SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001626s ]
INSERT INTO `visit_log` SET `ip` = '216.73.217.116' , `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=729&search=1' [ RunTime:0.002073s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002200s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000529s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.003651s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.116' ) [ RunTime:0.003986s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001417s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.002964s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002455s ]
SELECT * FROM `stock_search` WHERE `partno` = '729' LIMIT 1 [ RunTime:0.009487s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-07-23 12:41:11' WHERE `partno` = '729' [ RunTime:0.016488s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001504s ]
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 '729%' OR `brand` LIKE '729%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.029707s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002151s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11683891 LIMIT 5 [ RunTime:0.011235s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002763s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11683891 ORDER BY `minOrder` ASC [ RunTime:0.010590s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001339s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11683891 ORDER BY `unit` DESC [ RunTime:0.010372s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.010403s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11683891 LIMIT 2 [ RunTime:0.020266s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11683891 ORDER BY `minOrder` ASC [ RunTime:0.003642s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11684141 LIMIT 5 [ RunTime:0.019422s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11684141 ORDER BY `minOrder` ASC [ RunTime:0.005794s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11684141 ORDER BY `unit` DESC [ RunTime:0.003462s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11684141 LIMIT 2 [ RunTime:0.003184s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11684141 ORDER BY `minOrder` ASC [ RunTime:0.005630s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12883560 LIMIT 5 [ RunTime:0.008009s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12883560 ORDER BY `minOrder` ASC [ RunTime:0.001358s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12883560 ORDER BY `unit` DESC [ RunTime:0.000485s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12883560 LIMIT 2 [ RunTime:0.000369s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12883560 ORDER BY `minOrder` ASC [ RunTime:0.000380s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12883973 LIMIT 5 [ RunTime:0.004288s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12883973 ORDER BY `minOrder` ASC [ RunTime:0.006614s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12883973 ORDER BY `unit` DESC [ RunTime:0.000616s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12883973 LIMIT 2 [ RunTime:0.000666s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12883973 ORDER BY `minOrder` ASC [ RunTime:0.000635s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13346445 LIMIT 5 [ RunTime:0.003388s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13346445 ORDER BY `minOrder` ASC [ RunTime:0.000699s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13346445 ORDER BY `unit` DESC [ RunTime:0.000634s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13346445 LIMIT 2 [ RunTime:0.002425s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13346445 ORDER BY `minOrder` ASC [ RunTime:0.000603s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13346433 LIMIT 5 [ RunTime:0.002395s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13346433 ORDER BY `minOrder` ASC [ RunTime:0.019633s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13346433 ORDER BY `unit` DESC [ RunTime:0.002569s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13346433 LIMIT 2 [ RunTime:0.003542s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13346433 ORDER BY `minOrder` ASC [ RunTime:0.002479s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12065341 LIMIT 5 [ RunTime:0.002426s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12065341 ORDER BY `minOrder` ASC [ RunTime:0.002444s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12065341 ORDER BY `unit` DESC [ RunTime:0.002508s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12065341 LIMIT 2 [ RunTime:0.004125s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12065341 ORDER BY `minOrder` ASC [ RunTime:0.001354s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13346452 LIMIT 5 [ RunTime:0.010594s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13346452 ORDER BY `minOrder` ASC [ RunTime:0.003056s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13346452 ORDER BY `unit` DESC [ RunTime:0.003718s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13346452 LIMIT 2 [ RunTime:0.004375s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13346452 ORDER BY `minOrder` ASC [ RunTime:0.000807s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11683892 LIMIT 5 [ RunTime:0.004883s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11683892 ORDER BY `minOrder` ASC [ RunTime:0.013144s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11683892 ORDER BY `unit` DESC [ RunTime:0.001040s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11683892 LIMIT 2 [ RunTime:0.008815s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11683892 ORDER BY `minOrder` ASC [ RunTime:0.001346s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12065318 LIMIT 5 [ RunTime:0.007516s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12065318 ORDER BY `minOrder` ASC [ RunTime:0.001962s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12065318 ORDER BY `unit` DESC [ RunTime:0.009035s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12065318 LIMIT 2 [ RunTime:0.042573s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12065318 ORDER BY `minOrder` ASC [ RunTime:0.004998s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12883962 LIMIT 5 [ RunTime:0.007546s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12883962 ORDER BY `minOrder` ASC [ RunTime:0.019493s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12883962 ORDER BY `unit` DESC [ RunTime:0.022336s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12883962 LIMIT 2 [ RunTime:0.014382s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12883962 ORDER BY `minOrder` ASC [ RunTime:0.003304s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12065316 LIMIT 5 [ RunTime:0.001512s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12065316 ORDER BY `minOrder` ASC [ RunTime:0.005556s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12065316 ORDER BY `unit` DESC [ RunTime:0.002527s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12065316 LIMIT 2 [ RunTime:0.006401s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12065316 ORDER BY `minOrder` ASC [ RunTime:0.007540s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17372090 LIMIT 5 [ RunTime:0.007198s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17372090 ORDER BY `minOrder` ASC [ RunTime:0.010274s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17372090 ORDER BY `unit` DESC [ RunTime:0.003819s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17372090 LIMIT 2 [ RunTime:0.017200s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17372090 ORDER BY `minOrder` ASC [ RunTime:0.011655s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11684145 LIMIT 5 [ RunTime:0.011875s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11684145 ORDER BY `minOrder` ASC [ RunTime:0.013539s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11684145 ORDER BY `unit` DESC [ RunTime:0.017414s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11684145 LIMIT 2 [ RunTime:0.003612s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11684145 ORDER BY `minOrder` ASC [ RunTime:0.012923s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13323105 LIMIT 5 [ RunTime:0.004362s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13323105 ORDER BY `minOrder` ASC [ RunTime:0.000850s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13323105 ORDER BY `unit` DESC [ RunTime:0.006331s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13323105 LIMIT 2 [ RunTime:0.000879s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13323105 ORDER BY `minOrder` ASC [ RunTime:0.005324s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12875012 LIMIT 5 [ RunTime:0.010131s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12875012 ORDER BY `minOrder` ASC [ RunTime:0.003856s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12875012 ORDER BY `unit` DESC [ RunTime:0.004533s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12875012 LIMIT 2 [ RunTime:0.005898s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12875012 ORDER BY `minOrder` ASC [ RunTime:0.002135s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12065262 LIMIT 5 [ RunTime:0.007720s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12065262 ORDER BY `minOrder` ASC [ RunTime:0.006763s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12065262 ORDER BY `unit` DESC [ RunTime:0.000517s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12065262 LIMIT 2 [ RunTime:0.010600s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12065262 ORDER BY `minOrder` ASC [ RunTime:0.003357s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12065336 LIMIT 5 [ RunTime:0.002790s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12065336 ORDER BY `minOrder` ASC [ RunTime:0.000737s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12065336 ORDER BY `unit` DESC [ RunTime:0.004126s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12065336 LIMIT 2 [ RunTime:0.005892s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12065336 ORDER BY `minOrder` ASC [ RunTime:0.001152s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12884180 LIMIT 5 [ RunTime:0.001186s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12884180 ORDER BY `minOrder` ASC [ RunTime:0.000391s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12884180 ORDER BY `unit` DESC [ RunTime:0.000375s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12884180 LIMIT 2 [ RunTime:0.004935s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12884180 ORDER BY `minOrder` ASC [ RunTime:0.003785s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12065263 LIMIT 5 [ RunTime:0.004507s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12065263 ORDER BY `minOrder` ASC [ RunTime:0.009746s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12065263 ORDER BY `unit` DESC [ RunTime:0.000400s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12065263 LIMIT 2 [ RunTime:0.025784s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12065263 ORDER BY `minOrder` ASC [ RunTime:0.021662s ]
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 '729%' OR `brand` LIKE '729%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008369s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32284530 LIMIT 5 [ RunTime:0.002327s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32284530 ORDER BY `minOrder` ASC [ RunTime:0.003143s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32284530 ORDER BY `unit` DESC [ RunTime:0.001394s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32284530 LIMIT 2 [ RunTime:0.012785s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32284530 ORDER BY `minOrder` ASC [ RunTime:0.001226s ]
select * from pdf where partno='72913-2#' and brandshort='pomona electronics' limit 1 [ RunTime:0.004602s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001286s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '72913-2#' OR `brand` LIKE 'pomona electronics%' ) ) LIMIT 1 [ RunTime:0.001002s ]
SELECT `id` FROM `stock` WHERE `id` <> 32284530 AND `partno` = '72913-2#' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pomona electronics%' ) [ RunTime:0.000697s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12883762 [ RunTime:0.000320s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32284139 LIMIT 5 [ RunTime:0.002979s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32284139 ORDER BY `minOrder` ASC [ RunTime:0.003093s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32284139 ORDER BY `unit` DESC [ RunTime:0.018523s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32284139 LIMIT 2 [ RunTime:0.012341s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32284139 ORDER BY `minOrder` ASC [ RunTime:0.004219s ]
select * from pdf where partno='72922-0' and brandshort='pomona electronics' limit 1 [ RunTime:0.019901s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '72922-0' OR `brand` LIKE 'pomona electronics%' ) ) LIMIT 1 [ RunTime:0.024578s ]
SELECT `id` FROM `stock` WHERE `id` <> 32284139 AND `partno` = '72922-0' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pomona electronics%' ) [ RunTime:0.002156s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51866626 [ RunTime:0.011622s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32301828 LIMIT 5 [ RunTime:0.050381s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32301828 ORDER BY `minOrder` ASC [ RunTime:0.057606s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32301828 ORDER BY `unit` DESC [ RunTime:0.010151s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32301828 LIMIT 2 [ RunTime:0.052092s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32301828 ORDER BY `minOrder` ASC [ RunTime:0.037978s ]
select * from pdf where partno='72979' and brandshort='pomona electronics' limit 1 [ RunTime:0.030634s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '72979' OR `brand` LIKE 'pomona electronics%' ) ) LIMIT 1 [ RunTime:0.028529s ]
SELECT `id` FROM `stock` WHERE `id` <> 32301828 AND `partno` = '72979' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pomona electronics%' ) [ RunTime:0.004605s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20078644 [ RunTime:0.006497s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32273849 LIMIT 5 [ RunTime:0.010416s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32273849 ORDER BY `minOrder` ASC [ RunTime:0.006283s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32273849 ORDER BY `unit` DESC [ RunTime:0.003540s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32273849 LIMIT 2 [ RunTime:0.031705s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32273849 ORDER BY `minOrder` ASC [ RunTime:0.006028s ]
select * from pdf where partno='72979' and brandshort='pomona electronics' limit 1 [ RunTime:0.000727s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '72979' OR `brand` LIKE 'pomona electronics%' ) ) LIMIT 1 [ RunTime:0.006390s ]
SELECT `id` FROM `stock` WHERE `id` <> 32273849 AND `partno` = '72979' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pomona electronics%' ) [ RunTime:0.004304s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20078644 [ RunTime:0.009200s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32274512 LIMIT 5 [ RunTime:0.008999s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32274512 ORDER BY `minOrder` ASC [ RunTime:0.007229s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32274512 ORDER BY `unit` DESC [ RunTime:0.002279s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32274512 LIMIT 2 [ RunTime:0.010353s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32274512 ORDER BY `minOrder` ASC [ RunTime:0.005942s ]
select * from pdf where partno='72970' and brandshort='pomona electronics' limit 1 [ RunTime:0.024226s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '72970' OR `brand` LIKE 'pomona electronics%' ) ) LIMIT 1 [ RunTime:0.015713s ]
SELECT `id` FROM `stock` WHERE `id` <> 32274512 AND `partno` = '72970' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pomona electronics%' ) [ RunTime:0.043001s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11678434 [ RunTime:0.018941s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32285124 LIMIT 5 [ RunTime:0.001397s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32285124 ORDER BY `minOrder` ASC [ RunTime:0.021674s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32285124 ORDER BY `unit` DESC [ RunTime:0.035432s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32285124 LIMIT 2 [ RunTime:0.026893s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32285124 ORDER BY `minOrder` ASC [ RunTime:0.045479s ]
select * from pdf where partno='72922-2' and brandshort='pomona electronics' limit 1 [ RunTime:0.024065s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '72922-2' OR `brand` LIKE 'pomona electronics%' ) ) LIMIT 1 [ RunTime:0.013576s ]
SELECT `id` FROM `stock` WHERE `id` <> 32285124 AND `partno` = '72922-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pomona electronics%' ) [ RunTime:0.002938s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51866624 [ RunTime:0.002578s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32221347 LIMIT 5 [ RunTime:0.000909s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32221347 ORDER BY `minOrder` ASC [ RunTime:0.006846s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32221347 ORDER BY `unit` DESC [ RunTime:0.006201s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32221347 LIMIT 2 [ RunTime:0.016863s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32221347 ORDER BY `minOrder` ASC [ RunTime:0.008264s ]
select * from pdf where partno='72906-510-000 cns-0407 black' and brandshort='pactec' limit 1 [ RunTime:0.005387s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '72906-510-000 cns-0407 black' OR `brand` LIKE 'pactec%' ) ) LIMIT 1 [ RunTime:0.012510s ]
SELECT `id` FROM `stock` WHERE `id` <> 32221347 AND `partno` = '72906-510-000 cns-0407 black' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pactec%' ) [ RunTime:0.003716s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32285127 LIMIT 5 [ RunTime:0.002148s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32285127 ORDER BY `minOrder` ASC [ RunTime:0.000770s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32285127 ORDER BY `unit` DESC [ RunTime:0.003360s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32285127 LIMIT 2 [ RunTime:0.019009s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32285127 ORDER BY `minOrder` ASC [ RunTime:0.001383s ]
select * from pdf where partno='72930-4' and brandshort='pomona electronics' limit 1 [ RunTime:0.008512s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '72930-4' OR `brand` LIKE 'pomona electronics%' ) ) LIMIT 1 [ RunTime:0.006742s ]
SELECT `id` FROM `stock` WHERE `id` <> 32285127 AND `partno` = '72930-4' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pomona electronics%' ) [ RunTime:0.003780s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12884180 [ RunTime:0.026554s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32284206 LIMIT 5 [ RunTime:0.012721s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32284206 ORDER BY `minOrder` ASC [ RunTime:0.011629s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32284206 ORDER BY `unit` DESC [ RunTime:0.009726s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32284206 LIMIT 2 [ RunTime:0.013855s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32284206 ORDER BY `minOrder` ASC [ RunTime:0.004923s ]
select * from pdf where partno='72913-0#' and brandshort='pomona electronics' limit 1 [ RunTime:0.037707s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '72913-0#' OR `brand` LIKE 'pomona electronics%' ) ) LIMIT 1 [ RunTime:0.068763s ]
SELECT `id` FROM `stock` WHERE `id` <> 32284206 AND `partno` = '72913-0#' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pomona electronics%' ) [ RunTime:0.015653s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11684015 [ RunTime:0.004764s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32272660 LIMIT 5 [ RunTime:0.005442s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32272660 ORDER BY `minOrder` ASC [ RunTime:0.016934s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32272660 ORDER BY `unit` DESC [ RunTime:0.016145s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32272660 LIMIT 2 [ RunTime:0.061733s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32272660 ORDER BY `minOrder` ASC [ RunTime:0.004542s ]
select * from pdf where partno='7292-6sg-3es' and brandshort='conxall / switchcraft' limit 1 [ RunTime:0.012562s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '7292-6sg-3es' OR `brand` LIKE 'conxall / switchcraft%' ) ) LIMIT 1 [ RunTime:0.014772s ]
SELECT `id` FROM `stock` WHERE `id` <> 32272660 AND `partno` = '7292-6sg-3es' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%conxall / switchcraft%' ) [ RunTime:0.007688s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32285125 LIMIT 5 [ RunTime:0.013732s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32285125 ORDER BY `minOrder` ASC [ RunTime:0.007758s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32285125 ORDER BY `unit` DESC [ RunTime:0.010874s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32285125 LIMIT 2 [ RunTime:0.049777s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32285125 ORDER BY `minOrder` ASC [ RunTime:0.055980s ]
select * from pdf where partno='72924-0' and brandshort='pomona electronics' limit 1 [ RunTime:0.031053s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '72924-0' OR `brand` LIKE 'pomona electronics%' ) ) LIMIT 1 [ RunTime:0.014677s ]
SELECT `id` FROM `stock` WHERE `id` <> 32285125 AND `partno` = '72924-0' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pomona electronics%' ) [ RunTime:0.001270s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15222115 [ RunTime:0.015572s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32285126 LIMIT 5 [ RunTime:0.017113s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32285126 ORDER BY `minOrder` ASC [ RunTime:0.015732s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32285126 ORDER BY `unit` DESC [ RunTime:0.005639s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32285126 LIMIT 2 [ RunTime:0.008665s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32285126 ORDER BY `minOrder` ASC [ RunTime:0.004132s ]
select * from pdf where partno='72927-c-80' and brandshort='pomona electronics' limit 1 [ RunTime:0.015052s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '72927-c-80' OR `brand` LIKE 'pomona electronics%' ) ) LIMIT 1 [ RunTime:0.021695s ]
SELECT `id` FROM `stock` WHERE `id` <> 32285126 AND `partno` = '72927-c-80' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pomona electronics%' ) [ RunTime:0.011371s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18861505 [ RunTime:0.010906s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32284355 LIMIT 5 [ RunTime:0.006102s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32284355 ORDER BY `minOrder` ASC [ RunTime:0.044633s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32284355 ORDER BY `unit` DESC [ RunTime:0.016040s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32284355 LIMIT 2 [ RunTime:0.030972s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32284355 ORDER BY `minOrder` ASC [ RunTime:0.013339s ]
select * from pdf where partno='72936-39-2' and brandshort='pomona electronics' limit 1 [ RunTime:0.045963s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '72936-39-2' OR `brand` LIKE 'pomona electronics%' ) ) LIMIT 1 [ RunTime:0.022256s ]
SELECT `id` FROM `stock` WHERE `id` <> 32284355 AND `partno` = '72936-39-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pomona electronics%' ) [ RunTime:0.029660s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18838187 [ RunTime:0.013357s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32284279 LIMIT 5 [ RunTime:0.022900s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32284279 ORDER BY `minOrder` ASC [ RunTime:0.005645s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32284279 ORDER BY `unit` DESC [ RunTime:0.024574s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32284279 LIMIT 2 [ RunTime:0.018244s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32284279 ORDER BY `minOrder` ASC [ RunTime:0.017289s ]
select * from pdf where partno='72936-39-0' and brandshort='pomona electronics' limit 1 [ RunTime:0.025241s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '72936-39-0' OR `brand` LIKE 'pomona electronics%' ) ) LIMIT 1 [ RunTime:0.016206s ]
SELECT `id` FROM `stock` WHERE `id` <> 32284279 AND `partno` = '72936-39-0' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pomona electronics%' ) [ RunTime:0.003200s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18838186 [ RunTime:0.021029s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32284388 LIMIT 5 [ RunTime:0.011893s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32284388 ORDER BY `minOrder` ASC [ RunTime:0.001111s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32284388 ORDER BY `unit` DESC [ RunTime:0.007420s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32284388 LIMIT 2 [ RunTime:0.040782s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32284388 ORDER BY `minOrder` ASC [ RunTime:0.006526s ]
select * from pdf where partno='72935' and brandshort='pomona electronics' limit 1 [ RunTime:0.014013s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '72935' OR `brand` LIKE 'pomona electronics%' ) ) LIMIT 1 [ RunTime:0.024915s ]
SELECT `id` FROM `stock` WHERE `id` <> 32284388 AND `partno` = '72935' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pomona electronics%' ) [ RunTime:0.001859s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12191443 [ RunTime:0.007527s ]
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 '729%' OR `brand` LIKE '729%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.037425s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50743966 LIMIT 5 [ RunTime:0.006082s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50743966 ORDER BY `minOrder` ASC [ RunTime:0.010935s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50743966 ORDER BY `unit` DESC [ RunTime:0.010589s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50743966 LIMIT 2 [ RunTime:0.032413s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50743966 ORDER BY `minOrder` ASC [ RunTime:0.008748s ]
select * from pdf where partno='72959CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.003510s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '72959CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.003602s ]
SELECT `id` FROM `stock` WHERE `id` <> 50743966 AND `partno` = '72959CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.001006s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12065630 [ RunTime:0.031165s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 38147855 LIMIT 5 [ RunTime:0.009914s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38147855 ORDER BY `minOrder` ASC [ RunTime:0.011015s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 38147855 ORDER BY `unit` DESC [ RunTime:0.009755s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 38147855 LIMIT 2 [ RunTime:0.046093s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38147855 ORDER BY `minOrder` ASC [ RunTime:0.014402s ]
select * from pdf where partno='72959CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.012484s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '72959CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.014040s ]
SELECT `id` FROM `stock` WHERE `id` <> 38147855 AND `partno` = '72959CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.007339s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12065630 [ RunTime:0.005437s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50743960 LIMIT 5 [ RunTime:0.001616s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50743960 ORDER BY `minOrder` ASC [ RunTime:0.000789s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50743960 ORDER BY `unit` DESC [ RunTime:0.010535s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50743960 LIMIT 2 [ RunTime:0.008067s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50743960 ORDER BY `minOrder` ASC [ RunTime:0.002258s ]
select * from pdf where partno='72961CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.018270s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '72961CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.024550s ]
SELECT `id` FROM `stock` WHERE `id` <> 50743960 AND `partno` = '72961CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.010160s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12065276 [ RunTime:0.002808s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 38147849 LIMIT 5 [ RunTime:0.033758s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38147849 ORDER BY `minOrder` ASC [ RunTime:0.059207s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 38147849 ORDER BY `unit` DESC [ RunTime:0.007797s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 38147849 LIMIT 2 [ RunTime:0.081259s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38147849 ORDER BY `minOrder` ASC [ RunTime:0.011918s ]
select * from pdf where partno='72961CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.008895s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '72961CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.002528s ]
SELECT `id` FROM `stock` WHERE `id` <> 38147849 AND `partno` = '72961CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.007450s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12065276 [ RunTime:0.005450s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50743955 LIMIT 5 [ RunTime:0.008703s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50743955 ORDER BY `minOrder` ASC [ RunTime:0.027532s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50743955 ORDER BY `unit` DESC [ RunTime:0.030913s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50743955 LIMIT 2 [ RunTime:0.020571s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50743955 ORDER BY `minOrder` ASC [ RunTime:0.011591s ]
select * from pdf where partno='72901CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.028519s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '72901CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.011481s ]
SELECT `id` FROM `stock` WHERE `id` <> 50743955 AND `partno` = '72901CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.024804s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12065629 [ RunTime:0.008857s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 38147844 LIMIT 5 [ RunTime:0.009747s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38147844 ORDER BY `minOrder` ASC [ RunTime:0.001109s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 38147844 ORDER BY `unit` DESC [ RunTime:0.008782s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 38147844 LIMIT 2 [ RunTime:0.020727s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38147844 ORDER BY `minOrder` ASC [ RunTime:0.015245s ]
select * from pdf where partno='72901CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.009873s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '72901CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.013921s ]
SELECT `id` FROM `stock` WHERE `id` <> 38147844 AND `partno` = '72901CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.009486s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12065629 [ RunTime:0.009115s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56547916 LIMIT 5 [ RunTime:0.002225s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56547916 ORDER BY `minOrder` ASC [ RunTime:0.023668s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56547916 ORDER BY `unit` DESC [ RunTime:0.022356s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56547916 LIMIT 2 [ RunTime:0.031230s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56547916 ORDER BY `minOrder` ASC [ RunTime:0.012470s ]
select * from pdf where partno='729' and brandshort='Keystone Electronics' limit 1 [ RunTime:0.002999s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '729' OR `brand` LIKE 'Keystone Electronics%' ) ) LIMIT 1 [ RunTime:0.034416s ]
SELECT `id` FROM `stock` WHERE `id` <> 56547916 AND `partno` = '729' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%keystone electronics%' ) [ RunTime:0.003859s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13323105 [ RunTime:0.002707s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51866535 LIMIT 5 [ RunTime:0.001501s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51866535 ORDER BY `minOrder` ASC [ RunTime:0.009066s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51866535 ORDER BY `unit` DESC [ RunTime:0.000762s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51866535 LIMIT 2 [ RunTime:0.012668s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51866535 ORDER BY `minOrder` ASC [ RunTime:0.002027s ]
select * from pdf where partno='72918' and brandshort='Pomona Electronics' limit 1 [ RunTime:0.004196s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '72918' OR `brand` LIKE 'Pomona Electronics%' ) ) LIMIT 1 [ RunTime:0.005403s ]
SELECT `id` FROM `stock` WHERE `id` <> 51866535 AND `partno` = '72918' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pomona electronics%' ) [ RunTime:0.002693s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51866611 LIMIT 5 [ RunTime:0.000682s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51866611 ORDER BY `minOrder` ASC [ RunTime:0.007609s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51866611 ORDER BY `unit` DESC [ RunTime:0.013492s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51866611 LIMIT 2 [ RunTime:0.008703s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51866611 ORDER BY `minOrder` ASC [ RunTime:0.001941s ]
select * from pdf where partno='72930-0' and brandshort='Pomona Electronics' limit 1 [ RunTime:0.001190s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '72930-0' OR `brand` LIKE 'Pomona Electronics%' ) ) LIMIT 1 [ RunTime:0.008412s ]
SELECT `id` FROM `stock` WHERE `id` <> 51866611 AND `partno` = '72930-0' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pomona electronics%' ) [ RunTime:0.017169s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11683891 [ RunTime:0.010712s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50744255 LIMIT 5 [ RunTime:0.000748s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50744255 ORDER BY `minOrder` ASC [ RunTime:0.011057s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50744255 ORDER BY `unit` DESC [ RunTime:0.000701s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50744255 LIMIT 2 [ RunTime:0.001354s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50744255 ORDER BY `minOrder` ASC [ RunTime:0.013852s ]
select * from pdf where partno='72977SCS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.016879s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '72977SCS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.006045s ]
SELECT `id` FROM `stock` WHERE `id` <> 50744255 AND `partno` = '72977SCS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.004799s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12065366 [ RunTime:0.007719s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 38148242 LIMIT 5 [ RunTime:0.027950s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38148242 ORDER BY `minOrder` ASC [ RunTime:0.002898s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 38148242 ORDER BY `unit` DESC [ RunTime:0.003664s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 38148242 LIMIT 2 [ RunTime:0.023273s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38148242 ORDER BY `minOrder` ASC [ RunTime:0.001587s ]
select * from pdf where partno='72977SCS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.003045s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '72977SCS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.003779s ]
SELECT `id` FROM `stock` WHERE `id` <> 38148242 AND `partno` = '72977SCS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.008684s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12065366 [ RunTime:0.004847s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51261053 LIMIT 5 [ RunTime:0.005425s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51261053 ORDER BY `minOrder` ASC [ RunTime:0.037594s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51261053 ORDER BY `unit` DESC [ RunTime:0.039478s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51261053 LIMIT 2 [ RunTime:0.007796s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51261053 ORDER BY `minOrder` ASC [ RunTime:0.011095s ]
select * from pdf where partno='7299-RJ-C' and brandshort='ATGBICS' limit 1 [ RunTime:0.001056s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '7299-RJ-C' OR `brand` LIKE 'ATGBICS%' ) ) LIMIT 1 [ RunTime:0.017448s ]
SELECT `id` FROM `stock` WHERE `id` <> 51261053 AND `partno` = '7299-RJ-C' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%atgbics%' ) [ RunTime:0.005793s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51261084 LIMIT 5 [ RunTime:0.017715s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51261084 ORDER BY `minOrder` ASC [ RunTime:0.012551s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51261084 ORDER BY `unit` DESC [ RunTime:0.014982s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51261084 LIMIT 2 [ RunTime:0.012018s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51261084 ORDER BY `minOrder` ASC [ RunTime:0.007842s ]
select * from pdf where partno='7299-RJ-GI-C' and brandshort='ATGBICS' limit 1 [ RunTime:0.023780s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '7299-RJ-GI-C' OR `brand` LIKE 'ATGBICS%' ) ) LIMIT 1 [ RunTime:0.006083s ]
SELECT `id` FROM `stock` WHERE `id` <> 51261084 AND `partno` = '7299-RJ-GI-C' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%atgbics%' ) [ RunTime:0.000767s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50744090 LIMIT 5 [ RunTime:0.003884s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50744090 ORDER BY `minOrder` ASC [ RunTime:0.002433s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50744090 ORDER BY `unit` DESC [ RunTime:0.006776s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50744090 LIMIT 2 [ RunTime:0.014398s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50744090 ORDER BY `minOrder` ASC [ RunTime:0.020307s ]
select * from pdf where partno='72977CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.006004s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '72977CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.012483s ]
SELECT `id` FROM `stock` WHERE `id` <> 50744090 AND `partno` = '72977CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.013350s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 38147980 [ RunTime:0.007248s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 38147980 LIMIT 5 [ RunTime:0.000731s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38147980 ORDER BY `minOrder` ASC [ RunTime:0.003487s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 38147980 ORDER BY `unit` DESC [ RunTime:0.001116s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 38147980 LIMIT 2 [ RunTime:0.002590s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38147980 ORDER BY `minOrder` ASC [ RunTime:0.001668s ]
select * from pdf where partno='72977CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.003192s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '72977CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.000486s ]
SELECT `id` FROM `stock` WHERE `id` <> 38147980 AND `partno` = '72977CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.001333s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50744090 [ RunTime:0.018674s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51261263 LIMIT 5 [ RunTime:0.010334s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51261263 ORDER BY `minOrder` ASC [ RunTime:0.010989s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51261263 ORDER BY `unit` DESC [ RunTime:0.004849s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51261263 LIMIT 2 [ RunTime:0.006547s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51261263 ORDER BY `minOrder` ASC [ RunTime:0.006768s ]
select * from pdf where partno='7299-RJZ-C' and brandshort='ATGBICS' limit 1 [ RunTime:0.004636s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '7299-RJZ-C' OR `brand` LIKE 'ATGBICS%' ) ) LIMIT 1 [ RunTime:0.023959s ]
SELECT `id` FROM `stock` WHERE `id` <> 51261263 AND `partno` = '7299-RJZ-C' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%atgbics%' ) [ RunTime:0.006997s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50744128 LIMIT 5 [ RunTime:0.016056s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50744128 ORDER BY `minOrder` ASC [ RunTime:0.017570s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50744128 ORDER BY `unit` DESC [ RunTime:0.002646s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50744128 LIMIT 2 [ RunTime:0.009887s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50744128 ORDER BY `minOrder` ASC [ RunTime:0.001608s ]
select * from pdf where partno='72969CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.015685s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '72969CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.007299s ]
SELECT `id` FROM `stock` WHERE `id` <> 50744128 AND `partno` = '72969CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.026181s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12065327 [ RunTime:0.017609s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 38148018 LIMIT 5 [ RunTime:0.057533s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38148018 ORDER BY `minOrder` ASC [ RunTime:0.016909s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 38148018 ORDER BY `unit` DESC [ RunTime:0.012025s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 38148018 LIMIT 2 [ RunTime:0.005728s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38148018 ORDER BY `minOrder` ASC [ RunTime:0.002240s ]
select * from pdf where partno='72969CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.000705s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '72969CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.008823s ]
SELECT `id` FROM `stock` WHERE `id` <> 38148018 AND `partno` = '72969CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.000896s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12065327 [ RunTime:0.003018s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50744195 LIMIT 5 [ RunTime:0.005626s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50744195 ORDER BY `minOrder` ASC [ RunTime:0.000724s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50744195 ORDER BY `unit` DESC [ RunTime:0.000528s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50744195 LIMIT 2 [ RunTime:0.000535s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50744195 ORDER BY `minOrder` ASC [ RunTime:0.010761s ]
select * from pdf where partno='72989CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.009472s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '72989CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.010617s ]
SELECT `id` FROM `stock` WHERE `id` <> 50744195 AND `partno` = '72989CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.013347s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13346466 [ RunTime:0.005391s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 38148182 LIMIT 5 [ RunTime:0.017433s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38148182 ORDER BY `minOrder` ASC [ RunTime:0.004806s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 38148182 ORDER BY `unit` DESC [ RunTime:0.012140s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 38148182 LIMIT 2 [ RunTime:0.006993s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38148182 ORDER BY `minOrder` ASC [ RunTime:0.003650s ]
select * from pdf where partno='72989CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.002450s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '72989CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.008646s ]
SELECT `id` FROM `stock` WHERE `id` <> 38148182 AND `partno` = '72989CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.011947s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13346466 [ RunTime:0.004831s ]
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 '729%' OR `brand` LIKE '729%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004620s ]
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 '729%' OR `brand` LIKE '729%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001133s ]
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 '729%' OR `brand` LIKE '729%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002157s ]
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 '729%' OR `brand` LIKE '729%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011690s ]
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 '729%' OR `brand` LIKE '729%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004635s ]
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 '729%' OR `brand` LIKE '729%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011768s ]
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 '729%' OR `brand` LIKE '729%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006716s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '729%' OR `brand` LIKE '729%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.006695s ]