Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.url AS url_3,
  t0.body AS body_4,
  t0.keywords AS keywords_5,
  t0.description AS description_6,
  t0.ordering AS ordering_7,
  t0.created AS created_8,
  t0.updated AS updated_9,
  t0.deleted AS deleted_10,
  t0.deleted_at AS deleted_at_11,
  t0.journal_id AS journal_id_12,
  t13.id AS id_14,
  t13.title AS title_15,
  t13.abbreviation AS abbreviation_16,
  t13.url AS url_17,
  t13.issn AS issn_18,
  t13.doi AS doi_19,
  t13.ceased AS ceased_20,
  t13.email AS email_21,
  t13.cover_image AS cover_image_22,
  t13.created AS created_23,
  t13.updated AS updated_24,
  t13.deleted AS deleted_25,
  t13.deleted_at AS deleted_at_26,
  t13.group_id AS group_id_27,
  t0.parent_id AS parent_id_28,
  t29.id AS id_30,
  t29.title AS title_31,
  t29.url AS url_32,
  t29.body AS body_33,
  t29.keywords AS keywords_34,
  t29.description AS description_35,
  t29.ordering AS ordering_36,
  t29.created AS created_37,
  t29.updated AS updated_38,
  t29.deleted AS deleted_39,
  t29.deleted_at AS deleted_at_40,
  t29.journal_id AS journal_id_41,
  t29.parent_id AS parent_id_42
FROM
  journal_pages t0
  INNER JOIN journals t13 ON t0.journal_id = t13.id
  LEFT JOIN journal_pages t29 ON t0.parent_id = t29.id
WHERE
  (
    t0.deleted = ?
    AND t0.journal_id = ?
  )
ORDER BY
  t0.ordering ASC

SELECT t0.id AS id_1, t0.title AS title_2, t0.url AS url_3, t0.body AS body_4, t0.keywords AS keywords_5, t0.description AS description_6, t0.ordering AS ordering_7, t0.created AS created_8, t0.updated AS updated_9, t0.deleted AS deleted_10, t0.deleted_at AS deleted_at_11, t0.journal_id AS journal_id_12, t13.id AS id_14, t13.title AS title_15, t13.abbreviation AS abbreviation_16, t13.url AS url_17, t13.issn AS issn_18, t13.doi AS doi_19, t13.ceased AS ceased_20, t13.email AS email_21, t13.cover_image AS cover_image_22, t13.created AS created_23, t13.updated AS updated_24, t13.deleted AS deleted_25, t13.deleted_at AS deleted_at_26, t13.group_id AS group_id_27, t0.parent_id AS parent_id_28, t29.id AS id_30, t29.title AS title_31, t29.url AS url_32, t29.body AS body_33, t29.keywords AS keywords_34, t29.description AS description_35, t29.ordering AS ordering_36, t29.created AS created_37, t29.updated AS updated_38, t29.deleted AS deleted_39, t29.deleted_at AS deleted_at_40, t29.journal_id AS journal_id_41, t29.parent_id AS parent_id_42 FROM journal_pages t0 INNER JOIN journals t13 ON t0.journal_id = t13.id LEFT JOIN journal_pages t29 ON t0.parent_id = t29.id WHERE (t0.deleted = 0 AND t0.journal_id = 'bffa9f00-c60b-4514-8bcf-65d5c2281047') ORDER BY t0.ordering ASC;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.firstname AS firstname_3,
  t0.other_names AS other_names_4,
  t0.email AS email_5,
  t0.affiliations AS affiliations_6,
  t0.created AS created_7,
  t0.updated AS updated_8,
  t0.article_id AS article_id_9
FROM
  authors t0
WHERE
  t0.article_id = ?
ORDER BY
  t0.created ASC

SELECT t0.id AS id_1, t0.title AS title_2, t0.firstname AS firstname_3, t0.other_names AS other_names_4, t0.email AS email_5, t0.affiliations AS affiliations_6, t0.created AS created_7, t0.updated AS updated_8, t0.article_id AS article_id_9 FROM authors t0 WHERE t0.article_id = '2ada5a3f-ac76-482b-ac3c-99d5829f3f27' ORDER BY t0.created ASC;

SELECT
  a0_.id AS id_0,
  a0_.title AS title_1,
  a0_.number AS number_2,
  a0_.page_start AS page_start_3,
  a0_.page_end AS page_end_4,
  a0_.abstract AS abstract_5,
  a0_.full_text AS full_text_6,
  a0_.keywords AS keywords_7,
  a0_.description AS description_8,
  a0_.doi AS doi_9,
  a0_.published AS published_10,
  a0_.publication_date AS publication_date_11,
  a0_.publication_year AS publication_year_12,
  a0_.pdf AS pdf_13,
  a0_.created AS created_14,
  a0_.updated AS updated_15,
  a0_.deleted AS deleted_16,
  a0_.deleted_at AS deleted_at_17,
  a0_.journal_id AS journal_id_18,
  a0_.article_type_id AS article_type_id_19
