SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001275s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.043256s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001708s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.0' ) [ RunTime:0.072879s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.005173s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.074195s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.035675s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.048953s ]
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.031208s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002807s ]
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.040482s ]
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 940,20 [ RunTime:0.108425s ]
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 ('15314','15313','15312','15311','15310','15309','15308','15307','15306','15305','15304','15303','15302','15301','15300','15299','15298','15297','15296','15295') ORDER BY FIELD(s.id, 15314,15313,15312,15311,15310,15309,15308,15307,15306,15305,15304,15303,15302,15301,15300,15299,15298,15297,15296,15295) [ RunTime:0.218325s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.041944s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15314 LIMIT 4 [ RunTime:0.144404s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.003995s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15314 ORDER BY `minOrder` ASC [ RunTime:0.050809s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001207s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15314 ORDER BY `unit` DESC [ RunTime:0.182081s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.022672s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15314 LIMIT 2 [ RunTime:0.124904s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15314 ORDER BY `minOrder` ASC [ RunTime:0.094034s ]
select * from pdf where partno='RP73PF1E2K0BTDF' and brandshort='CGS - TE CONNECTIVITY' limit 1 [ RunTime:0.061259s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001392s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'RP73PF1E2K0BTDF' OR `brand` LIKE 'CGS - TE CONNECTIVITY%' ) ) LIMIT 1 [ RunTime:0.091076s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15313 LIMIT 4 [ RunTime:0.122682s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15313 ORDER BY `minOrder` ASC [ RunTime:0.137925s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15313 ORDER BY `unit` DESC [ RunTime:0.091888s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15313 LIMIT 2 [ RunTime:0.049285s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15313 ORDER BY `minOrder` ASC [ RunTime:0.090181s ]
select * from pdf where partno='TNPW06035K62BEEA' and brandshort='VISHAY' limit 1 [ RunTime:0.106840s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TNPW06035K62BEEA' OR `brand` LIKE 'VISHAY%' ) ) LIMIT 1 [ RunTime:0.130565s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15312 LIMIT 4 [ RunTime:0.083344s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15312 ORDER BY `minOrder` ASC [ RunTime:0.130644s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15312 ORDER BY `unit` DESC [ RunTime:0.153535s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15312 LIMIT 2 [ RunTime:0.090799s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15312 ORDER BY `minOrder` ASC [ RunTime:0.039218s ]
select * from pdf where partno='PMEG4050EP,115.' and brandshort='NEXPERIA' limit 1 [ RunTime:0.017801s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PMEG4050EP,115.' OR `brand` LIKE 'NEXPERIA%' ) ) LIMIT 1 [ RunTime:0.090858s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15311 LIMIT 4 [ RunTime:0.080506s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15311 ORDER BY `minOrder` ASC [ RunTime:0.067294s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15311 ORDER BY `unit` DESC [ RunTime:0.096766s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15311 LIMIT 2 [ RunTime:0.077274s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15311 ORDER BY `minOrder` ASC [ RunTime:0.014360s ]
select * from pdf where partno='FTY.00.250.CTF' and brandshort='LEMO' limit 1 [ RunTime:0.036847s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTY.00.250.CTF' OR `brand` LIKE 'LEMO%' ) ) LIMIT 1 [ RunTime:0.061518s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15310 LIMIT 4 [ RunTime:0.050036s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15310 ORDER BY `minOrder` ASC [ RunTime:0.057798s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15310 ORDER BY `unit` DESC [ RunTime:0.063291s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15310 LIMIT 2 [ RunTime:0.144224s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15310 ORDER BY `minOrder` ASC [ RunTime:0.069481s ]
select * from pdf where partno='FMMT591' and brandshort='DIODES INC.' limit 1 [ RunTime:0.117002s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FMMT591' OR `brand` LIKE 'DIODES INC.%' ) ) LIMIT 1 [ RunTime:0.094965s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15309 LIMIT 4 [ RunTime:0.030178s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15309 ORDER BY `minOrder` ASC [ RunTime:0.144987s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15309 ORDER BY `unit` DESC [ RunTime:0.118755s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15309 LIMIT 2 [ RunTime:0.082177s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15309 ORDER BY `minOrder` ASC [ RunTime:0.059994s ]
select * from pdf where partno='ZXTP2012ZTA' and brandshort='DIODES INC.' limit 1 [ RunTime:0.098734s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ZXTP2012ZTA' OR `brand` LIKE 'DIODES INC.%' ) ) LIMIT 1 [ RunTime:0.077316s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15308 LIMIT 4 [ RunTime:0.084622s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15308 ORDER BY `minOrder` ASC [ RunTime:0.059161s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15308 ORDER BY `unit` DESC [ RunTime:0.009989s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15308 LIMIT 2 [ RunTime:0.029548s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15308 ORDER BY `minOrder` ASC [ RunTime:0.036823s ]
select * from pdf where partno='PEL12T-4225S-S1024-DEL' and brandshort='BOURNS' limit 1 [ RunTime:0.019493s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PEL12T-4225S-S1024-DEL' OR `brand` LIKE 'BOURNS%' ) ) LIMIT 1 [ RunTime:0.004993s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15307 LIMIT 4 [ RunTime:0.015612s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15307 ORDER BY `minOrder` ASC [ RunTime:0.021316s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15307 ORDER BY `unit` DESC [ RunTime:0.028231s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15307 LIMIT 2 [ RunTime:0.040186s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15307 ORDER BY `minOrder` ASC [ RunTime:0.000588s ]
select * from pdf where partno='12061A151JAT2A' and brandshort='KYOCERA AVX' limit 1 [ RunTime:0.034800s ]
select foldpath,foldpath2,filename from pdf_file where id=1976071 limit 1 [ RunTime:0.029427s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '12061A151JAT2A' OR `brand` LIKE 'KYOCERA AVX%' ) ) LIMIT 1 [ RunTime:0.036196s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15306 LIMIT 4 [ RunTime:0.013775s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15306 ORDER BY `minOrder` ASC [ RunTime:0.033270s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15306 ORDER BY `unit` DESC [ RunTime:0.029893s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15306 LIMIT 2 [ RunTime:0.014237s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15306 ORDER BY `minOrder` ASC [ RunTime:0.002731s ]
select * from pdf where partno='PMV27UPER' and brandshort='NEXPERIA' limit 1 [ RunTime:0.011407s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PMV27UPER' OR `brand` LIKE 'NEXPERIA%' ) ) LIMIT 1 [ RunTime:0.011765s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15305 LIMIT 4 [ RunTime:0.015295s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15305 ORDER BY `minOrder` ASC [ RunTime:0.014538s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15305 ORDER BY `unit` DESC [ RunTime:0.002662s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15305 LIMIT 2 [ RunTime:0.012680s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15305 ORDER BY `minOrder` ASC [ RunTime:0.000908s ]
select * from pdf where partno='IRF9Z24NPBF' and brandshort='INFINEON' limit 1 [ RunTime:0.007981s ]
select foldpath,foldpath2,filename from pdf_file where id=987574 limit 1 [ RunTime:0.017857s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'IRF9Z24NPBF' OR `brand` LIKE 'INFINEON%' ) ) LIMIT 1 [ RunTime:0.019717s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15304 LIMIT 4 [ RunTime:0.017232s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15304 ORDER BY `minOrder` ASC [ RunTime:0.007731s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15304 ORDER BY `unit` DESC [ RunTime:0.030888s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15304 LIMIT 2 [ RunTime:0.015397s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15304 ORDER BY `minOrder` ASC [ RunTime:0.009998s ]
select * from pdf where partno='1582 1UH 2.2A' and brandshort='FERROPERM' limit 1 [ RunTime:0.026535s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1582 1UH 2.2A' OR `brand` LIKE 'FERROPERM%' ) ) LIMIT 1 [ RunTime:0.012282s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15303 LIMIT 4 [ RunTime:0.027767s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15303 ORDER BY `minOrder` ASC [ RunTime:0.016114s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15303 ORDER BY `unit` DESC [ RunTime:0.019153s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15303 LIMIT 2 [ RunTime:0.008484s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15303 ORDER BY `minOrder` ASC [ RunTime:0.034070s ]
select * from pdf where partno='HBL2623' and brandshort='HUBBELL WIRING DEVICES' limit 1 [ RunTime:0.017338s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'HBL2623' OR `brand` LIKE 'HUBBELL WIRING DEVICES%' ) ) LIMIT 1 [ RunTime:0.009518s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15302 LIMIT 4 [ RunTime:0.013266s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15302 ORDER BY `minOrder` ASC [ RunTime:0.008213s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15302 ORDER BY `unit` DESC [ RunTime:0.005519s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15302 LIMIT 2 [ RunTime:0.011522s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15302 ORDER BY `minOrder` ASC [ RunTime:0.000419s ]
select * from pdf where partno='MBR1660-E3/45' and brandshort='VISHAY' limit 1 [ RunTime:0.005569s ]
select foldpath,foldpath2,filename from pdf_file where id=1921777 limit 1 [ RunTime:0.001452s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MBR1660-E3/45' OR `brand` LIKE 'VISHAY%' ) ) LIMIT 1 [ RunTime:0.022301s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15301 LIMIT 4 [ RunTime:0.010639s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15301 ORDER BY `minOrder` ASC [ RunTime:0.009230s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15301 ORDER BY `unit` DESC [ RunTime:0.003786s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15301 LIMIT 2 [ RunTime:0.006159s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15301 ORDER BY `minOrder` ASC [ RunTime:0.000712s ]
select * from pdf where partno='PESD1CAN,215' and brandshort='NEXPERIA' limit 1 [ RunTime:0.011267s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PESD1CAN,215' OR `brand` LIKE 'NEXPERIA%' ) ) LIMIT 1 [ RunTime:0.023617s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15300 LIMIT 4 [ RunTime:0.023435s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15300 ORDER BY `minOrder` ASC [ RunTime:0.038411s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15300 ORDER BY `unit` DESC [ RunTime:0.002848s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15300 LIMIT 2 [ RunTime:0.009540s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15300 ORDER BY `minOrder` ASC [ RunTime:0.015551s ]
select * from pdf where partno='FTS-105-01-F-DV' and brandshort='SAMTEC' limit 1 [ RunTime:0.016543s ]
select foldpath,foldpath2,filename from pdf_file where id=1245244 limit 1 [ RunTime:0.005510s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTS-105-01-F-DV' OR `brand` LIKE 'SAMTEC%' ) ) LIMIT 1 [ RunTime:0.014288s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15299 LIMIT 4 [ RunTime:0.010060s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15299 ORDER BY `minOrder` ASC [ RunTime:0.005306s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15299 ORDER BY `unit` DESC [ RunTime:0.026699s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15299 LIMIT 2 [ RunTime:0.026298s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15299 ORDER BY `minOrder` ASC [ RunTime:0.003390s ]
select * from pdf where partno='TAP156M016CCS' and brandshort='KYOCERA AVX' limit 1 [ RunTime:0.011184s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TAP156M016CCS' OR `brand` LIKE 'KYOCERA AVX%' ) ) LIMIT 1 [ RunTime:0.029606s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15298 LIMIT 4 [ RunTime:0.023386s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15298 ORDER BY `minOrder` ASC [ RunTime:0.005143s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15298 ORDER BY `unit` DESC [ RunTime:0.004520s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15298 LIMIT 2 [ RunTime:0.039101s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15298 ORDER BY `minOrder` ASC [ RunTime:0.028752s ]
select * from pdf where partno='GD300HFY120C6S' and brandshort='STARPOWER' limit 1 [ RunTime:0.014531s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'GD300HFY120C6S' OR `brand` LIKE 'STARPOWER%' ) ) LIMIT 1 [ RunTime:0.050886s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15297 LIMIT 4 [ RunTime:0.009191s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15297 ORDER BY `minOrder` ASC [ RunTime:0.034405s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15297 ORDER BY `unit` DESC [ RunTime:0.051819s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15297 LIMIT 2 [ RunTime:0.020608s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15297 ORDER BY `minOrder` ASC [ RunTime:0.031664s ]
select * from pdf where partno='19323-0013' and brandshort='MOLEX' limit 1 [ RunTime:0.032512s ]
select foldpath,foldpath2,filename from pdf_file where id=1116667 limit 1 [ RunTime:0.060631s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '19323-0013' OR `brand` LIKE 'MOLEX%' ) ) LIMIT 1 [ RunTime:0.046667s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15296 LIMIT 4 [ RunTime:0.023724s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15296 ORDER BY `minOrder` ASC [ RunTime:0.015321s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15296 ORDER BY `unit` DESC [ RunTime:0.065481s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15296 LIMIT 2 [ RunTime:0.034247s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15296 ORDER BY `minOrder` ASC [ RunTime:0.020916s ]
select * from pdf where partno='352162KFT' and brandshort='TE CONNECTIVITY' limit 1 [ RunTime:0.068816s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '352162KFT' OR `brand` LIKE 'TE CONNECTIVITY%' ) ) LIMIT 1 [ RunTime:0.033129s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15295 LIMIT 4 [ RunTime:0.029977s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15295 ORDER BY `minOrder` ASC [ RunTime:0.001582s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15295 ORDER BY `unit` DESC [ RunTime:0.011468s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15295 LIMIT 2 [ RunTime:0.030628s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15295 ORDER BY `minOrder` ASC [ RunTime:0.022371s ]
select * from pdf where partno='ACPL-227-560E' and brandshort='BROADCOM' limit 1 [ RunTime:0.027018s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ACPL-227-560E' OR `brand` LIKE 'BROADCOM%' ) ) LIMIT 1 [ RunTime:0.021672s ]
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.021155s ]