| Query | Affected | Num. rows | Took (ms) | Actions |
|---|
| SELECT `Redirect`.`id`, `Redirect`.`old_url`, `Redirect`.`new_url_type`, `Redirect`.`new_url_custom`, `Redirect`.`new_url_id` FROM `apt_db`.`redirects` AS `Redirect` WHERE ((`old_url` LIKE '/central-packages') OR (`old_url` LIKE 'central-packages')) LIMIT 1 | 0 | 0 | 0 | |
| SELECT `Setting`.`api_token`, `Setting`.`api_supplier_id`, `Setting`.`api_base_url`, `Setting`.`google_recaptcha_site_key`, `Setting`.`google_recaptcha_secret_key`, `Setting`.`active_theme`, `Setting`.`destination_level` FROM `apt_db`.`setting` AS `Setting` WHERE `id` = 1 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Translate`.`key`, `Translate`.`value_eng` FROM `apt_db`.`translates` AS `Translate` WHERE 1 = 1 | 347 | 347 | 0 | |
| SELECT `Setting`.* FROM `apt_db`.`setting` AS `Setting` WHERE 1 = 1 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Company`.* FROM `apt_db`.`company` AS `Company` WHERE 1 = 1 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Menu`.*, `Destination`.`slug`, `ProductCategory`.`slug`, `BlogCategory`.`slug`, `Page`.`slug` FROM `apt_db`.`menus` AS `Menu` left JOIN `apt_db`.`destinations` AS `Destination` ON (`Menu`.`type` = "Destination" AND `Menu`.`child` = `Destination`.`id`) left JOIN `apt_db`.`product_categories` AS `ProductCategory` ON (`Menu`.`type` = "ProductCategory" AND `Menu`.`child` = `ProductCategory`.`id`) left JOIN `apt_db`.`blog_categories` AS `BlogCategory` ON (`Menu`.`type` = "BlogCategory" AND `Menu`.`child` = `BlogCategory`.`id`) left JOIN `apt_db`.`pages` AS `Page` ON (`Menu`.`type` = "Page" AND `Menu`.`child` = `Page`.`id`) WHERE `Menu`.`active` = '1' AND `Menu`.`top` = '1' ORDER BY `Menu`.`order` asc | 65 | 65 | 1 | |
| SELECT `Menu`.*, `Destination`.`slug`, `ProductCategory`.`slug`, `BlogCategory`.`slug`, `Page`.`slug` FROM `apt_db`.`menus` AS `Menu` left JOIN `apt_db`.`destinations` AS `Destination` ON (`Menu`.`type` = "Destination" AND `Menu`.`child` = `Destination`.`id`) left JOIN `apt_db`.`product_categories` AS `ProductCategory` ON (`Menu`.`type` = "ProductCategory" AND `Menu`.`child` = `ProductCategory`.`id`) left JOIN `apt_db`.`blog_categories` AS `BlogCategory` ON (`Menu`.`type` = "BlogCategory" AND `Menu`.`child` = `BlogCategory`.`id`) left JOIN `apt_db`.`pages` AS `Page` ON (`Menu`.`type` = "Page" AND `Menu`.`child` = `Page`.`id`) WHERE `Menu`.`active` = '1' AND `Menu`.`footer` = '1' AND `Menu`.`parent_id` IS NULL ORDER BY `Menu`.`order` asc | 1 | 1 | 0 | |
| SELECT `BlockContent`.`id`, `BlockContent`.`block_content_oneid`, `BlockContent`.`name`, `BlockContent`.`url`, `BlockContent`.`image`, `BlockContent`.`content_vie`, `BlockContent`.`content_eng`, `BlockContent`.`active`, `BlockContent`.`order`, `BlockContent`.`type`, `BlockContent`.`created`, `BlockContent`.`modified`, `BlockContent`.`status` FROM `apt_db`.`block_contents` AS `BlockContent` WHERE `type` = 2 ORDER BY `order` asc | 0 | 0 | 0 | |
| SELECT `SessionCart`.`id`, `SessionCart`.`data`, `SessionCart`.`expires` FROM `apt_db`.`session_carts` AS `SessionCart` WHERE `id` = 'd3d424cfce00c24cb346c67ff647bc7b' LIMIT 1 | 0 | 0 | 0 | |
| SELECT `Setting`.`usd_rate` FROM `apt_db`.`setting` AS `Setting` WHERE 1 = 1 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `ProductCategory`.`id`, `ProductCategory`.`product_category_oneid`, `ProductCategory`.`name_eng`, `ProductCategory`.`name_vie`, `ProductCategory`.`slug`, `ProductCategory`.`title`, `ProductCategory`.`content_eng`, `ProductCategory`.`content_vie`, `ProductCategory`.`description`, `ProductCategory`.`keyword`, `ProductCategory`.`image`, `ProductCategory`.`thumbnail`, `ProductCategory`.`mobile_image`, `ProductCategory`.`available_group`, `ProductCategory`.`order`, `ProductCategory`.`parent_id`, `ProductCategory`.`level`, `ProductCategory`.`id_path`, `ProductCategory`.`category_type`, `ProductCategory`.`top_category`, `ProductCategory`.`show_name_banner`, `ProductCategory`.`created`, `ProductCategory`.`modified`, `ProductCategory`.`status` FROM `apt_db`.`product_categories` AS `ProductCategory` WHERE `ProductCategory`.`slug` = 'central-packages' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Destination`.`id`, `Destination`.`destination_oneid`, `Destination`.`name_eng`, `Destination`.`name_vie`, `Destination`.`slug`, `Destination`.`title`, `Destination`.`type`, `Destination`.`latitude`, `Destination`.`longitude`, `Destination`.`content_eng`, `Destination`.`content_vie`, `Destination`.`highlights_eng`, `Destination`.`highlights_vie`, `Destination`.`tips_eng`, `Destination`.`tips_vie`, `Destination`.`activities`, `Destination`.`description`, `Destination`.`keyword`, `Destination`.`image`, `Destination`.`thumbnail`, `Destination`.`mobile_image`, `Destination`.`available_group`, `Destination`.`order`, `Destination`.`id_path`, `Destination`.`parent_id`, `Destination`.`level`, `Destination`.`top`, `Destination`.`show_name_banner`, `Destination`.`created`, `Destination`.`modified`, `Destination`.`status`, (SELECT COUNT(*) FROM `apt_db`.`products` AS `Product` WHERE status = 1 AND creation_date <= '2019-03-20 00:00:00' AND ((avail_since >= '2019-03-20 23:59:59') OR (avail_since IS NULL)) AND FIND_IN_SET(125, categories) AND FIND_IN_SET(`Destination`.`id`, tour_line)) AS `Destination__count_product_tour` FROM `apt_db`.`destinations` AS `Destination` WHERE (SELECT COUNT(*) FROM `apt_db`.`products` AS `Product` WHERE status = 1 AND creation_date <= '2019-03-20 00:00:00' AND ((avail_since >= '2019-03-20 23:59:59') OR (avail_since IS NULL)) AND FIND_IN_SET(125, categories) AND FIND_IN_SET(`Destination`.`id`, tour_line)) > 0 ORDER BY (SELECT COUNT(*) FROM `apt_db`.`products` AS `Product` WHERE status = 1 AND creation_date <= '2019-03-20 00:00:00' AND ((avail_since >= '2019-03-20 23:59:59') OR (avail_since IS NULL)) AND FIND_IN_SET(125, categories) AND FIND_IN_SET(`Destination`.`id`, tour_line)) desc | 6 | 6 | 312 | maybe slow |
| SELECT `Accommodation`.`id`, `Accommodation`.`accommodation_oneid`, `Accommodation`.`name_eng`, `Accommodation`.`created`, `Accommodation`.`modified`, `Accommodation`.`status`, (SELECT COUNT(*) FROM `apt_db`.`products` AS `Product` WHERE status = 1 AND creation_date <= '2019-03-20 00:00:00' AND ((avail_since >= '2019-03-20 23:59:59') OR (avail_since IS NULL)) AND FIND_IN_SET(125, categories) AND FIND_IN_SET(`Accommodation`.`id`, accommodation_ids)) AS `Accommodation__count_product_tour` FROM `apt_db`.`accommodations` AS `Accommodation` WHERE (SELECT COUNT(*) FROM `apt_db`.`products` AS `Product` WHERE status = 1 AND creation_date <= '2019-03-20 00:00:00' AND ((avail_since >= '2019-03-20 23:59:59') OR (avail_since IS NULL)) AND FIND_IN_SET(125, categories) AND FIND_IN_SET(`Accommodation`.`id`, accommodation_ids)) > 0 ORDER BY (SELECT COUNT(*) FROM `apt_db`.`products` AS `Product` WHERE status = 1 AND creation_date <= '2019-03-20 00:00:00' AND ((avail_since >= '2019-03-20 23:59:59') OR (avail_since IS NULL)) AND FIND_IN_SET(125, categories) AND FIND_IN_SET(`Accommodation`.`id`, accommodation_ids)) desc | 1 | 1 | 11 | maybe slow |
| SELECT `Destination`.`id`, `Destination`.`name_eng` FROM `apt_db`.`destinations` AS `Destination` WHERE 1 = 1 | 328 | 328 | 0 | |
| SELECT `Product`.`id`, `Product`.`slug`, `Product`.`name_eng`, `Product`.`image`, `Product`.`thumbnail`, `Product`.`map`, `Product`.`price`, `Product`.`price_old`, `Product`.`created`, `Product`.`price_type`, `Product`.`map_points`, `Product`.`map_center`, `Product`.`map_zoom`, `Product`.`brief`, `Product`.`duration`, `Product`.`price_per_day`, `Product`.`discount_percent`, `Product`.`code`, `Product`.`duration_text`, `Product`.`tour_line`, `Product`.`travel_type`, `Product`.`accommodation`, `Product`.`avail_since`, `Product`.`product_property`, (SELECT COUNT(*) FROM product_itineraries WHERE product_id = `Product`.`id`) AS `Product__count_itinerary`, (SELECT SUM(total_review) FROM product_reviews WHERE product_id = `Product`.`id`) AS `Product__total_review`, (SELECT COUNT(*) FROM product_reviews WHERE product_id = `Product`.`id`) AS `Product__count_review` FROM `apt_db`.`products` AS `Product` WHERE `status` = 1 AND `creation_date` <= '2019-03-20 00:00:00' AND ((`avail_since` >= '2019-03-20 23:59:59') OR (avail_since IS NULL)) AND FIND_IN_SET(125, categories) ORDER BY (SELECT COUNT(*) FROM product_reviews WHERE product_id = `Product`.`id`) desc LIMIT 12 | 2 | 2 | 1 | maybe slow |
| SELECT COUNT(*) AS `count` FROM `apt_db`.`products` AS `Product` WHERE `status` = 1 AND `creation_date` <= '2019-03-20 00:00:00' AND ((`avail_since` >= '2019-03-20 23:59:59') OR (avail_since IS NULL)) AND FIND_IN_SET(125, categories) | 1 | 1 | 1 | |
| SELECT `Setting`.`usd_rate` FROM `apt_db`.`setting` AS `Setting` WHERE 1 = 1 LIMIT 1 | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `apt_db`.`translates` AS `Translate` WHERE `key` = 'DURATION' | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `apt_db`.`translates` AS `Translate` WHERE `key` = 'ACCOMODATION' | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `apt_db`.`translates` AS `Translate` WHERE `key` = 'DURATION' | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `apt_db`.`translates` AS `Translate` WHERE `key` = 'ACCOMODATION' | 1 | 1 | 0 | |
Log in with Google