SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001138s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.001878s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001514s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.121' ) [ RunTime:0.000299s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001297s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000290s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.003473s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.001086s ]
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.000458s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001805s ]
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:0.950927s ]
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 9840,20 [ RunTime:0.058611s ]
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 ('5522','2171','12982','10162','14902','13345','3941','3530','2126','1375','10492576','10539','1624','3478','6341','4906','10510161','14216','6163','5161') ORDER BY FIELD(s.id, 5522,2171,12982,10162,14902,13345,3941,3530,2126,1375,10492576,10539,1624,3478,6341,4906,10510161,14216,6163,5161) [ RunTime:0.007520s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001578s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 5522 LIMIT 4 [ RunTime:0.001428s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001012s ]
SELECT * FROM `stock_price` WHERE `stockid` = 5522 ORDER BY `minOrder` ASC [ RunTime:0.001072s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002441s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 5522 ORDER BY `unit` DESC [ RunTime:0.002002s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.000936s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 5522 LIMIT 2 [ RunTime:0.000469s ]
SELECT * FROM `stock_price` WHERE `stockid` = 5522 ORDER BY `minOrder` ASC [ RunTime:0.002074s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.000966s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ACM90V-701-2PL-TL00' OR `brand` LIKE 'TDK%' ) ) LIMIT 1 [ RunTime:0.005104s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 2171 LIMIT 4 [ RunTime:0.000372s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2171 ORDER BY `minOrder` ASC [ RunTime:0.000347s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 2171 ORDER BY `unit` DESC [ RunTime:0.004733s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 2171 LIMIT 2 [ RunTime:0.000430s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2171 ORDER BY `minOrder` ASC [ RunTime:0.001215s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '70543-0002' OR `brand` LIKE 'MOLEX%' ) ) LIMIT 1 [ RunTime:0.008153s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12982 LIMIT 4 [ RunTime:0.000476s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12982 ORDER BY `minOrder` ASC [ RunTime:0.000772s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12982 ORDER BY `unit` DESC [ RunTime:0.000383s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12982 LIMIT 2 [ RunTime:0.000340s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12982 ORDER BY `minOrder` ASC [ RunTime:0.000252s ]
select * from pdf where partno='62GB-12E08-33SN' and brandshort='AMPHENOL LTD' limit 1 [ RunTime:0.002134s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '62GB-12E08-33SN' OR `brand` LIKE 'AMPHENOL LTD%' ) ) LIMIT 1 [ RunTime:0.002323s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10162 LIMIT 4 [ RunTime:0.005602s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10162 ORDER BY `minOrder` ASC [ RunTime:0.005676s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10162 ORDER BY `unit` DESC [ RunTime:0.000967s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10162 LIMIT 2 [ RunTime:0.001434s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10162 ORDER BY `minOrder` ASC [ RunTime:0.001491s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MAX17526AATP+' OR `brand` LIKE 'ANALOG DEVICES%' ) ) LIMIT 1 [ RunTime:0.001085s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14902 LIMIT 4 [ RunTime:0.000372s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14902 ORDER BY `minOrder` ASC [ RunTime:0.001017s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14902 ORDER BY `unit` DESC [ RunTime:0.000520s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14902 LIMIT 2 [ RunTime:0.003560s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14902 ORDER BY `minOrder` ASC [ RunTime:0.000580s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'HCPL-0631-000E' OR `brand` LIKE 'BROADCOM%' ) ) LIMIT 1 [ RunTime:0.003770s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13345 LIMIT 4 [ RunTime:0.000495s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13345 ORDER BY `minOrder` ASC [ RunTime:0.000654s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13345 ORDER BY `unit` DESC [ RunTime:0.001462s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13345 LIMIT 2 [ RunTime:0.006849s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13345 ORDER BY `minOrder` ASC [ RunTime:0.004308s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '163088-2' OR `brand` LIKE 'AMP - TE CONNECTIVITY%' ) ) LIMIT 1 [ RunTime:0.003499s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 3941 LIMIT 4 [ RunTime:0.000626s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3941 ORDER BY `minOrder` ASC [ RunTime:0.002656s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 3941 ORDER BY `unit` DESC [ RunTime:0.000322s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 3941 LIMIT 2 [ RunTime:0.000299s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3941 ORDER BY `minOrder` ASC [ RunTime:0.000295s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MLV0805E32503T' OR `brand` LIKE 'VISHAY%' ) ) LIMIT 1 [ RunTime:0.000411s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 3530 LIMIT 4 [ RunTime:0.000423s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3530 ORDER BY `minOrder` ASC [ RunTime:0.000447s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 3530 ORDER BY `unit` DESC [ RunTime:0.000503s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 3530 LIMIT 2 [ RunTime:0.004051s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3530 ORDER BY `minOrder` ASC [ RunTime:0.003617s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '39-01-2026' OR `brand` LIKE 'MOLEX%' ) ) LIMIT 1 [ RunTime:0.008196s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 2126 LIMIT 4 [ RunTime:0.004868s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2126 ORDER BY `minOrder` ASC [ RunTime:0.001634s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 2126 ORDER BY `unit` DESC [ RunTime:0.001817s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 2126 LIMIT 2 [ RunTime:0.006265s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2126 ORDER BY `minOrder` ASC [ RunTime:0.000344s ]
select * from pdf where partno='06035A150JAT2A' and brandshort='KYOCERA AVX' limit 1 [ RunTime:0.001762s ]
select foldpath,foldpath2,filename from pdf_file where id=1499146 limit 1 [ RunTime:0.001622s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '06035A150JAT2A' OR `brand` LIKE 'KYOCERA AVX%' ) ) LIMIT 1 [ RunTime:0.004285s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 1375 LIMIT 4 [ RunTime:0.003209s ]
SELECT * FROM `stock_price` WHERE `stockid` = 1375 ORDER BY `minOrder` ASC [ RunTime:0.002414s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 1375 ORDER BY `unit` DESC [ RunTime:0.000615s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 1375 LIMIT 2 [ RunTime:0.000480s ]
SELECT * FROM `stock_price` WHERE `stockid` = 1375 ORDER BY `minOrder` ASC [ RunTime:0.004241s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '172158-1' OR `brand` LIKE 'AMP - TE CONNECTIVITY%' ) ) LIMIT 1 [ RunTime:0.010332s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10492576 LIMIT 4 [ RunTime:0.001591s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10492576 ORDER BY `minOrder` ASC [ RunTime:0.000352s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10492576 ORDER BY `unit` DESC [ RunTime:0.001509s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10492576 LIMIT 2 [ RunTime:0.007484s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10492576 ORDER BY `minOrder` ASC [ RunTime:0.000324s ]
select * from pdf where partno='MCASE32MAB5476KPNDT1' and brandshort='Taiyo Yuden' limit 1 [ RunTime:0.001103s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10539 LIMIT 4 [ RunTime:0.001325s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10539 ORDER BY `minOrder` ASC [ RunTime:0.000355s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10539 ORDER BY `unit` DESC [ RunTime:0.000789s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10539 LIMIT 2 [ RunTime:0.000331s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10539 ORDER BY `minOrder` ASC [ RunTime:0.000190s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'RCLAMP0524PATCT' OR `brand` LIKE 'SEMTECH%' ) ) LIMIT 1 [ RunTime:0.001152s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 1624 LIMIT 4 [ RunTime:0.000810s ]
SELECT * FROM `stock_price` WHERE `stockid` = 1624 ORDER BY `minOrder` ASC [ RunTime:0.000314s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 1624 ORDER BY `unit` DESC [ RunTime:0.008701s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 1624 LIMIT 2 [ RunTime:0.003710s ]
SELECT * FROM `stock_price` WHERE `stockid` = 1624 ORDER BY `minOrder` ASC [ RunTime:0.001854s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MCP6001T-E/OT' OR `brand` LIKE 'MICROCHIP%' ) ) LIMIT 1 [ RunTime:0.011610s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 3478 LIMIT 4 [ RunTime:0.000562s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3478 ORDER BY `minOrder` ASC [ RunTime:0.000237s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 3478 ORDER BY `unit` DESC [ RunTime:0.000253s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 3478 LIMIT 2 [ RunTime:0.000280s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3478 ORDER BY `minOrder` ASC [ RunTime:0.000207s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MCP4651-103E/ST' OR `brand` LIKE 'MICROCHIP%' ) ) LIMIT 1 [ RunTime:0.001281s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 6341 LIMIT 4 [ RunTime:0.000412s ]
SELECT * FROM `stock_price` WHERE `stockid` = 6341 ORDER BY `minOrder` ASC [ RunTime:0.000482s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 6341 ORDER BY `unit` DESC [ RunTime:0.004587s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 6341 LIMIT 2 [ RunTime:0.002358s ]
SELECT * FROM `stock_price` WHERE `stockid` = 6341 ORDER BY `minOrder` ASC [ RunTime:0.001523s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BZX84C3V6LT1G' OR `brand` LIKE 'ONSEMI%' ) ) LIMIT 1 [ RunTime:0.008754s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 4906 LIMIT 4 [ RunTime:0.001828s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4906 ORDER BY `minOrder` ASC [ RunTime:0.004235s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 4906 ORDER BY `unit` DESC [ RunTime:0.001095s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 4906 LIMIT 2 [ RunTime:0.002709s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4906 ORDER BY `minOrder` ASC [ RunTime:0.000959s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'VY2472M49Y5US63V7' OR `brand` LIKE 'VISHAY%' ) ) LIMIT 1 [ RunTime:0.013608s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10510161 LIMIT 4 [ RunTime:0.003699s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10510161 ORDER BY `minOrder` ASC [ RunTime:0.004952s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10510161 ORDER BY `unit` DESC [ RunTime:0.000392s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10510161 LIMIT 2 [ RunTime:0.006007s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10510161 ORDER BY `minOrder` ASC [ RunTime:0.017500s ]
select * from pdf where partno='C4520X7R3D102K130KE' and brandshort='TDK Corporation' limit 1 [ RunTime:0.013179s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14216 LIMIT 4 [ RunTime:0.000587s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14216 ORDER BY `minOrder` ASC [ RunTime:0.000464s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14216 ORDER BY `unit` DESC [ RunTime:0.006355s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14216 LIMIT 2 [ RunTime:0.002987s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14216 ORDER BY `minOrder` ASC [ RunTime:0.000317s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MCF 0.25W 100R' OR `brand` LIKE 'MULTICOMP PRO%' ) ) LIMIT 1 [ RunTime:0.001253s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 6163 LIMIT 4 [ RunTime:0.001290s ]
SELECT * FROM `stock_price` WHERE `stockid` = 6163 ORDER BY `minOrder` ASC [ RunTime:0.005766s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 6163 ORDER BY `unit` DESC [ RunTime:0.016855s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 6163 LIMIT 2 [ RunTime:0.001580s ]
SELECT * FROM `stock_price` WHERE `stockid` = 6163 ORDER BY `minOrder` ASC [ RunTime:0.000257s ]
select * from pdf where partno='ERJ3EKF4702V' and brandshort='PANASONIC' limit 1 [ RunTime:0.001100s ]
select foldpath,foldpath2,filename from pdf_file where id=1243802 limit 1 [ RunTime:0.000187s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ERJ3EKF4702V' OR `brand` LIKE 'PANASONIC%' ) ) LIMIT 1 [ RunTime:0.017201s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 5161 LIMIT 4 [ RunTime:0.000468s ]
SELECT * FROM `stock_price` WHERE `stockid` = 5161 ORDER BY `minOrder` ASC [ RunTime:0.000461s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 5161 ORDER BY `unit` DESC [ RunTime:0.000446s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 5161 LIMIT 2 [ RunTime:0.000453s ]
SELECT * FROM `stock_price` WHERE `stockid` = 5161 ORDER BY `minOrder` ASC [ RunTime:0.001948s ]
select * from pdf where partno='50-84-1030' and brandshort='MOLEX' limit 1 [ RunTime:0.002582s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '50-84-1030' OR `brand` LIKE 'MOLEX%' ) ) LIMIT 1 [ RunTime:0.016499s ]
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:0.573732s ]