Query Metrics
140
Database Queries
28
Different statements
428.49 ms
Query time
0
Invalid entities
106
Managed entities
Queries
default connection
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.83 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:
[
"transporte-1390"
]
|
| 2 | 0.42 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:
[
"244a8ced-178f-571e-9db8-3e27a93eef3e"
]
|
| 3 | 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.parent_category_id = ?
Parameters:
[
"31fa19fc-9b42-5e8f-a392-0f24c488b989"
]
|
| 4 | 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 WHERE t0.parent_category_id = ?
Parameters:
[
"3bfea7d5-db79-56ba-94d2-c49e2f3218c7"
]
|
| 5 | 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 WHERE t0.parent_category_id = ?
Parameters:
[
"464dec73-9dff-58e5-bafd-c3d2cb20f283"
]
|
| 6 | 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 WHERE t0.parent_category_id = ?
Parameters:
[
"5c07e3fa-8edc-5a0b-8ff9-3eeb46786b90"
]
|
| 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:
[
"7ffb5b3c-8354-5dd3-b1f1-b1be26c8213d"
]
|
| 8 | 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:
[
"9286d476-a56a-5c33-80a4-56457d63b87c"
]
|
| 9 | 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:
[
"996694e4-0bdc-54e2-942f-912f4b342a6e"
]
|
| 10 | 0.13 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:
[
"c00cc284-aad9-5599-9d22-887e842eb4aa"
]
|
| 11 | 82.99 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 320
Parameters:
[ 0 "244a8ced-178f-571e-9db8-3e27a93eef3e" "31fa19fc-9b42-5e8f-a392-0f24c488b989" "3bfea7d5-db79-56ba-94d2-c49e2f3218c7" "464dec73-9dff-58e5-bafd-c3d2cb20f283" "5c07e3fa-8edc-5a0b-8ff9-3eeb46786b90" "7ffb5b3c-8354-5dd3-b1f1-b1be26c8213d" "9286d476-a56a-5c33-80a4-56457d63b87c" "996694e4-0bdc-54e2-942f-912f4b342a6e" "c00cc284-aad9-5599-9d22-887e842eb4aa" 1 1 ] |
| 12 | 0.72 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:
[
66671
]
|
| 13 | 0.25 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:
[
66672
]
|
| 14 | 0.19 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:
[
66673
]
|
| 15 | 0.18 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:
[
66674
]
|
| 16 | 0.61 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:
[
32809
]
|
| 17 | 0.20 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:
[
32810
]
|
| 18 | 0.20 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:
[
32811
]
|
| 19 | 0.49 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:
[
49547
]
|
| 20 | 0.25 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:
[
49548
]
|
| 21 | 0.21 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:
[
49549
]
|
| 22 | 0.22 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:
[
49550
]
|
| 23 | 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:
[
49551
]
|
| 24 | 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:
[
49552
]
|
| 25 | 0.52 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:
[
63208
]
|
| 26 | 0.51 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:
[
80611
]
|
| 27 | 0.46 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:
[
74563
]
|
| 28 | 0.46 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:
[
76513
]
|
| 29 | 0.20 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:
[
76514
]
|
| 30 | 0.20 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:
[
76515
]
|
| 31 | 0.19 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:
[
74566
]
|
| 32 | 13.38 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 "244a8ced-178f-571e-9db8-3e27a93eef3e" "31fa19fc-9b42-5e8f-a392-0f24c488b989" "3bfea7d5-db79-56ba-94d2-c49e2f3218c7" "464dec73-9dff-58e5-bafd-c3d2cb20f283" "5c07e3fa-8edc-5a0b-8ff9-3eeb46786b90" "7ffb5b3c-8354-5dd3-b1f1-b1be26c8213d" "9286d476-a56a-5c33-80a4-56457d63b87c" "996694e4-0bdc-54e2-942f-912f4b342a6e" "c00cc284-aad9-5599-9d22-887e842eb4aa" 1 1 ] |
| 33 | 9.73 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 "244a8ced-178f-571e-9db8-3e27a93eef3e" "31fa19fc-9b42-5e8f-a392-0f24c488b989" "3bfea7d5-db79-56ba-94d2-c49e2f3218c7" "464dec73-9dff-58e5-bafd-c3d2cb20f283" "5c07e3fa-8edc-5a0b-8ff9-3eeb46786b90" "7ffb5b3c-8354-5dd3-b1f1-b1be26c8213d" "9286d476-a56a-5c33-80a4-56457d63b87c" "996694e4-0bdc-54e2-942f-912f4b342a6e" "c00cc284-aad9-5599-9d22-887e842eb4aa" 1 1 ] |
| 34 | 7.81 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 "244a8ced-178f-571e-9db8-3e27a93eef3e" "31fa19fc-9b42-5e8f-a392-0f24c488b989" "3bfea7d5-db79-56ba-94d2-c49e2f3218c7" "464dec73-9dff-58e5-bafd-c3d2cb20f283" "5c07e3fa-8edc-5a0b-8ff9-3eeb46786b90" "7ffb5b3c-8354-5dd3-b1f1-b1be26c8213d" "9286d476-a56a-5c33-80a4-56457d63b87c" "996694e4-0bdc-54e2-942f-912f4b342a6e" "c00cc284-aad9-5599-9d22-887e842eb4aa" 1 1 ] |
| 35 | 254.57 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:
[ "244a8ced-178f-571e-9db8-3e27a93eef3e" "31fa19fc-9b42-5e8f-a392-0f24c488b989" "3bfea7d5-db79-56ba-94d2-c49e2f3218c7" "464dec73-9dff-58e5-bafd-c3d2cb20f283" "5c07e3fa-8edc-5a0b-8ff9-3eeb46786b90" "7ffb5b3c-8354-5dd3-b1f1-b1be26c8213d" "9286d476-a56a-5c33-80a4-56457d63b87c" "996694e4-0bdc-54e2-942f-912f4b342a6e" "c00cc284-aad9-5599-9d22-887e842eb4aa" 0 "244a8ced-178f-571e-9db8-3e27a93eef3e" "31fa19fc-9b42-5e8f-a392-0f24c488b989" "3bfea7d5-db79-56ba-94d2-c49e2f3218c7" "464dec73-9dff-58e5-bafd-c3d2cb20f283" "5c07e3fa-8edc-5a0b-8ff9-3eeb46786b90" "7ffb5b3c-8354-5dd3-b1f1-b1be26c8213d" "9286d476-a56a-5c33-80a4-56457d63b87c" "996694e4-0bdc-54e2-942f-912f4b342a6e" "c00cc284-aad9-5599-9d22-887e842eb4aa" 1 1 ] |
| 36 | 8.37 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 "244a8ced-178f-571e-9db8-3e27a93eef3e" "31fa19fc-9b42-5e8f-a392-0f24c488b989" "3bfea7d5-db79-56ba-94d2-c49e2f3218c7" "464dec73-9dff-58e5-bafd-c3d2cb20f283" "5c07e3fa-8edc-5a0b-8ff9-3eeb46786b90" "7ffb5b3c-8354-5dd3-b1f1-b1be26c8213d" "9286d476-a56a-5c33-80a4-56457d63b87c" "996694e4-0bdc-54e2-942f-912f4b342a6e" "c00cc284-aad9-5599-9d22-887e842eb4aa" 1 1 ] |
| 37 | 7.50 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 "244a8ced-178f-571e-9db8-3e27a93eef3e" "31fa19fc-9b42-5e8f-a392-0f24c488b989" "3bfea7d5-db79-56ba-94d2-c49e2f3218c7" "464dec73-9dff-58e5-bafd-c3d2cb20f283" "5c07e3fa-8edc-5a0b-8ff9-3eeb46786b90" "7ffb5b3c-8354-5dd3-b1f1-b1be26c8213d" "9286d476-a56a-5c33-80a4-56457d63b87c" "996694e4-0bdc-54e2-942f-912f4b342a6e" "c00cc284-aad9-5599-9d22-887e842eb4aa" 1 1 ] |
| 38 | 0.56 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 "244a8ced-178f-571e-9db8-3e27a93eef3e" ] |
| 39 | 0.18 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 "244a8ced-178f-571e-9db8-3e27a93eef3e" ] |
| 40 | 0.32 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 ] |
| 41 | 0.16 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 ] |
| 42 | 0.47 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:
[
66671
]
|
| 43 | 0.16 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"
]
|
| 44 | 0.51 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:
[
66671
]
|
| 45 | 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:
[
"d71edb5d-3a95-48f7-9723-76666d5933ba"
]
|
| 46 | 0.59 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:
[
"1449658f-e5f1-4c71-8902-7a53afdea913"
]
|
| 47 | 0.17 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:
[
"97e00e72-bb36-57df-adf7-67920132291b"
]
|
| 48 | 0.21 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:
[
"97e00e72-bb36-57df-adf7-67920132291b"
]
|
| 49 | 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:
[
66672
]
|
| 50 | 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:
[
66672
]
|
| 51 | 0.31 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:
[
"a094ab33-2987-4945-aada-3cdfdaa5c012"
]
|
| 52 | 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:
[
"faab75ce-bd89-430a-b1ea-174b2f632074"
]
|
| 53 | 0.28 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:
[
66673
]
|
| 54 | 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:
[
66673
]
|
| 55 | 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:
[
"f99f3ea5-0d33-4f31-b829-923b35f97452"
]
|
| 56 | 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:
[
"104e6892-2061-4061-9706-c2ccb1e47cca"
]
|
| 57 | 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:
[
66674
]
|
| 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:
[
66674
]
|
| 59 | 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:
[
"13459d6d-3070-4db4-9f66-780e577f5302"
]
|
| 60 | 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:
[
"c87ee3ca-a42b-4e00-bea3-c79395d0f6d4"
]
|
| 61 | 0.51 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:
[
32809
]
|
| 62 | 0.16 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"
]
|
| 63 | 0.45 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:
[
32809
]
|
| 64 | 0.31 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:
[
"37e97a70-50ae-442b-ad20-c3ec9b8b602f"
]
|
| 65 | 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:
[
"dc3360e1-99b3-460e-955a-752323ccd08f"
]
|
| 66 | 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:
[
32810
]
|
| 67 | 0.29 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:
[
32810
]
|
| 68 | 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:
[
32811
]
|
| 69 | 0.31 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:
[
32811
]
|
| 70 | 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:
[
49547
]
|
| 71 | 0.45 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:
[
49547
]
|
| 72 | 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:
[
"050667ea-639d-425f-aac4-07981e1d18bd"
]
|
| 73 | 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:
[
"0e6db914-0327-43ec-900a-440fd37b9a04"
]
|
| 74 | 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:
[
49548
]
|
| 75 | 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:
[
49548
]
|
| 76 | 0.30 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:
[
"db599442-250e-4a9a-98d5-f4b75c7dd404"
]
|
| 77 | 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, 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:
[
"dc636677-ff77-4645-b87d-d085e2135fc6"
]
|
| 78 | 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:
[
49549
]
|
| 79 | 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:
[
49549
]
|
| 80 | 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:
[
"0ede553e-7981-450c-ab9c-23aa014474a1"
]
|
| 81 | 0.40 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:
[
"83a46312-b41c-4acc-b5f3-de47466bbeee"
]
|
| 82 | 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:
[
49550
]
|
| 83 | 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:
[
49550
]
|
| 84 | 0.31 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:
[
"8b0ec1dd-05ba-40a5-b046-06f05ee57814"
]
|
| 85 | 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:
[
"c245a99e-20c9-4151-a5df-48751087e395"
]
|
| 86 | 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:
[
49551
]
|
| 87 | 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:
[
49551
]
|
| 88 | 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:
[
"f0ff1667-fda1-4dad-9eb9-3d40721bf4a6"
]
|
| 89 | 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:
[
"3bb91a37-5a59-49e8-8a64-0cf6e7abc53a"
]
|
| 90 | 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:
[
49552
]
|
| 91 | 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:
[
49552
]
|
| 92 | 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:
[
"d62b2f83-61d5-4a68-b0d1-6842f8d33b40"
]
|
| 93 | 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:
[
"ae18c805-3eb1-4ab7-9131-b987f97db5e8"
]
|
| 94 | 0.68 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:
[
63208
]
|
| 95 | 0.47 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:
[
63208
]
|
| 96 | 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:
[
"7842353a-d9eb-48b0-847b-fe1569bdead7"
]
|
| 97 | 0.63 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:
[
"25e623b1-5cbd-43ed-af92-ec399344a885"
]
|
| 98 | 0.36 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:
[
80611
]
|
| 99 | 0.43 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:
[
80611
]
|
| 100 | 0.30 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:
[
"ad153237-bcba-4d6e-82de-6e0ec5b83276"
]
|
| 101 | 0.39 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:
[
"d4fb5e5e-878b-4d96-8ab9-5121d098a794"
]
|
| 102 | 0.18 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:
[
"266e2918-aa32-52d5-bab0-14002d4a8daf"
]
|
| 103 | 0.17 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:
[
"266e2918-aa32-52d5-bab0-14002d4a8daf"
]
|
| 104 | 0.52 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:
[
74563
]
|
| 105 | 0.45 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:
[
74563
]
|
| 106 | 0.31 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:
[
"333ff969-78f6-466d-9d16-8a6e1b514974"
]
|
| 107 | 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:
[
"806fe8fd-d6b4-435e-bc97-d768d910901c"
]
|
| 108 | 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:
[
76513
]
|
| 109 | 0.45 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:
[
76513
]
|
| 110 | 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:
[
"1c3b9912-9763-4174-b4f4-973c3a26bd31"
]
|
| 111 | 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:
[
"cbe59d3a-f4e3-410f-9879-e71b5b83eba2"
]
|
| 112 | 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:
[
76514
]
|
| 113 | 0.31 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:
[
76514
]
|
| 114 | 0.30 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:
[
"60a6fbec-25dc-428e-a647-ff8fa0157621"
]
|
| 115 | 0.41 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:
[
"801980f3-58f6-4a36-9427-8b0e3c833bfa"
]
|
| 116 | 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:
[
76515
]
|
| 117 | 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:
[
76515
]
|
| 118 | 0.31 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:
[
"f44d63f0-4608-4654-9238-401c0e78dc69"
]
|
| 119 | 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, 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:
[
"c88a0232-1be2-4f5f-967d-653bb1addbdc"
]
|
| 120 | 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:
[
74566
]
|
| 121 | 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:
[
74566
]
|
| 122 | 0.31 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:
[
"bb5e1bb2-bfe2-407e-91ad-c007242d51b5"
]
|
| 123 | 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:
[
"234ce44e-2be5-4990-975f-cb4e5f9249cd"
]
|
| 124 | 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:
[
"370919e7-f496-4557-83b3-08a256eb2d1c"
]
|
| 125 | 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:
[
"0a6fbb75-fbc3-44c6-bed0-9a87af1e22cf"
]
|
| 126 | 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 = ? AND b1_.brand_id = ? ORDER BY b1_.position ASC LIMIT 30
Parameters:
[ 2 7 "97e00e72-bb36-57df-adf7-67920132291b" ] |
| 127 | 0.20 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 "97e00e72-bb36-57df-adf7-67920132291b" ] |
| 128 | 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 "244a8ced-178f-571e-9db8-3e27a93eef3e" "97e00e72-bb36-57df-adf7-67920132291b" ] |
| 129 | 0.22 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 "244a8ced-178f-571e-9db8-3e27a93eef3e" "97e00e72-bb36-57df-adf7-67920132291b" ] |
| 130 | 0.25 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 "266e2918-aa32-52d5-bab0-14002d4a8daf" ] |
| 131 | 0.20 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 "266e2918-aa32-52d5-bab0-14002d4a8daf" ] |
| 132 | 0.23 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 "244a8ced-178f-571e-9db8-3e27a93eef3e" "266e2918-aa32-52d5-bab0-14002d4a8daf" ] |
| 133 | 0.21 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 "244a8ced-178f-571e-9db8-3e27a93eef3e" "266e2918-aa32-52d5-bab0-14002d4a8daf" ] |
| 134 | 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.id = ?
Parameters:
[
"c3e382d3-ef0b-57a3-85f5-752574c7af52"
]
|
| 135 | 0.25 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"
]
|
| 136 | 0.15 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"
]
|
| 137 | 0.14 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"
]
|
| 138 | 0.14 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"
]
|
| 139 | 0.21 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
]
|
| 140 | 0.14 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 | 18 |
| Fotoboom\Product\Domain\Category | 10 |
| Fotoboom\Product\Domain\FeatureValue | 8 |
| Fotoboom\Configuration\Domain\Configuration | 4 |
| Fotoboom\Product\Domain\Brand | 2 |
| Fotoboom\Product\Domain\Feature | 2 |
| Fotoboom\Product\Domain\BrandMedia | 2 |