SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002573s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.48' , `useragent` = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)' , `reffer` = '' , `host` = 'https://www.ic118.com/stock?keyword=DF10&search=1' [ RunTime:0.005359s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001247s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.001182s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002146s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.48' ) [ RunTime:0.005236s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001469s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000534s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001932s ]
SELECT * FROM `stock_search` WHERE `partno` = 'DF10' LIMIT 1 [ RunTime:0.003022s ]
UPDATE `stock_search` SET `count` = 3 , `updatetime` = '2026-08-30 15:11:28' WHERE `partno` = 'DF10' [ RunTime:0.002257s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001402s ]
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` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'DF10%' OR `brand` LIKE 'DF10%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016682s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001248s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15999143 LIMIT 5 [ RunTime:0.004239s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001836s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15999143 ORDER BY `minOrder` ASC [ RunTime:0.011950s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.005246s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15999143 ORDER BY `unit` DESC [ RunTime:0.002112s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002081s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15999143 LIMIT 2 [ RunTime:0.002641s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15999143 ORDER BY `minOrder` ASC [ RunTime:0.000283s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15175883 LIMIT 5 [ RunTime:0.002154s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15175883 ORDER BY `minOrder` ASC [ RunTime:0.003815s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15175883 ORDER BY `unit` DESC [ RunTime:0.006770s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15175883 LIMIT 2 [ RunTime:0.004003s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15175883 ORDER BY `minOrder` ASC [ RunTime:0.000358s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15998938 LIMIT 5 [ RunTime:0.006886s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15998938 ORDER BY `minOrder` ASC [ RunTime:0.000703s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15998938 ORDER BY `unit` DESC [ RunTime:0.000423s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15998938 LIMIT 2 [ RunTime:0.003389s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15998938 ORDER BY `minOrder` ASC [ RunTime:0.000262s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18577745 LIMIT 5 [ RunTime:0.002029s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18577745 ORDER BY `minOrder` ASC [ RunTime:0.000431s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18577745 ORDER BY `unit` DESC [ RunTime:0.000386s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18577745 LIMIT 2 [ RunTime:0.000369s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18577745 ORDER BY `minOrder` ASC [ RunTime:0.001543s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15176174 LIMIT 5 [ RunTime:0.000722s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15176174 ORDER BY `minOrder` ASC [ RunTime:0.003190s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15176174 ORDER BY `unit` DESC [ RunTime:0.004560s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15176174 LIMIT 2 [ RunTime:0.002790s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15176174 ORDER BY `minOrder` ASC [ RunTime:0.001752s ]
select * from pdf where partno='DF10SA-E3/77' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.002411s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16000562 LIMIT 5 [ RunTime:0.011830s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16000562 ORDER BY `minOrder` ASC [ RunTime:0.016251s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16000562 ORDER BY `unit` DESC [ RunTime:0.003880s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16000562 LIMIT 2 [ RunTime:0.000571s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16000562 ORDER BY `minOrder` ASC [ RunTime:0.000377s ]
select * from pdf where partno='DF10MA-E3/45' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.001439s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15176512 LIMIT 5 [ RunTime:0.014291s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15176512 ORDER BY `minOrder` ASC [ RunTime:0.010233s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15176512 ORDER BY `unit` DESC [ RunTime:0.000600s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15176512 LIMIT 2 [ RunTime:0.009480s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15176512 ORDER BY `minOrder` ASC [ RunTime:0.005760s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18577759 LIMIT 5 [ RunTime:0.003513s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18577759 ORDER BY `minOrder` ASC [ RunTime:0.000695s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18577759 ORDER BY `unit` DESC [ RunTime:0.005923s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18577759 LIMIT 2 [ RunTime:0.000755s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18577759 ORDER BY `minOrder` ASC [ RunTime:0.000474s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15176511 LIMIT 5 [ RunTime:0.000718s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15176511 ORDER BY `minOrder` ASC [ RunTime:0.002593s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15176511 ORDER BY `unit` DESC [ RunTime:0.004540s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15176511 LIMIT 2 [ RunTime:0.000636s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15176511 ORDER BY `minOrder` ASC [ RunTime:0.002418s ]
select * from pdf where partno='DF10S-E3/45' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.010522s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15999499 LIMIT 5 [ RunTime:0.011245s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15999499 ORDER BY `minOrder` ASC [ RunTime:0.019354s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15999499 ORDER BY `unit` DESC [ RunTime:0.000747s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15999499 LIMIT 2 [ RunTime:0.001187s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15999499 ORDER BY `minOrder` ASC [ RunTime:0.004947s ]
select * from pdf where partno='DF10M-E3/45' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.005646s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15999110 LIMIT 5 [ RunTime:0.002553s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15999110 ORDER BY `minOrder` ASC [ RunTime:0.005690s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15999110 ORDER BY `unit` DESC [ RunTime:0.002396s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15999110 LIMIT 2 [ RunTime:0.000592s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15999110 ORDER BY `minOrder` ASC [ RunTime:0.000378s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18578535 LIMIT 5 [ RunTime:0.000995s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18578535 ORDER BY `minOrder` ASC [ RunTime:0.001669s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18578535 ORDER BY `unit` DESC [ RunTime:0.005869s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18578535 LIMIT 2 [ RunTime:0.002199s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18578535 ORDER BY `minOrder` ASC [ RunTime:0.005857s ]
select * from pdf where partno='DF10S-E3/77' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.001580s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15176029 LIMIT 5 [ RunTime:0.007322s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15176029 ORDER BY `minOrder` ASC [ RunTime:0.000944s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15176029 ORDER BY `unit` DESC [ RunTime:0.000616s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15176029 LIMIT 2 [ RunTime:0.000607s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15176029 ORDER BY `minOrder` ASC [ RunTime:0.002579s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15999184 LIMIT 5 [ RunTime:0.001023s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15999184 ORDER BY `minOrder` ASC [ RunTime:0.002442s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15999184 ORDER BY `unit` DESC [ RunTime:0.000604s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15999184 LIMIT 2 [ RunTime:0.000584s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15999184 ORDER BY `minOrder` ASC [ RunTime:0.000408s ]
select * from pdf where partno='DF10SA-E3/45' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.001298s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11520919 LIMIT 5 [ RunTime:0.001163s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11520919 ORDER BY `minOrder` ASC [ RunTime:0.000738s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11520919 ORDER BY `unit` DESC [ RunTime:0.010982s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11520919 LIMIT 2 [ RunTime:0.002239s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11520919 ORDER BY `minOrder` ASC [ RunTime:0.001857s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18578099 LIMIT 5 [ RunTime:0.003783s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18578099 ORDER BY `minOrder` ASC [ RunTime:0.003989s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18578099 ORDER BY `unit` DESC [ RunTime:0.000607s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18578099 LIMIT 2 [ RunTime:0.002130s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18578099 ORDER BY `minOrder` ASC [ RunTime:0.004425s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15999307 LIMIT 5 [ RunTime:0.008843s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15999307 ORDER BY `minOrder` ASC [ RunTime:0.007074s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15999307 ORDER BY `unit` DESC [ RunTime:0.001115s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15999307 LIMIT 2 [ RunTime:0.000926s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15999307 ORDER BY `minOrder` ASC [ RunTime:0.001147s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14706938 LIMIT 5 [ RunTime:0.005231s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14706938 ORDER BY `minOrder` ASC [ RunTime:0.003660s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14706938 ORDER BY `unit` DESC [ RunTime:0.007374s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14706938 LIMIT 2 [ RunTime:0.002404s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14706938 ORDER BY `minOrder` ASC [ RunTime:0.008458s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18578156 LIMIT 5 [ RunTime:0.016638s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18578156 ORDER BY `minOrder` ASC [ RunTime:0.001690s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18578156 ORDER BY `unit` DESC [ RunTime:0.000316s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18578156 LIMIT 2 [ RunTime:0.000273s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18578156 ORDER BY `minOrder` ASC [ RunTime:0.002284s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18580477 LIMIT 5 [ RunTime:0.000901s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18580477 ORDER BY `minOrder` ASC [ RunTime:0.004220s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18580477 ORDER BY `unit` DESC [ RunTime:0.010779s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18580477 LIMIT 2 [ RunTime:0.010600s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18580477 ORDER BY `minOrder` ASC [ RunTime:0.003077s ]
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` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'DF10%' OR `brand` LIKE 'DF10%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005362s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32263927 LIMIT 5 [ RunTime:0.004353s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32263927 ORDER BY `minOrder` ASC [ RunTime:0.005692s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32263927 ORDER BY `unit` DESC [ RunTime:0.006016s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32263927 LIMIT 2 [ RunTime:0.005160s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32263927 ORDER BY `minOrder` ASC [ RunTime:0.004925s ]
select * from pdf where partno='df10m3n/aa' and brandshort='amphenol positronic' limit 1 [ RunTime:0.012329s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001512s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'df10m3n/aa' OR `brand` LIKE 'amphenol positronic%' ) ) LIMIT 1 [ RunTime:0.008190s ]
SELECT `id` FROM `stock` WHERE `id` <> 32263927 AND `partno` = 'df10m3n/aa' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol positronic%' ) [ RunTime:0.017023s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12764592 [ RunTime:0.023384s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51026618 LIMIT 5 [ RunTime:0.013428s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51026618 ORDER BY `minOrder` ASC [ RunTime:0.012359s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51026618 ORDER BY `unit` DESC [ RunTime:0.015871s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51026618 LIMIT 2 [ RunTime:0.054116s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51026618 ORDER BY `minOrder` ASC [ RunTime:0.010034s ]
select * from pdf where partno='df100r07w1h5fpb53bpsa2' and brandshort='infineon technologies' limit 1 [ RunTime:0.012741s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'df100r07w1h5fpb53bpsa2' OR `brand` LIKE 'infineon technologies%' ) ) LIMIT 1 [ RunTime:0.032357s ]
SELECT `id` FROM `stock` WHERE `id` <> 51026618 AND `partno` = 'df100r07w1h5fpb53bpsa2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%infineon technologies%' ) [ RunTime:0.022071s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58714234 [ RunTime:0.026420s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51026613 LIMIT 5 [ RunTime:0.004805s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51026613 ORDER BY `minOrder` ASC [ RunTime:0.012648s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51026613 ORDER BY `unit` DESC [ RunTime:0.000861s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51026613 LIMIT 2 [ RunTime:0.000386s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51026613 ORDER BY `minOrder` ASC [ RunTime:0.000250s ]
select * from pdf where partno='df100r07w1h5fpb54bpsa2' and brandshort='infineon technologies' limit 1 [ RunTime:0.002323s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'df100r07w1h5fpb54bpsa2' OR `brand` LIKE 'infineon technologies%' ) ) LIMIT 1 [ RunTime:0.009080s ]
SELECT `id` FROM `stock` WHERE `id` <> 51026613 AND `partno` = 'df100r07w1h5fpb54bpsa2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%infineon technologies%' ) [ RunTime:0.014976s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58714233 [ RunTime:0.023110s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51026689 LIMIT 5 [ RunTime:0.011802s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51026689 ORDER BY `minOrder` ASC [ RunTime:0.012362s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51026689 ORDER BY `unit` DESC [ RunTime:0.026013s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51026689 LIMIT 2 [ RunTime:0.004744s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51026689 ORDER BY `minOrder` ASC [ RunTime:0.011569s ]
select * from pdf where partno='df100la160' and brandshort='sanrex' limit 1 [ RunTime:0.005786s ]
select foldpath,foldpath2,filename from pdf_file where id=324865 limit 1 [ RunTime:0.011019s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'df100la160' OR `brand` LIKE 'sanrex%' ) ) LIMIT 1 [ RunTime:0.006842s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51026650 LIMIT 5 [ RunTime:0.027583s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51026650 ORDER BY `minOrder` ASC [ RunTime:0.024650s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51026650 ORDER BY `unit` DESC [ RunTime:0.009131s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51026650 LIMIT 2 [ RunTime:0.023307s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51026650 ORDER BY `minOrder` ASC [ RunTime:0.019960s ]
select * from pdf where partno='df100la80' and brandshort='sanrex' limit 1 [ RunTime:0.019602s ]
select foldpath,foldpath2,filename from pdf_file where id=324865 limit 1 [ RunTime:0.013994s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'df100la80' OR `brand` LIKE 'sanrex%' ) ) LIMIT 1 [ RunTime:0.003030s ]
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` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'DF10%' OR `brand` LIKE 'DF10%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.032365s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58719466 LIMIT 5 [ RunTime:0.000551s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58719466 ORDER BY `minOrder` ASC [ RunTime:0.033851s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58719466 ORDER BY `unit` DESC [ RunTime:0.016687s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58719466 LIMIT 2 [ RunTime:0.017071s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58719466 ORDER BY `minOrder` ASC [ RunTime:0.000627s ]
select * from pdf where partno='DF10S1' and brandshort='Fairchild Semiconductor' limit 1 [ RunTime:0.018123s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'DF10S1' OR `brand` LIKE 'Fairchild Semiconductor%' ) ) LIMIT 1 [ RunTime:0.032708s ]
SELECT `id` FROM `stock` WHERE `id` <> 58719466 AND `partno` = 'DF10S1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%fairchild semiconductor%' ) [ RunTime:0.026431s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15999143 [ RunTime:0.013973s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58717826 LIMIT 5 [ RunTime:0.024014s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58717826 ORDER BY `minOrder` ASC [ RunTime:0.018526s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58717826 ORDER BY `unit` DESC [ RunTime:0.016085s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58717826 LIMIT 2 [ RunTime:0.018882s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58717826 ORDER BY `minOrder` ASC [ RunTime:0.005377s ]
select * from pdf where partno='DF10M' and brandshort='Diodes Incorporated' limit 1 [ RunTime:0.019446s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'DF10M' OR `brand` LIKE 'Diodes Incorporated%' ) ) LIMIT 1 [ RunTime:0.018028s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58717830 LIMIT 5 [ RunTime:0.000734s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58717830 ORDER BY `minOrder` ASC [ RunTime:0.000875s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58717830 ORDER BY `unit` DESC [ RunTime:0.016370s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58717830 LIMIT 2 [ RunTime:0.005143s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58717830 ORDER BY `minOrder` ASC [ RunTime:0.016412s ]
select * from pdf where partno='DF10S' and brandshort='onsemi' limit 1 [ RunTime:0.028694s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'DF10S' OR `brand` LIKE 'onsemi%' ) ) LIMIT 1 [ RunTime:0.020956s ]
SELECT `id` FROM `stock` WHERE `id` <> 58717830 AND `partno` = 'DF10S' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%onsemi%' ) [ RunTime:0.010490s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15998938 [ RunTime:0.001680s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58719159 LIMIT 5 [ RunTime:0.000678s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58719159 ORDER BY `minOrder` ASC [ RunTime:0.001085s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58719159 ORDER BY `unit` DESC [ RunTime:0.009462s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58719159 LIMIT 2 [ RunTime:0.002723s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58719159 ORDER BY `minOrder` ASC [ RunTime:0.005627s ]
select * from pdf where partno='DF10S' and brandshort='Good-Ark Semiconductor' limit 1 [ RunTime:0.000979s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'DF10S' OR `brand` LIKE 'Good-Ark Semiconductor%' ) ) LIMIT 1 [ RunTime:0.003763s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58717827 LIMIT 5 [ RunTime:0.007136s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58717827 ORDER BY `minOrder` ASC [ RunTime:0.006963s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58717827 ORDER BY `unit` DESC [ RunTime:0.004093s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58717827 LIMIT 2 [ RunTime:0.012033s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58717827 ORDER BY `minOrder` ASC [ RunTime:0.007409s ]
select * from pdf where partno='DF10S-T' and brandshort='Diodes Incorporated' limit 1 [ RunTime:0.001258s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'DF10S-T' OR `brand` LIKE 'Diodes Incorporated%' ) ) LIMIT 1 [ RunTime:0.000899s ]
SELECT `id` FROM `stock` WHERE `id` <> 58717827 AND `partno` = 'DF10S-T' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%diodes incorporated%' ) [ RunTime:0.012313s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15176029 [ RunTime:0.010513s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58718004 LIMIT 5 [ RunTime:0.002872s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58718004 ORDER BY `minOrder` ASC [ RunTime:0.031433s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58718004 ORDER BY `unit` DESC [ RunTime:0.004613s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58718004 LIMIT 2 [ RunTime:0.000404s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58718004 ORDER BY `minOrder` ASC [ RunTime:0.007508s ]
select * from pdf where partno='DF10S-E3/77' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.002656s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'DF10S-E3/77' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.001916s ]
SELECT `id` FROM `stock` WHERE `id` <> 58718004 AND `partno` = 'DF10S-E3/77' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.000692s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18578535 [ RunTime:0.000475s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58718009 LIMIT 5 [ RunTime:0.000482s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58718009 ORDER BY `minOrder` ASC [ RunTime:0.010929s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58718009 ORDER BY `unit` DESC [ RunTime:0.004664s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58718009 LIMIT 2 [ RunTime:0.007590s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58718009 ORDER BY `minOrder` ASC [ RunTime:0.000617s ]
select * from pdf where partno='DF10M-E3/45' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.000390s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'DF10M-E3/45' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.000614s ]
SELECT `id` FROM `stock` WHERE `id` <> 58718009 AND `partno` = 'DF10M-E3/45' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.004158s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15999499 [ RunTime:0.016169s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58718311 LIMIT 5 [ RunTime:0.008095s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58718311 ORDER BY `minOrder` ASC [ RunTime:0.002386s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58718311 ORDER BY `unit` DESC [ RunTime:0.000622s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58718311 LIMIT 2 [ RunTime:0.000516s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58718311 ORDER BY `minOrder` ASC [ RunTime:0.000365s ]
select * from pdf where partno='DF10SA-E3/77' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.000525s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'DF10SA-E3/77' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.000666s ]
SELECT `id` FROM `stock` WHERE `id` <> 58718311 AND `partno` = 'DF10SA-E3/77' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.000739s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15176174 [ RunTime:0.000818s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58718318 LIMIT 5 [ RunTime:0.004243s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58718318 ORDER BY `minOrder` ASC [ RunTime:0.006304s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58718318 ORDER BY `unit` DESC [ RunTime:0.003142s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58718318 LIMIT 2 [ RunTime:0.002901s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58718318 ORDER BY `minOrder` ASC [ RunTime:0.000432s ]
select * from pdf where partno='DF10MA-E3/45' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.000505s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'DF10MA-E3/45' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.000751s ]
SELECT `id` FROM `stock` WHERE `id` <> 58718318 AND `partno` = 'DF10MA-E3/45' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.000866s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16000562 [ RunTime:0.002473s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58718288 LIMIT 5 [ RunTime:0.001813s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58718288 ORDER BY `minOrder` ASC [ RunTime:0.022274s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58718288 ORDER BY `unit` DESC [ RunTime:0.002369s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58718288 LIMIT 2 [ RunTime:0.016639s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58718288 ORDER BY `minOrder` ASC [ RunTime:0.012645s ]
select * from pdf where partno='DF10-G' and brandshort='Comchip Technology' limit 1 [ RunTime:0.022077s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'DF10-G' OR `brand` LIKE 'Comchip Technology%' ) ) LIMIT 1 [ RunTime:0.017004s ]
SELECT `id` FROM `stock` WHERE `id` <> 58718288 AND `partno` = 'DF10-G' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%comchip technology%' ) [ RunTime:0.015720s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15176512 [ RunTime:0.001604s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58718594 LIMIT 5 [ RunTime:0.000745s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58718594 ORDER BY `minOrder` ASC [ RunTime:0.001314s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58718594 ORDER BY `unit` DESC [ RunTime:0.013153s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58718594 LIMIT 2 [ RunTime:0.008993s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58718594 ORDER BY `minOrder` ASC [ RunTime:0.011839s ]
select * from pdf where partno='DF10SA-E3/45' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.005683s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'DF10SA-E3/45' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.000838s ]
SELECT `id` FROM `stock` WHERE `id` <> 58718594 AND `partno` = 'DF10SA-E3/45' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.000680s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15999184 [ RunTime:0.004817s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58719189 LIMIT 5 [ RunTime:0.002020s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58719189 ORDER BY `minOrder` ASC [ RunTime:0.003556s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58719189 ORDER BY `unit` DESC [ RunTime:0.000890s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58719189 LIMIT 2 [ RunTime:0.009670s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58719189 ORDER BY `minOrder` ASC [ RunTime:0.011063s ]
select * from pdf where partno='DF10' and brandshort='Good-Ark Semiconductor' limit 1 [ RunTime:0.010917s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'DF10' OR `brand` LIKE 'Good-Ark Semiconductor%' ) ) LIMIT 1 [ RunTime:0.001583s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58719293 LIMIT 5 [ RunTime:0.009491s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58719293 ORDER BY `minOrder` ASC [ RunTime:0.005072s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58719293 ORDER BY `unit` DESC [ RunTime:0.001535s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58719293 LIMIT 2 [ RunTime:0.004925s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58719293 ORDER BY `minOrder` ASC [ RunTime:0.001119s ]
select * from pdf where partno='DF10S1' and brandshort='onsemi' limit 1 [ RunTime:0.000734s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'DF10S1' OR `brand` LIKE 'onsemi%' ) ) LIMIT 1 [ RunTime:0.014743s ]
SELECT `id` FROM `stock` WHERE `id` <> 58719293 AND `partno` = 'DF10S1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%onsemi%' ) [ RunTime:0.009467s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15999110 [ RunTime:0.003311s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58718346 LIMIT 5 [ RunTime:0.011365s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58718346 ORDER BY `minOrder` ASC [ RunTime:0.011404s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58718346 ORDER BY `unit` DESC [ RunTime:0.014230s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58718346 LIMIT 2 [ RunTime:0.003334s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58718346 ORDER BY `minOrder` ASC [ RunTime:0.007791s ]
select * from pdf where partno='DF10S-E3/45' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.001483s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'DF10S-E3/45' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.008612s ]
SELECT `id` FROM `stock` WHERE `id` <> 58718346 AND `partno` = 'DF10S-E3/45' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.011579s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15176511 [ RunTime:0.006077s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59750490 LIMIT 5 [ RunTime:0.004406s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59750490 ORDER BY `minOrder` ASC [ RunTime:0.014109s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59750490 ORDER BY `unit` DESC [ RunTime:0.000512s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59750490 LIMIT 2 [ RunTime:0.003497s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59750490 ORDER BY `minOrder` ASC [ RunTime:0.002461s ]
select * from pdf where partno='DF10-31S-2DSA(72)' and brandshort='Hirose Electric Co Ltd' limit 1 [ RunTime:0.000971s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'DF10-31S-2DSA(72)' OR `brand` LIKE 'Hirose Electric Co Ltd%' ) ) LIMIT 1 [ RunTime:0.007867s ]
SELECT `id` FROM `stock` WHERE `id` <> 59750490 AND `partno` = 'DF10-31S-2DSA(72)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hirose electric co ltd%' ) [ RunTime:0.000773s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58714029 LIMIT 5 [ RunTime:0.000525s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58714029 ORDER BY `minOrder` ASC [ RunTime:0.000948s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58714029 ORDER BY `unit` DESC [ RunTime:0.004732s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58714029 LIMIT 2 [ RunTime:0.010679s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58714029 ORDER BY `minOrder` ASC [ RunTime:0.004896s ]
select * from pdf where partno='DF1000R17IE4DB2BOSA1' and brandshort='Infineon Technologies' limit 1 [ RunTime:0.003987s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'DF1000R17IE4DB2BOSA1' OR `brand` LIKE 'Infineon Technologies%' ) ) LIMIT 1 [ RunTime:0.004566s ]
SELECT `id` FROM `stock` WHERE `id` <> 58714029 AND `partno` = 'DF1000R17IE4DB2BOSA1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%infineon technologies%' ) [ RunTime:0.002956s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58713829 LIMIT 5 [ RunTime:0.001726s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58713829 ORDER BY `minOrder` ASC [ RunTime:0.007212s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58713829 ORDER BY `unit` DESC [ RunTime:0.003221s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58713829 LIMIT 2 [ RunTime:0.007833s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58713829 ORDER BY `minOrder` ASC [ RunTime:0.000471s ]
select * from pdf where partno='DF100R07W1H5FPB53BPSA1' and brandshort='Infineon Technologies' limit 1 [ RunTime:0.008364s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'DF100R07W1H5FPB53BPSA1' OR `brand` LIKE 'Infineon Technologies%' ) ) LIMIT 1 [ RunTime:0.001056s ]
SELECT `id` FROM `stock` WHERE `id` <> 58713829 AND `partno` = 'DF100R07W1H5FPB53BPSA1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%infineon technologies%' ) [ RunTime:0.003182s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58719638 LIMIT 5 [ RunTime:0.003681s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58719638 ORDER BY `minOrder` ASC [ RunTime:0.010553s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58719638 ORDER BY `unit` DESC [ RunTime:0.003295s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58719638 LIMIT 2 [ RunTime:0.003472s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58719638 ORDER BY `minOrder` ASC [ RunTime:0.004641s ]
select * from pdf where partno='DF10S' and brandshort='Diodes Incorporated' limit 1 [ RunTime:0.002409s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'DF10S' OR `brand` LIKE 'Diodes Incorporated%' ) ) LIMIT 1 [ RunTime:0.001342s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58713971 LIMIT 5 [ RunTime:0.008947s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58713971 ORDER BY `minOrder` ASC [ RunTime:0.005314s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58713971 ORDER BY `unit` DESC [ RunTime:0.005013s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58713971 LIMIT 2 [ RunTime:0.007957s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58713971 ORDER BY `minOrder` ASC [ RunTime:0.003821s ]
select * from pdf where partno='DF1000R17IE4PBPSA1' and brandshort='Infineon Technologies' limit 1 [ RunTime:0.001277s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'DF1000R17IE4PBPSA1' OR `brand` LIKE 'Infineon Technologies%' ) ) LIMIT 1 [ RunTime:0.014154s ]
SELECT `id` FROM `stock` WHERE `id` <> 58713971 AND `partno` = 'DF1000R17IE4PBPSA1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%infineon technologies%' ) [ RunTime:0.003682s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58714234 LIMIT 5 [ RunTime:0.014954s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58714234 ORDER BY `minOrder` ASC [ RunTime:0.003767s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58714234 ORDER BY `unit` DESC [ RunTime:0.022980s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58714234 LIMIT 2 [ RunTime:0.012577s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58714234 ORDER BY `minOrder` ASC [ RunTime:0.006727s ]
select * from pdf where partno='DF100R07W1H5FPB53BPSA2' and brandshort='Infineon Technologies' limit 1 [ RunTime:0.002275s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'DF100R07W1H5FPB53BPSA2' OR `brand` LIKE 'Infineon Technologies%' ) ) LIMIT 1 [ RunTime:0.006654s ]
SELECT `id` FROM `stock` WHERE `id` <> 58714234 AND `partno` = 'DF100R07W1H5FPB53BPSA2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%infineon technologies%' ) [ RunTime:0.032194s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51026618 [ RunTime:0.018874s ]
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` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'DF10%' OR `brand` LIKE 'DF10%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.026543s ]
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` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'DF10%' OR `brand` LIKE 'DF10%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.015141s ]
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` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'DF10%' OR `brand` LIKE 'DF10%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.018333s ]
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` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'DF10%' OR `brand` LIKE 'DF10%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001170s ]
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` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'DF10%' OR `brand` LIKE 'DF10%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001352s ]
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` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'DF10%' OR `brand` LIKE 'DF10%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012574s ]
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` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'DF10%' OR `brand` LIKE 'DF10%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005449s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'DF10%' OR `brand` LIKE 'DF10%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.004417s ]