Symfony Profiler

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

Query Metrics

SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.id AS id_4, t0.warehouse_quantity AS warehouse_quantity_5, t0.quantity AS quantity_6, t0.ordered_quantity AS ordered_quantity_7, t0.unit_cost AS unit_cost_8, t0.total_cost AS total_cost_9, t0.order_number AS order_number_10, t0.ddt AS ddt_11, t0.order_date AS order_date_12, t0.serial_number AS serial_number_13, t0.installation_date AS installation_date_14, t0.expiration_date AS expiration_date_15, t0.jobs_id AS jobs_id_16, t0.material_id AS material_id_17, t0.supplier_id AS supplier_id_18, t0.order_id AS order_id_19 FROM coll_job_material t0 WHERE t0.jobs_id = ?

[
  1
]

SELECT
  t0.created_at AS created_at_1,
  t0.updated_at AS updated_at_2,
  t0.deleted_at AS deleted_at_3,
  t0.id AS id_4,
  t0.warehouse_quantity AS warehouse_quantity_5,
  t0.quantity AS quantity_6,
  t0.ordered_quantity AS ordered_quantity_7,
  t0.unit_cost AS unit_cost_8,
  t0.total_cost AS total_cost_9,
  t0.order_number AS order_number_10,
  t0.ddt AS ddt_11,
  t0.order_date AS order_date_12,
  t0.serial_number AS serial_number_13,
  t0.installation_date AS installation_date_14,
  t0.expiration_date AS expiration_date_15,
  t0.jobs_id AS jobs_id_16,
  t0.material_id AS material_id_17,
  t0.supplier_id AS supplier_id_18,
  t0.order_id AS order_id_19
FROM
  coll_job_material t0
WHERE
  t0.jobs_id = ?

SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.id AS id_4, t0.warehouse_quantity AS warehouse_quantity_5, t0.quantity AS quantity_6, t0.ordered_quantity AS ordered_quantity_7, t0.unit_cost AS unit_cost_8, t0.total_cost AS total_cost_9, t0.order_number AS order_number_10, t0.ddt AS ddt_11, t0.order_date AS order_date_12, t0.serial_number AS serial_number_13, t0.installation_date AS installation_date_14, t0.expiration_date AS expiration_date_15, t0.jobs_id AS jobs_id_16, t0.material_id AS material_id_17, t0.supplier_id AS supplier_id_18, t0.order_id AS order_id_19 FROM coll_job_material t0 WHERE t0.jobs_id = 1;

SELECT j0_.created_at AS created_at_0, j0_.updated_at AS updated_at_1, j0_.deleted_at AS deleted_at_2, j0_.id AS id_3, j0_.expected_man_hours AS expected_man_hours_4, j0_.price_man_hour AS price_man_hour_5, j0_.job_total_price AS job_total_price_6, j0_.total_advanced_payment AS total_advanced_payment_7, j0_.job_offer_price AS job_offer_price_8, j0_.total_work_price AS total_work_price_9, j0_.name AS name_10, j0_.description AS description_11, j0_.status AS status_12, j0_.offer_number AS offer_number_13, j0_.offer_date AS offer_date_14, j0_.job_total_price_material AS job_total_price_material_15, j0_.priority AS priority_16, j0_.offer_acceptance_date AS offer_acceptance_date_17, j0_.relief_enabled AS relief_enabled_18, j0_.installation_enabled AS installation_enabled_19, j0_.material_enabled AS material_enabled_20, j0_.documentation_enabled AS documentation_enabled_21, j0_.documentation_ready AS documentation_ready_22, j0_.order_ref AS order_ref_23, j0_.type AS type_24, j0_.company_id AS company_id_25, j0_.implant_id AS implant_id_26 FROM job j0_ WHERE (j0_.company_id = ? AND j0_.deleted_at IS NULL) AND j0_.type IN (1)

[
  20
]

SELECT
  j0_.created_at AS created_at_0,
  j0_.updated_at AS updated_at_1,
  j0_.deleted_at AS deleted_at_2,
  j0_.id AS id_3,
  j0_.expected_man_hours AS expected_man_hours_4,
  j0_.price_man_hour AS price_man_hour_5,
  j0_.job_total_price AS job_total_price_6,
  j0_.total_advanced_payment AS total_advanced_payment_7,
  j0_.job_offer_price AS job_offer_price_8,
  j0_.total_work_price AS total_work_price_9,
  j0_.name AS name_10,
  j0_.description AS description_11,
  j0_.status AS status_12,
  j0_.offer_number AS offer_number_13,
  j0_.offer_date AS offer_date_14,
  j0_.job_total_price_material AS job_total_price_material_15,
  j0_.priority AS priority_16,
  j0_.offer_acceptance_date AS offer_acceptance_date_17,
  j0_.relief_enabled AS relief_enabled_18,
  j0_.installation_enabled AS installation_enabled_19,
  j0_.material_enabled AS material_enabled_20,
  j0_.documentation_enabled AS documentation_enabled_21,
  j0_.documentation_ready AS documentation_ready_22,
  j0_.order_ref AS order_ref_23,
  j0_.type AS type_24,
  j0_.company_id AS company_id_25,
  j0_.implant_id AS implant_id_26
