SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001838s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.146' , `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-21-39P&search=1' [ RunTime:0.003110s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002226s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000572s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002764s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.146' ) [ RunTime:0.000374s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002418s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000358s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002924s ]
SELECT * FROM `stock_search` WHERE `partno` = 'LJT00RE-21-39P' LIMIT 1 [ RunTime:0.006829s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-08-10 07:11:29' WHERE `partno` = 'LJT00RE-21-39P' [ RunTime:0.010761s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002284s ]
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-21-39P%' OR `brand` LIKE 'LJT00RE-21-39P%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007979s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001103s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12936742 LIMIT 5 [ RunTime:0.006981s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.000913s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12936742 ORDER BY `minOrder` ASC [ RunTime:0.000328s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.003572s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12936742 ORDER BY `unit` DESC [ RunTime:0.005952s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.006928s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12936742 LIMIT 2 [ RunTime:0.005515s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12936742 ORDER BY `minOrder` ASC [ RunTime:0.012741s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11722747 LIMIT 5 [ RunTime:0.000897s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11722747 ORDER BY `minOrder` ASC [ RunTime:0.011932s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11722747 ORDER BY `unit` DESC [ RunTime:0.000728s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11722747 LIMIT 2 [ RunTime:0.000315s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11722747 ORDER BY `minOrder` ASC [ RunTime:0.009496s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11722745 LIMIT 5 [ RunTime:0.010735s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11722745 ORDER BY `minOrder` ASC [ RunTime:0.000600s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11722745 ORDER BY `unit` DESC [ RunTime:0.007658s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11722745 LIMIT 2 [ RunTime:0.000382s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11722745 ORDER BY `minOrder` ASC [ RunTime:0.002397s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11722743 LIMIT 5 [ RunTime:0.000362s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11722743 ORDER BY `minOrder` ASC [ RunTime:0.020188s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11722743 ORDER BY `unit` DESC [ RunTime:0.006328s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11722743 LIMIT 2 [ RunTime:0.039614s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11722743 ORDER BY `minOrder` ASC [ RunTime:0.011050s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11084848 LIMIT 5 [ RunTime:0.020322s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11084848 ORDER BY `minOrder` ASC [ RunTime:0.011478s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11084848 ORDER BY `unit` DESC [ RunTime:0.002786s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11084848 LIMIT 2 [ RunTime:0.000385s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11084848 ORDER BY `minOrder` ASC [ RunTime:0.002525s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11084847 LIMIT 5 [ RunTime:0.015729s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11084847 ORDER BY `minOrder` ASC [ RunTime:0.021226s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11084847 ORDER BY `unit` DESC [ RunTime:0.011150s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11084847 LIMIT 2 [ RunTime:0.009070s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11084847 ORDER BY `minOrder` ASC [ RunTime:0.003975s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11084844 LIMIT 5 [ RunTime:0.000725s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11084844 ORDER BY `minOrder` ASC [ RunTime:0.012564s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11084844 ORDER BY `unit` DESC [ RunTime:0.002211s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11084844 LIMIT 2 [ RunTime:0.012088s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11084844 ORDER BY `minOrder` ASC [ RunTime:0.003181s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11084837 LIMIT 5 [ RunTime:0.001425s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11084837 ORDER BY `minOrder` ASC [ RunTime:0.014081s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11084837 ORDER BY `unit` DESC [ RunTime:0.008699s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11084837 LIMIT 2 [ RunTime:0.010818s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11084837 ORDER BY `minOrder` ASC [ RunTime:0.004545s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11068421 LIMIT 5 [ RunTime:0.021942s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11068421 ORDER BY `minOrder` ASC [ RunTime:0.015757s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11068421 ORDER BY `unit` DESC [ RunTime:0.000773s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11068421 LIMIT 2 [ RunTime:0.002266s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11068421 ORDER BY `minOrder` ASC [ RunTime:0.007120s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11068417 LIMIT 5 [ RunTime:0.015933s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11068417 ORDER BY `minOrder` ASC [ RunTime:0.015015s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11068417 ORDER BY `unit` DESC [ RunTime:0.010420s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11068417 LIMIT 2 [ RunTime:0.034175s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11068417 ORDER BY `minOrder` ASC [ RunTime:0.024701s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11068416 LIMIT 5 [ RunTime:0.015320s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11068416 ORDER BY `minOrder` ASC [ RunTime:0.016458s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11068416 ORDER BY `unit` DESC [ RunTime:0.018966s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11068416 LIMIT 2 [ RunTime:0.012347s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11068416 ORDER BY `minOrder` ASC [ RunTime:0.004365s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11068414 LIMIT 5 [ RunTime:0.003385s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11068414 ORDER BY `minOrder` ASC [ RunTime:0.008141s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11068414 ORDER BY `unit` DESC [ RunTime:0.007953s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11068414 LIMIT 2 [ RunTime:0.021633s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11068414 ORDER BY `minOrder` ASC [ RunTime:0.009698s ]
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-21-39P%' OR `brand` LIKE 'LJT00RE-21-39P%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006380s ]
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-21-39P%' OR `brand` LIKE 'LJT00RE-21-39P%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012791s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61785531 LIMIT 5 [ RunTime:0.023587s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61785531 ORDER BY `minOrder` ASC [ RunTime:0.031163s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61785531 ORDER BY `unit` DESC [ RunTime:0.032552s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61785531 LIMIT 2 [ RunTime:0.007782s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61785531 ORDER BY `minOrder` ASC [ RunTime:0.002688s ]
select * from pdf where partno='LJT00RE-21-39P(344)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.006972s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001419s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LJT00RE-21-39P(344)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.008101s ]
SELECT `id` FROM `stock` WHERE `id` <> 61785531 AND `partno` = 'LJT00RE-21-39P(344)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.012578s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61785530 LIMIT 5 [ RunTime:0.003915s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61785530 ORDER BY `minOrder` ASC [ RunTime:0.008422s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61785530 ORDER BY `unit` DESC [ RunTime:0.007224s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61785530 LIMIT 2 [ RunTime:0.018773s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61785530 ORDER BY `minOrder` ASC [ RunTime:0.012969s ]
select * from pdf where partno='LJT00RE-21-39P(SR)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.014481s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LJT00RE-21-39P(SR)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.016810s ]
SELECT `id` FROM `stock` WHERE `id` <> 61785530 AND `partno` = 'LJT00RE-21-39P(SR)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.002890s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61785529 LIMIT 5 [ RunTime:0.008827s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61785529 ORDER BY `minOrder` ASC [ RunTime:0.009901s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61785529 ORDER BY `unit` DESC [ RunTime:0.016743s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61785529 LIMIT 2 [ RunTime:0.003077s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61785529 ORDER BY `minOrder` ASC [ RunTime:0.003090s ]
select * from pdf where partno='LJT00RE-21-39P(424)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.015232s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LJT00RE-21-39P(424)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.028485s ]
SELECT `id` FROM `stock` WHERE `id` <> 61785529 AND `partno` = 'LJT00RE-21-39P(424)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.013950s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61753278 LIMIT 5 [ RunTime:0.010637s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61753278 ORDER BY `minOrder` ASC [ RunTime:0.026986s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61753278 ORDER BY `unit` DESC [ RunTime:0.012713s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61753278 LIMIT 2 [ RunTime:0.013824s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61753278 ORDER BY `minOrder` ASC [ RunTime:0.029303s ]
select * from pdf where partno='LJT00RE-21-39P(106)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.011297s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LJT00RE-21-39P(106)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.045577s ]
SELECT `id` FROM `stock` WHERE `id` <> 61753278 AND `partno` = 'LJT00RE-21-39P(106)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.023302s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11084848 [ RunTime:0.010797s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61753276 LIMIT 5 [ RunTime:0.018225s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61753276 ORDER BY `minOrder` ASC [ RunTime:0.030952s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61753276 ORDER BY `unit` DESC [ RunTime:0.044163s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61753276 LIMIT 2 [ RunTime:0.037633s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61753276 ORDER BY `minOrder` ASC [ RunTime:0.021208s ]
select * from pdf where partno='LJT00RE-21-39P(406)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.060023s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LJT00RE-21-39P(406)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.038092s ]
SELECT `id` FROM `stock` WHERE `id` <> 61753276 AND `partno` = 'LJT00RE-21-39P(406)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.022203s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11084844 [ RunTime:0.035663s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61753270 LIMIT 5 [ RunTime:0.009769s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61753270 ORDER BY `minOrder` ASC [ RunTime:0.040417s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61753270 ORDER BY `unit` DESC [ RunTime:0.016000s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61753270 LIMIT 2 [ RunTime:0.019120s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61753270 ORDER BY `minOrder` ASC [ RunTime:0.018252s ]
select * from pdf where partno='LJT00RE-21-39P(408)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.020775s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LJT00RE-21-39P(408)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.027139s ]
SELECT `id` FROM `stock` WHERE `id` <> 61753270 AND `partno` = 'LJT00RE-21-39P(408)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.038859s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11084837 [ RunTime:0.015849s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61737025 LIMIT 5 [ RunTime:0.007295s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61737025 ORDER BY `minOrder` ASC [ RunTime:0.013256s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61737025 ORDER BY `unit` DESC [ RunTime:0.012999s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61737025 LIMIT 2 [ RunTime:0.036972s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61737025 ORDER BY `minOrder` ASC [ RunTime:0.009452s ]
select * from pdf where partno='LJT00RE-21-39P(011)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.034792s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LJT00RE-21-39P(011)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.024441s ]
SELECT `id` FROM `stock` WHERE `id` <> 61737025 AND `partno` = 'LJT00RE-21-39P(011)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.036730s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11068414 [ RunTime:0.023480s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61168508 LIMIT 5 [ RunTime:0.009830s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61168508 ORDER BY `minOrder` ASC [ RunTime:0.021824s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61168508 ORDER BY `unit` DESC [ RunTime:0.018833s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61168508 LIMIT 2 [ RunTime:0.019153s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61168508 ORDER BY `minOrder` ASC [ RunTime:0.002642s ]
select * from pdf where partno='LJT00RE-21-39P(386)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.010663s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LJT00RE-21-39P(386)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.016426s ]
SELECT `id` FROM `stock` WHERE `id` <> 61168508 AND `partno` = 'LJT00RE-21-39P(386)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.013888s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61166941 LIMIT 5 [ RunTime:0.009098s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61166941 ORDER BY `minOrder` ASC [ RunTime:0.027209s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61166941 ORDER BY `unit` DESC [ RunTime:0.022125s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61166941 LIMIT 2 [ RunTime:0.012125s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61166941 ORDER BY `minOrder` ASC [ RunTime:0.003708s ]
select * from pdf where partno='LJT00RE-21-39P(023)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.011191s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LJT00RE-21-39P(023)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.001778s ]
SELECT `id` FROM `stock` WHERE `id` <> 61166941 AND `partno` = 'LJT00RE-21-39P(023)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.025489s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11068421 [ RunTime:0.019582s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61166939 LIMIT 5 [ RunTime:0.006661s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61166939 ORDER BY `minOrder` ASC [ RunTime:0.003168s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61166939 ORDER BY `unit` DESC [ RunTime:0.000663s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61166939 LIMIT 2 [ RunTime:0.007849s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61166939 ORDER BY `minOrder` ASC [ RunTime:0.000426s ]
select * from pdf where partno='LJT00RE-21-39P(014)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.006663s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LJT00RE-21-39P(014)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.007364s ]
SELECT `id` FROM `stock` WHERE `id` <> 61166939 AND `partno` = 'LJT00RE-21-39P(014)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.014455s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11068417 [ RunTime:0.004716s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61166938 LIMIT 5 [ RunTime:0.017918s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61166938 ORDER BY `minOrder` ASC [ RunTime:0.005576s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61166938 ORDER BY `unit` DESC [ RunTime:0.026159s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61166938 LIMIT 2 [ RunTime:0.002829s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61166938 ORDER BY `minOrder` ASC [ RunTime:0.003394s ]
select * from pdf where partno='LJT00RE-21-39P' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.008232s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LJT00RE-21-39P' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.006276s ]
SELECT `id` FROM `stock` WHERE `id` <> 61166938 AND `partno` = 'LJT00RE-21-39P' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.029084s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11068416 [ RunTime:0.010140s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60240135 LIMIT 5 [ RunTime:0.001581s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60240135 ORDER BY `minOrder` ASC [ RunTime:0.006766s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60240135 ORDER BY `unit` DESC [ RunTime:0.004116s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60240135 LIMIT 2 [ RunTime:0.009829s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60240135 ORDER BY `minOrder` ASC [ RunTime:0.000580s ]
select * from pdf where partno='LJT00RE-21-39PB(023LC)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.004009s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LJT00RE-21-39PB(023LC)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.017968s ]
SELECT `id` FROM `stock` WHERE `id` <> 60240135 AND `partno` = 'LJT00RE-21-39PB(023LC)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.001344s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12936742 [ RunTime:0.002811s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60240133 LIMIT 5 [ RunTime:0.002891s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60240133 ORDER BY `minOrder` ASC [ RunTime:0.023705s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60240133 ORDER BY `unit` DESC [ RunTime:0.005963s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60240133 LIMIT 2 [ RunTime:0.008121s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60240133 ORDER BY `minOrder` ASC [ RunTime:0.005219s ]
select * from pdf where partno='LJT00RE-21-39PB(011LC)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.006330s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LJT00RE-21-39PB(011LC)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.000859s ]
SELECT `id` FROM `stock` WHERE `id` <> 60240133 AND `partno` = 'LJT00RE-21-39PB(011LC)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.000829s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11722747 [ RunTime:0.004964s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60240131 LIMIT 5 [ RunTime:0.018531s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60240131 ORDER BY `minOrder` ASC [ RunTime:0.030346s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60240131 ORDER BY `unit` DESC [ RunTime:0.017245s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60240131 LIMIT 2 [ RunTime:0.020875s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60240131 ORDER BY `minOrder` ASC [ RunTime:0.011812s ]
select * from pdf where partno='LJT00RE-21-39PB(LC)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.004879s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LJT00RE-21-39PB(LC)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.018855s ]
SELECT `id` FROM `stock` WHERE `id` <> 60240131 AND `partno` = 'LJT00RE-21-39PB(LC)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.011125s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11722745 [ RunTime:0.025091s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60240117 LIMIT 5 [ RunTime:0.006264s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60240117 ORDER BY `minOrder` ASC [ RunTime:0.009667s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60240117 ORDER BY `unit` DESC [ RunTime:0.012791s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60240117 LIMIT 2 [ RunTime:0.006503s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60240117 ORDER BY `minOrder` ASC [ RunTime:0.001354s ]
select * from pdf where partno='LJT00RE-21-39P(023LC)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.000819s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LJT00RE-21-39P(023LC)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.022358s ]
SELECT `id` FROM `stock` WHERE `id` <> 60240117 AND `partno` = 'LJT00RE-21-39P(023LC)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.011386s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60240115 LIMIT 5 [ RunTime:0.016238s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60240115 ORDER BY `minOrder` ASC [ RunTime:0.005425s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60240115 ORDER BY `unit` DESC [ RunTime:0.015844s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60240115 LIMIT 2 [ RunTime:0.002793s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60240115 ORDER BY `minOrder` ASC [ RunTime:0.004035s ]
select * from pdf where partno='LJT00RE-21-39P(LC)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.013316s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LJT00RE-21-39P(LC)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.010889s ]
SELECT `id` FROM `stock` WHERE `id` <> 60240115 AND `partno` = 'LJT00RE-21-39P(LC)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.004227s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60240114 LIMIT 5 [ RunTime:0.001402s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60240114 ORDER BY `minOrder` ASC [ RunTime:0.014422s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60240114 ORDER BY `unit` DESC [ RunTime:0.017452s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60240114 LIMIT 2 [ RunTime:0.006636s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60240114 ORDER BY `minOrder` ASC [ RunTime:0.007288s ]
select * from pdf where partno='LJT00RE-21-39PA(011LC)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.007687s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LJT00RE-21-39PA(011LC)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.017056s ]
SELECT `id` FROM `stock` WHERE `id` <> 60240114 AND `partno` = 'LJT00RE-21-39PA(011LC)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.007483s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60240112 LIMIT 5 [ RunTime:0.015418s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60240112 ORDER BY `minOrder` ASC [ RunTime:0.015108s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60240112 ORDER BY `unit` DESC [ RunTime:0.013493s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60240112 LIMIT 2 [ RunTime:0.000996s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60240112 ORDER BY `minOrder` ASC [ RunTime:0.000362s ]
select * from pdf where partno='LJT00RE-21-39PA(LC)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.010043s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LJT00RE-21-39PA(LC)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.003777s ]
SELECT `id` FROM `stock` WHERE `id` <> 60240112 AND `partno` = 'LJT00RE-21-39PA(LC)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.007581s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60240109 LIMIT 5 [ RunTime:0.007963s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60240109 ORDER BY `minOrder` ASC [ RunTime:0.011771s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60240109 ORDER BY `unit` DESC [ RunTime:0.004516s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60240109 LIMIT 2 [ RunTime:0.007946s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60240109 ORDER BY `minOrder` ASC [ RunTime:0.009893s ]
select * from pdf where partno='LJT00RE-21-39P(011LC)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.010905s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LJT00RE-21-39P(011LC)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.011131s ]
SELECT `id` FROM `stock` WHERE `id` <> 60240109 AND `partno` = 'LJT00RE-21-39P(011LC)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.018668s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60240108 LIMIT 5 [ RunTime:0.009179s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60240108 ORDER BY `minOrder` ASC [ RunTime:0.011290s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60240108 ORDER BY `unit` DESC [ RunTime:0.007308s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60240108 LIMIT 2 [ RunTime:0.010085s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60240108 ORDER BY `minOrder` ASC [ RunTime:0.000611s ]
select * from pdf where partno='LJT00RE-21-39PA(023LC)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.002682s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LJT00RE-21-39PA(023LC)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.008219s ]
SELECT `id` FROM `stock` WHERE `id` <> 60240108 AND `partno` = 'LJT00RE-21-39PA(023LC)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.006094s ]
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-21-39P%' OR `brand` LIKE 'LJT00RE-21-39P%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014224s ]
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-21-39P%' OR `brand` LIKE 'LJT00RE-21-39P%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013670s ]
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-21-39P%' OR `brand` LIKE 'LJT00RE-21-39P%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.034002s ]
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-21-39P%' OR `brand` LIKE 'LJT00RE-21-39P%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013902s ]
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-21-39P%' OR `brand` LIKE 'LJT00RE-21-39P%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009438s ]
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-21-39P%' OR `brand` LIKE 'LJT00RE-21-39P%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002845s ]
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-21-39P%' OR `brand` LIKE 'LJT00RE-21-39P%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009201s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'LJT00RE-21-39P%' OR `brand` LIKE 'LJT00RE-21-39P%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.002217s ]