SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002796s ]
INSERT INTO `visit_log` SET `ip` = '216.73.217.103' , `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=10627&search=1' [ RunTime:0.001962s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001526s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000721s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002700s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.103' ) [ RunTime:0.000420s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001593s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000329s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001553s ]
SELECT * FROM `stock_search` WHERE `partno` = '10627' LIMIT 1 [ RunTime:0.003000s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-08-13 13:10:14' WHERE `partno` = '10627' [ RunTime:0.010338s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002635s ]
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 '10627%' OR `brand` LIKE '10627%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.036415s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001302s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19577496 LIMIT 5 [ RunTime:0.013197s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001235s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19577496 ORDER BY `minOrder` ASC [ RunTime:0.015237s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.005185s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19577496 ORDER BY `unit` DESC [ RunTime:0.026202s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.007653s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19577496 LIMIT 2 [ RunTime:0.011612s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19577496 ORDER BY `minOrder` ASC [ RunTime:0.036774s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19602324 LIMIT 5 [ RunTime:0.035007s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19602324 ORDER BY `minOrder` ASC [ RunTime:0.059814s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19602324 ORDER BY `unit` DESC [ RunTime:0.005704s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19602324 LIMIT 2 [ RunTime:0.002844s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19602324 ORDER BY `minOrder` ASC [ RunTime:0.002841s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19602323 LIMIT 5 [ RunTime:0.002780s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19602323 ORDER BY `minOrder` ASC [ RunTime:0.021457s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19602323 ORDER BY `unit` DESC [ RunTime:0.004517s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19602323 LIMIT 2 [ RunTime:0.022196s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19602323 ORDER BY `minOrder` ASC [ RunTime:0.023953s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19577120 LIMIT 5 [ RunTime:0.021007s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19577120 ORDER BY `minOrder` ASC [ RunTime:0.034233s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19577120 ORDER BY `unit` DESC [ RunTime:0.023143s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19577120 LIMIT 2 [ RunTime:0.007769s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19577120 ORDER BY `minOrder` ASC [ RunTime:0.015808s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18982789 LIMIT 5 [ RunTime:0.011582s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18982789 ORDER BY `minOrder` ASC [ RunTime:0.024185s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18982789 ORDER BY `unit` DESC [ RunTime:0.015584s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18982789 LIMIT 2 [ RunTime:0.027095s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18982789 ORDER BY `minOrder` ASC [ RunTime:0.026020s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18981089 LIMIT 5 [ RunTime:0.039030s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18981089 ORDER BY `minOrder` ASC [ RunTime:0.012860s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18981089 ORDER BY `unit` DESC [ RunTime:0.020924s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18981089 LIMIT 2 [ RunTime:0.007418s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18981089 ORDER BY `minOrder` ASC [ RunTime:0.016418s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18980961 LIMIT 5 [ RunTime:0.014576s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18980961 ORDER BY `minOrder` ASC [ RunTime:0.024816s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18980961 ORDER BY `unit` DESC [ RunTime:0.008233s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18980961 LIMIT 2 [ RunTime:0.010540s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18980961 ORDER BY `minOrder` ASC [ RunTime:0.012411s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18980605 LIMIT 5 [ RunTime:0.012751s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18980605 ORDER BY `minOrder` ASC [ RunTime:0.019135s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18980605 ORDER BY `unit` DESC [ RunTime:0.005472s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18980605 LIMIT 2 [ RunTime:0.000677s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18980605 ORDER BY `minOrder` ASC [ RunTime:0.000412s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18980476 LIMIT 5 [ RunTime:0.003274s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18980476 ORDER BY `minOrder` ASC [ RunTime:0.015869s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18980476 ORDER BY `unit` DESC [ RunTime:0.006003s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18980476 LIMIT 2 [ RunTime:0.002895s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18980476 ORDER BY `minOrder` ASC [ RunTime:0.008655s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18979019 LIMIT 5 [ RunTime:0.003671s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18979019 ORDER BY `minOrder` ASC [ RunTime:0.001918s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18979019 ORDER BY `unit` DESC [ RunTime:0.001853s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18979019 LIMIT 2 [ RunTime:0.002527s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18979019 ORDER BY `minOrder` ASC [ RunTime:0.000929s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18932409 LIMIT 5 [ RunTime:0.001687s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18932409 ORDER BY `minOrder` ASC [ RunTime:0.002568s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18932409 ORDER BY `unit` DESC [ RunTime:0.012119s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18932409 LIMIT 2 [ RunTime:0.009558s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18932409 ORDER BY `minOrder` ASC [ RunTime:0.014134s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18777261 LIMIT 5 [ RunTime:0.003850s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18777261 ORDER BY `minOrder` ASC [ RunTime:0.002526s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18777261 ORDER BY `unit` DESC [ RunTime:0.006427s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18777261 LIMIT 2 [ RunTime:0.008662s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18777261 ORDER BY `minOrder` ASC [ RunTime:0.000321s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18776915 LIMIT 5 [ RunTime:0.004526s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18776915 ORDER BY `minOrder` ASC [ RunTime:0.008031s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18776915 ORDER BY `unit` DESC [ RunTime:0.006567s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18776915 LIMIT 2 [ RunTime:0.000374s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18776915 ORDER BY `minOrder` ASC [ RunTime:0.001101s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18775277 LIMIT 5 [ RunTime:0.011079s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18775277 ORDER BY `minOrder` ASC [ RunTime:0.008145s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18775277 ORDER BY `unit` DESC [ RunTime:0.006283s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18775277 LIMIT 2 [ RunTime:0.022923s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18775277 ORDER BY `minOrder` ASC [ RunTime:0.005069s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18774504 LIMIT 5 [ RunTime:0.001093s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18774504 ORDER BY `minOrder` ASC [ RunTime:0.005974s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18774504 ORDER BY `unit` DESC [ RunTime:0.011351s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18774504 LIMIT 2 [ RunTime:0.002621s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18774504 ORDER BY `minOrder` ASC [ RunTime:0.009594s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18774444 LIMIT 5 [ RunTime:0.007627s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18774444 ORDER BY `minOrder` ASC [ RunTime:0.007176s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18774444 ORDER BY `unit` DESC [ RunTime:0.028914s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18774444 LIMIT 2 [ RunTime:0.048834s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18774444 ORDER BY `minOrder` ASC [ RunTime:0.014576s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18773381 LIMIT 5 [ RunTime:0.006075s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18773381 ORDER BY `minOrder` ASC [ RunTime:0.004249s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18773381 ORDER BY `unit` DESC [ RunTime:0.009383s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18773381 LIMIT 2 [ RunTime:0.001373s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18773381 ORDER BY `minOrder` ASC [ RunTime:0.005924s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18772964 LIMIT 5 [ RunTime:0.005074s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18772964 ORDER BY `minOrder` ASC [ RunTime:0.000863s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18772964 ORDER BY `unit` DESC [ RunTime:0.004695s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18772964 LIMIT 2 [ RunTime:0.007459s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18772964 ORDER BY `minOrder` ASC [ RunTime:0.000403s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18772205 LIMIT 5 [ RunTime:0.002669s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18772205 ORDER BY `minOrder` ASC [ RunTime:0.000688s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18772205 ORDER BY `unit` DESC [ RunTime:0.012631s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18772205 LIMIT 2 [ RunTime:0.008477s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18772205 ORDER BY `minOrder` ASC [ RunTime:0.010802s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18771916 LIMIT 5 [ RunTime:0.008061s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18771916 ORDER BY `minOrder` ASC [ RunTime:0.007429s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18771916 ORDER BY `unit` DESC [ RunTime:0.008881s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18771916 LIMIT 2 [ RunTime:0.016013s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18771916 ORDER BY `minOrder` ASC [ RunTime:0.002918s ]
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 '10627%' OR `brand` LIKE '10627%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004699s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32270198 LIMIT 5 [ RunTime:0.007257s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32270198 ORDER BY `minOrder` ASC [ RunTime:0.003034s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32270198 ORDER BY `unit` DESC [ RunTime:0.001101s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32270198 LIMIT 2 [ RunTime:0.002327s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32270198 ORDER BY `minOrder` ASC [ RunTime:0.000356s ]
select * from pdf where partno='106276-4' and brandshort='te connectivity / amp' limit 1 [ RunTime:0.001278s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001931s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '106276-4' OR `brand` LIKE 'te connectivity / amp%' ) ) LIMIT 1 [ RunTime:0.007569s ]
SELECT `id` FROM `stock` WHERE `id` <> 32270198 AND `partno` = '106276-4' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity / amp%' ) [ RunTime:0.003232s ]
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 '10627%' OR `brand` LIKE '10627%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010201s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59351761 LIMIT 5 [ RunTime:0.002448s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59351761 ORDER BY `minOrder` ASC [ RunTime:0.008632s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59351761 ORDER BY `unit` DESC [ RunTime:0.006258s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59351761 LIMIT 2 [ RunTime:0.001026s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59351761 ORDER BY `minOrder` ASC [ RunTime:0.000357s ]
select * from pdf where partno='106276-4' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.004334s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '106276-4' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.002831s ]
SELECT `id` FROM `stock` WHERE `id` <> 59351761 AND `partno` = '106276-4' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.007157s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19577496 [ RunTime:0.004002s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60630115 LIMIT 5 [ RunTime:0.012986s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60630115 ORDER BY `minOrder` ASC [ RunTime:0.020505s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60630115 ORDER BY `unit` DESC [ RunTime:0.014542s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60630115 LIMIT 2 [ RunTime:0.003858s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60630115 ORDER BY `minOrder` ASC [ RunTime:0.000473s ]
select * from pdf where partno='1062720000' and brandshort='Weidmüller' limit 1 [ RunTime:0.000974s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1062720000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.035304s ]
SELECT `id` FROM `stock` WHERE `id` <> 60630115 AND `partno` = '1062720000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.010827s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63334850 LIMIT 5 [ RunTime:0.013382s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63334850 ORDER BY `minOrder` ASC [ RunTime:0.023875s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63334850 ORDER BY `unit` DESC [ RunTime:0.039143s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63334850 LIMIT 2 [ RunTime:0.012651s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63334850 ORDER BY `minOrder` ASC [ RunTime:0.005213s ]
select * from pdf where partno='1062753' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.012063s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1062753' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.012419s ]
SELECT `id` FROM `stock` WHERE `id` <> 63334850 AND `partno` = '1062753' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.037504s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64808409 LIMIT 5 [ RunTime:0.031791s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64808409 ORDER BY `minOrder` ASC [ RunTime:0.015712s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64808409 ORDER BY `unit` DESC [ RunTime:0.016100s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64808409 LIMIT 2 [ RunTime:0.005887s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64808409 ORDER BY `minOrder` ASC [ RunTime:0.005063s ]
select * from pdf where partno='1062733' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.018104s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1062733' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.032624s ]
SELECT `id` FROM `stock` WHERE `id` <> 64808409 AND `partno` = '1062733' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.032655s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17010954 [ RunTime:0.014846s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64807798 LIMIT 5 [ RunTime:0.010165s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64807798 ORDER BY `minOrder` ASC [ RunTime:0.018120s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64807798 ORDER BY `unit` DESC [ RunTime:0.013708s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64807798 LIMIT 2 [ RunTime:0.012591s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64807798 ORDER BY `minOrder` ASC [ RunTime:0.010384s ]
select * from pdf where partno='1062734' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.015025s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1062734' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.005016s ]
SELECT `id` FROM `stock` WHERE `id` <> 64807798 AND `partno` = '1062734' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.015974s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18775277 [ RunTime:0.015016s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64806713 LIMIT 5 [ RunTime:0.011949s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64806713 ORDER BY `minOrder` ASC [ RunTime:0.025245s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64806713 ORDER BY `unit` DESC [ RunTime:0.004426s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64806713 LIMIT 2 [ RunTime:0.000653s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64806713 ORDER BY `minOrder` ASC [ RunTime:0.002184s ]
select * from pdf where partno='1062768' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.012299s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1062768' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.018645s ]
SELECT `id` FROM `stock` WHERE `id` <> 64806713 AND `partno` = '1062768' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.017217s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18774504 [ RunTime:0.007479s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64806567 LIMIT 5 [ RunTime:0.004230s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64806567 ORDER BY `minOrder` ASC [ RunTime:0.000864s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64806567 ORDER BY `unit` DESC [ RunTime:0.001791s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64806567 LIMIT 2 [ RunTime:0.007262s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64806567 ORDER BY `minOrder` ASC [ RunTime:0.007437s ]
select * from pdf where partno='1062711' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.009902s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1062711' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.003606s ]
SELECT `id` FROM `stock` WHERE `id` <> 64806567 AND `partno` = '1062711' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.002006s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18774444 [ RunTime:0.003762s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64806280 LIMIT 5 [ RunTime:0.000996s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64806280 ORDER BY `minOrder` ASC [ RunTime:0.006376s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64806280 ORDER BY `unit` DESC [ RunTime:0.000780s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64806280 LIMIT 2 [ RunTime:0.003635s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64806280 ORDER BY `minOrder` ASC [ RunTime:0.008572s ]
select * from pdf where partno='1062736' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.004168s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1062736' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.011812s ]
SELECT `id` FROM `stock` WHERE `id` <> 64806280 AND `partno` = '1062736' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.016299s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18982789 [ RunTime:0.008969s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64805954 LIMIT 5 [ RunTime:0.007857s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64805954 ORDER BY `minOrder` ASC [ RunTime:0.034119s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64805954 ORDER BY `unit` DESC [ RunTime:0.018117s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64805954 LIMIT 2 [ RunTime:0.095632s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64805954 ORDER BY `minOrder` ASC [ RunTime:0.008287s ]
select * from pdf where partno='1062741' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.005506s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1062741' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.022630s ]
SELECT `id` FROM `stock` WHERE `id` <> 64805954 AND `partno` = '1062741' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.012287s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15223742 [ RunTime:0.014032s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64805774 LIMIT 5 [ RunTime:0.014797s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64805774 ORDER BY `minOrder` ASC [ RunTime:0.005942s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64805774 ORDER BY `unit` DESC [ RunTime:0.002197s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64805774 LIMIT 2 [ RunTime:0.007648s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64805774 ORDER BY `minOrder` ASC [ RunTime:0.006886s ]
select * from pdf where partno='1062739' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.030351s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1062739' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.020643s ]
SELECT `id` FROM `stock` WHERE `id` <> 64805774 AND `partno` = '1062739' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.004500s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14196916 [ RunTime:0.010300s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64805039 LIMIT 5 [ RunTime:0.029432s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64805039 ORDER BY `minOrder` ASC [ RunTime:0.038826s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64805039 ORDER BY `unit` DESC [ RunTime:0.030528s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64805039 LIMIT 2 [ RunTime:0.021701s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64805039 ORDER BY `minOrder` ASC [ RunTime:0.002585s ]
select * from pdf where partno='1062737' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.025969s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1062737' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.008150s ]
SELECT `id` FROM `stock` WHERE `id` <> 64805039 AND `partno` = '1062737' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.008978s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18981089 [ RunTime:0.015887s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64804495 LIMIT 5 [ RunTime:0.019105s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64804495 ORDER BY `minOrder` ASC [ RunTime:0.015823s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64804495 ORDER BY `unit` DESC [ RunTime:0.018836s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64804495 LIMIT 2 [ RunTime:0.024896s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64804495 ORDER BY `minOrder` ASC [ RunTime:0.002811s ]
select * from pdf where partno='1062740' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.013918s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1062740' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.033435s ]
SELECT `id` FROM `stock` WHERE `id` <> 64804495 AND `partno` = '1062740' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.057845s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18773381 [ RunTime:0.026554s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64803884 LIMIT 5 [ RunTime:0.011316s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64803884 ORDER BY `minOrder` ASC [ RunTime:0.011145s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64803884 ORDER BY `unit` DESC [ RunTime:0.012551s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64803884 LIMIT 2 [ RunTime:0.016606s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64803884 ORDER BY `minOrder` ASC [ RunTime:0.003644s ]
select * from pdf where partno='1062742' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.009191s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1062742' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.002791s ]
SELECT `id` FROM `stock` WHERE `id` <> 64803884 AND `partno` = '1062742' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.004435s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18980961 [ RunTime:0.000701s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64803760 LIMIT 5 [ RunTime:0.010529s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64803760 ORDER BY `minOrder` ASC [ RunTime:0.011563s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64803760 ORDER BY `unit` DESC [ RunTime:0.003327s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64803760 LIMIT 2 [ RunTime:0.001494s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64803760 ORDER BY `minOrder` ASC [ RunTime:0.001150s ]
select * from pdf where partno='1062796' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.008798s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1062796' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.002622s ]
SELECT `id` FROM `stock` WHERE `id` <> 64803760 AND `partno` = '1062796' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.006165s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18980605 [ RunTime:0.001692s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64803742 LIMIT 5 [ RunTime:0.001425s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64803742 ORDER BY `minOrder` ASC [ RunTime:0.000702s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64803742 ORDER BY `unit` DESC [ RunTime:0.008642s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64803742 LIMIT 2 [ RunTime:0.002129s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64803742 ORDER BY `minOrder` ASC [ RunTime:0.000450s ]
select * from pdf where partno='1062797' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.001045s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1062797' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.003675s ]
SELECT `id` FROM `stock` WHERE `id` <> 64803742 AND `partno` = '1062797' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.001780s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18772964 [ RunTime:0.000739s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64802603 LIMIT 5 [ RunTime:0.007805s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64802603 ORDER BY `minOrder` ASC [ RunTime:0.003072s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64802603 ORDER BY `unit` DESC [ RunTime:0.004366s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64802603 LIMIT 2 [ RunTime:0.000605s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64802603 ORDER BY `minOrder` ASC [ RunTime:0.008805s ]
select * from pdf where partno='1062712' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.001063s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1062712' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.010246s ]
SELECT `id` FROM `stock` WHERE `id` <> 64802603 AND `partno` = '1062712' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.020405s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18772205 [ RunTime:0.001850s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64802494 LIMIT 5 [ RunTime:0.017190s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64802494 ORDER BY `minOrder` ASC [ RunTime:0.004210s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64802494 ORDER BY `unit` DESC [ RunTime:0.007540s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64802494 LIMIT 2 [ RunTime:0.009300s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64802494 ORDER BY `minOrder` ASC [ RunTime:0.012094s ]
select * from pdf where partno='1062713' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.009618s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1062713' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.004381s ]
SELECT `id` FROM `stock` WHERE `id` <> 64802494 AND `partno` = '1062713' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.013859s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18980476 [ RunTime:0.011255s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64802011 LIMIT 5 [ RunTime:0.004587s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64802011 ORDER BY `minOrder` ASC [ RunTime:0.009315s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64802011 ORDER BY `unit` DESC [ RunTime:0.008352s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64802011 LIMIT 2 [ RunTime:0.005057s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64802011 ORDER BY `minOrder` ASC [ RunTime:0.003334s ]
select * from pdf where partno='1062779' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.010964s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1062779' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.006826s ]
SELECT `id` FROM `stock` WHERE `id` <> 64802011 AND `partno` = '1062779' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.005828s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18771916 [ RunTime:0.001671s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64801895 LIMIT 5 [ RunTime:0.000694s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64801895 ORDER BY `minOrder` ASC [ RunTime:0.011536s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64801895 ORDER BY `unit` DESC [ RunTime:0.023975s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64801895 LIMIT 2 [ RunTime:0.018541s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64801895 ORDER BY `minOrder` ASC [ RunTime:0.014838s ]
select * from pdf where partno='1062780' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.002531s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1062780' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.016423s ]
SELECT `id` FROM `stock` WHERE `id` <> 64801895 AND `partno` = '1062780' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.030805s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18771841 [ RunTime:0.012298s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64801545 LIMIT 5 [ RunTime:0.001219s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64801545 ORDER BY `minOrder` ASC [ RunTime:0.012895s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64801545 ORDER BY `unit` DESC [ RunTime:0.018142s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64801545 LIMIT 2 [ RunTime:0.005090s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64801545 ORDER BY `minOrder` ASC [ RunTime:0.002506s ]
select * from pdf where partno='1062738' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.005199s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1062738' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.006699s ]
SELECT `id` FROM `stock` WHERE `id` <> 64801545 AND `partno` = '1062738' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.001716s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17010331 [ RunTime:0.025230s ]
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 '10627%' OR `brand` LIKE '10627%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006417s ]
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 '10627%' OR `brand` LIKE '10627%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005308s ]
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 '10627%' OR `brand` LIKE '10627%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004274s ]
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 '10627%' OR `brand` LIKE '10627%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001610s ]
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 '10627%' OR `brand` LIKE '10627%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001218s ]
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 '10627%' OR `brand` LIKE '10627%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005971s ]
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 '10627%' OR `brand` LIKE '10627%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004772s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '10627%' OR `brand` LIKE '10627%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.007448s ]