SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001610s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000651s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001665s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.113' ) [ RunTime:0.008578s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001734s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.002539s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.001153s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.007343s ]
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.001066s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001352s ]
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.006571s ]
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.008279s ]
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.009734s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001200s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16154 LIMIT 4 [ RunTime:0.012946s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.006132s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16154 ORDER BY `minOrder` ASC [ RunTime:0.011202s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001659s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16154 ORDER BY `unit` DESC [ RunTime:0.008042s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002387s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16154 LIMIT 2 [ RunTime:0.016257s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16154 ORDER BY `minOrder` ASC [ RunTime:0.007929s ]
select * from pdf where partno='172264-3004' and brandshort='MOLEX' limit 1 [ RunTime:0.011366s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001734s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '172264-3004' OR `brand` LIKE 'MOLEX%' ) ) LIMIT 1 [ RunTime:0.015923s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16153 LIMIT 4 [ RunTime:0.005052s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16153 ORDER BY `minOrder` ASC [ RunTime:0.004696s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16153 ORDER BY `unit` DESC [ RunTime:0.002349s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16153 LIMIT 2 [ RunTime:0.002858s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16153 ORDER BY `minOrder` ASC [ RunTime:0.003680s ]
select * from pdf where partno='182655-1' and brandshort='AMP - TE CONNECTIVITY' limit 1 [ RunTime:0.002197s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '182655-1' OR `brand` LIKE 'AMP - TE CONNECTIVITY%' ) ) LIMIT 1 [ RunTime:0.003721s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16152 LIMIT 4 [ RunTime:0.020483s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16152 ORDER BY `minOrder` ASC [ RunTime:0.031425s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16152 ORDER BY `unit` DESC [ RunTime:0.010141s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16152 LIMIT 2 [ RunTime:0.017008s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16152 ORDER BY `minOrder` ASC [ RunTime:0.007822s ]
select * from pdf where partno='GRM31CR60J227ME11L' and brandshort='MURATA' limit 1 [ RunTime:0.009971s ]
select foldpath,foldpath2,filename from pdf_file where id=2125015 limit 1 [ RunTime:0.010224s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'GRM31CR60J227ME11L' OR `brand` LIKE 'MURATA%' ) ) LIMIT 1 [ RunTime:0.013811s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16151 LIMIT 4 [ RunTime:0.009616s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16151 ORDER BY `minOrder` ASC [ RunTime:0.000894s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16151 ORDER BY `unit` DESC [ RunTime:0.009749s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16151 LIMIT 2 [ RunTime:0.013371s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16151 ORDER BY `minOrder` ASC [ RunTime:0.003959s ]
select * from pdf where partno='STM32F765VIT6' and brandshort='STMICROELECTRONICS' limit 1 [ RunTime:0.015236s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'STM32F765VIT6' OR `brand` LIKE 'STMICROELECTRONICS%' ) ) LIMIT 1 [ RunTime:0.014419s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16150 LIMIT 4 [ RunTime:0.007584s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16150 ORDER BY `minOrder` ASC [ RunTime:0.006447s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16150 ORDER BY `unit` DESC [ RunTime:0.010140s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16150 LIMIT 2 [ RunTime:0.015169s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16150 ORDER BY `minOrder` ASC [ RunTime:0.006305s ]
select * from pdf where partno='13627267' and brandshort='APTIV / DELPHI' limit 1 [ RunTime:0.004743s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '13627267' OR `brand` LIKE 'APTIV / DELPHI%' ) ) LIMIT 1 [ RunTime:0.015219s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16149 LIMIT 4 [ RunTime:0.005591s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16149 ORDER BY `minOrder` ASC [ RunTime:0.005581s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16149 ORDER BY `unit` DESC [ RunTime:0.004694s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16149 LIMIT 2 [ RunTime:0.005283s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16149 ORDER BY `minOrder` ASC [ RunTime:0.004793s ]
select * from pdf where partno='STPS160U' and brandshort='STMICROELECTRONICS' limit 1 [ RunTime:0.007320s ]
select foldpath,foldpath2,filename from pdf_file where id=419620 limit 1 [ RunTime:0.006013s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'STPS160U' OR `brand` LIKE 'STMICROELECTRONICS%' ) ) LIMIT 1 [ RunTime:0.030480s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16148 LIMIT 4 [ RunTime:0.015040s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16148 ORDER BY `minOrder` ASC [ RunTime:0.008964s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16148 ORDER BY `unit` DESC [ RunTime:0.010366s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16148 LIMIT 2 [ RunTime:0.017370s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16148 ORDER BY `minOrder` ASC [ RunTime:0.020668s ]
select * from pdf where partno='CAT16-49R9F4LF' and brandshort='BOURNS' limit 1 [ RunTime:0.014704s ]
select foldpath,foldpath2,filename from pdf_file where id=653872 limit 1 [ RunTime:0.005897s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CAT16-49R9F4LF' OR `brand` LIKE 'BOURNS%' ) ) LIMIT 1 [ RunTime:0.031011s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16147 LIMIT 4 [ RunTime:0.013706s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16147 ORDER BY `minOrder` ASC [ RunTime:0.008987s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16147 ORDER BY `unit` DESC [ RunTime:0.011379s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16147 LIMIT 2 [ RunTime:0.006604s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16147 ORDER BY `minOrder` ASC [ RunTime:0.006777s ]
select * from pdf where partno='CRCW060314K0FKEA' and brandshort='VISHAY' limit 1 [ RunTime:0.012115s ]
select foldpath,foldpath2,filename from pdf_file where id=1523774 limit 1 [ RunTime:0.005595s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CRCW060314K0FKEA' OR `brand` LIKE 'VISHAY%' ) ) LIMIT 1 [ RunTime:0.031202s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16146 LIMIT 4 [ RunTime:0.010639s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16146 ORDER BY `minOrder` ASC [ RunTime:0.003763s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16146 ORDER BY `unit` DESC [ RunTime:0.016538s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16146 LIMIT 2 [ RunTime:0.012558s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16146 ORDER BY `minOrder` ASC [ RunTime:0.018128s ]
select * from pdf where partno='72968' and brandshort='POMONA' limit 1 [ RunTime:0.007680s ]
select foldpath,foldpath2,filename from pdf_file where id=772847 limit 1 [ RunTime:0.009649s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '72968' OR `brand` LIKE 'POMONA%' ) ) LIMIT 1 [ RunTime:0.009275s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16145 LIMIT 4 [ RunTime:0.011380s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16145 ORDER BY `minOrder` ASC [ RunTime:0.036875s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16145 ORDER BY `unit` DESC [ RunTime:0.015030s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16145 LIMIT 2 [ RunTime:0.014920s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16145 ORDER BY `minOrder` ASC [ RunTime:0.029885s ]
select * from pdf where partno='83500000005' and brandshort='LITTELFUSE' limit 1 [ RunTime:0.043773s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '83500000005' OR `brand` LIKE 'LITTELFUSE%' ) ) LIMIT 1 [ RunTime:0.032093s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16144 LIMIT 4 [ RunTime:0.021403s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16144 ORDER BY `minOrder` ASC [ RunTime:0.024065s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16144 ORDER BY `unit` DESC [ RunTime:0.024537s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16144 LIMIT 2 [ RunTime:0.015207s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16144 ORDER BY `minOrder` ASC [ RunTime:0.016109s ]
select * from pdf where partno='MCWR06X4991FTL' and brandshort='MULTICOMP PRO' limit 1 [ RunTime:0.008259s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MCWR06X4991FTL' OR `brand` LIKE 'MULTICOMP PRO%' ) ) LIMIT 1 [ RunTime:0.038420s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16143 LIMIT 4 [ RunTime:0.009274s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16143 ORDER BY `minOrder` ASC [ RunTime:0.015543s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16143 ORDER BY `unit` DESC [ RunTime:0.001220s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16143 LIMIT 2 [ RunTime:0.002376s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16143 ORDER BY `minOrder` ASC [ RunTime:0.007806s ]
select * from pdf where partno='61302511121' and brandshort='WURTH ELEKTRONIK' limit 1 [ RunTime:0.013076s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '61302511121' OR `brand` LIKE 'WURTH ELEKTRONIK%' ) ) LIMIT 1 [ RunTime:0.023056s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16142 LIMIT 4 [ RunTime:0.004427s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16142 ORDER BY `minOrder` ASC [ RunTime:0.008683s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16142 ORDER BY `unit` DESC [ RunTime:0.030317s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16142 LIMIT 2 [ RunTime:0.018474s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16142 ORDER BY `minOrder` ASC [ RunTime:0.005576s ]
select * from pdf where partno='AFBR-1624Z' and brandshort='BROADCOM' limit 1 [ RunTime:0.013584s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'AFBR-1624Z' OR `brand` LIKE 'BROADCOM%' ) ) LIMIT 1 [ RunTime:0.020366s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16141 LIMIT 4 [ RunTime:0.020086s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16141 ORDER BY `minOrder` ASC [ RunTime:0.010370s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16141 ORDER BY `unit` DESC [ RunTime:0.002860s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16141 LIMIT 2 [ RunTime:0.000517s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16141 ORDER BY `minOrder` ASC [ RunTime:0.000418s ]
select * from pdf where partno='BTS70082EPZXUMA1' and brandshort='INFINEON' limit 1 [ RunTime:0.001300s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BTS70082EPZXUMA1' OR `brand` LIKE 'INFINEON%' ) ) LIMIT 1 [ RunTime:0.000440s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16140 LIMIT 4 [ RunTime:0.006569s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16140 ORDER BY `minOrder` ASC [ RunTime:0.013390s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16140 ORDER BY `unit` DESC [ RunTime:0.022153s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16140 LIMIT 2 [ RunTime:0.006135s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16140 ORDER BY `minOrder` ASC [ RunTime:0.015829s ]
select * from pdf where partno='T491D226K025AT' and brandshort='KEMET' limit 1 [ RunTime:0.032161s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'T491D226K025AT' OR `brand` LIKE 'KEMET%' ) ) LIMIT 1 [ RunTime:0.011973s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16139 LIMIT 4 [ RunTime:0.014379s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16139 ORDER BY `minOrder` ASC [ RunTime:0.014128s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16139 ORDER BY `unit` DESC [ RunTime:0.020649s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16139 LIMIT 2 [ RunTime:0.005495s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16139 ORDER BY `minOrder` ASC [ RunTime:0.005570s ]
select * from pdf where partno='NTCLE213E3103FLB0' and brandshort='VISHAY' limit 1 [ RunTime:0.007614s ]
select foldpath,foldpath2,filename from pdf_file where id=1923427 limit 1 [ RunTime:0.018322s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'NTCLE213E3103FLB0' OR `brand` LIKE 'VISHAY%' ) ) LIMIT 1 [ RunTime:0.026628s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16138 LIMIT 4 [ RunTime:0.017315s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16138 ORDER BY `minOrder` ASC [ RunTime:0.020848s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16138 ORDER BY `unit` DESC [ RunTime:0.010726s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16138 LIMIT 2 [ RunTime:0.015704s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16138 ORDER BY `minOrder` ASC [ RunTime:0.032781s ]
select * from pdf where partno='10090769-P264ALF' and brandshort='AMPHENOL COMMUNICATIONS SOLUTIONS' limit 1 [ RunTime:0.017800s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10090769-P264ALF' OR `brand` LIKE 'AMPHENOL COMMUNICATIONS SOLUTIONS%' ) ) LIMIT 1 [ RunTime:0.013318s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16137 LIMIT 4 [ RunTime:0.009946s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16137 ORDER BY `minOrder` ASC [ RunTime:0.006374s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16137 ORDER BY `unit` DESC [ RunTime:0.009635s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16137 LIMIT 2 [ RunTime:0.006870s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16137 ORDER BY `minOrder` ASC [ RunTime:0.005995s ]
select * from pdf where partno='R6076ENZ1C9' and brandshort='ROHM' limit 1 [ RunTime:0.000889s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'R6076ENZ1C9' OR `brand` LIKE 'ROHM%' ) ) LIMIT 1 [ RunTime:0.008306s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16136 LIMIT 4 [ RunTime:0.006753s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16136 ORDER BY `minOrder` ASC [ RunTime:0.022556s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16136 ORDER BY `unit` DESC [ RunTime:0.016037s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16136 LIMIT 2 [ RunTime:0.040884s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16136 ORDER BY `minOrder` ASC [ RunTime:0.001075s ]
select * from pdf where partno='SMMBT3906WT1G' and brandshort='ONSEMI' limit 1 [ RunTime:0.017483s ]
select foldpath,foldpath2,filename from pdf_file where id=2084460 limit 1 [ RunTime:0.016938s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMMBT3906WT1G' OR `brand` LIKE 'ONSEMI%' ) ) LIMIT 1 [ RunTime:0.029368s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16135 LIMIT 4 [ RunTime:0.017555s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16135 ORDER BY `minOrder` ASC [ RunTime:0.011095s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16135 ORDER BY `unit` DESC [ RunTime:0.013389s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16135 LIMIT 2 [ RunTime:0.016941s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16135 ORDER BY `minOrder` ASC [ RunTime:0.007866s ]
select * from pdf where partno='DTC114YUBHZGTL' and brandshort='ROHM' limit 1 [ RunTime:0.010670s ]
select foldpath,foldpath2,filename from pdf_file where id=1681654 limit 1 [ RunTime:0.008118s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'DTC114YUBHZGTL' OR `brand` LIKE 'ROHM%' ) ) LIMIT 1 [ RunTime:0.009799s ]
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.007760s ]