1 |
0.56 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.position AS position_4, t0.is_active AS is_active_5, t0.image AS image_6 FROM category t0 WHERE t0.slug = ? LIMIT 1
Parameters: [
"beaute-and-bien-etre"
]
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.position AS position_4, t0.is_active AS is_active_5, t0.image AS image_6 FROM category t0 WHERE t0.slug = 'beaute-and-bien-etre' LIMIT 1;
|
2 |
0.52 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.position AS position_4, t0.is_active AS is_active_5, t0.image AS image_6 FROM category t0 WHERE t0.slug = ? LIMIT 1
Parameters: [
"beaute-and-bien-etre"
]
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.position AS position_4, t0.is_active AS is_active_5, t0.image AS image_6 FROM category t0 WHERE t0.slug = 'beaute-and-bien-etre' LIMIT 1;
|
3 |
0.84 ms |
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.extra AS extra_2, p0_.slug AS slug_3, p0_.description AS description_4, p0_.origin AS origin_5, p0_.price AS price_6, p0_.stock AS stock_7, p0_.sku AS sku_8, p0_.weight AS weight_9, p0_.created_at AS created_at_10, p0_.updated_at AS updated_at_11, p0_.reference AS reference_12, p0_.status AS status_13, p0_.is_mts_product AS is_mts_product_14 FROM product p0_ WHERE (p0_.status = ? OR p0_.status = ?) AND p0_.category_id IS NOT NULL AND p0_.category_id = ? ORDER BY p0_.id DESC) dctrn_result) dctrn_table
Parameters: [
"active"
"out-of-stock"
7
]
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.extra AS extra_2, p0_.slug AS slug_3, p0_.description AS description_4, p0_.origin AS origin_5, p0_.price AS price_6, p0_.stock AS stock_7, p0_.sku AS sku_8, p0_.weight AS weight_9, p0_.created_at AS created_at_10, p0_.updated_at AS updated_at_11, p0_.reference AS reference_12, p0_.status AS status_13, p0_.is_mts_product AS is_mts_product_14 FROM product p0_ WHERE (p0_.status = 'active' OR p0_.status = 'out-of-stock') AND p0_.category_id IS NOT NULL AND p0_.category_id = 7 ORDER BY p0_.id DESC) dctrn_result) dctrn_table;
|
4 |
3.08 ms |
SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0 FROM (SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.extra AS extra_2, p0_.slug AS slug_3, p0_.description AS description_4, p0_.origin AS origin_5, p0_.price AS price_6, p0_.stock AS stock_7, p0_.sku AS sku_8, p0_.weight AS weight_9, p0_.created_at AS created_at_10, p0_.updated_at AS updated_at_11, p0_.reference AS reference_12, p0_.status AS status_13, p0_.is_mts_product AS is_mts_product_14 FROM product p0_ WHERE (p0_.status = ? OR p0_.status = ?) AND p0_.category_id IS NOT NULL AND p0_.category_id = ?) dctrn_result_inner ORDER BY id_0 DESC) dctrn_result LIMIT 36
Parameters: [
"active"
"out-of-stock"
7
]
SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0 FROM (SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.extra AS extra_2, p0_.slug AS slug_3, p0_.description AS description_4, p0_.origin AS origin_5, p0_.price AS price_6, p0_.stock AS stock_7, p0_.sku AS sku_8, p0_.weight AS weight_9, p0_.created_at AS created_at_10, p0_.updated_at AS updated_at_11, p0_.reference AS reference_12, p0_.status AS status_13, p0_.is_mts_product AS is_mts_product_14 FROM product p0_ WHERE (p0_.status = 'active' OR p0_.status = 'out-of-stock') AND p0_.category_id IS NOT NULL AND p0_.category_id = 7) dctrn_result_inner ORDER BY id_0 DESC) dctrn_result LIMIT 36;
|
5 |
0.48 ms |
SELECT t0.id AS id_1, t0.setting_key AS setting_key_2, t0.setting_value AS setting_value_3 FROM site_setting t0 WHERE t0.setting_key = ? LIMIT 1
Parameters: [
"address_ofici"
]
SELECT t0.id AS id_1, t0.setting_key AS setting_key_2, t0.setting_value AS setting_value_3 FROM site_setting t0 WHERE t0.setting_key = 'address_ofici' LIMIT 1;
|
6 |
0.27 ms |
SELECT t0.id AS id_1, t0.setting_key AS setting_key_2, t0.setting_value AS setting_value_3 FROM site_setting t0 WHERE t0.setting_key = ? LIMIT 1
Parameters: [
"contact_email"
]
SELECT t0.id AS id_1, t0.setting_key AS setting_key_2, t0.setting_value AS setting_value_3 FROM site_setting t0 WHERE t0.setting_key = 'contact_email' LIMIT 1;
|
7 |
0.21 ms |
SELECT t0.id AS id_1, t0.setting_key AS setting_key_2, t0.setting_value AS setting_value_3 FROM site_setting t0 WHERE t0.setting_key = ? LIMIT 1
Parameters: [
"contact_phone"
]
SELECT t0.id AS id_1, t0.setting_key AS setting_key_2, t0.setting_value AS setting_value_3 FROM site_setting t0 WHERE t0.setting_key = 'contact_phone' LIMIT 1;
|
8 |
0.24 ms |
SELECT t0.id AS id_1, t0.setting_key AS setting_key_2, t0.setting_value AS setting_value_3 FROM site_setting t0 WHERE t0.setting_key = ? LIMIT 1
Parameters: [
"facebook_link"
]
SELECT t0.id AS id_1, t0.setting_key AS setting_key_2, t0.setting_value AS setting_value_3 FROM site_setting t0 WHERE t0.setting_key = 'facebook_link' LIMIT 1;
|
9 |
0.23 ms |
SELECT t0.id AS id_1, t0.setting_key AS setting_key_2, t0.setting_value AS setting_value_3 FROM site_setting t0 WHERE t0.setting_key = ? LIMIT 1
Parameters: [
"instagram_link"
]
SELECT t0.id AS id_1, t0.setting_key AS setting_key_2, t0.setting_value AS setting_value_3 FROM site_setting t0 WHERE t0.setting_key = 'instagram_link' LIMIT 1;
|
10 |
0.20 ms |
SELECT t0.id AS id_1, t0.setting_key AS setting_key_2, t0.setting_value AS setting_value_3 FROM site_setting t0 WHERE t0.setting_key = ? LIMIT 1
Parameters: [
"linkedin_link"
]
SELECT t0.id AS id_1, t0.setting_key AS setting_key_2, t0.setting_value AS setting_value_3 FROM site_setting t0 WHERE t0.setting_key = 'linkedin_link' LIMIT 1;
|
11 |
0.23 ms |
SELECT t0.id AS id_1, t0.setting_key AS setting_key_2, t0.setting_value AS setting_value_3 FROM site_setting t0 WHERE t0.setting_key = ? LIMIT 1
SELECT t0.id AS id_1, t0.setting_key AS setting_key_2, t0.setting_value AS setting_value_3 FROM site_setting t0 WHERE t0.setting_key = 'x_link' LIMIT 1;
|
12 |
0.50 ms |
SELECT t0.id AS id_1, t0.setting_key AS setting_key_2, t0.setting_value AS setting_value_3 FROM site_setting t0 WHERE t0.setting_key = ? LIMIT 1
Parameters: [
"tiktok_link"
]
SELECT t0.id AS id_1, t0.setting_key AS setting_key_2, t0.setting_value AS setting_value_3 FROM site_setting t0 WHERE t0.setting_key = 'tiktok_link' LIMIT 1;
|
13 |
3.94 ms |
SELECT t0.id AS id_1, t0.setting_key AS setting_key_2, t0.setting_value AS setting_value_3 FROM site_setting t0 WHERE t0.setting_key = ? LIMIT 1
Parameters: [
"youtube_link"
]
SELECT t0.id AS id_1, t0.setting_key AS setting_key_2, t0.setting_value AS setting_value_3 FROM site_setting t0 WHERE t0.setting_key = 'youtube_link' LIMIT 1;
|
14 |
0.49 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.position AS position_4, t0.is_active AS is_active_5, t0.image AS image_6 FROM category t0 ORDER BY t0.position ASC
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.position AS position_4, t0.is_active AS is_active_5, t0.image AS image_6 FROM category t0 ORDER BY t0.position ASC;
|
15 |
0.52 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.position AS position_4, t0.category_id AS category_id_5 FROM subcategory t0 WHERE t0.category_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.position AS position_4, t0.category_id AS category_id_5 FROM subcategory t0 WHERE t0.category_id = 1;
|
16 |
0.33 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.position AS position_4, t0.category_id AS category_id_5 FROM subcategory t0 WHERE t0.category_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.position AS position_4, t0.category_id AS category_id_5 FROM subcategory t0 WHERE t0.category_id = 2;
|
17 |
0.30 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.position AS position_4, t0.category_id AS category_id_5 FROM subcategory t0 WHERE t0.category_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.position AS position_4, t0.category_id AS category_id_5 FROM subcategory t0 WHERE t0.category_id = 3;
|
18 |
0.26 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.position AS position_4, t0.category_id AS category_id_5 FROM subcategory t0 WHERE t0.category_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.position AS position_4, t0.category_id AS category_id_5 FROM subcategory t0 WHERE t0.category_id = 4;
|
19 |
1.59 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.position AS position_4, t0.category_id AS category_id_5 FROM subcategory t0 WHERE t0.category_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.position AS position_4, t0.category_id AS category_id_5 FROM subcategory t0 WHERE t0.category_id = 5;
|
20 |
0.30 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.position AS position_4, t0.category_id AS category_id_5 FROM subcategory t0 WHERE t0.category_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.position AS position_4, t0.category_id AS category_id_5 FROM subcategory t0 WHERE t0.category_id = 6;
|
21 |
0.27 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.position AS position_4, t0.category_id AS category_id_5 FROM subcategory t0 WHERE t0.category_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.position AS position_4, t0.category_id AS category_id_5 FROM subcategory t0 WHERE t0.category_id = 7;
|