Query Metrics

5 Database Queries
5 Different statements
0.95 ms Query time
1 Invalid entities
7 Managed entities

Grouped Statements

Show all queries

Time Count Info
0.43 ms
(44.70%)
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 = ?
Parameters:
[
  "1"
]
0.20 ms
(20.61%)
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.13 ms
(13.26%)
1
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.11 ms
(11.76%)
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.09 ms
(9.68%)
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\Product\Entity\ProductImage 2
App\Admin\Modules\Product\Entity\Product 1
App\Admin\Modules\Settings\Entity\ProductCategory 1
App\Modules\User\Entity\User 1
App\Admin\Modules\Company\Entity\UserCompany 1
App\PanelCompany\Modules\Store\Entity\CompanyStore 1

Entities Mapping

Class Mapping errors
App\Admin\Modules\Product\Entity\Product No errors.
App\Modules\User\Entity\User 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\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\Admin\Modules\Client\Entity\UserClient No errors.
App\PanelCompany\Modules\Store\Entity\CompanyStore No errors.