Products
- Category Search
  
  Board to Board Connectors
  
  Wire Harness
  
  Socket Connectors
  
  Card Edge Connectors
  
  ESD Protector Chip
  
  FPC / FFC Connectors
  
  Pin Header Connectors
  
  I / O Connectors
  
  Compression Terminal
- Filter Search
  Search for products by specific details such as category, series, pin count, pitch, board mounting direction, type of mating, etc...
- Series Search
  Search for products by series.
- Mating Connector Search
  Search for product pairs based on mating height and pitch.
  Compression Search
  Search by compression terminal ranges.
- Handling Manual
  
  Understanding Parts Numbers
  
  Connector glossary
  
  Handling Manual
  
  Product Guide
  
  Connector Selection Guide
Advantage
- Advantage
  
  Floating Connector
  
  Z-Move structure
  
  2-Point Contact structure
  
  Auto I-Lock structure
  
  High-Speed Transmission Connector
  
  High heat-resistant Connector
- Technical Info
  
  What is a connector?
  
  Handling Manual
  
  Technical notes
  
  Advanced Connector Technology
  
  Column
- Understanding Parts Numbers
  We will explain how to read the packaging model number and product model number of IRISO products. Please use this when you want to check the specifications from the model number.
- Connector glossary
  We will introduce and explain connector types, names of each part, and connector terms related to specifications in an easy-to-understand manner.
- Product Guide
  This is the download page for the IRISO product guide. It provides an easy-to-understand introduction to IRISO' connector Technical Info and functions.
- Connector Selection Guide
  We will introduce the features and specifications of our products, focusing on size, etc., so that you can select the most suitable connector from our extensive lineup.
Solutions
- Solution Proposal
  We propose cutting-edge solutions that combine the technologies that IRISO has cultivated over the years.
  
  Automation Connector
  
  High-Speed Transmission Solution
  
  Onboard Coaxial Camera Solution
  
  Vibration Analysis Simulation
- Automotive Connector
  We propose cutting-edge solutions for the automotive market, centering on products for next-generation vehicles.
  
  Connector for ADAS
  
  Powertrain Connectors
  
  Infotainment Connectors
- Consumer Connector
  We propose optimal products for the consumer market such as information communication, video equipment, game equipment, and OA equipment.
  
  Home Appliances
  
  Industrial Devices
- Industrial Connector
  We provide optimal products for the industrial market, such as industrial machinery, communication equipment, and medical equipment.
  
  Industrial Equipment
- Touch Wall
  You can check how our products are used in the car from all viewpoints and angles in 3D.
Company
- Company
  
  Company Profile
  
  Message from Chairman & President
  
  Corporate History
  
  Locations
  
  Brand Statement
  
  Business Composition
  
  Design Policy
  
  Philosophy & Purpose
  
  Action Guidelines
  
  Pursuit of Excellence
  
  Company Brochure
  
  Sponsorship
- Careers
  
  Careers
  
  Club Activities
- Behind the Scenes Story
  You can see the back side of the development of Iriso Electronics Industry, which repeats design, verification, and prototyping many times.
- Exhibition information
  We will introduce information about our exhibition, new products to be exhibited and connection proposals in an easy-to-understand manner with videos.
- Distributors
  You can view information on agents and dealers who handle IRISO products.
Investors
Sustainability
Contact
- Product Inquiries
  For inquiries about products not listed on the product search page, please contact us here.
  Mail Form
- IR Inquiries
  For IR inquiries not listed on the IR page, please contact us here.
  Mail Form
- Other Inquiries
  For Other inquiries regarding proposals such as interviews and sales, please contact us from here.
  Mail Form

MOBILE PHONE BASE STATION INFRASTRUCTURE EQUIPMENT CONNECTOR（FPC / FFC Connectors） MOBILE PHONE BASE STATION INFRASTRUCTURE EQUIPMENT CONNECTOR
（FPC / FFC Connectors）

MOBILE PHONE BASE STATION INFRASTRUCTURE EQUIPMENT CONNECTOR （FPC / FFC Connectors）

Display Option

Results

Image	Product Name	Category	Series	Pin	Pitch(mm)	Board Mounting Method	Mating Interface	Height	Voltage Rating (AC)	Voltage Rating (DC)	Current Rating	Withstand Voltage
Member login required to use comparison list	12003S Series（10）	FPC / FFC Connectors	12003S	10 - 74	0.5	SMT	-	2.5	50	50	0.4	200
Member login required to use comparison list	12002S Series（2）	FPC / FFC Connectors	12002S	20 - 40	0.5	SMT	-	7.6	50	50	0.4	200
Member login required to use comparison list	12001S Series（24）	FPC / FFC Connectors	12001S	6 - 70	0.5	SMT	-	2.5	50	50	0.5	250
Member login required to use comparison list	Automation Connector 11600S Series（24）	FPC / FFC Connectors	11600S	8 - 60	0.5	SMT	-	6 - 6.5	50	50	0.5	250
Member login required to use comparison list	Automation Connector 11503S Series（1）	FPC / FFC Connectors	11503S	60	0.5	SMT	-	3.4	50	50	0.5	250
Member login required to use comparison list	Automation Connector 11501S Series（25）	FPC / FFC Connectors	11501S	8 - 60	0.5	SMT	-	3.4	50	50	0.5	250
Member login required to use comparison list	9699S Series（5）	FPC / FFC Connectors	9699S	15 - 50	0.5	SMT	-	2.9	50	50	0.5	200
Member login required to use comparison list	9695S Series（2）	FPC / FFC Connectors	9695S	10 - 15	0.5	SMT	-	7.95	50	50	0.5	200
Member login required to use comparison list	9691S Series（3）	FPC / FFC Connectors	9691S	10 - 15	0.5	SMT	-	2.75	50	50	0.5	200
Member login required to use comparison list	9688S Series（6）	FPC / FFC Connectors	9688S	50 - 100	0.5	SMT	-	1.95	50	50	0.5	250
Member login required to use comparison list	9687S Series（49）	FPC / FFC Connectors	9687S	4 - 60	0.5	SMT	-	5.5	50	50	0.5	250
Member login required to use comparison list	9686S Series（27）	FPC / FFC Connectors	9686S	4 - 50	0.5	SMT	-	1.8	50	50	0.5	250
Member login required to use comparison list	9685S Series（47）	FPC / FFC Connectors	9685S	4 - 50	0.5	SMT	-	1.8	50	50	0.5	250
Member login required to use comparison list	9665S Series（54）	FPC / FFC Connectors	9665S	4 - 40	1	SMT	-	5.5	125	125	1	250
Member login required to use comparison list	9664S Series（58）	FPC / FFC Connectors	9664S	4 - 40	1	SMT	-	2.5	125	125	1	250
Member login required to use comparison list	9663S Series（38）	FPC / FFC Connectors	9663S	4 - 40	1	SMT	-	2.55	125	125	1	250
Member login required to use comparison list	9661S Series（1）	FPC / FFC Connectors	9661S	16	1	SMT	-	2.5	125	125	1	250
Member login required to use comparison list	9639S Series（39）	FPC / FFC Connectors	9639S	6 - 60	0.5	SMT	-	4 - 5.5	50	50	0.5	250
Member login required to use comparison list	9637S Series（54）	FPC / FFC Connectors	9637S	6 - 60	0.5	SMT	-	2	50	50	0.5	250
Member login required to use comparison list	9634S Series（3）	FPC / FFC Connectors	9634S	30 - 60	0.5	SMT	-	2	50	50	0.5	250

MOBILE PHONE BASE STATION INFRASTRUCTURE EQUIPMENT CONNECTORIf you would like a custom product, please contact us.

Click here for inquiry form

Solution Proposal

We propose cutting-edge solutions that combine the technologies that IRISO has cultivated over the years.

Automation Connector

High-Speed Transmission Solution

Onboard Coaxial Camera Solution

Vibration Analysis Simulation
Automotive Connector

We propose cutting-edge solutions for the automotive market, centering on products for next-generation vehicles.

Connector for ADAS

Powertrain Connectors

Infotainment Connectors
Consumer Connector

We propose optimal products for the consumer market such as information communication, video equipment, game equipment, and OA equipment.

Home Appliances

Industrial Devices
Industrial Connector

We provide optimal products for the industrial market, such as industrial machinery, communication equipment, and medical equipment.

Industrial Equipment

