| 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` = 'communication-robot' 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` = (38) | | 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 = (38) | | 1 | 1 | 7 |
| 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` = 'communication-robot' 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 = (38) | | 1 | 1 | 7 |
| 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` = 30 ORDER BY `Application`.`odr` ASC LIMIT 1 | | 1 | 1 | 1 |
| 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 = (30) | | 1 | 1 | 8 |
| 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` = 29 ORDER BY `Application`.`odr` ASC LIMIT 1 | | 1 | 1 | 2 |
| 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 = (29) | | 1 | 1 | 7 |
| 10 | SELECT `Category`.`id`, `Category`.`status`, `Category`.`name`, `Category`.`name_en`, `Category`.`name_zh`, `Category`.`name_ko`, `Category`.`detail`, `Category`.`detail_en`, `Category`.`detail_zh`, `Category`.`detail_ko`, `Category`.`title`, `Category`.`title_en`, `Category`.`title_zh`, `Category`.`title_ko`, `Category`.`description`, `Category`.`description_en`, `Category`.`description_zh`, `Category`.`description_ko`, `Category`.`meta_keyword`, `Category`.`meta_keyword_en`, `Category`.`meta_keyword_zh`, `Category`.`meta_keyword_ko`, `Category`.`use_fields`, `Category`.`url`, `Category`.`header_title1`, `Category`.`header_title2`, `Category`.`header_title3`, `Category`.`header_title4`, `Category`.`header_url1`, `Category`.`header_url2`, `Category`.`header_url3`, `Category`.`header_url4`, `Category`.`odr`, `Category`.`created`, `Category`.`modified`, (CONCAT_WS( " ", IFNULL(`Category`.`name`, ""), IFNULL(`Category`.`name_en`, ""), IFNULL(`Category`.`name_zh`, ""), IFNULL(`Category`.`name_ko`, ""), IFNULL(`Category`.`detail`, ""), IFNULL(`Category`.`detail_en`, ""), IFNULL(`Category`.`detail_zh`, ""), IFNULL(`Category`.`detail_ko`, ""), IFNULL(`Category`.`url`, ""), IFNULL(`Category`.`header_title1`, ""), IFNULL(`Category`.`header_title2`, ""), IFNULL(`Category`.`header_title3`, ""), IFNULL(`Category`.`header_title4`, ""))) AS `Category__keyword` FROM `irisoweb_test`.`categories` AS `Category` WHERE `Category`.`status` = '有効' AND `Category`.`url` = 'socket' LIMIT 1 | | 1 | 1 | 1 |
| 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` = 'Category' AND model_id = (3) | | 1 | 1 | 11 |
| 12 | SELECT `Series`.`id`, `Series`.`status`, `Series`.`name`, `Series`.`detail`, `Series`.`detail_en`, `Series`.`detail_zh`, `Series`.`detail_ko`, `Series`.`category_id`, `Series`.`html`, `Series`.`html_en`, `Series`.`html_zh`, `Series`.`html_ko`, `Series`.`title`, `Series`.`title_en`, `Series`.`title_zh`, `Series`.`title_ko`, `Series`.`description`, `Series`.`description_en`, `Series`.`description_zh`, `Series`.`description_ko`, `Series`.`keyword_en`, `Series`.`keyword_zh`, `Series`.`keyword_ko`, `Series`.`file_title1`, `Series`.`file_title2`, `Series`.`file_title3`, `Series`.`file_title4`, `Series`.`file_title5`, `Series`.`file_title6`, `Series`.`file_title7`, `Series`.`file_title8`, `Series`.`file_role1`, `Series`.`file_role2`, `Series`.`file_role3`, `Series`.`file_role4`, `Series`.`file_role5`, `Series`.`file_role6`, `Series`.`file_role7`, `Series`.`file_role8`, `Series`.`file_count1`, `Series`.`file_count2`, `Series`.`file_count3`, `Series`.`file_count4`, `Series`.`file_count5`, `Series`.`file_count6`, `Series`.`file_count7`, `Series`.`file_count8`, `Series`.`similar`, `Series`.`alternative`, `Series`.`combination`, `Series`.`ambiguous`, `Series`.`notice_pattern`, `Series`.`type1`, `Series`.`type2`, `Series`.`type3`, `Series`.`type4`, `Series`.`type5`, `Series`.`type6`, `Series`.`type7`, `Series`.`type8`, `Series`.`type9`, `Series`.`type10`, `Series`.`type11`, `Series`.`type12`, `Series`.`type13`, `Series`.`type14`, `Series`.`type15`, `Series`.`type16`, `Series`.`type17`, `Series`.`type18`, `Series`.`type19`, `Series`.`type20`, `Series`.`type21`, `Series`.`type22`, `Series`.`type23`, `Series`.`type24`, `Series`.`type25`, `Series`.`type26`, `Series`.`type27`, `Series`.`type28`, `Series`.`type29`, `Series`.`type30`, `Series`.`type_height1`, `Series`.`type_height2`, `Series`.`type_height3`, `Series`.`type_height4`, `Series`.`type_height5`, `Series`.`type_height6`, `Series`.`type_height7`, `Series`.`type_height8`, `Series`.`type_height9`, `Series`.`type_height10`, `Series`.`type_height11`, `Series`.`type_height12`, `Series`.`type_height13`, `Series`.`type_height14`, `Series`.`type_height15`, `Series`.`type_height16`, `Series`.`type_height17`, `Series`.`type_height18`, `Series`.`type_height19`, `Series`.`type_height20`, `Series`.`type_height21`, `Series`.`type_height22`, `Series`.`type_height23`, `Series`.`type_height24`, `Series`.`type_height25`, `Series`.`type_height26`, `Series`.`type_height27`, `Series`.`type_height28`, `Series`.`type_height29`, `Series`.`type_height30`, `Series`.`odr`, `Series`.`created`, `Series`.`modified`, (CONCAT_WS( " ", IFNULL(`Series`.`name`,""), IFNULL(`Series`.`detail`,""), IFNULL(`Series`.`detail_en`,""), IFNULL(`Series`.`detail_zh`,""), IFNULL(`Series`.`detail_ko`,""), IFNULL(`Series`.`similar`,""), IFNULL(`Series`.`alternative`,""), IFNULL(`Series`.`combination`,""), IFNULL(`Series`.`ambiguous`,""))) AS `Series__keyword`, `Category`.`id`, `Category`.`status`, `Category`.`name`, `Category`.`name_en`, `Category`.`name_zh`, `Category`.`name_ko`, `Category`.`detail`, `Category`.`detail_en`, `Category`.`detail_zh`, `Category`.`detail_ko`, `Category`.`title`, `Category`.`title_en`, `Category`.`title_zh`, `Category`.`title_ko`, `Category`.`description`, `Category`.`description_en`, `Category`.`description_zh`, `Category`.`description_ko`, `Category`.`meta_keyword`, `Category`.`meta_keyword_en`, `Category`.`meta_keyword_zh`, `Category`.`meta_keyword_ko`, `Category`.`use_fields`, `Category`.`url`, `Category`.`header_title1`, `Category`.`header_title2`, `Category`.`header_title3`, `Category`.`header_title4`, `Category`.`header_url1`, `Category`.`header_url2`, `Category`.`header_url3`, `Category`.`header_url4`, `Category`.`odr`, `Category`.`created`, `Category`.`modified`, (CONCAT_WS( " ", IFNULL(`Category`.`name`, ""), IFNULL(`Category`.`name_en`, ""), IFNULL(`Category`.`name_zh`, ""), IFNULL(`Category`.`name_ko`, ""), IFNULL(`Category`.`detail`, ""), IFNULL(`Category`.`detail_en`, ""), IFNULL(`Category`.`detail_zh`, ""), IFNULL(`Category`.`detail_ko`, ""), IFNULL(`Category`.`url`, ""), IFNULL(`Category`.`header_title1`, ""), IFNULL(`Category`.`header_title2`, ""), IFNULL(`Category`.`header_title3`, ""), IFNULL(`Category`.`header_title4`, ""))) AS `Category__keyword` FROM `irisoweb_test`.`series` AS `Series` LEFT JOIN `irisoweb_test`.`categories` AS `Category` ON (`Series`.`category_id` = `Category`.`id`) WHERE `Series`.`name` IN ('6801', '6802', '6803', '11501S', '11503S', '11600S', '12001S', '12002S', '12003S', '9604S', '9610S', '9611S', '9615S', '9616S', '9617S', '9618S', '9619S', '9631S', '9632S', '9634S', '9637S', '9639S', '9671S', '9681S', '9690S', '9691S', '9695S', '9697S', '9699S', '6661S', '6662S', '18010S', '16105T', '16106T', '16109T', '4039T', '4055T', '4056T', '4066T', '4067T', '4076T', '4080T', '4086T', '4099T', '4101T', '4102T', '4103T', '4104T', '16104S', '6223S', '9162S', '9241S', '9706S', '9203B', '9261B', '10101S', '10102B', '10102S', '10103B', '10103S', '10106B', '10106S', '10109B', '10109S', '10110B', '10112B', '10112S', '10121S', '10126B', '10126S', '11000S', '11007S', '9110B', '9110S', '9111B', '9111S', '9115B', '9115S', '9176B', '9179B', '9179S', '9180S', '9184B', '9195B', '9828S', '9850B', '9850S', '9851B', '9851S', '9852S', '9853B', '9854B', '9854S', '9855B', '9855S', '9856B', '9856S', '9857B', '9857S', '9890B', '9890S', '9892B', '9892S', '9984B', '9984S', '9985S') AND `Series`.`status` = '有効' AND `Category`.`url` = 'socket' ORDER BY `Series`.`odr` DESC, `Series`.`id` DESC LIMIT 20 | | 5 | 5 | 7 |
| 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 `user_id` IS NULL AND `type` = 'FAV' AND `Download`.`series_id` IN (87, 439, 345, 306, 203) | | 0 | 0 | 8 |
| 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` = 'Series' AND `model_id` IN (87, 439, 345, 306, 203) | | 1 | 1 | 8 |
| 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` = 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 |
| 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` = (587) | | 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 = (587) | | 2 | 2 | 6 |
| 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` = 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 |
| 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` = (8907) | | 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 = (8907) | | 2 | 2 | 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` = 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 |
| 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` = (5271) | | 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 = (5271) | | 2 | 2 | 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` = 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 |
| 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` = (2478) | | 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 = (2478) | | 2 | 2 | 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` = 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 |
| 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` = (1796) | | 1 | 1 | 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 = (1796) | | 2 | 2 | 6 |
| 30 | 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 |
| 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` = 'Category' AND `model_id` IN (1, 2, 3, 4, 5, 6, 7, 8, 9) | | 10 | 10 | 6 |
| 32 | show columns from `products` | | 108 | 108 | 1 |
| 33 | SELECT `AddField`.`id`, `AddField`.`name` FROM `irisoweb_test`.`add_fields` AS `AddField` WHERE 1 = 1 ORDER BY `AddField`.`odr` ASC | | 48 | 48 | 0 |
| 34 | 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 |
| 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` = 'Category' AND `model_id` IN (1, 2, 3, 4, 5, 6, 7, 8, 9) | | 10 | 10 | 7 |
| 36 | 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 |
| 37 | 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 | 7 |
| 38 | show columns from `products` | | 108 | 108 | 1 |
