6800bc4dec78b: GET http://connectedbusinesses.app/frontend/core/shared/view-item?business=1514&id=412&type=3 at 2025-04-17 08:31:09 am by 10.244.23.152
Database Queries
Total 12 items.
| Time | Duration | Type | Duplicated | Query |
|---|---|---|---|---|
| 08:31:10.010 | 1.0 ms | SELECT | 1 | SELECT * FROM `key_storage_item` WHERE `key`='frontend.maintenance' |
| 08:31:10.037 | 1.3 ms | SELECT | 1 | SELECT EXISTS(SELECT * FROM `business` WHERE `business`.`id`='1514') |
| 08:31:10.039 | 1.2 ms | SELECT | 1 | SELECT * FROM `tribe` WHERE `id`='412' |
| 08:31:10.098 | 2.9 ms | SHOW | 1 | SHOW FULL COLUMNS FROM `tribe` |
| 08:31:10.102 | 3.6 ms | SELECT | 1 | 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` = 'tribe' AND `kcu`.`TABLE_NAME` = 'tribe' |
| 08:31:10.107 | 1.5 ms | SELECT | 1 | SELECT * FROM `business` WHERE `id`=1511 |
| 08:31:10.109 | 3.0 ms | SHOW | 1 | SHOW FULL COLUMNS FROM `business` |
| 08:31:10.112 | 3.5 ms | SELECT | 1 | 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` = 'business' AND `kcu`.`TABLE_NAME` = 'business' |
| 08:31:10.116 | 1.1 ms | SELECT | 1 | SELECT * FROM `business` WHERE `id`='1514' |
| 08:31:10.123 | 1.2 ms | SELECT | 1 | SELECT * FROM `business_community` WHERE `business_id`=1514 |
| 08:31:10.125 | 0.9 ms | SELECT | 1 | SELECT * FROM `community` WHERE 0=1 |
| 08:31:10.134 | 1.6 ms | INSERT | 1 | INSERT INTO `system_log` (`level`, `category`, `log_time`, `prefix`, `message`)
VALUES (1, 'yii\\base\\ErrorException:2', 1744878670.1263, '[frontend/core/shared/view-item][user=]', 'yii\\base\\ErrorException: Undefined array key 0 in /var/www/html/frontend/modules/core/views/shared/view_item.php:67\nStack trace:\n#0 /var/www/html/frontend/modules/core/views/shared/view_item.php(67): yii\\base\\ErrorHandler->handleError(2, \'Undefined array...\', \'/var/www/html/f...\', 67)\n#1 /var/www/html/vendor/yiisoft/yii2/base/View.php(348): require(\'/var/www/html/f...\')\n#2 /var/www/html/vendor/yiisoft/yii2/base/View.php(257): yii\\base\\View->renderPhpFile(\'/var/www/html/f...\', Array)\n#3 /var/www/html/vendor/yiisoft/yii2/base/View.php(156): yii\\base\\View->renderFile(\'/var/www/html/f...\', Array, Object(frontend\\modules\\core\\controllers\\SharedController))\n#4 /var/www/html/vendor/yiisoft/yii2/base/Controller.php(410): yii\\base\\View->render(\'view_item\', Array, Object(frontend\\modules\\core\\controllers\\SharedController))\n#5 /var/www/html/frontend/modules/core/controllers/SharedController.php(172): yii\\base\\Controller->render(\'view_item\', Array)\n#6 [internal function]: frontend\\modules\\core\\controllers\\SharedController->actionViewItem()\n#7 /var/www/html/vendor/yiisoft/yii2/base/InlineAction.php(57): call_user_func_array(Array, Array)\n#8 /var/www/html/vendor/yiisoft/yii2/base/Controller.php(181): yii\\base\\InlineAction->runWithParams(Array)\n#9 /var/www/html/vendor/yiisoft/yii2/base/Module.php(534): yii\\base\\Controller->runAction(\'view-item\', Array)\n#10 /var/www/html/vendor/yiisoft/yii2/web/Application.php(104): yii\\base\\Module->runAction(\'core/shared/vie...\', Array)\n#11 /var/www/html/vendor/yiisoft/yii2/base/Application.php(392): yii\\web\\Application->handleRequest(Object(yii\\web\\Request))\n#12 /var/www/html/public_html/frontend/index.php(22): yii\\base\\Application->run()\n#13 {main}') |