SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002365s ]
INSERT INTO `visit_log` SET `ip` = '216.73.217.142' , `useragent` = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)' , `reffer` = '' , `host` = 'https://www.ic118.com/stock?keyword=LJT00RE-19-11S&search=1' [ RunTime:0.011676s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002551s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.006896s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002606s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.142' ) [ RunTime:0.004317s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002445s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.004577s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002523s ]
SELECT * FROM `stock_search` WHERE `partno` = 'LJT00RE-19-11S' LIMIT 1 [ RunTime:0.005837s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-08-02 02:19:55' WHERE `partno` = 'LJT00RE-19-11S' [ RunTime:0.006715s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001342s ]
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-11S%' OR `brand` LIKE 'LJT00RE-19-11S%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.062135s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.011878s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12928377 LIMIT 5 [ RunTime:0.012063s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.019147s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12928377 ORDER BY `minOrder` ASC [ RunTime:0.014639s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.005101s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12928377 ORDER BY `unit` DESC [ RunTime:0.029792s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.019988s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12928377 LIMIT 2 [ RunTime:0.013462s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12928377 ORDER BY `minOrder` ASC [ RunTime:0.012915s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12928375 LIMIT 5 [ RunTime:0.029279s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12928375 ORDER BY `minOrder` ASC [ RunTime:0.048110s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12928375 ORDER BY `unit` DESC [ RunTime:0.084018s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12928375 LIMIT 2 [ RunTime:0.061823s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12928375 ORDER BY `minOrder` ASC [ RunTime:0.017926s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12928374 LIMIT 5 [ RunTime:0.054116s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12928374 ORDER BY `minOrder` ASC [ RunTime:0.072969s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12928374 ORDER BY `unit` DESC [ RunTime:0.046039s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12928374 LIMIT 2 [ RunTime:0.068807s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12928374 ORDER BY `minOrder` ASC [ RunTime:0.016150s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12928373 LIMIT 5 [ RunTime:0.034449s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12928373 ORDER BY `minOrder` ASC [ RunTime:0.073867s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12928373 ORDER BY `unit` DESC [ RunTime:0.017617s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12928373 LIMIT 2 [ RunTime:0.049808s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12928373 ORDER BY `minOrder` ASC [ RunTime:0.016152s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12928372 LIMIT 5 [ RunTime:0.032862s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12928372 ORDER BY `minOrder` ASC [ RunTime:0.031018s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12928372 ORDER BY `unit` DESC [ RunTime:0.037364s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12928372 LIMIT 2 [ RunTime:0.051672s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12928372 ORDER BY `minOrder` ASC [ RunTime:0.009370s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12928371 LIMIT 5 [ RunTime:0.018882s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12928371 ORDER BY `minOrder` ASC [ RunTime:0.022025s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12928371 ORDER BY `unit` DESC [ RunTime:0.022949s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12928371 LIMIT 2 [ RunTime:0.048171s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12928371 ORDER BY `minOrder` ASC [ RunTime:0.022105s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12928370 LIMIT 5 [ RunTime:0.059790s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12928370 ORDER BY `minOrder` ASC [ RunTime:0.016237s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12928370 ORDER BY `unit` DESC [ RunTime:0.037739s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12928370 LIMIT 2 [ RunTime:0.062700s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12928370 ORDER BY `minOrder` ASC [ RunTime:0.009176s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12928356 LIMIT 5 [ RunTime:0.010141s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12928356 ORDER BY `minOrder` ASC [ RunTime:0.013312s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12928356 ORDER BY `unit` DESC [ RunTime:0.018906s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12928356 LIMIT 2 [ RunTime:0.021611s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12928356 ORDER BY `minOrder` ASC [ RunTime:0.035280s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12928355 LIMIT 5 [ RunTime:0.024923s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12928355 ORDER BY `minOrder` ASC [ RunTime:0.028273s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12928355 ORDER BY `unit` DESC [ RunTime:0.007521s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12928355 LIMIT 2 [ RunTime:0.064124s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12928355 ORDER BY `minOrder` ASC [ RunTime:0.030662s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11717206 LIMIT 5 [ RunTime:0.022168s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11717206 ORDER BY `minOrder` ASC [ RunTime:0.019409s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11717206 ORDER BY `unit` DESC [ RunTime:0.011352s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11717206 LIMIT 2 [ RunTime:0.019839s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11717206 ORDER BY `minOrder` ASC [ RunTime:0.007460s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11717205 LIMIT 5 [ RunTime:0.008700s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11717205 ORDER BY `minOrder` ASC [ RunTime:0.038342s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11717205 ORDER BY `unit` DESC [ RunTime:0.014449s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11717205 LIMIT 2 [ RunTime:0.046804s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11717205 ORDER BY `minOrder` ASC [ RunTime:0.014214s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11717204 LIMIT 5 [ RunTime:0.007110s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11717204 ORDER BY `minOrder` ASC [ RunTime:0.018837s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11717204 ORDER BY `unit` DESC [ RunTime:0.003145s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11717204 LIMIT 2 [ RunTime:0.075175s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11717204 ORDER BY `minOrder` ASC [ RunTime:0.010171s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11717192 LIMIT 5 [ RunTime:0.019088s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11717192 ORDER BY `minOrder` ASC [ RunTime:0.005464s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11717192 ORDER BY `unit` DESC [ RunTime:0.020989s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11717192 LIMIT 2 [ RunTime:0.012289s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11717192 ORDER BY `minOrder` ASC [ RunTime:0.018060s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11717191 LIMIT 5 [ RunTime:0.044446s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11717191 ORDER BY `minOrder` ASC [ RunTime:0.022830s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11717191 ORDER BY `unit` DESC [ RunTime:0.009751s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11717191 LIMIT 2 [ RunTime:0.029301s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11717191 ORDER BY `minOrder` ASC [ RunTime:0.035749s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11717190 LIMIT 5 [ RunTime:0.049467s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11717190 ORDER BY `minOrder` ASC [ RunTime:0.043392s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11717190 ORDER BY `unit` DESC [ RunTime:0.034601s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11717190 LIMIT 2 [ RunTime:0.024679s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11717190 ORDER BY `minOrder` ASC [ RunTime:0.040796s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11114219 LIMIT 5 [ RunTime:0.053831s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11114219 ORDER BY `minOrder` ASC [ RunTime:0.070806s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11114219 ORDER BY `unit` DESC [ RunTime:0.050755s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11114219 LIMIT 2 [ RunTime:0.037234s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11114219 ORDER BY `minOrder` ASC [ RunTime:0.023336s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11114218 LIMIT 5 [ RunTime:0.018970s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11114218 ORDER BY `minOrder` ASC [ RunTime:0.047089s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11114218 ORDER BY `unit` DESC [ RunTime:0.024360s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11114218 LIMIT 2 [ RunTime:0.029630s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11114218 ORDER BY `minOrder` ASC [ RunTime:0.017239s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11114217 LIMIT 5 [ RunTime:0.054089s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11114217 ORDER BY `minOrder` ASC [ RunTime:0.039021s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11114217 ORDER BY `unit` DESC [ RunTime:0.009909s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11114217 LIMIT 2 [ RunTime:0.036821s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11114217 ORDER BY `minOrder` ASC [ RunTime:0.010861s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11114216 LIMIT 5 [ RunTime:0.072140s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11114216 ORDER BY `minOrder` ASC [ RunTime:0.053582s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11114216 ORDER BY `unit` DESC [ RunTime:0.052102s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11114216 LIMIT 2 [ RunTime:0.038008s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11114216 ORDER BY `minOrder` ASC [ RunTime:0.024188s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11065883 LIMIT 5 [ RunTime:0.030462s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11065883 ORDER BY `minOrder` ASC [ RunTime:0.049316s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11065883 ORDER BY `unit` DESC [ RunTime:0.026567s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11065883 LIMIT 2 [ RunTime:0.021476s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11065883 ORDER BY `minOrder` ASC [ RunTime:0.024329s ]
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-11S%' OR `brand` LIKE 'LJT00RE-19-11S%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.019051s ]
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-11S%' OR `brand` LIKE 'LJT00RE-19-11S%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.030099s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60226875 LIMIT 5 [ RunTime:0.009108s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60226875 ORDER BY `minOrder` ASC [ RunTime:0.043587s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60226875 ORDER BY `unit` DESC [ RunTime:0.015114s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60226875 LIMIT 2 [ RunTime:0.033266s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60226875 ORDER BY `minOrder` ASC [ RunTime:0.013290s ]
select * from pdf where partno='LJT00RE-19-11S(LC)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.019439s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002381s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LJT00RE-19-11S(LC)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.020792s ]
SELECT `id` FROM `stock` WHERE `id` <> 60226875 AND `partno` = 'LJT00RE-19-11S(LC)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.013466s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11717206 [ RunTime:0.017047s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60226874 LIMIT 5 [ RunTime:0.014220s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60226874 ORDER BY `minOrder` ASC [ RunTime:0.018939s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60226874 ORDER BY `unit` DESC [ RunTime:0.010568s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60226874 LIMIT 2 [ RunTime:0.004989s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60226874 ORDER BY `minOrder` ASC [ RunTime:0.018149s ]
select * from pdf where partno='LJT00RE-19-11S(023LC)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.011644s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LJT00RE-19-11S(023LC)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.034570s ]
SELECT `id` FROM `stock` WHERE `id` <> 60226874 AND `partno` = 'LJT00RE-19-11S(023LC)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.047316s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11717205 [ RunTime:0.011027s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60226873 LIMIT 5 [ RunTime:0.023295s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60226873 ORDER BY `minOrder` ASC [ RunTime:0.033941s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60226873 ORDER BY `unit` DESC [ RunTime:0.039402s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60226873 LIMIT 2 [ RunTime:0.009927s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60226873 ORDER BY `minOrder` ASC [ RunTime:0.014630s ]
select * from pdf where partno='LJT00RE-19-11S(011LC)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.015128s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LJT00RE-19-11S(011LC)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.044496s ]
SELECT `id` FROM `stock` WHERE `id` <> 60226873 AND `partno` = 'LJT00RE-19-11S(011LC)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.053275s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12928377 [ RunTime:0.018596s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60226871 LIMIT 5 [ RunTime:0.031247s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60226871 ORDER BY `minOrder` ASC [ RunTime:0.010279s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60226871 ORDER BY `unit` DESC [ RunTime:0.029243s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60226871 LIMIT 2 [ RunTime:0.005906s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60226871 ORDER BY `minOrder` ASC [ RunTime:0.009480s ]
select * from pdf where partno='LJT00RE-19-11SA(023LC)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.011226s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LJT00RE-19-11SA(023LC)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.060118s ]
SELECT `id` FROM `stock` WHERE `id` <> 60226871 AND `partno` = 'LJT00RE-19-11SA(023LC)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.036188s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60226870 LIMIT 5 [ RunTime:0.071245s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60226870 ORDER BY `minOrder` ASC [ RunTime:0.020415s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60226870 ORDER BY `unit` DESC [ RunTime:0.040136s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60226870 LIMIT 2 [ RunTime:0.034973s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60226870 ORDER BY `minOrder` ASC [ RunTime:0.013933s ]
select * from pdf where partno='LJT00RE-19-11SB(011LC)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.016837s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LJT00RE-19-11SB(011LC)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.016653s ]
SELECT `id` FROM `stock` WHERE `id` <> 60226870 AND `partno` = 'LJT00RE-19-11SB(011LC)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.018931s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60226869 LIMIT 5 [ RunTime:0.020703s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60226869 ORDER BY `minOrder` ASC [ RunTime:0.017303s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60226869 ORDER BY `unit` DESC [ RunTime:0.025339s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60226869 LIMIT 2 [ RunTime:0.024137s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60226869 ORDER BY `minOrder` ASC [ RunTime:0.016928s ]
select * from pdf where partno='LJT00RE-19-11SB(LC)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.055220s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LJT00RE-19-11SB(LC)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.055793s ]
SELECT `id` FROM `stock` WHERE `id` <> 60226869 AND `partno` = 'LJT00RE-19-11SB(LC)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.024892s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12928374 [ RunTime:0.017070s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60226868 LIMIT 5 [ RunTime:0.035641s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60226868 ORDER BY `minOrder` ASC [ RunTime:0.030772s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60226868 ORDER BY `unit` DESC [ RunTime:0.036809s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60226868 LIMIT 2 [ RunTime:0.054753s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60226868 ORDER BY `minOrder` ASC [ RunTime:0.034001s ]
select * from pdf where partno='LJT00RE-19-11SB(023LC)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.025407s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LJT00RE-19-11SB(023LC)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.021624s ]
SELECT `id` FROM `stock` WHERE `id` <> 60226868 AND `partno` = 'LJT00RE-19-11SB(023LC)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.024779s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12928373 [ RunTime:0.013650s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60226867 LIMIT 5 [ RunTime:0.026949s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60226867 ORDER BY `minOrder` ASC [ RunTime:0.039371s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60226867 ORDER BY `unit` DESC [ RunTime:0.026418s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60226867 LIMIT 2 [ RunTime:0.025752s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60226867 ORDER BY `minOrder` ASC [ RunTime:0.013455s ]
select * from pdf where partno='LJT00RE-19-11SA(LC)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.014918s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LJT00RE-19-11SA(LC)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.033820s ]
SELECT `id` FROM `stock` WHERE `id` <> 60226867 AND `partno` = 'LJT00RE-19-11SA(LC)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.033605s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12928371 [ RunTime:0.030199s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60226866 LIMIT 5 [ RunTime:0.010070s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60226866 ORDER BY `minOrder` ASC [ RunTime:0.015218s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60226866 ORDER BY `unit` DESC [ RunTime:0.010230s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60226866 LIMIT 2 [ RunTime:0.003073s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60226866 ORDER BY `minOrder` ASC [ RunTime:0.019781s ]
select * from pdf where partno='LJT00RE-19-11SA(011LC)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.014536s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LJT00RE-19-11SA(011LC)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.012190s ]
SELECT `id` FROM `stock` WHERE `id` <> 60226866 AND `partno` = 'LJT00RE-19-11SA(011LC)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.017311s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12928370 [ RunTime:0.012642s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60226864 LIMIT 5 [ RunTime:0.001461s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60226864 ORDER BY `minOrder` ASC [ RunTime:0.016087s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60226864 ORDER BY `unit` DESC [ RunTime:0.001919s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60226864 LIMIT 2 [ RunTime:0.016871s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60226864 ORDER BY `minOrder` ASC [ RunTime:0.018650s ]
select * from pdf where partno='LJT00RE-19-11SC(011LC)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.018900s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LJT00RE-19-11SC(011LC)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.018332s ]
SELECT `id` FROM `stock` WHERE `id` <> 60226864 AND `partno` = 'LJT00RE-19-11SC(011LC)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.003796s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60226863 LIMIT 5 [ RunTime:0.016243s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60226863 ORDER BY `minOrder` ASC [ RunTime:0.033325s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60226863 ORDER BY `unit` DESC [ RunTime:0.015923s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60226863 LIMIT 2 [ RunTime:0.006672s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60226863 ORDER BY `minOrder` ASC [ RunTime:0.001518s ]
select * from pdf where partno='LJT00RE-19-11SC(LC)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.040665s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LJT00RE-19-11SC(LC)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.003537s ]
SELECT `id` FROM `stock` WHERE `id` <> 60226863 AND `partno` = 'LJT00RE-19-11SC(LC)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.025911s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60226862 LIMIT 5 [ RunTime:0.017006s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60226862 ORDER BY `minOrder` ASC [ RunTime:0.064837s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60226862 ORDER BY `unit` DESC [ RunTime:0.020077s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60226862 LIMIT 2 [ RunTime:0.024226s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60226862 ORDER BY `minOrder` ASC [ RunTime:0.017735s ]
select * from pdf where partno='LJT00RE-19-11SD(023LC)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.035744s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LJT00RE-19-11SD(023LC)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.045310s ]
SELECT `id` FROM `stock` WHERE `id` <> 60226862 AND `partno` = 'LJT00RE-19-11SD(023LC)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.021850s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60226861 LIMIT 5 [ RunTime:0.047515s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60226861 ORDER BY `minOrder` ASC [ RunTime:0.082987s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60226861 ORDER BY `unit` DESC [ RunTime:0.057024s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60226861 LIMIT 2 [ RunTime:0.044469s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60226861 ORDER BY `minOrder` ASC [ RunTime:0.033547s ]
select * from pdf where partno='LJT00RE-19-11SD(LC)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.033437s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LJT00RE-19-11SD(LC)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.062464s ]
SELECT `id` FROM `stock` WHERE `id` <> 60226861 AND `partno` = 'LJT00RE-19-11SD(LC)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.023498s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11717192 [ RunTime:0.043153s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60226860 LIMIT 5 [ RunTime:0.058530s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60226860 ORDER BY `minOrder` ASC [ RunTime:0.022039s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60226860 ORDER BY `unit` DESC [ RunTime:0.022883s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60226860 LIMIT 2 [ RunTime:0.029043s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60226860 ORDER BY `minOrder` ASC [ RunTime:0.017810s ]
select * from pdf where partno='LJT00RE-19-11SD(011LC)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.011932s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LJT00RE-19-11SD(011LC)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.013246s ]
SELECT `id` FROM `stock` WHERE `id` <> 60226860 AND `partno` = 'LJT00RE-19-11SD(011LC)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.026627s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11717191 [ RunTime:0.031648s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60226859 LIMIT 5 [ RunTime:0.034002s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60226859 ORDER BY `minOrder` ASC [ RunTime:0.036711s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60226859 ORDER BY `unit` DESC [ RunTime:0.018298s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60226859 LIMIT 2 [ RunTime:0.041791s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60226859 ORDER BY `minOrder` ASC [ RunTime:0.010309s ]
select * from pdf where partno='LJT00RE-19-11SC(023LC)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.031268s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LJT00RE-19-11SC(023LC)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.030227s ]
SELECT `id` FROM `stock` WHERE `id` <> 60226859 AND `partno` = 'LJT00RE-19-11SC(023LC)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.017784s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11717190 [ RunTime:0.031003s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59986120 LIMIT 5 [ RunTime:0.016176s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59986120 ORDER BY `minOrder` ASC [ RunTime:0.005815s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59986120 ORDER BY `unit` DESC [ RunTime:0.007161s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59986120 LIMIT 2 [ RunTime:0.021885s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59986120 ORDER BY `minOrder` ASC [ RunTime:0.017206s ]
select * from pdf where partno='LJT00RE-19-11S(014LC)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.039795s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LJT00RE-19-11S(014LC)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.014950s ]
SELECT `id` FROM `stock` WHERE `id` <> 59986120 AND `partno` = 'LJT00RE-19-11S(014LC)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.038184s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11717204 [ RunTime:0.031866s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59986119 LIMIT 5 [ RunTime:0.018706s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59986119 ORDER BY `minOrder` ASC [ RunTime:0.013033s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59986119 ORDER BY `unit` DESC [ RunTime:0.016179s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59986119 LIMIT 2 [ RunTime:0.026470s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59986119 ORDER BY `minOrder` ASC [ RunTime:0.021873s ]
select * from pdf where partno='LJT00RE-19-11SB(014LC)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.017204s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LJT00RE-19-11SB(014LC)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.023279s ]
SELECT `id` FROM `stock` WHERE `id` <> 59986119 AND `partno` = 'LJT00RE-19-11SB(014LC)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.011715s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12928375 [ RunTime:0.020689s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59986118 LIMIT 5 [ RunTime:0.020111s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59986118 ORDER BY `minOrder` ASC [ RunTime:0.018374s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59986118 ORDER BY `unit` DESC [ RunTime:0.013478s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59986118 LIMIT 2 [ RunTime:0.025209s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59986118 ORDER BY `minOrder` ASC [ RunTime:0.007166s ]
select * from pdf where partno='LJT00RE-19-11SA(014LC)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.021068s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LJT00RE-19-11SA(014LC)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.012742s ]
SELECT `id` FROM `stock` WHERE `id` <> 59986118 AND `partno` = 'LJT00RE-19-11SA(014LC)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.013956s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12928372 [ RunTime:0.014523s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59986117 LIMIT 5 [ RunTime:0.016365s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59986117 ORDER BY `minOrder` ASC [ RunTime:0.023362s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59986117 ORDER BY `unit` DESC [ RunTime:0.017809s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59986117 LIMIT 2 [ RunTime:0.007930s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59986117 ORDER BY `minOrder` ASC [ RunTime:0.002662s ]
select * from pdf where partno='LJT00RE-19-11SC(014LC)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.012447s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LJT00RE-19-11SC(014LC)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.008594s ]
SELECT `id` FROM `stock` WHERE `id` <> 59986117 AND `partno` = 'LJT00RE-19-11SC(014LC)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.021405s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12928356 [ RunTime:0.005802s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59986116 LIMIT 5 [ RunTime:0.026998s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59986116 ORDER BY `minOrder` ASC [ RunTime:0.012282s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59986116 ORDER BY `unit` DESC [ RunTime:0.007057s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59986116 LIMIT 2 [ RunTime:0.009604s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59986116 ORDER BY `minOrder` ASC [ RunTime:0.006438s ]
select * from pdf where partno='LJT00RE-19-11SD(014LC)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.006294s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LJT00RE-19-11SD(014LC)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.015135s ]
SELECT `id` FROM `stock` WHERE `id` <> 59986116 AND `partno` = 'LJT00RE-19-11SD(014LC)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.028081s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12928355 [ RunTime:0.008628s ]
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-11S%' OR `brand` LIKE 'LJT00RE-19-11S%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.021312s ]
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-11S%' OR `brand` LIKE 'LJT00RE-19-11S%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.018469s ]
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-11S%' OR `brand` LIKE 'LJT00RE-19-11S%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.033997s ]
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-11S%' OR `brand` LIKE 'LJT00RE-19-11S%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003650s ]
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-11S%' OR `brand` LIKE 'LJT00RE-19-11S%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011644s ]
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-11S%' OR `brand` LIKE 'LJT00RE-19-11S%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009899s ]
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-11S%' OR `brand` LIKE 'LJT00RE-19-11S%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014543s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'LJT00RE-19-11S%' OR `brand` LIKE 'LJT00RE-19-11S%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.020613s ]