SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002237s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000501s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002318s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.43' ) [ RunTime:0.000336s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002094s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000321s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.000268s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,800,1068,1296,1456,1822,1929,2017,2101,2342,2393,2475,2518,2568) [ RunTime:0.000511s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002563s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `partno` LIKE '760%' AND `status` <> 2 ) [ RunTime:0.000406s ]
SELECT `s`.`id`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `partno` LIKE '760%' AND `status` <> 2 ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 500,20 [ RunTime:0.017143s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002442s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 3082077 LIMIT 4 [ RunTime:0.004273s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002315s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3082077 ORDER BY `minOrder` ASC [ RunTime:0.000518s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002697s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 3082077 ORDER BY `unit` DESC [ RunTime:0.002511s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.003429s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 3082077 LIMIT 2 [ RunTime:0.003716s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3082077 ORDER BY `minOrder` ASC [ RunTime:0.001006s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 3052226 LIMIT 4 [ RunTime:0.004642s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3052226 ORDER BY `minOrder` ASC [ RunTime:0.001021s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 3052226 ORDER BY `unit` DESC [ RunTime:0.000459s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 3052226 LIMIT 2 [ RunTime:0.001440s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3052226 ORDER BY `minOrder` ASC [ RunTime:0.001473s ]
select * from pdf where partno='76054-027' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.003085s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 3045719 LIMIT 4 [ RunTime:0.001391s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3045719 ORDER BY `minOrder` ASC [ RunTime:0.000512s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 3045719 ORDER BY `unit` DESC [ RunTime:0.004434s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 3045719 LIMIT 2 [ RunTime:0.000477s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3045719 ORDER BY `minOrder` ASC [ RunTime:0.000306s ]
select * from pdf where partno='76054-034LF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.000587s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 3038255 LIMIT 4 [ RunTime:0.008435s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3038255 ORDER BY `minOrder` ASC [ RunTime:0.002979s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 3038255 ORDER BY `unit` DESC [ RunTime:0.005289s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 3038255 LIMIT 2 [ RunTime:0.002850s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3038255 ORDER BY `minOrder` ASC [ RunTime:0.000636s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 2942874 LIMIT 4 [ RunTime:0.000764s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2942874 ORDER BY `minOrder` ASC [ RunTime:0.003315s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 2942874 ORDER BY `unit` DESC [ RunTime:0.000987s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 2942874 LIMIT 2 [ RunTime:0.002862s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2942874 ORDER BY `minOrder` ASC [ RunTime:0.002409s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 2942600 LIMIT 4 [ RunTime:0.003063s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2942600 ORDER BY `minOrder` ASC [ RunTime:0.002885s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 2942600 ORDER BY `unit` DESC [ RunTime:0.002436s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 2942600 LIMIT 2 [ RunTime:0.000845s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2942600 ORDER BY `minOrder` ASC [ RunTime:0.000313s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 2942501 LIMIT 4 [ RunTime:0.000639s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2942501 ORDER BY `minOrder` ASC [ RunTime:0.000395s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 2942501 ORDER BY `unit` DESC [ RunTime:0.001009s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 2942501 LIMIT 2 [ RunTime:0.000378s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2942501 ORDER BY `minOrder` ASC [ RunTime:0.000293s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 2942476 LIMIT 4 [ RunTime:0.000581s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2942476 ORDER BY `minOrder` ASC [ RunTime:0.004564s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 2942476 ORDER BY `unit` DESC [ RunTime:0.001605s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 2942476 LIMIT 2 [ RunTime:0.006474s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2942476 ORDER BY `minOrder` ASC [ RunTime:0.004707s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 2942461 LIMIT 4 [ RunTime:0.002352s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2942461 ORDER BY `minOrder` ASC [ RunTime:0.004104s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 2942461 ORDER BY `unit` DESC [ RunTime:0.011080s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 2942461 LIMIT 2 [ RunTime:0.003340s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2942461 ORDER BY `minOrder` ASC [ RunTime:0.000558s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 2942414 LIMIT 4 [ RunTime:0.005035s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2942414 ORDER BY `minOrder` ASC [ RunTime:0.000474s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 2942414 ORDER BY `unit` DESC [ RunTime:0.000330s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 2942414 LIMIT 2 [ RunTime:0.000969s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2942414 ORDER BY `minOrder` ASC [ RunTime:0.000293s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 2942335 LIMIT 4 [ RunTime:0.001514s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2942335 ORDER BY `minOrder` ASC [ RunTime:0.001235s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 2942335 ORDER BY `unit` DESC [ RunTime:0.001193s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 2942335 LIMIT 2 [ RunTime:0.004741s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2942335 ORDER BY `minOrder` ASC [ RunTime:0.000337s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 2942334 LIMIT 4 [ RunTime:0.001390s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2942334 ORDER BY `minOrder` ASC [ RunTime:0.001584s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 2942334 ORDER BY `unit` DESC [ RunTime:0.006294s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 2942334 LIMIT 2 [ RunTime:0.000666s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2942334 ORDER BY `minOrder` ASC [ RunTime:0.002344s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 2942333 LIMIT 4 [ RunTime:0.000430s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2942333 ORDER BY `minOrder` ASC [ RunTime:0.000391s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 2942333 ORDER BY `unit` DESC [ RunTime:0.001319s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 2942333 LIMIT 2 [ RunTime:0.000996s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2942333 ORDER BY `minOrder` ASC [ RunTime:0.000294s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 2942332 LIMIT 4 [ RunTime:0.000527s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2942332 ORDER BY `minOrder` ASC [ RunTime:0.000430s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 2942332 ORDER BY `unit` DESC [ RunTime:0.000384s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 2942332 LIMIT 2 [ RunTime:0.001037s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2942332 ORDER BY `minOrder` ASC [ RunTime:0.003349s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 2942331 LIMIT 4 [ RunTime:0.002252s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2942331 ORDER BY `minOrder` ASC [ RunTime:0.003297s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 2942331 ORDER BY `unit` DESC [ RunTime:0.003270s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 2942331 LIMIT 2 [ RunTime:0.001376s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2942331 ORDER BY `minOrder` ASC [ RunTime:0.000287s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 2942299 LIMIT 4 [ RunTime:0.000598s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2942299 ORDER BY `minOrder` ASC [ RunTime:0.001085s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 2942299 ORDER BY `unit` DESC [ RunTime:0.000358s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 2942299 LIMIT 2 [ RunTime:0.000381s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2942299 ORDER BY `minOrder` ASC [ RunTime:0.000244s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 2942298 LIMIT 4 [ RunTime:0.000489s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2942298 ORDER BY `minOrder` ASC [ RunTime:0.000314s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 2942298 ORDER BY `unit` DESC [ RunTime:0.000314s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 2942298 LIMIT 2 [ RunTime:0.000879s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2942298 ORDER BY `minOrder` ASC [ RunTime:0.000344s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 2931975 LIMIT 4 [ RunTime:0.001076s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2931975 ORDER BY `minOrder` ASC [ RunTime:0.001162s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 2931975 ORDER BY `unit` DESC [ RunTime:0.000329s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 2931975 LIMIT 2 [ RunTime:0.000395s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2931975 ORDER BY `minOrder` ASC [ RunTime:0.000294s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 2900394 LIMIT 4 [ RunTime:0.000520s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2900394 ORDER BY `minOrder` ASC [ RunTime:0.000315s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 2900394 ORDER BY `unit` DESC [ RunTime:0.002328s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 2900394 LIMIT 2 [ RunTime:0.004497s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2900394 ORDER BY `minOrder` ASC [ RunTime:0.000308s ]
select * from pdf where partno='760153403' and brandshort='Molex' limit 1 [ RunTime:0.000646s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 2803157 LIMIT 4 [ RunTime:0.002059s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2803157 ORDER BY `minOrder` ASC [ RunTime:0.001501s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 2803157 ORDER BY `unit` DESC [ RunTime:0.000500s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 2803157 LIMIT 2 [ RunTime:0.000349s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2803157 ORDER BY `minOrder` ASC [ RunTime:0.000215s ]
SELECT brand, count(*) as count FROM `stock` WHERE ( `partno` LIKE '760%' AND `status` <> 2 ) AND `brand` IS NOT NULL AND `brand` <> '' GROUP BY `brand` ORDER BY `count` DESC LIMIT 10000 [ RunTime:0.000297s ]