ELECTRIC WATER PUMP / ELECTRIC OIL PUMP CONNECTORIf you would like a custom product, please contact us.
Nr | Query | Error | 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 `irisoweb_test`.`applications` AS `Application` WHERE `Application`.`url` = 'pump' LIMIT 1 | 1 | 1 | 1 | |
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 `irisoweb_test`.`applications` AS `Application` WHERE `Application`.`parent_id` = (18) | 0 | 0 | 1 | |
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 `irisoweb_test`.`attachments` AS `Attachment` WHERE `model` = 'Application' AND model_id = (18) | 1 | 1 | 6 | |
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 `irisoweb_test`.`applications` AS `Application` WHERE `Application`.`url` = 'pump' ORDER BY `Application`.`odr` ASC LIMIT 1 | 1 | 1 | 1 | |
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 `irisoweb_test`.`attachments` AS `Attachment` WHERE `model` = 'Application' AND model_id = (18) | 1 | 1 | 6 | |
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 `irisoweb_test`.`applications` AS `Application` WHERE `Application`.`id` = 11 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 `irisoweb_test`.`attachments` AS `Attachment` WHERE `model` = 'Application' AND model_id = (11) | 1 | 1 | 6 | |
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 `irisoweb_test`.`applications` AS `Application` WHERE `Application`.`id` = 1 ORDER BY `Application`.`odr` ASC LIMIT 1 | 1 | 1 | 1 | |
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 `irisoweb_test`.`attachments` AS `Attachment` WHERE `model` = 'Application' AND model_id = (1) | 1 | 1 | 6 | |
10 | 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`.`name` IN ('13065S', '9491B', '9203B', '10120B', '10120S', '10122B', '10122S', '9880B', '9880S') AND `Series`.`status` = '有効' ORDER BY `Series`.`odr` DESC, `Series`.`id` DESC LIMIT 20 | 9 | 9 | 2 | |
11 | 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 (79, 27, 26, 24, 23, 504, 503, 386, 329) | 0 | 0 | 6 | |
12 | 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 (79, 27, 26, 24, 23, 504, 503, 386, 329) | 8 | 8 | 6 | |
13 | 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` = 79 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 | |
14 | 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` = (555) | 1 | 1 | 6 | |
15 | 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 = (555) | 1 | 1 | 6 | |
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 `irisoweb_test`.`products` AS `Product` LEFT JOIN `irisoweb_test`.`series` AS `Series` ON (`Product`.`series_id` = `Series`.`id`) WHERE `Product`.`series_id` = 27 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 | |
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 `irisoweb_test`.`downloads` AS `Download` WHERE `Download`.`product_id` = (310) | 0 | 0 | 6 | |
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 `irisoweb_test`.`attachments` AS `Attachment` WHERE `model` = 'Product' AND model_id = (310) | 1 | 1 | 6 | |
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 `irisoweb_test`.`products` AS `Product` LEFT JOIN `irisoweb_test`.`series` AS `Series` ON (`Product`.`series_id` = `Series`.`id`) WHERE `Product`.`series_id` = 26 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 | |
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 `irisoweb_test`.`downloads` AS `Download` WHERE `Download`.`product_id` = (309) | 1 | 1 | 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 `irisoweb_test`.`attachments` AS `Attachment` WHERE `model` = 'Product' AND model_id = (309) | 2 | 2 | 6 | |
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 `irisoweb_test`.`products` AS `Product` LEFT JOIN `irisoweb_test`.`series` AS `Series` ON (`Product`.`series_id` = `Series`.`id`) WHERE `Product`.`series_id` = 24 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 | |
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 `irisoweb_test`.`downloads` AS `Download` WHERE `Download`.`product_id` = (282) | 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 `irisoweb_test`.`attachments` AS `Attachment` WHERE `model` = 'Product' AND model_id = (282) | 2 | 2 | 6 | |
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 `irisoweb_test`.`products` AS `Product` LEFT JOIN `irisoweb_test`.`series` AS `Series` ON (`Product`.`series_id` = `Series`.`id`) WHERE `Product`.`series_id` = 23 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 | |
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 `irisoweb_test`.`downloads` AS `Download` WHERE `Download`.`product_id` = (270) | 1 | 1 | 6 | |
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 `irisoweb_test`.`attachments` AS `Attachment` WHERE `model` = 'Product' AND model_id = (270) | 2 | 2 | 6 | |
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 `irisoweb_test`.`products` AS `Product` LEFT JOIN `irisoweb_test`.`series` AS `Series` ON (`Product`.`series_id` = `Series`.`id`) WHERE `Product`.`series_id` = 504 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 | |
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 `irisoweb_test`.`downloads` AS `Download` WHERE `Download`.`product_id` = (11048) | 0 | 0 | 6 | |
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 `irisoweb_test`.`attachments` AS `Attachment` WHERE `model` = 'Product' AND model_id = (11048) | 0 | 0 | 6 | |
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 `irisoweb_test`.`products` AS `Product` LEFT JOIN `irisoweb_test`.`series` AS `Series` ON (`Product`.`series_id` = `Series`.`id`) WHERE `Product`.`series_id` = 503 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 | |
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 `irisoweb_test`.`downloads` AS `Download` WHERE `Download`.`product_id` = (11047) | 0 | 0 | 6 | |
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 `irisoweb_test`.`attachments` AS `Attachment` WHERE `model` = 'Product' AND model_id = (11047) | 0 | 0 | 6 | |
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 `irisoweb_test`.`products` AS `Product` LEFT JOIN `irisoweb_test`.`series` AS `Series` ON (`Product`.`series_id` = `Series`.`id`) WHERE `Product`.`series_id` = 386 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 | |
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 `irisoweb_test`.`downloads` AS `Download` WHERE `Download`.`product_id` = (5810) | 0 | 0 | 6 | |
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 `irisoweb_test`.`attachments` AS `Attachment` WHERE `model` = 'Product' AND model_id = (5810) | 2 | 2 | 6 | |
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 `irisoweb_test`.`products` AS `Product` LEFT JOIN `irisoweb_test`.`series` AS `Series` ON (`Product`.`series_id` = `Series`.`id`) WHERE `Product`.`series_id` = 329 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 | |
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 `irisoweb_test`.`downloads` AS `Download` WHERE `Download`.`product_id` = (3385) | 1 | 1 | 6 | |
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 `irisoweb_test`.`attachments` AS `Attachment` WHERE `model` = 'Product' AND model_id = (3385) | 1 | 1 | 6 | |
40 | 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`.`status` = '有効' | 9 | 9 | 1 | |
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` = 'Category' AND `model_id` IN (1, 2, 3, 4, 5, 6, 7, 8, 9) | 10 | 10 | 6 | |
42 | show columns from `products` | 108 | 108 | 1 | |
43 | SELECT `AddField`.`id`, `AddField`.`name` FROM `irisoweb_test`.`add_fields` AS `AddField` WHERE 1 = 1 ORDER BY `AddField`.`odr` ASC | 48 | 48 | 0 | |
44 | SELECT `Category`.`id`, `Category`.`name_en` FROM `irisoweb_test`.`categories` AS `Category` WHERE 1 = 1 ORDER BY `Category`.`odr` DESC, `Category`.`id` DESC | 9 | 9 | 0 | |
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 `irisoweb_test`.`attachments` AS `Attachment` WHERE `model` = 'Category' AND `model_id` IN (1, 2, 3, 4, 5, 6, 7, 8, 9) | 10 | 10 | 6 | |
46 | 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 | |
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` = 'Category' AND `model_id` IN (1, 2, 3, 4, 5, 6, 7, 8, 9) | 10 | 10 | 6 | |
48 | show columns from `products` | 108 | 108 | 1 |