Symfony Profiler

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

Query Metrics

SELECT t0.id_trello AS id_trello_1, t0.name AS name_2, t0.id AS id_3, t0.deleted_at AS deleted_at_4, t0.created AS created_5, t0.updated AS updated_6, t0.board_id AS board_id_7 FROM trello_card t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))

[
  19706
]

SELECT
  t0.id_trello AS id_trello_1,
  t0.name AS name_2,
  t0.id AS id_3,
  t0.deleted_at AS deleted_at_4,
  t0.created AS created_5,
  t0.updated AS updated_6,
  t0.board_id AS board_id_7
FROM
  trello_card t0
WHERE
  t0.id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.id_trello AS id_trello_1, t0.name AS name_2, t0.id AS id_3, t0.deleted_at AS deleted_at_4, t0.created AS created_5, t0.updated AS updated_6, t0.board_id AS board_id_7 FROM trello_card t0 WHERE t0.id = 19706 AND ((t0.deleted_at IS NULL));

SELECT g0_.id AS id_0, g0_.structure_fixed_cost AS structure_fixed_cost_1, g0_.created AS created_2, g0_.updated AS updated_3 FROM general_setting g0_

[]

SELECT
  g0_.id AS id_0,
  g0_.structure_fixed_cost AS structure_fixed_cost_1,
  g0_.created AS created_2,
  g0_.updated AS updated_3
FROM
  general_setting g0_

SELECT g0_.id AS id_0, g0_.structure_fixed_cost AS structure_fixed_cost_1, g0_.created AS created_2, g0_.updated AS updated_3 FROM general_setting g0_;

SELECT t0.date AS date_1, t0.billed_hours AS billed_hours_2, t0.worked_hours AS worked_hours_3, t0.registered AS registered_4, t0.task_type AS task_type_5, t0.status AS status_6, t0.description AS description_7, t0.id AS id_8, t0.deleted_at AS deleted_at_9, t0.created AS created_10, t0.updated AS updated_11, t0.user_id AS user_id_12, t0.trello_card_id AS trello_card_id_13, t0.customer_id AS customer_id_14, t0.hourly_package_id AS hourly_package_id_15 FROM log t0 WHERE t0.hourly_package_id = ? AND ((t0.deleted_at IS NULL))

[
  343
]

SELECT
  t0.date AS date_1,
  t0.billed_hours AS billed_hours_2,
  t0.worked_hours AS worked_hours_3,
  t0.registered AS registered_4,
  t0.task_type AS task_type_5,
  t0.status AS status_6,
  t0.description AS description_7,
  t0.id AS id_8,
  t0.deleted_at AS deleted_at_9,
  t0.created AS created_10,
  t0.updated AS updated_11,
  t0.user_id AS user_id_12,
  t0.trello_card_id AS trello_card_id_13,
  t0.customer_id AS customer_id_14,
  t0.hourly_package_id AS hourly_package_id_15
FROM
  log t0
WHERE
  t0.hourly_package_id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.date AS date_1, t0.billed_hours AS billed_hours_2, t0.worked_hours AS worked_hours_3, t0.registered AS registered_4, t0.task_type AS task_type_5, t0.status AS status_6, t0.description AS description_7, t0.id AS id_8, t0.deleted_at AS deleted_at_9, t0.created AS created_10, t0.updated AS updated_11, t0.user_id AS user_id_12, t0.trello_card_id AS trello_card_id_13, t0.customer_id AS customer_id_14, t0.hourly_package_id AS hourly_package_id_15 FROM log t0 WHERE t0.hourly_package_id = 343 AND ((t0.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 = ?

[
  7
]

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 = 7;

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

[
  "%conforama%"
  "%conforama%"
  "%conforama%"
]

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

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

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

[
  "%conforama%"
  "%conforama%"
  "%conforama%"
]

SELECT
  count(DISTINCT h0_.id) AS sclr_0
FROM
  hourly_package h0_
  LEFT JOIN customer c1_ ON h0_.customer_id = c1_.id
WHERE
  (
    (
      LOWER(h0_.name) LIKE ?
      OR LOWER(h0_.invoice) LIKE ?
      OR LOWER(c1_.business_name) LIKE ?
    )
    AND h0_.open = 1
  )
  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 WHERE ((LOWER(h0_.name) LIKE '%conforama%' OR LOWER(h0_.invoice) LIKE '%conforama%' OR LOWER(c1_.business_name) LIKE '%conforama%') AND h0_.open = 1) AND (h0_.deleted_at IS NULL);

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 WHERE ((LOWER(h0_.name) LIKE ? OR LOWER(h0_.invoice) LIKE ? OR LOWER(c1_.business_name) LIKE ?) AND h0_.open = 1 AND h0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) AND (h0_.deleted_at IS NULL) ORDER BY c1_.business_name ASC

[
  "%conforama%"
  "%conforama%"
  "%conforama%"
  343
  361
  373
  381
  385
  405
  408
  416
  418
  421
  427
]

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
WHERE
  (
    (
      LOWER(h0_.name) LIKE ?
      OR LOWER(h0_.invoice) LIKE ?
      OR LOWER(c1_.business_name) LIKE ?
    )
    AND h0_.open = 1
    AND h0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
  )
  AND (h0_.deleted_at IS NULL)
ORDER BY
  c1_.business_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 WHERE ((LOWER(h0_.name) LIKE '%conforama%' OR LOWER(h0_.invoice) LIKE '%conforama%' OR LOWER(c1_.business_name) LIKE '%conforama%') AND h0_.open = 1 AND h0_.id IN (343, 361, 373, 381, 385, 405, 408, 416, 418, 421, 427)) AND (h0_.deleted_at IS NULL) ORDER BY c1_.business_name ASC;

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 = ?

[
  54
]

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 = 54;