SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002514s ]
INSERT INTO `visit_log` SET `ip` = '216.73.217.72' , `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=2218&search=1' [ RunTime:0.008115s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002302s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.001598s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002594s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.72' ) [ RunTime:0.008194s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002615s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000397s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.005489s ]
SELECT * FROM `stock_search` WHERE `partno` = '2218' LIMIT 1 [ RunTime:0.005271s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-08-07 19:26:15' WHERE `partno` = '2218' [ RunTime:0.006389s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002431s ]
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 '2218%' OR `brand` LIKE '2218%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.031102s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002054s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13494554 LIMIT 5 [ RunTime:0.002421s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001237s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13494554 ORDER BY `minOrder` ASC [ RunTime:0.000712s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001124s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13494554 ORDER BY `unit` DESC [ RunTime:0.002270s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001041s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13494554 LIMIT 2 [ RunTime:0.000452s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13494554 ORDER BY `minOrder` ASC [ RunTime:0.002463s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13495336 LIMIT 5 [ RunTime:0.005811s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13495336 ORDER BY `minOrder` ASC [ RunTime:0.000726s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13495336 ORDER BY `unit` DESC [ RunTime:0.000471s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13495336 LIMIT 2 [ RunTime:0.001406s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13495336 ORDER BY `minOrder` ASC [ RunTime:0.001880s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14376954 LIMIT 5 [ RunTime:0.001615s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14376954 ORDER BY `minOrder` ASC [ RunTime:0.000433s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14376954 ORDER BY `unit` DESC [ RunTime:0.011793s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14376954 LIMIT 2 [ RunTime:0.001650s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14376954 ORDER BY `minOrder` ASC [ RunTime:0.000593s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13501869 LIMIT 5 [ RunTime:0.000899s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13501869 ORDER BY `minOrder` ASC [ RunTime:0.009666s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13501869 ORDER BY `unit` DESC [ RunTime:0.002235s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13501869 LIMIT 2 [ RunTime:0.000746s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13501869 ORDER BY `minOrder` ASC [ RunTime:0.000477s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13516762 LIMIT 5 [ RunTime:0.017953s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13516762 ORDER BY `minOrder` ASC [ RunTime:0.016460s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13516762 ORDER BY `unit` DESC [ RunTime:0.010001s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13516762 LIMIT 2 [ RunTime:0.013182s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13516762 ORDER BY `minOrder` ASC [ RunTime:0.002750s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14386166 LIMIT 5 [ RunTime:0.012026s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14386166 ORDER BY `minOrder` ASC [ RunTime:0.005083s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14386166 ORDER BY `unit` DESC [ RunTime:0.005018s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14386166 LIMIT 2 [ RunTime:0.000556s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14386166 ORDER BY `minOrder` ASC [ RunTime:0.000325s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14389602 LIMIT 5 [ RunTime:0.004424s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14389602 ORDER BY `minOrder` ASC [ RunTime:0.007849s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14389602 ORDER BY `unit` DESC [ RunTime:0.003203s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14389602 LIMIT 2 [ RunTime:0.001827s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14389602 ORDER BY `minOrder` ASC [ RunTime:0.000607s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14330484 LIMIT 5 [ RunTime:0.000998s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14330484 ORDER BY `minOrder` ASC [ RunTime:0.000680s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14330484 ORDER BY `unit` DESC [ RunTime:0.000571s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14330484 LIMIT 2 [ RunTime:0.015490s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14330484 ORDER BY `minOrder` ASC [ RunTime:0.003654s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13516095 LIMIT 5 [ RunTime:0.007305s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13516095 ORDER BY `minOrder` ASC [ RunTime:0.011796s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13516095 ORDER BY `unit` DESC [ RunTime:0.004102s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13516095 LIMIT 2 [ RunTime:0.018266s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13516095 ORDER BY `minOrder` ASC [ RunTime:0.044158s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19775622 LIMIT 5 [ RunTime:0.016881s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19775622 ORDER BY `minOrder` ASC [ RunTime:0.048446s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19775622 ORDER BY `unit` DESC [ RunTime:0.019784s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19775622 LIMIT 2 [ RunTime:0.004490s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19775622 ORDER BY `minOrder` ASC [ RunTime:0.003297s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18596399 LIMIT 5 [ RunTime:0.005511s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18596399 ORDER BY `minOrder` ASC [ RunTime:0.015113s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18596399 ORDER BY `unit` DESC [ RunTime:0.009024s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18596399 LIMIT 2 [ RunTime:0.000903s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18596399 ORDER BY `minOrder` ASC [ RunTime:0.007882s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14347660 LIMIT 5 [ RunTime:0.011338s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14347660 ORDER BY `minOrder` ASC [ RunTime:0.012263s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14347660 ORDER BY `unit` DESC [ RunTime:0.030403s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14347660 LIMIT 2 [ RunTime:0.013213s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14347660 ORDER BY `minOrder` ASC [ RunTime:0.011307s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18596120 LIMIT 5 [ RunTime:0.054320s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18596120 ORDER BY `minOrder` ASC [ RunTime:0.037846s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18596120 ORDER BY `unit` DESC [ RunTime:0.047711s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18596120 LIMIT 2 [ RunTime:0.027716s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18596120 ORDER BY `minOrder` ASC [ RunTime:0.002393s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16969007 LIMIT 5 [ RunTime:0.021612s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16969007 ORDER BY `minOrder` ASC [ RunTime:0.038057s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16969007 ORDER BY `unit` DESC [ RunTime:0.039431s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16969007 LIMIT 2 [ RunTime:0.040613s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16969007 ORDER BY `minOrder` ASC [ RunTime:0.018731s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13516204 LIMIT 5 [ RunTime:0.021429s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13516204 ORDER BY `minOrder` ASC [ RunTime:0.037024s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13516204 ORDER BY `unit` DESC [ RunTime:0.060780s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13516204 LIMIT 2 [ RunTime:0.047014s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13516204 ORDER BY `minOrder` ASC [ RunTime:0.017596s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14388908 LIMIT 5 [ RunTime:0.088852s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14388908 ORDER BY `minOrder` ASC [ RunTime:0.018132s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14388908 ORDER BY `unit` DESC [ RunTime:0.044393s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14388908 LIMIT 2 [ RunTime:0.048596s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14388908 ORDER BY `minOrder` ASC [ RunTime:0.043695s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13515665 LIMIT 5 [ RunTime:0.057192s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13515665 ORDER BY `minOrder` ASC [ RunTime:0.146251s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13515665 ORDER BY `unit` DESC [ RunTime:0.061238s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13515665 LIMIT 2 [ RunTime:0.030523s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13515665 ORDER BY `minOrder` ASC [ RunTime:0.003197s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19764811 LIMIT 5 [ RunTime:0.063612s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19764811 ORDER BY `minOrder` ASC [ RunTime:0.070163s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19764811 ORDER BY `unit` DESC [ RunTime:0.063797s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19764811 LIMIT 2 [ RunTime:0.035303s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19764811 ORDER BY `minOrder` ASC [ RunTime:0.032009s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19764792 LIMIT 5 [ RunTime:0.030568s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19764792 ORDER BY `minOrder` ASC [ RunTime:0.059565s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19764792 ORDER BY `unit` DESC [ RunTime:0.066294s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19764792 LIMIT 2 [ RunTime:0.048671s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19764792 ORDER BY `minOrder` ASC [ RunTime:0.029241s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18753941 LIMIT 5 [ RunTime:0.053798s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18753941 ORDER BY `minOrder` ASC [ RunTime:0.022877s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18753941 ORDER BY `unit` DESC [ RunTime:0.015312s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18753941 LIMIT 2 [ RunTime:0.036914s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18753941 ORDER BY `minOrder` ASC [ RunTime:0.027170s ]
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 '2218%' OR `brand` LIKE '2218%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.083828s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51106586 LIMIT 5 [ RunTime:0.024643s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51106586 ORDER BY `minOrder` ASC [ RunTime:0.036168s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51106586 ORDER BY `unit` DESC [ RunTime:0.196258s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51106586 LIMIT 2 [ RunTime:0.045336s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51106586 ORDER BY `minOrder` ASC [ RunTime:0.058201s ]
select * from pdf where partno='2218' and brandshort='adafruit' limit 1 [ RunTime:0.047661s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002560s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2218' OR `brand` LIKE 'adafruit%' ) ) LIMIT 1 [ RunTime:0.032254s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51084913 LIMIT 5 [ RunTime:0.139946s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51084913 ORDER BY `minOrder` ASC [ RunTime:0.051660s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51084913 ORDER BY `unit` DESC [ RunTime:0.025411s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51084913 LIMIT 2 [ RunTime:0.041205s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51084913 ORDER BY `minOrder` ASC [ RunTime:0.098110s ]
select * from pdf where partno='2218f/2tdhho' and brandshort='ebm-papst' limit 1 [ RunTime:0.102583s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2218f/2tdhho' OR `brand` LIKE 'ebm-papst%' ) ) LIMIT 1 [ RunTime:0.070198s ]
SELECT `id` FROM `stock` WHERE `id` <> 51084913 AND `partno` = '2218f/2tdhho' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%ebm-papst%' ) [ RunTime:0.099584s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18596399 [ RunTime:0.088482s ]
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 '2218%' OR `brand` LIKE '2218%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.077927s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63390321 LIMIT 5 [ RunTime:0.076039s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63390321 ORDER BY `minOrder` ASC [ RunTime:0.085311s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63390321 ORDER BY `unit` DESC [ RunTime:0.000856s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63390321 LIMIT 2 [ RunTime:0.060241s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63390321 ORDER BY `minOrder` ASC [ RunTime:0.020473s ]
select * from pdf where partno='2218' and brandshort='Keystone Electronics' limit 1 [ RunTime:0.056142s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2218' OR `brand` LIKE 'Keystone Electronics%' ) ) LIMIT 1 [ RunTime:0.040562s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63001782 LIMIT 5 [ RunTime:0.059676s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63001782 ORDER BY `minOrder` ASC [ RunTime:0.091865s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63001782 ORDER BY `unit` DESC [ RunTime:0.099978s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63001782 LIMIT 2 [ RunTime:0.058726s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63001782 ORDER BY `minOrder` ASC [ RunTime:0.013772s ]
select * from pdf where partno='221809' and brandshort='LAPP' limit 1 [ RunTime:0.057995s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '221809' OR `brand` LIKE 'LAPP%' ) ) LIMIT 1 [ RunTime:0.073916s ]
SELECT `id` FROM `stock` WHERE `id` <> 63001782 AND `partno` = '221809' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lapp%' ) [ RunTime:0.068281s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62997816 LIMIT 5 [ RunTime:0.059428s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62997816 ORDER BY `minOrder` ASC [ RunTime:0.124567s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62997816 ORDER BY `unit` DESC [ RunTime:0.068574s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62997816 LIMIT 2 [ RunTime:0.070225s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62997816 ORDER BY `minOrder` ASC [ RunTime:0.061820s ]
select * from pdf where partno='221825' and brandshort='LAPP' limit 1 [ RunTime:0.053752s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '221825' OR `brand` LIKE 'LAPP%' ) ) LIMIT 1 [ RunTime:0.082451s ]
SELECT `id` FROM `stock` WHERE `id` <> 62997816 AND `partno` = '221825' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lapp%' ) [ RunTime:0.102396s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13505291 [ RunTime:0.120652s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63002334 LIMIT 5 [ RunTime:0.084114s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63002334 ORDER BY `minOrder` ASC [ RunTime:0.039834s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63002334 ORDER BY `unit` DESC [ RunTime:0.100848s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63002334 LIMIT 2 [ RunTime:0.147427s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63002334 ORDER BY `minOrder` ASC [ RunTime:0.051342s ]
select * from pdf where partno='221805' and brandshort='LAPP' limit 1 [ RunTime:0.051680s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '221805' OR `brand` LIKE 'LAPP%' ) ) LIMIT 1 [ RunTime:0.045202s ]
SELECT `id` FROM `stock` WHERE `id` <> 63002334 AND `partno` = '221805' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lapp%' ) [ RunTime:0.111960s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13500025 [ RunTime:0.091665s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62997484 LIMIT 5 [ RunTime:0.170338s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62997484 ORDER BY `minOrder` ASC [ RunTime:0.064766s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62997484 ORDER BY `unit` DESC [ RunTime:0.084650s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62997484 LIMIT 2 [ RunTime:0.044090s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62997484 ORDER BY `minOrder` ASC [ RunTime:0.013313s ]
select * from pdf where partno='2218050' and brandshort='LAPP' limit 1 [ RunTime:0.033714s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2218050' OR `brand` LIKE 'LAPP%' ) ) LIMIT 1 [ RunTime:0.030292s ]
SELECT `id` FROM `stock` WHERE `id` <> 62997484 AND `partno` = '2218050' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lapp%' ) [ RunTime:0.022673s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13502078 [ RunTime:0.014068s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63001990 LIMIT 5 [ RunTime:0.005850s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63001990 ORDER BY `minOrder` ASC [ RunTime:0.044593s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63001990 ORDER BY `unit` DESC [ RunTime:0.094680s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63001990 LIMIT 2 [ RunTime:0.079390s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63001990 ORDER BY `minOrder` ASC [ RunTime:0.021091s ]
select * from pdf where partno='221818' and brandshort='LAPP' limit 1 [ RunTime:0.017273s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '221818' OR `brand` LIKE 'LAPP%' ) ) LIMIT 1 [ RunTime:0.025473s ]
SELECT `id` FROM `stock` WHERE `id` <> 63001990 AND `partno` = '221818' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lapp%' ) [ RunTime:0.027690s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13505142 [ RunTime:0.042678s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62997867 LIMIT 5 [ RunTime:0.026074s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62997867 ORDER BY `minOrder` ASC [ RunTime:0.035810s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62997867 ORDER BY `unit` DESC [ RunTime:0.032961s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62997867 LIMIT 2 [ RunTime:0.028980s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62997867 ORDER BY `minOrder` ASC [ RunTime:0.028258s ]
select * from pdf where partno='2218180' and brandshort='LAPP' limit 1 [ RunTime:0.028027s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2218180' OR `brand` LIKE 'LAPP%' ) ) LIMIT 1 [ RunTime:0.019592s ]
SELECT `id` FROM `stock` WHERE `id` <> 62997867 AND `partno` = '2218180' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lapp%' ) [ RunTime:0.007541s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14380361 [ RunTime:0.013242s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63002044 LIMIT 5 [ RunTime:0.016273s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63002044 ORDER BY `minOrder` ASC [ RunTime:0.067005s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63002044 ORDER BY `unit` DESC [ RunTime:0.039844s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63002044 LIMIT 2 [ RunTime:0.027069s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63002044 ORDER BY `minOrder` ASC [ RunTime:0.024943s ]
select * from pdf where partno='2218120' and brandshort='LAPP' limit 1 [ RunTime:0.052938s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2218120' OR `brand` LIKE 'LAPP%' ) ) LIMIT 1 [ RunTime:0.014627s ]
SELECT `id` FROM `stock` WHERE `id` <> 63002044 AND `partno` = '2218120' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lapp%' ) [ RunTime:0.009388s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13506038 [ RunTime:0.021065s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40461944 LIMIT 5 [ RunTime:0.023476s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40461944 ORDER BY `minOrder` ASC [ RunTime:0.012469s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40461944 ORDER BY `unit` DESC [ RunTime:0.010521s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40461944 LIMIT 2 [ RunTime:0.009840s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40461944 ORDER BY `minOrder` ASC [ RunTime:0.005401s ]
select * from pdf where partno='2218-V-RC' and brandshort='Bourns Inc.' limit 1 [ RunTime:0.031601s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2218-V-RC' OR `brand` LIKE 'Bourns Inc.%' ) ) LIMIT 1 [ RunTime:0.022355s ]
SELECT `id` FROM `stock` WHERE `id` <> 40461944 AND `partno` = '2218-V-RC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bourns inc.%' ) [ RunTime:0.008088s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14330484 [ RunTime:0.010479s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62997890 LIMIT 5 [ RunTime:0.005190s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62997890 ORDER BY `minOrder` ASC [ RunTime:0.011201s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62997890 ORDER BY `unit` DESC [ RunTime:0.012923s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62997890 LIMIT 2 [ RunTime:0.011605s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62997890 ORDER BY `minOrder` ASC [ RunTime:0.012329s ]
select * from pdf where partno='2218250' and brandshort='LAPP' limit 1 [ RunTime:0.034692s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2218250' OR `brand` LIKE 'LAPP%' ) ) LIMIT 1 [ RunTime:0.003014s ]
SELECT `id` FROM `stock` WHERE `id` <> 62997890 AND `partno` = '2218250' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lapp%' ) [ RunTime:0.022896s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13507563 [ RunTime:0.023159s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60942991 LIMIT 5 [ RunTime:0.026705s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60942991 ORDER BY `minOrder` ASC [ RunTime:0.023345s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60942991 ORDER BY `unit` DESC [ RunTime:0.032249s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60942991 LIMIT 2 [ RunTime:0.015213s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60942991 ORDER BY `minOrder` ASC [ RunTime:0.009926s ]
select * from pdf where partno='2218929301' and brandshort='Molex' limit 1 [ RunTime:0.021322s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2218929301' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.013281s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60409806 LIMIT 5 [ RunTime:0.013455s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60409806 ORDER BY `minOrder` ASC [ RunTime:0.005338s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60409806 ORDER BY `unit` DESC [ RunTime:0.000863s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60409806 LIMIT 2 [ RunTime:0.002925s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60409806 ORDER BY `minOrder` ASC [ RunTime:0.003325s ]
select * from pdf where partno='2218.0' and brandshort='Conta-Clip, Inc.' limit 1 [ RunTime:0.001042s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2218.0' OR `brand` LIKE 'Conta-Clip, Inc.%' ) ) LIMIT 1 [ RunTime:0.002496s ]
SELECT `id` FROM `stock` WHERE `id` <> 60409806 AND `partno` = '2218.0' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%conta-clip, inc.%' ) [ RunTime:0.001182s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60942993 LIMIT 5 [ RunTime:0.000723s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60942993 ORDER BY `minOrder` ASC [ RunTime:0.006316s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60942993 ORDER BY `unit` DESC [ RunTime:0.001347s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60942993 LIMIT 2 [ RunTime:0.000719s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60942993 ORDER BY `minOrder` ASC [ RunTime:0.000504s ]
select * from pdf where partno='2218923128' and brandshort='Molex' limit 1 [ RunTime:0.008198s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2218923128' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.016491s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59452619 LIMIT 5 [ RunTime:0.006300s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59452619 ORDER BY `minOrder` ASC [ RunTime:0.025059s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59452619 ORDER BY `unit` DESC [ RunTime:0.015461s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59452619 LIMIT 2 [ RunTime:0.016331s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59452619 ORDER BY `minOrder` ASC [ RunTime:0.000691s ]
select * from pdf where partno='2218883322' and brandshort='Molex' limit 1 [ RunTime:0.001007s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2218883322' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.024512s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58476502 LIMIT 5 [ RunTime:0.007419s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58476502 ORDER BY `minOrder` ASC [ RunTime:0.003987s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58476502 ORDER BY `unit` DESC [ RunTime:0.003307s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58476502 LIMIT 2 [ RunTime:0.002016s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58476502 ORDER BY `minOrder` ASC [ RunTime:0.003216s ]
select * from pdf where partno='2218F/2TDHHO' and brandshort='ebm-papst Inc.' limit 1 [ RunTime:0.001050s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2218F/2TDHHO' OR `brand` LIKE 'ebm-papst Inc.%' ) ) LIMIT 1 [ RunTime:0.003285s ]
SELECT `id` FROM `stock` WHERE `id` <> 58476502 AND `partno` = '2218F/2TDHHO' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%ebm-papst inc.%' ) [ RunTime:0.001243s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18596399 [ RunTime:0.000434s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59452703 LIMIT 5 [ RunTime:0.000785s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59452703 ORDER BY `minOrder` ASC [ RunTime:0.005811s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59452703 ORDER BY `unit` DESC [ RunTime:0.003912s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59452703 LIMIT 2 [ RunTime:0.006367s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59452703 ORDER BY `minOrder` ASC [ RunTime:0.000445s ]
select * from pdf where partno='2218873322' and brandshort='Molex' limit 1 [ RunTime:0.000839s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2218873322' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.013798s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59452620 LIMIT 5 [ RunTime:0.000672s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59452620 ORDER BY `minOrder` ASC [ RunTime:0.000750s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59452620 ORDER BY `unit` DESC [ RunTime:0.000613s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59452620 LIMIT 2 [ RunTime:0.002710s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59452620 ORDER BY `minOrder` ASC [ RunTime:0.000459s ]
select * from pdf where partno='2218883321' and brandshort='Molex' limit 1 [ RunTime:0.005201s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2218883321' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.013317s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60942992 LIMIT 5 [ RunTime:0.007502s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60942992 ORDER BY `minOrder` ASC [ RunTime:0.000787s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60942992 ORDER BY `unit` DESC [ RunTime:0.000634s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60942992 LIMIT 2 [ RunTime:0.001727s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60942992 ORDER BY `minOrder` ASC [ RunTime:0.000444s ]
select * from pdf where partno='2218919301' and brandshort='Molex' limit 1 [ RunTime:0.000868s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2218919301' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.012802s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59452704 LIMIT 5 [ RunTime:0.000699s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59452704 ORDER BY `minOrder` ASC [ RunTime:0.002853s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59452704 ORDER BY `unit` DESC [ RunTime:0.007744s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59452704 LIMIT 2 [ RunTime:0.002026s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59452704 ORDER BY `minOrder` ASC [ RunTime:0.000614s ]
select * from pdf where partno='2218873321' and brandshort='Molex' limit 1 [ RunTime:0.001004s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2218873321' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.014992s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63007857 LIMIT 5 [ RunTime:0.006298s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63007857 ORDER BY `minOrder` ASC [ RunTime:0.005766s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63007857 ORDER BY `unit` DESC [ RunTime:0.003639s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63007857 LIMIT 2 [ RunTime:0.008765s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63007857 ORDER BY `minOrder` ASC [ RunTime:0.003564s ]
select * from pdf where partno='221807' and brandshort='LAPP' limit 1 [ RunTime:0.008931s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '221807' OR `brand` LIKE 'LAPP%' ) ) LIMIT 1 [ RunTime:0.004279s ]
SELECT `id` FROM `stock` WHERE `id` <> 63007857 AND `partno` = '221807' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lapp%' ) [ RunTime:0.001507s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13494554 [ RunTime:0.003054s ]
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 '2218%' OR `brand` LIKE '2218%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001710s ]
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 '2218%' OR `brand` LIKE '2218%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004920s ]
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 '2218%' OR `brand` LIKE '2218%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001812s ]
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 '2218%' OR `brand` LIKE '2218%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005807s ]
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 '2218%' OR `brand` LIKE '2218%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001840s ]
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 '2218%' OR `brand` LIKE '2218%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006200s ]
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 '2218%' OR `brand` LIKE '2218%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005923s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '2218%' OR `brand` LIKE '2218%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.002925s ]