SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001468s ]
INSERT INTO `visit_log` SET `ip` = '216.73.217.116' , `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=87242&search=1' [ RunTime:0.006099s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002606s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000643s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002654s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.116' ) [ RunTime:0.000983s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002670s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.004424s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001722s ]
SELECT * FROM `stock_search` WHERE `partno` = '87242' LIMIT 1 [ RunTime:0.001729s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-07-23 15:38:11' WHERE `partno` = '87242' [ RunTime:0.009839s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001429s ]
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 '87242%' OR `brand` LIKE '87242%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011588s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002190s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20089588 LIMIT 5 [ RunTime:0.061555s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002080s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20089588 ORDER BY `minOrder` ASC [ RunTime:0.014175s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002073s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 20089588 ORDER BY `unit` DESC [ RunTime:0.066121s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.019779s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 20089588 LIMIT 2 [ RunTime:0.034299s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20089588 ORDER BY `minOrder` ASC [ RunTime:0.041242s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13094150 LIMIT 5 [ RunTime:0.056315s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13094150 ORDER BY `minOrder` ASC [ RunTime:0.022615s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13094150 ORDER BY `unit` DESC [ RunTime:0.049357s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13094150 LIMIT 2 [ RunTime:0.037649s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13094150 ORDER BY `minOrder` ASC [ RunTime:0.032334s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13094144 LIMIT 5 [ RunTime:0.072517s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13094144 ORDER BY `minOrder` ASC [ RunTime:0.054136s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13094144 ORDER BY `unit` DESC [ RunTime:0.048020s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13094144 LIMIT 2 [ RunTime:0.019612s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13094144 ORDER BY `minOrder` ASC [ RunTime:0.026780s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13092083 LIMIT 5 [ RunTime:0.005880s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13092083 ORDER BY `minOrder` ASC [ RunTime:0.029197s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13092083 ORDER BY `unit` DESC [ RunTime:0.019340s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13092083 LIMIT 2 [ RunTime:0.058985s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13092083 ORDER BY `minOrder` ASC [ RunTime:0.039866s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13090130 LIMIT 5 [ RunTime:0.082558s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13090130 ORDER BY `minOrder` ASC [ RunTime:0.058862s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13090130 ORDER BY `unit` DESC [ RunTime:0.044610s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13090130 LIMIT 2 [ RunTime:0.003983s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13090130 ORDER BY `minOrder` ASC [ RunTime:0.014816s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13056375 LIMIT 5 [ RunTime:0.012382s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13056375 ORDER BY `minOrder` ASC [ RunTime:0.066767s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13056375 ORDER BY `unit` DESC [ RunTime:0.029864s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13056375 LIMIT 2 [ RunTime:0.078847s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13056375 ORDER BY `minOrder` ASC [ RunTime:0.025962s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13049384 LIMIT 5 [ RunTime:0.070694s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13049384 ORDER BY `minOrder` ASC [ RunTime:0.031014s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13049384 ORDER BY `unit` DESC [ RunTime:0.026515s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13049384 LIMIT 2 [ RunTime:0.022145s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13049384 ORDER BY `minOrder` ASC [ RunTime:0.008919s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13049383 LIMIT 5 [ RunTime:0.013657s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13049383 ORDER BY `minOrder` ASC [ RunTime:0.007839s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13049383 ORDER BY `unit` DESC [ RunTime:0.019424s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13049383 LIMIT 2 [ RunTime:0.006680s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13049383 ORDER BY `minOrder` ASC [ RunTime:0.001835s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11843658 LIMIT 5 [ RunTime:0.013357s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11843658 ORDER BY `minOrder` ASC [ RunTime:0.005322s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11843658 ORDER BY `unit` DESC [ RunTime:0.007061s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11843658 LIMIT 2 [ RunTime:0.013795s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11843658 ORDER BY `minOrder` ASC [ RunTime:0.002923s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11810963 LIMIT 5 [ RunTime:0.017435s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11810963 ORDER BY `minOrder` ASC [ RunTime:0.012629s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11810963 ORDER BY `unit` DESC [ RunTime:0.005911s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11810963 LIMIT 2 [ RunTime:0.008960s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11810963 ORDER BY `minOrder` ASC [ RunTime:0.017481s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11810962 LIMIT 5 [ RunTime:0.032888s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11810962 ORDER BY `minOrder` ASC [ RunTime:0.014951s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11810962 ORDER BY `unit` DESC [ RunTime:0.027604s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11810962 LIMIT 2 [ RunTime:0.008837s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11810962 ORDER BY `minOrder` ASC [ RunTime:0.013251s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11690480 LIMIT 5 [ RunTime:0.016139s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11690480 ORDER BY `minOrder` ASC [ RunTime:0.001610s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11690480 ORDER BY `unit` DESC [ RunTime:0.011446s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11690480 LIMIT 2 [ RunTime:0.015455s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11690480 ORDER BY `minOrder` ASC [ RunTime:0.004055s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11687854 LIMIT 5 [ RunTime:0.021017s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11687854 ORDER BY `minOrder` ASC [ RunTime:0.022348s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11687854 ORDER BY `unit` DESC [ RunTime:0.002301s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11687854 LIMIT 2 [ RunTime:0.022919s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11687854 ORDER BY `minOrder` ASC [ RunTime:0.011995s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11687670 LIMIT 5 [ RunTime:0.020954s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11687670 ORDER BY `minOrder` ASC [ RunTime:0.003073s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11687670 ORDER BY `unit` DESC [ RunTime:0.018441s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11687670 LIMIT 2 [ RunTime:0.003199s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11687670 ORDER BY `minOrder` ASC [ RunTime:0.003576s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11112390 LIMIT 5 [ RunTime:0.002629s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11112390 ORDER BY `minOrder` ASC [ RunTime:0.017220s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11112390 ORDER BY `unit` DESC [ RunTime:0.010250s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11112390 LIMIT 2 [ RunTime:0.004925s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11112390 ORDER BY `minOrder` ASC [ RunTime:0.011771s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11097261 LIMIT 5 [ RunTime:0.012020s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11097261 ORDER BY `minOrder` ASC [ RunTime:0.006484s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11097261 ORDER BY `unit` DESC [ RunTime:0.013613s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11097261 LIMIT 2 [ RunTime:0.011142s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11097261 ORDER BY `minOrder` ASC [ RunTime:0.003864s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11056218 LIMIT 5 [ RunTime:0.015458s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11056218 ORDER BY `minOrder` ASC [ RunTime:0.005006s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11056218 ORDER BY `unit` DESC [ RunTime:0.005029s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11056218 LIMIT 2 [ RunTime:0.007998s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11056218 ORDER BY `minOrder` ASC [ RunTime:0.004141s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11047340 LIMIT 5 [ RunTime:0.032063s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11047340 ORDER BY `minOrder` ASC [ RunTime:0.007084s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11047340 ORDER BY `unit` DESC [ RunTime:0.001481s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11047340 LIMIT 2 [ RunTime:0.001513s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11047340 ORDER BY `minOrder` ASC [ RunTime:0.010218s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11033382 LIMIT 5 [ RunTime:0.032320s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11033382 ORDER BY `minOrder` ASC [ RunTime:0.008976s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11033382 ORDER BY `unit` DESC [ RunTime:0.016161s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11033382 LIMIT 2 [ RunTime:0.037839s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11033382 ORDER BY `minOrder` ASC [ RunTime:0.027824s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10977641 LIMIT 5 [ RunTime:0.006484s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10977641 ORDER BY `minOrder` ASC [ RunTime:0.007852s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10977641 ORDER BY `unit` DESC [ RunTime:0.013511s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10977641 LIMIT 2 [ RunTime:0.007744s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10977641 ORDER BY `minOrder` ASC [ RunTime:0.015783s ]
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 '87242%' OR `brand` LIKE '87242%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011143s ]
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 '87242%' OR `brand` LIKE '87242%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013775s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 54944224 LIMIT 5 [ RunTime:0.008199s ]
SELECT * FROM `stock_price` WHERE `stockid` = 54944224 ORDER BY `minOrder` ASC [ RunTime:0.011122s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 54944224 ORDER BY `unit` DESC [ RunTime:0.003350s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 54944224 LIMIT 2 [ RunTime:0.041516s ]
SELECT * FROM `stock_price` WHERE `stockid` = 54944224 ORDER BY `minOrder` ASC [ RunTime:0.046340s ]
select * from pdf where partno='8724254' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.038425s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.003499s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '8724254' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.030178s ]
SELECT `id` FROM `stock` WHERE `id` <> 54944224 AND `partno` = '8724254' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.014649s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11056218 [ RunTime:0.015744s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 54865318 LIMIT 5 [ RunTime:0.031322s ]
SELECT * FROM `stock_price` WHERE `stockid` = 54865318 ORDER BY `minOrder` ASC [ RunTime:0.021375s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 54865318 ORDER BY `unit` DESC [ RunTime:0.006353s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 54865318 LIMIT 2 [ RunTime:0.040575s ]
SELECT * FROM `stock_price` WHERE `stockid` = 54865318 ORDER BY `minOrder` ASC [ RunTime:0.038257s ]
select * from pdf where partno='8724253' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.043007s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '8724253' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.058883s ]
SELECT `id` FROM `stock` WHERE `id` <> 54865318 AND `partno` = '8724253' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.115951s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10977641 [ RunTime:0.058864s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 54805002 LIMIT 5 [ RunTime:0.042586s ]
SELECT * FROM `stock_price` WHERE `stockid` = 54805002 ORDER BY `minOrder` ASC [ RunTime:0.012627s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 54805002 ORDER BY `unit` DESC [ RunTime:0.032104s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 54805002 LIMIT 2 [ RunTime:0.058302s ]
SELECT * FROM `stock_price` WHERE `stockid` = 54805002 ORDER BY `minOrder` ASC [ RunTime:0.017100s ]
select * from pdf where partno='8724258' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.024637s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '8724258' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.041521s ]
SELECT `id` FROM `stock` WHERE `id` <> 54805002 AND `partno` = '8724258' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.033114s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 54783771 LIMIT 5 [ RunTime:0.017264s ]
SELECT * FROM `stock_price` WHERE `stockid` = 54783771 ORDER BY `minOrder` ASC [ RunTime:0.007536s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 54783771 ORDER BY `unit` DESC [ RunTime:0.012633s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 54783771 LIMIT 2 [ RunTime:0.012670s ]
SELECT * FROM `stock_price` WHERE `stockid` = 54783771 ORDER BY `minOrder` ASC [ RunTime:0.029195s ]
select * from pdf where partno='8724239' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.040659s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '8724239' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.027168s ]
SELECT `id` FROM `stock` WHERE `id` <> 54783771 AND `partno` = '8724239' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.012496s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13094144 [ RunTime:0.071847s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 54780901 LIMIT 5 [ RunTime:0.062081s ]
SELECT * FROM `stock_price` WHERE `stockid` = 54780901 ORDER BY `minOrder` ASC [ RunTime:0.080864s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 54780901 ORDER BY `unit` DESC [ RunTime:0.047978s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 54780901 LIMIT 2 [ RunTime:0.065776s ]
SELECT * FROM `stock_price` WHERE `stockid` = 54780901 ORDER BY `minOrder` ASC [ RunTime:0.060712s ]
select * from pdf where partno='8724260' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.028984s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '8724260' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.043896s ]
SELECT `id` FROM `stock` WHERE `id` <> 54780901 AND `partno` = '8724260' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.027281s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11112390 [ RunTime:0.071320s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 54764952 LIMIT 5 [ RunTime:0.056511s ]
SELECT * FROM `stock_price` WHERE `stockid` = 54764952 ORDER BY `minOrder` ASC [ RunTime:0.058259s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 54764952 ORDER BY `unit` DESC [ RunTime:0.044297s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 54764952 LIMIT 2 [ RunTime:0.077043s ]
SELECT * FROM `stock_price` WHERE `stockid` = 54764952 ORDER BY `minOrder` ASC [ RunTime:0.069479s ]
select * from pdf where partno='8724261' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.030730s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '8724261' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.073297s ]
SELECT `id` FROM `stock` WHERE `id` <> 54764952 AND `partno` = '8724261' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.003460s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11097261 [ RunTime:0.012464s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 54720163 LIMIT 5 [ RunTime:0.022581s ]
SELECT * FROM `stock_price` WHERE `stockid` = 54720163 ORDER BY `minOrder` ASC [ RunTime:0.023286s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 54720163 ORDER BY `unit` DESC [ RunTime:0.060522s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 54720163 LIMIT 2 [ RunTime:0.089279s ]
SELECT * FROM `stock_price` WHERE `stockid` = 54720163 ORDER BY `minOrder` ASC [ RunTime:0.044576s ]
select * from pdf where partno='8724256' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.019314s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '8724256' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.030024s ]
SELECT `id` FROM `stock` WHERE `id` <> 54720163 AND `partno` = '8724256' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.010198s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11047340 [ RunTime:0.023208s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 54709122 LIMIT 5 [ RunTime:0.079515s ]
SELECT * FROM `stock_price` WHERE `stockid` = 54709122 ORDER BY `minOrder` ASC [ RunTime:0.040449s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 54709122 ORDER BY `unit` DESC [ RunTime:0.058713s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 54709122 LIMIT 2 [ RunTime:0.009675s ]
SELECT * FROM `stock_price` WHERE `stockid` = 54709122 ORDER BY `minOrder` ASC [ RunTime:0.003684s ]
select * from pdf where partno='8724257' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.022174s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '8724257' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.035454s ]
SELECT `id` FROM `stock` WHERE `id` <> 54709122 AND `partno` = '8724257' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.001078s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11033382 [ RunTime:0.019781s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 54687067 LIMIT 5 [ RunTime:0.039596s ]
SELECT * FROM `stock_price` WHERE `stockid` = 54687067 ORDER BY `minOrder` ASC [ RunTime:0.013605s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 54687067 ORDER BY `unit` DESC [ RunTime:0.017405s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 54687067 LIMIT 2 [ RunTime:0.034284s ]
SELECT * FROM `stock_price` WHERE `stockid` = 54687067 ORDER BY `minOrder` ASC [ RunTime:0.070789s ]
select * from pdf where partno='8724225' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.033104s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '8724225' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.037612s ]
SELECT `id` FROM `stock` WHERE `id` <> 54687067 AND `partno` = '8724225' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.010556s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11810963 [ RunTime:0.010473s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 54673965 LIMIT 5 [ RunTime:0.023903s ]
SELECT * FROM `stock_price` WHERE `stockid` = 54673965 ORDER BY `minOrder` ASC [ RunTime:0.008562s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 54673965 ORDER BY `unit` DESC [ RunTime:0.007363s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 54673965 LIMIT 2 [ RunTime:0.015572s ]
SELECT * FROM `stock_price` WHERE `stockid` = 54673965 ORDER BY `minOrder` ASC [ RunTime:0.008184s ]
select * from pdf where partno='8724238' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.040970s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '8724238' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.053344s ]
SELECT `id` FROM `stock` WHERE `id` <> 54673965 AND `partno` = '8724238' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.056285s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10971121 [ RunTime:0.065147s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 54666768 LIMIT 5 [ RunTime:0.050834s ]
SELECT * FROM `stock_price` WHERE `stockid` = 54666768 ORDER BY `minOrder` ASC [ RunTime:0.051397s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 54666768 ORDER BY `unit` DESC [ RunTime:0.032699s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 54666768 LIMIT 2 [ RunTime:0.073494s ]
SELECT * FROM `stock_price` WHERE `stockid` = 54666768 ORDER BY `minOrder` ASC [ RunTime:0.017318s ]
select * from pdf where partno='8724240' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.011967s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '8724240' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.088425s ]
SELECT `id` FROM `stock` WHERE `id` <> 54666768 AND `partno` = '8724240' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.016775s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10951380 [ RunTime:0.029763s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 54665874 LIMIT 5 [ RunTime:0.053492s ]
SELECT * FROM `stock_price` WHERE `stockid` = 54665874 ORDER BY `minOrder` ASC [ RunTime:0.047889s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 54665874 ORDER BY `unit` DESC [ RunTime:0.031570s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 54665874 LIMIT 2 [ RunTime:0.025182s ]
SELECT * FROM `stock_price` WHERE `stockid` = 54665874 ORDER BY `minOrder` ASC [ RunTime:0.010566s ]
select * from pdf where partno='8724248' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.030498s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '8724248' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.030276s ]
SELECT `id` FROM `stock` WHERE `id` <> 54665874 AND `partno` = '8724248' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.043774s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10948403 [ RunTime:0.049429s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 54663395 LIMIT 5 [ RunTime:0.048861s ]
SELECT * FROM `stock_price` WHERE `stockid` = 54663395 ORDER BY `minOrder` ASC [ RunTime:0.010759s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 54663395 ORDER BY `unit` DESC [ RunTime:0.031889s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 54663395 LIMIT 2 [ RunTime:0.018199s ]
SELECT * FROM `stock_price` WHERE `stockid` = 54663395 ORDER BY `minOrder` ASC [ RunTime:0.013762s ]
select * from pdf where partno='8724247' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.018088s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '8724247' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.012164s ]
SELECT `id` FROM `stock` WHERE `id` <> 54663395 AND `partno` = '8724247' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.004693s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10940621 [ RunTime:0.008226s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 54660396 LIMIT 5 [ RunTime:0.028705s ]
SELECT * FROM `stock_price` WHERE `stockid` = 54660396 ORDER BY `minOrder` ASC [ RunTime:0.008584s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 54660396 ORDER BY `unit` DESC [ RunTime:0.009218s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 54660396 LIMIT 2 [ RunTime:0.013508s ]
SELECT * FROM `stock_price` WHERE `stockid` = 54660396 ORDER BY `minOrder` ASC [ RunTime:0.004600s ]
select * from pdf where partno='8724249' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.042102s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '8724249' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.051649s ]
SELECT `id` FROM `stock` WHERE `id` <> 54660396 AND `partno` = '8724249' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.006356s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10932395 [ RunTime:0.051026s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 54657107 LIMIT 5 [ RunTime:0.023261s ]
SELECT * FROM `stock_price` WHERE `stockid` = 54657107 ORDER BY `minOrder` ASC [ RunTime:0.019924s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 54657107 ORDER BY `unit` DESC [ RunTime:0.020633s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 54657107 LIMIT 2 [ RunTime:0.028553s ]
SELECT * FROM `stock_price` WHERE `stockid` = 54657107 ORDER BY `minOrder` ASC [ RunTime:0.016459s ]
select * from pdf where partno='8724242' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.029939s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '8724242' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.066795s ]
SELECT `id` FROM `stock` WHERE `id` <> 54657107 AND `partno` = '8724242' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.028283s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10922163 [ RunTime:0.044253s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 54655755 LIMIT 5 [ RunTime:0.022736s ]
SELECT * FROM `stock_price` WHERE `stockid` = 54655755 ORDER BY `minOrder` ASC [ RunTime:0.009586s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 54655755 ORDER BY `unit` DESC [ RunTime:0.035806s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 54655755 LIMIT 2 [ RunTime:0.017583s ]
SELECT * FROM `stock_price` WHERE `stockid` = 54655755 ORDER BY `minOrder` ASC [ RunTime:0.015766s ]
select * from pdf where partno='8724243' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.031851s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '8724243' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.027187s ]
SELECT `id` FROM `stock` WHERE `id` <> 54655755 AND `partno` = '8724243' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.012613s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10919273 [ RunTime:0.022205s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 54655687 LIMIT 5 [ RunTime:0.060846s ]
SELECT * FROM `stock_price` WHERE `stockid` = 54655687 ORDER BY `minOrder` ASC [ RunTime:0.033646s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 54655687 ORDER BY `unit` DESC [ RunTime:0.013332s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 54655687 LIMIT 2 [ RunTime:0.026297s ]
SELECT * FROM `stock_price` WHERE `stockid` = 54655687 ORDER BY `minOrder` ASC [ RunTime:0.027395s ]
select * from pdf where partno='8724244' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.013587s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '8724244' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.016681s ]
SELECT `id` FROM `stock` WHERE `id` <> 54655687 AND `partno` = '8724244' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.025362s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 54645489 LIMIT 5 [ RunTime:0.022795s ]
SELECT * FROM `stock_price` WHERE `stockid` = 54645489 ORDER BY `minOrder` ASC [ RunTime:0.010757s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 54645489 ORDER BY `unit` DESC [ RunTime:0.029196s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 54645489 LIMIT 2 [ RunTime:0.002431s ]
SELECT * FROM `stock_price` WHERE `stockid` = 54645489 ORDER BY `minOrder` ASC [ RunTime:0.027677s ]
select * from pdf where partno='8724246' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.023841s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '8724246' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.011534s ]
SELECT `id` FROM `stock` WHERE `id` <> 54645489 AND `partno` = '8724246' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.025787s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13094150 [ RunTime:0.042640s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 54644309 LIMIT 5 [ RunTime:0.027975s ]
SELECT * FROM `stock_price` WHERE `stockid` = 54644309 ORDER BY `minOrder` ASC [ RunTime:0.017206s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 54644309 ORDER BY `unit` DESC [ RunTime:0.010630s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 54644309 LIMIT 2 [ RunTime:0.042997s ]
SELECT * FROM `stock_price` WHERE `stockid` = 54644309 ORDER BY `minOrder` ASC [ RunTime:0.020262s ]
select * from pdf where partno='8724245' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.053969s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '8724245' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.065802s ]
SELECT `id` FROM `stock` WHERE `id` <> 54644309 AND `partno` = '8724245' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.035245s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11843658 [ RunTime:0.004941s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 54643527 LIMIT 5 [ RunTime:0.005125s ]
SELECT * FROM `stock_price` WHERE `stockid` = 54643527 ORDER BY `minOrder` ASC [ RunTime:0.009313s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 54643527 ORDER BY `unit` DESC [ RunTime:0.002934s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 54643527 LIMIT 2 [ RunTime:0.004717s ]
SELECT * FROM `stock_price` WHERE `stockid` = 54643527 ORDER BY `minOrder` ASC [ RunTime:0.004200s ]
select * from pdf where partno='8724241' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.015847s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '8724241' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.059638s ]
SELECT `id` FROM `stock` WHERE `id` <> 54643527 AND `partno` = '8724241' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.016324s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13092083 [ RunTime:0.002095s ]
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 '87242%' OR `brand` LIKE '87242%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017091s ]
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 '87242%' OR `brand` LIKE '87242%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.015945s ]
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 '87242%' OR `brand` LIKE '87242%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.015048s ]
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 '87242%' OR `brand` LIKE '87242%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.020550s ]
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 '87242%' OR `brand` LIKE '87242%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016680s ]
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 '87242%' OR `brand` LIKE '87242%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.053244s ]
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 '87242%' OR `brand` LIKE '87242%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.076591s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '87242%' OR `brand` LIKE '87242%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.055826s ]