SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001417s ]
INSERT INTO `visit_log` SET `ip` = '216.73.217.162' , `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=1.5KE82&search=1' [ RunTime:0.003492s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001281s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.001230s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002287s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.162' ) [ RunTime:0.006228s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.003025s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000312s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001984s ]
SELECT * FROM `stock_search` WHERE `partno` = '1.5KE82' LIMIT 1 [ RunTime:0.019546s ]
UPDATE `stock_search` SET `count` = 3 , `updatetime` = '2026-08-18 14:18:10' WHERE `partno` = '1.5KE82' [ RunTime:0.010025s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.003001s ]
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 '1.5KE82%' OR `brand` LIKE '1.5KE82%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017742s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.003521s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13906786 LIMIT 5 [ RunTime:0.015015s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.003833s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13906786 ORDER BY `minOrder` ASC [ RunTime:0.003178s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.003557s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13906786 ORDER BY `unit` DESC [ RunTime:0.007546s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.003802s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13906786 LIMIT 2 [ RunTime:0.015186s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13906786 ORDER BY `minOrder` ASC [ RunTime:0.000484s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16680092 LIMIT 5 [ RunTime:0.004866s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16680092 ORDER BY `minOrder` ASC [ RunTime:0.005529s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16680092 ORDER BY `unit` DESC [ RunTime:0.018940s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16680092 LIMIT 2 [ RunTime:0.008301s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16680092 ORDER BY `minOrder` ASC [ RunTime:0.013621s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13905752 LIMIT 5 [ RunTime:0.015233s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13905752 ORDER BY `minOrder` ASC [ RunTime:0.012127s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13905752 ORDER BY `unit` DESC [ RunTime:0.005342s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13905752 LIMIT 2 [ RunTime:0.028277s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13905752 ORDER BY `minOrder` ASC [ RunTime:0.004423s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14809929 LIMIT 5 [ RunTime:0.039265s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14809929 ORDER BY `minOrder` ASC [ RunTime:0.017376s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14809929 ORDER BY `unit` DESC [ RunTime:0.013495s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14809929 LIMIT 2 [ RunTime:0.014823s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14809929 ORDER BY `minOrder` ASC [ RunTime:0.003737s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13912244 LIMIT 5 [ RunTime:0.021003s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13912244 ORDER BY `minOrder` ASC [ RunTime:0.026461s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13912244 ORDER BY `unit` DESC [ RunTime:0.022386s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13912244 LIMIT 2 [ RunTime:0.007489s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13912244 ORDER BY `minOrder` ASC [ RunTime:0.012096s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13913220 LIMIT 5 [ RunTime:0.018773s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13913220 ORDER BY `minOrder` ASC [ RunTime:0.023554s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13913220 ORDER BY `unit` DESC [ RunTime:0.017498s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13913220 LIMIT 2 [ RunTime:0.014292s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13913220 ORDER BY `minOrder` ASC [ RunTime:0.014969s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14800145 LIMIT 5 [ RunTime:0.013792s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14800145 ORDER BY `minOrder` ASC [ RunTime:0.046378s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14800145 ORDER BY `unit` DESC [ RunTime:0.082492s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14800145 LIMIT 2 [ RunTime:0.026778s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14800145 ORDER BY `minOrder` ASC [ RunTime:0.051642s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14803337 LIMIT 5 [ RunTime:0.058748s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14803337 ORDER BY `minOrder` ASC [ RunTime:0.079712s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14803337 ORDER BY `unit` DESC [ RunTime:0.052746s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14803337 LIMIT 2 [ RunTime:0.082911s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14803337 ORDER BY `minOrder` ASC [ RunTime:0.034446s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13907581 LIMIT 5 [ RunTime:0.043141s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13907581 ORDER BY `minOrder` ASC [ RunTime:0.028974s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13907581 ORDER BY `unit` DESC [ RunTime:0.094652s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13907581 LIMIT 2 [ RunTime:0.045915s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13907581 ORDER BY `minOrder` ASC [ RunTime:0.030987s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14803086 LIMIT 5 [ RunTime:0.080591s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14803086 ORDER BY `minOrder` ASC [ RunTime:0.003508s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14803086 ORDER BY `unit` DESC [ RunTime:0.000354s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14803086 LIMIT 2 [ RunTime:0.000349s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14803086 ORDER BY `minOrder` ASC [ RunTime:0.027262s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16664632 LIMIT 5 [ RunTime:0.015536s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16664632 ORDER BY `minOrder` ASC [ RunTime:0.025570s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16664632 ORDER BY `unit` DESC [ RunTime:0.052384s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16664632 LIMIT 2 [ RunTime:0.028249s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16664632 ORDER BY `minOrder` ASC [ RunTime:0.012752s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14803063 LIMIT 5 [ RunTime:0.026685s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14803063 ORDER BY `minOrder` ASC [ RunTime:0.030049s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14803063 ORDER BY `unit` DESC [ RunTime:0.055802s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14803063 LIMIT 2 [ RunTime:0.028458s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14803063 ORDER BY `minOrder` ASC [ RunTime:0.033856s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16691062 LIMIT 5 [ RunTime:0.042308s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16691062 ORDER BY `minOrder` ASC [ RunTime:0.047740s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16691062 ORDER BY `unit` DESC [ RunTime:0.024397s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16691062 LIMIT 2 [ RunTime:0.012319s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16691062 ORDER BY `minOrder` ASC [ RunTime:0.002542s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16690869 LIMIT 5 [ RunTime:0.005256s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16690869 ORDER BY `minOrder` ASC [ RunTime:0.010933s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16690869 ORDER BY `unit` DESC [ RunTime:0.014521s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16690869 LIMIT 2 [ RunTime:0.022970s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16690869 ORDER BY `minOrder` ASC [ RunTime:0.020427s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16690868 LIMIT 5 [ RunTime:0.032903s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16690868 ORDER BY `minOrder` ASC [ RunTime:0.023210s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16690868 ORDER BY `unit` DESC [ RunTime:0.014359s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16690868 LIMIT 2 [ RunTime:0.009725s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16690868 ORDER BY `minOrder` ASC [ RunTime:0.004090s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16690194 LIMIT 5 [ RunTime:0.014807s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16690194 ORDER BY `minOrder` ASC [ RunTime:0.024803s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16690194 ORDER BY `unit` DESC [ RunTime:0.032540s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16690194 LIMIT 2 [ RunTime:0.050722s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16690194 ORDER BY `minOrder` ASC [ RunTime:0.000718s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16688160 LIMIT 5 [ RunTime:0.000855s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16688160 ORDER BY `minOrder` ASC [ RunTime:0.007997s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16688160 ORDER BY `unit` DESC [ RunTime:0.031350s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16688160 LIMIT 2 [ RunTime:0.024258s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16688160 ORDER BY `minOrder` ASC [ RunTime:0.005482s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16687878 LIMIT 5 [ RunTime:0.005794s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16687878 ORDER BY `minOrder` ASC [ RunTime:0.009151s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16687878 ORDER BY `unit` DESC [ RunTime:0.007634s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16687878 LIMIT 2 [ RunTime:0.014548s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16687878 ORDER BY `minOrder` ASC [ RunTime:0.003759s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16687518 LIMIT 5 [ RunTime:0.005108s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16687518 ORDER BY `minOrder` ASC [ RunTime:0.011238s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16687518 ORDER BY `unit` DESC [ RunTime:0.008546s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16687518 LIMIT 2 [ RunTime:0.012636s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16687518 ORDER BY `minOrder` ASC [ RunTime:0.012407s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16687195 LIMIT 5 [ RunTime:0.006482s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16687195 ORDER BY `minOrder` ASC [ RunTime:0.004078s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16687195 ORDER BY `unit` DESC [ RunTime:0.000326s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16687195 LIMIT 2 [ RunTime:0.000495s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16687195 ORDER BY `minOrder` ASC [ RunTime:0.000209s ]
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 '1.5KE82%' OR `brand` LIKE '1.5KE82%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.029141s ]
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 '1.5KE82%' OR `brand` LIKE '1.5KE82%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.034051s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42162970 LIMIT 5 [ RunTime:0.021636s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42162970 ORDER BY `minOrder` ASC [ RunTime:0.018597s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42162970 ORDER BY `unit` DESC [ RunTime:0.023931s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42162970 LIMIT 2 [ RunTime:0.080972s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42162970 ORDER BY `minOrder` ASC [ RunTime:0.015008s ]
select * from pdf where partno='1.5KE82A' and brandshort='onsemi' limit 1 [ RunTime:0.045388s ]
select foldpath,foldpath2,filename from pdf_file where id=310468 limit 1 [ RunTime:0.026556s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.004219s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5KE82A' OR `brand` LIKE 'onsemi%' ) ) LIMIT 1 [ RunTime:0.020472s ]
SELECT `id` FROM `stock` WHERE `id` <> 42162970 AND `partno` = '1.5KE82A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%onsemi%' ) [ RunTime:0.021863s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13906786 [ RunTime:0.036940s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42149848 LIMIT 5 [ RunTime:0.038914s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42149848 ORDER BY `minOrder` ASC [ RunTime:0.022876s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42149848 ORDER BY `unit` DESC [ RunTime:0.019794s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42149848 LIMIT 2 [ RunTime:0.039935s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42149848 ORDER BY `minOrder` ASC [ RunTime:0.040370s ]
select * from pdf where partno='1.5KE82ARL4G' and brandshort='onsemi' limit 1 [ RunTime:0.034162s ]
select foldpath,foldpath2,filename from pdf_file where id=579698 limit 1 [ RunTime:0.011075s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5KE82ARL4G' OR `brand` LIKE 'onsemi%' ) ) LIMIT 1 [ RunTime:0.022207s ]
SELECT `id` FROM `stock` WHERE `id` <> 42149848 AND `partno` = '1.5KE82ARL4G' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%onsemi%' ) [ RunTime:0.010669s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13905752 [ RunTime:0.014312s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42138568 LIMIT 5 [ RunTime:0.011705s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42138568 ORDER BY `minOrder` ASC [ RunTime:0.013581s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42138568 ORDER BY `unit` DESC [ RunTime:0.001375s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42138568 LIMIT 2 [ RunTime:0.008054s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42138568 ORDER BY `minOrder` ASC [ RunTime:0.005997s ]
select * from pdf where partno='1.5KE82CA/B' and brandshort='YAGEO' limit 1 [ RunTime:0.007547s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5KE82CA/B' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.009904s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42119819 LIMIT 5 [ RunTime:0.007583s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42119819 ORDER BY `minOrder` ASC [ RunTime:0.012036s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42119819 ORDER BY `unit` DESC [ RunTime:0.012190s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42119819 LIMIT 2 [ RunTime:0.001920s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42119819 ORDER BY `minOrder` ASC [ RunTime:0.011778s ]
select * from pdf where partno='1.5KE82A-E3/54' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.011195s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5KE82A-E3/54' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.021663s ]
SELECT `id` FROM `stock` WHERE `id` <> 42119819 AND `partno` = '1.5KE82A-E3/54' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.003387s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13913220 [ RunTime:0.004021s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42120183 LIMIT 5 [ RunTime:0.002006s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42120183 ORDER BY `minOrder` ASC [ RunTime:0.006136s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42120183 ORDER BY `unit` DESC [ RunTime:0.011689s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42120183 LIMIT 2 [ RunTime:0.018367s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42120183 ORDER BY `minOrder` ASC [ RunTime:0.001860s ]
select * from pdf where partno='1.5KE82CA-E3/54' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.019050s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5KE82CA-E3/54' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.020561s ]
SELECT `id` FROM `stock` WHERE `id` <> 42120183 AND `partno` = '1.5KE82CA-E3/54' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.007538s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14804116 [ RunTime:0.003009s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42155199 LIMIT 5 [ RunTime:0.007761s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42155199 ORDER BY `minOrder` ASC [ RunTime:0.019025s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42155199 ORDER BY `unit` DESC [ RunTime:0.027131s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42155199 LIMIT 2 [ RunTime:0.010367s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42155199 ORDER BY `minOrder` ASC [ RunTime:0.006687s ]
select * from pdf where partno='1.5KE82CA' and brandshort='Diotec Semiconductor' limit 1 [ RunTime:0.006910s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5KE82CA' OR `brand` LIKE 'Diotec Semiconductor%' ) ) LIMIT 1 [ RunTime:0.053103s ]
SELECT `id` FROM `stock` WHERE `id` <> 42155199 AND `partno` = '1.5KE82CA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%diotec semiconductor%' ) [ RunTime:0.028311s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14800145 [ RunTime:0.026873s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42105572 LIMIT 5 [ RunTime:0.028661s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42105572 ORDER BY `minOrder` ASC [ RunTime:0.056986s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42105572 ORDER BY `unit` DESC [ RunTime:0.011645s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42105572 LIMIT 2 [ RunTime:0.055076s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42105572 ORDER BY `minOrder` ASC [ RunTime:0.034227s ]
select * from pdf where partno='1.5KE82A' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.016164s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5KE82A' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.000876s ]
SELECT `id` FROM `stock` WHERE `id` <> 42105572 AND `partno` = '1.5KE82A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.003571s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16680092 [ RunTime:0.000605s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42170287 LIMIT 5 [ RunTime:0.010329s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42170287 ORDER BY `minOrder` ASC [ RunTime:0.036347s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42170287 ORDER BY `unit` DESC [ RunTime:0.029893s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42170287 LIMIT 2 [ RunTime:0.019273s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42170287 ORDER BY `minOrder` ASC [ RunTime:0.002733s ]
select * from pdf where partno='1.5KE82A/B' and brandshort='YAGEO' limit 1 [ RunTime:0.010131s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5KE82A/B' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.015063s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42132719 LIMIT 5 [ RunTime:0.023050s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42132719 ORDER BY `minOrder` ASC [ RunTime:0.037069s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42132719 ORDER BY `unit` DESC [ RunTime:0.001867s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42132719 LIMIT 2 [ RunTime:0.023686s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42132719 ORDER BY `minOrder` ASC [ RunTime:0.010705s ]
select * from pdf where partno='1.5KE82CA-TP' and brandshort='MCC Micro Commercial Components' limit 1 [ RunTime:0.002783s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5KE82CA-TP' OR `brand` LIKE 'MCC (Micro Commercial Components)%' ) ) LIMIT 1 [ RunTime:0.034156s ]
SELECT `id` FROM `stock` WHERE `id` <> 42132719 AND `partno` = '1.5KE82CA-TP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mcc%' ) [ RunTime:0.032170s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16664632 [ RunTime:0.052522s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42170365 LIMIT 5 [ RunTime:0.011861s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42170365 ORDER BY `minOrder` ASC [ RunTime:0.020592s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42170365 ORDER BY `unit` DESC [ RunTime:0.041079s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42170365 LIMIT 2 [ RunTime:0.019226s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42170365 ORDER BY `minOrder` ASC [ RunTime:0.006477s ]
select * from pdf where partno='1.5KE82A-TP' and brandshort='MCC Micro Commercial Components' limit 1 [ RunTime:0.025276s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5KE82A-TP' OR `brand` LIKE 'MCC (Micro Commercial Components)%' ) ) LIMIT 1 [ RunTime:0.020308s ]
SELECT `id` FROM `stock` WHERE `id` <> 42170365 AND `partno` = '1.5KE82A-TP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mcc%' ) [ RunTime:0.013600s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14803086 [ RunTime:0.009666s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42156173 LIMIT 5 [ RunTime:0.019706s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42156173 ORDER BY `minOrder` ASC [ RunTime:0.006775s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42156173 ORDER BY `unit` DESC [ RunTime:0.011113s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42156173 LIMIT 2 [ RunTime:0.026312s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42156173 ORDER BY `minOrder` ASC [ RunTime:0.010070s ]
select * from pdf where partno='1.5KE82A' and brandshort='STMicroelectronics' limit 1 [ RunTime:0.016766s ]
select foldpath,foldpath2,filename from pdf_file where id=310456 limit 1 [ RunTime:0.024459s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5KE82A' OR `brand` LIKE 'STMicroelectronics%' ) ) LIMIT 1 [ RunTime:0.016475s ]
SELECT `id` FROM `stock` WHERE `id` <> 42156173 AND `partno` = '1.5KE82A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%stmicroelectronics%' ) [ RunTime:0.016675s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14809929 [ RunTime:0.018645s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42170700 LIMIT 5 [ RunTime:0.020742s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42170700 ORDER BY `minOrder` ASC [ RunTime:0.042535s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42170700 ORDER BY `unit` DESC [ RunTime:0.023213s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42170700 LIMIT 2 [ RunTime:0.004543s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42170700 ORDER BY `minOrder` ASC [ RunTime:0.008210s ]
select * from pdf where partno='1.5KE82CA-B' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.005274s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5KE82CA-B' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.010877s ]
SELECT `id` FROM `stock` WHERE `id` <> 42170700 AND `partno` = '1.5KE82CA-B' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.030025s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14803063 [ RunTime:0.022461s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42295666 LIMIT 5 [ RunTime:0.019249s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42295666 ORDER BY `minOrder` ASC [ RunTime:0.017318s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42295666 ORDER BY `unit` DESC [ RunTime:0.035346s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42295666 LIMIT 2 [ RunTime:0.039690s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42295666 ORDER BY `minOrder` ASC [ RunTime:0.002351s ]
select * from pdf where partno='1.5KE82CA_R2_00001' and brandshort='Panjit International Inc.' limit 1 [ RunTime:0.002603s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5KE82CA_R2_00001' OR `brand` LIKE 'Panjit International Inc.%' ) ) LIMIT 1 [ RunTime:0.008475s ]
SELECT `id` FROM `stock` WHERE `id` <> 42295666 AND `partno` = '1.5KE82CA_R2_00001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panjit international inc.%' ) [ RunTime:0.015656s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14819642 [ RunTime:0.036123s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42295374 LIMIT 5 [ RunTime:0.024388s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42295374 ORDER BY `minOrder` ASC [ RunTime:0.036317s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42295374 ORDER BY `unit` DESC [ RunTime:0.008294s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42295374 LIMIT 2 [ RunTime:0.001017s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42295374 ORDER BY `minOrder` ASC [ RunTime:0.000846s ]
select * from pdf where partno='1.5KE82A_R2_00001' and brandshort='Panjit International Inc.' limit 1 [ RunTime:0.000850s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5KE82A_R2_00001' OR `brand` LIKE 'Panjit International Inc.%' ) ) LIMIT 1 [ RunTime:0.002748s ]
SELECT `id` FROM `stock` WHERE `id` <> 42295374 AND `partno` = '1.5KE82A_R2_00001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panjit international inc.%' ) [ RunTime:0.014996s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13921071 [ RunTime:0.027403s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42294399 LIMIT 5 [ RunTime:0.040046s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42294399 ORDER BY `minOrder` ASC [ RunTime:0.043591s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42294399 ORDER BY `unit` DESC [ RunTime:0.011381s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42294399 LIMIT 2 [ RunTime:0.027215s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42294399 ORDER BY `minOrder` ASC [ RunTime:0.030700s ]
select * from pdf where partno='1.5KE82CA-E3/73' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.060625s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5KE82CA-E3/73' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.012772s ]
SELECT `id` FROM `stock` WHERE `id` <> 42294399 AND `partno` = '1.5KE82CA-E3/73' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.001171s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42294173 LIMIT 5 [ RunTime:0.004371s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42294173 ORDER BY `minOrder` ASC [ RunTime:0.009497s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42294173 ORDER BY `unit` DESC [ RunTime:0.003630s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42294173 LIMIT 2 [ RunTime:0.003570s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42294173 ORDER BY `minOrder` ASC [ RunTime:0.018399s ]
select * from pdf where partno='1.5KE82CAHE3_B/C' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.047256s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5KE82CAHE3_B/C' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.044231s ]
SELECT `id` FROM `stock` WHERE `id` <> 42294173 AND `partno` = '1.5KE82CAHE3_B/C' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.018721s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16676839 [ RunTime:0.014694s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42293045 LIMIT 5 [ RunTime:0.004138s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42293045 ORDER BY `minOrder` ASC [ RunTime:0.006076s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42293045 ORDER BY `unit` DESC [ RunTime:0.014143s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42293045 LIMIT 2 [ RunTime:0.055741s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42293045 ORDER BY `minOrder` ASC [ RunTime:0.021049s ]
select * from pdf where partno='1.5KE82AHE3_B/C' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.011266s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5KE82AHE3_B/C' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.014581s ]
SELECT `id` FROM `stock` WHERE `id` <> 42293045 AND `partno` = '1.5KE82AHE3_B/C' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.029412s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14817426 [ RunTime:0.017484s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42291130 LIMIT 5 [ RunTime:0.030934s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42291130 ORDER BY `minOrder` ASC [ RunTime:0.026009s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42291130 ORDER BY `unit` DESC [ RunTime:0.028702s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42291130 LIMIT 2 [ RunTime:0.095137s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42291130 ORDER BY `minOrder` ASC [ RunTime:0.010860s ]
select * from pdf where partno='1.5KE82A-E3/73' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.005295s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5KE82A-E3/73' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.005230s ]
SELECT `id` FROM `stock` WHERE `id` <> 42291130 AND `partno` = '1.5KE82A-E3/73' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.010273s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42279320 LIMIT 5 [ RunTime:0.008251s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42279320 ORDER BY `minOrder` ASC [ RunTime:0.000707s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42279320 ORDER BY `unit` DESC [ RunTime:0.004505s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42279320 LIMIT 2 [ RunTime:0.007057s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42279320 ORDER BY `minOrder` ASC [ RunTime:0.006890s ]
select * from pdf where partno='1.5KE82CA-HF' and brandshort='Comchip Technology' limit 1 [ RunTime:0.012399s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5KE82CA-HF' OR `brand` LIKE 'Comchip Technology%' ) ) LIMIT 1 [ RunTime:0.007758s ]
SELECT `id` FROM `stock` WHERE `id` <> 42279320 AND `partno` = '1.5KE82CA-HF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%comchip technology%' ) [ RunTime:0.011702s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13919073 [ RunTime:0.013250s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42279297 LIMIT 5 [ RunTime:0.001630s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42279297 ORDER BY `minOrder` ASC [ RunTime:0.004347s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42279297 ORDER BY `unit` DESC [ RunTime:0.007205s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42279297 LIMIT 2 [ RunTime:0.000561s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42279297 ORDER BY `minOrder` ASC [ RunTime:0.005648s ]
select * from pdf where partno='1.5KE82CA-G' and brandshort='Comchip Technology' limit 1 [ RunTime:0.008117s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5KE82CA-G' OR `brand` LIKE 'Comchip Technology%' ) ) LIMIT 1 [ RunTime:0.011694s ]
SELECT `id` FROM `stock` WHERE `id` <> 42279297 AND `partno` = '1.5KE82CA-G' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%comchip technology%' ) [ RunTime:0.011750s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14816978 [ RunTime:0.024293s ]
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 '1.5KE82%' OR `brand` LIKE '1.5KE82%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008413s ]
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 '1.5KE82%' OR `brand` LIKE '1.5KE82%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013502s ]
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 '1.5KE82%' OR `brand` LIKE '1.5KE82%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009047s ]
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 '1.5KE82%' OR `brand` LIKE '1.5KE82%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009280s ]
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 '1.5KE82%' OR `brand` LIKE '1.5KE82%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004585s ]
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 '1.5KE82%' OR `brand` LIKE '1.5KE82%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.029275s ]
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 '1.5KE82%' OR `brand` LIKE '1.5KE82%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014330s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '1.5KE82%' OR `brand` LIKE '1.5KE82%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.022339s ]