(default) 84 queries took 339 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	SELECT `Application`.`id`, `Application`.`parent_id`, `Application`.`name`, `Application`.`name_en`, `Application`.`name_zh`, `Application`.`name_ko`, `Application`.`url`, `Application`.`market_name`, `Application`.`market_name_en`, `Application`.`market_name_zh`, `Application`.`market_name_ko`, `Application`.`html`, `Application`.`html_en`, `Application`.`html_zh`, `Application`.`html_ko`, `Application`.`header_title1`, `Application`.`header_title2`, `Application`.`header_title3`, `Application`.`header_title4`, `Application`.`header_url1`, `Application`.`header_url2`, `Application`.`header_url3`, `Application`.`header_url4`, `Application`.`series_ids`, `Application`.`odr`, `Application`.`created`, `Application`.`modified`, (CONCAT_WS( "", IFNULL( `Application`.`name`, ""), IFNULL( `Application`.`header_title1`, ""), IFNULL( `Application`.`header_title2`, ""), IFNULL( `Application`.`header_title3`, ""), IFNULL( `Application`.`header_title4`, ""), IFNULL( `Application`.`series_ids`, ""))) AS `Application__keyword` FROM `irisoweb2_test`.`applications` AS `Application` WHERE `Application`.`url` = 'infrastructure' LIMIT 1	1	1	0
2	SELECT `Application`.`id`, `Application`.`parent_id`, `Application`.`name`, `Application`.`name_en`, `Application`.`name_zh`, `Application`.`name_ko`, `Application`.`url`, `Application`.`market_name`, `Application`.`market_name_en`, `Application`.`market_name_zh`, `Application`.`market_name_ko`, `Application`.`html`, `Application`.`html_en`, `Application`.`html_zh`, `Application`.`html_ko`, `Application`.`header_title1`, `Application`.`header_title2`, `Application`.`header_title3`, `Application`.`header_title4`, `Application`.`header_url1`, `Application`.`header_url2`, `Application`.`header_url3`, `Application`.`header_url4`, `Application`.`series_ids`, `Application`.`odr`, `Application`.`created`, `Application`.`modified`, (CONCAT_WS( "", IFNULL( `Application`.`name`, ""), IFNULL( `Application`.`header_title1`, ""), IFNULL( `Application`.`header_title2`, ""), IFNULL( `Application`.`header_title3`, ""), IFNULL( `Application`.`header_title4`, ""), IFNULL( `Application`.`series_ids`, ""))) AS `Application__keyword` FROM `irisoweb2_test`.`applications` AS `Application` WHERE `Application`.`parent_id` = (50)	0	0	0
3	SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`model_id`, `Attachment`.`field_name`, `Attachment`.`file_name`, `Attachment`.`file_content_type`, `Attachment`.`file_size`, `Attachment`.`created`, `Attachment`.`modified` FROM `irisoweb2_test`.`attachments` AS `Attachment` WHERE `model` = 'Application' AND model_id = (50)	1	1	3
4	SELECT `Application`.`id`, `Application`.`parent_id`, `Application`.`name`, `Application`.`name_en`, `Application`.`name_zh`, `Application`.`name_ko`, `Application`.`url`, `Application`.`market_name`, `Application`.`market_name_en`, `Application`.`market_name_zh`, `Application`.`market_name_ko`, `Application`.`html`, `Application`.`html_en`, `Application`.`html_zh`, `Application`.`html_ko`, `Application`.`header_title1`, `Application`.`header_title2`, `Application`.`header_title3`, `Application`.`header_title4`, `Application`.`header_url1`, `Application`.`header_url2`, `Application`.`header_url3`, `Application`.`header_url4`, `Application`.`series_ids`, `Application`.`odr`, `Application`.`created`, `Application`.`modified`, (CONCAT_WS( "", IFNULL( `Application`.`name`, ""), IFNULL( `Application`.`header_title1`, ""), IFNULL( `Application`.`header_title2`, ""), IFNULL( `Application`.`header_title3`, ""), IFNULL( `Application`.`header_title4`, ""), IFNULL( `Application`.`series_ids`, ""))) AS `Application__keyword` FROM `irisoweb2_test`.`applications` AS `Application` WHERE `Application`.`url` = 'infrastructure' ORDER BY `Application`.`odr` ASC LIMIT 1	1	1	0
5	SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`model_id`, `Attachment`.`field_name`, `Attachment`.`file_name`, `Attachment`.`file_content_type`, `Attachment`.`file_size`, `Attachment`.`created`, `Attachment`.`modified` FROM `irisoweb2_test`.`attachments` AS `Attachment` WHERE `model` = 'Application' AND model_id = (50)	1	1	3
6	SELECT `Application`.`id`, `Application`.`parent_id`, `Application`.`name`, `Application`.`name_en`, `Application`.`name_zh`, `Application`.`name_ko`, `Application`.`url`, `Application`.`market_name`, `Application`.`market_name_en`, `Application`.`market_name_zh`, `Application`.`market_name_ko`, `Application`.`html`, `Application`.`html_en`, `Application`.`html_zh`, `Application`.`html_ko`, `Application`.`header_title1`, `Application`.`header_title2`, `Application`.`header_title3`, `Application`.`header_title4`, `Application`.`header_url1`, `Application`.`header_url2`, `Application`.`header_url3`, `Application`.`header_url4`, `Application`.`series_ids`, `Application`.`odr`, `Application`.`created`, `Application`.`modified`, (CONCAT_WS( "", IFNULL( `Application`.`name`, ""), IFNULL( `Application`.`header_title1`, ""), IFNULL( `Application`.`header_title2`, ""), IFNULL( `Application`.`header_title3`, ""), IFNULL( `Application`.`header_title4`, ""), IFNULL( `Application`.`series_ids`, ""))) AS `Application__keyword` FROM `irisoweb2_test`.`applications` AS `Application` WHERE `Application`.`id` = 49 ORDER BY `Application`.`odr` ASC LIMIT 1	1	1	0
7	SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`model_id`, `Attachment`.`field_name`, `Attachment`.`file_name`, `Attachment`.`file_content_type`, `Attachment`.`file_size`, `Attachment`.`created`, `Attachment`.`modified` FROM `irisoweb2_test`.`attachments` AS `Attachment` WHERE `model` = 'Application' AND model_id = (49)	1	1	3
8	SELECT `Application`.`id`, `Application`.`parent_id`, `Application`.`name`, `Application`.`name_en`, `Application`.`name_zh`, `Application`.`name_ko`, `Application`.`url`, `Application`.`market_name`, `Application`.`market_name_en`, `Application`.`market_name_zh`, `Application`.`market_name_ko`, `Application`.`html`, `Application`.`html_en`, `Application`.`html_zh`, `Application`.`html_ko`, `Application`.`header_title1`, `Application`.`header_title2`, `Application`.`header_title3`, `Application`.`header_title4`, `Application`.`header_url1`, `Application`.`header_url2`, `Application`.`header_url3`, `Application`.`header_url4`, `Application`.`series_ids`, `Application`.`odr`, `Application`.`created`, `Application`.`modified`, (CONCAT_WS( "", IFNULL( `Application`.`name`, ""), IFNULL( `Application`.`header_title1`, ""), IFNULL( `Application`.`header_title2`, ""), IFNULL( `Application`.`header_title3`, ""), IFNULL( `Application`.`header_title4`, ""), IFNULL( `Application`.`series_ids`, ""))) AS `Application__keyword` FROM `irisoweb2_test`.`applications` AS `Application` WHERE `Application`.`id` = 48 ORDER BY `Application`.`odr` ASC LIMIT 1	1	1	0
9	SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`model_id`, `Attachment`.`field_name`, `Attachment`.`file_name`, `Attachment`.`file_content_type`, `Attachment`.`file_size`, `Attachment`.`created`, `Attachment`.`modified` FROM `irisoweb2_test`.`attachments` AS `Attachment` WHERE `model` = 'Application' AND model_id = (48)	1	1	3
10	SELECT `Category`.`id`, `Category`.`status`, `Category`.`name`, `Category`.`name_en`, `Category`.`name_zh`, `Category`.`name_ko`, `Category`.`detail`, `Category`.`detail_en`, `Category`.`detail_zh`, `Category`.`detail_ko`, `Category`.`title`, `Category`.`title_en`, `Category`.`title_zh`, `Category`.`title_ko`, `Category`.`description`, `Category`.`description_en`, `Category`.`description_zh`, `Category`.`description_ko`, `Category`.`meta_keyword`, `Category`.`meta_keyword_en`, `Category`.`meta_keyword_zh`, `Category`.`meta_keyword_ko`, `Category`.`use_fields`, `Category`.`url`, `Category`.`header_title1`, `Category`.`header_title2`, `Category`.`header_title3`, `Category`.`header_title4`, `Category`.`header_url1`, `Category`.`header_url2`, `Category`.`header_url3`, `Category`.`header_url4`, `Category`.`odr`, `Category`.`created`, `Category`.`modified`, (CONCAT_WS( " ", IFNULL(`Category`.`name`, ""), IFNULL(`Category`.`name_en`, ""), IFNULL(`Category`.`name_zh`, ""), IFNULL(`Category`.`name_ko`, ""), IFNULL(`Category`.`detail`, ""), IFNULL(`Category`.`detail_en`, ""), IFNULL(`Category`.`detail_zh`, ""), IFNULL(`Category`.`detail_ko`, ""), IFNULL(`Category`.`url`, ""), IFNULL(`Category`.`header_title1`, ""), IFNULL(`Category`.`header_title2`, ""), IFNULL(`Category`.`header_title3`, ""), IFNULL(`Category`.`header_title4`, ""))) AS `Category__keyword` FROM `irisoweb2_test`.`categories` AS `Category` WHERE `Category`.`status` = '有効' AND `Category`.`url` = 'fpc-ffc' LIMIT 1	1	1	0
11	SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`model_id`, `Attachment`.`field_name`, `Attachment`.`file_name`, `Attachment`.`file_content_type`, `Attachment`.`file_size`, `Attachment`.`created`, `Attachment`.`modified` FROM `irisoweb2_test`.`attachments` AS `Attachment` WHERE `model` = 'Category' AND model_id = (2)	1	1	2
12	SELECT `Series`.`id`, `Series`.`status`, `Series`.`name`, `Series`.`detail`, `Series`.`detail_en`, `Series`.`detail_zh`, `Series`.`detail_ko`, `Series`.`category_id`, `Series`.`html`, `Series`.`html_en`, `Series`.`html_zh`, `Series`.`html_ko`, `Series`.`title`, `Series`.`title_en`, `Series`.`title_zh`, `Series`.`title_ko`, `Series`.`description`, `Series`.`description_en`, `Series`.`description_zh`, `Series`.`description_ko`, `Series`.`keyword_en`, `Series`.`keyword_zh`, `Series`.`keyword_ko`, `Series`.`file_title1`, `Series`.`file_title2`, `Series`.`file_title3`, `Series`.`file_title4`, `Series`.`file_title5`, `Series`.`file_title6`, `Series`.`file_title7`, `Series`.`file_title8`, `Series`.`file_role1`, `Series`.`file_role2`, `Series`.`file_role3`, `Series`.`file_role4`, `Series`.`file_role5`, `Series`.`file_role6`, `Series`.`file_role7`, `Series`.`file_role8`, `Series`.`file_count1`, `Series`.`file_count2`, `Series`.`file_count3`, `Series`.`file_count4`, `Series`.`file_count5`, `Series`.`file_count6`, `Series`.`file_count7`, `Series`.`file_count8`, `Series`.`similar`, `Series`.`alternative`, `Series`.`combination`, `Series`.`ambiguous`, `Series`.`notice_pattern`, `Series`.`type1`, `Series`.`type2`, `Series`.`type3`, `Series`.`type4`, `Series`.`type5`, `Series`.`type6`, `Series`.`type7`, `Series`.`type8`, `Series`.`type9`, `Series`.`type10`, `Series`.`type11`, `Series`.`type12`, `Series`.`type13`, `Series`.`type14`, `Series`.`type15`, `Series`.`type16`, `Series`.`type17`, `Series`.`type18`, `Series`.`type19`, `Series`.`type20`, `Series`.`type21`, `Series`.`type22`, `Series`.`type23`, `Series`.`type24`, `Series`.`type25`, `Series`.`type26`, `Series`.`type27`, `Series`.`type28`, `Series`.`type29`, `Series`.`type30`, `Series`.`type_height1`, `Series`.`type_height2`, `Series`.`type_height3`, `Series`.`type_height4`, `Series`.`type_height5`, `Series`.`type_height6`, `Series`.`type_height7`, `Series`.`type_height8`, `Series`.`type_height9`, `Series`.`type_height10`, `Series`.`type_height11`, `Series`.`type_height12`, `Series`.`type_height13`, `Series`.`type_height14`, `Series`.`type_height15`, `Series`.`type_height16`, `Series`.`type_height17`, `Series`.`type_height18`, `Series`.`type_height19`, `Series`.`type_height20`, `Series`.`type_height21`, `Series`.`type_height22`, `Series`.`type_height23`, `Series`.`type_height24`, `Series`.`type_height25`, `Series`.`type_height26`, `Series`.`type_height27`, `Series`.`type_height28`, `Series`.`type_height29`, `Series`.`type_height30`, `Series`.`odr`, `Series`.`created`, `Series`.`modified`, (CONCAT_WS( " ", IFNULL(`Series`.`name`,""), IFNULL(`Series`.`detail`,""), IFNULL(`Series`.`detail_en`,""), IFNULL(`Series`.`detail_zh`,""), IFNULL(`Series`.`detail_ko`,""), IFNULL(`Series`.`similar`,""), IFNULL(`Series`.`alternative`,""), IFNULL(`Series`.`combination`,""), IFNULL(`Series`.`ambiguous`,""))) AS `Series__keyword`, `Category`.`id`, `Category`.`status`, `Category`.`name`, `Category`.`name_en`, `Category`.`name_zh`, `Category`.`name_ko`, `Category`.`detail`, `Category`.`detail_en`, `Category`.`detail_zh`, `Category`.`detail_ko`, `Category`.`title`, `Category`.`title_en`, `Category`.`title_zh`, `Category`.`title_ko`, `Category`.`description`, `Category`.`description_en`, `Category`.`description_zh`, `Category`.`description_ko`, `Category`.`meta_keyword`, `Category`.`meta_keyword_en`, `Category`.`meta_keyword_zh`, `Category`.`meta_keyword_ko`, `Category`.`use_fields`, `Category`.`url`, `Category`.`header_title1`, `Category`.`header_title2`, `Category`.`header_title3`, `Category`.`header_title4`, `Category`.`header_url1`, `Category`.`header_url2`, `Category`.`header_url3`, `Category`.`header_url4`, `Category`.`odr`, `Category`.`created`, `Category`.`modified`, (CONCAT_WS( " ", IFNULL(`Category`.`name`, ""), IFNULL(`Category`.`name_en`, ""), IFNULL(`Category`.`name_zh`, ""), IFNULL(`Category`.`name_ko`, ""), IFNULL(`Category`.`detail`, ""), IFNULL(`Category`.`detail_en`, ""), IFNULL(`Category`.`detail_zh`, ""), IFNULL(`Category`.`detail_ko`, ""), IFNULL(`Category`.`url`, ""), IFNULL(`Category`.`header_title1`, ""), IFNULL(`Category`.`header_title2`, ""), IFNULL(`Category`.`header_title3`, ""), IFNULL(`Category`.`header_title4`, ""))) AS `Category__keyword` FROM `irisoweb2_test`.`series` AS `Series` LEFT JOIN `irisoweb2_test`.`categories` AS `Category` ON (`Series`.`category_id` = `Category`.`id`) WHERE `Series`.`name` IN ('6801', '6802', '6803', '11501S', '11503S', '11600S', '12001S', '12002S', '12003S', '9604S', '9610S', '9611S', '9615S', '9616S', '9617S', '9618S', '9619S', '9631S', '9632S', '9634S', '9637S', '9639S', '9661S', '9663S', '9664S', '9665S', '9685S', '9686S', '9687S', '9688S', '9691S', '9695S', '9699S', '6661S', '6662S', '18010S', '16104S', '6223S', '9162S', '9240S', '9241S', '9706S', '9203B', '9261B', '10101S', '10102B', '10102S', '10103B', '10103S', '10106B', '10106S', '10109B', '10109S', '10110B', '10112B', '10112S', '10120B', '10120S', '10121S', '10126B', '10126S', '11000S', '11007S', '9110B', '9110S', '9111B', '9111S', '9115B', '9115S', '9155B', '9157B', '9157S', '9176B', '9179B', '9179S', '9180S', '9184B', '9195B', '9735B', '9735S', '9827B', '9827S', '9828S', '9850B', '9850S', '9851B', '9851S', '9852S', '9853B', '9854B', '9854S', '9855B', '9855S', '9856B', '9856S', '9857B', '9857S', '9860B', '9890B', '9890S', '9892B', '9892S', '9984B', '9984S', '9985S') AND `Series`.`status` = '有効' AND `Category`.`url` = 'fpc-ffc' ORDER BY `Series`.`odr` DESC, `Series`.`id` DESC LIMIT 20	20	20	3
13	SELECT `Download`.`id`, `Download`.`type`, `Download`.`user_id`, `Download`.`series_id`, `Download`.`product_id`, `Download`.`field`, `Download`.`ip_address`, `Download`.`domain`, `Download`.`created`, `Download`.`modified` FROM `irisoweb2_test`.`downloads` AS `Download` WHERE `user_id` IS NULL AND `type` = 'FAV' AND `Download`.`series_id` IN (51, 50, 49, 46, 45, 43, 437, 434, 431, 429, 428, 427, 426, 421, 420, 419, 417, 415, 414, 413)	0	0	5
14	SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`model_id`, `Attachment`.`field_name`, `Attachment`.`file_name`, `Attachment`.`file_content_type`, `Attachment`.`file_size`, `Attachment`.`created`, `Attachment`.`modified` FROM `irisoweb2_test`.`attachments` AS `Attachment` WHERE `model` = 'Series' AND `model_id` IN (51, 50, 49, 46, 45, 43, 437, 434, 431, 429, 428, 427, 426, 421, 420, 419, 417, 415, 414, 413)	35	35	3
15	SELECT COUNT(*) AS `count` FROM `irisoweb2_test`.`series` AS `Series` LEFT JOIN `irisoweb2_test`.`categories` AS `Category` ON (`Series`.`category_id` = `Category`.`id`) WHERE `Series`.`name` IN ('6801', '6802', '6803', '11501S', '11503S', '11600S', '12001S', '12002S', '12003S', '9604S', '9610S', '9611S', '9615S', '9616S', '9617S', '9618S', '9619S', '9631S', '9632S', '9634S', '9637S', '9639S', '9661S', '9663S', '9664S', '9665S', '9685S', '9686S', '9687S', '9688S', '9691S', '9695S', '9699S', '6661S', '6662S', '18010S', '16104S', '6223S', '9162S', '9240S', '9241S', '9706S', '9203B', '9261B', '10101S', '10102B', '10102S', '10103B', '10103S', '10106B', '10106S', '10109B', '10109S', '10110B', '10112B', '10112S', '10120B', '10120S', '10121S', '10126B', '10126S', '11000S', '11007S', '9110B', '9110S', '9111B', '9111S', '9115B', '9115S', '9155B', '9157B', '9157S', '9176B', '9179B', '9179S', '9180S', '9184B', '9195B', '9735B', '9735S', '9827B', '9827S', '9828S', '9850B', '9850S', '9851B', '9851S', '9852S', '9853B', '9854B', '9854S', '9855B', '9855S', '9856B', '9856S', '9857B', '9857S', '9860B', '9890B', '9890S', '9892B', '9892S', '9984B', '9984S', '9985S') AND `Series`.`status` = '有効' AND `Category`.`url` = 'fpc-ffc'	1	1	1
16	SELECT COUNT(*) AS count, MAX(CAST(`極数` AS SIGNED)) AS 極数_max, MIN(CAST(`極数` AS SIGNED)) AS 極数_min, MAX(CAST(`嵌合部ピッチ` AS DECIMAL(10,3))) AS 嵌合部ピッチ_max, MIN(CAST(`嵌合部ピッチ` AS DECIMAL(10,3))) AS 嵌合部ピッチ_min, `Product`.`嵌合形状`, `Product`.`基板実装方法`, MAX(CAST(`本体高さ` AS DECIMAL(10,3))) AS 本体高さ_max, MIN(CAST(`本体高さ` AS DECIMAL(10,3))) AS 本体高さ_min, MAX(CAST(`定格電圧（AC）` AS DECIMAL(10,3))) AS 定格電圧（AC）_max, MIN(CAST(`定格電圧（AC）` AS DECIMAL(10,3))) AS 定格電圧（AC）_min, MAX(CAST(`定格電圧（DC）` AS DECIMAL(10,3))) AS 定格電圧（DC）_max, MIN(CAST(`定格電圧（DC）` AS DECIMAL(10,3))) AS 定格電圧（DC）_min, MAX(CAST(`定格電流` AS DECIMAL(10,3))) AS 定格電流_max, MIN(CAST(`定格電流` AS DECIMAL(10,3))) AS 定格電流_min, MAX(CAST(`耐電圧` AS DECIMAL(10,3))) AS 耐電圧_max, MIN(CAST(`耐電圧` AS DECIMAL(10,3))) AS 耐電圧_min, `Product`.`伝送速度（代表参考値）`, `Product`.`使用温度範囲（Max）`, `Product`.`フローティング機能`, `Product`.`振幅許容範囲`, `Product`.`2点接点`, `Product`.`ロック方式`, `Product`.`id` FROM `irisoweb2_test`.`products` AS `Product` LEFT JOIN `irisoweb2_test`.`series` AS `Series` ON (`Product`.`series_id` = `Series`.`id`) WHERE `Product`.`series_id` = 51 AND `Product`.`status` = '有効' AND `Product`.`販売分類` <> 'EOS' GROUP BY `Product`.`series_id` ORDER BY Product.販売分類 ASC, `Product`.`odr` DESC, `Product`.`id` DESC LIMIT 1	1	1	7
17	SELECT `Download`.`id`, `Download`.`type`, `Download`.`user_id`, `Download`.`series_id`, `Download`.`product_id`, `Download`.`field`, `Download`.`ip_address`, `Download`.`domain`, `Download`.`created`, `Download`.`modified` FROM `irisoweb2_test`.`downloads` AS `Download` WHERE `Download`.`product_id` = (468)	5	5	4
18	SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`model_id`, `Attachment`.`field_name`, `Attachment`.`file_name`, `Attachment`.`file_content_type`, `Attachment`.`file_size`, `Attachment`.`created`, `Attachment`.`modified` FROM `irisoweb2_test`.`attachments` AS `Attachment` WHERE `model` = 'Product' AND model_id = (468)	2	2	5
19	SELECT COUNT(*) AS count, MAX(CAST(`極数` AS SIGNED)) AS 極数_max, MIN(CAST(`極数` AS SIGNED)) AS 極数_min, MAX(CAST(`嵌合部ピッチ` AS DECIMAL(10,3))) AS 嵌合部ピッチ_max, MIN(CAST(`嵌合部ピッチ` AS DECIMAL(10,3))) AS 嵌合部ピッチ_min, `Product`.`嵌合形状`, `Product`.`基板実装方法`, MAX(CAST(`本体高さ` AS DECIMAL(10,3))) AS 本体高さ_max, MIN(CAST(`本体高さ` AS DECIMAL(10,3))) AS 本体高さ_min, MAX(CAST(`定格電圧（AC）` AS DECIMAL(10,3))) AS 定格電圧（AC）_max, MIN(CAST(`定格電圧（AC）` AS DECIMAL(10,3))) AS 定格電圧（AC）_min, MAX(CAST(`定格電圧（DC）` AS DECIMAL(10,3))) AS 定格電圧（DC）_max, MIN(CAST(`定格電圧（DC）` AS DECIMAL(10,3))) AS 定格電圧（DC）_min, MAX(CAST(`定格電流` AS DECIMAL(10,3))) AS 定格電流_max, MIN(CAST(`定格電流` AS DECIMAL(10,3))) AS 定格電流_min, MAX(CAST(`耐電圧` AS DECIMAL(10,3))) AS 耐電圧_max, MIN(CAST(`耐電圧` AS DECIMAL(10,3))) AS 耐電圧_min, `Product`.`伝送速度（代表参考値）`, `Product`.`使用温度範囲（Max）`, `Product`.`フローティング機能`, `Product`.`振幅許容範囲`, `Product`.`2点接点`, `Product`.`ロック方式`, `Product`.`id` FROM `irisoweb2_test`.`products` AS `Product` LEFT JOIN `irisoweb2_test`.`series` AS `Series` ON (`Product`.`series_id` = `Series`.`id`) WHERE `Product`.`series_id` = 50 AND `Product`.`status` = '有効' AND `Product`.`販売分類` <> 'EOS' GROUP BY `Product`.`series_id` ORDER BY Product.販売分類 ASC, `Product`.`odr` DESC, `Product`.`id` DESC LIMIT 1	1	1	11
20	SELECT `Download`.`id`, `Download`.`type`, `Download`.`user_id`, `Download`.`series_id`, `Download`.`product_id`, `Download`.`field`, `Download`.`ip_address`, `Download`.`domain`, `Download`.`created`, `Download`.`modified` FROM `irisoweb2_test`.`downloads` AS `Download` WHERE `Download`.`product_id` = (466)	0	0	6
21	SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`model_id`, `Attachment`.`field_name`, `Attachment`.`file_name`, `Attachment`.`file_content_type`, `Attachment`.`file_size`, `Attachment`.`created`, `Attachment`.`modified` FROM `irisoweb2_test`.`attachments` AS `Attachment` WHERE `model` = 'Product' AND model_id = (466)	1	1	3
22	SELECT COUNT(*) AS count, MAX(CAST(`極数` AS SIGNED)) AS 極数_max, MIN(CAST(`極数` AS SIGNED)) AS 極数_min, MAX(CAST(`嵌合部ピッチ` AS DECIMAL(10,3))) AS 嵌合部ピッチ_max, MIN(CAST(`嵌合部ピッチ` AS DECIMAL(10,3))) AS 嵌合部ピッチ_min, `Product`.`嵌合形状`, `Product`.`基板実装方法`, MAX(CAST(`本体高さ` AS DECIMAL(10,3))) AS 本体高さ_max, MIN(CAST(`本体高さ` AS DECIMAL(10,3))) AS 本体高さ_min, MAX(CAST(`定格電圧（AC）` AS DECIMAL(10,3))) AS 定格電圧（AC）_max, MIN(CAST(`定格電圧（AC）` AS DECIMAL(10,3))) AS 定格電圧（AC）_min, MAX(CAST(`定格電圧（DC）` AS DECIMAL(10,3))) AS 定格電圧（DC）_max, MIN(CAST(`定格電圧（DC）` AS DECIMAL(10,3))) AS 定格電圧（DC）_min, MAX(CAST(`定格電流` AS DECIMAL(10,3))) AS 定格電流_max, MIN(CAST(`定格電流` AS DECIMAL(10,3))) AS 定格電流_min, MAX(CAST(`耐電圧` AS DECIMAL(10,3))) AS 耐電圧_max, MIN(CAST(`耐電圧` AS DECIMAL(10,3))) AS 耐電圧_min, `Product`.`伝送速度（代表参考値）`, `Product`.`使用温度範囲（Max）`, `Product`.`フローティング機能`, `Product`.`振幅許容範囲`, `Product`.`2点接点`, `Product`.`ロック方式`, `Product`.`id` FROM `irisoweb2_test`.`products` AS `Product` LEFT JOIN `irisoweb2_test`.`series` AS `Series` ON (`Product`.`series_id` = `Series`.`id`) WHERE `Product`.`series_id` = 49 AND `Product`.`status` = '有効' AND `Product`.`販売分類` <> 'EOS' GROUP BY `Product`.`series_id` ORDER BY Product.販売分類 ASC, `Product`.`odr` DESC, `Product`.`id` DESC LIMIT 1	1	1	11
23	SELECT `Download`.`id`, `Download`.`type`, `Download`.`user_id`, `Download`.`series_id`, `Download`.`product_id`, `Download`.`field`, `Download`.`ip_address`, `Download`.`domain`, `Download`.`created`, `Download`.`modified` FROM `irisoweb2_test`.`downloads` AS `Download` WHERE `Download`.`product_id` = (407)	0	0	6
24	SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`model_id`, `Attachment`.`field_name`, `Attachment`.`file_name`, `Attachment`.`file_content_type`, `Attachment`.`file_size`, `Attachment`.`created`, `Attachment`.`modified` FROM `irisoweb2_test`.`attachments` AS `Attachment` WHERE `model` = 'Product' AND model_id = (407)	3	3	4
25	SELECT COUNT(*) AS count, MAX(CAST(`極数` AS SIGNED)) AS 極数_max, MIN(CAST(`極数` AS SIGNED)) AS 極数_min, MAX(CAST(`嵌合部ピッチ` AS DECIMAL(10,3))) AS 嵌合部ピッチ_max, MIN(CAST(`嵌合部ピッチ` AS DECIMAL(10,3))) AS 嵌合部ピッチ_min, `Product`.`嵌合形状`, `Product`.`基板実装方法`, MAX(CAST(`本体高さ` AS DECIMAL(10,3))) AS 本体高さ_max, MIN(CAST(`本体高さ` AS DECIMAL(10,3))) AS 本体高さ_min, MAX(CAST(`定格電圧（AC）` AS DECIMAL(10,3))) AS 定格電圧（AC）_max, MIN(CAST(`定格電圧（AC）` AS DECIMAL(10,3))) AS 定格電圧（AC）_min, MAX(CAST(`定格電圧（DC）` AS DECIMAL(10,3))) AS 定格電圧（DC）_max, MIN(CAST(`定格電圧（DC）` AS DECIMAL(10,3))) AS 定格電圧（DC）_min, MAX(CAST(`定格電流` AS DECIMAL(10,3))) AS 定格電流_max, MIN(CAST(`定格電流` AS DECIMAL(10,3))) AS 定格電流_min, MAX(CAST(`耐電圧` AS DECIMAL(10,3))) AS 耐電圧_max, MIN(CAST(`耐電圧` AS DECIMAL(10,3))) AS 耐電圧_min, `Product`.`伝送速度（代表参考値）`, `Product`.`使用温度範囲（Max）`, `Product`.`フローティング機能`, `Product`.`振幅許容範囲`, `Product`.`2点接点`, `Product`.`ロック方式`, `Product`.`id` FROM `irisoweb2_test`.`products` AS `Product` LEFT JOIN `irisoweb2_test`.`series` AS `Series` ON (`Product`.`series_id` = `Series`.`id`) WHERE `Product`.`series_id` = 46 AND `Product`.`status` = '有効' AND `Product`.`販売分類` <> 'EOS' GROUP BY `Product`.`series_id` ORDER BY Product.販売分類 ASC, `Product`.`odr` DESC, `Product`.`id` DESC LIMIT 1	1	1	11
26	SELECT `Download`.`id`, `Download`.`type`, `Download`.`user_id`, `Download`.`series_id`, `Download`.`product_id`, `Download`.`field`, `Download`.`ip_address`, `Download`.`domain`, `Download`.`created`, `Download`.`modified` FROM `irisoweb2_test`.`downloads` AS `Download` WHERE `Download`.`product_id` = (363)	0	0	5
27	SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`model_id`, `Attachment`.`field_name`, `Attachment`.`file_name`, `Attachment`.`file_content_type`, `Attachment`.`file_size`, `Attachment`.`created`, `Attachment`.`modified` FROM `irisoweb2_test`.`attachments` AS `Attachment` WHERE `model` = 'Product' AND model_id = (363)	3	3	3
28	SELECT COUNT(*) AS count, MAX(CAST(`極数` AS SIGNED)) AS 極数_max, MIN(CAST(`極数` AS SIGNED)) AS 極数_min, MAX(CAST(`嵌合部ピッチ` AS DECIMAL(10,3))) AS 嵌合部ピッチ_max, MIN(CAST(`嵌合部ピッチ` AS DECIMAL(10,3))) AS 嵌合部ピッチ_min, `Product`.`嵌合形状`, `Product`.`基板実装方法`, MAX(CAST(`本体高さ` AS DECIMAL(10,3))) AS 本体高さ_max, MIN(CAST(`本体高さ` AS DECIMAL(10,3))) AS 本体高さ_min, MAX(CAST(`定格電圧（AC）` AS DECIMAL(10,3))) AS 定格電圧（AC）_max, MIN(CAST(`定格電圧（AC）` AS DECIMAL(10,3))) AS 定格電圧（AC）_min, MAX(CAST(`定格電圧（DC）` AS DECIMAL(10,3))) AS 定格電圧（DC）_max, MIN(CAST(`定格電圧（DC）` AS DECIMAL(10,3))) AS 定格電圧（DC）_min, MAX(CAST(`定格電流` AS DECIMAL(10,3))) AS 定格電流_max, MIN(CAST(`定格電流` AS DECIMAL(10,3))) AS 定格電流_min, MAX(CAST(`耐電圧` AS DECIMAL(10,3))) AS 耐電圧_max, MIN(CAST(`耐電圧` AS DECIMAL(10,3))) AS 耐電圧_min, `Product`.`伝送速度（代表参考値）`, `Product`.`使用温度範囲（Max）`, `Product`.`フローティング機能`, `Product`.`振幅許容範囲`, `Product`.`2点接点`, `Product`.`ロック方式`, `Product`.`id` FROM `irisoweb2_test`.`products` AS `Product` LEFT JOIN `irisoweb2_test`.`series` AS `Series` ON (`Product`.`series_id` = `Series`.`id`) WHERE `Product`.`series_id` = 45 AND `Product`.`status` = '有効' AND `Product`.`販売分類` <> 'EOS' GROUP BY `Product`.`series_id` ORDER BY Product.販売分類 ASC, `Product`.`odr` DESC, `Product`.`id` DESC LIMIT 1	1	1	9
29	SELECT `Download`.`id`, `Download`.`type`, `Download`.`user_id`, `Download`.`series_id`, `Download`.`product_id`, `Download`.`field`, `Download`.`ip_address`, `Download`.`domain`, `Download`.`created`, `Download`.`modified` FROM `irisoweb2_test`.`downloads` AS `Download` WHERE `Download`.`product_id` = (362)	4	4	4
30	SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`model_id`, `Attachment`.`field_name`, `Attachment`.`file_name`, `Attachment`.`file_content_type`, `Attachment`.`file_size`, `Attachment`.`created`, `Attachment`.`modified` FROM `irisoweb2_test`.`attachments` AS `Attachment` WHERE `model` = 'Product' AND model_id = (362)	2	2	4
31	SELECT COUNT(*) AS count, MAX(CAST(`極数` AS SIGNED)) AS 極数_max, MIN(CAST(`極数` AS SIGNED)) AS 極数_min, MAX(CAST(`嵌合部ピッチ` AS DECIMAL(10,3))) AS 嵌合部ピッチ_max, MIN(CAST(`嵌合部ピッチ` AS DECIMAL(10,3))) AS 嵌合部ピッチ_min, `Product`.`嵌合形状`, `Product`.`基板実装方法`, MAX(CAST(`本体高さ` AS DECIMAL(10,3))) AS 本体高さ_max, MIN(CAST(`本体高さ` AS DECIMAL(10,3))) AS 本体高さ_min, MAX(CAST(`定格電圧（AC）` AS DECIMAL(10,3))) AS 定格電圧（AC）_max, MIN(CAST(`定格電圧（AC）` AS DECIMAL(10,3))) AS 定格電圧（AC）_min, MAX(CAST(`定格電圧（DC）` AS DECIMAL(10,3))) AS 定格電圧（DC）_max, MIN(CAST(`定格電圧（DC）` AS DECIMAL(10,3))) AS 定格電圧（DC）_min, MAX(CAST(`定格電流` AS DECIMAL(10,3))) AS 定格電流_max, MIN(CAST(`定格電流` AS DECIMAL(10,3))) AS 定格電流_min, MAX(CAST(`耐電圧` AS DECIMAL(10,3))) AS 耐電圧_max, MIN(CAST(`耐電圧` AS DECIMAL(10,3))) AS 耐電圧_min, `Product`.`伝送速度（代表参考値）`, `Product`.`使用温度範囲（Max）`, `Product`.`フローティング機能`, `Product`.`振幅許容範囲`, `Product`.`2点接点`, `Product`.`ロック方式`, `Product`.`id` FROM `irisoweb2_test`.`products` AS `Product` LEFT JOIN `irisoweb2_test`.`series` AS `Series` ON (`Product`.`series_id` = `Series`.`id`) WHERE `Product`.`series_id` = 43 AND `Product`.`status` = '有効' AND `Product`.`販売分類` <> 'EOS' GROUP BY `Product`.`series_id` ORDER BY Product.販売分類 ASC, `Product`.`odr` DESC, `Product`.`id` DESC LIMIT 1	1	1	9
32	SELECT `Download`.`id`, `Download`.`type`, `Download`.`user_id`, `Download`.`series_id`, `Download`.`product_id`, `Download`.`field`, `Download`.`ip_address`, `Download`.`domain`, `Download`.`created`, `Download`.`modified` FROM `irisoweb2_test`.`downloads` AS `Download` WHERE `Download`.`product_id` = (328)	7	7	4
33	SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`model_id`, `Attachment`.`field_name`, `Attachment`.`file_name`, `Attachment`.`file_content_type`, `Attachment`.`file_size`, `Attachment`.`created`, `Attachment`.`modified` FROM `irisoweb2_test`.`attachments` AS `Attachment` WHERE `model` = 'Product' AND model_id = (328)	3	3	3
34	SELECT COUNT(*) AS count, MAX(CAST(`極数` AS SIGNED)) AS 極数_max, MIN(CAST(`極数` AS SIGNED)) AS 極数_min, MAX(CAST(`嵌合部ピッチ` AS DECIMAL(10,3))) AS 嵌合部ピッチ_max, MIN(CAST(`嵌合部ピッチ` AS DECIMAL(10,3))) AS 嵌合部ピッチ_min, `Product`.`嵌合形状`, `Product`.`基板実装方法`, MAX(CAST(`本体高さ` AS DECIMAL(10,3))) AS 本体高さ_max, MIN(CAST(`本体高さ` AS DECIMAL(10,3))) AS 本体高さ_min, MAX(CAST(`定格電圧（AC）` AS DECIMAL(10,3))) AS 定格電圧（AC）_max, MIN(CAST(`定格電圧（AC）` AS DECIMAL(10,3))) AS 定格電圧（AC）_min, MAX(CAST(`定格電圧（DC）` AS DECIMAL(10,3))) AS 定格電圧（DC）_max, MIN(CAST(`定格電圧（DC）` AS DECIMAL(10,3))) AS 定格電圧（DC）_min, MAX(CAST(`定格電流` AS DECIMAL(10,3))) AS 定格電流_max, MIN(CAST(`定格電流` AS DECIMAL(10,3))) AS 定格電流_min, MAX(CAST(`耐電圧` AS DECIMAL(10,3))) AS 耐電圧_max, MIN(CAST(`耐電圧` AS DECIMAL(10,3))) AS 耐電圧_min, `Product`.`伝送速度（代表参考値）`, `Product`.`使用温度範囲（Max）`, `Product`.`フローティング機能`, `Product`.`振幅許容範囲`, `Product`.`2点接点`, `Product`.`ロック方式`, `Product`.`id` FROM `irisoweb2_test`.`products` AS `Product` LEFT JOIN `irisoweb2_test`.`series` AS `Series` ON (`Product`.`series_id` = `Series`.`id`) WHERE `Product`.`series_id` = 437 AND `Product`.`status` = '有効' AND `Product`.`販売分類` <> 'EOS' GROUP BY `Product`.`series_id` ORDER BY Product.販売分類 ASC, `Product`.`odr` DESC, `Product`.`id` DESC LIMIT 1	1	1	8
35	SELECT `Download`.`id`, `Download`.`type`, `Download`.`user_id`, `Download`.`series_id`, `Download`.`product_id`, `Download`.`field`, `Download`.`ip_address`, `Download`.`domain`, `Download`.`created`, `Download`.`modified` FROM `irisoweb2_test`.`downloads` AS `Download` WHERE `Download`.`product_id` = (8901)	0	0	4
36	SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`model_id`, `Attachment`.`field_name`, `Attachment`.`file_name`, `Attachment`.`file_content_type`, `Attachment`.`file_size`, `Attachment`.`created`, `Attachment`.`modified` FROM `irisoweb2_test`.`attachments` AS `Attachment` WHERE `model` = 'Product' AND model_id = (8901)	1	1	2
37	SELECT COUNT(*) AS count, MAX(CAST(`極数` AS SIGNED)) AS 極数_max, MIN(CAST(`極数` AS SIGNED)) AS 極数_min, MAX(CAST(`嵌合部ピッチ` AS DECIMAL(10,3))) AS 嵌合部ピッチ_max, MIN(CAST(`嵌合部ピッチ` AS DECIMAL(10,3))) AS 嵌合部ピッチ_min, `Product`.`嵌合形状`, `Product`.`基板実装方法`, MAX(CAST(`本体高さ` AS DECIMAL(10,3))) AS 本体高さ_max, MIN(CAST(`本体高さ` AS DECIMAL(10,3))) AS 本体高さ_min, MAX(CAST(`定格電圧（AC）` AS DECIMAL(10,3))) AS 定格電圧（AC）_max, MIN(CAST(`定格電圧（AC）` AS DECIMAL(10,3))) AS 定格電圧（AC）_min, MAX(CAST(`定格電圧（DC）` AS DECIMAL(10,3))) AS 定格電圧（DC）_max, MIN(CAST(`定格電圧（DC）` AS DECIMAL(10,3))) AS 定格電圧（DC）_min, MAX(CAST(`定格電流` AS DECIMAL(10,3))) AS 定格電流_max, MIN(CAST(`定格電流` AS DECIMAL(10,3))) AS 定格電流_min, MAX(CAST(`耐電圧` AS DECIMAL(10,3))) AS 耐電圧_max, MIN(CAST(`耐電圧` AS DECIMAL(10,3))) AS 耐電圧_min, `Product`.`伝送速度（代表参考値）`, `Product`.`使用温度範囲（Max）`, `Product`.`フローティング機能`, `Product`.`振幅許容範囲`, `Product`.`2点接点`, `Product`.`ロック方式`, `Product`.`id` FROM `irisoweb2_test`.`products` AS `Product` LEFT JOIN `irisoweb2_test`.`series` AS `Series` ON (`Product`.`series_id` = `Series`.`id`) WHERE `Product`.`series_id` = 434 AND `Product`.`status` = '有効' AND `Product`.`販売分類` <> 'EOS' GROUP BY `Product`.`series_id` ORDER BY Product.販売分類 ASC, `Product`.`odr` DESC, `Product`.`id` DESC LIMIT 1	1	1	7
38	SELECT `Download`.`id`, `Download`.`type`, `Download`.`user_id`, `Download`.`series_id`, `Download`.`product_id`, `Download`.`field`, `Download`.`ip_address`, `Download`.`domain`, `Download`.`created`, `Download`.`modified` FROM `irisoweb2_test`.`downloads` AS `Download` WHERE `Download`.`product_id` = (8893)	0	0	4
39	SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`model_id`, `Attachment`.`field_name`, `Attachment`.`file_name`, `Attachment`.`file_content_type`, `Attachment`.`file_size`, `Attachment`.`created`, `Attachment`.`modified` FROM `irisoweb2_test`.`attachments` AS `Attachment` WHERE `model` = 'Product' AND model_id = (8893)	2	2	4
40	SELECT COUNT(*) AS count, MAX(CAST(`極数` AS SIGNED)) AS 極数_max, MIN(CAST(`極数` AS SIGNED)) AS 極数_min, MAX(CAST(`嵌合部ピッチ` AS DECIMAL(10,3))) AS 嵌合部ピッチ_max, MIN(CAST(`嵌合部ピッチ` AS DECIMAL(10,3))) AS 嵌合部ピッチ_min, `Product`.`嵌合形状`, `Product`.`基板実装方法`, MAX(CAST(`本体高さ` AS DECIMAL(10,3))) AS 本体高さ_max, MIN(CAST(`本体高さ` AS DECIMAL(10,3))) AS 本体高さ_min, MAX(CAST(`定格電圧（AC）` AS DECIMAL(10,3))) AS 定格電圧（AC）_max, MIN(CAST(`定格電圧（AC）` AS DECIMAL(10,3))) AS 定格電圧（AC）_min, MAX(CAST(`定格電圧（DC）` AS DECIMAL(10,3))) AS 定格電圧（DC）_max, MIN(CAST(`定格電圧（DC）` AS DECIMAL(10,3))) AS 定格電圧（DC）_min, MAX(CAST(`定格電流` AS DECIMAL(10,3))) AS 定格電流_max, MIN(CAST(`定格電流` AS DECIMAL(10,3))) AS 定格電流_min, MAX(CAST(`耐電圧` AS DECIMAL(10,3))) AS 耐電圧_max, MIN(CAST(`耐電圧` AS DECIMAL(10,3))) AS 耐電圧_min, `Product`.`伝送速度（代表参考値）`, `Product`.`使用温度範囲（Max）`, `Product`.`フローティング機能`, `Product`.`振幅許容範囲`, `Product`.`2点接点`, `Product`.`ロック方式`, `Product`.`id` FROM `irisoweb2_test`.`products` AS `Product` LEFT JOIN `irisoweb2_test`.`series` AS `Series` ON (`Product`.`series_id` = `Series`.`id`) WHERE `Product`.`series_id` = 431 AND `Product`.`status` = '有効' AND `Product`.`販売分類` <> 'EOS' GROUP BY `Product`.`series_id` ORDER BY Product.販売分類 ASC, `Product`.`odr` DESC, `Product`.`id` DESC LIMIT 1	1	1	8
41	SELECT `Download`.`id`, `Download`.`type`, `Download`.`user_id`, `Download`.`series_id`, `Download`.`product_id`, `Download`.`field`, `Download`.`ip_address`, `Download`.`domain`, `Download`.`created`, `Download`.`modified` FROM `irisoweb2_test`.`downloads` AS `Download` WHERE `Download`.`product_id` = (8869)	0	0	4
42	SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`model_id`, `Attachment`.`field_name`, `Attachment`.`file_name`, `Attachment`.`file_content_type`, `Attachment`.`file_size`, `Attachment`.`created`, `Attachment`.`modified` FROM `irisoweb2_test`.`attachments` AS `Attachment` WHERE `model` = 'Product' AND model_id = (8869)	1	1	3
43	SELECT COUNT(*) AS count, MAX(CAST(`極数` AS SIGNED)) AS 極数_max, MIN(CAST(`極数` AS SIGNED)) AS 極数_min, MAX(CAST(`嵌合部ピッチ` AS DECIMAL(10,3))) AS 嵌合部ピッチ_max, MIN(CAST(`嵌合部ピッチ` AS DECIMAL(10,3))) AS 嵌合部ピッチ_min, `Product`.`嵌合形状`, `Product`.`基板実装方法`, MAX(CAST(`本体高さ` AS DECIMAL(10,3))) AS 本体高さ_max, MIN(CAST(`本体高さ` AS DECIMAL(10,3))) AS 本体高さ_min, MAX(CAST(`定格電圧（AC）` AS DECIMAL(10,3))) AS 定格電圧（AC）_max, MIN(CAST(`定格電圧（AC）` AS DECIMAL(10,3))) AS 定格電圧（AC）_min, MAX(CAST(`定格電圧（DC）` AS DECIMAL(10,3))) AS 定格電圧（DC）_max, MIN(CAST(`定格電圧（DC）` AS DECIMAL(10,3))) AS 定格電圧（DC）_min, MAX(CAST(`定格電流` AS DECIMAL(10,3))) AS 定格電流_max, MIN(CAST(`定格電流` AS DECIMAL(10,3))) AS 定格電流_min, MAX(CAST(`耐電圧` AS DECIMAL(10,3))) AS 耐電圧_max, MIN(CAST(`耐電圧` AS DECIMAL(10,3))) AS 耐電圧_min, `Product`.`伝送速度（代表参考値）`, `Product`.`使用温度範囲（Max）`, `Product`.`フローティング機能`, `Product`.`振幅許容範囲`, `Product`.`2点接点`, `Product`.`ロック方式`, `Product`.`id` FROM `irisoweb2_test`.`products` AS `Product` LEFT JOIN `irisoweb2_test`.`series` AS `Series` ON (`Product`.`series_id` = `Series`.`id`) WHERE `Product`.`series_id` = 429 AND `Product`.`status` = '有効' AND `Product`.`販売分類` <> 'EOS' GROUP BY `Product`.`series_id` ORDER BY Product.販売分類 ASC, `Product`.`odr` DESC, `Product`.`id` DESC LIMIT 1	1	1	7
44	SELECT `Download`.`id`, `Download`.`type`, `Download`.`user_id`, `Download`.`series_id`, `Download`.`product_id`, `Download`.`field`, `Download`.`ip_address`, `Download`.`domain`, `Download`.`created`, `Download`.`modified` FROM `irisoweb2_test`.`downloads` AS `Download` WHERE `Download`.`product_id` = (8838)	0	0	4
45	SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`model_id`, `Attachment`.`field_name`, `Attachment`.`file_name`, `Attachment`.`file_content_type`, `Attachment`.`file_size`, `Attachment`.`created`, `Attachment`.`modified` FROM `irisoweb2_test`.`attachments` AS `Attachment` WHERE `model` = 'Product' AND model_id = (8838)	2	2	2
46	SELECT COUNT(*) AS count, MAX(CAST(`極数` AS SIGNED)) AS 極数_max, MIN(CAST(`極数` AS SIGNED)) AS 極数_min, MAX(CAST(`嵌合部ピッチ` AS DECIMAL(10,3))) AS 嵌合部ピッチ_max, MIN(CAST(`嵌合部ピッチ` AS DECIMAL(10,3))) AS 嵌合部ピッチ_min, `Product`.`嵌合形状`, `Product`.`基板実装方法`, MAX(CAST(`本体高さ` AS DECIMAL(10,3))) AS 本体高さ_max, MIN(CAST(`本体高さ` AS DECIMAL(10,3))) AS 本体高さ_min, MAX(CAST(`定格電圧（AC）` AS DECIMAL(10,3))) AS 定格電圧（AC）_max, MIN(CAST(`定格電圧（AC）` AS DECIMAL(10,3))) AS 定格電圧（AC）_min, MAX(CAST(`定格電圧（DC）` AS DECIMAL(10,3))) AS 定格電圧（DC）_max, MIN(CAST(`定格電圧（DC）` AS DECIMAL(10,3))) AS 定格電圧（DC）_min, MAX(CAST(`定格電流` AS DECIMAL(10,3))) AS 定格電流_max, MIN(CAST(`定格電流` AS DECIMAL(10,3))) AS 定格電流_min, MAX(CAST(`耐電圧` AS DECIMAL(10,3))) AS 耐電圧_max, MIN(CAST(`耐電圧` AS DECIMAL(10,3))) AS 耐電圧_min, `Product`.`伝送速度（代表参考値）`, `Product`.`使用温度範囲（Max）`, `Product`.`フローティング機能`, `Product`.`振幅許容範囲`, `Product`.`2点接点`, `Product`.`ロック方式`, `Product`.`id` FROM `irisoweb2_test`.`products` AS `Product` LEFT JOIN `irisoweb2_test`.`series` AS `Series` ON (`Product`.`series_id` = `Series`.`id`) WHERE `Product`.`series_id` = 428 AND `Product`.`status` = '有効' AND `Product`.`販売分類` <> 'EOS' GROUP BY `Product`.`series_id` ORDER BY Product.販売分類 ASC, `Product`.`odr` DESC, `Product`.`id` DESC LIMIT 1	1	1	7
47	SELECT `Download`.`id`, `Download`.`type`, `Download`.`user_id`, `Download`.`series_id`, `Download`.`product_id`, `Download`.`field`, `Download`.`ip_address`, `Download`.`domain`, `Download`.`created`, `Download`.`modified` FROM `irisoweb2_test`.`downloads` AS `Download` WHERE `Download`.`product_id` = (8705)	0	0	5
48	SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`model_id`, `Attachment`.`field_name`, `Attachment`.`file_name`, `Attachment`.`file_content_type`, `Attachment`.`file_size`, `Attachment`.`created`, `Attachment`.`modified` FROM `irisoweb2_test`.`attachments` AS `Attachment` WHERE `model` = 'Product' AND model_id = (8705)	2	2	2
49	SELECT COUNT(*) AS count, MAX(CAST(`極数` AS SIGNED)) AS 極数_max, MIN(CAST(`極数` AS SIGNED)) AS 極数_min, MAX(CAST(`嵌合部ピッチ` AS DECIMAL(10,3))) AS 嵌合部ピッチ_max, MIN(CAST(`嵌合部ピッチ` AS DECIMAL(10,3))) AS 嵌合部ピッチ_min, `Product`.`嵌合形状`, `Product`.`基板実装方法`, MAX(CAST(`本体高さ` AS DECIMAL(10,3))) AS 本体高さ_max, MIN(CAST(`本体高さ` AS DECIMAL(10,3))) AS 本体高さ_min, MAX(CAST(`定格電圧（AC）` AS DECIMAL(10,3))) AS 定格電圧（AC）_max, MIN(CAST(`定格電圧（AC）` AS DECIMAL(10,3))) AS 定格電圧（AC）_min, MAX(CAST(`定格電圧（DC）` AS DECIMAL(10,3))) AS 定格電圧（DC）_max, MIN(CAST(`定格電圧（DC）` AS DECIMAL(10,3))) AS 定格電圧（DC）_min, MAX(CAST(`定格電流` AS DECIMAL(10,3))) AS 定格電流_max, MIN(CAST(`定格電流` AS DECIMAL(10,3))) AS 定格電流_min, MAX(CAST(`耐電圧` AS DECIMAL(10,3))) AS 耐電圧_max, MIN(CAST(`耐電圧` AS DECIMAL(10,3))) AS 耐電圧_min, `Product`.`伝送速度（代表参考値）`, `Product`.`使用温度範囲（Max）`, `Product`.`フローティング機能`, `Product`.`振幅許容範囲`, `Product`.`2点接点`, `Product`.`ロック方式`, `Product`.`id` FROM `irisoweb2_test`.`products` AS `Product` LEFT JOIN `irisoweb2_test`.`series` AS `Series` ON (`Product`.`series_id` = `Series`.`id`) WHERE `Product`.`series_id` = 427 AND `Product`.`status` = '有効' AND `Product`.`販売分類` <> 'EOS' GROUP BY `Product`.`series_id` ORDER BY Product.販売分類 ASC, `Product`.`odr` DESC, `Product`.`id` DESC LIMIT 1	1	1	6
50	SELECT `Download`.`id`, `Download`.`type`, `Download`.`user_id`, `Download`.`series_id`, `Download`.`product_id`, `Download`.`field`, `Download`.`ip_address`, `Download`.`domain`, `Download`.`created`, `Download`.`modified` FROM `irisoweb2_test`.`downloads` AS `Download` WHERE `Download`.`product_id` = (8625)	0	0	4
51	SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`model_id`, `Attachment`.`field_name`, `Attachment`.`file_name`, `Attachment`.`file_content_type`, `Attachment`.`file_size`, `Attachment`.`created`, `Attachment`.`modified` FROM `irisoweb2_test`.`attachments` AS `Attachment` WHERE `model` = 'Product' AND model_id = (8625)	2	2	3
52	SELECT COUNT(*) AS count, MAX(CAST(`極数` AS SIGNED)) AS 極数_max, MIN(CAST(`極数` AS SIGNED)) AS 極数_min, MAX(CAST(`嵌合部ピッチ` AS DECIMAL(10,3))) AS 嵌合部ピッチ_max, MIN(CAST(`嵌合部ピッチ` AS DECIMAL(10,3))) AS 嵌合部ピッチ_min, `Product`.`嵌合形状`, `Product`.`基板実装方法`, MAX(CAST(`本体高さ` AS DECIMAL(10,3))) AS 本体高さ_max, MIN(CAST(`本体高さ` AS DECIMAL(10,3))) AS 本体高さ_min, MAX(CAST(`定格電圧（AC）` AS DECIMAL(10,3))) AS 定格電圧（AC）_max, MIN(CAST(`定格電圧（AC）` AS DECIMAL(10,3))) AS 定格電圧（AC）_min, MAX(CAST(`定格電圧（DC）` AS DECIMAL(10,3))) AS 定格電圧（DC）_max, MIN(CAST(`定格電圧（DC）` AS DECIMAL(10,3))) AS 定格電圧（DC）_min, MAX(CAST(`定格電流` AS DECIMAL(10,3))) AS 定格電流_max, MIN(CAST(`定格電流` AS DECIMAL(10,3))) AS 定格電流_min, MAX(CAST(`耐電圧` AS DECIMAL(10,3))) AS 耐電圧_max, MIN(CAST(`耐電圧` AS DECIMAL(10,3))) AS 耐電圧_min, `Product`.`伝送速度（代表参考値）`, `Product`.`使用温度範囲（Max）`, `Product`.`フローティング機能`, `Product`.`振幅許容範囲`, `Product`.`2点接点`, `Product`.`ロック方式`, `Product`.`id` FROM `irisoweb2_test`.`products` AS `Product` LEFT JOIN `irisoweb2_test`.`series` AS `Series` ON (`Product`.`series_id` = `Series`.`id`) WHERE `Product`.`series_id` = 426 AND `Product`.`status` = '有効' AND `Product`.`販売分類` <> 'EOS' GROUP BY `Product`.`series_id` ORDER BY Product.販売分類 ASC, `Product`.`odr` DESC, `Product`.`id` DESC LIMIT 1	1	1	7
53	SELECT `Download`.`id`, `Download`.`type`, `Download`.`user_id`, `Download`.`series_id`, `Download`.`product_id`, `Download`.`field`, `Download`.`ip_address`, `Download`.`domain`, `Download`.`created`, `Download`.`modified` FROM `irisoweb2_test`.`downloads` AS `Download` WHERE `Download`.`product_id` = (8534)	0	0	4
54	SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`model_id`, `Attachment`.`field_name`, `Attachment`.`file_name`, `Attachment`.`file_content_type`, `Attachment`.`file_size`, `Attachment`.`created`, `Attachment`.`modified` FROM `irisoweb2_test`.`attachments` AS `Attachment` WHERE `model` = 'Product' AND model_id = (8534)	3	3	3
55	SELECT COUNT(*) AS count, MAX(CAST(`極数` AS SIGNED)) AS 極数_max, MIN(CAST(`極数` AS SIGNED)) AS 極数_min, MAX(CAST(`嵌合部ピッチ` AS DECIMAL(10,3))) AS 嵌合部ピッチ_max, MIN(CAST(`嵌合部ピッチ` AS DECIMAL(10,3))) AS 嵌合部ピッチ_min, `Product`.`嵌合形状`, `Product`.`基板実装方法`, MAX(CAST(`本体高さ` AS DECIMAL(10,3))) AS 本体高さ_max, MIN(CAST(`本体高さ` AS DECIMAL(10,3))) AS 本体高さ_min, MAX(CAST(`定格電圧（AC）` AS DECIMAL(10,3))) AS 定格電圧（AC）_max, MIN(CAST(`定格電圧（AC）` AS DECIMAL(10,3))) AS 定格電圧（AC）_min, MAX(CAST(`定格電圧（DC）` AS DECIMAL(10,3))) AS 定格電圧（DC）_max, MIN(CAST(`定格電圧（DC）` AS DECIMAL(10,3))) AS 定格電圧（DC）_min, MAX(CAST(`定格電流` AS DECIMAL(10,3))) AS 定格電流_max, MIN(CAST(`定格電流` AS DECIMAL(10,3))) AS 定格電流_min, MAX(CAST(`耐電圧` AS DECIMAL(10,3))) AS 耐電圧_max, MIN(CAST(`耐電圧` AS DECIMAL(10,3))) AS 耐電圧_min, `Product`.`伝送速度（代表参考値）`, `Product`.`使用温度範囲（Max）`, `Product`.`フローティング機能`, `Product`.`振幅許容範囲`, `Product`.`2点接点`, `Product`.`ロック方式`, `Product`.`id` FROM `irisoweb2_test`.`products` AS `Product` LEFT JOIN `irisoweb2_test`.`series` AS `Series` ON (`Product`.`series_id` = `Series`.`id`) WHERE `Product`.`series_id` = 421 AND `Product`.`status` = '有効' AND `Product`.`販売分類` <> 'EOS' GROUP BY `Product`.`series_id` ORDER BY Product.販売分類 ASC, `Product`.`odr` DESC, `Product`.`id` DESC LIMIT 1	1	1	7
56	SELECT `Download`.`id`, `Download`.`type`, `Download`.`user_id`, `Download`.`series_id`, `Download`.`product_id`, `Download`.`field`, `Download`.`ip_address`, `Download`.`domain`, `Download`.`created`, `Download`.`modified` FROM `irisoweb2_test`.`downloads` AS `Download` WHERE `Download`.`product_id` = (8321)	1	1	4
57	SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`model_id`, `Attachment`.`field_name`, `Attachment`.`file_name`, `Attachment`.`file_content_type`, `Attachment`.`file_size`, `Attachment`.`created`, `Attachment`.`modified` FROM `irisoweb2_test`.`attachments` AS `Attachment` WHERE `model` = 'Product' AND model_id = (8321)	2	2	3
58	SELECT COUNT(*) AS count, MAX(CAST(`極数` AS SIGNED)) AS 極数_max, MIN(CAST(`極数` AS SIGNED)) AS 極数_min, MAX(CAST(`嵌合部ピッチ` AS DECIMAL(10,3))) AS 嵌合部ピッチ_max, MIN(CAST(`嵌合部ピッチ` AS DECIMAL(10,3))) AS 嵌合部ピッチ_min, `Product`.`嵌合形状`, `Product`.`基板実装方法`, MAX(CAST(`本体高さ` AS DECIMAL(10,3))) AS 本体高さ_max, MIN(CAST(`本体高さ` AS DECIMAL(10,3))) AS 本体高さ_min, MAX(CAST(`定格電圧（AC）` AS DECIMAL(10,3))) AS 定格電圧（AC）_max, MIN(CAST(`定格電圧（AC）` AS DECIMAL(10,3))) AS 定格電圧（AC）_min, MAX(CAST(`定格電圧（DC）` AS DECIMAL(10,3))) AS 定格電圧（DC）_max, MIN(CAST(`定格電圧（DC）` AS DECIMAL(10,3))) AS 定格電圧（DC）_min, MAX(CAST(`定格電流` AS DECIMAL(10,3))) AS 定格電流_max, MIN(CAST(`定格電流` AS DECIMAL(10,3))) AS 定格電流_min, MAX(CAST(`耐電圧` AS DECIMAL(10,3))) AS 耐電圧_max, MIN(CAST(`耐電圧` AS DECIMAL(10,3))) AS 耐電圧_min, `Product`.`伝送速度（代表参考値）`, `Product`.`使用温度範囲（Max）`, `Product`.`フローティング機能`, `Product`.`振幅許容範囲`, `Product`.`2点接点`, `Product`.`ロック方式`, `Product`.`id` FROM `irisoweb2_test`.`products` AS `Product` LEFT JOIN `irisoweb2_test`.`series` AS `Series` ON (`Product`.`series_id` = `Series`.`id`) WHERE `Product`.`series_id` = 420 AND `Product`.`status` = '有効' AND `Product`.`販売分類` <> 'EOS' GROUP BY `Product`.`series_id` ORDER BY Product.販売分類 ASC, `Product`.`odr` DESC, `Product`.`id` DESC LIMIT 1	1	1	7
59	SELECT `Download`.`id`, `Download`.`type`, `Download`.`user_id`, `Download`.`series_id`, `Download`.`product_id`, `Download`.`field`, `Download`.`ip_address`, `Download`.`domain`, `Download`.`created`, `Download`.`modified` FROM `irisoweb2_test`.`downloads` AS `Download` WHERE `Download`.`product_id` = (8206)	3	3	4
60	SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`model_id`, `Attachment`.`field_name`, `Attachment`.`file_name`, `Attachment`.`file_content_type`, `Attachment`.`file_size`, `Attachment`.`created`, `Attachment`.`modified` FROM `irisoweb2_test`.`attachments` AS `Attachment` WHERE `model` = 'Product' AND model_id = (8206)	3	3	2
61	SELECT COUNT(*) AS count, MAX(CAST(`極数` AS SIGNED)) AS 極数_max, MIN(CAST(`極数` AS SIGNED)) AS 極数_min, MAX(CAST(`嵌合部ピッチ` AS DECIMAL(10,3))) AS 嵌合部ピッチ_max, MIN(CAST(`嵌合部ピッチ` AS DECIMAL(10,3))) AS 嵌合部ピッチ_min, `Product`.`嵌合形状`, `Product`.`基板実装方法`, MAX(CAST(`本体高さ` AS DECIMAL(10,3))) AS 本体高さ_max, MIN(CAST(`本体高さ` AS DECIMAL(10,3))) AS 本体高さ_min, MAX(CAST(`定格電圧（AC）` AS DECIMAL(10,3))) AS 定格電圧（AC）_max, MIN(CAST(`定格電圧（AC）` AS DECIMAL(10,3))) AS 定格電圧（AC）_min, MAX(CAST(`定格電圧（DC）` AS DECIMAL(10,3))) AS 定格電圧（DC）_max, MIN(CAST(`定格電圧（DC）` AS DECIMAL(10,3))) AS 定格電圧（DC）_min, MAX(CAST(`定格電流` AS DECIMAL(10,3))) AS 定格電流_max, MIN(CAST(`定格電流` AS DECIMAL(10,3))) AS 定格電流_min, MAX(CAST(`耐電圧` AS DECIMAL(10,3))) AS 耐電圧_max, MIN(CAST(`耐電圧` AS DECIMAL(10,3))) AS 耐電圧_min, `Product`.`伝送速度（代表参考値）`, `Product`.`使用温度範囲（Max）`, `Product`.`フローティング機能`, `Product`.`振幅許容範囲`, `Product`.`2点接点`, `Product`.`ロック方式`, `Product`.`id` FROM `irisoweb2_test`.`products` AS `Product` LEFT JOIN `irisoweb2_test`.`series` AS `Series` ON (`Product`.`series_id` = `Series`.`id`) WHERE `Product`.`series_id` = 419 AND `Product`.`status` = '有効' AND `Product`.`販売分類` <> 'EOS' GROUP BY `Product`.`series_id` ORDER BY Product.販売分類 ASC, `Product`.`odr` DESC, `Product`.`id` DESC LIMIT 1	1	1	8
62	SELECT `Download`.`id`, `Download`.`type`, `Download`.`user_id`, `Download`.`series_id`, `Download`.`product_id`, `Download`.`field`, `Download`.`ip_address`, `Download`.`domain`, `Download`.`created`, `Download`.`modified` FROM `irisoweb2_test`.`downloads` AS `Download` WHERE `Download`.`product_id` = (8117)	5	5	4
63	SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`model_id`, `Attachment`.`field_name`, `Attachment`.`file_name`, `Attachment`.`file_content_type`, `Attachment`.`file_size`, `Attachment`.`created`, `Attachment`.`modified` FROM `irisoweb2_test`.`attachments` AS `Attachment` WHERE `model` = 'Product' AND model_id = (8117)	3	3	3
64	SELECT COUNT(*) AS count, MAX(CAST(`極数` AS SIGNED)) AS 極数_max, MIN(CAST(`極数` AS SIGNED)) AS 極数_min, MAX(CAST(`嵌合部ピッチ` AS DECIMAL(10,3))) AS 嵌合部ピッチ_max, MIN(CAST(`嵌合部ピッチ` AS DECIMAL(10,3))) AS 嵌合部ピッチ_min, `Product`.`嵌合形状`, `Product`.`基板実装方法`, MAX(CAST(`本体高さ` AS DECIMAL(10,3))) AS 本体高さ_max, MIN(CAST(`本体高さ` AS DECIMAL(10,3))) AS 本体高さ_min, MAX(CAST(`定格電圧（AC）` AS DECIMAL(10,3))) AS 定格電圧（AC）_max, MIN(CAST(`定格電圧（AC）` AS DECIMAL(10,3))) AS 定格電圧（AC）_min, MAX(CAST(`定格電圧（DC）` AS DECIMAL(10,3))) AS 定格電圧（DC）_max, MIN(CAST(`定格電圧（DC）` AS DECIMAL(10,3))) AS 定格電圧（DC）_min, MAX(CAST(`定格電流` AS DECIMAL(10,3))) AS 定格電流_max, MIN(CAST(`定格電流` AS DECIMAL(10,3))) AS 定格電流_min, MAX(CAST(`耐電圧` AS DECIMAL(10,3))) AS 耐電圧_max, MIN(CAST(`耐電圧` AS DECIMAL(10,3))) AS 耐電圧_min, `Product`.`伝送速度（代表参考値）`, `Product`.`使用温度範囲（Max）`, `Product`.`フローティング機能`, `Product`.`振幅許容範囲`, `Product`.`2点接点`, `Product`.`ロック方式`, `Product`.`id` FROM `irisoweb2_test`.`products` AS `Product` LEFT JOIN `irisoweb2_test`.`series` AS `Series` ON (`Product`.`series_id` = `Series`.`id`) WHERE `Product`.`series_id` = 417 AND `Product`.`status` = '有効' AND `Product`.`販売分類` <> 'EOS' GROUP BY `Product`.`series_id` ORDER BY Product.販売分類 ASC, `Product`.`odr` DESC, `Product`.`id` DESC LIMIT 1	1	1	8
65	SELECT `Download`.`id`, `Download`.`type`, `Download`.`user_id`, `Download`.`series_id`, `Download`.`product_id`, `Download`.`field`, `Download`.`ip_address`, `Download`.`domain`, `Download`.`created`, `Download`.`modified` FROM `irisoweb2_test`.`downloads` AS `Download` WHERE `Download`.`product_id` = (8087)	0	0	3
66	SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`model_id`, `Attachment`.`field_name`, `Attachment`.`file_name`, `Attachment`.`file_content_type`, `Attachment`.`file_size`, `Attachment`.`created`, `Attachment`.`modified` FROM `irisoweb2_test`.`attachments` AS `Attachment` WHERE `model` = 'Product' AND model_id = (8087)	2	2	2
67	SELECT COUNT(*) AS count, MAX(CAST(`極数` AS SIGNED)) AS 極数_max, MIN(CAST(`極数` AS SIGNED)) AS 極数_min, MAX(CAST(`嵌合部ピッチ` AS DECIMAL(10,3))) AS 嵌合部ピッチ_max, MIN(CAST(`嵌合部ピッチ` AS DECIMAL(10,3))) AS 嵌合部ピッチ_min, `Product`.`嵌合形状`, `Product`.`基板実装方法`, MAX(CAST(`本体高さ` AS DECIMAL(10,3))) AS 本体高さ_max, MIN(CAST(`本体高さ` AS DECIMAL(10,3))) AS 本体高さ_min, MAX(CAST(`定格電圧（AC）` AS DECIMAL(10,3))) AS 定格電圧（AC）_max, MIN(CAST(`定格電圧（AC）` AS DECIMAL(10,3))) AS 定格電圧（AC）_min, MAX(CAST(`定格電圧（DC）` AS DECIMAL(10,3))) AS 定格電圧（DC）_max, MIN(CAST(`定格電圧（DC）` AS DECIMAL(10,3))) AS 定格電圧（DC）_min, MAX(CAST(`定格電流` AS DECIMAL(10,3))) AS 定格電流_max, MIN(CAST(`定格電流` AS DECIMAL(10,3))) AS 定格電流_min, MAX(CAST(`耐電圧` AS DECIMAL(10,3))) AS 耐電圧_max, MIN(CAST(`耐電圧` AS DECIMAL(10,3))) AS 耐電圧_min, `Product`.`伝送速度（代表参考値）`, `Product`.`使用温度範囲（Max）`, `Product`.`フローティング機能`, `Product`.`振幅許容範囲`, `Product`.`2点接点`, `Product`.`ロック方式`, `Product`.`id` FROM `irisoweb2_test`.`products` AS `Product` LEFT JOIN `irisoweb2_test`.`series` AS `Series` ON (`Product`.`series_id` = `Series`.`id`) WHERE `Product`.`series_id` = 415 AND `Product`.`status` = '有効' AND `Product`.`販売分類` <> 'EOS' GROUP BY `Product`.`series_id` ORDER BY Product.販売分類 ASC, `Product`.`odr` DESC, `Product`.`id` DESC LIMIT 1	1	1	7
68	SELECT `Download`.`id`, `Download`.`type`, `Download`.`user_id`, `Download`.`series_id`, `Download`.`product_id`, `Download`.`field`, `Download`.`ip_address`, `Download`.`domain`, `Download`.`created`, `Download`.`modified` FROM `irisoweb2_test`.`downloads` AS `Download` WHERE `Download`.`product_id` = (7931)	0	0	4
69	SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`model_id`, `Attachment`.`field_name`, `Attachment`.`file_name`, `Attachment`.`file_content_type`, `Attachment`.`file_size`, `Attachment`.`created`, `Attachment`.`modified` FROM `irisoweb2_test`.`attachments` AS `Attachment` WHERE `model` = 'Product' AND model_id = (7931)	3	3	3
70	SELECT COUNT(*) AS count, MAX(CAST(`極数` AS SIGNED)) AS 極数_max, MIN(CAST(`極数` AS SIGNED)) AS 極数_min, MAX(CAST(`嵌合部ピッチ` AS DECIMAL(10,3))) AS 嵌合部ピッチ_max, MIN(CAST(`嵌合部ピッチ` AS DECIMAL(10,3))) AS 嵌合部ピッチ_min, `Product`.`嵌合形状`, `Product`.`基板実装方法`, MAX(CAST(`本体高さ` AS DECIMAL(10,3))) AS 本体高さ_max, MIN(CAST(`本体高さ` AS DECIMAL(10,3))) AS 本体高さ_min, MAX(CAST(`定格電圧（AC）` AS DECIMAL(10,3))) AS 定格電圧（AC）_max, MIN(CAST(`定格電圧（AC）` AS DECIMAL(10,3))) AS 定格電圧（AC）_min, MAX(CAST(`定格電圧（DC）` AS DECIMAL(10,3))) AS 定格電圧（DC）_max, MIN(CAST(`定格電圧（DC）` AS DECIMAL(10,3))) AS 定格電圧（DC）_min, MAX(CAST(`定格電流` AS DECIMAL(10,3))) AS 定格電流_max, MIN(CAST(`定格電流` AS DECIMAL(10,3))) AS 定格電流_min, MAX(CAST(`耐電圧` AS DECIMAL(10,3))) AS 耐電圧_max, MIN(CAST(`耐電圧` AS DECIMAL(10,3))) AS 耐電圧_min, `Product`.`伝送速度（代表参考値）`, `Product`.`使用温度範囲（Max）`, `Product`.`フローティング機能`, `Product`.`振幅許容範囲`, `Product`.`2点接点`, `Product`.`ロック方式`, `Product`.`id` FROM `irisoweb2_test`.`products` AS `Product` LEFT JOIN `irisoweb2_test`.`series` AS `Series` ON (`Product`.`series_id` = `Series`.`id`) WHERE `Product`.`series_id` = 414 AND `Product`.`status` = '有効' AND `Product`.`販売分類` <> 'EOS' GROUP BY `Product`.`series_id` ORDER BY Product.販売分類 ASC, `Product`.`odr` DESC, `Product`.`id` DESC LIMIT 1	1	1	8
71	SELECT `Download`.`id`, `Download`.`type`, `Download`.`user_id`, `Download`.`series_id`, `Download`.`product_id`, `Download`.`field`, `Download`.`ip_address`, `Download`.`domain`, `Download`.`created`, `Download`.`modified` FROM `irisoweb2_test`.`downloads` AS `Download` WHERE `Download`.`product_id` = (7711)	1	1	4
72	SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`model_id`, `Attachment`.`field_name`, `Attachment`.`file_name`, `Attachment`.`file_content_type`, `Attachment`.`file_size`, `Attachment`.`created`, `Attachment`.`modified` FROM `irisoweb2_test`.`attachments` AS `Attachment` WHERE `model` = 'Product' AND model_id = (7711)	2	2	3
73	SELECT COUNT(*) AS count, MAX(CAST(`極数` AS SIGNED)) AS 極数_max, MIN(CAST(`極数` AS SIGNED)) AS 極数_min, MAX(CAST(`嵌合部ピッチ` AS DECIMAL(10,3))) AS 嵌合部ピッチ_max, MIN(CAST(`嵌合部ピッチ` AS DECIMAL(10,3))) AS 嵌合部ピッチ_min, `Product`.`嵌合形状`, `Product`.`基板実装方法`, MAX(CAST(`本体高さ` AS DECIMAL(10,3))) AS 本体高さ_max, MIN(CAST(`本体高さ` AS DECIMAL(10,3))) AS 本体高さ_min, MAX(CAST(`定格電圧（AC）` AS DECIMAL(10,3))) AS 定格電圧（AC）_max, MIN(CAST(`定格電圧（AC）` AS DECIMAL(10,3))) AS 定格電圧（AC）_min, MAX(CAST(`定格電圧（DC）` AS DECIMAL(10,3))) AS 定格電圧（DC）_max, MIN(CAST(`定格電圧（DC）` AS DECIMAL(10,3))) AS 定格電圧（DC）_min, MAX(CAST(`定格電流` AS DECIMAL(10,3))) AS 定格電流_max, MIN(CAST(`定格電流` AS DECIMAL(10,3))) AS 定格電流_min, MAX(CAST(`耐電圧` AS DECIMAL(10,3))) AS 耐電圧_max, MIN(CAST(`耐電圧` AS DECIMAL(10,3))) AS 耐電圧_min, `Product`.`伝送速度（代表参考値）`, `Product`.`使用温度範囲（Max）`, `Product`.`フローティング機能`, `Product`.`振幅許容範囲`, `Product`.`2点接点`, `Product`.`ロック方式`, `Product`.`id` FROM `irisoweb2_test`.`products` AS `Product` LEFT JOIN `irisoweb2_test`.`series` AS `Series` ON (`Product`.`series_id` = `Series`.`id`) WHERE `Product`.`series_id` = 413 AND `Product`.`status` = '有効' AND `Product`.`販売分類` <> 'EOS' GROUP BY `Product`.`series_id` ORDER BY Product.販売分類 ASC, `Product`.`odr` DESC, `Product`.`id` DESC LIMIT 1	1	1	7
74	SELECT `Download`.`id`, `Download`.`type`, `Download`.`user_id`, `Download`.`series_id`, `Download`.`product_id`, `Download`.`field`, `Download`.`ip_address`, `Download`.`domain`, `Download`.`created`, `Download`.`modified` FROM `irisoweb2_test`.`downloads` AS `Download` WHERE `Download`.`product_id` = (7693)	0	0	3
75	SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`model_id`, `Attachment`.`field_name`, `Attachment`.`file_name`, `Attachment`.`file_content_type`, `Attachment`.`file_size`, `Attachment`.`created`, `Attachment`.`modified` FROM `irisoweb2_test`.`attachments` AS `Attachment` WHERE `model` = 'Product' AND model_id = (7693)	3	3	2
76	SELECT `Category`.`id`, `Category`.`status`, `Category`.`name`, `Category`.`name_en`, `Category`.`name_zh`, `Category`.`name_ko`, `Category`.`detail`, `Category`.`detail_en`, `Category`.`detail_zh`, `Category`.`detail_ko`, `Category`.`title`, `Category`.`title_en`, `Category`.`title_zh`, `Category`.`title_ko`, `Category`.`description`, `Category`.`description_en`, `Category`.`description_zh`, `Category`.`description_ko`, `Category`.`meta_keyword`, `Category`.`meta_keyword_en`, `Category`.`meta_keyword_zh`, `Category`.`meta_keyword_ko`, `Category`.`use_fields`, `Category`.`url`, `Category`.`header_title1`, `Category`.`header_title2`, `Category`.`header_title3`, `Category`.`header_title4`, `Category`.`header_url1`, `Category`.`header_url2`, `Category`.`header_url3`, `Category`.`header_url4`, `Category`.`odr`, `Category`.`created`, `Category`.`modified`, (CONCAT_WS( " ", IFNULL(`Category`.`name`, ""), IFNULL(`Category`.`name_en`, ""), IFNULL(`Category`.`name_zh`, ""), IFNULL(`Category`.`name_ko`, ""), IFNULL(`Category`.`detail`, ""), IFNULL(`Category`.`detail_en`, ""), IFNULL(`Category`.`detail_zh`, ""), IFNULL(`Category`.`detail_ko`, ""), IFNULL(`Category`.`url`, ""), IFNULL(`Category`.`header_title1`, ""), IFNULL(`Category`.`header_title2`, ""), IFNULL(`Category`.`header_title3`, ""), IFNULL(`Category`.`header_title4`, ""))) AS `Category__keyword` FROM `irisoweb2_test`.`categories` AS `Category` WHERE `Category`.`status` = '有効'	9	9	0
77	SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`model_id`, `Attachment`.`field_name`, `Attachment`.`file_name`, `Attachment`.`file_content_type`, `Attachment`.`file_size`, `Attachment`.`created`, `Attachment`.`modified` FROM `irisoweb2_test`.`attachments` AS `Attachment` WHERE `model` = 'Category' AND `model_id` IN (1, 2, 3, 4, 5, 6, 7, 8, 9)	10	10	3
78	show columns from `products`	108	108	1
79	SELECT `AddField`.`id`, `AddField`.`name` FROM `irisoweb2_test`.`add_fields` AS `AddField` WHERE 1 = 1 ORDER BY `AddField`.`odr` ASC	48	48	0
80	SELECT `Category`.`id`, `Category`.`name_en` FROM `irisoweb2_test`.`categories` AS `Category` WHERE 1 = 1 ORDER BY `Category`.`odr` DESC, `Category`.`id` DESC	9	9	0
81	SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`model_id`, `Attachment`.`field_name`, `Attachment`.`file_name`, `Attachment`.`file_content_type`, `Attachment`.`file_size`, `Attachment`.`created`, `Attachment`.`modified` FROM `irisoweb2_test`.`attachments` AS `Attachment` WHERE `model` = 'Category' AND `model_id` IN (1, 2, 3, 4, 5, 6, 7, 8, 9)	10	10	2
82	SELECT `Category`.`id`, `Category`.`status`, `Category`.`name`, `Category`.`name_en`, `Category`.`name_zh`, `Category`.`name_ko`, `Category`.`detail`, `Category`.`detail_en`, `Category`.`detail_zh`, `Category`.`detail_ko`, `Category`.`title`, `Category`.`title_en`, `Category`.`title_zh`, `Category`.`title_ko`, `Category`.`description`, `Category`.`description_en`, `Category`.`description_zh`, `Category`.`description_ko`, `Category`.`meta_keyword`, `Category`.`meta_keyword_en`, `Category`.`meta_keyword_zh`, `Category`.`meta_keyword_ko`, `Category`.`use_fields`, `Category`.`url`, `Category`.`header_title1`, `Category`.`header_title2`, `Category`.`header_title3`, `Category`.`header_title4`, `Category`.`header_url1`, `Category`.`header_url2`, `Category`.`header_url3`, `Category`.`header_url4`, `Category`.`odr`, `Category`.`created`, `Category`.`modified`, (CONCAT_WS( " ", IFNULL(`Category`.`name`, ""), IFNULL(`Category`.`name_en`, ""), IFNULL(`Category`.`name_zh`, ""), IFNULL(`Category`.`name_ko`, ""), IFNULL(`Category`.`detail`, ""), IFNULL(`Category`.`detail_en`, ""), IFNULL(`Category`.`detail_zh`, ""), IFNULL(`Category`.`detail_ko`, ""), IFNULL(`Category`.`url`, ""), IFNULL(`Category`.`header_title1`, ""), IFNULL(`Category`.`header_title2`, ""), IFNULL(`Category`.`header_title3`, ""), IFNULL(`Category`.`header_title4`, ""))) AS `Category__keyword` FROM `irisoweb2_test`.`categories` AS `Category` WHERE 1 = 1 ORDER BY `Category`.`odr` DESC, `Category`.`id` DESC	9	9	0
83	SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`model_id`, `Attachment`.`field_name`, `Attachment`.`file_name`, `Attachment`.`file_content_type`, `Attachment`.`file_size`, `Attachment`.`created`, `Attachment`.`modified` FROM `irisoweb2_test`.`attachments` AS `Attachment` WHERE `model` = 'Category' AND `model_id` IN (1, 2, 3, 4, 5, 6, 7, 8, 9)	10	10	3
84	show columns from `products`	108	108	1

