Query Metrics
4
Database Queries
2
Different statements
1.20 ms
Query time
2
Invalid entities
Queries
default connection
#▲ | Time | Info |
---|---|---|
1 | 0.36 ms |
SELECT t0.id AS id_1, t0.cart_condition AS cart_condition_2, t0.message AS message_3, t0.title AS title_4, t0.text_button AS text_button_5, t0.lien_externe AS lien_externe_6, t0.formule_test_id AS formule_test_id_7, t8.id AS id_9, t8.designation AS designation_10, t8.code AS code_11, t8.url_formule AS url_formule_12, t8.temps_limite_resa AS temps_limite_resa_13, t8.nbre_mini AS nbre_mini_14, t8.nbre_maxi AS nbre_maxi_15, t8.presence_avant AS presence_avant_16, t8.is_creneau_activity AS is_creneau_activity_17, t8.heure_ouverture_creneau AS heure_ouverture_creneau_18, t8.heure_fermeture_creneau AS heure_fermeture_creneau_19, t8.temps_creneau AS temps_creneau_20, t8.priority AS priority_21, t8.actif AS actif_22, t8.description AS description_23, t8.image AS image_24, t8.updated_at AS updated_at_25, t0.forfait_cible_id AS forfait_cible_id_26, t27.id AS id_28, t27.designation AS designation_29, t27.information AS information_30, t27.is_pass_kids AS is_pass_kids_31, t27.is_pass_famille AS is_pass_famille_32, t27.pass_color AS pass_color_33, t27.nbre_activites AS nbre_activites_34, t27.priority AS priority_35, t27.is_active AS is_active_36, t27.url_forfait AS url_forfait_37, t27.min_participants AS min_participants_38, t27.is_new AS is_new_39, t27.is_shortly AS is_shortly_40, t27.formule_id AS formule_id_41 FROM suggested_offer t0 LEFT JOIN formule t8 ON t0.formule_test_id = t8.id LEFT JOIN forfait t27 ON t0.forfait_cible_id = t27.id
Parameters:
[] |
2 | 0.47 ms |
SELECT t0.id AS id_1, t0.designation AS designation_2, t0.information AS information_3, t0.is_pass_kids AS is_pass_kids_4, t0.is_pass_famille AS is_pass_famille_5, t0.pass_color AS pass_color_6, t0.nbre_activites AS nbre_activites_7, t0.priority AS priority_8, t0.is_active AS is_active_9, t0.url_forfait AS url_forfait_10, t0.min_participants AS min_participants_11, t0.is_new AS is_new_12, t0.is_shortly AS is_shortly_13, t0.formule_id AS formule_id_14 FROM forfait t0 INNER JOIN suggested_offer_forfait ON t0.id = suggested_offer_forfait.forfait_id WHERE suggested_offer_forfait.suggested_offer_id = ?
Parameters:
[
16
]
|
3 | 0.21 ms |
SELECT t0.id AS id_1, t0.designation AS designation_2, t0.information AS information_3, t0.is_pass_kids AS is_pass_kids_4, t0.is_pass_famille AS is_pass_famille_5, t0.pass_color AS pass_color_6, t0.nbre_activites AS nbre_activites_7, t0.priority AS priority_8, t0.is_active AS is_active_9, t0.url_forfait AS url_forfait_10, t0.min_participants AS min_participants_11, t0.is_new AS is_new_12, t0.is_shortly AS is_shortly_13, t0.formule_id AS formule_id_14 FROM forfait t0 INNER JOIN suggested_offer_forfait ON t0.id = suggested_offer_forfait.forfait_id WHERE suggested_offer_forfait.suggested_offer_id = ?
Parameters:
[
17
]
|
4 | 0.15 ms |
SELECT t0.id AS id_1, t0.designation AS designation_2, t0.information AS information_3, t0.is_pass_kids AS is_pass_kids_4, t0.is_pass_famille AS is_pass_famille_5, t0.pass_color AS pass_color_6, t0.nbre_activites AS nbre_activites_7, t0.priority AS priority_8, t0.is_active AS is_active_9, t0.url_forfait AS url_forfait_10, t0.min_participants AS min_participants_11, t0.is_new AS is_new_12, t0.is_shortly AS is_shortly_13, t0.formule_id AS formule_id_14 FROM forfait t0 INNER JOIN suggested_offer_forfait ON t0.id = suggested_offer_forfait.forfait_id WHERE suggested_offer_forfait.suggested_offer_id = ?
Parameters:
[
18
]
|
customer connection
No database queries were performed.
Database Connections
Name | Service |
---|---|
default | doctrine.dbal.default_connection |
customer | doctrine.dbal.customer_connection |
Entity Managers
Name | Service |
---|---|
default | doctrine.orm.default_entity_manager |
customer | doctrine.orm.customer_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Entities Mapping
default entity manager
Class | Mapping errors |
---|---|
App\Entity\Main\SuggestedOffer | No errors. |
App\Entity\Main\Formule | No errors. |
App\Entity\Main\Forfait |
|
App\Entity\Main\Activity |
|
App\Entity\Main\Price | No errors. |
App\Entity\Main\ActivityOptions | No errors. |
App\Entity\Main\Promos | No errors. |
App\Entity\Main\PromosOptions | No errors. |
App\Entity\Main\CartoBon | No errors. |
customer entity manager
No loaded entities.