https://shop.playdigital.ch/de/product/82-PL3-pl-3-protege-levres

Query Metrics

3 Database Queries
3 Different statements
4.90 ms Query time
7 Invalid entities

Queries

Group similar statements

default connection

# Time Info
1 1.59 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-24 00:00:51"
]
2 1.68 ms
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:
[
  82
]
3 1.63 ms
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:
[
  74
]

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
  • The field App\Entity\Products\Categories\ProductsCategories#parent is on the owning side of a bi-directional relationship, but the specified inversedBy association on the target-entity App\Entity\Products\Categories\ProductsCategories#parent does not contain the required 'mappedBy="parent"' attribute.
  • If association App\Entity\Products\Categories\ProductsCategories#parent is many-to-one, then the inversed side App\Entity\Products\Categories\ProductsCategories#parent has to be one-to-many.
App\Entity\Products\Products
  • The mappings App\Entity\Products\Products#customAttributTitles and App\Entity\Products\Attribut\AttributTitle#product are inconsistent with each other.
App\Entity\Pharmacies\Pharmacies
  • The association App\Entity\Pharmacies\Pharmacies#paymentMethods refers to the owning side field App\Entity\Pharmacies\PharmacyPaymentMethod#pharmacies which does not exist.
  • The association App\Entity\Pharmacies\Pharmacies#shippingMethods refers to the owning side field App\Entity\Pharmacies\PharmacyShippingMethod#pharmacy which does not exist.
  • The association App\Entity\Pharmacies\Pharmacies#pharmaciesProducts refers to the owning side field App\Entity\Pharmacies\PharmaciesProducts#pharmacy which does not exist.
  • The association App\Entity\Pharmacies\Pharmacies#orders refers to the owning side field App\Entity\Orders\Orders#pharmacy which does not exist.
  • The association App\Entity\Pharmacies\Pharmacies#promotionalCodes refers to the owning side field App\Entity\PromotionalCode\PromotionalCode#pharmacy which does not exist.
  • The association App\Entity\Pharmacies\Pharmacies#pharmacists refers to the owning side field App\Entity\Pharmacists#pharmacy which does not exist.
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
  • The association App\Entity\Products\Attribut\AttributTitle#product refers to the inverse side field App\Entity\Products\Products#customTerms which does not exist.
App\Entity\Products\Attribut\AttributTerms
  • The association App\Entity\Products\Attribut\AttributTerms#ordersProducts refers to the owning side field App\Entity\Orders\OrdersProducts#attributTerms which does not exist.
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
  • The mappings App\Entity\PromotionalCode\PromotionalCode#productsBrand and App\Entity\PromotionalCode\PromotionalCodeBrand#promotionalCode are inconsistent with each other.
App\Entity\PromotionalCode\PromotionalCodeBrand
  • The association App\Entity\PromotionalCode\PromotionalCodeBrand#promotionalCode refers to the inverse side field App\Entity\PromotionalCode\PromotionalCode#brand which does not exist.