Query Metrics

15 Database Queries
7 Different statements
7.81 ms Query time
10 Invalid entities

Queries

Group similar statements

default connection

# Time Info
1 0.58 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.image AS image_3, t0.created_at AS created_at_4, t0.email AS email_5, t0.description AS description_6, t0.is_valid AS is_valid_7, t0.full_name AS full_name_8, t0.tel AS tel_9, t0.address AS address_10, t0.city AS city_11, t0.ice AS ice_12, t0.rc AS rc_13, t0.simulate_username AS simulate_username_14, t0.simulate_password AS simulate_password_15, t0.cover_image AS cover_image_16, t0.path_rcimage AS path_rcimage_17, t0.path_ice_image AS path_ice_image_18, t0.path_ifimage AS path_ifimage_19, t0.identifiant_fiscale AS identifiant_fiscale_20, t0.user_id AS user_id_21 FROM vendor t0 WHERE t0.user_id IS NULL LIMIT 1
Parameters:
[]
2 0.91 ms
SELECT a0_.id AS id_0, a0_.first_name AS first_name_1, a0_.last_name AS last_name_2, a0_.email AS email_3, a0_.phone AS phone_4, a0_.address AS address_5, a0_.photo_identity AS photo_identity_6, a0_.gender AS gender_7, a0_.identity_number AS identity_number_8, a0_.deleted_at AS deleted_at_9, a0_.user_id AS user_id_10, a0_.agent_type_id AS agent_type_id_11, a0_.store_id AS store_id_12, a0_.agent_objective_id AS agent_objective_id_13 FROM agent a0_ LEFT JOIN user u1_ ON a0_.user_id = u1_.id WHERE (u1_.roles LIKE ?) AND (a0_.deleted_at IS NULL)
Parameters:
[
  "%ROLE_COMMERCIAL_AGENT%"
]
3 0.62 ms
SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_valid AS is_valid_5, t0.is_verified AS is_verified_6 FROM user t0 WHERE t0.id = ?
Parameters:
[
  6405
]
4 0.59 ms
SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_valid AS is_valid_5, t0.is_verified AS is_verified_6 FROM user t0 WHERE t0.id = ?
Parameters:
[
  6406
]
5 0.28 ms
SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_valid AS is_valid_5, t0.is_verified AS is_verified_6 FROM user t0 WHERE t0.id = ?
Parameters:
[
  6408
]
6 0.21 ms
SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_valid AS is_valid_5, t0.is_verified AS is_verified_6 FROM user t0 WHERE t0.id = ?
Parameters:
[
  6410
]
7 0.16 ms
SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_valid AS is_valid_5, t0.is_verified AS is_verified_6 FROM user t0 WHERE t0.id = ?
Parameters:
[
  6411
]
8 0.16 ms
SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_valid AS is_valid_5, t0.is_verified AS is_verified_6 FROM user t0 WHERE t0.id = ?
Parameters:
[
  6412
]
9 0.24 ms
SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_valid AS is_valid_5, t0.is_verified AS is_verified_6 FROM user t0 WHERE t0.id = ?
Parameters:
[
  6413
]
10 0.15 ms
SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_valid AS is_valid_5, t0.is_verified AS is_verified_6 FROM user t0 WHERE t0.id = ?
Parameters:
[
  6414
]
11 0.23 ms
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.created_at AS created_at_2, s0_.description AS description_3, s0_.store_type AS store_type_4, s0_.city_id AS city_id_5, s0_.user_id AS user_id_6, s0_.city_region_id AS city_region_id_7 FROM store s0_
Parameters:
[]
12 1.00 ms
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.image AS image_2, p0_.price AS price_3, p0_.description AS description_4, p0_.old_price AS old_price_5, p0_.quantity AS quantity_6, p0_.product_type AS product_type_7, p0_.meta_title AS meta_title_8, p0_.meta_description AS meta_description_9, p0_.meta_keywords AS meta_keywords_10, p0_.slug AS slug_11, p0_.created_at AS created_at_12, p0_.is_price_reduced_per_percent AS is_price_reduced_per_percent_13, p0_.percent_reduction AS percent_reduction_14, p0_.sku_code AS sku_code_15, p0_.short_description AS short_description_16, p0_.is_published AS is_published_17, p0_.sku_code_shop AS sku_code_shop_18, p0_.end_at AS end_at_19, p0_.type_reduction AS type_reduction_20, p0_.value_reduction AS value_reduction_21, p0_.subscription_monthly_price AS subscription_monthly_price_22, p0_.subscription_yearly_price AS subscription_yearly_price_23, p0_.deleted_at AS deleted_at_24, p0_.label_price_from AS label_price_from_25, p0_.subscription_duration AS subscription_duration_26, a1_.regular_price AS regular_price_27, p0_.dtype AS dtype_28, p0_.promotion_id AS promotion_id_29, p0_.vendor_id AS vendor_id_30, p0_.brand_id AS brand_id_31, p0_.parent_category_id AS parent_category_id_32, p0_.cloned_product_id AS cloned_product_id_33, p0_.store_id AS store_id_34 FROM product p0_ LEFT JOIN article a1_ ON p0_.id = a1_.id LEFT JOIN shop_product s2_ ON p0_.id = s2_.id WHERE (p0_.deleted_at IS NULL)
Parameters:
[]
13 0.85 ms
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.image AS image_2, p0_.description AS description_3, p0_.code AS code_4, p0_.is_enabled AS is_enabled_5, p0_.created_at AS created_at_6, p0_.position AS position_7, p0_.type AS type_8, p0_.secret_key AS secret_key_9, p0_.public_key AS public_key_10, p0_.display_on AS display_on_11 FROM payment_method p0_
Parameters:
[]
14 0.87 ms
SELECT t0.id AS id_1, t0.is_monday AS is_monday_2, t0.is_tuesday AS is_tuesday_3, t0.is_wednesday AS is_wednesday_4, t0.is_thursday AS is_thursday_5, t0.is_friday AS is_friday_6, t0.is_saturday AS is_saturday_7, t0.is_sunday AS is_sunday_8, t0.start_work_at AS start_work_at_9, t0.end_work_at AS end_work_at_10, t0.exclude_days AS exclude_days_11, t0.exclude_dates AS exclude_dates_12, t0.exclude_hours AS exclude_hours_13, t0.logo AS logo_14, t0.logo_base64 AS logo_base64_15, t0.favicon AS favicon_16, t0.email AS email_17, t0.address AS address_18, t0.currency AS currency_19, t0.default_lang AS default_lang_20, t0.project_name AS project_name_21, t0.code AS code_22, t0.asset_folder_name AS asset_folder_name_23, t0.mail_order_created_body AS mail_order_created_body_24, t0.mail_order_created_title AS mail_order_created_title_25, t0.prefix_order AS prefix_order_26, t0.root_url AS root_url_27, t0.description AS description_28, t0.is_mercure_enabled AS is_mercure_enabled_29, t0.front_theme_id AS front_theme_id_30 FROM settings t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
  "main"
]
15 0.96 ms
SELECT t0.id AS id_1, t0.is_monday AS is_monday_2, t0.is_tuesday AS is_tuesday_3, t0.is_wednesday AS is_wednesday_4, t0.is_thursday AS is_thursday_5, t0.is_friday AS is_friday_6, t0.is_saturday AS is_saturday_7, t0.is_sunday AS is_sunday_8, t0.start_work_at AS start_work_at_9, t0.end_work_at AS end_work_at_10, t0.exclude_days AS exclude_days_11, t0.exclude_dates AS exclude_dates_12, t0.exclude_hours AS exclude_hours_13, t0.logo AS logo_14, t0.logo_base64 AS logo_base64_15, t0.favicon AS favicon_16, t0.email AS email_17, t0.address AS address_18, t0.currency AS currency_19, t0.default_lang AS default_lang_20, t0.project_name AS project_name_21, t0.code AS code_22, t0.asset_folder_name AS asset_folder_name_23, t0.mail_order_created_body AS mail_order_created_body_24, t0.mail_order_created_title AS mail_order_created_title_25, t0.prefix_order AS prefix_order_26, t0.root_url AS root_url_27, t0.description AS description_28, t0.is_mercure_enabled AS is_mercure_enabled_29, t0.front_theme_id AS front_theme_id_30 FROM settings t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
  "main"
]

Database Connections

Name Service
default doctrine.dbal.default_connection
salle2 doctrine.dbal.salle2_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

Class Mapping errors
App\Flexy\ShopBundle\Entity\Vendor\Vendor No errors.
App\Entity\User No errors.
App\Flexy\ShopBundle\Entity\Customer\Customer No errors.
App\Flexy\ShopBundle\Entity\Order\Order
  • The mappings App\Flexy\ShopBundle\Entity\Order\Order#cityRegionShipping and App\Flexy\ShopBundle\Entity\Shipping\CityRegion#orders are inconsistent with each other.
App\Flexy\ShopBundle\Entity\Resource\Agent
  • The association App\Flexy\ShopBundle\Entity\Resource\Agent#agentObjective refers to the inverse side field App\Flexy\ShopBundle\Entity\Resource\AgentObjective#agent which does not exist.
App\Flexy\ShopBundle\Entity\Store\Store
  • The mappings App\Flexy\ShopBundle\Entity\Store\Store#cityRegion and App\Flexy\ShopBundle\Entity\Shipping\CityRegion#stores are inconsistent with each other.
App\Flexy\ShopBundle\Entity\Order\OrderItem No errors.
App\Flexy\ShopBundle\Entity\Product\Product
  • The mappings App\Flexy\ShopBundle\Entity\Product\Product#childrenProductsPack and App\Flexy\ShopBundle\Entity\Product\ProductPack#parentProduct are inconsistent with each other.
App\Flexy\ShopBundle\Entity\Payment\Payment No errors.
App\Flexy\ShopBundle\Entity\Payment\PaymentMethod No errors.
App\Flexy\ShopBundle\Entity\Product\ProductSubscription No errors.
App\Flexy\ShopBundle\Entity\Resource\AgentType No errors.
App\Flexy\ShopBundle\Entity\Resource\AgentObjective
  • The mappings App\Flexy\ShopBundle\Entity\Resource\AgentObjective#agents and App\Flexy\ShopBundle\Entity\Resource\Agent#agentObjective are inconsistent with each other.
App\Flexy\ShopBundle\Entity\Shipping\City No errors.
App\Flexy\ShopBundle\Entity\Shipping\CityRegion
  • The association App\Flexy\ShopBundle\Entity\Shipping\CityRegion#orders refers to the owning side field App\Flexy\ShopBundle\Entity\Order\Order#cityRegion which does not exist.
  • The association App\Flexy\ShopBundle\Entity\Shipping\CityRegion#stores refers to the owning side field App\Flexy\ShopBundle\Entity\Store\Store#�cityRegion which does not exist.
App\Flexy\StockBundle\Entity\Article
  • The mappings App\Flexy\StockBundle\Entity\Article#childrenProductsPack and App\Flexy\ShopBundle\Entity\Product\ProductPack#parentProduct are inconsistent with each other.
App\Flexy\ShopBundle\Entity\Product\ProductShop
  • The mappings App\Flexy\ShopBundle\Entity\Product\ProductShop#childrenProductsPack and App\Flexy\ShopBundle\Entity\Product\ProductPack#parentProduct are inconsistent with each other.
App\Flexy\ShopBundle\Entity\Promotion\Promotion No errors.
App\Flexy\ShopBundle\Entity\Brand No errors.
App\Flexy\ShopBundle\Entity\Product\CategoryProduct No errors.
App\Entity\Role No errors.
App\Entity\SessionHistory No errors.
App\Flexy\ShopBundle\Entity\Shipping\CashBox No errors.
App\Flexy\ShopBundle\Entity\Shipping\Shipment No errors.
App\Flexy\ShopBundle\Entity\Order\CashBoxOrder No errors.
App\Flexy\ShopBundle\Entity\Customer\Visit No errors.
App\Flexy\ShopBundle\Entity\Product\AttributValue No errors.
App\Flexy\ShopBundle\Entity\Product\ImageProduct No errors.
App\Flexy\ShopBundle\Entity\Product\ProductVariant No errors.
App\Flexy\ShopBundle\Entity\Product\Comment No errors.
App\Flexy\ShopBundle\Entity\Product\ProductPack
  • The association App\Flexy\ShopBundle\Entity\Product\ProductPack#parentProduct refers to the inverse side field App\Flexy\ShopBundle\Entity\Product\Product#childrenPackProducts which does not exist.
App\Flexy\ShopBundle\Entity\Accounting\Invoice
  • The association App\Flexy\ShopBundle\Entity\Accounting\Invoice#customerWalletPoints refers to the owning side field App\Flexy\ShopBundle\Entity\Customer\CustomerWalletPoint#invoice which does not exist.
App\Entity\Settings No errors.
App\Entity\FrontTheme No errors.