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

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

Query	Rows	Time	Cached
SET SESSION sql_mode = ''	-	0.000096	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	114	0.004976	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', '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')	381	0.001665	false
SELECT * FROM playbills_categories	3	0.000613	false
SELECT * FROM playbills_events as events WHERE (event_date >= '2022-10-01' OR event_end_date >= '2022-10-01' OR (event_end_date is null AND is_permanent = 1)) AND (event_date <= '2022-10-31' OR event_end_date <= '2022-10-31' OR (event_end_date is null AND is_permanent = 1)) ORDER BY event_date, event_times	0	0.000450	false
SELECT * FROM playbills_events as events WHERE (event_date >= '2022-10-04' OR event_end_date >= '2022-10-04' OR (event_end_date is null AND is_permanent = 1)) AND (event_date <= '2022-10-04' OR event_end_date <= '2022-10-04' OR (event_end_date is null AND is_permanent = 1)) ORDER BY event_date, event_times	0	0.000402	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.000233	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.000278	false
SHOW TABLES LIKE 'extrafields'	1	0.001651	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.000784	false
SHOW TABLES LIKE 'extrafields'	1	0.001601	false
update seo_settings set individual_seo_settings = 'a:0:{}'	-	0.000268	false
SHOW TABLES LIKE 'extrafields'	1	0.001374	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.000970	false
SHOW TABLES LIKE 'extrafields'	1	0.001873	false
SHOW TABLES LIKE 'extrafields'	1	0.001779	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.000858	false
SHOW TABLES LIKE 'extrafields'	1	0.001961	false
SHOW TABLES LIKE 'extrafields'	1	0.001830	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.002889	false
SHOW TABLES LIKE 'extrafields'	1	0.001807	false
SHOW TABLES LIKE 'extrafields'	1	0.001567	false
SHOW TABLES LIKE 'extrafields'	1	0.001333	false
SHOW TABLES LIKE 'extrafields'	1	0.001281	false
SHOW TABLES LIKE 'extrafields'	1	0.001499	false
SHOW TABLES LIKE 'extrafields'	1	0.001432	false
SHOW TABLES LIKE 'extrafields'	1	0.001505	false
SELECT admin_menu_items.* FROM admin_menu_items ORDER BY sort_order	114	0.000759	false
SHOW TABLES LIKE 'extrafields'	1	0.001950	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.000883	false
SHOW TABLES LIKE 'extrafields'	1	0.001503	false
SHOW TABLES LIKE 'extrafields'	1	0.001218	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.001112	false
SHOW TABLES LIKE 'extrafields'	1	0.002079	false
SHOW TABLES LIKE 'extrafields'	1	0.001685	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.001366	false
SHOW TABLES LIKE 'extrafields'	1	0.001972	false
SHOW TABLES LIKE 'extrafields'	1	0.001815	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.001146	false
SHOW TABLES LIKE 'extrafields'	1	0.005415	false
SHOW TABLES LIKE 'extrafields'	1	0.002124	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.001469	false
SHOW TABLES LIKE 'extrafields'	1	0.001699	false
SHOW TABLES LIKE 'extrafields'	1	0.002089	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.001307	false
SHOW TABLES LIKE 'extrafields'	1	0.001962	false
SHOW TABLES LIKE 'extrafields'	1	0.001573	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.001252	false
SHOW TABLES LIKE 'extrafields'	1	0.001157	false
SHOW TABLES LIKE 'extrafields'	1	0.001116	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.000836	false
SHOW TABLES LIKE 'extrafields'	1	0.001162	false
SHOW TABLES LIKE 'extrafields'	1	0.001237	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.001136	false
SHOW TABLES LIKE 'extrafields'	1	0.001102	false
SHOW TABLES LIKE 'extrafields'	1	0.001150	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.000825	false
SHOW TABLES LIKE 'extrafields'	1	0.001058	false
SHOW TABLES LIKE 'extrafields'	1	0.001051	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.000850	false
SHOW TABLES LIKE 'extrafields'	1	0.001099	false
SHOW TABLES LIKE 'extrafields'	1	0.001130	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.000838	false
SHOW TABLES LIKE 'extrafields'	1	0.001118	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 = '47') LIMIT 0, 1	1	0.000822	false
SHOW TABLES LIKE 'extrafields'	1	0.001085	false
SHOW TABLES LIKE 'extrafields'	1	0.001141	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.000776	false
SHOW TABLES LIKE 'extrafields'	1	0.001169	false
SHOW TABLES LIKE 'extrafields'	1	0.001087	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.000686	false
SHOW TABLES LIKE 'extrafields'	1	0.001284	false
SHOW TABLES LIKE 'extrafields'	1	0.001010	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.000732	false
SHOW TABLES LIKE 'extrafields'	1	0.001262	false
SHOW TABLES LIKE 'extrafields'	1	0.001147	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.000820	false
SHOW TABLES LIKE 'extrafields'	1	0.001449	false
SHOW TABLES LIKE 'extrafields'	1	0.001175	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.000882	false
SHOW TABLES LIKE 'extrafields'	1	0.001434	false
SHOW TABLES LIKE 'extrafields'	1	0.001085	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.000782	false
SHOW TABLES LIKE 'extrafields'	1	0.001328	false
SHOW TABLES LIKE 'extrafields'	1	0.001059	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.001259	false
SHOW TABLES LIKE 'extrafields'	1	0.001080	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.000757	false
SHOW TABLES LIKE 'extrafields'	1	0.001349	false
SHOW TABLES LIKE 'extrafields'	1	0.001220	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.000569	false
SHOW TABLES LIKE 'extrafields'	1	0.001151	false
SHOW TABLES LIKE 'extrafields'	1	0.001285	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.002258	false
SHOW TABLES LIKE 'extrafields'	1	0.001171	false
SHOW TABLES LIKE 'extrafields'	1	0.001154	false
SHOW TABLES LIKE 'extrafields'	1	0.001339	false
SHOW TABLES LIKE 'extrafields'	1	0.001245	false
SHOW TABLES LIKE 'extrafields'	1	0.001264	false
SHOW TABLES LIKE 'extrafields'	1	0.001055	false
SHOW TABLES LIKE 'extrafields'	1	0.001039	false