FROM
  articles a0_
WHERE
  a0_.journal_id = ?
  AND a0_.published = ?
  AND a0_.deleted = ?
ORDER BY
  a0_.publication_date DESC,
  a0_.publication_year DESC
LIMIT
  6 OFFSET 108

SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.number AS number_2, a0_.page_start AS page_start_3, a0_.page_end AS page_end_4, a0_.abstract AS abstract_5, a0_.full_text AS full_text_6, a0_.keywords AS keywords_7, a0_.description AS description_8, a0_.doi AS doi_9, a0_.published AS published_10, a0_.publication_date AS publication_date_11, a0_.publication_year AS publication_year_12, a0_.pdf AS pdf_13, a0_.created AS created_14, a0_.updated AS updated_15, a0_.deleted AS deleted_16, a0_.deleted_at AS deleted_at_17, a0_.journal_id AS journal_id_18, a0_.article_type_id AS article_type_id_19 FROM articles a0_ WHERE a0_.journal_id = 'bffa9f00-c60b-4514-8bcf-65d5c2281047' AND a0_.published = 1 AND a0_.deleted = 0 ORDER BY a0_.publication_date DESC, a0_.publication_year DESC LIMIT 6 OFFSET 108;

SELECT
  t0.id AS id_1,
  t0.downloaded AS downloaded_2,
  t0.printed AS printed_3,
  t0.shared AS shared_4,
  t0.viewed AS viewed_5,
  t0.created AS created_6,
  t0.updated AS updated_7,
  t0.article_id AS article_id_8
FROM
  article_analytics t0
WHERE
  t0.article_id = ?

SELECT t0.id AS id_1, t0.downloaded AS downloaded_2, t0.printed AS printed_3, t0.shared AS shared_4, t0.viewed AS viewed_5, t0.created AS created_6, t0.updated AS updated_7, t0.article_id AS article_id_8 FROM article_analytics t0 WHERE t0.article_id = '2ada5a3f-ac76-482b-ac3c-99d5829f3f27';

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.abbreviation AS abbreviation_3,
  t0.url AS url_4,
  t0.issn AS issn_5,
  t0.doi AS doi_6,
  t0.ceased AS ceased_7,
  t0.email AS email_8,
  t0.cover_image AS cover_image_9,
  t0.created AS created_10,
  t0.updated AS updated_11,
  t0.deleted AS deleted_12,
  t0.deleted_at AS deleted_at_13,
  t0.group_id AS group_id_14,
  t15.id AS id_16,
  t15.name AS name_17,
  t15.created AS created_18,
  t15.updated AS updated_19,
  t15.deleted AS deleted_20,
  t15.deleted_at AS deleted_at_21
FROM
  journals t0
  INNER JOIN journal_groups t15 ON t0.group_id = t15.id
WHERE
  t0.url = ?
  AND t0.deleted = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.title AS title_2, t0.abbreviation AS abbreviation_3, t0.url AS url_4, t0.issn AS issn_5, t0.doi AS doi_6, t0.ceased AS ceased_7, t0.email AS email_8, t0.cover_image AS cover_image_9, t0.created AS created_10, t0.updated AS updated_11, t0.deleted AS deleted_12, t0.deleted_at AS deleted_at_13, t0.group_id AS group_id_14, t15.id AS id_16, t15.name AS name_17, t15.created AS created_18, t15.updated AS updated_19, t15.deleted AS deleted_20, t15.deleted_at AS deleted_at_21 FROM journals t0 INNER JOIN journal_groups t15 ON t0.group_id = t15.id WHERE t0.url = 'ijog' AND t0.deleted = 0 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.created AS created_3,
  t0.updated AS updated_4,
  t0.deleted AS deleted_5,
  t0.deleted_at AS deleted_at_6
FROM
  article_types t0
WHERE
  t0.id IN (?)

SELECT t0.id AS id_1, t0.name AS name_2, t0.created AS created_3, t0.updated AS updated_4, t0.deleted AS deleted_5, t0.deleted_at AS deleted_at_6 FROM article_types t0 WHERE t0.id IN ('9534247a-18b4-455b-b455-4b5af73f07ae');

SELECT
  COUNT(a0_.id) AS sclr_0
FROM
  articles a0_
WHERE
  a0_.journal_id = ?
  AND a0_.published = ?
  AND a0_.deleted = ?

SELECT COUNT(a0_.id) AS sclr_0 FROM articles a0_ WHERE a0_.journal_id = 'bffa9f00-c60b-4514-8bcf-65d5c2281047' AND a0_.published = 1 AND a0_.deleted = 0;