# | Time | Since previous | Level | Category | Message |
---|---|---|---|---|---|
1 | 16:56:41.326 | < 0ms > | info | yii\web\Session::open | Session started |
2 | 16:56:41.387 | info | yii\db\Connection::open | Opening DB connection: mysql:host=localhost;dbname=lh2025 | |
3 | 16:56:41.396 | info | yii\db\Command::query | SELECT * FROM `seos_sections` WHERE `slug`='catalog' | |
4 | 16:56:41.397 | info | yii\db\Command::query | SHOW FULL COLUMNS FROM `seos_sections` | |
5 | 16:56:41.398 | info | yii\db\Command::query | SHOW CREATE TABLE `seos_sections` | |
6 | 16:56:41.399 | 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:41.418 | info | yii\db\Command::query | SELECT COUNT(*) FROM `good` WHERE (`good`.`is_delete`=0) AND (`good`.`visibility`=1) | |
8 | 16:56:41.420 | info | yii\db\Command::query | SELECT * FROM `good` WHERE (`good`.`is_delete`=0) AND (`good`.`visibility`=1) LIMIT 12 | |
9 | 16:56:41.425 | info | yii\db\Command::query | SHOW FULL COLUMNS FROM `good` | |
10 | 16:56:41.425 | info | yii\db\Command::query | SHOW CREATE TABLE `good` | |
11 | 16:56:41.426 | 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:41.436 | info | yii\db\Command::query | SELECT * FROM `category` WHERE (`visibility`=1) AND (`parent_id`=0) ORDER BY `sort` | |
13 | 16:56:41.436 | info | yii\db\Command::query | SHOW FULL COLUMNS FROM `category` | |
14 | 16:56:41.437 | info | yii\db\Command::query | SHOW CREATE TABLE `category` | |
15 | 16:56:41.437 | 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:41.444 | 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:41.450 | 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:41.457 | 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:41.468 | 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:41.468 | info | yii\db\Command::query | SHOW FULL COLUMNS FROM `image` | |
21 | 16:56:41.469 | info | yii\db\Command::query | SHOW CREATE TABLE `image` | |
22 | 16:56:41.469 | 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:41.472 | info | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `model` WHERE `good_id`=24) | |
24 | 16:56:41.473 | 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:41.473 | info | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `model` WHERE `good_id`=160) | |
26 | 16:56:41.474 | 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:41.475 | info | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `model` WHERE `good_id`=161) | |
28 | 16:56:41.476 | 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:41.477 | info | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `model` WHERE `good_id`=162) | |
30 | 16:56:41.478 | 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:41.479 | info | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `model` WHERE `good_id`=163) | |
32 | 16:56:41.480 | 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:41.480 | info | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `model` WHERE `good_id`=164) | |
34 | 16:56:41.481 | 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:41.483 | info | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `model` WHERE `good_id`=165) | |
36 | 16:56:41.484 | 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:41.484 | info | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `model` WHERE `good_id`=166) | |
38 | 16:56:41.485 | 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:41.485 | info | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `model` WHERE `good_id`=167) | |
40 | 16:56:41.485 | 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:41.486 | info | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `model` WHERE `good_id`=168) | |
42 | 16:56:41.487 | 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:41.488 | info | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `model` WHERE `good_id`=169) | |
44 | 16:56:41.488 | 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:41.489 | info | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `model` WHERE `good_id`=170) | |
46 | 16:56:41.502 | info | yii\db\Command::query | SELECT * FROM `category` WHERE (`category`.`visibility`=1) AND (`parent_id`=0) ORDER BY `name` | |
47 | 16:56:41.504 | info | yii\db\Command::query | SELECT * FROM `category` WHERE (`is_delete`=0) AND (`parent_id`=15) ORDER BY `name` | |
48 | 16:56:41.504 | info | yii\db\Command::query | SELECT * FROM `category` WHERE (`is_delete`=0) AND (`parent_id`=29) ORDER BY `name` | |
49 | 16:56:41.505 | info | yii\db\Command::query | SELECT * FROM `category` WHERE (`is_delete`=0) AND (`parent_id`=41) ORDER BY `name` | |
50 | 16:56:41.505 | info | yii\db\Command::query | SELECT * FROM `category` WHERE (`is_delete`=0) AND (`parent_id`=11) ORDER BY `name` | |
51 | 16:56:41.506 | info | yii\db\Command::query | SELECT * FROM `category` WHERE (`is_delete`=0) AND (`parent_id`=31) ORDER BY `name` | |
52 | 16:56:41.507 | info | yii\db\Command::query | SELECT * FROM `category` WHERE (`is_delete`=0) AND (`parent_id`=33) ORDER BY `name` | |
53 | 16:56:41.507 | info | yii\db\Command::query | SELECT * FROM `category` WHERE (`is_delete`=0) AND (`parent_id`=28) ORDER BY `name` | |
54 | 16:56:41.508 | info | yii\db\Command::query | SELECT * FROM `category` WHERE (`is_delete`=0) AND (`parent_id`=9) ORDER BY `name` | |
55 | 16:56:41.509 | info | yii\db\Command::query | SELECT * FROM `category` WHERE (`is_delete`=0) AND (`parent_id`=21) ORDER BY `name` | |
56 | 16:56:41.509 | info | yii\db\Command::query | SELECT * FROM `category` WHERE (`is_delete`=0) AND (`parent_id`=24) ORDER BY `name` | |
57 | 16:56:41.510 | < 0ms > | info | yii\db\Command::query | SELECT * FROM `category` WHERE (`is_delete`=0) AND (`parent_id`=2) ORDER BY `name` |