Narzędzia

Top »Narzędzia

Karmniki dla ptaków

Karmnik dla ptaków

35.00 zł

Karmniki dla ptaków

Karmnik dla ptaków

34.00 zł

Kołowrotki

KOŁOWROTEK JAXON ACURA XL 100

109.28 zł

Żyłki, Plecionki

Plecionka Jax New Concept Line G 0,12 100M

50.02 zł

Wszystkich zapytań: 46 w czasie 0.1525 s
Rows	ms	Err	Zapytanie
0	0.0023		SELECT `Banner`.`id` AS `Banner.id`, `Banner`.`zone_id` AS `Banner.zone_id`, `Banner`.`category_id` AS `Banner.category_id`, `Banner`.`name` AS `Banner.name`, `Banner`.`url` AS `Banner.url`, `Banner`.`file_id` AS `Banner.file_id`, `Banner`.`description` AS `Banner.description`, `Banner`.`add_date` AS `Banner.add_date`, `Banner`.`type_id` AS `Banner.type_id`, `Banner`.`height` AS `Banner.height`, `Banner`.`javascript` AS `Banner.javascript`, `Banner`.`method` AS `Banner.method`, `Banner`.`options_string` AS `Banner.options_string`, `Banner`.`from` AS `Banner.from`, `Banner`.`to` AS `Banner.to`, `Banner`.`display_always` AS `Banner.display_always`, `Banner`.`clicked` AS `Banner.clicked`, `Banner`.`viewed` AS `Banner.viewed`, `Banner`.`blocked` AS `Banner.blocked`, `Banner`.`display_in_special_cat1` AS `Banner.display_in_special_cat1`, `BannerZone`.`id` AS `BannerZone.id`, `BannerZone`.`name` AS `BannerZone.name`, `BannerZone`.`width` AS `BannerZone.width`, `BannerZone`.`height` AS `BannerZone.height`, `BannerToCategory`.`id` AS `BannerToCategory.id`, `BannerToCategory`.`banner_id` AS `BannerToCategory.banner_id`, `BannerToCategory`.`category_id` AS `BannerToCategory.category_id`, `BannerToCategory`.`pos` AS `BannerToCategory.pos` FROM `banner` AS `Banner` LEFT JOIN `banner_to_category` AS `BannerToCategory` ON `BannerToCategory`.`banner_id` = `Banner`.`id` LEFT JOIN `banner_zone` AS `BannerZone` ON `BannerZone`.`id` = `Banner`.`zone_id` WHERE DATE(Banner.`to`) >= DATE(NOW()) AND DATE(Banner.`from`) <= DATE(NOW()) AND Banner.`blocked` = 0 AND Banner.`zone_id` = 3 AND (`BannerToCategory`.`category_id` = 7 OR `Banner`.`display_always` = '1') GROUP BY Banner.`id` ORDER BY RAND() LIMIT 1;
1	0.0004		SELECT * FROM `file` WHERE `id` = 1128;
1	0.0005		UPDATE `banner` SET `viewed` = '38662' WHERE `id` = 34
1	0.0024		SELECT `Banner`.`id` AS `Banner.id`, `Banner`.`zone_id` AS `Banner.zone_id`, `Banner`.`category_id` AS `Banner.category_id`, `Banner`.`name` AS `Banner.name`, `Banner`.`url` AS `Banner.url`, `Banner`.`file_id` AS `Banner.file_id`, `Banner`.`description` AS `Banner.description`, `Banner`.`add_date` AS `Banner.add_date`, `Banner`.`type_id` AS `Banner.type_id`, `Banner`.`height` AS `Banner.height`, `Banner`.`javascript` AS `Banner.javascript`, `Banner`.`method` AS `Banner.method`, `Banner`.`options_string` AS `Banner.options_string`, `Banner`.`from` AS `Banner.from`, `Banner`.`to` AS `Banner.to`, `Banner`.`display_always` AS `Banner.display_always`, `Banner`.`clicked` AS `Banner.clicked`, `Banner`.`viewed` AS `Banner.viewed`, `Banner`.`blocked` AS `Banner.blocked`, `Banner`.`display_in_special_cat1` AS `Banner.display_in_special_cat1`, `BannerZone`.`id` AS `BannerZone.id`, `BannerZone`.`name` AS `BannerZone.name`, `BannerZone`.`width` AS `BannerZone.width`, `BannerZone`.`height` AS `BannerZone.height`, `BannerToCategory`.`id` AS `BannerToCategory.id`, `BannerToCategory`.`banner_id` AS `BannerToCategory.banner_id`, `BannerToCategory`.`category_id` AS `BannerToCategory.category_id`, `BannerToCategory`.`pos` AS `BannerToCategory.pos` FROM `banner` AS `Banner` LEFT JOIN `banner_to_category` AS `BannerToCategory` ON `BannerToCategory`.`banner_id` = `Banner`.`id` LEFT JOIN `banner_zone` AS `BannerZone` ON `BannerZone`.`id` = `Banner`.`zone_id` WHERE DATE(Banner.`to`) >= DATE(NOW()) AND DATE(Banner.`from`) <= DATE(NOW()) AND Banner.`blocked` = 0 AND Banner.`zone_id` = 1 AND (`BannerToCategory`.`category_id` = 7 OR `Banner`.`display_always` = '1') GROUP BY Banner.`id` ORDER BY RAND() LIMIT 1;
4	0.0017		SELECT `Article`.`id` AS `Article.id`, `Article`.`category_id` AS `Article.category_id`, `Article`.`template_id` AS `Article.template_id`, `Article`.`title` AS `Article.title`, `Article`.`header` AS `Article.header`, `Article`.`text` AS `Article.text`, `Article`.`source` AS `Article.source`, `Article`.`author` AS `Article.author`, `Article`.`add_date` AS `Article.add_date`, `Article`.`meta_title` AS `Article.meta_title`, `Article`.`meta_keywords` AS `Article.meta_keywords`, `Article`.`meta_description` AS `Article.meta_description`, `Article`.`modify_date` AS `Article.modify_date`, `Article`.`modify_user_id` AS `Article.modify_user_id`, `Article`.`lang` AS `Article.lang`, `Article`.`visitors` AS `Article.visitors`, `Article`.`file_id` AS `Article.file_id`, `Article`.`main_page` AS `Article.main_page`, `Article`.`visible` AS `Article.visible`, `Article`.`hide_reason` AS `Article.hide_reason`, `Article`.`alias` AS `Article.alias`, `Article`.`readonly` AS `Article.readonly`, `Article`.`system_key` AS `Article.system_key` FROM `article` AS `Article` WHERE `category_id` = 5 ORDER BY `title ;
23	0.0021		DESCRIBE `article`;
5	0.0009		SELECT `ProductCategory`.`id` AS `ProductCategory.id`, `ProductCategory`.`name` AS `ProductCategory.name`, `ProductCategory`.`file_id` AS `ProductCategory.file_id`, `ProductCategory`.`visible` AS `ProductCategory.visible`, `ProductCategory`.`parent_id` AS `ProductCategory.parent_id`, `ProductCategory`.`readonly` AS `ProductCategory.readonly`, `ProductCategory`.`meta_keywords` AS `ProductCategory.meta_keywords`, `ProductCategory`.`meta_description` AS `ProductCategory.meta_description`, `ProductCategory`.`pos` AS `ProductCategory.pos`, `ProductCategory`.`description` AS `ProductCategory.description`, `ProductCategory`.`special` AS `ProductCategory.special`, `ProductCategory`.`show_in_menu` AS `ProductCategory.show_in_menu`, `ProductCategory`.`clicks` AS `ProductCategory.clicks`, `ProductCategory`.`add_date` AS `ProductCategory.add_date` FROM `product_category` AS `ProductCategory` WHERE `visible` > 0 AND `id` IN (3,4,5,6,7) ORDER BY `pos` ASC ;
206	0.0055		SELECT `ProductCategory`.`id` AS `ProductCategory.id`, `ProductCategory`.`name` AS `ProductCategory.name`, `ProductCategory`.`file_id` AS `ProductCategory.file_id`, `ProductCategory`.`visible` AS `ProductCategory.visible`, `ProductCategory`.`parent_id` AS `ProductCategory.parent_id`, `ProductCategory`.`readonly` AS `ProductCategory.readonly`, `ProductCategory`.`meta_keywords` AS `ProductCategory.meta_keywords`, `ProductCategory`.`meta_description` AS `ProductCategory.meta_description`, `ProductCategory`.`pos` AS `ProductCategory.pos`, `ProductCategory`.`description` AS `ProductCategory.description`, `ProductCategory`.`special` AS `ProductCategory.special`, `ProductCategory`.`show_in_menu` AS `ProductCategory.show_in_menu`, `ProductCategory`.`clicks` AS `ProductCategory.clicks`, `ProductCategory`.`add_date` AS `ProductCategory.add_date` FROM `product_category` AS `ProductCategory` WHERE `visible` = 1 ORDER BY `pos` ASC ;
1	0.0005		SELECT * FROM `file` WHERE `id` = 368;
1	0.0005		SELECT * FROM `file` WHERE `id` = 1789;
1	0.0005		SELECT * FROM `file` WHERE `id` = 1750;
1	0.0005		SELECT * FROM `file` WHERE `id` = 1748;
1	0.0005		SELECT * FROM `file` WHERE `id` = 1396;
1	0.0005		UPDATE `banner` SET `viewed` = '1453' WHERE `id` = 54
1	0.0056		SELECT `Banner`.`id` AS `Banner.id`, `Banner`.`zone_id` AS `Banner.zone_id`, `Banner`.`category_id` AS `Banner.category_id`, `Banner`.`name` AS `Banner.name`, `Banner`.`url` AS `Banner.url`, `Banner`.`file_id` AS `Banner.file_id`, `Banner`.`description` AS `Banner.description`, `Banner`.`add_date` AS `Banner.add_date`, `Banner`.`type_id` AS `Banner.type_id`, `Banner`.`height` AS `Banner.height`, `Banner`.`javascript` AS `Banner.javascript`, `Banner`.`method` AS `Banner.method`, `Banner`.`options_string` AS `Banner.options_string`, `Banner`.`from` AS `Banner.from`, `Banner`.`to` AS `Banner.to`, `Banner`.`display_always` AS `Banner.display_always`, `Banner`.`clicked` AS `Banner.clicked`, `Banner`.`viewed` AS `Banner.viewed`, `Banner`.`blocked` AS `Banner.blocked`, `Banner`.`display_in_special_cat1` AS `Banner.display_in_special_cat1`, `BannerZone`.`id` AS `BannerZone.id`, `BannerZone`.`name` AS `BannerZone.name`, `BannerZone`.`width` AS `BannerZone.width`, `BannerZone`.`height` AS `BannerZone.height`, `BannerToCategory`.`id` AS `BannerToCategory.id`, `BannerToCategory`.`banner_id` AS `BannerToCategory.banner_id`, `BannerToCategory`.`category_id` AS `BannerToCategory.category_id`, `BannerToCategory`.`pos` AS `BannerToCategory.pos` FROM `banner` AS `Banner` LEFT JOIN `banner_to_category` AS `BannerToCategory` ON `BannerToCategory`.`banner_id` = `Banner`.`id` LEFT JOIN `banner_zone` AS `BannerZone` ON `BannerZone`.`id` = `Banner`.`zone_id` WHERE DATE(Banner.`to`) >= DATE(NOW()) AND DATE(Banner.`from`) <= DATE(NOW()) AND Banner.`blocked` = 0 AND Banner.`zone_id` = 6 AND (`BannerToCategory`.`category_id` = 7 OR `Banner`.`display_always` = '1') GROUP BY Banner.`id` ORDER BY RAND() LIMIT 1;
4	0.0013		DESCRIBE `banner_to_category`;
4	0.0014		DESCRIBE `banner_zone`;
20	0.0019		DESCRIBE `banner`;
1	0.0009		SELECT `ProductToCategory`.`id` AS `ProductToCategory.id`, `ProductToCategory`.`product_id` AS `ProductToCategory.product_id`, `ProductToCategory`.`category_id` AS `ProductToCategory.category_id`, `ProductToCategory`.`pos` AS `ProductToCategory.pos`, `ProductCategory`.`id` AS `ProductCategory.id`, `ProductCategory`.`name` AS `ProductCategory.name`, `ProductCategory`.`file_id` AS `ProductCategory.file_id`, `ProductCategory`.`visible` AS `ProductCategory.visible`, `ProductCategory`.`parent_id` AS `ProductCategory.parent_id`, `ProductCategory`.`readonly` AS `ProductCategory.readonly`, `ProductCategory`.`meta_keywords` AS `ProductCategory.meta_keywords`, `ProductCategory`.`meta_description` AS `ProductCategory.meta_description`, `ProductCategory`.`pos` AS `ProductCategory.pos`, `ProductCategory`.`description` AS `ProductCategory.description`, `ProductCategory`.`special` AS `ProductCategory.special`, `ProductCategory`.`show_in_menu` AS `ProductCategory.show_in_menu`, `ProductCategory`.`clicks` AS `ProductCategory.clicks`, `ProductCategory`.`add_date` AS `ProductCategory.add_date` FROM `product_to_category` AS `ProductToCategory` LEFT JOIN `product_category` AS `ProductCategory` ON `ProductCategory`.`id` = `ProductToCategory`.`category_id` WHERE `product_id` = 22106 ;
1	0.0009		SELECT `ProductToCategory`.`id` AS `ProductToCategory.id`, `ProductToCategory`.`product_id` AS `ProductToCategory.product_id`, `ProductToCategory`.`category_id` AS `ProductToCategory.category_id`, `ProductToCategory`.`pos` AS `ProductToCategory.pos`, `ProductCategory`.`id` AS `ProductCategory.id`, `ProductCategory`.`name` AS `ProductCategory.name`, `ProductCategory`.`file_id` AS `ProductCategory.file_id`, `ProductCategory`.`visible` AS `ProductCategory.visible`, `ProductCategory`.`parent_id` AS `ProductCategory.parent_id`, `ProductCategory`.`readonly` AS `ProductCategory.readonly`, `ProductCategory`.`meta_keywords` AS `ProductCategory.meta_keywords`, `ProductCategory`.`meta_description` AS `ProductCategory.meta_description`, `ProductCategory`.`pos` AS `ProductCategory.pos`, `ProductCategory`.`description` AS `ProductCategory.description`, `ProductCategory`.`special` AS `ProductCategory.special`, `ProductCategory`.`show_in_menu` AS `ProductCategory.show_in_menu`, `ProductCategory`.`clicks` AS `ProductCategory.clicks`, `ProductCategory`.`add_date` AS `ProductCategory.add_date` FROM `product_to_category` AS `ProductToCategory` LEFT JOIN `product_category` AS `ProductCategory` ON `ProductCategory`.`id` = `ProductToCategory`.`category_id` WHERE `product_id` = 22004 ;
1	0.0009		SELECT `ProductToCategory`.`id` AS `ProductToCategory.id`, `ProductToCategory`.`product_id` AS `ProductToCategory.product_id`, `ProductToCategory`.`category_id` AS `ProductToCategory.category_id`, `ProductToCategory`.`pos` AS `ProductToCategory.pos`, `ProductCategory`.`id` AS `ProductCategory.id`, `ProductCategory`.`name` AS `ProductCategory.name`, `ProductCategory`.`file_id` AS `ProductCategory.file_id`, `ProductCategory`.`visible` AS `ProductCategory.visible`, `ProductCategory`.`parent_id` AS `ProductCategory.parent_id`, `ProductCategory`.`readonly` AS `ProductCategory.readonly`, `ProductCategory`.`meta_keywords` AS `ProductCategory.meta_keywords`, `ProductCategory`.`meta_description` AS `ProductCategory.meta_description`, `ProductCategory`.`pos` AS `ProductCategory.pos`, `ProductCategory`.`description` AS `ProductCategory.description`, `ProductCategory`.`special` AS `ProductCategory.special`, `ProductCategory`.`show_in_menu` AS `ProductCategory.show_in_menu`, `ProductCategory`.`clicks` AS `ProductCategory.clicks`, `ProductCategory`.`add_date` AS `ProductCategory.add_date` FROM `product_to_category` AS `ProductToCategory` LEFT JOIN `product_category` AS `ProductCategory` ON `ProductCategory`.`id` = `ProductToCategory`.`category_id` WHERE `product_id` = 23780 ;
1	0.0009		SELECT `ProductToCategory`.`id` AS `ProductToCategory.id`, `ProductToCategory`.`product_id` AS `ProductToCategory.product_id`, `ProductToCategory`.`category_id` AS `ProductToCategory.category_id`, `ProductToCategory`.`pos` AS `ProductToCategory.pos`, `ProductCategory`.`id` AS `ProductCategory.id`, `ProductCategory`.`name` AS `ProductCategory.name`, `ProductCategory`.`file_id` AS `ProductCategory.file_id`, `ProductCategory`.`visible` AS `ProductCategory.visible`, `ProductCategory`.`parent_id` AS `ProductCategory.parent_id`, `ProductCategory`.`readonly` AS `ProductCategory.readonly`, `ProductCategory`.`meta_keywords` AS `ProductCategory.meta_keywords`, `ProductCategory`.`meta_description` AS `ProductCategory.meta_description`, `ProductCategory`.`pos` AS `ProductCategory.pos`, `ProductCategory`.`description` AS `ProductCategory.description`, `ProductCategory`.`special` AS `ProductCategory.special`, `ProductCategory`.`show_in_menu` AS `ProductCategory.show_in_menu`, `ProductCategory`.`clicks` AS `ProductCategory.clicks`, `ProductCategory`.`add_date` AS `ProductCategory.add_date` FROM `product_to_category` AS `ProductToCategory` LEFT JOIN `product_category` AS `ProductCategory` ON `ProductCategory`.`id` = `ProductToCategory`.`category_id` WHERE `product_id` = 23778 ;
0	0.0023		SELECT `Product`.`id` AS `Product.id`, `Product`.`category_id` AS `Product.category_id`, `Product`.`producer_id` AS `Product.producer_id`, `Product`.`promotion_id` AS `Product.promotion_id`, `Product`.`name` AS `Product.name`, `Product`.`model` AS `Product.model`, `Product`.`producer_key` AS `Product.producer_key`, `Product`.`pkwiu` AS `Product.pkwiu`, `Product`.`price` AS `Product.price`, `Product`.`tax_rate` AS `Product.tax_rate`, `Product`.`promotion_from` AS `Product.promotion_from`, `Product`.`promotion_to` AS `Product.promotion_to`, `Product`.`is_promotion` AS `Product.is_promotion`, `Product`.`promotion_price` AS `Product.promotion_price`, `Product`.`special` AS `Product.special`, `Product`.`available` AS `Product.available`, `Product`.`available_date` AS `Product.available_date`, `Product`.`add_date` AS `Product.add_date`, `Product`.`last_modified` AS `Product.last_modified`, `Product`.`short` AS `Product.short`, `Product`.`long` AS `Product.long`, `Product`.`faq` AS `Product.faq`, `Product`.`visible` AS `Product.visible`, `Product`.`meta_keywords` AS `Product.meta_keywords`, `Product`.`meta_description` AS `Product.meta_description`, `Product`.`clicks` AS `Product.clicks`, `Product`.`weight` AS `Product.weight`, `Product`.`points` AS `Product.points`, `Product`.`model_string` AS `Product.model_string`, `Product`.`loyality_program` AS `Product.loyality_program`, `Product`.`loyality_points_auto` AS `Product.loyality_points_auto`, `Product`.`loyality_points_additional` AS `Product.loyality_points_additional`, `Product`.`loyality_exchangeable` AS `Product.loyality_exchangeable`, `Product`.`sec_discount_active` AS `Product.sec_discount_active`, `Product`.`sec_discount_value` AS `Product.sec_discount_value`, `Product`.`sec_discount_unit` AS `Product.sec_discount_unit`, `ProductImage`.`id` AS `ProductImage.id`, `ProductImage`.`product_id` AS `ProductImage.product_id`, `ProductImage`.`file_id` AS `ProductImage.file_id`, `ProductImage`.`default` AS `ProductImage.default`, `ProductStatus`.`id` AS `ProductStatus.id`, `ProductStatus`.`name` AS `ProductStatus.name`, `ProductStatus`.`show_available_date` AS `ProductStatus.show_available_date`, `ProductStatus`.`not_available` AS `ProductStatus.not_available` FROM `product` AS `Product` LEFT JOIN `product_image` AS `ProductImage` ON `ProductImage`.`product_id` = `Product`.`id` AND ProductImage.`default` = '1' LEFT JOIN `product_to_category` AS `ProductToCategory` ON `ProductToCategory`.`product_id` = `Product`.`id` LEFT JOIN `product_status` AS `ProductStatus` ON `ProductStatus`.`id` = `Product`.`available` WHERE Product.`id` NOT IN (22106,2200423780,23778) AND ProductToCategory.`category_id` = 7 AND Product.`visible` = '1' GROUP BY Product.`id` ORDER BY RAND() LIMIT 1;
2	0.0305		SELECT `Product`.`id` AS `Product.id`, `Product`.`category_id` AS `Product.category_id`, `Product`.`producer_id` AS `Product.producer_id`, `Product`.`promotion_id` AS `Product.promotion_id`, `Product`.`name` AS `Product.name`, `Product`.`model` AS `Product.model`, `Product`.`producer_key` AS `Product.producer_key`, `Product`.`pkwiu` AS `Product.pkwiu`, `Product`.`price` AS `Product.price`, `Product`.`tax_rate` AS `Product.tax_rate`, `Product`.`promotion_from` AS `Product.promotion_from`, `Product`.`promotion_to` AS `Product.promotion_to`, `Product`.`is_promotion` AS `Product.is_promotion`, `Product`.`promotion_price` AS `Product.promotion_price`, `Product`.`special` AS `Product.special`, `Product`.`available` AS `Product.available`, `Product`.`available_date` AS `Product.available_date`, `Product`.`add_date` AS `Product.add_date`, `Product`.`last_modified` AS `Product.last_modified`, `Product`.`short` AS `Product.short`, `Product`.`long` AS `Product.long`, `Product`.`faq` AS `Product.faq`, `Product`.`visible` AS `Product.visible`, `Product`.`meta_keywords` AS `Product.meta_keywords`, `Product`.`meta_description` AS `Product.meta_description`, `Product`.`clicks` AS `Product.clicks`, `Product`.`weight` AS `Product.weight`, `Product`.`points` AS `Product.points`, `Product`.`model_string` AS `Product.model_string`, `Product`.`loyality_program` AS `Product.loyality_program`, `Product`.`loyality_points_auto` AS `Product.loyality_points_auto`, `Product`.`loyality_points_additional` AS `Product.loyality_points_additional`, `Product`.`loyality_exchangeable` AS `Product.loyality_exchangeable`, `Product`.`sec_discount_active` AS `Product.sec_discount_active`, `Product`.`sec_discount_value` AS `Product.sec_discount_value`, `Product`.`sec_discount_unit` AS `Product.sec_discount_unit`, `ProductImage`.`id` AS `ProductImage.id`, `ProductImage`.`product_id` AS `ProductImage.product_id`, `ProductImage`.`file_id` AS `ProductImage.file_id`, `ProductImage`.`default` AS `ProductImage.default`, `ProductStatus`.`id` AS `ProductStatus.id`, `ProductStatus`.`name` AS `ProductStatus.name`, `ProductStatus`.`show_available_date` AS `ProductStatus.show_available_date`, `ProductStatus`.`not_available` AS `ProductStatus.not_available` FROM `product` AS `Product` LEFT JOIN `product_image` AS `ProductImage` ON `ProductImage`.`product_id` = `Product`.`id` AND ProductImage.`default` = '1' LEFT JOIN `product_status` AS `ProductStatus` ON `ProductStatus`.`id` = `Product`.`available` WHERE Product.`id` NOT IN (22106,22004) AND Product.`is_promotion` = '1' AND Product.`promotion_from` <= CURDATE() AND Product.`promotion_to` >= CURDATE() AND Product.`visible` = '1' ORDER BY RAND() LIMIT 2;
2	0.0014		SELECT `Product`.`id` AS `Product.id`, `Product`.`category_id` AS `Product.category_id`, `Product`.`producer_id` AS `Product.producer_id`, `Product`.`promotion_id` AS `Product.promotion_id`, `Product`.`name` AS `Product.name`, `Product`.`model` AS `Product.model`, `Product`.`producer_key` AS `Product.producer_key`, `Product`.`pkwiu` AS `Product.pkwiu`, `Product`.`price` AS `Product.price`, `Product`.`tax_rate` AS `Product.tax_rate`, `Product`.`promotion_from` AS `Product.promotion_from`, `Product`.`promotion_to` AS `Product.promotion_to`, `Product`.`is_promotion` AS `Product.is_promotion`, `Product`.`promotion_price` AS `Product.promotion_price`, `Product`.`special` AS `Product.special`, `Product`.`available` AS `Product.available`, `Product`.`available_date` AS `Product.available_date`, `Product`.`add_date` AS `Product.add_date`, `Product`.`last_modified` AS `Product.last_modified`, `Product`.`short` AS `Product.short`, `Product`.`long` AS `Product.long`, `Product`.`faq` AS `Product.faq`, `Product`.`visible` AS `Product.visible`, `Product`.`meta_keywords` AS `Product.meta_keywords`, `Product`.`meta_description` AS `Product.meta_description`, `Product`.`clicks` AS `Product.clicks`, `Product`.`weight` AS `Product.weight`, `Product`.`points` AS `Product.points`, `Product`.`model_string` AS `Product.model_string`, `Product`.`loyality_program` AS `Product.loyality_program`, `Product`.`loyality_points_auto` AS `Product.loyality_points_auto`, `Product`.`loyality_points_additional` AS `Product.loyality_points_additional`, `Product`.`loyality_exchangeable` AS `Product.loyality_exchangeable`, `Product`.`sec_discount_active` AS `Product.sec_discount_active`, `Product`.`sec_discount_value` AS `Product.sec_discount_value`, `Product`.`sec_discount_unit` AS `Product.sec_discount_unit`, `ProductImage`.`id` AS `ProductImage.id`, `ProductImage`.`product_id` AS `ProductImage.product_id`, `ProductImage`.`file_id` AS `ProductImage.file_id`, `ProductImage`.`default` AS `ProductImage.default`, `ProductStatus`.`id` AS `ProductStatus.id`, `ProductStatus`.`name` AS `ProductStatus.name`, `ProductStatus`.`show_available_date` AS `ProductStatus.show_available_date`, `ProductStatus`.`not_available` AS `ProductStatus.not_available` FROM `product` AS `Product` LEFT JOIN `product_image` AS `ProductImage` ON `ProductImage`.`product_id` = `Product`.`id` AND ProductImage.`default` = '1' LEFT JOIN `product_status` AS `ProductStatus` ON `ProductStatus`.`id` = `Product`.`available` WHERE Product.`id` IN (22106,22004) AND Product.`visible` = '1' ;
2	0.0023		SELECT SUM(OrderItem.`amount`) AS `bought_times`, `OrderItem`.`id` AS `OrderItem.id`, `OrderItem`.`order_id` AS `OrderItem.order_id`, `OrderItem`.`product_id` AS `OrderItem.product_id`, `OrderItem`.`producer_id` AS `OrderItem.producer_id`, `OrderItem`.`name` AS `OrderItem.name`, `OrderItem`.`producer_key` AS `OrderItem.producer_key`, `OrderItem`.`amount` AS `OrderItem.amount`, `OrderItem`.`tax_rate` AS `OrderItem.tax_rate`, `OrderItem`.`price_brutto` AS `OrderItem.price_brutto`, `OrderItem`.`option_name` AS `OrderItem.option_name`, `OrderItem`.`weight` AS `OrderItem.weight`, `OrderItem`.`loyality_points` AS `OrderItem.loyality_points`, `OrderItem`.`loyality_exchange` AS `OrderItem.loyality_exchange`, `OrderItem`.`loyality_points_cost` AS `OrderItem.loyality_points_cost`, `OrderItem`.`discount_value` AS `OrderItem.discount_value`, `OrderItem`.`discount_unit` AS `OrderItem.discount_unit`, `OrderItem`.`sec_discount_active` AS `OrderItem.sec_discount_active`, `OrderItem`.`sec_discount_value` AS `OrderItem.sec_discount_value`, `OrderItem`.`sec_discount_unit` AS `OrderItem.sec_discount_unit` FROM `order_item` AS `OrderItem` GROUP BY OrderItem.`product_id` ORDER BY `bought_times` DESC LIMIT 2;
19	0.0024		DESCRIBE `order_item`;
11	0.0016		SELECT `ProductCategory`.`id` AS `ProductCategory.id`, `ProductCategory`.`name` AS `ProductCategory.name`, `ProductCategory`.`file_id` AS `ProductCategory.file_id`, `ProductCategory`.`visible` AS `ProductCategory.visible`, `ProductCategory`.`parent_id` AS `ProductCategory.parent_id`, `ProductCategory`.`readonly` AS `ProductCategory.readonly`, `ProductCategory`.`meta_keywords` AS `ProductCategory.meta_keywords`, `ProductCategory`.`meta_description` AS `ProductCategory.meta_description`, `ProductCategory`.`pos` AS `ProductCategory.pos`, `ProductCategory`.`description` AS `ProductCategory.description`, `ProductCategory`.`special` AS `ProductCategory.special`, `ProductCategory`.`show_in_menu` AS `ProductCategory.show_in_menu`, `ProductCategory`.`clicks` AS `ProductCategory.clicks`, `ProductCategory`.`add_date` AS `ProductCategory.add_date` FROM `product_category` AS `ProductCategory` WHERE `parent_id` = 21 ORDER BY `clicks` DESC ;
6	0.0011		SELECT `ProductCategory`.`id` AS `ProductCategory.id`, `ProductCategory`.`name` AS `ProductCategory.name`, `ProductCategory`.`file_id` AS `ProductCategory.file_id`, `ProductCategory`.`visible` AS `ProductCategory.visible`, `ProductCategory`.`parent_id` AS `ProductCategory.parent_id`, `ProductCategory`.`readonly` AS `ProductCategory.readonly`, `ProductCategory`.`meta_keywords` AS `ProductCategory.meta_keywords`, `ProductCategory`.`meta_description` AS `ProductCategory.meta_description`, `ProductCategory`.`pos` AS `ProductCategory.pos`, `ProductCategory`.`description` AS `ProductCategory.description`, `ProductCategory`.`special` AS `ProductCategory.special`, `ProductCategory`.`show_in_menu` AS `ProductCategory.show_in_menu`, `ProductCategory`.`clicks` AS `ProductCategory.clicks`, `ProductCategory`.`add_date` AS `ProductCategory.add_date` FROM `product_category` AS `ProductCategory` WHERE `parent_id` = 184 ORDER BY `clicks` DESC ;
16	0.0013		SELECT `ProductCategory`.`id` AS `ProductCategory.id`, `ProductCategory`.`name` AS `ProductCategory.name`, `ProductCategory`.`file_id` AS `ProductCategory.file_id`, `ProductCategory`.`visible` AS `ProductCategory.visible`, `ProductCategory`.`parent_id` AS `ProductCategory.parent_id`, `ProductCategory`.`readonly` AS `ProductCategory.readonly`, `ProductCategory`.`meta_keywords` AS `ProductCategory.meta_keywords`, `ProductCategory`.`meta_description` AS `ProductCategory.meta_description`, `ProductCategory`.`pos` AS `ProductCategory.pos`, `ProductCategory`.`description` AS `ProductCategory.description`, `ProductCategory`.`special` AS `ProductCategory.special`, `ProductCategory`.`show_in_menu` AS `ProductCategory.show_in_menu`, `ProductCategory`.`clicks` AS `ProductCategory.clicks`, `ProductCategory`.`add_date` AS `ProductCategory.add_date` FROM `product_category` AS `ProductCategory` WHERE `parent_id` = 22 ORDER BY `clicks` DESC ;
16	0.0013		SELECT `ProductCategory`.`id` AS `ProductCategory.id`, `ProductCategory`.`name` AS `ProductCategory.name`, `ProductCategory`.`file_id` AS `ProductCategory.file_id`, `ProductCategory`.`visible` AS `ProductCategory.visible`, `ProductCategory`.`parent_id` AS `ProductCategory.parent_id`, `ProductCategory`.`readonly` AS `ProductCategory.readonly`, `ProductCategory`.`meta_keywords` AS `ProductCategory.meta_keywords`, `ProductCategory`.`meta_description` AS `ProductCategory.meta_description`, `ProductCategory`.`pos` AS `ProductCategory.pos`, `ProductCategory`.`description` AS `ProductCategory.description`, `ProductCategory`.`special` AS `ProductCategory.special`, `ProductCategory`.`show_in_menu` AS `ProductCategory.show_in_menu`, `ProductCategory`.`clicks` AS `ProductCategory.clicks`, `ProductCategory`.`add_date` AS `ProductCategory.add_date` FROM `product_category` AS `ProductCategory` WHERE `parent_id` = 20 ORDER BY `clicks` DESC ;
4	0.0011		SELECT `ProductCategory`.`id` AS `ProductCategory.id`, `ProductCategory`.`name` AS `ProductCategory.name`, `ProductCategory`.`file_id` AS `ProductCategory.file_id`, `ProductCategory`.`visible` AS `ProductCategory.visible`, `ProductCategory`.`parent_id` AS `ProductCategory.parent_id`, `ProductCategory`.`readonly` AS `ProductCategory.readonly`, `ProductCategory`.`meta_keywords` AS `ProductCategory.meta_keywords`, `ProductCategory`.`meta_description` AS `ProductCategory.meta_description`, `ProductCategory`.`pos` AS `ProductCategory.pos`, `ProductCategory`.`description` AS `ProductCategory.description`, `ProductCategory`.`special` AS `ProductCategory.special`, `ProductCategory`.`show_in_menu` AS `ProductCategory.show_in_menu`, `ProductCategory`.`clicks` AS `ProductCategory.clicks`, `ProductCategory`.`add_date` AS `ProductCategory.add_date` FROM `product_category` AS `ProductCategory` WHERE `parent_id` = 7 ORDER BY `clicks` DESC ;
1	0.0006		SELECT `ProductCategory`.`id` AS `ProductCategory.id`, `ProductCategory`.`name` AS `ProductCategory.name`, `ProductCategory`.`file_id` AS `ProductCategory.file_id`, `ProductCategory`.`visible` AS `ProductCategory.visible`, `ProductCategory`.`parent_id` AS `ProductCategory.parent_id`, `ProductCategory`.`readonly` AS `ProductCategory.readonly`, `ProductCategory`.`meta_keywords` AS `ProductCategory.meta_keywords`, `ProductCategory`.`meta_description` AS `ProductCategory.meta_description`, `ProductCategory`.`pos` AS `ProductCategory.pos`, `ProductCategory`.`description` AS `ProductCategory.description`, `ProductCategory`.`special` AS `ProductCategory.special`, `ProductCategory`.`show_in_menu` AS `ProductCategory.show_in_menu`, `ProductCategory`.`clicks` AS `ProductCategory.clicks`, `ProductCategory`.`add_date` AS `ProductCategory.add_date` FROM `product_category` AS `ProductCategory` WHERE `ProductCategory`.`id` = '7' ;
1	0.0253		UPDATE `product_category` SET `clicks` = '473' WHERE `id` = '7'
1	0.0009		SELECT `ProductCategory`.`id` AS `ProductCategory.id`, `ProductCategory`.`name` AS `ProductCategory.name`, `ProductCategory`.`file_id` AS `ProductCategory.file_id`, `ProductCategory`.`visible` AS `ProductCategory.visible`, `ProductCategory`.`parent_id` AS `ProductCategory.parent_id`, `ProductCategory`.`readonly` AS `ProductCategory.readonly`, `ProductCategory`.`meta_keywords` AS `ProductCategory.meta_keywords`, `ProductCategory`.`meta_description` AS `ProductCategory.meta_description`, `ProductCategory`.`pos` AS `ProductCategory.pos`, `ProductCategory`.`description` AS `ProductCategory.description`, `ProductCategory`.`special` AS `ProductCategory.special`, `ProductCategory`.`show_in_menu` AS `ProductCategory.show_in_menu`, `ProductCategory`.`clicks` AS `ProductCategory.clicks`, `ProductCategory`.`add_date` AS `ProductCategory.add_date` FROM `product_category` AS `ProductCategory` WHERE `ProductCategory`.`id` = '7' ;
14	0.0017		DESCRIBE `product_category`;
0	0.0009		SELECT `Product`.`id` AS `Product.id` FROM `product` AS `Product` LEFT JOIN `product_to_category` AS `ProductToCategory` ON `ProductToCategory`.`product_id` = `Product`.`id` LEFT JOIN `product_image` AS `ProductImage` ON `ProductImage`.`product_id` = `Product`.`id` AND ProductImage.`default` = '1' LEFT JOIN `product_producer` AS `ProductProducer` ON `ProductProducer`.`id` = `Product`.`producer_id` LEFT JOIN `product_status` AS `ProductStatus` ON `ProductStatus`.`id` = `Product`.`available` WHERE (ProductToCategory.`category_id` = 7 AND Product.`visible` = '1') GROUP BY Product.`id` ;
4	0.0013		DESCRIBE `product_image`;
4	0.0013		DESCRIBE `product_to_category`;
4	0.0014		DESCRIBE `product_status`;
6	0.0015		DESCRIBE `product_producer`;
36	0.0345		DESCRIBE `product`;
0	0.0007		SELECT `BasketItem`.`id` AS `BasketItem.id`, `BasketItem`.`basket_id` AS `BasketItem.basket_id`, `BasketItem`.`product_id` AS `BasketItem.product_id`, `BasketItem`.`producer_id` AS `BasketItem.producer_id`, `BasketItem`.`name` AS `BasketItem.name`, `BasketItem`.`tax_rate` AS `BasketItem.tax_rate`, `BasketItem`.`price_brutto` AS `BasketItem.price_brutto`, `BasketItem`.`amount` AS `BasketItem.amount`, `BasketItem`.`producer_key` AS `BasketItem.producer_key`, `BasketItem`.`option_name` AS `BasketItem.option_name`, `BasketItem`.`weight` AS `BasketItem.weight`, `BasketItem`.`loyality_points` AS `BasketItem.loyality_points`, `BasketItem`.`loyality_exchange` AS `BasketItem.loyality_exchange`, `BasketItem`.`loyality_points_cost` AS `BasketItem.loyality_points_cost`, `BasketItem`.`discount_value` AS `BasketItem.discount_value`, `BasketItem`.`discount_unit` AS `BasketItem.discount_unit`, `BasketItem`.`sec_discount_active` AS `BasketItem.sec_discount_active`, `BasketItem`.`sec_discount_value` AS `BasketItem.sec_discount_value`, `BasketItem`.`sec_discount_unit` AS `BasketItem.sec_discount_unit` FROM `basket_item` AS `BasketItem` WHERE `basket_id` = 55369 ;
19	0.0021		DESCRIBE `basket_item`;
1	0.0006		SELECT `Basket`.`id` AS `Basket.id`, `Basket`.`customer_id` AS `Basket.customer_id`, `Basket`.`add_date` AS `Basket.add_date`, `Basket`.`session_id` AS `Basket.session_id` FROM `basket` AS `Basket` WHERE `Basket`.`id` = '55369' ;
4	0.0015		DESCRIBE `basket`;

Wszystkich zapytań: 46 w czasie 0.1525 s

Rows

Err

Zapytanie

0.0023

SELECT `Banner`.`id` AS `Banner.id`, `Banner`.`zone_id` AS `Banner.zone_id`, `Banner`.`category_id` AS `Banner.category_id`, `Banner`.`name` AS `Banner.name`, `Banner`.`url` AS `Banner.url`, `Banner`.`file_id` AS `Banner.file_id`, `Banner`.`description` AS `Banner.description`, `Banner`.`add_date` AS `Banner.add_date`, `Banner`.`type_id` AS `Banner.type_id`, `Banner`.`height` AS `Banner.height`, `Banner`.`javascript` AS `Banner.javascript`, `Banner`.`method` AS `Banner.method`, `Banner`.`options_string` AS `Banner.options_string`, `Banner`.`from` AS `Banner.from`, `Banner`.`to` AS `Banner.to`, `Banner`.`display_always` AS `Banner.display_always`, `Banner`.`clicked` AS `Banner.clicked`, `Banner`.`viewed` AS `Banner.viewed`, `Banner`.`blocked` AS `Banner.blocked`, `Banner`.`display_in_special_cat1` AS `Banner.display_in_special_cat1`, `BannerZone`.`id` AS `BannerZone.id`, `BannerZone`.`name` AS `BannerZone.name`, `BannerZone`.`width` AS `BannerZone.width`, `BannerZone`.`height` AS `BannerZone.height`, `BannerToCategory`.`id` AS `BannerToCategory.id`, `BannerToCategory`.`banner_id` AS `BannerToCategory.banner_id`, `BannerToCategory`.`category_id` AS `BannerToCategory.category_id`, `BannerToCategory`.`pos` AS `BannerToCategory.pos`
FROM `banner` AS `Banner`
LEFT JOIN `banner_to_category` AS `BannerToCategory` ON `BannerToCategory`.`banner_id` = `Banner`.`id`
LEFT JOIN `banner_zone` AS `BannerZone` ON `BannerZone`.`id` = `Banner`.`zone_id`
WHERE DATE(Banner.`to`) >= DATE(NOW()) AND DATE(Banner.`from`) <= DATE(NOW()) AND Banner.`blocked` = 0 AND Banner.`zone_id` = 3 AND (`BannerToCategory`.`category_id` = 7 OR `Banner`.`display_always` = '1')
GROUP BY Banner.`id`
ORDER BY RAND()
LIMIT 1;

0.0004

SELECT *
FROM `file`
WHERE `id` = 1128;

0.0005

UPDATE `banner` SET `viewed` = '38662'
WHERE `id` = 34

0.0024

SELECT `Banner`.`id` AS `Banner.id`, `Banner`.`zone_id` AS `Banner.zone_id`, `Banner`.`category_id` AS `Banner.category_id`, `Banner`.`name` AS `Banner.name`, `Banner`.`url` AS `Banner.url`, `Banner`.`file_id` AS `Banner.file_id`, `Banner`.`description` AS `Banner.description`, `Banner`.`add_date` AS `Banner.add_date`, `Banner`.`type_id` AS `Banner.type_id`, `Banner`.`height` AS `Banner.height`, `Banner`.`javascript` AS `Banner.javascript`, `Banner`.`method` AS `Banner.method`, `Banner`.`options_string` AS `Banner.options_string`, `Banner`.`from` AS `Banner.from`, `Banner`.`to` AS `Banner.to`, `Banner`.`display_always` AS `Banner.display_always`, `Banner`.`clicked` AS `Banner.clicked`, `Banner`.`viewed` AS `Banner.viewed`, `Banner`.`blocked` AS `Banner.blocked`, `Banner`.`display_in_special_cat1` AS `Banner.display_in_special_cat1`, `BannerZone`.`id` AS `BannerZone.id`, `BannerZone`.`name` AS `BannerZone.name`, `BannerZone`.`width` AS `BannerZone.width`, `BannerZone`.`height` AS `BannerZone.height`, `BannerToCategory`.`id` AS `BannerToCategory.id`, `BannerToCategory`.`banner_id` AS `BannerToCategory.banner_id`, `BannerToCategory`.`category_id` AS `BannerToCategory.category_id`, `BannerToCategory`.`pos` AS `BannerToCategory.pos`
FROM `banner` AS `Banner`
LEFT JOIN `banner_to_category` AS `BannerToCategory` ON `BannerToCategory`.`banner_id` = `Banner`.`id`
LEFT JOIN `banner_zone` AS `BannerZone` ON `BannerZone`.`id` = `Banner`.`zone_id`
WHERE DATE(Banner.`to`) >= DATE(NOW()) AND DATE(Banner.`from`) <= DATE(NOW()) AND Banner.`blocked` = 0 AND Banner.`zone_id` = 1 AND (`BannerToCategory`.`category_id` = 7 OR `Banner`.`display_always` = '1')
GROUP BY Banner.`id`
ORDER BY RAND()
LIMIT 1;

0.0017

SELECT `Article`.`id` AS `Article.id`, `Article`.`category_id` AS `Article.category_id`, `Article`.`template_id` AS `Article.template_id`, `Article`.`title` AS `Article.title`, `Article`.`header` AS `Article.header`, `Article`.`text` AS `Article.text`, `Article`.`source` AS `Article.source`, `Article`.`author` AS `Article.author`, `Article`.`add_date` AS `Article.add_date`, `Article`.`meta_title` AS `Article.meta_title`, `Article`.`meta_keywords` AS `Article.meta_keywords`, `Article`.`meta_description` AS `Article.meta_description`, `Article`.`modify_date` AS `Article.modify_date`, `Article`.`modify_user_id` AS `Article.modify_user_id`, `Article`.`lang` AS `Article.lang`, `Article`.`visitors` AS `Article.visitors`, `Article`.`file_id` AS `Article.file_id`, `Article`.`main_page` AS `Article.main_page`, `Article`.`visible` AS `Article.visible`, `Article`.`hide_reason` AS `Article.hide_reason`, `Article`.`alias` AS `Article.alias`, `Article`.`readonly` AS `Article.readonly`, `Article`.`system_key` AS `Article.system_key`
FROM `article` AS `Article`
WHERE `category_id` = 5
ORDER BY `title ;

