Query Metrics

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

Queries

Group similar statements

# Time Info
1 0.43 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.12 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.99 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.12 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.46 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.59 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.09 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.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
]
9 0.44 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