# | Time | Since previous | Level | Category | Message |
---|---|---|---|---|---|
1 | 23:12:37.162 | < 0ms > | info | yii\db\Connection::open | Opening DB connection: mysql:host=localhost;dbname=lh2025 |
2 | 23:12:37.167 | info | yii\db\Command::query | SELECT * FROM `seos_sections` WHERE `slug`='catalog' | |
3 | 23:12:37.167 | info | yii\db\Command::query | SHOW FULL COLUMNS FROM `seos_sections` | |
4 | 23:12:37.168 | info | yii\db\Command::query | SHOW CREATE TABLE `seos_sections` | |
5 | 23:12:37.169 | 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' | |
6 | 23:12:37.184 | info | yii\db\Command::query | SELECT COUNT(*) FROM `good` WHERE (`good`.`is_delete`=0) AND (`good`.`visibility`=1) | |
7 | 23:12:37.186 | info | yii\db\Command::query | SELECT * FROM `good` WHERE (`good`.`is_delete`=0) AND (`good`.`visibility`=1) LIMIT 12 | |
8 | 23:12:37.192 | info | yii\db\Command::query | SHOW FULL COLUMNS FROM `good` | |
9 | 23:12:37.192 | info | yii\db\Command::query | SHOW CREATE TABLE `good` | |
10 | 23:12:37.193 | 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' | |
11 | 23:12:37.204 | info | yii\db\Command::query | SELECT * FROM `category` WHERE (`visibility`=1) AND (`parent_id`=0) ORDER BY `sort` | |
12 | 23:12:37.205 | info | yii\db\Command::query | SHOW FULL COLUMNS FROM `category` | |
13 | 23:12:37.205 | info | yii\db\Command::query | SHOW CREATE TABLE `category` | |
14 | 23:12:37.206 | 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' | |
15 | 23:12:37.210 | 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` | |
16 | 23:12:37.212 | 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)) | |
17 | 23:12:37.222 | 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)) | |
18 | 23:12:37.233 | info | yii\db\Command::query | SELECT * FROM `image` WHERE (`itemId`=24) AND (`modelName`='Good') AND (`name`='prev') ORDER BY `isMain` DESC, `id` | |
19 | 23:12:37.234 | info | yii\db\Command::query | SHOW FULL COLUMNS FROM `image` | |
20 | 23:12:37.234 | info | yii\db\Command::query | SHOW CREATE TABLE `image` | |
21 | 23:12:37.235 | 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' | |
22 | 23:12:37.238 | info | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `model` WHERE `good_id`=24) | |
23 | 23:12:37.239 | info | yii\db\Command::query | SELECT * FROM `image` WHERE (`itemId`=160) AND (`modelName`='Good') AND (`name`='prev') ORDER BY `isMain` DESC, `id` | |
24 | 23:12:37.240 | info | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `model` WHERE `good_id`=160) | |
25 | 23:12:37.241 | info | yii\db\Command::query | SELECT * FROM `image` WHERE (`itemId`=161) AND (`modelName`='Good') AND (`name`='prev') ORDER BY `isMain` DESC, `id` | |
26 | 23:12:37.241 | info | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `model` WHERE `good_id`=161) | |
27 | 23:12:37.242 | info | yii\db\Command::query | SELECT * FROM `image` WHERE (`itemId`=162) AND (`modelName`='Good') AND (`name`='prev') ORDER BY `isMain` DESC, `id` | |
28 | 23:12:37.243 | info | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `model` WHERE `good_id`=162) | |
29 | 23:12:37.245 | info | yii\db\Command::query | SELECT * FROM `image` WHERE (`itemId`=163) AND (`modelName`='Good') AND (`name`='prev') ORDER BY `isMain` DESC, `id` | |
30 | 23:12:37.246 | info | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `model` WHERE `good_id`=163) | |
31 | 23:12:37.246 | info | yii\db\Command::query | SELECT * FROM `image` WHERE (`itemId`=164) AND (`modelName`='Good') AND (`name`='prev') ORDER BY `isMain` DESC, `id` | |
32 | 23:12:37.247 | info | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `model` WHERE `good_id`=164) | |
33 | 23:12:37.248 | info | yii\db\Command::query | SELECT * FROM `image` WHERE (`itemId`=165) AND (`modelName`='Good') AND (`name`='prev') ORDER BY `isMain` DESC, `id` | |
34 | 23:12:37.253 | info | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `model` WHERE `good_id`=165) | |
35 | 23:12:37.254 | info | yii\db\Command::query | SELECT * FROM `image` WHERE (`itemId`=166) AND (`modelName`='Good') AND (`name`='prev') ORDER BY `isMain` DESC, `id` | |
36 | 23:12:37.256 | info | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `model` WHERE `good_id`=166) | |
37 | 23:12:37.257 | info | yii\db\Command::query | SELECT * FROM `image` WHERE (`itemId`=167) AND (`modelName`='Good') AND (`name`='prev') ORDER BY `isMain` DESC, `id` | |
38 | 23:12:37.260 | info | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `model` WHERE `good_id`=167) | |
39 | 23:12:37.261 | info | yii\db\Command::query | SELECT * FROM `image` WHERE (`itemId`=168) AND (`modelName`='Good') AND (`name`='prev') ORDER BY `isMain` DESC, `id` | |
40 | 23:12:37.261 | info | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `model` WHERE `good_id`=168) | |
41 | 23:12:37.262 | info | yii\db\Command::query | SELECT * FROM `image` WHERE (`itemId`=169) AND (`modelName`='Good') AND (`name`='prev') ORDER BY `isMain` DESC, `id` | |
42 | 23:12:37.263 | info | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `model` WHERE `good_id`=169) | |
43 | 23:12:37.263 | info | yii\db\Command::query | SELECT * FROM `image` WHERE (`itemId`=170) AND (`modelName`='Good') AND (`name`='prev') ORDER BY `isMain` DESC, `id` | |
44 | 23:12:37.264 | info | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `model` WHERE `good_id`=170) | |
45 | 23:12:37.279 | info | yii\db\Command::query | SELECT * FROM `category` WHERE (`category`.`visibility`=1) AND (`parent_id`=0) ORDER BY `name` | |
46 | 23:12:37.281 | info | yii\db\Command::query | SELECT * FROM `category` WHERE (`is_delete`=0) AND (`parent_id`=15) ORDER BY `name` | |
47 | 23:12:37.281 | info | yii\db\Command::query | SELECT * FROM `category` WHERE (`is_delete`=0) AND (`parent_id`=29) ORDER BY `name` | |
48 | 23:12:37.282 | info | yii\db\Command::query | SELECT * FROM `category` WHERE (`is_delete`=0) AND (`parent_id`=41) ORDER BY `name` | |
49 | 23:12:37.283 | info | yii\db\Command::query | SELECT * FROM `category` WHERE (`is_delete`=0) AND (`parent_id`=11) ORDER BY `name` | |
50 | 23:12:37.283 | info | yii\db\Command::query | SELECT * FROM `category` WHERE (`is_delete`=0) AND (`parent_id`=31) ORDER BY `name` | |
51 | 23:12:37.284 | info | yii\db\Command::query | SELECT * FROM `category` WHERE (`is_delete`=0) AND (`parent_id`=33) ORDER BY `name` | |
52 | 23:12:37.284 | info | yii\db\Command::query | SELECT * FROM `category` WHERE (`is_delete`=0) AND (`parent_id`=28) ORDER BY `name` | |
53 | 23:12:37.285 | info | yii\db\Command::query | SELECT * FROM `category` WHERE (`is_delete`=0) AND (`parent_id`=9) ORDER BY `name` | |
54 | 23:12:37.286 | info | yii\db\Command::query | SELECT * FROM `category` WHERE (`is_delete`=0) AND (`parent_id`=21) ORDER BY `name` | |
55 | 23:12:37.287 | info | yii\db\Command::query | SELECT * FROM `category` WHERE (`is_delete`=0) AND (`parent_id`=24) ORDER BY `name` | |
56 | 23:12:37.287 | info | yii\db\Command::query | SELECT * FROM `category` WHERE (`is_delete`=0) AND (`parent_id`=2) ORDER BY `name` | |
57 | 23:12:37.289 | < 1ms > | info | yii\web\Session::open | Session started |