SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001320s ]
INSERT INTO `visit_log` SET `ip` = '216.73.217.113' , `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=DS1834&search=1' [ RunTime:0.002926s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001436s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000524s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001637s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.113' ) [ RunTime:0.004431s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.007752s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.005610s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001294s ]
SELECT * FROM `stock_search` WHERE `partno` = 'DS1834' LIMIT 1 [ RunTime:0.012510s ]
UPDATE `stock_search` SET `count` = 4 , `updatetime` = '2026-08-06 11:46:11' WHERE `partno` = 'DS1834' [ RunTime:0.005286s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002393s ]
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 'DS1834%' OR `brand` LIKE 'DS1834%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.034775s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001193s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14215813 LIMIT 5 [ RunTime:0.007087s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001384s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14215813 ORDER BY `minOrder` ASC [ RunTime:0.001199s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002077s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14215813 ORDER BY `unit` DESC [ RunTime:0.009749s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.004499s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14215813 LIMIT 2 [ RunTime:0.005654s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14215813 ORDER BY `minOrder` ASC [ RunTime:0.005919s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19087790 LIMIT 5 [ RunTime:0.004802s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19087790 ORDER BY `minOrder` ASC [ RunTime:0.014992s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19087790 ORDER BY `unit` DESC [ RunTime:0.011436s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19087790 LIMIT 2 [ RunTime:0.003021s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19087790 ORDER BY `minOrder` ASC [ RunTime:0.000356s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16035778 LIMIT 5 [ RunTime:0.007478s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16035778 ORDER BY `minOrder` ASC [ RunTime:0.010471s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16035778 ORDER BY `unit` DESC [ RunTime:0.010738s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16035778 LIMIT 2 [ RunTime:0.020211s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16035778 ORDER BY `minOrder` ASC [ RunTime:0.004405s ]
select * from pdf where partno='DS1834AU+T&R' and brandshort='Analog Devices Inc./Maxim Integrated' limit 1 [ RunTime:0.015151s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15296087 LIMIT 5 [ RunTime:0.001108s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15296087 ORDER BY `minOrder` ASC [ RunTime:0.004686s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15296087 ORDER BY `unit` DESC [ RunTime:0.015779s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15296087 LIMIT 2 [ RunTime:0.006141s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15296087 ORDER BY `minOrder` ASC [ RunTime:0.007326s ]
select * from pdf where partno='DS1834U/T&R' and brandshort='Analog Devices Inc./Maxim Integrated' limit 1 [ RunTime:0.004151s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16038111 LIMIT 5 [ RunTime:0.003081s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16038111 ORDER BY `minOrder` ASC [ RunTime:0.006601s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16038111 ORDER BY `unit` DESC [ RunTime:0.010647s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16038111 LIMIT 2 [ RunTime:0.002962s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16038111 ORDER BY `minOrder` ASC [ RunTime:0.011983s ]
select * from pdf where partno='DS1834D' and brandshort='Analog Devices Inc./Maxim Integrated' limit 1 [ RunTime:0.001474s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19087680 LIMIT 5 [ RunTime:0.008532s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19087680 ORDER BY `minOrder` ASC [ RunTime:0.003110s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19087680 ORDER BY `unit` DESC [ RunTime:0.002091s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19087680 LIMIT 2 [ RunTime:0.011792s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19087680 ORDER BY `minOrder` ASC [ RunTime:0.003484s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14214374 LIMIT 5 [ RunTime:0.015966s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14214374 ORDER BY `minOrder` ASC [ RunTime:0.011102s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14214374 ORDER BY `unit` DESC [ RunTime:0.015714s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14214374 LIMIT 2 [ RunTime:0.023426s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14214374 ORDER BY `minOrder` ASC [ RunTime:0.000489s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19087789 LIMIT 5 [ RunTime:0.007029s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19087789 ORDER BY `minOrder` ASC [ RunTime:0.012199s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19087789 ORDER BY `unit` DESC [ RunTime:0.008908s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19087789 LIMIT 2 [ RunTime:0.002343s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19087789 ORDER BY `minOrder` ASC [ RunTime:0.000449s ]
select * from pdf where partno='DS1834A' and brandshort='Analog Devices Inc./Maxim Integrated' limit 1 [ RunTime:0.002049s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19087647 LIMIT 5 [ RunTime:0.022985s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19087647 ORDER BY `minOrder` ASC [ RunTime:0.003625s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19087647 ORDER BY `unit` DESC [ RunTime:0.008946s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19087647 LIMIT 2 [ RunTime:0.003038s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19087647 ORDER BY `minOrder` ASC [ RunTime:0.008013s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19084554 LIMIT 5 [ RunTime:0.006478s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19084554 ORDER BY `minOrder` ASC [ RunTime:0.001485s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19084554 ORDER BY `unit` DESC [ RunTime:0.003169s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19084554 LIMIT 2 [ RunTime:0.005666s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19084554 ORDER BY `minOrder` ASC [ RunTime:0.001072s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19083935 LIMIT 5 [ RunTime:0.007068s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19083935 ORDER BY `minOrder` ASC [ RunTime:0.007283s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19083935 ORDER BY `unit` DESC [ RunTime:0.002713s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19083935 LIMIT 2 [ RunTime:0.001732s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19083935 ORDER BY `minOrder` ASC [ RunTime:0.000439s ]
select * from pdf where partno='DS1834DU' and brandshort='Analog Devices Inc./Maxim Integrated' limit 1 [ RunTime:0.001455s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17077026 LIMIT 5 [ RunTime:0.004029s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17077026 ORDER BY `minOrder` ASC [ RunTime:0.001343s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17077026 ORDER BY `unit` DESC [ RunTime:0.003549s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17077026 LIMIT 2 [ RunTime:0.005657s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17077026 ORDER BY `minOrder` ASC [ RunTime:0.000427s ]
select * from pdf where partno='DS1834S' and brandshort='Analog Devices Inc./Maxim Integrated' limit 1 [ RunTime:0.006594s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17077014 LIMIT 5 [ RunTime:0.003864s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17077014 ORDER BY `minOrder` ASC [ RunTime:0.002762s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17077014 ORDER BY `unit` DESC [ RunTime:0.000630s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17077014 LIMIT 2 [ RunTime:0.007231s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17077014 ORDER BY `minOrder` ASC [ RunTime:0.002120s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17076978 LIMIT 5 [ RunTime:0.002987s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17076978 ORDER BY `minOrder` ASC [ RunTime:0.007717s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17076978 ORDER BY `unit` DESC [ RunTime:0.009570s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17076978 LIMIT 2 [ RunTime:0.010353s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17076978 ORDER BY `minOrder` ASC [ RunTime:0.016395s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16038126 LIMIT 5 [ RunTime:0.003464s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16038126 ORDER BY `minOrder` ASC [ RunTime:0.011181s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16038126 ORDER BY `unit` DESC [ RunTime:0.003191s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16038126 LIMIT 2 [ RunTime:0.006950s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16038126 ORDER BY `minOrder` ASC [ RunTime:0.012642s ]
select * from pdf where partno='DS1834S/T&R' and brandshort='Analog Devices Inc./Maxim Integrated' limit 1 [ RunTime:0.005267s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16038106 LIMIT 5 [ RunTime:0.000774s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16038106 ORDER BY `minOrder` ASC [ RunTime:0.009597s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16038106 ORDER BY `unit` DESC [ RunTime:0.018413s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16038106 LIMIT 2 [ RunTime:0.005517s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16038106 ORDER BY `minOrder` ASC [ RunTime:0.001481s ]
select * from pdf where partno='DS1834AS' and brandshort='Analog Devices Inc./Maxim Integrated' limit 1 [ RunTime:0.010086s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15295999 LIMIT 5 [ RunTime:0.016114s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15295999 ORDER BY `minOrder` ASC [ RunTime:0.005998s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15295999 ORDER BY `unit` DESC [ RunTime:0.011251s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15295999 LIMIT 2 [ RunTime:0.018957s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15295999 ORDER BY `minOrder` ASC [ RunTime:0.012431s ]
select * from pdf where partno='DS1834' and brandshort='Analog Devices Inc./Maxim Integrated' limit 1 [ RunTime:0.021861s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15295457 LIMIT 5 [ RunTime:0.008416s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15295457 ORDER BY `minOrder` ASC [ RunTime:0.004936s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15295457 ORDER BY `unit` DESC [ RunTime:0.006182s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15295457 LIMIT 2 [ RunTime:0.033214s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15295457 ORDER BY `minOrder` ASC [ RunTime:0.029312s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15294620 LIMIT 5 [ RunTime:0.011238s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15294620 ORDER BY `minOrder` ASC [ RunTime:0.033242s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15294620 ORDER BY `unit` DESC [ RunTime:0.014524s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15294620 LIMIT 2 [ RunTime:0.003443s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15294620 ORDER BY `minOrder` ASC [ RunTime:0.015582s ]
select * from pdf where partno='DS1834AU/T&R' and brandshort='Analog Devices Inc./Maxim Integrated' limit 1 [ RunTime:0.012769s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15294601 LIMIT 5 [ RunTime:0.010859s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15294601 ORDER BY `minOrder` ASC [ RunTime:0.011648s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15294601 ORDER BY `unit` DESC [ RunTime:0.017093s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15294601 LIMIT 2 [ RunTime:0.025795s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15294601 ORDER BY `minOrder` ASC [ RunTime:0.017150s ]
select * from pdf where partno='DS1834AU' and brandshort='Analog Devices Inc./Maxim Integrated' limit 1 [ RunTime:0.002177s ]
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 'DS1834%' OR `brand` LIKE 'DS1834%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011972s ]
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 'DS1834%' OR `brand` LIKE 'DS1834%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.015117s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63629893 LIMIT 5 [ RunTime:0.002435s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63629893 ORDER BY `minOrder` ASC [ RunTime:0.017671s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63629893 ORDER BY `unit` DESC [ RunTime:0.008849s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63629893 LIMIT 2 [ RunTime:0.008595s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63629893 ORDER BY `minOrder` ASC [ RunTime:0.000356s ]
select * from pdf where partno='DS1834AS+T&R' and brandshort='Analog Devices Inc./Maxim Integrated' limit 1 [ RunTime:0.025650s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002439s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'DS1834AS+T&R' OR `brand` LIKE 'Analog Devices Inc./Maxim Integrated%' ) ) LIMIT 1 [ RunTime:0.012938s ]
SELECT `id` FROM `stock` WHERE `id` <> 63629893 AND `partno` = 'DS1834AS+T&R' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%analog devices inc./maxim integrated%' ) [ RunTime:0.014157s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14215813 [ RunTime:0.009470s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63631047 LIMIT 5 [ RunTime:0.013980s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63631047 ORDER BY `minOrder` ASC [ RunTime:0.008615s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63631047 ORDER BY `unit` DESC [ RunTime:0.023899s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63631047 LIMIT 2 [ RunTime:0.027498s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63631047 ORDER BY `minOrder` ASC [ RunTime:0.003483s ]
select * from pdf where partno='DS1834AU+T&R' and brandshort='Analog Devices Inc./Maxim Integrated' limit 1 [ RunTime:0.004425s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'DS1834AU+T&R' OR `brand` LIKE 'Analog Devices Inc./Maxim Integrated%' ) ) LIMIT 1 [ RunTime:0.004725s ]
SELECT `id` FROM `stock` WHERE `id` <> 63631047 AND `partno` = 'DS1834AU+T&R' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%analog devices inc./maxim integrated%' ) [ RunTime:0.029528s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16035778 [ RunTime:0.006948s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63631920 LIMIT 5 [ RunTime:0.040584s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63631920 ORDER BY `minOrder` ASC [ RunTime:0.038850s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63631920 ORDER BY `unit` DESC [ RunTime:0.032440s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63631920 LIMIT 2 [ RunTime:0.002225s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63631920 ORDER BY `minOrder` ASC [ RunTime:0.001185s ]
select * from pdf where partno='DS1834S+' and brandshort='Analog Devices Inc./Maxim Integrated' limit 1 [ RunTime:0.012840s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'DS1834S+' OR `brand` LIKE 'Analog Devices Inc./Maxim Integrated%' ) ) LIMIT 1 [ RunTime:0.005137s ]
SELECT `id` FROM `stock` WHERE `id` <> 63631920 AND `partno` = 'DS1834S+' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%analog devices inc./maxim integrated%' ) [ RunTime:0.024162s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14217417 [ RunTime:0.005964s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63629910 LIMIT 5 [ RunTime:0.008707s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63629910 ORDER BY `minOrder` ASC [ RunTime:0.021581s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63629910 ORDER BY `unit` DESC [ RunTime:0.043778s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63629910 LIMIT 2 [ RunTime:0.013425s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63629910 ORDER BY `minOrder` ASC [ RunTime:0.011796s ]
select * from pdf where partno='DS1834AU+' and brandshort='Analog Devices Inc./Maxim Integrated' limit 1 [ RunTime:0.025957s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'DS1834AU+' OR `brand` LIKE 'Analog Devices Inc./Maxim Integrated%' ) ) LIMIT 1 [ RunTime:0.031894s ]
SELECT `id` FROM `stock` WHERE `id` <> 63629910 AND `partno` = 'DS1834AU+' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%analog devices inc./maxim integrated%' ) [ RunTime:0.052288s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14214374 [ RunTime:0.007918s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63629894 LIMIT 5 [ RunTime:0.030077s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63629894 ORDER BY `minOrder` ASC [ RunTime:0.007171s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63629894 ORDER BY `unit` DESC [ RunTime:0.014145s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63629894 LIMIT 2 [ RunTime:0.014810s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63629894 ORDER BY `minOrder` ASC [ RunTime:0.000731s ]
select * from pdf where partno='DS1834AS+' and brandshort='Analog Devices Inc./Maxim Integrated' limit 1 [ RunTime:0.007092s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'DS1834AS+' OR `brand` LIKE 'Analog Devices Inc./Maxim Integrated%' ) ) LIMIT 1 [ RunTime:0.006861s ]
SELECT `id` FROM `stock` WHERE `id` <> 63629894 AND `partno` = 'DS1834AS+' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%analog devices inc./maxim integrated%' ) [ RunTime:0.020656s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15293016 [ RunTime:0.030078s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63659365 LIMIT 5 [ RunTime:0.006587s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63659365 ORDER BY `minOrder` ASC [ RunTime:0.015664s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63659365 ORDER BY `unit` DESC [ RunTime:0.007336s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63659365 LIMIT 2 [ RunTime:0.013241s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63659365 ORDER BY `minOrder` ASC [ RunTime:0.016200s ]
select * from pdf where partno='DS1834S+T&R' and brandshort='Analog Devices Inc./Maxim Integrated' limit 1 [ RunTime:0.007554s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'DS1834S+T&R' OR `brand` LIKE 'Analog Devices Inc./Maxim Integrated%' ) ) LIMIT 1 [ RunTime:0.011411s ]
SELECT `id` FROM `stock` WHERE `id` <> 63659365 AND `partno` = 'DS1834S+T&R' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%analog devices inc./maxim integrated%' ) [ RunTime:0.021438s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19084554 [ RunTime:0.015033s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63658033 LIMIT 5 [ RunTime:0.041219s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63658033 ORDER BY `minOrder` ASC [ RunTime:0.017154s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63658033 ORDER BY `unit` DESC [ RunTime:0.020955s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63658033 LIMIT 2 [ RunTime:0.052067s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63658033 ORDER BY `minOrder` ASC [ RunTime:0.016842s ]
select * from pdf where partno='DS1834A+' and brandshort='Analog Devices Inc./Maxim Integrated' limit 1 [ RunTime:0.019542s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'DS1834A+' OR `brand` LIKE 'Analog Devices Inc./Maxim Integrated%' ) ) LIMIT 1 [ RunTime:0.014506s ]
SELECT `id` FROM `stock` WHERE `id` <> 63658033 AND `partno` = 'DS1834A+' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%analog devices inc./maxim integrated%' ) [ RunTime:0.021247s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19087647 [ RunTime:0.017937s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63657974 LIMIT 5 [ RunTime:0.014121s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63657974 ORDER BY `minOrder` ASC [ RunTime:0.014881s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63657974 ORDER BY `unit` DESC [ RunTime:0.018546s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63657974 LIMIT 2 [ RunTime:0.035030s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63657974 ORDER BY `minOrder` ASC [ RunTime:0.005140s ]
select * from pdf where partno='DS1834U+' and brandshort='Analog Devices Inc./Maxim Integrated' limit 1 [ RunTime:0.009971s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'DS1834U+' OR `brand` LIKE 'Analog Devices Inc./Maxim Integrated%' ) ) LIMIT 1 [ RunTime:0.025410s ]
SELECT `id` FROM `stock` WHERE `id` <> 63657974 AND `partno` = 'DS1834U+' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%analog devices inc./maxim integrated%' ) [ RunTime:0.017749s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17077014 [ RunTime:0.017020s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63657757 LIMIT 5 [ RunTime:0.031468s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63657757 ORDER BY `minOrder` ASC [ RunTime:0.030206s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63657757 ORDER BY `unit` DESC [ RunTime:0.007532s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63657757 LIMIT 2 [ RunTime:0.019283s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63657757 ORDER BY `minOrder` ASC [ RunTime:0.009543s ]
select * from pdf where partno='DS1834AU/T&R' and brandshort='Analog Devices Inc./Maxim Integrated' limit 1 [ RunTime:0.007510s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'DS1834AU/T&R' OR `brand` LIKE 'Analog Devices Inc./Maxim Integrated%' ) ) LIMIT 1 [ RunTime:0.003382s ]
SELECT `id` FROM `stock` WHERE `id` <> 63657757 AND `partno` = 'DS1834AU/T&R' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%analog devices inc./maxim integrated%' ) [ RunTime:0.006732s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15294620 [ RunTime:0.006713s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63657705 LIMIT 5 [ RunTime:0.004443s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63657705 ORDER BY `minOrder` ASC [ RunTime:0.008888s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63657705 ORDER BY `unit` DESC [ RunTime:0.020407s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63657705 LIMIT 2 [ RunTime:0.007885s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63657705 ORDER BY `minOrder` ASC [ RunTime:0.001640s ]
select * from pdf where partno='DS1834DU' and brandshort='Analog Devices Inc./Maxim Integrated' limit 1 [ RunTime:0.003501s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'DS1834DU' OR `brand` LIKE 'Analog Devices Inc./Maxim Integrated%' ) ) LIMIT 1 [ RunTime:0.016609s ]
SELECT `id` FROM `stock` WHERE `id` <> 63657705 AND `partno` = 'DS1834DU' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%analog devices inc./maxim integrated%' ) [ RunTime:0.017695s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19083935 [ RunTime:0.004783s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63657704 LIMIT 5 [ RunTime:0.010171s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63657704 ORDER BY `minOrder` ASC [ RunTime:0.003516s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63657704 ORDER BY `unit` DESC [ RunTime:0.004693s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63657704 LIMIT 2 [ RunTime:0.006525s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63657704 ORDER BY `minOrder` ASC [ RunTime:0.008270s ]
select * from pdf where partno='DS1834AU' and brandshort='Analog Devices Inc./Maxim Integrated' limit 1 [ RunTime:0.000658s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'DS1834AU' OR `brand` LIKE 'Analog Devices Inc./Maxim Integrated%' ) ) LIMIT 1 [ RunTime:0.016647s ]
SELECT `id` FROM `stock` WHERE `id` <> 63657704 AND `partno` = 'DS1834AU' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%analog devices inc./maxim integrated%' ) [ RunTime:0.012999s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15294601 [ RunTime:0.008267s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63657622 LIMIT 5 [ RunTime:0.002738s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63657622 ORDER BY `minOrder` ASC [ RunTime:0.010177s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63657622 ORDER BY `unit` DESC [ RunTime:0.038236s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63657622 LIMIT 2 [ RunTime:0.028295s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63657622 ORDER BY `minOrder` ASC [ RunTime:0.000791s ]
select * from pdf where partno='DS1834AS/T&R' and brandshort='Analog Devices Inc./Maxim Integrated' limit 1 [ RunTime:0.002541s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'DS1834AS/T&R' OR `brand` LIKE 'Analog Devices Inc./Maxim Integrated%' ) ) LIMIT 1 [ RunTime:0.002498s ]
SELECT `id` FROM `stock` WHERE `id` <> 63657622 AND `partno` = 'DS1834AS/T&R' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%analog devices inc./maxim integrated%' ) [ RunTime:0.023245s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14217810 [ RunTime:0.019804s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63657619 LIMIT 5 [ RunTime:0.015170s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63657619 ORDER BY `minOrder` ASC [ RunTime:0.006987s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63657619 ORDER BY `unit` DESC [ RunTime:0.014536s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63657619 LIMIT 2 [ RunTime:0.028386s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63657619 ORDER BY `minOrder` ASC [ RunTime:0.016630s ]
select * from pdf where partno='DS1834S/T&R' and brandshort='Analog Devices Inc./Maxim Integrated' limit 1 [ RunTime:0.007668s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'DS1834S/T&R' OR `brand` LIKE 'Analog Devices Inc./Maxim Integrated%' ) ) LIMIT 1 [ RunTime:0.018753s ]
SELECT `id` FROM `stock` WHERE `id` <> 63657619 AND `partno` = 'DS1834S/T&R' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%analog devices inc./maxim integrated%' ) [ RunTime:0.011999s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16038126 [ RunTime:0.004163s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63657600 LIMIT 5 [ RunTime:0.014309s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63657600 ORDER BY `minOrder` ASC [ RunTime:0.006872s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63657600 ORDER BY `unit` DESC [ RunTime:0.012336s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63657600 LIMIT 2 [ RunTime:0.011933s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63657600 ORDER BY `minOrder` ASC [ RunTime:0.001305s ]
select * from pdf where partno='DS1834A' and brandshort='Analog Devices Inc./Maxim Integrated' limit 1 [ RunTime:0.000536s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'DS1834A' OR `brand` LIKE 'Analog Devices Inc./Maxim Integrated%' ) ) LIMIT 1 [ RunTime:0.000864s ]
SELECT `id` FROM `stock` WHERE `id` <> 63657600 AND `partno` = 'DS1834A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%analog devices inc./maxim integrated%' ) [ RunTime:0.010684s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19087789 [ RunTime:0.006613s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63657599 LIMIT 5 [ RunTime:0.038267s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63657599 ORDER BY `minOrder` ASC [ RunTime:0.025982s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63657599 ORDER BY `unit` DESC [ RunTime:0.022298s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63657599 LIMIT 2 [ RunTime:0.007153s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63657599 ORDER BY `minOrder` ASC [ RunTime:0.000577s ]
select * from pdf where partno='DS1834AS' and brandshort='Analog Devices Inc./Maxim Integrated' limit 1 [ RunTime:0.003958s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'DS1834AS' OR `brand` LIKE 'Analog Devices Inc./Maxim Integrated%' ) ) LIMIT 1 [ RunTime:0.014761s ]
SELECT `id` FROM `stock` WHERE `id` <> 63657599 AND `partno` = 'DS1834AS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%analog devices inc./maxim integrated%' ) [ RunTime:0.010550s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16038106 [ RunTime:0.017239s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63657598 LIMIT 5 [ RunTime:0.027974s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63657598 ORDER BY `minOrder` ASC [ RunTime:0.043097s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63657598 ORDER BY `unit` DESC [ RunTime:0.010722s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63657598 LIMIT 2 [ RunTime:0.020351s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63657598 ORDER BY `minOrder` ASC [ RunTime:0.005747s ]
select * from pdf where partno='DS1834' and brandshort='Analog Devices Inc./Maxim Integrated' limit 1 [ RunTime:0.008298s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'DS1834' OR `brand` LIKE 'Analog Devices Inc./Maxim Integrated%' ) ) LIMIT 1 [ RunTime:0.008312s ]
SELECT `id` FROM `stock` WHERE `id` <> 63657598 AND `partno` = 'DS1834' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%analog devices inc./maxim integrated%' ) [ RunTime:0.025958s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15295999 [ RunTime:0.037536s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63657595 LIMIT 5 [ RunTime:0.017849s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63657595 ORDER BY `minOrder` ASC [ RunTime:0.052325s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63657595 ORDER BY `unit` DESC [ RunTime:0.014655s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63657595 LIMIT 2 [ RunTime:0.053921s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63657595 ORDER BY `minOrder` ASC [ RunTime:0.027116s ]
select * from pdf where partno='DS1834S' and brandshort='Analog Devices Inc./Maxim Integrated' limit 1 [ RunTime:0.008266s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'DS1834S' OR `brand` LIKE 'Analog Devices Inc./Maxim Integrated%' ) ) LIMIT 1 [ RunTime:0.027057s ]
SELECT `id` FROM `stock` WHERE `id` <> 63657595 AND `partno` = 'DS1834S' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%analog devices inc./maxim integrated%' ) [ RunTime:0.021922s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17077026 [ RunTime:0.009460s ]
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 'DS1834%' OR `brand` LIKE 'DS1834%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.024307s ]
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 'DS1834%' OR `brand` LIKE 'DS1834%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.040952s ]
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 'DS1834%' OR `brand` LIKE 'DS1834%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016417s ]
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 'DS1834%' OR `brand` LIKE 'DS1834%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004829s ]
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 'DS1834%' OR `brand` LIKE 'DS1834%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007097s ]
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 'DS1834%' OR `brand` LIKE 'DS1834%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.023660s ]
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 'DS1834%' OR `brand` LIKE 'DS1834%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.032066s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'DS1834%' OR `brand` LIKE 'DS1834%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.019597s ]