| 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 `4love_ro`.`shops` AS `Shop` LEFT JOIN `4love_ro`.`sellers` AS `Seller` ON (`Shop`.`seller_id` = `Seller`.`id`) WHERE `slug` = '4love' LIMIT 1 | 0 | 0 | 0 | |
| SELECT `Category`.`slug`, `Category`.`name` FROM `4love_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`.`description_ai`, `Product`.`modified_ai`, `Product`.`meta_description`, `Product`.`meta_keywords`, `Product`.`uuid`, `Product`.`sku`, `Product`.`upc`, `Product`.`internal_code`, `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`.`date_available`, `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`, `Product`.`adult`, `Manufacturer`.`id`, `Manufacturer`.`name`, `Manufacturer`.`slug`, `Manufacturer`.`image`, `Manufacturer`.`sort_order`, `Manufacturer`.`status`, `StockStatus`.`name` FROM `4love_ro`.`products` AS `Product` LEFT JOIN `4love_ro`.`manufacturers` AS `Manufacturer` ON (`Product`.`manufacturer_id` = `Manufacturer`.`id`) LEFT JOIN `4love_ro`.`stock_statuses` AS `StockStatus` ON (`Product`.`stock_status_id` = `StockStatus`.`id` AND language_id = 1) WHERE `Product`.`slug` = 'lovense-usb-bluetooth-adapter' LIMIT 1 | 1 | 1 | 1 | |
| SELECT `AttributeValue`.`id`, `AttributeValue`.`attribute_id`, `AttributeValue`.`value`, `AttributeValue`.`entity_id` FROM `4love_ro`.`attribute_values` AS `AttributeValue` WHERE `AttributeValue`.`model` = 'Product' AND `AttributeValue`.`entity_id` = (18298) ORDER BY `id` asc | 0 | 0 | 0 | |
| SELECT `ProductDiscount`.`price`, `ProductDiscount`.`product_id` FROM `4love_ro`.`product_discounts` AS `ProductDiscount` WHERE ((((`ProductDiscount`.`end_date` >= NOW()) OR (`ProductDiscount`.`end_date` = '0000-00-00'))) AND (((`ProductDiscount`.`start_date` <= NOW()) OR (`ProductDiscount`.`start_date` = '0000-00-00')))) AND `ProductDiscount`.`product_id` = (18298) LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Comment`.`id`, `Comment`.`text`, `Comment`.`rating`, `Comment`.`created`, `Comment`.`title`, `Comment`.`member_id`, `Comment`.`product_id` FROM `4love_ro`.`comments` AS `Comment` WHERE `Comment`.`status` = '1' AND `Comment`.`verified` = '1' AND `Comment`.`product_id` = (18298) ORDER BY `id` desc | 25 | 25 | 15 | maybe slow |
| SELECT `Member`.`id`, `Member`.`username` FROM `4love_ro`.`members` AS `Member` WHERE `Member`.`id` = 34212 | 1 | 1 | 0 | |
| SELECT `Member`.`id`, `Member`.`username` FROM `4love_ro`.`members` AS `Member` WHERE `Member`.`id` = 34191 | 1 | 1 | 0 | |
| SELECT `Member`.`id`, `Member`.`username` FROM `4love_ro`.`members` AS `Member` WHERE `Member`.`id` = 33752 | 0 | 0 | 0 | |
| SELECT `Member`.`id`, `Member`.`username` FROM `4love_ro`.`members` AS `Member` WHERE `Member`.`id` = 33491 | 0 | 0 | 0 | |
| SELECT `Member`.`id`, `Member`.`username` FROM `4love_ro`.`members` AS `Member` WHERE `Member`.`id` = 33377 | 1 | 1 | 0 | |
| SELECT `Member`.`id`, `Member`.`username` FROM `4love_ro`.`members` AS `Member` WHERE `Member`.`id` = 33020 | 1 | 1 | 0 | |
| SELECT `Member`.`id`, `Member`.`username` FROM `4love_ro`.`members` AS `Member` WHERE `Member`.`id` = 32068 | 1 | 1 | 0 | |
| SELECT `Member`.`id`, `Member`.`username` FROM `4love_ro`.`members` AS `Member` WHERE `Member`.`id` = 31884 | 1 | 1 | 0 | |
| SELECT `Member`.`id`, `Member`.`username` FROM `4love_ro`.`members` AS `Member` WHERE `Member`.`id` = 31796 | 1 | 1 | 0 | |
| SELECT `Member`.`id`, `Member`.`username` FROM `4love_ro`.`members` AS `Member` WHERE `Member`.`id` = 31734 | 0 | 0 | 0 | |
| SELECT `Member`.`id`, `Member`.`username` FROM `4love_ro`.`members` AS `Member` WHERE `Member`.`id` = 31672 | 0 | 0 | 0 | |
| SELECT `Member`.`id`, `Member`.`username` FROM `4love_ro`.`members` AS `Member` WHERE `Member`.`id` = 31660 | 1 | 1 | 0 | |
| SELECT `Member`.`id`, `Member`.`username` FROM `4love_ro`.`members` AS `Member` WHERE `Member`.`id` = 31637 | 1 | 1 | 0 | |
| SELECT `Member`.`id`, `Member`.`username` FROM `4love_ro`.`members` AS `Member` WHERE `Member`.`id` = 31535 | 0 | 0 | 0 | |
| SELECT `Member`.`id`, `Member`.`username` FROM `4love_ro`.`members` AS `Member` WHERE `Member`.`id` = 31511 | 0 | 0 | 0 | |
| SELECT `Member`.`id`, `Member`.`username` FROM `4love_ro`.`members` AS `Member` WHERE `Member`.`id` = 31496 | 0 | 0 | 0 | |
| SELECT `Member`.`id`, `Member`.`username` FROM `4love_ro`.`members` AS `Member` WHERE `Member`.`id` = 31491 | 0 | 0 | 0 | |
| SELECT `Member`.`id`, `Member`.`username` FROM `4love_ro`.`members` AS `Member` WHERE `Member`.`id` = 31448 | 0 | 0 | 0 | |
| SELECT `Member`.`id`, `Member`.`username` FROM `4love_ro`.`members` AS `Member` WHERE `Member`.`id` = 31420 | 0 | 0 | 0 | |
| SELECT `Member`.`id`, `Member`.`username` FROM `4love_ro`.`members` AS `Member` WHERE `Member`.`id` = 31390 | 0 | 0 | 0 | |
| SELECT `Member`.`id`, `Member`.`username` FROM `4love_ro`.`members` AS `Member` WHERE `Member`.`id` = 31371 | 0 | 0 | 0 | |
| SELECT `Member`.`id`, `Member`.`username` FROM `4love_ro`.`members` AS `Member` WHERE `Member`.`id` = 31356 | 1 | 1 | 0 | |
| SELECT `Member`.`id`, `Member`.`username` FROM `4love_ro`.`members` AS `Member` WHERE `Member`.`id` = 31150 | 0 | 0 | 0 | |
| SELECT `Member`.`id`, `Member`.`username` FROM `4love_ro`.`members` AS `Member` WHERE `Member`.`id` = 31137 | 1 | 1 | 0 | |
| SELECT `Member`.`id`, `Member`.`username` FROM `4love_ro`.`members` AS `Member` WHERE `Member`.`id` = 23607 | 1 | 1 | 0 | |
| SELECT `ProductImage`.`id`, `ProductImage`.`product_id`, `ProductImage`.`image`, `ProductImage`.`sort_order`, `ProductImage`.`size`, `ProductImage`.`main_image`, `ProductImage`.`label`, `ProductImage`.`deleted_at` FROM `4love_ro`.`product_images` AS `ProductImage` WHERE `main_image` <> 1 AND `ProductImage`.`product_id` = (18298) | 1 | 1 | 11 | maybe slow |
| 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 `4love_ro`.`products` AS `ProductRelated` JOIN `4love_ro`.`related_products` AS `RelatedProduct` ON (`RelatedProduct`.`product_id` = 18298 AND `RelatedProduct`.`related_id` = `ProductRelated`.`id`) LIMIT 3 | 0 | 0 | 0 | |
| SELECT `ProductRelatedCategory`.`id`, `ProductRelatedCategory`.`name`, `ProductCategoriesRelation`.`category_id`, `ProductCategoriesRelation`.`model_id` FROM `4love_ro`.`categories` AS `ProductRelatedCategory` JOIN `4love_ro`.`product_categories_relations` AS `ProductCategoriesRelation` ON (`ProductCategoriesRelation`.`model_id` = 18298 AND `ProductCategoriesRelation`.`category_id` = `ProductRelatedCategory`.`id`) | 0 | 0 | 0 | |
| SELECT `Category`.`id`, `CategoriesProduct`.`product_id`, `CategoriesProduct`.`category_id` FROM `4love_ro`.`categories` AS `Category` JOIN `4love_ro`.`categories_products` AS `CategoriesProduct` ON (`CategoriesProduct`.`product_id` = 18298 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 `4love_ro`.`tags` AS `Tag` JOIN `4love_ro`.`tagged` AS `Tagged` ON (`Tagged`.`foreign_key` = 18298 AND `Tagged`.`tag_id` = `Tag`.`id`) WHERE `Tagged`.`model` = 'Product' | 0 | 0 | 0 | |
| SELECT `Product`.`id` FROM `4love_ro`.`products` AS `Product` WHERE `Product`.`id` = 18298 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Category`.`id`, `Category`.`name`, `Category`.`slug`, `CategoriesProduct`.`product_id`, `CategoriesProduct`.`category_id` FROM `4love_ro`.`categories` AS `Category` JOIN `4love_ro`.`categories_products` AS `CategoriesProduct` ON (`CategoriesProduct`.`product_id` = 18298 AND `CategoriesProduct`.`category_id` = `Category`.`id`) | 1 | 1 | 0 | |
| SELECT `Category`.`lft`, `Category`.`rght` FROM `4love_ro`.`categories` AS `Category` WHERE `Category`.`id` = 132 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`name`, `Category`.`slug` FROM `4love_ro`.`categories` AS `Category` WHERE 1 = 1 AND `Category`.`lft` <= 251 AND `Category`.`rght` >= 252 ORDER BY `Category`.`lft` asc | 3 | 3 | 0 | |
| SELECT `Product`.`id` FROM `4love_ro`.`products` AS `Product` WHERE `id` = 18298 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `ProductRelated`.`id`, `RelatedProduct`.`product_id`, `RelatedProduct`.`related_id` FROM `4love_ro`.`products` AS `ProductRelated` JOIN `4love_ro`.`related_products` AS `RelatedProduct` ON (`RelatedProduct`.`product_id` = 18298 AND `RelatedProduct`.`related_id` = `ProductRelated`.`id`) WHERE `status` = '1' | 0 | 0 | 0 | |
| SELECT `Product`.`id` FROM `4love_ro`.`products` AS `Product` WHERE `id` = 18298 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `ProductRelatedCategory`.`id`, `ProductRelatedCategory`.`name`, `ProductCategoriesRelation`.`category_id`, `ProductCategoriesRelation`.`model_id` FROM `4love_ro`.`categories` AS `ProductRelatedCategory` JOIN `4love_ro`.`product_categories_relations` AS `ProductCategoriesRelation` ON (`ProductCategoriesRelation`.`model_id` = 18298 AND `ProductCategoriesRelation`.`category_id` = `ProductRelatedCategory`.`id`) | 0 | 0 | 0 | |
| SELECT `Product`.`id` FROM `4love_ro`.`products` AS `Product` WHERE `Product`.`id` = 18298 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Category`.`id`, `Category`.`name`, `Category`.`slug`, `CategoriesProduct`.`product_id`, `CategoriesProduct`.`category_id` FROM `4love_ro`.`categories` AS `Category` JOIN `4love_ro`.`categories_products` AS `CategoriesProduct` ON (`CategoriesProduct`.`product_id` = 18298 AND `CategoriesProduct`.`category_id` = `Category`.`id`) | 1 | 1 | 0 | |
| SELECT `Category`.`lft`, `Category`.`rght` FROM `4love_ro`.`categories` AS `Category` WHERE `Category`.`id` = 132 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`name`, `Category`.`slug` FROM `4love_ro`.`categories` AS `Category` WHERE 1 = 1 AND `Category`.`lft` <= 251 AND `Category`.`rght` >= 252 ORDER BY `Category`.`lft` asc | 3 | 3 | 0 | |
| SELECT `Category`.`id` FROM `4love_ro`.`categories` AS `Category` WHERE `id` = 132 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `RelatedCategory`.`id`, `CategoryToCategory`.`category_id`, `CategoryToCategory`.`related_id` FROM `4love_ro`.`categories` AS `RelatedCategory` JOIN `4love_ro`.`category_to_categories` AS `CategoryToCategory` ON (`CategoryToCategory`.`category_id` = 132 AND `CategoryToCategory`.`related_id` = `RelatedCategory`.`id`) | 0 | 0 | 0 | |
| SELECT `RelatedCategoryProduct`.`id`, `CategoryRelatedProduct`.`category_id`, `CategoryRelatedProduct`.`product_id` FROM `4love_ro`.`products` AS `RelatedCategoryProduct` JOIN `4love_ro`.`category_related_products` AS `CategoryRelatedProduct` ON (`CategoryRelatedProduct`.`category_id` = 132 AND `CategoryRelatedProduct`.`product_id` = `RelatedCategoryProduct`.`id`) WHERE `status` = '1' | 0 | 0 | 0 | |
| SELECT `Product`.`id` FROM `4love_ro`.`products` AS `Product` WHERE `Product`.`id` = 18298 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Category`.`id`, `Category`.`name`, `Category`.`slug`, `CategoriesProduct`.`product_id`, `CategoriesProduct`.`category_id` FROM `4love_ro`.`categories` AS `Category` JOIN `4love_ro`.`categories_products` AS `CategoriesProduct` ON (`CategoriesProduct`.`product_id` = 18298 AND `CategoriesProduct`.`category_id` = `Category`.`id`) | 1 | 1 | 0 | |
| SELECT `Category`.`lft`, `Category`.`rght` FROM `4love_ro`.`categories` AS `Category` WHERE `Category`.`id` = 132 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`name`, `Category`.`slug` FROM `4love_ro`.`categories` AS `Category` WHERE 1 = 1 AND `Category`.`lft` <= 251 AND `Category`.`rght` >= 252 ORDER BY `Category`.`lft` asc | 3 | 3 | 0 | |
| SELECT `Category`.`id` FROM `4love_ro`.`categories` AS `Category` WHERE `Category`.`id` = 132 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 `4love_ro`.`products` AS `Product` JOIN `4love_ro`.`categories_products` AS `CategoriesProduct` ON (`CategoriesProduct`.`category_id` = 132 AND `CategoriesProduct`.`product_id` = `Product`.`id`) WHERE NOT (`Product`.`id` = 18298) AND `Product`.`status` = '1' ORDER BY RAND() ASC LIMIT 5 | 5 | 5 | 1 | maybe slow |
| SELECT `ProductDiscount`.`price`, `ProductDiscount`.`id`, `ProductDiscount`.`product_id` FROM `4love_ro`.`product_discounts` AS `ProductDiscount` WHERE ((((`ProductDiscount`.`end_date` >= NOW()) OR (`ProductDiscount`.`end_date` = '0000-00-00'))) AND (((`ProductDiscount`.`start_date` <= NOW()) OR (`ProductDiscount`.`start_date` = '0000-00-00')))) AND `ProductDiscount`.`product_id` = (36960) LIMIT 1 | 1 | 1 | 0 | |
| SELECT `ProductDiscount`.`price`, `ProductDiscount`.`id`, `ProductDiscount`.`product_id` FROM `4love_ro`.`product_discounts` AS `ProductDiscount` WHERE ((((`ProductDiscount`.`end_date` >= NOW()) OR (`ProductDiscount`.`end_date` = '0000-00-00'))) AND (((`ProductDiscount`.`start_date` <= NOW()) OR (`ProductDiscount`.`start_date` = '0000-00-00')))) AND `ProductDiscount`.`product_id` = (24186) LIMIT 1 | 1 | 1 | 0 | |
| SELECT `ProductDiscount`.`price`, `ProductDiscount`.`id`, `ProductDiscount`.`product_id` FROM `4love_ro`.`product_discounts` AS `ProductDiscount` WHERE ((((`ProductDiscount`.`end_date` >= NOW()) OR (`ProductDiscount`.`end_date` = '0000-00-00'))) AND (((`ProductDiscount`.`start_date` <= NOW()) OR (`ProductDiscount`.`start_date` = '0000-00-00')))) AND `ProductDiscount`.`product_id` = (38110) LIMIT 1 | 1 | 1 | 0 | |
| SELECT `ProductDiscount`.`price`, `ProductDiscount`.`id`, `ProductDiscount`.`product_id` FROM `4love_ro`.`product_discounts` AS `ProductDiscount` WHERE ((((`ProductDiscount`.`end_date` >= NOW()) OR (`ProductDiscount`.`end_date` = '0000-00-00'))) AND (((`ProductDiscount`.`start_date` <= NOW()) OR (`ProductDiscount`.`start_date` = '0000-00-00')))) AND `ProductDiscount`.`product_id` = (29239) LIMIT 1 | 1 | 1 | 0 | |
| SELECT `ProductDiscount`.`price`, `ProductDiscount`.`id`, `ProductDiscount`.`product_id` FROM `4love_ro`.`product_discounts` AS `ProductDiscount` WHERE ((((`ProductDiscount`.`end_date` >= NOW()) OR (`ProductDiscount`.`end_date` = '0000-00-00'))) AND (((`ProductDiscount`.`start_date` <= NOW()) OR (`ProductDiscount`.`start_date` = '0000-00-00')))) AND `ProductDiscount`.`product_id` = (21656) LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Product`.`id` FROM `4love_ro`.`products` AS `Product` WHERE `id` = 18298 LIMIT 1 | 1 | 1 | 1 | |
| SELECT `ProductRelated`.`id`, `RelatedProduct`.`product_id`, `RelatedProduct`.`related_id` FROM `4love_ro`.`products` AS `ProductRelated` JOIN `4love_ro`.`related_products` AS `RelatedProduct` ON (`RelatedProduct`.`product_id` = 18298 AND `RelatedProduct`.`related_id` = `ProductRelated`.`id`) WHERE `status` = '1' | 0 | 0 | 0 | |
| SELECT `Product`.`id` FROM `4love_ro`.`products` AS `Product` WHERE `id` = 18298 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `ProductRelatedCategory`.`id`, `ProductRelatedCategory`.`name`, `ProductCategoriesRelation`.`category_id`, `ProductCategoriesRelation`.`model_id` FROM `4love_ro`.`categories` AS `ProductRelatedCategory` JOIN `4love_ro`.`product_categories_relations` AS `ProductCategoriesRelation` ON (`ProductCategoriesRelation`.`model_id` = 18298 AND `ProductCategoriesRelation`.`category_id` = `ProductRelatedCategory`.`id`) | 0 | 0 | 0 | |
| SELECT `Product`.`id` FROM `4love_ro`.`products` AS `Product` WHERE `Product`.`id` = 18298 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Category`.`id`, `Category`.`name`, `Category`.`slug`, `CategoriesProduct`.`product_id`, `CategoriesProduct`.`category_id` FROM `4love_ro`.`categories` AS `Category` JOIN `4love_ro`.`categories_products` AS `CategoriesProduct` ON (`CategoriesProduct`.`product_id` = 18298 AND `CategoriesProduct`.`category_id` = `Category`.`id`) | 1 | 1 | 0 | |
| SELECT `Category`.`lft`, `Category`.`rght` FROM `4love_ro`.`categories` AS `Category` WHERE `Category`.`id` = 132 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`name`, `Category`.`slug` FROM `4love_ro`.`categories` AS `Category` WHERE 1 = 1 AND `Category`.`lft` <= 251 AND `Category`.`rght` >= 252 ORDER BY `Category`.`lft` asc | 3 | 3 | 0 | |
| SELECT `Category`.`id` FROM `4love_ro`.`categories` AS `Category` WHERE `id` = 132 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `RelatedCategory`.`id`, `CategoryToCategory`.`category_id`, `CategoryToCategory`.`related_id` FROM `4love_ro`.`categories` AS `RelatedCategory` JOIN `4love_ro`.`category_to_categories` AS `CategoryToCategory` ON (`CategoryToCategory`.`category_id` = 132 AND `CategoryToCategory`.`related_id` = `RelatedCategory`.`id`) | 0 | 0 | 0 | |
| SELECT `RelatedCategoryProduct`.`id`, `CategoryRelatedProduct`.`category_id`, `CategoryRelatedProduct`.`product_id` FROM `4love_ro`.`products` AS `RelatedCategoryProduct` JOIN `4love_ro`.`category_related_products` AS `CategoryRelatedProduct` ON (`CategoryRelatedProduct`.`category_id` = 132 AND `CategoryRelatedProduct`.`product_id` = `RelatedCategoryProduct`.`id`) WHERE `status` = '1' | 0 | 0 | 0 | |
| SELECT `Category`.`id` FROM `4love_ro`.`categories` AS `Category` WHERE `Category`.`id` = 132 AND `Category`.`status` = '1' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Product`.`id`, `Product`.`name`, `Product`.`display_name`, `Product`.`slug`, `Product`.`price`, `Product`.`image`, `Product`.`temp_1`, `CategoriesProduct`.`product_id`, `CategoriesProduct`.`category_id` FROM `4love_ro`.`products` AS `Product` JOIN `4love_ro`.`categories_products` AS `CategoriesProduct` ON (`CategoriesProduct`.`category_id` = 132 AND `CategoriesProduct`.`product_id` = `Product`.`id`) WHERE `Product`.`status` = '1' AND NOT (`Product`.`id` = (18298)) ORDER BY `Product`.`id` desc LIMIT 5 | 5 | 5 | 1 | maybe slow |
| SELECT `Product`.`id`, `Product`.`name`, `Product`.`display_name`, `Product`.`slug`, `Product`.`price`, `Product`.`image`, `Product`.`temp_1` FROM `4love_ro`.`products` AS `Product` WHERE `Product`.`id` IN (38628, 38627, 38626, 38314, 38313) AND `Product`.`status` = '1' LIMIT 5 | 5 | 5 | 0 | |
| SELECT `ProductDiscount`.`id`, `ProductDiscount`.`price`, `ProductDiscount`.`product_id` FROM `4love_ro`.`product_discounts` AS `ProductDiscount` WHERE ((((`ProductDiscount`.`end_date` >= NOW()) OR (`ProductDiscount`.`end_date` = '0000-00-00'))) AND (((`ProductDiscount`.`start_date` <= NOW()) OR (`ProductDiscount`.`start_date` = '0000-00-00')))) AND `ProductDiscount`.`product_id` = (38313) LIMIT 1 | 1 | 1 | 0 | |
| SELECT `ProductDiscount`.`id`, `ProductDiscount`.`price`, `ProductDiscount`.`product_id` FROM `4love_ro`.`product_discounts` AS `ProductDiscount` WHERE ((((`ProductDiscount`.`end_date` >= NOW()) OR (`ProductDiscount`.`end_date` = '0000-00-00'))) AND (((`ProductDiscount`.`start_date` <= NOW()) OR (`ProductDiscount`.`start_date` = '0000-00-00')))) AND `ProductDiscount`.`product_id` = (38314) LIMIT 1 | 1 | 1 | 0 | |
| SELECT `ProductDiscount`.`id`, `ProductDiscount`.`price`, `ProductDiscount`.`product_id` FROM `4love_ro`.`product_discounts` AS `ProductDiscount` WHERE ((((`ProductDiscount`.`end_date` >= NOW()) OR (`ProductDiscount`.`end_date` = '0000-00-00'))) AND (((`ProductDiscount`.`start_date` <= NOW()) OR (`ProductDiscount`.`start_date` = '0000-00-00')))) AND `ProductDiscount`.`product_id` = (38626) LIMIT 1 | 1 | 1 | 0 | |
| SELECT `ProductDiscount`.`id`, `ProductDiscount`.`price`, `ProductDiscount`.`product_id` FROM `4love_ro`.`product_discounts` AS `ProductDiscount` WHERE ((((`ProductDiscount`.`end_date` >= NOW()) OR (`ProductDiscount`.`end_date` = '0000-00-00'))) AND (((`ProductDiscount`.`start_date` <= NOW()) OR (`ProductDiscount`.`start_date` = '0000-00-00')))) AND `ProductDiscount`.`product_id` = (38627) LIMIT 1 | 1 | 1 | 0 | |
| SELECT `ProductDiscount`.`id`, `ProductDiscount`.`price`, `ProductDiscount`.`product_id` FROM `4love_ro`.`product_discounts` AS `ProductDiscount` WHERE ((((`ProductDiscount`.`end_date` >= NOW()) OR (`ProductDiscount`.`end_date` = '0000-00-00'))) AND (((`ProductDiscount`.`start_date` <= NOW()) OR (`ProductDiscount`.`start_date` = '0000-00-00')))) AND `ProductDiscount`.`product_id` = (38628) LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Manufacturer`.`id`, `Manufacturer`.`name`, `Manufacturer`.`slug`, `Manufacturer`.`image`, `Manufacturer`.`sort_order`, `Manufacturer`.`status` FROM `4love_ro`.`manufacturers` AS `Manufacturer` WHERE `Manufacturer`.`status` = 1 ORDER BY `name` ASC | 47 | 47 | 0 | |
| SELECT COUNT(*) AS `count` FROM `4love_ro`.`products` AS `Product` WHERE `Product`.`manufacturer_id` = 106 AND `Product`.`status` = '1' | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `4love_ro`.`products` AS `Product` WHERE `Product`.`manufacturer_id` = 110 AND `Product`.`status` = '1' | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `4love_ro`.`products` AS `Product` WHERE `Product`.`manufacturer_id` = 35 AND `Product`.`status` = '1' | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `4love_ro`.`products` AS `Product` WHERE `Product`.`manufacturer_id` = 36 AND `Product`.`status` = '1' | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `4love_ro`.`products` AS `Product` WHERE `Product`.`manufacturer_id` = 37 AND `Product`.`status` = '1' | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `4love_ro`.`products` AS `Product` WHERE `Product`.`manufacturer_id` = 38 AND `Product`.`status` = '1' | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `4love_ro`.`products` AS `Product` WHERE `Product`.`manufacturer_id` = 126 AND `Product`.`status` = '1' | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `4love_ro`.`products` AS `Product` WHERE `Product`.`manufacturer_id` = 75 AND `Product`.`status` = '1' | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `4love_ro`.`products` AS `Product` WHERE `Product`.`manufacturer_id` = 70 AND `Product`.`status` = '1' | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `4love_ro`.`products` AS `Product` WHERE `Product`.`manufacturer_id` = 98 AND `Product`.`status` = '1' | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `4love_ro`.`products` AS `Product` WHERE `Product`.`manufacturer_id` = 108 AND `Product`.`status` = '1' | 1 | 1 | 3 | maybe slow |
| SELECT COUNT(*) AS `count` FROM `4love_ro`.`products` AS `Product` WHERE `Product`.`manufacturer_id` = 107 AND `Product`.`status` = '1' | 1 | 1 | 2 | maybe slow |
| SELECT COUNT(*) AS `count` FROM `4love_ro`.`products` AS `Product` WHERE `Product`.`manufacturer_id` = 64 AND `Product`.`status` = '1' | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `4love_ro`.`products` AS `Product` WHERE `Product`.`manufacturer_id` = 31 AND `Product`.`status` = '1' | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `4love_ro`.`products` AS `Product` WHERE `Product`.`manufacturer_id` = 42 AND `Product`.`status` = '1' | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `4love_ro`.`products` AS `Product` WHERE `Product`.`manufacturer_id` = 128 AND `Product`.`status` = '1' | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `4love_ro`.`products` AS `Product` WHERE `Product`.`manufacturer_id` = 123 AND `Product`.`status` = '1' | 1 | 1 | 2 | maybe slow |
| SELECT COUNT(*) AS `count` FROM `4love_ro`.`products` AS `Product` WHERE `Product`.`manufacturer_id` = 125 AND `Product`.`status` = '1' | 1 | 1 | 2 | maybe slow |
| SELECT COUNT(*) AS `count` FROM `4love_ro`.`products` AS `Product` WHERE `Product`.`manufacturer_id` = 122 AND `Product`.`status` = '1' | 1 | 1 | 2 | maybe slow |
| SELECT COUNT(*) AS `count` FROM `4love_ro`.`products` AS `Product` WHERE `Product`.`manufacturer_id` = 89 AND `Product`.`status` = '1' | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `4love_ro`.`products` AS `Product` WHERE `Product`.`manufacturer_id` = 32 AND `Product`.`status` = '1' | 1 | 1 | 2 | maybe slow |
| SELECT COUNT(*) AS `count` FROM `4love_ro`.`products` AS `Product` WHERE `Product`.`manufacturer_id` = 104 AND `Product`.`status` = '1' | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `4love_ro`.`products` AS `Product` WHERE `Product`.`manufacturer_id` = 102 AND `Product`.`status` = '1' | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `4love_ro`.`products` AS `Product` WHERE `Product`.`manufacturer_id` = 83 AND `Product`.`status` = '1' | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `4love_ro`.`products` AS `Product` WHERE `Product`.`manufacturer_id` = 96 AND `Product`.`status` = '1' | 1 | 1 | 2 | maybe slow |
| SELECT COUNT(*) AS `count` FROM `4love_ro`.`products` AS `Product` WHERE `Product`.`manufacturer_id` = 127 AND `Product`.`status` = '1' | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `4love_ro`.`products` AS `Product` WHERE `Product`.`manufacturer_id` = 116 AND `Product`.`status` = '1' | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `4love_ro`.`products` AS `Product` WHERE `Product`.`manufacturer_id` = 95 AND `Product`.`status` = '1' | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `4love_ro`.`products` AS `Product` WHERE `Product`.`manufacturer_id` = 129 AND `Product`.`status` = '1' | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `4love_ro`.`products` AS `Product` WHERE `Product`.`manufacturer_id` = 124 AND `Product`.`status` = '1' | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `4love_ro`.`products` AS `Product` WHERE `Product`.`manufacturer_id` = 47 AND `Product`.`status` = '1' | 1 | 1 | 2 | maybe slow |
| SELECT COUNT(*) AS `count` FROM `4love_ro`.`products` AS `Product` WHERE `Product`.`manufacturer_id` = 90 AND `Product`.`status` = '1' | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `4love_ro`.`products` AS `Product` WHERE `Product`.`manufacturer_id` = 49 AND `Product`.`status` = '1' | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `4love_ro`.`products` AS `Product` WHERE `Product`.`manufacturer_id` = 112 AND `Product`.`status` = '1' | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `4love_ro`.`products` AS `Product` WHERE `Product`.`manufacturer_id` = 130 AND `Product`.`status` = '1' | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `4love_ro`.`products` AS `Product` WHERE `Product`.`manufacturer_id` = 50 AND `Product`.`status` = '1' | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `4love_ro`.`products` AS `Product` WHERE `Product`.`manufacturer_id` = 51 AND `Product`.`status` = '1' | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `4love_ro`.`products` AS `Product` WHERE `Product`.`manufacturer_id` = 109 AND `Product`.`status` = '1' | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `4love_ro`.`products` AS `Product` WHERE `Product`.`manufacturer_id` = 101 AND `Product`.`status` = '1' | 1 | 1 | 2 | maybe slow |
| SELECT COUNT(*) AS `count` FROM `4love_ro`.`products` AS `Product` WHERE `Product`.`manufacturer_id` = 111 AND `Product`.`status` = '1' | 1 | 1 | 3 | maybe slow |
| SELECT COUNT(*) AS `count` FROM `4love_ro`.`products` AS `Product` WHERE `Product`.`manufacturer_id` = 54 AND `Product`.`status` = '1' | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `4love_ro`.`products` AS `Product` WHERE `Product`.`manufacturer_id` = 105 AND `Product`.`status` = '1' | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `4love_ro`.`products` AS `Product` WHERE `Product`.`manufacturer_id` = 103 AND `Product`.`status` = '1' | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `4love_ro`.`products` AS `Product` WHERE `Product`.`manufacturer_id` = 55 AND `Product`.`status` = '1' | 1 | 1 | 2 | maybe slow |
| SELECT COUNT(*) AS `count` FROM `4love_ro`.`products` AS `Product` WHERE `Product`.`manufacturer_id` = 118 AND `Product`.`status` = '1' | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `4love_ro`.`products` AS `Product` WHERE `Product`.`manufacturer_id` = 97 AND `Product`.`status` = '1' | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `4love_ro`.`products` AS `Product` WHERE `Product`.`manufacturer_id` = 63 AND `Product`.`status` = '1' | 1 | 1 | 1 | |
| SELECT `Product`.`id`, `Product`.`display_name`, `Product`.`slug`, `Product`.`image`, `Product`.`temp_1` FROM `4love_ro`.`products` AS `Product` WHERE id = (18298) AND `status` = '1' ORDER BY FIND_IN_SET(id, '18298') desc | 1 | 1 | 0 | |
Ai deja un cont?
Nu ai un cont inca?