Symfony Profiler

• Request / Response
• API Platform
• Performance
• Validator
• Forms
• Exception
• Logs 11
• Events
• Routing
• Cache
• Translation 11
• Security
• Twig
• HTTP Client
• Doctrine
• Debug
• Messages
• Emails
• Notifications
• Serializer
• EasyAdmin
• Configuration

Query Metrics

SELECT DISTINCT m0_.id AS id_0, (SELECT COUNT(o1_.id) AS sclr_2 FROM `order` o1_ WHERE o1_.manifest_id = m0_.id) AS sclr_1, m0_.id AS id_3 FROM manifest m0_ LEFT JOIN `order` o2_ ON m0_.id = o2_.manifest_id ORDER BY sclr_1 DESC, m0_.id DESC LIMIT 20

[]

SELECT
  DISTINCT m0_.id AS id_0,
  (
    SELECT
      COUNT(o1_.id) AS sclr_2
    FROM
      `order` o1_
    WHERE
      o1_.manifest_id = m0_.id
  ) AS sclr_1,
  m0_.id AS id_3
FROM
  manifest m0_
  LEFT JOIN `order` o2_ ON m0_.id = o2_.manifest_id
ORDER BY
  sclr_1 DESC,
  m0_.id DESC
LIMIT
  20

SELECT DISTINCT m0_.id AS id_0, (SELECT COUNT(o1_.id) AS sclr_2 FROM `order` o1_ WHERE o1_.manifest_id = m0_.id) AS sclr_1, m0_.id AS id_3 FROM manifest m0_ LEFT JOIN `order` o2_ ON m0_.id = o2_.manifest_id ORDER BY sclr_1 DESC, m0_.id DESC LIMIT 20;

SELECT m0_.id AS id_0, m0_.created_at AS created_at_1, m0_.reference AS reference_2, m0_.data AS data_3, m0_.file AS file_4, m0_.direction_type AS direction_type_5, m0_.status_import AS status_import_6, (SELECT COUNT(o1_.id) AS sclr_8 FROM `order` o1_ WHERE o1_.manifest_id = m0_.id) AS sclr_7 FROM manifest m0_ LEFT JOIN `order` o2_ ON m0_.id = o2_.manifest_id WHERE m0_.id IN (?, ?, ?, ?) ORDER BY sclr_7 DESC, m0_.id DESC

[
  213
  212
  211
  210
]

SELECT
  m0_.id AS id_0,
  m0_.created_at AS created_at_1,
  m0_.reference AS reference_2,
  m0_.data AS data_3,
  m0_.file AS file_4,
  m0_.direction_type AS direction_type_5,
  m0_.status_import AS status_import_6,
  (
    SELECT
      COUNT(o1_.id) AS sclr_8
    FROM
      `order` o1_
    WHERE
      o1_.manifest_id = m0_.id
  ) AS sclr_7
FROM
  manifest m0_
  LEFT JOIN `order` o2_ ON m0_.id = o2_.manifest_id
WHERE
  m0_.id IN (?, ?, ?, ?)
ORDER BY
  sclr_7 DESC,
  m0_.id DESC

SELECT m0_.id AS id_0, m0_.created_at AS created_at_1, m0_.reference AS reference_2, m0_.data AS data_3, m0_.file AS file_4, m0_.direction_type AS direction_type_5, m0_.status_import AS status_import_6, (SELECT COUNT(o1_.id) AS sclr_8 FROM `order` o1_ WHERE o1_.manifest_id = m0_.id) AS sclr_7 FROM manifest m0_ LEFT JOIN `order` o2_ ON m0_.id = o2_.manifest_id WHERE m0_.id IN (213, 212, 211, 210) ORDER BY sclr_7 DESC, m0_.id DESC;

SELECT count(DISTINCT m0_.id) AS sclr_0 FROM manifest m0_ LEFT JOIN `order` o1_ ON m0_.id = o1_.manifest_id

[]

SELECT
  count(DISTINCT m0_.id) AS sclr_0
FROM
  manifest m0_
  LEFT JOIN `order` o1_ ON m0_.id = o1_.manifest_id

SELECT count(DISTINCT m0_.id) AS sclr_0 FROM manifest m0_ LEFT JOIN `order` o1_ ON m0_.id = o1_.manifest_id;

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.tracking_number AS tracking_number_3, t0.data AS data_4, t0.api_status AS api_status_5, t0.status AS status_6, t0.previous_status AS previous_status_7, t0.weight AS weight_8, t0.previous_weight AS previous_weight_9, t0.size AS size_10, t0.previous_size AS previous_size_11, t0.tracking_barcode AS tracking_barcode_12, t0.manifest_id AS manifest_id_13 FROM `order` t0 WHERE t0.manifest_id = ?

[
  213
]

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.tracking_number AS tracking_number_3,
  t0.data AS data_4,
  t0.api_status AS api_status_5,
  t0.status AS status_6,
  t0.previous_status AS previous_status_7,
  t0.weight AS weight_8,
  t0.previous_weight AS previous_weight_9,
  t0.size AS size_10,
  t0.previous_size AS previous_size_11,
  t0.tracking_barcode AS tracking_barcode_12,
  t0.manifest_id AS manifest_id_13
