| 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%') ORDER BY `name` ASC LIMIT 39 | | 39 | 39 | 4 |
| 8 | SELECT `ProductImg`.`id`, `ProductImg`.`product_id`, `ProductImg`.`title`, `ProductImg`.`slug` FROM `acurebd_uat`.`product_imgs` AS `ProductImg` WHERE `ProductImg`.`product_id` IN (3995, 3989, 3993, 3996, 1410, 1675, 4396, 1409, 1416, 1950, 1951, 3994, 3997, 4390, 4445, 2270, 1869, 1042, 4035, 1139, 1140, 1141, 1044, 4294, 1463, 1891, 2205, 3567, 4139, 4444, 4007, 4375, 4112, 3571, 4000, 3561, 2147, 2148, 1404) | | 51 | 51 | 1 |
| 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 | 3 |
| 10 | SELECT `Category`.`id`, `Category`.`name`, `Category`.`meta_key`, `Category`.`meta_description` FROM `acurebd_uat`.`categories` AS `Category` WHERE `id` IS NULL LIMIT 1 | | 0 | 0 | 1 |
| 11 | SELECT `ProductImg`.`id`, `ProductImg`.`slug` FROM `acurebd_uat`.`product_imgs` AS `ProductImg` WHERE `ProductImg`.`product_id` = 3995 LIMIT 1 | | 1 | 1 | 1 |
| 12 | SELECT `ProductImg`.`id`, `ProductImg`.`slug` FROM `acurebd_uat`.`product_imgs` AS `ProductImg` WHERE `ProductImg`.`product_id` = 3989 LIMIT 1 | | 1 | 1 | 1 |
| 13 | SELECT `ProductImg`.`id`, `ProductImg`.`slug` FROM `acurebd_uat`.`product_imgs` AS `ProductImg` WHERE `ProductImg`.`product_id` = 3993 LIMIT 1 | | 1 | 1 | 1 |
| 14 | SELECT `ProductImg`.`id`, `ProductImg`.`slug` FROM `acurebd_uat`.`product_imgs` AS `ProductImg` WHERE `ProductImg`.`product_id` = 3996 LIMIT 1 | | 1 | 1 | 1 |
| 15 | SELECT `ProductImg`.`id`, `ProductImg`.`slug` FROM `acurebd_uat`.`product_imgs` AS `ProductImg` WHERE `ProductImg`.`product_id` = 1410 LIMIT 1 | | 1 | 1 | 0 |
| 16 | SELECT `ProductImg`.`id`, `ProductImg`.`slug` FROM `acurebd_uat`.`product_imgs` AS `ProductImg` WHERE `ProductImg`.`product_id` = 1675 LIMIT 1 | | 1 | 1 | 0 |
| 17 | SELECT `ProductImg`.`id`, `ProductImg`.`slug` FROM `acurebd_uat`.`product_imgs` AS `ProductImg` WHERE `ProductImg`.`product_id` = 4396 LIMIT 1 | | 1 | 1 | 1 |
| 18 | SELECT `ProductImg`.`id`, `ProductImg`.`slug` FROM `acurebd_uat`.`product_imgs` AS `ProductImg` WHERE `ProductImg`.`product_id` = 1409 LIMIT 1 | | 1 | 1 | 0 |
| 19 | SELECT `ProductImg`.`id`, `ProductImg`.`slug` FROM `acurebd_uat`.`product_imgs` AS `ProductImg` WHERE `ProductImg`.`product_id` = 1416 LIMIT 1 | | 1 | 1 | 0 |
| 20 | SELECT `ProductImg`.`id`, `ProductImg`.`slug` FROM `acurebd_uat`.`product_imgs` AS `ProductImg` WHERE `ProductImg`.`product_id` = 1950 LIMIT 1 | | 1 | 1 | 0 |
| 21 | SELECT `ProductImg`.`id`, `ProductImg`.`slug` FROM `acurebd_uat`.`product_imgs` AS `ProductImg` WHERE `ProductImg`.`product_id` = 1951 LIMIT 1 | | 1 | 1 | 0 |
| 22 | SELECT `ProductImg`.`id`, `ProductImg`.`slug` FROM `acurebd_uat`.`product_imgs` AS `ProductImg` WHERE `ProductImg`.`product_id` = 3994 LIMIT 1 | | 1 | 1 | 1 |
| 23 | SELECT `ProductImg`.`id`, `ProductImg`.`slug` FROM `acurebd_uat`.`product_imgs` AS `ProductImg` WHERE `ProductImg`.`product_id` = 3997 LIMIT 1 | | 1 | 1 | 1 |
| 24 | SELECT `ProductImg`.`id`, `ProductImg`.`slug` FROM `acurebd_uat`.`product_imgs` AS `ProductImg` WHERE `ProductImg`.`product_id` = 4390 LIMIT 1 | | 1 | 1 | 1 |
| 25 | SELECT `ProductImg`.`id`, `ProductImg`.`slug` FROM `acurebd_uat`.`product_imgs` AS `ProductImg` WHERE `ProductImg`.`product_id` = 4445 LIMIT 1 | | 1 | 1 | 1 |
| 26 | SELECT `ProductImg`.`id`, `ProductImg`.`slug` FROM `acurebd_uat`.`product_imgs` AS `ProductImg` WHERE `ProductImg`.`product_id` = 2270 LIMIT 1 | | 1 | 1 | 1 |
| 27 | SELECT `ProductImg`.`id`, `ProductImg`.`slug` FROM `acurebd_uat`.`product_imgs` AS `ProductImg` WHERE `ProductImg`.`product_id` = 1869 LIMIT 1 | | 1 | 1 | 0 |
| 28 | SELECT `ProductImg`.`id`, `ProductImg`.`slug` FROM `acurebd_uat`.`product_imgs` AS `ProductImg` WHERE `ProductImg`.`product_id` = 1042 LIMIT 1 | | 1 | 1 | 1 |
| 29 | SELECT `ProductImg`.`id`, `ProductImg`.`slug` FROM `acurebd_uat`.`product_imgs` AS `ProductImg` WHERE `ProductImg`.`product_id` = 4035 LIMIT 1 | | 1 | 1 | 1 |
| 30 | SELECT `ProductImg`.`id`, `ProductImg`.`slug` FROM `acurebd_uat`.`product_imgs` AS `ProductImg` WHERE `ProductImg`.`product_id` = 1139 LIMIT 1 | | 1 | 1 | 0 |
| 31 | SELECT `ProductImg`.`id`, `ProductImg`.`slug` FROM `acurebd_uat`.`product_imgs` AS `ProductImg` WHERE `ProductImg`.`product_id` = 1140 LIMIT 1 | | 1 | 1 | 0 |
| 32 | SELECT `ProductImg`.`id`, `ProductImg`.`slug` FROM `acurebd_uat`.`product_imgs` AS `ProductImg` WHERE `ProductImg`.`product_id` = 1141 LIMIT 1 | | 1 | 1 | 0 |
| 33 | SELECT `ProductImg`.`id`, `ProductImg`.`slug` FROM `acurebd_uat`.`product_imgs` AS `ProductImg` WHERE `ProductImg`.`product_id` = 1044 LIMIT 1 | | 1 | 1 | 0 |
| 34 | SELECT `ProductImg`.`id`, `ProductImg`.`slug` FROM `acurebd_uat`.`product_imgs` AS `ProductImg` WHERE `ProductImg`.`product_id` = 4294 LIMIT 1 | | 1 | 1 | 1 |
| 35 | SELECT `ProductImg`.`id`, `ProductImg`.`slug` FROM `acurebd_uat`.`product_imgs` AS `ProductImg` WHERE `ProductImg`.`product_id` = 1463 LIMIT 1 | | 1 | 1 | 0 |
| 36 | SELECT `ProductImg`.`id`, `ProductImg`.`slug` FROM `acurebd_uat`.`product_imgs` AS `ProductImg` WHERE `ProductImg`.`product_id` = 1891 LIMIT 1 | | 1 | 1 | 0 |
| 37 | SELECT `ProductImg`.`id`, `ProductImg`.`slug` FROM `acurebd_uat`.`product_imgs` AS `ProductImg` WHERE `ProductImg`.`product_id` = 2205 LIMIT 1 | | 1 | 1 | 0 |
| 38 | SELECT `ProductImg`.`id`, `ProductImg`.`slug` FROM `acurebd_uat`.`product_imgs` AS `ProductImg` WHERE `ProductImg`.`product_id` = 3567 LIMIT 1 | | 1 | 1 | 1 |
| 39 | SELECT `ProductImg`.`id`, `ProductImg`.`slug` FROM `acurebd_uat`.`product_imgs` AS `ProductImg` WHERE `ProductImg`.`product_id` = 4139 LIMIT 1 | | 1 | 1 | 1 |
| 40 | SELECT `ProductImg`.`id`, `ProductImg`.`slug` FROM `acurebd_uat`.`product_imgs` AS `ProductImg` WHERE `ProductImg`.`product_id` = 4444 LIMIT 1 | | 1 | 1 | 1 |
| 41 | SELECT `ProductImg`.`id`, `ProductImg`.`slug` FROM `acurebd_uat`.`product_imgs` AS `ProductImg` WHERE `ProductImg`.`product_id` = 4007 LIMIT 1 | | 1 | 1 | 1 |
| 42 | SELECT `ProductImg`.`id`, `ProductImg`.`slug` FROM `acurebd_uat`.`product_imgs` AS `ProductImg` WHERE `ProductImg`.`product_id` = 4375 LIMIT 1 | | 1 | 1 | 1 |
| 43 | SELECT `ProductImg`.`id`, `ProductImg`.`slug` FROM `acurebd_uat`.`product_imgs` AS `ProductImg` WHERE `ProductImg`.`product_id` = 4112 LIMIT 1 | | 1 | 1 | 1 |
| 44 | SELECT `ProductImg`.`id`, `ProductImg`.`slug` FROM `acurebd_uat`.`product_imgs` AS `ProductImg` WHERE `ProductImg`.`product_id` = 3571 LIMIT 1 | | 1 | 1 | 1 |
| 45 | SELECT `ProductImg`.`id`, `ProductImg`.`slug` FROM `acurebd_uat`.`product_imgs` AS `ProductImg` WHERE `ProductImg`.`product_id` = 4000 LIMIT 1 | | 1 | 1 | 1 |
| 46 | SELECT `ProductImg`.`id`, `ProductImg`.`slug` FROM `acurebd_uat`.`product_imgs` AS `ProductImg` WHERE `ProductImg`.`product_id` = 3561 LIMIT 1 | | 1 | 1 | 1 |
| 47 | SELECT `ProductImg`.`id`, `ProductImg`.`slug` FROM `acurebd_uat`.`product_imgs` AS `ProductImg` WHERE `ProductImg`.`product_id` = 2147 LIMIT 1 | | 1 | 1 | 1 |
| 48 | SELECT `ProductImg`.`id`, `ProductImg`.`slug` FROM `acurebd_uat`.`product_imgs` AS `ProductImg` WHERE `ProductImg`.`product_id` = 2148 LIMIT 1 | | 1 | 1 | 1 |
| 49 | SELECT `ProductImg`.`id`, `ProductImg`.`slug` FROM `acurebd_uat`.`product_imgs` AS `ProductImg` WHERE `ProductImg`.`product_id` = 1404 LIMIT 1 | | 1 | 1 | 1 |
