SELECT (`product`.`id`) AS `id`,
(`product`.`name`) AS `name`,
(`product`.`category`) AS `category`,
(`product`.`title`) AS `title`,
(`product`.`summary`) AS `summary`,
(`product`.`product_price`) AS `product_price`,
(`product`.`content`) AS `content`,
(`product`.`tax_rate_id`) AS `tax_rate_id`,
(`product`.`style_id`) AS `style_id`,
(`product`.`new`) AS `new`,
(`product`.`color_id`) AS `color_id`,
(`product`.`extra_heavy_domestic`) AS `extra_heavy_domestic`,
(`product`.`heavy_domestic`) AS `heavy_domestic`,
(`product`.`commercial`) AS `commercial`,
(`product`.`lounge`) AS `lounge`,
(`product`.`dining`) AS `dining`,
(`product`.`stairs`) AS `stairs`,
(`product`.`bedroom`) AS `bedroom`,
(`product`.`exclusivity`) AS `exclusivity`,
(`product`.`construction`) AS `construction`,
(`product`.`tog`) AS `tog`,
(`product`.`pile_content`) AS `pile_content`,
(`product`.`pattern_repeat`) AS `pattern_repeat`,
(`product`.`width`) AS `width`,
(`product`.`meta_title`) AS `meta_title`,
(`product`.`meta_description`) AS `meta_description`,
(`product`.`star`) AS `star`,
(`product`.`publish`) AS `publish`,
(`product`.`discard`) AS `discard`,
(`product`.`updated`) AS `updated`,
(
SELECT `image`
FROM `product_image`
WHERE `product_image`.`discard` IS FALSE
AND `product_image`.`publish` IS TRUE
AND `product_image`.`product_id` = `product`.`id`
ORDER BY `product_image`.`ordinal` ASC
LIMIT 1) AS `image`,
(
SELECT MIN(price)
FROM `variant`
WHERE `variant`.`discard` IS FALSE
AND `variant`.`publish` IS TRUE
AND `variant`.`product_id` = `product`.`id`) AS `price`
FROM `product`
WHERE `product`.`id` = '163'
AND `product`.`discard` IS FALSE
AND `product`.`publish` IS TRUE
Command completed in 0.0024192333221436 seconds - 1 row(s) affected.
SELECT (`variant`.`id`) AS `id`,
(`variant`.`product_id`) AS `product_id`,
(`variant`.`name`) AS `name`,
(`variant`.`ordinal`) AS `ordinal`,
(`variant`.`sku`) AS `sku`,
(`variant`.`image`) AS `image`,
(`variant`.`color_id`) AS `color_id`,
(`variant`.`price`) AS `price`,
(`variant`.`publish`) AS `publish`,
(`variant`.`discard`) AS `discard`,
(`variant`.`updated`) AS `updated`,
(`product`.`tax_rate_id`) AS `tax_rate_id`
FROM `variant`
INNER JOIN `product` ON `product`.`id` = `variant`.`product_id`
WHERE `variant`.`discard` IS FALSE
AND `variant`.`publish` IS TRUE
AND `variant`.`product_id` IN ('163')
ORDER BY `variant`.`ordinal` ASC, `variant`.`name` ASC, `variant`.`id` ASC
Command completed in 0.0010719299316406 seconds - 1 row(s) affected.
SELECT (`category_product`.`category_id`) AS `category_id`,
(`category_product`.`product_id`) AS `product_id`,
(`category_product`.`ordinal`) AS `ordinal`
FROM `category_product`
WHERE `category_product`.`product_id` IN ('163')
Command completed in 0.0010731220245361 seconds - 1 row(s) affected.
SELECT (`category`.`id`) AS `id`,
(`category`.`parent`) AS `parent`,
(`category`.`ordinal`) AS `ordinal`,
(`category`.`name`) AS `name`,
(`category`.`title`) AS `title`,
(`category`.`summary`) AS `summary`,
(`category`.`content`) AS `content`,
(`category`.`image`) AS `image`,
(`category`.`meta_title`) AS `meta_title`,
(`category`.`meta_description`) AS `meta_description`,
(`category`.`publish`) AS `publish`,
(`category`.`discard`) AS `discard`,
(`category`.`updated`) AS `updated`
FROM `category`
WHERE `category`.`discard` IS FALSE
AND `category`.`publish` IS TRUE
AND `category`.`id` IN ('9')
ORDER BY `category`.`parent` ASC, `category`.`ordinal` ASC, `category`.`name` ASC, `category`.`id` ASC
Command completed in 0.00069594383239746 seconds - 1 row(s) affected.
SELECT (`product_image`.`id`) AS `id`,
(`product_image`.`product_id`) AS `product_id`,
(`product_image`.`ordinal`) AS `ordinal`,
(`product_image`.`name`) AS `name`,
(`product_image`.`title`) AS `title`,
(`product_image`.`image`) AS `image`,
(`product_image`.`publish`) AS `publish`,
(`product_image`.`discard`) AS `discard`,
(`product_image`.`updated`) AS `updated`
FROM `product_image`
WHERE `product_image`.`discard` IS FALSE
AND `product_image`.`publish` IS TRUE
AND `product_image`.`product_id` IN ('163')
ORDER BY `product_image`.`ordinal` ASC, `product_image`.`name` ASC, `product_image`.`id` ASC
Command completed in 0.00091695785522461 seconds - 0 row(s) affected.
SELECT (`variant`.`id`) AS `id`,
(`variant`.`product_id`) AS `product_id`,
(`variant`.`name`) AS `name`,
(`variant`.`ordinal`) AS `ordinal`,
(`variant`.`sku`) AS `sku`,
(`variant`.`image`) AS `image`,
(`variant`.`color_id`) AS `color_id`,
(`variant`.`price`) AS `price`,
(`variant`.`publish`) AS `publish`,
(`variant`.`discard`) AS `discard`,
(`variant`.`updated`) AS `updated`,
(`product`.`tax_rate_id`) AS `tax_rate_id`
FROM `variant`
INNER JOIN `product` ON `product`.`id` = `variant`.`product_id`
WHERE `variant`.`discard` IS FALSE
AND `variant`.`publish` IS TRUE
AND `variant`.`product_id` IN ('163')
ORDER BY `variant`.`ordinal` ASC, `variant`.`name` ASC, `variant`.`id` ASC
Command completed in 0.00080204010009766 seconds - 1 row(s) affected.
SELECT (`category_product`.`category_id`) AS `category_id`,
(`category_product`.`product_id`) AS `product_id`,
(`category_product`.`ordinal`) AS `ordinal`
FROM `category_product`
WHERE `category_product`.`product_id` IN ('163')
Command completed in 0.00065112113952637 seconds - 1 row(s) affected.
SELECT (`category`.`id`) AS `id`,
(`category`.`parent`) AS `parent`,
(`category`.`ordinal`) AS `ordinal`,
(`category`.`name`) AS `name`,
(`category`.`title`) AS `title`,
(`category`.`summary`) AS `summary`,
(`category`.`content`) AS `content`,
(`category`.`image`) AS `image`,
(`category`.`meta_title`) AS `meta_title`,
(`category`.`meta_description`) AS `meta_description`,
(`category`.`publish`) AS `publish`,
(`category`.`discard`) AS `discard`,
(`category`.`updated`) AS `updated`
FROM `category`
WHERE `category`.`discard` IS FALSE
AND `category`.`publish` IS TRUE
AND `category`.`id` IN ('9')
ORDER BY `category`.`parent` ASC, `category`.`ordinal` ASC, `category`.`name` ASC, `category`.`id` ASC
Command completed in 0.00087094306945801 seconds - 1 row(s) affected.
SELECT (`product_image`.`id`) AS `id`,
(`product_image`.`product_id`) AS `product_id`,
(`product_image`.`ordinal`) AS `ordinal`,
(`product_image`.`name`) AS `name`,
(`product_image`.`title`) AS `title`,
(`product_image`.`image`) AS `image`,
(`product_image`.`publish`) AS `publish`,
(`product_image`.`discard`) AS `discard`,
(`product_image`.`updated`) AS `updated`
FROM `product_image`
WHERE `product_image`.`discard` IS FALSE
AND `product_image`.`publish` IS TRUE
AND `product_image`.`product_id` IN ('163')
ORDER BY `product_image`.`ordinal` ASC, `product_image`.`name` ASC, `product_image`.`id` ASC
Command completed in 0.00078105926513672 seconds - 0 row(s) affected.
SELECT (`color`.`id`) AS `id`,
(`color`.`name`) AS `name`,
(`color`.`color`) AS `color`,
(`color`.`publish`) AS `publish`
FROM `color`
WHERE `color`.`publish` IS TRUE
AND `color`.`id` IN ('39')
ORDER BY `color`.`name` ASC, `color`.`id` ASC
Command completed in 0.00063514709472656 seconds - 1 row(s) affected.
SELECT (`category`.`id`) AS `id`,
(`category`.`parent`) AS `parent`,
(`category`.`ordinal`) AS `ordinal`,
(`category`.`name`) AS `name`,
(`category`.`title`) AS `title`,
(`category`.`summary`) AS `summary`,
(`category`.`content`) AS `content`,
(`category`.`image`) AS `image`,
(`category`.`meta_title`) AS `meta_title`,
(`category`.`meta_description`) AS `meta_description`,
(`category`.`publish`) AS `publish`,
(`category`.`discard`) AS `discard`,
(`category`.`updated`) AS `updated`
FROM `category`
WHERE `category`.`discard` IS FALSE
AND `category`.`publish` IS TRUE
AND `category`.`id` IN ('9')
ORDER BY `category`.`parent` ASC, `category`.`ordinal` ASC, `category`.`name` ASC, `category`.`id` ASC
Command completed in 0.00069999694824219 seconds - 1 row(s) affected.
SELECT (`category_product`.`category_id`) AS `category_id`,
(`category_product`.`product_id`) AS `product_id`,
(`category_product`.`ordinal`) AS `ordinal`
FROM `category_product`
WHERE `category_product`.`category_id` IN ('9')
Command completed in 0.0005640983581543 seconds - 26 row(s) affected.
SELECT (`product`.`id`) AS `id`,
(`product`.`name`) AS `name`,
(`product`.`category`) AS `category`,
(`product`.`title`) AS `title`,
(`product`.`summary`) AS `summary`,
(`product`.`product_price`) AS `product_price`,
(`product`.`content`) AS `content`,
(`product`.`tax_rate_id`) AS `tax_rate_id`,
(`product`.`style_id`) AS `style_id`,
(`product`.`new`) AS `new`,
(`product`.`color_id`) AS `color_id`,
(`product`.`extra_heavy_domestic`) AS `extra_heavy_domestic`,
(`product`.`heavy_domestic`) AS `heavy_domestic`,
(`product`.`commercial`) AS `commercial`,
(`product`.`lounge`) AS `lounge`,
(`product`.`dining`) AS `dining`,
(`product`.`stairs`) AS `stairs`,
(`product`.`bedroom`) AS `bedroom`,
(`product`.`exclusivity`) AS `exclusivity`,
(`product`.`construction`) AS `construction`,
(`product`.`tog`) AS `tog`,
(`product`.`pile_content`) AS `pile_content`,
(`product`.`pattern_repeat`) AS `pattern_repeat`,
(`product`.`width`) AS `width`,
(`product`.`meta_title`) AS `meta_title`,
(`product`.`meta_description`) AS `meta_description`,
(`product`.`star`) AS `star`,
(`product`.`publish`) AS `publish`,
(`product`.`discard`) AS `discard`,
(`product`.`updated`) AS `updated`,
(
SELECT `image`
FROM `product_image`
WHERE `product_image`.`discard` IS FALSE
AND `product_image`.`publish` IS TRUE
AND `product_image`.`product_id` = `product`.`id`
ORDER BY `product_image`.`ordinal` ASC
LIMIT 1) AS `image`,
(
SELECT MIN(price)
FROM `variant`
WHERE `variant`.`discard` IS FALSE
AND `variant`.`publish` IS TRUE
AND `variant`.`product_id` = `product`.`id`) AS `price`
FROM `product`
WHERE `product`.`discard` IS FALSE
AND `product`.`publish` IS TRUE
AND `product`.`id` IN ('157', '159', '161', '163', '165', '167', '169', '171', '173', '175', '177', '179', '181', '183', '185', '187', '189', '191', '193', '195', '707', '709', '711', '737', '739', '741')
ORDER BY `product`.`name` ASC
Command completed in 0.00118088722229 seconds - 17 row(s) affected.
SELECT (`variant`.`id`) AS `id`,
(`variant`.`product_id`) AS `product_id`,
(`variant`.`name`) AS `name`,
(`variant`.`ordinal`) AS `ordinal`,
(`variant`.`sku`) AS `sku`,
(`variant`.`image`) AS `image`,
(`variant`.`color_id`) AS `color_id`,
(`variant`.`price`) AS `price`,
(`variant`.`publish`) AS `publish`,
(`variant`.`discard`) AS `discard`,
(`variant`.`updated`) AS `updated`,
(`product`.`tax_rate_id`) AS `tax_rate_id`
FROM `variant`
INNER JOIN `product` ON `product`.`id` = `variant`.`product_id`
WHERE `variant`.`discard` IS FALSE
AND `variant`.`publish` IS TRUE
AND `variant`.`product_id` IN ('159', '161', '163', '165', '167', '171', '177', '179', '181', '183', '185', '189', '191', '193', '737', '739', '741')
ORDER BY `variant`.`ordinal` ASC, `variant`.`name` ASC, `variant`.`id` ASC
Command completed in 0.00086498260498047 seconds - 17 row(s) affected.
SELECT (`category_product`.`category_id`) AS `category_id`,
(`category_product`.`product_id`) AS `product_id`,
(`category_product`.`ordinal`) AS `ordinal`
FROM `category_product`
WHERE `category_product`.`product_id` IN ('159', '161', '163', '165', '167', '171', '177', '179', '181', '183', '185', '189', '191', '193', '737', '739', '741')
Command completed in 0.00061392784118652 seconds - 17 row(s) affected.
SELECT (`category`.`id`) AS `id`,
(`category`.`parent`) AS `parent`,
(`category`.`ordinal`) AS `ordinal`,
(`category`.`name`) AS `name`,
(`category`.`title`) AS `title`,
(`category`.`summary`) AS `summary`,
(`category`.`content`) AS `content`,
(`category`.`image`) AS `image`,
(`category`.`meta_title`) AS `meta_title`,
(`category`.`meta_description`) AS `meta_description`,
(`category`.`publish`) AS `publish`,
(`category`.`discard`) AS `discard`,
(`category`.`updated`) AS `updated`
FROM `category`
WHERE `category`.`discard` IS FALSE
AND `category`.`publish` IS TRUE
AND `category`.`id` IN ('9', '9', '9', '9', '9', '9', '9', '9', '9', '9', '9', '9', '9', '9', '9', '9', '9')
ORDER BY `category`.`parent` ASC, `category`.`ordinal` ASC, `category`.`name` ASC, `category`.`id` ASC
Command completed in 0.00073504447937012 seconds - 1 row(s) affected.
SELECT (`product_image`.`id`) AS `id`,
(`product_image`.`product_id`) AS `product_id`,
(`product_image`.`ordinal`) AS `ordinal`,
(`product_image`.`name`) AS `name`,
(`product_image`.`title`) AS `title`,
(`product_image`.`image`) AS `image`,
(`product_image`.`publish`) AS `publish`,
(`product_image`.`discard`) AS `discard`,
(`product_image`.`updated`) AS `updated`
FROM `product_image`
WHERE `product_image`.`discard` IS FALSE
AND `product_image`.`publish` IS TRUE
AND `product_image`.`product_id` IN ('159', '161', '163', '165', '167', '171', '177', '179', '181', '183', '185', '189', '191', '193', '737', '739', '741')
ORDER BY `product_image`.`ordinal` ASC, `product_image`.`name` ASC, `product_image`.`id` ASC
Command completed in 0.00072312355041504 seconds - 0 row(s) affected.
SELECT (`page`.`id`) AS `id`,
(`page`.`parent`) AS `parent`,
(`page`.`ordinal`) AS `ordinal`,
(`page`.`name`) AS `name`,
(`page`.`title`) AS `title`,
(`page`.`subtitle`) AS `subtitle`,
(`page`.`alternate_layout`) AS `alternate_layout`,
(`page`.`summary`) AS `summary`,
(`page`.`content`) AS `content`,
(`page`.`second_content`) AS `second_content`,
(`page`.`image`) AS `image`,
(`page`.`meta_title`) AS `meta_title`,
(`page`.`meta_description`) AS `meta_description`,
(`page`.`static`) AS `static`,
(`page`.`publish`) AS `publish`,
(`page`.`discard`) AS `discard`,
(`page`.`updated`) AS `updated`
FROM `page`
WHERE `page`.`discard` IS FALSE
AND `page`.`publish` IS TRUE
ORDER BY `page`.`parent` ASC, `page`.`ordinal` ASC, `page`.`name` ASC, `page`.`id` ASC
Command completed in 0.001727819442749 seconds - 46 row(s) affected.
SELECT (`label`.`id`) AS `id`,
(`label`.`name`) AS `name`,
(`label`.`path`) AS `path`,
(`label`.`source`) AS `source`,
(`label`.`content`) AS `content`,
(`label`.`block`) AS `block`,
(`label`.`discard`) AS `discard`
FROM `label`
WHERE `label`.`discard` IS FALSE
AND (`label`.`path` = ''
OR '/carpets/163-Moorland%20Tweed' LIKE `label`.`path`)
ORDER BY `label`.`name` ASC, `label`.`path` ASC
Command completed in 0.0040378570556641 seconds - 304 row(s) affected.
SELECT (`color`.`id`) AS `id`,
(`color`.`name`) AS `name`,
(`color`.`color`) AS `color`,
(`color`.`publish`) AS `publish`
FROM `color`
WHERE `color`.`id` = '37'
Command completed in 0.0006260871887207 seconds - 1 row(s) affected.
SELECT (`color`.`id`) AS `id`,
(`color`.`name`) AS `name`,
(`color`.`color`) AS `color`,
(`color`.`publish`) AS `publish`
FROM `color`
WHERE `color`.`id` = '21'
Command completed in 0.00060200691223145 seconds - 1 row(s) affected.
SELECT (`color`.`id`) AS `id`,
(`color`.`name`) AS `name`,
(`color`.`color`) AS `color`,
(`color`.`publish`) AS `publish`
FROM `color`
WHERE `color`.`id` = '39'
Command completed in 0.00063681602478027 seconds - 1 row(s) affected.
SELECT (`color`.`id`) AS `id`,
(`color`.`name`) AS `name`,
(`color`.`color`) AS `color`,
(`color`.`publish`) AS `publish`
FROM `color`
WHERE `color`.`id` = '23'
Command completed in 0.0006251335144043 seconds - 1 row(s) affected.
SELECT (`color`.`id`) AS `id`,
(`color`.`name`) AS `name`,
(`color`.`color`) AS `color`,
(`color`.`publish`) AS `publish`
FROM `color`
WHERE `color`.`id` = '41'
Command completed in 0.0006101131439209 seconds - 1 row(s) affected.
SELECT (`color`.`id`) AS `id`,
(`color`.`name`) AS `name`,
(`color`.`color`) AS `color`,
(`color`.`publish`) AS `publish`
FROM `color`
WHERE `color`.`id` = '45'
Command completed in 0.0005650520324707 seconds - 1 row(s) affected.
SELECT (`color`.`id`) AS `id`,
(`color`.`name`) AS `name`,
(`color`.`color`) AS `color`,
(`color`.`publish`) AS `publish`
FROM `color`
WHERE `color`.`id` = '29'
Command completed in 0.00061488151550293 seconds - 1 row(s) affected.
SELECT (`color`.`id`) AS `id`,
(`color`.`name`) AS `name`,
(`color`.`color`) AS `color`,
(`color`.`publish`) AS `publish`
FROM `color`
WHERE `color`.`id` = '51'
Command completed in 0.00059390068054199 seconds - 1 row(s) affected.
SELECT (`color`.`id`) AS `id`,
(`color`.`name`) AS `name`,
(`color`.`color`) AS `color`,
(`color`.`publish`) AS `publish`
FROM `color`
WHERE `color`.`id` = '53'
Command completed in 0.00055384635925293 seconds - 1 row(s) affected.
SELECT (`color`.`id`) AS `id`,
(`color`.`name`) AS `name`,
(`color`.`color`) AS `color`,
(`color`.`publish`) AS `publish`
FROM `color`
WHERE `color`.`id` = '55'
Command completed in 0.00057315826416016 seconds - 1 row(s) affected.
SELECT (`color`.`id`) AS `id`,
(`color`.`name`) AS `name`,
(`color`.`color`) AS `color`,
(`color`.`publish`) AS `publish`
FROM `color`
WHERE `color`.`id` = '57'
Command completed in 0.00054121017456055 seconds - 1 row(s) affected.
SELECT (`color`.`id`) AS `id`,
(`color`.`name`) AS `name`,
(`color`.`color`) AS `color`,
(`color`.`publish`) AS `publish`
FROM `color`
WHERE `color`.`id` = '61'
Command completed in 0.00055789947509766 seconds - 1 row(s) affected.
SELECT (`color`.`id`) AS `id`,
(`color`.`name`) AS `name`,
(`color`.`color`) AS `color`,
(`color`.`publish`) AS `publish`
FROM `color`
WHERE `color`.`id` = '63'
Command completed in 0.00053691864013672 seconds - 1 row(s) affected.
SELECT (`color`.`id`) AS `id`,
(`color`.`name`) AS `name`,
(`color`.`color`) AS `color`,
(`color`.`publish`) AS `publish`
FROM `color`
WHERE `color`.`id` = '65'
Command completed in 0.00056099891662598 seconds - 1 row(s) affected.
SELECT (`color`.`id`) AS `id`,
(`color`.`name`) AS `name`,
(`color`.`color`) AS `color`,
(`color`.`publish`) AS `publish`
FROM `color`
WHERE `color`.`id` = '301'
Command completed in 0.00055193901062012 seconds - 1 row(s) affected.
SELECT (`color`.`id`) AS `id`,
(`color`.`name`) AS `name`,
(`color`.`color`) AS `color`,
(`color`.`publish`) AS `publish`
FROM `color`
WHERE `color`.`id` = '303'
Command completed in 0.00055599212646484 seconds - 1 row(s) affected.
SELECT (`color`.`id`) AS `id`,
(`color`.`name`) AS `name`,
(`color`.`color`) AS `color`,
(`color`.`publish`) AS `publish`
FROM `color`
WHERE `color`.`id` = '305'
Command completed in 0.00053906440734863 seconds - 1 row(s) affected.
SELECT (`color_group`.`id`) AS `id`,
(`color_group`.`name`) AS `name`,
(`color_group`.`ordinal`) AS `ordinal`,
(`color_group`.`color`) AS `color`,
(`color_group`.`content`) AS `content`,
(`color_group`.`image`) AS `image`
FROM `color_group`
ORDER BY `color_group`.`ordinal` ASC, `color_group`.`name` ASC, `color_group`.`id` ASC
Command completed in 0.00070500373840332 seconds - 12 row(s) affected.
SELECT (`style`.`id`) AS `id`,
(`style`.`name`) AS `name`,
(`style`.`publish`) AS `publish`
FROM `style`
WHERE `style`.`publish` IS TRUE
ORDER BY `style`.`name` ASC, `style`.`id` ASC
Command completed in 0.0005800724029541 seconds - 8 row(s) affected.
SELECT (`product`.`id`) AS `id`,
(`product`.`name`) AS `name`,
(`product`.`category`) AS `category`,
(`product`.`title`) AS `title`,
(`product`.`summary`) AS `summary`,
(`product`.`product_price`) AS `product_price`,
(`product`.`content`) AS `content`,
(`product`.`tax_rate_id`) AS `tax_rate_id`,
(`product`.`style_id`) AS `style_id`,
(`product`.`new`) AS `new`,
(`product`.`color_id`) AS `color_id`,
(`product`.`extra_heavy_domestic`) AS `extra_heavy_domestic`,
(`product`.`heavy_domestic`) AS `heavy_domestic`,
(`product`.`commercial`) AS `commercial`,
(`product`.`lounge`) AS `lounge`,
(`product`.`dining`) AS `dining`,
(`product`.`stairs`) AS `stairs`,
(`product`.`bedroom`) AS `bedroom`,
(`product`.`exclusivity`) AS `exclusivity`,
(`product`.`construction`) AS `construction`,
(`product`.`tog`) AS `tog`,
(`product`.`pile_content`) AS `pile_content`,
(`product`.`pattern_repeat`) AS `pattern_repeat`,
(`product`.`width`) AS `width`,
(`product`.`meta_title`) AS `meta_title`,
(`product`.`meta_description`) AS `meta_description`,
(`product`.`star`) AS `star`,
(`product`.`publish`) AS `publish`,
(`product`.`discard`) AS `discard`,
(`product`.`updated`) AS `updated`,
(
SELECT `image`
FROM `product_image`
WHERE `product_image`.`discard` IS FALSE
AND `product_image`.`publish` IS TRUE
AND `product_image`.`product_id` = `product`.`id`
ORDER BY `product_image`.`ordinal` ASC
LIMIT 1) AS `image`,
(
SELECT MIN(price)
FROM `variant`
WHERE `variant`.`discard` IS FALSE
AND `variant`.`publish` IS TRUE
AND `variant`.`product_id` = `product`.`id`) AS `price`
FROM `product`
WHERE `product`.`discard` IS FALSE
AND `product`.`publish` IS TRUE
AND `product`.`style_id` IN ('7', '1', '13', '3', '9', '11', '5', '15')
ORDER BY `product`.`name` ASC
Command completed in 0.0016951560974121 seconds - 263 row(s) affected.
SELECT (`variant`.`id`) AS `id`,
(`variant`.`product_id`) AS `product_id`,
(`variant`.`name`) AS `name`,
(`variant`.`ordinal`) AS `ordinal`,
(`variant`.`sku`) AS `sku`,
(`variant`.`image`) AS `image`,
(`variant`.`color_id`) AS `color_id`,
(`variant`.`price`) AS `price`,
(`variant`.`publish`) AS `publish`,
(`variant`.`discard`) AS `discard`,
(`variant`.`updated`) AS `updated`,
(`product`.`tax_rate_id`) AS `tax_rate_id`
FROM `variant`
INNER JOIN `product` ON `product`.`id` = `variant`.`product_id`
WHERE `variant`.`discard` IS FALSE
AND `variant`.`publish` IS TRUE
AND `variant`.`product_id` IN ('55', '67', '351', '353', '487', '347', '349', '335', '337', '339', '489', '1', '573', '575', '601', '603', '605', '607', '545', '547', '549', '551', '659', '49', '57', '63', '71', '515', '519', '523', '503', '509', '665', '667', '669', '363', '119', '121', '123', '125', '131', '137', '141', '153', '261', '263', '267', '273', '279', '301', '303', '307', '247', '259', '265', '269', '271', '275', '277', '283', '287', '291', '293', '295', '297', '299', '309', '311', '315', '317', '319', '321', '325', '239', '241', '243', '497', '5', '7', '609', '611', '333', '329', '331', '47', '51', '59', '61', '65', '73', '75', '53', '481', '367', '369', '341', '343', '371', '517', '521', '525', '505', '511', '613', '623', '629', '649', '651', '655', '479', '25', '373', '375', '9', '11', '381', '439', '441', '443', '445', '447', '449', '451', '453', '455', '457', '459', '461', '463', '465', '467', '469', '471', '473', '475', '477', '593', '595', '597', '599', '383', '553', '555', '557', '559', '385', '389', '391', '393', '395', '397', '529', '527', '39', '41', '43', '719', '721', '159', '161', '163', '165', '167', '171', '177', '179', '181', '183', '185', '189', '191', '193', '737', '739', '741', '199', '201', '713', '203', '715', '205', '717', '207', '211', '723', '725', '727', '217', '729', '219', '731', '221', '733', '223', '735', '225', '229', '231', '233', '499', '531', '533', '535', '401', '569', '661', '663', '69', '407', '513', '507', '405', '409', '19', '615', '617', '619', '621', '625', '627', '631', '633', '635', '639', '641', '643', '647', '413', '29', '33', '567', '23', '13', '17', '45', '417', '419', '421', '423', '425', '427', '491', '429', '561', '563', '565', '577', '579', '581', '583', '493', '483', '657', '671', '435', '437', '537', '539', '541', '543', '495', '485', '501')
ORDER BY `variant`.`ordinal` ASC, `variant`.`name` ASC, `variant`.`id` ASC
Command completed in 0.0014410018920898 seconds - 263 row(s) affected.
SELECT (`category_product`.`category_id`) AS `category_id`,
(`category_product`.`product_id`) AS `product_id`,
(`category_product`.`ordinal`) AS `ordinal`
FROM `category_product`
WHERE `category_product`.`product_id` IN ('55', '67', '351', '353', '487', '347', '349', '335', '337', '339', '489', '1', '573', '575', '601', '603', '605', '607', '545', '547', '549', '551', '659', '49', '57', '63', '71', '515', '519', '523', '503', '509', '665', '667', '669', '363', '119', '121', '123', '125', '131', '137', '141', '153', '261', '263', '267', '273', '279', '301', '303', '307', '247', '259', '265', '269', '271', '275', '277', '283', '287', '291', '293', '295', '297', '299', '309', '311', '315', '317', '319', '321', '325', '239', '241', '243', '497', '5', '7', '609', '611', '333', '329', '331', '47', '51', '59', '61', '65', '73', '75', '53', '481', '367', '369', '341', '343', '371', '517', '521', '525', '505', '511', '613', '623', '629', '649', '651', '655', '479', '25', '373', '375', '9', '11', '381', '439', '441', '443', '445', '447', '449', '451', '453', '455', '457', '459', '461', '463', '465', '467', '469', '471', '473', '475', '477', '593', '595', '597', '599', '383', '553', '555', '557', '559', '385', '389', '391', '393', '395', '397', '529', '527', '39', '41', '43', '719', '721', '159', '161', '163', '165', '167', '171', '177', '179', '181', '183', '185', '189', '191', '193', '737', '739', '741', '199', '201', '713', '203', '715', '205', '717', '207', '211', '723', '725', '727', '217', '729', '219', '731', '221', '733', '223', '735', '225', '229', '231', '233', '499', '531', '533', '535', '401', '569', '661', '663', '69', '407', '513', '507', '405', '409', '19', '615', '617', '619', '621', '625', '627', '631', '633', '635', '639', '641', '643', '647', '413', '29', '33', '567', '23', '13', '17', '45', '417', '419', '421', '423', '425', '427', '491', '429', '561', '563', '565', '577', '579', '581', '583', '493', '483', '657', '671', '435', '437', '537', '539', '541', '543', '495', '485', '501')
Command completed in 0.001046895980835 seconds - 263 row(s) affected.
SELECT (`category`.`id`) AS `id`,
(`category`.`parent`) AS `parent`,
(`category`.`ordinal`) AS `ordinal`,
(`category`.`name`) AS `name`,
(`category`.`title`) AS `title`,
(`category`.`summary`) AS `summary`,
(`category`.`content`) AS `content`,
(`category`.`image`) AS `image`,
(`category`.`meta_title`) AS `meta_title`,
(`category`.`meta_description`) AS `meta_description`,
(`category`.`publish`) AS `publish`,
(`category`.`discard`) AS `discard`,
(`category`.`updated`) AS `updated`
FROM `category`
WHERE `category`.`discard` IS FALSE
AND `category`.`publish` IS TRUE
AND `category`.`id` IN ('1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '3', '3', '3', '3', '3', '3', '3', '3', '3', '3', '3', '3', '3', '3', '3', '3', '7', '7', '7', '7', '7', '7', '7', '7', '9', '9', '9', '9', '9', '9', '9', '9', '9', '9', '9', '9', '9', '9', '9', '9', '9', '11', '11', '11', '11', '11', '11', '11', '11', '11', '11', '11', '11', '11', '11', '11', '11', '11', '11', '11', '11', '11', '11', '11', '11', '11', '11', '13', '13', '13', '13', '13', '13', '13', '13', '13', '13', '13', '13', '13', '13', '13', '13', '13', '13', '13', '13', '13', '13', '13', '15', '15', '15', '15', '15', '15', '15', '15', '15', '17', '17', '17', '19', '19', '19', '19', '19', '19', '19', '21', '21', '21', '21', '21', '21', '21', '21', '21', '21', '21', '21', '21', '21', '21', '21', '21', '21', '21', '21', '21', '21', '21', '21', '21', '21', '21', '21', '21', '21', '23', '23', '23', '23', '23', '23', '23', '23', '23', '23', '25', '25', '25', '25', '25', '25', '25', '25', '25', '25', '27', '27', '27', '27', '27', '27', '27', '27', '27', '27', '27', '27', '29', '29', '29', '29', '29', '29', '29', '29', '29', '29', '29', '29', '29', '31', '33', '33', '33', '35', '35', '35', '35', '35', '35', '35', '35', '35', '35', '35', '35', '37', '37', '37', '39', '39', '41', '41', '43', '43', '43', '43', '43', '43', '43', '43', '43', '43', '43', '43', '43', '43', '45', '45', '45', '45', '45', '45', '45', '45', '45', '45', '45', '45', '45', '45', '45', '45', '45', '45', '45', '47', '47', '49', '49', '49', '49', '49', '49')
ORDER BY `category`.`parent` ASC, `category`.`ordinal` ASC, `category`.`name` ASC, `category`.`id` ASC
Command completed in 0.0010929107666016 seconds - 24 row(s) affected.
SELECT (`product_image`.`id`) AS `id`,
(`product_image`.`product_id`) AS `product_id`,
(`product_image`.`ordinal`) AS `ordinal`,
(`product_image`.`name`) AS `name`,
(`product_image`.`title`) AS `title`,
(`product_image`.`image`) AS `image`,
(`product_image`.`publish`) AS `publish`,
(`product_image`.`discard`) AS `discard`,
(`product_image`.`updated`) AS `updated`
FROM `product_image`
WHERE `product_image`.`discard` IS FALSE
AND `product_image`.`publish` IS TRUE
AND `product_image`.`product_id` IN ('55', '67', '351', '353', '487', '347', '349', '335', '337', '339', '489', '1', '573', '575', '601', '603', '605', '607', '545', '547', '549', '551', '659', '49', '57', '63', '71', '515', '519', '523', '503', '509', '665', '667', '669', '363', '119', '121', '123', '125', '131', '137', '141', '153', '261', '263', '267', '273', '279', '301', '303', '307', '247', '259', '265', '269', '271', '275', '277', '283', '287', '291', '293', '295', '297', '299', '309', '311', '315', '317', '319', '321', '325', '239', '241', '243', '497', '5', '7', '609', '611', '333', '329', '331', '47', '51', '59', '61', '65', '73', '75', '53', '481', '367', '369', '341', '343', '371', '517', '521', '525', '505', '511', '613', '623', '629', '649', '651', '655', '479', '25', '373', '375', '9', '11', '381', '439', '441', '443', '445', '447', '449', '451', '453', '455', '457', '459', '461', '463', '465', '467', '469', '471', '473', '475', '477', '593', '595', '597', '599', '383', '553', '555', '557', '559', '385', '389', '391', '393', '395', '397', '529', '527', '39', '41', '43', '719', '721', '159', '161', '163', '165', '167', '171', '177', '179', '181', '183', '185', '189', '191', '193', '737', '739', '741', '199', '201', '713', '203', '715', '205', '717', '207', '211', '723', '725', '727', '217', '729', '219', '731', '221', '733', '223', '735', '225', '229', '231', '233', '499', '531', '533', '535', '401', '569', '661', '663', '69', '407', '513', '507', '405', '409', '19', '615', '617', '619', '621', '625', '627', '631', '633', '635', '639', '641', '643', '647', '413', '29', '33', '567', '23', '13', '17', '45', '417', '419', '421', '423', '425', '427', '491', '429', '561', '563', '565', '577', '579', '581', '583', '493', '483', '657', '671', '435', '437', '537', '539', '541', '543', '495', '485', '501')
ORDER BY `product_image`.`ordinal` ASC, `product_image`.`name` ASC, `product_image`.`id` ASC
Command completed in 0.001101016998291 seconds - 0 row(s) affected.
SELECT (`page`.`id`) AS `id`,
(`page`.`parent`) AS `parent`,
(`page`.`ordinal`) AS `ordinal`,
(`page`.`name`) AS `name`,
(`page`.`title`) AS `title`,
(`page`.`subtitle`) AS `subtitle`,
(`page`.`alternate_layout`) AS `alternate_layout`,
(`page`.`summary`) AS `summary`,
(`page`.`content`) AS `content`,
(`page`.`second_content`) AS `second_content`,
(`page`.`image`) AS `image`,
(`page`.`meta_title`) AS `meta_title`,
(`page`.`meta_description`) AS `meta_description`,
(`page`.`static`) AS `static`,
(`page`.`publish`) AS `publish`,
(`page`.`discard`) AS `discard`,
(`page`.`updated`) AS `updated`
FROM `page`
WHERE `page`.`id` = '27'
AND `page`.`discard` IS FALSE
AND `page`.`publish` IS TRUE
Command completed in 0.00079607963562012 seconds - 1 row(s) affected.
SELECT (`page_image`.`id`) AS `id`,
(`page_image`.`page_id`) AS `page_id`,
(`page_image`.`ordinal`) AS `ordinal`,
(`page_image`.`name`) AS `name`,
(`page_image`.`title`) AS `title`,
(`page_image`.`summary`) AS `summary`,
(`page_image`.`url`) AS `url`,
(`page_image`.`label`) AS `label`,
(`page_image`.`image`) AS `image`,
(`page_image`.`publish`) AS `publish`,
(`page_image`.`discard`) AS `discard`,
(`page_image`.`updated`) AS `updated`
FROM `page_image`
WHERE `page_image`.`discard` IS FALSE
AND `page_image`.`publish` IS TRUE
AND `page_image`.`page_id` IN ('27')
ORDER BY `page_image`.`ordinal` ASC, `page_image`.`name` ASC, `page_image`.`id` ASC
Command completed in 0.00074887275695801 seconds - 4 row(s) affected.
SELECT (`order`.`id`) AS `id`,
(`order`.`session_id`) AS `session_id`,
(`order`.`user_id`) AS `user_id`,
(`order`.`reference`) AS `reference`,
(`order`.`email`) AS `email`,
(`order`.`billing_address_id`) AS `billing_address_id`,
(`order`.`delivery_address_id`) AS `delivery_address_id`,
(`order`.`delivery_instructions`) AS `delivery_instructions`,
(`order`.`notes`) AS `notes`,
(`order`.`analytics_id`) AS `analytics_id`,
(`order`.`subscribe`) AS `subscribe`,
(`order`.`abandon`) AS `abandon`,
(`order`.`confirm`) AS `confirm`,
(`order`.`confirmed`) AS `confirmed`,
(`order`.`complete`) AS `complete`,
(`order`.`completed`) AS `completed`,
(`order`.`discard`) AS `discard`,
(`order`.`created`) AS `created`,
(`order`.`updated`) AS `updated`,
(`order`.`contactAgreed`) AS `contactAgreed`,
(`order`.`designer`) AS `designer`
FROM `order`
WHERE `order`.`discard` IS FALSE
AND `order`.`confirm` IS FALSE
AND `order`.`id` IS NULL
ORDER BY `order`.`created` DESC
LIMIT 1
Command completed in 0.00073719024658203 seconds - 0 row(s) affected.
SELECT (`page`.`id`) AS `id`,
(`page`.`parent`) AS `parent`,
(`page`.`ordinal`) AS `ordinal`,
(`page`.`name`) AS `name`,
(`page`.`title`) AS `title`,
(`page`.`subtitle`) AS `subtitle`,
(`page`.`alternate_layout`) AS `alternate_layout`,
(`page`.`summary`) AS `summary`,
(`page`.`content`) AS `content`,
(`page`.`second_content`) AS `second_content`,
(`page`.`image`) AS `image`,
(`page`.`meta_title`) AS `meta_title`,
(`page`.`meta_description`) AS `meta_description`,
(`page`.`static`) AS `static`,
(`page`.`publish`) AS `publish`,
(`page`.`discard`) AS `discard`,
(`page`.`updated`) AS `updated`
FROM `page`
WHERE `page`.`id` = 23
AND `page`.`discard` IS FALSE
AND `page`.`publish` IS TRUE
Command completed in 0.00077104568481445 seconds - 1 row(s) affected.
SELECT (`article`.`id`) AS `id`,
(`article`.`name`) AS `name`,
(`article`.`title`) AS `title`,
(`article`.`summary`) AS `summary`,
(`article`.`author`) AS `author`,
(`article`.`content`) AS `content`,
(`article`.`second_content`) AS `second_content`,
(`article`.`image`) AS `image`,
(`article`.`meta_title`) AS `meta_title`,
(`article`.`meta_description`) AS `meta_description`,
(`article`.`publish_date`) AS `publish_date`,
(`article`.`publish`) AS `publish`,
(`article`.`discard`) AS `discard`,
(`article`.`updated`) AS `updated`,
(`article`.`hide_date`) AS `hide_date`,
(`article`.`static`) AS `static`
FROM `article`
WHERE `article`.`discard` IS FALSE
AND `article`.`publish` IS TRUE
AND `article`.`publish_date` <= CURRENT_DATE
ORDER BY `article`.`publish_date` DESC, `article`.`id` DESC
LIMIT 6
Command completed in 0.0010800361633301 seconds - 6 row(s) affected.
SELECT (`article`.`id`) AS `id`,
(`article`.`name`) AS `name`,
(`article`.`title`) AS `title`,
(`article`.`summary`) AS `summary`,
(`article`.`author`) AS `author`,
(`article`.`content`) AS `content`,
(`article`.`second_content`) AS `second_content`,
(`article`.`image`) AS `image`,
(`article`.`meta_title`) AS `meta_title`,
(`article`.`meta_description`) AS `meta_description`,
(`article`.`publish_date`) AS `publish_date`,
(`article`.`publish`) AS `publish`,
(`article`.`discard`) AS `discard`,
(`article`.`updated`) AS `updated`,
(`article`.`hide_date`) AS `hide_date`,
(`article`.`static`) AS `static`
FROM `article`
WHERE `article`.`discard` IS FALSE
AND `article`.`publish` IS TRUE
AND `article`.`publish_date` <= CURRENT_DATE
ORDER BY `article`.`publish_date` DESC, `article`.`id` DESC
LIMIT 6
Command completed in 0.0011641979217529 seconds - 6 row(s) affected.
100% Pure New Wool
