Symfony Profiler

[
  "route" => "exposition_translation_division_passage"
  "route_parameters" => [
    "_route" => "exposition_translation_division_passage"
    "_controller" => "NCBS\WebsiteBundle\Controller\ExpositionController::translationDivisionPassage"
    "_locale" => "hr"
    "translationUrl" => "summaries-in-exposition-of-apocalypse-chadwick"
    "divisionUrls" => "contents"
    "passageNumber" => "20"
  ]
  "request_uri" => "https://update.newchristianbiblestudy.org/hr/exposition/translation/summaries-in-exposition-of-apocalypse-chadwick/contents/20"
  "method" => "GET"
]

[
  "firewall_name" => "main"
  "authenticators" => 0
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\DebugHandlersListener::configure"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\UX\Turbo\Request\RequestListener::__invoke"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ValidateRequestListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Bridge\Doctrine\Middleware\IdleConnection\Listener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleListener::setDefaultLocale"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\AssetMapper\AssetMapperDevServerSubscriber::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::configureLogoutUrlGenerator"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelRequest"
]

[
  "event" => "kernel.controller"
  "listener" => "Symfony\Bundle\FrameworkBundle\DataCollector\RouterDataCollector::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelController"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\Security\Http\EventListener\IsCsrfTokenValidAttributeListener::onKernelControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\Security\Http\EventListener\IsGrantedAttributeListener::onKernelControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\HttpKernel\EventListener\CacheAttributeListener::onKernelControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\HttpKernel\Controller\ArgumentResolver\RequestPayloadValueResolver::onKernelControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ErrorListener::onControllerArguments"
]

[
  "params" => [
    "driver" => "pdo_pgsql"
    "idle_connection_ttl" => 600
    "host" => "127.0.0.1"
    "port" => 5432
    "user" => "skymark"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => []
    "dbname" => "ncbsw"
    "serverVersion" => "16"
    "charset" => "utf8"
  ]
]

[
  "sql" => "SELECT id FROM language WHERE shortcode = 'hr' limit 1"
]

[
  "sql" => """
    SELECT MAX(sl.datemod)\n
    \t\t\t\tFROM ui_string_language sl\n
    \t\t\t\tJOIN ui_string s ON s.id = sl.ui_string_id\n
    \t\t\t\tWHERE sl.language_id IN (181, 123)\n
    \t\t\t\tAND s.is_active AND s.type_id IN (1, 3)
    """
]

[
  "sql" => """
    SELECT DISTINCT s.name,\n
    \t\t\t\t\t\t\t\tCASE WHEN sl2.id IS NULL THEN sl.text ELSE sl2.text END AS text,\n
    \t\t\t\t\t\t\t\ts.fix_quote\n
    \t\t\t\t\t\tFROM (SELECT * FROM ui_string_language WHERE language_id = 123) sl\n
    \t\t\t\t\t\tJOIN ui_string s ON s.id = sl.ui_string_id\n
    \t\t\t\t\t\tLEFT JOIN (SELECT * FROM ui_string_language\n
    \t\t\t\t\t\t\t\t\tWHERE language_id = 181\n
    \t\t\t\t\t\t\t\t\tAND text IS NOT NULL AND text <> '') sl2\n
    \t\t\t\t\t\tON s.id = sl2.ui_string_id\n
    \t\t\t\t\t\tWHERE s.is_active AND s.type_id IN (1, 3)
    """
]

[
  "sql" => "select t.id from expositiontranslation t WHERE t.url = 'summaries-in-exposition-of-apocalypse-chadwick' and  (t.ispublic and not t.restricted_access) "
]

[
  "sql" => "SELECT t.id FROM expositionwork w, expositiontranslation t where t.url = 'summaries-in-exposition-of-apocalypse-chadwick' and w.id = t.work_id and w.swedenborgtype is not null"
]