0.0021

DESCRIBE `article`;

0.0009

SELECT `ProductCategory`.`id` AS `ProductCategory.id`, `ProductCategory`.`name` AS `ProductCategory.name`, `ProductCategory`.`file_id` AS `ProductCategory.file_id`, `ProductCategory`.`visible` AS `ProductCategory.visible`, `ProductCategory`.`parent_id` AS `ProductCategory.parent_id`, `ProductCategory`.`readonly` AS `ProductCategory.readonly`, `ProductCategory`.`meta_keywords` AS `ProductCategory.meta_keywords`, `ProductCategory`.`meta_description` AS `ProductCategory.meta_description`, `ProductCategory`.`pos` AS `ProductCategory.pos`, `ProductCategory`.`description` AS `ProductCategory.description`, `ProductCategory`.`special` AS `ProductCategory.special`, `ProductCategory`.`show_in_menu` AS `ProductCategory.show_in_menu`, `ProductCategory`.`clicks` AS `ProductCategory.clicks`, `ProductCategory`.`add_date` AS `ProductCategory.add_date`
FROM `product_category` AS `ProductCategory`
WHERE `visible` > 0 AND `id` IN (3,4,5,6,7)
ORDER BY `pos` ASC ;

206

0.0055

0.0005

SELECT *
FROM `file`
WHERE `id` = 368;

