SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001600s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.215' , `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=8208&search=1' [ RunTime:0.009778s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001258s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.007012s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001938s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.215' ) [ RunTime:0.012479s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001316s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.006202s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001062s ]
SELECT * FROM `stock_search` WHERE `partno` = '8208' LIMIT 1 [ RunTime:0.007536s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-08-12 22:02:54' WHERE `partno` = '8208' [ RunTime:0.018549s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001211s ]
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 '8208%' OR `brand` LIKE '8208%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.067803s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001328s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12513729 LIMIT 5 [ RunTime:0.031035s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001652s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12513729 ORDER BY `minOrder` ASC [ RunTime:0.049227s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.018209s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12513729 ORDER BY `unit` DESC [ RunTime:0.029306s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.008104s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12513729 LIMIT 2 [ RunTime:0.018932s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12513729 ORDER BY `minOrder` ASC [ RunTime:0.005711s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12799933 LIMIT 5 [ RunTime:0.021572s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12799933 ORDER BY `minOrder` ASC [ RunTime:0.014144s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12799933 ORDER BY `unit` DESC [ RunTime:0.026848s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12799933 LIMIT 2 [ RunTime:0.018484s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12799933 ORDER BY `minOrder` ASC [ RunTime:0.009292s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19020849 LIMIT 5 [ RunTime:0.017923s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19020849 ORDER BY `minOrder` ASC [ RunTime:0.072580s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19020849 ORDER BY `unit` DESC [ RunTime:0.036521s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19020849 LIMIT 2 [ RunTime:0.024973s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19020849 ORDER BY `minOrder` ASC [ RunTime:0.026698s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18756716 LIMIT 5 [ RunTime:0.065657s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18756716 ORDER BY `minOrder` ASC [ RunTime:0.046473s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18756716 ORDER BY `unit` DESC [ RunTime:0.047445s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18756716 LIMIT 2 [ RunTime:0.043268s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18756716 ORDER BY `minOrder` ASC [ RunTime:0.025343s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18752539 LIMIT 5 [ RunTime:0.038663s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18752539 ORDER BY `minOrder` ASC [ RunTime:0.014264s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18752539 ORDER BY `unit` DESC [ RunTime:0.019352s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18752539 LIMIT 2 [ RunTime:0.040149s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18752539 ORDER BY `minOrder` ASC [ RunTime:0.002411s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18751560 LIMIT 5 [ RunTime:0.012780s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18751560 ORDER BY `minOrder` ASC [ RunTime:0.072622s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18751560 ORDER BY `unit` DESC [ RunTime:0.076439s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18751560 LIMIT 2 [ RunTime:0.022342s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18751560 ORDER BY `minOrder` ASC [ RunTime:0.031347s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18746222 LIMIT 5 [ RunTime:0.022879s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18746222 ORDER BY `minOrder` ASC [ RunTime:0.033105s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18746222 ORDER BY `unit` DESC [ RunTime:0.018725s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18746222 LIMIT 2 [ RunTime:0.048668s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18746222 ORDER BY `minOrder` ASC [ RunTime:0.016108s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18741734 LIMIT 5 [ RunTime:0.055900s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18741734 ORDER BY `minOrder` ASC [ RunTime:0.046353s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18741734 ORDER BY `unit` DESC [ RunTime:0.030778s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18741734 LIMIT 2 [ RunTime:0.016733s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18741734 ORDER BY `minOrder` ASC [ RunTime:0.014236s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18731559 LIMIT 5 [ RunTime:0.027473s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18731559 ORDER BY `minOrder` ASC [ RunTime:0.006719s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18731559 ORDER BY `unit` DESC [ RunTime:0.002685s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18731559 LIMIT 2 [ RunTime:0.000383s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18731559 ORDER BY `minOrder` ASC [ RunTime:0.001086s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17262466 LIMIT 5 [ RunTime:0.003093s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17262466 ORDER BY `minOrder` ASC [ RunTime:0.013273s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17262466 ORDER BY `unit` DESC [ RunTime:0.011173s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17262466 LIMIT 2 [ RunTime:0.000711s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17262466 ORDER BY `minOrder` ASC [ RunTime:0.000258s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17059357 LIMIT 5 [ RunTime:0.004984s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17059357 ORDER BY `minOrder` ASC [ RunTime:0.000546s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17059357 ORDER BY `unit` DESC [ RunTime:0.001954s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17059357 LIMIT 2 [ RunTime:0.001427s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17059357 ORDER BY `minOrder` ASC [ RunTime:0.000216s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17005818 LIMIT 5 [ RunTime:0.000655s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17005818 ORDER BY `minOrder` ASC [ RunTime:0.000955s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17005818 ORDER BY `unit` DESC [ RunTime:0.004678s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17005818 LIMIT 2 [ RunTime:0.004479s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17005818 ORDER BY `minOrder` ASC [ RunTime:0.000275s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15219641 LIMIT 5 [ RunTime:0.000647s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15219641 ORDER BY `minOrder` ASC [ RunTime:0.016090s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15219641 ORDER BY `unit` DESC [ RunTime:0.026702s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15219641 LIMIT 2 [ RunTime:0.012451s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15219641 ORDER BY `minOrder` ASC [ RunTime:0.010078s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15219640 LIMIT 5 [ RunTime:0.001095s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15219640 ORDER BY `minOrder` ASC [ RunTime:0.002576s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15219640 ORDER BY `unit` DESC [ RunTime:0.003398s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15219640 LIMIT 2 [ RunTime:0.000969s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15219640 ORDER BY `minOrder` ASC [ RunTime:0.004946s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15219639 LIMIT 5 [ RunTime:0.004744s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15219639 ORDER BY `minOrder` ASC [ RunTime:0.001808s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15219639 ORDER BY `unit` DESC [ RunTime:0.000615s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15219639 LIMIT 2 [ RunTime:0.000573s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15219639 ORDER BY `minOrder` ASC [ RunTime:0.001440s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15218621 LIMIT 5 [ RunTime:0.002057s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15218621 ORDER BY `minOrder` ASC [ RunTime:0.004825s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15218621 ORDER BY `unit` DESC [ RunTime:0.002654s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15218621 LIMIT 2 [ RunTime:0.009874s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15218621 ORDER BY `minOrder` ASC [ RunTime:0.000475s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14378204 LIMIT 5 [ RunTime:0.006131s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14378204 ORDER BY `minOrder` ASC [ RunTime:0.002421s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14378204 ORDER BY `unit` DESC [ RunTime:0.000612s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14378204 LIMIT 2 [ RunTime:0.004707s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14378204 ORDER BY `minOrder` ASC [ RunTime:0.002677s ]
select * from pdf where partno='8208 0605000' and brandshort='Belden Inc.' limit 1 [ RunTime:0.003700s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14176284 LIMIT 5 [ RunTime:0.001198s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14176284 ORDER BY `minOrder` ASC [ RunTime:0.007041s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14176284 ORDER BY `unit` DESC [ RunTime:0.008802s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14176284 LIMIT 2 [ RunTime:0.002270s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14176284 ORDER BY `minOrder` ASC [ RunTime:0.000472s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13505406 LIMIT 5 [ RunTime:0.001099s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13505406 ORDER BY `minOrder` ASC [ RunTime:0.002130s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13505406 ORDER BY `unit` DESC [ RunTime:0.020699s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13505406 LIMIT 2 [ RunTime:0.015352s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13505406 ORDER BY `minOrder` ASC [ RunTime:0.006145s ]
select * from pdf where partno='8208 060100' and brandshort='Belden Inc.' limit 1 [ RunTime:0.015935s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13504129 LIMIT 5 [ RunTime:0.004490s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13504129 ORDER BY `minOrder` ASC [ RunTime:0.016644s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13504129 ORDER BY `unit` DESC [ RunTime:0.040250s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13504129 LIMIT 2 [ RunTime:0.002274s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13504129 ORDER BY `minOrder` ASC [ RunTime:0.014410s ]
select * from pdf where partno='8208 060500' and brandshort='Belden Inc.' limit 1 [ RunTime:0.004327s ]
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 '8208%' OR `brand` LIKE '8208%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003705s ]
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 '8208%' OR `brand` LIKE '8208%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017998s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58736264 LIMIT 5 [ RunTime:0.005108s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58736264 ORDER BY `minOrder` ASC [ RunTime:0.006687s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58736264 ORDER BY `unit` DESC [ RunTime:0.011803s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58736264 LIMIT 2 [ RunTime:0.010194s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58736264 ORDER BY `minOrder` ASC [ RunTime:0.002962s ]
select * from pdf where partno='8208-2x20C30DR2PNT' and brandshort='Oupiin' limit 1 [ RunTime:0.001103s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.004688s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '8208-2x20C30DR2PNT' OR `brand` LIKE 'Oupiin%' ) ) LIMIT 1 [ RunTime:0.017498s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60647142 LIMIT 5 [ RunTime:0.003008s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60647142 ORDER BY `minOrder` ASC [ RunTime:0.009210s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60647142 ORDER BY `unit` DESC [ RunTime:0.015900s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60647142 LIMIT 2 [ RunTime:0.008687s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60647142 ORDER BY `minOrder` ASC [ RunTime:0.001101s ]
select * from pdf where partno='8208' and brandshort='Keystone Electronics' limit 1 [ RunTime:0.001474s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '8208' OR `brand` LIKE 'Keystone Electronics%' ) ) LIMIT 1 [ RunTime:0.001173s ]
SELECT `id` FROM `stock` WHERE `id` <> 60647142 AND `partno` = '8208' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%keystone electronics%' ) [ RunTime:0.011050s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12513729 [ RunTime:0.009470s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62420987 LIMIT 5 [ RunTime:0.002568s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62420987 ORDER BY `minOrder` ASC [ RunTime:0.001884s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62420987 ORDER BY `unit` DESC [ RunTime:0.003429s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62420987 LIMIT 2 [ RunTime:0.003318s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62420987 ORDER BY `minOrder` ASC [ RunTime:0.006287s ]
select * from pdf where partno='820886-SF' and brandshort='TE Connectivity' limit 1 [ RunTime:0.020511s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '820886-SF' OR `brand` LIKE 'TE Connectivity%' ) ) LIMIT 1 [ RunTime:0.029395s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62421855 LIMIT 5 [ RunTime:0.001148s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62421855 ORDER BY `minOrder` ASC [ RunTime:0.010215s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62421855 ORDER BY `unit` DESC [ RunTime:0.016089s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62421855 LIMIT 2 [ RunTime:0.030374s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62421855 ORDER BY `minOrder` ASC [ RunTime:0.015123s ]
select * from pdf where partno='820891-SF' and brandshort='TE Connectivity' limit 1 [ RunTime:0.004646s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '820891-SF' OR `brand` LIKE 'TE Connectivity%' ) ) LIMIT 1 [ RunTime:0.018792s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64131860 LIMIT 5 [ RunTime:0.019271s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64131860 ORDER BY `minOrder` ASC [ RunTime:0.043339s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64131860 ORDER BY `unit` DESC [ RunTime:0.014829s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64131860 LIMIT 2 [ RunTime:0.016690s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64131860 ORDER BY `minOrder` ASC [ RunTime:0.012934s ]
select * from pdf where partno='820860-SF' and brandshort='TE Connectivity' limit 1 [ RunTime:0.015542s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '820860-SF' OR `brand` LIKE 'TE Connectivity%' ) ) LIMIT 1 [ RunTime:0.035434s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64131834 LIMIT 5 [ RunTime:0.017249s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64131834 ORDER BY `minOrder` ASC [ RunTime:0.004303s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64131834 ORDER BY `unit` DESC [ RunTime:0.008132s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64131834 LIMIT 2 [ RunTime:0.011250s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64131834 ORDER BY `minOrder` ASC [ RunTime:0.007719s ]
select * from pdf where partno='820822-SF' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.014842s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '820822-SF' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.027072s ]
SELECT `id` FROM `stock` WHERE `id` <> 64131834 AND `partno` = '820822-SF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.029056s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64131923 LIMIT 5 [ RunTime:0.020117s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64131923 ORDER BY `minOrder` ASC [ RunTime:0.045126s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64131923 ORDER BY `unit` DESC [ RunTime:0.020563s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64131923 LIMIT 2 [ RunTime:0.013983s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64131923 ORDER BY `minOrder` ASC [ RunTime:0.014511s ]
select * from pdf where partno='820868-SF' and brandshort='TE Connectivity' limit 1 [ RunTime:0.003637s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '820868-SF' OR `brand` LIKE 'TE Connectivity%' ) ) LIMIT 1 [ RunTime:0.040843s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64131849 LIMIT 5 [ RunTime:0.048181s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64131849 ORDER BY `minOrder` ASC [ RunTime:0.020577s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64131849 ORDER BY `unit` DESC [ RunTime:0.022436s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64131849 LIMIT 2 [ RunTime:0.022008s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64131849 ORDER BY `minOrder` ASC [ RunTime:0.050479s ]
select * from pdf where partno='820858-SF' and brandshort='TE Connectivity' limit 1 [ RunTime:0.016793s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '820858-SF' OR `brand` LIKE 'TE Connectivity%' ) ) LIMIT 1 [ RunTime:0.038676s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64131894 LIMIT 5 [ RunTime:0.027537s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64131894 ORDER BY `minOrder` ASC [ RunTime:0.009410s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64131894 ORDER BY `unit` DESC [ RunTime:0.021082s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64131894 LIMIT 2 [ RunTime:0.017808s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64131894 ORDER BY `minOrder` ASC [ RunTime:0.009897s ]
select * from pdf where partno='820864-SF' and brandshort='TE Connectivity' limit 1 [ RunTime:0.004403s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '820864-SF' OR `brand` LIKE 'TE Connectivity%' ) ) LIMIT 1 [ RunTime:0.037098s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64131859 LIMIT 5 [ RunTime:0.013014s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64131859 ORDER BY `minOrder` ASC [ RunTime:0.002648s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64131859 ORDER BY `unit` DESC [ RunTime:0.010005s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64131859 LIMIT 2 [ RunTime:0.010196s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64131859 ORDER BY `minOrder` ASC [ RunTime:0.005026s ]
select * from pdf where partno='820836-SF' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.022976s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '820836-SF' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.002063s ]
SELECT `id` FROM `stock` WHERE `id` <> 64131859 AND `partno` = '820836-SF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.003357s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64131858 LIMIT 5 [ RunTime:0.007273s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64131858 ORDER BY `minOrder` ASC [ RunTime:0.022974s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64131858 ORDER BY `unit` DESC [ RunTime:0.023289s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64131858 LIMIT 2 [ RunTime:0.010466s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64131858 ORDER BY `minOrder` ASC [ RunTime:0.004368s ]
select * from pdf where partno='820836-SF' and brandshort='TE Connectivity' limit 1 [ RunTime:0.011241s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '820836-SF' OR `brand` LIKE 'TE Connectivity%' ) ) LIMIT 1 [ RunTime:0.034723s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64131836 LIMIT 5 [ RunTime:0.007566s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64131836 ORDER BY `minOrder` ASC [ RunTime:0.015168s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64131836 ORDER BY `unit` DESC [ RunTime:0.013547s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64131836 LIMIT 2 [ RunTime:0.004222s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64131836 ORDER BY `minOrder` ASC [ RunTime:0.001285s ]
select * from pdf where partno='820846-SF' and brandshort='TE Connectivity' limit 1 [ RunTime:0.011730s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '820846-SF' OR `brand` LIKE 'TE Connectivity%' ) ) LIMIT 1 [ RunTime:0.034511s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63448648 LIMIT 5 [ RunTime:0.007756s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63448648 ORDER BY `minOrder` ASC [ RunTime:0.009843s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63448648 ORDER BY `unit` DESC [ RunTime:0.006254s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63448648 LIMIT 2 [ RunTime:0.012007s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63448648 ORDER BY `minOrder` ASC [ RunTime:0.000222s ]
select * from pdf where partno='8208500' and brandshort='Rittal' limit 1 [ RunTime:0.000732s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '8208500' OR `brand` LIKE 'Rittal%' ) ) LIMIT 1 [ RunTime:0.002942s ]
SELECT `id` FROM `stock` WHERE `id` <> 63448648 AND `partno` = '8208500' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%rittal%' ) [ RunTime:0.008444s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17059357 [ RunTime:0.002681s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63022722 LIMIT 5 [ RunTime:0.000334s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63022722 ORDER BY `minOrder` ASC [ RunTime:0.010312s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63022722 ORDER BY `unit` DESC [ RunTime:0.005742s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63022722 LIMIT 2 [ RunTime:0.000481s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63022722 ORDER BY `minOrder` ASC [ RunTime:0.000310s ]
select * from pdf where partno='8208 060100' and brandshort='Belden Inc.' limit 1 [ RunTime:0.011281s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '8208 060100' OR `brand` LIKE 'Belden Inc.%' ) ) LIMIT 1 [ RunTime:0.008593s ]
SELECT `id` FROM `stock` WHERE `id` <> 63022722 AND `partno` = '8208 060100' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%belden inc.%' ) [ RunTime:0.014427s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13505406 [ RunTime:0.007793s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63021506 LIMIT 5 [ RunTime:0.004516s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63021506 ORDER BY `minOrder` ASC [ RunTime:0.000941s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63021506 ORDER BY `unit` DESC [ RunTime:0.009885s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63021506 LIMIT 2 [ RunTime:0.016845s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63021506 ORDER BY `minOrder` ASC [ RunTime:0.006691s ]
select * from pdf where partno='8208 060500' and brandshort='Belden Inc.' limit 1 [ RunTime:0.006591s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '8208 060500' OR `brand` LIKE 'Belden Inc.%' ) ) LIMIT 1 [ RunTime:0.008155s ]
SELECT `id` FROM `stock` WHERE `id` <> 63021506 AND `partno` = '8208 060500' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%belden inc.%' ) [ RunTime:0.000915s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13504129 [ RunTime:0.024712s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63021505 LIMIT 5 [ RunTime:0.035602s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63021505 ORDER BY `minOrder` ASC [ RunTime:0.005937s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63021505 ORDER BY `unit` DESC [ RunTime:0.021991s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63021505 LIMIT 2 [ RunTime:0.007414s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63021505 ORDER BY `minOrder` ASC [ RunTime:0.005893s ]
select * from pdf where partno='8208 0601000' and brandshort='Belden Inc.' limit 1 [ RunTime:0.004288s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '8208 0601000' OR `brand` LIKE 'Belden Inc.%' ) ) LIMIT 1 [ RunTime:0.017823s ]
SELECT `id` FROM `stock` WHERE `id` <> 63021505 AND `partno` = '8208 0601000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%belden inc.%' ) [ RunTime:0.012339s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13503825 [ RunTime:0.006357s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63021503 LIMIT 5 [ RunTime:0.006518s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63021503 ORDER BY `minOrder` ASC [ RunTime:0.004340s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63021503 ORDER BY `unit` DESC [ RunTime:0.024387s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63021503 LIMIT 2 [ RunTime:0.010578s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63021503 ORDER BY `minOrder` ASC [ RunTime:0.002207s ]
select * from pdf where partno='8208 0605000' and brandshort='Belden Inc.' limit 1 [ RunTime:0.002170s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '8208 0605000' OR `brand` LIKE 'Belden Inc.%' ) ) LIMIT 1 [ RunTime:0.012324s ]
SELECT `id` FROM `stock` WHERE `id` <> 63021503 AND `partno` = '8208 0605000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%belden inc.%' ) [ RunTime:0.007207s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14378204 [ RunTime:0.002879s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63021414 LIMIT 5 [ RunTime:0.012768s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63021414 ORDER BY `minOrder` ASC [ RunTime:0.004097s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63021414 ORDER BY `unit` DESC [ RunTime:0.014906s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63021414 LIMIT 2 [ RunTime:0.000939s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63021414 ORDER BY `minOrder` ASC [ RunTime:0.000799s ]
select * from pdf where partno='8208 060U1000' and brandshort='Belden Inc.' limit 1 [ RunTime:0.001141s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '8208 060U1000' OR `brand` LIKE 'Belden Inc.%' ) ) LIMIT 1 [ RunTime:0.003267s ]
SELECT `id` FROM `stock` WHERE `id` <> 63021414 AND `partno` = '8208 060U1000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%belden inc.%' ) [ RunTime:0.023531s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13503776 [ RunTime:0.004843s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59918475 LIMIT 5 [ RunTime:0.023108s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59918475 ORDER BY `minOrder` ASC [ RunTime:0.006456s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59918475 ORDER BY `unit` DESC [ RunTime:0.011008s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59918475 LIMIT 2 [ RunTime:0.015705s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59918475 ORDER BY `minOrder` ASC [ RunTime:0.018847s ]
select * from pdf where partno='82080-6000RB' and brandshort='3M' limit 1 [ RunTime:0.014577s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '82080-6000RB' OR `brand` LIKE '3M%' ) ) LIMIT 1 [ RunTime:0.015931s ]
SELECT `id` FROM `stock` WHERE `id` <> 59918475 AND `partno` = '82080-6000RB' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%3m%' ) [ RunTime:0.010127s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12796192 [ RunTime:0.009310s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59917849 LIMIT 5 [ RunTime:0.009228s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59917849 ORDER BY `minOrder` ASC [ RunTime:0.011551s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59917849 ORDER BY `unit` DESC [ RunTime:0.012542s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59917849 LIMIT 2 [ RunTime:0.020585s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59917849 ORDER BY `minOrder` ASC [ RunTime:0.004931s ]
select * from pdf where partno='82080-6006RB' and brandshort='3M' limit 1 [ RunTime:0.014750s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '82080-6006RB' OR `brand` LIKE '3M%' ) ) LIMIT 1 [ RunTime:0.025692s ]
SELECT `id` FROM `stock` WHERE `id` <> 59917849 AND `partno` = '82080-6006RB' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%3m%' ) [ RunTime:0.030729s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11613173 [ RunTime:0.035235s ]
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 '8208%' OR `brand` LIKE '8208%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.021828s ]
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 '8208%' OR `brand` LIKE '8208%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014656s ]
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 '8208%' OR `brand` LIKE '8208%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.050248s ]
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 '8208%' OR `brand` LIKE '8208%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.033305s ]
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 '8208%' OR `brand` LIKE '8208%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.031517s ]
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 '8208%' OR `brand` LIKE '8208%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.020110s ]
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 '8208%' OR `brand` LIKE '8208%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017330s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '8208%' OR `brand` LIKE '8208%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.021798s ]