FROM
  `order` t0
WHERE
  t0.manifest_id = ?

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.tracking_number AS tracking_number_3, t0.data AS data_4, t0.api_status AS api_status_5, t0.status AS status_6, t0.previous_status AS previous_status_7, t0.weight AS weight_8, t0.previous_weight AS previous_weight_9, t0.size AS size_10, t0.previous_size AS previous_size_11, t0.tracking_barcode AS tracking_barcode_12, t0.manifest_id AS manifest_id_13 FROM `order` t0 WHERE t0.manifest_id = 213;

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.tracking_number AS tracking_number_3, t0.data AS data_4, t0.api_status AS api_status_5, t0.status AS status_6, t0.previous_status AS previous_status_7, t0.weight AS weight_8, t0.previous_weight AS previous_weight_9, t0.size AS size_10, t0.previous_size AS previous_size_11, t0.tracking_barcode AS tracking_barcode_12, t0.manifest_id AS manifest_id_13 FROM `order` t0 WHERE t0.manifest_id = ?

[
  212
]

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.tracking_number AS tracking_number_3,
  t0.data AS data_4,
  t0.api_status AS api_status_5,
  t0.status AS status_6,
  t0.previous_status AS previous_status_7,
  t0.weight AS weight_8,
  t0.previous_weight AS previous_weight_9,
  t0.size AS size_10,
  t0.previous_size AS previous_size_11,
  t0.tracking_barcode AS tracking_barcode_12,
  t0.manifest_id AS manifest_id_13
FROM
  `order` t0
WHERE
  t0.manifest_id = ?

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.tracking_number AS tracking_number_3, t0.data AS data_4, t0.api_status AS api_status_5, t0.status AS status_6, t0.previous_status AS previous_status_7, t0.weight AS weight_8, t0.previous_weight AS previous_weight_9, t0.size AS size_10, t0.previous_size AS previous_size_11, t0.tracking_barcode AS tracking_barcode_12, t0.manifest_id AS manifest_id_13 FROM `order` t0 WHERE t0.manifest_id = 212;

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.tracking_number AS tracking_number_3, t0.data AS data_4, t0.api_status AS api_status_5, t0.status AS status_6, t0.previous_status AS previous_status_7, t0.weight AS weight_8, t0.previous_weight AS previous_weight_9, t0.size AS size_10, t0.previous_size AS previous_size_11, t0.tracking_barcode AS tracking_barcode_12, t0.manifest_id AS manifest_id_13 FROM `order` t0 WHERE t0.manifest_id = ?

[
  211
]

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.tracking_number AS tracking_number_3,
  t0.data AS data_4,
  t0.api_status AS api_status_5,
  t0.status AS status_6,
  t0.previous_status AS previous_status_7,
  t0.weight AS weight_8,
  t0.previous_weight AS previous_weight_9,
  t0.size AS size_10,
  t0.previous_size AS previous_size_11,
  t0.tracking_barcode AS tracking_barcode_12,
  t0.manifest_id AS manifest_id_13
FROM
  `order` t0
WHERE
  t0.manifest_id = ?

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.tracking_number AS tracking_number_3, t0.data AS data_4, t0.api_status AS api_status_5, t0.status AS status_6, t0.previous_status AS previous_status_7, t0.weight AS weight_8, t0.previous_weight AS previous_weight_9, t0.size AS size_10, t0.previous_size AS previous_size_11, t0.tracking_barcode AS tracking_barcode_12, t0.manifest_id AS manifest_id_13 FROM `order` t0 WHERE t0.manifest_id = 211;

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.tracking_number AS tracking_number_3, t0.data AS data_4, t0.api_status AS api_status_5, t0.status AS status_6, t0.previous_status AS previous_status_7, t0.weight AS weight_8, t0.previous_weight AS previous_weight_9, t0.size AS size_10, t0.previous_size AS previous_size_11, t0.tracking_barcode AS tracking_barcode_12, t0.manifest_id AS manifest_id_13 FROM `order` t0 WHERE t0.manifest_id = ?

[
  210
]

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.tracking_number AS tracking_number_3,
  t0.data AS data_4,
  t0.api_status AS api_status_5,
  t0.status AS status_6,
  t0.previous_status AS previous_status_7,
  t0.weight AS weight_8,
  t0.previous_weight AS previous_weight_9,
  t0.size AS size_10,
  t0.previous_size AS previous_size_11,
  t0.tracking_barcode AS tracking_barcode_12,
  t0.manifest_id AS manifest_id_13
FROM
  `order` t0
WHERE
  t0.manifest_id = ?

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.tracking_number AS tracking_number_3, t0.data AS data_4, t0.api_status AS api_status_5, t0.status AS status_6, t0.previous_status AS previous_status_7, t0.weight AS weight_8, t0.previous_weight AS previous_weight_9, t0.size AS size_10, t0.previous_size AS previous_size_11, t0.tracking_barcode AS tracking_barcode_12, t0.manifest_id AS manifest_id_13 FROM `order` t0 WHERE t0.manifest_id = 210;