SHOW FULL COLUMNS FROM `mrpr_config` [ RunTime:0.001577s ]
SELECT `value` FROM `mrpr_config` [ RunTime:0.000380s ]
SHOW FULL COLUMNS FROM `mrpr_search` [ RunTime:0.001150s ]
SELECT * FROM `mrpr_search` ORDER BY `id` DESC LIMIT 10 [ RunTime:0.000325s ]
SHOW FULL COLUMNS FROM `mrpr_cart` [ RunTime:0.001100s ]
SELECT COUNT(*) AS think_count FROM `mrpr_cart` WHERE `user_id` IS NULL LIMIT 1 [ RunTime:0.000266s ]
SHOW FULL COLUMNS FROM `mrpr_ad` [ RunTime:0.001124s ]
SELECT `thumb` FROM `mrpr_ad` WHERE `type_id` = 4 [ RunTime:0.000315s ]
SELECT `thumb` FROM `mrpr_ad` WHERE `type_id` = 5 [ RunTime:0.000283s ]
SHOW FULL COLUMNS FROM `mrpr_goods` [ RunTime:0.001426s ]
SELECT `sale_start_time` FROM `mrpr_goods` WHERE `goods_status` = 1 AND `sale_status` = 1 ORDER BY `sale_start_time` ASC [ RunTime:0.000430s ]
SHOW FULL COLUMNS FROM `mrpr_shopcategory` [ RunTime:0.001120s ]
SELECT * FROM `mrpr_shopcategory` WHERE `parent_id` = 0 AND `status` = 1 ORDER BY `id` ASC LIMIT 8 [ RunTime:0.000709s ]
SELECT * FROM `mrpr_shopcategory` WHERE `parent_id` = 879 AND `thumb_show_status` = 1 ORDER BY `id` ASC LIMIT 3 [ RunTime:0.000522s ]
SELECT * FROM `mrpr_shopcategory` WHERE `parent_id` = 0 AND `thumb_show_status` = 1 ORDER BY `id` ASC LIMIT 3 [ RunTime:0.000801s ]
SELECT * FROM `mrpr_shopcategory` WHERE `parent_id` = 832 AND `thumb_show_status` = 1 ORDER BY `id` ASC LIMIT 3 [ RunTime:0.000551s ]
SELECT * FROM `mrpr_shopcategory` WHERE `parent_id` = 853 AND `thumb_show_status` = 1 ORDER BY `id` ASC LIMIT 3 [ RunTime:0.000435s ]
SELECT * FROM `mrpr_shopcategory` WHERE `parent_id` = 950 AND `thumb_show_status` = 1 ORDER BY `id` ASC LIMIT 3 [ RunTime:0.000653s ]
SELECT * FROM `mrpr_shopcategory` WHERE `parent_id` = 765 AND `thumb_show_status` = 1 ORDER BY `id` ASC LIMIT 3 [ RunTime:0.000608s ]
SELECT * FROM `mrpr_shopcategory` WHERE `parent_id` = 866 AND `thumb_show_status` = 1 ORDER BY `id` ASC LIMIT 3 [ RunTime:0.000604s ]
SELECT * FROM `mrpr_shopcategory` WHERE `parent_id` = 738 AND `thumb_show_status` = 1 ORDER BY `id` ASC LIMIT 3 [ RunTime:0.000369s ]
SELECT * FROM `mrpr_shopcategory` WHERE `parent_id` = 736 AND `thumb_show_status` = 1 ORDER BY `id` ASC LIMIT 1 [ RunTime:0.000680s ]
SELECT * FROM `mrpr_shopcategory` WHERE `parent_id` = 728 AND `thumb_show_status` = 1 ORDER BY `id` ASC LIMIT 1 [ RunTime:0.000722s ]
SHOW FULL COLUMNS FROM `mrpr_nav_manage` [ RunTime:0.001087s ]
SELECT * FROM `mrpr_nav_manage` WHERE `show_status` = 2 ORDER BY `sort` ASC [ RunTime:0.000361s ]
SELECT `id`,`parent_id`,`cate_name` FROM `mrpr_shopcategory` WHERE `status` = 1 ORDER BY `listorder` ASC [ RunTime:0.000850s ]
SELECT COUNT(*) AS think_count FROM `mrpr_goods` `a` INNER JOIN `mrpr_goods_sn_manage` `b` ON `a`.`goods_id`=`b`.`goods_id` WHERE `sale_status` = 1 AND `goods_status` = 1 AND ( `goods_name` LIKE '%鞋子%' ) LIMIT 1 [ RunTime:0.000634s ]
SELECT `a`.*,`b`.`goods_thumb`,`b`.`goods_name`,`b`.`goods_sn` FROM `mrpr_goods` `a` INNER JOIN `mrpr_goods_sn_manage` `b` ON `a`.`goods_id`=`b`.`goods_id` WHERE `sale_status` = 1 AND `goods_status` = 1 AND ( `goods_name` LIKE '%鞋子%' ) ORDER BY `id` DESC LIMIT 0,30 [ RunTime:0.000832s ]
SHOW FULL COLUMNS FROM `mrpr_goods_sn_manage` [ RunTime:0.002121s ]
SELECT `goods_id`,`goods_thumb` FROM `mrpr_goods_sn_manage` WHERE `goods_sn` = 'W231020010R' [ RunTime:0.000956s ]
SELECT COUNT(*) AS think_count FROM `mrpr_goods_sn_manage` WHERE `goods_sn` = 'W231020010R' LIMIT 1 [ RunTime:0.000801s ]
SELECT * FROM `mrpr_goods` WHERE `goods_id` = 750 LIMIT 1 [ RunTime:0.000455s ]
SELECT `goods_id`,`goods_thumb` FROM `mrpr_goods_sn_manage` WHERE `goods_sn` = 'W231020008R' [ RunTime:0.000917s ]
SELECT COUNT(*) AS think_count FROM `mrpr_goods_sn_manage` WHERE `goods_sn` = 'W231020008R' LIMIT 1 [ RunTime:0.000770s ]
SELECT * FROM `mrpr_goods` WHERE `goods_id` = 747 LIMIT 1 [ RunTime:0.000439s ]
SELECT `goods_id`,`goods_thumb` FROM `mrpr_goods_sn_manage` WHERE `goods_sn` = 'W231020002R' [ RunTime:0.000953s ]
SELECT COUNT(*) AS think_count FROM `mrpr_goods_sn_manage` WHERE `goods_sn` = 'W231020002R' LIMIT 1 [ RunTime:0.000780s ]
SELECT * FROM `mrpr_goods` WHERE `goods_id` = 735 LIMIT 1 [ RunTime:0.000414s ]
SELECT * FROM `mrpr_goods` WHERE `goods_id` = 736 LIMIT 1 [ RunTime:0.000384s ]
SELECT `goods_id`,`goods_thumb` FROM `mrpr_goods_sn_manage` WHERE `goods_sn` = 'W231020002R' [ RunTime:0.000886s ]
SELECT COUNT(*) AS think_count FROM `mrpr_goods_sn_manage` WHERE `goods_sn` = 'W231020002R' LIMIT 1 [ RunTime:0.000769s ]
SELECT * FROM `mrpr_goods` WHERE `goods_id` = 735 LIMIT 1 [ RunTime:0.000407s ]
SELECT * FROM `mrpr_goods` WHERE `goods_id` = 736 LIMIT 1 [ RunTime:0.000378s ]
SELECT `goods_id`,`goods_thumb` FROM `mrpr_goods_sn_manage` WHERE `goods_sn` = 'W231019002R' [ RunTime:0.000880s ]
SELECT COUNT(*) AS think_count FROM `mrpr_goods_sn_manage` WHERE `goods_sn` = 'W231019002R' LIMIT 1 [ RunTime:0.000780s ]
SELECT * FROM `mrpr_goods` WHERE `goods_id` = 726 LIMIT 1 [ RunTime:0.000379s ]
SELECT * FROM `mrpr_goods` WHERE `goods_id` = 727 LIMIT 1 [ RunTime:0.000393s ]
SELECT * FROM `mrpr_goods` WHERE `goods_id` = 728 LIMIT 1 [ RunTime:0.000376s ]
SELECT `goods_id`,`goods_thumb` FROM `mrpr_goods_sn_manage` WHERE `goods_sn` = 'W231019002R' [ RunTime:0.000874s ]
SELECT COUNT(*) AS think_count FROM `mrpr_goods_sn_manage` WHERE `goods_sn` = 'W231019002R' LIMIT 1 [ RunTime:0.000770s ]
SELECT * FROM `mrpr_goods` WHERE `goods_id` = 726 LIMIT 1 [ RunTime:0.000410s ]
SELECT * FROM `mrpr_goods` WHERE `goods_id` = 727 LIMIT 1 [ RunTime:0.000378s ]
SELECT * FROM `mrpr_goods` WHERE `goods_id` = 728 LIMIT 1 [ RunTime:0.000405s ]
SELECT `goods_id`,`goods_thumb` FROM `mrpr_goods_sn_manage` WHERE `goods_sn` = 'W231019002R' [ RunTime:0.000907s ]
SELECT COUNT(*) AS think_count FROM `mrpr_goods_sn_manage` WHERE `goods_sn` = 'W231019002R' LIMIT 1 [ RunTime:0.000778s ]
SELECT * FROM `mrpr_goods` WHERE `goods_id` = 726 LIMIT 1 [ RunTime:0.000417s ]
SELECT * FROM `mrpr_goods` WHERE `goods_id` = 727 LIMIT 1 [ RunTime:0.000386s ]
SELECT * FROM `mrpr_goods` WHERE `goods_id` = 728 LIMIT 1 [ RunTime:0.000382s ]
SELECT `goods_id`,`goods_thumb` FROM `mrpr_goods_sn_manage` WHERE `goods_sn` = 'W231019001R' [ RunTime:0.000910s ]
SELECT COUNT(*) AS think_count FROM `mrpr_goods_sn_manage` WHERE `goods_sn` = 'W231019001R' LIMIT 1 [ RunTime:0.000782s ]
SELECT * FROM `mrpr_goods` WHERE `goods_id` = 722 LIMIT 1 [ RunTime:0.000412s ]
SELECT * FROM `mrpr_goods` WHERE `goods_id` = 723 LIMIT 1 [ RunTime:0.000384s ]
SELECT * FROM `mrpr_goods` WHERE `goods_id` = 724 LIMIT 1 [ RunTime:0.000399s ]
SELECT * FROM `mrpr_goods` WHERE `goods_id` = 725 LIMIT 1 [ RunTime:0.000380s ]
SELECT `goods_id`,`goods_thumb` FROM `mrpr_goods_sn_manage` WHERE `goods_sn` = 'W231019001R' [ RunTime:0.000897s ]
SELECT COUNT(*) AS think_count FROM `mrpr_goods_sn_manage` WHERE `goods_sn` = 'W231019001R' LIMIT 1 [ RunTime:0.000769s ]
SELECT * FROM `mrpr_goods` WHERE `goods_id` = 722 LIMIT 1 [ RunTime:0.000423s ]
SELECT * FROM `mrpr_goods` WHERE `goods_id` = 723 LIMIT 1 [ RunTime:0.000378s ]
SELECT * FROM `mrpr_goods` WHERE `goods_id` = 724 LIMIT 1 [ RunTime:0.000399s ]
SELECT * FROM `mrpr_goods` WHERE `goods_id` = 725 LIMIT 1 [ RunTime:0.000383s ]
SELECT `goods_id`,`goods_thumb` FROM `mrpr_goods_sn_manage` WHERE `goods_sn` = 'W231019001R' [ RunTime:0.000887s ]
SELECT COUNT(*) AS think_count FROM `mrpr_goods_sn_manage` WHERE `goods_sn` = 'W231019001R' LIMIT 1 [ RunTime:0.000835s ]
SELECT * FROM `mrpr_goods` WHERE `goods_id` = 722 LIMIT 1 [ RunTime:0.000386s ]
SELECT * FROM `mrpr_goods` WHERE `goods_id` = 723 LIMIT 1 [ RunTime:0.000386s ]
SELECT * FROM `mrpr_goods` WHERE `goods_id` = 724 LIMIT 1 [ RunTime:0.000386s ]
SELECT * FROM `mrpr_goods` WHERE `goods_id` = 725 LIMIT 1 [ RunTime:0.000391s ]
SELECT `goods_id`,`goods_thumb` FROM `mrpr_goods_sn_manage` WHERE `goods_sn` = 'W231019001R' [ RunTime:0.000961s ]
SELECT COUNT(*) AS think_count FROM `mrpr_goods_sn_manage` WHERE `goods_sn` = 'W231019001R' LIMIT 1 [ RunTime:0.000787s ]
SELECT * FROM `mrpr_goods` WHERE `goods_id` = 722 LIMIT 1 [ RunTime:0.000422s ]
SELECT * FROM `mrpr_goods` WHERE `goods_id` = 723 LIMIT 1 [ RunTime:0.000402s ]
SELECT * FROM `mrpr_goods` WHERE `goods_id` = 724 LIMIT 1 [ RunTime:0.000398s ]
SELECT * FROM `mrpr_goods` WHERE `goods_id` = 725 LIMIT 1 [ RunTime:0.000372s ]
SELECT COUNT(*) AS think_count FROM `mrpr_goods` `a` INNER JOIN `mrpr_goods_sn_manage` `b` ON `a`.`goods_id`=`b`.`goods_id` WHERE `sale_status` = 1 AND `goods_status` = 1 AND ( `goods_name` LIKE '%鞋子%' ) ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000618s ]