0.0005

SELECT *
FROM `file`
WHERE `id` = 1789;

0.0005

SELECT *
FROM `file`
WHERE `id` = 1750;

0.0005

SELECT *
FROM `file`
WHERE `id` = 1748;

0.0005

SELECT *
FROM `file`
WHERE `id` = 1396;

0.0005

UPDATE `banner` SET `viewed` = '1453'
WHERE `id` = 54

0.0056

SELECT `Banner`.`id` AS `Banner.id`, `Banner`.`zone_id` AS `Banner.zone_id`, `Banner`.`category_id` AS `Banner.category_id`, `Banner`.`name` AS `Banner.name`, `Banner`.`url` AS `Banner.url`, `Banner`.`file_id` AS `Banner.file_id`, `Banner`.`description` AS `Banner.description`, `Banner`.`add_date` AS `Banner.add_date`, `Banner`.`type_id` AS `Banner.type_id`, `Banner`.`height` AS `Banner.height`, `Banner`.`javascript` AS `Banner.javascript`, `Banner`.`method` AS `Banner.method`, `Banner`.`options_string` AS `Banner.options_string`, `Banner`.`from` AS `Banner.from`, `Banner`.`to` AS `Banner.to`, `Banner`.`display_always` AS `Banner.display_always`, `Banner`.`clicked` AS `Banner.clicked`, `Banner`.`viewed` AS `Banner.viewed`, `Banner`.`blocked` AS `Banner.blocked`, `Banner`.`display_in_special_cat1` AS `Banner.display_in_special_cat1`, `BannerZone`.`id` AS `BannerZone.id`, `BannerZone`.`name` AS `BannerZone.name`, `BannerZone`.`width` AS `BannerZone.width`, `BannerZone`.`height` AS `BannerZone.height`, `BannerToCategory`.`id` AS `BannerToCategory.id`, `BannerToCategory`.`banner_id` AS `BannerToCategory.banner_id`, `BannerToCategory`.`category_id` AS `BannerToCategory.category_id`, `BannerToCategory`.`pos` AS `BannerToCategory.pos`
FROM `banner` AS `Banner`
LEFT JOIN `banner_to_category` AS `BannerToCategory` ON `BannerToCategory`.`banner_id` = `Banner`.`id`
LEFT JOIN `banner_zone` AS `BannerZone` ON `BannerZone`.`id` = `Banner`.`zone_id`
WHERE DATE(Banner.`to`) >= DATE(NOW()) AND DATE(Banner.`from`) <= DATE(NOW()) AND Banner.`blocked` = 0 AND Banner.`zone_id` = 6 AND (`BannerToCategory`.`category_id` = 7 OR `Banner`.`display_always` = '1')
GROUP BY Banner.`id`
ORDER BY RAND()
LIMIT 1;

