SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002149s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000851s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002045s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.79' ) [ RunTime:0.000299s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001068s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000233s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000271s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.018906s ]
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.005220s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001548s ]
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.003109s ]
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 100,20 [ RunTime:0.016847s ]
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 ('16154','16153','16152','16151','16150','16149','16148','16147','16146','16145','16144','16143','16142','16141','16140','16139','16138','16137','16136','16135') ORDER BY FIELD(s.id, 16154,16153,16152,16151,16150,16149,16148,16147,16146,16145,16144,16143,16142,16141,16140,16139,16138,16137,16136,16135) [ RunTime:0.003498s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001931s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16154 LIMIT 4 [ RunTime:0.006163s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001063s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16154 ORDER BY `minOrder` ASC [ RunTime:0.004132s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.008740s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16154 ORDER BY `unit` DESC [ RunTime:0.010545s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002219s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16154 LIMIT 2 [ RunTime:0.003640s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16154 ORDER BY `minOrder` ASC [ RunTime:0.010612s ]
select * from pdf where partno='172264-3004' and brandshort='MOLEX' limit 1 [ RunTime:0.037666s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001626s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '172264-3004' OR `brand` LIKE 'MOLEX%' ) ) LIMIT 1 [ RunTime:0.023107s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16153 LIMIT 4 [ RunTime:0.022455s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16153 ORDER BY `minOrder` ASC [ RunTime:0.004615s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16153 ORDER BY `unit` DESC [ RunTime:0.000784s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16153 LIMIT 2 [ RunTime:0.000405s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16153 ORDER BY `minOrder` ASC [ RunTime:0.002844s ]
select * from pdf where partno='182655-1' and brandshort='AMP - TE CONNECTIVITY' limit 1 [ RunTime:0.002272s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '182655-1' OR `brand` LIKE 'AMP - TE CONNECTIVITY%' ) ) LIMIT 1 [ RunTime:0.005832s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16152 LIMIT 4 [ RunTime:0.002919s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16152 ORDER BY `minOrder` ASC [ RunTime:0.004880s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16152 ORDER BY `unit` DESC [ RunTime:0.014624s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16152 LIMIT 2 [ RunTime:0.011247s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16152 ORDER BY `minOrder` ASC [ RunTime:0.008167s ]
select * from pdf where partno='GRM31CR60J227ME11L' and brandshort='MURATA' limit 1 [ RunTime:0.008691s ]
select foldpath,foldpath2,filename from pdf_file where id=2125015 limit 1 [ RunTime:0.006777s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'GRM31CR60J227ME11L' OR `brand` LIKE 'MURATA%' ) ) LIMIT 1 [ RunTime:0.030864s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16151 LIMIT 4 [ RunTime:0.011481s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16151 ORDER BY `minOrder` ASC [ RunTime:0.015164s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16151 ORDER BY `unit` DESC [ RunTime:0.027691s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16151 LIMIT 2 [ RunTime:0.004978s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16151 ORDER BY `minOrder` ASC [ RunTime:0.000412s ]
select * from pdf where partno='STM32F765VIT6' and brandshort='STMICROELECTRONICS' limit 1 [ RunTime:0.004782s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'STM32F765VIT6' OR `brand` LIKE 'STMICROELECTRONICS%' ) ) LIMIT 1 [ RunTime:0.002056s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16150 LIMIT 4 [ RunTime:0.005051s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16150 ORDER BY `minOrder` ASC [ RunTime:0.010208s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16150 ORDER BY `unit` DESC [ RunTime:0.007807s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16150 LIMIT 2 [ RunTime:0.003740s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16150 ORDER BY `minOrder` ASC [ RunTime:0.017150s ]
select * from pdf where partno='13627267' and brandshort='APTIV / DELPHI' limit 1 [ RunTime:0.011972s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '13627267' OR `brand` LIKE 'APTIV / DELPHI%' ) ) LIMIT 1 [ RunTime:0.010415s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16149 LIMIT 4 [ RunTime:0.011994s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16149 ORDER BY `minOrder` ASC [ RunTime:0.001461s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16149 ORDER BY `unit` DESC [ RunTime:0.001947s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16149 LIMIT 2 [ RunTime:0.000413s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16149 ORDER BY `minOrder` ASC [ RunTime:0.003570s ]
select * from pdf where partno='STPS160U' and brandshort='STMICROELECTRONICS' limit 1 [ RunTime:0.002461s ]
select foldpath,foldpath2,filename from pdf_file where id=419620 limit 1 [ RunTime:0.000404s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'STPS160U' OR `brand` LIKE 'STMICROELECTRONICS%' ) ) LIMIT 1 [ RunTime:0.000541s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16148 LIMIT 4 [ RunTime:0.008253s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16148 ORDER BY `minOrder` ASC [ RunTime:0.011279s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16148 ORDER BY `unit` DESC [ RunTime:0.006697s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16148 LIMIT 2 [ RunTime:0.006320s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16148 ORDER BY `minOrder` ASC [ RunTime:0.002376s ]
select * from pdf where partno='CAT16-49R9F4LF' and brandshort='BOURNS' limit 1 [ RunTime:0.021641s ]
select foldpath,foldpath2,filename from pdf_file where id=653872 limit 1 [ RunTime:0.023567s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CAT16-49R9F4LF' OR `brand` LIKE 'BOURNS%' ) ) LIMIT 1 [ RunTime:0.015943s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16147 LIMIT 4 [ RunTime:0.003195s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16147 ORDER BY `minOrder` ASC [ RunTime:0.005321s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16147 ORDER BY `unit` DESC [ RunTime:0.000684s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16147 LIMIT 2 [ RunTime:0.015517s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16147 ORDER BY `minOrder` ASC [ RunTime:0.011728s ]
select * from pdf where partno='CRCW060314K0FKEA' and brandshort='VISHAY' limit 1 [ RunTime:0.031935s ]
select foldpath,foldpath2,filename from pdf_file where id=1523774 limit 1 [ RunTime:0.007273s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CRCW060314K0FKEA' OR `brand` LIKE 'VISHAY%' ) ) LIMIT 1 [ RunTime:0.042094s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16146 LIMIT 4 [ RunTime:0.013245s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16146 ORDER BY `minOrder` ASC [ RunTime:0.015750s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16146 ORDER BY `unit` DESC [ RunTime:0.004889s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16146 LIMIT 2 [ RunTime:0.000461s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16146 ORDER BY `minOrder` ASC [ RunTime:0.000741s ]
select * from pdf where partno='72968' and brandshort='POMONA' limit 1 [ RunTime:0.007117s ]
select foldpath,foldpath2,filename from pdf_file where id=772847 limit 1 [ RunTime:0.002197s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '72968' OR `brand` LIKE 'POMONA%' ) ) LIMIT 1 [ RunTime:0.005812s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16145 LIMIT 4 [ RunTime:0.011435s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16145 ORDER BY `minOrder` ASC [ RunTime:0.000480s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16145 ORDER BY `unit` DESC [ RunTime:0.000770s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16145 LIMIT 2 [ RunTime:0.000485s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16145 ORDER BY `minOrder` ASC [ RunTime:0.004414s ]
select * from pdf where partno='83500000005' and brandshort='LITTELFUSE' limit 1 [ RunTime:0.005629s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '83500000005' OR `brand` LIKE 'LITTELFUSE%' ) ) LIMIT 1 [ RunTime:0.010585s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16144 LIMIT 4 [ RunTime:0.012119s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16144 ORDER BY `minOrder` ASC [ RunTime:0.033042s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16144 ORDER BY `unit` DESC [ RunTime:0.003379s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16144 LIMIT 2 [ RunTime:0.006267s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16144 ORDER BY `minOrder` ASC [ RunTime:0.014539s ]
select * from pdf where partno='MCWR06X4991FTL' and brandshort='MULTICOMP PRO' limit 1 [ RunTime:0.012400s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MCWR06X4991FTL' OR `brand` LIKE 'MULTICOMP PRO%' ) ) LIMIT 1 [ RunTime:0.022039s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16143 LIMIT 4 [ RunTime:0.009265s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16143 ORDER BY `minOrder` ASC [ RunTime:0.011487s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16143 ORDER BY `unit` DESC [ RunTime:0.011029s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16143 LIMIT 2 [ RunTime:0.010738s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16143 ORDER BY `minOrder` ASC [ RunTime:0.008266s ]
select * from pdf where partno='61302511121' and brandshort='WURTH ELEKTRONIK' limit 1 [ RunTime:0.018769s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '61302511121' OR `brand` LIKE 'WURTH ELEKTRONIK%' ) ) LIMIT 1 [ RunTime:0.005305s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16142 LIMIT 4 [ RunTime:0.003931s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16142 ORDER BY `minOrder` ASC [ RunTime:0.012611s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16142 ORDER BY `unit` DESC [ RunTime:0.018166s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16142 LIMIT 2 [ RunTime:0.017991s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16142 ORDER BY `minOrder` ASC [ RunTime:0.017718s ]
select * from pdf where partno='AFBR-1624Z' and brandshort='BROADCOM' limit 1 [ RunTime:0.008541s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'AFBR-1624Z' OR `brand` LIKE 'BROADCOM%' ) ) LIMIT 1 [ RunTime:0.007094s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16141 LIMIT 4 [ RunTime:0.004132s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16141 ORDER BY `minOrder` ASC [ RunTime:0.010995s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16141 ORDER BY `unit` DESC [ RunTime:0.003627s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16141 LIMIT 2 [ RunTime:0.005266s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16141 ORDER BY `minOrder` ASC [ RunTime:0.000337s ]
select * from pdf where partno='BTS70082EPZXUMA1' and brandshort='INFINEON' limit 1 [ RunTime:0.022041s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BTS70082EPZXUMA1' OR `brand` LIKE 'INFINEON%' ) ) LIMIT 1 [ RunTime:0.021861s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16140 LIMIT 4 [ RunTime:0.012177s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16140 ORDER BY `minOrder` ASC [ RunTime:0.005475s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16140 ORDER BY `unit` DESC [ RunTime:0.002542s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16140 LIMIT 2 [ RunTime:0.009338s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16140 ORDER BY `minOrder` ASC [ RunTime:0.004518s ]
select * from pdf where partno='T491D226K025AT' and brandshort='KEMET' limit 1 [ RunTime:0.010930s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'T491D226K025AT' OR `brand` LIKE 'KEMET%' ) ) LIMIT 1 [ RunTime:0.008878s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16139 LIMIT 4 [ RunTime:0.005914s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16139 ORDER BY `minOrder` ASC [ RunTime:0.004362s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16139 ORDER BY `unit` DESC [ RunTime:0.004998s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16139 LIMIT 2 [ RunTime:0.012719s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16139 ORDER BY `minOrder` ASC [ RunTime:0.004450s ]
select * from pdf where partno='NTCLE213E3103FLB0' and brandshort='VISHAY' limit 1 [ RunTime:0.013902s ]
select foldpath,foldpath2,filename from pdf_file where id=1923427 limit 1 [ RunTime:0.007961s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'NTCLE213E3103FLB0' OR `brand` LIKE 'VISHAY%' ) ) LIMIT 1 [ RunTime:0.020985s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16138 LIMIT 4 [ RunTime:0.012933s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16138 ORDER BY `minOrder` ASC [ RunTime:0.017656s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16138 ORDER BY `unit` DESC [ RunTime:0.012292s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16138 LIMIT 2 [ RunTime:0.002430s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16138 ORDER BY `minOrder` ASC [ RunTime:0.003762s ]
select * from pdf where partno='10090769-P264ALF' and brandshort='AMPHENOL COMMUNICATIONS SOLUTIONS' limit 1 [ RunTime:0.004515s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10090769-P264ALF' OR `brand` LIKE 'AMPHENOL COMMUNICATIONS SOLUTIONS%' ) ) LIMIT 1 [ RunTime:0.028976s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16137 LIMIT 4 [ RunTime:0.018280s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16137 ORDER BY `minOrder` ASC [ RunTime:0.003541s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16137 ORDER BY `unit` DESC [ RunTime:0.013816s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16137 LIMIT 2 [ RunTime:0.003496s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16137 ORDER BY `minOrder` ASC [ RunTime:0.016363s ]
select * from pdf where partno='R6076ENZ1C9' and brandshort='ROHM' limit 1 [ RunTime:0.002522s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'R6076ENZ1C9' OR `brand` LIKE 'ROHM%' ) ) LIMIT 1 [ RunTime:0.009917s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16136 LIMIT 4 [ RunTime:0.005672s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16136 ORDER BY `minOrder` ASC [ RunTime:0.010380s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16136 ORDER BY `unit` DESC [ RunTime:0.017060s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16136 LIMIT 2 [ RunTime:0.003547s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16136 ORDER BY `minOrder` ASC [ RunTime:0.007772s ]
select * from pdf where partno='SMMBT3906WT1G' and brandshort='ONSEMI' limit 1 [ RunTime:0.016331s ]
select foldpath,foldpath2,filename from pdf_file where id=2084460 limit 1 [ RunTime:0.003689s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMMBT3906WT1G' OR `brand` LIKE 'ONSEMI%' ) ) LIMIT 1 [ RunTime:0.013800s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16135 LIMIT 4 [ RunTime:0.003093s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16135 ORDER BY `minOrder` ASC [ RunTime:0.000578s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16135 ORDER BY `unit` DESC [ RunTime:0.006014s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16135 LIMIT 2 [ RunTime:0.000583s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16135 ORDER BY `minOrder` ASC [ RunTime:0.002648s ]
select * from pdf where partno='DTC114YUBHZGTL' and brandshort='ROHM' limit 1 [ RunTime:0.010985s ]
select foldpath,foldpath2,filename from pdf_file where id=1681654 limit 1 [ RunTime:0.000660s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'DTC114YUBHZGTL' OR `brand` LIKE 'ROHM%' ) ) LIMIT 1 [ RunTime:0.004275s ]
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.003457s ]