SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.004630s ]
INSERT INTO `visit_log` SET `ip` = '216.73.217.114' , `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=13&search=1' [ RunTime:0.007322s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002024s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.003954s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002217s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.114' ) [ RunTime:0.000572s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001807s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000586s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002033s ]
SELECT * FROM `stock_search` WHERE `partno` = '13' LIMIT 1 [ RunTime:0.000817s ]
UPDATE `stock_search` SET `count` = 89 , `updatetime` = '2026-10-13 02:28:16' WHERE `partno` = '13' [ RunTime:0.002663s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001964s ]
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 '13%' OR `brand` LIKE '13%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.712437s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001437s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12512082 LIMIT 5 [ RunTime:0.000988s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001269s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12512082 ORDER BY `minOrder` ASC [ RunTime:0.000498s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001119s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12512082 ORDER BY `unit` DESC [ RunTime:0.000389s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002405s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12512082 LIMIT 2 [ RunTime:0.000499s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12512082 ORDER BY `minOrder` ASC [ RunTime:0.000447s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12610597 LIMIT 5 [ RunTime:0.000681s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12610597 ORDER BY `minOrder` ASC [ RunTime:0.000374s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12610597 ORDER BY `unit` DESC [ RunTime:0.000331s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12610597 LIMIT 2 [ RunTime:0.000304s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12610597 ORDER BY `minOrder` ASC [ RunTime:0.000312s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12612732 LIMIT 5 [ RunTime:0.000603s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12612732 ORDER BY `minOrder` ASC [ RunTime:0.000319s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12612732 ORDER BY `unit` DESC [ RunTime:0.000301s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12612732 LIMIT 2 [ RunTime:0.000286s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12612732 ORDER BY `minOrder` ASC [ RunTime:0.000298s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12608921 LIMIT 5 [ RunTime:0.000574s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12608921 ORDER BY `minOrder` ASC [ RunTime:0.000330s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12608921 ORDER BY `unit` DESC [ RunTime:0.000286s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12608921 LIMIT 2 [ RunTime:0.000282s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12608921 ORDER BY `minOrder` ASC [ RunTime:0.000303s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19523755 LIMIT 5 [ RunTime:0.000706s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19523755 ORDER BY `minOrder` ASC [ RunTime:0.000315s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19523755 ORDER BY `unit` DESC [ RunTime:0.000298s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19523755 LIMIT 2 [ RunTime:0.000304s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19523755 ORDER BY `minOrder` ASC [ RunTime:0.000298s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11481319 LIMIT 5 [ RunTime:0.001001s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11481319 ORDER BY `minOrder` ASC [ RunTime:0.000315s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11481319 ORDER BY `unit` DESC [ RunTime:0.000292s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11481319 LIMIT 2 [ RunTime:0.000282s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11481319 ORDER BY `minOrder` ASC [ RunTime:0.000307s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12609327 LIMIT 5 [ RunTime:0.000557s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12609327 ORDER BY `minOrder` ASC [ RunTime:0.000304s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12609327 ORDER BY `unit` DESC [ RunTime:0.000348s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12609327 LIMIT 2 [ RunTime:0.000280s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12609327 ORDER BY `minOrder` ASC [ RunTime:0.000307s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12610605 LIMIT 5 [ RunTime:0.000333s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12610605 ORDER BY `minOrder` ASC [ RunTime:0.000310s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12610605 ORDER BY `unit` DESC [ RunTime:0.000290s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12610605 LIMIT 2 [ RunTime:0.000286s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12610605 ORDER BY `minOrder` ASC [ RunTime:0.000304s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11484105 LIMIT 5 [ RunTime:0.000536s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11484105 ORDER BY `minOrder` ASC [ RunTime:0.000308s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11484105 ORDER BY `unit` DESC [ RunTime:0.000290s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11484105 LIMIT 2 [ RunTime:0.000286s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11484105 ORDER BY `minOrder` ASC [ RunTime:0.000298s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12609080 LIMIT 5 [ RunTime:0.000488s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12609080 ORDER BY `minOrder` ASC [ RunTime:0.000256s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12609080 ORDER BY `unit` DESC [ RunTime:0.000244s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12609080 LIMIT 2 [ RunTime:0.000233s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12609080 ORDER BY `minOrder` ASC [ RunTime:0.000252s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12609731 LIMIT 5 [ RunTime:0.000535s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12609731 ORDER BY `minOrder` ASC [ RunTime:0.000311s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12609731 ORDER BY `unit` DESC [ RunTime:0.000244s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12609731 LIMIT 2 [ RunTime:0.000234s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12609731 ORDER BY `minOrder` ASC [ RunTime:0.000253s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12041342 LIMIT 5 [ RunTime:0.000627s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12041342 ORDER BY `minOrder` ASC [ RunTime:0.000279s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12041342 ORDER BY `unit` DESC [ RunTime:0.000298s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12041342 LIMIT 2 [ RunTime:0.000286s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12041342 ORDER BY `minOrder` ASC [ RunTime:0.000265s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19591542 LIMIT 5 [ RunTime:0.000495s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19591542 ORDER BY `minOrder` ASC [ RunTime:0.000257s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19591542 ORDER BY `unit` DESC [ RunTime:0.000247s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19591542 LIMIT 2 [ RunTime:0.000236s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19591542 ORDER BY `minOrder` ASC [ RunTime:0.000287s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 6680 LIMIT 5 [ RunTime:0.000302s ]
SELECT * FROM `stock_price` WHERE `stockid` = 6680 ORDER BY `minOrder` ASC [ RunTime:0.000660s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 6680 ORDER BY `unit` DESC [ RunTime:0.000477s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 6680 LIMIT 2 [ RunTime:0.000468s ]
SELECT * FROM `stock_price` WHERE `stockid` = 6680 ORDER BY `minOrder` ASC [ RunTime:0.000278s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001246s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1375819-1' OR `brand` LIKE 'TE CONNECTIVITY%' ) ) LIMIT 1 [ RunTime:0.009991s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12612891 LIMIT 5 [ RunTime:0.001906s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12612891 ORDER BY `minOrder` ASC [ RunTime:0.000383s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12612891 ORDER BY `unit` DESC [ RunTime:0.000290s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12612891 LIMIT 2 [ RunTime:0.000252s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12612891 ORDER BY `minOrder` ASC [ RunTime:0.000304s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12513900 LIMIT 5 [ RunTime:0.002622s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12513900 ORDER BY `minOrder` ASC [ RunTime:0.000342s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12513900 ORDER BY `unit` DESC [ RunTime:0.000299s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12513900 LIMIT 2 [ RunTime:0.000294s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12513900 ORDER BY `minOrder` ASC [ RunTime:0.000308s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11333177 LIMIT 5 [ RunTime:0.000696s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11333177 ORDER BY `minOrder` ASC [ RunTime:0.000378s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11333177 ORDER BY `unit` DESC [ RunTime:0.000295s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11333177 LIMIT 2 [ RunTime:0.000303s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11333177 ORDER BY `minOrder` ASC [ RunTime:0.000314s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12613349 LIMIT 5 [ RunTime:0.000582s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12613349 ORDER BY `minOrder` ASC [ RunTime:0.000318s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12613349 ORDER BY `unit` DESC [ RunTime:0.000305s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12613349 LIMIT 2 [ RunTime:0.000293s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12613349 ORDER BY `minOrder` ASC [ RunTime:0.000356s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12620020 LIMIT 5 [ RunTime:0.002116s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12620020 ORDER BY `minOrder` ASC [ RunTime:0.000315s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12620020 ORDER BY `unit` DESC [ RunTime:0.000295s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12620020 LIMIT 2 [ RunTime:0.000296s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12620020 ORDER BY `minOrder` ASC [ RunTime:0.000311s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 3270 LIMIT 5 [ RunTime:0.000304s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3270 ORDER BY `minOrder` ASC [ RunTime:0.000480s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 3270 ORDER BY `unit` DESC [ RunTime:0.000323s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 3270 LIMIT 2 [ RunTime:0.000302s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3270 ORDER BY `minOrder` ASC [ RunTime:0.000365s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1375820-2' OR `brand` LIKE 'AMP - TE CONNECTIVITY%' ) ) LIMIT 1 [ RunTime:0.000711s ]
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 '13%' OR `brand` LIKE '13%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009133s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 71806798 LIMIT 5 [ RunTime:0.000700s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71806798 ORDER BY `minOrder` ASC [ RunTime:0.000405s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 71806798 ORDER BY `unit` DESC [ RunTime:0.000271s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 71806798 LIMIT 2 [ RunTime:0.000250s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71806798 ORDER BY `minOrder` ASC [ RunTime:0.000325s ]
select * from pdf where partno='1318106-1' and brandshort='te connectivity' limit 1 [ RunTime:0.001565s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1318106-1' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.012268s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32281709 LIMIT 5 [ RunTime:0.000639s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32281709 ORDER BY `minOrder` ASC [ RunTime:0.001021s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32281709 ORDER BY `unit` DESC [ RunTime:0.000486s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32281709 LIMIT 2 [ RunTime:0.000421s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32281709 ORDER BY `minOrder` ASC [ RunTime:0.000553s ]
select * from pdf where partno='130014' and brandshort='te connectivity' limit 1 [ RunTime:0.001115s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '130014' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.019054s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 71782674 LIMIT 5 [ RunTime:0.001074s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71782674 ORDER BY `minOrder` ASC [ RunTime:0.000672s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 71782674 ORDER BY `unit` DESC [ RunTime:0.000595s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 71782674 LIMIT 2 [ RunTime:0.000558s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71782674 ORDER BY `minOrder` ASC [ RunTime:0.000597s ]
select * from pdf where partno='131a15019x' and brandshort='amphenol conec' limit 1 [ RunTime:0.001197s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '131a15019x' OR `brand` LIKE 'amphenol conec%' ) ) LIMIT 1 [ RunTime:0.000760s ]
SELECT `id` FROM `stock` WHERE `id` <> 71782674 AND `partno` = '131a15019x' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol conec%' ) [ RunTime:0.001257s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32267134 LIMIT 5 [ RunTime:0.000572s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32267134 ORDER BY `minOrder` ASC [ RunTime:0.001212s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32267134 ORDER BY `unit` DESC [ RunTime:0.000580s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32267134 LIMIT 2 [ RunTime:0.000550s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32267134 ORDER BY `minOrder` ASC [ RunTime:0.000609s ]
select * from pdf where partno='1393365-1' and brandshort='te connectivity / amp' limit 1 [ RunTime:0.001536s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1393365-1' OR `brand` LIKE 'te connectivity / amp%' ) ) LIMIT 1 [ RunTime:0.000871s ]
SELECT `id` FROM `stock` WHERE `id` <> 32267134 AND `partno` = '1393365-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity / amp%' ) [ RunTime:0.001284s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32267366 LIMIT 5 [ RunTime:0.000590s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32267366 ORDER BY `minOrder` ASC [ RunTime:0.002967s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32267366 ORDER BY `unit` DESC [ RunTime:0.000582s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32267366 LIMIT 2 [ RunTime:0.000558s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32267366 ORDER BY `minOrder` ASC [ RunTime:0.000653s ]
select * from pdf where partno='1326029-7' and brandshort='te connectivity' limit 1 [ RunTime:0.001529s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1326029-7' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.020276s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32273944 LIMIT 5 [ RunTime:0.000625s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32273944 ORDER BY `minOrder` ASC [ RunTime:0.001559s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32273944 ORDER BY `unit` DESC [ RunTime:0.000606s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32273944 LIMIT 2 [ RunTime:0.000573s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32273944 ORDER BY `minOrder` ASC [ RunTime:0.000696s ]
select * from pdf where partno='132-nut-sma-gld' and brandshort='amphenol rf' limit 1 [ RunTime:0.001539s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '132-nut-sma-gld' OR `brand` LIKE 'amphenol rf%' ) ) LIMIT 1 [ RunTime:0.000699s ]
SELECT `id` FROM `stock` WHERE `id` <> 32273944 AND `partno` = '132-nut-sma-gld' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol rf%' ) [ RunTime:0.001124s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32301878 [ RunTime:0.000563s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32301878 LIMIT 5 [ RunTime:0.000553s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32301878 ORDER BY `minOrder` ASC [ RunTime:0.001231s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32301878 ORDER BY `unit` DESC [ RunTime:0.000574s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32301878 LIMIT 2 [ RunTime:0.000542s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32301878 ORDER BY `minOrder` ASC [ RunTime:0.000652s ]
select * from pdf where partno='132-nut-sma-gld' and brandshort='amphenol rf' limit 1 [ RunTime:0.000727s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '132-nut-sma-gld' OR `brand` LIKE 'amphenol rf%' ) ) LIMIT 1 [ RunTime:0.000712s ]
SELECT `id` FROM `stock` WHERE `id` <> 32301878 AND `partno` = '132-nut-sma-gld' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol rf%' ) [ RunTime:0.000776s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32273944 [ RunTime:0.000580s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 71786034 LIMIT 5 [ RunTime:0.000566s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71786034 ORDER BY `minOrder` ASC [ RunTime:0.000611s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 71786034 ORDER BY `unit` DESC [ RunTime:0.000563s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 71786034 LIMIT 2 [ RunTime:0.000562s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71786034 ORDER BY `minOrder` ASC [ RunTime:0.000594s ]
select * from pdf where partno='1367073-1' and brandshort='te connectivity' limit 1 [ RunTime:0.003269s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1367073-1' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.019901s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 71812567 LIMIT 5 [ RunTime:0.000550s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71812567 ORDER BY `minOrder` ASC [ RunTime:0.000549s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 71812567 ORDER BY `unit` DESC [ RunTime:0.000590s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 71812567 LIMIT 2 [ RunTime:0.000537s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71812567 ORDER BY `minOrder` ASC [ RunTime:0.000521s ]
select * from pdf where partno='1318954-1' and brandshort='te connectivity' limit 1 [ RunTime:0.000759s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1318954-1' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.020327s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 71798680 LIMIT 5 [ RunTime:0.000667s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71798680 ORDER BY `minOrder` ASC [ RunTime:0.000617s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 71798680 ORDER BY `unit` DESC [ RunTime:0.000566s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 71798680 LIMIT 2 [ RunTime:0.000572s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71798680 ORDER BY `minOrder` ASC [ RunTime:0.000585s ]
select * from pdf where partno='1355556-1' and brandshort='te connectivity / amp' limit 1 [ RunTime:0.001495s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1355556-1' OR `brand` LIKE 'te connectivity / amp%' ) ) LIMIT 1 [ RunTime:0.000734s ]
SELECT `id` FROM `stock` WHERE `id` <> 71798680 AND `partno` = '1355556-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity / amp%' ) [ RunTime:0.001330s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 71797705 LIMIT 5 [ RunTime:0.000597s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71797705 ORDER BY `minOrder` ASC [ RunTime:0.000659s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 71797705 ORDER BY `unit` DESC [ RunTime:0.000585s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 71797705 LIMIT 2 [ RunTime:0.000568s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71797705 ORDER BY `minOrder` ASC [ RunTime:0.000614s ]
select * from pdf where partno='1326028-3' and brandshort='te connectivity' limit 1 [ RunTime:0.001349s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1326028-3' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.008814s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32263381 LIMIT 5 [ RunTime:0.000311s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32263381 ORDER BY `minOrder` ASC [ RunTime:0.002464s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32263381 ORDER BY `unit` DESC [ RunTime:0.000293s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32263381 LIMIT 2 [ RunTime:0.000240s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32263381 ORDER BY `minOrder` ASC [ RunTime:0.000286s ]
select * from pdf where partno='1327g7fp-bk' and brandshort='anderson power products' limit 1 [ RunTime:0.000668s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1327g7fp-bk' OR `brand` LIKE 'anderson power products%' ) ) LIMIT 1 [ RunTime:0.000462s ]
SELECT `id` FROM `stock` WHERE `id` <> 32263381 AND `partno` = '1327g7fp-bk' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%anderson power products%' ) [ RunTime:0.000867s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51086680 [ RunTime:0.000242s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12510361 [ RunTime:0.000565s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51086680 LIMIT 5 [ RunTime:0.000242s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51086680 ORDER BY `minOrder` ASC [ RunTime:0.004122s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51086680 ORDER BY `unit` DESC [ RunTime:0.000283s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51086680 LIMIT 2 [ RunTime:0.000229s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51086680 ORDER BY `minOrder` ASC [ RunTime:0.000280s ]
select * from pdf where partno='1327g7fp-bk' and brandshort='anderson power products' limit 1 [ RunTime:0.000649s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1327g7fp-bk' OR `brand` LIKE 'anderson power products%' ) ) LIMIT 1 [ RunTime:0.000311s ]
SELECT `id` FROM `stock` WHERE `id` <> 51086680 AND `partno` = '1327g7fp-bk' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%anderson power products%' ) [ RunTime:0.000374s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32263381 [ RunTime:0.000238s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12510361 [ RunTime:0.000276s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 71797980 LIMIT 5 [ RunTime:0.000231s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71797980 ORDER BY `minOrder` ASC [ RunTime:0.000260s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 71797980 ORDER BY `unit` DESC [ RunTime:0.000228s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 71797980 LIMIT 2 [ RunTime:0.000220s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71797980 ORDER BY `minOrder` ASC [ RunTime:0.000244s ]
select * from pdf where partno='1326029-1' and brandshort='te connectivity / amp' limit 1 [ RunTime:0.000643s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1326029-1' OR `brand` LIKE 'te connectivity / amp%' ) ) LIMIT 1 [ RunTime:0.000292s ]
SELECT `id` FROM `stock` WHERE `id` <> 71797980 AND `partno` = '1326029-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity / amp%' ) [ RunTime:0.000778s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 71798559 LIMIT 5 [ RunTime:0.000248s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71798559 ORDER BY `minOrder` ASC [ RunTime:0.000252s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 71798559 ORDER BY `unit` DESC [ RunTime:0.000235s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 71798559 LIMIT 2 [ RunTime:0.000231s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71798559 ORDER BY `minOrder` ASC [ RunTime:0.000243s ]
select * from pdf where partno='1379658-1' and brandshort='te connectivity / amp' limit 1 [ RunTime:0.005805s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1379658-1' OR `brand` LIKE 'te connectivity / amp%' ) ) LIMIT 1 [ RunTime:0.000456s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 71811692 LIMIT 5 [ RunTime:0.000235s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71811692 ORDER BY `minOrder` ASC [ RunTime:0.000255s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 71811692 ORDER BY `unit` DESC [ RunTime:0.000235s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 71811692 LIMIT 2 [ RunTime:0.000221s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71811692 ORDER BY `minOrder` ASC [ RunTime:0.000236s ]
select * from pdf where partno='130550' and brandshort='te connectivity' limit 1 [ RunTime:0.001566s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '130550' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.008527s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 71656086 LIMIT 5 [ RunTime:0.000317s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71656086 ORDER BY `minOrder` ASC [ RunTime:0.000700s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 71656086 ORDER BY `unit` DESC [ RunTime:0.000248s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 71656086 LIMIT 2 [ RunTime:0.000232s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71656086 ORDER BY `minOrder` ASC [ RunTime:0.000297s ]
select * from pdf where partno='1327g16-bk' and brandshort='anderson power products' limit 1 [ RunTime:0.000662s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1327g16-bk' OR `brand` LIKE 'anderson power products%' ) ) LIMIT 1 [ RunTime:0.000304s ]
SELECT `id` FROM `stock` WHERE `id` <> 71656086 AND `partno` = '1327g16-bk' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%anderson power products%' ) [ RunTime:0.000394s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 1893 [ RunTime:0.000245s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 71793552 [ RunTime:0.000228s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 67799301 [ RunTime:0.000227s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 71793552 LIMIT 5 [ RunTime:0.000245s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71793552 ORDER BY `minOrder` ASC [ RunTime:0.000252s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 71793552 ORDER BY `unit` DESC [ RunTime:0.000235s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 71793552 LIMIT 2 [ RunTime:0.000229s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71793552 ORDER BY `minOrder` ASC [ RunTime:0.000241s ]
select * from pdf where partno='1327g16-bk' and brandshort='anderson power products' limit 1 [ RunTime:0.000602s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1327g16-bk' OR `brand` LIKE 'anderson power products%' ) ) LIMIT 1 [ RunTime:0.000296s ]
SELECT `id` FROM `stock` WHERE `id` <> 71793552 AND `partno` = '1327g16-bk' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%anderson power products%' ) [ RunTime:0.000340s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 1893 [ RunTime:0.000229s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 71656086 [ RunTime:0.000237s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 67799301 [ RunTime:0.000224s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32267201 LIMIT 5 [ RunTime:0.000225s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32267201 ORDER BY `minOrder` ASC [ RunTime:0.000532s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32267201 ORDER BY `unit` DESC [ RunTime:0.000240s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32267201 LIMIT 2 [ RunTime:0.000225s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32267201 ORDER BY `minOrder` ASC [ RunTime:0.000271s ]
select * from pdf where partno='1376352-1' and brandshort='te connectivity / raychem' limit 1 [ RunTime:0.000655s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1376352-1' OR `brand` LIKE 'te connectivity / raychem%' ) ) LIMIT 1 [ RunTime:0.000315s ]
SELECT `id` FROM `stock` WHERE `id` <> 32267201 AND `partno` = '1376352-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity / raychem%' ) [ RunTime:0.000765s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32267579 LIMIT 5 [ RunTime:0.000240s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32267579 ORDER BY `minOrder` ASC [ RunTime:0.000580s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32267579 ORDER BY `unit` DESC [ RunTime:0.000241s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32267579 LIMIT 2 [ RunTime:0.000238s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32267579 ORDER BY `minOrder` ASC [ RunTime:0.000255s ]
select * from pdf where partno='1376109-1 (mouser reel)' and brandshort='te connectivity / amp' limit 1 [ RunTime:0.000604s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1376109-1 (mouser reel)' OR `brand` LIKE 'te connectivity / amp%' ) ) LIMIT 1 [ RunTime:0.000300s ]
SELECT `id` FROM `stock` WHERE `id` <> 32267579 AND `partno` = '1376109-1 (mouser reel)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity / amp%' ) [ RunTime:0.000541s ]
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 '13%' OR `brand` LIKE '13%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.405306s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 70272972 LIMIT 5 [ RunTime:0.000601s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70272972 ORDER BY `minOrder` ASC [ RunTime:0.000831s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 70272972 ORDER BY `unit` DESC [ RunTime:0.000371s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 70272972 LIMIT 2 [ RunTime:0.000343s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70272972 ORDER BY `minOrder` ASC [ RunTime:0.000359s ]
select * from pdf where partno='13415' and brandshort='Desco' limit 1 [ RunTime:0.003641s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '13415' OR `brand` LIKE 'Desco%' ) ) LIMIT 1 [ RunTime:0.001971s ]
SELECT `id` FROM `stock` WHERE `id` <> 70272972 AND `partno` = '13415' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%desco%' ) [ RunTime:0.002774s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11333175 [ RunTime:0.000409s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 67186716 LIMIT 5 [ RunTime:0.000351s ]
SELECT * FROM `stock_price` WHERE `stockid` = 67186716 ORDER BY `minOrder` ASC [ RunTime:0.000754s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 67186716 ORDER BY `unit` DESC [ RunTime:0.000354s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 67186716 LIMIT 2 [ RunTime:0.000336s ]
SELECT * FROM `stock_price` WHERE `stockid` = 67186716 ORDER BY `minOrder` ASC [ RunTime:0.000376s ]
select * from pdf where partno='1394476-1' and brandshort='TE Connectivity' limit 1 [ RunTime:0.003016s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1394476-1' OR `brand` LIKE 'TE Connectivity%' ) ) LIMIT 1 [ RunTime:0.008269s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 67154078 LIMIT 5 [ RunTime:0.000372s ]
SELECT * FROM `stock_price` WHERE `stockid` = 67154078 ORDER BY `minOrder` ASC [ RunTime:0.003162s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 67154078 ORDER BY `unit` DESC [ RunTime:0.000427s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 67154078 LIMIT 2 [ RunTime:0.000362s ]
SELECT * FROM `stock_price` WHERE `stockid` = 67154078 ORDER BY `minOrder` ASC [ RunTime:0.000406s ]
select * from pdf where partno='1375819-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.000818s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1375819-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.000692s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 67155804 LIMIT 5 [ RunTime:0.000343s ]
SELECT * FROM `stock_price` WHERE `stockid` = 67155804 ORDER BY `minOrder` ASC [ RunTime:0.000732s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 67155804 ORDER BY `unit` DESC [ RunTime:0.000346s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 67155804 LIMIT 2 [ RunTime:0.000326s ]
SELECT * FROM `stock_price` WHERE `stockid` = 67155804 ORDER BY `minOrder` ASC [ RunTime:0.000384s ]
select * from pdf where partno='1318108-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.000793s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1318108-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.000420s ]
SELECT `id` FROM `stock` WHERE `id` <> 67155804 AND `partno` = '1318108-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.000891s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 67154804 LIMIT 5 [ RunTime:0.000334s ]
SELECT * FROM `stock_price` WHERE `stockid` = 67154804 ORDER BY `minOrder` ASC [ RunTime:0.000707s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 67154804 ORDER BY `unit` DESC [ RunTime:0.000343s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 67154804 LIMIT 2 [ RunTime:0.000328s ]
SELECT * FROM `stock_price` WHERE `stockid` = 67154804 ORDER BY `minOrder` ASC [ RunTime:0.000385s ]
select * from pdf where partno='1355717-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.000790s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1355717-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.000572s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 67154359 LIMIT 5 [ RunTime:0.000341s ]
SELECT * FROM `stock_price` WHERE `stockid` = 67154359 ORDER BY `minOrder` ASC [ RunTime:0.000740s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 67154359 ORDER BY `unit` DESC [ RunTime:0.000348s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 67154359 LIMIT 2 [ RunTime:0.000330s ]
SELECT * FROM `stock_price` WHERE `stockid` = 67154359 ORDER BY `minOrder` ASC [ RunTime:0.000384s ]
select * from pdf where partno='1318106-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.000970s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1318106-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.000652s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 65200324 LIMIT 5 [ RunTime:0.000357s ]
SELECT * FROM `stock_price` WHERE `stockid` = 65200324 ORDER BY `minOrder` ASC [ RunTime:0.000853s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 65200324 ORDER BY `unit` DESC [ RunTime:0.000344s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 65200324 LIMIT 2 [ RunTime:0.000324s ]
SELECT * FROM `stock_price` WHERE `stockid` = 65200324 ORDER BY `minOrder` ASC [ RunTime:0.000386s ]
select * from pdf where partno='1301.9315.24' and brandshort='SCHURTER Inc.' limit 1 [ RunTime:0.012100s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1301.9315.24' OR `brand` LIKE 'SCHURTER Inc.%' ) ) LIMIT 1 [ RunTime:0.000655s ]
SELECT `id` FROM `stock` WHERE `id` <> 65200324 AND `partno` = '1301.9315.24' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%schurter inc.%' ) [ RunTime:0.001417s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19523755 [ RunTime:0.000578s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 67155848 LIMIT 5 [ RunTime:0.000351s ]
SELECT * FROM `stock_price` WHERE `stockid` = 67155848 ORDER BY `minOrder` ASC [ RunTime:0.000563s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 67155848 ORDER BY `unit` DESC [ RunTime:0.000350s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 67155848 LIMIT 2 [ RunTime:0.000343s ]
SELECT * FROM `stock_price` WHERE `stockid` = 67155848 ORDER BY `minOrder` ASC [ RunTime:0.000397s ]
select * from pdf where partno='1318112-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.000954s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1318112-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.000448s ]
SELECT `id` FROM `stock` WHERE `id` <> 67155848 AND `partno` = '1318112-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.000501s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11481319 [ RunTime:0.000388s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 70272907 LIMIT 5 [ RunTime:0.000342s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70272907 ORDER BY `minOrder` ASC [ RunTime:0.000414s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 70272907 ORDER BY `unit` DESC [ RunTime:0.000338s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 70272907 LIMIT 2 [ RunTime:0.000327s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70272907 ORDER BY `minOrder` ASC [ RunTime:0.000371s ]
select * from pdf where partno='13405' and brandshort='Desco' limit 1 [ RunTime:0.000769s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '13405' OR `brand` LIKE 'Desco%' ) ) LIMIT 1 [ RunTime:0.001058s ]
SELECT `id` FROM `stock` WHERE `id` <> 70272907 AND `partno` = '13405' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%desco%' ) [ RunTime:0.000837s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11333177 [ RunTime:0.000372s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 67154432 LIMIT 5 [ RunTime:0.000344s ]
SELECT * FROM `stock_price` WHERE `stockid` = 67154432 ORDER BY `minOrder` ASC [ RunTime:0.003679s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 67154432 ORDER BY `unit` DESC [ RunTime:0.000378s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 67154432 LIMIT 2 [ RunTime:0.000356s ]
SELECT * FROM `stock_price` WHERE `stockid` = 67154432 ORDER BY `minOrder` ASC [ RunTime:0.000412s ]
select * from pdf where partno='1318110-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.001083s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1318110-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.000509s ]
SELECT `id` FROM `stock` WHERE `id` <> 67154432 AND `partno` = '1318110-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.000506s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12609327 [ RunTime:0.000375s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 67155504 LIMIT 5 [ RunTime:0.000358s ]
SELECT * FROM `stock_price` WHERE `stockid` = 67155504 ORDER BY `minOrder` ASC [ RunTime:0.001122s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 67155504 ORDER BY `unit` DESC [ RunTime:0.000368s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 67155504 LIMIT 2 [ RunTime:0.000332s ]
SELECT * FROM `stock_price` WHERE `stockid` = 67155504 ORDER BY `minOrder` ASC [ RunTime:0.000390s ]
select * from pdf where partno='1318912-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.001399s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1318912-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.000507s ]
SELECT `id` FROM `stock` WHERE `id` <> 67155504 AND `partno` = '1318912-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.000993s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12610605 [ RunTime:0.000434s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 67122449 LIMIT 5 [ RunTime:0.000341s ]
SELECT * FROM `stock_price` WHERE `stockid` = 67122449 ORDER BY `minOrder` ASC [ RunTime:0.000932s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 67122449 ORDER BY `unit` DESC [ RunTime:0.000351s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 67122449 LIMIT 2 [ RunTime:0.000332s ]
SELECT * FROM `stock_price` WHERE `stockid` = 67122449 ORDER BY `minOrder` ASC [ RunTime:0.000406s ]
select * from pdf where partno='1363-2' and brandshort='Keystone Electronics' limit 1 [ RunTime:0.001597s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1363-2' OR `brand` LIKE 'Keystone Electronics%' ) ) LIMIT 1 [ RunTime:0.000504s ]
SELECT `id` FROM `stock` WHERE `id` <> 67122449 AND `partno` = '1363-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%keystone electronics%' ) [ RunTime:0.000989s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19591542 [ RunTime:0.000451s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 67172861 LIMIT 5 [ RunTime:0.000420s ]
SELECT * FROM `stock_price` WHERE `stockid` = 67172861 ORDER BY `minOrder` ASC [ RunTime:0.003403s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 67172861 ORDER BY `unit` DESC [ RunTime:0.000367s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 67172861 LIMIT 2 [ RunTime:0.000336s ]
SELECT * FROM `stock_price` WHERE `stockid` = 67172861 ORDER BY `minOrder` ASC [ RunTime:0.000396s ]
select * from pdf where partno='1394512-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.000996s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1394512-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.000850s ]
SELECT `id` FROM `stock` WHERE `id` <> 67172861 AND `partno` = '1394512-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.001023s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11484105 [ RunTime:0.000444s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 70175284 LIMIT 5 [ RunTime:0.000358s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70175284 ORDER BY `minOrder` ASC [ RunTime:0.004510s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 70175284 ORDER BY `unit` DESC [ RunTime:0.000605s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 70175284 LIMIT 2 [ RunTime:0.000412s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70175284 ORDER BY `minOrder` ASC [ RunTime:0.000468s ]
select * from pdf where partno='13SPRT032' and brandshort='Essentra Components' limit 1 [ RunTime:0.001488s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '13SPRT032' OR `brand` LIKE 'Essentra Components%' ) ) LIMIT 1 [ RunTime:0.000518s ]
SELECT `id` FROM `stock` WHERE `id` <> 70175284 AND `partno` = '13SPRT032' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%essentra components%' ) [ RunTime:0.002556s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12041342 [ RunTime:0.000452s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 66770762 LIMIT 5 [ RunTime:0.000411s ]
SELECT * FROM `stock_price` WHERE `stockid` = 66770762 ORDER BY `minOrder` ASC [ RunTime:0.008122s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 66770762 ORDER BY `unit` DESC [ RunTime:0.000590s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 66770762 LIMIT 2 [ RunTime:0.000502s ]
SELECT * FROM `stock_price` WHERE `stockid` = 66770762 ORDER BY `minOrder` ASC [ RunTime:0.000607s ]
select * from pdf where partno='1394007-1' and brandshort='TE Connectivity' limit 1 [ RunTime:0.000662s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1394007-1' OR `brand` LIKE 'TE Connectivity%' ) ) LIMIT 1 [ RunTime:0.020284s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 67799251 LIMIT 5 [ RunTime:0.000555s ]
SELECT * FROM `stock_price` WHERE `stockid` = 67799251 ORDER BY `minOrder` ASC [ RunTime:0.001257s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 67799251 ORDER BY `unit` DESC [ RunTime:0.000637s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 67799251 LIMIT 2 [ RunTime:0.000649s ]
SELECT * FROM `stock_price` WHERE `stockid` = 67799251 ORDER BY `minOrder` ASC [ RunTime:0.000676s ]
select * from pdf where partno='1327G6-BK' and brandshort='Anderson Power Products, Inc.' limit 1 [ RunTime:0.000933s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1327G6-BK' OR `brand` LIKE 'Anderson Power Products, Inc.%' ) ) LIMIT 1 [ RunTime:0.001323s ]
SELECT `id` FROM `stock` WHERE `id` <> 67799251 AND `partno` = '1327G6-BK' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%anderson power products, inc.%' ) [ RunTime:0.001706s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12510320 [ RunTime:0.003145s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 67172728 LIMIT 5 [ RunTime:0.000492s ]
SELECT * FROM `stock_price` WHERE `stockid` = 67172728 ORDER BY `minOrder` ASC [ RunTime:0.000907s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 67172728 ORDER BY `unit` DESC [ RunTime:0.000490s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 67172728 LIMIT 2 [ RunTime:0.000417s ]
SELECT * FROM `stock_price` WHERE `stockid` = 67172728 ORDER BY `minOrder` ASC [ RunTime:0.000483s ]
select * from pdf where partno='1394133-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.001059s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1394133-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.000944s ]
SELECT `id` FROM `stock` WHERE `id` <> 67172728 AND `partno` = '1394133-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.003069s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12612891 [ RunTime:0.000657s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 66741997 LIMIT 5 [ RunTime:0.000614s ]
SELECT * FROM `stock_price` WHERE `stockid` = 66741997 ORDER BY `minOrder` ASC [ RunTime:0.001129s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 66741997 ORDER BY `unit` DESC [ RunTime:0.000631s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 66741997 LIMIT 2 [ RunTime:0.000586s ]
SELECT * FROM `stock_price` WHERE `stockid` = 66741997 ORDER BY `minOrder` ASC [ RunTime:0.000740s ]
select * from pdf where partno='1375820-8' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.000936s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1375820-8' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.001104s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 67217257 LIMIT 5 [ RunTime:0.000649s ]
SELECT * FROM `stock_price` WHERE `stockid` = 67217257 ORDER BY `minOrder` ASC [ RunTime:0.001876s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 67217257 ORDER BY `unit` DESC [ RunTime:0.000617s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 67217257 LIMIT 2 [ RunTime:0.000497s ]
SELECT * FROM `stock_price` WHERE `stockid` = 67217257 ORDER BY `minOrder` ASC [ RunTime:0.000594s ]
select * from pdf where partno='1381010' and brandshort='American Electrical Inc.' limit 1 [ RunTime:0.002261s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1381010' OR `brand` LIKE 'American Electrical Inc.%' ) ) LIMIT 1 [ RunTime:0.001260s ]
SELECT `id` FROM `stock` WHERE `id` <> 67217257 AND `partno` = '1381010' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%american electrical inc.%' ) [ RunTime:0.001193s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 67426748 LIMIT 5 [ RunTime:0.000506s ]
SELECT * FROM `stock_price` WHERE `stockid` = 67426748 ORDER BY `minOrder` ASC [ RunTime:0.001628s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 67426748 ORDER BY `unit` DESC [ RunTime:0.000356s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 67426748 LIMIT 2 [ RunTime:0.000345s ]
SELECT * FROM `stock_price` WHERE `stockid` = 67426748 ORDER BY `minOrder` ASC [ RunTime:0.000460s ]
select * from pdf where partno='132360' and brandshort='Amphenol RF' limit 1 [ RunTime:0.001397s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '132360' OR `brand` LIKE 'Amphenol RF%' ) ) LIMIT 1 [ RunTime:0.000495s ]
SELECT `id` FROM `stock` WHERE `id` <> 67426748 AND `partno` = '132360' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol rf%' ) [ RunTime:0.000932s ]
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 '13%' OR `brand` LIKE '13%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000801s ]
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 '13%' OR `brand` LIKE '13%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000732s ]
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 '13%' OR `brand` LIKE '13%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000616s ]
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 '13%' OR `brand` LIKE '13%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000618s ]
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 '13%' OR `brand` LIKE '13%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000700s ]
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 '13%' OR `brand` LIKE '13%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000621s ]
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 '13%' OR `brand` LIKE '13%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000787s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51016251 LIMIT 5 [ RunTime:0.000391s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51016251 ORDER BY `minOrder` ASC [ RunTime:0.000779s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51016251 ORDER BY `unit` DESC [ RunTime:0.000399s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51016251 LIMIT 2 [ RunTime:0.000390s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51016251 ORDER BY `minOrder` ASC [ RunTime:0.000379s ]
select * from pdf where partno='13F-39MNL' and brandshort='YDS' limit 1 [ RunTime:0.005962s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '13F-39MNL' OR `brand` LIKE 'YDS(元册科技)%' ) ) LIMIT 1 [ RunTime:0.000803s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51020455 LIMIT 5 [ RunTime:0.000358s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51020455 ORDER BY `minOrder` ASC [ RunTime:0.002374s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51020455 ORDER BY `unit` DESC [ RunTime:0.000351s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51020455 LIMIT 2 [ RunTime:0.000328s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51020455 ORDER BY `minOrder` ASC [ RunTime:0.000409s ]
select * from pdf where partno='1300580025' and brandshort='MOLEX' limit 1 [ RunTime:0.003282s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1300580025' OR `brand` LIKE 'MOLEX%' ) ) LIMIT 1 [ RunTime:0.005224s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '13%' OR `brand` LIKE '13%' ) ) AND ( (s.platform = 1) ) [ RunTime:1.282627s ]