SHOW FULL COLUMNS FROM `fwshop_setting_config` [ RunTime:0.002819s ]
SHOW FULL COLUMNS FROM `fwshop_content_menu` [ RunTime:0.002585s ]
SHOW FULL COLUMNS FROM `fwshop_setting_pic2` [ RunTime:0.002636s ]
SHOW FULL COLUMNS FROM `fwshop_setting_pic` [ RunTime:0.002105s ]
SHOW FULL COLUMNS FROM `fwshop_setting_follow` [ RunTime:0.002159s ]
SHOW FULL COLUMNS FROM `fwshop_setting_language` [ RunTime:0.002714s ]
SHOW FULL COLUMNS FROM `fwshop_content_footlink` [ RunTime:0.003099s ]
SHOW FULL COLUMNS FROM `fwshop_goods` [ RunTime:0.003865s ]
SHOW FULL COLUMNS FROM `fwshop_goods_sku` [ RunTime:0.002864s ]
SELECT * FROM `fwshop_goods_sku` WHERE `goods_id` = 1471 AND `goods_id` = 1471 ORDER BY `goods_sku_id` ASC [ RunTime:0.000511s ]
SELECT * FROM `fwshop_goods_sku` WHERE `goods_id` = 451 AND `goods_id` = 451 ORDER BY `goods_sku_id` ASC [ RunTime:0.000617s ]
SELECT * FROM `fwshop_goods_sku` WHERE `goods_id` = 1105 AND `goods_id` = 1105 ORDER BY `goods_sku_id` ASC [ RunTime:0.000597s ]
SELECT * FROM `fwshop_goods_sku` WHERE `goods_id` = 1104 AND `goods_id` = 1104 ORDER BY `goods_sku_id` ASC [ RunTime:0.000517s ]
SELECT * FROM `fwshop_goods_sku` WHERE `goods_id` = 408 AND `goods_id` = 408 ORDER BY `goods_sku_id` ASC [ RunTime:0.000427s ]
SELECT * FROM `fwshop_goods_sku` WHERE `goods_id` = 1103 AND `goods_id` = 1103 ORDER BY `goods_sku_id` ASC [ RunTime:0.000431s ]
SELECT * FROM `fwshop_goods_sku` WHERE `goods_id` = 1102 AND `goods_id` = 1102 ORDER BY `goods_sku_id` ASC [ RunTime:0.000527s ]
SELECT * FROM `fwshop_goods_sku` WHERE `goods_id` = 402 AND `goods_id` = 402 ORDER BY `goods_sku_id` ASC [ RunTime:0.000534s ]
SELECT * FROM `fwshop_goods_sku` WHERE `goods_id` = 394 AND `goods_id` = 394 ORDER BY `goods_sku_id` ASC [ RunTime:0.000600s ]
SELECT * FROM `fwshop_goods_sku` WHERE `goods_id` = 423 AND `goods_id` = 423 ORDER BY `goods_sku_id` ASC [ RunTime:0.001284s ]
SHOW FULL COLUMNS FROM `fwshop_setting_oauth` [ RunTime:0.003112s ]
SHOW FULL COLUMNS FROM `fwshop_setting_seo` [ RunTime:0.002315s ]
SHOW FULL COLUMNS FROM `fwshop_category` [ RunTime:0.003044s ]
SHOW FULL COLUMNS FROM `fwshop_brand` [ RunTime:0.002153s ]
SELECT * FROM `fwshop_category` WHERE `parent_id` = 0 AND `status` = 1 ORDER BY `sort` ASC,`category_id` ASC [ RunTime:0.000646s ]
SELECT COUNT(*) AS think_count FROM `fwshop_goods` WHERE `is_delete` = 0 AND `goods_status` = 10 AND `goods_name` LIKE 'P%' AND (`category_id` LIKE '%,264,%' OR `category_id` LIKE '%,265,%' OR `category_id` LIKE '%,268,%' OR `category_id` LIKE '%,269,%' OR `category_id` LIKE '%,270,%' OR `category_id` LIKE '%,266,%' OR `category_id` LIKE '%,271,%' OR `category_id` LIKE '%,272,%' OR `category_id` LIKE '%,273,%' OR `category_id` LIKE '%,274,%' OR `category_id` LIKE '%,275,%' OR `category_id` LIKE '%,267,%' OR `category_id` LIKE '%,152,%' OR `category_id` LIKE '%,191,%' OR `category_id` LIKE '%,276,%' OR `category_id` LIKE '%,277,%') LIMIT 1 [ RunTime:0.001664s ]
SELECT COUNT(*) AS think_count FROM `fwshop_goods` WHERE `is_delete` = 0 AND `goods_status` = 10 AND `goods_name` LIKE 'P%' AND (`category_id` LIKE '%,257,%' OR `category_id` LIKE '%,14,%' OR `category_id` LIKE '%,24,%' OR `category_id` LIKE '%,16,%' OR `category_id` LIKE '%,27,%' OR `category_id` LIKE '%,11,%' OR `category_id` LIKE '%,12,%' OR `category_id` LIKE '%,20,%' OR `category_id` LIKE '%,25,%' OR `category_id` LIKE '%,26,%' OR `category_id` LIKE '%,34,%' OR `category_id` LIKE '%,30,%' OR `category_id` LIKE '%,22,%' OR `category_id` LIKE '%,29,%' OR `category_id` LIKE '%,28,%' OR `category_id` LIKE '%,23,%' OR `category_id` LIKE '%,98,%' OR `category_id` LIKE '%,99,%' OR `category_id` LIKE '%,239,%' OR `category_id` LIKE '%,258,%' OR `category_id` LIKE '%,55,%' OR `category_id` LIKE '%,86,%' OR `category_id` LIKE '%,79,%' OR `category_id` LIKE '%,89,%' OR `category_id` LIKE '%,63,%' OR `category_id` LIKE '%,64,%' OR `category_id` LIKE '%,65,%' OR `category_id` LIKE '%,66,%' OR `category_id` LIKE '%,71,%' OR `category_id` LIKE '%,253,%' OR `category_id` LIKE '%,254,%' OR `category_id` LIKE '%,255,%' OR `category_id` LIKE '%,126,%' OR `category_id` LIKE '%,59,%' OR `category_id` LIKE '%,127,%' OR `category_id` LIKE '%,134,%' OR `category_id` LIKE '%,106,%' OR `category_id` LIKE '%,111,%' OR `category_id` LIKE '%,109,%' OR `category_id` LIKE '%,110,%' OR `category_id` LIKE '%,113,%' OR `category_id` LIKE '%,217,%' OR `category_id` LIKE '%,219,%' OR `category_id` LIKE '%,220,%' OR `category_id` LIKE '%,218,%' OR `category_id` LIKE '%,104,%' OR `category_id` LIKE '%,108,%' OR `category_id` LIKE '%,107,%') LIMIT 1 [ RunTime:0.002007s ]
SELECT COUNT(*) AS think_count FROM `fwshop_goods` WHERE `is_delete` = 0 AND `goods_status` = 10 AND `goods_name` LIKE 'P%' AND (`category_id` LIKE '%,102,%') LIMIT 1 [ RunTime:0.001702s ]
SELECT COUNT(*) AS think_count FROM `fwshop_goods` WHERE `is_delete` = 0 AND `goods_status` = 10 AND `goods_name` LIKE 'P%' AND (`category_id` LIKE '%,5,%' OR `category_id` LIKE '%,163,%' OR `category_id` LIKE '%,164,%' OR `category_id` LIKE '%,165,%' OR `category_id` LIKE '%,166,%' OR `category_id` LIKE '%,172,%' OR `category_id` LIKE '%,175,%' OR `category_id` LIKE '%,173,%' OR `category_id` LIKE '%,174,%') LIMIT 1 [ RunTime:0.001642s ]
SELECT COUNT(*) AS think_count FROM `fwshop_goods` WHERE `is_delete` = 0 AND `goods_status` = 10 AND `goods_name` LIKE 'P%' AND (`category_id` LIKE '%,6,%' OR `category_id` LIKE '%,183,%' OR `category_id` LIKE '%,184,%' OR `category_id` LIKE '%,186,%' OR `category_id` LIKE '%,185,%' OR `category_id` LIKE '%,187,%') LIMIT 1 [ RunTime:0.001824s ]
SELECT COUNT(*) AS think_count FROM `fwshop_goods` WHERE `is_delete` = 0 AND `goods_status` = 10 AND `goods_name` LIKE 'P%' AND (`category_id` LIKE '%,7,%' OR `category_id` LIKE '%,43,%' OR `category_id` LIKE '%,44,%' OR `category_id` LIKE '%,243,%' OR `category_id` LIKE '%,45,%' OR `category_id` LIKE '%,46,%' OR `category_id` LIKE '%,49,%' OR `category_id` LIKE '%,47,%' OR `category_id` LIKE '%,48,%') LIMIT 1 [ RunTime:0.001503s ]
SELECT COUNT(*) AS think_count FROM `fwshop_goods` WHERE `is_delete` = 0 AND `goods_status` = 10 AND `goods_name` LIKE 'P%' AND (`category_id` LIKE '%,8,%' OR `category_id` LIKE '%,192,%' OR `category_id` LIKE '%,193,%' OR `category_id` LIKE '%,203,%' OR `category_id` LIKE '%,194,%' OR `category_id` LIKE '%,195,%' OR `category_id` LIKE '%,196,%' OR `category_id` LIKE '%,197,%' OR `category_id` LIKE '%,198,%' OR `category_id` LIKE '%,201,%' OR `category_id` LIKE '%,202,%') LIMIT 1 [ RunTime:0.002556s ]
SELECT COUNT(*) AS think_count FROM `fwshop_goods` WHERE `is_delete` = 0 AND `goods_status` = 10 AND `goods_name` LIKE 'P%' AND (`category_id` LIKE '%,9,%' OR `category_id` LIKE '%,205,%' OR `category_id` LIKE '%,209,%' OR `category_id` LIKE '%,206,%' OR `category_id` LIKE '%,208,%' OR `category_id` LIKE '%,214,%' OR `category_id` LIKE '%,215,%' OR `category_id` LIKE '%,252,%') LIMIT 1 [ RunTime:0.001614s ]
SELECT COUNT(*) AS think_count FROM `fwshop_goods` WHERE `is_delete` = 0 AND `goods_status` = 10 AND `goods_name` LIKE 'P%' AND (`category_id` LIKE '%,10,%' OR `category_id` LIKE '%,136,%' OR `category_id` LIKE '%,142,%' OR `category_id` LIKE '%,137,%' OR `category_id` LIKE '%,138,%' OR `category_id` LIKE '%,147,%' OR `category_id` LIKE '%,149,%' OR `category_id` LIKE '%,148,%' OR `category_id` LIKE '%,150,%' OR `category_id` LIKE '%,250,%' OR `category_id` LIKE '%,151,%' OR `category_id` LIKE '%,251,%' OR `category_id` LIKE '%,153,%' OR `category_id` LIKE '%,154,%' OR `category_id` LIKE '%,155,%' OR `category_id` LIKE '%,156,%' OR `category_id` LIKE '%,157,%' OR `category_id` LIKE '%,158,%' OR `category_id` LIKE '%,159,%' OR `category_id` LIKE '%,160,%') LIMIT 1 [ RunTime:0.001894s ]
SELECT COUNT(*) AS think_count FROM `fwshop_goods` WHERE `is_delete` = 0 AND `goods_status` = 10 AND `goods_name` LIKE 'P%' AND (`category_id` LIKE '%,259,%' OR `category_id` LIKE '%,260,%' OR `category_id` LIKE '%,261,%' OR `category_id` LIKE '%,262,%' OR `category_id` LIKE '%,263,%') LIMIT 1 [ RunTime:0.001696s ]
SELECT DISTINCT `brand_id` FROM `fwshop_goods` WHERE `is_delete` = 0 AND `goods_status` = 10 AND `goods_name` LIKE 'P%' [ RunTime:0.001450s ]
SHOW FULL COLUMNS FROM `fwshop_goods_attr` [ RunTime:0.002715s ]
SELECT * FROM `fwshop_goods_attr` WHERE 0 = 1 AND `status` = 1 ORDER BY `sort` ASC,`attr_id` ASC [ RunTime:0.000361s ]
SELECT DISTINCT MIN(`goods_price`) AS think_min FROM `fwshop_goods` WHERE `is_delete` = 0 AND `goods_status` = 10 AND `goods_name` LIKE 'P%' LIMIT 1 [ RunTime:0.001667s ]
SELECT DISTINCT MAX(`goods_price`) AS think_max FROM `fwshop_goods` WHERE `is_delete` = 0 AND `goods_status` = 10 AND `goods_name` LIKE 'P%' LIMIT 1 [ RunTime:0.001291s ]
SELECT COUNT(*) AS think_count FROM `fwshop_goods` WHERE `is_delete` = 0 AND `goods_status` = 10 AND `goods_name` LIKE 'P%' AND `discount` BETWEEN 0.001 AND 24.999 LIMIT 1 [ RunTime:0.001148s ]
SELECT COUNT(*) AS think_count FROM `fwshop_goods` WHERE `is_delete` = 0 AND `goods_status` = 10 AND `goods_name` LIKE 'P%' AND `discount` BETWEEN 25 AND 50 LIMIT 1 [ RunTime:0.001159s ]
SELECT COUNT(*) AS think_count FROM `fwshop_goods` WHERE `is_delete` = 0 AND `goods_status` = 10 AND `goods_name` LIKE 'P%' AND `discount` BETWEEN 50.001 AND 75 LIMIT 1 [ RunTime:0.001117s ]
SELECT COUNT(*) AS think_count FROM `fwshop_goods` WHERE `is_delete` = 0 AND `goods_status` = 10 AND `goods_name` LIKE 'P%' AND `discount` BETWEEN 75.001 AND 99.99 LIMIT 1 [ RunTime:0.001602s ]
SELECT COUNT(*) AS think_count FROM `fwshop_goods` WHERE `is_delete` = 0 AND `goods_status` = 10 AND `goods_name` LIKE 'P%' LIMIT 1 [ RunTime:0.001409s ]