| 1 | SELECT `Config`.`key`, `Config`.`value` FROM `shunfabd_main`.`configs` AS `Config` WHERE 1 = 1 | | 35 | 35 | 0 |
| 2 | BEGIN | | 0 | 0 | 0 |
| 3 | ROLLBACK | | 0 | 0 | 0 |
| 4 | SELECT `Category`.`id`, `Category`.`name`, `Category`.`slug`, COUNT(`Product`.`id`) AS total_products FROM `shunfabd_main`.`categories` AS `Category` LEFT JOIN `shunfabd_main`.`products` AS `Product` ON (`Category`.`id` = `Product`.`category_id`) WHERE `Category`.`status` = '1' AND `Category`.`parent_id` = 0 GROUP BY `Category`.`id`, `Category`.`name`, `Category`.`slug` ORDER BY `Category`.`sequence` ASC | | 6 | 6 | 1 |
| 5 | SELECT `Category`.`id`, `Category`.`name`, `Category`.`slug` FROM `shunfabd_main`.`categories` AS `Category` WHERE `Category`.`status` = '1' AND `Category`.`parent_id` = 1 ORDER BY `Category`.`sequence` ASC | | 0 | 0 | 0 |
| 6 | SELECT `Category`.`id`, `Category`.`name`, `Category`.`slug` FROM `shunfabd_main`.`categories` AS `Category` WHERE `Category`.`status` = '1' AND `Category`.`parent_id` = 2 ORDER BY `Category`.`sequence` ASC | | 0 | 0 | 0 |
| 7 | SELECT `Category`.`id`, `Category`.`name`, `Category`.`slug` FROM `shunfabd_main`.`categories` AS `Category` WHERE `Category`.`status` = '1' AND `Category`.`parent_id` = 3 ORDER BY `Category`.`sequence` ASC | | 0 | 0 | 0 |
| 8 | SELECT `Category`.`id`, `Category`.`name`, `Category`.`slug` FROM `shunfabd_main`.`categories` AS `Category` WHERE `Category`.`status` = '1' AND `Category`.`parent_id` = 4 ORDER BY `Category`.`sequence` ASC | | 0 | 0 | 0 |
| 9 | SELECT `Category`.`id`, `Category`.`name`, `Category`.`slug` FROM `shunfabd_main`.`categories` AS `Category` WHERE `Category`.`status` = '1' AND `Category`.`parent_id` = 5 ORDER BY `Category`.`sequence` ASC | | 0 | 0 | 0 |
| 10 | SELECT `Category`.`id`, `Category`.`name`, `Category`.`slug` FROM `shunfabd_main`.`categories` AS `Category` WHERE `Category`.`status` = '1' AND `Category`.`parent_id` = 6 ORDER BY `Category`.`sequence` ASC | | 0 | 0 | 0 |
| 11 | SELECT `News`.`id`, `News`.`title`, `News`.`color_code` FROM `shunfabd_main`.`news` AS `News` WHERE `type` = '1' AND `status` = '1' ORDER BY `sequence` ASC | | 0 | 0 | 0 |
| 12 | SELECT `Brand`.`id` FROM `shunfabd_main`.`brands` AS `Brand` WHERE `status` = '1' LIMIT 10 | | 1 | 1 | 0 |
| 13 | SELECT `News`.`id`, `News`.`user_id`, `News`.`title`, `News`.`color_code`, `News`.`news`, `News`.`publish_date`, `News`.`publish_time`, `News`.`type`, `News`.`sequence`, `News`.`ext`, `News`.`status`, `News`.`created`, `News`.`modified`, `User`.`id`, `User`.`role_id`, `User`.`staff_id`, `User`.`agent_id`, `User`.`username`, `User`.`password`, `User`.`email`, `User`.`gitax`, `User`.`sc`, `User`.`ship`, `User`.`vat`, `User`.`status`, `User`.`created`, `User`.`modified` FROM `shunfabd_main`.`news` AS `News` LEFT JOIN `shunfabd_main`.`users` AS `User` ON (`News`.`user_id` = `User`.`id`) WHERE 1 = 1 ORDER BY `News`.`created` DESC LIMIT 20 | | 3 | 3 | 0 |