0.0013

DESCRIBE `banner_to_category`;

0.0014

DESCRIBE `banner_zone`;

0.0019

DESCRIBE `banner`;

0.0009

SELECT `ProductToCategory`.`id` AS `ProductToCategory.id`, `ProductToCategory`.`product_id` AS `ProductToCategory.product_id`, `ProductToCategory`.`category_id` AS `ProductToCategory.category_id`, `ProductToCategory`.`pos` AS `ProductToCategory.pos`, `ProductCategory`.`id` AS `ProductCategory.id`, `ProductCategory`.`name` AS `ProductCategory.name`, `ProductCategory`.`file_id` AS `ProductCategory.file_id`, `ProductCategory`.`visible` AS `ProductCategory.visible`, `ProductCategory`.`parent_id` AS `ProductCategory.parent_id`, `ProductCategory`.`readonly` AS `ProductCategory.readonly`, `ProductCategory`.`meta_keywords` AS `ProductCategory.meta_keywords`, `ProductCategory`.`meta_description` AS `ProductCategory.meta_description`, `ProductCategory`.`pos` AS `ProductCategory.pos`, `ProductCategory`.`description` AS `ProductCategory.description`, `ProductCategory`.`special` AS `ProductCategory.special`, `ProductCategory`.`show_in_menu` AS `ProductCategory.show_in_menu`, `ProductCategory`.`clicks` AS `ProductCategory.clicks`, `ProductCategory`.`add_date` AS `ProductCategory.add_date`
FROM `product_to_category` AS `ProductToCategory`
LEFT JOIN `product_category` AS `ProductCategory` ON `ProductCategory`.`id` = `ProductToCategory`.`category_id`
WHERE `product_id` = 22106 ;

