Query | Affected | Num. rows | Took (ms) | Actions |
---|
SELECT `Shop`.`id`, `Shop`.`seller_id`, `Shop`.`name`, `Shop`.`slug`, `Shop`.`description`, `Seller`.`id`, `Seller`.`member_id` FROM `lenjerieerotica_ro`.`shops` AS `Shop` LEFT JOIN `lenjerieerotica_ro`.`sellers` AS `Seller` ON (`Shop`.`seller_id` = `Seller`.`id`) WHERE `slug` = 'lenjerieerotica' LIMIT 1 | 0 | 0 | 0 | |
SELECT `Category`.`slug`, `Category`.`name` FROM `lenjerieerotica_ro`.`categories` AS `Category` WHERE `slug` IS NULL | 0 | 0 | 0 | |
SELECT `Product`.`id`, `Product`.`shop_id`, `Product`.`name`, `Product`.`display_name`, `Product`.`slug`, `Product`.`model`, `Product`.`short_description`, `Product`.`description`, `Product`.`meta_description`, `Product`.`meta_keywords`, `Product`.`uuid`, `Product`.`internal_code`, `Product`.`sku`, `Product`.`upc`, `Product`.`priority`, `Product`.`location`, `Product`.`quantity`, `Product`.`stock_status_id`, `Product`.`image`, `Product`.`media_url`, `Product`.`manufacturer_id`, `Product`.`require_shipping`, `Product`.`price`, `Product`.`points`, `Product`.`tax_class_id`, `Product`.`weight`, `Product`.`weight_class_id`, `Product`.`length`, `Product`.`width`, `Product`.`height`, `Product`.`length_class_id`, `Product`.`subtract_stock`, `Product`.`minimum_quantity`, `Product`.`sort_order`, `Product`.`status`, `Product`.`is_package`, `Product`.`created`, `Product`.`modified`, `Product`.`modified_by`, `Product`.`views`, `Product`.`comment_count`, `Product`.`temp_1`, `Product`.`promoted`, `StockStatus`.`name` FROM `lenjerieerotica_ro`.`products` AS `Product` LEFT JOIN `lenjerieerotica_ro`.`stock_statuses` AS `StockStatus` ON (`Product`.`stock_status_id` = `StockStatus`.`id` AND language_id = 1) WHERE `Product`.`slug` = 'accesoriu-pentru-par-blue' LIMIT 1 | 1 | 1 | 0 | |
SELECT `AttributeValue`.`id`, `AttributeValue`.`attribute_id`, `AttributeValue`.`value`, `AttributeValue`.`entity_id` FROM `lenjerieerotica_ro`.`attribute_values` AS `AttributeValue` WHERE `AttributeValue`.`model` = 'Product' AND `AttributeValue`.`entity_id` = (782) ORDER BY `id` asc | 1 | 1 | 4 | maybe slow |
SELECT `Attribute`.`id`, `Attribute`.`name`, `Attribute`.`model`, `Attribute`.`description`, `Attribute`.`data_type`, `Attribute`.`created`, `Attribute`.`modified` FROM `lenjerieerotica_ro`.`attributes` AS `Attribute` WHERE `Attribute`.`id` = 1 | 1 | 1 | 0 | |
SELECT `Comment`.`id`, `Comment`.`text`, `Comment`.`rating`, `Comment`.`created`, `Comment`.`title`, `Comment`.`member_id`, `Comment`.`product_id` FROM `lenjerieerotica_ro`.`comments` AS `Comment` WHERE `Comment`.`status` = '1' AND `Comment`.`product_id` = (782) ORDER BY `id` desc | 0 | 0 | 0 | |
SELECT `ProductImage`.`id`, `ProductImage`.`product_id`, `ProductImage`.`image`, `ProductImage`.`sort_order`, `ProductImage`.`size`, `ProductImage`.`main_image`, `ProductImage`.`label` FROM `lenjerieerotica_ro`.`product_images` AS `ProductImage` WHERE `main_image` <> 1 AND `ProductImage`.`product_id` = (782) | 0 | 0 | 4 | maybe slow |
SELECT `ProductDiscount`.`price`, `ProductDiscount`.`product_id` FROM `lenjerieerotica_ro`.`product_discounts` AS `ProductDiscount` WHERE `ProductDiscount`.`product_id` = (782) LIMIT 1 | 0 | 0 | 0 | |
SELECT `ProductRelated`.`id`, `ProductRelated`.`name`, `ProductRelated`.`display_name`, `ProductRelated`.`slug`, `ProductRelated`.`price`, `ProductRelated`.`image`, `ProductRelated`.`meta_keywords`, `ProductRelated`.`meta_description`, `RelatedProduct`.`product_id`, `RelatedProduct`.`related_id` FROM `lenjerieerotica_ro`.`products` AS `ProductRelated` JOIN `lenjerieerotica_ro`.`related_products` AS `RelatedProduct` ON (`RelatedProduct`.`product_id` = 782 AND `RelatedProduct`.`related_id` = `ProductRelated`.`id`) LIMIT 3 | 0 | 0 | 0 | |
SELECT `ProductRelatedCategory`.`id`, `ProductRelatedCategory`.`name`, `ProductCategoriesRelation`.`category_id`, `ProductCategoriesRelation`.`model_id` FROM `lenjerieerotica_ro`.`categories` AS `ProductRelatedCategory` JOIN `lenjerieerotica_ro`.`product_categories_relations` AS `ProductCategoriesRelation` ON (`ProductCategoriesRelation`.`model_id` = 782 AND `ProductCategoriesRelation`.`category_id` = `ProductRelatedCategory`.`id`) | 0 | 0 | 0 | |
SELECT `Category`.`id`, `Category`.`name`, `CategoriesProduct`.`product_id`, `CategoriesProduct`.`category_id` FROM `lenjerieerotica_ro`.`categories` AS `Category` JOIN `lenjerieerotica_ro`.`categories_products` AS `CategoriesProduct` ON (`CategoriesProduct`.`product_id` = 782 AND `CategoriesProduct`.`category_id` = `Category`.`id`) | 1 | 1 | 0 | |
SELECT `Tag`.`id`, `Tag`.`identifier`, `Tag`.`name`, `Tag`.`keyname`, `Tag`.`weight`, `Tag`.`created`, `Tag`.`modified`, `Tagged`.`id`, `Tagged`.`foreign_key`, `Tagged`.`tag_id`, `Tagged`.`model`, `Tagged`.`language`, `Tagged`.`times_tagged`, `Tagged`.`created`, `Tagged`.`modified` FROM `lenjerieerotica_ro`.`tags` AS `Tag` JOIN `lenjerieerotica_ro`.`tagged` AS `Tagged` ON (`Tagged`.`foreign_key` = 782 AND `Tagged`.`tag_id` = `Tag`.`id`) WHERE `Tagged`.`model` = 'Product' | 0 | 0 | 0 | |
SELECT `Product`.`id` FROM `lenjerieerotica_ro`.`products` AS `Product` WHERE `Product`.`id` = 782 LIMIT 1 | 1 | 1 | 0 | |
SELECT `Category`.`id`, `Category`.`name`, `Category`.`slug`, `CategoriesProduct`.`product_id`, `CategoriesProduct`.`category_id` FROM `lenjerieerotica_ro`.`categories` AS `Category` JOIN `lenjerieerotica_ro`.`categories_products` AS `CategoriesProduct` ON (`CategoriesProduct`.`product_id` = 782 AND `CategoriesProduct`.`category_id` = `Category`.`id`) | 1 | 1 | 0 | |
SELECT `Category`.`lft`, `Category`.`rght` FROM `lenjerieerotica_ro`.`categories` AS `Category` WHERE `Category`.`id` = 11 LIMIT 1 | 1 | 1 | 0 | |
SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`name`, `Category`.`slug` FROM `lenjerieerotica_ro`.`categories` AS `Category` WHERE 1 = 1 AND `Category`.`lft` <= 28 AND `Category`.`rght` >= 29 ORDER BY `Category`.`lft` asc | 2 | 2 | 0 | |
SELECT `Product`.`id` FROM `lenjerieerotica_ro`.`products` AS `Product` WHERE `id` = 782 LIMIT 1 | 1 | 1 | 0 | |
SELECT `ProductRelated`.`id`, `RelatedProduct`.`product_id`, `RelatedProduct`.`related_id` FROM `lenjerieerotica_ro`.`products` AS `ProductRelated` JOIN `lenjerieerotica_ro`.`related_products` AS `RelatedProduct` ON (`RelatedProduct`.`product_id` = 782 AND `RelatedProduct`.`related_id` = `ProductRelated`.`id`) WHERE `status` = '1' | 0 | 0 | 0 | |
SELECT `Product`.`id` FROM `lenjerieerotica_ro`.`products` AS `Product` WHERE `id` = 782 LIMIT 1 | 1 | 1 | 0 | |
SELECT `ProductRelatedCategory`.`id`, `ProductRelatedCategory`.`name`, `ProductCategoriesRelation`.`category_id`, `ProductCategoriesRelation`.`model_id` FROM `lenjerieerotica_ro`.`categories` AS `ProductRelatedCategory` JOIN `lenjerieerotica_ro`.`product_categories_relations` AS `ProductCategoriesRelation` ON (`ProductCategoriesRelation`.`model_id` = 782 AND `ProductCategoriesRelation`.`category_id` = `ProductRelatedCategory`.`id`) | 0 | 0 | 0 | |
SELECT `Product`.`id` FROM `lenjerieerotica_ro`.`products` AS `Product` WHERE `Product`.`id` = 782 LIMIT 1 | 1 | 1 | 0 | |
SELECT `Category`.`id`, `Category`.`name`, `Category`.`slug`, `CategoriesProduct`.`product_id`, `CategoriesProduct`.`category_id` FROM `lenjerieerotica_ro`.`categories` AS `Category` JOIN `lenjerieerotica_ro`.`categories_products` AS `CategoriesProduct` ON (`CategoriesProduct`.`product_id` = 782 AND `CategoriesProduct`.`category_id` = `Category`.`id`) | 1 | 1 | 0 | |
SELECT `Category`.`lft`, `Category`.`rght` FROM `lenjerieerotica_ro`.`categories` AS `Category` WHERE `Category`.`id` = 11 LIMIT 1 | 1 | 1 | 0 | |
SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`name`, `Category`.`slug` FROM `lenjerieerotica_ro`.`categories` AS `Category` WHERE 1 = 1 AND `Category`.`lft` <= 28 AND `Category`.`rght` >= 29 ORDER BY `Category`.`lft` asc | 2 | 2 | 0 | |
SELECT `Category`.`id` FROM `lenjerieerotica_ro`.`categories` AS `Category` WHERE `id` = 11 LIMIT 1 | 1 | 1 | 0 | |
SELECT `RelatedCategory`.`id`, `CategoryToCategory`.`category_id`, `CategoryToCategory`.`related_id` FROM `lenjerieerotica_ro`.`categories` AS `RelatedCategory` JOIN `lenjerieerotica_ro`.`category_to_categories` AS `CategoryToCategory` ON (`CategoryToCategory`.`category_id` = 11 AND `CategoryToCategory`.`related_id` = `RelatedCategory`.`id`) | 0 | 0 | 0 | |
SELECT `RelatedCategoryProduct`.`id`, `CategoryRelatedProduct`.`category_id`, `CategoryRelatedProduct`.`product_id` FROM `lenjerieerotica_ro`.`products` AS `RelatedCategoryProduct` JOIN `lenjerieerotica_ro`.`category_related_products` AS `CategoryRelatedProduct` ON (`CategoryRelatedProduct`.`category_id` = 11 AND `CategoryRelatedProduct`.`product_id` = `RelatedCategoryProduct`.`id`) WHERE `status` = '1' | 0 | 0 | 0 | |
SELECT `Product`.`id` FROM `lenjerieerotica_ro`.`products` AS `Product` WHERE `Product`.`id` = 782 LIMIT 1 | 1 | 1 | 0 | |
SELECT `Category`.`id`, `Category`.`name`, `Category`.`slug`, `CategoriesProduct`.`product_id`, `CategoriesProduct`.`category_id` FROM `lenjerieerotica_ro`.`categories` AS `Category` JOIN `lenjerieerotica_ro`.`categories_products` AS `CategoriesProduct` ON (`CategoriesProduct`.`product_id` = 782 AND `CategoriesProduct`.`category_id` = `Category`.`id`) | 1 | 1 | 0 | |
SELECT `Category`.`lft`, `Category`.`rght` FROM `lenjerieerotica_ro`.`categories` AS `Category` WHERE `Category`.`id` = 11 LIMIT 1 | 1 | 1 | 0 | |
SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`name`, `Category`.`slug` FROM `lenjerieerotica_ro`.`categories` AS `Category` WHERE 1 = 1 AND `Category`.`lft` <= 28 AND `Category`.`rght` >= 29 ORDER BY `Category`.`lft` asc | 2 | 2 | 0 | |
SELECT `Category`.`id` FROM `lenjerieerotica_ro`.`categories` AS `Category` WHERE `Category`.`id` = 11 AND `status` = '1' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Product`.`id`, `Product`.`display_name`, `Product`.`slug`, `Product`.`image`, `Product`.`price`, `Product`.`temp_1`, `CategoriesProduct`.`product_id`, `CategoriesProduct`.`category_id` FROM `lenjerieerotica_ro`.`products` AS `Product` JOIN `lenjerieerotica_ro`.`categories_products` AS `CategoriesProduct` ON (`CategoriesProduct`.`category_id` = 11 AND `CategoriesProduct`.`product_id` = `Product`.`id`) WHERE NOT (`Product`.`id` = 782) AND `Product`.`status` = '1' ORDER BY RAND() ASC LIMIT 4 | 4 | 4 | 4 | |
SELECT `ProductDiscount`.`price`, `ProductDiscount`.`id`, `ProductDiscount`.`product_id` FROM `lenjerieerotica_ro`.`product_discounts` AS `ProductDiscount` WHERE `ProductDiscount`.`product_id` = (6646) LIMIT 1 | 0 | 0 | 0 | |
SELECT `ProductDiscount`.`price`, `ProductDiscount`.`id`, `ProductDiscount`.`product_id` FROM `lenjerieerotica_ro`.`product_discounts` AS `ProductDiscount` WHERE `ProductDiscount`.`product_id` = (5195) LIMIT 1 | 0 | 0 | 0 | |
SELECT `ProductDiscount`.`price`, `ProductDiscount`.`id`, `ProductDiscount`.`product_id` FROM `lenjerieerotica_ro`.`product_discounts` AS `ProductDiscount` WHERE `ProductDiscount`.`product_id` = (5504) LIMIT 1 | 0 | 0 | 0 | |
SELECT `ProductDiscount`.`price`, `ProductDiscount`.`id`, `ProductDiscount`.`product_id` FROM `lenjerieerotica_ro`.`product_discounts` AS `ProductDiscount` WHERE `ProductDiscount`.`product_id` = (4952) LIMIT 1 | 0 | 0 | 0 | |
UPDATE `lenjerieerotica_ro`.`products` AS `Product` SET `Product`.`views` = `Product`.`views` + 1 WHERE `Product`.`id` = 782 | 1 | 1 | 0 | |
SELECT `Product`.`id`, `Product`.`display_name`, `Product`.`slug`, `Product`.`image`, `Product`.`temp_1`, `Product`.`price` FROM `lenjerieerotica_ro`.`products` AS `Product` WHERE id = (782) AND `status` = '1' ORDER BY FIND_IN_SET(id, '782') desc LIMIT 6 | 0 | 0 | 0 | |
SELECT DISTINCT(product_id) FROM `lenjerieerotica_ro`.`product_discounts` AS `ProductDiscount` LEFT JOIN `lenjerieerotica_ro`.`products` AS `Product` ON (`ProductDiscount`.`product_id` = `Product`.`id`) WHERE 1 = 1 | 33 | 33 | 0 | |
SELECT `Product`.`id`, `Product`.`display_name`, `Product`.`slug`, `Product`.`price`, `Product`.`image`, `Product`.`temp_1` FROM `lenjerieerotica_ro`.`products` AS `Product` WHERE id IN (94, 95, 97, 98, 100, 101, 304, 305, 684, 688, 689, 692, 693, 698, 699, 700, 701, 702, 704, 755, 758, 770, 927, 985, 987, 5863, 5872, 5874, 6011, 6032, 6215, 6268, 6326) AND `status` = '1' ORDER BY RAND() ASC LIMIT 4 | 2 | 2 | 1 | maybe slow |
SELECT `ProductDiscount`.`price`, `ProductDiscount`.`product_id` FROM `lenjerieerotica_ro`.`product_discounts` AS `ProductDiscount` WHERE `ProductDiscount`.`product_id` = (97) LIMIT 1 | 1 | 1 | 0 | |
SELECT `ProductDiscount`.`price`, `ProductDiscount`.`product_id` FROM `lenjerieerotica_ro`.`product_discounts` AS `ProductDiscount` WHERE `ProductDiscount`.`product_id` = (95) LIMIT 1 | 1 | 1 | 0 | |