[ DB ] CONNECT:[ UseTime:0.000566s ] mysql:host=127.0.0.1;dbname=ksgjzb_srok_cn;charset=utf8
[ SQL ] SHOW COLUMNS FROM `yzn_test` [ RunTime:0.000882s ]
[ SQL ] UPDATE `yzn_test` SET `hits` = `hits` + 1 WHERE `id` = 126 [ RunTime:0.003895s ]
[ SQL ] SELECT `Test`.*,`Test_data`.* FROM `yzn_test` `Test` LEFT JOIN `yzn_test_data` `Test_data` ON `Test`.`id`=`Test_data`.`did` WHERE ( id=126 ) LIMIT 1 [ RunTime:0.001073s ]
[ SQL ] SHOW COLUMNS FROM `yzn_link` [ RunTime:0.000915s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `yzn_link` WHERE ( `status`=1 AND `catid` = 49 ) [ RunTime:0.000245s ]
[ SQL ] SELECT * FROM `yzn_link` WHERE ( `status`=1 AND `catid` = 49 ) ORDER BY `listorder` ASC LIMIT 0,10 [ RunTime:0.000338s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `yzn_link` WHERE ( `status`=1 AND `catid` = 50 ) [ RunTime:0.000299s ]
[ SQL ] SELECT * FROM `yzn_link` WHERE ( `status`=1 AND `catid` = 50 ) ORDER BY `listorder` ASC LIMIT 0,10 [ RunTime:0.000304s ]
[ SQL ] SHOW COLUMNS FROM `yzn_category` [ RunTime:0.001123s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 0 AND `language` = 'default' ) ORDER BY `listorder` DESC LIMIT 10 [ RunTime:0.000508s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 169 AND `language` = 'default' ) ORDER BY `listorder` DESC LIMIT 10 [ RunTime:0.000312s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 171 AND `language` = 'default' ) ORDER BY `listorder` ASC LIMIT 10 [ RunTime:0.000267s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 171 AND `language` = 'default' ) ORDER BY `listorder` ASC LIMIT 2 [ RunTime:0.000331s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 1 AND `language` = 'default' ) ORDER BY `listorder` DESC LIMIT 10 [ RunTime:0.000456s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 158 AND `language` = 'default' ) ORDER BY `listorder` ASC LIMIT 10 [ RunTime:0.000431s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 8 AND `language` = 'default' ) ORDER BY `listorder` ASC LIMIT 10 [ RunTime:0.000418s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 8 AND `language` = 'default' ) ORDER BY `listorder` ASC LIMIT 2 [ RunTime:0.000386s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 2 AND `language` = 'default' ) ORDER BY `listorder` DESC LIMIT 10 [ RunTime:0.000336s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 10 AND `language` = 'default' ) ORDER BY `listorder` ASC LIMIT 10 [ RunTime:0.000318s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 11 AND `language` = 'default' ) ORDER BY `listorder` ASC LIMIT 10 [ RunTime:0.000304s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 11 AND `language` = 'default' ) ORDER BY `listorder` ASC LIMIT 2 [ RunTime:0.000409s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 3 AND `language` = 'default' ) ORDER BY `listorder` DESC LIMIT 10 [ RunTime:0.000290s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 3 AND `language` = 'default' ) ORDER BY `listorder` ASC LIMIT 2 [ RunTime:0.000294s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 4 AND `language` = 'default' ) ORDER BY `listorder` DESC LIMIT 10 [ RunTime:0.000246s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 4 AND `language` = 'default' ) ORDER BY `listorder` ASC LIMIT 2 [ RunTime:0.000248s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `yzn_test` `Test` LEFT JOIN `yzn_test_data` `Test_data` ON `Test`.`id`=`Test_data`.`did` WHERE ( flag != 1 AND `status`=1 AND `catid` = 5 ) [ RunTime:0.001413s ]
[ SQL ] SELECT `Test`.*,`Test_data`.* FROM `yzn_test` `Test` LEFT JOIN `yzn_test_data` `Test_data` ON `Test`.`id`=`Test_data`.`did` WHERE ( flag != 1 AND `status`=1 AND `catid` = 5 ) ORDER BY `listorder` ASC LIMIT 0,10 [ RunTime:0.001564s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 19 AND `language` = 'default' ) ORDER BY `listorder` ASC LIMIT 3 [ RunTime:0.000277s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `yzn_link` `Link` LEFT JOIN `yzn_link_data` `Link_data` ON `Link`.`id`=`Link_data`.`did` WHERE ( `status`=1 AND `catid` = 20 ) [ RunTime:0.000211s ]
[ SQL ] SELECT `Link`.*,`Link_data`.* FROM `yzn_link` `Link` LEFT JOIN `yzn_link_data` `Link_data` ON `Link`.`id`=`Link_data`.`did` WHERE ( `status`=1 AND `catid` = 20 ) ORDER BY `listorder` ASC LIMIT 0,100 [ RunTime:0.000216s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `yzn_link` `Link` LEFT JOIN `yzn_link_data` `Link_data` ON `Link`.`id`=`Link_data`.`did` WHERE ( `status`=1 AND `catid` = 21 ) [ RunTime:0.000185s ]
[ SQL ] SELECT `Link`.*,`Link_data`.* FROM `yzn_link` `Link` LEFT JOIN `yzn_link_data` `Link_data` ON `Link`.`id`=`Link_data`.`did` WHERE ( `status`=1 AND `catid` = 21 ) ORDER BY `listorder` ASC LIMIT 0,100 [ RunTime:0.000187s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `yzn_link` `Link` LEFT JOIN `yzn_link_data` `Link_data` ON `Link`.`id`=`Link_data`.`did` WHERE ( `status`=1 AND `catid` = 22 ) [ RunTime:0.000236s ]
[ SQL ] SELECT `Link`.*,`Link_data`.* FROM `yzn_link` `Link` LEFT JOIN `yzn_link_data` `Link_data` ON `Link`.`id`=`Link_data`.`did` WHERE ( `status`=1 AND `catid` = 22 ) ORDER BY `listorder` ASC LIMIT 0,100 [ RunTime:0.000193s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `yzn_link` WHERE ( `status`=1 AND `catid` = 24 ) [ RunTime:0.000221s ]
[ SQL ] SELECT * FROM `yzn_link` WHERE ( `status`=1 AND `catid` = 24 ) ORDER BY `listorder` ASC LIMIT 0,10 [ RunTime:0.000163s ]
时间：2017-04-14
来源：
目录
免费标准配送
免费礼品包装
预约门店服务
微博
抖音
小红书
公众号