SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002501s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.133' , `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=6N137&search=1' [ RunTime:0.034364s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002161s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.020194s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002459s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.133' ) [ RunTime:0.012840s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002543s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.003059s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002463s ]
SELECT * FROM `stock_search` WHERE `partno` = '6N137' LIMIT 1 [ RunTime:0.039432s ]
UPDATE `stock_search` SET `count` = 8 , `updatetime` = '2026-08-27 19:17:24' WHERE `partno` = '6N137' [ RunTime:0.023706s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002633s ]
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 '6N137%' OR `brand` LIKE '6N137%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.068926s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.017961s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12155944 LIMIT 5 [ RunTime:0.013150s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.005637s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12155944 ORDER BY `minOrder` ASC [ RunTime:0.031160s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.009296s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12155944 ORDER BY `unit` DESC [ RunTime:0.016098s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.015808s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12155944 LIMIT 2 [ RunTime:0.025674s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12155944 ORDER BY `minOrder` ASC [ RunTime:0.016999s ]
select * from pdf where partno='6N137S' and brandshort='UMW' limit 1 [ RunTime:0.023777s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12155943 LIMIT 5 [ RunTime:0.024704s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12155943 ORDER BY `minOrder` ASC [ RunTime:0.018935s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12155943 ORDER BY `unit` DESC [ RunTime:0.027229s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12155943 LIMIT 2 [ RunTime:0.060718s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12155943 ORDER BY `minOrder` ASC [ RunTime:0.004735s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12157142 LIMIT 5 [ RunTime:0.018710s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12157142 ORDER BY `minOrder` ASC [ RunTime:0.062826s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12157142 ORDER BY `unit` DESC [ RunTime:0.040859s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12157142 LIMIT 2 [ RunTime:0.012330s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12157142 ORDER BY `minOrder` ASC [ RunTime:0.008478s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12156860 LIMIT 5 [ RunTime:0.036855s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12156860 ORDER BY `minOrder` ASC [ RunTime:0.021133s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12156860 ORDER BY `unit` DESC [ RunTime:0.046721s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12156860 LIMIT 2 [ RunTime:0.010544s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12156860 ORDER BY `minOrder` ASC [ RunTime:0.002816s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14899 LIMIT 5 [ RunTime:0.015504s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14899 ORDER BY `minOrder` ASC [ RunTime:0.041414s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14899 ORDER BY `unit` DESC [ RunTime:0.011505s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14899 LIMIT 2 [ RunTime:0.011085s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14899 ORDER BY `minOrder` ASC [ RunTime:0.018364s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001772s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6N137-000E' OR `brand` LIKE 'BROADCOM%' ) ) LIMIT 1 [ RunTime:0.049844s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12155952 LIMIT 5 [ RunTime:0.057788s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12155952 ORDER BY `minOrder` ASC [ RunTime:0.071273s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12155952 ORDER BY `unit` DESC [ RunTime:0.018450s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12155952 LIMIT 2 [ RunTime:0.023928s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12155952 ORDER BY `minOrder` ASC [ RunTime:0.010249s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12157158 LIMIT 5 [ RunTime:0.023540s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12157158 ORDER BY `minOrder` ASC [ RunTime:0.027773s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12157158 ORDER BY `unit` DESC [ RunTime:0.017921s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12157158 LIMIT 2 [ RunTime:0.035819s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12157158 ORDER BY `minOrder` ASC [ RunTime:0.008669s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20146938 LIMIT 5 [ RunTime:0.040748s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20146938 ORDER BY `minOrder` ASC [ RunTime:0.048851s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 20146938 ORDER BY `unit` DESC [ RunTime:0.038880s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 20146938 LIMIT 2 [ RunTime:0.025881s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20146938 ORDER BY `minOrder` ASC [ RunTime:0.023604s ]
select * from pdf where partno='6N137S' and brandshort='UMW' limit 1 [ RunTime:0.033146s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6N137S' OR `brand` LIKE 'UMW(友台半导体)%' ) ) LIMIT 1 [ RunTime:0.007308s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12156867 LIMIT 5 [ RunTime:0.013406s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12156867 ORDER BY `minOrder` ASC [ RunTime:0.006620s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12156867 ORDER BY `unit` DESC [ RunTime:0.006432s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12156867 LIMIT 2 [ RunTime:0.001528s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12156867 ORDER BY `minOrder` ASC [ RunTime:0.003105s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12157146 LIMIT 5 [ RunTime:0.002254s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12157146 ORDER BY `minOrder` ASC [ RunTime:0.007667s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12157146 ORDER BY `unit` DESC [ RunTime:0.001477s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12157146 LIMIT 2 [ RunTime:0.006404s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12157146 ORDER BY `minOrder` ASC [ RunTime:0.001520s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12156783 LIMIT 5 [ RunTime:0.001047s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12156783 ORDER BY `minOrder` ASC [ RunTime:0.001607s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12156783 ORDER BY `unit` DESC [ RunTime:0.006568s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12156783 LIMIT 2 [ RunTime:0.002041s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12156783 ORDER BY `minOrder` ASC [ RunTime:0.000525s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11176620 LIMIT 5 [ RunTime:0.012792s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11176620 ORDER BY `minOrder` ASC [ RunTime:0.002245s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11176620 ORDER BY `unit` DESC [ RunTime:0.001217s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11176620 LIMIT 2 [ RunTime:0.005612s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11176620 ORDER BY `minOrder` ASC [ RunTime:0.006004s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12156889 LIMIT 5 [ RunTime:0.001429s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12156889 ORDER BY `minOrder` ASC [ RunTime:0.001668s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12156889 ORDER BY `unit` DESC [ RunTime:0.012463s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12156889 LIMIT 2 [ RunTime:0.008730s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12156889 ORDER BY `minOrder` ASC [ RunTime:0.004866s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12157113 LIMIT 5 [ RunTime:0.006594s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12157113 ORDER BY `minOrder` ASC [ RunTime:0.003386s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12157113 ORDER BY `unit` DESC [ RunTime:0.007153s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12157113 LIMIT 2 [ RunTime:0.006698s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12157113 ORDER BY `minOrder` ASC [ RunTime:0.000562s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20146937 LIMIT 5 [ RunTime:0.000954s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20146937 ORDER BY `minOrder` ASC [ RunTime:0.000836s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 20146937 ORDER BY `unit` DESC [ RunTime:0.002239s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 20146937 LIMIT 2 [ RunTime:0.004993s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20146937 ORDER BY `minOrder` ASC [ RunTime:0.000887s ]
select * from pdf where partno='6N137M' and brandshort='UMW' limit 1 [ RunTime:0.001660s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6N137M' OR `brand` LIKE 'UMW(友台半导体)%' ) ) LIMIT 1 [ RunTime:0.009743s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 7397 LIMIT 5 [ RunTime:0.001201s ]
SELECT * FROM `stock_price` WHERE `stockid` = 7397 ORDER BY `minOrder` ASC [ RunTime:0.001815s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 7397 ORDER BY `unit` DESC [ RunTime:0.004655s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 7397 LIMIT 2 [ RunTime:0.004162s ]
SELECT * FROM `stock_price` WHERE `stockid` = 7397 ORDER BY `minOrder` ASC [ RunTime:0.000456s ]
select * from pdf where partno='6N137M' and brandshort='UMW' limit 1 [ RunTime:0.000625s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6N137M' OR `brand` LIKE 'UMW(友台半导体)%' ) ) LIMIT 1 [ RunTime:0.000698s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11176848 LIMIT 5 [ RunTime:0.001177s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11176848 ORDER BY `minOrder` ASC [ RunTime:0.006975s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11176848 ORDER BY `unit` DESC [ RunTime:0.003010s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11176848 LIMIT 2 [ RunTime:0.006156s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11176848 ORDER BY `minOrder` ASC [ RunTime:0.000503s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12156477 LIMIT 5 [ RunTime:0.001060s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12156477 ORDER BY `minOrder` ASC [ RunTime:0.000773s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12156477 ORDER BY `unit` DESC [ RunTime:0.000648s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12156477 LIMIT 2 [ RunTime:0.007380s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12156477 ORDER BY `minOrder` ASC [ RunTime:0.002833s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11177014 LIMIT 5 [ RunTime:0.009855s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11177014 ORDER BY `minOrder` ASC [ RunTime:0.005485s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11177014 ORDER BY `unit` DESC [ RunTime:0.005517s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11177014 LIMIT 2 [ RunTime:0.005874s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11177014 ORDER BY `minOrder` ASC [ RunTime:0.004650s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11176842 LIMIT 5 [ RunTime:0.009694s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11176842 ORDER BY `minOrder` ASC [ RunTime:0.016806s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11176842 ORDER BY `unit` DESC [ RunTime:0.017477s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11176842 LIMIT 2 [ RunTime:0.000809s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11176842 ORDER BY `minOrder` ASC [ RunTime:0.000491s ]
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 '6N137%' OR `brand` LIKE '6N137%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013491s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51050335 LIMIT 5 [ RunTime:0.016665s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51050335 ORDER BY `minOrder` ASC [ RunTime:0.019656s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51050335 ORDER BY `unit` DESC [ RunTime:0.007695s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51050335 LIMIT 2 [ RunTime:0.012046s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51050335 ORDER BY `minOrder` ASC [ RunTime:0.010113s ]
select * from pdf where partno='6n137-500e' and brandshort='broadcom / avago' limit 1 [ RunTime:0.002110s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6n137-500e' OR `brand` LIKE 'broadcom / avago%' ) ) LIMIT 1 [ RunTime:0.015899s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51051158 LIMIT 5 [ RunTime:0.006815s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51051158 ORDER BY `minOrder` ASC [ RunTime:0.001509s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51051158 ORDER BY `unit` DESC [ RunTime:0.000498s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51051158 LIMIT 2 [ RunTime:0.000450s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51051158 ORDER BY `minOrder` ASC [ RunTime:0.001802s ]
select * from pdf where partno='6n137-x006' and brandshort='vishay semiconductors' limit 1 [ RunTime:0.017473s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6n137-x006' OR `brand` LIKE 'vishay semiconductors%' ) ) LIMIT 1 [ RunTime:0.005709s ]
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 '6N137%' OR `brand` LIKE '6N137%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014437s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64257525 LIMIT 5 [ RunTime:0.003566s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64257525 ORDER BY `minOrder` ASC [ RunTime:0.004161s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64257525 ORDER BY `unit` DESC [ RunTime:0.001317s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64257525 LIMIT 2 [ RunTime:0.000416s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64257525 ORDER BY `minOrder` ASC [ RunTime:0.000299s ]
select * from pdf where partno='6N137' and brandshort='Lite-On Inc.' limit 1 [ RunTime:0.001842s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6N137' OR `brand` LIKE 'Lite-On Inc.%' ) ) LIMIT 1 [ RunTime:0.009440s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64257512 LIMIT 5 [ RunTime:0.006511s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64257512 ORDER BY `minOrder` ASC [ RunTime:0.015692s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64257512 ORDER BY `unit` DESC [ RunTime:0.000747s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64257512 LIMIT 2 [ RunTime:0.000547s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64257512 ORDER BY `minOrder` ASC [ RunTime:0.002143s ]
select * from pdf where partno='6N137S' and brandshort='Lite-On Inc.' limit 1 [ RunTime:0.001104s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6N137S' OR `brand` LIKE 'Lite-On Inc.%' ) ) LIMIT 1 [ RunTime:0.007208s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64257669 LIMIT 5 [ RunTime:0.001208s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64257669 ORDER BY `minOrder` ASC [ RunTime:0.000976s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64257669 ORDER BY `unit` DESC [ RunTime:0.000506s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64257669 LIMIT 2 [ RunTime:0.000498s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64257669 ORDER BY `minOrder` ASC [ RunTime:0.001883s ]
select * from pdf where partno='6N137-500E' and brandshort='Broadcom Limited' limit 1 [ RunTime:0.002866s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6N137-500E' OR `brand` LIKE 'Broadcom Limited%' ) ) LIMIT 1 [ RunTime:0.000644s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64258255 LIMIT 5 [ RunTime:0.000443s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64258255 ORDER BY `minOrder` ASC [ RunTime:0.000925s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64258255 ORDER BY `unit` DESC [ RunTime:0.000410s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64258255 LIMIT 2 [ RunTime:0.000575s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64258255 ORDER BY `minOrder` ASC [ RunTime:0.000335s ]
select * from pdf where partno='6N137SD' and brandshort='Fairchild Semiconductor' limit 1 [ RunTime:0.001315s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6N137SD' OR `brand` LIKE 'Fairchild Semiconductor%' ) ) LIMIT 1 [ RunTime:0.004870s ]
SELECT `id` FROM `stock` WHERE `id` <> 64258255 AND `partno` = '6N137SD' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%fairchild semiconductor%' ) [ RunTime:0.008065s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12157142 [ RunTime:0.003910s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64258235 LIMIT 5 [ RunTime:0.001652s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64258235 ORDER BY `minOrder` ASC [ RunTime:0.001571s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64258235 ORDER BY `unit` DESC [ RunTime:0.002598s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64258235 LIMIT 2 [ RunTime:0.000417s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64258235 ORDER BY `minOrder` ASC [ RunTime:0.000338s ]
select * from pdf where partno='6N137S' and brandshort='Shenzhen Slkormicro Semicon Co., Ltd.' limit 1 [ RunTime:0.001064s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6N137S' OR `brand` LIKE 'Shenzhen Slkormicro Semicon Co., Ltd.%' ) ) LIMIT 1 [ RunTime:0.003378s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64257534 LIMIT 5 [ RunTime:0.002001s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64257534 ORDER BY `minOrder` ASC [ RunTime:0.000436s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64257534 ORDER BY `unit` DESC [ RunTime:0.003398s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64257534 LIMIT 2 [ RunTime:0.006143s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64257534 ORDER BY `minOrder` ASC [ RunTime:0.000385s ]
select * from pdf where partno='6N137-X007T' and brandshort='Vishay Semiconductor Opto Division' limit 1 [ RunTime:0.001003s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6N137-X007T' OR `brand` LIKE 'Vishay Semiconductor Opto Division%' ) ) LIMIT 1 [ RunTime:0.008662s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64258027 LIMIT 5 [ RunTime:0.009906s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64258027 ORDER BY `minOrder` ASC [ RunTime:0.011318s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64258027 ORDER BY `unit` DESC [ RunTime:0.012348s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64258027 LIMIT 2 [ RunTime:0.012842s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64258027 ORDER BY `minOrder` ASC [ RunTime:0.019004s ]
select * from pdf where partno='6N137TSR2VM' and brandshort='onsemi' limit 1 [ RunTime:0.006942s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6N137TSR2VM' OR `brand` LIKE 'onsemi%' ) ) LIMIT 1 [ RunTime:0.027148s ]
SELECT `id` FROM `stock` WHERE `id` <> 64258027 AND `partno` = '6N137TSR2VM' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%onsemi%' ) [ RunTime:0.004191s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12156889 [ RunTime:0.012216s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64257530 LIMIT 5 [ RunTime:0.001028s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64257530 ORDER BY `minOrder` ASC [ RunTime:0.002208s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64257530 ORDER BY `unit` DESC [ RunTime:0.012709s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64257530 LIMIT 2 [ RunTime:0.004577s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64257530 ORDER BY `minOrder` ASC [ RunTime:0.015079s ]
select * from pdf where partno='6N137SDM' and brandshort='onsemi' limit 1 [ RunTime:0.010098s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6N137SDM' OR `brand` LIKE 'onsemi%' ) ) LIMIT 1 [ RunTime:0.013641s ]
SELECT `id` FROM `stock` WHERE `id` <> 64257530 AND `partno` = '6N137SDM' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%onsemi%' ) [ RunTime:0.015826s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12156860 [ RunTime:0.005138s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64258193 LIMIT 5 [ RunTime:0.002794s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64258193 ORDER BY `minOrder` ASC [ RunTime:0.014971s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64258193 ORDER BY `unit` DESC [ RunTime:0.006427s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64258193 LIMIT 2 [ RunTime:0.001519s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64258193 ORDER BY `minOrder` ASC [ RunTime:0.003012s ]
select * from pdf where partno='6N137-560E' and brandshort='Broadcom Limited' limit 1 [ RunTime:0.008757s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6N137-560E' OR `brand` LIKE 'Broadcom Limited%' ) ) LIMIT 1 [ RunTime:0.020627s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64258265 LIMIT 5 [ RunTime:0.017173s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64258265 ORDER BY `minOrder` ASC [ RunTime:0.019538s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64258265 ORDER BY `unit` DESC [ RunTime:0.018466s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64258265 LIMIT 2 [ RunTime:0.022027s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64258265 ORDER BY `minOrder` ASC [ RunTime:0.016975s ]
select * from pdf where partno='6N137S(TA)' and brandshort='Everlight Electronics Co Ltd' limit 1 [ RunTime:0.014978s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6N137S(TA)' OR `brand` LIKE 'Everlight Electronics Co Ltd%' ) ) LIMIT 1 [ RunTime:0.032540s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64257626 LIMIT 5 [ RunTime:0.063759s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64257626 ORDER BY `minOrder` ASC [ RunTime:0.018218s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64257626 ORDER BY `unit` DESC [ RunTime:0.018293s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64257626 LIMIT 2 [ RunTime:0.029056s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64257626 ORDER BY `minOrder` ASC [ RunTime:0.019855s ]
select * from pdf where partno='6N137SM' and brandshort='onsemi' limit 1 [ RunTime:0.025413s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6N137SM' OR `brand` LIKE 'onsemi%' ) ) LIMIT 1 [ RunTime:0.031131s ]
SELECT `id` FROM `stock` WHERE `id` <> 64257626 AND `partno` = '6N137SM' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%onsemi%' ) [ RunTime:0.032974s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 7398 [ RunTime:0.047023s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12156867 [ RunTime:0.033126s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64257541 LIMIT 5 [ RunTime:0.004453s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64257541 ORDER BY `minOrder` ASC [ RunTime:0.031439s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64257541 ORDER BY `unit` DESC [ RunTime:0.040121s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64257541 LIMIT 2 [ RunTime:0.034833s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64257541 ORDER BY `minOrder` ASC [ RunTime:0.010042s ]
select * from pdf where partno='6N137-000E' and brandshort='Broadcom Limited' limit 1 [ RunTime:0.013596s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6N137-000E' OR `brand` LIKE 'Broadcom Limited%' ) ) LIMIT 1 [ RunTime:0.023025s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64257680 LIMIT 5 [ RunTime:0.030313s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64257680 ORDER BY `minOrder` ASC [ RunTime:0.035023s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64257680 ORDER BY `unit` DESC [ RunTime:0.041682s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64257680 LIMIT 2 [ RunTime:0.069053s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64257680 ORDER BY `minOrder` ASC [ RunTime:0.029202s ]
select * from pdf where partno='6N137' and brandshort='Vishay Semiconductor Opto Division' limit 1 [ RunTime:0.033390s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6N137' OR `brand` LIKE 'Vishay Semiconductor Opto Division%' ) ) LIMIT 1 [ RunTime:0.039122s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64258282 LIMIT 5 [ RunTime:0.009624s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64258282 ORDER BY `minOrder` ASC [ RunTime:0.047742s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64258282 ORDER BY `unit` DESC [ RunTime:0.032303s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64258282 LIMIT 2 [ RunTime:0.020975s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64258282 ORDER BY `minOrder` ASC [ RunTime:0.014848s ]
select * from pdf where partno='6N137S1(TA)' and brandshort='Everlight Electronics Co Ltd' limit 1 [ RunTime:0.029367s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6N137S1(TA)' OR `brand` LIKE 'Everlight Electronics Co Ltd%' ) ) LIMIT 1 [ RunTime:0.062650s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64258192 LIMIT 5 [ RunTime:0.061541s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64258192 ORDER BY `minOrder` ASC [ RunTime:0.056689s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64258192 ORDER BY `unit` DESC [ RunTime:0.036994s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64258192 LIMIT 2 [ RunTime:0.040586s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64258192 ORDER BY `minOrder` ASC [ RunTime:0.019334s ]
select * from pdf where partno='6N137-020E' and brandshort='Broadcom Limited' limit 1 [ RunTime:0.079503s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6N137-020E' OR `brand` LIKE 'Broadcom Limited%' ) ) LIMIT 1 [ RunTime:0.017997s ]
SELECT `id` FROM `stock` WHERE `id` <> 64258192 AND `partno` = '6N137-020E' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%broadcom limited%' ) [ RunTime:0.023456s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11177014 [ RunTime:0.018761s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64257668 LIMIT 5 [ RunTime:0.026915s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64257668 ORDER BY `minOrder` ASC [ RunTime:0.025118s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64257668 ORDER BY `unit` DESC [ RunTime:0.067504s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64257668 LIMIT 2 [ RunTime:0.013614s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64257668 ORDER BY `minOrder` ASC [ RunTime:0.029378s ]
select * from pdf where partno='6N137' and brandshort='Isocom Components 2004 LTD' limit 1 [ RunTime:0.045772s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6N137' OR `brand` LIKE 'Isocom Components 2004 LTD%' ) ) LIMIT 1 [ RunTime:0.114949s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64257639 LIMIT 5 [ RunTime:0.120203s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64257639 ORDER BY `minOrder` ASC [ RunTime:0.102146s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64257639 ORDER BY `unit` DESC [ RunTime:0.039900s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64257639 LIMIT 2 [ RunTime:0.030910s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64257639 ORDER BY `minOrder` ASC [ RunTime:0.030209s ]
select * from pdf where partno='6N137M' and brandshort='Lite-On Inc.' limit 1 [ RunTime:0.045828s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6N137M' OR `brand` LIKE 'Lite-On Inc.%' ) ) LIMIT 1 [ RunTime:0.033116s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64258188 LIMIT 5 [ RunTime:0.037957s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64258188 ORDER BY `minOrder` ASC [ RunTime:0.039299s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64258188 ORDER BY `unit` DESC [ RunTime:0.042593s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64258188 LIMIT 2 [ RunTime:0.064822s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64258188 ORDER BY `minOrder` ASC [ RunTime:0.031094s ]
select * from pdf where partno='6N137SM' and brandshort='Isocom Components 2004 LTD' limit 1 [ RunTime:0.048213s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6N137SM' OR `brand` LIKE 'Isocom Components 2004 LTD%' ) ) LIMIT 1 [ RunTime:0.098340s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64257678 LIMIT 5 [ RunTime:0.100504s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64257678 ORDER BY `minOrder` ASC [ RunTime:0.063664s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64257678 ORDER BY `unit` DESC [ RunTime:0.073522s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64257678 LIMIT 2 [ RunTime:0.038599s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64257678 ORDER BY `minOrder` ASC [ RunTime:0.027587s ]
select * from pdf where partno='6N137M' and brandshort='onsemi' limit 1 [ RunTime:0.059485s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6N137M' OR `brand` LIKE 'onsemi%' ) ) LIMIT 1 [ RunTime:0.126002s ]
SELECT `id` FROM `stock` WHERE `id` <> 64257678 AND `partno` = '6N137M' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%onsemi%' ) [ RunTime:0.044445s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11176620 [ RunTime:0.017992s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64258534 LIMIT 5 [ RunTime:0.049991s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64258534 ORDER BY `minOrder` ASC [ RunTime:0.136289s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64258534 ORDER BY `unit` DESC [ RunTime:0.032980s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64258534 LIMIT 2 [ RunTime:0.024729s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64258534 ORDER BY `minOrder` ASC [ RunTime:0.004915s ]
select * from pdf where partno='6N137TSVM' and brandshort='Fairchild Semiconductor' limit 1 [ RunTime:0.082488s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6N137TSVM' OR `brand` LIKE 'Fairchild Semiconductor%' ) ) LIMIT 1 [ RunTime:0.051425s ]
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 '6N137%' OR `brand` LIKE '6N137%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.044399s ]
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 '6N137%' OR `brand` LIKE '6N137%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.031349s ]
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 '6N137%' OR `brand` LIKE '6N137%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.066421s ]
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 '6N137%' OR `brand` LIKE '6N137%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.069004s ]
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 '6N137%' OR `brand` LIKE '6N137%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.044934s ]
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 '6N137%' OR `brand` LIKE '6N137%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.050020s ]
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 '6N137%' OR `brand` LIKE '6N137%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.033738s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '6N137%' OR `brand` LIKE '6N137%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.053364s ]