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

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

Query	Rows	Time	Cached
SET SESSION sql_mode = ''	-	0.000110	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.003429	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')	390	0.001415	false
SELECT * FROM playbills_categories	3	0.000287	false
SELECT * FROM playbills_events as events WHERE (event_date >= '2035-04-01' OR event_end_date >= '2035-04-01' OR (event_end_date is null AND is_permanent = 1)) AND (event_date <= '2035-04-30' OR event_end_date <= '2035-04-30' OR (event_end_date is null AND is_permanent = 1)) ORDER BY event_date, event_times	0	0.000410	false
SELECT * FROM playbills_events as events WHERE (event_date >= '2035-04-03' OR event_end_date >= '2035-04-03' OR (event_end_date is null AND is_permanent = 1)) AND (event_date <= '2035-04-03' OR event_end_date <= '2035-04-03' OR (event_end_date is null AND is_permanent = 1)) ORDER BY event_date, event_times	0	0.000285	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.000176	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.000232	false
SHOW TABLES LIKE 'extrafields'	1	0.001592	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.000493	false
SHOW TABLES LIKE 'extrafields'	1	0.000903	false
update seo_settings set individual_seo_settings = 'a:0:{}'	-	0.000546	false
SHOW TABLES LIKE 'extrafields'	1	0.000997	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.000578	false
SHOW TABLES LIKE 'extrafields'	1	0.000956	false
SHOW TABLES LIKE 'extrafields'	1	0.001309	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.000967	false
SHOW TABLES LIKE 'extrafields'	1	0.001356	false
SHOW TABLES LIKE 'extrafields'	1	0.001006	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.001610	false
SHOW TABLES LIKE 'extrafields'	1	0.001030	false
SHOW TABLES LIKE 'extrafields'	1	0.001172	false
SHOW TABLES LIKE 'extrafields'	1	0.000850	false
SHOW TABLES LIKE 'extrafields'	1	0.000935	false
SHOW TABLES LIKE 'extrafields'	1	0.001042	false
SHOW TABLES LIKE 'extrafields'	1	0.000878	false
SHOW TABLES LIKE 'extrafields'	1	0.000958	false
SELECT admin_menu_items.* FROM admin_menu_items ORDER BY sort_order	114	0.000733	false
SHOW TABLES LIKE 'extrafields'	1	0.001230	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.000471	false
SHOW TABLES LIKE 'extrafields'	1	0.000812	false
SHOW TABLES LIKE 'extrafields'	1	0.000955	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.000612	false
SHOW TABLES LIKE 'extrafields'	1	0.000858	false
SHOW TABLES LIKE 'extrafields'	1	0.000990	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.000819	false
SHOW TABLES LIKE 'extrafields'	1	0.001118	false
SHOW TABLES LIKE 'extrafields'	1	0.001367	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.000701	false
SHOW TABLES LIKE 'extrafields'	1	0.001136	false
SHOW TABLES LIKE 'extrafields'	1	0.000970	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.000635	false
SHOW TABLES LIKE 'extrafields'	1	0.001163	false
SHOW TABLES LIKE 'extrafields'	1	0.000967	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.001098	false
SHOW TABLES LIKE 'extrafields'	1	0.000875	false
SHOW TABLES LIKE 'extrafields'	1	0.001030	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.000644	false
SHOW TABLES LIKE 'extrafields'	1	0.000993	false
SHOW TABLES LIKE 'extrafields'	1	0.001446	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.000611	false
SHOW TABLES LIKE 'extrafields'	1	0.001155	false
SHOW TABLES LIKE 'extrafields'	1	0.001077	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.000772	false
SHOW TABLES LIKE 'extrafields'	1	0.000978	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 = '40') LIMIT 0, 1	1	0.000954	false
SHOW TABLES LIKE 'extrafields'	1	0.000842	false
SHOW TABLES LIKE 'extrafields'	1	0.000990	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.000629	false
SHOW TABLES LIKE 'extrafields'	1	0.001055	false
SHOW TABLES LIKE 'extrafields'	1	0.000915	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.000923	false
SHOW TABLES LIKE 'extrafields'	1	0.000837	false
SHOW TABLES LIKE 'extrafields'	1	0.000796	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.000986	false
SHOW TABLES LIKE 'extrafields'	1	0.000874	false
SHOW TABLES LIKE 'extrafields'	1	0.001050	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.000667	false
SHOW TABLES LIKE 'extrafields'	1	0.001266	false
SHOW TABLES LIKE 'extrafields'	1	0.001261	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.000653	false
SHOW TABLES LIKE 'extrafields'	1	0.000865	false
SHOW TABLES LIKE 'extrafields'	1	0.000811	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.000577	false
SHOW TABLES LIKE 'extrafields'	1	0.000963	false
SHOW TABLES LIKE 'extrafields'	1	0.001099	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.000607	false
SHOW TABLES LIKE 'extrafields'	1	0.001258	false
SHOW TABLES LIKE 'extrafields'	1	0.000823	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.001021	false
SHOW TABLES LIKE 'extrafields'	1	0.000798	false
SHOW TABLES LIKE 'extrafields'	1	0.000943	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.000835	false
SHOW TABLES LIKE 'extrafields'	1	0.000901	false
SHOW TABLES LIKE 'extrafields'	1	0.001047	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.000645	false
SHOW TABLES LIKE 'extrafields'	1	0.001254	false
SHOW TABLES LIKE 'extrafields'	1	0.002603	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.001833	false
SHOW TABLES LIKE 'extrafields'	1	0.001960	false
SHOW TABLES LIKE 'extrafields'	1	0.001664	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.001670	false
SHOW TABLES LIKE 'extrafields'	1	0.001945	false
SHOW TABLES LIKE 'extrafields'	1	0.001649	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.002803	false
SHOW TABLES LIKE 'extrafields'	1	0.003864	false
SHOW TABLES LIKE 'extrafields'	1	0.002062	false
SHOW TABLES LIKE 'extrafields'	1	0.002374	false
SHOW TABLES LIKE 'extrafields'	1	0.002872	false
SHOW TABLES LIKE 'extrafields'	1	0.002596	false
SHOW TABLES LIKE 'extrafields'	1	0.002498	false
SHOW TABLES LIKE 'extrafields'	1	0.003088	false