SHOW FULL COLUMNS FROM `mrpr_config` [ RunTime:0.002376s ]
SELECT `value` FROM `mrpr_config` [ RunTime:0.000418s ]
SHOW FULL COLUMNS FROM `mrpr_search` [ RunTime:0.001705s ]
SELECT * FROM `mrpr_search` ORDER BY `id` DESC LIMIT 10 [ RunTime:0.000340s ]
SHOW FULL COLUMNS FROM `mrpr_cart` [ RunTime:0.001550s ]
SELECT COUNT(*) AS think_count FROM `mrpr_cart` WHERE `user_id` IS NULL LIMIT 1 [ RunTime:0.000281s ]
SHOW FULL COLUMNS FROM `mrpr_ad` [ RunTime:0.001577s ]
SELECT `thumb` FROM `mrpr_ad` WHERE `type_id` = 4 [ RunTime:0.000400s ]
SELECT `thumb` FROM `mrpr_ad` WHERE `type_id` = 5 [ RunTime:0.000312s ]
SHOW FULL COLUMNS FROM `mrpr_goods` [ RunTime:0.001928s ]
SELECT `sale_start_time` FROM `mrpr_goods` WHERE `goods_status` = 1 AND `sale_status` = 1 ORDER BY `sale_start_time` ASC [ RunTime:0.000534s ]
SHOW FULL COLUMNS FROM `mrpr_shopcategory` [ RunTime:0.001453s ]
SELECT * FROM `mrpr_shopcategory` WHERE `parent_id` = 0 AND `status` = 1 ORDER BY `id` ASC LIMIT 8 [ RunTime:0.000929s ]
SELECT * FROM `mrpr_shopcategory` WHERE `parent_id` = 879 AND `thumb_show_status` = 1 ORDER BY `id` ASC LIMIT 3 [ RunTime:0.000697s ]
SELECT * FROM `mrpr_shopcategory` WHERE `parent_id` = 0 AND `thumb_show_status` = 1 ORDER BY `id` ASC LIMIT 3 [ RunTime:0.001079s ]
SELECT * FROM `mrpr_shopcategory` WHERE `parent_id` = 832 AND `thumb_show_status` = 1 ORDER BY `id` ASC LIMIT 3 [ RunTime:0.000666s ]
SELECT * FROM `mrpr_shopcategory` WHERE `parent_id` = 853 AND `thumb_show_status` = 1 ORDER BY `id` ASC LIMIT 3 [ RunTime:0.000673s ]
SELECT * FROM `mrpr_shopcategory` WHERE `parent_id` = 950 AND `thumb_show_status` = 1 ORDER BY `id` ASC LIMIT 3 [ RunTime:0.000902s ]
SELECT * FROM `mrpr_shopcategory` WHERE `parent_id` = 765 AND `thumb_show_status` = 1 ORDER BY `id` ASC LIMIT 3 [ RunTime:0.000785s ]
SELECT * FROM `mrpr_shopcategory` WHERE `parent_id` = 866 AND `thumb_show_status` = 1 ORDER BY `id` ASC LIMIT 3 [ RunTime:0.000832s ]
SELECT * FROM `mrpr_shopcategory` WHERE `parent_id` = 738 AND `thumb_show_status` = 1 ORDER BY `id` ASC LIMIT 3 [ RunTime:0.000486s ]
SELECT * FROM `mrpr_shopcategory` WHERE `parent_id` = 736 AND `thumb_show_status` = 1 ORDER BY `id` ASC LIMIT 1 [ RunTime:0.000918s ]
SELECT * FROM `mrpr_shopcategory` WHERE `parent_id` = 728 AND `thumb_show_status` = 1 ORDER BY `id` ASC LIMIT 1 [ RunTime:0.001005s ]
SHOW FULL COLUMNS FROM `mrpr_nav_manage` [ RunTime:0.001589s ]
SELECT * FROM `mrpr_nav_manage` WHERE `show_status` = 2 ORDER BY `sort` ASC [ RunTime:0.000413s ]
SELECT `id`,`parent_id`,`cate_name` FROM `mrpr_shopcategory` WHERE `status` = 1 ORDER BY `listorder` ASC [ RunTime:0.001193s ]
SHOW FULL COLUMNS FROM `mrpr_category` [ RunTime:0.001632s ]
SELECT * FROM `mrpr_category` WHERE ( id=774 ) LIMIT 1 [ RunTime:0.000559s ]
SELECT * FROM `mrpr_shopcategory` WHERE `id` = 774 LIMIT 1 [ RunTime:0.000394s ]
SELECT * FROM `mrpr_shopcategory` WHERE `id` = 774 LIMIT 1 [ RunTime:0.000341s ]
SELECT `id`,`cate_name` FROM `mrpr_shopcategory` WHERE `parent_id` = 765 ORDER BY `listorder` ASC [ RunTime:0.001010s ]
SHOW FULL COLUMNS FROM `mrpr_goods_shop_cate` [ RunTime:0.001515s ]
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.001113s ]
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.001239s ]
SHOW FULL COLUMNS FROM `mrpr_goods_sn_manage` [ RunTime:0.002988s ]
SELECT * FROM `mrpr_goods_sn_manage` WHERE `goods_id` = 731 LIMIT 1 [ RunTime:0.000682s ]
SELECT `goods_id`,`goods_thumb` FROM `mrpr_goods_sn_manage` WHERE `goods_sn` = 'W231019003R' [ RunTime:0.001634s ]
SELECT COUNT(*) AS think_count FROM `mrpr_goods_sn_manage` WHERE `goods_sn` = 'W231019003R' LIMIT 1 [ RunTime:0.001369s ]
SELECT * FROM `mrpr_goods` WHERE `goods_id` = 729 LIMIT 1 [ RunTime:0.000513s ]
SELECT * FROM `mrpr_goods` WHERE `goods_id` = 730 LIMIT 1 [ RunTime:0.000516s ]
SELECT * FROM `mrpr_goods` WHERE `goods_id` = 731 LIMIT 1 [ RunTime:0.000514s ]
SELECT * FROM `mrpr_goods_sn_manage` WHERE `goods_id` = 730 LIMIT 1 [ RunTime:0.000545s ]
SELECT `goods_id`,`goods_thumb` FROM `mrpr_goods_sn_manage` WHERE `goods_sn` = 'W231019003R' [ RunTime:0.001450s ]
SELECT COUNT(*) AS think_count FROM `mrpr_goods_sn_manage` WHERE `goods_sn` = 'W231019003R' LIMIT 1 [ RunTime:0.001396s ]
SELECT * FROM `mrpr_goods` WHERE `goods_id` = 729 LIMIT 1 [ RunTime:0.000624s ]
SELECT * FROM `mrpr_goods` WHERE `goods_id` = 730 LIMIT 1 [ RunTime:0.000517s ]
SELECT * FROM `mrpr_goods` WHERE `goods_id` = 731 LIMIT 1 [ RunTime:0.000540s ]
SELECT * FROM `mrpr_goods_sn_manage` WHERE `goods_id` = 729 LIMIT 1 [ RunTime:0.000600s ]
SELECT `goods_id`,`goods_thumb` FROM `mrpr_goods_sn_manage` WHERE `goods_sn` = 'W231019003R' [ RunTime:0.001518s ]
SELECT COUNT(*) AS think_count FROM `mrpr_goods_sn_manage` WHERE `goods_sn` = 'W231019003R' LIMIT 1 [ RunTime:0.001333s ]
SELECT * FROM `mrpr_goods` WHERE `goods_id` = 729 LIMIT 1 [ RunTime:0.000506s ]
SELECT * FROM `mrpr_goods` WHERE `goods_id` = 730 LIMIT 1 [ RunTime:0.000512s ]
SELECT * FROM `mrpr_goods` WHERE `goods_id` = 731 LIMIT 1 [ RunTime:0.000533s ]
SELECT * FROM `mrpr_goods_sn_manage` WHERE `goods_id` = 728 LIMIT 1 [ RunTime:0.000532s ]
SELECT `goods_id`,`goods_thumb` FROM `mrpr_goods_sn_manage` WHERE `goods_sn` = 'W231019002R' [ RunTime:0.001483s ]
SELECT COUNT(*) AS think_count FROM `mrpr_goods_sn_manage` WHERE `goods_sn` = 'W231019002R' LIMIT 1 [ RunTime:0.001268s ]
SELECT * FROM `mrpr_goods` WHERE `goods_id` = 726 LIMIT 1 [ RunTime:0.000491s ]
SELECT * FROM `mrpr_goods` WHERE `goods_id` = 727 LIMIT 1 [ RunTime:0.000534s ]
SELECT * FROM `mrpr_goods` WHERE `goods_id` = 728 LIMIT 1 [ RunTime:0.000516s ]
SELECT * FROM `mrpr_goods_sn_manage` WHERE `goods_id` = 727 LIMIT 1 [ RunTime:0.000524s ]
SELECT `goods_id`,`goods_thumb` FROM `mrpr_goods_sn_manage` WHERE `goods_sn` = 'W231019002R' [ RunTime:0.001510s ]
SELECT COUNT(*) AS think_count FROM `mrpr_goods_sn_manage` WHERE `goods_sn` = 'W231019002R' LIMIT 1 [ RunTime:0.001254s ]
SELECT * FROM `mrpr_goods` WHERE `goods_id` = 726 LIMIT 1 [ RunTime:0.000532s ]
SELECT * FROM `mrpr_goods` WHERE `goods_id` = 727 LIMIT 1 [ RunTime:0.000537s ]
SELECT * FROM `mrpr_goods` WHERE `goods_id` = 728 LIMIT 1 [ RunTime:0.000438s ]
SELECT * FROM `mrpr_goods_sn_manage` WHERE `goods_id` = 726 LIMIT 1 [ RunTime:0.000510s ]
SELECT `goods_id`,`goods_thumb` FROM `mrpr_goods_sn_manage` WHERE `goods_sn` = 'W231019002R' [ RunTime:0.001336s ]
SELECT COUNT(*) AS think_count FROM `mrpr_goods_sn_manage` WHERE `goods_sn` = 'W231019002R' LIMIT 1 [ RunTime:0.001317s ]
SELECT * FROM `mrpr_goods` WHERE `goods_id` = 726 LIMIT 1 [ RunTime:0.000493s ]
SELECT * FROM `mrpr_goods` WHERE `goods_id` = 727 LIMIT 1 [ RunTime:0.000474s ]
SELECT * FROM `mrpr_goods` WHERE `goods_id` = 728 LIMIT 1 [ RunTime:0.000990s ]
SELECT * FROM `mrpr_goods_sn_manage` WHERE `goods_id` = 725 LIMIT 1 [ RunTime:0.000610s ]
SELECT `goods_id`,`goods_thumb` FROM `mrpr_goods_sn_manage` WHERE `goods_sn` = 'W231019001R' [ RunTime:0.001533s ]
SELECT COUNT(*) AS think_count FROM `mrpr_goods_sn_manage` WHERE `goods_sn` = 'W231019001R' LIMIT 1 [ RunTime:0.001318s ]
SELECT * FROM `mrpr_goods` WHERE `goods_id` = 722 LIMIT 1 [ RunTime:0.000547s ]
SELECT * FROM `mrpr_goods` WHERE `goods_id` = 723 LIMIT 1 [ RunTime:0.000541s ]
SELECT * FROM `mrpr_goods` WHERE `goods_id` = 724 LIMIT 1 [ RunTime:0.000489s ]
SELECT * FROM `mrpr_goods` WHERE `goods_id` = 725 LIMIT 1 [ RunTime:0.000535s ]
SELECT * FROM `mrpr_goods_sn_manage` WHERE `goods_id` = 724 LIMIT 1 [ RunTime:0.000574s ]
SELECT `goods_id`,`goods_thumb` FROM `mrpr_goods_sn_manage` WHERE `goods_sn` = 'W231019001R' [ RunTime:0.001511s ]
SELECT COUNT(*) AS think_count FROM `mrpr_goods_sn_manage` WHERE `goods_sn` = 'W231019001R' LIMIT 1 [ RunTime:0.001329s ]
SELECT * FROM `mrpr_goods` WHERE `goods_id` = 722 LIMIT 1 [ RunTime:0.000461s ]
SELECT * FROM `mrpr_goods` WHERE `goods_id` = 723 LIMIT 1 [ RunTime:0.000502s ]
SELECT * FROM `mrpr_goods` WHERE `goods_id` = 724 LIMIT 1 [ RunTime:0.000507s ]
SELECT * FROM `mrpr_goods` WHERE `goods_id` = 725 LIMIT 1 [ RunTime:0.000508s ]
SELECT * FROM `mrpr_goods_sn_manage` WHERE `goods_id` = 723 LIMIT 1 [ RunTime:0.000590s ]
SELECT `goods_id`,`goods_thumb` FROM `mrpr_goods_sn_manage` WHERE `goods_sn` = 'W231019001R' [ RunTime:0.001555s ]
SELECT COUNT(*) AS think_count FROM `mrpr_goods_sn_manage` WHERE `goods_sn` = 'W231019001R' LIMIT 1 [ RunTime:0.001259s ]
SELECT * FROM `mrpr_goods` WHERE `goods_id` = 722 LIMIT 1 [ RunTime:0.000629s ]
SELECT * FROM `mrpr_goods` WHERE `goods_id` = 723 LIMIT 1 [ RunTime:0.000840s ]
SELECT * FROM `mrpr_goods` WHERE `goods_id` = 724 LIMIT 1 [ RunTime:0.000495s ]
SELECT * FROM `mrpr_goods` WHERE `goods_id` = 725 LIMIT 1 [ RunTime:0.000412s ]
SELECT * FROM `mrpr_goods_sn_manage` WHERE `goods_id` = 722 LIMIT 1 [ RunTime:0.000522s ]
SELECT `goods_id`,`goods_thumb` FROM `mrpr_goods_sn_manage` WHERE `goods_sn` = 'W231019001R' [ RunTime:0.001219s ]
SELECT COUNT(*) AS think_count FROM `mrpr_goods_sn_manage` WHERE `goods_sn` = 'W231019001R' LIMIT 1 [ RunTime:0.001364s ]
SELECT * FROM `mrpr_goods` WHERE `goods_id` = 722 LIMIT 1 [ RunTime:0.000521s ]
SELECT * FROM `mrpr_goods` WHERE `goods_id` = 723 LIMIT 1 [ RunTime:0.000467s ]
SELECT * FROM `mrpr_goods` WHERE `goods_id` = 724 LIMIT 1 [ RunTime:0.000533s ]
SELECT * FROM `mrpr_goods` WHERE `goods_id` = 725 LIMIT 1 [ RunTime:0.000520s ]
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.000945s ]