[ DB ] CONNECT:[ UseTime:0.000380s ] mysql:host=127.0.0.1;port=3306;dbname=v_360cm_net;charset=utf8
[ SQL ] SHOW COLUMNS FROM `yoshop_admin_head` [ RunTime:0.000718s ]
[ SQL ] SELECT * FROM `yoshop_admin_head` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000308s ]
[ SQL ] SHOW COLUMNS FROM `yoshop_admin_footer` [ RunTime:0.000627s ]
[ SQL ] SELECT * FROM `yoshop_admin_footer` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000278s ]
[ SQL ] SHOW COLUMNS FROM `yoshop_admin_footernav` [ RunTime:0.000588s ]
[ SQL ] SELECT * FROM `yoshop_admin_footernav` ORDER BY `sort` DESC [ RunTime:0.000286s ]
[ SQL ] SHOW COLUMNS FROM `yoshop_wxapp` [ RunTime:0.000686s ]
[ SQL ] SELECT * FROM `yoshop_wxapp` WHERE `wxapp_id` = 10001 LIMIT 1 [ RunTime:0.000381s ]
[ SQL ] SHOW COLUMNS FROM `yoshop_admin_adcolumn` [ RunTime:0.000661s ]
[ SQL ] SELECT * FROM `yoshop_admin_adcolumn` WHERE `id` > 1 [ RunTime:0.000403s ]
[ SQL ] SHOW COLUMNS FROM `yoshop_admin_banner` [ RunTime:0.000565s ]
[ SQL ] SELECT * FROM `yoshop_admin_banner` WHERE `status` = 1 ORDER BY `orders` DESC [ RunTime:0.000292s ]
[ SQL ] SHOW COLUMNS FROM `yoshop_goods_sku` [ RunTime:0.000600s ]
[ SQL ] SHOW COLUMNS FROM `yoshop_category` [ RunTime:0.000553s ]
[ SQL ] SHOW COLUMNS FROM `yoshop_goods` [ RunTime:0.000676s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `yoshop_goods` WHERE `is_delete` = 0 AND `goods_status` = 10 AND `wxapp_id` = 10001 LIMIT 1 [ RunTime:0.000508s ]
[ SQL ] SELECT *,(sales_initial + sales_actual) as goods_sales,( SELECT MIN(goods_price) FROM `yoshop_goods_sku` WHERE ( `goods_id` = `yoshop_goods`.`goods_id` ) ) AS goods_min_price,( SELECT MAX(goods_price) FROM `yoshop_goods_sku` WHERE ( `goods_id` = `yoshop_goods`.`goods_id` ) ) AS goods_max_price FROM `yoshop_goods` WHERE `is_delete` = 0 AND `goods_status` = 10 AND `wxapp_id` = 10001 ORDER BY `goods_sort`,`goods_id` DESC LIMIT 0,14 [ RunTime:0.001347s ]
[ SQL ] SELECT * FROM `yoshop_category` WHERE `category_id` IN (1) [ RunTime:0.000300s ]
[ SQL ] SHOW COLUMNS FROM `yoshop_goods_image` [ RunTime:0.000515s ]
[ SQL ] SELECT * FROM `yoshop_goods_image` WHERE `goods_id` IN (176,195,194,193,192,191,190,189,188,187,186,185,184,183) ORDER BY `id` ASC [ RunTime:0.000345s ]
[ SQL ] SHOW COLUMNS FROM `yoshop_upload_file` [ RunTime:0.000463s ]
[ SQL ] SELECT * FROM `yoshop_upload_file` WHERE `file_id` IN (1566,1596,1552,1599,1581,1580,1573,1567,1601,1602,1611,1614,1615,1613,1618) [ RunTime:0.000315s ]
[ SQL ] SELECT * FROM `yoshop_goods_sku` WHERE `goods_id` IN (176,195,194,193,192,191,190,189,188,187,186,185,184,183) ORDER BY `goods_sku_id` ASC [ RunTime:0.000436s ]
[ SQL ] SELECT * FROM `yoshop_category` WHERE `wxapp_id` = 10001 ORDER BY `sort` ASC,`create_time` ASC [ RunTime:0.000250s ]
[ SQL ] SELECT * FROM `yoshop_upload_file` WHERE `file_id` IN (296,1154,1179,0) [ RunTime:0.000253s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `yoshop_wxapp` WHERE `is_recycle` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000270s ]
[ SQL ] SELECT * FROM `yoshop_wxapp` WHERE `is_recycle` = 0 AND `is_delete` = 0 ORDER BY `create_time` DESC LIMIT 0,15 [ RunTime:0.000298s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `yoshop_goods` WHERE `is_delete` = 0 AND `goods_status` = 10 AND `wxapp_id` = 10001 LIMIT 1 [ RunTime:0.000333s ]
[ SQL ] SELECT *,(sales_initial + sales_actual) as goods_sales,( SELECT MIN(goods_price) FROM `yoshop_goods_sku` WHERE ( `goods_id` = `yoshop_goods`.`goods_id` ) ) AS goods_min_price,( SELECT MAX(goods_price) FROM `yoshop_goods_sku` WHERE ( `goods_id` = `yoshop_goods`.`goods_id` ) ) AS goods_max_price FROM `yoshop_goods` WHERE `is_delete` = 0 AND `goods_status` = 10 AND `wxapp_id` = 10001 ORDER BY `goods_sort`,`goods_id` DESC LIMIT 0,14 [ RunTime:0.000572s ]
[ SQL ] SELECT * FROM `yoshop_category` WHERE `category_id` IN (1) [ RunTime:0.000232s ]
[ SQL ] SELECT * FROM `yoshop_goods_image` WHERE `goods_id` IN (176,195,194,193,192,191,190,189,188,187,186,185,184,183) ORDER BY `id` ASC [ RunTime:0.000277s ]
[ SQL ] SELECT * FROM `yoshop_upload_file` WHERE `file_id` IN (1566,1596,1552,1599,1581,1580,1573,1567,1601,1602,1611,1614,1615,1613,1618) [ RunTime:0.000307s ]
[ SQL ] SELECT * FROM `yoshop_goods_sku` WHERE `goods_id` IN (176,195,194,193,192,191,190,189,188,187,186,185,184,183) ORDER BY `goods_sku_id` ASC [ RunTime:0.000348s ]
[ SQL ] SHOW COLUMNS FROM `yoshop_video_room` [ RunTime:0.000528s ]
[ SQL ] SELECT * FROM `yoshop_video_room` WHERE `status` <> 0 AND `end_status` <> 0 ORDER BY `sort`,`live_status` DESC [ RunTime:0.000328s ]
[ SQL ] SELECT * FROM `yoshop_video_room` WHERE `status` <> 0 AND `end_status` <> 0 ORDER BY `sort`,`live_status` DESC LIMIT 3 [ RunTime:0.000330s ]
[ SQL ] SHOW COLUMNS FROM `yoshop_store_user` [ RunTime:0.000492s ]
[ SQL ] SELECT `anchor_uid`,`anchor_name` FROM `yoshop_store_user` WHERE `store_user_id` = 10017 LIMIT 1 [ RunTime:0.000200s ]
[ SQL ] SHOW COLUMNS FROM `yoshop_user` [ RunTime:0.000462s ]
[ SQL ] SELECT `avatarUrl` FROM `yoshop_user` WHERE `user_id` = 148 LIMIT 1 [ RunTime:0.000203s ]
[ SQL ] SELECT `anchor_uid`,`anchor_name` FROM `yoshop_store_user` WHERE `store_user_id` = 10034 LIMIT 1 [ RunTime:0.000175s ]
[ SQL ] SELECT `avatarUrl` FROM `yoshop_user` WHERE `user_id` = 510 LIMIT 1 [ RunTime:0.000167s ]
[ SQL ] SELECT `anchor_uid`,`anchor_name` FROM `yoshop_store_user` WHERE `store_user_id` = 10091 LIMIT 1 [ RunTime:0.000183s ]
[ SQL ] SELECT `avatarUrl` FROM `yoshop_user` WHERE `user_id` = 132 LIMIT 1 [ RunTime:0.000170s ]
[ SQL ] SHOW COLUMNS FROM `yoshop_video_smallvideo` [ RunTime:0.000429s ]
[ SQL ] SELECT * FROM `yoshop_video_smallvideo` ORDER BY rand() LIMIT 15 [ RunTime:0.012769s ]
[ SQL ] SELECT * FROM `yoshop_user` WHERE `user_id` = 2814 LIMIT 1 [ RunTime:0.000414s ]
[ SQL ] SELECT * FROM `yoshop_user` WHERE `user_id` = 2814 LIMIT 1 [ RunTime:0.000360s ]
[ SQL ] SELECT * FROM `yoshop_user` WHERE `user_id` = 634 LIMIT 1 [ RunTime:0.000321s ]
[ SQL ] SELECT * FROM `yoshop_user` WHERE `user_id` = 2814 LIMIT 1 [ RunTime:0.000343s ]
[ SQL ] SELECT * FROM `yoshop_user` WHERE `user_id` = 2513 LIMIT 1 [ RunTime:0.000332s ]
[ SQL ] SELECT * FROM `yoshop_user` WHERE `user_id` = 338 LIMIT 1 [ RunTime:0.000332s ]
[ SQL ] SELECT * FROM `yoshop_user` WHERE `user_id` = 1866 LIMIT 1 [ RunTime:0.000327s ]
[ SQL ] SELECT * FROM `yoshop_user` WHERE `user_id` = 922 LIMIT 1 [ RunTime:0.000445s ]
[ SQL ] SELECT * FROM `yoshop_user` WHERE `user_id` = 233 LIMIT 1 [ RunTime:0.000392s ]
[ SQL ] SELECT * FROM `yoshop_user` WHERE `user_id` = 4975 LIMIT 1 [ RunTime:0.000366s ]
[ SQL ] SELECT * FROM `yoshop_user` WHERE `user_id` = 1502 LIMIT 1 [ RunTime:0.000340s ]
[ SQL ] SELECT * FROM `yoshop_user` WHERE `user_id` = 551 LIMIT 1 [ RunTime:0.000385s ]
[ SQL ] SELECT * FROM `yoshop_user` WHERE `user_id` = 1675 LIMIT 1 [ RunTime:0.000367s ]
[ SQL ] SELECT * FROM `yoshop_user` WHERE `user_id` = 2814 LIMIT 1 [ RunTime:0.000394s ]
[ SQL ] SELECT * FROM `yoshop_user` WHERE `user_id` = 205 LIMIT 1 [ RunTime:0.000363s ]