(default) 84 queries took 339 ms

Query

Error

Affected

Num. rows

Took (ms)

SELECT `Application`.`id`, `Application`.`parent_id`, `Application`.`name`, `Application`.`name_en`, `Application`.`name_zh`, `Application`.`name_ko`, `Application`.`url`, `Application`.`market_name`, `Application`.`market_name_en`, `Application`.`market_name_zh`, `Application`.`market_name_ko`, `Application`.`html`, `Application`.`html_en`, `Application`.`html_zh`, `Application`.`html_ko`, `Application`.`header_title1`, `Application`.`header_title2`, `Application`.`header_title3`, `Application`.`header_title4`, `Application`.`header_url1`, `Application`.`header_url2`, `Application`.`header_url3`, `Application`.`header_url4`, `Application`.`series_ids`, `Application`.`odr`, `Application`.`created`, `Application`.`modified`, (CONCAT_WS( "", IFNULL( `Application`.`name`, ""), IFNULL( `Application`.`header_title1`, ""), IFNULL( `Application`.`header_title2`, ""), IFNULL( `Application`.`header_title3`, ""), IFNULL( `Application`.`header_title4`, ""), IFNULL( `Application`.`series_ids`, ""))) AS `Application__keyword` FROM `irisoweb2_test`.`applications` AS `Application` WHERE `Application`.`url` = 'infrastructure' LIMIT 1

SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`model_id`, `Attachment`.`field_name`, `Attachment`.`file_name`, `Attachment`.`file_content_type`, `Attachment`.`file_size`, `Attachment`.`created`, `Attachment`.`modified` FROM `irisoweb2_test`.`attachments` AS `Attachment` WHERE `model` = 'Application' AND model_id = (50)

SELECT `Category`.`id`, `Category`.`status`, `Category`.`name`, `Category`.`name_en`, `Category`.`name_zh`, `Category`.`name_ko`, `Category`.`detail`, `Category`.`detail_en`, `Category`.`detail_zh`, `Category`.`detail_ko`, `Category`.`title`, `Category`.`title_en`, `Category`.`title_zh`, `Category`.`title_ko`, `Category`.`description`, `Category`.`description_en`, `Category`.`description_zh`, `Category`.`description_ko`, `Category`.`meta_keyword`, `Category`.`meta_keyword_en`, `Category`.`meta_keyword_zh`, `Category`.`meta_keyword_ko`, `Category`.`use_fields`, `Category`.`url`, `Category`.`header_title1`, `Category`.`header_title2`, `Category`.`header_title3`, `Category`.`header_title4`, `Category`.`header_url1`, `Category`.`header_url2`, `Category`.`header_url3`, `Category`.`header_url4`, `Category`.`odr`, `Category`.`created`, `Category`.`modified`, (CONCAT_WS( " ", IFNULL(`Category`.`name`, ""), IFNULL(`Category`.`name_en`, ""), IFNULL(`Category`.`name_zh`, ""), IFNULL(`Category`.`name_ko`, ""), IFNULL(`Category`.`detail`, ""), IFNULL(`Category`.`detail_en`, ""), IFNULL(`Category`.`detail_zh`, ""), IFNULL(`Category`.`detail_ko`, ""), IFNULL(`Category`.`url`, ""), IFNULL(`Category`.`header_title1`, ""), IFNULL(`Category`.`header_title2`, ""), IFNULL(`Category`.`header_title3`, ""), IFNULL(`Category`.`header_title4`, ""))) AS `Category__keyword` FROM `irisoweb2_test`.`categories` AS `Category` WHERE `Category`.`status` = '有効' AND `Category`.`url` = 'fpc-ffc' LIMIT 1

SELECT `Series`.`id`, `Series`.`status`, `Series`.`name`, `Series`.`detail`, `Series`.`detail_en`, `Series`.`detail_zh`, `Series`.`detail_ko`, `Series`.`category_id`, `Series`.`html`, `Series`.`html_en`, `Series`.`html_zh`, `Series`.`html_ko`, `Series`.`title`, `Series`.`title_en`, `Series`.`title_zh`, `Series`.`title_ko`, `Series`.`description`, `Series`.`description_en`, `Series`.`description_zh`, `Series`.`description_ko`, `Series`.`keyword_en`, `Series`.`keyword_zh`, `Series`.`keyword_ko`, `Series`.`file_title1`, `Series`.`file_title2`, `Series`.`file_title3`, `Series`.`file_title4`, `Series`.`file_title5`, `Series`.`file_title6`, `Series`.`file_title7`, `Series`.`file_title8`, `Series`.`file_role1`, `Series`.`file_role2`, `Series`.`file_role3`, `Series`.`file_role4`, `Series`.`file_role5`, `Series`.`file_role6`, `Series`.`file_role7`, `Series`.`file_role8`, `Series`.`file_count1`, `Series`.`file_count2`, `Series`.`file_count3`, `Series`.`file_count4`, `Series`.`file_count5`, `Series`.`file_count6`, `Series`.`file_count7`, `Series`.`file_count8`, `Series`.`similar`, `Series`.`alternative`, `Series`.`combination`, `Series`.`ambiguous`, `Series`.`notice_pattern`, `Series`.`type1`, `Series`.`type2`, `Series`.`type3`, `Series`.`type4`, `Series`.`type5`, `Series`.`type6`, `Series`.`type7`, `Series`.`type8`, `Series`.`type9`, `Series`.`type10`, `Series`.`type11`, `Series`.`type12`, `Series`.`type13`, `Series`.`type14`, `Series`.`type15`, `Series`.`type16`, `Series`.`type17`, `Series`.`type18`, `Series`.`type19`, `Series`.`type20`, `Series`.`type21`, `Series`.`type22`, `Series`.`type23`, `Series`.`type24`, `Series`.`type25`, `Series`.`type26`, `Series`.`type27`, `Series`.`type28`, `Series`.`type29`, `Series`.`type30`, `Series`.`type_height1`, `Series`.`type_height2`, `Series`.`type_height3`, `Series`.`type_height4`, `Series`.`type_height5`, `Series`.`type_height6`, `Series`.`type_height7`, `Series`.`type_height8`, `Series`.`type_height9`, `Series`.`type_height10`, `Series`.`type_height11`, `Series`.`type_height12`, `Series`.`type_height13`, `Series`.`type_height14`, `Series`.`type_height15`, `Series`.`type_height16`, `Series`.`type_height17`, `Series`.`type_height18`, `Series`.`type_height19`, `Series`.`type_height20`, `Series`.`type_height21`, `Series`.`type_height22`, `Series`.`type_height23`, `Series`.`type_height24`, `Series`.`type_height25`, `Series`.`type_height26`, `Series`.`type_height27`, `Series`.`type_height28`, `Series`.`type_height29`, `Series`.`type_height30`, `Series`.`odr`, `Series`.`created`, `Series`.`modified`, (CONCAT_WS( " ", IFNULL(`Series`.`name`,""), IFNULL(`Series`.`detail`,""), IFNULL(`Series`.`detail_en`,""), IFNULL(`Series`.`detail_zh`,""), IFNULL(`Series`.`detail_ko`,""), IFNULL(`Series`.`similar`,""), IFNULL(`Series`.`alternative`,""), IFNULL(`Series`.`combination`,""), IFNULL(`Series`.`ambiguous`,""))) AS `Series__keyword`, `Category`.`id`, `Category`.`status`, `Category`.`name`, `Category`.`name_en`, `Category`.`name_zh`, `Category`.`name_ko`, `Category`.`detail`, `Category`.`detail_en`, `Category`.`detail_zh`, `Category`.`detail_ko`, `Category`.`title`, `Category`.`title_en`, `Category`.`title_zh`, `Category`.`title_ko`, `Category`.`description`, `Category`.`description_en`, `Category`.`description_zh`, `Category`.`description_ko`, `Category`.`meta_keyword`, `Category`.`meta_keyword_en`, `Category`.`meta_keyword_zh`, `Category`.`meta_keyword_ko`, `Category`.`use_fields`, `Category`.`url`, `Category`.`header_title1`, `Category`.`header_title2`, `Category`.`header_title3`, `Category`.`header_title4`, `Category`.`header_url1`, `Category`.`header_url2`, `Category`.`header_url3`, `Category`.`header_url4`, `Category`.`odr`, `Category`.`created`, `Category`.`modified`, (CONCAT_WS( " ", IFNULL(`Category`.`name`, ""), IFNULL(`Category`.`name_en`, ""), IFNULL(`Category`.`name_zh`, ""), IFNULL(`Category`.`name_ko`, ""), IFNULL(`Category`.`detail`, ""), IFNULL(`Category`.`detail_en`, ""), IFNULL(`Category`.`detail_zh`, ""), IFNULL(`Category`.`detail_ko`, ""), IFNULL(`Category`.`url`, ""), IFNULL(`Category`.`header_title1`, ""), IFNULL(`Category`.`header_title2`, ""), IFNULL(`Category`.`header_title3`, ""), IFNULL(`Category`.`header_title4`, ""))) AS `Category__keyword` FROM `irisoweb2_test`.`series` AS `Series` LEFT JOIN `irisoweb2_test`.`categories` AS `Category` ON (`Series`.`category_id` = `Category`.`id`) WHERE `Series`.`name` IN ('6801', '6802', '6803', '11501S', '11503S', '11600S', '12001S', '12002S', '12003S', '9604S', '9610S', '9611S', '9615S', '9616S', '9617S', '9618S', '9619S', '9631S', '9632S', '9634S', '9637S', '9639S', '9661S', '9663S', '9664S', '9665S', '9685S', '9686S', '9687S', '9688S', '9691S', '9695S', '9699S', '6661S', '6662S', '18010S', '16104S', '6223S', '9162S', '9240S', '9241S', '9706S', '9203B', '9261B', '10101S', '10102B', '10102S', '10103B', '10103S', '10106B', '10106S', '10109B', '10109S', '10110B', '10112B', '10112S', '10120B', '10120S', '10121S', '10126B', '10126S', '11000S', '11007S', '9110B', '9110S', '9111B', '9111S', '9115B', '9115S', '9155B', '9157B', '9157S', '9176B', '9179B', '9179S', '9180S', '9184B', '9195B', '9735B', '9735S', '9827B', '9827S', '9828S', '9850B', '9850S', '9851B', '9851S', '9852S', '9853B', '9854B', '9854S', '9855B', '9855S', '9856B', '9856S', '9857B', '9857S', '9860B', '9890B', '9890S', '9892B', '9892S', '9984B', '9984S', '9985S') AND `Series`.`status` = '有効' AND `Category`.`url` = 'fpc-ffc' ORDER BY `Series`.`odr` DESC, `Series`.`id` DESC LIMIT 20

SELECT `Download`.`id`, `Download`.`type`, `Download`.`user_id`, `Download`.`series_id`, `Download`.`product_id`, `Download`.`field`, `Download`.`ip_address`, `Download`.`domain`, `Download`.`created`, `Download`.`modified` FROM `irisoweb2_test`.`downloads` AS `Download` WHERE `user_id` IS NULL AND `type` = 'FAV' AND `Download`.`series_id` IN (51, 50, 49, 46, 45, 43, 437, 434, 431, 429, 428, 427, 426, 421, 420, 419, 417, 415, 414, 413)

SELECT COUNT(*) AS `count` FROM `irisoweb2_test`.`series` AS `Series` LEFT JOIN `irisoweb2_test`.`categories` AS `Category` ON (`Series`.`category_id` = `Category`.`id`) WHERE `Series`.`name` IN ('6801', '6802', '6803', '11501S', '11503S', '11600S', '12001S', '12002S', '12003S', '9604S', '9610S', '9611S', '9615S', '9616S', '9617S', '9618S', '9619S', '9631S', '9632S', '9634S', '9637S', '9639S', '9661S', '9663S', '9664S', '9665S', '9685S', '9686S', '9687S', '9688S', '9691S', '9695S', '9699S', '6661S', '6662S', '18010S', '16104S', '6223S', '9162S', '9240S', '9241S', '9706S', '9203B', '9261B', '10101S', '10102B', '10102S', '10103B', '10103S', '10106B', '10106S', '10109B', '10109S', '10110B', '10112B', '10112S', '10120B', '10120S', '10121S', '10126B', '10126S', '11000S', '11007S', '9110B', '9110S', '9111B', '9111S', '9115B', '9115S', '9155B', '9157B', '9157S', '9176B', '9179B', '9179S', '9180S', '9184B', '9195B', '9735B', '9735S', '9827B', '9827S', '9828S', '9850B', '9850S', '9851B', '9851S', '9852S', '9853B', '9854B', '9854S', '9855B', '9855S', '9856B', '9856S', '9857B', '9857S', '9860B', '9890B', '9890S', '9892B', '9892S', '9984B', '9984S', '9985S') AND `Series`.`status` = '有効' AND `Category`.`url` = 'fpc-ffc'

SELECT COUNT(*) AS count, MAX(CAST(`極数` AS SIGNED)) AS 極数_max, MIN(CAST(`極数` AS SIGNED)) AS 極数_min, MAX(CAST(`嵌合部ピッチ` AS DECIMAL(10,3))) AS 嵌合部ピッチ_max, MIN(CAST(`嵌合部ピッチ` AS DECIMAL(10,3))) AS 嵌合部ピッチ_min, `Product`.`嵌合形状`, `Product`.`基板実装方法`, MAX(CAST(`本体高さ` AS DECIMAL(10,3))) AS 本体高さ_max, MIN(CAST(`本体高さ` AS DECIMAL(10,3))) AS 本体高さ_min, MAX(CAST(`定格電圧（AC）` AS DECIMAL(10,3))) AS 定格電圧（AC）_max, MIN(CAST(`定格電圧（AC）` AS DECIMAL(10,3))) AS 定格電圧（AC）_min, MAX(CAST(`定格電圧（DC）` AS DECIMAL(10,3))) AS 定格電圧（DC）_max, MIN(CAST(`定格電圧（DC）` AS DECIMAL(10,3))) AS 定格電圧（DC）_min, MAX(CAST(`定格電流` AS DECIMAL(10,3))) AS 定格電流_max, MIN(CAST(`定格電流` AS DECIMAL(10,3))) AS 定格電流_min, MAX(CAST(`耐電圧` AS DECIMAL(10,3))) AS 耐電圧_max, MIN(CAST(`耐電圧` AS DECIMAL(10,3))) AS 耐電圧_min, `Product`.`伝送速度（代表参考値）`, `Product`.`使用温度範囲（Max）`, `Product`.`フローティング機能`, `Product`.`振幅許容範囲`, `Product`.`2点接点`, `Product`.`ロック方式`, `Product`.`id` FROM `irisoweb2_test`.`products` AS `Product` LEFT JOIN `irisoweb2_test`.`series` AS `Series` ON (`Product`.`series_id` = `Series`.`id`) WHERE `Product`.`series_id` = 51 AND `Product`.`status` = '有効' AND `Product`.`販売分類` <> 'EOS' GROUP BY `Product`.`series_id` ORDER BY Product.販売分類 ASC, `Product`.`odr` DESC, `Product`.`id` DESC LIMIT 1

SELECT COUNT(*) AS count, MAX(CAST(`極数` AS SIGNED)) AS 極数_max, MIN(CAST(`極数` AS SIGNED)) AS 極数_min, MAX(CAST(`嵌合部ピッチ` AS DECIMAL(10,3))) AS 嵌合部ピッチ_max, MIN(CAST(`嵌合部ピッチ` AS DECIMAL(10,3))) AS 嵌合部ピッチ_min, `Product`.`嵌合形状`, `Product`.`基板実装方法`, MAX(CAST(`本体高さ` AS DECIMAL(10,3))) AS 本体高さ_max, MIN(CAST(`本体高さ` AS DECIMAL(10,3))) AS 本体高さ_min, MAX(CAST(`定格電圧（AC）` AS DECIMAL(10,3))) AS 定格電圧（AC）_max, MIN(CAST(`定格電圧（AC）` AS DECIMAL(10,3))) AS 定格電圧（AC）_min, MAX(CAST(`定格電圧（DC）` AS DECIMAL(10,3))) AS 定格電圧（DC）_max, MIN(CAST(`定格電圧（DC）` AS DECIMAL(10,3))) AS 定格電圧（DC）_min, MAX(CAST(`定格電流` AS DECIMAL(10,3))) AS 定格電流_max, MIN(CAST(`定格電流` AS DECIMAL(10,3))) AS 定格電流_min, MAX(CAST(`耐電圧` AS DECIMAL(10,3))) AS 耐電圧_max, MIN(CAST(`耐電圧` AS DECIMAL(10,3))) AS 耐電圧_min, `Product`.`伝送速度（代表参考値）`, `Product`.`使用温度範囲（Max）`, `Product`.`フローティング機能`, `Product`.`振幅許容範囲`, `Product`.`2点接点`, `Product`.`ロック方式`, `Product`.`id` FROM `irisoweb2_test`.`products` AS `Product` LEFT JOIN `irisoweb2_test`.`series` AS `Series` ON (`Product`.`series_id` = `Series`.`id`) WHERE `Product`.`series_id` = 50 AND `Product`.`status` = '有効' AND `Product`.`販売分類` <> 'EOS' GROUP BY `Product`.`series_id` ORDER BY Product.販売分類 ASC, `Product`.`odr` DESC, `Product`.`id` DESC LIMIT 1

SELECT COUNT(*) AS count, MAX(CAST(`極数` AS SIGNED)) AS 極数_max, MIN(CAST(`極数` AS SIGNED)) AS 極数_min, MAX(CAST(`嵌合部ピッチ` AS DECIMAL(10,3))) AS 嵌合部ピッチ_max, MIN(CAST(`嵌合部ピッチ` AS DECIMAL(10,3))) AS 嵌合部ピッチ_min, `Product`.`嵌合形状`, `Product`.`基板実装方法`, MAX(CAST(`本体高さ` AS DECIMAL(10,3))) AS 本体高さ_max, MIN(CAST(`本体高さ` AS DECIMAL(10,3))) AS 本体高さ_min, MAX(CAST(`定格電圧（AC）` AS DECIMAL(10,3))) AS 定格電圧（AC）_max, MIN(CAST(`定格電圧（AC）` AS DECIMAL(10,3))) AS 定格電圧（AC）_min, MAX(CAST(`定格電圧（DC）` AS DECIMAL(10,3))) AS 定格電圧（DC）_max, MIN(CAST(`定格電圧（DC）` AS DECIMAL(10,3))) AS 定格電圧（DC）_min, MAX(CAST(`定格電流` AS DECIMAL(10,3))) AS 定格電流_max, MIN(CAST(`定格電流` AS DECIMAL(10,3))) AS 定格電流_min, MAX(CAST(`耐電圧` AS DECIMAL(10,3))) AS 耐電圧_max, MIN(CAST(`耐電圧` AS DECIMAL(10,3))) AS 耐電圧_min, `Product`.`伝送速度（代表参考値）`, `Product`.`使用温度範囲（Max）`, `Product`.`フローティング機能`, `Product`.`振幅許容範囲`, `Product`.`2点接点`, `Product`.`ロック方式`, `Product`.`id` FROM `irisoweb2_test`.`products` AS `Product` LEFT JOIN `irisoweb2_test`.`series` AS `Series` ON (`Product`.`series_id` = `Series`.`id`) WHERE `Product`.`series_id` = 49 AND `Product`.`status` = '有効' AND `Product`.`販売分類` <> 'EOS' GROUP BY `Product`.`series_id` ORDER BY Product.販売分類 ASC, `Product`.`odr` DESC, `Product`.`id` DESC LIMIT 1

SELECT COUNT(*) AS count, MAX(CAST(`極数` AS SIGNED)) AS 極数_max, MIN(CAST(`極数` AS SIGNED)) AS 極数_min, MAX(CAST(`嵌合部ピッチ` AS DECIMAL(10,3))) AS 嵌合部ピッチ_max, MIN(CAST(`嵌合部ピッチ` AS DECIMAL(10,3))) AS 嵌合部ピッチ_min, `Product`.`嵌合形状`, `Product`.`基板実装方法`, MAX(CAST(`本体高さ` AS DECIMAL(10,3))) AS 本体高さ_max, MIN(CAST(`本体高さ` AS DECIMAL(10,3))) AS 本体高さ_min, MAX(CAST(`定格電圧（AC）` AS DECIMAL(10,3))) AS 定格電圧（AC）_max, MIN(CAST(`定格電圧（AC）` AS DECIMAL(10,3))) AS 定格電圧（AC）_min, MAX(CAST(`定格電圧（DC）` AS DECIMAL(10,3))) AS 定格電圧（DC）_max, MIN(CAST(`定格電圧（DC）` AS DECIMAL(10,3))) AS 定格電圧（DC）_min, MAX(CAST(`定格電流` AS DECIMAL(10,3))) AS 定格電流_max, MIN(CAST(`定格電流` AS DECIMAL(10,3))) AS 定格電流_min, MAX(CAST(`耐電圧` AS DECIMAL(10,3))) AS 耐電圧_max, MIN(CAST(`耐電圧` AS DECIMAL(10,3))) AS 耐電圧_min, `Product`.`伝送速度（代表参考値）`, `Product`.`使用温度範囲（Max）`, `Product`.`フローティング機能`, `Product`.`振幅許容範囲`, `Product`.`2点接点`, `Product`.`ロック方式`, `Product`.`id` FROM `irisoweb2_test`.`products` AS `Product` LEFT JOIN `irisoweb2_test`.`series` AS `Series` ON (`Product`.`series_id` = `Series`.`id`) WHERE `Product`.`series_id` = 46 AND `Product`.`status` = '有効' AND `Product`.`販売分類` <> 'EOS' GROUP BY `Product`.`series_id` ORDER BY Product.販売分類 ASC, `Product`.`odr` DESC, `Product`.`id` DESC LIMIT 1

