SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001449s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.007702s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001249s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.219' ) [ RunTime:0.003591s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001279s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.001782s ]
SHOW FULL COLUMNS FROM `icreplace` [ RunTime:0.001764s ]
SELECT COUNT(*) AS think_count FROM `icreplace` `r` LEFT JOIN `stock_brand` `b1` ON `b1`.`id`=`r`.`brandid` LEFT JOIN `stock_brand` `b2` ON `b2`.`id`=`r`.`icbrandid` LEFT JOIN `stock` `s` ON `s`.`partno`=`r`.`partno` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` [ RunTime:0.008696s ]
SELECT `r`.*,`b1`.`brandshort`,`b1`.`brandcn`,b2.brandshort replaceBrandshort,b2.brandcn replaceBrandcn,`s`.`categoryid`,`s`.`note`,`s`.`imgurl`,`t`.`name` FROM `icreplace` `r` LEFT JOIN `stock_brand` `b1` ON `b1`.`id`=`r`.`brandid` LEFT JOIN `stock_brand` `b2` ON `b2`.`id`=`r`.`icbrandid` LEFT JOIN `stock` `s` ON `s`.`partno`=`r`.`partno` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` ORDER BY `r`.`id` DESC LIMIT 2160,10 [ RunTime:0.032578s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001457s ]
SELECT `id` FROM `stock` WHERE `partno` = 'CDCV304' AND `brand` = 'TI' LIMIT 1 [ RunTime:0.011318s ]
SELECT `id` FROM `stock` WHERE `partno` = 'CDCV304' LIMIT 1 [ RunTime:0.008196s ]
SELECT `id` FROM `stock` WHERE `partno` = 'RS304UE' LIMIT 1 [ RunTime:0.005906s ]
SELECT `id` FROM `stock` WHERE `partno` = 'ICS9112AM-27' AND `brand` IS NULL LIMIT 1 [ RunTime:0.005887s ]
SELECT `id` FROM `stock` WHERE `partno` = 'ICS9112AM-27' LIMIT 1 [ RunTime:0.004549s ]
SELECT `id` FROM `stock` WHERE `partno` = 'RS304WE' LIMIT 1 [ RunTime:0.002095s ]
SELECT `id` FROM `stock` WHERE `partno` = 'GM50304' AND `brand` IS NULL LIMIT 1 [ RunTime:0.035280s ]
SELECT `id` FROM `stock` WHERE `partno` = 'GM50304' LIMIT 1 [ RunTime:0.016448s ]
SELECT `id` FROM `stock` WHERE `partno` = 'RS00304ZHIE' LIMIT 1 [ RunTime:0.015253s ]
SELECT `id` FROM `stock` WHERE `partno` = 'LMK00105' AND `brand` = 'TI' LIMIT 1 [ RunTime:0.018163s ]
SELECT `id` FROM `stock` WHERE `partno` = 'LMK00105' LIMIT 1 [ RunTime:0.052734s ]
SELECT `id` FROM `stock` WHERE `partno` = 'RS2CB00105' LIMIT 1 [ RunTime:0.024145s ]
SELECT `id` FROM `stock` WHERE `partno` = 'ICS553' AND `brand` IS NULL LIMIT 1 [ RunTime:0.007012s ]
SELECT `id` FROM `stock` WHERE `partno` = 'ICS553' LIMIT 1 [ RunTime:0.005602s ]
SELECT `id` FROM `stock` WHERE `partno` = 'RS2CB553WE' LIMIT 1 [ RunTime:0.009068s ]
SELECT `id` FROM `stock` WHERE `partno` = 'ICS551' AND `brand` IS NULL LIMIT 1 [ RunTime:0.033432s ]
SELECT `id` FROM `stock` WHERE `partno` = 'ICS551' LIMIT 1 [ RunTime:0.016122s ]
SELECT `id` FROM `stock` WHERE `partno` = 'RS2CB551WE' LIMIT 1 [ RunTime:0.012730s ]
SELECT `id` FROM `stock` WHERE `partno` = 'CDCVF2310' AND `brand` = 'TI' LIMIT 1 [ RunTime:0.017634s ]
SELECT `id` FROM `stock` WHERE `partno` = 'CDCVF2310' LIMIT 1 [ RunTime:0.014028s ]
SELECT `id` FROM `stock` WHERE `partno` = 'RS2CB2310LE' LIMIT 1 [ RunTime:0.011670s ]
SELECT `id` FROM `stock` WHERE `partno` = 'CDCLVC310' AND `brand` = 'TI' LIMIT 1 [ RunTime:0.021974s ]
SELECT `id` FROM `stock` WHERE `partno` = 'CDCLVC310' LIMIT 1 [ RunTime:0.004795s ]
SELECT `id` FROM `stock` WHERE `partno` = 'RS2CB1310ZHE' LIMIT 1 [ RunTime:0.003824s ]
SELECT `id` FROM `stock` WHERE `partno` = '5PB1104' AND `brand` IS NULL LIMIT 1 [ RunTime:0.012419s ]
SELECT `id` FROM `stock` WHERE `partno` = '5PB1104' LIMIT 1 [ RunTime:0.016124s ]
SELECT `id` FROM `stock` WHERE `partno` = 'RS2CB2104ZAE' LIMIT 1 [ RunTime:0.012222s ]
SELECT `id` FROM `stock` WHERE `partno` = 'ICS8304' AND `brand` IS NULL LIMIT 1 [ RunTime:0.045784s ]
SELECT `id` FROM `stock` WHERE `partno` = 'ICS8304' LIMIT 1 [ RunTime:0.012242s ]
SELECT `id` FROM `stock` WHERE `partno` = 'RS8304TE' LIMIT 1 [ RunTime:0.033722s ]