Symfony Profiler

Query Metrics

43 Database Queries

9 Different statements

38.56 ms Query time

1 Invalid entities

230 Managed entities

Queries


SELECT t0.id AS id_1, t0.username AS username_2, t0.password AS password_3, t0.email AS email_4, t0.new_email AS new_email_5, t0.roles AS roles_6, t0.firstname AS firstname_7, t0.lastname AS lastname_8, t0.newsletter_accepted AS newsletter_accepted_9, t0.terms_accepted AS terms_accepted_10, t0.is_valid AS is_valid_11, t0.confirmation_token AS confirmation_token_12, t0.shortcuts AS shortcuts_13, t0.lastlogin AS lastlogin_14, t0.locale AS locale_15, t0.birthday AS birthday_16, t0.description AS description_17, t0.gender_id AS gender_id_18, t0.picture_name AS picture_name_19, t0.password_request_at AS password_request_at_20, t0.enabled AS enabled_21, t0.come_from AS come_from_22, t0.display_scenario AS display_scenario_23, t0.phone AS phone_24, t0.info_shared_neopse AS info_shared_neopse_25, t0.created_at AS created_at_26, t0.updated_at AS updated_at_27, t0.city_id AS city_id_28, t0.admin_group_id AS admin_group_id_29 FROM users t0 WHERE t0.email = ? LIMIT 1
UPDATE users SET last_login = ? WHERE id = ?
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.description AS description_2, p0_.address AS address_3, p0_.additional_address AS additional_address_4, p0_.postcode AS postcode_5, p0_.identify_number AS identify_number_6, p0_.website AS website_7, p0_.prepaid_amount AS prepaid_amount_8, p0_.sponsor_code AS sponsor_code_9, p0_.sponsor_points AS sponsor_points_10, p0_.reference AS reference_11, p0_.sepa_name AS sepa_name_12, p0_.population AS population_13, p0_.typology AS typology_14, p0_.is_rdc AS is_rdc_15, p0_.is_contract_historic AS is_contract_historic_16, p0_.collectivity_service_code AS collectivity_service_code_17, p0_.is_number_ej AS is_number_ej_18, p0_.demo AS demo_19, p0_.vat AS vat_20, p0_.logo AS logo_21, p0_.is_data_different_invoice AS is_data_different_invoice_22, p0_.other_name AS other_name_23, p0_.other_address AS other_address_24, p0_.other_identify_number AS other_identify_number_25, p0_.manual_renewal AS manual_renewal_26, p0_.testimony_answered AS testimony_answered_27, p0_.is_cmd AS is_cmd_28, p0_.notes AS notes_29, p0_.date_invitation_ceo_interview AS date_invitation_ceo_interview_30, p0_.date_ceo_interview AS date_ceo_interview_31, p0_.top_ranking AS top_ranking_32, p0_.rdc_feeling AS rdc_feeling_33, p0_.created_at AS created_at_34, p0_.updated_at AS updated_at_35, p0_.deleted_at AS deleted_at_36, p0_.lat AS lat_37, p0_.lng AS lng_38, p1_.date_end AS date_end_39, p1_.status AS status_40, p1_.additional_size AS additional_size_41, p1_.free AS free_42, p1_.next_data AS next_data_43, p1_.pending_order AS pending_order_44, p1_.size_platform AS size_platform_45, p1_.pack AS pack_46, p1_.reminded_at AS reminded_at_47, p1_.delete_at AS delete_at_48, p1_.locked AS locked_49, p1_.renewal_refused AS renewal_refused_50, p1_.renewal_refused_reason AS renewal_refused_reason_51, p1_.renewal_refused_filename AS renewal_refused_filename_52, p2_.id AS id_53, p2_.name AS name_54, p2_.always_checked AS always_checked_55, p2_.projecttool_key AS projecttool_key_56, p2_.max_size AS max_size_57, p2_.index_route AS index_route_58, p2_.enabled AS enabled_59, p0_.type_id AS type_id_60, p0_.category_id AS category_id_61, p0_.city_id AS city_id_62, p0_.user_id AS user_id_63, p0_.othet_city_id AS othet_city_id_64, p0_.intercommunality_id AS intercommunality_id_65, p0_.attachments AS attachments_66, p1_.projecttool_id AS projecttool_id_67, p1_.project_id AS project_id_68 FROM projects p0_ INNER JOIN users_access u3_ ON (p0_.id = u3_.project_id) INNER JOIN users u4_ ON (u4_.id = u3_.user_id) LEFT JOIN projects_projecttools p1_ ON p0_.id = p1_.project_id LEFT JOIN projecttools p2_ ON p1_.projecttool_id = p2_.id WHERE u4_.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.address AS address_4, t0.additional_address AS additional_address_5, t0.postcode AS postcode_6, t0.identify_number AS identify_number_7, t0.website AS website_8, t0.prepaid_amount AS prepaid_amount_9, t0.sponsor_code AS sponsor_code_10, t0.sponsor_points AS sponsor_points_11, t0.reference AS reference_12, t0.sepa_name AS sepa_name_13, t0.population AS population_14, t0.typology AS typology_15, t0.is_rdc AS is_rdc_16, t0.is_contract_historic AS is_contract_historic_17, t0.collectivity_service_code AS collectivity_service_code_18, t0.is_number_ej AS is_number_ej_19, t0.demo AS demo_20, t0.vat AS vat_21, t0.logo AS logo_22, t0.is_data_different_invoice AS is_data_different_invoice_23, t0.other_name AS other_name_24, t0.other_address AS other_address_25, t0.other_identify_number AS other_identify_number_26, t0.manual_renewal AS manual_renewal_27, t0.testimony_answered AS testimony_answered_28, t0.is_cmd AS is_cmd_29, t0.notes AS notes_30, t0.date_invitation_ceo_interview AS date_invitation_ceo_interview_31, t0.date_ceo_interview AS date_ceo_interview_32, t0.top_ranking AS top_ranking_33, t0.rdc_feeling AS rdc_feeling_34, t0.created_at AS created_at_35, t0.updated_at AS updated_at_36, t0.deleted_at AS deleted_at_37, t0.lat AS lat_38, t0.lng AS lng_39, t0.type_id AS type_id_40, t0.category_id AS category_id_41, t0.city_id AS city_id_42, t0.user_id AS user_id_43, t0.othet_city_id AS othet_city_id_44, t0.intercommunality_id AS intercommunality_id_45, t0.attachments AS attachments_46 FROM projects t0 INNER JOIN users_projects ON t0.id = users_projects.project_id WHERE users_projects.user_id = ? ORDER BY t0.name ASC
SELECT t0.id AS id_1, t0.name AS name_2, t0.always_checked AS always_checked_3, t0.projecttool_key AS projecttool_key_4, t0.max_size AS max_size_5, t0.index_route AS index_route_6, t0.enabled AS enabled_7 FROM projecttools t0 WHERE t0.enabled = ?
SELECT t0.id AS id_1, t0.postcode AS postcode_2, t0.slug AS slug_3, t0.lat AS lat_4, t0.lng AS lng_5, t0.country_id AS country_id_6 FROM cities t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4, t5.id AS id_6, t5.postcode AS postcode_7, t5.slug AS slug_8, t5.lat AS lat_9, t5.lng AS lng_10, t5.country_id AS country_id_11 FROM cities_translation t0 LEFT JOIN cities t5 ON t0.translatable_id = t5.id WHERE t0.translatable_id = ?
SELECT p.id AS id0, p.name AS name1, p.description AS description2, p.address AS address3, p.additional_address AS additional_address4, p.postcode AS postcode5, p.identify_number AS identify_number6, p.website AS website7, p.prepaid_amount AS prepaid_amount8, p.sponsor_code AS sponsor_code9, p.sponsor_points AS sponsor_points10, p.reference AS reference11, p.sepa_name AS sepa_name12, p.population AS population13, p.typology AS typology14, p.is_rdc AS is_rdc15, p.is_contract_historic AS is_contract_historic16, p.collectivity_service_code AS collectivity_service_code17, p.is_number_ej AS is_number_ej18, p.demo AS demo19, p.vat AS vat20, p.logo AS logo21, p.is_data_different_invoice AS is_data_different_invoice22, p.other_name AS other_name23, p.other_address AS other_address24, p.other_identify_number AS other_identify_number25, p.manual_renewal AS manual_renewal26, p.testimony_answered AS testimony_answered27, p.is_cmd AS is_cmd28, p.notes AS notes29, p.date_invitation_ceo_interview AS date_invitation_ceo_interview30, p.date_ceo_interview AS date_ceo_interview31, p.top_ranking AS top_ranking32, p.rdc_feeling AS rdc_feeling33, p.created_at AS created_at34, p.updated_at AS updated_at35, p.deleted_at AS deleted_at36, p.lat AS lat37, p.lng AS lng38, p.type_id AS type_id39, p.category_id AS category_id40, p.city_id AS city_id41, p.user_id AS user_id42, p.othet_city_id AS othet_city_id43, p.intercommunality_id AS intercommunality_id44, p.attachments AS attachments45, c.id AS id, c.postcode AS postcode, c.slug AS slug, c.lat AS lat, c.lng AS lng, c.country_id AS country_id, ( 6371 * acos(cos(radians(48.778100)) * cos( radians( c.lat ) )
                        * cos( radians( c.lng ) - radians(2.297500) ) + sin( radians(48.778100) ) * sin( radians( c.lat ) ) ) ) as distance
                  FROM projects p
                  INNER JOIN cities c ON c.id = p.city_id
                  WHERE p.demo = 0
                  HAVING distance < ?
                  ORDER BY distance ASC
SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4, t5.id AS id_6, t5.postcode AS postcode_7, t5.slug AS slug_8, t5.lat AS lat_9, t5.lng AS lng_10, t5.country_id AS country_id_11 FROM cities_translation t0 LEFT JOIN cities t5 ON t0.translatable_id = t5.id WHERE t0.translatable_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4, t5.id AS id_6, t5.postcode AS postcode_7, t5.slug AS slug_8, t5.lat AS lat_9, t5.lng AS lng_10, t5.country_id AS country_id_11 FROM cities_translation t0 LEFT JOIN cities t5 ON t0.translatable_id = t5.id WHERE t0.translatable_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4, t5.id AS id_6, t5.postcode AS postcode_7, t5.slug AS slug_8, t5.lat AS lat_9, t5.lng AS lng_10, t5.country_id AS country_id_11 FROM cities_translation t0 LEFT JOIN cities t5 ON t0.translatable_id = t5.id WHERE t0.translatable_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4, t5.id AS id_6, t5.postcode AS postcode_7, t5.slug AS slug_8, t5.lat AS lat_9, t5.lng AS lng_10, t5.country_id AS country_id_11 FROM cities_translation t0 LEFT JOIN cities t5 ON t0.translatable_id = t5.id WHERE t0.translatable_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4, t5.id AS id_6, t5.postcode AS postcode_7, t5.slug AS slug_8, t5.lat AS lat_9, t5.lng AS lng_10, t5.country_id AS country_id_11 FROM cities_translation t0 LEFT JOIN cities t5 ON t0.translatable_id = t5.id WHERE t0.translatable_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4, t5.id AS id_6, t5.postcode AS postcode_7, t5.slug AS slug_8, t5.lat AS lat_9, t5.lng AS lng_10, t5.country_id AS country_id_11 FROM cities_translation t0 LEFT JOIN cities t5 ON t0.translatable_id = t5.id WHERE t0.translatable_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4, t5.id AS id_6, t5.postcode AS postcode_7, t5.slug AS slug_8, t5.lat AS lat_9, t5.lng AS lng_10, t5.country_id AS country_id_11 FROM cities_translation t0 LEFT JOIN cities t5 ON t0.translatable_id = t5.id WHERE t0.translatable_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4, t5.id AS id_6, t5.postcode AS postcode_7, t5.slug AS slug_8, t5.lat AS lat_9, t5.lng AS lng_10, t5.country_id AS country_id_11 FROM cities_translation t0 LEFT JOIN cities t5 ON t0.translatable_id = t5.id WHERE t0.translatable_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4, t5.id AS id_6, t5.postcode AS postcode_7, t5.slug AS slug_8, t5.lat AS lat_9, t5.lng AS lng_10, t5.country_id AS country_id_11 FROM cities_translation t0 LEFT JOIN cities t5 ON t0.translatable_id = t5.id WHERE t0.translatable_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4, t5.id AS id_6, t5.postcode AS postcode_7, t5.slug AS slug_8, t5.lat AS lat_9, t5.lng AS lng_10, t5.country_id AS country_id_11 FROM cities_translation t0 LEFT JOIN cities t5 ON t0.translatable_id = t5.id WHERE t0.translatable_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4, t5.id AS id_6, t5.postcode AS postcode_7, t5.slug AS slug_8, t5.lat AS lat_9, t5.lng AS lng_10, t5.country_id AS country_id_11 FROM cities_translation t0 LEFT JOIN cities t5 ON t0.translatable_id = t5.id WHERE t0.translatable_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4, t5.id AS id_6, t5.postcode AS postcode_7, t5.slug AS slug_8, t5.lat AS lat_9, t5.lng AS lng_10, t5.country_id AS country_id_11 FROM cities_translation t0 LEFT JOIN cities t5 ON t0.translatable_id = t5.id WHERE t0.translatable_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4, t5.id AS id_6, t5.postcode AS postcode_7, t5.slug AS slug_8, t5.lat AS lat_9, t5.lng AS lng_10, t5.country_id AS country_id_11 FROM cities_translation t0 LEFT JOIN cities t5 ON t0.translatable_id = t5.id WHERE t0.translatable_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4, t5.id AS id_6, t5.postcode AS postcode_7, t5.slug AS slug_8, t5.lat AS lat_9, t5.lng AS lng_10, t5.country_id AS country_id_11 FROM cities_translation t0 LEFT JOIN cities t5 ON t0.translatable_id = t5.id WHERE t0.translatable_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4, t5.id AS id_6, t5.postcode AS postcode_7, t5.slug AS slug_8, t5.lat AS lat_9, t5.lng AS lng_10, t5.country_id AS country_id_11 FROM cities_translation t0 LEFT JOIN cities t5 ON t0.translatable_id = t5.id WHERE t0.translatable_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4, t5.id AS id_6, t5.postcode AS postcode_7, t5.slug AS slug_8, t5.lat AS lat_9, t5.lng AS lng_10, t5.country_id AS country_id_11 FROM cities_translation t0 LEFT JOIN cities t5 ON t0.translatable_id = t5.id WHERE t0.translatable_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4, t5.id AS id_6, t5.postcode AS postcode_7, t5.slug AS slug_8, t5.lat AS lat_9, t5.lng AS lng_10, t5.country_id AS country_id_11 FROM cities_translation t0 LEFT JOIN cities t5 ON t0.translatable_id = t5.id WHERE t0.translatable_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4, t5.id AS id_6, t5.postcode AS postcode_7, t5.slug AS slug_8, t5.lat AS lat_9, t5.lng AS lng_10, t5.country_id AS country_id_11 FROM cities_translation t0 LEFT JOIN cities t5 ON t0.translatable_id = t5.id WHERE t0.translatable_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4, t5.id AS id_6, t5.postcode AS postcode_7, t5.slug AS slug_8, t5.lat AS lat_9, t5.lng AS lng_10, t5.country_id AS country_id_11 FROM cities_translation t0 LEFT JOIN cities t5 ON t0.translatable_id = t5.id WHERE t0.translatable_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4, t5.id AS id_6, t5.postcode AS postcode_7, t5.slug AS slug_8, t5.lat AS lat_9, t5.lng AS lng_10, t5.country_id AS country_id_11 FROM cities_translation t0 LEFT JOIN cities t5 ON t0.translatable_id = t5.id WHERE t0.translatable_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4, t5.id AS id_6, t5.postcode AS postcode_7, t5.slug AS slug_8, t5.lat AS lat_9, t5.lng AS lng_10, t5.country_id AS country_id_11 FROM cities_translation t0 LEFT JOIN cities t5 ON t0.translatable_id = t5.id WHERE t0.translatable_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4, t5.id AS id_6, t5.postcode AS postcode_7, t5.slug AS slug_8, t5.lat AS lat_9, t5.lng AS lng_10, t5.country_id AS country_id_11 FROM cities_translation t0 LEFT JOIN cities t5 ON t0.translatable_id = t5.id WHERE t0.translatable_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4, t5.id AS id_6, t5.postcode AS postcode_7, t5.slug AS slug_8, t5.lat AS lat_9, t5.lng AS lng_10, t5.country_id AS country_id_11 FROM cities_translation t0 LEFT JOIN cities t5 ON t0.translatable_id = t5.id WHERE t0.translatable_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4, t5.id AS id_6, t5.postcode AS postcode_7, t5.slug AS slug_8, t5.lat AS lat_9, t5.lng AS lng_10, t5.country_id AS country_id_11 FROM cities_translation t0 LEFT JOIN cities t5 ON t0.translatable_id = t5.id WHERE t0.translatable_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4, t5.id AS id_6, t5.postcode AS postcode_7, t5.slug AS slug_8, t5.lat AS lat_9, t5.lng AS lng_10, t5.country_id AS country_id_11 FROM cities_translation t0 LEFT JOIN cities t5 ON t0.translatable_id = t5.id WHERE t0.translatable_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4, t5.id AS id_6, t5.postcode AS postcode_7, t5.slug AS slug_8, t5.lat AS lat_9, t5.lng AS lng_10, t5.country_id AS country_id_11 FROM cities_translation t0 LEFT JOIN cities t5 ON t0.translatable_id = t5.id WHERE t0.translatable_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4, t5.id AS id_6, t5.postcode AS postcode_7, t5.slug AS slug_8, t5.lat AS lat_9, t5.lng AS lng_10, t5.country_id AS country_id_11 FROM cities_translation t0 LEFT JOIN cities t5 ON t0.translatable_id = t5.id WHERE t0.translatable_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4, t5.id AS id_6, t5.postcode AS postcode_7, t5.slug AS slug_8, t5.lat AS lat_9, t5.lng AS lng_10, t5.country_id AS country_id_11 FROM cities_translation t0 LEFT JOIN cities t5 ON t0.translatable_id = t5.id WHERE t0.translatable_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4, t5.id AS id_6, t5.postcode AS postcode_7, t5.slug AS slug_8, t5.lat AS lat_9, t5.lng AS lng_10, t5.country_id AS country_id_11 FROM cities_translation t0 LEFT JOIN cities t5 ON t0.translatable_id = t5.id WHERE t0.translatable_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4, t5.id AS id_6, t5.postcode AS postcode_7, t5.slug AS slug_8, t5.lat AS lat_9, t5.lng AS lng_10, t5.country_id AS country_id_11 FROM cities_translation t0 LEFT JOIN cities t5 ON t0.translatable_id = t5.id WHERE t0.translatable_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4, t5.id AS id_6, t5.postcode AS postcode_7, t5.slug AS slug_8, t5.lat AS lat_9, t5.lng AS lng_10, t5.country_id AS country_id_11 FROM cities_translation t0 LEFT JOIN cities t5 ON t0.translatable_id = t5.id WHERE t0.translatable_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4, t5.id AS id_6, t5.postcode AS postcode_7, t5.slug AS slug_8, t5.lat AS lat_9, t5.lng AS lng_10, t5.country_id AS country_id_11 FROM cities_translation t0 LEFT JOIN cities t5 ON t0.translatable_id = t5.id WHERE t0.translatable_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4, t5.id AS id_6, t5.postcode AS postcode_7, t5.slug AS slug_8, t5.lat AS lat_9, t5.lng AS lng_10, t5.country_id AS country_id_11 FROM cities_translation t0 LEFT JOIN cities t5 ON t0.translatable_id = t5.id WHERE t0.translatable_id = ?
SELECT m0_.id AS id_0, m0_.date_publication AS date_publication_1, m0_.date_unpublication AS date_unpublication_2, m0_.on_account AS on_account_3, m0_.on_back_office AS on_back_office_4, m0_.on_website AS on_website_5, m0_.on_intranet AS on_intranet_6, m0_.on_ticketing AS on_ticketing_7, m1_.id AS id_8, m1_.title AS title_9, m1_.content AS content_10, m1_.locale AS locale_11, m1_.translatable_id AS translatable_id_12 FROM messages m0_ INNER JOIN messages_translation m1_ ON m0_.id = m1_.translatable_id WHERE m0_.on_account = 1 AND m0_.date_publication <= CURRENT_DATE AND m0_.date_unpublication > CURRENT_DATE ORDER BY m0_.date_publication DESC
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.description AS description_2, p0_.address AS address_3, p0_.additional_address AS additional_address_4, p0_.postcode AS postcode_5, p0_.identify_number AS identify_number_6, p0_.website AS website_7, p0_.prepaid_amount AS prepaid_amount_8, p0_.sponsor_code AS sponsor_code_9, p0_.sponsor_points AS sponsor_points_10, p0_.reference AS reference_11, p0_.sepa_name AS sepa_name_12, p0_.population AS population_13, p0_.typology AS typology_14, p0_.is_rdc AS is_rdc_15, p0_.is_contract_historic AS is_contract_historic_16, p0_.collectivity_service_code AS collectivity_service_code_17, p0_.is_number_ej AS is_number_ej_18, p0_.demo AS demo_19, p0_.vat AS vat_20, p0_.logo AS logo_21, p0_.is_data_different_invoice AS is_data_different_invoice_22, p0_.other_name AS other_name_23, p0_.other_address AS other_address_24, p0_.other_identify_number AS other_identify_number_25, p0_.manual_renewal AS manual_renewal_26, p0_.testimony_answered AS testimony_answered_27, p0_.is_cmd AS is_cmd_28, p0_.notes AS notes_29, p0_.date_invitation_ceo_interview AS date_invitation_ceo_interview_30, p0_.date_ceo_interview AS date_ceo_interview_31, p0_.top_ranking AS top_ranking_32, p0_.rdc_feeling AS rdc_feeling_33, p0_.created_at AS created_at_34, p0_.updated_at AS updated_at_35, p0_.deleted_at AS deleted_at_36, p0_.lat AS lat_37, p0_.lng AS lng_38, p1_.date_end AS date_end_39, p1_.status AS status_40, p1_.additional_size AS additional_size_41, p1_.free AS free_42, p1_.next_data AS next_data_43, p1_.pending_order AS pending_order_44, p1_.size_platform AS size_platform_45, p1_.pack AS pack_46, p1_.reminded_at AS reminded_at_47, p1_.delete_at AS delete_at_48, p1_.locked AS locked_49, p1_.renewal_refused AS renewal_refused_50, p1_.renewal_refused_reason AS renewal_refused_reason_51, p1_.renewal_refused_filename AS renewal_refused_filename_52, p2_.id AS id_53, p2_.name AS name_54, p2_.always_checked AS always_checked_55, p2_.projecttool_key AS projecttool_key_56, p2_.max_size AS max_size_57, p2_.index_route AS index_route_58, p2_.enabled AS enabled_59, p0_.type_id AS type_id_60, p0_.category_id AS category_id_61, p0_.city_id AS city_id_62, p0_.user_id AS user_id_63, p0_.othet_city_id AS othet_city_id_64, p0_.intercommunality_id AS intercommunality_id_65, p0_.attachments AS attachments_66, p1_.projecttool_id AS projecttool_id_67, p1_.project_id AS project_id_68 FROM projects p0_ INNER JOIN users_access u3_ ON (p0_.id = u3_.project_id) INNER JOIN users u4_ ON (u4_.id = u3_.user_id) LEFT JOIN projects_projecttools p1_ ON p0_.id = p1_.project_id LEFT JOIN projecttools p2_ ON p1_.projecttool_id = p2_.id WHERE u4_.id = ?

