Categories
Categories
| Nr | Query | Error | Affected | Num. rows | Took (ms) |
|---|---|---|---|---|---|
| 1 | SELECT `Config`.`key`, `Config`.`value` FROM `niramoypolli_demo`.`configs` AS `Config` WHERE 1 = 1 | 42 | 42 | 0 | |
| 2 | BEGIN | 0 | 0 | 0 | |
| 3 | ROLLBACK | 0 | 0 | 0 | |
| 4 | SELECT `Category`.`id`, `Category`.`name`, `Category`.`slug` FROM `niramoypolli_demo`.`categories` AS `Category` WHERE `status` = '1' AND `parent_id` = 0 ORDER BY `Category`.`sequence` ASC | 11 | 11 | 0 | |
| 5 | SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`name`, `Category`.`slug` FROM `niramoypolli_demo`.`categories` AS `Category` WHERE `status` = '1' AND parent_id > 0 ORDER BY `sequence` ASC | 5 | 5 | 0 | |
| 6 | SELECT `News`.`id`, `News`.`title`, `News`.`color_code` FROM `niramoypolli_demo`.`news` AS `News` WHERE `type` = '1' AND `status` = '1' ORDER BY `sequence` ASC | 0 | 0 | 0 | |
| 7 | SELECT `Slider`.`id`, `Slider`.`title`, `Slider`.`color_code`, `Slider`.`content`, `Slider`.`product_id`, `Product`.`slug` FROM `niramoypolli_demo`.`sliders` AS `Slider` LEFT JOIN `niramoypolli_demo`.`products` AS `Product` ON (`Slider`.`product_id` = `Product`.`id`) WHERE `Slider`.`status` = '1' ORDER BY `Slider`.`sequence` ASC | 2 | 2 | 1 | |
| 8 | SELECT `Blog`.`id`, `Blog`.`title`, `Blog`.`details`, `Blog`.`writer_name`, `Blog`.`publish_date`, `Blog`.`user_id`, `Blog`.`status`, `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` FROM `niramoypolli_demo`.`blogs` AS `Blog` LEFT JOIN `niramoypolli_demo`.`users` AS `User` ON (`Blog`.`user_id` = `User`.`id`) WHERE `Blog`.`status` = 1 ORDER BY `Blog`.`created` DESC | 1 | 1 | 0 | |
| 9 | SELECT `Category`.`id`, `Category`.`name`, `Category`.`slug`, `Category`.`product_id`, `Category`.`parent_id` FROM `niramoypolli_demo`.`categories` AS `Category` WHERE `Category`.`status` = '1' AND `Category`.`parent_id` = 0 ORDER BY `sequence` ASC | 11 | 11 | 0 | |
| 10 | SELECT `ChildCategory`.`id`, `ChildCategory`.`name`, `ChildCategory`.`slug`, `ChildCategory`.`parent_id` FROM `niramoypolli_demo`.`categories` AS `ChildCategory` WHERE `ChildCategory`.`parent_id` IN (1, 3, 4, 5, 6, 2, 7, 8, 9, 10, 16) | 5 | 5 | 0 | |
| 11 | SELECT `Brand`.`id`, `Brand`.`name`, `Brand`.`slug` FROM `niramoypolli_demo`.`brands` AS `Brand` WHERE `status` = '1' | 7 | 7 | 0 | |
| 12 | SELECT `Flashphoto`.`id`, `Flashphoto`.`product_id`, `Flashphoto`.`title_one`, `Flashphoto`.`title_two`, `Flashphoto`.`sequence`, `Flashphoto`.`status`, `Flashphoto`.`created`, `Flashphoto`.`modified` FROM `niramoypolli_demo`.`flashphotos` AS `Flashphoto` WHERE `status` = '1' ORDER BY `sequence` ASC LIMIT 2 | 2 | 2 | 0 | |
| 13 | SELECT `Category`.`id`, `Category`.`slug` FROM `niramoypolli_demo`.`categories` AS `Category` WHERE `status` = '1' | 16 | 16 | 0 |