| 1 | SELECT `Config`.`key`, `Config`.`value` FROM `niramoypolli_sohansworld`.`configs` AS `Config` WHERE 1 = 1 | | 59 | 59 | 0 |
| 2 | BEGIN | | 0 | 0 | 0 |
| 3 | ROLLBACK | | 0 | 0 | 0 |
| 4 | SELECT `Category`.`id`, `Category`.`name`, `Category`.`slug` FROM `niramoypolli_sohansworld`.`categories` AS `Category` WHERE `status` = '1' AND `parent_id` = 0 ORDER BY `Category`.`sequence` ASC | | 12 | 12 | 0 |
| 5 | SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`name`, `Category`.`slug` FROM `niramoypolli_sohansworld`.`categories` AS `Category` WHERE `status` = '1' ORDER BY `sequence` ASC | | 17 | 17 | 0 |
| 6 | SELECT `News`.`id`, `News`.`title`, `News`.`color_code` FROM `niramoypolli_sohansworld`.`news` AS `News` WHERE `type` = '1' AND `status` = '1' ORDER BY `sequence` ASC | | 0 | 0 | 1 |
| 7 | SELECT `Banner`.`id`, `Banner`.`product_id`, `Banner`.`link`, `Banner`.`button_text`, `Banner`.`title_one`, `Banner`.`title_two`, `Banner`.`sequence`, `Banner`.`status`, `Banner`.`created`, `Banner`.`modified`, `Product`.`id`, `Product`.`name`, `Product`.`slug`, `Product`.`barcode`, `Product`.`parent_id`, `Product`.`category_id`, `Product`.`categories`, `Product`.`brand_id`, `Product`.`model`, `Product`.`specification`, `Product`.`short_details`, `Product`.`details`, `Product`.`details_en`, `Product`.`details_bn`, `Product`.`meta_des`, `Product`.`meta_tag`, `Product`.`p_price`, `Product`.`price`, `Product`.`special_price`, `Product`.`special_pricep`, `Product`.`wholesale_price`, `Product`.`wholesale_pricep`, `Product`.`dealer_price`, `Product`.`dealer_pricep`, `Product`.`showroom_price`, `Product`.`showroom_pricep`, `Product`.`stock`, `Product`.`sold_qty`, `Product`.`unit`, `Product`.`unit_value`, `Product`.`unit_name`, `Product`.`offer_type`, `Product`.`is_corporate_porduct`, `Product`.`meta_key`, `Product`.`meta_description`, `Product`.`rating`, `Product`.`avg_rating`, `Product`.`status`, `Product`.`created`, `Product`.`modified`, `Product`.`viewtime`, `Product`.`totalview`, `Product`.`last_purchase_price`, `Product`.`avg_purchase_price`, `Product`.`total_profit`, `Product`.`total_sold_amount`, `Product`.`profit_margin`, (CONCAT(`Product`.`name`, " -- " , `Product`.`unit_name`)) AS `Product__label` FROM `niramoypolli_sohansworld`.`banners` AS `Banner` LEFT JOIN `niramoypolli_sohansworld`.`products` AS `Product` ON (`Banner`.`product_id` = `Product`.`id`) WHERE `Banner`.`status` = '1' ORDER BY `Banner`.`sequence` ASC, `Banner`.`created` DESC | | 1 | 1 | 0 |
| 8 | SELECT `Slider`.`id`, `Slider`.`title`, `Slider`.`color_code`, `Slider`.`content`, `Slider`.`product_id`, `Product`.`slug` FROM `niramoypolli_sohansworld`.`sliders` AS `Slider` LEFT JOIN `niramoypolli_sohansworld`.`products` AS `Product` ON (`Slider`.`product_id` = `Product`.`id`) WHERE `Slider`.`status` = '1' ORDER BY `Slider`.`sequence` ASC | | 3 | 3 | 0 |
| 9 | SELECT `Blog`.`id`, `Blog`.`title`, `Blog`.`slug`, `Blog`.`details`, `Blog`.`meta_description`, `Blog`.`meta_keywords`, `Blog`.`category`, `Blog`.`category_id`, `Blog`.`writer_name`, `Blog`.`publish_date`, `Blog`.`user_id`, `Blog`.`status`, `Blog`.`like_count`, `Blog`.`created`, `User`.`id`, `User`.`role_id`, `User`.`staff_id`, `User`.`dealer_id`, `User`.`showroom_id`, `User`.`customer_id`, `User`.`corporateclient_id`, `User`.`manager_id`, `User`.`marketingrepresentative_id`, `User`.`salesrepresentative_id`, `User`.`username`, `User`.`password`, `User`.`gitax`, `User`.`sc`, `User`.`ship`, `User`.`vat`, `User`.`status`, `User`.`created`, `User`.`modified`, `BlogCategory`.`id`, `BlogCategory`.`name`, `BlogCategory`.`slug`, `BlogCategory`.`description`, `BlogCategory`.`status`, `BlogCategory`.`created`, `BlogCategory`.`modified` FROM `niramoypolli_sohansworld`.`blogs` AS `Blog` LEFT JOIN `niramoypolli_sohansworld`.`users` AS `User` ON (`Blog`.`user_id` = `User`.`id`) LEFT JOIN `niramoypolli_sohansworld`.`blog_categories` AS `BlogCategory` ON (`Blog`.`category_id` = `BlogCategory`.`id`) WHERE `Blog`.`status` = 1 ORDER BY `Blog`.`created` DESC | | 4 | 4 | 0 |
| 10 | SELECT `Category`.`id`, `Category`.`name`, `Category`.`slug`, `Category`.`product_id`, `Category`.`parent_id` FROM `niramoypolli_sohansworld`.`categories` AS `Category` WHERE `Category`.`status` = '1' AND `Category`.`parent_id` = 0 ORDER BY `sequence` ASC | | 12 | 12 | 0 |
| 11 | SELECT `ChildCategory`.`id`, `ChildCategory`.`name`, `ChildCategory`.`slug`, `ChildCategory`.`parent_id` FROM `niramoypolli_sohansworld`.`categories` AS `ChildCategory` WHERE `ChildCategory`.`parent_id` IN (1, 3, 4, 5, 6, 2, 7, 8, 9, 10, 16, 22) | | 5 | 5 | 0 |
| 12 | SELECT `Brand`.`id`, `Brand`.`name`, `Brand`.`slug` FROM `niramoypolli_sohansworld`.`brands` AS `Brand` WHERE `status` = '1' | | 7 | 7 | 0 |
| 13 | SELECT `Flashphoto`.`id`, `Flashphoto`.`product_id`, `Flashphoto`.`link`, `Flashphoto`.`button_text`, `Flashphoto`.`title_one`, `Flashphoto`.`title_two`, `Flashphoto`.`sequence`, `Flashphoto`.`status`, `Flashphoto`.`created`, `Flashphoto`.`modified` FROM `niramoypolli_sohansworld`.`flashphotos` AS `Flashphoto` WHERE `status` = '1' ORDER BY `sequence` ASC LIMIT 2 | | 2 | 2 | 0 |
| 14 | SELECT `Category`.`id`, `Category`.`slug` FROM `niramoypolli_sohansworld`.`categories` AS `Category` WHERE `status` = '1' | | 17 | 17 | 0 |
Nuts & Dried Fruits
Honey
Herbs & Spices
Vinegar With The Mother
Salt
Whole Grain Foods
Oil
Super Food
Coffee & Tea
All Products
Combo
Fitness Instruments
