SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001360s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000582s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001969s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.79' ) [ RunTime:0.000488s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001803s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000295s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.004249s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.000303s ]
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.010265s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002011s ]
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.000951s ]
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.030520s ]
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.042631s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.003582s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15314 LIMIT 4 [ RunTime:0.040530s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.007775s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15314 ORDER BY `minOrder` ASC [ RunTime:0.025851s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.020265s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15314 ORDER BY `unit` DESC [ RunTime:0.048038s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.004358s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15314 LIMIT 2 [ RunTime:0.020043s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15314 ORDER BY `minOrder` ASC [ RunTime:0.018259s ]
select * from pdf where partno='RP73PF1E2K0BTDF' and brandshort='CGS - TE CONNECTIVITY' limit 1 [ RunTime:0.059518s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002341s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'RP73PF1E2K0BTDF' OR `brand` LIKE 'CGS - TE CONNECTIVITY%' ) ) LIMIT 1 [ RunTime:0.033041s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15313 LIMIT 4 [ RunTime:0.004226s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15313 ORDER BY `minOrder` ASC [ RunTime:0.082152s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15313 ORDER BY `unit` DESC [ RunTime:0.032598s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15313 LIMIT 2 [ RunTime:0.015333s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15313 ORDER BY `minOrder` ASC [ RunTime:0.004289s ]
select * from pdf where partno='TNPW06035K62BEEA' and brandshort='VISHAY' limit 1 [ RunTime:0.045017s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TNPW06035K62BEEA' OR `brand` LIKE 'VISHAY%' ) ) LIMIT 1 [ RunTime:0.082637s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15312 LIMIT 4 [ RunTime:0.018907s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15312 ORDER BY `minOrder` ASC [ RunTime:0.033700s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15312 ORDER BY `unit` DESC [ RunTime:0.013211s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15312 LIMIT 2 [ RunTime:0.049425s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15312 ORDER BY `minOrder` ASC [ RunTime:0.007220s ]
select * from pdf where partno='PMEG4050EP,115.' and brandshort='NEXPERIA' limit 1 [ RunTime:0.024868s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PMEG4050EP,115.' OR `brand` LIKE 'NEXPERIA%' ) ) LIMIT 1 [ RunTime:0.051419s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15311 LIMIT 4 [ RunTime:0.011472s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15311 ORDER BY `minOrder` ASC [ RunTime:0.058975s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15311 ORDER BY `unit` DESC [ RunTime:0.032547s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15311 LIMIT 2 [ RunTime:0.024554s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15311 ORDER BY `minOrder` ASC [ RunTime:0.033618s ]
select * from pdf where partno='FTY.00.250.CTF' and brandshort='LEMO' limit 1 [ RunTime:0.052213s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTY.00.250.CTF' OR `brand` LIKE 'LEMO%' ) ) LIMIT 1 [ RunTime:0.038764s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15310 LIMIT 4 [ RunTime:0.111663s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15310 ORDER BY `minOrder` ASC [ RunTime:0.166168s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15310 ORDER BY `unit` DESC [ RunTime:0.008260s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15310 LIMIT 2 [ RunTime:0.084249s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15310 ORDER BY `minOrder` ASC [ RunTime:0.015882s ]
select * from pdf where partno='FMMT591' and brandshort='DIODES INC.' limit 1 [ RunTime:0.075400s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FMMT591' OR `brand` LIKE 'DIODES INC.%' ) ) LIMIT 1 [ RunTime:0.051906s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15309 LIMIT 4 [ RunTime:0.034801s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15309 ORDER BY `minOrder` ASC [ RunTime:0.040642s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15309 ORDER BY `unit` DESC [ RunTime:0.057810s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15309 LIMIT 2 [ RunTime:0.064909s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15309 ORDER BY `minOrder` ASC [ RunTime:0.034403s ]
select * from pdf where partno='ZXTP2012ZTA' and brandshort='DIODES INC.' limit 1 [ RunTime:0.033527s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ZXTP2012ZTA' OR `brand` LIKE 'DIODES INC.%' ) ) LIMIT 1 [ RunTime:0.051110s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15308 LIMIT 4 [ RunTime:0.043092s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15308 ORDER BY `minOrder` ASC [ RunTime:0.012231s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15308 ORDER BY `unit` DESC [ RunTime:0.026945s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15308 LIMIT 2 [ RunTime:0.017629s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15308 ORDER BY `minOrder` ASC [ RunTime:0.005788s ]
select * from pdf where partno='PEL12T-4225S-S1024-DEL' and brandshort='BOURNS' limit 1 [ RunTime:0.013029s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PEL12T-4225S-S1024-DEL' OR `brand` LIKE 'BOURNS%' ) ) LIMIT 1 [ RunTime:0.010088s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15307 LIMIT 4 [ RunTime:0.042148s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15307 ORDER BY `minOrder` ASC [ RunTime:0.081868s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15307 ORDER BY `unit` DESC [ RunTime:0.031502s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15307 LIMIT 2 [ RunTime:0.107162s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15307 ORDER BY `minOrder` ASC [ RunTime:0.028756s ]
select * from pdf where partno='12061A151JAT2A' and brandshort='KYOCERA AVX' limit 1 [ RunTime:0.021091s ]
select foldpath,foldpath2,filename from pdf_file where id=1976071 limit 1 [ RunTime:0.039827s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '12061A151JAT2A' OR `brand` LIKE 'KYOCERA AVX%' ) ) LIMIT 1 [ RunTime:0.067561s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15306 LIMIT 4 [ RunTime:0.076609s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15306 ORDER BY `minOrder` ASC [ RunTime:0.095011s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15306 ORDER BY `unit` DESC [ RunTime:0.062471s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15306 LIMIT 2 [ RunTime:0.032485s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15306 ORDER BY `minOrder` ASC [ RunTime:0.025271s ]
select * from pdf where partno='PMV27UPER' and brandshort='NEXPERIA' limit 1 [ RunTime:0.067667s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PMV27UPER' OR `brand` LIKE 'NEXPERIA%' ) ) LIMIT 1 [ RunTime:0.034662s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15305 LIMIT 4 [ RunTime:0.013374s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15305 ORDER BY `minOrder` ASC [ RunTime:0.013928s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15305 ORDER BY `unit` DESC [ RunTime:0.024832s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15305 LIMIT 2 [ RunTime:0.011254s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15305 ORDER BY `minOrder` ASC [ RunTime:0.012844s ]
select * from pdf where partno='IRF9Z24NPBF' and brandshort='INFINEON' limit 1 [ RunTime:0.009029s ]
select foldpath,foldpath2,filename from pdf_file where id=987574 limit 1 [ RunTime:0.013830s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'IRF9Z24NPBF' OR `brand` LIKE 'INFINEON%' ) ) LIMIT 1 [ RunTime:0.004440s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15304 LIMIT 4 [ RunTime:0.010753s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15304 ORDER BY `minOrder` ASC [ RunTime:0.033417s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15304 ORDER BY `unit` DESC [ RunTime:0.038777s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15304 LIMIT 2 [ RunTime:0.027188s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15304 ORDER BY `minOrder` ASC [ RunTime:0.050051s ]
select * from pdf where partno='1582 1UH 2.2A' and brandshort='FERROPERM' limit 1 [ RunTime:0.013293s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1582 1UH 2.2A' OR `brand` LIKE 'FERROPERM%' ) ) LIMIT 1 [ RunTime:0.033844s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15303 LIMIT 4 [ RunTime:0.048987s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15303 ORDER BY `minOrder` ASC [ RunTime:0.079341s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15303 ORDER BY `unit` DESC [ RunTime:0.010986s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15303 LIMIT 2 [ RunTime:0.031797s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15303 ORDER BY `minOrder` ASC [ RunTime:0.007658s ]
select * from pdf where partno='HBL2623' and brandshort='HUBBELL WIRING DEVICES' limit 1 [ RunTime:0.009058s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'HBL2623' OR `brand` LIKE 'HUBBELL WIRING DEVICES%' ) ) LIMIT 1 [ RunTime:0.017808s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15302 LIMIT 4 [ RunTime:0.044795s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15302 ORDER BY `minOrder` ASC [ RunTime:0.014497s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15302 ORDER BY `unit` DESC [ RunTime:0.056318s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15302 LIMIT 2 [ RunTime:0.046308s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15302 ORDER BY `minOrder` ASC [ RunTime:0.021043s ]
select * from pdf where partno='MBR1660-E3/45' and brandshort='VISHAY' limit 1 [ RunTime:0.040237s ]
select foldpath,foldpath2,filename from pdf_file where id=1921777 limit 1 [ RunTime:0.039014s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MBR1660-E3/45' OR `brand` LIKE 'VISHAY%' ) ) LIMIT 1 [ RunTime:0.044716s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15301 LIMIT 4 [ RunTime:0.020918s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15301 ORDER BY `minOrder` ASC [ RunTime:0.109327s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15301 ORDER BY `unit` DESC [ RunTime:0.037286s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15301 LIMIT 2 [ RunTime:0.027445s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15301 ORDER BY `minOrder` ASC [ RunTime:0.041195s ]
select * from pdf where partno='PESD1CAN,215' and brandshort='NEXPERIA' limit 1 [ RunTime:0.075794s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PESD1CAN,215' OR `brand` LIKE 'NEXPERIA%' ) ) LIMIT 1 [ RunTime:0.096465s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15300 LIMIT 4 [ RunTime:0.042489s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15300 ORDER BY `minOrder` ASC [ RunTime:0.010850s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15300 ORDER BY `unit` DESC [ RunTime:0.054656s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15300 LIMIT 2 [ RunTime:0.046798s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15300 ORDER BY `minOrder` ASC [ RunTime:0.004476s ]
select * from pdf where partno='FTS-105-01-F-DV' and brandshort='SAMTEC' limit 1 [ RunTime:0.025700s ]
select foldpath,foldpath2,filename from pdf_file where id=1245244 limit 1 [ RunTime:0.015273s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTS-105-01-F-DV' OR `brand` LIKE 'SAMTEC%' ) ) LIMIT 1 [ RunTime:0.048581s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15299 LIMIT 4 [ RunTime:0.040942s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15299 ORDER BY `minOrder` ASC [ RunTime:0.051800s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15299 ORDER BY `unit` DESC [ RunTime:0.040124s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15299 LIMIT 2 [ RunTime:0.005461s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15299 ORDER BY `minOrder` ASC [ RunTime:0.031856s ]
select * from pdf where partno='TAP156M016CCS' and brandshort='KYOCERA AVX' limit 1 [ RunTime:0.028077s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TAP156M016CCS' OR `brand` LIKE 'KYOCERA AVX%' ) ) LIMIT 1 [ RunTime:0.016904s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15298 LIMIT 4 [ RunTime:0.036160s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15298 ORDER BY `minOrder` ASC [ RunTime:0.036440s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15298 ORDER BY `unit` DESC [ RunTime:0.044894s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15298 LIMIT 2 [ RunTime:0.013060s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15298 ORDER BY `minOrder` ASC [ RunTime:0.002051s ]
select * from pdf where partno='GD300HFY120C6S' and brandshort='STARPOWER' limit 1 [ RunTime:0.044026s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'GD300HFY120C6S' OR `brand` LIKE 'STARPOWER%' ) ) LIMIT 1 [ RunTime:0.033715s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15297 LIMIT 4 [ RunTime:0.036464s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15297 ORDER BY `minOrder` ASC [ RunTime:0.044313s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15297 ORDER BY `unit` DESC [ RunTime:0.027326s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15297 LIMIT 2 [ RunTime:0.034599s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15297 ORDER BY `minOrder` ASC [ RunTime:0.044519s ]
select * from pdf where partno='19323-0013' and brandshort='MOLEX' limit 1 [ RunTime:0.016110s ]
select foldpath,foldpath2,filename from pdf_file where id=1116667 limit 1 [ RunTime:0.048955s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '19323-0013' OR `brand` LIKE 'MOLEX%' ) ) LIMIT 1 [ RunTime:0.058624s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15296 LIMIT 4 [ RunTime:0.028371s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15296 ORDER BY `minOrder` ASC [ RunTime:0.010112s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15296 ORDER BY `unit` DESC [ RunTime:0.027022s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15296 LIMIT 2 [ RunTime:0.040198s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15296 ORDER BY `minOrder` ASC [ RunTime:0.013865s ]
select * from pdf where partno='352162KFT' and brandshort='TE CONNECTIVITY' limit 1 [ RunTime:0.010688s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '352162KFT' OR `brand` LIKE 'TE CONNECTIVITY%' ) ) LIMIT 1 [ RunTime:0.043300s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15295 LIMIT 4 [ RunTime:0.017785s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15295 ORDER BY `minOrder` ASC [ RunTime:0.008358s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15295 ORDER BY `unit` DESC [ RunTime:0.013011s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15295 LIMIT 2 [ RunTime:0.013863s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15295 ORDER BY `minOrder` ASC [ RunTime:0.005633s ]
select * from pdf where partno='ACPL-227-560E' and brandshort='BROADCOM' limit 1 [ RunTime:0.057921s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ACPL-227-560E' OR `brand` LIKE 'BROADCOM%' ) ) LIMIT 1 [ RunTime:0.020103s ]
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.016255s ]