КАРТОТЕКА МД AFC-07

В наличии

61 880p

шт. Добавить

Описание
Характеристики

Предназначены для систематизации и удобного хранения документации

изделия сертифицированы на соответствие требованиям ГОСТ 16371-93

телескопические направляющие выдвижных ящиков

система полного выдвижения ящиков

надежность подтверждена промышленным испытанием 50000 открываний, при нагрузке на ящик 30 кг

оборудованы антиопрокидывающим устройством, не позволяющим одновременно выдвигать более чем один ящик

комплектуются центральным замком ПРАКТИК (2000 комбинаций), с возможностью смены цилиндра и мастер-ключом

габариты ящиков рассчитаны для хранения подвесных папок формата А4 или Foolscap

поставляются в разобранном виде

Размеры внешние, мм (ВхШхГ):	1327x515x631
Вес, кг:	71
Количество ящиков:	7
Внутренние размеры ящика, мм (ВхШхГ):	168х433х581
Формат документов:	A5
Максимальная нагрузка на ящик, кг:	20
Вместимость:	7000 карточек
Цвет:	Серый полуматовый (RAL 7038)
Тип покрытия:	Порошковое

Query	Rows	Time	Cached
SET SESSION sql_mode = ''	-	0.000032	false
SELECT seo_settings.* FROM seo_settings ORDER BY id desc LIMIT 0, 1	1	0.000741	false
update seo_settings set individual_seo_settings = 'a:0:{}'	-	0.000271	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.deleted is null) AND (catalog_products.hidden is null) AND (catalog_products.id = '2434') OR (catalog_products.deleted <> 1) AND (catalog_products.hidden is null) AND (catalog_products.id = '2434') LIMIT 0, 1	1	0.002797	false
select * from catalog_attribute_values where product_id = '2434'	0	0.000419	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 = '24') LIMIT 0, 1	1	0.001198	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_products_alt_categories ON catalog_categories.id = catalog_products_alt_categories.category_id LEFT JOIN catalog_product_types as product_type_calculated_join ON product_type_calculated_join.id = catalog_categories.type_id WHERE (catalog_products_alt_categories.product_id = '2434')	0	0.000888	false
SELECT catalog_categories.* FROM catalog_categories ORDER BY sort_order	214	0.002858	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 = '22') LIMIT 0, 1	1	0.001277	false
SELECT db_files.* FROM db_files WHERE (db_files.master_object_id = '2434') AND (db_files.master_object_class='Catalog_Product' and field='photos') ORDER BY sort_order	1	0.000620	false
SELECT (colour_calculated_join.name) as colour_calculated, mebel_relations.* FROM mebel_relations LEFT JOIN mebel_colours as colour_calculated_join ON colour_calculated_join.id = mebel_relations.colour_id WHERE (mebel_relations.object_id = '2434')	0	0.000650	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.000628	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.000677	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.000458	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.000415	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_mail') LIMIT 0, 1	1	0.000538	false
SELECT admin_menus.* FROM admin_menus WHERE (admin_menus.code = 'main') LIMIT 0, 1	1	0.000802	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.000692	false
SELECT admin_menu_items.* FROM admin_menu_items ORDER BY sort_order	25	0.000536	false
SELECT admin_menus.* FROM admin_menus WHERE (admin_menus.id = '1') LIMIT 0, 1	1	0.000296	false
select count(*) from shop_carts where cart_id = '2135efa2804905505ff06e911d4e6979ef55e7065ed8991042e6aa402f5907d092532dd3b9bc978c080489cdc1d9d85aa4d326a3057507a999dbd96b2f03ef43'	1	0.000405	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.000415	false
SELECT shop_carts.* FROM shop_carts WHERE (shop_carts.cart_id = '2135efa2804905505ff06e911d4e6979ef55e7065ed8991042e6aa402f5907d092532dd3b9bc978c080489cdc1d9d85aa4d326a3057507a999dbd96b2f03ef43') LIMIT 0, 1	0	0.000289	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.000431	false
select id, is_recommended, name from catalog_categories where parent_id = 62 and hidden is null order by sort_order asc	2	0.000450	false
select id, is_recommended, name from catalog_categories where parent_id = 1 and hidden is null order by sort_order asc	5	0.000380	false
select id, is_recommended, name from catalog_categories where parent_id = 21 and hidden is null order by sort_order asc	6	0.000263	false
select id, is_recommended, name from catalog_categories where parent_id = 4 and hidden is null order by sort_order asc	8	0.000292	false
select id, is_recommended, name from catalog_categories where parent_id = 22 and hidden is null order by sort_order asc	7	0.000299	false
select id, is_recommended, name from catalog_categories where parent_id = 16 and hidden is null order by sort_order asc	8	0.000321	false
select id, is_recommended, name from catalog_categories where parent_id = 8 and hidden is null order by sort_order asc	4	0.000316	false
select id, is_recommended, name from catalog_categories where parent_id = 135 and hidden is null order by sort_order asc	9	0.000442	false
select id, is_recommended, name from catalog_categories where parent_id = 232 and hidden is null order by sort_order asc	0	0.000284	false
select id, is_recommended, name from catalog_categories where parent_id = 14 and hidden is null order by sort_order asc	0	0.000315	false
select id, is_recommended, name from catalog_categories where parent_id = 63 and hidden is null order by sort_order asc	3	0.000238	false
select id, is_recommended, name from catalog_categories where parent_id = 65 and hidden is null order by sort_order asc	11	0.000800	false
select id, is_recommended, name from catalog_categories where parent_id = 203 and hidden is null order by sort_order asc	0	0.000330	false
SELECT * FROM banners_categories WHERE code = 'sidebar_banners'	1	0.000471	false
SELECT max(id) as id FROM banners WHERE category_id = '2' AND enabled = 1 GROUP BY position	1	0.000795	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.001035	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.000843	false
update banners set impression_number = impression_number+1 where id in ('12')	-	0.000279	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.000533	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.000379	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.000591	false

Query

Rows

Time

Cached

SET SESSION sql_mode = ''

0.000032

false

SELECT seo_settings.* FROM seo_settings ORDER BY id desc LIMIT 0, 1

0.000741

false

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

0.000271

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.deleted is null) AND (catalog_products.hidden is null) AND (catalog_products.id = '2434') OR (catalog_products.deleted <> 1) AND (catalog_products.hidden is null) AND (catalog_products.id = '2434') LIMIT 0, 1

0.002797

false

select * from catalog_attribute_values where product_id = '2434'

0.000419

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 = '24') LIMIT 0, 1

0.001198

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_products_alt_categories ON catalog_categories.id = catalog_products_alt_categories.category_id LEFT JOIN catalog_product_types as product_type_calculated_join ON product_type_calculated_join.id = catalog_categories.type_id WHERE (catalog_products_alt_categories.product_id = '2434')

0.000888

false

SELECT catalog_categories.* FROM catalog_categories ORDER BY sort_order

214

0.002858

false

0.001277

false

SELECT db_files.* FROM db_files WHERE (db_files.master_object_id = '2434') AND (db_files.master_object_class='Catalog_Product' and field='photos') ORDER BY sort_order

0.000620

false

SELECT (colour_calculated_join.name) as colour_calculated, mebel_relations.* FROM mebel_relations LEFT JOIN mebel_colours as colour_calculated_join ON colour_calculated_join.id = mebel_relations.colour_id WHERE (mebel_relations.object_id = '2434')

0.000650

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

0.000628

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

0.000677

false

0.000458

false

0.000415

false

0.000538

false

SELECT admin_menus.* FROM admin_menus WHERE (admin_menus.code = 'main') LIMIT 0, 1

0.000802

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

0.000692

false

SELECT admin_menu_items.* FROM admin_menu_items ORDER BY sort_order

0.000536

false

SELECT admin_menus.* FROM admin_menus WHERE (admin_menus.id = '1') LIMIT 0, 1

0.000296

false

select count(*) from shop_carts where cart_id = '2135efa2804905505ff06e911d4e6979ef55e7065ed8991042e6aa402f5907d092532dd3b9bc978c080489cdc1d9d85aa4d326a3057507a999dbd96b2f03ef43'

0.000405

false

0.000415

false

SELECT shop_carts.* FROM shop_carts WHERE (shop_carts.cart_id = '2135efa2804905505ff06e911d4e6979ef55e7065ed8991042e6aa402f5907d092532dd3b9bc978c080489cdc1d9d85aa4d326a3057507a999dbd96b2f03ef43') LIMIT 0, 1

0.000289

false

select id, is_recommended, name from catalog_categories where parent_id is null and hidden is null order by sort_order asc

0.000431

false

select id, is_recommended, name from catalog_categories where parent_id = 62 and hidden is null order by sort_order asc

0.000450

false

select id, is_recommended, name from catalog_categories where parent_id = 1 and hidden is null order by sort_order asc

0.000380

false

select id, is_recommended, name from catalog_categories where parent_id = 21 and hidden is null order by sort_order asc

0.000263

false

select id, is_recommended, name from catalog_categories where parent_id = 4 and hidden is null order by sort_order asc

0.000292

false

select id, is_recommended, name from catalog_categories where parent_id = 22 and hidden is null order by sort_order asc

0.000299

false

select id, is_recommended, name from catalog_categories where parent_id = 16 and hidden is null order by sort_order asc

0.000321

false

select id, is_recommended, name from catalog_categories where parent_id = 8 and hidden is null order by sort_order asc

0.000316

false

select id, is_recommended, name from catalog_categories where parent_id = 135 and hidden is null order by sort_order asc

0.000442

false

select id, is_recommended, name from catalog_categories where parent_id = 232 and hidden is null order by sort_order asc

0.000284

false

select id, is_recommended, name from catalog_categories where parent_id = 14 and hidden is null order by sort_order asc

0.000315

false

select id, is_recommended, name from catalog_categories where parent_id = 63 and hidden is null order by sort_order asc

0.000238

false

select id, is_recommended, name from catalog_categories where parent_id = 65 and hidden is null order by sort_order asc

0.000800

false

select id, is_recommended, name from catalog_categories where parent_id = 203 and hidden is null order by sort_order asc

0.000330

false

SELECT * FROM banners_categories WHERE code = 'sidebar_banners'

0.000471

false

SELECT max(id) as id FROM banners WHERE category_id = '2' AND enabled = 1 GROUP BY position

0.000795

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

0.001035

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) ))

0.000843

false

update banners set impression_number = impression_number+1 where id in ('12')

0.000279

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

0.000533

false

0.000379

false

0.000591

false

Контакты

КАРТОТЕКА МД AFC-07

Контакты