6877de75c4cd4: GET http://feniks.gisgkx.ru/catalog/index at 2025-07-16 05:16:37 pm by 185.191.171.8
Database Queries
Всего 11 записей.
| Time | Duration | Type | Duplicated | Query |
|---|---|---|---|---|
| 17:16:37.826 | 11.9 ms | SELECT | 1 | SELECT * FROM `shop_categories` WHERE (`slug`='index') AND (`depth` > 0) |
| 17:16:37.847 | 0.4 ms | SHOW | 1 | SHOW FULL COLUMNS FROM `shop_categories` |
| 17:16:37.847 | 8.0 ms | SELECT | 1 | SELECT
kcu.constraint_name,
kcu.column_name,
kcu.referenced_table_name,
kcu.referenced_column_name
FROM information_schema.referential_constraints AS rc
JOIN information_schema.key_column_usage AS kcu ON
(
kcu.constraint_catalog = rc.constraint_catalog OR
(kcu.constraint_catalog IS NULL AND rc.constraint_catalog IS NULL)
) AND
kcu.constraint_schema = rc.constraint_schema AND
kcu.constraint_name = rc.constraint_name
WHERE rc.constraint_schema = database() AND kcu.table_schema = database()
AND rc.table_name = 'shop_categories' AND kcu.table_name = 'shop_categories' |
| 17:16:37.864 | 0.3 ms | SELECT | 1 | SELECT * FROM `shop_categories` WHERE (`shop_categories`.`lft` < 2) AND (`shop_categories`.`rgt` > 3) AND (`depth` > 0) ORDER BY `shop_categories`.`lft` |
| 17:16:37.868 | 9.3 ms | SELECT | 1 | SELECT * FROM `shop_categories` WHERE (`id`=3) AND (`depth` > 0) |
| 17:16:37.894 | 0.4 ms | SELECT | 1 | SELECT `id` FROM `shop_categories` WHERE (`shop_categories`.`lft` > 2) AND (`shop_categories`.`lft` < 3) ORDER BY `shop_categories`.`lft` |
| 17:16:37.897 | 0.3 ms | SELECT | 1 | SELECT * FROM `shop_categories` WHERE (`shop_categories`.`lft` < 2) AND (`shop_categories`.`rgt` > 3) ORDER BY `shop_categories`.`lft` |
| 17:16:37.898 | 0.3 ms | SELECT | 1 | SELECT * FROM `shop_categories` WHERE (`shop_categories`.`lft` > 2) AND (`shop_categories`.`lft` < 3) AND (`shop_categories`.`depth` <= 2) ORDER BY `shop_categories`.`lft` |
| 17:16:37.902 | 18.4 ms | SELECT | 1 | SELECT COUNT(*) FROM (SELECT `p`.* FROM `shop_products` `p` LEFT JOIN `shop_category_assignments` `ca` ON `p`.`id` = `ca`.`product_id` WHERE (`p`.`status`=1) AND ((`p`.`category_id`=3) OR (`ca`.`category_id`=3)) GROUP BY `p`.`id`) `c` |
| 17:16:37.921 | 0.3 ms | SHOW | 1 | SHOW FULL COLUMNS FROM `shop_products` |
| 17:16:37.921 | 0.9 ms | SELECT | 1 | SELECT
kcu.constraint_name,
kcu.column_name,
kcu.referenced_table_name,
kcu.referenced_column_name
FROM information_schema.referential_constraints AS rc
JOIN information_schema.key_column_usage AS kcu ON
(
kcu.constraint_catalog = rc.constraint_catalog OR
(kcu.constraint_catalog IS NULL AND rc.constraint_catalog IS NULL)
) AND
kcu.constraint_schema = rc.constraint_schema AND
kcu.constraint_name = rc.constraint_name
WHERE rc.constraint_schema = database() AND kcu.table_schema = database()
AND rc.table_name = 'shop_products' AND kcu.table_name = 'shop_products' |