АО "Транспортная компания"

Мы используем

Query	Rows	Time	Cached
SET SESSION sql_mode = ''	-	0.000049	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	50	0.002322	false
SELECT * FROM extrafields WHERE object_class = 'Admin_MenuItem' AND object_id in ('1', '3', '9', '10', '11', '17', '51', '18', '24', '25', '44', '33', '72', '38', '39', '40', '41', '42', '43', '26', '34', '48', '49', '52', '36', '37', '58', '59', '65', '61', '71', '64', '6', '7', '8', '12', '13', '19', '20', '21', '23', '50', '29', '30', '32', '35', '46', '70', '66', '67')	21	0,000647	false
SELECT count(*) FROM photoalbums as posts WHERE id in ('4') ORDER BY posts.sort_order ASC LIMIT 1	1	0,000408	false
SELECT * FROM photoalbums as posts WHERE id in ('4') ORDER BY posts.sort_order DESC LIMIT 0, 1	1	0,000166	false
SELECT id, disk_name as `path`, `description`, mime_type, master_object_id as parent_id, field FROM db_files as f WHERE master_object_id in ('4') AND master_object_class = 'Photoalbum_Album' ORDER BY is_main, sort_order	14	0,000522	false
SELECT * FROM extrafields WHERE object_class = 'Photoalbum_Album' AND object_id in ('4')	1	0,000497	false
SHOW TABLES LIKE 'extrafields'	1	0,000393	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,000446	false
SHOW TABLES LIKE 'extrafields'	1	0,000220	false
update seo_settings set individual_seo_settings = 'a:0:{}'	-	0,000125	false
SHOW TABLES LIKE 'extrafields'	1	0,000237	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,000504	false
SHOW TABLES LIKE 'extrafields'	1	0,000298	false

Query

Rows

Time

Cached

SET SESSION sql_mode = ''

0.000049

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

0.002322

false

SELECT * FROM extrafields WHERE object_class = 'Admin_MenuItem' AND object_id in ('1', '3', '9', '10', '11', '17', '51', '18', '24', '25', '44', '33', '72', '38', '39', '40', '41', '42', '43', '26', '34', '48', '49', '52', '36', '37', '58', '59', '65', '61', '71', '64', '6', '7', '8', '12', '13', '19', '20', '21', '23', '50', '29', '30', '32', '35', '46', '70', '66', '67')

0,000647

false

SELECT count(*) FROM photoalbums as posts WHERE id in ('4') ORDER BY posts.sort_order ASC LIMIT 1

0,000408

false

SELECT * FROM photoalbums as posts WHERE id in ('4') ORDER BY posts.sort_order DESC LIMIT 0, 1

0,000166

false

SELECT id, disk_name as `path`, `description`, mime_type, master_object_id as parent_id, field FROM db_files as f WHERE master_object_id in ('4') AND master_object_class = 'Photoalbum_Album' ORDER BY is_main, sort_order

0,000522

false

SELECT * FROM extrafields WHERE object_class = 'Photoalbum_Album' AND object_id in ('4')

0,000497

false

SHOW TABLES LIKE 'extrafields'

0,000393

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

0,000446

false

SHOW TABLES LIKE 'extrafields'

0,000220

false

update seo_settings set individual_seo_settings = 'a:0:{}'

0,000125

false

SHOW TABLES LIKE 'extrafields'

0,000237

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

0,000504

false

SHOW TABLES LIKE 'extrafields'

0,000298

false

Наш автопарк