Query Metrics
3
Database Queries
3
Different statements
3.72 ms
Query time
7
Invalid entities
Grouped Statements
default connection
Time▼ | Count | Info |
---|---|---|
1.98 ms (53.26%) |
1 |
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 14:39:35" ] |
1.00 ms (26.96%) |
1 |
SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.pharmacode AS pharmacode_3, t0.gtin AS gtin_4, t0.price AS price_5, t0.prevent_image_update AS prevent_image_update_6, t0.has360 AS has360_7, t0.has_back_image AS has_back_image_8, t0.has_info_patient AS has_info_patient_9, t0.has_info_pro AS has_info_pro_10, t0.price_promotion AS price_promotion_11, t0.start_promotion AS start_promotion_12, t0.end_promotion AS end_promotion_13, t0.prdno AS prdno_14, t0.stock AS stock_15, t0.recommanded AS recommanded_16, t0.best_seller AS best_seller_17, t0.custom_vente AS custom_vente_18, t0.created_at AS created_at_19, t0.updated_at AS updated_at_20, t0.brand_id AS brand_id_21, t22.id AS id_23, t22.name AS name_24, t22.description AS description_25, t22.meta_description AS meta_description_26, t22.meta_keyword AS meta_keyword_27, t22.slug AS slug_28, t22.image AS image_29, t22.created_at AS created_at_30, t22.updated_at AS updated_at_31, t22.locale AS locale_32, t22.translatable_id AS translatable_id_33 FROM products t0 LEFT JOIN products_translation t22 ON t22.translatable_id = t0.id WHERE t0.id = ?
Parameters:
[
6174
]
|
0.74 ms (19.78%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.is_active AS is_active_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM product_brand t0 WHERE t0.id = ?
Parameters:
[
1494
]
|
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\ProductsTranslation | 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\PromotionalCode\PromotionalCodeBrand |
|