基板対基板用コネクタ(BtoB)は、プリント基板の高密度実装用に開発されたコネクタです。中でも接続したコネクタが、ピッチ方向、列間方向、嵌合方向のすべて、またはいずれかに可動し、その嵌合ずれを吸収するように設計されたフローティングコネクタは、ソケットとプラグの組合わせにより、平面状のX-Y-Z方向に可動し、こじり(衝撃)、位置ズレなどに強い設計構造を持った製品群です。イリソのフローティングコネクタは、0.4~2.0mmピッチ、嵌合高さ4~30mmの圧倒的なバリエーションを誇る<b>イリソの主要製品</b>です。
画像 | 製品名 | カテゴリ | シリーズ | 極数 | ピッチ(mm) | 基板実装方法 | 嵌合形状 | 本体高さ | 定格電圧-AC(V) | 定格電圧-DC(V) | 定格電流(A) | 耐電圧-AC(V) |
---|---|---|---|---|---|---|---|---|---|---|---|---|
比較検討リストのご利用には会員ログインが必要となります ![]() |
9855B シリーズ(19)1.0mmピッチ、フローティングタイプ平行接続(ST/ST)BtoBコネクタ。可動(フローティング)構造でX-Y方向に0.5mm、Z方向は0.4mm有効嵌合長。(組み合わせにより可動範囲は異なります。)嵌合コネクタにより各種基板間寸法に対応。 |
基板対基板コネクタ | 9855B | 8 - 30 | 1 | SMT | Stacking | 4.4 | 125 | 125 | 1 | 250 |
比較検討リストのご利用には会員ログインが必要となります ![]() |
9854S シリーズ(17)1.0mmピッチ、フローティングタイプ平行接続(ST/ST)BtoBコネクタ。可動(フローティング)構造でX-Y-Z方向にX/Y/Z:±0.8/±0.5/±0.8可動構造。(組み合わせにより可動範囲は異なります。)嵌合コネクタにより各種基板間寸法に対応。 |
基板対基板コネクタ | 9854S | 6 - 30 | 1 | SMT | Stacking | 8 | 125 | 125 | 1 | 250 |
比較検討リストのご利用には会員ログインが必要となります ![]() |
9854B シリーズ(12)1.0mmピッチ、フローティングタイプ平行接続(ST/ST)BtoBコネクタ。可動(フローティング)構造でX-Y-Z方向にX/Y/Z:±0.8/±0.5/±0.8可動構造。(組み合わせにより可動範囲は異なります。)嵌合コネクタにより各種基板間寸法に対応。 |
基板対基板コネクタ | 9854B | 6 - 30 | 1 | DIP | Stacking | 11.4 | 125 | 125 | 1 | 250 |
比較検討リストのご利用には会員ログインが必要となります ![]() |
9853S シリーズ(13)1.0mmピッチ、フローティングタイプBtoBコネクタ。可動(フローティング)構造でX-Y-Z方向にX/Y/Z:±0.8/±0.5/±0.8可動構造。(組み合わせにより可動範囲は異なります。)嵌合コネクタにより各種基板間寸法に対応。 |
基板対基板コネクタ | 9853S | 6 - 28 | 1 | SMT | RightAngle | 5.225 | 125 | 125 | 1 | 250 |
比較検討リストのご利用には会員ログインが必要となります ![]() |
フローティングコネクタ オートメーションコネクタ9853B シリーズ(38)1.0mmピッチ、フローティングタイプ平行接続(ST/ST)BtoBコネクタ。可動(フローティング)構造でX-Y-Z方向にX/Y:±0.8/±0.5/ Z方向は0.8mmの有効嵌合長。(組み合わせにより可動範囲は異なります。)嵌合コネクタにより各種基板間寸法に対応。 |
基板対基板コネクタ | 9853B | 6 - 30 | 1 | SMT | RightAngle | 6.8 | 125 | 125 | 1 | 250 |
比較検討リストのご利用には会員ログインが必要となります ![]() |
フローティングコネクタ オートメーションコネクタ9852S シリーズ(15)1.0mmピッチ、フローティングタイプ平行接続(ST/ST)BtoBコネクタ。可動(フローティング)構造でX-Y方向に0.5mm、Z方向は0.4mm有効嵌合長。(組み合わせにより可動範囲は異なります。)嵌合コネクタにより各種基板間寸法に対応。 |
基板対基板コネクタ | 9852S | 6 - 30 | 1 | SMT | Stacking | 6.5 | 125 | 125 | 1 | 250 |
比較検討リストのご利用には会員ログインが必要となります ![]() |
フローティングコネクタ オートメーションコネクタ9851S シリーズ(25)1.0mmピッチ、フローティングタイプ平行接続(ST/ST)BtoBコネクタ。可動(フローティング)構造でX-Y方向に0.5mm、Z方向は0.4mm有効嵌合長。(組み合わせにより可動範囲は異なります。)嵌合コネクタにより各種基板間寸法に対応。 |
基板対基板コネクタ | 9851S | 6 - 30 | 1 | SMT | Stacking | 3.85 | 125 | 125 | 1 | 250 |
比較検討リストのご利用には会員ログインが必要となります ![]() |
フローティングコネクタ オートメーションコネクタ9851B シリーズ(16)1.0mmピッチ、フローティングタイプ平行接続(ST/ST)BtoBコネクタ。可動(フローティング)構造でX-Y方向に0.5mm、Z方向は0.4mm有効嵌合長。(組み合わせにより可動範囲は異なります。)嵌合コネクタにより各種基板間寸法に対応。 |
基板対基板コネクタ | 9851B | 6 - 30 | 1 | SMT | Stacking | 5 | 125 | 125 | 1 | 250 |
比較検討リストのご利用には会員ログインが必要となります ![]() |
フローティングコネクタ オートメーションコネクタ9850S シリーズ(54)1.0mmピッチ、フローティングタイプ垂直接続(ST/RA)BtoBコネクタ。可動(フローティング)構造でX-Y方向に0.5mm、Z方向は0.4mmの有効嵌合長。(組み合わせにより可動範囲は異なります。)嵌合コネクタにより各種基板間寸法に対応。 |
基板対基板コネクタ | 9850S | 6 - 30 | 1 | SMT | RightAngle | 5 | 125 | 125 | 1 | 250 |
比較検討リストのご利用には会員ログインが必要となります ![]() |
フローティングコネクタ オートメーションコネクタ9850B シリーズ(34)1.0mmピッチ、フローティングタイプ平行接続(ST/ST)BtoBコネクタ。可動(フローティング)構造でX-Y方向に0.5mm、Z方向は0.4mmの有効嵌合長。(組み合わせにより可動範囲は異なります。)嵌合コネクタにより各種基板間寸法に対応。 |
基板対基板コネクタ | 9850B | 6 - 30 | 1 | DIP | RightAngle | 5 | 125 | 125 | 1 | 250 |
比較検討リストのご利用には会員ログインが必要となります ![]() |
9828S シリーズ(14)デジタル信号の高速伝送を可能とする0.8mmピッチ、フローティングタイプ平行接続(ST/ST)BtoBコネクタ。可動(フローティング)構造でX-Y方向に0.5mm可動。Z方向は0.5mmの有効嵌合長。1.6Gbps(自社定義による代表参考値)の高速伝送に対応。インピーダンスマッチング:差動100Ω。 |
基板対基板コネクタ | 9828S | 30 - 100 | 0.8 | SMT | RightAngle | 8.45 | 50 | 50 | 0.5 | 250 |
比較検討リストのご利用には会員ログインが必要となります ![]() |
9828B シリーズ(12)0.8mmピッチ、フローティングタイプBtoBコネクタ。可動(フローティング)構造でX-Y-Z方向に0.5mm可動構造。省スペース化を実現。 |
基板対基板コネクタ | 9828B | 30 - 90 | 0.8 | SMT | RightAngle | 6.7 | 50 | 50 | 0.5 | 250 |
比較検討リストのご利用には会員ログインが必要となります ![]() |
9827S シリーズ(10)デジタル信号の高速伝送を可能とする0.8mmピッチ、フローティングタイプ平行接続(ST/ST)BtoBコネクタ。可動(フローティング)構造でX-Y方向に0.5mm可動。Z方向は0.5mmの有効嵌合長。5.0Gbps(自社定義による代表参考値)の高速伝送に対応。インピーダンスマッチング:差動100Ω。 |
基板対基板コネクタ | 9827S | 30 - 80 | 0.8 | SMT | Stacking | 4.95 | 50 | 50 | 0.5 | 250 |
比較検討リストのご利用には会員ログインが必要となります ![]() |
9827B シリーズ(33)デジタル信号の高速伝送を可能とする0.8mmピッチ、フローティングタイプ平行接続(ST/ST)BtoBコネクタ。可動(フローティング)構造でX-Y方向に0.5mm可動。Z方向は0.5mmの有効嵌合長。5.0Gbps(自社定義による代表参考値)の高速伝送に対応。インピーダンスマッチング:差動100Ω。 |
基板対基板コネクタ | 9827B | 30 - 120 | 0.8 | SMT | Stacking | 4.8 - 7.8 | 50 | 50 | 0.5 | 250 |
比較検討リストのご利用には会員ログインが必要となります |
9735S シリーズ(2)2.0mmピッチ、フローティングタイプ垂直接続(ST/RA)BtoBコネクタ。可動(フローティング)構造でX-Y方向に1.0mm/Z方向は2.0mmの有効嵌合長。 |
基板対基板コネクタ | 9735S | 18 - 26 | 2 | SMT | RightAngle | 10.5 | 125 | 125 | 1.5 | 250 |
比較検討リストのご利用には会員ログインが必要となります |
9735B シリーズ(4)2.0mmピッチ、フローティングタイプ垂直接続(ST/RA)BtoBコネクタ。可動(フローティング)構造でX-Y方向に1.0mm/Z方向は2.0mmの有効嵌合長。 |
基板対基板コネクタ | 9735B | 8 - 30 | 2 | DIP | RightAngle | 8.1 | 125 | 125 | 1.5 | 250 |
比較検討リストのご利用には会員ログインが必要となります |
9195B シリーズ(2)2.0mmピッチ 2列ピンヘッダー 2.0mmピッチのソケットとの接続が可能 |
基板対基板コネクタ | 9195B | 24 - 30 | 2 | DIP | RightAngle | 25.45 - 35.1 | 125 | 125 | 1 | 250 |
比較検討リストのご利用には会員ログインが必要となります |
9184B シリーズ(9)2.0mmピッチ ピンヘッダー 2列 RAタイプ |
基板対基板コネクタ | 9184B | 6 - 26 | 2 | DIP | RightAngle | 8.1 | 125 | 125 | 1 | 250 |
比較検討リストのご利用には会員ログインが必要となります |
9180S シリーズ(12)2.0mmピッチ、2列のフローティングタイプコネクタ。プラグ側(B)の変更で垂直接続(ST/RA)、水平接続(ST/ST)変更可能なBtoソケットコネクタ。(フローティング)構造でX-Y方向に0.5mm/Z方向は0.5mmの有効嵌合長。 |
基板対基板コネクタ | 9180S | 6 - 30 | 2 | DIP | Stacking | 8.4 | 125 | 125 | 1 | 250 |
比較検討リストのご利用には会員ログインが必要となります |
9180B シリーズ(10)2.0mmピッチ、フローティングタイプ平行接続(ST/ST)BtoBコネクタ。可動(フローティング)構造でX-Y方向に0.5mm可動。Z方向は0.5mmの有効嵌合長。ピンヘッダーとの接続が可能で多彩な高さ調整が可能 |
基板対基板コネクタ | 9180B | 6 - 30 | 2 | DIP | Stacking | 11.2 | 125 | 125 | 1 | 250 |
基板対基板コネクタのカスタム製品をご希望の場合は、別途お問い合わせ下さい。
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 | 1 | |
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` = 'board-to-board' 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 = (1) | 2 | 2 | 8 | |
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` = 1 AND `Series`.`status` = '有効' ORDER BY `Series`.`odr` DESC, `Series`.`id` DESC LIMIT 40, 20 | 20 | 20 | 6 | |
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 (490, 489, 488, 487, 486, 485, 483, 482, 481, 480, 468, 467, 466, 465, 451, 450, 324, 317, 316, 315) | 0 | 0 | 7 | |
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 (490, 489, 488, 487, 486, 485, 483, 482, 481, 480, 468, 467, 466, 465, 451, 450, 324, 317, 316, 315) | 34 | 34 | 8 | |
8 | SELECT COUNT(*) AS `count` FROM `irisoweb_test`.`series` AS `Series` LEFT JOIN `irisoweb_test`.`categories` AS `Category` ON (`Series`.`category_id` = `Category`.`id`) WHERE `Series`.`category_id` = 1 AND `Series`.`status` = '有効' | 1 | 1 | 1 | |
9 | 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` = 490 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 | |
10 | 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` = (10665) | 0 | 0 | 6 | |
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 `irisoweb_test`.`attachments` AS `Attachment` WHERE `model` = 'Product' AND model_id = (10665) | 2 | 2 | 10 | |
12 | 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` = 489 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 | 27 | |
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 `irisoweb_test`.`downloads` AS `Download` WHERE `Download`.`product_id` = (10611) | 0 | 0 | 9 | |
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 `irisoweb_test`.`attachments` AS `Attachment` WHERE `model` = 'Product' AND model_id = (10611) | 1 | 1 | 10 | |
15 | 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` = 488 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 | 23 | |
16 | 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` = (10591) | 0 | 0 | 6 | |
17 | 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 = (10591) | 2 | 2 | 8 | |
18 | 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` = 487 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 | 24 | |
19 | 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` = (10557) | 0 | 0 | 6 | |
20 | 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 = (10557) | 3 | 3 | 6 | |
21 | 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` = 486 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 | |
22 | 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` = (10500) | 0 | 0 | 6 | |
23 | 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 = (10500) | 3 | 3 | 6 | |
24 | 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` = 485 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 | |
25 | 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` = (10413) | 0 | 0 | 6 | |
26 | 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 = (10413) | 3 | 3 | 6 | |
27 | 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` = 483 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 | |
28 | 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` = (10305) | 0 | 0 | 6 | |
29 | 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 = (10305) | 3 | 3 | 6 | |
30 | 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` = 482 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 | |
31 | 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` = (10243) | 2 | 2 | 6 | |
32 | 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 = (10243) | 3 | 3 | 6 | |
33 | 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` = 481 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 | |
34 | 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` = (9913) | 0 | 0 | 6 | |
35 | 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 = (9913) | 2 | 2 | 7 | |
36 | 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` = 480 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 | |
37 | 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` = (9662) | 0 | 0 | 6 | |
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` = 'Product' AND model_id = (9662) | 3 | 3 | 6 | |
39 | 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` = 468 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 | |
40 | 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` = (9394) | 0 | 0 | 6 | |
41 | 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 = (9394) | 3 | 3 | 6 | |
42 | 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` = 467 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 | 19 | |
43 | 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` = (9318) | 0 | 0 | 6 | |
44 | 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 = (9318) | 3 | 3 | 7 | |
45 | 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` = 466 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 | |
46 | 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` = (9204) | 0 | 0 | 6 | |
47 | 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 = (9204) | 3 | 3 | 7 | |
48 | 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` = 465 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 | |
49 | 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` = (9087) | 0 | 0 | 6 | |
50 | 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 = (9087) | 3 | 3 | 6 | |
51 | 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` = 451 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 | |
52 | 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` = (9053) | 0 | 0 | 6 | |
53 | 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 = (9053) | 2 | 2 | 6 | |
54 | 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` = 450 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 | |
55 | 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` = (9047) | 0 | 0 | 6 | |
56 | 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 = (9047) | 2 | 2 | 6 | |
57 | 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` = 324 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 | |
58 | 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` = (2690) | 0 | 0 | 6 | |
59 | 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 = (2690) | 2 | 2 | 6 | |
60 | 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` = 317 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 | |
61 | 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` = (2660) | 0 | 0 | 6 | |
62 | 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 = (2660) | 1 | 1 | 6 | |
63 | 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` = 316 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 | |
64 | 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` = (2619) | 2 | 2 | 6 | |
65 | 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 = (2619) | 2 | 2 | 7 | |
66 | 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` = 315 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 | |
67 | 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` = (2597) | 1 | 1 | 6 | |
68 | 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 = (2597) | 2 | 2 | 6 | |
69 | show columns from `products` | 108 | 108 | 1 | |
70 | SELECT `AddField`.`id`, `AddField`.`name` FROM `irisoweb_test`.`add_fields` AS `AddField` WHERE 1 = 1 ORDER BY `AddField`.`odr` ASC | 48 | 48 | 0 | |
71 | 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 | |
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 `irisoweb_test`.`attachments` AS `Attachment` WHERE `model` = 'Category' AND `model_id` IN (1, 2, 3, 4, 5, 6, 7, 8, 9) | 10 | 10 | 6 | |
73 | 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 | |
74 | 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 | |
75 | show columns from `products` | 108 | 108 | 1 |