Query Metrics
134
Database Queries
28
Different statements
1590.95 ms
Query time
0
Invalid entities
108
Managed entities
Queries
default connection
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.74 ms |
SELECT t0.name AS name_1, t0.slug AS slug_2, t0.position AS position_3, t0.enabled AS enabled_4, t0.number_id AS number_id_5, t0.is_virtual AS is_virtual_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.id AS id_9, t0.related_category_id AS related_category_id_10, t0.parent_category_id AS parent_category_id_11 FROM products_categories t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
"camaras-digitales-1150"
]
|
| 2 | 0.44 ms |
SELECT t0.name AS name_1, t0.slug AS slug_2, t0.position AS position_3, t0.enabled AS enabled_4, t0.number_id AS number_id_5, t0.is_virtual AS is_virtual_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.id AS id_9, t0.related_category_id AS related_category_id_10, t0.parent_category_id AS parent_category_id_11 FROM products_categories t0 WHERE t0.parent_category_id = ?
Parameters:
[
"7656ed5f-ec3f-5217-9573-e3aa3316fc2f"
]
|
| 3 | 0.20 ms |
SELECT t0.name AS name_1, t0.slug AS slug_2, t0.position AS position_3, t0.enabled AS enabled_4, t0.number_id AS number_id_5, t0.is_virtual AS is_virtual_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.id AS id_9, t0.related_category_id AS related_category_id_10, t0.parent_category_id AS parent_category_id_11 FROM products_categories t0 WHERE t0.parent_category_id = ?
Parameters:
[
"1415a39e-9a6e-5e82-8d70-e0febf387696"
]
|
| 4 | 0.18 ms |
SELECT t0.name AS name_1, t0.slug AS slug_2, t0.position AS position_3, t0.enabled AS enabled_4, t0.number_id AS number_id_5, t0.is_virtual AS is_virtual_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.id AS id_9, t0.related_category_id AS related_category_id_10, t0.parent_category_id AS parent_category_id_11 FROM products_categories t0 WHERE t0.parent_category_id = ?
Parameters:
[
"4f314950-6034-5671-a352-4ef848f6bc04"
]
|
| 5 | 0.19 ms |
SELECT t0.name AS name_1, t0.slug AS slug_2, t0.position AS position_3, t0.enabled AS enabled_4, t0.number_id AS number_id_5, t0.is_virtual AS is_virtual_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.id AS id_9, t0.related_category_id AS related_category_id_10, t0.parent_category_id AS parent_category_id_11 FROM products_categories t0 WHERE t0.parent_category_id = ?
Parameters:
[
"639e5567-8297-57ca-9070-4e50f26eafaf"
]
|
| 6 | 0.19 ms |
SELECT t0.name AS name_1, t0.slug AS slug_2, t0.position AS position_3, t0.enabled AS enabled_4, t0.number_id AS number_id_5, t0.is_virtual AS is_virtual_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.id AS id_9, t0.related_category_id AS related_category_id_10, t0.parent_category_id AS parent_category_id_11 FROM products_categories t0 WHERE t0.parent_category_id = ?
Parameters:
[
"673f29a2-d05a-5977-b3d6-718f0de1e383"
]
|
| 7 | 0.19 ms |
SELECT t0.name AS name_1, t0.slug AS slug_2, t0.position AS position_3, t0.enabled AS enabled_4, t0.number_id AS number_id_5, t0.is_virtual AS is_virtual_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.id AS id_9, t0.related_category_id AS related_category_id_10, t0.parent_category_id AS parent_category_id_11 FROM products_categories t0 WHERE t0.parent_category_id = ?
Parameters:
[
"75494ced-fa49-5903-8914-236fe0ac2c86"
]
|
| 8 | 0.17 ms |
SELECT t0.name AS name_1, t0.slug AS slug_2, t0.position AS position_3, t0.enabled AS enabled_4, t0.number_id AS number_id_5, t0.is_virtual AS is_virtual_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.id AS id_9, t0.related_category_id AS related_category_id_10, t0.parent_category_id AS parent_category_id_11 FROM products_categories t0 WHERE t0.parent_category_id = ?
Parameters:
[
"ad281a49-01a1-54a2-8d0e-b50573e36bff"
]
|
| 9 | 0.18 ms |
SELECT t0.name AS name_1, t0.slug AS slug_2, t0.position AS position_3, t0.enabled AS enabled_4, t0.number_id AS number_id_5, t0.is_virtual AS is_virtual_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.id AS id_9, t0.related_category_id AS related_category_id_10, t0.parent_category_id AS parent_category_id_11 FROM products_categories t0 WHERE t0.parent_category_id = ?
Parameters:
[
"b382bbda-24b9-5f77-abeb-3217fcbec693"
]
|
| 10 | 704.97 ms |
SELECT p0_.slug AS slug_0, p0_.name AS name_1, p0_.description AS description_2, p0_.description_short AS description_short_3, p0_.supplier_reference AS supplier_reference_4, p0_.manufacturer_reference AS manufacturer_reference_5, p0_.ean AS ean_6, p0_.position AS position_7, p0_.status AS status_8, p0_.tax_type AS tax_type_9, p0_.showcase AS showcase_10, p0_.on_offer AS on_offer_11, p0_.new AS new_12, p0_.show_on_home_deals AS show_on_home_deals_13, p0_.show_on_home_new_products AS show_on_home_new_products_14, p0_.kit AS kit_15, p0_.show_only_in_pack AS show_only_in_pack_16, p0_.price_buy AS price_buy_17, p0_.price_sell AS price_sell_18, p0_.price_offer AS price_offer_19, p0_.soa AS soa_20, p0_.stock AS stock_21, p0_.stock_supplier AS stock_supplier_22, p0_.min AS min_23, p0_.max AS max_24, p0_.period AS period_25, p0_.internal_comments AS internal_comments_26, p0_.created_at AS created_at_27, p0_.updated_at AS updated_at_28, p0_.last_activation_at AS last_activation_at_29, p0_.product_specs AS product_specs_30, p0_.cron_export_status AS cron_export_status_31, p0_.id AS id_32, CASE WHEN p0_.price_offer IS NOT NULL THEN p0_.price_offer ELSE p0_.price_sell END AS sclr_33, p0_.brand_id AS brand_id_34, p0_.created_by_user AS created_by_user_35, p0_.updated_by_user AS updated_by_user_36, p0_.last_activation_by_user AS last_activation_by_user_37 FROM products p0_ LEFT JOIN products_rel_categories p2_ ON p0_.id = p2_.product_id LEFT JOIN products_categories p1_ ON p1_.id = p2_.category_id INNER JOIN products_brands p3_ ON p0_.brand_id = p3_.id WHERE p0_.show_only_in_pack = ? AND p1_.id IN (?, ?, ?, ?, ?, ?, ?, ?) AND p3_.enabled = ? AND p0_.status = ? ORDER BY p3_.name ASC, sclr_33 DESC LIMIT 20 OFFSET 420
Parameters:
[ 0 "7656ed5f-ec3f-5217-9573-e3aa3316fc2f" "1415a39e-9a6e-5e82-8d70-e0febf387696" "4f314950-6034-5671-a352-4ef848f6bc04" "639e5567-8297-57ca-9070-4e50f26eafaf" "673f29a2-d05a-5977-b3d6-718f0de1e383" "75494ced-fa49-5903-8914-236fe0ac2c86" "ad281a49-01a1-54a2-8d0e-b50573e36bff" "b382bbda-24b9-5f77-abeb-3217fcbec693" 1 1 ] |
| 11 | 1.66 ms |
SELECT t0.name AS name_1, t0.enabled AS enabled_2, t0.slug AS slug_3, t0.position AS position_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.id AS id_7, t0.feature_id AS feature_id_8 FROM products_feature_values t0 INNER JOIN products_rel_feature_values ON t0.id = products_rel_feature_values.feature_value_id WHERE products_rel_feature_values.product_id = ?
Parameters:
[
38402
]
|
| 12 | 0.48 ms |
SELECT t0.name AS name_1, t0.enabled AS enabled_2, t0.slug AS slug_3, t0.position AS position_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.id AS id_7, t0.feature_id AS feature_id_8 FROM products_feature_values t0 INNER JOIN products_rel_feature_values ON t0.id = products_rel_feature_values.feature_value_id WHERE products_rel_feature_values.product_id = ?
Parameters:
[
38498
]
|
| 13 | 0.33 ms |
SELECT t0.name AS name_1, t0.enabled AS enabled_2, t0.slug AS slug_3, t0.position AS position_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.id AS id_7, t0.feature_id AS feature_id_8 FROM products_feature_values t0 INNER JOIN products_rel_feature_values ON t0.id = products_rel_feature_values.feature_value_id WHERE products_rel_feature_values.product_id = ?
Parameters:
[
38507
]
|
| 14 | 0.29 ms |
SELECT t0.name AS name_1, t0.enabled AS enabled_2, t0.slug AS slug_3, t0.position AS position_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.id AS id_7, t0.feature_id AS feature_id_8 FROM products_feature_values t0 INNER JOIN products_rel_feature_values ON t0.id = products_rel_feature_values.feature_value_id WHERE products_rel_feature_values.product_id = ?
Parameters:
[
38510
]
|
| 15 | 0.44 ms |
SELECT t0.name AS name_1, t0.enabled AS enabled_2, t0.slug AS slug_3, t0.position AS position_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.id AS id_7, t0.feature_id AS feature_id_8 FROM products_feature_values t0 INNER JOIN products_rel_feature_values ON t0.id = products_rel_feature_values.feature_value_id WHERE products_rel_feature_values.product_id = ?
Parameters:
[
38511
]
|
| 16 | 0.74 ms |
SELECT t0.name AS name_1, t0.enabled AS enabled_2, t0.slug AS slug_3, t0.position AS position_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.id AS id_7, t0.feature_id AS feature_id_8 FROM products_feature_values t0 INNER JOIN products_rel_feature_values ON t0.id = products_rel_feature_values.feature_value_id WHERE products_rel_feature_values.product_id = ?
Parameters:
[
38722
]
|
| 17 | 0.71 ms |
SELECT t0.name AS name_1, t0.enabled AS enabled_2, t0.slug AS slug_3, t0.position AS position_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.id AS id_7, t0.feature_id AS feature_id_8 FROM products_feature_values t0 INNER JOIN products_rel_feature_values ON t0.id = products_rel_feature_values.feature_value_id WHERE products_rel_feature_values.product_id = ?
Parameters:
[
38988
]
|
| 18 | 0.58 ms |
SELECT t0.name AS name_1, t0.enabled AS enabled_2, t0.slug AS slug_3, t0.position AS position_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.id AS id_7, t0.feature_id AS feature_id_8 FROM products_feature_values t0 INNER JOIN products_rel_feature_values ON t0.id = products_rel_feature_values.feature_value_id WHERE products_rel_feature_values.product_id = ?
Parameters:
[
40730
]
|
| 19 | 0.28 ms |
SELECT t0.name AS name_1, t0.enabled AS enabled_2, t0.slug AS slug_3, t0.position AS position_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.id AS id_7, t0.feature_id AS feature_id_8 FROM products_feature_values t0 INNER JOIN products_rel_feature_values ON t0.id = products_rel_feature_values.feature_value_id WHERE products_rel_feature_values.product_id = ?
Parameters:
[
40731
]
|
| 20 | 0.56 ms |
SELECT t0.name AS name_1, t0.enabled AS enabled_2, t0.slug AS slug_3, t0.position AS position_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.id AS id_7, t0.feature_id AS feature_id_8 FROM products_feature_values t0 INNER JOIN products_rel_feature_values ON t0.id = products_rel_feature_values.feature_value_id WHERE products_rel_feature_values.product_id = ?
Parameters:
[
40894
]
|
| 21 | 0.56 ms |
SELECT t0.name AS name_1, t0.enabled AS enabled_2, t0.slug AS slug_3, t0.position AS position_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.id AS id_7, t0.feature_id AS feature_id_8 FROM products_feature_values t0 INNER JOIN products_rel_feature_values ON t0.id = products_rel_feature_values.feature_value_id WHERE products_rel_feature_values.product_id = ?
Parameters:
[
40992
]
|
| 22 | 0.30 ms |
SELECT t0.name AS name_1, t0.enabled AS enabled_2, t0.slug AS slug_3, t0.position AS position_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.id AS id_7, t0.feature_id AS feature_id_8 FROM products_feature_values t0 INNER JOIN products_rel_feature_values ON t0.id = products_rel_feature_values.feature_value_id WHERE products_rel_feature_values.product_id = ?
Parameters:
[
40993
]
|
| 23 | 0.28 ms |
SELECT t0.name AS name_1, t0.enabled AS enabled_2, t0.slug AS slug_3, t0.position AS position_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.id AS id_7, t0.feature_id AS feature_id_8 FROM products_feature_values t0 INNER JOIN products_rel_feature_values ON t0.id = products_rel_feature_values.feature_value_id WHERE products_rel_feature_values.product_id = ?
Parameters:
[
40994
]
|
| 24 | 0.26 ms |
SELECT t0.name AS name_1, t0.enabled AS enabled_2, t0.slug AS slug_3, t0.position AS position_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.id AS id_7, t0.feature_id AS feature_id_8 FROM products_feature_values t0 INNER JOIN products_rel_feature_values ON t0.id = products_rel_feature_values.feature_value_id WHERE products_rel_feature_values.product_id = ?
Parameters:
[
40995
]
|
| 25 | 0.27 ms |
SELECT t0.name AS name_1, t0.enabled AS enabled_2, t0.slug AS slug_3, t0.position AS position_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.id AS id_7, t0.feature_id AS feature_id_8 FROM products_feature_values t0 INNER JOIN products_rel_feature_values ON t0.id = products_rel_feature_values.feature_value_id WHERE products_rel_feature_values.product_id = ?
Parameters:
[
40996
]
|
| 26 | 0.27 ms |
SELECT t0.name AS name_1, t0.enabled AS enabled_2, t0.slug AS slug_3, t0.position AS position_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.id AS id_7, t0.feature_id AS feature_id_8 FROM products_feature_values t0 INNER JOIN products_rel_feature_values ON t0.id = products_rel_feature_values.feature_value_id WHERE products_rel_feature_values.product_id = ?
Parameters:
[
40997
]
|
| 27 | 0.24 ms |
SELECT t0.name AS name_1, t0.enabled AS enabled_2, t0.slug AS slug_3, t0.position AS position_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.id AS id_7, t0.feature_id AS feature_id_8 FROM products_feature_values t0 INNER JOIN products_rel_feature_values ON t0.id = products_rel_feature_values.feature_value_id WHERE products_rel_feature_values.product_id = ?
Parameters:
[
40998
]
|
| 28 | 0.23 ms |
SELECT t0.name AS name_1, t0.enabled AS enabled_2, t0.slug AS slug_3, t0.position AS position_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.id AS id_7, t0.feature_id AS feature_id_8 FROM products_feature_values t0 INNER JOIN products_rel_feature_values ON t0.id = products_rel_feature_values.feature_value_id WHERE products_rel_feature_values.product_id = ?
Parameters:
[
40999
]
|
| 29 | 0.28 ms |
SELECT t0.name AS name_1, t0.enabled AS enabled_2, t0.slug AS slug_3, t0.position AS position_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.id AS id_7, t0.feature_id AS feature_id_8 FROM products_feature_values t0 INNER JOIN products_rel_feature_values ON t0.id = products_rel_feature_values.feature_value_id WHERE products_rel_feature_values.product_id = ?
Parameters:
[
41000
]
|
| 30 | 0.27 ms |
SELECT t0.name AS name_1, t0.enabled AS enabled_2, t0.slug AS slug_3, t0.position AS position_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.id AS id_7, t0.feature_id AS feature_id_8 FROM products_feature_values t0 INNER JOIN products_rel_feature_values ON t0.id = products_rel_feature_values.feature_value_id WHERE products_rel_feature_values.product_id = ?
Parameters:
[
41001
]
|
| 31 | 227.98 ms |
SELECT count(1) AS sclr_0 FROM products p0_ LEFT JOIN products_rel_categories p2_ ON p0_.id = p2_.product_id LEFT JOIN products_categories p1_ ON p1_.id = p2_.category_id INNER JOIN products_brands p3_ ON p0_.brand_id = p3_.id WHERE p0_.show_only_in_pack = ? AND p1_.id IN (?, ?, ?, ?, ?, ?, ?, ?) AND p3_.enabled = ? AND p0_.status = ?
Parameters:
[ 0 "7656ed5f-ec3f-5217-9573-e3aa3316fc2f" "1415a39e-9a6e-5e82-8d70-e0febf387696" "4f314950-6034-5671-a352-4ef848f6bc04" "639e5567-8297-57ca-9070-4e50f26eafaf" "673f29a2-d05a-5977-b3d6-718f0de1e383" "75494ced-fa49-5903-8914-236fe0ac2c86" "ad281a49-01a1-54a2-8d0e-b50573e36bff" "b382bbda-24b9-5f77-abeb-3217fcbec693" 1 1 ] |
| 32 | 24.39 ms |
SELECT p0_.slug AS slug_0, p0_.id AS id_1, p0_.name AS name_2 FROM products p1_ LEFT JOIN products_rel_categories p3_ ON p1_.id = p3_.product_id LEFT JOIN products_categories p2_ ON p2_.id = p3_.category_id INNER JOIN products_brands p4_ ON p1_.brand_id = p4_.id INNER JOIN products_brands p0_ ON p1_.brand_id = p0_.id WHERE p1_.show_only_in_pack = ? AND p2_.id IN (?, ?, ?, ?, ?, ?, ?, ?) AND p4_.enabled = ? AND p1_.status = ? GROUP BY p0_.id ORDER BY p0_.name ASC
Parameters:
[ 0 "7656ed5f-ec3f-5217-9573-e3aa3316fc2f" "1415a39e-9a6e-5e82-8d70-e0febf387696" "4f314950-6034-5671-a352-4ef848f6bc04" "639e5567-8297-57ca-9070-4e50f26eafaf" "673f29a2-d05a-5977-b3d6-718f0de1e383" "75494ced-fa49-5903-8914-236fe0ac2c86" "ad281a49-01a1-54a2-8d0e-b50573e36bff" "b382bbda-24b9-5f77-abeb-3217fcbec693" 1 1 ] |
| 33 | 21.25 ms |
SELECT p0_.slug AS slug_0, p0_.id AS id_1, p0_.name AS name_2, p0_.slug AS slug_3 FROM products p1_ LEFT JOIN products_rel_categories p2_ ON p1_.id = p2_.product_id LEFT JOIN products_categories p0_ ON p0_.id = p2_.category_id INNER JOIN products_brands p3_ ON p1_.brand_id = p3_.id WHERE p1_.show_only_in_pack = ? AND p0_.id IN (?, ?, ?, ?, ?, ?, ?, ?) AND p3_.enabled = ? AND p1_.status = ? GROUP BY p0_.id ORDER BY p0_.name ASC
Parameters:
[ 0 "7656ed5f-ec3f-5217-9573-e3aa3316fc2f" "1415a39e-9a6e-5e82-8d70-e0febf387696" "4f314950-6034-5671-a352-4ef848f6bc04" "639e5567-8297-57ca-9070-4e50f26eafaf" "673f29a2-d05a-5977-b3d6-718f0de1e383" "75494ced-fa49-5903-8914-236fe0ac2c86" "ad281a49-01a1-54a2-8d0e-b50573e36bff" "b382bbda-24b9-5f77-abeb-3217fcbec693" 1 1 ] |
| 34 | 516.83 ms |
SELECT p0_.id AS id_0, p1_.id AS id_1, p1_.name AS name_2, p0_.name AS name_3, p1_.slug AS slug_4, p0_.slug AS slug_5, p0_.position AS position_6 FROM products p2_ LEFT JOIN products_rel_categories p4_ ON p2_.id = p4_.product_id LEFT JOIN products_categories p3_ ON p3_.id = p4_.category_id INNER JOIN products_brands p5_ ON p2_.brand_id = p5_.id INNER JOIN products_rel_feature_values p6_ ON p2_.id = p6_.product_id INNER JOIN products_feature_values p0_ ON p0_.id = p6_.feature_value_id INNER JOIN products_features p1_ ON p0_.feature_id = p1_.id INNER JOIN products_categories_rel_products_features p7_ ON p1_.id = p7_.feature_id AND (p7_.feature_id = p1_.id AND p7_.category_id IN (?, ?, ?, ?, ?, ?, ?, ?)) WHERE p2_.show_only_in_pack = ? AND p3_.id IN (?, ?, ?, ?, ?, ?, ?, ?) AND p5_.enabled = ? AND p2_.status = ? GROUP BY p0_.id, p1_.id, p1_.name, p0_.name, p1_.slug, p0_.slug, p0_.position, p7_.position ORDER BY p2_.id ASC, p7_.position ASC, p0_.position ASC
Parameters:
[ "7656ed5f-ec3f-5217-9573-e3aa3316fc2f" "1415a39e-9a6e-5e82-8d70-e0febf387696" "4f314950-6034-5671-a352-4ef848f6bc04" "639e5567-8297-57ca-9070-4e50f26eafaf" "673f29a2-d05a-5977-b3d6-718f0de1e383" "75494ced-fa49-5903-8914-236fe0ac2c86" "ad281a49-01a1-54a2-8d0e-b50573e36bff" "b382bbda-24b9-5f77-abeb-3217fcbec693" 0 "7656ed5f-ec3f-5217-9573-e3aa3316fc2f" "1415a39e-9a6e-5e82-8d70-e0febf387696" "4f314950-6034-5671-a352-4ef848f6bc04" "639e5567-8297-57ca-9070-4e50f26eafaf" "673f29a2-d05a-5977-b3d6-718f0de1e383" "75494ced-fa49-5903-8914-236fe0ac2c86" "ad281a49-01a1-54a2-8d0e-b50573e36bff" "b382bbda-24b9-5f77-abeb-3217fcbec693" 1 1 ] |
| 35 | 23.17 ms |
SELECT MIN((CASE WHEN p0_.price_offer IS NOT NULL THEN p0_.price_offer ELSE p0_.price_sell END) * (CASE p0_.tax_type WHEN 1 THEN 1.21 WHEN 2 THEN 1.10 WHEN 3 THEN 1.04 WHEN 4 THEN 1.05 ELSE 1 END)) AS sclr_0, MAX((CASE WHEN p0_.price_offer IS NOT NULL THEN p0_.price_offer ELSE p0_.price_sell END) * (CASE p0_.tax_type WHEN 1 THEN 1.21 WHEN 2 THEN 1.10 WHEN 3 THEN 1.04 WHEN 4 THEN 1.05 ELSE 1 END)) AS sclr_1 FROM products p0_ LEFT JOIN products_rel_categories p2_ ON p0_.id = p2_.product_id LEFT JOIN products_categories p1_ ON p1_.id = p2_.category_id INNER JOIN products_brands p3_ ON p0_.brand_id = p3_.id WHERE p0_.show_only_in_pack = ? AND p1_.id IN (?, ?, ?, ?, ?, ?, ?, ?) AND p3_.enabled = ? AND p0_.status = ?
Parameters:
[ 0 "7656ed5f-ec3f-5217-9573-e3aa3316fc2f" "1415a39e-9a6e-5e82-8d70-e0febf387696" "4f314950-6034-5671-a352-4ef848f6bc04" "639e5567-8297-57ca-9070-4e50f26eafaf" "673f29a2-d05a-5977-b3d6-718f0de1e383" "75494ced-fa49-5903-8914-236fe0ac2c86" "ad281a49-01a1-54a2-8d0e-b50573e36bff" "b382bbda-24b9-5f77-abeb-3217fcbec693" 1 1 ] |
| 36 | 21.82 ms |
SELECT p0_.slug AS slug_0, p0_.id AS id_1, p0_.name AS name_2, p0_.slug AS slug_3 FROM products p1_ LEFT JOIN products_rel_categories p2_ ON p1_.id = p2_.product_id LEFT JOIN products_categories p0_ ON p0_.id = p2_.category_id INNER JOIN products_brands p3_ ON p1_.brand_id = p3_.id WHERE p1_.show_only_in_pack = ? AND p0_.id IN (?, ?, ?, ?, ?, ?, ?, ?) AND p3_.enabled = ? AND p1_.status = ? GROUP BY p0_.id ORDER BY p0_.name ASC
Parameters:
[ 0 "7656ed5f-ec3f-5217-9573-e3aa3316fc2f" "1415a39e-9a6e-5e82-8d70-e0febf387696" "4f314950-6034-5671-a352-4ef848f6bc04" "639e5567-8297-57ca-9070-4e50f26eafaf" "673f29a2-d05a-5977-b3d6-718f0de1e383" "75494ced-fa49-5903-8914-236fe0ac2c86" "ad281a49-01a1-54a2-8d0e-b50573e36bff" "b382bbda-24b9-5f77-abeb-3217fcbec693" 1 1 ] |
| 37 | 0.77 ms |
SELECT b0_.name AS name_0, b0_.link_to AS link_to_1, b0_.status AS status_2, b0_.created_at AS created_at_3, b0_.updated_at AS updated_at_4, b0_.id AS id_5 FROM banners b0_ INNER JOIN banner_location_position b1_ ON b0_.id = b1_.banner_id WHERE b0_.status = ? AND b1_.location = ? AND b1_.category_id = ? ORDER BY b1_.position ASC LIMIT 30
Parameters:
[ 2 2 "7656ed5f-ec3f-5217-9573-e3aa3316fc2f" ] |
| 38 | 0.27 ms |
SELECT count(1) AS sclr_0 FROM banners b0_ INNER JOIN banner_location_position b1_ ON b0_.id = b1_.banner_id WHERE b0_.status = ? AND b1_.location = ? AND b1_.category_id = ?
Parameters:
[ 2 2 "7656ed5f-ec3f-5217-9573-e3aa3316fc2f" ] |
| 39 | 0.39 ms |
SELECT b0_.name AS name_0, b0_.link_to AS link_to_1, b0_.status AS status_2, b0_.created_at AS created_at_3, b0_.updated_at AS updated_at_4, b0_.id AS id_5 FROM banners b0_ INNER JOIN banner_location_position b1_ ON b0_.id = b1_.banner_id WHERE b0_.status = ? AND b1_.location = ? ORDER BY b1_.position ASC LIMIT 30
Parameters:
[ 2 3 ] |
| 40 | 0.23 ms |
SELECT count(1) AS sclr_0 FROM banners b0_ INNER JOIN banner_location_position b1_ ON b0_.id = b1_.banner_id WHERE b0_.status = ? AND b1_.location = ?
Parameters:
[ 2 3 ] |
| 41 | 0.69 ms |
SELECT t0.name AS name_1, t0.slug AS slug_2, t0.position AS position_3, t0.enabled AS enabled_4, t0.number_id AS number_id_5, t0.is_virtual AS is_virtual_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.id AS id_9, t0.related_category_id AS related_category_id_10, t0.parent_category_id AS parent_category_id_11 FROM products_categories t0 INNER JOIN products_rel_categories ON t0.id = products_rel_categories.category_id WHERE products_rel_categories.product_id = ?
Parameters:
[
38402
]
|
| 42 | 0.20 ms |
SELECT t0.name AS name_1, t0.slug AS slug_2, t0.enabled AS enabled_3, t0.multiple AS multiple_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.id AS id_7 FROM products_features t0 WHERE t0.id = ?
Parameters:
[
"a6de82a2-6826-533f-a5dc-feed1d391dce"
]
|
| 43 | 0.19 ms |
SELECT t0.name AS name_1, t0.slug AS slug_2, t0.enabled AS enabled_3, t0.multiple AS multiple_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.id AS id_7 FROM products_features t0 WHERE t0.id = ?
Parameters:
[
"d0307b7d-df93-596a-ac0f-dfb601c2a201"
]
|
| 44 | 1.07 ms |
SELECT t0.position AS position_1, t0.is_main AS is_main_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.id AS id_5, t0.product_id AS product_id_6, t0.media_id AS media_id_7 FROM products_medias t0 WHERE t0.product_id = ?
Parameters:
[
38402
]
|
| 45 | 0.66 ms |
SELECT t0.content_type AS content_type_1, t0.filename AS filename_2, t0.file_extension AS file_extension_3, t0.path AS path_4, t0.md5 AS md5_5, t0.file_size AS file_size_6, t0.width AS width_7, t0.height AS height_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.id AS id_11, t0.media_watermark_id AS media_watermark_id_12 FROM media t0 WHERE t0.id = ?
Parameters:
[
"f6f0eb86-7126-4326-af24-e71ececbc838"
]
|
| 46 | 0.85 ms |
SELECT t0.content_type AS content_type_1, t0.filename AS filename_2, t0.file_extension AS file_extension_3, t0.path AS path_4, t0.md5 AS md5_5, t0.file_size AS file_size_6, t0.width AS width_7, t0.height AS height_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.id AS id_11, t12.content_type AS content_type_13, t12.filename AS filename_14, t12.file_extension AS file_extension_15, t12.path AS path_16, t12.md5 AS md5_17, t12.file_size AS file_size_18, t12.width AS width_19, t12.height AS height_20, t12.created_at AS created_at_21, t12.updated_at AS updated_at_22, t12.id AS id_23, t12.media_watermark_id AS media_watermark_id_24 FROM media_watermark t0 LEFT JOIN media t12 ON t12.media_watermark_id = t0.id WHERE t0.id = ?
Parameters:
[
"46ce555d-4879-4af0-a1e1-1ae76077cdf0"
]
|
| 47 | 0.24 ms |
SELECT t0.name AS name_1, t0.slug AS slug_2, t0.enabled AS enabled_3, t0.number_id AS number_id_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.id AS id_7 FROM products_brands t0 WHERE t0.id = ?
Parameters:
[
"f14941cb-732a-5eb2-9cd7-3a07e29fdd66"
]
|
| 48 | 0.86 ms |
SELECT t0.position AS position_1, t0.is_main AS is_main_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.id AS id_5, t0.brand_id AS brand_id_6, t0.media_id AS media_id_7 FROM brands_medias t0 WHERE t0.brand_id = ?
Parameters:
[
"f14941cb-732a-5eb2-9cd7-3a07e29fdd66"
]
|
| 49 | 0.25 ms |
SELECT t0.name AS name_1, t0.slug AS slug_2, t0.position AS position_3, t0.enabled AS enabled_4, t0.number_id AS number_id_5, t0.is_virtual AS is_virtual_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.id AS id_9, t0.related_category_id AS related_category_id_10, t0.parent_category_id AS parent_category_id_11 FROM products_categories t0 INNER JOIN products_rel_categories ON t0.id = products_rel_categories.category_id WHERE products_rel_categories.product_id = ?
Parameters:
[
38498
]
|
| 50 | 0.34 ms |
SELECT t0.position AS position_1, t0.is_main AS is_main_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.id AS id_5, t0.product_id AS product_id_6, t0.media_id AS media_id_7 FROM products_medias t0 WHERE t0.product_id = ?
Parameters:
[
38498
]
|
| 51 | 0.50 ms |
SELECT t0.content_type AS content_type_1, t0.filename AS filename_2, t0.file_extension AS file_extension_3, t0.path AS path_4, t0.md5 AS md5_5, t0.file_size AS file_size_6, t0.width AS width_7, t0.height AS height_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.id AS id_11, t0.media_watermark_id AS media_watermark_id_12 FROM media t0 WHERE t0.id = ?
Parameters:
[
"40e52555-0183-46dc-a8ed-cd68cc79516e"
]
|
| 52 | 0.66 ms |
SELECT t0.content_type AS content_type_1, t0.filename AS filename_2, t0.file_extension AS file_extension_3, t0.path AS path_4, t0.md5 AS md5_5, t0.file_size AS file_size_6, t0.width AS width_7, t0.height AS height_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.id AS id_11, t12.content_type AS content_type_13, t12.filename AS filename_14, t12.file_extension AS file_extension_15, t12.path AS path_16, t12.md5 AS md5_17, t12.file_size AS file_size_18, t12.width AS width_19, t12.height AS height_20, t12.created_at AS created_at_21, t12.updated_at AS updated_at_22, t12.id AS id_23, t12.media_watermark_id AS media_watermark_id_24 FROM media_watermark t0 LEFT JOIN media t12 ON t12.media_watermark_id = t0.id WHERE t0.id = ?
Parameters:
[
"2dbf1da2-6ab3-402e-bb5e-deb455a94bab"
]
|
| 53 | 0.24 ms |
SELECT t0.name AS name_1, t0.slug AS slug_2, t0.position AS position_3, t0.enabled AS enabled_4, t0.number_id AS number_id_5, t0.is_virtual AS is_virtual_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.id AS id_9, t0.related_category_id AS related_category_id_10, t0.parent_category_id AS parent_category_id_11 FROM products_categories t0 INNER JOIN products_rel_categories ON t0.id = products_rel_categories.category_id WHERE products_rel_categories.product_id = ?
Parameters:
[
38507
]
|
| 54 | 0.36 ms |
SELECT t0.position AS position_1, t0.is_main AS is_main_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.id AS id_5, t0.product_id AS product_id_6, t0.media_id AS media_id_7 FROM products_medias t0 WHERE t0.product_id = ?
Parameters:
[
38507
]
|
| 55 | 0.34 ms |
SELECT t0.content_type AS content_type_1, t0.filename AS filename_2, t0.file_extension AS file_extension_3, t0.path AS path_4, t0.md5 AS md5_5, t0.file_size AS file_size_6, t0.width AS width_7, t0.height AS height_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.id AS id_11, t0.media_watermark_id AS media_watermark_id_12 FROM media t0 WHERE t0.id = ?
Parameters:
[
"9a89c663-db63-4aff-a5dc-a99d707e24df"
]
|
| 56 | 0.61 ms |
SELECT t0.content_type AS content_type_1, t0.filename AS filename_2, t0.file_extension AS file_extension_3, t0.path AS path_4, t0.md5 AS md5_5, t0.file_size AS file_size_6, t0.width AS width_7, t0.height AS height_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.id AS id_11, t12.content_type AS content_type_13, t12.filename AS filename_14, t12.file_extension AS file_extension_15, t12.path AS path_16, t12.md5 AS md5_17, t12.file_size AS file_size_18, t12.width AS width_19, t12.height AS height_20, t12.created_at AS created_at_21, t12.updated_at AS updated_at_22, t12.id AS id_23, t12.media_watermark_id AS media_watermark_id_24 FROM media_watermark t0 LEFT JOIN media t12 ON t12.media_watermark_id = t0.id WHERE t0.id = ?
Parameters:
[
"8ceb403b-ba3b-4f66-8794-6f9fbb26eb8c"
]
|
| 57 | 0.25 ms |
SELECT t0.name AS name_1, t0.slug AS slug_2, t0.position AS position_3, t0.enabled AS enabled_4, t0.number_id AS number_id_5, t0.is_virtual AS is_virtual_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.id AS id_9, t0.related_category_id AS related_category_id_10, t0.parent_category_id AS parent_category_id_11 FROM products_categories t0 INNER JOIN products_rel_categories ON t0.id = products_rel_categories.category_id WHERE products_rel_categories.product_id = ?
Parameters:
[
38510
]
|
| 58 | 0.32 ms |
SELECT t0.position AS position_1, t0.is_main AS is_main_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.id AS id_5, t0.product_id AS product_id_6, t0.media_id AS media_id_7 FROM products_medias t0 WHERE t0.product_id = ?
Parameters:
[
38510
]
|
| 59 | 0.50 ms |
SELECT t0.content_type AS content_type_1, t0.filename AS filename_2, t0.file_extension AS file_extension_3, t0.path AS path_4, t0.md5 AS md5_5, t0.file_size AS file_size_6, t0.width AS width_7, t0.height AS height_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.id AS id_11, t0.media_watermark_id AS media_watermark_id_12 FROM media t0 WHERE t0.id = ?
Parameters:
[
"6e256bfc-fccf-4235-a71c-7371689a072a"
]
|
| 60 | 0.51 ms |
SELECT t0.content_type AS content_type_1, t0.filename AS filename_2, t0.file_extension AS file_extension_3, t0.path AS path_4, t0.md5 AS md5_5, t0.file_size AS file_size_6, t0.width AS width_7, t0.height AS height_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.id AS id_11, t12.content_type AS content_type_13, t12.filename AS filename_14, t12.file_extension AS file_extension_15, t12.path AS path_16, t12.md5 AS md5_17, t12.file_size AS file_size_18, t12.width AS width_19, t12.height AS height_20, t12.created_at AS created_at_21, t12.updated_at AS updated_at_22, t12.id AS id_23, t12.media_watermark_id AS media_watermark_id_24 FROM media_watermark t0 LEFT JOIN media t12 ON t12.media_watermark_id = t0.id WHERE t0.id = ?
Parameters:
[
"247dcbf3-be34-46a9-81a6-8d80dd41624b"
]
|
| 61 | 0.23 ms |
SELECT t0.name AS name_1, t0.slug AS slug_2, t0.position AS position_3, t0.enabled AS enabled_4, t0.number_id AS number_id_5, t0.is_virtual AS is_virtual_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.id AS id_9, t0.related_category_id AS related_category_id_10, t0.parent_category_id AS parent_category_id_11 FROM products_categories t0 INNER JOIN products_rel_categories ON t0.id = products_rel_categories.category_id WHERE products_rel_categories.product_id = ?
Parameters:
[
38511
]
|
| 62 | 0.34 ms |
SELECT t0.position AS position_1, t0.is_main AS is_main_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.id AS id_5, t0.product_id AS product_id_6, t0.media_id AS media_id_7 FROM products_medias t0 WHERE t0.product_id = ?
Parameters:
[
38511
]
|
| 63 | 0.44 ms |
SELECT t0.content_type AS content_type_1, t0.filename AS filename_2, t0.file_extension AS file_extension_3, t0.path AS path_4, t0.md5 AS md5_5, t0.file_size AS file_size_6, t0.width AS width_7, t0.height AS height_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.id AS id_11, t0.media_watermark_id AS media_watermark_id_12 FROM media t0 WHERE t0.id = ?
Parameters:
[
"1b696631-febf-4dad-adb7-596f864ccc73"
]
|
| 64 | 0.73 ms |
SELECT t0.content_type AS content_type_1, t0.filename AS filename_2, t0.file_extension AS file_extension_3, t0.path AS path_4, t0.md5 AS md5_5, t0.file_size AS file_size_6, t0.width AS width_7, t0.height AS height_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.id AS id_11, t12.content_type AS content_type_13, t12.filename AS filename_14, t12.file_extension AS file_extension_15, t12.path AS path_16, t12.md5 AS md5_17, t12.file_size AS file_size_18, t12.width AS width_19, t12.height AS height_20, t12.created_at AS created_at_21, t12.updated_at AS updated_at_22, t12.id AS id_23, t12.media_watermark_id AS media_watermark_id_24 FROM media_watermark t0 LEFT JOIN media t12 ON t12.media_watermark_id = t0.id WHERE t0.id = ?
Parameters:
[
"fb88df2b-0d1a-475d-810c-b421781bf4a9"
]
|
| 65 | 0.38 ms |
SELECT t0.name AS name_1, t0.slug AS slug_2, t0.position AS position_3, t0.enabled AS enabled_4, t0.number_id AS number_id_5, t0.is_virtual AS is_virtual_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.id AS id_9, t0.related_category_id AS related_category_id_10, t0.parent_category_id AS parent_category_id_11 FROM products_categories t0 INNER JOIN products_rel_categories ON t0.id = products_rel_categories.category_id WHERE products_rel_categories.product_id = ?
Parameters:
[
38722
]
|
| 66 | 0.48 ms |
SELECT t0.position AS position_1, t0.is_main AS is_main_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.id AS id_5, t0.product_id AS product_id_6, t0.media_id AS media_id_7 FROM products_medias t0 WHERE t0.product_id = ?
Parameters:
[
38722
]
|
| 67 | 0.45 ms |
SELECT t0.content_type AS content_type_1, t0.filename AS filename_2, t0.file_extension AS file_extension_3, t0.path AS path_4, t0.md5 AS md5_5, t0.file_size AS file_size_6, t0.width AS width_7, t0.height AS height_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.id AS id_11, t0.media_watermark_id AS media_watermark_id_12 FROM media t0 WHERE t0.id = ?
Parameters:
[
"8e77de73-ba80-4617-aea2-60ff9cf50d3b"
]
|
| 68 | 0.52 ms |
SELECT t0.content_type AS content_type_1, t0.filename AS filename_2, t0.file_extension AS file_extension_3, t0.path AS path_4, t0.md5 AS md5_5, t0.file_size AS file_size_6, t0.width AS width_7, t0.height AS height_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.id AS id_11, t12.content_type AS content_type_13, t12.filename AS filename_14, t12.file_extension AS file_extension_15, t12.path AS path_16, t12.md5 AS md5_17, t12.file_size AS file_size_18, t12.width AS width_19, t12.height AS height_20, t12.created_at AS created_at_21, t12.updated_at AS updated_at_22, t12.id AS id_23, t12.media_watermark_id AS media_watermark_id_24 FROM media_watermark t0 LEFT JOIN media t12 ON t12.media_watermark_id = t0.id WHERE t0.id = ?
Parameters:
[
"99fe7f6a-e981-41f1-8bd7-89c8aa987119"
]
|
| 69 | 0.50 ms |
SELECT t0.name AS name_1, t0.slug AS slug_2, t0.position AS position_3, t0.enabled AS enabled_4, t0.number_id AS number_id_5, t0.is_virtual AS is_virtual_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.id AS id_9, t0.related_category_id AS related_category_id_10, t0.parent_category_id AS parent_category_id_11 FROM products_categories t0 INNER JOIN products_rel_categories ON t0.id = products_rel_categories.category_id WHERE products_rel_categories.product_id = ?
Parameters:
[
38988
]
|
| 70 | 0.33 ms |
SELECT t0.position AS position_1, t0.is_main AS is_main_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.id AS id_5, t0.product_id AS product_id_6, t0.media_id AS media_id_7 FROM products_medias t0 WHERE t0.product_id = ?
Parameters:
[
38988
]
|
| 71 | 0.33 ms |
SELECT t0.content_type AS content_type_1, t0.filename AS filename_2, t0.file_extension AS file_extension_3, t0.path AS path_4, t0.md5 AS md5_5, t0.file_size AS file_size_6, t0.width AS width_7, t0.height AS height_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.id AS id_11, t0.media_watermark_id AS media_watermark_id_12 FROM media t0 WHERE t0.id = ?
Parameters:
[
"7224a938-25dc-4785-bcd7-2e8c178ad9ed"
]
|
| 72 | 0.52 ms |
SELECT t0.content_type AS content_type_1, t0.filename AS filename_2, t0.file_extension AS file_extension_3, t0.path AS path_4, t0.md5 AS md5_5, t0.file_size AS file_size_6, t0.width AS width_7, t0.height AS height_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.id AS id_11, t12.content_type AS content_type_13, t12.filename AS filename_14, t12.file_extension AS file_extension_15, t12.path AS path_16, t12.md5 AS md5_17, t12.file_size AS file_size_18, t12.width AS width_19, t12.height AS height_20, t12.created_at AS created_at_21, t12.updated_at AS updated_at_22, t12.id AS id_23, t12.media_watermark_id AS media_watermark_id_24 FROM media_watermark t0 LEFT JOIN media t12 ON t12.media_watermark_id = t0.id WHERE t0.id = ?
Parameters:
[
"16e5ea81-d8af-40a8-b971-91486cce473f"
]
|
| 73 | 0.49 ms |
SELECT t0.name AS name_1, t0.slug AS slug_2, t0.position AS position_3, t0.enabled AS enabled_4, t0.number_id AS number_id_5, t0.is_virtual AS is_virtual_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.id AS id_9, t0.related_category_id AS related_category_id_10, t0.parent_category_id AS parent_category_id_11 FROM products_categories t0 INNER JOIN products_rel_categories ON t0.id = products_rel_categories.category_id WHERE products_rel_categories.product_id = ?
Parameters:
[
40730
]
|
| 74 | 0.48 ms |
SELECT t0.position AS position_1, t0.is_main AS is_main_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.id AS id_5, t0.product_id AS product_id_6, t0.media_id AS media_id_7 FROM products_medias t0 WHERE t0.product_id = ?
Parameters:
[
40730
]
|
| 75 | 0.46 ms |
SELECT t0.content_type AS content_type_1, t0.filename AS filename_2, t0.file_extension AS file_extension_3, t0.path AS path_4, t0.md5 AS md5_5, t0.file_size AS file_size_6, t0.width AS width_7, t0.height AS height_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.id AS id_11, t0.media_watermark_id AS media_watermark_id_12 FROM media t0 WHERE t0.id = ?
Parameters:
[
"57e11754-8d19-4320-9a84-8468f167133d"
]
|
| 76 | 0.53 ms |
SELECT t0.content_type AS content_type_1, t0.filename AS filename_2, t0.file_extension AS file_extension_3, t0.path AS path_4, t0.md5 AS md5_5, t0.file_size AS file_size_6, t0.width AS width_7, t0.height AS height_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.id AS id_11, t12.content_type AS content_type_13, t12.filename AS filename_14, t12.file_extension AS file_extension_15, t12.path AS path_16, t12.md5 AS md5_17, t12.file_size AS file_size_18, t12.width AS width_19, t12.height AS height_20, t12.created_at AS created_at_21, t12.updated_at AS updated_at_22, t12.id AS id_23, t12.media_watermark_id AS media_watermark_id_24 FROM media_watermark t0 LEFT JOIN media t12 ON t12.media_watermark_id = t0.id WHERE t0.id = ?
Parameters:
[
"eb2764c2-a26b-49f5-82cf-008e948037b1"
]
|
| 77 | 0.22 ms |
SELECT t0.name AS name_1, t0.slug AS slug_2, t0.position AS position_3, t0.enabled AS enabled_4, t0.number_id AS number_id_5, t0.is_virtual AS is_virtual_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.id AS id_9, t0.related_category_id AS related_category_id_10, t0.parent_category_id AS parent_category_id_11 FROM products_categories t0 INNER JOIN products_rel_categories ON t0.id = products_rel_categories.category_id WHERE products_rel_categories.product_id = ?
Parameters:
[
40731
]
|
| 78 | 0.36 ms |
SELECT t0.position AS position_1, t0.is_main AS is_main_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.id AS id_5, t0.product_id AS product_id_6, t0.media_id AS media_id_7 FROM products_medias t0 WHERE t0.product_id = ?
Parameters:
[
40731
]
|
| 79 | 0.47 ms |
SELECT t0.content_type AS content_type_1, t0.filename AS filename_2, t0.file_extension AS file_extension_3, t0.path AS path_4, t0.md5 AS md5_5, t0.file_size AS file_size_6, t0.width AS width_7, t0.height AS height_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.id AS id_11, t0.media_watermark_id AS media_watermark_id_12 FROM media t0 WHERE t0.id = ?
Parameters:
[
"b8c354b2-2bed-4f0f-8898-6b48f10fd0c7"
]
|
| 80 | 0.67 ms |
SELECT t0.content_type AS content_type_1, t0.filename AS filename_2, t0.file_extension AS file_extension_3, t0.path AS path_4, t0.md5 AS md5_5, t0.file_size AS file_size_6, t0.width AS width_7, t0.height AS height_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.id AS id_11, t12.content_type AS content_type_13, t12.filename AS filename_14, t12.file_extension AS file_extension_15, t12.path AS path_16, t12.md5 AS md5_17, t12.file_size AS file_size_18, t12.width AS width_19, t12.height AS height_20, t12.created_at AS created_at_21, t12.updated_at AS updated_at_22, t12.id AS id_23, t12.media_watermark_id AS media_watermark_id_24 FROM media_watermark t0 LEFT JOIN media t12 ON t12.media_watermark_id = t0.id WHERE t0.id = ?
Parameters:
[
"cbd8ba8d-314e-487d-9576-e03793bd9d8a"
]
|
| 81 | 0.50 ms |
SELECT t0.name AS name_1, t0.slug AS slug_2, t0.position AS position_3, t0.enabled AS enabled_4, t0.number_id AS number_id_5, t0.is_virtual AS is_virtual_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.id AS id_9, t0.related_category_id AS related_category_id_10, t0.parent_category_id AS parent_category_id_11 FROM products_categories t0 INNER JOIN products_rel_categories ON t0.id = products_rel_categories.category_id WHERE products_rel_categories.product_id = ?
Parameters:
[
40894
]
|
| 82 | 0.49 ms |
SELECT t0.position AS position_1, t0.is_main AS is_main_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.id AS id_5, t0.product_id AS product_id_6, t0.media_id AS media_id_7 FROM products_medias t0 WHERE t0.product_id = ?
Parameters:
[
40894
]
|
| 83 | 0.35 ms |
SELECT t0.content_type AS content_type_1, t0.filename AS filename_2, t0.file_extension AS file_extension_3, t0.path AS path_4, t0.md5 AS md5_5, t0.file_size AS file_size_6, t0.width AS width_7, t0.height AS height_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.id AS id_11, t0.media_watermark_id AS media_watermark_id_12 FROM media t0 WHERE t0.id = ?
Parameters:
[
"7b1db36a-c2fb-4fc0-a3f2-54333bdb3c1c"
]
|
| 84 | 0.52 ms |
SELECT t0.content_type AS content_type_1, t0.filename AS filename_2, t0.file_extension AS file_extension_3, t0.path AS path_4, t0.md5 AS md5_5, t0.file_size AS file_size_6, t0.width AS width_7, t0.height AS height_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.id AS id_11, t12.content_type AS content_type_13, t12.filename AS filename_14, t12.file_extension AS file_extension_15, t12.path AS path_16, t12.md5 AS md5_17, t12.file_size AS file_size_18, t12.width AS width_19, t12.height AS height_20, t12.created_at AS created_at_21, t12.updated_at AS updated_at_22, t12.id AS id_23, t12.media_watermark_id AS media_watermark_id_24 FROM media_watermark t0 LEFT JOIN media t12 ON t12.media_watermark_id = t0.id WHERE t0.id = ?
Parameters:
[
"3545f225-5fa9-473a-b0cc-1f279e65169b"
]
|
| 85 | 0.23 ms |
SELECT t0.name AS name_1, t0.slug AS slug_2, t0.position AS position_3, t0.enabled AS enabled_4, t0.number_id AS number_id_5, t0.is_virtual AS is_virtual_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.id AS id_9, t0.related_category_id AS related_category_id_10, t0.parent_category_id AS parent_category_id_11 FROM products_categories t0 INNER JOIN products_rel_categories ON t0.id = products_rel_categories.category_id WHERE products_rel_categories.product_id = ?
Parameters:
[
40992
]
|
| 86 | 0.46 ms |
SELECT t0.position AS position_1, t0.is_main AS is_main_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.id AS id_5, t0.product_id AS product_id_6, t0.media_id AS media_id_7 FROM products_medias t0 WHERE t0.product_id = ?
Parameters:
[
40992
]
|
| 87 | 0.35 ms |
SELECT t0.content_type AS content_type_1, t0.filename AS filename_2, t0.file_extension AS file_extension_3, t0.path AS path_4, t0.md5 AS md5_5, t0.file_size AS file_size_6, t0.width AS width_7, t0.height AS height_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.id AS id_11, t0.media_watermark_id AS media_watermark_id_12 FROM media t0 WHERE t0.id = ?
Parameters:
[
"5ea0a3bd-98b5-4246-8e90-3f9ff31fac71"
]
|
| 88 | 0.54 ms |
SELECT t0.content_type AS content_type_1, t0.filename AS filename_2, t0.file_extension AS file_extension_3, t0.path AS path_4, t0.md5 AS md5_5, t0.file_size AS file_size_6, t0.width AS width_7, t0.height AS height_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.id AS id_11, t12.content_type AS content_type_13, t12.filename AS filename_14, t12.file_extension AS file_extension_15, t12.path AS path_16, t12.md5 AS md5_17, t12.file_size AS file_size_18, t12.width AS width_19, t12.height AS height_20, t12.created_at AS created_at_21, t12.updated_at AS updated_at_22, t12.id AS id_23, t12.media_watermark_id AS media_watermark_id_24 FROM media_watermark t0 LEFT JOIN media t12 ON t12.media_watermark_id = t0.id WHERE t0.id = ?
Parameters:
[
"128479a3-d590-4911-ad8d-a702584d9de5"
]
|
| 89 | 0.23 ms |
SELECT t0.name AS name_1, t0.slug AS slug_2, t0.position AS position_3, t0.enabled AS enabled_4, t0.number_id AS number_id_5, t0.is_virtual AS is_virtual_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.id AS id_9, t0.related_category_id AS related_category_id_10, t0.parent_category_id AS parent_category_id_11 FROM products_categories t0 INNER JOIN products_rel_categories ON t0.id = products_rel_categories.category_id WHERE products_rel_categories.product_id = ?
Parameters:
[
40993
]
|
| 90 | 0.34 ms |
SELECT t0.position AS position_1, t0.is_main AS is_main_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.id AS id_5, t0.product_id AS product_id_6, t0.media_id AS media_id_7 FROM products_medias t0 WHERE t0.product_id = ?
Parameters:
[
40993
]
|
| 91 | 0.48 ms |
SELECT t0.content_type AS content_type_1, t0.filename AS filename_2, t0.file_extension AS file_extension_3, t0.path AS path_4, t0.md5 AS md5_5, t0.file_size AS file_size_6, t0.width AS width_7, t0.height AS height_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.id AS id_11, t0.media_watermark_id AS media_watermark_id_12 FROM media t0 WHERE t0.id = ?
Parameters:
[
"c360cc0b-8604-4c3b-9f9f-81ccd029427c"
]
|
| 92 | 0.25 ms |
SELECT t0.content_type AS content_type_1, t0.filename AS filename_2, t0.file_extension AS file_extension_3, t0.path AS path_4, t0.md5 AS md5_5, t0.file_size AS file_size_6, t0.width AS width_7, t0.height AS height_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.id AS id_11, t12.content_type AS content_type_13, t12.filename AS filename_14, t12.file_extension AS file_extension_15, t12.path AS path_16, t12.md5 AS md5_17, t12.file_size AS file_size_18, t12.width AS width_19, t12.height AS height_20, t12.created_at AS created_at_21, t12.updated_at AS updated_at_22, t12.id AS id_23, t12.media_watermark_id AS media_watermark_id_24 FROM media_watermark t0 LEFT JOIN media t12 ON t12.media_watermark_id = t0.id WHERE t0.id = ?
Parameters:
[
"46c14194-3618-4c46-bfca-3df546f5f900"
]
|
| 93 | 0.22 ms |
SELECT t0.name AS name_1, t0.slug AS slug_2, t0.position AS position_3, t0.enabled AS enabled_4, t0.number_id AS number_id_5, t0.is_virtual AS is_virtual_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.id AS id_9, t0.related_category_id AS related_category_id_10, t0.parent_category_id AS parent_category_id_11 FROM products_categories t0 INNER JOIN products_rel_categories ON t0.id = products_rel_categories.category_id WHERE products_rel_categories.product_id = ?
Parameters:
[
40994
]
|
| 94 | 0.32 ms |
SELECT t0.position AS position_1, t0.is_main AS is_main_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.id AS id_5, t0.product_id AS product_id_6, t0.media_id AS media_id_7 FROM products_medias t0 WHERE t0.product_id = ?
Parameters:
[
40994
]
|
| 95 | 0.32 ms |
SELECT t0.content_type AS content_type_1, t0.filename AS filename_2, t0.file_extension AS file_extension_3, t0.path AS path_4, t0.md5 AS md5_5, t0.file_size AS file_size_6, t0.width AS width_7, t0.height AS height_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.id AS id_11, t0.media_watermark_id AS media_watermark_id_12 FROM media t0 WHERE t0.id = ?
Parameters:
[
"172dcb33-c633-43da-91eb-118729d677a7"
]
|
| 96 | 0.48 ms |
SELECT t0.content_type AS content_type_1, t0.filename AS filename_2, t0.file_extension AS file_extension_3, t0.path AS path_4, t0.md5 AS md5_5, t0.file_size AS file_size_6, t0.width AS width_7, t0.height AS height_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.id AS id_11, t12.content_type AS content_type_13, t12.filename AS filename_14, t12.file_extension AS file_extension_15, t12.path AS path_16, t12.md5 AS md5_17, t12.file_size AS file_size_18, t12.width AS width_19, t12.height AS height_20, t12.created_at AS created_at_21, t12.updated_at AS updated_at_22, t12.id AS id_23, t12.media_watermark_id AS media_watermark_id_24 FROM media_watermark t0 LEFT JOIN media t12 ON t12.media_watermark_id = t0.id WHERE t0.id = ?
Parameters:
[
"fd85e853-af73-4330-98e0-28f83a8a6606"
]
|
| 97 | 0.20 ms |
SELECT t0.name AS name_1, t0.slug AS slug_2, t0.position AS position_3, t0.enabled AS enabled_4, t0.number_id AS number_id_5, t0.is_virtual AS is_virtual_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.id AS id_9, t0.related_category_id AS related_category_id_10, t0.parent_category_id AS parent_category_id_11 FROM products_categories t0 INNER JOIN products_rel_categories ON t0.id = products_rel_categories.category_id WHERE products_rel_categories.product_id = ?
Parameters:
[
40995
]
|
| 98 | 0.34 ms |
SELECT t0.position AS position_1, t0.is_main AS is_main_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.id AS id_5, t0.product_id AS product_id_6, t0.media_id AS media_id_7 FROM products_medias t0 WHERE t0.product_id = ?
Parameters:
[
40995
]
|
| 99 | 0.32 ms |
SELECT t0.content_type AS content_type_1, t0.filename AS filename_2, t0.file_extension AS file_extension_3, t0.path AS path_4, t0.md5 AS md5_5, t0.file_size AS file_size_6, t0.width AS width_7, t0.height AS height_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.id AS id_11, t0.media_watermark_id AS media_watermark_id_12 FROM media t0 WHERE t0.id = ?
Parameters:
[
"e77a5c57-76d1-45f4-88c3-2cdef18dfe29"
]
|
| 100 | 0.47 ms |
SELECT t0.content_type AS content_type_1, t0.filename AS filename_2, t0.file_extension AS file_extension_3, t0.path AS path_4, t0.md5 AS md5_5, t0.file_size AS file_size_6, t0.width AS width_7, t0.height AS height_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.id AS id_11, t12.content_type AS content_type_13, t12.filename AS filename_14, t12.file_extension AS file_extension_15, t12.path AS path_16, t12.md5 AS md5_17, t12.file_size AS file_size_18, t12.width AS width_19, t12.height AS height_20, t12.created_at AS created_at_21, t12.updated_at AS updated_at_22, t12.id AS id_23, t12.media_watermark_id AS media_watermark_id_24 FROM media_watermark t0 LEFT JOIN media t12 ON t12.media_watermark_id = t0.id WHERE t0.id = ?
Parameters:
[
"d87a8bcc-b27e-4fa0-8b43-d963729e0113"
]
|
| 101 | 0.22 ms |
SELECT t0.name AS name_1, t0.slug AS slug_2, t0.position AS position_3, t0.enabled AS enabled_4, t0.number_id AS number_id_5, t0.is_virtual AS is_virtual_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.id AS id_9, t0.related_category_id AS related_category_id_10, t0.parent_category_id AS parent_category_id_11 FROM products_categories t0 INNER JOIN products_rel_categories ON t0.id = products_rel_categories.category_id WHERE products_rel_categories.product_id = ?
Parameters:
[
40996
]
|
| 102 | 0.35 ms |
SELECT t0.position AS position_1, t0.is_main AS is_main_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.id AS id_5, t0.product_id AS product_id_6, t0.media_id AS media_id_7 FROM products_medias t0 WHERE t0.product_id = ?
Parameters:
[
40996
]
|
| 103 | 0.32 ms |
SELECT t0.content_type AS content_type_1, t0.filename AS filename_2, t0.file_extension AS file_extension_3, t0.path AS path_4, t0.md5 AS md5_5, t0.file_size AS file_size_6, t0.width AS width_7, t0.height AS height_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.id AS id_11, t0.media_watermark_id AS media_watermark_id_12 FROM media t0 WHERE t0.id = ?
Parameters:
[
"8408f15d-4eb5-4cc5-8014-77a6a2acf312"
]
|
| 104 | 0.38 ms |
SELECT t0.content_type AS content_type_1, t0.filename AS filename_2, t0.file_extension AS file_extension_3, t0.path AS path_4, t0.md5 AS md5_5, t0.file_size AS file_size_6, t0.width AS width_7, t0.height AS height_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.id AS id_11, t12.content_type AS content_type_13, t12.filename AS filename_14, t12.file_extension AS file_extension_15, t12.path AS path_16, t12.md5 AS md5_17, t12.file_size AS file_size_18, t12.width AS width_19, t12.height AS height_20, t12.created_at AS created_at_21, t12.updated_at AS updated_at_22, t12.id AS id_23, t12.media_watermark_id AS media_watermark_id_24 FROM media_watermark t0 LEFT JOIN media t12 ON t12.media_watermark_id = t0.id WHERE t0.id = ?
Parameters:
[
"cba0af43-7f7a-49d5-b411-b053ae575c0a"
]
|
| 105 | 0.22 ms |
SELECT t0.name AS name_1, t0.slug AS slug_2, t0.position AS position_3, t0.enabled AS enabled_4, t0.number_id AS number_id_5, t0.is_virtual AS is_virtual_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.id AS id_9, t0.related_category_id AS related_category_id_10, t0.parent_category_id AS parent_category_id_11 FROM products_categories t0 INNER JOIN products_rel_categories ON t0.id = products_rel_categories.category_id WHERE products_rel_categories.product_id = ?
Parameters:
[
40997
]
|
| 106 | 0.36 ms |
SELECT t0.position AS position_1, t0.is_main AS is_main_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.id AS id_5, t0.product_id AS product_id_6, t0.media_id AS media_id_7 FROM products_medias t0 WHERE t0.product_id = ?
Parameters:
[
40997
]
|
| 107 | 0.34 ms |
SELECT t0.content_type AS content_type_1, t0.filename AS filename_2, t0.file_extension AS file_extension_3, t0.path AS path_4, t0.md5 AS md5_5, t0.file_size AS file_size_6, t0.width AS width_7, t0.height AS height_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.id AS id_11, t0.media_watermark_id AS media_watermark_id_12 FROM media t0 WHERE t0.id = ?
Parameters:
[
"fdf9e88e-6636-4a10-b207-1e4a065f2b0a"
]
|
| 108 | 0.65 ms |
SELECT t0.content_type AS content_type_1, t0.filename AS filename_2, t0.file_extension AS file_extension_3, t0.path AS path_4, t0.md5 AS md5_5, t0.file_size AS file_size_6, t0.width AS width_7, t0.height AS height_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.id AS id_11, t12.content_type AS content_type_13, t12.filename AS filename_14, t12.file_extension AS file_extension_15, t12.path AS path_16, t12.md5 AS md5_17, t12.file_size AS file_size_18, t12.width AS width_19, t12.height AS height_20, t12.created_at AS created_at_21, t12.updated_at AS updated_at_22, t12.id AS id_23, t12.media_watermark_id AS media_watermark_id_24 FROM media_watermark t0 LEFT JOIN media t12 ON t12.media_watermark_id = t0.id WHERE t0.id = ?
Parameters:
[
"f9467198-102f-4459-8a12-10dd9cb94996"
]
|
| 109 | 0.23 ms |
SELECT t0.name AS name_1, t0.slug AS slug_2, t0.position AS position_3, t0.enabled AS enabled_4, t0.number_id AS number_id_5, t0.is_virtual AS is_virtual_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.id AS id_9, t0.related_category_id AS related_category_id_10, t0.parent_category_id AS parent_category_id_11 FROM products_categories t0 INNER JOIN products_rel_categories ON t0.id = products_rel_categories.category_id WHERE products_rel_categories.product_id = ?
Parameters:
[
40998
]
|
| 110 | 0.35 ms |
SELECT t0.position AS position_1, t0.is_main AS is_main_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.id AS id_5, t0.product_id AS product_id_6, t0.media_id AS media_id_7 FROM products_medias t0 WHERE t0.product_id = ?
Parameters:
[
40998
]
|
| 111 | 0.32 ms |
SELECT t0.content_type AS content_type_1, t0.filename AS filename_2, t0.file_extension AS file_extension_3, t0.path AS path_4, t0.md5 AS md5_5, t0.file_size AS file_size_6, t0.width AS width_7, t0.height AS height_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.id AS id_11, t0.media_watermark_id AS media_watermark_id_12 FROM media t0 WHERE t0.id = ?
Parameters:
[
"9c6804d4-9a75-41f5-9c31-408edf65c364"
]
|
| 112 | 0.52 ms |
SELECT t0.content_type AS content_type_1, t0.filename AS filename_2, t0.file_extension AS file_extension_3, t0.path AS path_4, t0.md5 AS md5_5, t0.file_size AS file_size_6, t0.width AS width_7, t0.height AS height_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.id AS id_11, t12.content_type AS content_type_13, t12.filename AS filename_14, t12.file_extension AS file_extension_15, t12.path AS path_16, t12.md5 AS md5_17, t12.file_size AS file_size_18, t12.width AS width_19, t12.height AS height_20, t12.created_at AS created_at_21, t12.updated_at AS updated_at_22, t12.id AS id_23, t12.media_watermark_id AS media_watermark_id_24 FROM media_watermark t0 LEFT JOIN media t12 ON t12.media_watermark_id = t0.id WHERE t0.id = ?
Parameters:
[
"52a1827d-0cc5-4707-8325-fa0c005c39e8"
]
|
| 113 | 0.22 ms |
SELECT t0.name AS name_1, t0.slug AS slug_2, t0.position AS position_3, t0.enabled AS enabled_4, t0.number_id AS number_id_5, t0.is_virtual AS is_virtual_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.id AS id_9, t0.related_category_id AS related_category_id_10, t0.parent_category_id AS parent_category_id_11 FROM products_categories t0 INNER JOIN products_rel_categories ON t0.id = products_rel_categories.category_id WHERE products_rel_categories.product_id = ?
Parameters:
[
40999
]
|
| 114 | 0.34 ms |
SELECT t0.position AS position_1, t0.is_main AS is_main_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.id AS id_5, t0.product_id AS product_id_6, t0.media_id AS media_id_7 FROM products_medias t0 WHERE t0.product_id = ?
Parameters:
[
40999
]
|
| 115 | 0.32 ms |
SELECT t0.content_type AS content_type_1, t0.filename AS filename_2, t0.file_extension AS file_extension_3, t0.path AS path_4, t0.md5 AS md5_5, t0.file_size AS file_size_6, t0.width AS width_7, t0.height AS height_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.id AS id_11, t0.media_watermark_id AS media_watermark_id_12 FROM media t0 WHERE t0.id = ?
Parameters:
[
"ecc34674-61bf-497d-9227-3e2ed25fdb31"
]
|
| 116 | 0.48 ms |
SELECT t0.content_type AS content_type_1, t0.filename AS filename_2, t0.file_extension AS file_extension_3, t0.path AS path_4, t0.md5 AS md5_5, t0.file_size AS file_size_6, t0.width AS width_7, t0.height AS height_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.id AS id_11, t12.content_type AS content_type_13, t12.filename AS filename_14, t12.file_extension AS file_extension_15, t12.path AS path_16, t12.md5 AS md5_17, t12.file_size AS file_size_18, t12.width AS width_19, t12.height AS height_20, t12.created_at AS created_at_21, t12.updated_at AS updated_at_22, t12.id AS id_23, t12.media_watermark_id AS media_watermark_id_24 FROM media_watermark t0 LEFT JOIN media t12 ON t12.media_watermark_id = t0.id WHERE t0.id = ?
Parameters:
[
"df98b194-96ac-4035-8e8b-8084578dc2e1"
]
|
| 117 | 0.22 ms |
SELECT t0.name AS name_1, t0.slug AS slug_2, t0.position AS position_3, t0.enabled AS enabled_4, t0.number_id AS number_id_5, t0.is_virtual AS is_virtual_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.id AS id_9, t0.related_category_id AS related_category_id_10, t0.parent_category_id AS parent_category_id_11 FROM products_categories t0 INNER JOIN products_rel_categories ON t0.id = products_rel_categories.category_id WHERE products_rel_categories.product_id = ?
Parameters:
[
41000
]
|
| 118 | 0.36 ms |
SELECT t0.position AS position_1, t0.is_main AS is_main_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.id AS id_5, t0.product_id AS product_id_6, t0.media_id AS media_id_7 FROM products_medias t0 WHERE t0.product_id = ?
Parameters:
[
41000
]
|
| 119 | 0.34 ms |
SELECT t0.content_type AS content_type_1, t0.filename AS filename_2, t0.file_extension AS file_extension_3, t0.path AS path_4, t0.md5 AS md5_5, t0.file_size AS file_size_6, t0.width AS width_7, t0.height AS height_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.id AS id_11, t0.media_watermark_id AS media_watermark_id_12 FROM media t0 WHERE t0.id = ?
Parameters:
[
"a6590fb1-782e-4032-b904-d3e0b8667e62"
]
|
| 120 | 0.23 ms |
SELECT t0.content_type AS content_type_1, t0.filename AS filename_2, t0.file_extension AS file_extension_3, t0.path AS path_4, t0.md5 AS md5_5, t0.file_size AS file_size_6, t0.width AS width_7, t0.height AS height_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.id AS id_11, t12.content_type AS content_type_13, t12.filename AS filename_14, t12.file_extension AS file_extension_15, t12.path AS path_16, t12.md5 AS md5_17, t12.file_size AS file_size_18, t12.width AS width_19, t12.height AS height_20, t12.created_at AS created_at_21, t12.updated_at AS updated_at_22, t12.id AS id_23, t12.media_watermark_id AS media_watermark_id_24 FROM media_watermark t0 LEFT JOIN media t12 ON t12.media_watermark_id = t0.id WHERE t0.id = ?
Parameters:
[
"2dbb88c5-066f-4f8d-a773-a22235495193"
]
|
| 121 | 0.22 ms |
SELECT t0.name AS name_1, t0.slug AS slug_2, t0.position AS position_3, t0.enabled AS enabled_4, t0.number_id AS number_id_5, t0.is_virtual AS is_virtual_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.id AS id_9, t0.related_category_id AS related_category_id_10, t0.parent_category_id AS parent_category_id_11 FROM products_categories t0 INNER JOIN products_rel_categories ON t0.id = products_rel_categories.category_id WHERE products_rel_categories.product_id = ?
Parameters:
[
41001
]
|
| 122 | 0.33 ms |
SELECT t0.position AS position_1, t0.is_main AS is_main_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.id AS id_5, t0.product_id AS product_id_6, t0.media_id AS media_id_7 FROM products_medias t0 WHERE t0.product_id = ?
Parameters:
[
41001
]
|
| 123 | 0.45 ms |
SELECT t0.content_type AS content_type_1, t0.filename AS filename_2, t0.file_extension AS file_extension_3, t0.path AS path_4, t0.md5 AS md5_5, t0.file_size AS file_size_6, t0.width AS width_7, t0.height AS height_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.id AS id_11, t0.media_watermark_id AS media_watermark_id_12 FROM media t0 WHERE t0.id = ?
Parameters:
[
"70bbab53-f29f-4dca-85f4-f0fb98cb8445"
]
|
| 124 | 0.64 ms |
SELECT b0_.name AS name_0, b0_.link_to AS link_to_1, b0_.status AS status_2, b0_.created_at AS created_at_3, b0_.updated_at AS updated_at_4, b0_.id AS id_5 FROM banners b0_ INNER JOIN banner_location_position b1_ ON b0_.id = b1_.banner_id WHERE b0_.status = ? AND b1_.location = ? AND b1_.brand_id = ? ORDER BY b1_.position ASC LIMIT 30
Parameters:
[ 2 7 "f14941cb-732a-5eb2-9cd7-3a07e29fdd66" ] |
| 125 | 0.26 ms |
SELECT count(1) AS sclr_0 FROM banners b0_ INNER JOIN banner_location_position b1_ ON b0_.id = b1_.banner_id WHERE b0_.status = ? AND b1_.location = ? AND b1_.brand_id = ?
Parameters:
[ 2 7 "f14941cb-732a-5eb2-9cd7-3a07e29fdd66" ] |
| 126 | 0.28 ms |
SELECT b0_.name AS name_0, b0_.link_to AS link_to_1, b0_.status AS status_2, b0_.created_at AS created_at_3, b0_.updated_at AS updated_at_4, b0_.id AS id_5 FROM banners b0_ INNER JOIN banner_location_position b1_ ON b0_.id = b1_.banner_id WHERE b0_.status = ? AND b1_.location = ? AND b1_.category_id = ? AND b1_.brand_id = ? ORDER BY b1_.position ASC LIMIT 30
Parameters:
[ 2 6 "7656ed5f-ec3f-5217-9573-e3aa3316fc2f" "f14941cb-732a-5eb2-9cd7-3a07e29fdd66" ] |
| 127 | 0.28 ms |
SELECT count(1) AS sclr_0 FROM banners b0_ INNER JOIN banner_location_position b1_ ON b0_.id = b1_.banner_id WHERE b0_.status = ? AND b1_.location = ? AND b1_.category_id = ? AND b1_.brand_id = ?
Parameters:
[ 2 6 "7656ed5f-ec3f-5217-9573-e3aa3316fc2f" "f14941cb-732a-5eb2-9cd7-3a07e29fdd66" ] |
| 128 | 0.24 ms |
SELECT t0.name AS name_1, t0.slug AS slug_2, t0.position AS position_3, t0.enabled AS enabled_4, t0.number_id AS number_id_5, t0.is_virtual AS is_virtual_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.id AS id_9, t0.related_category_id AS related_category_id_10, t0.parent_category_id AS parent_category_id_11 FROM products_categories t0 WHERE t0.id = ?
Parameters:
[
"c3e382d3-ef0b-57a3-85f5-752574c7af52"
]
|
| 129 | 0.67 ms |
SELECT t0.keyname AS keyname_1, t0.value AS value_2, t0.label AS label_3, t0.description AS description_4, t0.id AS id_5 FROM configuration t0 WHERE t0.keyname = ? LIMIT 1
Parameters:
[
"info_header_contact_1"
]
|
| 130 | 0.19 ms |
SELECT t0.keyname AS keyname_1, t0.value AS value_2, t0.label AS label_3, t0.description AS description_4, t0.id AS id_5 FROM configuration t0 WHERE t0.keyname = ? LIMIT 1
Parameters:
[
"info_header_contact_2"
]
|
| 131 | 0.29 ms |
SELECT t0.keyname AS keyname_1, t0.value AS value_2, t0.label AS label_3, t0.description AS description_4, t0.id AS id_5 FROM configuration t0 WHERE t0.keyname = ? LIMIT 1
Parameters:
[
"info_opening_hours_1"
]
|
| 132 | 0.17 ms |
SELECT t0.keyname AS keyname_1, t0.value AS value_2, t0.label AS label_3, t0.description AS description_4, t0.id AS id_5 FROM configuration t0 WHERE t0.keyname = ? LIMIT 1
Parameters:
[
"info_opening_hours_2"
]
|
| 133 | 0.40 ms |
SELECT p0_.name AS name_0, p0_.url AS url_1, p0_.status AS status_2, p0_.date_start AS date_start_3, p0_.date_end AS date_end_4, p0_.created_at AS created_at_5, p0_.updated_at AS updated_at_6, p0_.id AS id_7 FROM promotions p0_ WHERE p0_.status = ? ORDER BY p0_.date_start ASC LIMIT 30
Parameters:
[
1
]
|
| 134 | 0.20 ms |
SELECT count(1) AS sclr_0 FROM promotions p0_ WHERE p0_.status = ?
Parameters:
[
1
]
|
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
| legacy | doctrine.dbal.legacy_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 |
|---|---|
| Fotoboom\Product\Domain\Product | 20 |
| Fotoboom\Product\Domain\Media | 20 |
| Fotoboom\Media\Domain\Media | 20 |
| Fotoboom\Media\Domain\MediaWatermark | 19 |
| Fotoboom\Product\Domain\FeatureValue | 12 |
| Fotoboom\Product\Domain\Category | 9 |
| Fotoboom\Configuration\Domain\Configuration | 4 |
| Fotoboom\Product\Domain\Feature | 2 |
| Fotoboom\Product\Domain\Brand | 1 |
| Fotoboom\Product\Domain\BrandMedia | 1 |