Query Metrics
112
Database Queries
28
Different statements
30.97 ms
Query time
0
Invalid entities
142
Managed entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.94 ms |
SELECT t0.slug AS slug_1, t0.name AS name_2, t0.description AS description_3, t0.description_short AS description_short_4, t0.supplier_reference AS supplier_reference_5, t0.manufacturer_reference AS manufacturer_reference_6, t0.ean AS ean_7, t0.position AS position_8, t0.status AS status_9, t0.tax_type AS tax_type_10, t0.showcase AS showcase_11, t0.on_offer AS on_offer_12, t0.new AS new_13, t0.kit AS kit_14, t0.show_only_in_pack AS show_only_in_pack_15, t0.price_buy AS price_buy_16, t0.price_sell AS price_sell_17, t0.price_offer AS price_offer_18, t0.soa AS soa_19, t0.stock AS stock_20, t0.stock_supplier AS stock_supplier_21, t0.min AS min_22, t0.max AS max_23, t0.period AS period_24, t0.internal_comments AS internal_comments_25, t0.created_at AS created_at_26, t0.updated_at AS updated_at_27, t0.last_activation_at AS last_activation_at_28, t0.product_specs AS product_specs_29, t0.cron_export_status AS cron_export_status_30, t0.id AS id_31, t0.brand_id AS brand_id_32, t0.created_by_user AS created_by_user_33, t0.updated_by_user AS updated_by_user_34, t0.last_activation_by_user AS last_activation_by_user_35 FROM products t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
"pera-naranja"
]
|
| 2 | 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:
[
117
]
|
| 3 | 0.28 ms |
SELECT p0_.reference AS reference_0, p0_.number_id AS number_id_1, p0_.name AS name_2, p0_.position AS position_3, p0_.enabled AS enabled_4, p0_.created_at AS created_at_5, p0_.updated_at AS updated_at_6, p0_.id AS id_7 FROM product_boxes p0_ ORDER BY p0_.id ASC LIMIT 30
Parameters:
[] |
| 4 | 0.22 ms |
SELECT count(1) AS sclr_0 FROM product_boxes p0_
Parameters:
[] |
| 5 | 0.20 ms |
SELECT p0_.reference AS reference_0, p0_.number_id AS number_id_1, p0_.name AS name_2, p0_.position AS position_3, p0_.enabled AS enabled_4, p0_.created_at AS created_at_5, p0_.updated_at AS updated_at_6, p0_.id AS id_7 FROM product_packs p0_ ORDER BY p0_.id ASC LIMIT 30
Parameters:
[] |
| 6 | 0.20 ms |
SELECT count(1) AS sclr_0 FROM product_packs p0_
Parameters:
[] |
| 7 | 0.26 ms |
SELECT t0.name AS name_1, t0.type AS type_2, t0.slug AS slug_3, t0.position AS position_4, t0.number_id AS number_id_5, t0.description AS description_6, t0.description_admin AS description_admin_7, t0.enabled AS enabled_8, t0.button_1_text AS button_1_text_9, t0.button_1_url AS button_1_url_10, t0.video_youtube_code AS video_youtube_code_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.id AS id_14, t0.brand_id AS brand_id_15 FROM products_legends t0 INNER JOIN products_rel_legends ON t0.id = products_rel_legends.legend_id WHERE products_rel_legends.product_id = ?
Parameters:
[
117
]
|
| 8 | 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 INNER JOIN products_rel_categories ON t0.id = products_rel_categories.category_id WHERE products_rel_categories.product_id = ?
Parameters:
[
117
]
|
| 9 | 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:
[
117
]
|
| 10 | 0.21 ms |
SELECT t0.name AS name_1, t0.position AS position_2, t0.embed_url AS embed_url_3, t0.id AS id_4, t0.product_id AS product_id_5 FROM products_videos t0 WHERE t0.product_id = ? ORDER BY t0.position ASC
Parameters:
[
117
]
|
| 11 | 0.34 ms |
SELECT t0.slug AS slug_1, t0.name AS name_2, t0.description AS description_3, t0.description_short AS description_short_4, t0.supplier_reference AS supplier_reference_5, t0.manufacturer_reference AS manufacturer_reference_6, t0.ean AS ean_7, t0.position AS position_8, t0.status AS status_9, t0.tax_type AS tax_type_10, t0.showcase AS showcase_11, t0.on_offer AS on_offer_12, t0.new AS new_13, t0.kit AS kit_14, t0.show_only_in_pack AS show_only_in_pack_15, t0.price_buy AS price_buy_16, t0.price_sell AS price_sell_17, t0.price_offer AS price_offer_18, t0.soa AS soa_19, t0.stock AS stock_20, t0.stock_supplier AS stock_supplier_21, t0.min AS min_22, t0.max AS max_23, t0.period AS period_24, t0.internal_comments AS internal_comments_25, t0.created_at AS created_at_26, t0.updated_at AS updated_at_27, t0.last_activation_at AS last_activation_at_28, t0.product_specs AS product_specs_29, t0.cron_export_status AS cron_export_status_30, t0.id AS id_31, t0.brand_id AS brand_id_32, t0.created_by_user AS created_by_user_33, t0.updated_by_user AS updated_by_user_34, t0.last_activation_by_user AS last_activation_by_user_35 FROM products t0 INNER JOIN products_rel_accessories ON t0.id = products_rel_accessories.accessory_id WHERE products_rel_accessories.product_id = ?
Parameters:
[
117
]
|
| 12 | 0.19 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:
[
"2cc48cdd-b315-474b-8b05-755b5e8c5077"
]
|
| 13 | 0.21 ms |
SELECT t0.position AS position_1, t0.is_main AS is_main_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.id AS id_5, t0.brand_id AS brand_id_6, t0.media_id AS media_id_7 FROM brands_medias t0 WHERE t0.brand_id = ?
Parameters:
[
"2cc48cdd-b315-474b-8b05-755b5e8c5077"
]
|
| 14 | 0.22 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:
[
"2441a2cf-552c-44f2-8334-9d5c037b8bf9"
]
|
| 15 | 0.22 ms |
SELECT t0.position AS position_1, t0.id AS id_2, t0.product_box_id AS product_box_id_3, t0.product_id AS product_id_4 FROM product_box_products_inside_position t0 WHERE t0.product_box_id = ? ORDER BY t0.position ASC
Parameters:
[
"134bebf8-19d1-4590-9a9e-1aea226c2259"
]
|
| 16 | 0.40 ms |
SELECT t0.slug AS slug_1, t0.name AS name_2, t0.description AS description_3, t0.description_short AS description_short_4, t0.supplier_reference AS supplier_reference_5, t0.manufacturer_reference AS manufacturer_reference_6, t0.ean AS ean_7, t0.position AS position_8, t0.status AS status_9, t0.tax_type AS tax_type_10, t0.showcase AS showcase_11, t0.on_offer AS on_offer_12, t0.new AS new_13, t0.kit AS kit_14, t0.show_only_in_pack AS show_only_in_pack_15, t0.price_buy AS price_buy_16, t0.price_sell AS price_sell_17, t0.price_offer AS price_offer_18, t0.soa AS soa_19, t0.stock AS stock_20, t0.stock_supplier AS stock_supplier_21, t0.min AS min_22, t0.max AS max_23, t0.period AS period_24, t0.internal_comments AS internal_comments_25, t0.created_at AS created_at_26, t0.updated_at AS updated_at_27, t0.last_activation_at AS last_activation_at_28, t0.product_specs AS product_specs_29, t0.cron_export_status AS cron_export_status_30, t0.id AS id_31, t0.brand_id AS brand_id_32, t0.created_by_user AS created_by_user_33, t0.updated_by_user AS updated_by_user_34, t0.last_activation_by_user AS last_activation_by_user_35 FROM products t0 INNER JOIN product_boxes_rel_products_assoc ON t0.id = product_boxes_rel_products_assoc.product_id WHERE product_boxes_rel_products_assoc.product_box_id = ?
Parameters:
[
"134bebf8-19d1-4590-9a9e-1aea226c2259"
]
|
| 17 | 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:
[
6
]
|
| 18 | 0.41 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:
[
7
]
|
| 19 | 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:
[
8
]
|
| 20 | 0.25 ms |
SELECT t0.name AS name_1, t0.enabled AS enabled_2, t0.slug AS slug_3, t0.position AS position_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.id AS id_7, t0.feature_id AS feature_id_8 FROM products_feature_values t0 INNER JOIN products_rel_feature_values ON t0.id = products_rel_feature_values.feature_value_id WHERE products_rel_feature_values.product_id = ?
Parameters:
[
9
]
|
| 21 | 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:
[
10
]
|
| 22 | 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:
[
11
]
|
| 23 | 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:
[
12
]
|
| 24 | 0.24 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:
[
6
]
|
| 25 | 0.22 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:
[
"73b48ba6-0fd8-417a-aa0a-29f98e5af3f7"
]
|
| 26 | 0.27 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:
[
7
]
|
| 27 | 0.25 ms |
SELECT t0.content_type AS content_type_1, t0.filename AS filename_2, t0.file_extension AS file_extension_3, t0.path AS path_4, t0.md5 AS md5_5, t0.file_size AS file_size_6, t0.width AS width_7, t0.height AS height_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.id AS id_11, t0.media_watermark_id AS media_watermark_id_12 FROM media t0 WHERE t0.id = ?
Parameters:
[
"2b976614-1483-40ce-8b99-20b0833b68a3"
]
|
| 28 | 0.21 ms |
SELECT t0.position AS position_1, t0.is_main AS is_main_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.id AS id_5, t0.product_id AS product_id_6, t0.media_id AS media_id_7 FROM products_medias t0 WHERE t0.product_id = ?
Parameters:
[
8
]
|
| 29 | 0.21 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:
[
"d0e96bb5-f361-443d-a29f-af1b9e8b5002"
]
|
| 30 | 0.21 ms |
SELECT t0.position AS position_1, t0.is_main AS is_main_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.id AS id_5, t0.product_id AS product_id_6, t0.media_id AS media_id_7 FROM products_medias t0 WHERE t0.product_id = ?
Parameters:
[
9
]
|
| 31 | 0.21 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:
[
"4b698c07-f4a6-415b-98c3-deb14e04f94d"
]
|
| 32 | 0.21 ms |
SELECT t0.position AS position_1, t0.is_main AS is_main_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.id AS id_5, t0.product_id AS product_id_6, t0.media_id AS media_id_7 FROM products_medias t0 WHERE t0.product_id = ?
Parameters:
[
10
]
|
| 33 | 0.21 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:
[
"4bfd7171-10e6-4d3c-bcc2-3979606ebf71"
]
|
| 34 | 0.21 ms |
SELECT t0.position AS position_1, t0.is_main AS is_main_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.id AS id_5, t0.product_id AS product_id_6, t0.media_id AS media_id_7 FROM products_medias t0 WHERE t0.product_id = ?
Parameters:
[
11
]
|
| 35 | 0.21 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:
[
"aadcb294-9eed-423f-863a-6f202932168f"
]
|
| 36 | 0.20 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:
[
12
]
|
| 37 | 0.21 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:
[
"0709f40b-474b-450a-83ab-d0ce94bd654e"
]
|
| 38 | 0.22 ms |
SELECT t0.position AS position_1, t0.id AS id_2, t0.product_box_id AS product_box_id_3, t0.product_id AS product_id_4 FROM product_box_products_inside_position t0 WHERE t0.product_box_id = ? ORDER BY t0.position ASC
Parameters:
[
"d69a687c-40dc-4e9a-ac7b-de91cbdb6bfe"
]
|
| 39 | 0.50 ms |
SELECT t0.slug AS slug_1, t0.name AS name_2, t0.description AS description_3, t0.description_short AS description_short_4, t0.supplier_reference AS supplier_reference_5, t0.manufacturer_reference AS manufacturer_reference_6, t0.ean AS ean_7, t0.position AS position_8, t0.status AS status_9, t0.tax_type AS tax_type_10, t0.showcase AS showcase_11, t0.on_offer AS on_offer_12, t0.new AS new_13, t0.kit AS kit_14, t0.show_only_in_pack AS show_only_in_pack_15, t0.price_buy AS price_buy_16, t0.price_sell AS price_sell_17, t0.price_offer AS price_offer_18, t0.soa AS soa_19, t0.stock AS stock_20, t0.stock_supplier AS stock_supplier_21, t0.min AS min_22, t0.max AS max_23, t0.period AS period_24, t0.internal_comments AS internal_comments_25, t0.created_at AS created_at_26, t0.updated_at AS updated_at_27, t0.last_activation_at AS last_activation_at_28, t0.product_specs AS product_specs_29, t0.cron_export_status AS cron_export_status_30, t0.id AS id_31, t0.brand_id AS brand_id_32, t0.created_by_user AS created_by_user_33, t0.updated_by_user AS updated_by_user_34, t0.last_activation_by_user AS last_activation_by_user_35 FROM products t0 INNER JOIN product_boxes_rel_products_assoc ON t0.id = product_boxes_rel_products_assoc.product_id WHERE product_boxes_rel_products_assoc.product_box_id = ?
Parameters:
[
"d69a687c-40dc-4e9a-ac7b-de91cbdb6bfe"
]
|
| 40 | 0.31 ms |
SELECT t0.position AS position_1, t0.id AS id_2, t0.product_box_id AS product_box_id_3, t0.product_id AS product_id_4 FROM product_box_products_inside_position t0 WHERE t0.product_box_id = ? ORDER BY t0.position ASC
Parameters:
[
"f3217091-ebeb-4028-a386-0823a78f1465"
]
|
| 41 | 0.46 ms |
SELECT t0.slug AS slug_1, t0.name AS name_2, t0.description AS description_3, t0.description_short AS description_short_4, t0.supplier_reference AS supplier_reference_5, t0.manufacturer_reference AS manufacturer_reference_6, t0.ean AS ean_7, t0.position AS position_8, t0.status AS status_9, t0.tax_type AS tax_type_10, t0.showcase AS showcase_11, t0.on_offer AS on_offer_12, t0.new AS new_13, t0.kit AS kit_14, t0.show_only_in_pack AS show_only_in_pack_15, t0.price_buy AS price_buy_16, t0.price_sell AS price_sell_17, t0.price_offer AS price_offer_18, t0.soa AS soa_19, t0.stock AS stock_20, t0.stock_supplier AS stock_supplier_21, t0.min AS min_22, t0.max AS max_23, t0.period AS period_24, t0.internal_comments AS internal_comments_25, t0.created_at AS created_at_26, t0.updated_at AS updated_at_27, t0.last_activation_at AS last_activation_at_28, t0.product_specs AS product_specs_29, t0.cron_export_status AS cron_export_status_30, t0.id AS id_31, t0.brand_id AS brand_id_32, t0.created_by_user AS created_by_user_33, t0.updated_by_user AS updated_by_user_34, t0.last_activation_by_user AS last_activation_by_user_35 FROM products t0 INNER JOIN product_boxes_rel_products_assoc ON t0.id = product_boxes_rel_products_assoc.product_id WHERE product_boxes_rel_products_assoc.product_box_id = ?
Parameters:
[
"f3217091-ebeb-4028-a386-0823a78f1465"
]
|
| 42 | 0.28 ms |
SELECT t0.name AS name_1, t0.enabled AS enabled_2, t0.slug AS slug_3, t0.position AS position_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.id AS id_7, t0.feature_id AS feature_id_8 FROM products_feature_values t0 INNER JOIN products_rel_feature_values ON t0.id = products_rel_feature_values.feature_value_id WHERE products_rel_feature_values.product_id = ?
Parameters:
[
149
]
|
| 43 | 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:
[
225
]
|
| 44 | 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:
[
226
]
|
| 45 | 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:
[
227
]
|
| 46 | 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:
[
228
]
|
| 47 | 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:
[
229
]
|
| 48 | 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:
[
230
]
|
| 49 | 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:
[
231
]
|
| 50 | 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.product_id AS product_id_6, t0.media_id AS media_id_7 FROM products_medias t0 WHERE t0.product_id = ?
Parameters:
[
149
]
|
| 51 | 0.24 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:
[
"121dc88d-ea1b-40ea-a217-9494ce6e8d13"
]
|
| 52 | 0.21 ms |
SELECT t0.position AS position_1, t0.is_main AS is_main_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.id AS id_5, t0.product_id AS product_id_6, t0.media_id AS media_id_7 FROM products_medias t0 WHERE t0.product_id = ?
Parameters:
[
225
]
|
| 53 | 0.21 ms |
SELECT t0.position AS position_1, t0.is_main AS is_main_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.id AS id_5, t0.product_id AS product_id_6, t0.media_id AS media_id_7 FROM products_medias t0 WHERE t0.product_id = ?
Parameters:
[
226
]
|
| 54 | 0.24 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:
[
227
]
|
| 55 | 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:
[
228
]
|
| 56 | 0.24 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:
[
229
]
|
| 57 | 0.24 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:
[
230
]
|
| 58 | 0.24 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:
[
231
]
|
| 59 | 0.45 ms |
SELECT t0.slug AS slug_1, t0.name AS name_2, t0.description AS description_3, t0.description_short AS description_short_4, t0.supplier_reference AS supplier_reference_5, t0.manufacturer_reference AS manufacturer_reference_6, t0.ean AS ean_7, t0.position AS position_8, t0.status AS status_9, t0.tax_type AS tax_type_10, t0.showcase AS showcase_11, t0.on_offer AS on_offer_12, t0.new AS new_13, t0.kit AS kit_14, t0.show_only_in_pack AS show_only_in_pack_15, t0.price_buy AS price_buy_16, t0.price_sell AS price_sell_17, t0.price_offer AS price_offer_18, t0.soa AS soa_19, t0.stock AS stock_20, t0.stock_supplier AS stock_supplier_21, t0.min AS min_22, t0.max AS max_23, t0.period AS period_24, t0.internal_comments AS internal_comments_25, t0.created_at AS created_at_26, t0.updated_at AS updated_at_27, t0.last_activation_at AS last_activation_at_28, t0.product_specs AS product_specs_29, t0.cron_export_status AS cron_export_status_30, t0.id AS id_31, t0.brand_id AS brand_id_32, t0.created_by_user AS created_by_user_33, t0.updated_by_user AS updated_by_user_34, t0.last_activation_by_user AS last_activation_by_user_35 FROM products t0 INNER JOIN product_packs_rel_products_inside ON t0.id = product_packs_rel_products_inside.product_id WHERE product_packs_rel_products_inside.product_pack_id = ?
Parameters:
[
"3f5a95e8-0e2f-46f7-924c-9417fdf9c7d7"
]
|
| 60 | 0.51 ms |
SELECT t0.slug AS slug_1, t0.name AS name_2, t0.description AS description_3, t0.description_short AS description_short_4, t0.supplier_reference AS supplier_reference_5, t0.manufacturer_reference AS manufacturer_reference_6, t0.ean AS ean_7, t0.position AS position_8, t0.status AS status_9, t0.tax_type AS tax_type_10, t0.showcase AS showcase_11, t0.on_offer AS on_offer_12, t0.new AS new_13, t0.kit AS kit_14, t0.show_only_in_pack AS show_only_in_pack_15, t0.price_buy AS price_buy_16, t0.price_sell AS price_sell_17, t0.price_offer AS price_offer_18, t0.soa AS soa_19, t0.stock AS stock_20, t0.stock_supplier AS stock_supplier_21, t0.min AS min_22, t0.max AS max_23, t0.period AS period_24, t0.internal_comments AS internal_comments_25, t0.created_at AS created_at_26, t0.updated_at AS updated_at_27, t0.last_activation_at AS last_activation_at_28, t0.product_specs AS product_specs_29, t0.cron_export_status AS cron_export_status_30, t0.id AS id_31, t0.brand_id AS brand_id_32, t0.created_by_user AS created_by_user_33, t0.updated_by_user AS updated_by_user_34, t0.last_activation_by_user AS last_activation_by_user_35 FROM products t0 INNER JOIN product_packs_rel_products_assoc ON t0.id = product_packs_rel_products_assoc.product_id WHERE product_packs_rel_products_assoc.product_pack_id = ?
Parameters:
[
"3f5a95e8-0e2f-46f7-924c-9417fdf9c7d7"
]
|
| 61 | 0.34 ms |
SELECT o0_.reference AS reference_0, o0_.amount AS amount_1, o0_.name AS name_2, o0_.price_sell AS price_sell_3, o0_.price_offer AS price_offer_4, o0_.price_subtotal AS price_subtotal_5, o0_.price_subtotal_after_taxes AS price_subtotal_after_taxes_6, o0_.created_at AS created_at_7, o0_.updated_at AS updated_at_8, o0_.id AS id_9, o0_.order_id AS order_id_10, o0_.product_id AS product_id_11 FROM orders_products o0_ ORDER BY o0_.id ASC LIMIT 30
Parameters:
[] |
| 62 | 0.60 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_.kit AS kit_13, p0_.show_only_in_pack AS show_only_in_pack_14, p0_.price_buy AS price_buy_15, p0_.price_sell AS price_sell_16, p0_.price_offer AS price_offer_17, p0_.soa AS soa_18, p0_.stock AS stock_19, p0_.stock_supplier AS stock_supplier_20, p0_.min AS min_21, p0_.max AS max_22, p0_.period AS period_23, p0_.internal_comments AS internal_comments_24, p0_.created_at AS created_at_25, p0_.updated_at AS updated_at_26, p0_.last_activation_at AS last_activation_at_27, p0_.product_specs AS product_specs_28, p0_.cron_export_status AS cron_export_status_29, p0_.id AS id_30, p0_.brand_id AS brand_id_31, p0_.created_by_user AS created_by_user_32, p0_.updated_by_user AS updated_by_user_33, p0_.last_activation_by_user AS last_activation_by_user_34 FROM products p0_ WHERE p0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY p0_.id ASC LIMIT 30
Parameters:
[ 341 341 341 341 7 5 341 7 8 8 341 5 ] |
| 63 | 0.38 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:
[
5
]
|
| 64 | 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:
[
341
]
|
| 65 | 0.27 ms |
SELECT count(1) AS sclr_0 FROM products p0_ WHERE p0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 341 341 341 341 7 5 341 7 8 8 341 5 ] |
| 66 | 0.41 ms |
SELECT p0_.slug AS slug_0, p0_.name AS name_1 FROM products p1_ INNER JOIN products_brands p0_ ON p1_.brand_id = p0_.id WHERE p1_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) GROUP BY p0_.id ORDER BY p0_.name ASC
Parameters:
[ 341 341 341 341 7 5 341 7 8 8 341 5 ] |
| 67 | 0.48 ms |
SELECT p0_.slug AS slug_0, p0_.name AS name_1, p0_.slug AS slug_2 FROM products p1_ INNER JOIN products_brands p2_ ON p1_.brand_id = p2_.id LEFT JOIN products_rel_categories p3_ ON p1_.id = p3_.product_id LEFT JOIN products_categories p0_ ON p0_.id = p3_.category_id WHERE p1_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) GROUP BY p0_.id ORDER BY p0_.name ASC
Parameters:
[ 341 341 341 341 7 5 341 7 8 8 341 5 ] |
| 68 | 0.47 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_ INNER JOIN products_brands p3_ ON p2_.brand_id = p3_.id LEFT JOIN products_rel_categories p5_ ON p2_.id = p5_.product_id LEFT JOIN products_categories p4_ ON p4_.id = p5_.category_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 (NULL)) WHERE p2_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) GROUP BY p0_.id, p1_.id, p1_.name, p0_.name, p1_.slug, p0_.slug, p0_.position, p7_.position ORDER BY p4_.name ASC, p7_.position ASC, p0_.position ASC
Parameters:
[ 341 341 341 341 7 5 341 7 8 8 341 5 ] |
| 69 | 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:
[
5
]
|
| 70 | 0.28 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:
[
"1d786ea2-36ad-498d-a071-2cee364e3357"
]
|
| 71 | 0.21 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:
[
"41bb1ff0-fe8c-46f9-a003-2052943827ed"
]
|
| 72 | 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.product_id AS product_id_6, t0.media_id AS media_id_7 FROM products_medias t0 WHERE t0.product_id = ?
Parameters:
[
5
]
|
| 73 | 0.26 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:
[
"9d806004-96b8-403d-82f0-67c888a562ff"
]
|
| 74 | 0.23 ms |
SELECT t0.content_type AS content_type_1, t0.filename AS filename_2, t0.file_extension AS file_extension_3, t0.path AS path_4, t0.md5 AS md5_5, t0.file_size AS file_size_6, t0.width AS width_7, t0.height AS height_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.id AS id_11, t12.content_type AS content_type_13, t12.filename AS filename_14, t12.file_extension AS file_extension_15, t12.path AS path_16, t12.md5 AS md5_17, t12.file_size AS file_size_18, t12.width AS width_19, t12.height AS height_20, t12.created_at AS created_at_21, t12.updated_at AS updated_at_22, t12.id AS id_23, t12.media_watermark_id AS media_watermark_id_24 FROM media_watermark t0 LEFT JOIN media t12 ON t12.media_watermark_id = t0.id WHERE t0.id = ?
Parameters:
[
"0d085bd2-f176-432b-bdc8-e09a15406643"
]
|
| 75 | 0.21 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:
[
"5157f3e1-9de5-4835-a78a-df2ea4992766"
]
|
| 76 | 0.34 ms |
SELECT t0.content_type AS content_type_1, t0.filename AS filename_2, t0.file_extension AS file_extension_3, t0.path AS path_4, t0.md5 AS md5_5, t0.file_size AS file_size_6, t0.width AS width_7, t0.height AS height_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.id AS id_11, t12.content_type AS content_type_13, t12.filename AS filename_14, t12.file_extension AS file_extension_15, t12.path AS path_16, t12.md5 AS md5_17, t12.file_size AS file_size_18, t12.width AS width_19, t12.height AS height_20, t12.created_at AS created_at_21, t12.updated_at AS updated_at_22, t12.id AS id_23, t12.media_watermark_id AS media_watermark_id_24 FROM media_watermark t0 LEFT JOIN media t12 ON t12.media_watermark_id = t0.id WHERE t0.id = ?
Parameters:
[
"1bbffb22-17d4-4e06-b429-a0789b8a1580"
]
|
| 77 | 0.25 ms |
SELECT t0.content_type AS content_type_1, t0.filename AS filename_2, t0.file_extension AS file_extension_3, t0.path AS path_4, t0.md5 AS md5_5, t0.file_size AS file_size_6, t0.width AS width_7, t0.height AS height_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.id AS id_11, t0.media_watermark_id AS media_watermark_id_12 FROM media t0 WHERE t0.id = ?
Parameters:
[
"a75a2485-7e7e-4c0f-9a3c-c1465f107d48"
]
|
| 78 | 0.27 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:
[
"fd2f63b5-86ad-49e7-975e-51b92a448392"
]
|
| 79 | 0.23 ms |
SELECT t0.content_type AS content_type_1, t0.filename AS filename_2, t0.file_extension AS file_extension_3, t0.path AS path_4, t0.md5 AS md5_5, t0.file_size AS file_size_6, t0.width AS width_7, t0.height AS height_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.id AS id_11, t0.media_watermark_id AS media_watermark_id_12 FROM media t0 WHERE t0.id = ?
Parameters:
[
"2297d826-68bd-417d-a215-256eeb68b398"
]
|
| 80 | 0.28 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:
[
"0b0e0939-94e8-41aa-b51a-820ead9d83a8"
]
|
| 81 | 0.22 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:
[
"132e60e4-f4aa-4bc4-8878-eb562a2a582a"
]
|
| 82 | 0.25 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:
[
"132e60e4-f4aa-4bc4-8878-eb562a2a582a"
]
|
| 83 | 0.29 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:
[
7
]
|
| 84 | 0.21 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:
[
"0194f8e9-bf10-4061-9d4d-6eaf935096f3"
]
|
| 85 | 0.27 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:
[
"d9c3a60a-0132-49ca-869d-b776d74e0e27"
]
|
| 86 | 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:
[
8
]
|
| 87 | 0.27 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:
[
"5f93c01a-fc2a-45d8-aa6c-b6f399426166"
]
|
| 88 | 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 INNER JOIN products_rel_categories ON t0.id = products_rel_categories.category_id WHERE products_rel_categories.product_id = ?
Parameters:
[
341
]
|
| 89 | 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:
[
341
]
|
| 90 | 0.22 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:
[
"a62e355a-217d-4b8d-af13-68ce20d6f84c"
]
|
| 91 | 0.26 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:
[
"bc36cb48-e5a0-4bc0-aabd-f8120bef4f85"
]
|
| 92 | 0.26 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:
[
"0282fbc1-6bfb-4c92-8082-f8ef229907ba"
]
|
| 93 | 0.26 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:
[
"f4e9c0df-0748-4844-a66a-ea5188dfde2e"
]
|
| 94 | 0.23 ms |
SELECT t0.content_type AS content_type_1, t0.filename AS filename_2, t0.file_extension AS file_extension_3, t0.path AS path_4, t0.md5 AS md5_5, t0.file_size AS file_size_6, t0.width AS width_7, t0.height AS height_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.id AS id_11, t0.media_watermark_id AS media_watermark_id_12 FROM media t0 WHERE t0.id = ?
Parameters:
[
"756ac647-a838-429a-a695-4c2c4778f6bf"
]
|
| 95 | 0.26 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:
[
"36f26050-b3ce-49da-a939-522ae0db12c4"
]
|
| 96 | 0.21 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:
[
"e79e2bbf-5215-4209-8c25-53c9078bc5f0"
]
|
| 97 | 0.25 ms |
SELECT t0.content_type AS content_type_1, t0.filename AS filename_2, t0.file_extension AS file_extension_3, t0.path AS path_4, t0.md5 AS md5_5, t0.file_size AS file_size_6, t0.width AS width_7, t0.height AS height_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.id AS id_11, t12.content_type AS content_type_13, t12.filename AS filename_14, t12.file_extension AS file_extension_15, t12.path AS path_16, t12.md5 AS md5_17, t12.file_size AS file_size_18, t12.width AS width_19, t12.height AS height_20, t12.created_at AS created_at_21, t12.updated_at AS updated_at_22, t12.id AS id_23, t12.media_watermark_id AS media_watermark_id_24 FROM media_watermark t0 LEFT JOIN media t12 ON t12.media_watermark_id = t0.id WHERE t0.id = ?
Parameters:
[
"5d85e5fe-cb80-4313-a96d-ddcab81215bc"
]
|
| 98 | 0.20 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:
[
"c8865cc1-0c05-4f01-a135-c0427ca03fc9"
]
|
| 99 | 0.25 ms |
SELECT t0.content_type AS content_type_1, t0.filename AS filename_2, t0.file_extension AS file_extension_3, t0.path AS path_4, t0.md5 AS md5_5, t0.file_size AS file_size_6, t0.width AS width_7, t0.height AS height_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.id AS id_11, t12.content_type AS content_type_13, t12.filename AS filename_14, t12.file_extension AS file_extension_15, t12.path AS path_16, t12.md5 AS md5_17, t12.file_size AS file_size_18, t12.width AS width_19, t12.height AS height_20, t12.created_at AS created_at_21, t12.updated_at AS updated_at_22, t12.id AS id_23, t12.media_watermark_id AS media_watermark_id_24 FROM media_watermark t0 LEFT JOIN media t12 ON t12.media_watermark_id = t0.id WHERE t0.id = ?
Parameters:
[
"289cb580-53b3-41e4-8e6c-4536a2dc6db3"
]
|
| 100 | 0.23 ms |
SELECT t0.content_type AS content_type_1, t0.filename AS filename_2, t0.file_extension AS file_extension_3, t0.path AS path_4, t0.md5 AS md5_5, t0.file_size AS file_size_6, t0.width AS width_7, t0.height AS height_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.id AS id_11, t0.media_watermark_id AS media_watermark_id_12 FROM media t0 WHERE t0.id = ?
Parameters:
[
"0f9c1a9b-0caa-403b-a766-75280931e8f1"
]
|
| 101 | 0.26 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:
[
"e9c61140-1e76-4129-a69f-2b826cdb2035"
]
|
| 102 | 0.22 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:
[
"441c5fd3-d55b-4a7f-8104-5824db8eaeb5"
]
|
| 103 | 0.26 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:
[
"051e9ea0-b237-430d-be9a-07222e755e14"
]
|
| 104 | 0.21 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:
[
"38e6f0d3-2e30-40f6-a985-20125dd6e11c"
]
|
| 105 | 0.25 ms |
SELECT t0.content_type AS content_type_1, t0.filename AS filename_2, t0.file_extension AS file_extension_3, t0.path AS path_4, t0.md5 AS md5_5, t0.file_size AS file_size_6, t0.width AS width_7, t0.height AS height_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.id AS id_11, t12.content_type AS content_type_13, t12.filename AS filename_14, t12.file_extension AS file_extension_15, t12.path AS path_16, t12.md5 AS md5_17, t12.file_size AS file_size_18, t12.width AS width_19, t12.height AS height_20, t12.created_at AS created_at_21, t12.updated_at AS updated_at_22, t12.id AS id_23, t12.media_watermark_id AS media_watermark_id_24 FROM media_watermark t0 LEFT JOIN media t12 ON t12.media_watermark_id = t0.id WHERE t0.id = ?
Parameters:
[
"45c3c9ff-eb03-47b0-b7ae-f108b9031383"
]
|
| 106 | 0.19 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:
[
"8e25365a-aebd-4560-ba37-9d9a265cc7e5"
]
|
| 107 | 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.brand_id AS brand_id_6, t0.media_id AS media_id_7 FROM brands_medias t0 WHERE t0.brand_id = ?
Parameters:
[
"8e25365a-aebd-4560-ba37-9d9a265cc7e5"
]
|
| 108 | 0.38 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"
]
|
| 109 | 0.23 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"
]
|
| 110 | 0.23 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"
]
|
| 111 | 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_2"
]
|
| 112 | 0.26 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
]
|
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_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 | 24 |
| Fotoboom\Product\Domain\Media | 21 |
| Fotoboom\Media\Domain\MediaWatermark | 20 |
| Fotoboom\Product\Domain\Product | 18 |
| Fotoboom\Order\Domain\OrderProduct | 12 |
| Fotoboom\Order\Domain\Order | 10 |
| Fotoboom\Product\Domain\Category | 7 |
| Fotoboom\Product\Domain\FeatureValue | 7 |
| Fotoboom\Product\Domain\Brand | 5 |
| Fotoboom\Product\Domain\Feature | 5 |
| Fotoboom\Configuration\Domain\Configuration | 4 |
| Fotoboom\Product\Domain\ProductBox | 3 |
| Fotoboom\Product\Domain\BrandMedia | 3 |
| Fotoboom\User\Domain\User | 2 |
| Fotoboom\Product\Domain\ProductPack | 1 |