SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002429s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000602s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002635s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.121' ) [ RunTime:0.000344s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002148s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.004604s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.001830s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.001210s ]
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.000557s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002405s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` INNER JOIN `user` `u` ON `s`.`userid`=`u`.`stockuserid` WHERE ( `status` <> 2 ) AND `u`.`lockUser` = '0' [ RunTime:1.007670s ]
SELECT `s`.`id` FROM `stock` `s` INNER JOIN `user` `u` ON `s`.`userid`=`u`.`stockuserid` WHERE `u`.`lockUser` = '0' AND ( (s.isDisplay = 1) ) AND ( `status` <> 2 ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 1040,20 [ RunTime:0.017651s ]
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 = 1) ) AND `s`.`id` IN ('10447034','10447033','10447032','10447031','10447030','10447029','10447028','10447027','10447026','10447025','10447024','10447023','10447022','10447021','10447020','10447019','10447018','10447017','10522','10453549') ORDER BY FIELD(s.id, 10447034,10447033,10447032,10447031,10447030,10447029,10447028,10447027,10447026,10447025,10447024,10447023,10447022,10447021,10447020,10447019,10447018,10447017,10522,10453549) [ RunTime:0.008629s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001265s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10447034 LIMIT 4 [ RunTime:0.003516s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001060s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10447034 ORDER BY `minOrder` ASC [ RunTime:0.003029s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.006029s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10447034 ORDER BY `unit` DESC [ RunTime:0.000490s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.000960s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10447034 LIMIT 2 [ RunTime:0.004947s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10447034 ORDER BY `minOrder` ASC [ RunTime:0.000599s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10447033 LIMIT 4 [ RunTime:0.000873s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10447033 ORDER BY `minOrder` ASC [ RunTime:0.000554s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10447033 ORDER BY `unit` DESC [ RunTime:0.001220s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10447033 LIMIT 2 [ RunTime:0.005919s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10447033 ORDER BY `minOrder` ASC [ RunTime:0.005647s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10447032 LIMIT 4 [ RunTime:0.000648s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10447032 ORDER BY `minOrder` ASC [ RunTime:0.004636s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10447032 ORDER BY `unit` DESC [ RunTime:0.000560s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10447032 LIMIT 2 [ RunTime:0.002453s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10447032 ORDER BY `minOrder` ASC [ RunTime:0.000310s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10447031 LIMIT 4 [ RunTime:0.000550s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10447031 ORDER BY `minOrder` ASC [ RunTime:0.000540s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10447031 ORDER BY `unit` DESC [ RunTime:0.005477s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10447031 LIMIT 2 [ RunTime:0.004200s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10447031 ORDER BY `minOrder` ASC [ RunTime:0.000762s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10447030 LIMIT 4 [ RunTime:0.001942s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10447030 ORDER BY `minOrder` ASC [ RunTime:0.003654s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10447030 ORDER BY `unit` DESC [ RunTime:0.000657s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10447030 LIMIT 2 [ RunTime:0.008315s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10447030 ORDER BY `minOrder` ASC [ RunTime:0.002355s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10447029 LIMIT 4 [ RunTime:0.009784s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10447029 ORDER BY `minOrder` ASC [ RunTime:0.003028s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10447029 ORDER BY `unit` DESC [ RunTime:0.002327s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10447029 LIMIT 2 [ RunTime:0.007464s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10447029 ORDER BY `minOrder` ASC [ RunTime:0.000313s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10447028 LIMIT 4 [ RunTime:0.002212s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10447028 ORDER BY `minOrder` ASC [ RunTime:0.000599s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10447028 ORDER BY `unit` DESC [ RunTime:0.000581s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10447028 LIMIT 2 [ RunTime:0.001846s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10447028 ORDER BY `minOrder` ASC [ RunTime:0.002384s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10447027 LIMIT 4 [ RunTime:0.008452s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10447027 ORDER BY `minOrder` ASC [ RunTime:0.002438s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10447027 ORDER BY `unit` DESC [ RunTime:0.001720s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10447027 LIMIT 2 [ RunTime:0.007477s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10447027 ORDER BY `minOrder` ASC [ RunTime:0.003166s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10447026 LIMIT 4 [ RunTime:0.000737s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10447026 ORDER BY `minOrder` ASC [ RunTime:0.001941s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10447026 ORDER BY `unit` DESC [ RunTime:0.001420s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10447026 LIMIT 2 [ RunTime:0.005623s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10447026 ORDER BY `minOrder` ASC [ RunTime:0.007221s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10447025 LIMIT 4 [ RunTime:0.004055s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10447025 ORDER BY `minOrder` ASC [ RunTime:0.001685s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10447025 ORDER BY `unit` DESC [ RunTime:0.000724s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10447025 LIMIT 2 [ RunTime:0.000560s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10447025 ORDER BY `minOrder` ASC [ RunTime:0.001551s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10447024 LIMIT 4 [ RunTime:0.001506s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10447024 ORDER BY `minOrder` ASC [ RunTime:0.001728s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10447024 ORDER BY `unit` DESC [ RunTime:0.001891s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10447024 LIMIT 2 [ RunTime:0.002073s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10447024 ORDER BY `minOrder` ASC [ RunTime:0.000363s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10447023 LIMIT 4 [ RunTime:0.009518s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10447023 ORDER BY `minOrder` ASC [ RunTime:0.001466s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10447023 ORDER BY `unit` DESC [ RunTime:0.005038s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10447023 LIMIT 2 [ RunTime:0.000696s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10447023 ORDER BY `minOrder` ASC [ RunTime:0.001182s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10447022 LIMIT 4 [ RunTime:0.001310s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10447022 ORDER BY `minOrder` ASC [ RunTime:0.002818s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10447022 ORDER BY `unit` DESC [ RunTime:0.007330s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10447022 LIMIT 2 [ RunTime:0.000644s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10447022 ORDER BY `minOrder` ASC [ RunTime:0.000360s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10447021 LIMIT 4 [ RunTime:0.000580s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10447021 ORDER BY `minOrder` ASC [ RunTime:0.001606s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10447021 ORDER BY `unit` DESC [ RunTime:0.000432s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10447021 LIMIT 2 [ RunTime:0.000403s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10447021 ORDER BY `minOrder` ASC [ RunTime:0.000291s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10447020 LIMIT 4 [ RunTime:0.000534s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10447020 ORDER BY `minOrder` ASC [ RunTime:0.000516s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10447020 ORDER BY `unit` DESC [ RunTime:0.005574s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10447020 LIMIT 2 [ RunTime:0.000579s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10447020 ORDER BY `minOrder` ASC [ RunTime:0.000337s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10447019 LIMIT 4 [ RunTime:0.000498s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10447019 ORDER BY `minOrder` ASC [ RunTime:0.001059s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10447019 ORDER BY `unit` DESC [ RunTime:0.004676s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10447019 LIMIT 2 [ RunTime:0.008644s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10447019 ORDER BY `minOrder` ASC [ RunTime:0.000591s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10447018 LIMIT 4 [ RunTime:0.001272s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10447018 ORDER BY `minOrder` ASC [ RunTime:0.000537s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10447018 ORDER BY `unit` DESC [ RunTime:0.001330s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10447018 LIMIT 2 [ RunTime:0.002129s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10447018 ORDER BY `minOrder` ASC [ RunTime:0.000365s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10447017 LIMIT 4 [ RunTime:0.001611s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10447017 ORDER BY `minOrder` ASC [ RunTime:0.002165s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10447017 ORDER BY `unit` DESC [ RunTime:0.002286s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10447017 LIMIT 2 [ RunTime:0.003221s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10447017 ORDER BY `minOrder` ASC [ RunTime:0.000359s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10522 LIMIT 4 [ RunTime:0.000496s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10522 ORDER BY `minOrder` ASC [ RunTime:0.000783s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10522 ORDER BY `unit` DESC [ RunTime:0.000993s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10522 LIMIT 2 [ RunTime:0.011086s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10522 ORDER BY `minOrder` ASC [ RunTime:0.003083s ]
select * from pdf where partno='CC0805KRX7R9BB104' and brandshort='YAGEO' limit 1 [ RunTime:0.013675s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002507s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CC0805KRX7R9BB104' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.007826s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10453549 LIMIT 4 [ RunTime:0.003536s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10453549 ORDER BY `minOrder` ASC [ RunTime:0.002676s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10453549 ORDER BY `unit` DESC [ RunTime:0.016148s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10453549 LIMIT 2 [ RunTime:0.002711s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10453549 ORDER BY `minOrder` ASC [ RunTime:0.003654s ]
SELECT brand, count(*) as count FROM `stock` WHERE ( `status` <> 2 ) AND `brand` IS NOT NULL AND `brand` <> '' GROUP BY `brand` ORDER BY `count` DESC LIMIT 10000 [ RunTime:1.228070s ]