| 1 |
0.95 ms |
"START TRANSACTION"
"START TRANSACTION";
|
| 2 |
1.58 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.245"
"/catalog/brand/40/210"
"2025-07-07 06:56:56"
8
0
367
0.737
0.0
0
0.921
40
210
]
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.245', '/catalog/brand/40/210', '2025-07-07 06:56:56', 8, 0, 367, 0.737, 0, 0, 0.921, 40, 210);
|
| 3 |
0.81 ms |
"COMMIT"
|
| 4 |
0.78 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 06:56:56"
"2025-07-07 06:56:56"
]
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 06:56:56' AND s0_.end_date >= '2025-07-07 06:56:56' AND s0_.is_active = 1;
|
| 5 |
1.15 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: [
10025
"2025-07-07 06:56:56"
]
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 = 10025 AND (p2_.date_finish IS NULL OR p2_.date_finish >= '2025-07-07 06:56:56') AND p2_.public = 1;
|
| 6 |
1.07 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: [
10026
"2025-07-07 06:56:56"
]
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 = 10026 AND (p2_.date_finish IS NULL OR p2_.date_finish >= '2025-07-07 06:56:56') AND p2_.public = 1;
|
| 7 |
1.37 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: [
10031
"2025-07-07 06:56:56"
]
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 = 10031 AND (p2_.date_finish IS NULL OR p2_.date_finish >= '2025-07-07 06:56:56') AND p2_.public = 1;
|
| 8 |
1.13 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: [
19471
"2025-07-07 06:56:56"
]
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 = 19471 AND (p2_.date_finish IS NULL OR p2_.date_finish >= '2025-07-07 06:56:56') AND p2_.public = 1;
|
| 9 |
1.46 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: [
19460
"2025-07-07 06:56:56"
]
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 = 19460 AND (p2_.date_finish IS NULL OR p2_.date_finish >= '2025-07-07 06:56:56') AND p2_.public = 1;
|
| 10 |
1.37 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: [
19461
"2025-07-07 06:56:56"
]
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 = 19461 AND (p2_.date_finish IS NULL OR p2_.date_finish >= '2025-07-07 06:56:56') AND p2_.public = 1;
|
| 11 |
1.39 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.09 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 06:56:56"
"2025-07-07 06:56:56"
]
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 06:56:56' AND s0_.end_date >= '2025-07-07 06:56:56' AND s0_.is_active = 1;
|
| 13 |
1.12 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.03 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 06:56:56"
"2025-07-07 06:56:56"
]
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 06:56:56' AND s0_.end_date >= '2025-07-07 06:56:56' AND s0_.is_active = 1;
|