26.54 ms (71.83%)
|
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;
|
4.29 ms (11.61%)
|
4 |
SELECT t0.id AS id_1, t0.url AS url_2, t0.date AS date_3, t0.title AS title_4, t0.status AS status_5, t0.author_name AS author_name_6, t0.author_uri AS author_uri_7, t0.source AS source_8, t0.name AS name_9, t0.portada AS portada_10, t0.user_id AS user_id_11, t0.center_id AS center_id_12 FROM photos t0 WHERE t0.center_id = ?
SELECT t0.id AS id_1, t0.url AS url_2, t0.date AS date_3, t0.title AS title_4, t0.status AS status_5, t0.author_name AS author_name_6, t0.author_uri AS author_uri_7, t0.source AS source_8, t0.name AS name_9, t0.portada AS portada_10, t0.user_id AS user_id_11, t0.center_id AS center_id_12 FROM photos t0 WHERE t0.center_id = 104;
|
1.63 ms (4.40%)
|
1 |
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 = ? ORDER BY t0.rating ASC LIMIT 100
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 = 7 ORDER BY t0.rating ASC LIMIT 100;
|