[ BEHAVIOR ] Run app\index\behavior\UserActionLog @app_end [ RunTime:0.001288s ]
[ DB ] CONNECT:[ UseTime:0.000476s ] mysql:host=127.0.0.1;port=3306;dbname=jyjshop;charset=utf8mb4
[ SQL ] SHOW COLUMNS FROM `s_config` [ RunTime:0.000863s ]
[ SQL ] SELECT * FROM `s_config` [ RunTime:0.000205s ]
[ SQL ] SHOW COLUMNS FROM `s_user_rule` [ RunTime:0.001069s ]
[ SQL ] SELECT `id`,`pid`,`name`,`title`,`ismenu` FROM `s_user_rule` WHERE `status` = 'normal' [ RunTime:0.000305s ]
[ SQL ] SELECT * FROM `s_config` WHERE `name` = 'version' LIMIT 1 [ RunTime:0.000241s ]
[ SQL ] SHOW COLUMNS FROM `s_category` [ RunTime:0.000869s ]
[ SQL ] SELECT `id`,`name`,`type`,`flag` FROM `s_category` WHERE `type` = 'article_items' ORDER BY `id` ASC [ RunTime:0.000182s ]
[ SQL ] SHOW COLUMNS FROM `s_article_items` [ RunTime:0.000671s ]
[ SQL ] SELECT `id`,`name`,`createtime`,`is_show` FROM `s_article_items` WHERE `category_id` = 18 ORDER BY `id` ASC [ RunTime:0.000154s ]
[ SQL ] SELECT `id`,`name`,`createtime`,`is_show` FROM `s_article_items` WHERE `category_id` = 27 ORDER BY `id` ASC [ RunTime:0.000174s ]
[ SQL ] SELECT `id`,`name`,`createtime`,`is_show` FROM `s_article_items` WHERE `category_id` = 28 ORDER BY `id` ASC [ RunTime:0.000131s ]
[ SQL ] SELECT `id`,`name`,`createtime`,`is_show` FROM `s_article_items` WHERE `category_id` = 29 ORDER BY `id` ASC [ RunTime:0.000167s ]
[ SQL ] SELECT `id`,`name`,`createtime`,`is_show` FROM `s_article_items` WHERE `category_id` = 30 ORDER BY `id` ASC [ RunTime:0.000144s ]
[ SQL ] SELECT `id`,`name`,`createtime`,`is_show` FROM `s_article_items` WHERE `category_id` = 31 ORDER BY `id` ASC [ RunTime:0.000117s ]
[ SQL ] SELECT `id`,`name`,`createtime`,`is_show` FROM `s_article_items` WHERE `category_id` = 32 ORDER BY `id` ASC [ RunTime:0.000124s ]
[ SQL ] SELECT * FROM `s_config` WHERE `name` IN ('recruit_url','agent_url') [ RunTime:0.000146s ]
[ SQL ] SHOW COLUMNS FROM `s_menu_module_index` [ RunTime:0.000653s ]
[ SQL ] SELECT `dir_rules` FROM `s_menu_module_index` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000154s ]
[ SQL ] SHOW COLUMNS FROM `s_menu_module_index_left_dir` [ RunTime:0.000574s ]
[ SQL ] SELECT `dir_name`,`rules` FROM `s_menu_module_index_left_dir` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000223s ]
[ 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.000263s ]
[ SQL ] SELECT `id`,`module_name`,`rules` FROM `s_menu_module_index` ORDER BY `id` ASC [ RunTime:0.000138s ]
[ SQL ] SHOW COLUMNS FROM `s_goods_classs` [ RunTime:0.000691s ]
[ SQL ] SELECT id,classname FROM `s_goods_classs` WHERE `level` = 1 ORDER BY `weigh` DESC [ RunTime:0.000170s ]
[ SQL ] SHOW COLUMNS FROM `s_ad_items` [ RunTime:0.000574s ]
[ SQL ] SELECT * FROM `s_ad_items` WHERE `ad_posts_id` = 15 AND `switch` = 1 [ RunTime:0.000173s ]
[ SQL ] SELECT id,classname FROM `s_goods_classs` WHERE `level` = 2 AND `classparentid` = 5 ORDER BY `weigh` DESC LIMIT 2 [ RunTime:0.000155s ]
[ SQL ] SELECT id,classname FROM `s_goods_classs` WHERE `level` = 2 AND `classparentid` = 6 ORDER BY `weigh` DESC LIMIT 2 [ RunTime:0.000144s ]
[ SQL ] SELECT id,classname FROM `s_goods_classs` WHERE `level` = 2 AND `classparentid` = 8 ORDER BY `weigh` DESC LIMIT 2 [ RunTime:0.000142s ]
[ SQL ] SELECT id,classname FROM `s_goods_classs` WHERE `level` = 2 AND `classparentid` = 7 ORDER BY `weigh` DESC LIMIT 2 [ RunTime:0.000118s ]
[ SQL ] SELECT id,classname FROM `s_goods_classs` WHERE `level` = 2 AND `classparentid` = 9 ORDER BY `weigh` DESC LIMIT 2 [ RunTime:0.000102s ]
[ SQL ] SELECT id,classname FROM `s_goods_classs` WHERE `level` = 2 AND `classparentid` = 10 ORDER BY `weigh` DESC LIMIT 2 [ RunTime:0.000121s ]
[ SQL ] SELECT * FROM `s_ad_items` WHERE `ad_posts_id` = 15 AND `switch` = 1 [ RunTime:0.000132s ]
[ SQL ] SELECT * FROM `s_goods_classs` WHERE `switch` = 1 ORDER BY `weigh` DESC [ RunTime:0.000223s ]
[ 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.000437s ]
[ SQL ] SELECT * FROM `s_goods_classs` `goods_classs` WHERE ( `level` = 3 AND `switch` = 1 ) ORDER BY `id` DESC [ RunTime:0.000250s ]
[ SQL ] SELECT `value` FROM `s_config` WHERE `name` = 'systemtype' LIMIT 1 [ RunTime:0.000207s ]
[ SQL ] SELECT * FROM `s_goods_classs` WHERE `switch` = 1 ORDER BY `weigh` DESC [ RunTime:0.000199s ]
[ SQL ] SELECT `goods_standards_ids` FROM `s_goods_classs` WHERE `id` = 56 LIMIT 1 [ RunTime:0.000561s ]
[ SQL ] SHOW COLUMNS FROM `s_goods_standards` [ RunTime:0.000936s ]
[ SQL ] SELECT * FROM `s_goods_standards` `goods_standards` WHERE ( `switch` = 1 AND `id` IN (98,113) AND `searchswitch` = 1 ) ORDER BY field(id,098,113) LIMIT 0,100 [ RunTime:0.000312s ]
[ SQL ] select group_concat(distinct(goodsbrand)) as str from s_goods where `upper_switch`=1 [ RunTime:0.000269s ]
[ SQL ] SHOW COLUMNS FROM `s_store_brands` [ RunTime:0.000803s ]
[ SQL ] SELECT * FROM `s_store_brands` WHERE `apply` = '1' AND `store_type` = 0 AND `out_time` > '2024-06-28' AND `id` IN (22,1,5,-1,26,0) [ RunTime:0.000240s ]
[ SQL ] SHOW COLUMNS FROM `s_goods_hot` [ RunTime:0.000646s ]
[ SQL ] SELECT `goods_id` FROM `s_goods_hot` WHERE `type` = 1 ORDER BY `id` DESC LIMIT 4 [ RunTime:0.000153s ]
[ SQL ] SHOW COLUMNS FROM `s_cert_store` [ RunTime:0.000638s ]
[ SQL ] SELECT group_concat(uid) as id_str FROM `s_cert_store` WHERE `status` <> 3 LIMIT 1 [ RunTime:0.000149s ]
[ SQL ] SHOW COLUMNS FROM `s_goods` [ RunTime:0.001046s ]
[ SQL ] SELECT * FROM `s_goods` `goods` WHERE ( `id` IN (177,219,218,208) AND `store_id` NOT IN (20,32,113,3078,3310,3763,4294,4396,5166,5589,6168,6311,6568,21364,65395,67939,67959,67985,68009,68012,68088,68144,68179,68509,68606,68676,69033,69424,69510,69590,69813,69860,0) AND `upper_switch` = 1 AND `is_examine` = 1 AND `isdel` = 0 AND `is_price_negotiable` = 1 ) ORDER BY `id` DESC LIMIT 0,4 [ RunTime:0.000423s ]
[ SQL ] SHOW COLUMNS FROM `s_goods_unit` [ RunTime:0.000700s ]
[ SQL ] SELECT `is_integer` FROM `s_goods_unit` WHERE `id` = 7 AND `store_id` = 26 LIMIT 1 [ RunTime:0.000180s ]
[ SQL ] SELECT `is_integer` FROM `s_goods_unit` WHERE `id` = 7 AND `store_id` = 26 LIMIT 1 [ RunTime:0.000153s ]
[ SQL ] SELECT `is_integer` FROM `s_goods_unit` WHERE `id` = 7 AND `store_id` = 26 LIMIT 1 [ RunTime:0.000141s ]
[ SQL ] SELECT `is_integer` FROM `s_goods_unit` WHERE `id` = 7 AND `store_id` = 26 LIMIT 1 [ RunTime:0.000132s ]
[ SQL ] SELECT group_concat(uid) as id_str FROM `s_cert_store` WHERE `status` <> 3 LIMIT 1 [ RunTime:0.000130s ]
[ SQL ] SHOW COLUMNS FROM `s_store` [ RunTime:0.000994s ]
[ SQL ] SELECT `id`,`store_name` FROM `s_store` WHERE `id` IN (2858,3307,3735,21173,1785,5742,6253) [ RunTime:0.000456s ]
[ SQL ] SELECT group_concat(uid) as id_str FROM `s_cert_store` WHERE `status` <> 3 LIMIT 1 [ RunTime:0.000261s ]
[ SQL ] SELECT * FROM `s_goods` `goods` WHERE ( `store_id` NOT IN (20,32,113,3078,3310,3763,4294,4396,5166,5589,6168,6311,6568,21364,65395,67939,67959,67985,68009,68012,68088,68144,68179,68509,68606,68676,69033,69424,69510,69590,69813,69860,0) AND `upper_switch` = 1 AND `is_examine` = 1 AND `isdel` = 0 AND `is_price_negotiable` = 1 ) ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000371s ]
[ SQL ] SELECT `is_integer` FROM `s_goods_unit` WHERE `id` = 1 AND `store_id` = 27 LIMIT 1 [ RunTime:0.000212s ]
[ SQL ] SELECT `is_integer` FROM `s_goods_unit` WHERE `id` = 1 AND `store_id` = 27 LIMIT 1 [ RunTime:0.000152s ]
[ SQL ] SELECT `is_integer` FROM `s_goods_unit` WHERE `id` = 1 AND `store_id` = 27 LIMIT 1 [ RunTime:0.000139s ]
[ SQL ] SHOW COLUMNS FROM `s_func_list` [ RunTime:0.000740s ]
[ SQL ] SELECT * FROM `s_func_list` WHERE `url` = '/goods/goods_list.html' AND `method` = 'GET' [ RunTime:0.000192s ]