Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

1 Database Queries

1 Different statements

3.66 ms Query time

3 Invalid entities

Queries

Group similar statements

default connection

#▲	Time	Info
1	3.66 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-10-19 00:00:00" "2025-10-21 19:00:07"`] View formatted query View runnable query Explain query 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 ? 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 '2025-10-19 00:00:00' AND '2025-10-21 19:00:07';

#▲

Time

Info

3.66 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-10-19 00:00:00"
  "2025-10-21 19:00:07"
]

View formatted query View runnable query Explain query

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 ?

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 '2025-10-19 00:00:00' AND '2025-10-21 19:00:07';

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.