Error 500 Internal Server Error

GET https://demo.blk.gr/en/Discontinued_Cameras/DMC_GH3EG_K

Query Metrics

94 Database Queries
15 Different statements
112.14 ms Query time
0 Invalid entities
93 Managed entities

Queries

Group similar statements

default connection

# Time Info
1 0.29 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:
[
  "Discontinued_Cameras"
]
2 0.25 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:
[
  "131"
  "en"
  "App\Entity\Product\Category"
]
3 0.41 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:
[
  "DMC_GH3EG_K"
]
4 7.38 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:
[
  "1209"
  "en"
  "App\Entity\Product\Object\BaseProduct"
]
5 0.17 ms
"START TRANSACTION"
Parameters:
[]
6 0.28 ms
UPDATE products SET views = ? WHERE id = ?
Parameters:
[
  3
  1209
]
7 10.70 ms
"COMMIT"
Parameters:
[]
8 0.26 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:
[
  1209
]
9 57.93 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:
[
  1036
  6423
  6352
  6353
  6497
  6508
  9435
  6691
  6699
  6857
  6865
  6871
  7055
  7102
  6208
  1280
  1367
  1468
  1541
  1930
  2054
  2061
  2063
  9374
  2133
  2134
  2140
  2220
  2223
  2224
  2226
  2227
  2234
  2309
  2311
  2617
  2689
  2927
  2982
  9240
  9300
  9301
  9316
  469
  9339
  313
  437
  612
  613
  774
  2249
  2882
  5023
  5882
  5987
  6546
  6547
  6652
  7190
  7226
  7230
  7267
  9461
  7641
  7854
  8943
  8947
  8583
  8611
  8867
  1289
  9508
  9514
  9487
  8800
  8802
  8870
  8871
  8892
  8950
  8991
  9030
  9035
  9067
  9068
  9100
  9290
  973
  978
  983
  989
  1122
  1123
  1124
  1130
  1132
  1298
  1410
  1545
  1600
  1606
  1642
  6662
  9244
  9303
  8018
  8631
  9190
  3614
  3903
  2926
  3282
  3283
  3284
  3565
  3566
  3843
  4125
  446
  9495
  9055
  9056
  9057
  9058
  9083
  9088
  9133
  9194
  8002
  8057
  8058
  5228
  6456
  6458
  6608
  6609
  7381
  7382
  9456
  7581
  10102
  8100
  9473
  8273
  8700
  9213
  7225
  7349
  7350
  7493
  7498
  7502
  9463
  7650
  7671
  7799
  7810
  7863
  7874
  7884
  7943
  463
  745
  746
  5050
  5056
  5057
  5058
  5272
  5541
  5619
  6569
  6808
  6818
  747
  9355
  968
  4862
  4863
  6483
  1
  "view"
  "no_view"
]
10 0.39 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:
[
  1209
]
11 0.27 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:
[
  19
]
12 0.48 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:
[
  "19"
  "en"
  "App\Entity\Product\Attribute\Attribute"
]
13 0.26 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
]
14 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:
[
  "6"
  "en"
  "App\Entity\Product\Attribute\AttributeGroup"
]
15 0.19 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:
[
  20
]
16 0.30 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:
[
  "20"
  "en"
  "App\Entity\Product\Attribute\Attribute"
]
17 0.21 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:
[
  8
]
18 0.30 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:
[
  "8"
  "en"
  "App\Entity\Product\Attribute\Attribute"
]
19 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:
[
  2
]
20 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:
[
  "2"
  "en"
  "App\Entity\Product\Attribute\AttributeGroup"
]
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:
[
  12
]
22 0.28 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:
[
  "12"
  "en"
  "App\Entity\Product\Attribute\Attribute"
]
23 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:
[
  13
]
24 0.28 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:
[
  "13"
  "en"
  "App\Entity\Product\Attribute\Attribute"
]
25 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:
[
  3
]
26 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:
[
  "3"
  "en"
  "App\Entity\Product\Attribute\AttributeGroup"
]
27 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:
[
  28
]
28 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"
  "en"
  "App\Entity\Product\Attribute\Attribute"
]
29 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:
[
  5
]
30 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:
[
  "5"
  "en"
  "App\Entity\Product\Attribute\AttributeGroup"
]
31 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:
[
  796
]
32 2.20 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:
[
  "796"
  "en"
  "App\Entity\Product\Attribute\AttributeValue"
]
33 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:
[
  33
]
34 0.28 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:
[
  "33"
  "en"
  "App\Entity\Product\Attribute\Attribute"
]
35 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:
[
  830
]
36 2.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:
[
  "830"
  "en"
  "App\Entity\Product\Attribute\AttributeValue"
]
37 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:
[
  23
]
38 0.28 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:
[
  "23"
  "en"
  "App\Entity\Product\Attribute\Attribute"
]
39 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:
[
  681
]
40 2.14 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:
[
  "681"
  "en"
  "App\Entity\Product\Attribute\AttributeValue"
]
41 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:
[
  730
]
42 2.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:
[
  "730"
  "en"
  "App\Entity\Product\Attribute\AttributeValue"
]
43 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:
[
  18
]
44 0.28 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:
[
  "18"
  "en"
  "App\Entity\Product\Attribute\Attribute"
]
45 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:
[
  4
]
46 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:
[
  "4"
  "en"
  "App\Entity\Product\Attribute\AttributeGroup"
]
47 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:
[
  17
]
48 0.27 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:
[
  "17"
  "en"
  "App\Entity\Product\Attribute\Attribute"
]
49 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:
[
  16
]
50 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:
[
  "16"
  "en"
  "App\Entity\Product\Attribute\Attribute"
]
51 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:
[
  14
]
52 0.27 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:
[
  "14"
  "en"
  "App\Entity\Product\Attribute\Attribute"
]
53 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:
[
  38
]
54 0.24 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:
[
  "38"
  "en"
  "App\Entity\Product\Attribute\Attribute"
]
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:
[
  24
]
56 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:
[
  "24"
  "en"
  "App\Entity\Product\Attribute\Attribute"
]
57 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:
[
  15
]
58 0.28 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:
[
  "15"
  "en"
  "App\Entity\Product\Attribute\Attribute"
]
59 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:
[
  9
]
60 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:
[
  "9"
  "en"
  "App\Entity\Product\Attribute\Attribute"
]
61 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:
[
  10
]
62 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:
[
  "10"
  "en"
  "App\Entity\Product\Attribute\Attribute"
]
63 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:
[
  11
]
64 0.27 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:
[
  "11"
  "en"
  "App\Entity\Product\Attribute\Attribute"
]
65 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:
[
  61
]
66 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:
[
  "61"
  "en"
  "App\Entity\Product\Attribute\Attribute"
]
67 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:
[
  7
]
68 0.30 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:
[
  "7"
  "en"
  "App\Entity\Product\Attribute\Attribute"
]
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:
[
  5
]
70 0.27 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:
[
  "5"
  "en"
  "App\Entity\Product\Attribute\Attribute"
]
71 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:
[
  1
]
72 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:
[
  "1"
  "en"
  "App\Entity\Product\Attribute\AttributeGroup"
]
73 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:
[
  194
]
74 2.14 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:
[
  "194"
  "en"
  "App\Entity\Product\Attribute\AttributeValue"
]
75 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:
[
  4
]
76 0.28 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:
[
  "4"
  "en"
  "App\Entity\Product\Attribute\Attribute"
]
77 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:
[
  154
]
78 2.14 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:
[
  "154"
  "en"
  "App\Entity\Product\Attribute\AttributeValue"
]
79 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:
[
  3
]
80 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:
[
  "3"
  "en"
  "App\Entity\Product\Attribute\Attribute"
]
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:
[
  142
]
82 2.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:
[
  "142"
  "en"
  "App\Entity\Product\Attribute\AttributeValue"
]
83 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:
[
  150
]
84 2.13 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:
[
  "150"
  "en"
  "App\Entity\Product\Attribute\AttributeValue"
]
85 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:
[
  1
]
86 0.28 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:
[
  "1"
  "en"
  "App\Entity\Product\Attribute\Attribute"
]
87 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
]
88 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"
  "en"
  "App\Entity\Product\Attribute\AttributeGroup"
]
89 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:
[
  8
]
90 2.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:
[
  "8"
  "en"
  "App\Entity\Product\Attribute\AttributeValue"
]
91 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:
[
  10
]
92 2.18 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:
[
  "10"
  "en"
  "App\Entity\Product\Attribute\AttributeValue"
]
93 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:
[
  25
]
94 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:
[
  "25"
  "en"
  "App\Entity\Product\Attribute\Attribute"
]

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\Object\ProductAttributeValue 31
App\Entity\Product\Attribute\Attribute 25
App\Entity\Product\Attribute\AttributeValue 23
App\Entity\Product\Attribute\AttributeGroup 7
App\Entity\Product\Category 3
App\Entity\Product\Object\BaseProduct 1
App\Entity\Product\ProductType 1
App\Entity\Common\Files\AppFile 1
App\Entity\Product\ProductManufacturer 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\ProductType No errors.
App\Entity\Common\Files\ProductImage No errors.
App\Entity\Product\ProductManufacturer No errors.
App\Entity\Product\Object\ProductVariantGroup No errors.
App\Entity\Product\Object\Dimensions No errors.
App\Entity\Product\Object\Weight No errors.
App\Entity\Product\Object\Product No errors.
App\Entity\Product\Object\ProductKit No errors.
App\Entity\Product\Object\ProductCategory No errors.
App\Entity\Product\ProductExtraWebsite No errors.
App\Entity\Product\Object\ProductAttributeValue No errors.
App\Entity\Product\ProductReference No errors.
App\Entity\Translation\ProductTranslation No errors.
App\Entity\Common\Files\ArticleImage No errors.
App\Entity\Common\Files\ManufacturerLogo No errors.
App\Entity\Common\Files\ProductReferencePdf No errors.
App\Entity\Common\Files\ProductReferenceImage No errors.
App\Entity\Common\Files\Slide No errors.
App\Entity\Product\Object\BaseRental No errors.
App\Entity\Product\Object\ProductVariantGroupFilterAttribute No errors.
App\Entity\Product\Object\ProductKitPart No errors.
App\Entity\Product\Attribute\Attribute No errors.
App\Entity\Product\Attribute\AttributeValue No errors.
App\Entity\Article\Article No errors.
App\Entity\Article\ArticleCategory No errors.
App\Entity\Common\Country No errors.
App\Entity\Common\Currency No errors.
App\Entity\Common\Region No errors.
App\Entity\Translation\RentalTranslation No errors.
App\Entity\Translation\AttributeTranslation No errors.
App\Entity\Translation\AttributeValueTranslation No errors.
App\Entity\User\User No errors.
App\Entity\User\AdminUser No errors.
App\Entity\User\WebUser No errors.
App\Entity\User\Role No errors.
App\Entity\Slide\Slider No errors.
App\Entity\Slide\ManufacturerLogo No errors.
App\Entity\Slide\TopSlider No errors.
App\Entity\Statistics\OpenAIUsage No errors.
App\Entity\Cart\Cart No errors.
App\Entity\Cart\CartItem No errors.
App\Entity\ResetPasswordRequest No errors.
App\Entity\UserAccount\Address No errors.
App\Entity\UserAccount\Details No errors.
App\Entity\UserAccount\Company No errors.
App\Entity\UserAccount\Individual No errors.
App\Entity\Menu No errors.
App\Entity\Product\Attribute\AttributeGroup No errors.
App\Entity\Product\Object\RentalAttributeValue No errors.
App\Entity\Product\Object\Rental No errors.
App\Entity\Product\Object\RentalKit No errors.
App\Entity\Product\Object\RentalCategory No errors.
App\Entity\Product\RentalReference No errors.
App\Entity\LogEntry No errors.
App\Entity\Order\CustomerSnapshot No errors.
App\Entity\Order\AddressSnapshot No errors.
App\Entity\Order\Order No errors.
App\Entity\Order\BaseProductSnapshot No errors.
App\Entity\Order\OrderItem No errors.
Gedmo\Translatable\Entity\MappedSuperclass\AbstractPersonalTranslation No errors.
Gedmo\Tree\Entity\MappedSuperclass\AbstractClosure No errors.