SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001217s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000480s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002676s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.0' ) [ RunTime:0.000394s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002053s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000357s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.008123s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.006466s ]
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.000504s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002582s ]
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.003492s ]
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.025965s ]
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.039175s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.013168s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16154 LIMIT 4 [ RunTime:0.016521s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.012631s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16154 ORDER BY `minOrder` ASC [ RunTime:0.014556s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.005923s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16154 ORDER BY `unit` DESC [ RunTime:0.009036s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.012002s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16154 LIMIT 2 [ RunTime:0.007944s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16154 ORDER BY `minOrder` ASC [ RunTime:0.000434s ]
select * from pdf where partno='172264-3004' and brandshort='MOLEX' limit 1 [ RunTime:0.012854s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002484s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '172264-3004' OR `brand` LIKE 'MOLEX%' ) ) LIMIT 1 [ RunTime:0.026317s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16153 LIMIT 4 [ RunTime:0.025248s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16153 ORDER BY `minOrder` ASC [ RunTime:0.004867s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16153 ORDER BY `unit` DESC [ RunTime:0.014841s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16153 LIMIT 2 [ RunTime:0.064731s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16153 ORDER BY `minOrder` ASC [ RunTime:0.014041s ]
select * from pdf where partno='182655-1' and brandshort='AMP - TE CONNECTIVITY' limit 1 [ RunTime:0.014505s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '182655-1' OR `brand` LIKE 'AMP - TE CONNECTIVITY%' ) ) LIMIT 1 [ RunTime:0.054893s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16152 LIMIT 4 [ RunTime:0.067317s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16152 ORDER BY `minOrder` ASC [ RunTime:0.053319s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16152 ORDER BY `unit` DESC [ RunTime:0.027565s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16152 LIMIT 2 [ RunTime:0.015295s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16152 ORDER BY `minOrder` ASC [ RunTime:0.028136s ]
select * from pdf where partno='GRM31CR60J227ME11L' and brandshort='MURATA' limit 1 [ RunTime:0.015741s ]
select foldpath,foldpath2,filename from pdf_file where id=2125015 limit 1 [ RunTime:0.022595s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'GRM31CR60J227ME11L' OR `brand` LIKE 'MURATA%' ) ) LIMIT 1 [ RunTime:0.011709s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16151 LIMIT 4 [ RunTime:0.003820s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16151 ORDER BY `minOrder` ASC [ RunTime:0.012588s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16151 ORDER BY `unit` DESC [ RunTime:0.020702s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16151 LIMIT 2 [ RunTime:0.010815s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16151 ORDER BY `minOrder` ASC [ RunTime:0.008419s ]
select * from pdf where partno='STM32F765VIT6' and brandshort='STMICROELECTRONICS' limit 1 [ RunTime:0.006444s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'STM32F765VIT6' OR `brand` LIKE 'STMICROELECTRONICS%' ) ) LIMIT 1 [ RunTime:0.010303s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16150 LIMIT 4 [ RunTime:0.009755s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16150 ORDER BY `minOrder` ASC [ RunTime:0.020722s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16150 ORDER BY `unit` DESC [ RunTime:0.012173s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16150 LIMIT 2 [ RunTime:0.018581s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16150 ORDER BY `minOrder` ASC [ RunTime:0.007080s ]
select * from pdf where partno='13627267' and brandshort='APTIV / DELPHI' limit 1 [ RunTime:0.020527s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '13627267' OR `brand` LIKE 'APTIV / DELPHI%' ) ) LIMIT 1 [ RunTime:0.020885s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16149 LIMIT 4 [ RunTime:0.008457s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16149 ORDER BY `minOrder` ASC [ RunTime:0.018742s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16149 ORDER BY `unit` DESC [ RunTime:0.053174s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16149 LIMIT 2 [ RunTime:0.016020s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16149 ORDER BY `minOrder` ASC [ RunTime:0.004559s ]
select * from pdf where partno='STPS160U' and brandshort='STMICROELECTRONICS' limit 1 [ RunTime:0.020918s ]
select foldpath,foldpath2,filename from pdf_file where id=419620 limit 1 [ RunTime:0.021606s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'STPS160U' OR `brand` LIKE 'STMICROELECTRONICS%' ) ) LIMIT 1 [ RunTime:0.051848s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16148 LIMIT 4 [ RunTime:0.019112s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16148 ORDER BY `minOrder` ASC [ RunTime:0.042831s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16148 ORDER BY `unit` DESC [ RunTime:0.027607s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16148 LIMIT 2 [ RunTime:0.023097s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16148 ORDER BY `minOrder` ASC [ RunTime:0.016608s ]
select * from pdf where partno='CAT16-49R9F4LF' and brandshort='BOURNS' limit 1 [ RunTime:0.023951s ]
select foldpath,foldpath2,filename from pdf_file where id=653872 limit 1 [ RunTime:0.032578s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CAT16-49R9F4LF' OR `brand` LIKE 'BOURNS%' ) ) LIMIT 1 [ RunTime:0.028096s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16147 LIMIT 4 [ RunTime:0.028410s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16147 ORDER BY `minOrder` ASC [ RunTime:0.031543s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16147 ORDER BY `unit` DESC [ RunTime:0.023328s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16147 LIMIT 2 [ RunTime:0.061667s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16147 ORDER BY `minOrder` ASC [ RunTime:0.020621s ]
select * from pdf where partno='CRCW060314K0FKEA' and brandshort='VISHAY' limit 1 [ RunTime:0.040473s ]
select foldpath,foldpath2,filename from pdf_file where id=1523774 limit 1 [ RunTime:0.044055s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CRCW060314K0FKEA' OR `brand` LIKE 'VISHAY%' ) ) LIMIT 1 [ RunTime:0.045174s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16146 LIMIT 4 [ RunTime:0.046042s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16146 ORDER BY `minOrder` ASC [ RunTime:0.088473s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16146 ORDER BY `unit` DESC [ RunTime:0.016196s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16146 LIMIT 2 [ RunTime:0.137267s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16146 ORDER BY `minOrder` ASC [ RunTime:0.050839s ]
select * from pdf where partno='72968' and brandshort='POMONA' limit 1 [ RunTime:0.074636s ]
select foldpath,foldpath2,filename from pdf_file where id=772847 limit 1 [ RunTime:0.175432s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '72968' OR `brand` LIKE 'POMONA%' ) ) LIMIT 1 [ RunTime:0.121834s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16145 LIMIT 4 [ RunTime:0.069380s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16145 ORDER BY `minOrder` ASC [ RunTime:0.062298s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16145 ORDER BY `unit` DESC [ RunTime:0.068910s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16145 LIMIT 2 [ RunTime:0.058843s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16145 ORDER BY `minOrder` ASC [ RunTime:0.027699s ]
select * from pdf where partno='83500000005' and brandshort='LITTELFUSE' limit 1 [ RunTime:0.044621s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '83500000005' OR `brand` LIKE 'LITTELFUSE%' ) ) LIMIT 1 [ RunTime:0.042024s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16144 LIMIT 4 [ RunTime:0.020461s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16144 ORDER BY `minOrder` ASC [ RunTime:0.031344s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16144 ORDER BY `unit` DESC [ RunTime:0.011593s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16144 LIMIT 2 [ RunTime:0.051561s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16144 ORDER BY `minOrder` ASC [ RunTime:0.001757s ]
select * from pdf where partno='MCWR06X4991FTL' and brandshort='MULTICOMP PRO' limit 1 [ RunTime:0.016449s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MCWR06X4991FTL' OR `brand` LIKE 'MULTICOMP PRO%' ) ) LIMIT 1 [ RunTime:0.023396s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16143 LIMIT 4 [ RunTime:0.046801s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16143 ORDER BY `minOrder` ASC [ RunTime:0.030942s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16143 ORDER BY `unit` DESC [ RunTime:0.039833s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16143 LIMIT 2 [ RunTime:0.046908s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16143 ORDER BY `minOrder` ASC [ RunTime:0.002647s ]
select * from pdf where partno='61302511121' and brandshort='WURTH ELEKTRONIK' limit 1 [ RunTime:0.029627s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '61302511121' OR `brand` LIKE 'WURTH ELEKTRONIK%' ) ) LIMIT 1 [ RunTime:0.051966s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16142 LIMIT 4 [ RunTime:0.071920s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16142 ORDER BY `minOrder` ASC [ RunTime:0.016610s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16142 ORDER BY `unit` DESC [ RunTime:0.077711s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16142 LIMIT 2 [ RunTime:0.053229s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16142 ORDER BY `minOrder` ASC [ RunTime:0.028972s ]
select * from pdf where partno='AFBR-1624Z' and brandshort='BROADCOM' limit 1 [ RunTime:0.096930s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'AFBR-1624Z' OR `brand` LIKE 'BROADCOM%' ) ) LIMIT 1 [ RunTime:0.079712s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16141 LIMIT 4 [ RunTime:0.034238s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16141 ORDER BY `minOrder` ASC [ RunTime:0.017149s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16141 ORDER BY `unit` DESC [ RunTime:0.013354s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16141 LIMIT 2 [ RunTime:0.027032s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16141 ORDER BY `minOrder` ASC [ RunTime:0.017139s ]
select * from pdf where partno='BTS70082EPZXUMA1' and brandshort='INFINEON' limit 1 [ RunTime:0.009512s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BTS70082EPZXUMA1' OR `brand` LIKE 'INFINEON%' ) ) LIMIT 1 [ RunTime:0.014105s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16140 LIMIT 4 [ RunTime:0.036222s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16140 ORDER BY `minOrder` ASC [ RunTime:0.025914s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16140 ORDER BY `unit` DESC [ RunTime:0.061259s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16140 LIMIT 2 [ RunTime:0.019184s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16140 ORDER BY `minOrder` ASC [ RunTime:0.089084s ]
select * from pdf where partno='T491D226K025AT' and brandshort='KEMET' limit 1 [ RunTime:0.019958s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'T491D226K025AT' OR `brand` LIKE 'KEMET%' ) ) LIMIT 1 [ RunTime:0.017258s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16139 LIMIT 4 [ RunTime:0.002710s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16139 ORDER BY `minOrder` ASC [ RunTime:0.010902s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16139 ORDER BY `unit` DESC [ RunTime:0.014828s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16139 LIMIT 2 [ RunTime:0.000662s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16139 ORDER BY `minOrder` ASC [ RunTime:0.002279s ]
select * from pdf where partno='NTCLE213E3103FLB0' and brandshort='VISHAY' limit 1 [ RunTime:0.004504s ]
select foldpath,foldpath2,filename from pdf_file where id=1923427 limit 1 [ RunTime:0.006278s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'NTCLE213E3103FLB0' OR `brand` LIKE 'VISHAY%' ) ) LIMIT 1 [ RunTime:0.040503s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16138 LIMIT 4 [ RunTime:0.016190s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16138 ORDER BY `minOrder` ASC [ RunTime:0.022888s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16138 ORDER BY `unit` DESC [ RunTime:0.029520s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16138 LIMIT 2 [ RunTime:0.011898s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16138 ORDER BY `minOrder` ASC [ RunTime:0.004997s ]
select * from pdf where partno='10090769-P264ALF' and brandshort='AMPHENOL COMMUNICATIONS SOLUTIONS' limit 1 [ RunTime:0.016551s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10090769-P264ALF' OR `brand` LIKE 'AMPHENOL COMMUNICATIONS SOLUTIONS%' ) ) LIMIT 1 [ RunTime:0.013633s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16137 LIMIT 4 [ RunTime:0.024705s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16137 ORDER BY `minOrder` ASC [ RunTime:0.040060s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16137 ORDER BY `unit` DESC [ RunTime:0.010657s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16137 LIMIT 2 [ RunTime:0.036410s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16137 ORDER BY `minOrder` ASC [ RunTime:0.006674s ]
select * from pdf where partno='R6076ENZ1C9' and brandshort='ROHM' limit 1 [ RunTime:0.013335s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'R6076ENZ1C9' OR `brand` LIKE 'ROHM%' ) ) LIMIT 1 [ RunTime:0.075794s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16136 LIMIT 4 [ RunTime:0.011146s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16136 ORDER BY `minOrder` ASC [ RunTime:0.012584s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16136 ORDER BY `unit` DESC [ RunTime:0.024312s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16136 LIMIT 2 [ RunTime:0.016383s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16136 ORDER BY `minOrder` ASC [ RunTime:0.007798s ]
select * from pdf where partno='SMMBT3906WT1G' and brandshort='ONSEMI' limit 1 [ RunTime:0.013075s ]
select foldpath,foldpath2,filename from pdf_file where id=2084460 limit 1 [ RunTime:0.005248s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMMBT3906WT1G' OR `brand` LIKE 'ONSEMI%' ) ) LIMIT 1 [ RunTime:0.042913s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16135 LIMIT 4 [ RunTime:0.015983s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16135 ORDER BY `minOrder` ASC [ RunTime:0.004847s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16135 ORDER BY `unit` DESC [ RunTime:0.023092s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16135 LIMIT 2 [ RunTime:0.018814s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16135 ORDER BY `minOrder` ASC [ RunTime:0.006418s ]
select * from pdf where partno='DTC114YUBHZGTL' and brandshort='ROHM' limit 1 [ RunTime:0.020193s ]
select foldpath,foldpath2,filename from pdf_file where id=1681654 limit 1 [ RunTime:0.017815s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'DTC114YUBHZGTL' OR `brand` LIKE 'ROHM%' ) ) LIMIT 1 [ RunTime:0.031501s ]
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.016155s ]