Query Metrics
8
Database Queries
2
Different statements
5.69 ms
Query time
3
Invalid entities
6
Managed entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.96 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"
]
|
| 2 | 0.72 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"
]
|
| 3 | 0.68 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"
]
|
| 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:
[
"MF25_AVANCE"
]
|
| 5 | 0.73 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"
]
|
| 6 | 0.69 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"
]
|
| 7 | 0.59 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"
]
|
| 8 | 0.62 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 |