1 | SELECT `Configuration`.`key`, `Configuration`.`value` FROM `demoaffenbits_loris`.`configurations` AS `Configuration` WHERE 1 = 1 | | 22 | 22 | 0 |
2 | SELECT `Website`.`id`, `Website`.`key`, `Website`.`name`, `Website`.`description`, `Website`.`domain`, `Website`.`main`, `Website`.`created`, `Website`.`modified` FROM `demoaffenbits_loris`.`websites` AS `Website` WHERE `Website`.`main` = '1' LIMIT 1 | | 0 | 0 | 0 |
3 | SELECT `MenuItem`.`id`, `MenuItem`.`es_name`, `MenuItem`.`en_name`, `MenuItem`.`es_url`, `MenuItem`.`en_url`, `MenuItem`.`internal_id`, `MenuItem`.`controller`, `MenuItem`.`action`, `MenuItem`.`web_page_id`, `MenuItem`.`parent_id`, `MenuItem`.`lft`, `MenuItem`.`rght`, `MenuItem`.`type`, `MenuItem`.`position`, `MenuItem`.`order`, `MenuItem`.`target`, `MenuItem`.`website_id`, `MenuItem`.`created`, `MenuItem`.`modified`, `ParentItem`.`id`, `ParentItem`.`es_name`, `ParentItem`.`en_name`, `ParentItem`.`es_url`, `ParentItem`.`en_url`, `ParentItem`.`internal_id`, `ParentItem`.`controller`, `ParentItem`.`action`, `ParentItem`.`web_page_id`, `ParentItem`.`parent_id`, `ParentItem`.`lft`, `ParentItem`.`rght`, `ParentItem`.`type`, `ParentItem`.`position`, `ParentItem`.`order`, `ParentItem`.`target`, `ParentItem`.`website_id`, `ParentItem`.`created`, `ParentItem`.`modified`, `WebPage`.`id`, `WebPage`.`name`, `WebPage`.`shared_page_id`, `WebPage`.`active`, `WebPage`.`key`, `WebPage`.`es_key`, `WebPage`.`en_key`, `WebPage`.`es_meta_tags`, `WebPage`.`en_meta_tags`, `WebPage`.`user_id`, `WebPage`.`created`, `WebPage`.`modified` FROM `demoaffenbits_loris`.`menu_items` AS `MenuItem` LEFT JOIN `demoaffenbits_loris`.`menu_items` AS `ParentItem` ON (`MenuItem`.`parent_id` = `ParentItem`.`id`) LEFT JOIN `demoaffenbits_loris`.`web_pages` AS `WebPage` ON (`MenuItem`.`web_page_id` = `WebPage`.`id`) WHERE `MenuItem`.`position` = 'main' AND `MenuItem`.`website_id` IS NULL ORDER BY `MenuItem`.`order` ASC | | 0 | 0 | 0 |
4 | SELECT `MenuItem`.`id`, `MenuItem`.`es_name`, `MenuItem`.`en_name`, `MenuItem`.`es_url`, `MenuItem`.`en_url`, `MenuItem`.`internal_id`, `MenuItem`.`controller`, `MenuItem`.`action`, `MenuItem`.`web_page_id`, `MenuItem`.`parent_id`, `MenuItem`.`lft`, `MenuItem`.`rght`, `MenuItem`.`type`, `MenuItem`.`position`, `MenuItem`.`order`, `MenuItem`.`target`, `MenuItem`.`website_id`, `MenuItem`.`created`, `MenuItem`.`modified`, `ParentItem`.`id`, `ParentItem`.`es_name`, `ParentItem`.`en_name`, `ParentItem`.`es_url`, `ParentItem`.`en_url`, `ParentItem`.`internal_id`, `ParentItem`.`controller`, `ParentItem`.`action`, `ParentItem`.`web_page_id`, `ParentItem`.`parent_id`, `ParentItem`.`lft`, `ParentItem`.`rght`, `ParentItem`.`type`, `ParentItem`.`position`, `ParentItem`.`order`, `ParentItem`.`target`, `ParentItem`.`website_id`, `ParentItem`.`created`, `ParentItem`.`modified`, `WebPage`.`id`, `WebPage`.`name`, `WebPage`.`shared_page_id`, `WebPage`.`active`, `WebPage`.`key`, `WebPage`.`es_key`, `WebPage`.`en_key`, `WebPage`.`es_meta_tags`, `WebPage`.`en_meta_tags`, `WebPage`.`user_id`, `WebPage`.`created`, `WebPage`.`modified` FROM `demoaffenbits_loris`.`menu_items` AS `MenuItem` LEFT JOIN `demoaffenbits_loris`.`menu_items` AS `ParentItem` ON (`MenuItem`.`parent_id` = `ParentItem`.`id`) LEFT JOIN `demoaffenbits_loris`.`web_pages` AS `WebPage` ON (`MenuItem`.`web_page_id` = `WebPage`.`id`) WHERE `MenuItem`.`position` = 'header' AND `MenuItem`.`website_id` IS NULL ORDER BY `MenuItem`.`order` ASC | | 0 | 0 | 0 |
5 | SELECT `MenuItem`.`id`, `MenuItem`.`es_name`, `MenuItem`.`en_name`, `MenuItem`.`es_url`, `MenuItem`.`en_url`, `MenuItem`.`internal_id`, `MenuItem`.`controller`, `MenuItem`.`action`, `MenuItem`.`web_page_id`, `MenuItem`.`parent_id`, `MenuItem`.`lft`, `MenuItem`.`rght`, `MenuItem`.`type`, `MenuItem`.`position`, `MenuItem`.`order`, `MenuItem`.`target`, `MenuItem`.`website_id`, `MenuItem`.`created`, `MenuItem`.`modified`, `ParentItem`.`id`, `ParentItem`.`es_name`, `ParentItem`.`en_name`, `ParentItem`.`es_url`, `ParentItem`.`en_url`, `ParentItem`.`internal_id`, `ParentItem`.`controller`, `ParentItem`.`action`, `ParentItem`.`web_page_id`, `ParentItem`.`parent_id`, `ParentItem`.`lft`, `ParentItem`.`rght`, `ParentItem`.`type`, `ParentItem`.`position`, `ParentItem`.`order`, `ParentItem`.`target`, `ParentItem`.`website_id`, `ParentItem`.`created`, `ParentItem`.`modified`, `WebPage`.`id`, `WebPage`.`name`, `WebPage`.`shared_page_id`, `WebPage`.`active`, `WebPage`.`key`, `WebPage`.`es_key`, `WebPage`.`en_key`, `WebPage`.`es_meta_tags`, `WebPage`.`en_meta_tags`, `WebPage`.`user_id`, `WebPage`.`created`, `WebPage`.`modified` FROM `demoaffenbits_loris`.`menu_items` AS `MenuItem` LEFT JOIN `demoaffenbits_loris`.`menu_items` AS `ParentItem` ON (`MenuItem`.`parent_id` = `ParentItem`.`id`) LEFT JOIN `demoaffenbits_loris`.`web_pages` AS `WebPage` ON (`MenuItem`.`web_page_id` = `WebPage`.`id`) WHERE `MenuItem`.`position` = 'footer' AND `MenuItem`.`website_id` IS NULL ORDER BY `MenuItem`.`order` ASC | | 0 | 0 | 0 |
6 | SELECT `Banner`.`id`, `Banner`.`title_es`, `Banner`.`title_en`, `Banner`.`description_es`, `Banner`.`description_en`, `MediaMain`.`id`, `MediaMain`.`name`, `MediaMain`.`title`, `MediaMain`.`subtitle`, `MediaMain`.`alt`, `MediaMain`.`share_key`, `MediaMain`.`extra`, `MediaMain`.`type`, `MediaMain`.`model`, `MediaMain`.`foreign_key`, `MediaMain`.`collection`, `MediaMain`.`order`, `MediaMain`.`key`, `MediaMain`.`source`, `MediaMain`.`source_format`, `MediaMain`.`format`, `MediaMain`.`width`, `MediaMain`.`height`, `MediaMain`.`size`, `MediaMain`.`length`, `MediaMain`.`public`, `MediaMain`.`main`, `MediaMain`.`shared`, `MediaMain`.`is_file`, `MediaMain`.`created`, `MediaMain`.`modified` FROM `demoaffenbits_loris`.`banners` AS `Banner` LEFT JOIN `demoaffenbits_loris`.`media` AS `MediaMain` ON (`MediaMain`.`foreign_key` = `Banner`.`id` AND `MediaMain`.`model` = 'Banner' AND `MediaMain`.`collection` = 'main') WHERE 1 = 1 | | 0 | 0 | 0 |
7 | SELECT `SuccessStory`.`id`, `SuccessStory`.`title_es`, `SuccessStory`.`title_en`, `SuccessStory`.`description_en`, `SuccessStory`.`description_es`, `SuccessStory`.`description2_en`, `SuccessStory`.`description2_es` FROM `demoaffenbits_loris`.`success_stories` AS `SuccessStory` WHERE 1 = 1 | | 0 | 0 | 0 |