SHOW FULL COLUMNS FROM `mrpr_config` [ RunTime:0.001631s ]
SELECT `value` FROM `mrpr_config` [ RunTime:0.000363s ]
SHOW FULL COLUMNS FROM `mrpr_search` [ RunTime:0.001235s ]
SELECT * FROM `mrpr_search` ORDER BY `id` DESC LIMIT 10 [ RunTime:0.000323s ]
SHOW FULL COLUMNS FROM `mrpr_cart` [ RunTime:0.001131s ]
SELECT COUNT(*) AS think_count FROM `mrpr_cart` WHERE `user_id` IS NULL LIMIT 1 [ RunTime:0.000284s ]
SHOW FULL COLUMNS FROM `mrpr_ad` [ RunTime:0.001153s ]
SELECT `thumb` FROM `mrpr_ad` WHERE `type_id` = 4 [ RunTime:0.000328s ]
SELECT `thumb` FROM `mrpr_ad` WHERE `type_id` = 5 [ RunTime:0.000279s ]
SHOW FULL COLUMNS FROM `mrpr_goods` [ RunTime:0.001400s ]
SELECT `sale_start_time` FROM `mrpr_goods` WHERE `goods_status` = 1 AND `sale_status` = 1 ORDER BY `sale_start_time` ASC [ RunTime:0.000435s ]
SHOW FULL COLUMNS FROM `mrpr_shopcategory` [ RunTime:0.001112s ]
SELECT * FROM `mrpr_shopcategory` WHERE `parent_id` = 0 AND `status` = 1 ORDER BY `id` ASC LIMIT 8 [ RunTime:0.000702s ]
SELECT * FROM `mrpr_shopcategory` WHERE `parent_id` = 879 AND `thumb_show_status` = 1 ORDER BY `id` ASC LIMIT 3 [ RunTime:0.000546s ]
SELECT * FROM `mrpr_shopcategory` WHERE `parent_id` = 0 AND `thumb_show_status` = 1 ORDER BY `id` ASC LIMIT 3 [ RunTime:0.000797s ]
SELECT * FROM `mrpr_shopcategory` WHERE `parent_id` = 832 AND `thumb_show_status` = 1 ORDER BY `id` ASC LIMIT 3 [ RunTime:0.000548s ]
SELECT * FROM `mrpr_shopcategory` WHERE `parent_id` = 853 AND `thumb_show_status` = 1 ORDER BY `id` ASC LIMIT 3 [ RunTime:0.000421s ]
SELECT * FROM `mrpr_shopcategory` WHERE `parent_id` = 950 AND `thumb_show_status` = 1 ORDER BY `id` ASC LIMIT 3 [ RunTime:0.000673s ]
SELECT * FROM `mrpr_shopcategory` WHERE `parent_id` = 765 AND `thumb_show_status` = 1 ORDER BY `id` ASC LIMIT 3 [ RunTime:0.000610s ]
SELECT * FROM `mrpr_shopcategory` WHERE `parent_id` = 866 AND `thumb_show_status` = 1 ORDER BY `id` ASC LIMIT 3 [ RunTime:0.000600s ]
SELECT * FROM `mrpr_shopcategory` WHERE `parent_id` = 738 AND `thumb_show_status` = 1 ORDER BY `id` ASC LIMIT 3 [ RunTime:0.000364s ]
SELECT * FROM `mrpr_shopcategory` WHERE `parent_id` = 736 AND `thumb_show_status` = 1 ORDER BY `id` ASC LIMIT 1 [ RunTime:0.000690s ]
SELECT * FROM `mrpr_shopcategory` WHERE `parent_id` = 728 AND `thumb_show_status` = 1 ORDER BY `id` ASC LIMIT 1 [ RunTime:0.000756s ]
SHOW FULL COLUMNS FROM `mrpr_nav_manage` [ RunTime:0.001103s ]
SELECT * FROM `mrpr_nav_manage` WHERE `show_status` = 2 ORDER BY `sort` ASC [ RunTime:0.000345s ]
SELECT `id`,`parent_id`,`cate_name` FROM `mrpr_shopcategory` WHERE `status` = 1 ORDER BY `listorder` ASC [ RunTime:0.000848s ]
SHOW FULL COLUMNS FROM `mrpr_category` [ RunTime:0.001189s ]
SELECT * FROM `mrpr_category` WHERE ( id=774 ) LIMIT 1 [ RunTime:0.000307s ]
SELECT * FROM `mrpr_shopcategory` WHERE `id` = 774 LIMIT 1 [ RunTime:0.000329s ]
SELECT * FROM `mrpr_shopcategory` WHERE `id` = 774 LIMIT 1 [ RunTime:0.000312s ]
SELECT `id`,`cate_name` FROM `mrpr_shopcategory` WHERE `parent_id` = 765 ORDER BY `listorder` ASC [ RunTime:0.000748s ]
SHOW FULL COLUMNS FROM `mrpr_goods_shop_cate` [ RunTime:0.001050s ]
SELECT COUNT(*) AS think_count FROM `mrpr_goods_shop_cate` `a` INNER JOIN `mrpr_goods` `b` ON `a`.`gs_id`=`b`.`id` WHERE `sale_status` = '1' AND `goods_status` = '1' AND ( `shop_cate_id` = 774 ) LIMIT 1 [ RunTime:0.000678s ]
SELECT `a`.*,`b`.`goods_status`,`b`.`sale_status`,`b`.`id`,`b`.`goods_price`,`b`.`market_price` FROM `mrpr_goods_shop_cate` `a` INNER JOIN `mrpr_goods` `b` ON `a`.`gs_id`=`b`.`id` WHERE `sale_status` = '1' AND `goods_status` = '1' AND ( `shop_cate_id` = 774 ) ORDER BY `goods_id` DESC LIMIT 0,30 [ RunTime:0.000740s ]
SHOW FULL COLUMNS FROM `mrpr_goods_sn_manage` [ RunTime:0.002123s ]
SELECT * FROM `mrpr_goods_sn_manage` WHERE `goods_id` = 731 LIMIT 1 [ RunTime:0.000615s ]
SELECT `goods_id`,`goods_thumb` FROM `mrpr_goods_sn_manage` WHERE `goods_sn` = 'W231019003R' [ RunTime:0.000981s ]
SELECT COUNT(*) AS think_count FROM `mrpr_goods_sn_manage` WHERE `goods_sn` = 'W231019003R' LIMIT 1 [ RunTime:0.000806s ]
SELECT * FROM `mrpr_goods` WHERE `goods_id` = 729 LIMIT 1 [ RunTime:0.000446s ]
SELECT * FROM `mrpr_goods` WHERE `goods_id` = 730 LIMIT 1 [ RunTime:0.000404s ]
SELECT * FROM `mrpr_goods` WHERE `goods_id` = 731 LIMIT 1 [ RunTime:0.000402s ]
SELECT * FROM `mrpr_goods_sn_manage` WHERE `goods_id` = 730 LIMIT 1 [ RunTime:0.000430s ]
SELECT `goods_id`,`goods_thumb` FROM `mrpr_goods_sn_manage` WHERE `goods_sn` = 'W231019003R' [ RunTime:0.000916s ]
SELECT COUNT(*) AS think_count FROM `mrpr_goods_sn_manage` WHERE `goods_sn` = 'W231019003R' LIMIT 1 [ RunTime:0.000858s ]
SELECT * FROM `mrpr_goods` WHERE `goods_id` = 729 LIMIT 1 [ RunTime:0.000416s ]
SELECT * FROM `mrpr_goods` WHERE `goods_id` = 730 LIMIT 1 [ RunTime:0.000404s ]
SELECT * FROM `mrpr_goods` WHERE `goods_id` = 731 LIMIT 1 [ RunTime:0.000403s ]
SELECT * FROM `mrpr_goods_sn_manage` WHERE `goods_id` = 729 LIMIT 1 [ RunTime:0.000429s ]
SELECT `goods_id`,`goods_thumb` FROM `mrpr_goods_sn_manage` WHERE `goods_sn` = 'W231019003R' [ RunTime:0.000900s ]
SELECT COUNT(*) AS think_count FROM `mrpr_goods_sn_manage` WHERE `goods_sn` = 'W231019003R' LIMIT 1 [ RunTime:0.000793s ]
SELECT * FROM `mrpr_goods` WHERE `goods_id` = 729 LIMIT 1 [ RunTime:0.000391s ]
SELECT * FROM `mrpr_goods` WHERE `goods_id` = 730 LIMIT 1 [ RunTime:0.000415s ]
SELECT * FROM `mrpr_goods` WHERE `goods_id` = 731 LIMIT 1 [ RunTime:0.000384s ]
SELECT * FROM `mrpr_goods_sn_manage` WHERE `goods_id` = 728 LIMIT 1 [ RunTime:0.000435s ]
SELECT `goods_id`,`goods_thumb` FROM `mrpr_goods_sn_manage` WHERE `goods_sn` = 'W231019002R' [ RunTime:0.000900s ]
SELECT COUNT(*) AS think_count FROM `mrpr_goods_sn_manage` WHERE `goods_sn` = 'W231019002R' LIMIT 1 [ RunTime:0.000821s ]
SELECT * FROM `mrpr_goods` WHERE `goods_id` = 726 LIMIT 1 [ RunTime:0.000415s ]
SELECT * FROM `mrpr_goods` WHERE `goods_id` = 727 LIMIT 1 [ RunTime:0.000424s ]
SELECT * FROM `mrpr_goods` WHERE `goods_id` = 728 LIMIT 1 [ RunTime:0.000400s ]
SELECT * FROM `mrpr_goods_sn_manage` WHERE `goods_id` = 727 LIMIT 1 [ RunTime:0.000443s ]
SELECT `goods_id`,`goods_thumb` FROM `mrpr_goods_sn_manage` WHERE `goods_sn` = 'W231019002R' [ RunTime:0.000908s ]
SELECT COUNT(*) AS think_count FROM `mrpr_goods_sn_manage` WHERE `goods_sn` = 'W231019002R' LIMIT 1 [ RunTime:0.000783s ]
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.000414s ]
SELECT * FROM `mrpr_goods` WHERE `goods_id` = 728 LIMIT 1 [ RunTime:0.000400s ]
SELECT * FROM `mrpr_goods_sn_manage` WHERE `goods_id` = 726 LIMIT 1 [ RunTime:0.000425s ]
SELECT `goods_id`,`goods_thumb` FROM `mrpr_goods_sn_manage` WHERE `goods_sn` = 'W231019002R' [ RunTime:0.000897s ]
SELECT COUNT(*) AS think_count FROM `mrpr_goods_sn_manage` WHERE `goods_sn` = 'W231019002R' LIMIT 1 [ RunTime:0.000809s ]
SELECT * FROM `mrpr_goods` WHERE `goods_id` = 726 LIMIT 1 [ RunTime:0.000404s ]
SELECT * FROM `mrpr_goods` WHERE `goods_id` = 727 LIMIT 1 [ RunTime:0.000966s ]
SELECT * FROM `mrpr_goods` WHERE `goods_id` = 728 LIMIT 1 [ RunTime:0.000400s ]
SELECT * FROM `mrpr_goods_sn_manage` WHERE `goods_id` = 725 LIMIT 1 [ RunTime:0.000457s ]
SELECT `goods_id`,`goods_thumb` FROM `mrpr_goods_sn_manage` WHERE `goods_sn` = 'W231019001R' [ RunTime:0.000922s ]
SELECT COUNT(*) AS think_count FROM `mrpr_goods_sn_manage` WHERE `goods_sn` = 'W231019001R' LIMIT 1 [ RunTime:0.000753s ]
SELECT * FROM `mrpr_goods` WHERE `goods_id` = 722 LIMIT 1 [ RunTime:0.000410s ]
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.000402s ]
SELECT * FROM `mrpr_goods` WHERE `goods_id` = 725 LIMIT 1 [ RunTime:0.000399s ]
SELECT * FROM `mrpr_goods_sn_manage` WHERE `goods_id` = 724 LIMIT 1 [ RunTime:0.000423s ]
SELECT `goods_id`,`goods_thumb` FROM `mrpr_goods_sn_manage` WHERE `goods_sn` = 'W231019001R' [ RunTime:0.000919s ]
SELECT COUNT(*) AS think_count FROM `mrpr_goods_sn_manage` WHERE `goods_sn` = 'W231019001R' LIMIT 1 [ RunTime:0.000793s ]
SELECT * FROM `mrpr_goods` WHERE `goods_id` = 722 LIMIT 1 [ RunTime:0.000389s ]
SELECT * FROM `mrpr_goods` WHERE `goods_id` = 723 LIMIT 1 [ RunTime:0.000423s ]
SELECT * FROM `mrpr_goods` WHERE `goods_id` = 724 LIMIT 1 [ RunTime:0.000395s ]
SELECT * FROM `mrpr_goods` WHERE `goods_id` = 725 LIMIT 1 [ RunTime:0.000411s ]
SELECT * FROM `mrpr_goods_sn_manage` WHERE `goods_id` = 723 LIMIT 1 [ RunTime:0.000416s ]
SELECT `goods_id`,`goods_thumb` FROM `mrpr_goods_sn_manage` WHERE `goods_sn` = 'W231019001R' [ RunTime:0.000892s ]
SELECT COUNT(*) AS think_count FROM `mrpr_goods_sn_manage` WHERE `goods_sn` = 'W231019001R' LIMIT 1 [ RunTime:0.000780s ]
SELECT * FROM `mrpr_goods` WHERE `goods_id` = 722 LIMIT 1 [ RunTime:0.000415s ]
SELECT * FROM `mrpr_goods` WHERE `goods_id` = 723 LIMIT 1 [ RunTime:0.000390s ]
SELECT * FROM `mrpr_goods` WHERE `goods_id` = 724 LIMIT 1 [ RunTime:0.000395s ]
SELECT * FROM `mrpr_goods` WHERE `goods_id` = 725 LIMIT 1 [ RunTime:0.000399s ]
SELECT * FROM `mrpr_goods_sn_manage` WHERE `goods_id` = 722 LIMIT 1 [ RunTime:0.000412s ]
SELECT `goods_id`,`goods_thumb` FROM `mrpr_goods_sn_manage` WHERE `goods_sn` = 'W231019001R' [ RunTime:0.000890s ]
SELECT COUNT(*) AS think_count FROM `mrpr_goods_sn_manage` WHERE `goods_sn` = 'W231019001R' LIMIT 1 [ RunTime:0.000810s ]
SELECT * FROM `mrpr_goods` WHERE `goods_id` = 722 LIMIT 1 [ RunTime:0.000415s ]
SELECT * FROM `mrpr_goods` WHERE `goods_id` = 723 LIMIT 1 [ RunTime:0.000397s ]
SELECT * FROM `mrpr_goods` WHERE `goods_id` = 724 LIMIT 1 [ RunTime:0.000396s ]
SELECT * FROM `mrpr_goods` WHERE `goods_id` = 725 LIMIT 1 [ RunTime:0.000394s ]
SELECT COUNT(*) AS think_count FROM `mrpr_goods_shop_cate` `a` INNER JOIN `mrpr_goods` `b` ON `a`.`gs_id`=`b`.`id` WHERE `sale_status` = '1' AND `goods_status` = '1' AND ( `shop_cate_id` = 774 ) LIMIT 1 [ RunTime:0.000652s ]