1.40 ms (23.49%)
|
10 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.legal_name AS legal_name_3, t0.business_type AS business_type_4, t0.nin AS nin_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.domain AS domain_8, t0.email AS email_9, t0.website AS website_10, t0.facebook_page AS facebook_page_11, t0.instagram_username AS instagram_username_12, t0.xcorp_username AS xcorp_username_13, t0.youtube_handle AS youtube_handle_14, t0.cslug AS cslug_15, t0.street AS street_16, t0.postal_code AS postal_code_17, t0.phone_number AS phone_number_18, t0.username AS username_19, t0.password AS password_20, t0.client_status AS client_status_21, t0.server_status AS server_status_22, t0.phone_status AS phone_status_23, t0.lat AS lat_24, t0.lng AS lng_25, t0.roles AS roles_26, t0.views AS views_27, t0.created_at AS created_at_28, t0.updated_at AS updated_at_29, t0.language_id AS language_id_30, t0.locality_id AS locality_id_31 FROM ax_company t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.legal_name AS legal_name_3, t0.business_type AS business_type_4, t0.nin AS nin_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.domain AS domain_8, t0.email AS email_9, t0.website AS website_10, t0.facebook_page AS facebook_page_11, t0.instagram_username AS instagram_username_12, t0.xcorp_username AS xcorp_username_13, t0.youtube_handle AS youtube_handle_14, t0.cslug AS cslug_15, t0.street AS street_16, t0.postal_code AS postal_code_17, t0.phone_number AS phone_number_18, t0.username AS username_19, t0.password AS password_20, t0.client_status AS client_status_21, t0.server_status AS server_status_22, t0.phone_status AS phone_status_23, t0.lat AS lat_24, t0.lng AS lng_25, t0.roles AS roles_26, t0.views AS views_27, t0.created_at AS created_at_28, t0.updated_at AS updated_at_29, t0.language_id AS language_id_30, t0.locality_id AS locality_id_31 FROM ax_company t0 WHERE t0.id = 10;
|
1.22 ms (20.43%)
|
1 |
SELECT t0.id AS id_1, t0.cadastral_id AS cadastral_id_2, ST_AsText(t0.multipolygon_moldref) AS multipolygon_moldref_3, ST_AsText(t0.multipolygon) AS multipolygon_4, ST_AsText(t0.centroid) AS centroid_5, t0.land_area AS land_area_6, t0.name AS name_7, t0.rcslug AS rcslug_8, t0.address AS address_9, t0.instagram_reel_id AS instagram_reel_id_10, t0.price_per_square_meter AS price_per_square_meter_11, t0.completion_date AS completion_date_12, t0.is_sold_out AS is_sold_out_13, t0.client_status AS client_status_14, t0.server_status AS server_status_15, t0.views AS views_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.company_id AS company_id_19, t0.locality_id AS locality_id_20 FROM ax_residential_complex t0 WHERE t0.client_status = ? AND t0.server_status = ? ORDER BY t0.name ASC
Parameters: [
"active"
"ok"
]
SELECT t0.id AS id_1, t0.cadastral_id AS cadastral_id_2, ST_AsText(t0.multipolygon_moldref) AS multipolygon_moldref_3, ST_AsText(t0.multipolygon) AS multipolygon_4, ST_AsText(t0.centroid) AS centroid_5, t0.land_area AS land_area_6, t0.name AS name_7, t0.rcslug AS rcslug_8, t0.address AS address_9, t0.instagram_reel_id AS instagram_reel_id_10, t0.price_per_square_meter AS price_per_square_meter_11, t0.completion_date AS completion_date_12, t0.is_sold_out AS is_sold_out_13, t0.client_status AS client_status_14, t0.server_status AS server_status_15, t0.views AS views_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.company_id AS company_id_19, t0.locality_id AS locality_id_20 FROM ax_residential_complex t0 WHERE t0.client_status = 'active' AND t0.server_status = 'ok' ORDER BY t0.name ASC;
|