Symfony Profiler

Query Metrics

97 Database Queries

19 Different statements

17.72 ms Query time

0 Invalid entities

78 Managed entities

Queries

Group similar statements

default connection


SELECT t0.id AS id_1, t0.migration_id AS migration_id_2, t0.softone_id AS softone_id_3, t0.name AS name_4, t0.slug AS slug_5, t0.description AS description_6, t0.lft AS lft_7, t0.lvl AS lvl_8, t0.rgt AS rgt_9, t0.published AS published_10, t0.sort_index AS sort_index_11, t0.tree_root AS tree_root_12, t0.parent_id AS parent_id_13, t0.banner_id AS banner_id_14 FROM product_category t0 WHERE t0.slug = ? LIMIT 1
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT t0.id AS id_1, t0.custom_id AS custom_id_2, t0.softone_id AS softone_id_3, t0.name AS name_4, t0.slug AS slug_5, t0.summary AS summary_6, t0.description AS description_7, t0.status AS status_8, t0.keywords AS keywords_9, t0.general_comments AS general_comments_10, t0.published AS published_11, t0.featured AS featured_12, t0.sku AS sku_13, t0.mfr_code AS mfr_code_14, t0.blk_code AS blk_code_15, t0.ean_code AS ean_code_16, t0.supplier_code AS supplier_code_17, t0.volumetric_weight AS volumetric_weight_18, t0.views AS views_19, t0.sales AS sales_20, t0.created_at AS created_at_21, t0.supplier_url AS supplier_url_22, t0.in_the_box_text AS in_the_box_text_23, t0.discount_percent AS discount_percent_24, t0.available_at AS available_at_25, t0.offer AS offer_26, t0.cash_back AS cash_back_27, t0.ask_for_price AS ask_for_price_28, t0.warehouse_stock_warehouse AS warehouse_stock_warehouse_29, t0.warehouse_stock_quantity AS warehouse_stock_quantity_30, t0.warehouse_stock_reserved AS warehouse_stock_reserved_31, t0.warehouse_stock_target_stock AS warehouse_stock_target_stock_32, t0.warehouse_stock_immutable AS warehouse_stock_immutable_33, t0.price_gross_amount AS price_gross_amount_34, t0.price_gross_currency AS price_gross_currency_35, t0.price_with_discount_amount AS price_with_discount_amount_36, t0.price_with_discount_currency AS price_with_discount_currency_37, t0.price_url AS price_url_38, t0.price_comments AS price_comments_39, t0.supplier_discount AS supplier_discount_40, t0.special_discount AS special_discount_41, t0.customs_charges AS customs_charges_42, t0.expected_profit AS expected_profit_43, t0.accessories AS accessories_44, t0.original_price_amount AS original_price_amount_45, t0.original_price_currency AS original_price_currency_46, t0.supplier_shipping_value_amount AS supplier_shipping_value_amount_47, t0.supplier_shipping_value_currency AS supplier_shipping_value_currency_48, t0.dimensions_measurement_unit AS dimensions_measurement_unit_49, t0.dimensions_length AS dimensions_length_50, t0.dimensions_width AS dimensions_width_51, t0.dimensions_height AS dimensions_height_52, t0.dimensions_weight_unit AS dimensions_weight_unit_53, t0.dimensions_weight AS dimensions_weight_54, t0.dimensions_volume AS dimensions_volume_55, t0.type_id AS type_id_56, t0.main_image_id AS main_image_id_57, t0.manufacturer_id AS manufacturer_id_58, t0.discr FROM products t0 WHERE t0.slug = ? AND t0.discr IN ('product') LIMIT 1
SELECT p0_.content AS content_0, p0_.field AS field_1 FROM product_translations p0_ WHERE p0_.foreign_key = ? AND p0_.locale = ? AND p0_.object_class = ?
"START TRANSACTION"
UPDATE products SET views = ? WHERE id = ?
"COMMIT"
SELECT t0.id AS id_1, t0.title AS title_2, t0.type AS type_3, t0.url AS url_4 FROM product_reference t0 INNER JOIN products_references ON t0.id = products_references.reference_id WHERE products_references.product_id = ?
SELECT t0.id AS id_1, t0.session_id AS session_id_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.user_id AS user_id_5 FROM cart t0 WHERE t0.session_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.migration_id AS migration_id_2, t0.softone_id AS softone_id_3, t0.name AS name_4, t0.slug AS slug_5, t0.description AS description_6, t0.lft AS lft_7, t0.lvl AS lvl_8, t0.rgt AS rgt_9, t0.published AS published_10, t0.sort_index AS sort_index_11, t0.tree_root AS tree_root_12, t0.parent_id AS parent_id_13, t0.banner_id AS banner_id_14 FROM product_category t0 WHERE t0.lvl = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT t0.id AS id_1, t0.migration_id AS migration_id_2, t0.softone_id AS softone_id_3, t0.name AS name_4, t0.slug AS slug_5, t0.description AS description_6, t0.lft AS lft_7, t0.lvl AS lvl_8, t0.rgt AS rgt_9, t0.published AS published_10, t0.sort_index AS sort_index_11, t0.tree_root AS tree_root_12, t0.parent_id AS parent_id_13, t0.banner_id AS banner_id_14 FROM product_category t0 WHERE t0.tree_root = ? LIMIT 1
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT p0_.id AS id_0, p0_.migration_id AS migration_id_1, p0_.softone_id AS softone_id_2, p0_.name AS name_3, p0_.slug AS slug_4, p0_.description AS description_5, p0_.lft AS lft_6, p0_.lvl AS lvl_7, p0_.rgt AS rgt_8, p0_.published AS published_9, p0_.sort_index AS sort_index_10 FROM product_category p0_ WHERE p0_.rgt < 924 AND p0_.lft > 1 AND p0_.tree_root = ? ORDER BY p0_.tree_root ASC, p0_.lft ASC
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.wishlist AS wishlist_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.price_amount AS price_amount_6, t0.price_currency AS price_currency_7, t0.cart_id AS cart_id_8, t0.product_id AS product_id_9 FROM cart_item t0 WHERE t0.cart_id = ?
SELECT t0.id AS id_1, t0.text_value AS text_value_2, t0.quantity AS quantity_3, t0.product_id AS product_id_4, t0.attribute_id AS attribute_id_5, t0.attribute_value_id AS attribute_value_id_6 FROM product_attribute_value t0 WHERE t0.product_id = ?
SELECT t0.id AS id_1, t0.migration_id AS migration_id_2, t0.softone_id AS softone_id_3, t0.name AS name_4, t0.slug AS slug_5, t0.description AS description_6, t0.lft AS lft_7, t0.lvl AS lvl_8, t0.rgt AS rgt_9, t0.published AS published_10, t0.sort_index AS sort_index_11, t0.tree_root AS tree_root_12, t0.parent_id AS parent_id_13, t0.banner_id AS banner_id_14 FROM product_category t0 WHERE t0.parent_id = ? ORDER BY t0.lft ASC
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT t0.id AS id_1, t0.migration_id AS migration_id_2, t0.softone_id AS softone_id_3, t0.name AS name_4, t0.slug AS slug_5, t0.description AS description_6, t0.lft AS lft_7, t0.lvl AS lvl_8, t0.rgt AS rgt_9, t0.published AS published_10, t0.sort_index AS sort_index_11, t0.tree_root AS tree_root_12, t0.parent_id AS parent_id_13, t0.banner_id AS banner_id_14 FROM product_category t0 WHERE t0.parent_id = ? ORDER BY t0.lft ASC
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT t0.id AS id_1, t0.migration_id AS migration_id_2, t0.softone_id AS softone_id_3, t0.name AS name_4, t0.slug AS slug_5, t0.description AS description_6, t0.lft AS lft_7, t0.lvl AS lvl_8, t0.rgt AS rgt_9, t0.published AS published_10, t0.sort_index AS sort_index_11, t0.tree_root AS tree_root_12, t0.parent_id AS parent_id_13, t0.banner_id AS banner_id_14 FROM product_category t0 WHERE t0.parent_id = ? ORDER BY t0.lft ASC
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT t0.id AS id_1, t0.migration_id AS migration_id_2, t0.softone_id AS softone_id_3, t0.name AS name_4, t0.slug AS slug_5, t0.description AS description_6, t0.lft AS lft_7, t0.lvl AS lvl_8, t0.rgt AS rgt_9, t0.published AS published_10, t0.sort_index AS sort_index_11, t0.tree_root AS tree_root_12, t0.parent_id AS parent_id_13, t0.banner_id AS banner_id_14 FROM product_category t0 WHERE t0.parent_id = ? ORDER BY t0.lft ASC
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT t0.id AS id_1, t0.migration_id AS migration_id_2, t0.softone_id AS softone_id_3, t0.name AS name_4, t0.slug AS slug_5, t0.description AS description_6, t0.lft AS lft_7, t0.lvl AS lvl_8, t0.rgt AS rgt_9, t0.published AS published_10, t0.sort_index AS sort_index_11, t0.tree_root AS tree_root_12, t0.parent_id AS parent_id_13, t0.banner_id AS banner_id_14 FROM product_category t0 WHERE t0.parent_id = ? ORDER BY t0.lft ASC
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT t0.id AS id_1, t0.migration_id AS migration_id_2, t0.softone_id AS softone_id_3, t0.name AS name_4, t0.slug AS slug_5, t0.description AS description_6, t0.lft AS lft_7, t0.lvl AS lvl_8, t0.rgt AS rgt_9, t0.published AS published_10, t0.sort_index AS sort_index_11, t0.tree_root AS tree_root_12, t0.parent_id AS parent_id_13, t0.banner_id AS banner_id_14 FROM product_category t0 WHERE t0.parent_id = ? ORDER BY t0.lft ASC
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT t0.id AS id_1, t0.migration_id AS migration_id_2, t0.softone_id AS softone_id_3, t0.name AS name_4, t0.slug AS slug_5, t0.description AS description_6, t0.lft AS lft_7, t0.lvl AS lvl_8, t0.rgt AS rgt_9, t0.published AS published_10, t0.sort_index AS sort_index_11, t0.tree_root AS tree_root_12, t0.parent_id AS parent_id_13, t0.banner_id AS banner_id_14 FROM product_category t0 WHERE t0.parent_id = ? ORDER BY t0.lft ASC
SELECT t0.id AS id_1, t0.migration_id AS migration_id_2, t0.softone_id AS softone_id_3, t0.name AS name_4, t0.slug AS slug_5, t0.description AS description_6, t0.lft AS lft_7, t0.lvl AS lvl_8, t0.rgt AS rgt_9, t0.published AS published_10, t0.sort_index AS sort_index_11, t0.tree_root AS tree_root_12, t0.parent_id AS parent_id_13, t0.banner_id AS banner_id_14 FROM product_category t0 WHERE t0.parent_id = ? ORDER BY t0.lft ASC
SELECT t0.id AS id_1, t0.migration_id AS migration_id_2, t0.softone_id AS softone_id_3, t0.name AS name_4, t0.slug AS slug_5, t0.description AS description_6, t0.lft AS lft_7, t0.lvl AS lvl_8, t0.rgt AS rgt_9, t0.published AS published_10, t0.sort_index AS sort_index_11, t0.tree_root AS tree_root_12, t0.parent_id AS parent_id_13, t0.banner_id AS banner_id_14 FROM product_category t0 WHERE t0.parent_id = ? ORDER BY t0.lft ASC
SELECT t0.id AS id_1, t0.path AS path_2, t0.name AS name_3, t0.mime_type AS mime_type_4, t0.size AS size_5, t0.uploaded_at AS uploaded_at_6, t0.discr FROM app_file t0 WHERE t0.id = ? AND t0.discr IN ('product_image')
SELECT t0.id AS id_1, t0.path AS path_2, t0.name AS name_3, t0.mime_type AS mime_type_4, t0.size AS size_5, t0.uploaded_at AS uploaded_at_6, t0.discr FROM app_file t0 INNER JOIN product_images ON t0.id = product_images.image_id WHERE product_images.product_id = ? AND t0.discr IN ('product_image')
SELECT t0.id AS id_1, t0.custom_id AS custom_id_2, t0.softone_id AS softone_id_3, t0.name AS name_4, t0.slug AS slug_5, t0.url AS url_6, t0.email AS email_7, t0.published AS published_8, t0.official_dealer AS official_dealer_9, t0.european_support AS european_support_10, t0.discount_percent AS discount_percent_11, t0.extra_discount AS extra_discount_12, t0.logo_id AS logo_id_13 FROM product_manufacturer t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.migration_id AS migration_id_2, t0.softone_id AS softone_id_3, t0.name AS name_4 FROM product_type t0 WHERE t0.id = ?

