Symfony Profiler

SELECT
  j0_.id AS id_0,
  j0_.title AS title_1
FROM
  journal j0_
WHERE
  j0_.area LIKE ?
LIMIT
  4

SELECT j0_.id AS id_0, j0_.title AS title_1 FROM journal j0_ WHERE j0_.area LIKE '%Assessment and Diagnosis%' LIMIT 4;

SELECT
  DISTINCT j0_.publisher AS publisher_0
FROM
  journal j0_
WHERE
  j0_.publisher IS NOT NULL
  AND j0_.publisher <> ?
ORDER BY
  j0_.publisher ASC

SELECT DISTINCT j0_.publisher AS publisher_0 FROM journal j0_ WHERE j0_.publisher IS NOT NULL AND j0_.publisher <> '' ORDER BY j0_.publisher ASC;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.category_name AS category_name_3,
  t0.area AS area_4,
  t0.guide AS guide_5,
  t0.publisher AS publisher_6,
  t0.quartile AS quartile_7,
  t0.is_open_access AS is_open_access_8,
  t0.print_issn AS print_issn_9,
  t0.original_print_issn AS original_print_issn_10,
  t0.original_eissn AS original_eissn_11,
  t0.eissn AS eissn_12,
  t0.citation_count AS citation_count_13,
  t0.country AS country_14,
  t0.region AS region_15,
  t0.hindex AS hindex_16,
  t0.updated_at AS updated_at_17,
  t0.scope AS scope_18,
  t0.email AS email_19,
  t0.home_page AS home_page_20,
  t0.start_date_open_licence AS start_date_open_licence_21,
  t0.langue_manuscript AS langue_manuscript_22,
  t0.country_publisher AS country_publisher_23,
  t0.licence AS licence_24,
  t0.review_url AS review_url_25,
  t0.aim_scoop_url AS aim_scoop_url_26,
  t0.weeks_between_submission_publication AS weeks_between_submission_publication_27,
  t0.added_in_doaj_at AS added_in_doaj_at_28,
  t0.last_updated_in_doaj_at AS last_updated_in_doaj_at_29,
  t0.recent_article_added_at AS recent_article_added_at_30,
  t0.how_to_publish AS how_to_publish_31,
  t0.sjr AS sjr_32,
  t0.total_doc_last_year AS total_doc_last_year_33,
  t0.total_docs_3_years AS total_docs_3_years_34,
  t0.total_refs AS total_refs_35,
  t0.total_cites_3_years AS total_cites_3_years_36,
  t0.citable_docs_3_years AS citable_docs_3_years_37,
  t0.cites_docs_2_years AS cites_docs_2_years_38,
  t0.ref_per_doc AS ref_per_doc_39,
  t0.female AS female_40,
  t0.overton AS overton_41,
  t0.sdg AS sdg_42,
  t0.coverage AS coverage_43,
  t0.contributor_id AS contributor_id_44
FROM
  journal t0

SELECT t0.id AS id_1, t0.title AS title_2, t0.category_name AS category_name_3, t0.area AS area_4, t0.guide AS guide_5, t0.publisher AS publisher_6, t0.quartile AS quartile_7, t0.is_open_access AS is_open_access_8, t0.print_issn AS print_issn_9, t0.original_print_issn AS original_print_issn_10, t0.original_eissn AS original_eissn_11, t0.eissn AS eissn_12, t0.citation_count AS citation_count_13, t0.country AS country_14, t0.region AS region_15, t0.hindex AS hindex_16, t0.updated_at AS updated_at_17, t0.scope AS scope_18, t0.email AS email_19, t0.home_page AS home_page_20, t0.start_date_open_licence AS start_date_open_licence_21, t0.langue_manuscript AS langue_manuscript_22, t0.country_publisher AS country_publisher_23, t0.licence AS licence_24, t0.review_url AS review_url_25, t0.aim_scoop_url AS aim_scoop_url_26, t0.weeks_between_submission_publication AS weeks_between_submission_publication_27, t0.added_in_doaj_at AS added_in_doaj_at_28, t0.last_updated_in_doaj_at AS last_updated_in_doaj_at_29, t0.recent_article_added_at AS recent_article_added_at_30, t0.how_to_publish AS how_to_publish_31, t0.sjr AS sjr_32, t0.total_doc_last_year AS total_doc_last_year_33, t0.total_docs_3_years AS total_docs_3_years_34, t0.total_refs AS total_refs_35, t0.total_cites_3_years AS total_cites_3_years_36, t0.citable_docs_3_years AS citable_docs_3_years_37, t0.cites_docs_2_years AS cites_docs_2_years_38, t0.ref_per_doc AS ref_per_doc_39, t0.female AS female_40, t0.overton AS overton_41, t0.sdg AS sdg_42, t0.coverage AS coverage_43, t0.contributor_id AS contributor_id_44 FROM journal t0;

