Symfony Profiler

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 = 363 
      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)

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 = 363 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);

SELECT 
  max(sl.datemod) 
FROM 
  ui_string_language sl, 
  ui_string s 
WHERE 
  sl.language_id in (363, 123) 
  and s.id = sl.ui_string_id 
  and s.is_active 
  and s.type_id in (1, 3)

SELECT max(sl.datemod) FROM ui_string_language sl, ui_string s WHERE sl.language_id in (363, 123) and s.id = sl.ui_string_id and s.is_active and s.type_id in (1, 3);

SELECT 
  bc.id as chapter_id, 
  cbv.ordering as verse_order, 
  t.url || '/' || cb.url || '/' || cc.ordering as link, 
  cc.ordering || ':' || cbv.ordering as linktext, 
  bv.content as text, 
  cb.id as cbook_id, 
  cc.id as cchapter_id, 
  cc.ordering as cchapter_order, 
  bc.book_id, 
  cbv.id as cverse_id, 
  cb.url || '/' || cc.ordering as link_end 
FROM 
  bibleverse bv, 
  biblechapter bc, 
  biblebook b, 
  bibletranslation t, 
  canonicalbibleverse_bibleverse cbv_bv, 
  canonicalbibleverse cbv, 
  canonicalbiblechapter cc, 
  canonicalbiblebook cb 
where 
  t.language_id = 363 
  and cbv.id = 30972 
  and cbv.id = cbv_bv.canonicalbibleverse_id 
  and bv.id = cbv_bv.bibleverse_id 
  and bv.chapter_id = bc.id 
  and bc.book_id = b.id 
  and b.translation_id = t.id 
  and cbv.chapter_id = cc.id 
  and cc.book_id = cb.id 
order by 
  t.languagedefault desc 
limit 
  1

SELECT bc.id as chapter_id, cbv.ordering as verse_order, t.url || '/' || cb.url || '/' || cc.ordering as link, cc.ordering || ':' || cbv.ordering as linktext, bv.content as text, cb.id as cbook_id, cc.id as cchapter_id, cc.ordering as cchapter_order, bc.book_id, cbv.id as cverse_id, cb.url || '/' || cc.ordering as link_end FROM bibleverse bv, biblechapter bc, biblebook b, bibletranslation t, canonicalbibleverse_bibleverse cbv_bv, canonicalbibleverse cbv, canonicalbiblechapter cc, canonicalbiblebook cb where t.language_id = 363 and cbv.id = 30972 and cbv.id = cbv_bv.canonicalbibleverse_id and bv.id = cbv_bv.bibleverse_id and bv.chapter_id = bc.id and bc.book_id = b.id and b.translation_id = t.id and cbv.chapter_id = cc.id and cc.book_id = cb.id order by t.languagedefault desc limit 1;

SELECT 
  id 
FROM 
  language 
WHERE 
  shortcode = 'ru' 
limit 
  1

SELECT id FROM language WHERE shortcode = 'ru' limit 1;

SELECT 
  startverse_id, 
  endverse_id, 
  commentary, 
  work_id, 
  passage_id, 
  subsection_num 
FROM 
  emailbydate 
WHERE 
  date_to_send = CURRENT_DATE 
limit 
  1

SELECT startverse_id, endverse_id, commentary, work_id, passage_id, subsection_num FROM emailbydate WHERE date_to_send = CURRENT_DATE limit 1;

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'
  )

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');

SELECT 
  text 
FROM 
  page_message 
WHERE 
  id = 1

SELECT text FROM page_message WHERE id = 1;

select 
  name 
from 
  canonicalbiblebooklanguage 
where 
  book_id = 60 
  and language_id = 363 
  and not is_abbr 
order by 
  is_standard desc 
limit 
  1

select name from canonicalbiblebooklanguage where book_id = 60 and language_id = 363 and not is_abbr order by is_standard desc limit 1;