Query Metrics

18 Database Queries
17 Different statements
41.11 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
4.37 ms
(10.63%)
2
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.plain_password AS plain_password_5, t0.name AS name_6, t0.organization AS organization_7, t0.is_deleted AS is_deleted_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.deleted_at AS deleted_at_11, t0.role_id AS role_id_12 FROM user t0 WHERE t0.id = ?
Parameters:
[
  1
]
3.74 ms
(9.11%)
1
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.password AS password_4, t0.ministry AS ministry_5, t0.customer AS customer_6, t0.object AS object_7, t0.object_work_titleholder AS object_work_titleholder_8, t0.description AS description_9, t0.description_work_titleholder AS description_work_titleholder_10, t0.layout AS layout_11, t0.is_locked AS is_locked_12, t0.is_deleted AS is_deleted_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.locked_at AS locked_at_16, t0.deleted_at AS deleted_at_17, t0.mission_contract AS mission_contract_18, t0.mission_market AS mission_market_19, t0.mission_contract_start AS mission_contract_start_20, t0.mission_contract_end AS mission_contract_end_21, t0.mission_amount AS mission_amount_22, t0.company_name AS company_name_23, t0.company_address AS company_address_24, t0.company_email AS company_email_25, t0.company_phone AS company_phone_26, t0.company_contract AS company_contract_27, t0.company_amount AS company_amount_28, t0.contract_price_currency AS contract_price_currency_29, t0.tmp_type AS tmp_type_30, t0.tmp_type_contract AS tmp_type_contract_31, t0.company_currency AS company_currency_32, t0.contract_price_currency_other AS contract_price_currency_other_33, t0.company_currency_other AS company_currency_other_34, t0.company_works_start AS company_works_start_35, t0.works_end AS works_end_36, t0.lifebase_infrastructure AS lifebase_infrastructure_37, t0.lifebase_safety AS lifebase_safety_38, t0.lifebase_epi AS lifebase_epi_39, t0.lifebase_date AS lifebase_date_40, t0.lifebase_place AS lifebase_place_41, t0.lifebase_description AS lifebase_description_42, t0.lifebase_other AS lifebase_other_43, t0.mobile_infrastructure AS mobile_infrastructure_44, t0.mobile_safety AS mobile_safety_45, t0.mobile_epi AS mobile_epi_46, t0.mobile_date AS mobile_date_47, t0.mobile_place AS mobile_place_48, t0.mobile_description AS mobile_description_49, t0.mobile_other AS mobile_other_50, t0.owner_id AS owner_id_51 FROM project t0 WHERE t0.id = ?
Parameters:
[
  "1"
]
3.47 ms
(8.44%)
1
SELECT t0.id AS id_1, t0.type AS type_2, t0.date AS date_3, t0.attendees AS attendees_4, t0.agenda AS agenda_5, t0.worksite_visit AS worksite_visit_6, t0.reminder AS reminder_7, t0.progress AS progress_8, t0.problems AS problems_9, t0.environmental_point AS environmental_point_10, t0.work_forecast AS work_forecast_11, t0.miscellaneous AS miscellaneous_12, t0.other AS other_13, t0.created_at AS created_at_14, t0.project_id AS project_id_15 FROM meeting t0 WHERE t0.project_id = ?
Parameters:
[
  1
]
2.91 ms
(7.07%)
1
SELECT t0.id AS id_1, t0.type AS type_2, t0.valuation AS valuation_3, t0.send_mode AS send_mode_4, t0.remark AS remark_5, t0.receipt_at AS receipt_at_6, t0.observed_at AS observed_at_7, t0.created_at AS created_at_8, t0.project_id AS project_id_9, t0.work_id AS work_id_10 FROM dossier t0 WHERE t0.project_id = ?
Parameters:
[
  1
]
2.90 ms
(7.04%)
1
SELECT t0.id AS id_1, t0.code AS code_2, t0.location AS location_3, t0.pk AS pk_4, t0.work AS work_5, t0.description AS description_6, t0.created_at AS created_at_7, t0.project_id AS project_id_8 FROM WORK t0 WHERE t0.project_id = ?
Parameters:
[
  1
]
2.43 ms
(5.92%)
1
SELECT t0.id AS id_1, t0.type AS type_2, t0.date AS date_3, t0.observation AS observation_4, t0.created_at AS created_at_5, t0.project_id AS project_id_6 FROM observation t0 WHERE t0.project_id = ?
Parameters:
[
  1
]
2.43 ms
(5.90%)
1
SELECT t0.id AS id_1, t0.type AS type_2, t0.fk AS fk_3, t0.name AS name_4, t0.description AS description_5, t0.content AS content_6, t0.filename AS filename_7, t0.filepath AS filepath_8, t0.filesize AS filesize_9, t0.filetype AS filetype_10, t0.filetime AS filetime_11, t0.is_generated AS is_generated_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.project_id AS project_id_15 FROM document t0 WHERE t0.project_id = ?
Parameters:
[
  1
]
2.28 ms
(5.54%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.qualification AS qualification_3, t0.created_at AS created_at_4, t0.project_id AS project_id_5 FROM executive_staff t0 WHERE t0.project_id = ?
Parameters:
[
  1
]
2.14 ms
(5.21%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.date AS date_3, t0.activity AS activity_4, t0.remark AS remark_5, t0.created_at AS created_at_6, t0.project_id AS project_id_7 FROM visitor t0 WHERE t0.project_id = ?
Parameters:
[
  1
]
2.02 ms
(4.92%)
1
SELECT t0.id AS id_1, t0.code AS code_2, t0.type AS type_3, t0.state AS state_4, t0.arrival AS arrival_5, t0.departure AS departure_6, t0.created_at AS created_at_7, t0.project_id AS project_id_8 FROM equipment t0 WHERE t0.project_id = ?
Parameters:
[
  1
]
2.00 ms
(4.87%)
1
SELECT t0.id AS id_1, t0.date AS date_2, t0.description AS description_3, t0.created_at AS created_at_4, t0.project_id AS project_id_5, t0.work_id AS work_id_6 FROM implantation t0 WHERE t0.project_id = ?
Parameters:
[
  1
]
1.98 ms
(4.83%)
1
SELECT t0.id AS id_1, t0.code AS code_2, t0.type AS type_3, t0.start AS start_4, t0.end AS end_5, t0.created_at AS created_at_6, t0.project_id AS project_id_7 FROM schedule t0 WHERE t0.project_id = ?
Parameters:
[
  1
]
1.92 ms
(4.68%)
1
SELECT t0.id AS id_1, t0.date AS date_2, t0.description AS description_3, t0.decision AS decision_4, t0.created_at AS created_at_5, t0.project_id AS project_id_6 FROM materials_reception t0 WHERE t0.project_id = ?
Parameters:
[
  1
]
1.89 ms
(4.59%)
1
SELECT t0.id AS id_1, t0.date AS date_2, t0.works AS works_3, t0.created_at AS created_at_4, t0.project_id AS project_id_5, t0.work_id AS work_id_6 FROM breakpoint t0 WHERE t0.project_id = ?
Parameters:
[
  1
]
1.87 ms
(4.55%)
1
SELECT t0.id AS id_1, t0.date AS date_2, t0.conditions AS conditions_3, t0.lifting_date AS lifting_date_4, t0.decision AS decision_5, t0.created_at AS created_at_6, t0.project_id AS project_id_7, t0.work_id AS work_id_8 FROM technical_reception t0 WHERE t0.project_id = ?
Parameters:
[
  1
]
1.77 ms
(4.30%)
1
SELECT t0.id AS id_1, t0.date AS date_2, t0.decision AS decision_3, t0.created_at AS created_at_4, t0.project_id AS project_id_5 FROM provisional_reception t0 WHERE t0.project_id = ?
Parameters:
[
  1
]
0.99 ms
(2.42%)
1
SELECT t0.id AS id_1, t0.type AS type_2, t0.valuation AS valuation_3, t0.send_mode AS send_mode_4, t0.remark AS remark_5, t0.receipt_at AS receipt_at_6, t0.observed_at AS observed_at_7, t0.created_at AS created_at_8, t0.project_id AS project_id_9, t0.work_id AS work_id_10 FROM dossier t0 WHERE t0.work_id = ?
Parameters:
[
  1
]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping