| Queries | Time | Rows |
| SELECT * FROM wb_structures LEFT JOIN wb_meta ON wb_structures.structure_id = wb_meta.table_col_value WHERE wb_structures.structure_path IN ('/catalog/vitriny/68/index', '/catalog/vitriny/68', '/catalog/vitriny', '/catalog', '/') AND wb_structures.structure_scope = 'ru' AND wb_meta.table = 'structures' AND wb_meta.table_col = 'structure_id' ORDER BY LENGTH(wb_structures.structure_path) DESC LIMIT 0,1 | 0.002 | 1 |
SELECT * FROM (`wb_settings`) ORDER BY `wb_settings`.`setting_id` DESC | 0.000 | 10 |
SELECT `wb_users`.*, `wb_users_roles`.* FROM (`wb_users_roles`) LEFT JOIN `wb_users` ON (`wb_users`.`role_id` = `wb_users_roles`.`role_id`) WHERE `wb_users_roles`.`role_name` = 'guest' | 0.000 | 1 |
SELECT `wb_users_roles_permissions`.`permission_name` FROM (`wb_users_roles_permissions`) WHERE `wb_users_roles_permissions`.`role_id` = '2' | 0.000 | 18 |
SELECT `wb_users_roles`.`role_name`, `wb_users_roles_permissions`.`permission_name` FROM (`wb_users_roles`) LEFT JOIN `wb_users_roles_permissions` ON (`wb_users_roles_permissions`.`role_id` = `wb_users_roles`.`role_id`) ORDER BY `wb_users_roles`.`role_id` ASC | 0.000 | 45 |
SELECT `A`.`structure_lkey`, `A`.`structure_rkey`, `A`.`structure_level`
FROM (`wb_structures` AS `A`, `wb_structures` AS `B`) WHERE `B`.`structure_id` = 120
AND `B`.`structure_lkey` BETWEEN `A`.`structure_lkey` AND `A`.`structure_rkey`
ORDER BY `A`.`structure_lkey` ASC | 0.000 | 3 |
SELECT *
FROM `wb_structures`
LEFT JOIN `wb_meta` ON (`wb_meta`.`table_col_value` = `wb_structures`.`structure_id`)
WHERE (`structure_level` = 2 OR (`structure_level` = 2 AND `structure_lkey` > 1 AND `structure_rkey` < 36) OR (`structure_level` = 3 AND `structure_lkey` > 8 AND `structure_rkey` < 23) OR (`structure_level` = 4 AND `structure_lkey` > 17 AND `structure_rkey` < 18))
AND `wb_meta`.`table_col` = 'structure_id'
AND `wb_structures`.`structure_level` >= '3'
ORDER BY `structure_level` ASC | 0.001 | 7 |
SELECT `wb_users`.*, `wb_users_roles`.* FROM (`wb_users_roles`) LEFT JOIN `wb_users` ON (`wb_users`.`role_id` = `wb_users_roles`.`role_id`) WHERE `wb_users_roles`.`role_name` = 'guest' | 0.000 | 1 |
SELECT `wb_users_roles_permissions`.`permission_name` FROM (`wb_users_roles_permissions`) WHERE `wb_users_roles_permissions`.`role_id` = '2' | 0.000 | 18 |
SELECT `wb_structures`.*, `wb_meta`.* FROM (`wb_structures`) LEFT JOIN `wb_meta` ON (`wb_meta`.`table_col_value` = `wb_structures`.`structure_id`) WHERE `wb_structures`.`structure_id` = '120' AND `wb_meta`.`table` = 'structures' AND `wb_meta`.`table_col` = 'structure_id' | 0.001 | 1 |
SELECT * FROM (`wb_structures`) LEFT JOIN `wb_meta` ON (`wb_meta`.`table_col_value` = `wb_structures`.`structure_id`) WHERE `wb_meta`.`table` = 'structures' AND `wb_meta`.`table_col` = 'structure_id' AND structure_lkey <= 17 AND structure_rkey >= 18 AND `structure_scope` = 'ru' AND `structure_level` >= 1 | 0.001 | 3 |
SELECT * FROM (`wb_settings`) ORDER BY `wb_settings`.`setting_id` DESC | 0.000 | 10 |
SELECT * FROM (`wb_catalog_categories`) LEFT JOIN `wb_structures` ON (`wb_structures`.`structure_id` = `wb_catalog_categories`.`structure_id`) LEFT JOIN `wb_meta` ON (`wb_structures`.`structure_id` = `wb_meta`.`table_col_value`) WHERE `wb_structures`.`structure_id` IN (120) AND `wb_meta`.`table` = 'structures' AND `wb_meta`.`table_col` = 'structure_id' | 0.001 | 1 |
SELECT `wb_structures`.*, `wb_meta`.* FROM (`wb_structures`) LEFT JOIN `wb_meta` ON (`wb_meta`.`table_col_value` = `wb_structures`.`structure_id`) WHERE `wb_structures`.`structure_id` = '120' AND `wb_meta`.`table` = 'structures' AND `wb_meta`.`table_col` = 'structure_id' | 0.000 | 1 |
SELECT `wb_structures`.* FROM (`wb_structures`) WHERE structure_lkey > 17 AND structure_rkey < 18 AND `wb_structures`.`structure_level` >= 4 AND `wb_structures`.`structure_level` <= 4 AND `structure_scope` = 'ru' AND `structure_id` IN (109,110,111,112,113,115,116,117,118,119,120,121,122,123,124,125,114,126) ORDER BY `wb_structures`.`structure_lkey` ASC | 0.000 | 0 |
SELECT * FROM (`wb_catalog_items`) LEFT JOIN `wb_structures` ON (`wb_structures`.`structure_id` = `wb_catalog_items`.`item_scope`) LEFT JOIN `wb_catalog_categories` ON (`wb_structures`.`structure_id` = `wb_catalog_categories`.`structure_id`) LEFT JOIN `wb_users` ON (`wb_catalog_items`.`user_id` = `wb_users`.`user_id`) LEFT JOIN `wb_meta` ON (`wb_catalog_items`.`item_id` = `wb_meta`.`table_col_value`) WHERE `wb_catalog_items`.`item_id` IN (68) AND `wb_structures`.`structure_id` IN (120) AND `wb_meta`.`table` = 'catalog_items' AND `wb_meta`.`table_col` = 'item_id' | 0.001 | 1 |
SELECT COUNT(*) FROM (`wb_gallery`) WHERE `gallery_scope` = 'catalog_items:item_id:68' AND `gallery_lkey` > 1 | 0.000 | 1 |
SELECT * FROM (`wb_gallery`) WHERE `gallery_scope` = 'catalog_items:item_id:68' AND `gallery_lkey` > 1 ORDER BY `wb_gallery`.`gallery_lkey` ASC LIMIT 0, 1000000 | 0.000 | 0 |
| Total: 18 | 0.008 | 122 |
| Template vars | Value |
| builder_global_data | Array
(
[submenu] => Array
(
[0] => Array
(
[structure_id] => 118
[structure_parent_id] => 110
[structure_level] => 3
[structure_lkey] => 11
[structure_rkey] => 12
[structure_scope] => ru
[structure_link] => banners
[structure_path] => /catalog/banners
[structure_module] => catalog
[structure_template_filename] => frontend
[structure_template] => catalog
[structure_data] =>
[structure_settings] => a:3:{s:19:"categories_per_page";s:1:"5";s:14:"items_per_page";s:1:"5";s:19:"use_parent_settings";s:1:"1";}
[structure_active] => 1
[meta_id] => 163
[table] => structures
[table_col] => structure_id
[table_col_value] => 118
[meta_page_title] =>
[meta_caption] => Баннерные стенды
[meta_title] => Баннерные стенды
[meta_hint] => Баннерные стенды
[meta_keywords] =>
[meta_description] =>
)
[1] => Array
(
[structure_id] => 119
[structure_parent_id] => 110
[structure_level] => 3
[structure_lkey] => 15
[structure_rkey] => 16
[structure_scope] => ru
[structure_link] => bukletnicy
[structure_path] => /catalog/bukletnicy
[structure_module] => catalog
[structure_template_filename] => frontend
[structure_template] => catalog
[structure_data] =>
[structure_settings] => a:3:{s:19:"categories_per_page";s:1:"5";s:14:"items_per_page";s:1:"5";s:19:"use_parent_settings";s:1:"1";}
[structure_active] => 1
[meta_id] => 164
[table] => structures
[table_col] => structure_id
[table_col_value] => 119
[meta_page_title] =>
[meta_caption] => Буклетницы
[meta_title] => Буклетницы
[meta_hint] => Буклетницы
[meta_keywords] =>
[meta_description] =>
)
[2] => Array
(
[structure_id] => 120
[structure_parent_id] => 110
[structure_level] => 3
[structure_lkey] => 17
[structure_rkey] => 18
[structure_scope] => ru
[structure_link] => vitriny
[structure_path] => /catalog/vitriny
[structure_module] => catalog
[structure_template_filename] => frontend
[structure_template] => catalog
[structure_data] =>
[structure_settings] => a:3:{s:19:"categories_per_page";s:1:"5";s:14:"items_per_page";s:1:"5";s:19:"use_parent_settings";s:1:"1";}
[structure_active] => 1
[meta_id] => 165
[table] => structures
[table_col] => structure_id
[table_col_value] => 120
[meta_page_title] =>
[meta_caption] => Витрины
[meta_title] => Витрины
[meta_hint] => Витрины
[meta_keywords] =>
[meta_description] =>
)
[3] => Array
(
[structure_id] => 121
[structure_parent_id] => 110
[structure_level] => 3
[structure_lkey] => 13
[structure_rkey] => 14
[structure_scope] => ru
[structure_link] => rollernye_stendy
[structure_path] => /catalog/rollernye_stendy
[structure_module] => catalog
[structure_template_filename] => frontend
[structure_template] => catalog
[structure_data] =>
[structure_settings] => a:3:{s:19:"categories_per_page";s:1:"5";s:14:"items_per_page";s:1:"5";s:19:"use_parent_settings";s:1:"1";}
[structure_active] => 1
[meta_id] => 166
[table] => structures
[table_col] => structure_id
[table_col_value] => 121
[meta_page_title] =>
[meta_caption] => Роллерные стенды
[meta_title] => Роллерные стенды
[meta_hint] => Роллерные стенды
[meta_keywords] =>
[meta_description] =>
)
[4] => Array
(
[structure_id] => 122
[structure_parent_id] => 110
[structure_level] => 3
[structure_lkey] => 21
[structure_rkey] => 22
[structure_scope] => ru
[structure_link] => svetovye_koroba
[structure_path] => /catalog/svetovye_koroba
[structure_module] => catalog
[structure_template_filename] => frontend
[structure_template] => catalog
[structure_data] =>
[structure_settings] => a:3:{s:19:"categories_per_page";s:1:"5";s:14:"items_per_page";s:1:"5";s:19:"use_parent_settings";s:1:"1";}
[structure_active] => 1
[meta_id] => 167
[table] => structures
[table_col] => structure_id
[table_col_value] => 122
[meta_page_title] =>
[meta_caption] => Световые короба
[meta_title] => Световые короба
[meta_hint] => Световые короба
[meta_keywords] =>
[meta_description] =>
)
[5] => Array
(
[structure_id] => 123
[structure_parent_id] => 110
[structure_level] => 3
[structure_lkey] => 19
[structure_rkey] => 20
[structure_scope] => ru
[structure_link] => stellazhi
[structure_path] => /catalog/stellazhi
[structure_module] => catalog
[structure_template_filename] => frontend
[structure_template] => catalog
[structure_data] =>
[structure_settings] => a:3:{s:19:"categories_per_page";s:1:"5";s:14:"items_per_page";s:1:"5";s:19:"use_parent_settings";s:1:"1";}
[structure_active] => 1
[meta_id] => 168
[table] => structures
[table_col] => structure_id
[table_col_value] => 123
[meta_page_title] =>
[meta_caption] => Стеллажи
[meta_title] => Стеллажи
[meta_hint] => Стеллажи
[meta_keywords] =>
[meta_description] =>
)
[6] => Array
(
[structure_id] => 126
[structure_parent_id] => 110
[structure_level] => 3
[structure_lkey] => 9
[structure_rkey] => 10
[structure_scope] => ru
[structure_link] => bolshie_stendy
[structure_path] => /catalog/bolshie_stendy
[structure_module] => catalog
[structure_template_filename] => frontend
[structure_template] => catalog
[structure_data] =>
[structure_settings] => a:3:{s:19:"categories_per_page";s:1:"5";s:14:"items_per_page";s:1:"5";s:19:"use_parent_settings";s:1:"1";}
[structure_active] => 1
[meta_id] => 190
[table] => structures
[table_col] => structure_id
[table_col_value] => 126
[meta_page_title] =>
[meta_caption] => Большие стенды
[meta_title] => Большие стенды
[meta_hint] => Большие стенды
[meta_keywords] =>
[meta_description] =>
)
)
[parents] => Array
(
[0] => Array
(
[structure_id] => 108
[structure_parent_id] => 0
[structure_level] => 1
[structure_lkey] => 1
[structure_rkey] => 36
[structure_scope] => ru
[structure_link] =>
[structure_path] =>
[structure_module] => info
[structure_template_filename] => frontend
[structure_template] => info
[structure_data] =>
[structure_settings] =>
[structure_active] => 1
[meta_id] => 145
[table] => structures
[table_col] => structure_id
[table_col_value] => 108
[meta_page_title] =>
[meta_caption] => Сайт
[meta_title] => Сайт
[meta_hint] => Сайт
[meta_keywords] =>
[meta_description] =>
)
[1] => Array
(
[structure_id] => 110
[structure_parent_id] => 108
[structure_level] => 2
[structure_lkey] => 8
[structure_rkey] => 23
[structure_scope] => ru
[structure_link] => catalog
[structure_path] => /catalog
[structure_module] => catalog
[structure_template_filename] => frontend
[structure_template] => catalog
[structure_data] =>
[structure_settings] => Array
(
[categories_per_page] => 5
[items_per_page] => 5
[use_parent_settings] => 0
)
[structure_active] => 1
[meta_id] => 147
[table] => structures
[table_col] => structure_id
[table_col_value] => 110
[meta_page_title] =>
[meta_caption] => Каталог продукции
[meta_title] => Каталог продукции
[meta_hint] => Каталог продукции
[meta_keywords] =>
[meta_description] =>
)
[2] => Array
(
[structure_id] => 120
[structure_parent_id] => 110
[structure_level] => 3
[structure_lkey] => 17
[structure_rkey] => 18
[structure_scope] => ru
[structure_link] => vitriny
[structure_path] => /catalog/vitriny
[structure_module] => catalog
[structure_template_filename] => frontend
[structure_template] => catalog
[structure_data] =>
[structure_settings] => Array
(
[categories_per_page] => 5
[items_per_page] => 5
[use_parent_settings] => 1
)
[structure_active] => 1
[meta_id] => 165
[table] => structures
[table_col] => structure_id
[table_col_value] => 120
[meta_page_title] =>
[meta_caption] => Витрины
[meta_title] => Витрины
[meta_hint] => Витрины
[meta_keywords] =>
[meta_description] =>
)
)
[caption] => ВИТРИНА КРУГЛАЯ ОТКРЫТАЯ
[page_title] =>
[keywords] =>
[description] =>
)
|
| builder_local_data | Array
(
[content] => View Object
(
[builder_filename:protected] => /var/www/vhosts/dekor-st.ru/httpdocs/builder/views/frontend/catalog.php
[builder_filetype:protected] => .php
[builder_local_data:protected] => Array
(
[category] => Array
(
[category_id] => 3
[structure_id] => 120
[category_photo] => H4xZklAI47rN8geZgEDcOvMnVhSes3H9WS2aceasSPluaqHxqspg6aW02bB6oD0J
[category_description] => Инструмент для демонстрации Вашей продукции, активный инструмент маркетинговой политики, способствующий продвижению предприятия на собственном рынке товаров и услуг.
[category_text] => <p>
Инструмент для демонстрации Вашей продукции, активный инструмент маркетинговой политики, способствующий продвижению предприятия на собственном рынке товаров и услуг. С помощью витрин вы можете оформить магазин, офис, стенд на выставке. Возможно изменение конфигураций и комплектации наших моделей в соответствии с Вашими пожеланиями и потребностями.</p>
[structure_parent_id] => 110
[structure_level] => 3
[structure_lkey] => 17
[structure_rkey] => 18
[structure_scope] => ru
[structure_link] => vitriny
[structure_path] => /catalog/vitriny
[structure_module] => catalog
[structure_template_filename] => frontend
[structure_template] => catalog
[structure_data] =>
[structure_settings] => a:3:{s:19:"categories_per_page";s:1:"5";s:14:"items_per_page";s:1:"5";s:19:"use_parent_settings";s:1:"1";}
[structure_active] => 1
[meta_id] => 165
[table] => structures
[table_col] => structure_id
[table_col_value] => 120
[meta_page_title] =>
[meta_caption] => Витрины
[meta_title] => Витрины
[meta_hint] => Витрины
[meta_keywords] =>
[meta_description] =>
)
[mode] => item
[item] => Array
(
[item_id] => 68
[user_id] => 2
[item_parent_id] => 63
[item_lkey] => 10
[item_rkey] => 11
[item_level] => 2
[item_scope] => 120
[item_photo] => MEqpgL2wVJGSupzRb8LVmuQR5nDNxB6aHazRQ6X16nKrxCJdoSjugtZA8GqzmrcA
[item_chars] =>
[item_text] =>
[item_description_1] => <p>
Комплектация:<br />
основание и фризовая часть из ДСП 16мм, полки из оргстекла 10мм 3шт., полки держатся на фланцах, фризовая часть, накопитель и центральная часть витрины закрыта Пэтом, опоры хромированные d=25mm., светильники, встроенные галогеновые 3 шт.<br />
На фризовую часть и на основание устанавливается фотопанель с помощью магнитной ленты.</p>
[item_description_2] => <p>
Диаметр: 62 см.<br />
Высота: 200 см.</p>
[item_description_3] =>
[structure_id] => 120
[structure_parent_id] => 110
[structure_level] => 3
[structure_lkey] => 17
[structure_rkey] => 18
[structure_scope] => ru
[structure_link] => vitriny
[structure_path] => /catalog/vitriny
[structure_module] => catalog
[structure_template_filename] => frontend
[structure_template] => catalog
[structure_data] =>
[structure_settings] => a:3:{s:19:"categories_per_page";s:1:"5";s:14:"items_per_page";s:1:"5";s:19:"use_parent_settings";s:1:"1";}
[structure_active] => 1
[category_id] => 3
[category_photo] => H4xZklAI47rN8geZgEDcOvMnVhSes3H9WS2aceasSPluaqHxqspg6aW02bB6oD0J
[category_description] => Инструмент для демонстрации Вашей продукции, активный инструмент маркетинговой политики, способствующий продвижению предприятия на собственном рынке товаров и услуг.
[category_text] => <p>
Инструмент для демонстрации Вашей продукции, активный инструмент маркетинговой политики, способствующий продвижению предприятия на собственном рынке товаров и услуг. С помощью витрин вы можете оформить магазин, офис, стенд на выставке. Возможно изменение конфигураций и комплектации наших моделей в соответствии с Вашими пожеланиями и потребностями.</p>
[role_id] => 1
[user_login] => admin
[user_email] => nikita@wbased.ru
[user_password] => 5f4dcc3b5aa765d61d8327deb882cf99
[user_confirm] =>
[user_active] => 2
[user_name] => Никита
[user_lastname] => Мосияш
[user_patronymic] => Игоревич
[user_data] =>
[user_confirmed] => 1
[meta_id] => 235
[table] => catalog_items
[table_col] => item_id
[table_col_value] => 68
[meta_page_title] =>
[meta_caption] => ВИТРИНА КРУГЛАЯ ОТКРЫТАЯ
[meta_title] => ВИТРИНА КРУГЛАЯ ОТКРЫТАЯ
[meta_hint] => ВИТРИНА КРУГЛАЯ ОТКРЫТАЯ
[meta_keywords] =>
[meta_description] =>
)
)
)
)
|