Query | Affected | Num. rows | Took (ms) | Actions |
---|
SELECT `Shop`.`id`, `Shop`.`slug` FROM `lenjerieerotica_ro`.`shops` AS `Shop` WHERE 1 = 1 | 2 | 2 | 0 | |
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 `Setting`.`id`, `Setting`.`shop_id`, `Setting`.`group`, `Setting`.`key`, `Setting`.`value`, `Setting`.`serialized` FROM `lenjerieerotica_ro`.`settings` AS `Setting` WHERE 1 = 1 | 153 | 153 | 0 | |
SELECT `Layout`.`id`, `Layout`.`name` FROM `lenjerieerotica_ro`.`layouts` AS `Layout` WHERE 1 = 1 | 15 | 15 | 0 | |
SELECT `LayoutRoute`.`id`, `LayoutRoute`.`layout_id`, `LayoutRoute`.`store_id`, `LayoutRoute`.`route` FROM `lenjerieerotica_ro`.`layout_routes` AS `LayoutRoute` WHERE `LayoutRoute`.`store_id` = 0 AND `LayoutRoute`.`layout_id` IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15) | 11 | 11 | 0 | |
SELECT `Layout`.`name`, `Layout`.`id` FROM `lenjerieerotica_ro`.`layouts` AS `Layout` WHERE 1 = 1 | 15 | 15 | 0 | |
SELECT `Language`.`id`, `Language`.`name`, `Language`.`code`, `Language`.`locale`, `Language`.`image`, `Language`.`directory`, `Language`.`filename`, `Language`.`sort_order`, `Language`.`status` FROM `lenjerieerotica_ro`.`languages` AS `Language` WHERE `status` = '1' ORDER BY `sort_order` asc | 1 | 1 | 0 | |
SELECT `Currency`.`id`, `Currency`.`title`, `Currency`.`code`, `Currency`.`symbol_left`, `Currency`.`symbol_right`, `Currency`.`decimal_place`, `Currency`.`value`, `Currency`.`status`, `Currency`.`modified` FROM `lenjerieerotica_ro`.`currencies` AS `Currency` WHERE `status` = '1' | 3 | 3 | 0 | |
SELECT `Article`.`id`, `Article`.`member_id`, `Article`.`title`, `Article`.`slug`, `Article`.`subtitle`, `Article`.`text`, `Article`.`image`, `Article`.`views`, `Article`.`created`, `Article`.`modified`, `Article`.`comment_count`, `Member`.`id`, `Member`.`group_id`, `Member`.`store_id`, `Member`.`language_id`, `Member`.`firstname`, `Member`.`lastname`, `Member`.`username`, `Member`.`slug`, `Member`.`email`, `Member`.`phone_number`, `Member`.`fax`, `Member`.`password`, `Member`.`cart`, `Member`.`wishlist`, `Member`.`newsletter`, `Member`.`address_id`, `Member`.`customer_group_id`, `Member`.`ip`, `Member`.`status`, `Member`.`approved`, `Member`.`hide_username`, `Member`.`token`, `Member`.`confirmation_code`, `Member`.`created`, `Member`.`modified` FROM `lenjerieerotica_ro`.`articles` AS `Article` LEFT JOIN `lenjerieerotica_ro`.`members` AS `Member` ON (`Article`.`member_id` = `Member`.`id`) WHERE `Article`.`slug` = 'ghid-marimi' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Comment`.`id`, `Comment`.`member_id`, `Comment`.`product_id`, `Comment`.`article_id`, `Comment`.`status`, `Comment`.`rating`, `Comment`.`title`, `Comment`.`text`, `Comment`.`created`, `Comment`.`modified` FROM `lenjerieerotica_ro`.`comments` AS `Comment` WHERE `Comment`.`article_id` = (60) ORDER BY `id` desc | 0 | 0 | 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` = 60 AND `Tagged`.`tag_id` = `Tag`.`id`) WHERE `Tagged`.`model` = 'Article' | 0 | 0 | 0 | |
UPDATE `lenjerieerotica_ro`.`articles` AS `Article` SET `Article`.`views` = `Article`.`views` + 1 WHERE `Article`.`id` = 60 | 1 | 1 | 0 | |
SELECT Tagged.tag_id, Tag.id, Tag.identifier, Tag.name, Tag.keyname, Tag.weight, COUNT(*) AS occurrence, `Tag`.`id` FROM `lenjerieerotica_ro`.`tagged` AS `Tagged` LEFT JOIN `lenjerieerotica_ro`.`tags` AS `Tag` ON (`Tagged`.`tag_id` = `Tag`.`id`) WHERE 1 = 1 GROUP BY `Tagged`.`tag_id`, `Tag`.`id`, `Tag`.`identifier`, `Tag`.`name`, `Tag`.`keyname`, `Tag`.`weight` | 214 | 214 | 4 | |
SELECT `Article`.`title`, `Article`.`slug` FROM `lenjerieerotica_ro`.`articles` AS `Article` WHERE NOT (`Article`.`id` = 60) ORDER BY RAND() ASC LIMIT 4 | 0 | 0 | 0 | |
SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`sort_order`, `Category`.`name`, `Category`.`slug`, `Category`.`status`, `Category`.`banner`, `Category`.`views` FROM `lenjerieerotica_ro`.`categories` AS `Category` WHERE `Category`.`status` = '1' ORDER BY `sort_order` asc, `lft` asc | 23 | 23 | 0 | |
SELECT `Product`.`id`, `Product`.`display_name`, `Product`.`slug`, `Product`.`image`, `Product`.`temp_1`, `Product`.`price` FROM `lenjerieerotica_ro`.`products` AS `Product` WHERE `status` = '1' ORDER BY RAND() ASC LIMIT 6 | 6 | 6 | 5 | maybe slow |
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` = (95) LIMIT 1 | 1 | 1 | 0 | |
SELECT `ProductDiscount`.`price`, `ProductDiscount`.`product_id` FROM `lenjerieerotica_ro`.`product_discounts` AS `ProductDiscount` WHERE `ProductDiscount`.`product_id` = (97) LIMIT 1 | 1 | 1 | 0 | |
Ai deja un cont?
Te poti autentifica si cu
Nu ai un cont inca?