Database Queries

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

Time	Duration	Type	Query

18:43:47.763	0.4 ms	SELECT	SELECT * FROM `cms_tree` WHERE `id`=1 [+] Explain
18:43:47.764	0.2 ms	SELECT	SELECT * FROM `cms_tree` WHERE 0=1 [+] Explain
18:43:47.764	0.2 ms	SELECT	SELECT * FROM `cms_site` WHERE (`code`='s1') AND (`active`='Y') [+] Explain
18:43:47.765	0.1 ms	SELECT	SELECT * FROM `cms_tree_type` WHERE `id`=1 [+] Explain
18:43:47.765	0.3 ms	SELECT	SELECT * FROM `cms_content_element` WHERE `content_id`=10 [+] Explain
18:43:47.767	0.2 ms	SELECT	SELECT * FROM `cms_content` WHERE `id`=10 [+] Explain
18:43:47.767	0.3 ms	SELECT	SELECT * FROM `cms_content_property` WHERE `content_id`=10 ORDER BY `priority` [+] Explain
18:43:47.768	0.2 ms	SELECT	SELECT * FROM `cms_content_element_property` WHERE `element_id`=321 [+] Explain
18:43:47.769	0.1 ms	SELECT	SELECT * FROM `cms_content` WHERE `id`=10 [+] Explain
18:43:47.769	0.1 ms	SELECT	SELECT * FROM `cms_content_property` WHERE `content_id`=10 ORDER BY `priority` [+] Explain
18:43:47.769	0.2 ms	SELECT	SELECT * FROM `cms_content_element_property` WHERE `element_id`=326 [+] Explain
18:43:47.770	0.1 ms	SELECT	SELECT * FROM `cms_content` WHERE `id`=10 [+] Explain
18:43:47.770	0.1 ms	SELECT	SELECT * FROM `cms_content_property` WHERE `content_id`=10 ORDER BY `priority` [+] Explain
18:43:47.771	0.2 ms	SELECT	SELECT * FROM `cms_content_element_property` WHERE `element_id`=232 [+] Explain
18:43:47.771	0.1 ms	SELECT	SELECT * FROM `cms_content` WHERE `id`=10 [+] Explain
18:43:47.771	0.1 ms	SELECT	SELECT * FROM `cms_content_property` WHERE `content_id`=10 ORDER BY `priority` [+] Explain
18:43:47.772	0.2 ms	SELECT	SELECT * FROM `cms_content_element_property` WHERE `element_id`=320 [+] Explain
18:43:47.772	0.1 ms	SELECT	SELECT * FROM `cms_content` WHERE `id`=10 [+] Explain
18:43:47.773	0.1 ms	SELECT	SELECT * FROM `cms_content_property` WHERE `content_id`=10 ORDER BY `priority` [+] Explain
18:43:47.773	0.2 ms	SELECT	SELECT * FROM `cms_content_element_property` WHERE `element_id`=231 [+] Explain
18:43:47.774	0.1 ms	SELECT	SELECT * FROM `cms_content` WHERE `id`=10 [+] Explain
18:43:47.774	0.1 ms	SELECT	SELECT * FROM `cms_content_property` WHERE `content_id`=10 ORDER BY `priority` [+] Explain
18:43:47.775	0.2 ms	SELECT	SELECT * FROM `cms_content_element_property` WHERE `element_id`=319 [+] Explain
18:43:47.775	0.1 ms	SELECT	SELECT * FROM `cms_content` WHERE `id`=10 [+] Explain
18:43:47.775	0.1 ms	SELECT	SELECT * FROM `cms_content_property` WHERE `content_id`=10 ORDER BY `priority` [+] Explain
18:43:47.776	0.2 ms	SELECT	SELECT * FROM `cms_content_element_property` WHERE `element_id`=325 [+] Explain
18:43:47.777	0.1 ms	SELECT	SELECT * FROM `cms_content` WHERE `id`=10 [+] Explain
18:43:47.777	0.1 ms	SELECT	SELECT * FROM `cms_content_property` WHERE `content_id`=10 ORDER BY `priority` [+] Explain
18:43:47.778	0.3 ms	SELECT	SELECT * FROM `cms_content_element_property` WHERE `element_id`=233 [+] Explain
18:43:47.779	0.1 ms	SELECT	SELECT * FROM `cms_content` WHERE `id`=10 [+] Explain
18:43:47.779	0.1 ms	SELECT	SELECT * FROM `cms_content_property` WHERE `content_id`=10 ORDER BY `priority` [+] Explain
18:43:47.780	0.2 ms	SELECT	SELECT * FROM `cms_content_element_property` WHERE `element_id`=236 [+] Explain
18:43:47.781	0.1 ms	SELECT	SELECT * FROM `cms_content` WHERE `id`=10 [+] Explain
18:43:47.781	0.1 ms	SELECT	SELECT * FROM `cms_content_property` WHERE `content_id`=10 ORDER BY `priority` [+] Explain
18:43:47.782	0.2 ms	SELECT	SELECT * FROM `cms_content_element_property` WHERE `element_id`=229 [+] Explain
18:43:47.783	0.1 ms	SELECT	SELECT * FROM `cms_content` WHERE `id`=10 [+] Explain
18:43:47.783	0.1 ms	SELECT	SELECT * FROM `cms_content_property` WHERE `content_id`=10 ORDER BY `priority` [+] Explain
18:43:47.784	0.2 ms	SELECT	SELECT * FROM `cms_content_element_property` WHERE `element_id`=230 [+] Explain
18:43:47.784	0.1 ms	SELECT	SELECT * FROM `cms_content` WHERE `id`=10 [+] Explain
18:43:47.785	0.2 ms	SELECT	SELECT * FROM `cms_content_property` WHERE `content_id`=10 ORDER BY `priority` [+] Explain
18:43:47.786	0.2 ms	SELECT	SELECT * FROM `cms_content_element_property` WHERE `element_id`=235 [+] Explain
18:43:47.786	0.1 ms	SELECT	SELECT * FROM `cms_content` WHERE `id`=10 [+] Explain
18:43:47.786	0.2 ms	SELECT	SELECT * FROM `cms_content_property` WHERE `content_id`=10 ORDER BY `priority` [+] Explain
18:43:47.787	0.2 ms	SELECT	SELECT * FROM `cms_content_element_property` WHERE `element_id`=238 [+] Explain
18:43:47.788	0.1 ms	SELECT	SELECT * FROM `cms_content` WHERE `id`=10 [+] Explain
18:43:47.788	0.1 ms	SELECT	SELECT * FROM `cms_content_property` WHERE `content_id`=10 ORDER BY `priority` [+] Explain
18:43:47.789	0.2 ms	SELECT	SELECT * FROM `cms_content_element_property` WHERE `element_id`=327 [+] Explain
18:43:47.790	0.1 ms	SELECT	SELECT * FROM `cms_content` WHERE `id`=10 [+] Explain
18:43:47.790	0.2 ms	SELECT	SELECT * FROM `cms_content_property` WHERE `content_id`=10 ORDER BY `priority` [+] Explain
18:43:47.791	0.2 ms	SELECT	SELECT * FROM `cms_content_element_property` WHERE `element_id`=237 [+] Explain
18:43:47.792	0.1 ms	SELECT	SELECT * FROM `cms_content` WHERE `id`=10 [+] Explain
18:43:47.792	0.1 ms	SELECT	SELECT * FROM `cms_content_property` WHERE `content_id`=10 ORDER BY `priority` [+] Explain
18:43:47.793	0.2 ms	SELECT	SELECT * FROM `cms_content_element_property` WHERE `element_id`=234 [+] Explain
18:43:47.794	0.1 ms	SELECT	SELECT * FROM `cms_content` WHERE `id`=10 [+] Explain
18:43:47.794	0.1 ms	SELECT	SELECT * FROM `cms_content_property` WHERE `content_id`=10 ORDER BY `priority` [+] Explain
18:43:47.795	0.3 ms	SELECT	SELECT * FROM `cms_content_element_property` WHERE `element_id`=322 [+] Explain
18:43:47.796	0.1 ms	SELECT	SELECT * FROM `cms_content` WHERE `id`=10 [+] Explain
18:43:47.796	0.1 ms	SELECT	SELECT * FROM `cms_content_property` WHERE `content_id`=10 ORDER BY `priority` [+] Explain
18:43:47.797	0.2 ms	SELECT	SELECT * FROM `cms_content_element_property` WHERE `element_id`=226 [+] Explain
18:43:47.797	0.1 ms	SELECT	SELECT * FROM `cms_content` WHERE `id`=10 [+] Explain
18:43:47.798	0.1 ms	SELECT	SELECT * FROM `cms_content_property` WHERE `content_id`=10 ORDER BY `priority` [+] Explain
18:43:47.798	0.2 ms	SELECT	SELECT * FROM `cms_content_element_property` WHERE `element_id`=318 [+] Explain
18:43:47.799	0.1 ms	SELECT	SELECT * FROM `cms_content` WHERE `id`=10 [+] Explain
18:43:47.799	0.1 ms	SELECT	SELECT * FROM `cms_content_property` WHERE `content_id`=10 ORDER BY `priority` [+] Explain
18:43:47.801	0.4 ms	SELECT	SELECT * FROM `cms_content_element_property` WHERE `element_id`=324 [+] Explain
18:43:47.802	0.1 ms	SELECT	SELECT * FROM `cms_content` WHERE `id`=10 [+] Explain
18:43:47.802	0.1 ms	SELECT	SELECT * FROM `cms_content_property` WHERE `content_id`=10 ORDER BY `priority` [+] Explain
18:43:47.803	0.2 ms	SELECT	SELECT * FROM `cms_content_element_property` WHERE `element_id`=323 [+] Explain
18:43:47.803	0.1 ms	SELECT	SELECT * FROM `cms_content` WHERE `id`=10 [+] Explain
18:43:47.803	0.1 ms	SELECT	SELECT * FROM `cms_content_property` WHERE `content_id`=10 ORDER BY `priority` [+] Explain
18:43:47.804	0.2 ms	SELECT	SELECT * FROM `cms_content_element_property` WHERE `element_id`=227 [+] Explain
18:43:47.805	0.3 ms	SELECT	SELECT `id` FROM `cms_tree` WHERE (`pids` LIKE '/1/%') OR (`pid`=1) ORDER BY `level`, `priority` [+] Explain
18:43:47.819	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` <= '1737560627') AND ((`cms_content_element`.`published_to` >= '1737560627') OR (`cms_content_element`.`published_to` IS NULL)) GROUP BY `cms_content_element`.`id` ORDER BY `priority` [+] Explain
18:43:47.820	0.2 ms	SELECT	SELECT * FROM `cms_storage_file` WHERE `id` IN (2948, 2864, 2865, 2867, 2863, 2868, 2971) [+] Explain
18:43:47.821	0.1 ms	SELECT	SELECT * FROM `cms_tree` WHERE `id`=1 [+] Explain
18:43:47.821	0.2 ms	SELECT	SELECT * FROM `cms_content_element_tree` WHERE `element_id` IN (330, 287, 288, 286, 317, 329, 331) [+] Explain
18:43:47.822	0.2 ms	SELECT	SELECT * FROM `cms_content` WHERE `id`=9 [+] Explain
18:43:47.822	0.3 ms	SELECT	SELECT * FROM `cms_content_property` WHERE `content_id`=9 ORDER BY `priority` [+] Explain
18:43:47.823	0.2 ms	SELECT	SELECT * FROM `cms_content_element_property` WHERE `element_id`=330 [+] Explain
18:43:47.823	0.1 ms	SELECT	SELECT * FROM `cms_content` WHERE `id`=9 [+] Explain
18:43:47.823	0.1 ms	SELECT	SELECT * FROM `cms_content_property` WHERE `content_id`=9 ORDER BY `priority` [+] Explain
18:43:47.823	0.2 ms	SELECT	SELECT * FROM `cms_content_element_property` WHERE `element_id`=287 [+] Explain
18:43:47.824	0.1 ms	SELECT	SELECT * FROM `cms_content` WHERE `id`=9 [+] Explain
18:43:47.824	0.1 ms	SELECT	SELECT * FROM `cms_content_property` WHERE `content_id`=9 ORDER BY `priority` [+] Explain
18:43:47.824	0.2 ms	SELECT	SELECT * FROM `cms_content_element_property` WHERE `element_id`=288 [+] Explain
18:43:47.825	0.1 ms	SELECT	SELECT * FROM `cms_content` WHERE `id`=9 [+] Explain
18:43:47.825	0.1 ms	SELECT	SELECT * FROM `cms_content_property` WHERE `content_id`=9 ORDER BY `priority` [+] Explain
18:43:47.825	0.2 ms	SELECT	SELECT * FROM `cms_content_element_property` WHERE `element_id`=286 [+] Explain
18:43:47.825	0.1 ms	SELECT	SELECT * FROM `cms_content` WHERE `id`=9 [+] Explain
18:43:47.826	0.1 ms	SELECT	SELECT * FROM `cms_content_property` WHERE `content_id`=9 ORDER BY `priority` [+] Explain
18:43:47.826	0.2 ms	SELECT	SELECT * FROM `cms_content_element_property` WHERE `element_id`=317 [+] Explain
18:43:47.826	0.1 ms	SELECT	SELECT * FROM `cms_content` WHERE `id`=9 [+] Explain
18:43:47.826	0.1 ms	SELECT	SELECT * FROM `cms_content_property` WHERE `content_id`=9 ORDER BY `priority` [+] Explain
18:43:47.827	0.2 ms	SELECT	SELECT * FROM `cms_content_element_property` WHERE `element_id`=329 [+] Explain
18:43:47.827	0.1 ms	SELECT	SELECT * FROM `cms_content` WHERE `id`=9 [+] Explain
18:43:47.827	0.1 ms	SELECT	SELECT * FROM `cms_content_property` WHERE `content_id`=9 ORDER BY `priority` [+] Explain
18:43:47.827	0.2 ms	SELECT	SELECT * FROM `cms_content_element_property` WHERE `element_id`=331 [+] Explain
18:43:47.837	0.6 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
18:43:47.839	0.3 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
18:43:47.839	0.2 ms	SELECT	SELECT * FROM `cms_storage_file` WHERE `id`=2380 [+] Explain
18:43:47.839	0.2 ms	SELECT	SELECT * FROM `cms_storage_file` WHERE `id`=2959 [+] Explain
18:43:47.840	0.1 ms	SELECT	SELECT * FROM `cms_storage_file` WHERE `id`=1407 [+] Explain
18:43:47.840	0.2 ms	SELECT	SELECT * FROM `cms_storage_file` WHERE `id`=1402 [+] Explain
18:43:47.840	0.2 ms	SELECT	SELECT * FROM `cms_storage_file` WHERE `id`=1404 [+] Explain
18:43:47.841	0.1 ms	SELECT	SELECT * FROM `cms_storage_file` WHERE `id`=2365 [+] Explain
18:43:47.841	0.1 ms	SELECT	SELECT * FROM `cms_storage_file` WHERE `id`=2782 [+] Explain
18:43:47.841	0.2 ms	SELECT	SELECT * FROM `cms_storage_file` WHERE `id`=2707 [+] Explain
18:43:47.842	0.1 ms	SELECT	SELECT * FROM `cms_storage_file` WHERE `id`=2639 [+] Explain
18:43:47.842	0.2 ms	SELECT	SELECT * FROM `cms_storage_file` WHERE `id`=2701 [+] Explain
18:43:47.842	0.2 ms	SELECT	SELECT * FROM `cms_storage_file` WHERE `id`=1406 [+] Explain
18:43:47.842	0.2 ms	SELECT	SELECT * FROM `cms_storage_file` WHERE `id`=2360 [+] Explain
18:43:47.843	0.2 ms	SELECT	SELECT * FROM `cms_storage_file` WHERE `id`=1409 [+] Explain
18:43:47.845	3.1 ms	SELECT	SELECT * FROM `cms_tree` WHERE (`pid`='37') AND (`active`='Y') AND (`site_code`='s1') ORDER BY `priority` [+] Explain
18:43:47.849	0.3 ms	SELECT	SELECT * FROM `cms_tree` WHERE `pid` IN (57, 111, 58, 59, 62, 61) ORDER BY `priority` [+] Explain
18:43:47.849	0.2 ms	SELECT	SELECT * FROM `cms_storage_file` WHERE `id`=1463 [+] Explain
18:43:47.850	0.2 ms	SELECT	SELECT * FROM `cms_storage_file` WHERE `id`=1788 [+] Explain
18:43:47.850	0.2 ms	SELECT	SELECT * FROM `cms_storage_file` WHERE `id`=1790 [+] Explain
18:43:47.850	0.2 ms	SELECT	SELECT * FROM `cms_storage_file` WHERE `id`=1789 [+] Explain
18:43:47.850	0.2 ms	SELECT	SELECT * FROM `cms_storage_file` WHERE `id`=353 [+] Explain
18:43:47.851	0.2 ms	SELECT	SELECT * FROM `cms_storage_file` WHERE `id`=352 [+] Explain
18:43:47.851	0.2 ms	SELECT	SELECT * FROM `cms_tree` WHERE (`pid`='37') AND (`active`='Y') AND (`site_code`='s1') ORDER BY `priority` [+] Explain
18:43:47.851	0.0 ms	SELECT	SELECT * FROM `cms_tree` WHERE `pid` IN (57, 111, 58, 59, 62, 61) ORDER BY `priority` [+] Explain
18:43:47.852	0.1 ms	SELECT	SELECT * FROM `cms_tree` WHERE 0=1 [+] Explain
18:43:47.853	0.4 ms	SELECT	SELECT * FROM `cms_tree` WHERE (`pid`='1') AND (`level`='1') AND (`active`='Y') AND (`site_code`='s1') ORDER BY `priority` [+] Explain
18:43:47.854	0.3 ms	SELECT	SELECT * FROM `cms_tree` WHERE `pid` IN (65, 66, 67, 76, 7, 8, 4) ORDER BY `priority` [+] Explain
18:43:47.854	0.2 ms	SELECT	SELECT * FROM `cms_tree` WHERE `id`=35 [+] Explain
18:43:47.855	0.3 ms	SELECT	SELECT * FROM `cms_tree` WHERE `pid`=35 ORDER BY `priority` [+] Explain
18:43:47.856	0.3 ms	SELECT	SELECT * FROM `cms_tree` WHERE (`active`='Y') AND (`pid`=35) ORDER BY `priority` [+] Explain
18:43:47.857	0.2 ms	SELECT	SELECT * FROM `cms_tree` WHERE `id`=36 [+] Explain
18:43:47.857	0.3 ms	SELECT	SELECT * FROM `cms_tree` WHERE `pid`=36 ORDER BY `priority` [+] Explain
18:43:47.858	0.3 ms	SELECT	SELECT * FROM `cms_tree` WHERE (`active`='Y') AND (`pid`=36) ORDER BY `priority` [+] Explain
18:43:47.859	0.2 ms	SELECT	SELECT * FROM `cms_tree` WHERE `id`=37 [+] Explain
18:43:47.859	0.3 ms	SELECT	SELECT * FROM `cms_tree` WHERE `pid`=37 ORDER BY `priority` [+] Explain
18:43:47.860	0.3 ms	SELECT	SELECT * FROM `cms_tree` WHERE (`active`='Y') AND (`pid`=37) ORDER BY `priority` [+] Explain
18:43:47.861	0.2 ms	SELECT	SELECT * FROM `cms_tree` WHERE `id`=71 [+] Explain
18:43:47.861	0.3 ms	SELECT	SELECT * FROM `cms_tree` WHERE `pid`=71 ORDER BY `priority` [+] Explain
18:43:47.862	0.3 ms	SELECT	SELECT * FROM `cms_tree` WHERE (`active`='Y') AND (`pid`=71) ORDER BY `priority` [+] Explain
18:43:47.863	0.2 ms	SELECT	SELECT * FROM `cms_tree` WHERE `id`=63 [+] Explain
18:43:47.863	0.2 ms	SELECT	SELECT * FROM `cms_tree` WHERE `id`=69 [+] Explain
18:43:47.863	0.1 ms	SELECT	SELECT * FROM `cms_tree` WHERE 0=1 [+] Explain
18:43:47.864	0.2 ms	SELECT	SELECT * FROM `cms_tree` WHERE (`active`='Y') AND (`pid`=7) ORDER BY `priority` [+] Explain
18:43:47.864	0.1 ms	SELECT	SELECT * FROM `cms_tree` WHERE 0=1 [+] Explain
18:43:47.864	0.1 ms	SELECT	SELECT * FROM `cms_tree` WHERE 0=1 [+] Explain
18:43:47.869	0.4 ms	SELECT	SELECT * FROM `cms_tree` WHERE (`level`='1') AND (`active`='Y') AND (`site_code`='s1') ORDER BY `priority` [+] Explain
18:43:47.870	0.2 ms	SELECT	SELECT * FROM `cms_tree` WHERE `pid` IN (65, 66, 67, 76, 7, 8, 4) ORDER BY `priority` [+] Explain
18:43:47.870	0.1 ms	SELECT	SELECT * FROM `cms_tree` WHERE `id`=35 [+] Explain
18:43:47.870	0.1 ms	SELECT	SELECT * FROM `cms_tree` WHERE `id`=36 [+] Explain
18:43:47.871	0.1 ms	SELECT	SELECT * FROM `cms_tree` WHERE `id`=37 [+] Explain
18:43:47.871	0.1 ms	SELECT	SELECT * FROM `cms_tree` WHERE `id`=71 [+] Explain
18:43:47.888	0.4 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
18:43:47.889	0.8 ms	SELECT	SELECT * FROM `cms_tree` WHERE `pid` IN (35, 36, 37, 71) ORDER BY `priority` [+] Explain
18:43:47.900	0.3 ms	SELECT	SELECT * FROM `form2_form` WHERE `code`='callback' [+] Explain
18:43:47.900	0.1 ms	SELECT	SELECT * FROM `form2_form` WHERE `id`=3 [+] Explain
18:43:47.900	0.2 ms	SELECT	SELECT * FROM `form2_form_property` WHERE `form_id`=3 ORDER BY `priority` [+] Explain
18:43:47.901	0.1 ms	SELECT	SELECT * FROM `form2_form_send_property` WHERE 0=1 [+] Explain
18:43:47.902	0.2 ms	SELECT	SELECT * FROM `form2_form` WHERE `code`='feedback' [+] Explain
18:43:47.902	0.2 ms	SELECT	SELECT * FROM `form2_form` WHERE `id`=1 [+] Explain
18:43:47.902	0.2 ms	SELECT	SELECT * FROM `form2_form_property` WHERE `form_id`=1 ORDER BY `priority` [+] Explain
18:43:47.903	0.1 ms	SELECT	SELECT * FROM `form2_form_send_property` WHERE 0=1 [+] Explain

[+] Explain all