SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002422s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000577s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002537s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.166' ) [ RunTime:0.000370s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002242s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.002096s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000572s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.000317s ]
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.000564s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.003210s ]
SELECT `s`.`id` FROM `stock` `s` INNER JOIN `user` `u` ON `s`.`userid`=`u`.`stockuserid` WHERE `u`.`lockUser` = '0' AND ( (s.isDisplay IS NULL OR s.isDisplay = 1) ) AND ( `partno` LIKE '228%' AND `status` <> 2 ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 1860,20 [ RunTime:0.100772s ]
SELECT `s`.`id`,`s`.`userid`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` INNER JOIN `user` `u` ON `s`.`userid`=`u`.`stockuserid` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE `u`.`lockUser` = '0' AND ( (s.isDisplay IS NULL OR s.isDisplay = 1) ) AND `s`.`id` IN ('3900092','3725598','3717893','3716826','3715709','3712804','3712287','3712187','3711223','3709041','3708466','3707548','3707506','3705072','3703213','3700228','3698450','3695659','3695397','3695326') ORDER BY FIELD(s.id, 3900092,3725598,3717893,3716826,3715709,3712804,3712287,3712187,3711223,3709041,3708466,3707548,3707506,3705072,3703213,3700228,3698450,3695659,3695397,3695326) [ RunTime:0.003853s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002678s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 3900092 LIMIT 4 [ RunTime:0.003997s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002355s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3900092 ORDER BY `minOrder` ASC [ RunTime:0.001177s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002072s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 3900092 ORDER BY `unit` DESC [ RunTime:0.002571s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.000941s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 3900092 LIMIT 2 [ RunTime:0.004225s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3900092 ORDER BY `minOrder` ASC [ RunTime:0.000304s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 3725598 LIMIT 4 [ RunTime:0.002853s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3725598 ORDER BY `minOrder` ASC [ RunTime:0.002134s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 3725598 ORDER BY `unit` DESC [ RunTime:0.001888s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 3725598 LIMIT 2 [ RunTime:0.000346s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3725598 ORDER BY `minOrder` ASC [ RunTime:0.000245s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 3717893 LIMIT 4 [ RunTime:0.000572s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3717893 ORDER BY `minOrder` ASC [ RunTime:0.001447s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 3717893 ORDER BY `unit` DESC [ RunTime:0.009851s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 3717893 LIMIT 2 [ RunTime:0.002407s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3717893 ORDER BY `minOrder` ASC [ RunTime:0.000244s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 3716826 LIMIT 4 [ RunTime:0.000593s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3716826 ORDER BY `minOrder` ASC [ RunTime:0.000395s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 3716826 ORDER BY `unit` DESC [ RunTime:0.000472s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 3716826 LIMIT 2 [ RunTime:0.001184s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3716826 ORDER BY `minOrder` ASC [ RunTime:0.000941s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 3715709 LIMIT 4 [ RunTime:0.000828s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3715709 ORDER BY `minOrder` ASC [ RunTime:0.000492s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 3715709 ORDER BY `unit` DESC [ RunTime:0.003662s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 3715709 LIMIT 2 [ RunTime:0.000333s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3715709 ORDER BY `minOrder` ASC [ RunTime:0.000253s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 3712804 LIMIT 4 [ RunTime:0.000486s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3712804 ORDER BY `minOrder` ASC [ RunTime:0.000437s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 3712804 ORDER BY `unit` DESC [ RunTime:0.000772s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 3712804 LIMIT 2 [ RunTime:0.001201s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3712804 ORDER BY `minOrder` ASC [ RunTime:0.000252s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 3712287 LIMIT 4 [ RunTime:0.008079s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3712287 ORDER BY `minOrder` ASC [ RunTime:0.000359s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 3712287 ORDER BY `unit` DESC [ RunTime:0.000344s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 3712287 LIMIT 2 [ RunTime:0.000300s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3712287 ORDER BY `minOrder` ASC [ RunTime:0.000225s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 3712187 LIMIT 4 [ RunTime:0.000436s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3712187 ORDER BY `minOrder` ASC [ RunTime:0.002619s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 3712187 ORDER BY `unit` DESC [ RunTime:0.000803s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 3712187 LIMIT 2 [ RunTime:0.003043s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3712187 ORDER BY `minOrder` ASC [ RunTime:0.000233s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 3711223 LIMIT 4 [ RunTime:0.000478s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3711223 ORDER BY `minOrder` ASC [ RunTime:0.000309s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 3711223 ORDER BY `unit` DESC [ RunTime:0.003740s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 3711223 LIMIT 2 [ RunTime:0.004631s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3711223 ORDER BY `minOrder` ASC [ RunTime:0.000299s ]
select * from pdf where partno='2286685-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.004880s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 3709041 LIMIT 4 [ RunTime:0.000863s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3709041 ORDER BY `minOrder` ASC [ RunTime:0.000413s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 3709041 ORDER BY `unit` DESC [ RunTime:0.000340s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 3709041 LIMIT 2 [ RunTime:0.000338s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3709041 ORDER BY `minOrder` ASC [ RunTime:0.001186s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 3708466 LIMIT 4 [ RunTime:0.000449s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3708466 ORDER BY `minOrder` ASC [ RunTime:0.000303s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 3708466 ORDER BY `unit` DESC [ RunTime:0.000294s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 3708466 LIMIT 2 [ RunTime:0.000797s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3708466 ORDER BY `minOrder` ASC [ RunTime:0.001682s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 3707548 LIMIT 4 [ RunTime:0.002335s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3707548 ORDER BY `minOrder` ASC [ RunTime:0.000635s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 3707548 ORDER BY `unit` DESC [ RunTime:0.002794s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 3707548 LIMIT 2 [ RunTime:0.002186s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3707548 ORDER BY `minOrder` ASC [ RunTime:0.000277s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 3707506 LIMIT 4 [ RunTime:0.000553s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3707506 ORDER BY `minOrder` ASC [ RunTime:0.000312s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 3707506 ORDER BY `unit` DESC [ RunTime:0.005599s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 3707506 LIMIT 2 [ RunTime:0.001701s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3707506 ORDER BY `minOrder` ASC [ RunTime:0.001463s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 3705072 LIMIT 4 [ RunTime:0.002436s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3705072 ORDER BY `minOrder` ASC [ RunTime:0.007955s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 3705072 ORDER BY `unit` DESC [ RunTime:0.002092s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 3705072 LIMIT 2 [ RunTime:0.000385s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3705072 ORDER BY `minOrder` ASC [ RunTime:0.000224s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 3703213 LIMIT 4 [ RunTime:0.000705s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3703213 ORDER BY `minOrder` ASC [ RunTime:0.001921s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 3703213 ORDER BY `unit` DESC [ RunTime:0.001319s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 3703213 LIMIT 2 [ RunTime:0.001129s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3703213 ORDER BY `minOrder` ASC [ RunTime:0.000257s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 3700228 LIMIT 4 [ RunTime:0.006678s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3700228 ORDER BY `minOrder` ASC [ RunTime:0.001413s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 3700228 ORDER BY `unit` DESC [ RunTime:0.003782s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 3700228 LIMIT 2 [ RunTime:0.003451s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3700228 ORDER BY `minOrder` ASC [ RunTime:0.000235s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 3698450 LIMIT 4 [ RunTime:0.000562s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3698450 ORDER BY `minOrder` ASC [ RunTime:0.000383s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 3698450 ORDER BY `unit` DESC [ RunTime:0.006740s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 3698450 LIMIT 2 [ RunTime:0.008988s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3698450 ORDER BY `minOrder` ASC [ RunTime:0.000397s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 3695659 LIMIT 4 [ RunTime:0.006408s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3695659 ORDER BY `minOrder` ASC [ RunTime:0.004384s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 3695659 ORDER BY `unit` DESC [ RunTime:0.001270s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 3695659 LIMIT 2 [ RunTime:0.000483s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3695659 ORDER BY `minOrder` ASC [ RunTime:0.000386s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 3695397 LIMIT 4 [ RunTime:0.002462s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3695397 ORDER BY `minOrder` ASC [ RunTime:0.000783s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 3695397 ORDER BY `unit` DESC [ RunTime:0.000830s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 3695397 LIMIT 2 [ RunTime:0.001913s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3695397 ORDER BY `minOrder` ASC [ RunTime:0.000329s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 3695326 LIMIT 4 [ RunTime:0.000660s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3695326 ORDER BY `minOrder` ASC [ RunTime:0.000685s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 3695326 ORDER BY `unit` DESC [ RunTime:0.000459s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 3695326 LIMIT 2 [ RunTime:0.000446s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3695326 ORDER BY `minOrder` ASC [ RunTime:0.000326s ]
SELECT brand, count(*) as count FROM `stock` WHERE ( `partno` LIKE '228%' AND `status` <> 2 ) AND `brand` IS NOT NULL AND `brand` <> '' GROUP BY `brand` ORDER BY `count` DESC LIMIT 10000 [ RunTime:0.035418s ]