SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001291s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.202' , `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-96P&search=1' [ RunTime:0.001743s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001236s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000921s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001796s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.202' ) [ RunTime:0.000301s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002340s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000324s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001518s ]
SELECT * FROM `stock_search` WHERE `partno` = 'LJT00RE-19-96P' LIMIT 1 [ RunTime:0.006915s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-08-06 03:42:09' WHERE `partno` = 'LJT00RE-19-96P' [ RunTime:0.003190s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001325s ]
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-96P%' OR `brand` LIKE 'LJT00RE-19-96P%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.019037s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002140s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12930242 LIMIT 5 [ RunTime:0.010347s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.007705s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12930242 ORDER BY `minOrder` ASC [ RunTime:0.012730s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.007302s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12930242 ORDER BY `unit` DESC [ RunTime:0.005635s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.003888s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12930242 LIMIT 2 [ RunTime:0.008428s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12930242 ORDER BY `minOrder` ASC [ RunTime:0.003186s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12930241 LIMIT 5 [ RunTime:0.000463s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12930241 ORDER BY `minOrder` ASC [ RunTime:0.029033s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12930241 ORDER BY `unit` DESC [ RunTime:0.010180s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12930241 LIMIT 2 [ RunTime:0.034902s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12930241 ORDER BY `minOrder` ASC [ RunTime:0.023880s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12930240 LIMIT 5 [ RunTime:0.008707s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12930240 ORDER BY `minOrder` ASC [ RunTime:0.017500s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12930240 ORDER BY `unit` DESC [ RunTime:0.021847s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12930240 LIMIT 2 [ RunTime:0.018611s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12930240 ORDER BY `minOrder` ASC [ RunTime:0.016127s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12930234 LIMIT 5 [ RunTime:0.008078s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12930234 ORDER BY `minOrder` ASC [ RunTime:0.004182s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12930234 ORDER BY `unit` DESC [ RunTime:0.011060s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12930234 LIMIT 2 [ RunTime:0.006930s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12930234 ORDER BY `minOrder` ASC [ RunTime:0.013333s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12930233 LIMIT 5 [ RunTime:0.009268s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12930233 ORDER BY `minOrder` ASC [ RunTime:0.018881s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12930233 ORDER BY `unit` DESC [ RunTime:0.029240s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12930233 LIMIT 2 [ RunTime:0.035512s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12930233 ORDER BY `minOrder` ASC [ RunTime:0.014646s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12930227 LIMIT 5 [ RunTime:0.020194s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12930227 ORDER BY `minOrder` ASC [ RunTime:0.014587s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12930227 ORDER BY `unit` DESC [ RunTime:0.009086s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12930227 LIMIT 2 [ RunTime:0.013316s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12930227 ORDER BY `minOrder` ASC [ RunTime:0.012092s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12930226 LIMIT 5 [ RunTime:0.015052s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12930226 ORDER BY `minOrder` ASC [ RunTime:0.030589s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12930226 ORDER BY `unit` DESC [ RunTime:0.012500s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12930226 LIMIT 2 [ RunTime:0.021311s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12930226 ORDER BY `minOrder` ASC [ RunTime:0.000883s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12930225 LIMIT 5 [ RunTime:0.019847s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12930225 ORDER BY `minOrder` ASC [ RunTime:0.024412s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12930225 ORDER BY `unit` DESC [ RunTime:0.016354s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12930225 LIMIT 2 [ RunTime:0.033683s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12930225 ORDER BY `minOrder` ASC [ RunTime:0.018948s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12930224 LIMIT 5 [ RunTime:0.012086s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12930224 ORDER BY `minOrder` ASC [ RunTime:0.023083s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12930224 ORDER BY `unit` DESC [ RunTime:0.023120s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12930224 LIMIT 2 [ RunTime:0.041302s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12930224 ORDER BY `minOrder` ASC [ RunTime:0.003295s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12930223 LIMIT 5 [ RunTime:0.014779s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12930223 ORDER BY `minOrder` ASC [ RunTime:0.018971s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12930223 ORDER BY `unit` DESC [ RunTime:0.053373s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12930223 LIMIT 2 [ RunTime:0.027361s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12930223 ORDER BY `minOrder` ASC [ RunTime:0.015705s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12930220 LIMIT 5 [ RunTime:0.020668s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12930220 ORDER BY `minOrder` ASC [ RunTime:0.015212s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12930220 ORDER BY `unit` DESC [ RunTime:0.016272s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12930220 LIMIT 2 [ RunTime:0.026417s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12930220 ORDER BY `minOrder` ASC [ RunTime:0.005088s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12930219 LIMIT 5 [ RunTime:0.000930s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12930219 ORDER BY `minOrder` ASC [ RunTime:0.006772s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12930219 ORDER BY `unit` DESC [ RunTime:0.017161s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12930219 LIMIT 2 [ RunTime:0.011158s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12930219 ORDER BY `minOrder` ASC [ RunTime:0.007349s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12930218 LIMIT 5 [ RunTime:0.003442s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12930218 ORDER BY `minOrder` ASC [ RunTime:0.008959s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12930218 ORDER BY `unit` DESC [ RunTime:0.020223s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12930218 LIMIT 2 [ RunTime:0.005695s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12930218 ORDER BY `minOrder` ASC [ RunTime:0.002851s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11718630 LIMIT 5 [ RunTime:0.015503s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11718630 ORDER BY `minOrder` ASC [ RunTime:0.004922s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11718630 ORDER BY `unit` DESC [ RunTime:0.009257s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11718630 LIMIT 2 [ RunTime:0.000677s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11718630 ORDER BY `minOrder` ASC [ RunTime:0.007619s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11718625 LIMIT 5 [ RunTime:0.002796s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11718625 ORDER BY `minOrder` ASC [ RunTime:0.008792s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11718625 ORDER BY `unit` DESC [ RunTime:0.004122s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11718625 LIMIT 2 [ RunTime:0.000603s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11718625 ORDER BY `minOrder` ASC [ RunTime:0.000402s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11718624 LIMIT 5 [ RunTime:0.008315s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11718624 ORDER BY `minOrder` ASC [ RunTime:0.001507s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11718624 ORDER BY `unit` DESC [ RunTime:0.005141s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11718624 LIMIT 2 [ RunTime:0.009395s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11718624 ORDER BY `minOrder` ASC [ RunTime:0.000614s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11718620 LIMIT 5 [ RunTime:0.000494s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11718620 ORDER BY `minOrder` ASC [ RunTime:0.000462s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11718620 ORDER BY `unit` DESC [ RunTime:0.005506s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11718620 LIMIT 2 [ RunTime:0.009767s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11718620 ORDER BY `minOrder` ASC [ RunTime:0.012416s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11718619 LIMIT 5 [ RunTime:0.002558s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11718619 ORDER BY `minOrder` ASC [ RunTime:0.003810s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11718619 ORDER BY `unit` DESC [ RunTime:0.003732s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11718619 LIMIT 2 [ RunTime:0.004029s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11718619 ORDER BY `minOrder` ASC [ RunTime:0.001386s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11718618 LIMIT 5 [ RunTime:0.000816s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11718618 ORDER BY `minOrder` ASC [ RunTime:0.002583s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11718618 ORDER BY `unit` DESC [ RunTime:0.001670s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11718618 LIMIT 2 [ RunTime:0.000706s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11718618 ORDER BY `minOrder` ASC [ RunTime:0.006922s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11084845 LIMIT 5 [ RunTime:0.010291s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11084845 ORDER BY `minOrder` ASC [ RunTime:0.003648s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11084845 ORDER BY `unit` DESC [ RunTime:0.002810s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11084845 LIMIT 2 [ RunTime:0.003851s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11084845 ORDER BY `minOrder` ASC [ RunTime:0.000549s ]
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-96P%' OR `brand` LIKE 'LJT00RE-19-96P%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.032432s ]
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-96P%' OR `brand` LIKE 'LJT00RE-19-96P%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.018657s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61753275 LIMIT 5 [ RunTime:0.006033s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61753275 ORDER BY `minOrder` ASC [ RunTime:0.012118s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61753275 ORDER BY `unit` DESC [ RunTime:0.010386s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61753275 LIMIT 2 [ RunTime:0.000617s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61753275 ORDER BY `minOrder` ASC [ RunTime:0.003284s ]
select * from pdf where partno='LJT00RE-19-96P(424)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.009553s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.003148s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LJT00RE-19-96P(424)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.008731s ]
SELECT `id` FROM `stock` WHERE `id` <> 61753275 AND `partno` = 'LJT00RE-19-96P(424)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.001399s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11084843 [ RunTime:0.000546s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61753274 LIMIT 5 [ RunTime:0.000482s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61753274 ORDER BY `minOrder` ASC [ RunTime:0.026117s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61753274 ORDER BY `unit` DESC [ RunTime:0.037742s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61753274 LIMIT 2 [ RunTime:0.006615s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61753274 ORDER BY `minOrder` ASC [ RunTime:0.001744s ]
select * from pdf where partno='LJT00RE-19-96P(SR)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.001114s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LJT00RE-19-96P(SR)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.011844s ]
SELECT `id` FROM `stock` WHERE `id` <> 61753274 AND `partno` = 'LJT00RE-19-96P(SR)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.020566s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11084841 [ RunTime:0.004435s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61753273 LIMIT 5 [ RunTime:0.015207s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61753273 ORDER BY `minOrder` ASC [ RunTime:0.001135s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61753273 ORDER BY `unit` DESC [ RunTime:0.005216s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61753273 LIMIT 2 [ RunTime:0.017059s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61753273 ORDER BY `minOrder` ASC [ RunTime:0.017350s ]
select * from pdf where partno='LJT00RE-19-96P(344)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.008152s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LJT00RE-19-96P(344)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.000698s ]
SELECT `id` FROM `stock` WHERE `id` <> 61753273 AND `partno` = 'LJT00RE-19-96P(344)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.000727s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11084840 [ RunTime:0.008634s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61721822 LIMIT 5 [ RunTime:0.002687s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61721822 ORDER BY `minOrder` ASC [ RunTime:0.006921s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61721822 ORDER BY `unit` DESC [ RunTime:0.002329s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61721822 LIMIT 2 [ RunTime:0.022894s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61721822 ORDER BY `minOrder` ASC [ RunTime:0.006359s ]
select * from pdf where partno='LJT00RE-19-96P(439)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.011302s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LJT00RE-19-96P(439)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.018939s ]
SELECT `id` FROM `stock` WHERE `id` <> 61721822 AND `partno` = 'LJT00RE-19-96P(439)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.021621s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61721819 LIMIT 5 [ RunTime:0.006594s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61721819 ORDER BY `minOrder` ASC [ RunTime:0.012517s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61721819 ORDER BY `unit` DESC [ RunTime:0.011755s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61721819 LIMIT 2 [ RunTime:0.004310s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61721819 ORDER BY `minOrder` ASC [ RunTime:0.002073s ]
select * from pdf where partno='LJT00RE-19-96P(408)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.002304s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LJT00RE-19-96P(408)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.010796s ]
SELECT `id` FROM `stock` WHERE `id` <> 61721819 AND `partno` = 'LJT00RE-19-96P(408)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.012501s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61721813 LIMIT 5 [ RunTime:0.009302s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61721813 ORDER BY `minOrder` ASC [ RunTime:0.001862s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61721813 ORDER BY `unit` DESC [ RunTime:0.016504s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61721813 LIMIT 2 [ RunTime:0.015445s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61721813 ORDER BY `minOrder` ASC [ RunTime:0.009409s ]
select * from pdf where partno='LJT00RE-19-96P(106)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.020847s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LJT00RE-19-96P(106)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.012634s ]
SELECT `id` FROM `stock` WHERE `id` <> 61721813 AND `partno` = 'LJT00RE-19-96P(106)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.006326s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61721810 LIMIT 5 [ RunTime:0.024495s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61721810 ORDER BY `minOrder` ASC [ RunTime:0.013141s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61721810 ORDER BY `unit` DESC [ RunTime:0.016672s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61721810 LIMIT 2 [ RunTime:0.002559s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61721810 ORDER BY `minOrder` ASC [ RunTime:0.012391s ]
select * from pdf where partno='LJT00RE-19-96P(406)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.052103s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LJT00RE-19-96P(406)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.017618s ]
SELECT `id` FROM `stock` WHERE `id` <> 61721810 AND `partno` = 'LJT00RE-19-96P(406)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.013924s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61694039 LIMIT 5 [ RunTime:0.016858s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61694039 ORDER BY `minOrder` ASC [ RunTime:0.022028s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61694039 ORDER BY `unit` DESC [ RunTime:0.012764s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61694039 LIMIT 2 [ RunTime:0.022644s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61694039 ORDER BY `minOrder` ASC [ RunTime:0.016369s ]
select * from pdf where partno='LJT00RE-19-96P' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.019663s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LJT00RE-19-96P' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.000710s ]
SELECT `id` FROM `stock` WHERE `id` <> 61694039 AND `partno` = 'LJT00RE-19-96P' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.004310s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11027094 [ RunTime:0.007210s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61694037 LIMIT 5 [ RunTime:0.001152s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61694037 ORDER BY `minOrder` ASC [ RunTime:0.007402s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61694037 ORDER BY `unit` DESC [ RunTime:0.003641s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61694037 LIMIT 2 [ RunTime:0.001402s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61694037 ORDER BY `minOrder` ASC [ RunTime:0.004063s ]
select * from pdf where partno='LJT00RE-19-96P(023)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.010949s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LJT00RE-19-96P(023)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.008620s ]
SELECT `id` FROM `stock` WHERE `id` <> 61694037 AND `partno` = 'LJT00RE-19-96P(023)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.005653s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11027090 [ RunTime:0.010832s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61694033 LIMIT 5 [ RunTime:0.008554s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61694033 ORDER BY `minOrder` ASC [ RunTime:0.016940s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61694033 ORDER BY `unit` DESC [ RunTime:0.001908s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61694033 LIMIT 2 [ RunTime:0.009577s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61694033 ORDER BY `minOrder` ASC [ RunTime:0.005966s ]
select * from pdf where partno='LJT00RE-19-96P(011)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.010126s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LJT00RE-19-96P(011)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.021607s ]
SELECT `id` FROM `stock` WHERE `id` <> 61694033 AND `partno` = 'LJT00RE-19-96P(011)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.015887s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11027086 [ RunTime:0.016008s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61167463 LIMIT 5 [ RunTime:0.009290s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61167463 ORDER BY `minOrder` ASC [ RunTime:0.018225s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61167463 ORDER BY `unit` DESC [ RunTime:0.011669s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61167463 LIMIT 2 [ RunTime:0.000413s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61167463 ORDER BY `minOrder` ASC [ RunTime:0.003518s ]
select * from pdf where partno='LJT00RE-19-96P(386)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.002474s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LJT00RE-19-96P(386)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.012971s ]
SELECT `id` FROM `stock` WHERE `id` <> 61167463 AND `partno` = 'LJT00RE-19-96P(386)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.017981s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11084845 [ RunTime:0.002465s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61165734 LIMIT 5 [ RunTime:0.013509s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61165734 ORDER BY `minOrder` ASC [ RunTime:0.042222s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61165734 ORDER BY `unit` DESC [ RunTime:0.009543s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61165734 LIMIT 2 [ RunTime:0.026557s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61165734 ORDER BY `minOrder` ASC [ RunTime:0.006856s ]
select * from pdf where partno='LJT00RE-19-96P(014)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.022580s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LJT00RE-19-96P(014)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.018461s ]
SELECT `id` FROM `stock` WHERE `id` <> 61165734 AND `partno` = 'LJT00RE-19-96P(014)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.018356s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11027084 [ RunTime:0.013153s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60230266 LIMIT 5 [ RunTime:0.002824s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60230266 ORDER BY `minOrder` ASC [ RunTime:0.018045s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60230266 ORDER BY `unit` DESC [ RunTime:0.006748s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60230266 LIMIT 2 [ RunTime:0.024727s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60230266 ORDER BY `minOrder` ASC [ RunTime:0.006844s ]
select * from pdf where partno='LJT00RE-19-96PD(011LC)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.010288s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LJT00RE-19-96PD(011LC)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.009798s ]
SELECT `id` FROM `stock` WHERE `id` <> 60230266 AND `partno` = 'LJT00RE-19-96PD(011LC)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.017934s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12930242 [ RunTime:0.022844s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60230265 LIMIT 5 [ RunTime:0.014803s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60230265 ORDER BY `minOrder` ASC [ RunTime:0.014930s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60230265 ORDER BY `unit` DESC [ RunTime:0.004171s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60230265 LIMIT 2 [ RunTime:0.003613s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60230265 ORDER BY `minOrder` ASC [ RunTime:0.005986s ]
select * from pdf where partno='LJT00RE-19-96PD(023LC)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.005846s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LJT00RE-19-96PD(023LC)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.004458s ]
SELECT `id` FROM `stock` WHERE `id` <> 60230265 AND `partno` = 'LJT00RE-19-96PD(023LC)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.001957s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12930241 [ RunTime:0.007754s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60230264 LIMIT 5 [ RunTime:0.015800s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60230264 ORDER BY `minOrder` ASC [ RunTime:0.011729s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60230264 ORDER BY `unit` DESC [ RunTime:0.000472s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60230264 LIMIT 2 [ RunTime:0.010984s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60230264 ORDER BY `minOrder` ASC [ RunTime:0.003344s ]
select * from pdf where partno='LJT00RE-19-96PD(LC)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.006545s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LJT00RE-19-96PD(LC)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.005096s ]
SELECT `id` FROM `stock` WHERE `id` <> 60230264 AND `partno` = 'LJT00RE-19-96PD(LC)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.004510s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11718630 [ RunTime:0.003836s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60230259 LIMIT 5 [ RunTime:0.010489s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60230259 ORDER BY `minOrder` ASC [ RunTime:0.001827s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60230259 ORDER BY `unit` DESC [ RunTime:0.014141s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60230259 LIMIT 2 [ RunTime:0.012093s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60230259 ORDER BY `minOrder` ASC [ RunTime:0.000628s ]
select * from pdf where partno='LJT00RE-19-96PA(023LC)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.011895s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LJT00RE-19-96PA(023LC)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.004137s ]
SELECT `id` FROM `stock` WHERE `id` <> 60230259 AND `partno` = 'LJT00RE-19-96PA(023LC)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.010687s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11718625 [ RunTime:0.011751s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60230258 LIMIT 5 [ RunTime:0.004644s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60230258 ORDER BY `minOrder` ASC [ RunTime:0.018514s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60230258 ORDER BY `unit` DESC [ RunTime:0.000998s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60230258 LIMIT 2 [ RunTime:0.000738s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60230258 ORDER BY `minOrder` ASC [ RunTime:0.002856s ]
select * from pdf where partno='LJT00RE-19-96PA(011LC)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.007534s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LJT00RE-19-96PA(011LC)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.001790s ]
SELECT `id` FROM `stock` WHERE `id` <> 60230258 AND `partno` = 'LJT00RE-19-96PA(011LC)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.000489s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12930234 [ RunTime:0.000296s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60230257 LIMIT 5 [ RunTime:0.001545s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60230257 ORDER BY `minOrder` ASC [ RunTime:0.003830s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60230257 ORDER BY `unit` DESC [ RunTime:0.004223s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60230257 LIMIT 2 [ RunTime:0.000586s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60230257 ORDER BY `minOrder` ASC [ RunTime:0.002749s ]
select * from pdf where partno='LJT00RE-19-96PA(LC)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.004597s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LJT00RE-19-96PA(LC)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.002845s ]
SELECT `id` FROM `stock` WHERE `id` <> 60230257 AND `partno` = 'LJT00RE-19-96PA(LC)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.009142s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11718624 [ RunTime:0.000359s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60230256 LIMIT 5 [ RunTime:0.000268s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60230256 ORDER BY `minOrder` ASC [ RunTime:0.003260s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60230256 ORDER BY `unit` DESC [ RunTime:0.003182s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60230256 LIMIT 2 [ RunTime:0.002511s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60230256 ORDER BY `minOrder` ASC [ RunTime:0.004064s ]
select * from pdf where partno='LJT00RE-19-96PB(LC)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.004445s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LJT00RE-19-96PB(LC)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.009172s ]
SELECT `id` FROM `stock` WHERE `id` <> 60230256 AND `partno` = 'LJT00RE-19-96PB(LC)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.010307s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12930227 [ RunTime:0.000627s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60230255 LIMIT 5 [ RunTime:0.009697s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60230255 ORDER BY `minOrder` ASC [ RunTime:0.002450s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60230255 ORDER BY `unit` DESC [ RunTime:0.002296s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60230255 LIMIT 2 [ RunTime:0.000639s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60230255 ORDER BY `minOrder` ASC [ RunTime:0.000441s ]
select * from pdf where partno='LJT00RE-19-96PB(023LC)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.019350s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LJT00RE-19-96PB(023LC)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.004601s ]
SELECT `id` FROM `stock` WHERE `id` <> 60230255 AND `partno` = 'LJT00RE-19-96PB(023LC)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.009224s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12930225 [ RunTime:0.004775s ]
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-96P%' OR `brand` LIKE 'LJT00RE-19-96P%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013250s ]
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-96P%' OR `brand` LIKE 'LJT00RE-19-96P%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003295s ]
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-96P%' OR `brand` LIKE 'LJT00RE-19-96P%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004836s ]
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-96P%' OR `brand` LIKE 'LJT00RE-19-96P%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001559s ]
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-96P%' OR `brand` LIKE 'LJT00RE-19-96P%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011388s ]
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-96P%' OR `brand` LIKE 'LJT00RE-19-96P%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008195s ]
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-96P%' OR `brand` LIKE 'LJT00RE-19-96P%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009940s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'LJT00RE-19-96P%' OR `brand` LIKE 'LJT00RE-19-96P%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.015726s ]