FROM
  job j0_
WHERE
  (
    j0_.company_id = ?
    AND j0_.deleted_at IS NULL
  )
  AND j0_.type IN (1)

SELECT j0_.created_at AS created_at_0, j0_.updated_at AS updated_at_1, j0_.deleted_at AS deleted_at_2, j0_.id AS id_3, j0_.expected_man_hours AS expected_man_hours_4, j0_.price_man_hour AS price_man_hour_5, j0_.job_total_price AS job_total_price_6, j0_.total_advanced_payment AS total_advanced_payment_7, j0_.job_offer_price AS job_offer_price_8, j0_.total_work_price AS total_work_price_9, j0_.name AS name_10, j0_.description AS description_11, j0_.status AS status_12, j0_.offer_number AS offer_number_13, j0_.offer_date AS offer_date_14, j0_.job_total_price_material AS job_total_price_material_15, j0_.priority AS priority_16, j0_.offer_acceptance_date AS offer_acceptance_date_17, j0_.relief_enabled AS relief_enabled_18, j0_.installation_enabled AS installation_enabled_19, j0_.material_enabled AS material_enabled_20, j0_.documentation_enabled AS documentation_enabled_21, j0_.documentation_ready AS documentation_ready_22, j0_.order_ref AS order_ref_23, j0_.type AS type_24, j0_.company_id AS company_id_25, j0_.implant_id AS implant_id_26 FROM job j0_ WHERE (j0_.company_id = 20 AND j0_.deleted_at IS NULL) AND j0_.type IN (1);

SELECT s0_.created_at AS created_at_0, s0_.updated_at AS updated_at_1, s0_.deleted_at AS deleted_at_2, s0_.id AS id_3, s0_.name AS name_4, s0_.road AS road_5, s0_.house_number AS house_number_6, s0_.city AS city_7, s0_.cap AS cap_8, s0_.province AS province_9, s0_.state AS state_10, s0_.country AS country_11, s0_.company_type AS company_type_12, s0_.phone AS phone_13, s0_.mail AS mail_14 FROM sys_company s0_ WHERE s0_.id = ?

[
  20
]

SELECT
  s0_.created_at AS created_at_0,
  s0_.updated_at AS updated_at_1,
  s0_.deleted_at AS deleted_at_2,
  s0_.id AS id_3,
  s0_.name AS name_4,
  s0_.road AS road_5,
  s0_.house_number AS house_number_6,
  s0_.city AS city_7,
  s0_.cap AS cap_8,
  s0_.province AS province_9,
  s0_.state AS state_10,
  s0_.country AS country_11,
  s0_.company_type AS company_type_12,
  s0_.phone AS phone_13,
  s0_.mail AS mail_14
FROM
  sys_company s0_
WHERE
  s0_.id = ?

SELECT s0_.created_at AS created_at_0, s0_.updated_at AS updated_at_1, s0_.deleted_at AS deleted_at_2, s0_.id AS id_3, s0_.name AS name_4, s0_.road AS road_5, s0_.house_number AS house_number_6, s0_.city AS city_7, s0_.cap AS cap_8, s0_.province AS province_9, s0_.state AS state_10, s0_.country AS country_11, s0_.company_type AS company_type_12, s0_.phone AS phone_13, s0_.mail AS mail_14 FROM sys_company s0_ WHERE s0_.id = 20;

SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.id AS id_4, t0.email AS email_5, t0.roles AS roles_6, t0.username AS username_7, t0.password AS password_8, t0.last_access AS last_access_9 FROM sys_user t0 WHERE t0.id = ?

[
  2
]

SELECT
  t0.created_at AS created_at_1,
  t0.updated_at AS updated_at_2,
  t0.deleted_at AS deleted_at_3,
  t0.id AS id_4,
  t0.email AS email_5,
  t0.roles AS roles_6,
  t0.username AS username_7,
  t0.password AS password_8,
  t0.last_access AS last_access_9
FROM
  sys_user t0
WHERE
  t0.id = ?

SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.id AS id_4, t0.email AS email_5, t0.roles AS roles_6, t0.username AS username_7, t0.password AS password_8, t0.last_access AS last_access_9 FROM sys_user t0 WHERE t0.id = 2;