[
  "sql" => "SELECT t0.id AS id_1, t0.translatedtitle AS translatedtitle_2, t0.name AS name_3, t0.description AS description_4, t0.url AS url_5, t0.ispublic AS ispublic_6, t0.audience AS audience_7, t0.isoriginal AS isoriginal_8, t0.islanguagedefault AS islanguagedefault_9, t0.type_id AS type_id_10, t0.translationmethod_id AS translationmethod_id_11, t0.public_file AS public_file_12, t0.doc_link AS doc_link_13, t0.work_id AS work_id_14, t0.language_id AS language_id_15 FROM expositiontranslation t0 WHERE t0.url = ? AND t0.ispublic = ? LIMIT 1"
  "params" => [
    1 => "summaries-in-exposition-of-apocalypse-chadwick"
    2 => 1
  ]
  "types" => [
    1 => 2
    2 => 5
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.sitedefault AS sitedefault_2, t0.name AS name_3, t0.frenchname AS frenchname_4, t0.nativename AS nativename_5, t0.bibliographiccode AS bibliographiccode_6, t0.terminologiccode AS terminologiccode_7, t0.shortcode AS shortcode_8, t0.righttoleft AS righttoleft_9, t0.searchlibrary AS searchlibrary_10 FROM language t0 WHERE t0.id = ?"
  "params" => [
    1 => 123
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.title AS title_2, t0.fulltitle AS fulltitle_3, t0.description AS description_4, t0.url AS url_5, t0.ispublic AS ispublic_6, t0.audience AS audience_7, t0.swedenborgtype AS swedenborgtype_8 FROM expositionwork t0 WHERE t0.id = ?"
  "params" => [
    1 => 52
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.ordering AS ordering_4, t0.work_id AS work_id_5, t0.superdivision_id AS superdivision_id_6 FROM expositiondivision t0 WHERE t0.work_id = ? AND t0.url = ? LIMIT 1"
  "params" => [
    1 => 52
    2 => "contents"
  ]
  "types" => [
    1 => 1
    2 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.ordering AS ordering_2, t0.title AS title_3, t0.swedenborgsection AS swedenborgsection_4, t0.division_id AS division_id_5 FROM expositionpassage t0 WHERE t0.division_id = ? AND t0.ordering = ? LIMIT 1"
  "params" => [
    1 => 7
    2 => "20"
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "select case when w.swedenborgtype is null then false else true end as sw from expositionwork w, expositiontranslation t where t.id = 12 and t.work_id = w.id"
]

[
  "sql" => "SELECT text_style_override  FROM language WHERE id = 123"
]

[
  "sql" => "SELECT 'bible_' || t.url || '_' || cb.url || '_' || cc.ordering as link_spec, (case when t.language_id in (select language_id from expositiontranslation where id = 12) then 2 else case when t.language_id = 123 then 3 else 4 end end) as priority_order, cb.url as book_url, t.url as trans_url, cc.ordering as chapter_order  FROM canonicalbibleverse cv, canonicalbiblechapter cc, canonicalbiblebook cb, biblebook b, bibletranslation t WHERE (cv.id in (select verse_id from verse_passage where passage_id = 31 and iscorepassage) or cc.id in (select chapter_id from chapter_passage where passage_id = 31) ) and cv.chapter_id = cc.id and cc.book_id = cb.id and b.canonicalization_id = cb.id and b.translation_id = t.id and  (t.enabled and not t.restricted_access)  order by priority_order asc, t.languagedefault desc limit 1"
]

[
  "sql" => "select di1.text as footnote, array_to_string(array_agg(di3.text order by di3.tu_order, di3.ordering),' ') as footnote_text from expositiondisplayitem di1, (select di2.text, di2.ordering, di2.containingitem_id, tu.ordering as tu_order from expositiondisplayitem di2, expositiontranslationtext tt, expositiontextunit tu where tu.passage_id = 31 and tt.translation_id = 12 and tu.id = tt.placement_id and di2.container_id = tt.id order by di2.ordering) as di3 where di3.containingitem_id = di1.id group by di1.text"
]

[
  "sql" => "select * from (SELECT distinct on (di.ref_id) di.ref_id, 'bible_' || t.url || '_' || cb.url || '_' || cc1.ordering || (case when cc1.id <> cc2.id then '-' || cc2.ordering else '' end) || '_' || cv1.ordering || (case when rb.startverse_id <> rb.endverse_id then '-' || cv2.ordering else '' end) as multilink, true as is_bibleref, 1 as section_order, (case when t.language_id in (select language_id from expositiontranslation where id = 12) then 1 else case when t.language_id = 123 then 2 else 3 end end ) as priority_order, cb.url as book_url, t.url as trans_url, cc1.ordering as chapter_order1, cc2.ordering as chapter_order2, cv1.ordering as verse_order1, cv2.ordering as verse_order2, t.url as div_url, 0 as passage_order FROM refbible rb, expositiontextunit tu, expositiontranslationtext tt, expositiondisplayitem di, canonicalbibleverse cv1, canonicalbiblechapter cc1, canonicalbiblebook cb, canonicalbibleverse cv2, canonicalbiblechapter cc2, biblebook b, bibletranslation t  WHERE tu.passage_id = 31 and tu.id = tt.placement_id and rb.container_id = di.ref_id and di.container_id = tt.id and di.ref_id is not null and cv1.id = rb.startverse_id and cv1.chapter_id = cc1.id and cc1.book_id = cb.id and cv2.id = rb.endverse_id and cv2.chapter_id = cc2.id and b.canonicalization_id = cb.id and b.translation_id = t.id and  (t.enabled and not t.restricted_access)  order by di.ref_id, priority_order asc, t.languagedefault desc) as b union select * from (SELECT distinct on (di.ref_id) di.ref_id, (case when w.swedenborgtype is not null then 'swedenborg' else 'explanation' end) || '_' || t.url || (case when p.swedenborgsection is not null then '_' || p.swedenborgsection else '' end) as multilink, false as is_bibleref, t2.ordering as section_order,  (case when t.id = 12 then 1 else case when t.language_id in (select language_id from expositiontranslation where id = 12) then 2 else case when t.language_id = 123 then 3 else 4 end end end) as priority_order, t.url as book_url, t.url as trans_url, 0 as chapter_order1, 0 as chapter_order2, 0 as verse_order1, 0 as verse_order2, d.url as div_url, p.ordering as passage_order FROM refexposition re, expositiontextunit tu, expositiontextunit t2, expositionpassage p, expositiondivision d, expositiontranslationtext tt, expositiondisplayitem di, expositionwork w, expositiontranslation t WHERE tu.passage_id = 31 and t2.id = re.startlocation_id and p.id = t2.passage_id and d.id = p.division_id and re.container_id = di.ref_id and tu.id = tt.placement_id and di.container_id = tt.id and di.ref_id is not null and d.work_id = w.id and w.id = t.work_id and t.url is not null and  (t.ispublic and not t.restricted_access)  and w.ispublic order by di.ref_id, priority_order asc, t.islanguagedefault desc, t.isoriginal desc) as e"
]

[
  "sql" => "select tt.toc_text, wt.startpassage_id, p.swedenborgsection as startpassagenum, p2.swedenborgsection as endpassagenum, t.url as translation_url, d.url as division_url, p.ordering as startpassageorder, p2.ordering as endpassageorder, (case when w.swedenborgtype is not null then 'swedenborg' else 'explanation' end) || '_' || t.url || (case when p.swedenborgsection is not null then '_' || p.swedenborgsection else '' end) as link_spec from expositiontranslationtoc tt, expositionwork w, expositiontranslation t, expositiondivision d, expositionpassage p, expositionworktoc wt left join expositionpassage p2 on wt.endpassage_id = p2.id where tt.translation_id = 12 and tt.worktoc_id = wt.id and wt.startpassage_id = p.id and tt.translation_id = t.id and p.division_id = d.id and t.work_id = w.id order by p.ordering limit 1"
]

[
  "sql" => """
    select array_to_string(array_agg(DISTINCT id), ',') from (SELECT distinct on (w.id) t.id FROM expositionwork w, expositiontranslation t, expositionpassage p, expositiondivision d WHERE  p.id in (select ps.id\n
    FROM refexposition re, textunit_combinedreference tc, expositiontextunit ts, expositiontextunit t1, expositiontextunit t2, expositionpassage ps, expositiondivision d1, expositiondivision da, expositionpassage p1, expositionpassage p2, expositionpassage pa WHERE ts.passage_id = ps.id and ts.id = tc.textunit_id and re.container_id = tc.combinedreference_id and t1.id = re.startlocation_id and t2.id = re.endlocation_id and t1.passage_id = p1.id and t2.passage_id = p2.id and p1.division_id = d1.id and pa.id = 31 and pa.division_id = da.id and da.work_id = d1.work_id and pa.ordering >= p1.ordering and pa.ordering <= p2.ordering) and w.swedenborgtype  is not null and t.work_id=w.id and d.work_id = w.id and p.division_id = d.id and t.language_id in ( 123,123) and  (t.ispublic and not t.restricted_access)  and w.ispublic and t.url is not null and t.url <> '' AND t.type_id = 1 order by w.id,  (case when t.id = 12 then 1 else 2 end), t.islanguagedefault desc limit 1 ) as t
    """
]

[
  "sql" => """
    select array_to_string(array_agg(DISTINCT id), ',') from (SELECT distinct on (w.id) t.id FROM expositionwork w, expositiontranslation t, expositionpassage p, expositiondivision d WHERE  p.id in (select ps.id\n
    FROM refexposition re, textunit_combinedreference tc, expositiontextunit ts, expositiontextunit t1, expositiontextunit t2, expositionpassage ps, expositiondivision d1, expositiondivision da, expositionpassage p1, expositionpassage p2, expositionpassage pa WHERE ts.passage_id = ps.id and ts.id = tc.textunit_id and re.container_id = tc.combinedreference_id and t1.id = re.startlocation_id and t2.id = re.endlocation_id and t1.passage_id = p1.id and t2.passage_id = p2.id and p1.division_id = d1.id and pa.id = 31 and pa.division_id = da.id and da.work_id = d1.work_id and pa.ordering >= p1.ordering and pa.ordering <= p2.ordering) and w.swedenborgtype  is null and t.work_id=w.id and d.work_id = w.id and p.division_id = d.id and t.language_id in ( 123,123) and  (t.ispublic and not t.restricted_access)  and w.ispublic and t.url is not null and t.url <> '' AND t.type_id = 1 order by w.id, t.islanguagedefault desc limit 1) as t
    """
]

[
  "sql" => "SELECT distinct r.id, r.publicfile, r.title, case when r.searchsummary is not null then r.searchsummary else r.description end as searchsummary, rt.image_file as type_icon, case when rt.description is null then '' else rt.description || ' | ' end || case when r.minaudienceage is null and r.maxaudienceage is null then 'All Ages ' else case when r.minaudienceage is not null or r.maxaudienceage is not null then 'Ages ' else '' end end || case when r.minaudienceage is null and r.maxaudienceage is not null then 'up to ' else case when r.minaudienceage is not null and r.maxaudienceage is null then 'over ' else '' end end || case when r.minaudienceage is null then '' else r.minaudienceage || '' end || case when r.minaudienceage is not null and r.maxaudienceage is not null then ' - ' else '' end || case when r.maxaudienceage is null then '' else '' || r.maxaudienceage end as otherinfo FROM resource_workref rw, resource r left join resourcetype rt on r.resourcetype_id = rt.id WHERE rw.passage_id = 31 and r.id = rw.resource_id and r.publish order by r.title limit 1"
]

[
  "sql" => "SELECT distinct on (s.id) s.id, s.title, e.description, e.youtube_id, sr.time, s.showtype_id, e.location, case when e.youtube_id is null then 2 else 1 end as video_order, null as chapter_order, null as start_verse, null as end_verse FROM show s, embed e, show_workref sr WHERE sr.passage_id = 31 and s.id = sr.show_id and e.visibilitydefault and s.embed_id = e.id and s.showtype_id <> 18 order by s.id desc, sr.time limit 1"
]

[
  "sql" => "select * from (SELECT distinct on (p.id) p.id, w.swedenborgtype, t.translatedtitle AS title, (case when p.swedenborgsection is not null then p.swedenborgsection else cast(p.ordering as text) end) as num, (case when w.swedenborgtype is not null then 'swedenborg' else 'explanation' end) || '_' || t.url || (case when p.swedenborgsection is not null then '_' || p.swedenborgsection else '' end) as link_spec, t.url as translation_url, d.url as division_url, w.ordering as work_order, p.ordering, case when t.language_id = 123 then 1 else 2 end as lang_order FROM expositionwork w, expositiontranslation t, expositionpassage p, expositiondivision d WHERE  p.id in (select distinct passage_id2 from relatedpassage WHERE passage_id1 = 31 union select distinct passage_id1 from relatedpassage WHERE passage_id2 = 31) and t.work_id=w.id and d.work_id = w.id and p.division_id = d.id and t.id in (SELECT distinct on (w.id) t.id FROM expositionwork w, expositiontranslation t, expositionpassage p, expositiondivision d WHERE  p.id in (select distinct passage_id2 from relatedpassage WHERE passage_id1 = 31 union select distinct passage_id1 from relatedpassage WHERE passage_id2 = 31) and t.work_id=w.id and d.work_id = w.id and p.division_id = d.id and t.id in (SELECT distinct on (w.id) t.id FROM expositionwork w, expositiontranslation t, expositionpassage p, expositiondivision d WHERE  p.id in (select distinct passage_id2 from relatedpassage WHERE passage_id1 = 31 union select distinct passage_id1 from relatedpassage WHERE passage_id2 = 31) and t.work_id=w.id and d.work_id = w.id and p.division_id = d.id and t.language_id in ( 123,123) and  (t.ispublic and not t.restricted_access)  and w.ispublic and t.url is not null and t.url <> '' AND t.type_id = 1 order by w.id, t.islanguagedefault desc)) order by p.id, lang_order limit 1) as t2 order by work_order, title, ordering"
]

[
  "sql" => "SELECT t0.id AS id_1, t0.ordering AS ordering_2, t0.subsection AS subsection_3, t0.passage_id AS passage_id_4 FROM expositiontextunit t0 WHERE t0.passage_id = ? ORDER BY t0.ordering ASC"
  "params" => [
    1 => 31
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.text AS text_2, t0.textvector AS textvector_3, t0.translation_id AS translation_id_4, t0.placement_id AS placement_id_5 FROM expositiontranslationtext t0 WHERE t0.placement_id = ?"
  "params" => [
    1 => 31
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "select tt.toc_text, wt.startpassage_id, p.swedenborgsection as startpassagenum, p2.swedenborgsection as endpassagenum, t.url as translation_url, d.url as division_url, p.ordering as startpassageorder, p2.ordering as endpassageorder, (case when w.swedenborgtype is not null then 'swedenborg' else 'explanation' end) || '_' || t.url || (case when p.swedenborgsection is not null then '_' || p.swedenborgsection else '' end) as link_spec from expositiontranslationtoc tt, expositionwork w, expositiontranslation t, expositiondivision d, expositionpassage p, expositionworktoc wt left join expositionpassage p2 on wt.endpassage_id = p2.id where tt.translation_id = 12 and tt.worktoc_id = wt.id and wt.startpassage_id = p.id and tt.translation_id = t.id and p.division_id = d.id and t.work_id = w.id order by p.ordering limit 1"
]

[
  "sql" => "SELECT credit, sourcelink from bibliographicdata b, translation_bibliographicdata tb WHERE tb.translation_id = 12 and tb.bibliographicdata_id = b.id and sourcelink is not null and credit is not null"
]

[
  "sql" => "SELECT t.name, t.translatedtitle, (case when b.datecreated is null then '' else ' (' || b.datecreated || ')' end) as datestr, w.title as work_title, t.isoriginal, t.language_id FROM language l, expositionwork w, expositiontranslation t left join (select tb.translation_id, b.datecreated from bibliographicdata b, translation_bibliographicdata tb where b.id = tb.bibliographicdata_id) as b on t.id = b.translation_id WHERE t.id = 12 and t.work_id = w.id and t.language_id = l.id"
]

[
  "sql" => "select text from ui_string_language where ui_string_id = 469 and language_id = 123"
]

[
  "sql" => "SELECT w.book_id FROM expositionwork w, expositiontranslation t where t.id = 12 and t.work_id = w.id limit 1"
]

[
  "sql" => "select bs.level_id, sw.story_id from story_work sw, biblestory bs, expositiontranslation t where t.id = 12 and t.work_id = sw.work_id and sw.story_id = bs.id order by bs.level_id limit 1"
]

[
  "sql" => "SELECT cl.concept_id FROM work_category wc, concept_work cl, expositiontranslation t WHERE t.id = 12  and wc.category_id = 12 and wc.work_id = t.work_id and cl.work_id = t.work_id"
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.url AS url_4, t0.indexpage AS indexpage_5 FROM expositioncategory t0 INNER JOIN work_category ON t0.id = work_category.category_id WHERE work_category.work_id = ?"
  "params" => [
    1 => 52
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.url AS url_4, t0.indexpage AS indexpage_5 FROM expositioncategory t0 INNER JOIN translation_category ON t0.id = translation_category.category_id WHERE translation_category.translation_id = ?"
  "params" => [
    1 => 12
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT p.id, t.url as translation_url, d.url as division_url,  (case when p.swedenborgsection is not null then p.swedenborgsection else cast(p.ordering as text) end) as passage_num, p.ordering as passage_order, (case when w.swedenborgtype is not null then 'swedenborg' else 'explanation' end) || '_' || t.url || (case when p.swedenborgsection is not null then '_' || p.swedenborgsection else '_' || p.ordering end) as multi_spec  FROM expositionpassage p, expositiondivision d, expositiontranslationtext tt, expositiontextunit tu, expositiontranslation t, expositionwork w WHERE d.work_id = 52 and p.division_id = d.id and p.ordering < 20 and tt.translation_id=12 and tt.placement_id = tu.id and tu.passage_id = p.id and t.id = tt.translation_id and d.work_id = w.id order by p.ordering desc limit 1"
]

[
  "sql" => "SELECT p.id, t.url as translation_url, d.url as division_url, (case when p.swedenborgsection is not null then p.swedenborgsection else cast(p.ordering as text) end) as passage_num, p.ordering as passage_order, (case when w.swedenborgtype is not null then 'swedenborg' else 'explanation' end) || '_' || t.url || (case when p.swedenborgsection is not null then '_' || p.swedenborgsection else '_' || p.ordering end) as multi_spec  FROM expositionpassage p, expositiondivision d, expositiontranslationtext tt, expositiontextunit tu, expositiontranslation t, expositionwork w WHERE d.work_id = 52 and p.division_id = d.id and p.ordering > 20 and tt.translation_id=12 and tt.placement_id = tu.id and tu.passage_id = p.id and t.id = tt.translation_id and d.work_id = w.id order by p.ordering limit 1"
]

[
  "sql" => "select array_to_string(array_agg(d.text ORDER BY tu.ordering, d.ordering),'') as content from expositiontranslationtext tt, expositiontextunit tu, expositiondisplayitem d where tu.passage_id = 31 and tt.translation_id = 12 and tu.id = tt.placement_id and d.container_id = tt.id"
]

[
  "sql" => "SELECT lower(l.shortcode) AS shortcode, (CASE WHEN l.nativename IS NOT NULL AND l.nativename <> '' THEN l.nativename ELSE l.name END) AS name FROM language l INNER JOIN languageforui lui ON lui.language_id = l.id WHERE l.shortcode IS NOT NULL AND l.shortcode <> '' ORDER BY name"
]

[
  "sql" => "SELECT t0.id AS id_1, t0.translatedtitle AS translatedtitle_2, t0.name AS name_3, t0.description AS description_4, t0.url AS url_5, t0.ispublic AS ispublic_6, t0.audience AS audience_7, t0.isoriginal AS isoriginal_8, t0.islanguagedefault AS islanguagedefault_9, t0.type_id AS type_id_10, t0.translationmethod_id AS translationmethod_id_11, t0.public_file AS public_file_12, t0.doc_link AS doc_link_13, t0.work_id AS work_id_14, t0.language_id AS language_id_15 FROM expositiontranslation t0 WHERE t0.work_id = ?"
  "params" => [
    1 => 52
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.ordering AS ordering_4, t0.work_id AS work_id_5, t0.superdivision_id AS superdivision_id_6 FROM expositiondivision t0 WHERE t0.work_id = ? ORDER BY t0.ordering ASC"
  "params" => [
    1 => 52
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.ordering AS ordering_2, t0.title AS title_3, t0.swedenborgsection AS swedenborgsection_4, t0.division_id AS division_id_5 FROM expositionpassage t0 WHERE t0.division_id = ? ORDER BY t0.ordering ASC"
  "params" => [
    1 => 7
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.ispublic AS ispublic_4, t0.level_id AS level_id_5, t0.startverse_id AS startverse_id_6, t0.endverse_id AS endverse_id_7, t0.chapter_id AS chapter_id_8 FROM biblestory t0 INNER JOIN story_work ON t0.id = story_work.story_id WHERE story_work.work_id = ?"
  "params" => [
    1 => 52
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.ordering AS ordering_2, t0.passage_id AS passage_id_3, t0.embed_id AS embed_id_4 FROM passage_media t0 WHERE t0.passage_id = ? ORDER BY t0.ordering ASC"
  "params" => [
    1 => 31
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.recordnumber AS recordnumber_2, t0.file AS file_3, t0.title AS title_4, t0.description AS description_5, t0.author AS author_6, t0.credit AS credit_7, t0.link AS link_8, t0.date AS date_9, t0.license AS license_10, t0.width AS width_11, t0.height AS height_12, t0.language_id AS language_id_13, t0.mediatype_id AS mediatype_id_14 FROM image t0 INNER JOIN textunit_image ON t0.id = textunit_image.image_id WHERE textunit_image.textunit_id = ?"
  "params" => [
    1 => 31
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.ordering AS ordering_2, t0.flags AS flags_3, t0.searchable AS searchable_4, t0.text AS text_5, t0.type_id AS type_id_6, t0.container_id AS container_id_7, t0.containingitem_id AS containingitem_id_8, t0.ref_id AS ref_id_9, t0.image_id AS image_id_10, t0.embed_id AS embed_id_11 FROM expositiondisplayitem t0 WHERE t0.container_id = ? ORDER BY t0.ordering ASC"
  "params" => [
    1 => 1277898
  ]
  "types" => [
    1 => 1
  ]
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\AssetMapper\AssetMapperDevServerSubscriber::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\Security\Csrf\SameOriginCsrfTokenManager::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\Security\Http\Firewall\ContextListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ResponseListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\WebLink\EventListener\AddLinkHeaderListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\CacheAttributeListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ProfilerListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ErrorListener::removeCspHeader"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Bundle\WebProfilerBundle\EventListener\WebDebugToolbarListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\DisallowRobotsIndexingListener::onResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelResponse"
]

[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelFinishRequest"
]

[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelFinishRequest"
]

[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelFinishRequest"
]

[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelFinishRequest"
]