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

Daniel

Сортировать по:
Фильтр
Быстрый заказ
100% гарантия качества
100% гарантия качества
14 дней на возврат товара
14 дней на возврат товара
Доставка по всей стране
Доставка по всей стране
Самовывоз из магазина
Самовывоз из магазина
1) 0.00021004676818848: perform SET NAMES 'utf8mb4' ------------------------------------------------------------------------------------------------------------------------------------------------------ 2) 0.00029706954956055: perform SET SESSION SQL_MODE = "ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION" ------------------------------------------------------------------------------------------------------------------------------------------------------ 3) 0.0003199577331543: perform SELECT * FROM `ok_languages` ORDER BY position ASC ------------------------------------------------------------------------------------------------------------------------------------------------------ 4) 0.00047397613525391: perform SELECT id, vendor, module_name, enabled FROM `ok_modules` ORDER BY position ASC ------------------------------------------------------------------------------------------------------------------------------------------------------ 5) 0.00046300888061523: perform SELECT param, value FROM `ok_settings` ------------------------------------------------------------------------------------------------------------------------------------------------------ 6) 0.00028586387634277: perform SELECT id FROM `ok_languages` WHERE id=0 LIMIT 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ 7) 0.00032401084899902: perform SELECT * FROM `ok_settings_lang` WHERE lang_id=:action_object_lang_id ------------------------------------------------------------------------------------------------------------------------------------------------------ 8) 0.0004119873046875: 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.0001981258392334: perform SELECT category_id FROM `ok_blog_categories_relation` GROUP BY category_id ------------------------------------------------------------------------------------------------------------------------------------------------------ 10) 0.00050616264343262: perform SELECT id, parent_id, url FROM `ok_blog_categories` WHERE url IN(:urls) ------------------------------------------------------------------------------------------------------------------------------------------------------ 11) 0.00021600723266602: 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.0003199577331543: perform SELECT DISTINCT SQL_CACHE `m`.`vendor`, `m`.`module_name` FROM `ok_modules` AS `m` ORDER BY `m`.`position` DESC ------------------------------------------------------------------------------------------------------------------------------------------------------ 13) 0.00098490715026855: 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.00040483474731445: 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.00048184394836426: 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.00031495094299316: 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.00078797340393066: 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.0005340576171875: 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.0045750141143799: 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.00040984153747559: perform SELECT category_id FROM `ok_products_categories` GROUP BY category_id ------------------------------------------------------------------------------------------------------------------------------------------------------ 21) 0.00031495094299316: 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.00033211708068848: 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.00049090385437012: 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.00081801414489746: 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.00054407119750977: 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.00070500373840332: 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.00051283836364746: 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.00061702728271484: 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.00061607360839844: 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.0017299652099609: 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.00029397010803223: 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.00034379959106445: 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.00029587745666504: 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.00077295303344727: 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.00080013275146484: 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 '[[:<:]](245)[[:>:]]' OR show_all_pages=1) ORDER BY `b`.`position` ------------------------------------------------------------------------------------------------------------------------------------------------------ 36) 0.00040411949157715: 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.00038886070251465: 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` ------------------------------------------------------------------------------------------------------------------------------------------------------