| 1 | SELECT `Config`.`key`, `Config`.`value` FROM `acurebd_uat`.`configs` AS `Config` WHERE 1 = 1 | | 67 | 67 | 0 |
| 2 | SELECT `Category`.`id`, `Category`.`name`, `Category`.`slug`, `Category`.`product_id` FROM `acurebd_uat`.`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_uat`.`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_uat`.`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`.`special_price`, `Product`.`unit_name`, `Product`.`offer_type`, `Product`.`brand_id` FROM `acurebd_uat`.`products` AS `Product` WHERE `Product`.`status` = '1' AND (`Product`.`is_corporate_porduct` LIKE '%3%' OR `Product`.`is_corporate_porduct` LIKE '%4%') AND sold_qty >0 ORDER BY `Product`.`sold_qty` DESC LIMIT 10 | | 10 | 10 | 2 |
| 8 | SELECT `Product`.`id`, `Product`.`name`, `Product`.`slug`, `Product`.`price`, `Product`.`special_price`, `Product`.`unit_name`, `Product`.`offer_type`, `Product`.`brand_id` FROM `acurebd_uat`.`products` AS `Product` WHERE `Product`.`status` = '1' AND (`Product`.`is_corporate_porduct` LIKE '%3%' OR `Product`.`is_corporate_porduct` LIKE '%4%') AND offer_type >0 ORDER BY `Product`.`id` DESC LIMIT 10 | | 10 | 10 | 2 |
| 9 | SELECT `Brand`.`id`, `Brand`.`name`, `Brand`.`slug`, Count(`Product`.`id`) AS item_total FROM `acurebd_uat`.`brands` AS `Brand` LEFT JOIN `acurebd_uat`.`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 | 0 |
| 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` FROM `acurebd_uat`.`products` AS `Product` LEFT JOIN `acurebd_uat`.`categories` AS `Category` ON (`Product`.`category_id` = `Category`.`id`) LEFT JOIN `acurebd_uat`.`brands` AS `Brand` ON (`Product`.`brand_id` = `Brand`.`id`) WHERE `Product`.`status` = '1' AND (`Product`.`is_corporate_porduct` LIKE '%3%' OR `Product`.`is_corporate_porduct` LIKE '%4%') ORDER BY `Product`.`totalview` DESC LIMIT 15 | | 15 | 15 | 2 |
| 11 | SELECT `Dealerproduct`.`id`, `Dealerproduct`.`product_id`, `Dealerproduct`.`dealer_id`, `Dealerproduct`.`stock`, `Dealerproduct`.`price`, `Dealerproduct`.`d_price`, `Dealerproduct`.`t_price`, `Dealerproduct`.`d_pricep`, `Dealerproduct`.`t_pricep`, `Dealerproduct`.`status` FROM `acurebd_uat`.`dealerproducts` AS `Dealerproduct` WHERE `Dealerproduct`.`product_id` IN (1051, 1042, 1069, 1020, 1032, 2105, 1008, 1044, 1005, 1062, 1056, 1894, 1876, 1033, 1009) | | 30 | 30 | 2 |
| 12 | SELECT `Showroomproduct`.`id`, `Showroomproduct`.`product_id`, `Showroomproduct`.`showroom_id`, `Showroomproduct`.`stock`, `Showroomproduct`.`price`, `Showroomproduct`.`d_price`, `Showroomproduct`.`t_price`, `Showroomproduct`.`d_pricep`, `Showroomproduct`.`t_pricep`, `Showroomproduct`.`status` FROM `acurebd_uat`.`showroomproducts` AS `Showroomproduct` WHERE `Showroomproduct`.`product_id` IN (1051, 1042, 1069, 1020, 1032, 2105, 1008, 1044, 1005, 1062, 1056, 1894, 1876, 1033, 1009) | | 270 | 270 | 16 |
| 13 | SELECT `Dealerpurchasedetail`.`id`, `Dealerpurchasedetail`.`dealerpurchase_id`, `Dealerpurchasedetail`.`product_id`, `Dealerpurchasedetail`.`price`, `Dealerpurchasedetail`.`qty` FROM `acurebd_uat`.`dealerpurchasedetails` AS `Dealerpurchasedetail` WHERE `Dealerpurchasedetail`.`product_id` IN (1051, 1042, 1069, 1020, 1032, 2105, 1008, 1044, 1005, 1062, 1056, 1894, 1876, 1033, 1009) | | 7 | 7 | 0 |
| 14 | SELECT `OrderDetail`.`id`, `OrderDetail`.`order_id`, `OrderDetail`.`product_id`, `OrderDetail`.`price`, `OrderDetail`.`qty`, `OrderDetail`.`total_price` FROM `acurebd_uat`.`order_details` AS `OrderDetail` WHERE `OrderDetail`.`product_id` IN (1051, 1042, 1069, 1020, 1032, 2105, 1008, 1044, 1005, 1062, 1056, 1894, 1876, 1033, 1009) | | 961 | 961 | 4 |
| 15 | SELECT `ProductImg`.`id`, `ProductImg`.`product_id`, `ProductImg`.`title`, `ProductImg`.`slug` FROM `acurebd_uat`.`product_imgs` AS `ProductImg` WHERE `ProductImg`.`product_id` IN (1051, 1042, 1069, 1020, 1032, 2105, 1008, 1044, 1005, 1062, 1056, 1894, 1876, 1033, 1009) | | 37 | 37 | 1 |
| 16 | SELECT `PurchaseDetail`.`id`, `PurchaseDetail`.`purchase_id`, `PurchaseDetail`.`product_id`, `PurchaseDetail`.`p_price`, `PurchaseDetail`.`price`, `PurchaseDetail`.`qty` FROM `acurebd_uat`.`purchase_details` AS `PurchaseDetail` WHERE `PurchaseDetail`.`product_id` IN (1051, 1042, 1069, 1020, 1032, 2105, 1008, 1044, 1005, 1062, 1056, 1894, 1876, 1033, 1009) | | 10 | 10 | 1 |
| 17 | SELECT `Review`.`id`, `Review`.`product_id`, `Review`.`name`, `Review`.`summary`, `Review`.`rating`, `Review`.`email`, `Review`.`status`, `Review`.`created`, `Review`.`modified`, `Review`.`mobile_number` FROM `acurebd_uat`.`reviews` AS `Review` WHERE `Review`.`product_id` IN (1051, 1042, 1069, 1020, 1032, 2105, 1008, 1044, 1005, 1062, 1056, 1894, 1876, 1033, 1009) | | 132 | 132 | 7 |
| 18 | SELECT `ProductImg`.`id`, `ProductImg`.`slug` FROM `acurebd_uat`.`product_imgs` AS `ProductImg` WHERE `ProductImg`.`product_id` = 1062 LIMIT 1 | | 1 | 1 | 1 |
| 19 | SELECT `ProductImg`.`id`, `ProductImg`.`slug` FROM `acurebd_uat`.`product_imgs` AS `ProductImg` WHERE `ProductImg`.`product_id` = 1010 LIMIT 1 | | 1 | 1 | 1 |
| 20 | SELECT `ProductImg`.`id`, `ProductImg`.`slug` FROM `acurebd_uat`.`product_imgs` AS `ProductImg` WHERE `ProductImg`.`product_id` = 1011 LIMIT 1 | | 1 | 1 | 1 |
| 21 | SELECT `ProductImg`.`id`, `ProductImg`.`slug` FROM `acurebd_uat`.`product_imgs` AS `ProductImg` WHERE `ProductImg`.`product_id` = 1033 LIMIT 1 | | 1 | 1 | 0 |
| 22 | SELECT `ProductImg`.`id`, `ProductImg`.`slug` FROM `acurebd_uat`.`product_imgs` AS `ProductImg` WHERE `ProductImg`.`product_id` = 1117 LIMIT 1 | | 1 | 1 | 0 |
| 23 | SELECT `ProductImg`.`id`, `ProductImg`.`slug` FROM `acurebd_uat`.`product_imgs` AS `ProductImg` WHERE `ProductImg`.`product_id` = 1123 LIMIT 1 | | 1 | 1 | 0 |
| 24 | SELECT `ProductImg`.`id`, `ProductImg`.`slug` FROM `acurebd_uat`.`product_imgs` AS `ProductImg` WHERE `ProductImg`.`product_id` = 1042 LIMIT 1 | | 1 | 1 | 0 |
| 25 | SELECT `ProductImg`.`id`, `ProductImg`.`slug` FROM `acurebd_uat`.`product_imgs` AS `ProductImg` WHERE `ProductImg`.`product_id` = 1020 LIMIT 1 | | 1 | 1 | 0 |
| 26 | SELECT `ProductImg`.`id`, `ProductImg`.`slug` FROM `acurebd_uat`.`product_imgs` AS `ProductImg` WHERE `ProductImg`.`product_id` = 1139 LIMIT 1 | | 1 | 1 | 0 |
| 27 | SELECT `ProductImg`.`id`, `ProductImg`.`slug` FROM `acurebd_uat`.`product_imgs` AS `ProductImg` WHERE `ProductImg`.`product_id` = 2135 LIMIT 1 | | 1 | 1 | 0 |
| 28 | SELECT `ProductImg`.`id`, `ProductImg`.`slug` FROM `acurebd_uat`.`product_imgs` AS `ProductImg` WHERE `ProductImg`.`product_id` = 4351 LIMIT 1 | | 0 | 0 | 1 |
| 29 | SELECT `ProductImg`.`id`, `ProductImg`.`slug` FROM `acurebd_uat`.`product_imgs` AS `ProductImg` WHERE `ProductImg`.`product_id` = 2304 LIMIT 1 | | 1 | 1 | 0 |
| 30 | SELECT `ProductImg`.`id`, `ProductImg`.`slug` FROM `acurebd_uat`.`product_imgs` AS `ProductImg` WHERE `ProductImg`.`product_id` = 2302 LIMIT 1 | | 1 | 1 | 0 |
| 31 | SELECT `ProductImg`.`id`, `ProductImg`.`slug` FROM `acurebd_uat`.`product_imgs` AS `ProductImg` WHERE `ProductImg`.`product_id` = 1885 LIMIT 1 | | 1 | 1 | 0 |
| 32 | SELECT `ProductImg`.`id`, `ProductImg`.`slug` FROM `acurebd_uat`.`product_imgs` AS `ProductImg` WHERE `ProductImg`.`product_id` = 1884 LIMIT 1 | | 1 | 1 | 0 |
| 33 | SELECT `ProductImg`.`id`, `ProductImg`.`slug` FROM `acurebd_uat`.`product_imgs` AS `ProductImg` WHERE `ProductImg`.`product_id` = 1882 LIMIT 1 | | 1 | 1 | 0 |
| 34 | SELECT `ProductImg`.`id`, `ProductImg`.`slug` FROM `acurebd_uat`.`product_imgs` AS `ProductImg` WHERE `ProductImg`.`product_id` = 1879 LIMIT 1 | | 1 | 1 | 0 |
| 35 | SELECT `ProductImg`.`id`, `ProductImg`.`slug` FROM `acurebd_uat`.`product_imgs` AS `ProductImg` WHERE `ProductImg`.`product_id` = 1878 LIMIT 1 | | 1 | 1 | 0 |
| 36 | SELECT `ProductImg`.`id`, `ProductImg`.`slug` FROM `acurebd_uat`.`product_imgs` AS `ProductImg` WHERE `ProductImg`.`product_id` = 1877 LIMIT 1 | | 1 | 1 | 0 |
| 37 | SELECT `ProductImg`.`id`, `ProductImg`.`slug` FROM `acurebd_uat`.`product_imgs` AS `ProductImg` WHERE `ProductImg`.`product_id` = 1876 LIMIT 1 | | 1 | 1 | 0 |
| 38 | SELECT `ProductImg`.`id`, `ProductImg`.`slug` FROM `acurebd_uat`.`product_imgs` AS `ProductImg` WHERE `ProductImg`.`product_id` = 1051 LIMIT 1 | | 1 | 1 | 1 |
| 39 | SELECT `ProductImg`.`id`, `ProductImg`.`slug` FROM `acurebd_uat`.`product_imgs` AS `ProductImg` WHERE `ProductImg`.`product_id` = 1042 LIMIT 1 | | 1 | 1 | 0 |
| 40 | SELECT `ProductImg`.`id`, `ProductImg`.`slug` FROM `acurebd_uat`.`product_imgs` AS `ProductImg` WHERE `ProductImg`.`product_id` = 1069 LIMIT 1 | | 1 | 1 | 0 |
| 41 | SELECT `ProductImg`.`id`, `ProductImg`.`slug` FROM `acurebd_uat`.`product_imgs` AS `ProductImg` WHERE `ProductImg`.`product_id` = 1020 LIMIT 1 | | 1 | 1 | 0 |
| 42 | SELECT `ProductImg`.`id`, `ProductImg`.`slug` FROM `acurebd_uat`.`product_imgs` AS `ProductImg` WHERE `ProductImg`.`product_id` = 1032 LIMIT 1 | | 1 | 1 | 0 |
| 43 | SELECT `ProductImg`.`id`, `ProductImg`.`slug` FROM `acurebd_uat`.`product_imgs` AS `ProductImg` WHERE `ProductImg`.`product_id` = 2105 LIMIT 1 | | 1 | 1 | 1 |
| 44 | SELECT `ProductImg`.`id`, `ProductImg`.`slug` FROM `acurebd_uat`.`product_imgs` AS `ProductImg` WHERE `ProductImg`.`product_id` = 1008 LIMIT 1 | | 1 | 1 | 0 |
| 45 | SELECT `ProductImg`.`id`, `ProductImg`.`slug` FROM `acurebd_uat`.`product_imgs` AS `ProductImg` WHERE `ProductImg`.`product_id` = 1044 LIMIT 1 | | 1 | 1 | 0 |
| 46 | SELECT `ProductImg`.`id`, `ProductImg`.`slug` FROM `acurebd_uat`.`product_imgs` AS `ProductImg` WHERE `ProductImg`.`product_id` = 1005 LIMIT 1 | | 1 | 1 | 1 |
| 47 | SELECT `ProductImg`.`id`, `ProductImg`.`slug` FROM `acurebd_uat`.`product_imgs` AS `ProductImg` WHERE `ProductImg`.`product_id` = 1062 LIMIT 1 | | 1 | 1 | 0 |
| 48 | SELECT `ProductImg`.`id`, `ProductImg`.`slug` FROM `acurebd_uat`.`product_imgs` AS `ProductImg` WHERE `ProductImg`.`product_id` = 1056 LIMIT 1 | | 1 | 1 | 0 |
| 49 | SELECT `ProductImg`.`id`, `ProductImg`.`slug` FROM `acurebd_uat`.`product_imgs` AS `ProductImg` WHERE `ProductImg`.`product_id` = 1894 LIMIT 1 | | 1 | 1 | 0 |
| 50 | SELECT `ProductImg`.`id`, `ProductImg`.`slug` FROM `acurebd_uat`.`product_imgs` AS `ProductImg` WHERE `ProductImg`.`product_id` = 1876 LIMIT 1 | | 1 | 1 | 0 |
| 51 | SELECT `ProductImg`.`id`, `ProductImg`.`slug` FROM `acurebd_uat`.`product_imgs` AS `ProductImg` WHERE `ProductImg`.`product_id` = 1033 LIMIT 1 | | 1 | 1 | 0 |
| 52 | SELECT `ProductImg`.`id`, `ProductImg`.`slug` FROM `acurebd_uat`.`product_imgs` AS `ProductImg` WHERE `ProductImg`.`product_id` = 1009 LIMIT 1 | | 1 | 1 | 0 |