0.0009

0.0023

SELECT `Product`.`id` AS `Product.id`, `Product`.`category_id` AS `Product.category_id`, `Product`.`producer_id` AS `Product.producer_id`, `Product`.`promotion_id` AS `Product.promotion_id`, `Product`.`name` AS `Product.name`, `Product`.`model` AS `Product.model`, `Product`.`producer_key` AS `Product.producer_key`, `Product`.`pkwiu` AS `Product.pkwiu`, `Product`.`price` AS `Product.price`, `Product`.`tax_rate` AS `Product.tax_rate`, `Product`.`promotion_from` AS `Product.promotion_from`, `Product`.`promotion_to` AS `Product.promotion_to`, `Product`.`is_promotion` AS `Product.is_promotion`, `Product`.`promotion_price` AS `Product.promotion_price`, `Product`.`special` AS `Product.special`, `Product`.`available` AS `Product.available`, `Product`.`available_date` AS `Product.available_date`, `Product`.`add_date` AS `Product.add_date`, `Product`.`last_modified` AS `Product.last_modified`, `Product`.`short` AS `Product.short`, `Product`.`long` AS `Product.long`, `Product`.`faq` AS `Product.faq`, `Product`.`visible` AS `Product.visible`, `Product`.`meta_keywords` AS `Product.meta_keywords`, `Product`.`meta_description` AS `Product.meta_description`, `Product`.`clicks` AS `Product.clicks`, `Product`.`weight` AS `Product.weight`, `Product`.`points` AS `Product.points`, `Product`.`model_string` AS `Product.model_string`, `Product`.`loyality_program` AS `Product.loyality_program`, `Product`.`loyality_points_auto` AS `Product.loyality_points_auto`, `Product`.`loyality_points_additional` AS `Product.loyality_points_additional`, `Product`.`loyality_exchangeable` AS `Product.loyality_exchangeable`, `Product`.`sec_discount_active` AS `Product.sec_discount_active`, `Product`.`sec_discount_value` AS `Product.sec_discount_value`, `Product`.`sec_discount_unit` AS `Product.sec_discount_unit`, `ProductImage`.`id` AS `ProductImage.id`, `ProductImage`.`product_id` AS `ProductImage.product_id`, `ProductImage`.`file_id` AS `ProductImage.file_id`, `ProductImage`.`default` AS `ProductImage.default`, `ProductStatus`.`id` AS `ProductStatus.id`, `ProductStatus`.`name` AS `ProductStatus.name`, `ProductStatus`.`show_available_date` AS `ProductStatus.show_available_date`, `ProductStatus`.`not_available` AS `ProductStatus.not_available`
FROM `product` AS `Product`
LEFT JOIN `product_image` AS `ProductImage` ON `ProductImage`.`product_id` = `Product`.`id` AND ProductImage.`default` = '1'
LEFT JOIN `product_to_category` AS `ProductToCategory` ON `ProductToCategory`.`product_id` = `Product`.`id`
LEFT JOIN `product_status` AS `ProductStatus` ON `ProductStatus`.`id` = `Product`.`available`
WHERE Product.`id` NOT IN (22106,2200423780,23778) AND ProductToCategory.`category_id` = 7 AND Product.`visible` = '1'
GROUP BY Product.`id`
ORDER BY RAND()
LIMIT 1;

