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

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

Query	Rows	Time	Cached
SET SESSION sql_mode = ''	-	0.000052	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.002734	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,001033	false
SELECT count(*) FROM photoalbums as posts WHERE id in ('3') ORDER BY posts.sort_order ASC LIMIT 1	1	0,000503	false
SELECT * FROM photoalbums as posts WHERE id in ('3') ORDER BY posts.sort_order DESC LIMIT 0, 1	1	0,000366	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 ('3') AND master_object_class = 'Photoalbum_Album' ORDER BY is_main, sort_order	1	0,000291	false
SELECT * FROM extrafields WHERE object_class = 'Photoalbum_Album' AND object_id in ('3')	1	0,000502	false
SHOW TABLES LIKE 'extrafields'	1	0,000452	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,000436	false
SHOW TABLES LIKE 'extrafields'	1	0,000243	false
update seo_settings set individual_seo_settings = 'a:0:{}'	-	0,000111	false
SHOW TABLES LIKE 'extrafields'	1	0,000220	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,000426	false
SHOW TABLES LIKE 'extrafields'	1	0,000204	false

Query

Rows

Time

Cached

SET SESSION sql_mode = ''

0.000052

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

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

false

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

0,000503

false

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

0,000366

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 ('3') AND master_object_class = 'Photoalbum_Album' ORDER BY is_main, sort_order

0,000291

false

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

0,000502

false

SHOW TABLES LIKE 'extrafields'

0,000452

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

false

SHOW TABLES LIKE 'extrafields'

0,000243

false

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

0,000111

false

SHOW TABLES LIKE 'extrafields'

0,000220

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

false

SHOW TABLES LIKE 'extrafields'

0,000204

false

День в нашей компании