#▲	Time	Info
1	0.26 ms	SELECT t0.id AS id_1, t0.migration_id AS migration_id_2, t0.softone_id AS softone_id_3, t0.name AS name_4, t0.slug AS slug_5, t0.description AS description_6, t0.lft AS lft_7, t0.lvl AS lvl_8, t0.rgt AS rgt_9, t0.published AS published_10, t0.sort_index AS sort_index_11, t0.tree_root AS tree_root_12, t0.parent_id AS parent_id_13, t0.banner_id AS banner_id_14 FROM product_category t0 WHERE t0.slug = ? LIMIT 1 Parameters: [`"Streaming_Software"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.migration_id AS migration_id_2, t0.softone_id AS softone_id_3, t0.name AS name_4, t0.slug AS slug_5, t0.description AS description_6, t0.lft AS lft_7, t0.lvl AS lvl_8, t0.rgt AS rgt_9, t0.published AS published_10, t0.sort_index AS sort_index_11, t0.tree_root AS tree_root_12, t0.parent_id AS parent_id_13, t0.banner_id AS banner_id_14 FROM product_category t0 WHERE t0.slug = ? LIMIT 1 SELECT t0.id AS id_1, t0.migration_id AS migration_id_2, t0.softone_id AS softone_id_3, t0.name AS name_4, t0.slug AS slug_5, t0.description AS description_6, t0.lft AS lft_7, t0.lvl AS lvl_8, t0.rgt AS rgt_9, t0.published AS published_10, t0.sort_index AS sort_index_11, t0.tree_root AS tree_root_12, t0.parent_id AS parent_id_13, t0.banner_id AS banner_id_14 FROM product_category t0 WHERE t0.slug = 'Streaming_Software' LIMIT 1;
2	0.34 ms	SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ? Parameters: [`"26" "en" "App\Entity\Product\Category"`] View formatted query View runnable query Explain query SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ? SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '26' AND e0_.locale = 'en' AND e0_.object_class = 'App\\Entity\\Product\\Category';
3	0.39 ms	SELECT t0.id AS id_1, t0.custom_id AS custom_id_2, t0.softone_id AS softone_id_3, t0.name AS name_4, t0.slug AS slug_5, t0.summary AS summary_6, t0.description AS description_7, t0.status AS status_8, t0.keywords AS keywords_9, t0.general_comments AS general_comments_10, t0.published AS published_11, t0.featured AS featured_12, t0.sku AS sku_13, t0.mfr_code AS mfr_code_14, t0.blk_code AS blk_code_15, t0.ean_code AS ean_code_16, t0.supplier_code AS supplier_code_17, t0.volumetric_weight AS volumetric_weight_18, t0.views AS views_19, t0.sales AS sales_20, t0.created_at AS created_at_21, t0.supplier_url AS supplier_url_22, t0.in_the_box_text AS in_the_box_text_23, t0.discount_percent AS discount_percent_24, t0.available_at AS available_at_25, t0.offer AS offer_26, t0.cash_back AS cash_back_27, t0.ask_for_price AS ask_for_price_28, t0.warehouse_stock_warehouse AS warehouse_stock_warehouse_29, t0.warehouse_stock_quantity AS warehouse_stock_quantity_30, t0.warehouse_stock_reserved AS warehouse_stock_reserved_31, t0.warehouse_stock_target_stock AS warehouse_stock_target_stock_32, t0.warehouse_stock_immutable AS warehouse_stock_immutable_33, t0.price_gross_amount AS price_gross_amount_34, t0.price_gross_currency AS price_gross_currency_35, t0.price_with_discount_amount AS price_with_discount_amount_36, t0.price_with_discount_currency AS price_with_discount_currency_37, t0.price_url AS price_url_38, t0.price_comments AS price_comments_39, t0.supplier_discount AS supplier_discount_40, t0.special_discount AS special_discount_41, t0.customs_charges AS customs_charges_42, t0.expected_profit AS expected_profit_43, t0.accessories AS accessories_44, t0.original_price_amount AS original_price_amount_45, t0.original_price_currency AS original_price_currency_46, t0.supplier_shipping_value_amount AS supplier_shipping_value_amount_47, t0.supplier_shipping_value_currency AS supplier_shipping_value_currency_48, t0.dimensions_measurement_unit AS dimensions_measurement_unit_49, t0.dimensions_length AS dimensions_length_50, t0.dimensions_width AS dimensions_width_51, t0.dimensions_height AS dimensions_height_52, t0.dimensions_weight_unit AS dimensions_weight_unit_53, t0.dimensions_weight AS dimensions_weight_54, t0.dimensions_volume AS dimensions_volume_55, t0.type_id AS type_id_56, t0.main_image_id AS main_image_id_57, t0.manufacturer_id AS manufacturer_id_58, t0.discr FROM products t0 WHERE t0.slug = ? AND t0.discr IN ('product') LIMIT 1 Parameters: [`"CB_61"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.custom_id AS custom_id_2, t0.softone_id AS softone_id_3, t0.name AS name_4, t0.slug AS slug_5, t0.summary AS summary_6, t0.description AS description_7, t0.status AS status_8, t0.keywords AS keywords_9, t0.general_comments AS general_comments_10, t0.published AS published_11, t0.featured AS featured_12, t0.sku AS sku_13, t0.mfr_code AS mfr_code_14, t0.blk_code AS blk_code_15, t0.ean_code AS ean_code_16, t0.supplier_code AS supplier_code_17, t0.volumetric_weight AS volumetric_weight_18, t0.views AS views_19, t0.sales AS sales_20, t0.created_at AS created_at_21, t0.supplier_url AS supplier_url_22, t0.in_the_box_text AS in_the_box_text_23, t0.discount_percent AS discount_percent_24, t0.available_at AS available_at_25, t0.offer AS offer_26, t0.cash_back AS cash_back_27, t0.ask_for_price AS ask_for_price_28, t0.warehouse_stock_warehouse AS warehouse_stock_warehouse_29, t0.warehouse_stock_quantity AS warehouse_stock_quantity_30, t0.warehouse_stock_reserved AS warehouse_stock_reserved_31, t0.warehouse_stock_target_stock AS warehouse_stock_target_stock_32, t0.warehouse_stock_immutable AS warehouse_stock_immutable_33, t0.price_gross_amount AS price_gross_amount_34, t0.price_gross_currency AS price_gross_currency_35, t0.price_with_discount_amount AS price_with_discount_amount_36, t0.price_with_discount_currency AS price_with_discount_currency_37, t0.price_url AS price_url_38, t0.price_comments AS price_comments_39, t0.supplier_discount AS supplier_discount_40, t0.special_discount AS special_discount_41, t0.customs_charges AS customs_charges_42, t0.expected_profit AS expected_profit_43, t0.accessories AS accessories_44, t0.original_price_amount AS original_price_amount_45, t0.original_price_currency AS original_price_currency_46, t0.supplier_shipping_value_amount AS supplier_shipping_value_amount_47, t0.supplier_shipping_value_currency AS supplier_shipping_value_currency_48, t0.dimensions_measurement_unit AS dimensions_measurement_unit_49, t0.dimensions_length AS dimensions_length_50, t0.dimensions_width AS dimensions_width_51, t0.dimensions_height AS dimensions_height_52, t0.dimensions_weight_unit AS dimensions_weight_unit_53, t0.dimensions_weight AS dimensions_weight_54, t0.dimensions_volume AS dimensions_volume_55, t0.type_id AS type_id_56, t0.main_image_id AS main_image_id_57, t0.manufacturer_id AS manufacturer_id_58, t0.discr FROM products t0 WHERE t0.slug = ? AND t0.discr IN ('product') LIMIT 1 SELECT t0.id AS id_1, t0.custom_id AS custom_id_2, t0.softone_id AS softone_id_3, t0.name AS name_4, t0.slug AS slug_5, t0.summary AS summary_6, t0.description AS description_7, t0.status AS status_8, t0.keywords AS keywords_9, t0.general_comments AS general_comments_10, t0.published AS published_11, t0.featured AS featured_12, t0.sku AS sku_13, t0.mfr_code AS mfr_code_14, t0.blk_code AS blk_code_15, t0.ean_code AS ean_code_16, t0.supplier_code AS supplier_code_17, t0.volumetric_weight AS volumetric_weight_18, t0.views AS views_19, t0.sales AS sales_20, t0.created_at AS created_at_21, t0.supplier_url AS supplier_url_22, t0.in_the_box_text AS in_the_box_text_23, t0.discount_percent AS discount_percent_24, t0.available_at AS available_at_25, t0.offer AS offer_26, t0.cash_back AS cash_back_27, t0.ask_for_price AS ask_for_price_28, t0.warehouse_stock_warehouse AS warehouse_stock_warehouse_29, t0.warehouse_stock_quantity AS warehouse_stock_quantity_30, t0.warehouse_stock_reserved AS warehouse_stock_reserved_31, t0.warehouse_stock_target_stock AS warehouse_stock_target_stock_32, t0.warehouse_stock_immutable AS warehouse_stock_immutable_33, t0.price_gross_amount AS price_gross_amount_34, t0.price_gross_currency AS price_gross_currency_35, t0.price_with_discount_amount AS price_with_discount_amount_36, t0.price_with_discount_currency AS price_with_discount_currency_37, t0.price_url AS price_url_38, t0.price_comments AS price_comments_39, t0.supplier_discount AS supplier_discount_40, t0.special_discount AS special_discount_41, t0.customs_charges AS customs_charges_42, t0.expected_profit AS expected_profit_43, t0.accessories AS accessories_44, t0.original_price_amount AS original_price_amount_45, t0.original_price_currency AS original_price_currency_46, t0.supplier_shipping_value_amount AS supplier_shipping_value_amount_47, t0.supplier_shipping_value_currency AS supplier_shipping_value_currency_48, t0.dimensions_measurement_unit AS dimensions_measurement_unit_49, t0.dimensions_length AS dimensions_length_50, t0.dimensions_width AS dimensions_width_51, t0.dimensions_height AS dimensions_height_52, t0.dimensions_weight_unit AS dimensions_weight_unit_53, t0.dimensions_weight AS dimensions_weight_54, t0.dimensions_volume AS dimensions_volume_55, t0.type_id AS type_id_56, t0.main_image_id AS main_image_id_57, t0.manufacturer_id AS manufacturer_id_58, t0.discr FROM products t0 WHERE t0.slug = 'CB_61' AND t0.discr IN ('product') LIMIT 1;
4	0.29 ms	SELECT p0_.content AS content_0, p0_.field AS field_1 FROM product_translations p0_ WHERE p0_.foreign_key = ? AND p0_.locale = ? AND p0_.object_class = ? Parameters: [`"8112" "en" "App\Entity\Product\Object\BaseProduct"`] View formatted query View runnable query Explain query SELECT p0_.content AS content_0, p0_.field AS field_1 FROM product_translations p0_ WHERE p0_.foreign_key = ? AND p0_.locale = ? AND p0_.object_class = ? SELECT p0_.content AS content_0, p0_.field AS field_1 FROM product_translations p0_ WHERE p0_.foreign_key = '8112' AND p0_.locale = 'en' AND p0_.object_class = 'App\\Entity\\Product\\Object\\BaseProduct';
5	0.14 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
6	0.27 ms	UPDATE products SET views = ? WHERE id = ? Parameters: [`75 8112`] View formatted query View runnable query Explain query UPDATE products SET views = ? WHERE id = ? UPDATE products SET views = 75 WHERE id = 8112;
7	2.76 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
8	0.22 ms	SELECT t0.id AS id_1, t0.title AS title_2, t0.type AS type_3, t0.url AS url_4 FROM product_reference t0 INNER JOIN products_references ON t0.id = products_references.reference_id WHERE products_references.product_id = ? Parameters: [`8112`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.title AS title_2, t0.type AS type_3, t0.url AS url_4 FROM product_reference t0 INNER JOIN products_references ON t0.id = products_references.reference_id WHERE products_references.product_id = ? SELECT t0.id AS id_1, t0.title AS title_2, t0.type AS type_3, t0.url AS url_4 FROM product_reference t0 INNER JOIN products_references ON t0.id = products_references.reference_id WHERE products_references.product_id = 8112;
9	0.67 ms	SELECT t0.id AS id_1, t0.session_id AS session_id_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.user_id AS user_id_5 FROM cart t0 WHERE t0.session_id = ? LIMIT 1 Parameters: [`"cart_6989706177f230.60966807"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.session_id AS session_id_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.user_id AS user_id_5 FROM cart t0 WHERE t0.session_id = ? LIMIT 1 SELECT t0.id AS id_1, t0.session_id AS session_id_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.user_id AS user_id_5 FROM cart t0 WHERE t0.session_id = 'cart_6989706177f230.60966807' LIMIT 1;
10	0.24 ms	SELECT t0.id AS id_1, t0.migration_id AS migration_id_2, t0.softone_id AS softone_id_3, t0.name AS name_4, t0.slug AS slug_5, t0.description AS description_6, t0.lft AS lft_7, t0.lvl AS lvl_8, t0.rgt AS rgt_9, t0.published AS published_10, t0.sort_index AS sort_index_11, t0.tree_root AS tree_root_12, t0.parent_id AS parent_id_13, t0.banner_id AS banner_id_14 FROM product_category t0 WHERE t0.lvl = ? Parameters: [`1`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.migration_id AS migration_id_2, t0.softone_id AS softone_id_3, t0.name AS name_4, t0.slug AS slug_5, t0.description AS description_6, t0.lft AS lft_7, t0.lvl AS lvl_8, t0.rgt AS rgt_9, t0.published AS published_10, t0.sort_index AS sort_index_11, t0.tree_root AS tree_root_12, t0.parent_id AS parent_id_13, t0.banner_id AS banner_id_14 FROM product_category t0 WHERE t0.lvl = ? SELECT t0.id AS id_1, t0.migration_id AS migration_id_2, t0.softone_id AS softone_id_3, t0.name AS name_4, t0.slug AS slug_5, t0.description AS description_6, t0.lft AS lft_7, t0.lvl AS lvl_8, t0.rgt AS rgt_9, t0.published AS published_10, t0.sort_index AS sort_index_11, t0.tree_root AS tree_root_12, t0.parent_id AS parent_id_13, t0.banner_id AS banner_id_14 FROM product_category t0 WHERE t0.lvl = 1;
11	0.15 ms	SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ? Parameters: [`"4" "en" "App\Entity\Product\Category"`] View formatted query View runnable query Explain query SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ? SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '4' AND e0_.locale = 'en' AND e0_.object_class = 'App\\Entity\\Product\\Category';
12	0.10 ms	SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ? Parameters: [`"5" "en" "App\Entity\Product\Category"`] View formatted query View runnable query Explain query SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ? SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '5' AND e0_.locale = 'en' AND e0_.object_class = 'App\\Entity\\Product\\Category';
13	0.09 ms	SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ? Parameters: [`"6" "en" "App\Entity\Product\Category"`] View formatted query View runnable query Explain query SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ? SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '6' AND e0_.locale = 'en' AND e0_.object_class = 'App\\Entity\\Product\\Category';
14	0.09 ms	SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ? Parameters: [`"7" "en" "App\Entity\Product\Category"`] View formatted query View runnable query Explain query SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ? SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '7' AND e0_.locale = 'en' AND e0_.object_class = 'App\\Entity\\Product\\Category';
15	0.09 ms	SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ? Parameters: [`"8" "en" "App\Entity\Product\Category"`] View formatted query View runnable query Explain query SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ? SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '8' AND e0_.locale = 'en' AND e0_.object_class = 'App\\Entity\\Product\\Category';
16	0.09 ms	SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ? Parameters: [`"9" "en" "App\Entity\Product\Category"`] View formatted query View runnable query Explain query SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ? SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '9' AND e0_.locale = 'en' AND e0_.object_class = 'App\\Entity\\Product\\Category';
17	0.13 ms	SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ? Parameters: [`"10" "en" "App\Entity\Product\Category"`] View formatted query View runnable query Explain query SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ? SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '10' AND e0_.locale = 'en' AND e0_.object_class = 'App\\Entity\\Product\\Category';
18	0.09 ms	SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ? Parameters: [`"11" "en" "App\Entity\Product\Category"`] View formatted query View runnable query Explain query SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ? SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '11' AND e0_.locale = 'en' AND e0_.object_class = 'App\\Entity\\Product\\Category';
19	0.08 ms	SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ? Parameters: [`"14" "en" "App\Entity\Product\Category"`] View formatted query View runnable query Explain query SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ? SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '14' AND e0_.locale = 'en' AND e0_.object_class = 'App\\Entity\\Product\\Category';
20	0.13 ms	SELECT t0.id AS id_1, t0.migration_id AS migration_id_2, t0.softone_id AS softone_id_3, t0.name AS name_4, t0.slug AS slug_5, t0.description AS description_6, t0.lft AS lft_7, t0.lvl AS lvl_8, t0.rgt AS rgt_9, t0.published AS published_10, t0.sort_index AS sort_index_11, t0.tree_root AS tree_root_12, t0.parent_id AS parent_id_13, t0.banner_id AS banner_id_14 FROM product_category t0 WHERE t0.tree_root = ? LIMIT 1 Parameters: [`true`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.migration_id AS migration_id_2, t0.softone_id AS softone_id_3, t0.name AS name_4, t0.slug AS slug_5, t0.description AS description_6, t0.lft AS lft_7, t0.lvl AS lvl_8, t0.rgt AS rgt_9, t0.published AS published_10, t0.sort_index AS sort_index_11, t0.tree_root AS tree_root_12, t0.parent_id AS parent_id_13, t0.banner_id AS banner_id_14 FROM product_category t0 WHERE t0.tree_root = ? LIMIT 1 SELECT t0.id AS id_1, t0.migration_id AS migration_id_2, t0.softone_id AS softone_id_3, t0.name AS name_4, t0.slug AS slug_5, t0.description AS description_6, t0.lft AS lft_7, t0.lvl AS lvl_8, t0.rgt AS rgt_9, t0.published AS published_10, t0.sort_index AS sort_index_11, t0.tree_root AS tree_root_12, t0.parent_id AS parent_id_13, t0.banner_id AS banner_id_14 FROM product_category t0 WHERE t0.tree_root = 1 LIMIT 1;
21	0.13 ms	SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ? Parameters: [`"1" "en" "App\Entity\Product\Category"`] View formatted query View runnable query Explain query SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ? SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '1' AND e0_.locale = 'en' AND e0_.object_class = 'App\\Entity\\Product\\Category';
22	0.67 ms	SELECT p0_.id AS id_0, p0_.migration_id AS migration_id_1, p0_.softone_id AS softone_id_2, p0_.name AS name_3, p0_.slug AS slug_4, p0_.description AS description_5, p0_.lft AS lft_6, p0_.lvl AS lvl_7, p0_.rgt AS rgt_8, p0_.published AS published_9, p0_.sort_index AS sort_index_10 FROM product_category p0_ WHERE p0_.rgt < 924 AND p0_.lft > 1 AND p0_.tree_root = ? ORDER BY p0_.tree_root ASC, p0_.lft ASC Parameters: [`1`] View formatted query View runnable query Explain query SELECT p0_.id AS id_0, p0_.migration_id AS migration_id_1, p0_.softone_id AS softone_id_2, p0_.name AS name_3, p0_.slug AS slug_4, p0_.description AS description_5, p0_.lft AS lft_6, p0_.lvl AS lvl_7, p0_.rgt AS rgt_8, p0_.published AS published_9, p0_.sort_index AS sort_index_10 FROM product_category p0_ WHERE p0_.rgt < 924 AND p0_.lft > 1 AND p0_.tree_root = ? ORDER BY p0_.tree_root ASC, p0_.lft ASC SELECT p0_.id AS id_0, p0_.migration_id AS migration_id_1, p0_.softone_id AS softone_id_2, p0_.name AS name_3, p0_.slug AS slug_4, p0_.description AS description_5, p0_.lft AS lft_6, p0_.lvl AS lvl_7, p0_.rgt AS rgt_8, p0_.published AS published_9, p0_.sort_index AS sort_index_10 FROM product_category p0_ WHERE p0_.rgt < 924 AND p0_.lft > 1 AND p0_.tree_root = 1 ORDER BY p0_.tree_root ASC, p0_.lft ASC;
23	0.16 ms	SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.wishlist AS wishlist_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.price_amount AS price_amount_6, t0.price_currency AS price_currency_7, t0.cart_id AS cart_id_8, t0.product_id AS product_id_9 FROM cart_item t0 WHERE t0.cart_id = ? Parameters: [b"\x1F\x10WŸ`nä±R¡°[!ãd"] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.wishlist AS wishlist_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.price_amount AS price_amount_6, t0.price_currency AS price_currency_7, t0.cart_id AS cart_id_8, t0.product_id AS product_id_9 FROM cart_item t0 WHERE t0.cart_id = ? SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.wishlist AS wishlist_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.price_amount AS price_amount_6, t0.price_currency AS price_currency_7, t0.cart_id AS cart_id_8, t0.product_id AS product_id_9 FROM cart_item t0 WHERE t0.cart_id = 0x1F1057819F606EE4B152A1B05B21E364;
24	0.15 ms	SELECT t0.id AS id_1, t0.text_value AS text_value_2, t0.quantity AS quantity_3, t0.product_id AS product_id_4, t0.attribute_id AS attribute_id_5, t0.attribute_value_id AS attribute_value_id_6 FROM product_attribute_value t0 WHERE t0.product_id = ? Parameters: [`8112`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.text_value AS text_value_2, t0.quantity AS quantity_3, t0.product_id AS product_id_4, t0.attribute_id AS attribute_id_5, t0.attribute_value_id AS attribute_value_id_6 FROM product_attribute_value t0 WHERE t0.product_id = ? SELECT t0.id AS id_1, t0.text_value AS text_value_2, t0.quantity AS quantity_3, t0.product_id AS product_id_4, t0.attribute_id AS attribute_id_5, t0.attribute_value_id AS attribute_value_id_6 FROM product_attribute_value t0 WHERE t0.product_id = 8112;
25	0.23 ms	SELECT t0.id AS id_1, t0.migration_id AS migration_id_2, t0.softone_id AS softone_id_3, t0.name AS name_4, t0.slug AS slug_5, t0.description AS description_6, t0.lft AS lft_7, t0.lvl AS lvl_8, t0.rgt AS rgt_9, t0.published AS published_10, t0.sort_index AS sort_index_11, t0.tree_root AS tree_root_12, t0.parent_id AS parent_id_13, t0.banner_id AS banner_id_14 FROM product_category t0 WHERE t0.parent_id = ? ORDER BY t0.lft ASC Parameters: [`4`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.migration_id AS migration_id_2, t0.softone_id AS softone_id_3, t0.name AS name_4, t0.slug AS slug_5, t0.description AS description_6, t0.lft AS lft_7, t0.lvl AS lvl_8, t0.rgt AS rgt_9, t0.published AS published_10, t0.sort_index AS sort_index_11, t0.tree_root AS tree_root_12, t0.parent_id AS parent_id_13, t0.banner_id AS banner_id_14 FROM product_category t0 WHERE t0.parent_id = ? ORDER BY t0.lft ASC SELECT t0.id AS id_1, t0.migration_id AS migration_id_2, t0.softone_id AS softone_id_3, t0.name AS name_4, t0.slug AS slug_5, t0.description AS description_6, t0.lft AS lft_7, t0.lvl AS lvl_8, t0.rgt AS rgt_9, t0.published AS published_10, t0.sort_index AS sort_index_11, t0.tree_root AS tree_root_12, t0.parent_id AS parent_id_13, t0.banner_id AS banner_id_14 FROM product_category t0 WHERE t0.parent_id = 4 ORDER BY t0.lft ASC;
26	0.19 ms	SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ? Parameters: [`"15" "en" "App\Entity\Product\Category"`] View formatted query View runnable query Explain query SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ? SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '15' AND e0_.locale = 'en' AND e0_.object_class = 'App\\Entity\\Product\\Category';
27	0.17 ms	SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ? Parameters: [`"17" "en" "App\Entity\Product\Category"`] View formatted query View runnable query Explain query SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ? SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '17' AND e0_.locale = 'en' AND e0_.object_class = 'App\\Entity\\Product\\Category';
28	0.14 ms	SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ? Parameters: [`"19" "en" "App\Entity\Product\Category"`] View formatted query View runnable query Explain query SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ? SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '19' AND e0_.locale = 'en' AND e0_.object_class = 'App\\Entity\\Product\\Category';
29	0.10 ms	SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ? Parameters: [`"20" "en" "App\Entity\Product\Category"`] View formatted query View runnable query Explain query SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ? SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '20' AND e0_.locale = 'en' AND e0_.object_class = 'App\\Entity\\Product\\Category';
30	0.09 ms	SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ? Parameters: [`"22" "en" "App\Entity\Product\Category"`] View formatted query View runnable query Explain query SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ? SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '22' AND e0_.locale = 'en' AND e0_.object_class = 'App\\Entity\\Product\\Category';
31	0.20 ms	SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ? Parameters: [`"24" "en" "App\Entity\Product\Category"`] View formatted query View runnable query Explain query SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ? SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '24' AND e0_.locale = 'en' AND e0_.object_class = 'App\\Entity\\Product\\Category';
32	0.14 ms	SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ? Parameters: [`"25" "en" "App\Entity\Product\Category"`] View formatted query View runnable query Explain query SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ? SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '25' AND e0_.locale = 'en' AND e0_.object_class = 'App\\Entity\\Product\\Category';
33	0.13 ms	SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ? Parameters: [`"27" "en" "App\Entity\Product\Category"`] View formatted query View runnable query Explain query SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ? SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '27' AND e0_.locale = 'en' AND e0_.object_class = 'App\\Entity\\Product\\Category';
34	0.11 ms	SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ? Parameters: [`"28" "en" "App\Entity\Product\Category"`] View formatted query View runnable query Explain query SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ? SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '28' AND e0_.locale = 'en' AND e0_.object_class = 'App\\Entity\\Product\\Category';
35	0.14 ms	SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ? Parameters: [`"30" "en" "App\Entity\Product\Category"`] View formatted query View runnable query Explain query SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ? SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '30' AND e0_.locale = 'en' AND e0_.object_class = 'App\\Entity\\Product\\Category';
36	0.22 ms	SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ? Parameters: [`"32" "en" "App\Entity\Product\Category"`] View formatted query View runnable query Explain query SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ? SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '32' AND e0_.locale = 'en' AND e0_.object_class = 'App\\Entity\\Product\\Category';
37	0.21 ms	SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ? Parameters: [`"33" "en" "App\Entity\Product\Category"`] View formatted query View runnable query Explain query SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ? SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '33' AND e0_.locale = 'en' AND e0_.object_class = 'App\\Entity\\Product\\Category';
38	0.19 ms	SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ? Parameters: [`"36" "en" "App\Entity\Product\Category"`] View formatted query View runnable query Explain query SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ? SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '36' AND e0_.locale = 'en' AND e0_.object_class = 'App\\Entity\\Product\\Category';
39	0.20 ms	SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ? Parameters: [`"37" "en" "App\Entity\Product\Category"`] View formatted query View runnable query Explain query SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ? SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '37' AND e0_.locale = 'en' AND e0_.object_class = 'App\\Entity\\Product\\Category';
40	0.21 ms	SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ? Parameters: [`"38" "en" "App\Entity\Product\Category"`] View formatted query View runnable query Explain query SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ? SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '38' AND e0_.locale = 'en' AND e0_.object_class = 'App\\Entity\\Product\\Category';
41	0.19 ms	SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ? Parameters: [`"39" "en" "App\Entity\Product\Category"`] View formatted query View runnable query Explain query SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ? SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '39' AND e0_.locale = 'en' AND e0_.object_class = 'App\\Entity\\Product\\Category';
42	0.19 ms	SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ? Parameters: [`"40" "en" "App\Entity\Product\Category"`] View formatted query View runnable query Explain query SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ? SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '40' AND e0_.locale = 'en' AND e0_.object_class = 'App\\Entity\\Product\\Category';
43	0.19 ms	SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ? Parameters: [`"41" "en" "App\Entity\Product\Category"`] View formatted query View runnable query Explain query SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ? SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '41' AND e0_.locale = 'en' AND e0_.object_class = 'App\\Entity\\Product\\Category';
44	0.19 ms	SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ? Parameters: [`"42" "en" "App\Entity\Product\Category"`] View formatted query View runnable query Explain query SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ? SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '42' AND e0_.locale = 'en' AND e0_.object_class = 'App\\Entity\\Product\\Category';
45	0.10 ms	SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ? Parameters: [`"43" "en" "App\Entity\Product\Category"`] View formatted query View runnable query Explain query SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ? SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '43' AND e0_.locale = 'en' AND e0_.object_class = 'App\\Entity\\Product\\Category';
46	0.08 ms	SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ? Parameters: [`"44" "en" "App\Entity\Product\Category"`] View formatted query View runnable query Explain query SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ? SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '44' AND e0_.locale = 'en' AND e0_.object_class = 'App\\Entity\\Product\\Category';
47	0.08 ms	SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ? Parameters: [`"45" "en" "App\Entity\Product\Category"`] View formatted query View runnable query Explain query SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ? SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '45' AND e0_.locale = 'en' AND e0_.object_class = 'App\\Entity\\Product\\Category';
48	0.09 ms	SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ? Parameters: [`"46" "en" "App\Entity\Product\Category"`] View formatted query View runnable query Explain query SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ? SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '46' AND e0_.locale = 'en' AND e0_.object_class = 'App\\Entity\\Product\\Category';
49	0.08 ms	SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ? Parameters: [`"47" "en" "App\Entity\Product\Category"`] View formatted query View runnable query Explain query SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ? SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '47' AND e0_.locale = 'en' AND e0_.object_class = 'App\\Entity\\Product\\Category';
50	0.08 ms	SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ? Parameters: [`"48" "en" "App\Entity\Product\Category"`] View formatted query View runnable query Explain query SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ? SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '48' AND e0_.locale = 'en' AND e0_.object_class = 'App\\Entity\\Product\\Category';
51	0.08 ms	SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ? Parameters: [`"49" "en" "App\Entity\Product\Category"`] View formatted query View runnable query Explain query SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ? SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '49' AND e0_.locale = 'en' AND e0_.object_class = 'App\\Entity\\Product\\Category';
52	0.08 ms	SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ? Parameters: [`"50" "en" "App\Entity\Product\Category"`] View formatted query View runnable query Explain query SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ? SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '50' AND e0_.locale = 'en' AND e0_.object_class = 'App\\Entity\\Product\\Category';
53	0.09 ms	SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ? Parameters: [`"51" "en" "App\Entity\Product\Category"`] View formatted query View runnable query Explain query SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ? SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '51' AND e0_.locale = 'en' AND e0_.object_class = 'App\\Entity\\Product\\Category';
54	0.17 ms	SELECT t0.id AS id_1, t0.migration_id AS migration_id_2, t0.softone_id AS softone_id_3, t0.name AS name_4, t0.slug AS slug_5, t0.description AS description_6, t0.lft AS lft_7, t0.lvl AS lvl_8, t0.rgt AS rgt_9, t0.published AS published_10, t0.sort_index AS sort_index_11, t0.tree_root AS tree_root_12, t0.parent_id AS parent_id_13, t0.banner_id AS banner_id_14 FROM product_category t0 WHERE t0.parent_id = ? ORDER BY t0.lft ASC Parameters: [`5`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.migration_id AS migration_id_2, t0.softone_id AS softone_id_3, t0.name AS name_4, t0.slug AS slug_5, t0.description AS description_6, t0.lft AS lft_7, t0.lvl AS lvl_8, t0.rgt AS rgt_9, t0.published AS published_10, t0.sort_index AS sort_index_11, t0.tree_root AS tree_root_12, t0.parent_id AS parent_id_13, t0.banner_id AS banner_id_14 FROM product_category t0 WHERE t0.parent_id = ? ORDER BY t0.lft ASC SELECT t0.id AS id_1, t0.migration_id AS migration_id_2, t0.softone_id AS softone_id_3, t0.name AS name_4, t0.slug AS slug_5, t0.description AS description_6, t0.lft AS lft_7, t0.lvl AS lvl_8, t0.rgt AS rgt_9, t0.published AS published_10, t0.sort_index AS sort_index_11, t0.tree_root AS tree_root_12, t0.parent_id AS parent_id_13, t0.banner_id AS banner_id_14 FROM product_category t0 WHERE t0.parent_id = 5 ORDER BY t0.lft ASC;
55	0.15 ms	SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ? Parameters: [`"18" "en" "App\Entity\Product\Category"`] View formatted query View runnable query Explain query SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ? SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '18' AND e0_.locale = 'en' AND e0_.object_class = 'App\\Entity\\Product\\Category';
56	0.09 ms	SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ? Parameters: [`"23" "en" "App\Entity\Product\Category"`] View formatted query View runnable query Explain query SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ? SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '23' AND e0_.locale = 'en' AND e0_.object_class = 'App\\Entity\\Product\\Category';
57	0.10 ms	SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ? Parameters: [`"31" "en" "App\Entity\Product\Category"`] View formatted query View runnable query Explain query SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ? SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '31' AND e0_.locale = 'en' AND e0_.object_class = 'App\\Entity\\Product\\Category';
58	0.08 ms	SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ? Parameters: [`"35" "en" "App\Entity\Product\Category"`] View formatted query View runnable query Explain query SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ? SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '35' AND e0_.locale = 'en' AND e0_.object_class = 'App\\Entity\\Product\\Category';
59	0.12 ms	SELECT t0.id AS id_1, t0.migration_id AS migration_id_2, t0.softone_id AS softone_id_3, t0.name AS name_4, t0.slug AS slug_5, t0.description AS description_6, t0.lft AS lft_7, t0.lvl AS lvl_8, t0.rgt AS rgt_9, t0.published AS published_10, t0.sort_index AS sort_index_11, t0.tree_root AS tree_root_12, t0.parent_id AS parent_id_13, t0.banner_id AS banner_id_14 FROM product_category t0 WHERE t0.parent_id = ? ORDER BY t0.lft ASC Parameters: [`6`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.migration_id AS migration_id_2, t0.softone_id AS softone_id_3, t0.name AS name_4, t0.slug AS slug_5, t0.description AS description_6, t0.lft AS lft_7, t0.lvl AS lvl_8, t0.rgt AS rgt_9, t0.published AS published_10, t0.sort_index AS sort_index_11, t0.tree_root AS tree_root_12, t0.parent_id AS parent_id_13, t0.banner_id AS banner_id_14 FROM product_category t0 WHERE t0.parent_id = ? ORDER BY t0.lft ASC SELECT t0.id AS id_1, t0.migration_id AS migration_id_2, t0.softone_id AS softone_id_3, t0.name AS name_4, t0.slug AS slug_5, t0.description AS description_6, t0.lft AS lft_7, t0.lvl AS lvl_8, t0.rgt AS rgt_9, t0.published AS published_10, t0.sort_index AS sort_index_11, t0.tree_root AS tree_root_12, t0.parent_id AS parent_id_13, t0.banner_id AS banner_id_14 FROM product_category t0 WHERE t0.parent_id = 6 ORDER BY t0.lft ASC;
60	0.14 ms	SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ? Parameters: [`"52" "en" "App\Entity\Product\Category"`] View formatted query View runnable query Explain query SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ? SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '52' AND e0_.locale = 'en' AND e0_.object_class = 'App\\Entity\\Product\\Category';
61	0.12 ms	SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ? Parameters: [`"55" "en" "App\Entity\Product\Category"`] View formatted query View runnable query Explain query SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ? SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '55' AND e0_.locale = 'en' AND e0_.object_class = 'App\\Entity\\Product\\Category';
62	0.16 ms	SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ? Parameters: [`"58" "en" "App\Entity\Product\Category"`] View formatted query View runnable query Explain query SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ? SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '58' AND e0_.locale = 'en' AND e0_.object_class = 'App\\Entity\\Product\\Category';
63	0.13 ms	SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ? Parameters: [`"61" "en" "App\Entity\Product\Category"`] View formatted query View runnable query Explain query SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ? SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '61' AND e0_.locale = 'en' AND e0_.object_class = 'App\\Entity\\Product\\Category';
64	0.10 ms	SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ? Parameters: [`"65" "en" "App\Entity\Product\Category"`] View formatted query View runnable query Explain query SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ? SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '65' AND e0_.locale = 'en' AND e0_.object_class = 'App\\Entity\\Product\\Category';
65	0.09 ms	SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ? Parameters: [`"67" "en" "App\Entity\Product\Category"`] View formatted query View runnable query Explain query SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ? SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '67' AND e0_.locale = 'en' AND e0_.object_class = 'App\\Entity\\Product\\Category';
66	0.09 ms	SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ? Parameters: [`"70" "en" "App\Entity\Product\Category"`] View formatted query View runnable query Explain query SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ? SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '70' AND e0_.locale = 'en' AND e0_.object_class = 'App\\Entity\\Product\\Category';
67	0.09 ms	SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ? Parameters: [`"74" "en" "App\Entity\Product\Category"`] View formatted query View runnable query Explain query SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ? SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '74' AND e0_.locale = 'en' AND e0_.object_class = 'App\\Entity\\Product\\Category';
68	0.13 ms	SELECT t0.id AS id_1, t0.migration_id AS migration_id_2, t0.softone_id AS softone_id_3, t0.name AS name_4, t0.slug AS slug_5, t0.description AS description_6, t0.lft AS lft_7, t0.lvl AS lvl_8, t0.rgt AS rgt_9, t0.published AS published_10, t0.sort_index AS sort_index_11, t0.tree_root AS tree_root_12, t0.parent_id AS parent_id_13, t0.banner_id AS banner_id_14 FROM product_category t0 WHERE t0.parent_id = ? ORDER BY t0.lft ASC Parameters: [`7`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.migration_id AS migration_id_2, t0.softone_id AS softone_id_3, t0.name AS name_4, t0.slug AS slug_5, t0.description AS description_6, t0.lft AS lft_7, t0.lvl AS lvl_8, t0.rgt AS rgt_9, t0.published AS published_10, t0.sort_index AS sort_index_11, t0.tree_root AS tree_root_12, t0.parent_id AS parent_id_13, t0.banner_id AS banner_id_14 FROM product_category t0 WHERE t0.parent_id = ? ORDER BY t0.lft ASC SELECT t0.id AS id_1, t0.migration_id AS migration_id_2, t0.softone_id AS softone_id_3, t0.name AS name_4, t0.slug AS slug_5, t0.description AS description_6, t0.lft AS lft_7, t0.lvl AS lvl_8, t0.rgt AS rgt_9, t0.published AS published_10, t0.sort_index AS sort_index_11, t0.tree_root AS tree_root_12, t0.parent_id AS parent_id_13, t0.banner_id AS banner_id_14 FROM product_category t0 WHERE t0.parent_id = 7 ORDER BY t0.lft ASC;
69	0.21 ms	SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ? Parameters: [`"53" "en" "App\Entity\Product\Category"`] View formatted query View runnable query Explain query SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ? SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '53' AND e0_.locale = 'en' AND e0_.object_class = 'App\\Entity\\Product\\Category';
70	0.15 ms	SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ? Parameters: [`"57" "en" "App\Entity\Product\Category"`] View formatted query View runnable query Explain query SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ? SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '57' AND e0_.locale = 'en' AND e0_.object_class = 'App\\Entity\\Product\\Category';
71	0.13 ms	SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ? Parameters: [`"59" "en" "App\Entity\Product\Category"`] View formatted query View runnable query Explain query SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ? SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '59' AND e0_.locale = 'en' AND e0_.object_class = 'App\\Entity\\Product\\Category';
72	0.13 ms	SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ? Parameters: [`"62" "en" "App\Entity\Product\Category"`] View formatted query View runnable query Explain query SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ? SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '62' AND e0_.locale = 'en' AND e0_.object_class = 'App\\Entity\\Product\\Category';
73	0.12 ms	SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ? Parameters: [`"64" "en" "App\Entity\Product\Category"`] View formatted query View runnable query Explain query SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ? SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '64' AND e0_.locale = 'en' AND e0_.object_class = 'App\\Entity\\Product\\Category';
74	0.12 ms	SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ? Parameters: [`"68" "en" "App\Entity\Product\Category"`] View formatted query View runnable query Explain query SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ? SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '68' AND e0_.locale = 'en' AND e0_.object_class = 'App\\Entity\\Product\\Category';
75	0.11 ms	SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ? Parameters: [`"71" "en" "App\Entity\Product\Category"`] View formatted query View runnable query Explain query SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ? SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '71' AND e0_.locale = 'en' AND e0_.object_class = 'App\\Entity\\Product\\Category';
76	0.11 ms	SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ? Parameters: [`"72" "en" "App\Entity\Product\Category"`] View formatted query View runnable query Explain query SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ? SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '72' AND e0_.locale = 'en' AND e0_.object_class = 'App\\Entity\\Product\\Category';
77	0.12 ms	SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ? Parameters: [`"75" "en" "App\Entity\Product\Category"`] View formatted query View runnable query Explain query SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ? SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '75' AND e0_.locale = 'en' AND e0_.object_class = 'App\\Entity\\Product\\Category';
78	0.19 ms	SELECT t0.id AS id_1, t0.migration_id AS migration_id_2, t0.softone_id AS softone_id_3, t0.name AS name_4, t0.slug AS slug_5, t0.description AS description_6, t0.lft AS lft_7, t0.lvl AS lvl_8, t0.rgt AS rgt_9, t0.published AS published_10, t0.sort_index AS sort_index_11, t0.tree_root AS tree_root_12, t0.parent_id AS parent_id_13, t0.banner_id AS banner_id_14 FROM product_category t0 WHERE t0.parent_id = ? ORDER BY t0.lft ASC Parameters: [`8`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.migration_id AS migration_id_2, t0.softone_id AS softone_id_3, t0.name AS name_4, t0.slug AS slug_5, t0.description AS description_6, t0.lft AS lft_7, t0.lvl AS lvl_8, t0.rgt AS rgt_9, t0.published AS published_10, t0.sort_index AS sort_index_11, t0.tree_root AS tree_root_12, t0.parent_id AS parent_id_13, t0.banner_id AS banner_id_14 FROM product_category t0 WHERE t0.parent_id = ? ORDER BY t0.lft ASC SELECT t0.id AS id_1, t0.migration_id AS migration_id_2, t0.softone_id AS softone_id_3, t0.name AS name_4, t0.slug AS slug_5, t0.description AS description_6, t0.lft AS lft_7, t0.lvl AS lvl_8, t0.rgt AS rgt_9, t0.published AS published_10, t0.sort_index AS sort_index_11, t0.tree_root AS tree_root_12, t0.parent_id AS parent_id_13, t0.banner_id AS banner_id_14 FROM product_category t0 WHERE t0.parent_id = 8 ORDER BY t0.lft ASC;
79	0.16 ms	SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ? Parameters: [`"16" "en" "App\Entity\Product\Category"`] View formatted query View runnable query Explain query SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ? SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '16' AND e0_.locale = 'en' AND e0_.object_class = 'App\\Entity\\Product\\Category';
80	0.13 ms	SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ? Parameters: [`"21" "en" "App\Entity\Product\Category"`] View formatted query View runnable query Explain query SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ? SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '21' AND e0_.locale = 'en' AND e0_.object_class = 'App\\Entity\\Product\\Category';
81	0.12 ms	SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ? Parameters: [`"29" "en" "App\Entity\Product\Category"`] View formatted query View runnable query Explain query SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ? SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '29' AND e0_.locale = 'en' AND e0_.object_class = 'App\\Entity\\Product\\Category';
82	0.12 ms	SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ? Parameters: [`"34" "en" "App\Entity\Product\Category"`] View formatted query View runnable query Explain query SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ? SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '34' AND e0_.locale = 'en' AND e0_.object_class = 'App\\Entity\\Product\\Category';
83	0.18 ms	SELECT t0.id AS id_1, t0.migration_id AS migration_id_2, t0.softone_id AS softone_id_3, t0.name AS name_4, t0.slug AS slug_5, t0.description AS description_6, t0.lft AS lft_7, t0.lvl AS lvl_8, t0.rgt AS rgt_9, t0.published AS published_10, t0.sort_index AS sort_index_11, t0.tree_root AS tree_root_12, t0.parent_id AS parent_id_13, t0.banner_id AS banner_id_14 FROM product_category t0 WHERE t0.parent_id = ? ORDER BY t0.lft ASC Parameters: [`9`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.migration_id AS migration_id_2, t0.softone_id AS softone_id_3, t0.name AS name_4, t0.slug AS slug_5, t0.description AS description_6, t0.lft AS lft_7, t0.lvl AS lvl_8, t0.rgt AS rgt_9, t0.published AS published_10, t0.sort_index AS sort_index_11, t0.tree_root AS tree_root_12, t0.parent_id AS parent_id_13, t0.banner_id AS banner_id_14 FROM product_category t0 WHERE t0.parent_id = ? ORDER BY t0.lft ASC SELECT t0.id AS id_1, t0.migration_id AS migration_id_2, t0.softone_id AS softone_id_3, t0.name AS name_4, t0.slug AS slug_5, t0.description AS description_6, t0.lft AS lft_7, t0.lvl AS lvl_8, t0.rgt AS rgt_9, t0.published AS published_10, t0.sort_index AS sort_index_11, t0.tree_root AS tree_root_12, t0.parent_id AS parent_id_13, t0.banner_id AS banner_id_14 FROM product_category t0 WHERE t0.parent_id = 9 ORDER BY t0.lft ASC;
84	0.16 ms	SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ? Parameters: [`"54" "en" "App\Entity\Product\Category"`] View formatted query View runnable query Explain query SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ? SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '54' AND e0_.locale = 'en' AND e0_.object_class = 'App\\Entity\\Product\\Category';
85	0.14 ms	SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ? Parameters: [`"56" "en" "App\Entity\Product\Category"`] View formatted query View runnable query Explain query SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ? SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '56' AND e0_.locale = 'en' AND e0_.object_class = 'App\\Entity\\Product\\Category';
86	0.13 ms	SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ? Parameters: [`"60" "en" "App\Entity\Product\Category"`] View formatted query View runnable query Explain query SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ? SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '60' AND e0_.locale = 'en' AND e0_.object_class = 'App\\Entity\\Product\\Category';
87	0.12 ms	SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ? Parameters: [`"63" "en" "App\Entity\Product\Category"`] View formatted query View runnable query Explain query SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ? SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '63' AND e0_.locale = 'en' AND e0_.object_class = 'App\\Entity\\Product\\Category';
88	0.12 ms	SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ? Parameters: [`"66" "en" "App\Entity\Product\Category"`] View formatted query View runnable query Explain query SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ? SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '66' AND e0_.locale = 'en' AND e0_.object_class = 'App\\Entity\\Product\\Category';
89	0.15 ms	SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ? Parameters: [`"69" "en" "App\Entity\Product\Category"`] View formatted query View runnable query Explain query SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ? SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '69' AND e0_.locale = 'en' AND e0_.object_class = 'App\\Entity\\Product\\Category';
90	0.11 ms	SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ? Parameters: [`"73" "en" "App\Entity\Product\Category"`] View formatted query View runnable query Explain query SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ? SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '73' AND e0_.locale = 'en' AND e0_.object_class = 'App\\Entity\\Product\\Category';
91	0.13 ms	SELECT t0.id AS id_1, t0.migration_id AS migration_id_2, t0.softone_id AS softone_id_3, t0.name AS name_4, t0.slug AS slug_5, t0.description AS description_6, t0.lft AS lft_7, t0.lvl AS lvl_8, t0.rgt AS rgt_9, t0.published AS published_10, t0.sort_index AS sort_index_11, t0.tree_root AS tree_root_12, t0.parent_id AS parent_id_13, t0.banner_id AS banner_id_14 FROM product_category t0 WHERE t0.parent_id = ? ORDER BY t0.lft ASC Parameters: [`10`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.migration_id AS migration_id_2, t0.softone_id AS softone_id_3, t0.name AS name_4, t0.slug AS slug_5, t0.description AS description_6, t0.lft AS lft_7, t0.lvl AS lvl_8, t0.rgt AS rgt_9, t0.published AS published_10, t0.sort_index AS sort_index_11, t0.tree_root AS tree_root_12, t0.parent_id AS parent_id_13, t0.banner_id AS banner_id_14 FROM product_category t0 WHERE t0.parent_id = ? ORDER BY t0.lft ASC SELECT t0.id AS id_1, t0.migration_id AS migration_id_2, t0.softone_id AS softone_id_3, t0.name AS name_4, t0.slug AS slug_5, t0.description AS description_6, t0.lft AS lft_7, t0.lvl AS lvl_8, t0.rgt AS rgt_9, t0.published AS published_10, t0.sort_index AS sort_index_11, t0.tree_root AS tree_root_12, t0.parent_id AS parent_id_13, t0.banner_id AS banner_id_14 FROM product_category t0 WHERE t0.parent_id = 10 ORDER BY t0.lft ASC;
92	0.11 ms	SELECT t0.id AS id_1, t0.migration_id AS migration_id_2, t0.softone_id AS softone_id_3, t0.name AS name_4, t0.slug AS slug_5, t0.description AS description_6, t0.lft AS lft_7, t0.lvl AS lvl_8, t0.rgt AS rgt_9, t0.published AS published_10, t0.sort_index AS sort_index_11, t0.tree_root AS tree_root_12, t0.parent_id AS parent_id_13, t0.banner_id AS banner_id_14 FROM product_category t0 WHERE t0.parent_id = ? ORDER BY t0.lft ASC Parameters: [`11`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.migration_id AS migration_id_2, t0.softone_id AS softone_id_3, t0.name AS name_4, t0.slug AS slug_5, t0.description AS description_6, t0.lft AS lft_7, t0.lvl AS lvl_8, t0.rgt AS rgt_9, t0.published AS published_10, t0.sort_index AS sort_index_11, t0.tree_root AS tree_root_12, t0.parent_id AS parent_id_13, t0.banner_id AS banner_id_14 FROM product_category t0 WHERE t0.parent_id = ? ORDER BY t0.lft ASC SELECT t0.id AS id_1, t0.migration_id AS migration_id_2, t0.softone_id AS softone_id_3, t0.name AS name_4, t0.slug AS slug_5, t0.description AS description_6, t0.lft AS lft_7, t0.lvl AS lvl_8, t0.rgt AS rgt_9, t0.published AS published_10, t0.sort_index AS sort_index_11, t0.tree_root AS tree_root_12, t0.parent_id AS parent_id_13, t0.banner_id AS banner_id_14 FROM product_category t0 WHERE t0.parent_id = 11 ORDER BY t0.lft ASC;
93	0.10 ms	SELECT t0.id AS id_1, t0.migration_id AS migration_id_2, t0.softone_id AS softone_id_3, t0.name AS name_4, t0.slug AS slug_5, t0.description AS description_6, t0.lft AS lft_7, t0.lvl AS lvl_8, t0.rgt AS rgt_9, t0.published AS published_10, t0.sort_index AS sort_index_11, t0.tree_root AS tree_root_12, t0.parent_id AS parent_id_13, t0.banner_id AS banner_id_14 FROM product_category t0 WHERE t0.parent_id = ? ORDER BY t0.lft ASC Parameters: [`14`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.migration_id AS migration_id_2, t0.softone_id AS softone_id_3, t0.name AS name_4, t0.slug AS slug_5, t0.description AS description_6, t0.lft AS lft_7, t0.lvl AS lvl_8, t0.rgt AS rgt_9, t0.published AS published_10, t0.sort_index AS sort_index_11, t0.tree_root AS tree_root_12, t0.parent_id AS parent_id_13, t0.banner_id AS banner_id_14 FROM product_category t0 WHERE t0.parent_id = ? ORDER BY t0.lft ASC SELECT t0.id AS id_1, t0.migration_id AS migration_id_2, t0.softone_id AS softone_id_3, t0.name AS name_4, t0.slug AS slug_5, t0.description AS description_6, t0.lft AS lft_7, t0.lvl AS lvl_8, t0.rgt AS rgt_9, t0.published AS published_10, t0.sort_index AS sort_index_11, t0.tree_root AS tree_root_12, t0.parent_id AS parent_id_13, t0.banner_id AS banner_id_14 FROM product_category t0 WHERE t0.parent_id = 14 ORDER BY t0.lft ASC;
94	0.15 ms	SELECT t0.id AS id_1, t0.path AS path_2, t0.name AS name_3, t0.mime_type AS mime_type_4, t0.size AS size_5, t0.uploaded_at AS uploaded_at_6, t0.discr FROM app_file t0 WHERE t0.id = ? AND t0.discr IN ('product_image') Parameters: [`43622`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.path AS path_2, t0.name AS name_3, t0.mime_type AS mime_type_4, t0.size AS size_5, t0.uploaded_at AS uploaded_at_6, t0.discr FROM app_file t0 WHERE t0.id = ? AND t0.discr IN ('product_image') SELECT t0.id AS id_1, t0.path AS path_2, t0.name AS name_3, t0.mime_type AS mime_type_4, t0.size AS size_5, t0.uploaded_at AS uploaded_at_6, t0.discr FROM app_file t0 WHERE t0.id = 43622 AND t0.discr IN ('product_image');
95	0.19 ms	SELECT t0.id AS id_1, t0.path AS path_2, t0.name AS name_3, t0.mime_type AS mime_type_4, t0.size AS size_5, t0.uploaded_at AS uploaded_at_6, t0.discr FROM app_file t0 INNER JOIN product_images ON t0.id = product_images.image_id WHERE product_images.product_id = ? AND t0.discr IN ('product_image') Parameters: [`8112`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.path AS path_2, t0.name AS name_3, t0.mime_type AS mime_type_4, t0.size AS size_5, t0.uploaded_at AS uploaded_at_6, t0.discr FROM app_file t0 INNER JOIN product_images ON t0.id = product_images.image_id WHERE product_images.product_id = ? AND t0.discr IN ('product_image') SELECT t0.id AS id_1, t0.path AS path_2, t0.name AS name_3, t0.mime_type AS mime_type_4, t0.size AS size_5, t0.uploaded_at AS uploaded_at_6, t0.discr FROM app_file t0 INNER JOIN product_images ON t0.id = product_images.image_id WHERE product_images.product_id = 8112 AND t0.discr IN ('product_image');
96	0.16 ms	SELECT t0.id AS id_1, t0.custom_id AS custom_id_2, t0.softone_id AS softone_id_3, t0.name AS name_4, t0.slug AS slug_5, t0.url AS url_6, t0.email AS email_7, t0.published AS published_8, t0.official_dealer AS official_dealer_9, t0.european_support AS european_support_10, t0.discount_percent AS discount_percent_11, t0.extra_discount AS extra_discount_12, t0.logo_id AS logo_id_13 FROM product_manufacturer t0 WHERE t0.id = ? Parameters: [`76`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.custom_id AS custom_id_2, t0.softone_id AS softone_id_3, t0.name AS name_4, t0.slug AS slug_5, t0.url AS url_6, t0.email AS email_7, t0.published AS published_8, t0.official_dealer AS official_dealer_9, t0.european_support AS european_support_10, t0.discount_percent AS discount_percent_11, t0.extra_discount AS extra_discount_12, t0.logo_id AS logo_id_13 FROM product_manufacturer t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.custom_id AS custom_id_2, t0.softone_id AS softone_id_3, t0.name AS name_4, t0.slug AS slug_5, t0.url AS url_6, t0.email AS email_7, t0.published AS published_8, t0.official_dealer AS official_dealer_9, t0.european_support AS european_support_10, t0.discount_percent AS discount_percent_11, t0.extra_discount AS extra_discount_12, t0.logo_id AS logo_id_13 FROM product_manufacturer t0 WHERE t0.id = 76;
97	0.16 ms	SELECT t0.id AS id_1, t0.migration_id AS migration_id_2, t0.softone_id AS softone_id_3, t0.name AS name_4 FROM product_type t0 WHERE t0.id = ? Parameters: [`10`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.migration_id AS migration_id_2, t0.softone_id AS softone_id_3, t0.name AS name_4 FROM product_type t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.migration_id AS migration_id_2, t0.softone_id AS softone_id_3, t0.name AS name_4 FROM product_type t0 WHERE t0.id = 10;

Database Connections

Name	Service
default	doctrine.dbal.default_connection
blk	doctrine.dbal.blk_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\Entity\Product\Category	71
App\Entity\Common\Files\AppFile	2
App\Entity\Product\Object\BaseProduct	1
App\Entity\Product\ProductType	1
App\Entity\Product\ProductManufacturer	1
App\Entity\Product\ProductReference	1
App\Entity\Cart\Cart	1

Entities Mapping

Class	Mapping errors
App\Entity\Product\Category	No errors.
App\Entity\Common\Files\AppFile	No errors.
App\Entity\Common\Files\CategoryBanner	No errors.
Gedmo\Translatable\Entity\MappedSuperclass\AbstractTranslation	No errors.
Gedmo\Translatable\Entity\Translation	No errors.
App\Entity\Product\Object\CommonProduct	No errors.
App\Entity\Product\WarehouseStock	No errors.
App\Entity\Common\Price	No errors.
App\Entity\Product\Object\BaseProduct	No errors.
App\Entity\Product\Object\Dimensions	No errors.
App\Entity\Product\Object\Product	No errors.
App\Entity\Product\ProductType	No errors.
App\Entity\Common\Files\ProductImage	No errors.
App\Entity\Product\ProductManufacturer	No errors.
App\Entity\Product\Object\ProductCategory	No errors.
App\Entity\Product\ProductExtraWebsite	No errors.
App\Entity\Product\ProductReference	No errors.
App\Entity\Product\Object\ProductAttributeValue	No errors.
App\Entity\Translation\ProductTranslation	No errors.
App\Entity\Cart\Cart	No errors.
App\Entity\User\User	No errors.
App\Entity\User\WebUser	No errors.
App\Entity\Cart\CartItem	No errors.
App\Entity\Product\Attribute\Attribute	No errors.
App\Entity\Product\Attribute\AttributeValue	No errors.
App\Entity\Common\Files\ManufacturerLogo	No errors.
App\Entity\Product\Object\BaseRental	No errors.

Symfony Profiler

GET https://quirky-mahavira.176-9-144-72.plesk.page/en/Streaming_Software/CB_61

Configuration Settings

Theme

Page Width

Query Metrics

Queries

default connection

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping