SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002147s ]
INSERT INTO `visit_log` SET `ip` = '216.73.217.15' , `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=2&search=1' [ RunTime:0.003121s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001169s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.003453s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001458s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.15' ) [ RunTime:0.000522s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001082s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000400s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001407s ]
SELECT * FROM `stock_search` WHERE `partno` = '2' LIMIT 1 [ RunTime:0.000749s ]
UPDATE `stock_search` SET `count` = 675 , `updatetime` = '2026-10-07 20:58:50' WHERE `partno` = '2' [ RunTime:0.003732s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001062s ]
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 '2%' OR `brand` LIKE '2%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.104078s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001401s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18582433 LIMIT 5 [ RunTime:0.000763s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001038s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18582433 ORDER BY `minOrder` ASC [ RunTime:0.000470s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001564s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18582433 ORDER BY `unit` DESC [ RunTime:0.000439s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001030s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18582433 LIMIT 2 [ RunTime:0.000394s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18582433 ORDER BY `minOrder` ASC [ RunTime:0.000414s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11482092 LIMIT 5 [ RunTime:0.000734s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11482092 ORDER BY `minOrder` ASC [ RunTime:0.000417s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11482092 ORDER BY `unit` DESC [ RunTime:0.000381s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11482092 LIMIT 2 [ RunTime:0.000376s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11482092 ORDER BY `minOrder` ASC [ RunTime:0.000398s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18582432 LIMIT 5 [ RunTime:0.000408s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18582432 ORDER BY `minOrder` ASC [ RunTime:0.000419s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18582432 ORDER BY `unit` DESC [ RunTime:0.000382s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18582432 LIMIT 2 [ RunTime:0.000372s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18582432 ORDER BY `minOrder` ASC [ RunTime:0.000429s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14890867 LIMIT 5 [ RunTime:0.000665s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14890867 ORDER BY `minOrder` ASC [ RunTime:0.000403s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14890867 ORDER BY `unit` DESC [ RunTime:0.000379s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14890867 LIMIT 2 [ RunTime:0.000381s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14890867 ORDER BY `minOrder` ASC [ RunTime:0.000396s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13211672 LIMIT 5 [ RunTime:0.000741s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13211672 ORDER BY `minOrder` ASC [ RunTime:0.000406s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13211672 ORDER BY `unit` DESC [ RunTime:0.000385s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13211672 LIMIT 2 [ RunTime:0.000369s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13211672 ORDER BY `minOrder` ASC [ RunTime:0.000394s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17921684 LIMIT 5 [ RunTime:0.000711s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17921684 ORDER BY `minOrder` ASC [ RunTime:0.000411s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17921684 ORDER BY `unit` DESC [ RunTime:0.000383s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17921684 LIMIT 2 [ RunTime:0.000372s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17921684 ORDER BY `minOrder` ASC [ RunTime:0.000400s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19668092 LIMIT 5 [ RunTime:0.000636s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19668092 ORDER BY `minOrder` ASC [ RunTime:0.000415s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19668092 ORDER BY `unit` DESC [ RunTime:0.000387s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19668092 LIMIT 2 [ RunTime:0.000377s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19668092 ORDER BY `minOrder` ASC [ RunTime:0.000453s ]
select * from pdf where partno='2038638103' and brandshort='Molex' limit 1 [ RunTime:0.001686s ]
select foldpath,foldpath2,filename from pdf_file where id=1653053 limit 1 [ RunTime:0.000659s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13180034 LIMIT 5 [ RunTime:0.001004s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13180034 ORDER BY `minOrder` ASC [ RunTime:0.000634s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13180034 ORDER BY `unit` DESC [ RunTime:0.000593s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13180034 LIMIT 2 [ RunTime:0.000534s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13180034 ORDER BY `minOrder` ASC [ RunTime:0.000511s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12517379 LIMIT 5 [ RunTime:0.000925s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12517379 ORDER BY `minOrder` ASC [ RunTime:0.000517s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12517379 ORDER BY `unit` DESC [ RunTime:0.000492s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12517379 LIMIT 2 [ RunTime:0.000477s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12517379 ORDER BY `minOrder` ASC [ RunTime:0.000590s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13254771 LIMIT 5 [ RunTime:0.000775s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13254771 ORDER BY `minOrder` ASC [ RunTime:0.000514s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13254771 ORDER BY `unit` DESC [ RunTime:0.000556s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13254771 LIMIT 2 [ RunTime:0.000561s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13254771 ORDER BY `minOrder` ASC [ RunTime:0.000511s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13212459 LIMIT 5 [ RunTime:0.000833s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13212459 ORDER BY `minOrder` ASC [ RunTime:0.000622s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13212459 ORDER BY `unit` DESC [ RunTime:0.000499s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13212459 LIMIT 2 [ RunTime:0.000475s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13212459 ORDER BY `minOrder` ASC [ RunTime:0.000508s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17298776 LIMIT 5 [ RunTime:0.000820s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17298776 ORDER BY `minOrder` ASC [ RunTime:0.000522s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17298776 ORDER BY `unit` DESC [ RunTime:0.000519s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17298776 LIMIT 2 [ RunTime:0.000495s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17298776 ORDER BY `minOrder` ASC [ RunTime:0.000602s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14273902 LIMIT 5 [ RunTime:0.000966s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14273902 ORDER BY `minOrder` ASC [ RunTime:0.000493s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14273902 ORDER BY `unit` DESC [ RunTime:0.000474s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14273902 LIMIT 2 [ RunTime:0.000488s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14273902 ORDER BY `minOrder` ASC [ RunTime:0.000476s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12517381 LIMIT 5 [ RunTime:0.000474s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12517381 ORDER BY `minOrder` ASC [ RunTime:0.000477s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12517381 ORDER BY `unit` DESC [ RunTime:0.000513s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12517381 LIMIT 2 [ RunTime:0.000476s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12517381 ORDER BY `minOrder` ASC [ RunTime:0.000516s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12511907 LIMIT 5 [ RunTime:0.000835s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12511907 ORDER BY `minOrder` ASC [ RunTime:0.000504s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12511907 ORDER BY `unit` DESC [ RunTime:0.000454s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12511907 LIMIT 2 [ RunTime:0.000438s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12511907 ORDER BY `minOrder` ASC [ RunTime:0.000470s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11481413 LIMIT 5 [ RunTime:0.000775s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11481413 ORDER BY `minOrder` ASC [ RunTime:0.000486s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11481413 ORDER BY `unit` DESC [ RunTime:0.000411s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11481413 LIMIT 2 [ RunTime:0.000403s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11481413 ORDER BY `minOrder` ASC [ RunTime:0.000421s ]
select * from pdf where partno='2-963964-7' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.001227s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14370404 LIMIT 5 [ RunTime:0.000717s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14370404 ORDER BY `minOrder` ASC [ RunTime:0.000428s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14370404 ORDER BY `unit` DESC [ RunTime:0.000337s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14370404 LIMIT 2 [ RunTime:0.000336s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14370404 ORDER BY `minOrder` ASC [ RunTime:0.000355s ]
select * from pdf where partno='22759/34-20-9' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.001754s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11943763 LIMIT 5 [ RunTime:0.000567s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11943763 ORDER BY `minOrder` ASC [ RunTime:0.000357s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11943763 ORDER BY `unit` DESC [ RunTime:0.000353s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11943763 LIMIT 2 [ RunTime:0.000437s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11943763 ORDER BY `minOrder` ASC [ RunTime:0.000358s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12516371 LIMIT 5 [ RunTime:0.001144s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12516371 ORDER BY `minOrder` ASC [ RunTime:0.000431s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12516371 ORDER BY `unit` DESC [ RunTime:0.000355s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12516371 LIMIT 2 [ RunTime:0.000335s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12516371 ORDER BY `minOrder` ASC [ RunTime:0.000356s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11481946 LIMIT 5 [ RunTime:0.000567s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11481946 ORDER BY `minOrder` ASC [ RunTime:0.000423s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11481946 ORDER BY `unit` DESC [ RunTime:0.000339s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11481946 LIMIT 2 [ RunTime:0.000330s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11481946 ORDER BY `minOrder` ASC [ RunTime:0.000352s ]
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 '2%' OR `brand` LIKE '2%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.159031s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 71811705 LIMIT 5 [ RunTime:0.000746s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71811705 ORDER BY `minOrder` ASC [ RunTime:0.000393s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 71811705 ORDER BY `unit` DESC [ RunTime:0.000340s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 71811705 LIMIT 2 [ RunTime:0.000326s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71811705 ORDER BY `minOrder` ASC [ RunTime:0.000363s ]
select * from pdf where partno='2-520128-2' and brandshort='te connectivity / amp' limit 1 [ RunTime:0.001509s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001374s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2-520128-2' OR `brand` LIKE 'te connectivity / amp%' ) ) LIMIT 1 [ RunTime:0.000872s ]
SELECT `id` FROM `stock` WHERE `id` <> 71811705 AND `partno` = '2-520128-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity / amp%' ) [ RunTime:0.000845s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32281260 LIMIT 5 [ RunTime:0.000340s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32281260 ORDER BY `minOrder` ASC [ RunTime:0.000706s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32281260 ORDER BY `unit` DESC [ RunTime:0.000440s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32281260 LIMIT 2 [ RunTime:0.000398s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32281260 ORDER BY `minOrder` ASC [ RunTime:0.000475s ]
select * from pdf where partno='2-520129-2' and brandshort='te connectivity / amp' limit 1 [ RunTime:0.001045s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2-520129-2' OR `brand` LIKE 'te connectivity / amp%' ) ) LIMIT 1 [ RunTime:0.000607s ]
SELECT `id` FROM `stock` WHERE `id` <> 32281260 AND `partno` = '2-520129-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity / amp%' ) [ RunTime:0.000578s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 71697976 LIMIT 5 [ RunTime:0.000349s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71697976 ORDER BY `minOrder` ASC [ RunTime:0.000902s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 71697976 ORDER BY `unit` DESC [ RunTime:0.000355s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 71697976 LIMIT 2 [ RunTime:0.000330s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71697976 ORDER BY `minOrder` ASC [ RunTime:0.000397s ]
select * from pdf where partno='2512065007y6' and brandshort='fair-rite' limit 1 [ RunTime:0.001353s ]
select foldpath,foldpath2,filename from pdf_file where id=1984224 limit 1 [ RunTime:0.000588s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2512065007y6' OR `brand` LIKE 'fair-rite%' ) ) LIMIT 1 [ RunTime:0.001261s ]
SELECT `id` FROM `stock` WHERE `id` <> 71697976 AND `partno` = '2512065007y6' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%fair-rite%' ) [ RunTime:0.000882s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 71693944 [ RunTime:0.000345s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 70931499 [ RunTime:0.000394s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 71693944 LIMIT 5 [ RunTime:0.000347s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71693944 ORDER BY `minOrder` ASC [ RunTime:0.000699s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 71693944 ORDER BY `unit` DESC [ RunTime:0.000418s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 71693944 LIMIT 2 [ RunTime:0.000328s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71693944 ORDER BY `minOrder` ASC [ RunTime:0.000392s ]
select * from pdf where partno='2512065007y6' and brandshort='fair-rite' limit 1 [ RunTime:0.000633s ]
select foldpath,foldpath2,filename from pdf_file where id=1984224 limit 1 [ RunTime:0.000367s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2512065007y6' OR `brand` LIKE 'fair-rite%' ) ) LIMIT 1 [ RunTime:0.000610s ]
SELECT `id` FROM `stock` WHERE `id` <> 71693944 AND `partno` = '2512065007y6' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%fair-rite%' ) [ RunTime:0.000465s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 71697976 [ RunTime:0.000344s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 70931499 [ RunTime:0.000324s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 71797472 LIMIT 5 [ RunTime:0.000324s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71797472 ORDER BY `minOrder` ASC [ RunTime:0.000358s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 71797472 ORDER BY `unit` DESC [ RunTime:0.000330s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 71797472 LIMIT 2 [ RunTime:0.000360s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71797472 ORDER BY `minOrder` ASC [ RunTime:0.000409s ]
select * from pdf where partno='2-2287720-1' and brandshort='te connectivity' limit 1 [ RunTime:0.001134s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2-2287720-1' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.008809s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32281271 LIMIT 5 [ RunTime:0.000454s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32281271 ORDER BY `minOrder` ASC [ RunTime:0.000491s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32281271 ORDER BY `unit` DESC [ RunTime:0.000358s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32281271 LIMIT 2 [ RunTime:0.000392s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32281271 ORDER BY `minOrder` ASC [ RunTime:0.000385s ]
select * from pdf where partno='2-520182-2' and brandshort='te connectivity / amp' limit 1 [ RunTime:0.000923s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2-520182-2' OR `brand` LIKE 'te connectivity / amp%' ) ) LIMIT 1 [ RunTime:0.000552s ]
SELECT `id` FROM `stock` WHERE `id` <> 32281271 AND `partno` = '2-520182-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity / amp%' ) [ RunTime:0.000450s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32267153 LIMIT 5 [ RunTime:0.000340s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32267153 ORDER BY `minOrder` ASC [ RunTime:0.000680s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32267153 ORDER BY `unit` DESC [ RunTime:0.000357s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32267153 LIMIT 2 [ RunTime:0.000326s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32267153 ORDER BY `minOrder` ASC [ RunTime:0.000369s ]
select * from pdf where partno='2098762-1' and brandshort='te connectivity / amp' limit 1 [ RunTime:0.001201s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2098762-1' OR `brand` LIKE 'te connectivity / amp%' ) ) LIMIT 1 [ RunTime:0.000405s ]
SELECT `id` FROM `stock` WHERE `id` <> 32267153 AND `partno` = '2098762-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity / amp%' ) [ RunTime:0.000852s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51126515 LIMIT 5 [ RunTime:0.000381s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51126515 ORDER BY `minOrder` ASC [ RunTime:0.000785s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51126515 ORDER BY `unit` DESC [ RunTime:0.000342s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51126515 LIMIT 2 [ RunTime:0.000344s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51126515 ORDER BY `minOrder` ASC [ RunTime:0.000403s ]
select * from pdf where partno='2643004801' and brandshort='fair-rite' limit 1 [ RunTime:0.001355s ]
select foldpath,foldpath2,filename from pdf_file where id=1183624 limit 1 [ RunTime:0.000716s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2643004801' OR `brand` LIKE 'fair-rite%' ) ) LIMIT 1 [ RunTime:0.000826s ]
SELECT `id` FROM `stock` WHERE `id` <> 51126515 AND `partno` = '2643004801' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%fair-rite%' ) [ RunTime:0.000816s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51113871 [ RunTime:0.000423s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11943530 [ RunTime:0.002024s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51113871 LIMIT 5 [ RunTime:0.000411s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51113871 ORDER BY `minOrder` ASC [ RunTime:0.000712s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51113871 ORDER BY `unit` DESC [ RunTime:0.000406s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51113871 LIMIT 2 [ RunTime:0.000354s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51113871 ORDER BY `minOrder` ASC [ RunTime:0.000387s ]
select * from pdf where partno='2643004801' and brandshort='fair-rite' limit 1 [ RunTime:0.000582s ]
select foldpath,foldpath2,filename from pdf_file where id=1183624 limit 1 [ RunTime:0.000301s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2643004801' OR `brand` LIKE 'fair-rite%' ) ) LIMIT 1 [ RunTime:0.000647s ]
SELECT `id` FROM `stock` WHERE `id` <> 51113871 AND `partno` = '2643004801' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%fair-rite%' ) [ RunTime:0.000471s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51126515 [ RunTime:0.000337s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11943530 [ RunTime:0.000419s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 71811645 LIMIT 5 [ RunTime:0.000398s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71811645 ORDER BY `minOrder` ASC [ RunTime:0.000438s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 71811645 ORDER BY `unit` DESC [ RunTime:0.000405s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 71811645 LIMIT 2 [ RunTime:0.000355s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71811645 ORDER BY `minOrder` ASC [ RunTime:0.000346s ]
select * from pdf where partno='2-520102-1' and brandshort='te connectivity / amp' limit 1 [ RunTime:0.000836s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2-520102-1' OR `brand` LIKE 'te connectivity / amp%' ) ) LIMIT 1 [ RunTime:0.000482s ]
SELECT `id` FROM `stock` WHERE `id` <> 71811645 AND `partno` = '2-520102-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity / amp%' ) [ RunTime:0.000502s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 71601769 LIMIT 5 [ RunTime:0.000333s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71601769 ORDER BY `minOrder` ASC [ RunTime:0.000730s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 71601769 ORDER BY `unit` DESC [ RunTime:0.000346s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 71601769 LIMIT 2 [ RunTime:0.000324s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71601769 ORDER BY `minOrder` ASC [ RunTime:0.000385s ]
select * from pdf where partno='2sc4738-y,lf' and brandshort='toshiba' limit 1 [ RunTime:0.001474s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2sc4738-y,lf' OR `brand` LIKE 'toshiba%' ) ) LIMIT 1 [ RunTime:0.003854s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 71807844 LIMIT 5 [ RunTime:0.000346s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71807844 ORDER BY `minOrder` ASC [ RunTime:0.000355s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 71807844 ORDER BY `unit` DESC [ RunTime:0.000411s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 71807844 LIMIT 2 [ RunTime:0.000327s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71807844 ORDER BY `minOrder` ASC [ RunTime:0.000347s ]
select * from pdf where partno='203863-8103' and brandshort='molex' limit 1 [ RunTime:0.000722s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '203863-8103' OR `brand` LIKE 'molex%' ) ) LIMIT 1 [ RunTime:0.010118s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 71812189 LIMIT 5 [ RunTime:0.000363s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71812189 ORDER BY `minOrder` ASC [ RunTime:0.000356s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 71812189 ORDER BY `unit` DESC [ RunTime:0.000342s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 71812189 LIMIT 2 [ RunTime:0.000321s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71812189 ORDER BY `minOrder` ASC [ RunTime:0.000340s ]
select * from pdf where partno='280002-1' and brandshort='te connectivity / raychem' limit 1 [ RunTime:0.004275s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '280002-1' OR `brand` LIKE 'te connectivity / raychem%' ) ) LIMIT 1 [ RunTime:0.001819s ]
SELECT `id` FROM `stock` WHERE `id` <> 71812189 AND `partno` = '280002-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity / raychem%' ) [ RunTime:0.002186s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 71620629 LIMIT 5 [ RunTime:0.000366s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71620629 ORDER BY `minOrder` ASC [ RunTime:0.000836s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 71620629 ORDER BY `unit` DESC [ RunTime:0.000366s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 71620629 LIMIT 2 [ RunTime:0.000345s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71620629 ORDER BY `minOrder` ASC [ RunTime:0.000442s ]
select * from pdf where partno='24cw320t-i/ot' and brandshort='microchip technology' limit 1 [ RunTime:0.001382s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '24cw320t-i/ot' OR `brand` LIKE 'microchip technology%' ) ) LIMIT 1 [ RunTime:0.002937s ]
SELECT `id` FROM `stock` WHERE `id` <> 71620629 AND `partno` = '24cw320t-i/ot' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%microchip technology%' ) [ RunTime:0.000619s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15279226 [ RunTime:0.000809s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 71835776 LIMIT 5 [ RunTime:0.000352s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71835776 ORDER BY `minOrder` ASC [ RunTime:0.000416s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 71835776 ORDER BY `unit` DESC [ RunTime:0.000406s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 71835776 LIMIT 2 [ RunTime:0.000335s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71835776 ORDER BY `minOrder` ASC [ RunTime:0.000358s ]
select * from pdf where partno='24cw320t-i/ot' and brandshort='microchip technology' limit 1 [ RunTime:0.000500s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '24cw320t-i/ot' OR `brand` LIKE 'microchip technology%' ) ) LIMIT 1 [ RunTime:0.000463s ]
SELECT `id` FROM `stock` WHERE `id` <> 71835776 AND `partno` = '24cw320t-i/ot' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%microchip technology%' ) [ RunTime:0.000502s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15279226 [ RunTime:0.000373s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 71811661 LIMIT 5 [ RunTime:0.000417s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71811661 ORDER BY `minOrder` ASC [ RunTime:0.000366s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 71811661 ORDER BY `unit` DESC [ RunTime:0.000344s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 71811661 LIMIT 2 [ RunTime:0.000335s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71811661 ORDER BY `minOrder` ASC [ RunTime:0.000377s ]
select * from pdf where partno='2-520856-2' and brandshort='te connectivity / amp' limit 1 [ RunTime:0.000568s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2-520856-2' OR `brand` LIKE 'te connectivity / amp%' ) ) LIMIT 1 [ RunTime:0.001315s ]
SELECT `id` FROM `stock` WHERE `id` <> 71811661 AND `partno` = '2-520856-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity / amp%' ) [ RunTime:0.002908s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 71811652 LIMIT 5 [ RunTime:0.000357s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71811652 ORDER BY `minOrder` ASC [ RunTime:0.000365s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 71811652 ORDER BY `unit` DESC [ RunTime:0.000399s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 71811652 LIMIT 2 [ RunTime:0.000375s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71811652 ORDER BY `minOrder` ASC [ RunTime:0.000355s ]
select * from pdf where partno='2-520261-2' and brandshort='te connectivity / amp' limit 1 [ RunTime:0.000492s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2-520261-2' OR `brand` LIKE 'te connectivity / amp%' ) ) LIMIT 1 [ RunTime:0.000535s ]
SELECT `id` FROM `stock` WHERE `id` <> 71811652 AND `partno` = '2-520261-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity / amp%' ) [ RunTime:0.000436s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 71811736 LIMIT 5 [ RunTime:0.000350s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71811736 ORDER BY `minOrder` ASC [ RunTime:0.000363s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 71811736 ORDER BY `unit` DESC [ RunTime:0.000341s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 71811736 LIMIT 2 [ RunTime:0.000334s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71811736 ORDER BY `minOrder` ASC [ RunTime:0.000434s ]
select * from pdf where partno='280002-2' and brandshort='te connectivity / raychem' limit 1 [ RunTime:0.000569s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '280002-2' OR `brand` LIKE 'te connectivity / raychem%' ) ) LIMIT 1 [ RunTime:0.000432s ]
SELECT `id` FROM `stock` WHERE `id` <> 71811736 AND `partno` = '280002-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity / raychem%' ) [ RunTime:0.000450s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51131323 LIMIT 5 [ RunTime:0.000351s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51131323 ORDER BY `minOrder` ASC [ RunTime:0.000775s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51131323 ORDER BY `unit` DESC [ RunTime:0.000425s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51131323 LIMIT 2 [ RunTime:0.000425s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51131323 ORDER BY `minOrder` ASC [ RunTime:0.000453s ]
select * from pdf where partno='28b0141-000' and brandshort='laird technologies' limit 1 [ RunTime:0.000715s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '28b0141-000' OR `brand` LIKE 'laird technologies%' ) ) LIMIT 1 [ RunTime:0.000760s ]
SELECT `id` FROM `stock` WHERE `id` <> 51131323 AND `partno` = '28b0141-000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%laird technologies%' ) [ RunTime:0.000474s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51126320 [ RunTime:0.000359s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51126320 LIMIT 5 [ RunTime:0.000343s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51126320 ORDER BY `minOrder` ASC [ RunTime:0.000666s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51126320 ORDER BY `unit` DESC [ RunTime:0.000356s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51126320 LIMIT 2 [ RunTime:0.000342s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51126320 ORDER BY `minOrder` ASC [ RunTime:0.000450s ]
select * from pdf where partno='28b0141-000' and brandshort='laird technologies' limit 1 [ RunTime:0.000735s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '28b0141-000' OR `brand` LIKE 'laird technologies%' ) ) LIMIT 1 [ RunTime:0.000417s ]
SELECT `id` FROM `stock` WHERE `id` <> 51126320 AND `partno` = '28b0141-000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%laird technologies%' ) [ RunTime:0.000460s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51131323 [ RunTime:0.000355s ]
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 '2%' OR `brand` LIKE '2%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.043008s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 65419247 LIMIT 5 [ RunTime:0.000659s ]
SELECT * FROM `stock_price` WHERE `stockid` = 65419247 ORDER BY `minOrder` ASC [ RunTime:0.000799s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 65419247 ORDER BY `unit` DESC [ RunTime:0.000351s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 65419247 LIMIT 2 [ RunTime:0.000325s ]
SELECT * FROM `stock_price` WHERE `stockid` = 65419247 ORDER BY `minOrder` ASC [ RunTime:0.000349s ]
select * from pdf where partno='2SC1623A-T1B-AT' and brandshort='Renesas Electronics Corporation' limit 1 [ RunTime:0.001305s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2SC1623A-T1B-AT' OR `brand` LIKE 'Renesas Electronics Corporation%' ) ) LIMIT 1 [ RunTime:0.000446s ]
SELECT `id` FROM `stock` WHERE `id` <> 65419247 AND `partno` = '2SC1623A-T1B-AT' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%renesas electronics corporation%' ) [ RunTime:0.000838s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 65419055 LIMIT 5 [ RunTime:0.000331s ]
SELECT * FROM `stock_price` WHERE `stockid` = 65419055 ORDER BY `minOrder` ASC [ RunTime:0.000474s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 65419055 ORDER BY `unit` DESC [ RunTime:0.000387s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 65419055 LIMIT 2 [ RunTime:0.000317s ]
SELECT * FROM `stock_price` WHERE `stockid` = 65419055 ORDER BY `minOrder` ASC [ RunTime:0.000349s ]
select * from pdf where partno='2SA812A-T1B-AT' and brandshort='Renesas Electronics Corporation' limit 1 [ RunTime:0.001199s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2SA812A-T1B-AT' OR `brand` LIKE 'Renesas Electronics Corporation%' ) ) LIMIT 1 [ RunTime:0.000430s ]
SELECT `id` FROM `stock` WHERE `id` <> 65419055 AND `partno` = '2SA812A-T1B-AT' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%renesas electronics corporation%' ) [ RunTime:0.000796s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 65419767 LIMIT 5 [ RunTime:0.000333s ]
SELECT * FROM `stock_price` WHERE `stockid` = 65419767 ORDER BY `minOrder` ASC [ RunTime:0.000709s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 65419767 ORDER BY `unit` DESC [ RunTime:0.000438s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 65419767 LIMIT 2 [ RunTime:0.000330s ]
SELECT * FROM `stock_price` WHERE `stockid` = 65419767 ORDER BY `minOrder` ASC [ RunTime:0.000357s ]
select * from pdf where partno='2SC2001-A' and brandshort='Renesas Electronics Corporation' limit 1 [ RunTime:0.001177s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2SC2001-A' OR `brand` LIKE 'Renesas Electronics Corporation%' ) ) LIMIT 1 [ RunTime:0.000427s ]
SELECT `id` FROM `stock` WHERE `id` <> 65419767 AND `partno` = '2SC2001-A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%renesas electronics corporation%' ) [ RunTime:0.000421s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 65511734 LIMIT 5 [ RunTime:0.000335s ]
SELECT * FROM `stock_price` WHERE `stockid` = 65511734 ORDER BY `minOrder` ASC [ RunTime:0.000683s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 65511734 ORDER BY `unit` DESC [ RunTime:0.000389s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 65511734 LIMIT 2 [ RunTime:0.000325s ]
SELECT * FROM `stock_price` WHERE `stockid` = 65511734 ORDER BY `minOrder` ASC [ RunTime:0.000361s ]
select * from pdf where partno='2SK514-T-A' and brandshort='Renesas Electronics Corporation' limit 1 [ RunTime:0.001101s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2SK514-T-A' OR `brand` LIKE 'Renesas Electronics Corporation%' ) ) LIMIT 1 [ RunTime:0.002693s ]
SELECT `id` FROM `stock` WHERE `id` <> 65511734 AND `partno` = '2SK514-T-A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%renesas electronics corporation%' ) [ RunTime:0.002966s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18582433 [ RunTime:0.000442s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 65419377 LIMIT 5 [ RunTime:0.000404s ]
SELECT * FROM `stock_price` WHERE `stockid` = 65419377 ORDER BY `minOrder` ASC [ RunTime:0.000599s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 65419377 ORDER BY `unit` DESC [ RunTime:0.000345s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 65419377 LIMIT 2 [ RunTime:0.000332s ]
SELECT * FROM `stock_price` WHERE `stockid` = 65419377 ORDER BY `minOrder` ASC [ RunTime:0.000429s ]
select * from pdf where partno='2SC3735-T1B-A' and brandshort='Renesas Electronics Corporation' limit 1 [ RunTime:0.001131s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2SC3735-T1B-A' OR `brand` LIKE 'Renesas Electronics Corporation%' ) ) LIMIT 1 [ RunTime:0.000479s ]
SELECT `id` FROM `stock` WHERE `id` <> 65419377 AND `partno` = '2SC3735-T1B-A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%renesas electronics corporation%' ) [ RunTime:0.000780s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 65419768 LIMIT 5 [ RunTime:0.000338s ]
SELECT * FROM `stock_price` WHERE `stockid` = 65419768 ORDER BY `minOrder` ASC [ RunTime:0.000364s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 65419768 ORDER BY `unit` DESC [ RunTime:0.000337s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 65419768 LIMIT 2 [ RunTime:0.000322s ]
SELECT * FROM `stock_price` WHERE `stockid` = 65419768 ORDER BY `minOrder` ASC [ RunTime:0.000434s ]
select * from pdf where partno='2SC2001-T-A' and brandshort='Renesas Electronics Corporation' limit 1 [ RunTime:0.000723s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2SC2001-T-A' OR `brand` LIKE 'Renesas Electronics Corporation%' ) ) LIMIT 1 [ RunTime:0.000391s ]
SELECT `id` FROM `stock` WHERE `id` <> 65419768 AND `partno` = '2SC2001-T-A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%renesas electronics corporation%' ) [ RunTime:0.000414s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 65420013 LIMIT 5 [ RunTime:0.000341s ]
SELECT * FROM `stock_price` WHERE `stockid` = 65420013 ORDER BY `minOrder` ASC [ RunTime:0.000586s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 65420013 ORDER BY `unit` DESC [ RunTime:0.000337s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 65420013 LIMIT 2 [ RunTime:0.000324s ]
SELECT * FROM `stock_price` WHERE `stockid` = 65420013 ORDER BY `minOrder` ASC [ RunTime:0.000356s ]
select * from pdf where partno='2SA1625-T-AZ' and brandshort='Renesas Electronics Corporation' limit 1 [ RunTime:0.001373s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2SA1625-T-AZ' OR `brand` LIKE 'Renesas Electronics Corporation%' ) ) LIMIT 1 [ RunTime:0.000394s ]
SELECT `id` FROM `stock` WHERE `id` <> 65420013 AND `partno` = '2SA1625-T-AZ' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%renesas electronics corporation%' ) [ RunTime:0.000616s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 65439613 LIMIT 5 [ RunTime:0.000341s ]
SELECT * FROM `stock_price` WHERE `stockid` = 65439613 ORDER BY `minOrder` ASC [ RunTime:0.000626s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 65439613 ORDER BY `unit` DESC [ RunTime:0.000334s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 65439613 LIMIT 2 [ RunTime:0.000323s ]
SELECT * FROM `stock_price` WHERE `stockid` = 65439613 ORDER BY `minOrder` ASC [ RunTime:0.000408s ]
select * from pdf where partno='2SC5508-T2B-A' and brandshort='Renesas Electronics Corporation' limit 1 [ RunTime:0.001418s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2SC5508-T2B-A' OR `brand` LIKE 'Renesas Electronics Corporation%' ) ) LIMIT 1 [ RunTime:0.000467s ]
SELECT `id` FROM `stock` WHERE `id` <> 65439613 AND `partno` = '2SC5508-T2B-A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%renesas electronics corporation%' ) [ RunTime:0.000708s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 65419559 LIMIT 5 [ RunTime:0.000343s ]
SELECT * FROM `stock_price` WHERE `stockid` = 65419559 ORDER BY `minOrder` ASC [ RunTime:0.000483s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 65419559 ORDER BY `unit` DESC [ RunTime:0.000335s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 65419559 LIMIT 2 [ RunTime:0.000323s ]
SELECT * FROM `stock_price` WHERE `stockid` = 65419559 ORDER BY `minOrder` ASC [ RunTime:0.000371s ]
select * from pdf where partno='2SA1610-T1-A' and brandshort='Renesas Electronics Corporation' limit 1 [ RunTime:0.000830s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2SA1610-T1-A' OR `brand` LIKE 'Renesas Electronics Corporation%' ) ) LIMIT 1 [ RunTime:0.000393s ]
SELECT `id` FROM `stock` WHERE `id` <> 65419559 AND `partno` = '2SA1610-T1-A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%renesas electronics corporation%' ) [ RunTime:0.000414s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 67184958 LIMIT 5 [ RunTime:0.000336s ]
SELECT * FROM `stock_price` WHERE `stockid` = 67184958 ORDER BY `minOrder` ASC [ RunTime:0.000702s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 67184958 ORDER BY `unit` DESC [ RunTime:0.000339s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 67184958 LIMIT 2 [ RunTime:0.000325s ]
SELECT * FROM `stock_price` WHERE `stockid` = 67184958 ORDER BY `minOrder` ASC [ RunTime:0.000459s ]
select * from pdf where partno='2-487406-2' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.000689s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2-487406-2' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.000581s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 65419795 LIMIT 5 [ RunTime:0.000406s ]
SELECT * FROM `stock_price` WHERE `stockid` = 65419795 ORDER BY `minOrder` ASC [ RunTime:0.000572s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 65419795 ORDER BY `unit` DESC [ RunTime:0.000402s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 65419795 LIMIT 2 [ RunTime:0.000411s ]
SELECT * FROM `stock_price` WHERE `stockid` = 65419795 ORDER BY `minOrder` ASC [ RunTime:0.000416s ]
select * from pdf where partno='2SA1462-T1B-A' and brandshort='Renesas Electronics Corporation' limit 1 [ RunTime:0.000949s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2SA1462-T1B-A' OR `brand` LIKE 'Renesas Electronics Corporation%' ) ) LIMIT 1 [ RunTime:0.000402s ]
SELECT `id` FROM `stock` WHERE `id` <> 65419795 AND `partno` = '2SA1462-T1B-A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%renesas electronics corporation%' ) [ RunTime:0.000473s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 67158023 LIMIT 5 [ RunTime:0.000397s ]
SELECT * FROM `stock_price` WHERE `stockid` = 67158023 ORDER BY `minOrder` ASC [ RunTime:0.000767s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 67158023 ORDER BY `unit` DESC [ RunTime:0.000408s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 67158023 LIMIT 2 [ RunTime:0.000326s ]
SELECT * FROM `stock_price` WHERE `stockid` = 67158023 ORDER BY `minOrder` ASC [ RunTime:0.000380s ]
select * from pdf where partno='2232903-1' and brandshort='TE Connectivity' limit 1 [ RunTime:0.000875s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2232903-1' OR `brand` LIKE 'TE Connectivity%' ) ) LIMIT 1 [ RunTime:0.009048s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 67158044 LIMIT 5 [ RunTime:0.000344s ]
SELECT * FROM `stock_price` WHERE `stockid` = 67158044 ORDER BY `minOrder` ASC [ RunTime:0.000372s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 67158044 ORDER BY `unit` DESC [ RunTime:0.000371s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 67158044 LIMIT 2 [ RunTime:0.000365s ]
SELECT * FROM `stock_price` WHERE `stockid` = 67158044 ORDER BY `minOrder` ASC [ RunTime:0.000361s ]
select * from pdf where partno='2-964294-1' and brandshort='TE Connectivity' limit 1 [ RunTime:0.000539s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2-964294-1' OR `brand` LIKE 'TE Connectivity%' ) ) LIMIT 1 [ RunTime:0.008581s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 65419876 LIMIT 5 [ RunTime:0.000357s ]
SELECT * FROM `stock_price` WHERE `stockid` = 65419876 ORDER BY `minOrder` ASC [ RunTime:0.000367s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 65419876 ORDER BY `unit` DESC [ RunTime:0.000327s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 65419876 LIMIT 2 [ RunTime:0.000382s ]
SELECT * FROM `stock_price` WHERE `stockid` = 65419876 ORDER BY `minOrder` ASC [ RunTime:0.000371s ]
select * from pdf where partno='2SA952-A' and brandshort='Renesas Electronics Corporation' limit 1 [ RunTime:0.003542s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2SA952-A' OR `brand` LIKE 'Renesas Electronics Corporation%' ) ) LIMIT 1 [ RunTime:0.000402s ]
SELECT `id` FROM `stock` WHERE `id` <> 65419876 AND `partno` = '2SA952-A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%renesas electronics corporation%' ) [ RunTime:0.000434s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 65511733 LIMIT 5 [ RunTime:0.000451s ]
SELECT * FROM `stock_price` WHERE `stockid` = 65511733 ORDER BY `minOrder` ASC [ RunTime:0.000447s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 65511733 ORDER BY `unit` DESC [ RunTime:0.000327s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 65511733 LIMIT 2 [ RunTime:0.000321s ]
SELECT * FROM `stock_price` WHERE `stockid` = 65511733 ORDER BY `minOrder` ASC [ RunTime:0.000346s ]
select * from pdf where partno='2SK508-T1B-A' and brandshort='Renesas Electronics Corporation' limit 1 [ RunTime:0.000905s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2SK508-T1B-A' OR `brand` LIKE 'Renesas Electronics Corporation%' ) ) LIMIT 1 [ RunTime:0.000406s ]
SELECT `id` FROM `stock` WHERE `id` <> 65511733 AND `partno` = '2SK508-T1B-A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%renesas electronics corporation%' ) [ RunTime:0.000432s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18582432 [ RunTime:0.000350s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 65420130 LIMIT 5 [ RunTime:0.000327s ]
SELECT * FROM `stock_price` WHERE `stockid` = 65420130 ORDER BY `minOrder` ASC [ RunTime:0.000687s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 65420130 ORDER BY `unit` DESC [ RunTime:0.000340s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 65420130 LIMIT 2 [ RunTime:0.000326s ]
SELECT * FROM `stock_price` WHERE `stockid` = 65420130 ORDER BY `minOrder` ASC [ RunTime:0.000353s ]
select * from pdf where partno='2SA1338-5-TB-E' and brandshort='onsemi' limit 1 [ RunTime:0.001223s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2SA1338-5-TB-E' OR `brand` LIKE 'onsemi%' ) ) LIMIT 1 [ RunTime:0.006095s ]
SELECT `id` FROM `stock` WHERE `id` <> 65420130 AND `partno` = '2SA1338-5-TB-E' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%onsemi%' ) [ RunTime:0.000564s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 65418941 LIMIT 5 [ RunTime:0.000340s ]
SELECT * FROM `stock_price` WHERE `stockid` = 65418941 ORDER BY `minOrder` ASC [ RunTime:0.000662s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 65418941 ORDER BY `unit` DESC [ RunTime:0.000338s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 65418941 LIMIT 2 [ RunTime:0.000368s ]
SELECT * FROM `stock_price` WHERE `stockid` = 65418941 ORDER BY `minOrder` ASC [ RunTime:0.000419s ]
select * from pdf where partno='2SC4453-3-TB-E' and brandshort='onsemi' limit 1 [ RunTime:0.001178s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2SC4453-3-TB-E' OR `brand` LIKE 'onsemi%' ) ) LIMIT 1 [ RunTime:0.006460s ]
SELECT `id` FROM `stock` WHERE `id` <> 65418941 AND `partno` = '2SC4453-3-TB-E' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%onsemi%' ) [ RunTime:0.000631s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 65518416 LIMIT 5 [ RunTime:0.000342s ]
SELECT * FROM `stock_price` WHERE `stockid` = 65518416 ORDER BY `minOrder` ASC [ RunTime:0.000707s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 65518416 ORDER BY `unit` DESC [ RunTime:0.000341s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 65518416 LIMIT 2 [ RunTime:0.000326s ]
SELECT * FROM `stock_price` WHERE `stockid` = 65518416 ORDER BY `minOrder` ASC [ RunTime:0.000355s ]
select * from pdf where partno='2SC3395-TB-E' and brandshort='onsemi' limit 1 [ RunTime:0.001258s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2SC3395-TB-E' OR `brand` LIKE 'onsemi%' ) ) LIMIT 1 [ RunTime:0.005978s ]
SELECT `id` FROM `stock` WHERE `id` <> 65518416 AND `partno` = '2SC3395-TB-E' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%onsemi%' ) [ RunTime:0.000476s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 65512706 LIMIT 5 [ RunTime:0.000412s ]
SELECT * FROM `stock_price` WHERE `stockid` = 65512706 ORDER BY `minOrder` ASC [ RunTime:0.000853s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 65512706 ORDER BY `unit` DESC [ RunTime:0.000393s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 65512706 LIMIT 2 [ RunTime:0.000446s ]
SELECT * FROM `stock_price` WHERE `stockid` = 65512706 ORDER BY `minOrder` ASC [ RunTime:0.000387s ]
select * from pdf where partno='2N7002DW-TP' and brandshort='MCC Micro Commercial Components' limit 1 [ RunTime:0.002341s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2N7002DW-TP' OR `brand` LIKE 'MCC (Micro Commercial Components)%' ) ) LIMIT 1 [ RunTime:0.000491s ]
SELECT `id` FROM `stock` WHERE `id` <> 65512706 AND `partno` = '2N7002DW-TP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mcc%' ) [ RunTime:0.000447s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 70931506 LIMIT 5 [ RunTime:0.000371s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70931506 ORDER BY `minOrder` ASC [ RunTime:0.000843s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 70931506 ORDER BY `unit` DESC [ RunTime:0.000357s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 70931506 LIMIT 2 [ RunTime:0.000362s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70931506 ORDER BY `minOrder` ASC [ RunTime:0.000395s ]
select * from pdf where partno='2512067007Y3' and brandshort='Fair-Rite Products Corp.' limit 1 [ RunTime:0.000816s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2512067007Y3' OR `brand` LIKE 'Fair-Rite Products Corp.%' ) ) LIMIT 1 [ RunTime:0.000446s ]
SELECT `id` FROM `stock` WHERE `id` <> 70931506 AND `partno` = '2512067007Y3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%fair-rite products corp.%' ) [ RunTime:0.000467s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11943793 [ RunTime:0.000506s ]
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 '2%' OR `brand` LIKE '2%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000812s ]
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 '2%' OR `brand` LIKE '2%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000652s ]
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 '2%' OR `brand` LIKE '2%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000671s ]
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 '2%' OR `brand` LIKE '2%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000725s ]
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 '2%' OR `brand` LIKE '2%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000651s ]
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 '2%' OR `brand` LIKE '2%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000774s ]
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 '2%' OR `brand` LIKE '2%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011036s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64839037 LIMIT 5 [ RunTime:0.000422s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64839037 ORDER BY `minOrder` ASC [ RunTime:0.000725s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64839037 ORDER BY `unit` DESC [ RunTime:0.000363s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64839037 LIMIT 2 [ RunTime:0.000329s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64839037 ORDER BY `minOrder` ASC [ RunTime:0.000374s ]
select * from pdf where partno='2.54短路帽开口' and brandshort='BOOMELE' limit 1 [ RunTime:0.001368s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2.54短路帽开口' OR `brand` LIKE 'BOOMELE(博穆精密)%' ) ) LIMIT 1 [ RunTime:0.001128s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64839817 LIMIT 5 [ RunTime:0.000415s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64839817 ORDER BY `minOrder` ASC [ RunTime:0.000716s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64839817 ORDER BY `unit` DESC [ RunTime:0.000402s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64839817 LIMIT 2 [ RunTime:0.000391s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64839817 ORDER BY `minOrder` ASC [ RunTime:0.000396s ]
select * from pdf where partno='2.54短路帽闭口' and brandshort='BOOMELE' limit 1 [ RunTime:0.000640s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2.54短路帽闭口' OR `brand` LIKE 'BOOMELE(博穆精密)%' ) ) LIMIT 1 [ RunTime:0.000625s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64839213 LIMIT 5 [ RunTime:0.000360s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64839213 ORDER BY `minOrder` ASC [ RunTime:0.001487s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64839213 ORDER BY `unit` DESC [ RunTime:0.000405s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64839213 LIMIT 2 [ RunTime:0.000324s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64839213 ORDER BY `minOrder` ASC [ RunTime:0.000373s ]
select * from pdf where partno='2.54-1*3P针' and brandshort='BOOMELE' limit 1 [ RunTime:0.000731s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2.54-1*3P针' OR `brand` LIKE 'BOOMELE(博穆精密)%' ) ) LIMIT 1 [ RunTime:0.000570s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64839003 LIMIT 5 [ RunTime:0.000333s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64839003 ORDER BY `minOrder` ASC [ RunTime:0.000376s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64839003 ORDER BY `unit` DESC [ RunTime:0.000548s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64839003 LIMIT 2 [ RunTime:0.000411s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64839003 ORDER BY `minOrder` ASC [ RunTime:0.000533s ]
select * from pdf where partno='2.54-1x6P直针' and brandshort='BOOMELE' limit 1 [ RunTime:0.000681s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2.54-1x6P直针' OR `brand` LIKE 'BOOMELE(博穆精密)%' ) ) LIMIT 1 [ RunTime:0.000948s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64838803 LIMIT 5 [ RunTime:0.000413s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64838803 ORDER BY `minOrder` ASC [ RunTime:0.000881s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64838803 ORDER BY `unit` DESC [ RunTime:0.000423s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64838803 LIMIT 2 [ RunTime:0.000452s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64838803 ORDER BY `minOrder` ASC [ RunTime:0.000595s ]
select * from pdf where partno='25121WJ0000T4E' and brandshort='UNI-ROYAL' limit 1 [ RunTime:0.000703s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '25121WJ0000T4E' OR `brand` LIKE 'UNI-ROYAL(厚声)%' ) ) LIMIT 1 [ RunTime:0.002795s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32138156 LIMIT 5 [ RunTime:0.000510s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32138156 ORDER BY `minOrder` ASC [ RunTime:0.003370s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32138156 ORDER BY `unit` DESC [ RunTime:0.000638s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32138156 LIMIT 2 [ RunTime:0.000593s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32138156 ORDER BY `minOrder` ASC [ RunTime:0.000721s ]
select * from pdf where partno='293D475X9025A2TE3' and brandshort='VISHAY' limit 1 [ RunTime:0.001290s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '293D475X9025A2TE3' OR `brand` LIKE 'VISHAY(威世)%' ) ) LIMIT 1 [ RunTime:0.019431s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58018889 LIMIT 5 [ RunTime:0.000668s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58018889 ORDER BY `minOrder` ASC [ RunTime:0.001299s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58018889 ORDER BY `unit` DESC [ RunTime:0.000511s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58018889 LIMIT 2 [ RunTime:0.000501s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58018889 ORDER BY `minOrder` ASC [ RunTime:0.000626s ]
select * from pdf where partno='281934-2' and brandshort='TE Connectivity' limit 1 [ RunTime:0.001296s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '281934-2' OR `brand` LIKE 'TE Connectivity(泰科电子)%' ) ) LIMIT 1 [ RunTime:0.027354s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64837524 LIMIT 5 [ RunTime:0.000886s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64837524 ORDER BY `minOrder` ASC [ RunTime:0.003467s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64837524 ORDER BY `unit` DESC [ RunTime:0.000505s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64837524 LIMIT 2 [ RunTime:0.000350s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64837524 ORDER BY `minOrder` ASC [ RunTime:0.000447s ]
select * from pdf where partno='25121WF100JT4E' and brandshort='UNI-ROYAL' limit 1 [ RunTime:0.000822s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '25121WF100JT4E' OR `brand` LIKE 'UNI-ROYAL(厚声)%' ) ) LIMIT 1 [ RunTime:0.001167s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64838280 LIMIT 5 [ RunTime:0.000346s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64838280 ORDER BY `minOrder` ASC [ RunTime:0.000719s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64838280 ORDER BY `unit` DESC [ RunTime:0.000332s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64838280 LIMIT 2 [ RunTime:0.000316s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64838280 ORDER BY `minOrder` ASC [ RunTime:0.000360s ]
select * from pdf where partno='25121WJ047JT4E' and brandshort='UNI-ROYAL' limit 1 [ RunTime:0.000715s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '25121WJ047JT4E' OR `brand` LIKE 'UNI-ROYAL(厚声)%' ) ) LIMIT 1 [ RunTime:0.000971s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64840180 LIMIT 5 [ RunTime:0.000327s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64840180 ORDER BY `minOrder` ASC [ RunTime:0.000708s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64840180 ORDER BY `unit` DESC [ RunTime:0.000333s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64840180 LIMIT 2 [ RunTime:0.000315s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64840180 ORDER BY `minOrder` ASC [ RunTime:0.000362s ]
select * from pdf where partno='2510-3A' and brandshort='BOOMELE' limit 1 [ RunTime:0.001400s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2510-3A' OR `brand` LIKE 'BOOMELE(博穆精密)%' ) ) LIMIT 1 [ RunTime:0.000623s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58018298 LIMIT 5 [ RunTime:0.000329s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58018298 ORDER BY `minOrder` ASC [ RunTime:0.000912s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58018298 ORDER BY `unit` DESC [ RunTime:0.000327s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58018298 LIMIT 2 [ RunTime:0.000314s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58018298 ORDER BY `minOrder` ASC [ RunTime:0.000381s ]
select * from pdf where partno='25121WJ0102T4E' and brandshort='UNI-ROYAL' limit 1 [ RunTime:0.000916s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '25121WJ0102T4E' OR `brand` LIKE 'UNI-ROYAL(厚声)%' ) ) LIMIT 1 [ RunTime:0.001141s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64838983 LIMIT 5 [ RunTime:0.000397s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64838983 ORDER BY `minOrder` ASC [ RunTime:0.000564s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64838983 ORDER BY `unit` DESC [ RunTime:0.000343s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64838983 LIMIT 2 [ RunTime:0.000339s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64838983 ORDER BY `minOrder` ASC [ RunTime:0.000378s ]
select * from pdf where partno='2.54-1*4P母' and brandshort='BOOMELE' limit 1 [ RunTime:0.000731s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2.54-1*4P母' OR `brand` LIKE 'BOOMELE(博穆精密)%' ) ) LIMIT 1 [ RunTime:0.000671s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64838076 LIMIT 5 [ RunTime:0.000396s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64838076 ORDER BY `minOrder` ASC [ RunTime:0.001565s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64838076 ORDER BY `unit` DESC [ RunTime:0.000333s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64838076 LIMIT 2 [ RunTime:0.000316s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64838076 ORDER BY `minOrder` ASC [ RunTime:0.000361s ]
select * from pdf where partno='25121WF200JT4E' and brandshort='UNI-ROYAL' limit 1 [ RunTime:0.000710s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '25121WF200JT4E' OR `brand` LIKE 'UNI-ROYAL(厚声)%' ) ) LIMIT 1 [ RunTime:0.001063s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64846996 LIMIT 5 [ RunTime:0.000328s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64846996 ORDER BY `minOrder` ASC [ RunTime:0.000706s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64846996 ORDER BY `unit` DESC [ RunTime:0.000375s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64846996 LIMIT 2 [ RunTime:0.000319s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64846996 ORDER BY `minOrder` ASC [ RunTime:0.000361s ]
select * from pdf where partno='25YXJ220M6.3X11' and brandshort='Rubycon' limit 1 [ RunTime:0.001532s ]
select foldpath,foldpath2,filename from pdf_file where id=2048439 limit 1 [ RunTime:0.000886s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '25YXJ220M6.3X11' OR `brand` LIKE 'Rubycon(红宝石)%' ) ) LIMIT 1 [ RunTime:0.001660s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64839004 LIMIT 5 [ RunTime:0.000441s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64839004 ORDER BY `minOrder` ASC [ RunTime:0.000504s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64839004 ORDER BY `unit` DESC [ RunTime:0.000412s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64839004 LIMIT 2 [ RunTime:0.000397s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64839004 ORDER BY `minOrder` ASC [ RunTime:0.000452s ]
select * from pdf where partno='2.54-2*5P简牛' and brandshort='BOOMELE' limit 1 [ RunTime:0.000630s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2.54-2*5P简牛' OR `brand` LIKE 'BOOMELE(博穆精密)%' ) ) LIMIT 1 [ RunTime:0.000728s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64838808 LIMIT 5 [ RunTime:0.000389s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64838808 ORDER BY `minOrder` ASC [ RunTime:0.000584s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64838808 ORDER BY `unit` DESC [ RunTime:0.000451s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64838808 LIMIT 2 [ RunTime:0.000411s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64838808 ORDER BY `minOrder` ASC [ RunTime:0.000469s ]
select * from pdf where partno='25121WJ0104T4E' and brandshort='UNI-ROYAL' limit 1 [ RunTime:0.000596s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '25121WJ0104T4E' OR `brand` LIKE 'UNI-ROYAL(厚声)%' ) ) LIMIT 1 [ RunTime:0.001323s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64842411 LIMIT 5 [ RunTime:0.000445s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64842411 ORDER BY `minOrder` ASC [ RunTime:0.000849s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64842411 ORDER BY `unit` DESC [ RunTime:0.000415s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64842411 LIMIT 2 [ RunTime:0.000400s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64842411 ORDER BY `minOrder` ASC [ RunTime:0.000480s ]
select * from pdf where partno='2010T2A250V' and brandshort='WALTER' limit 1 [ RunTime:0.000989s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2010T2A250V' OR `brand` LIKE 'WALTER(华德)%' ) ) LIMIT 1 [ RunTime:0.000896s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64838513 LIMIT 5 [ RunTime:0.000410s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64838513 ORDER BY `minOrder` ASC [ RunTime:0.000770s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64838513 ORDER BY `unit` DESC [ RunTime:0.000411s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64838513 LIMIT 2 [ RunTime:0.000390s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64838513 ORDER BY `minOrder` ASC [ RunTime:0.000445s ]
select * from pdf where partno='25121WF100MT4E' and brandshort='UNI-ROYAL' limit 1 [ RunTime:0.000549s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '25121WF100MT4E' OR `brand` LIKE 'UNI-ROYAL(厚声)%' ) ) LIMIT 1 [ RunTime:0.001279s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58019111 LIMIT 5 [ RunTime:0.000398s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58019111 ORDER BY `minOrder` ASC [ RunTime:0.000503s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58019111 ORDER BY `unit` DESC [ RunTime:0.000431s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58019111 LIMIT 2 [ RunTime:0.000388s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58019111 ORDER BY `minOrder` ASC [ RunTime:0.000459s ]
select * from pdf where partno='282110-1' and brandshort='TE Connectivity' limit 1 [ RunTime:0.001119s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '282110-1' OR `brand` LIKE 'TE Connectivity(泰科电子)%' ) ) LIMIT 1 [ RunTime:0.011692s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64842623 LIMIT 5 [ RunTime:0.000501s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64842623 ORDER BY `minOrder` ASC [ RunTime:0.000844s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64842623 ORDER BY `unit` DESC [ RunTime:0.000412s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64842623 LIMIT 2 [ RunTime:0.000444s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64842623 ORDER BY `minOrder` ASC [ RunTime:0.000469s ]
select * from pdf where partno='2RM600L-8' and brandshort='Brightking' limit 1 [ RunTime:0.001043s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2RM600L-8' OR `brand` LIKE 'Brightking(君耀电子)%' ) ) LIMIT 1 [ RunTime:0.001064s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '2%' OR `brand` LIKE '2%' ) ) AND ( (s.platform = 1) ) [ RunTime:6.121482s ]