SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001512s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.146' , `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=10962&search=1' [ RunTime:0.006348s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001563s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.005339s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002568s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.146' ) [ RunTime:0.000777s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002716s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.013235s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002460s ]
SELECT * FROM `stock_search` WHERE `partno` = '10962' LIMIT 1 [ RunTime:0.014482s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-08-10 03:35:17' WHERE `partno` = '10962' [ RunTime:0.003799s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002300s ]
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 '10962%' OR `brand` LIKE '10962%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014469s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.005740s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12066776 LIMIT 5 [ RunTime:0.023515s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.008275s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12066776 ORDER BY `minOrder` ASC [ RunTime:0.036248s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.006276s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12066776 ORDER BY `unit` DESC [ RunTime:0.020435s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.008797s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12066776 LIMIT 2 [ RunTime:0.012861s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12066776 ORDER BY `minOrder` ASC [ RunTime:0.026099s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18915390 LIMIT 5 [ RunTime:0.020054s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18915390 ORDER BY `minOrder` ASC [ RunTime:0.054489s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18915390 ORDER BY `unit` DESC [ RunTime:0.017498s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18915390 LIMIT 2 [ RunTime:0.042883s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18915390 ORDER BY `minOrder` ASC [ RunTime:0.030315s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19140729 LIMIT 5 [ RunTime:0.029585s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19140729 ORDER BY `minOrder` ASC [ RunTime:0.022935s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19140729 ORDER BY `unit` DESC [ RunTime:0.037060s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19140729 LIMIT 2 [ RunTime:0.054243s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19140729 ORDER BY `minOrder` ASC [ RunTime:0.010253s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18982474 LIMIT 5 [ RunTime:0.016147s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18982474 ORDER BY `minOrder` ASC [ RunTime:0.014310s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18982474 ORDER BY `unit` DESC [ RunTime:0.022260s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18982474 LIMIT 2 [ RunTime:0.027253s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18982474 ORDER BY `minOrder` ASC [ RunTime:0.019189s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18982134 LIMIT 5 [ RunTime:0.013252s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18982134 ORDER BY `minOrder` ASC [ RunTime:0.021530s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18982134 ORDER BY `unit` DESC [ RunTime:0.026119s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18982134 LIMIT 2 [ RunTime:0.026603s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18982134 ORDER BY `minOrder` ASC [ RunTime:0.011795s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18780952 LIMIT 5 [ RunTime:0.026352s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18780952 ORDER BY `minOrder` ASC [ RunTime:0.024990s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18780952 ORDER BY `unit` DESC [ RunTime:0.013677s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18780952 LIMIT 2 [ RunTime:0.031508s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18780952 ORDER BY `minOrder` ASC [ RunTime:0.008258s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18780947 LIMIT 5 [ RunTime:0.043462s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18780947 ORDER BY `minOrder` ASC [ RunTime:0.064494s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18780947 ORDER BY `unit` DESC [ RunTime:0.023309s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18780947 LIMIT 2 [ RunTime:0.015676s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18780947 ORDER BY `minOrder` ASC [ RunTime:0.031150s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18775603 LIMIT 5 [ RunTime:0.024793s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18775603 ORDER BY `minOrder` ASC [ RunTime:0.064717s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18775603 ORDER BY `unit` DESC [ RunTime:0.034897s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18775603 LIMIT 2 [ RunTime:0.018962s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18775603 ORDER BY `minOrder` ASC [ RunTime:0.005837s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18772667 LIMIT 5 [ RunTime:0.020902s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18772667 ORDER BY `minOrder` ASC [ RunTime:0.012461s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18772667 ORDER BY `unit` DESC [ RunTime:0.028083s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18772667 LIMIT 2 [ RunTime:0.006576s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18772667 ORDER BY `minOrder` ASC [ RunTime:0.015953s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18751663 LIMIT 5 [ RunTime:0.006813s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18751663 ORDER BY `minOrder` ASC [ RunTime:0.025506s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18751663 ORDER BY `unit` DESC [ RunTime:0.015559s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18751663 LIMIT 2 [ RunTime:0.010012s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18751663 ORDER BY `minOrder` ASC [ RunTime:0.005672s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17096291 LIMIT 5 [ RunTime:0.017168s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17096291 ORDER BY `minOrder` ASC [ RunTime:0.029274s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17096291 ORDER BY `unit` DESC [ RunTime:0.023939s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17096291 LIMIT 2 [ RunTime:0.022296s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17096291 ORDER BY `minOrder` ASC [ RunTime:0.019534s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15316950 LIMIT 5 [ RunTime:0.012238s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15316950 ORDER BY `minOrder` ASC [ RunTime:0.030262s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15316950 ORDER BY `unit` DESC [ RunTime:0.020117s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15316950 LIMIT 2 [ RunTime:0.005695s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15316950 ORDER BY `minOrder` ASC [ RunTime:0.008334s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15225432 LIMIT 5 [ RunTime:0.019841s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15225432 ORDER BY `minOrder` ASC [ RunTime:0.017194s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15225432 ORDER BY `unit` DESC [ RunTime:0.018186s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15225432 LIMIT 2 [ RunTime:0.014393s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15225432 ORDER BY `minOrder` ASC [ RunTime:0.002168s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15223302 LIMIT 5 [ RunTime:0.032319s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15223302 ORDER BY `minOrder` ASC [ RunTime:0.026388s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15223302 ORDER BY `unit` DESC [ RunTime:0.011515s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15223302 LIMIT 2 [ RunTime:0.027449s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15223302 ORDER BY `minOrder` ASC [ RunTime:0.002411s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14258182 LIMIT 5 [ RunTime:0.015415s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14258182 ORDER BY `minOrder` ASC [ RunTime:0.014082s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14258182 ORDER BY `unit` DESC [ RunTime:0.038738s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14258182 LIMIT 2 [ RunTime:0.050088s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14258182 ORDER BY `minOrder` ASC [ RunTime:0.016829s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12030532 LIMIT 5 [ RunTime:0.010083s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12030532 ORDER BY `minOrder` ASC [ RunTime:0.004170s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12030532 ORDER BY `unit` DESC [ RunTime:0.006510s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12030532 LIMIT 2 [ RunTime:0.015066s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12030532 ORDER BY `minOrder` ASC [ RunTime:0.000852s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11753551 LIMIT 5 [ RunTime:0.032075s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11753551 ORDER BY `minOrder` ASC [ RunTime:0.030405s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11753551 ORDER BY `unit` DESC [ RunTime:0.012645s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11753551 LIMIT 2 [ RunTime:0.014564s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11753551 ORDER BY `minOrder` ASC [ RunTime:0.004391s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11753550 LIMIT 5 [ RunTime:0.033903s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11753550 ORDER BY `minOrder` ASC [ RunTime:0.014005s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11753550 ORDER BY `unit` DESC [ RunTime:0.022345s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11753550 LIMIT 2 [ RunTime:0.025513s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11753550 ORDER BY `minOrder` ASC [ RunTime:0.035208s ]
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 '10962%' OR `brand` LIKE '10962%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008217s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51068363 LIMIT 5 [ RunTime:0.018838s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51068363 ORDER BY `minOrder` ASC [ RunTime:0.040669s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51068363 ORDER BY `unit` DESC [ RunTime:0.009082s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51068363 LIMIT 2 [ RunTime:0.016285s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51068363 ORDER BY `minOrder` ASC [ RunTime:0.009249s ]
select * from pdf where partno='10962' and brandshort='carclo technical plastics' limit 1 [ RunTime:0.031474s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002656s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10962' OR `brand` LIKE 'carclo technical plastics%' ) ) LIMIT 1 [ RunTime:0.029837s ]
SELECT `id` FROM `stock` WHERE `id` <> 51068363 AND `partno` = '10962' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%carclo technical plastics%' ) [ RunTime:0.031813s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18915390 [ RunTime:0.026190s ]
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 '10962%' OR `brand` LIKE '10962%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.074636s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64558940 LIMIT 5 [ RunTime:0.027510s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64558940 ORDER BY `minOrder` ASC [ RunTime:0.031239s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64558940 ORDER BY `unit` DESC [ RunTime:0.025476s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64558940 LIMIT 2 [ RunTime:0.023716s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64558940 ORDER BY `minOrder` ASC [ RunTime:0.015518s ]
select * from pdf where partno='10962CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.016367s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10962CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.039461s ]
SELECT `id` FROM `stock` WHERE `id` <> 64558940 AND `partno` = '10962CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.054358s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12066776 [ RunTime:0.037887s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58115515 LIMIT 5 [ RunTime:0.042434s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58115515 ORDER BY `minOrder` ASC [ RunTime:0.053763s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58115515 ORDER BY `unit` DESC [ RunTime:0.096370s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58115515 LIMIT 2 [ RunTime:0.064295s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58115515 ORDER BY `minOrder` ASC [ RunTime:0.019139s ]
select * from pdf where partno='10962' and brandshort='Carclo Technical Plastics' limit 1 [ RunTime:0.056983s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10962' OR `brand` LIKE 'Carclo Technical Plastics%' ) ) LIMIT 1 [ RunTime:0.027703s ]
SELECT `id` FROM `stock` WHERE `id` <> 58115515 AND `partno` = '10962' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%carclo technical plastics%' ) [ RunTime:0.140170s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18915390 [ RunTime:0.014890s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63278538 LIMIT 5 [ RunTime:0.051072s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63278538 ORDER BY `minOrder` ASC [ RunTime:0.030591s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63278538 ORDER BY `unit` DESC [ RunTime:0.008354s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63278538 LIMIT 2 [ RunTime:0.043366s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63278538 ORDER BY `minOrder` ASC [ RunTime:0.016103s ]
select * from pdf where partno='1096266' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.013225s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1096266' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.016641s ]
SELECT `id` FROM `stock` WHERE `id` <> 63278538 AND `partno` = '1096266' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.113564s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64808280 LIMIT 5 [ RunTime:0.066637s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64808280 ORDER BY `minOrder` ASC [ RunTime:0.030276s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64808280 ORDER BY `unit` DESC [ RunTime:0.044735s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64808280 LIMIT 2 [ RunTime:0.074802s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64808280 ORDER BY `minOrder` ASC [ RunTime:0.000775s ]
select * from pdf where partno='1096270' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.073223s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1096270' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.055511s ]
SELECT `id` FROM `stock` WHERE `id` <> 64808280 AND `partno` = '1096270' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.087293s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18775603 [ RunTime:0.081815s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64803262 LIMIT 5 [ RunTime:0.052017s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64803262 ORDER BY `minOrder` ASC [ RunTime:0.105426s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64803262 ORDER BY `unit` DESC [ RunTime:0.005422s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64803262 LIMIT 2 [ RunTime:0.051485s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64803262 ORDER BY `minOrder` ASC [ RunTime:0.044266s ]
select * from pdf where partno='1096216' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.026073s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1096216' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.060455s ]
SELECT `id` FROM `stock` WHERE `id` <> 64803262 AND `partno` = '1096216' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.049066s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18772667 [ RunTime:0.032791s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64802379 LIMIT 5 [ RunTime:0.006770s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64802379 ORDER BY `minOrder` ASC [ RunTime:0.035243s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64802379 ORDER BY `unit` DESC [ RunTime:0.033127s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64802379 LIMIT 2 [ RunTime:0.044146s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64802379 ORDER BY `minOrder` ASC [ RunTime:0.018776s ]
select * from pdf where partno='1096204' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.037014s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1096204' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.060972s ]
SELECT `id` FROM `stock` WHERE `id` <> 64802379 AND `partno` = '1096204' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.051402s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15223302 [ RunTime:0.021523s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64414417 LIMIT 5 [ RunTime:0.028484s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64414417 ORDER BY `minOrder` ASC [ RunTime:0.064503s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64414417 ORDER BY `unit` DESC [ RunTime:0.013076s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64414417 LIMIT 2 [ RunTime:0.032872s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64414417 ORDER BY `minOrder` ASC [ RunTime:0.012151s ]
select * from pdf where partno='10962' and brandshort='SparkFun Electronics' limit 1 [ RunTime:0.022924s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10962' OR `brand` LIKE 'SparkFun Electronics%' ) ) LIMIT 1 [ RunTime:0.025031s ]
SELECT `id` FROM `stock` WHERE `id` <> 64414417 AND `partno` = '10962' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sparkfun electronics%' ) [ RunTime:0.033806s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14258182 [ RunTime:0.067107s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63346568 LIMIT 5 [ RunTime:0.013798s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63346568 ORDER BY `minOrder` ASC [ RunTime:0.042060s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63346568 ORDER BY `unit` DESC [ RunTime:0.026068s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63346568 LIMIT 2 [ RunTime:0.029410s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63346568 ORDER BY `minOrder` ASC [ RunTime:0.022517s ]
select * from pdf where partno='1096227' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.039224s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1096227' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.036371s ]
SELECT `id` FROM `stock` WHERE `id` <> 63346568 AND `partno` = '1096227' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.037882s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18780947 [ RunTime:0.043322s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63199621 LIMIT 5 [ RunTime:0.006756s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63199621 ORDER BY `minOrder` ASC [ RunTime:0.012876s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63199621 ORDER BY `unit` DESC [ RunTime:0.036258s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63199621 LIMIT 2 [ RunTime:0.023086s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63199621 ORDER BY `minOrder` ASC [ RunTime:0.008504s ]
select * from pdf where partno='1096206' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.054396s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1096206' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.008220s ]
SELECT `id` FROM `stock` WHERE `id` <> 63199621 AND `partno` = '1096206' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.012656s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18982474 [ RunTime:0.007279s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63199405 LIMIT 5 [ RunTime:0.080439s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63199405 ORDER BY `minOrder` ASC [ RunTime:0.037854s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63199405 ORDER BY `unit` DESC [ RunTime:0.031106s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63199405 LIMIT 2 [ RunTime:0.025445s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63199405 ORDER BY `minOrder` ASC [ RunTime:0.015235s ]
select * from pdf where partno='1096221' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.031209s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1096221' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.021414s ]
SELECT `id` FROM `stock` WHERE `id` <> 63199405 AND `partno` = '1096221' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.043712s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18982134 [ RunTime:0.010491s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60336892 LIMIT 5 [ RunTime:0.009381s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60336892 ORDER BY `minOrder` ASC [ RunTime:0.016775s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60336892 ORDER BY `unit` DESC [ RunTime:0.011868s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60336892 LIMIT 2 [ RunTime:0.005104s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60336892 ORDER BY `minOrder` ASC [ RunTime:0.035584s ]
select * from pdf where partno='109629-108' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.011426s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '109629-108' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.007398s ]
SELECT `id` FROM `stock` WHERE `id` <> 60336892 AND `partno` = '109629-108' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.013971s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60336604 LIMIT 5 [ RunTime:0.017380s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60336604 ORDER BY `minOrder` ASC [ RunTime:0.023513s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60336604 ORDER BY `unit` DESC [ RunTime:0.068280s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60336604 LIMIT 2 [ RunTime:0.027571s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60336604 ORDER BY `minOrder` ASC [ RunTime:0.010719s ]
select * from pdf where partno='109629-90' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.025095s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '109629-90' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.032523s ]
SELECT `id` FROM `stock` WHERE `id` <> 60336604 AND `partno` = '109629-90' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.030424s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60335855 LIMIT 5 [ RunTime:0.028353s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60335855 ORDER BY `minOrder` ASC [ RunTime:0.010017s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60335855 ORDER BY `unit` DESC [ RunTime:0.084847s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60335855 LIMIT 2 [ RunTime:0.049585s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60335855 ORDER BY `minOrder` ASC [ RunTime:0.027102s ]
select * from pdf where partno='109629-01' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.011698s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '109629-01' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.017559s ]
SELECT `id` FROM `stock` WHERE `id` <> 60335855 AND `partno` = '109629-01' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.016734s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60050442 LIMIT 5 [ RunTime:0.044967s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60050442 ORDER BY `minOrder` ASC [ RunTime:0.038826s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60050442 ORDER BY `unit` DESC [ RunTime:0.015880s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60050442 LIMIT 2 [ RunTime:0.034647s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60050442 ORDER BY `minOrder` ASC [ RunTime:0.013185s ]
select * from pdf where partno='1096285' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.003313s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1096285' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.043912s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60046902 LIMIT 5 [ RunTime:0.020436s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60046902 ORDER BY `minOrder` ASC [ RunTime:0.052115s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60046902 ORDER BY `unit` DESC [ RunTime:0.006471s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60046902 LIMIT 2 [ RunTime:0.012480s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60046902 ORDER BY `minOrder` ASC [ RunTime:0.003224s ]
select * from pdf where partno='1096284' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.022039s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1096284' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.051103s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50630750 LIMIT 5 [ RunTime:0.003336s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50630750 ORDER BY `minOrder` ASC [ RunTime:0.012054s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50630750 ORDER BY `unit` DESC [ RunTime:0.037221s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50630750 LIMIT 2 [ RunTime:0.018640s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50630750 ORDER BY `minOrder` ASC [ RunTime:0.013707s ]
select * from pdf where partno='109628' and brandshort='Lumberg Automation' limit 1 [ RunTime:0.001597s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '109628' OR `brand` LIKE 'Lumberg Automation%' ) ) LIMIT 1 [ RunTime:0.004300s ]
SELECT `id` FROM `stock` WHERE `id` <> 50630750 AND `partno` = '109628' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lumberg automation%' ) [ RunTime:0.015029s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17096291 [ RunTime:0.010199s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50630749 LIMIT 5 [ RunTime:0.005623s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50630749 ORDER BY `minOrder` ASC [ RunTime:0.007613s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50630749 ORDER BY `unit` DESC [ RunTime:0.010704s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50630749 LIMIT 2 [ RunTime:0.012400s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50630749 ORDER BY `minOrder` ASC [ RunTime:0.015936s ]
select * from pdf where partno='109627' and brandshort='Lumberg Automation' limit 1 [ RunTime:0.023984s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '109627' OR `brand` LIKE 'Lumberg Automation%' ) ) LIMIT 1 [ RunTime:0.027277s ]
SELECT `id` FROM `stock` WHERE `id` <> 50630749 AND `partno` = '109627' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lumberg automation%' ) [ RunTime:0.032058s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15316950 [ RunTime:0.031114s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50630729 LIMIT 5 [ RunTime:0.022738s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50630729 ORDER BY `minOrder` ASC [ RunTime:0.038980s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50630729 ORDER BY `unit` DESC [ RunTime:0.006623s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50630729 LIMIT 2 [ RunTime:0.055896s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50630729 ORDER BY `minOrder` ASC [ RunTime:0.014514s ]
select * from pdf where partno='109629' and brandshort='Lumberg Automation' limit 1 [ RunTime:0.039176s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '109629' OR `brand` LIKE 'Lumberg Automation%' ) ) LIMIT 1 [ RunTime:0.008501s ]
SELECT `id` FROM `stock` WHERE `id` <> 50630729 AND `partno` = '109629' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lumberg automation%' ) [ RunTime:0.024217s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19140729 [ RunTime:0.025804s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37965112 LIMIT 5 [ RunTime:0.068610s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37965112 ORDER BY `minOrder` ASC [ RunTime:0.047689s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37965112 ORDER BY `unit` DESC [ RunTime:0.004070s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37965112 LIMIT 2 [ RunTime:0.010854s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37965112 ORDER BY `minOrder` ASC [ RunTime:0.019371s ]
select * from pdf where partno='109628' and brandshort='Lumberg Automation' limit 1 [ RunTime:0.001711s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '109628' OR `brand` LIKE 'Lumberg Automation%' ) ) LIMIT 1 [ RunTime:0.002352s ]
SELECT `id` FROM `stock` WHERE `id` <> 37965112 AND `partno` = '109628' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lumberg automation%' ) [ RunTime:0.008708s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17096291 [ RunTime:0.016082s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37965111 LIMIT 5 [ RunTime:0.006912s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37965111 ORDER BY `minOrder` ASC [ RunTime:0.008872s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37965111 ORDER BY `unit` DESC [ RunTime:0.020324s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37965111 LIMIT 2 [ RunTime:0.024835s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37965111 ORDER BY `minOrder` ASC [ RunTime:0.006261s ]
select * from pdf where partno='109627' and brandshort='Lumberg Automation' limit 1 [ RunTime:0.006565s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '109627' OR `brand` LIKE 'Lumberg Automation%' ) ) LIMIT 1 [ RunTime:0.006770s ]
SELECT `id` FROM `stock` WHERE `id` <> 37965111 AND `partno` = '109627' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lumberg automation%' ) [ RunTime:0.003836s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15316950 [ RunTime:0.010843s ]
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 '10962%' OR `brand` LIKE '10962%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013797s ]
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 '10962%' OR `brand` LIKE '10962%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.040741s ]
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 '10962%' OR `brand` LIKE '10962%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017390s ]
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 '10962%' OR `brand` LIKE '10962%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.026682s ]
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 '10962%' OR `brand` LIKE '10962%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012003s ]
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 '10962%' OR `brand` LIKE '10962%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.023384s ]
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 '10962%' OR `brand` LIKE '10962%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013833s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '10962%' OR `brand` LIKE '10962%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.011090s ]