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.0016388893127441 seconds - 46 row(s) affected.
SELECT COUNT(*)
FROM `product`
WHERE `product`.`discard` IS FALSE
AND `product`.`publish` IS TRUE
AND `product`.`id` IN (
SELECT product_id
FROM `variant`
WHERE `variant`.`discard` IS FALSE
AND `variant`.`publish` IS TRUE)
AND `product`.`id` IN (
SELECT `product_id`
FROM `variant`
WHERE `variant`.`color_id` IN (
SELECT `id`
FROM `color`
WHERE `color`.`color` IN ('Gold')))
Command completed in 0.0036540031433105 seconds - 1 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 (
SELECT product_id
FROM `variant`
WHERE `variant`.`discard` IS FALSE
AND `variant`.`publish` IS TRUE)
AND `product`.`id` IN (
SELECT `product_id`
FROM `variant`
WHERE `variant`.`color_id` IN (
SELECT `id`
FROM `color`
WHERE `color`.`color` IN ('Gold')))
ORDER BY `product`.`new` DESC, `product`.`name` ASC
LIMIT 12
Command completed in 0.0050230026245117 seconds - 12 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 ('67', '337', '603', '549', '63', '515', '137', '263', '267', '283', '65', '517')
ORDER BY `variant`.`ordinal` ASC, `variant`.`name` ASC, `variant`.`id` ASC
Command completed in 0.0014641284942627 seconds - 12 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 ('67', '337', '603', '549', '63', '515', '137', '263', '267', '283', '65', '517')
Command completed in 0.001101016998291 seconds - 12 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 ('3', '3', '3', '7', '13', '15', '15', '19', '29', '29', '35', '43')
ORDER BY `category`.`parent` ASC, `category`.`ordinal` ASC, `category`.`name` ASC, `category`.`id` ASC
Command completed in 0.0012550354003906 seconds - 8 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 ('67', '337', '603', '549', '63', '515', '137', '263', '267', '283', '65', '517')
ORDER BY `product_image`.`ordinal` ASC, `product_image`.`name` ASC, `product_image`.`id` ASC
Command completed in 0.0010349750518799 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 ('67', '337', '603', '549', '63', '515', '137', '263', '267', '283', '65', '517')
ORDER BY `variant`.`ordinal` ASC, `variant`.`name` ASC, `variant`.`id` ASC
Command completed in 0.00077700614929199 seconds - 12 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 ('67', '337', '603', '549', '63', '515', '137', '263', '267', '283', '65', '517')
Command completed in 0.00064587593078613 seconds - 12 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 ('3', '3', '3', '7', '13', '15', '15', '19', '29', '29', '35', '43')
ORDER BY `category`.`parent` ASC, `category`.`ordinal` ASC, `category`.`name` ASC, `category`.`id` ASC
Command completed in 0.0007929801940918 seconds - 8 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 ('29', '29', '237', '219', '29', '29', '29', '95', '99', '115', '29', '29')
ORDER BY `color`.`name` ASC, `color`.`id` ASC
Command completed in 0.00098800659179688 seconds - 6 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.0006108283996582 seconds - 12 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`.`parent` = 0
ORDER BY `category`.`name` ASC
Command completed in 0.00063395500183105 seconds - 26 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.00050997734069824 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.0016698837280273 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.0014770030975342 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.0011651515960693 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.001121997833252 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.0010309219360352 seconds - 0 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
ORDER BY `product`.`name` ASC
Command completed in 0.0016980171203613 seconds - 263 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`
WHERE `color_group`.`name` IN ('Gold')
ORDER BY `color_group`.`ordinal` ASC, `color_group`.`name` ASC, `color_group`.`id` ASC
Command completed in 0.00095605850219727 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` = '573'
ORDER BY `variant`.`ordinal` ASC, `variant`.`name` ASC, `variant`.`id` ASC
LIMIT 1
Command completed in 0.0010848045349121 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` = '559'
ORDER BY `variant`.`ordinal` ASC, `variant`.`name` ASC, `variant`.`id` ASC
LIMIT 1
Command completed in 0.0011458396911621 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` = '409'
ORDER BY `variant`.`ordinal` ASC, `variant`.`name` ASC, `variant`.`id` ASC
LIMIT 1
Command completed in 0.00074100494384766 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` = '333'
ORDER BY `variant`.`ordinal` ASC, `variant`.`name` ASC, `variant`.`id` ASC
LIMIT 1
Command completed in 0.001101016998291 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` = '569'
ORDER BY `variant`.`ordinal` ASC, `variant`.`name` ASC, `variant`.`id` ASC
LIMIT 1
Command completed in 0.0011200904846191 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` = '205'
ORDER BY `variant`.`ordinal` ASC, `variant`.`name` ASC, `variant`.`id` ASC
LIMIT 1
Command completed in 0.0010659694671631 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` = '527'
ORDER BY `variant`.`ordinal` ASC, `variant`.`name` ASC, `variant`.`id` ASC
LIMIT 1
Command completed in 0.00063896179199219 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` = '493'
ORDER BY `variant`.`ordinal` ASC, `variant`.`name` ASC, `variant`.`id` ASC
LIMIT 1
Command completed in 0.00071978569030762 seconds - 1 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
ORDER BY `product`.`name` ASC
Command completed in 0.0016911029815674 seconds - 263 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/colour/Gold' LIKE `label`.`path`)
ORDER BY `label`.`name` ASC, `label`.`path` ASC
Command completed in 0.00364089012146 seconds - 304 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.00072693824768066 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.00060677528381348 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.0017869472503662 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.0013220310211182 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.0011320114135742 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.0010850429534912 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.0010809898376465 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.000823974609375 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.00075507164001465 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.00083088874816895 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.0007321834564209 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.0011630058288574 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.00099897384643555 seconds - 6 row(s) affected.
