Symfony Profiler

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

Query Metrics

SELECT DISTINCT h0_.id AS id_0, h0_.name AS name_1 FROM hourly_package h0_ LEFT JOIN customer c1_ ON h0_.customer_id = c1_.id INNER JOIN customer c2_ ON h0_.customer_id = c2_.id WHERE ((LOWER(h0_.name) LIKE ? OR LOWER(h0_.invoice) LIKE ? OR LOWER(c1_.business_name) LIKE ?) AND h0_.open = 1 AND c2_.id = ? AND h0_.name LIKE ?) AND (h0_.deleted_at IS NULL) ORDER BY h0_.name ASC LIMIT 30

[
  "%u%"
  "%u%"
  "%u%"
  "67"
  "%u%"
]

SELECT
  DISTINCT h0_.id AS id_0,
  h0_.name AS name_1
FROM
  hourly_package h0_
  LEFT JOIN customer c1_ ON h0_.customer_id = c1_.id
  INNER JOIN customer c2_ ON h0_.customer_id = c2_.id
WHERE
  (
    (
      LOWER(h0_.name) LIKE ?
      OR LOWER(h0_.invoice) LIKE ?
      OR LOWER(c1_.business_name) LIKE ?
    )
    AND h0_.open = 1
    AND c2_.id = ?
    AND h0_.name LIKE ?
  )
  AND (h0_.deleted_at IS NULL)
ORDER BY
  h0_.name ASC
LIMIT
  30

SELECT DISTINCT h0_.id AS id_0, h0_.name AS name_1 FROM hourly_package h0_ LEFT JOIN customer c1_ ON h0_.customer_id = c1_.id INNER JOIN customer c2_ ON h0_.customer_id = c2_.id WHERE ((LOWER(h0_.name) LIKE '%u%' OR LOWER(h0_.invoice) LIKE '%u%' OR LOWER(c1_.business_name) LIKE '%u%') AND h0_.open = 1 AND c2_.id = '67' AND h0_.name LIKE '%u%') AND (h0_.deleted_at IS NULL) ORDER BY h0_.name ASC LIMIT 30;

SELECT h0_.name AS name_0, h0_.type AS type_1, h0_.hours AS hours_2, h0_.invoice AS invoice_3, h0_.notes AS notes_4, h0_.open AS open_5, h0_.hourly_sell_cost AS hourly_sell_cost_6, h0_.reem_hours AS reem_hours_7, h0_.id AS id_8, h0_.deleted_at AS deleted_at_9, h0_.created AS created_10, h0_.updated AS updated_11, h0_.customer_id AS customer_id_12 FROM hourly_package h0_ LEFT JOIN customer c1_ ON h0_.customer_id = c1_.id INNER JOIN customer c2_ ON h0_.customer_id = c2_.id WHERE ((LOWER(h0_.name) LIKE ? OR LOWER(h0_.invoice) LIKE ? OR LOWER(c1_.business_name) LIKE ?) AND h0_.open = 1 AND c2_.id = ? AND h0_.name LIKE ? AND h0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) AND (h0_.deleted_at IS NULL) ORDER BY h0_.name ASC

[
  "%u%"
  "%u%"
  "%u%"
  "67"
  "%u%"
  398
  447
  414
  435
  424
  466
  476
  453
  443
  400
  387
  377
  448
  413
  436
  423
  467
  477
  454
  444
  401
  388
  380
]

SELECT
  h0_.name AS name_0,
  h0_.type AS type_1,
  h0_.hours AS hours_2,
  h0_.invoice AS invoice_3,
  h0_.notes AS notes_4,
  h0_.open AS open_5,
  h0_.hourly_sell_cost AS hourly_sell_cost_6,
  h0_.reem_hours AS reem_hours_7,
  h0_.id AS id_8,
  h0_.deleted_at AS deleted_at_9,
  h0_.created AS created_10,
  h0_.updated AS updated_11,
  h0_.customer_id AS customer_id_12
FROM
  hourly_package h0_
  LEFT JOIN customer c1_ ON h0_.customer_id = c1_.id
  INNER JOIN customer c2_ ON h0_.customer_id = c2_.id
WHERE
  (
    (
      LOWER(h0_.name) LIKE ?
      OR LOWER(h0_.invoice) LIKE ?
      OR LOWER(c1_.business_name) LIKE ?
    )
    AND h0_.open = 1
    AND c2_.id = ?
    AND h0_.name LIKE ?
    AND h0_.id IN (
      ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
      ?, ?, ?, ?, ?, ?, ?
    )
  )
  AND (h0_.deleted_at IS NULL)
ORDER BY
  h0_.name ASC

SELECT h0_.name AS name_0, h0_.type AS type_1, h0_.hours AS hours_2, h0_.invoice AS invoice_3, h0_.notes AS notes_4, h0_.open AS open_5, h0_.hourly_sell_cost AS hourly_sell_cost_6, h0_.reem_hours AS reem_hours_7, h0_.id AS id_8, h0_.deleted_at AS deleted_at_9, h0_.created AS created_10, h0_.updated AS updated_11, h0_.customer_id AS customer_id_12 FROM hourly_package h0_ LEFT JOIN customer c1_ ON h0_.customer_id = c1_.id INNER JOIN customer c2_ ON h0_.customer_id = c2_.id WHERE ((LOWER(h0_.name) LIKE '%u%' OR LOWER(h0_.invoice) LIKE '%u%' OR LOWER(c1_.business_name) LIKE '%u%') AND h0_.open = 1 AND c2_.id = '67' AND h0_.name LIKE '%u%' AND h0_.id IN (398, 447, 414, 435, 424, 466, 476, 453, 443, 400, 387, 377, 448, 413, 436, 423, 467, 477, 454, 444, 401, 388, 380)) AND (h0_.deleted_at IS NULL) ORDER BY h0_.name ASC;

