SHOW FULL COLUMNS FROM `mrpr_config` [ RunTime:0.002271s ]
SELECT `value` FROM `mrpr_config` [ RunTime:0.000412s ]
SHOW FULL COLUMNS FROM `mrpr_search` [ RunTime:0.002029s ]
SELECT * FROM `mrpr_search` ORDER BY `id` DESC LIMIT 10 [ RunTime:0.000376s ]
SHOW FULL COLUMNS FROM `mrpr_cart` [ RunTime:0.001610s ]
SELECT COUNT(*) AS think_count FROM `mrpr_cart` WHERE `user_id` IS NULL LIMIT 1 [ RunTime:0.000306s ]
SHOW FULL COLUMNS FROM `mrpr_ad` [ RunTime:0.001637s ]
SELECT `thumb` FROM `mrpr_ad` WHERE `type_id` = 4 [ RunTime:0.000398s ]
SELECT `thumb` FROM `mrpr_ad` WHERE `type_id` = 5 [ RunTime:0.000306s ]
SHOW FULL COLUMNS FROM `mrpr_goods` [ RunTime:0.001966s ]
SELECT `sale_start_time` FROM `mrpr_goods` WHERE `goods_status` = 1 AND `sale_status` = 1 ORDER BY `sale_start_time` ASC [ RunTime:0.000498s ]
SHOW FULL COLUMNS FROM `mrpr_shopcategory` [ RunTime:0.001665s ]
SELECT * FROM `mrpr_shopcategory` WHERE `parent_id` = 0 AND `status` = 1 ORDER BY `id` ASC LIMIT 8 [ RunTime:0.001234s ]
SELECT * FROM `mrpr_shopcategory` WHERE `parent_id` = 879 AND `thumb_show_status` = 1 ORDER BY `id` ASC LIMIT 3 [ RunTime:0.000686s ]
SELECT * FROM `mrpr_shopcategory` WHERE `parent_id` = 0 AND `thumb_show_status` = 1 ORDER BY `id` ASC LIMIT 3 [ RunTime:0.001104s ]
SELECT * FROM `mrpr_shopcategory` WHERE `parent_id` = 832 AND `thumb_show_status` = 1 ORDER BY `id` ASC LIMIT 3 [ RunTime:0.000718s ]
SELECT * FROM `mrpr_shopcategory` WHERE `parent_id` = 853 AND `thumb_show_status` = 1 ORDER BY `id` ASC LIMIT 3 [ RunTime:0.000565s ]
SELECT * FROM `mrpr_shopcategory` WHERE `parent_id` = 950 AND `thumb_show_status` = 1 ORDER BY `id` ASC LIMIT 3 [ RunTime:0.000893s ]
SELECT * FROM `mrpr_shopcategory` WHERE `parent_id` = 765 AND `thumb_show_status` = 1 ORDER BY `id` ASC LIMIT 3 [ RunTime:0.010964s ]
SELECT * FROM `mrpr_shopcategory` WHERE `parent_id` = 866 AND `thumb_show_status` = 1 ORDER BY `id` ASC LIMIT 3 [ RunTime:0.000749s ]
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.000880s ]
SELECT * FROM `mrpr_shopcategory` WHERE `parent_id` = 728 AND `thumb_show_status` = 1 ORDER BY `id` ASC LIMIT 1 [ RunTime:0.000936s ]
SHOW FULL COLUMNS FROM `mrpr_nav_manage` [ RunTime:0.001631s ]
SELECT * FROM `mrpr_nav_manage` WHERE `show_status` = 2 ORDER BY `sort` ASC [ RunTime:0.000403s ]
SELECT `id`,`parent_id`,`cate_name` FROM `mrpr_shopcategory` WHERE `status` = 1 ORDER BY `listorder` ASC [ RunTime:0.001117s ]
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.000931s ]
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.001237s ]
SHOW FULL COLUMNS FROM `mrpr_goods_sn_manage` [ RunTime:0.003503s ]
SELECT `goods_id`,`goods_thumb` FROM `mrpr_goods_sn_manage` WHERE `goods_sn` = 'W231020010R' [ RunTime:0.001561s ]
SELECT COUNT(*) AS think_count FROM `mrpr_goods_sn_manage` WHERE `goods_sn` = 'W231020010R' LIMIT 1 [ RunTime:0.001267s ]
SELECT * FROM `mrpr_goods` WHERE `goods_id` = 750 LIMIT 1 [ RunTime:0.000610s ]
SELECT `goods_id`,`goods_thumb` FROM `mrpr_goods_sn_manage` WHERE `goods_sn` = 'W231020008R' [ RunTime:0.001523s ]
SELECT COUNT(*) AS think_count FROM `mrpr_goods_sn_manage` WHERE `goods_sn` = 'W231020008R' LIMIT 1 [ RunTime:0.001292s ]
SELECT * FROM `mrpr_goods` WHERE `goods_id` = 747 LIMIT 1 [ RunTime:0.000607s ]
SELECT `goods_id`,`goods_thumb` FROM `mrpr_goods_sn_manage` WHERE `goods_sn` = 'W231020002R' [ RunTime:0.001804s ]
SELECT COUNT(*) AS think_count FROM `mrpr_goods_sn_manage` WHERE `goods_sn` = 'W231020002R' LIMIT 1 [ RunTime:0.001178s ]
SELECT * FROM `mrpr_goods` WHERE `goods_id` = 735 LIMIT 1 [ RunTime:0.000481s ]
SELECT * FROM `mrpr_goods` WHERE `goods_id` = 736 LIMIT 1 [ RunTime:0.000507s ]
SELECT `goods_id`,`goods_thumb` FROM `mrpr_goods_sn_manage` WHERE `goods_sn` = 'W231020002R' [ RunTime:0.001438s ]
SELECT COUNT(*) AS think_count FROM `mrpr_goods_sn_manage` WHERE `goods_sn` = 'W231020002R' LIMIT 1 [ RunTime:0.001272s ]
SELECT * FROM `mrpr_goods` WHERE `goods_id` = 735 LIMIT 1 [ RunTime:0.000499s ]
SELECT * FROM `mrpr_goods` WHERE `goods_id` = 736 LIMIT 1 [ RunTime:0.000566s ]
SELECT `goods_id`,`goods_thumb` FROM `mrpr_goods_sn_manage` WHERE `goods_sn` = 'W231019002R' [ RunTime:0.001491s ]
SELECT COUNT(*) AS think_count FROM `mrpr_goods_sn_manage` WHERE `goods_sn` = 'W231019002R' LIMIT 1 [ RunTime:0.001226s ]
SELECT * FROM `mrpr_goods` WHERE `goods_id` = 726 LIMIT 1 [ RunTime:0.000442s ]
SELECT * FROM `mrpr_goods` WHERE `goods_id` = 727 LIMIT 1 [ RunTime:0.000512s ]
SELECT * FROM `mrpr_goods` WHERE `goods_id` = 728 LIMIT 1 [ RunTime:0.000487s ]
SELECT `goods_id`,`goods_thumb` FROM `mrpr_goods_sn_manage` WHERE `goods_sn` = 'W231019002R' [ RunTime:0.001506s ]
SELECT COUNT(*) AS think_count FROM `mrpr_goods_sn_manage` WHERE `goods_sn` = 'W231019002R' LIMIT 1 [ RunTime:0.001269s ]
SELECT * FROM `mrpr_goods` WHERE `goods_id` = 726 LIMIT 1 [ RunTime:0.000466s ]
SELECT * FROM `mrpr_goods` WHERE `goods_id` = 727 LIMIT 1 [ RunTime:0.000545s ]
SELECT * FROM `mrpr_goods` WHERE `goods_id` = 728 LIMIT 1 [ RunTime:0.000486s ]
SELECT `goods_id`,`goods_thumb` FROM `mrpr_goods_sn_manage` WHERE `goods_sn` = 'W231019002R' [ RunTime:0.001532s ]
SELECT COUNT(*) AS think_count FROM `mrpr_goods_sn_manage` WHERE `goods_sn` = 'W231019002R' LIMIT 1 [ RunTime:0.001582s ]
SELECT * FROM `mrpr_goods` WHERE `goods_id` = 726 LIMIT 1 [ RunTime:0.000522s ]
SELECT * FROM `mrpr_goods` WHERE `goods_id` = 727 LIMIT 1 [ RunTime:0.000518s ]
SELECT * FROM `mrpr_goods` WHERE `goods_id` = 728 LIMIT 1 [ RunTime:0.000779s ]
SELECT `goods_id`,`goods_thumb` FROM `mrpr_goods_sn_manage` WHERE `goods_sn` = 'W231019001R' [ RunTime:0.001548s ]
SELECT COUNT(*) AS think_count FROM `mrpr_goods_sn_manage` WHERE `goods_sn` = 'W231019001R' LIMIT 1 [ RunTime:0.001275s ]
SELECT * FROM `mrpr_goods` WHERE `goods_id` = 722 LIMIT 1 [ RunTime:0.010788s ]
SELECT * FROM `mrpr_goods` WHERE `goods_id` = 723 LIMIT 1 [ RunTime:0.000562s ]
SELECT * FROM `mrpr_goods` WHERE `goods_id` = 724 LIMIT 1 [ RunTime:0.000569s ]
SELECT * FROM `mrpr_goods` WHERE `goods_id` = 725 LIMIT 1 [ RunTime:0.000538s ]
SELECT `goods_id`,`goods_thumb` FROM `mrpr_goods_sn_manage` WHERE `goods_sn` = 'W231019001R' [ RunTime:0.001650s ]
SELECT COUNT(*) AS think_count FROM `mrpr_goods_sn_manage` WHERE `goods_sn` = 'W231019001R' LIMIT 1 [ RunTime:0.001444s ]
SELECT * FROM `mrpr_goods` WHERE `goods_id` = 722 LIMIT 1 [ RunTime:0.000503s ]
SELECT * FROM `mrpr_goods` WHERE `goods_id` = 723 LIMIT 1 [ RunTime:0.000515s ]
SELECT * FROM `mrpr_goods` WHERE `goods_id` = 724 LIMIT 1 [ RunTime:0.000515s ]
SELECT * FROM `mrpr_goods` WHERE `goods_id` = 725 LIMIT 1 [ RunTime:0.000516s ]
SELECT `goods_id`,`goods_thumb` FROM `mrpr_goods_sn_manage` WHERE `goods_sn` = 'W231019001R' [ RunTime:0.001643s ]
SELECT COUNT(*) AS think_count FROM `mrpr_goods_sn_manage` WHERE `goods_sn` = 'W231019001R' LIMIT 1 [ RunTime:0.001405s ]
SELECT * FROM `mrpr_goods` WHERE `goods_id` = 722 LIMIT 1 [ RunTime:0.000499s ]
SELECT * FROM `mrpr_goods` WHERE `goods_id` = 723 LIMIT 1 [ RunTime:0.000513s ]
SELECT * FROM `mrpr_goods` WHERE `goods_id` = 724 LIMIT 1 [ RunTime:0.002979s ]
SELECT * FROM `mrpr_goods` WHERE `goods_id` = 725 LIMIT 1 [ RunTime:0.000495s ]
SELECT `goods_id`,`goods_thumb` FROM `mrpr_goods_sn_manage` WHERE `goods_sn` = 'W231019001R' [ RunTime:0.001446s ]
SELECT COUNT(*) AS think_count FROM `mrpr_goods_sn_manage` WHERE `goods_sn` = 'W231019001R' LIMIT 1 [ RunTime:0.001277s ]
SELECT * FROM `mrpr_goods` WHERE `goods_id` = 722 LIMIT 1 [ RunTime:0.000530s ]
SELECT * FROM `mrpr_goods` WHERE `goods_id` = 723 LIMIT 1 [ RunTime:0.002636s ]
SELECT * FROM `mrpr_goods` WHERE `goods_id` = 724 LIMIT 1 [ RunTime:0.000502s ]
SELECT * FROM `mrpr_goods` WHERE `goods_id` = 725 LIMIT 1 [ RunTime:0.000474s ]
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.000843s ]