SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001413s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.016397s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001437s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.113' ) [ RunTime:0.023680s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001460s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.012956s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.004794s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.010078s ]
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.016234s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001719s ]
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.009845s ]
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 300,20 [ RunTime:0.044243s ]
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 ('15954','15953','15952','15951','15950','15949','15948','15947','15946','15945','15944','15943','15942','15941','15940','15939','15938','15937','15936','15935') ORDER BY FIELD(s.id, 15954,15953,15952,15951,15950,15949,15948,15947,15946,15945,15944,15943,15942,15941,15940,15939,15938,15937,15936,15935) [ RunTime:0.053194s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.008781s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15954 LIMIT 4 [ RunTime:0.004499s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.005103s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15954 ORDER BY `minOrder` ASC [ RunTime:0.036820s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002712s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15954 ORDER BY `unit` DESC [ RunTime:0.023587s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002747s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15954 LIMIT 2 [ RunTime:0.040601s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15954 ORDER BY `minOrder` ASC [ RunTime:0.052675s ]
select * from pdf where partno='RC0402FR-0747KL' and brandshort='YAGEO' limit 1 [ RunTime:0.014454s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002561s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'RC0402FR-0747KL' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.028926s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15953 LIMIT 4 [ RunTime:0.026963s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15953 ORDER BY `minOrder` ASC [ RunTime:0.003934s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15953 ORDER BY `unit` DESC [ RunTime:0.021513s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15953 LIMIT 2 [ RunTime:0.005229s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15953 ORDER BY `minOrder` ASC [ RunTime:0.020954s ]
select * from pdf where partno='WD 1000 CN' and brandshort='WELLER' limit 1 [ RunTime:0.007588s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'WD 1000 CN' OR `brand` LIKE 'WELLER%' ) ) LIMIT 1 [ RunTime:0.005581s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15952 LIMIT 4 [ RunTime:0.030443s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15952 ORDER BY `minOrder` ASC [ RunTime:0.016144s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15952 ORDER BY `unit` DESC [ RunTime:0.025459s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15952 LIMIT 2 [ RunTime:0.018647s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15952 ORDER BY `minOrder` ASC [ RunTime:0.015291s ]
select * from pdf where partno='0603YC104JAT2A' and brandshort='KYOCERA AVX' limit 1 [ RunTime:0.031826s ]
select foldpath,foldpath2,filename from pdf_file where id=1976081 limit 1 [ RunTime:0.001713s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '0603YC104JAT2A' OR `brand` LIKE 'KYOCERA AVX%' ) ) LIMIT 1 [ RunTime:0.022678s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15951 LIMIT 4 [ RunTime:0.019741s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15951 ORDER BY `minOrder` ASC [ RunTime:0.020152s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15951 ORDER BY `unit` DESC [ RunTime:0.038541s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15951 LIMIT 2 [ RunTime:0.057750s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15951 ORDER BY `minOrder` ASC [ RunTime:0.019251s ]
select * from pdf where partno='ASC0805-10KFT5' and brandshort='TT ELECTRONICS / WELWYN' limit 1 [ RunTime:0.036333s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ASC0805-10KFT5' OR `brand` LIKE 'TT ELECTRONICS / WELWYN%' ) ) LIMIT 1 [ RunTime:0.024898s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15950 LIMIT 4 [ RunTime:0.046096s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15950 ORDER BY `minOrder` ASC [ RunTime:0.073549s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15950 ORDER BY `unit` DESC [ RunTime:0.013341s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15950 LIMIT 2 [ RunTime:0.031551s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15950 ORDER BY `minOrder` ASC [ RunTime:0.010537s ]
select * from pdf where partno='BTS5016SDAAUMA1' and brandshort='INFINEON' limit 1 [ RunTime:0.034753s ]
select foldpath,foldpath2,filename from pdf_file where id=1670929 limit 1 [ RunTime:0.039783s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BTS5016SDAAUMA1' OR `brand` LIKE 'INFINEON%' ) ) LIMIT 1 [ RunTime:0.048674s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15949 LIMIT 4 [ RunTime:0.009699s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15949 ORDER BY `minOrder` ASC [ RunTime:0.039945s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15949 ORDER BY `unit` DESC [ RunTime:0.037131s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15949 LIMIT 2 [ RunTime:0.014677s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15949 ORDER BY `minOrder` ASC [ RunTime:0.012585s ]
select * from pdf where partno='74HC245D,653' and brandshort='NEXPERIA' limit 1 [ RunTime:0.059375s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '74HC245D,653' OR `brand` LIKE 'NEXPERIA%' ) ) LIMIT 1 [ RunTime:0.035659s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15948 LIMIT 4 [ RunTime:0.024738s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15948 ORDER BY `minOrder` ASC [ RunTime:0.025409s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15948 ORDER BY `unit` DESC [ RunTime:0.016483s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15948 LIMIT 2 [ RunTime:0.041452s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15948 ORDER BY `minOrder` ASC [ RunTime:0.002989s ]
select * from pdf where partno='EEEFK1C221P' and brandshort='PANASONIC' limit 1 [ RunTime:0.026199s ]
select foldpath,foldpath2,filename from pdf_file where id=258802 limit 1 [ RunTime:0.041800s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'EEEFK1C221P' OR `brand` LIKE 'PANASONIC%' ) ) LIMIT 1 [ RunTime:0.072129s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15947 LIMIT 4 [ RunTime:0.064218s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15947 ORDER BY `minOrder` ASC [ RunTime:0.014074s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15947 ORDER BY `unit` DESC [ RunTime:0.034105s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15947 LIMIT 2 [ RunTime:0.029599s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15947 ORDER BY `minOrder` ASC [ RunTime:0.028625s ]
select * from pdf where partno='561R10TCCT10' and brandshort='VISHAY' limit 1 [ RunTime:0.048793s ]
select foldpath,foldpath2,filename from pdf_file where id=1554879 limit 1 [ RunTime:0.045258s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '561R10TCCT10' OR `brand` LIKE 'VISHAY%' ) ) LIMIT 1 [ RunTime:0.007141s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15946 LIMIT 4 [ RunTime:0.041567s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15946 ORDER BY `minOrder` ASC [ RunTime:0.004855s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15946 ORDER BY `unit` DESC [ RunTime:0.052401s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15946 LIMIT 2 [ RunTime:0.032577s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15946 ORDER BY `minOrder` ASC [ RunTime:0.036781s ]
select * from pdf where partno='ERJPA3F8201V' and brandshort='PANASONIC' limit 1 [ RunTime:0.011342s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ERJPA3F8201V' OR `brand` LIKE 'PANASONIC%' ) ) LIMIT 1 [ RunTime:0.038627s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15945 LIMIT 4 [ RunTime:0.035510s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15945 ORDER BY `minOrder` ASC [ RunTime:0.012752s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15945 ORDER BY `unit` DESC [ RunTime:0.047363s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15945 LIMIT 2 [ RunTime:0.012311s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15945 ORDER BY `minOrder` ASC [ RunTime:0.016247s ]
select * from pdf where partno='SMCJ9.0CA-13-F' and brandshort='MULTICOMP PRO' limit 1 [ RunTime:0.030164s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMCJ9.0CA-13-F' OR `brand` LIKE 'MULTICOMP PRO%' ) ) LIMIT 1 [ RunTime:0.013622s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15944 LIMIT 4 [ RunTime:0.030527s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15944 ORDER BY `minOrder` ASC [ RunTime:0.021663s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15944 ORDER BY `unit` DESC [ RunTime:0.042207s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15944 LIMIT 2 [ RunTime:0.039937s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15944 ORDER BY `minOrder` ASC [ RunTime:0.005211s ]
select * from pdf where partno='RC0603FR-0710KL' and brandshort='YAGEO' limit 1 [ RunTime:0.018127s ]
select foldpath,foldpath2,filename from pdf_file where id=1487253 limit 1 [ RunTime:0.019344s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'RC0603FR-0710KL' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.024068s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15943 LIMIT 4 [ RunTime:0.023426s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15943 ORDER BY `minOrder` ASC [ RunTime:0.031926s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15943 ORDER BY `unit` DESC [ RunTime:0.027269s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15943 LIMIT 2 [ RunTime:0.011870s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15943 ORDER BY `minOrder` ASC [ RunTime:0.003699s ]
select * from pdf where partno='C1005X7R1C224K050BC' and brandshort='TDK' limit 1 [ RunTime:0.049222s ]
select foldpath,foldpath2,filename from pdf_file where id=1205027 limit 1 [ RunTime:0.024055s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'C1005X7R1C224K050BC' OR `brand` LIKE 'TDK%' ) ) LIMIT 1 [ RunTime:0.030299s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15942 LIMIT 4 [ RunTime:0.037585s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15942 ORDER BY `minOrder` ASC [ RunTime:0.043848s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15942 ORDER BY `unit` DESC [ RunTime:0.027413s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15942 LIMIT 2 [ RunTime:0.011574s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15942 ORDER BY `minOrder` ASC [ RunTime:0.025406s ]
select * from pdf where partno='C2220X106K5RACTU' and brandshort='KEMET' limit 1 [ RunTime:0.007960s ]
select foldpath,foldpath2,filename from pdf_file where id=1980073 limit 1 [ RunTime:0.019937s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'C2220X106K5RACTU' OR `brand` LIKE 'KEMET%' ) ) LIMIT 1 [ RunTime:0.017038s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15941 LIMIT 4 [ RunTime:0.009469s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15941 ORDER BY `minOrder` ASC [ RunTime:0.019600s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15941 ORDER BY `unit` DESC [ RunTime:0.021190s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15941 LIMIT 2 [ RunTime:0.002219s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15941 ORDER BY `minOrder` ASC [ RunTime:0.000453s ]
select * from pdf where partno='PCA9306D,118.' and brandshort='NXP' limit 1 [ RunTime:0.008825s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PCA9306D,118.' OR `brand` LIKE 'NXP%' ) ) LIMIT 1 [ RunTime:0.029012s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15940 LIMIT 4 [ RunTime:0.016309s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15940 ORDER BY `minOrder` ASC [ RunTime:0.021715s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15940 ORDER BY `unit` DESC [ RunTime:0.016568s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15940 LIMIT 2 [ RunTime:0.015386s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15940 ORDER BY `minOrder` ASC [ RunTime:0.010979s ]
select * from pdf where partno='J0011D01BNL' and brandshort='PULSE ELECTRONICS' limit 1 [ RunTime:0.018732s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'J0011D01BNL' OR `brand` LIKE 'PULSE ELECTRONICS%' ) ) LIMIT 1 [ RunTime:0.012503s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15939 LIMIT 4 [ RunTime:0.010134s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15939 ORDER BY `minOrder` ASC [ RunTime:0.002452s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15939 ORDER BY `unit` DESC [ RunTime:0.005648s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15939 LIMIT 2 [ RunTime:0.024432s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15939 ORDER BY `minOrder` ASC [ RunTime:0.013755s ]
select * from pdf where partno='G3VM-202J1' and brandshort='OMRON' limit 1 [ RunTime:0.013499s ]
select foldpath,foldpath2,filename from pdf_file where id=689977 limit 1 [ RunTime:0.015538s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'G3VM-202J1' OR `brand` LIKE 'OMRON%' ) ) LIMIT 1 [ RunTime:0.025206s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15938 LIMIT 4 [ RunTime:0.007642s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15938 ORDER BY `minOrder` ASC [ RunTime:0.008823s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15938 ORDER BY `unit` DESC [ RunTime:0.001998s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15938 LIMIT 2 [ RunTime:0.008306s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15938 ORDER BY `minOrder` ASC [ RunTime:0.008730s ]
select * from pdf where partno='MF12 1K' and brandshort='MULTICOMP PRO' limit 1 [ RunTime:0.026941s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MF12 1K' OR `brand` LIKE 'MULTICOMP PRO%' ) ) LIMIT 1 [ RunTime:0.010630s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15937 LIMIT 4 [ RunTime:0.001369s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15937 ORDER BY `minOrder` ASC [ RunTime:0.002951s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15937 ORDER BY `unit` DESC [ RunTime:0.005127s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15937 LIMIT 2 [ RunTime:0.015733s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15937 ORDER BY `minOrder` ASC [ RunTime:0.008757s ]
select * from pdf where partno='CPF210R000FKE14' and brandshort='VISHAY' limit 1 [ RunTime:0.022915s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CPF210R000FKE14' OR `brand` LIKE 'VISHAY%' ) ) LIMIT 1 [ RunTime:0.023784s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15936 LIMIT 4 [ RunTime:0.014821s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15936 ORDER BY `minOrder` ASC [ RunTime:0.006671s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15936 ORDER BY `unit` DESC [ RunTime:0.014640s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15936 LIMIT 2 [ RunTime:0.009786s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15936 ORDER BY `minOrder` ASC [ RunTime:0.000807s ]
select * from pdf where partno='LTC6269IDD#PBF' and brandshort='ANALOG DEVICES' limit 1 [ RunTime:0.017223s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LTC6269IDD#PBF' OR `brand` LIKE 'ANALOG DEVICES%' ) ) LIMIT 1 [ RunTime:0.023074s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15935 LIMIT 4 [ RunTime:0.013313s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15935 ORDER BY `minOrder` ASC [ RunTime:0.024297s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15935 ORDER BY `unit` DESC [ RunTime:0.033108s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15935 LIMIT 2 [ RunTime:0.010394s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15935 ORDER BY `minOrder` ASC [ RunTime:0.009932s ]
select * from pdf where partno='0603B102K500CT' and brandshort='WALSIN' limit 1 [ RunTime:0.031304s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '0603B102K500CT' OR `brand` LIKE 'WALSIN%' ) ) LIMIT 1 [ RunTime:0.022551s ]
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.011004s ]