SELECT
  DISTINCT j0_.country AS country_0
FROM
  journal j0_
WHERE
  j0_.country IS NOT NULL
  AND j0_.country <> ?
ORDER BY
  j0_.country ASC

SELECT DISTINCT j0_.country AS country_0 FROM journal j0_ WHERE j0_.country IS NOT NULL AND j0_.country <> '' ORDER BY j0_.country ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.alternative_name AS alternative_name_3,
  t0.affiliation AS affiliation_4,
  t0.last_known_institutions AS last_known_institutions_5,
  t0.topics AS topics_6,
  t0.publications AS publications_7,
  t0.fields AS fields_8
FROM
  author t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.alternative_name AS alternative_name_3, t0.affiliation AS affiliation_4, t0.last_known_institutions AS last_known_institutions_5, t0.topics AS topics_6, t0.publications AS publications_7, t0.fields AS fields_8 FROM author t0;

SELECT
  DISTINCT (j0_.publisher) AS sclr_0
FROM
  journal j0_
WHERE
  j0_.publisher IS NOT NULL
  AND j0_.publisher <> ?

SELECT DISTINCT (j0_.publisher) AS sclr_0 FROM journal j0_ WHERE j0_.publisher IS NOT NULL AND j0_.publisher <> '';

SELECT
  DISTINCT (j0_.country) AS sclr_0
FROM
  journal j0_
WHERE
  j0_.country IS NOT NULL
  AND j0_.country <> ?

SELECT DISTINCT (j0_.country) AS sclr_0 FROM journal j0_ WHERE j0_.country IS NOT NULL AND j0_.country <> '';

SELECT
  DISTINCT c0_.name AS name_0,
  c0_.id AS id_1
FROM
  category c0_
WHERE
  c0_.name IS NOT NULL
  AND c0_.name <> ?
ORDER BY
  c0_.name ASC

SELECT DISTINCT c0_.name AS name_0, c0_.id AS id_1 FROM category c0_ WHERE c0_.name IS NOT NULL AND c0_.name <> '' ORDER BY c0_.name ASC;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.link AS link_3,
  t0.description AS description_4,
  t0.image AS image_5
FROM
  future_conference t0

SELECT t0.id AS id_1, t0.title AS title_2, t0.link AS link_3, t0.description AS description_4, t0.image AS image_5 FROM future_conference t0;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3
FROM
  category t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3 FROM category t0;

SELECT
  t0.id AS id_1,
  t0.type AS type_2,
  t0.file_path AS file_path_3
FROM
  media t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.type AS type_2, t0.file_path AS file_path_3 FROM media t0 WHERE t0.id = 21;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.content AS content_3,
  t0.created_at AS created_at_4,
  t0.published_at AS published_at_5,
  t0.updated_at AS updated_at_6,
  t0.slug AS slug_7,
  t0.image_id AS image_id_8
FROM
  post t0

SELECT t0.id AS id_1, t0.title AS title_2, t0.content AS content_3, t0.created_at AS created_at_4, t0.published_at AS published_at_5, t0.updated_at AS updated_at_6, t0.slug AS slug_7, t0.image_id AS image_id_8 FROM post t0;