Query Metrics
147
Database Queries
82
Different statements
568.24 ms
Query time
0
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 1.63 ms |
SELECT id FROM language WHERE shortcode = 'ml' limit 1
Parameters:
[] |
2 | 7.88 ms |
SELECT max(sl.datemod) FROM ui_string_language sl, ui_string s WHERE sl.language_id in (268, 123) and s.id = sl.ui_string_id and s.is_active and s.type_id in (1, 3)
Parameters:
[] |
3 | 9.97 ms |
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 = 268 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)
Parameters:
[] |
4 | 0.93 ms |
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 = ? AND t0.type_id = ? LIMIT 1
Parameters:
[ "inner-meaning-of-luke-14-sr" 1 1 ] |
5 | 0.55 ms |
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 = ?
Parameters:
[
11314
]
|
6 | 0.60 ms |
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
Parameters:
[
11314
]
|
7 | 0.20 ms |
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.superdivision_id = ? ORDER BY t0.ordering ASC
Parameters:
[
10581
]
|
8 | 0.42 ms |
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
Parameters:
[
10581
]
|
9 | 0.39 ms |
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
Parameters:
[
48244
]
|
10 | 11.43 ms |
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 = ?
Parameters:
[
86866
]
|
11 | 0.22 ms |
select translationmethod_id from expositiontranslation where id = 63700
Parameters:
[] |
12 | 0.41 ms |
select t2.id from expositiontranslation t1, expositiontranslation t2 where t1.id = 63700 and t1.work_id = t2.work_id and t2.isoriginal order by case when t2.language_id = 123 then 1 else 2 end
Parameters:
[] |
13 | 1.43 ms |
SELECT array_to_string(array_agg( (CASE WHEN p.name is not null then p.name else (case when p.title is null then '' else p.title || ' ' end) || (case when p.firstname is null then '' else p.firstname || ' ' end) || (case when p.middlename is null then '' else p.middlename || ' ' end) || (case when p.lastname is null then '' else p.lastname || ' ' end) || (case when p.suffix is null then '' else p.suffix || ' ' end) end) ), ', ') as authors FROM translation_bibliographicdata tbg, bibliographicdata_person bp, person p WHERE tbg.translation_id = 63465 and tbg.bibliographicdata_id = bp.bibliographicdata_id and bp.person_id = p.id
Parameters:
[] |
14 | 0.44 ms |
select (case when l.nativename is not null and l.nativename <> '' then l.nativename else l.name end) as language_name from expositiontranslation t, language l where t.id = 63700 and l.id = t.language_id
Parameters:
[] |
15 | 0.86 ms |
SELECT c.url FROM expositionwork w, work_category wc, concept_work cl, expositiontranslation t, concept c WHERE w.id = 11314 and wc.work_id = w.id and t.work_id = w.id and cl.work_id = w.id and c.id = cl.concept_id and wc.category_id = 12
Parameters:
[] |
16 | 0.65 ms |
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 = ?
Parameters:
[
11314
]
|
17 | 0.37 ms |
SELECT text_style_override FROM language WHERE id = 404
Parameters:
[] |
18 | 0.45 ms |
SELECT t.name FROM texttospeech t, texttospeechlanguage tl WHERE tl.language_id = 404 and t.id = tl.tts_id order by tl.is_standard desc limit 1
Parameters:
[] |
19 | 1.36 ms |
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 = 11314 and p.division_id = d.id and p.ordering < 1 and tt.translation_id=63700 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
Parameters:
[] |
20 | 1.02 ms |
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 = 11314 and p.division_id = d.id and p.ordering > 1 and tt.translation_id=63700 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
Parameters:
[] |
21 | 1.00 ms |
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 = 63700 and t.work_id = w.id and t.language_id = l.id
Parameters:
[] |
22 | 0.16 ms |
select text from ui_string_language where ui_string_id = 469 and language_id = 404
Parameters:
[] |
23 | 0.14 ms |
select language_id from expositiontranslation where id = 63700
Parameters:
[] |
24 | 1.99 ms |
select array_to_string(array_agg(DISTINCT d.ref_id),',') as ref from expositiontextunit t, expositiontranslationtext tt, expositiondisplayitem d where t.passage_id = 48244 and tt.translation_id = 63700 and t.id = tt.placement_id and d.container_id = tt.id and d.type_id = 2
Parameters:
[] |
25 | 68.11 ms |
select t3.* from (select * from (SELECT distinct on (tc.textunit_id, rc.id) tc.textunit_id, rc.id as ref_id, rc.originallinktext as link_text, cc1.book_id, rb.startverse_id as startloc_id, rb.endverse_id as endloc_id, true as is_bibleref, 'bible_' || trans.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_text, cc1.ordering as ordering1, cv1.ordering as ordering2, (case when trans.language_id = 404 then 2 else case when trans.language_id = 123 then case when trans.languagedefault then 3 else 4 end end end) as priority_order, cb.url as book_url, trans.url as trans_url, cc1.ordering as chapter_order1, cc2.ordering as chapter_order2, cv1.ordering as verse_order1, cv2.ordering as verse_order2, trans.url as div_url, 0 as passage_order FROM refbible rb, refcombined rc, textunit_combinedreference tc, expositiontextunit t, canonicalbibleverse cv1, canonicalbiblechapter cc1, canonicalbiblebook cb, canonicalbibleverse_bibleverse cbb1, bibleverse v1, biblechapter c1, canonicalbibleverse cv2, canonicalbiblechapter cc2, biblebook b, bibletranslation trans WHERE t.passage_id = 48244 and t.id = tc.textunit_id and rc.id = tc.combinedreference_id and rc.id not in (437,464,594,1112,2203,3453,3543,5352,9338,12285,12471,14754,15542,15650,17845,19951,20049,20797,22382,23112,24615,39354,39355,43788,45778,59675,65533,65539,65540,65543,65546,65547,65548,65551,65552,65553,65555,65557,65560,96440,97297,97611,98517,98628,99055,107571,108512,116866,117164,118961,119217,122122,122123,122126,147035,148271,148272,148274,148275,148276) and rb.container_id = rc.id and cv1.id = rb.startverse_id and cv1.chapter_id = cc1.id and cc1.book_id = cb.id and cv1.id = cbb1.canonicalbibleverse_id and v1.id = cbb1.bibleverse_id and v1.chapter_id = c1.id and c1.book_id = b.id and cv2.id = rb.endverse_id and cv2.chapter_id = cc2.id and b.translation_id = trans.id and trans.enabled order by tc.textunit_id, rc.id, priority_order asc, trans.languagedefault desc) as b union select * from (SELECT distinct on (tc.textunit_id, rc.id) tc.textunit_id, rc.id as ref_id, rc.originallinktext as link_text, d.work_id as book_id, re.startlocation_id as startloc_id, re.endlocation_id as endloc_id, false as is_bibleref, (case when w.swedenborgtype is not null then 'swedenborg_' else 'explanation_' end) || trans.url || (case when p.swedenborgsection is not null then '_' || p.swedenborgsection else '' end) as multilink_text, p.ordering as ordering1, t2.ordering as ordering2, (case when trans.id = 63700 then 1 else case when trans.language_id = 404 then 2 else case when trans.language_id = 123 then case when trans.islanguagedefault then 3 else 4 end end end end) as priority_order, trans.url as book_url, trans.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, refcombined rc, textunit_combinedreference tc, expositiontextunit t, expositiontextunit t2, expositionpassage p, expositiondivision d, expositionwork w, expositiontranslation trans, expositiontranslationtext tt WHERE t.passage_id = 48244 and t.id = tc.textunit_id and rc.id = tc.combinedreference_id and rc.id not in (437,464,594,1112,2203,3453,3543,5352,9338,12285,12471,14754,15542,15650,17845,19951,20049,20797,22382,23112,24615,39354,39355,43788,45778,59675,65533,65539,65540,65543,65546,65547,65548,65551,65552,65553,65555,65557,65560,96440,97297,97611,98517,98628,99055,107571,108512,116866,117164,118961,119217,122122,122123,122126,147035,148271,148272,148274,148275,148276) and re.container_id = rc.id and t2.id = re.startlocation_id and p.id = t2.passage_id and d.id = p.division_id and d.work_id = w.id and w.id = trans.work_id and trans.url is not null and trans.ispublic and w.ispublic and t2.id = tt.placement_id and trans.id = tt.translation_id order by tc.textunit_id, rc.id, priority_order asc, trans.islanguagedefault desc, trans.isoriginal desc) as e) as t3 order by split_part(link_text, ' ', 1), book_id, ordering1, ordering2
Parameters:
[] |
26 | 1.76 ms |
select di1.text as footnote, array_to_string(array_agg(di3.text order by di3.ordering),' ') as footnote_text from expositiondisplayitem di1, (select di2.* from expositiondisplayitem di2, expositiontranslationtext tt, expositiontextunit tu where tu.passage_id = 48244 and tt.translation_id = 63700 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
Parameters:
[] |
27 | 99.19 ms |
select * from (SELECT distinct on (di.ref_id) di.ref_id, 'bible_' || trans.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 trans.language_id in (select language_id from expositiontranslation where id = 63700) then 1 else case when trans.language_id = 123 then 2 else 3 end end ) as priority_order, cb.url as book_url, trans.url as trans_url, cc1.ordering as chapter_order1, cc2.ordering as chapter_order2, cv1.ordering as verse_order1, cv2.ordering as verse_order2, trans.url as div_url, 0 as passage_order FROM refbible rb, expositiontextunit t, expositiontranslationtext tt, expositiondisplayitem di, canonicalbibleverse cv1, canonicalbiblechapter cc1, canonicalbiblebook cb, canonicalbibleverse cv2, canonicalbiblechapter cc2, biblebook b, bibletranslation trans WHERE t.passage_id = 48244 and t.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 = trans.id and trans.enabled order by di.ref_id, priority_order asc, trans.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) || '_' || trans.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 trans.id = 63700 then 1 else case when trans.language_id in (select language_id from expositiontranslation where id = 63700) then 2 else case when trans.language_id = 123 then 3 else 4 end end end) as priority_order, trans.url as book_url, trans.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 t, expositiontextunit t2, expositionpassage p, expositiondivision d, expositiontranslationtext tt, expositiondisplayitem di, expositionwork w, expositiontranslation trans WHERE t.passage_id = 48244 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 t.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 = trans.work_id and trans.url is not null and trans.ispublic and w.ispublic order by di.ref_id, priority_order asc, trans.islanguagedefault desc, trans.isoriginal desc) as e
Parameters:
[] |
28 | 3.21 ms |
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 = 63700 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
Parameters:
[] |
29 | 0.87 ms |
SELECT c.id FROM biblebook b, biblechapter c, bibletranslation t, canonicalbiblebook cb WHERE t.url = 'serbian' and cb.url = 'luke' and c.ordering = 14 and b.canonicalization_id = cb.id and b.translation_id = t.id and c.book_id = b.id limit 1
Parameters:
[] |
30 | 2.77 ms |
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, t.url, l.righttoleft, b.id as book_id, b.name as book_name, cb.url as canonical_book_url, cc.id as chapter_id, l.id as language_id FROM language l, bibletranslation t, biblebook b, biblechapter c, canonicalbiblebook cb, canonicalbiblechapter cc where c.id = 127647 and c.book_id = b.id and b.canonicalization_id = cb.id and b.translation_id = t.id and t.enabled and t.language_id = l.id and cc.book_id = cb.id and cc.ordering = c.ordering limit 1
Parameters:
[] |
31 | 1.18 ms |
SELECT v.id FROM biblebook b, biblechapter c, bibletranslation t, bibleverse v, canonicalbiblebook cb WHERE t.url = 'serbian' and cb.url = 'luke' and b.canonicalization_id = cb.id and b.translation_id = t.id and c.book_id = b.id and v.chapter_id = c.id and c.ordering = 14 and v.indexdisplay = '31' order by c.ordering, v.indexdisplay limit 1
Parameters:
[] |
32 | 0.55 ms |
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.id = ? LIMIT 1
Parameters:
[
3393106
]
|
33 | 0.19 ms |
SELECT t0.id AS id_1, t0.ordering AS ordering_2, t0.book_id AS book_id_3 FROM biblechapter t0 WHERE t0.id = ?
Parameters:
[
127647
]
|
34 | 0.20 ms |
SELECT t0.id AS id_1, t0.ordering AS ordering_2, t0.name AS name_3, t0.url AS url_4, t0.translation_id AS translation_id_5, t0.canonicalization_id AS canonicalization_id_6 FROM biblebook t0 WHERE t0.id = ?
Parameters:
[
7341
]
|
35 | 0.30 ms |
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.id = ?
Parameters:
[
62
]
|
36 | 0.38 ms |
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
Parameters:
[
62
]
|
37 | 0.23 ms |
select id from language where shortcode = 'ml'
Parameters:
[] |
38 | 0.36 ms |
select language_id from bibletranslation where url = 'serbian'
Parameters:
[] |
39 | 0.14 ms |
select show_bible_chapter_summary from language where id = 404
Parameters:
[] |
40 | 3.43 ms |
SELECT bs.chapter_id, t.id as translation_id, t.url, t.is_modern, t.translatedtitle as explanationtitle, case when t.language_id = 404 then 2 else case when t.language_id = 268 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 = 1132 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 (404,268,123)) and w.ispublic AND t.ispublic order by lang_order, t.is_modern desc, t.islanguagedefault desc limit 1
Parameters:
[] |
41 | 1.35 ms |
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 = 127647) and c.ordering > (select ordering from biblechapter where id = 127647) and c.book_id = b.id and b.canonicalization_id = cb.id and b.translation_id = t.id order by c.ordering limit 1
Parameters:
[] |
42 | 1.42 ms |
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 = 127647) and c.ordering < (select ordering from biblechapter where id = 127647) 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
Parameters:
[] |
43 | 0.52 ms |
SELECT id FROM bibleverse WHERE verse_id = 3393106 and chapter_id in (select chapter_id from bibleverse where id = 3393106) and indexdisplay like '%-%' limit 1
Parameters:
[] |
44 | 5.65 ms |
SELECT c.id, t.url as translation_url, cb.url as book_url, c.ordering as chapter_order, (case when v2.indexdisplay is not null and v.indexdisplay not like '%-%' then v.indexdisplay else null end) as subverse_index, (case when v2.indexdisplay is not null then case when v.indexdisplay like '%-%' then v2.indexdisplay else v2.indexdisplay || v.indexdisplay end else v.indexdisplay end) as verse_label, (case when v2.indexdisplay is not null then v2.indexdisplay else v.indexdisplay end) as verse_index, v.id as verse_id, 'bible' || '_' || t.url || '_' || cb.url || '_' || c.ordering || '_' || (case when v2.indexdisplay is not null then v2.indexdisplay else '' end) || v.indexdisplay as verse_multi_spec, b.name as book_name FROM bibletranslation t, biblebook b, biblechapter c, canonicalbiblebook cb, bibleverse v left join bibleverse v2 on v.verse_id = v2.id WHERE c.book_id in (select book_id from biblechapter where id in (select chapter_id from bibleverse where id = 3393106)) and v.chapter_id = c.id and v.ordering > (select ordering from bibleverse where id = 3393106) and c.book_id = b.id and b.canonicalization_id = cb.id and b.translation_id = t.id and (v.verse_id is null or v.indexdisplay like '%-%') order by v.ordering limit 1
Parameters:
[] |
45 | 0.39 ms |
SELECT id FROM bibleverse WHERE verse_id = 3393106 and chapter_id in (select chapter_id from bibleverse where id = 3393106) and indexdisplay like '%-%' limit 1
Parameters:
[] |
46 | 4.41 ms |
SELECT c.id, t.url as translation_url, cb.url as book_url, c.ordering as chapter_order, (case when v2.indexdisplay is not null and v.indexdisplay not like '%-%' then v.indexdisplay else null end) as subverse_index, (case when v2.indexdisplay is not null then case when v.indexdisplay like '%-%' then v2.indexdisplay else v2.indexdisplay || v.indexdisplay end else v.indexdisplay end) as verse_label, (case when v2.indexdisplay is not null then v2.indexdisplay else v.indexdisplay end) as verse_index, v.id as verse_id, 'bible' || '_' || t.url || '_' || cb.url || '_' || c.ordering || '_' || (case when v2.indexdisplay is not null then v2.indexdisplay else '' end) || v.indexdisplay as verse_multi_spec, b.name as book_name FROM bibletranslation t, biblebook b, biblechapter c, canonicalbiblebook cb, bibleverse v left join bibleverse v2 on v.verse_id = v2.id WHERE c.book_id in (select book_id from biblechapter where id in (select chapter_id from bibleverse where id = 3393106)) and v.chapter_id = c.id and v.ordering < (select ordering from bibleverse where id = 3393106) and c.book_id = b.id and b.canonicalization_id = cb.id and b.translation_id = t.id and (v.verse_id is null or v.indexdisplay like '%-%') order by v.ordering desc limit 1
Parameters:
[] |
47 | 1.78 ms |
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, t.url, l.righttoleft, b.id as book_id, b.name as book_name, cb.url as canonical_book_url, case when l.id = 123 then 1 else 2 end as lang_ordering, case when t.languagedefault then 1 else 2 end as trans_ordering, l.id as language_id, t.abbreviation FROM language l, bibletranslation t, biblebook b, biblechapter c, canonicalbiblebook cb WHERE t.url = 'serbian' and c.book_id = b.id and b.canonicalization_id = cb.id and b.translation_id = t.id and t.enabled and t.language_id = l.id order by lang_ordering, trans_ordering limit 1
Parameters:
[] |
48 | 0.18 ms |
SELECT ordering FROM biblechapter WHERE book_id = 7341 and ordering = 14 limit 1
Parameters:
[] |
49 | 0.30 ms |
SELECT v.indexdisplay FROM bibleverse v, biblechapter c WHERE c.book_id = 7341 and c.ordering = 14 and v.chapter_id = c.id and v.indexdisplay = '31' limit 1
Parameters:
[] |
50 | 0.21 ms |
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 = ? ORDER BY t0.ordering ASC
Parameters:
[
7341
]
|
51 | 0.36 ms |
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
Parameters:
[
127647
]
|
52 | 0.20 ms |
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
Parameters:
[
3393076
]
|
53 | 0.18 ms |
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
Parameters:
[
3393077
]
|
54 | 0.17 ms |
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
Parameters:
[
3393078
]
|
55 | 0.18 ms |
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
Parameters:
[
3393079
]
|
56 | 0.17 ms |
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
Parameters:
[
3393080
]
|
57 | 0.17 ms |
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
Parameters:
[
3393081
]
|
58 | 0.16 ms |
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
Parameters:
[
3393082
]
|
59 | 0.16 ms |
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
Parameters:
[
3393083
]
|
60 | 0.16 ms |
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
Parameters:
[
3393084
]
|
61 | 0.17 ms |
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
Parameters:
[
3393085
]
|
62 | 0.20 ms |
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
Parameters:
[
3393086
]
|
63 | 0.20 ms |
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
Parameters:
[
3393087
]
|
64 | 0.16 ms |
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
Parameters:
[
3393088
]
|
65 | 0.15 ms |
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
Parameters:
[
3393089
]
|
66 | 0.15 ms |
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
Parameters:
[
3393090
]
|
67 | 0.15 ms |
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
Parameters:
[
3393091
]
|
68 | 0.15 ms |
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
Parameters:
[
3393092
]
|
69 | 0.15 ms |
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
Parameters:
[
3393093
]
|
70 | 0.15 ms |
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
Parameters:
[
3393094
]
|
71 | 0.16 ms |
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
Parameters:
[
3393095
]
|
72 | 0.16 ms |
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
Parameters:
[
3393096
]
|
73 | 0.14 ms |
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
Parameters:
[
3393097
]
|
74 | 0.17 ms |
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
Parameters:
[
3393098
]
|
75 | 0.17 ms |
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
Parameters:
[
3393099
]
|
76 | 0.15 ms |
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
Parameters:
[
3393100
]
|
77 | 0.17 ms |
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
Parameters:
[
3393101
]
|
78 | 0.16 ms |
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
Parameters:
[
3393102
]
|
79 | 0.18 ms |
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
Parameters:
[
3393103
]
|
80 | 0.18 ms |
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
Parameters:
[
3393104
]
|
81 | 0.18 ms |
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
Parameters:
[
3393105
]
|
82 | 0.16 ms |
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
Parameters:
[
3393106
]
|
83 | 0.89 ms |
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 = 3393106 and v.chapter_id = c.id and c.book_id = b.id and b.translation_id = t.id and t.language_id = l.id
Parameters:
[] |
84 | 1.12 ms |
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 (3393106)) as cvv where v.id in (3393106) and v.id = cvv.bibleverse_id and cv.id = cvv.canonicalbibleverse_id and cv.chapter_id = cc.id
Parameters:
[] |
85 | 0.20 ms |
select array_to_string(array_agg(distinct chapter_id), ',') from canonicalbibleverse where id in (28664)
Parameters:
[] |
86 | 0.29 ms |
select array_to_string(array_agg(id), ',') from canonicalbiblechapter where id in (1132) and id not in (select distinct chapter_id from canonicalbibleverse where chapter_id in (1132) and id not in (28664))
Parameters:
[] |
87 | 8.89 ms |
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 = 404 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 (28664)) and p.id not in (SELECT DISTINCT passage_id FROM chapter_passage WHERE chapter_id in (1132) union SELECT DISTINCT passage_id FROM verse_passage WHERE verse_id in (28664) 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 (28664)) and p.id not in (SELECT DISTINCT passage_id FROM chapter_passage WHERE chapter_id in (1132) union SELECT DISTINCT passage_id FROM verse_passage WHERE verse_id in (28664) 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 ( 404,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
Parameters:
[] |
88 | 0.30 ms |
SELECT chapter_id, min(ordering) as min_order, max(ordering) as max_order from canonicalbibleverse WHERE id in (28664) group by chapter_id
Parameters:
[] |
89 | 2.63 ms |
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 (1132) and from_verse_id is null and to_verse_id is null) or ( to_verse_id is null and sr.from_verse_id in (28664) ) or ( to_verse_id is not null and sr.chapter_id = 1132 and cb1.ordering <= 31 and cb2.ordering >= 31 )) and s.id = sr.show_id and e.visibilitydefault and s.embed_id = e.id limit 1) as t order by video_order1
Parameters:
[] |
90 | 0.29 ms |
SELECT 'http://qbible.com/greek-new-testament/' || qbible_url || '/' || '14' || '.html#' || '1' as url from canonicalbiblebook WHERE id = 62 and qbible_url is not null and qbible_url <> ''
Parameters:
[] |
91 | 2.22 ms |
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 = 62 and r.publicfile like 'dbsn%' and r.id = rb.resource_id and cc.id = rb.chapter_id and cc.ordering = 14 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 = 62) and type_id = 2 and ispublic and public_file is not null order by ordering, name
Parameters:
[] |
92 | 0.23 ms |
select id from language where shortcode = 'ml'
Parameters:
[] |
93 | 67.47 ms |
SELECT v.id, cv.ordering as verse_order, scc.ordering as chapter_order, t.id as translation_id, scc.id as cchapter_id, v.chapter_id, 'bible' || '_' || bt.url || '_' || cb.url || '_' || c.ordering || '_' || v.indexdisplay as bible_spec, 'explanation' || '_' || t.url as explanation_spec, bt.url as bible_trans_url, cb.url as book_url, v.indexdisplay as verse_index, case when t.language_id = 404 then 1 else case when t.language_id = 268 then 2 else case when t.language_id = 123 then 4 end end end as lang_order, bt.language_id FROM (select * from biblestory where level_id = 2) as bs, canonicalbibleverse cv, (select * from canonicalbibleverse_bibleverse where bibleverse_id in (3393106)) as cvv, canonicalbiblechapter scc, expositionwork w, expositiontranslation t, expositiontranslationtext tt, story_work sw, biblechapter c, biblebook b, bibletranslation bt, canonicalbiblebook cb, bibleverse v WHERE w.ispublic and t.ispublic and t.language_id in (404,268,123) and v.id = cvv.bibleverse_id and cv.id = cvv.canonicalbibleverse_id and bs.startverse_id = cv.id and cv.chapter_id = scc.id and v.verse_id is null and sw.story_id = bs.id and w.id = sw.work_id and t.work_id=w.id and v.chapter_id = c.id and b.id = c.book_id and b.translation_id=bt.id and scc.book_id = cb.id and t.id = tt.translation_id and tt.text is not null and tt.text <> '' order by cv.ordering, lang_order, t.is_modern desc, w.ordering, t.islanguagedefault desc limit 1
Parameters:
[] |
94 | 0.72 ms |
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 = 3393106 and v.chapter_id = c.id and c.book_id = b.id and b.translation_id = t.id and t.language_id = l.id
Parameters:
[] |
95 | 0.16 ms |
select show_bible_verse_highlights from language where id = 404
Parameters:
[] |
96 | 36.16 ms |
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 (3393106)) 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 = 404 then 1 else 2 end as ordering from concept_work cl, expositiontranslation trans where trans.language_id in (404, 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 = 404 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
Parameters:
[] |
97 | 0.35 ms |
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.id = ? LIMIT 1
Parameters:
[
63700
]
|
98 | 0.20 ms |
SELECT text_style_override FROM language WHERE id = 63700
Parameters:
[] |
99 | 0.19 ms |
select translationmethod_id from expositiontranslation where id = 63700
Parameters:
[] |
100 | 0.37 ms |
select t2.id from expositiontranslation t1, expositiontranslation t2 where t1.id = 63700 and t1.work_id = t2.work_id and t2.isoriginal order by case when t2.language_id = 123 then 1 else 2 end
Parameters:
[] |
101 | 0.57 ms |
SELECT array_to_string(array_agg( (CASE WHEN p.name is not null then p.name else (case when p.title is null then '' else p.title || ' ' end) || (case when p.firstname is null then '' else p.firstname || ' ' end) || (case when p.middlename is null then '' else p.middlename || ' ' end) || (case when p.lastname is null then '' else p.lastname || ' ' end) || (case when p.suffix is null then '' else p.suffix || ' ' end) end) ), ', ') as authors FROM translation_bibliographicdata tbg, bibliographicdata_person bp, person p WHERE tbg.translation_id = 63465 and tbg.bibliographicdata_id = bp.bibliographicdata_id and bp.person_id = p.id
Parameters:
[] |
102 | 0.29 ms |
select (case when l.nativename is not null and l.nativename <> '' then l.nativename else l.name end) as language_name from expositiontranslation t, language l where t.id = 63700 and l.id = t.language_id
Parameters:
[] |
103 | 0.29 ms |
SELECT t.name FROM texttospeech t, texttospeechlanguage tl WHERE tl.language_id = 404 and t.id = tl.tts_id order by tl.is_standard desc limit 1
Parameters:
[] |
104 | 0.15 ms |
select language_id from expositiontranslation where id = 63700
Parameters:
[] |
105 | 0.86 ms |
select array_to_string(array_agg(DISTINCT d.ref_id),',') as ref from expositiontextunit t, expositiontranslationtext tt, expositiondisplayitem d where t.passage_id = 48244 and tt.translation_id = 63700 and t.id = tt.placement_id and d.container_id = tt.id and d.type_id = 2
Parameters:
[] |
106 | 63.76 ms |
select t3.* from (select * from (SELECT distinct on (tc.textunit_id, rc.id) tc.textunit_id, rc.id as ref_id, rc.originallinktext as link_text, cc1.book_id, rb.startverse_id as startloc_id, rb.endverse_id as endloc_id, true as is_bibleref, 'bible_' || trans.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_text, cc1.ordering as ordering1, cv1.ordering as ordering2, (case when trans.language_id = 404 then 2 else case when trans.language_id = 123 then case when trans.languagedefault then 3 else 4 end end end) as priority_order, cb.url as book_url, trans.url as trans_url, cc1.ordering as chapter_order1, cc2.ordering as chapter_order2, cv1.ordering as verse_order1, cv2.ordering as verse_order2, trans.url as div_url, 0 as passage_order FROM refbible rb, refcombined rc, textunit_combinedreference tc, expositiontextunit t, canonicalbibleverse cv1, canonicalbiblechapter cc1, canonicalbiblebook cb, canonicalbibleverse_bibleverse cbb1, bibleverse v1, biblechapter c1, canonicalbibleverse cv2, canonicalbiblechapter cc2, biblebook b, bibletranslation trans WHERE t.passage_id = 48244 and t.id = tc.textunit_id and rc.id = tc.combinedreference_id and rc.id not in (437,464,594,1112,2203,3453,3543,5352,9338,12285,12471,14754,15542,15650,17845,19951,20049,20797,22382,23112,24615,39354,39355,43788,45778,59675,65533,65539,65540,65543,65546,65547,65548,65551,65552,65553,65555,65557,65560,96440,97297,97611,98517,98628,99055,107571,108512,116866,117164,118961,119217,122122,122123,122126,147035,148271,148272,148274,148275,148276) and rb.container_id = rc.id and cv1.id = rb.startverse_id and cv1.chapter_id = cc1.id and cc1.book_id = cb.id and cv1.id = cbb1.canonicalbibleverse_id and v1.id = cbb1.bibleverse_id and v1.chapter_id = c1.id and c1.book_id = b.id and cv2.id = rb.endverse_id and cv2.chapter_id = cc2.id and b.translation_id = trans.id and trans.enabled order by tc.textunit_id, rc.id, priority_order asc, trans.languagedefault desc) as b union select * from (SELECT distinct on (tc.textunit_id, rc.id) tc.textunit_id, rc.id as ref_id, rc.originallinktext as link_text, d.work_id as book_id, re.startlocation_id as startloc_id, re.endlocation_id as endloc_id, false as is_bibleref, (case when w.swedenborgtype is not null then 'swedenborg_' else 'explanation_' end) || trans.url || (case when p.swedenborgsection is not null then '_' || p.swedenborgsection else '' end) as multilink_text, p.ordering as ordering1, t2.ordering as ordering2, (case when trans.id = 63700 then 1 else case when trans.language_id = 404 then 2 else case when trans.language_id = 123 then case when trans.islanguagedefault then 3 else 4 end end end end) as priority_order, trans.url as book_url, trans.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, refcombined rc, textunit_combinedreference tc, expositiontextunit t, expositiontextunit t2, expositionpassage p, expositiondivision d, expositionwork w, expositiontranslation trans, expositiontranslationtext tt WHERE t.passage_id = 48244 and t.id = tc.textunit_id and rc.id = tc.combinedreference_id and rc.id not in (437,464,594,1112,2203,3453,3543,5352,9338,12285,12471,14754,15542,15650,17845,19951,20049,20797,22382,23112,24615,39354,39355,43788,45778,59675,65533,65539,65540,65543,65546,65547,65548,65551,65552,65553,65555,65557,65560,96440,97297,97611,98517,98628,99055,107571,108512,116866,117164,118961,119217,122122,122123,122126,147035,148271,148272,148274,148275,148276) and re.container_id = rc.id and t2.id = re.startlocation_id and p.id = t2.passage_id and d.id = p.division_id and d.work_id = w.id and w.id = trans.work_id and trans.url is not null and trans.ispublic and w.ispublic and t2.id = tt.placement_id and trans.id = tt.translation_id order by tc.textunit_id, rc.id, priority_order asc, trans.islanguagedefault desc, trans.isoriginal desc) as e) as t3 order by split_part(link_text, ' ', 1), book_id, ordering1, ordering2
Parameters:
[] |
107 | 89.71 ms |
select * from (SELECT distinct on (di.ref_id) di.ref_id, 'bible_' || trans.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 trans.language_id in (select language_id from expositiontranslation where id = 63700) then 1 else case when trans.language_id = 123 then 2 else 3 end end ) as priority_order, cb.url as book_url, trans.url as trans_url, cc1.ordering as chapter_order1, cc2.ordering as chapter_order2, cv1.ordering as verse_order1, cv2.ordering as verse_order2, trans.url as div_url, 0 as passage_order FROM refbible rb, expositiontextunit t, expositiontranslationtext tt, expositiondisplayitem di, canonicalbibleverse cv1, canonicalbiblechapter cc1, canonicalbiblebook cb, canonicalbibleverse cv2, canonicalbiblechapter cc2, biblebook b, bibletranslation trans WHERE t.passage_id = 48244 and t.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 = trans.id and trans.enabled order by di.ref_id, priority_order asc, trans.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) || '_' || trans.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 trans.id = 63700 then 1 else case when trans.language_id in (select language_id from expositiontranslation where id = 63700) then 2 else case when trans.language_id = 123 then 3 else 4 end end end) as priority_order, trans.url as book_url, trans.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 t, expositiontextunit t2, expositionpassage p, expositiondivision d, expositiontranslationtext tt, expositiondisplayitem di, expositionwork w, expositiontranslation trans WHERE t.passage_id = 48244 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 t.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 = trans.work_id and trans.url is not null and trans.ispublic and w.ispublic order by di.ref_id, priority_order asc, trans.islanguagedefault desc, trans.isoriginal desc) as e
Parameters:
[] |
108 | 16.86 ms |
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 = 123 then 1 else 2 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 = 62 and c3.book_id = b3.id and c3.ordering = 14 and v3.chapter_id = c3.id and v3.indexdisplay = '31') order by group_order, language_name, t.name
Parameters:
[] |
109 | 0.24 ms |
SELECT text_style_override FROM language WHERE id = 404
Parameters:
[] |
110 | 0.40 ms |
SELECT t.name FROM texttospeech t, texttospeechlanguage tl WHERE tl.language_id = 404 and t.id = tl.tts_id order by tl.is_standard desc limit 1
Parameters:
[] |
111 | 0.22 ms |
SELECT credit from bibletranslation WHERE url = 'serbian'
Parameters:
[] |
112 | 0.19 ms |
select show_bible_verse_highlights from language where id = 404
Parameters:
[] |
113 | 0.37 ms |
SELECT w.book_id FROM expositionwork w, expositiontranslation t where t.id = 63700 and t.work_id = w.id limit 1
Parameters:
[] |
114 | 10.27 ms |
select distinct on (chapter_order) * from (SELECT t.id as translation_id, t.url as translation_url, bs.name as explanationtitle, 'explanation' || '_' || t.url as explanation_spec, cbc.ordering as chapter_order, case when t.language_id = 404 then 1 else case when t.language_id = 123 then 2 end end as lang_order, case when t.id = 63700 then 1 else case when t.language_id = 404 then 2 else case when t.islanguagedefault then 3 else 4 end end end as trans_order, w.id as work_id, bs.id as story_id, t.language_id, (case when l.nativename is not null and l.nativename <> '' then l.nativename else l.name end) as language_name FROM expositionwork w, expositiontranslation t, story_work sw, biblestory bs, canonicalbiblechapter cbc, language l WHERE bs.chapter_id in (select id from canonicalbiblechapter where book_id in (select book_id from biblestory bs2, story_work sw2, canonicalbiblechapter cbc2 where sw2.work_id = 11314 and sw2.story_id = bs2.id and cbc2.id = bs2.chapter_id)) and sw.story_id = bs.id and w.id = sw.work_id and t.work_id=w.id and cbc.id = bs.chapter_id and t.language_id = l.id and w.ispublic AND t.ispublic order by cbc.ordering, lang_order, trans_order, t.is_modern desc, sw.ordering) as t
Parameters:
[] |
115 | 0.37 ms |
select case when w.swedenborgtype is null then false else true end as sw from expositionwork w, expositiontranslation t where t.id = 63700 and t.work_id = w.id
Parameters:
[] |
116 | 0.55 ms |
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')
Parameters:
[] |
117 | 0.57 ms |
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 = ?
Parameters:
[
63700
]
|
118 | 0.48 ms |
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.id = ?
Parameters:
[
151
]
|
119 | 0.29 ms |
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 = ?
Parameters:
[
404
]
|
120 | 0.43 ms |
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 = ?
Parameters:
[
11314
]
|
121 | 0.68 ms |
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 = ?
Parameters:
[
11314
]
|
122 | 0.52 ms |
SELECT t0.id AS id_1, t0.story_id AS story_id_2, t0.image_id AS image_id_3 FROM storyillustration t0 WHERE t0.story_id = ?
Parameters:
[
1414
]
|
123 | 0.47 ms |
SELECT t0.id AS id_1, t0.width AS width_2, t0.height AS height_3, t0.location AS location_4, t0.isLocal AS islocal_5, t0.alt AS alt_6, t0.copyright AS copyright_7, t0.notice AS notice_8, t0.license AS license_9, t0.youtube_id AS youtube_id_10, t0.visibilityDefault AS visibilitydefault_11, t0.language_id AS language_id_12 FROM embed t0 INNER JOIN story_embed ON t0.id = story_embed.embed_id WHERE story_embed.story_id = ?
Parameters:
[
1414
]
|
124 | 0.95 ms |
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 = ?
Parameters:
[
86866
]
|
125 | 0.84 ms |
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
Parameters:
[
4307504
]
|
126 | 0.63 ms |
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.containingItem_id = ? ORDER BY t0.ordering ASC
Parameters:
[
40356295
]
|
127 | 0.25 ms |
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.containingItem_id = ? ORDER BY t0.ordering ASC
Parameters:
[
40356299
]
|
128 | 0.25 ms |
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.containingItem_id = ? ORDER BY t0.ordering ASC
Parameters:
[
40356309
]
|
129 | 0.22 ms |
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.containingItem_id = ? ORDER BY t0.ordering ASC
Parameters:
[
40356317
]
|
130 | 0.22 ms |
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.containingItem_id = ? ORDER BY t0.ordering ASC
Parameters:
[
40356521
]
|
131 | 0.22 ms |
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.containingItem_id = ? ORDER BY t0.ordering ASC
Parameters:
[
40356567
]
|
132 | 0.22 ms |
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.containingItem_id = ? ORDER BY t0.ordering ASC
Parameters:
[
40356569
]
|
133 | 0.23 ms |
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.containingItem_id = ? ORDER BY t0.ordering ASC
Parameters:
[
40356573
]
|
134 | 0.22 ms |
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.containingItem_id = ? ORDER BY t0.ordering ASC
Parameters:
[
40356577
]
|
135 | 0.39 ms |
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.containingItem_id = ? ORDER BY t0.ordering ASC
Parameters:
[
40356581
]
|
136 | 0.23 ms |
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.containingItem_id = ? ORDER BY t0.ordering ASC
Parameters:
[
40356591
]
|
137 | 0.24 ms |
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.containingItem_id = ? ORDER BY t0.ordering ASC
Parameters:
[
40356595
]
|
138 | 0.21 ms |
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.containingItem_id = ? ORDER BY t0.ordering ASC
Parameters:
[
40356599
]
|
139 | 0.24 ms |
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.containingItem_id = ? ORDER BY t0.ordering ASC
Parameters:
[
40356601
]
|
140 | 0.22 ms |
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.containingItem_id = ? ORDER BY t0.ordering ASC
Parameters:
[
40356603
]
|
141 | 0.22 ms |
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.containingItem_id = ? ORDER BY t0.ordering ASC
Parameters:
[
40356607
]
|
142 | 0.22 ms |
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.containingItem_id = ? ORDER BY t0.ordering ASC
Parameters:
[
40356611
]
|
143 | 0.43 ms |
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.containingItem_id = ? ORDER BY t0.ordering ASC
Parameters:
[
40356619
]
|
144 | 0.23 ms |
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.containingItem_id = ? ORDER BY t0.ordering ASC
Parameters:
[
40356625
]
|
145 | 0.21 ms |
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.containingItem_id = ? ORDER BY t0.ordering ASC
Parameters:
[
40356631
]
|
146 | 0.24 ms |
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.containingItem_id = ? ORDER BY t0.ordering ASC
Parameters:
[
40356637
]
|
147 | 0.57 ms |
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
Parameters:
[
48244
]
|
Database Connections
Name | Service |
---|---|
default | doctrine.dbal.default_connection |
Entity Managers
Name | Service |
---|---|
default | doctrine.orm.default_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Entities Mapping
Class | Mapping errors |
---|---|
NCBS\WebsiteBundle\Entity\Exposition\Translation | No errors. |
NCBS\WebsiteBundle\Entity\Exposition\Work | No errors. |
NCBS\WebsiteBundle\Entity\Language | No errors. |
NCBS\WebsiteBundle\Entity\Bibliographic\BibliographicData | No errors. |
NCBS\WebsiteBundle\Entity\Exposition\Category | No errors. |
NCBS\WebsiteBundle\Entity\Bible\Stories\Story | No errors. |
NCBS\WebsiteBundle\Entity\Exposition\Division | No errors. |
NCBS\WebsiteBundle\Entity\Exposition\Passage | No errors. |
NCBS\WebsiteBundle\Entity\Exposition\TextUnit | No errors. |
NCBS\WebsiteBundle\Entity\Relation\PassageMedia | No errors. |
NCBS\WebsiteBundle\Entity\Exposition\TranslationText | No errors. |
NCBS\WebsiteBundle\Entity\Reference\CombinedReference | No errors. |
NCBS\WebsiteBundle\Entity\Media\Image | No errors. |
NCBS\WebsiteBundle\Entity\Exposition\DisplayItem | No errors. |
NCBS\WebsiteBundle\Entity\Exposition\Collection | No errors. |
NCBS\WebsiteBundle\Entity\Bible\Verse | No errors. |
NCBS\WebsiteBundle\Entity\Bible\Chapter | No errors. |
NCBS\WebsiteBundle\Entity\Bible\Canonical\Verse | No errors. |
NCBS\WebsiteBundle\Entity\Bible\Book | No errors. |
NCBS\WebsiteBundle\Entity\Bible\Translation | No errors. |
NCBS\WebsiteBundle\Entity\Bible\Canonical\Book | No errors. |
NCBS\WebsiteBundle\Entity\Bible\Canonical\Testament | No errors. |
NCBS\WebsiteBundle\Entity\Bible\Canonical\Chapter | No errors. |
NCBS\WebsiteBundle\Entity\Relation\StoryIllustration | No errors. |
NCBS\WebsiteBundle\Entity\Media\Embed | No errors. |