[ DB ] CONNECT:[ UseTime:0.008981s ] mysql:host=localhost;port=3306;dbname=web_hscnshop2;charset=utf8
[ SQL ] SHOW COLUMNS FROM `sys_url_route` [ RunTime:0.000620s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `sys_url_route` WHERE `is_open` = 1 LIMIT 1 [ RunTime:0.000410s ]
[ SQL ] SELECT `rule`,`route` FROM `sys_url_route` WHERE `is_open` = 1 [ RunTime:0.000316s ]
[ SQL ] SHOW COLUMNS FROM `sys_seo_config` [ RunTime:0.003089s ]
[ SQL ] SELECT * FROM `sys_seo_config` WHERE `webpage_type` = 'Goods/coupon' LIMIT 1 [ RunTime:0.000338s ]
[ SQL ] SELECT * FROM `sys_seo_config` WHERE `webpage_type` = 'all' LIMIT 1 [ RunTime:0.000229s ]
[ SQL ] SHOW COLUMNS FROM `ns_goods_category` [ RunTime:0.000840s ]
[ SQL ] SELECT `category_id`,`category_name`,`short_name`,`pid`,`category_pic` FROM `ns_goods_category` WHERE `level` = 1 AND `is_visible` = 1 ORDER BY `sort` DESC [ RunTime:0.000271s ]
[ SQL ] SELECT `category_id`,`category_name`,`short_name`,`pid`,`category_pic` FROM `ns_goods_category` WHERE `level` = 2 AND `is_visible` = 1 AND `pid` = 1 ORDER BY `sort` DESC [ RunTime:0.000310s ]
[ SQL ] SELECT `category_id`,`category_name`,`short_name`,`pid`,`category_pic` FROM `ns_goods_category` WHERE `level` = 3 AND `is_visible` = 1 AND `pid` = 6 ORDER BY `sort` DESC [ RunTime:0.000231s ]
[ SQL ] SELECT `category_id`,`category_name`,`short_name`,`pid`,`category_pic` FROM `ns_goods_category` WHERE `level` = 3 AND `is_visible` = 1 AND `pid` = 7 ORDER BY `sort` DESC [ RunTime:0.000235s ]
[ SQL ] SELECT `category_id`,`category_name`,`short_name`,`pid`,`category_pic` FROM `ns_goods_category` WHERE `level` = 2 AND `is_visible` = 1 AND `pid` = 2 ORDER BY `sort` DESC [ RunTime:0.000248s ]
[ SQL ] SELECT `category_id`,`category_name`,`short_name`,`pid`,`category_pic` FROM `ns_goods_category` WHERE `level` = 3 AND `is_visible` = 1 AND `pid` = 15 ORDER BY `sort` DESC [ RunTime:0.000275s ]
[ SQL ] SELECT `category_id`,`category_name`,`short_name`,`pid`,`category_pic` FROM `ns_goods_category` WHERE `level` = 3 AND `is_visible` = 1 AND `pid` = 16 ORDER BY `sort` DESC [ RunTime:0.000297s ]
[ SQL ] SELECT `category_id`,`category_name`,`short_name`,`pid`,`category_pic` FROM `ns_goods_category` WHERE `level` = 2 AND `is_visible` = 1 AND `pid` = 3 ORDER BY `sort` DESC [ RunTime:0.000223s ]
[ SQL ] SELECT `category_id`,`category_name`,`short_name`,`pid`,`category_pic` FROM `ns_goods_category` WHERE `level` = 3 AND `is_visible` = 1 AND `pid` = 13 ORDER BY `sort` DESC [ RunTime:0.000210s ]
[ SQL ] SELECT `category_id`,`category_name`,`short_name`,`pid`,`category_pic` FROM `ns_goods_category` WHERE `level` = 3 AND `is_visible` = 1 AND `pid` = 14 ORDER BY `sort` DESC [ RunTime:0.000265s ]
[ SQL ] SELECT `category_id`,`category_name`,`short_name`,`pid`,`category_pic` FROM `ns_goods_category` WHERE `level` = 2 AND `is_visible` = 1 AND `pid` = 4 ORDER BY `sort` DESC [ RunTime:0.000304s ]
[ SQL ] SELECT `category_id`,`category_name`,`short_name`,`pid`,`category_pic` FROM `ns_goods_category` WHERE `level` = 3 AND `is_visible` = 1 AND `pid` = 9 ORDER BY `sort` DESC [ RunTime:0.000205s ]
[ SQL ] SELECT `category_id`,`category_name`,`short_name`,`pid`,`category_pic` FROM `ns_goods_category` WHERE `level` = 3 AND `is_visible` = 1 AND `pid` = 10 ORDER BY `sort` DESC [ RunTime:0.000320s ]
[ SQL ] SELECT `category_id`,`category_name`,`short_name`,`pid`,`category_pic` FROM `ns_goods_category` WHERE `level` = 3 AND `is_visible` = 1 AND `pid` = 11 ORDER BY `sort` DESC [ RunTime:0.000226s ]
[ SQL ] SELECT `category_id`,`category_name`,`short_name`,`pid`,`category_pic` FROM `ns_goods_category` WHERE `level` = 3 AND `is_visible` = 1 AND `pid` = 12 ORDER BY `sort` DESC [ RunTime:0.000202s ]
[ SQL ] SELECT `category_id`,`category_name`,`short_name`,`pid`,`category_pic` FROM `ns_goods_category` WHERE `level` = 3 AND `is_visible` = 1 AND `pid` = 17 ORDER BY `sort` DESC [ RunTime:0.000222s ]
[ SQL ] SELECT `category_id`,`category_name`,`short_name`,`pid`,`category_pic` FROM `ns_goods_category` WHERE `level` = 2 AND `is_visible` = 1 AND `pid` = 5 ORDER BY `sort` DESC [ RunTime:0.000210s ]
[ SQL ] SELECT `category_id`,`category_name`,`short_name`,`pid`,`category_pic` FROM `ns_goods_category` WHERE `level` = 3 AND `is_visible` = 1 AND `pid` = 8 ORDER BY `sort` DESC [ RunTime:0.000200s ]
[ SQL ] SELECT `category_id`,`category_name`,`short_name`,`pid`,`category_pic` FROM `ns_goods_category` WHERE `level` = 3 AND `is_visible` = 1 AND `pid` = 28 ORDER BY `sort` DESC [ RunTime:0.000212s ]
[ SQL ] SELECT `category_id`,`category_name`,`short_name`,`pid`,`category_pic` FROM `ns_goods_category` WHERE `level` = 2 AND `is_visible` = 1 AND `pid` = 29 ORDER BY `sort` DESC [ RunTime:0.000234s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `sys_url_route` WHERE `is_open` = 1 LIMIT 1 [ RunTime:0.000508s ]
[ SQL ] SELECT `rule`,`route` FROM `sys_url_route` WHERE `is_open` = 1 [ RunTime:0.000465s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `sys_url_route` WHERE `is_open` = 1 LIMIT 1 [ RunTime:0.000545s ]
[ SQL ] SELECT `rule`,`route` FROM `sys_url_route` WHERE `is_open` = 1 [ RunTime:0.000627s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `sys_url_route` WHERE `is_open` = 1 LIMIT 1 [ RunTime:0.000530s ]
[ SQL ] SELECT `rule`,`route` FROM `sys_url_route` WHERE `is_open` = 1 [ RunTime:0.000354s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `sys_url_route` WHERE `is_open` = 1 LIMIT 1 [ RunTime:0.000373s ]
[ SQL ] SELECT `rule`,`route` FROM `sys_url_route` WHERE `is_open` = 1 [ RunTime:0.000612s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `sys_url_route` WHERE `is_open` = 1 LIMIT 1 [ RunTime:0.000311s ]
[ SQL ] SELECT `rule`,`route` FROM `sys_url_route` WHERE `is_open` = 1 [ RunTime:0.000310s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `sys_url_route` WHERE `is_open` = 1 LIMIT 1 [ RunTime:0.000262s ]
[ SQL ] SELECT `rule`,`route` FROM `sys_url_route` WHERE `is_open` = 1 [ RunTime:0.000257s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `sys_url_route` WHERE `is_open` = 1 LIMIT 1 [ RunTime:0.000291s ]
[ SQL ] SELECT `rule`,`route` FROM `sys_url_route` WHERE `is_open` = 1 [ RunTime:0.000260s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `sys_url_route` WHERE `is_open` = 1 LIMIT 1 [ RunTime:0.000271s ]
[ SQL ] SELECT `rule`,`route` FROM `sys_url_route` WHERE `is_open` = 1 [ RunTime:0.000278s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `sys_url_route` WHERE `is_open` = 1 LIMIT 1 [ RunTime:0.000269s ]
[ SQL ] SELECT `rule`,`route` FROM `sys_url_route` WHERE `is_open` = 1 [ RunTime:0.000295s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `sys_url_route` WHERE `is_open` = 1 LIMIT 1 [ RunTime:0.000288s ]
[ SQL ] SELECT `rule`,`route` FROM `sys_url_route` WHERE `is_open` = 1 [ RunTime:0.000280s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `sys_url_route` WHERE `is_open` = 1 LIMIT 1 [ RunTime:0.000270s ]
[ SQL ] SELECT `rule`,`route` FROM `sys_url_route` WHERE `is_open` = 1 [ RunTime:0.000272s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `sys_url_route` WHERE `is_open` = 1 LIMIT 1 [ RunTime:0.000392s ]
[ SQL ] SELECT `rule`,`route` FROM `sys_url_route` WHERE `is_open` = 1 [ RunTime:0.000680s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `sys_url_route` WHERE `is_open` = 1 LIMIT 1 [ RunTime:0.000371s ]
[ SQL ] SELECT `rule`,`route` FROM `sys_url_route` WHERE `is_open` = 1 [ RunTime:0.002181s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `sys_url_route` WHERE `is_open` = 1 LIMIT 1 [ RunTime:0.000229s ]
[ SQL ] SELECT `rule`,`route` FROM `sys_url_route` WHERE `is_open` = 1 [ RunTime:0.000299s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `sys_url_route` WHERE `is_open` = 1 LIMIT 1 [ RunTime:0.000159s ]
[ SQL ] SELECT `rule`,`route` FROM `sys_url_route` WHERE `is_open` = 1 [ RunTime:0.000179s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `sys_url_route` WHERE `is_open` = 1 LIMIT 1 [ RunTime:0.000191s ]
[ SQL ] SELECT `rule`,`route` FROM `sys_url_route` WHERE `is_open` = 1 [ RunTime:0.000171s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `sys_url_route` WHERE `is_open` = 1 LIMIT 1 [ RunTime:0.000350s ]
[ SQL ] SELECT `rule`,`route` FROM `sys_url_route` WHERE `is_open` = 1 [ RunTime:0.000353s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `sys_url_route` WHERE `is_open` = 1 LIMIT 1 [ RunTime:0.000265s ]
[ SQL ] SELECT `rule`,`route` FROM `sys_url_route` WHERE `is_open` = 1 [ RunTime:0.000203s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `sys_url_route` WHERE `is_open` = 1 LIMIT 1 [ RunTime:0.000246s ]
[ SQL ] SELECT `rule`,`route` FROM `sys_url_route` WHERE `is_open` = 1 [ RunTime:0.000226s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `sys_url_route` WHERE `is_open` = 1 LIMIT 1 [ RunTime:0.000188s ]
[ SQL ] SELECT `rule`,`route` FROM `sys_url_route` WHERE `is_open` = 1 [ RunTime:0.000299s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `sys_url_route` WHERE `is_open` = 1 LIMIT 1 [ RunTime:0.000344s ]
[ SQL ] SELECT `rule`,`route` FROM `sys_url_route` WHERE `is_open` = 1 [ RunTime:0.000183s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `sys_url_route` WHERE `is_open` = 1 LIMIT 1 [ RunTime:0.000296s ]
[ SQL ] SELECT `rule`,`route` FROM `sys_url_route` WHERE `is_open` = 1 [ RunTime:0.000194s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `sys_url_route` WHERE `is_open` = 1 LIMIT 1 [ RunTime:0.000168s ]
[ SQL ] SELECT `rule`,`route` FROM `sys_url_route` WHERE `is_open` = 1 [ RunTime:0.000162s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `sys_url_route` WHERE `is_open` = 1 LIMIT 1 [ RunTime:0.000294s ]
[ SQL ] SELECT `rule`,`route` FROM `sys_url_route` WHERE `is_open` = 1 [ RunTime:0.000239s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `sys_url_route` WHERE `is_open` = 1 LIMIT 1 [ RunTime:0.000329s ]
[ SQL ] SELECT `rule`,`route` FROM `sys_url_route` WHERE `is_open` = 1 [ RunTime:0.000248s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `sys_url_route` WHERE `is_open` = 1 LIMIT 1 [ RunTime:0.000238s ]
[ SQL ] SELECT `rule`,`route` FROM `sys_url_route` WHERE `is_open` = 1 [ RunTime:0.000192s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `sys_url_route` WHERE `is_open` = 1 LIMIT 1 [ RunTime:0.000217s ]
[ SQL ] SELECT `rule`,`route` FROM `sys_url_route` WHERE `is_open` = 1 [ RunTime:0.000331s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `sys_url_route` WHERE `is_open` = 1 LIMIT 1 [ RunTime:0.000211s ]
[ SQL ] SELECT `rule`,`route` FROM `sys_url_route` WHERE `is_open` = 1 [ RunTime:0.001138s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `sys_url_route` WHERE `is_open` = 1 LIMIT 1 [ RunTime:0.000504s ]
[ SQL ] SELECT `rule`,`route` FROM `sys_url_route` WHERE `is_open` = 1 [ RunTime:0.000231s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `sys_url_route` WHERE `is_open` = 1 LIMIT 1 [ RunTime:0.000299s ]
[ SQL ] SELECT `rule`,`route` FROM `sys_url_route` WHERE `is_open` = 1 [ RunTime:0.000198s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `sys_url_route` WHERE `is_open` = 1 LIMIT 1 [ RunTime:0.000254s ]
[ SQL ] SELECT `rule`,`route` FROM `sys_url_route` WHERE `is_open` = 1 [ RunTime:0.000162s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `sys_url_route` WHERE `is_open` = 1 LIMIT 1 [ RunTime:0.000283s ]
[ SQL ] SELECT `rule`,`route` FROM `sys_url_route` WHERE `is_open` = 1 [ RunTime:0.000176s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `sys_url_route` WHERE `is_open` = 1 LIMIT 1 [ RunTime:0.000175s ]
[ SQL ] SELECT `rule`,`route` FROM `sys_url_route` WHERE `is_open` = 1 [ RunTime:0.000164s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `sys_url_route` WHERE `is_open` = 1 LIMIT 1 [ RunTime:0.000177s ]
[ SQL ] SELECT `rule`,`route` FROM `sys_url_route` WHERE `is_open` = 1 [ RunTime:0.000158s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `sys_url_route` WHERE `is_open` = 1 LIMIT 1 [ RunTime:0.000277s ]
[ SQL ] SELECT `rule`,`route` FROM `sys_url_route` WHERE `is_open` = 1 [ RunTime:0.000244s ]
[ SQL ] SHOW COLUMNS FROM `ns_platform_adv_position` [ RunTime:0.000857s ]
[ SQL ] SELECT * FROM `ns_platform_adv_position` WHERE `ap_keyword` = 'PC_COUPON_SWIPER' AND `is_use` = 1 LIMIT 1 [ RunTime:0.000909s ]
[ SQL ] SHOW COLUMNS FROM `ns_platform_adv` [ RunTime:0.000711s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ns_platform_adv` WHERE `ap_id` = 6682 LIMIT 1 [ RunTime:0.000275s ]
[ SQL ] SELECT * FROM `ns_platform_adv` WHERE `ap_id` = 6682 [ RunTime:0.000517s ]
[ SQL ] SHOW COLUMNS FROM `ns_coupon_type` [ RunTime:0.000586s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ns_coupon_type` WHERE ( (count > 0 AND end_time > 1786533142 AND is_show = 1 AND term_of_validity_type = 0 AND status = 0)OR (term_of_validity_type = 1 AND is_show = 1 AND status = 0) ) LIMIT 1 [ RunTime:0.000277s ]
[ SQL ] SELECT `coupon_type_id`,`coupon_name`,`money`,`count`,`max_fetch`,`at_least`,`need_user_level`,`range_type`,`start_time`,`end_time`,`create_time`,`update_time`,`is_show`,`term_of_validity_type`,`fixed_term`,`get_num`,`is_end` FROM `ns_coupon_type` WHERE ( (count > 0 AND end_time > 1786533142 AND is_show = 1 AND term_of_validity_type = 0 AND status = 0)OR (term_of_validity_type = 1 AND is_show = 1 AND status = 0) ) ORDER BY `create_time` DESC LIMIT 0,20 [ RunTime:0.000415s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `sys_url_route` WHERE `is_open` = 1 LIMIT 1 [ RunTime:0.000295s ]
[ SQL ] SELECT `rule`,`route` FROM `sys_url_route` WHERE `is_open` = 1 [ RunTime:0.000139s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `sys_url_route` WHERE `is_open` = 1 LIMIT 1 [ RunTime:0.000218s ]
[ SQL ] SELECT `rule`,`route` FROM `sys_url_route` WHERE `is_open` = 1 [ RunTime:0.000252s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `sys_url_route` WHERE `is_open` = 1 LIMIT 1 [ RunTime:0.000273s ]
[ SQL ] SELECT `rule`,`route` FROM `sys_url_route` WHERE `is_open` = 1 [ RunTime:0.000144s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `sys_url_route` WHERE `is_open` = 1 LIMIT 1 [ RunTime:0.000291s ]
[ SQL ] SELECT `rule`,`route` FROM `sys_url_route` WHERE `is_open` = 1 [ RunTime:0.000136s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `sys_url_route` WHERE `is_open` = 1 LIMIT 1 [ RunTime:0.000223s ]
[ SQL ] SELECT `rule`,`route` FROM `sys_url_route` WHERE `is_open` = 1 [ RunTime:0.000202s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `sys_url_route` WHERE `is_open` = 1 LIMIT 1 [ RunTime:0.000229s ]
[ SQL ] SELECT `rule`,`route` FROM `sys_url_route` WHERE `is_open` = 1 [ RunTime:0.000164s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `sys_url_route` WHERE `is_open` = 1 LIMIT 1 [ RunTime:0.000189s ]
[ SQL ] SELECT `rule`,`route` FROM `sys_url_route` WHERE `is_open` = 1 [ RunTime:0.000161s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `sys_url_route` WHERE `is_open` = 1 LIMIT 1 [ RunTime:0.000158s ]
[ SQL ] SELECT `rule`,`route` FROM `sys_url_route` WHERE `is_open` = 1 [ RunTime:0.000233s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `sys_url_route` WHERE `is_open` = 1 LIMIT 1 [ RunTime:0.000147s ]
[ SQL ] SELECT `rule`,`route` FROM `sys_url_route` WHERE `is_open` = 1 [ RunTime:0.000173s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `sys_url_route` WHERE `is_open` = 1 LIMIT 1 [ RunTime:0.000232s ]
[ SQL ] SELECT `rule`,`route` FROM `sys_url_route` WHERE `is_open` = 1 [ RunTime:0.000195s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `sys_url_route` WHERE `is_open` = 1 LIMIT 1 [ RunTime:0.000317s ]
[ SQL ] SELECT `rule`,`route` FROM `sys_url_route` WHERE `is_open` = 1 [ RunTime:0.000329s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `sys_url_route` WHERE `is_open` = 1 LIMIT 1 [ RunTime:0.000174s ]
[ SQL ] SELECT `rule`,`route` FROM `sys_url_route` WHERE `is_open` = 1 [ RunTime:0.000162s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `sys_url_route` WHERE `is_open` = 1 LIMIT 1 [ RunTime:0.000186s ]
[ SQL ] SELECT `rule`,`route` FROM `sys_url_route` WHERE `is_open` = 1 [ RunTime:0.000177s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `sys_url_route` WHERE `is_open` = 1 LIMIT 1 [ RunTime:0.000168s ]
[ SQL ] SELECT `rule`,`route` FROM `sys_url_route` WHERE `is_open` = 1 [ RunTime:0.000157s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `sys_url_route` WHERE `is_open` = 1 LIMIT 1 [ RunTime:0.000263s ]
[ SQL ] SELECT `rule`,`route` FROM `sys_url_route` WHERE `is_open` = 1 [ RunTime:0.000320s ]
