| 1 | SELECT `Config`.`key`, `Config`.`value` FROM `niramoypolli_sohansworld`.`configs` AS `Config` WHERE 1 = 1 | | 59 | 59 | 1 |
| 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 | 0 |
| 7 | SELECT COUNT(*) AS `count` FROM `niramoypolli_sohansworld`.`blogs` AS `Blog` WHERE `Blog`.`id` = 23 | | 1 | 1 | 0 |
| 8 | 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`.`id` = 23 LIMIT 1 | | 1 | 1 | 0 |
| 9 | SELECT `Comment`.`id`, `Comment`.`blog_id`, `Comment`.`parent_id`, `Comment`.`user_name`, `Comment`.`user_email`, `Comment`.`comment`, `Comment`.`ip_address`, `Comment`.`status`, `Comment`.`likes`, `Comment`.`created`, `Comment`.`modified` FROM `niramoypolli_sohansworld`.`comments` AS `Comment` WHERE `Comment`.`status` = '1' AND `Comment`.`blog_id` = (23) | | 0 | 0 | 0 |
| 10 | SELECT `BlogLike`.`id`, `BlogLike`.`blog_id`, `BlogLike`.`ip_address`, `BlogLike`.`user_agent`, `BlogLike`.`created` FROM `niramoypolli_sohansworld`.`blog_likes` AS `BlogLike` WHERE `BlogLike`.`blog_id` = (23) | | 1 | 1 | 0 |
| 11 | SELECT COUNT(*) AS `count` FROM `niramoypolli_sohansworld`.`blog_likes` AS `BlogLike` WHERE `BlogLike`.`blog_id` = 23 AND `BlogLike`.`ip_address` = '216.73.216.47' | | 1 | 1 | 0 |
| 12 | SELECT `Comment`.`id`, `Comment`.`blog_id`, `Comment`.`parent_id`, `Comment`.`user_name`, `Comment`.`user_email`, `Comment`.`comment`, `Comment`.`ip_address`, `Comment`.`status`, `Comment`.`likes`, `Comment`.`created`, `Comment`.`modified`, `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`, `ParentComment`.`id`, `ParentComment`.`blog_id`, `ParentComment`.`parent_id`, `ParentComment`.`user_name`, `ParentComment`.`user_email`, `ParentComment`.`comment`, `ParentComment`.`ip_address`, `ParentComment`.`status`, `ParentComment`.`likes`, `ParentComment`.`created`, `ParentComment`.`modified` FROM `niramoypolli_sohansworld`.`comments` AS `Comment` LEFT JOIN `niramoypolli_sohansworld`.`blogs` AS `Blog` ON (`Comment`.`blog_id` = `Blog`.`id`) LEFT JOIN `niramoypolli_sohansworld`.`comments` AS `ParentComment` ON (`Comment`.`parent_id` = `ParentComment`.`id`) WHERE `Comment`.`blog_id` = 23 AND `Comment`.`status` = '1' ORDER BY `Comment`.`created` DESC | | 0 | 0 | 0 |
মন্তব্য 0
নতুন মন্তব্য
এখনো কোনো মন্তব্য নেই। প্রথম মন্তব্য করুন!