| 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 | 1 | |
| 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 "about-the-project" 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; | 1 | 1 | 0 | |
| SELECT PageType.id, PageTypeTranslation.slug, Language.id, Language.code_link, Language.default_language FROM page_types PageType INNER JOIN page_type_translations PageTypeTranslation ON PageTypeTranslation.page_type_id = PageType.id INNER JOIN languages Language ON Language.id = PageTypeTranslation.language_code_id AND Language.publish = 1 WHERE PageType.id = 24 | 2 | 2 | 0 | |
| SELECT PageType.*, PageTypeTranslation.id, PageTypeTranslation.title, PageTypeTranslation.slug, PageContent.*, PageContentTranslation.id, PageContentTranslation.slug, PageContentTranslation.title, PageContentTranslation.seo_title, PageContentTranslation.subtitle, PageContentTranslation.introduction, PageContentTranslation.description, PageContentTranslation.description_complement, PageContentTranslation.seo_meta_description, PageContentTranslation.seo_meta_keywords, Image.id, Image.name, TopImage.id, TopImage.name FROM page_types PageType INNER JOIN page_contents PageContent ON PageContent.page_type_id = PageType.id AND PageContent.publish = 1 AND PageContent.group_of_pages = 0 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" INNER JOIN page_type_translations PageTypeTranslation ON PageTypeTranslation.page_type_id = PageType.id AND PageTypeTranslation.language_code_id = Language.id LEFT JOIN images Image ON Image.id = PageContent.image_id LEFT JOIN images TopImage ON TopImage.id = PageContent.top_image_id WHERE PageType.id = 24 AND PageType.publish = 1 AND PageType.block = 0 AND ((PageType.collect_slug = 1 AND PageContentTranslation.slug LIKE "about-the-project") OR (PageType.collect_slug = 0) OR (PageType.collect_slug = 1 AND PageTypeTranslation.slug LIKE "about-the-project")); | 1 | 1 | 4 | maybe slow |
| SELECT Promotion.id, Promotion.discount, PromotionContent.id, PromotionContent.title FROM promotions Promotion INNER JOIN promotion_contents PromotionContent ON PromotionContent.promotion_id = Promotion.id INNER JOIN languages Language ON Language.id = PromotionContent.language_code_id AND Language.code_link = "en" WHERE Promotion.publish = 1; | 0 | 0 | 1 | maybe slow |
| SELECT PageContentTranslation.id, PageContentTranslation.title 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 PageContent.settings_page = 1 | 1 | 1 | 3 | maybe slow |
| SELECT Image.id, Image.name, Image.gallery_id, Image.image_order, ImageContent.id, ImageContent.title FROM page_contents PageContent INNER JOIN galleries Gallery ON Gallery.page_content_id = PageContent.id AND Gallery.product_type_id IS NULL AND Gallery.mobile = 0 LEFT JOIN images Image ON Image.gallery_id = Gallery.id INNER JOIN image_contents ImageContent ON ImageContent.image_id = Image.id INNER JOIN languages Language ON Language.id = ImageContent.language_code_id AND Language.code_link = "en" WHERE PageContent.id = 48 AND PageContent.publish = 1 ORDER BY Image.image_order DESC | 0 | 0 | 6 | 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 = 48 ORDER BY PageContentFaq.faq_order ASC; | 0 | 0 | 0 | |
| SELECT DISTINCT ShopType.id, ShopType.price, ShopType.promo, ShopType.price_promo, ShopTypeTranslation.title, ShopTypeTranslation.color, ShopTypeTranslation.type, ShopTypeTranslation.slug, ShopTypeTranslation.duration, ShopCategoryTranslation.id, ShopCategoryTranslation.slug, ShopCategoryTranslation.title, ShopProductTranslation.id, ShopProductTranslation.slug, ShopProductTranslation.title, Image.name FROM shop_types ShopType INNER JOIN shop_type_translations ShopTypeTranslation ON ShopTypeTranslation.product_type_id = ShopType.id INNER JOIN shop_categories ShopCategorie ON ShopCategorie.id = ShopType.category_id AND ShopCategorie.category_type = "booking_agenda" INNER JOIN shop_category_translations ShopCategoryTranslation ON ShopCategoryTranslation.category_id = ShopCategorie.id INNER JOIN shop_products ShopProduct ON ShopProduct.id = ShopType.product_id INNER JOIN shop_product_translations ShopProductTranslation ON ShopProductTranslation.product_id = ShopProduct.id INNER JOIN languages Language ON Language.code_link = "en" AND Language.id = ShopTypeTranslation.language_code_id AND Language.id = ShopCategoryTranslation.language_code_id AND Language.id = ShopProductTranslation.language_code_id LEFT OUTER JOIN ( SELECT i.id, i.name, i.item_id, min(i.image_order) as image_order FROM images i GROUP BY i.item_id ) as Image ON Image.item_id = ShopType.id WHERE ShopType.publish = 1 AND ShopType.destaque = 1 ORDER BY rand() LIMIT 3; | 0 | 0 | 1 | maybe slow |
| SELECT PageType.id, PageType.static_page, PageType.booking_system, PageType.associate_promotion, PageTypeTranslation.slug, PageTypeTranslation.title, PageContent.id, PageContent.associate_promotion, PageContent.duration_tour, PageContent.price_tour, PageContentTranslation.id, PageContentTranslation.slug, PageContentTranslation.title, PageContentTranslation.subtitle, PageContentTranslation.introduction, PageContent.booking_url, Image.id, Image.name 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" INNER JOIN page_types PageType ON PageType.id = PageContent.page_type_id AND PageType.publish = 1 AND PageType.block = 0 INNER JOIN page_type_translations PageTypeTranslation ON PageTypeTranslation.page_type_id = PageType.id AND PageTypeTranslation.language_code_id = Language.id LEFT JOIN images Image ON Image.id = PageContent.image_id WHERE PageContent.page_content_associate = 48 AND PageContent.publish = 1 ORDER BY RAND() LIMIT 3; | 0 | 0 | 6 | 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 | 3 | 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 | 3 | maybe slow |
| 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 | 0 | |
| 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 | 0 | |
| 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 | 4 | 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 | 0 | |
| 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 = "about-the-project?place=historic-center" | 0 | 0 | 1 | maybe slow |
| 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 = "about-the-project?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 | 0 | |