#▲	Time	Info
1	0.67 ms	SELECT t0.id AS id_1, t0.username AS username_2, t0.password AS password_3, t0.email AS email_4, t0.new_email AS new_email_5, t0.roles AS roles_6, t0.firstname AS firstname_7, t0.lastname AS lastname_8, t0.newsletter_accepted AS newsletter_accepted_9, t0.terms_accepted AS terms_accepted_10, t0.is_valid AS is_valid_11, t0.confirmation_token AS confirmation_token_12, t0.shortcuts AS shortcuts_13, t0.lastlogin AS lastlogin_14, t0.locale AS locale_15, t0.birthday AS birthday_16, t0.description AS description_17, t0.gender_id AS gender_id_18, t0.picture_name AS picture_name_19, t0.password_request_at AS password_request_at_20, t0.enabled AS enabled_21, t0.come_from AS come_from_22, t0.display_scenario AS display_scenario_23, t0.phone AS phone_24, t0.info_shared_neopse AS info_shared_neopse_25, t0.created_at AS created_at_26, t0.updated_at AS updated_at_27, t0.city_id AS city_id_28, t0.admin_group_id AS admin_group_id_29 FROM users t0 WHERE t0.email = ? LIMIT 1 Parameters: [`"jean-sebastien.leleu@epicture.fr"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.username AS username_2, t0.password AS password_3, t0.email AS email_4, t0.new_email AS new_email_5, t0.roles AS roles_6, t0.firstname AS firstname_7, t0.lastname AS lastname_8, t0.newsletter_accepted AS newsletter_accepted_9, t0.terms_accepted AS terms_accepted_10, t0.is_valid AS is_valid_11, t0.confirmation_token AS confirmation_token_12, t0.shortcuts AS shortcuts_13, t0.lastlogin AS lastlogin_14, t0.locale AS locale_15, t0.birthday AS birthday_16, t0.description AS description_17, t0.gender_id AS gender_id_18, t0.picture_name AS picture_name_19, t0.password_request_at AS password_request_at_20, t0.enabled AS enabled_21, t0.come_from AS come_from_22, t0.display_scenario AS display_scenario_23, t0.phone AS phone_24, t0.info_shared_neopse AS info_shared_neopse_25, t0.created_at AS created_at_26, t0.updated_at AS updated_at_27, t0.city_id AS city_id_28, t0.admin_group_id AS admin_group_id_29 FROM users t0 WHERE t0.email = ? LIMIT 1 SELECT t0.id AS id_1, t0.username AS username_2, t0.password AS password_3, t0.email AS email_4, t0.new_email AS new_email_5, t0.roles AS roles_6, t0.firstname AS firstname_7, t0.lastname AS lastname_8, t0.newsletter_accepted AS newsletter_accepted_9, t0.terms_accepted AS terms_accepted_10, t0.is_valid AS is_valid_11, t0.confirmation_token AS confirmation_token_12, t0.shortcuts AS shortcuts_13, t0.lastlogin AS lastlogin_14, t0.locale AS locale_15, t0.birthday AS birthday_16, t0.description AS description_17, t0.gender_id AS gender_id_18, t0.picture_name AS picture_name_19, t0.password_request_at AS password_request_at_20, t0.enabled AS enabled_21, t0.come_from AS come_from_22, t0.display_scenario AS display_scenario_23, t0.phone AS phone_24, t0.info_shared_neopse AS info_shared_neopse_25, t0.created_at AS created_at_26, t0.updated_at AS updated_at_27, t0.city_id AS city_id_28, t0.admin_group_id AS admin_group_id_29 FROM users t0 WHERE t0.email = 'jean-sebastien.leleu@epicture.fr' LIMIT 1;
2	1.17 ms	UPDATE users SET last_login = ? WHERE id = ? Parameters: [`"2026-06-13 07:35:25" 2797`] View formatted query View runnable query Explain query UPDATE users SET last_login = ? WHERE id = ? UPDATE users SET last_login = '2026-06-13 07:35:25' WHERE id = 2797;
3	0.82 ms	SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.description AS description_2, p0_.address AS address_3, p0_.additional_address AS additional_address_4, p0_.postcode AS postcode_5, p0_.identify_number AS identify_number_6, p0_.website AS website_7, p0_.prepaid_amount AS prepaid_amount_8, p0_.sponsor_code AS sponsor_code_9, p0_.sponsor_points AS sponsor_points_10, p0_.reference AS reference_11, p0_.sepa_name AS sepa_name_12, p0_.population AS population_13, p0_.typology AS typology_14, p0_.is_rdc AS is_rdc_15, p0_.is_contract_historic AS is_contract_historic_16, p0_.collectivity_service_code AS collectivity_service_code_17, p0_.is_number_ej AS is_number_ej_18, p0_.demo AS demo_19, p0_.vat AS vat_20, p0_.logo AS logo_21, p0_.is_data_different_invoice AS is_data_different_invoice_22, p0_.other_name AS other_name_23, p0_.other_address AS other_address_24, p0_.other_identify_number AS other_identify_number_25, p0_.manual_renewal AS manual_renewal_26, p0_.testimony_answered AS testimony_answered_27, p0_.is_cmd AS is_cmd_28, p0_.notes AS notes_29, p0_.date_invitation_ceo_interview AS date_invitation_ceo_interview_30, p0_.date_ceo_interview AS date_ceo_interview_31, p0_.top_ranking AS top_ranking_32, p0_.rdc_feeling AS rdc_feeling_33, p0_.created_at AS created_at_34, p0_.updated_at AS updated_at_35, p0_.deleted_at AS deleted_at_36, p0_.lat AS lat_37, p0_.lng AS lng_38, p1_.date_end AS date_end_39, p1_.status AS status_40, p1_.additional_size AS additional_size_41, p1_.free AS free_42, p1_.next_data AS next_data_43, p1_.pending_order AS pending_order_44, p1_.size_platform AS size_platform_45, p1_.pack AS pack_46, p1_.reminded_at AS reminded_at_47, p1_.delete_at AS delete_at_48, p1_.locked AS locked_49, p1_.renewal_refused AS renewal_refused_50, p1_.renewal_refused_reason AS renewal_refused_reason_51, p1_.renewal_refused_filename AS renewal_refused_filename_52, p2_.id AS id_53, p2_.name AS name_54, p2_.always_checked AS always_checked_55, p2_.projecttool_key AS projecttool_key_56, p2_.max_size AS max_size_57, p2_.index_route AS index_route_58, p2_.enabled AS enabled_59, p0_.type_id AS type_id_60, p0_.category_id AS category_id_61, p0_.city_id AS city_id_62, p0_.user_id AS user_id_63, p0_.othet_city_id AS othet_city_id_64, p0_.intercommunality_id AS intercommunality_id_65, p0_.attachments AS attachments_66, p1_.projecttool_id AS projecttool_id_67, p1_.project_id AS project_id_68 FROM projects p0_ INNER JOIN users_access u3_ ON (p0_.id = u3_.project_id) INNER JOIN users u4_ ON (u4_.id = u3_.user_id) LEFT JOIN projects_projecttools p1_ ON p0_.id = p1_.project_id LEFT JOIN projecttools p2_ ON p1_.projecttool_id = p2_.id WHERE u4_.id = ? Parameters: [`2797`] View formatted query View runnable query Explain query SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.description AS description_2, p0_.address AS address_3, p0_.additional_address AS additional_address_4, p0_.postcode AS postcode_5, p0_.identify_number AS identify_number_6, p0_.website AS website_7, p0_.prepaid_amount AS prepaid_amount_8, p0_.sponsor_code AS sponsor_code_9, p0_.sponsor_points AS sponsor_points_10, p0_.reference AS reference_11, p0_.sepa_name AS sepa_name_12, p0_.population AS population_13, p0_.typology AS typology_14, p0_.is_rdc AS is_rdc_15, p0_.is_contract_historic AS is_contract_historic_16, p0_.collectivity_service_code AS collectivity_service_code_17, p0_.is_number_ej AS is_number_ej_18, p0_.demo AS demo_19, p0_.vat AS vat_20, p0_.logo AS logo_21, p0_.is_data_different_invoice AS is_data_different_invoice_22, p0_.other_name AS other_name_23, p0_.other_address AS other_address_24, p0_.other_identify_number AS other_identify_number_25, p0_.manual_renewal AS manual_renewal_26, p0_.testimony_answered AS testimony_answered_27, p0_.is_cmd AS is_cmd_28, p0_.notes AS notes_29, p0_.date_invitation_ceo_interview AS date_invitation_ceo_interview_30, p0_.date_ceo_interview AS date_ceo_interview_31, p0_.top_ranking AS top_ranking_32, p0_.rdc_feeling AS rdc_feeling_33, p0_.created_at AS created_at_34, p0_.updated_at AS updated_at_35, p0_.deleted_at AS deleted_at_36, p0_.lat AS lat_37, p0_.lng AS lng_38, p1_.date_end AS date_end_39, p1_.status AS status_40, p1_.additional_size AS additional_size_41, p1_.free AS free_42, p1_.next_data AS next_data_43, p1_.pending_order AS pending_order_44, p1_.size_platform AS size_platform_45, p1_.pack AS pack_46, p1_.reminded_at AS reminded_at_47, p1_.delete_at AS delete_at_48, p1_.locked AS locked_49, p1_.renewal_refused AS renewal_refused_50, p1_.renewal_refused_reason AS renewal_refused_reason_51, p1_.renewal_refused_filename AS renewal_refused_filename_52, p2_.id AS id_53, p2_.name AS name_54, p2_.always_checked AS always_checked_55, p2_.projecttool_key AS projecttool_key_56, p2_.max_size AS max_size_57, p2_.index_route AS index_route_58, p2_.enabled AS enabled_59, p0_.type_id AS type_id_60, p0_.category_id AS category_id_61, p0_.city_id AS city_id_62, p0_.user_id AS user_id_63, p0_.othet_city_id AS othet_city_id_64, p0_.intercommunality_id AS intercommunality_id_65, p0_.attachments AS attachments_66, p1_.projecttool_id AS projecttool_id_67, p1_.project_id AS project_id_68 FROM projects p0_ INNER JOIN users_access u3_ ON (p0_.id = u3_.project_id) INNER JOIN users u4_ ON (u4_.id = u3_.user_id) LEFT JOIN projects_projecttools p1_ ON p0_.id = p1_.project_id LEFT JOIN projecttools p2_ ON p1_.projecttool_id = p2_.id WHERE u4_.id = ? SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.description AS description_2, p0_.address AS address_3, p0_.additional_address AS additional_address_4, p0_.postcode AS postcode_5, p0_.identify_number AS identify_number_6, p0_.website AS website_7, p0_.prepaid_amount AS prepaid_amount_8, p0_.sponsor_code AS sponsor_code_9, p0_.sponsor_points AS sponsor_points_10, p0_.reference AS reference_11, p0_.sepa_name AS sepa_name_12, p0_.population AS population_13, p0_.typology AS typology_14, p0_.is_rdc AS is_rdc_15, p0_.is_contract_historic AS is_contract_historic_16, p0_.collectivity_service_code AS collectivity_service_code_17, p0_.is_number_ej AS is_number_ej_18, p0_.demo AS demo_19, p0_.vat AS vat_20, p0_.logo AS logo_21, p0_.is_data_different_invoice AS is_data_different_invoice_22, p0_.other_name AS other_name_23, p0_.other_address AS other_address_24, p0_.other_identify_number AS other_identify_number_25, p0_.manual_renewal AS manual_renewal_26, p0_.testimony_answered AS testimony_answered_27, p0_.is_cmd AS is_cmd_28, p0_.notes AS notes_29, p0_.date_invitation_ceo_interview AS date_invitation_ceo_interview_30, p0_.date_ceo_interview AS date_ceo_interview_31, p0_.top_ranking AS top_ranking_32, p0_.rdc_feeling AS rdc_feeling_33, p0_.created_at AS created_at_34, p0_.updated_at AS updated_at_35, p0_.deleted_at AS deleted_at_36, p0_.lat AS lat_37, p0_.lng AS lng_38, p1_.date_end AS date_end_39, p1_.status AS status_40, p1_.additional_size AS additional_size_41, p1_.free AS free_42, p1_.next_data AS next_data_43, p1_.pending_order AS pending_order_44, p1_.size_platform AS size_platform_45, p1_.pack AS pack_46, p1_.reminded_at AS reminded_at_47, p1_.delete_at AS delete_at_48, p1_.locked AS locked_49, p1_.renewal_refused AS renewal_refused_50, p1_.renewal_refused_reason AS renewal_refused_reason_51, p1_.renewal_refused_filename AS renewal_refused_filename_52, p2_.id AS id_53, p2_.name AS name_54, p2_.always_checked AS always_checked_55, p2_.projecttool_key AS projecttool_key_56, p2_.max_size AS max_size_57, p2_.index_route AS index_route_58, p2_.enabled AS enabled_59, p0_.type_id AS type_id_60, p0_.category_id AS category_id_61, p0_.city_id AS city_id_62, p0_.user_id AS user_id_63, p0_.othet_city_id AS othet_city_id_64, p0_.intercommunality_id AS intercommunality_id_65, p0_.attachments AS attachments_66, p1_.projecttool_id AS projecttool_id_67, p1_.project_id AS project_id_68 FROM projects p0_ INNER JOIN users_access u3_ ON (p0_.id = u3_.project_id) INNER JOIN users u4_ ON (u4_.id = u3_.user_id) LEFT JOIN projects_projecttools p1_ ON p0_.id = p1_.project_id LEFT JOIN projecttools p2_ ON p1_.projecttool_id = p2_.id WHERE u4_.id = 2797;
4	0.80 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.address AS address_4, t0.additional_address AS additional_address_5, t0.postcode AS postcode_6, t0.identify_number AS identify_number_7, t0.website AS website_8, t0.prepaid_amount AS prepaid_amount_9, t0.sponsor_code AS sponsor_code_10, t0.sponsor_points AS sponsor_points_11, t0.reference AS reference_12, t0.sepa_name AS sepa_name_13, t0.population AS population_14, t0.typology AS typology_15, t0.is_rdc AS is_rdc_16, t0.is_contract_historic AS is_contract_historic_17, t0.collectivity_service_code AS collectivity_service_code_18, t0.is_number_ej AS is_number_ej_19, t0.demo AS demo_20, t0.vat AS vat_21, t0.logo AS logo_22, t0.is_data_different_invoice AS is_data_different_invoice_23, t0.other_name AS other_name_24, t0.other_address AS other_address_25, t0.other_identify_number AS other_identify_number_26, t0.manual_renewal AS manual_renewal_27, t0.testimony_answered AS testimony_answered_28, t0.is_cmd AS is_cmd_29, t0.notes AS notes_30, t0.date_invitation_ceo_interview AS date_invitation_ceo_interview_31, t0.date_ceo_interview AS date_ceo_interview_32, t0.top_ranking AS top_ranking_33, t0.rdc_feeling AS rdc_feeling_34, t0.created_at AS created_at_35, t0.updated_at AS updated_at_36, t0.deleted_at AS deleted_at_37, t0.lat AS lat_38, t0.lng AS lng_39, t0.type_id AS type_id_40, t0.category_id AS category_id_41, t0.city_id AS city_id_42, t0.user_id AS user_id_43, t0.othet_city_id AS othet_city_id_44, t0.intercommunality_id AS intercommunality_id_45, t0.attachments AS attachments_46 FROM projects t0 INNER JOIN users_projects ON t0.id = users_projects.project_id WHERE users_projects.user_id = ? ORDER BY t0.name ASC Parameters: [`2797`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.address AS address_4, t0.additional_address AS additional_address_5, t0.postcode AS postcode_6, t0.identify_number AS identify_number_7, t0.website AS website_8, t0.prepaid_amount AS prepaid_amount_9, t0.sponsor_code AS sponsor_code_10, t0.sponsor_points AS sponsor_points_11, t0.reference AS reference_12, t0.sepa_name AS sepa_name_13, t0.population AS population_14, t0.typology AS typology_15, t0.is_rdc AS is_rdc_16, t0.is_contract_historic AS is_contract_historic_17, t0.collectivity_service_code AS collectivity_service_code_18, t0.is_number_ej AS is_number_ej_19, t0.demo AS demo_20, t0.vat AS vat_21, t0.logo AS logo_22, t0.is_data_different_invoice AS is_data_different_invoice_23, t0.other_name AS other_name_24, t0.other_address AS other_address_25, t0.other_identify_number AS other_identify_number_26, t0.manual_renewal AS manual_renewal_27, t0.testimony_answered AS testimony_answered_28, t0.is_cmd AS is_cmd_29, t0.notes AS notes_30, t0.date_invitation_ceo_interview AS date_invitation_ceo_interview_31, t0.date_ceo_interview AS date_ceo_interview_32, t0.top_ranking AS top_ranking_33, t0.rdc_feeling AS rdc_feeling_34, t0.created_at AS created_at_35, t0.updated_at AS updated_at_36, t0.deleted_at AS deleted_at_37, t0.lat AS lat_38, t0.lng AS lng_39, t0.type_id AS type_id_40, t0.category_id AS category_id_41, t0.city_id AS city_id_42, t0.user_id AS user_id_43, t0.othet_city_id AS othet_city_id_44, t0.intercommunality_id AS intercommunality_id_45, t0.attachments AS attachments_46 FROM projects t0 INNER JOIN users_projects ON t0.id = users_projects.project_id WHERE users_projects.user_id = ? ORDER BY t0.name ASC SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.address AS address_4, t0.additional_address AS additional_address_5, t0.postcode AS postcode_6, t0.identify_number AS identify_number_7, t0.website AS website_8, t0.prepaid_amount AS prepaid_amount_9, t0.sponsor_code AS sponsor_code_10, t0.sponsor_points AS sponsor_points_11, t0.reference AS reference_12, t0.sepa_name AS sepa_name_13, t0.population AS population_14, t0.typology AS typology_15, t0.is_rdc AS is_rdc_16, t0.is_contract_historic AS is_contract_historic_17, t0.collectivity_service_code AS collectivity_service_code_18, t0.is_number_ej AS is_number_ej_19, t0.demo AS demo_20, t0.vat AS vat_21, t0.logo AS logo_22, t0.is_data_different_invoice AS is_data_different_invoice_23, t0.other_name AS other_name_24, t0.other_address AS other_address_25, t0.other_identify_number AS other_identify_number_26, t0.manual_renewal AS manual_renewal_27, t0.testimony_answered AS testimony_answered_28, t0.is_cmd AS is_cmd_29, t0.notes AS notes_30, t0.date_invitation_ceo_interview AS date_invitation_ceo_interview_31, t0.date_ceo_interview AS date_ceo_interview_32, t0.top_ranking AS top_ranking_33, t0.rdc_feeling AS rdc_feeling_34, t0.created_at AS created_at_35, t0.updated_at AS updated_at_36, t0.deleted_at AS deleted_at_37, t0.lat AS lat_38, t0.lng AS lng_39, t0.type_id AS type_id_40, t0.category_id AS category_id_41, t0.city_id AS city_id_42, t0.user_id AS user_id_43, t0.othet_city_id AS othet_city_id_44, t0.intercommunality_id AS intercommunality_id_45, t0.attachments AS attachments_46 FROM projects t0 INNER JOIN users_projects ON t0.id = users_projects.project_id WHERE users_projects.user_id = 2797 ORDER BY t0.name ASC;
5	0.39 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.always_checked AS always_checked_3, t0.projecttool_key AS projecttool_key_4, t0.max_size AS max_size_5, t0.index_route AS index_route_6, t0.enabled AS enabled_7 FROM projecttools t0 WHERE t0.enabled = ? Parameters: [`1`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.always_checked AS always_checked_3, t0.projecttool_key AS projecttool_key_4, t0.max_size AS max_size_5, t0.index_route AS index_route_6, t0.enabled AS enabled_7 FROM projecttools t0 WHERE t0.enabled = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.always_checked AS always_checked_3, t0.projecttool_key AS projecttool_key_4, t0.max_size AS max_size_5, t0.index_route AS index_route_6, t0.enabled AS enabled_7 FROM projecttools t0 WHERE t0.enabled = 1;
6	0.42 ms	SELECT t0.id AS id_1, t0.postcode AS postcode_2, t0.slug AS slug_3, t0.lat AS lat_4, t0.lng AS lng_5, t0.country_id AS country_id_6 FROM cities t0 WHERE t0.id = ? Parameters: [`36443`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.postcode AS postcode_2, t0.slug AS slug_3, t0.lat AS lat_4, t0.lng AS lng_5, t0.country_id AS country_id_6 FROM cities t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.postcode AS postcode_2, t0.slug AS slug_3, t0.lat AS lat_4, t0.lng AS lng_5, t0.country_id AS country_id_6 FROM cities t0 WHERE t0.id = 36443;
7	0.48 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4, t5.id AS id_6, t5.postcode AS postcode_7, t5.slug AS slug_8, t5.lat AS lat_9, t5.lng AS lng_10, t5.country_id AS country_id_11 FROM cities_translation t0 LEFT JOIN cities t5 ON t0.translatable_id = t5.id WHERE t0.translatable_id = ? Parameters: [`36443`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4, t5.id AS id_6, t5.postcode AS postcode_7, t5.slug AS slug_8, t5.lat AS lat_9, t5.lng AS lng_10, t5.country_id AS country_id_11 FROM cities_translation t0 LEFT JOIN cities t5 ON t0.translatable_id = t5.id WHERE t0.translatable_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4, t5.id AS id_6, t5.postcode AS postcode_7, t5.slug AS slug_8, t5.lat AS lat_9, t5.lng AS lng_10, t5.country_id AS country_id_11 FROM cities_translation t0 LEFT JOIN cities t5 ON t0.translatable_id = t5.id WHERE t0.translatable_id = 36443;
8	16.22 ms	SELECT p.id AS id0, p.name AS name1, p.description AS description2, p.address AS address3, p.additional_address AS additional_address4, p.postcode AS postcode5, p.identify_number AS identify_number6, p.website AS website7, p.prepaid_amount AS prepaid_amount8, p.sponsor_code AS sponsor_code9, p.sponsor_points AS sponsor_points10, p.reference AS reference11, p.sepa_name AS sepa_name12, p.population AS population13, p.typology AS typology14, p.is_rdc AS is_rdc15, p.is_contract_historic AS is_contract_historic16, p.collectivity_service_code AS collectivity_service_code17, p.is_number_ej AS is_number_ej18, p.demo AS demo19, p.vat AS vat20, p.logo AS logo21, p.is_data_different_invoice AS is_data_different_invoice22, p.other_name AS other_name23, p.other_address AS other_address24, p.other_identify_number AS other_identify_number25, p.manual_renewal AS manual_renewal26, p.testimony_answered AS testimony_answered27, p.is_cmd AS is_cmd28, p.notes AS notes29, p.date_invitation_ceo_interview AS date_invitation_ceo_interview30, p.date_ceo_interview AS date_ceo_interview31, p.top_ranking AS top_ranking32, p.rdc_feeling AS rdc_feeling33, p.created_at AS created_at34, p.updated_at AS updated_at35, p.deleted_at AS deleted_at36, p.lat AS lat37, p.lng AS lng38, p.type_id AS type_id39, p.category_id AS category_id40, p.city_id AS city_id41, p.user_id AS user_id42, p.othet_city_id AS othet_city_id43, p.intercommunality_id AS intercommunality_id44, p.attachments AS attachments45, c.id AS id, c.postcode AS postcode, c.slug AS slug, c.lat AS lat, c.lng AS lng, c.country_id AS country_id, ( 6371 * acos(cos(radians(48.778100)) * cos( radians( c.lat ) ) * cos( radians( c.lng ) - radians(2.297500) ) + sin( radians(48.778100) ) * sin( radians( c.lat ) ) ) ) as distance FROM projects p INNER JOIN cities c ON c.id = p.city_id WHERE p.demo = 0 HAVING distance < ? ORDER BY distance ASC Parameters: [`30`] View formatted query View runnable query Explain query SELECT p.id AS id0, p.name AS name1, p.description AS description2, p.address AS address3, p.additional_address AS additional_address4, p.postcode AS postcode5, p.identify_number AS identify_number6, p.website AS website7, p.prepaid_amount AS prepaid_amount8, p.sponsor_code AS sponsor_code9, p.sponsor_points AS sponsor_points10, p.reference AS reference11, p.sepa_name AS sepa_name12, p.population AS population13, p.typology AS typology14, p.is_rdc AS is_rdc15, p.is_contract_historic AS is_contract_historic16, p.collectivity_service_code AS collectivity_service_code17, p.is_number_ej AS is_number_ej18, p.demo AS demo19, p.vat AS vat20, p.logo AS logo21, p.is_data_different_invoice AS is_data_different_invoice22, p.other_name AS other_name23, p.other_address AS other_address24, p.other_identify_number AS other_identify_number25, p.manual_renewal AS manual_renewal26, p.testimony_answered AS testimony_answered27, p.is_cmd AS is_cmd28, p.notes AS notes29, p.date_invitation_ceo_interview AS date_invitation_ceo_interview30, p.date_ceo_interview AS date_ceo_interview31, p.top_ranking AS top_ranking32, p.rdc_feeling AS rdc_feeling33, p.created_at AS created_at34, p.updated_at AS updated_at35, p.deleted_at AS deleted_at36, p.lat AS lat37, p.lng AS lng38, p.type_id AS type_id39, p.category_id AS category_id40, p.city_id AS city_id41, p.user_id AS user_id42, p.othet_city_id AS othet_city_id43, p.intercommunality_id AS intercommunality_id44, p.attachments AS attachments45, c.id AS id, c.postcode AS postcode, c.slug AS slug, c.lat AS lat, c.lng AS lng, c.country_id AS country_id, ( 6371 * acos( cos( radians(48.778100) ) * cos( radians(c.lat) ) * cos( radians(c.lng) - radians(2.297500) ) + sin( radians(48.778100) ) * sin( radians(c.lat) ) ) ) as distance FROM projects p INNER JOIN cities c ON c.id = p.city_id WHERE p.demo = 0 HAVING distance < ? ORDER BY distance ASC SELECT p.id AS id0, p.name AS name1, p.description AS description2, p.address AS address3, p.additional_address AS additional_address4, p.postcode AS postcode5, p.identify_number AS identify_number6, p.website AS website7, p.prepaid_amount AS prepaid_amount8, p.sponsor_code AS sponsor_code9, p.sponsor_points AS sponsor_points10, p.reference AS reference11, p.sepa_name AS sepa_name12, p.population AS population13, p.typology AS typology14, p.is_rdc AS is_rdc15, p.is_contract_historic AS is_contract_historic16, p.collectivity_service_code AS collectivity_service_code17, p.is_number_ej AS is_number_ej18, p.demo AS demo19, p.vat AS vat20, p.logo AS logo21, p.is_data_different_invoice AS is_data_different_invoice22, p.other_name AS other_name23, p.other_address AS other_address24, p.other_identify_number AS other_identify_number25, p.manual_renewal AS manual_renewal26, p.testimony_answered AS testimony_answered27, p.is_cmd AS is_cmd28, p.notes AS notes29, p.date_invitation_ceo_interview AS date_invitation_ceo_interview30, p.date_ceo_interview AS date_ceo_interview31, p.top_ranking AS top_ranking32, p.rdc_feeling AS rdc_feeling33, p.created_at AS created_at34, p.updated_at AS updated_at35, p.deleted_at AS deleted_at36, p.lat AS lat37, p.lng AS lng38, p.type_id AS type_id39, p.category_id AS category_id40, p.city_id AS city_id41, p.user_id AS user_id42, p.othet_city_id AS othet_city_id43, p.intercommunality_id AS intercommunality_id44, p.attachments AS attachments45, c.id AS id, c.postcode AS postcode, c.slug AS slug, c.lat AS lat, c.lng AS lng, c.country_id AS country_id, ( 6371 * acos(cos(radians(48.778100)) * cos( radians( c.lat ) ) * cos( radians( c.lng ) - radians(2.297500) ) + sin( radians(48.778100) ) * sin( radians( c.lat ) ) ) ) as distance FROM projects p INNER JOIN cities c ON c.id = p.city_id WHERE p.demo = 0 HAVING distance < 30 ORDER BY distance ASC;
9	0.52 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4, t5.id AS id_6, t5.postcode AS postcode_7, t5.slug AS slug_8, t5.lat AS lat_9, t5.lng AS lng_10, t5.country_id AS country_id_11 FROM cities_translation t0 LEFT JOIN cities t5 ON t0.translatable_id = t5.id WHERE t0.translatable_id = ? Parameters: [`17194`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4, t5.id AS id_6, t5.postcode AS postcode_7, t5.slug AS slug_8, t5.lat AS lat_9, t5.lng AS lng_10, t5.country_id AS country_id_11 FROM cities_translation t0 LEFT JOIN cities t5 ON t0.translatable_id = t5.id WHERE t0.translatable_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4, t5.id AS id_6, t5.postcode AS postcode_7, t5.slug AS slug_8, t5.lat AS lat_9, t5.lng AS lng_10, t5.country_id AS country_id_11 FROM cities_translation t0 LEFT JOIN cities t5 ON t0.translatable_id = t5.id WHERE t0.translatable_id = 17194;
10	0.48 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4, t5.id AS id_6, t5.postcode AS postcode_7, t5.slug AS slug_8, t5.lat AS lat_9, t5.lng AS lng_10, t5.country_id AS country_id_11 FROM cities_translation t0 LEFT JOIN cities t5 ON t0.translatable_id = t5.id WHERE t0.translatable_id = ? Parameters: [`36728`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4, t5.id AS id_6, t5.postcode AS postcode_7, t5.slug AS slug_8, t5.lat AS lat_9, t5.lng AS lng_10, t5.country_id AS country_id_11 FROM cities_translation t0 LEFT JOIN cities t5 ON t0.translatable_id = t5.id WHERE t0.translatable_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4, t5.id AS id_6, t5.postcode AS postcode_7, t5.slug AS slug_8, t5.lat AS lat_9, t5.lng AS lng_10, t5.country_id AS country_id_11 FROM cities_translation t0 LEFT JOIN cities t5 ON t0.translatable_id = t5.id WHERE t0.translatable_id = 36728;
11	0.48 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4, t5.id AS id_6, t5.postcode AS postcode_7, t5.slug AS slug_8, t5.lat AS lat_9, t5.lng AS lng_10, t5.country_id AS country_id_11 FROM cities_translation t0 LEFT JOIN cities t5 ON t0.translatable_id = t5.id WHERE t0.translatable_id = ? Parameters: [`35002`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4, t5.id AS id_6, t5.postcode AS postcode_7, t5.slug AS slug_8, t5.lat AS lat_9, t5.lng AS lng_10, t5.country_id AS country_id_11 FROM cities_translation t0 LEFT JOIN cities t5 ON t0.translatable_id = t5.id WHERE t0.translatable_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4, t5.id AS id_6, t5.postcode AS postcode_7, t5.slug AS slug_8, t5.lat AS lat_9, t5.lng AS lng_10, t5.country_id AS country_id_11 FROM cities_translation t0 LEFT JOIN cities t5 ON t0.translatable_id = t5.id WHERE t0.translatable_id = 35002;
12	0.38 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4, t5.id AS id_6, t5.postcode AS postcode_7, t5.slug AS slug_8, t5.lat AS lat_9, t5.lng AS lng_10, t5.country_id AS country_id_11 FROM cities_translation t0 LEFT JOIN cities t5 ON t0.translatable_id = t5.id WHERE t0.translatable_id = ? Parameters: [`36718`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4, t5.id AS id_6, t5.postcode AS postcode_7, t5.slug AS slug_8, t5.lat AS lat_9, t5.lng AS lng_10, t5.country_id AS country_id_11 FROM cities_translation t0 LEFT JOIN cities t5 ON t0.translatable_id = t5.id WHERE t0.translatable_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4, t5.id AS id_6, t5.postcode AS postcode_7, t5.slug AS slug_8, t5.lat AS lat_9, t5.lng AS lng_10, t5.country_id AS country_id_11 FROM cities_translation t0 LEFT JOIN cities t5 ON t0.translatable_id = t5.id WHERE t0.translatable_id = 36718;
13	0.49 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4, t5.id AS id_6, t5.postcode AS postcode_7, t5.slug AS slug_8, t5.lat AS lat_9, t5.lng AS lng_10, t5.country_id AS country_id_11 FROM cities_translation t0 LEFT JOIN cities t5 ON t0.translatable_id = t5.id WHERE t0.translatable_id = ? Parameters: [`36721`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4, t5.id AS id_6, t5.postcode AS postcode_7, t5.slug AS slug_8, t5.lat AS lat_9, t5.lng AS lng_10, t5.country_id AS country_id_11 FROM cities_translation t0 LEFT JOIN cities t5 ON t0.translatable_id = t5.id WHERE t0.translatable_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4, t5.id AS id_6, t5.postcode AS postcode_7, t5.slug AS slug_8, t5.lat AS lat_9, t5.lng AS lng_10, t5.country_id AS country_id_11 FROM cities_translation t0 LEFT JOIN cities t5 ON t0.translatable_id = t5.id WHERE t0.translatable_id = 36721;
14	0.68 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4, t5.id AS id_6, t5.postcode AS postcode_7, t5.slug AS slug_8, t5.lat AS lat_9, t5.lng AS lng_10, t5.country_id AS country_id_11 FROM cities_translation t0 LEFT JOIN cities t5 ON t0.translatable_id = t5.id WHERE t0.translatable_id = ? Parameters: [`36725`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4, t5.id AS id_6, t5.postcode AS postcode_7, t5.slug AS slug_8, t5.lat AS lat_9, t5.lng AS lng_10, t5.country_id AS country_id_11 FROM cities_translation t0 LEFT JOIN cities t5 ON t0.translatable_id = t5.id WHERE t0.translatable_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4, t5.id AS id_6, t5.postcode AS postcode_7, t5.slug AS slug_8, t5.lat AS lat_9, t5.lng AS lng_10, t5.country_id AS country_id_11 FROM cities_translation t0 LEFT JOIN cities t5 ON t0.translatable_id = t5.id WHERE t0.translatable_id = 36725;
15	0.51 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4, t5.id AS id_6, t5.postcode AS postcode_7, t5.slug AS slug_8, t5.lat AS lat_9, t5.lng AS lng_10, t5.country_id AS country_id_11 FROM cities_translation t0 LEFT JOIN cities t5 ON t0.translatable_id = t5.id WHERE t0.translatable_id = ? Parameters: [`17022`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4, t5.id AS id_6, t5.postcode AS postcode_7, t5.slug AS slug_8, t5.lat AS lat_9, t5.lng AS lng_10, t5.country_id AS country_id_11 FROM cities_translation t0 LEFT JOIN cities t5 ON t0.translatable_id = t5.id WHERE t0.translatable_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4, t5.id AS id_6, t5.postcode AS postcode_7, t5.slug AS slug_8, t5.lat AS lat_9, t5.lng AS lng_10, t5.country_id AS country_id_11 FROM cities_translation t0 LEFT JOIN cities t5 ON t0.translatable_id = t5.id WHERE t0.translatable_id = 17022;
16	0.45 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4, t5.id AS id_6, t5.postcode AS postcode_7, t5.slug AS slug_8, t5.lat AS lat_9, t5.lng AS lng_10, t5.country_id AS country_id_11 FROM cities_translation t0 LEFT JOIN cities t5 ON t0.translatable_id = t5.id WHERE t0.translatable_id = ? Parameters: [`36723`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4, t5.id AS id_6, t5.postcode AS postcode_7, t5.slug AS slug_8, t5.lat AS lat_9, t5.lng AS lng_10, t5.country_id AS country_id_11 FROM cities_translation t0 LEFT JOIN cities t5 ON t0.translatable_id = t5.id WHERE t0.translatable_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4, t5.id AS id_6, t5.postcode AS postcode_7, t5.slug AS slug_8, t5.lat AS lat_9, t5.lng AS lng_10, t5.country_id AS country_id_11 FROM cities_translation t0 LEFT JOIN cities t5 ON t0.translatable_id = t5.id WHERE t0.translatable_id = 36723;
17	0.50 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4, t5.id AS id_6, t5.postcode AS postcode_7, t5.slug AS slug_8, t5.lat AS lat_9, t5.lng AS lng_10, t5.country_id AS country_id_11 FROM cities_translation t0 LEFT JOIN cities t5 ON t0.translatable_id = t5.id WHERE t0.translatable_id = ? Parameters: [`36730`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4, t5.id AS id_6, t5.postcode AS postcode_7, t5.slug AS slug_8, t5.lat AS lat_9, t5.lng AS lng_10, t5.country_id AS country_id_11 FROM cities_translation t0 LEFT JOIN cities t5 ON t0.translatable_id = t5.id WHERE t0.translatable_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4, t5.id AS id_6, t5.postcode AS postcode_7, t5.slug AS slug_8, t5.lat AS lat_9, t5.lng AS lng_10, t5.country_id AS country_id_11 FROM cities_translation t0 LEFT JOIN cities t5 ON t0.translatable_id = t5.id WHERE t0.translatable_id = 36730;
18	0.47 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4, t5.id AS id_6, t5.postcode AS postcode_7, t5.slug AS slug_8, t5.lat AS lat_9, t5.lng AS lng_10, t5.country_id AS country_id_11 FROM cities_translation t0 LEFT JOIN cities t5 ON t0.translatable_id = t5.id WHERE t0.translatable_id = ? Parameters: [`35582`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4, t5.id AS id_6, t5.postcode AS postcode_7, t5.slug AS slug_8, t5.lat AS lat_9, t5.lng AS lng_10, t5.country_id AS country_id_11 FROM cities_translation t0 LEFT JOIN cities t5 ON t0.translatable_id = t5.id WHERE t0.translatable_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4, t5.id AS id_6, t5.postcode AS postcode_7, t5.slug AS slug_8, t5.lat AS lat_9, t5.lng AS lng_10, t5.country_id AS country_id_11 FROM cities_translation t0 LEFT JOIN cities t5 ON t0.translatable_id = t5.id WHERE t0.translatable_id = 35582;
19	0.40 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4, t5.id AS id_6, t5.postcode AS postcode_7, t5.slug AS slug_8, t5.lat AS lat_9, t5.lng AS lng_10, t5.country_id AS country_id_11 FROM cities_translation t0 LEFT JOIN cities t5 ON t0.translatable_id = t5.id WHERE t0.translatable_id = ? Parameters: [`17184`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4, t5.id AS id_6, t5.postcode AS postcode_7, t5.slug AS slug_8, t5.lat AS lat_9, t5.lng AS lng_10, t5.country_id AS country_id_11 FROM cities_translation t0 LEFT JOIN cities t5 ON t0.translatable_id = t5.id WHERE t0.translatable_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4, t5.id AS id_6, t5.postcode AS postcode_7, t5.slug AS slug_8, t5.lat AS lat_9, t5.lng AS lng_10, t5.country_id AS country_id_11 FROM cities_translation t0 LEFT JOIN cities t5 ON t0.translatable_id = t5.id WHERE t0.translatable_id = 17184;
20	0.48 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4, t5.id AS id_6, t5.postcode AS postcode_7, t5.slug AS slug_8, t5.lat AS lat_9, t5.lng AS lng_10, t5.country_id AS country_id_11 FROM cities_translation t0 LEFT JOIN cities t5 ON t0.translatable_id = t5.id WHERE t0.translatable_id = ? Parameters: [`17190`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4, t5.id AS id_6, t5.postcode AS postcode_7, t5.slug AS slug_8, t5.lat AS lat_9, t5.lng AS lng_10, t5.country_id AS country_id_11 FROM cities_translation t0 LEFT JOIN cities t5 ON t0.translatable_id = t5.id WHERE t0.translatable_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4, t5.id AS id_6, t5.postcode AS postcode_7, t5.slug AS slug_8, t5.lat AS lat_9, t5.lng AS lng_10, t5.country_id AS country_id_11 FROM cities_translation t0 LEFT JOIN cities t5 ON t0.translatable_id = t5.id WHERE t0.translatable_id = 17190;
21	0.44 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4, t5.id AS id_6, t5.postcode AS postcode_7, t5.slug AS slug_8, t5.lat AS lat_9, t5.lng AS lng_10, t5.country_id AS country_id_11 FROM cities_translation t0 LEFT JOIN cities t5 ON t0.translatable_id = t5.id WHERE t0.translatable_id = ? Parameters: [`17248`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4, t5.id AS id_6, t5.postcode AS postcode_7, t5.slug AS slug_8, t5.lat AS lat_9, t5.lng AS lng_10, t5.country_id AS country_id_11 FROM cities_translation t0 LEFT JOIN cities t5 ON t0.translatable_id = t5.id WHERE t0.translatable_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4, t5.id AS id_6, t5.postcode AS postcode_7, t5.slug AS slug_8, t5.lat AS lat_9, t5.lng AS lng_10, t5.country_id AS country_id_11 FROM cities_translation t0 LEFT JOIN cities t5 ON t0.translatable_id = t5.id WHERE t0.translatable_id = 17248;
22	0.43 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4, t5.id AS id_6, t5.postcode AS postcode_7, t5.slug AS slug_8, t5.lat AS lat_9, t5.lng AS lng_10, t5.country_id AS country_id_11 FROM cities_translation t0 LEFT JOIN cities t5 ON t0.translatable_id = t5.id WHERE t0.translatable_id = ? Parameters: [`17085`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4, t5.id AS id_6, t5.postcode AS postcode_7, t5.slug AS slug_8, t5.lat AS lat_9, t5.lng AS lng_10, t5.country_id AS country_id_11 FROM cities_translation t0 LEFT JOIN cities t5 ON t0.translatable_id = t5.id WHERE t0.translatable_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4, t5.id AS id_6, t5.postcode AS postcode_7, t5.slug AS slug_8, t5.lat AS lat_9, t5.lng AS lng_10, t5.country_id AS country_id_11 FROM cities_translation t0 LEFT JOIN cities t5 ON t0.translatable_id = t5.id WHERE t0.translatable_id = 17085;
23	0.48 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4, t5.id AS id_6, t5.postcode AS postcode_7, t5.slug AS slug_8, t5.lat AS lat_9, t5.lng AS lng_10, t5.country_id AS country_id_11 FROM cities_translation t0 LEFT JOIN cities t5 ON t0.translatable_id = t5.id WHERE t0.translatable_id = ? Parameters: [`17100`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4, t5.id AS id_6, t5.postcode AS postcode_7, t5.slug AS slug_8, t5.lat AS lat_9, t5.lng AS lng_10, t5.country_id AS country_id_11 FROM cities_translation t0 LEFT JOIN cities t5 ON t0.translatable_id = t5.id WHERE t0.translatable_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4, t5.id AS id_6, t5.postcode AS postcode_7, t5.slug AS slug_8, t5.lat AS lat_9, t5.lng AS lng_10, t5.country_id AS country_id_11 FROM cities_translation t0 LEFT JOIN cities t5 ON t0.translatable_id = t5.id WHERE t0.translatable_id = 17100;
24	0.48 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4, t5.id AS id_6, t5.postcode AS postcode_7, t5.slug AS slug_8, t5.lat AS lat_9, t5.lng AS lng_10, t5.country_id AS country_id_11 FROM cities_translation t0 LEFT JOIN cities t5 ON t0.translatable_id = t5.id WHERE t0.translatable_id = ? Parameters: [`16977`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4, t5.id AS id_6, t5.postcode AS postcode_7, t5.slug AS slug_8, t5.lat AS lat_9, t5.lng AS lng_10, t5.country_id AS country_id_11 FROM cities_translation t0 LEFT JOIN cities t5 ON t0.translatable_id = t5.id WHERE t0.translatable_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4, t5.id AS id_6, t5.postcode AS postcode_7, t5.slug AS slug_8, t5.lat AS lat_9, t5.lng AS lng_10, t5.country_id AS country_id_11 FROM cities_translation t0 LEFT JOIN cities t5 ON t0.translatable_id = t5.id WHERE t0.translatable_id = 16977;
25	0.48 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4, t5.id AS id_6, t5.postcode AS postcode_7, t5.slug AS slug_8, t5.lat AS lat_9, t5.lng AS lng_10, t5.country_id AS country_id_11 FROM cities_translation t0 LEFT JOIN cities t5 ON t0.translatable_id = t5.id WHERE t0.translatable_id = ? Parameters: [`17142`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4, t5.id AS id_6, t5.postcode AS postcode_7, t5.slug AS slug_8, t5.lat AS lat_9, t5.lng AS lng_10, t5.country_id AS country_id_11 FROM cities_translation t0 LEFT JOIN cities t5 ON t0.translatable_id = t5.id WHERE t0.translatable_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4, t5.id AS id_6, t5.postcode AS postcode_7, t5.slug AS slug_8, t5.lat AS lat_9, t5.lng AS lng_10, t5.country_id AS country_id_11 FROM cities_translation t0 LEFT JOIN cities t5 ON t0.translatable_id = t5.id WHERE t0.translatable_id = 17142;
26	0.50 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4, t5.id AS id_6, t5.postcode AS postcode_7, t5.slug AS slug_8, t5.lat AS lat_9, t5.lng AS lng_10, t5.country_id AS country_id_11 FROM cities_translation t0 LEFT JOIN cities t5 ON t0.translatable_id = t5.id WHERE t0.translatable_id = ? Parameters: [`17032`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4, t5.id AS id_6, t5.postcode AS postcode_7, t5.slug AS slug_8, t5.lat AS lat_9, t5.lng AS lng_10, t5.country_id AS country_id_11 FROM cities_translation t0 LEFT JOIN cities t5 ON t0.translatable_id = t5.id WHERE t0.translatable_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4, t5.id AS id_6, t5.postcode AS postcode_7, t5.slug AS slug_8, t5.lat AS lat_9, t5.lng AS lng_10, t5.country_id AS country_id_11 FROM cities_translation t0 LEFT JOIN cities t5 ON t0.translatable_id = t5.id WHERE t0.translatable_id = 17032;
27	0.48 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4, t5.id AS id_6, t5.postcode AS postcode_7, t5.slug AS slug_8, t5.lat AS lat_9, t5.lng AS lng_10, t5.country_id AS country_id_11 FROM cities_translation t0 LEFT JOIN cities t5 ON t0.translatable_id = t5.id WHERE t0.translatable_id = ? Parameters: [`17236`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4, t5.id AS id_6, t5.postcode AS postcode_7, t5.slug AS slug_8, t5.lat AS lat_9, t5.lng AS lng_10, t5.country_id AS country_id_11 FROM cities_translation t0 LEFT JOIN cities t5 ON t0.translatable_id = t5.id WHERE t0.translatable_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4, t5.id AS id_6, t5.postcode AS postcode_7, t5.slug AS slug_8, t5.lat AS lat_9, t5.lng AS lng_10, t5.country_id AS country_id_11 FROM cities_translation t0 LEFT JOIN cities t5 ON t0.translatable_id = t5.id WHERE t0.translatable_id = 17236;
28	0.50 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4, t5.id AS id_6, t5.postcode AS postcode_7, t5.slug AS slug_8, t5.lat AS lat_9, t5.lng AS lng_10, t5.country_id AS country_id_11 FROM cities_translation t0 LEFT JOIN cities t5 ON t0.translatable_id = t5.id WHERE t0.translatable_id = ? Parameters: [`17096`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4, t5.id AS id_6, t5.postcode AS postcode_7, t5.slug AS slug_8, t5.lat AS lat_9, t5.lng AS lng_10, t5.country_id AS country_id_11 FROM cities_translation t0 LEFT JOIN cities t5 ON t0.translatable_id = t5.id WHERE t0.translatable_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4, t5.id AS id_6, t5.postcode AS postcode_7, t5.slug AS slug_8, t5.lat AS lat_9, t5.lng AS lng_10, t5.country_id AS country_id_11 FROM cities_translation t0 LEFT JOIN cities t5 ON t0.translatable_id = t5.id WHERE t0.translatable_id = 17096;
29	0.52 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4, t5.id AS id_6, t5.postcode AS postcode_7, t5.slug AS slug_8, t5.lat AS lat_9, t5.lng AS lng_10, t5.country_id AS country_id_11 FROM cities_translation t0 LEFT JOIN cities t5 ON t0.translatable_id = t5.id WHERE t0.translatable_id = ? Parameters: [`17233`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4, t5.id AS id_6, t5.postcode AS postcode_7, t5.slug AS slug_8, t5.lat AS lat_9, t5.lng AS lng_10, t5.country_id AS country_id_11 FROM cities_translation t0 LEFT JOIN cities t5 ON t0.translatable_id = t5.id WHERE t0.translatable_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4, t5.id AS id_6, t5.postcode AS postcode_7, t5.slug AS slug_8, t5.lat AS lat_9, t5.lng AS lng_10, t5.country_id AS country_id_11 FROM cities_translation t0 LEFT JOIN cities t5 ON t0.translatable_id = t5.id WHERE t0.translatable_id = 17233;
30	0.49 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4, t5.id AS id_6, t5.postcode AS postcode_7, t5.slug AS slug_8, t5.lat AS lat_9, t5.lng AS lng_10, t5.country_id AS country_id_11 FROM cities_translation t0 LEFT JOIN cities t5 ON t0.translatable_id = t5.id WHERE t0.translatable_id = ? Parameters: [`17071`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4, t5.id AS id_6, t5.postcode AS postcode_7, t5.slug AS slug_8, t5.lat AS lat_9, t5.lng AS lng_10, t5.country_id AS country_id_11 FROM cities_translation t0 LEFT JOIN cities t5 ON t0.translatable_id = t5.id WHERE t0.translatable_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4, t5.id AS id_6, t5.postcode AS postcode_7, t5.slug AS slug_8, t5.lat AS lat_9, t5.lng AS lng_10, t5.country_id AS country_id_11 FROM cities_translation t0 LEFT JOIN cities t5 ON t0.translatable_id = t5.id WHERE t0.translatable_id = 17071;
31	0.45 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4, t5.id AS id_6, t5.postcode AS postcode_7, t5.slug AS slug_8, t5.lat AS lat_9, t5.lng AS lng_10, t5.country_id AS country_id_11 FROM cities_translation t0 LEFT JOIN cities t5 ON t0.translatable_id = t5.id WHERE t0.translatable_id = ? Parameters: [`16814`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4, t5.id AS id_6, t5.postcode AS postcode_7, t5.slug AS slug_8, t5.lat AS lat_9, t5.lng AS lng_10, t5.country_id AS country_id_11 FROM cities_translation t0 LEFT JOIN cities t5 ON t0.translatable_id = t5.id WHERE t0.translatable_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4, t5.id AS id_6, t5.postcode AS postcode_7, t5.slug AS slug_8, t5.lat AS lat_9, t5.lng AS lng_10, t5.country_id AS country_id_11 FROM cities_translation t0 LEFT JOIN cities t5 ON t0.translatable_id = t5.id WHERE t0.translatable_id = 16814;
32	0.53 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4, t5.id AS id_6, t5.postcode AS postcode_7, t5.slug AS slug_8, t5.lat AS lat_9, t5.lng AS lng_10, t5.country_id AS country_id_11 FROM cities_translation t0 LEFT JOIN cities t5 ON t0.translatable_id = t5.id WHERE t0.translatable_id = ? Parameters: [`17154`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4, t5.id AS id_6, t5.postcode AS postcode_7, t5.slug AS slug_8, t5.lat AS lat_9, t5.lng AS lng_10, t5.country_id AS country_id_11 FROM cities_translation t0 LEFT JOIN cities t5 ON t0.translatable_id = t5.id WHERE t0.translatable_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4, t5.id AS id_6, t5.postcode AS postcode_7, t5.slug AS slug_8, t5.lat AS lat_9, t5.lng AS lng_10, t5.country_id AS country_id_11 FROM cities_translation t0 LEFT JOIN cities t5 ON t0.translatable_id = t5.id WHERE t0.translatable_id = 17154;
33	0.54 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4, t5.id AS id_6, t5.postcode AS postcode_7, t5.slug AS slug_8, t5.lat AS lat_9, t5.lng AS lng_10, t5.country_id AS country_id_11 FROM cities_translation t0 LEFT JOIN cities t5 ON t0.translatable_id = t5.id WHERE t0.translatable_id = ? Parameters: [`17175`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4, t5.id AS id_6, t5.postcode AS postcode_7, t5.slug AS slug_8, t5.lat AS lat_9, t5.lng AS lng_10, t5.country_id AS country_id_11 FROM cities_translation t0 LEFT JOIN cities t5 ON t0.translatable_id = t5.id WHERE t0.translatable_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4, t5.id AS id_6, t5.postcode AS postcode_7, t5.slug AS slug_8, t5.lat AS lat_9, t5.lng AS lng_10, t5.country_id AS country_id_11 FROM cities_translation t0 LEFT JOIN cities t5 ON t0.translatable_id = t5.id WHERE t0.translatable_id = 17175;
34	0.43 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4, t5.id AS id_6, t5.postcode AS postcode_7, t5.slug AS slug_8, t5.lat AS lat_9, t5.lng AS lng_10, t5.country_id AS country_id_11 FROM cities_translation t0 LEFT JOIN cities t5 ON t0.translatable_id = t5.id WHERE t0.translatable_id = ? Parameters: [`36314`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4, t5.id AS id_6, t5.postcode AS postcode_7, t5.slug AS slug_8, t5.lat AS lat_9, t5.lng AS lng_10, t5.country_id AS country_id_11 FROM cities_translation t0 LEFT JOIN cities t5 ON t0.translatable_id = t5.id WHERE t0.translatable_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4, t5.id AS id_6, t5.postcode AS postcode_7, t5.slug AS slug_8, t5.lat AS lat_9, t5.lng AS lng_10, t5.country_id AS country_id_11 FROM cities_translation t0 LEFT JOIN cities t5 ON t0.translatable_id = t5.id WHERE t0.translatable_id = 36314;
35	0.58 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4, t5.id AS id_6, t5.postcode AS postcode_7, t5.slug AS slug_8, t5.lat AS lat_9, t5.lng AS lng_10, t5.country_id AS country_id_11 FROM cities_translation t0 LEFT JOIN cities t5 ON t0.translatable_id = t5.id WHERE t0.translatable_id = ? Parameters: [`16813`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4, t5.id AS id_6, t5.postcode AS postcode_7, t5.slug AS slug_8, t5.lat AS lat_9, t5.lng AS lng_10, t5.country_id AS country_id_11 FROM cities_translation t0 LEFT JOIN cities t5 ON t0.translatable_id = t5.id WHERE t0.translatable_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4, t5.id AS id_6, t5.postcode AS postcode_7, t5.slug AS slug_8, t5.lat AS lat_9, t5.lng AS lng_10, t5.country_id AS country_id_11 FROM cities_translation t0 LEFT JOIN cities t5 ON t0.translatable_id = t5.id WHERE t0.translatable_id = 16813;
36	0.47 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4, t5.id AS id_6, t5.postcode AS postcode_7, t5.slug AS slug_8, t5.lat AS lat_9, t5.lng AS lng_10, t5.country_id AS country_id_11 FROM cities_translation t0 LEFT JOIN cities t5 ON t0.translatable_id = t5.id WHERE t0.translatable_id = ? Parameters: [`17014`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4, t5.id AS id_6, t5.postcode AS postcode_7, t5.slug AS slug_8, t5.lat AS lat_9, t5.lng AS lng_10, t5.country_id AS country_id_11 FROM cities_translation t0 LEFT JOIN cities t5 ON t0.translatable_id = t5.id WHERE t0.translatable_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4, t5.id AS id_6, t5.postcode AS postcode_7, t5.slug AS slug_8, t5.lat AS lat_9, t5.lng AS lng_10, t5.country_id AS country_id_11 FROM cities_translation t0 LEFT JOIN cities t5 ON t0.translatable_id = t5.id WHERE t0.translatable_id = 17014;
37	0.54 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4, t5.id AS id_6, t5.postcode AS postcode_7, t5.slug AS slug_8, t5.lat AS lat_9, t5.lng AS lng_10, t5.country_id AS country_id_11 FROM cities_translation t0 LEFT JOIN cities t5 ON t0.translatable_id = t5.id WHERE t0.translatable_id = ? Parameters: [`16423`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4, t5.id AS id_6, t5.postcode AS postcode_7, t5.slug AS slug_8, t5.lat AS lat_9, t5.lng AS lng_10, t5.country_id AS country_id_11 FROM cities_translation t0 LEFT JOIN cities t5 ON t0.translatable_id = t5.id WHERE t0.translatable_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4, t5.id AS id_6, t5.postcode AS postcode_7, t5.slug AS slug_8, t5.lat AS lat_9, t5.lng AS lng_10, t5.country_id AS country_id_11 FROM cities_translation t0 LEFT JOIN cities t5 ON t0.translatable_id = t5.id WHERE t0.translatable_id = 16423;
38	0.54 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4, t5.id AS id_6, t5.postcode AS postcode_7, t5.slug AS slug_8, t5.lat AS lat_9, t5.lng AS lng_10, t5.country_id AS country_id_11 FROM cities_translation t0 LEFT JOIN cities t5 ON t0.translatable_id = t5.id WHERE t0.translatable_id = ? Parameters: [`17099`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4, t5.id AS id_6, t5.postcode AS postcode_7, t5.slug AS slug_8, t5.lat AS lat_9, t5.lng AS lng_10, t5.country_id AS country_id_11 FROM cities_translation t0 LEFT JOIN cities t5 ON t0.translatable_id = t5.id WHERE t0.translatable_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4, t5.id AS id_6, t5.postcode AS postcode_7, t5.slug AS slug_8, t5.lat AS lat_9, t5.lng AS lng_10, t5.country_id AS country_id_11 FROM cities_translation t0 LEFT JOIN cities t5 ON t0.translatable_id = t5.id WHERE t0.translatable_id = 17099;
39	0.48 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4, t5.id AS id_6, t5.postcode AS postcode_7, t5.slug AS slug_8, t5.lat AS lat_9, t5.lng AS lng_10, t5.country_id AS country_id_11 FROM cities_translation t0 LEFT JOIN cities t5 ON t0.translatable_id = t5.id WHERE t0.translatable_id = ? Parameters: [`17006`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4, t5.id AS id_6, t5.postcode AS postcode_7, t5.slug AS slug_8, t5.lat AS lat_9, t5.lng AS lng_10, t5.country_id AS country_id_11 FROM cities_translation t0 LEFT JOIN cities t5 ON t0.translatable_id = t5.id WHERE t0.translatable_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4, t5.id AS id_6, t5.postcode AS postcode_7, t5.slug AS slug_8, t5.lat AS lat_9, t5.lng AS lng_10, t5.country_id AS country_id_11 FROM cities_translation t0 LEFT JOIN cities t5 ON t0.translatable_id = t5.id WHERE t0.translatable_id = 17006;
40	0.53 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4, t5.id AS id_6, t5.postcode AS postcode_7, t5.slug AS slug_8, t5.lat AS lat_9, t5.lng AS lng_10, t5.country_id AS country_id_11 FROM cities_translation t0 LEFT JOIN cities t5 ON t0.translatable_id = t5.id WHERE t0.translatable_id = ? Parameters: [`34631`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4, t5.id AS id_6, t5.postcode AS postcode_7, t5.slug AS slug_8, t5.lat AS lat_9, t5.lng AS lng_10, t5.country_id AS country_id_11 FROM cities_translation t0 LEFT JOIN cities t5 ON t0.translatable_id = t5.id WHERE t0.translatable_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4, t5.id AS id_6, t5.postcode AS postcode_7, t5.slug AS slug_8, t5.lat AS lat_9, t5.lng AS lng_10, t5.country_id AS country_id_11 FROM cities_translation t0 LEFT JOIN cities t5 ON t0.translatable_id = t5.id WHERE t0.translatable_id = 34631;
41	0.47 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4, t5.id AS id_6, t5.postcode AS postcode_7, t5.slug AS slug_8, t5.lat AS lat_9, t5.lng AS lng_10, t5.country_id AS country_id_11 FROM cities_translation t0 LEFT JOIN cities t5 ON t0.translatable_id = t5.id WHERE t0.translatable_id = ? Parameters: [`16815`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4, t5.id AS id_6, t5.postcode AS postcode_7, t5.slug AS slug_8, t5.lat AS lat_9, t5.lng AS lng_10, t5.country_id AS country_id_11 FROM cities_translation t0 LEFT JOIN cities t5 ON t0.translatable_id = t5.id WHERE t0.translatable_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4, t5.id AS id_6, t5.postcode AS postcode_7, t5.slug AS slug_8, t5.lat AS lat_9, t5.lng AS lng_10, t5.country_id AS country_id_11 FROM cities_translation t0 LEFT JOIN cities t5 ON t0.translatable_id = t5.id WHERE t0.translatable_id = 16815;
42	0.44 ms	SELECT m0_.id AS id_0, m0_.date_publication AS date_publication_1, m0_.date_unpublication AS date_unpublication_2, m0_.on_account AS on_account_3, m0_.on_back_office AS on_back_office_4, m0_.on_website AS on_website_5, m0_.on_intranet AS on_intranet_6, m0_.on_ticketing AS on_ticketing_7, m1_.id AS id_8, m1_.title AS title_9, m1_.content AS content_10, m1_.locale AS locale_11, m1_.translatable_id AS translatable_id_12 FROM messages m0_ INNER JOIN messages_translation m1_ ON m0_.id = m1_.translatable_id WHERE m0_.on_account = 1 AND m0_.date_publication <= CURRENT_DATE AND m0_.date_unpublication > CURRENT_DATE ORDER BY m0_.date_publication DESC Parameters: [] View formatted query View runnable query Explain query SELECT m0_.id AS id_0, m0_.date_publication AS date_publication_1, m0_.date_unpublication AS date_unpublication_2, m0_.on_account AS on_account_3, m0_.on_back_office AS on_back_office_4, m0_.on_website AS on_website_5, m0_.on_intranet AS on_intranet_6, m0_.on_ticketing AS on_ticketing_7, m1_.id AS id_8, m1_.title AS title_9, m1_.content AS content_10, m1_.locale AS locale_11, m1_.translatable_id AS translatable_id_12 FROM messages m0_ INNER JOIN messages_translation m1_ ON m0_.id = m1_.translatable_id WHERE m0_.on_account = 1 AND m0_.date_publication <= CURRENT_DATE AND m0_.date_unpublication > CURRENT_DATE ORDER BY m0_.date_publication DESC SELECT m0_.id AS id_0, m0_.date_publication AS date_publication_1, m0_.date_unpublication AS date_unpublication_2, m0_.on_account AS on_account_3, m0_.on_back_office AS on_back_office_4, m0_.on_website AS on_website_5, m0_.on_intranet AS on_intranet_6, m0_.on_ticketing AS on_ticketing_7, m1_.id AS id_8, m1_.title AS title_9, m1_.content AS content_10, m1_.locale AS locale_11, m1_.translatable_id AS translatable_id_12 FROM messages m0_ INNER JOIN messages_translation m1_ ON m0_.id = m1_.translatable_id WHERE m0_.on_account = 1 AND m0_.date_publication <= CURRENT_DATE AND m0_.date_unpublication > CURRENT_DATE ORDER BY m0_.date_publication DESC;
43	0.95 ms	SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.description AS description_2, p0_.address AS address_3, p0_.additional_address AS additional_address_4, p0_.postcode AS postcode_5, p0_.identify_number AS identify_number_6, p0_.website AS website_7, p0_.prepaid_amount AS prepaid_amount_8, p0_.sponsor_code AS sponsor_code_9, p0_.sponsor_points AS sponsor_points_10, p0_.reference AS reference_11, p0_.sepa_name AS sepa_name_12, p0_.population AS population_13, p0_.typology AS typology_14, p0_.is_rdc AS is_rdc_15, p0_.is_contract_historic AS is_contract_historic_16, p0_.collectivity_service_code AS collectivity_service_code_17, p0_.is_number_ej AS is_number_ej_18, p0_.demo AS demo_19, p0_.vat AS vat_20, p0_.logo AS logo_21, p0_.is_data_different_invoice AS is_data_different_invoice_22, p0_.other_name AS other_name_23, p0_.other_address AS other_address_24, p0_.other_identify_number AS other_identify_number_25, p0_.manual_renewal AS manual_renewal_26, p0_.testimony_answered AS testimony_answered_27, p0_.is_cmd AS is_cmd_28, p0_.notes AS notes_29, p0_.date_invitation_ceo_interview AS date_invitation_ceo_interview_30, p0_.date_ceo_interview AS date_ceo_interview_31, p0_.top_ranking AS top_ranking_32, p0_.rdc_feeling AS rdc_feeling_33, p0_.created_at AS created_at_34, p0_.updated_at AS updated_at_35, p0_.deleted_at AS deleted_at_36, p0_.lat AS lat_37, p0_.lng AS lng_38, p1_.date_end AS date_end_39, p1_.status AS status_40, p1_.additional_size AS additional_size_41, p1_.free AS free_42, p1_.next_data AS next_data_43, p1_.pending_order AS pending_order_44, p1_.size_platform AS size_platform_45, p1_.pack AS pack_46, p1_.reminded_at AS reminded_at_47, p1_.delete_at AS delete_at_48, p1_.locked AS locked_49, p1_.renewal_refused AS renewal_refused_50, p1_.renewal_refused_reason AS renewal_refused_reason_51, p1_.renewal_refused_filename AS renewal_refused_filename_52, p2_.id AS id_53, p2_.name AS name_54, p2_.always_checked AS always_checked_55, p2_.projecttool_key AS projecttool_key_56, p2_.max_size AS max_size_57, p2_.index_route AS index_route_58, p2_.enabled AS enabled_59, p0_.type_id AS type_id_60, p0_.category_id AS category_id_61, p0_.city_id AS city_id_62, p0_.user_id AS user_id_63, p0_.othet_city_id AS othet_city_id_64, p0_.intercommunality_id AS intercommunality_id_65, p0_.attachments AS attachments_66, p1_.projecttool_id AS projecttool_id_67, p1_.project_id AS project_id_68 FROM projects p0_ INNER JOIN users_access u3_ ON (p0_.id = u3_.project_id) INNER JOIN users u4_ ON (u4_.id = u3_.user_id) LEFT JOIN projects_projecttools p1_ ON p0_.id = p1_.project_id LEFT JOIN projecttools p2_ ON p1_.projecttool_id = p2_.id WHERE u4_.id = ? Parameters: [`2797`] View formatted query View runnable query Explain query SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.description AS description_2, p0_.address AS address_3, p0_.additional_address AS additional_address_4, p0_.postcode AS postcode_5, p0_.identify_number AS identify_number_6, p0_.website AS website_7, p0_.prepaid_amount AS prepaid_amount_8, p0_.sponsor_code AS sponsor_code_9, p0_.sponsor_points AS sponsor_points_10, p0_.reference AS reference_11, p0_.sepa_name AS sepa_name_12, p0_.population AS population_13, p0_.typology AS typology_14, p0_.is_rdc AS is_rdc_15, p0_.is_contract_historic AS is_contract_historic_16, p0_.collectivity_service_code AS collectivity_service_code_17, p0_.is_number_ej AS is_number_ej_18, p0_.demo AS demo_19, p0_.vat AS vat_20, p0_.logo AS logo_21, p0_.is_data_different_invoice AS is_data_different_invoice_22, p0_.other_name AS other_name_23, p0_.other_address AS other_address_24, p0_.other_identify_number AS other_identify_number_25, p0_.manual_renewal AS manual_renewal_26, p0_.testimony_answered AS testimony_answered_27, p0_.is_cmd AS is_cmd_28, p0_.notes AS notes_29, p0_.date_invitation_ceo_interview AS date_invitation_ceo_interview_30, p0_.date_ceo_interview AS date_ceo_interview_31, p0_.top_ranking AS top_ranking_32, p0_.rdc_feeling AS rdc_feeling_33, p0_.created_at AS created_at_34, p0_.updated_at AS updated_at_35, p0_.deleted_at AS deleted_at_36, p0_.lat AS lat_37, p0_.lng AS lng_38, p1_.date_end AS date_end_39, p1_.status AS status_40, p1_.additional_size AS additional_size_41, p1_.free AS free_42, p1_.next_data AS next_data_43, p1_.pending_order AS pending_order_44, p1_.size_platform AS size_platform_45, p1_.pack AS pack_46, p1_.reminded_at AS reminded_at_47, p1_.delete_at AS delete_at_48, p1_.locked AS locked_49, p1_.renewal_refused AS renewal_refused_50, p1_.renewal_refused_reason AS renewal_refused_reason_51, p1_.renewal_refused_filename AS renewal_refused_filename_52, p2_.id AS id_53, p2_.name AS name_54, p2_.always_checked AS always_checked_55, p2_.projecttool_key AS projecttool_key_56, p2_.max_size AS max_size_57, p2_.index_route AS index_route_58, p2_.enabled AS enabled_59, p0_.type_id AS type_id_60, p0_.category_id AS category_id_61, p0_.city_id AS city_id_62, p0_.user_id AS user_id_63, p0_.othet_city_id AS othet_city_id_64, p0_.intercommunality_id AS intercommunality_id_65, p0_.attachments AS attachments_66, p1_.projecttool_id AS projecttool_id_67, p1_.project_id AS project_id_68 FROM projects p0_ INNER JOIN users_access u3_ ON (p0_.id = u3_.project_id) INNER JOIN users u4_ ON (u4_.id = u3_.user_id) LEFT JOIN projects_projecttools p1_ ON p0_.id = p1_.project_id LEFT JOIN projecttools p2_ ON p1_.projecttool_id = p2_.id WHERE u4_.id = ? SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.description AS description_2, p0_.address AS address_3, p0_.additional_address AS additional_address_4, p0_.postcode AS postcode_5, p0_.identify_number AS identify_number_6, p0_.website AS website_7, p0_.prepaid_amount AS prepaid_amount_8, p0_.sponsor_code AS sponsor_code_9, p0_.sponsor_points AS sponsor_points_10, p0_.reference AS reference_11, p0_.sepa_name AS sepa_name_12, p0_.population AS population_13, p0_.typology AS typology_14, p0_.is_rdc AS is_rdc_15, p0_.is_contract_historic AS is_contract_historic_16, p0_.collectivity_service_code AS collectivity_service_code_17, p0_.is_number_ej AS is_number_ej_18, p0_.demo AS demo_19, p0_.vat AS vat_20, p0_.logo AS logo_21, p0_.is_data_different_invoice AS is_data_different_invoice_22, p0_.other_name AS other_name_23, p0_.other_address AS other_address_24, p0_.other_identify_number AS other_identify_number_25, p0_.manual_renewal AS manual_renewal_26, p0_.testimony_answered AS testimony_answered_27, p0_.is_cmd AS is_cmd_28, p0_.notes AS notes_29, p0_.date_invitation_ceo_interview AS date_invitation_ceo_interview_30, p0_.date_ceo_interview AS date_ceo_interview_31, p0_.top_ranking AS top_ranking_32, p0_.rdc_feeling AS rdc_feeling_33, p0_.created_at AS created_at_34, p0_.updated_at AS updated_at_35, p0_.deleted_at AS deleted_at_36, p0_.lat AS lat_37, p0_.lng AS lng_38, p1_.date_end AS date_end_39, p1_.status AS status_40, p1_.additional_size AS additional_size_41, p1_.free AS free_42, p1_.next_data AS next_data_43, p1_.pending_order AS pending_order_44, p1_.size_platform AS size_platform_45, p1_.pack AS pack_46, p1_.reminded_at AS reminded_at_47, p1_.delete_at AS delete_at_48, p1_.locked AS locked_49, p1_.renewal_refused AS renewal_refused_50, p1_.renewal_refused_reason AS renewal_refused_reason_51, p1_.renewal_refused_filename AS renewal_refused_filename_52, p2_.id AS id_53, p2_.name AS name_54, p2_.always_checked AS always_checked_55, p2_.projecttool_key AS projecttool_key_56, p2_.max_size AS max_size_57, p2_.index_route AS index_route_58, p2_.enabled AS enabled_59, p0_.type_id AS type_id_60, p0_.category_id AS category_id_61, p0_.city_id AS city_id_62, p0_.user_id AS user_id_63, p0_.othet_city_id AS othet_city_id_64, p0_.intercommunality_id AS intercommunality_id_65, p0_.attachments AS attachments_66, p1_.projecttool_id AS projecttool_id_67, p1_.project_id AS project_id_68 FROM projects p0_ INNER JOIN users_access u3_ ON (p0_.id = u3_.project_id) INNER JOIN users u4_ ON (u4_.id = u3_.user_id) LEFT JOIN projects_projecttools p1_ ON p0_.id = p1_.project_id LEFT JOIN projecttools p2_ ON p1_.projecttool_id = p2_.id WHERE u4_.id = 2797;

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\Project\Project	102
App\Entity\Location\City	34
App\Entity\Location\CityTranslation	34
App\Entity\User	31
App\Entity\Project\Category	18
App\Entity\Project\ProjectType	4
App\Entity\Project\Projecttool	3
App\Entity\Project\ProjectProjecttool	2
App\Entity\AdministratorGroup	1
App\Entity\Location\Country	1

Entities Mapping

Class	Mapping errors
App\Entity\User	No errors.
App\Entity\Location\City	No errors.
App\Entity\AdministratorGroup	No errors.
App\Entity\Project\Project	No errors.
App\Entity\UserAccess	No errors.
App\Entity\Project\ProjectProjecttool	No errors.
App\Entity\Project\Projecttool	No errors.
App\Entity\Project\ProjectType	No errors.
App\Entity\Project\Category	No errors.
App\Entity\Intercommunality	No errors.
App\Entity\Project\ProjectRefuseAttachment	No errors.
App\Entity\ToolSite\SiteModule	No errors.
App\Entity\Project\ProjectMod	No errors.
App\Entity\Project\ProjectRelation	No errors.
App\Entity\Project\ProjectContact	The field 'App\Entity\Project\ProjectContact#type' has the property type 'string' that differs from the metadata field type 'int' returned by the 'smallint' DBAL type.
App\Entity\Order	No errors.
App\Entity\Historic\Contract	No errors.
App\Entity\Location\Country	No errors.
App\Entity\Location\ZoneArea	No errors.
App\Entity\Location\CityTranslation	No errors.
App\Entity\Message	No errors.
App\Entity\MessageTranslation	No errors.

Symfony Profiler

GET https://account.staging.neopse.com/_fragment?_path=_format%3Dhtml%26_locale%3Dfr%26_controller%3DApp%255CController%255CAccount%255CInterfaceController%253A%253…

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping