SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001482s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.153' , `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=TN-SFP-OC3S8&search=1' [ RunTime:0.006987s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001134s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.002705s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001740s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.153' ) [ RunTime:0.006239s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001488s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.006132s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001324s ]
SELECT * FROM `stock_search` WHERE `partno` = 'TN-SFP-OC3S8' LIMIT 1 [ RunTime:0.002026s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-08-16 16:08:21' WHERE `partno` = 'TN-SFP-OC3S8' [ RunTime:0.002341s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002416s ]
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 'TN-SFP-OC3S8%' OR `brand` LIKE 'TN-SFP-OC3S8%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005021s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001524s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12226660 LIMIT 5 [ RunTime:0.000933s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001524s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12226660 ORDER BY `minOrder` ASC [ RunTime:0.005152s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002666s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12226660 ORDER BY `unit` DESC [ RunTime:0.002862s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001818s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12226660 LIMIT 2 [ RunTime:0.000499s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12226660 ORDER BY `minOrder` ASC [ RunTime:0.011033s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12225560 LIMIT 5 [ RunTime:0.006175s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12225560 ORDER BY `minOrder` ASC [ RunTime:0.002838s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12225560 ORDER BY `unit` DESC [ RunTime:0.001072s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12225560 LIMIT 2 [ RunTime:0.001683s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12225560 ORDER BY `minOrder` ASC [ RunTime:0.000771s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12226658 LIMIT 5 [ RunTime:0.000687s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12226658 ORDER BY `minOrder` ASC [ RunTime:0.008636s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12226658 ORDER BY `unit` DESC [ RunTime:0.002408s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12226658 LIMIT 2 [ RunTime:0.000510s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12226658 ORDER BY `minOrder` ASC [ RunTime:0.000362s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12226655 LIMIT 5 [ RunTime:0.006899s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12226655 ORDER BY `minOrder` ASC [ RunTime:0.001634s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12226655 ORDER BY `unit` DESC [ RunTime:0.004589s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12226655 LIMIT 2 [ RunTime:0.010262s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12226655 ORDER BY `minOrder` ASC [ RunTime:0.003798s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12226656 LIMIT 5 [ RunTime:0.000824s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12226656 ORDER BY `minOrder` ASC [ RunTime:0.014671s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12226656 ORDER BY `unit` DESC [ RunTime:0.002830s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12226656 LIMIT 2 [ RunTime:0.003934s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12226656 ORDER BY `minOrder` ASC [ RunTime:0.000507s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11226923 LIMIT 5 [ RunTime:0.007563s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11226923 ORDER BY `minOrder` ASC [ RunTime:0.000741s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11226923 ORDER BY `unit` DESC [ RunTime:0.003945s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11226923 LIMIT 2 [ RunTime:0.007992s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11226923 ORDER BY `minOrder` ASC [ RunTime:0.000455s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12226657 LIMIT 5 [ RunTime:0.003820s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12226657 ORDER BY `minOrder` ASC [ RunTime:0.005301s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12226657 ORDER BY `unit` DESC [ RunTime:0.016101s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12226657 LIMIT 2 [ RunTime:0.001163s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12226657 ORDER BY `minOrder` ASC [ RunTime:0.000448s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12226652 LIMIT 5 [ RunTime:0.007677s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12226652 ORDER BY `minOrder` ASC [ RunTime:0.016095s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12226652 ORDER BY `unit` DESC [ RunTime:0.003456s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12226652 LIMIT 2 [ RunTime:0.000607s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12226652 ORDER BY `minOrder` ASC [ RunTime:0.003397s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11226924 LIMIT 5 [ RunTime:0.000727s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11226924 ORDER BY `minOrder` ASC [ RunTime:0.009405s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11226924 ORDER BY `unit` DESC [ RunTime:0.004235s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11226924 LIMIT 2 [ RunTime:0.003479s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11226924 ORDER BY `minOrder` ASC [ RunTime:0.003345s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12226663 LIMIT 5 [ RunTime:0.004112s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12226663 ORDER BY `minOrder` ASC [ RunTime:0.006202s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12226663 ORDER BY `unit` DESC [ RunTime:0.005061s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12226663 LIMIT 2 [ RunTime:0.003471s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12226663 ORDER BY `minOrder` ASC [ RunTime:0.000455s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12226661 LIMIT 5 [ RunTime:0.000823s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12226661 ORDER BY `minOrder` ASC [ RunTime:0.005564s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12226661 ORDER BY `unit` DESC [ RunTime:0.006436s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12226661 LIMIT 2 [ RunTime:0.007821s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12226661 ORDER BY `minOrder` ASC [ RunTime:0.000835s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12226653 LIMIT 5 [ RunTime:0.003617s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12226653 ORDER BY `minOrder` ASC [ RunTime:0.000733s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12226653 ORDER BY `unit` DESC [ RunTime:0.001857s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12226653 LIMIT 2 [ RunTime:0.004180s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12226653 ORDER BY `minOrder` ASC [ RunTime:0.000460s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12226654 LIMIT 5 [ RunTime:0.002487s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12226654 ORDER BY `minOrder` ASC [ RunTime:0.001153s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12226654 ORDER BY `unit` DESC [ RunTime:0.000755s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12226654 LIMIT 2 [ RunTime:0.010627s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12226654 ORDER BY `minOrder` ASC [ RunTime:0.007250s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12226662 LIMIT 5 [ RunTime:0.003142s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12226662 ORDER BY `minOrder` ASC [ RunTime:0.006850s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12226662 ORDER BY `unit` DESC [ RunTime:0.004803s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12226662 LIMIT 2 [ RunTime:0.003149s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12226662 ORDER BY `minOrder` ASC [ RunTime:0.000455s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11226925 LIMIT 5 [ RunTime:0.005075s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11226925 ORDER BY `minOrder` ASC [ RunTime:0.001140s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11226925 ORDER BY `unit` DESC [ RunTime:0.002822s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11226925 LIMIT 2 [ RunTime:0.000678s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11226925 ORDER BY `minOrder` ASC [ RunTime:0.000537s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12226659 LIMIT 5 [ RunTime:0.005689s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12226659 ORDER BY `minOrder` ASC [ RunTime:0.001812s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12226659 ORDER BY `unit` DESC [ RunTime:0.000653s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12226659 LIMIT 2 [ RunTime:0.002940s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12226659 ORDER BY `minOrder` ASC [ RunTime:0.004273s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11226927 LIMIT 5 [ RunTime:0.000782s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11226927 ORDER BY `minOrder` ASC [ RunTime:0.000689s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11226927 ORDER BY `unit` DESC [ RunTime:0.002941s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11226927 LIMIT 2 [ RunTime:0.001939s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11226927 ORDER BY `minOrder` ASC [ RunTime:0.000496s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11226926 LIMIT 5 [ RunTime:0.000776s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11226926 ORDER BY `minOrder` ASC [ RunTime:0.000928s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11226926 ORDER BY `unit` DESC [ RunTime:0.000684s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11226926 LIMIT 2 [ RunTime:0.000651s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11226926 ORDER BY `minOrder` ASC [ RunTime:0.003512s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12223240 LIMIT 5 [ RunTime:0.008812s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12223240 ORDER BY `minOrder` ASC [ RunTime:0.001089s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12223240 ORDER BY `unit` DESC [ RunTime:0.000697s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12223240 LIMIT 2 [ RunTime:0.003166s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12223240 ORDER BY `minOrder` ASC [ RunTime:0.004377s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12223239 LIMIT 5 [ RunTime:0.005347s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12223239 ORDER BY `minOrder` ASC [ RunTime:0.017229s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12223239 ORDER BY `unit` DESC [ RunTime:0.007168s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12223239 LIMIT 2 [ RunTime:0.001218s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12223239 ORDER BY `minOrder` ASC [ RunTime:0.000490s ]
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 'TN-SFP-OC3S8%' OR `brand` LIKE 'TN-SFP-OC3S8%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001549s ]
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 'TN-SFP-OC3S8%' OR `brand` LIKE 'TN-SFP-OC3S8%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003427s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58150334 LIMIT 5 [ RunTime:0.016513s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58150334 ORDER BY `minOrder` ASC [ RunTime:0.009619s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58150334 ORDER BY `unit` DESC [ RunTime:0.001254s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58150334 LIMIT 2 [ RunTime:0.010968s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58150334 ORDER BY `minOrder` ASC [ RunTime:0.001594s ]
select * from pdf where partno='TN-SFP-OC3S8-C27-C' and brandshort='ATGBICS' limit 1 [ RunTime:0.011530s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.003489s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TN-SFP-OC3S8-C27-C' OR `brand` LIKE 'ATGBICS%' ) ) LIMIT 1 [ RunTime:0.007098s ]
SELECT `id` FROM `stock` WHERE `id` <> 58150334 AND `partno` = 'TN-SFP-OC3S8-C27-C' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%atgbics%' ) [ RunTime:0.037098s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12226661 [ RunTime:0.007313s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58150335 LIMIT 5 [ RunTime:0.041178s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58150335 ORDER BY `minOrder` ASC [ RunTime:0.008301s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58150335 ORDER BY `unit` DESC [ RunTime:0.014422s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58150335 LIMIT 2 [ RunTime:0.062291s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58150335 ORDER BY `minOrder` ASC [ RunTime:0.009972s ]
select * from pdf where partno='TN-SFP-OC3S8-C35-C' and brandshort='ATGBICS' limit 1 [ RunTime:0.019050s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TN-SFP-OC3S8-C35-C' OR `brand` LIKE 'ATGBICS%' ) ) LIMIT 1 [ RunTime:0.023104s ]
SELECT `id` FROM `stock` WHERE `id` <> 58150335 AND `partno` = 'TN-SFP-OC3S8-C35-C' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%atgbics%' ) [ RunTime:0.031443s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12226659 [ RunTime:0.042137s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58150336 LIMIT 5 [ RunTime:0.004426s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58150336 ORDER BY `minOrder` ASC [ RunTime:0.004675s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58150336 ORDER BY `unit` DESC [ RunTime:0.001463s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58150336 LIMIT 2 [ RunTime:0.000595s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58150336 ORDER BY `minOrder` ASC [ RunTime:0.000428s ]
select * from pdf where partno='TN-SFP-OC3S8-C39-C' and brandshort='ATGBICS' limit 1 [ RunTime:0.001340s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TN-SFP-OC3S8-C39-C' OR `brand` LIKE 'ATGBICS%' ) ) LIMIT 1 [ RunTime:0.013709s ]
SELECT `id` FROM `stock` WHERE `id` <> 58150336 AND `partno` = 'TN-SFP-OC3S8-C39-C' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%atgbics%' ) [ RunTime:0.013792s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12226658 [ RunTime:0.007701s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58150337 LIMIT 5 [ RunTime:0.011727s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58150337 ORDER BY `minOrder` ASC [ RunTime:0.010674s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58150337 ORDER BY `unit` DESC [ RunTime:0.004438s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58150337 LIMIT 2 [ RunTime:0.031624s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58150337 ORDER BY `minOrder` ASC [ RunTime:0.002679s ]
select * from pdf where partno='TN-SFP-OC3S8-C45-C' and brandshort='ATGBICS' limit 1 [ RunTime:0.001073s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TN-SFP-OC3S8-C45-C' OR `brand` LIKE 'ATGBICS%' ) ) LIMIT 1 [ RunTime:0.016743s ]
SELECT `id` FROM `stock` WHERE `id` <> 58150337 AND `partno` = 'TN-SFP-OC3S8-C45-C' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%atgbics%' ) [ RunTime:0.026358s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11226925 [ RunTime:0.000904s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58150338 LIMIT 5 [ RunTime:0.008491s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58150338 ORDER BY `minOrder` ASC [ RunTime:0.006805s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58150338 ORDER BY `unit` DESC [ RunTime:0.001648s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58150338 LIMIT 2 [ RunTime:0.005261s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58150338 ORDER BY `minOrder` ASC [ RunTime:0.002031s ]
select * from pdf where partno='TN-SFP-OC3S8-C51-C' and brandshort='ATGBICS' limit 1 [ RunTime:0.003174s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TN-SFP-OC3S8-C51-C' OR `brand` LIKE 'ATGBICS%' ) ) LIMIT 1 [ RunTime:0.006817s ]
SELECT `id` FROM `stock` WHERE `id` <> 58150338 AND `partno` = 'TN-SFP-OC3S8-C51-C' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%atgbics%' ) [ RunTime:0.008850s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12226654 [ RunTime:0.000937s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58150339 LIMIT 5 [ RunTime:0.003460s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58150339 ORDER BY `minOrder` ASC [ RunTime:0.013183s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58150339 ORDER BY `unit` DESC [ RunTime:0.013041s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58150339 LIMIT 2 [ RunTime:0.010225s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58150339 ORDER BY `minOrder` ASC [ RunTime:0.000802s ]
select * from pdf where partno='TN-SFP-OC3S8-C49-C' and brandshort='ATGBICS' limit 1 [ RunTime:0.001023s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TN-SFP-OC3S8-C49-C' OR `brand` LIKE 'ATGBICS%' ) ) LIMIT 1 [ RunTime:0.010555s ]
SELECT `id` FROM `stock` WHERE `id` <> 58150339 AND `partno` = 'TN-SFP-OC3S8-C49-C' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%atgbics%' ) [ RunTime:0.008119s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12226656 [ RunTime:0.004071s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58150340 LIMIT 5 [ RunTime:0.013815s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58150340 ORDER BY `minOrder` ASC [ RunTime:0.013557s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58150340 ORDER BY `unit` DESC [ RunTime:0.009277s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58150340 LIMIT 2 [ RunTime:0.011090s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58150340 ORDER BY `minOrder` ASC [ RunTime:0.009217s ]
select * from pdf where partno='TN-SFP-OC3S8-C41-C' and brandshort='ATGBICS' limit 1 [ RunTime:0.006661s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TN-SFP-OC3S8-C41-C' OR `brand` LIKE 'ATGBICS%' ) ) LIMIT 1 [ RunTime:0.005102s ]
SELECT `id` FROM `stock` WHERE `id` <> 58150340 AND `partno` = 'TN-SFP-OC3S8-C41-C' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%atgbics%' ) [ RunTime:0.014209s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11226924 [ RunTime:0.021329s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58150341 LIMIT 5 [ RunTime:0.007491s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58150341 ORDER BY `minOrder` ASC [ RunTime:0.008280s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58150341 ORDER BY `unit` DESC [ RunTime:0.020886s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58150341 LIMIT 2 [ RunTime:0.013422s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58150341 ORDER BY `minOrder` ASC [ RunTime:0.003722s ]
select * from pdf where partno='TN-SFP-OC3S8-C57-C' and brandshort='ATGBICS' limit 1 [ RunTime:0.004843s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TN-SFP-OC3S8-C57-C' OR `brand` LIKE 'ATGBICS%' ) ) LIMIT 1 [ RunTime:0.009549s ]
SELECT `id` FROM `stock` WHERE `id` <> 58150341 AND `partno` = 'TN-SFP-OC3S8-C57-C' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%atgbics%' ) [ RunTime:0.006968s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11226927 [ RunTime:0.003846s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58150342 LIMIT 5 [ RunTime:0.012230s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58150342 ORDER BY `minOrder` ASC [ RunTime:0.016163s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58150342 ORDER BY `unit` DESC [ RunTime:0.009546s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58150342 LIMIT 2 [ RunTime:0.002597s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58150342 ORDER BY `minOrder` ASC [ RunTime:0.009456s ]
select * from pdf where partno='TN-SFP-OC3S8-C53-C' and brandshort='ATGBICS' limit 1 [ RunTime:0.004472s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TN-SFP-OC3S8-C53-C' OR `brand` LIKE 'ATGBICS%' ) ) LIMIT 1 [ RunTime:0.015064s ]
SELECT `id` FROM `stock` WHERE `id` <> 58150342 AND `partno` = 'TN-SFP-OC3S8-C53-C' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%atgbics%' ) [ RunTime:0.036364s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12226655 [ RunTime:0.006733s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58150343 LIMIT 5 [ RunTime:0.014286s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58150343 ORDER BY `minOrder` ASC [ RunTime:0.013761s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58150343 ORDER BY `unit` DESC [ RunTime:0.009761s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58150343 LIMIT 2 [ RunTime:0.018950s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58150343 ORDER BY `minOrder` ASC [ RunTime:0.009968s ]
select * from pdf where partno='TN-SFP-OC3S8-C43-C' and brandshort='ATGBICS' limit 1 [ RunTime:0.014758s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TN-SFP-OC3S8-C43-C' OR `brand` LIKE 'ATGBICS%' ) ) LIMIT 1 [ RunTime:0.006302s ]
SELECT `id` FROM `stock` WHERE `id` <> 58150343 AND `partno` = 'TN-SFP-OC3S8-C43-C' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%atgbics%' ) [ RunTime:0.009104s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12226657 [ RunTime:0.010437s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58150344 LIMIT 5 [ RunTime:0.022899s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58150344 ORDER BY `minOrder` ASC [ RunTime:0.001681s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58150344 ORDER BY `unit` DESC [ RunTime:0.002307s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58150344 LIMIT 2 [ RunTime:0.006508s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58150344 ORDER BY `minOrder` ASC [ RunTime:0.004173s ]
select * from pdf where partno='TN-SFP-OC3S8-C55-C' and brandshort='ATGBICS' limit 1 [ RunTime:0.007182s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TN-SFP-OC3S8-C55-C' OR `brand` LIKE 'ATGBICS%' ) ) LIMIT 1 [ RunTime:0.019901s ]
SELECT `id` FROM `stock` WHERE `id` <> 58150344 AND `partno` = 'TN-SFP-OC3S8-C55-C' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%atgbics%' ) [ RunTime:0.021513s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12226652 [ RunTime:0.022051s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58150346 LIMIT 5 [ RunTime:0.002636s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58150346 ORDER BY `minOrder` ASC [ RunTime:0.000819s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58150346 ORDER BY `unit` DESC [ RunTime:0.015494s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58150346 LIMIT 2 [ RunTime:0.007845s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58150346 ORDER BY `minOrder` ASC [ RunTime:0.008494s ]
select * from pdf where partno='TN-SFP-OC3S8-C47-C' and brandshort='ATGBICS' limit 1 [ RunTime:0.005458s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TN-SFP-OC3S8-C47-C' OR `brand` LIKE 'ATGBICS%' ) ) LIMIT 1 [ RunTime:0.011906s ]
SELECT `id` FROM `stock` WHERE `id` <> 58150346 AND `partno` = 'TN-SFP-OC3S8-C47-C' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%atgbics%' ) [ RunTime:0.021137s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12226653 [ RunTime:0.032033s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58150347 LIMIT 5 [ RunTime:0.008231s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58150347 ORDER BY `minOrder` ASC [ RunTime:0.004731s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58150347 ORDER BY `unit` DESC [ RunTime:0.006292s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58150347 LIMIT 2 [ RunTime:0.003219s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58150347 ORDER BY `minOrder` ASC [ RunTime:0.006774s ]
select * from pdf where partno='TN-SFP-OC3S8-C61-C' and brandshort='ATGBICS' limit 1 [ RunTime:0.012351s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TN-SFP-OC3S8-C61-C' OR `brand` LIKE 'ATGBICS%' ) ) LIMIT 1 [ RunTime:0.020788s ]
SELECT `id` FROM `stock` WHERE `id` <> 58150347 AND `partno` = 'TN-SFP-OC3S8-C61-C' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%atgbics%' ) [ RunTime:0.016549s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12226662 [ RunTime:0.001647s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58150348 LIMIT 5 [ RunTime:0.004315s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58150348 ORDER BY `minOrder` ASC [ RunTime:0.011872s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58150348 ORDER BY `unit` DESC [ RunTime:0.027007s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58150348 LIMIT 2 [ RunTime:0.002385s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58150348 ORDER BY `minOrder` ASC [ RunTime:0.010530s ]
select * from pdf where partno='TN-SFP-OC3S8-C59-C' and brandshort='ATGBICS' limit 1 [ RunTime:0.000869s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TN-SFP-OC3S8-C59-C' OR `brand` LIKE 'ATGBICS%' ) ) LIMIT 1 [ RunTime:0.007408s ]
SELECT `id` FROM `stock` WHERE `id` <> 58150348 AND `partno` = 'TN-SFP-OC3S8-C59-C' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%atgbics%' ) [ RunTime:0.014403s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12226660 [ RunTime:0.025791s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58147859 LIMIT 5 [ RunTime:0.039555s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58147859 ORDER BY `minOrder` ASC [ RunTime:0.015662s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58147859 ORDER BY `unit` DESC [ RunTime:0.014059s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58147859 LIMIT 2 [ RunTime:0.000650s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58147859 ORDER BY `minOrder` ASC [ RunTime:0.003140s ]
select * from pdf where partno='TN-SFP-OC3S8-C' and brandshort='ATGBICS' limit 1 [ RunTime:0.021888s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TN-SFP-OC3S8-C' OR `brand` LIKE 'ATGBICS%' ) ) LIMIT 1 [ RunTime:0.021360s ]
SELECT `id` FROM `stock` WHERE `id` <> 58147859 AND `partno` = 'TN-SFP-OC3S8-C' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%atgbics%' ) [ RunTime:0.006960s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12225560 [ RunTime:0.009184s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58150349 LIMIT 5 [ RunTime:0.013984s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58150349 ORDER BY `minOrder` ASC [ RunTime:0.011976s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58150349 ORDER BY `unit` DESC [ RunTime:0.002866s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58150349 LIMIT 2 [ RunTime:0.005950s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58150349 ORDER BY `minOrder` ASC [ RunTime:0.002666s ]
select * from pdf where partno='TN-SFP-OC3S8-C37-C' and brandshort='ATGBICS' limit 1 [ RunTime:0.009501s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TN-SFP-OC3S8-C37-C' OR `brand` LIKE 'ATGBICS%' ) ) LIMIT 1 [ RunTime:0.016224s ]
SELECT `id` FROM `stock` WHERE `id` <> 58150349 AND `partno` = 'TN-SFP-OC3S8-C37-C' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%atgbics%' ) [ RunTime:0.053927s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12226663 [ RunTime:0.029979s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58150351 LIMIT 5 [ RunTime:0.020877s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58150351 ORDER BY `minOrder` ASC [ RunTime:0.003669s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58150351 ORDER BY `unit` DESC [ RunTime:0.009983s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58150351 LIMIT 2 [ RunTime:0.012457s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58150351 ORDER BY `minOrder` ASC [ RunTime:0.000486s ]
select * from pdf where partno='TN-SFP-OC3S8-C29-C' and brandshort='ATGBICS' limit 1 [ RunTime:0.016232s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TN-SFP-OC3S8-C29-C' OR `brand` LIKE 'ATGBICS%' ) ) LIMIT 1 [ RunTime:0.018394s ]
SELECT `id` FROM `stock` WHERE `id` <> 58150351 AND `partno` = 'TN-SFP-OC3S8-C29-C' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%atgbics%' ) [ RunTime:0.006817s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11226923 [ RunTime:0.011883s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58150352 LIMIT 5 [ RunTime:0.045324s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58150352 ORDER BY `minOrder` ASC [ RunTime:0.022919s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58150352 ORDER BY `unit` DESC [ RunTime:0.031436s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58150352 LIMIT 2 [ RunTime:0.023548s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58150352 ORDER BY `minOrder` ASC [ RunTime:0.029023s ]
select * from pdf where partno='TN-SFP-OC3S8-C31-C' and brandshort='ATGBICS' limit 1 [ RunTime:0.010837s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TN-SFP-OC3S8-C31-C' OR `brand` LIKE 'ATGBICS%' ) ) LIMIT 1 [ RunTime:0.027897s ]
SELECT `id` FROM `stock` WHERE `id` <> 58150352 AND `partno` = 'TN-SFP-OC3S8-C31-C' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%atgbics%' ) [ RunTime:0.024264s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11226926 [ RunTime:0.012092s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58150353 LIMIT 5 [ RunTime:0.004091s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58150353 ORDER BY `minOrder` ASC [ RunTime:0.006015s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58150353 ORDER BY `unit` DESC [ RunTime:0.011934s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58150353 LIMIT 2 [ RunTime:0.008071s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58150353 ORDER BY `minOrder` ASC [ RunTime:0.002934s ]
select * from pdf where partno='TN-SFP-OC3S8-C33-C' and brandshort='ATGBICS' limit 1 [ RunTime:0.005985s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TN-SFP-OC3S8-C33-C' OR `brand` LIKE 'ATGBICS%' ) ) LIMIT 1 [ RunTime:0.015539s ]
SELECT `id` FROM `stock` WHERE `id` <> 58150353 AND `partno` = 'TN-SFP-OC3S8-C33-C' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%atgbics%' ) [ RunTime:0.008336s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44256856 LIMIT 5 [ RunTime:0.002089s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44256856 ORDER BY `minOrder` ASC [ RunTime:0.014996s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44256856 ORDER BY `unit` DESC [ RunTime:0.010601s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44256856 LIMIT 2 [ RunTime:0.000605s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44256856 ORDER BY `minOrder` ASC [ RunTime:0.002736s ]
select * from pdf where partno='TN-SFP-OC3S8-C55' and brandshort='Lantronix, Inc.' limit 1 [ RunTime:0.001272s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TN-SFP-OC3S8-C55' OR `brand` LIKE 'Lantronix, Inc.%' ) ) LIMIT 1 [ RunTime:0.004244s ]
SELECT `id` FROM `stock` WHERE `id` <> 44256856 AND `partno` = 'TN-SFP-OC3S8-C55' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lantronix, inc.%' ) [ RunTime:0.014450s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12223240 [ RunTime:0.002662s ]
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 'TN-SFP-OC3S8%' OR `brand` LIKE 'TN-SFP-OC3S8%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001155s ]
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 'TN-SFP-OC3S8%' OR `brand` LIKE 'TN-SFP-OC3S8%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010967s ]
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 'TN-SFP-OC3S8%' OR `brand` LIKE 'TN-SFP-OC3S8%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.018499s ]
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 'TN-SFP-OC3S8%' OR `brand` LIKE 'TN-SFP-OC3S8%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001177s ]
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 'TN-SFP-OC3S8%' OR `brand` LIKE 'TN-SFP-OC3S8%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007089s ]
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 'TN-SFP-OC3S8%' OR `brand` LIKE 'TN-SFP-OC3S8%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004445s ]
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 'TN-SFP-OC3S8%' OR `brand` LIKE 'TN-SFP-OC3S8%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005417s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'TN-SFP-OC3S8%' OR `brand` LIKE 'TN-SFP-OC3S8%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.002287s ]