1.17 ms |
SELECT *
FROM `Years`
LEFT JOIN `Avg_values` `avg` ON `avg`.`years_id` = `Years`.`id`
WHERE `value` IS NOT NULL
AND (
`Years`.`deleted_at` IS NULL
)
AND `Years`.`deleted_at` IS NULL |
APPPATH/Controllers/Home.php:36 |
|
1 SYSTEMPATH/Database/BaseBuilder.php:1636
CodeIgniter\Database\BaseConnection->query()
2 SYSTEMPATH/Model.php:286
CodeIgniter\Database\BaseBuilder->get()
3 SYSTEMPATH/BaseModel.php:676
CodeIgniter\Model->doFindAll()
4 APPPATH/Controllers/Home.php:36
CodeIgniter\BaseModel->findAll()
5 SYSTEMPATH/CodeIgniter.php:933
App\Controllers\Home->index()
6 SYSTEMPATH/CodeIgniter.php:509
CodeIgniter\CodeIgniter->runController()
7 SYSTEMPATH/CodeIgniter.php:355
CodeIgniter\CodeIgniter->handleRequest()
8 SYSTEMPATH/Boot.php:325
CodeIgniter\CodeIgniter->run()
9 SYSTEMPATH/Boot.php:67
CodeIgniter\Boot::runCodeIgniter()
10 FCPATH/index.php:56
CodeIgniter\Boot::bootWeb()
|
0.36 ms |
SELECT *
FROM `Levels`
WHERE `Levels`.`deleted_at` IS NULL |
APPPATH/Controllers/Home.php:52 |
|
1 SYSTEMPATH/Database/BaseBuilder.php:1636
CodeIgniter\Database\BaseConnection->query()
2 SYSTEMPATH/Model.php:286
CodeIgniter\Database\BaseBuilder->get()
3 SYSTEMPATH/BaseModel.php:676
CodeIgniter\Model->doFindAll()
4 APPPATH/Controllers/Home.php:52
CodeIgniter\BaseModel->findAll()
5 SYSTEMPATH/CodeIgniter.php:933
App\Controllers\Home->index()
6 SYSTEMPATH/CodeIgniter.php:509
CodeIgniter\CodeIgniter->runController()
7 SYSTEMPATH/CodeIgniter.php:355
CodeIgniter\CodeIgniter->handleRequest()
8 SYSTEMPATH/Boot.php:325
CodeIgniter\CodeIgniter->run()
9 SYSTEMPATH/Boot.php:67
CodeIgniter\Boot::runCodeIgniter()
10 FCPATH/index.php:56
CodeIgniter\Boot::bootWeb()
|
0.12 ms |
SELECT *
FROM `Years`
WHERE `Years`.`deleted_at` IS NULL
ORDER BY `year` DESC
LIMIT 1 |
APPPATH/Controllers/Home.php:53 |
|
1 SYSTEMPATH/Database/BaseBuilder.php:1636
CodeIgniter\Database\BaseConnection->query()
2 SYSTEMPATH/Model.php:330
CodeIgniter\Database\BaseBuilder->get()
3 SYSTEMPATH/BaseModel.php:714
CodeIgniter\Model->doFirst()
4 APPPATH/Controllers/Home.php:53
CodeIgniter\BaseModel->first()
5 SYSTEMPATH/CodeIgniter.php:933
App\Controllers\Home->index()
6 SYSTEMPATH/CodeIgniter.php:509
CodeIgniter\CodeIgniter->runController()
7 SYSTEMPATH/CodeIgniter.php:355
CodeIgniter\CodeIgniter->handleRequest()
8 SYSTEMPATH/Boot.php:325
CodeIgniter\CodeIgniter->run()
9 SYSTEMPATH/Boot.php:67
CodeIgniter\Boot::runCodeIgniter()
10 FCPATH/index.php:56
CodeIgniter\Boot::bootWeb()
|
0.57 ms |
SELECT `Categories`.`id`
FROM `Categories`
LEFT JOIN `Avg_values` `avg` ON `Categories`.`id` = `avg`.`categories_id`
LEFT JOIN `Years` `y` ON `y`.`id` = `avg`.`years_id`
WHERE `y`.`year` = 2024
AND (
`y`.`deleted_at` IS NULL
)
AND `Categories`.`deleted_at` IS NULL |
APPPATH/Libraries/YearsHelper.php:139 |
|
1 SYSTEMPATH/Database/BaseBuilder.php:1636
CodeIgniter\Database\BaseConnection->query()
2 SYSTEMPATH/Model.php:286
CodeIgniter\Database\BaseBuilder->get()
3 SYSTEMPATH/BaseModel.php:676
CodeIgniter\Model->doFindAll()
4 APPPATH/Libraries/YearsHelper.php:139
CodeIgniter\BaseModel->findAll()
5 APPPATH/Libraries/YearsHelper.php:22
App\Libraries\YearsHelper->get_categories_amount()
6 APPPATH/Controllers/Home.php:57
App\Libraries\YearsHelper->__construct()
7 SYSTEMPATH/CodeIgniter.php:933
App\Controllers\Home->index()
8 SYSTEMPATH/CodeIgniter.php:509
CodeIgniter\CodeIgniter->runController()
9 SYSTEMPATH/CodeIgniter.php:355
CodeIgniter\CodeIgniter->handleRequest()
10 SYSTEMPATH/Boot.php:325
CodeIgniter\CodeIgniter->run()
11 SYSTEMPATH/Boot.php:67
CodeIgniter\Boot::runCodeIgniter()
12 FCPATH/index.php:56
CodeIgniter\Boot::bootWeb()
|
0.43 ms |
SELECT `Categories`.`id`, `Categories`.`name`, `Categories`.`logo`
FROM `Categories`
JOIN `Avg_values` `avg` ON `Categories`.`id` = `avg`.`categories_id`
LEFT JOIN `Years` `y` ON `y`.`id` = `avg`.`years_id`
WHERE `y`.`year` = 2024
AND (
`y`.`deleted_at` IS NULL
)
AND `Categories`.`deleted_at` IS NULL
ORDER BY `Categories`.`name` ASC |
APPPATH/Libraries/YearsHelper.php:78 |
|
1 SYSTEMPATH/Database/BaseBuilder.php:1636
CodeIgniter\Database\BaseConnection->query()
2 SYSTEMPATH/Model.php:213
CodeIgniter\Database\BaseBuilder->get()
3 SYSTEMPATH/BaseModel.php:610
CodeIgniter\Model->doFind()
4 APPPATH/Libraries/YearsHelper.php:78
CodeIgniter\BaseModel->find()
5 APPPATH/Libraries/YearsHelper.php:23
App\Libraries\YearsHelper->list_categories()
6 APPPATH/Controllers/Home.php:57
App\Libraries\YearsHelper->__construct()
7 SYSTEMPATH/CodeIgniter.php:933
App\Controllers\Home->index()
8 SYSTEMPATH/CodeIgniter.php:509
CodeIgniter\CodeIgniter->runController()
9 SYSTEMPATH/CodeIgniter.php:355
CodeIgniter\CodeIgniter->handleRequest()
10 SYSTEMPATH/Boot.php:325
CodeIgniter\CodeIgniter->run()
11 SYSTEMPATH/Boot.php:67
CodeIgniter\Boot::runCodeIgniter()
12 FCPATH/index.php:56
CodeIgniter\Boot::bootWeb()
|
0.63 ms |
SELECT `Cities`.`id`, `Cities`.`uuid`, `Cities`.`name`, `Cities`.`levels_id`
FROM `Cities`
LEFT JOIN `Avg_values` `avg` ON `Cities`.`id` = `avg`.`cities_id`
LEFT JOIN `Years` `y` ON `y`.`id` = `avg`.`years_id`
WHERE `y`.`year` = 2024
AND (
`y`.`deleted_at` IS NULL
)
AND `Cities`.`deleted_at` IS NULL |
APPPATH/Libraries/YearsHelper.php:40 |
|
1 SYSTEMPATH/Database/BaseBuilder.php:1636
CodeIgniter\Database\BaseConnection->query()
2 SYSTEMPATH/Model.php:213
CodeIgniter\Database\BaseBuilder->get()
3 SYSTEMPATH/BaseModel.php:610
CodeIgniter\Model->doFind()
4 APPPATH/Libraries/YearsHelper.php:40
CodeIgniter\BaseModel->find()
5 APPPATH/Libraries/YearsHelper.php:24
App\Libraries\YearsHelper->list_cities()
6 APPPATH/Controllers/Home.php:57
App\Libraries\YearsHelper->__construct()
7 SYSTEMPATH/CodeIgniter.php:933
App\Controllers\Home->index()
8 SYSTEMPATH/CodeIgniter.php:509
CodeIgniter\CodeIgniter->runController()
9 SYSTEMPATH/CodeIgniter.php:355
CodeIgniter\CodeIgniter->handleRequest()
10 SYSTEMPATH/Boot.php:325
CodeIgniter\CodeIgniter->run()
11 SYSTEMPATH/Boot.php:67
CodeIgniter\Boot::runCodeIgniter()
12 FCPATH/index.php:56
CodeIgniter\Boot::bootWeb()
|
0.44 ms |
SELECT `ci`.`id`, `ci`.`name`, `stoplight`, `value`
FROM `General_values`
LEFT JOIN `Years` `y` ON `y`.`id` = `General_values`.`years_id`
LEFT JOIN `Cities` `ci` ON `ci`.`id` = `General_values`.`cities_id`
WHERE `ci`.`id` = '3'
AND `y`.`year` <= 2024
AND (
`y`.`deleted_at` IS NULL
)
LIMIT 1 |
APPPATH/Libraries/YearsHelper.php:210 |
|
1 SYSTEMPATH/Database/BaseBuilder.php:1636
CodeIgniter\Database\BaseConnection->query()
2 SYSTEMPATH/Model.php:330
CodeIgniter\Database\BaseBuilder->get()
3 SYSTEMPATH/BaseModel.php:714
CodeIgniter\Model->doFirst()
4 APPPATH/Libraries/YearsHelper.php:210
CodeIgniter\BaseModel->first()
5 APPPATH/Controllers/Home.php:67
App\Libraries\YearsHelper->general_values_by_city()
6 SYSTEMPATH/CodeIgniter.php:933
App\Controllers\Home->index()
7 SYSTEMPATH/CodeIgniter.php:509
CodeIgniter\CodeIgniter->runController()
8 SYSTEMPATH/CodeIgniter.php:355
CodeIgniter\CodeIgniter->handleRequest()
9 SYSTEMPATH/Boot.php:325
CodeIgniter\CodeIgniter->run()
10 SYSTEMPATH/Boot.php:67
CodeIgniter\Boot::runCodeIgniter()
11 FCPATH/index.php:56
CodeIgniter\Boot::bootWeb()
|
0.2 ms |
SELECT `value`
FROM `Avg_values`
LEFT JOIN `Years` `y` ON `y`.`id` = `Avg_values`.`years_id`
LEFT JOIN `Cities` `ci` ON `ci`.`id` = `Avg_values`.`cities_id`
LEFT JOIN `Categories` `ca` ON `ca`.`id` = `Avg_values`.`categories_id`
WHERE `ci`.`id` = '3'
AND `ca`.`id` = '1'
AND `y`.`year` = 2024
AND (
`y`.`deleted_at` IS NULL
)
LIMIT 1 |
APPPATH/Libraries/YearsHelper.php:173 |
|
1 SYSTEMPATH/Database/BaseBuilder.php:1636
CodeIgniter\Database\BaseConnection->query()
2 SYSTEMPATH/Model.php:330
CodeIgniter\Database\BaseBuilder->get()
3 SYSTEMPATH/BaseModel.php:714
CodeIgniter\Model->doFirst()
4 APPPATH/Libraries/YearsHelper.php:173
CodeIgniter\BaseModel->first()
5 APPPATH/Controllers/Home.php:68
App\Libraries\YearsHelper->category_values_by_city()
6 SYSTEMPATH/CodeIgniter.php:933
App\Controllers\Home->index()
7 SYSTEMPATH/CodeIgniter.php:509
CodeIgniter\CodeIgniter->runController()
8 SYSTEMPATH/CodeIgniter.php:355
CodeIgniter\CodeIgniter->handleRequest()
9 SYSTEMPATH/Boot.php:325
CodeIgniter\CodeIgniter->run()
10 SYSTEMPATH/Boot.php:67
CodeIgniter\Boot::runCodeIgniter()
11 FCPATH/index.php:56
CodeIgniter\Boot::bootWeb()
|
0.22 ms |
SELECT `value`
FROM `Avg_values`
LEFT JOIN `Years` `y` ON `y`.`id` = `Avg_values`.`years_id`
LEFT JOIN `Cities` `ci` ON `ci`.`id` = `Avg_values`.`cities_id`
LEFT JOIN `Categories` `ca` ON `ca`.`id` = `Avg_values`.`categories_id`
WHERE `ci`.`id` = '3'
AND `ca`.`id` = '2'
AND `y`.`year` = 2024
AND (
`y`.`deleted_at` IS NULL
)
LIMIT 1 |
APPPATH/Libraries/YearsHelper.php:173 |
|
1 SYSTEMPATH/Database/BaseBuilder.php:1636
CodeIgniter\Database\BaseConnection->query()
2 SYSTEMPATH/Model.php:330
CodeIgniter\Database\BaseBuilder->get()
3 SYSTEMPATH/BaseModel.php:714
CodeIgniter\Model->doFirst()
4 APPPATH/Libraries/YearsHelper.php:173
CodeIgniter\BaseModel->first()
5 APPPATH/Controllers/Home.php:68
App\Libraries\YearsHelper->category_values_by_city()
6 SYSTEMPATH/CodeIgniter.php:933
App\Controllers\Home->index()
7 SYSTEMPATH/CodeIgniter.php:509
CodeIgniter\CodeIgniter->runController()
8 SYSTEMPATH/CodeIgniter.php:355
CodeIgniter\CodeIgniter->handleRequest()
9 SYSTEMPATH/Boot.php:325
CodeIgniter\CodeIgniter->run()
10 SYSTEMPATH/Boot.php:67
CodeIgniter\Boot::runCodeIgniter()
11 FCPATH/index.php:56
CodeIgniter\Boot::bootWeb()
|
0.19 ms |
SELECT `value`
FROM `Avg_values`
LEFT JOIN `Years` `y` ON `y`.`id` = `Avg_values`.`years_id`
LEFT JOIN `Cities` `ci` ON `ci`.`id` = `Avg_values`.`cities_id`
LEFT JOIN `Categories` `ca` ON `ca`.`id` = `Avg_values`.`categories_id`
WHERE `ci`.`id` = '3'
AND `ca`.`id` = '3'
AND `y`.`year` = 2024
AND (
`y`.`deleted_at` IS NULL
)
LIMIT 1 |
APPPATH/Libraries/YearsHelper.php:173 |
|
1 SYSTEMPATH/Database/BaseBuilder.php:1636
CodeIgniter\Database\BaseConnection->query()
2 SYSTEMPATH/Model.php:330
CodeIgniter\Database\BaseBuilder->get()
3 SYSTEMPATH/BaseModel.php:714
CodeIgniter\Model->doFirst()
4 APPPATH/Libraries/YearsHelper.php:173
CodeIgniter\BaseModel->first()
5 APPPATH/Controllers/Home.php:68
App\Libraries\YearsHelper->category_values_by_city()
6 SYSTEMPATH/CodeIgniter.php:933
App\Controllers\Home->index()
7 SYSTEMPATH/CodeIgniter.php:509
CodeIgniter\CodeIgniter->runController()
8 SYSTEMPATH/CodeIgniter.php:355
CodeIgniter\CodeIgniter->handleRequest()
9 SYSTEMPATH/Boot.php:325
CodeIgniter\CodeIgniter->run()
10 SYSTEMPATH/Boot.php:67
CodeIgniter\Boot::runCodeIgniter()
11 FCPATH/index.php:56
CodeIgniter\Boot::bootWeb()
|
0.17 ms |
SELECT `value`
FROM `Avg_values`
LEFT JOIN `Years` `y` ON `y`.`id` = `Avg_values`.`years_id`
LEFT JOIN `Cities` `ci` ON `ci`.`id` = `Avg_values`.`cities_id`
LEFT JOIN `Categories` `ca` ON `ca`.`id` = `Avg_values`.`categories_id`
WHERE `ci`.`id` = '3'
AND `ca`.`id` = '4'
AND `y`.`year` = 2024
AND (
`y`.`deleted_at` IS NULL
)
LIMIT 1 |
APPPATH/Libraries/YearsHelper.php:173 |
|
1 SYSTEMPATH/Database/BaseBuilder.php:1636
CodeIgniter\Database\BaseConnection->query()
2 SYSTEMPATH/Model.php:330
CodeIgniter\Database\BaseBuilder->get()
3 SYSTEMPATH/BaseModel.php:714
CodeIgniter\Model->doFirst()
4 APPPATH/Libraries/YearsHelper.php:173
CodeIgniter\BaseModel->first()
5 APPPATH/Controllers/Home.php:68
App\Libraries\YearsHelper->category_values_by_city()
6 SYSTEMPATH/CodeIgniter.php:933
App\Controllers\Home->index()
7 SYSTEMPATH/CodeIgniter.php:509
CodeIgniter\CodeIgniter->runController()
8 SYSTEMPATH/CodeIgniter.php:355
CodeIgniter\CodeIgniter->handleRequest()
9 SYSTEMPATH/Boot.php:325
CodeIgniter\CodeIgniter->run()
10 SYSTEMPATH/Boot.php:67
CodeIgniter\Boot::runCodeIgniter()
11 FCPATH/index.php:56
CodeIgniter\Boot::bootWeb()
|
0.15 ms |
SELECT `value`
FROM `Avg_values`
LEFT JOIN `Years` `y` ON `y`.`id` = `Avg_values`.`years_id`
LEFT JOIN `Cities` `ci` ON `ci`.`id` = `Avg_values`.`cities_id`
LEFT JOIN `Categories` `ca` ON `ca`.`id` = `Avg_values`.`categories_id`
WHERE `ci`.`id` = '3'
AND `ca`.`id` = '5'
AND `y`.`year` = 2024
AND (
`y`.`deleted_at` IS NULL
)
LIMIT 1 |
APPPATH/Libraries/YearsHelper.php:173 |
|
1 SYSTEMPATH/Database/BaseBuilder.php:1636
CodeIgniter\Database\BaseConnection->query()
2 SYSTEMPATH/Model.php:330
CodeIgniter\Database\BaseBuilder->get()
3 SYSTEMPATH/BaseModel.php:714
CodeIgniter\Model->doFirst()
4 APPPATH/Libraries/YearsHelper.php:173
CodeIgniter\BaseModel->first()
5 APPPATH/Controllers/Home.php:68
App\Libraries\YearsHelper->category_values_by_city()
6 SYSTEMPATH/CodeIgniter.php:933
App\Controllers\Home->index()
7 SYSTEMPATH/CodeIgniter.php:509
CodeIgniter\CodeIgniter->runController()
8 SYSTEMPATH/CodeIgniter.php:355
CodeIgniter\CodeIgniter->handleRequest()
9 SYSTEMPATH/Boot.php:325
CodeIgniter\CodeIgniter->run()
10 SYSTEMPATH/Boot.php:67
CodeIgniter\Boot::runCodeIgniter()
11 FCPATH/index.php:56
CodeIgniter\Boot::bootWeb()
|
0.16 ms |
SELECT `value`
FROM `Avg_values`
LEFT JOIN `Years` `y` ON `y`.`id` = `Avg_values`.`years_id`
LEFT JOIN `Cities` `ci` ON `ci`.`id` = `Avg_values`.`cities_id`
LEFT JOIN `Categories` `ca` ON `ca`.`id` = `Avg_values`.`categories_id`
WHERE `ci`.`id` = '3'
AND `ca`.`id` = '6'
AND `y`.`year` = 2024
AND (
`y`.`deleted_at` IS NULL
)
LIMIT 1 |
APPPATH/Libraries/YearsHelper.php:173 |
|
1 SYSTEMPATH/Database/BaseBuilder.php:1636
CodeIgniter\Database\BaseConnection->query()
2 SYSTEMPATH/Model.php:330
CodeIgniter\Database\BaseBuilder->get()
3 SYSTEMPATH/BaseModel.php:714
CodeIgniter\Model->doFirst()
4 APPPATH/Libraries/YearsHelper.php:173
CodeIgniter\BaseModel->first()
5 APPPATH/Controllers/Home.php:68
App\Libraries\YearsHelper->category_values_by_city()
6 SYSTEMPATH/CodeIgniter.php:933
App\Controllers\Home->index()
7 SYSTEMPATH/CodeIgniter.php:509
CodeIgniter\CodeIgniter->runController()
8 SYSTEMPATH/CodeIgniter.php:355
CodeIgniter\CodeIgniter->handleRequest()
9 SYSTEMPATH/Boot.php:325
CodeIgniter\CodeIgniter->run()
10 SYSTEMPATH/Boot.php:67
CodeIgniter\Boot::runCodeIgniter()
11 FCPATH/index.php:56
CodeIgniter\Boot::bootWeb()
|
0.17 ms |
SELECT `value`
FROM `Avg_values`
LEFT JOIN `Years` `y` ON `y`.`id` = `Avg_values`.`years_id`
LEFT JOIN `Cities` `ci` ON `ci`.`id` = `Avg_values`.`cities_id`
LEFT JOIN `Categories` `ca` ON `ca`.`id` = `Avg_values`.`categories_id`
WHERE `ci`.`id` = '3'
AND `ca`.`id` = '7'
AND `y`.`year` = 2024
AND (
`y`.`deleted_at` IS NULL
)
LIMIT 1 |
APPPATH/Libraries/YearsHelper.php:173 |
|
1 SYSTEMPATH/Database/BaseBuilder.php:1636
CodeIgniter\Database\BaseConnection->query()
2 SYSTEMPATH/Model.php:330
CodeIgniter\Database\BaseBuilder->get()
3 SYSTEMPATH/BaseModel.php:714
CodeIgniter\Model->doFirst()
4 APPPATH/Libraries/YearsHelper.php:173
CodeIgniter\BaseModel->first()
5 APPPATH/Controllers/Home.php:68
App\Libraries\YearsHelper->category_values_by_city()
6 SYSTEMPATH/CodeIgniter.php:933
App\Controllers\Home->index()
7 SYSTEMPATH/CodeIgniter.php:509
CodeIgniter\CodeIgniter->runController()
8 SYSTEMPATH/CodeIgniter.php:355
CodeIgniter\CodeIgniter->handleRequest()
9 SYSTEMPATH/Boot.php:325
CodeIgniter\CodeIgniter->run()
10 SYSTEMPATH/Boot.php:67
CodeIgniter\Boot::runCodeIgniter()
11 FCPATH/index.php:56
CodeIgniter\Boot::bootWeb()
|
0.12 ms |
SELECT `ci`.`id`, `ci`.`name`, `stoplight`, `value`
FROM `General_values`
LEFT JOIN `Years` `y` ON `y`.`id` = `General_values`.`years_id`
LEFT JOIN `Cities` `ci` ON `ci`.`id` = `General_values`.`cities_id`
WHERE `ci`.`id` = '3'
AND `y`.`year` <= 2024
AND (
`y`.`deleted_at` IS NULL
)
LIMIT 1 |
APPPATH/Libraries/YearsHelper.php:210 |
|
1 SYSTEMPATH/Database/BaseBuilder.php:1636
CodeIgniter\Database\BaseConnection->query()
2 SYSTEMPATH/Model.php:330
CodeIgniter\Database\BaseBuilder->get()
3 SYSTEMPATH/BaseModel.php:714
CodeIgniter\Model->doFirst()
4 APPPATH/Libraries/YearsHelper.php:210
CodeIgniter\BaseModel->first()
5 APPPATH/Libraries/YearsHelper.php:238
App\Libraries\YearsHelper->general_values_by_city()
6 APPPATH/Controllers/Home.php:71
App\Libraries\YearsHelper->general_city_score_by_year()
7 SYSTEMPATH/CodeIgniter.php:933
App\Controllers\Home->index()
8 SYSTEMPATH/CodeIgniter.php:509
CodeIgniter\CodeIgniter->runController()
9 SYSTEMPATH/CodeIgniter.php:355
CodeIgniter\CodeIgniter->handleRequest()
10 SYSTEMPATH/Boot.php:325
CodeIgniter\CodeIgniter->run()
11 SYSTEMPATH/Boot.php:67
CodeIgniter\Boot::runCodeIgniter()
12 FCPATH/index.php:56
CodeIgniter\Boot::bootWeb()
|
0.12 ms |
SELECT `ci`.`id`, `ci`.`name`, `stoplight`, `value`
FROM `General_values`
LEFT JOIN `Years` `y` ON `y`.`id` = `General_values`.`years_id`
LEFT JOIN `Cities` `ci` ON `ci`.`id` = `General_values`.`cities_id`
WHERE `ci`.`id` = '4'
AND `y`.`year` <= 2024
AND (
`y`.`deleted_at` IS NULL
)
LIMIT 1 |
APPPATH/Libraries/YearsHelper.php:210 |
|
1 SYSTEMPATH/Database/BaseBuilder.php:1636
CodeIgniter\Database\BaseConnection->query()
2 SYSTEMPATH/Model.php:330
CodeIgniter\Database\BaseBuilder->get()
3 SYSTEMPATH/BaseModel.php:714
CodeIgniter\Model->doFirst()
4 APPPATH/Libraries/YearsHelper.php:210
CodeIgniter\BaseModel->first()
5 APPPATH/Controllers/Home.php:67
App\Libraries\YearsHelper->general_values_by_city()
6 SYSTEMPATH/CodeIgniter.php:933
App\Controllers\Home->index()
7 SYSTEMPATH/CodeIgniter.php:509
CodeIgniter\CodeIgniter->runController()
8 SYSTEMPATH/CodeIgniter.php:355
CodeIgniter\CodeIgniter->handleRequest()
9 SYSTEMPATH/Boot.php:325
CodeIgniter\CodeIgniter->run()
10 SYSTEMPATH/Boot.php:67
CodeIgniter\Boot::runCodeIgniter()
11 FCPATH/index.php:56
CodeIgniter\Boot::bootWeb()
|
0.15 ms |
SELECT `value`
FROM `Avg_values`
LEFT JOIN `Years` `y` ON `y`.`id` = `Avg_values`.`years_id`
LEFT JOIN `Cities` `ci` ON `ci`.`id` = `Avg_values`.`cities_id`
LEFT JOIN `Categories` `ca` ON `ca`.`id` = `Avg_values`.`categories_id`
WHERE `ci`.`id` = '4'
AND `ca`.`id` = '1'
AND `y`.`year` = 2024
AND (
`y`.`deleted_at` IS NULL
)
LIMIT 1 |
APPPATH/Libraries/YearsHelper.php:173 |
|
1 SYSTEMPATH/Database/BaseBuilder.php:1636
CodeIgniter\Database\BaseConnection->query()
2 SYSTEMPATH/Model.php:330
CodeIgniter\Database\BaseBuilder->get()
3 SYSTEMPATH/BaseModel.php:714
CodeIgniter\Model->doFirst()
4 APPPATH/Libraries/YearsHelper.php:173
CodeIgniter\BaseModel->first()
5 APPPATH/Controllers/Home.php:68
App\Libraries\YearsHelper->category_values_by_city()
6 SYSTEMPATH/CodeIgniter.php:933
App\Controllers\Home->index()
7 SYSTEMPATH/CodeIgniter.php:509
CodeIgniter\CodeIgniter->runController()
8 SYSTEMPATH/CodeIgniter.php:355
CodeIgniter\CodeIgniter->handleRequest()
9 SYSTEMPATH/Boot.php:325
CodeIgniter\CodeIgniter->run()
10 SYSTEMPATH/Boot.php:67
CodeIgniter\Boot::runCodeIgniter()
11 FCPATH/index.php:56
CodeIgniter\Boot::bootWeb()
|
0.16 ms |
SELECT `value`
FROM `Avg_values`
LEFT JOIN `Years` `y` ON `y`.`id` = `Avg_values`.`years_id`
LEFT JOIN `Cities` `ci` ON `ci`.`id` = `Avg_values`.`cities_id`
LEFT JOIN `Categories` `ca` ON `ca`.`id` = `Avg_values`.`categories_id`
WHERE `ci`.`id` = '4'
AND `ca`.`id` = '2'
AND `y`.`year` = 2024
AND (
`y`.`deleted_at` IS NULL
)
LIMIT 1 |
APPPATH/Libraries/YearsHelper.php:173 |
|
1 SYSTEMPATH/Database/BaseBuilder.php:1636
CodeIgniter\Database\BaseConnection->query()
2 SYSTEMPATH/Model.php:330
CodeIgniter\Database\BaseBuilder->get()
3 SYSTEMPATH/BaseModel.php:714
CodeIgniter\Model->doFirst()
4 APPPATH/Libraries/YearsHelper.php:173
CodeIgniter\BaseModel->first()
5 APPPATH/Controllers/Home.php:68
App\Libraries\YearsHelper->category_values_by_city()
6 SYSTEMPATH/CodeIgniter.php:933
App\Controllers\Home->index()
7 SYSTEMPATH/CodeIgniter.php:509
CodeIgniter\CodeIgniter->runController()
8 SYSTEMPATH/CodeIgniter.php:355
CodeIgniter\CodeIgniter->handleRequest()
9 SYSTEMPATH/Boot.php:325
CodeIgniter\CodeIgniter->run()
10 SYSTEMPATH/Boot.php:67
CodeIgniter\Boot::runCodeIgniter()
11 FCPATH/index.php:56
CodeIgniter\Boot::bootWeb()
|
0.17 ms |
SELECT `value`
FROM `Avg_values`
LEFT JOIN `Years` `y` ON `y`.`id` = `Avg_values`.`years_id`
LEFT JOIN `Cities` `ci` ON `ci`.`id` = `Avg_values`.`cities_id`
LEFT JOIN `Categories` `ca` ON `ca`.`id` = `Avg_values`.`categories_id`
WHERE `ci`.`id` = '4'
AND `ca`.`id` = '3'
AND `y`.`year` = 2024
AND (
`y`.`deleted_at` IS NULL
)
LIMIT 1 |
APPPATH/Libraries/YearsHelper.php:173 |
|
1 SYSTEMPATH/Database/BaseBuilder.php:1636
CodeIgniter\Database\BaseConnection->query()
2 SYSTEMPATH/Model.php:330
CodeIgniter\Database\BaseBuilder->get()
3 SYSTEMPATH/BaseModel.php:714
CodeIgniter\Model->doFirst()
4 APPPATH/Libraries/YearsHelper.php:173
CodeIgniter\BaseModel->first()
5 APPPATH/Controllers/Home.php:68
App\Libraries\YearsHelper->category_values_by_city()
6 SYSTEMPATH/CodeIgniter.php:933
App\Controllers\Home->index()
7 SYSTEMPATH/CodeIgniter.php:509
CodeIgniter\CodeIgniter->runController()
8 SYSTEMPATH/CodeIgniter.php:355
CodeIgniter\CodeIgniter->handleRequest()
9 SYSTEMPATH/Boot.php:325
CodeIgniter\CodeIgniter->run()
10 SYSTEMPATH/Boot.php:67
CodeIgniter\Boot::runCodeIgniter()
11 FCPATH/index.php:56
CodeIgniter\Boot::bootWeb()
|
0.15 ms |
SELECT `value`
FROM `Avg_values`
LEFT JOIN `Years` `y` ON `y`.`id` = `Avg_values`.`years_id`
LEFT JOIN `Cities` `ci` ON `ci`.`id` = `Avg_values`.`cities_id`
LEFT JOIN `Categories` `ca` ON `ca`.`id` = `Avg_values`.`categories_id`
WHERE `ci`.`id` = '4'
AND `ca`.`id` = '4'
AND `y`.`year` = 2024
AND (
`y`.`deleted_at` IS NULL
)
LIMIT 1 |
APPPATH/Libraries/YearsHelper.php:173 |
|
1 SYSTEMPATH/Database/BaseBuilder.php:1636
CodeIgniter\Database\BaseConnection->query()
2 SYSTEMPATH/Model.php:330
CodeIgniter\Database\BaseBuilder->get()
3 SYSTEMPATH/BaseModel.php:714
CodeIgniter\Model->doFirst()
4 APPPATH/Libraries/YearsHelper.php:173
CodeIgniter\BaseModel->first()
5 APPPATH/Controllers/Home.php:68
App\Libraries\YearsHelper->category_values_by_city()
6 SYSTEMPATH/CodeIgniter.php:933
App\Controllers\Home->index()
7 SYSTEMPATH/CodeIgniter.php:509
CodeIgniter\CodeIgniter->runController()
8 SYSTEMPATH/CodeIgniter.php:355
CodeIgniter\CodeIgniter->handleRequest()
9 SYSTEMPATH/Boot.php:325
CodeIgniter\CodeIgniter->run()
10 SYSTEMPATH/Boot.php:67
CodeIgniter\Boot::runCodeIgniter()
11 FCPATH/index.php:56
CodeIgniter\Boot::bootWeb()
|
0.15 ms |
SELECT `value`
FROM `Avg_values`
LEFT JOIN `Years` `y` ON `y`.`id` = `Avg_values`.`years_id`
LEFT JOIN `Cities` `ci` ON `ci`.`id` = `Avg_values`.`cities_id`
LEFT JOIN `Categories` `ca` ON `ca`.`id` = `Avg_values`.`categories_id`
WHERE `ci`.`id` = '4'
AND `ca`.`id` = '5'
AND `y`.`year` = 2024
AND (
`y`.`deleted_at` IS NULL
)
LIMIT 1 |
APPPATH/Libraries/YearsHelper.php:173 |
|
1 SYSTEMPATH/Database/BaseBuilder.php:1636
CodeIgniter\Database\BaseConnection->query()
2 SYSTEMPATH/Model.php:330
CodeIgniter\Database\BaseBuilder->get()
3 SYSTEMPATH/BaseModel.php:714
CodeIgniter\Model->doFirst()
4 APPPATH/Libraries/YearsHelper.php:173
CodeIgniter\BaseModel->first()
5 APPPATH/Controllers/Home.php:68
App\Libraries\YearsHelper->category_values_by_city()
6 SYSTEMPATH/CodeIgniter.php:933
App\Controllers\Home->index()
7 SYSTEMPATH/CodeIgniter.php:509
CodeIgniter\CodeIgniter->runController()
8 SYSTEMPATH/CodeIgniter.php:355
CodeIgniter\CodeIgniter->handleRequest()
9 SYSTEMPATH/Boot.php:325
CodeIgniter\CodeIgniter->run()
10 SYSTEMPATH/Boot.php:67
CodeIgniter\Boot::runCodeIgniter()
11 FCPATH/index.php:56
CodeIgniter\Boot::bootWeb()
|
0.15 ms |
SELECT `value`
FROM `Avg_values`
LEFT JOIN `Years` `y` ON `y`.`id` = `Avg_values`.`years_id`
LEFT JOIN `Cities` `ci` ON `ci`.`id` = `Avg_values`.`cities_id`
LEFT JOIN `Categories` `ca` ON `ca`.`id` = `Avg_values`.`categories_id`
WHERE `ci`.`id` = '4'
AND `ca`.`id` = '6'
AND `y`.`year` = 2024
AND (
`y`.`deleted_at` IS NULL
)
LIMIT 1 |
APPPATH/Libraries/YearsHelper.php:173 |
|
1 SYSTEMPATH/Database/BaseBuilder.php:1636
CodeIgniter\Database\BaseConnection->query()
2 SYSTEMPATH/Model.php:330
CodeIgniter\Database\BaseBuilder->get()
3 SYSTEMPATH/BaseModel.php:714
CodeIgniter\Model->doFirst()
4 APPPATH/Libraries/YearsHelper.php:173
CodeIgniter\BaseModel->first()
5 APPPATH/Controllers/Home.php:68
App\Libraries\YearsHelper->category_values_by_city()
6 SYSTEMPATH/CodeIgniter.php:933
App\Controllers\Home->index()
7 SYSTEMPATH/CodeIgniter.php:509
CodeIgniter\CodeIgniter->runController()
8 SYSTEMPATH/CodeIgniter.php:355
CodeIgniter\CodeIgniter->handleRequest()
9 SYSTEMPATH/Boot.php:325
CodeIgniter\CodeIgniter->run()
10 SYSTEMPATH/Boot.php:67
CodeIgniter\Boot::runCodeIgniter()
11 FCPATH/index.php:56
CodeIgniter\Boot::bootWeb()
|
0.15 ms |
SELECT `value`
FROM `Avg_values`
LEFT JOIN `Years` `y` ON `y`.`id` = `Avg_values`.`years_id`
LEFT JOIN `Cities` `ci` ON `ci`.`id` = `Avg_values`.`cities_id`
LEFT JOIN `Categories` `ca` ON `ca`.`id` = `Avg_values`.`categories_id`
WHERE `ci`.`id` = '4'
AND `ca`.`id` = '7'
AND `y`.`year` = 2024
AND (
`y`.`deleted_at` IS NULL
)
LIMIT 1 |
APPPATH/Libraries/YearsHelper.php:173 |
|
1 SYSTEMPATH/Database/BaseBuilder.php:1636
CodeIgniter\Database\BaseConnection->query()
2 SYSTEMPATH/Model.php:330
CodeIgniter\Database\BaseBuilder->get()
3 SYSTEMPATH/BaseModel.php:714
CodeIgniter\Model->doFirst()
4 APPPATH/Libraries/YearsHelper.php:173
CodeIgniter\BaseModel->first()
5 APPPATH/Controllers/Home.php:68
App\Libraries\YearsHelper->category_values_by_city()
6 SYSTEMPATH/CodeIgniter.php:933
App\Controllers\Home->index()
7 SYSTEMPATH/CodeIgniter.php:509
CodeIgniter\CodeIgniter->runController()
8 SYSTEMPATH/CodeIgniter.php:355
CodeIgniter\CodeIgniter->handleRequest()
9 SYSTEMPATH/Boot.php:325
CodeIgniter\CodeIgniter->run()
10 SYSTEMPATH/Boot.php:67
CodeIgniter\Boot::runCodeIgniter()
11 FCPATH/index.php:56
CodeIgniter\Boot::bootWeb()
|
0.13 ms |
SELECT `ci`.`id`, `ci`.`name`, `stoplight`, `value`
FROM `General_values`
LEFT JOIN `Years` `y` ON `y`.`id` = `General_values`.`years_id`
LEFT JOIN `Cities` `ci` ON `ci`.`id` = `General_values`.`cities_id`
WHERE `ci`.`id` = '4'
AND `y`.`year` <= 2024
AND (
`y`.`deleted_at` IS NULL
)
LIMIT 1 |
APPPATH/Libraries/YearsHelper.php:210 |
|
1 SYSTEMPATH/Database/BaseBuilder.php:1636
CodeIgniter\Database\BaseConnection->query()
2 SYSTEMPATH/Model.php:330
CodeIgniter\Database\BaseBuilder->get()
3 SYSTEMPATH/BaseModel.php:714
CodeIgniter\Model->doFirst()
4 APPPATH/Libraries/YearsHelper.php:210
CodeIgniter\BaseModel->first()
5 APPPATH/Libraries/YearsHelper.php:238
App\Libraries\YearsHelper->general_values_by_city()
6 APPPATH/Controllers/Home.php:71
App\Libraries\YearsHelper->general_city_score_by_year()
7 SYSTEMPATH/CodeIgniter.php:933
App\Controllers\Home->index()
8 SYSTEMPATH/CodeIgniter.php:509
CodeIgniter\CodeIgniter->runController()
9 SYSTEMPATH/CodeIgniter.php:355
CodeIgniter\CodeIgniter->handleRequest()
10 SYSTEMPATH/Boot.php:325
CodeIgniter\CodeIgniter->run()
11 SYSTEMPATH/Boot.php:67
CodeIgniter\Boot::runCodeIgniter()
12 FCPATH/index.php:56
CodeIgniter\Boot::bootWeb()
|
0.11 ms |
SELECT `ci`.`id`, `ci`.`name`, `stoplight`, `value`
FROM `General_values`
LEFT JOIN `Years` `y` ON `y`.`id` = `General_values`.`years_id`
LEFT JOIN `Cities` `ci` ON `ci`.`id` = `General_values`.`cities_id`
WHERE `ci`.`id` = '6'
AND `y`.`year` <= 2024
AND (
`y`.`deleted_at` IS NULL
)
LIMIT 1 |
APPPATH/Libraries/YearsHelper.php:210 |
|
1 SYSTEMPATH/Database/BaseBuilder.php:1636
CodeIgniter\Database\BaseConnection->query()
2 SYSTEMPATH/Model.php:330
CodeIgniter\Database\BaseBuilder->get()
3 SYSTEMPATH/BaseModel.php:714
CodeIgniter\Model->doFirst()
4 APPPATH/Libraries/YearsHelper.php:210
CodeIgniter\BaseModel->first()
5 APPPATH/Controllers/Home.php:67
App\Libraries\YearsHelper->general_values_by_city()
6 SYSTEMPATH/CodeIgniter.php:933
App\Controllers\Home->index()
7 SYSTEMPATH/CodeIgniter.php:509
CodeIgniter\CodeIgniter->runController()
8 SYSTEMPATH/CodeIgniter.php:355
CodeIgniter\CodeIgniter->handleRequest()
9 SYSTEMPATH/Boot.php:325
CodeIgniter\CodeIgniter->run()
10 SYSTEMPATH/Boot.php:67
CodeIgniter\Boot::runCodeIgniter()
11 FCPATH/index.php:56
CodeIgniter\Boot::bootWeb()
|
0.15 ms |
SELECT `value`
FROM `Avg_values`
LEFT JOIN `Years` `y` ON `y`.`id` = `Avg_values`.`years_id`
LEFT JOIN `Cities` `ci` ON `ci`.`id` = `Avg_values`.`cities_id`
LEFT JOIN `Categories` `ca` ON `ca`.`id` = `Avg_values`.`categories_id`
WHERE `ci`.`id` = '6'
AND `ca`.`id` = '1'
AND `y`.`year` = 2024
AND (
`y`.`deleted_at` IS NULL
)
LIMIT 1 |
APPPATH/Libraries/YearsHelper.php:173 |
|
1 SYSTEMPATH/Database/BaseBuilder.php:1636
CodeIgniter\Database\BaseConnection->query()
2 SYSTEMPATH/Model.php:330
CodeIgniter\Database\BaseBuilder->get()
3 SYSTEMPATH/BaseModel.php:714
CodeIgniter\Model->doFirst()
4 APPPATH/Libraries/YearsHelper.php:173
CodeIgniter\BaseModel->first()
5 APPPATH/Controllers/Home.php:68
App\Libraries\YearsHelper->category_values_by_city()
6 SYSTEMPATH/CodeIgniter.php:933
App\Controllers\Home->index()
7 SYSTEMPATH/CodeIgniter.php:509
CodeIgniter\CodeIgniter->runController()
8 SYSTEMPATH/CodeIgniter.php:355
CodeIgniter\CodeIgniter->handleRequest()
9 SYSTEMPATH/Boot.php:325
CodeIgniter\CodeIgniter->run()
10 SYSTEMPATH/Boot.php:67
CodeIgniter\Boot::runCodeIgniter()
11 FCPATH/index.php:56
CodeIgniter\Boot::bootWeb()
|
0.15 ms |
SELECT `value`
FROM `Avg_values`
LEFT JOIN `Years` `y` ON `y`.`id` = `Avg_values`.`years_id`
LEFT JOIN `Cities` `ci` ON `ci`.`id` = `Avg_values`.`cities_id`
LEFT JOIN `Categories` `ca` ON `ca`.`id` = `Avg_values`.`categories_id`
WHERE `ci`.`id` = '6'
AND `ca`.`id` = '2'
AND `y`.`year` = 2024
AND (
`y`.`deleted_at` IS NULL
)
LIMIT 1 |
APPPATH/Libraries/YearsHelper.php:173 |
|
1 SYSTEMPATH/Database/BaseBuilder.php:1636
CodeIgniter\Database\BaseConnection->query()
2 SYSTEMPATH/Model.php:330
CodeIgniter\Database\BaseBuilder->get()
3 SYSTEMPATH/BaseModel.php:714
CodeIgniter\Model->doFirst()
4 APPPATH/Libraries/YearsHelper.php:173
CodeIgniter\BaseModel->first()
5 APPPATH/Controllers/Home.php:68
App\Libraries\YearsHelper->category_values_by_city()
6 SYSTEMPATH/CodeIgniter.php:933
App\Controllers\Home->index()
7 SYSTEMPATH/CodeIgniter.php:509
CodeIgniter\CodeIgniter->runController()
8 SYSTEMPATH/CodeIgniter.php:355
CodeIgniter\CodeIgniter->handleRequest()
9 SYSTEMPATH/Boot.php:325
CodeIgniter\CodeIgniter->run()
10 SYSTEMPATH/Boot.php:67
CodeIgniter\Boot::runCodeIgniter()
11 FCPATH/index.php:56
CodeIgniter\Boot::bootWeb()
|
0.15 ms |
SELECT `value`
FROM `Avg_values`
LEFT JOIN `Years` `y` ON `y`.`id` = `Avg_values`.`years_id`
LEFT JOIN `Cities` `ci` ON `ci`.`id` = `Avg_values`.`cities_id`
LEFT JOIN `Categories` `ca` ON `ca`.`id` = `Avg_values`.`categories_id`
WHERE `ci`.`id` = '6'
AND `ca`.`id` = '3'
AND `y`.`year` = 2024
AND (
`y`.`deleted_at` IS NULL
)
LIMIT 1 |
APPPATH/Libraries/YearsHelper.php:173 |
|
1 SYSTEMPATH/Database/BaseBuilder.php:1636
CodeIgniter\Database\BaseConnection->query()
2 SYSTEMPATH/Model.php:330
CodeIgniter\Database\BaseBuilder->get()
3 SYSTEMPATH/BaseModel.php:714
CodeIgniter\Model->doFirst()
4 APPPATH/Libraries/YearsHelper.php:173
CodeIgniter\BaseModel->first()
5 APPPATH/Controllers/Home.php:68
App\Libraries\YearsHelper->category_values_by_city()
6 SYSTEMPATH/CodeIgniter.php:933
App\Controllers\Home->index()
7 SYSTEMPATH/CodeIgniter.php:509
CodeIgniter\CodeIgniter->runController()
8 SYSTEMPATH/CodeIgniter.php:355
CodeIgniter\CodeIgniter->handleRequest()
9 SYSTEMPATH/Boot.php:325
CodeIgniter\CodeIgniter->run()
10 SYSTEMPATH/Boot.php:67
CodeIgniter\Boot::runCodeIgniter()
11 FCPATH/index.php:56
CodeIgniter\Boot::bootWeb()
|
0.16 ms |
SELECT `value`
FROM `Avg_values`
LEFT JOIN `Years` `y` ON `y`.`id` = `Avg_values`.`years_id`
LEFT JOIN `Cities` `ci` ON `ci`.`id` = `Avg_values`.`cities_id`
LEFT JOIN `Categories` `ca` ON `ca`.`id` = `Avg_values`.`categories_id`
WHERE `ci`.`id` = '6'
AND `ca`.`id` = '4'
AND `y`.`year` = 2024
AND (
`y`.`deleted_at` IS NULL
)
LIMIT 1 |
APPPATH/Libraries/YearsHelper.php:173 |
|
1 SYSTEMPATH/Database/BaseBuilder.php:1636
CodeIgniter\Database\BaseConnection->query()
2 SYSTEMPATH/Model.php:330
CodeIgniter\Database\BaseBuilder->get()
3 SYSTEMPATH/BaseModel.php:714
CodeIgniter\Model->doFirst()
4 APPPATH/Libraries/YearsHelper.php:173
CodeIgniter\BaseModel->first()
5 APPPATH/Controllers/Home.php:68
App\Libraries\YearsHelper->category_values_by_city()
6 SYSTEMPATH/CodeIgniter.php:933
App\Controllers\Home->index()
7 SYSTEMPATH/CodeIgniter.php:509
CodeIgniter\CodeIgniter->runController()
8 SYSTEMPATH/CodeIgniter.php:355
CodeIgniter\CodeIgniter->handleRequest()
9 SYSTEMPATH/Boot.php:325
CodeIgniter\CodeIgniter->run()
10 SYSTEMPATH/Boot.php:67
CodeIgniter\Boot::runCodeIgniter()
11 FCPATH/index.php:56
CodeIgniter\Boot::bootWeb()
|
0.15 ms |
SELECT `value`
FROM `Avg_values`
LEFT JOIN `Years` `y` ON `y`.`id` = `Avg_values`.`years_id`
LEFT JOIN `Cities` `ci` ON `ci`.`id` = `Avg_values`.`cities_id`
LEFT JOIN `Categories` `ca` ON `ca`.`id` = `Avg_values`.`categories_id`
WHERE `ci`.`id` = '6'
AND `ca`.`id` = '5'
AND `y`.`year` = 2024
AND (
`y`.`deleted_at` IS NULL
)
LIMIT 1 |
APPPATH/Libraries/YearsHelper.php:173 |
|
1 SYSTEMPATH/Database/BaseBuilder.php:1636
CodeIgniter\Database\BaseConnection->query()
2 SYSTEMPATH/Model.php:330
CodeIgniter\Database\BaseBuilder->get()
3 SYSTEMPATH/BaseModel.php:714
CodeIgniter\Model->doFirst()
4 APPPATH/Libraries/YearsHelper.php:173
CodeIgniter\BaseModel->first()
5 APPPATH/Controllers/Home.php:68
App\Libraries\YearsHelper->category_values_by_city()
6 SYSTEMPATH/CodeIgniter.php:933
App\Controllers\Home->index()
7 SYSTEMPATH/CodeIgniter.php:509
CodeIgniter\CodeIgniter->runController()
8 SYSTEMPATH/CodeIgniter.php:355
CodeIgniter\CodeIgniter->handleRequest()
9 SYSTEMPATH/Boot.php:325
CodeIgniter\CodeIgniter->run()
10 SYSTEMPATH/Boot.php:67
CodeIgniter\Boot::runCodeIgniter()
11 FCPATH/index.php:56
CodeIgniter\Boot::bootWeb()
|
0.14 ms |
SELECT `value`
FROM `Avg_values`
LEFT JOIN `Years` `y` ON `y`.`id` = `Avg_values`.`years_id`
LEFT JOIN `Cities` `ci` ON `ci`.`id` = `Avg_values`.`cities_id`
LEFT JOIN `Categories` `ca` ON `ca`.`id` = `Avg_values`.`categories_id`
WHERE `ci`.`id` = '6'
AND `ca`.`id` = '6'
AND `y`.`year` = 2024
AND (
`y`.`deleted_at` IS NULL
)
LIMIT 1 |
APPPATH/Libraries/YearsHelper.php:173 |
|
1 SYSTEMPATH/Database/BaseBuilder.php:1636
CodeIgniter\Database\BaseConnection->query()
2 SYSTEMPATH/Model.php:330
CodeIgniter\Database\BaseBuilder->get()
3 SYSTEMPATH/BaseModel.php:714
CodeIgniter\Model->doFirst()
4 APPPATH/Libraries/YearsHelper.php:173
CodeIgniter\BaseModel->first()
5 APPPATH/Controllers/Home.php:68
App\Libraries\YearsHelper->category_values_by_city()
6 SYSTEMPATH/CodeIgniter.php:933
App\Controllers\Home->index()
7 SYSTEMPATH/CodeIgniter.php:509
CodeIgniter\CodeIgniter->runController()
8 SYSTEMPATH/CodeIgniter.php:355
CodeIgniter\CodeIgniter->handleRequest()
9 SYSTEMPATH/Boot.php:325
CodeIgniter\CodeIgniter->run()
10 SYSTEMPATH/Boot.php:67
CodeIgniter\Boot::runCodeIgniter()
11 FCPATH/index.php:56
CodeIgniter\Boot::bootWeb()
|
0.15 ms |
SELECT `value`
FROM `Avg_values`
LEFT JOIN `Years` `y` ON `y`.`id` = `Avg_values`.`years_id`
LEFT JOIN `Cities` `ci` ON `ci`.`id` = `Avg_values`.`cities_id`
LEFT JOIN `Categories` `ca` ON `ca`.`id` = `Avg_values`.`categories_id`
WHERE `ci`.`id` = '6'
AND `ca`.`id` = '7'
AND `y`.`year` = 2024
AND (
`y`.`deleted_at` IS NULL
)
LIMIT 1 |
APPPATH/Libraries/YearsHelper.php:173 |
|
1 SYSTEMPATH/Database/BaseBuilder.php:1636
CodeIgniter\Database\BaseConnection->query()
2 SYSTEMPATH/Model.php:330
CodeIgniter\Database\BaseBuilder->get()
3 SYSTEMPATH/BaseModel.php:714
CodeIgniter\Model->doFirst()
4 APPPATH/Libraries/YearsHelper.php:173
CodeIgniter\BaseModel->first()
5 APPPATH/Controllers/Home.php:68
App\Libraries\YearsHelper->category_values_by_city()
6 SYSTEMPATH/CodeIgniter.php:933
App\Controllers\Home->index()
7 SYSTEMPATH/CodeIgniter.php:509
CodeIgniter\CodeIgniter->runController()
8 SYSTEMPATH/CodeIgniter.php:355
CodeIgniter\CodeIgniter->handleRequest()
9 SYSTEMPATH/Boot.php:325
CodeIgniter\CodeIgniter->run()
10 SYSTEMPATH/Boot.php:67
CodeIgniter\Boot::runCodeIgniter()
11 FCPATH/index.php:56
CodeIgniter\Boot::bootWeb()
|
0.12 ms |
SELECT `ci`.`id`, `ci`.`name`, `stoplight`, `value`
FROM `General_values`
LEFT JOIN `Years` `y` ON `y`.`id` = `General_values`.`years_id`
LEFT JOIN `Cities` `ci` ON `ci`.`id` = `General_values`.`cities_id`
WHERE `ci`.`id` = '6'
AND `y`.`year` <= 2024
AND (
`y`.`deleted_at` IS NULL
)
LIMIT 1 |
APPPATH/Libraries/YearsHelper.php:210 |
|
1 SYSTEMPATH/Database/BaseBuilder.php:1636
CodeIgniter\Database\BaseConnection->query()
2 SYSTEMPATH/Model.php:330
CodeIgniter\Database\BaseBuilder->get()
3 SYSTEMPATH/BaseModel.php:714
CodeIgniter\Model->doFirst()
4 APPPATH/Libraries/YearsHelper.php:210
CodeIgniter\BaseModel->first()
5 APPPATH/Libraries/YearsHelper.php:238
App\Libraries\YearsHelper->general_values_by_city()
6 APPPATH/Controllers/Home.php:71
App\Libraries\YearsHelper->general_city_score_by_year()
7 SYSTEMPATH/CodeIgniter.php:933
App\Controllers\Home->index()
8 SYSTEMPATH/CodeIgniter.php:509
CodeIgniter\CodeIgniter->runController()
9 SYSTEMPATH/CodeIgniter.php:355
CodeIgniter\CodeIgniter->handleRequest()
10 SYSTEMPATH/Boot.php:325
CodeIgniter\CodeIgniter->run()
11 SYSTEMPATH/Boot.php:67
CodeIgniter\Boot::runCodeIgniter()
12 FCPATH/index.php:56
CodeIgniter\Boot::bootWeb()
|
0.13 ms |
SELECT `ci`.`id`, `ci`.`name`, `stoplight`, `value`
FROM `General_values`
LEFT JOIN `Years` `y` ON `y`.`id` = `General_values`.`years_id`
LEFT JOIN `Cities` `ci` ON `ci`.`id` = `General_values`.`cities_id`
WHERE `ci`.`id` = '7'
AND `y`.`year` <= 2024
AND (
`y`.`deleted_at` IS NULL
)
LIMIT 1 |
APPPATH/Libraries/YearsHelper.php:210 |
|
1 SYSTEMPATH/Database/BaseBuilder.php:1636
CodeIgniter\Database\BaseConnection->query()
2 SYSTEMPATH/Model.php:330
CodeIgniter\Database\BaseBuilder->get()
3 SYSTEMPATH/BaseModel.php:714
CodeIgniter\Model->doFirst()
4 APPPATH/Libraries/YearsHelper.php:210
CodeIgniter\BaseModel->first()
5 APPPATH/Controllers/Home.php:67
App\Libraries\YearsHelper->general_values_by_city()
6 SYSTEMPATH/CodeIgniter.php:933
App\Controllers\Home->index()
7 SYSTEMPATH/CodeIgniter.php:509
CodeIgniter\CodeIgniter->runController()
8 SYSTEMPATH/CodeIgniter.php:355
CodeIgniter\CodeIgniter->handleRequest()
9 SYSTEMPATH/Boot.php:325
CodeIgniter\CodeIgniter->run()
10 SYSTEMPATH/Boot.php:67
CodeIgniter\Boot::runCodeIgniter()
11 FCPATH/index.php:56
CodeIgniter\Boot::bootWeb()
|
0.15 ms |
SELECT `value`
FROM `Avg_values`
LEFT JOIN `Years` `y` ON `y`.`id` = `Avg_values`.`years_id`
LEFT JOIN `Cities` `ci` ON `ci`.`id` = `Avg_values`.`cities_id`
LEFT JOIN `Categories` `ca` ON `ca`.`id` = `Avg_values`.`categories_id`
WHERE `ci`.`id` = '7'
AND `ca`.`id` = '1'
AND `y`.`year` = 2024
AND (
`y`.`deleted_at` IS NULL
)
LIMIT 1 |
APPPATH/Libraries/YearsHelper.php:173 |
|
1 SYSTEMPATH/Database/BaseBuilder.php:1636
CodeIgniter\Database\BaseConnection->query()
2 SYSTEMPATH/Model.php:330
CodeIgniter\Database\BaseBuilder->get()
3 SYSTEMPATH/BaseModel.php:714
CodeIgniter\Model->doFirst()
4 APPPATH/Libraries/YearsHelper.php:173
CodeIgniter\BaseModel->first()
5 APPPATH/Controllers/Home.php:68
App\Libraries\YearsHelper->category_values_by_city()
6 SYSTEMPATH/CodeIgniter.php:933
App\Controllers\Home->index()
7 SYSTEMPATH/CodeIgniter.php:509
CodeIgniter\CodeIgniter->runController()
8 SYSTEMPATH/CodeIgniter.php:355
CodeIgniter\CodeIgniter->handleRequest()
9 SYSTEMPATH/Boot.php:325
CodeIgniter\CodeIgniter->run()
10 SYSTEMPATH/Boot.php:67
CodeIgniter\Boot::runCodeIgniter()
11 FCPATH/index.php:56
CodeIgniter\Boot::bootWeb()
|
0.14 ms |
SELECT `value`
FROM `Avg_values`
LEFT JOIN `Years` `y` ON `y`.`id` = `Avg_values`.`years_id`
LEFT JOIN `Cities` `ci` ON `ci`.`id` = `Avg_values`.`cities_id`
LEFT JOIN `Categories` `ca` ON `ca`.`id` = `Avg_values`.`categories_id`
WHERE `ci`.`id` = '7'
AND `ca`.`id` = '2'
AND `y`.`year` = 2024
AND (
`y`.`deleted_at` IS NULL
)
LIMIT 1 |
APPPATH/Libraries/YearsHelper.php:173 |
|
1 SYSTEMPATH/Database/BaseBuilder.php:1636
CodeIgniter\Database\BaseConnection->query()
2 SYSTEMPATH/Model.php:330
CodeIgniter\Database\BaseBuilder->get()
3 SYSTEMPATH/BaseModel.php:714
CodeIgniter\Model->doFirst()
4 APPPATH/Libraries/YearsHelper.php:173
CodeIgniter\BaseModel->first()
5 APPPATH/Controllers/Home.php:68
App\Libraries\YearsHelper->category_values_by_city()
6 SYSTEMPATH/CodeIgniter.php:933
App\Controllers\Home->index()
7 SYSTEMPATH/CodeIgniter.php:509
CodeIgniter\CodeIgniter->runController()
8 SYSTEMPATH/CodeIgniter.php:355
CodeIgniter\CodeIgniter->handleRequest()
9 SYSTEMPATH/Boot.php:325
CodeIgniter\CodeIgniter->run()
10 SYSTEMPATH/Boot.php:67
CodeIgniter\Boot::runCodeIgniter()
11 FCPATH/index.php:56
CodeIgniter\Boot::bootWeb()
|
0.14 ms |
SELECT `value`
FROM `Avg_values`
LEFT JOIN `Years` `y` ON `y`.`id` = `Avg_values`.`years_id`
LEFT JOIN `Cities` `ci` ON `ci`.`id` = `Avg_values`.`cities_id`
LEFT JOIN `Categories` `ca` ON `ca`.`id` = `Avg_values`.`categories_id`
WHERE `ci`.`id` = '7'
AND `ca`.`id` = '3'
AND `y`.`year` = 2024
AND (
`y`.`deleted_at` IS NULL
)
LIMIT 1 |
APPPATH/Libraries/YearsHelper.php:173 |
|
1 SYSTEMPATH/Database/BaseBuilder.php:1636
CodeIgniter\Database\BaseConnection->query()
2 SYSTEMPATH/Model.php:330
CodeIgniter\Database\BaseBuilder->get()
3 SYSTEMPATH/BaseModel.php:714
CodeIgniter\Model->doFirst()
4 APPPATH/Libraries/YearsHelper.php:173
CodeIgniter\BaseModel->first()
5 APPPATH/Controllers/Home.php:68
App\Libraries\YearsHelper->category_values_by_city()
6 SYSTEMPATH/CodeIgniter.php:933
App\Controllers\Home->index()
7 SYSTEMPATH/CodeIgniter.php:509
CodeIgniter\CodeIgniter->runController()
8 SYSTEMPATH/CodeIgniter.php:355
CodeIgniter\CodeIgniter->handleRequest()
9 SYSTEMPATH/Boot.php:325
CodeIgniter\CodeIgniter->run()
10 SYSTEMPATH/Boot.php:67
CodeIgniter\Boot::runCodeIgniter()
11 FCPATH/index.php:56
CodeIgniter\Boot::bootWeb()
|
0.15 ms |
SELECT `value`
FROM `Avg_values`
LEFT JOIN `Years` `y` ON `y`.`id` = `Avg_values`.`years_id`
LEFT JOIN `Cities` `ci` ON `ci`.`id` = `Avg_values`.`cities_id`
LEFT JOIN `Categories` `ca` ON `ca`.`id` = `Avg_values`.`categories_id`
WHERE `ci`.`id` = '7'
AND `ca`.`id` = '4'
AND `y`.`year` = 2024
AND (
`y`.`deleted_at` IS NULL
)
LIMIT 1 |
APPPATH/Libraries/YearsHelper.php:173 |
|
1 SYSTEMPATH/Database/BaseBuilder.php:1636
CodeIgniter\Database\BaseConnection->query()
2 SYSTEMPATH/Model.php:330
CodeIgniter\Database\BaseBuilder->get()
3 SYSTEMPATH/BaseModel.php:714
CodeIgniter\Model->doFirst()
4 APPPATH/Libraries/YearsHelper.php:173
CodeIgniter\BaseModel->first()
5 APPPATH/Controllers/Home.php:68
App\Libraries\YearsHelper->category_values_by_city()
6 SYSTEMPATH/CodeIgniter.php:933
App\Controllers\Home->index()
7 SYSTEMPATH/CodeIgniter.php:509
CodeIgniter\CodeIgniter->runController()
8 SYSTEMPATH/CodeIgniter.php:355
CodeIgniter\CodeIgniter->handleRequest()
9 SYSTEMPATH/Boot.php:325
CodeIgniter\CodeIgniter->run()
10 SYSTEMPATH/Boot.php:67
CodeIgniter\Boot::runCodeIgniter()
11 FCPATH/index.php:56
CodeIgniter\Boot::bootWeb()
|
0.16 ms |
SELECT `value`
FROM `Avg_values`
LEFT JOIN `Years` `y` ON `y`.`id` = `Avg_values`.`years_id`
LEFT JOIN `Cities` `ci` ON `ci`.`id` = `Avg_values`.`cities_id`
LEFT JOIN `Categories` `ca` ON `ca`.`id` = `Avg_values`.`categories_id`
WHERE `ci`.`id` = '7'
AND `ca`.`id` = '5'
AND `y`.`year` = 2024
AND (
`y`.`deleted_at` IS NULL
)
LIMIT 1 |
APPPATH/Libraries/YearsHelper.php:173 |
|
1 SYSTEMPATH/Database/BaseBuilder.php:1636
CodeIgniter\Database\BaseConnection->query()
2 SYSTEMPATH/Model.php:330
CodeIgniter\Database\BaseBuilder->get()
3 SYSTEMPATH/BaseModel.php:714
CodeIgniter\Model->doFirst()
4 APPPATH/Libraries/YearsHelper.php:173
CodeIgniter\BaseModel->first()
5 APPPATH/Controllers/Home.php:68
App\Libraries\YearsHelper->category_values_by_city()
6 SYSTEMPATH/CodeIgniter.php:933
App\Controllers\Home->index()
7 SYSTEMPATH/CodeIgniter.php:509
CodeIgniter\CodeIgniter->runController()
8 SYSTEMPATH/CodeIgniter.php:355
CodeIgniter\CodeIgniter->handleRequest()
9 SYSTEMPATH/Boot.php:325
CodeIgniter\CodeIgniter->run()
10 SYSTEMPATH/Boot.php:67
CodeIgniter\Boot::runCodeIgniter()
11 FCPATH/index.php:56
CodeIgniter\Boot::bootWeb()
|
0.14 ms |
SELECT `value`
FROM `Avg_values`
LEFT JOIN `Years` `y` ON `y`.`id` = `Avg_values`.`years_id`
LEFT JOIN `Cities` `ci` ON `ci`.`id` = `Avg_values`.`cities_id`
LEFT JOIN `Categories` `ca` ON `ca`.`id` = `Avg_values`.`categories_id`
WHERE `ci`.`id` = '7'
AND `ca`.`id` = '6'
AND `y`.`year` = 2024
AND (
`y`.`deleted_at` IS NULL
)
LIMIT 1 |
APPPATH/Libraries/YearsHelper.php:173 |
|
1 SYSTEMPATH/Database/BaseBuilder.php:1636
CodeIgniter\Database\BaseConnection->query()
2 SYSTEMPATH/Model.php:330
CodeIgniter\Database\BaseBuilder->get()
3 SYSTEMPATH/BaseModel.php:714
CodeIgniter\Model->doFirst()
4 APPPATH/Libraries/YearsHelper.php:173
CodeIgniter\BaseModel->first()
5 APPPATH/Controllers/Home.php:68
App\Libraries\YearsHelper->category_values_by_city()
6 SYSTEMPATH/CodeIgniter.php:933
App\Controllers\Home->index()
7 SYSTEMPATH/CodeIgniter.php:509
CodeIgniter\CodeIgniter->runController()
8 SYSTEMPATH/CodeIgniter.php:355
CodeIgniter\CodeIgniter->handleRequest()
9 SYSTEMPATH/Boot.php:325
CodeIgniter\CodeIgniter->run()
10 SYSTEMPATH/Boot.php:67
CodeIgniter\Boot::runCodeIgniter()
11 FCPATH/index.php:56
CodeIgniter\Boot::bootWeb()
|
0.15 ms |
SELECT `value`
FROM `Avg_values`
LEFT JOIN `Years` `y` ON `y`.`id` = `Avg_values`.`years_id`
LEFT JOIN `Cities` `ci` ON `ci`.`id` = `Avg_values`.`cities_id`
LEFT JOIN `Categories` `ca` ON `ca`.`id` = `Avg_values`.`categories_id`
WHERE `ci`.`id` = '7'
AND `ca`.`id` = '7'
AND `y`.`year` = 2024
AND (
`y`.`deleted_at` IS NULL
)
LIMIT 1 |
APPPATH/Libraries/YearsHelper.php:173 |
|
1 SYSTEMPATH/Database/BaseBuilder.php:1636
CodeIgniter\Database\BaseConnection->query()
2 SYSTEMPATH/Model.php:330
CodeIgniter\Database\BaseBuilder->get()
3 SYSTEMPATH/BaseModel.php:714
CodeIgniter\Model->doFirst()
4 APPPATH/Libraries/YearsHelper.php:173
CodeIgniter\BaseModel->first()
5 APPPATH/Controllers/Home.php:68
App\Libraries\YearsHelper->category_values_by_city()
6 SYSTEMPATH/CodeIgniter.php:933
App\Controllers\Home->index()
7 SYSTEMPATH/CodeIgniter.php:509
CodeIgniter\CodeIgniter->runController()
8 SYSTEMPATH/CodeIgniter.php:355
CodeIgniter\CodeIgniter->handleRequest()
9 SYSTEMPATH/Boot.php:325
CodeIgniter\CodeIgniter->run()
10 SYSTEMPATH/Boot.php:67
CodeIgniter\Boot::runCodeIgniter()
11 FCPATH/index.php:56
CodeIgniter\Boot::bootWeb()
|
0.12 ms |
SELECT `ci`.`id`, `ci`.`name`, `stoplight`, `value`
FROM `General_values`
LEFT JOIN `Years` `y` ON `y`.`id` = `General_values`.`years_id`
LEFT JOIN `Cities` `ci` ON `ci`.`id` = `General_values`.`cities_id`
WHERE `ci`.`id` = '7'
AND `y`.`year` <= 2024
AND (
`y`.`deleted_at` IS NULL
)
LIMIT 1 |
APPPATH/Libraries/YearsHelper.php:210 |
|
1 SYSTEMPATH/Database/BaseBuilder.php:1636
CodeIgniter\Database\BaseConnection->query()
2 SYSTEMPATH/Model.php:330
CodeIgniter\Database\BaseBuilder->get()
3 SYSTEMPATH/BaseModel.php:714
CodeIgniter\Model->doFirst()
4 APPPATH/Libraries/YearsHelper.php:210
CodeIgniter\BaseModel->first()
5 APPPATH/Libraries/YearsHelper.php:238
App\Libraries\YearsHelper->general_values_by_city()
6 APPPATH/Controllers/Home.php:71
App\Libraries\YearsHelper->general_city_score_by_year()
7 SYSTEMPATH/CodeIgniter.php:933
App\Controllers\Home->index()
8 SYSTEMPATH/CodeIgniter.php:509
CodeIgniter\CodeIgniter->runController()
9 SYSTEMPATH/CodeIgniter.php:355
CodeIgniter\CodeIgniter->handleRequest()
10 SYSTEMPATH/Boot.php:325
CodeIgniter\CodeIgniter->run()
11 SYSTEMPATH/Boot.php:67
CodeIgniter\Boot::runCodeIgniter()
12 FCPATH/index.php:56
CodeIgniter\Boot::bootWeb()
|
0.11 ms |
SELECT `ci`.`id`, `ci`.`name`, `stoplight`, `value`
FROM `General_values`
LEFT JOIN `Years` `y` ON `y`.`id` = `General_values`.`years_id`
LEFT JOIN `Cities` `ci` ON `ci`.`id` = `General_values`.`cities_id`
WHERE `ci`.`id` = '10'
AND `y`.`year` <= 2024
AND (
`y`.`deleted_at` IS NULL
)
LIMIT 1 |
APPPATH/Libraries/YearsHelper.php:210 |
|
1 SYSTEMPATH/Database/BaseBuilder.php:1636
CodeIgniter\Database\BaseConnection->query()
2 SYSTEMPATH/Model.php:330
CodeIgniter\Database\BaseBuilder->get()
3 SYSTEMPATH/BaseModel.php:714
CodeIgniter\Model->doFirst()
4 APPPATH/Libraries/YearsHelper.php:210
CodeIgniter\BaseModel->first()
5 APPPATH/Controllers/Home.php:67
App\Libraries\YearsHelper->general_values_by_city()
6 SYSTEMPATH/CodeIgniter.php:933
App\Controllers\Home->index()
7 SYSTEMPATH/CodeIgniter.php:509
CodeIgniter\CodeIgniter->runController()
8 SYSTEMPATH/CodeIgniter.php:355
CodeIgniter\CodeIgniter->handleRequest()
9 SYSTEMPATH/Boot.php:325
CodeIgniter\CodeIgniter->run()
10 SYSTEMPATH/Boot.php:67
CodeIgniter\Boot::runCodeIgniter()
11 FCPATH/index.php:56
CodeIgniter\Boot::bootWeb()
|
0.16 ms |
SELECT `value`
FROM `Avg_values`
LEFT JOIN `Years` `y` ON `y`.`id` = `Avg_values`.`years_id`
LEFT JOIN `Cities` `ci` ON `ci`.`id` = `Avg_values`.`cities_id`
LEFT JOIN `Categories` `ca` ON `ca`.`id` = `Avg_values`.`categories_id`
WHERE `ci`.`id` = '10'
AND `ca`.`id` = '1'
AND `y`.`year` = 2024
AND (
`y`.`deleted_at` IS NULL
)
LIMIT 1 |
APPPATH/Libraries/YearsHelper.php:173 |
|
1 SYSTEMPATH/Database/BaseBuilder.php:1636
CodeIgniter\Database\BaseConnection->query()
2 SYSTEMPATH/Model.php:330
CodeIgniter\Database\BaseBuilder->get()
3 SYSTEMPATH/BaseModel.php:714
CodeIgniter\Model->doFirst()
4 APPPATH/Libraries/YearsHelper.php:173
CodeIgniter\BaseModel->first()
5 APPPATH/Controllers/Home.php:68
App\Libraries\YearsHelper->category_values_by_city()
6 SYSTEMPATH/CodeIgniter.php:933
App\Controllers\Home->index()
7 SYSTEMPATH/CodeIgniter.php:509
CodeIgniter\CodeIgniter->runController()
8 SYSTEMPATH/CodeIgniter.php:355
CodeIgniter\CodeIgniter->handleRequest()
9 SYSTEMPATH/Boot.php:325
CodeIgniter\CodeIgniter->run()
10 SYSTEMPATH/Boot.php:67
CodeIgniter\Boot::runCodeIgniter()
11 FCPATH/index.php:56
CodeIgniter\Boot::bootWeb()
|
0.15 ms |
SELECT `value`
FROM `Avg_values`
LEFT JOIN `Years` `y` ON `y`.`id` = `Avg_values`.`years_id`
LEFT JOIN `Cities` `ci` ON `ci`.`id` = `Avg_values`.`cities_id`
LEFT JOIN `Categories` `ca` ON `ca`.`id` = `Avg_values`.`categories_id`
WHERE `ci`.`id` = '10'
AND `ca`.`id` = '2'
AND `y`.`year` = 2024
AND (
`y`.`deleted_at` IS NULL
)
LIMIT 1 |
APPPATH/Libraries/YearsHelper.php:173 |
|
1 SYSTEMPATH/Database/BaseBuilder.php:1636
CodeIgniter\Database\BaseConnection->query()
2 SYSTEMPATH/Model.php:330
CodeIgniter\Database\BaseBuilder->get()
3 SYSTEMPATH/BaseModel.php:714
CodeIgniter\Model->doFirst()
4 APPPATH/Libraries/YearsHelper.php:173
CodeIgniter\BaseModel->first()
5 APPPATH/Controllers/Home.php:68
App\Libraries\YearsHelper->category_values_by_city()
6 SYSTEMPATH/CodeIgniter.php:933
App\Controllers\Home->index()
7 SYSTEMPATH/CodeIgniter.php:509
CodeIgniter\CodeIgniter->runController()
8 SYSTEMPATH/CodeIgniter.php:355
CodeIgniter\CodeIgniter->handleRequest()
9 SYSTEMPATH/Boot.php:325
CodeIgniter\CodeIgniter->run()
10 SYSTEMPATH/Boot.php:67
CodeIgniter\Boot::runCodeIgniter()
11 FCPATH/index.php:56
CodeIgniter\Boot::bootWeb()
|
0.15 ms |
SELECT `value`
FROM `Avg_values`
LEFT JOIN `Years` `y` ON `y`.`id` = `Avg_values`.`years_id`
LEFT JOIN `Cities` `ci` ON `ci`.`id` = `Avg_values`.`cities_id`
LEFT JOIN `Categories` `ca` ON `ca`.`id` = `Avg_values`.`categories_id`
WHERE `ci`.`id` = '10'
AND `ca`.`id` = '3'
AND `y`.`year` = 2024
AND (
`y`.`deleted_at` IS NULL
)
LIMIT 1 |
APPPATH/Libraries/YearsHelper.php:173 |
|
1 SYSTEMPATH/Database/BaseBuilder.php:1636
CodeIgniter\Database\BaseConnection->query()
2 SYSTEMPATH/Model.php:330
CodeIgniter\Database\BaseBuilder->get()
3 SYSTEMPATH/BaseModel.php:714
CodeIgniter\Model->doFirst()
4 APPPATH/Libraries/YearsHelper.php:173
CodeIgniter\BaseModel->first()
5 APPPATH/Controllers/Home.php:68
App\Libraries\YearsHelper->category_values_by_city()
6 SYSTEMPATH/CodeIgniter.php:933
App\Controllers\Home->index()
7 SYSTEMPATH/CodeIgniter.php:509
CodeIgniter\CodeIgniter->runController()
8 SYSTEMPATH/CodeIgniter.php:355
CodeIgniter\CodeIgniter->handleRequest()
9 SYSTEMPATH/Boot.php:325
CodeIgniter\CodeIgniter->run()
10 SYSTEMPATH/Boot.php:67
CodeIgniter\Boot::runCodeIgniter()
11 FCPATH/index.php:56
CodeIgniter\Boot::bootWeb()
|
0.14 ms |
SELECT `value`
FROM `Avg_values`
LEFT JOIN `Years` `y` ON `y`.`id` = `Avg_values`.`years_id`
LEFT JOIN `Cities` `ci` ON `ci`.`id` = `Avg_values`.`cities_id`
LEFT JOIN `Categories` `ca` ON `ca`.`id` = `Avg_values`.`categories_id`
WHERE `ci`.`id` = '10'
AND `ca`.`id` = '4'
AND `y`.`year` = 2024
AND (
`y`.`deleted_at` IS NULL
)
LIMIT 1 |
APPPATH/Libraries/YearsHelper.php:173 |
|
1 SYSTEMPATH/Database/BaseBuilder.php:1636
CodeIgniter\Database\BaseConnection->query()
2 SYSTEMPATH/Model.php:330
CodeIgniter\Database\BaseBuilder->get()
3 SYSTEMPATH/BaseModel.php:714
CodeIgniter\Model->doFirst()
4 APPPATH/Libraries/YearsHelper.php:173
CodeIgniter\BaseModel->first()
5 APPPATH/Controllers/Home.php:68
App\Libraries\YearsHelper->category_values_by_city()
6 SYSTEMPATH/CodeIgniter.php:933
App\Controllers\Home->index()
7 SYSTEMPATH/CodeIgniter.php:509
CodeIgniter\CodeIgniter->runController()
8 SYSTEMPATH/CodeIgniter.php:355
CodeIgniter\CodeIgniter->handleRequest()
9 SYSTEMPATH/Boot.php:325
CodeIgniter\CodeIgniter->run()
10 SYSTEMPATH/Boot.php:67
CodeIgniter\Boot::runCodeIgniter()
11 FCPATH/index.php:56
CodeIgniter\Boot::bootWeb()
|
0.15 ms |
SELECT `value`
FROM `Avg_values`
LEFT JOIN `Years` `y` ON `y`.`id` = `Avg_values`.`years_id`
LEFT JOIN `Cities` `ci` ON `ci`.`id` = `Avg_values`.`cities_id`
LEFT JOIN `Categories` `ca` ON `ca`.`id` = `Avg_values`.`categories_id`
WHERE `ci`.`id` = '10'
AND `ca`.`id` = '5'
AND `y`.`year` = 2024
AND (
`y`.`deleted_at` IS NULL
)
LIMIT 1 |
APPPATH/Libraries/YearsHelper.php:173 |
|
1 SYSTEMPATH/Database/BaseBuilder.php:1636
CodeIgniter\Database\BaseConnection->query()
2 SYSTEMPATH/Model.php:330
CodeIgniter\Database\BaseBuilder->get()
3 SYSTEMPATH/BaseModel.php:714
CodeIgniter\Model->doFirst()
4 APPPATH/Libraries/YearsHelper.php:173
CodeIgniter\BaseModel->first()
5 APPPATH/Controllers/Home.php:68
App\Libraries\YearsHelper->category_values_by_city()
6 SYSTEMPATH/CodeIgniter.php:933
App\Controllers\Home->index()
7 SYSTEMPATH/CodeIgniter.php:509
CodeIgniter\CodeIgniter->runController()
8 SYSTEMPATH/CodeIgniter.php:355
CodeIgniter\CodeIgniter->handleRequest()
9 SYSTEMPATH/Boot.php:325
CodeIgniter\CodeIgniter->run()
10 SYSTEMPATH/Boot.php:67
CodeIgniter\Boot::runCodeIgniter()
11 FCPATH/index.php:56
CodeIgniter\Boot::bootWeb()
|
0.19 ms |
SELECT `value`
FROM `Avg_values`
LEFT JOIN `Years` `y` ON `y`.`id` = `Avg_values`.`years_id`
LEFT JOIN `Cities` `ci` ON `ci`.`id` = `Avg_values`.`cities_id`
LEFT JOIN `Categories` `ca` ON `ca`.`id` = `Avg_values`.`categories_id`
WHERE `ci`.`id` = '10'
AND `ca`.`id` = '6'
AND `y`.`year` = 2024
AND (
`y`.`deleted_at` IS NULL
)
LIMIT 1 |
APPPATH/Libraries/YearsHelper.php:173 |
|
1 SYSTEMPATH/Database/BaseBuilder.php:1636
CodeIgniter\Database\BaseConnection->query()
2 SYSTEMPATH/Model.php:330
CodeIgniter\Database\BaseBuilder->get()
3 SYSTEMPATH/BaseModel.php:714
CodeIgniter\Model->doFirst()
4 APPPATH/Libraries/YearsHelper.php:173
CodeIgniter\BaseModel->first()
5 APPPATH/Controllers/Home.php:68
App\Libraries\YearsHelper->category_values_by_city()
6 SYSTEMPATH/CodeIgniter.php:933
App\Controllers\Home->index()
7 SYSTEMPATH/CodeIgniter.php:509
CodeIgniter\CodeIgniter->runController()
8 SYSTEMPATH/CodeIgniter.php:355
CodeIgniter\CodeIgniter->handleRequest()
9 SYSTEMPATH/Boot.php:325
CodeIgniter\CodeIgniter->run()
10 SYSTEMPATH/Boot.php:67
CodeIgniter\Boot::runCodeIgniter()
11 FCPATH/index.php:56
CodeIgniter\Boot::bootWeb()
|
0.15 ms |
SELECT `value`
FROM `Avg_values`
LEFT JOIN `Years` `y` ON `y`.`id` = `Avg_values`.`years_id`
LEFT JOIN `Cities` `ci` ON `ci`.`id` = `Avg_values`.`cities_id`
LEFT JOIN `Categories` `ca` ON `ca`.`id` = `Avg_values`.`categories_id`
WHERE `ci`.`id` = '10'
AND `ca`.`id` = '7'
AND `y`.`year` = 2024
AND (
`y`.`deleted_at` IS NULL
)
LIMIT 1 |
APPPATH/Libraries/YearsHelper.php:173 |
|
1 SYSTEMPATH/Database/BaseBuilder.php:1636
CodeIgniter\Database\BaseConnection->query()
2 SYSTEMPATH/Model.php:330
CodeIgniter\Database\BaseBuilder->get()
3 SYSTEMPATH/BaseModel.php:714
CodeIgniter\Model->doFirst()
4 APPPATH/Libraries/YearsHelper.php:173
CodeIgniter\BaseModel->first()
5 APPPATH/Controllers/Home.php:68
App\Libraries\YearsHelper->category_values_by_city()
6 SYSTEMPATH/CodeIgniter.php:933
App\Controllers\Home->index()
7 SYSTEMPATH/CodeIgniter.php:509
CodeIgniter\CodeIgniter->runController()
8 SYSTEMPATH/CodeIgniter.php:355
CodeIgniter\CodeIgniter->handleRequest()
9 SYSTEMPATH/Boot.php:325
CodeIgniter\CodeIgniter->run()
10 SYSTEMPATH/Boot.php:67
CodeIgniter\Boot::runCodeIgniter()
11 FCPATH/index.php:56
CodeIgniter\Boot::bootWeb()
|
0.12 ms |
SELECT `ci`.`id`, `ci`.`name`, `stoplight`, `value`
FROM `General_values`
LEFT JOIN `Years` `y` ON `y`.`id` = `General_values`.`years_id`
LEFT JOIN `Cities` `ci` ON `ci`.`id` = `General_values`.`cities_id`
WHERE `ci`.`id` = '10'
AND `y`.`year` <= 2024
AND (
`y`.`deleted_at` IS NULL
)
LIMIT 1 |
APPPATH/Libraries/YearsHelper.php:210 |
|
1 SYSTEMPATH/Database/BaseBuilder.php:1636
CodeIgniter\Database\BaseConnection->query()
2 SYSTEMPATH/Model.php:330
CodeIgniter\Database\BaseBuilder->get()
3 SYSTEMPATH/BaseModel.php:714
CodeIgniter\Model->doFirst()
4 APPPATH/Libraries/YearsHelper.php:210
CodeIgniter\BaseModel->first()
5 APPPATH/Libraries/YearsHelper.php:238
App\Libraries\YearsHelper->general_values_by_city()
6 APPPATH/Controllers/Home.php:71
App\Libraries\YearsHelper->general_city_score_by_year()
7 SYSTEMPATH/CodeIgniter.php:933
App\Controllers\Home->index()
8 SYSTEMPATH/CodeIgniter.php:509
CodeIgniter\CodeIgniter->runController()
9 SYSTEMPATH/CodeIgniter.php:355
CodeIgniter\CodeIgniter->handleRequest()
10 SYSTEMPATH/Boot.php:325
CodeIgniter\CodeIgniter->run()
11 SYSTEMPATH/Boot.php:67
CodeIgniter\Boot::runCodeIgniter()
12 FCPATH/index.php:56
CodeIgniter\Boot::bootWeb()
|
0.15 ms |
SELECT `ci`.`id`, `ci`.`name`, `stoplight`, `value`
FROM `General_values`
LEFT JOIN `Years` `y` ON `y`.`id` = `General_values`.`years_id`
LEFT JOIN `Cities` `ci` ON `ci`.`id` = `General_values`.`cities_id`
WHERE `ci`.`id` = '18'
AND `y`.`year` <= 2024
AND (
`y`.`deleted_at` IS NULL
)
LIMIT 1 |
APPPATH/Libraries/YearsHelper.php:210 |
|
1 SYSTEMPATH/Database/BaseBuilder.php:1636
CodeIgniter\Database\BaseConnection->query()
2 SYSTEMPATH/Model.php:330
CodeIgniter\Database\BaseBuilder->get()
3 SYSTEMPATH/BaseModel.php:714
CodeIgniter\Model->doFirst()
4 APPPATH/Libraries/YearsHelper.php:210
CodeIgniter\BaseModel->first()
5 APPPATH/Controllers/Home.php:67
App\Libraries\YearsHelper->general_values_by_city()
6 SYSTEMPATH/CodeIgniter.php:933
App\Controllers\Home->index()
7 SYSTEMPATH/CodeIgniter.php:509
CodeIgniter\CodeIgniter->runController()
8 SYSTEMPATH/CodeIgniter.php:355
CodeIgniter\CodeIgniter->handleRequest()
9 SYSTEMPATH/Boot.php:325
CodeIgniter\CodeIgniter->run()
10 SYSTEMPATH/Boot.php:67
CodeIgniter\Boot::runCodeIgniter()
11 FCPATH/index.php:56
CodeIgniter\Boot::bootWeb()
|
0.16 ms |
SELECT `value`
FROM `Avg_values`
LEFT JOIN `Years` `y` ON `y`.`id` = `Avg_values`.`years_id`
LEFT JOIN `Cities` `ci` ON `ci`.`id` = `Avg_values`.`cities_id`
LEFT JOIN `Categories` `ca` ON `ca`.`id` = `Avg_values`.`categories_id`
WHERE `ci`.`id` = '18'
AND `ca`.`id` = '1'
AND `y`.`year` = 2024
AND (
`y`.`deleted_at` IS NULL
)
LIMIT 1 |
APPPATH/Libraries/YearsHelper.php:173 |
|
1 SYSTEMPATH/Database/BaseBuilder.php:1636
CodeIgniter\Database\BaseConnection->query()
2 SYSTEMPATH/Model.php:330
CodeIgniter\Database\BaseBuilder->get()
3 SYSTEMPATH/BaseModel.php:714
CodeIgniter\Model->doFirst()
4 APPPATH/Libraries/YearsHelper.php:173
CodeIgniter\BaseModel->first()
5 APPPATH/Controllers/Home.php:68
App\Libraries\YearsHelper->category_values_by_city()
6 SYSTEMPATH/CodeIgniter.php:933
App\Controllers\Home->index()
7 SYSTEMPATH/CodeIgniter.php:509
CodeIgniter\CodeIgniter->runController()
8 SYSTEMPATH/CodeIgniter.php:355
CodeIgniter\CodeIgniter->handleRequest()
9 SYSTEMPATH/Boot.php:325
CodeIgniter\CodeIgniter->run()
10 SYSTEMPATH/Boot.php:67
CodeIgniter\Boot::runCodeIgniter()
11 FCPATH/index.php:56
CodeIgniter\Boot::bootWeb()
|
0.15 ms |
SELECT `value`
FROM `Avg_values`
LEFT JOIN `Years` `y` ON `y`.`id` = `Avg_values`.`years_id`
LEFT JOIN `Cities` `ci` ON `ci`.`id` = `Avg_values`.`cities_id`
LEFT JOIN `Categories` `ca` ON `ca`.`id` = `Avg_values`.`categories_id`
WHERE `ci`.`id` = '18'
AND `ca`.`id` = '2'
AND `y`.`year` = 2024
AND (
`y`.`deleted_at` IS NULL
)
LIMIT 1 |
APPPATH/Libraries/YearsHelper.php:173 |
|
1 SYSTEMPATH/Database/BaseBuilder.php:1636
CodeIgniter\Database\BaseConnection->query()
2 SYSTEMPATH/Model.php:330
CodeIgniter\Database\BaseBuilder->get()
3 SYSTEMPATH/BaseModel.php:714
CodeIgniter\Model->doFirst()
4 APPPATH/Libraries/YearsHelper.php:173
CodeIgniter\BaseModel->first()
5 APPPATH/Controllers/Home.php:68
App\Libraries\YearsHelper->category_values_by_city()
6 SYSTEMPATH/CodeIgniter.php:933
App\Controllers\Home->index()
7 SYSTEMPATH/CodeIgniter.php:509
CodeIgniter\CodeIgniter->runController()
8 SYSTEMPATH/CodeIgniter.php:355
CodeIgniter\CodeIgniter->handleRequest()
9 SYSTEMPATH/Boot.php:325
CodeIgniter\CodeIgniter->run()
10 SYSTEMPATH/Boot.php:67
CodeIgniter\Boot::runCodeIgniter()
11 FCPATH/index.php:56
CodeIgniter\Boot::bootWeb()
|
0.15 ms |
SELECT `value`
FROM `Avg_values`
LEFT JOIN `Years` `y` ON `y`.`id` = `Avg_values`.`years_id`
LEFT JOIN `Cities` `ci` ON `ci`.`id` = `Avg_values`.`cities_id`
LEFT JOIN `Categories` `ca` ON `ca`.`id` = `Avg_values`.`categories_id`
WHERE `ci`.`id` = '18'
AND `ca`.`id` = '3'
AND `y`.`year` = 2024
AND (
`y`.`deleted_at` IS NULL
)
LIMIT 1 |
APPPATH/Libraries/YearsHelper.php:173 |
|
1 SYSTEMPATH/Database/BaseBuilder.php:1636
CodeIgniter\Database\BaseConnection->query()
2 SYSTEMPATH/Model.php:330
CodeIgniter\Database\BaseBuilder->get()
3 SYSTEMPATH/BaseModel.php:714
CodeIgniter\Model->doFirst()
4 APPPATH/Libraries/YearsHelper.php:173
CodeIgniter\BaseModel->first()
5 APPPATH/Controllers/Home.php:68
App\Libraries\YearsHelper->category_values_by_city()
6 SYSTEMPATH/CodeIgniter.php:933
App\Controllers\Home->index()
7 SYSTEMPATH/CodeIgniter.php:509
CodeIgniter\CodeIgniter->runController()
8 SYSTEMPATH/CodeIgniter.php:355
CodeIgniter\CodeIgniter->handleRequest()
9 SYSTEMPATH/Boot.php:325
CodeIgniter\CodeIgniter->run()
10 SYSTEMPATH/Boot.php:67
CodeIgniter\Boot::runCodeIgniter()
11 FCPATH/index.php:56
CodeIgniter\Boot::bootWeb()
|
0.15 ms |
SELECT `value`
FROM `Avg_values`
LEFT JOIN `Years` `y` ON `y`.`id` = `Avg_values`.`years_id`
LEFT JOIN `Cities` `ci` ON `ci`.`id` = `Avg_values`.`cities_id`
LEFT JOIN `Categories` `ca` ON `ca`.`id` = `Avg_values`.`categories_id`
WHERE `ci`.`id` = '18'
AND `ca`.`id` = '4'
AND `y`.`year` = 2024
AND (
`y`.`deleted_at` IS NULL
)
LIMIT 1 |
APPPATH/Libraries/YearsHelper.php:173 |
|
1 SYSTEMPATH/Database/BaseBuilder.php:1636
CodeIgniter\Database\BaseConnection->query()
2 SYSTEMPATH/Model.php:330
CodeIgniter\Database\BaseBuilder->get()
3 SYSTEMPATH/BaseModel.php:714
CodeIgniter\Model->doFirst()
4 APPPATH/Libraries/YearsHelper.php:173
CodeIgniter\BaseModel->first()
5 APPPATH/Controllers/Home.php:68
App\Libraries\YearsHelper->category_values_by_city()
6 SYSTEMPATH/CodeIgniter.php:933
App\Controllers\Home->index()
7 SYSTEMPATH/CodeIgniter.php:509
CodeIgniter\CodeIgniter->runController()
8 SYSTEMPATH/CodeIgniter.php:355
CodeIgniter\CodeIgniter->handleRequest()
9 SYSTEMPATH/Boot.php:325
CodeIgniter\CodeIgniter->run()
10 SYSTEMPATH/Boot.php:67
CodeIgniter\Boot::runCodeIgniter()
11 FCPATH/index.php:56
CodeIgniter\Boot::bootWeb()
|
0.17 ms |
SELECT `value`
FROM `Avg_values`
LEFT JOIN `Years` `y` ON `y`.`id` = `Avg_values`.`years_id`
LEFT JOIN `Cities` `ci` ON `ci`.`id` = `Avg_values`.`cities_id`
LEFT JOIN `Categories` `ca` ON `ca`.`id` = `Avg_values`.`categories_id`
WHERE `ci`.`id` = '18'
AND `ca`.`id` = '5'
AND `y`.`year` = 2024
AND (
`y`.`deleted_at` IS NULL
)
LIMIT 1 |
APPPATH/Libraries/YearsHelper.php:173 |
|
1 SYSTEMPATH/Database/BaseBuilder.php:1636
CodeIgniter\Database\BaseConnection->query()
2 SYSTEMPATH/Model.php:330
CodeIgniter\Database\BaseBuilder->get()
3 SYSTEMPATH/BaseModel.php:714
CodeIgniter\Model->doFirst()
4 APPPATH/Libraries/YearsHelper.php:173
CodeIgniter\BaseModel->first()
5 APPPATH/Controllers/Home.php:68
App\Libraries\YearsHelper->category_values_by_city()
6 SYSTEMPATH/CodeIgniter.php:933
App\Controllers\Home->index()
7 SYSTEMPATH/CodeIgniter.php:509
CodeIgniter\CodeIgniter->runController()
8 SYSTEMPATH/CodeIgniter.php:355
CodeIgniter\CodeIgniter->handleRequest()
9 SYSTEMPATH/Boot.php:325
CodeIgniter\CodeIgniter->run()
10 SYSTEMPATH/Boot.php:67
CodeIgniter\Boot::runCodeIgniter()
11 FCPATH/index.php:56
CodeIgniter\Boot::bootWeb()
|
0.17 ms |
SELECT `value`
FROM `Avg_values`
LEFT JOIN `Years` `y` ON `y`.`id` = `Avg_values`.`years_id`
LEFT JOIN `Cities` `ci` ON `ci`.`id` = `Avg_values`.`cities_id`
LEFT JOIN `Categories` `ca` ON `ca`.`id` = `Avg_values`.`categories_id`
WHERE `ci`.`id` = '18'
AND `ca`.`id` = '6'
AND `y`.`year` = 2024
AND (
`y`.`deleted_at` IS NULL
)
LIMIT 1 |
APPPATH/Libraries/YearsHelper.php:173 |
|
1 SYSTEMPATH/Database/BaseBuilder.php:1636
CodeIgniter\Database\BaseConnection->query()
2 SYSTEMPATH/Model.php:330
CodeIgniter\Database\BaseBuilder->get()
3 SYSTEMPATH/BaseModel.php:714
CodeIgniter\Model->doFirst()
4 APPPATH/Libraries/YearsHelper.php:173
CodeIgniter\BaseModel->first()
5 APPPATH/Controllers/Home.php:68
App\Libraries\YearsHelper->category_values_by_city()
6 SYSTEMPATH/CodeIgniter.php:933
App\Controllers\Home->index()
7 SYSTEMPATH/CodeIgniter.php:509
CodeIgniter\CodeIgniter->runController()
8 SYSTEMPATH/CodeIgniter.php:355
CodeIgniter\CodeIgniter->handleRequest()
9 SYSTEMPATH/Boot.php:325
CodeIgniter\CodeIgniter->run()
10 SYSTEMPATH/Boot.php:67
CodeIgniter\Boot::runCodeIgniter()
11 FCPATH/index.php:56
CodeIgniter\Boot::bootWeb()
|
0.15 ms |
SELECT `value`
FROM `Avg_values`
LEFT JOIN `Years` `y` ON `y`.`id` = `Avg_values`.`years_id`
LEFT JOIN `Cities` `ci` ON `ci`.`id` = `Avg_values`.`cities_id`
LEFT JOIN `Categories` `ca` ON `ca`.`id` = `Avg_values`.`categories_id`
WHERE `ci`.`id` = '18'
AND `ca`.`id` = '7'
AND `y`.`year` = 2024
AND (
`y`.`deleted_at` IS NULL
)
LIMIT 1 |
APPPATH/Libraries/YearsHelper.php:173 |
|
1 SYSTEMPATH/Database/BaseBuilder.php:1636
CodeIgniter\Database\BaseConnection->query()
2 SYSTEMPATH/Model.php:330
CodeIgniter\Database\BaseBuilder->get()
3 SYSTEMPATH/BaseModel.php:714
CodeIgniter\Model->doFirst()
4 APPPATH/Libraries/YearsHelper.php:173
CodeIgniter\BaseModel->first()
5 APPPATH/Controllers/Home.php:68
App\Libraries\YearsHelper->category_values_by_city()
6 SYSTEMPATH/CodeIgniter.php:933
App\Controllers\Home->index()
7 SYSTEMPATH/CodeIgniter.php:509
CodeIgniter\CodeIgniter->runController()
8 SYSTEMPATH/CodeIgniter.php:355
CodeIgniter\CodeIgniter->handleRequest()
9 SYSTEMPATH/Boot.php:325
CodeIgniter\CodeIgniter->run()
10 SYSTEMPATH/Boot.php:67
CodeIgniter\Boot::runCodeIgniter()
11 FCPATH/index.php:56
CodeIgniter\Boot::bootWeb()
|
0.12 ms |
SELECT `ci`.`id`, `ci`.`name`, `stoplight`, `value`
FROM `General_values`
LEFT JOIN `Years` `y` ON `y`.`id` = `General_values`.`years_id`
LEFT JOIN `Cities` `ci` ON `ci`.`id` = `General_values`.`cities_id`
WHERE `ci`.`id` = '18'
AND `y`.`year` <= 2024
AND (
`y`.`deleted_at` IS NULL
)
LIMIT 1 |
APPPATH/Libraries/YearsHelper.php:210 |
|
1 SYSTEMPATH/Database/BaseBuilder.php:1636
CodeIgniter\Database\BaseConnection->query()
2 SYSTEMPATH/Model.php:330
CodeIgniter\Database\BaseBuilder->get()
3 SYSTEMPATH/BaseModel.php:714
CodeIgniter\Model->doFirst()
4 APPPATH/Libraries/YearsHelper.php:210
CodeIgniter\BaseModel->first()
5 APPPATH/Libraries/YearsHelper.php:238
App\Libraries\YearsHelper->general_values_by_city()
6 APPPATH/Controllers/Home.php:71
App\Libraries\YearsHelper->general_city_score_by_year()
7 SYSTEMPATH/CodeIgniter.php:933
App\Controllers\Home->index()
8 SYSTEMPATH/CodeIgniter.php:509
CodeIgniter\CodeIgniter->runController()
9 SYSTEMPATH/CodeIgniter.php:355
CodeIgniter\CodeIgniter->handleRequest()
10 SYSTEMPATH/Boot.php:325
CodeIgniter\CodeIgniter->run()
11 SYSTEMPATH/Boot.php:67
CodeIgniter\Boot::runCodeIgniter()
12 FCPATH/index.php:56
CodeIgniter\Boot::bootWeb()
|
0.12 ms |
SELECT `ci`.`id`, `ci`.`name`, `stoplight`, `value`
FROM `General_values`
LEFT JOIN `Years` `y` ON `y`.`id` = `General_values`.`years_id`
LEFT JOIN `Cities` `ci` ON `ci`.`id` = `General_values`.`cities_id`
WHERE `ci`.`id` = '20'
AND `y`.`year` <= 2024
AND (
`y`.`deleted_at` IS NULL
)
LIMIT 1 |
APPPATH/Libraries/YearsHelper.php:210 |
|
1 SYSTEMPATH/Database/BaseBuilder.php:1636
CodeIgniter\Database\BaseConnection->query()
2 SYSTEMPATH/Model.php:330
CodeIgniter\Database\BaseBuilder->get()
3 SYSTEMPATH/BaseModel.php:714
CodeIgniter\Model->doFirst()
4 APPPATH/Libraries/YearsHelper.php:210
CodeIgniter\BaseModel->first()
5 APPPATH/Controllers/Home.php:67
App\Libraries\YearsHelper->general_values_by_city()
6 SYSTEMPATH/CodeIgniter.php:933
App\Controllers\Home->index()
7 SYSTEMPATH/CodeIgniter.php:509
CodeIgniter\CodeIgniter->runController()
8 SYSTEMPATH/CodeIgniter.php:355
CodeIgniter\CodeIgniter->handleRequest()
9 SYSTEMPATH/Boot.php:325
CodeIgniter\CodeIgniter->run()
10 SYSTEMPATH/Boot.php:67
CodeIgniter\Boot::runCodeIgniter()
11 FCPATH/index.php:56
CodeIgniter\Boot::bootWeb()
|
0.16 ms |
SELECT `value`
FROM `Avg_values`
LEFT JOIN `Years` `y` ON `y`.`id` = `Avg_values`.`years_id`
LEFT JOIN `Cities` `ci` ON `ci`.`id` = `Avg_values`.`cities_id`
LEFT JOIN `Categories` `ca` ON `ca`.`id` = `Avg_values`.`categories_id`
WHERE `ci`.`id` = '20'
AND `ca`.`id` = '1'
AND `y`.`year` = 2024
AND (
`y`.`deleted_at` IS NULL
)
LIMIT 1 |
APPPATH/Libraries/YearsHelper.php:173 |
|
1 SYSTEMPATH/Database/BaseBuilder.php:1636
CodeIgniter\Database\BaseConnection->query()
2 SYSTEMPATH/Model.php:330
CodeIgniter\Database\BaseBuilder->get()
3 SYSTEMPATH/BaseModel.php:714
CodeIgniter\Model->doFirst()
4 APPPATH/Libraries/YearsHelper.php:173
CodeIgniter\BaseModel->first()
5 APPPATH/Controllers/Home.php:68
App\Libraries\YearsHelper->category_values_by_city()
6 SYSTEMPATH/CodeIgniter.php:933
App\Controllers\Home->index()
7 SYSTEMPATH/CodeIgniter.php:509
CodeIgniter\CodeIgniter->runController()
8 SYSTEMPATH/CodeIgniter.php:355
CodeIgniter\CodeIgniter->handleRequest()
9 SYSTEMPATH/Boot.php:325
CodeIgniter\CodeIgniter->run()
10 SYSTEMPATH/Boot.php:67
CodeIgniter\Boot::runCodeIgniter()
11 FCPATH/index.php:56
CodeIgniter\Boot::bootWeb()
|
0.17 ms |
SELECT `value`
FROM `Avg_values`
LEFT JOIN `Years` `y` ON `y`.`id` = `Avg_values`.`years_id`
LEFT JOIN `Cities` `ci` ON `ci`.`id` = `Avg_values`.`cities_id`
LEFT JOIN `Categories` `ca` ON `ca`.`id` = `Avg_values`.`categories_id`
WHERE `ci`.`id` = '20'
AND `ca`.`id` = '2'
AND `y`.`year` = 2024
AND (
`y`.`deleted_at` IS NULL
)
LIMIT 1 |
APPPATH/Libraries/YearsHelper.php:173 |
|
1 SYSTEMPATH/Database/BaseBuilder.php:1636
CodeIgniter\Database\BaseConnection->query()
2 SYSTEMPATH/Model.php:330
CodeIgniter\Database\BaseBuilder->get()
3 SYSTEMPATH/BaseModel.php:714
CodeIgniter\Model->doFirst()
4 APPPATH/Libraries/YearsHelper.php:173
CodeIgniter\BaseModel->first()
5 APPPATH/Controllers/Home.php:68
App\Libraries\YearsHelper->category_values_by_city()
6 SYSTEMPATH/CodeIgniter.php:933
App\Controllers\Home->index()
7 SYSTEMPATH/CodeIgniter.php:509
CodeIgniter\CodeIgniter->runController()
8 SYSTEMPATH/CodeIgniter.php:355
CodeIgniter\CodeIgniter->handleRequest()
9 SYSTEMPATH/Boot.php:325
CodeIgniter\CodeIgniter->run()
10 SYSTEMPATH/Boot.php:67
CodeIgniter\Boot::runCodeIgniter()
11 FCPATH/index.php:56
CodeIgniter\Boot::bootWeb()
|
0.17 ms |
SELECT `value`
FROM `Avg_values`
LEFT JOIN `Years` `y` ON `y`.`id` = `Avg_values`.`years_id`
LEFT JOIN `Cities` `ci` ON `ci`.`id` = `Avg_values`.`cities_id`
LEFT JOIN `Categories` `ca` ON `ca`.`id` = `Avg_values`.`categories_id`
WHERE `ci`.`id` = '20'
AND `ca`.`id` = '3'
AND `y`.`year` = 2024
AND (
`y`.`deleted_at` IS NULL
)
LIMIT 1 |
APPPATH/Libraries/YearsHelper.php:173 |
|
1 SYSTEMPATH/Database/BaseBuilder.php:1636
CodeIgniter\Database\BaseConnection->query()
2 SYSTEMPATH/Model.php:330
CodeIgniter\Database\BaseBuilder->get()
3 SYSTEMPATH/BaseModel.php:714
CodeIgniter\Model->doFirst()
4 APPPATH/Libraries/YearsHelper.php:173
CodeIgniter\BaseModel->first()
5 APPPATH/Controllers/Home.php:68
App\Libraries\YearsHelper->category_values_by_city()
6 SYSTEMPATH/CodeIgniter.php:933
App\Controllers\Home->index()
7 SYSTEMPATH/CodeIgniter.php:509
CodeIgniter\CodeIgniter->runController()
8 SYSTEMPATH/CodeIgniter.php:355
CodeIgniter\CodeIgniter->handleRequest()
9 SYSTEMPATH/Boot.php:325
CodeIgniter\CodeIgniter->run()
10 SYSTEMPATH/Boot.php:67
CodeIgniter\Boot::runCodeIgniter()
11 FCPATH/index.php:56
CodeIgniter\Boot::bootWeb()
|
0.16 ms |
SELECT `value`
FROM `Avg_values`
LEFT JOIN `Years` `y` ON `y`.`id` = `Avg_values`.`years_id`
LEFT JOIN `Cities` `ci` ON `ci`.`id` = `Avg_values`.`cities_id`
LEFT JOIN `Categories` `ca` ON `ca`.`id` = `Avg_values`.`categories_id`
WHERE `ci`.`id` = '20'
AND `ca`.`id` = '4'
AND `y`.`year` = 2024
AND (
`y`.`deleted_at` IS NULL
)
LIMIT 1 |
APPPATH/Libraries/YearsHelper.php:173 |
|
1 SYSTEMPATH/Database/BaseBuilder.php:1636
CodeIgniter\Database\BaseConnection->query()
2 SYSTEMPATH/Model.php:330
CodeIgniter\Database\BaseBuilder->get()
3 SYSTEMPATH/BaseModel.php:714
CodeIgniter\Model->doFirst()
4 APPPATH/Libraries/YearsHelper.php:173
CodeIgniter\BaseModel->first()
5 APPPATH/Controllers/Home.php:68
App\Libraries\YearsHelper->category_values_by_city()
6 SYSTEMPATH/CodeIgniter.php:933
App\Controllers\Home->index()
7 SYSTEMPATH/CodeIgniter.php:509
CodeIgniter\CodeIgniter->runController()
8 SYSTEMPATH/CodeIgniter.php:355
CodeIgniter\CodeIgniter->handleRequest()
9 SYSTEMPATH/Boot.php:325
CodeIgniter\CodeIgniter->run()
10 SYSTEMPATH/Boot.php:67
CodeIgniter\Boot::runCodeIgniter()
11 FCPATH/index.php:56
CodeIgniter\Boot::bootWeb()
|
0.17 ms |
SELECT `value`
FROM `Avg_values`
LEFT JOIN `Years` `y` ON `y`.`id` = `Avg_values`.`years_id`
LEFT JOIN `Cities` `ci` ON `ci`.`id` = `Avg_values`.`cities_id`
LEFT JOIN `Categories` `ca` ON `ca`.`id` = `Avg_values`.`categories_id`
WHERE `ci`.`id` = '20'
AND `ca`.`id` = '5'
AND `y`.`year` = 2024
AND (
`y`.`deleted_at` IS NULL
)
LIMIT 1 |
APPPATH/Libraries/YearsHelper.php:173 |
|
1 SYSTEMPATH/Database/BaseBuilder.php:1636
CodeIgniter\Database\BaseConnection->query()
2 SYSTEMPATH/Model.php:330
CodeIgniter\Database\BaseBuilder->get()
3 SYSTEMPATH/BaseModel.php:714
CodeIgniter\Model->doFirst()
4 APPPATH/Libraries/YearsHelper.php:173
CodeIgniter\BaseModel->first()
5 APPPATH/Controllers/Home.php:68
App\Libraries\YearsHelper->category_values_by_city()
6 SYSTEMPATH/CodeIgniter.php:933
App\Controllers\Home->index()
7 SYSTEMPATH/CodeIgniter.php:509
CodeIgniter\CodeIgniter->runController()
8 SYSTEMPATH/CodeIgniter.php:355
CodeIgniter\CodeIgniter->handleRequest()
9 SYSTEMPATH/Boot.php:325
CodeIgniter\CodeIgniter->run()
10 SYSTEMPATH/Boot.php:67
CodeIgniter\Boot::runCodeIgniter()
11 FCPATH/index.php:56
CodeIgniter\Boot::bootWeb()
|
0.2 ms |
SELECT `value`
FROM `Avg_values`
LEFT JOIN `Years` `y` ON `y`.`id` = `Avg_values`.`years_id`
LEFT JOIN `Cities` `ci` ON `ci`.`id` = `Avg_values`.`cities_id`
LEFT JOIN `Categories` `ca` ON `ca`.`id` = `Avg_values`.`categories_id`
WHERE `ci`.`id` = '20'
AND `ca`.`id` = '6'
AND `y`.`year` = 2024
AND (
`y`.`deleted_at` IS NULL
)
LIMIT 1 |
APPPATH/Libraries/YearsHelper.php:173 |
|
1 SYSTEMPATH/Database/BaseBuilder.php:1636
CodeIgniter\Database\BaseConnection->query()
2 SYSTEMPATH/Model.php:330
CodeIgniter\Database\BaseBuilder->get()
3 SYSTEMPATH/BaseModel.php:714
CodeIgniter\Model->doFirst()
4 APPPATH/Libraries/YearsHelper.php:173
CodeIgniter\BaseModel->first()
5 APPPATH/Controllers/Home.php:68
App\Libraries\YearsHelper->category_values_by_city()
6 SYSTEMPATH/CodeIgniter.php:933
App\Controllers\Home->index()
7 SYSTEMPATH/CodeIgniter.php:509
CodeIgniter\CodeIgniter->runController()
8 SYSTEMPATH/CodeIgniter.php:355
CodeIgniter\CodeIgniter->handleRequest()
9 SYSTEMPATH/Boot.php:325
CodeIgniter\CodeIgniter->run()
10 SYSTEMPATH/Boot.php:67
CodeIgniter\Boot::runCodeIgniter()
11 FCPATH/index.php:56
CodeIgniter\Boot::bootWeb()
|
0.16 ms |
SELECT `value`
FROM `Avg_values`
LEFT JOIN `Years` `y` ON `y`.`id` = `Avg_values`.`years_id`
LEFT JOIN `Cities` `ci` ON `ci`.`id` = `Avg_values`.`cities_id`
LEFT JOIN `Categories` `ca` ON `ca`.`id` = `Avg_values`.`categories_id`
WHERE `ci`.`id` = '20'
AND `ca`.`id` = '7'
AND `y`.`year` = 2024
AND (
`y`.`deleted_at` IS NULL
)
LIMIT 1 |
APPPATH/Libraries/YearsHelper.php:173 |
|
1 SYSTEMPATH/Database/BaseBuilder.php:1636
CodeIgniter\Database\BaseConnection->query()
2 SYSTEMPATH/Model.php:330
CodeIgniter\Database\BaseBuilder->get()
3 SYSTEMPATH/BaseModel.php:714
CodeIgniter\Model->doFirst()
4 APPPATH/Libraries/YearsHelper.php:173
CodeIgniter\BaseModel->first()
5 APPPATH/Controllers/Home.php:68
App\Libraries\YearsHelper->category_values_by_city()
6 SYSTEMPATH/CodeIgniter.php:933
App\Controllers\Home->index()
7 SYSTEMPATH/CodeIgniter.php:509
CodeIgniter\CodeIgniter->runController()
8 SYSTEMPATH/CodeIgniter.php:355
CodeIgniter\CodeIgniter->handleRequest()
9 SYSTEMPATH/Boot.php:325
CodeIgniter\CodeIgniter->run()
10 SYSTEMPATH/Boot.php:67
CodeIgniter\Boot::runCodeIgniter()
11 FCPATH/index.php:56
CodeIgniter\Boot::bootWeb()
|
0.12 ms |
SELECT `ci`.`id`, `ci`.`name`, `stoplight`, `value`
FROM `General_values`
LEFT JOIN `Years` `y` ON `y`.`id` = `General_values`.`years_id`
LEFT JOIN `Cities` `ci` ON `ci`.`id` = `General_values`.`cities_id`
WHERE `ci`.`id` = '20'
AND `y`.`year` <= 2024
AND (
`y`.`deleted_at` IS NULL
)
LIMIT 1 |
APPPATH/Libraries/YearsHelper.php:210 |
|
1 SYSTEMPATH/Database/BaseBuilder.php:1636
CodeIgniter\Database\BaseConnection->query()
2 SYSTEMPATH/Model.php:330
CodeIgniter\Database\BaseBuilder->get()
3 SYSTEMPATH/BaseModel.php:714
CodeIgniter\Model->doFirst()
4 APPPATH/Libraries/YearsHelper.php:210
CodeIgniter\BaseModel->first()
5 APPPATH/Libraries/YearsHelper.php:238
App\Libraries\YearsHelper->general_values_by_city()
6 APPPATH/Controllers/Home.php:71
App\Libraries\YearsHelper->general_city_score_by_year()
7 SYSTEMPATH/CodeIgniter.php:933
App\Controllers\Home->index()
8 SYSTEMPATH/CodeIgniter.php:509
CodeIgniter\CodeIgniter->runController()
9 SYSTEMPATH/CodeIgniter.php:355
CodeIgniter\CodeIgniter->handleRequest()
10 SYSTEMPATH/Boot.php:325
CodeIgniter\CodeIgniter->run()
11 SYSTEMPATH/Boot.php:67
CodeIgniter\Boot::runCodeIgniter()
12 FCPATH/index.php:56
CodeIgniter\Boot::bootWeb()
|
0.12 ms |
SELECT `ci`.`id`, `ci`.`name`, `stoplight`, `value`
FROM `General_values`
LEFT JOIN `Years` `y` ON `y`.`id` = `General_values`.`years_id`
LEFT JOIN `Cities` `ci` ON `ci`.`id` = `General_values`.`cities_id`
WHERE `ci`.`id` = '27'
AND `y`.`year` <= 2024
AND (
`y`.`deleted_at` IS NULL
)
LIMIT 1 |
APPPATH/Libraries/YearsHelper.php:210 |
|
1 SYSTEMPATH/Database/BaseBuilder.php:1636
CodeIgniter\Database\BaseConnection->query()
2 SYSTEMPATH/Model.php:330
CodeIgniter\Database\BaseBuilder->get()
3 SYSTEMPATH/BaseModel.php:714
CodeIgniter\Model->doFirst()
4 APPPATH/Libraries/YearsHelper.php:210
CodeIgniter\BaseModel->first()
5 APPPATH/Controllers/Home.php:67
App\Libraries\YearsHelper->general_values_by_city()
6 SYSTEMPATH/CodeIgniter.php:933
App\Controllers\Home->index()
7 SYSTEMPATH/CodeIgniter.php:509
CodeIgniter\CodeIgniter->runController()
8 SYSTEMPATH/CodeIgniter.php:355
CodeIgniter\CodeIgniter->handleRequest()
9 SYSTEMPATH/Boot.php:325
CodeIgniter\CodeIgniter->run()
10 SYSTEMPATH/Boot.php:67
CodeIgniter\Boot::runCodeIgniter()
11 FCPATH/index.php:56
CodeIgniter\Boot::bootWeb()
|
0.16 ms |
SELECT `value`
FROM `Avg_values`
LEFT JOIN `Years` `y` ON `y`.`id` = `Avg_values`.`years_id`
LEFT JOIN `Cities` `ci` ON `ci`.`id` = `Avg_values`.`cities_id`
LEFT JOIN `Categories` `ca` ON `ca`.`id` = `Avg_values`.`categories_id`
WHERE `ci`.`id` = '27'
AND `ca`.`id` = '1'
AND `y`.`year` = 2024
AND (
`y`.`deleted_at` IS NULL
)
LIMIT 1 |
APPPATH/Libraries/YearsHelper.php:173 |
|
1 SYSTEMPATH/Database/BaseBuilder.php:1636
CodeIgniter\Database\BaseConnection->query()
2 SYSTEMPATH/Model.php:330
CodeIgniter\Database\BaseBuilder->get()
3 SYSTEMPATH/BaseModel.php:714
CodeIgniter\Model->doFirst()
4 APPPATH/Libraries/YearsHelper.php:173
CodeIgniter\BaseModel->first()
5 APPPATH/Controllers/Home.php:68
App\Libraries\YearsHelper->category_values_by_city()
6 SYSTEMPATH/CodeIgniter.php:933
App\Controllers\Home->index()
7 SYSTEMPATH/CodeIgniter.php:509
CodeIgniter\CodeIgniter->runController()
8 SYSTEMPATH/CodeIgniter.php:355
CodeIgniter\CodeIgniter->handleRequest()
9 SYSTEMPATH/Boot.php:325
CodeIgniter\CodeIgniter->run()
10 SYSTEMPATH/Boot.php:67
CodeIgniter\Boot::runCodeIgniter()
11 FCPATH/index.php:56
CodeIgniter\Boot::bootWeb()
|
0.17 ms |
SELECT `value`
FROM `Avg_values`
LEFT JOIN `Years` `y` ON `y`.`id` = `Avg_values`.`years_id`
LEFT JOIN `Cities` `ci` ON `ci`.`id` = `Avg_values`.`cities_id`
LEFT JOIN `Categories` `ca` ON `ca`.`id` = `Avg_values`.`categories_id`
WHERE `ci`.`id` = '27'
AND `ca`.`id` = '2'
AND `y`.`year` = 2024
AND (
`y`.`deleted_at` IS NULL
)
LIMIT 1 |
APPPATH/Libraries/YearsHelper.php:173 |
|
1 SYSTEMPATH/Database/BaseBuilder.php:1636
CodeIgniter\Database\BaseConnection->query()
2 SYSTEMPATH/Model.php:330
CodeIgniter\Database\BaseBuilder->get()
3 SYSTEMPATH/BaseModel.php:714
CodeIgniter\Model->doFirst()
4 APPPATH/Libraries/YearsHelper.php:173
CodeIgniter\BaseModel->first()
5 APPPATH/Controllers/Home.php:68
App\Libraries\YearsHelper->category_values_by_city()
6 SYSTEMPATH/CodeIgniter.php:933
App\Controllers\Home->index()
7 SYSTEMPATH/CodeIgniter.php:509
CodeIgniter\CodeIgniter->runController()
8 SYSTEMPATH/CodeIgniter.php:355
CodeIgniter\CodeIgniter->handleRequest()
9 SYSTEMPATH/Boot.php:325
CodeIgniter\CodeIgniter->run()
10 SYSTEMPATH/Boot.php:67
CodeIgniter\Boot::runCodeIgniter()
11 FCPATH/index.php:56
CodeIgniter\Boot::bootWeb()
|
0.16 ms |
SELECT `value`
FROM `Avg_values`
LEFT JOIN `Years` `y` ON `y`.`id` = `Avg_values`.`years_id`
LEFT JOIN `Cities` `ci` ON `ci`.`id` = `Avg_values`.`cities_id`
LEFT JOIN `Categories` `ca` ON `ca`.`id` = `Avg_values`.`categories_id`
WHERE `ci`.`id` = '27'
AND `ca`.`id` = '3'
AND `y`.`year` = 2024
AND (
`y`.`deleted_at` IS NULL
)
LIMIT 1 |
APPPATH/Libraries/YearsHelper.php:173 |
|
1 SYSTEMPATH/Database/BaseBuilder.php:1636
CodeIgniter\Database\BaseConnection->query()
2 SYSTEMPATH/Model.php:330
CodeIgniter\Database\BaseBuilder->get()
3 SYSTEMPATH/BaseModel.php:714
CodeIgniter\Model->doFirst()
4 APPPATH/Libraries/YearsHelper.php:173
CodeIgniter\BaseModel->first()
5 APPPATH/Controllers/Home.php:68
App\Libraries\YearsHelper->category_values_by_city()
6 SYSTEMPATH/CodeIgniter.php:933
App\Controllers\Home->index()
7 SYSTEMPATH/CodeIgniter.php:509
CodeIgniter\CodeIgniter->runController()
8 SYSTEMPATH/CodeIgniter.php:355
CodeIgniter\CodeIgniter->handleRequest()
9 SYSTEMPATH/Boot.php:325
CodeIgniter\CodeIgniter->run()
10 SYSTEMPATH/Boot.php:67
CodeIgniter\Boot::runCodeIgniter()
11 FCPATH/index.php:56
CodeIgniter\Boot::bootWeb()
|
0.15 ms |
SELECT `value`
FROM `Avg_values`
LEFT JOIN `Years` `y` ON `y`.`id` = `Avg_values`.`years_id`
LEFT JOIN `Cities` `ci` ON `ci`.`id` = `Avg_values`.`cities_id`
LEFT JOIN `Categories` `ca` ON `ca`.`id` = `Avg_values`.`categories_id`
WHERE `ci`.`id` = '27'
AND `ca`.`id` = '4'
AND `y`.`year` = 2024
AND (
`y`.`deleted_at` IS NULL
)
LIMIT 1 |
APPPATH/Libraries/YearsHelper.php:173 |
|
1 SYSTEMPATH/Database/BaseBuilder.php:1636
CodeIgniter\Database\BaseConnection->query()
2 SYSTEMPATH/Model.php:330
CodeIgniter\Database\BaseBuilder->get()
3 SYSTEMPATH/BaseModel.php:714
CodeIgniter\Model->doFirst()
4 APPPATH/Libraries/YearsHelper.php:173
CodeIgniter\BaseModel->first()
5 APPPATH/Controllers/Home.php:68
App\Libraries\YearsHelper->category_values_by_city()
6 SYSTEMPATH/CodeIgniter.php:933
App\Controllers\Home->index()
7 SYSTEMPATH/CodeIgniter.php:509
CodeIgniter\CodeIgniter->runController()
8 SYSTEMPATH/CodeIgniter.php:355
CodeIgniter\CodeIgniter->handleRequest()
9 SYSTEMPATH/Boot.php:325
CodeIgniter\CodeIgniter->run()
10 SYSTEMPATH/Boot.php:67
CodeIgniter\Boot::runCodeIgniter()
11 FCPATH/index.php:56
CodeIgniter\Boot::bootWeb()
|
0.17 ms |
SELECT `value`
FROM `Avg_values`
LEFT JOIN `Years` `y` ON `y`.`id` = `Avg_values`.`years_id`
LEFT JOIN `Cities` `ci` ON `ci`.`id` = `Avg_values`.`cities_id`
LEFT JOIN `Categories` `ca` ON `ca`.`id` = `Avg_values`.`categories_id`
WHERE `ci`.`id` = '27'
AND `ca`.`id` = '5'
AND `y`.`year` = 2024
AND (
`y`.`deleted_at` IS NULL
)
LIMIT 1 |
APPPATH/Libraries/YearsHelper.php:173 |
|
1 SYSTEMPATH/Database/BaseBuilder.php:1636
CodeIgniter\Database\BaseConnection->query()
2 SYSTEMPATH/Model.php:330
CodeIgniter\Database\BaseBuilder->get()
3 SYSTEMPATH/BaseModel.php:714
CodeIgniter\Model->doFirst()
4 APPPATH/Libraries/YearsHelper.php:173
CodeIgniter\BaseModel->first()
5 APPPATH/Controllers/Home.php:68
App\Libraries\YearsHelper->category_values_by_city()
6 SYSTEMPATH/CodeIgniter.php:933
App\Controllers\Home->index()
7 SYSTEMPATH/CodeIgniter.php:509
CodeIgniter\CodeIgniter->runController()
8 SYSTEMPATH/CodeIgniter.php:355
CodeIgniter\CodeIgniter->handleRequest()
9 SYSTEMPATH/Boot.php:325
CodeIgniter\CodeIgniter->run()
10 SYSTEMPATH/Boot.php:67
CodeIgniter\Boot::runCodeIgniter()
11 FCPATH/index.php:56
CodeIgniter\Boot::bootWeb()
|
0.15 ms |
SELECT `value`
FROM `Avg_values`
LEFT JOIN `Years` `y` ON `y`.`id` = `Avg_values`.`years_id`
LEFT JOIN `Cities` `ci` ON `ci`.`id` = `Avg_values`.`cities_id`
LEFT JOIN `Categories` `ca` ON `ca`.`id` = `Avg_values`.`categories_id`
WHERE `ci`.`id` = '27'
AND `ca`.`id` = '6'
AND `y`.`year` = 2024
AND (
`y`.`deleted_at` IS NULL
)
LIMIT 1 |
APPPATH/Libraries/YearsHelper.php:173 |
|
1 SYSTEMPATH/Database/BaseBuilder.php:1636
CodeIgniter\Database\BaseConnection->query()
2 SYSTEMPATH/Model.php:330
CodeIgniter\Database\BaseBuilder->get()
3 SYSTEMPATH/BaseModel.php:714
CodeIgniter\Model->doFirst()
4 APPPATH/Libraries/YearsHelper.php:173
CodeIgniter\BaseModel->first()
5 APPPATH/Controllers/Home.php:68
App\Libraries\YearsHelper->category_values_by_city()
6 SYSTEMPATH/CodeIgniter.php:933
App\Controllers\Home->index()
7 SYSTEMPATH/CodeIgniter.php:509
CodeIgniter\CodeIgniter->runController()
8 SYSTEMPATH/CodeIgniter.php:355
CodeIgniter\CodeIgniter->handleRequest()
9 SYSTEMPATH/Boot.php:325
CodeIgniter\CodeIgniter->run()
10 SYSTEMPATH/Boot.php:67
CodeIgniter\Boot::runCodeIgniter()
11 FCPATH/index.php:56
CodeIgniter\Boot::bootWeb()
|
0.15 ms |
SELECT `value`
FROM `Avg_values`
LEFT JOIN `Years` `y` ON `y`.`id` = `Avg_values`.`years_id`
LEFT JOIN `Cities` `ci` ON `ci`.`id` = `Avg_values`.`cities_id`
LEFT JOIN `Categories` `ca` ON `ca`.`id` = `Avg_values`.`categories_id`
WHERE `ci`.`id` = '27'
AND `ca`.`id` = '7'
AND `y`.`year` = 2024
AND (
`y`.`deleted_at` IS NULL
)
LIMIT 1 |
APPPATH/Libraries/YearsHelper.php:173 |
|
1 SYSTEMPATH/Database/BaseBuilder.php:1636
CodeIgniter\Database\BaseConnection->query()
2 SYSTEMPATH/Model.php:330
CodeIgniter\Database\BaseBuilder->get()
3 SYSTEMPATH/BaseModel.php:714
CodeIgniter\Model->doFirst()
4 APPPATH/Libraries/YearsHelper.php:173
CodeIgniter\BaseModel->first()
5 APPPATH/Controllers/Home.php:68
App\Libraries\YearsHelper->category_values_by_city()
6 SYSTEMPATH/CodeIgniter.php:933
App\Controllers\Home->index()
7 SYSTEMPATH/CodeIgniter.php:509
CodeIgniter\CodeIgniter->runController()
8 SYSTEMPATH/CodeIgniter.php:355
CodeIgniter\CodeIgniter->handleRequest()
9 SYSTEMPATH/Boot.php:325
CodeIgniter\CodeIgniter->run()
10 SYSTEMPATH/Boot.php:67
CodeIgniter\Boot::runCodeIgniter()
11 FCPATH/index.php:56
CodeIgniter\Boot::bootWeb()
|
0.12 ms |
SELECT `ci`.`id`, `ci`.`name`, `stoplight`, `value`
FROM `General_values`
LEFT JOIN `Years` `y` ON `y`.`id` = `General_values`.`years_id`
LEFT JOIN `Cities` `ci` ON `ci`.`id` = `General_values`.`cities_id`
WHERE `ci`.`id` = '27'
AND `y`.`year` <= 2024
AND (
`y`.`deleted_at` IS NULL
)
LIMIT 1 |
APPPATH/Libraries/YearsHelper.php:210 |
|
1 SYSTEMPATH/Database/BaseBuilder.php:1636
CodeIgniter\Database\BaseConnection->query()
2 SYSTEMPATH/Model.php:330
CodeIgniter\Database\BaseBuilder->get()
3 SYSTEMPATH/BaseModel.php:714
CodeIgniter\Model->doFirst()
4 APPPATH/Libraries/YearsHelper.php:210
CodeIgniter\BaseModel->first()
5 APPPATH/Libraries/YearsHelper.php:238
App\Libraries\YearsHelper->general_values_by_city()
6 APPPATH/Controllers/Home.php:71
App\Libraries\YearsHelper->general_city_score_by_year()
7 SYSTEMPATH/CodeIgniter.php:933
App\Controllers\Home->index()
8 SYSTEMPATH/CodeIgniter.php:509
CodeIgniter\CodeIgniter->runController()
9 SYSTEMPATH/CodeIgniter.php:355
CodeIgniter\CodeIgniter->handleRequest()
10 SYSTEMPATH/Boot.php:325
CodeIgniter\CodeIgniter->run()
11 SYSTEMPATH/Boot.php:67
CodeIgniter\Boot::runCodeIgniter()
12 FCPATH/index.php:56
CodeIgniter\Boot::bootWeb()
|
0.12 ms |
SELECT `ci`.`id`, `ci`.`name`, `stoplight`, `value`
FROM `General_values`
LEFT JOIN `Years` `y` ON `y`.`id` = `General_values`.`years_id`
LEFT JOIN `Cities` `ci` ON `ci`.`id` = `General_values`.`cities_id`
WHERE `ci`.`id` = '29'
AND `y`.`year` <= 2024
AND (
`y`.`deleted_at` IS NULL
)
LIMIT 1 |
APPPATH/Libraries/YearsHelper.php:210 |
|
1 SYSTEMPATH/Database/BaseBuilder.php:1636
CodeIgniter\Database\BaseConnection->query()
2 SYSTEMPATH/Model.php:330
CodeIgniter\Database\BaseBuilder->get()
3 SYSTEMPATH/BaseModel.php:714
CodeIgniter\Model->doFirst()
4 APPPATH/Libraries/YearsHelper.php:210
CodeIgniter\BaseModel->first()
5 APPPATH/Controllers/Home.php:67
App\Libraries\YearsHelper->general_values_by_city()
6 SYSTEMPATH/CodeIgniter.php:933
App\Controllers\Home->index()
7 SYSTEMPATH/CodeIgniter.php:509
CodeIgniter\CodeIgniter->runController()
8 SYSTEMPATH/CodeIgniter.php:355
CodeIgniter\CodeIgniter->handleRequest()
9 SYSTEMPATH/Boot.php:325
CodeIgniter\CodeIgniter->run()
10 SYSTEMPATH/Boot.php:67
CodeIgniter\Boot::runCodeIgniter()
11 FCPATH/index.php:56
CodeIgniter\Boot::bootWeb()
|
0.16 ms |
SELECT `value`
FROM `Avg_values`
LEFT JOIN `Years` `y` ON `y`.`id` = `Avg_values`.`years_id`
LEFT JOIN `Cities` `ci` ON `ci`.`id` = `Avg_values`.`cities_id`
LEFT JOIN `Categories` `ca` ON `ca`.`id` = `Avg_values`.`categories_id`
WHERE `ci`.`id` = '29'
AND `ca`.`id` = '1'
AND `y`.`year` = 2024
AND (
`y`.`deleted_at` IS NULL
)
LIMIT 1 |
APPPATH/Libraries/YearsHelper.php:173 |
|
1 SYSTEMPATH/Database/BaseBuilder.php:1636
CodeIgniter\Database\BaseConnection->query()
2 SYSTEMPATH/Model.php:330
CodeIgniter\Database\BaseBuilder->get()
3 SYSTEMPATH/BaseModel.php:714
CodeIgniter\Model->doFirst()
4 APPPATH/Libraries/YearsHelper.php:173
CodeIgniter\BaseModel->first()
5 APPPATH/Controllers/Home.php:68
App\Libraries\YearsHelper->category_values_by_city()
6 SYSTEMPATH/CodeIgniter.php:933
App\Controllers\Home->index()
7 SYSTEMPATH/CodeIgniter.php:509
CodeIgniter\CodeIgniter->runController()
8 SYSTEMPATH/CodeIgniter.php:355
CodeIgniter\CodeIgniter->handleRequest()
9 SYSTEMPATH/Boot.php:325
CodeIgniter\CodeIgniter->run()
10 SYSTEMPATH/Boot.php:67
CodeIgniter\Boot::runCodeIgniter()
11 FCPATH/index.php:56
CodeIgniter\Boot::bootWeb()
|
0.16 ms |
SELECT `value`
FROM `Avg_values`
LEFT JOIN `Years` `y` ON `y`.`id` = `Avg_values`.`years_id`
LEFT JOIN `Cities` `ci` ON `ci`.`id` = `Avg_values`.`cities_id`
LEFT JOIN `Categories` `ca` ON `ca`.`id` = `Avg_values`.`categories_id`
WHERE `ci`.`id` = '29'
AND `ca`.`id` = '2'
AND `y`.`year` = 2024
AND (
`y`.`deleted_at` IS NULL
)
LIMIT 1 |
APPPATH/Libraries/YearsHelper.php:173 |
|
1 SYSTEMPATH/Database/BaseBuilder.php:1636
CodeIgniter\Database\BaseConnection->query()
2 SYSTEMPATH/Model.php:330
CodeIgniter\Database\BaseBuilder->get()
3 SYSTEMPATH/BaseModel.php:714
CodeIgniter\Model->doFirst()
4 APPPATH/Libraries/YearsHelper.php:173
CodeIgniter\BaseModel->first()
5 APPPATH/Controllers/Home.php:68
App\Libraries\YearsHelper->category_values_by_city()
6 SYSTEMPATH/CodeIgniter.php:933
App\Controllers\Home->index()
7 SYSTEMPATH/CodeIgniter.php:509
CodeIgniter\CodeIgniter->runController()
8 SYSTEMPATH/CodeIgniter.php:355
CodeIgniter\CodeIgniter->handleRequest()
9 SYSTEMPATH/Boot.php:325
CodeIgniter\CodeIgniter->run()
10 SYSTEMPATH/Boot.php:67
CodeIgniter\Boot::runCodeIgniter()
11 FCPATH/index.php:56
CodeIgniter\Boot::bootWeb()
|
0.15 ms |
SELECT `value`
FROM `Avg_values`
LEFT JOIN `Years` `y` ON `y`.`id` = `Avg_values`.`years_id`
LEFT JOIN `Cities` `ci` ON `ci`.`id` = `Avg_values`.`cities_id`
LEFT JOIN `Categories` `ca` ON `ca`.`id` = `Avg_values`.`categories_id`
WHERE `ci`.`id` = '29'
AND `ca`.`id` = '3'
AND `y`.`year` = 2024
AND (
`y`.`deleted_at` IS NULL
)
LIMIT 1 |
APPPATH/Libraries/YearsHelper.php:173 |
|
1 SYSTEMPATH/Database/BaseBuilder.php:1636
CodeIgniter\Database\BaseConnection->query()
2 SYSTEMPATH/Model.php:330
CodeIgniter\Database\BaseBuilder->get()
3 SYSTEMPATH/BaseModel.php:714
CodeIgniter\Model->doFirst()
4 APPPATH/Libraries/YearsHelper.php:173
CodeIgniter\BaseModel->first()
5 APPPATH/Controllers/Home.php:68
App\Libraries\YearsHelper->category_values_by_city()
6 SYSTEMPATH/CodeIgniter.php:933
App\Controllers\Home->index()
7 SYSTEMPATH/CodeIgniter.php:509
CodeIgniter\CodeIgniter->runController()
8 SYSTEMPATH/CodeIgniter.php:355
CodeIgniter\CodeIgniter->handleRequest()
9 SYSTEMPATH/Boot.php:325
CodeIgniter\CodeIgniter->run()
10 SYSTEMPATH/Boot.php:67
CodeIgniter\Boot::runCodeIgniter()
11 FCPATH/index.php:56
CodeIgniter\Boot::bootWeb()
|
0.15 ms |
SELECT `value`
FROM `Avg_values`
LEFT JOIN `Years` `y` ON `y`.`id` = `Avg_values`.`years_id`
LEFT JOIN `Cities` `ci` ON `ci`.`id` = `Avg_values`.`cities_id`
LEFT JOIN `Categories` `ca` ON `ca`.`id` = `Avg_values`.`categories_id`
WHERE `ci`.`id` = '29'
AND `ca`.`id` = '4'
AND `y`.`year` = 2024
AND (
`y`.`deleted_at` IS NULL
)
LIMIT 1 |
APPPATH/Libraries/YearsHelper.php:173 |
|
1 SYSTEMPATH/Database/BaseBuilder.php:1636
CodeIgniter\Database\BaseConnection->query()
2 SYSTEMPATH/Model.php:330
CodeIgniter\Database\BaseBuilder->get()
3 SYSTEMPATH/BaseModel.php:714
CodeIgniter\Model->doFirst()
4 APPPATH/Libraries/YearsHelper.php:173
CodeIgniter\BaseModel->first()
5 APPPATH/Controllers/Home.php:68
App\Libraries\YearsHelper->category_values_by_city()
6 SYSTEMPATH/CodeIgniter.php:933
App\Controllers\Home->index()
7 SYSTEMPATH/CodeIgniter.php:509
CodeIgniter\CodeIgniter->runController()
8 SYSTEMPATH/CodeIgniter.php:355
CodeIgniter\CodeIgniter->handleRequest()
9 SYSTEMPATH/Boot.php:325
CodeIgniter\CodeIgniter->run()
10 SYSTEMPATH/Boot.php:67
CodeIgniter\Boot::runCodeIgniter()
11 FCPATH/index.php:56
CodeIgniter\Boot::bootWeb()
|
0.15 ms |
SELECT `value`
FROM `Avg_values`
LEFT JOIN `Years` `y` ON `y`.`id` = `Avg_values`.`years_id`
LEFT JOIN `Cities` `ci` ON `ci`.`id` = `Avg_values`.`cities_id`
LEFT JOIN `Categories` `ca` ON `ca`.`id` = `Avg_values`.`categories_id`
WHERE `ci`.`id` = '29'
AND `ca`.`id` = '5'
AND `y`.`year` = 2024
AND (
`y`.`deleted_at` IS NULL
)
LIMIT 1 |
APPPATH/Libraries/YearsHelper.php:173 |
|
1 SYSTEMPATH/Database/BaseBuilder.php:1636
CodeIgniter\Database\BaseConnection->query()
2 SYSTEMPATH/Model.php:330
CodeIgniter\Database\BaseBuilder->get()
3 SYSTEMPATH/BaseModel.php:714
CodeIgniter\Model->doFirst()
4 APPPATH/Libraries/YearsHelper.php:173
CodeIgniter\BaseModel->first()
5 APPPATH/Controllers/Home.php:68
App\Libraries\YearsHelper->category_values_by_city()
6 SYSTEMPATH/CodeIgniter.php:933
App\Controllers\Home->index()
7 SYSTEMPATH/CodeIgniter.php:509
CodeIgniter\CodeIgniter->runController()
8 SYSTEMPATH/CodeIgniter.php:355
CodeIgniter\CodeIgniter->handleRequest()
9 SYSTEMPATH/Boot.php:325
CodeIgniter\CodeIgniter->run()
10 SYSTEMPATH/Boot.php:67
CodeIgniter\Boot::runCodeIgniter()
11 FCPATH/index.php:56
CodeIgniter\Boot::bootWeb()
|
0.15 ms |
SELECT `value`
FROM `Avg_values`
LEFT JOIN `Years` `y` ON `y`.`id` = `Avg_values`.`years_id`
LEFT JOIN `Cities` `ci` ON `ci`.`id` = `Avg_values`.`cities_id`
LEFT JOIN `Categories` `ca` ON `ca`.`id` = `Avg_values`.`categories_id`
WHERE `ci`.`id` = '29'
AND `ca`.`id` = '6'
AND `y`.`year` = 2024
AND (
`y`.`deleted_at` IS NULL
)
LIMIT 1 |
APPPATH/Libraries/YearsHelper.php:173 |
|
1 SYSTEMPATH/Database/BaseBuilder.php:1636
CodeIgniter\Database\BaseConnection->query()
2 SYSTEMPATH/Model.php:330
CodeIgniter\Database\BaseBuilder->get()
3 SYSTEMPATH/BaseModel.php:714
CodeIgniter\Model->doFirst()
4 APPPATH/Libraries/YearsHelper.php:173
CodeIgniter\BaseModel->first()
5 APPPATH/Controllers/Home.php:68
App\Libraries\YearsHelper->category_values_by_city()
6 SYSTEMPATH/CodeIgniter.php:933
App\Controllers\Home->index()
7 SYSTEMPATH/CodeIgniter.php:509
CodeIgniter\CodeIgniter->runController()
8 SYSTEMPATH/CodeIgniter.php:355
CodeIgniter\CodeIgniter->handleRequest()
9 SYSTEMPATH/Boot.php:325
CodeIgniter\CodeIgniter->run()
10 SYSTEMPATH/Boot.php:67
CodeIgniter\Boot::runCodeIgniter()
11 FCPATH/index.php:56
CodeIgniter\Boot::bootWeb()
|
0.18 ms |
SELECT `value`
FROM `Avg_values`
LEFT JOIN `Years` `y` ON `y`.`id` = `Avg_values`.`years_id`
LEFT JOIN `Cities` `ci` ON `ci`.`id` = `Avg_values`.`cities_id`
LEFT JOIN `Categories` `ca` ON `ca`.`id` = `Avg_values`.`categories_id`
WHERE `ci`.`id` = '29'
AND `ca`.`id` = '7'
AND `y`.`year` = 2024
AND (
`y`.`deleted_at` IS NULL
)
LIMIT 1 |
APPPATH/Libraries/YearsHelper.php:173 |
|
1 SYSTEMPATH/Database/BaseBuilder.php:1636
CodeIgniter\Database\BaseConnection->query()
2 SYSTEMPATH/Model.php:330
CodeIgniter\Database\BaseBuilder->get()
3 SYSTEMPATH/BaseModel.php:714
CodeIgniter\Model->doFirst()
4 APPPATH/Libraries/YearsHelper.php:173
CodeIgniter\BaseModel->first()
5 APPPATH/Controllers/Home.php:68
App\Libraries\YearsHelper->category_values_by_city()
6 SYSTEMPATH/CodeIgniter.php:933
App\Controllers\Home->index()
7 SYSTEMPATH/CodeIgniter.php:509
CodeIgniter\CodeIgniter->runController()
8 SYSTEMPATH/CodeIgniter.php:355
CodeIgniter\CodeIgniter->handleRequest()
9 SYSTEMPATH/Boot.php:325
CodeIgniter\CodeIgniter->run()
10 SYSTEMPATH/Boot.php:67
CodeIgniter\Boot::runCodeIgniter()
11 FCPATH/index.php:56
CodeIgniter\Boot::bootWeb()
|
0.12 ms |
SELECT `ci`.`id`, `ci`.`name`, `stoplight`, `value`
FROM `General_values`
LEFT JOIN `Years` `y` ON `y`.`id` = `General_values`.`years_id`
LEFT JOIN `Cities` `ci` ON `ci`.`id` = `General_values`.`cities_id`
WHERE `ci`.`id` = '29'
AND `y`.`year` <= 2024
AND (
`y`.`deleted_at` IS NULL
)
LIMIT 1 |
APPPATH/Libraries/YearsHelper.php:210 |
|
1 SYSTEMPATH/Database/BaseBuilder.php:1636
CodeIgniter\Database\BaseConnection->query()
2 SYSTEMPATH/Model.php:330
CodeIgniter\Database\BaseBuilder->get()
3 SYSTEMPATH/BaseModel.php:714
CodeIgniter\Model->doFirst()
4 APPPATH/Libraries/YearsHelper.php:210
CodeIgniter\BaseModel->first()
5 APPPATH/Libraries/YearsHelper.php:238
App\Libraries\YearsHelper->general_values_by_city()
6 APPPATH/Controllers/Home.php:71
App\Libraries\YearsHelper->general_city_score_by_year()
7 SYSTEMPATH/CodeIgniter.php:933
App\Controllers\Home->index()
8 SYSTEMPATH/CodeIgniter.php:509
CodeIgniter\CodeIgniter->runController()
9 SYSTEMPATH/CodeIgniter.php:355
CodeIgniter\CodeIgniter->handleRequest()
10 SYSTEMPATH/Boot.php:325
CodeIgniter\CodeIgniter->run()
11 SYSTEMPATH/Boot.php:67
CodeIgniter\Boot::runCodeIgniter()
12 FCPATH/index.php:56
CodeIgniter\Boot::bootWeb()
|
0.11 ms |
SELECT `ci`.`id`, `ci`.`name`, `stoplight`, `value`
FROM `General_values`
LEFT JOIN `Years` `y` ON `y`.`id` = `General_values`.`years_id`
LEFT JOIN `Cities` `ci` ON `ci`.`id` = `General_values`.`cities_id`
WHERE `ci`.`id` = '30'
AND `y`.`year` <= 2024
AND (
`y`.`deleted_at` IS NULL
)
LIMIT 1 |
APPPATH/Libraries/YearsHelper.php:210 |
|
1 SYSTEMPATH/Database/BaseBuilder.php:1636
CodeIgniter\Database\BaseConnection->query()
2 SYSTEMPATH/Model.php:330
CodeIgniter\Database\BaseBuilder->get()
3 SYSTEMPATH/BaseModel.php:714
CodeIgniter\Model->doFirst()
4 APPPATH/Libraries/YearsHelper.php:210
CodeIgniter\BaseModel->first()
5 APPPATH/Controllers/Home.php:67
App\Libraries\YearsHelper->general_values_by_city()
6 SYSTEMPATH/CodeIgniter.php:933
App\Controllers\Home->index()
7 SYSTEMPATH/CodeIgniter.php:509
CodeIgniter\CodeIgniter->runController()
8 SYSTEMPATH/CodeIgniter.php:355
CodeIgniter\CodeIgniter->handleRequest()
9 SYSTEMPATH/Boot.php:325
CodeIgniter\CodeIgniter->run()
10 SYSTEMPATH/Boot.php:67
CodeIgniter\Boot::runCodeIgniter()
11 FCPATH/index.php:56
CodeIgniter\Boot::bootWeb()
|
0.15 ms |
SELECT `value`
FROM `Avg_values`
LEFT JOIN `Years` `y` ON `y`.`id` = `Avg_values`.`years_id`
LEFT JOIN `Cities` `ci` ON `ci`.`id` = `Avg_values`.`cities_id`
LEFT JOIN `Categories` `ca` ON `ca`.`id` = `Avg_values`.`categories_id`
WHERE `ci`.`id` = '30'
AND `ca`.`id` = '1'
AND `y`.`year` = 2024
AND (
`y`.`deleted_at` IS NULL
)
LIMIT 1 |
APPPATH/Libraries/YearsHelper.php:173 |
|
1 SYSTEMPATH/Database/BaseBuilder.php:1636
CodeIgniter\Database\BaseConnection->query()
2 SYSTEMPATH/Model.php:330
CodeIgniter\Database\BaseBuilder->get()
3 SYSTEMPATH/BaseModel.php:714
CodeIgniter\Model->doFirst()
4 APPPATH/Libraries/YearsHelper.php:173
CodeIgniter\BaseModel->first()
5 APPPATH/Controllers/Home.php:68
App\Libraries\YearsHelper->category_values_by_city()
6 SYSTEMPATH/CodeIgniter.php:933
App\Controllers\Home->index()
7 SYSTEMPATH/CodeIgniter.php:509
CodeIgniter\CodeIgniter->runController()
8 SYSTEMPATH/CodeIgniter.php:355
CodeIgniter\CodeIgniter->handleRequest()
9 SYSTEMPATH/Boot.php:325
CodeIgniter\CodeIgniter->run()
10 SYSTEMPATH/Boot.php:67
CodeIgniter\Boot::runCodeIgniter()
11 FCPATH/index.php:56
CodeIgniter\Boot::bootWeb()
|
0.16 ms |
SELECT `value`
FROM `Avg_values`
LEFT JOIN `Years` `y` ON `y`.`id` = `Avg_values`.`years_id`
LEFT JOIN `Cities` `ci` ON `ci`.`id` = `Avg_values`.`cities_id`
LEFT JOIN `Categories` `ca` ON `ca`.`id` = `Avg_values`.`categories_id`
WHERE `ci`.`id` = '30'
AND `ca`.`id` = '2'
AND `y`.`year` = 2024
AND (
`y`.`deleted_at` IS NULL
)
LIMIT 1 |
APPPATH/Libraries/YearsHelper.php:173 |
|
1 SYSTEMPATH/Database/BaseBuilder.php:1636
CodeIgniter\Database\BaseConnection->query()
2 SYSTEMPATH/Model.php:330
CodeIgniter\Database\BaseBuilder->get()
3 SYSTEMPATH/BaseModel.php:714
CodeIgniter\Model->doFirst()
4 APPPATH/Libraries/YearsHelper.php:173
CodeIgniter\BaseModel->first()
5 APPPATH/Controllers/Home.php:68
App\Libraries\YearsHelper->category_values_by_city()
6 SYSTEMPATH/CodeIgniter.php:933
App\Controllers\Home->index()
7 SYSTEMPATH/CodeIgniter.php:509
CodeIgniter\CodeIgniter->runController()
8 SYSTEMPATH/CodeIgniter.php:355
CodeIgniter\CodeIgniter->handleRequest()
9 SYSTEMPATH/Boot.php:325
CodeIgniter\CodeIgniter->run()
10 SYSTEMPATH/Boot.php:67
CodeIgniter\Boot::runCodeIgniter()
11 FCPATH/index.php:56
CodeIgniter\Boot::bootWeb()
|
0.16 ms |
SELECT `value`
FROM `Avg_values`
LEFT JOIN `Years` `y` ON `y`.`id` = `Avg_values`.`years_id`
LEFT JOIN `Cities` `ci` ON `ci`.`id` = `Avg_values`.`cities_id`
LEFT JOIN `Categories` `ca` ON `ca`.`id` = `Avg_values`.`categories_id`
WHERE `ci`.`id` = '30'
AND `ca`.`id` = '3'
AND `y`.`year` = 2024
AND (
`y`.`deleted_at` IS NULL
)
LIMIT 1 |
APPPATH/Libraries/YearsHelper.php:173 |
|
1 SYSTEMPATH/Database/BaseBuilder.php:1636
CodeIgniter\Database\BaseConnection->query()
2 SYSTEMPATH/Model.php:330
CodeIgniter\Database\BaseBuilder->get()
3 SYSTEMPATH/BaseModel.php:714
CodeIgniter\Model->doFirst()
4 APPPATH/Libraries/YearsHelper.php:173
CodeIgniter\BaseModel->first()
5 APPPATH/Controllers/Home.php:68
App\Libraries\YearsHelper->category_values_by_city()
6 SYSTEMPATH/CodeIgniter.php:933
App\Controllers\Home->index()
7 SYSTEMPATH/CodeIgniter.php:509
CodeIgniter\CodeIgniter->runController()
8 SYSTEMPATH/CodeIgniter.php:355
CodeIgniter\CodeIgniter->handleRequest()
9 SYSTEMPATH/Boot.php:325
CodeIgniter\CodeIgniter->run()
10 SYSTEMPATH/Boot.php:67
CodeIgniter\Boot::runCodeIgniter()
11 FCPATH/index.php:56
CodeIgniter\Boot::bootWeb()
|
0.15 ms |
SELECT `value`
FROM `Avg_values`
LEFT JOIN `Years` `y` ON `y`.`id` = `Avg_values`.`years_id`
LEFT JOIN `Cities` `ci` ON `ci`.`id` = `Avg_values`.`cities_id`
LEFT JOIN `Categories` `ca` ON `ca`.`id` = `Avg_values`.`categories_id`
WHERE `ci`.`id` = '30'
AND `ca`.`id` = '4'
AND `y`.`year` = 2024
AND (
`y`.`deleted_at` IS NULL
)
LIMIT 1 |
APPPATH/Libraries/YearsHelper.php:173 |
|
1 SYSTEMPATH/Database/BaseBuilder.php:1636
CodeIgniter\Database\BaseConnection->query()
2 SYSTEMPATH/Model.php:330
CodeIgniter\Database\BaseBuilder->get()
3 SYSTEMPATH/BaseModel.php:714
CodeIgniter\Model->doFirst()
4 APPPATH/Libraries/YearsHelper.php:173
CodeIgniter\BaseModel->first()
5 APPPATH/Controllers/Home.php:68
App\Libraries\YearsHelper->category_values_by_city()
6 SYSTEMPATH/CodeIgniter.php:933
App\Controllers\Home->index()
7 SYSTEMPATH/CodeIgniter.php:509
CodeIgniter\CodeIgniter->runController()
8 SYSTEMPATH/CodeIgniter.php:355
CodeIgniter\CodeIgniter->handleRequest()
9 SYSTEMPATH/Boot.php:325
CodeIgniter\CodeIgniter->run()
10 SYSTEMPATH/Boot.php:67
CodeIgniter\Boot::runCodeIgniter()
11 FCPATH/index.php:56
CodeIgniter\Boot::bootWeb()
|
0.15 ms |
SELECT `value`
FROM `Avg_values`
LEFT JOIN `Years` `y` ON `y`.`id` = `Avg_values`.`years_id`
LEFT JOIN `Cities` `ci` ON `ci`.`id` = `Avg_values`.`cities_id`
LEFT JOIN `Categories` `ca` ON `ca`.`id` = `Avg_values`.`categories_id`
WHERE `ci`.`id` = '30'
AND `ca`.`id` = '5'
AND `y`.`year` = 2024
AND (
`y`.`deleted_at` IS NULL
)
LIMIT 1 |
APPPATH/Libraries/YearsHelper.php:173 |
|
1 SYSTEMPATH/Database/BaseBuilder.php:1636
CodeIgniter\Database\BaseConnection->query()
2 SYSTEMPATH/Model.php:330
CodeIgniter\Database\BaseBuilder->get()
3 SYSTEMPATH/BaseModel.php:714
CodeIgniter\Model->doFirst()
4 APPPATH/Libraries/YearsHelper.php:173
CodeIgniter\BaseModel->first()
5 APPPATH/Controllers/Home.php:68
App\Libraries\YearsHelper->category_values_by_city()
6 SYSTEMPATH/CodeIgniter.php:933
App\Controllers\Home->index()
7 SYSTEMPATH/CodeIgniter.php:509
CodeIgniter\CodeIgniter->runController()
8 SYSTEMPATH/CodeIgniter.php:355
CodeIgniter\CodeIgniter->handleRequest()
9 SYSTEMPATH/Boot.php:325
CodeIgniter\CodeIgniter->run()
10 SYSTEMPATH/Boot.php:67
CodeIgniter\Boot::runCodeIgniter()
11 FCPATH/index.php:56
CodeIgniter\Boot::bootWeb()
|
0.16 ms |
SELECT `value`
FROM `Avg_values`
LEFT JOIN `Years` `y` ON `y`.`id` = `Avg_values`.`years_id`
LEFT JOIN `Cities` `ci` ON `ci`.`id` = `Avg_values`.`cities_id`
LEFT JOIN `Categories` `ca` ON `ca`.`id` = `Avg_values`.`categories_id`
WHERE `ci`.`id` = '30'
AND `ca`.`id` = '6'
AND `y`.`year` = 2024
AND (
`y`.`deleted_at` IS NULL
)
LIMIT 1 |
APPPATH/Libraries/YearsHelper.php:173 |
|
1 SYSTEMPATH/Database/BaseBuilder.php:1636
CodeIgniter\Database\BaseConnection->query()
2 SYSTEMPATH/Model.php:330
CodeIgniter\Database\BaseBuilder->get()
3 SYSTEMPATH/BaseModel.php:714
CodeIgniter\Model->doFirst()
4 APPPATH/Libraries/YearsHelper.php:173
CodeIgniter\BaseModel->first()
5 APPPATH/Controllers/Home.php:68
App\Libraries\YearsHelper->category_values_by_city()
6 SYSTEMPATH/CodeIgniter.php:933
App\Controllers\Home->index()
7 SYSTEMPATH/CodeIgniter.php:509
CodeIgniter\CodeIgniter->runController()
8 SYSTEMPATH/CodeIgniter.php:355
CodeIgniter\CodeIgniter->handleRequest()
9 SYSTEMPATH/Boot.php:325
CodeIgniter\CodeIgniter->run()
10 SYSTEMPATH/Boot.php:67
CodeIgniter\Boot::runCodeIgniter()
11 FCPATH/index.php:56
CodeIgniter\Boot::bootWeb()
|
0.15 ms |
SELECT `value`
FROM `Avg_values`
LEFT JOIN `Years` `y` ON `y`.`id` = `Avg_values`.`years_id`
LEFT JOIN `Cities` `ci` ON `ci`.`id` = `Avg_values`.`cities_id`
LEFT JOIN `Categories` `ca` ON `ca`.`id` = `Avg_values`.`categories_id`
WHERE `ci`.`id` = '30'
AND `ca`.`id` = '7'
AND `y`.`year` = 2024
AND (
`y`.`deleted_at` IS NULL
)
LIMIT 1 |
APPPATH/Libraries/YearsHelper.php:173 |
|
1 SYSTEMPATH/Database/BaseBuilder.php:1636
CodeIgniter\Database\BaseConnection->query()
2 SYSTEMPATH/Model.php:330
CodeIgniter\Database\BaseBuilder->get()
3 SYSTEMPATH/BaseModel.php:714
CodeIgniter\Model->doFirst()
4 APPPATH/Libraries/YearsHelper.php:173
CodeIgniter\BaseModel->first()
5 APPPATH/Controllers/Home.php:68
App\Libraries\YearsHelper->category_values_by_city()
6 SYSTEMPATH/CodeIgniter.php:933
App\Controllers\Home->index()
7 SYSTEMPATH/CodeIgniter.php:509
CodeIgniter\CodeIgniter->runController()
8 SYSTEMPATH/CodeIgniter.php:355
CodeIgniter\CodeIgniter->handleRequest()
9 SYSTEMPATH/Boot.php:325
CodeIgniter\CodeIgniter->run()
10 SYSTEMPATH/Boot.php:67
CodeIgniter\Boot::runCodeIgniter()
11 FCPATH/index.php:56
CodeIgniter\Boot::bootWeb()
|
0.12 ms |
SELECT `ci`.`id`, `ci`.`name`, `stoplight`, `value`
FROM `General_values`
LEFT JOIN `Years` `y` ON `y`.`id` = `General_values`.`years_id`
LEFT JOIN `Cities` `ci` ON `ci`.`id` = `General_values`.`cities_id`
WHERE `ci`.`id` = '30'
AND `y`.`year` <= 2024
AND (
`y`.`deleted_at` IS NULL
)
LIMIT 1 |
APPPATH/Libraries/YearsHelper.php:210 |
|
1 SYSTEMPATH/Database/BaseBuilder.php:1636
CodeIgniter\Database\BaseConnection->query()
2 SYSTEMPATH/Model.php:330
CodeIgniter\Database\BaseBuilder->get()
3 SYSTEMPATH/BaseModel.php:714
CodeIgniter\Model->doFirst()
4 APPPATH/Libraries/YearsHelper.php:210
CodeIgniter\BaseModel->first()
5 APPPATH/Libraries/YearsHelper.php:238
App\Libraries\YearsHelper->general_values_by_city()
6 APPPATH/Controllers/Home.php:71
App\Libraries\YearsHelper->general_city_score_by_year()
7 SYSTEMPATH/CodeIgniter.php:933
App\Controllers\Home->index()
8 SYSTEMPATH/CodeIgniter.php:509
CodeIgniter\CodeIgniter->runController()
9 SYSTEMPATH/CodeIgniter.php:355
CodeIgniter\CodeIgniter->handleRequest()
10 SYSTEMPATH/Boot.php:325
CodeIgniter\CodeIgniter->run()
11 SYSTEMPATH/Boot.php:67
CodeIgniter\Boot::runCodeIgniter()
12 FCPATH/index.php:56
CodeIgniter\Boot::bootWeb()
|
0.11 ms |
SELECT `ci`.`id`, `ci`.`name`, `stoplight`, `value`
FROM `General_values`
LEFT JOIN `Years` `y` ON `y`.`id` = `General_values`.`years_id`
LEFT JOIN `Cities` `ci` ON `ci`.`id` = `General_values`.`cities_id`
WHERE `ci`.`id` = '32'
AND `y`.`year` <= 2024
AND (
`y`.`deleted_at` IS NULL
)
LIMIT 1 |
APPPATH/Libraries/YearsHelper.php:210 |
|
1 SYSTEMPATH/Database/BaseBuilder.php:1636
CodeIgniter\Database\BaseConnection->query()
2 SYSTEMPATH/Model.php:330
CodeIgniter\Database\BaseBuilder->get()
3 SYSTEMPATH/BaseModel.php:714
CodeIgniter\Model->doFirst()
4 APPPATH/Libraries/YearsHelper.php:210
CodeIgniter\BaseModel->first()
5 APPPATH/Controllers/Home.php:67
App\Libraries\YearsHelper->general_values_by_city()
6 SYSTEMPATH/CodeIgniter.php:933
App\Controllers\Home->index()
7 SYSTEMPATH/CodeIgniter.php:509
CodeIgniter\CodeIgniter->runController()
8 SYSTEMPATH/CodeIgniter.php:355
CodeIgniter\CodeIgniter->handleRequest()
9 SYSTEMPATH/Boot.php:325
CodeIgniter\CodeIgniter->run()
10 SYSTEMPATH/Boot.php:67
CodeIgniter\Boot::runCodeIgniter()
11 FCPATH/index.php:56
CodeIgniter\Boot::bootWeb()
|
0.15 ms |
SELECT `value`
FROM `Avg_values`
LEFT JOIN `Years` `y` ON `y`.`id` = `Avg_values`.`years_id`
LEFT JOIN `Cities` `ci` ON `ci`.`id` = `Avg_values`.`cities_id`
LEFT JOIN `Categories` `ca` ON `ca`.`id` = `Avg_values`.`categories_id`
WHERE `ci`.`id` = '32'
AND `ca`.`id` = '1'
AND `y`.`year` = 2024
AND (
`y`.`deleted_at` IS NULL
)
LIMIT 1 |
APPPATH/Libraries/YearsHelper.php:173 |
|
1 SYSTEMPATH/Database/BaseBuilder.php:1636
CodeIgniter\Database\BaseConnection->query()
2 SYSTEMPATH/Model.php:330
CodeIgniter\Database\BaseBuilder->get()
3 SYSTEMPATH/BaseModel.php:714
CodeIgniter\Model->doFirst()
4 APPPATH/Libraries/YearsHelper.php:173
CodeIgniter\BaseModel->first()
5 APPPATH/Controllers/Home.php:68
App\Libraries\YearsHelper->category_values_by_city()
6 SYSTEMPATH/CodeIgniter.php:933
App\Controllers\Home->index()
7 SYSTEMPATH/CodeIgniter.php:509
CodeIgniter\CodeIgniter->runController()
8 SYSTEMPATH/CodeIgniter.php:355
CodeIgniter\CodeIgniter->handleRequest()
9 SYSTEMPATH/Boot.php:325
CodeIgniter\CodeIgniter->run()
10 SYSTEMPATH/Boot.php:67
CodeIgniter\Boot::runCodeIgniter()
11 FCPATH/index.php:56
CodeIgniter\Boot::bootWeb()
|
0.16 ms |
SELECT `value`
FROM `Avg_values`
LEFT JOIN `Years` `y` ON `y`.`id` = `Avg_values`.`years_id`
LEFT JOIN `Cities` `ci` ON `ci`.`id` = `Avg_values`.`cities_id`
LEFT JOIN `Categories` `ca` ON `ca`.`id` = `Avg_values`.`categories_id`
WHERE `ci`.`id` = '32'
AND `ca`.`id` = '2'
AND `y`.`year` = 2024
AND (
`y`.`deleted_at` IS NULL
)
LIMIT 1 |
APPPATH/Libraries/YearsHelper.php:173 |
|
1 SYSTEMPATH/Database/BaseBuilder.php:1636
CodeIgniter\Database\BaseConnection->query()
2 SYSTEMPATH/Model.php:330
CodeIgniter\Database\BaseBuilder->get()
3 SYSTEMPATH/BaseModel.php:714
CodeIgniter\Model->doFirst()
4 APPPATH/Libraries/YearsHelper.php:173
CodeIgniter\BaseModel->first()
5 APPPATH/Controllers/Home.php:68
App\Libraries\YearsHelper->category_values_by_city()
6 SYSTEMPATH/CodeIgniter.php:933
App\Controllers\Home->index()
7 SYSTEMPATH/CodeIgniter.php:509
CodeIgniter\CodeIgniter->runController()
8 SYSTEMPATH/CodeIgniter.php:355
CodeIgniter\CodeIgniter->handleRequest()
9 SYSTEMPATH/Boot.php:325
CodeIgniter\CodeIgniter->run()
10 SYSTEMPATH/Boot.php:67
CodeIgniter\Boot::runCodeIgniter()
11 FCPATH/index.php:56
CodeIgniter\Boot::bootWeb()
|
0.15 ms |
SELECT `value`
FROM `Avg_values`
LEFT JOIN `Years` `y` ON `y`.`id` = `Avg_values`.`years_id`
LEFT JOIN `Cities` `ci` ON `ci`.`id` = `Avg_values`.`cities_id`
LEFT JOIN `Categories` `ca` ON `ca`.`id` = `Avg_values`.`categories_id`
WHERE `ci`.`id` = '32'
AND `ca`.`id` = '3'
AND `y`.`year` = 2024
AND (
`y`.`deleted_at` IS NULL
)
LIMIT 1 |
APPPATH/Libraries/YearsHelper.php:173 |
|
1 SYSTEMPATH/Database/BaseBuilder.php:1636
CodeIgniter\Database\BaseConnection->query()
2 SYSTEMPATH/Model.php:330
CodeIgniter\Database\BaseBuilder->get()
3 SYSTEMPATH/BaseModel.php:714
CodeIgniter\Model->doFirst()
4 APPPATH/Libraries/YearsHelper.php:173
CodeIgniter\BaseModel->first()
5 APPPATH/Controllers/Home.php:68
App\Libraries\YearsHelper->category_values_by_city()
6 SYSTEMPATH/CodeIgniter.php:933
App\Controllers\Home->index()
7 SYSTEMPATH/CodeIgniter.php:509
CodeIgniter\CodeIgniter->runController()
8 SYSTEMPATH/CodeIgniter.php:355
CodeIgniter\CodeIgniter->handleRequest()
9 SYSTEMPATH/Boot.php:325
CodeIgniter\CodeIgniter->run()
10 SYSTEMPATH/Boot.php:67
CodeIgniter\Boot::runCodeIgniter()
11 FCPATH/index.php:56
CodeIgniter\Boot::bootWeb()
|