# | Time | Since previous | Level | Category | Message |
---|---|---|---|---|---|
1 | 19:19:50.381 | < 0ms > | trace | yii\base\Application::bootstrap | Bootstrap with yii\log\Dispatcher |
2 | 19:19:50.381 | trace | yii\base\Module::getModule | Loading module: debug | |
3 | 19:19:50.384 | trace | yii\base\Application::bootstrap | Bootstrap with yii\debug\Module::bootstrap() | |
4 | 19:19:50.388 | info | yii\db\Connection::open | Opening DB connection: mysql:host=mysql_db;dbname=5am | |
5 | 19:19:50.390 | info | yii\db\Command::query | SELECT * FROM `section` | |
6 | 19:19:50.390 | info | yii\db\Command::query | SELECT MAX(updated_at) FROM section | |
7 | 19:19:50.390 | trace | yii\db\Command::query | Query result served from cache | |
8 | 19:19:50.413 | trace | yii\base\Module::getModule | Loading module: gii | |
9 | 19:19:50.414 | trace | yii\base\Application::bootstrap | Bootstrap with yii\gii\Module::bootstrap() | |
10 | 19:19:50.415 | info | yii\db\Command::query | SELECT * FROM `lang` WHERE `default` = 1 | |
11 | 19:19:50.415 | trace | yii\db\Command::query | Query result served from cache | |
12 | 19:19:50.415 | info | yii\db\Command::query | SHOW FULL COLUMNS FROM `lang` | |
13 | 19:19:50.415 | trace | yii\db\Command::query | Query result served from cache | |
14 | 19:19:50.415 | info | yii\db\Command::query | SHOW CREATE TABLE `lang` | |
15 | 19:19:50.415 | trace | yii\db\Command::query | Query result served from cache | |
16 | 19:19:50.415 | info | yii\db\Command::query | SELECT `kcu`.`CONSTRAINT_NAME` AS `constraint_name`, `kcu`.`COLUMN_NAME` AS `column_name`, `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`, `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name` FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc` JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON ( `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL) ) AND `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME` WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database() AND `rc`.`TABLE_NAME` = 'lang' AND `kcu`.`TABLE_NAME` = 'lang' | |
17 | 19:19:50.415 | trace | yii\db\Command::query | Query result served from cache | |
18 | 19:19:50.416 | info | yii\db\Command::query | SELECT * FROM `lang` WHERE (url = 'en') AND (`active`=1) | |
19 | 19:19:50.423 | trace | yii\db\Command::query | Saved query result in cache | |
20 | 19:19:50.424 | info | yii\db\Command::query | SELECT COUNT(*) FROM `posts` WHERE (`url`='war-crimes') AND (`type`='content') | |
21 | 19:19:50.424 | info | yii\db\Command::query | SELECT MAX(update_cache) FROM posts WHERE `type` = "content" | |
22 | 19:19:50.424 | trace | yii\db\Command::query | Query result served from cache | |
23 | 19:19:50.425 | trace | yii\web\Application::handleRequest | Route requested: 'site/war-crimes' | |
24 | 19:19:50.425 | trace | yii\base\Controller::runAction | Route to run: site/war-crimes | |
25 | 19:19:50.425 | trace | yii\base\InlineAction::runWithParams | Running action: frontend\controllers\SiteController::actionWarCrimes() | |
26 | 19:19:50.427 | info | yii\db\Command::query | SHOW FULL COLUMNS FROM `incidents` | |
27 | 19:19:50.428 | info | yii\db\Command::query | SHOW CREATE TABLE `incidents` | |
28 | 19:19:50.428 | info | yii\db\Command::query | SELECT `kcu`.`CONSTRAINT_NAME` AS `constraint_name`, `kcu`.`COLUMN_NAME` AS `column_name`, `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`, `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name` FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc` JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON ( `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL) ) AND `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME` WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database() AND `rc`.`TABLE_NAME` = 'incidents' AND `kcu`.`TABLE_NAME` = 'incidents' | |
29 | 19:19:50.430 | info | yii\db\Command::query | SELECT DISTINCT `incident_geographic`.`lat`, `incident_geographic`.`lng`, `incident_geographic`.`incident_id` FROM `incident_geographic` LEFT JOIN `incidents` ON `incident_geographic`.`incident_id` = `incidents`.`post_id` LEFT JOIN `thematic_typology_id` ON `incidents`.`post_id` = `thematic_typology_id`.`post_id` LEFT JOIN `thematic_typology` ON `thematic_typology_id`.`thematic_id` = `thematic_typology`.`post_id` WHERE (`incident_geographic`.`lat` IS NOT NULL) AND (`incident_geographic`.`lng` IS NOT NULL) AND ((`incidents`.`lang`='en') AND (`incidents`.`status`=100) AND ((`thematic_typology`.`post_id`='129') AND (`thematic_typology`.`lang` = 'en'))) | |
30 | 19:19:50.451 | info | yii\db\Command::query | SHOW FULL COLUMNS FROM `incident_geographic` | |
31 | 19:19:50.451 | info | yii\db\Command::query | SHOW CREATE TABLE `incident_geographic` | |
32 | 19:19:50.452 | info | yii\db\Command::query | SELECT `kcu`.`CONSTRAINT_NAME` AS `constraint_name`, `kcu`.`COLUMN_NAME` AS `column_name`, `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`, `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name` FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc` JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON ( `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL) ) AND `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME` WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database() AND `rc`.`TABLE_NAME` = 'incident_geographic' AND `kcu`.`TABLE_NAME` = 'incident_geographic' | |
33 | 19:19:50.469 | info | yii\db\Command::query | SELECT `incidents`.* FROM `incidents` LEFT JOIN `thematic_typology_id` ON `incidents`.`post_id` = `thematic_typology_id`.`post_id` LEFT JOIN `thematic_typology` ON `thematic_typology_id`.`thematic_id` = `thematic_typology`.`post_id` WHERE (`incidents`.`lang`='en') AND (`incidents`.`status`=100) AND (`incidents`.`post_id` IN (331, 332, 336, 340, 343, 345, 348, 349, 351, 352, 355, 356, 357, 358, 359, 360, 373, 383, 387, 392, 393, 396, 397, 398, 402, 407, 408, 413, 415, 448, 449, 453, 457, 467, 481, 491, 499, 500, 519, 534, 544, 551, 557, 568, 581, 582, 598, 599, 600, 603, 609, 652, 663, 692, 693, 705, 707, 708, 709, 725, 786, 787, 810, 813, 817, 825, 828, 837, 842, 856, 859, 860, 861, 862, 865, 877, 880, 881, 885, 889, 890, 894, 907, 911, 922, 926, 944, 971, 972, 975, 976, 977, 981, 982, 983, 984, 996, 1009, 1011, 1013, 1014, 1015, 1021, 1024, 1051, 1052, 1083, 1085, 1086, 1103, 1129, 1136, 1189, 1199, 1200, 1202, 1203, 1204, 1209, 1210, 1214, 1220, 1223, 1237, 1240, 1241, 1243, 1249, 1257, 1261, 1262, 1273, 1280, 1282, 1295, 1297, 1298, 1301, 1318, 1354, 1357, 1369, 1383, 1385, 1398, 1429, 1430, 1442, 1444, 1476, 1498, 1511, 1525, 1546, 1548, 1551, 1554, 1563, 1570, 1576, 1582, 1585, 1592, 1595, 1597, 1601, 1622, 1623, 1624, 1637, 1650, 1651, 1656, 1659, 1660, 1663, 1667, 1668, 1678, 1679, 1681, 1682, 1683, 1684, 1699, 1701, 1702, 1703, 1704, 1706, 1707, 1708, 1711, 1750, 1781, 1783, 1793, 1797, 1798, 1810, 1811, 1812, 1826, 1827, 1832, 1853, 1854, 1859, 1878, 1882, 1883, 1902, 1913, 1915, 1919, 1922, 1929, 1932, 1940, 1947, 1949, 1951, 1958, 1966, 1980, 1981, 1985, 1988, 1990, 1991, 1992, 1996, 2000, 2022, 2030, 2032, 2042, 2053, 2057, 2074, 2078, 2092, 2094, 2095, 2101, 2102, 2103, 2113, 2117, 2128, 2129, 2136, 2137, 2138, 2141, 2145, 2147, 2154, 2169, 2170, 2171, 2181, 2182, 2183, 2211, 2215, 2216, 2217, 2219, 2220, 2225, 2240, 2241, 2244, 2245, 2246, 2262, 2263, 2264, 2266, 2267, 2273, 2278, 2279, 2280, 2282, 2294, 2295, 2297, 2299, 2300, 2301, 2313, 2315, 2320, 2321, 2322, 2324, 2325, 2327, 2328, 2330, 2341, 2381, 2382, 2392, 2393, 2394, 2397, 2399, 2403, 2404, 2405, 2407, 2408, 2410, 2416, 2417, 2426, 2433, 2435, 2437, 2438, 2453, 2455, 2458, 2459, 2463, 2473, 2475, 2513, 2537, 2545, 2548, 2553, 2567, 2573, 2574, 2575, 2576, 2578, 2579, 2580, 2581, 2584, 2590, 2614, 2634, 2649, 2655, 2663, 2667, 2681, 2690, 2691, 2699, 2701, 2702, 2703, 2706, 2708, 2712, 2717, 2722, 2727, 2732, 2733, 2742, 2748, 2751, 2754, 2761, 2762, 2764, 2765, 2780, 2781, 2801, 2817, 2819, 2829, 2835, 2879, 2880, 2883, 2892, 2902, 2933, 2935, 2941, 2956, 2968, 2998, 2999, 3000, 3001, 3002, 3003, 3004, 3005, 3007, 3008, 3009, 3010, 3011, 3012, 3015, 3016, 3018, 3021, 3022, 3023, 3026, 3027, 3035, 3037, 3038, 3039, 3041, 3042, 3045, 3049)) AND ((`thematic_typology`.`post_id`='129') AND (`thematic_typology`.`lang` = 'en')) | |
34 | 19:19:50.517 | info | yii\db\Command::query | SELECT * FROM `thematic_typology_id` WHERE `post_id` IN (331, 332, 336, 340, 343, 345, 348, 349, 351, 352, 355, 356, 357, 358, 359, 360, 373, 383, 387, 392, 393, 396, 397, 398, 402, 407, 408, 413, 415, 448, 449, 453, 457, 467, 481, 491, 499, 500, 519, 534, 544, 551, 557, 568, 581, 582, 598, 599, 600, 603, 609, 652, 663, 692, 693, 705, 707, 708, 709, 725, 786, 787, 810, 813, 817, 825, 828, 837, 842, 856, 859, 860, 861, 862, 865, 877, 880, 881, 885, 889, 890, 894, 907, 911, 922, 926, 944, 971, 972, 975, 976, 977, 981, 982, 983, 984, 996, 1009, 1011, 1013, 1014, 1015, 1021, 1024, 1051, 1052, 1083, 1085, 1086, 1103, 1129, 1136, 1189, 1199, 1200, 1202, 1203, 1204, 1209, 1210, 1214, 1220, 1223, 1237, 1240, 1241, 1243, 1249, 1257, 1261, 1262, 1273, 1280, 1282, 1295, 1297, 1298, 1301, 1318, 1354, 1357, 1369, 1383, 1385, 1398, 1429, 1430, 1442, 1444, 1476, 1498, 1511, 1525, 1546, 1548, 1551, 1554, 1563, 1570, 1576, 1582, 1585, 1592, 1595, 1597, 1601, 1622, 1623, 1624, 1637, 1650, 1651, 1656, 1659, 1660, 1663, 1667, 1668, 1678, 1679, 1681, 1682, 1683, 1684, 1699, 1701, 1702, 1703, 1704, 1706, 1707, 1708, 1711, 1750, 1781, 1783, 1793, 1797, 1798, 1810, 1811, 1812, 1826, 1827, 1832, 1853, 1854, 1859, 1878, 1882, 1883, 1902, 1913, 1915, 1919, 1922, 1929, 1932, 1940, 1947, 1949, 1951, 1958, 1966, 1980, 1981, 1985, 1988, 1990, 1991, 1992, 1996, 2000, 2022, 2030, 2032, 2042, 2053, 2057, 2074, 2078, 2092, 2094, 2095, 2101, 2102, 2103, 2113, 2117, 2128, 2129, 2136, 2137, 2138, 2141, 2145, 2147, 2154, 2169, 2170, 2171, 2181, 2182, 2183, 2211, 2215, 2216, 2217, 2219, 2220, 2225, 2240, 2241, 2244, 2245, 2246, 2262, 2263, 2264, 2266, 2267, 2273, 2278, 2279, 2280, 2282, 2294, 2295, 2297, 2299, 2300, 2301, 2313, 2315, 2320, 2321, 2322, 2324, 2325, 2327, 2328, 2330, 2341, 2381, 2382, 2392, 2393, 2394, 2397, 2399, 2403, 2404, 2405, 2407, 2408, 2410, 2416, 2417, 2426, 2433, 2435, 2437, 2438, 2453, 2455, 2458, 2459, 2463, 2473, 2475, 2513, 2537, 2545, 2548, 2553, 2567, 2573, 2574, 2575, 2576, 2578, 2579, 2580, 2581, 2584, 2590, 2614, 2634, 2649, 2655, 2663, 2667, 2681, 2690, 2691, 2699, 2701, 2702, 2703, 2706, 2708, 2712, 2717, 2722, 2727, 2732, 2733, 2742, 2748, 2751, 2754, 2761, 2762, 2764, 2765, 2780, 2781, 2801, 2817, 2819, 2829, 2835, 2879, 2880, 2883, 2892, 2902, 2933, 2935, 2941, 2956, 2968, 2998, 2999, 3000, 3001, 3002, 3003, 3004, 3005, 3007, 3008, 3009, 3010, 3011, 3012, 3015, 3016, 3018, 3021, 3022, 3023, 3026, 3027, 3035, 3037, 3038, 3039, 3041, 3042, 3045, 3049) | |
35 | 19:19:50.521 | info | yii\db\Command::query | SELECT * FROM `thematic_typology` WHERE (`thematic_typology`.`post_id`='129') AND (`thematic_typology`.`lang` = 'en') AND (`post_id` IN (131, 133, 124, 129, 134, 139, 146, 147, 137, 143, 138, 140, 144, 128, 136, 155, 156, 157, 158, 145, 170, 160, 181, 177, 183, 168, 159, 165, 179, 174, 127, 141, 126, 149, 135, 150, 125, 173, 148, 142, 196, 180, 185, 153, 130, 193, 186, 167, 190, 184, 132, 191, 169, 172, 199, 188, 176)) | |
36 | 19:19:50.521 | info | yii\db\Command::query | SHOW FULL COLUMNS FROM `thematic_typology` | |
37 | 19:19:50.522 | info | yii\db\Command::query | SHOW CREATE TABLE `thematic_typology` | |
38 | 19:19:50.522 | info | yii\db\Command::query | SELECT `kcu`.`CONSTRAINT_NAME` AS `constraint_name`, `kcu`.`COLUMN_NAME` AS `column_name`, `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`, `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name` FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc` JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON ( `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL) ) AND `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME` WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database() AND `rc`.`TABLE_NAME` = 'thematic_typology' AND `kcu`.`TABLE_NAME` = 'thematic_typology' | |
39 | 19:19:50.537 | info | yii\db\Command::query | SELECT COUNT(*) FROM `incidents` LEFT JOIN `thematic_typology_id` ON `incidents`.`post_id` = `thematic_typology_id`.`post_id` LEFT JOIN `thematic_typology` ON `thematic_typology_id`.`thematic_id` = `thematic_typology`.`post_id` WHERE (`incidents`.`status`=100) AND (`incidents`.`lang`='en') AND ((`thematic_typology`.`post_id`='129') AND (`thematic_typology`.`lang` = 'en')) | |
40 | 19:19:50.555 | info | yii\db\Command::query | SELECT * FROM `thematic_typology` WHERE `lang`='en' ORDER BY `name` | |
41 | 19:19:50.555 | info | yii\db\Command::query | SELECT MAX(updated_at) FROM `thematic_typology` | |
42 | 19:19:50.555 | info | yii\db\Command::query | SELECT COUNT(*) FROM `thematic_typology` | |
43 | 19:19:50.555 | trace | yii\db\Command::query | Query result served from cache | |
44 | 19:19:50.558 | trace | yii\base\View::renderFile | Rendering view file: /var/www/html/frontend/views/site/war-crimes.php | |
45 | 19:19:50.558 | info | yii\db\Command::query | SELECT * FROM `lang` WHERE `active`=1 ORDER BY `id` | |
46 | 19:19:50.559 | trace | yii\db\Command::query | Saved query result in cache | |
47 | 19:19:50.559 | info | yii\db\Command::query | SELECT * FROM `lang` WHERE `default` = 1 | |
48 | 19:19:50.559 | trace | yii\db\Command::query | Query result served from cache | |
49 | 19:19:50.560 | info | yii\db\Command::query | SELECT * FROM `lang` WHERE `default` = 1 | |
50 | 19:19:50.560 | trace | yii\db\Command::query | Query result served from cache | |
51 | 19:19:50.560 | info | yii\db\Command::query | SELECT * FROM `lang` WHERE `default` = 1 | |
52 | 19:19:50.561 | trace | yii\db\Command::query | Query result served from cache | |
53 | 19:19:50.561 | info | yii\db\Command::query | SELECT * FROM `lang` WHERE `default` = 1 | |
54 | 19:19:50.561 | trace | yii\db\Command::query | Query result served from cache | |
55 | 19:19:50.561 | info | yii\db\Command::query | SELECT * FROM `lang` WHERE `default` = 1 | |
56 | 19:19:50.561 | trace | yii\db\Command::query | Query result served from cache | |
57 | 19:19:50.561 | info | yii\db\Command::query | SELECT * FROM `lang` WHERE `default` = 1 | |
58 | 19:19:50.561 | trace | yii\db\Command::query | Query result served from cache | |
59 | 19:19:50.562 | trace | yii\redis\Connection::open | Opening redis DB connection: tcp://redis:6379, database=0 | |
60 | 19:19:50.562 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: SELECT | |
61 | 19:19:50.562 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET | |
62 | 19:19:50.563 | info | yii\db\Command::query | (SELECT `t1`.`message` AS `message`, `t2`.`translation` AS `translation` FROM `source_message` `t1`, `message` `t2` WHERE (`t1`.`id`=`t2`.`id`) AND (`t1`.`category`='seo') AND (`t2`.`language`='en-EN')) UNION ALL ( SELECT `t1`.`message` AS `message`, `t2`.`translation` AS `translation` FROM `source_message` `t1`, `message` `t2` WHERE ((`t1`.`id`=`t2`.`id`) AND (`t1`.`category`='seo') AND (`t2`.`language`='en')) AND (`t2`.`id` NOT IN (SELECT `id` FROM `message` WHERE `language`='en-EN')) ) | |
63 | 19:19:50.563 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET | |
64 | 19:19:50.563 | info | yii\db\Command::query | (SELECT `t1`.`message` AS `message`, `t2`.`translation` AS `translation` FROM `source_message` `t1`, `message` `t2` WHERE (`t1`.`id`=`t2`.`id`) AND (`t1`.`category`='app') AND (`t2`.`language`='en-EN')) UNION ALL ( SELECT `t1`.`message` AS `message`, `t2`.`translation` AS `translation` FROM `source_message` `t1`, `message` `t2` WHERE ((`t1`.`id`=`t2`.`id`) AND (`t1`.`category`='app') AND (`t2`.`language`='en')) AND (`t2`.`id` NOT IN (SELECT `id` FROM `message` WHERE `language`='en-EN')) ) | |
65 | 19:19:50.565 | trace | yii\base\View::renderFile | Rendering view file: /var/www/html/frontend/views/site/partialFilter/crime_catalogue.php | |
66 | 19:19:50.565 | info | yii\db\Command::query | SELECT * FROM `thematic_typology` WHERE (`post_id`='129') AND (`lang`='en') | |
67 | 19:19:50.565 | trace | yii\base\View::renderFile | Rendering view file: /var/www/html/frontend/views/site/partialFilter/filterForm.php | |
68 | 19:19:50.565 | info | yii\db\Command::query | SELECT * FROM `thematic_typology` WHERE (`post_id`='129') AND (`lang`='en') | |
69 | 19:19:50.566 | info | yii\db\Command::query | SELECT * FROM `lang` WHERE `default` = 1 | |
70 | 19:19:50.566 | trace | yii\db\Command::query | Query result served from cache | |
71 | 19:19:50.566 | trace | yii\base\View::renderFile | Rendering view file: /var/www/html/frontend/views/site/partialFilter/selectedFilter.php | |
72 | 19:19:50.567 | info | yii\db\Command::query | SELECT * FROM `thematic_typology` WHERE (`post_id`='129') AND (`lang`='en') | |
73 | 19:19:50.567 | trace | yii\base\View::renderFile | Rendering view file: /var/www/html/frontend/views/site/partialFilter/resultFilterMap.php | |
74 | 19:19:50.567 | info | yii\db\Command::query | SELECT * FROM `settings` WHERE `name`='google_api_key' | |
75 | 19:19:50.567 | info | yii\db\Command::query | SELECT MAX(updated_at) FROM settings | |
76 | 19:19:50.567 | trace | yii\db\Command::query | Query result served from cache | |
77 | 19:19:50.574 | info | yii\db\Command::query | SELECT `incidents`.* FROM `incidents` LEFT JOIN `thematic_typology_id` ON `incidents`.`post_id` = `thematic_typology_id`.`post_id` LEFT JOIN `thematic_typology` ON `thematic_typology_id`.`thematic_id` = `thematic_typology`.`post_id` WHERE (`incidents`.`status`=100) AND (`incidents`.`lang`='en') AND ((`thematic_typology`.`post_id`='129') AND (`thematic_typology`.`lang` = 'en')) ORDER BY `date_end` DESC LIMIT 6 | |
78 | 19:19:50.607 | info | yii\db\Command::query | SELECT * FROM `thematic_typology_id` WHERE `post_id` IN (3037, 3038, 3039, 3041, 3026, 3020) | |
79 | 19:19:50.608 | info | yii\db\Command::query | SELECT * FROM `thematic_typology` WHERE (`thematic_typology`.`post_id`='129') AND (`thematic_typology`.`lang` = 'en') AND (`post_id` IN (136, 137, 141, 156, 167, 134, 144, 128, 145, 129, 199, 155, 158, 157)) | |
80 | 19:19:50.609 | trace | yii\base\View::renderFile | Rendering view file: /var/www/html/frontend/views/site/items/incidentsItems.php | |
81 | 19:19:50.610 | info | yii\db\Command::query | SELECT * FROM `lang` WHERE `default` = 1 | |
82 | 19:19:50.610 | trace | yii\db\Command::query | Query result served from cache | |
83 | 19:19:50.611 | info | yii\db\Command::query | SELECT * FROM `incident_geographic` WHERE `incident_id`=3037 | |
84 | 19:19:50.614 | info | yii\db\Command::query | SELECT * FROM `persons` WHERE (`type`=100) AND (`incident_id`=3037) | |
85 | 19:19:50.616 | info | yii\db\Command::query | SHOW FULL COLUMNS FROM `persons` | |
86 | 19:19:50.617 | info | yii\db\Command::query | SHOW CREATE TABLE `persons` | |
87 | 19:19:50.617 | info | yii\db\Command::query | SELECT `kcu`.`CONSTRAINT_NAME` AS `constraint_name`, `kcu`.`COLUMN_NAME` AS `column_name`, `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`, `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name` FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc` JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON ( `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL) ) AND `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME` WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database() AND `rc`.`TABLE_NAME` = 'persons' AND `kcu`.`TABLE_NAME` = 'persons' | |
88 | 19:19:50.617 | trace | yii\base\View::renderFile | Rendering view file: /var/www/html/frontend/views/site/items/incidentsItems.php | |
89 | 19:19:50.618 | info | yii\db\Command::query | SELECT * FROM `lang` WHERE `default` = 1 | |
90 | 19:19:50.618 | trace | yii\db\Command::query | Query result served from cache | |
91 | 19:19:50.618 | info | yii\db\Command::query | SELECT * FROM `incident_geographic` WHERE `incident_id`=3038 | |
92 | 19:19:50.621 | info | yii\db\Command::query | SELECT * FROM `persons` WHERE (`type`=100) AND (`incident_id`=3038) | |
93 | 19:19:50.623 | trace | yii\base\View::renderFile | Rendering view file: /var/www/html/frontend/views/site/items/incidentsItems.php | |
94 | 19:19:50.623 | info | yii\db\Command::query | SELECT * FROM `lang` WHERE `default` = 1 | |
95 | 19:19:50.623 | trace | yii\db\Command::query | Query result served from cache | |
96 | 19:19:50.623 | info | yii\db\Command::query | SELECT * FROM `incident_geographic` WHERE `incident_id`=3039 | |
97 | 19:19:50.627 | info | yii\db\Command::query | SELECT * FROM `persons` WHERE (`type`=100) AND (`incident_id`=3039) | |
98 | 19:19:50.628 | trace | yii\base\View::renderFile | Rendering view file: /var/www/html/frontend/views/site/items/incidentsItems.php | |
99 | 19:19:50.629 | info | yii\db\Command::query | SELECT * FROM `lang` WHERE `default` = 1 | |
100 | 19:19:50.629 | trace | yii\db\Command::query | Query result served from cache | |
101 | 19:19:50.629 | info | yii\db\Command::query | SELECT * FROM `incident_geographic` WHERE `incident_id`=3041 | |
102 | 19:19:50.632 | info | yii\db\Command::query | SELECT * FROM `persons` WHERE (`type`=100) AND (`incident_id`=3041) | |
103 | 19:19:50.633 | trace | yii\base\View::renderFile | Rendering view file: /var/www/html/frontend/views/site/items/incidentsItems.php | |
104 | 19:19:50.634 | info | yii\db\Command::query | SELECT * FROM `lang` WHERE `default` = 1 | |
105 | 19:19:50.634 | trace | yii\db\Command::query | Query result served from cache | |
106 | 19:19:50.634 | info | yii\db\Command::query | SELECT * FROM `incident_geographic` WHERE `incident_id`=3026 | |
107 | 19:19:50.637 | info | yii\db\Command::query | SELECT * FROM `persons` WHERE (`type`=100) AND (`incident_id`=3026) | |
108 | 19:19:50.638 | trace | yii\base\View::renderFile | Rendering view file: /var/www/html/frontend/views/site/items/incidentsItems.php | |
109 | 19:19:50.639 | info | yii\db\Command::query | SELECT * FROM `lang` WHERE `default` = 1 | |
110 | 19:19:50.639 | trace | yii\db\Command::query | Query result served from cache | |
111 | 19:19:50.639 | info | yii\db\Command::query | SELECT * FROM `incident_geographic` WHERE `incident_id`=3020 | |
112 | 19:19:50.641 | info | yii\db\Command::query | SELECT * FROM `persons` WHERE (`type`=100) AND (`incident_id`=3020) | |
113 | 19:19:50.643 | trace | yii\base\View::renderFile | Rendering view file: /var/www/html/frontend/views/layouts/main.php | |
114 | 19:19:50.644 | info | yii\db\Command::query | SELECT * FROM `lang` WHERE `default` = 1 | |
115 | 19:19:50.644 | trace | yii\db\Command::query | Query result served from cache | |
116 | 19:19:50.644 | info | yii\db\Command::query | SELECT * FROM `lang` WHERE `default` = 1 | |
117 | 19:19:50.644 | trace | yii\db\Command::query | Query result served from cache | |
118 | 19:19:50.644 | trace | yii\base\View::renderFile | Rendering view file: /var/www/html/frontend/views/layouts/header.php | |
119 | 19:19:50.644 | info | yii\db\Command::query | SELECT * FROM `lang` WHERE `default` = 1 | |
120 | 19:19:50.644 | trace | yii\db\Command::query | Query result served from cache | |
121 | 19:19:50.645 | info | yii\db\Command::query | SELECT * FROM `lang` WHERE `active`=1 ORDER BY `id` | |
122 | 19:19:50.645 | trace | yii\db\Command::query | Query result served from cache | |
123 | 19:19:50.645 | info | yii\db\Command::query | SELECT * FROM `lang` WHERE `default` = 1 | |
124 | 19:19:50.645 | trace | yii\db\Command::query | Query result served from cache | |
125 | 19:19:50.645 | info | yii\db\Command::query | SELECT * FROM `lang` WHERE `default` = 1 | |
126 | 19:19:50.645 | trace | yii\db\Command::query | Query result served from cache | |
127 | 19:19:50.645 | info | yii\db\Command::query | SELECT * FROM `lang` WHERE `default` = 1 | |
128 | 19:19:50.645 | trace | yii\db\Command::query | Query result served from cache | |
129 | 19:19:50.646 | info | yii\db\Command::query | SELECT * FROM `lang` WHERE `default` = 1 | |
130 | 19:19:50.646 | trace | yii\db\Command::query | Query result served from cache | |
131 | 19:19:50.646 | info | yii\db\Command::query | SELECT * FROM `lang` WHERE `default` = 1 | |
132 | 19:19:50.646 | trace | yii\db\Command::query | Query result served from cache | |
133 | 19:19:50.646 | info | yii\db\Command::query | SELECT * FROM `lang` WHERE `default` = 1 | |
134 | 19:19:50.646 | trace | yii\db\Command::query | Query result served from cache | |
135 | 19:19:50.646 | info | yii\db\Command::query | SELECT * FROM `lang` WHERE `default` = 1 | |
136 | 19:19:50.646 | trace | yii\db\Command::query | Query result served from cache | |
137 | 19:19:50.646 | info | yii\db\Command::query | SELECT * FROM `lang` WHERE `default` = 1 | |
138 | 19:19:50.646 | trace | yii\db\Command::query | Query result served from cache | |
139 | 19:19:50.646 | info | yii\db\Command::query | SELECT * FROM `lang` WHERE `default` = 1 | |
140 | 19:19:50.646 | trace | yii\db\Command::query | Query result served from cache | |
141 | 19:19:50.646 | info | yii\db\Command::query | SELECT * FROM `lang` WHERE `default` = 1 | |
142 | 19:19:50.646 | trace | yii\db\Command::query | Query result served from cache | |
143 | 19:19:50.646 | info | yii\db\Command::query | SELECT * FROM `lang` WHERE `default` = 1 | |
144 | 19:19:50.646 | trace | yii\db\Command::query | Query result served from cache | |
145 | 19:19:50.647 | info | yii\db\Command::query | SELECT * FROM `lang` WHERE `default` = 1 | |
146 | 19:19:50.647 | trace | yii\db\Command::query | Query result served from cache | |
147 | 19:19:50.647 | info | yii\db\Command::query | SELECT * FROM `lang` WHERE `default` = 1 | |
148 | 19:19:50.647 | trace | yii\db\Command::query | Query result served from cache | |
149 | 19:19:50.647 | info | yii\db\Command::query | SELECT * FROM `lang` WHERE `default` = 1 | |
150 | 19:19:50.647 | trace | yii\db\Command::query | Query result served from cache | |
151 | 19:19:50.647 | info | yii\db\Command::query | SELECT * FROM `lang` WHERE `default` = 1 | |
152 | 19:19:50.647 | trace | yii\db\Command::query | Query result served from cache | |
153 | 19:19:50.648 | info | yii\db\Command::query | SELECT * FROM `menu` WHERE (`lang`='en') AND (`menu_type`=1) ORDER BY `num` | |
154 | 19:19:50.648 | info | yii\db\Command::query | SELECT * FROM `types` WHERE (`type`='statements') AND (`lang`='en') | |
155 | 19:19:50.648 | info | yii\db\Command::query | SELECT * FROM `lang` WHERE `default` = 1 | |
156 | 19:19:50.648 | trace | yii\db\Command::query | Query result served from cache | |
157 | 19:19:50.648 | info | yii\db\Command::query | SELECT * FROM `types` WHERE (`type`='research') AND (`lang`='en') | |
158 | 19:19:50.648 | info | yii\db\Command::query | SELECT * FROM `lang` WHERE `default` = 1 | |
159 | 19:19:50.648 | trace | yii\db\Command::query | Query result served from cache | |
160 | 19:19:50.649 | info | yii\db\Command::query | SELECT * FROM `types` WHERE (`type`='announcements') AND (`lang`='en') | |
161 | 19:19:50.649 | info | yii\db\Command::query | SELECT * FROM `lang` WHERE `default` = 1 | |
162 | 19:19:50.649 | trace | yii\db\Command::query | Query result served from cache | |
163 | 19:19:50.649 | info | yii\db\Command::query | SELECT * FROM `types` WHERE (`type`='news') AND (`lang`='en') | |
164 | 19:19:50.649 | info | yii\db\Command::query | SELECT * FROM `lang` WHERE `default` = 1 | |
165 | 19:19:50.649 | trace | yii\db\Command::query | Query result served from cache | |
166 | 19:19:50.649 | info | yii\db\Command::query | SELECT * FROM `types` WHERE (`type`='media-about-us') AND (`lang`='en') | |
167 | 19:19:50.649 | info | yii\db\Command::query | SELECT * FROM `lang` WHERE `default` = 1 | |
168 | 19:19:50.649 | trace | yii\db\Command::query | Query result served from cache | |
169 | 19:19:50.650 | trace | yii\base\View::renderFile | Rendering view file: /var/www/html/frontend/widgets/views/menu/render.php | |
170 | 19:19:50.650 | info | yii\db\Command::query | SELECT * FROM `menu` WHERE (`lang`='en') AND (`menu_type`=1) ORDER BY `num` | |
171 | 19:19:50.650 | info | yii\db\Command::query | SELECT * FROM `types` WHERE (`type`='statements') AND (`lang`='en') | |
172 | 19:19:50.650 | info | yii\db\Command::query | SELECT * FROM `lang` WHERE `default` = 1 | |
173 | 19:19:50.650 | trace | yii\db\Command::query | Query result served from cache | |
174 | 19:19:50.650 | info | yii\db\Command::query | SELECT * FROM `types` WHERE (`type`='research') AND (`lang`='en') | |
175 | 19:19:50.650 | info | yii\db\Command::query | SELECT * FROM `lang` WHERE `default` = 1 | |
176 | 19:19:50.650 | trace | yii\db\Command::query | Query result served from cache | |
177 | 19:19:50.651 | info | yii\db\Command::query | SELECT * FROM `types` WHERE (`type`='announcements') AND (`lang`='en') | |
178 | 19:19:50.651 | info | yii\db\Command::query | SELECT * FROM `lang` WHERE `default` = 1 | |
179 | 19:19:50.651 | trace | yii\db\Command::query | Query result served from cache | |
180 | 19:19:50.651 | info | yii\db\Command::query | SELECT * FROM `types` WHERE (`type`='news') AND (`lang`='en') | |
181 | 19:19:50.651 | info | yii\db\Command::query | SELECT * FROM `lang` WHERE `default` = 1 | |
182 | 19:19:50.651 | trace | yii\db\Command::query | Query result served from cache | |
183 | 19:19:50.651 | info | yii\db\Command::query | SELECT * FROM `types` WHERE (`type`='media-about-us') AND (`lang`='en') | |
184 | 19:19:50.651 | info | yii\db\Command::query | SELECT * FROM `lang` WHERE `default` = 1 | |
185 | 19:19:50.651 | trace | yii\db\Command::query | Query result served from cache | |
186 | 19:19:50.651 | trace | yii\base\View::renderFile | Rendering view file: /var/www/html/frontend/widgets/views/menu/render.php | |
187 | 19:19:50.652 | info | yii\db\Command::query | SELECT * FROM `lang` WHERE `default` = 1 | |
188 | 19:19:50.652 | trace | yii\db\Command::query | Query result served from cache | |
189 | 19:19:50.652 | info | yii\db\Command::query | SELECT * FROM `lang` WHERE `active`=1 ORDER BY `id` | |
190 | 19:19:50.652 | trace | yii\db\Command::query | Query result served from cache | |
191 | 19:19:50.652 | info | yii\db\Command::query | SELECT * FROM `lang` WHERE `default` = 1 | |
192 | 19:19:50.652 | trace | yii\db\Command::query | Query result served from cache | |
193 | 19:19:50.652 | info | yii\db\Command::query | SELECT * FROM `lang` WHERE `default` = 1 | |
194 | 19:19:50.652 | trace | yii\db\Command::query | Query result served from cache | |
195 | 19:19:50.652 | info | yii\db\Command::query | SELECT * FROM `lang` WHERE `default` = 1 | |
196 | 19:19:50.652 | trace | yii\db\Command::query | Query result served from cache | |
197 | 19:19:50.652 | info | yii\db\Command::query | SELECT * FROM `lang` WHERE `default` = 1 | |
198 | 19:19:50.653 | trace | yii\db\Command::query | Query result served from cache | |
199 | 19:19:50.653 | info | yii\db\Command::query | SELECT * FROM `lang` WHERE `default` = 1 | |
200 | 19:19:50.653 | trace | yii\db\Command::query | Query result served from cache | |
201 | 19:19:50.653 | info | yii\db\Command::query | SELECT * FROM `lang` WHERE `default` = 1 | |
202 | 19:19:50.653 | trace | yii\db\Command::query | Query result served from cache | |
203 | 19:19:50.653 | info | yii\db\Command::query | SELECT * FROM `lang` WHERE `default` = 1 | |
204 | 19:19:50.653 | trace | yii\db\Command::query | Query result served from cache | |
205 | 19:19:50.653 | info | yii\db\Command::query | SELECT * FROM `lang` WHERE `default` = 1 | |
206 | 19:19:50.653 | trace | yii\db\Command::query | Query result served from cache | |
207 | 19:19:50.653 | info | yii\db\Command::query | SELECT * FROM `lang` WHERE `default` = 1 | |
208 | 19:19:50.653 | trace | yii\db\Command::query | Query result served from cache | |
209 | 19:19:50.653 | info | yii\db\Command::query | SELECT * FROM `lang` WHERE `default` = 1 | |
210 | 19:19:50.653 | trace | yii\db\Command::query | Query result served from cache | |
211 | 19:19:50.653 | info | yii\db\Command::query | SELECT * FROM `lang` WHERE `default` = 1 | |
212 | 19:19:50.653 | trace | yii\db\Command::query | Query result served from cache | |
213 | 19:19:50.653 | info | yii\db\Command::query | SELECT * FROM `lang` WHERE `default` = 1 | |
214 | 19:19:50.653 | trace | yii\db\Command::query | Query result served from cache | |
215 | 19:19:50.654 | info | yii\db\Command::query | SELECT * FROM `lang` WHERE `default` = 1 | |
216 | 19:19:50.654 | trace | yii\db\Command::query | Query result served from cache | |
217 | 19:19:50.654 | info | yii\db\Command::query | SELECT * FROM `lang` WHERE `default` = 1 | |
218 | 19:19:50.654 | trace | yii\db\Command::query | Query result served from cache | |
219 | 19:19:50.654 | trace | yii\base\View::renderFile | Rendering view file: /var/www/html/frontend/views/layouts/footer.php | |
220 | 19:19:50.654 | trace | yii\base\View::renderFile | Rendering view file: /var/www/html/frontend/views/forms/subscribe.php | |
221 | 19:19:50.654 | info | yii\db\Command::query | SELECT * FROM `lang` WHERE `default` = 1 | |
222 | 19:19:50.654 | trace | yii\db\Command::query | Query result served from cache | |
223 | 19:19:50.654 | info | yii\db\Command::query | SELECT * FROM `menu` WHERE (`lang`='en') AND (`menu_type`=2) ORDER BY `num` | |
224 | 19:19:50.655 | info | yii\db\Command::query | SELECT * FROM `types` WHERE (`type`='statements') AND (`lang`='en') | |
225 | 19:19:50.655 | info | yii\db\Command::query | SELECT * FROM `lang` WHERE `default` = 1 | |
226 | 19:19:50.655 | trace | yii\db\Command::query | Query result served from cache | |
227 | 19:19:50.655 | info | yii\db\Command::query | SELECT * FROM `types` WHERE (`type`='research') AND (`lang`='en') | |
228 | 19:19:50.655 | info | yii\db\Command::query | SELECT * FROM `lang` WHERE `default` = 1 | |
229 | 19:19:50.655 | trace | yii\db\Command::query | Query result served from cache | |
230 | 19:19:50.655 | info | yii\db\Command::query | SELECT * FROM `types` WHERE (`type`='announcements') AND (`lang`='en') | |
231 | 19:19:50.655 | info | yii\db\Command::query | SELECT * FROM `lang` WHERE `default` = 1 | |
232 | 19:19:50.655 | trace | yii\db\Command::query | Query result served from cache | |
233 | 19:19:50.656 | info | yii\db\Command::query | SELECT * FROM `types` WHERE (`type`='news') AND (`lang`='en') | |
234 | 19:19:50.656 | info | yii\db\Command::query | SELECT * FROM `lang` WHERE `default` = 1 | |
235 | 19:19:50.656 | trace | yii\db\Command::query | Query result served from cache | |
236 | 19:19:50.656 | info | yii\db\Command::query | SELECT * FROM `types` WHERE (`type`='media-about-us') AND (`lang`='en') | |
237 | 19:19:50.656 | info | yii\db\Command::query | SELECT * FROM `lang` WHERE `default` = 1 | |
238 | 19:19:50.656 | trace | yii\db\Command::query | Query result served from cache | |
239 | 19:19:50.656 | trace | yii\base\View::renderFile | Rendering view file: /var/www/html/frontend/widgets/views/menu/render.php | |
240 | 19:19:50.656 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET | |
241 | 19:19:50.657 | info | yii\db\Command::query | SELECT * FROM `constants` | |
242 | 19:19:50.657 | info | yii\db\Command::query | SELECT MAX(updated_at) FROM `constants` | |
243 | 19:19:50.657 | info | yii\db\Command::query | SELECT COUNT(id) FROM `constants` | |
244 | 19:19:50.657 | trace | yii\db\Command::query | Query result served from cache | |
245 | 19:19:50.657 | info | yii\db\Command::query | SHOW FULL COLUMNS FROM `constants` | |
246 | 19:19:50.657 | info | yii\db\Command::query | SELECT MAX(updated_at) FROM `constants` | |
247 | 19:19:50.657 | info | yii\db\Command::query | SELECT COUNT(id) FROM `constants` | |
248 | 19:19:50.657 | trace | yii\db\Command::query | Query result served from cache | |
249 | 19:19:50.657 | info | yii\db\Command::query | SHOW CREATE TABLE `constants` | |
250 | 19:19:50.657 | info | yii\db\Command::query | SELECT MAX(updated_at) FROM `constants` | |
251 | 19:19:50.657 | info | yii\db\Command::query | SELECT COUNT(id) FROM `constants` | |
252 | 19:19:50.658 | trace | yii\db\Command::query | Query result served from cache | |
253 | 19:19:50.658 | info | yii\db\Command::query | SELECT `kcu`.`CONSTRAINT_NAME` AS `constraint_name`, `kcu`.`COLUMN_NAME` AS `column_name`, `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`, `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name` FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc` JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON ( `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL) ) AND `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME` WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database() AND `rc`.`TABLE_NAME` = 'constants' AND `kcu`.`TABLE_NAME` = 'constants' | |
254 | 19:19:50.658 | info | yii\db\Command::query | SELECT MAX(updated_at) FROM `constants` | |
255 | 19:19:50.658 | info | yii\db\Command::query | SELECT COUNT(id) FROM `constants` | |
256 | 19:19:50.658 | trace | yii\db\Command::query | Query result served from cache | |
257 | 19:19:50.659 | info | yii\db\Command::query | SELECT * FROM `lang` WHERE `default` = 1 | |
258 | 19:19:50.659 | trace | yii\db\Command::query | Query result served from cache | |
259 | 19:19:50.659 | info | yii\db\Command::query | SELECT * FROM `lang` WHERE `default` = 1 | |
260 | 19:19:50.659 | < 0ms > | trace | yii\db\Command::query | Query result served from cache |