| Query | Affected | Num. rows | Took (ms) | Actions |
|---|
| SELECT PageContent.id FROM page_contents PageContent INNER JOIN page_content_translations PageContentTranslation ON PageContentTranslation.page_content_id = PageContent.id INNER JOIN languages Language ON Language.code_link = "en" AND Language.id = PageContentTranslation.language_code_id WHERE PageContentTranslation.slug LIKE "historic-center" AND PageContent.page_type_id = 57 | 1 | 1 | 4 | maybe slow |
| SELECT PageType.id, PageType.order_pages, PageType.static_page, PageType.listing_page, PageType.collect_slug, PageType.booking_system, PageType.blog, PageTypeTranslation.* FROM page_types PageType INNER JOIN page_type_translations PageTypeTranslation ON PageTypeTranslation.page_type_id = PageType.id AND PageTypeTranslation.slug LIKE "enjoy" INNER JOIN languages Language ON Language.id = PageTypeTranslation.language_code_id AND Language.code_link = "en" WHERE PageType.is_homepage = 0 AND PageType.publish = 1 AND PageType.block = 0; | 0 | 0 | 2 | maybe slow |
| SELECT PageContent.id, PageContent.page_type_id, PageContent.google_maps_latitude, PageContent.google_maps_longitude, PageContent.image_id, PageContent.company_id, PageContent.page_type_associate, PageContent.website, PageContent.facebook, PageContent.instagram, PageContentTranslation.title, PageContentTranslation.seo_title, PageContentTranslation.subtitle, PageContentTranslation.introduction, PageContentTranslation.description, PageContentTranslation.slug, PageContentTranslation.seo_meta_description, PageContentTranslation.seo_meta_keywords, TopImage.id, TopImage.name, Image.id, Image.name FROM page_contents PageContent INNER JOIN page_content_translations PageContentTranslation ON PageContentTranslation.page_content_id = PageContent.id INNER JOIN page_types PageType ON PageType.id = PageContent.page_type_id INNER JOIN page_type_translations PageTypeTranslation ON PageTypeTranslation.page_type_id = PageType.id INNER JOIN languages Language ON Language.code_link = "en" AND Language.id = PageContentTranslation.language_code_id AND Language.id = PageTypeTranslation.language_code_id LEFT JOIN images TopImage ON TopImage.id = PageContent.top_image_id LEFT JOIN images Image ON Image.id = PageContent.image_id WHERE PageContentTranslation.slug = "enjoy" AND PageType.static_page = 0 | 1 | 1 | 9 | maybe slow |
| SELECT PageContent.id, PageContentTranslation.slug, Language.id, Language.code_link, Language.default_language FROM page_contents PageContent INNER JOIN page_content_translations PageContentTranslation ON PageContentTranslation.page_content_id = PageContent.id INNER JOIN languages Language ON Language.id = PageContentTranslation.language_code_id AND Language.publish = 1 WHERE PageContent.id = 219 | 2 | 2 | 1 | maybe slow |
| SELECT PageContentFaq.id, PageContentFaq.question, PageContentFaq.answer, PageContentFaq.faq_order FROM page_content_faqs PageContentFaq INNER JOIN languages Language ON Language.id = PageContentFaq.language_code_id AND Language.code_link = "en" WHERE PageContentFaq.page_content_id = 219 ORDER BY PageContentFaq.faq_order ASC; | 5 | 5 | 2 | maybe slow |
| SELECT PageContent.id, PageContentTranslation.title, PageContentTranslation.slug FROM page_contents PageContent INNER JOIN page_content_translations PageContentTranslation ON PageContentTranslation.page_content_id = PageContent.id INNER JOIN languages Language ON Language.code_link = "en" AND Language.id = PageContentTranslation.language_code_id WHERE PageContent.page_type_id = 57 AND PageContent.publish = 1 AND PageContent.group_of_pages = 0 ORDER BY PageContent.content_order ASC; | 4 | 4 | 7 | maybe slow |
| SELECT PageContent.id, PageContent.publish, PageContent.video_mp4_url, PageContent.video_webm_url, PageContent.video_mobile_mp4_url, PageContent.video_mobile_webm_url, PageContentTranslation.title, PageContentTranslation.subtitle, PageContentTranslation.slug, PageContentTranslation.introduction, Image.name, TopImage.name, MobileTopImage.name , Business.* FROM page_contents PageContent INNER JOIN page_content_translations PageContentTranslation ON PageContentTranslation.page_content_id = PageContent.id INNER JOIN languages Language ON Language.id = PageContentTranslation.language_code_id AND Language.code_link = "en" LEFT JOIN images Image ON Image.id = PageContent.image_id LEFT JOIN images TopImage ON TopImage.id = PageContent.top_image_id LEFT JOIN images MobileTopImage ON MobileTopImage.id = PageContent.mobile_top_image_id INNER JOIN ( SELECT PC.id AS TOT_ID, COUNT(*) AS TOT FROM page_contents PC INNER JOIN page_contents C ON C.page_type_associate LIKE CONCAT("%", PC.id, "%") WHERE C.publish = 1 AND C.associated_select_box_id = 261 GROUP BY PC.id ) as Business ON Business.TOT_ID = PageContent.id WHERE PageContent.publish = 1 AND PageContent.page_type_associate = 219 ORDER BY PageContent.content_order ASC; | 1 | 1 | 12 | maybe slow |
| SELECT `Language`.`id`, `Language`.`title`, `Language`.`flag` FROM `discover_discoverlagosdb2023`.`languages` AS `Language` WHERE `Language`.`code_link` = 'en' LIMIT 1 | 1 | 1 | 0 | |
| SELECT Language.id, Language.title, Language.code_link, Language.flag, Language.default_language FROM languages Language WHERE Language.publish = 1 ORDER BY Language.title ASC; | 2 | 2 | 0 | |
| SELECT PageType.id, PageType.is_homepage, PageTypeTranslation.id, PageTypeTranslation.title, PageTypeTranslation.slug FROM page_types PageType LEFT JOIN page_type_translations PageTypeTranslation ON PageTypeTranslation.page_type_id = PageType.id AND PageTypeTranslation.language_code_id = 3 WHERE PageType.show_on_menu = 1 AND PageType.publish = 1 AND PageType.block = 0 AND PageType.id <> 53 ORDER BY PageType.type_order ASC; | 1 | 1 | 0 | |
| SELECT PageContent.id, PageContentTranslation.id, PageContentTranslation.title, PageContentTranslation.subtitle, PageContentTranslation.slug FROM page_contents PageContent INNER JOIN page_content_translations PageContentTranslation ON PageContentTranslation.page_content_id = PageContent.id AND PageContentTranslation.language_code_id = 3 WHERE PageContent.page_type_id = 53 AND PageContent.publish = 1 AND PageContent.group_of_pages = 0 ORDER BY PageContent.content_order ASC; | 5 | 5 | 4 | maybe slow |
| SELECT PageType.id, PageTypeTranslation.id, PageTypeTranslation.title, PageTypeTranslation.slug FROM page_types PageType INNER JOIN page_type_translations PageTypeTranslation ON PageTypeTranslation.page_type_id = PageType.id AND PageTypeTranslation.language_code_id = 3 WHERE PageType.id = 64 AND PageType.publish = 1 ORDER BY PageType.type_order ASC; | 1 | 1 | 0 | |
| SELECT PageContent.id, PageContentTranslation.id, PageContentTranslation.title, PageContentTranslation.slug, PageTypeTranslation.slug FROM page_contents PageContent INNER JOIN page_content_translations PageContentTranslation ON PageContentTranslation.page_content_id = PageContent.id AND PageContentTranslation.language_code_id = 3 INNER JOIN page_types PageType ON PageType.id = PageContent.page_type_id INNER JOIN page_type_translations PageTypeTranslation ON PageTypeTranslation.page_type_id = PageType.id AND PageTypeTranslation.language_code_id = 3 WHERE PageContent.page_type_id = 59 AND PageContent.publish = 1 AND PageContent.group_of_pages = 0 ORDER BY PageContent.content_order ASC; | 4 | 4 | 4 | |
| SELECT PageContent.id, PageContentTranslation.id, PageContentTranslation.title, PageContentTranslation.slug, PageTypeTranslation.slug FROM page_contents PageContent INNER JOIN page_content_translations PageContentTranslation ON PageContentTranslation.page_content_id = PageContent.id AND PageContentTranslation.language_code_id = 3 INNER JOIN page_types PageType ON PageType.id = PageContent.page_type_id INNER JOIN page_type_translations PageTypeTranslation ON PageTypeTranslation.page_type_id = PageType.id AND PageTypeTranslation.language_code_id = 3 WHERE PageContent.page_type_id = 64 AND PageContent.publish = 1 AND PageContent.group_of_pages = 0 ORDER BY PageContent.content_order ASC; | 4 | 4 | 3 | maybe slow |
| SELECT ShopCategory.id, ShopCategoryTranslation.id, ShopCategoryTranslation.title, ShopCategoryTranslation.slug FROM shop_categories ShopCategory INNER JOIN shop_category_translations ShopCategoryTranslation ON ShopCategoryTranslation.category_id = ShopCategory.id AND ShopCategoryTranslation.language_code_id = 3 WHERE ShopCategory.publish = 1 ORDER BY ShopCategory.content_order ASC; | 3 | 3 | 1 | maybe slow |
| SELECT ShopProduct.id, ShopProduct.category_id, ShopProductTranslation.id, ShopProductTranslation.title, ShopProductTranslation.slug FROM shop_products ShopProduct INNER JOIN shop_product_translations ShopProductTranslation ON ShopProductTranslation.product_id = ShopProduct.id AND ShopProductTranslation.language_code_id = 3 WHERE ShopProduct.publish = 1 ORDER BY ShopProduct.category_id ASC, ShopProduct.content_order ASC; | 3 | 3 | 1 | maybe slow |
| SELECT PageType.id, PageType.is_homepage, PageType.type_footer_order, PageType.footer_column, PageTypeTranslation.id, PageTypeTranslation.title, PageTypeTranslation.slug FROM page_types PageType LEFT JOIN page_type_translations PageTypeTranslation ON PageTypeTranslation.page_type_id = PageType.id AND PageTypeTranslation.language_code_id = 3 WHERE PageType.show_on_footer_menu = 1 AND PageType.publish = 1 AND PageType.block = 0 ORDER BY PageType.type_footer_order ASC; | 5 | 5 | 0 | |
| SELECT PageContent.id, PageContentTranslation.title, PageContentTranslation.slug, PageContentTranslation.subtitle, PageContentTranslation.introduction FROM page_contents PageContent INNER JOIN page_content_translations PageContentTranslation ON PageContentTranslation.page_content_id = PageContent.id INNER JOIN languages Language ON Language.code_link = "en" AND Language.id = PageContentTranslation.language_code_id WHERE PageContent.page_type_id = 57 AND PageContent.publish = 1 ORDER BY PageContent.content_order ASC; | 5 | 5 | 3 | maybe slow |
| SELECT `Setting`.`website_title`, `Setting`.`website_link`, `Setting`.`social_networks_script`, `Setting`.`social_networks_div`, `Setting`.`google_analytics_script`, `Setting`.`email_contact`, `Setting`.`company_cellphone`, `Setting`.`company_cellphone_whatsapp`, `Setting`.`company_telephone`, `Setting`.`company_telephone_whatsapp`, `Setting`.`company_address_1`, `Setting`.`company_address_2`, `Setting`.`company_address_3`, `Setting`.`company_image_id`, `Setting`.`accept_payments`, `Setting`.`localhost_img_link_frontend`, `Image`.`id`, `Image`.`name` FROM `discover_discoverlagosdb2023`.`settings` AS `Setting` LEFT JOIN `discover_discoverlagosdb2023`.`images` AS `Image` ON (`Setting`.`company_image_id` = `Image`.`id`) WHERE 1 = 1 LIMIT 1 | 1 | 1 | 1 | |
| SELECT PageContentTranslation.id, PageContentTranslation.title, PageContentTranslation.introduction, PageContentTranslation.seo_meta_keywords, PageContentTranslation.seo_meta_description FROM page_contents PageContent INNER JOIN page_content_translations PageContentTranslation ON PageContentTranslation.page_content_id = PageContent.id AND PageContentTranslation.language_code_id = 3 WHERE PageContent.settings_page = 1 | 1 | 1 | 3 | maybe slow |
| SELECT PageContent.id, PageContentTranslation.title, PageContentTranslation.slug FROM page_contents PageContent INNER JOIN page_content_translations PageContentTranslation ON PageContentTranslation.page_content_id = PageContent.id INNER JOIN languages Language ON Language.id = PageContentTranslation.language_code_id AND Language.code_link = "en" WHERE PageContentTranslation.slug = "historic-center" | 1 | 1 | 1 | |
| SELECT PageContent.id, PageContentTranslation.id, PageContentTranslation.language_code_id, PageContentTranslation.slug FROM page_contents PageContent INNER JOIN page_content_translations PageContentTranslation ON PageContentTranslation.page_content_id = PageContent.id WHERE PageContentTranslation.slug = "enjoy?place=historic-center" | 0 | 0 | 0 | |
| SELECT PageType.id, PageTypeTranslation.id, PageTypeTranslation.language_code_id, PageTypeTranslation.slug FROM page_types PageType INNER JOIN page_type_translations PageTypeTranslation ON PageTypeTranslation.page_type_id = PageType.id WHERE PageTypeTranslation.slug = "enjoy?place=historic-center" | 0 | 0 | 0 | |
| SELECT WebsiteContact.id, WebsiteContact.type, WebsiteContact.contact_order, WebsiteContact.email_content, WebsiteContact.phone_country_code, WebsiteContact.phone_number, WebsiteContact.address_1, WebsiteContact.address_2, WebsiteContact.address_3, WebsiteContact.gps_lat, WebsiteContact.gps_lon, WebsiteContactContent.title, WebsiteContactContent.timetable_1, WebsiteContactContent.timetable_2 FROM website_contacts WebsiteContact LEFT JOIN website_contact_contents WebsiteContactContent ON WebsiteContactContent.website_contact_id = WebsiteContact.id AND WebsiteContactContent.language_code_id = 3 WHERE WebsiteContact.publish = 1 ORDER BY WebsiteContact.type DESC, WebsiteContact.contact_order ASC; | 0 | 0 | 1 | maybe slow |