SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001349s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.015724s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001700s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.113' ) [ RunTime:0.009354s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001516s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.008279s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.011462s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.003477s ]
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.008050s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002232s ]
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.031015s ]
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.023119s ]
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.100398s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.007938s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15314 LIMIT 4 [ RunTime:0.017706s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.012548s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15314 ORDER BY `minOrder` ASC [ RunTime:0.010059s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.005466s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15314 ORDER BY `unit` DESC [ RunTime:0.019912s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.005432s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15314 LIMIT 2 [ RunTime:0.037256s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15314 ORDER BY `minOrder` ASC [ RunTime:0.018318s ]
select * from pdf where partno='RP73PF1E2K0BTDF' and brandshort='CGS - TE CONNECTIVITY' limit 1 [ RunTime:0.042389s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002381s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'RP73PF1E2K0BTDF' OR `brand` LIKE 'CGS - TE CONNECTIVITY%' ) ) LIMIT 1 [ RunTime:0.028331s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15313 LIMIT 4 [ RunTime:0.021821s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15313 ORDER BY `minOrder` ASC [ RunTime:0.007547s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15313 ORDER BY `unit` DESC [ RunTime:0.089098s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15313 LIMIT 2 [ RunTime:0.048471s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15313 ORDER BY `minOrder` ASC [ RunTime:0.017040s ]
select * from pdf where partno='TNPW06035K62BEEA' and brandshort='VISHAY' limit 1 [ RunTime:0.077645s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TNPW06035K62BEEA' OR `brand` LIKE 'VISHAY%' ) ) LIMIT 1 [ RunTime:0.066820s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15312 LIMIT 4 [ RunTime:0.041842s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15312 ORDER BY `minOrder` ASC [ RunTime:0.016782s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15312 ORDER BY `unit` DESC [ RunTime:0.070221s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15312 LIMIT 2 [ RunTime:0.058078s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15312 ORDER BY `minOrder` ASC [ RunTime:0.067544s ]
select * from pdf where partno='PMEG4050EP,115.' and brandshort='NEXPERIA' limit 1 [ RunTime:0.028480s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PMEG4050EP,115.' OR `brand` LIKE 'NEXPERIA%' ) ) LIMIT 1 [ RunTime:0.041043s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15311 LIMIT 4 [ RunTime:0.038930s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15311 ORDER BY `minOrder` ASC [ RunTime:0.020859s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15311 ORDER BY `unit` DESC [ RunTime:0.025212s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15311 LIMIT 2 [ RunTime:0.011264s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15311 ORDER BY `minOrder` ASC [ RunTime:0.009603s ]
select * from pdf where partno='FTY.00.250.CTF' and brandshort='LEMO' limit 1 [ RunTime:0.033306s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTY.00.250.CTF' OR `brand` LIKE 'LEMO%' ) ) LIMIT 1 [ RunTime:0.022518s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15310 LIMIT 4 [ RunTime:0.025690s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15310 ORDER BY `minOrder` ASC [ RunTime:0.033042s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15310 ORDER BY `unit` DESC [ RunTime:0.044243s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15310 LIMIT 2 [ RunTime:0.012186s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15310 ORDER BY `minOrder` ASC [ RunTime:0.003682s ]
select * from pdf where partno='FMMT591' and brandshort='DIODES INC.' limit 1 [ RunTime:0.038051s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FMMT591' OR `brand` LIKE 'DIODES INC.%' ) ) LIMIT 1 [ RunTime:0.019959s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15309 LIMIT 4 [ RunTime:0.023380s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15309 ORDER BY `minOrder` ASC [ RunTime:0.072122s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15309 ORDER BY `unit` DESC [ RunTime:0.044872s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15309 LIMIT 2 [ RunTime:0.055434s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15309 ORDER BY `minOrder` ASC [ RunTime:0.018682s ]
select * from pdf where partno='ZXTP2012ZTA' and brandshort='DIODES INC.' limit 1 [ RunTime:0.036815s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ZXTP2012ZTA' OR `brand` LIKE 'DIODES INC.%' ) ) LIMIT 1 [ RunTime:0.016006s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15308 LIMIT 4 [ RunTime:0.049490s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15308 ORDER BY `minOrder` ASC [ RunTime:0.018405s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15308 ORDER BY `unit` DESC [ RunTime:0.010991s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15308 LIMIT 2 [ RunTime:0.008427s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15308 ORDER BY `minOrder` ASC [ RunTime:0.011399s ]
select * from pdf where partno='PEL12T-4225S-S1024-DEL' and brandshort='BOURNS' limit 1 [ RunTime:0.015555s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PEL12T-4225S-S1024-DEL' OR `brand` LIKE 'BOURNS%' ) ) LIMIT 1 [ RunTime:0.008059s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15307 LIMIT 4 [ RunTime:0.025667s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15307 ORDER BY `minOrder` ASC [ RunTime:0.011770s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15307 ORDER BY `unit` DESC [ RunTime:0.031015s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15307 LIMIT 2 [ RunTime:0.021268s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15307 ORDER BY `minOrder` ASC [ RunTime:0.011230s ]
select * from pdf where partno='12061A151JAT2A' and brandshort='KYOCERA AVX' limit 1 [ RunTime:0.012943s ]
select foldpath,foldpath2,filename from pdf_file where id=1976071 limit 1 [ RunTime:0.023522s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '12061A151JAT2A' OR `brand` LIKE 'KYOCERA AVX%' ) ) LIMIT 1 [ RunTime:0.049377s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15306 LIMIT 4 [ RunTime:0.022294s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15306 ORDER BY `minOrder` ASC [ RunTime:0.021800s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15306 ORDER BY `unit` DESC [ RunTime:0.009634s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15306 LIMIT 2 [ RunTime:0.023249s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15306 ORDER BY `minOrder` ASC [ RunTime:0.037560s ]
select * from pdf where partno='PMV27UPER' and brandshort='NEXPERIA' limit 1 [ RunTime:0.029985s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PMV27UPER' OR `brand` LIKE 'NEXPERIA%' ) ) LIMIT 1 [ RunTime:0.021475s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15305 LIMIT 4 [ RunTime:0.013501s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15305 ORDER BY `minOrder` ASC [ RunTime:0.031422s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15305 ORDER BY `unit` DESC [ RunTime:0.014633s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15305 LIMIT 2 [ RunTime:0.037365s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15305 ORDER BY `minOrder` ASC [ RunTime:0.001503s ]
select * from pdf where partno='IRF9Z24NPBF' and brandshort='INFINEON' limit 1 [ RunTime:0.026169s ]
select foldpath,foldpath2,filename from pdf_file where id=987574 limit 1 [ RunTime:0.025756s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'IRF9Z24NPBF' OR `brand` LIKE 'INFINEON%' ) ) LIMIT 1 [ RunTime:0.044544s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15304 LIMIT 4 [ RunTime:0.029629s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15304 ORDER BY `minOrder` ASC [ RunTime:0.009296s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15304 ORDER BY `unit` DESC [ RunTime:0.031681s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15304 LIMIT 2 [ RunTime:0.013928s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15304 ORDER BY `minOrder` ASC [ RunTime:0.007916s ]
select * from pdf where partno='1582 1UH 2.2A' and brandshort='FERROPERM' limit 1 [ RunTime:0.036180s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1582 1UH 2.2A' OR `brand` LIKE 'FERROPERM%' ) ) LIMIT 1 [ RunTime:0.040634s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15303 LIMIT 4 [ RunTime:0.009915s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15303 ORDER BY `minOrder` ASC [ RunTime:0.024831s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15303 ORDER BY `unit` DESC [ RunTime:0.005756s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15303 LIMIT 2 [ RunTime:0.025185s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15303 ORDER BY `minOrder` ASC [ RunTime:0.001031s ]
select * from pdf where partno='HBL2623' and brandshort='HUBBELL WIRING DEVICES' limit 1 [ RunTime:0.010585s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'HBL2623' OR `brand` LIKE 'HUBBELL WIRING DEVICES%' ) ) LIMIT 1 [ RunTime:0.016402s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15302 LIMIT 4 [ RunTime:0.026760s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15302 ORDER BY `minOrder` ASC [ RunTime:0.012100s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15302 ORDER BY `unit` DESC [ RunTime:0.004773s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15302 LIMIT 2 [ RunTime:0.002725s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15302 ORDER BY `minOrder` ASC [ RunTime:0.004423s ]
select * from pdf where partno='MBR1660-E3/45' and brandshort='VISHAY' limit 1 [ RunTime:0.018473s ]
select foldpath,foldpath2,filename from pdf_file where id=1921777 limit 1 [ RunTime:0.012673s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MBR1660-E3/45' OR `brand` LIKE 'VISHAY%' ) ) LIMIT 1 [ RunTime:0.035217s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15301 LIMIT 4 [ RunTime:0.027034s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15301 ORDER BY `minOrder` ASC [ RunTime:0.042342s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15301 ORDER BY `unit` DESC [ RunTime:0.015795s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15301 LIMIT 2 [ RunTime:0.008030s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15301 ORDER BY `minOrder` ASC [ RunTime:0.004900s ]
select * from pdf where partno='PESD1CAN,215' and brandshort='NEXPERIA' limit 1 [ RunTime:0.014742s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PESD1CAN,215' OR `brand` LIKE 'NEXPERIA%' ) ) LIMIT 1 [ RunTime:0.030408s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15300 LIMIT 4 [ RunTime:0.013434s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15300 ORDER BY `minOrder` ASC [ RunTime:0.037776s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15300 ORDER BY `unit` DESC [ RunTime:0.018043s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15300 LIMIT 2 [ RunTime:0.010725s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15300 ORDER BY `minOrder` ASC [ RunTime:0.006666s ]
select * from pdf where partno='FTS-105-01-F-DV' and brandshort='SAMTEC' limit 1 [ RunTime:0.024786s ]
select foldpath,foldpath2,filename from pdf_file where id=1245244 limit 1 [ RunTime:0.014302s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTS-105-01-F-DV' OR `brand` LIKE 'SAMTEC%' ) ) LIMIT 1 [ RunTime:0.004535s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15299 LIMIT 4 [ RunTime:0.003204s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15299 ORDER BY `minOrder` ASC [ RunTime:0.015002s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15299 ORDER BY `unit` DESC [ RunTime:0.013932s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15299 LIMIT 2 [ RunTime:0.026107s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15299 ORDER BY `minOrder` ASC [ RunTime:0.004979s ]
select * from pdf where partno='TAP156M016CCS' and brandshort='KYOCERA AVX' limit 1 [ RunTime:0.007353s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TAP156M016CCS' OR `brand` LIKE 'KYOCERA AVX%' ) ) LIMIT 1 [ RunTime:0.017526s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15298 LIMIT 4 [ RunTime:0.009756s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15298 ORDER BY `minOrder` ASC [ RunTime:0.007229s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15298 ORDER BY `unit` DESC [ RunTime:0.008292s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15298 LIMIT 2 [ RunTime:0.005380s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15298 ORDER BY `minOrder` ASC [ RunTime:0.005110s ]
select * from pdf where partno='GD300HFY120C6S' and brandshort='STARPOWER' limit 1 [ RunTime:0.018249s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'GD300HFY120C6S' OR `brand` LIKE 'STARPOWER%' ) ) LIMIT 1 [ RunTime:0.018012s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15297 LIMIT 4 [ RunTime:0.018259s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15297 ORDER BY `minOrder` ASC [ RunTime:0.041832s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15297 ORDER BY `unit` DESC [ RunTime:0.038554s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15297 LIMIT 2 [ RunTime:0.042571s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15297 ORDER BY `minOrder` ASC [ RunTime:0.019063s ]
select * from pdf where partno='19323-0013' and brandshort='MOLEX' limit 1 [ RunTime:0.010612s ]
select foldpath,foldpath2,filename from pdf_file where id=1116667 limit 1 [ RunTime:0.023604s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '19323-0013' OR `brand` LIKE 'MOLEX%' ) ) LIMIT 1 [ RunTime:0.027283s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15296 LIMIT 4 [ RunTime:0.030575s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15296 ORDER BY `minOrder` ASC [ RunTime:0.013387s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15296 ORDER BY `unit` DESC [ RunTime:0.010496s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15296 LIMIT 2 [ RunTime:0.020898s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15296 ORDER BY `minOrder` ASC [ RunTime:0.002590s ]
select * from pdf where partno='352162KFT' and brandshort='TE CONNECTIVITY' limit 1 [ RunTime:0.008544s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '352162KFT' OR `brand` LIKE 'TE CONNECTIVITY%' ) ) LIMIT 1 [ RunTime:0.047494s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15295 LIMIT 4 [ RunTime:0.007265s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15295 ORDER BY `minOrder` ASC [ RunTime:0.012502s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15295 ORDER BY `unit` DESC [ RunTime:0.012945s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15295 LIMIT 2 [ RunTime:0.013194s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15295 ORDER BY `minOrder` ASC [ RunTime:0.003459s ]
select * from pdf where partno='ACPL-227-560E' and brandshort='BROADCOM' limit 1 [ RunTime:0.017550s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ACPL-227-560E' OR `brand` LIKE 'BROADCOM%' ) ) LIMIT 1 [ RunTime:0.014908s ]
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.008746s ]