30.02 ms (80.19%)
|
24 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.place_id AS place_id_3, t0.formatted_address AS formatted_address_4, t0.locality AS locality_5, t0.administrative_area_level_second AS administrative_area_level_second_6, t0.administrative_area_level_first AS administrative_area_level_first_7, t0.postal_code AS postal_code_8, t0.lat AS lat_9, t0.lng AS lng_10, t0.rating AS rating_11, t0.google_maps_uri AS google_maps_uri_12, t0.website_uri AS website_uri_13, t0.adr_format_address AS adr_format_address_14, t0.user_rating_count AS user_rating_count_15, t0.display_name AS display_name_16, t0.slug AS slug_17, t0.whatsapp AS whatsapp_18, t0.instagram AS instagram_19, t0.facebook AS facebook_20, t0.twitter AS twitter_21, t0.youtube AS youtube_22, t0.phone AS phone_23, t0.country_id AS country_id_24 FROM center t0 WHERE t0.country_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.place_id AS place_id_3, t0.formatted_address AS formatted_address_4, t0.locality AS locality_5, t0.administrative_area_level_second AS administrative_area_level_second_6, t0.administrative_area_level_first AS administrative_area_level_first_7, t0.postal_code AS postal_code_8, t0.lat AS lat_9, t0.lng AS lng_10, t0.rating AS rating_11, t0.google_maps_uri AS google_maps_uri_12, t0.website_uri AS website_uri_13, t0.adr_format_address AS adr_format_address_14, t0.user_rating_count AS user_rating_count_15, t0.display_name AS display_name_16, t0.slug AS slug_17, t0.whatsapp AS whatsapp_18, t0.instagram AS instagram_19, t0.facebook AS facebook_20, t0.twitter AS twitter_21, t0.youtube AS youtube_22, t0.phone AS phone_23, t0.country_id AS country_id_24 FROM center t0 WHERE t0.country_id = 1;
|
1.67 ms (4.47%)
|
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.lat AS lat_4, t0.lng AS lng_5, t0.deep AS deep_6, t0.slug AS slug_7, t0.country_id AS country_id_8, t0.region_id AS region_id_9, t0.type_id AS type_id_10 FROM dive_place t0 WHERE t0.region_id = ? ORDER BY t0.id DESC
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.lat AS lat_4, t0.lng AS lng_5, t0.deep AS deep_6, t0.slug AS slug_7, t0.country_id AS country_id_8, t0.region_id AS region_id_9, t0.type_id AS type_id_10 FROM dive_place t0 WHERE t0.region_id = 6 ORDER BY t0.id DESC;
|