# | Time | Since previous | Level | Category | Message |
---|---|---|---|---|---|
1 | 16:56:33.145 | < 0ms > | info | yii\web\Session::open | Session started |
2 | 16:56:33.206 | info | yii\db\Connection::open | Opening DB connection: mysql:host=localhost;dbname=lh2025 | |
3 | 16:56:33.211 | info | yii\db\Command::query | SELECT * FROM `seos_sections` WHERE `slug`='catalog' | |
4 | 16:56:33.211 | info | yii\db\Command::query | SHOW FULL COLUMNS FROM `seos_sections` | |
5 | 16:56:33.212 | info | yii\db\Command::query | SHOW CREATE TABLE `seos_sections` | |
6 | 16:56:33.213 | info | yii\db\Command::query | SELECT `kcu`.`CONSTRAINT_NAME` AS `constraint_name`, `kcu`.`COLUMN_NAME` AS `column_name`, `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`, `kcu`.`REFERENCED_COLUMN_NAME` AS `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` = 'seos_sections' AND `kcu`.`TABLE_NAME` = 'seos_sections' | |
7 | 16:56:33.228 | info | yii\db\Command::query | SELECT COUNT(*) FROM `good` WHERE (`good`.`is_delete`=0) AND (`good`.`visibility`=1) | |
8 | 16:56:33.230 | info | yii\db\Command::query | SELECT * FROM `good` WHERE (`good`.`is_delete`=0) AND (`good`.`visibility`=1) LIMIT 12 | |
9 | 16:56:33.236 | info | yii\db\Command::query | SHOW FULL COLUMNS FROM `good` | |
10 | 16:56:33.237 | info | yii\db\Command::query | SHOW CREATE TABLE `good` | |
11 | 16:56:33.237 | info | yii\db\Command::query | SELECT `kcu`.`CONSTRAINT_NAME` AS `constraint_name`, `kcu`.`COLUMN_NAME` AS `column_name`, `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`, `kcu`.`REFERENCED_COLUMN_NAME` AS `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` = 'good' AND `kcu`.`TABLE_NAME` = 'good' | |
12 | 16:56:33.248 | info | yii\db\Command::query | SELECT * FROM `category` WHERE (`visibility`=1) AND (`parent_id`=0) ORDER BY `sort` | |
13 | 16:56:33.249 | info | yii\db\Command::query | SHOW FULL COLUMNS FROM `category` | |
14 | 16:56:33.249 | info | yii\db\Command::query | SHOW CREATE TABLE `category` | |
15 | 16:56:33.250 | info | yii\db\Command::query | SELECT `kcu`.`CONSTRAINT_NAME` AS `constraint_name`, `kcu`.`COLUMN_NAME` AS `column_name`, `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`, `kcu`.`REFERENCED_COLUMN_NAME` AS `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` = 'category' AND `kcu`.`TABLE_NAME` = 'category' | |
16 | 16:56:33.257 | info | yii\db\Command::query | SELECT * FROM `category` WHERE (`is_delete`=0) AND (`parent_id` IN (2, 11, 15, 24, 28, 29, 41, 33, 21, 9, 31)) ORDER BY `name` | |
17 | 16:56:33.259 | info | yii\db\Command::query | SELECT * FROM `good` WHERE ((`good`.`visibility`=1) AND (`good`.`is_delete`=0)) AND (`category_id` IN (14, 22, 36, 42, 23, 3, 17)) | |
18 | 16:56:33.268 | info | yii\db\Command::query | SELECT * FROM `good` WHERE ((`good`.`visibility`=1) AND (`good`.`is_delete`=0)) AND (`category_id` IN (2, 11, 15, 24, 28, 29, 41, 33, 21, 9, 31)) | |
19 | 16:56:33.278 | info | yii\db\Command::query | SELECT * FROM `image` WHERE (`itemId`=24) AND (`modelName`='Good') AND (`name`='prev') ORDER BY `isMain` DESC, `id` | |
20 | 16:56:33.279 | info | yii\db\Command::query | SHOW FULL COLUMNS FROM `image` | |
21 | 16:56:33.280 | info | yii\db\Command::query | SHOW CREATE TABLE `image` | |
22 | 16:56:33.280 | info | yii\db\Command::query | SELECT `kcu`.`CONSTRAINT_NAME` AS `constraint_name`, `kcu`.`COLUMN_NAME` AS `column_name`, `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`, `kcu`.`REFERENCED_COLUMN_NAME` AS `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` = 'image' AND `kcu`.`TABLE_NAME` = 'image' | |
23 | 16:56:33.283 | info | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `model` WHERE `good_id`=24) | |
24 | 16:56:33.284 | info | yii\db\Command::query | SELECT * FROM `image` WHERE (`itemId`=160) AND (`modelName`='Good') AND (`name`='prev') ORDER BY `isMain` DESC, `id` | |
25 | 16:56:33.284 | info | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `model` WHERE `good_id`=160) | |
26 | 16:56:33.285 | info | yii\db\Command::query | SELECT * FROM `image` WHERE (`itemId`=161) AND (`modelName`='Good') AND (`name`='prev') ORDER BY `isMain` DESC, `id` | |
27 | 16:56:33.286 | info | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `model` WHERE `good_id`=161) | |
28 | 16:56:33.287 | info | yii\db\Command::query | SELECT * FROM `image` WHERE (`itemId`=162) AND (`modelName`='Good') AND (`name`='prev') ORDER BY `isMain` DESC, `id` | |
29 | 16:56:33.288 | info | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `model` WHERE `good_id`=162) | |
30 | 16:56:33.289 | info | yii\db\Command::query | SELECT * FROM `image` WHERE (`itemId`=163) AND (`modelName`='Good') AND (`name`='prev') ORDER BY `isMain` DESC, `id` | |
31 | 16:56:33.290 | info | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `model` WHERE `good_id`=163) | |
32 | 16:56:33.291 | info | yii\db\Command::query | SELECT * FROM `image` WHERE (`itemId`=164) AND (`modelName`='Good') AND (`name`='prev') ORDER BY `isMain` DESC, `id` | |
33 | 16:56:33.292 | info | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `model` WHERE `good_id`=164) | |
34 | 16:56:33.293 | info | yii\db\Command::query | SELECT * FROM `image` WHERE (`itemId`=165) AND (`modelName`='Good') AND (`name`='prev') ORDER BY `isMain` DESC, `id` | |
35 | 16:56:33.294 | info | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `model` WHERE `good_id`=165) | |
36 | 16:56:33.295 | info | yii\db\Command::query | SELECT * FROM `image` WHERE (`itemId`=166) AND (`modelName`='Good') AND (`name`='prev') ORDER BY `isMain` DESC, `id` | |
37 | 16:56:33.296 | info | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `model` WHERE `good_id`=166) | |
38 | 16:56:33.296 | info | yii\db\Command::query | SELECT * FROM `image` WHERE (`itemId`=167) AND (`modelName`='Good') AND (`name`='prev') ORDER BY `isMain` DESC, `id` | |
39 | 16:56:33.297 | info | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `model` WHERE `good_id`=167) | |
40 | 16:56:33.297 | info | yii\db\Command::query | SELECT * FROM `image` WHERE (`itemId`=168) AND (`modelName`='Good') AND (`name`='prev') ORDER BY `isMain` DESC, `id` | |
41 | 16:56:33.298 | info | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `model` WHERE `good_id`=168) | |
42 | 16:56:33.298 | info | yii\db\Command::query | SELECT * FROM `image` WHERE (`itemId`=169) AND (`modelName`='Good') AND (`name`='prev') ORDER BY `isMain` DESC, `id` | |
43 | 16:56:33.299 | info | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `model` WHERE `good_id`=169) | |
44 | 16:56:33.300 | info | yii\db\Command::query | SELECT * FROM `image` WHERE (`itemId`=170) AND (`modelName`='Good') AND (`name`='prev') ORDER BY `isMain` DESC, `id` | |
45 | 16:56:33.301 | info | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `model` WHERE `good_id`=170) | |
46 | 16:56:33.311 | info | yii\db\Command::query | SELECT * FROM `category` WHERE (`category`.`visibility`=1) AND (`parent_id`=0) ORDER BY `name` | |
47 | 16:56:33.313 | info | yii\db\Command::query | SELECT * FROM `category` WHERE (`is_delete`=0) AND (`parent_id`=15) ORDER BY `name` | |
48 | 16:56:33.313 | info | yii\db\Command::query | SELECT * FROM `category` WHERE (`is_delete`=0) AND (`parent_id`=29) ORDER BY `name` | |
49 | 16:56:33.314 | info | yii\db\Command::query | SELECT * FROM `category` WHERE (`is_delete`=0) AND (`parent_id`=41) ORDER BY `name` | |
50 | 16:56:33.315 | info | yii\db\Command::query | SELECT * FROM `category` WHERE (`is_delete`=0) AND (`parent_id`=11) ORDER BY `name` | |
51 | 16:56:33.315 | info | yii\db\Command::query | SELECT * FROM `category` WHERE (`is_delete`=0) AND (`parent_id`=31) ORDER BY `name` | |
52 | 16:56:33.316 | info | yii\db\Command::query | SELECT * FROM `category` WHERE (`is_delete`=0) AND (`parent_id`=33) ORDER BY `name` | |
53 | 16:56:33.317 | info | yii\db\Command::query | SELECT * FROM `category` WHERE (`is_delete`=0) AND (`parent_id`=28) ORDER BY `name` | |
54 | 16:56:33.318 | info | yii\db\Command::query | SELECT * FROM `category` WHERE (`is_delete`=0) AND (`parent_id`=9) ORDER BY `name` | |
55 | 16:56:33.318 | info | yii\db\Command::query | SELECT * FROM `category` WHERE (`is_delete`=0) AND (`parent_id`=21) ORDER BY `name` | |
56 | 16:56:33.319 | info | yii\db\Command::query | SELECT * FROM `category` WHERE (`is_delete`=0) AND (`parent_id`=24) ORDER BY `name` | |
57 | 16:56:33.320 | < 0ms > | info | yii\db\Command::query | SELECT * FROM `category` WHERE (`is_delete`=0) AND (`parent_id`=2) ORDER BY `name` |