Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 51
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• HTTP Client
• Doctrine 8
• Migrations
• Debug
• Messages
• Emails
• Notifications
• Configuration

Query Metrics

SELECT t0.id AS id_1, t0.works AS works_2, t0.tools AS tools_3, t0.created_at AS created_at_4, t0.datetime AS datetime_5, t0.number_of_construction_site AS number_of_construction_site_6, t0.update_at AS update_at_7, t0.construction_site_id AS construction_site_id_8 FROM reports_cost t0 WHERE t0.number_of_construction_site = ? AND t0.datetime = ? LIMIT 1

[
  "FRATEUR_CENTRAL"
  "2026-03-09 00:00:00"
]

SELECT
  t0.id AS id_1,
  t0.works AS works_2,
  t0.tools AS tools_3,
  t0.created_at AS created_at_4,
  t0.datetime AS datetime_5,
  t0.number_of_construction_site AS number_of_construction_site_6,
  t0.update_at AS update_at_7,
  t0.construction_site_id AS construction_site_id_8
FROM
  reports_cost t0
WHERE
  t0.number_of_construction_site = ?
  AND t0.datetime = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.works AS works_2, t0.tools AS tools_3, t0.created_at AS created_at_4, t0.datetime AS datetime_5, t0.number_of_construction_site AS number_of_construction_site_6, t0.update_at AS update_at_7, t0.construction_site_id AS construction_site_id_8 FROM reports_cost t0 WHERE t0.number_of_construction_site = 'FRATEUR_CENTRAL' AND t0.datetime = '2026-03-09 00:00:00' LIMIT 1;

SELECT t0.id AS id_1, t0.works AS works_2, t0.tools AS tools_3, t0.created_at AS created_at_4, t0.datetime AS datetime_5, t0.number_of_construction_site AS number_of_construction_site_6, t0.update_at AS update_at_7, t0.construction_site_id AS construction_site_id_8 FROM reports_cost t0 WHERE t0.datetime = ? AND t0.tools = ? AND t0.works = ? LIMIT 1

[
  "2026-03-09 00:00:00"
  "0"
  "391"
]

SELECT
  t0.id AS id_1,
  t0.works AS works_2,
  t0.tools AS tools_3,
  t0.created_at AS created_at_4,
  t0.datetime AS datetime_5,
  t0.number_of_construction_site AS number_of_construction_site_6,
  t0.update_at AS update_at_7,
  t0.construction_site_id AS construction_site_id_8
FROM
  reports_cost t0
WHERE
  t0.datetime = ?
  AND t0.tools = ?
  AND t0.works = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.works AS works_2, t0.tools AS tools_3, t0.created_at AS created_at_4, t0.datetime AS datetime_5, t0.number_of_construction_site AS number_of_construction_site_6, t0.update_at AS update_at_7, t0.construction_site_id AS construction_site_id_8 FROM reports_cost t0 WHERE t0.datetime = '2026-03-09 00:00:00' AND t0.tools = '0' AND t0.works = '391' LIMIT 1;

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.deleted AS deleted_4, t0.created_at AS created_at_5, t0.project_manager AS project_manager_6, t0.engineer AS engineer_7, t0.address_street AS address_street_8, t0.address_city AS address_city_9, t0.address_postcode AS address_postcode_10, t0.price AS price_11, t0.start_date AS start_date_12, t0.end_date AS end_date_13, t0.metries AS metries_14, t0.path_csc AS path_csc_15, t0.number AS number_16, t0.id_planning_cloud AS id_planning_cloud_17, t0.id_lead_planning_cloud AS id_lead_planning_cloud_18, t0.update_at AS update_at_19, t0.master AS master_20, t0.over_tablet AS over_tablet_21, t0.use_previous_review_formula AS use_previous_review_formula_22, t0.csc AS csc_23, t0.date_adjudication AS date_adjudication_24, t0.bail AS bail_25, t0.district AS district_26, t0.invoice_client_address AS invoice_client_address_27, t0.invoice_manager AS invoice_manager_28, t0.invoice_contract AS invoice_contract_29, t0.invoice_remarks AS invoice_remarks_30, t0.disabled AS disabled_31, t0.compare_cs AS compare_cs_32, t0.company_id AS company_id_33, t0.contracting_authority_id AS contracting_authority_id_34, t0.chief_id AS chief_id_35, t0.master_link_id AS master_link_id_36, t0.second_chief_id AS second_chief_id_37, t0.status_id AS status_id_38, t0.dispatching_person_id AS dispatching_person_id_39 FROM construction_site t0 WHERE t0.number = ? AND t0.master = ? AND t0.deleted = ? LIMIT 1

