1 |
2.23 ms |
SELECT t0.id AS id_1, t0.user_id AS user_id_2, t0.display AS display_3, t0.search AS search_4, t0.basket AS basket_5, t0.button AS button_6 FROM extracharge t0 WHERE t0.user_id IS NULL LIMIT 1
SELECT t0.id AS id_1, t0.user_id AS user_id_2, t0.display AS display_3, t0.search AS search_4, t0.basket AS basket_5, t0.button AS button_6 FROM extracharge t0 WHERE t0.user_id IS NULL LIMIT 1;
|
2 |
1.80 ms |
"START TRANSACTION"
"START TRANSACTION";
|
3 |
3.61 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: [
"group"
"216.73.216.245"
"/catalog/chemistry/183"
"2025-07-07 01:01:10"
8
0
69
0.59
0.0
0
0.638
null
null
]
INSERT INTO sf_stat_catalog (type, ip, ref, date, fid, uid, found, time_local, time_cross, time_logic, microtime, brand_id, category_id) VALUES ('group', '216.73.216.245', '/catalog/chemistry/183', '2025-07-07 01:01:10', 8, 0, 69, 0.59, 0, 0, 0.638, NULL, NULL);
|
4 |
3.46 ms |
"COMMIT"
|
5 |
2.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 01:01:10"
"2025-07-07 01:01:10"
]
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 01:01:10' AND s0_.end_date >= '2025-07-07 01:01:10' AND s0_.is_active = 1;
|
6 |
2.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: [
1825125
"2025-07-07 01:01:10"
]
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 = 1825125 AND (p2_.date_finish IS NULL OR p2_.date_finish >= '2025-07-07 01:01:10') AND p2_.public = 1;
|
7 |
1.84 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: [
1825127
"2025-07-07 01:01:10"
]
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 = 1825127 AND (p2_.date_finish IS NULL OR p2_.date_finish >= '2025-07-07 01:01:10') AND p2_.public = 1;
|
8 |
1.17 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: [
1825128
"2025-07-07 01:01:10"
]
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 = 1825128 AND (p2_.date_finish IS NULL OR p2_.date_finish >= '2025-07-07 01:01:10') AND p2_.public = 1;
|
9 |
1.17 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: [
1741020
"2025-07-07 01:01:10"
]
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 = 1741020 AND (p2_.date_finish IS NULL OR p2_.date_finish >= '2025-07-07 01:01:10') AND p2_.public = 1;
|
10 |
0.64 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;
|
11 |
0.72 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 01:01:10"
"2025-07-07 01:01:10"
]
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 01:01:10' AND s0_.end_date >= '2025-07-07 01:01:10' AND s0_.is_active = 1;
|
12 |
0.70 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;
|
13 |
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 01:01:10"
"2025-07-07 01:01:10"
]
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 01:01:10' AND s0_.end_date >= '2025-07-07 01:01:10' AND s0_.is_active = 1;
|