SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001430s ]
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=LT1767EMS8&search=1' [ RunTime:0.052514s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001516s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.007065s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001432s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.142' ) [ RunTime:0.005756s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001149s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.003961s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001454s ]
SELECT * FROM `stock_search` WHERE `partno` = 'LT1767EMS8' LIMIT 1 [ RunTime:0.002373s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-08-02 02:19:55' WHERE `partno` = 'LT1767EMS8' [ RunTime:0.009552s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002863s ]
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 'LT1767EMS8%' OR `brand` LIKE 'LT1767EMS8%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.029857s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.003273s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17091821 LIMIT 5 [ RunTime:0.048901s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001330s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17091821 ORDER BY `minOrder` ASC [ RunTime:0.006419s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001307s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17091821 ORDER BY `unit` DESC [ RunTime:0.060594s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.023793s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17091821 LIMIT 2 [ RunTime:0.037136s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17091821 ORDER BY `minOrder` ASC [ RunTime:0.008482s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19123082 LIMIT 5 [ RunTime:0.083984s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19123082 ORDER BY `minOrder` ASC [ RunTime:0.036947s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19123082 ORDER BY `unit` DESC [ RunTime:0.050214s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19123082 LIMIT 2 [ RunTime:0.064853s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19123082 ORDER BY `minOrder` ASC [ RunTime:0.040916s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19133537 LIMIT 5 [ RunTime:0.060861s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19133537 ORDER BY `minOrder` ASC [ RunTime:0.063712s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19133537 ORDER BY `unit` DESC [ RunTime:0.059434s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19133537 LIMIT 2 [ RunTime:0.046264s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19133537 ORDER BY `minOrder` ASC [ RunTime:0.002973s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19121803 LIMIT 5 [ RunTime:0.044517s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19121803 ORDER BY `minOrder` ASC [ RunTime:0.098063s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19121803 ORDER BY `unit` DESC [ RunTime:0.049196s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19121803 LIMIT 2 [ RunTime:0.039849s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19121803 ORDER BY `minOrder` ASC [ RunTime:0.010038s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19121534 LIMIT 5 [ RunTime:0.029240s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19121534 ORDER BY `minOrder` ASC [ RunTime:0.061724s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19121534 ORDER BY `unit` DESC [ RunTime:0.025137s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19121534 LIMIT 2 [ RunTime:0.014834s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19121534 ORDER BY `minOrder` ASC [ RunTime:0.018671s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19134422 LIMIT 5 [ RunTime:0.034851s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19134422 ORDER BY `minOrder` ASC [ RunTime:0.031336s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19134422 ORDER BY `unit` DESC [ RunTime:0.071586s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19134422 LIMIT 2 [ RunTime:0.016029s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19134422 ORDER BY `minOrder` ASC [ RunTime:0.015001s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19135321 LIMIT 5 [ RunTime:0.045235s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19135321 ORDER BY `minOrder` ASC [ RunTime:0.014009s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19135321 ORDER BY `unit` DESC [ RunTime:0.042636s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19135321 LIMIT 2 [ RunTime:0.012105s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19135321 ORDER BY `minOrder` ASC [ RunTime:0.007906s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16063331 LIMIT 5 [ RunTime:0.013629s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16063331 ORDER BY `minOrder` ASC [ RunTime:0.017099s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16063331 ORDER BY `unit` DESC [ RunTime:0.006617s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16063331 LIMIT 2 [ RunTime:0.032996s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16063331 ORDER BY `minOrder` ASC [ RunTime:0.014074s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14222948 LIMIT 5 [ RunTime:0.036836s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14222948 ORDER BY `minOrder` ASC [ RunTime:0.034973s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14222948 ORDER BY `unit` DESC [ RunTime:0.012018s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14222948 LIMIT 2 [ RunTime:0.014320s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14222948 ORDER BY `minOrder` ASC [ RunTime:0.004224s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16062440 LIMIT 5 [ RunTime:0.028652s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16062440 ORDER BY `minOrder` ASC [ RunTime:0.028506s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16062440 ORDER BY `unit` DESC [ RunTime:0.037961s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16062440 LIMIT 2 [ RunTime:0.018512s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16062440 ORDER BY `minOrder` ASC [ RunTime:0.010612s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19123093 LIMIT 5 [ RunTime:0.005450s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19123093 ORDER BY `minOrder` ASC [ RunTime:0.040278s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19123093 ORDER BY `unit` DESC [ RunTime:0.046516s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19123093 LIMIT 2 [ RunTime:0.033821s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19123093 ORDER BY `minOrder` ASC [ RunTime:0.024411s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19123092 LIMIT 5 [ RunTime:0.003065s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19123092 ORDER BY `minOrder` ASC [ RunTime:0.067088s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19123092 ORDER BY `unit` DESC [ RunTime:0.020190s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19123092 LIMIT 2 [ RunTime:0.020056s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19123092 ORDER BY `minOrder` ASC [ RunTime:0.011343s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19133531 LIMIT 5 [ RunTime:0.019035s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19133531 ORDER BY `minOrder` ASC [ RunTime:0.069714s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19133531 ORDER BY `unit` DESC [ RunTime:0.022658s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19133531 LIMIT 2 [ RunTime:0.027438s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19133531 ORDER BY `minOrder` ASC [ RunTime:0.025668s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15315323 LIMIT 5 [ RunTime:0.038387s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15315323 ORDER BY `minOrder` ASC [ RunTime:0.080335s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15315323 ORDER BY `unit` DESC [ RunTime:0.048021s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15315323 LIMIT 2 [ RunTime:0.003435s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15315323 ORDER BY `minOrder` ASC [ RunTime:0.022032s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15315580 LIMIT 5 [ RunTime:0.057219s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15315580 ORDER BY `minOrder` ASC [ RunTime:0.024248s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15315580 ORDER BY `unit` DESC [ RunTime:0.061483s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15315580 LIMIT 2 [ RunTime:0.034607s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15315580 ORDER BY `minOrder` ASC [ RunTime:0.031219s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19135327 LIMIT 5 [ RunTime:0.039751s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19135327 ORDER BY `minOrder` ASC [ RunTime:0.056626s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19135327 ORDER BY `unit` DESC [ RunTime:0.035081s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19135327 LIMIT 2 [ RunTime:0.025275s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19135327 ORDER BY `minOrder` ASC [ RunTime:0.043686s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19134431 LIMIT 5 [ RunTime:0.035405s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19134431 ORDER BY `minOrder` ASC [ RunTime:0.047446s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19134431 ORDER BY `unit` DESC [ RunTime:0.048330s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19134431 LIMIT 2 [ RunTime:0.115498s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19134431 ORDER BY `minOrder` ASC [ RunTime:0.021754s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17095047 LIMIT 5 [ RunTime:0.071215s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17095047 ORDER BY `minOrder` ASC [ RunTime:0.020716s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17095047 ORDER BY `unit` DESC [ RunTime:0.025024s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17095047 LIMIT 2 [ RunTime:0.061199s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17095047 ORDER BY `minOrder` ASC [ RunTime:0.009833s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17093913 LIMIT 5 [ RunTime:0.025841s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17093913 ORDER BY `minOrder` ASC [ RunTime:0.012074s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17093913 ORDER BY `unit` DESC [ RunTime:0.039537s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17093913 LIMIT 2 [ RunTime:0.020916s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17093913 ORDER BY `minOrder` ASC [ RunTime:0.021724s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17093902 LIMIT 5 [ RunTime:0.022279s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17093902 ORDER BY `minOrder` ASC [ RunTime:0.033299s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17093902 ORDER BY `unit` DESC [ RunTime:0.009344s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17093902 LIMIT 2 [ RunTime:0.028338s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17093902 ORDER BY `minOrder` ASC [ RunTime:0.028738s ]
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 'LT1767EMS8%' OR `brand` LIKE 'LT1767EMS8%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.029528s ]
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 'LT1767EMS8%' OR `brand` LIKE 'LT1767EMS8%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.021030s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57064363 LIMIT 5 [ RunTime:0.007096s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57064363 ORDER BY `minOrder` ASC [ RunTime:0.032621s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57064363 ORDER BY `unit` DESC [ RunTime:0.008679s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57064363 LIMIT 2 [ RunTime:0.008005s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57064363 ORDER BY `minOrder` ASC [ RunTime:0.004634s ]
select * from pdf where partno='LT1767EMS8#TRPBF' and brandshort='Analog Devices Inc.' limit 1 [ RunTime:0.025270s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002492s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LT1767EMS8#TRPBF' OR `brand` LIKE 'Analog Devices Inc.%' ) ) LIMIT 1 [ RunTime:0.029530s ]
SELECT `id` FROM `stock` WHERE `id` <> 57064363 AND `partno` = 'LT1767EMS8#TRPBF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%analog devices inc.%' ) [ RunTime:0.049582s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19123082 [ RunTime:0.014341s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57064397 LIMIT 5 [ RunTime:0.018562s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57064397 ORDER BY `minOrder` ASC [ RunTime:0.049431s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57064397 ORDER BY `unit` DESC [ RunTime:0.036635s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57064397 LIMIT 2 [ RunTime:0.021901s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57064397 ORDER BY `minOrder` ASC [ RunTime:0.007295s ]
select * from pdf where partno='LT1767EMS8E-5#TRPBF' and brandshort='Analog Devices Inc.' limit 1 [ RunTime:0.052953s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LT1767EMS8E-5#TRPBF' OR `brand` LIKE 'Analog Devices Inc.%' ) ) LIMIT 1 [ RunTime:0.043284s ]
SELECT `id` FROM `stock` WHERE `id` <> 57064397 AND `partno` = 'LT1767EMS8E-5#TRPBF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%analog devices inc.%' ) [ RunTime:0.006305s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19121803 [ RunTime:0.046194s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57062074 LIMIT 5 [ RunTime:0.022264s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57062074 ORDER BY `minOrder` ASC [ RunTime:0.029688s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57062074 ORDER BY `unit` DESC [ RunTime:0.012012s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57062074 LIMIT 2 [ RunTime:0.038711s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57062074 ORDER BY `minOrder` ASC [ RunTime:0.027475s ]
select * from pdf where partno='LT1767EMS8E-3.3#TRPBF' and brandshort='Analog Devices Inc.' limit 1 [ RunTime:0.015483s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LT1767EMS8E-3.3#TRPBF' OR `brand` LIKE 'Analog Devices Inc.%' ) ) LIMIT 1 [ RunTime:0.015378s ]
SELECT `id` FROM `stock` WHERE `id` <> 57062074 AND `partno` = 'LT1767EMS8E-3.3#TRPBF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%analog devices inc.%' ) [ RunTime:0.052258s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17091821 [ RunTime:0.033347s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57062075 LIMIT 5 [ RunTime:0.034401s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57062075 ORDER BY `minOrder` ASC [ RunTime:0.047264s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57062075 ORDER BY `unit` DESC [ RunTime:0.034602s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57062075 LIMIT 2 [ RunTime:0.039883s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57062075 ORDER BY `minOrder` ASC [ RunTime:0.011956s ]
select * from pdf where partno='LT1767EMS8E#TRPBF' and brandshort='Analog Devices Inc.' limit 1 [ RunTime:0.023704s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LT1767EMS8E#TRPBF' OR `brand` LIKE 'Analog Devices Inc.%' ) ) LIMIT 1 [ RunTime:0.026288s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57062076 LIMIT 5 [ RunTime:0.051588s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57062076 ORDER BY `minOrder` ASC [ RunTime:0.081614s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57062076 ORDER BY `unit` DESC [ RunTime:0.014590s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57062076 LIMIT 2 [ RunTime:0.034220s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57062076 ORDER BY `minOrder` ASC [ RunTime:0.026089s ]
select * from pdf where partno='LT1767EMS8E-3.3#PBF' and brandshort='Analog Devices Inc.' limit 1 [ RunTime:0.037106s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LT1767EMS8E-3.3#PBF' OR `brand` LIKE 'Analog Devices Inc.%' ) ) LIMIT 1 [ RunTime:0.022780s ]
SELECT `id` FROM `stock` WHERE `id` <> 57062076 AND `partno` = 'LT1767EMS8E-3.3#PBF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%analog devices inc.%' ) [ RunTime:0.019903s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19123092 [ RunTime:0.079969s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57064364 LIMIT 5 [ RunTime:0.029089s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57064364 ORDER BY `minOrder` ASC [ RunTime:0.040586s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57064364 ORDER BY `unit` DESC [ RunTime:0.060949s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57064364 LIMIT 2 [ RunTime:0.026743s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57064364 ORDER BY `minOrder` ASC [ RunTime:0.030788s ]
select * from pdf where partno='LT1767EMS8#PBF' and brandshort='Analog Devices Inc.' limit 1 [ RunTime:0.032093s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LT1767EMS8#PBF' OR `brand` LIKE 'Analog Devices Inc.%' ) ) LIMIT 1 [ RunTime:0.008125s ]
SELECT `id` FROM `stock` WHERE `id` <> 57064364 AND `partno` = 'LT1767EMS8#PBF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%analog devices inc.%' ) [ RunTime:0.016728s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19133531 [ RunTime:0.008424s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57064398 LIMIT 5 [ RunTime:0.014550s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57064398 ORDER BY `minOrder` ASC [ RunTime:0.024608s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57064398 ORDER BY `unit` DESC [ RunTime:0.024572s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57064398 LIMIT 2 [ RunTime:0.041724s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57064398 ORDER BY `minOrder` ASC [ RunTime:0.004182s ]
select * from pdf where partno='LT1767EMS8E#PBF' and brandshort='Analog Devices Inc.' limit 1 [ RunTime:0.017143s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LT1767EMS8E#PBF' OR `brand` LIKE 'Analog Devices Inc.%' ) ) LIMIT 1 [ RunTime:0.015925s ]
SELECT `id` FROM `stock` WHERE `id` <> 57064398 AND `partno` = 'LT1767EMS8E#PBF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%analog devices inc.%' ) [ RunTime:0.024174s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19123093 [ RunTime:0.001947s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57062056 LIMIT 5 [ RunTime:0.006727s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57062056 ORDER BY `minOrder` ASC [ RunTime:0.020563s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57062056 ORDER BY `unit` DESC [ RunTime:0.002569s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57062056 LIMIT 2 [ RunTime:0.002671s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57062056 ORDER BY `minOrder` ASC [ RunTime:0.012430s ]
select * from pdf where partno='LT1767EMS8-3.3#PBF' and brandshort='Analog Devices Inc.' limit 1 [ RunTime:0.011405s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LT1767EMS8-3.3#PBF' OR `brand` LIKE 'Analog Devices Inc.%' ) ) LIMIT 1 [ RunTime:0.028386s ]
SELECT `id` FROM `stock` WHERE `id` <> 57062056 AND `partno` = 'LT1767EMS8-3.3#PBF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%analog devices inc.%' ) [ RunTime:0.015388s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16063331 [ RunTime:0.024448s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57064399 LIMIT 5 [ RunTime:0.032440s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57064399 ORDER BY `minOrder` ASC [ RunTime:0.012370s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57064399 ORDER BY `unit` DESC [ RunTime:0.018076s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57064399 LIMIT 2 [ RunTime:0.004305s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57064399 ORDER BY `minOrder` ASC [ RunTime:0.001972s ]
select * from pdf where partno='LT1767EMS8E-5#PBF' and brandshort='Analog Devices Inc.' limit 1 [ RunTime:0.016874s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LT1767EMS8E-5#PBF' OR `brand` LIKE 'Analog Devices Inc.%' ) ) LIMIT 1 [ RunTime:0.025738s ]
SELECT `id` FROM `stock` WHERE `id` <> 57064399 AND `partno` = 'LT1767EMS8E-5#PBF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%analog devices inc.%' ) [ RunTime:0.001185s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15315323 [ RunTime:0.018955s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57068160 LIMIT 5 [ RunTime:0.070112s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57068160 ORDER BY `minOrder` ASC [ RunTime:0.028913s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57068160 ORDER BY `unit` DESC [ RunTime:0.020064s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57068160 LIMIT 2 [ RunTime:0.033355s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57068160 ORDER BY `minOrder` ASC [ RunTime:0.024535s ]
select * from pdf where partno='LT1767EMS8-2.5#PBF' and brandshort='Analog Devices Inc.' limit 1 [ RunTime:0.044119s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LT1767EMS8-2.5#PBF' OR `brand` LIKE 'Analog Devices Inc.%' ) ) LIMIT 1 [ RunTime:0.026697s ]
SELECT `id` FROM `stock` WHERE `id` <> 57068160 AND `partno` = 'LT1767EMS8-2.5#PBF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%analog devices inc.%' ) [ RunTime:0.002984s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15315580 [ RunTime:0.088529s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57066569 LIMIT 5 [ RunTime:0.057279s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57066569 ORDER BY `minOrder` ASC [ RunTime:0.061615s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57066569 ORDER BY `unit` DESC [ RunTime:0.018497s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57066569 LIMIT 2 [ RunTime:0.026365s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57066569 ORDER BY `minOrder` ASC [ RunTime:0.009082s ]
select * from pdf where partno='LT1767EMS8E-2.5#PBF' and brandshort='Analog Devices Inc.' limit 1 [ RunTime:0.044439s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LT1767EMS8E-2.5#PBF' OR `brand` LIKE 'Analog Devices Inc.%' ) ) LIMIT 1 [ RunTime:0.037559s ]
SELECT `id` FROM `stock` WHERE `id` <> 57066569 AND `partno` = 'LT1767EMS8E-2.5#PBF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%analog devices inc.%' ) [ RunTime:0.022881s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19134431 [ RunTime:0.063740s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57068178 LIMIT 5 [ RunTime:0.032891s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57068178 ORDER BY `minOrder` ASC [ RunTime:0.040911s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57068178 ORDER BY `unit` DESC [ RunTime:0.019704s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57068178 LIMIT 2 [ RunTime:0.027939s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57068178 ORDER BY `minOrder` ASC [ RunTime:0.010000s ]
select * from pdf where partno='LT1767EMS8E-1.8#PBF' and brandshort='Analog Devices Inc.' limit 1 [ RunTime:0.012332s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LT1767EMS8E-1.8#PBF' OR `brand` LIKE 'Analog Devices Inc.%' ) ) LIMIT 1 [ RunTime:0.019802s ]
SELECT `id` FROM `stock` WHERE `id` <> 57068178 AND `partno` = 'LT1767EMS8E-1.8#PBF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%analog devices inc.%' ) [ RunTime:0.003770s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19135327 [ RunTime:0.022283s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57068161 LIMIT 5 [ RunTime:0.043799s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57068161 ORDER BY `minOrder` ASC [ RunTime:0.019418s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57068161 ORDER BY `unit` DESC [ RunTime:0.022265s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57068161 LIMIT 2 [ RunTime:0.034710s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57068161 ORDER BY `minOrder` ASC [ RunTime:0.020081s ]
select * from pdf where partno='LT1767EMS8-1.8#PBF' and brandshort='Analog Devices Inc.' limit 1 [ RunTime:0.023576s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LT1767EMS8-1.8#PBF' OR `brand` LIKE 'Analog Devices Inc.%' ) ) LIMIT 1 [ RunTime:0.021938s ]
SELECT `id` FROM `stock` WHERE `id` <> 57068161 AND `partno` = 'LT1767EMS8-1.8#PBF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%analog devices inc.%' ) [ RunTime:0.065477s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17095047 [ RunTime:0.021689s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57091812 LIMIT 5 [ RunTime:0.017749s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57091812 ORDER BY `minOrder` ASC [ RunTime:0.014912s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57091812 ORDER BY `unit` DESC [ RunTime:0.011382s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57091812 LIMIT 2 [ RunTime:0.053513s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57091812 ORDER BY `minOrder` ASC [ RunTime:0.018242s ]
select * from pdf where partno='LT1767EMS8E-1.8#TRPBF' and brandshort='Analog Devices Inc.' limit 1 [ RunTime:0.038278s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LT1767EMS8E-1.8#TRPBF' OR `brand` LIKE 'Analog Devices Inc.%' ) ) LIMIT 1 [ RunTime:0.023924s ]
SELECT `id` FROM `stock` WHERE `id` <> 57091812 AND `partno` = 'LT1767EMS8E-1.8#TRPBF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%analog devices inc.%' ) [ RunTime:0.015042s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16067584 [ RunTime:0.022637s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57091811 LIMIT 5 [ RunTime:0.017135s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57091811 ORDER BY `minOrder` ASC [ RunTime:0.011902s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57091811 ORDER BY `unit` DESC [ RunTime:0.023644s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57091811 LIMIT 2 [ RunTime:0.015272s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57091811 ORDER BY `minOrder` ASC [ RunTime:0.020870s ]
select * from pdf where partno='LT1767EMS8E-2.5#TRPBF' and brandshort='Analog Devices Inc.' limit 1 [ RunTime:0.010158s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LT1767EMS8E-2.5#TRPBF' OR `brand` LIKE 'Analog Devices Inc.%' ) ) LIMIT 1 [ RunTime:0.026970s ]
SELECT `id` FROM `stock` WHERE `id` <> 57091811 AND `partno` = 'LT1767EMS8E-2.5#TRPBF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%analog devices inc.%' ) [ RunTime:0.018012s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17093913 [ RunTime:0.031816s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57091748 LIMIT 5 [ RunTime:0.016368s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57091748 ORDER BY `minOrder` ASC [ RunTime:0.007796s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57091748 ORDER BY `unit` DESC [ RunTime:0.021445s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57091748 LIMIT 2 [ RunTime:0.032692s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57091748 ORDER BY `minOrder` ASC [ RunTime:0.015250s ]
select * from pdf where partno='LT1767EMS8-1.8#TRPBF' and brandshort='Analog Devices Inc.' limit 1 [ RunTime:0.006362s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LT1767EMS8-1.8#TRPBF' OR `brand` LIKE 'Analog Devices Inc.%' ) ) LIMIT 1 [ RunTime:0.008812s ]
SELECT `id` FROM `stock` WHERE `id` <> 57091748 AND `partno` = 'LT1767EMS8-1.8#TRPBF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%analog devices inc.%' ) [ RunTime:0.025166s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17093902 [ RunTime:0.015395s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57091747 LIMIT 5 [ RunTime:0.023921s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57091747 ORDER BY `minOrder` ASC [ RunTime:0.011159s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57091747 ORDER BY `unit` DESC [ RunTime:0.011863s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57091747 LIMIT 2 [ RunTime:0.004905s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57091747 ORDER BY `minOrder` ASC [ RunTime:0.011616s ]
select * from pdf where partno='LT1767EMS8-2.5#TRPBF' and brandshort='Analog Devices Inc.' limit 1 [ RunTime:0.011263s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LT1767EMS8-2.5#TRPBF' OR `brand` LIKE 'Analog Devices Inc.%' ) ) LIMIT 1 [ RunTime:0.014317s ]
SELECT `id` FROM `stock` WHERE `id` <> 57091747 AND `partno` = 'LT1767EMS8-2.5#TRPBF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%analog devices inc.%' ) [ RunTime:0.009775s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16067564 [ RunTime:0.020728s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57091745 LIMIT 5 [ RunTime:0.017194s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57091745 ORDER BY `minOrder` ASC [ RunTime:0.002331s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57091745 ORDER BY `unit` DESC [ RunTime:0.014294s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57091745 LIMIT 2 [ RunTime:0.005143s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57091745 ORDER BY `minOrder` ASC [ RunTime:0.007067s ]
select * from pdf where partno='LT1767EMS8-3.3#TRPBF' and brandshort='Analog Devices Inc.' limit 1 [ RunTime:0.029182s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LT1767EMS8-3.3#TRPBF' OR `brand` LIKE 'Analog Devices Inc.%' ) ) LIMIT 1 [ RunTime:0.014667s ]
SELECT `id` FROM `stock` WHERE `id` <> 57091745 AND `partno` = 'LT1767EMS8-3.3#TRPBF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%analog devices inc.%' ) [ RunTime:0.015303s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14225238 [ RunTime:0.017506s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57073333 LIMIT 5 [ RunTime:0.012214s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57073333 ORDER BY `minOrder` ASC [ RunTime:0.025343s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57073333 ORDER BY `unit` DESC [ RunTime:0.015428s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57073333 LIMIT 2 [ RunTime:0.001924s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57073333 ORDER BY `minOrder` ASC [ RunTime:0.009490s ]
select * from pdf where partno='LT1767EMS8-5#TRPBF' and brandshort='Analog Devices Inc.' limit 1 [ RunTime:0.006172s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LT1767EMS8-5#TRPBF' OR `brand` LIKE 'Analog Devices Inc.%' ) ) LIMIT 1 [ RunTime:0.009299s ]
SELECT `id` FROM `stock` WHERE `id` <> 57073333 AND `partno` = 'LT1767EMS8-5#TRPBF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%analog devices inc.%' ) [ RunTime:0.012796s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19135321 [ RunTime:0.009405s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57072023 LIMIT 5 [ RunTime:0.011528s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57072023 ORDER BY `minOrder` ASC [ RunTime:0.002615s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57072023 ORDER BY `unit` DESC [ RunTime:0.026992s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57072023 LIMIT 2 [ RunTime:0.016962s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57072023 ORDER BY `minOrder` ASC [ RunTime:0.011722s ]
select * from pdf where partno='LT1767EMS8-5#PBF' and brandshort='Analog Devices Inc.' limit 1 [ RunTime:0.028742s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LT1767EMS8-5#PBF' OR `brand` LIKE 'Analog Devices Inc.%' ) ) LIMIT 1 [ RunTime:0.005022s ]
SELECT `id` FROM `stock` WHERE `id` <> 57072023 AND `partno` = 'LT1767EMS8-5#PBF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%analog devices inc.%' ) [ RunTime:0.007623s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19134422 [ RunTime:0.016603s ]
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 'LT1767EMS8%' OR `brand` LIKE 'LT1767EMS8%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011118s ]
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 'LT1767EMS8%' OR `brand` LIKE 'LT1767EMS8%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.025051s ]
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 'LT1767EMS8%' OR `brand` LIKE 'LT1767EMS8%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.023022s ]
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 'LT1767EMS8%' OR `brand` LIKE 'LT1767EMS8%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016225s ]
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 'LT1767EMS8%' OR `brand` LIKE 'LT1767EMS8%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.022765s ]
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 'LT1767EMS8%' OR `brand` LIKE 'LT1767EMS8%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011441s ]
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 'LT1767EMS8%' OR `brand` LIKE 'LT1767EMS8%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.019465s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'LT1767EMS8%' OR `brand` LIKE 'LT1767EMS8%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.026458s ]