6QDP-032-01.7-TTL-TBR-1-F6QDP-032-01.7-SBR-SBL-4-F6QDP-032-01.7-TTR-TBL-1-SRX8900SA:UB0 PURE SN6QDP-016-01.7-TTR-SBL-3-B6QDP-016-24.0-TED-TEU-2-B6QDP-048-01.7-SBR-TTR-16QDP-048-01.7-SBL-SBR-8-B6QDP-016-01.7-SBR-TBR-4-B
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002000s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.004151s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001625s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.79' ) [ RunTime:0.032353s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001837s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.050816s ]
SHOW FULL COLUMNS FROM `icreplace` [ RunTime:0.001915s ]
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` = '6QDP-032-01.7-TBL-TBR-3' ) [ RunTime:0.017676s ]