Query Metrics

138 Database Queries
28 Different statements
310.63 ms Query time
0 Invalid entities
102 Managed entities

Queries

Group similar statements

default connection

# Time Info
1 1.06 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:
[
  "realizacion-1645"
]
2 0.60 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:
[
  "bc91fc74-b932-54df-881b-a6a99c9bd6ba"
]
3 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 WHERE t0.parent_category_id = ?
Parameters:
[
  "23bc4adb-be85-5a87-9f4a-be57cd3d3916"
]
4 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 WHERE t0.parent_category_id = ?
Parameters:
[
  "32c857c6-3f98-50c6-8238-6d2aa9c8f942"
]
5 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 WHERE t0.parent_category_id = ?
Parameters:
[
  "770a67e7-30bd-5adb-baeb-5189ead1368d"
]
6 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:
[
  "ac4df730-a789-58bd-a208-eb60a6643d97"
]
7 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:
[
  "aeb2e7fd-2b8e-5eb7-8ad8-a977eb362e6f"
]
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:
[
  "e9ceb4fe-cd6b-58de-96e0-b8369e824809"
]
9 53.76 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 1560
Parameters:
[
  0
  "bc91fc74-b932-54df-881b-a6a99c9bd6ba"
  "23bc4adb-be85-5a87-9f4a-be57cd3d3916"
  "32c857c6-3f98-50c6-8238-6d2aa9c8f942"
  "770a67e7-30bd-5adb-baeb-5189ead1368d"
  "ac4df730-a789-58bd-a208-eb60a6643d97"
  "aeb2e7fd-2b8e-5eb7-8ad8-a977eb362e6f"
  "e9ceb4fe-cd6b-58de-96e0-b8369e824809"
  1
  1
]
10 0.86 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:
[
  73279
]
11 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:
[
  73278
]
12 0.35 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:
[
  73276
]
13 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:
[
  73277
]
14 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:
[
  72788
]
15 0.30 ms
SELECT t0.name AS name_1, t0.enabled AS enabled_2, t0.slug AS slug_3, t0.position AS position_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.id AS id_7, t0.feature_id AS feature_id_8 FROM products_feature_values t0 INNER JOIN products_rel_feature_values ON t0.id = products_rel_feature_values.feature_value_id WHERE products_rel_feature_values.product_id = ?
Parameters:
[
  72787
]
16 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:
[
  72789
]
17 0.30 ms
SELECT t0.name AS name_1, t0.enabled AS enabled_2, t0.slug AS slug_3, t0.position AS position_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.id AS id_7, t0.feature_id AS feature_id_8 FROM products_feature_values t0 INNER JOIN products_rel_feature_values ON t0.id = products_rel_feature_values.feature_value_id WHERE products_rel_feature_values.product_id = ?
Parameters:
[
  73275
]
18 0.31 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:
[
  73274
]
19 0.31 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:
[
  73272
]
20 0.31 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:
[
  73273
]
21 0.33 ms
SELECT t0.name AS name_1, t0.enabled AS enabled_2, t0.slug AS slug_3, t0.position AS position_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.id AS id_7, t0.feature_id AS feature_id_8 FROM products_feature_values t0 INNER JOIN products_rel_feature_values ON t0.id = products_rel_feature_values.feature_value_id WHERE products_rel_feature_values.product_id = ?
Parameters:
[
  73269
]
22 0.31 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:
[
  73270
]
23 0.34 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:
[
  73271
]
24 0.31 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:
[
  73268
]
25 0.31 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:
[
  73267
]
26 0.29 ms
SELECT t0.name AS name_1, t0.enabled AS enabled_2, t0.slug AS slug_3, t0.position AS position_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.id AS id_7, t0.feature_id AS feature_id_8 FROM products_feature_values t0 INNER JOIN products_rel_feature_values ON t0.id = products_rel_feature_values.feature_value_id WHERE products_rel_feature_values.product_id = ?
Parameters:
[
  73266
]
27 0.33 ms
SELECT t0.name AS name_1, t0.enabled AS enabled_2, t0.slug AS slug_3, t0.position AS position_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.id AS id_7, t0.feature_id AS feature_id_8 FROM products_feature_values t0 INNER JOIN products_rel_feature_values ON t0.id = products_rel_feature_values.feature_value_id WHERE products_rel_feature_values.product_id = ?
Parameters:
[
  73265
]
28 0.36 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:
[
  72786
]
29 0.56 ms
SELECT t0.name AS name_1, t0.enabled AS enabled_2, t0.slug AS slug_3, t0.position AS position_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.id AS id_7, t0.feature_id AS feature_id_8 FROM products_feature_values t0 INNER JOIN products_rel_feature_values ON t0.id = products_rel_feature_values.feature_value_id WHERE products_rel_feature_values.product_id = ?
Parameters:
[
  80452
]
30 13.26 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
  "bc91fc74-b932-54df-881b-a6a99c9bd6ba"
  "23bc4adb-be85-5a87-9f4a-be57cd3d3916"
  "32c857c6-3f98-50c6-8238-6d2aa9c8f942"
  "770a67e7-30bd-5adb-baeb-5189ead1368d"
  "ac4df730-a789-58bd-a208-eb60a6643d97"
  "aeb2e7fd-2b8e-5eb7-8ad8-a977eb362e6f"
  "e9ceb4fe-cd6b-58de-96e0-b8369e824809"
  1
  1
]
31 17.56 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
  "bc91fc74-b932-54df-881b-a6a99c9bd6ba"
  "23bc4adb-be85-5a87-9f4a-be57cd3d3916"
  "32c857c6-3f98-50c6-8238-6d2aa9c8f942"
  "770a67e7-30bd-5adb-baeb-5189ead1368d"
  "ac4df730-a789-58bd-a208-eb60a6643d97"
  "aeb2e7fd-2b8e-5eb7-8ad8-a977eb362e6f"
  "e9ceb4fe-cd6b-58de-96e0-b8369e824809"
  1
  1
]
32 7.77 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
  "bc91fc74-b932-54df-881b-a6a99c9bd6ba"
  "23bc4adb-be85-5a87-9f4a-be57cd3d3916"
  "32c857c6-3f98-50c6-8238-6d2aa9c8f942"
  "770a67e7-30bd-5adb-baeb-5189ead1368d"
  "ac4df730-a789-58bd-a208-eb60a6643d97"
  "aeb2e7fd-2b8e-5eb7-8ad8-a977eb362e6f"
  "e9ceb4fe-cd6b-58de-96e0-b8369e824809"
  1
  1
]
33 141.48 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:
[
  "bc91fc74-b932-54df-881b-a6a99c9bd6ba"
  "23bc4adb-be85-5a87-9f4a-be57cd3d3916"
  "32c857c6-3f98-50c6-8238-6d2aa9c8f942"
  "770a67e7-30bd-5adb-baeb-5189ead1368d"
  "ac4df730-a789-58bd-a208-eb60a6643d97"
  "aeb2e7fd-2b8e-5eb7-8ad8-a977eb362e6f"
  "e9ceb4fe-cd6b-58de-96e0-b8369e824809"
  0
  "bc91fc74-b932-54df-881b-a6a99c9bd6ba"
  "23bc4adb-be85-5a87-9f4a-be57cd3d3916"
  "32c857c6-3f98-50c6-8238-6d2aa9c8f942"
  "770a67e7-30bd-5adb-baeb-5189ead1368d"
  "ac4df730-a789-58bd-a208-eb60a6643d97"
  "aeb2e7fd-2b8e-5eb7-8ad8-a977eb362e6f"
  "e9ceb4fe-cd6b-58de-96e0-b8369e824809"
  1
  1
]
34 11.27 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
  "bc91fc74-b932-54df-881b-a6a99c9bd6ba"
  "23bc4adb-be85-5a87-9f4a-be57cd3d3916"
  "32c857c6-3f98-50c6-8238-6d2aa9c8f942"
  "770a67e7-30bd-5adb-baeb-5189ead1368d"
  "ac4df730-a789-58bd-a208-eb60a6643d97"
  "aeb2e7fd-2b8e-5eb7-8ad8-a977eb362e6f"
  "e9ceb4fe-cd6b-58de-96e0-b8369e824809"
  1
  1
]
35 10.30 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
  "bc91fc74-b932-54df-881b-a6a99c9bd6ba"
  "23bc4adb-be85-5a87-9f4a-be57cd3d3916"
  "32c857c6-3f98-50c6-8238-6d2aa9c8f942"
  "770a67e7-30bd-5adb-baeb-5189ead1368d"
  "ac4df730-a789-58bd-a208-eb60a6643d97"
  "aeb2e7fd-2b8e-5eb7-8ad8-a977eb362e6f"
  "e9ceb4fe-cd6b-58de-96e0-b8369e824809"
  1
  1
]
36 0.66 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
  "bc91fc74-b932-54df-881b-a6a99c9bd6ba"
]
37 0.39 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
  "bc91fc74-b932-54df-881b-a6a99c9bd6ba"
]
38 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
]
39 0.33 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
]
40 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:
[
  73279
]
41 0.26 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"
]
42 0.23 ms
SELECT t0.name AS name_1, t0.slug AS slug_2, t0.enabled AS enabled_3, t0.multiple AS multiple_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.id AS id_7 FROM products_features t0 WHERE t0.id = ?
Parameters:
[
  "a6de82a2-6826-533f-a5dc-feed1d391dce"
]
43 0.74 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:
[
  73279
]
44 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, t0.media_watermark_id AS media_watermark_id_12 FROM media t0 WHERE t0.id = ?
Parameters:
[
  "4035308d-d3a6-449f-ba1e-27d1626987b2"
]
45 0.78 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:
[
  "b04aab92-f63a-4d20-b985-5e0b7441513b"
]
46 0.26 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:
[
  "2aa9792d-93ce-5718-9cf9-db0f147143be"
]
47 0.63 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:
[
  "2aa9792d-93ce-5718-9cf9-db0f147143be"
]
48 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:
[
  73278
]
49 0.40 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:
[
  73278
]
50 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:
[
  "41858c99-b440-4a7f-9eff-80020e0f0241"
]
51 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:
[
  "6989e911-b669-4cbd-8c28-0f128f572d5c"
]
52 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:
[
  73276
]
53 0.38 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:
[
  73276
]
54 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, t0.media_watermark_id AS media_watermark_id_12 FROM media t0 WHERE t0.id = ?
Parameters:
[
  "fa127c28-52a2-42c2-9f58-6404758ef88b"
]
55 0.71 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:
[
  "086c3348-6d75-4581-9785-e6a71dba70d5"
]
56 0.34 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:
[
  73277
]
57 0.44 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:
[
  73277
]
58 0.74 ms
SELECT t0.name AS name_1, t0.slug AS slug_2, t0.position AS position_3, t0.enabled AS enabled_4, t0.number_id AS number_id_5, t0.is_virtual AS is_virtual_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.id AS id_9, t0.related_category_id AS related_category_id_10, t0.parent_category_id AS parent_category_id_11 FROM products_categories t0 INNER JOIN products_rel_categories ON t0.id = products_rel_categories.category_id WHERE products_rel_categories.product_id = ?
Parameters:
[
  72788
]
59 0.60 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:
[
  72788
]
60 0.45 ms
SELECT t0.content_type AS content_type_1, t0.filename AS filename_2, t0.file_extension AS file_extension_3, t0.path AS path_4, t0.md5 AS md5_5, t0.file_size AS file_size_6, t0.width AS width_7, t0.height AS height_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.id AS id_11, t0.media_watermark_id AS media_watermark_id_12 FROM media t0 WHERE t0.id = ?
Parameters:
[
  "9f0812e0-aea5-4c70-80e0-d66c50a27dbb"
]
61 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:
[
  "2512a278-703b-4199-92fe-7911580ddf5f"
]
62 0.37 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:
[
  72787
]
63 0.40 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:
[
  72787
]
64 0.37 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:
[
  "bd060b30-2b78-4d60-bc27-b02659b3edfb"
]
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:
[
  "13460f26-d1d3-4a05-b788-073c35c60712"
]
66 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:
[
  72789
]
67 0.41 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:
[
  72789
]
68 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:
[
  "752d7863-7e19-4774-9f07-8c27dea91927"
]
69 0.61 ms
SELECT t0.content_type AS content_type_1, t0.filename AS filename_2, t0.file_extension AS file_extension_3, t0.path AS path_4, t0.md5 AS md5_5, t0.file_size AS file_size_6, t0.width AS width_7, t0.height AS height_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.id AS id_11, t12.content_type AS content_type_13, t12.filename AS filename_14, t12.file_extension AS file_extension_15, t12.path AS path_16, t12.md5 AS md5_17, t12.file_size AS file_size_18, t12.width AS width_19, t12.height AS height_20, t12.created_at AS created_at_21, t12.updated_at AS updated_at_22, t12.id AS id_23, t12.media_watermark_id AS media_watermark_id_24 FROM media_watermark t0 LEFT JOIN media t12 ON t12.media_watermark_id = t0.id WHERE t0.id = ?
Parameters:
[
  "f846a300-4bc5-4bee-b9a8-035473a4c7c2"
]
70 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:
[
  73275
]
71 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:
[
  73275
]
72 0.52 ms
SELECT t0.content_type AS content_type_1, t0.filename AS filename_2, t0.file_extension AS file_extension_3, t0.path AS path_4, t0.md5 AS md5_5, t0.file_size AS file_size_6, t0.width AS width_7, t0.height AS height_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.id AS id_11, t0.media_watermark_id AS media_watermark_id_12 FROM media t0 WHERE t0.id = ?
Parameters:
[
  "ce394c7d-318d-4cd2-b4de-55b9e20393dc"
]
73 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, 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:
[
  "29bf124a-1add-40b6-ba60-db997bdb102a"
]
74 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:
[
  73274
]
75 0.38 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:
[
  73274
]
76 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, t0.media_watermark_id AS media_watermark_id_12 FROM media t0 WHERE t0.id = ?
Parameters:
[
  "2ec2eaf7-a592-46f4-9a34-a8c24bacdba7"
]
77 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:
[
  "5a7ffaad-3738-45db-b92a-efdf70d5064e"
]
78 0.33 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:
[
  73272
]
79 0.39 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:
[
  73272
]
80 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, t0.media_watermark_id AS media_watermark_id_12 FROM media t0 WHERE t0.id = ?
Parameters:
[
  "60ac0de3-0844-4bc2-a3d6-d29258377f58"
]
81 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:
[
  "c44b29c6-670d-48a5-90b4-2f3bcea194f7"
]
82 0.33 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:
[
  73273
]
83 0.38 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:
[
  73273
]
84 0.46 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:
[
  73269
]
85 0.38 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:
[
  73269
]
86 0.37 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:
[
  "7848b7ab-0999-4966-985a-7db592291d57"
]
87 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:
[
  "bab1305e-1e1a-444c-b997-a266d0721850"
]
88 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:
[
  73270
]
89 0.42 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:
[
  73270
]
90 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, t0.media_watermark_id AS media_watermark_id_12 FROM media t0 WHERE t0.id = ?
Parameters:
[
  "32e60e1d-840b-4199-9645-8e1f45e4edd8"
]
91 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:
[
  "04626032-d359-48d7-9ff8-6c128dcfd6ad"
]
92 0.37 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:
[
  73271
]
93 0.23 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:
[
  73271
]
94 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, t0.media_watermark_id AS media_watermark_id_12 FROM media t0 WHERE t0.id = ?
Parameters:
[
  "f8b12b87-fe5c-4554-a2a9-ff3a665d3ce0"
]
95 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, 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:
[
  "b4d31ce3-b36d-42c1-b801-334bbe32b18d"
]
96 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:
[
  73268
]
97 0.22 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:
[
  73268
]
98 0.37 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:
[
  "6665fe55-a129-4944-bc65-e0d39c746aaf"
]
99 0.61 ms
SELECT t0.content_type AS content_type_1, t0.filename AS filename_2, t0.file_extension AS file_extension_3, t0.path AS path_4, t0.md5 AS md5_5, t0.file_size AS file_size_6, t0.width AS width_7, t0.height AS height_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.id AS id_11, t12.content_type AS content_type_13, t12.filename AS filename_14, t12.file_extension AS file_extension_15, t12.path AS path_16, t12.md5 AS md5_17, t12.file_size AS file_size_18, t12.width AS width_19, t12.height AS height_20, t12.created_at AS created_at_21, t12.updated_at AS updated_at_22, t12.id AS id_23, t12.media_watermark_id AS media_watermark_id_24 FROM media_watermark t0 LEFT JOIN media t12 ON t12.media_watermark_id = t0.id WHERE t0.id = ?
Parameters:
[
  "b1c42e2c-a221-495a-9d17-0ab93c990a50"
]
100 0.31 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:
[
  73267
]
101 0.40 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:
[
  73267
]
102 0.37 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:
[
  "d16773da-5813-4d17-ac95-fb761789dd53"
]
103 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:
[
  "334fb02f-b63a-44c3-955a-f1e4e3ed050e"
]
104 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:
[
  73266
]
105 0.39 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:
[
  73266
]
106 0.50 ms
SELECT t0.content_type AS content_type_1, t0.filename AS filename_2, t0.file_extension AS file_extension_3, t0.path AS path_4, t0.md5 AS md5_5, t0.file_size AS file_size_6, t0.width AS width_7, t0.height AS height_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.id AS id_11, t0.media_watermark_id AS media_watermark_id_12 FROM media t0 WHERE t0.id = ?
Parameters:
[
  "62e13d93-3c5c-480c-88d9-bd4f3740a25f"
]
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:
[
  "cec06f2a-1c20-4609-bebb-8d0a6bc4a515"
]
108 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:
[
  73265
]
109 0.40 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:
[
  73265
]
110 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, t0.media_watermark_id AS media_watermark_id_12 FROM media t0 WHERE t0.id = ?
Parameters:
[
  "c2b20b6d-5c85-4d2e-9d6c-3e7448c2a954"
]
111 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:
[
  "77559973-040f-45af-92df-1e10852ddb20"
]
112 0.37 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:
[
  72786
]
113 0.39 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:
[
  72786
]
114 0.38 ms
SELECT t0.content_type AS content_type_1, t0.filename AS filename_2, t0.file_extension AS file_extension_3, t0.path AS path_4, t0.md5 AS md5_5, t0.file_size AS file_size_6, t0.width AS width_7, t0.height AS height_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.id AS id_11, t0.media_watermark_id AS media_watermark_id_12 FROM media t0 WHERE t0.id = ?
Parameters:
[
  "b9206976-ed8a-479f-9100-9374694c0f55"
]
115 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:
[
  "d79d15c8-296f-4194-af1c-4c4c05a02e1d"
]
116 0.64 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:
[
  80452
]
117 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:
[
  80452
]
118 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:
[
  "663e7b01-3aeb-4faf-86a1-826087b3d681"
]
119 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:
[
  "58e5d57f-c749-4126-9b01-9ae5db4a5e97"
]
120 0.23 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:
[
  "50ae2539-453d-5eab-a2fc-d2d12a295021"
]
121 0.41 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:
[
  "50ae2539-453d-5eab-a2fc-d2d12a295021"
]
122 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:
[
  "24a6d1a6-99ea-4d09-bfdc-41aededfc5ad"
]
123 0.71 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:
[
  "d8cc86bb-5552-4048-b34c-2527b703c430"
]
124 0.47 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
  "2aa9792d-93ce-5718-9cf9-db0f147143be"
]
125 0.34 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
  "2aa9792d-93ce-5718-9cf9-db0f147143be"
]
126 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 = ? AND b1_.category_id = ? AND b1_.brand_id = ? ORDER BY b1_.position ASC LIMIT 30
Parameters:
[
  2
  6
  "bc91fc74-b932-54df-881b-a6a99c9bd6ba"
  "2aa9792d-93ce-5718-9cf9-db0f147143be"
]
127 0.33 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
  "bc91fc74-b932-54df-881b-a6a99c9bd6ba"
  "2aa9792d-93ce-5718-9cf9-db0f147143be"
]
128 0.33 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
  "50ae2539-453d-5eab-a2fc-d2d12a295021"
]
129 0.28 ms
SELECT count(1) AS sclr_0 FROM banners b0_ INNER JOIN banner_location_position b1_ ON b0_.id = b1_.banner_id WHERE b0_.status = ? AND b1_.location = ? AND b1_.brand_id = ?
Parameters:
[
  2
  7
  "50ae2539-453d-5eab-a2fc-d2d12a295021"
]
130 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 = ? AND b1_.category_id = ? AND b1_.brand_id = ? ORDER BY b1_.position ASC LIMIT 30
Parameters:
[
  2
  6
  "bc91fc74-b932-54df-881b-a6a99c9bd6ba"
  "50ae2539-453d-5eab-a2fc-d2d12a295021"
]
131 0.29 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
  "bc91fc74-b932-54df-881b-a6a99c9bd6ba"
  "50ae2539-453d-5eab-a2fc-d2d12a295021"
]
132 0.26 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:
[
  "ca0de886-82a9-5d37-be79-2df8a2ab2956"
]
133 0.53 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"
]
134 0.28 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"
]
135 0.22 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"
]
136 0.21 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"
]
137 0.47 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
]
138 0.23 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 8
Fotoboom\Product\Domain\FeatureValue 6
Fotoboom\Configuration\Domain\Configuration 4
Fotoboom\Product\Domain\Brand 2
Fotoboom\Product\Domain\Feature 2
Fotoboom\Product\Domain\BrandMedia 2