SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001220s ]
INSERT INTO `visit_log` SET `ip` = '216.73.217.142' , `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=89038&search=1' [ RunTime:0.004579s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001508s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.008728s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001375s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.142' ) [ RunTime:0.007732s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001241s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.003536s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001401s ]
SELECT * FROM `stock_search` WHERE `partno` = '89038' LIMIT 1 [ RunTime:0.027469s ]
UPDATE `stock_search` SET `count` = 3 , `updatetime` = '2026-08-02 02:08:26' WHERE `partno` = '89038' [ RunTime:0.010069s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001732s ]
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 '89038%' OR `brand` LIKE '89038%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.029858s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.018209s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11406278 LIMIT 5 [ RunTime:0.045673s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.004055s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11406278 ORDER BY `minOrder` ASC [ RunTime:0.008077s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001214s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11406278 ORDER BY `unit` DESC [ RunTime:0.032489s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002276s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11406278 LIMIT 2 [ RunTime:0.026208s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11406278 ORDER BY `minOrder` ASC [ RunTime:0.033922s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18714373 LIMIT 5 [ RunTime:0.048700s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18714373 ORDER BY `minOrder` ASC [ RunTime:0.033453s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18714373 ORDER BY `unit` DESC [ RunTime:0.033080s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18714373 LIMIT 2 [ RunTime:0.068156s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18714373 ORDER BY `minOrder` ASC [ RunTime:0.025162s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16997102 LIMIT 5 [ RunTime:0.020025s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16997102 ORDER BY `minOrder` ASC [ RunTime:0.017030s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16997102 ORDER BY `unit` DESC [ RunTime:0.059471s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16997102 LIMIT 2 [ RunTime:0.122206s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16997102 ORDER BY `minOrder` ASC [ RunTime:0.019209s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16996630 LIMIT 5 [ RunTime:0.084840s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16996630 ORDER BY `minOrder` ASC [ RunTime:0.036159s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16996630 ORDER BY `unit` DESC [ RunTime:0.060567s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16996630 LIMIT 2 [ RunTime:0.058879s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16996630 ORDER BY `minOrder` ASC [ RunTime:0.025935s ]
select * from pdf where partno='890382' and brandshort='3M' limit 1 [ RunTime:0.078260s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12500118 LIMIT 5 [ RunTime:0.067891s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12500118 ORDER BY `minOrder` ASC [ RunTime:0.064138s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12500118 ORDER BY `unit` DESC [ RunTime:0.053359s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12500118 LIMIT 2 [ RunTime:0.028897s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12500118 ORDER BY `minOrder` ASC [ RunTime:0.026768s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12496549 LIMIT 5 [ RunTime:0.060833s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12496549 ORDER BY `minOrder` ASC [ RunTime:0.056391s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12496549 ORDER BY `unit` DESC [ RunTime:0.048241s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12496549 LIMIT 2 [ RunTime:0.027772s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12496549 ORDER BY `minOrder` ASC [ RunTime:0.008331s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12491055 LIMIT 5 [ RunTime:0.024962s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12491055 ORDER BY `minOrder` ASC [ RunTime:0.036975s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12491055 ORDER BY `unit` DESC [ RunTime:0.062007s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12491055 LIMIT 2 [ RunTime:0.068955s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12491055 ORDER BY `minOrder` ASC [ RunTime:0.031966s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12489672 LIMIT 5 [ RunTime:0.067515s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12489672 ORDER BY `minOrder` ASC [ RunTime:0.049540s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12489672 ORDER BY `unit` DESC [ RunTime:0.056065s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12489672 LIMIT 2 [ RunTime:0.035274s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12489672 ORDER BY `minOrder` ASC [ RunTime:0.008611s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11406432 LIMIT 5 [ RunTime:0.053008s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11406432 ORDER BY `minOrder` ASC [ RunTime:0.059147s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11406432 ORDER BY `unit` DESC [ RunTime:0.037416s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11406432 LIMIT 2 [ RunTime:0.015335s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11406432 ORDER BY `minOrder` ASC [ RunTime:0.004118s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11406405 LIMIT 5 [ RunTime:0.070130s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11406405 ORDER BY `minOrder` ASC [ RunTime:0.080785s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11406405 ORDER BY `unit` DESC [ RunTime:0.014813s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11406405 LIMIT 2 [ RunTime:0.046877s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11406405 ORDER BY `minOrder` ASC [ RunTime:0.027622s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11402006 LIMIT 5 [ RunTime:0.056396s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11402006 ORDER BY `minOrder` ASC [ RunTime:0.082384s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11402006 ORDER BY `unit` DESC [ RunTime:0.091464s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11402006 LIMIT 2 [ RunTime:0.038921s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11402006 ORDER BY `minOrder` ASC [ RunTime:0.018933s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11401958 LIMIT 5 [ RunTime:0.045115s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11401958 ORDER BY `minOrder` ASC [ RunTime:0.068485s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11401958 ORDER BY `unit` DESC [ RunTime:0.040208s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11401958 LIMIT 2 [ RunTime:0.051237s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11401958 ORDER BY `minOrder` ASC [ RunTime:0.013662s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11192249 LIMIT 5 [ RunTime:0.042890s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11192249 ORDER BY `minOrder` ASC [ RunTime:0.081833s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11192249 ORDER BY `unit` DESC [ RunTime:0.016513s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11192249 LIMIT 2 [ RunTime:0.039131s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11192249 ORDER BY `minOrder` ASC [ RunTime:0.047417s ]
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 '89038%' OR `brand` LIKE '89038%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.045648s ]
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 '89038%' OR `brand` LIKE '89038%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.075880s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57621487 LIMIT 5 [ RunTime:0.013145s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57621487 ORDER BY `minOrder` ASC [ RunTime:0.043812s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57621487 ORDER BY `unit` DESC [ RunTime:0.030654s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57621487 LIMIT 2 [ RunTime:0.043283s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57621487 ORDER BY `minOrder` ASC [ RunTime:0.026422s ]
select * from pdf where partno='890389' and brandshort='3M' limit 1 [ RunTime:0.017168s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002630s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '890389' OR `brand` LIKE '3M%' ) ) LIMIT 1 [ RunTime:0.027190s ]
SELECT `id` FROM `stock` WHERE `id` <> 57621487 AND `partno` = '890389' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%3m%' ) [ RunTime:0.140806s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16997102 [ RunTime:0.057308s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57619552 LIMIT 5 [ RunTime:0.042034s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57619552 ORDER BY `minOrder` ASC [ RunTime:0.067763s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57619552 ORDER BY `unit` DESC [ RunTime:0.063042s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57619552 LIMIT 2 [ RunTime:0.027047s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57619552 ORDER BY `minOrder` ASC [ RunTime:0.060415s ]
select * from pdf where partno='890386' and brandshort='3M' limit 1 [ RunTime:0.010902s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '890386' OR `brand` LIKE '3M%' ) ) LIMIT 1 [ RunTime:0.066765s ]
SELECT `id` FROM `stock` WHERE `id` <> 57619552 AND `partno` = '890386' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%3m%' ) [ RunTime:0.063346s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18714373 [ RunTime:0.046963s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57618567 LIMIT 5 [ RunTime:0.047541s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57618567 ORDER BY `minOrder` ASC [ RunTime:0.030863s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57618567 ORDER BY `unit` DESC [ RunTime:0.085715s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57618567 LIMIT 2 [ RunTime:0.064578s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57618567 ORDER BY `minOrder` ASC [ RunTime:0.081559s ]
select * from pdf where partno='890382' and brandshort='3M' limit 1 [ RunTime:0.029947s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '890382' OR `brand` LIKE '3M%' ) ) LIMIT 1 [ RunTime:0.038957s ]
SELECT `id` FROM `stock` WHERE `id` <> 57618567 AND `partno` = '890382' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%3m%' ) [ RunTime:0.062699s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16996630 [ RunTime:0.167812s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56413593 LIMIT 5 [ RunTime:0.074470s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56413593 ORDER BY `minOrder` ASC [ RunTime:0.069230s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56413593 ORDER BY `unit` DESC [ RunTime:0.048299s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56413593 LIMIT 2 [ RunTime:0.058408s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56413593 ORDER BY `minOrder` ASC [ RunTime:0.040659s ]
select * from pdf where partno='89038-02500270-21' and brandshort='Honeywell Sensing and Productivity Solutions' limit 1 [ RunTime:0.067373s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '89038-02500270-21' OR `brand` LIKE 'Honeywell Sensing and Productivity Solutions%' ) ) LIMIT 1 [ RunTime:0.039651s ]
SELECT `id` FROM `stock` WHERE `id` <> 56413593 AND `partno` = '89038-02500270-21' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%honeywell sensing and productivity solutions%' ) [ RunTime:0.068283s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 54126626 LIMIT 5 [ RunTime:0.090133s ]
SELECT * FROM `stock_price` WHERE `stockid` = 54126626 ORDER BY `minOrder` ASC [ RunTime:0.089087s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 54126626 ORDER BY `unit` DESC [ RunTime:0.069616s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 54126626 LIMIT 2 [ RunTime:0.075588s ]
SELECT * FROM `stock_price` WHERE `stockid` = 54126626 ORDER BY `minOrder` ASC [ RunTime:0.036091s ]
select * from pdf where partno='89038-111LF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.038916s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '89038-111LF' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.021009s ]
SELECT `id` FROM `stock` WHERE `id` <> 54126626 AND `partno` = '89038-111LF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.046429s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12491055 [ RunTime:0.084093s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 54125002 LIMIT 5 [ RunTime:0.062733s ]
SELECT * FROM `stock_price` WHERE `stockid` = 54125002 ORDER BY `minOrder` ASC [ RunTime:0.056657s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 54125002 ORDER BY `unit` DESC [ RunTime:0.048722s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 54125002 LIMIT 2 [ RunTime:0.030900s ]
SELECT * FROM `stock_price` WHERE `stockid` = 54125002 ORDER BY `minOrder` ASC [ RunTime:0.026339s ]
select * from pdf where partno='89038-102' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.102663s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '89038-102' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.024711s ]
SELECT `id` FROM `stock` WHERE `id` <> 54125002 AND `partno` = '89038-102' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.047492s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12489672 [ RunTime:0.047509s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 54124916 LIMIT 5 [ RunTime:0.047986s ]
SELECT * FROM `stock_price` WHERE `stockid` = 54124916 ORDER BY `minOrder` ASC [ RunTime:0.033173s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 54124916 ORDER BY `unit` DESC [ RunTime:0.037647s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 54124916 LIMIT 2 [ RunTime:0.042828s ]
SELECT * FROM `stock_price` WHERE `stockid` = 54124916 ORDER BY `minOrder` ASC [ RunTime:0.006505s ]
select * from pdf where partno='89038-112' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.030166s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '89038-112' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.006222s ]
SELECT `id` FROM `stock` WHERE `id` <> 54124916 AND `partno` = '89038-112' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.073297s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 54124132 LIMIT 5 [ RunTime:0.020355s ]
SELECT * FROM `stock_price` WHERE `stockid` = 54124132 ORDER BY `minOrder` ASC [ RunTime:0.046547s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 54124132 ORDER BY `unit` DESC [ RunTime:0.039262s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 54124132 LIMIT 2 [ RunTime:0.049586s ]
SELECT * FROM `stock_price` WHERE `stockid` = 54124132 ORDER BY `minOrder` ASC [ RunTime:0.021657s ]
select * from pdf where partno='89038-101LF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.035334s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '89038-101LF' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.044004s ]
SELECT `id` FROM `stock` WHERE `id` <> 54124132 AND `partno` = '89038-101LF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.015532s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11406432 [ RunTime:0.053876s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 54119799 LIMIT 5 [ RunTime:0.050010s ]
SELECT * FROM `stock_price` WHERE `stockid` = 54119799 ORDER BY `minOrder` ASC [ RunTime:0.043065s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 54119799 ORDER BY `unit` DESC [ RunTime:0.041239s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 54119799 LIMIT 2 [ RunTime:0.083289s ]
SELECT * FROM `stock_price` WHERE `stockid` = 54119799 ORDER BY `minOrder` ASC [ RunTime:0.040251s ]
select * from pdf where partno='89038-102LF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.048183s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '89038-102LF' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.015775s ]
SELECT `id` FROM `stock` WHERE `id` <> 54119799 AND `partno` = '89038-102LF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.108040s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11406278 [ RunTime:0.116546s ]
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 '89038%' OR `brand` LIKE '89038%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013459s ]
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 '89038%' OR `brand` LIKE '89038%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014163s ]
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 '89038%' OR `brand` LIKE '89038%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.027442s ]
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 '89038%' OR `brand` LIKE '89038%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.058525s ]
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 '89038%' OR `brand` LIKE '89038%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.051236s ]
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 '89038%' OR `brand` LIKE '89038%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.029160s ]
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 '89038%' OR `brand` LIKE '89038%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.044764s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '89038%' OR `brand` LIKE '89038%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.100238s ]