Query Metrics
21
Database Queries
9
Different statements
256.46 ms
Query time
6
Invalid entities
Queries
default connection
| #▲ | Time | Info |
|---|---|---|
| 1 | 78.72 ms |
SELECT o0_.id AS id_0, o0_.order_number AS order_number_1, o0_.price AS price_2, o0_.status AS status_3, o0_.shipping_name AS shipping_name_4, o0_.shipping_address AS shipping_address_5, o0_.shipping_postcode AS shipping_postcode_6, o0_.shipping_city AS shipping_city_7, o0_.invoce_name AS invoce_name_8, o0_.invode_address AS invode_address_9, o0_.invoce_postcode AS invoce_postcode_10, o0_.invoce_city AS invoce_city_11, o0_.comment AS comment_12, o0_.is_done AS is_done_13, o0_.user_id AS user_id_14, o0_.pharmacy_id AS pharmacy_id_15, o0_.created_at AS created_at_16, o0_.updated_at AS updated_at_17, o0_.shipping_type_id AS shipping_type_id_18, o0_.payment_method_id AS payment_method_id_19 FROM orders o0_ WHERE o0_.created_at BETWEEN ? AND ?
Parameters:
[ "2026-02-08 00:00:00" "2026-02-11 04:16:57" ] |
| 2 | 8.71 ms |
SELECT p0_.id AS id_0, p0_.is_active AS is_active_1, p0_.pharmacode AS pharmacode_2, p0_.gtin AS gtin_3, p0_.price AS price_4, p0_.prevent_image_update AS prevent_image_update_5, p0_.has360 AS has360_6, p0_.has_back_image AS has_back_image_7, p0_.has_info_patient AS has_info_patient_8, p0_.has_info_pro AS has_info_pro_9, p0_.price_promotion AS price_promotion_10, p0_.start_promotion AS start_promotion_11, p0_.end_promotion AS end_promotion_12, p0_.prdno AS prdno_13, p0_.stock AS stock_14, p0_.recommanded AS recommanded_15, p0_.best_seller AS best_seller_16, p0_.custom_vente AS custom_vente_17, p0_.created_at AS created_at_18, p0_.updated_at AS updated_at_19, p0_.brand_id AS brand_id_20 FROM products p0_ WHERE p0_.best_seller = 1 LIMIT 12
Parameters:
[] |
| 3 | 72.46 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.meta_description AS meta_description_4, t0.meta_keyword AS meta_keyword_5, t0.slug AS slug_6, t0.image AS image_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.locale AS locale_10, t0.translatable_id AS translatable_id_11, t12.id AS id_13, t12.is_active AS is_active_14, t12.pharmacode AS pharmacode_15, t12.gtin AS gtin_16, t12.price AS price_17, t12.prevent_image_update AS prevent_image_update_18, t12.has360 AS has360_19, t12.has_back_image AS has_back_image_20, t12.has_info_patient AS has_info_patient_21, t12.has_info_pro AS has_info_pro_22, t12.price_promotion AS price_promotion_23, t12.start_promotion AS start_promotion_24, t12.end_promotion AS end_promotion_25, t12.prdno AS prdno_26, t12.stock AS stock_27, t12.recommanded AS recommanded_28, t12.best_seller AS best_seller_29, t12.custom_vente AS custom_vente_30, t12.created_at AS created_at_31, t12.updated_at AS updated_at_32, t12.brand_id AS brand_id_33 FROM products_translation t0 LEFT JOIN products t12 ON t0.translatable_id = t12.id WHERE t0.translatable_id = ?
Parameters:
[
9392
]
|
| 4 | 0.63 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.meta_description AS meta_description_4, t0.meta_keyword AS meta_keyword_5, t0.slug AS slug_6, t0.image AS image_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.locale AS locale_10, t0.translatable_id AS translatable_id_11, t12.id AS id_13, t12.is_active AS is_active_14, t12.pharmacode AS pharmacode_15, t12.gtin AS gtin_16, t12.price AS price_17, t12.prevent_image_update AS prevent_image_update_18, t12.has360 AS has360_19, t12.has_back_image AS has_back_image_20, t12.has_info_patient AS has_info_patient_21, t12.has_info_pro AS has_info_pro_22, t12.price_promotion AS price_promotion_23, t12.start_promotion AS start_promotion_24, t12.end_promotion AS end_promotion_25, t12.prdno AS prdno_26, t12.stock AS stock_27, t12.recommanded AS recommanded_28, t12.best_seller AS best_seller_29, t12.custom_vente AS custom_vente_30, t12.created_at AS created_at_31, t12.updated_at AS updated_at_32, t12.brand_id AS brand_id_33 FROM products_translation t0 LEFT JOIN products t12 ON t0.translatable_id = t12.id WHERE t0.translatable_id = ?
Parameters:
[
9420
]
|
| 5 | 0.41 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.meta_description AS meta_description_4, t0.meta_keyword AS meta_keyword_5, t0.slug AS slug_6, t0.image AS image_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.locale AS locale_10, t0.translatable_id AS translatable_id_11, t12.id AS id_13, t12.is_active AS is_active_14, t12.pharmacode AS pharmacode_15, t12.gtin AS gtin_16, t12.price AS price_17, t12.prevent_image_update AS prevent_image_update_18, t12.has360 AS has360_19, t12.has_back_image AS has_back_image_20, t12.has_info_patient AS has_info_patient_21, t12.has_info_pro AS has_info_pro_22, t12.price_promotion AS price_promotion_23, t12.start_promotion AS start_promotion_24, t12.end_promotion AS end_promotion_25, t12.prdno AS prdno_26, t12.stock AS stock_27, t12.recommanded AS recommanded_28, t12.best_seller AS best_seller_29, t12.custom_vente AS custom_vente_30, t12.created_at AS created_at_31, t12.updated_at AS updated_at_32, t12.brand_id AS brand_id_33 FROM products_translation t0 LEFT JOIN products t12 ON t0.translatable_id = t12.id WHERE t0.translatable_id = ?
Parameters:
[
9433
]
|
| 6 | 5.93 ms |
SELECT p0_.id AS id_0, p0_.is_active AS is_active_1, p0_.pharmacode AS pharmacode_2, p0_.gtin AS gtin_3, p0_.price AS price_4, p0_.prevent_image_update AS prevent_image_update_5, p0_.has360 AS has360_6, p0_.has_back_image AS has_back_image_7, p0_.has_info_patient AS has_info_patient_8, p0_.has_info_pro AS has_info_pro_9, p0_.price_promotion AS price_promotion_10, p0_.start_promotion AS start_promotion_11, p0_.end_promotion AS end_promotion_12, p0_.prdno AS prdno_13, p0_.stock AS stock_14, p0_.recommanded AS recommanded_15, p0_.best_seller AS best_seller_16, p0_.custom_vente AS custom_vente_17, p0_.created_at AS created_at_18, p0_.updated_at AS updated_at_19, p0_.brand_id AS brand_id_20 FROM products p0_ WHERE p0_.recommanded = 1 LIMIT 12
Parameters:
[] |
| 7 | 8.34 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.meta_description AS meta_description_4, t0.meta_keyword AS meta_keyword_5, t0.slug AS slug_6, t0.image AS image_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.locale AS locale_10, t0.translatable_id AS translatable_id_11, t12.id AS id_13, t12.is_active AS is_active_14, t12.pharmacode AS pharmacode_15, t12.gtin AS gtin_16, t12.price AS price_17, t12.prevent_image_update AS prevent_image_update_18, t12.has360 AS has360_19, t12.has_back_image AS has_back_image_20, t12.has_info_patient AS has_info_patient_21, t12.has_info_pro AS has_info_pro_22, t12.price_promotion AS price_promotion_23, t12.start_promotion AS start_promotion_24, t12.end_promotion AS end_promotion_25, t12.prdno AS prdno_26, t12.stock AS stock_27, t12.recommanded AS recommanded_28, t12.best_seller AS best_seller_29, t12.custom_vente AS custom_vente_30, t12.created_at AS created_at_31, t12.updated_at AS updated_at_32, t12.brand_id AS brand_id_33 FROM products_translation t0 LEFT JOIN products t12 ON t0.translatable_id = t12.id WHERE t0.translatable_id = ?
Parameters:
[
9446
]
|
| 8 | 0.52 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.meta_description AS meta_description_4, t0.meta_keyword AS meta_keyword_5, t0.slug AS slug_6, t0.image AS image_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.locale AS locale_10, t0.translatable_id AS translatable_id_11, t12.id AS id_13, t12.is_active AS is_active_14, t12.pharmacode AS pharmacode_15, t12.gtin AS gtin_16, t12.price AS price_17, t12.prevent_image_update AS prevent_image_update_18, t12.has360 AS has360_19, t12.has_back_image AS has_back_image_20, t12.has_info_patient AS has_info_patient_21, t12.has_info_pro AS has_info_pro_22, t12.price_promotion AS price_promotion_23, t12.start_promotion AS start_promotion_24, t12.end_promotion AS end_promotion_25, t12.prdno AS prdno_26, t12.stock AS stock_27, t12.recommanded AS recommanded_28, t12.best_seller AS best_seller_29, t12.custom_vente AS custom_vente_30, t12.created_at AS created_at_31, t12.updated_at AS updated_at_32, t12.brand_id AS brand_id_33 FROM products_translation t0 LEFT JOIN products t12 ON t0.translatable_id = t12.id WHERE t0.translatable_id = ?
Parameters:
[
9456
]
|
| 9 | 4.47 ms |
SELECT p0_.id AS id_0, p1_.name AS name_1, COUNT(o2_.id) AS sclr_2 FROM orders_products o2_ LEFT JOIN pharmacies_products p3_ ON o2_.pharmacies_products_id = p3_.id LEFT JOIN products p4_ ON p3_.product_id = p4_.id LEFT JOIN products_categories_products p5_ ON p4_.id = p5_.products_id LEFT JOIN products_categories p0_ ON p0_.id = p5_.products_categories_id INNER JOIN products_categories_translation p1_ ON p0_.id = p1_.translatable_id WHERE p1_.locale = ? GROUP BY p0_.id ORDER BY sclr_2 DESC LIMIT 7
Parameters:
[
"fr"
]
|
| 10 | 43.48 ms |
SELECT b0_.id AS id_0, b0_.is_active AS is_active_1, b0_.created_at AS created_at_2, b0_.updated_at AS updated_at_3 FROM blog b0_ WHERE b0_.is_active = 1 ORDER BY b0_.created_at DESC LIMIT 3
Parameters:
[] |
| 11 | 5.43 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.content AS content_3, t0.slug AS slug_4, t0.image AS image_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.locale AS locale_8, t0.translatable_id AS translatable_id_9, t10.id AS id_11, t10.is_active AS is_active_12, t10.created_at AS created_at_13, t10.updated_at AS updated_at_14 FROM blog_translation t0 LEFT JOIN blog t10 ON t0.translatable_id = t10.id WHERE t0.translatable_id = ?
Parameters:
[
2
]
|
| 12 | 1.53 ms |
SELECT t0.id AS id_1, t0.type AS type_2 FROM app_text t0 WHERE t0.type = ? LIMIT 1
Parameters:
[
"HEADER_KEYWORD"
]
|
| 13 | 1.72 ms |
SELECT t0.id AS id_1, t0.type AS type_2 FROM app_text t0 WHERE t0.type = ? LIMIT 1
Parameters:
[
"HEADER_DESCRIPTION"
]
|
| 14 | 0.87 ms |
SELECT t0.id AS id_1, t0.type AS type_2 FROM app_text t0 WHERE t0.type = ? LIMIT 1
Parameters:
[
"HEADER_KEYWORD"
]
|
| 15 | 4.98 ms |
SELECT t0.id AS id_1, t0.type AS type_2 FROM app_text t0 WHERE t0.type = ? LIMIT 1
Parameters:
[
"HEADER_DESCRIPTION"
]
|
| 16 | 5.04 ms |
SELECT t0.id AS id_1, t0.type AS type_2 FROM app_text t0 WHERE t0.type = ? LIMIT 1
Parameters:
[
"Banner"
]
|
| 17 | 0.34 ms |
SELECT t0.id AS id_1, t0.content AS content_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4, t5.id AS id_6, t5.type AS type_7 FROM app_text_translation t0 LEFT JOIN app_text t5 ON t0.translatable_id = t5.id WHERE t0.translatable_id = ?
Parameters:
[
2
]
|
| 18 | 1.07 ms |
SELECT t0.id AS id_1, t0.type AS type_2 FROM app_text t0 WHERE t0.type = ? LIMIT 1
Parameters:
[
"Header1"
]
|
| 19 | 1.41 ms |
SELECT t0.id AS id_1, t0.type AS type_2 FROM app_text t0 WHERE t0.type = ? LIMIT 1
Parameters:
[
"Header2"
]
|
| 20 | 6.49 ms |
SELECT t0.id AS id_1, t0.type AS type_2 FROM app_text t0 WHERE t0.type = ? LIMIT 1
Parameters:
[
"Header1"
]
|
| 21 | 3.89 ms |
SELECT t0.id AS id_1, t0.type AS type_2 FROM app_text t0 WHERE t0.type = ? LIMIT 1
Parameters:
[
"Header2"
]
|
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
| pharmonline | doctrine.dbal.pharmonline_connection |
Entity Managers
| Name | Service |
|---|---|
| pharmonline | doctrine.orm.pharmonline_entity_manager |
| default | doctrine.orm.default_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Entities Mapping
pharmonline entity manager
| Class | Mapping errors |
|---|---|
| App\EntityPharmonline\Users | No errors. |
default entity manager
| Class | Mapping errors |
|---|---|
| App\Entity\Superadmin | No errors. |
| App\Entity\Orders\Orders | No errors. |
| App\Entity\Pharmacies\PharmacyShippingMethod | No errors. |
| App\Entity\Pharmacies\PharmacyPaymentMethod | No errors. |
| App\Entity\PharmacyNotification | No errors. |
| App\Entity\Orders\OrdersProducts | No errors. |
| App\Entity\Products\Categories\ProductsCategories |
|
| App\Entity\Products\Products |
|
| App\Entity\Pharmacies\Pharmacies |
|
| App\Entity\Products\Attribut\ProductsAttributsTerms | No errors. |
| App\Entity\Gift\OrderGift | No errors. |
| App\Entity\AppText | No errors. |
| App\Entity\Products\ProductBrand | No errors. |
| App\Entity\Products\Associated\AssociatedProductsProducts | No errors. |
| App\Entity\Products\Attribut\AttributTitle |
|
| App\Entity\Products\Attribut\AttributTerms |
|
| App\Entity\Pharmacies\PharmaciesProducts | No errors. |
| App\Entity\PromotionalCode\PromotionalCodeProducts | No errors. |
| App\Entity\Products\ProductsPrestations | No errors. |
| App\Entity\Products\ProductsRecommanded | No errors. |
| App\Entity\Gift\OrderGiftItems | No errors. |
| App\Entity\PromotionalCode\PromotionalCode |
|
| App\Entity\Products\ProductsTranslation | No errors. |
| App\Entity\Products\Categories\ProductsCategoriesTranslation | No errors. |
| App\Entity\Blog\Blog | No errors. |
| App\Entity\Blog\BlogCategories | No errors. |
| App\Entity\Blog\BlogTranslation | No errors. |
| App\Entity\AppTextTranslation | No errors. |