SELECT COUNT(*) AS count, MAX(CAST(`極数` AS SIGNED)) AS 極数_max, MIN(CAST(`極数` AS SIGNED)) AS 極数_min, MAX(CAST(`嵌合部ピッチ` AS DECIMAL(10,3))) AS 嵌合部ピッチ_max, MIN(CAST(`嵌合部ピッチ` AS DECIMAL(10,3))) AS 嵌合部ピッチ_min, `Product`.`嵌合形状`, `Product`.`基板実装方法`, MAX(CAST(`本体高さ` AS DECIMAL(10,3))) AS 本体高さ_max, MIN(CAST(`本体高さ` AS DECIMAL(10,3))) AS 本体高さ_min, MAX(CAST(`定格電圧（AC）` AS DECIMAL(10,3))) AS 定格電圧（AC）_max, MIN(CAST(`定格電圧（AC）` AS DECIMAL(10,3))) AS 定格電圧（AC）_min, MAX(CAST(`定格電圧（DC）` AS DECIMAL(10,3))) AS 定格電圧（DC）_max, MIN(CAST(`定格電圧（DC）` AS DECIMAL(10,3))) AS 定格電圧（DC）_min, MAX(CAST(`定格電流` AS DECIMAL(10,3))) AS 定格電流_max, MIN(CAST(`定格電流` AS DECIMAL(10,3))) AS 定格電流_min, MAX(CAST(`耐電圧` AS DECIMAL(10,3))) AS 耐電圧_max, MIN(CAST(`耐電圧` AS DECIMAL(10,3))) AS 耐電圧_min, `Product`.`伝送速度（代表参考値）`, `Product`.`使用温度範囲（Max）`, `Product`.`フローティング機能`, `Product`.`振幅許容範囲`, `Product`.`2点接点`, `Product`.`ロック方式`, `Product`.`id` FROM `irisoweb2_test`.`products` AS `Product` LEFT JOIN `irisoweb2_test`.`series` AS `Series` ON (`Product`.`series_id` = `Series`.`id`) WHERE `Product`.`series_id` = 45 AND `Product`.`status` = '有効' AND `Product`.`販売分類` <> 'EOS' GROUP BY `Product`.`series_id` ORDER BY Product.販売分類 ASC, `Product`.`odr` DESC, `Product`.`id` DESC LIMIT 1

SELECT COUNT(*) AS count, MAX(CAST(`極数` AS SIGNED)) AS 極数_max, MIN(CAST(`極数` AS SIGNED)) AS 極数_min, MAX(CAST(`嵌合部ピッチ` AS DECIMAL(10,3))) AS 嵌合部ピッチ_max, MIN(CAST(`嵌合部ピッチ` AS DECIMAL(10,3))) AS 嵌合部ピッチ_min, `Product`.`嵌合形状`, `Product`.`基板実装方法`, MAX(CAST(`本体高さ` AS DECIMAL(10,3))) AS 本体高さ_max, MIN(CAST(`本体高さ` AS DECIMAL(10,3))) AS 本体高さ_min, MAX(CAST(`定格電圧（AC）` AS DECIMAL(10,3))) AS 定格電圧（AC）_max, MIN(CAST(`定格電圧（AC）` AS DECIMAL(10,3))) AS 定格電圧（AC）_min, MAX(CAST(`定格電圧（DC）` AS DECIMAL(10,3))) AS 定格電圧（DC）_max, MIN(CAST(`定格電圧（DC）` AS DECIMAL(10,3))) AS 定格電圧（DC）_min, MAX(CAST(`定格電流` AS DECIMAL(10,3))) AS 定格電流_max, MIN(CAST(`定格電流` AS DECIMAL(10,3))) AS 定格電流_min, MAX(CAST(`耐電圧` AS DECIMAL(10,3))) AS 耐電圧_max, MIN(CAST(`耐電圧` AS DECIMAL(10,3))) AS 耐電圧_min, `Product`.`伝送速度（代表参考値）`, `Product`.`使用温度範囲（Max）`, `Product`.`フローティング機能`, `Product`.`振幅許容範囲`, `Product`.`2点接点`, `Product`.`ロック方式`, `Product`.`id` FROM `irisoweb2_test`.`products` AS `Product` LEFT JOIN `irisoweb2_test`.`series` AS `Series` ON (`Product`.`series_id` = `Series`.`id`) WHERE `Product`.`series_id` = 43 AND `Product`.`status` = '有効' AND `Product`.`販売分類` <> 'EOS' GROUP BY `Product`.`series_id` ORDER BY Product.販売分類 ASC, `Product`.`odr` DESC, `Product`.`id` DESC LIMIT 1

SELECT COUNT(*) AS count, MAX(CAST(`極数` AS SIGNED)) AS 極数_max, MIN(CAST(`極数` AS SIGNED)) AS 極数_min, MAX(CAST(`嵌合部ピッチ` AS DECIMAL(10,3))) AS 嵌合部ピッチ_max, MIN(CAST(`嵌合部ピッチ` AS DECIMAL(10,3))) AS 嵌合部ピッチ_min, `Product`.`嵌合形状`, `Product`.`基板実装方法`, MAX(CAST(`本体高さ` AS DECIMAL(10,3))) AS 本体高さ_max, MIN(CAST(`本体高さ` AS DECIMAL(10,3))) AS 本体高さ_min, MAX(CAST(`定格電圧（AC）` AS DECIMAL(10,3))) AS 定格電圧（AC）_max, MIN(CAST(`定格電圧（AC）` AS DECIMAL(10,3))) AS 定格電圧（AC）_min, MAX(CAST(`定格電圧（DC）` AS DECIMAL(10,3))) AS 定格電圧（DC）_max, MIN(CAST(`定格電圧（DC）` AS DECIMAL(10,3))) AS 定格電圧（DC）_min, MAX(CAST(`定格電流` AS DECIMAL(10,3))) AS 定格電流_max, MIN(CAST(`定格電流` AS DECIMAL(10,3))) AS 定格電流_min, MAX(CAST(`耐電圧` AS DECIMAL(10,3))) AS 耐電圧_max, MIN(CAST(`耐電圧` AS DECIMAL(10,3))) AS 耐電圧_min, `Product`.`伝送速度（代表参考値）`, `Product`.`使用温度範囲（Max）`, `Product`.`フローティング機能`, `Product`.`振幅許容範囲`, `Product`.`2点接点`, `Product`.`ロック方式`, `Product`.`id` FROM `irisoweb2_test`.`products` AS `Product` LEFT JOIN `irisoweb2_test`.`series` AS `Series` ON (`Product`.`series_id` = `Series`.`id`) WHERE `Product`.`series_id` = 437 AND `Product`.`status` = '有効' AND `Product`.`販売分類` <> 'EOS' GROUP BY `Product`.`series_id` ORDER BY Product.販売分類 ASC, `Product`.`odr` DESC, `Product`.`id` DESC LIMIT 1

SELECT COUNT(*) AS count, MAX(CAST(`極数` AS SIGNED)) AS 極数_max, MIN(CAST(`極数` AS SIGNED)) AS 極数_min, MAX(CAST(`嵌合部ピッチ` AS DECIMAL(10,3))) AS 嵌合部ピッチ_max, MIN(CAST(`嵌合部ピッチ` AS DECIMAL(10,3))) AS 嵌合部ピッチ_min, `Product`.`嵌合形状`, `Product`.`基板実装方法`, MAX(CAST(`本体高さ` AS DECIMAL(10,3))) AS 本体高さ_max, MIN(CAST(`本体高さ` AS DECIMAL(10,3))) AS 本体高さ_min, MAX(CAST(`定格電圧（AC）` AS DECIMAL(10,3))) AS 定格電圧（AC）_max, MIN(CAST(`定格電圧（AC）` AS DECIMAL(10,3))) AS 定格電圧（AC）_min, MAX(CAST(`定格電圧（DC）` AS DECIMAL(10,3))) AS 定格電圧（DC）_max, MIN(CAST(`定格電圧（DC）` AS DECIMAL(10,3))) AS 定格電圧（DC）_min, MAX(CAST(`定格電流` AS DECIMAL(10,3))) AS 定格電流_max, MIN(CAST(`定格電流` AS DECIMAL(10,3))) AS 定格電流_min, MAX(CAST(`耐電圧` AS DECIMAL(10,3))) AS 耐電圧_max, MIN(CAST(`耐電圧` AS DECIMAL(10,3))) AS 耐電圧_min, `Product`.`伝送速度（代表参考値）`, `Product`.`使用温度範囲（Max）`, `Product`.`フローティング機能`, `Product`.`振幅許容範囲`, `Product`.`2点接点`, `Product`.`ロック方式`, `Product`.`id` FROM `irisoweb2_test`.`products` AS `Product` LEFT JOIN `irisoweb2_test`.`series` AS `Series` ON (`Product`.`series_id` = `Series`.`id`) WHERE `Product`.`series_id` = 434 AND `Product`.`status` = '有効' AND `Product`.`販売分類` <> 'EOS' GROUP BY `Product`.`series_id` ORDER BY Product.販売分類 ASC, `Product`.`odr` DESC, `Product`.`id` DESC LIMIT 1

SELECT COUNT(*) AS count, MAX(CAST(`極数` AS SIGNED)) AS 極数_max, MIN(CAST(`極数` AS SIGNED)) AS 極数_min, MAX(CAST(`嵌合部ピッチ` AS DECIMAL(10,3))) AS 嵌合部ピッチ_max, MIN(CAST(`嵌合部ピッチ` AS DECIMAL(10,3))) AS 嵌合部ピッチ_min, `Product`.`嵌合形状`, `Product`.`基板実装方法`, MAX(CAST(`本体高さ` AS DECIMAL(10,3))) AS 本体高さ_max, MIN(CAST(`本体高さ` AS DECIMAL(10,3))) AS 本体高さ_min, MAX(CAST(`定格電圧（AC）` AS DECIMAL(10,3))) AS 定格電圧（AC）_max, MIN(CAST(`定格電圧（AC）` AS DECIMAL(10,3))) AS 定格電圧（AC）_min, MAX(CAST(`定格電圧（DC）` AS DECIMAL(10,3))) AS 定格電圧（DC）_max, MIN(CAST(`定格電圧（DC）` AS DECIMAL(10,3))) AS 定格電圧（DC）_min, MAX(CAST(`定格電流` AS DECIMAL(10,3))) AS 定格電流_max, MIN(CAST(`定格電流` AS DECIMAL(10,3))) AS 定格電流_min, MAX(CAST(`耐電圧` AS DECIMAL(10,3))) AS 耐電圧_max, MIN(CAST(`耐電圧` AS DECIMAL(10,3))) AS 耐電圧_min, `Product`.`伝送速度（代表参考値）`, `Product`.`使用温度範囲（Max）`, `Product`.`フローティング機能`, `Product`.`振幅許容範囲`, `Product`.`2点接点`, `Product`.`ロック方式`, `Product`.`id` FROM `irisoweb2_test`.`products` AS `Product` LEFT JOIN `irisoweb2_test`.`series` AS `Series` ON (`Product`.`series_id` = `Series`.`id`) WHERE `Product`.`series_id` = 431 AND `Product`.`status` = '有効' AND `Product`.`販売分類` <> 'EOS' GROUP BY `Product`.`series_id` ORDER BY Product.販売分類 ASC, `Product`.`odr` DESC, `Product`.`id` DESC LIMIT 1

SELECT COUNT(*) AS count, MAX(CAST(`極数` AS SIGNED)) AS 極数_max, MIN(CAST(`極数` AS SIGNED)) AS 極数_min, MAX(CAST(`嵌合部ピッチ` AS DECIMAL(10,3))) AS 嵌合部ピッチ_max, MIN(CAST(`嵌合部ピッチ` AS DECIMAL(10,3))) AS 嵌合部ピッチ_min, `Product`.`嵌合形状`, `Product`.`基板実装方法`, MAX(CAST(`本体高さ` AS DECIMAL(10,3))) AS 本体高さ_max, MIN(CAST(`本体高さ` AS DECIMAL(10,3))) AS 本体高さ_min, MAX(CAST(`定格電圧（AC）` AS DECIMAL(10,3))) AS 定格電圧（AC）_max, MIN(CAST(`定格電圧（AC）` AS DECIMAL(10,3))) AS 定格電圧（AC）_min, MAX(CAST(`定格電圧（DC）` AS DECIMAL(10,3))) AS 定格電圧（DC）_max, MIN(CAST(`定格電圧（DC）` AS DECIMAL(10,3))) AS 定格電圧（DC）_min, MAX(CAST(`定格電流` AS DECIMAL(10,3))) AS 定格電流_max, MIN(CAST(`定格電流` AS DECIMAL(10,3))) AS 定格電流_min, MAX(CAST(`耐電圧` AS DECIMAL(10,3))) AS 耐電圧_max, MIN(CAST(`耐電圧` AS DECIMAL(10,3))) AS 耐電圧_min, `Product`.`伝送速度（代表参考値）`, `Product`.`使用温度範囲（Max）`, `Product`.`フローティング機能`, `Product`.`振幅許容範囲`, `Product`.`2点接点`, `Product`.`ロック方式`, `Product`.`id` FROM `irisoweb2_test`.`products` AS `Product` LEFT JOIN `irisoweb2_test`.`series` AS `Series` ON (`Product`.`series_id` = `Series`.`id`) WHERE `Product`.`series_id` = 429 AND `Product`.`status` = '有効' AND `Product`.`販売分類` <> 'EOS' GROUP BY `Product`.`series_id` ORDER BY Product.販売分類 ASC, `Product`.`odr` DESC, `Product`.`id` DESC LIMIT 1

SELECT COUNT(*) AS count, MAX(CAST(`極数` AS SIGNED)) AS 極数_max, MIN(CAST(`極数` AS SIGNED)) AS 極数_min, MAX(CAST(`嵌合部ピッチ` AS DECIMAL(10,3))) AS 嵌合部ピッチ_max, MIN(CAST(`嵌合部ピッチ` AS DECIMAL(10,3))) AS 嵌合部ピッチ_min, `Product`.`嵌合形状`, `Product`.`基板実装方法`, MAX(CAST(`本体高さ` AS DECIMAL(10,3))) AS 本体高さ_max, MIN(CAST(`本体高さ` AS DECIMAL(10,3))) AS 本体高さ_min, MAX(CAST(`定格電圧（AC）` AS DECIMAL(10,3))) AS 定格電圧（AC）_max, MIN(CAST(`定格電圧（AC）` AS DECIMAL(10,3))) AS 定格電圧（AC）_min, MAX(CAST(`定格電圧（DC）` AS DECIMAL(10,3))) AS 定格電圧（DC）_max, MIN(CAST(`定格電圧（DC）` AS DECIMAL(10,3))) AS 定格電圧（DC）_min, MAX(CAST(`定格電流` AS DECIMAL(10,3))) AS 定格電流_max, MIN(CAST(`定格電流` AS DECIMAL(10,3))) AS 定格電流_min, MAX(CAST(`耐電圧` AS DECIMAL(10,3))) AS 耐電圧_max, MIN(CAST(`耐電圧` AS DECIMAL(10,3))) AS 耐電圧_min, `Product`.`伝送速度（代表参考値）`, `Product`.`使用温度範囲（Max）`, `Product`.`フローティング機能`, `Product`.`振幅許容範囲`, `Product`.`2点接点`, `Product`.`ロック方式`, `Product`.`id` FROM `irisoweb2_test`.`products` AS `Product` LEFT JOIN `irisoweb2_test`.`series` AS `Series` ON (`Product`.`series_id` = `Series`.`id`) WHERE `Product`.`series_id` = 428 AND `Product`.`status` = '有効' AND `Product`.`販売分類` <> 'EOS' GROUP BY `Product`.`series_id` ORDER BY Product.販売分類 ASC, `Product`.`odr` DESC, `Product`.`id` DESC LIMIT 1

SELECT COUNT(*) AS count, MAX(CAST(`極数` AS SIGNED)) AS 極数_max, MIN(CAST(`極数` AS SIGNED)) AS 極数_min, MAX(CAST(`嵌合部ピッチ` AS DECIMAL(10,3))) AS 嵌合部ピッチ_max, MIN(CAST(`嵌合部ピッチ` AS DECIMAL(10,3))) AS 嵌合部ピッチ_min, `Product`.`嵌合形状`, `Product`.`基板実装方法`, MAX(CAST(`本体高さ` AS DECIMAL(10,3))) AS 本体高さ_max, MIN(CAST(`本体高さ` AS DECIMAL(10,3))) AS 本体高さ_min, MAX(CAST(`定格電圧（AC）` AS DECIMAL(10,3))) AS 定格電圧（AC）_max, MIN(CAST(`定格電圧（AC）` AS DECIMAL(10,3))) AS 定格電圧（AC）_min, MAX(CAST(`定格電圧（DC）` AS DECIMAL(10,3))) AS 定格電圧（DC）_max, MIN(CAST(`定格電圧（DC）` AS DECIMAL(10,3))) AS 定格電圧（DC）_min, MAX(CAST(`定格電流` AS DECIMAL(10,3))) AS 定格電流_max, MIN(CAST(`定格電流` AS DECIMAL(10,3))) AS 定格電流_min, MAX(CAST(`耐電圧` AS DECIMAL(10,3))) AS 耐電圧_max, MIN(CAST(`耐電圧` AS DECIMAL(10,3))) AS 耐電圧_min, `Product`.`伝送速度（代表参考値）`, `Product`.`使用温度範囲（Max）`, `Product`.`フローティング機能`, `Product`.`振幅許容範囲`, `Product`.`2点接点`, `Product`.`ロック方式`, `Product`.`id` FROM `irisoweb2_test`.`products` AS `Product` LEFT JOIN `irisoweb2_test`.`series` AS `Series` ON (`Product`.`series_id` = `Series`.`id`) WHERE `Product`.`series_id` = 427 AND `Product`.`status` = '有効' AND `Product`.`販売分類` <> 'EOS' GROUP BY `Product`.`series_id` ORDER BY Product.販売分類 ASC, `Product`.`odr` DESC, `Product`.`id` DESC LIMIT 1

SELECT COUNT(*) AS count, MAX(CAST(`極数` AS SIGNED)) AS 極数_max, MIN(CAST(`極数` AS SIGNED)) AS 極数_min, MAX(CAST(`嵌合部ピッチ` AS DECIMAL(10,3))) AS 嵌合部ピッチ_max, MIN(CAST(`嵌合部ピッチ` AS DECIMAL(10,3))) AS 嵌合部ピッチ_min, `Product`.`嵌合形状`, `Product`.`基板実装方法`, MAX(CAST(`本体高さ` AS DECIMAL(10,3))) AS 本体高さ_max, MIN(CAST(`本体高さ` AS DECIMAL(10,3))) AS 本体高さ_min, MAX(CAST(`定格電圧（AC）` AS DECIMAL(10,3))) AS 定格電圧（AC）_max, MIN(CAST(`定格電圧（AC）` AS DECIMAL(10,3))) AS 定格電圧（AC）_min, MAX(CAST(`定格電圧（DC）` AS DECIMAL(10,3))) AS 定格電圧（DC）_max, MIN(CAST(`定格電圧（DC）` AS DECIMAL(10,3))) AS 定格電圧（DC）_min, MAX(CAST(`定格電流` AS DECIMAL(10,3))) AS 定格電流_max, MIN(CAST(`定格電流` AS DECIMAL(10,3))) AS 定格電流_min, MAX(CAST(`耐電圧` AS DECIMAL(10,3))) AS 耐電圧_max, MIN(CAST(`耐電圧` AS DECIMAL(10,3))) AS 耐電圧_min, `Product`.`伝送速度（代表参考値）`, `Product`.`使用温度範囲（Max）`, `Product`.`フローティング機能`, `Product`.`振幅許容範囲`, `Product`.`2点接点`, `Product`.`ロック方式`, `Product`.`id` FROM `irisoweb2_test`.`products` AS `Product` LEFT JOIN `irisoweb2_test`.`series` AS `Series` ON (`Product`.`series_id` = `Series`.`id`) WHERE `Product`.`series_id` = 426 AND `Product`.`status` = '有効' AND `Product`.`販売分類` <> 'EOS' GROUP BY `Product`.`series_id` ORDER BY Product.販売分類 ASC, `Product`.`odr` DESC, `Product`.`id` DESC LIMIT 1

