অর্গানিক পণ্য, স্বাস্থ্য টিপস এবং সুস্থ থাকার নানা উপায় নিয়ে আমাদের বিশেষ আর্টিকেল
| Nr | Query | Error | Affected | Num. rows | Took (ms) |
|---|---|---|---|---|---|
| 1 | SELECT `Config`.`key`, `Config`.`value` FROM `niramoypolli_sohansworld`.`configs` AS `Config` WHERE 1 = 1 | 60 | 60 | 51 | |
| 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 | 51 | |
| 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 | 25 | |
| 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 `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 AND `Blog`.`category_id` = 4 ORDER BY `Blog`.`created` DESC LIMIT 9 | 1 | 1 | 2 | |
| 8 | SELECT `BlogCategory`.`id`, `BlogCategory`.`name`, `BlogCategory`.`slug`, COUNT(`Blog`.`id`) as blog_count FROM `niramoypolli_sohansworld`.`blog_categories` AS `BlogCategory` LEFT JOIN `niramoypolli_sohansworld`.`blogs` AS `Blog` ON (`Blog`.`category_id` = `BlogCategory`.`id` AND `Blog`.`status` = 1) WHERE `BlogCategory`.`status` = '1' GROUP BY `BlogCategory`.`id` ORDER BY `BlogCategory`.`name` ASC | 6 | 6 | 1 | |
| 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` FROM `niramoypolli_sohansworld`.`blogs` AS `Blog` WHERE `Blog`.`category_id` IN (6, 2, 4, 5, 3, 1) | 4 | 4 | 1 | |
| 10 | SELECT COUNT(*) AS `count` 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 | 1 | 1 | 0 |
