SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.003465s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.85' , `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-17-42S&search=1' [ RunTime:0.035371s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002357s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.055426s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002774s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.85' ) [ RunTime:0.074902s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002879s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.037177s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001174s ]
SELECT * FROM `stock_search` WHERE `partno` = 'LJT00RE-17-42S' LIMIT 1 [ RunTime:0.074904s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-07-29 10:50:24' WHERE `partno` = 'LJT00RE-17-42S' [ RunTime:0.077790s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002618s ]
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-17-42S%' OR `brand` LIKE 'LJT00RE-17-42S%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.108231s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002919s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20110005 LIMIT 5 [ RunTime:0.019229s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001309s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20110005 ORDER BY `minOrder` ASC [ RunTime:0.024522s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002820s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 20110005 ORDER BY `unit` DESC [ RunTime:0.027690s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.046613s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 20110005 LIMIT 2 [ RunTime:0.036939s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20110005 ORDER BY `minOrder` ASC [ RunTime:0.028185s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20110002 LIMIT 5 [ RunTime:0.026543s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20110002 ORDER BY `minOrder` ASC [ RunTime:0.028920s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 20110002 ORDER BY `unit` DESC [ RunTime:0.008135s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 20110002 LIMIT 2 [ RunTime:0.010556s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20110002 ORDER BY `minOrder` ASC [ RunTime:0.039720s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20110001 LIMIT 5 [ RunTime:0.024675s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20110001 ORDER BY `minOrder` ASC [ RunTime:0.025584s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 20110001 ORDER BY `unit` DESC [ RunTime:0.032341s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 20110001 LIMIT 2 [ RunTime:0.018990s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20110001 ORDER BY `minOrder` ASC [ RunTime:0.021427s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20109992 LIMIT 5 [ RunTime:0.048337s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20109992 ORDER BY `minOrder` ASC [ RunTime:0.163928s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 20109992 ORDER BY `unit` DESC [ RunTime:0.076520s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 20109992 LIMIT 2 [ RunTime:0.024692s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20109992 ORDER BY `minOrder` ASC [ RunTime:0.061042s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20109990 LIMIT 5 [ RunTime:0.096895s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20109990 ORDER BY `minOrder` ASC [ RunTime:0.090457s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 20109990 ORDER BY `unit` DESC [ RunTime:0.043599s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 20109990 LIMIT 2 [ RunTime:0.084769s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20109990 ORDER BY `minOrder` ASC [ RunTime:0.025606s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20109989 LIMIT 5 [ RunTime:0.037098s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20109989 ORDER BY `minOrder` ASC [ RunTime:0.151798s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 20109989 ORDER BY `unit` DESC [ RunTime:0.071563s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 20109989 LIMIT 2 [ RunTime:0.049013s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20109989 ORDER BY `minOrder` ASC [ RunTime:0.023561s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20109988 LIMIT 5 [ RunTime:0.012510s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20109988 ORDER BY `minOrder` ASC [ RunTime:0.083079s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 20109988 ORDER BY `unit` DESC [ RunTime:0.040169s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 20109988 LIMIT 2 [ RunTime:0.067674s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20109988 ORDER BY `minOrder` ASC [ RunTime:0.025488s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20109966 LIMIT 5 [ RunTime:0.067356s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20109966 ORDER BY `minOrder` ASC [ RunTime:0.050708s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 20109966 ORDER BY `unit` DESC [ RunTime:0.034407s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 20109966 LIMIT 2 [ RunTime:0.055297s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20109966 ORDER BY `minOrder` ASC [ RunTime:0.029086s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20109964 LIMIT 5 [ RunTime:0.027315s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20109964 ORDER BY `minOrder` ASC [ RunTime:0.021077s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 20109964 ORDER BY `unit` DESC [ RunTime:0.023881s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 20109964 LIMIT 2 [ RunTime:0.032466s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20109964 ORDER BY `minOrder` ASC [ RunTime:0.024121s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17379497 LIMIT 5 [ RunTime:0.018726s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17379497 ORDER BY `minOrder` ASC [ RunTime:0.019196s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17379497 ORDER BY `unit` DESC [ RunTime:0.018627s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17379497 LIMIT 2 [ RunTime:0.040699s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17379497 ORDER BY `minOrder` ASC [ RunTime:0.009999s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17379491 LIMIT 5 [ RunTime:0.006759s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17379491 ORDER BY `minOrder` ASC [ RunTime:0.005117s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17379491 ORDER BY `unit` DESC [ RunTime:0.026851s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17379491 LIMIT 2 [ RunTime:0.031149s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17379491 ORDER BY `minOrder` ASC [ RunTime:0.003978s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17379490 LIMIT 5 [ RunTime:0.017556s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17379490 ORDER BY `minOrder` ASC [ RunTime:0.013948s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17379490 ORDER BY `unit` DESC [ RunTime:0.038678s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17379490 LIMIT 2 [ RunTime:0.023826s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17379490 ORDER BY `minOrder` ASC [ RunTime:0.008057s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17379489 LIMIT 5 [ RunTime:0.010157s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17379489 ORDER BY `minOrder` ASC [ RunTime:0.018591s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17379489 ORDER BY `unit` DESC [ RunTime:0.006692s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17379489 LIMIT 2 [ RunTime:0.003083s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17379489 ORDER BY `minOrder` ASC [ RunTime:0.012279s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16373186 LIMIT 5 [ RunTime:0.005905s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16373186 ORDER BY `minOrder` ASC [ RunTime:0.012111s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16373186 ORDER BY `unit` DESC [ RunTime:0.001500s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16373186 LIMIT 2 [ RunTime:0.003431s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16373186 ORDER BY `minOrder` ASC [ RunTime:0.003646s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16373185 LIMIT 5 [ RunTime:0.013368s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16373185 ORDER BY `minOrder` ASC [ RunTime:0.015358s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16373185 ORDER BY `unit` DESC [ RunTime:0.016122s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16373185 LIMIT 2 [ RunTime:0.051800s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16373185 ORDER BY `minOrder` ASC [ RunTime:0.021265s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16373183 LIMIT 5 [ RunTime:0.030590s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16373183 ORDER BY `minOrder` ASC [ RunTime:0.065446s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16373183 ORDER BY `unit` DESC [ RunTime:0.057974s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16373183 LIMIT 2 [ RunTime:0.024931s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16373183 ORDER BY `minOrder` ASC [ RunTime:0.004343s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16373182 LIMIT 5 [ RunTime:0.043685s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16373182 ORDER BY `minOrder` ASC [ RunTime:0.008541s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16373182 ORDER BY `unit` DESC [ RunTime:0.018435s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16373182 LIMIT 2 [ RunTime:0.043994s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16373182 ORDER BY `minOrder` ASC [ RunTime:0.008374s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16373181 LIMIT 5 [ RunTime:0.024384s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16373181 ORDER BY `minOrder` ASC [ RunTime:0.051910s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16373181 ORDER BY `unit` DESC [ RunTime:0.029646s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16373181 LIMIT 2 [ RunTime:0.071395s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16373181 ORDER BY `minOrder` ASC [ RunTime:0.025087s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16373178 LIMIT 5 [ RunTime:0.067662s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16373178 ORDER BY `minOrder` ASC [ RunTime:0.064212s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16373178 ORDER BY `unit` DESC [ RunTime:0.055580s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16373178 LIMIT 2 [ RunTime:0.046397s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16373178 ORDER BY `minOrder` ASC [ RunTime:0.027731s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15556544 LIMIT 5 [ RunTime:0.051047s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15556544 ORDER BY `minOrder` ASC [ RunTime:0.091770s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15556544 ORDER BY `unit` DESC [ RunTime:0.084899s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15556544 LIMIT 2 [ RunTime:0.050449s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15556544 ORDER BY `minOrder` ASC [ RunTime:0.043209s ]
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-17-42S%' OR `brand` LIKE 'LJT00RE-17-42S%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.082496s ]
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-17-42S%' OR `brand` LIKE 'LJT00RE-17-42S%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.130099s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55035189 LIMIT 5 [ RunTime:0.082960s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55035189 ORDER BY `minOrder` ASC [ RunTime:0.048111s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55035189 ORDER BY `unit` DESC [ RunTime:0.027744s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55035189 LIMIT 2 [ RunTime:0.017285s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55035189 ORDER BY `minOrder` ASC [ RunTime:0.012002s ]
select * from pdf where partno='LJT00RE-17-42S(439)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.034069s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002843s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LJT00RE-17-42S(439)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.030797s ]
SELECT `id` FROM `stock` WHERE `id` <> 55035189 AND `partno` = 'LJT00RE-17-42S(439)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.016557s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55035188 LIMIT 5 [ RunTime:0.020235s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55035188 ORDER BY `minOrder` ASC [ RunTime:0.016576s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55035188 ORDER BY `unit` DESC [ RunTime:0.017547s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55035188 LIMIT 2 [ RunTime:0.014627s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55035188 ORDER BY `minOrder` ASC [ RunTime:0.010764s ]
select * from pdf where partno='LJT00RE-17-42S(406)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.018115s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LJT00RE-17-42S(406)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.014363s ]
SELECT `id` FROM `stock` WHERE `id` <> 55035188 AND `partno` = 'LJT00RE-17-42S(406)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.013198s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55006623 LIMIT 5 [ RunTime:0.016449s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55006623 ORDER BY `minOrder` ASC [ RunTime:0.009189s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55006623 ORDER BY `unit` DESC [ RunTime:0.013011s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55006623 LIMIT 2 [ RunTime:0.006057s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55006623 ORDER BY `minOrder` ASC [ RunTime:0.003163s ]
select * from pdf where partno='LJT00RE-17-42S(424)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.008418s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LJT00RE-17-42S(424)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.052939s ]
SELECT `id` FROM `stock` WHERE `id` <> 55006623 AND `partno` = 'LJT00RE-17-42S(424)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.022425s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55006620 LIMIT 5 [ RunTime:0.028011s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55006620 ORDER BY `minOrder` ASC [ RunTime:0.034038s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55006620 ORDER BY `unit` DESC [ RunTime:0.037308s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55006620 LIMIT 2 [ RunTime:0.000907s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55006620 ORDER BY `minOrder` ASC [ RunTime:0.009967s ]
select * from pdf where partno='LJT00RE-17-42S(344)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.015924s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LJT00RE-17-42S(344)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.017045s ]
SELECT `id` FROM `stock` WHERE `id` <> 55006620 AND `partno` = 'LJT00RE-17-42S(344)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.029575s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55006618 LIMIT 5 [ RunTime:0.021613s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55006618 ORDER BY `minOrder` ASC [ RunTime:0.021827s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55006618 ORDER BY `unit` DESC [ RunTime:0.009399s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55006618 LIMIT 2 [ RunTime:0.012856s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55006618 ORDER BY `minOrder` ASC [ RunTime:0.011259s ]
select * from pdf where partno='LJT00RE-17-42S(SR)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.029976s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LJT00RE-17-42S(SR)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.010832s ]
SELECT `id` FROM `stock` WHERE `id` <> 55006618 AND `partno` = 'LJT00RE-17-42S(SR)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.002960s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 54963220 LIMIT 5 [ RunTime:0.000426s ]
SELECT * FROM `stock_price` WHERE `stockid` = 54963220 ORDER BY `minOrder` ASC [ RunTime:0.006351s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 54963220 ORDER BY `unit` DESC [ RunTime:0.012505s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 54963220 LIMIT 2 [ RunTime:0.014290s ]
SELECT * FROM `stock_price` WHERE `stockid` = 54963220 ORDER BY `minOrder` ASC [ RunTime:0.007871s ]
select * from pdf where partno='LJT00RE-17-42S(023)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.024737s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LJT00RE-17-42S(023)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.008612s ]
SELECT `id` FROM `stock` WHERE `id` <> 54963220 AND `partno` = 'LJT00RE-17-42S(023)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.041712s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 54963218 LIMIT 5 [ RunTime:0.036024s ]
SELECT * FROM `stock_price` WHERE `stockid` = 54963218 ORDER BY `minOrder` ASC [ RunTime:0.051078s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 54963218 ORDER BY `unit` DESC [ RunTime:0.059006s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 54963218 LIMIT 2 [ RunTime:0.028948s ]
SELECT * FROM `stock_price` WHERE `stockid` = 54963218 ORDER BY `minOrder` ASC [ RunTime:0.008167s ]
select * from pdf where partno='LJT00RE-17-42S' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.042453s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LJT00RE-17-42S' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.030956s ]
SELECT `id` FROM `stock` WHERE `id` <> 54963218 AND `partno` = 'LJT00RE-17-42S' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.074225s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 54963217 LIMIT 5 [ RunTime:0.019046s ]
SELECT * FROM `stock_price` WHERE `stockid` = 54963217 ORDER BY `minOrder` ASC [ RunTime:0.043076s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 54963217 ORDER BY `unit` DESC [ RunTime:0.065127s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 54963217 LIMIT 2 [ RunTime:0.071647s ]
SELECT * FROM `stock_price` WHERE `stockid` = 54963217 ORDER BY `minOrder` ASC [ RunTime:0.038520s ]
select * from pdf where partno='LJT00RE-17-42S(011)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.008492s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LJT00RE-17-42S(011)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.059408s ]
SELECT `id` FROM `stock` WHERE `id` <> 54963217 AND `partno` = 'LJT00RE-17-42S(011)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.045636s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 54360950 LIMIT 5 [ RunTime:0.047764s ]
SELECT * FROM `stock_price` WHERE `stockid` = 54360950 ORDER BY `minOrder` ASC [ RunTime:0.043685s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 54360950 ORDER BY `unit` DESC [ RunTime:0.036412s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 54360950 LIMIT 2 [ RunTime:0.056742s ]
SELECT * FROM `stock_price` WHERE `stockid` = 54360950 ORDER BY `minOrder` ASC [ RunTime:0.004634s ]
select * from pdf where partno='LJT00RE-17-42S(386)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.022653s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LJT00RE-17-42S(386)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.043692s ]
SELECT `id` FROM `stock` WHERE `id` <> 54360950 AND `partno` = 'LJT00RE-17-42S(386)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.018358s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 54359351 LIMIT 5 [ RunTime:0.015117s ]
SELECT * FROM `stock_price` WHERE `stockid` = 54359351 ORDER BY `minOrder` ASC [ RunTime:0.024284s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 54359351 ORDER BY `unit` DESC [ RunTime:0.011368s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 54359351 LIMIT 2 [ RunTime:0.038666s ]
SELECT * FROM `stock_price` WHERE `stockid` = 54359351 ORDER BY `minOrder` ASC [ RunTime:0.029877s ]
select * from pdf where partno='LJT00RE-17-42S(014)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.018121s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LJT00RE-17-42S(014)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.012639s ]
SELECT `id` FROM `stock` WHERE `id` <> 54359351 AND `partno` = 'LJT00RE-17-42S(014)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.003654s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53370412 LIMIT 5 [ RunTime:0.012854s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53370412 ORDER BY `minOrder` ASC [ RunTime:0.019345s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53370412 ORDER BY `unit` DESC [ RunTime:0.016031s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53370412 LIMIT 2 [ RunTime:0.020537s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53370412 ORDER BY `minOrder` ASC [ RunTime:0.006698s ]
select * from pdf where partno='LJT00RE-17-42SB(LC)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.035637s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LJT00RE-17-42SB(LC)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.033487s ]
SELECT `id` FROM `stock` WHERE `id` <> 53370412 AND `partno` = 'LJT00RE-17-42SB(LC)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.013072s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20110005 [ RunTime:0.002888s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53370409 LIMIT 5 [ RunTime:0.002342s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53370409 ORDER BY `minOrder` ASC [ RunTime:0.017458s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53370409 ORDER BY `unit` DESC [ RunTime:0.031218s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53370409 LIMIT 2 [ RunTime:0.021295s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53370409 ORDER BY `minOrder` ASC [ RunTime:0.015509s ]
select * from pdf where partno='LJT00RE-17-42SB(011LC)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.016589s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LJT00RE-17-42SB(011LC)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.029186s ]
SELECT `id` FROM `stock` WHERE `id` <> 53370409 AND `partno` = 'LJT00RE-17-42SB(011LC)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.047542s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20110001 [ RunTime:0.041821s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53370407 LIMIT 5 [ RunTime:0.024290s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53370407 ORDER BY `minOrder` ASC [ RunTime:0.018704s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53370407 ORDER BY `unit` DESC [ RunTime:0.057576s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53370407 LIMIT 2 [ RunTime:0.064442s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53370407 ORDER BY `minOrder` ASC [ RunTime:0.049185s ]
select * from pdf where partno='LJT00RE-17-42SC(LC)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.004192s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LJT00RE-17-42SC(LC)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.047289s ]
SELECT `id` FROM `stock` WHERE `id` <> 53370407 AND `partno` = 'LJT00RE-17-42SC(LC)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.052358s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20109992 [ RunTime:0.016380s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53370406 LIMIT 5 [ RunTime:0.017630s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53370406 ORDER BY `minOrder` ASC [ RunTime:0.021767s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53370406 ORDER BY `unit` DESC [ RunTime:0.036326s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53370406 LIMIT 2 [ RunTime:0.060984s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53370406 ORDER BY `minOrder` ASC [ RunTime:0.045530s ]
select * from pdf where partno='LJT00RE-17-42SC(023LC)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.036765s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LJT00RE-17-42SC(023LC)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.017360s ]
SELECT `id` FROM `stock` WHERE `id` <> 53370406 AND `partno` = 'LJT00RE-17-42SC(023LC)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.057516s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20109990 [ RunTime:0.016504s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53370405 LIMIT 5 [ RunTime:0.050345s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53370405 ORDER BY `minOrder` ASC [ RunTime:0.066811s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53370405 ORDER BY `unit` DESC [ RunTime:0.027743s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53370405 LIMIT 2 [ RunTime:0.029323s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53370405 ORDER BY `minOrder` ASC [ RunTime:0.019496s ]
select * from pdf where partno='LJT00RE-17-42SC(011LC)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.037220s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LJT00RE-17-42SC(011LC)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.051420s ]
SELECT `id` FROM `stock` WHERE `id` <> 53370405 AND `partno` = 'LJT00RE-17-42SC(011LC)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.036397s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20109988 [ RunTime:0.022713s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53370403 LIMIT 5 [ RunTime:0.043667s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53370403 ORDER BY `minOrder` ASC [ RunTime:0.037719s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53370403 ORDER BY `unit` DESC [ RunTime:0.035353s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53370403 LIMIT 2 [ RunTime:0.064639s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53370403 ORDER BY `minOrder` ASC [ RunTime:0.027845s ]
select * from pdf where partno='LJT00RE-17-42S(011LC)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.018756s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LJT00RE-17-42S(011LC)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.034632s ]
SELECT `id` FROM `stock` WHERE `id` <> 53370403 AND `partno` = 'LJT00RE-17-42S(011LC)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.022618s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16373186 [ RunTime:0.006523s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53370402 LIMIT 5 [ RunTime:0.009886s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53370402 ORDER BY `minOrder` ASC [ RunTime:0.010297s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53370402 ORDER BY `unit` DESC [ RunTime:0.019377s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53370402 LIMIT 2 [ RunTime:0.039666s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53370402 ORDER BY `minOrder` ASC [ RunTime:0.010793s ]
select * from pdf where partno='LJT00RE-17-42S(LC)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.041300s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LJT00RE-17-42S(LC)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.019622s ]
SELECT `id` FROM `stock` WHERE `id` <> 53370402 AND `partno` = 'LJT00RE-17-42S(LC)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.013011s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17379491 [ RunTime:0.022187s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53370401 LIMIT 5 [ RunTime:0.048887s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53370401 ORDER BY `minOrder` ASC [ RunTime:0.027763s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53370401 ORDER BY `unit` DESC [ RunTime:0.007432s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53370401 LIMIT 2 [ RunTime:0.016046s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53370401 ORDER BY `minOrder` ASC [ RunTime:0.005762s ]
select * from pdf where partno='LJT00RE-17-42SD(011LC)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.007264s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LJT00RE-17-42SD(011LC)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.003412s ]
SELECT `id` FROM `stock` WHERE `id` <> 53370401 AND `partno` = 'LJT00RE-17-42SD(011LC)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.008347s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17379490 [ RunTime:0.022422s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53370398 LIMIT 5 [ RunTime:0.028517s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53370398 ORDER BY `minOrder` ASC [ RunTime:0.014491s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53370398 ORDER BY `unit` DESC [ RunTime:0.006082s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53370398 LIMIT 2 [ RunTime:0.008642s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53370398 ORDER BY `minOrder` ASC [ RunTime:0.000558s ]
select * from pdf where partno='LJT00RE-17-42SD(023LC)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.025765s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LJT00RE-17-42SD(023LC)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.009154s ]
SELECT `id` FROM `stock` WHERE `id` <> 53370398 AND `partno` = 'LJT00RE-17-42SD(023LC)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.002433s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16373182 [ RunTime:0.005526s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53370397 LIMIT 5 [ RunTime:0.007966s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53370397 ORDER BY `minOrder` ASC [ RunTime:0.021941s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53370397 ORDER BY `unit` DESC [ RunTime:0.006014s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53370397 LIMIT 2 [ RunTime:0.003093s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53370397 ORDER BY `minOrder` ASC [ RunTime:0.008310s ]
select * from pdf where partno='LJT00RE-17-42S(023LC)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.006212s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LJT00RE-17-42S(023LC)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.010980s ]
SELECT `id` FROM `stock` WHERE `id` <> 53370397 AND `partno` = 'LJT00RE-17-42S(023LC)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.008779s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16373181 [ RunTime:0.023315s ]
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-17-42S%' OR `brand` LIKE 'LJT00RE-17-42S%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012277s ]
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-17-42S%' OR `brand` LIKE 'LJT00RE-17-42S%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.023831s ]
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-17-42S%' OR `brand` LIKE 'LJT00RE-17-42S%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017038s ]
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-17-42S%' OR `brand` LIKE 'LJT00RE-17-42S%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010132s ]
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-17-42S%' OR `brand` LIKE 'LJT00RE-17-42S%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016451s ]
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-17-42S%' OR `brand` LIKE 'LJT00RE-17-42S%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.022757s ]
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-17-42S%' OR `brand` LIKE 'LJT00RE-17-42S%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.027681s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'LJT00RE-17-42S%' OR `brand` LIKE 'LJT00RE-17-42S%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.008661s ]