SHOW FULL COLUMNS FROM `mrpr_config` [ RunTime:0.002321s ]
SELECT `value` FROM `mrpr_config` [ RunTime:0.000588s ]
SHOW FULL COLUMNS FROM `mrpr_search` [ RunTime:0.001704s ]
SELECT * FROM `mrpr_search` ORDER BY `id` DESC LIMIT 10 [ RunTime:0.000545s ]
SHOW FULL COLUMNS FROM `mrpr_cart` [ RunTime:0.001457s ]
SELECT COUNT(*) AS think_count FROM `mrpr_cart` WHERE `user_id` IS NULL LIMIT 1 [ RunTime:0.000461s ]
SHOW FULL COLUMNS FROM `mrpr_ad` [ RunTime:0.001576s ]
SELECT `thumb` FROM `mrpr_ad` WHERE `type_id` = 4 [ RunTime:0.000542s ]
SELECT `thumb` FROM `mrpr_ad` WHERE `type_id` = 5 [ RunTime:0.000293s ]
SHOW FULL COLUMNS FROM `mrpr_goods` [ RunTime:0.001955s ]
SELECT `sale_start_time` FROM `mrpr_goods` WHERE `goods_status` = 1 AND `sale_status` = 1 ORDER BY `sale_start_time` ASC [ RunTime:0.000652s ]
SHOW FULL COLUMNS FROM `mrpr_shopcategory` [ RunTime:0.001587s ]
SELECT * FROM `mrpr_shopcategory` WHERE `parent_id` = 0 AND `status` = 1 ORDER BY `id` ASC LIMIT 8 [ RunTime:0.001085s ]
SELECT * FROM `mrpr_shopcategory` WHERE `parent_id` = 879 AND `thumb_show_status` = 1 ORDER BY `id` ASC LIMIT 3 [ RunTime:0.000703s ]
SELECT * FROM `mrpr_shopcategory` WHERE `parent_id` = 0 AND `thumb_show_status` = 1 ORDER BY `id` ASC LIMIT 3 [ RunTime:0.001054s ]
SELECT * FROM `mrpr_shopcategory` WHERE `parent_id` = 832 AND `thumb_show_status` = 1 ORDER BY `id` ASC LIMIT 3 [ RunTime:0.000713s ]
SELECT * FROM `mrpr_shopcategory` WHERE `parent_id` = 853 AND `thumb_show_status` = 1 ORDER BY `id` ASC LIMIT 3 [ RunTime:0.000586s ]
SELECT * FROM `mrpr_shopcategory` WHERE `parent_id` = 950 AND `thumb_show_status` = 1 ORDER BY `id` ASC LIMIT 3 [ RunTime:0.000881s ]
SELECT * FROM `mrpr_shopcategory` WHERE `parent_id` = 765 AND `thumb_show_status` = 1 ORDER BY `id` ASC LIMIT 3 [ RunTime:0.000755s ]
SELECT * FROM `mrpr_shopcategory` WHERE `parent_id` = 866 AND `thumb_show_status` = 1 ORDER BY `id` ASC LIMIT 3 [ RunTime:0.000788s ]
SELECT * FROM `mrpr_shopcategory` WHERE `parent_id` = 738 AND `thumb_show_status` = 1 ORDER BY `id` ASC LIMIT 3 [ RunTime:0.000436s ]
SELECT * FROM `mrpr_shopcategory` WHERE `parent_id` = 736 AND `thumb_show_status` = 1 ORDER BY `id` ASC LIMIT 1 [ RunTime:0.000827s ]
SELECT * FROM `mrpr_shopcategory` WHERE `parent_id` = 728 AND `thumb_show_status` = 1 ORDER BY `id` ASC LIMIT 1 [ RunTime:0.000956s ]
SHOW FULL COLUMNS FROM `mrpr_nav_manage` [ RunTime:0.001771s ]
SELECT * FROM `mrpr_nav_manage` WHERE `show_status` = 2 ORDER BY `sort` ASC [ RunTime:0.000530s ]
SELECT `id`,`parent_id`,`cate_name` FROM `mrpr_shopcategory` WHERE `status` = 1 ORDER BY `listorder` ASC [ RunTime:0.001220s ]
SHOW FULL COLUMNS FROM `mrpr_category` [ RunTime:0.001668s ]
SELECT * FROM `mrpr_category` WHERE ( id=912 ) LIMIT 1 [ RunTime:0.000494s ]
SELECT * FROM `mrpr_shopcategory` WHERE `id` = 912 LIMIT 1 [ RunTime:0.000389s ]
SELECT * FROM `mrpr_shopcategory` WHERE `id` = 912 LIMIT 1 [ RunTime:0.000306s ]
SELECT `id`,`cate_name` FROM `mrpr_shopcategory` WHERE `parent_id` = 832 ORDER BY `listorder` ASC [ RunTime:0.001036s ]
SHOW FULL COLUMNS FROM `mrpr_goods_shop_cate` [ RunTime:0.001522s ]
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` = 912 ) LIMIT 1 [ RunTime:0.003251s ]
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` = 912 ) ORDER BY `goods_id` DESC LIMIT 0,30 [ RunTime:0.001084s ]
SHOW FULL COLUMNS FROM `mrpr_goods_sn_manage` [ RunTime:0.003384s ]
SELECT * FROM `mrpr_goods_sn_manage` WHERE `goods_id` = 966 LIMIT 1 [ RunTime:0.000900s ]
SELECT `goods_id`,`goods_thumb` FROM `mrpr_goods_sn_manage` WHERE `goods_sn` = 'W240715001R' [ RunTime:0.001570s ]
SELECT COUNT(*) AS think_count FROM `mrpr_goods_sn_manage` WHERE `goods_sn` = 'W240715001R' LIMIT 1 [ RunTime:0.001300s ]
SELECT * FROM `mrpr_goods` WHERE `goods_id` = 966 LIMIT 1 [ RunTime:0.000641s ]
SELECT * FROM `mrpr_goods_sn_manage` WHERE `goods_id` = 952 LIMIT 1 [ RunTime:0.000592s ]
SELECT `goods_id`,`goods_thumb` FROM `mrpr_goods_sn_manage` WHERE `goods_sn` = 'W240704004R' [ RunTime:0.001531s ]
SELECT COUNT(*) AS think_count FROM `mrpr_goods_sn_manage` WHERE `goods_sn` = 'W240704004R' LIMIT 1 [ RunTime:0.001308s ]
SELECT * FROM `mrpr_goods` WHERE `goods_id` = 952 LIMIT 1 [ RunTime:0.000664s ]
SELECT * FROM `mrpr_goods_sn_manage` WHERE `goods_id` = 936 LIMIT 1 [ RunTime:0.000567s ]
SELECT `goods_id`,`goods_thumb` FROM `mrpr_goods_sn_manage` WHERE `goods_sn` = 'W240621001R' [ RunTime:0.001401s ]
SELECT COUNT(*) AS think_count FROM `mrpr_goods_sn_manage` WHERE `goods_sn` = 'W240621001R' LIMIT 1 [ RunTime:0.001511s ]
SELECT * FROM `mrpr_goods` WHERE `goods_id` = 936 LIMIT 1 [ RunTime:0.000601s ]
SELECT * FROM `mrpr_goods_sn_manage` WHERE `goods_id` = 904 LIMIT 1 [ RunTime:0.000713s ]
SELECT `goods_id`,`goods_thumb` FROM `mrpr_goods_sn_manage` WHERE `goods_sn` = 'W240617002R' [ RunTime:0.001571s ]
SELECT COUNT(*) AS think_count FROM `mrpr_goods_sn_manage` WHERE `goods_sn` = 'W240617002R' LIMIT 1 [ RunTime:0.001407s ]
SELECT * FROM `mrpr_goods` WHERE `goods_id` = 904 LIMIT 1 [ RunTime:0.000757s ]
SELECT * FROM `mrpr_goods_sn_manage` WHERE `goods_id` = 794 LIMIT 1 [ RunTime:0.000590s ]
SELECT `goods_id`,`goods_thumb` FROM `mrpr_goods_sn_manage` WHERE `goods_sn` = 'W231210005R' [ RunTime:0.001839s ]
SELECT COUNT(*) AS think_count FROM `mrpr_goods_sn_manage` WHERE `goods_sn` = 'W231210005R' LIMIT 1 [ RunTime:0.001295s ]
SELECT * FROM `mrpr_goods` WHERE `goods_id` = 794 LIMIT 1 [ RunTime:0.000608s ]
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` = 912 ) LIMIT 1 [ RunTime:0.001005s ]