| 1 |
1.33 ms |
"START TRANSACTION"
"START TRANSACTION";
|
| 2 |
3.95 ms |
INSERT INTO sf_stat_catalog (type, ip, ref, date, fid, uid, found, time_local, time_cross, time_logic, microtime, brand_id, category_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters: [
"brand"
"216.73.216.246"
"/catalog/brand/11/200"
"2025-07-07 18:41:42"
8
0
43
0.106
0.0
0
0.206
11
200
]
INSERT INTO sf_stat_catalog (type, ip, ref, date, fid, uid, found, time_local, time_cross, time_logic, microtime, brand_id, category_id) VALUES ('brand', '216.73.216.246', '/catalog/brand/11/200', '2025-07-07 18:41:42', 8, 0, 43, 0.106, 0, 0, 0.206, 11, 200);
|
| 3 |
1.02 ms |
"COMMIT"
|
| 4 |
3.30 ms |
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.description AS description_2, s0_.is_active AS is_active_3, s0_.start_date AS start_date_4, s0_.end_date AS end_date_5, s0_.color AS color_6, s0_.icon AS icon_7 FROM sale_types s0_ WHERE s0_.start_date <= ? AND s0_.end_date >= ? AND s0_.is_active = 1
Parameters: [
"2025-07-07 18:41:42"
"2025-07-07 18:41:42"
]
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.description AS description_2, s0_.is_active AS is_active_3, s0_.start_date AS start_date_4, s0_.end_date AS end_date_5, s0_.color AS color_6, s0_.icon AS icon_7 FROM sale_types s0_ WHERE s0_.start_date <= '2025-07-07 18:41:42' AND s0_.end_date >= '2025-07-07 18:41:42' AND s0_.is_active = 1;
|
| 5 |
2.16 ms |
SELECT p0_.id AS id_0 FROM product_kit_items p0_ INNER JOIN product_kit p1_ ON (p0_.product_kit_id = p1_.id) INNER JOIN promo_kit p2_ ON (p2_.product_kit_id = p1_.id OR p2_.product_kit_id = p1_.parent_id) WHERE p0_.product_id = ? AND (p2_.date_finish IS NULL OR p2_.date_finish >= ?) AND p2_.public = 1
Parameters: [
1735433
"2025-07-07 18:41:42"
]
SELECT p0_.id AS id_0 FROM product_kit_items p0_ INNER JOIN product_kit p1_ ON (p0_.product_kit_id = p1_.id) INNER JOIN promo_kit p2_ ON (p2_.product_kit_id = p1_.id OR p2_.product_kit_id = p1_.parent_id) WHERE p0_.product_id = 1735433 AND (p2_.date_finish IS NULL OR p2_.date_finish >= '2025-07-07 18:41:42') AND p2_.public = 1;
|
| 6 |
1.68 ms |
SELECT p0_.id AS id_0 FROM product_kit_items p0_ INNER JOIN product_kit p1_ ON (p0_.product_kit_id = p1_.id) INNER JOIN promo_kit p2_ ON (p2_.product_kit_id = p1_.id OR p2_.product_kit_id = p1_.parent_id) WHERE p0_.product_id = ? AND (p2_.date_finish IS NULL OR p2_.date_finish >= ?) AND p2_.public = 1
Parameters: [
1735435
"2025-07-07 18:41:42"
]
SELECT p0_.id AS id_0 FROM product_kit_items p0_ INNER JOIN product_kit p1_ ON (p0_.product_kit_id = p1_.id) INNER JOIN promo_kit p2_ ON (p2_.product_kit_id = p1_.id OR p2_.product_kit_id = p1_.parent_id) WHERE p0_.product_id = 1735435 AND (p2_.date_finish IS NULL OR p2_.date_finish >= '2025-07-07 18:41:42') AND p2_.public = 1;
|
| 7 |
1.71 ms |
SELECT p0_.id AS id_0 FROM product_kit_items p0_ INNER JOIN product_kit p1_ ON (p0_.product_kit_id = p1_.id) INNER JOIN promo_kit p2_ ON (p2_.product_kit_id = p1_.id OR p2_.product_kit_id = p1_.parent_id) WHERE p0_.product_id = ? AND (p2_.date_finish IS NULL OR p2_.date_finish >= ?) AND p2_.public = 1
Parameters: [
1735437
"2025-07-07 18:41:42"
]
SELECT p0_.id AS id_0 FROM product_kit_items p0_ INNER JOIN product_kit p1_ ON (p0_.product_kit_id = p1_.id) INNER JOIN promo_kit p2_ ON (p2_.product_kit_id = p1_.id OR p2_.product_kit_id = p1_.parent_id) WHERE p0_.product_id = 1735437 AND (p2_.date_finish IS NULL OR p2_.date_finish >= '2025-07-07 18:41:42') AND p2_.public = 1;
|
| 8 |
2.95 ms |
SELECT p0_.id AS id_0 FROM product_kit_items p0_ INNER JOIN product_kit p1_ ON (p0_.product_kit_id = p1_.id) INNER JOIN promo_kit p2_ ON (p2_.product_kit_id = p1_.id OR p2_.product_kit_id = p1_.parent_id) WHERE p0_.product_id = ? AND (p2_.date_finish IS NULL OR p2_.date_finish >= ?) AND p2_.public = 1
Parameters: [
1735439
"2025-07-07 18:41:42"
]
SELECT p0_.id AS id_0 FROM product_kit_items p0_ INNER JOIN product_kit p1_ ON (p0_.product_kit_id = p1_.id) INNER JOIN promo_kit p2_ ON (p2_.product_kit_id = p1_.id OR p2_.product_kit_id = p1_.parent_id) WHERE p0_.product_id = 1735439 AND (p2_.date_finish IS NULL OR p2_.date_finish >= '2025-07-07 18:41:42') AND p2_.public = 1;
|
| 9 |
1.25 ms |
SELECT p0_.id AS id_0 FROM product_kit_items p0_ INNER JOIN product_kit p1_ ON (p0_.product_kit_id = p1_.id) INNER JOIN promo_kit p2_ ON (p2_.product_kit_id = p1_.id OR p2_.product_kit_id = p1_.parent_id) WHERE p0_.product_id = ? AND (p2_.date_finish IS NULL OR p2_.date_finish >= ?) AND p2_.public = 1
Parameters: [
1735440
"2025-07-07 18:41:42"
]
SELECT p0_.id AS id_0 FROM product_kit_items p0_ INNER JOIN product_kit p1_ ON (p0_.product_kit_id = p1_.id) INNER JOIN promo_kit p2_ ON (p2_.product_kit_id = p1_.id OR p2_.product_kit_id = p1_.parent_id) WHERE p0_.product_id = 1735440 AND (p2_.date_finish IS NULL OR p2_.date_finish >= '2025-07-07 18:41:42') AND p2_.public = 1;
|
| 10 |
2.22 ms |
SELECT p0_.id AS id_0 FROM product_kit_items p0_ INNER JOIN product_kit p1_ ON (p0_.product_kit_id = p1_.id) INNER JOIN promo_kit p2_ ON (p2_.product_kit_id = p1_.id OR p2_.product_kit_id = p1_.parent_id) WHERE p0_.product_id = ? AND (p2_.date_finish IS NULL OR p2_.date_finish >= ?) AND p2_.public = 1
Parameters: [
1735441
"2025-07-07 18:41:42"
]
SELECT p0_.id AS id_0 FROM product_kit_items p0_ INNER JOIN product_kit p1_ ON (p0_.product_kit_id = p1_.id) INNER JOIN promo_kit p2_ ON (p2_.product_kit_id = p1_.id OR p2_.product_kit_id = p1_.parent_id) WHERE p0_.product_id = 1735441 AND (p2_.date_finish IS NULL OR p2_.date_finish >= '2025-07-07 18:41:42') AND p2_.public = 1;
|
| 11 |
1.89 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.enabled AS enabled_3, t0.type AS type_4, t0.sort AS sort_5 FROM selection_type t0 WHERE t0.enabled = ? ORDER BY t0.sort DESC
SELECT t0.id AS id_1, t0.title AS title_2, t0.enabled AS enabled_3, t0.type AS type_4, t0.sort AS sort_5 FROM selection_type t0 WHERE t0.enabled = 1 ORDER BY t0.sort DESC;
|
| 12 |
1.17 ms |
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.description AS description_2, s0_.is_active AS is_active_3, s0_.start_date AS start_date_4, s0_.end_date AS end_date_5, s0_.color AS color_6, s0_.icon AS icon_7 FROM sale_types s0_ WHERE s0_.start_date <= ? AND s0_.end_date >= ? AND s0_.is_active = 1
Parameters: [
"2025-07-07 18:41:42"
"2025-07-07 18:41:42"
]
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.description AS description_2, s0_.is_active AS is_active_3, s0_.start_date AS start_date_4, s0_.end_date AS end_date_5, s0_.color AS color_6, s0_.icon AS icon_7 FROM sale_types s0_ WHERE s0_.start_date <= '2025-07-07 18:41:42' AND s0_.end_date >= '2025-07-07 18:41:42' AND s0_.is_active = 1;
|
| 13 |
1.06 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.enabled AS enabled_3, t0.type AS type_4, t0.sort AS sort_5 FROM selection_type t0 WHERE t0.enabled = ? ORDER BY t0.sort DESC
SELECT t0.id AS id_1, t0.title AS title_2, t0.enabled AS enabled_3, t0.type AS type_4, t0.sort AS sort_5 FROM selection_type t0 WHERE t0.enabled = 1 ORDER BY t0.sort DESC;
|
| 14 |
1.22 ms |
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.description AS description_2, s0_.is_active AS is_active_3, s0_.start_date AS start_date_4, s0_.end_date AS end_date_5, s0_.color AS color_6, s0_.icon AS icon_7 FROM sale_types s0_ WHERE s0_.start_date <= ? AND s0_.end_date >= ? AND s0_.is_active = 1
Parameters: [
"2025-07-07 18:41:42"
"2025-07-07 18:41:42"
]
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.description AS description_2, s0_.is_active AS is_active_3, s0_.start_date AS start_date_4, s0_.end_date AS end_date_5, s0_.color AS color_6, s0_.icon AS icon_7 FROM sale_types s0_ WHERE s0_.start_date <= '2025-07-07 18:41:42' AND s0_.end_date >= '2025-07-07 18:41:42' AND s0_.is_active = 1;
|