SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002179s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.254' , `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-19-53P&search=1' [ RunTime:0.003618s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001607s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.006534s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001893s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.254' ) [ RunTime:0.014689s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001363s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.003146s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001555s ]
SELECT * FROM `stock_search` WHERE `partno` = 'LJT00RE-19-53P' LIMIT 1 [ RunTime:0.003452s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-08-04 14:21:49' WHERE `partno` = 'LJT00RE-19-53P' [ RunTime:0.002826s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001474s ]
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-19-53P%' OR `brand` LIKE 'LJT00RE-19-53P%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009699s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001646s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12926486 LIMIT 5 [ RunTime:0.009645s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002316s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12926486 ORDER BY `minOrder` ASC [ RunTime:0.005671s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001126s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12926486 ORDER BY `unit` DESC [ RunTime:0.000487s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.000902s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12926486 LIMIT 2 [ RunTime:0.008034s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12926486 ORDER BY `minOrder` ASC [ RunTime:0.007902s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12926485 LIMIT 5 [ RunTime:0.025251s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12926485 ORDER BY `minOrder` ASC [ RunTime:0.011125s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12926485 ORDER BY `unit` DESC [ RunTime:0.006263s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12926485 LIMIT 2 [ RunTime:0.015103s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12926485 ORDER BY `minOrder` ASC [ RunTime:0.014612s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11715915 LIMIT 5 [ RunTime:0.016607s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11715915 ORDER BY `minOrder` ASC [ RunTime:0.015664s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11715915 ORDER BY `unit` DESC [ RunTime:0.056483s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11715915 LIMIT 2 [ RunTime:0.020903s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11715915 ORDER BY `minOrder` ASC [ RunTime:0.009301s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11090873 LIMIT 5 [ RunTime:0.002383s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11090873 ORDER BY `minOrder` ASC [ RunTime:0.013302s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11090873 ORDER BY `unit` DESC [ RunTime:0.033097s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11090873 LIMIT 2 [ RunTime:0.014956s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11090873 ORDER BY `minOrder` ASC [ RunTime:0.001331s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11090872 LIMIT 5 [ RunTime:0.005244s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11090872 ORDER BY `minOrder` ASC [ RunTime:0.018658s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11090872 ORDER BY `unit` DESC [ RunTime:0.005198s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11090872 LIMIT 2 [ RunTime:0.000620s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11090872 ORDER BY `minOrder` ASC [ RunTime:0.004618s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11090871 LIMIT 5 [ RunTime:0.002323s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11090871 ORDER BY `minOrder` ASC [ RunTime:0.012347s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11090871 ORDER BY `unit` DESC [ RunTime:0.002465s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11090871 LIMIT 2 [ RunTime:0.003934s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11090871 ORDER BY `minOrder` ASC [ RunTime:0.007686s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11090866 LIMIT 5 [ RunTime:0.002040s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11090866 ORDER BY `minOrder` ASC [ RunTime:0.011221s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11090866 ORDER BY `unit` DESC [ RunTime:0.001758s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11090866 LIMIT 2 [ RunTime:0.004371s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11090866 ORDER BY `minOrder` ASC [ RunTime:0.005474s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11036079 LIMIT 5 [ RunTime:0.003492s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11036079 ORDER BY `minOrder` ASC [ RunTime:0.032183s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11036079 ORDER BY `unit` DESC [ RunTime:0.010870s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11036079 LIMIT 2 [ RunTime:0.000957s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11036079 ORDER BY `minOrder` ASC [ RunTime:0.003054s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11036078 LIMIT 5 [ RunTime:0.006619s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11036078 ORDER BY `minOrder` ASC [ RunTime:0.020287s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11036078 ORDER BY `unit` DESC [ RunTime:0.027168s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11036078 LIMIT 2 [ RunTime:0.020046s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11036078 ORDER BY `minOrder` ASC [ RunTime:0.006584s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11036073 LIMIT 5 [ RunTime:0.015777s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11036073 ORDER BY `minOrder` ASC [ RunTime:0.005395s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11036073 ORDER BY `unit` DESC [ RunTime:0.000758s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11036073 LIMIT 2 [ RunTime:0.012197s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11036073 ORDER BY `minOrder` ASC [ RunTime:0.000453s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11036072 LIMIT 5 [ RunTime:0.001105s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11036072 ORDER BY `minOrder` ASC [ RunTime:0.005070s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11036072 ORDER BY `unit` DESC [ RunTime:0.002033s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11036072 LIMIT 2 [ RunTime:0.009701s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11036072 ORDER BY `minOrder` ASC [ RunTime:0.001995s ]
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-19-53P%' OR `brand` LIKE 'LJT00RE-19-53P%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002008s ]
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-19-53P%' OR `brand` LIKE 'LJT00RE-19-53P%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007381s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61759755 LIMIT 5 [ RunTime:0.018086s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61759755 ORDER BY `minOrder` ASC [ RunTime:0.025725s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61759755 ORDER BY `unit` DESC [ RunTime:0.008649s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61759755 LIMIT 2 [ RunTime:0.002090s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61759755 ORDER BY `minOrder` ASC [ RunTime:0.004345s ]
select * from pdf where partno='LJT00RE-19-53P(SR)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.004197s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002373s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LJT00RE-19-53P(SR)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.010008s ]
SELECT `id` FROM `stock` WHERE `id` <> 61759755 AND `partno` = 'LJT00RE-19-53P(SR)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.025134s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11090873 [ RunTime:0.023214s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61759754 LIMIT 5 [ RunTime:0.001986s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61759754 ORDER BY `minOrder` ASC [ RunTime:0.006499s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61759754 ORDER BY `unit` DESC [ RunTime:0.003756s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61759754 LIMIT 2 [ RunTime:0.001593s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61759754 ORDER BY `minOrder` ASC [ RunTime:0.000466s ]
select * from pdf where partno='LJT00RE-19-53P(424)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.000833s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LJT00RE-19-53P(424)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.005012s ]
SELECT `id` FROM `stock` WHERE `id` <> 61759754 AND `partno` = 'LJT00RE-19-53P(424)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.029526s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11090872 [ RunTime:0.013557s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61759753 LIMIT 5 [ RunTime:0.025393s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61759753 ORDER BY `minOrder` ASC [ RunTime:0.013922s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61759753 ORDER BY `unit` DESC [ RunTime:0.028675s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61759753 LIMIT 2 [ RunTime:0.002457s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61759753 ORDER BY `minOrder` ASC [ RunTime:0.010507s ]
select * from pdf where partno='LJT00RE-19-53P(344)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.004103s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LJT00RE-19-53P(344)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.003343s ]
SELECT `id` FROM `stock` WHERE `id` <> 61759753 AND `partno` = 'LJT00RE-19-53P(344)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.011369s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11090871 [ RunTime:0.020418s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61721821 LIMIT 5 [ RunTime:0.014525s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61721821 ORDER BY `minOrder` ASC [ RunTime:0.019657s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61721821 ORDER BY `unit` DESC [ RunTime:0.021494s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61721821 LIMIT 2 [ RunTime:0.003672s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61721821 ORDER BY `minOrder` ASC [ RunTime:0.015735s ]
select * from pdf where partno='LJT00RE-19-53P(439)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.062564s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LJT00RE-19-53P(439)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.095298s ]
SELECT `id` FROM `stock` WHERE `id` <> 61721821 AND `partno` = 'LJT00RE-19-53P(439)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.060879s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61721818 LIMIT 5 [ RunTime:0.039166s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61721818 ORDER BY `minOrder` ASC [ RunTime:0.034189s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61721818 ORDER BY `unit` DESC [ RunTime:0.057556s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61721818 LIMIT 2 [ RunTime:0.028492s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61721818 ORDER BY `minOrder` ASC [ RunTime:0.006373s ]
select * from pdf where partno='LJT00RE-19-53P(406)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.005826s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LJT00RE-19-53P(406)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.015505s ]
SELECT `id` FROM `stock` WHERE `id` <> 61721818 AND `partno` = 'LJT00RE-19-53P(406)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.014264s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61721816 LIMIT 5 [ RunTime:0.051462s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61721816 ORDER BY `minOrder` ASC [ RunTime:0.042238s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61721816 ORDER BY `unit` DESC [ RunTime:0.048203s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61721816 LIMIT 2 [ RunTime:0.017157s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61721816 ORDER BY `minOrder` ASC [ RunTime:0.008736s ]
select * from pdf where partno='LJT00RE-19-53P(408)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.025272s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LJT00RE-19-53P(408)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.019909s ]
SELECT `id` FROM `stock` WHERE `id` <> 61721816 AND `partno` = 'LJT00RE-19-53P(408)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.007473s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61721815 LIMIT 5 [ RunTime:0.036416s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61721815 ORDER BY `minOrder` ASC [ RunTime:0.039521s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61721815 ORDER BY `unit` DESC [ RunTime:0.082313s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61721815 LIMIT 2 [ RunTime:0.041810s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61721815 ORDER BY `minOrder` ASC [ RunTime:0.045707s ]
select * from pdf where partno='LJT00RE-19-53P(106)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.050265s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LJT00RE-19-53P(106)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.043940s ]
SELECT `id` FROM `stock` WHERE `id` <> 61721815 AND `partno` = 'LJT00RE-19-53P(106)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.031933s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61703573 LIMIT 5 [ RunTime:0.067416s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61703573 ORDER BY `minOrder` ASC [ RunTime:0.021277s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61703573 ORDER BY `unit` DESC [ RunTime:0.026250s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61703573 LIMIT 2 [ RunTime:0.080580s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61703573 ORDER BY `minOrder` ASC [ RunTime:0.022818s ]
select * from pdf where partno='LJT00RE-19-53P(023)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.041350s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LJT00RE-19-53P(023)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.017597s ]
SELECT `id` FROM `stock` WHERE `id` <> 61703573 AND `partno` = 'LJT00RE-19-53P(023)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.014698s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11036079 [ RunTime:0.017781s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61703572 LIMIT 5 [ RunTime:0.002805s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61703572 ORDER BY `minOrder` ASC [ RunTime:0.006099s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61703572 ORDER BY `unit` DESC [ RunTime:0.013562s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61703572 LIMIT 2 [ RunTime:0.042516s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61703572 ORDER BY `minOrder` ASC [ RunTime:0.029244s ]
select * from pdf where partno='LJT00RE-19-53P(011)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.029543s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LJT00RE-19-53P(011)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.021881s ]
SELECT `id` FROM `stock` WHERE `id` <> 61703572 AND `partno` = 'LJT00RE-19-53P(011)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.022466s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11036078 [ RunTime:0.035509s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61703570 LIMIT 5 [ RunTime:0.026565s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61703570 ORDER BY `minOrder` ASC [ RunTime:0.006599s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61703570 ORDER BY `unit` DESC [ RunTime:0.018645s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61703570 LIMIT 2 [ RunTime:0.010827s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61703570 ORDER BY `minOrder` ASC [ RunTime:0.002510s ]
select * from pdf where partno='LJT00RE-19-53P' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.012032s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LJT00RE-19-53P' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.009016s ]
SELECT `id` FROM `stock` WHERE `id` <> 61703570 AND `partno` = 'LJT00RE-19-53P' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.022329s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11036073 [ RunTime:0.019151s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61167686 LIMIT 5 [ RunTime:0.019662s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61167686 ORDER BY `minOrder` ASC [ RunTime:0.009247s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61167686 ORDER BY `unit` DESC [ RunTime:0.000926s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61167686 LIMIT 2 [ RunTime:0.005790s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61167686 ORDER BY `minOrder` ASC [ RunTime:0.005394s ]
select * from pdf where partno='LJT00RE-19-53P(386)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.006198s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LJT00RE-19-53P(386)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.031289s ]
SELECT `id` FROM `stock` WHERE `id` <> 61167686 AND `partno` = 'LJT00RE-19-53P(386)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.004533s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11090866 [ RunTime:0.022672s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61166034 LIMIT 5 [ RunTime:0.016144s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61166034 ORDER BY `minOrder` ASC [ RunTime:0.026680s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61166034 ORDER BY `unit` DESC [ RunTime:0.010225s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61166034 LIMIT 2 [ RunTime:0.027865s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61166034 ORDER BY `minOrder` ASC [ RunTime:0.009964s ]
select * from pdf where partno='LJT00RE-19-53P(014)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.028979s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LJT00RE-19-53P(014)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.018929s ]
SELECT `id` FROM `stock` WHERE `id` <> 61166034 AND `partno` = 'LJT00RE-19-53P(014)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.042770s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11036072 [ RunTime:0.010964s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60223549 LIMIT 5 [ RunTime:0.014969s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60223549 ORDER BY `minOrder` ASC [ RunTime:0.025129s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60223549 ORDER BY `unit` DESC [ RunTime:0.017571s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60223549 LIMIT 2 [ RunTime:0.011922s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60223549 ORDER BY `minOrder` ASC [ RunTime:0.034082s ]
select * from pdf where partno='LJT00RE-19-53PA(011LC)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.013821s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LJT00RE-19-53PA(011LC)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.010244s ]
SELECT `id` FROM `stock` WHERE `id` <> 60223549 AND `partno` = 'LJT00RE-19-53PA(011LC)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.000768s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60223548 LIMIT 5 [ RunTime:0.011227s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60223548 ORDER BY `minOrder` ASC [ RunTime:0.005857s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60223548 ORDER BY `unit` DESC [ RunTime:0.006846s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60223548 LIMIT 2 [ RunTime:0.020113s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60223548 ORDER BY `minOrder` ASC [ RunTime:0.025793s ]
select * from pdf where partno='LJT00RE-19-53PA(023LC)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.098183s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LJT00RE-19-53PA(023LC)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.009821s ]
SELECT `id` FROM `stock` WHERE `id` <> 60223548 AND `partno` = 'LJT00RE-19-53PA(023LC)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.003825s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60223547 LIMIT 5 [ RunTime:0.006342s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60223547 ORDER BY `minOrder` ASC [ RunTime:0.011600s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60223547 ORDER BY `unit` DESC [ RunTime:0.015960s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60223547 LIMIT 2 [ RunTime:0.058873s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60223547 ORDER BY `minOrder` ASC [ RunTime:0.019226s ]
select * from pdf where partno='LJT00RE-19-53PD(023LC)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.019923s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LJT00RE-19-53PD(023LC)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.084035s ]
SELECT `id` FROM `stock` WHERE `id` <> 60223547 AND `partno` = 'LJT00RE-19-53PD(023LC)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.039360s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60223545 LIMIT 5 [ RunTime:0.042867s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60223545 ORDER BY `minOrder` ASC [ RunTime:0.052843s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60223545 ORDER BY `unit` DESC [ RunTime:0.059046s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60223545 LIMIT 2 [ RunTime:0.081504s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60223545 ORDER BY `minOrder` ASC [ RunTime:0.020763s ]
select * from pdf where partno='LJT00RE-19-53PD(LC)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.031539s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LJT00RE-19-53PD(LC)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.045697s ]
SELECT `id` FROM `stock` WHERE `id` <> 60223545 AND `partno` = 'LJT00RE-19-53PD(LC)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.060495s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60223543 LIMIT 5 [ RunTime:0.042276s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60223543 ORDER BY `minOrder` ASC [ RunTime:0.054242s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60223543 ORDER BY `unit` DESC [ RunTime:0.084097s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60223543 LIMIT 2 [ RunTime:0.072934s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60223543 ORDER BY `minOrder` ASC [ RunTime:0.019859s ]
select * from pdf where partno='LJT00RE-19-53PD(011LC)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.095250s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LJT00RE-19-53PD(011LC)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.076942s ]
SELECT `id` FROM `stock` WHERE `id` <> 60223543 AND `partno` = 'LJT00RE-19-53PD(011LC)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.067575s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60223540 LIMIT 5 [ RunTime:0.034968s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60223540 ORDER BY `minOrder` ASC [ RunTime:0.068747s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60223540 ORDER BY `unit` DESC [ RunTime:0.044294s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60223540 LIMIT 2 [ RunTime:0.052030s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60223540 ORDER BY `minOrder` ASC [ RunTime:0.033611s ]
select * from pdf where partno='LJT00RE-19-53PA(LC)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.098661s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LJT00RE-19-53PA(LC)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.049377s ]
SELECT `id` FROM `stock` WHERE `id` <> 60223540 AND `partno` = 'LJT00RE-19-53PA(LC)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.071120s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60223517 LIMIT 5 [ RunTime:0.030304s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60223517 ORDER BY `minOrder` ASC [ RunTime:0.033213s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60223517 ORDER BY `unit` DESC [ RunTime:0.048862s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60223517 LIMIT 2 [ RunTime:0.070052s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60223517 ORDER BY `minOrder` ASC [ RunTime:0.015555s ]
select * from pdf where partno='LJT00RE-19-53P(023LC)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.063655s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LJT00RE-19-53P(023LC)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.024640s ]
SELECT `id` FROM `stock` WHERE `id` <> 60223517 AND `partno` = 'LJT00RE-19-53P(023LC)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.035105s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60223516 LIMIT 5 [ RunTime:0.012242s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60223516 ORDER BY `minOrder` ASC [ RunTime:0.040941s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60223516 ORDER BY `unit` DESC [ RunTime:0.020159s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60223516 LIMIT 2 [ RunTime:0.034281s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60223516 ORDER BY `minOrder` ASC [ RunTime:0.043796s ]
select * from pdf where partno='LJT00RE-19-53PB(LC)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.039069s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LJT00RE-19-53PB(LC)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.013738s ]
SELECT `id` FROM `stock` WHERE `id` <> 60223516 AND `partno` = 'LJT00RE-19-53PB(LC)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.008810s ]
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-19-53P%' OR `brand` LIKE 'LJT00RE-19-53P%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.030324s ]
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-19-53P%' OR `brand` LIKE 'LJT00RE-19-53P%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.047404s ]
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-19-53P%' OR `brand` LIKE 'LJT00RE-19-53P%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.073845s ]
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-19-53P%' OR `brand` LIKE 'LJT00RE-19-53P%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.144252s ]
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-19-53P%' OR `brand` LIKE 'LJT00RE-19-53P%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.066489s ]
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-19-53P%' OR `brand` LIKE 'LJT00RE-19-53P%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.049608s ]
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-19-53P%' OR `brand` LIKE 'LJT00RE-19-53P%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.041944s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'LJT00RE-19-53P%' OR `brand` LIKE 'LJT00RE-19-53P%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.018099s ]