ソケットコネクタは、機器間の接続、内部接続に広く使用されています。ピンヘッダー(プラグ)との組み合わせにより、様々なアプリケーションに対応可能です。車載電装機器のLCD接続、基板とHDDの接続用としても広く使用されます。また、隣接する2本のポストを短絡させることができ、ロジック回路の切り替えやディップスイッチの代替として利用される短絡ソケット(ジャンパーソケット)などもご用意しております。
画像 | 製品名 | カテゴリ | シリーズ | 極数 | ピッチ(mm) | 基板実装方法 | 嵌合形状 | 本体高さ | 定格電圧-AC(V) | 定格電圧-DC(V) | 定格電流(A) | 耐電圧-AC(V) |
---|---|---|---|---|---|---|---|---|---|---|---|---|
比較検討リストのご利用には会員ログインが必要となります ![]() |
16104S シリーズ(4)4.0mmピッチ2P専用プラグコネクタ不要なワイヤー直差しソケット。定格電流3A、SMT実装。対応ワイヤー 単線: AWG#22, 撚線: AWG#24(半田上げ)。 |
ソケットコネクタ | 16104S | 2 | 4 | SMT | Horizon | 2.8 | 250 | 250 | 3 | 1600 |
比較検討リストのご利用には会員ログインが必要となります |
13016B シリーズ(1)4.0mmピッチ中継用2P専用ピンヘッダー。16104Sとの組み合わせで基板間を平行に接続可能。 |
ソケットコネクタ | 13016B | 2 | 2 | Horizon | 4.8 | 250 | 250 | 3 | 1600 | |
比較検討リストのご利用には会員ログインが必要となります |
9706S シリーズ(11)2.0mmピッチ・トップエントリーソケット。高さ4.2mm。4〜49極、2列。実装方法SMT/DIP有り。 |
ソケットコネクタ | 9706S | 4 - 22 | 2 | SMT | Stacking | 4.2 | 125 | 125 | 1 | 250 |
比較検討リストのご利用には会員ログインが必要となります |
9257S シリーズ(18)LCD接続用2.0mmピッチ・トップエントリーソケット。使用上限温度105℃。高さ8mm。タブサイズ幅0.5mmx厚さ0.3mm。6〜30極、1列、SMT実装。 |
ソケットコネクタ | 9257S | 6 - 30 | 2 | SMT | Stacking | 8 | 125 | 125 | 1 | 1000 |
比較検討リストのご利用には会員ログインが必要となります ![]() |
9242S シリーズ(25)LCD接続用2.0mmピッチ・トップエントリーソケット。使用上限温度105℃。高さ5.8mmのコンパクト設計。タブサイズ幅0.5mmx厚さ0.3mm。5〜28極、1列、SMT実装。 |
ソケットコネクタ | 9242S | 5 - 28 | 2 | SMT | Stacking | 5.8 | 125 | 125 | 1 | 500 |
比較検討リストのご利用には会員ログインが必要となります |
9241S シリーズ(3)HDD用2.0mmピッチライトアングルソケット。2列、DIP実装。 |
ソケットコネクタ | 9241S | 36 - 50 | 2 | DIP | Stacking | 5.1 - 8.4 | 125 | 125 | 1 | 250 |
比較検討リストのご利用には会員ログインが必要となります |
9240S シリーズ(15)LCD接続用2.0mmピッチ・ボトムエントリーソケット。使用上限温度105℃。タブサイズ幅0.5mmx厚さ0.3mm。10〜30極、1列、SMT実装。 |
ソケットコネクタ | 9240S | 6 - 22 | 2 | SMT | Stacking | 6.5 | 125 | 125 | 1 | 1000 |
比較検討リストのご利用には会員ログインが必要となります |
9162S シリーズ(9)2mmピッチ リジット ピン+ソケット ボトム嵌合 平行 SMT&DIP 2列 |
ソケットコネクタ | 9162S | 10 - 34 | 2 | DIP | Stacking | 4.2 | 125 | 125 | 1 | 250 |
比較検討リストのご利用には会員ログインが必要となります |
6223S シリーズ(1)1P専用プラグコネクタ不要なワイヤー直差しソケット。定格電流3A、SMT実装。対応ワイヤー 単線: AWG#22, 撚線: AWG#24(半田上げ)。 |
ソケットコネクタ | 6223S | 1 | 0 | SMT | Stacking | 6 | 250 | 250 | 5 | 0 |
ソケットコネクタのカスタム製品をご希望の場合は、別途お問い合わせ下さい。
Nr | Query | Error | Affected | Num. rows | Took (ms) |
---|---|---|---|---|---|
1 | show columns from `categories` | 35 | 35 | 1 | |
2 | SELECT `AddField`.`id`, `AddField`.`name` FROM `irisoweb_test`.`add_fields` AS `AddField` WHERE 1 = 1 ORDER BY `odr` ASC | 48 | 48 | 0 | |
3 | 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 `irisoweb_test`.`categories` AS `Category` WHERE `Category`.`url` = 'socket' LIMIT 1 | 1 | 1 | 1 | |
4 | 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 `irisoweb_test`.`attachments` AS `Attachment` WHERE `model` = 'Category' AND model_id = (3) | 1 | 1 | 6 | |
5 | 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 `irisoweb_test`.`series` AS `Series` LEFT JOIN `irisoweb_test`.`categories` AS `Category` ON (`Series`.`category_id` = `Category`.`id`) WHERE `Series`.`category_id` = 3 AND `Series`.`status` = '有効' ORDER BY `Series`.`odr` DESC, `Series`.`id` DESC LIMIT 20 | 9 | 9 | 2 | |
6 | 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 `irisoweb_test`.`downloads` AS `Download` WHERE `user_id` IS NULL AND `type` = 'FAV' AND `Download`.`series_id` IN (87, 59, 439, 351, 346, 345, 344, 306, 203) | 0 | 0 | 6 | |
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 `irisoweb_test`.`attachments` AS `Attachment` WHERE `model` = 'Series' AND `model_id` IN (87, 59, 439, 351, 346, 345, 344, 306, 203) | 2 | 2 | 6 | |
8 | 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 `irisoweb_test`.`products` AS `Product` LEFT JOIN `irisoweb_test`.`series` AS `Series` ON (`Product`.`series_id` = `Series`.`id`) WHERE `Product`.`series_id` = 87 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 | 17 | |
9 | 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 `irisoweb_test`.`downloads` AS `Download` WHERE `Download`.`product_id` = (587) | 0 | 0 | 6 | |
10 | 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 `irisoweb_test`.`attachments` AS `Attachment` WHERE `model` = 'Product' AND model_id = (587) | 2 | 2 | 6 | |
11 | 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 `irisoweb_test`.`products` AS `Product` LEFT JOIN `irisoweb_test`.`series` AS `Series` ON (`Product`.`series_id` = `Series`.`id`) WHERE `Product`.`series_id` = 59 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 | 17 | |
12 | 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 `irisoweb_test`.`downloads` AS `Download` WHERE `Download`.`product_id` = (498) | 0 | 0 | 6 | |
13 | 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 `irisoweb_test`.`attachments` AS `Attachment` WHERE `model` = 'Product' AND model_id = (498) | 1 | 1 | 6 | |
14 | 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 `irisoweb_test`.`products` AS `Product` LEFT JOIN `irisoweb_test`.`series` AS `Series` ON (`Product`.`series_id` = `Series`.`id`) WHERE `Product`.`series_id` = 439 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 | 17 | |
15 | 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 `irisoweb_test`.`downloads` AS `Download` WHERE `Download`.`product_id` = (8907) | 0 | 0 | 6 | |
16 | 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 `irisoweb_test`.`attachments` AS `Attachment` WHERE `model` = 'Product' AND model_id = (8907) | 2 | 2 | 6 | |
17 | 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 `irisoweb_test`.`products` AS `Product` LEFT JOIN `irisoweb_test`.`series` AS `Series` ON (`Product`.`series_id` = `Series`.`id`) WHERE `Product`.`series_id` = 351 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 | 16 | |
18 | 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 `irisoweb_test`.`downloads` AS `Download` WHERE `Download`.`product_id` = (5323) | 0 | 0 | 6 | |
19 | 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 `irisoweb_test`.`attachments` AS `Attachment` WHERE `model` = 'Product' AND model_id = (5323) | 2 | 2 | 6 | |
20 | 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 `irisoweb_test`.`products` AS `Product` LEFT JOIN `irisoweb_test`.`series` AS `Series` ON (`Product`.`series_id` = `Series`.`id`) WHERE `Product`.`series_id` = 346 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 | 16 | |
21 | 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 `irisoweb_test`.`downloads` AS `Download` WHERE `Download`.`product_id` = (5274) | 0 | 0 | 6 | |
22 | 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 `irisoweb_test`.`attachments` AS `Attachment` WHERE `model` = 'Product' AND model_id = (5274) | 2 | 2 | 6 | |
23 | 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 `irisoweb_test`.`products` AS `Product` LEFT JOIN `irisoweb_test`.`series` AS `Series` ON (`Product`.`series_id` = `Series`.`id`) WHERE `Product`.`series_id` = 345 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 | 17 | |
24 | 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 `irisoweb_test`.`downloads` AS `Download` WHERE `Download`.`product_id` = (5271) | 0 | 0 | 6 | |
25 | 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 `irisoweb_test`.`attachments` AS `Attachment` WHERE `model` = 'Product' AND model_id = (5271) | 2 | 2 | 6 | |
26 | 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 `irisoweb_test`.`products` AS `Product` LEFT JOIN `irisoweb_test`.`series` AS `Series` ON (`Product`.`series_id` = `Series`.`id`) WHERE `Product`.`series_id` = 344 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 | 16 | |
27 | 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 `irisoweb_test`.`downloads` AS `Download` WHERE `Download`.`product_id` = (5226) | 0 | 0 | 6 | |
28 | 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 `irisoweb_test`.`attachments` AS `Attachment` WHERE `model` = 'Product' AND model_id = (5226) | 1 | 1 | 7 | |
29 | 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 `irisoweb_test`.`products` AS `Product` LEFT JOIN `irisoweb_test`.`series` AS `Series` ON (`Product`.`series_id` = `Series`.`id`) WHERE `Product`.`series_id` = 306 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 | 17 | |
30 | 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 `irisoweb_test`.`downloads` AS `Download` WHERE `Download`.`product_id` = (2478) | 0 | 0 | 6 | |
31 | 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 `irisoweb_test`.`attachments` AS `Attachment` WHERE `model` = 'Product' AND model_id = (2478) | 2 | 2 | 6 | |
32 | 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 `irisoweb_test`.`products` AS `Product` LEFT JOIN `irisoweb_test`.`series` AS `Series` ON (`Product`.`series_id` = `Series`.`id`) WHERE `Product`.`series_id` = 203 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 | 17 | |
33 | 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 `irisoweb_test`.`downloads` AS `Download` WHERE `Download`.`product_id` = (1796) | 1 | 1 | 6 | |
34 | 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 `irisoweb_test`.`attachments` AS `Attachment` WHERE `model` = 'Product' AND model_id = (1796) | 2 | 2 | 6 | |
35 | show columns from `products` | 108 | 108 | 1 | |
36 | SELECT `AddField`.`id`, `AddField`.`name` FROM `irisoweb_test`.`add_fields` AS `AddField` WHERE 1 = 1 ORDER BY `AddField`.`odr` ASC | 48 | 48 | 0 | |
37 | SELECT `Category`.`id`, `Category`.`name` FROM `irisoweb_test`.`categories` AS `Category` WHERE 1 = 1 ORDER BY `Category`.`odr` DESC, `Category`.`id` DESC | 9 | 9 | 0 | |
38 | 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 `irisoweb_test`.`attachments` AS `Attachment` WHERE `model` = 'Category' AND `model_id` IN (1, 2, 3, 4, 5, 6, 7, 8, 9) | 10 | 10 | 6 | |
39 | 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 `irisoweb_test`.`categories` AS `Category` WHERE 1 = 1 ORDER BY `Category`.`odr` DESC, `Category`.`id` DESC | 9 | 9 | 1 | |
40 | 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 `irisoweb_test`.`attachments` AS `Attachment` WHERE `model` = 'Category' AND `model_id` IN (1, 2, 3, 4, 5, 6, 7, 8, 9) | 10 | 10 | 6 | |
41 | show columns from `products` | 108 | 108 | 1 |