Query Metrics
11
Database Queries
5
Different statements
7.10 ms
Query time
0
Invalid entities
8
Managed entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 1.10 ms |
SELECT t0.app_id_registration AS app_id_registration_1, t0.app_id_last_login AS app_id_last_login_2, t0.comments AS comments_3, t0.confirmation_token AS confirmation_token_4, t0.email AS email_5, t0.email_canonical AS email_canonical_6, t0.email_change_requested_at AS email_change_requested_at_7, t0.email_change AS email_change_8, t0.enabled AS enabled_9, t0.last_login AS last_login_10, t0.login_count AS login_count_11, t0.password AS password_12, t0.password_requested_at AS password_requested_at_13, t0.phone AS phone_14, t0.registered_at AS registered_at_15, t0.roles AS roles_16, t0.salt AS salt_17, t0.type AS type_18, t0.updated_at AS updated_at_19, t0.username AS username_20, t0.username_canonical AS username_canonical_21, t0.id AS id_22, t0.facebook_id AS facebook_id_23, t0.facebook_token AS facebook_token_24, t0.google_id AS google_id_25, t0.google_token AS google_token_26, t0.registered_to_server AS registered_to_server_27, t0.uuid AS uuid_28, t0.address_address1 AS address_address1_29, t0.address_address2 AS address_address2_30, t0.address_postal_code AS address_postal_code_31, t0.address_post_office_box_number AS address_post_office_box_number_32, t0.address_country AS address_country_33, t0.address_areaLevel1 AS address_areaLevel1_34, t0.address_areaLevel2 AS address_areaLevel2_35, t0.address_locality AS address_locality_36, t0.organization_activity AS organization_activity_37, t0.organization_name AS organization_name_38, t0.organization_code AS organization_code_39, t0.organization_type AS organization_type_40, t0.person_honorific_prefix AS person_honorific_prefix_41, t0.person_given_name AS person_given_name_42, t0.person_family_name AS person_family_name_43, t0.privacy_marketing_emailing AS privacy_marketing_emailing_44, t0.privacy_analytics_cookie AS privacy_analytics_cookie_45, t0.privacy_session_cookie AS privacy_session_cookie_46, t0.discr FROM user t0 WHERE t0.email = ? LIMIT 1
Parameters:
[
"oforsans@gmail.com"
]
|
| 2 | 0.77 ms |
SELECT t0.expiration_date AS expiration_date_1, t0.max_area AS max_area_2, t0.max_properties AS max_properties_3, t0.max_users AS max_users_4, t0.max_shares AS max_shares_5, t0.features AS features_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.id AS id_9, t0.user_id AS user_id_10, t0.subscription_product_id AS subscription_product_id_11 FROM user_user_premium_subscription t0 WHERE t0.user_id = ?
Parameters:
[
4
]
|
| 3 | 0.85 ms |
SELECT t0.code AS code_3, t0.created_at AS created_at_4, t0.description AS description_5, t0.enable AS enable_6, t0.image AS image_7, t0.name AS name_8, t0.updated_at AS updated_at_9, t0.id AS id_10, t0.duration AS duration_11, t0.max_area AS max_area_12, t0.max_users AS max_users_13, t0.max_shares AS max_shares_14, t0.max_properties AS max_properties_15, t0.price_amount AS price_amount_16, t0.price_amount_including_tax AS price_amount_including_tax_17, t0.price_vat_rate AS price_vat_rate_18, t0.price_currency AS price_currency_19, t0.category, t1.duration_extension AS duration_extension_20, t1.max_area_extension AS max_area_extension_21, t1.min_area AS min_area_22 FROM commerce_product t0 LEFT JOIN commerce_subscription_product t1 ON t0.id = t1.id LEFT JOIN commerce_subscription_constant_area t2 ON t0.id = t2.id WHERE t0.id = ?
Parameters:
[
232
]
|
| 4 | 0.70 ms |
SELECT t1.code AS code_2, t1.created_at AS created_at_3, t1.description AS description_4, t1.enable AS enable_5, t1.image AS image_6, t1.name AS name_7, t1.updated_at AS updated_at_8, t1.id AS id_9, t1.duration AS duration_10, t1.max_area AS max_area_11, t1.max_users AS max_users_12, t1.max_shares AS max_shares_13, t1.max_properties AS max_properties_14, t1.price_amount AS price_amount_15, t1.price_amount_including_tax AS price_amount_including_tax_16, t1.price_vat_rate AS price_vat_rate_17, t1.price_currency AS price_currency_18, t1.category FROM commerce_subscription_constant_area t0 INNER JOIN commerce_product t1 ON t0.id = t1.id WHERE t1.code = ? LIMIT 1
Parameters:
[
"MF24_PREMIUM"
]
|
| 5 | 0.58 ms |
SELECT t1.code AS code_2, t1.created_at AS created_at_3, t1.description AS description_4, t1.enable AS enable_5, t1.image AS image_6, t1.name AS name_7, t1.updated_at AS updated_at_8, t1.id AS id_9, t1.duration AS duration_10, t1.max_area AS max_area_11, t1.max_users AS max_users_12, t1.max_shares AS max_shares_13, t1.max_properties AS max_properties_14, t1.price_amount AS price_amount_15, t1.price_amount_including_tax AS price_amount_including_tax_16, t1.price_vat_rate AS price_vat_rate_17, t1.price_currency AS price_currency_18, t0.duration_extension AS duration_extension_19, t0.max_area_extension AS max_area_extension_20, t0.min_area AS min_area_21, t1.category FROM commerce_subscription_product t0 INNER JOIN commerce_product t1 ON t0.id = t1.id WHERE t1.code = ? LIMIT 1
Parameters:
[
"MF24_PREMIUM"
]
|
| 6 | 0.52 ms |
SELECT t1.code AS code_2, t1.created_at AS created_at_3, t1.description AS description_4, t1.enable AS enable_5, t1.image AS image_6, t1.name AS name_7, t1.updated_at AS updated_at_8, t1.id AS id_9, t1.duration AS duration_10, t1.max_area AS max_area_11, t1.max_users AS max_users_12, t1.max_shares AS max_shares_13, t1.max_properties AS max_properties_14, t1.price_amount AS price_amount_15, t1.price_amount_including_tax AS price_amount_including_tax_16, t1.price_vat_rate AS price_vat_rate_17, t1.price_currency AS price_currency_18, t1.category FROM commerce_subscription_constant_area t0 INNER JOIN commerce_product t1 ON t0.id = t1.id WHERE t1.code = ? LIMIT 1
Parameters:
[
"MF25_ESSENTIEL"
]
|
| 7 | 0.57 ms |
SELECT t1.code AS code_2, t1.created_at AS created_at_3, t1.description AS description_4, t1.enable AS enable_5, t1.image AS image_6, t1.name AS name_7, t1.updated_at AS updated_at_8, t1.id AS id_9, t1.duration AS duration_10, t1.max_area AS max_area_11, t1.max_users AS max_users_12, t1.max_shares AS max_shares_13, t1.max_properties AS max_properties_14, t1.price_amount AS price_amount_15, t1.price_amount_including_tax AS price_amount_including_tax_16, t1.price_vat_rate AS price_vat_rate_17, t1.price_currency AS price_currency_18, t1.category FROM commerce_subscription_constant_area t0 INNER JOIN commerce_product t1 ON t0.id = t1.id WHERE t1.code = ? LIMIT 1
Parameters:
[
"MF25_AVANCE"
]
|
| 8 | 0.60 ms |
SELECT t1.code AS code_2, t1.created_at AS created_at_3, t1.description AS description_4, t1.enable AS enable_5, t1.image AS image_6, t1.name AS name_7, t1.updated_at AS updated_at_8, t1.id AS id_9, t1.duration AS duration_10, t1.max_area AS max_area_11, t1.max_users AS max_users_12, t1.max_shares AS max_shares_13, t1.max_properties AS max_properties_14, t1.price_amount AS price_amount_15, t1.price_amount_including_tax AS price_amount_including_tax_16, t1.price_vat_rate AS price_vat_rate_17, t1.price_currency AS price_currency_18, t0.duration_extension AS duration_extension_19, t0.max_area_extension AS max_area_extension_20, t0.min_area AS min_area_21, t1.category FROM commerce_subscription_product t0 INNER JOIN commerce_product t1 ON t0.id = t1.id WHERE t1.code = ? LIMIT 1
Parameters:
[
"MF25_AVANCE"
]
|
| 9 | 0.48 ms |
SELECT t1.code AS code_2, t1.created_at AS created_at_3, t1.description AS description_4, t1.enable AS enable_5, t1.image AS image_6, t1.name AS name_7, t1.updated_at AS updated_at_8, t1.id AS id_9, t1.duration AS duration_10, t1.max_area AS max_area_11, t1.max_users AS max_users_12, t1.max_shares AS max_shares_13, t1.max_properties AS max_properties_14, t1.price_amount AS price_amount_15, t1.price_amount_including_tax AS price_amount_including_tax_16, t1.price_vat_rate AS price_vat_rate_17, t1.price_currency AS price_currency_18, t1.category FROM commerce_subscription_constant_area t0 INNER JOIN commerce_product t1 ON t0.id = t1.id WHERE t1.code = ? LIMIT 1
Parameters:
[
"MF25_EXPERT"
]
|
| 10 | 0.45 ms |
SELECT t1.code AS code_2, t1.created_at AS created_at_3, t1.description AS description_4, t1.enable AS enable_5, t1.image AS image_6, t1.name AS name_7, t1.updated_at AS updated_at_8, t1.id AS id_9, t1.duration AS duration_10, t1.max_area AS max_area_11, t1.max_users AS max_users_12, t1.max_shares AS max_shares_13, t1.max_properties AS max_properties_14, t1.price_amount AS price_amount_15, t1.price_amount_including_tax AS price_amount_including_tax_16, t1.price_vat_rate AS price_vat_rate_17, t1.price_currency AS price_currency_18, t1.category FROM commerce_subscription_constant_area t0 INNER JOIN commerce_product t1 ON t0.id = t1.id WHERE t1.code = ? LIMIT 1
Parameters:
[
"MF25_EXPERT_P"
]
|
| 11 | 0.49 ms |
SELECT t1.code AS code_2, t1.created_at AS created_at_3, t1.description AS description_4, t1.enable AS enable_5, t1.image AS image_6, t1.name AS name_7, t1.updated_at AS updated_at_8, t1.id AS id_9, t1.duration AS duration_10, t1.max_area AS max_area_11, t1.max_users AS max_users_12, t1.max_shares AS max_shares_13, t1.max_properties AS max_properties_14, t1.price_amount AS price_amount_15, t1.price_amount_including_tax AS price_amount_including_tax_16, t1.price_vat_rate AS price_vat_rate_17, t1.price_currency AS price_currency_18, t1.category FROM commerce_subscription_constant_area t0 INNER JOIN commerce_product t1 ON t0.id = t1.id WHERE t1.code = ? LIMIT 1
Parameters:
[
"ETUDIANT_200"
]
|
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.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| App\Entity\Commerce\AbstractMaForetProduct | 6 |
| App\Entity\User\User | 1 |
| App\Entity\Subscription\UserSubscription | 1 |