Каталог товаров

Ibero

Сортировать по:
Фильтр
Быстрый заказ
Быстрый заказ
Быстрый заказ
Быстрый заказ
Быстрый заказ
Быстрый заказ
Быстрый заказ
Быстрый заказ
Быстрый заказ
Быстрый заказ
Быстрый заказ
100% гарантия качества
100% гарантия качества
14 дней на возврат товара
14 дней на возврат товара
Доставка по всей стране
Доставка по всей стране
Самовывоз из магазина
Самовывоз из магазина
1) 0.00039911270141602: perform SET NAMES 'utf8mb4' ------------------------------------------------------------------------------------------------------------------------------------------------------ 2) 0.00032496452331543: perform SET SESSION SQL_MODE = "ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION" ------------------------------------------------------------------------------------------------------------------------------------------------------ 3) 0.00043988227844238: perform SELECT * FROM `ok_languages` ORDER BY position ASC ------------------------------------------------------------------------------------------------------------------------------------------------------ 4) 0.00063300132751465: perform SELECT id, vendor, module_name, enabled FROM `ok_modules` ORDER BY position ASC ------------------------------------------------------------------------------------------------------------------------------------------------------ 5) 0.00093197822570801: perform SELECT param, value FROM `ok_settings` ------------------------------------------------------------------------------------------------------------------------------------------------------ 6) 0.00034403800964355: perform SELECT id FROM `ok_languages` WHERE id=0 LIMIT 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ 7) 0.00040817260742188: perform SELECT * FROM `ok_settings_lang` WHERE lang_id=:action_object_lang_id ------------------------------------------------------------------------------------------------------------------------------------------------------ 8) 0.00057101249694824: perform SELECT `c`.`id`, `c`.`parent_id`, `c`.`url`, `c`.`image`, `c`.`position`, `c`.`visible`, `c`.`external_id`, `c`.`level_depth`, `c`.`last_modify`, `c`.`created`, `r`.`slug_url`, `l`.`name`, `l`.`name_h1`, `l`.`meta_title`, `l`.`meta_keywords`, `l`.`meta_description`, `l`.`annotation`, `l`.`description` FROM `ok_blog_categories` AS `c` LEFT JOIN `ok_lang_blog_categories` AS `l` ON `l`.`category_id` = `c`.`id` AND `l`.`lang_id` = 1 LEFT JOIN `ok_router_cache` AS `r` ON `r`.`url`=`c`.`url` AND `r`.`type`="category" ORDER BY `c`.`parent_id`, `c`.`position` ------------------------------------------------------------------------------------------------------------------------------------------------------ 9) 0.00035595893859863: perform SELECT category_id FROM `ok_blog_categories_relation` GROUP BY category_id ------------------------------------------------------------------------------------------------------------------------------------------------------ 10) 0.00078701972961426: perform SELECT id, parent_id, url FROM `ok_blog_categories` WHERE url IN(:urls) ------------------------------------------------------------------------------------------------------------------------------------------------------ 11) 0.00028610229492188: perform SELECT DISTINCT SQL_CACHE `le`.`id`, `le`.`label`, `le`.`href_lang`, `le`.`enabled`, `le`.`position`, `l`.`name` FROM `ok_languages` AS `le` LEFT JOIN `ok_lang_languages` AS `l` ON `l`.`language_id` = `le`.`id` AND `l`.`lang_id` = 1 ORDER BY `le`.`position` ASC ------------------------------------------------------------------------------------------------------------------------------------------------------ 12) 0.00055694580078125: perform SELECT DISTINCT SQL_CACHE `m`.`vendor`, `m`.`module_name` FROM `ok_modules` AS `m` ORDER BY `m`.`position` DESC ------------------------------------------------------------------------------------------------------------------------------------------------------ 13) 0.0011441707611084: perform SELECT `p`.`id`, `p`.`url`, `p`.`visible`, `p`.`position`, `p`.`last_modify`, `l`.`name`, `l`.`name_h1`, `l`.`meta_title`, `l`.`meta_keywords`, `l`.`meta_description`, `l`.`description` FROM `ok_pages` AS `p` LEFT JOIN `ok_lang_pages` AS `l` ON `l`.`page_id` = `p`.`id` AND `l`.`lang_id` = 1 WHERE `p`.`url` = :magic_filter_url ORDER BY `p`.`position` ASC ------------------------------------------------------------------------------------------------------------------------------------------------------ 14) 0.00071811676025391: perform SELECT DISTINCT SQL_CACHE `c`.`id`, `c`.`code`, `c`.`rate_from`, `c`.`rate_to`, `c`.`cents`, `c`.`position`, `c`.`enabled`, `l`.`name`, `l`.`sign` FROM `ok_currencies` AS `c` LEFT JOIN `ok_lang_currencies` AS `l` ON `l`.`currency_id` = `c`.`id` AND `l`.`lang_id` = 1 ORDER BY `c`.`position` ------------------------------------------------------------------------------------------------------------------------------------------------------ 15) 0.00056004524230957: perform SELECT `p`.`id`, `p`.`url`, `p`.`visible`, `p`.`position`, `p`.`last_modify`, `l`.`name`, `l`.`name_h1`, `l`.`meta_title`, `l`.`meta_keywords`, `l`.`meta_description`, `l`.`description` FROM `ok_pages` AS `p` LEFT JOIN `ok_lang_pages` AS `l` ON `l`.`page_id` = `p`.`id` AND `l`.`lang_id` = 1 WHERE `p`.`url` = :magic_filter_url ORDER BY `p`.`position` ASC ------------------------------------------------------------------------------------------------------------------------------------------------------ 16) 0.00041794776916504: perform SELECT DISTINCT SQL_CACHE `c`.`id`, `c`.`code`, `c`.`rate_from`, `c`.`rate_to`, `c`.`cents`, `c`.`position`, `c`.`enabled`, `l`.`name`, `l`.`sign` FROM `ok_currencies` AS `c` LEFT JOIN `ok_lang_currencies` AS `l` ON `l`.`currency_id` = `c`.`id` AND `l`.`lang_id` = 1 WHERE `c`.`enabled` = :magic_filter_enabled ORDER BY `c`.`position` ------------------------------------------------------------------------------------------------------------------------------------------------------ 17) 0.00074100494384766: perform SELECT DISTINCT SQL_CACHE `p`.`id`, `p`.`url`, `p`.`visible`, `p`.`position`, `p`.`last_modify`, `l`.`name`, `l`.`name_h1`, `l`.`meta_title`, `l`.`meta_keywords`, `l`.`meta_description`, `l`.`description` FROM `ok_pages` AS `p` LEFT JOIN `ok_lang_pages` AS `l` ON `l`.`page_id` = `p`.`id` AND `l`.`lang_id` = 1 WHERE `p`.`visible` = :magic_filter_visible ORDER BY `p`.`position` ASC ------------------------------------------------------------------------------------------------------------------------------------------------------ 18) 0.00059986114501953: perform SELECT DISTINCT SQL_CACHE `p`.`id`, `p`.`module`, `p`.`currency_id`, `p`.`settings`, `p`.`enabled`, `p`.`position`, `p`.`image`, `l`.`name`, `l`.`description` FROM `ok_payment_methods` AS `p` LEFT JOIN `ok_lang_payment_methods` AS `l` ON `l`.`payment_id` = `p`.`id` AND `l`.`lang_id` = 1 WHERE `p`.`enabled` = :magic_filter_enabled ORDER BY `p`.`position` ------------------------------------------------------------------------------------------------------------------------------------------------------ 19) 0.0081369876861572: perform SELECT `c`.`id`, `c`.`parent_id`, `c`.`url`, `c`.`image`, `c`.`position`, `c`.`visible`, `c`.`external_id`, `c`.`level_depth`, `c`.`last_modify`, `c`.`created`, `r`.`slug_url`, `l`.`name`, `l`.`name_h1`, `l`.`auto_h1`, `l`.`meta_title`, `l`.`meta_keywords`, `l`.`meta_description`, `l`.`annotation`, `l`.`description`, `l`.`auto_meta_title`, `l`.`auto_meta_keywords`, `l`.`auto_meta_desc`, `l`.`auto_description` FROM `ok_categories` AS `c` LEFT JOIN `ok_lang_categories` AS `l` ON `l`.`category_id` = `c`.`id` AND `l`.`lang_id` = 1 LEFT JOIN `ok_router_cache` AS `r` ON `r`.`url`=`c`.`url` AND `r`.`type`="category" ORDER BY `c`.`parent_id`, `c`.`position` ------------------------------------------------------------------------------------------------------------------------------------------------------ 20) 0.00036191940307617: perform SELECT category_id FROM `ok_products_categories` GROUP BY category_id ------------------------------------------------------------------------------------------------------------------------------------------------------ 21) 0.00029706954956055: perform SELECT DISTINCT SQL_CACHE `m`.`id`, `m`.`group_id`, `m`.`name`, `m`.`visible`, `m`.`position` FROM `ok_menu` AS `m` WHERE `m`.`visible` = :magic_filter_visible ORDER BY `m`.`position` ASC ------------------------------------------------------------------------------------------------------------------------------------------------------ 22) 0.00036191940307617: perform SELECT DISTINCT SQL_CACHE `it`.`id`, `it`.`menu_id`, `it`.`parent_id`, `it`.`url`, `it`.`is_target_blank`, `it`.`visible`, `it`.`position`, `l`.`name` FROM `ok_menu_items` AS `it` LEFT JOIN `ok_lang_menu_items` AS `l` ON `l`.`menu_item_id` = `it`.`id` AND `l`.`lang_id` = 1 ORDER BY `it`.`parent_id`, `it`.`position` ------------------------------------------------------------------------------------------------------------------------------------------------------ 23) 0.00031113624572754: perform SELECT DISTINCT SQL_CACHE `a`.`id`, `a`.`filename`, `a`.`position`, `l`.`text` FROM `ok_advantages` AS `a` LEFT JOIN `ok_lang_advantages` AS `l` ON `l`.`advantage_id` = `a`.`id` AND `l`.`lang_id` = 1 ORDER BY `a`.`position` ASC ------------------------------------------------------------------------------------------------------------------------------------------------------ 24) 0.00078988075256348: perform SELECT `b`.`id`, `b`.`url`, `b`.`image`, `b`.`last_modify`, `b`.`visible`, `b`.`position`, `l`.`name`, `l`.`meta_title`, `l`.`meta_keywords`, `l`.`meta_description`, `l`.`annotation`, `l`.`description` FROM `ok_brands` AS `b` LEFT JOIN `ok_lang_brands` AS `l` ON `l`.`brand_id` = `b`.`id` AND `l`.`lang_id` = 1 WHERE `b`.`url` = :magic_filter_url ORDER BY `b`.`position` ------------------------------------------------------------------------------------------------------------------------------------------------------ 25) 0.0047800540924072: perform SELECT `pc`.`category_id` FROM `ok_products_categories` AS `pc` INNER JOIN `ok_products` `p` ON `p`.`id`=`pc`.`product_id` AND `p`.`brand_id` in (:brands_ids) AND `p`.`visible`=1 LEFT JOIN `ok_categories` `c` ON `c`.`id`=`pc`.`category_id` WHERE `c`.`visible`=:visible GROUP BY `pc`.`category_id` ORDER BY `c`.`parent_id`, `c`.`position` ------------------------------------------------------------------------------------------------------------------------------------------------------ 26) 0.0047900676727295: perform SELECT DISTINCT COUNT( DISTINCT `p`.`id`) AS `count` FROM `ok_products` AS `p` LEFT JOIN `ok_lang_products` AS `l` ON `l`.`product_id` = `p`.`id` AND `l`.`lang_id` = 1 LEFT JOIN `ok_variants` AS `pv` ON `pv`.`product_id` = `p`.`id` LEFT JOIN `ok_currencies` AS `c` ON `c`.`id`=`pv`.`currency_id` WHERE `p`.`visible` = :magic_filter_visible AND `p`.`brand_id` = :magic_filter_brand_id AND ((SELECT 1 FROM ok_variants pv WHERE `pv`.`product_id`=`p`.`id` AND `pv`.`compare_price`>0 LIMIT 1) = 1) ------------------------------------------------------------------------------------------------------------------------------------------------------ 27) 0.00062799453735352: perform SELECT DISTINCT COUNT( DISTINCT `p`.`id`) AS `count` FROM `ok_products` AS `p` LEFT JOIN `ok_lang_products` AS `l` ON `l`.`product_id` = `p`.`id` AND `l`.`lang_id` = 1 LEFT JOIN `ok_variants` AS `pv` ON `pv`.`product_id` = `p`.`id` LEFT JOIN `ok_currencies` AS `c` ON `c`.`id`=`pv`.`currency_id` WHERE `p`.`visible` = :magic_filter_visible AND `p`.`brand_id` = :magic_filter_brand_id AND (`p`.`featured`=1) ------------------------------------------------------------------------------------------------------------------------------------------------------ 28) 0.0092000961303711: perform SELECT floor(min(IF(`pv`.`currency_id`=0 OR `c`.`id` is null,`pv`.`price`, `pv`.`price`*`c`.`rate_to`/`c`.`rate_from`)*1)) AS `min`, floor(max(IF(`pv`.`currency_id`=0 OR `c`.`id` is null,`pv`.`price`, `pv`.`price`*`c`.`rate_to`/`c`.`rate_from`)*1)) AS `max` FROM `ok_products` AS `p` LEFT JOIN `ok_lang_products` AS `l` ON `l`.`product_id` = `p`.`id` AND `l`.`lang_id` = 1 LEFT JOIN `ok_variants` AS `pv` ON `pv`.`product_id` = `p`.`id` LEFT JOIN `ok_currencies` AS `c` ON `c`.`id`=`pv`.`currency_id` WHERE `p`.`visible` = :magic_filter_visible AND `p`.`brand_id` = :magic_filter_brand_id ------------------------------------------------------------------------------------------------------------------------------------------------------ 29) 0.010249853134155: perform SELECT DISTINCT COUNT( DISTINCT `p`.`id`) AS `count` FROM `ok_products` AS `p` LEFT JOIN `ok_lang_products` AS `l` ON `l`.`product_id` = `p`.`id` AND `l`.`lang_id` = 1 LEFT JOIN `ok_variants` AS `pv` ON `pv`.`product_id` = `p`.`id` LEFT JOIN `ok_currencies` AS `c` ON `c`.`id`=`pv`.`currency_id` WHERE `p`.`visible` = :magic_filter_visible AND `p`.`brand_id` = :magic_filter_brand_id ------------------------------------------------------------------------------------------------------------------------------------------------------ 30) 0.0030078887939453: perform SELECT DISTINCT SQL_CACHE `p`.`id`, `p`.`url`, `p`.`brand_id`, `p`.`visible`, `p`.`position`, `p`.`created`, `p`.`featured`, `p`.`external_id`, `p`.`rating`, `p`.`votes`, `p`.`last_modify`, `p`.`main_category_id`, `p`.`main_image_id`, `r`.`slug_url`, `l`.`name`, `l`.`annotation`, `l`.`special` FROM `ok_products` AS `p` LEFT JOIN `ok_router_cache` AS `r` ON `r`.`url`=`p`.`url` AND `r`.`type`="product" LEFT JOIN `ok_lang_products` AS `l` ON `l`.`product_id` = `p`.`id` AND `l`.`lang_id` = 1 LEFT JOIN `ok_variants` AS `pv` ON `pv`.`product_id` = `p`.`id` LEFT JOIN `ok_currencies` AS `c` ON `c`.`id`=`pv`.`currency_id` WHERE `p`.`visible` = :magic_filter_visible AND `p`.`brand_id` = :magic_filter_brand_id ORDER BY ((SELECT count(`pv`.`id`) FROM ok_variants pv WHERE (`pv`.`stock` IS NULL OR `pv`.`stock`>0) AND `p`.`id` = `pv`.`product_id`)>0) DESC, `p`.`position` DESC LIMIT 24 ------------------------------------------------------------------------------------------------------------------------------------------------------ 31) 0.0011210441589355: perform SELECT DISTINCT SQL_CACHE `v`.`id`, `v`.`product_id`, `v`.`sku`, `v`.`weight`, `v`.`price`, `v`.`compare_price`, `v`.`stock`, `v`.`position`, `v`.`external_id`, `v`.`currency_id`, (`v`.`stock` IS NULL) AS `infinity`, `c`.`rate_from`, `c`.`rate_to`, `l`.`name`, `l`.`units` FROM `ok_variants` AS `v` LEFT JOIN `ok_currencies` AS `c` ON `c`.`id`=`v`.`currency_id` LEFT JOIN `ok_lang_variants` AS `l` ON `l`.`variant_id` = `v`.`id` AND `l`.`lang_id` = 1 WHERE `v`.`product_id` IN (:magic_filter_product_id) ORDER BY IF(stock=0, 0, 1) DESC, `v`.`position`, `v`.`id` ------------------------------------------------------------------------------------------------------------------------------------------------------ 32) 0.00025200843811035: perform SELECT DISTINCT SQL_CACHE `c`.`id`, `c`.`code`, `c`.`rate_from`, `c`.`rate_to`, `c`.`cents`, `c`.`position`, `c`.`enabled`, `l`.`name`, `l`.`sign` FROM `ok_currencies` AS `c` LEFT JOIN `ok_lang_currencies` AS `l` ON `l`.`currency_id` = `c`.`id` AND `l`.`lang_id` = 1 ORDER BY `c`.`position` ------------------------------------------------------------------------------------------------------------------------------------------------------ 33) 0.00054311752319336: perform SELECT DISTINCT SQL_CACHE `i`.`id`, `i`.`name`, `i`.`product_id`, `i`.`filename`, `i`.`position` FROM `ok_images` AS `i` WHERE `i`.`id` IN (:magic_filter_id) ORDER BY `i`.`product_id`, `i`.`position` ------------------------------------------------------------------------------------------------------------------------------------------------------ 34) 0.00069499015808105: perform SELECT DISTINCT SQL_CACHE `p`.`last_modify` FROM `ok_products` AS `p` LEFT JOIN `ok_router_cache` AS `r` ON `r`.`url`=`p`.`url` AND `r`.`type`="product" LEFT JOIN `ok_lang_products` AS `l` ON `l`.`product_id` = `p`.`id` AND `l`.`lang_id` = 1 WHERE `p`.`brand_id` = :magic_filter_brand_id ORDER BY `p`.`last_modify` DESC LIMIT 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ 35) 0.00059103965759277: perform SELECT DISTINCT SQL_CACHE `b`.`id`, `b`.`name`, `b`.`group_name`, `b`.`position`, `b`.`visible`, `b`.`show_all_pages`, `b`.`categories`, `b`.`pages`, `b`.`brands`, `b`.`as_individual_shortcode`, `b`.`settings`, `b`.`show_all_products` FROM `ok_okaycms__banners` AS `b` WHERE `b`.`visible` = :magic_filter_visible AND (brands regexp '[[:<:]](255)[[:>:]]' OR show_all_pages=1) ORDER BY `b`.`position` ------------------------------------------------------------------------------------------------------------------------------------------------------ 36) 0.00029206275939941: perform SELECT DISTINCT SQL_CACHE `p`.`id`, `p`.`url`, `p`.`brand_id`, `p`.`visible`, `p`.`position`, `p`.`created`, `p`.`featured`, `p`.`external_id`, `p`.`rating`, `p`.`votes`, `p`.`last_modify`, `p`.`main_category_id`, `p`.`main_image_id`, `r`.`slug_url`, `l`.`name`, `l`.`annotation`, `l`.`special` FROM `ok_products` AS `p` LEFT JOIN `ok_router_cache` AS `r` ON `r`.`url`=`p`.`url` AND `r`.`type`="product" LEFT JOIN `ok_lang_products` AS `l` ON `l`.`product_id` = `p`.`id` AND `l`.`lang_id` = 1 WHERE `p`.`id` IN (:magic_filter_id) ORDER BY ((SELECT count(`pv`.`id`) FROM ok_variants pv WHERE (`pv`.`stock` IS NULL OR `pv`.`stock`>0) AND `p`.`id` = `pv`.`product_id`)>0) DESC, `p`.`position` DESC ------------------------------------------------------------------------------------------------------------------------------------------------------ 37) 0.00063085556030273: perform SELECT `c`.`id`, `c`.`code`, `c`.`rate_from`, `c`.`rate_to`, `c`.`cents`, `c`.`position`, `c`.`enabled`, `l`.`name`, `l`.`sign` FROM `ok_currencies` AS `c` LEFT JOIN `ok_lang_currencies` AS `l` ON `l`.`currency_id` = `c`.`id` AND `l`.`lang_id` = 1 WHERE `c`.`id` = :magic_filter_id ORDER BY `c`.`position` ------------------------------------------------------------------------------------------------------------------------------------------------------