Query Metrics
139
Database Queries
28
Different statements
2375.23 ms
Query time
0
Invalid entities
109
Managed entities
Queries
default connection
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.94 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:
[
"objetivos-1215"
]
|
| 2 | 0.58 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:
[
"33e7c218-861e-50a8-be04-ae53d3267a7e"
]
|
| 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:
[
"41d3cdf8-19ce-53c1-9cf1-7e4faa613ce1"
]
|
| 4 | 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 WHERE t0.parent_category_id = ?
Parameters:
[
"43fef828-3c2d-5d9c-91a0-076f9bb8d0f0"
]
|
| 5 | 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:
[
"77e36751-298c-5cc3-a682-98581433c171"
]
|
| 6 | 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 WHERE t0.parent_category_id = ?
Parameters:
[
"799156f5-abcb-5598-8bf6-05a29abc06cc"
]
|
| 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:
[
"8df87149-54af-5e04-bac3-49121394c29f"
]
|
| 8 | 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:
[
"91cbad28-2703-5cea-999e-379efe956c9a"
]
|
| 9 | 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 WHERE t0.parent_category_id = ?
Parameters:
[
"ad2cf2d1-3648-5738-85cf-4548439f67a2"
]
|
| 10 | 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 WHERE t0.parent_category_id = ?
Parameters:
[
"c85ca2d1-5e08-5404-b108-6d8b48bdb66f"
]
|
| 11 | 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:
[
"e3d971d6-b235-59bb-ad9c-763cbc20fa1c"
]
|
| 12 | 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:
[
"f88e0e15-a475-51ee-aff3-075675c5bda1"
]
|
| 13 | 207.27 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 4020
Parameters:
[ 0 "33e7c218-861e-50a8-be04-ae53d3267a7e" "41d3cdf8-19ce-53c1-9cf1-7e4faa613ce1" "43fef828-3c2d-5d9c-91a0-076f9bb8d0f0" "77e36751-298c-5cc3-a682-98581433c171" "799156f5-abcb-5598-8bf6-05a29abc06cc" "8df87149-54af-5e04-bac3-49121394c29f" "91cbad28-2703-5cea-999e-379efe956c9a" "ad2cf2d1-3648-5738-85cf-4548439f67a2" "c85ca2d1-5e08-5404-b108-6d8b48bdb66f" "e3d971d6-b235-59bb-ad9c-763cbc20fa1c" "f88e0e15-a475-51ee-aff3-075675c5bda1" 1 1 ] |
| 14 | 0.82 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:
[
83474
]
|
| 15 | 0.37 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:
[
83475
]
|
| 16 | 0.43 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:
[
83523
]
|
| 17 | 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:
[
83524
]
|
| 18 | 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:
[
83525
]
|
| 19 | 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:
[
83526
]
|
| 20 | 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:
[
83545
]
|
| 21 | 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:
[
86187
]
|
| 22 | 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:
[
86446
]
|
| 23 | 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:
[
87139
]
|
| 24 | 0.53 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:
[
87646
]
|
| 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:
[
87647
]
|
| 26 | 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:
[
87942
]
|
| 27 | 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:
[
88525
]
|
| 28 | 0.55 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:
[
53362
]
|
| 29 | 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:
[
53363
]
|
| 30 | 0.53 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:
[
10276
]
|
| 31 | 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:
[
10280
]
|
| 32 | 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:
[
10284
]
|
| 33 | 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:
[
11937
]
|
| 34 | 43.46 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 "33e7c218-861e-50a8-be04-ae53d3267a7e" "41d3cdf8-19ce-53c1-9cf1-7e4faa613ce1" "43fef828-3c2d-5d9c-91a0-076f9bb8d0f0" "77e36751-298c-5cc3-a682-98581433c171" "799156f5-abcb-5598-8bf6-05a29abc06cc" "8df87149-54af-5e04-bac3-49121394c29f" "91cbad28-2703-5cea-999e-379efe956c9a" "ad2cf2d1-3648-5738-85cf-4548439f67a2" "c85ca2d1-5e08-5404-b108-6d8b48bdb66f" "e3d971d6-b235-59bb-ad9c-763cbc20fa1c" "f88e0e15-a475-51ee-aff3-075675c5bda1" 1 1 ] |
| 35 | 24.07 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 "33e7c218-861e-50a8-be04-ae53d3267a7e" "41d3cdf8-19ce-53c1-9cf1-7e4faa613ce1" "43fef828-3c2d-5d9c-91a0-076f9bb8d0f0" "77e36751-298c-5cc3-a682-98581433c171" "799156f5-abcb-5598-8bf6-05a29abc06cc" "8df87149-54af-5e04-bac3-49121394c29f" "91cbad28-2703-5cea-999e-379efe956c9a" "ad2cf2d1-3648-5738-85cf-4548439f67a2" "c85ca2d1-5e08-5404-b108-6d8b48bdb66f" "e3d971d6-b235-59bb-ad9c-763cbc20fa1c" "f88e0e15-a475-51ee-aff3-075675c5bda1" 1 1 ] |
| 36 | 17.93 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 "33e7c218-861e-50a8-be04-ae53d3267a7e" "41d3cdf8-19ce-53c1-9cf1-7e4faa613ce1" "43fef828-3c2d-5d9c-91a0-076f9bb8d0f0" "77e36751-298c-5cc3-a682-98581433c171" "799156f5-abcb-5598-8bf6-05a29abc06cc" "8df87149-54af-5e04-bac3-49121394c29f" "91cbad28-2703-5cea-999e-379efe956c9a" "ad2cf2d1-3648-5738-85cf-4548439f67a2" "c85ca2d1-5e08-5404-b108-6d8b48bdb66f" "e3d971d6-b235-59bb-ad9c-763cbc20fa1c" "f88e0e15-a475-51ee-aff3-075675c5bda1" 1 1 ] |
| 37 | 1952.23 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:
[ "33e7c218-861e-50a8-be04-ae53d3267a7e" "41d3cdf8-19ce-53c1-9cf1-7e4faa613ce1" "43fef828-3c2d-5d9c-91a0-076f9bb8d0f0" "77e36751-298c-5cc3-a682-98581433c171" "799156f5-abcb-5598-8bf6-05a29abc06cc" "8df87149-54af-5e04-bac3-49121394c29f" "91cbad28-2703-5cea-999e-379efe956c9a" "ad2cf2d1-3648-5738-85cf-4548439f67a2" "c85ca2d1-5e08-5404-b108-6d8b48bdb66f" "e3d971d6-b235-59bb-ad9c-763cbc20fa1c" "f88e0e15-a475-51ee-aff3-075675c5bda1" 0 "33e7c218-861e-50a8-be04-ae53d3267a7e" "41d3cdf8-19ce-53c1-9cf1-7e4faa613ce1" "43fef828-3c2d-5d9c-91a0-076f9bb8d0f0" "77e36751-298c-5cc3-a682-98581433c171" "799156f5-abcb-5598-8bf6-05a29abc06cc" "8df87149-54af-5e04-bac3-49121394c29f" "91cbad28-2703-5cea-999e-379efe956c9a" "ad2cf2d1-3648-5738-85cf-4548439f67a2" "c85ca2d1-5e08-5404-b108-6d8b48bdb66f" "e3d971d6-b235-59bb-ad9c-763cbc20fa1c" "f88e0e15-a475-51ee-aff3-075675c5bda1" 1 1 ] |
| 38 | 41.99 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 "33e7c218-861e-50a8-be04-ae53d3267a7e" "41d3cdf8-19ce-53c1-9cf1-7e4faa613ce1" "43fef828-3c2d-5d9c-91a0-076f9bb8d0f0" "77e36751-298c-5cc3-a682-98581433c171" "799156f5-abcb-5598-8bf6-05a29abc06cc" "8df87149-54af-5e04-bac3-49121394c29f" "91cbad28-2703-5cea-999e-379efe956c9a" "ad2cf2d1-3648-5738-85cf-4548439f67a2" "c85ca2d1-5e08-5404-b108-6d8b48bdb66f" "e3d971d6-b235-59bb-ad9c-763cbc20fa1c" "f88e0e15-a475-51ee-aff3-075675c5bda1" 1 1 ] |
| 39 | 34.65 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 "33e7c218-861e-50a8-be04-ae53d3267a7e" "41d3cdf8-19ce-53c1-9cf1-7e4faa613ce1" "43fef828-3c2d-5d9c-91a0-076f9bb8d0f0" "77e36751-298c-5cc3-a682-98581433c171" "799156f5-abcb-5598-8bf6-05a29abc06cc" "8df87149-54af-5e04-bac3-49121394c29f" "91cbad28-2703-5cea-999e-379efe956c9a" "ad2cf2d1-3648-5738-85cf-4548439f67a2" "c85ca2d1-5e08-5404-b108-6d8b48bdb66f" "e3d971d6-b235-59bb-ad9c-763cbc20fa1c" "f88e0e15-a475-51ee-aff3-075675c5bda1" 1 1 ] |
| 40 | 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 "33e7c218-861e-50a8-be04-ae53d3267a7e" ] |
| 41 | 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_.category_id = ?
Parameters:
[ 2 2 "33e7c218-861e-50a8-be04-ae53d3267a7e" ] |
| 42 | 0.40 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 ] |
| 43 | 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 = ?
Parameters:
[ 2 3 ] |
| 44 | 0.58 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:
[
83474
]
|
| 45 | 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:
[
"a6de82a2-6826-533f-a5dc-feed1d391dce"
]
|
| 46 | 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"
]
|
| 47 | 0.67 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:
[
83474
]
|
| 48 | 0.43 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:
[
"676129df-85f1-4ed7-9d4d-e01769a257ee"
]
|
| 49 | 0.75 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:
[
"98a4b1da-63ff-4a8b-a7c5-b0e69a1413ce"
]
|
| 50 | 0.20 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:
[
"33cae703-f2e4-56c8-a05d-9d81a16f1908"
]
|
| 51 | 0.26 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:
[
"33cae703-f2e4-56c8-a05d-9d81a16f1908"
]
|
| 52 | 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:
[
83475
]
|
| 53 | 0.37 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:
[
83475
]
|
| 54 | 0.36 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:
[
"cbb68d56-c973-472b-98a9-d681af5a9b7c"
]
|
| 55 | 0.58 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:
[
"adceefdd-9b66-423b-9e4e-654d2e646210"
]
|
| 56 | 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 INNER JOIN products_rel_categories ON t0.id = products_rel_categories.category_id WHERE products_rel_categories.product_id = ?
Parameters:
[
83523
]
|
| 57 | 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:
[
83523
]
|
| 58 | 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:
[
"14b8ec5d-863b-4e52-8d22-69c1bca18adc"
]
|
| 59 | 0.57 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:
[
"2e2d2b0d-ae91-4ed1-949d-9335055141bf"
]
|
| 60 | 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:
[
83524
]
|
| 61 | 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:
[
83524
]
|
| 62 | 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:
[
"339ae1c3-4ff3-4558-9cbe-299c5f2bbaae"
]
|
| 63 | 0.56 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:
[
"c48c72c1-f760-47bd-9990-9d0bd877f756"
]
|
| 64 | 0.35 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:
[
83525
]
|
| 65 | 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:
[
83525
]
|
| 66 | 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:
[
"dd4c95b3-5d51-4ed9-80e1-288292f7ae9b"
]
|
| 67 | 0.68 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:
[
"cfd4dd89-0c6d-48d0-b16b-33e3ab8f788b"
]
|
| 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:
[
83526
]
|
| 69 | 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:
[
83526
]
|
| 70 | 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:
[
"2abbcc9e-2e66-40ca-9be6-255fa00cc319"
]
|
| 71 | 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:
[
"23a16762-a83b-40af-be55-0c90a616b486"
]
|
| 72 | 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:
[
83545
]
|
| 73 | 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:
[
83545
]
|
| 74 | 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:
[
"f5c2863b-4bc0-4d40-9e77-67d470768d8b"
]
|
| 75 | 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:
[
"4d443e37-d9cf-404d-bc7e-2da234e12492"
]
|
| 76 | 0.54 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:
[
86187
]
|
| 77 | 0.50 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:
[
86187
]
|
| 78 | 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:
[
"1ae74b69-faf9-410a-b25a-2b2bb61e581e"
]
|
| 79 | 0.55 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:
[
"7e4dd66c-013d-4a08-bfaf-2f055cc52232"
]
|
| 80 | 0.59 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:
[
86446
]
|
| 81 | 0.50 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:
[
86446
]
|
| 82 | 0.36 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:
[
"7da88fa7-a7a7-49e6-b995-9969ec93cf3d"
]
|
| 83 | 0.55 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:
[
"e59a7c5c-0e2a-42f3-a5a6-03b5127129ad"
]
|
| 84 | 0.55 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:
[
87139
]
|
| 85 | 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:
[
87139
]
|
| 86 | 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:
[
"441988e9-be01-47aa-882e-a4e7755f3252"
]
|
| 87 | 0.55 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:
[
"32798af9-f0b3-49a7-b1ba-df315743fa7a"
]
|
| 88 | 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:
[
87646
]
|
| 89 | 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:
[
87646
]
|
| 90 | 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:
[
"61d72346-f2cc-4036-bb27-76505402c095"
]
|
| 91 | 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:
[
"b136f22d-f153-4c46-bfb8-bdf928935749"
]
|
| 92 | 0.27 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:
[
87647
]
|
| 93 | 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:
[
87647
]
|
| 94 | 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:
[
"9ba678cd-fa22-4548-85da-ba389f87b276"
]
|
| 95 | 0.55 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:
[
"055a5330-5067-4b65-8694-3ce9da4c391b"
]
|
| 96 | 0.56 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:
[
87942
]
|
| 97 | 0.52 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:
[
87942
]
|
| 98 | 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:
[
"b9d67ad4-9915-4dcd-a847-3808f7670c42"
]
|
| 99 | 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:
[
"e1654507-a33b-410e-9d6b-6ec7cbc04e0e"
]
|
| 100 | 0.62 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:
[
88525
]
|
| 101 | 0.56 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:
[
88525
]
|
| 102 | 0.42 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:
[
"2387d2bb-b7ad-491f-beeb-a516b8ab6e63"
]
|
| 103 | 0.60 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:
[
"9ae1ede0-febc-4135-b650-cccd760f4b08"
]
|
| 104 | 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:
[
53362
]
|
| 105 | 0.37 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:
[
53362
]
|
| 106 | 0.36 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:
[
"9f1fbe8f-a3f6-41a2-a9ef-9996c37c76d2"
]
|
| 107 | 0.62 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:
[
"fa62e198-fd39-47ec-9f50-29a7647a1d2f"
]
|
| 108 | 0.32 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:
[
53363
]
|
| 109 | 0.37 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:
[
53363
]
|
| 110 | 0.36 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:
[
"2ec036d5-bf2e-42d7-b7ad-7a97350cc7b6"
]
|
| 111 | 0.57 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:
[
"fcf0d381-5d92-434b-8456-f8a7185e0bc3"
]
|
| 112 | 0.54 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:
[
10276
]
|
| 113 | 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:
[
10276
]
|
| 114 | 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:
[
"8e400222-8c3f-4aca-bfb1-32fe961e9280"
]
|
| 115 | 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:
[
"088e93ae-2ce1-4bc3-a121-894a329fad30"
]
|
| 116 | 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:
[
10280
]
|
| 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:
[
10280
]
|
| 118 | 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:
[
"3928a5f4-f0fc-4b65-ab11-b5a4f8bcbe1a"
]
|
| 119 | 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:
[
"8b4549bf-6df4-478d-a7d3-8f3c5baf5fa2"
]
|
| 120 | 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:
[
10284
]
|
| 121 | 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:
[
10284
]
|
| 122 | 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:
[
"9a52efb6-c57d-4196-b17a-9646c7c46604"
]
|
| 123 | 0.57 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:
[
"50d607f5-6bc4-4b87-9280-9361ea636369"
]
|
| 124 | 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:
[
11937
]
|
| 125 | 0.52 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:
[
11937
]
|
| 126 | 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:
[
"b185a4fe-2561-4369-830b-68a0f00cb2db"
]
|
| 127 | 0.58 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:
[
"7ad6c99a-3844-4592-9d3b-725449270a77"
]
|
| 128 | 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:
[
"e1c69175-6d65-4503-85f0-a67037e6d524"
]
|
| 129 | 0.50 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 "33cae703-f2e4-56c8-a05d-9d81a16f1908" ] |
| 130 | 0.25 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 "33cae703-f2e4-56c8-a05d-9d81a16f1908" ] |
| 131 | 0.29 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 "33e7c218-861e-50a8-be04-ae53d3267a7e" "33cae703-f2e4-56c8-a05d-9d81a16f1908" ] |
| 132 | 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_.category_id = ? AND b1_.brand_id = ?
Parameters:
[ 2 6 "33e7c218-861e-50a8-be04-ae53d3267a7e" "33cae703-f2e4-56c8-a05d-9d81a16f1908" ] |
| 133 | 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.id = ?
Parameters:
[
"c3e382d3-ef0b-57a3-85f5-752574c7af52"
]
|
| 134 | 0.35 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"
]
|
| 135 | 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"
]
|
| 136 | 0.18 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"
]
|
| 137 | 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_opening_hours_2"
]
|
| 138 | 0.34 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
]
|
| 139 | 0.19 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\Media\Domain\Media | 21 |
| Fotoboom\Product\Domain\Product | 20 |
| Fotoboom\Product\Domain\Media | 20 |
| Fotoboom\Media\Domain\MediaWatermark | 20 |
| Fotoboom\Product\Domain\Category | 12 |
| Fotoboom\Product\Domain\FeatureValue | 8 |
| Fotoboom\Configuration\Domain\Configuration | 4 |
| Fotoboom\Product\Domain\Feature | 2 |
| Fotoboom\Product\Domain\Brand | 1 |
| Fotoboom\Product\Domain\BrandMedia | 1 |