Query Metrics
5
Database Queries
3
Different statements
1.07 ms
Query time
2
Invalid entities
Queries
default connection
#▲ | Time | Info |
---|---|---|
1 | 0.24 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.16 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.11 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.09 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
#▲ | Time | Info |
---|---|---|
1 | 0.48 ms |
SELECT t0.id AS id_1, t0.roles AS roles_2, t0.password AS password_3, t0.company AS company_4, t0.customer_number AS customer_number_5, t0.firstname AS firstname_6, t0.lastname AS lastname_7, t0.email AS email_8, t0.phone AS phone_9, t0.phone_mobile AS phone_mobile_10, t0.address1 AS address1_11, t0.address2 AS address2_12, t0.postcode AS postcode_13, t0.city AS city_14, t0.country AS country_15, t0.birthday AS birthday_16, t0.gender AS gender_17, t0.solde AS solde_18, t0.date_add AS date_add_19, t0.date_upd AS date_upd_20, t0.comment AS comment_21, t0.statut AS statut_22, t0.active AS active_23, t0.deleted AS deleted_24, t0.reset_token AS reset_token_25 FROM customer t0 WHERE t0.id = ?
Parameters:
[
56685
]
|
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
Class | Mapping errors |
---|---|
App\Entity\Customer\Customer | No errors. |