Query | Affected | Num. rows | Took (ms) | Actions |
---|
SELECT `CmsPages`.`id`, `CmsPages`.`url`, `CmsPages`.`title`, `CmsPages`.`content`, `CmsPages`.`additional_content`, `CmsPages`.`created`, `CmsPages`.`modified`, `CmsPages`.`draft`, `CmsPages`.`empty_action`, `CmsPages`.`menu`, `CmsPages`.`position`, `CmsPages`.`parent`, `CmsPages`.`meta_title`, `CmsPages`.`meta_description`, `CmsPages`.`meta_keywords` FROM `m1056_salazabaw14`.`cms_pages` AS `CmsPages` WHERE 1 = 1 ORDER BY `url` DESC | 1 | 1 | 1 | |
SELECT `CmsPage`.`id`, `CmsPage`.`url`, `CmsPage`.`title`, `CmsPage`.`content`, `CmsPage`.`additional_content`, `CmsPage`.`created`, `CmsPage`.`modified`, `CmsPage`.`draft`, `CmsPage`.`empty_action`, `CmsPage`.`menu`, `CmsPage`.`position`, `CmsPage`.`parent`, `CmsPage`.`meta_title`, `CmsPage`.`meta_description`, `CmsPage`.`meta_keywords` FROM `m1056_salazabaw14`.`cms_pages` AS `CmsPage` WHERE `CmsPage`.`menu` = '1' | 1 | 1 | 0 | |
SELECT `Place`.`id`, `Place`.`name`, `Place`.`url`, `Place`.`meta_title`, `Place`.`meta_description`, `Place`.`meta_keywords`, `Place`.`description`, `Place`.`province_id`, `Place`.`menu`, `Place`.`thumb` FROM `m1056_salazabaw14`.`places` AS `Place` WHERE `Place`.`menu` = '1' | 53 | 53 | 1 | |
SELECT `Facility`.`id`, `Facility`.`icon`, `Facility`.`name`, `Facility`.`url`, `Facility`.`meta_title`, `Facility`.`meta_description`, `Facility`.`meta_keywords`, `Facility`.`description`, `Facility`.`menu` FROM `m1056_salazabaw14`.`facilities` AS `Facility` WHERE `Facility`.`menu` = '1' | 0 | 0 | 1 | maybe slow |
SELECT `Province`.`id`, `Province`.`name`, `Province`.`url`, `Province`.`meta_title`, `Province`.`meta_description`, `Province`.`meta_keywords` FROM `m1056_salazabaw14`.`provinces` AS `Province` WHERE 1 = 1 ORDER BY `Province`.`name` ASC | 16 | 16 | 1 | maybe slow |
SELECT `Room`.`id`, `Room`.`url`, `Room`.`user_id`, `Room`.`name`, `Room`.`opening_hours`, `Room`.`googlelocation`, `Room`.`address_street`, `Room`.`address_postcode`, `Room`.`place_id`, `Room`.`phone`, `Room`.`email`, `Room`.`facebook_link`, `Room`.`instagram_link`, `Room`.`www_page`, `Room`.`description`, `Room`.`movie`, `Room`.`prices`, `Room`.`meta_title`, `Room`.`meta_description`, `Room`.`meta_keywords`, `Room`.`free`, `Room`.`available_to_pay`, `Room`.`last_payment_status`, `Room`.`payment_id`, `Room`.`subscription_id`, `Room`.`credit_card_token`, `Room`.`package_name`, `Room`.`package_start`, `Room`.`package_end`, `Room`.`cyclic`, `Room`.`cycle`, `Room`.`cycle_next_payment`, `Room`.`active`, `Room`.`created`, `Room`.`modified`, `Room`.`lat`, `Room`.`long`, `Room`.`thumb`, `Room`.`banner`, `Room`.`recommended`, `Room`.`history_log`, `Place`.`id`, `Place`.`name`, `Place`.`url`, `Place`.`meta_title`, `Place`.`meta_description`, `Place`.`meta_keywords`, `Place`.`description`, `Place`.`province_id`, `Place`.`menu`, `Place`.`thumb` FROM `m1056_salazabaw14`.`rooms` AS `Room` LEFT JOIN `m1056_salazabaw14`.`places` AS `Place` ON (`Room`.`place_id` = `Place`.`id`) WHERE `Room`.`active` = '1' AND `Room`.`recommended` = '1' GROUP BY `Room`.`id` ORDER BY rand() ASC LIMIT 8 | 4 | 4 | 2 | maybe slow |
SELECT `Province`.`id`, `Province`.`name`, `Province`.`url`, `Province`.`meta_title`, `Province`.`meta_description`, `Province`.`meta_keywords` FROM `m1056_salazabaw14`.`provinces` AS `Province` WHERE `Province`.`id` = 4 | 1 | 1 | 0 | |
SELECT `Province`.`id`, `Province`.`name`, `Province`.`url`, `Province`.`meta_title`, `Province`.`meta_description`, `Province`.`meta_keywords` FROM `m1056_salazabaw14`.`provinces` AS `Province` WHERE `Province`.`id` = 4 | 1 | 1 | 0 | |
SELECT `Province`.`id`, `Province`.`name`, `Province`.`url`, `Province`.`meta_title`, `Province`.`meta_description`, `Province`.`meta_keywords` FROM `m1056_salazabaw14`.`provinces` AS `Province` WHERE `Province`.`id` = 8 | 1 | 1 | 0 | |
SELECT `Province`.`id`, `Province`.`name`, `Province`.`url`, `Province`.`meta_title`, `Province`.`meta_description`, `Province`.`meta_keywords` FROM `m1056_salazabaw14`.`provinces` AS `Province` WHERE `Province`.`id` = 4 | 1 | 1 | 0 | |
SELECT `Facility`.`id`, `Facility`.`icon`, `Facility`.`name`, `Facility`.`url`, `Facility`.`meta_title`, `Facility`.`meta_description`, `Facility`.`meta_keywords`, `Facility`.`description`, `Facility`.`menu`, `FacilitiesRoom`.`id`, `FacilitiesRoom`.`facilitie_id`, `FacilitiesRoom`.`room_id` FROM `m1056_salazabaw14`.`facilities` AS `Facility` JOIN `m1056_salazabaw14`.`facilities_rooms` AS `FacilitiesRoom` ON (`FacilitiesRoom`.`room_id` IN (78, 74, 83, 70) AND `FacilitiesRoom`.`facilitie_id` = `Facility`.`id`) | 20 | 20 | 1 | maybe slow |
SELECT `Slide`.`id`, `Slide`.`slide`, `Slide`.`subtitle`, `Slide`.`title`, `Slide`.`description` FROM `m1056_salazabaw14`.`slides` AS `Slide` WHERE 1 = 1 ORDER BY `Slide`.`id` DESC | 1 | 1 | 1 | |
SELECT `Article`.`id`, `Article`.`title`, `Article`.`description`, `Article`.`short_description`, `Article`.`url`, `Article`.`meta_title`, `Article`.`meta_keywords`, `Article`.`meta_description`, `Article`.`sponsored`, `Article`.`created`, `Article`.`modified`, `Article`.`thumb` FROM `m1056_salazabaw14`.`articles` AS `Article` WHERE 1 = 1 ORDER BY `Article`.`created` DESC | 0 | 0 | 1 | maybe slow |
SELECT `Place`.*, Count(`Room`.`id`) as rooms FROM `m1056_salazabaw14`.`places` AS `Place` LEFT JOIN `m1056_salazabaw14`.`rooms` AS `Room` ON (`Room`.`place_id` = `Place`.`id`) WHERE NOT (`Place`.`name` = 'Opole') GROUP BY `Place`.`id` ORDER BY `rooms` DESC LIMIT 8 | 8 | 8 | 1 | maybe slow |
SELECT `Place`.* FROM `m1056_salazabaw14`.`places` AS `Place` WHERE `Place`.`name` = 'Opole' LIMIT 1 | 1 | 1 | 0 | |
BEGIN | | | | |
INSERT INTO `m1056_salazabaw14`.`searchstats` (`room_id`, `details`, `group_id`, `created`) VALUES (78, 'a:5:{s:4:\"user\";s:8:\"UserID: \";s:2:\"ip\";s:11:\"18.97.9.170\";s:7:\"browser\";s:40:\"CCBot/2.0 (https://commoncrawl.org/faq/)\";s:3:\"url\";s:21:\"https://salazabaw.pl/\";s:8:\"referrer\";s:0:\"\";}', 1733333012, '2024-12-04 18:23:32') | 1 | 1 | 1 | |
COMMIT | | | | |
BEGIN | | | | |
INSERT INTO `m1056_salazabaw14`.`searchstats` (`room_id`, `details`, `group_id`, `created`) VALUES (74, 'a:5:{s:4:\"user\";s:8:\"UserID: \";s:2:\"ip\";s:11:\"18.97.9.170\";s:7:\"browser\";s:40:\"CCBot/2.0 (https://commoncrawl.org/faq/)\";s:3:\"url\";s:21:\"https://salazabaw.pl/\";s:8:\"referrer\";s:0:\"\";}', 1733333012, '2024-12-04 18:23:32') | 1 | 1 | 0 | |
COMMIT | | | | |
BEGIN | | | | |
INSERT INTO `m1056_salazabaw14`.`searchstats` (`room_id`, `details`, `group_id`, `created`) VALUES (83, 'a:5:{s:4:\"user\";s:8:\"UserID: \";s:2:\"ip\";s:11:\"18.97.9.170\";s:7:\"browser\";s:40:\"CCBot/2.0 (https://commoncrawl.org/faq/)\";s:3:\"url\";s:21:\"https://salazabaw.pl/\";s:8:\"referrer\";s:0:\"\";}', 1733333012, '2024-12-04 18:23:32') | 1 | 1 | 0 | |
COMMIT | | | | |
BEGIN | | | | |
INSERT INTO `m1056_salazabaw14`.`searchstats` (`room_id`, `details`, `group_id`, `created`) VALUES (70, 'a:5:{s:4:\"user\";s:8:\"UserID: \";s:2:\"ip\";s:11:\"18.97.9.170\";s:7:\"browser\";s:40:\"CCBot/2.0 (https://commoncrawl.org/faq/)\";s:3:\"url\";s:21:\"https://salazabaw.pl/\";s:8:\"referrer\";s:0:\"\";}', 1733333012, '2024-12-04 18:23:32') | 1 | 1 | 0 | |
COMMIT | | | | |
SELECT `Facility`.`id`, `Facility`.`icon`, `Facility`.`name`, `Facility`.`url`, `Facility`.`meta_title`, `Facility`.`meta_description`, `Facility`.`meta_keywords`, `Facility`.`description`, `Facility`.`menu` FROM `m1056_salazabaw14`.`facilities` AS `Facility` WHERE 1 = 1 | 17 | 17 | 0 | |
SELECT `CmsPage`.`id`, `CmsPage`.`url`, `CmsPage`.`title`, `CmsPage`.`content`, `CmsPage`.`additional_content`, `CmsPage`.`created`, `CmsPage`.`modified`, `CmsPage`.`draft`, `CmsPage`.`empty_action`, `CmsPage`.`menu`, `CmsPage`.`position`, `CmsPage`.`parent`, `CmsPage`.`meta_title`, `CmsPage`.`meta_description`, `CmsPage`.`meta_keywords` FROM `m1056_salazabaw14`.`cms_pages` AS `CmsPage` WHERE `url` = '' LIMIT 1 | 0 | 0 | 0 | |