[ DB ] CONNECT:[ UseTime:0.001125s ] mysql:host=127.0.0.1;dbname=lyketsjk;charset=utf8
[ SQL ] SHOW COLUMNS FROM `yzn_category` [ RunTime:0.014056s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE `id` = 123 LIMIT 1 [ RunTime:0.000451s ]
[ SQL ] SHOW COLUMNS FROM `yzn_picture` [ RunTime:0.012862s ]
[ SQL ] UPDATE `yzn_picture` SET `hits` = `hits` + 1 WHERE `id` = 293 [ RunTime:0.000534s ]
[ SQL ] SHOW COLUMNS FROM `yzn_model` [ RunTime:0.012462s ]
[ SQL ] SELECT * FROM `yzn_model` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000269s ]
[ SQL ] SELECT `Picture`.*,`Picture_data`.* FROM `yzn_picture` `Picture` LEFT JOIN `yzn_picture_data` `Picture_data` ON `Picture`.`id`=`Picture_data`.`did` WHERE ( id=293 ) LIMIT 1 [ RunTime:0.000471s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 0 ) ORDER BY `listorder` DESC LIMIT 10 [ RunTime:0.000432s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 19 ) ORDER BY `listorder` DESC LIMIT 20 [ RunTime:0.000295s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 23 ) ORDER BY `listorder` DESC LIMIT 20 [ RunTime:0.000332s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 43 ) ORDER BY `listorder` DESC LIMIT 20 [ RunTime:0.000274s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 44 ) ORDER BY `listorder` DESC LIMIT 20 [ RunTime:0.000227s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 104 ) ORDER BY `listorder` DESC LIMIT 20 [ RunTime:0.000235s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 103 ) ORDER BY `listorder` DESC LIMIT 20 [ RunTime:0.000215s ]
[ SQL ] SELECT * FROM `yzn_picture` WHERE ( `catid` = 123 AND `status` = 1 AND `id` < 293 ) ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000540s ]
[ SQL ] SELECT * FROM `yzn_picture` WHERE ( `catid` = 123 AND `status` = 1 AND `id` > 293 ) LIMIT 1 [ RunTime:0.000500s ]
[ SQL ] SELECT * FROM `yzn_picture` WHERE ( `status`=1 AND `catid` in(105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120,121,122,23) ) ORDER BY `id` DESC LIMIT 5 [ RunTime:0.000627s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 43 ) ORDER BY `listorder` DESC LIMIT 20 [ RunTime:0.000308s ]
[ DB ] CONNECT:[ UseTime:0.004583s ] mysql:host=127.0.0.1;dbname=lyketsjk;charset=utf8
[ SQL ] SELECT * FROM `yzn_category` WHERE `id` = 104 LIMIT 1 [ RunTime:0.000330s ]
[ SQL ] SELECT * FROM `yzn_model` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000273s ]
[ SQL ] SHOW COLUMNS FROM `yzn_article` [ RunTime:0.010326s ]
[ SQL ] SELECT * FROM `yzn_article` WHERE ( `status`=1 AND `catid` in(143,144,104) ) ORDER BY `listorder` DESC LIMIT 5 [ RunTime:0.000417s ]
QQ客服