0.0305

SELECT `Product`.`id` AS `Product.id`, `Product`.`category_id` AS `Product.category_id`, `Product`.`producer_id` AS `Product.producer_id`, `Product`.`promotion_id` AS `Product.promotion_id`, `Product`.`name` AS `Product.name`, `Product`.`model` AS `Product.model`, `Product`.`producer_key` AS `Product.producer_key`, `Product`.`pkwiu` AS `Product.pkwiu`, `Product`.`price` AS `Product.price`, `Product`.`tax_rate` AS `Product.tax_rate`, `Product`.`promotion_from` AS `Product.promotion_from`, `Product`.`promotion_to` AS `Product.promotion_to`, `Product`.`is_promotion` AS `Product.is_promotion`, `Product`.`promotion_price` AS `Product.promotion_price`, `Product`.`special` AS `Product.special`, `Product`.`available` AS `Product.available`, `Product`.`available_date` AS `Product.available_date`, `Product`.`add_date` AS `Product.add_date`, `Product`.`last_modified` AS `Product.last_modified`, `Product`.`short` AS `Product.short`, `Product`.`long` AS `Product.long`, `Product`.`faq` AS `Product.faq`, `Product`.`visible` AS `Product.visible`, `Product`.`meta_keywords` AS `Product.meta_keywords`, `Product`.`meta_description` AS `Product.meta_description`, `Product`.`clicks` AS `Product.clicks`, `Product`.`weight` AS `Product.weight`, `Product`.`points` AS `Product.points`, `Product`.`model_string` AS `Product.model_string`, `Product`.`loyality_program` AS `Product.loyality_program`, `Product`.`loyality_points_auto` AS `Product.loyality_points_auto`, `Product`.`loyality_points_additional` AS `Product.loyality_points_additional`, `Product`.`loyality_exchangeable` AS `Product.loyality_exchangeable`, `Product`.`sec_discount_active` AS `Product.sec_discount_active`, `Product`.`sec_discount_value` AS `Product.sec_discount_value`, `Product`.`sec_discount_unit` AS `Product.sec_discount_unit`, `ProductImage`.`id` AS `ProductImage.id`, `ProductImage`.`product_id` AS `ProductImage.product_id`, `ProductImage`.`file_id` AS `ProductImage.file_id`, `ProductImage`.`default` AS `ProductImage.default`, `ProductStatus`.`id` AS `ProductStatus.id`, `ProductStatus`.`name` AS `ProductStatus.name`, `ProductStatus`.`show_available_date` AS `ProductStatus.show_available_date`, `ProductStatus`.`not_available` AS `ProductStatus.not_available`
FROM `product` AS `Product`
LEFT JOIN `product_image` AS `ProductImage` ON `ProductImage`.`product_id` = `Product`.`id` AND ProductImage.`default` = '1'
LEFT JOIN `product_status` AS `ProductStatus` ON `ProductStatus`.`id` = `Product`.`available`
WHERE Product.`id` NOT IN (22106,22004) AND Product.`is_promotion` = '1' AND Product.`promotion_from` <= CURDATE() AND Product.`promotion_to` >= CURDATE() AND Product.`visible` = '1'
ORDER BY RAND()
LIMIT 2;

