Symfony Profiler

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

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

SELECT 
  max(sl.datemod) 
FROM 
  ui_string_language sl, 
  ui_string s 
WHERE 
  sl.language_id in (425, 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 (425, 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 = 425 
      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 = 425 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 
  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 = ? 
LIMIT 
  1

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 = 'inner-meaning-of-luke-14-sv' AND t0.isPublic = 1 LIMIT 1;

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 = ?

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 = 413;

select 
  translationmethod_id 
from 
  expositiontranslation 
where 
  id = 63701

select translationmethod_id from expositiontranslation where id = 63701;

SELECT 
  b.*, 
  bp.creators, 
  l.name as license_name, 
  l.terms as license_terms, 
  cr.description as copyright 
from 
  translation_bibliographicdata tb, 
  bibliographicdata b 
  LEFT JOIN (
    SELECT 
      bp1.bibliographicdata_id, 
      string_agg(
        CASE WHEN p.name is not null then p.name else (
          (
            (
              (p.firstname):: text || CASE WHEN (p.middlename IS NULL) THEN '' :: text ELSE (
                ' ' :: text || (p.middlename):: text
              ) END
            ) || ' ' :: text
          ) || (p.lastname):: text
        ) end, 
        ', ' :: text
      ) AS creators 
    FROM 
      bibliographicdata_person bp1, 
      person p 
    WHERE 
      (
        bp1.person_id = p.id 
        and bp1.role_id = 2
      ) 
    GROUP BY 
      bp1.bibliographicdata_id
  ) bp ON (b.id = bp.bibliographicdata_id) 
  LEFT JOIN lnccopyrightholder cr on b.copyright_id = cr.id 
  LEFT JOIN license l on b.license_id = l.id 
where 
  tb.translation_id = 63701 
  and tb.bibliographicdata_id = b.id

SELECT b.*, bp.creators, l.name as license_name, l.terms as license_terms, cr.description as copyright from translation_bibliographicdata tb,  bibliographicdata b LEFT JOIN (SELECT bp1.bibliographicdata_id, string_agg(CASE WHEN p.name is not null then p.name else ((((p.firstname)::text || CASE WHEN (p.middlename IS NULL) THEN ''::text ELSE (' '::text || (p.middlename)::text) END) || ' '::text) || (p.lastname)::text) end, ', '::text) AS creators FROM bibliographicdata_person bp1, person p WHERE (bp1.person_id = p.id and bp1.role_id = 2) GROUP BY bp1.bibliographicdata_id) bp ON (b.id = bp.bibliographicdata_id) LEFT JOIN lnccopyrightholder cr on b.copyright_id = cr.id LEFT JOIN license l on b.license_id = l.id where  tb.translation_id = 63701 and tb.bibliographicdata_id = b.id;

SELECT 
  b.*, 
  bp.creators, 
  l.name as license_name, 
  l.terms as license_terms, 
  cr.description as copyright 
from 
  bibliographicdata b 
  LEFT JOIN (
    SELECT 
      bp1.bibliographicdata_id, 
      string_agg(
        CASE WHEN p.name is not null then p.name else (
          (
            (
              (p.firstname):: text || CASE WHEN (p.middlename IS NULL) THEN '' :: text ELSE (
                ' ' :: text || (p.middlename):: text
              ) END
            ) || ' ' :: text
          ) || (p.lastname):: text
        ) end, 
        ', ' :: text
      ) AS creators 
    FROM 
      bibliographicdata_person bp1, 
      person p 
    WHERE 
      (
        bp1.person_id = p.id 
        and bp1.role_id = 2
      ) 
    GROUP BY 
      bp1.bibliographicdata_id
  ) bp ON (b.id = bp.bibliographicdata_id) 
  LEFT JOIN lnccopyrightholder cr on b.copyright_id = cr.id 
  LEFT JOIN license l on b.license_id = l.id 
where 
  b.id in (
    select 
      machine_translation_bilio_id 
    from 
      parameter 
    where 
      id = 1
  )

SELECT b.*, bp.creators, l.name as license_name, l.terms as license_terms, cr.description as copyright from bibliographicdata b LEFT JOIN (SELECT bp1.bibliographicdata_id, string_agg(CASE WHEN p.name is not null then p.name else ((((p.firstname)::text || CASE WHEN (p.middlename IS NULL) THEN ''::text ELSE (' '::text || (p.middlename)::text) END) || ' '::text) || (p.lastname)::text) end, ', '::text) AS creators FROM bibliographicdata_person bp1, person p WHERE (bp1.person_id = p.id and bp1.role_id = 2) GROUP BY bp1.bibliographicdata_id) bp ON (b.id = bp.bibliographicdata_id) LEFT JOIN lnccopyrightholder cr on b.copyright_id = cr.id LEFT JOIN license l on b.license_id = l.id where  b.id in (select machine_translation_bilio_id from parameter where id = 1);

SELECT 
  * 
from 
  publication 
where 
  biblio_id = 1650

SELECT * from publication where biblio_id = 1650;

SELECT 
  b.*, 
  bp.creators, 
  l.name as license_name, 
  l.terms as license_terms, 
  cr.description as copyright, 
  t.url as translation_url 
from 
  translation_bibliographicdata tb, 
  expositiontranslation t, 
  bibliographicdata b 
  LEFT JOIN (
    SELECT 
      bp1.bibliographicdata_id, 
      string_agg(
        CASE WHEN p.name is not null then p.name else (
          (
            (
              (p.firstname):: text || CASE WHEN (p.middlename IS NULL) THEN '' :: text ELSE (
                ' ' :: text || (p.middlename):: text
              ) END
            ) || ' ' :: text
          ) || (p.lastname):: text
        ) end, 
        ', ' :: text
      ) AS creators 
    FROM 
      bibliographicdata_person bp1, 
      person p 
    WHERE 
      (
        bp1.person_id = p.id 
        and (
          bp1.role_id = 1 
          or bp1.role_id is null
        )
      ) 
    GROUP BY 
      bp1.bibliographicdata_id
  ) bp ON (b.id = bp.bibliographicdata_id) 
  LEFT JOIN lnccopyrightholder cr on b.copyright_id = cr.id 
  LEFT JOIN license l on b.license_id = l.id 
WHERE 
  tb.translation_id in (
    select 
      id 
    from 
      expositiontranslation 
    where 
      work_id in (
        select 
          work_id 
        from 
          expositiontranslation 
        where 
          id = 63701
      ) 
      and isoriginal
  ) 
  and tb.bibliographicdata_id = b.id 
  and t.id = tb.translation_id

SELECT b.*, bp.creators, l.name as license_name, l.terms as license_terms, cr.description as copyright, t.url as translation_url from translation_bibliographicdata tb, expositiontranslation t, bibliographicdata b LEFT JOIN (SELECT bp1.bibliographicdata_id, string_agg(CASE WHEN p.name is not null then p.name else ((((p.firstname)::text || CASE WHEN (p.middlename IS NULL) THEN ''::text ELSE (' '::text || (p.middlename)::text) END) || ' '::text) || (p.lastname)::text) end, ', '::text) AS creators FROM bibliographicdata_person bp1, person p WHERE (bp1.person_id = p.id and (bp1.role_id = 1 or bp1.role_id is null)) GROUP BY bp1.bibliographicdata_id) bp ON (b.id = bp.bibliographicdata_id) LEFT JOIN lnccopyrightholder cr on b.copyright_id = cr.id LEFT JOIN license l on b.license_id = l.id WHERE tb.translation_id in (select id from expositiontranslation where work_id in (select work_id from expositiontranslation where id = 63701) and isoriginal) and tb.bibliographicdata_id = b.id and t.id = tb.translation_id;

SELECT 
  * 
from 
  publication 
where 
  biblio_id = 1489

SELECT * from publication where biblio_id = 1489;

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 
  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 = ?

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 = 11314;

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 = ?

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 = 11314;

SELECT 
  t0.id AS id_1, 
  t0.sourceLink AS sourcelink_2, 
  t0.credit AS credit_3, 
  t0.copyright AS copyright_4, 
  t0.copyrightyear AS copyrightyear_5, 
  t0.notice AS notice_6, 
  t0.about AS about_7, 
  t0.dateCreated AS datecreated_8, 
  t0.language_id AS language_id_9, 
  t0.license_id AS license_id_10 
FROM 
  bibliographicdata t0 
  INNER JOIN translation_bibliographicdata ON t0.id = translation_bibliographicdata.bibliographicdata_id 
WHERE 
  translation_bibliographicdata.translation_id = ?

SELECT t0.id AS id_1, t0.sourceLink AS sourcelink_2, t0.credit AS credit_3, t0.copyright AS copyright_4, t0.copyrightyear AS copyrightyear_5, t0.notice AS notice_6, t0.about AS about_7, t0.dateCreated AS datecreated_8, t0.language_id AS language_id_9, t0.license_id AS license_id_10 FROM bibliographicdata t0 INNER JOIN translation_bibliographicdata ON t0.id = translation_bibliographicdata.bibliographicdata_id WHERE translation_bibliographicdata.translation_id = 63701;