Query Metrics
40
Database Queries
8
Different statements
37.39 ms
Query time
0
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 0.92 ms |
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\x00ùö»Èn¼ž¦Yòy¨;6"
]
|
2 | 16.88 ms |
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:
[] |
3 | 1.23 ms |
SELECT t0.name AS name_1, t0.id AS id_2 FROM activity_area t0 ORDER BY t0.name ASC
Parameters:
[] |
4 | 0.86 ms |
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:
[] |
5 | 0.91 ms |
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\x00ùö»Èn¼ž¦Yòy¨;6"
]
|
6 | 0.73 ms |
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\x00ùö»Ëk&£=Yòy¨;6"
]
|
7 | 0.57 ms |
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\x00ùö»Ël*¹YYòy¨;6"
]
|
8 | 0.52 ms |
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\x00ùö»Ëlf†xYòy¨;6"
]
|
9 | 0.53 ms |
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\x00ùö»Ël¢¥„Yòy¨;6"
]
|
10 | 0.70 ms |
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"
]
|
11 | 0.60 ms |
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"
]
|
12 | 0.44 ms |
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ÿa¯Ü\x1FÚ\x03│Jý\x1F"
]
|
13 | 0.46 ms |
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ÿbpù█Ú\x03│Jý\x1F"
]
|
14 | 0.47 ms |
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ÿb╩ñ©Ú\x03│Jý\x1F"
]
|
15 | 0.39 ms |
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ÿc$å¿Ú\x03│Jý\x1F"
]
|
16 | 0.39 ms |
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ÿctü\x18Ú\x03│Jý\x1F"
]
|
17 | 0.40 ms |
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ÿc─ë\x1AÚ\x03│Jý\x1F"
]
|
18 | 0.49 ms |
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ÿd\x14º(Ú\x03│Jý\x1F"
]
|
19 | 0.42 ms |
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ÿdZ║mÚ\x03│Jý\x1F"
]
|
20 | 0.42 ms |
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ÿd┤ÜèÚ\x03│Jý\x1F"
]
|
21 | 0.43 ms |
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ÿd·º§Ú\x03│Jý\x1F"
]
|
22 | 0.44 ms |
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ÿe@║xÚ\x03│Jý\x1F"
]
|
23 | 0.38 ms |
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ÿeÉ║|Ú\x03│Jý\x1F"
]
|
24 | 0.54 ms |
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ÓÉ$"▄e4¥aÚ\x03│Jý\x1F"
]
|
25 | 0.43 ms |
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ÓÉ$"Úo\x0E▓\x10Ú\x03│Jý\x1F"
]
|
26 | 0.47 ms |
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ÓÉ$"Ûapú$Ú\x03│Jý\x1F"
]
|
27 | 0.52 ms |
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ÓÉ$"Ûb\x06Æ*Ú\x03│Jý\x1F"
]
|
28 | 0.51 ms |
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ÓÉ$"Ûb─ï\x1CÚ\x03│Jý\x1F"
]
|
29 | 0.40 ms |
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ÓÉ$"Ûc\x14éÔÚ\x03│Jý\x1F"
]
|
30 | 0.37 ms |
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ÓÉ$"Ûcn©|Ú\x03│Jý\x1F"
]
|
31 | 0.39 ms |
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ÓÉ$"Ûc┤©\x18Ú\x03│Jý\x1F"
]
|
32 | 0.53 ms |
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ÓÉ$"kfñ«AÚ\x03│Jý\x1F"
]
|
33 | 0.50 ms |
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ÓÉ$"|`¿ëÂÚ\x03│Jý\x1F"
]
|
34 | 0.52 ms |
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ÓÉ$"|cF©ÄÚ\x03│Jý\x1F"
]
|
35 | 0.55 ms |
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ÓÉ$"|c·▓ÿÚ\x03│Jý\x1F"
]
|
36 | 0.42 ms |
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ÓÉ$"|dJ½_Ú\x03│Jý\x1F"
]
|
37 | 0.43 ms |
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ÓÉ$"|dññ³Ú\x03│Jý\x1F"
]
|
38 | 0.44 ms |
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ÓÉ$"|d¶ÄzÚ\x03│Jý\x1F"
]
|
39 | 0.42 ms |
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ÓÉ$"|e:©╬Ú\x03│Jý\x1F"
]
|
40 | 0.39 ms |
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ÓÉ$"|evç\x11Ú\x03│Jý\x1F"
]
|
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
Class | Mapping errors |
---|---|
App\Entity\Configuration | No errors. |
App\Entity\Prospect | No errors. |
App\Entity\ConfigurationType | No errors. |
App\Entity\ConfigurationItem | No errors. |
App\Entity\ProductOption | No errors. |
App\Entity\ActivityArea | No errors. |
App\Entity\Question | No errors. |
App\Entity\ConfigurationItemParent | No errors. |
App\Entity\ConfigurationItemValue | No errors. |
App\Entity\NextQuestion | No errors. |