Query Metrics

16 Database Queries
6 Different statements
7.80 ms Query time
3 Invalid entities

Queries

Group similar statements

default connection

# Time Info
1 1.62 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_ INNER JOIN blog_translation b1_ ON b0_.id = b1_.translatable_id WHERE b0_.is_active = 1 AND b1_.slug = ? ORDER BY b0_.created_at DESC LIMIT 1
Parameters:
[
  "que-contient-le-nouveau-plan-antitabac"
]
2 0.67 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
]
3 0.60 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_categories b0_ WHERE b0_.is_active = 1 ORDER BY b0_.created_at DESC
Parameters:
[]
4 0.71 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6, t7.id AS id_8, t7.is_active AS is_active_9, t7.created_at AS created_at_10, t7.updated_at AS updated_at_11 FROM blog_categories_translation t0 LEFT JOIN blog_categories t7 ON t0.translatable_id = t7.id WHERE t0.translatable_id = ?
Parameters:
[
  3
]
5 0.42 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6, t7.id AS id_8, t7.is_active AS is_active_9, t7.created_at AS created_at_10, t7.updated_at AS updated_at_11 FROM blog_categories_translation t0 LEFT JOIN blog_categories t7 ON t0.translatable_id = t7.id WHERE t0.translatable_id = ?
Parameters:
[
  2
]
6 0.29 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6, t7.id AS id_8, t7.is_active AS is_active_9, t7.created_at AS created_at_10, t7.updated_at AS updated_at_11 FROM blog_categories_translation t0 LEFT JOIN blog_categories t7 ON t0.translatable_id = t7.id WHERE t0.translatable_id = ?
Parameters:
[
  1
]
7 1.65 ms
SELECT t0.id AS id_1, t0.type AS type_2 FROM app_text t0 WHERE t0.type = ? LIMIT 1
Parameters:
[
  "HEADER_KEYWORD"
]
8 0.76 ms
SELECT t0.id AS id_1, t0.type AS type_2 FROM app_text t0 WHERE t0.type = ? LIMIT 1
Parameters:
[
  "HEADER_DESCRIPTION"
]
9 0.14 ms
SELECT t0.id AS id_1, t0.type AS type_2 FROM app_text t0 WHERE t0.type = ? LIMIT 1
Parameters:
[
  "HEADER_KEYWORD"
]
10 0.10 ms
SELECT t0.id AS id_1, t0.type AS type_2 FROM app_text t0 WHERE t0.type = ? LIMIT 1
Parameters:
[
  "HEADER_DESCRIPTION"
]
11 0.22 ms
SELECT t0.id AS id_1, t0.type AS type_2 FROM app_text t0 WHERE t0.type = ? LIMIT 1
Parameters:
[
  "Banner"
]
12 0.20 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
]
13 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"
]
14 0.10 ms
SELECT t0.id AS id_1, t0.type AS type_2 FROM app_text t0 WHERE t0.type = ? LIMIT 1
Parameters:
[
  "Header2"
]
15 0.10 ms
SELECT t0.id AS id_1, t0.type AS type_2 FROM app_text t0 WHERE t0.type = ? LIMIT 1
Parameters:
[
  "Header1"
]
16 0.09 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\Blog\BlogCategories No errors.
App\Entity\Blog\Blog No errors.
App\Entity\Blog\BlogTranslation No errors.
App\Entity\Blog\BlogCategoriesTranslation No errors.
App\Entity\PharmacyNotification No errors.
App\Entity\Orders\OrdersProducts No errors.
App\Entity\Orders\Orders 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\AppTextTranslation No errors.