SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002209s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.254' , `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=12132&search=1' [ RunTime:0.007324s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.003811s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000591s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002375s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.254' ) [ RunTime:0.000355s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001886s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.001673s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002179s ]
SELECT * FROM `stock_search` WHERE `partno` = '12132' LIMIT 1 [ RunTime:0.011649s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-08-04 14:21:49' WHERE `partno` = '12132' [ RunTime:0.022253s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001349s ]
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 '12132%' OR `brand` LIKE '12132%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011990s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001348s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16012659 LIMIT 5 [ RunTime:0.002568s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001100s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16012659 ORDER BY `minOrder` ASC [ RunTime:0.001073s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002044s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16012659 ORDER BY `unit` DESC [ RunTime:0.000542s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.003848s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16012659 LIMIT 2 [ RunTime:0.000314s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16012659 ORDER BY `minOrder` ASC [ RunTime:0.002299s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18835331 LIMIT 5 [ RunTime:0.002388s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18835331 ORDER BY `minOrder` ASC [ RunTime:0.005604s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18835331 ORDER BY `unit` DESC [ RunTime:0.009854s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18835331 LIMIT 2 [ RunTime:0.002416s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18835331 ORDER BY `minOrder` ASC [ RunTime:0.003947s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18835328 LIMIT 5 [ RunTime:0.000838s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18835328 ORDER BY `minOrder` ASC [ RunTime:0.000473s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18835328 ORDER BY `unit` DESC [ RunTime:0.000363s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18835328 LIMIT 2 [ RunTime:0.000305s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18835328 ORDER BY `minOrder` ASC [ RunTime:0.000209s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17020924 LIMIT 5 [ RunTime:0.000692s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17020924 ORDER BY `minOrder` ASC [ RunTime:0.016501s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17020924 ORDER BY `unit` DESC [ RunTime:0.024765s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17020924 LIMIT 2 [ RunTime:0.010424s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17020924 ORDER BY `minOrder` ASC [ RunTime:0.003269s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18835348 LIMIT 5 [ RunTime:0.013653s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18835348 ORDER BY `minOrder` ASC [ RunTime:0.008664s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18835348 ORDER BY `unit` DESC [ RunTime:0.025981s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18835348 LIMIT 2 [ RunTime:0.010257s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18835348 ORDER BY `minOrder` ASC [ RunTime:0.008118s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18835340 LIMIT 5 [ RunTime:0.015839s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18835340 ORDER BY `minOrder` ASC [ RunTime:0.031413s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18835340 ORDER BY `unit` DESC [ RunTime:0.015261s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18835340 LIMIT 2 [ RunTime:0.012998s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18835340 ORDER BY `minOrder` ASC [ RunTime:0.010784s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18835333 LIMIT 5 [ RunTime:0.006986s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18835333 ORDER BY `minOrder` ASC [ RunTime:0.026130s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18835333 ORDER BY `unit` DESC [ RunTime:0.018263s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18835333 LIMIT 2 [ RunTime:0.011780s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18835333 ORDER BY `minOrder` ASC [ RunTime:0.001112s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16012661 LIMIT 5 [ RunTime:0.006113s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16012661 ORDER BY `minOrder` ASC [ RunTime:0.017811s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16012661 ORDER BY `unit` DESC [ RunTime:0.003496s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16012661 LIMIT 2 [ RunTime:0.001175s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16012661 ORDER BY `minOrder` ASC [ RunTime:0.003664s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18837369 LIMIT 5 [ RunTime:0.007429s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18837369 ORDER BY `minOrder` ASC [ RunTime:0.009640s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18837369 ORDER BY `unit` DESC [ RunTime:0.001740s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18837369 LIMIT 2 [ RunTime:0.005013s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18837369 ORDER BY `minOrder` ASC [ RunTime:0.006283s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18837368 LIMIT 5 [ RunTime:0.007726s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18837368 ORDER BY `minOrder` ASC [ RunTime:0.005500s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18837368 ORDER BY `unit` DESC [ RunTime:0.004236s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18837368 LIMIT 2 [ RunTime:0.002855s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18837368 ORDER BY `minOrder` ASC [ RunTime:0.005131s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18837365 LIMIT 5 [ RunTime:0.016409s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18837365 ORDER BY `minOrder` ASC [ RunTime:0.020567s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18837365 ORDER BY `unit` DESC [ RunTime:0.009006s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18837365 LIMIT 2 [ RunTime:0.003611s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18837365 ORDER BY `minOrder` ASC [ RunTime:0.006511s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18837364 LIMIT 5 [ RunTime:0.011087s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18837364 ORDER BY `minOrder` ASC [ RunTime:0.017917s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18837364 ORDER BY `unit` DESC [ RunTime:0.020771s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18837364 LIMIT 2 [ RunTime:0.017215s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18837364 ORDER BY `minOrder` ASC [ RunTime:0.006468s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18837362 LIMIT 5 [ RunTime:0.006101s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18837362 ORDER BY `minOrder` ASC [ RunTime:0.015881s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18837362 ORDER BY `unit` DESC [ RunTime:0.000579s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18837362 LIMIT 2 [ RunTime:0.012122s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18837362 ORDER BY `minOrder` ASC [ RunTime:0.000392s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18837358 LIMIT 5 [ RunTime:0.002391s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18837358 ORDER BY `minOrder` ASC [ RunTime:0.004005s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18837358 ORDER BY `unit` DESC [ RunTime:0.009167s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18837358 LIMIT 2 [ RunTime:0.002538s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18837358 ORDER BY `minOrder` ASC [ RunTime:0.001954s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18837355 LIMIT 5 [ RunTime:0.000673s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18837355 ORDER BY `minOrder` ASC [ RunTime:0.002846s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18837355 ORDER BY `unit` DESC [ RunTime:0.002283s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18837355 LIMIT 2 [ RunTime:0.017504s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18837355 ORDER BY `minOrder` ASC [ RunTime:0.014431s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18837354 LIMIT 5 [ RunTime:0.009893s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18837354 ORDER BY `minOrder` ASC [ RunTime:0.010052s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18837354 ORDER BY `unit` DESC [ RunTime:0.006422s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18837354 LIMIT 2 [ RunTime:0.000564s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18837354 ORDER BY `minOrder` ASC [ RunTime:0.001457s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17021533 LIMIT 5 [ RunTime:0.004884s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17021533 ORDER BY `minOrder` ASC [ RunTime:0.003463s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17021533 ORDER BY `unit` DESC [ RunTime:0.003297s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17021533 LIMIT 2 [ RunTime:0.002324s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17021533 ORDER BY `minOrder` ASC [ RunTime:0.007981s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16013772 LIMIT 5 [ RunTime:0.006313s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16013772 ORDER BY `minOrder` ASC [ RunTime:0.009103s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16013772 ORDER BY `unit` DESC [ RunTime:0.021553s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16013772 LIMIT 2 [ RunTime:0.013173s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16013772 ORDER BY `minOrder` ASC [ RunTime:0.002166s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16013768 LIMIT 5 [ RunTime:0.003829s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16013768 ORDER BY `minOrder` ASC [ RunTime:0.005414s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16013768 ORDER BY `unit` DESC [ RunTime:0.001856s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16013768 LIMIT 2 [ RunTime:0.000752s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16013768 ORDER BY `minOrder` ASC [ RunTime:0.000453s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18835975 LIMIT 5 [ RunTime:0.005343s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18835975 ORDER BY `minOrder` ASC [ RunTime:0.029021s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18835975 ORDER BY `unit` DESC [ RunTime:0.010518s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18835975 LIMIT 2 [ RunTime:0.037079s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18835975 ORDER BY `minOrder` ASC [ RunTime:0.005798s ]
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 '12132%' OR `brand` LIKE '12132%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.029939s ]
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 '12132%' OR `brand` LIKE '12132%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011531s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60410020 LIMIT 5 [ RunTime:0.000688s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60410020 ORDER BY `minOrder` ASC [ RunTime:0.006302s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60410020 ORDER BY `unit` DESC [ RunTime:0.011166s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60410020 LIMIT 2 [ RunTime:0.005686s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60410020 ORDER BY `minOrder` ASC [ RunTime:0.008964s ]
select * from pdf where partno='1213207' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.015699s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002396s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1213207' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.021391s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60410023 LIMIT 5 [ RunTime:0.021472s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60410023 ORDER BY `minOrder` ASC [ RunTime:0.003683s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60410023 ORDER BY `unit` DESC [ RunTime:0.059627s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60410023 LIMIT 2 [ RunTime:0.048512s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60410023 ORDER BY `minOrder` ASC [ RunTime:0.029960s ]
select * from pdf where partno='1213204' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.060601s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1213204' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.015189s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57643746 LIMIT 5 [ RunTime:0.055494s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57643746 ORDER BY `minOrder` ASC [ RunTime:0.080867s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57643746 ORDER BY `unit` DESC [ RunTime:0.019672s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57643746 LIMIT 2 [ RunTime:0.027273s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57643746 ORDER BY `minOrder` ASC [ RunTime:0.005409s ]
select * from pdf where partno='1213206' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.017373s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1213206' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.025442s ]
SELECT `id` FROM `stock` WHERE `id` <> 57643746 AND `partno` = '1213206' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.065778s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16012659 [ RunTime:0.049256s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57643750 LIMIT 5 [ RunTime:0.034562s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57643750 ORDER BY `minOrder` ASC [ RunTime:0.035417s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57643750 ORDER BY `unit` DESC [ RunTime:0.015326s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57643750 LIMIT 2 [ RunTime:0.046066s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57643750 ORDER BY `minOrder` ASC [ RunTime:0.049093s ]
select * from pdf where partno='1213207' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.045017s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1213207' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.051085s ]
SELECT `id` FROM `stock` WHERE `id` <> 57643750 AND `partno` = '1213207' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.066197s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18835331 [ RunTime:0.047995s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57643747 LIMIT 5 [ RunTime:0.064351s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57643747 ORDER BY `minOrder` ASC [ RunTime:0.042204s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57643747 ORDER BY `unit` DESC [ RunTime:0.042101s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57643747 LIMIT 2 [ RunTime:0.037114s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57643747 ORDER BY `minOrder` ASC [ RunTime:0.026896s ]
select * from pdf where partno='1213205' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.036100s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1213205' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.072685s ]
SELECT `id` FROM `stock` WHERE `id` <> 57643747 AND `partno` = '1213205' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.056384s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18835328 [ RunTime:0.007857s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57643745 LIMIT 5 [ RunTime:0.028528s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57643745 ORDER BY `minOrder` ASC [ RunTime:0.048805s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57643745 ORDER BY `unit` DESC [ RunTime:0.042934s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57643745 LIMIT 2 [ RunTime:0.021134s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57643745 ORDER BY `minOrder` ASC [ RunTime:0.003788s ]
select * from pdf where partno='1213204' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.028025s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1213204' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.023844s ]
SELECT `id` FROM `stock` WHERE `id` <> 57643745 AND `partno` = '1213204' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.016552s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17020924 [ RunTime:0.014805s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57643883 LIMIT 5 [ RunTime:0.002654s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57643883 ORDER BY `minOrder` ASC [ RunTime:0.026872s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57643883 ORDER BY `unit` DESC [ RunTime:0.005082s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57643883 LIMIT 2 [ RunTime:0.000693s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57643883 ORDER BY `minOrder` ASC [ RunTime:0.006426s ]
select * from pdf where partno='1213217' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.017586s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1213217' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.014134s ]
SELECT `id` FROM `stock` WHERE `id` <> 57643883 AND `partno` = '1213217' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.003665s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18835348 [ RunTime:0.019158s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57643879 LIMIT 5 [ RunTime:0.028069s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57643879 ORDER BY `minOrder` ASC [ RunTime:0.002266s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57643879 ORDER BY `unit` DESC [ RunTime:0.002801s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57643879 LIMIT 2 [ RunTime:0.003667s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57643879 ORDER BY `minOrder` ASC [ RunTime:0.006894s ]
select * from pdf where partno='1213216' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.023401s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1213216' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.008450s ]
SELECT `id` FROM `stock` WHERE `id` <> 57643879 AND `partno` = '1213216' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.009434s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18835340 [ RunTime:0.012951s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57643876 LIMIT 5 [ RunTime:0.014833s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57643876 ORDER BY `minOrder` ASC [ RunTime:0.010242s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57643876 ORDER BY `unit` DESC [ RunTime:0.009250s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57643876 LIMIT 2 [ RunTime:0.019981s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57643876 ORDER BY `minOrder` ASC [ RunTime:0.045152s ]
select * from pdf where partno='1213213' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.016719s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1213213' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.030618s ]
SELECT `id` FROM `stock` WHERE `id` <> 57643876 AND `partno` = '1213213' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.041942s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18837368 [ RunTime:0.013780s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57643871 LIMIT 5 [ RunTime:0.017851s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57643871 ORDER BY `minOrder` ASC [ RunTime:0.017822s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57643871 ORDER BY `unit` DESC [ RunTime:0.015632s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57643871 LIMIT 2 [ RunTime:0.046736s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57643871 ORDER BY `minOrder` ASC [ RunTime:0.002296s ]
select * from pdf where partno='1213212' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.018250s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1213212' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.005636s ]
SELECT `id` FROM `stock` WHERE `id` <> 57643871 AND `partno` = '1213212' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.012226s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16013768 [ RunTime:0.001506s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57644265 LIMIT 5 [ RunTime:0.005243s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57644265 ORDER BY `minOrder` ASC [ RunTime:0.023569s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57644265 ORDER BY `unit` DESC [ RunTime:0.032233s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57644265 LIMIT 2 [ RunTime:0.072654s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57644265 ORDER BY `minOrder` ASC [ RunTime:0.017301s ]
select * from pdf where partno='1213221' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.010980s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1213221' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.003009s ]
SELECT `id` FROM `stock` WHERE `id` <> 57644265 AND `partno` = '1213221' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.011806s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16013772 [ RunTime:0.009894s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57644256 LIMIT 5 [ RunTime:0.011423s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57644256 ORDER BY `minOrder` ASC [ RunTime:0.040870s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57644256 ORDER BY `unit` DESC [ RunTime:0.047216s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57644256 LIMIT 2 [ RunTime:0.038951s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57644256 ORDER BY `minOrder` ASC [ RunTime:0.076001s ]
select * from pdf where partno='1213220' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.044900s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1213220' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.040121s ]
SELECT `id` FROM `stock` WHERE `id` <> 57644256 AND `partno` = '1213220' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.032312s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18837369 [ RunTime:0.043466s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57644247 LIMIT 5 [ RunTime:0.026455s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57644247 ORDER BY `minOrder` ASC [ RunTime:0.031159s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57644247 ORDER BY `unit` DESC [ RunTime:0.048980s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57644247 LIMIT 2 [ RunTime:0.058700s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57644247 ORDER BY `minOrder` ASC [ RunTime:0.036917s ]
select * from pdf where partno='1213215' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.062774s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1213215' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.056773s ]
SELECT `id` FROM `stock` WHERE `id` <> 57644247 AND `partno` = '1213215' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.004112s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17021533 [ RunTime:0.109559s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57644240 LIMIT 5 [ RunTime:0.067471s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57644240 ORDER BY `minOrder` ASC [ RunTime:0.125843s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57644240 ORDER BY `unit` DESC [ RunTime:0.106506s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57644240 LIMIT 2 [ RunTime:0.055190s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57644240 ORDER BY `minOrder` ASC [ RunTime:0.051420s ]
select * from pdf where partno='1213214' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.115282s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1213214' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.058480s ]
SELECT `id` FROM `stock` WHERE `id` <> 57644240 AND `partno` = '1213214' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.036178s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18837365 [ RunTime:0.085190s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57644236 LIMIT 5 [ RunTime:0.060141s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57644236 ORDER BY `minOrder` ASC [ RunTime:0.054858s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57644236 ORDER BY `unit` DESC [ RunTime:0.019786s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57644236 LIMIT 2 [ RunTime:0.081239s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57644236 ORDER BY `minOrder` ASC [ RunTime:0.063834s ]
select * from pdf where partno='1213211' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.017300s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1213211' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.048680s ]
SELECT `id` FROM `stock` WHERE `id` <> 57644236 AND `partno` = '1213211' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.025937s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18837364 [ RunTime:0.029914s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57644235 LIMIT 5 [ RunTime:0.035716s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57644235 ORDER BY `minOrder` ASC [ RunTime:0.028731s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57644235 ORDER BY `unit` DESC [ RunTime:0.023071s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57644235 LIMIT 2 [ RunTime:0.029738s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57644235 ORDER BY `minOrder` ASC [ RunTime:0.014570s ]
select * from pdf where partno='1213209' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.038277s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1213209' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.025461s ]
SELECT `id` FROM `stock` WHERE `id` <> 57644235 AND `partno` = '1213209' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.035028s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18835333 [ RunTime:0.059435s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57644232 LIMIT 5 [ RunTime:0.035677s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57644232 ORDER BY `minOrder` ASC [ RunTime:0.046951s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57644232 ORDER BY `unit` DESC [ RunTime:0.077991s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57644232 LIMIT 2 [ RunTime:0.067607s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57644232 ORDER BY `minOrder` ASC [ RunTime:0.017434s ]
select * from pdf where partno='1213210' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.079570s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1213210' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.030716s ]
SELECT `id` FROM `stock` WHERE `id` <> 57644232 AND `partno` = '1213210' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.107197s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18837362 [ RunTime:0.068631s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57644228 LIMIT 5 [ RunTime:0.073588s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57644228 ORDER BY `minOrder` ASC [ RunTime:0.044655s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57644228 ORDER BY `unit` DESC [ RunTime:0.043075s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57644228 LIMIT 2 [ RunTime:0.037252s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57644228 ORDER BY `minOrder` ASC [ RunTime:0.022472s ]
select * from pdf where partno='1213208' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.024948s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1213208' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.031135s ]
SELECT `id` FROM `stock` WHERE `id` <> 57644228 AND `partno` = '1213208' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.069365s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16012661 [ RunTime:0.032898s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57644221 LIMIT 5 [ RunTime:0.047264s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57644221 ORDER BY `minOrder` ASC [ RunTime:0.010545s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57644221 ORDER BY `unit` DESC [ RunTime:0.016796s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57644221 LIMIT 2 [ RunTime:0.058961s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57644221 ORDER BY `minOrder` ASC [ RunTime:0.042759s ]
select * from pdf where partno='1213203' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.120937s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1213203' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.015351s ]
SELECT `id` FROM `stock` WHERE `id` <> 57644221 AND `partno` = '1213203' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.062587s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18837358 [ RunTime:0.048336s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57644218 LIMIT 5 [ RunTime:0.033720s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57644218 ORDER BY `minOrder` ASC [ RunTime:0.004329s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57644218 ORDER BY `unit` DESC [ RunTime:0.018973s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57644218 LIMIT 2 [ RunTime:0.069256s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57644218 ORDER BY `minOrder` ASC [ RunTime:0.030406s ]
select * from pdf where partno='1213202' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.025297s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1213202' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.038153s ]
SELECT `id` FROM `stock` WHERE `id` <> 57644218 AND `partno` = '1213202' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.079961s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18837355 [ RunTime:0.026479s ]
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 '12132%' OR `brand` LIKE '12132%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.041668s ]
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 '12132%' OR `brand` LIKE '12132%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.030437s ]
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 '12132%' OR `brand` LIKE '12132%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.051454s ]
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 '12132%' OR `brand` LIKE '12132%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.041298s ]
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 '12132%' OR `brand` LIKE '12132%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.143407s ]
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 '12132%' OR `brand` LIKE '12132%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.034742s ]
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 '12132%' OR `brand` LIKE '12132%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.105969s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '12132%' OR `brand` LIKE '12132%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.108806s ]