Log Messages
Info. & Errors 2
Informational and error log messages generated during the execution of the application.
Level | Channel | Message |
---|---|---|
INFO 18:29:52 | request |
Matched route "bible_chapter" .
[ "route" => "bible_chapter" "route_parameters" => [ "_controller" => "NCBS\WebsiteBundle\Controller\BibleController::chapterAction" "_locale" => "ka" "translationUrl" => "spanish-reina-valera-1909" "bookUrl" => "hebrews" "chapterIndex" => "1" "_route" => "bible_chapter" ] "request_uri" => "https://dv285zceyyjcw5t4.newchristianbiblestudy.org/app_dev.php/ka/bible/spanish-reina-valera-1909/hebrews/1/" "method" => "GET" ] |
INFO 18:29:52 | security | Populated the TokenStorage with an anonymous Token. |
Deprecations 9
Log messages generated by using features marked as deprecated.
Debug 102
Unimportant log messages generated during the execution of the application.
Time | Channel | Message |
---|---|---|
18:29:52 | event |
Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\DebugHandlersListener::configure" .
[ "event" => "kernel.request" "listener" => "Symfony\Component\HttpKernel\EventListener\DebugHandlersListener::configure" ] |
18:29:52 | event |
Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\ValidateRequestListener::onKernelRequest" .
[ "event" => "kernel.request" "listener" => "Symfony\Component\HttpKernel\EventListener\ValidateRequestListener::onKernelRequest" ] |
18:29:52 | event |
Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelRequest" .
[ "event" => "kernel.request" "listener" => "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelRequest" ] |
18:29:52 | event |
Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelRequest" .
[ "event" => "kernel.request" "listener" => "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelRequest" ] |
18:29:52 | event |
Notified event "kernel.request" to listener "Symfony\Bundle\FrameworkBundle\EventListener\ResolveControllerNameSubscriber::onKernelRequest" .
[ "event" => "kernel.request" "listener" => "Symfony\Bundle\FrameworkBundle\EventListener\ResolveControllerNameSubscriber::onKernelRequest" ] |
18:29:52 | event |
Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelRequest" .
[ "event" => "kernel.request" "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelRequest" ] |
18:29:52 | event |
Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\TranslatorListener::onKernelRequest" .
[ "event" => "kernel.request" "listener" => "Symfony\Component\HttpKernel\EventListener\TranslatorListener::onKernelRequest" ] |
18:29:52 | event |
Notified event "kernel.request" to listener "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelRequest" .
[ "event" => "kernel.request" "listener" => "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelRequest" ] |
18:29:52 | event |
Notified event "kernel.request" to listener "Symfony\Bundle\AsseticBundle\EventListener\RequestListener::onKernelRequest" .
[ "event" => "kernel.request" "listener" => "Symfony\Bundle\AsseticBundle\EventListener\RequestListener::onKernelRequest" ] |
18:29:52 | event |
Notified event "kernel.controller" to listener "Symfony\Bundle\FrameworkBundle\DataCollector\RouterDataCollector::onKernelController" .
[ "event" => "kernel.controller" "listener" => "Symfony\Bundle\FrameworkBundle\DataCollector\RouterDataCollector::onKernelController" ] |
18:29:52 | event |
Notified event "kernel.controller" to listener "Symfony\Bundle\FrameworkBundle\DataCollector\RequestDataCollector::onKernelController" .
[ "event" => "kernel.controller" "listener" => "Symfony\Bundle\FrameworkBundle\DataCollector\RequestDataCollector::onKernelController" ] |
18:29:52 | event |
Notified event "kernel.controller" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\ControllerListener::onKernelController" .
[ "event" => "kernel.controller" "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\ControllerListener::onKernelController" ] |
18:29:52 | event |
Notified event "kernel.controller" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\ParamConverterListener::onKernelController" .
[ "event" => "kernel.controller" "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\ParamConverterListener::onKernelController" ] |
18:29:52 | event |
Notified event "kernel.controller" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\HttpCacheListener::onKernelController" .
[ "event" => "kernel.controller" "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\HttpCacheListener::onKernelController" ] |
18:29:52 | event |
Notified event "kernel.controller" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\SecurityListener::onKernelController" .
[ "event" => "kernel.controller" "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\SecurityListener::onKernelController" ] |
18:29:52 | event |
Notified event "kernel.controller" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\TemplateListener::onKernelController" .
[ "event" => "kernel.controller" "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\TemplateListener::onKernelController" ] |
18:29:52 | doctrine | SELECT id FROM language WHERE shortcode = 'ka' limit 1 |
18:29:52 | doctrine | SELECT max(sl.datemod) FROM ui_string_language sl, ui_string s WHERE sl.language_id in (149, 123) and s.id = sl.ui_string_id and s.is_active and s.type_id in (1, 3) |
18:29:52 | doctrine | SELECT distinct s.name, case when sl2.id is null then sl.text else sl2.text end as text, s.fix_quote FROM (select * from ui_string_language where language_id = 123) sl, ui_string s left join (select * from ui_string_language where language_id = 149 and text is not null and text <> '') sl2 on s.id = sl2.ui_string_id where s.id = sl.ui_string_id and s.is_active and s.type_id in (1, 3) |
18:29:52 | doctrine | select language_id from bibletranslation where url = 'spanish-reina-valera-1909' |
18:29:52 | doctrine |
SELECT t0.id AS id_1, t0.languageDefault AS languagedefault_2, t0.name AS name_3, t0.abbreviation AS abbreviation_4, t0.copyright AS copyright_5, t0.notice AS notice_6, t0.license AS license_7, t0.url AS url_8, t0.enabled AS enabled_9, t0.language_id AS language_id_10 FROM bibletranslation t0 WHERE t0.url = ? AND t0.enabled = ? LIMIT 1
[ "spanish-reina-valera-1909" true ] |
18:29:52 | doctrine |
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 = ?
[
401
]
|
18:29:52 | doctrine |
SELECT b0_.id AS id_0, b0_.ordering AS ordering_1, b0_.name AS name_2, b0_.url AS url_3, b1_.id AS id_4, b1_.languageDefault AS languagedefault_5, b1_.name AS name_6, b1_.abbreviation AS abbreviation_7, b1_.copyright AS copyright_8, b1_.notice AS notice_9, b1_.license AS license_10, b1_.url AS url_11, b1_.enabled AS enabled_12, c2_.id AS id_13, c2_.ordering AS ordering_14, c2_.name AS name_15, c2_.url AS url_16, c2_.apocryphal AS apocryphal_17, c2_.deuterocanonical AS deuterocanonical_18, b0_.translation_id AS translation_id_19, b0_.canonicalization_id AS canonicalization_id_20, b1_.language_id AS language_id_21, c2_.testament_id AS testament_id_22 FROM biblebook b0_ INNER JOIN bibletranslation b1_ ON b0_.translation_id = b1_.id INNER JOIN canonicalbiblebook c2_ ON b0_.canonicalization_id = c2_.id INNER JOIN language l3_ ON b1_.language_id = l3_.id WHERE c2_.url = ? AND b0_.translation_id = ? ORDER BY b0_.ordering ASC
[ "hebrews" 25 ] |
18:29:52 | doctrine |
SELECT t0.id AS id_1, t0.ordering AS ordering_2, t0.book_id AS book_id_3 FROM biblechapter t0 WHERE t0.book_id = ? AND t0.ordering = ? LIMIT 1
[ 1207 "1" ] |
18:29:52 | doctrine |
SELECT t0.id AS id_1, t0.ordering AS ordering_2, t0.name AS name_3, t0.url AS url_4, t0.apocryphal AS apocryphal_5, t0.deuterocanonical AS deuterocanonical_6, t0.testament_id AS testament_id_7 FROM canonicalbiblebook t0 WHERE t0.url = ? LIMIT 1
[
"hebrews"
]
|
18:29:52 | doctrine |
SELECT t0.id AS id_1, t0.indexDisplay AS indexdisplay_2, t0.ordering AS ordering_3, t0.content AS content_4, t0.contentVector AS contentvector_5, t0.chapter_id AS chapter_id_6, t0.verse_id AS verse_id_7 FROM bibleverse t0 WHERE t0.chapter_id = ? ORDER BY t0.ordering ASC
[
20422
]
|
18:29:52 | doctrine |
SELECT t0.id AS id_1, t0.languageDefault AS languagedefault_2, t0.name AS name_3, t0.abbreviation AS abbreviation_4, t0.copyright AS copyright_5, t0.notice AS notice_6, t0.license AS license_7, t0.url AS url_8, t0.enabled AS enabled_9, t0.language_id AS language_id_10 FROM bibletranslation t0 WHERE t0.url = ? AND t0.enabled = ? LIMIT 1
[ "spanish-reina-valera-1909" true ] |
18:29:52 | doctrine | select show_bible_chapter_summary from language where id = 401 |
18:29:52 | doctrine |
SELECT t0.id AS id_1, t0.ordering AS ordering_2, t0.book_id AS book_id_3 FROM canonicalbiblechapter t0 WHERE t0.book_id = ? ORDER BY t0.ordering ASC
[
78
]
|
18:29:52 | doctrine | select id from language where shortcode = 'ka' |
18:29:52 | doctrine | select language_id from bibletranslation where url = 'spanish-reina-valera-1909' |
18:29:52 | doctrine | select show_bible_chapter_summary from language where id = 401 |
18:29:52 | doctrine | SELECT bs.chapter_id, t.id as translation_id, t.url, t.is_modern, t.translatedtitle as explanationtitle, case when t.language_id = 401 then 2 else case when t.language_id = 149 then 3 else case when t.language_id = 123 then 5 else 6 end end end as lang_order FROM expositionwork w, expositiontranslation t, expositiontranslationtext tt, story_work sw, biblestory bs WHERE bs.chapter_id = 985 and sw.story_id = bs.id and w.id = sw.work_id and t.work_id=w.id and t.id = tt.translation_id and tt.text is not null and tt.text <> '' and (t.language_id in (401,149,123)) and w.ispublic AND t.ispublic order by lang_order, t.is_modern desc, t.islanguagedefault desc limit 1 |
18:29:52 | doctrine | SELECT b.id, b.name, cb.id as canonical_id, cb.url as canonical_book_url, case when cb.testament_id = 1 then 'ძველი აღთქმა.' else case when cb.testament_id = 2 then 'ახალი აღთქმა.' else case when cb.testament_id = 3 then 'აპოკრიფები.' end end end as testament_name, t.url as translation_url, min(c.ordering) as first_chapter_order, cb.testament_id FROM biblebook b, biblechapter c, canonicalbiblebook cb, bibletranslation t WHERE b.translation_id = 25 and b.canonicalization_id = cb.id and t.id = b.translation_id and c.book_id = b.id group by b.id, b.name, cb.id, cb.url, testament_name, t.url order by cb.testament_id, cb.id |
18:29:52 | doctrine | SELECT c.id, t.url as translation_url, cb.url as book_url, c.ordering as chapter_order, 'bible' || '_' || t.url || '_' || cb.url || '_' || c.ordering as chapter_multi_spec, b.name as book_name FROM bibletranslation t, biblebook b, biblechapter c, canonicalbiblebook cb WHERE c.book_id in (select book_id from biblechapter where id = 20422) and c.ordering > (select ordering from biblechapter where id = 20422) and c.book_id = b.id and b.canonicalization_id = cb.id and b.translation_id = t.id order by c.ordering limit 1 |
18:29:52 | doctrine | SELECT c.id, t.url as translation_url, cb.url as book_url, c.ordering as chapter_order, 'bible' || '_' || t.url || '_' || cb.url || '_' || c.ordering as chapter_multi_spec, b.name as book_name FROM bibletranslation t, biblebook b, biblechapter c, canonicalbiblebook cb WHERE c.book_id in (select book_id from biblechapter where id = 20422) and c.ordering < (select ordering from biblechapter where id = 20422) and c.book_id = b.id and b.canonicalization_id = cb.id and b.translation_id = t.id order by c.ordering desc limit 1 |
18:29:52 | doctrine | SELECT c.id, t.url as translation_url, cb.url as book_url, c.ordering as chapter_order, 'bible' || '_' || t.url || '_' || cb.url || '_' || c.ordering as chapter_multi_spec, b.name as book_name FROM bibletranslation t, biblebook b, biblechapter c, canonicalbiblebook cb WHERE c.book_id = 1208 and c.book_id = b.id and b.canonicalization_id = cb.id and b.translation_id = t.id order by c.ordering desc limit 1 |
18:29:52 | doctrine | SELECT credit from bibletranslation WHERE url = 'spanish-reina-valera-1909' |
18:29:52 | doctrine | select t.language_id, l.bibliographiccode, c.book_id, b.translation_id, v.chapter_id from bibleverse v, biblechapter c, biblebook b, bibletranslation t, language l where v.id = 545171 and v.chapter_id = c.id and c.book_id = b.id and b.translation_id = t.id and t.language_id = l.id |
18:29:52 | doctrine | select string_agg(distinct cv.id::text, ',') as cverse_ids, string_agg(distinct cc.id::text, ',') as cchapter_ids, string_agg(distinct cc.ordering::text, ',' order by cc.ordering::text) as cchapter_orders from canonicalbibleverse cv, canonicalbiblechapter cc, canonicalbiblebook cb, bibleverse v, (select * from canonicalbibleverse_bibleverse where bibleverse_id in (545171,545170,545169,545168,545167,545166,545165,545164,545163,545162,545161,545160,545159,545158)) as cvv where v.id in (545171,545170,545169,545168,545167,545166,545165,545164,545163,545162,545161,545160,545159,545158) and v.id = cvv.bibleverse_id and cv.id = cvv.canonicalbibleverse_id and cv.chapter_id = cc.id |
18:29:52 | doctrine | select array_to_string(array_agg(distinct chapter_id), ',') from canonicalbibleverse where id in (24275,24276,24277,24278,24279,24280,24281,24282,24283,24284,24285,24286,24287,24288) |
18:29:52 | doctrine | select array_to_string(array_agg(id), ',') from canonicalbiblechapter where id in (985) and id not in (select distinct chapter_id from canonicalbibleverse where chapter_id in (985) and id not in (24275,24276,24277,24278,24279,24280,24281,24282,24283,24284,24285,24286,24287,24288)) |
18:29:52 | doctrine | select * from (SELECT distinct on (p.id) p.id, w.swedenborgtype, t.translatedtitle AS title, p.swedenborgsection as num, 'swedenborg' || '_' || t.url || (case when p.swedenborgsection is not null then '_' || p.swedenborgsection else '' end) as ref_column_spec, t.url as translation_url, d.url as division_url, w.ordering as work_order, p.ordering, case when t.language_id = 401 then 1 else 2 end as lang_order FROM expositionwork w, expositiontranslation t, expositionpassage p, expositiondivision d WHERE p.id in (SELECT DISTINCT passage_id FROM verse_passage WHERE verse_id in (24275,24276,24277,24278,24279,24280,24281,24282,24283,24284,24285,24286,24287,24288)) and p.id not in (SELECT DISTINCT passage_id FROM chapter_passage WHERE chapter_id in (985,985) union SELECT DISTINCT passage_id FROM verse_passage WHERE verse_id in (24275,24276,24277,24278,24279,24280,24281,24282,24283,24284,24285,24286,24287,24288) and iscorepassage) 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.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_id FROM verse_passage WHERE verse_id in (24275,24276,24277,24278,24279,24280,24281,24282,24283,24284,24285,24286,24287,24288)) and p.id not in (SELECT DISTINCT passage_id FROM chapter_passage WHERE chapter_id in (985,985) union SELECT DISTINCT passage_id FROM verse_passage WHERE verse_id in (24275,24276,24277,24278,24279,24280,24281,24282,24283,24284,24285,24286,24287,24288) and iscorepassage) and t.work_id=w.id and d.work_id = w.id and p.division_id = d.id and t.language_id in ( 401,123) and t.ispublic 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) order by p.id, lang_order) as t2 order by work_order, title, ordering |
18:29:52 | doctrine | SELECT chapter_id, min(ordering) as min_order, max(ordering) as max_order from canonicalbibleverse WHERE id in (24275,24276,24277,24278,24279,24280,24281,24282,24283,24284,24285,24286,24287,24288) group by chapter_id |
18:29:52 | doctrine | select * from (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, cc.ordering as chapter_order, cb1.ordering as start_verse, cb2.ordering as end_verse, case when e.youtube_id is null then 2 else 1 end as video_order1 FROM show s, embed e, show_bibleref sr left join canonicalbibleverse as cb1 on from_verse_id = cb1.id left join canonicalbibleverse as cb2 on to_verse_id = cb2.id left join canonicalbiblechapter as cc on sr.chapter_id = cc.id WHERE ( (sr.chapter_id in (985))) and s.id = sr.show_id and e.visibilitydefault and s.embed_id = e.id limit 1) as t order by video_order1 |
18:29:52 | doctrine | select t.language_id, l.bibliographiccode, c.book_id, b.translation_id, v.chapter_id from bibleverse v, biblechapter c, biblebook b, bibletranslation t, language l where v.id = 545171 and v.chapter_id = c.id and c.book_id = b.id and b.translation_id = t.id and t.language_id = l.id |
18:29:52 | doctrine | select show_bible_verse_highlights from language where id = 401 |
18:29:52 | doctrine | select * from (SELECT distinct on (verse_id, term_text) * from (select cbb.bibleverse_id as verse_id, t.id as term_id, lower(t.text) as term_text, c.url as concept_url, char_length(t.text) as text_len, ct.translatedtitle as title, ct.explanation_id, c.id as concept_id FROM verse_concept vc, term_concept tc, term t, concept c, (select * from canonicalbibleverse_bibleverse where bibleverse_id in (545171,545170,545169,545168,545167,545166,545165,545164,545163,545162,545161,545160,545159,545158)) as cbb, bibleverse bv, (select distinct on (cl.concept_id) cl.concept_id, trans.translatedtitle, trans.id as explanation_id, case when trans.language_id = 401 then 1 else 2 end as ordering from concept_work cl, expositiontranslation trans where trans.language_id in (401, 123) and cl.work_id = trans.work_id order by cl.concept_id, ordering) as ct WHERE cbb.canonicalbibleverse_id = vc.verse_id and tc.concept_id = vc.concept_id and t.id = tc.term_id and c.id = tc.concept_id and t.language_id = 401 and ct.concept_id = c.id and cbb.bibleverse_id = bv.id and case when t.text is not null and (bv.content ~* ('\y' || replace(replace(replace(replace(t.text, ')', '\)'), '(', '\('), ']', '\]'), '[', '\[') || '\y')) then true else false end order by cbb.bibleverse_id, lower(t.text), term_id) as t1) as t order by verse_id, char_length(term_text) desc |
18:29:52 | doctrine |
SELECT t0.id AS id_1, t0.ordering AS ordering_2, t0.chapter_id AS chapter_id_3 FROM canonicalbibleverse t0 INNER JOIN canonicalbibleverse_bibleverse ON t0.id = canonicalbibleverse_bibleverse.canonicalbibleverse_id WHERE canonicalbibleverse_bibleverse.bibleverse_id = ?
[
545171
]
|
18:29:52 | doctrine |
SELECT t0.id AS id_1, t0.ordering AS ordering_2, t0.chapter_id AS chapter_id_3 FROM canonicalbibleverse t0 INNER JOIN canonicalbibleverse_bibleverse ON t0.id = canonicalbibleverse_bibleverse.canonicalbibleverse_id WHERE canonicalbibleverse_bibleverse.bibleverse_id = ?
[
545170
]
|
18:29:52 | doctrine |
SELECT t0.id AS id_1, t0.ordering AS ordering_2, t0.chapter_id AS chapter_id_3 FROM canonicalbibleverse t0 INNER JOIN canonicalbibleverse_bibleverse ON t0.id = canonicalbibleverse_bibleverse.canonicalbibleverse_id WHERE canonicalbibleverse_bibleverse.bibleverse_id = ?
[
545169
]
|
18:29:52 | doctrine |
SELECT t0.id AS id_1, t0.ordering AS ordering_2, t0.chapter_id AS chapter_id_3 FROM canonicalbibleverse t0 INNER JOIN canonicalbibleverse_bibleverse ON t0.id = canonicalbibleverse_bibleverse.canonicalbibleverse_id WHERE canonicalbibleverse_bibleverse.bibleverse_id = ?
[
545168
]
|
18:29:52 | doctrine |
SELECT t0.id AS id_1, t0.ordering AS ordering_2, t0.chapter_id AS chapter_id_3 FROM canonicalbibleverse t0 INNER JOIN canonicalbibleverse_bibleverse ON t0.id = canonicalbibleverse_bibleverse.canonicalbibleverse_id WHERE canonicalbibleverse_bibleverse.bibleverse_id = ?
[
545167
]
|
18:29:52 | doctrine |
SELECT t0.id AS id_1, t0.ordering AS ordering_2, t0.chapter_id AS chapter_id_3 FROM canonicalbibleverse t0 INNER JOIN canonicalbibleverse_bibleverse ON t0.id = canonicalbibleverse_bibleverse.canonicalbibleverse_id WHERE canonicalbibleverse_bibleverse.bibleverse_id = ?
[
545166
]
|
18:29:52 | doctrine |
SELECT t0.id AS id_1, t0.ordering AS ordering_2, t0.chapter_id AS chapter_id_3 FROM canonicalbibleverse t0 INNER JOIN canonicalbibleverse_bibleverse ON t0.id = canonicalbibleverse_bibleverse.canonicalbibleverse_id WHERE canonicalbibleverse_bibleverse.bibleverse_id = ?
[
545165
]
|
18:29:52 | doctrine |
SELECT t0.id AS id_1, t0.ordering AS ordering_2, t0.chapter_id AS chapter_id_3 FROM canonicalbibleverse t0 INNER JOIN canonicalbibleverse_bibleverse ON t0.id = canonicalbibleverse_bibleverse.canonicalbibleverse_id WHERE canonicalbibleverse_bibleverse.bibleverse_id = ?
[
545164
]
|
18:29:52 | doctrine |
SELECT t0.id AS id_1, t0.ordering AS ordering_2, t0.chapter_id AS chapter_id_3 FROM canonicalbibleverse t0 INNER JOIN canonicalbibleverse_bibleverse ON t0.id = canonicalbibleverse_bibleverse.canonicalbibleverse_id WHERE canonicalbibleverse_bibleverse.bibleverse_id = ?
[
545163
]
|
18:29:52 | doctrine |
SELECT t0.id AS id_1, t0.ordering AS ordering_2, t0.chapter_id AS chapter_id_3 FROM canonicalbibleverse t0 INNER JOIN canonicalbibleverse_bibleverse ON t0.id = canonicalbibleverse_bibleverse.canonicalbibleverse_id WHERE canonicalbibleverse_bibleverse.bibleverse_id = ?
[
545162
]
|
18:29:52 | doctrine |
SELECT t0.id AS id_1, t0.ordering AS ordering_2, t0.chapter_id AS chapter_id_3 FROM canonicalbibleverse t0 INNER JOIN canonicalbibleverse_bibleverse ON t0.id = canonicalbibleverse_bibleverse.canonicalbibleverse_id WHERE canonicalbibleverse_bibleverse.bibleverse_id = ?
[
545161
]
|
18:29:52 | doctrine |
SELECT t0.id AS id_1, t0.ordering AS ordering_2, t0.chapter_id AS chapter_id_3 FROM canonicalbibleverse t0 INNER JOIN canonicalbibleverse_bibleverse ON t0.id = canonicalbibleverse_bibleverse.canonicalbibleverse_id WHERE canonicalbibleverse_bibleverse.bibleverse_id = ?
[
545160
]
|
18:29:52 | doctrine |
SELECT t0.id AS id_1, t0.ordering AS ordering_2, t0.chapter_id AS chapter_id_3 FROM canonicalbibleverse t0 INNER JOIN canonicalbibleverse_bibleverse ON t0.id = canonicalbibleverse_bibleverse.canonicalbibleverse_id WHERE canonicalbibleverse_bibleverse.bibleverse_id = ?
[
545159
]
|
18:29:52 | doctrine |
SELECT t0.id AS id_1, t0.ordering AS ordering_2, t0.chapter_id AS chapter_id_3 FROM canonicalbibleverse t0 INNER JOIN canonicalbibleverse_bibleverse ON t0.id = canonicalbibleverse_bibleverse.canonicalbibleverse_id WHERE canonicalbibleverse_bibleverse.bibleverse_id = ?
[
545158
]
|
18:29:52 | doctrine |
SELECT t0.id AS id_1, t0.ordering AS ordering_2, t0.chapter_id AS chapter_id_3 FROM canonicalbibleverse t0 WHERE t0.chapter_id = ? ORDER BY t0.ordering ASC
[
985
]
|
18:29:52 | doctrine | select show_bible_verse_highlights from language where id = 401 |
18:29:52 | doctrine | SELECT id FROM language WHERE shortcode = 'ka' limit 1 |
18:29:52 | doctrine | SELECT t.id, (case when l.nativename is not null and l.nativename <> '' then l.nativename else l.name end) as language_name, t.name as name, t.url, bk.url as first_book_url, (case when l.nativename is not null and l.nativename <> '' then l.nativename else l.name end) as group_name, (case when language_id = 149 then 1 else case when language_id = 123 then 2 else 3 end end) as group_order, true as has_book, true as has_chapter, l.righttoleft FROM language l, bibletranslation t join ( select distinct on (t2.id) t2.id as translation_id, cb.url from bibletranslation t2, biblebook b, canonicalbiblebook cb where b.translation_id = t2.id and cb.id = b.canonicalization_id order by t2.id, b.ordering) as bk on t.id = bk.translation_id WHERE t.enabled and t.language_id = l.id and t.id in (select distinct translation_id from biblebook b3, biblechapter c3, bibleverse v3 where b3.canonicalization_id = 78 and c3.book_id = b3.id and c3.ordering = 1 and v3.chapter_id = c3.id and v3.indexdisplay = '1') and t.id in (select distinct translation_id from biblebook b3, biblechapter c3, bibleverse v3 where b3.canonicalization_id = 78 and c3.book_id = b3.id and c3.ordering = 1 and v3.chapter_id = c3.id and v3.indexdisplay = '14') order by group_order, language_name, t.name |
18:29:52 | doctrine | SELECT 'http://qbible.com/greek-new-testament/' || qbible_url || '/' || '1' || '.html#' || '1' as url from canonicalbiblebook WHERE id = 78 and qbible_url is not null and qbible_url <> '' |
18:29:52 | doctrine | SELECT r.title as name, ('/bundles/ncbsw/resource/publicfile/' || r.publicfile) as public_file, 1 as ordering from resource r, resource_bibleref rb, canonicalbiblechapter cc WHERE rb.book_id = 78 and r.publicfile like 'dbsn%' and r.id = rb.resource_id and cc.id = rb.chapter_id and cc.ordering = 1 and r.publish union SELECT name, ('/bundles/ncbsw/translation/' || public_file) as public_file, 2 as ordering from expositiontranslation WHERE id in (select translation_id from expositiontranslationref where book_id = 78) and type_id = 2 and ispublic and public_file is not null order by ordering, name |
18:29:52 | doctrine | SELECT l.text_style_override FROM language l, bibletranslation bt, biblebook b WHERE b.id = 1207 and b.translation_id = bt.id and l.id = bt.language_id |
18:29:52 | doctrine | SELECT t.name FROM texttospeech t, texttospeechlanguage tl WHERE tl.language_id = 401 and t.id = tl.tts_id order by tl.is_standard desc limit 1 |
18:29:52 | doctrine | select shortcode, (case when nativename is not null and nativename <> '' then nativename else name end) as name FROM language where shortcode in ('en','sq','bg','zh','hr','cs','nl','fr','ka','de','hi','it','ja','ko','la','mk','ml','me','pt','ru','sr','es','sv','tl','uk','zu') |
18:29:52 | doctrine |
SELECT t0.id AS id_1, t0.indexDisplay AS indexdisplay_2, t0.ordering AS ordering_3, t0.content AS content_4, t0.contentVector AS contentvector_5, t0.chapter_id AS chapter_id_6, t0.verse_id AS verse_id_7 FROM bibleverse t0 WHERE t0.chapter_id = ? ORDER BY t0.ordering ASC
[
20422
]
|
18:29:52 | doctrine |
SELECT t0.id AS id_1, t0.indexDisplay AS indexdisplay_2, t0.ordering AS ordering_3, t0.content AS content_4, t0.contentVector AS contentvector_5, t0.chapter_id AS chapter_id_6, t0.verse_id AS verse_id_7 FROM bibleverse t0 WHERE t0.verse_id = ? ORDER BY t0.ordering ASC
[
545171
]
|
18:29:52 | doctrine |
SELECT t0.id AS id_1, t0.indexDisplay AS indexdisplay_2, t0.ordering AS ordering_3, t0.content AS content_4, t0.contentVector AS contentvector_5, t0.chapter_id AS chapter_id_6, t0.verse_id AS verse_id_7 FROM bibleverse t0 WHERE t0.verse_id = ? ORDER BY t0.ordering ASC
[
545170
]
|
18:29:52 | doctrine |
SELECT t0.id AS id_1, t0.indexDisplay AS indexdisplay_2, t0.ordering AS ordering_3, t0.content AS content_4, t0.contentVector AS contentvector_5, t0.chapter_id AS chapter_id_6, t0.verse_id AS verse_id_7 FROM bibleverse t0 WHERE t0.verse_id = ? ORDER BY t0.ordering ASC
[
545169
]
|
18:29:52 | doctrine |
SELECT t0.id AS id_1, t0.indexDisplay AS indexdisplay_2, t0.ordering AS ordering_3, t0.content AS content_4, t0.contentVector AS contentvector_5, t0.chapter_id AS chapter_id_6, t0.verse_id AS verse_id_7 FROM bibleverse t0 WHERE t0.verse_id = ? ORDER BY t0.ordering ASC
[
545168
]
|
18:29:52 | doctrine |
SELECT t0.id AS id_1, t0.indexDisplay AS indexdisplay_2, t0.ordering AS ordering_3, t0.content AS content_4, t0.contentVector AS contentvector_5, t0.chapter_id AS chapter_id_6, t0.verse_id AS verse_id_7 FROM bibleverse t0 WHERE t0.verse_id = ? ORDER BY t0.ordering ASC
[
545167
]
|
18:29:52 | doctrine |
SELECT t0.id AS id_1, t0.indexDisplay AS indexdisplay_2, t0.ordering AS ordering_3, t0.content AS content_4, t0.contentVector AS contentvector_5, t0.chapter_id AS chapter_id_6, t0.verse_id AS verse_id_7 FROM bibleverse t0 WHERE t0.verse_id = ? ORDER BY t0.ordering ASC
[
545166
]
|
18:29:52 | doctrine |
SELECT t0.id AS id_1, t0.indexDisplay AS indexdisplay_2, t0.ordering AS ordering_3, t0.content AS content_4, t0.contentVector AS contentvector_5, t0.chapter_id AS chapter_id_6, t0.verse_id AS verse_id_7 FROM bibleverse t0 WHERE t0.verse_id = ? ORDER BY t0.ordering ASC
[
545165
]
|
18:29:52 | doctrine |
SELECT t0.id AS id_1, t0.indexDisplay AS indexdisplay_2, t0.ordering AS ordering_3, t0.content AS content_4, t0.contentVector AS contentvector_5, t0.chapter_id AS chapter_id_6, t0.verse_id AS verse_id_7 FROM bibleverse t0 WHERE t0.verse_id = ? ORDER BY t0.ordering ASC
[
545164
]
|
18:29:52 | doctrine |
SELECT t0.id AS id_1, t0.indexDisplay AS indexdisplay_2, t0.ordering AS ordering_3, t0.content AS content_4, t0.contentVector AS contentvector_5, t0.chapter_id AS chapter_id_6, t0.verse_id AS verse_id_7 FROM bibleverse t0 WHERE t0.verse_id = ? ORDER BY t0.ordering ASC
[
545163
]
|
18:29:52 | doctrine |
SELECT t0.id AS id_1, t0.indexDisplay AS indexdisplay_2, t0.ordering AS ordering_3, t0.content AS content_4, t0.contentVector AS contentvector_5, t0.chapter_id AS chapter_id_6, t0.verse_id AS verse_id_7 FROM bibleverse t0 WHERE t0.verse_id = ? ORDER BY t0.ordering ASC
[
545162
]
|
18:29:52 | doctrine |
SELECT t0.id AS id_1, t0.indexDisplay AS indexdisplay_2, t0.ordering AS ordering_3, t0.content AS content_4, t0.contentVector AS contentvector_5, t0.chapter_id AS chapter_id_6, t0.verse_id AS verse_id_7 FROM bibleverse t0 WHERE t0.verse_id = ? ORDER BY t0.ordering ASC
[
545161
]
|
18:29:52 | doctrine |
SELECT t0.id AS id_1, t0.indexDisplay AS indexdisplay_2, t0.ordering AS ordering_3, t0.content AS content_4, t0.contentVector AS contentvector_5, t0.chapter_id AS chapter_id_6, t0.verse_id AS verse_id_7 FROM bibleverse t0 WHERE t0.verse_id = ? ORDER BY t0.ordering ASC
[
545160
]
|
18:29:52 | doctrine |
SELECT t0.id AS id_1, t0.indexDisplay AS indexdisplay_2, t0.ordering AS ordering_3, t0.content AS content_4, t0.contentVector AS contentvector_5, t0.chapter_id AS chapter_id_6, t0.verse_id AS verse_id_7 FROM bibleverse t0 WHERE t0.verse_id = ? ORDER BY t0.ordering ASC
[
545159
]
|
18:29:52 | doctrine |
SELECT t0.id AS id_1, t0.indexDisplay AS indexdisplay_2, t0.ordering AS ordering_3, t0.content AS content_4, t0.contentVector AS contentvector_5, t0.chapter_id AS chapter_id_6, t0.verse_id AS verse_id_7 FROM bibleverse t0 WHERE t0.verse_id = ? ORDER BY t0.ordering ASC
[
545158
]
|
18:29:52 | event |
Notified event "kernel.response" to listener "JMS\I18nRoutingBundle\EventListener\CookieSettingListener::onKernelResponse" .
[ "event" => "kernel.response" "listener" => "JMS\I18nRoutingBundle\EventListener\CookieSettingListener::onKernelResponse" ] |
18:29:52 | event |
Notified event "kernel.response" to listener "Symfony\Bridge\Monolog\Handler\FirePHPHandler::onKernelResponse" .
[ "event" => "kernel.response" "listener" => "Symfony\Bridge\Monolog\Handler\FirePHPHandler::onKernelResponse" ] |
18:29:52 | event |
Notified event "kernel.response" to listener "Symfony\Component\HttpKernel\EventListener\ResponseListener::onKernelResponse" .
[ "event" => "kernel.response" "listener" => "Symfony\Component\HttpKernel\EventListener\ResponseListener::onKernelResponse" ] |
18:29:52 | event |
Notified event "kernel.response" to listener "Symfony\Bundle\FrameworkBundle\DataCollector\RequestDataCollector::onKernelResponse" .
[ "event" => "kernel.response" "listener" => "Symfony\Bundle\FrameworkBundle\DataCollector\RequestDataCollector::onKernelResponse" ] |
18:29:52 | event |
Notified event "kernel.response" to listener "Symfony\Component\Security\Http\RememberMe\ResponseListener::onKernelResponse" .
[ "event" => "kernel.response" "listener" => "Symfony\Component\Security\Http\RememberMe\ResponseListener::onKernelResponse" ] |
18:29:52 | event |
Notified event "kernel.response" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\HttpCacheListener::onKernelResponse" .
[ "event" => "kernel.response" "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\HttpCacheListener::onKernelResponse" ] |
18:29:52 | event |
Notified event "kernel.response" to listener "Symfony\Component\HttpKernel\EventListener\ProfilerListener::onKernelResponse" .
[ "event" => "kernel.response" "listener" => "Symfony\Component\HttpKernel\EventListener\ProfilerListener::onKernelResponse" ] |
18:29:52 | event |
Notified event "kernel.response" to listener "Symfony\Bundle\WebProfilerBundle\EventListener\WebDebugToolbarListener::onKernelResponse" .
[ "event" => "kernel.response" "listener" => "Symfony\Bundle\WebProfilerBundle\EventListener\WebDebugToolbarListener::onKernelResponse" ] |
18:29:52 | event |
Notified event "kernel.response" to listener "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelResponse" .
[ "event" => "kernel.response" "listener" => "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelResponse" ] |
18:29:52 | event |
Notified event "kernel.response" to listener "Symfony\Component\HttpKernel\EventListener\SaveSessionListener::onKernelResponse" .
[ "event" => "kernel.response" "listener" => "Symfony\Component\HttpKernel\EventListener\SaveSessionListener::onKernelResponse" ] |
18:29:52 | event |
Notified event "kernel.response" to listener "Symfony\Component\HttpKernel\EventListener\StreamedResponseListener::onKernelResponse" .
[ "event" => "kernel.response" "listener" => "Symfony\Component\HttpKernel\EventListener\StreamedResponseListener::onKernelResponse" ] |
18:29:52 | event |
Notified event "kernel.finish_request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelFinishRequest" .
[ "event" => "kernel.finish_request" "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelFinishRequest" ] |
18:29:52 | event |
Notified event "kernel.finish_request" to listener "Symfony\Component\HttpKernel\EventListener\SessionListener::onFinishRequest" .
[ "event" => "kernel.finish_request" "listener" => "Symfony\Component\HttpKernel\EventListener\SessionListener::onFinishRequest" ] |
18:29:52 | event |
Notified event "kernel.finish_request" to listener "Symfony\Component\HttpKernel\EventListener\TranslatorListener::onKernelFinishRequest" .
[ "event" => "kernel.finish_request" "listener" => "Symfony\Component\HttpKernel\EventListener\TranslatorListener::onKernelFinishRequest" ] |
18:29:52 | event |
Notified event "kernel.finish_request" to listener "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelFinishRequest" .
[ "event" => "kernel.finish_request" "listener" => "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelFinishRequest" ] |
18:29:52 | event |
Notified event "kernel.finish_request" to listener "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelFinishRequest" .
[ "event" => "kernel.finish_request" "listener" => "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelFinishRequest" ] |
PHP Notices 0
Log messages generated by PHP notices silenced with the @ operator.
There are no log messages of this level.
Container 835
Log messages generated during the compilation of the service container.
Class | Messages |
---|---|
Symfony\Component\DependencyInjection\Compiler\ResolveChildDefinitionsPass
|
78 |
Symfony\Component\DependencyInjection\Compiler\RemovePrivateAliasesPass
|
86 |
Symfony\Component\DependencyInjection\Compiler\ReplaceAliasByActualDefinitionPass
|
98 |
Symfony\Component\DependencyInjection\Compiler\RemoveAbstractDefinitionsPass
|
97 |
Symfony\Component\DependencyInjection\Compiler\InlineServiceDefinitionsPass
|
215 |
Symfony\Component\DependencyInjection\Compiler\RemoveUnusedDefinitionsPass
|
259 |
Symfony\Bundle\FrameworkBundle\DependencyInjection\Compiler\UnusedTagsPass
|
2 |