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 = 'f3aafa0d-6a5a-48aa-951a-e5467a296a01') ORDER BY t0.ordering ASC;

"COMMIT"

"COMMIT";

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.number AS number_3,
  t0.page_start AS page_start_4,
  t0.page_end AS page_end_5,
  t0.abstract AS abstract_6,
  t0.full_text AS full_text_7,
  t0.keywords AS keywords_8,
  t0.description AS description_9,
  t0.doi AS doi_10,
  t0.published AS published_11,
  t0.publication_date AS publication_date_12,
  t0.publication_year AS publication_year_13,
  t0.pdf AS pdf_14,
  t0.created AS created_15,
  t0.updated AS updated_16,
  t0.deleted AS deleted_17,
  t0.deleted_at AS deleted_at_18,
  t0.journal_id AS journal_id_19,
  t20.id AS id_21,
  t20.title AS title_22,
  t20.abbreviation AS abbreviation_23,
  t20.url AS url_24,
  t20.issn AS issn_25,
  t20.doi AS doi_26,
  t20.ceased AS ceased_27,
  t20.email AS email_28,
  t20.cover_image AS cover_image_29,
  t20.created AS created_30,
  t20.updated AS updated_31,
  t20.deleted AS deleted_32,
  t20.deleted_at AS deleted_at_33,
  t20.group_id AS group_id_34,
  t0.article_type_id AS article_type_id_35,
  t36.id AS id_37,
  t36.name AS name_38,
  t36.created AS created_39,
  t36.updated AS updated_40,
  t36.deleted AS deleted_41,
  t36.deleted_at AS deleted_at_42,
  t43.id AS id_44,
  t43.downloaded AS downloaded_45,
  t43.printed AS printed_46,
  t43.shared AS shared_47,
  t43.viewed AS viewed_48,
  t43.created AS created_49,
  t43.updated AS updated_50,
  t43.article_id AS article_id_51
FROM
  articles t0
  INNER JOIN journals t20 ON t0.journal_id = t20.id
  LEFT JOIN article_types t36 ON t0.article_type_id = t36.id
  LEFT JOIN article_analytics t43 ON t43.article_id = t0.id
WHERE
  t0.number = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.title AS title_2, t0.number AS number_3, t0.page_start AS page_start_4, t0.page_end AS page_end_5, t0.abstract AS abstract_6, t0.full_text AS full_text_7, t0.keywords AS keywords_8, t0.description AS description_9, t0.doi AS doi_10, t0.published AS published_11, t0.publication_date AS publication_date_12, t0.publication_year AS publication_year_13, t0.pdf AS pdf_14, t0.created AS created_15, t0.updated AS updated_16, t0.deleted AS deleted_17, t0.deleted_at AS deleted_at_18, t0.journal_id AS journal_id_19, t20.id AS id_21, t20.title AS title_22, t20.abbreviation AS abbreviation_23, t20.url AS url_24, t20.issn AS issn_25, t20.doi AS doi_26, t20.ceased AS ceased_27, t20.email AS email_28, t20.cover_image AS cover_image_29, t20.created AS created_30, t20.updated AS updated_31, t20.deleted AS deleted_32, t20.deleted_at AS deleted_at_33, t20.group_id AS group_id_34, t0.article_type_id AS article_type_id_35, t36.id AS id_37, t36.name AS name_38, t36.created AS created_39, t36.updated AS updated_40, t36.deleted AS deleted_41, t36.deleted_at AS deleted_at_42, t43.id AS id_44, t43.downloaded AS downloaded_45, t43.printed AS printed_46, t43.shared AS shared_47, t43.viewed AS viewed_48, t43.created AS created_49, t43.updated AS updated_50, t43.article_id AS article_id_51 FROM articles t0 INNER JOIN journals t20 ON t0.journal_id = t20.id LEFT JOIN article_types t36 ON t0.article_type_id = t36.id LEFT JOIN article_analytics t43 ON t43.article_id = t0.id WHERE t0.number = '395502042026' LIMIT 1;

"START TRANSACTION"