SELECT count(DISTINCT h0_.id) AS sclr_0 FROM hourly_package h0_ LEFT JOIN customer c1_ ON h0_.customer_id = c1_.id INNER JOIN customer c2_ ON h0_.customer_id = c2_.id WHERE ((LOWER(h0_.name) LIKE ? OR LOWER(h0_.invoice) LIKE ? OR LOWER(c1_.business_name) LIKE ?) AND h0_.open = 1 AND c2_.id = ? AND h0_.name LIKE ?) AND (h0_.deleted_at IS NULL)

[
  "%u%"
  "%u%"
  "%u%"
  "67"
  "%u%"
]

SELECT
  count(DISTINCT h0_.id) AS sclr_0
FROM
  hourly_package h0_
  LEFT JOIN customer c1_ ON h0_.customer_id = c1_.id
  INNER JOIN customer c2_ ON h0_.customer_id = c2_.id
WHERE
  (
    (
      LOWER(h0_.name) LIKE ?
      OR LOWER(h0_.invoice) LIKE ?
      OR LOWER(c1_.business_name) LIKE ?
    )
    AND h0_.open = 1
    AND c2_.id = ?
    AND h0_.name LIKE ?
  )
  AND (h0_.deleted_at IS NULL)

SELECT count(DISTINCT h0_.id) AS sclr_0 FROM hourly_package h0_ LEFT JOIN customer c1_ ON h0_.customer_id = c1_.id INNER JOIN customer c2_ ON h0_.customer_id = c2_.id WHERE ((LOWER(h0_.name) LIKE '%u%' OR LOWER(h0_.invoice) LIKE '%u%' OR LOWER(c1_.business_name) LIKE '%u%') AND h0_.open = 1 AND c2_.id = '67' AND h0_.name LIKE '%u%') AND (h0_.deleted_at IS NULL);

SELECT t0.email AS email_1, t0.roles AS roles_2, t0.password AS password_3, t0.firstname AS firstname_4, t0.lastname AS lastname_5, t0.active AS active_6, t0.deactivated_at AS deactivated_at_7, t0.hourly_resource_cost AS hourly_resource_cost_8, t0.id AS id_9, t0.uuid AS uuid_10, t0.created AS created_11, t0.updated AS updated_12, t0.hourly_package_id AS hourly_package_id_13 FROM `user` t0 WHERE t0.id = ?

[
  6
]

SELECT
  t0.email AS email_1,
  t0.roles AS roles_2,
  t0.password AS password_3,
  t0.firstname AS firstname_4,
  t0.lastname AS lastname_5,
  t0.active AS active_6,
  t0.deactivated_at AS deactivated_at_7,
  t0.hourly_resource_cost AS hourly_resource_cost_8,
  t0.id AS id_9,
  t0.uuid AS uuid_10,
  t0.created AS created_11,
  t0.updated AS updated_12,
  t0.hourly_package_id AS hourly_package_id_13
FROM
  `user` t0
WHERE
  t0.id = ?

SELECT t0.email AS email_1, t0.roles AS roles_2, t0.password AS password_3, t0.firstname AS firstname_4, t0.lastname AS lastname_5, t0.active AS active_6, t0.deactivated_at AS deactivated_at_7, t0.hourly_resource_cost AS hourly_resource_cost_8, t0.id AS id_9, t0.uuid AS uuid_10, t0.created AS created_11, t0.updated AS updated_12, t0.hourly_package_id AS hourly_package_id_13 FROM `user` t0 WHERE t0.id = 6;

SELECT t0.id_magento AS id_magento_1, t0.business_name AS business_name_2, t0.vat AS vat_3, t0.commercial_reference AS commercial_reference_4, t0.commercial_emails AS commercial_emails_5, t0.active AS active_6, t0.deactivated_at AS deactivated_at_7, t0.id AS id_8, t0.created AS created_9, t0.updated AS updated_10 FROM customer t0 WHERE t0.id = ?

[
  67
]

SELECT
  t0.id_magento AS id_magento_1,
  t0.business_name AS business_name_2,
  t0.vat AS vat_3,
  t0.commercial_reference AS commercial_reference_4,
  t0.commercial_emails AS commercial_emails_5,
  t0.active AS active_6,
  t0.deactivated_at AS deactivated_at_7,
  t0.id AS id_8,
  t0.created AS created_9,
  t0.updated AS updated_10
FROM
  customer t0
WHERE
  t0.id = ?

SELECT t0.id_magento AS id_magento_1, t0.business_name AS business_name_2, t0.vat AS vat_3, t0.commercial_reference AS commercial_reference_4, t0.commercial_emails AS commercial_emails_5, t0.active AS active_6, t0.deactivated_at AS deactivated_at_7, t0.id AS id_8, t0.created AS created_9, t0.updated AS updated_10 FROM customer t0 WHERE t0.id = 67;