https://afimes-crm.wdib.fr/config/1f0106bd-fc97-667c-9927-7fa4ac759abd

Query Metrics

40 Database Queries
8 Different statements
40.99 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
17.44 ms
(42.55%)
1
SELECT p0_.name AS name_0, min(CAST(p0_.value AS decimal)) AS sclr_1, max(CAST(p0_.value AS decimal)) AS sclr_2 FROM product_option p0_ WHERE p0_.name IN ('NAME_MEASURE_VOLUME', 'NAME_COMPARTMENTS_COUNT', 'NAME_MEASURE_LINEAR_METERS', 'NAME_INSURABLE_VALUE') GROUP BY p0_.name
Parameters:
[]
11.96 ms
(29.17%)
28
SELECT t0.answers AS answers_1, t0.id AS id_2, t0.current_question_id AS current_question_id_3, t0.question_id AS question_id_4 FROM next_question t0 WHERE t0.current_question_id = ?
Parameters:
[
  b"\x1EÓÉ$\x19ÿ`,£\x01Ú\x03│Jý\x1F"
]
3.10 ms
(7.55%)
3
SELECT t0.question AS question_1, t0.name AS name_2, t0.position AS position_3, t0.answer_type AS answer_type_4, t0.answer_input AS answer_input_5, t0.choices AS choices_6, t0.id AS id_7, t0.type_id AS type_id_8 FROM question t0 WHERE t0.type_id = ? ORDER BY t0.position ASC
Parameters:
[
  b"\x1EÓÉ$\x19ég©»0Ú\x03│Jý\x1F"
]
2.73 ms
(6.65%)
4
SELECT t0.name AS name_3, t0.id AS id_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.configuration_id AS configuration_id_7, t0.parent_id AS parent_id_8, t0.discr, t2.value AS value_9 FROM configuration_item t0 LEFT JOIN configuration_item_parent t1 ON t0.id = t1.id LEFT JOIN configuration_item_value t2 ON t0.id = t2.id WHERE t0.parent_id = ?
Parameters:
[
  b"\x1F\x01\x06½ü˜n\x00¥¨\x7F¤¬uš½"
]
2.58 ms
(6.30%)
1
SELECT t0.name AS name_3, t0.id AS id_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.configuration_id AS configuration_id_7, t0.parent_id AS parent_id_8, t0.discr, t2.value AS value_9 FROM configuration_item t0 LEFT JOIN configuration_item_parent t1 ON t0.id = t1.id LEFT JOIN configuration_item_value t2 ON t0.id = t2.id WHERE t0.configuration_id = ?
Parameters:
[
  b"\x1F\x01\x06½ü—f|™'\x7F¤¬uš½"
]
1.73 ms
(4.23%)
1
SELECT t0.notify_level AS notify_level_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.prospect_id AS prospect_id_5, t0.type_id AS type_id_6 FROM configuration t0 WHERE t0.id = ?
Parameters:
[
  b"\x1F\x01\x06½ü—f|™'\x7F¤¬uš½"
]
0.77 ms
(1.89%)
1
SELECT t0.name AS name_1, t0.id AS id_2 FROM activity_area t0 ORDER BY t0.name ASC
Parameters:
[]
0.68 ms
(1.66%)
1
SELECT t0.name AS name_1, t0.code AS code_2, t0.id AS id_3 FROM configuration_type t0 ORDER BY t0.name ASC
Parameters:
[]

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.