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.0015730857849121 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)
Command completed in 0.00058293342590332 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)
ORDER BY `product`.`new` DESC, `product`.`name` ASC
LIMIT 12 OFFSET 24
Command completed in 0.0060970783233643 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 ('57', '63', '71', '515', '519', '523', '503', '509', '665', '667', '669', '363')
ORDER BY `variant`.`ordinal` ASC, `variant`.`name` ASC, `variant`.`id` ASC
Command completed in 0.0015039443969727 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 ('57', '63', '71', '515', '519', '523', '503', '509', '665', '667', '669', '363')
Command completed in 0.0011100769042969 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', '21', '29', '29', '29', '29', '29', '49', '49', '49')
ORDER BY `category`.`parent` ASC, `category`.`ordinal` ASC, `category`.`name` ASC, `category`.`id` ASC
Command completed in 0.0012168884277344 seconds - 4 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 ('57', '63', '71', '515', '519', '523', '503', '509', '665', '667', '669', '363')
ORDER BY `product_image`.`ordinal` ASC, `product_image`.`name` ASC, `product_image`.`id` ASC
Command completed in 0.0010888576507568 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 ('57', '63', '71', '515', '519', '523', '503', '509', '665', '667', '669', '363')
ORDER BY `variant`.`ordinal` ASC, `variant`.`name` ASC, `variant`.`id` ASC
Command completed in 0.00084996223449707 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 ('57', '63', '71', '515', '519', '523', '503', '509', '665', '667', '669', '363')
Command completed in 0.00069379806518555 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', '21', '29', '29', '29', '29', '29', '49', '49', '49')
ORDER BY `category`.`parent` ASC, `category`.`ordinal` ASC, `category`.`name` ASC, `category`.`id` ASC
Command completed in 0.00084400177001953 seconds - 4 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 ('25', '29', '17', '29', '57', '65', '21', '39', '273', '163', '235', '181')
ORDER BY `color`.`name` ASC, `color`.`id` ASC
Command completed in 0.0011439323425293 seconds - 11 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.00066781044006348 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.00070095062255859 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.00060391426086426 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.0017430782318115 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.001533031463623 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.0011382102966309 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.0011279582977295 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.0010380744934082 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.0017211437225342 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` = '349'
ORDER BY `variant`.`ordinal` ASC, `variant`.`name` ASC, `variant`.`id` ASC
LIMIT 1
Command completed in 0.00067996978759766 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` = '383'
ORDER BY `variant`.`ordinal` ASC, `variant`.`name` ASC, `variant`.`id` ASC
LIMIT 1
Command completed in 0.0010290145874023 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.000762939453125 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` = '61'
ORDER BY `variant`.`ordinal` ASC, `variant`.`name` ASC, `variant`.`id` ASC
LIMIT 1
Command completed in 0.001060962677002 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` = '657'
ORDER BY `variant`.`ordinal` ASC, `variant`.`name` ASC, `variant`.`id` ASC
LIMIT 1
Command completed in 0.00064706802368164 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` = '453'
ORDER BY `variant`.`ordinal` ASC, `variant`.`name` ASC, `variant`.`id` ASC
LIMIT 1
Command completed in 0.0010299682617188 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` = '373'
ORDER BY `variant`.`ordinal` ASC, `variant`.`name` ASC, `variant`.`id` ASC
LIMIT 1
Command completed in 0.00073909759521484 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` = '495'
ORDER BY `variant`.`ordinal` ASC, `variant`.`name` ASC, `variant`.`id` ASC
LIMIT 1
Command completed in 0.00074601173400879 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.0016870498657227 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' LIKE `label`.`path`)
ORDER BY `label`.`name` ASC, `label`.`path` ASC
Command completed in 0.00097799301147461 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.00063896179199219 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.00060582160949707 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.0017399787902832 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.00142502784729 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.0010089874267578 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.0011360645294189 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.0010371208190918 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.00090909004211426 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.00081491470336914 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.0008699893951416 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.00083518028259277 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.0010778903961182 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.0011482238769531 seconds - 6 row(s) affected.