0.0014

SELECT `Product`.`id` AS `Product.id`, `Product`.`category_id` AS `Product.category_id`, `Product`.`producer_id` AS `Product.producer_id`, `Product`.`promotion_id` AS `Product.promotion_id`, `Product`.`name` AS `Product.name`, `Product`.`model` AS `Product.model`, `Product`.`producer_key` AS `Product.producer_key`, `Product`.`pkwiu` AS `Product.pkwiu`, `Product`.`price` AS `Product.price`, `Product`.`tax_rate` AS `Product.tax_rate`, `Product`.`promotion_from` AS `Product.promotion_from`, `Product`.`promotion_to` AS `Product.promotion_to`, `Product`.`is_promotion` AS `Product.is_promotion`, `Product`.`promotion_price` AS `Product.promotion_price`, `Product`.`special` AS `Product.special`, `Product`.`available` AS `Product.available`, `Product`.`available_date` AS `Product.available_date`, `Product`.`add_date` AS `Product.add_date`, `Product`.`last_modified` AS `Product.last_modified`, `Product`.`short` AS `Product.short`, `Product`.`long` AS `Product.long`, `Product`.`faq` AS `Product.faq`, `Product`.`visible` AS `Product.visible`, `Product`.`meta_keywords` AS `Product.meta_keywords`, `Product`.`meta_description` AS `Product.meta_description`, `Product`.`clicks` AS `Product.clicks`, `Product`.`weight` AS `Product.weight`, `Product`.`points` AS `Product.points`, `Product`.`model_string` AS `Product.model_string`, `Product`.`loyality_program` AS `Product.loyality_program`, `Product`.`loyality_points_auto` AS `Product.loyality_points_auto`, `Product`.`loyality_points_additional` AS `Product.loyality_points_additional`, `Product`.`loyality_exchangeable` AS `Product.loyality_exchangeable`, `Product`.`sec_discount_active` AS `Product.sec_discount_active`, `Product`.`sec_discount_value` AS `Product.sec_discount_value`, `Product`.`sec_discount_unit` AS `Product.sec_discount_unit`, `ProductImage`.`id` AS `ProductImage.id`, `ProductImage`.`product_id` AS `ProductImage.product_id`, `ProductImage`.`file_id` AS `ProductImage.file_id`, `ProductImage`.`default` AS `ProductImage.default`, `ProductStatus`.`id` AS `ProductStatus.id`, `ProductStatus`.`name` AS `ProductStatus.name`, `ProductStatus`.`show_available_date` AS `ProductStatus.show_available_date`, `ProductStatus`.`not_available` AS `ProductStatus.not_available`
FROM `product` AS `Product`
LEFT JOIN `product_image` AS `ProductImage` ON `ProductImage`.`product_id` = `Product`.`id` AND ProductImage.`default` = '1'
LEFT JOIN `product_status` AS `ProductStatus` ON `ProductStatus`.`id` = `Product`.`available`
WHERE Product.`id` IN (22106,22004) AND Product.`visible` = '1' ;

0.0023

SELECT SUM(OrderItem.`amount`) AS `bought_times`, `OrderItem`.`id` AS `OrderItem.id`, `OrderItem`.`order_id` AS `OrderItem.order_id`, `OrderItem`.`product_id` AS `OrderItem.product_id`, `OrderItem`.`producer_id` AS `OrderItem.producer_id`, `OrderItem`.`name` AS `OrderItem.name`, `OrderItem`.`producer_key` AS `OrderItem.producer_key`, `OrderItem`.`amount` AS `OrderItem.amount`, `OrderItem`.`tax_rate` AS `OrderItem.tax_rate`, `OrderItem`.`price_brutto` AS `OrderItem.price_brutto`, `OrderItem`.`option_name` AS `OrderItem.option_name`, `OrderItem`.`weight` AS `OrderItem.weight`, `OrderItem`.`loyality_points` AS `OrderItem.loyality_points`, `OrderItem`.`loyality_exchange` AS `OrderItem.loyality_exchange`, `OrderItem`.`loyality_points_cost` AS `OrderItem.loyality_points_cost`, `OrderItem`.`discount_value` AS `OrderItem.discount_value`, `OrderItem`.`discount_unit` AS `OrderItem.discount_unit`, `OrderItem`.`sec_discount_active` AS `OrderItem.sec_discount_active`, `OrderItem`.`sec_discount_value` AS `OrderItem.sec_discount_value`, `OrderItem`.`sec_discount_unit` AS `OrderItem.sec_discount_unit`
FROM `order_item` AS `OrderItem`
GROUP BY OrderItem.`product_id`
ORDER BY `bought_times` DESC
LIMIT 2;

