| SET SESSION sql_mode = '' |
- |
0.000089 |
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 |
23 |
0.002279 |
false |
| SELECT id, code FROM news_categories |
4 |
0.000392 |
false |
| SHOW TABLES LIKE 'extrafields' |
1 |
0.000494 |
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.001026 |
false |
| SHOW TABLES LIKE 'extrafields' |
1 |
0.000263 |
false |
| update seo_settings set individual_seo_settings = 'a:0:{}' |
- |
0.000143 |
false |
| SHOW TABLES LIKE 'extrafields' |
1 |
0.000258 |
false |
| SELECT
(news_categories.code) as category_code, (select group_concat(news_posts_versions.created_at ORDER BY 1 SEPARATOR ', ') from news_posts_versions where
news_posts_versions.post_id = news_posts.id) as versions_calculated, (select group_concat(extrafields.id ORDER BY 1 SEPARATOR ', ') from extrafields where
extrafields.object_id = news_posts.id and (object_class='News_Post')) as extrafields_calculated, (select group_concat(db_files.name ORDER BY 1 SEPARATOR ', ') from db_files where
db_files.master_object_id = news_posts.id and (master_object_class='News_Post' and field='document_files')) as document_files_calculated, (select group_concat(db_files.id ORDER BY 1 SEPARATOR ', ') from db_files where
db_files.master_object_id = news_posts.id and (master_object_class='News_Post' and field='photos')) as photos_calculated, news_posts.*
FROM news_posts
LEFT JOIN news_categories ON news_categories.id=news_posts.category_id
WHERE
(news_posts.id = '46')
LIMIT 0, 1 |
1 |
0.002318 |
false |
| SHOW TABLES LIKE 'extrafields' |
1 |
0.000275 |
false |
| select * from donations where master_object_id = '46' and master_object_class = 'News_Post' |
1 |
0.000616 |
false |
| SELECT * FROM extrafields WHERE object_class = 'News_Post' AND object_id in ('46') |
0 |
0.000306 |
false |
| SHOW TABLES LIKE 'extrafields' |
1 |
0.000304 |
false |
| SELECT
(select group_concat(db_files.name ORDER BY 1 SEPARATOR ', ') from db_files where
db_files.master_object_id = news_categories.id and (master_object_class='News_Category' and field='image')) as image_calculated, (select group_concat(extrafields.id ORDER BY 1 SEPARATOR ', ') from extrafields where
extrafields.object_id = news_categories.id and (object_class='News_Category')) as extrafields_calculated, news_categories.*
FROM news_categories
WHERE
(news_categories.id = '2')
LIMIT 0, 1 |
1 |
0.000547 |
false |
| SHOW TABLES LIKE 'extrafields' |
1 |
0.000260 |
false |
| SHOW TABLES LIKE 'extrafields' |
1 |
0.000257 |
false |
| SELECT
(news_categories.code) as category_code, (select group_concat(news_posts_versions.created_at ORDER BY 1 SEPARATOR ', ') from news_posts_versions where
news_posts_versions.post_id = news_posts.id) as versions_calculated, (select group_concat(extrafields.id ORDER BY 1 SEPARATOR ', ') from extrafields where
extrafields.object_id = news_posts.id and (object_class='News_Post')) as extrafields_calculated, (select group_concat(db_files.name ORDER BY 1 SEPARATOR ', ') from db_files where
db_files.master_object_id = news_posts.id and (master_object_class='News_Post' and field='document_files')) as document_files_calculated, (select group_concat(db_files.id ORDER BY 1 SEPARATOR ', ') from db_files where
db_files.master_object_id = news_posts.id and (master_object_class='News_Post' and field='photos')) as photos_calculated, news_posts.*
FROM news_posts
LEFT JOIN news_categories ON news_categories.id=news_posts.category_id
WHERE
(news_posts.published=1) AND (news_posts.publish_date <= '2025-04-06 21:13:46' or publish_date is null) AND (news_posts.is_important_news != 1 or is_important_news is null) AND (news_posts.category_id='2')
ORDER BY
publish_date desc |
12 |
0.003373 |
false |
| SHOW TABLES LIKE 'extrafields' |
1 |
0.000307 |
false |
| select * from donations where master_object_id = '49' and master_object_class = 'News_Post' |
1 |
0.000249 |
false |
| SHOW TABLES LIKE 'extrafields' |
1 |
0.000277 |
false |
| select * from donations where master_object_id = '48' and master_object_class = 'News_Post' |
1 |
0.000260 |
false |
| SHOW TABLES LIKE 'extrafields' |
1 |
0.000265 |
false |
| select * from donations where master_object_id = '47' and master_object_class = 'News_Post' |
1 |
0.000230 |
false |
| SHOW TABLES LIKE 'extrafields' |
1 |
0.000269 |
false |
| select * from donations where master_object_id = '46' and master_object_class = 'News_Post' |
1 |
0.000201 |
false |
| SHOW TABLES LIKE 'extrafields' |
1 |
0.000269 |
false |
| select * from donations where master_object_id = '45' and master_object_class = 'News_Post' |
1 |
0.000248 |
false |
| SHOW TABLES LIKE 'extrafields' |
1 |
0.000257 |
false |
| select * from donations where master_object_id = '44' and master_object_class = 'News_Post' |
1 |
0.000350 |
false |
| SHOW TABLES LIKE 'extrafields' |
1 |
0.000276 |
false |
| select * from donations where master_object_id = '43' and master_object_class = 'News_Post' |
1 |
0.000206 |
false |
| SHOW TABLES LIKE 'extrafields' |
1 |
0.000260 |
false |
| select * from donations where master_object_id = '42' and master_object_class = 'News_Post' |
1 |
0.000208 |
false |
| SHOW TABLES LIKE 'extrafields' |
1 |
0.000273 |
false |
| select * from donations where master_object_id = '13' and master_object_class = 'News_Post' |
1 |
0.000212 |
false |
| SHOW TABLES LIKE 'extrafields' |
1 |
0.000280 |
false |
| select * from donations where master_object_id = '12' and master_object_class = 'News_Post' |
1 |
0.002491 |
false |
| SHOW TABLES LIKE 'extrafields' |
1 |
0.000311 |
false |
| select * from donations where master_object_id = '11' and master_object_class = 'News_Post' |
1 |
0.000226 |
false |
| SHOW TABLES LIKE 'extrafields' |
1 |
0.000294 |
false |
| select * from donations where master_object_id = '10' and master_object_class = 'News_Post' |
1 |
0.000217 |
false |
| SHOW TABLES LIKE 'extrafields' |
1 |
0.000281 |
false |
| SELECT
(select group_concat(extrafields.id ORDER BY 1 SEPARATOR ', ') from extrafields where
extrafields.object_id = db_files.id and (object_class='Db_File')) as extrafields_calculated, db_files.*
FROM db_files
WHERE
(db_files.master_object_id = '46') AND (db_files.master_object_class='News_Post' and field='image')
ORDER BY
id |
1 |
0.000515 |
false |
| SHOW TABLES LIKE 'extrafields' |
1 |
0.000241 |
false |
| SHOW TABLES LIKE 'extrafields' |
1 |
0.000285 |
false |
| SELECT
(select group_concat(extrafields.id ORDER BY 1 SEPARATOR ', ') from extrafields where
extrafields.object_id = db_files.id and (object_class='Db_File')) as extrafields_calculated, db_files.*
FROM db_files
WHERE
(db_files.master_object_id = '46') AND (db_files.master_object_class='News_Post' and field='photos')
ORDER BY
sort_order |
0 |
0.000525 |
false |
| SHOW TABLES LIKE 'extrafields' |
1 |
0.000272 |
false |
| SELECT
(select group_concat(extrafields.id ORDER BY 1 SEPARATOR ', ') from extrafields where
extrafields.object_id = db_filecategories.id and (object_class='Db_FileCategory')) as extrafields_calculated, db_filecategories.*
FROM db_filecategories
WHERE
(db_filecategories.master_object_class='News_Post') AND (db_filecategories.master_object_id = '46') AND (EXISTS(SELECT * FROM db_files WHERE db_files.category_id = db_filecategories.id))
ORDER BY
sort_order |
1 |
0.000983 |
false |
| SHOW TABLES LIKE 'extrafields' |
1 |
0.000266 |
false |
| SHOW TABLES LIKE 'extrafields' |
1 |
0.000266 |
false |
| SELECT
(select group_concat(extrafields.id ORDER BY 1 SEPARATOR ', ') from extrafields where
extrafields.object_id = db_files.id and (object_class='Db_File')) as extrafields_calculated, db_files.*
FROM db_files
WHERE
(db_files.master_object_class='News_Post') AND (db_files.master_object_id='46') AND (db_files.field='document_files') AND (db_files.category_id='89')
ORDER BY
sort_order |
0 |
0.000525 |
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.000787 |
false |
| SHOW TABLES LIKE 'extrafields' |
1 |
0.000224 |
false |
| select id, title, amount from donations where enable is not null order by priority desc, id desc |
1 |
0.000297 |
false |
