SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002605s ]
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=941&search=1' [ RunTime:0.016899s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002567s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000546s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.004047s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.133' ) [ RunTime:0.005003s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002275s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000282s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001923s ]
SELECT * FROM `stock_search` WHERE `partno` = '941' LIMIT 1 [ RunTime:0.001600s ]
UPDATE `stock_search` SET `count` = 36 , `updatetime` = '2026-08-19 15:43:44' WHERE `partno` = '941' [ RunTime:0.003069s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002073s ]
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 '941%' OR `brand` LIKE '941%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.057936s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002419s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20073047 LIMIT 5 [ RunTime:0.027262s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.004891s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20073047 ORDER BY `minOrder` ASC [ RunTime:0.006999s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.009139s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 20073047 ORDER BY `unit` DESC [ RunTime:0.014861s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.014827s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 20073047 LIMIT 2 [ RunTime:0.002464s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20073047 ORDER BY `minOrder` ASC [ RunTime:0.012119s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14375340 LIMIT 5 [ RunTime:0.007580s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14375340 ORDER BY `minOrder` ASC [ RunTime:0.015356s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14375340 ORDER BY `unit` DESC [ RunTime:0.027309s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14375340 LIMIT 2 [ RunTime:0.042594s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14375340 ORDER BY `minOrder` ASC [ RunTime:0.017134s ]
select * from pdf where partno='9418 0601000' and brandshort='Belden Inc.' limit 1 [ RunTime:0.008522s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14376975 LIMIT 5 [ RunTime:0.051964s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14376975 ORDER BY `minOrder` ASC [ RunTime:0.026335s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14376975 ORDER BY `unit` DESC [ RunTime:0.000420s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14376975 LIMIT 2 [ RunTime:0.012793s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14376975 ORDER BY `minOrder` ASC [ RunTime:0.004888s ]
select * from pdf where partno='9418 060U500' and brandshort='Belden Inc.' limit 1 [ RunTime:0.032705s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12552703 LIMIT 5 [ RunTime:0.019036s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12552703 ORDER BY `minOrder` ASC [ RunTime:0.017266s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12552703 ORDER BY `unit` DESC [ RunTime:0.018729s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12552703 LIMIT 2 [ RunTime:0.054721s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12552703 ORDER BY `minOrder` ASC [ RunTime:0.045084s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17757918 LIMIT 5 [ RunTime:0.007431s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17757918 ORDER BY `minOrder` ASC [ RunTime:0.032249s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17757918 ORDER BY `unit` DESC [ RunTime:0.027411s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17757918 LIMIT 2 [ RunTime:0.010363s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17757918 ORDER BY `minOrder` ASC [ RunTime:0.010324s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14389599 LIMIT 5 [ RunTime:0.004040s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14389599 ORDER BY `minOrder` ASC [ RunTime:0.013700s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14389599 ORDER BY `unit` DESC [ RunTime:0.012776s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14389599 LIMIT 2 [ RunTime:0.010355s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14389599 ORDER BY `minOrder` ASC [ RunTime:0.012586s ]
select * from pdf where partno='9418 060500' and brandshort='Belden Inc.' limit 1 [ RunTime:0.006388s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13512777 LIMIT 5 [ RunTime:0.031770s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13512777 ORDER BY `minOrder` ASC [ RunTime:0.045346s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13512777 ORDER BY `unit` DESC [ RunTime:0.015204s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13512777 LIMIT 2 [ RunTime:0.018482s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13512777 ORDER BY `minOrder` ASC [ RunTime:0.006439s ]
select * from pdf where partno='9412 060500' and brandshort='Belden Inc.' limit 1 [ RunTime:0.003723s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11933050 LIMIT 5 [ RunTime:0.010568s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11933050 ORDER BY `minOrder` ASC [ RunTime:0.060636s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11933050 ORDER BY `unit` DESC [ RunTime:0.048624s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11933050 LIMIT 2 [ RunTime:0.020238s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11933050 ORDER BY `minOrder` ASC [ RunTime:0.029177s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15674817 LIMIT 5 [ RunTime:0.029006s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15674817 ORDER BY `minOrder` ASC [ RunTime:0.020713s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15674817 ORDER BY `unit` DESC [ RunTime:0.003528s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15674817 LIMIT 2 [ RunTime:0.027499s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15674817 ORDER BY `minOrder` ASC [ RunTime:0.018420s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15674803 LIMIT 5 [ RunTime:0.036444s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15674803 ORDER BY `minOrder` ASC [ RunTime:0.045060s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15674803 ORDER BY `unit` DESC [ RunTime:0.052808s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15674803 LIMIT 2 [ RunTime:0.071974s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15674803 ORDER BY `minOrder` ASC [ RunTime:0.040195s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14374985 LIMIT 5 [ RunTime:0.044814s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14374985 ORDER BY `minOrder` ASC [ RunTime:0.015056s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14374985 ORDER BY `unit` DESC [ RunTime:0.030437s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14374985 LIMIT 2 [ RunTime:0.050072s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14374985 ORDER BY `minOrder` ASC [ RunTime:0.004826s ]
select * from pdf where partno='9418 060U1000' and brandshort='Belden Inc.' limit 1 [ RunTime:0.017568s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13494566 LIMIT 5 [ RunTime:0.076093s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13494566 ORDER BY `minOrder` ASC [ RunTime:0.015897s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13494566 ORDER BY `unit` DESC [ RunTime:0.017548s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13494566 LIMIT 2 [ RunTime:0.019932s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13494566 ORDER BY `minOrder` ASC [ RunTime:0.043691s ]
select * from pdf where partno='9411 060U500' and brandshort='Belden Inc.' limit 1 [ RunTime:0.034946s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15674816 LIMIT 5 [ RunTime:0.026222s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15674816 ORDER BY `minOrder` ASC [ RunTime:0.004107s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15674816 ORDER BY `unit` DESC [ RunTime:0.030489s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15674816 LIMIT 2 [ RunTime:0.059917s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15674816 ORDER BY `minOrder` ASC [ RunTime:0.019345s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12510618 LIMIT 5 [ RunTime:0.016119s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12510618 ORDER BY `minOrder` ASC [ RunTime:0.087062s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12510618 ORDER BY `unit` DESC [ RunTime:0.037713s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12510618 LIMIT 2 [ RunTime:0.074291s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12510618 ORDER BY `minOrder` ASC [ RunTime:0.014131s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16004354 LIMIT 5 [ RunTime:0.080404s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16004354 ORDER BY `minOrder` ASC [ RunTime:0.107057s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16004354 ORDER BY `unit` DESC [ RunTime:0.033416s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16004354 LIMIT 2 [ RunTime:0.027306s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16004354 ORDER BY `minOrder` ASC [ RunTime:0.023104s ]
select * from pdf where partno='9418-2-4039' and brandshort='ebm-papst Inc.' limit 1 [ RunTime:0.012635s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11256740 LIMIT 5 [ RunTime:0.040869s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11256740 ORDER BY `minOrder` ASC [ RunTime:0.036500s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11256740 ORDER BY `unit` DESC [ RunTime:0.043720s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11256740 LIMIT 2 [ RunTime:0.063259s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11256740 ORDER BY `minOrder` ASC [ RunTime:0.030261s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12272131 LIMIT 5 [ RunTime:0.019459s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12272131 ORDER BY `minOrder` ASC [ RunTime:0.016645s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12272131 ORDER BY `unit` DESC [ RunTime:0.011217s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12272131 LIMIT 2 [ RunTime:0.031736s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12272131 ORDER BY `minOrder` ASC [ RunTime:0.013258s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16706172 LIMIT 5 [ RunTime:0.032877s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16706172 ORDER BY `minOrder` ASC [ RunTime:0.013006s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16706172 ORDER BY `unit` DESC [ RunTime:0.002866s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16706172 LIMIT 2 [ RunTime:0.008479s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16706172 ORDER BY `minOrder` ASC [ RunTime:0.010538s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14386187 LIMIT 5 [ RunTime:0.020801s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14386187 ORDER BY `minOrder` ASC [ RunTime:0.017129s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14386187 ORDER BY `unit` DESC [ RunTime:0.011574s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14386187 LIMIT 2 [ RunTime:0.016339s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14386187 ORDER BY `minOrder` ASC [ RunTime:0.009219s ]
select * from pdf where partno='9418 060100' and brandshort='Belden Inc.' limit 1 [ RunTime:0.003471s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12510564 LIMIT 5 [ RunTime:0.030264s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12510564 ORDER BY `minOrder` ASC [ RunTime:0.015079s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12510564 ORDER BY `unit` DESC [ RunTime:0.015348s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12510564 LIMIT 2 [ RunTime:0.018526s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12510564 ORDER BY `minOrder` ASC [ RunTime:0.022631s ]
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 '941%' OR `brand` LIKE '941%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.051570s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32257325 LIMIT 5 [ RunTime:0.043027s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32257325 ORDER BY `minOrder` ASC [ RunTime:0.022801s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32257325 ORDER BY `unit` DESC [ RunTime:0.069148s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32257325 LIMIT 2 [ RunTime:0.026804s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32257325 ORDER BY `minOrder` ASC [ RunTime:0.008570s ]
select * from pdf where partno='941' and brandshort='keystone electronics' limit 1 [ RunTime:0.009495s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.003411s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '941' OR `brand` LIKE 'keystone electronics%' ) ) LIMIT 1 [ RunTime:0.062621s ]
SELECT `id` FROM `stock` WHERE `id` <> 32257325 AND `partno` = '941' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%keystone electronics%' ) [ RunTime:0.101574s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11933050 [ RunTime:0.054128s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51098472 LIMIT 5 [ RunTime:0.045905s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51098472 ORDER BY `minOrder` ASC [ RunTime:0.023966s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51098472 ORDER BY `unit` DESC [ RunTime:0.048494s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51098472 LIMIT 2 [ RunTime:0.028084s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51098472 ORDER BY `minOrder` ASC [ RunTime:0.056805s ]
select * from pdf where partno='9415pc' and brandshort='3m electronic specialty' limit 1 [ RunTime:0.032144s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9415pc' OR `brand` LIKE '3m electronic specialty%' ) ) LIMIT 1 [ RunTime:0.029857s ]
SELECT `id` FROM `stock` WHERE `id` <> 51098472 AND `partno` = '9415pc' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%3m electronic specialty%' ) [ RunTime:0.015989s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51137490 LIMIT 5 [ RunTime:0.104282s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51137490 ORDER BY `minOrder` ASC [ RunTime:0.016711s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51137490 ORDER BY `unit` DESC [ RunTime:0.026598s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51137490 LIMIT 2 [ RunTime:0.036302s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51137490 ORDER BY `minOrder` ASC [ RunTime:0.007826s ]
select * from pdf where partno='9418 060100' and brandshort='belden wire & cable' limit 1 [ RunTime:0.010925s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9418 060100' OR `brand` LIKE 'belden wire & cable%' ) ) LIMIT 1 [ RunTime:0.016432s ]
SELECT `id` FROM `stock` WHERE `id` <> 51137490 AND `partno` = '9418 060100' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%belden wire & cable%' ) [ RunTime:0.036815s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32189330 LIMIT 5 [ RunTime:0.018607s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32189330 ORDER BY `minOrder` ASC [ RunTime:0.023488s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32189330 ORDER BY `unit` DESC [ RunTime:0.022504s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32189330 LIMIT 2 [ RunTime:0.026764s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32189330 ORDER BY `minOrder` ASC [ RunTime:0.005094s ]
select * from pdf where partno='9416 (3/4 x 72yd)' and brandshort='3m electronic specialty' limit 1 [ RunTime:0.010696s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9416 (3/4 x 72yd)' OR `brand` LIKE '3m electronic specialty%' ) ) LIMIT 1 [ RunTime:0.014610s ]
SELECT `id` FROM `stock` WHERE `id` <> 32189330 AND `partno` = '9416 (3/4 x 72yd)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%3m electronic specialty%' ) [ RunTime:0.006220s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51137492 LIMIT 5 [ RunTime:0.009449s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51137492 ORDER BY `minOrder` ASC [ RunTime:0.038756s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51137492 ORDER BY `unit` DESC [ RunTime:0.006799s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51137492 LIMIT 2 [ RunTime:0.008460s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51137492 ORDER BY `minOrder` ASC [ RunTime:0.010731s ]
select * from pdf where partno='9418 060500' and brandshort='belden wire & cable' limit 1 [ RunTime:0.012831s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9418 060500' OR `brand` LIKE 'belden wire & cable%' ) ) LIMIT 1 [ RunTime:0.011454s ]
SELECT `id` FROM `stock` WHERE `id` <> 51137492 AND `partno` = '9418 060500' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%belden wire & cable%' ) [ RunTime:0.004790s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51137491 LIMIT 5 [ RunTime:0.007782s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51137491 ORDER BY `minOrder` ASC [ RunTime:0.015944s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51137491 ORDER BY `unit` DESC [ RunTime:0.022374s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51137491 LIMIT 2 [ RunTime:0.010552s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51137491 ORDER BY `minOrder` ASC [ RunTime:0.011752s ]
select * from pdf where partno='9418 0601000' and brandshort='belden wire & cable' limit 1 [ RunTime:0.014339s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9418 0601000' OR `brand` LIKE 'belden wire & cable%' ) ) LIMIT 1 [ RunTime:0.003387s ]
SELECT `id` FROM `stock` WHERE `id` <> 51137491 AND `partno` = '9418 0601000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%belden wire & cable%' ) [ RunTime:0.018220s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51136944 LIMIT 5 [ RunTime:0.006492s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51136944 ORDER BY `minOrder` ASC [ RunTime:0.015565s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51136944 ORDER BY `unit` DESC [ RunTime:0.051099s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51136944 LIMIT 2 [ RunTime:0.018918s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51136944 ORDER BY `minOrder` ASC [ RunTime:0.014923s ]
select * from pdf where partno='9411 060u500' and brandshort='belden wire & cable' limit 1 [ RunTime:0.027687s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9411 060u500' OR `brand` LIKE 'belden wire & cable%' ) ) LIMIT 1 [ RunTime:0.018857s ]
SELECT `id` FROM `stock` WHERE `id` <> 51136944 AND `partno` = '9411 060u500' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%belden wire & cable%' ) [ RunTime:0.008484s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51137489 LIMIT 5 [ RunTime:0.090935s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51137489 ORDER BY `minOrder` ASC [ RunTime:0.040763s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51137489 ORDER BY `unit` DESC [ RunTime:0.042469s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51137489 LIMIT 2 [ RunTime:0.094520s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51137489 ORDER BY `minOrder` ASC [ RunTime:0.024555s ]
select * from pdf where partno='9410 060u500' and brandshort='belden wire & cable' limit 1 [ RunTime:0.012223s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9410 060u500' OR `brand` LIKE 'belden wire & cable%' ) ) LIMIT 1 [ RunTime:0.008426s ]
SELECT `id` FROM `stock` WHERE `id` <> 51137489 AND `partno` = '9410 060u500' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%belden wire & cable%' ) [ RunTime:0.038474s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51128197 LIMIT 5 [ RunTime:0.004671s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51128197 ORDER BY `minOrder` ASC [ RunTime:0.037948s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51128197 ORDER BY `unit` DESC [ RunTime:0.029290s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51128197 LIMIT 2 [ RunTime:0.013182s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51128197 ORDER BY `minOrder` ASC [ RunTime:0.005119s ]
select * from pdf where partno='9418/s25' and brandshort='bei sensors' limit 1 [ RunTime:0.013607s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9418/s25' OR `brand` LIKE 'bei sensors%' ) ) LIMIT 1 [ RunTime:0.015864s ]
SELECT `id` FROM `stock` WHERE `id` <> 51128197 AND `partno` = '9418/s25' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bei sensors%' ) [ RunTime:0.023983s ]
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 '941%' OR `brand` LIKE '941%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.040192s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60416936 LIMIT 5 [ RunTime:0.022449s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60416936 ORDER BY `minOrder` ASC [ RunTime:0.024990s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60416936 ORDER BY `unit` DESC [ RunTime:0.025996s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60416936 LIMIT 2 [ RunTime:0.025706s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60416936 ORDER BY `minOrder` ASC [ RunTime:0.003114s ]
select * from pdf where partno='94152-088LF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.030895s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '94152-088LF' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.016200s ]
SELECT `id` FROM `stock` WHERE `id` <> 60416936 AND `partno` = '94152-088LF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.014317s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20073047 [ RunTime:0.012158s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62997494 LIMIT 5 [ RunTime:0.007627s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62997494 ORDER BY `minOrder` ASC [ RunTime:0.014653s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62997494 ORDER BY `unit` DESC [ RunTime:0.023365s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62997494 LIMIT 2 [ RunTime:0.002557s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62997494 ORDER BY `minOrder` ASC [ RunTime:0.003335s ]
select * from pdf where partno='9418 0601000' and brandshort='Belden Inc.' limit 1 [ RunTime:0.001966s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9418 0601000' OR `brand` LIKE 'Belden Inc.%' ) ) LIMIT 1 [ RunTime:0.017548s ]
SELECT `id` FROM `stock` WHERE `id` <> 62997494 AND `partno` = '9418 0601000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%belden inc.%' ) [ RunTime:0.007298s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14375340 [ RunTime:0.013189s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63001585 LIMIT 5 [ RunTime:0.015360s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63001585 ORDER BY `minOrder` ASC [ RunTime:0.011781s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63001585 ORDER BY `unit` DESC [ RunTime:0.007295s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63001585 LIMIT 2 [ RunTime:0.017133s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63001585 ORDER BY `minOrder` ASC [ RunTime:0.001848s ]
select * from pdf where partno='9418 06010000' and brandshort='Belden Inc.' limit 1 [ RunTime:0.007301s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9418 06010000' OR `brand` LIKE 'Belden Inc.%' ) ) LIMIT 1 [ RunTime:0.013726s ]
SELECT `id` FROM `stock` WHERE `id` <> 63001585 AND `partno` = '9418 06010000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%belden inc.%' ) [ RunTime:0.004043s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14373304 [ RunTime:0.017770s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59393690 LIMIT 5 [ RunTime:0.005691s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59393690 ORDER BY `minOrder` ASC [ RunTime:0.036769s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59393690 ORDER BY `unit` DESC [ RunTime:0.005136s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59393690 LIMIT 2 [ RunTime:0.027125s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59393690 ORDER BY `minOrder` ASC [ RunTime:0.030908s ]
select * from pdf where partno='941' and brandshort='Keystone Electronics' limit 1 [ RunTime:0.006139s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '941' OR `brand` LIKE 'Keystone Electronics%' ) ) LIMIT 1 [ RunTime:0.001684s ]
SELECT `id` FROM `stock` WHERE `id` <> 59393690 AND `partno` = '941' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%keystone electronics%' ) [ RunTime:0.021169s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11933050 [ RunTime:0.014732s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60562773 LIMIT 5 [ RunTime:0.034990s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60562773 ORDER BY `minOrder` ASC [ RunTime:0.090592s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60562773 ORDER BY `unit` DESC [ RunTime:0.034986s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60562773 LIMIT 2 [ RunTime:0.041313s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60562773 ORDER BY `minOrder` ASC [ RunTime:0.001425s ]
select * from pdf where partno='941-T-DS/03' and brandshort='WECO Electrical Connectors Inc.' limit 1 [ RunTime:0.027418s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '941-T-DS/03' OR `brand` LIKE 'WECO Electrical Connectors Inc.%' ) ) LIMIT 1 [ RunTime:0.019184s ]
SELECT `id` FROM `stock` WHERE `id` <> 60562773 AND `partno` = '941-T-DS/03' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weco electrical connectors inc.%' ) [ RunTime:0.037060s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12552703 [ RunTime:0.024065s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63001567 LIMIT 5 [ RunTime:0.013430s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63001567 ORDER BY `minOrder` ASC [ RunTime:0.056253s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63001567 ORDER BY `unit` DESC [ RunTime:0.021026s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63001567 LIMIT 2 [ RunTime:0.021015s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63001567 ORDER BY `minOrder` ASC [ RunTime:0.014777s ]
select * from pdf where partno='9410 0602500' and brandshort='Belden Inc.' limit 1 [ RunTime:0.032382s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9410 0602500' OR `brand` LIKE 'Belden Inc.%' ) ) LIMIT 1 [ RunTime:0.025789s ]
SELECT `id` FROM `stock` WHERE `id` <> 63001567 AND `partno` = '9410 0602500' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%belden inc.%' ) [ RunTime:0.038634s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14376003 [ RunTime:0.022518s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58041053 LIMIT 5 [ RunTime:0.033692s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58041053 ORDER BY `minOrder` ASC [ RunTime:0.045920s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58041053 ORDER BY `unit` DESC [ RunTime:0.045565s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58041053 LIMIT 2 [ RunTime:0.028505s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58041053 ORDER BY `minOrder` ASC [ RunTime:0.020082s ]
select * from pdf where partno='9410-5SL-1R7' and brandshort='Knowles Johanson Manufacturing' limit 1 [ RunTime:0.014830s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9410-5SL-1R7' OR `brand` LIKE 'Knowles Johanson Manufacturing%' ) ) LIMIT 1 [ RunTime:0.038798s ]
SELECT `id` FROM `stock` WHERE `id` <> 58041053 AND `partno` = '9410-5SL-1R7' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%knowles johanson manufacturing%' ) [ RunTime:0.022087s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17757918 [ RunTime:0.049435s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63001825 LIMIT 5 [ RunTime:0.015271s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63001825 ORDER BY `minOrder` ASC [ RunTime:0.019718s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63001825 ORDER BY `unit` DESC [ RunTime:0.037346s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63001825 LIMIT 2 [ RunTime:0.029456s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63001825 ORDER BY `minOrder` ASC [ RunTime:0.009070s ]
select * from pdf where partno='9412 0601000' and brandshort='Belden Inc.' limit 1 [ RunTime:0.013014s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9412 0601000' OR `brand` LIKE 'Belden Inc.%' ) ) LIMIT 1 [ RunTime:0.022665s ]
SELECT `id` FROM `stock` WHERE `id` <> 63001825 AND `partno` = '9412 0601000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%belden inc.%' ) [ RunTime:0.016386s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13503491 [ RunTime:0.003709s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63001764 LIMIT 5 [ RunTime:0.022127s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63001764 ORDER BY `minOrder` ASC [ RunTime:0.008577s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63001764 ORDER BY `unit` DESC [ RunTime:0.008806s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63001764 LIMIT 2 [ RunTime:0.014425s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63001764 ORDER BY `minOrder` ASC [ RunTime:0.002718s ]
select * from pdf where partno='9411 0601000' and brandshort='Belden Inc.' limit 1 [ RunTime:0.006961s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9411 0601000' OR `brand` LIKE 'Belden Inc.%' ) ) LIMIT 1 [ RunTime:0.020739s ]
SELECT `id` FROM `stock` WHERE `id` <> 63001764 AND `partno` = '9411 0601000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%belden inc.%' ) [ RunTime:0.007934s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14377353 [ RunTime:0.004086s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63001597 LIMIT 5 [ RunTime:0.020427s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63001597 ORDER BY `minOrder` ASC [ RunTime:0.007532s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63001597 ORDER BY `unit` DESC [ RunTime:0.037774s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63001597 LIMIT 2 [ RunTime:0.013480s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63001597 ORDER BY `minOrder` ASC [ RunTime:0.007892s ]
select * from pdf where partno='9410 0601000' and brandshort='Belden Inc.' limit 1 [ RunTime:0.012340s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9410 0601000' OR `brand` LIKE 'Belden Inc.%' ) ) LIMIT 1 [ RunTime:0.017514s ]
SELECT `id` FROM `stock` WHERE `id` <> 63001597 AND `partno` = '9410 0601000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%belden inc.%' ) [ RunTime:0.005511s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14376193 [ RunTime:0.009500s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62999243 LIMIT 5 [ RunTime:0.002432s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62999243 ORDER BY `minOrder` ASC [ RunTime:0.003780s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62999243 ORDER BY `unit` DESC [ RunTime:0.003130s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62999243 LIMIT 2 [ RunTime:0.011125s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62999243 ORDER BY `minOrder` ASC [ RunTime:0.006081s ]
select * from pdf where partno='9418 060U1000' and brandshort='Belden Inc.' limit 1 [ RunTime:0.003815s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9418 060U1000' OR `brand` LIKE 'Belden Inc.%' ) ) LIMIT 1 [ RunTime:0.021725s ]
SELECT `id` FROM `stock` WHERE `id` <> 62999243 AND `partno` = '9418 060U1000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%belden inc.%' ) [ RunTime:0.006630s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14374985 [ RunTime:0.010996s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62997317 LIMIT 5 [ RunTime:0.032030s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62997317 ORDER BY `minOrder` ASC [ RunTime:0.011767s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62997317 ORDER BY `unit` DESC [ RunTime:0.009508s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62997317 LIMIT 2 [ RunTime:0.012288s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62997317 ORDER BY `minOrder` ASC [ RunTime:0.029834s ]
select * from pdf where partno='9418 060500' and brandshort='Belden Inc.' limit 1 [ RunTime:0.011336s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9418 060500' OR `brand` LIKE 'Belden Inc.%' ) ) LIMIT 1 [ RunTime:0.027470s ]
SELECT `id` FROM `stock` WHERE `id` <> 62997317 AND `partno` = '9418 060500' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%belden inc.%' ) [ RunTime:0.013264s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14389599 [ RunTime:0.000449s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58041121 LIMIT 5 [ RunTime:0.001389s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58041121 ORDER BY `minOrder` ASC [ RunTime:0.003918s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58041121 ORDER BY `unit` DESC [ RunTime:0.009638s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58041121 LIMIT 2 [ RunTime:0.011116s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58041121 ORDER BY `minOrder` ASC [ RunTime:0.009104s ]
select * from pdf where partno='9410-25' and brandshort='Knowles Johanson Manufacturing' limit 1 [ RunTime:0.008417s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9410-25' OR `brand` LIKE 'Knowles Johanson Manufacturing%' ) ) LIMIT 1 [ RunTime:0.018735s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62997485 LIMIT 5 [ RunTime:0.002939s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62997485 ORDER BY `minOrder` ASC [ RunTime:0.005794s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62997485 ORDER BY `unit` DESC [ RunTime:0.010629s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62997485 LIMIT 2 [ RunTime:0.006335s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62997485 ORDER BY `minOrder` ASC [ RunTime:0.007463s ]
select * from pdf where partno='9411 060U500' and brandshort='Belden Inc.' limit 1 [ RunTime:0.000835s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9411 060U500' OR `brand` LIKE 'Belden Inc.%' ) ) LIMIT 1 [ RunTime:0.010997s ]
SELECT `id` FROM `stock` WHERE `id` <> 62997485 AND `partno` = '9411 060U500' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%belden inc.%' ) [ RunTime:0.011299s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13494566 [ RunTime:0.012018s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60993917 LIMIT 5 [ RunTime:0.008933s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60993917 ORDER BY `minOrder` ASC [ RunTime:0.009159s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60993917 ORDER BY `unit` DESC [ RunTime:0.015277s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60993917 LIMIT 2 [ RunTime:0.008912s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60993917 ORDER BY `minOrder` ASC [ RunTime:0.011137s ]
select * from pdf where partno='941-BK' and brandshort='Anderson Power Products, Inc.' limit 1 [ RunTime:0.234923s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '941-BK' OR `brand` LIKE 'Anderson Power Products, Inc.%' ) ) LIMIT 1 [ RunTime:0.022492s ]
SELECT `id` FROM `stock` WHERE `id` <> 60993917 AND `partno` = '941-BK' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%anderson power products, inc.%' ) [ RunTime:0.019242s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12510618 [ RunTime:0.014614s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64287417 LIMIT 5 [ RunTime:0.000817s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64287417 ORDER BY `minOrder` ASC [ RunTime:0.026029s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64287417 ORDER BY `unit` DESC [ RunTime:0.084132s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64287417 LIMIT 2 [ RunTime:0.041447s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64287417 ORDER BY `minOrder` ASC [ RunTime:0.024067s ]
select * from pdf where partno='9410-3ML' and brandshort='MG Chemicals' limit 1 [ RunTime:0.026045s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9410-3ML' OR `brand` LIKE 'MG Chemicals%' ) ) LIMIT 1 [ RunTime:0.030164s ]
SELECT `id` FROM `stock` WHERE `id` <> 64287417 AND `partno` = '9410-3ML' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mg chemicals%' ) [ RunTime:0.056734s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12261947 [ RunTime:0.049798s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58041118 LIMIT 5 [ RunTime:0.029012s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58041118 ORDER BY `minOrder` ASC [ RunTime:0.015764s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58041118 ORDER BY `unit` DESC [ RunTime:0.020288s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58041118 LIMIT 2 [ RunTime:0.020787s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58041118 ORDER BY `minOrder` ASC [ RunTime:0.007316s ]
select * from pdf where partno='9410-0' and brandshort='Knowles Johanson Manufacturing' limit 1 [ RunTime:0.028241s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9410-0' OR `brand` LIKE 'Knowles Johanson Manufacturing%' ) ) LIMIT 1 [ RunTime:0.015657s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58041225 LIMIT 5 [ RunTime:0.006858s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58041225 ORDER BY `minOrder` ASC [ RunTime:0.020831s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58041225 ORDER BY `unit` DESC [ RunTime:0.019183s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58041225 LIMIT 2 [ RunTime:0.015582s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58041225 ORDER BY `minOrder` ASC [ RunTime:0.010971s ]
select * from pdf where partno='9410-2' and brandshort='Knowles Johanson Manufacturing' limit 1 [ RunTime:0.002177s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9410-2' OR `brand` LIKE 'Knowles Johanson Manufacturing%' ) ) LIMIT 1 [ RunTime:0.006012s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60994178 LIMIT 5 [ RunTime:0.004908s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60994178 ORDER BY `minOrder` ASC [ RunTime:0.003190s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60994178 ORDER BY `unit` DESC [ RunTime:0.001722s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60994178 LIMIT 2 [ RunTime:0.016788s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60994178 ORDER BY `minOrder` ASC [ RunTime:0.001245s ]
select * from pdf where partno='941' and brandshort='Anderson Power Products, Inc.' limit 1 [ RunTime:0.011889s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '941' OR `brand` LIKE 'Anderson Power Products, Inc.%' ) ) LIMIT 1 [ RunTime:0.008953s ]
SELECT `id` FROM `stock` WHERE `id` <> 60994178 AND `partno` = '941' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%anderson power products, inc.%' ) [ RunTime:0.013463s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12510564 [ RunTime:0.003314s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64287434 LIMIT 5 [ RunTime:0.002268s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64287434 ORDER BY `minOrder` ASC [ RunTime:0.005137s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64287434 ORDER BY `unit` DESC [ RunTime:0.009145s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64287434 LIMIT 2 [ RunTime:0.004430s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64287434 ORDER BY `minOrder` ASC [ RunTime:0.002523s ]
select * from pdf where partno='9410-30ML' and brandshort='MG Chemicals' limit 1 [ RunTime:0.003842s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9410-30ML' OR `brand` LIKE 'MG Chemicals%' ) ) LIMIT 1 [ RunTime:0.003694s ]
SELECT `id` FROM `stock` WHERE `id` <> 64287434 AND `partno` = '9410-30ML' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mg chemicals%' ) [ RunTime:0.005104s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15378332 [ RunTime:0.003633s ]
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 '941%' OR `brand` LIKE '941%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003052s ]
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 '941%' OR `brand` LIKE '941%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001420s ]
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 '941%' OR `brand` LIKE '941%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004448s ]
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 '941%' OR `brand` LIKE '941%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002164s ]
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 '941%' OR `brand` LIKE '941%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002326s ]
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 '941%' OR `brand` LIKE '941%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001208s ]
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 '941%' OR `brand` LIKE '941%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001386s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '941%' OR `brand` LIKE '941%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.004594s ]