| SET SESSION sql_mode = '' |
- |
0.000047 |
false |
| SELECT
seo_settings.*
FROM seo_settings
ORDER BY
id desc
LIMIT 0, 1 |
1 |
0.000356 |
false |
| update seo_settings set individual_seo_settings = 'a:0:{}' |
- |
0.000155 |
false |
| SELECT
(select group_concat(db_files.name ORDER BY 1 SEPARATOR ', ') from db_files where
db_files.master_object_id = catalog_categories.id and (master_object_class='Catalog_Category' and field='image')) as image_calculated, (product_type_calculated_join.name) as product_type_calculated, (select group_concat(catalog_attributes.name ORDER BY 1 SEPARATOR ', ') from catalog_attributes, catalog_category_filters where
catalog_attributes.id=catalog_category_filters.attribute_id and
catalog_category_filters.category_id=catalog_categories.id) as filters_calculated, (select group_concat(mebel_relations.id ORDER BY 1 SEPARATOR ', ') from mebel_relations where
mebel_relations.object_id = catalog_categories.id) as colours_calculated, (select group_concat(db_files.id ORDER BY 1 SEPARATOR ', ') from db_files where
db_files.master_object_id = catalog_categories.id and (master_object_class='Catalog_Category' and field='photos')) as photos_calculated, catalog_categories.*
FROM catalog_categories
LEFT JOIN catalog_product_types as product_type_calculated_join ON product_type_calculated_join.id = catalog_categories.type_id
WHERE
(catalog_categories.id = '150')
LIMIT 0, 1 |
1 |
0.001470 |
false |
| SELECT product_id, category_id FROM catalog_products_alt_categories WHERE category_id='150' ORDER BY product_id ASC |
0 |
0.000362 |
false |
| SELECT
count(DISTINCT catalog_products.id)
FROM catalog_products
LEFT JOIN catalog_products_alt_categories ON catalog_products_alt_categories.product_id = catalog_products.id
LEFT JOIN catalog_categories as category_calculated_join ON category_calculated_join.id = catalog_products.category_id
LEFT JOIN catalog_product_types as type_calculated_join ON type_calculated_join.id = catalog_products.type_id
WHERE
(catalog_products.category_id = '150') AND (catalog_products.hidden is null) AND (catalog_products.deleted is null) OR (catalog_products_alt_categories.category_id = '150') AND (catalog_products.hidden is null) AND (catalog_products.deleted is null) |
1 |
0.009459 |
false |
| SELECT
catalog_products_alt_categories.category_id as alt_category_id, (select min(price) from catalog_skus where product_id=catalog_products.id) as min_price, (select max(price) from catalog_skus where product_id=catalog_products.id) as max_price, (select group_concat(db_files.name ORDER BY 1 SEPARATOR ', ') from db_files where
db_files.master_object_id = catalog_products.id and (master_object_class='Catalog_Product' and field='photos')) as photos_calculated, (category_calculated_join.name) as category_calculated, (type_calculated_join.name) as type_calculated, (select group_concat(catalog_skus.name ORDER BY 1 SEPARATOR ', ') from catalog_skus where
catalog_skus.product_id = catalog_products.id) as skus_calculated, (select group_concat(mebel_relations.id ORDER BY 1 SEPARATOR ', ') from mebel_relations where
mebel_relations.object_id = catalog_products.id) as colours_calculated, (select group_concat(catalog_categories.name ORDER BY 1 SEPARATOR ', ') from catalog_categories, catalog_products_alt_categories where
catalog_categories.id=catalog_products_alt_categories.category_id and
catalog_products_alt_categories.product_id=catalog_products.id) as alt_categories_calculated, catalog_products.*
FROM catalog_products
LEFT JOIN catalog_products_alt_categories ON catalog_products_alt_categories.product_id = catalog_products.id
LEFT JOIN catalog_categories as category_calculated_join ON category_calculated_join.id = catalog_products.category_id
LEFT JOIN catalog_product_types as type_calculated_join ON type_calculated_join.id = catalog_products.type_id
WHERE
(catalog_products.category_id = '150') AND (catalog_products.hidden is null) AND (catalog_products.deleted is null) OR (catalog_products_alt_categories.category_id = '150') AND (catalog_products.hidden is null) AND (catalog_products.deleted is null)
GROUP BY
catalog_products.id
ORDER BY
CASE WHEN catalog_products.category_id = 150 THEN 0 ELSE 1 END, sort_order asc
LIMIT 0, 28 |
28 |
0.022614 |
false |
| select * from catalog_attribute_values where product_id = '1358' |
0 |
0.000524 |
false |
| select * from catalog_attribute_values where product_id = '1359' |
0 |
0.000232 |
false |
| select * from catalog_attribute_values where product_id = '1360' |
0 |
0.000173 |
false |
| select * from catalog_attribute_values where product_id = '1361' |
0 |
0.000166 |
false |
| select * from catalog_attribute_values where product_id = '1363' |
0 |
0.000164 |
false |
| select * from catalog_attribute_values where product_id = '1367' |
0 |
0.000160 |
false |
| select * from catalog_attribute_values where product_id = '1368' |
0 |
0.000171 |
false |
| select * from catalog_attribute_values where product_id = '1369' |
0 |
0.000157 |
false |
| select * from catalog_attribute_values where product_id = '1370' |
0 |
0.000179 |
false |
| select * from catalog_attribute_values where product_id = '1371' |
0 |
0.000181 |
false |
| select * from catalog_attribute_values where product_id = '1372' |
0 |
0.000171 |
false |
| select * from catalog_attribute_values where product_id = '1373' |
0 |
0.000170 |
false |
| select * from catalog_attribute_values where product_id = '1374' |
0 |
0.000175 |
false |
| select * from catalog_attribute_values where product_id = '1375' |
0 |
0.000206 |
false |
| select * from catalog_attribute_values where product_id = '1376' |
0 |
0.000161 |
false |
| select * from catalog_attribute_values where product_id = '1364' |
0 |
0.000161 |
false |
| select * from catalog_attribute_values where product_id = '1377' |
0 |
0.000176 |
false |
| select * from catalog_attribute_values where product_id = '1378' |
0 |
0.000158 |
false |
| select * from catalog_attribute_values where product_id = '1379' |
0 |
0.000174 |
false |
| select * from catalog_attribute_values where product_id = '1380' |
0 |
0.000192 |
false |
| select * from catalog_attribute_values where product_id = '1382' |
0 |
0.000158 |
false |
| select * from catalog_attribute_values where product_id = '1383' |
0 |
0.000159 |
false |
| select * from catalog_attribute_values where product_id = '1384' |
0 |
0.000158 |
false |
| select * from catalog_attribute_values where product_id = '1386' |
0 |
0.000179 |
false |
| select * from catalog_attribute_values where product_id = '1387' |
0 |
0.000159 |
false |
| select * from catalog_attribute_values where product_id = '1388' |
0 |
0.000167 |
false |
| select * from catalog_attribute_values where product_id = '1389' |
0 |
0.000158 |
false |
| select * from catalog_attribute_values where product_id = '1390' |
0 |
0.000159 |
false |
| SELECT id, name
FROM catalog_categories
WHERE hidden IS NULL AND parent_id = 147 ORDER BY sort_order ASC |
9 |
0.000356 |
false |
| SELECT
(select min(price) from catalog_skus where product_id=catalog_products.id) as min_price, (select max(price) from catalog_skus where product_id=catalog_products.id) as max_price, (select group_concat(db_files.name ORDER BY 1 SEPARATOR ', ') from db_files where
db_files.master_object_id = catalog_products.id and (master_object_class='Catalog_Product' and field='photos')) as photos_calculated, (category_calculated_join.name) as category_calculated, (type_calculated_join.name) as type_calculated, (select group_concat(catalog_skus.name ORDER BY 1 SEPARATOR ', ') from catalog_skus where
catalog_skus.product_id = catalog_products.id) as skus_calculated, (select group_concat(mebel_relations.id ORDER BY 1 SEPARATOR ', ') from mebel_relations where
mebel_relations.object_id = catalog_products.id) as colours_calculated, (select group_concat(catalog_categories.name ORDER BY 1 SEPARATOR ', ') from catalog_categories, catalog_products_alt_categories where
catalog_categories.id=catalog_products_alt_categories.category_id and
catalog_products_alt_categories.product_id=catalog_products.id) as alt_categories_calculated, catalog_products.*
FROM catalog_products
LEFT JOIN catalog_categories as category_calculated_join ON category_calculated_join.id = catalog_products.category_id
LEFT JOIN catalog_product_types as type_calculated_join ON type_calculated_join.id = catalog_products.type_id
WHERE
(catalog_products.sell_out = 1) AND (catalog_products.hidden is null) AND (catalog_products.deleted is null) |
6 |
0.012581 |
false |
| SELECT
catalog_categories.*
FROM catalog_categories
ORDER BY
sort_order |
208 |
0.002102 |
false |
| SELECT
(select group_concat(db_files.name ORDER BY 1 SEPARATOR ', ') from db_files where
db_files.master_object_id = catalog_categories.id and (master_object_class='Catalog_Category' and field='image')) as image_calculated, (product_type_calculated_join.name) as product_type_calculated, (select group_concat(catalog_attributes.name ORDER BY 1 SEPARATOR ', ') from catalog_attributes, catalog_category_filters where
catalog_attributes.id=catalog_category_filters.attribute_id and
catalog_category_filters.category_id=catalog_categories.id) as filters_calculated, (select group_concat(mebel_relations.id ORDER BY 1 SEPARATOR ', ') from mebel_relations where
mebel_relations.object_id = catalog_categories.id) as colours_calculated, (select group_concat(db_files.id ORDER BY 1 SEPARATOR ', ') from db_files where
db_files.master_object_id = catalog_categories.id and (master_object_class='Catalog_Category' and field='photos')) as photos_calculated, catalog_categories.*
FROM catalog_categories
LEFT JOIN catalog_product_types as product_type_calculated_join ON product_type_calculated_join.id = catalog_categories.type_id
WHERE
(catalog_categories.id = '21')
LIMIT 0, 1 |
1 |
0.001150 |
false |
| SELECT
(select group_concat(db_files.name ORDER BY 1 SEPARATOR ', ') from db_files where
db_files.master_object_id = catalog_categories.id and (master_object_class='Catalog_Category' and field='image')) as image_calculated, (product_type_calculated_join.name) as product_type_calculated, (select group_concat(catalog_attributes.name ORDER BY 1 SEPARATOR ', ') from catalog_attributes, catalog_category_filters where
catalog_attributes.id=catalog_category_filters.attribute_id and
catalog_category_filters.category_id=catalog_categories.id) as filters_calculated, (select group_concat(mebel_relations.id ORDER BY 1 SEPARATOR ', ') from mebel_relations where
mebel_relations.object_id = catalog_categories.id) as colours_calculated, (select group_concat(db_files.id ORDER BY 1 SEPARATOR ', ') from db_files where
db_files.master_object_id = catalog_categories.id and (master_object_class='Catalog_Category' and field='photos')) as photos_calculated, catalog_categories.*
FROM catalog_categories
LEFT JOIN catalog_product_types as product_type_calculated_join ON product_type_calculated_join.id = catalog_categories.type_id
WHERE
(catalog_categories.id = '147')
LIMIT 0, 1 |
1 |
0.000906 |
false |
| SELECT
(select group_concat(db_files.name ORDER BY 1 SEPARATOR ', ') from db_files where
db_files.master_object_id = catalog_categories.id and (master_object_class='Catalog_Category' and field='image')) as image_calculated, (product_type_calculated_join.name) as product_type_calculated, (select group_concat(catalog_attributes.name ORDER BY 1 SEPARATOR ', ') from catalog_attributes, catalog_category_filters where
catalog_attributes.id=catalog_category_filters.attribute_id and
catalog_category_filters.category_id=catalog_categories.id) as filters_calculated, (select group_concat(mebel_relations.id ORDER BY 1 SEPARATOR ', ') from mebel_relations where
mebel_relations.object_id = catalog_categories.id) as colours_calculated, (select group_concat(db_files.id ORDER BY 1 SEPARATOR ', ') from db_files where
db_files.master_object_id = catalog_categories.id and (master_object_class='Catalog_Category' and field='photos')) as photos_calculated, catalog_categories.*
FROM catalog_categories
LEFT JOIN catalog_product_types as product_type_calculated_join ON product_type_calculated_join.id = catalog_categories.type_id
WHERE
(catalog_categories.id = '150')
LIMIT 0, 1 |
1 |
0.000753 |
false |
| SELECT
db_files.*
FROM db_files
WHERE
(db_files.master_object_id = '1358') AND (db_files.master_object_class='Catalog_Product' and field='photos')
ORDER BY
sort_order |
1 |
0.000402 |
false |
| SELECT
db_files.*
FROM db_files
WHERE
(db_files.master_object_id = '1359') AND (db_files.master_object_class='Catalog_Product' and field='photos')
ORDER BY
sort_order |
1 |
0.000331 |
false |
| SELECT
db_files.*
FROM db_files
WHERE
(db_files.master_object_id = '1360') AND (db_files.master_object_class='Catalog_Product' and field='photos')
ORDER BY
sort_order |
1 |
0.000360 |
false |
| SELECT
db_files.*
FROM db_files
WHERE
(db_files.master_object_id = '1361') AND (db_files.master_object_class='Catalog_Product' and field='photos')
ORDER BY
sort_order |
1 |
0.000307 |
false |
| SELECT
db_files.*
FROM db_files
WHERE
(db_files.master_object_id = '1363') AND (db_files.master_object_class='Catalog_Product' and field='photos')
ORDER BY
sort_order |
1 |
0.000294 |
false |
| SELECT
db_files.*
FROM db_files
WHERE
(db_files.master_object_id = '1367') AND (db_files.master_object_class='Catalog_Product' and field='photos')
ORDER BY
sort_order |
1 |
0.000293 |
false |
| SELECT
db_files.*
FROM db_files
WHERE
(db_files.master_object_id = '1368') AND (db_files.master_object_class='Catalog_Product' and field='photos')
ORDER BY
sort_order |
1 |
0.000313 |
false |
| SELECT
db_files.*
FROM db_files
WHERE
(db_files.master_object_id = '1369') AND (db_files.master_object_class='Catalog_Product' and field='photos')
ORDER BY
sort_order |
1 |
0.000301 |
false |
| SELECT
db_files.*
FROM db_files
WHERE
(db_files.master_object_id = '1370') AND (db_files.master_object_class='Catalog_Product' and field='photos')
ORDER BY
sort_order |
1 |
0.000282 |
false |
| SELECT
db_files.*
FROM db_files
WHERE
(db_files.master_object_id = '1371') AND (db_files.master_object_class='Catalog_Product' and field='photos')
ORDER BY
sort_order |
2 |
0.000309 |
false |
| SELECT
db_files.*
FROM db_files
WHERE
(db_files.master_object_id = '1372') AND (db_files.master_object_class='Catalog_Product' and field='photos')
ORDER BY
sort_order |
1 |
0.000289 |
false |
| SELECT
db_files.*
FROM db_files
WHERE
(db_files.master_object_id = '1373') AND (db_files.master_object_class='Catalog_Product' and field='photos')
ORDER BY
sort_order |
1 |
0.000292 |
false |
| SELECT
db_files.*
FROM db_files
WHERE
(db_files.master_object_id = '1374') AND (db_files.master_object_class='Catalog_Product' and field='photos')
ORDER BY
sort_order |
1 |
0.000323 |
false |
| SELECT
db_files.*
FROM db_files
WHERE
(db_files.master_object_id = '1375') AND (db_files.master_object_class='Catalog_Product' and field='photos')
ORDER BY
sort_order |
1 |
0.000291 |
false |
| SELECT
db_files.*
FROM db_files
WHERE
(db_files.master_object_id = '1376') AND (db_files.master_object_class='Catalog_Product' and field='photos')
ORDER BY
sort_order |
1 |
0.000315 |
false |
| SELECT
db_files.*
FROM db_files
WHERE
(db_files.master_object_id = '1364') AND (db_files.master_object_class='Catalog_Product' and field='photos')
ORDER BY
sort_order |
1 |
0.000296 |
false |
| SELECT
db_files.*
FROM db_files
WHERE
(db_files.master_object_id = '1377') AND (db_files.master_object_class='Catalog_Product' and field='photos')
ORDER BY
sort_order |
4 |
0.000478 |
false |
| SELECT
db_files.*
FROM db_files
WHERE
(db_files.master_object_id = '1378') AND (db_files.master_object_class='Catalog_Product' and field='photos')
ORDER BY
sort_order |
1 |
0.000291 |
false |
| SELECT
db_files.*
FROM db_files
WHERE
(db_files.master_object_id = '1379') AND (db_files.master_object_class='Catalog_Product' and field='photos')
ORDER BY
sort_order |
2 |
0.000309 |
false |
| SELECT
db_files.*
FROM db_files
WHERE
(db_files.master_object_id = '1380') AND (db_files.master_object_class='Catalog_Product' and field='photos')
ORDER BY
sort_order |
2 |
0.000259 |
false |
| SELECT
db_files.*
FROM db_files
WHERE
(db_files.master_object_id = '1382') AND (db_files.master_object_class='Catalog_Product' and field='photos')
ORDER BY
sort_order |
2 |
0.000286 |
false |
| SELECT
db_files.*
FROM db_files
WHERE
(db_files.master_object_id = '1383') AND (db_files.master_object_class='Catalog_Product' and field='photos')
ORDER BY
sort_order |
2 |
0.000274 |
false |
| SELECT
db_files.*
FROM db_files
WHERE
(db_files.master_object_id = '1384') AND (db_files.master_object_class='Catalog_Product' and field='photos')
ORDER BY
sort_order |
2 |
0.000308 |
false |
| SELECT
db_files.*
FROM db_files
WHERE
(db_files.master_object_id = '1386') AND (db_files.master_object_class='Catalog_Product' and field='photos')
ORDER BY
sort_order |
2 |
0.000275 |
false |
| SELECT
db_files.*
FROM db_files
WHERE
(db_files.master_object_id = '1387') AND (db_files.master_object_class='Catalog_Product' and field='photos')
ORDER BY
sort_order |
1 |
0.000256 |
false |
| SELECT
db_files.*
FROM db_files
WHERE
(db_files.master_object_id = '1388') AND (db_files.master_object_class='Catalog_Product' and field='photos')
ORDER BY
sort_order |
2 |
0.000269 |
false |
| SELECT
db_files.*
FROM db_files
WHERE
(db_files.master_object_id = '1389') AND (db_files.master_object_class='Catalog_Product' and field='photos')
ORDER BY
sort_order |
2 |
0.000252 |
false |
| SELECT
db_files.*
FROM db_files
WHERE
(db_files.master_object_id = '1390') AND (db_files.master_object_class='Catalog_Product' and field='photos')
ORDER BY
sort_order |
2 |
0.000269 |
false |
| SELECT
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.000330 |
false |
| SELECT
(menu_link_calculated_join.title) as menu_link_calculated, admin_text_blocks.*
FROM admin_text_blocks
LEFT JOIN admin_menu_items as menu_link_calculated_join ON menu_link_calculated_join.text_block_id = admin_text_blocks.id
WHERE
(admin_text_blocks.code = 'header_wa')
LIMIT 0, 1 |
1 |
0.000464 |
false |
| SELECT
(menu_link_calculated_join.title) as menu_link_calculated, admin_text_blocks.*
FROM admin_text_blocks
LEFT JOIN admin_menu_items as menu_link_calculated_join ON menu_link_calculated_join.text_block_id = admin_text_blocks.id
WHERE
(admin_text_blocks.code = 'header_address')
LIMIT 0, 1 |
1 |
0.000357 |
false |
| SELECT
(menu_link_calculated_join.title) as menu_link_calculated, admin_text_blocks.*
FROM admin_text_blocks
LEFT JOIN admin_menu_items as menu_link_calculated_join ON menu_link_calculated_join.text_block_id = admin_text_blocks.id
WHERE
(admin_text_blocks.code = 'header_tel')
LIMIT 0, 1 |
1 |
0.000232 |
false |
| SELECT
admin_menus.*
FROM admin_menus
WHERE
(admin_menus.code = 'main')
LIMIT 0, 1 |
1 |
0.000314 |
false |
| SELECT
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 |
6 |
0.000393 |
false |
| SELECT
admin_menu_items.*
FROM admin_menu_items
ORDER BY
sort_order |
24 |
0.000336 |
false |
| SELECT
admin_menus.*
FROM admin_menus
WHERE
(admin_menus.id = '1')
LIMIT 0, 1 |
1 |
0.000170 |
false |
| select count(*) from shop_carts where cart_id = '2606dc087d89e0f6e7fb00b445582ae3a9e642ab7a7052f7db7d9e5b40885f46fe3cc156ed3695fdec8931a1685601fa2ac5e266089d89cc7afcb3f908a51f4c' |
1 |
0.000401 |
false |
| SELECT
(menu_link_calculated_join.title) as menu_link_calculated, admin_text_blocks.*
FROM admin_text_blocks
LEFT JOIN admin_menu_items as menu_link_calculated_join ON menu_link_calculated_join.text_block_id = admin_text_blocks.id
WHERE
(admin_text_blocks.code = 'header_tel_mobile')
LIMIT 0, 1 |
1 |
0.000250 |
false |
| SELECT
shop_carts.*
FROM shop_carts
WHERE
(shop_carts.cart_id = '2606dc087d89e0f6e7fb00b445582ae3a9e642ab7a7052f7db7d9e5b40885f46fe3cc156ed3695fdec8931a1685601fa2ac5e266089d89cc7afcb3f908a51f4c')
LIMIT 0, 1 |
0 |
0.000170 |
false |
| select id, is_recommended, name
from catalog_categories
where parent_id is null and hidden is null
order by sort_order asc |
13 |
0.000263 |
false |
| select id, is_recommended, name
from catalog_categories
where parent_id = 1 and hidden is null
order by sort_order asc |
5 |
0.000235 |
false |
| select id, is_recommended, name
from catalog_categories
where parent_id = 21 and hidden is null
order by sort_order asc |
6 |
0.000187 |
false |
| select id, is_recommended, name
from catalog_categories
where parent_id = 4 and hidden is null
order by sort_order asc |
9 |
0.000261 |
false |
| select id, is_recommended, name
from catalog_categories
where parent_id = 22 and hidden is null
order by sort_order asc |
7 |
0.000172 |
false |
| select id, is_recommended, name
from catalog_categories
where parent_id = 16 and hidden is null
order by sort_order asc |
8 |
0.000149 |
false |
| select id, is_recommended, name
from catalog_categories
where parent_id = 8 and hidden is null
order by sort_order asc |
4 |
0.000163 |
false |
| select id, is_recommended, name
from catalog_categories
where parent_id = 135 and hidden is null
order by sort_order asc |
8 |
0.000140 |
false |
| select id, is_recommended, name
from catalog_categories
where parent_id = 232 and hidden is null
order by sort_order asc |
0 |
0.000108 |
false |
| select id, is_recommended, name
from catalog_categories
where parent_id = 14 and hidden is null
order by sort_order asc |
0 |
0.000157 |
false |
| select id, is_recommended, name
from catalog_categories
where parent_id = 63 and hidden is null
order by sort_order asc |
3 |
0.000116 |
false |
| select id, is_recommended, name
from catalog_categories
where parent_id = 65 and hidden is null
order by sort_order asc |
11 |
0.000191 |
false |
| select id, is_recommended, name
from catalog_categories
where parent_id = 62 and hidden is null
order by sort_order asc |
0 |
0.000119 |
false |
| select id, is_recommended, name
from catalog_categories
where parent_id = 203 and hidden is null
order by sort_order asc |
0 |
0.000111 |
false |
| SELECT * FROM banners_categories WHERE code = 'sidebar_banners' |
1 |
0.000291 |
false |
| SELECT max(id) as id
FROM banners
WHERE category_id = '2' AND enabled = 1
GROUP BY position |
1 |
0.000347 |
false |
| SELECT
(DATEDIFF(CURRENT_DATE(), date_enabled)) as days_enabled, (category_calculated_join.name) as category_calculated, (select group_concat(db_files.name ORDER BY 1 SEPARATOR ', ') from db_files where
db_files.master_object_id = banners.id and (master_object_class='Banners_Banner' and field='image')) as image_calculated, (select group_concat(db_files.name ORDER BY 1 SEPARATOR ', ') from db_files where
db_files.master_object_id = banners.id and (master_object_class='Banners_Banner' and field='flash_file')) as flash_file_calculated, banners.*
FROM banners
LEFT JOIN banners_categories as category_calculated_join ON category_calculated_join.id = banners.category_id
WHERE
(banners.id IN ('12'))
ORDER BY
banners.sort_order DESC, banners.id |
1 |
0.000684 |
false |
| SELECT
(DATEDIFF(CURRENT_DATE(), date_enabled)) as days_enabled, (category_calculated_join.name) as category_calculated, (select group_concat(db_files.name ORDER BY 1 SEPARATOR ', ') from db_files where
db_files.master_object_id = banners.id and (master_object_class='Banners_Banner' and field='image')) as image_calculated, (select group_concat(db_files.name ORDER BY 1 SEPARATOR ', ') from db_files where
db_files.master_object_id = banners.id and (master_object_class='Banners_Banner' and field='flash_file')) as flash_file_calculated, banners.*
FROM banners
LEFT JOIN banners_categories as category_calculated_join ON category_calculated_join.id = banners.category_id
WHERE
(banners.position='12') AND ((
exposure_limit_type is NULL or
exposure_limit_type = 0 or
(exposure_limit_type = 1 and period_start >= CURRENT_DATE() and period_end <= CURRENT_DATE()) or
(exposure_limit_type = 2 and hits_left > 0)
)) |
1 |
0.000592 |
false |
| update banners set impression_number = impression_number+1 where id in ('12') |
- |
0.000191 |
false |
| SELECT
db_files.*
FROM db_files
WHERE
(db_files.master_object_id = '12') AND (db_files.master_object_class='Banners_Banner' and field='image')
ORDER BY
id |
1 |
0.000259 |
false |
| SELECT
(menu_link_calculated_join.title) as menu_link_calculated, admin_text_blocks.*
FROM admin_text_blocks
LEFT JOIN admin_menu_items as menu_link_calculated_join ON menu_link_calculated_join.text_block_id = admin_text_blocks.id
WHERE
(admin_text_blocks.code = 'footer_address')
LIMIT 0, 1 |
1 |
0.000242 |
false |
| SELECT
(menu_link_calculated_join.title) as menu_link_calculated, admin_text_blocks.*
FROM admin_text_blocks
LEFT JOIN admin_menu_items as menu_link_calculated_join ON menu_link_calculated_join.text_block_id = admin_text_blocks.id
WHERE
(admin_text_blocks.code = 'footer_address')
LIMIT 0, 1 |
1 |
0.000283 |
false |
