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

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

Query	Rows	Time	Cached
SET SESSION sql_mode = ''	-	0.000055	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.001976	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,000545	false
SELECT count(*) FROM photoalbums as posts WHERE id in ('4') ORDER BY posts.sort_order ASC LIMIT 1	1	0,000312	false
SELECT * FROM photoalbums as posts WHERE id in ('4') ORDER BY posts.sort_order DESC LIMIT 0, 1	1	0,000129	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,001363	false
SELECT * FROM extrafields WHERE object_class = 'Photoalbum_Album' AND object_id in ('4')	1	0,001520	false
SHOW TABLES LIKE 'extrafields'	1	0,000315	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,000370	false
SHOW TABLES LIKE 'extrafields'	1	0,000205	false
update seo_settings set individual_seo_settings = 'a:0:{}'	-	0,001444	false
SHOW TABLES LIKE 'extrafields'	1	0,000246	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,000401	false
SHOW TABLES LIKE 'extrafields'	1	0,000186	false

Query

Rows

Time

Cached

SET SESSION sql_mode = ''

0.000055

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.001976

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,000545

false

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

0,000312

false

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

0,000129

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,001363

false

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

0,001520

false

SHOW TABLES LIKE 'extrafields'

0,000315

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,000370

false

SHOW TABLES LIKE 'extrafields'

0,000205

false

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

0,001444

false

SHOW TABLES LIKE 'extrafields'

0,000246

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,000401

false

SHOW TABLES LIKE 'extrafields'

0,000186

false

Наш автопарк