SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001412s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.133' , `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=JT00P-10-98P&search=1' [ RunTime:0.002790s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001619s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.001794s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002138s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.133' ) [ RunTime:0.000326s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001256s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000278s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001743s ]
SELECT * FROM `stock_search` WHERE `partno` = 'JT00P-10-98P' LIMIT 1 [ RunTime:0.001104s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-08-24 10:36:20' WHERE `partno` = 'JT00P-10-98P' [ RunTime:0.013261s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001717s ]
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 'JT00P-10-98P%' OR `brand` LIKE 'JT00P-10-98P%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.029315s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001335s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12962640 LIMIT 5 [ RunTime:0.008725s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002257s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12962640 ORDER BY `minOrder` ASC [ RunTime:0.015499s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.004078s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12962640 ORDER BY `unit` DESC [ RunTime:0.009335s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.014247s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12962640 LIMIT 2 [ RunTime:0.059035s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12962640 ORDER BY `minOrder` ASC [ RunTime:0.042705s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12962639 LIMIT 5 [ RunTime:0.036810s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12962639 ORDER BY `minOrder` ASC [ RunTime:0.020343s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12962639 ORDER BY `unit` DESC [ RunTime:0.021259s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12962639 LIMIT 2 [ RunTime:0.062306s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12962639 ORDER BY `minOrder` ASC [ RunTime:0.049278s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12962638 LIMIT 5 [ RunTime:0.031931s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12962638 ORDER BY `minOrder` ASC [ RunTime:0.042947s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12962638 ORDER BY `unit` DESC [ RunTime:0.028665s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12962638 LIMIT 2 [ RunTime:0.065997s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12962638 ORDER BY `minOrder` ASC [ RunTime:0.010850s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12961684 LIMIT 5 [ RunTime:0.039985s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12961684 ORDER BY `minOrder` ASC [ RunTime:0.031834s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12961684 ORDER BY `unit` DESC [ RunTime:0.068369s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12961684 LIMIT 2 [ RunTime:0.066194s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12961684 ORDER BY `minOrder` ASC [ RunTime:0.008858s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12961683 LIMIT 5 [ RunTime:0.046239s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12961683 ORDER BY `minOrder` ASC [ RunTime:0.058669s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12961683 ORDER BY `unit` DESC [ RunTime:0.014076s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12961683 LIMIT 2 [ RunTime:0.038814s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12961683 ORDER BY `minOrder` ASC [ RunTime:0.039539s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12961682 LIMIT 5 [ RunTime:0.017030s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12961682 ORDER BY `minOrder` ASC [ RunTime:0.024155s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12961682 ORDER BY `unit` DESC [ RunTime:0.034373s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12961682 LIMIT 2 [ RunTime:0.035735s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12961682 ORDER BY `minOrder` ASC [ RunTime:0.021404s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12961681 LIMIT 5 [ RunTime:0.036825s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12961681 ORDER BY `minOrder` ASC [ RunTime:0.010967s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12961681 ORDER BY `unit` DESC [ RunTime:0.017789s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12961681 LIMIT 2 [ RunTime:0.030228s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12961681 ORDER BY `minOrder` ASC [ RunTime:0.007006s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12961680 LIMIT 5 [ RunTime:0.011958s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12961680 ORDER BY `minOrder` ASC [ RunTime:0.003390s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12961680 ORDER BY `unit` DESC [ RunTime:0.011589s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12961680 LIMIT 2 [ RunTime:0.015454s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12961680 ORDER BY `minOrder` ASC [ RunTime:0.010990s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12961679 LIMIT 5 [ RunTime:0.006072s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12961679 ORDER BY `minOrder` ASC [ RunTime:0.024764s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12961679 ORDER BY `unit` DESC [ RunTime:0.009009s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12961679 LIMIT 2 [ RunTime:0.012939s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12961679 ORDER BY `minOrder` ASC [ RunTime:0.014619s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12961678 LIMIT 5 [ RunTime:0.044732s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12961678 ORDER BY `minOrder` ASC [ RunTime:0.059160s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12961678 ORDER BY `unit` DESC [ RunTime:0.010856s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12961678 LIMIT 2 [ RunTime:0.024581s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12961678 ORDER BY `minOrder` ASC [ RunTime:0.013615s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12961677 LIMIT 5 [ RunTime:0.001240s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12961677 ORDER BY `minOrder` ASC [ RunTime:0.019751s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12961677 ORDER BY `unit` DESC [ RunTime:0.027905s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12961677 LIMIT 2 [ RunTime:0.043045s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12961677 ORDER BY `minOrder` ASC [ RunTime:0.006255s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12961676 LIMIT 5 [ RunTime:0.004800s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12961676 ORDER BY `minOrder` ASC [ RunTime:0.037084s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12961676 ORDER BY `unit` DESC [ RunTime:0.053603s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12961676 LIMIT 2 [ RunTime:0.033881s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12961676 ORDER BY `minOrder` ASC [ RunTime:0.016252s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12961675 LIMIT 5 [ RunTime:0.005532s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12961675 ORDER BY `minOrder` ASC [ RunTime:0.014321s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12961675 ORDER BY `unit` DESC [ RunTime:0.016986s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12961675 LIMIT 2 [ RunTime:0.008791s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12961675 ORDER BY `minOrder` ASC [ RunTime:0.030457s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12961674 LIMIT 5 [ RunTime:0.016191s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12961674 ORDER BY `minOrder` ASC [ RunTime:0.011632s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12961674 ORDER BY `unit` DESC [ RunTime:0.006688s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12961674 LIMIT 2 [ RunTime:0.012300s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12961674 ORDER BY `minOrder` ASC [ RunTime:0.010325s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12961673 LIMIT 5 [ RunTime:0.007777s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12961673 ORDER BY `minOrder` ASC [ RunTime:0.041715s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12961673 ORDER BY `unit` DESC [ RunTime:0.023227s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12961673 LIMIT 2 [ RunTime:0.008359s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12961673 ORDER BY `minOrder` ASC [ RunTime:0.013860s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12961672 LIMIT 5 [ RunTime:0.030147s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12961672 ORDER BY `minOrder` ASC [ RunTime:0.025296s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12961672 ORDER BY `unit` DESC [ RunTime:0.018043s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12961672 LIMIT 2 [ RunTime:0.029960s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12961672 ORDER BY `minOrder` ASC [ RunTime:0.000768s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12961671 LIMIT 5 [ RunTime:0.033422s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12961671 ORDER BY `minOrder` ASC [ RunTime:0.029785s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12961671 ORDER BY `unit` DESC [ RunTime:0.048643s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12961671 LIMIT 2 [ RunTime:0.012237s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12961671 ORDER BY `minOrder` ASC [ RunTime:0.042186s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12961670 LIMIT 5 [ RunTime:0.033925s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12961670 ORDER BY `minOrder` ASC [ RunTime:0.028612s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12961670 ORDER BY `unit` DESC [ RunTime:0.048265s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12961670 LIMIT 2 [ RunTime:0.019504s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12961670 ORDER BY `minOrder` ASC [ RunTime:0.013008s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12961669 LIMIT 5 [ RunTime:0.023983s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12961669 ORDER BY `minOrder` ASC [ RunTime:0.048470s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12961669 ORDER BY `unit` DESC [ RunTime:0.019236s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12961669 LIMIT 2 [ RunTime:0.012302s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12961669 ORDER BY `minOrder` ASC [ RunTime:0.026182s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12961668 LIMIT 5 [ RunTime:0.013144s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12961668 ORDER BY `minOrder` ASC [ RunTime:0.035929s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12961668 ORDER BY `unit` DESC [ RunTime:0.014995s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12961668 LIMIT 2 [ RunTime:0.030408s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12961668 ORDER BY `minOrder` ASC [ RunTime:0.008929s ]
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 'JT00P-10-98P%' OR `brand` LIKE 'JT00P-10-98P%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013094s ]
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 'JT00P-10-98P%' OR `brand` LIKE 'JT00P-10-98P%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.036237s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60275136 LIMIT 5 [ RunTime:0.020884s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60275136 ORDER BY `minOrder` ASC [ RunTime:0.028728s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60275136 ORDER BY `unit` DESC [ RunTime:0.012546s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60275136 LIMIT 2 [ RunTime:0.033713s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60275136 ORDER BY `minOrder` ASC [ RunTime:0.007608s ]
select * from pdf where partno='JT00P-10-98PC(105)(LC)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.021073s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.003475s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'JT00P-10-98PC(105)(LC)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.024271s ]
SELECT `id` FROM `stock` WHERE `id` <> 60275136 AND `partno` = 'JT00P-10-98PC(105)(LC)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.005287s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60275135 LIMIT 5 [ RunTime:0.015364s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60275135 ORDER BY `minOrder` ASC [ RunTime:0.010926s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60275135 ORDER BY `unit` DESC [ RunTime:0.020529s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60275135 LIMIT 2 [ RunTime:0.024508s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60275135 ORDER BY `minOrder` ASC [ RunTime:0.005486s ]
select * from pdf where partno='JT00P-10-98PA(105)(LC)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.017386s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'JT00P-10-98PA(105)(LC)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.018816s ]
SELECT `id` FROM `stock` WHERE `id` <> 60275135 AND `partno` = 'JT00P-10-98PA(105)(LC)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.044511s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12962640 [ RunTime:0.026785s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60275134 LIMIT 5 [ RunTime:0.034681s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60275134 ORDER BY `minOrder` ASC [ RunTime:0.024413s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60275134 ORDER BY `unit` DESC [ RunTime:0.014701s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60275134 LIMIT 2 [ RunTime:0.024003s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60275134 ORDER BY `minOrder` ASC [ RunTime:0.007541s ]
select * from pdf where partno='JT00P-10-98PD(105)(LC)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.007306s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'JT00P-10-98PD(105)(LC)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.003982s ]
SELECT `id` FROM `stock` WHERE `id` <> 60275134 AND `partno` = 'JT00P-10-98PD(105)(LC)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.019117s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12962639 [ RunTime:0.009330s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60275133 LIMIT 5 [ RunTime:0.008623s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60275133 ORDER BY `minOrder` ASC [ RunTime:0.032588s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60275133 ORDER BY `unit` DESC [ RunTime:0.007833s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60275133 LIMIT 2 [ RunTime:0.010111s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60275133 ORDER BY `minOrder` ASC [ RunTime:0.006468s ]
select * from pdf where partno='JT00P-10-98PB(105)(LC)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.045407s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'JT00P-10-98PB(105)(LC)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.036428s ]
SELECT `id` FROM `stock` WHERE `id` <> 60275133 AND `partno` = 'JT00P-10-98PB(105)(LC)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.048683s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12962638 [ RunTime:0.023874s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60272356 LIMIT 5 [ RunTime:0.038739s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60272356 ORDER BY `minOrder` ASC [ RunTime:0.027186s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60272356 ORDER BY `unit` DESC [ RunTime:0.067530s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60272356 LIMIT 2 [ RunTime:0.044683s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60272356 ORDER BY `minOrder` ASC [ RunTime:0.013267s ]
select * from pdf where partno='JT00P-10-98PD(001)(LC)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.026659s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'JT00P-10-98PD(001)(LC)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.024729s ]
SELECT `id` FROM `stock` WHERE `id` <> 60272356 AND `partno` = 'JT00P-10-98PD(001)(LC)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.061976s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12961684 [ RunTime:0.033016s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60272355 LIMIT 5 [ RunTime:0.050032s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60272355 ORDER BY `minOrder` ASC [ RunTime:0.096170s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60272355 ORDER BY `unit` DESC [ RunTime:0.010540s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60272355 LIMIT 2 [ RunTime:0.028433s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60272355 ORDER BY `minOrder` ASC [ RunTime:0.011927s ]
select * from pdf where partno='JT00P-10-98PD(003)(LC)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.014681s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'JT00P-10-98PD(003)(LC)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.020900s ]
SELECT `id` FROM `stock` WHERE `id` <> 60272355 AND `partno` = 'JT00P-10-98PD(003)(LC)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.020187s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11739526 [ RunTime:0.008579s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60272354 LIMIT 5 [ RunTime:0.052699s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60272354 ORDER BY `minOrder` ASC [ RunTime:0.053270s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60272354 ORDER BY `unit` DESC [ RunTime:0.010694s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60272354 LIMIT 2 [ RunTime:0.038034s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60272354 ORDER BY `minOrder` ASC [ RunTime:0.026811s ]
select * from pdf where partno='JT00P-10-98PD(004)(LC)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.013208s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'JT00P-10-98PD(004)(LC)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.035544s ]
SELECT `id` FROM `stock` WHERE `id` <> 60272354 AND `partno` = 'JT00P-10-98PD(004)(LC)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.008277s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12961683 [ RunTime:0.024416s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60272353 LIMIT 5 [ RunTime:0.023390s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60272353 ORDER BY `minOrder` ASC [ RunTime:0.058728s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60272353 ORDER BY `unit` DESC [ RunTime:0.006581s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60272353 LIMIT 2 [ RunTime:0.028617s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60272353 ORDER BY `minOrder` ASC [ RunTime:0.035471s ]
select * from pdf where partno='JT00P-10-98PD(011)(LC)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.026854s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'JT00P-10-98PD(011)(LC)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.017921s ]
SELECT `id` FROM `stock` WHERE `id` <> 60272353 AND `partno` = 'JT00P-10-98PD(011)(LC)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.007267s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11739525 [ RunTime:0.013056s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60272352 LIMIT 5 [ RunTime:0.025849s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60272352 ORDER BY `minOrder` ASC [ RunTime:0.019956s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60272352 ORDER BY `unit` DESC [ RunTime:0.005634s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60272352 LIMIT 2 [ RunTime:0.012578s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60272352 ORDER BY `minOrder` ASC [ RunTime:0.008242s ]
select * from pdf where partno='JT00P-10-98PD(021)(LC)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.016115s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'JT00P-10-98PD(021)(LC)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.003644s ]
SELECT `id` FROM `stock` WHERE `id` <> 60272352 AND `partno` = 'JT00P-10-98PD(021)(LC)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.007159s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12961682 [ RunTime:0.005625s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60272351 LIMIT 5 [ RunTime:0.008551s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60272351 ORDER BY `minOrder` ASC [ RunTime:0.007856s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60272351 ORDER BY `unit` DESC [ RunTime:0.000705s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60272351 LIMIT 2 [ RunTime:0.000660s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60272351 ORDER BY `minOrder` ASC [ RunTime:0.003940s ]
select * from pdf where partno='JT00P-10-98PD(014)(LC)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.004301s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'JT00P-10-98PD(014)(LC)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.003669s ]
SELECT `id` FROM `stock` WHERE `id` <> 60272351 AND `partno` = 'JT00P-10-98PD(014)(LC)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.009835s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60272350 LIMIT 5 [ RunTime:0.006650s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60272350 ORDER BY `minOrder` ASC [ RunTime:0.006656s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60272350 ORDER BY `unit` DESC [ RunTime:0.005036s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60272350 LIMIT 2 [ RunTime:0.011497s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60272350 ORDER BY `minOrder` ASC [ RunTime:0.006093s ]
select * from pdf where partno='JT00P-10-98PD(023)(LC)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.011680s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'JT00P-10-98PD(023)(LC)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.009590s ]
SELECT `id` FROM `stock` WHERE `id` <> 60272350 AND `partno` = 'JT00P-10-98PD(023)(LC)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.010544s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11739524 [ RunTime:0.005411s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60272349 LIMIT 5 [ RunTime:0.004198s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60272349 ORDER BY `minOrder` ASC [ RunTime:0.005976s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60272349 ORDER BY `unit` DESC [ RunTime:0.001398s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60272349 LIMIT 2 [ RunTime:0.000689s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60272349 ORDER BY `minOrder` ASC [ RunTime:0.002648s ]
select * from pdf where partno='JT00P-10-98PD(009)(LC)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.012176s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'JT00P-10-98PD(009)(LC)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.008929s ]
SELECT `id` FROM `stock` WHERE `id` <> 60272349 AND `partno` = 'JT00P-10-98PD(009)(LC)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.004099s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11739523 [ RunTime:0.003261s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60272348 LIMIT 5 [ RunTime:0.004959s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60272348 ORDER BY `minOrder` ASC [ RunTime:0.011330s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60272348 ORDER BY `unit` DESC [ RunTime:0.000762s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60272348 LIMIT 2 [ RunTime:0.000694s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60272348 ORDER BY `minOrder` ASC [ RunTime:0.004095s ]
select * from pdf where partno='JT00P-10-98PD(005)(LC)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.003967s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'JT00P-10-98PD(005)(LC)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.002634s ]
SELECT `id` FROM `stock` WHERE `id` <> 60272348 AND `partno` = 'JT00P-10-98PD(005)(LC)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.005790s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11739522 [ RunTime:0.005714s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60272347 LIMIT 5 [ RunTime:0.015080s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60272347 ORDER BY `minOrder` ASC [ RunTime:0.000899s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60272347 ORDER BY `unit` DESC [ RunTime:0.009121s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60272347 LIMIT 2 [ RunTime:0.009833s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60272347 ORDER BY `minOrder` ASC [ RunTime:0.002901s ]
select * from pdf where partno='JT00P-10-98PA(011)(LC)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.003207s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'JT00P-10-98PA(011)(LC)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.005945s ]
SELECT `id` FROM `stock` WHERE `id` <> 60272347 AND `partno` = 'JT00P-10-98PA(011)(LC)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.011202s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12961681 [ RunTime:0.021603s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60272346 LIMIT 5 [ RunTime:0.011570s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60272346 ORDER BY `minOrder` ASC [ RunTime:0.020618s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60272346 ORDER BY `unit` DESC [ RunTime:0.003420s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60272346 LIMIT 2 [ RunTime:0.010079s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60272346 ORDER BY `minOrder` ASC [ RunTime:0.002665s ]
select * from pdf where partno='JT00P-10-98PA(004)(LC)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.003034s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'JT00P-10-98PA(004)(LC)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.003955s ]
SELECT `id` FROM `stock` WHERE `id` <> 60272346 AND `partno` = 'JT00P-10-98PA(004)(LC)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.002471s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11739521 [ RunTime:0.009921s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60272345 LIMIT 5 [ RunTime:0.001417s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60272345 ORDER BY `minOrder` ASC [ RunTime:0.003534s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60272345 ORDER BY `unit` DESC [ RunTime:0.010164s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60272345 LIMIT 2 [ RunTime:0.000760s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60272345 ORDER BY `minOrder` ASC [ RunTime:0.007330s ]
select * from pdf where partno='JT00P-10-98PA(021)(LC)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.005942s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'JT00P-10-98PA(021)(LC)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.001416s ]
SELECT `id` FROM `stock` WHERE `id` <> 60272345 AND `partno` = 'JT00P-10-98PA(021)(LC)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.013719s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12961680 [ RunTime:0.011467s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60272344 LIMIT 5 [ RunTime:0.020436s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60272344 ORDER BY `minOrder` ASC [ RunTime:0.027173s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60272344 ORDER BY `unit` DESC [ RunTime:0.000777s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60272344 LIMIT 2 [ RunTime:0.006235s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60272344 ORDER BY `minOrder` ASC [ RunTime:0.002204s ]
select * from pdf where partno='JT00P-10-98PA(005)(LC)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.010758s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'JT00P-10-98PA(005)(LC)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.009119s ]
SELECT `id` FROM `stock` WHERE `id` <> 60272344 AND `partno` = 'JT00P-10-98PA(005)(LC)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.012653s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12961679 [ RunTime:0.006962s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60272343 LIMIT 5 [ RunTime:0.006147s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60272343 ORDER BY `minOrder` ASC [ RunTime:0.011331s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60272343 ORDER BY `unit` DESC [ RunTime:0.007999s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60272343 LIMIT 2 [ RunTime:0.009472s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60272343 ORDER BY `minOrder` ASC [ RunTime:0.013689s ]
select * from pdf where partno='JT00P-10-98PA(014)(LC)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.014761s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'JT00P-10-98PA(014)(LC)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.011491s ]
SELECT `id` FROM `stock` WHERE `id` <> 60272343 AND `partno` = 'JT00P-10-98PA(014)(LC)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.029059s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12961678 [ RunTime:0.022882s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60272342 LIMIT 5 [ RunTime:0.027684s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60272342 ORDER BY `minOrder` ASC [ RunTime:0.045948s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60272342 ORDER BY `unit` DESC [ RunTime:0.014736s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60272342 LIMIT 2 [ RunTime:0.001800s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60272342 ORDER BY `minOrder` ASC [ RunTime:0.011228s ]
select * from pdf where partno='JT00P-10-98PA(003)(LC)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.027956s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'JT00P-10-98PA(003)(LC)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.013901s ]
SELECT `id` FROM `stock` WHERE `id` <> 60272342 AND `partno` = 'JT00P-10-98PA(003)(LC)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.021294s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12961677 [ RunTime:0.017826s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60272341 LIMIT 5 [ RunTime:0.032389s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60272341 ORDER BY `minOrder` ASC [ RunTime:0.065458s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60272341 ORDER BY `unit` DESC [ RunTime:0.027530s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60272341 LIMIT 2 [ RunTime:0.023031s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60272341 ORDER BY `minOrder` ASC [ RunTime:0.024150s ]
select * from pdf where partno='JT00P-10-98PA(009)(LC)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.024718s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'JT00P-10-98PA(009)(LC)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.025841s ]
SELECT `id` FROM `stock` WHERE `id` <> 60272341 AND `partno` = 'JT00P-10-98PA(009)(LC)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.026742s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12961676 [ RunTime:0.014251s ]
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 'JT00P-10-98P%' OR `brand` LIKE 'JT00P-10-98P%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.025043s ]
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 'JT00P-10-98P%' OR `brand` LIKE 'JT00P-10-98P%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.032746s ]
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 'JT00P-10-98P%' OR `brand` LIKE 'JT00P-10-98P%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006762s ]
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 'JT00P-10-98P%' OR `brand` LIKE 'JT00P-10-98P%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010356s ]
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 'JT00P-10-98P%' OR `brand` LIKE 'JT00P-10-98P%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011752s ]
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 'JT00P-10-98P%' OR `brand` LIKE 'JT00P-10-98P%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011674s ]
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 'JT00P-10-98P%' OR `brand` LIKE 'JT00P-10-98P%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003209s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'JT00P-10-98P%' OR `brand` LIKE 'JT00P-10-98P%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.018970s ]