SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002039s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.111' , `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=LJT00RE-23-14P&search=1' [ RunTime:0.002367s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001296s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000507s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001609s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.111' ) [ RunTime:0.001613s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001126s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.001716s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001402s ]
SELECT * FROM `stock_search` WHERE `partno` = 'LJT00RE-23-14P' LIMIT 1 [ RunTime:0.006280s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-08-13 18:25:10' WHERE `partno` = 'LJT00RE-23-14P' [ RunTime:0.002646s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001245s ]
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 'LJT00RE-23-14P%' OR `brand` LIKE 'LJT00RE-23-14P%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010400s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001901s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20116595 LIMIT 5 [ RunTime:0.008205s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.007278s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20116595 ORDER BY `minOrder` ASC [ RunTime:0.003900s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.005261s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 20116595 ORDER BY `unit` DESC [ RunTime:0.002127s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.006134s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 20116595 LIMIT 2 [ RunTime:0.002130s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20116595 ORDER BY `minOrder` ASC [ RunTime:0.000354s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20116594 LIMIT 5 [ RunTime:0.000464s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20116594 ORDER BY `minOrder` ASC [ RunTime:0.003317s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 20116594 ORDER BY `unit` DESC [ RunTime:0.000457s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 20116594 LIMIT 2 [ RunTime:0.000365s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20116594 ORDER BY `minOrder` ASC [ RunTime:0.000262s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20116562 LIMIT 5 [ RunTime:0.000406s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20116562 ORDER BY `minOrder` ASC [ RunTime:0.005397s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 20116562 ORDER BY `unit` DESC [ RunTime:0.011104s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 20116562 LIMIT 2 [ RunTime:0.002216s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20116562 ORDER BY `minOrder` ASC [ RunTime:0.001610s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16376561 LIMIT 5 [ RunTime:0.007561s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16376561 ORDER BY `minOrder` ASC [ RunTime:0.002527s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16376561 ORDER BY `unit` DESC [ RunTime:0.000798s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16376561 LIMIT 2 [ RunTime:0.005702s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16376561 ORDER BY `minOrder` ASC [ RunTime:0.000298s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16376535 LIMIT 5 [ RunTime:0.002803s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16376535 ORDER BY `minOrder` ASC [ RunTime:0.014099s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16376535 ORDER BY `unit` DESC [ RunTime:0.008846s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16376535 LIMIT 2 [ RunTime:0.002441s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16376535 ORDER BY `minOrder` ASC [ RunTime:0.010941s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16376519 LIMIT 5 [ RunTime:0.000750s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16376519 ORDER BY `minOrder` ASC [ RunTime:0.000465s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16376519 ORDER BY `unit` DESC [ RunTime:0.020520s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16376519 LIMIT 2 [ RunTime:0.025878s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16376519 ORDER BY `minOrder` ASC [ RunTime:0.007726s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16376518 LIMIT 5 [ RunTime:0.006345s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16376518 ORDER BY `minOrder` ASC [ RunTime:0.006775s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16376518 ORDER BY `unit` DESC [ RunTime:0.018591s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16376518 LIMIT 2 [ RunTime:0.012490s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16376518 ORDER BY `minOrder` ASC [ RunTime:0.013106s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16376516 LIMIT 5 [ RunTime:0.009215s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16376516 ORDER BY `minOrder` ASC [ RunTime:0.006769s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16376516 ORDER BY `unit` DESC [ RunTime:0.015251s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16376516 LIMIT 2 [ RunTime:0.004278s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16376516 ORDER BY `minOrder` ASC [ RunTime:0.008915s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14252601 LIMIT 5 [ RunTime:0.013465s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14252601 ORDER BY `minOrder` ASC [ RunTime:0.032561s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14252601 ORDER BY `unit` DESC [ RunTime:0.023578s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14252601 LIMIT 2 [ RunTime:0.012194s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14252601 ORDER BY `minOrder` ASC [ RunTime:0.002538s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11062468 LIMIT 5 [ RunTime:0.016573s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11062468 ORDER BY `minOrder` ASC [ RunTime:0.024699s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11062468 ORDER BY `unit` DESC [ RunTime:0.023080s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11062468 LIMIT 2 [ RunTime:0.064971s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11062468 ORDER BY `minOrder` ASC [ RunTime:0.051156s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11062461 LIMIT 5 [ RunTime:0.079846s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11062461 ORDER BY `minOrder` ASC [ RunTime:0.076125s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11062461 ORDER BY `unit` DESC [ RunTime:0.057993s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11062461 LIMIT 2 [ RunTime:0.060721s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11062461 ORDER BY `minOrder` ASC [ RunTime:0.051055s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11062460 LIMIT 5 [ RunTime:0.063119s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11062460 ORDER BY `minOrder` ASC [ RunTime:0.049467s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11062460 ORDER BY `unit` DESC [ RunTime:0.046395s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11062460 LIMIT 2 [ RunTime:0.014670s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11062460 ORDER BY `minOrder` ASC [ RunTime:0.014784s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11062459 LIMIT 5 [ RunTime:0.068233s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11062459 ORDER BY `minOrder` ASC [ RunTime:0.041792s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11062459 ORDER BY `unit` DESC [ RunTime:0.036352s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11062459 LIMIT 2 [ RunTime:0.022265s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11062459 ORDER BY `minOrder` ASC [ RunTime:0.004367s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11035649 LIMIT 5 [ RunTime:0.007339s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11035649 ORDER BY `minOrder` ASC [ RunTime:0.016207s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11035649 ORDER BY `unit` DESC [ RunTime:0.016358s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11035649 LIMIT 2 [ RunTime:0.046181s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11035649 ORDER BY `minOrder` ASC [ RunTime:0.006075s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11035646 LIMIT 5 [ RunTime:0.007442s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11035646 ORDER BY `minOrder` ASC [ RunTime:0.018637s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11035646 ORDER BY `unit` DESC [ RunTime:0.041183s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11035646 LIMIT 2 [ RunTime:0.021076s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11035646 ORDER BY `minOrder` ASC [ RunTime:0.014109s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11035645 LIMIT 5 [ RunTime:0.018386s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11035645 ORDER BY `minOrder` ASC [ RunTime:0.021626s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11035645 ORDER BY `unit` DESC [ RunTime:0.045965s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11035645 LIMIT 2 [ RunTime:0.032854s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11035645 ORDER BY `minOrder` ASC [ RunTime:0.005941s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10988702 LIMIT 5 [ RunTime:0.033054s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10988702 ORDER BY `minOrder` ASC [ RunTime:0.014250s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10988702 ORDER BY `unit` DESC [ RunTime:0.049851s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10988702 LIMIT 2 [ RunTime:0.060278s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10988702 ORDER BY `minOrder` ASC [ RunTime:0.014227s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10988687 LIMIT 5 [ RunTime:0.059673s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10988687 ORDER BY `minOrder` ASC [ RunTime:0.056374s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10988687 ORDER BY `unit` DESC [ RunTime:0.040113s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10988687 LIMIT 2 [ RunTime:0.028523s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10988687 ORDER BY `minOrder` ASC [ RunTime:0.009614s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10988686 LIMIT 5 [ RunTime:0.014384s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10988686 ORDER BY `minOrder` ASC [ RunTime:0.080060s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10988686 ORDER BY `unit` DESC [ RunTime:0.032391s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10988686 LIMIT 2 [ RunTime:0.015459s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10988686 ORDER BY `minOrder` ASC [ RunTime:0.025611s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10988494 LIMIT 5 [ RunTime:0.033665s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10988494 ORDER BY `minOrder` ASC [ RunTime:0.047859s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10988494 ORDER BY `unit` DESC [ RunTime:0.017603s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10988494 LIMIT 2 [ RunTime:0.012550s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10988494 ORDER BY `minOrder` ASC [ RunTime:0.008010s ]
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 'LJT00RE-23-14P%' OR `brand` LIKE 'LJT00RE-23-14P%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007286s ]
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 'LJT00RE-23-14P%' OR `brand` LIKE 'LJT00RE-23-14P%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.021587s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61730510 LIMIT 5 [ RunTime:0.000861s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61730510 ORDER BY `minOrder` ASC [ RunTime:0.007127s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61730510 ORDER BY `unit` DESC [ RunTime:0.006420s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61730510 LIMIT 2 [ RunTime:0.000364s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61730510 ORDER BY `minOrder` ASC [ RunTime:0.001881s ]
select * from pdf where partno='LJT00RE-23-14P(344)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.007748s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.004777s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LJT00RE-23-14P(344)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.006050s ]
SELECT `id` FROM `stock` WHERE `id` <> 61730510 AND `partno` = 'LJT00RE-23-14P(344)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.002300s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11062468 [ RunTime:0.004315s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61730503 LIMIT 5 [ RunTime:0.008374s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61730503 ORDER BY `minOrder` ASC [ RunTime:0.006944s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61730503 ORDER BY `unit` DESC [ RunTime:0.008134s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61730503 LIMIT 2 [ RunTime:0.022734s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61730503 ORDER BY `minOrder` ASC [ RunTime:0.005455s ]
select * from pdf where partno='LJT00RE-23-14P(424)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.000794s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LJT00RE-23-14P(424)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.011439s ]
SELECT `id` FROM `stock` WHERE `id` <> 61730503 AND `partno` = 'LJT00RE-23-14P(424)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.009820s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11062460 [ RunTime:0.004871s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61730502 LIMIT 5 [ RunTime:0.002319s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61730502 ORDER BY `minOrder` ASC [ RunTime:0.001441s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61730502 ORDER BY `unit` DESC [ RunTime:0.006997s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61730502 LIMIT 2 [ RunTime:0.011399s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61730502 ORDER BY `minOrder` ASC [ RunTime:0.000783s ]
select * from pdf where partno='LJT00RE-23-14P(SR)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.007776s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LJT00RE-23-14P(SR)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.011498s ]
SELECT `id` FROM `stock` WHERE `id` <> 61730502 AND `partno` = 'LJT00RE-23-14P(SR)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.023654s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11062459 [ RunTime:0.003206s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61703164 LIMIT 5 [ RunTime:0.001166s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61703164 ORDER BY `minOrder` ASC [ RunTime:0.003853s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61703164 ORDER BY `unit` DESC [ RunTime:0.005465s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61703164 LIMIT 2 [ RunTime:0.011070s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61703164 ORDER BY `minOrder` ASC [ RunTime:0.007112s ]
select * from pdf where partno='LJT00RE-23-14P(406)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.025765s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LJT00RE-23-14P(406)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.012386s ]
SELECT `id` FROM `stock` WHERE `id` <> 61703164 AND `partno` = 'LJT00RE-23-14P(406)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.009846s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11035649 [ RunTime:0.006123s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61703162 LIMIT 5 [ RunTime:0.015122s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61703162 ORDER BY `minOrder` ASC [ RunTime:0.027296s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61703162 ORDER BY `unit` DESC [ RunTime:0.044432s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61703162 LIMIT 2 [ RunTime:0.028631s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61703162 ORDER BY `minOrder` ASC [ RunTime:0.000520s ]
select * from pdf where partno='LJT00RE-23-14P(106)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.000783s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LJT00RE-23-14P(106)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.002900s ]
SELECT `id` FROM `stock` WHERE `id` <> 61703162 AND `partno` = 'LJT00RE-23-14P(106)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.006532s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11035646 [ RunTime:0.003815s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61703161 LIMIT 5 [ RunTime:0.000493s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61703161 ORDER BY `minOrder` ASC [ RunTime:0.000481s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61703161 ORDER BY `unit` DESC [ RunTime:0.023024s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61703161 LIMIT 2 [ RunTime:0.004994s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61703161 ORDER BY `minOrder` ASC [ RunTime:0.000679s ]
select * from pdf where partno='LJT00RE-23-14P(408)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.000829s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LJT00RE-23-14P(408)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.001943s ]
SELECT `id` FROM `stock` WHERE `id` <> 61703161 AND `partno` = 'LJT00RE-23-14P(408)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.018496s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11035645 [ RunTime:0.001266s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61703150 LIMIT 5 [ RunTime:0.002300s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61703150 ORDER BY `minOrder` ASC [ RunTime:0.003282s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61703150 ORDER BY `unit` DESC [ RunTime:0.000364s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61703150 LIMIT 2 [ RunTime:0.004013s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61703150 ORDER BY `minOrder` ASC [ RunTime:0.000268s ]
select * from pdf where partno='LJT00RE-23-14P(439)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.001864s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LJT00RE-23-14P(439)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.005783s ]
SELECT `id` FROM `stock` WHERE `id` <> 61703150 AND `partno` = 'LJT00RE-23-14P(439)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.000621s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61655776 LIMIT 5 [ RunTime:0.000358s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61655776 ORDER BY `minOrder` ASC [ RunTime:0.012547s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61655776 ORDER BY `unit` DESC [ RunTime:0.000452s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61655776 LIMIT 2 [ RunTime:0.000374s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61655776 ORDER BY `minOrder` ASC [ RunTime:0.001374s ]
select * from pdf where partno='LJT00RE-23-14P(011)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.017418s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LJT00RE-23-14P(011)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.009454s ]
SELECT `id` FROM `stock` WHERE `id` <> 61655776 AND `partno` = 'LJT00RE-23-14P(011)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.028177s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10988702 [ RunTime:0.004365s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61655767 LIMIT 5 [ RunTime:0.001646s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61655767 ORDER BY `minOrder` ASC [ RunTime:0.002938s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61655767 ORDER BY `unit` DESC [ RunTime:0.000676s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61655767 LIMIT 2 [ RunTime:0.000625s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61655767 ORDER BY `minOrder` ASC [ RunTime:0.003691s ]
select * from pdf where partno='LJT00RE-23-14P' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.011704s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LJT00RE-23-14P' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.001790s ]
SELECT `id` FROM `stock` WHERE `id` <> 61655767 AND `partno` = 'LJT00RE-23-14P' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.006288s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10988687 [ RunTime:0.000669s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61655766 LIMIT 5 [ RunTime:0.030858s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61655766 ORDER BY `minOrder` ASC [ RunTime:0.016080s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61655766 ORDER BY `unit` DESC [ RunTime:0.004569s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61655766 LIMIT 2 [ RunTime:0.005297s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61655766 ORDER BY `minOrder` ASC [ RunTime:0.002243s ]
select * from pdf where partno='LJT00RE-23-14P(023)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.005875s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LJT00RE-23-14P(023)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.001769s ]
SELECT `id` FROM `stock` WHERE `id` <> 61655766 AND `partno` = 'LJT00RE-23-14P(023)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.015602s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10988686 [ RunTime:0.006964s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61166750 LIMIT 5 [ RunTime:0.008084s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61166750 ORDER BY `minOrder` ASC [ RunTime:0.002682s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61166750 ORDER BY `unit` DESC [ RunTime:0.008094s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61166750 LIMIT 2 [ RunTime:0.025683s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61166750 ORDER BY `minOrder` ASC [ RunTime:0.010239s ]
select * from pdf where partno='LJT00RE-23-14P(386)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.001598s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LJT00RE-23-14P(386)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.015187s ]
SELECT `id` FROM `stock` WHERE `id` <> 61166750 AND `partno` = 'LJT00RE-23-14P(386)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.006949s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11062461 [ RunTime:0.002733s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61164669 LIMIT 5 [ RunTime:0.002107s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61164669 ORDER BY `minOrder` ASC [ RunTime:0.003266s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61164669 ORDER BY `unit` DESC [ RunTime:0.001502s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61164669 LIMIT 2 [ RunTime:0.000694s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61164669 ORDER BY `minOrder` ASC [ RunTime:0.002034s ]
select * from pdf where partno='LJT00RE-23-14P(014)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.012300s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LJT00RE-23-14P(014)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.019527s ]
SELECT `id` FROM `stock` WHERE `id` <> 61164669 AND `partno` = 'LJT00RE-23-14P(014)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.008869s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10988494 [ RunTime:0.003921s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60205709 LIMIT 5 [ RunTime:0.002559s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60205709 ORDER BY `minOrder` ASC [ RunTime:0.006163s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60205709 ORDER BY `unit` DESC [ RunTime:0.003050s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60205709 LIMIT 2 [ RunTime:0.000642s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60205709 ORDER BY `minOrder` ASC [ RunTime:0.002823s ]
select * from pdf where partno='LJT00RE-23-14P(011LC)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.003765s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LJT00RE-23-14P(011LC)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.000848s ]
SELECT `id` FROM `stock` WHERE `id` <> 60205709 AND `partno` = 'LJT00RE-23-14P(011LC)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.000631s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60205708 LIMIT 5 [ RunTime:0.000466s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60205708 ORDER BY `minOrder` ASC [ RunTime:0.004729s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60205708 ORDER BY `unit` DESC [ RunTime:0.000675s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60205708 LIMIT 2 [ RunTime:0.001174s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60205708 ORDER BY `minOrder` ASC [ RunTime:0.005755s ]
select * from pdf where partno='LJT00RE-23-14P(023LC)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.005364s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LJT00RE-23-14P(023LC)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.002680s ]
SELECT `id` FROM `stock` WHERE `id` <> 60205708 AND `partno` = 'LJT00RE-23-14P(023LC)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.004321s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60205706 LIMIT 5 [ RunTime:0.000619s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60205706 ORDER BY `minOrder` ASC [ RunTime:0.000662s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60205706 ORDER BY `unit` DESC [ RunTime:0.000548s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60205706 LIMIT 2 [ RunTime:0.010595s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60205706 ORDER BY `minOrder` ASC [ RunTime:0.000465s ]
select * from pdf where partno='LJT00RE-23-14P(LC)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.009613s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LJT00RE-23-14P(LC)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.001227s ]
SELECT `id` FROM `stock` WHERE `id` <> 60205706 AND `partno` = 'LJT00RE-23-14P(LC)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.006400s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16376561 [ RunTime:0.008923s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60205622 LIMIT 5 [ RunTime:0.007085s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60205622 ORDER BY `minOrder` ASC [ RunTime:0.010072s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60205622 ORDER BY `unit` DESC [ RunTime:0.000729s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60205622 LIMIT 2 [ RunTime:0.002981s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60205622 ORDER BY `minOrder` ASC [ RunTime:0.000338s ]
select * from pdf where partno='LJT00RE-23-14PD(LC)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.001039s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LJT00RE-23-14PD(LC)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.003986s ]
SELECT `id` FROM `stock` WHERE `id` <> 60205622 AND `partno` = 'LJT00RE-23-14PD(LC)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.008683s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60205621 LIMIT 5 [ RunTime:0.023955s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60205621 ORDER BY `minOrder` ASC [ RunTime:0.014590s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60205621 ORDER BY `unit` DESC [ RunTime:0.015492s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60205621 LIMIT 2 [ RunTime:0.026832s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60205621 ORDER BY `minOrder` ASC [ RunTime:0.001514s ]
select * from pdf where partno='LJT00RE-23-14PC(LC)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.000967s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LJT00RE-23-14PC(LC)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.006928s ]
SELECT `id` FROM `stock` WHERE `id` <> 60205621 AND `partno` = 'LJT00RE-23-14PC(LC)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.006922s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60205620 LIMIT 5 [ RunTime:0.007994s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60205620 ORDER BY `minOrder` ASC [ RunTime:0.021554s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60205620 ORDER BY `unit` DESC [ RunTime:0.010233s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60205620 LIMIT 2 [ RunTime:0.010837s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60205620 ORDER BY `minOrder` ASC [ RunTime:0.020411s ]
select * from pdf where partno='LJT00RE-23-14PD(023LC)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.003131s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LJT00RE-23-14PD(023LC)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.010824s ]
SELECT `id` FROM `stock` WHERE `id` <> 60205620 AND `partno` = 'LJT00RE-23-14PD(023LC)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.027470s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60205617 LIMIT 5 [ RunTime:0.019945s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60205617 ORDER BY `minOrder` ASC [ RunTime:0.025941s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60205617 ORDER BY `unit` DESC [ RunTime:0.024981s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60205617 LIMIT 2 [ RunTime:0.009455s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60205617 ORDER BY `minOrder` ASC [ RunTime:0.010207s ]
select * from pdf where partno='LJT00RE-23-14PD(011LC)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.031287s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LJT00RE-23-14PD(011LC)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.010538s ]
SELECT `id` FROM `stock` WHERE `id` <> 60205617 AND `partno` = 'LJT00RE-23-14PD(011LC)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.029606s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60205616 LIMIT 5 [ RunTime:0.019401s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60205616 ORDER BY `minOrder` ASC [ RunTime:0.038374s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60205616 ORDER BY `unit` DESC [ RunTime:0.040574s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60205616 LIMIT 2 [ RunTime:0.020865s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60205616 ORDER BY `minOrder` ASC [ RunTime:0.003525s ]
select * from pdf where partno='LJT00RE-23-14PC(023LC)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.000836s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LJT00RE-23-14PC(023LC)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.003857s ]
SELECT `id` FROM `stock` WHERE `id` <> 60205616 AND `partno` = 'LJT00RE-23-14PC(023LC)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.000876s ]
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 'LJT00RE-23-14P%' OR `brand` LIKE 'LJT00RE-23-14P%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011363s ]
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 'LJT00RE-23-14P%' OR `brand` LIKE 'LJT00RE-23-14P%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008184s ]
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 'LJT00RE-23-14P%' OR `brand` LIKE 'LJT00RE-23-14P%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012843s ]
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 'LJT00RE-23-14P%' OR `brand` LIKE 'LJT00RE-23-14P%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001724s ]
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 'LJT00RE-23-14P%' OR `brand` LIKE 'LJT00RE-23-14P%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001298s ]
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 'LJT00RE-23-14P%' OR `brand` LIKE 'LJT00RE-23-14P%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003234s ]
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 'LJT00RE-23-14P%' OR `brand` LIKE 'LJT00RE-23-14P%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017211s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'LJT00RE-23-14P%' OR `brand` LIKE 'LJT00RE-23-14P%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.001105s ]