"START TRANSACTION";

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 = '12cf118c-095e-400c-ba0f-1d84bee72cd3' ORDER BY t0.created ASC;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.number AS number_3,
  t0.page_start AS page_start_4,
  t0.page_end AS page_end_5,
  t0.abstract AS abstract_6,
  t0.full_text AS full_text_7,
  t0.keywords AS keywords_8,
  t0.description AS description_9,
  t0.doi AS doi_10,
  t0.published AS published_11,
  t0.publication_date AS publication_date_12,
  t0.publication_year AS publication_year_13,
  t0.pdf AS pdf_14,
  t0.created AS created_15,
  t0.updated AS updated_16,
  t0.deleted AS deleted_17,
  t0.deleted_at AS deleted_at_18,
  t0.journal_id AS journal_id_19,
  t20.id AS id_21,
  t20.title AS title_22,
  t20.abbreviation AS abbreviation_23,
  t20.url AS url_24,
  t20.issn AS issn_25,
  t20.doi AS doi_26,
  t20.ceased AS ceased_27,
  t20.email AS email_28,
  t20.cover_image AS cover_image_29,
  t20.created AS created_30,
  t20.updated AS updated_31,
  t20.deleted AS deleted_32,
  t20.deleted_at AS deleted_at_33,
  t20.group_id AS group_id_34,
  t0.article_type_id AS article_type_id_35,
  t36.id AS id_37,
  t36.name AS name_38,
  t36.created AS created_39,
  t36.updated AS updated_40,
  t36.deleted AS deleted_41,
  t36.deleted_at AS deleted_at_42,
  t43.id AS id_44,
  t43.downloaded AS downloaded_45,
  t43.printed AS printed_46,
  t43.shared AS shared_47,
  t43.viewed AS viewed_48,
  t43.created AS created_49,
  t43.updated AS updated_50,
  t43.article_id AS article_id_51
FROM
  articles t0
  INNER JOIN journals t20 ON t0.journal_id = t20.id
  LEFT JOIN article_types t36 ON t0.article_type_id = t36.id
  LEFT JOIN article_analytics t43 ON t43.article_id = t0.id
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.title AS title_2, t0.number AS number_3, t0.page_start AS page_start_4, t0.page_end AS page_end_5, t0.abstract AS abstract_6, t0.full_text AS full_text_7, t0.keywords AS keywords_8, t0.description AS description_9, t0.doi AS doi_10, t0.published AS published_11, t0.publication_date AS publication_date_12, t0.publication_year AS publication_year_13, t0.pdf AS pdf_14, t0.created AS created_15, t0.updated AS updated_16, t0.deleted AS deleted_17, t0.deleted_at AS deleted_at_18, t0.journal_id AS journal_id_19, t20.id AS id_21, t20.title AS title_22, t20.abbreviation AS abbreviation_23, t20.url AS url_24, t20.issn AS issn_25, t20.doi AS doi_26, t20.ceased AS ceased_27, t20.email AS email_28, t20.cover_image AS cover_image_29, t20.created AS created_30, t20.updated AS updated_31, t20.deleted AS deleted_32, t20.deleted_at AS deleted_at_33, t20.group_id AS group_id_34, t0.article_type_id AS article_type_id_35, t36.id AS id_37, t36.name AS name_38, t36.created AS created_39, t36.updated AS updated_40, t36.deleted AS deleted_41, t36.deleted_at AS deleted_at_42, t43.id AS id_44, t43.downloaded AS downloaded_45, t43.printed AS printed_46, t43.shared AS shared_47, t43.viewed AS viewed_48, t43.created AS created_49, t43.updated AS updated_50, t43.article_id AS article_id_51 FROM articles t0 INNER JOIN journals t20 ON t0.journal_id = t20.id LEFT JOIN article_types t36 ON t0.article_type_id = t36.id LEFT JOIN article_analytics t43 ON t43.article_id = t0.id WHERE t0.id = '12cf118c-095e-400c-ba0f-1d84bee72cd3' LIMIT 1;

UPDATE
  article_analytics
SET
  viewed = ?,
  updated = CURRENT_TIMESTAMP
WHERE
  id = ?
  AND updated = ?

UPDATE article_analytics SET viewed = 248, updated = CURRENT_TIMESTAMP WHERE id = 'ffcb33d1-1927-444b-8277-ae7850ceb470' AND updated = '2026-09-01 20:30:16';

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
  journal_groups 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 journal_groups t0 WHERE t0.id IN ('065ae945-8adf-42b7-b67c-69f2f8180043');

SELECT
  updated
FROM
  article_analytics
WHERE
  id = ?

SELECT updated FROM article_analytics WHERE id = 'ffcb33d1-1927-444b-8277-ae7850ceb470';