Афиша — Спортивная школа водных видов спорта им.В.В. Сальникова

MySQL статистика (109)

Query	Rows	Time	Cached
SET SESSION sql_mode = ''	-	0.000069	false
SELECT items.id, items.parent_id, items.title, items.is_hidden_in_menu, items.sort_order, items.href, menus.code as menu_code, menus.use_code_in_links as menu_code_in_links, blocks.id as block_id, blocks.code as block_code, blocks.description, blocks.content, blocks.template, blocks.block_type, f.id as image_id, f.disk_name as image_path FROM admin_menu_items as items LEFT JOIN admin_menus as menus ON menus.id = items.menu_id LEFT JOIN admin_text_blocks as blocks ON blocks.id = items.text_block_id LEFT JOIN db_files as f ON f.master_object_id = items.id AND f.master_object_class = 'Admin_MenuItem' AND f.field = 'image' WHERE items.is_hidden is null ORDER BY items.parent_id, items.sort_order	115	0.004084	false
SELECT * FROM extrafields WHERE object_class = 'Admin_MenuItem' AND object_id in ('1', '2', '3', '72', '18', '13', '19', '112', '28', '29', '30', '31', '35', '36', '37', '38', '69', '70', '71', '21', '73', '74', '87', '89', '90', '91', '92', '93', '94', '95', '96', '105', '106', '107', '108', '110', '111', '22', '144', '14', '24', '23', '39', '40', '47', '48', '60', '61', '102', '133', '15', '16', '17', '86', '88', '46', '62', '66', '56', '57', '75', '51', '52', '58', '59', '41', '42', '43', '44', '45', '100', '101', '113', '114', '115', '116', '117', '118', '119', '120', '121', '122', '123', '124', '125', '126', '127', '128', '134', '129', '130', '131', '132', '135', '136', '137', '138', '139', '140', '141', '142', '143', '53', '54', '80', '81', '82', '84', '83', '85', '63', '64', '65', '67', '68')	374	0.001207	false
SELECT * FROM playbills_categories	3	0.000296	false
SELECT * FROM playbills_events as events WHERE (event_date >= '2025-07-01' OR event_end_date >= '2025-07-01' OR (event_end_date is null AND is_permanent = 1)) AND (event_date <= '2025-07-31' OR event_end_date <= '2025-07-31' OR (event_end_date is null AND is_permanent = 1)) ORDER BY event_date, event_times	0	0.000477	false
SELECT * FROM playbills_events as events WHERE (event_date >= '2025-07-07' OR event_end_date >= '2025-07-07' OR (event_end_date is null AND is_permanent = 1)) AND (event_date <= '2025-07-07' OR event_end_date <= '2025-07-07' OR (event_end_date is null AND is_permanent = 1)) ORDER BY event_date, event_times	0	0.000351	false
SELECT places.*, settlements.title as settlement FROM playbills_places AS places LEFT JOIN playbills_settlements AS settlements ON settlements.id = places.settlement_id WHERE false	0	0.000196	false
SELECT playbills.id FROM playbills_playbills as playbills LEFT JOIN playbills_events as events ON playbills.id = events.playbill_id WHERE hidden is null AND playbills.id = -1 GROUP BY id LIMIT 100	0	0.000224	false
SHOW TABLES LIKE 'extrafields'	1	0.001734	false
SELECT (select group_concat(extrafields.id ORDER BY 1 SEPARATOR ', ') from extrafields where extrafields.object_id = seo_settings.id and (object_class='Admin_SeoParams')) as extrafields_calculated, seo_settings.* FROM seo_settings ORDER BY id desc LIMIT 0, 1	1	0.000634	false
SHOW TABLES LIKE 'extrafields'	1	0.001026	false
update seo_settings set individual_seo_settings = 'a:0:{}'	-	0.000169	false
SHOW TABLES LIKE 'extrafields'	1	0.001138	false
SELECT (select group_concat(extrafields.id ORDER BY 1 SEPARATOR ', ') from extrafields where extrafields.object_id = admin_module_settings.id and (object_class='Admin_ModuleSettings')) as extrafields_calculated, admin_module_settings.* FROM admin_module_settings WHERE (admin_module_settings.module_id='admin') AND (admin_module_settings.form_id='default') LIMIT 0, 1	1	0.000537	false
SHOW TABLES LIKE 'extrafields'	1	0.001026	false
SHOW TABLES LIKE 'extrafields'	1	0.001080	false
SELECT (select group_concat(extrafields.id ORDER BY 1 SEPARATOR ', ') from extrafields where extrafields.object_id = admin_menus.id and (object_class='Admin_Menu')) as extrafields_calculated, admin_menus.* FROM admin_menus WHERE (admin_menus.code = 'main') LIMIT 0, 1	1	0.000489	false
SHOW TABLES LIKE 'extrafields'	1	0.001010	false
SHOW TABLES LIKE 'extrafields'	1	0.001076	false
SELECT (select group_concat(db_files.id ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = admin_menu_items.id and (master_object_class='Admin_MenuItem' and field='photos')) as photos_calculated, (select group_concat(db_files.name ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = admin_menu_items.id and (master_object_class='Admin_MenuItem' and field='document_files')) as document_files_calculated, (select group_concat(extrafields.id ORDER BY 1 SEPARATOR ', ') from extrafields where extrafields.object_id = admin_menu_items.id and (object_class='Admin_MenuItem')) as extrafields_calculated, admin_menu_items.* FROM admin_menu_items WHERE (admin_menu_items.menu_id = '1') AND (admin_menu_items.parent_id is null and (admin_menu_items.is_hidden is null or admin_menu_items.is_hidden=0) and (admin_menu_items.is_hidden_in_menu is null or admin_menu_items.is_hidden_in_menu=0)) ORDER BY group_name, sort_order	7	0.002090	false
SHOW TABLES LIKE 'extrafields'	1	0.001072	false
SHOW TABLES LIKE 'extrafields'	1	0.001067	false
SHOW TABLES LIKE 'extrafields'	1	0.001045	false
SHOW TABLES LIKE 'extrafields'	1	0.001082	false
SHOW TABLES LIKE 'extrafields'	1	0.000986	false
SHOW TABLES LIKE 'extrafields'	1	0.000977	false
SHOW TABLES LIKE 'extrafields'	1	0.001004	false
SELECT admin_menu_items.* FROM admin_menu_items ORDER BY sort_order	115	0.000567	false
SHOW TABLES LIKE 'extrafields'	1	0.001061	false
SELECT (select group_concat(extrafields.id ORDER BY 1 SEPARATOR ', ') from extrafields where extrafields.object_id = admin_menus.id and (object_class='Admin_Menu')) as extrafields_calculated, admin_menus.* FROM admin_menus WHERE (admin_menus.id = '1') LIMIT 0, 1	1	0.000542	false
SHOW TABLES LIKE 'extrafields'	1	0.001278	false
SHOW TABLES LIKE 'extrafields'	1	0.001081	false
SELECT (select group_concat(db_files.id ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = admin_menu_items.id and (master_object_class='Admin_MenuItem' and field='photos')) as photos_calculated, (select group_concat(db_files.name ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = admin_menu_items.id and (master_object_class='Admin_MenuItem' and field='document_files')) as document_files_calculated, (select group_concat(extrafields.id ORDER BY 1 SEPARATOR ', ') from extrafields where extrafields.object_id = admin_menu_items.id and (object_class='Admin_MenuItem')) as extrafields_calculated, admin_menu_items.* FROM admin_menu_items WHERE (admin_menu_items.id = '14') LIMIT 0, 1	1	0.000729	false
SHOW TABLES LIKE 'extrafields'	1	0.001055	false
SHOW TABLES LIKE 'extrafields'	1	0.001045	false
SELECT (select group_concat(db_files.id ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = admin_menu_items.id and (master_object_class='Admin_MenuItem' and field='photos')) as photos_calculated, (select group_concat(db_files.name ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = admin_menu_items.id and (master_object_class='Admin_MenuItem' and field='document_files')) as document_files_calculated, (select group_concat(extrafields.id ORDER BY 1 SEPARATOR ', ') from extrafields where extrafields.object_id = admin_menu_items.id and (object_class='Admin_MenuItem')) as extrafields_calculated, admin_menu_items.* FROM admin_menu_items WHERE (admin_menu_items.id = '14') LIMIT 0, 1	1	0.000927	false
SHOW TABLES LIKE 'extrafields'	1	0.001146	false
SHOW TABLES LIKE 'extrafields'	1	0.001098	false
SELECT (select group_concat(db_files.id ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = admin_menu_items.id and (master_object_class='Admin_MenuItem' and field='photos')) as photos_calculated, (select group_concat(db_files.name ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = admin_menu_items.id and (master_object_class='Admin_MenuItem' and field='document_files')) as document_files_calculated, (select group_concat(extrafields.id ORDER BY 1 SEPARATOR ', ') from extrafields where extrafields.object_id = admin_menu_items.id and (object_class='Admin_MenuItem')) as extrafields_calculated, admin_menu_items.* FROM admin_menu_items WHERE (admin_menu_items.id = '24') LIMIT 0, 1	1	0.000750	false
SHOW TABLES LIKE 'extrafields'	1	0.001145	false
SHOW TABLES LIKE 'extrafields'	1	0.001079	false
SELECT (select group_concat(db_files.id ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = admin_menu_items.id and (master_object_class='Admin_MenuItem' and field='photos')) as photos_calculated, (select group_concat(db_files.name ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = admin_menu_items.id and (master_object_class='Admin_MenuItem' and field='document_files')) as document_files_calculated, (select group_concat(extrafields.id ORDER BY 1 SEPARATOR ', ') from extrafields where extrafields.object_id = admin_menu_items.id and (object_class='Admin_MenuItem')) as extrafields_calculated, admin_menu_items.* FROM admin_menu_items WHERE (admin_menu_items.id = '24') LIMIT 0, 1	1	0.000783	false
SHOW TABLES LIKE 'extrafields'	1	0.000998	false
SHOW TABLES LIKE 'extrafields'	1	0.001079	false
SELECT (select group_concat(db_files.id ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = admin_menu_items.id and (master_object_class='Admin_MenuItem' and field='photos')) as photos_calculated, (select group_concat(db_files.name ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = admin_menu_items.id and (master_object_class='Admin_MenuItem' and field='document_files')) as document_files_calculated, (select group_concat(extrafields.id ORDER BY 1 SEPARATOR ', ') from extrafields where extrafields.object_id = admin_menu_items.id and (object_class='Admin_MenuItem')) as extrafields_calculated, admin_menu_items.* FROM admin_menu_items WHERE (admin_menu_items.id = '23') LIMIT 0, 1	1	0.000732	false
SHOW TABLES LIKE 'extrafields'	1	0.001089	false
SHOW TABLES LIKE 'extrafields'	1	0.001226	false
SELECT (select group_concat(db_files.id ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = admin_menu_items.id and (master_object_class='Admin_MenuItem' and field='photos')) as photos_calculated, (select group_concat(db_files.name ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = admin_menu_items.id and (master_object_class='Admin_MenuItem' and field='document_files')) as document_files_calculated, (select group_concat(extrafields.id ORDER BY 1 SEPARATOR ', ') from extrafields where extrafields.object_id = admin_menu_items.id and (object_class='Admin_MenuItem')) as extrafields_calculated, admin_menu_items.* FROM admin_menu_items WHERE (admin_menu_items.id = '23') LIMIT 0, 1	1	0.000766	false
SHOW TABLES LIKE 'extrafields'	1	0.001255	false
SHOW TABLES LIKE 'extrafields'	1	0.001273	false
SELECT (select group_concat(db_files.id ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = admin_menu_items.id and (master_object_class='Admin_MenuItem' and field='photos')) as photos_calculated, (select group_concat(db_files.name ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = admin_menu_items.id and (master_object_class='Admin_MenuItem' and field='document_files')) as document_files_calculated, (select group_concat(extrafields.id ORDER BY 1 SEPARATOR ', ') from extrafields where extrafields.object_id = admin_menu_items.id and (object_class='Admin_MenuItem')) as extrafields_calculated, admin_menu_items.* FROM admin_menu_items WHERE (admin_menu_items.id = '39') LIMIT 0, 1	1	0.000837	false
SHOW TABLES LIKE 'extrafields'	1	0.001090	false
SHOW TABLES LIKE 'extrafields'	1	0.001090	false
SELECT (select group_concat(db_files.id ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = admin_menu_items.id and (master_object_class='Admin_MenuItem' and field='photos')) as photos_calculated, (select group_concat(db_files.name ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = admin_menu_items.id and (master_object_class='Admin_MenuItem' and field='document_files')) as document_files_calculated, (select group_concat(extrafields.id ORDER BY 1 SEPARATOR ', ') from extrafields where extrafields.object_id = admin_menu_items.id and (object_class='Admin_MenuItem')) as extrafields_calculated, admin_menu_items.* FROM admin_menu_items WHERE (admin_menu_items.id = '39') LIMIT 0, 1	1	0.000775	false
SHOW TABLES LIKE 'extrafields'	1	0.001101	false
SHOW TABLES LIKE 'extrafields'	1	0.001119	false
SELECT (select group_concat(db_files.id ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = admin_menu_items.id and (master_object_class='Admin_MenuItem' and field='photos')) as photos_calculated, (select group_concat(db_files.name ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = admin_menu_items.id and (master_object_class='Admin_MenuItem' and field='document_files')) as document_files_calculated, (select group_concat(extrafields.id ORDER BY 1 SEPARATOR ', ') from extrafields where extrafields.object_id = admin_menu_items.id and (object_class='Admin_MenuItem')) as extrafields_calculated, admin_menu_items.* FROM admin_menu_items WHERE (admin_menu_items.id = '40') LIMIT 0, 1	1	0.000846	false
SHOW TABLES LIKE 'extrafields'	1	0.001070	false
SHOW TABLES LIKE 'extrafields'	1	0.001067	false
SELECT (select group_concat(db_files.id ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = admin_menu_items.id and (master_object_class='Admin_MenuItem' and field='photos')) as photos_calculated, (select group_concat(db_files.name ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = admin_menu_items.id and (master_object_class='Admin_MenuItem' and field='document_files')) as document_files_calculated, (select group_concat(extrafields.id ORDER BY 1 SEPARATOR ', ') from extrafields where extrafields.object_id = admin_menu_items.id and (object_class='Admin_MenuItem')) as extrafields_calculated, admin_menu_items.* FROM admin_menu_items WHERE (admin_menu_items.id = '40') LIMIT 0, 1	1	0.000752	false
SHOW TABLES LIKE 'extrafields'	1	0.001050	false
SHOW TABLES LIKE 'extrafields'	1	0.001081	false
SELECT (select group_concat(db_files.id ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = admin_menu_items.id and (master_object_class='Admin_MenuItem' and field='photos')) as photos_calculated, (select group_concat(db_files.name ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = admin_menu_items.id and (master_object_class='Admin_MenuItem' and field='document_files')) as document_files_calculated, (select group_concat(extrafields.id ORDER BY 1 SEPARATOR ', ') from extrafields where extrafields.object_id = admin_menu_items.id and (object_class='Admin_MenuItem')) as extrafields_calculated, admin_menu_items.* FROM admin_menu_items WHERE (admin_menu_items.id = '47') LIMIT 0, 1	1	0.000761	false
SHOW TABLES LIKE 'extrafields'	1	0.001128	false
SHOW TABLES LIKE 'extrafields'	1	0.001108	false
SELECT (select group_concat(db_files.id ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = admin_menu_items.id and (master_object_class='Admin_MenuItem' and field='photos')) as photos_calculated, (select group_concat(db_files.name ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = admin_menu_items.id and (master_object_class='Admin_MenuItem' and field='document_files')) as document_files_calculated, (select group_concat(extrafields.id ORDER BY 1 SEPARATOR ', ') from extrafields where extrafields.object_id = admin_menu_items.id and (object_class='Admin_MenuItem')) as extrafields_calculated, admin_menu_items.* FROM admin_menu_items WHERE (admin_menu_items.id = '47') LIMIT 0, 1	1	0.000689	false
SHOW TABLES LIKE 'extrafields'	1	0.001078	false
SHOW TABLES LIKE 'extrafields'	1	0.001062	false
SELECT (select group_concat(db_files.id ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = admin_menu_items.id and (master_object_class='Admin_MenuItem' and field='photos')) as photos_calculated, (select group_concat(db_files.name ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = admin_menu_items.id and (master_object_class='Admin_MenuItem' and field='document_files')) as document_files_calculated, (select group_concat(extrafields.id ORDER BY 1 SEPARATOR ', ') from extrafields where extrafields.object_id = admin_menu_items.id and (object_class='Admin_MenuItem')) as extrafields_calculated, admin_menu_items.* FROM admin_menu_items WHERE (admin_menu_items.id = '48') LIMIT 0, 1	1	0.000710	false
SHOW TABLES LIKE 'extrafields'	1	0.000992	false
SHOW TABLES LIKE 'extrafields'	1	0.000996	false
SELECT (select group_concat(db_files.id ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = admin_menu_items.id and (master_object_class='Admin_MenuItem' and field='photos')) as photos_calculated, (select group_concat(db_files.name ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = admin_menu_items.id and (master_object_class='Admin_MenuItem' and field='document_files')) as document_files_calculated, (select group_concat(extrafields.id ORDER BY 1 SEPARATOR ', ') from extrafields where extrafields.object_id = admin_menu_items.id and (object_class='Admin_MenuItem')) as extrafields_calculated, admin_menu_items.* FROM admin_menu_items WHERE (admin_menu_items.id = '48') LIMIT 0, 1	1	0.000718	false
SHOW TABLES LIKE 'extrafields'	1	0.001075	false
SHOW TABLES LIKE 'extrafields'	1	0.001166	false
SELECT (select group_concat(db_files.id ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = admin_menu_items.id and (master_object_class='Admin_MenuItem' and field='photos')) as photos_calculated, (select group_concat(db_files.name ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = admin_menu_items.id and (master_object_class='Admin_MenuItem' and field='document_files')) as document_files_calculated, (select group_concat(extrafields.id ORDER BY 1 SEPARATOR ', ') from extrafields where extrafields.object_id = admin_menu_items.id and (object_class='Admin_MenuItem')) as extrafields_calculated, admin_menu_items.* FROM admin_menu_items WHERE (admin_menu_items.id = '60') LIMIT 0, 1	1	0.000723	false
SHOW TABLES LIKE 'extrafields'	1	0.001075	false
SHOW TABLES LIKE 'extrafields'	1	0.001110	false
SELECT (select group_concat(db_files.id ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = admin_menu_items.id and (master_object_class='Admin_MenuItem' and field='photos')) as photos_calculated, (select group_concat(db_files.name ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = admin_menu_items.id and (master_object_class='Admin_MenuItem' and field='document_files')) as document_files_calculated, (select group_concat(extrafields.id ORDER BY 1 SEPARATOR ', ') from extrafields where extrafields.object_id = admin_menu_items.id and (object_class='Admin_MenuItem')) as extrafields_calculated, admin_menu_items.* FROM admin_menu_items WHERE (admin_menu_items.id = '60') LIMIT 0, 1	1	0.000740	false
SHOW TABLES LIKE 'extrafields'	1	0.001065	false
SHOW TABLES LIKE 'extrafields'	1	0.001016	false
SELECT (select group_concat(db_files.id ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = admin_menu_items.id and (master_object_class='Admin_MenuItem' and field='photos')) as photos_calculated, (select group_concat(db_files.name ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = admin_menu_items.id and (master_object_class='Admin_MenuItem' and field='document_files')) as document_files_calculated, (select group_concat(extrafields.id ORDER BY 1 SEPARATOR ', ') from extrafields where extrafields.object_id = admin_menu_items.id and (object_class='Admin_MenuItem')) as extrafields_calculated, admin_menu_items.* FROM admin_menu_items WHERE (admin_menu_items.id = '61') LIMIT 0, 1	1	0.000919	false
SHOW TABLES LIKE 'extrafields'	1	0.001010	false
SHOW TABLES LIKE 'extrafields'	1	0.001024	false
SELECT (select group_concat(db_files.id ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = admin_menu_items.id and (master_object_class='Admin_MenuItem' and field='photos')) as photos_calculated, (select group_concat(db_files.name ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = admin_menu_items.id and (master_object_class='Admin_MenuItem' and field='document_files')) as document_files_calculated, (select group_concat(extrafields.id ORDER BY 1 SEPARATOR ', ') from extrafields where extrafields.object_id = admin_menu_items.id and (object_class='Admin_MenuItem')) as extrafields_calculated, admin_menu_items.* FROM admin_menu_items WHERE (admin_menu_items.id = '61') LIMIT 0, 1	1	0.000970	false
SHOW TABLES LIKE 'extrafields'	1	0.001045	false
SHOW TABLES LIKE 'extrafields'	1	0.000974	false
SELECT (select group_concat(db_files.id ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = admin_menu_items.id and (master_object_class='Admin_MenuItem' and field='photos')) as photos_calculated, (select group_concat(db_files.name ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = admin_menu_items.id and (master_object_class='Admin_MenuItem' and field='document_files')) as document_files_calculated, (select group_concat(extrafields.id ORDER BY 1 SEPARATOR ', ') from extrafields where extrafields.object_id = admin_menu_items.id and (object_class='Admin_MenuItem')) as extrafields_calculated, admin_menu_items.* FROM admin_menu_items WHERE (admin_menu_items.id = '102') LIMIT 0, 1	1	0.000695	false
SHOW TABLES LIKE 'extrafields'	1	0.001030	false
SHOW TABLES LIKE 'extrafields'	1	0.000956	false
SELECT (select group_concat(db_files.id ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = admin_menu_items.id and (master_object_class='Admin_MenuItem' and field='photos')) as photos_calculated, (select group_concat(db_files.name ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = admin_menu_items.id and (master_object_class='Admin_MenuItem' and field='document_files')) as document_files_calculated, (select group_concat(extrafields.id ORDER BY 1 SEPARATOR ', ') from extrafields where extrafields.object_id = admin_menu_items.id and (object_class='Admin_MenuItem')) as extrafields_calculated, admin_menu_items.* FROM admin_menu_items WHERE (admin_menu_items.id = '102') LIMIT 0, 1	1	0.000958	false
SHOW TABLES LIKE 'extrafields'	1	0.001097	false
SHOW TABLES LIKE 'extrafields'	1	0.001145	false
SELECT (select group_concat(db_files.id ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = admin_menu_items.id and (master_object_class='Admin_MenuItem' and field='photos')) as photos_calculated, (select group_concat(db_files.name ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = admin_menu_items.id and (master_object_class='Admin_MenuItem' and field='document_files')) as document_files_calculated, (select group_concat(extrafields.id ORDER BY 1 SEPARATOR ', ') from extrafields where extrafields.object_id = admin_menu_items.id and (object_class='Admin_MenuItem')) as extrafields_calculated, admin_menu_items.* FROM admin_menu_items WHERE (admin_menu_items.id = '133') LIMIT 0, 1	1	0.000755	false
SHOW TABLES LIKE 'extrafields'	1	0.001076	false
SHOW TABLES LIKE 'extrafields'	1	0.000983	false
SELECT (select group_concat(db_files.id ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = admin_menu_items.id and (master_object_class='Admin_MenuItem' and field='photos')) as photos_calculated, (select group_concat(db_files.name ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = admin_menu_items.id and (master_object_class='Admin_MenuItem' and field='document_files')) as document_files_calculated, (select group_concat(extrafields.id ORDER BY 1 SEPARATOR ', ') from extrafields where extrafields.object_id = admin_menu_items.id and (object_class='Admin_MenuItem')) as extrafields_calculated, admin_menu_items.* FROM admin_menu_items WHERE (admin_menu_items.id = '133') LIMIT 0, 1	1	0.000715	false
SHOW TABLES LIKE 'extrafields'	1	0.001084	false
SHOW TABLES LIKE 'extrafields'	1	0.001224	false
SELECT (select group_concat(extrafields.id ORDER BY 1 SEPARATOR ', ') from extrafields where extrafields.object_id = admin_menus.id and (object_class='Admin_Menu')) as extrafields_calculated, admin_menus.* FROM admin_menus WHERE (admin_menus.code = 'main') LIMIT 0, 1	1	0.000538	false
SHOW TABLES LIKE 'extrafields'	1	0.001490	false
SHOW TABLES LIKE 'extrafields'	1	0.001100	false
SELECT (select group_concat(db_files.id ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = admin_menu_items.id and (master_object_class='Admin_MenuItem' and field='photos')) as photos_calculated, (select group_concat(db_files.name ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = admin_menu_items.id and (master_object_class='Admin_MenuItem' and field='document_files')) as document_files_calculated, (select group_concat(extrafields.id ORDER BY 1 SEPARATOR ', ') from extrafields where extrafields.object_id = admin_menu_items.id and (object_class='Admin_MenuItem')) as extrafields_calculated, admin_menu_items.* FROM admin_menu_items WHERE (admin_menu_items.menu_id = '1') AND (admin_menu_items.parent_id is null and (admin_menu_items.is_hidden is null or admin_menu_items.is_hidden=0) and (admin_menu_items.is_hidden_in_menu is null or admin_menu_items.is_hidden_in_menu=0)) ORDER BY group_name, sort_order	7	0.002129	false
SHOW TABLES LIKE 'extrafields'	1	0.001127	false
SHOW TABLES LIKE 'extrafields'	1	0.001164	false
SHOW TABLES LIKE 'extrafields'	1	0.000978	false
SHOW TABLES LIKE 'extrafields'	1	0.001116	false
SHOW TABLES LIKE 'extrafields'	1	0.001053	false
SHOW TABLES LIKE 'extrafields'	1	0.000948	false
SHOW TABLES LIKE 'extrafields'	1	0.001322	false