0.0024

DESCRIBE `order_item`;

0.0016

0.0011

0.0013

0.0011

0.0006

0.0253

UPDATE `product_category` SET `clicks` = '473'
WHERE `id` = '7'

0.0009

0.0017

DESCRIBE `product_category`;

0.0009

SELECT `Product`.`id` AS `Product.id`
FROM `product` AS `Product`
LEFT JOIN `product_to_category` AS `ProductToCategory` ON `ProductToCategory`.`product_id` = `Product`.`id`
LEFT JOIN `product_image` AS `ProductImage` ON `ProductImage`.`product_id` = `Product`.`id` AND ProductImage.`default` = '1'
LEFT JOIN `product_producer` AS `ProductProducer` ON `ProductProducer`.`id` = `Product`.`producer_id`
LEFT JOIN `product_status` AS `ProductStatus` ON `ProductStatus`.`id` = `Product`.`available`
WHERE (ProductToCategory.`category_id` = 7 AND Product.`visible` = '1')
GROUP BY Product.`id` ;

0.0013

DESCRIBE `product_image`;

0.0013

DESCRIBE `product_to_category`;

0.0014

DESCRIBE `product_status`;

0.0015

DESCRIBE `product_producer`;

0.0345

DESCRIBE `product`;

0.0007

SELECT `BasketItem`.`id` AS `BasketItem.id`, `BasketItem`.`basket_id` AS `BasketItem.basket_id`, `BasketItem`.`product_id` AS `BasketItem.product_id`, `BasketItem`.`producer_id` AS `BasketItem.producer_id`, `BasketItem`.`name` AS `BasketItem.name`, `BasketItem`.`tax_rate` AS `BasketItem.tax_rate`, `BasketItem`.`price_brutto` AS `BasketItem.price_brutto`, `BasketItem`.`amount` AS `BasketItem.amount`, `BasketItem`.`producer_key` AS `BasketItem.producer_key`, `BasketItem`.`option_name` AS `BasketItem.option_name`, `BasketItem`.`weight` AS `BasketItem.weight`, `BasketItem`.`loyality_points` AS `BasketItem.loyality_points`, `BasketItem`.`loyality_exchange` AS `BasketItem.loyality_exchange`, `BasketItem`.`loyality_points_cost` AS `BasketItem.loyality_points_cost`, `BasketItem`.`discount_value` AS `BasketItem.discount_value`, `BasketItem`.`discount_unit` AS `BasketItem.discount_unit`, `BasketItem`.`sec_discount_active` AS `BasketItem.sec_discount_active`, `BasketItem`.`sec_discount_value` AS `BasketItem.sec_discount_value`, `BasketItem`.`sec_discount_unit` AS `BasketItem.sec_discount_unit`
FROM `basket_item` AS `BasketItem`
WHERE `basket_id` = 55369 ;

0.0021

DESCRIBE `basket_item`;

0.0006

SELECT `Basket`.`id` AS `Basket.id`, `Basket`.`customer_id` AS `Basket.customer_id`, `Basket`.`add_date` AS `Basket.add_date`, `Basket`.`session_id` AS `Basket.session_id`
FROM `basket` AS `Basket`
WHERE `Basket`.`id` = '55369' ;

0.0015

DESCRIBE `basket`;

			Zaawansowane
		- Leśnictwo - Dystynkcje, Naszywki - Dystynkcje - Naszywki - Oznaki - Mundur Codzienny - Akcesoria Mundurowe - Bluzy - Buty - Kamizelki - Koszule Damskie - Koszule Męskie - Kurtki Damskie - Kurtki Męskie - Marynarki Damskie - Marynarki Męskie - Nakrycia głowy - Spódnice - Spodnie - Swetry - Mundur Terenowy - Akcesoria Mundurowe - Buty - Kamizelki - Koszule Damskie - Koszule Męskie - Kurtki Damskie - Kurtki Męskie - Nakrycia głowy - Spodnie - Swetry - Mundur Wyjściowy - Akcesoria Mundurowe - Buty - Kamizelki - Koszule Damskie - Koszule Męskie - Kurtki Damskie - Kurtki Męskie - Marynarki damskie - Marynarki męskie - Nakrycia głowy - Płaszcze - Spódnice - Spodnie - Swetry - Narzędzia - Artykuły Gospodarstwa Domowego - Garnki - Inne - Małe Akcesoria Kuchenne - Noże, Nożyczki , Ostrzałki - Patelnie - Sztućce - Narzędzia leśne - Akcesoria do numerowania - Akcesoria do płynów chemicznych - Akcesoria ochronne i inne - Chwytaki, Kleszcze, Esy - Dźwignie, Obracaki, Haki - Inne Akcesoria do pomiaru - Kostur, Kliny - Kosy, Tasaki, Świdry - Motyki, Maczety - Noże, Nożyce, Sekatory, Os - Ośniki, Wysokościomierze - Ściągi linowe, Liny - Siekiery, Młoty - Średnicomierze, Klupy - Taśmy miernicze, wkłady, haczyki - Znaczniki, Lubryki, Ryśniki, Far - Narzędzia ogrodnicze - Inne - Kostury, Kliny - Narzędzia małe, Trzonki - Nożyce, Sekatory, Ostrza - Odgarniacze, Skuwacze, Pługi do - Oleje - Pilarki i części zamienne - Piły - Szpadle, Szufle, Saperki, Łopaty - Ubrania dla Pilarzy - Widły, Grabie - Układy tnące - Bębny OREGON - Inne Akcesoria Układów Tnących, - Kółka, Linki, Tarcze - Ostrzałki, Pilniki OREGON - Pilarki i części zamienne - Prowadnice TIGER - Prowadnice, Osłony OREGON - Żyłki, Taśmy, Wkłady - Łańcuchy, Ogniwa OREGON - Łańcuchy SARP - Prowadnice TIGER - Łańcuchy, Ogniwa TIGER - Pilniki SARP - Pilniki TIGER - Bęben sprzęgła TIGER - Linki rozrusznika Tiger - Myślistwo - Akcesoria - Biżuteria, Medale - Breloki, figurki i inne - Latarki, Lornetki, Lunety - Noże myśliwskie - Wyposażenie kwater myśliwskich - Książki - Filmy - Płyty CD - Karmniki dla ptaków - Inne - Buty - Buty letnie - Buty wyjściowe - Buty zimowe - Kalosze - Mundury - Akcesoria mundurowe - Marynarki mundurowe - Płaszcze mundurowe - Spodnie mundurowe - Ubrania - Marynarki - Spodnie - Swetry - Bielizna - Inne - Nakrycia głowy - Dodatki - Kurtki - Bluzy - Kamizelki - Kurtki letnie - Kurtki zimowe - Koszule - Koszule długi rękaw - Koszule krótki rękaw - Kulinaria - Przyprawy - Herbaty zdrowotne - Garnki - Noże, Nożyczki, Ostrzałki - Sztućce - Patelnie - Małe akcesoria kuchenne - Zioła do kąpieli - Turystyka - Akcesoria - Artykuły kuchenne - Latarki - Narzędzia turystyczne - Noże - Optyka - Inne - Torby, plecaki - Buty - Buty miejskie - Buty trekingowe - Buty wspinaczkowe - Impregnaty do butów - Kalosze - Ubrania turystyczne - Bielizna - Bluzy - Dodatki do ubrań - Kamizelki - Koszule - Koszulki - Kurtki - Spodnie - Wędkarstwo - Akcesoria Wędkarskie Duże - Kołowrotki - Krzesełka wędkarskie - Pojemniki - Siatki, Podbieraki - Torby Wędkarskie, Pokrowce - Wędki - Akcesoria Wędkarskie Małe - Atraktory - Błystki - Obrotówki - Wahadłówki - Ciężarki - Haczyki, Kotwiczki - Inne - Koszyczki zanętowe - Noże - Przynęty - Spławiki - Sygnalizatory, Wagi - Zanęty - Noże wędkarskie - Żyłki, Plecionki - Odzież Wędkarska - Bielizna - Czapki - Kalosze, Buty gumowe - Kamizelki - Kurtki - Spodnie - Inne - SILVAPUNKTY WYMIANA - Wyprzedaż - Końcówki Serii