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` = '523'
AND `product`.`discard` IS FALSE
AND `product`.`publish` IS TRUE
Command completed in 0.0017471313476562 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 ('523')
ORDER BY `variant`.`ordinal` ASC, `variant`.`name` ASC, `variant`.`id` ASC
Command completed in 0.0011978149414062 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 ('523')
Command completed in 0.0010230541229248 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 ('29')
ORDER BY `category`.`parent` ASC, `category`.`ordinal` ASC, `category`.`name` ASC, `category`.`id` ASC
Command completed in 0.00081491470336914 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 ('523')
ORDER BY `product_image`.`ordinal` ASC, `product_image`.`name` ASC, `product_image`.`id` ASC
Command completed in 0.00093698501586914 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 ('523')
ORDER BY `variant`.`ordinal` ASC, `variant`.`name` ASC, `variant`.`id` ASC
Command completed in 0.0007779598236084 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 ('523')
Command completed in 0.00062012672424316 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 ('29')
ORDER BY `category`.`parent` ASC, `category`.`ordinal` ASC, `category`.`name` ASC, `category`.`id` ASC
Command completed in 0.00069904327392578 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 ('523')
ORDER BY `product_image`.`ordinal` ASC, `product_image`.`name` ASC, `product_image`.`id` ASC
Command completed in 0.00070309638977051 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 ('65')
ORDER BY `color`.`name` ASC, `color`.`id` ASC
Command completed in 0.00075411796569824 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 ('29')
ORDER BY `category`.`parent` ASC, `category`.`ordinal` ASC, `category`.`name` ASC, `category`.`id` ASC
Command completed in 0.00068402290344238 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 ('29')
Command completed in 0.00057792663574219 seconds - 13 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 ('503', '505', '507', '509', '511', '513', '515', '517', '519', '521', '523', '525', '527')
ORDER BY `product`.`name` ASC
Command completed in 0.0010280609130859 seconds - 13 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 ('515', '519', '523', '503', '509', '517', '521', '525', '505', '511', '527', '513', '507')
ORDER BY `variant`.`ordinal` ASC, `variant`.`name` ASC, `variant`.`id` ASC
Command completed in 0.00096702575683594 seconds - 13 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 ('515', '519', '523', '503', '509', '517', '521', '525', '505', '511', '527', '513', '507')
Command completed in 0.00072407722473145 seconds - 13 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 ('29', '29', '29', '29', '29', '29', '29', '29', '29', '29', '29', '29', '29')
ORDER BY `category`.`parent` ASC, `category`.`ordinal` ASC, `category`.`name` ASC, `category`.`id` ASC
Command completed in 0.00074386596679688 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 ('515', '519', '523', '503', '509', '517', '521', '525', '505', '511', '527', '513', '507')
ORDER BY `product_image`.`ordinal` ASC, `product_image`.`name` ASC, `product_image`.`id` ASC
Command completed in 0.00068497657775879 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.0018789768218994 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/523-Crest' LIKE `label`.`path`)
ORDER BY `label`.`name` ASC, `label`.`path` ASC
Command completed in 0.003511905670166 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` = '29'
Command completed in 0.00066804885864258 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.00062704086303711 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.0005791187286377 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.00061798095703125 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.00058197975158691 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.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` = '57'
Command completed in 0.00065708160400391 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.00058293342590332 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.00057578086853027 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.00054407119750977 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.00055980682373047 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.00055813789367676 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.00051283836364746 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.00065994262695312 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.00063705444335938 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.0017189979553223 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.0014228820800781 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.0009620189666748 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.001021146774292 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.00098586082458496 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.00087285041809082 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.00080609321594238 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.00066208839416504 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.00081801414489746 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.0012140274047852 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.0010759830474854 seconds - 6 row(s) affected.
100% Pure New Wool