[
  "FRATEUR_CENTRAL"
  0
  0
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.deleted AS deleted_4,
  t0.created_at AS created_at_5,
  t0.project_manager AS project_manager_6,
  t0.engineer AS engineer_7,
  t0.address_street AS address_street_8,
  t0.address_city AS address_city_9,
  t0.address_postcode AS address_postcode_10,
  t0.price AS price_11,
  t0.start_date AS start_date_12,
  t0.end_date AS end_date_13,
  t0.metries AS metries_14,
  t0.path_csc AS path_csc_15,
  t0.number AS number_16,
  t0.id_planning_cloud AS id_planning_cloud_17,
  t0.id_lead_planning_cloud AS id_lead_planning_cloud_18,
  t0.update_at AS update_at_19,
  t0.master AS master_20,
  t0.over_tablet AS over_tablet_21,
  t0.use_previous_review_formula AS use_previous_review_formula_22,
  t0.csc AS csc_23,
  t0.date_adjudication AS date_adjudication_24,
  t0.bail AS bail_25,
  t0.district AS district_26,
  t0.invoice_client_address AS invoice_client_address_27,
  t0.invoice_manager AS invoice_manager_28,
  t0.invoice_contract AS invoice_contract_29,
  t0.invoice_remarks AS invoice_remarks_30,
  t0.disabled AS disabled_31,
  t0.compare_cs AS compare_cs_32,
  t0.company_id AS company_id_33,
  t0.contracting_authority_id AS contracting_authority_id_34,
  t0.chief_id AS chief_id_35,
  t0.master_link_id AS master_link_id_36,
  t0.second_chief_id AS second_chief_id_37,
  t0.status_id AS status_id_38,
  t0.dispatching_person_id AS dispatching_person_id_39
FROM
  construction_site t0
WHERE
  t0.number = ?
  AND t0.master = ?
  AND t0.deleted = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.deleted AS deleted_4, t0.created_at AS created_at_5, t0.project_manager AS project_manager_6, t0.engineer AS engineer_7, t0.address_street AS address_street_8, t0.address_city AS address_city_9, t0.address_postcode AS address_postcode_10, t0.price AS price_11, t0.start_date AS start_date_12, t0.end_date AS end_date_13, t0.metries AS metries_14, t0.path_csc AS path_csc_15, t0.number AS number_16, t0.id_planning_cloud AS id_planning_cloud_17, t0.id_lead_planning_cloud AS id_lead_planning_cloud_18, t0.update_at AS update_at_19, t0.master AS master_20, t0.over_tablet AS over_tablet_21, t0.use_previous_review_formula AS use_previous_review_formula_22, t0.csc AS csc_23, t0.date_adjudication AS date_adjudication_24, t0.bail AS bail_25, t0.district AS district_26, t0.invoice_client_address AS invoice_client_address_27, t0.invoice_manager AS invoice_manager_28, t0.invoice_contract AS invoice_contract_29, t0.invoice_remarks AS invoice_remarks_30, t0.disabled AS disabled_31, t0.compare_cs AS compare_cs_32, t0.company_id AS company_id_33, t0.contracting_authority_id AS contracting_authority_id_34, t0.chief_id AS chief_id_35, t0.master_link_id AS master_link_id_36, t0.second_chief_id AS second_chief_id_37, t0.status_id AS status_id_38, t0.dispatching_person_id AS dispatching_person_id_39 FROM construction_site t0 WHERE t0.number = 'FRATEUR_CENTRAL' AND t0.master = 0 AND t0.deleted = 0 LIMIT 1;

SELECT r0_.id AS id_0, r0_.works AS works_1, r0_.tools AS tools_2, r0_.created_at AS created_at_3, r0_.datetime AS datetime_4, r0_.number_of_construction_site AS number_of_construction_site_5, r0_.update_at AS update_at_6, r0_.construction_site_id AS construction_site_id_7 FROM reports_cost r0_ INNER JOIN construction_site c1_ ON r0_.construction_site_id = c1_.id WHERE DATE_FORMAT(r0_.datetime, '%Y-%m-%d') = ? AND c1_.number NOT LIKE ?

[
  "2026-03-07"
  "%/%"
]

SELECT
  r0_.id AS id_0,
  r0_.works AS works_1,
  r0_.tools AS tools_2,
  r0_.created_at AS created_at_3,
  r0_.datetime AS datetime_4,
  r0_.number_of_construction_site AS number_of_construction_site_5,
  r0_.update_at AS update_at_6,
  r0_.construction_site_id AS construction_site_id_7
FROM
  reports_cost r0_
  INNER JOIN construction_site c1_ ON r0_.construction_site_id = c1_.id
WHERE
  DATE_FORMAT(r0_.datetime, '%Y-%m-%d') = ?
  AND c1_.number NOT LIKE ?

SELECT r0_.id AS id_0, r0_.works AS works_1, r0_.tools AS tools_2, r0_.created_at AS created_at_3, r0_.datetime AS datetime_4, r0_.number_of_construction_site AS number_of_construction_site_5, r0_.update_at AS update_at_6, r0_.construction_site_id AS construction_site_id_7 FROM reports_cost r0_ INNER JOIN construction_site c1_ ON r0_.construction_site_id = c1_.id WHERE DATE_FORMAT(r0_.datetime, '%Y-%m-%d') = '2026-03-07' AND c1_.number NOT LIKE '%/%';

INSERT INTO reports_cost (works, tools, created_at, datetime, number_of_construction_site, update_at, construction_site_id) VALUES (?, ?, ?, ?, ?, ?, ?)

[
  391.0
  0.0
  "2026-03-09 00:00:00"
  "2026-03-09 00:00:00"
  "FRATEUR_CENTRAL"
  "2026-04-07 12:00:02"
  4025
]

INSERT INTO reports_cost (
  works, tools, created_at, datetime,
  number_of_construction_site, update_at,
  construction_site_id
)
VALUES
  (?, ?, ?, ?, ?, ?, ?)

INSERT INTO reports_cost (works, tools, created_at, datetime, number_of_construction_site, update_at, construction_site_id) VALUES (391, 0, '2026-03-09 00:00:00', '2026-03-09 00:00:00', 'FRATEUR_CENTRAL', '2026-04-07 12:00:02', 4025);

DELETE FROM reports_cost WHERE id = ?

[
  1098341
]

DELETE FROM
  reports_cost
WHERE
  id = ?

DELETE FROM reports_cost WHERE id = 1098341;

"COMMIT"

[]

"COMMIT"

"COMMIT";

"START TRANSACTION"

[]

"START TRANSACTION"

"START TRANSACTION";

UPDATE reports_cost SET created_at = ?, datetime = ?, update_at = ? WHERE id = ?

[
  "2026-03-16 00:00:00"
  "2026-03-16 00:00:00"
  "2026-04-07 12:00:05"
  1091812
]

UPDATE
  reports_cost
SET
  created_at = ?,
  datetime = ?,
  update_at = ?
WHERE
  id = ?

UPDATE reports_cost SET created_at = '2026-03-16 00:00:00', datetime = '2026-03-16 00:00:00', update_at = '2026-04-07 12:00:05' WHERE id = 1091812;