Query Metrics
269
Database Queries
33
Different statements
77.97 ms
Query time
0
Invalid entities
231
Managed entities
Queries
default connection
| #▲ | Time | Info |
|---|---|---|
| 1 | 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.slug = ? LIMIT 1
Parameters:
[
"bags_for_shoulder_cameras"
]
|
| 2 | 0.23 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:
[ "213" "el" "App\Entity\Product\Category" ] |
| 3 | 0.35 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.online_discount_percentage AS online_discount_percentage_24, t0.availability AS availability_25, t0.available_at AS available_at_26, t0.offer AS offer_27, t0.cash_back AS cash_back_28, t0.ask_for_price AS ask_for_price_29, t0.warehouse_stock_warehouse AS warehouse_stock_warehouse_30, t0.warehouse_stock_quantity AS warehouse_stock_quantity_31, t0.warehouse_stock_reserved AS warehouse_stock_reserved_32, t0.warehouse_stock_target_stock AS warehouse_stock_target_stock_33, t0.warehouse_stock_immutable AS warehouse_stock_immutable_34, t0.price_gross_amount AS price_gross_amount_35, t0.price_gross_currency AS price_gross_currency_36, t0.price_with_discount_amount AS price_with_discount_amount_37, t0.price_with_discount_currency AS price_with_discount_currency_38, t0.type_id AS type_id_39, t0.main_image_id AS main_image_id_40, t0.manufacturer_id AS manufacturer_id_41, t0.variant_group_id AS variant_group_id_42, t0.discr, t0.price_url AS price_url_43, t0.price_comments AS price_comments_44, t0.supplier_discount AS supplier_discount_45, t0.special_discount AS special_discount_46, t0.customs_charges_percentage AS customs_charges_percentage_47, t0.markup_percentage AS markup_percentage_48, t0.product_dimensions AS product_dimensions_49, t0.net_weight AS net_weight_50, t0.warranty AS warranty_51, t0.accessories AS accessories_52, t0.original_price_amount AS original_price_amount_53, t0.original_price_currency AS original_price_currency_54, t0.supplier_shipping_value_amount AS supplier_shipping_value_amount_55, t0.supplier_shipping_value_currency AS supplier_shipping_value_currency_56, t0.package_length_mm AS package_length_mm_57, t0.package_width_mm AS package_width_mm_58, t0.package_height_mm AS package_height_mm_59, t0.package_details AS package_details_60, t0.package_dimension_unit AS package_dimension_unit_61, t0.package_grams AS package_grams_62, t0.package_weight_details AS package_weight_details_63, t0.package_weight_unit AS package_weight_unit_64, t0.kit_discount_percentage AS kit_discount_percentage_65 FROM products t0 WHERE t0.slug = ? AND t0.discr IN ('product', 'product_kit') LIMIT 1
Parameters:
[
"1637 Air Empty"
]
|
| 4 | 7.79 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:
[ "7314" "el" "App\Entity\Product\Object\BaseProduct" ] |
| 5 | 0.17 ms |
"START TRANSACTION"
Parameters:
[] |
| 6 | 0.27 ms |
UPDATE products SET views = ? WHERE id = ?
Parameters:
[ 5 7314 ] |
| 7 | 2.94 ms |
"COMMIT"
Parameters:
[] |
| 8 | 0.28 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.type AS type_3, t0.url AS url_4, t0.file_id AS file_id_5 FROM product_reference t0 INNER JOIN products_references ON t0.id = products_references.reference_id WHERE products_references.product_id = ?
Parameters:
[
7314
]
|
| 9 | 2.33 ms |
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.slug AS slug_2, p0_.summary AS summary_3, p0_.status AS status_4, p0_.price_gross_amount AS price_gross_amount_5, p0_.price_gross_currency AS price_gross_currency_6, p0_.price_with_discount_amount AS price_with_discount_amount_7, p0_.price_with_discount_currency AS price_with_discount_currency_8, p0_.warehouse_stock_quantity AS warehouse_stock_quantity_9, p0_.availability AS availability_10, p0_.mfr_code AS mfr_code_11, p0_.blk_code AS blk_code_12, p0_.offer AS offer_13, p0_.cash_back AS cash_back_14, p1_.id AS id_15, p1_.name AS name_16, a2_.name AS name_17, a2_.path AS path_18, p3_.id AS id_19, p3_.name AS name_20, p3_.slug AS slug_21, a4_.name AS name_22, a4_.path AS path_23, p5_.slug AS slug_24, GROUP_CONCAT(DISTINCT p6_.website) AS sclr_25, GROUP_CONCAT(DISTINCT CONCAT(p7_.lvl, ':', p7_.name) ORDER BY p7_.lft ASC SEPARATOR '||') AS sclr_26 FROM products p0_ INNER JOIN product_manufacturer p3_ ON (p0_.manufacturer_id = p3_.id) INNER JOIN app_file a4_ ON (p3_.logo_id = a4_.id) AND a4_.discr IN ('manufacturer_logo') INNER JOIN products_categories p8_ ON (p0_.id = p8_.product_id AND p8_.main = 1) INNER JOIN product_category p5_ ON (p8_.category_id = p5_.id) INNER JOIN products_categories p9_ ON (p0_.id = p9_.product_id) INNER JOIN product_category p7_ ON (p9_.category_id = p7_.id) INNER JOIN product_type p1_ ON (p0_.type_id = p1_.id) LEFT JOIN app_file a2_ ON (p0_.main_image_id = a2_.id) AND a2_.discr IN ('article_image', 'product_image', 'product_category_banner', 'manufacturer_logo', 'product_reference_pdf', 'product_reference_image', 'slider_image') LEFT JOIN product_extra_website p6_ ON p0_.id = p6_.product_id WHERE (p0_.id IN (?, ?, ?) AND p0_.published = ? AND p0_.status NOT IN (?, ?)) AND p0_.discr IN ('product', 'product_kit') GROUP BY p0_.id ORDER BY p0_.name ASC
Parameters:
[ 7250 7389 7951 1 "view" "no_view" ] |
| 10 | 0.25 ms |
SELECT t0.id AS id_1, t0.text_value AS text_value_2, t0.extra_info AS extra_info_3, t0.quantity AS quantity_4, t0.product_id AS product_id_5, t0.attribute_id AS attribute_id_6, t0.attribute_value_id AS attribute_value_id_7 FROM product_attribute_value t0 WHERE t0.product_id = ?
Parameters:
[
7314
]
|
| 11 | 0.26 ms |
SELECT t0.id AS id_1, t0.custom_id AS custom_id_2, t0.name AS name_3, t0.comments AS comments_4, t0.has_quantity AS has_quantity_5, t0.sort_index AS sort_index_6, t0.filter AS filter_7, t0.filter_type AS filter_type_8, t0.published AS published_9, t0.attribute_type AS attribute_type_10, t0.attribute_group_id AS attribute_group_id_11 FROM attribute t0 WHERE t0.id = ?
Parameters:
[
93
]
|
| 12 | 0.25 ms |
SELECT a0_.content AS content_0, a0_.field AS field_1 FROM attribute_translations a0_ WHERE a0_.foreign_key = ? AND a0_.locale = ? AND a0_.object_class = ?
Parameters:
[ "93" "el" "App\Entity\Product\Attribute\Attribute" ] |
| 13 | 0.12 ms |
SELECT t0.id AS id_1, t0.migration_id AS migration_id_2, t0.name AS name_3, t0.sort_index AS sort_index_4, t0.published AS published_5 FROM attribute_group t0 WHERE t0.id = ?
Parameters:
[
8
]
|
| 14 | 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:
[ "8" "el" "App\Entity\Product\Attribute\AttributeGroup" ] |
| 15 | 0.11 ms |
SELECT t0.id AS id_1, t0.custom_id AS custom_id_2, t0.name AS name_3, t0.comments AS comments_4, t0.has_quantity AS has_quantity_5, t0.sort_index AS sort_index_6, t0.filter AS filter_7, t0.filter_type AS filter_type_8, t0.published AS published_9, t0.attribute_type AS attribute_type_10, t0.attribute_group_id AS attribute_group_id_11 FROM attribute t0 WHERE t0.id = ?
Parameters:
[
28
]
|
| 16 | 0.26 ms |
SELECT a0_.content AS content_0, a0_.field AS field_1 FROM attribute_translations a0_ WHERE a0_.foreign_key = ? AND a0_.locale = ? AND a0_.object_class = ?
Parameters:
[ "28" "el" "App\Entity\Product\Attribute\Attribute" ] |
| 17 | 0.11 ms |
SELECT t0.id AS id_1, t0.migration_id AS migration_id_2, t0.name AS name_3, t0.sort_index AS sort_index_4, t0.published AS published_5 FROM attribute_group t0 WHERE t0.id = ?
Parameters:
[
5
]
|
| 18 | 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:
[ "5" "el" "App\Entity\Product\Attribute\AttributeGroup" ] |
| 19 | 0.10 ms |
SELECT t0.id AS id_1, t0.value AS value_2, t0.sort_index AS sort_index_3, t0.extra_info AS extra_info_4, t0.attribute_id AS attribute_id_5 FROM attribute_value t0 WHERE t0.id = ?
Parameters:
[
815
]
|
| 20 | 0.16 ms |
SELECT a0_.content AS content_0, a0_.field AS field_1 FROM attribute_value_translations a0_ WHERE a0_.foreign_key = ? AND a0_.locale = ? AND a0_.object_class = ?
Parameters:
[ "815" "el" "App\Entity\Product\Attribute\AttributeValue" ] |
| 21 | 0.10 ms |
SELECT t0.id AS id_1, t0.custom_id AS custom_id_2, t0.name AS name_3, t0.comments AS comments_4, t0.has_quantity AS has_quantity_5, t0.sort_index AS sort_index_6, t0.filter AS filter_7, t0.filter_type AS filter_type_8, t0.published AS published_9, t0.attribute_type AS attribute_type_10, t0.attribute_group_id AS attribute_group_id_11 FROM attribute t0 WHERE t0.id = ?
Parameters:
[
89
]
|
| 22 | 0.11 ms |
SELECT a0_.content AS content_0, a0_.field AS field_1 FROM attribute_translations a0_ WHERE a0_.foreign_key = ? AND a0_.locale = ? AND a0_.object_class = ?
Parameters:
[ "89" "el" "App\Entity\Product\Attribute\Attribute" ] |
| 23 | 0.09 ms |
SELECT t0.id AS id_1, t0.migration_id AS migration_id_2, t0.name AS name_3, t0.sort_index AS sort_index_4, t0.published AS published_5 FROM attribute_group t0 WHERE t0.id = ?
Parameters:
[
6
]
|
| 24 | 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:
[ "6" "el" "App\Entity\Product\Attribute\AttributeGroup" ] |
| 25 | 0.09 ms |
SELECT t0.id AS id_1, t0.value AS value_2, t0.sort_index AS sort_index_3, t0.extra_info AS extra_info_4, t0.attribute_id AS attribute_id_5 FROM attribute_value t0 WHERE t0.id = ?
Parameters:
[
2089
]
|
| 26 | 0.12 ms |
SELECT a0_.content AS content_0, a0_.field AS field_1 FROM attribute_value_translations a0_ WHERE a0_.foreign_key = ? AND a0_.locale = ? AND a0_.object_class = ?
Parameters:
[ "2089" "el" "App\Entity\Product\Attribute\AttributeValue" ] |
| 27 | 0.09 ms |
SELECT t0.id AS id_1, t0.value AS value_2, t0.sort_index AS sort_index_3, t0.extra_info AS extra_info_4, t0.attribute_id AS attribute_id_5 FROM attribute_value t0 WHERE t0.id = ?
Parameters:
[
2090
]
|
| 28 | 0.10 ms |
SELECT a0_.content AS content_0, a0_.field AS field_1 FROM attribute_value_translations a0_ WHERE a0_.foreign_key = ? AND a0_.locale = ? AND a0_.object_class = ?
Parameters:
[ "2090" "el" "App\Entity\Product\Attribute\AttributeValue" ] |
| 29 | 0.09 ms |
SELECT t0.id AS id_1, t0.value AS value_2, t0.sort_index AS sort_index_3, t0.extra_info AS extra_info_4, t0.attribute_id AS attribute_id_5 FROM attribute_value t0 WHERE t0.id = ?
Parameters:
[
2094
]
|
| 30 | 0.10 ms |
SELECT a0_.content AS content_0, a0_.field AS field_1 FROM attribute_value_translations a0_ WHERE a0_.foreign_key = ? AND a0_.locale = ? AND a0_.object_class = ?
Parameters:
[ "2094" "el" "App\Entity\Product\Attribute\AttributeValue" ] |
| 31 | 0.11 ms |
SELECT t0.id AS id_1, t0.custom_id AS custom_id_2, t0.name AS name_3, t0.comments AS comments_4, t0.has_quantity AS has_quantity_5, t0.sort_index AS sort_index_6, t0.filter AS filter_7, t0.filter_type AS filter_type_8, t0.published AS published_9, t0.attribute_type AS attribute_type_10, t0.attribute_group_id AS attribute_group_id_11 FROM attribute t0 WHERE t0.id = ?
Parameters:
[
90
]
|
| 32 | 0.14 ms |
SELECT a0_.content AS content_0, a0_.field AS field_1 FROM attribute_translations a0_ WHERE a0_.foreign_key = ? AND a0_.locale = ? AND a0_.object_class = ?
Parameters:
[ "90" "el" "App\Entity\Product\Attribute\Attribute" ] |
| 33 | 0.09 ms |
SELECT t0.id AS id_1, t0.value AS value_2, t0.sort_index AS sort_index_3, t0.extra_info AS extra_info_4, t0.attribute_id AS attribute_id_5 FROM attribute_value t0 WHERE t0.id = ?
Parameters:
[
2096
]
|
| 34 | 0.10 ms |
SELECT a0_.content AS content_0, a0_.field AS field_1 FROM attribute_value_translations a0_ WHERE a0_.foreign_key = ? AND a0_.locale = ? AND a0_.object_class = ?
Parameters:
[ "2096" "el" "App\Entity\Product\Attribute\AttributeValue" ] |
| 35 | 0.10 ms |
SELECT t0.id AS id_1, t0.custom_id AS custom_id_2, t0.name AS name_3, t0.comments AS comments_4, t0.has_quantity AS has_quantity_5, t0.sort_index AS sort_index_6, t0.filter AS filter_7, t0.filter_type AS filter_type_8, t0.published AS published_9, t0.attribute_type AS attribute_type_10, t0.attribute_group_id AS attribute_group_id_11 FROM attribute t0 WHERE t0.id = ?
Parameters:
[
91
]
|
| 36 | 0.11 ms |
SELECT a0_.content AS content_0, a0_.field AS field_1 FROM attribute_translations a0_ WHERE a0_.foreign_key = ? AND a0_.locale = ? AND a0_.object_class = ?
Parameters:
[ "91" "el" "App\Entity\Product\Attribute\Attribute" ] |
| 37 | 0.09 ms |
SELECT t0.id AS id_1, t0.value AS value_2, t0.sort_index AS sort_index_3, t0.extra_info AS extra_info_4, t0.attribute_id AS attribute_id_5 FROM attribute_value t0 WHERE t0.id = ?
Parameters:
[
2098
]
|
| 38 | 0.10 ms |
SELECT a0_.content AS content_0, a0_.field AS field_1 FROM attribute_value_translations a0_ WHERE a0_.foreign_key = ? AND a0_.locale = ? AND a0_.object_class = ?
Parameters:
[ "2098" "el" "App\Entity\Product\Attribute\AttributeValue" ] |
| 39 | 0.09 ms |
SELECT t0.id AS id_1, t0.custom_id AS custom_id_2, t0.name AS name_3, t0.comments AS comments_4, t0.has_quantity AS has_quantity_5, t0.sort_index AS sort_index_6, t0.filter AS filter_7, t0.filter_type AS filter_type_8, t0.published AS published_9, t0.attribute_type AS attribute_type_10, t0.attribute_group_id AS attribute_group_id_11 FROM attribute t0 WHERE t0.id = ?
Parameters:
[
88
]
|
| 40 | 0.11 ms |
SELECT a0_.content AS content_0, a0_.field AS field_1 FROM attribute_translations a0_ WHERE a0_.foreign_key = ? AND a0_.locale = ? AND a0_.object_class = ?
Parameters:
[ "88" "el" "App\Entity\Product\Attribute\Attribute" ] |
| 41 | 0.09 ms |
SELECT t0.id AS id_1, t0.value AS value_2, t0.sort_index AS sort_index_3, t0.extra_info AS extra_info_4, t0.attribute_id AS attribute_id_5 FROM attribute_value t0 WHERE t0.id = ?
Parameters:
[
2087
]
|
| 42 | 0.10 ms |
SELECT a0_.content AS content_0, a0_.field AS field_1 FROM attribute_value_translations a0_ WHERE a0_.foreign_key = ? AND a0_.locale = ? AND a0_.object_class = ?
Parameters:
[ "2087" "el" "App\Entity\Product\Attribute\AttributeValue" ] |
| 43 | 0.09 ms |
SELECT t0.id AS id_1, t0.custom_id AS custom_id_2, t0.name AS name_3, t0.comments AS comments_4, t0.has_quantity AS has_quantity_5, t0.sort_index AS sort_index_6, t0.filter AS filter_7, t0.filter_type AS filter_type_8, t0.published AS published_9, t0.attribute_type AS attribute_type_10, t0.attribute_group_id AS attribute_group_id_11 FROM attribute t0 WHERE t0.id = ?
Parameters:
[
87
]
|
| 44 | 0.11 ms |
SELECT a0_.content AS content_0, a0_.field AS field_1 FROM attribute_translations a0_ WHERE a0_.foreign_key = ? AND a0_.locale = ? AND a0_.object_class = ?
Parameters:
[ "87" "el" "App\Entity\Product\Attribute\Attribute" ] |
| 45 | 0.09 ms |
SELECT t0.id AS id_1, t0.value AS value_2, t0.sort_index AS sort_index_3, t0.extra_info AS extra_info_4, t0.attribute_id AS attribute_id_5 FROM attribute_value t0 WHERE t0.id = ?
Parameters:
[
2085
]
|
| 46 | 0.11 ms |
SELECT a0_.content AS content_0, a0_.field AS field_1 FROM attribute_value_translations a0_ WHERE a0_.foreign_key = ? AND a0_.locale = ? AND a0_.object_class = ?
Parameters:
[ "2085" "el" "App\Entity\Product\Attribute\AttributeValue" ] |
| 47 | 0.09 ms |
SELECT t0.id AS id_1, t0.custom_id AS custom_id_2, t0.name AS name_3, t0.comments AS comments_4, t0.has_quantity AS has_quantity_5, t0.sort_index AS sort_index_6, t0.filter AS filter_7, t0.filter_type AS filter_type_8, t0.published AS published_9, t0.attribute_type AS attribute_type_10, t0.attribute_group_id AS attribute_group_id_11 FROM attribute t0 WHERE t0.id = ?
Parameters:
[
94
]
|
| 48 | 0.13 ms |
SELECT a0_.content AS content_0, a0_.field AS field_1 FROM attribute_translations a0_ WHERE a0_.foreign_key = ? AND a0_.locale = ? AND a0_.object_class = ?
Parameters:
[ "94" "el" "App\Entity\Product\Attribute\Attribute" ] |
| 49 | 0.19 ms |
SELECT t0.id AS id_1, t0.value AS value_2, t0.sort_index AS sort_index_3, t0.extra_info AS extra_info_4, t0.attribute_id AS attribute_id_5 FROM attribute_value t0 WHERE t0.id = ?
Parameters:
[
2182
]
|
| 50 | 0.16 ms |
SELECT a0_.content AS content_0, a0_.field AS field_1 FROM attribute_value_translations a0_ WHERE a0_.foreign_key = ? AND a0_.locale = ? AND a0_.object_class = ?
Parameters:
[ "2182" "el" "App\Entity\Product\Attribute\AttributeValue" ] |
| 51 | 0.12 ms |
SELECT t0.id AS id_1, t0.custom_id AS custom_id_2, t0.name AS name_3, t0.comments AS comments_4, t0.has_quantity AS has_quantity_5, t0.sort_index AS sort_index_6, t0.filter AS filter_7, t0.filter_type AS filter_type_8, t0.published AS published_9, t0.attribute_type AS attribute_type_10, t0.attribute_group_id AS attribute_group_id_11 FROM attribute t0 WHERE t0.id = ?
Parameters:
[
92
]
|
| 52 | 0.14 ms |
SELECT a0_.content AS content_0, a0_.field AS field_1 FROM attribute_translations a0_ WHERE a0_.foreign_key = ? AND a0_.locale = ? AND a0_.object_class = ?
Parameters:
[ "92" "el" "App\Entity\Product\Attribute\Attribute" ] |
| 53 | 0.10 ms |
SELECT t0.id AS id_1, t0.value AS value_2, t0.sort_index AS sort_index_3, t0.extra_info AS extra_info_4, t0.attribute_id AS attribute_id_5 FROM attribute_value t0 WHERE t0.id = ?
Parameters:
[
2120
]
|
| 54 | 0.11 ms |
SELECT a0_.content AS content_0, a0_.field AS field_1 FROM attribute_value_translations a0_ WHERE a0_.foreign_key = ? AND a0_.locale = ? AND a0_.object_class = ?
Parameters:
[ "2120" "el" "App\Entity\Product\Attribute\AttributeValue" ] |
| 55 | 0.10 ms |
SELECT t0.id AS id_1, t0.custom_id AS custom_id_2, t0.name AS name_3, t0.comments AS comments_4, t0.has_quantity AS has_quantity_5, t0.sort_index AS sort_index_6, t0.filter AS filter_7, t0.filter_type AS filter_type_8, t0.published AS published_9, t0.attribute_type AS attribute_type_10, t0.attribute_group_id AS attribute_group_id_11 FROM attribute t0 WHERE t0.id = ?
Parameters:
[
86
]
|
| 56 | 0.15 ms |
SELECT a0_.content AS content_0, a0_.field AS field_1 FROM attribute_translations a0_ WHERE a0_.foreign_key = ? AND a0_.locale = ? AND a0_.object_class = ?
Parameters:
[ "86" "el" "App\Entity\Product\Attribute\Attribute" ] |
| 57 | 0.09 ms |
SELECT t0.id AS id_1, t0.value AS value_2, t0.sort_index AS sort_index_3, t0.extra_info AS extra_info_4, t0.attribute_id AS attribute_id_5 FROM attribute_value t0 WHERE t0.id = ?
Parameters:
[
2071
]
|
| 58 | 0.11 ms |
SELECT a0_.content AS content_0, a0_.field AS field_1 FROM attribute_value_translations a0_ WHERE a0_.foreign_key = ? AND a0_.locale = ? AND a0_.object_class = ?
Parameters:
[ "2071" "el" "App\Entity\Product\Attribute\AttributeValue" ] |
| 59 | 0.09 ms |
SELECT t0.id AS id_1, t0.value AS value_2, t0.sort_index AS sort_index_3, t0.extra_info AS extra_info_4, t0.attribute_id AS attribute_id_5 FROM attribute_value t0 WHERE t0.id = ?
Parameters:
[
2118
]
|
| 60 | 0.10 ms |
SELECT a0_.content AS content_0, a0_.field AS field_1 FROM attribute_value_translations a0_ WHERE a0_.foreign_key = ? AND a0_.locale = ? AND a0_.object_class = ?
Parameters:
[ "2118" "el" "App\Entity\Product\Attribute\AttributeValue" ] |
| 61 | 0.09 ms |
SELECT t0.id AS id_1, t0.value AS value_2, t0.sort_index AS sort_index_3, t0.extra_info AS extra_info_4, t0.attribute_id AS attribute_id_5 FROM attribute_value t0 WHERE t0.id = ?
Parameters:
[
2121
]
|
| 62 | 0.11 ms |
SELECT a0_.content AS content_0, a0_.field AS field_1 FROM attribute_value_translations a0_ WHERE a0_.foreign_key = ? AND a0_.locale = ? AND a0_.object_class = ?
Parameters:
[ "2121" "el" "App\Entity\Product\Attribute\AttributeValue" ] |
| 63 | 0.09 ms |
SELECT t0.id AS id_1, t0.value AS value_2, t0.sort_index AS sort_index_3, t0.extra_info AS extra_info_4, t0.attribute_id AS attribute_id_5 FROM attribute_value t0 WHERE t0.id = ?
Parameters:
[
2122
]
|
| 64 | 0.10 ms |
SELECT a0_.content AS content_0, a0_.field AS field_1 FROM attribute_value_translations a0_ WHERE a0_.foreign_key = ? AND a0_.locale = ? AND a0_.object_class = ?
Parameters:
[ "2122" "el" "App\Entity\Product\Attribute\AttributeValue" ] |
| 65 | 0.09 ms |
SELECT t0.id AS id_1, t0.value AS value_2, t0.sort_index AS sort_index_3, t0.extra_info AS extra_info_4, t0.attribute_id AS attribute_id_5 FROM attribute_value t0 WHERE t0.id = ?
Parameters:
[
2135
]
|
| 66 | 0.10 ms |
SELECT a0_.content AS content_0, a0_.field AS field_1 FROM attribute_value_translations a0_ WHERE a0_.foreign_key = ? AND a0_.locale = ? AND a0_.object_class = ?
Parameters:
[ "2135" "el" "App\Entity\Product\Attribute\AttributeValue" ] |
| 67 | 0.09 ms |
SELECT t0.id AS id_1, t0.value AS value_2, t0.sort_index AS sort_index_3, t0.extra_info AS extra_info_4, t0.attribute_id AS attribute_id_5 FROM attribute_value t0 WHERE t0.id = ?
Parameters:
[
2137
]
|
| 68 | 0.11 ms |
SELECT a0_.content AS content_0, a0_.field AS field_1 FROM attribute_value_translations a0_ WHERE a0_.foreign_key = ? AND a0_.locale = ? AND a0_.object_class = ?
Parameters:
[ "2137" "el" "App\Entity\Product\Attribute\AttributeValue" ] |
| 69 | 0.10 ms |
SELECT t0.id AS id_1, t0.custom_id AS custom_id_2, t0.name AS name_3, t0.comments AS comments_4, t0.has_quantity AS has_quantity_5, t0.sort_index AS sort_index_6, t0.filter AS filter_7, t0.filter_type AS filter_type_8, t0.published AS published_9, t0.attribute_type AS attribute_type_10, t0.attribute_group_id AS attribute_group_id_11 FROM attribute t0 WHERE t0.id = ?
Parameters:
[
85
]
|
| 70 | 0.14 ms |
SELECT a0_.content AS content_0, a0_.field AS field_1 FROM attribute_translations a0_ WHERE a0_.foreign_key = ? AND a0_.locale = ? AND a0_.object_class = ?
Parameters:
[ "85" "el" "App\Entity\Product\Attribute\Attribute" ] |
| 71 | 0.09 ms |
SELECT t0.id AS id_1, t0.value AS value_2, t0.sort_index AS sort_index_3, t0.extra_info AS extra_info_4, t0.attribute_id AS attribute_id_5 FROM attribute_value t0 WHERE t0.id = ?
Parameters:
[
1963
]
|
| 72 | 0.11 ms |
SELECT a0_.content AS content_0, a0_.field AS field_1 FROM attribute_value_translations a0_ WHERE a0_.foreign_key = ? AND a0_.locale = ? AND a0_.object_class = ?
Parameters:
[ "1963" "el" "App\Entity\Product\Attribute\AttributeValue" ] |
| 73 | 0.09 ms |
SELECT t0.id AS id_1, t0.value AS value_2, t0.sort_index AS sort_index_3, t0.extra_info AS extra_info_4, t0.attribute_id AS attribute_id_5 FROM attribute_value t0 WHERE t0.id = ?
Parameters:
[
1965
]
|
| 74 | 0.11 ms |
SELECT a0_.content AS content_0, a0_.field AS field_1 FROM attribute_value_translations a0_ WHERE a0_.foreign_key = ? AND a0_.locale = ? AND a0_.object_class = ?
Parameters:
[ "1965" "el" "App\Entity\Product\Attribute\AttributeValue" ] |
| 75 | 0.09 ms |
SELECT t0.id AS id_1, t0.value AS value_2, t0.sort_index AS sort_index_3, t0.extra_info AS extra_info_4, t0.attribute_id AS attribute_id_5 FROM attribute_value t0 WHERE t0.id = ?
Parameters:
[
1975
]
|
| 76 | 0.11 ms |
SELECT a0_.content AS content_0, a0_.field AS field_1 FROM attribute_value_translations a0_ WHERE a0_.foreign_key = ? AND a0_.locale = ? AND a0_.object_class = ?
Parameters:
[ "1975" "el" "App\Entity\Product\Attribute\AttributeValue" ] |
| 77 | 0.10 ms |
SELECT t0.id AS id_1, t0.custom_id AS custom_id_2, t0.name AS name_3, t0.comments AS comments_4, t0.has_quantity AS has_quantity_5, t0.sort_index AS sort_index_6, t0.filter AS filter_7, t0.filter_type AS filter_type_8, t0.published AS published_9, t0.attribute_type AS attribute_type_10, t0.attribute_group_id AS attribute_group_id_11 FROM attribute t0 WHERE t0.id = ?
Parameters:
[
84
]
|
| 78 | 0.14 ms |
SELECT a0_.content AS content_0, a0_.field AS field_1 FROM attribute_translations a0_ WHERE a0_.foreign_key = ? AND a0_.locale = ? AND a0_.object_class = ?
Parameters:
[ "84" "el" "App\Entity\Product\Attribute\Attribute" ] |
| 79 | 0.09 ms |
SELECT t0.id AS id_1, t0.migration_id AS migration_id_2, t0.name AS name_3, t0.sort_index AS sort_index_4, t0.published AS published_5 FROM attribute_group t0 WHERE t0.id = ?
Parameters:
[
7
]
|
| 80 | 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:
[ "7" "el" "App\Entity\Product\Attribute\AttributeGroup" ] |
| 81 | 0.09 ms |
SELECT t0.id AS id_1, t0.value AS value_2, t0.sort_index AS sort_index_3, t0.extra_info AS extra_info_4, t0.attribute_id AS attribute_id_5 FROM attribute_value t0 WHERE t0.id = ?
Parameters:
[
1815
]
|
| 82 | 0.11 ms |
SELECT a0_.content AS content_0, a0_.field AS field_1 FROM attribute_value_translations a0_ WHERE a0_.foreign_key = ? AND a0_.locale = ? AND a0_.object_class = ?
Parameters:
[ "1815" "el" "App\Entity\Product\Attribute\AttributeValue" ] |
| 83 | 13.78 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_69d79bace5d7b4.82302217"
]
|
| 84 | 0.33 ms |
SELECT t0.id AS id_1, t0.migration_id AS migration_id_2, t0.name AS name_3, t0.type AS type_4, t0.website AS website_5, t0.page_name AS page_name_6, t0.slug AS slug_7, t0.url AS url_8, t0.internal_url_data AS internal_url_data_9, t0.description AS description_10, t0.lft AS lft_11, t0.lvl AS lvl_12, t0.rgt AS rgt_13, t0.published AS published_14, t0.sort_index AS sort_index_15, t0.tree_root AS tree_root_16, t0.parent_id AS parent_id_17 FROM menu t0 WHERE t0.lvl = ? AND t0.website = ? ORDER BY t0.id ASC LIMIT 1
Parameters:
[ 0 "blk.gr" ] |
| 85 | 0.31 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" "el" "App\Entity\Menu" ] |
| 86 | 0.26 ms |
SELECT t0.id AS id_1, t0.migration_id AS migration_id_2, t0.name AS name_3, t0.type AS type_4, t0.website AS website_5, t0.page_name AS page_name_6, t0.slug AS slug_7, t0.url AS url_8, t0.internal_url_data AS internal_url_data_9, t0.description AS description_10, t0.lft AS lft_11, t0.lvl AS lvl_12, t0.rgt AS rgt_13, t0.published AS published_14, t0.sort_index AS sort_index_15, t0.tree_root AS tree_root_16, t0.parent_id AS parent_id_17 FROM menu t0 WHERE t0.parent_id = ? ORDER BY t0.lft ASC
Parameters:
[
1
]
|
| 87 | 0.32 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:
[ "2" "el" "App\Entity\Menu" ] |
| 88 | 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:
[ "12" "el" "App\Entity\Menu" ] |
| 89 | 0.23 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" "el" "App\Entity\Menu" ] |
| 90 | 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:
[ "13" "el" "App\Entity\Menu" ] |
| 91 | 0.18 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" "el" "App\Entity\Menu" ] |
| 92 | 0.18 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" "el" "App\Entity\Menu" ] |
| 93 | 0.18 ms |
SELECT t0.id AS id_1, t0.migration_id AS migration_id_2, t0.name AS name_3, t0.type AS type_4, t0.website AS website_5, t0.page_name AS page_name_6, t0.slug AS slug_7, t0.url AS url_8, t0.internal_url_data AS internal_url_data_9, t0.description AS description_10, t0.lft AS lft_11, t0.lvl AS lvl_12, t0.rgt AS rgt_13, t0.published AS published_14, t0.sort_index AS sort_index_15, t0.tree_root AS tree_root_16, t0.parent_id AS parent_id_17 FROM menu t0 WHERE t0.parent_id = ? ORDER BY t0.lft ASC
Parameters:
[
2
]
|
| 94 | 0.18 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:
[ "3" "el" "App\Entity\Menu" ] |
| 95 | 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:
[ "4" "el" "App\Entity\Menu" ] |
| 96 | 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:
[ "9" "el" "App\Entity\Menu" ] |
| 97 | 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:
[ "10" "el" "App\Entity\Menu" ] |
| 98 | 0.16 ms |
SELECT t0.id AS id_1, t0.migration_id AS migration_id_2, t0.name AS name_3, t0.type AS type_4, t0.website AS website_5, t0.page_name AS page_name_6, t0.slug AS slug_7, t0.url AS url_8, t0.internal_url_data AS internal_url_data_9, t0.description AS description_10, t0.lft AS lft_11, t0.lvl AS lvl_12, t0.rgt AS rgt_13, t0.published AS published_14, t0.sort_index AS sort_index_15, t0.tree_root AS tree_root_16, t0.parent_id AS parent_id_17 FROM menu t0 WHERE t0.parent_id = ? ORDER BY t0.lft ASC
Parameters:
[
3
]
|
| 99 | 0.20 ms |
SELECT t0.id AS id_1, t0.migration_id AS migration_id_2, t0.name AS name_3, t0.type AS type_4, t0.website AS website_5, t0.page_name AS page_name_6, t0.slug AS slug_7, t0.url AS url_8, t0.internal_url_data AS internal_url_data_9, t0.description AS description_10, t0.lft AS lft_11, t0.lvl AS lvl_12, t0.rgt AS rgt_13, t0.published AS published_14, t0.sort_index AS sort_index_15, t0.tree_root AS tree_root_16, t0.parent_id AS parent_id_17 FROM menu t0 WHERE t0.parent_id = ? ORDER BY t0.lft ASC
Parameters:
[
4
]
|
| 100 | 0.17 ms |
SELECT t0.id AS id_1, t0.migration_id AS migration_id_2, t0.name AS name_3, t0.type AS type_4, t0.website AS website_5, t0.page_name AS page_name_6, t0.slug AS slug_7, t0.url AS url_8, t0.internal_url_data AS internal_url_data_9, t0.description AS description_10, t0.lft AS lft_11, t0.lvl AS lvl_12, t0.rgt AS rgt_13, t0.published AS published_14, t0.sort_index AS sort_index_15, t0.tree_root AS tree_root_16, t0.parent_id AS parent_id_17 FROM menu t0 WHERE t0.parent_id = ? ORDER BY t0.lft ASC
Parameters:
[
9
]
|
| 101 | 0.14 ms |
SELECT t0.id AS id_1, t0.migration_id AS migration_id_2, t0.name AS name_3, t0.type AS type_4, t0.website AS website_5, t0.page_name AS page_name_6, t0.slug AS slug_7, t0.url AS url_8, t0.internal_url_data AS internal_url_data_9, t0.description AS description_10, t0.lft AS lft_11, t0.lvl AS lvl_12, t0.rgt AS rgt_13, t0.published AS published_14, t0.sort_index AS sort_index_15, t0.tree_root AS tree_root_16, t0.parent_id AS parent_id_17 FROM menu t0 WHERE t0.parent_id = ? ORDER BY t0.lft ASC
Parameters:
[
10
]
|
| 102 | 0.14 ms |
SELECT t0.id AS id_1, t0.migration_id AS migration_id_2, t0.name AS name_3, t0.type AS type_4, t0.website AS website_5, t0.page_name AS page_name_6, t0.slug AS slug_7, t0.url AS url_8, t0.internal_url_data AS internal_url_data_9, t0.description AS description_10, t0.lft AS lft_11, t0.lvl AS lvl_12, t0.rgt AS rgt_13, t0.published AS published_14, t0.sort_index AS sort_index_15, t0.tree_root AS tree_root_16, t0.parent_id AS parent_id_17 FROM menu t0 WHERE t0.parent_id = ? ORDER BY t0.lft ASC
Parameters:
[
12
]
|
| 103 | 0.14 ms |
SELECT t0.id AS id_1, t0.migration_id AS migration_id_2, t0.name AS name_3, t0.type AS type_4, t0.website AS website_5, t0.page_name AS page_name_6, t0.slug AS slug_7, t0.url AS url_8, t0.internal_url_data AS internal_url_data_9, t0.description AS description_10, t0.lft AS lft_11, t0.lvl AS lvl_12, t0.rgt AS rgt_13, t0.published AS published_14, t0.sort_index AS sort_index_15, t0.tree_root AS tree_root_16, t0.parent_id AS parent_id_17 FROM menu t0 WHERE t0.parent_id = ? ORDER BY t0.lft ASC
Parameters:
[
6
]
|
| 104 | 0.14 ms |
SELECT t0.id AS id_1, t0.migration_id AS migration_id_2, t0.name AS name_3, t0.type AS type_4, t0.website AS website_5, t0.page_name AS page_name_6, t0.slug AS slug_7, t0.url AS url_8, t0.internal_url_data AS internal_url_data_9, t0.description AS description_10, t0.lft AS lft_11, t0.lvl AS lvl_12, t0.rgt AS rgt_13, t0.published AS published_14, t0.sort_index AS sort_index_15, t0.tree_root AS tree_root_16, t0.parent_id AS parent_id_17 FROM menu t0 WHERE t0.parent_id = ? ORDER BY t0.lft ASC
Parameters:
[
13
]
|
| 105 | 0.14 ms |
SELECT t0.id AS id_1, t0.migration_id AS migration_id_2, t0.name AS name_3, t0.type AS type_4, t0.website AS website_5, t0.page_name AS page_name_6, t0.slug AS slug_7, t0.url AS url_8, t0.internal_url_data AS internal_url_data_9, t0.description AS description_10, t0.lft AS lft_11, t0.lvl AS lvl_12, t0.rgt AS rgt_13, t0.published AS published_14, t0.sort_index AS sort_index_15, t0.tree_root AS tree_root_16, t0.parent_id AS parent_id_17 FROM menu t0 WHERE t0.parent_id = ? ORDER BY t0.lft ASC
Parameters:
[
14
]
|
| 106 | 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:
[ "15" "el" "App\Entity\Menu" ] |
| 107 | 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:
[ "17" "el" "App\Entity\Menu" ] |
| 108 | 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:
[ "18" "el" "App\Entity\Menu" ] |
| 109 | 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:
[ "19" "el" "App\Entity\Menu" ] |
| 110 | 0.16 ms |
SELECT t0.id AS id_1, t0.migration_id AS migration_id_2, t0.name AS name_3, t0.type AS type_4, t0.website AS website_5, t0.page_name AS page_name_6, t0.slug AS slug_7, t0.url AS url_8, t0.internal_url_data AS internal_url_data_9, t0.description AS description_10, t0.lft AS lft_11, t0.lvl AS lvl_12, t0.rgt AS rgt_13, t0.published AS published_14, t0.sort_index AS sort_index_15, t0.tree_root AS tree_root_16, t0.parent_id AS parent_id_17 FROM menu t0 WHERE t0.parent_id = ? ORDER BY t0.lft ASC
Parameters:
[
15
]
|
| 111 | 0.16 ms |
SELECT t0.id AS id_1, t0.migration_id AS migration_id_2, t0.name AS name_3, t0.type AS type_4, t0.website AS website_5, t0.page_name AS page_name_6, t0.slug AS slug_7, t0.url AS url_8, t0.internal_url_data AS internal_url_data_9, t0.description AS description_10, t0.lft AS lft_11, t0.lvl AS lvl_12, t0.rgt AS rgt_13, t0.published AS published_14, t0.sort_index AS sort_index_15, t0.tree_root AS tree_root_16, t0.parent_id AS parent_id_17 FROM menu t0 WHERE t0.parent_id = ? ORDER BY t0.lft ASC
Parameters:
[
17
]
|
| 112 | 0.16 ms |
SELECT t0.id AS id_1, t0.migration_id AS migration_id_2, t0.name AS name_3, t0.type AS type_4, t0.website AS website_5, t0.page_name AS page_name_6, t0.slug AS slug_7, t0.url AS url_8, t0.internal_url_data AS internal_url_data_9, t0.description AS description_10, t0.lft AS lft_11, t0.lvl AS lvl_12, t0.rgt AS rgt_13, t0.published AS published_14, t0.sort_index AS sort_index_15, t0.tree_root AS tree_root_16, t0.parent_id AS parent_id_17 FROM menu t0 WHERE t0.parent_id = ? ORDER BY t0.lft ASC
Parameters:
[
18
]
|
| 113 | 0.15 ms |
SELECT t0.id AS id_1, t0.migration_id AS migration_id_2, t0.name AS name_3, t0.type AS type_4, t0.website AS website_5, t0.page_name AS page_name_6, t0.slug AS slug_7, t0.url AS url_8, t0.internal_url_data AS internal_url_data_9, t0.description AS description_10, t0.lft AS lft_11, t0.lvl AS lvl_12, t0.rgt AS rgt_13, t0.published AS published_14, t0.sort_index AS sort_index_15, t0.tree_root AS tree_root_16, t0.parent_id AS parent_id_17 FROM menu t0 WHERE t0.parent_id = ? ORDER BY t0.lft ASC
Parameters:
[
19
]
|
| 114 | 0.15 ms |
SELECT t0.id AS id_1, t0.migration_id AS migration_id_2, t0.name AS name_3, t0.type AS type_4, t0.website AS website_5, t0.page_name AS page_name_6, t0.slug AS slug_7, t0.url AS url_8, t0.internal_url_data AS internal_url_data_9, t0.description AS description_10, t0.lft AS lft_11, t0.lvl AS lvl_12, t0.rgt AS rgt_13, t0.published AS published_14, t0.sort_index AS sort_index_15, t0.tree_root AS tree_root_16, t0.parent_id AS parent_id_17 FROM menu t0 WHERE t0.parent_id = ? ORDER BY t0.lft ASC
Parameters:
[
8
]
|
| 115 | 0.21 ms |
SELECT t0.id AS id_1, t0.migration_id AS migration_id_2, t0.name AS name_3, t0.type AS type_4, t0.website AS website_5, t0.page_name AS page_name_6, t0.slug AS slug_7, t0.url AS url_8, t0.internal_url_data AS internal_url_data_9, t0.description AS description_10, t0.lft AS lft_11, t0.lvl AS lvl_12, t0.rgt AS rgt_13, t0.published AS published_14, t0.sort_index AS sort_index_15, t0.tree_root AS tree_root_16, t0.parent_id AS parent_id_17 FROM menu t0 WHERE t0.lvl = ? AND t0.website = ? ORDER BY t0.id DESC LIMIT 1
Parameters:
[ 0 "blk.gr" ] |
| 116 | 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:
[ "20" "el" "App\Entity\Menu" ] |
| 117 | 0.17 ms |
SELECT t0.id AS id_1, t0.migration_id AS migration_id_2, t0.name AS name_3, t0.type AS type_4, t0.website AS website_5, t0.page_name AS page_name_6, t0.slug AS slug_7, t0.url AS url_8, t0.internal_url_data AS internal_url_data_9, t0.description AS description_10, t0.lft AS lft_11, t0.lvl AS lvl_12, t0.rgt AS rgt_13, t0.published AS published_14, t0.sort_index AS sort_index_15, t0.tree_root AS tree_root_16, t0.parent_id AS parent_id_17 FROM menu t0 WHERE t0.parent_id = ? ORDER BY t0.lft ASC
Parameters:
[
20
]
|
| 118 | 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:
[ "21" "el" "App\Entity\Menu" ] |
| 119 | 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:
[ "32" "el" "App\Entity\Menu" ] |
| 120 | 0.18 ms |
SELECT t0.id AS id_1, t0.migration_id AS migration_id_2, t0.name AS name_3, t0.type AS type_4, t0.website AS website_5, t0.page_name AS page_name_6, t0.slug AS slug_7, t0.url AS url_8, t0.internal_url_data AS internal_url_data_9, t0.description AS description_10, t0.lft AS lft_11, t0.lvl AS lvl_12, t0.rgt AS rgt_13, t0.published AS published_14, t0.sort_index AS sort_index_15, t0.tree_root AS tree_root_16, t0.parent_id AS parent_id_17 FROM menu t0 WHERE t0.parent_id = ? ORDER BY t0.lft ASC
Parameters:
[
21
]
|
| 121 | 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:
[ "23" "el" "App\Entity\Menu" ] |
| 122 | 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:
[ "25" "el" "App\Entity\Menu" ] |
| 123 | 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:
[ "26" "el" "App\Entity\Menu" ] |
| 124 | 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:
[ "28" "el" "App\Entity\Menu" ] |
| 125 | 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:
[ "29" "el" "App\Entity\Menu" ] |
| 126 | 0.12 ms |
SELECT t0.id AS id_1, t0.migration_id AS migration_id_2, t0.name AS name_3, t0.type AS type_4, t0.website AS website_5, t0.page_name AS page_name_6, t0.slug AS slug_7, t0.url AS url_8, t0.internal_url_data AS internal_url_data_9, t0.description AS description_10, t0.lft AS lft_11, t0.lvl AS lvl_12, t0.rgt AS rgt_13, t0.published AS published_14, t0.sort_index AS sort_index_15, t0.tree_root AS tree_root_16, t0.parent_id AS parent_id_17 FROM menu t0 WHERE t0.parent_id = ? ORDER BY t0.lft ASC
Parameters:
[
23
]
|
| 127 | 0.13 ms |
SELECT t0.id AS id_1, t0.migration_id AS migration_id_2, t0.name AS name_3, t0.type AS type_4, t0.website AS website_5, t0.page_name AS page_name_6, t0.slug AS slug_7, t0.url AS url_8, t0.internal_url_data AS internal_url_data_9, t0.description AS description_10, t0.lft AS lft_11, t0.lvl AS lvl_12, t0.rgt AS rgt_13, t0.published AS published_14, t0.sort_index AS sort_index_15, t0.tree_root AS tree_root_16, t0.parent_id AS parent_id_17 FROM menu t0 WHERE t0.parent_id = ? ORDER BY t0.lft ASC
Parameters:
[
25
]
|
| 128 | 0.23 ms |
SELECT t0.id AS id_1, t0.migration_id AS migration_id_2, t0.name AS name_3, t0.type AS type_4, t0.website AS website_5, t0.page_name AS page_name_6, t0.slug AS slug_7, t0.url AS url_8, t0.internal_url_data AS internal_url_data_9, t0.description AS description_10, t0.lft AS lft_11, t0.lvl AS lvl_12, t0.rgt AS rgt_13, t0.published AS published_14, t0.sort_index AS sort_index_15, t0.tree_root AS tree_root_16, t0.parent_id AS parent_id_17 FROM menu t0 WHERE t0.parent_id = ? ORDER BY t0.lft ASC
Parameters:
[
26
]
|
| 129 | 0.18 ms |
SELECT t0.id AS id_1, t0.migration_id AS migration_id_2, t0.name AS name_3, t0.type AS type_4, t0.website AS website_5, t0.page_name AS page_name_6, t0.slug AS slug_7, t0.url AS url_8, t0.internal_url_data AS internal_url_data_9, t0.description AS description_10, t0.lft AS lft_11, t0.lvl AS lvl_12, t0.rgt AS rgt_13, t0.published AS published_14, t0.sort_index AS sort_index_15, t0.tree_root AS tree_root_16, t0.parent_id AS parent_id_17 FROM menu t0 WHERE t0.parent_id = ? ORDER BY t0.lft ASC
Parameters:
[
28
]
|
| 130 | 0.18 ms |
SELECT t0.id AS id_1, t0.migration_id AS migration_id_2, t0.name AS name_3, t0.type AS type_4, t0.website AS website_5, t0.page_name AS page_name_6, t0.slug AS slug_7, t0.url AS url_8, t0.internal_url_data AS internal_url_data_9, t0.description AS description_10, t0.lft AS lft_11, t0.lvl AS lvl_12, t0.rgt AS rgt_13, t0.published AS published_14, t0.sort_index AS sort_index_15, t0.tree_root AS tree_root_16, t0.parent_id AS parent_id_17 FROM menu t0 WHERE t0.parent_id = ? ORDER BY t0.lft ASC
Parameters:
[
29
]
|
| 131 | 0.19 ms |
SELECT t0.id AS id_1, t0.migration_id AS migration_id_2, t0.name AS name_3, t0.type AS type_4, t0.website AS website_5, t0.page_name AS page_name_6, t0.slug AS slug_7, t0.url AS url_8, t0.internal_url_data AS internal_url_data_9, t0.description AS description_10, t0.lft AS lft_11, t0.lvl AS lvl_12, t0.rgt AS rgt_13, t0.published AS published_14, t0.sort_index AS sort_index_15, t0.tree_root AS tree_root_16, t0.parent_id AS parent_id_17 FROM menu t0 WHERE t0.parent_id = ? ORDER BY t0.lft ASC
Parameters:
[
32
]
|
| 132 | 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:
[ "22" "el" "App\Entity\Menu" ] |
| 133 | 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:
[ "24" "el" "App\Entity\Menu" ] |
| 134 | 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:
[ "27" "el" "App\Entity\Menu" ] |
| 135 | 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:
[ "30" "el" "App\Entity\Menu" ] |
| 136 | 0.18 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" "el" "App\Entity\Menu" ] |
| 137 | 0.19 ms |
SELECT t0.id AS id_1, t0.migration_id AS migration_id_2, t0.name AS name_3, t0.type AS type_4, t0.website AS website_5, t0.page_name AS page_name_6, t0.slug AS slug_7, t0.url AS url_8, t0.internal_url_data AS internal_url_data_9, t0.description AS description_10, t0.lft AS lft_11, t0.lvl AS lvl_12, t0.rgt AS rgt_13, t0.published AS published_14, t0.sort_index AS sort_index_15, t0.tree_root AS tree_root_16, t0.parent_id AS parent_id_17 FROM menu t0 WHERE t0.parent_id = ? ORDER BY t0.lft ASC
Parameters:
[
22
]
|
| 138 | 0.17 ms |
SELECT t0.id AS id_1, t0.migration_id AS migration_id_2, t0.name AS name_3, t0.type AS type_4, t0.website AS website_5, t0.page_name AS page_name_6, t0.slug AS slug_7, t0.url AS url_8, t0.internal_url_data AS internal_url_data_9, t0.description AS description_10, t0.lft AS lft_11, t0.lvl AS lvl_12, t0.rgt AS rgt_13, t0.published AS published_14, t0.sort_index AS sort_index_15, t0.tree_root AS tree_root_16, t0.parent_id AS parent_id_17 FROM menu t0 WHERE t0.parent_id = ? ORDER BY t0.lft ASC
Parameters:
[
24
]
|
| 139 | 0.16 ms |
SELECT t0.id AS id_1, t0.migration_id AS migration_id_2, t0.name AS name_3, t0.type AS type_4, t0.website AS website_5, t0.page_name AS page_name_6, t0.slug AS slug_7, t0.url AS url_8, t0.internal_url_data AS internal_url_data_9, t0.description AS description_10, t0.lft AS lft_11, t0.lvl AS lvl_12, t0.rgt AS rgt_13, t0.published AS published_14, t0.sort_index AS sort_index_15, t0.tree_root AS tree_root_16, t0.parent_id AS parent_id_17 FROM menu t0 WHERE t0.parent_id = ? ORDER BY t0.lft ASC
Parameters:
[
27
]
|
| 140 | 0.17 ms |
SELECT t0.id AS id_1, t0.migration_id AS migration_id_2, t0.name AS name_3, t0.type AS type_4, t0.website AS website_5, t0.page_name AS page_name_6, t0.slug AS slug_7, t0.url AS url_8, t0.internal_url_data AS internal_url_data_9, t0.description AS description_10, t0.lft AS lft_11, t0.lvl AS lvl_12, t0.rgt AS rgt_13, t0.published AS published_14, t0.sort_index AS sort_index_15, t0.tree_root AS tree_root_16, t0.parent_id AS parent_id_17 FROM menu t0 WHERE t0.parent_id = ? ORDER BY t0.lft ASC
Parameters:
[
30
]
|
| 141 | 0.15 ms |
SELECT t0.id AS id_1, t0.migration_id AS migration_id_2, t0.name AS name_3, t0.type AS type_4, t0.website AS website_5, t0.page_name AS page_name_6, t0.slug AS slug_7, t0.url AS url_8, t0.internal_url_data AS internal_url_data_9, t0.description AS description_10, t0.lft AS lft_11, t0.lvl AS lvl_12, t0.rgt AS rgt_13, t0.published AS published_14, t0.sort_index AS sort_index_15, t0.tree_root AS tree_root_16, t0.parent_id AS parent_id_17 FROM menu t0 WHERE t0.parent_id = ? ORDER BY t0.lft ASC
Parameters:
[
31
]
|
| 142 | 0.27 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
]
|
| 143 | 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:
[ "4" "el" "App\Entity\Product\Category" ] |
| 144 | 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:
[ "5" "el" "App\Entity\Product\Category" ] |
| 145 | 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:
[ "6" "el" "App\Entity\Product\Category" ] |
| 146 | 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:
[ "7" "el" "App\Entity\Product\Category" ] |
| 147 | 0.18 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" "el" "App\Entity\Product\Category" ] |
| 148 | 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:
[ "9" "el" "App\Entity\Product\Category" ] |
| 149 | 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:
[ "10" "el" "App\Entity\Product\Category" ] |
| 150 | 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:
[ "11" "el" "App\Entity\Product\Category" ] |
| 151 | 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:
[ "14" "el" "App\Entity\Product\Category" ] |
| 152 | 0.23 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:
[ "474" "el" "App\Entity\Product\Category" ] |
| 153 | 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:
[ "475" "el" "App\Entity\Product\Category" ] |
| 154 | 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:
[ "476" "el" "App\Entity\Product\Category" ] |
| 155 | 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:
[ "477" "el" "App\Entity\Product\Category" ] |
| 156 | 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:
[ "478" "el" "App\Entity\Product\Category" ] |
| 157 | 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:
[ "479" "el" "App\Entity\Product\Category" ] |
| 158 | 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:
[ "481" "el" "App\Entity\Product\Category" ] |
| 159 | 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:
[ "482" "el" "App\Entity\Product\Category" ] |
| 160 | 0.14 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
]
|
| 161 | 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:
[ "1" "el" "App\Entity\Product\Category" ] |
| 162 | 0.66 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 < 932 AND p0_.lft > 1 AND p0_.tree_root = ? ORDER BY p0_.tree_root ASC, p0_.lft ASC
Parameters:
[
1
]
|
| 163 | 0.22 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\x13@ü3xlöš×ûòd9\x00\f"
]
|
| 164 | 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.id = ?
Parameters:
[
37
]
|
| 165 | 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:
[ "37" "el" "App\Entity\Product\Category" ] |
| 166 | 0.18 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.manufacturer_id AS manufacturer_id_3, t0.product_type_id AS product_type_id_4 FROM product_variant_group t0 WHERE t0.id = ?
Parameters:
[
203
]
|
| 167 | 0.19 ms |
SELECT t0.id AS id_1, t0.sort_order AS sort_order_2, t0.variant_group_id AS variant_group_id_3, t0.attribute_id AS attribute_id_4 FROM product_variant_group_filter_attribute t0 WHERE t0.variant_group_id = ? ORDER BY t0.sort_order ASC
Parameters:
[
203
]
|
| 168 | 0.29 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.online_discount_percentage AS online_discount_percentage_24, t0.availability AS availability_25, t0.available_at AS available_at_26, t0.offer AS offer_27, t0.cash_back AS cash_back_28, t0.ask_for_price AS ask_for_price_29, t0.warehouse_stock_warehouse AS warehouse_stock_warehouse_30, t0.warehouse_stock_quantity AS warehouse_stock_quantity_31, t0.warehouse_stock_reserved AS warehouse_stock_reserved_32, t0.warehouse_stock_target_stock AS warehouse_stock_target_stock_33, t0.warehouse_stock_immutable AS warehouse_stock_immutable_34, t0.price_gross_amount AS price_gross_amount_35, t0.price_gross_currency AS price_gross_currency_36, t0.price_with_discount_amount AS price_with_discount_amount_37, t0.price_with_discount_currency AS price_with_discount_currency_38, t0.type_id AS type_id_39, t0.main_image_id AS main_image_id_40, t0.manufacturer_id AS manufacturer_id_41, t0.variant_group_id AS variant_group_id_42, t0.discr, t0.price_url AS price_url_43, t0.price_comments AS price_comments_44, t0.supplier_discount AS supplier_discount_45, t0.special_discount AS special_discount_46, t0.customs_charges_percentage AS customs_charges_percentage_47, t0.markup_percentage AS markup_percentage_48, t0.product_dimensions AS product_dimensions_49, t0.net_weight AS net_weight_50, t0.warranty AS warranty_51, t0.accessories AS accessories_52, t0.original_price_amount AS original_price_amount_53, t0.original_price_currency AS original_price_currency_54, t0.supplier_shipping_value_amount AS supplier_shipping_value_amount_55, t0.supplier_shipping_value_currency AS supplier_shipping_value_currency_56, t0.package_length_mm AS package_length_mm_57, t0.package_width_mm AS package_width_mm_58, t0.package_height_mm AS package_height_mm_59, t0.package_details AS package_details_60, t0.package_dimension_unit AS package_dimension_unit_61, t0.package_grams AS package_grams_62, t0.package_weight_details AS package_weight_details_63, t0.package_weight_unit AS package_weight_unit_64, t0.kit_discount_percentage AS kit_discount_percentage_65 FROM products t0 WHERE t0.variant_group_id = ? AND t0.discr IN ('product', 'product_kit')
Parameters:
[
203
]
|
| 169 | 6.98 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:
[ "7209" "el" "App\Entity\Product\Object\BaseProduct" ] |
| 170 | 6.84 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:
[ "7247" "el" "App\Entity\Product\Object\BaseProduct" ] |
| 171 | 0.19 ms |
SELECT t0.id AS id_1, t0.text_value AS text_value_2, t0.extra_info AS extra_info_3, t0.quantity AS quantity_4, t0.product_id AS product_id_5, t0.attribute_id AS attribute_id_6, t0.attribute_value_id AS attribute_value_id_7 FROM product_attribute_value t0 WHERE t0.product_id = ?
Parameters:
[
7209
]
|
| 172 | 0.21 ms |
SELECT t0.id AS id_1, t0.text_value AS text_value_2, t0.extra_info AS extra_info_3, t0.quantity AS quantity_4, t0.product_id AS product_id_5, t0.attribute_id AS attribute_id_6, t0.attribute_value_id AS attribute_value_id_7 FROM product_attribute_value t0 WHERE t0.product_id = ?
Parameters:
[
7247
]
|
| 173 | 0.12 ms |
SELECT t0.id AS id_1, t0.value AS value_2, t0.sort_index AS sort_index_3, t0.extra_info AS extra_info_4, t0.attribute_id AS attribute_id_5 FROM attribute_value t0 WHERE t0.id = ?
Parameters:
[
2078
]
|
| 174 | 0.15 ms |
SELECT a0_.content AS content_0, a0_.field AS field_1 FROM attribute_value_translations a0_ WHERE a0_.foreign_key = ? AND a0_.locale = ? AND a0_.object_class = ?
Parameters:
[ "2078" "el" "App\Entity\Product\Attribute\AttributeValue" ] |
| 175 | 0.09 ms |
SELECT t0.id AS id_1, t0.value AS value_2, t0.sort_index AS sort_index_3, t0.extra_info AS extra_info_4, t0.attribute_id AS attribute_id_5 FROM attribute_value t0 WHERE t0.id = ?
Parameters:
[
2081
]
|
| 176 | 0.11 ms |
SELECT a0_.content AS content_0, a0_.field AS field_1 FROM attribute_value_translations a0_ WHERE a0_.foreign_key = ? AND a0_.locale = ? AND a0_.object_class = ?
Parameters:
[ "2081" "el" "App\Entity\Product\Attribute\AttributeValue" ] |
| 177 | 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 FROM product_type t0 WHERE t0.id = ?
Parameters:
[
16
]
|
| 178 | 0.33 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
]
|
| 179 | 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:
[ "15" "el" "App\Entity\Product\Category" ] |
| 180 | 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:
[ "17" "el" "App\Entity\Product\Category" ] |
| 181 | 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:
[ "19" "el" "App\Entity\Product\Category" ] |
| 182 | 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" "el" "App\Entity\Product\Category" ] |
| 183 | 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:
[ "22" "el" "App\Entity\Product\Category" ] |
| 184 | 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:
[ "24" "el" "App\Entity\Product\Category" ] |
| 185 | 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:
[ "25" "el" "App\Entity\Product\Category" ] |
| 186 | 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:
[ "27" "el" "App\Entity\Product\Category" ] |
| 187 | 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:
[ "28" "el" "App\Entity\Product\Category" ] |
| 188 | 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:
[ "30" "el" "App\Entity\Product\Category" ] |
| 189 | 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:
[ "32" "el" "App\Entity\Product\Category" ] |
| 190 | 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:
[ "33" "el" "App\Entity\Product\Category" ] |
| 191 | 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:
[ "36" "el" "App\Entity\Product\Category" ] |
| 192 | 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:
[ "38" "el" "App\Entity\Product\Category" ] |
| 193 | 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:
[ "39" "el" "App\Entity\Product\Category" ] |
| 194 | 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:
[ "40" "el" "App\Entity\Product\Category" ] |
| 195 | 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:
[ "41" "el" "App\Entity\Product\Category" ] |
| 196 | 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:
[ "42" "el" "App\Entity\Product\Category" ] |
| 197 | 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" "el" "App\Entity\Product\Category" ] |
| 198 | 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:
[ "44" "el" "App\Entity\Product\Category" ] |
| 199 | 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:
[ "45" "el" "App\Entity\Product\Category" ] |
| 200 | 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:
[ "46" "el" "App\Entity\Product\Category" ] |
| 201 | 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:
[ "47" "el" "App\Entity\Product\Category" ] |
| 202 | 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:
[ "48" "el" "App\Entity\Product\Category" ] |
| 203 | 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:
[ "49" "el" "App\Entity\Product\Category" ] |
| 204 | 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:
[ "50" "el" "App\Entity\Product\Category" ] |
| 205 | 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" "el" "App\Entity\Product\Category" ] |
| 206 | 0.15 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
]
|
| 207 | 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" "el" "App\Entity\Product\Category" ] |
| 208 | 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:
[ "23" "el" "App\Entity\Product\Category" ] |
| 209 | 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:
[ "26" "el" "App\Entity\Product\Category" ] |
| 210 | 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" "el" "App\Entity\Product\Category" ] |
| 211 | 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:
[ "35" "el" "App\Entity\Product\Category" ] |
| 212 | 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:
[
6
]
|
| 213 | 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:
[ "52" "el" "App\Entity\Product\Category" ] |
| 214 | 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:
[ "55" "el" "App\Entity\Product\Category" ] |
| 215 | 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:
[ "58" "el" "App\Entity\Product\Category" ] |
| 216 | 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:
[ "61" "el" "App\Entity\Product\Category" ] |
| 217 | 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" "el" "App\Entity\Product\Category" ] |
| 218 | 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:
[ "67" "el" "App\Entity\Product\Category" ] |
| 219 | 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:
[ "70" "el" "App\Entity\Product\Category" ] |
| 220 | 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:
[ "74" "el" "App\Entity\Product\Category" ] |
| 221 | 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:
[ "469" "el" "App\Entity\Product\Category" ] |
| 222 | 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:
[ "471" "el" "App\Entity\Product\Category" ] |
| 223 | 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:
[
7
]
|
| 224 | 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:
[ "53" "el" "App\Entity\Product\Category" ] |
| 225 | 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:
[ "57" "el" "App\Entity\Product\Category" ] |
| 226 | 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:
[ "59" "el" "App\Entity\Product\Category" ] |
| 227 | 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:
[ "62" "el" "App\Entity\Product\Category" ] |
| 228 | 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:
[ "64" "el" "App\Entity\Product\Category" ] |
| 229 | 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:
[ "68" "el" "App\Entity\Product\Category" ] |
| 230 | 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:
[ "71" "el" "App\Entity\Product\Category" ] |
| 231 | 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:
[ "72" "el" "App\Entity\Product\Category" ] |
| 232 | 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:
[ "75" "el" "App\Entity\Product\Category" ] |
| 233 | 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:
[
8
]
|
| 234 | 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:
[ "16" "el" "App\Entity\Product\Category" ] |
| 235 | 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:
[ "21" "el" "App\Entity\Product\Category" ] |
| 236 | 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:
[ "29" "el" "App\Entity\Product\Category" ] |
| 237 | 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:
[ "34" "el" "App\Entity\Product\Category" ] |
| 238 | 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:
[ "470" "el" "App\Entity\Product\Category" ] |
| 239 | 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:
[ "480" "el" "App\Entity\Product\Category" ] |
| 240 | 0.14 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
]
|
| 241 | 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:
[ "54" "el" "App\Entity\Product\Category" ] |
| 242 | 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:
[ "56" "el" "App\Entity\Product\Category" ] |
| 243 | 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:
[ "60" "el" "App\Entity\Product\Category" ] |
| 244 | 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:
[ "63" "el" "App\Entity\Product\Category" ] |
| 245 | 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:
[ "66" "el" "App\Entity\Product\Category" ] |
| 246 | 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:
[ "69" "el" "App\Entity\Product\Category" ] |
| 247 | 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:
[ "73" "el" "App\Entity\Product\Category" ] |
| 248 | 0.15 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
]
|
| 249 | 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
]
|
| 250 | 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:
[
14
]
|
| 251 | 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:
[
474
]
|
| 252 | 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:
[
475
]
|
| 253 | 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:
[
476
]
|
| 254 | 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:
[
477
]
|
| 255 | 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:
[
478
]
|
| 256 | 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:
[
479
]
|
| 257 | 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:
[
481
]
|
| 258 | 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:
[
482
]
|
| 259 | 0.17 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:
[
40010
]
|
| 260 | 0.20 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:
[
7314
]
|
| 261 | 0.26 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:
[
236
]
|
| 262 | 0.17 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.rate AS rate_3, t0.code AS code_4, t0.symbol AS symbol_5, t0.published AS published_6, t0.default_currency AS default_currency_7 FROM currency t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
"EUR"
]
|
| 263 | 0.16 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.rate AS rate_3, t0.code AS code_4, t0.symbol AS symbol_5, t0.published AS published_6, t0.default_currency AS default_currency_7 FROM currency t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
"EUR"
]
|
| 264 | 0.12 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.rate AS rate_3, t0.code AS code_4, t0.symbol AS symbol_5, t0.published AS published_6, t0.default_currency AS default_currency_7 FROM currency t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
"EUR"
]
|
| 265 | 0.09 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.rate AS rate_3, t0.code AS code_4, t0.symbol AS symbol_5, t0.published AS published_6, t0.default_currency AS default_currency_7 FROM currency t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
"EUR"
]
|
| 266 | 0.13 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.rate AS rate_3, t0.code AS code_4, t0.symbol AS symbol_5, t0.published AS published_6, t0.default_currency AS default_currency_7 FROM currency t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
"EUR"
]
|
| 267 | 0.09 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.rate AS rate_3, t0.code AS code_4, t0.symbol AS symbol_5, t0.published AS published_6, t0.default_currency AS default_currency_7 FROM currency t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
"EUR"
]
|
| 268 | 0.13 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.rate AS rate_3, t0.code AS code_4, t0.symbol AS symbol_5, t0.published AS published_6, t0.default_currency AS default_currency_7 FROM currency t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
"EUR"
]
|
| 269 | 0.09 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.rate AS rate_3, t0.code AS code_4, t0.symbol AS symbol_5, t0.published AS published_6, t0.default_currency AS default_currency_7 FROM currency t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
"EUR"
]
|
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 | 85 |
| App\Entity\Product\Object\ProductAttributeValue | 63 |
| App\Entity\Menu | 28 |
| App\Entity\Product\Attribute\AttributeValue | 22 |
| App\Entity\Product\Attribute\Attribute | 12 |
| App\Entity\Common\Files\AppFile | 8 |
| App\Entity\Product\Attribute\AttributeGroup | 4 |
| App\Entity\Product\Object\BaseProduct | 3 |
| App\Entity\Product\ProductType | 1 |
| App\Entity\Product\ProductManufacturer | 1 |
| App\Entity\Product\Object\ProductVariantGroup | 1 |
| App\Entity\Cart\Cart | 1 |
| App\Entity\Product\Object\ProductVariantGroupFilterAttribute | 1 |
| App\Entity\Common\Currency | 1 |