Query Metrics

11 Database Queries
9 Different statements
2.24 ms Query time
1 Invalid entities
11 Managed entities

Grouped Statements

Show all queries

Time Count Info
0.67 ms
(30.06%)
1
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.slug AS slug_2, p0_.short_description AS short_description_3, p0_.description AS description_4, p0_.ean AS ean_5, p0_.sku AS sku_6, p0_.price AS price_7, p0_.vat AS vat_8, p0_.gross_price AS gross_price_9, p0_.stock_quantity AS stock_quantity_10, p0_.gross_weight AS gross_weight_11, p0_.package_width AS package_width_12, p0_.package_height AS package_height_13, p0_.package_length AS package_length_14, p0_.shipping_type AS shipping_type_15, p0_.is_active AS is_active_16, p0_.added_at AS added_at_17, p0_.id_product_category AS id_product_category_18, p0_.id_added_by_user AS id_added_by_user_19 FROM product p0_ INNER JOIN user u1_ ON p0_.id_added_by_user = u1_.id WHERE p0_.is_active = 1 AND u1_.is_active = 1 AND p0_.id_added_by_user = ?
Parameters:
[
  "3"
]
0.46 ms
(20.67%)
1
SELECT u0_.id AS id_0, u0_.name AS name_1, u0_.slug AS slug_2, u0_.description AS description_3, u0_.logo AS logo_4, u0_.image AS image_5, u0_.tin AS tin_6, u0_.street AS street_7, u0_.postal_code AS postal_code_8, u0_.city AS city_9, u0_.company_data_visible AS company_data_visible_10, u0_.bank_account_number AS bank_account_number_11, u0_.id_user AS id_user_12 FROM user_company u0_ INNER JOIN user u1_ ON u0_.id_user = u1_.id WHERE u1_.is_active = 1 AND u0_.slug = ?
Parameters:
[
  "firma-testowa-1"
]
0.23 ms
(10.33%)
2
SELECT t0.id AS id_1, t0.image AS image_2, t0.id_product AS id_product_3 FROM product_image t0 WHERE t0.id_product = ? ORDER BY t0.id ASC
Parameters:
[
  1
]
0.20 ms
(9.03%)
1
SELECT COUNT(p0_.id) AS sclr_0 FROM product p0_ INNER JOIN user u1_ ON p0_.id_added_by_user = u1_.id WHERE p0_.is_active = 1 AND u1_.is_active = 1 AND p0_.id_added_by_user = ?
Parameters:
[
  "3"
]
0.18 ms
(8.13%)
2
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.slug AS slug_2, p0_.description AS description_3, p0_.icon AS icon_4, p0_.lft AS lft_5, p0_.rgt AS rgt_6, p0_.depth AS depth_7 FROM product_category p0_ WHERE p0_.lft < ? AND p0_.rgt > ? ORDER BY p0_.lft DESC
Parameters:
[
  3
  4
]
0.16 ms
(7.07%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.icon AS icon_5, t0.lft AS lft_6, t0.rgt AS rgt_7, t0.depth AS depth_8 FROM product_category t0 WHERE t0.id = ?
Parameters:
[
  9
]
0.16 ms
(7.03%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.intro AS intro_3, t0.description AS description_4, t0.image AS image_5, t0.delivery_methods_info AS delivery_methods_info_6, t0.returns_info AS returns_info_7, t0.payment_methods_info AS payment_methods_info_8, t0.is_active AS is_active_9, t0.id_company AS id_company_10 FROM company_store t0 WHERE t0.id_company = ? LIMIT 1
Parameters:
[
  "1"
]
0.09 ms
(3.98%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.logo AS logo_5, t0.image AS image_6, t0.tin AS tin_7, t0.street AS street_8, t0.postal_code AS postal_code_9, t0.city AS city_10, t0.company_data_visible AS company_data_visible_11, t0.bank_account_number AS bank_account_number_12, t0.id_user AS id_user_13 FROM user_company t0 WHERE t0.id_user = ?
Parameters:
[
  "3"
]
0.08 ms
(3.71%)
1
SELECT t0.id AS id_1, t0.username AS username_2, t0.password AS password_3, t0.email AS email_4, t0.type AS type_5, t0.is_active AS is_active_6 FROM user t0 WHERE t0.id = ?
Parameters:
[
  "3"
]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class Amount of managed objects
App\Admin\Modules\Settings\Entity\ProductCategory 3
App\Admin\Modules\Product\Entity\ProductImage 3
App\Admin\Modules\Product\Entity\Product 2
App\Admin\Modules\Company\Entity\UserCompany 1
App\Modules\User\Entity\User 1
App\PanelCompany\Modules\Store\Entity\CompanyStore 1

Entities Mapping

Class Mapping errors
App\Admin\Modules\Company\Entity\UserCompany
  • The field 'App\Admin\Modules\Company\Entity\UserCompany#companyDataVisible' has the property type 'string' that differs from the metadata field type 'bool' returned by the 'boolean' DBAL type.
App\Modules\User\Entity\User No errors.
App\Admin\Modules\Product\Entity\Product No errors.
App\Admin\Modules\Settings\Entity\ProductCategory No errors.
App\Admin\Modules\Product\Entity\ProductImage No errors.
App\Admin\Modules\Product\Entity\ProductTag No errors.
App\Admin\Modules\Presentation\Entity\PresentationProduct No errors.
App\PanelCompany\Modules\Store\Entity\CompanyStore No errors.
App\Admin\Modules\Client\Entity\UserClient No errors.