Query Metrics
41
Database Queries
10
Different statements
35.83 ms
Query time
6
Invalid entities
Queries
default connection
#▲ | Time | Info |
---|---|---|
1 | 1.45 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:
[ "2025-02-23 00:00:00" "2025-02-23 04:39:12" ] |
2 | 1.03 ms |
SELECT p0_.id AS id_0, p0_.is_active AS is_active_1, p0_.created_at AS created_at_2, p0_.updated_at AS updated_at_3, p0_.parent_id AS parent_id_4 FROM products_categories p0_ LEFT JOIN products_categories p1_ ON p0_.parent_id = p1_.id LEFT JOIN products_categories_translation p2_ ON p0_.id = p2_.translatable_id WHERE p0_.id = ?
Parameters:
[
165
]
|
3 | 0.33 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.meta_description AS meta_description_3, t0.meta_keyword AS meta_keyword_4, t0.slug AS slug_5, t0.image AS image_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.locale AS locale_9, t0.translatable_id AS translatable_id_10, t11.id AS id_12, t11.is_active AS is_active_13, t11.created_at AS created_at_14, t11.updated_at AS updated_at_15, t11.parent_id AS parent_id_16 FROM products_categories_translation t0 LEFT JOIN products_categories t11 ON t0.translatable_id = t11.id WHERE t0.translatable_id = ?
Parameters:
[
165
]
|
4 | 0.61 ms |
SELECT p0_.id AS id_0, p1_.name AS name_1, p1_.locale AS locale_2, p2_.id AS id_3 FROM products_categories p0_ LEFT JOIN products_categories p2_ ON p0_.parent_id = p2_.id LEFT JOIN products_categories_translation p1_ ON p0_.id = p1_.translatable_id WHERE p0_.parent_id = ? AND p1_.locale = ?
Parameters:
[ 165 "fr" ] |
5 | 4.57 ms |
SELECT count(DISTINCT p0_.id) AS sclr_0 FROM products p0_ LEFT JOIN products_translation p1_ ON p0_.id = p1_.translatable_id INNER JOIN product_brand p2_ ON p0_.brand_id = p2_.id INNER JOIN products_categories_products p4_ ON p0_.id = p4_.products_id INNER JOIN products_categories p3_ ON p3_.id = p4_.products_categories_id INNER JOIN products_categories_translation p5_ ON p3_.id = p5_.translatable_id WHERE p0_.is_active = 1 AND p3_.id IN (?) AND p0_.price >= ? AND p0_.price <= ?
Parameters:
[ 165 1.0 100.0 ] |
6 | 3.19 ms |
SELECT DISTINCT p0_.id AS id_0, p0_.price AS price_1 FROM products p0_ LEFT JOIN products_translation p1_ ON p0_.id = p1_.translatable_id INNER JOIN product_brand p2_ ON p0_.brand_id = p2_.id INNER JOIN products_categories_products p4_ ON p0_.id = p4_.products_id INNER JOIN products_categories p3_ ON p3_.id = p4_.products_categories_id INNER JOIN products_categories_translation p5_ ON p3_.id = p5_.translatable_id WHERE p0_.is_active = 1 AND p3_.id IN (?) AND p0_.price >= ? AND p0_.price <= ? ORDER BY p0_.price ASC LIMIT 20
Parameters:
[ 165 1.0 100.0 ] |
7 | 2.27 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_ LEFT JOIN products_translation p1_ ON p0_.id = p1_.translatable_id INNER JOIN product_brand p2_ ON p0_.brand_id = p2_.id INNER JOIN products_categories_products p4_ ON p0_.id = p4_.products_id INNER JOIN products_categories p3_ ON p3_.id = p4_.products_categories_id INNER JOIN products_categories_translation p5_ ON p3_.id = p5_.translatable_id WHERE p0_.is_active = 1 AND p3_.id IN (?) AND p0_.price >= ? AND p0_.price <= ? AND p0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY p0_.price ASC
Parameters:
[ 165 1.0 100.0 3120 4043 3396 3397 3398 3399 3400 3401 3387 5479 3383 3384 8470 8471 7423 7424 7425 7426 9191 9192 ] |
8 | 1.20 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:
[
3120
]
|
9 | 1.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:
[
4043
]
|
10 | 1.79 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:
[
3396
]
|
11 | 0.82 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:
[
3397
]
|
12 | 0.62 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:
[
3398
]
|
13 | 0.45 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:
[
3399
]
|
14 | 0.38 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:
[
3400
]
|
15 | 0.50 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:
[
3401
]
|
16 | 1.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:
[
3387
]
|
17 | 0.95 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:
[
3383
]
|
18 | 0.47 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:
[
3384
]
|
19 | 0.29 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:
[
3384
]
|
20 | 1.44 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:
[
5479
]
|
21 | 1.56 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:
[
8470
]
|
22 | 0.47 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:
[
8471
]
|
23 | 1.43 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:
[
7424
]
|
24 | 0.21 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:
[
7424
]
|
25 | 0.56 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:
[
7425
]
|
26 | 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:
[
7426
]
|
27 | 0.19 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:
[
7426
]
|
28 | 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:
[
7423
]
|
29 | 1.37 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:
[
9191
]
|
30 | 0.25 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:
[
9191
]
|
31 | 1.09 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:
[
9192
]
|
32 | 0.47 ms |
SELECT t0.id AS id_1, t0.type AS type_2 FROM app_text t0 WHERE t0.type = ? LIMIT 1
Parameters:
[
"HEADER_KEYWORD"
]
|
33 | 0.24 ms |
SELECT t0.id AS id_1, t0.type AS type_2 FROM app_text t0 WHERE t0.type = ? LIMIT 1
Parameters:
[
"HEADER_DESCRIPTION"
]
|
34 | 0.40 ms |
SELECT t0.id AS id_1, t0.type AS type_2 FROM app_text t0 WHERE t0.type = ? LIMIT 1
Parameters:
[
"HEADER_KEYWORD"
]
|
35 | 0.24 ms |
SELECT t0.id AS id_1, t0.type AS type_2 FROM app_text t0 WHERE t0.type = ? LIMIT 1
Parameters:
[
"HEADER_DESCRIPTION"
]
|
36 | 0.36 ms |
SELECT t0.id AS id_1, t0.type AS type_2 FROM app_text t0 WHERE t0.type = ? LIMIT 1
Parameters:
[
"Banner"
]
|
37 | 0.17 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
]
|
38 | 0.14 ms |
SELECT t0.id AS id_1, t0.type AS type_2 FROM app_text t0 WHERE t0.type = ? LIMIT 1
Parameters:
[
"Header1"
]
|
39 | 0.14 ms |
SELECT t0.id AS id_1, t0.type AS type_2 FROM app_text t0 WHERE t0.type = ? LIMIT 1
Parameters:
[
"Header2"
]
|
40 | 0.13 ms |
SELECT t0.id AS id_1, t0.type AS type_2 FROM app_text t0 WHERE t0.type = ? LIMIT 1
Parameters:
[
"Header1"
]
|
41 | 0.15 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\Categories\ProductsCategoriesTranslation | No errors. |
App\Entity\PromotionalCode\PromotionalCodeProductsCategories | No errors. |
App\Entity\Gift\OrderGiftItems | No errors. |
App\Entity\Products\ProductsTranslation | 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\PromotionalCode\PromotionalCode |
|
App\Entity\AppTextTranslation | No errors. |