FX23-100P-0.5SV15(01)FX20-40P-0.5SV15(20)QTH-120-01-C-D-AQTH-120-02-H-D-A-KFX2C-100S-1.27DSAL(71)FX2C-20S-1.27DSA(71)QTS-025-04-H-D-A-K-TRRX-8803LCUB PURE SN BULKIW-G27M-SCQM-4L004G-E016G-BIGIW-G28M-SM20-3D512M-E008G-BIF
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001142s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000391s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001097s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.133' ) [ RunTime:0.000239s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001069s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000222s ]
SHOW FULL COLUMNS FROM `icreplace` [ RunTime:0.000915s ]
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` WHERE ( `r`.`partno` = 'FX20-40P-0.5SV20(20)' ) [ RunTime:0.000598s ]