Symfony Profiler

select 
  * 
from 
  (
    SELECT 
      distinct on (t.id) t.translatedtitle AS title, 
      t.description, 
      t.url, 
      bsw.story_id, 
      bsw.story_url, 
      t.url as translation_url, 
      wo.feature_ordering, 
      case when fi.image_file is not null then fi.image_file else case when fi2.image_file is not null then fi2.image_file else case when ci.image_file is not null then ci.image_file else ti.image_file end end end as image_file, 
      case when fi.image_file is not null then fi.image_title else case when fi2.image_file is not null then fi2.image_title else case when ci.image_file is not null then ci.image_title else ti.image_title end end end as image_title 
    FROM 
      expositionwork w, 
      expositiontranslation t 
      left join (
        select 
          distinct on (t1.id) t1.id, 
          i.file as image_file, 
          i.title as image_title 
        from 
          expositiontranslation t1, 
          image i 
        where 
          t1.is_featured 
          and t1.feature_image_id = i.id
      ) fi on t.id = fi.id 
      left join (
        select 
          distinct on (t1.work_id) t1.work_id, 
          i.file as image_file, 
          i.title as image_title 
        from 
          expositiontranslation t1, 
          image i 
        where 
          t1.is_featured 
          and t1.feature_image_id = i.id 
        order by 
          t1.work_id, 
          case when t1.language_id = 123 then 1 else 2 end
      ) fi2 on t.work_id = fi2.work_id 
      left join (
        select 
          distinct on (tt1.translation_id) tt1.translation_id, 
          i.file as image_file, 
          i.title as image_title 
        from 
          textunit_image ti, 
          image i, 
          expositiontranslationtext tt1 
        where 
          ti.textunit_id = tt1.placement_id 
          and ti.image_id = i.id 
          and i.mediatype_id = 1
      ) ti on t.id = ti.translation_id 
      left join (
        select 
          distinct on (cl.work_id) cl.work_id as id, 
          i.file as image_file, 
          i.title as image_title 
        from 
          image i, 
          conceptillustration ci1, 
          concept_work cl 
        where 
          cl.concept_id = ci1.concept_id 
          and ci1.image_id = i.id
      ) ci on t.work_id = ci.id 
      join (
        select 
          distinct on (t2.work_id) t2.work_id, 
          t2.feature_ordering 
        from 
          expositiontranslation t2 
        where 
          t2.is_featured 
          and t2.language_id = 123
      ) as wo on t.work_id = wo.work_id 
      left join (
        select 
          bs.id, 
          bs.url as story_url, 
          sw.work_id, 
          sw.story_id 
        from 
          story_work sw, 
          (
            select 
              * 
            from 
              biblestory 
            where 
              level_id = 1
          ) as bs 
        where 
          bs.id = sw.story_id
      ) bsw on t.work_id = bsw.work_id 
    WHERE 
      t.language_id = 177 
      AND t.ispublic 
      AND w.ispublic 
      and t.work_id = w.id 
      and w.id not IN (
        SELECT 
          work_id 
        FROM 
          work_category 
        WHERE 
          category_id = 45
      ) 
      and t.id not IN (
        SELECT 
          translation_id 
        FROM 
          translation_category 
        WHERE 
          category_id = 45
      ) 
      and w.id not IN (
        SELECT 
          work_id 
        FROM 
          work_category 
        WHERE 
          category_id = 53
      )
  ) as t1 
ORDER BY 
  t1.feature_ordering 
limit 
  26

select * from (SELECT distinct on (t.id) t.translatedtitle AS title, t.description, t.url, bsw.story_id, bsw.story_url, t.url as translation_url, wo.feature_ordering, case when fi.image_file is not null then fi.image_file else case when fi2.image_file is not null then fi2.image_file else case when ci.image_file is not null then ci.image_file else ti.image_file end end end as image_file, case when fi.image_file is not null then fi.image_title else case when fi2.image_file is not null then fi2.image_title else case when ci.image_file is not null then ci.image_title else ti.image_title end end end as image_title FROM expositionwork w, expositiontranslation t left join (select distinct on (t1.id) t1.id, i.file as image_file, i.title as image_title from expositiontranslation t1, image i where t1.is_featured and t1.feature_image_id = i.id) fi on t.id = fi.id left join (select distinct on (t1.work_id) t1.work_id, i.file as image_file, i.title as image_title from expositiontranslation t1, image i where t1.is_featured and t1.feature_image_id = i.id order by t1.work_id, case when t1.language_id = 123 then 1 else 2 end) fi2 on t.work_id = fi2.work_id left join (select distinct on (tt1.translation_id) tt1.translation_id, i.file as image_file, i.title as image_title from textunit_image ti, image i, expositiontranslationtext tt1 where ti.textunit_id = tt1.placement_id and ti.image_id = i.id and i.mediatype_id = 1) ti on t.id = ti.translation_id left join (select distinct on (cl.work_id) cl.work_id as id, i.file as image_file, i.title as image_title from image i, conceptillustration ci1, concept_work cl where cl.concept_id = ci1.concept_id and ci1.image_id = i.id) ci on t.work_id = ci.id join (select distinct on (t2.work_id) t2.work_id, t2.feature_ordering from expositiontranslation t2 where t2.is_featured and t2.language_id = 123) as wo on t.work_id = wo.work_id left join (select bs.id, bs.url as story_url, sw.work_id, sw.story_id from story_work sw, (select * from biblestory where level_id = 1) as bs where bs.id = sw.story_id) bsw on t.work_id = bsw.work_id WHERE t.language_id = 177 AND t.ispublic AND w.ispublic and t.work_id=w.id and w.id not IN (SELECT work_id FROM work_category WHERE category_id=45) and t.id not IN (SELECT translation_id FROM translation_category WHERE category_id=45) and w.id not IN (SELECT work_id FROM work_category WHERE category_id=53)) as t1 ORDER BY t1.feature_ordering limit 26;

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.shortcode = 'hi' then 1 else case when l.shortcode = 'en' then 2 else 3 end end as lang_ordering, 
  l.id as language_id 
FROM 
  language l, 
  bibletranslation t, 
  biblebook b, 
  biblechapter c, 
  canonicalbiblebook cb 
WHERE 
  c.book_id = b.id 
  and b.canonicalization_id = cb.id 
  and b.translation_id = t.id 
  and (
    t.enabled 
    and not t.restricted_access
  ) 
  and t.language_id = l.id 
order by 
  lang_ordering, 
  languagedefault desc 
limit 
  1

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.shortcode = 'hi' then 1 else case when l.shortcode = 'en' then 2 else 3 end end as lang_ordering, l.id as language_id FROM language l, bibletranslation t, biblebook b, biblechapter c, canonicalbiblebook cb WHERE c.book_id = b.id and b.canonicalization_id = cb.id and b.translation_id = t.id and  (t.enabled and not t.restricted_access)  and t.language_id = l.id order by lang_ordering, languagedefault desc limit 1;

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 = 177 
      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 = 177 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 (177, 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 (177, 123) and s.id = sl.ui_string_id and s.is_active and s.type_id in (1, 3);

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

SELECT id FROM language WHERE shortcode = 'hi' 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');