| 1 | SELECT `Config`.`key`, `Config`.`value` FROM `acurebd_main`.`configs` AS `Config` WHERE 1 = 1 | | 67 | 67 | 0 |
| 2 | SELECT `Category`.`id`, `Category`.`name`, `Category`.`slug`, `Category`.`product_id` FROM `acurebd_main`.`categories` AS `Category` WHERE `Category`.`status` = '1' AND `Category`.`parent_id` = 0 ORDER BY `Category`.`sequence` ASC | | 12 | 12 | 0 |
| 3 | SELECT `ChildCategory`.`id`, `ChildCategory`.`name`, `ChildCategory`.`slug`, `ChildCategory`.`parent_id` FROM `acurebd_main`.`categories` AS `ChildCategory` WHERE `ChildCategory`.`parent_id` IN (73, 4, 9, 29, 28, 21, 30, 24, 20, 26, 6, 15) | | 40 | 40 | 0 |
| 4 | SELECT `News`.`id`, `News`.`title`, `News`.`color_code` FROM `acurebd_main`.`news` AS `News` WHERE `type` = '1' AND `status` = '1' ORDER BY `sequence` ASC | | 0 | 0 | 0 |
| 5 | BEGIN | | 0 | 0 | 0 |
| 6 | ROLLBACK | | 0 | 0 | 0 |
| 7 | SELECT `Product`.`id`, `Product`.`name`, `Product`.`slug`, `Product`.`price`, `Product`.`meta_title`, `Product`.`special_price`, `Product`.`unit_name`, `Product`.`offer_type`, `Product`.`brand_id`, `ProductImg`.`id`, `ProductImg`.`slug`, `ProductImg`.`title`, COUNT(`Review`.`rating`) AS tot, AVG(`Review`.`rating`) AS scr FROM `acurebd_main`.`products` AS `Product` LEFT JOIN `acurebd_main`.`product_imgs` AS `ProductImg` ON (`ProductImg`.`product_id` = `Product`.`id`) LEFT JOIN `acurebd_main`.`reviews` AS `Review` ON (`Review`.`product_id` = `Product`.`id`) WHERE `Product`.`status` = '1' AND `Product`.`sold_qty` >0 AND (`Product`.`is_corporate_porduct` LIKE '%3%' OR `Product`.`is_corporate_porduct` LIKE '%4%') GROUP BY `Product`.`id` ORDER BY `Product`.`id` DESC LIMIT 50 | | 50 | 50 | 278 |
| 8 | SELECT `Product`.`id`, `Product`.`name`, `Product`.`slug`, `Product`.`price`, `Product`.`meta_title`, `Product`.`special_price`, `Product`.`unit_name`, `Product`.`offer_type`, `Product`.`brand_id`, `ProductImg`.`id`, `ProductImg`.`slug`, `ProductImg`.`title`, COUNT(`Review`.`rating`) AS tot, AVG(`Review`.`rating`) AS scr FROM `acurebd_main`.`products` AS `Product` LEFT JOIN `acurebd_main`.`product_imgs` AS `ProductImg` ON (`ProductImg`.`product_id` = `Product`.`id`) LEFT JOIN `acurebd_main`.`reviews` AS `Review` ON (`Review`.`product_id` = `Product`.`id`) WHERE `Product`.`status` = '1' AND `Product`.`offer_type` >0 AND (`Product`.`is_corporate_porduct` LIKE '%3%' OR `Product`.`is_corporate_porduct` LIKE '%4%') GROUP BY `Product`.`id` ORDER BY `Product`.`id` DESC LIMIT 50 | | 16 | 16 | 14 |
| 9 | SELECT `Brand`.`id`, `Brand`.`name`, `Brand`.`slug`, Count(`Product`.`id`) AS item_total FROM `acurebd_main`.`brands` AS `Brand` LEFT JOIN `acurebd_main`.`products` AS `Product` ON (`Product`.`brand_id` = `Brand`.`id`) WHERE `Product`.`status` = '1' AND (`Product`.`is_corporate_porduct` LIKE '%3%' OR `Product`.`is_corporate_porduct` LIKE '%4%') GROUP BY `Brand`.`id` HAVING Count(`Product`.`id`) >0 ORDER BY `Brand`.`created` DESC | | 17 | 17 | 2 |
| 10 | SELECT `Product`.`id`, `Product`.`name`, `Product`.`slug`, `Product`.`price`, `Product`.`meta_title`, `Product`.`special_price`, `Product`.`unit_name`, `Product`.`offer_type`, `Product`.`brand_id`, `ProductImg`.`id`, `ProductImg`.`slug`, `ProductImg`.`title`, COUNT(`Review`.`rating`) AS tot, AVG(`Review`.`rating`) AS scr FROM `acurebd_main`.`products` AS `Product` LEFT JOIN `acurebd_main`.`product_imgs` AS `ProductImg` ON (`ProductImg`.`product_id` = `Product`.`id`) LEFT JOIN `acurebd_main`.`reviews` AS `Review` ON (`Review`.`product_id` = `Product`.`id`) WHERE `Product`.`status` = '1' AND (`Product`.`is_corporate_porduct` LIKE '%3%' OR `Product`.`is_corporate_porduct` LIKE '%4%') GROUP BY `Product`.`id` ORDER BY `Product`.`totalview` DESC LIMIT 15 | | 15 | 15 | 222 |
