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` = 'adas' LIMIT 1 | | 1 | 1 | 2 |
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` = (2) | | 8 | 8 | 1 |
3 | 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` IN (3, 4, 5, 6, 7, 8, 9, 10) | | 0 | 0 | 0 |
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` = 'Application' AND model_id = (2) | | 1 | 1 | 6 |
5 | 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` = 'adas' ORDER BY `Application`.`odr` ASC LIMIT 1 | | 1 | 1 | 1 |
6 | 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 = (2) | | 1 | 1 | 7 |
7 | 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` = '2' ORDER BY `Application`.`odr` ASC | | 8 | 8 | 1 |
8 | 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` IN (3, 4, 5, 6, 7, 8, 9, 10) | | 8 | 8 | 8 |
9 | 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 |
10 | SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`model_id`, `Attachment`.`field_name`, `Attachment`.`file_name`, `Attachment`.`file_content_type`, `Attachment`.`file_size`, `Attachment`.`created`, `Attachment`.`modified` FROM `irisoweb_test`.`attachments` AS `Attachment` WHERE `model` = 'Application' AND model_id = (1) | | 1 | 1 | 7 |