SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002235s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.002067s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002275s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.113' ) [ RunTime:0.009564s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002240s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.011781s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.016526s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.009571s ]
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.004233s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.003259s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` INNER JOIN `user` `u` ON `s`.`userid`=`u`.`stockuserid` WHERE ( `status` = 4 AND `status` <> 2 ) AND `u`.`lockUser` = '0' [ RunTime:0.002392s ]
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` = 4 AND `status` <> 2 ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 240,20 [ RunTime:0.042983s ]
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 ('16014','16013','16012','16011','16010','16009','16008','16007','16006','16005','16004','16003','16002','16001','16000','15999','15998','15997','15996','15995') ORDER BY FIELD(s.id, 16014,16013,16012,16011,16010,16009,16008,16007,16006,16005,16004,16003,16002,16001,16000,15999,15998,15997,15996,15995) [ RunTime:0.017739s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002101s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16014 LIMIT 4 [ RunTime:0.019620s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.011185s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16014 ORDER BY `minOrder` ASC [ RunTime:0.021802s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.011971s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16014 ORDER BY `unit` DESC [ RunTime:0.026559s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.024904s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16014 LIMIT 2 [ RunTime:0.014314s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16014 ORDER BY `minOrder` ASC [ RunTime:0.003543s ]
select * from pdf where partno='MAX9259GCB/V+' and brandshort='ANALOG DEVICES' limit 1 [ RunTime:0.038134s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.004463s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MAX9259GCB/V+' OR `brand` LIKE 'ANALOG DEVICES%' ) ) LIMIT 1 [ RunTime:0.013604s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16013 LIMIT 4 [ RunTime:0.027471s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16013 ORDER BY `minOrder` ASC [ RunTime:0.034596s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16013 ORDER BY `unit` DESC [ RunTime:0.016417s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16013 LIMIT 2 [ RunTime:0.019255s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16013 ORDER BY `minOrder` ASC [ RunTime:0.013006s ]
select * from pdf where partno='L-130WDT/1EGW' and brandshort='KINGBRIGHT' limit 1 [ RunTime:0.014118s ]
select foldpath,foldpath2,filename from pdf_file where id=1387246 limit 1 [ RunTime:0.013442s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'L-130WDT/1EGW' OR `brand` LIKE 'KINGBRIGHT%' ) ) LIMIT 1 [ RunTime:0.018656s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16012 LIMIT 4 [ RunTime:0.008447s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16012 ORDER BY `minOrder` ASC [ RunTime:0.019924s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16012 ORDER BY `unit` DESC [ RunTime:0.018634s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16012 LIMIT 2 [ RunTime:0.009601s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16012 ORDER BY `minOrder` ASC [ RunTime:0.006749s ]
select * from pdf where partno='MDS-S-TS' and brandshort='ITT CANNON' limit 1 [ RunTime:0.043379s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MDS-S-TS' OR `brand` LIKE 'ITT CANNON%' ) ) LIMIT 1 [ RunTime:0.025250s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16011 LIMIT 4 [ RunTime:0.049668s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16011 ORDER BY `minOrder` ASC [ RunTime:0.031786s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16011 ORDER BY `unit` DESC [ RunTime:0.025196s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16011 LIMIT 2 [ RunTime:0.027746s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16011 ORDER BY `minOrder` ASC [ RunTime:0.033306s ]
select * from pdf where partno='BAS16P2T5G' and brandshort='ONSEMI' limit 1 [ RunTime:0.023039s ]
select foldpath,foldpath2,filename from pdf_file where id=2047199 limit 1 [ RunTime:0.026603s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BAS16P2T5G' OR `brand` LIKE 'ONSEMI%' ) ) LIMIT 1 [ RunTime:0.035845s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16010 LIMIT 4 [ RunTime:0.007231s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16010 ORDER BY `minOrder` ASC [ RunTime:0.046000s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16010 ORDER BY `unit` DESC [ RunTime:0.020637s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16010 LIMIT 2 [ RunTime:0.045841s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16010 ORDER BY `minOrder` ASC [ RunTime:0.011416s ]
select * from pdf where partno='WKO102MCPCJ0KR' and brandshort='VISHAY' limit 1 [ RunTime:0.048813s ]
select foldpath,foldpath2,filename from pdf_file where id=1498251 limit 1 [ RunTime:0.062445s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'WKO102MCPCJ0KR' OR `brand` LIKE 'VISHAY%' ) ) LIMIT 1 [ RunTime:0.028726s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16009 LIMIT 4 [ RunTime:0.064201s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16009 ORDER BY `minOrder` ASC [ RunTime:0.036146s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16009 ORDER BY `unit` DESC [ RunTime:0.072861s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16009 LIMIT 2 [ RunTime:0.030395s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16009 ORDER BY `minOrder` ASC [ RunTime:0.041791s ]
select * from pdf where partno='MCWR08X2003FTL' and brandshort='MULTICOMP PRO' limit 1 [ RunTime:0.038542s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MCWR08X2003FTL' OR `brand` LIKE 'MULTICOMP PRO%' ) ) LIMIT 1 [ RunTime:0.008280s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16008 LIMIT 4 [ RunTime:0.044038s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16008 ORDER BY `minOrder` ASC [ RunTime:0.026185s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16008 ORDER BY `unit` DESC [ RunTime:0.054170s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16008 LIMIT 2 [ RunTime:0.030040s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16008 ORDER BY `minOrder` ASC [ RunTime:0.011713s ]
select * from pdf where partno='STM32F071RBT6TR' and brandshort='STMICROELECTRONICS' limit 1 [ RunTime:0.055971s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'STM32F071RBT6TR' OR `brand` LIKE 'STMICROELECTRONICS%' ) ) LIMIT 1 [ RunTime:0.021156s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16007 LIMIT 4 [ RunTime:0.043595s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16007 ORDER BY `minOrder` ASC [ RunTime:0.041950s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16007 ORDER BY `unit` DESC [ RunTime:0.032085s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16007 LIMIT 2 [ RunTime:0.041478s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16007 ORDER BY `minOrder` ASC [ RunTime:0.006746s ]
select * from pdf where partno='MT46H64M16LFBF-5 IT:B' and brandshort='MICRON' limit 1 [ RunTime:0.029274s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MT46H64M16LFBF-5 IT:B' OR `brand` LIKE 'MICRON%' ) ) LIMIT 1 [ RunTime:0.036208s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16006 LIMIT 4 [ RunTime:0.036187s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16006 ORDER BY `minOrder` ASC [ RunTime:0.062919s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16006 ORDER BY `unit` DESC [ RunTime:0.014428s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16006 LIMIT 2 [ RunTime:0.024202s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16006 ORDER BY `minOrder` ASC [ RunTime:0.009678s ]
select * from pdf where partno='DF11-16DP-2DSA(08)' and brandshort='HIROSEHRS' limit 1 [ RunTime:0.016332s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'DF11-16DP-2DSA(08)' OR `brand` LIKE 'HIROSE(HRS)%' ) ) LIMIT 1 [ RunTime:0.031677s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16005 LIMIT 4 [ RunTime:0.026038s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16005 ORDER BY `minOrder` ASC [ RunTime:0.050762s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16005 ORDER BY `unit` DESC [ RunTime:0.043106s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16005 LIMIT 2 [ RunTime:0.039334s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16005 ORDER BY `minOrder` ASC [ RunTime:0.006074s ]
select * from pdf where partno='17501 10 B1' and brandshort='VOLEX' limit 1 [ RunTime:0.010184s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '17501 10 B1' OR `brand` LIKE 'VOLEX%' ) ) LIMIT 1 [ RunTime:0.049950s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16004 LIMIT 4 [ RunTime:0.032685s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16004 ORDER BY `minOrder` ASC [ RunTime:0.021823s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16004 ORDER BY `unit` DESC [ RunTime:0.009768s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16004 LIMIT 2 [ RunTime:0.021787s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16004 ORDER BY `minOrder` ASC [ RunTime:0.012164s ]
select * from pdf where partno='ERJP03J5R1V' and brandshort='PANASONIC' limit 1 [ RunTime:0.019054s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ERJP03J5R1V' OR `brand` LIKE 'PANASONIC%' ) ) LIMIT 1 [ RunTime:0.045464s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16003 LIMIT 4 [ RunTime:0.022701s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16003 ORDER BY `minOrder` ASC [ RunTime:0.014248s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16003 ORDER BY `unit` DESC [ RunTime:0.000748s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16003 LIMIT 2 [ RunTime:0.044224s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16003 ORDER BY `minOrder` ASC [ RunTime:0.019526s ]
select * from pdf where partno='FDBB-25S1AENT2/1-LF' and brandshort='CINCH CONNECTIVITY SOLUTIONS' limit 1 [ RunTime:0.015657s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FDBB-25S1AENT2/1-LF' OR `brand` LIKE 'CINCH CONNECTIVITY SOLUTIONS%' ) ) LIMIT 1 [ RunTime:0.032709s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16002 LIMIT 4 [ RunTime:0.011736s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16002 ORDER BY `minOrder` ASC [ RunTime:0.070126s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16002 ORDER BY `unit` DESC [ RunTime:0.011659s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16002 LIMIT 2 [ RunTime:0.007646s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16002 ORDER BY `minOrder` ASC [ RunTime:0.005511s ]
select * from pdf where partno='CRCW08051M00FKEA' and brandshort='VISHAY' limit 1 [ RunTime:0.014837s ]
select foldpath,foldpath2,filename from pdf_file where id=1132266 limit 1 [ RunTime:0.017785s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CRCW08051M00FKEA' OR `brand` LIKE 'VISHAY%' ) ) LIMIT 1 [ RunTime:0.038991s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16001 LIMIT 4 [ RunTime:0.042275s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16001 ORDER BY `minOrder` ASC [ RunTime:0.031404s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16001 ORDER BY `unit` DESC [ RunTime:0.040291s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16001 LIMIT 2 [ RunTime:0.012687s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16001 ORDER BY `minOrder` ASC [ RunTime:0.020953s ]
select * from pdf where partno='MP6925AGS-P' and brandshort='MONOLITHIC POWER SYSTEMS MPS' limit 1 [ RunTime:0.039970s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MP6925AGS-P' OR `brand` LIKE 'MONOLITHIC POWER SYSTEMS (MPS)%' ) ) LIMIT 1 [ RunTime:0.023528s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16000 LIMIT 4 [ RunTime:0.028265s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16000 ORDER BY `minOrder` ASC [ RunTime:0.017567s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16000 ORDER BY `unit` DESC [ RunTime:0.050385s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16000 LIMIT 2 [ RunTime:0.024690s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16000 ORDER BY `minOrder` ASC [ RunTime:0.003307s ]
select * from pdf where partno='EEUFM1H471' and brandshort='PANASONIC' limit 1 [ RunTime:0.019988s ]
select foldpath,foldpath2,filename from pdf_file where id=1102890 limit 1 [ RunTime:0.010878s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'EEUFM1H471' OR `brand` LIKE 'PANASONIC%' ) ) LIMIT 1 [ RunTime:0.036257s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15999 LIMIT 4 [ RunTime:0.010119s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15999 ORDER BY `minOrder` ASC [ RunTime:0.014299s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15999 ORDER BY `unit` DESC [ RunTime:0.001410s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15999 LIMIT 2 [ RunTime:0.008973s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15999 ORDER BY `minOrder` ASC [ RunTime:0.019856s ]
select * from pdf where partno='XMLB010A2S13' and brandshort='TELEMECANIQUE SENSORS' limit 1 [ RunTime:0.014604s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'XMLB010A2S13' OR `brand` LIKE 'TELEMECANIQUE SENSORS%' ) ) LIMIT 1 [ RunTime:0.030450s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15998 LIMIT 4 [ RunTime:0.010425s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15998 ORDER BY `minOrder` ASC [ RunTime:0.019482s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15998 ORDER BY `unit` DESC [ RunTime:0.038915s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15998 LIMIT 2 [ RunTime:0.019833s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15998 ORDER BY `minOrder` ASC [ RunTime:0.002385s ]
select * from pdf where partno='74439358068' and brandshort='WURTH ELEKTRONIK' limit 1 [ RunTime:0.016091s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '74439358068' OR `brand` LIKE 'WURTH ELEKTRONIK%' ) ) LIMIT 1 [ RunTime:0.005229s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15997 LIMIT 4 [ RunTime:0.021693s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15997 ORDER BY `minOrder` ASC [ RunTime:0.015737s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15997 ORDER BY `unit` DESC [ RunTime:0.047220s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15997 LIMIT 2 [ RunTime:0.002151s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15997 ORDER BY `minOrder` ASC [ RunTime:0.007549s ]
select * from pdf where partno='CRCW0603330RFKEAHP' and brandshort='VISHAY' limit 1 [ RunTime:0.009400s ]
select foldpath,foldpath2,filename from pdf_file where id=1489008 limit 1 [ RunTime:0.001594s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CRCW0603330RFKEAHP' OR `brand` LIKE 'VISHAY%' ) ) LIMIT 1 [ RunTime:0.038058s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15996 LIMIT 4 [ RunTime:0.012015s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15996 ORDER BY `minOrder` ASC [ RunTime:0.002823s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15996 ORDER BY `unit` DESC [ RunTime:0.005009s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15996 LIMIT 2 [ RunTime:0.019396s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15996 ORDER BY `minOrder` ASC [ RunTime:0.005945s ]
select * from pdf where partno='785679-01' and brandshort='NI' limit 1 [ RunTime:0.020654s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '785679-01' OR `brand` LIKE 'NI%' ) ) LIMIT 1 [ RunTime:0.005647s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15995 LIMIT 4 [ RunTime:0.005537s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15995 ORDER BY `minOrder` ASC [ RunTime:0.004096s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15995 ORDER BY `unit` DESC [ RunTime:0.011476s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15995 LIMIT 2 [ RunTime:0.017919s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15995 ORDER BY `minOrder` ASC [ RunTime:0.005696s ]
select * from pdf where partno='SK34A' and brandshort='TAIWAN SEMICONDUCTOR' limit 1 [ RunTime:0.011966s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SK34A' OR `brand` LIKE 'TAIWAN SEMICONDUCTOR%' ) ) LIMIT 1 [ RunTime:0.009559s ]
SELECT brand, count(*) as count FROM `stock` WHERE ( `status` = 4 AND `status` <> 2 ) AND `brand` IS NOT NULL AND `brand` <> '' GROUP BY `brand` ORDER BY `count` DESC LIMIT 10000 [ RunTime:0.002634s ]