[ BEHAVIOR ] Run app\index\behavior\UserActionLog @app_end [ RunTime:0.002169s ]
[ DB ] CONNECT:[ UseTime:0.000706s ] mysql:host=127.0.0.1;port=3306;dbname=jyjshop;charset=utf8mb4
[ SQL ] SHOW COLUMNS FROM `s_config` [ RunTime:0.001110s ]
[ SQL ] SELECT * FROM `s_config` [ RunTime:0.000216s ]
[ SQL ] SHOW COLUMNS FROM `s_user_rule` [ RunTime:0.001006s ]
[ SQL ] SELECT `id`,`pid`,`name`,`title`,`ismenu` FROM `s_user_rule` WHERE `status` = 'normal' [ RunTime:0.000328s ]
[ SQL ] SELECT * FROM `s_config` WHERE `name` = 'version' LIMIT 1 [ RunTime:0.000304s ]
[ SQL ] SHOW COLUMNS FROM `s_category` [ RunTime:0.000901s ]
[ SQL ] SELECT `id`,`name`,`type`,`flag` FROM `s_category` WHERE `type` = 'article_items' ORDER BY `id` ASC [ RunTime:0.000191s ]
[ SQL ] SHOW COLUMNS FROM `s_article_items` [ RunTime:0.000775s ]
[ SQL ] SELECT `id`,`name`,`createtime`,`is_show` FROM `s_article_items` WHERE `category_id` = 18 ORDER BY `id` ASC [ RunTime:0.000269s ]
[ SQL ] SELECT `id`,`name`,`createtime`,`is_show` FROM `s_article_items` WHERE `category_id` = 27 ORDER BY `id` ASC [ RunTime:0.000200s ]
[ SQL ] SELECT `id`,`name`,`createtime`,`is_show` FROM `s_article_items` WHERE `category_id` = 28 ORDER BY `id` ASC [ RunTime:0.000170s ]
[ SQL ] SELECT `id`,`name`,`createtime`,`is_show` FROM `s_article_items` WHERE `category_id` = 29 ORDER BY `id` ASC [ RunTime:0.000248s ]
[ SQL ] SELECT `id`,`name`,`createtime`,`is_show` FROM `s_article_items` WHERE `category_id` = 30 ORDER BY `id` ASC [ RunTime:0.000150s ]
[ SQL ] SELECT `id`,`name`,`createtime`,`is_show` FROM `s_article_items` WHERE `category_id` = 31 ORDER BY `id` ASC [ RunTime:0.000168s ]
[ SQL ] SELECT `id`,`name`,`createtime`,`is_show` FROM `s_article_items` WHERE `category_id` = 32 ORDER BY `id` ASC [ RunTime:0.000186s ]
[ SQL ] SELECT * FROM `s_config` WHERE `name` IN ('recruit_url','agent_url') [ RunTime:0.000179s ]
[ SQL ] SHOW COLUMNS FROM `s_menu_module_index` [ RunTime:0.000774s ]
[ SQL ] SELECT `dir_rules` FROM `s_menu_module_index` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000173s ]
[ SQL ] SHOW COLUMNS FROM `s_menu_module_index_left_dir` [ RunTime:0.000850s ]
[ SQL ] SELECT `dir_name`,`rules` FROM `s_menu_module_index_left_dir` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000184s ]
[ SQL ] SELECT * FROM `s_user_rule` WHERE `status` = 'normal' AND `id` IN (7,27,40,48,49,62,64,70,83) ORDER BY `weigh` DESC [ RunTime:0.000299s ]
[ SQL ] SELECT `id`,`module_name`,`rules` FROM `s_menu_module_index` ORDER BY `id` ASC [ RunTime:0.000198s ]
[ SQL ] SHOW COLUMNS FROM `s_goods_classs` [ RunTime:0.000798s ]
[ SQL ] SELECT id,classname FROM `s_goods_classs` WHERE `level` = 1 ORDER BY `weigh` DESC [ RunTime:0.000304s ]
[ SQL ] SHOW COLUMNS FROM `s_ad_items` [ RunTime:0.000734s ]
[ SQL ] SELECT * FROM `s_ad_items` WHERE `ad_posts_id` = 15 AND `switch` = 1 [ RunTime:0.000189s ]
[ SQL ] SELECT id,classname FROM `s_goods_classs` WHERE `level` = 2 AND `classparentid` = 5 ORDER BY `weigh` DESC LIMIT 2 [ RunTime:0.000204s ]
[ SQL ] SELECT id,classname FROM `s_goods_classs` WHERE `level` = 2 AND `classparentid` = 6 ORDER BY `weigh` DESC LIMIT 2 [ RunTime:0.000140s ]
[ SQL ] SELECT id,classname FROM `s_goods_classs` WHERE `level` = 2 AND `classparentid` = 8 ORDER BY `weigh` DESC LIMIT 2 [ RunTime:0.000151s ]
[ SQL ] SELECT id,classname FROM `s_goods_classs` WHERE `level` = 2 AND `classparentid` = 7 ORDER BY `weigh` DESC LIMIT 2 [ RunTime:0.000140s ]
[ SQL ] SELECT id,classname FROM `s_goods_classs` WHERE `level` = 2 AND `classparentid` = 9 ORDER BY `weigh` DESC LIMIT 2 [ RunTime:0.000138s ]
[ SQL ] SELECT id,classname FROM `s_goods_classs` WHERE `level` = 2 AND `classparentid` = 10 ORDER BY `weigh` DESC LIMIT 2 [ RunTime:0.000118s ]
[ SQL ] SELECT * FROM `s_ad_items` WHERE `ad_posts_id` = 15 AND `switch` = 1 [ RunTime:0.000149s ]
[ SQL ] SELECT * FROM `s_goods_classs` WHERE `switch` = 1 ORDER BY `weigh` DESC [ RunTime:0.000263s ]
[ SQL ] SELECT * FROM `s_ad_items` `ad_items` WHERE ( `ad_posts_id` IN (21,22,23,24,25,26) AND `switch` = 1 ) ORDER BY `ad_posts_id` ASC,`weigh` DESC,`id` DESC [ RunTime:0.000494s ]
[ SQL ] SELECT * FROM `s_goods_classs` `goods_classs` WHERE ( `level` = 3 AND `switch` = 1 ) ORDER BY `id` DESC [ RunTime:0.000374s ]
[ SQL ] SHOW COLUMNS FROM `s_store_brands` [ RunTime:0.001135s ]
[ SQL ] SELECT * FROM `s_store_brands` [ RunTime:0.000272s ]
[ SQL ] SELECT `value` FROM `s_config` WHERE `name` = 'systemtype' LIMIT 1 [ RunTime:0.000320s ]
[ SQL ] SHOW COLUMNS FROM `s_store` [ RunTime:0.001013s ]
[ SQL ] SELECT * FROM `s_store` WHERE `id` = 6197 LIMIT 1 [ RunTime:0.000701s ]
[ SQL ] SHOW COLUMNS FROM `s_cert_store` [ RunTime:0.000698s ]
[ SQL ] SELECT * FROM `s_cert_store` WHERE `uid` = 6197 LIMIT 1 [ RunTime:0.000425s ]
[ SQL ] SHOW COLUMNS FROM `s_shop_goodsclasss` [ RunTime:0.000632s ]
[ SQL ] SELECT * FROM `s_shop_goodsclasss` `shop_goodsclasss` WHERE ( `store_id` = 6197 AND `switch` = 1 AND `level` IN (1,2) ) ORDER BY `pid` ASC,`weigh` DESC LIMIT 0,100 [ RunTime:0.000534s ]
[ SQL ] SELECT * FROM `s_store_brands` WHERE `store_id` = 6197 [ RunTime:0.000482s ]
[ SQL ] SELECT * FROM `s_goods_classs` WHERE `switch` = 1 ORDER BY `weigh` DESC [ RunTime:0.000304s ]
[ SQL ] SHOW COLUMNS FROM `s_goods` [ RunTime:0.001305s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `s_goods` `goods` WHERE ( `store_id` = 6197 AND `upper_switch` = 1 AND `is_examine` = 1 AND `isdel` = 0 AND `is_price_negotiable` = 1 ) LIMIT 1 [ RunTime:0.011302s ]
[ SQL ] SELECT * FROM `s_goods` `goods` WHERE ( `store_id` = 6197 AND `upper_switch` = 1 AND `is_examine` = 1 AND `isdel` = 0 AND `is_price_negotiable` = 1 ) ORDER BY `order_count` DESC LIMIT 0,12 [ RunTime:0.022497s ]
[ SQL ] SELECT `id`,`name`,`store_name`,`store_type`,`avatar`,`score_service`,`score_logistics`,`score_business` FROM `s_store` WHERE `id` IN (6197) [ RunTime:0.000790s ]
[ SQL ] SELECT `id`,`classname` FROM `s_goods_classs` [ RunTime:0.000364s ]
[ SQL ] SELECT `id`,`classname` FROM `s_goods_classs` [ RunTime:0.000547s ]
[ SQL ] SHOW COLUMNS FROM `s_store_navigation` [ RunTime:0.001112s ]
[ SQL ] SELECT * FROM `s_store_navigation` WHERE `store_id` = 6197 [ RunTime:0.000492s ]
[ SQL ] SELECT * FROM `s_shop_goodsclasss` `shop_goodsclasss` WHERE ( `store_id` = 6197 AND `switch` = 1 AND `level` IN (1,2) ) ORDER BY `pid` ASC,`weigh` DESC LIMIT 0,100 [ RunTime:0.000490s ]
[ SQL ] SHOW COLUMNS FROM `s_func_list` [ RunTime:0.001268s ]
[ SQL ] SELECT * FROM `s_func_list` WHERE `url` = '/store/goods_list.html' AND `method` = 'GET' [ RunTime:0.000348s ]