SELECT COUNT(*) AS count, MAX(CAST(`極数` AS SIGNED)) AS 極数_max, MIN(CAST(`極数` AS SIGNED)) AS 極数_min, MAX(CAST(`嵌合部ピッチ` AS DECIMAL(10,3))) AS 嵌合部ピッチ_max, MIN(CAST(`嵌合部ピッチ` AS DECIMAL(10,3))) AS 嵌合部ピッチ_min, `Product`.`嵌合形状`, `Product`.`基板実装方法`, MAX(CAST(`本体高さ` AS DECIMAL(10,3))) AS 本体高さ_max, MIN(CAST(`本体高さ` AS DECIMAL(10,3))) AS 本体高さ_min, MAX(CAST(`定格電圧（AC）` AS DECIMAL(10,3))) AS 定格電圧（AC）_max, MIN(CAST(`定格電圧（AC）` AS DECIMAL(10,3))) AS 定格電圧（AC）_min, MAX(CAST(`定格電圧（DC）` AS DECIMAL(10,3))) AS 定格電圧（DC）_max, MIN(CAST(`定格電圧（DC）` AS DECIMAL(10,3))) AS 定格電圧（DC）_min, MAX(CAST(`定格電流` AS DECIMAL(10,3))) AS 定格電流_max, MIN(CAST(`定格電流` AS DECIMAL(10,3))) AS 定格電流_min, MAX(CAST(`耐電圧` AS DECIMAL(10,3))) AS 耐電圧_max, MIN(CAST(`耐電圧` AS DECIMAL(10,3))) AS 耐電圧_min, `Product`.`伝送速度（代表参考値）`, `Product`.`使用温度範囲（Max）`, `Product`.`フローティング機能`, `Product`.`振幅許容範囲`, `Product`.`2点接点`, `Product`.`ロック方式`, `Product`.`id` FROM `irisoweb2_test`.`products` AS `Product` LEFT JOIN `irisoweb2_test`.`series` AS `Series` ON (`Product`.`series_id` = `Series`.`id`) WHERE `Product`.`series_id` = 421 AND `Product`.`status` = '有効' AND `Product`.`販売分類` <> 'EOS' GROUP BY `Product`.`series_id` ORDER BY Product.販売分類 ASC, `Product`.`odr` DESC, `Product`.`id` DESC LIMIT 1

SELECT COUNT(*) AS count, MAX(CAST(`極数` AS SIGNED)) AS 極数_max, MIN(CAST(`極数` AS SIGNED)) AS 極数_min, MAX(CAST(`嵌合部ピッチ` AS DECIMAL(10,3))) AS 嵌合部ピッチ_max, MIN(CAST(`嵌合部ピッチ` AS DECIMAL(10,3))) AS 嵌合部ピッチ_min, `Product`.`嵌合形状`, `Product`.`基板実装方法`, MAX(CAST(`本体高さ` AS DECIMAL(10,3))) AS 本体高さ_max, MIN(CAST(`本体高さ` AS DECIMAL(10,3))) AS 本体高さ_min, MAX(CAST(`定格電圧（AC）` AS DECIMAL(10,3))) AS 定格電圧（AC）_max, MIN(CAST(`定格電圧（AC）` AS DECIMAL(10,3))) AS 定格電圧（AC）_min, MAX(CAST(`定格電圧（DC）` AS DECIMAL(10,3))) AS 定格電圧（DC）_max, MIN(CAST(`定格電圧（DC）` AS DECIMAL(10,3))) AS 定格電圧（DC）_min, MAX(CAST(`定格電流` AS DECIMAL(10,3))) AS 定格電流_max, MIN(CAST(`定格電流` AS DECIMAL(10,3))) AS 定格電流_min, MAX(CAST(`耐電圧` AS DECIMAL(10,3))) AS 耐電圧_max, MIN(CAST(`耐電圧` AS DECIMAL(10,3))) AS 耐電圧_min, `Product`.`伝送速度（代表参考値）`, `Product`.`使用温度範囲（Max）`, `Product`.`フローティング機能`, `Product`.`振幅許容範囲`, `Product`.`2点接点`, `Product`.`ロック方式`, `Product`.`id` FROM `irisoweb2_test`.`products` AS `Product` LEFT JOIN `irisoweb2_test`.`series` AS `Series` ON (`Product`.`series_id` = `Series`.`id`) WHERE `Product`.`series_id` = 420 AND `Product`.`status` = '有効' AND `Product`.`販売分類` <> 'EOS' GROUP BY `Product`.`series_id` ORDER BY Product.販売分類 ASC, `Product`.`odr` DESC, `Product`.`id` DESC LIMIT 1

SELECT COUNT(*) AS count, MAX(CAST(`極数` AS SIGNED)) AS 極数_max, MIN(CAST(`極数` AS SIGNED)) AS 極数_min, MAX(CAST(`嵌合部ピッチ` AS DECIMAL(10,3))) AS 嵌合部ピッチ_max, MIN(CAST(`嵌合部ピッチ` AS DECIMAL(10,3))) AS 嵌合部ピッチ_min, `Product`.`嵌合形状`, `Product`.`基板実装方法`, MAX(CAST(`本体高さ` AS DECIMAL(10,3))) AS 本体高さ_max, MIN(CAST(`本体高さ` AS DECIMAL(10,3))) AS 本体高さ_min, MAX(CAST(`定格電圧（AC）` AS DECIMAL(10,3))) AS 定格電圧（AC）_max, MIN(CAST(`定格電圧（AC）` AS DECIMAL(10,3))) AS 定格電圧（AC）_min, MAX(CAST(`定格電圧（DC）` AS DECIMAL(10,3))) AS 定格電圧（DC）_max, MIN(CAST(`定格電圧（DC）` AS DECIMAL(10,3))) AS 定格電圧（DC）_min, MAX(CAST(`定格電流` AS DECIMAL(10,3))) AS 定格電流_max, MIN(CAST(`定格電流` AS DECIMAL(10,3))) AS 定格電流_min, MAX(CAST(`耐電圧` AS DECIMAL(10,3))) AS 耐電圧_max, MIN(CAST(`耐電圧` AS DECIMAL(10,3))) AS 耐電圧_min, `Product`.`伝送速度（代表参考値）`, `Product`.`使用温度範囲（Max）`, `Product`.`フローティング機能`, `Product`.`振幅許容範囲`, `Product`.`2点接点`, `Product`.`ロック方式`, `Product`.`id` FROM `irisoweb2_test`.`products` AS `Product` LEFT JOIN `irisoweb2_test`.`series` AS `Series` ON (`Product`.`series_id` = `Series`.`id`) WHERE `Product`.`series_id` = 419 AND `Product`.`status` = '有効' AND `Product`.`販売分類` <> 'EOS' GROUP BY `Product`.`series_id` ORDER BY Product.販売分類 ASC, `Product`.`odr` DESC, `Product`.`id` DESC LIMIT 1

SELECT COUNT(*) AS count, MAX(CAST(`極数` AS SIGNED)) AS 極数_max, MIN(CAST(`極数` AS SIGNED)) AS 極数_min, MAX(CAST(`嵌合部ピッチ` AS DECIMAL(10,3))) AS 嵌合部ピッチ_max, MIN(CAST(`嵌合部ピッチ` AS DECIMAL(10,3))) AS 嵌合部ピッチ_min, `Product`.`嵌合形状`, `Product`.`基板実装方法`, MAX(CAST(`本体高さ` AS DECIMAL(10,3))) AS 本体高さ_max, MIN(CAST(`本体高さ` AS DECIMAL(10,3))) AS 本体高さ_min, MAX(CAST(`定格電圧（AC）` AS DECIMAL(10,3))) AS 定格電圧（AC）_max, MIN(CAST(`定格電圧（AC）` AS DECIMAL(10,3))) AS 定格電圧（AC）_min, MAX(CAST(`定格電圧（DC）` AS DECIMAL(10,3))) AS 定格電圧（DC）_max, MIN(CAST(`定格電圧（DC）` AS DECIMAL(10,3))) AS 定格電圧（DC）_min, MAX(CAST(`定格電流` AS DECIMAL(10,3))) AS 定格電流_max, MIN(CAST(`定格電流` AS DECIMAL(10,3))) AS 定格電流_min, MAX(CAST(`耐電圧` AS DECIMAL(10,3))) AS 耐電圧_max, MIN(CAST(`耐電圧` AS DECIMAL(10,3))) AS 耐電圧_min, `Product`.`伝送速度（代表参考値）`, `Product`.`使用温度範囲（Max）`, `Product`.`フローティング機能`, `Product`.`振幅許容範囲`, `Product`.`2点接点`, `Product`.`ロック方式`, `Product`.`id` FROM `irisoweb2_test`.`products` AS `Product` LEFT JOIN `irisoweb2_test`.`series` AS `Series` ON (`Product`.`series_id` = `Series`.`id`) WHERE `Product`.`series_id` = 417 AND `Product`.`status` = '有効' AND `Product`.`販売分類` <> 'EOS' GROUP BY `Product`.`series_id` ORDER BY Product.販売分類 ASC, `Product`.`odr` DESC, `Product`.`id` DESC LIMIT 1

SELECT COUNT(*) AS count, MAX(CAST(`極数` AS SIGNED)) AS 極数_max, MIN(CAST(`極数` AS SIGNED)) AS 極数_min, MAX(CAST(`嵌合部ピッチ` AS DECIMAL(10,3))) AS 嵌合部ピッチ_max, MIN(CAST(`嵌合部ピッチ` AS DECIMAL(10,3))) AS 嵌合部ピッチ_min, `Product`.`嵌合形状`, `Product`.`基板実装方法`, MAX(CAST(`本体高さ` AS DECIMAL(10,3))) AS 本体高さ_max, MIN(CAST(`本体高さ` AS DECIMAL(10,3))) AS 本体高さ_min, MAX(CAST(`定格電圧（AC）` AS DECIMAL(10,3))) AS 定格電圧（AC）_max, MIN(CAST(`定格電圧（AC）` AS DECIMAL(10,3))) AS 定格電圧（AC）_min, MAX(CAST(`定格電圧（DC）` AS DECIMAL(10,3))) AS 定格電圧（DC）_max, MIN(CAST(`定格電圧（DC）` AS DECIMAL(10,3))) AS 定格電圧（DC）_min, MAX(CAST(`定格電流` AS DECIMAL(10,3))) AS 定格電流_max, MIN(CAST(`定格電流` AS DECIMAL(10,3))) AS 定格電流_min, MAX(CAST(`耐電圧` AS DECIMAL(10,3))) AS 耐電圧_max, MIN(CAST(`耐電圧` AS DECIMAL(10,3))) AS 耐電圧_min, `Product`.`伝送速度（代表参考値）`, `Product`.`使用温度範囲（Max）`, `Product`.`フローティング機能`, `Product`.`振幅許容範囲`, `Product`.`2点接点`, `Product`.`ロック方式`, `Product`.`id` FROM `irisoweb2_test`.`products` AS `Product` LEFT JOIN `irisoweb2_test`.`series` AS `Series` ON (`Product`.`series_id` = `Series`.`id`) WHERE `Product`.`series_id` = 415 AND `Product`.`status` = '有効' AND `Product`.`販売分類` <> 'EOS' GROUP BY `Product`.`series_id` ORDER BY Product.販売分類 ASC, `Product`.`odr` DESC, `Product`.`id` DESC LIMIT 1

SELECT COUNT(*) AS count, MAX(CAST(`極数` AS SIGNED)) AS 極数_max, MIN(CAST(`極数` AS SIGNED)) AS 極数_min, MAX(CAST(`嵌合部ピッチ` AS DECIMAL(10,3))) AS 嵌合部ピッチ_max, MIN(CAST(`嵌合部ピッチ` AS DECIMAL(10,3))) AS 嵌合部ピッチ_min, `Product`.`嵌合形状`, `Product`.`基板実装方法`, MAX(CAST(`本体高さ` AS DECIMAL(10,3))) AS 本体高さ_max, MIN(CAST(`本体高さ` AS DECIMAL(10,3))) AS 本体高さ_min, MAX(CAST(`定格電圧（AC）` AS DECIMAL(10,3))) AS 定格電圧（AC）_max, MIN(CAST(`定格電圧（AC）` AS DECIMAL(10,3))) AS 定格電圧（AC）_min, MAX(CAST(`定格電圧（DC）` AS DECIMAL(10,3))) AS 定格電圧（DC）_max, MIN(CAST(`定格電圧（DC）` AS DECIMAL(10,3))) AS 定格電圧（DC）_min, MAX(CAST(`定格電流` AS DECIMAL(10,3))) AS 定格電流_max, MIN(CAST(`定格電流` AS DECIMAL(10,3))) AS 定格電流_min, MAX(CAST(`耐電圧` AS DECIMAL(10,3))) AS 耐電圧_max, MIN(CAST(`耐電圧` AS DECIMAL(10,3))) AS 耐電圧_min, `Product`.`伝送速度（代表参考値）`, `Product`.`使用温度範囲（Max）`, `Product`.`フローティング機能`, `Product`.`振幅許容範囲`, `Product`.`2点接点`, `Product`.`ロック方式`, `Product`.`id` FROM `irisoweb2_test`.`products` AS `Product` LEFT JOIN `irisoweb2_test`.`series` AS `Series` ON (`Product`.`series_id` = `Series`.`id`) WHERE `Product`.`series_id` = 414 AND `Product`.`status` = '有効' AND `Product`.`販売分類` <> 'EOS' GROUP BY `Product`.`series_id` ORDER BY Product.販売分類 ASC, `Product`.`odr` DESC, `Product`.`id` DESC LIMIT 1

SELECT COUNT(*) AS count, MAX(CAST(`極数` AS SIGNED)) AS 極数_max, MIN(CAST(`極数` AS SIGNED)) AS 極数_min, MAX(CAST(`嵌合部ピッチ` AS DECIMAL(10,3))) AS 嵌合部ピッチ_max, MIN(CAST(`嵌合部ピッチ` AS DECIMAL(10,3))) AS 嵌合部ピッチ_min, `Product`.`嵌合形状`, `Product`.`基板実装方法`, MAX(CAST(`本体高さ` AS DECIMAL(10,3))) AS 本体高さ_max, MIN(CAST(`本体高さ` AS DECIMAL(10,3))) AS 本体高さ_min, MAX(CAST(`定格電圧（AC）` AS DECIMAL(10,3))) AS 定格電圧（AC）_max, MIN(CAST(`定格電圧（AC）` AS DECIMAL(10,3))) AS 定格電圧（AC）_min, MAX(CAST(`定格電圧（DC）` AS DECIMAL(10,3))) AS 定格電圧（DC）_max, MIN(CAST(`定格電圧（DC）` AS DECIMAL(10,3))) AS 定格電圧（DC）_min, MAX(CAST(`定格電流` AS DECIMAL(10,3))) AS 定格電流_max, MIN(CAST(`定格電流` AS DECIMAL(10,3))) AS 定格電流_min, MAX(CAST(`耐電圧` AS DECIMAL(10,3))) AS 耐電圧_max, MIN(CAST(`耐電圧` AS DECIMAL(10,3))) AS 耐電圧_min, `Product`.`伝送速度（代表参考値）`, `Product`.`使用温度範囲（Max）`, `Product`.`フローティング機能`, `Product`.`振幅許容範囲`, `Product`.`2点接点`, `Product`.`ロック方式`, `Product`.`id` FROM `irisoweb2_test`.`products` AS `Product` LEFT JOIN `irisoweb2_test`.`series` AS `Series` ON (`Product`.`series_id` = `Series`.`id`) WHERE `Product`.`series_id` = 413 AND `Product`.`status` = '有効' AND `Product`.`販売分類` <> 'EOS' GROUP BY `Product`.`series_id` ORDER BY Product.販売分類 ASC, `Product`.`odr` DESC, `Product`.`id` DESC LIMIT 1

show columns from `products`

108

SELECT `AddField`.`id`, `AddField`.`name` FROM `irisoweb2_test`.`add_fields` AS `AddField` WHERE 1 = 1 ORDER BY `AddField`.`odr` ASC

SELECT `Category`.`id`, `Category`.`name_en` FROM `irisoweb2_test`.`categories` AS `Category` WHERE 1 = 1 ORDER BY `Category`.`odr` DESC, `Category`.`id` DESC

SELECT `Category`.`id`, `Category`.`status`, `Category`.`name`, `Category`.`name_en`, `Category`.`name_zh`, `Category`.`name_ko`, `Category`.`detail`, `Category`.`detail_en`, `Category`.`detail_zh`, `Category`.`detail_ko`, `Category`.`title`, `Category`.`title_en`, `Category`.`title_zh`, `Category`.`title_ko`, `Category`.`description`, `Category`.`description_en`, `Category`.`description_zh`, `Category`.`description_ko`, `Category`.`meta_keyword`, `Category`.`meta_keyword_en`, `Category`.`meta_keyword_zh`, `Category`.`meta_keyword_ko`, `Category`.`use_fields`, `Category`.`url`, `Category`.`header_title1`, `Category`.`header_title2`, `Category`.`header_title3`, `Category`.`header_title4`, `Category`.`header_url1`, `Category`.`header_url2`, `Category`.`header_url3`, `Category`.`header_url4`, `Category`.`odr`, `Category`.`created`, `Category`.`modified`, (CONCAT_WS( " ", IFNULL(`Category`.`name`, ""), IFNULL(`Category`.`name_en`, ""), IFNULL(`Category`.`name_zh`, ""), IFNULL(`Category`.`name_ko`, ""), IFNULL(`Category`.`detail`, ""), IFNULL(`Category`.`detail_en`, ""), IFNULL(`Category`.`detail_zh`, ""), IFNULL(`Category`.`detail_ko`, ""), IFNULL(`Category`.`url`, ""), IFNULL(`Category`.`header_title1`, ""), IFNULL(`Category`.`header_title2`, ""), IFNULL(`Category`.`header_title3`, ""), IFNULL(`Category`.`header_title4`, ""))) AS `Category__keyword` FROM `irisoweb2_test`.`categories` AS `Category` WHERE 1 = 1 ORDER BY `Category`.`odr` DESC, `Category`.`id` DESC

show columns from `products`

108

MOBILE PHONE BASE STATION INFRASTRUCTURE EQUIPMENT CONNECTOR（FPC / FFC Connectors） MOBILE PHONE BASE STATION INFRASTRUCTURE EQUIPMENT CONNECTOR （FPC / FFC Connectors）

MOBILE PHONE BASE STATION INFRASTRUCTURE EQUIPMENT CONNECTOR （FPC / FFC Connectors）

Change Filters. Close

Search by Conditions

Keyword Search

Category

Please Select a Category

Series

Please Select a Series

Pin

Pitch

Board Mounting Method

Mating Interface

High-Speed Transmission

Height

Voltage Rating (AC)

Voltage Rating (DC)

Current Rating

Withstand Voltage

High heat-resistant

Floating Function

Automation Connector

Buy Now

We propose cutting-edge solutions that combine the technologies that IRISO has cultivated over the years.

We propose cutting-edge solutions for the automotive market, centering on products for next-generation vehicles.

We propose optimal products for the consumer market such as information communication, video equipment, game equipment, and OA equipment.

We provide optimal products for the industrial market, such as industrial machinery, communication equipment, and medical equipment.

MOBILE PHONE BASE STATION INFRASTRUCTURE EQUIPMENT CONNECTOR（FPC / FFC Connectors） MOBILE PHONE BASE STATION INFRASTRUCTURE EQUIPMENT CONNECTOR
（FPC / FFC Connectors）