SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001583s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.133' , `useragent` = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)' , `reffer` = '' , `host` = 'https://www.ic118.com/stock?keyword=5050&search=1' [ RunTime:0.004038s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001195s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000477s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001677s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.133' ) [ RunTime:0.001412s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002389s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000318s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001419s ]
SELECT * FROM `stock_search` WHERE `partno` = '5050' LIMIT 1 [ RunTime:0.006923s ]
UPDATE `stock_search` SET `count` = 3 , `updatetime` = '2026-08-19 08:11:31' WHERE `partno` = '5050' [ RunTime:0.004561s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001709s ]
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 '5050%' OR `brand` LIKE '5050%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.043142s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001639s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19667831 LIMIT 5 [ RunTime:0.003827s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.007965s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19667831 ORDER BY `minOrder` ASC [ RunTime:0.004293s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001528s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19667831 ORDER BY `unit` DESC [ RunTime:0.000512s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.004478s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19667831 LIMIT 2 [ RunTime:0.011505s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19667831 ORDER BY `minOrder` ASC [ RunTime:0.005001s ]
select * from pdf where partno='5050720101' and brandshort='Molex' limit 1 [ RunTime:0.014451s ]
select foldpath,foldpath2,filename from pdf_file where id=1874994 limit 1 [ RunTime:0.002055s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12780403 LIMIT 5 [ RunTime:0.003940s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12780403 ORDER BY `minOrder` ASC [ RunTime:0.001572s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12780403 ORDER BY `unit` DESC [ RunTime:0.000441s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12780403 LIMIT 2 [ RunTime:0.010294s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12780403 ORDER BY `minOrder` ASC [ RunTime:0.002084s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19593953 LIMIT 5 [ RunTime:0.018174s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19593953 ORDER BY `minOrder` ASC [ RunTime:0.002646s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19593953 ORDER BY `unit` DESC [ RunTime:0.003010s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19593953 LIMIT 2 [ RunTime:0.014044s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19593953 ORDER BY `minOrder` ASC [ RunTime:0.002077s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19667830 LIMIT 5 [ RunTime:0.011385s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19667830 ORDER BY `minOrder` ASC [ RunTime:0.034702s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19667830 ORDER BY `unit` DESC [ RunTime:0.006420s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19667830 LIMIT 2 [ RunTime:0.015145s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19667830 ORDER BY `minOrder` ASC [ RunTime:0.019429s ]
select * from pdf where partno='5050710101' and brandshort='Molex' limit 1 [ RunTime:0.002968s ]
select foldpath,foldpath2,filename from pdf_file where id=1333542 limit 1 [ RunTime:0.014072s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12780402 LIMIT 5 [ RunTime:0.001960s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12780402 ORDER BY `minOrder` ASC [ RunTime:0.010925s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12780402 ORDER BY `unit` DESC [ RunTime:0.010003s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12780402 LIMIT 2 [ RunTime:0.009627s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12780402 ORDER BY `minOrder` ASC [ RunTime:0.005501s ]
select * from pdf where partno='5050660622' and brandshort='Molex' limit 1 [ RunTime:0.015716s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11611098 LIMIT 5 [ RunTime:0.007970s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11611098 ORDER BY `minOrder` ASC [ RunTime:0.018711s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11611098 ORDER BY `unit` DESC [ RunTime:0.028047s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11611098 LIMIT 2 [ RunTime:0.021052s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11611098 ORDER BY `minOrder` ASC [ RunTime:0.021639s ]
select * from pdf where partno='5050700622' and brandshort='Molex' limit 1 [ RunTime:0.008653s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19593970 LIMIT 5 [ RunTime:0.013492s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19593970 ORDER BY `minOrder` ASC [ RunTime:0.011669s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19593970 ORDER BY `unit` DESC [ RunTime:0.013154s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19593970 LIMIT 2 [ RunTime:0.009751s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19593970 ORDER BY `minOrder` ASC [ RunTime:0.008964s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15443250 LIMIT 5 [ RunTime:0.005799s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15443250 ORDER BY `minOrder` ASC [ RunTime:0.012760s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15443250 ORDER BY `unit` DESC [ RunTime:0.038405s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15443250 LIMIT 2 [ RunTime:0.009333s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15443250 ORDER BY `minOrder` ASC [ RunTime:0.009685s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11601294 LIMIT 5 [ RunTime:0.028893s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11601294 ORDER BY `minOrder` ASC [ RunTime:0.055733s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11601294 ORDER BY `unit` DESC [ RunTime:0.018759s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11601294 LIMIT 2 [ RunTime:0.014304s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11601294 ORDER BY `minOrder` ASC [ RunTime:0.021371s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17300498 LIMIT 5 [ RunTime:0.007464s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17300498 ORDER BY `minOrder` ASC [ RunTime:0.007547s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17300498 ORDER BY `unit` DESC [ RunTime:0.010168s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17300498 LIMIT 2 [ RunTime:0.024018s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17300498 ORDER BY `minOrder` ASC [ RunTime:0.019031s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11611099 LIMIT 5 [ RunTime:0.012253s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11611099 ORDER BY `minOrder` ASC [ RunTime:0.023230s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11611099 ORDER BY `unit` DESC [ RunTime:0.011940s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11611099 LIMIT 2 [ RunTime:0.009391s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11611099 ORDER BY `minOrder` ASC [ RunTime:0.008039s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12793044 LIMIT 5 [ RunTime:0.006366s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12793044 ORDER BY `minOrder` ASC [ RunTime:0.043991s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12793044 ORDER BY `unit` DESC [ RunTime:0.040741s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12793044 LIMIT 2 [ RunTime:0.063597s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12793044 ORDER BY `minOrder` ASC [ RunTime:0.014955s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11610680 LIMIT 5 [ RunTime:0.010842s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11610680 ORDER BY `minOrder` ASC [ RunTime:0.025456s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11610680 ORDER BY `unit` DESC [ RunTime:0.023511s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11610680 LIMIT 2 [ RunTime:0.002432s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11610680 ORDER BY `minOrder` ASC [ RunTime:0.000472s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12793701 LIMIT 5 [ RunTime:0.007879s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12793701 ORDER BY `minOrder` ASC [ RunTime:0.019738s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12793701 ORDER BY `unit` DESC [ RunTime:0.011585s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12793701 LIMIT 2 [ RunTime:0.000653s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12793701 ORDER BY `minOrder` ASC [ RunTime:0.004018s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12794229 LIMIT 5 [ RunTime:0.021861s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12794229 ORDER BY `minOrder` ASC [ RunTime:0.024728s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12794229 ORDER BY `unit` DESC [ RunTime:0.028929s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12794229 LIMIT 2 [ RunTime:0.022699s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12794229 ORDER BY `minOrder` ASC [ RunTime:0.046425s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12793716 LIMIT 5 [ RunTime:0.029951s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12793716 ORDER BY `minOrder` ASC [ RunTime:0.022185s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12793716 ORDER BY `unit` DESC [ RunTime:0.025385s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12793716 LIMIT 2 [ RunTime:0.010310s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12793716 ORDER BY `minOrder` ASC [ RunTime:0.001217s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11601290 LIMIT 5 [ RunTime:0.001485s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11601290 ORDER BY `minOrder` ASC [ RunTime:0.016068s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11601290 ORDER BY `unit` DESC [ RunTime:0.002358s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11601290 LIMIT 2 [ RunTime:0.006329s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11601290 ORDER BY `minOrder` ASC [ RunTime:0.004357s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 988 LIMIT 5 [ RunTime:0.013513s ]
SELECT * FROM `stock_price` WHERE `stockid` = 988 ORDER BY `minOrder` ASC [ RunTime:0.030085s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 988 ORDER BY `unit` DESC [ RunTime:0.022587s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 988 LIMIT 2 [ RunTime:0.003365s ]
SELECT * FROM `stock_price` WHERE `stockid` = 988 ORDER BY `minOrder` ASC [ RunTime:0.028709s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002684s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5050935-2' OR `brand` LIKE 'AMP - TE CONNECTIVITY%' ) ) LIMIT 1 [ RunTime:0.021359s ]
SELECT `id` FROM `stock` WHERE `id` <> 988 AND `partno` = '5050935-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amp - te connectivity%' ) [ RunTime:0.027443s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12780407 LIMIT 5 [ RunTime:0.019970s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12780407 ORDER BY `minOrder` ASC [ RunTime:0.025046s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12780407 ORDER BY `unit` DESC [ RunTime:0.007214s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12780407 LIMIT 2 [ RunTime:0.037543s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12780407 ORDER BY `minOrder` ASC [ RunTime:0.001348s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11611100 LIMIT 5 [ RunTime:0.004348s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11611100 ORDER BY `minOrder` ASC [ RunTime:0.009214s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11611100 ORDER BY `unit` DESC [ RunTime:0.035382s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11611100 LIMIT 2 [ RunTime:0.008623s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11611100 ORDER BY `minOrder` ASC [ RunTime:0.009111s ]
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 '5050%' OR `brand` LIKE '5050%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.023096s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32268379 LIMIT 5 [ RunTime:0.010395s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32268379 ORDER BY `minOrder` ASC [ RunTime:0.019313s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32268379 ORDER BY `unit` DESC [ RunTime:0.000563s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32268379 LIMIT 2 [ RunTime:0.002436s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32268379 ORDER BY `minOrder` ASC [ RunTime:0.000402s ]
select * from pdf where partno='505070-3022' and brandshort='molex' limit 1 [ RunTime:0.005919s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '505070-3022' OR `brand` LIKE 'molex%' ) ) LIMIT 1 [ RunTime:0.063592s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32269089 LIMIT 5 [ RunTime:0.026994s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32269089 ORDER BY `minOrder` ASC [ RunTime:0.027796s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32269089 ORDER BY `unit` DESC [ RunTime:0.044763s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32269089 LIMIT 2 [ RunTime:0.029922s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32269089 ORDER BY `minOrder` ASC [ RunTime:0.027111s ]
select * from pdf where partno='505070-2442' and brandshort='molex' limit 1 [ RunTime:0.057578s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '505070-2442' OR `brand` LIKE 'molex%' ) ) LIMIT 1 [ RunTime:0.064631s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32269382 LIMIT 5 [ RunTime:0.029322s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32269382 ORDER BY `minOrder` ASC [ RunTime:0.013986s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32269382 ORDER BY `unit` DESC [ RunTime:0.008042s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32269382 LIMIT 2 [ RunTime:0.026752s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32269382 ORDER BY `minOrder` ASC [ RunTime:0.009473s ]
select * from pdf where partno='505070-1642' and brandshort='molex' limit 1 [ RunTime:0.022275s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '505070-1642' OR `brand` LIKE 'molex%' ) ) LIMIT 1 [ RunTime:0.019746s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32269380 LIMIT 5 [ RunTime:0.000529s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32269380 ORDER BY `minOrder` ASC [ RunTime:0.003683s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32269380 ORDER BY `unit` DESC [ RunTime:0.006673s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32269380 LIMIT 2 [ RunTime:0.026809s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32269380 ORDER BY `minOrder` ASC [ RunTime:0.017566s ]
select * from pdf where partno='505070-0822' and brandshort='molex' limit 1 [ RunTime:0.015920s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '505070-0822' OR `brand` LIKE 'molex%' ) ) LIMIT 1 [ RunTime:0.042367s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32268449 LIMIT 5 [ RunTime:0.020123s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32268449 ORDER BY `minOrder` ASC [ RunTime:0.029662s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32268449 ORDER BY `unit` DESC [ RunTime:0.064377s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32268449 LIMIT 2 [ RunTime:0.028570s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32268449 ORDER BY `minOrder` ASC [ RunTime:0.006381s ]
select * from pdf where partno='505066-0822' and brandshort='molex' limit 1 [ RunTime:0.030190s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '505066-0822' OR `brand` LIKE 'molex%' ) ) LIMIT 1 [ RunTime:0.031423s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32269381 LIMIT 5 [ RunTime:0.030278s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32269381 ORDER BY `minOrder` ASC [ RunTime:0.016384s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32269381 ORDER BY `unit` DESC [ RunTime:0.015135s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32269381 LIMIT 2 [ RunTime:0.020140s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32269381 ORDER BY `minOrder` ASC [ RunTime:0.003723s ]
select * from pdf where partno='505070-1222' and brandshort='molex' limit 1 [ RunTime:0.000705s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '505070-1222' OR `brand` LIKE 'molex%' ) ) LIMIT 1 [ RunTime:0.023288s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32269090 LIMIT 5 [ RunTime:0.021890s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32269090 ORDER BY `minOrder` ASC [ RunTime:0.014412s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32269090 ORDER BY `unit` DESC [ RunTime:0.041226s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32269090 LIMIT 2 [ RunTime:0.020641s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32269090 ORDER BY `minOrder` ASC [ RunTime:0.021138s ]
select * from pdf where partno='505070-3442' and brandshort='molex' limit 1 [ RunTime:0.030817s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '505070-3442' OR `brand` LIKE 'molex%' ) ) LIMIT 1 [ RunTime:0.026192s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32269379 LIMIT 5 [ RunTime:0.025691s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32269379 ORDER BY `minOrder` ASC [ RunTime:0.073083s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32269379 ORDER BY `unit` DESC [ RunTime:0.031881s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32269379 LIMIT 2 [ RunTime:0.013661s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32269379 ORDER BY `minOrder` ASC [ RunTime:0.054034s ]
select * from pdf where partno='505066-1422' and brandshort='molex' limit 1 [ RunTime:0.040361s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '505066-1422' OR `brand` LIKE 'molex%' ) ) LIMIT 1 [ RunTime:0.036514s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32256460 LIMIT 5 [ RunTime:0.043287s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32256460 ORDER BY `minOrder` ASC [ RunTime:0.069929s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32256460 ORDER BY `unit` DESC [ RunTime:0.020290s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32256460 LIMIT 2 [ RunTime:0.060030s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32256460 ORDER BY `minOrder` ASC [ RunTime:0.060372s ]
select * from pdf where partno='5050462-2' and brandshort='te connectivity / amp' limit 1 [ RunTime:0.036171s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5050462-2' OR `brand` LIKE 'te connectivity / amp%' ) ) LIMIT 1 [ RunTime:0.094714s ]
SELECT `id` FROM `stock` WHERE `id` <> 32256460 AND `partno` = '5050462-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity / amp%' ) [ RunTime:0.141981s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32256465 LIMIT 5 [ RunTime:0.101853s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32256465 ORDER BY `minOrder` ASC [ RunTime:0.078082s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32256465 ORDER BY `unit` DESC [ RunTime:0.072432s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32256465 LIMIT 2 [ RunTime:0.118809s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32256465 ORDER BY `minOrder` ASC [ RunTime:0.028573s ]
select * from pdf where partno='5050865-5' and brandshort='te connectivity / amp' limit 1 [ RunTime:0.147026s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5050865-5' OR `brand` LIKE 'te connectivity / amp%' ) ) LIMIT 1 [ RunTime:0.078083s ]
SELECT `id` FROM `stock` WHERE `id` <> 32256465 AND `partno` = '5050865-5' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity / amp%' ) [ RunTime:0.125259s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32255802 LIMIT 5 [ RunTime:0.027003s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32255802 ORDER BY `minOrder` ASC [ RunTime:0.106986s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32255802 ORDER BY `unit` DESC [ RunTime:0.126970s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32255802 LIMIT 2 [ RunTime:0.096497s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32255802 ORDER BY `minOrder` ASC [ RunTime:0.022397s ]
select * from pdf where partno='5050462-7' and brandshort='te connectivity' limit 1 [ RunTime:0.089805s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5050462-7' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.062277s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32256461 LIMIT 5 [ RunTime:0.040070s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32256461 ORDER BY `minOrder` ASC [ RunTime:0.016575s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32256461 ORDER BY `unit` DESC [ RunTime:0.061221s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32256461 LIMIT 2 [ RunTime:0.030270s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32256461 ORDER BY `minOrder` ASC [ RunTime:0.048550s ]
select * from pdf where partno='5050462-8' and brandshort='te connectivity / amp' limit 1 [ RunTime:0.059665s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5050462-8' OR `brand` LIKE 'te connectivity / amp%' ) ) LIMIT 1 [ RunTime:0.043197s ]
SELECT `id` FROM `stock` WHERE `id` <> 32256461 AND `partno` = '5050462-8' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity / amp%' ) [ RunTime:0.018334s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32256462 LIMIT 5 [ RunTime:0.036519s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32256462 ORDER BY `minOrder` ASC [ RunTime:0.042638s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32256462 ORDER BY `unit` DESC [ RunTime:0.059228s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32256462 LIMIT 2 [ RunTime:0.039779s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32256462 ORDER BY `minOrder` ASC [ RunTime:0.003864s ]
select * from pdf where partno='5050863-5' and brandshort='te connectivity' limit 1 [ RunTime:0.076005s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5050863-5' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.050276s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32256463 LIMIT 5 [ RunTime:0.008740s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32256463 ORDER BY `minOrder` ASC [ RunTime:0.059544s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32256463 ORDER BY `unit` DESC [ RunTime:0.030091s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32256463 LIMIT 2 [ RunTime:0.000669s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32256463 ORDER BY `minOrder` ASC [ RunTime:0.033530s ]
select * from pdf where partno='5050864-1' and brandshort='te connectivity / amp' limit 1 [ RunTime:0.047021s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5050864-1' OR `brand` LIKE 'te connectivity / amp%' ) ) LIMIT 1 [ RunTime:0.058460s ]
SELECT `id` FROM `stock` WHERE `id` <> 32256463 AND `partno` = '5050864-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity / amp%' ) [ RunTime:0.032964s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32269088 LIMIT 5 [ RunTime:0.016207s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32269088 ORDER BY `minOrder` ASC [ RunTime:0.004965s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32269088 ORDER BY `unit` DESC [ RunTime:0.038935s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32269088 LIMIT 2 [ RunTime:0.046652s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32269088 ORDER BY `minOrder` ASC [ RunTime:0.019362s ]
select * from pdf where partno='505066-3022' and brandshort='molex' limit 1 [ RunTime:0.015235s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '505066-3022' OR `brand` LIKE 'molex%' ) ) LIMIT 1 [ RunTime:0.046700s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32256464 LIMIT 5 [ RunTime:0.029541s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32256464 ORDER BY `minOrder` ASC [ RunTime:0.001210s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32256464 ORDER BY `unit` DESC [ RunTime:0.019139s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32256464 LIMIT 2 [ RunTime:0.013091s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32256464 ORDER BY `minOrder` ASC [ RunTime:0.022354s ]
select * from pdf where partno='5050864-5' and brandshort='te connectivity' limit 1 [ RunTime:0.001774s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5050864-5' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.013533s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32269226 LIMIT 5 [ RunTime:0.000462s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32269226 ORDER BY `minOrder` ASC [ RunTime:0.003845s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32269226 ORDER BY `unit` DESC [ RunTime:0.000407s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32269226 LIMIT 2 [ RunTime:0.002143s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32269226 ORDER BY `minOrder` ASC [ RunTime:0.001120s ]
select * from pdf where partno='505066-2222' and brandshort='molex' limit 1 [ RunTime:0.007936s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '505066-2222' OR `brand` LIKE 'molex%' ) ) LIMIT 1 [ RunTime:0.012313s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32256466 LIMIT 5 [ RunTime:0.018484s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32256466 ORDER BY `minOrder` ASC [ RunTime:0.001978s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32256466 ORDER BY `unit` DESC [ RunTime:0.004995s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32256466 LIMIT 2 [ RunTime:0.001089s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32256466 ORDER BY `minOrder` ASC [ RunTime:0.002706s ]
select * from pdf where partno='5050865-8' and brandshort='te connectivity' limit 1 [ RunTime:0.002055s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5050865-8' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.018361s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32268938 LIMIT 5 [ RunTime:0.011390s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32268938 ORDER BY `minOrder` ASC [ RunTime:0.011208s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32268938 ORDER BY `unit` DESC [ RunTime:0.015831s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32268938 LIMIT 2 [ RunTime:0.024237s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32268938 ORDER BY `minOrder` ASC [ RunTime:0.006490s ]
select * from pdf where partno='505070-4822' and brandshort='molex' limit 1 [ RunTime:0.001892s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '505070-4822' OR `brand` LIKE 'molex%' ) ) LIMIT 1 [ RunTime:0.017391s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32256783 LIMIT 5 [ RunTime:0.008577s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32256783 ORDER BY `minOrder` ASC [ RunTime:0.004030s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32256783 ORDER BY `unit` DESC [ RunTime:0.011438s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32256783 LIMIT 2 [ RunTime:0.005171s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32256783 ORDER BY `minOrder` ASC [ RunTime:0.003774s ]
select * from pdf where partno='5050865-3' and brandshort='te connectivity' limit 1 [ RunTime:0.002990s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5050865-3' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.022997s ]
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 '5050%' OR `brand` LIKE '5050%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.020367s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59362091 LIMIT 5 [ RunTime:0.012091s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59362091 ORDER BY `minOrder` ASC [ RunTime:0.026073s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59362091 ORDER BY `unit` DESC [ RunTime:0.007029s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59362091 LIMIT 2 [ RunTime:0.000483s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59362091 ORDER BY `minOrder` ASC [ RunTime:0.009496s ]
select * from pdf where partno='505070-0860' and brandshort='WEC' limit 1 [ RunTime:0.012709s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '505070-0860' OR `brand` LIKE 'WEC%' ) ) LIMIT 1 [ RunTime:0.021205s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59362104 LIMIT 5 [ RunTime:0.008975s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59362104 ORDER BY `minOrder` ASC [ RunTime:0.013041s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59362104 ORDER BY `unit` DESC [ RunTime:0.010701s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59362104 LIMIT 2 [ RunTime:0.018721s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59362104 ORDER BY `minOrder` ASC [ RunTime:0.002357s ]
select * from pdf where partno='505070-5442' and brandshort='WEC' limit 1 [ RunTime:0.002697s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '505070-5442' OR `brand` LIKE 'WEC%' ) ) LIMIT 1 [ RunTime:0.028303s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59359955 LIMIT 5 [ RunTime:0.041145s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59359955 ORDER BY `minOrder` ASC [ RunTime:0.013811s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59359955 ORDER BY `unit` DESC [ RunTime:0.012321s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59359955 LIMIT 2 [ RunTime:0.021982s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59359955 ORDER BY `minOrder` ASC [ RunTime:0.000413s ]
select * from pdf where partno='5050662220' and brandshort='Molex' limit 1 [ RunTime:0.019491s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5050662220' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.018307s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59359987 LIMIT 5 [ RunTime:0.006840s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59359987 ORDER BY `minOrder` ASC [ RunTime:0.006867s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59359987 ORDER BY `unit` DESC [ RunTime:0.016246s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59359987 LIMIT 2 [ RunTime:0.031968s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59359987 ORDER BY `minOrder` ASC [ RunTime:0.003787s ]
select * from pdf where partno='5050702020' and brandshort='Molex' limit 1 [ RunTime:0.026998s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5050702020' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.034408s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59359974 LIMIT 5 [ RunTime:0.018123s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59359974 ORDER BY `minOrder` ASC [ RunTime:0.011002s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59359974 ORDER BY `unit` DESC [ RunTime:0.016559s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59359974 LIMIT 2 [ RunTime:0.011436s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59359974 ORDER BY `minOrder` ASC [ RunTime:0.010633s ]
select * from pdf where partno='5050702220' and brandshort='Molex' limit 1 [ RunTime:0.022301s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5050702220' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.028834s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59355010 LIMIT 5 [ RunTime:0.017290s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59355010 ORDER BY `minOrder` ASC [ RunTime:0.014613s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59355010 ORDER BY `unit` DESC [ RunTime:0.013816s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59355010 LIMIT 2 [ RunTime:0.005772s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59355010 ORDER BY `minOrder` ASC [ RunTime:0.021210s ]
select * from pdf where partno='5050060812' and brandshort='Molex' limit 1 [ RunTime:0.016968s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5050060812' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.016175s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60313577 LIMIT 5 [ RunTime:0.033501s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60313577 ORDER BY `minOrder` ASC [ RunTime:0.048612s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60313577 ORDER BY `unit` DESC [ RunTime:0.046916s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60313577 LIMIT 2 [ RunTime:0.053375s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60313577 ORDER BY `minOrder` ASC [ RunTime:0.020477s ]
select * from pdf where partno='5050935-2' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.021723s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5050935-2' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.009460s ]
SELECT `id` FROM `stock` WHERE `id` <> 60313577 AND `partno` = '5050935-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.045655s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19593953 [ RunTime:0.028396s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62126357 LIMIT 5 [ RunTime:0.026450s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62126357 ORDER BY `minOrder` ASC [ RunTime:0.024924s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62126357 ORDER BY `unit` DESC [ RunTime:0.000807s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62126357 LIMIT 2 [ RunTime:0.014673s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62126357 ORDER BY `minOrder` ASC [ RunTime:0.008827s ]
select * from pdf where partno='5050710101' and brandshort='Molex' limit 1 [ RunTime:0.005003s ]
select foldpath,foldpath2,filename from pdf_file where id=1333542 limit 1 [ RunTime:0.007075s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5050710101' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.024013s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59355690 LIMIT 5 [ RunTime:0.023704s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59355690 ORDER BY `minOrder` ASC [ RunTime:0.007180s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59355690 ORDER BY `unit` DESC [ RunTime:0.000620s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59355690 LIMIT 2 [ RunTime:0.003026s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59355690 ORDER BY `minOrder` ASC [ RunTime:0.000460s ]
select * from pdf where partno='5050704022' and brandshort='Molex' limit 1 [ RunTime:0.006208s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5050704022' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.013852s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59355680 LIMIT 5 [ RunTime:0.002834s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59355680 ORDER BY `minOrder` ASC [ RunTime:0.000819s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59355680 ORDER BY `unit` DESC [ RunTime:0.000636s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59355680 LIMIT 2 [ RunTime:0.008217s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59355680 ORDER BY `minOrder` ASC [ RunTime:0.000486s ]
select * from pdf where partno='5050664022' and brandshort='Molex' limit 1 [ RunTime:0.001018s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5050664022' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.015561s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59355008 LIMIT 5 [ RunTime:0.005850s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59355008 ORDER BY `minOrder` ASC [ RunTime:0.002418s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59355008 ORDER BY `unit` DESC [ RunTime:0.012793s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59355008 LIMIT 2 [ RunTime:0.013404s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59355008 ORDER BY `minOrder` ASC [ RunTime:0.000444s ]
select * from pdf where partno='5050700622' and brandshort='Molex' limit 1 [ RunTime:0.000643s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5050700622' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.015977s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59355043 LIMIT 5 [ RunTime:0.004077s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59355043 ORDER BY `minOrder` ASC [ RunTime:0.014043s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59355043 ORDER BY `unit` DESC [ RunTime:0.003386s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59355043 LIMIT 2 [ RunTime:0.003468s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59355043 ORDER BY `minOrder` ASC [ RunTime:0.000483s ]
select * from pdf where partno='5050662422' and brandshort='Molex' limit 1 [ RunTime:0.007374s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5050662422' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.012608s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60313649 LIMIT 5 [ RunTime:0.000627s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60313649 ORDER BY `minOrder` ASC [ RunTime:0.021247s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60313649 ORDER BY `unit` DESC [ RunTime:0.002524s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60313649 LIMIT 2 [ RunTime:0.012934s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60313649 ORDER BY `minOrder` ASC [ RunTime:0.003028s ]
select * from pdf where partno='5050864-5' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.014404s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5050864-5' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.020763s ]
SELECT `id` FROM `stock` WHERE `id` <> 60313649 AND `partno` = '5050864-5' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.015442s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17300498 [ RunTime:0.019464s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60313674 LIMIT 5 [ RunTime:0.003186s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60313674 ORDER BY `minOrder` ASC [ RunTime:0.013507s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60313674 ORDER BY `unit` DESC [ RunTime:0.034380s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60313674 LIMIT 2 [ RunTime:0.018794s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60313674 ORDER BY `minOrder` ASC [ RunTime:0.002488s ]
select * from pdf where partno='5050871-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.016353s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5050871-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.012062s ]
SELECT `id` FROM `stock` WHERE `id` <> 60313674 AND `partno` = '5050871-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.003171s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19594811 [ RunTime:0.024390s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59362092 LIMIT 5 [ RunTime:0.003341s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59362092 ORDER BY `minOrder` ASC [ RunTime:0.002876s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59362092 ORDER BY `unit` DESC [ RunTime:0.003831s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59362092 LIMIT 2 [ RunTime:0.023214s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59362092 ORDER BY `minOrder` ASC [ RunTime:0.003621s ]
select * from pdf where partno='5050703040' and brandshort='Molex' limit 1 [ RunTime:0.004170s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5050703040' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.018225s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59355616 LIMIT 5 [ RunTime:0.017248s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59355616 ORDER BY `minOrder` ASC [ RunTime:0.022619s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59355616 ORDER BY `unit` DESC [ RunTime:0.021280s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59355616 LIMIT 2 [ RunTime:0.018389s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59355616 ORDER BY `minOrder` ASC [ RunTime:0.000957s ]
select * from pdf where partno='5050700822' and brandshort='Molex' limit 1 [ RunTime:0.009290s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5050700822' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.011878s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60313616 LIMIT 5 [ RunTime:0.010038s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60313616 ORDER BY `minOrder` ASC [ RunTime:0.020721s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60313616 ORDER BY `unit` DESC [ RunTime:0.032770s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60313616 LIMIT 2 [ RunTime:0.008252s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60313616 ORDER BY `minOrder` ASC [ RunTime:0.006620s ]
select * from pdf where partno='5050864-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.017726s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5050864-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.001210s ]
SELECT `id` FROM `stock` WHERE `id` <> 60313616 AND `partno` = '5050864-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.001013s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19593979 [ RunTime:0.000945s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60313849 LIMIT 5 [ RunTime:0.016739s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60313849 ORDER BY `minOrder` ASC [ RunTime:0.032635s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60313849 ORDER BY `unit` DESC [ RunTime:0.039446s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60313849 LIMIT 2 [ RunTime:0.006967s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60313849 ORDER BY `minOrder` ASC [ RunTime:0.000335s ]
select * from pdf where partno='5050864-8' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.006826s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5050864-8' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.002704s ]
SELECT `id` FROM `stock` WHERE `id` <> 60313849 AND `partno` = '5050864-8' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.015644s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19597343 [ RunTime:0.008052s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60313418 LIMIT 5 [ RunTime:0.013126s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60313418 ORDER BY `minOrder` ASC [ RunTime:0.027703s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60313418 ORDER BY `unit` DESC [ RunTime:0.014812s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60313418 LIMIT 2 [ RunTime:0.003640s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60313418 ORDER BY `minOrder` ASC [ RunTime:0.000369s ]
select * from pdf where partno='5050462-2' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.001178s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5050462-2' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.000952s ]
SELECT `id` FROM `stock` WHERE `id` <> 60313418 AND `partno` = '5050462-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.012528s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19593970 [ RunTime:0.010400s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59355633 LIMIT 5 [ RunTime:0.017106s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59355633 ORDER BY `minOrder` ASC [ RunTime:0.000826s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59355633 ORDER BY `unit` DESC [ RunTime:0.000565s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59355633 LIMIT 2 [ RunTime:0.010165s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59355633 ORDER BY `minOrder` ASC [ RunTime:0.000432s ]
select * from pdf where partno='5050661022' and brandshort='Molex' limit 1 [ RunTime:0.009125s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5050661022' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.017272s ]
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 '5050%' OR `brand` LIKE '5050%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.026022s ]
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 '5050%' OR `brand` LIKE '5050%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007963s ]
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 '5050%' OR `brand` LIKE '5050%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.019195s ]
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 '5050%' OR `brand` LIKE '5050%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001189s ]
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 '5050%' OR `brand` LIKE '5050%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001006s ]
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 '5050%' OR `brand` LIKE '5050%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007020s ]
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 '5050%' OR `brand` LIKE '5050%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008239s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58019551 LIMIT 5 [ RunTime:0.005105s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58019551 ORDER BY `minOrder` ASC [ RunTime:0.003834s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58019551 ORDER BY `unit` DESC [ RunTime:0.004124s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58019551 LIMIT 2 [ RunTime:0.019081s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58019551 ORDER BY `minOrder` ASC [ RunTime:0.000506s ]
select * from pdf where partno='5050040812' and brandshort='MOLEX' limit 1 [ RunTime:0.000940s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5050040812' OR `brand` LIKE 'MOLEX%' ) ) LIMIT 1 [ RunTime:0.020355s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '5050%' OR `brand` LIKE '5050%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.009065s ]