SHOW FULL COLUMNS FROM `mrpr_config` [ RunTime:0.001570s ]
SELECT `value` FROM `mrpr_config` [ RunTime:0.000510s ]
SHOW FULL COLUMNS FROM `mrpr_search` [ RunTime:0.001227s ]
SELECT * FROM `mrpr_search` ORDER BY `id` DESC LIMIT 10 [ RunTime:0.000416s ]
SHOW FULL COLUMNS FROM `mrpr_cart` [ RunTime:0.001129s ]
SELECT COUNT(*) AS think_count FROM `mrpr_cart` WHERE `user_id` IS NULL LIMIT 1 [ RunTime:0.000377s ]
SHOW FULL COLUMNS FROM `mrpr_ad` [ RunTime:0.001109s ]
SELECT `thumb` FROM `mrpr_ad` WHERE `type_id` = 4 [ RunTime:0.000412s ]
SELECT `thumb` FROM `mrpr_ad` WHERE `type_id` = 5 [ RunTime:0.000283s ]
SHOW FULL COLUMNS FROM `mrpr_goods` [ RunTime:0.001386s ]
SELECT `sale_start_time` FROM `mrpr_goods` WHERE `goods_status` = 1 AND `sale_status` = 1 ORDER BY `sale_start_time` ASC [ RunTime:0.000513s ]
SHOW FULL COLUMNS FROM `mrpr_shopcategory` [ RunTime:0.001117s ]
SELECT * FROM `mrpr_shopcategory` WHERE `parent_id` = 0 AND `status` = 1 ORDER BY `id` ASC LIMIT 8 [ RunTime:0.000794s ]
SELECT * FROM `mrpr_shopcategory` WHERE `parent_id` = 879 AND `thumb_show_status` = 1 ORDER BY `id` ASC LIMIT 3 [ RunTime:0.000511s ]
SELECT * FROM `mrpr_shopcategory` WHERE `parent_id` = 0 AND `thumb_show_status` = 1 ORDER BY `id` ASC LIMIT 3 [ RunTime:0.000763s ]
SELECT * FROM `mrpr_shopcategory` WHERE `parent_id` = 832 AND `thumb_show_status` = 1 ORDER BY `id` ASC LIMIT 3 [ RunTime:0.000553s ]
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.000647s ]
SELECT * FROM `mrpr_shopcategory` WHERE `parent_id` = 765 AND `thumb_show_status` = 1 ORDER BY `id` ASC LIMIT 3 [ RunTime:0.000586s ]
SELECT * FROM `mrpr_shopcategory` WHERE `parent_id` = 866 AND `thumb_show_status` = 1 ORDER BY `id` ASC LIMIT 3 [ RunTime:0.000593s ]
SELECT * FROM `mrpr_shopcategory` WHERE `parent_id` = 738 AND `thumb_show_status` = 1 ORDER BY `id` ASC LIMIT 3 [ RunTime:0.000353s ]
SELECT * FROM `mrpr_shopcategory` WHERE `parent_id` = 736 AND `thumb_show_status` = 1 ORDER BY `id` ASC LIMIT 1 [ RunTime:0.000683s ]
SELECT * FROM `mrpr_shopcategory` WHERE `parent_id` = 728 AND `thumb_show_status` = 1 ORDER BY `id` ASC LIMIT 1 [ RunTime:0.000717s ]
SHOW FULL COLUMNS FROM `mrpr_nav_manage` [ RunTime:0.001110s ]
SELECT * FROM `mrpr_nav_manage` WHERE `show_status` = 2 ORDER BY `sort` ASC [ RunTime:0.000410s ]
SELECT `id`,`parent_id`,`cate_name` FROM `mrpr_shopcategory` WHERE `status` = 1 ORDER BY `listorder` ASC [ RunTime:0.000818s ]
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.000776s ]
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.000829s ]
SHOW FULL COLUMNS FROM `mrpr_goods_sn_manage` [ RunTime:0.002100s ]
SELECT `goods_id`,`goods_thumb` FROM `mrpr_goods_sn_manage` WHERE `goods_sn` = 'W240617002R' [ RunTime:0.000998s ]
SELECT COUNT(*) AS think_count FROM `mrpr_goods_sn_manage` WHERE `goods_sn` = 'W240617002R' LIMIT 1 [ RunTime:0.000796s ]
SELECT * FROM `mrpr_goods` WHERE `goods_id` = 904 LIMIT 1 [ RunTime:0.000479s ]
SELECT `goods_id`,`goods_thumb` FROM `mrpr_goods_sn_manage` WHERE `goods_sn` = 'W240715001R' [ RunTime:0.000920s ]
SELECT COUNT(*) AS think_count FROM `mrpr_goods_sn_manage` WHERE `goods_sn` = 'W240715001R' LIMIT 1 [ RunTime:0.000794s ]
SELECT * FROM `mrpr_goods` WHERE `goods_id` = 966 LIMIT 1 [ RunTime:0.000433s ]
SELECT `goods_id`,`goods_thumb` FROM `mrpr_goods_sn_manage` WHERE `goods_sn` = 'W240721014R' [ RunTime:0.000931s ]
SELECT COUNT(*) AS think_count FROM `mrpr_goods_sn_manage` WHERE `goods_sn` = 'W240721014R' LIMIT 1 [ RunTime:0.000777s ]
SELECT * FROM `mrpr_goods` WHERE `goods_id` = 988 LIMIT 1 [ RunTime:0.000452s ]
SELECT `goods_id`,`goods_thumb` FROM `mrpr_goods_sn_manage` WHERE `goods_sn` = 'W240621001R' [ RunTime:0.000921s ]
SELECT COUNT(*) AS think_count FROM `mrpr_goods_sn_manage` WHERE `goods_sn` = 'W240621001R' LIMIT 1 [ RunTime:0.000790s ]
SELECT * FROM `mrpr_goods` WHERE `goods_id` = 936 LIMIT 1 [ RunTime:0.000430s ]
SELECT `goods_id`,`goods_thumb` FROM `mrpr_goods_sn_manage` WHERE `goods_sn` = 'W240727001R' [ RunTime:0.000887s ]
SELECT COUNT(*) AS think_count FROM `mrpr_goods_sn_manage` WHERE `goods_sn` = 'W240727001R' LIMIT 1 [ RunTime:0.000772s ]
SELECT * FROM `mrpr_goods` WHERE `goods_id` = 1031 LIMIT 1 [ RunTime:0.000478s ]
SELECT `goods_id`,`goods_thumb` FROM `mrpr_goods_sn_manage` WHERE `goods_sn` = 'W231020007R' [ RunTime:0.000914s ]
SELECT COUNT(*) AS think_count FROM `mrpr_goods_sn_manage` WHERE `goods_sn` = 'W231020007R' LIMIT 1 [ RunTime:0.000815s ]
SELECT * FROM `mrpr_goods` WHERE `goods_id` = 745 LIMIT 1 [ RunTime:0.000419s ]
SELECT * FROM `mrpr_goods` WHERE `goods_id` = 746 LIMIT 1 [ RunTime:0.000430s ]
SELECT `goods_id`,`goods_thumb` FROM `mrpr_goods_sn_manage` WHERE `goods_sn` = 'W231020007R' [ RunTime:0.000902s ]
SELECT COUNT(*) AS think_count FROM `mrpr_goods_sn_manage` WHERE `goods_sn` = 'W231020007R' LIMIT 1 [ RunTime:0.000785s ]
SELECT * FROM `mrpr_goods` WHERE `goods_id` = 745 LIMIT 1 [ RunTime:0.000429s ]
SELECT * FROM `mrpr_goods` WHERE `goods_id` = 746 LIMIT 1 [ RunTime:0.000441s ]
SELECT `goods_id`,`goods_thumb` FROM `mrpr_goods_sn_manage` WHERE `goods_sn` = 'W230812067R' [ RunTime:0.000903s ]
SELECT COUNT(*) AS think_count FROM `mrpr_goods_sn_manage` WHERE `goods_sn` = 'W230812067R' LIMIT 1 [ RunTime:0.000790s ]
SELECT * FROM `mrpr_goods` WHERE `goods_id` = 688 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.000610s ]