SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002800s ]
INSERT INTO `visit_log` SET `ip` = '216.73.217.116' , `useragent` = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)' , `reffer` = '' , `host` = 'https://www.ic118.com/stock?typeid=134' [ RunTime:0.090158s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002782s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000639s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002196s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.116' ) [ RunTime:0.026120s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002030s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.010398s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 134 [ RunTime:0.129891s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 134 LIMIT 1 [ RunTime:0.046522s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002389s ]
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` FORCE INDEX ( idx_categoryid ) LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND `s`.`categoryid` = '134' ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.187317s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.068656s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14959 LIMIT 5 [ RunTime:0.085154s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.018599s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14959 ORDER BY `minOrder` ASC [ RunTime:0.121598s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.005698s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14959 ORDER BY `unit` DESC [ RunTime:0.056649s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.029972s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14959 LIMIT 2 [ RunTime:0.052974s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14959 ORDER BY `minOrder` ASC [ RunTime:0.017625s ]
select * from pdf where partno='TYN640RG' and brandshort='ST' limit 1 [ RunTime:0.116126s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002103s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TYN640RG' OR `brand` LIKE 'ST%' ) ) LIMIT 1 [ RunTime:0.130276s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10387 LIMIT 5 [ RunTime:0.043102s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10387 ORDER BY `minOrder` ASC [ RunTime:0.079327s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10387 ORDER BY `unit` DESC [ RunTime:0.039693s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10387 LIMIT 2 [ RunTime:0.032359s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10387 ORDER BY `minOrder` ASC [ RunTime:0.013118s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MAC97A6,116' OR `brand` LIKE 'WEEN SEMICONDUCTORS%' ) ) LIMIT 1 [ RunTime:0.023262s ]
SELECT `id` FROM `stock` WHERE `id` <> 10387 AND `partno` = 'MAC97A6,116' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%ween semiconductors%' ) [ RunTime:0.016560s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18583126 [ RunTime:0.066635s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 2254 LIMIT 5 [ RunTime:0.019388s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2254 ORDER BY `minOrder` ASC [ RunTime:0.022786s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 2254 ORDER BY `unit` DESC [ RunTime:0.023479s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 2254 LIMIT 2 [ RunTime:0.035100s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2254 ORDER BY `minOrder` ASC [ RunTime:0.016451s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MOC3051-M' OR `brand` LIKE 'ONSEMI%' ) ) LIMIT 1 [ RunTime:0.029761s ]
SELECT `id` FROM `stock` WHERE `id` <> 2254 AND `partno` = 'MOC3051-M' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%onsemi%' ) [ RunTime:0.048755s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 8211 LIMIT 5 [ RunTime:0.007310s ]
SELECT * FROM `stock_price` WHERE `stockid` = 8211 ORDER BY `minOrder` ASC [ RunTime:0.011164s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 8211 ORDER BY `unit` DESC [ RunTime:0.010183s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 8211 LIMIT 2 [ RunTime:0.010768s ]
SELECT * FROM `stock_price` WHERE `stockid` = 8211 ORDER BY `minOrder` ASC [ RunTime:0.003464s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MRA4005T1G' OR `brand` LIKE 'ONSEMI%' ) ) LIMIT 1 [ RunTime:0.025593s ]
SELECT `id` FROM `stock` WHERE `id` <> 8211 AND `partno` = 'MRA4005T1G' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%onsemi%' ) [ RunTime:0.037225s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44080764 [ RunTime:0.033339s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10983 LIMIT 5 [ RunTime:0.005230s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10983 ORDER BY `minOrder` ASC [ RunTime:0.003638s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10983 ORDER BY `unit` DESC [ RunTime:0.014929s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10983 LIMIT 2 [ RunTime:0.010467s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10983 ORDER BY `minOrder` ASC [ RunTime:0.008655s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'X0202MA 2BL2' OR `brand` LIKE 'STMICROELECTRONICS%' ) ) LIMIT 1 [ RunTime:0.022814s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 9216 LIMIT 5 [ RunTime:0.003332s ]
SELECT * FROM `stock_price` WHERE `stockid` = 9216 ORDER BY `minOrder` ASC [ RunTime:0.039510s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 9216 ORDER BY `unit` DESC [ RunTime:0.008047s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 9216 LIMIT 2 [ RunTime:0.023521s ]
SELECT * FROM `stock_price` WHERE `stockid` = 9216 ORDER BY `minOrder` ASC [ RunTime:0.010743s ]
select * from pdf where partno='S6X8ES' and brandshort='LITTELFUSE' limit 1 [ RunTime:0.024558s ]
select foldpath,foldpath2,filename from pdf_file where id=626060 limit 1 [ RunTime:0.008671s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'S6X8ES' OR `brand` LIKE 'LITTELFUSE%' ) ) LIMIT 1 [ RunTime:0.022515s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 7435 LIMIT 5 [ RunTime:0.017261s ]
SELECT * FROM `stock_price` WHERE `stockid` = 7435 ORDER BY `minOrder` ASC [ RunTime:0.038342s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 7435 ORDER BY `unit` DESC [ RunTime:0.006974s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 7435 LIMIT 2 [ RunTime:0.001660s ]
SELECT * FROM `stock_price` WHERE `stockid` = 7435 ORDER BY `minOrder` ASC [ RunTime:0.005098s ]
select * from pdf where partno='ACST1235-8FP' and brandshort='STMICROELECTRONICS' limit 1 [ RunTime:0.004936s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ACST1235-8FP' OR `brand` LIKE 'STMICROELECTRONICS%' ) ) LIMIT 1 [ RunTime:0.001658s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 3433 LIMIT 5 [ RunTime:0.019238s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3433 ORDER BY `minOrder` ASC [ RunTime:0.020899s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 3433 ORDER BY `unit` DESC [ RunTime:0.017273s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 3433 LIMIT 2 [ RunTime:0.010617s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3433 ORDER BY `minOrder` ASC [ RunTime:0.003334s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'IS622X' OR `brand` LIKE 'ISOCOM%' ) ) LIMIT 1 [ RunTime:0.011249s ]
SELECT `id` FROM `stock` WHERE `id` <> 3433 AND `partno` = 'IS622X' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%isocom%' ) [ RunTime:0.015666s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16992802 [ RunTime:0.019681s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 6575 LIMIT 5 [ RunTime:0.010361s ]
SELECT * FROM `stock_price` WHERE `stockid` = 6575 ORDER BY `minOrder` ASC [ RunTime:0.019137s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 6575 ORDER BY `unit` DESC [ RunTime:0.014061s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 6575 LIMIT 2 [ RunTime:0.004088s ]
SELECT * FROM `stock_price` WHERE `stockid` = 6575 ORDER BY `minOrder` ASC [ RunTime:0.006561s ]
select * from pdf where partno='BTB24-800BWRG' and brandshort='STMICROELECTRONICS' limit 1 [ RunTime:0.002949s ]
select foldpath,foldpath2,filename from pdf_file where id=551017 limit 1 [ RunTime:0.001650s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BTB24-800BWRG' OR `brand` LIKE 'STMICROELECTRONICS%' ) ) LIMIT 1 [ RunTime:0.000370s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10036 LIMIT 5 [ RunTime:0.004482s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10036 ORDER BY `minOrder` ASC [ RunTime:0.000416s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10036 ORDER BY `unit` DESC [ RunTime:0.003868s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10036 LIMIT 2 [ RunTime:0.016767s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10036 ORDER BY `minOrder` ASC [ RunTime:0.009354s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BT151-500R,127' OR `brand` LIKE 'WEEN SEMICONDUCTORS%' ) ) LIMIT 1 [ RunTime:0.010477s ]
SELECT `id` FROM `stock` WHERE `id` <> 10036 AND `partno` = 'BT151-500R,127' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%ween semiconductors%' ) [ RunTime:0.000475s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18584630 [ RunTime:0.008928s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16907 LIMIT 5 [ RunTime:0.010791s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16907 ORDER BY `minOrder` ASC [ RunTime:0.010645s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16907 ORDER BY `unit` DESC [ RunTime:0.001524s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16907 LIMIT 2 [ RunTime:0.002813s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16907 ORDER BY `minOrder` ASC [ RunTime:0.006167s ]
select * from pdf where partno='ACST1235-8FP' and brandshort='STMICROELECTRONICS' limit 1 [ RunTime:0.000427s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ACST1235-8FP' OR `brand` LIKE 'STMICROELECTRONICS%' ) ) LIMIT 1 [ RunTime:0.000233s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15889 LIMIT 5 [ RunTime:0.000396s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15889 ORDER BY `minOrder` ASC [ RunTime:0.001897s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15889 ORDER BY `unit` DESC [ RunTime:0.000348s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15889 LIMIT 2 [ RunTime:0.006498s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15889 ORDER BY `minOrder` ASC [ RunTime:0.011209s ]
select * from pdf where partno='ACST1235-8FP' and brandshort='STMICROELECTRONICS' limit 1 [ RunTime:0.000496s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ACST1235-8FP' OR `brand` LIKE 'STMICROELECTRONICS%' ) ) LIMIT 1 [ RunTime:0.011187s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 9417 LIMIT 5 [ RunTime:0.022472s ]
SELECT * FROM `stock_price` WHERE `stockid` = 9417 ORDER BY `minOrder` ASC [ RunTime:0.013025s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 9417 ORDER BY `unit` DESC [ RunTime:0.022762s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 9417 LIMIT 2 [ RunTime:0.012551s ]
SELECT * FROM `stock_price` WHERE `stockid` = 9417 ORDER BY `minOrder` ASC [ RunTime:0.005710s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'T3050H-6T' OR `brand` LIKE 'STMICROELECTRONICS%' ) ) LIMIT 1 [ RunTime:0.005153s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 3809 LIMIT 5 [ RunTime:0.002273s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3809 ORDER BY `minOrder` ASC [ RunTime:0.035552s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 3809 ORDER BY `unit` DESC [ RunTime:0.006437s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 3809 LIMIT 2 [ RunTime:0.011525s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3809 ORDER BY `minOrder` ASC [ RunTime:0.017677s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'T2535-600G-TR' OR `brand` LIKE 'STMICROELECTRONICS%' ) ) LIMIT 1 [ RunTime:0.013318s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 9212 LIMIT 5 [ RunTime:0.016276s ]
SELECT * FROM `stock_price` WHERE `stockid` = 9212 ORDER BY `minOrder` ASC [ RunTime:0.016443s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 9212 ORDER BY `unit` DESC [ RunTime:0.002226s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 9212 LIMIT 2 [ RunTime:0.000950s ]
SELECT * FROM `stock_price` WHERE `stockid` = 9212 ORDER BY `minOrder` ASC [ RunTime:0.004887s ]
select * from pdf where partno='P0080SAMCLRP' and brandshort='LITTELFUSE' limit 1 [ RunTime:0.006253s ]
select foldpath,foldpath2,filename from pdf_file where id=1020732 limit 1 [ RunTime:0.003262s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P0080SAMCLRP' OR `brand` LIKE 'LITTELFUSE%' ) ) LIMIT 1 [ RunTime:0.029439s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10388 LIMIT 5 [ RunTime:0.015019s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10388 ORDER BY `minOrder` ASC [ RunTime:0.001248s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10388 ORDER BY `unit` DESC [ RunTime:0.000490s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10388 LIMIT 2 [ RunTime:0.000643s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10388 ORDER BY `minOrder` ASC [ RunTime:0.000424s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'EC103D1WX' OR `brand` LIKE 'WEEN SEMICONDUCTORS%' ) ) LIMIT 1 [ RunTime:0.002110s ]
SELECT `id` FROM `stock` WHERE `id` <> 10388 AND `partno` = 'EC103D1WX' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%ween semiconductors%' ) [ RunTime:0.006686s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18586353 [ RunTime:0.008864s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 9591 LIMIT 5 [ RunTime:0.005031s ]
SELECT * FROM `stock_price` WHERE `stockid` = 9591 ORDER BY `minOrder` ASC [ RunTime:0.037890s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 9591 ORDER BY `unit` DESC [ RunTime:0.011223s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 9591 LIMIT 2 [ RunTime:0.008991s ]
SELECT * FROM `stock_price` WHERE `stockid` = 9591 ORDER BY `minOrder` ASC [ RunTime:0.001735s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TISP4040L1BJR-S' OR `brand` LIKE 'BOURNS%' ) ) LIMIT 1 [ RunTime:0.039442s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11343 LIMIT 5 [ RunTime:0.017857s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11343 ORDER BY `minOrder` ASC [ RunTime:0.015185s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11343 ORDER BY `unit` DESC [ RunTime:0.010658s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11343 LIMIT 2 [ RunTime:0.007232s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11343 ORDER BY `minOrder` ASC [ RunTime:0.009880s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BTA312B-600B,118' OR `brand` LIKE 'WEEN SEMICONDUCTORS%' ) ) LIMIT 1 [ RunTime:0.002109s ]
SELECT `id` FROM `stock` WHERE `id` <> 11343 AND `partno` = 'BTA312B-600B,118' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%ween semiconductors%' ) [ RunTime:0.017431s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16001782 [ RunTime:0.008471s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 7396 LIMIT 5 [ RunTime:0.003013s ]
SELECT * FROM `stock_price` WHERE `stockid` = 7396 ORDER BY `minOrder` ASC [ RunTime:0.011283s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 7396 ORDER BY `unit` DESC [ RunTime:0.020436s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 7396 LIMIT 2 [ RunTime:0.009410s ]
SELECT * FROM `stock_price` WHERE `stockid` = 7396 ORDER BY `minOrder` ASC [ RunTime:0.007005s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FODM3053R2-NF098' OR `brand` LIKE 'ONSEMI%' ) ) LIMIT 1 [ RunTime:0.002735s ]
SELECT `id` FROM `stock` WHERE `id` <> 7396 AND `partno` = 'FODM3053R2-NF098' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%onsemi%' ) [ RunTime:0.029974s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18695330 [ RunTime:0.007189s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 7614 LIMIT 5 [ RunTime:0.041046s ]
SELECT * FROM `stock_price` WHERE `stockid` = 7614 ORDER BY `minOrder` ASC [ RunTime:0.007660s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 7614 ORDER BY `unit` DESC [ RunTime:0.011572s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 7614 LIMIT 2 [ RunTime:0.010476s ]
SELECT * FROM `stock_price` WHERE `stockid` = 7614 ORDER BY `minOrder` ASC [ RunTime:0.010452s ]
select * from pdf where partno='MCMA140P1600TA' and brandshort='IXYS SEMICONDUCTOR' limit 1 [ RunTime:0.025302s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MCMA140P1600TA' OR `brand` LIKE 'IXYS SEMICONDUCTOR%' ) ) LIMIT 1 [ RunTime:0.021408s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` FORCE INDEX ( idx_categoryid ) LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND `s`.`categoryid` = '134' ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016117s ]
SELECT brand, count(*) as count FROM ( SELECT `brand` FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND `s`.`categoryid` = '134' ) LIMIT 21 ) tmp GROUP BY `brand` [ RunTime:0.027443s ]