SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002286s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.133' , `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=P6KE200&search=1' [ RunTime:0.024259s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002428s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.001090s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002615s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.133' ) [ RunTime:0.016790s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.003374s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.035224s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.006875s ]
SELECT * FROM `stock_search` WHERE `partno` = 'P6KE200' LIMIT 1 [ RunTime:0.098794s ]
UPDATE `stock_search` SET `count` = 4 , `updatetime` = '2026-08-19 00:29:58' WHERE `partno` = 'P6KE200' [ RunTime:0.058316s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.004697s ]
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 'P6KE200%' OR `brand` LIKE 'P6KE200%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.077486s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.019698s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14800781 LIMIT 5 [ RunTime:0.033977s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002112s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14800781 ORDER BY `minOrder` ASC [ RunTime:0.074090s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002169s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14800781 ORDER BY `unit` DESC [ RunTime:0.081086s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.042822s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14800781 LIMIT 2 [ RunTime:0.054447s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14800781 ORDER BY `minOrder` ASC [ RunTime:0.036546s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13906731 LIMIT 5 [ RunTime:0.099165s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13906731 ORDER BY `minOrder` ASC [ RunTime:0.019903s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13906731 ORDER BY `unit` DESC [ RunTime:0.083687s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13906731 LIMIT 2 [ RunTime:0.019908s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13906731 ORDER BY `minOrder` ASC [ RunTime:0.029463s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14800825 LIMIT 5 [ RunTime:0.050054s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14800825 ORDER BY `minOrder` ASC [ RunTime:0.095119s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14800825 ORDER BY `unit` DESC [ RunTime:0.049945s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14800825 LIMIT 2 [ RunTime:0.038948s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14800825 ORDER BY `minOrder` ASC [ RunTime:0.006691s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13905746 LIMIT 5 [ RunTime:0.011742s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13905746 ORDER BY `minOrder` ASC [ RunTime:0.020531s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13905746 ORDER BY `unit` DESC [ RunTime:0.007410s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13905746 LIMIT 2 [ RunTime:0.010752s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13905746 ORDER BY `minOrder` ASC [ RunTime:0.009823s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14800493 LIMIT 5 [ RunTime:0.007973s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14800493 ORDER BY `minOrder` ASC [ RunTime:0.008176s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14800493 ORDER BY `unit` DESC [ RunTime:0.001802s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14800493 LIMIT 2 [ RunTime:0.012687s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14800493 ORDER BY `minOrder` ASC [ RunTime:0.002176s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16676975 LIMIT 5 [ RunTime:0.024730s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16676975 ORDER BY `minOrder` ASC [ RunTime:0.026850s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16676975 ORDER BY `unit` DESC [ RunTime:0.008246s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16676975 LIMIT 2 [ RunTime:0.016554s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16676975 ORDER BY `minOrder` ASC [ RunTime:0.006769s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16662614 LIMIT 5 [ RunTime:0.009488s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16662614 ORDER BY `minOrder` ASC [ RunTime:0.019123s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16662614 ORDER BY `unit` DESC [ RunTime:0.006655s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16662614 LIMIT 2 [ RunTime:0.001811s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16662614 ORDER BY `minOrder` ASC [ RunTime:0.000377s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16662169 LIMIT 5 [ RunTime:0.001148s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16662169 ORDER BY `minOrder` ASC [ RunTime:0.000581s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16662169 ORDER BY `unit` DESC [ RunTime:0.015664s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16662169 LIMIT 2 [ RunTime:0.010105s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16662169 ORDER BY `minOrder` ASC [ RunTime:0.003292s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16668787 LIMIT 5 [ RunTime:0.007770s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16668787 ORDER BY `minOrder` ASC [ RunTime:0.014797s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16668787 ORDER BY `unit` DESC [ RunTime:0.008108s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16668787 LIMIT 2 [ RunTime:0.010673s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16668787 ORDER BY `minOrder` ASC [ RunTime:0.004042s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13921215 LIMIT 5 [ RunTime:0.006607s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13921215 ORDER BY `minOrder` ASC [ RunTime:0.002471s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13921215 ORDER BY `unit` DESC [ RunTime:0.003093s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13921215 LIMIT 2 [ RunTime:0.012371s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13921215 ORDER BY `minOrder` ASC [ RunTime:0.001403s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13905875 LIMIT 5 [ RunTime:0.007881s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13905875 ORDER BY `minOrder` ASC [ RunTime:0.009271s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13905875 ORDER BY `unit` DESC [ RunTime:0.005877s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13905875 LIMIT 2 [ RunTime:0.019434s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13905875 ORDER BY `minOrder` ASC [ RunTime:0.004335s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16676978 LIMIT 5 [ RunTime:0.001484s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16676978 ORDER BY `minOrder` ASC [ RunTime:0.002598s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16676978 ORDER BY `unit` DESC [ RunTime:0.005483s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16676978 LIMIT 2 [ RunTime:0.004290s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16676978 ORDER BY `minOrder` ASC [ RunTime:0.002463s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14830249 LIMIT 5 [ RunTime:0.002705s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14830249 ORDER BY `minOrder` ASC [ RunTime:0.000996s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14830249 ORDER BY `unit` DESC [ RunTime:0.005171s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14830249 LIMIT 2 [ RunTime:0.009983s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14830249 ORDER BY `minOrder` ASC [ RunTime:0.006256s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13906027 LIMIT 5 [ RunTime:0.005236s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13906027 ORDER BY `minOrder` ASC [ RunTime:0.004245s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13906027 ORDER BY `unit` DESC [ RunTime:0.003939s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13906027 LIMIT 2 [ RunTime:0.011433s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13906027 ORDER BY `minOrder` ASC [ RunTime:0.008000s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 8727 LIMIT 5 [ RunTime:0.000578s ]
SELECT * FROM `stock_price` WHERE `stockid` = 8727 ORDER BY `minOrder` ASC [ RunTime:0.005202s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 8727 ORDER BY `unit` DESC [ RunTime:0.008213s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 8727 LIMIT 2 [ RunTime:0.011726s ]
SELECT * FROM `stock_price` WHERE `stockid` = 8727 ORDER BY `minOrder` ASC [ RunTime:0.009424s ]
select * from pdf where partno='P6KE200A' and brandshort='LITTELFUSE' limit 1 [ RunTime:0.012588s ]
select foldpath,foldpath2,filename from pdf_file where id=445614 limit 1 [ RunTime:0.005151s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002215s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6KE200A' OR `brand` LIKE 'LITTELFUSE%' ) ) LIMIT 1 [ RunTime:0.017095s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13916935 LIMIT 5 [ RunTime:0.004703s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13916935 ORDER BY `minOrder` ASC [ RunTime:0.006591s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13916935 ORDER BY `unit` DESC [ RunTime:0.002055s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13916935 LIMIT 2 [ RunTime:0.006807s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13916935 ORDER BY `minOrder` ASC [ RunTime:0.001648s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14799447 LIMIT 5 [ RunTime:0.006673s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14799447 ORDER BY `minOrder` ASC [ RunTime:0.016148s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14799447 ORDER BY `unit` DESC [ RunTime:0.028184s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14799447 LIMIT 2 [ RunTime:0.035596s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14799447 ORDER BY `minOrder` ASC [ RunTime:0.018171s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16689236 LIMIT 5 [ RunTime:0.026658s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16689236 ORDER BY `minOrder` ASC [ RunTime:0.040909s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16689236 ORDER BY `unit` DESC [ RunTime:0.025902s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16689236 LIMIT 2 [ RunTime:0.039989s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16689236 ORDER BY `minOrder` ASC [ RunTime:0.004710s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16665504 LIMIT 5 [ RunTime:0.023283s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16665504 ORDER BY `minOrder` ASC [ RunTime:0.064134s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16665504 ORDER BY `unit` DESC [ RunTime:0.009348s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16665504 LIMIT 2 [ RunTime:0.024821s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16665504 ORDER BY `minOrder` ASC [ RunTime:0.014973s ]
select * from pdf where partno='P6KE200CA' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.012134s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16662196 LIMIT 5 [ RunTime:0.021430s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16662196 ORDER BY `minOrder` ASC [ RunTime:0.015632s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16662196 ORDER BY `unit` DESC [ RunTime:0.014343s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16662196 LIMIT 2 [ RunTime:0.023741s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16662196 ORDER BY `minOrder` ASC [ RunTime:0.009670s ]
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 'P6KE200%' OR `brand` LIKE 'P6KE200%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.020548s ]
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 'P6KE200%' OR `brand` LIKE 'P6KE200%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.022691s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42149525 LIMIT 5 [ RunTime:0.023715s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42149525 ORDER BY `minOrder` ASC [ RunTime:0.028990s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42149525 ORDER BY `unit` DESC [ RunTime:0.019971s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42149525 LIMIT 2 [ RunTime:0.018812s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42149525 ORDER BY `minOrder` ASC [ RunTime:0.034977s ]
select * from pdf where partno='P6KE200ARLG' and brandshort='onsemi' limit 1 [ RunTime:0.030161s ]
select foldpath,foldpath2,filename from pdf_file where id=1051076 limit 1 [ RunTime:0.028161s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6KE200ARLG' OR `brand` LIKE 'onsemi%' ) ) LIMIT 1 [ RunTime:0.035440s ]
SELECT `id` FROM `stock` WHERE `id` <> 42149525 AND `partno` = 'P6KE200ARLG' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%onsemi%' ) [ RunTime:0.115313s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14800781 [ RunTime:0.032899s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42162536 LIMIT 5 [ RunTime:0.055020s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42162536 ORDER BY `minOrder` ASC [ RunTime:0.076939s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42162536 ORDER BY `unit` DESC [ RunTime:0.109512s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42162536 LIMIT 2 [ RunTime:0.038521s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42162536 ORDER BY `minOrder` ASC [ RunTime:0.021653s ]
select * from pdf where partno='P6KE200A' and brandshort='Fairchild Semiconductor' limit 1 [ RunTime:0.073798s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6KE200A' OR `brand` LIKE 'Fairchild Semiconductor%' ) ) LIMIT 1 [ RunTime:0.100808s ]
SELECT `id` FROM `stock` WHERE `id` <> 42162536 AND `partno` = 'P6KE200A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%fairchild semiconductor%' ) [ RunTime:0.103653s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13906731 [ RunTime:0.108649s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42149215 LIMIT 5 [ RunTime:0.038548s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42149215 ORDER BY `minOrder` ASC [ RunTime:0.056165s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42149215 ORDER BY `unit` DESC [ RunTime:0.057100s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42149215 LIMIT 2 [ RunTime:0.023033s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42149215 ORDER BY `minOrder` ASC [ RunTime:0.017437s ]
select * from pdf where partno='P6KE200CA' and brandshort='Fairchild Semiconductor' limit 1 [ RunTime:0.101666s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6KE200CA' OR `brand` LIKE 'Fairchild Semiconductor%' ) ) LIMIT 1 [ RunTime:0.008145s ]
SELECT `id` FROM `stock` WHERE `id` <> 42149215 AND `partno` = 'P6KE200CA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%fairchild semiconductor%' ) [ RunTime:0.021129s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14800825 [ RunTime:0.008518s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42149830 LIMIT 5 [ RunTime:0.027172s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42149830 ORDER BY `minOrder` ASC [ RunTime:0.034545s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42149830 ORDER BY `unit` DESC [ RunTime:0.012979s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42149830 LIMIT 2 [ RunTime:0.006723s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42149830 ORDER BY `minOrder` ASC [ RunTime:0.007497s ]
select * from pdf where partno='P6KE200AG' and brandshort='onsemi' limit 1 [ RunTime:0.022933s ]
select foldpath,foldpath2,filename from pdf_file where id=1129195 limit 1 [ RunTime:0.011479s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6KE200AG' OR `brand` LIKE 'onsemi%' ) ) LIMIT 1 [ RunTime:0.040629s ]
SELECT `id` FROM `stock` WHERE `id` <> 42149830 AND `partno` = 'P6KE200AG' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%onsemi%' ) [ RunTime:0.016739s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13905746 [ RunTime:0.005001s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42146490 LIMIT 5 [ RunTime:0.007259s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42146490 ORDER BY `minOrder` ASC [ RunTime:0.018977s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42146490 ORDER BY `unit` DESC [ RunTime:0.019099s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42146490 LIMIT 2 [ RunTime:0.018080s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42146490 ORDER BY `minOrder` ASC [ RunTime:0.006424s ]
select * from pdf where partno='P6KE200BRL' and brandshort='onsemi' limit 1 [ RunTime:0.041425s ]
select foldpath,foldpath2,filename from pdf_file where id=654487 limit 1 [ RunTime:0.031405s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6KE200BRL' OR `brand` LIKE 'onsemi%' ) ) LIMIT 1 [ RunTime:0.036592s ]
SELECT `id` FROM `stock` WHERE `id` <> 42146490 AND `partno` = 'P6KE200BRL' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%onsemi%' ) [ RunTime:0.071982s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14800493 [ RunTime:0.100181s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42150905 LIMIT 5 [ RunTime:0.068119s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42150905 ORDER BY `minOrder` ASC [ RunTime:0.049508s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42150905 ORDER BY `unit` DESC [ RunTime:0.053544s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42150905 LIMIT 2 [ RunTime:0.059530s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42150905 ORDER BY `minOrder` ASC [ RunTime:0.057564s ]
select * from pdf where partno='P6KE200CA' and brandshort='Good-Ark Semiconductor' limit 1 [ RunTime:0.034525s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6KE200CA' OR `brand` LIKE 'Good-Ark Semiconductor%' ) ) LIMIT 1 [ RunTime:0.039221s ]
SELECT `id` FROM `stock` WHERE `id` <> 42150905 AND `partno` = 'P6KE200CA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%good-ark semiconductor%' ) [ RunTime:0.036237s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16662614 [ RunTime:0.013083s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42101116 LIMIT 5 [ RunTime:0.017911s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42101116 ORDER BY `minOrder` ASC [ RunTime:0.049349s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42101116 ORDER BY `unit` DESC [ RunTime:0.006966s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42101116 LIMIT 2 [ RunTime:0.016665s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42101116 ORDER BY `minOrder` ASC [ RunTime:0.012226s ]
select * from pdf where partno='P6KE200A' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.016162s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6KE200A' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.014690s ]
SELECT `id` FROM `stock` WHERE `id` <> 42101116 AND `partno` = 'P6KE200A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.011418s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13907977 [ RunTime:0.021006s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42117375 LIMIT 5 [ RunTime:0.000638s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42117375 ORDER BY `minOrder` ASC [ RunTime:0.010966s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42117375 ORDER BY `unit` DESC [ RunTime:0.005213s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42117375 LIMIT 2 [ RunTime:0.004341s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42117375 ORDER BY `minOrder` ASC [ RunTime:0.000578s ]
select * from pdf where partno='P6KE200A-E3/54' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.003316s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6KE200A-E3/54' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.011218s ]
SELECT `id` FROM `stock` WHERE `id` <> 42117375 AND `partno` = 'P6KE200A-E3/54' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.023431s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16676975 [ RunTime:0.003641s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42147133 LIMIT 5 [ RunTime:0.002793s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42147133 ORDER BY `minOrder` ASC [ RunTime:0.005914s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42147133 ORDER BY `unit` DESC [ RunTime:0.007523s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42147133 LIMIT 2 [ RunTime:0.030337s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42147133 ORDER BY `minOrder` ASC [ RunTime:0.012668s ]
select * from pdf where partno='P6KE200BRLG' and brandshort='onsemi' limit 1 [ RunTime:0.019491s ]
select foldpath,foldpath2,filename from pdf_file where id=654487 limit 1 [ RunTime:0.015456s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6KE200BRLG' OR `brand` LIKE 'onsemi%' ) ) LIMIT 1 [ RunTime:0.019040s ]
SELECT `id` FROM `stock` WHERE `id` <> 42147133 AND `partno` = 'P6KE200BRLG' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%onsemi%' ) [ RunTime:0.083549s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16662169 [ RunTime:0.005861s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42155872 LIMIT 5 [ RunTime:0.024555s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42155872 ORDER BY `minOrder` ASC [ RunTime:0.072305s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42155872 ORDER BY `unit` DESC [ RunTime:0.095140s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42155872 LIMIT 2 [ RunTime:0.046483s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42155872 ORDER BY `minOrder` ASC [ RunTime:0.009111s ]
select * from pdf where partno='P6KE200A' and brandshort='STMicroelectronics' limit 1 [ RunTime:0.026651s ]
select foldpath,foldpath2,filename from pdf_file where id=445584 limit 1 [ RunTime:0.059909s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6KE200A' OR `brand` LIKE 'STMicroelectronics%' ) ) LIMIT 1 [ RunTime:0.062002s ]
SELECT `id` FROM `stock` WHERE `id` <> 42155872 AND `partno` = 'P6KE200A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%stmicroelectronics%' ) [ RunTime:0.034909s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16668787 [ RunTime:0.056236s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42150914 LIMIT 5 [ RunTime:0.029370s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42150914 ORDER BY `minOrder` ASC [ RunTime:0.027630s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42150914 ORDER BY `unit` DESC [ RunTime:0.118933s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42150914 LIMIT 2 [ RunTime:0.036097s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42150914 ORDER BY `minOrder` ASC [ RunTime:0.025870s ]
select * from pdf where partno='P6KE200A' and brandshort='Good-Ark Semiconductor' limit 1 [ RunTime:0.045065s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6KE200A' OR `brand` LIKE 'Good-Ark Semiconductor%' ) ) LIMIT 1 [ RunTime:0.023182s ]
SELECT `id` FROM `stock` WHERE `id` <> 42150914 AND `partno` = 'P6KE200A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%good-ark semiconductor%' ) [ RunTime:0.030856s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13905875 [ RunTime:0.129582s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42104287 LIMIT 5 [ RunTime:0.041818s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42104287 ORDER BY `minOrder` ASC [ RunTime:0.024635s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42104287 ORDER BY `unit` DESC [ RunTime:0.114561s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42104287 LIMIT 2 [ RunTime:0.022007s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42104287 ORDER BY `minOrder` ASC [ RunTime:0.012229s ]
select * from pdf where partno='P6KE200CA' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.003287s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6KE200CA' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.018417s ]
SELECT `id` FROM `stock` WHERE `id` <> 42104287 AND `partno` = 'P6KE200CA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.031355s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16665504 [ RunTime:0.019233s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42155610 LIMIT 5 [ RunTime:0.008362s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42155610 ORDER BY `minOrder` ASC [ RunTime:0.010917s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42155610 ORDER BY `unit` DESC [ RunTime:0.022602s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42155610 LIMIT 2 [ RunTime:0.026027s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42155610 ORDER BY `minOrder` ASC [ RunTime:0.010525s ]
select * from pdf where partno='P6KE200CA' and brandshort='STMicroelectronics' limit 1 [ RunTime:0.016092s ]
select foldpath,foldpath2,filename from pdf_file where id=445589 limit 1 [ RunTime:0.006499s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6KE200CA' OR `brand` LIKE 'STMicroelectronics%' ) ) LIMIT 1 [ RunTime:0.021084s ]
SELECT `id` FROM `stock` WHERE `id` <> 42155610 AND `partno` = 'P6KE200CA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%stmicroelectronics%' ) [ RunTime:0.022982s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14812 [ RunTime:0.021351s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13907387 [ RunTime:0.018366s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42155555 LIMIT 5 [ RunTime:0.057628s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42155555 ORDER BY `minOrder` ASC [ RunTime:0.041844s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42155555 ORDER BY `unit` DESC [ RunTime:0.042004s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42155555 LIMIT 2 [ RunTime:0.041061s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42155555 ORDER BY `minOrder` ASC [ RunTime:0.005744s ]
select * from pdf where partno='P6KE200ARL' and brandshort='STMicroelectronics' limit 1 [ RunTime:0.031993s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6KE200ARL' OR `brand` LIKE 'STMicroelectronics%' ) ) LIMIT 1 [ RunTime:0.021771s ]
SELECT `id` FROM `stock` WHERE `id` <> 42155555 AND `partno` = 'P6KE200ARL' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%stmicroelectronics%' ) [ RunTime:0.011334s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13921215 [ RunTime:0.022407s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42152619 LIMIT 5 [ RunTime:0.008456s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42152619 ORDER BY `minOrder` ASC [ RunTime:0.018046s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42152619 ORDER BY `unit` DESC [ RunTime:0.008172s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42152619 LIMIT 2 [ RunTime:0.014041s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42152619 ORDER BY `minOrder` ASC [ RunTime:0.015002s ]
select * from pdf where partno='P6KE200A_R2_00001' and brandshort='Panjit International Inc.' limit 1 [ RunTime:0.014787s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6KE200A_R2_00001' OR `brand` LIKE 'Panjit International Inc.%' ) ) LIMIT 1 [ RunTime:0.020921s ]
SELECT `id` FROM `stock` WHERE `id` <> 42152619 AND `partno` = 'P6KE200A_R2_00001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panjit international inc.%' ) [ RunTime:0.018399s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13906027 [ RunTime:0.015236s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42126735 LIMIT 5 [ RunTime:0.001841s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42126735 ORDER BY `minOrder` ASC [ RunTime:0.020666s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42126735 ORDER BY `unit` DESC [ RunTime:0.014352s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42126735 LIMIT 2 [ RunTime:0.006240s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42126735 ORDER BY `minOrder` ASC [ RunTime:0.002038s ]
select * from pdf where partno='P6KE200A-TP' and brandshort='MCC Micro Commercial Components' limit 1 [ RunTime:0.007146s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6KE200A-TP' OR `brand` LIKE 'MCC (Micro Commercial Components)%' ) ) LIMIT 1 [ RunTime:0.004762s ]
SELECT `id` FROM `stock` WHERE `id` <> 42126735 AND `partno` = 'P6KE200A-TP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mcc%' ) [ RunTime:0.000802s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16676978 [ RunTime:0.000635s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42132412 LIMIT 5 [ RunTime:0.006234s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42132412 ORDER BY `minOrder` ASC [ RunTime:0.004133s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42132412 ORDER BY `unit` DESC [ RunTime:0.000679s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42132412 LIMIT 2 [ RunTime:0.002251s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42132412 ORDER BY `minOrder` ASC [ RunTime:0.006226s ]
select * from pdf where partno='P6KE200CA-E3/54' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.001441s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6KE200CA-E3/54' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.006348s ]
SELECT `id` FROM `stock` WHERE `id` <> 42132412 AND `partno` = 'P6KE200CA-E3/54' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.009894s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16689236 [ RunTime:0.003354s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42146843 LIMIT 5 [ RunTime:0.000780s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42146843 ORDER BY `minOrder` ASC [ RunTime:0.012043s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42146843 ORDER BY `unit` DESC [ RunTime:0.002632s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42146843 LIMIT 2 [ RunTime:0.000653s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42146843 ORDER BY `minOrder` ASC [ RunTime:0.000425s ]
select * from pdf where partno='P6KE200A' and brandshort='Lumimax Optoelectronic Technology' limit 1 [ RunTime:0.004897s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6KE200A' OR `brand` LIKE 'Lumimax Optoelectronic Technology%' ) ) LIMIT 1 [ RunTime:0.007546s ]
SELECT `id` FROM `stock` WHERE `id` <> 42146843 AND `partno` = 'P6KE200A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lumimax optoelectronic technology%' ) [ RunTime:0.023050s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16662196 [ RunTime:0.003727s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42140681 LIMIT 5 [ RunTime:0.003584s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42140681 ORDER BY `minOrder` ASC [ RunTime:0.013279s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42140681 ORDER BY `unit` DESC [ RunTime:0.018634s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42140681 LIMIT 2 [ RunTime:0.007929s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42140681 ORDER BY `minOrder` ASC [ RunTime:0.001741s ]
select * from pdf where partno='P6KE200A-AT/B' and brandshort='YAGEO' limit 1 [ RunTime:0.016088s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6KE200A-AT/B' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.016595s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42123238 LIMIT 5 [ RunTime:0.013158s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42123238 ORDER BY `minOrder` ASC [ RunTime:0.007855s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42123238 ORDER BY `unit` DESC [ RunTime:0.046359s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42123238 LIMIT 2 [ RunTime:0.017989s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42123238 ORDER BY `minOrder` ASC [ RunTime:0.012786s ]
select * from pdf where partno='P6KE200CA/B' and brandshort='YAGEO' limit 1 [ RunTime:0.034104s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6KE200CA/B' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.088276s ]
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 'P6KE200%' OR `brand` LIKE 'P6KE200%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011356s ]
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 'P6KE200%' OR `brand` LIKE 'P6KE200%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.058584s ]
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 'P6KE200%' OR `brand` LIKE 'P6KE200%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.030406s ]
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 'P6KE200%' OR `brand` LIKE 'P6KE200%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.031192s ]
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 'P6KE200%' OR `brand` LIKE 'P6KE200%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012024s ]
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 'P6KE200%' OR `brand` LIKE 'P6KE200%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.047984s ]
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 'P6KE200%' OR `brand` LIKE 'P6KE200%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.030630s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'P6KE200%' OR `brand` LIKE 'P6KE200%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.012541s ]