Symfony Profiler

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

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

SELECT 
  rs.id, 
  rs.name, 
  rs.text, 
  rs.closing_text, 
  rs.image_file, 
  rs.image_title, 
  rs.video_link, 
  rs.youtube_id, 
  rs.video_notice, 
  case when rl.name is null then r.name else rl.name end as plan_title, 
  rs.ordering as step_order, 
  rs.type_id, 
  rs.work_id, 
  rs.passage_id, 
  rs.explanation_id 
FROM 
  (
    select 
      rsa.id, 
      case when rsl.name is null then rsa.name else rsl.name end as name, 
      rsa.readingplan_id, 
      rsa.startverse_id, 
      rsa.endverse_id, 
      rsa.ordering, 
      rsa.type_id, 
      rsa.work_id, 
      rsa.passage_id, 
      rsa.explanation_id, 
      case when rsl.text is null then rsa.text else rsl.text end as text, 
      case when rsl.closing_text is null then rsa.closing_text else rsl.closing_text end as closing_text, 
      i.file as image_file, 
      i.title as image_title, 
      e.location as video_link, 
      e.youtube_id, 
      e.notice as video_notice 
    from 
      readingplanstep rsa 
      left join (
        select 
          * 
        from 
          readingplanstep_language 
        where 
          language_id = 65
      ) rsl on rsa.id = rsl.readingplanstep_id 
      left join image i on rsa.image_id = i.id 
      left join (
        select 
          * 
        from 
          embed 
        where 
          visibilitydefault
      ) e on rsa.embed_id = e.id
  ) rs, 
  readingplan r 
  left join (
    select 
      * 
    from 
      readingplan_language 
    where 
      language_id = 65
  ) rl on r.id = rl.readingplan_id 
where 
  r.url = 'a-seamless-garment-luke' 
  and r.id = rs.readingplan_id 
  and rs.ordering = 19

SELECT rs.id, rs.name, rs.text, rs.closing_text, rs.image_file, rs.image_title, rs.video_link, rs.youtube_id, rs.video_notice, case when rl.name is null then r.name else rl.name end as plan_title, rs.ordering as step_order, rs.type_id, rs.work_id, rs.passage_id, rs.explanation_id FROM  (select rsa.id, case when rsl.name is null then rsa.name else rsl.name end as name, rsa.readingplan_id, rsa.startverse_id, rsa.endverse_id, rsa.ordering, rsa.type_id, rsa.work_id, rsa.passage_id, rsa.explanation_id, case when rsl.text is null then rsa.text else rsl.text end as text, case when rsl.closing_text is null then rsa.closing_text else rsl.closing_text end as closing_text, i.file as image_file, i.title as image_title, e.location as video_link, e.youtube_id, e.notice as video_notice from readingplanstep rsa left join (select * from readingplanstep_language where language_id = 65) rsl on rsa.id = rsl.readingplanstep_id left join image i on rsa.image_id = i.id left join (select * from embed where visibilitydefault) e on rsa.embed_id = e.id) rs,  readingplan r left join (select * from readingplan_language where language_id = 65) rl on r.id = rl.readingplan_id  where r.url = 'a-seamless-garment-luke' and r.id = rs.readingplan_id and rs.ordering = 19;

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

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

SELECT 
  max(sl.datemod) 
FROM 
  ui_string_language sl, 
  ui_string s 
WHERE 
  sl.language_id in (65, 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 (65, 123) and 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 = 65 
      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 = 65 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 
  t.id, 
  t.url 
FROM 
  language l, 
  expositionwork w, 
  expositiontranslation t 
WHERE 
  w.id = 11268 
  and w.ispublic 
  and t.work_id = w.id 
  and t.ispublic 
  and t.language_id = l.id 
  AND t.type_id = 1 
order by 
  (
    case when t.language_id in (
      select 
        id 
      from 
        language 
      where 
        shortcode = 'bg'
    ) then 1 else case when t.language_id = 123 then 2 else 3 end end
  ), 
  t.islanguagedefault desc 
limit 
  1

SELECT t.id, t.url FROM language l, expositionwork w, expositiontranslation t WHERE w.id = 11268 and w.ispublic and t.work_id = w.id and t.ispublic and t.language_id = l.id AND t.type_id = 1 order by (case when t.language_id in (select id from language where shortcode = 'bg') then 1 else case when t.language_id = 123 then 2 else 3 end end), t.islanguagedefault desc limit 1;