SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001171s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.194' , `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=2213&search=1' [ RunTime:0.007347s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001310s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000593s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001309s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.194' ) [ RunTime:0.000359s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001910s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000285s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001362s ]
SELECT * FROM `stock_search` WHERE `partno` = '2213' LIMIT 1 [ RunTime:0.009572s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-08-03 05:16:39' WHERE `partno` = '2213' [ RunTime:0.002105s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001961s ]
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 '2213%' OR `brand` LIKE '2213%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.047293s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001085s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11483928 LIMIT 5 [ RunTime:0.006300s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.003174s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11483928 ORDER BY `minOrder` ASC [ RunTime:0.009941s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001228s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11483928 ORDER BY `unit` DESC [ RunTime:0.001595s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.000966s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11483928 LIMIT 2 [ RunTime:0.001283s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11483928 ORDER BY `minOrder` ASC [ RunTime:0.012699s ]
select * from pdf where partno='2213782-2' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.019017s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 2792 LIMIT 5 [ RunTime:0.009956s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2792 ORDER BY `minOrder` ASC [ RunTime:0.022613s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 2792 ORDER BY `unit` DESC [ RunTime:0.002990s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 2792 LIMIT 2 [ RunTime:0.008499s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2792 ORDER BY `minOrder` ASC [ RunTime:0.002923s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002560s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2213S-08G' OR `brand` LIKE 'MULTICOMP PRO%' ) ) LIMIT 1 [ RunTime:0.002153s ]
SELECT `id` FROM `stock` WHERE `id` <> 2792 AND `partno` = '2213S-08G' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%multicomp pro%' ) [ RunTime:0.012447s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15318 [ RunTime:0.010733s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16338 [ RunTime:0.002540s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11483793 LIMIT 5 [ RunTime:0.002504s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11483793 ORDER BY `minOrder` ASC [ RunTime:0.003007s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11483793 ORDER BY `unit` DESC [ RunTime:0.014702s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11483793 LIMIT 2 [ RunTime:0.009863s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11483793 ORDER BY `minOrder` ASC [ RunTime:0.003455s ]
select * from pdf where partno='2213782-4' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.018431s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19668623 LIMIT 5 [ RunTime:0.007177s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19668623 ORDER BY `minOrder` ASC [ RunTime:0.015661s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19668623 ORDER BY `unit` DESC [ RunTime:0.018505s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19668623 LIMIT 2 [ RunTime:0.011324s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19668623 ORDER BY `minOrder` ASC [ RunTime:0.003428s ]
select * from pdf where partno='2213240-2' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.001412s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15454170 LIMIT 5 [ RunTime:0.011873s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15454170 ORDER BY `minOrder` ASC [ RunTime:0.002385s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15454170 ORDER BY `unit` DESC [ RunTime:0.005687s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15454170 LIMIT 2 [ RunTime:0.004131s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15454170 ORDER BY `minOrder` ASC [ RunTime:0.005060s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17313792 LIMIT 5 [ RunTime:0.004373s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17313792 ORDER BY `minOrder` ASC [ RunTime:0.028081s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17313792 ORDER BY `unit` DESC [ RunTime:0.014146s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17313792 LIMIT 2 [ RunTime:0.017356s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17313792 ORDER BY `minOrder` ASC [ RunTime:0.020351s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15454261 LIMIT 5 [ RunTime:0.014394s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15454261 ORDER BY `minOrder` ASC [ RunTime:0.016465s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15454261 ORDER BY `unit` DESC [ RunTime:0.016712s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15454261 LIMIT 2 [ RunTime:0.003394s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15454261 ORDER BY `minOrder` ASC [ RunTime:0.006813s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18912359 LIMIT 5 [ RunTime:0.009416s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18912359 ORDER BY `minOrder` ASC [ RunTime:0.006333s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18912359 ORDER BY `unit` DESC [ RunTime:0.005817s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18912359 LIMIT 2 [ RunTime:0.011771s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18912359 ORDER BY `minOrder` ASC [ RunTime:0.007691s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19668652 LIMIT 5 [ RunTime:0.004686s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19668652 ORDER BY `minOrder` ASC [ RunTime:0.011990s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19668652 ORDER BY `unit` DESC [ RunTime:0.025356s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19668652 LIMIT 2 [ RunTime:0.016272s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19668652 ORDER BY `minOrder` ASC [ RunTime:0.002135s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19668641 LIMIT 5 [ RunTime:0.005080s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19668641 ORDER BY `minOrder` ASC [ RunTime:0.009874s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19668641 ORDER BY `unit` DESC [ RunTime:0.005503s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19668641 LIMIT 2 [ RunTime:0.006931s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19668641 ORDER BY `minOrder` ASC [ RunTime:0.002508s ]
select * from pdf where partno='2213428-2' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.017953s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18913142 LIMIT 5 [ RunTime:0.006625s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18913142 ORDER BY `minOrder` ASC [ RunTime:0.012139s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18913142 ORDER BY `unit` DESC [ RunTime:0.008239s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18913142 LIMIT 2 [ RunTime:0.008215s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18913142 ORDER BY `minOrder` ASC [ RunTime:0.010425s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17313896 LIMIT 5 [ RunTime:0.024215s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17313896 ORDER BY `minOrder` ASC [ RunTime:0.028098s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17313896 ORDER BY `unit` DESC [ RunTime:0.020816s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17313896 LIMIT 2 [ RunTime:0.013925s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17313896 ORDER BY `minOrder` ASC [ RunTime:0.009481s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17313921 LIMIT 5 [ RunTime:0.010879s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17313921 ORDER BY `minOrder` ASC [ RunTime:0.017693s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17313921 ORDER BY `unit` DESC [ RunTime:0.012282s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17313921 LIMIT 2 [ RunTime:0.011930s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17313921 ORDER BY `minOrder` ASC [ RunTime:0.002300s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15454229 LIMIT 5 [ RunTime:0.016189s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15454229 ORDER BY `minOrder` ASC [ RunTime:0.009477s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15454229 ORDER BY `unit` DESC [ RunTime:0.016854s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15454229 LIMIT 2 [ RunTime:0.005462s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15454229 ORDER BY `minOrder` ASC [ RunTime:0.004552s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18912361 LIMIT 5 [ RunTime:0.016405s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18912361 ORDER BY `minOrder` ASC [ RunTime:0.024568s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18912361 ORDER BY `unit` DESC [ RunTime:0.013005s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18912361 LIMIT 2 [ RunTime:0.016549s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18912361 ORDER BY `minOrder` ASC [ RunTime:0.004841s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19584832 LIMIT 5 [ RunTime:0.010461s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19584832 ORDER BY `minOrder` ASC [ RunTime:0.007926s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19584832 ORDER BY `unit` DESC [ RunTime:0.015002s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19584832 LIMIT 2 [ RunTime:0.013770s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19584832 ORDER BY `minOrder` ASC [ RunTime:0.003873s ]
select * from pdf where partno='2213600-8' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.003710s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18913139 LIMIT 5 [ RunTime:0.010237s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18913139 ORDER BY `minOrder` ASC [ RunTime:0.014172s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18913139 ORDER BY `unit` DESC [ RunTime:0.007315s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18913139 LIMIT 2 [ RunTime:0.005204s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18913139 ORDER BY `minOrder` ASC [ RunTime:0.005196s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18912362 LIMIT 5 [ RunTime:0.000800s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18912362 ORDER BY `minOrder` ASC [ RunTime:0.004506s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18912362 ORDER BY `unit` DESC [ RunTime:0.013108s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18912362 LIMIT 2 [ RunTime:0.001377s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18912362 ORDER BY `minOrder` ASC [ RunTime:0.003969s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15454258 LIMIT 5 [ RunTime:0.008681s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15454258 ORDER BY `minOrder` ASC [ RunTime:0.011683s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15454258 ORDER BY `unit` DESC [ RunTime:0.009241s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15454258 LIMIT 2 [ RunTime:0.014383s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15454258 ORDER BY `minOrder` ASC [ RunTime:0.000508s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19606745 LIMIT 5 [ RunTime:0.010031s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19606745 ORDER BY `minOrder` ASC [ RunTime:0.021371s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19606745 ORDER BY `unit` DESC [ RunTime:0.020627s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19606745 LIMIT 2 [ RunTime:0.014137s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19606745 ORDER BY `minOrder` ASC [ RunTime:0.013391s ]
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 '2213%' OR `brand` LIKE '2213%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.019761s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51070687 LIMIT 5 [ RunTime:0.004253s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51070687 ORDER BY `minOrder` ASC [ RunTime:0.021077s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51070687 ORDER BY `unit` DESC [ RunTime:0.013545s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51070687 LIMIT 2 [ RunTime:0.006629s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51070687 ORDER BY `minOrder` ASC [ RunTime:0.011503s ]
select * from pdf where partno='2213847-1' and brandshort='te connectivity' limit 1 [ RunTime:0.013622s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2213847-1' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.030783s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51070657 LIMIT 5 [ RunTime:0.009068s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51070657 ORDER BY `minOrder` ASC [ RunTime:0.007330s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51070657 ORDER BY `unit` DESC [ RunTime:0.031132s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51070657 LIMIT 2 [ RunTime:0.018395s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51070657 ORDER BY `minOrder` ASC [ RunTime:0.024080s ]
select * from pdf where partno='2213189-1' and brandshort='te connectivity / raychem' limit 1 [ RunTime:0.021741s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2213189-1' OR `brand` LIKE 'te connectivity / raychem%' ) ) LIMIT 1 [ RunTime:0.010581s ]
SELECT `id` FROM `stock` WHERE `id` <> 51070657 AND `partno` = '2213189-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity / raychem%' ) [ RunTime:0.013801s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51070686 LIMIT 5 [ RunTime:0.003260s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51070686 ORDER BY `minOrder` ASC [ RunTime:0.001439s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51070686 ORDER BY `unit` DESC [ RunTime:0.002924s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51070686 LIMIT 2 [ RunTime:0.010985s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51070686 ORDER BY `minOrder` ASC [ RunTime:0.003197s ]
select * from pdf where partno='2213614-1' and brandshort='te connectivity / raychem' limit 1 [ RunTime:0.010782s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2213614-1' OR `brand` LIKE 'te connectivity / raychem%' ) ) LIMIT 1 [ RunTime:0.018532s ]
SELECT `id` FROM `stock` WHERE `id` <> 51070686 AND `partno` = '2213614-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity / raychem%' ) [ RunTime:0.002043s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51070649 LIMIT 5 [ RunTime:0.006432s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51070649 ORDER BY `minOrder` ASC [ RunTime:0.011397s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51070649 ORDER BY `unit` DESC [ RunTime:0.006204s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51070649 LIMIT 2 [ RunTime:0.020988s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51070649 ORDER BY `minOrder` ASC [ RunTime:0.005951s ]
select * from pdf where partno='2213617-3' and brandshort='te connectivity / p&b' limit 1 [ RunTime:0.005459s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2213617-3' OR `brand` LIKE 'te connectivity / p&b%' ) ) LIMIT 1 [ RunTime:0.019645s ]
SELECT `id` FROM `stock` WHERE `id` <> 51070649 AND `partno` = '2213617-3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity / p&b%' ) [ RunTime:0.017297s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32280536 LIMIT 5 [ RunTime:0.007599s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32280536 ORDER BY `minOrder` ASC [ RunTime:0.010343s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32280536 ORDER BY `unit` DESC [ RunTime:0.006097s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32280536 LIMIT 2 [ RunTime:0.008374s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32280536 ORDER BY `minOrder` ASC [ RunTime:0.000403s ]
select * from pdf where partno='2213782-4' and brandshort='te connectivity / raychem' limit 1 [ RunTime:0.004131s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2213782-4' OR `brand` LIKE 'te connectivity / raychem%' ) ) LIMIT 1 [ RunTime:0.008245s ]
SELECT `id` FROM `stock` WHERE `id` <> 32280536 AND `partno` = '2213782-4' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity / raychem%' ) [ RunTime:0.009684s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51068226 LIMIT 5 [ RunTime:0.018606s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51068226 ORDER BY `minOrder` ASC [ RunTime:0.013727s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51068226 ORDER BY `unit` DESC [ RunTime:0.010406s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51068226 LIMIT 2 [ RunTime:0.000809s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51068226 ORDER BY `minOrder` ASC [ RunTime:0.000517s ]
select * from pdf where partno='2213194-1' and brandshort='te connectivity / p&b' limit 1 [ RunTime:0.004233s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2213194-1' OR `brand` LIKE 'te connectivity / p&b%' ) ) LIMIT 1 [ RunTime:0.004758s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51068060 LIMIT 5 [ RunTime:0.001203s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51068060 ORDER BY `minOrder` ASC [ RunTime:0.024107s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51068060 ORDER BY `unit` DESC [ RunTime:0.003483s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51068060 LIMIT 2 [ RunTime:0.013696s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51068060 ORDER BY `minOrder` ASC [ RunTime:0.001316s ]
select * from pdf where partno='2213407-1' and brandshort='te connectivity / amp' limit 1 [ RunTime:0.010210s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2213407-1' OR `brand` LIKE 'te connectivity / amp%' ) ) LIMIT 1 [ RunTime:0.022743s ]
SELECT `id` FROM `stock` WHERE `id` <> 51068060 AND `partno` = '2213407-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity / amp%' ) [ RunTime:0.019388s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51068229 LIMIT 5 [ RunTime:0.015460s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51068229 ORDER BY `minOrder` ASC [ RunTime:0.030777s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51068229 ORDER BY `unit` DESC [ RunTime:0.023715s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51068229 LIMIT 2 [ RunTime:0.014147s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51068229 ORDER BY `minOrder` ASC [ RunTime:0.014632s ]
select * from pdf where partno='2213678-5' and brandshort='te connectivity / raychem' limit 1 [ RunTime:0.007016s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2213678-5' OR `brand` LIKE 'te connectivity / raychem%' ) ) LIMIT 1 [ RunTime:0.011223s ]
SELECT `id` FROM `stock` WHERE `id` <> 51068229 AND `partno` = '2213678-5' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity / raychem%' ) [ RunTime:0.025418s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51070406 LIMIT 5 [ RunTime:0.001391s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51070406 ORDER BY `minOrder` ASC [ RunTime:0.010973s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51070406 ORDER BY `unit` DESC [ RunTime:0.012474s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51070406 LIMIT 2 [ RunTime:0.005578s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51070406 ORDER BY `minOrder` ASC [ RunTime:0.003359s ]
select * from pdf where partno='2213189-3' and brandshort='te connectivity / p&b' limit 1 [ RunTime:0.028970s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2213189-3' OR `brand` LIKE 'te connectivity / p&b%' ) ) LIMIT 1 [ RunTime:0.005038s ]
SELECT `id` FROM `stock` WHERE `id` <> 51070406 AND `partno` = '2213189-3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity / p&b%' ) [ RunTime:0.007797s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51070197 LIMIT 5 [ RunTime:0.027880s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51070197 ORDER BY `minOrder` ASC [ RunTime:0.013440s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51070197 ORDER BY `unit` DESC [ RunTime:0.010539s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51070197 LIMIT 2 [ RunTime:0.053375s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51070197 ORDER BY `minOrder` ASC [ RunTime:0.002987s ]
select * from pdf where partno='2213188-2' and brandshort='te connectivity / amp' limit 1 [ RunTime:0.005699s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2213188-2' OR `brand` LIKE 'te connectivity / amp%' ) ) LIMIT 1 [ RunTime:0.007413s ]
SELECT `id` FROM `stock` WHERE `id` <> 51070197 AND `partno` = '2213188-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity / amp%' ) [ RunTime:0.018463s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51070319 LIMIT 5 [ RunTime:0.022304s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51070319 ORDER BY `minOrder` ASC [ RunTime:0.017541s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51070319 ORDER BY `unit` DESC [ RunTime:0.010754s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51070319 LIMIT 2 [ RunTime:0.032865s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51070319 ORDER BY `minOrder` ASC [ RunTime:0.001179s ]
select * from pdf where partno='2213203-1' and brandshort='te connectivity / amp' limit 1 [ RunTime:0.030929s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2213203-1' OR `brand` LIKE 'te connectivity / amp%' ) ) LIMIT 1 [ RunTime:0.012661s ]
SELECT `id` FROM `stock` WHERE `id` <> 51070319 AND `partno` = '2213203-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity / amp%' ) [ RunTime:0.015351s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51068224 LIMIT 5 [ RunTime:0.021491s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51068224 ORDER BY `minOrder` ASC [ RunTime:0.018679s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51068224 ORDER BY `unit` DESC [ RunTime:0.009647s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51068224 LIMIT 2 [ RunTime:0.015202s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51068224 ORDER BY `minOrder` ASC [ RunTime:0.002355s ]
select * from pdf where partno='2213118-2' and brandshort='te connectivity / amp' limit 1 [ RunTime:0.002752s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2213118-2' OR `brand` LIKE 'te connectivity / amp%' ) ) LIMIT 1 [ RunTime:0.023733s ]
SELECT `id` FROM `stock` WHERE `id` <> 51068224 AND `partno` = '2213118-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity / amp%' ) [ RunTime:0.007381s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51070287 LIMIT 5 [ RunTime:0.017188s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51070287 ORDER BY `minOrder` ASC [ RunTime:0.023628s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51070287 ORDER BY `unit` DESC [ RunTime:0.007252s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51070287 LIMIT 2 [ RunTime:0.010909s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51070287 ORDER BY `minOrder` ASC [ RunTime:0.005773s ]
select * from pdf where partno='2213188-4' and brandshort='te connectivity / p&b' limit 1 [ RunTime:0.003952s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2213188-4' OR `brand` LIKE 'te connectivity / p&b%' ) ) LIMIT 1 [ RunTime:0.009408s ]
SELECT `id` FROM `stock` WHERE `id` <> 51070287 AND `partno` = '2213188-4' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity / p&b%' ) [ RunTime:0.012972s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51070198 LIMIT 5 [ RunTime:0.021867s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51070198 ORDER BY `minOrder` ASC [ RunTime:0.014859s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51070198 ORDER BY `unit` DESC [ RunTime:0.012631s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51070198 LIMIT 2 [ RunTime:0.001354s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51070198 ORDER BY `minOrder` ASC [ RunTime:0.003164s ]
select * from pdf where partno='2213626-1' and brandshort='te connectivity / p&b' limit 1 [ RunTime:0.009827s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2213626-1' OR `brand` LIKE 'te connectivity / p&b%' ) ) LIMIT 1 [ RunTime:0.010427s ]
SELECT `id` FROM `stock` WHERE `id` <> 51070198 AND `partno` = '2213626-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity / p&b%' ) [ RunTime:0.005758s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32277770 LIMIT 5 [ RunTime:0.003548s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32277770 ORDER BY `minOrder` ASC [ RunTime:0.003568s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32277770 ORDER BY `unit` DESC [ RunTime:0.010184s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32277770 LIMIT 2 [ RunTime:0.025079s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32277770 ORDER BY `minOrder` ASC [ RunTime:0.005665s ]
select * from pdf where partno='2213413-1' and brandshort='te connectivity / p&b' limit 1 [ RunTime:0.029281s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2213413-1' OR `brand` LIKE 'te connectivity / p&b%' ) ) LIMIT 1 [ RunTime:0.012022s ]
SELECT `id` FROM `stock` WHERE `id` <> 32277770 AND `partno` = '2213413-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity / p&b%' ) [ RunTime:0.027511s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32163268 [ RunTime:0.012191s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32163268 LIMIT 5 [ RunTime:0.006239s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32163268 ORDER BY `minOrder` ASC [ RunTime:0.022716s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32163268 ORDER BY `unit` DESC [ RunTime:0.015502s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32163268 LIMIT 2 [ RunTime:0.014024s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32163268 ORDER BY `minOrder` ASC [ RunTime:0.028626s ]
select * from pdf where partno='2213413-1' and brandshort='te connectivity / p&b' limit 1 [ RunTime:0.009125s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2213413-1' OR `brand` LIKE 'te connectivity / p&b%' ) ) LIMIT 1 [ RunTime:0.007283s ]
SELECT `id` FROM `stock` WHERE `id` <> 32163268 AND `partno` = '2213413-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity / p&b%' ) [ RunTime:0.014289s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32277770 [ RunTime:0.016221s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51068051 LIMIT 5 [ RunTime:0.013806s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51068051 ORDER BY `minOrder` ASC [ RunTime:0.040671s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51068051 ORDER BY `unit` DESC [ RunTime:0.006948s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51068051 LIMIT 2 [ RunTime:0.014671s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51068051 ORDER BY `minOrder` ASC [ RunTime:0.006209s ]
select * from pdf where partno='2213929-5' and brandshort='te connectivity / raychem' limit 1 [ RunTime:0.009868s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2213929-5' OR `brand` LIKE 'te connectivity / raychem%' ) ) LIMIT 1 [ RunTime:0.004690s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51068056 LIMIT 5 [ RunTime:0.008462s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51068056 ORDER BY `minOrder` ASC [ RunTime:0.009895s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51068056 ORDER BY `unit` DESC [ RunTime:0.006787s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51068056 LIMIT 2 [ RunTime:0.048807s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51068056 ORDER BY `minOrder` ASC [ RunTime:0.004968s ]
select * from pdf where partno='2213929-3' and brandshort='te connectivity / amp' limit 1 [ RunTime:0.017436s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2213929-3' OR `brand` LIKE 'te connectivity / amp%' ) ) LIMIT 1 [ RunTime:0.010657s ]
SELECT `id` FROM `stock` WHERE `id` <> 51068056 AND `partno` = '2213929-3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity / amp%' ) [ RunTime:0.020127s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51068405 LIMIT 5 [ RunTime:0.001663s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51068405 ORDER BY `minOrder` ASC [ RunTime:0.026680s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51068405 ORDER BY `unit` DESC [ RunTime:0.005832s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51068405 LIMIT 2 [ RunTime:0.007303s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51068405 ORDER BY `minOrder` ASC [ RunTime:0.002452s ]
select * from pdf where partno='2213929-6' and brandshort='te connectivity' limit 1 [ RunTime:0.014895s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2213929-6' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.046734s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32277769 LIMIT 5 [ RunTime:0.015944s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32277769 ORDER BY `minOrder` ASC [ RunTime:0.052074s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32277769 ORDER BY `unit` DESC [ RunTime:0.028541s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32277769 LIMIT 2 [ RunTime:0.054878s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32277769 ORDER BY `minOrder` ASC [ RunTime:0.022050s ]
select * from pdf where partno='2213410-2' and brandshort='te connectivity / amp' limit 1 [ RunTime:0.034985s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2213410-2' OR `brand` LIKE 'te connectivity / amp%' ) ) LIMIT 1 [ RunTime:0.035635s ]
SELECT `id` FROM `stock` WHERE `id` <> 32277769 AND `partno` = '2213410-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity / amp%' ) [ RunTime:0.047421s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32163267 [ RunTime:0.011083s ]
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 '2213%' OR `brand` LIKE '2213%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.033536s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60361698 LIMIT 5 [ RunTime:0.013364s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60361698 ORDER BY `minOrder` ASC [ RunTime:0.013696s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60361698 ORDER BY `unit` DESC [ RunTime:0.007132s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60361698 LIMIT 2 [ RunTime:0.009773s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60361698 ORDER BY `minOrder` ASC [ RunTime:0.007891s ]
select * from pdf where partno='2213782-2' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.002903s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2213782-2' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.004759s ]
SELECT `id` FROM `stock` WHERE `id` <> 60361698 AND `partno` = '2213782-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.015104s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11483928 [ RunTime:0.010459s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60362355 LIMIT 5 [ RunTime:0.004919s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60362355 ORDER BY `minOrder` ASC [ RunTime:0.004931s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60362355 ORDER BY `unit` DESC [ RunTime:0.020678s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60362355 LIMIT 2 [ RunTime:0.040181s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60362355 ORDER BY `minOrder` ASC [ RunTime:0.016526s ]
select * from pdf where partno='2213782-4' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.002450s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2213782-4' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.002765s ]
SELECT `id` FROM `stock` WHERE `id` <> 60362355 AND `partno` = '2213782-4' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.012628s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11483793 [ RunTime:0.011756s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55304272 LIMIT 5 [ RunTime:0.006838s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55304272 ORDER BY `minOrder` ASC [ RunTime:0.009580s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55304272 ORDER BY `unit` DESC [ RunTime:0.006832s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55304272 LIMIT 2 [ RunTime:0.021046s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55304272 ORDER BY `minOrder` ASC [ RunTime:0.014586s ]
select * from pdf where partno='2213240-2' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.002052s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2213240-2' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.001119s ]
SELECT `id` FROM `stock` WHERE `id` <> 55304272 AND `partno` = '2213240-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.000936s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19668623 [ RunTime:0.017079s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56317751 LIMIT 5 [ RunTime:0.002004s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56317751 ORDER BY `minOrder` ASC [ RunTime:0.007198s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56317751 ORDER BY `unit` DESC [ RunTime:0.004466s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56317751 LIMIT 2 [ RunTime:0.015571s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56317751 ORDER BY `minOrder` ASC [ RunTime:0.007710s ]
select * from pdf where partno='2213' and brandshort='Heyco Products Corporation' limit 1 [ RunTime:0.011149s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2213' OR `brand` LIKE 'Heyco Products Corporation%' ) ) LIMIT 1 [ RunTime:0.004328s ]
SELECT `id` FROM `stock` WHERE `id` <> 56317751 AND `partno` = '2213' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%heyco products corporation%' ) [ RunTime:0.006356s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16419634 [ RunTime:0.017519s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55430299 LIMIT 5 [ RunTime:0.011934s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55430299 ORDER BY `minOrder` ASC [ RunTime:0.013371s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55430299 ORDER BY `unit` DESC [ RunTime:0.002917s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55430299 LIMIT 2 [ RunTime:0.000779s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55430299 ORDER BY `minOrder` ASC [ RunTime:0.002515s ]
select * from pdf where partno='2213203-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.008412s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2213203-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.002313s ]
SELECT `id` FROM `stock` WHERE `id` <> 55430299 AND `partno` = '2213203-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.016977s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14462636 [ RunTime:0.004570s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55304244 LIMIT 5 [ RunTime:0.001999s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55304244 ORDER BY `minOrder` ASC [ RunTime:0.002750s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55304244 ORDER BY `unit` DESC [ RunTime:0.017576s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55304244 LIMIT 2 [ RunTime:0.006999s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55304244 ORDER BY `minOrder` ASC [ RunTime:0.003880s ]
select * from pdf where partno='2213288-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.001593s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2213288-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.019940s ]
SELECT `id` FROM `stock` WHERE `id` <> 55304244 AND `partno` = '2213288-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.010995s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15454261 [ RunTime:0.006483s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55304290 LIMIT 5 [ RunTime:0.004470s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55304290 ORDER BY `minOrder` ASC [ RunTime:0.010444s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55304290 ORDER BY `unit` DESC [ RunTime:0.002058s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55304290 LIMIT 2 [ RunTime:0.002180s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55304290 ORDER BY `minOrder` ASC [ RunTime:0.009374s ]
select * from pdf where partno='2213428-2' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.003633s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2213428-2' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.003287s ]
SELECT `id` FROM `stock` WHERE `id` <> 55304290 AND `partno` = '2213428-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.016204s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19668641 [ RunTime:0.013260s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55300393 LIMIT 5 [ RunTime:0.022062s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55300393 ORDER BY `minOrder` ASC [ RunTime:0.013239s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55300393 ORDER BY `unit` DESC [ RunTime:0.010893s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55300393 LIMIT 2 [ RunTime:0.016606s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55300393 ORDER BY `minOrder` ASC [ RunTime:0.011346s ]
select * from pdf where partno='2213782-3' and brandshort='TE Connectivity' limit 1 [ RunTime:0.005156s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2213782-3' OR `brand` LIKE 'TE Connectivity%' ) ) LIMIT 1 [ RunTime:0.033218s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55304021 LIMIT 5 [ RunTime:0.013887s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55304021 ORDER BY `minOrder` ASC [ RunTime:0.006386s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55304021 ORDER BY `unit` DESC [ RunTime:0.001806s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55304021 LIMIT 2 [ RunTime:0.004657s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55304021 ORDER BY `minOrder` ASC [ RunTime:0.003457s ]
select * from pdf where partno='2213611-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.005458s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2213611-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.001567s ]
SELECT `id` FROM `stock` WHERE `id` <> 55304021 AND `partno` = '2213611-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.010909s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17313896 [ RunTime:0.005432s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58115535 LIMIT 5 [ RunTime:0.003414s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58115535 ORDER BY `minOrder` ASC [ RunTime:0.016696s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58115535 ORDER BY `unit` DESC [ RunTime:0.004823s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58115535 LIMIT 2 [ RunTime:0.006903s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58115535 ORDER BY `minOrder` ASC [ RunTime:0.005543s ]
select * from pdf where partno='2213407-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.008988s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2213407-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.004734s ]
SELECT `id` FROM `stock` WHERE `id` <> 58115535 AND `partno` = '2213407-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.015392s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18913142 [ RunTime:0.001692s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55303966 LIMIT 5 [ RunTime:0.010465s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55303966 ORDER BY `minOrder` ASC [ RunTime:0.008083s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55303966 ORDER BY `unit` DESC [ RunTime:0.010683s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55303966 LIMIT 2 [ RunTime:0.016236s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55303966 ORDER BY `minOrder` ASC [ RunTime:0.004305s ]
select * from pdf where partno='2213189-3' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.002707s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2213189-3' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.004991s ]
SELECT `id` FROM `stock` WHERE `id` <> 55303966 AND `partno` = '2213189-3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.007606s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17313792 [ RunTime:0.028020s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55304300 LIMIT 5 [ RunTime:0.016796s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55304300 ORDER BY `minOrder` ASC [ RunTime:0.014123s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55304300 ORDER BY `unit` DESC [ RunTime:0.017915s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55304300 LIMIT 2 [ RunTime:0.000796s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55304300 ORDER BY `minOrder` ASC [ RunTime:0.003487s ]
select * from pdf where partno='2213262-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.008433s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2213262-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.004905s ]
SELECT `id` FROM `stock` WHERE `id` <> 55304300 AND `partno` = '2213262-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.011894s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15454266 [ RunTime:0.000432s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55304265 LIMIT 5 [ RunTime:0.000430s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55304265 ORDER BY `minOrder` ASC [ RunTime:0.007633s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55304265 ORDER BY `unit` DESC [ RunTime:0.001430s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55304265 LIMIT 2 [ RunTime:0.008016s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55304265 ORDER BY `minOrder` ASC [ RunTime:0.003216s ]
select * from pdf where partno='2213288-2' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.007424s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2213288-2' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.005906s ]
SELECT `id` FROM `stock` WHERE `id` <> 55304265 AND `partno` = '2213288-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.013956s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17313921 [ RunTime:0.001888s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56181796 LIMIT 5 [ RunTime:0.003035s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56181796 ORDER BY `minOrder` ASC [ RunTime:0.004425s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56181796 ORDER BY `unit` DESC [ RunTime:0.008750s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56181796 LIMIT 2 [ RunTime:0.018052s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56181796 ORDER BY `minOrder` ASC [ RunTime:0.001178s ]
select * from pdf where partno='2213C SL001' and brandshort='Alpha Wire' limit 1 [ RunTime:0.003884s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2213C SL001' OR `brand` LIKE 'Alpha Wire%' ) ) LIMIT 1 [ RunTime:0.004171s ]
SELECT `id` FROM `stock` WHERE `id` <> 56181796 AND `partno` = '2213C SL001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.002991s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13501825 [ RunTime:0.004654s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55303967 LIMIT 5 [ RunTime:0.008688s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55303967 ORDER BY `minOrder` ASC [ RunTime:0.014585s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55303967 ORDER BY `unit` DESC [ RunTime:0.006247s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55303967 LIMIT 2 [ RunTime:0.004624s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55303967 ORDER BY `minOrder` ASC [ RunTime:0.004429s ]
select * from pdf where partno='2213611-3' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.002112s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2213611-3' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.002105s ]
SELECT `id` FROM `stock` WHERE `id` <> 55303967 AND `partno` = '2213611-3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.012042s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15454170 [ RunTime:0.016503s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60361741 LIMIT 5 [ RunTime:0.000488s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60361741 ORDER BY `minOrder` ASC [ RunTime:0.008445s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60361741 ORDER BY `unit` DESC [ RunTime:0.012461s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60361741 LIMIT 2 [ RunTime:0.004105s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60361741 ORDER BY `minOrder` ASC [ RunTime:0.002632s ]
select * from pdf where partno='2213782-3' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.013854s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2213782-3' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.006705s ]
SELECT `id` FROM `stock` WHERE `id` <> 60361741 AND `partno` = '2213782-3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.032359s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58115842 LIMIT 5 [ RunTime:0.000851s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58115842 ORDER BY `minOrder` ASC [ RunTime:0.004198s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58115842 ORDER BY `unit` DESC [ RunTime:0.011307s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58115842 LIMIT 2 [ RunTime:0.000600s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58115842 ORDER BY `minOrder` ASC [ RunTime:0.000479s ]
select * from pdf where partno='2213407-1' and brandshort='TE Connectivity' limit 1 [ RunTime:0.003018s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2213407-1' OR `brand` LIKE 'TE Connectivity%' ) ) LIMIT 1 [ RunTime:0.023421s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56578646 LIMIT 5 [ RunTime:0.000888s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56578646 ORDER BY `minOrder` ASC [ RunTime:0.001210s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56578646 ORDER BY `unit` DESC [ RunTime:0.009033s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56578646 LIMIT 2 [ RunTime:0.019018s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56578646 ORDER BY `minOrder` ASC [ RunTime:0.017801s ]
select * from pdf where partno='2213' and brandshort='Keystone Electronics' limit 1 [ RunTime:0.016842s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2213' OR `brand` LIKE 'Keystone Electronics%' ) ) LIMIT 1 [ RunTime:0.009752s ]
SELECT `id` FROM `stock` WHERE `id` <> 56578646 AND `partno` = '2213' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%keystone electronics%' ) [ RunTime:0.014772s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12036649 [ RunTime:0.008235s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58115560 LIMIT 5 [ RunTime:0.000742s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58115560 ORDER BY `minOrder` ASC [ RunTime:0.000611s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58115560 ORDER BY `unit` DESC [ RunTime:0.007310s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58115560 LIMIT 2 [ RunTime:0.001932s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58115560 ORDER BY `minOrder` ASC [ RunTime:0.000381s ]
select * from pdf where partno='2213837-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.004661s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2213837-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.007462s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55304070 LIMIT 5 [ RunTime:0.009513s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55304070 ORDER BY `minOrder` ASC [ RunTime:0.008052s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55304070 ORDER BY `unit` DESC [ RunTime:0.004159s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55304070 LIMIT 2 [ RunTime:0.011565s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55304070 ORDER BY `minOrder` ASC [ RunTime:0.002568s ]
select * from pdf where partno='2213611-2' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.007491s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2213611-2' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.006452s ]
SELECT `id` FROM `stock` WHERE `id` <> 55304070 AND `partno` = '2213611-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.003525s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19668456 [ RunTime:0.002984s ]
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 '2213%' OR `brand` LIKE '2213%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003841s ]
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 '2213%' OR `brand` LIKE '2213%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000975s ]
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 '2213%' OR `brand` LIKE '2213%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004287s ]
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 '2213%' OR `brand` LIKE '2213%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004490s ]
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 '2213%' OR `brand` LIKE '2213%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002791s ]
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 '2213%' OR `brand` LIKE '2213%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001990s ]
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 '2213%' OR `brand` LIKE '2213%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001525s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '2213%' OR `brand` LIKE '2213%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.008100s ]