[ DB ] CONNECT:[ UseTime:0.000263s ] mysql:host=localhost;port=3306;dbname=nmgjxsbct_com;charset=utf8mb4
[ SQL ] SHOW COLUMNS FROM `yzn_category` [ RunTime:0.002271s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 0 ) ORDER BY `id` ASC,`listorder` ASC LIMIT 8 [ RunTime:0.000185s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 1 ) ORDER BY `listorder` DESC,`id` ASC LIMIT 1 [ RunTime:0.000193s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 2 ) ORDER BY `listorder` DESC,`id` ASC LIMIT 1 [ RunTime:0.000220s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 3 ) ORDER BY `listorder` DESC,`id` ASC LIMIT 1 [ RunTime:0.000148s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 4 ) ORDER BY `listorder` DESC,`id` ASC LIMIT 1 [ RunTime:0.000174s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 5 ) ORDER BY `listorder` DESC,`id` ASC LIMIT 1 [ RunTime:0.000194s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 6 ) ORDER BY `listorder` DESC,`id` ASC LIMIT 1 [ RunTime:0.000188s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 7 ) ORDER BY `listorder` DESC,`id` ASC LIMIT 1 [ RunTime:0.000215s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 8 ) ORDER BY `listorder` DESC,`id` ASC LIMIT 1 [ RunTime:0.000219s ]
[ SQL ] SHOW COLUMNS FROM `yzn_picture` [ RunTime:0.001999s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `yzn_picture` `Picture` LEFT JOIN `yzn_picture_data` `Picture_data` ON `Picture`.`id`=`Picture_data`.`did` WHERE ( `status`=1 AND `catid` = 11 ) [ RunTime:0.000202s ]
[ SQL ] SELECT `Picture`.*,`Picture_data`.* FROM `yzn_picture` `Picture` LEFT JOIN `yzn_picture_data` `Picture_data` ON `Picture`.`id`=`Picture_data`.`did` WHERE ( `status`=1 AND `catid` = 11 ) ORDER BY `listorder` DESC,`inputtime` DESC LIMIT 0,10 [ RunTime:0.000180s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 0 ) ORDER BY `listorder` DESC LIMIT 8 [ RunTime:0.000180s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 1 ) ORDER BY `listorder` ASC LIMIT 1 [ RunTime:0.000171s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 2 ) ORDER BY `listorder` ASC LIMIT 1 [ RunTime:0.000137s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 3 ) ORDER BY `listorder` ASC LIMIT 1 [ RunTime:0.000146s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 4 ) ORDER BY `listorder` ASC LIMIT 1 [ RunTime:0.000123s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 5 ) ORDER BY `listorder` ASC LIMIT 1 [ RunTime:0.000146s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 6 ) ORDER BY `listorder` ASC LIMIT 1 [ RunTime:0.000131s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 7 ) ORDER BY `listorder` ASC LIMIT 1 [ RunTime:0.000116s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 8 ) ORDER BY `listorder` ASC LIMIT 1 [ RunTime:0.000109s ]
资质荣誉
