Query Metrics

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

Queries

Group similar statements

# Time Info
1 0.14 ms
SELECT u0_.id AS id_0, u0_.username AS username_1, u0_.password AS password_2, u0_.email AS email_3, u0_.type AS type_4, u0_.is_active AS is_active_5, u1_.id AS id_6, u1_.name AS name_7, u1_.slug AS slug_8, u1_.description AS description_9, u1_.logo AS logo_10, u1_.image AS image_11, u1_.tin AS tin_12, u1_.street AS street_13, u1_.postal_code AS postal_code_14, u1_.city AS city_15, u1_.company_data_visible AS company_data_visible_16, u1_.bank_account_number AS bank_account_number_17, u1_.id_user AS id_user_18 FROM user u0_ INNER JOIN user_company u1_ ON u0_.id = u1_.id_user WHERE u0_.type = ? AND u0_.is_active = 1 AND u1_.slug = ?
Parameters:
[
  2
  "firma-testowa-1"
]
2 0.11 ms
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"
]
3 0.13 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.short_description AS short_description_4, t0.description AS description_5, t0.ean AS ean_6, t0.sku AS sku_7, t0.price AS price_8, t0.vat AS vat_9, t0.gross_price AS gross_price_10, t0.stock_quantity AS stock_quantity_11, t0.gross_weight AS gross_weight_12, t0.package_width AS package_width_13, t0.package_height AS package_height_14, t0.package_length AS package_length_15, t0.shipping_type AS shipping_type_16, t0.is_active AS is_active_17, t0.added_at AS added_at_18, t0.id_product_category AS id_product_category_19, t0.id_added_by_user AS id_added_by_user_20 FROM product t0 INNER JOIN company_store_product ON t0.id = company_store_product.id_product WHERE company_store_product.id_company_store = ?
Parameters:
[
  "1"
]
4 0.11 ms
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
]
5 0.09 ms
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
]
6 0.09 ms
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
]
7 0.07 ms
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:
[
  2
]
8 0.07 ms
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
]
9 0.11 ms
SELECT c0_.id AS id_0, c0_.question AS question_1, c0_.answer AS answer_2, c0_.position AS position_3, c0_.id_user_company AS id_user_company_4 FROM company_faq c0_ WHERE c0_.id_user_company = ? ORDER BY c0_.position ASC
Parameters:
[
  "1"
]

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\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\Modules\User\Entity\User 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.
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\Faq\Entity\CompanyFaq No errors.