Database Queries

Всего 159 записей.

Time	Duration	Type	Query

01:43:48.590	0.2 ms	SELECT	SELECT * FROM `cms_tree` WHERE `id`=1 [+] Explain
01:43:48.590	0.1 ms	SELECT	SELECT * FROM `cms_tree` WHERE 0=1 [+] Explain
01:43:48.590	0.1 ms	SELECT	SELECT * FROM `cms_site` WHERE (`code`='s1') AND (`active`='Y') [+] Explain
01:43:48.590	0.1 ms	SELECT	SELECT * FROM `cms_tree_type` WHERE `id`=1 [+] Explain
01:43:48.591	0.1 ms	SELECT	SELECT * FROM `cms_content_element` WHERE `content_id`=10 [+] Explain
01:43:48.592	0.1 ms	SELECT	SELECT * FROM `cms_content` WHERE `id`=10 [+] Explain
01:43:48.592	0.1 ms	SELECT	SELECT * FROM `cms_content_property` WHERE `content_id`=10 ORDER BY `priority` [+] Explain
01:43:48.593	0.1 ms	SELECT	SELECT * FROM `cms_content_element_property` WHERE `element_id`=321 [+] Explain
01:43:48.594	0.0 ms	SELECT	SELECT * FROM `cms_content` WHERE `id`=10 [+] Explain
01:43:48.594	0.1 ms	SELECT	SELECT * FROM `cms_content_property` WHERE `content_id`=10 ORDER BY `priority` [+] Explain
01:43:48.594	0.0 ms	SELECT	SELECT * FROM `cms_content_element_property` WHERE `element_id`=326 [+] Explain
01:43:48.595	0.0 ms	SELECT	SELECT * FROM `cms_content` WHERE `id`=10 [+] Explain
01:43:48.595	0.1 ms	SELECT	SELECT * FROM `cms_content_property` WHERE `content_id`=10 ORDER BY `priority` [+] Explain
01:43:48.595	0.0 ms	SELECT	SELECT * FROM `cms_content_element_property` WHERE `element_id`=232 [+] Explain
01:43:48.596	0.0 ms	SELECT	SELECT * FROM `cms_content` WHERE `id`=10 [+] Explain
01:43:48.596	0.1 ms	SELECT	SELECT * FROM `cms_content_property` WHERE `content_id`=10 ORDER BY `priority` [+] Explain
01:43:48.596	0.1 ms	SELECT	SELECT * FROM `cms_content_element_property` WHERE `element_id`=320 [+] Explain
01:43:48.597	0.1 ms	SELECT	SELECT * FROM `cms_content` WHERE `id`=10 [+] Explain
01:43:48.597	0.1 ms	SELECT	SELECT * FROM `cms_content_property` WHERE `content_id`=10 ORDER BY `priority` [+] Explain
01:43:48.598	0.0 ms	SELECT	SELECT * FROM `cms_content_element_property` WHERE `element_id`=231 [+] Explain
01:43:48.598	0.0 ms	SELECT	SELECT * FROM `cms_content` WHERE `id`=10 [+] Explain
01:43:48.598	0.1 ms	SELECT	SELECT * FROM `cms_content_property` WHERE `content_id`=10 ORDER BY `priority` [+] Explain
01:43:48.599	0.0 ms	SELECT	SELECT * FROM `cms_content_element_property` WHERE `element_id`=319 [+] Explain
01:43:48.599	0.0 ms	SELECT	SELECT * FROM `cms_content` WHERE `id`=10 [+] Explain
01:43:48.599	0.1 ms	SELECT	SELECT * FROM `cms_content_property` WHERE `content_id`=10 ORDER BY `priority` [+] Explain
01:43:48.600	0.0 ms	SELECT	SELECT * FROM `cms_content_element_property` WHERE `element_id`=325 [+] Explain
01:43:48.600	0.0 ms	SELECT	SELECT * FROM `cms_content` WHERE `id`=10 [+] Explain
01:43:48.600	0.1 ms	SELECT	SELECT * FROM `cms_content_property` WHERE `content_id`=10 ORDER BY `priority` [+] Explain
01:43:48.601	0.0 ms	SELECT	SELECT * FROM `cms_content_element_property` WHERE `element_id`=233 [+] Explain
01:43:48.601	0.0 ms	SELECT	SELECT * FROM `cms_content` WHERE `id`=10 [+] Explain
01:43:48.601	0.1 ms	SELECT	SELECT * FROM `cms_content_property` WHERE `content_id`=10 ORDER BY `priority` [+] Explain
01:43:48.602	0.1 ms	SELECT	SELECT * FROM `cms_content_element_property` WHERE `element_id`=236 [+] Explain
01:43:48.602	0.0 ms	SELECT	SELECT * FROM `cms_content` WHERE `id`=10 [+] Explain
01:43:48.602	0.1 ms	SELECT	SELECT * FROM `cms_content_property` WHERE `content_id`=10 ORDER BY `priority` [+] Explain
01:43:48.603	0.0 ms	SELECT	SELECT * FROM `cms_content_element_property` WHERE `element_id`=229 [+] Explain
01:43:48.603	0.0 ms	SELECT	SELECT * FROM `cms_content` WHERE `id`=10 [+] Explain
01:43:48.603	0.1 ms	SELECT	SELECT * FROM `cms_content_property` WHERE `content_id`=10 ORDER BY `priority` [+] Explain
01:43:48.604	0.0 ms	SELECT	SELECT * FROM `cms_content_element_property` WHERE `element_id`=230 [+] Explain
01:43:48.604	0.0 ms	SELECT	SELECT * FROM `cms_content` WHERE `id`=10 [+] Explain
01:43:48.604	0.1 ms	SELECT	SELECT * FROM `cms_content_property` WHERE `content_id`=10 ORDER BY `priority` [+] Explain
01:43:48.605	0.0 ms	SELECT	SELECT * FROM `cms_content_element_property` WHERE `element_id`=235 [+] Explain
01:43:48.605	0.0 ms	SELECT	SELECT * FROM `cms_content` WHERE `id`=10 [+] Explain
01:43:48.605	0.1 ms	SELECT	SELECT * FROM `cms_content_property` WHERE `content_id`=10 ORDER BY `priority` [+] Explain
01:43:48.606	0.1 ms	SELECT	SELECT * FROM `cms_content_element_property` WHERE `element_id`=238 [+] Explain
01:43:48.606	0.0 ms	SELECT	SELECT * FROM `cms_content` WHERE `id`=10 [+] Explain
01:43:48.606	0.1 ms	SELECT	SELECT * FROM `cms_content_property` WHERE `content_id`=10 ORDER BY `priority` [+] Explain
01:43:48.607	0.0 ms	SELECT	SELECT * FROM `cms_content_element_property` WHERE `element_id`=327 [+] Explain
01:43:48.607	0.0 ms	SELECT	SELECT * FROM `cms_content` WHERE `id`=10 [+] Explain
01:43:48.607	0.1 ms	SELECT	SELECT * FROM `cms_content_property` WHERE `content_id`=10 ORDER BY `priority` [+] Explain
01:43:48.608	0.0 ms	SELECT	SELECT * FROM `cms_content_element_property` WHERE `element_id`=237 [+] Explain
01:43:48.608	0.0 ms	SELECT	SELECT * FROM `cms_content` WHERE `id`=10 [+] Explain
01:43:48.608	0.1 ms	SELECT	SELECT * FROM `cms_content_property` WHERE `content_id`=10 ORDER BY `priority` [+] Explain
01:43:48.609	0.0 ms	SELECT	SELECT * FROM `cms_content_element_property` WHERE `element_id`=234 [+] Explain
01:43:48.609	0.0 ms	SELECT	SELECT * FROM `cms_content` WHERE `id`=10 [+] Explain
01:43:48.609	0.1 ms	SELECT	SELECT * FROM `cms_content_property` WHERE `content_id`=10 ORDER BY `priority` [+] Explain
01:43:48.610	0.1 ms	SELECT	SELECT * FROM `cms_content_element_property` WHERE `element_id`=322 [+] Explain
01:43:48.610	0.0 ms	SELECT	SELECT * FROM `cms_content` WHERE `id`=10 [+] Explain
01:43:48.610	0.1 ms	SELECT	SELECT * FROM `cms_content_property` WHERE `content_id`=10 ORDER BY `priority` [+] Explain
01:43:48.611	0.0 ms	SELECT	SELECT * FROM `cms_content_element_property` WHERE `element_id`=226 [+] Explain
01:43:48.611	0.0 ms	SELECT	SELECT * FROM `cms_content` WHERE `id`=10 [+] Explain
01:43:48.611	0.1 ms	SELECT	SELECT * FROM `cms_content_property` WHERE `content_id`=10 ORDER BY `priority` [+] Explain
01:43:48.612	0.0 ms	SELECT	SELECT * FROM `cms_content_element_property` WHERE `element_id`=318 [+] Explain
01:43:48.612	0.0 ms	SELECT	SELECT * FROM `cms_content` WHERE `id`=10 [+] Explain
01:43:48.612	0.1 ms	SELECT	SELECT * FROM `cms_content_property` WHERE `content_id`=10 ORDER BY `priority` [+] Explain
01:43:48.615	0.1 ms	SELECT	SELECT * FROM `cms_content_element_property` WHERE `element_id`=324 [+] Explain
01:43:48.615	0.0 ms	SELECT	SELECT * FROM `cms_content` WHERE `id`=10 [+] Explain
01:43:48.615	0.1 ms	SELECT	SELECT * FROM `cms_content_property` WHERE `content_id`=10 ORDER BY `priority` [+] Explain
01:43:48.616	0.0 ms	SELECT	SELECT * FROM `cms_content_element_property` WHERE `element_id`=323 [+] Explain
01:43:48.616	0.0 ms	SELECT	SELECT * FROM `cms_content` WHERE `id`=10 [+] Explain
01:43:48.616	0.1 ms	SELECT	SELECT * FROM `cms_content_property` WHERE `content_id`=10 ORDER BY `priority` [+] Explain
01:43:48.617	0.0 ms	SELECT	SELECT * FROM `cms_content_element_property` WHERE `element_id`=227 [+] Explain
01:43:48.618	0.0 ms	SELECT	SELECT `id` FROM `cms_tree` WHERE (`pids` LIKE '/1/%') OR (`pid`=1) ORDER BY `level`, `priority` [+] Explain
01:43:48.619	0.7 ms	SELECT	SELECT `cms_content_element`.* FROM `cms_content_element` LEFT JOIN `cms_content_element_tree` ON `cms_content_element`.`id` = `cms_content_element_tree`.`element_id` WHERE (`cms_content_element`.`active`='Y') AND (`cms_content_element`.`content_id`='9') AND ((`cms_content_element`.`tree_id` IN (65, 66, 67, 76, 18, 7, 8, 4, 50, 51, 64, 53, 1)) OR (`cms_content_element_tree`.`tree_id` IN (65, 66, 67, 76, 18, 7, 8, 4, 50, 51, 64, 53, 1))) AND (`cms_content_element`.`published_at` <= '1736549028') AND ((`cms_content_element`.`published_to` >= '1736549028') OR (`cms_content_element`.`published_to` IS NULL)) GROUP BY `cms_content_element`.`id` ORDER BY `priority` [+] Explain
01:43:48.620	0.1 ms	SELECT	SELECT * FROM `cms_storage_file` WHERE `id` IN (2948, 2864, 2865, 2867, 2863, 2868, 2971) [+] Explain
01:43:48.620	0.1 ms	SELECT	SELECT * FROM `cms_tree` WHERE `id`=1 [+] Explain
01:43:48.620	0.1 ms	SELECT	SELECT * FROM `cms_content_element_tree` WHERE `element_id` IN (330, 287, 288, 286, 317, 329, 331) [+] Explain
01:43:48.621	0.1 ms	SELECT	SELECT * FROM `cms_content` WHERE `id`=9 [+] Explain
01:43:48.621	0.1 ms	SELECT	SELECT * FROM `cms_content_property` WHERE `content_id`=9 ORDER BY `priority` [+] Explain
01:43:48.621	0.1 ms	SELECT	SELECT * FROM `cms_content_element_property` WHERE `element_id`=330 [+] Explain
01:43:48.622	0.1 ms	SELECT	SELECT * FROM `cms_content` WHERE `id`=9 [+] Explain
01:43:48.622	0.1 ms	SELECT	SELECT * FROM `cms_content_property` WHERE `content_id`=9 ORDER BY `priority` [+] Explain
01:43:48.622	0.1 ms	SELECT	SELECT * FROM `cms_content_element_property` WHERE `element_id`=287 [+] Explain
01:43:48.622	0.1 ms	SELECT	SELECT * FROM `cms_content` WHERE `id`=9 [+] Explain
01:43:48.622	0.1 ms	SELECT	SELECT * FROM `cms_content_property` WHERE `content_id`=9 ORDER BY `priority` [+] Explain
01:43:48.623	0.1 ms	SELECT	SELECT * FROM `cms_content_element_property` WHERE `element_id`=288 [+] Explain
01:43:48.623	0.1 ms	SELECT	SELECT * FROM `cms_content` WHERE `id`=9 [+] Explain
01:43:48.623	0.1 ms	SELECT	SELECT * FROM `cms_content_property` WHERE `content_id`=9 ORDER BY `priority` [+] Explain
01:43:48.623	0.1 ms	SELECT	SELECT * FROM `cms_content_element_property` WHERE `element_id`=286 [+] Explain
01:43:48.624	0.1 ms	SELECT	SELECT * FROM `cms_content` WHERE `id`=9 [+] Explain
01:43:48.624	0.1 ms	SELECT	SELECT * FROM `cms_content_property` WHERE `content_id`=9 ORDER BY `priority` [+] Explain
01:43:48.624	0.1 ms	SELECT	SELECT * FROM `cms_content_element_property` WHERE `element_id`=317 [+] Explain
01:43:48.624	0.1 ms	SELECT	SELECT * FROM `cms_content` WHERE `id`=9 [+] Explain
01:43:48.624	0.1 ms	SELECT	SELECT * FROM `cms_content_property` WHERE `content_id`=9 ORDER BY `priority` [+] Explain
01:43:48.625	0.1 ms	SELECT	SELECT * FROM `cms_content_element_property` WHERE `element_id`=329 [+] Explain
01:43:48.625	0.1 ms	SELECT	SELECT * FROM `cms_content` WHERE `id`=9 [+] Explain
01:43:48.625	0.1 ms	SELECT	SELECT * FROM `cms_content_property` WHERE `content_id`=9 ORDER BY `priority` [+] Explain
01:43:48.625	0.1 ms	SELECT	SELECT * FROM `cms_content_element_property` WHERE `element_id`=331 [+] Explain
01:43:48.627	0.1 ms	SELECT	SELECT * FROM `cms_tree` WHERE (`pid`='35') AND (`active`='Y') AND (`site_code`='s1') AND (`tree_type_id`='6') ORDER BY `priority` [+] Explain
01:43:48.628	0.1 ms	SELECT	SELECT * FROM `cms_tree` WHERE `pid` IN (112, 114, 42, 38, 40, 106, 39, 98, 105, 102, 43, 104, 101) ORDER BY `priority` [+] Explain
01:43:48.628	0.1 ms	SELECT	SELECT * FROM `cms_storage_file` WHERE `id`=2380 [+] Explain
01:43:48.628	0.1 ms	SELECT	SELECT * FROM `cms_storage_file` WHERE `id`=2959 [+] Explain
01:43:48.628	0.1 ms	SELECT	SELECT * FROM `cms_storage_file` WHERE `id`=1407 [+] Explain
01:43:48.629	0.1 ms	SELECT	SELECT * FROM `cms_storage_file` WHERE `id`=1402 [+] Explain
01:43:48.629	0.1 ms	SELECT	SELECT * FROM `cms_storage_file` WHERE `id`=1404 [+] Explain
01:43:48.629	0.1 ms	SELECT	SELECT * FROM `cms_storage_file` WHERE `id`=2365 [+] Explain
01:43:48.629	0.1 ms	SELECT	SELECT * FROM `cms_storage_file` WHERE `id`=2782 [+] Explain
01:43:48.629	0.1 ms	SELECT	SELECT * FROM `cms_storage_file` WHERE `id`=2707 [+] Explain
01:43:48.630	0.1 ms	SELECT	SELECT * FROM `cms_storage_file` WHERE `id`=2639 [+] Explain
01:43:48.630	0.1 ms	SELECT	SELECT * FROM `cms_storage_file` WHERE `id`=2701 [+] Explain
01:43:48.630	0.1 ms	SELECT	SELECT * FROM `cms_storage_file` WHERE `id`=1406 [+] Explain
01:43:48.630	0.1 ms	SELECT	SELECT * FROM `cms_storage_file` WHERE `id`=2360 [+] Explain
01:43:48.630	0.1 ms	SELECT	SELECT * FROM `cms_storage_file` WHERE `id`=1409 [+] Explain
01:43:48.632	0.1 ms	SELECT	SELECT * FROM `cms_tree` WHERE (`pid`='37') AND (`active`='Y') AND (`site_code`='s1') ORDER BY `priority` [+] Explain
01:43:48.633	0.1 ms	SELECT	SELECT * FROM `cms_tree` WHERE `pid` IN (57, 111, 58, 59, 62, 61) ORDER BY `priority` [+] Explain
01:43:48.633	0.1 ms	SELECT	SELECT * FROM `cms_storage_file` WHERE `id`=1463 [+] Explain
01:43:48.633	0.1 ms	SELECT	SELECT * FROM `cms_storage_file` WHERE `id`=1788 [+] Explain
01:43:48.633	0.1 ms	SELECT	SELECT * FROM `cms_storage_file` WHERE `id`=1790 [+] Explain
01:43:48.633	0.1 ms	SELECT	SELECT * FROM `cms_storage_file` WHERE `id`=1789 [+] Explain
01:43:48.634	0.1 ms	SELECT	SELECT * FROM `cms_storage_file` WHERE `id`=353 [+] Explain
01:43:48.634	0.1 ms	SELECT	SELECT * FROM `cms_storage_file` WHERE `id`=352 [+] Explain
01:43:48.634	0.1 ms	SELECT	SELECT * FROM `cms_tree` WHERE (`pid`='37') AND (`active`='Y') AND (`site_code`='s1') ORDER BY `priority` [+] Explain
01:43:48.634	0.1 ms	SELECT	SELECT * FROM `cms_tree` WHERE `pid` IN (57, 111, 58, 59, 62, 61) ORDER BY `priority` [+] Explain
01:43:48.637	0.1 ms	SELECT	SELECT * FROM `cms_tree` WHERE 0=1 [+] Explain
01:43:48.637	0.1 ms	SELECT	SELECT * FROM `cms_tree` WHERE (`pid`='1') AND (`level`='1') AND (`active`='Y') AND (`site_code`='s1') ORDER BY `priority` [+] Explain
01:43:48.638	0.1 ms	SELECT	SELECT * FROM `cms_tree` WHERE `pid` IN (65, 66, 67, 76, 7, 8, 4) ORDER BY `priority` [+] Explain
01:43:48.639	0.1 ms	SELECT	SELECT * FROM `cms_tree` WHERE `id`=35 [+] Explain
01:43:48.639	0.2 ms	SELECT	SELECT * FROM `cms_tree` WHERE `pid`=35 ORDER BY `priority` [+] Explain
01:43:48.640	0.1 ms	SELECT	SELECT * FROM `cms_tree` WHERE (`active`='Y') AND (`pid`=35) ORDER BY `priority` [+] Explain
01:43:48.641	0.1 ms	SELECT	SELECT * FROM `cms_tree` WHERE `id`=36 [+] Explain
01:43:48.641	0.1 ms	SELECT	SELECT * FROM `cms_tree` WHERE `pid`=36 ORDER BY `priority` [+] Explain
01:43:48.642	0.1 ms	SELECT	SELECT * FROM `cms_tree` WHERE (`active`='Y') AND (`pid`=36) ORDER BY `priority` [+] Explain
01:43:48.643	0.0 ms	SELECT	SELECT * FROM `cms_tree` WHERE `id`=37 [+] Explain
01:43:48.643	0.1 ms	SELECT	SELECT * FROM `cms_tree` WHERE `pid`=37 ORDER BY `priority` [+] Explain
01:43:48.643	0.1 ms	SELECT	SELECT * FROM `cms_tree` WHERE (`active`='Y') AND (`pid`=37) ORDER BY `priority` [+] Explain
01:43:48.644	0.0 ms	SELECT	SELECT * FROM `cms_tree` WHERE `id`=71 [+] Explain
01:43:48.644	0.1 ms	SELECT	SELECT * FROM `cms_tree` WHERE `pid`=71 ORDER BY `priority` [+] Explain
01:43:48.645	0.1 ms	SELECT	SELECT * FROM `cms_tree` WHERE (`active`='Y') AND (`pid`=71) ORDER BY `priority` [+] Explain
01:43:48.645	0.1 ms	SELECT	SELECT * FROM `cms_tree` WHERE `id`=63 [+] Explain
01:43:48.645	0.0 ms	SELECT	SELECT * FROM `cms_tree` WHERE `id`=69 [+] Explain
01:43:48.645	0.0 ms	SELECT	SELECT * FROM `cms_tree` WHERE 0=1 [+] Explain
01:43:48.646	0.0 ms	SELECT	SELECT * FROM `cms_tree` WHERE (`active`='Y') AND (`pid`=7) ORDER BY `priority` [+] Explain
01:43:48.646	0.1 ms	SELECT	SELECT * FROM `cms_tree` WHERE 0=1 [+] Explain
01:43:48.646	0.1 ms	SELECT	SELECT * FROM `cms_tree` WHERE 0=1 [+] Explain
01:43:48.648	0.1 ms	SELECT	SELECT * FROM `cms_tree` WHERE (`level`='1') AND (`active`='Y') AND (`site_code`='s1') ORDER BY `priority` [+] Explain
01:43:48.648	0.1 ms	SELECT	SELECT * FROM `cms_tree` WHERE `pid` IN (65, 66, 67, 76, 7, 8, 4) ORDER BY `priority` [+] Explain
01:43:48.649	0.1 ms	SELECT	SELECT * FROM `cms_tree` WHERE `id`=35 [+] Explain
01:43:48.649	0.1 ms	SELECT	SELECT * FROM `cms_tree` WHERE `id`=36 [+] Explain
01:43:48.649	0.1 ms	SELECT	SELECT * FROM `cms_tree` WHERE `id`=37 [+] Explain
01:43:48.649	0.1 ms	SELECT	SELECT * FROM `cms_tree` WHERE `id`=71 [+] Explain
01:43:48.651	0.1 ms	SELECT	SELECT * FROM `cms_tree` WHERE (`pid`='18') AND (`active`='Y') AND (`site_code`='s1') AND (`tree_type_id` IN ('2', '6')) ORDER BY `priority` [+] Explain
01:43:48.651	0.5 ms	SELECT	SELECT * FROM `cms_tree` WHERE `pid` IN (35, 36, 37, 71) ORDER BY `priority` [+] Explain
01:43:48.663	0.1 ms	SELECT	SELECT * FROM `form2_form` WHERE `code`='callback' [+] Explain
01:43:48.664	0.1 ms	SELECT	SELECT * FROM `form2_form` WHERE `id`=3 [+] Explain
01:43:48.664	0.1 ms	SELECT	SELECT * FROM `form2_form_property` WHERE `form_id`=3 ORDER BY `priority` [+] Explain
01:43:48.664	0.0 ms	SELECT	SELECT * FROM `form2_form_send_property` WHERE 0=1 [+] Explain
01:43:48.665	0.1 ms	SELECT	SELECT * FROM `form2_form` WHERE `code`='feedback' [+] Explain
01:43:48.665	0.1 ms	SELECT	SELECT * FROM `form2_form` WHERE `id`=1 [+] Explain
01:43:48.665	0.1 ms	SELECT	SELECT * FROM `form2_form_property` WHERE `form_id`=1 ORDER BY `priority` [+] Explain
01:43:48.666	0.1 ms	SELECT	SELECT * FROM `form2_form_send_property` WHERE 0=1 [+] Explain

[+] Explain all