SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001357s ]
INSERT INTO `visit_log` SET `ip` = '216.73.217.37' , `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=11938&search=1' [ RunTime:0.005348s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001461s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000603s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002673s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.37' ) [ RunTime:0.000413s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002110s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.005665s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002549s ]
SELECT * FROM `stock_search` WHERE `partno` = '11938' LIMIT 1 [ RunTime:0.002344s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-08-01 15:22:34' WHERE `partno` = '11938' [ RunTime:0.029084s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002185s ]
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 '11938%' OR `brand` LIKE '11938%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.047441s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001482s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18599700 LIMIT 5 [ RunTime:0.005416s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001185s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18599700 ORDER BY `minOrder` ASC [ RunTime:0.001276s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002363s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18599700 ORDER BY `unit` DESC [ RunTime:0.004841s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001094s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18599700 LIMIT 2 [ RunTime:0.001043s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18599700 ORDER BY `minOrder` ASC [ RunTime:0.008057s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16009079 LIMIT 5 [ RunTime:0.009213s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16009079 ORDER BY `minOrder` ASC [ RunTime:0.009687s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16009079 ORDER BY `unit` DESC [ RunTime:0.011739s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16009079 LIMIT 2 [ RunTime:0.008376s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16009079 ORDER BY `minOrder` ASC [ RunTime:0.006519s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18600588 LIMIT 5 [ RunTime:0.017388s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18600588 ORDER BY `minOrder` ASC [ RunTime:0.004392s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18600588 ORDER BY `unit` DESC [ RunTime:0.002211s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18600588 LIMIT 2 [ RunTime:0.001586s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18600588 ORDER BY `minOrder` ASC [ RunTime:0.005229s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13349458 LIMIT 5 [ RunTime:0.017793s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13349458 ORDER BY `minOrder` ASC [ RunTime:0.004525s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13349458 ORDER BY `unit` DESC [ RunTime:0.015486s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13349458 LIMIT 2 [ RunTime:0.023346s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13349458 ORDER BY `minOrder` ASC [ RunTime:0.019351s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16009080 LIMIT 5 [ RunTime:0.039733s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16009080 ORDER BY `minOrder` ASC [ RunTime:0.033471s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16009080 ORDER BY `unit` DESC [ RunTime:0.012307s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16009080 LIMIT 2 [ RunTime:0.032638s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16009080 ORDER BY `minOrder` ASC [ RunTime:0.000807s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16009081 LIMIT 5 [ RunTime:0.031993s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16009081 ORDER BY `minOrder` ASC [ RunTime:0.017698s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16009081 ORDER BY `unit` DESC [ RunTime:0.013402s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16009081 LIMIT 2 [ RunTime:0.029157s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16009081 ORDER BY `minOrder` ASC [ RunTime:0.064611s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16006259 LIMIT 5 [ RunTime:0.017716s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16006259 ORDER BY `minOrder` ASC [ RunTime:0.022125s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16006259 ORDER BY `unit` DESC [ RunTime:0.024668s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16006259 LIMIT 2 [ RunTime:0.027765s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16006259 ORDER BY `minOrder` ASC [ RunTime:0.008585s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18599702 LIMIT 5 [ RunTime:0.019806s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18599702 ORDER BY `minOrder` ASC [ RunTime:0.046193s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18599702 ORDER BY `unit` DESC [ RunTime:0.044590s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18599702 LIMIT 2 [ RunTime:0.048591s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18599702 ORDER BY `minOrder` ASC [ RunTime:0.014025s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18595843 LIMIT 5 [ RunTime:0.028964s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18595843 ORDER BY `minOrder` ASC [ RunTime:0.035661s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18595843 ORDER BY `unit` DESC [ RunTime:0.018786s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18595843 LIMIT 2 [ RunTime:0.047227s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18595843 ORDER BY `minOrder` ASC [ RunTime:0.041577s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16008750 LIMIT 5 [ RunTime:0.039411s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16008750 ORDER BY `minOrder` ASC [ RunTime:0.044366s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16008750 ORDER BY `unit` DESC [ RunTime:0.006589s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16008750 LIMIT 2 [ RunTime:0.009007s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16008750 ORDER BY `minOrder` ASC [ RunTime:0.073563s ]
select * from pdf where partno='11938MA-24N-EA-D0' and brandshort='NMB Technologies Corporation' limit 1 [ RunTime:0.047700s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18595844 LIMIT 5 [ RunTime:0.004360s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18595844 ORDER BY `minOrder` ASC [ RunTime:0.020664s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18595844 ORDER BY `unit` DESC [ RunTime:0.027598s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18595844 LIMIT 2 [ RunTime:0.061087s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18595844 ORDER BY `minOrder` ASC [ RunTime:0.031404s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16010478 LIMIT 5 [ RunTime:0.052747s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16010478 ORDER BY `minOrder` ASC [ RunTime:0.042919s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16010478 ORDER BY `unit` DESC [ RunTime:0.016790s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16010478 LIMIT 2 [ RunTime:0.000902s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16010478 ORDER BY `minOrder` ASC [ RunTime:0.009910s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18596319 LIMIT 5 [ RunTime:0.025190s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18596319 ORDER BY `minOrder` ASC [ RunTime:0.032767s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18596319 ORDER BY `unit` DESC [ RunTime:0.028189s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18596319 LIMIT 2 [ RunTime:0.044831s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18596319 ORDER BY `minOrder` ASC [ RunTime:0.020674s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18600726 LIMIT 5 [ RunTime:0.027500s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18600726 ORDER BY `minOrder` ASC [ RunTime:0.041215s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18600726 ORDER BY `unit` DESC [ RunTime:0.025827s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18600726 LIMIT 2 [ RunTime:0.017950s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18600726 ORDER BY `minOrder` ASC [ RunTime:0.019627s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16007023 LIMIT 5 [ RunTime:0.052462s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16007023 ORDER BY `minOrder` ASC [ RunTime:0.024703s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16007023 ORDER BY `unit` DESC [ RunTime:0.040016s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16007023 LIMIT 2 [ RunTime:0.008562s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16007023 ORDER BY `minOrder` ASC [ RunTime:0.001756s ]
select * from pdf where partno='11938ME-24P-GA-00' and brandshort='NMB Technologies Corporation' limit 1 [ RunTime:0.002638s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15183531 LIMIT 5 [ RunTime:0.039165s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15183531 ORDER BY `minOrder` ASC [ RunTime:0.007559s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15183531 ORDER BY `unit` DESC [ RunTime:0.034979s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15183531 LIMIT 2 [ RunTime:0.058360s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15183531 ORDER BY `minOrder` ASC [ RunTime:0.025127s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16970217 LIMIT 5 [ RunTime:0.014671s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16970217 ORDER BY `minOrder` ASC [ RunTime:0.041901s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16970217 ORDER BY `unit` DESC [ RunTime:0.025450s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16970217 LIMIT 2 [ RunTime:0.040770s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16970217 ORDER BY `minOrder` ASC [ RunTime:0.007196s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18597052 LIMIT 5 [ RunTime:0.031258s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18597052 ORDER BY `minOrder` ASC [ RunTime:0.030769s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18597052 ORDER BY `unit` DESC [ RunTime:0.033263s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18597052 LIMIT 2 [ RunTime:0.017609s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18597052 ORDER BY `minOrder` ASC [ RunTime:0.003327s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18596881 LIMIT 5 [ RunTime:0.008702s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18596881 ORDER BY `minOrder` ASC [ RunTime:0.005766s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18596881 ORDER BY `unit` DESC [ RunTime:0.002309s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18596881 LIMIT 2 [ RunTime:0.014889s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18596881 ORDER BY `minOrder` ASC [ RunTime:0.004456s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16970710 LIMIT 5 [ RunTime:0.007262s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16970710 ORDER BY `minOrder` ASC [ RunTime:0.008257s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16970710 ORDER BY `unit` DESC [ RunTime:0.021514s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16970710 LIMIT 2 [ RunTime:0.000647s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16970710 ORDER BY `minOrder` ASC [ RunTime:0.000596s ]
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 '11938%' OR `brand` LIKE '11938%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.018870s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51085814 LIMIT 5 [ RunTime:0.006462s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51085814 ORDER BY `minOrder` ASC [ RunTime:0.010351s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51085814 ORDER BY `unit` DESC [ RunTime:0.011469s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51085814 LIMIT 2 [ RunTime:0.014843s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51085814 ORDER BY `minOrder` ASC [ RunTime:0.005557s ]
select * from pdf where partno='11938mb-b3n-ea-c0' and brandshort='nmb' limit 1 [ RunTime:0.007380s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.003559s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '11938mb-b3n-ea-c0' OR `brand` LIKE 'nmb%' ) ) LIMIT 1 [ RunTime:0.012516s ]
SELECT `id` FROM `stock` WHERE `id` <> 51085814 AND `partno` = '11938mb-b3n-ea-c0' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%nmb%' ) [ RunTime:0.008904s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58473268 [ RunTime:0.006316s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51085728 LIMIT 5 [ RunTime:0.021199s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51085728 ORDER BY `minOrder` ASC [ RunTime:0.035897s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51085728 ORDER BY `unit` DESC [ RunTime:0.023584s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51085728 LIMIT 2 [ RunTime:0.014403s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51085728 ORDER BY `minOrder` ASC [ RunTime:0.019869s ]
select * from pdf where partno='11938mb-a1m-ea-00' and brandshort='nmb' limit 1 [ RunTime:0.008503s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '11938mb-a1m-ea-00' OR `brand` LIKE 'nmb%' ) ) LIMIT 1 [ RunTime:0.026301s ]
SELECT `id` FROM `stock` WHERE `id` <> 51085728 AND `partno` = '11938mb-a1m-ea-00' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%nmb%' ) [ RunTime:0.046083s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18599702 [ RunTime:0.040050s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32177870 LIMIT 5 [ RunTime:0.029289s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32177870 ORDER BY `minOrder` ASC [ RunTime:0.057000s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32177870 ORDER BY `unit` DESC [ RunTime:0.038200s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32177870 LIMIT 2 [ RunTime:0.021646s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32177870 ORDER BY `minOrder` ASC [ RunTime:0.008951s ]
select * from pdf where partno='11938ka-24n-el-00' and brandshort='nmb' limit 1 [ RunTime:0.032929s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '11938ka-24n-el-00' OR `brand` LIKE 'nmb%' ) ) LIMIT 1 [ RunTime:0.062360s ]
SELECT `id` FROM `stock` WHERE `id` <> 32177870 AND `partno` = '11938ka-24n-el-00' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%nmb%' ) [ RunTime:0.026395s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32287101 [ RunTime:0.069058s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18595843 [ RunTime:0.056302s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32287101 LIMIT 5 [ RunTime:0.023042s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32287101 ORDER BY `minOrder` ASC [ RunTime:0.011715s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32287101 ORDER BY `unit` DESC [ RunTime:0.032755s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32287101 LIMIT 2 [ RunTime:0.048959s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32287101 ORDER BY `minOrder` ASC [ RunTime:0.037191s ]
select * from pdf where partno='11938ka-24n-el-00' and brandshort='nmb' limit 1 [ RunTime:0.006955s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '11938ka-24n-el-00' OR `brand` LIKE 'nmb%' ) ) LIMIT 1 [ RunTime:0.018514s ]
SELECT `id` FROM `stock` WHERE `id` <> 32287101 AND `partno` = '11938ka-24n-el-00' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%nmb%' ) [ RunTime:0.025413s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32177870 [ RunTime:0.025156s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18595843 [ RunTime:0.030378s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51085624 LIMIT 5 [ RunTime:0.024826s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51085624 ORDER BY `minOrder` ASC [ RunTime:0.020794s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51085624 ORDER BY `unit` DESC [ RunTime:0.016042s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51085624 LIMIT 2 [ RunTime:0.008758s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51085624 ORDER BY `minOrder` ASC [ RunTime:0.003652s ]
select * from pdf where partno='11938ka-48l-et-00' and brandshort='nmb' limit 1 [ RunTime:0.020602s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '11938ka-48l-et-00' OR `brand` LIKE 'nmb%' ) ) LIMIT 1 [ RunTime:0.040209s ]
SELECT `id` FROM `stock` WHERE `id` <> 51085624 AND `partno` = '11938ka-48l-et-00' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%nmb%' ) [ RunTime:0.059668s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15180297 [ RunTime:0.034624s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51085693 LIMIT 5 [ RunTime:0.029897s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51085693 ORDER BY `minOrder` ASC [ RunTime:0.013900s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51085693 ORDER BY `unit` DESC [ RunTime:0.024690s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51085693 LIMIT 2 [ RunTime:0.042624s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51085693 ORDER BY `minOrder` ASC [ RunTime:0.030256s ]
select * from pdf where partno='11938ka-48j-ea-00' and brandshort='nmb' limit 1 [ RunTime:0.045159s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '11938ka-48j-ea-00' OR `brand` LIKE 'nmb%' ) ) LIMIT 1 [ RunTime:0.022036s ]
SELECT `id` FROM `stock` WHERE `id` <> 51085693 AND `partno` = '11938ka-48j-ea-00' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%nmb%' ) [ RunTime:0.037734s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15180254 [ RunTime:0.027452s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51085637 LIMIT 5 [ RunTime:0.034335s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51085637 ORDER BY `minOrder` ASC [ RunTime:0.013055s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51085637 ORDER BY `unit` DESC [ RunTime:0.024618s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51085637 LIMIT 2 [ RunTime:0.007101s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51085637 ORDER BY `minOrder` ASC [ RunTime:0.003213s ]
select * from pdf where partno='11938ka-12m-el-00' and brandshort='nmb' limit 1 [ RunTime:0.008351s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '11938ka-12m-el-00' OR `brand` LIKE 'nmb%' ) ) LIMIT 1 [ RunTime:0.007474s ]
SELECT `id` FROM `stock` WHERE `id` <> 51085637 AND `partno` = '11938ka-12m-el-00' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%nmb%' ) [ RunTime:0.028853s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18591563 [ RunTime:0.021054s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51085638 LIMIT 5 [ RunTime:0.007585s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51085638 ORDER BY `minOrder` ASC [ RunTime:0.010187s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51085638 ORDER BY `unit` DESC [ RunTime:0.008403s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51085638 LIMIT 2 [ RunTime:0.005575s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51085638 ORDER BY `minOrder` ASC [ RunTime:0.008822s ]
select * from pdf where partno='11938ka-24m-el-00' and brandshort='nmb' limit 1 [ RunTime:0.016029s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '11938ka-24m-el-00' OR `brand` LIKE 'nmb%' ) ) LIMIT 1 [ RunTime:0.040843s ]
SELECT `id` FROM `stock` WHERE `id` <> 51085638 AND `partno` = '11938ka-24m-el-00' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%nmb%' ) [ RunTime:0.012537s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16006274 [ RunTime:0.036477s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51085639 LIMIT 5 [ RunTime:0.010796s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51085639 ORDER BY `minOrder` ASC [ RunTime:0.019921s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51085639 ORDER BY `unit` DESC [ RunTime:0.006323s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51085639 LIMIT 2 [ RunTime:0.014157s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51085639 ORDER BY `minOrder` ASC [ RunTime:0.015171s ]
select * from pdf where partno='11938mb-b3n-ap-00' and brandshort='nmb' limit 1 [ RunTime:0.018374s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '11938mb-b3n-ap-00' OR `brand` LIKE 'nmb%' ) ) LIMIT 1 [ RunTime:0.009154s ]
SELECT `id` FROM `stock` WHERE `id` <> 51085639 AND `partno` = '11938mb-b3n-ap-00' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%nmb%' ) [ RunTime:0.032257s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15183139 [ RunTime:0.003706s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51085679 LIMIT 5 [ RunTime:0.005943s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51085679 ORDER BY `minOrder` ASC [ RunTime:0.005126s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51085679 ORDER BY `unit` DESC [ RunTime:0.000753s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51085679 LIMIT 2 [ RunTime:0.009243s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51085679 ORDER BY `minOrder` ASC [ RunTime:0.027979s ]
select * from pdf where partno='11938mb-a1n-ap-00' and brandshort='nmb' limit 1 [ RunTime:0.022086s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '11938mb-a1n-ap-00' OR `brand` LIKE 'nmb%' ) ) LIMIT 1 [ RunTime:0.018222s ]
SELECT `id` FROM `stock` WHERE `id` <> 51085679 AND `partno` = '11938mb-a1n-ap-00' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%nmb%' ) [ RunTime:0.028165s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15183137 [ RunTime:0.009118s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51085664 LIMIT 5 [ RunTime:0.010439s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51085664 ORDER BY `minOrder` ASC [ RunTime:0.005764s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51085664 ORDER BY `unit` DESC [ RunTime:0.014573s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51085664 LIMIT 2 [ RunTime:0.002758s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51085664 ORDER BY `minOrder` ASC [ RunTime:0.002584s ]
select * from pdf where partno='11938mb-a1m-aa-00' and brandshort='nmb' limit 1 [ RunTime:0.014346s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '11938mb-a1m-aa-00' OR `brand` LIKE 'nmb%' ) ) LIMIT 1 [ RunTime:0.020921s ]
SELECT `id` FROM `stock` WHERE `id` <> 51085664 AND `partno` = '11938mb-a1m-aa-00' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%nmb%' ) [ RunTime:0.011339s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18599565 [ RunTime:0.057520s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51085640 LIMIT 5 [ RunTime:0.017379s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51085640 ORDER BY `minOrder` ASC [ RunTime:0.045557s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51085640 ORDER BY `unit` DESC [ RunTime:0.018192s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51085640 LIMIT 2 [ RunTime:0.012977s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51085640 ORDER BY `minOrder` ASC [ RunTime:0.017093s ]
select * from pdf where partno='11938sb-a1n-np-00' and brandshort='nmb' limit 1 [ RunTime:0.048432s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '11938sb-a1n-np-00' OR `brand` LIKE 'nmb%' ) ) LIMIT 1 [ RunTime:0.017161s ]
SELECT `id` FROM `stock` WHERE `id` <> 51085640 AND `partno` = '11938sb-a1n-np-00' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%nmb%' ) [ RunTime:0.030713s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16970710 [ RunTime:0.044036s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51085608 LIMIT 5 [ RunTime:0.007476s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51085608 ORDER BY `minOrder` ASC [ RunTime:0.045159s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51085608 ORDER BY `unit` DESC [ RunTime:0.042228s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51085608 LIMIT 2 [ RunTime:0.040347s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51085608 ORDER BY `minOrder` ASC [ RunTime:0.014849s ]
select * from pdf where partno='11938ka-24n-et-00' and brandshort='nmb' limit 1 [ RunTime:0.015448s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '11938ka-24n-et-00' OR `brand` LIKE 'nmb%' ) ) LIMIT 1 [ RunTime:0.017732s ]
SELECT `id` FROM `stock` WHERE `id` <> 51085608 AND `partno` = '11938ka-24n-et-00' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%nmb%' ) [ RunTime:0.035405s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18591559 [ RunTime:0.016043s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51085692 LIMIT 5 [ RunTime:0.006876s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51085692 ORDER BY `minOrder` ASC [ RunTime:0.036613s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51085692 ORDER BY `unit` DESC [ RunTime:0.016905s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51085692 LIMIT 2 [ RunTime:0.024687s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51085692 ORDER BY `minOrder` ASC [ RunTime:0.012345s ]
select * from pdf where partno='11938ka-24k-et-00' and brandshort='nmb' limit 1 [ RunTime:0.038975s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '11938ka-24k-et-00' OR `brand` LIKE 'nmb%' ) ) LIMIT 1 [ RunTime:0.047078s ]
SELECT `id` FROM `stock` WHERE `id` <> 51085692 AND `partno` = '11938ka-24k-et-00' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%nmb%' ) [ RunTime:0.019918s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18591553 [ RunTime:0.031398s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51085663 LIMIT 5 [ RunTime:0.030824s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51085663 ORDER BY `minOrder` ASC [ RunTime:0.014269s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51085663 ORDER BY `unit` DESC [ RunTime:0.014165s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51085663 LIMIT 2 [ RunTime:0.008971s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51085663 ORDER BY `minOrder` ASC [ RunTime:0.016635s ]
select * from pdf where partno='11938fb-b3n-ep-00' and brandshort='nmb' limit 1 [ RunTime:0.008216s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '11938fb-b3n-ep-00' OR `brand` LIKE 'nmb%' ) ) LIMIT 1 [ RunTime:0.015283s ]
SELECT `id` FROM `stock` WHERE `id` <> 51085663 AND `partno` = '11938fb-b3n-ep-00' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%nmb%' ) [ RunTime:0.014973s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16010554 [ RunTime:0.023370s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51085625 LIMIT 5 [ RunTime:0.009151s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51085625 ORDER BY `minOrder` ASC [ RunTime:0.015104s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51085625 ORDER BY `unit` DESC [ RunTime:0.012196s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51085625 LIMIT 2 [ RunTime:0.015812s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51085625 ORDER BY `minOrder` ASC [ RunTime:0.003584s ]
select * from pdf where partno='11938mb-a1l-aa-00' and brandshort='nmb' limit 1 [ RunTime:0.003608s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '11938mb-a1l-aa-00' OR `brand` LIKE 'nmb%' ) ) LIMIT 1 [ RunTime:0.013279s ]
SELECT `id` FROM `stock` WHERE `id` <> 51085625 AND `partno` = '11938mb-a1l-aa-00' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%nmb%' ) [ RunTime:0.016091s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15183127 [ RunTime:0.025655s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51085678 LIMIT 5 [ RunTime:0.013285s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51085678 ORDER BY `minOrder` ASC [ RunTime:0.002557s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51085678 ORDER BY `unit` DESC [ RunTime:0.006197s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51085678 LIMIT 2 [ RunTime:0.021159s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51085678 ORDER BY `minOrder` ASC [ RunTime:0.005113s ]
select * from pdf where partno='11938ka-12l-el-00' and brandshort='nmb' limit 1 [ RunTime:0.006041s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '11938ka-12l-el-00' OR `brand` LIKE 'nmb%' ) ) LIMIT 1 [ RunTime:0.015924s ]
SELECT `id` FROM `stock` WHERE `id` <> 51085678 AND `partno` = '11938ka-12l-el-00' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%nmb%' ) [ RunTime:0.008343s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18591561 [ RunTime:0.006339s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51085636 LIMIT 5 [ RunTime:0.015192s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51085636 ORDER BY `minOrder` ASC [ RunTime:0.015487s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51085636 ORDER BY `unit` DESC [ RunTime:0.006981s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51085636 LIMIT 2 [ RunTime:0.005303s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51085636 ORDER BY `minOrder` ASC [ RunTime:0.019833s ]
select * from pdf where partno='11938fb-a1k-aa-00' and brandshort='nmb' limit 1 [ RunTime:0.007315s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '11938fb-a1k-aa-00' OR `brand` LIKE 'nmb%' ) ) LIMIT 1 [ RunTime:0.005421s ]
SELECT `id` FROM `stock` WHERE `id` <> 51085636 AND `partno` = '11938fb-a1k-aa-00' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%nmb%' ) [ RunTime:0.004010s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15183125 [ RunTime:0.000798s ]
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 '11938%' OR `brand` LIKE '11938%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.024750s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57740208 LIMIT 5 [ RunTime:0.004256s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57740208 ORDER BY `minOrder` ASC [ RunTime:0.009132s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57740208 ORDER BY `unit` DESC [ RunTime:0.000616s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57740208 LIMIT 2 [ RunTime:0.000661s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57740208 ORDER BY `minOrder` ASC [ RunTime:0.000417s ]
select * from pdf where partno='11938CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.005736s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '11938CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.009746s ]
SELECT `id` FROM `stock` WHERE `id` <> 57740208 AND `partno` = '11938CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.002576s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13349458 [ RunTime:0.008268s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58471640 LIMIT 5 [ RunTime:0.003769s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58471640 ORDER BY `minOrder` ASC [ RunTime:0.002128s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58471640 ORDER BY `unit` DESC [ RunTime:0.001290s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58471640 LIMIT 2 [ RunTime:0.000491s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58471640 ORDER BY `minOrder` ASC [ RunTime:0.000340s ]
select * from pdf where partno='11938MB-B3N-EA-00' and brandshort='NMB Technologies Corporation' limit 1 [ RunTime:0.002392s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '11938MB-B3N-EA-00' OR `brand` LIKE 'NMB Technologies Corporation%' ) ) LIMIT 1 [ RunTime:0.002192s ]
SELECT `id` FROM `stock` WHERE `id` <> 58471640 AND `partno` = '11938MB-B3N-EA-00' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%nmb technologies corporation%' ) [ RunTime:0.005111s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14169296 [ RunTime:0.004673s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58471642 LIMIT 5 [ RunTime:0.000464s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58471642 ORDER BY `minOrder` ASC [ RunTime:0.000537s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58471642 ORDER BY `unit` DESC [ RunTime:0.000459s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58471642 LIMIT 2 [ RunTime:0.000434s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58471642 ORDER BY `minOrder` ASC [ RunTime:0.000373s ]
select * from pdf where partno='11938FB-B3N-EA-00' and brandshort='NMB Technologies Corporation' limit 1 [ RunTime:0.007137s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '11938FB-B3N-EA-00' OR `brand` LIKE 'NMB Technologies Corporation%' ) ) LIMIT 1 [ RunTime:0.000577s ]
SELECT `id` FROM `stock` WHERE `id` <> 58471642 AND `partno` = '11938FB-B3N-EA-00' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%nmb technologies corporation%' ) [ RunTime:0.000550s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16010478 [ RunTime:0.000489s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58471638 LIMIT 5 [ RunTime:0.002936s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58471638 ORDER BY `minOrder` ASC [ RunTime:0.003551s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58471638 ORDER BY `unit` DESC [ RunTime:0.002805s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58471638 LIMIT 2 [ RunTime:0.000755s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58471638 ORDER BY `minOrder` ASC [ RunTime:0.000419s ]
select * from pdf where partno='11938FB-A1N-EA-00' and brandshort='NMB Technologies Corporation' limit 1 [ RunTime:0.004077s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '11938FB-A1N-EA-00' OR `brand` LIKE 'NMB Technologies Corporation%' ) ) LIMIT 1 [ RunTime:0.004761s ]
SELECT `id` FROM `stock` WHERE `id` <> 58471638 AND `partno` = '11938FB-A1N-EA-00' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%nmb technologies corporation%' ) [ RunTime:0.003609s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16010477 [ RunTime:0.002600s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58475238 LIMIT 5 [ RunTime:0.000417s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58475238 ORDER BY `minOrder` ASC [ RunTime:0.000870s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58475238 ORDER BY `unit` DESC [ RunTime:0.000870s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58475238 LIMIT 2 [ RunTime:0.000499s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58475238 ORDER BY `minOrder` ASC [ RunTime:0.000264s ]
select * from pdf where partno='11938KA-24N-EA-00' and brandshort='NMB Technologies Corporation' limit 1 [ RunTime:0.001389s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '11938KA-24N-EA-00' OR `brand` LIKE 'NMB Technologies Corporation%' ) ) LIMIT 1 [ RunTime:0.000494s ]
SELECT `id` FROM `stock` WHERE `id` <> 58475238 AND `partno` = '11938KA-24N-EA-00' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%nmb technologies corporation%' ) [ RunTime:0.001548s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16009304 [ RunTime:0.003193s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58471967 LIMIT 5 [ RunTime:0.006672s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58471967 ORDER BY `minOrder` ASC [ RunTime:0.015543s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58471967 ORDER BY `unit` DESC [ RunTime:0.012027s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58471967 LIMIT 2 [ RunTime:0.003665s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58471967 ORDER BY `minOrder` ASC [ RunTime:0.003154s ]
select * from pdf where partno='11938MB-A1J-EA-00' and brandshort='NMB Technologies Corporation' limit 1 [ RunTime:0.018847s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '11938MB-A1J-EA-00' OR `brand` LIKE 'NMB Technologies Corporation%' ) ) LIMIT 1 [ RunTime:0.003141s ]
SELECT `id` FROM `stock` WHERE `id` <> 58471967 AND `partno` = '11938MB-A1J-EA-00' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%nmb technologies corporation%' ) [ RunTime:0.003593s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18600695 [ RunTime:0.003348s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58471641 LIMIT 5 [ RunTime:0.000387s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58471641 ORDER BY `minOrder` ASC [ RunTime:0.025142s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58471641 ORDER BY `unit` DESC [ RunTime:0.000883s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58471641 LIMIT 2 [ RunTime:0.000315s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58471641 ORDER BY `minOrder` ASC [ RunTime:0.000639s ]
select * from pdf where partno='11938MB-A1N-EA-00' and brandshort='NMB Technologies Corporation' limit 1 [ RunTime:0.001111s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '11938MB-A1N-EA-00' OR `brand` LIKE 'NMB Technologies Corporation%' ) ) LIMIT 1 [ RunTime:0.000779s ]
SELECT `id` FROM `stock` WHERE `id` <> 58471641 AND `partno` = '11938MB-A1N-EA-00' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%nmb technologies corporation%' ) [ RunTime:0.000515s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18599455 [ RunTime:0.000899s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58477024 LIMIT 5 [ RunTime:0.001149s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58477024 ORDER BY `minOrder` ASC [ RunTime:0.002868s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58477024 ORDER BY `unit` DESC [ RunTime:0.003413s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58477024 LIMIT 2 [ RunTime:0.002221s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58477024 ORDER BY `minOrder` ASC [ RunTime:0.002638s ]
select * from pdf where partno='11938KA-24J-EA-00' and brandshort='NMB Technologies Corporation' limit 1 [ RunTime:0.004060s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '11938KA-24J-EA-00' OR `brand` LIKE 'NMB Technologies Corporation%' ) ) LIMIT 1 [ RunTime:0.002700s ]
SELECT `id` FROM `stock` WHERE `id` <> 58477024 AND `partno` = '11938KA-24J-EA-00' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%nmb technologies corporation%' ) [ RunTime:0.001143s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16969090 [ RunTime:0.003450s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58471968 LIMIT 5 [ RunTime:0.004573s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58471968 ORDER BY `minOrder` ASC [ RunTime:0.000424s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58471968 ORDER BY `unit` DESC [ RunTime:0.000354s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58471968 LIMIT 2 [ RunTime:0.001181s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58471968 ORDER BY `minOrder` ASC [ RunTime:0.002421s ]
select * from pdf where partno='11938MB-B3K-EA-00' and brandshort='NMB Technologies Corporation' limit 1 [ RunTime:0.005592s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '11938MB-B3K-EA-00' OR `brand` LIKE 'NMB Technologies Corporation%' ) ) LIMIT 1 [ RunTime:0.001470s ]
SELECT `id` FROM `stock` WHERE `id` <> 58471968 AND `partno` = '11938MB-B3K-EA-00' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%nmb technologies corporation%' ) [ RunTime:0.000963s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18599492 [ RunTime:0.000922s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58471636 LIMIT 5 [ RunTime:0.001054s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58471636 ORDER BY `minOrder` ASC [ RunTime:0.000836s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58471636 ORDER BY `unit` DESC [ RunTime:0.000427s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58471636 LIMIT 2 [ RunTime:0.000630s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58471636 ORDER BY `minOrder` ASC [ RunTime:0.002806s ]
select * from pdf where partno='11938MB-A1K-EA-00' and brandshort='NMB Technologies Corporation' limit 1 [ RunTime:0.001377s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '11938MB-A1K-EA-00' OR `brand` LIKE 'NMB Technologies Corporation%' ) ) LIMIT 1 [ RunTime:0.002604s ]
SELECT `id` FROM `stock` WHERE `id` <> 58471636 AND `partno` = '11938MB-A1K-EA-00' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%nmb technologies corporation%' ) [ RunTime:0.002754s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18599700 [ RunTime:0.002568s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58477025 LIMIT 5 [ RunTime:0.003171s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58477025 ORDER BY `minOrder` ASC [ RunTime:0.016914s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58477025 ORDER BY `unit` DESC [ RunTime:0.001831s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58477025 LIMIT 2 [ RunTime:0.006314s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58477025 ORDER BY `minOrder` ASC [ RunTime:0.003931s ]
select * from pdf where partno='11938KA-12M-EA-00' and brandshort='NMB Technologies Corporation' limit 1 [ RunTime:0.001084s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '11938KA-12M-EA-00' OR `brand` LIKE 'NMB Technologies Corporation%' ) ) LIMIT 1 [ RunTime:0.004131s ]
SELECT `id` FROM `stock` WHERE `id` <> 58477025 AND `partno` = '11938KA-12M-EA-00' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%nmb technologies corporation%' ) [ RunTime:0.000763s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16006259 [ RunTime:0.000569s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58477031 LIMIT 5 [ RunTime:0.000520s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58477031 ORDER BY `minOrder` ASC [ RunTime:0.000596s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58477031 ORDER BY `unit` DESC [ RunTime:0.008322s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58477031 LIMIT 2 [ RunTime:0.001832s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58477031 ORDER BY `minOrder` ASC [ RunTime:0.000535s ]
select * from pdf where partno='11938KA-24N-EL-00' and brandshort='NMB Technologies Corporation' limit 1 [ RunTime:0.000802s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '11938KA-24N-EL-00' OR `brand` LIKE 'NMB Technologies Corporation%' ) ) LIMIT 1 [ RunTime:0.002476s ]
SELECT `id` FROM `stock` WHERE `id` <> 58477031 AND `partno` = '11938KA-24N-EL-00' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%nmb technologies corporation%' ) [ RunTime:0.004279s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18595843 [ RunTime:0.000820s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58471783 LIMIT 5 [ RunTime:0.000507s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58471783 ORDER BY `minOrder` ASC [ RunTime:0.005383s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58471783 ORDER BY `unit` DESC [ RunTime:0.000563s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58471783 LIMIT 2 [ RunTime:0.000483s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58471783 ORDER BY `minOrder` ASC [ RunTime:0.000316s ]
select * from pdf where partno='11938MB-A1L-EA-00' and brandshort='NMB Technologies Corporation' limit 1 [ RunTime:0.001174s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '11938MB-A1L-EA-00' OR `brand` LIKE 'NMB Technologies Corporation%' ) ) LIMIT 1 [ RunTime:0.002862s ]
SELECT `id` FROM `stock` WHERE `id` <> 58471783 AND `partno` = '11938MB-A1L-EA-00' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%nmb technologies corporation%' ) [ RunTime:0.003587s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18600588 [ RunTime:0.013491s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58476097 LIMIT 5 [ RunTime:0.000707s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58476097 ORDER BY `minOrder` ASC [ RunTime:0.007948s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58476097 ORDER BY `unit` DESC [ RunTime:0.000688s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58476097 LIMIT 2 [ RunTime:0.000891s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58476097 ORDER BY `minOrder` ASC [ RunTime:0.000630s ]
select * from pdf where partno='11938KA-12L-EA-00' and brandshort='NMB Technologies Corporation' limit 1 [ RunTime:0.001313s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '11938KA-12L-EA-00' OR `brand` LIKE 'NMB Technologies Corporation%' ) ) LIMIT 1 [ RunTime:0.004209s ]
SELECT `id` FROM `stock` WHERE `id` <> 58476097 AND `partno` = '11938KA-12L-EA-00' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%nmb technologies corporation%' ) [ RunTime:0.001525s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16009081 [ RunTime:0.001088s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58478036 LIMIT 5 [ RunTime:0.000652s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58478036 ORDER BY `minOrder` ASC [ RunTime:0.001157s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58478036 ORDER BY `unit` DESC [ RunTime:0.001041s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58478036 LIMIT 2 [ RunTime:0.000688s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58478036 ORDER BY `minOrder` ASC [ RunTime:0.000448s ]
select * from pdf where partno='11938KA-12K-EA-00' and brandshort='NMB Technologies Corporation' limit 1 [ RunTime:0.001225s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '11938KA-12K-EA-00' OR `brand` LIKE 'NMB Technologies Corporation%' ) ) LIMIT 1 [ RunTime:0.004646s ]
SELECT `id` FROM `stock` WHERE `id` <> 58478036 AND `partno` = '11938KA-12K-EA-00' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%nmb technologies corporation%' ) [ RunTime:0.006232s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18596319 [ RunTime:0.002473s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58471784 LIMIT 5 [ RunTime:0.000730s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58471784 ORDER BY `minOrder` ASC [ RunTime:0.000768s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58471784 ORDER BY `unit` DESC [ RunTime:0.000669s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58471784 LIMIT 2 [ RunTime:0.004118s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58471784 ORDER BY `minOrder` ASC [ RunTime:0.000468s ]
select * from pdf where partno='11938MB-A1N-AA-00' and brandshort='NMB Technologies Corporation' limit 1 [ RunTime:0.004187s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '11938MB-A1N-AA-00' OR `brand` LIKE 'NMB Technologies Corporation%' ) ) LIMIT 1 [ RunTime:0.000931s ]
SELECT `id` FROM `stock` WHERE `id` <> 58471784 AND `partno` = '11938MB-A1N-AA-00' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%nmb technologies corporation%' ) [ RunTime:0.000879s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18600727 [ RunTime:0.000688s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58471782 LIMIT 5 [ RunTime:0.003913s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58471782 ORDER BY `minOrder` ASC [ RunTime:0.000995s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58471782 ORDER BY `unit` DESC [ RunTime:0.002566s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58471782 LIMIT 2 [ RunTime:0.001735s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58471782 ORDER BY `minOrder` ASC [ RunTime:0.000476s ]
select * from pdf where partno='11938MB-B3J-EA-00' and brandshort='NMB Technologies Corporation' limit 1 [ RunTime:0.002201s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '11938MB-B3J-EA-00' OR `brand` LIKE 'NMB Technologies Corporation%' ) ) LIMIT 1 [ RunTime:0.000937s ]
SELECT `id` FROM `stock` WHERE `id` <> 58471782 AND `partno` = '11938MB-B3J-EA-00' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%nmb technologies corporation%' ) [ RunTime:0.000881s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15183531 [ RunTime:0.011131s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58476348 LIMIT 5 [ RunTime:0.002022s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58476348 ORDER BY `minOrder` ASC [ RunTime:0.006925s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58476348 ORDER BY `unit` DESC [ RunTime:0.005339s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58476348 LIMIT 2 [ RunTime:0.005520s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58476348 ORDER BY `minOrder` ASC [ RunTime:0.000339s ]
select * from pdf where partno='11938ME-24P-GA-00' and brandshort='NMB Technologies Corporation' limit 1 [ RunTime:0.000489s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '11938ME-24P-GA-00' OR `brand` LIKE 'NMB Technologies Corporation%' ) ) LIMIT 1 [ RunTime:0.003485s ]
SELECT `id` FROM `stock` WHERE `id` <> 58476348 AND `partno` = '11938ME-24P-GA-00' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%nmb technologies corporation%' ) [ RunTime:0.012856s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16007023 [ RunTime:0.002505s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58476099 LIMIT 5 [ RunTime:0.000591s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58476099 ORDER BY `minOrder` ASC [ RunTime:0.000622s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58476099 ORDER BY `unit` DESC [ RunTime:0.007856s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58476099 LIMIT 2 [ RunTime:0.003170s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58476099 ORDER BY `minOrder` ASC [ RunTime:0.000326s ]
select * from pdf where partno='11938KA-48L-EA-00' and brandshort='NMB Technologies Corporation' limit 1 [ RunTime:0.002031s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '11938KA-48L-EA-00' OR `brand` LIKE 'NMB Technologies Corporation%' ) ) LIMIT 1 [ RunTime:0.000730s ]
SELECT `id` FROM `stock` WHERE `id` <> 58476099 AND `partno` = '11938KA-48L-EA-00' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%nmb technologies corporation%' ) [ RunTime:0.001725s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15182370 [ RunTime:0.001004s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58477026 LIMIT 5 [ RunTime:0.001333s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58477026 ORDER BY `minOrder` ASC [ RunTime:0.014725s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58477026 ORDER BY `unit` DESC [ RunTime:0.003362s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58477026 LIMIT 2 [ RunTime:0.000796s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58477026 ORDER BY `minOrder` ASC [ RunTime:0.000334s ]
select * from pdf where partno='11938KA-24K-EA-00' and brandshort='NMB Technologies Corporation' limit 1 [ RunTime:0.001796s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '11938KA-24K-EA-00' OR `brand` LIKE 'NMB Technologies Corporation%' ) ) LIMIT 1 [ RunTime:0.005397s ]
SELECT `id` FROM `stock` WHERE `id` <> 58477026 AND `partno` = '11938KA-24K-EA-00' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%nmb technologies corporation%' ) [ RunTime:0.007590s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18597404 [ RunTime:0.001158s ]
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 '11938%' OR `brand` LIKE '11938%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007926s ]
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 '11938%' OR `brand` LIKE '11938%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003826s ]
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 '11938%' OR `brand` LIKE '11938%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001100s ]
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 '11938%' OR `brand` LIKE '11938%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000985s ]
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 '11938%' OR `brand` LIKE '11938%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011090s ]
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 '11938%' OR `brand` LIKE '11938%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002060s ]
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 '11938%' OR `brand` LIKE '11938%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001320s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '11938%' OR `brand` LIKE '11938%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.004642s ]