Query Metrics
15
Database Queries
4
Different statements
102.24 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.48 ms |
SELECT t0.id AS id_1, t0.label AS label_2, t0.description AS description_3, t0.price AS price_4, t0.placeholder_commentary AS placeholder_commentary_5, t0.enable_privatisation AS enable_privatisation_6, t0.enable_reservation AS enable_reservation_7, t0.enable_carte_cadeau AS enable_carte_cadeau_8, t0.tva_ratio AS tva_ratio_9, t0.single_object AS single_object_10, t0.label_button_add AS label_button_add_11, t0.created AS created_12, t0.updated AS updated_13 FROM extra t0 WHERE t0.enable_carte_cadeau = ?
Parameters:
[
1
]
|
| 2 | 0.38 ms |
SELECT t0.id AS id_1, t0.label AS label_2, t0.description AS description_3, t0.placeholder_commentary AS placeholder_commentary_4, t0.deleted_at AS deleted_at_5, t0.price AS price_6, t0.tva_ratio AS tva_ratio_7, t0.extra_id AS extra_id_8, t0.discr FROM abstract_option t0 WHERE t0.extra_id = ? AND t0.discr IN ('optionquantity')
Parameters:
[
1
]
|
| 3 | 0.28 ms |
SELECT t0.id AS id_1, t0.label AS label_2, t0.description AS description_3, t0.placeholder_commentary AS placeholder_commentary_4, t0.deleted_at AS deleted_at_5, t0.extra_id AS extra_id_6, t0.discr FROM abstract_option t0 WHERE t0.extra_id = ? AND t0.discr IN ('optionselect')
Parameters:
[
1
]
|
| 4 | 0.23 ms |
SELECT t0.id AS id_1, t0.label AS label_2, t0.description AS description_3, t0.placeholder_commentary AS placeholder_commentary_4, t0.deleted_at AS deleted_at_5, t0.price AS price_6, t0.tva_ratio AS tva_ratio_7, t0.extra_id AS extra_id_8, t0.discr FROM abstract_option t0 WHERE t0.extra_id = ? AND t0.discr IN ('optionquantity')
Parameters:
[
4
]
|
| 5 | 0.21 ms |
SELECT t0.id AS id_1, t0.label AS label_2, t0.description AS description_3, t0.placeholder_commentary AS placeholder_commentary_4, t0.deleted_at AS deleted_at_5, t0.extra_id AS extra_id_6, t0.discr FROM abstract_option t0 WHERE t0.extra_id = ? AND t0.discr IN ('optionselect')
Parameters:
[
4
]
|
| 6 | 10.91 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.offer AS offer_3, t0.solo AS solo_4, t0.duo AS duo_5, t0.validity AS validity_6, t0.value AS value_7, t0.used AS used_8, t0.max_used AS max_used_9, t0.count_used AS count_used_10, t0.services AS services_11, t0.comment AS comment_12, t0.template_carte_cadeau AS template_carte_cadeau_13, t0.physical_card AS physical_card_14, t0.reste_apayer AS reste_apayer_15, t0.created_at AS created_at_16, t0.delivery_address_id AS delivery_address_id_17, t0.created_from_reservation_id AS created_from_reservation_id_18 FROM code t0 WHERE t0.value = ?
Parameters:
[
"779B3C"
]
|
| 7 | 10.63 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.offer AS offer_3, t0.solo AS solo_4, t0.duo AS duo_5, t0.validity AS validity_6, t0.value AS value_7, t0.used AS used_8, t0.max_used AS max_used_9, t0.count_used AS count_used_10, t0.services AS services_11, t0.comment AS comment_12, t0.template_carte_cadeau AS template_carte_cadeau_13, t0.physical_card AS physical_card_14, t0.reste_apayer AS reste_apayer_15, t0.created_at AS created_at_16, t0.delivery_address_id AS delivery_address_id_17, t0.created_from_reservation_id AS created_from_reservation_id_18 FROM code t0 WHERE t0.value = ?
Parameters:
[
"8A3177"
]
|
| 8 | 9.55 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.offer AS offer_3, t0.solo AS solo_4, t0.duo AS duo_5, t0.validity AS validity_6, t0.value AS value_7, t0.used AS used_8, t0.max_used AS max_used_9, t0.count_used AS count_used_10, t0.services AS services_11, t0.comment AS comment_12, t0.template_carte_cadeau AS template_carte_cadeau_13, t0.physical_card AS physical_card_14, t0.reste_apayer AS reste_apayer_15, t0.created_at AS created_at_16, t0.delivery_address_id AS delivery_address_id_17, t0.created_from_reservation_id AS created_from_reservation_id_18 FROM code t0 WHERE t0.value = ?
Parameters:
[
"79EX5F"
]
|
| 9 | 9.38 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.offer AS offer_3, t0.solo AS solo_4, t0.duo AS duo_5, t0.validity AS validity_6, t0.value AS value_7, t0.used AS used_8, t0.max_used AS max_used_9, t0.count_used AS count_used_10, t0.services AS services_11, t0.comment AS comment_12, t0.template_carte_cadeau AS template_carte_cadeau_13, t0.physical_card AS physical_card_14, t0.reste_apayer AS reste_apayer_15, t0.created_at AS created_at_16, t0.delivery_address_id AS delivery_address_id_17, t0.created_from_reservation_id AS created_from_reservation_id_18 FROM code t0 WHERE t0.value = ?
Parameters:
[
"7C8DF5"
]
|
| 10 | 9.20 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.offer AS offer_3, t0.solo AS solo_4, t0.duo AS duo_5, t0.validity AS validity_6, t0.value AS value_7, t0.used AS used_8, t0.max_used AS max_used_9, t0.count_used AS count_used_10, t0.services AS services_11, t0.comment AS comment_12, t0.template_carte_cadeau AS template_carte_cadeau_13, t0.physical_card AS physical_card_14, t0.reste_apayer AS reste_apayer_15, t0.created_at AS created_at_16, t0.delivery_address_id AS delivery_address_id_17, t0.created_from_reservation_id AS created_from_reservation_id_18 FROM code t0 WHERE t0.value = ?
Parameters:
[
"X58FE6"
]
|
| 11 | 10.78 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.offer AS offer_3, t0.solo AS solo_4, t0.duo AS duo_5, t0.validity AS validity_6, t0.value AS value_7, t0.used AS used_8, t0.max_used AS max_used_9, t0.count_used AS count_used_10, t0.services AS services_11, t0.comment AS comment_12, t0.template_carte_cadeau AS template_carte_cadeau_13, t0.physical_card AS physical_card_14, t0.reste_apayer AS reste_apayer_15, t0.created_at AS created_at_16, t0.delivery_address_id AS delivery_address_id_17, t0.created_from_reservation_id AS created_from_reservation_id_18 FROM code t0 WHERE t0.value = ?
Parameters:
[
"139X31"
]
|
| 12 | 10.78 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.offer AS offer_3, t0.solo AS solo_4, t0.duo AS duo_5, t0.validity AS validity_6, t0.value AS value_7, t0.used AS used_8, t0.max_used AS max_used_9, t0.count_used AS count_used_10, t0.services AS services_11, t0.comment AS comment_12, t0.template_carte_cadeau AS template_carte_cadeau_13, t0.physical_card AS physical_card_14, t0.reste_apayer AS reste_apayer_15, t0.created_at AS created_at_16, t0.delivery_address_id AS delivery_address_id_17, t0.created_from_reservation_id AS created_from_reservation_id_18 FROM code t0 WHERE t0.value = ?
Parameters:
[
"8195F5"
]
|
| 13 | 10.62 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.offer AS offer_3, t0.solo AS solo_4, t0.duo AS duo_5, t0.validity AS validity_6, t0.value AS value_7, t0.used AS used_8, t0.max_used AS max_used_9, t0.count_used AS count_used_10, t0.services AS services_11, t0.comment AS comment_12, t0.template_carte_cadeau AS template_carte_cadeau_13, t0.physical_card AS physical_card_14, t0.reste_apayer AS reste_apayer_15, t0.created_at AS created_at_16, t0.delivery_address_id AS delivery_address_id_17, t0.created_from_reservation_id AS created_from_reservation_id_18 FROM code t0 WHERE t0.value = ?
Parameters:
[
"119316"
]
|
| 14 | 9.52 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.offer AS offer_3, t0.solo AS solo_4, t0.duo AS duo_5, t0.validity AS validity_6, t0.value AS value_7, t0.used AS used_8, t0.max_used AS max_used_9, t0.count_used AS count_used_10, t0.services AS services_11, t0.comment AS comment_12, t0.template_carte_cadeau AS template_carte_cadeau_13, t0.physical_card AS physical_card_14, t0.reste_apayer AS reste_apayer_15, t0.created_at AS created_at_16, t0.delivery_address_id AS delivery_address_id_17, t0.created_from_reservation_id AS created_from_reservation_id_18 FROM code t0 WHERE t0.value = ?
Parameters:
[
"B6B76D"
]
|
| 15 | 9.29 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.offer AS offer_3, t0.solo AS solo_4, t0.duo AS duo_5, t0.validity AS validity_6, t0.value AS value_7, t0.used AS used_8, t0.max_used AS max_used_9, t0.count_used AS count_used_10, t0.services AS services_11, t0.comment AS comment_12, t0.template_carte_cadeau AS template_carte_cadeau_13, t0.physical_card AS physical_card_14, t0.reste_apayer AS reste_apayer_15, t0.created_at AS created_at_16, t0.delivery_address_id AS delivery_address_id_17, t0.created_from_reservation_id AS created_from_reservation_id_18 FROM code t0 WHERE t0.value = ?
Parameters:
[
"D7FD81"
]
|
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\Extra | No errors. |
| App\Entity\AbstractOption | No errors. |
| App\Entity\OptionSelect | No errors. |
| App\Entity\OptionQuantity | No errors. |
| App\Entity\ExtraReservation | No errors. |
| App\Entity\AbstractOptionReservation | No errors. |
| App\Entity\OptionQuantityReservation | No errors. |
| App\Entity\Code | No errors. |
| App\Entity\DeliveryAddress | No errors. |
| App\Entity\Reservation | No errors. |
| App\Entity\Token | No errors. |
| App\Entity\Contact | No errors. |