Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 1
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• HTTP Client
• Doctrine 1
• Debug
• Messages
• E-mails
• Notifications
• Serializer
• Configuration

Query Metrics

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.abbreviation = ? AND t0.deleted = ? LIMIT 1

[
  "mail"
  0
]

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.abbreviation = ?
  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.abbreviation = 'mail' AND t0.deleted = 0 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 = ? AND t0.deleted = ? LIMIT 1

[
  "mail"
  0
]

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 = 'mail' AND t0.deleted = 0 LIMIT 1;

SELECT j0_.id AS id_0, j0_.title AS title_1, j0_.abbreviation AS abbreviation_2, j0_.url AS url_3, j0_.issn AS issn_4, j0_.doi AS doi_5, j0_.ceased AS ceased_6, j0_.email AS email_7, j0_.cover_image AS cover_image_8, j0_.created AS created_9, j0_.updated AS updated_10, j0_.deleted AS deleted_11, j0_.deleted_at AS deleted_at_12, j0_.group_id AS group_id_13 FROM journals j0_ WHERE j0_.deleted = 0 AND (LOWER(TRIM(j0_.url)) = ? OR LOWER(TRIM(j0_.abbreviation)) = ? OR LOWER(TRIM(j0_.url)) = ? OR LOWER(TRIM(j0_.url)) = ? OR LOWER(j0_.title) LIKE ?) LIMIT 1

[
  "mail"
  "mail"
  "mail/"
  "/mail"
  "%mail%"
]

SELECT
  j0_.id AS id_0,
  j0_.title AS title_1,
  j0_.abbreviation AS abbreviation_2,
  j0_.url AS url_3,
  j0_.issn AS issn_4,
  j0_.doi AS doi_5,
  j0_.ceased AS ceased_6,
  j0_.email AS email_7,
  j0_.cover_image AS cover_image_8,
  j0_.created AS created_9,
  j0_.updated AS updated_10,
  j0_.deleted AS deleted_11,
  j0_.deleted_at AS deleted_at_12,
  j0_.group_id AS group_id_13
FROM
  journals j0_
WHERE
  j0_.deleted = 0
  AND (
    LOWER(
      TRIM(j0_.url)
    ) = ?
    OR LOWER(
      TRIM(j0_.abbreviation)
    ) = ?
    OR LOWER(
      TRIM(j0_.url)
    ) = ?
    OR LOWER(
      TRIM(j0_.url)
    ) = ?
    OR LOWER(j0_.title) LIKE ?
  )
LIMIT
  1

SELECT j0_.id AS id_0, j0_.title AS title_1, j0_.abbreviation AS abbreviation_2, j0_.url AS url_3, j0_.issn AS issn_4, j0_.doi AS doi_5, j0_.ceased AS ceased_6, j0_.email AS email_7, j0_.cover_image AS cover_image_8, j0_.created AS created_9, j0_.updated AS updated_10, j0_.deleted AS deleted_11, j0_.deleted_at AS deleted_at_12, j0_.group_id AS group_id_13 FROM journals j0_ WHERE j0_.deleted = 0 AND (LOWER(TRIM(j0_.url)) = 'mail' OR LOWER(TRIM(j0_.abbreviation)) = 'mail' OR LOWER(TRIM(j0_.url)) = 'mail/' OR LOWER(TRIM(j0_.url)) = '/mail' OR LOWER(j0_.title) LIKE '%mail%') LIMIT 1;

SELECT COUNT(*) FROM journals t0 WHERE t0.ceased = ? AND t0.deleted = ?

[
  0
  0
]

SELECT
  COUNT(*)
FROM
  journals t0
WHERE
  t0.ceased = ?
  AND t0.deleted = ?

SELECT COUNT(*) FROM journals t0 WHERE t0.ceased = 0 AND t0.deleted = 0;

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.ceased = ? AND t0.deleted = ? ORDER BY t0.title ASC LIMIT 100

[
  0
  0
]

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.ceased = ?
  AND t0.deleted = ?
ORDER BY
  t0.title ASC
LIMIT
  100

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.ceased = 0 AND t0.deleted = 0 ORDER BY t0.title ASC LIMIT 100;