SHOW FULL COLUMNS FROM `mrpr_config` [ RunTime:0.002254s ]
SELECT `value` FROM `mrpr_config` [ RunTime:0.000570s ]
SHOW FULL COLUMNS FROM `mrpr_search` [ RunTime:0.001643s ]
SELECT * FROM `mrpr_search` ORDER BY `id` DESC LIMIT 10 [ RunTime:0.000519s ]
SHOW FULL COLUMNS FROM `mrpr_cart` [ RunTime:0.001553s ]
SELECT COUNT(*) AS think_count FROM `mrpr_cart` WHERE `user_id` IS NULL LIMIT 1 [ RunTime:0.000486s ]
SHOW FULL COLUMNS FROM `mrpr_ad` [ RunTime:0.001591s ]
SELECT `thumb` FROM `mrpr_ad` WHERE `type_id` = 4 [ RunTime:0.000509s ]
SELECT `thumb` FROM `mrpr_ad` WHERE `type_id` = 5 [ RunTime:0.000322s ]
SHOW FULL COLUMNS FROM `mrpr_goods` [ RunTime:0.001992s ]
SELECT `sale_start_time` FROM `mrpr_goods` WHERE `goods_status` = 1 AND `sale_status` = 1 ORDER BY `sale_start_time` ASC [ RunTime:0.000792s ]
SHOW FULL COLUMNS FROM `mrpr_shopcategory` [ RunTime:0.002317s ]
SELECT * FROM `mrpr_shopcategory` WHERE `parent_id` = 0 AND `status` = 1 ORDER BY `id` ASC LIMIT 8 [ RunTime:0.001064s ]
SELECT * FROM `mrpr_shopcategory` WHERE `parent_id` = 879 AND `thumb_show_status` = 1 ORDER BY `id` ASC LIMIT 3 [ RunTime:0.000795s ]
SELECT * FROM `mrpr_shopcategory` WHERE `parent_id` = 0 AND `thumb_show_status` = 1 ORDER BY `id` ASC LIMIT 3 [ RunTime:0.000959s ]
SELECT * FROM `mrpr_shopcategory` WHERE `parent_id` = 832 AND `thumb_show_status` = 1 ORDER BY `id` ASC LIMIT 3 [ RunTime:0.006930s ]
SELECT * FROM `mrpr_shopcategory` WHERE `parent_id` = 853 AND `thumb_show_status` = 1 ORDER BY `id` ASC LIMIT 3 [ RunTime:0.000576s ]
SELECT * FROM `mrpr_shopcategory` WHERE `parent_id` = 950 AND `thumb_show_status` = 1 ORDER BY `id` ASC LIMIT 3 [ RunTime:0.000889s ]
SELECT * FROM `mrpr_shopcategory` WHERE `parent_id` = 765 AND `thumb_show_status` = 1 ORDER BY `id` ASC LIMIT 3 [ RunTime:0.000803s ]
SELECT * FROM `mrpr_shopcategory` WHERE `parent_id` = 866 AND `thumb_show_status` = 1 ORDER BY `id` ASC LIMIT 3 [ RunTime:0.000814s ]
SELECT * FROM `mrpr_shopcategory` WHERE `parent_id` = 738 AND `thumb_show_status` = 1 ORDER BY `id` ASC LIMIT 3 [ RunTime:0.000452s ]
SELECT * FROM `mrpr_shopcategory` WHERE `parent_id` = 736 AND `thumb_show_status` = 1 ORDER BY `id` ASC LIMIT 1 [ RunTime:0.000820s ]
SELECT * FROM `mrpr_shopcategory` WHERE `parent_id` = 728 AND `thumb_show_status` = 1 ORDER BY `id` ASC LIMIT 1 [ RunTime:0.004805s ]
SHOW FULL COLUMNS FROM `mrpr_nav_manage` [ RunTime:0.001883s ]
SELECT * FROM `mrpr_nav_manage` WHERE `show_status` = 2 ORDER BY `sort` ASC [ RunTime:0.000575s ]
SELECT `id`,`parent_id`,`cate_name` FROM `mrpr_shopcategory` WHERE `status` = 1 ORDER BY `listorder` ASC [ RunTime:0.001344s ]
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.001146s ]
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.001343s ]
SHOW FULL COLUMNS FROM `mrpr_goods_sn_manage` [ RunTime:0.003349s ]
SELECT `goods_id`,`goods_thumb` FROM `mrpr_goods_sn_manage` WHERE `goods_sn` = 'W240727001R' [ RunTime:0.001663s ]
SELECT COUNT(*) AS think_count FROM `mrpr_goods_sn_manage` WHERE `goods_sn` = 'W240727001R' LIMIT 1 [ RunTime:0.001366s ]
SELECT * FROM `mrpr_goods` WHERE `goods_id` = 1031 LIMIT 1 [ RunTime:0.000631s ]
SELECT `goods_id`,`goods_thumb` FROM `mrpr_goods_sn_manage` WHERE `goods_sn` = 'W240225001R' [ RunTime:0.001506s ]
SELECT COUNT(*) AS think_count FROM `mrpr_goods_sn_manage` WHERE `goods_sn` = 'W240225001R' LIMIT 1 [ RunTime:0.001314s ]
SELECT * FROM `mrpr_goods` WHERE `goods_id` = 833 LIMIT 1 [ RunTime:0.000584s ]
SELECT `goods_id`,`goods_thumb` FROM `mrpr_goods_sn_manage` WHERE `goods_sn` = 'W231210008R' [ RunTime:0.001436s ]
SELECT COUNT(*) AS think_count FROM `mrpr_goods_sn_manage` WHERE `goods_sn` = 'W231210008R' LIMIT 1 [ RunTime:0.001266s ]
SELECT * FROM `mrpr_goods` WHERE `goods_id` = 797 LIMIT 1 [ RunTime:0.000593s ]
SELECT `goods_id`,`goods_thumb` FROM `mrpr_goods_sn_manage` WHERE `goods_sn` = 'W231210005R' [ RunTime:0.001502s ]
SELECT COUNT(*) AS think_count FROM `mrpr_goods_sn_manage` WHERE `goods_sn` = 'W231210005R' LIMIT 1 [ RunTime:0.001266s ]
SELECT * FROM `mrpr_goods` WHERE `goods_id` = 794 LIMIT 1 [ RunTime:0.000594s ]
SELECT `goods_id`,`goods_thumb` FROM `mrpr_goods_sn_manage` WHERE `goods_sn` = 'W231210001R' [ RunTime:0.001679s ]
SELECT COUNT(*) AS think_count FROM `mrpr_goods_sn_manage` WHERE `goods_sn` = 'W231210001R' LIMIT 1 [ RunTime:0.001128s ]
SELECT * FROM `mrpr_goods` WHERE `goods_id` = 790 LIMIT 1 [ RunTime:0.000597s ]
SELECT `goods_id`,`goods_thumb` FROM `mrpr_goods_sn_manage` WHERE `goods_sn` = 'W231129003R' [ RunTime:0.001488s ]
SELECT COUNT(*) AS think_count FROM `mrpr_goods_sn_manage` WHERE `goods_sn` = 'W231129003R' LIMIT 1 [ RunTime:0.001192s ]
SELECT * FROM `mrpr_goods` WHERE `goods_id` = 757 LIMIT 1 [ RunTime:0.000626s ]
SELECT `goods_id`,`goods_thumb` FROM `mrpr_goods_sn_manage` WHERE `goods_sn` = 'W231129002R' [ RunTime:0.001477s ]
SELECT COUNT(*) AS think_count FROM `mrpr_goods_sn_manage` WHERE `goods_sn` = 'W231129002R' LIMIT 1 [ RunTime:0.001324s ]
SELECT * FROM `mrpr_goods` WHERE `goods_id` = 756 LIMIT 1 [ RunTime:0.000566s ]
SELECT `goods_id`,`goods_thumb` FROM `mrpr_goods_sn_manage` WHERE `goods_sn` = 'W230812067R' [ RunTime:0.001477s ]
SELECT COUNT(*) AS think_count FROM `mrpr_goods_sn_manage` WHERE `goods_sn` = 'W230812067R' LIMIT 1 [ RunTime:0.001341s ]
SELECT * FROM `mrpr_goods` WHERE `goods_id` = 688 LIMIT 1 [ RunTime:0.000513s ]
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.000910s ]