Symfony Profiler

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
  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
  COUNT(j0_.id) AS sclr_0
FROM
  journal j0_
WHERE
  j0_.category_name LIKE ?
ORDER BY
  j0_.title ASC

SELECT COUNT(j0_.id) AS sclr_0 FROM journal j0_ WHERE j0_.category_name LIKE '%Materials Science (miscellaneous)%' ORDER BY j0_.title ASC;

SELECT
  DISTINCT j0_.id AS id_0,
  j0_.title AS title_1
FROM
  journal j0_
WHERE
  j0_.category_name LIKE ?
ORDER BY
  j0_.title ASC
LIMIT
  10 OFFSET 160

SELECT DISTINCT j0_.id AS id_0, j0_.title AS title_1 FROM journal j0_ WHERE j0_.category_name LIKE '%Materials Science (miscellaneous)%' ORDER BY j0_.title ASC LIMIT 10 OFFSET 160;

SELECT
  COUNT(DISTINCT j0_.id) AS sclr_0
FROM
  journal j0_
WHERE
  j0_.category_name LIKE ?

SELECT COUNT(DISTINCT j0_.id) AS sclr_0 FROM journal j0_ WHERE j0_.category_name LIKE '%Materials Science (miscellaneous)%';

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.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
  j0_.id AS id_0,
  j0_.title AS title_1,
  j0_.category_name AS category_name_2,
  j0_.area AS area_3,
  j0_.guide AS guide_4,
  j0_.publisher AS publisher_5,
  j0_.quartile AS quartile_6,
  j0_.is_open_access AS is_open_access_7,
  j0_.print_issn AS print_issn_8,
  j0_.original_print_issn AS original_print_issn_9,
  j0_.original_eissn AS original_eissn_10,
  j0_.eissn AS eissn_11,
  j0_.citation_count AS citation_count_12,
  j0_.country AS country_13,
  j0_.region AS region_14,
  j0_.hindex AS hindex_15,
  j0_.updated_at AS updated_at_16,
  j0_.scope AS scope_17,
  j0_.email AS email_18,
  j0_.home_page AS home_page_19,
  j0_.start_date_open_licence AS start_date_open_licence_20,
  j0_.langue_manuscript AS langue_manuscript_21,
  j0_.country_publisher AS country_publisher_22,
  j0_.licence AS licence_23,
  j0_.review_url AS review_url_24,
  j0_.aim_scoop_url AS aim_scoop_url_25,
  j0_.weeks_between_submission_publication AS weeks_between_submission_publication_26,
  j0_.added_in_doaj_at AS added_in_doaj_at_27,
  j0_.last_updated_in_doaj_at AS last_updated_in_doaj_at_28,
  j0_.recent_article_added_at AS recent_article_added_at_29,
  j0_.how_to_publish AS how_to_publish_30,
  j0_.sjr AS sjr_31,
  j0_.total_doc_last_year AS total_doc_last_year_32,
  j0_.total_docs_3_years AS total_docs_3_years_33,
  j0_.total_refs AS total_refs_34,
  j0_.total_cites_3_years AS total_cites_3_years_35,
  j0_.citable_docs_3_years AS citable_docs_3_years_36,
  j0_.cites_docs_2_years AS cites_docs_2_years_37,
  j0_.ref_per_doc AS ref_per_doc_38,
  j0_.female AS female_39,
  j0_.overton AS overton_40,
  j0_.sdg AS sdg_41,
  j0_.coverage AS coverage_42,
  j0_.contributor_id AS contributor_id_43
FROM
  journal j0_
WHERE
  j0_.category_name LIKE ?
  AND j0_.id IN (?)
ORDER BY
  j0_.title ASC

SELECT j0_.id AS id_0, j0_.title AS title_1, j0_.category_name AS category_name_2, j0_.area AS area_3, j0_.guide AS guide_4, j0_.publisher AS publisher_5, j0_.quartile AS quartile_6, j0_.is_open_access AS is_open_access_7, j0_.print_issn AS print_issn_8, j0_.original_print_issn AS original_print_issn_9, j0_.original_eissn AS original_eissn_10, j0_.eissn AS eissn_11, j0_.citation_count AS citation_count_12, j0_.country AS country_13, j0_.region AS region_14, j0_.hindex AS hindex_15, j0_.updated_at AS updated_at_16, j0_.scope AS scope_17, j0_.email AS email_18, j0_.home_page AS home_page_19, j0_.start_date_open_licence AS start_date_open_licence_20, j0_.langue_manuscript AS langue_manuscript_21, j0_.country_publisher AS country_publisher_22, j0_.licence AS licence_23, j0_.review_url AS review_url_24, j0_.aim_scoop_url AS aim_scoop_url_25, j0_.weeks_between_submission_publication AS weeks_between_submission_publication_26, j0_.added_in_doaj_at AS added_in_doaj_at_27, j0_.last_updated_in_doaj_at AS last_updated_in_doaj_at_28, j0_.recent_article_added_at AS recent_article_added_at_29, j0_.how_to_publish AS how_to_publish_30, j0_.sjr AS sjr_31, j0_.total_doc_last_year AS total_doc_last_year_32, j0_.total_docs_3_years AS total_docs_3_years_33, j0_.total_refs AS total_refs_34, j0_.total_cites_3_years AS total_cites_3_years_35, j0_.citable_docs_3_years AS citable_docs_3_years_36, j0_.cites_docs_2_years AS cites_docs_2_years_37, j0_.ref_per_doc AS ref_per_doc_38, j0_.female AS female_39, j0_.overton AS overton_40, j0_.sdg AS sdg_41, j0_.coverage AS coverage_42, j0_.contributor_id AS contributor_id_43 FROM journal j0_ WHERE j0_.category_name LIKE '%Materials Science (miscellaneous)%' AND j0_.id IN (15244, 16782, 13935, 27789, 39199, 14414, 24167, 10541, 23361, 17351) ORDER BY j0_.title ASC;