SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002462s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000531s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.003262s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.21' ) [ RunTime:0.008987s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002181s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.003891s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.000799s ]
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.000972s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002633s ]
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.014661s ]
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.004142s ]
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.002134s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001030s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16014 LIMIT 4 [ RunTime:0.000836s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001159s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16014 ORDER BY `minOrder` ASC [ RunTime:0.000668s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001010s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16014 ORDER BY `unit` DESC [ RunTime:0.006913s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001221s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16014 LIMIT 2 [ RunTime:0.010192s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16014 ORDER BY `minOrder` ASC [ RunTime:0.007865s ]
select * from pdf where partno='MAX9259GCB/V+' and brandshort='ANALOG DEVICES' limit 1 [ RunTime:0.002541s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002654s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MAX9259GCB/V+' OR `brand` LIKE 'ANALOG DEVICES%' ) ) LIMIT 1 [ RunTime:0.008555s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16013 LIMIT 4 [ RunTime:0.009713s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16013 ORDER BY `minOrder` ASC [ RunTime:0.003575s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16013 ORDER BY `unit` DESC [ RunTime:0.002904s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16013 LIMIT 2 [ RunTime:0.000319s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16013 ORDER BY `minOrder` ASC [ RunTime:0.003256s ]
select * from pdf where partno='L-130WDT/1EGW' and brandshort='KINGBRIGHT' limit 1 [ RunTime:0.000298s ]
select foldpath,foldpath2,filename from pdf_file where id=1387246 limit 1 [ RunTime:0.000171s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'L-130WDT/1EGW' OR `brand` LIKE 'KINGBRIGHT%' ) ) LIMIT 1 [ RunTime:0.000253s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16012 LIMIT 4 [ RunTime:0.000473s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16012 ORDER BY `minOrder` ASC [ RunTime:0.012088s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16012 ORDER BY `unit` DESC [ RunTime:0.005283s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16012 LIMIT 2 [ RunTime:0.005072s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16012 ORDER BY `minOrder` ASC [ RunTime:0.005833s ]
select * from pdf where partno='MDS-S-TS' and brandshort='ITT CANNON' limit 1 [ RunTime:0.014081s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MDS-S-TS' OR `brand` LIKE 'ITT CANNON%' ) ) LIMIT 1 [ RunTime:0.003700s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16011 LIMIT 4 [ RunTime:0.002422s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16011 ORDER BY `minOrder` ASC [ RunTime:0.002679s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16011 ORDER BY `unit` DESC [ RunTime:0.000471s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16011 LIMIT 2 [ RunTime:0.001111s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16011 ORDER BY `minOrder` ASC [ RunTime:0.014966s ]
select * from pdf where partno='BAS16P2T5G' and brandshort='ONSEMI' limit 1 [ RunTime:0.000387s ]
select foldpath,foldpath2,filename from pdf_file where id=2047199 limit 1 [ RunTime:0.000302s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BAS16P2T5G' OR `brand` LIKE 'ONSEMI%' ) ) LIMIT 1 [ RunTime:0.002171s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16010 LIMIT 4 [ RunTime:0.011745s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16010 ORDER BY `minOrder` ASC [ RunTime:0.005729s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16010 ORDER BY `unit` DESC [ RunTime:0.002443s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16010 LIMIT 2 [ RunTime:0.001531s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16010 ORDER BY `minOrder` ASC [ RunTime:0.022221s ]
select * from pdf where partno='WKO102MCPCJ0KR' and brandshort='VISHAY' limit 1 [ RunTime:0.001844s ]
select foldpath,foldpath2,filename from pdf_file where id=1498251 limit 1 [ RunTime:0.011727s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'WKO102MCPCJ0KR' OR `brand` LIKE 'VISHAY%' ) ) LIMIT 1 [ RunTime:0.024543s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16009 LIMIT 4 [ RunTime:0.025589s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16009 ORDER BY `minOrder` ASC [ RunTime:0.003905s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16009 ORDER BY `unit` DESC [ RunTime:0.014836s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16009 LIMIT 2 [ RunTime:0.001033s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16009 ORDER BY `minOrder` ASC [ RunTime:0.000495s ]
select * from pdf where partno='MCWR08X2003FTL' and brandshort='MULTICOMP PRO' limit 1 [ RunTime:0.012859s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MCWR08X2003FTL' OR `brand` LIKE 'MULTICOMP PRO%' ) ) LIMIT 1 [ RunTime:0.002772s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16008 LIMIT 4 [ RunTime:0.001084s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16008 ORDER BY `minOrder` ASC [ RunTime:0.003453s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16008 ORDER BY `unit` DESC [ RunTime:0.008522s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16008 LIMIT 2 [ RunTime:0.018795s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16008 ORDER BY `minOrder` ASC [ RunTime:0.009148s ]
select * from pdf where partno='STM32F071RBT6TR' and brandshort='STMICROELECTRONICS' limit 1 [ RunTime:0.008671s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'STM32F071RBT6TR' OR `brand` LIKE 'STMICROELECTRONICS%' ) ) LIMIT 1 [ RunTime:0.015173s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16007 LIMIT 4 [ RunTime:0.007883s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16007 ORDER BY `minOrder` ASC [ RunTime:0.029732s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16007 ORDER BY `unit` DESC [ RunTime:0.023712s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16007 LIMIT 2 [ RunTime:0.043004s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16007 ORDER BY `minOrder` ASC [ RunTime:0.007155s ]
select * from pdf where partno='MT46H64M16LFBF-5 IT:B' and brandshort='MICRON' limit 1 [ RunTime:0.003489s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MT46H64M16LFBF-5 IT:B' OR `brand` LIKE 'MICRON%' ) ) LIMIT 1 [ RunTime:0.004965s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16006 LIMIT 4 [ RunTime:0.003155s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16006 ORDER BY `minOrder` ASC [ RunTime:0.010559s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16006 ORDER BY `unit` DESC [ RunTime:0.006342s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16006 LIMIT 2 [ RunTime:0.008480s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16006 ORDER BY `minOrder` ASC [ RunTime:0.002757s ]
select * from pdf where partno='DF11-16DP-2DSA(08)' and brandshort='HIROSEHRS' limit 1 [ RunTime:0.011902s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'DF11-16DP-2DSA(08)' OR `brand` LIKE 'HIROSE(HRS)%' ) ) LIMIT 1 [ RunTime:0.008852s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16005 LIMIT 4 [ RunTime:0.004938s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16005 ORDER BY `minOrder` ASC [ RunTime:0.014666s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16005 ORDER BY `unit` DESC [ RunTime:0.006478s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16005 LIMIT 2 [ RunTime:0.006076s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16005 ORDER BY `minOrder` ASC [ RunTime:0.002301s ]
select * from pdf where partno='17501 10 B1' and brandshort='VOLEX' limit 1 [ RunTime:0.007519s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '17501 10 B1' OR `brand` LIKE 'VOLEX%' ) ) LIMIT 1 [ RunTime:0.003111s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16004 LIMIT 4 [ RunTime:0.004675s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16004 ORDER BY `minOrder` ASC [ RunTime:0.001386s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16004 ORDER BY `unit` DESC [ RunTime:0.003565s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16004 LIMIT 2 [ RunTime:0.000278s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16004 ORDER BY `minOrder` ASC [ RunTime:0.000159s ]
select * from pdf where partno='ERJP03J5R1V' and brandshort='PANASONIC' limit 1 [ RunTime:0.001283s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ERJP03J5R1V' OR `brand` LIKE 'PANASONIC%' ) ) LIMIT 1 [ RunTime:0.013017s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16003 LIMIT 4 [ RunTime:0.003161s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16003 ORDER BY `minOrder` ASC [ RunTime:0.001403s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16003 ORDER BY `unit` DESC [ RunTime:0.001252s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16003 LIMIT 2 [ RunTime:0.000251s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16003 ORDER BY `minOrder` ASC [ RunTime:0.000156s ]
select * from pdf where partno='FDBB-25S1AENT2/1-LF' and brandshort='CINCH CONNECTIVITY SOLUTIONS' limit 1 [ RunTime:0.001213s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FDBB-25S1AENT2/1-LF' OR `brand` LIKE 'CINCH CONNECTIVITY SOLUTIONS%' ) ) LIMIT 1 [ RunTime:0.005085s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16002 LIMIT 4 [ RunTime:0.002167s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16002 ORDER BY `minOrder` ASC [ RunTime:0.006131s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16002 ORDER BY `unit` DESC [ RunTime:0.012062s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16002 LIMIT 2 [ RunTime:0.011271s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16002 ORDER BY `minOrder` ASC [ RunTime:0.005192s ]
select * from pdf where partno='CRCW08051M00FKEA' and brandshort='VISHAY' limit 1 [ RunTime:0.004577s ]
select foldpath,foldpath2,filename from pdf_file where id=1132266 limit 1 [ RunTime:0.003076s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CRCW08051M00FKEA' OR `brand` LIKE 'VISHAY%' ) ) LIMIT 1 [ RunTime:0.024841s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16001 LIMIT 4 [ RunTime:0.002495s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16001 ORDER BY `minOrder` ASC [ RunTime:0.015886s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16001 ORDER BY `unit` DESC [ RunTime:0.030666s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16001 LIMIT 2 [ RunTime:0.031635s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16001 ORDER BY `minOrder` ASC [ RunTime:0.007577s ]
select * from pdf where partno='MP6925AGS-P' and brandshort='MONOLITHIC POWER SYSTEMS MPS' limit 1 [ RunTime:0.006652s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MP6925AGS-P' OR `brand` LIKE 'MONOLITHIC POWER SYSTEMS (MPS)%' ) ) LIMIT 1 [ RunTime:0.022974s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16000 LIMIT 4 [ RunTime:0.031604s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16000 ORDER BY `minOrder` ASC [ RunTime:0.037493s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16000 ORDER BY `unit` DESC [ RunTime:0.003159s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16000 LIMIT 2 [ RunTime:0.056114s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16000 ORDER BY `minOrder` ASC [ RunTime:0.031414s ]
select * from pdf where partno='EEUFM1H471' and brandshort='PANASONIC' limit 1 [ RunTime:0.027897s ]
select foldpath,foldpath2,filename from pdf_file where id=1102890 limit 1 [ RunTime:0.014843s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'EEUFM1H471' OR `brand` LIKE 'PANASONIC%' ) ) LIMIT 1 [ RunTime:0.019246s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15999 LIMIT 4 [ RunTime:0.003454s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15999 ORDER BY `minOrder` ASC [ RunTime:0.000568s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15999 ORDER BY `unit` DESC [ RunTime:0.000574s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15999 LIMIT 2 [ RunTime:0.002645s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15999 ORDER BY `minOrder` ASC [ RunTime:0.012826s ]
select * from pdf where partno='XMLB010A2S13' and brandshort='TELEMECANIQUE SENSORS' limit 1 [ RunTime:0.018109s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'XMLB010A2S13' OR `brand` LIKE 'TELEMECANIQUE SENSORS%' ) ) LIMIT 1 [ RunTime:0.003229s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15998 LIMIT 4 [ RunTime:0.001689s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15998 ORDER BY `minOrder` ASC [ RunTime:0.000672s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15998 ORDER BY `unit` DESC [ RunTime:0.000532s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15998 LIMIT 2 [ RunTime:0.011863s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15998 ORDER BY `minOrder` ASC [ RunTime:0.002098s ]
select * from pdf where partno='74439358068' and brandshort='WURTH ELEKTRONIK' limit 1 [ RunTime:0.022871s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '74439358068' OR `brand` LIKE 'WURTH ELEKTRONIK%' ) ) LIMIT 1 [ RunTime:0.014032s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15997 LIMIT 4 [ RunTime:0.005732s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15997 ORDER BY `minOrder` ASC [ RunTime:0.001276s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15997 ORDER BY `unit` DESC [ RunTime:0.000547s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15997 LIMIT 2 [ RunTime:0.000646s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15997 ORDER BY `minOrder` ASC [ RunTime:0.000347s ]
select * from pdf where partno='CRCW0603330RFKEAHP' and brandshort='VISHAY' limit 1 [ RunTime:0.004755s ]
select foldpath,foldpath2,filename from pdf_file where id=1489008 limit 1 [ RunTime:0.001900s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CRCW0603330RFKEAHP' OR `brand` LIKE 'VISHAY%' ) ) LIMIT 1 [ RunTime:0.018454s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15996 LIMIT 4 [ RunTime:0.002818s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15996 ORDER BY `minOrder` ASC [ RunTime:0.000507s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15996 ORDER BY `unit` DESC [ RunTime:0.004490s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15996 LIMIT 2 [ RunTime:0.019933s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15996 ORDER BY `minOrder` ASC [ RunTime:0.021729s ]
select * from pdf where partno='785679-01' and brandshort='NI' limit 1 [ RunTime:0.020910s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '785679-01' OR `brand` LIKE 'NI%' ) ) LIMIT 1 [ RunTime:0.029144s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15995 LIMIT 4 [ RunTime:0.048655s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15995 ORDER BY `minOrder` ASC [ RunTime:0.011496s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15995 ORDER BY `unit` DESC [ RunTime:0.023095s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15995 LIMIT 2 [ RunTime:0.073591s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15995 ORDER BY `minOrder` ASC [ RunTime:0.008949s ]
select * from pdf where partno='SK34A' and brandshort='TAIWAN SEMICONDUCTOR' limit 1 [ RunTime:0.026741s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SK34A' OR `brand` LIKE 'TAIWAN SEMICONDUCTOR%' ) ) LIMIT 1 [ RunTime:0.039755s ]
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.012973s ]