SHOW FULL COLUMNS FROM `e_web` [ RunTime:0.003284s ]
SELECT * FROM `e_web` WHERE ( `web_id` = 2 ) AND `e_web`.`del_time` IS NULL LIMIT 1 [ RunTime:0.001071s ]
SHOW FULL COLUMNS FROM `e_nav` [ RunTime:0.002576s ]
SELECT *,(SELECT COUNT(*) AS think_count FROM `e_nav` `count_table` WHERE ( `nav_state` = 1 AND ( `count_table`.`parent_id` =e_nav.nav_id ) ) AND `count_table`.`del_time` IS NULL) AS `children_count` FROM `e_nav` WHERE ( `web_id` = 2 AND `nav_state` = 1 AND `parent_id` = 0 ) AND `e_nav`.`del_time` IS NULL ORDER BY `nav_rank` ASC [ RunTime:0.000627s ]
SELECT *,(SELECT COUNT(*) AS think_count FROM `e_nav` `count_table` WHERE ( `nav_state` = 1 AND ( `count_table`.`parent_id` =e_nav.nav_id ) ) AND `count_table`.`del_time` IS NULL) AS `children_count` FROM `e_nav` WHERE ( `nav_state` = 1 AND `parent_id` IN (76,77,78,79,80) ) AND `e_nav`.`del_time` IS NULL ORDER BY `nav_rank` ASC [ RunTime:0.000671s ]
SELECT * FROM `e_nav` WHERE ( `nav_state` = 1 AND `parent_id` IN (81,82,83) ) AND `e_nav`.`del_time` IS NULL ORDER BY `nav_rank` ASC [ RunTime:0.000679s ]
SHOW FULL COLUMNS FROM `e_web_page` [ RunTime:0.003327s ]
SELECT * FROM `e_web_page` WHERE ( `data_id` = 18 AND `data_type` = 'ProductType' ) AND `e_web_page`.`del_time` IS NULL LIMIT 1 [ RunTime:0.000622s ]
