Symfony Profiler

Query Metrics

45 Database Queries

12 Different statements

64.76 ms Query time

0 Invalid entities

Queries


SELECT d0_.id AS id_0, d0_.label AS label_1, d0_.code AS code_2, d0_.slug AS slug_3, r1_.id AS id_4, r1_.label AS label_5, r1_.slug AS slug_6, d0_.region_id AS region_id_7 FROM department d0_ INNER JOIN region r1_ ON d0_.region_id = r1_.id WHERE d0_.region_id = ? AND d0_.id IN (?) ORDER BY d0_.code ASC
SELECT r0_.id AS id_0, r0_.label AS label_1 FROM report_category r0_ WHERE r0_.id IN (?)
SELECT r0_.id AS id_0, r0_.label AS label_1, r0_.sort AS sort_2 FROM report_status r0_ WHERE r0_.id IN (?, ?, ?, ?) ORDER BY r0_.sort ASC
SELECT r0_.id AS id_0, r0_.label AS label_1, r0_.sort AS sort_2 FROM report_status r0_ WHERE r0_.id IN (?, ?, ?, ?) ORDER BY r0_.sort ASC
SELECT count(DISTINCT r0_.id) AS sclr_0 FROM report r0_ LEFT JOIN city c1_ ON r0_.city_id = c1_.id LEFT JOIN department d2_ ON c1_.department_id = d2_.id LEFT JOIN report_category r3_ ON r0_.report_category_id = r3_.id LEFT JOIN report_status r4_ ON r0_.report_status_id = r4_.id WHERE d2_.id = ? AND r3_.id = ? AND (r4_.id = ? OR r4_.id = ? OR r4_.id = ? OR r4_.id = ?)
SELECT DISTINCT r0_.id AS id_0, r0_.id AS id_1 FROM report r0_ LEFT JOIN city c1_ ON r0_.city_id = c1_.id LEFT JOIN department d2_ ON c1_.department_id = d2_.id LEFT JOIN report_category r3_ ON r0_.report_category_id = r3_.id LEFT JOIN report_status r4_ ON r0_.report_status_id = r4_.id WHERE d2_.id = ? AND r3_.id = ? AND (r4_.id = ? OR r4_.id = ? OR r4_.id = ? OR r4_.id = ?) ORDER BY r0_.id ASC LIMIT 25
SELECT r0_.id AS id_0, r0_.email AS email_1, r0_.date AS date_2, r0_.first_name AS first_name_3, r0_.last_name AS last_name_4, r0_.phone_number AS phone_number_5, r0_.address AS address_6, r0_.latitude AS latitude_7, r0_.longitude AS longitude_8, r0_.position_approximate AS position_approximate_9, r0_.close_to_sensitive_site AS close_to_sensitive_site_10, r0_.other_nest_support AS other_nest_support_11, r0_.nest_height AS nest_height_12, r0_.nest_diameter_centimeters AS nest_diameter_centimeters_13, r0_.nest_access_by_vehicle AS nest_access_by_vehicle_14, r0_.nest_active AS nest_active_15, r0_.property_owner AS property_owner_16, r0_.property_owner_email AS property_owner_email_17, r0_.property_owner_first_name AS property_owner_first_name_18, r0_.property_owner_last_name AS property_owner_last_name_19, r0_.property_owner_phone_number AS property_owner_phone_number_20, r0_.fenced_property AS fenced_property_21, r0_.distance_from_road AS distance_from_road_22, r0_.additional_info AS additional_info_23, r0_.hives AS hives_24, r0_.followup_note AS followup_note_25, r0_.intervention_date AS intervention_date_26, r0_.processing_date AS processing_date_27, r0_.other_nest_destruction_method AS other_nest_destruction_method_28, r0_.destroyed_with_insecticide AS destroyed_with_insecticide_29, r0_.insecticide_name AS insecticide_name_30, r0_.nest_removed AS nest_removed_31, r0_.nest_removal_date AS nest_removal_date_32, r0_.nest_non_removal_reason AS nest_non_removal_reason_33, r0_.nest_disposal_date AS nest_disposal_date_34, r0_.other_nest_disposal_method_without_insecticide AS other_nest_disposal_method_without_insecticide_35, r0_.other_nest_disposal_method_with_insecticide AS other_nest_disposal_method_with_insecticide_36, r0_.community_label AS community_label_37, r0_.exterminator_accepted_report AS exterminator_accepted_report_38, r0_.exterminator_affectation_date AS exterminator_affectation_date_39, r0_.archived AS archived_40, r0_.created_at AS created_at_41, r0_.updated_at AS updated_at_42, r0_.city_id AS city_id_43, r0_.nest_destruction_method_id AS nest_destruction_method_id_44, r0_.nest_disposal_method_id AS nest_disposal_method_id_45, r0_.nest_support_category_id AS nest_support_category_id_46, r0_.original_report_id AS original_report_id_47, r0_.report_category_id AS report_category_id_48, r0_.report_status_id AS report_status_id_49, r0_.report_substatus_id AS report_substatus_id_50, r0_.author_id AS author_id_51, r0_.advisor_id AS advisor_id_52, r0_.exterminator_id AS exterminator_id_53, r0_.funding_status_id AS funding_status_id_54 FROM report r0_ LEFT JOIN city c1_ ON r0_.city_id = c1_.id LEFT JOIN department d2_ ON c1_.department_id = d2_.id LEFT JOIN report_category r3_ ON r0_.report_category_id = r3_.id LEFT JOIN report_status r4_ ON r0_.report_status_id = r4_.id WHERE d2_.id = ? AND r3_.id = ? AND (r4_.id = ? OR r4_.id = ? OR r4_.id = ? OR r4_.id = ?) AND r0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY r0_.id ASC
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.last_login AS last_login_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.phone_number AS phone_number_8, t0.address AS address_9, t0.enabled AS enabled_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.city_id AS city_id_13, t0.discr, t0.unavailability_start_date AS unavailability_start_date_14, t0.unavailability_end_date AS unavailability_end_date_15, t0.is_validated AS is_validated_16, t0.company_name AS company_name_17, t0.company_prices AS company_prices_18, t0.comment AS comment_19, t0.viewer_category_id AS viewer_category_id_20 FROM user t0 WHERE t0.id = ? AND t0.discr IN ('administrator', 'advisor', 'sector_manager', 'declarant', 'exterminator', 'supervisor', 'viewer')
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.last_login AS last_login_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.phone_number AS phone_number_8, t0.address AS address_9, t0.enabled AS enabled_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.city_id AS city_id_13, t0.discr, t0.unavailability_start_date AS unavailability_start_date_14, t0.unavailability_end_date AS unavailability_end_date_15, t0.is_validated AS is_validated_16, t0.company_name AS company_name_17, t0.company_prices AS company_prices_18, t0.comment AS comment_19, t0.viewer_category_id AS viewer_category_id_20 FROM user t0 WHERE t0.id = ? AND t0.discr IN ('administrator', 'advisor', 'sector_manager', 'declarant', 'exterminator', 'supervisor', 'viewer')
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.last_login AS last_login_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.phone_number AS phone_number_8, t0.address AS address_9, t0.enabled AS enabled_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.city_id AS city_id_13, t0.discr, t0.unavailability_start_date AS unavailability_start_date_14, t0.unavailability_end_date AS unavailability_end_date_15, t0.is_validated AS is_validated_16, t0.company_name AS company_name_17, t0.company_prices AS company_prices_18, t0.comment AS comment_19, t0.viewer_category_id AS viewer_category_id_20 FROM user t0 WHERE t0.id = ? AND t0.discr IN ('administrator', 'advisor', 'sector_manager', 'declarant', 'exterminator', 'supervisor', 'viewer')
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.last_login AS last_login_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.phone_number AS phone_number_8, t0.address AS address_9, t0.enabled AS enabled_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.city_id AS city_id_13, t0.discr, t0.unavailability_start_date AS unavailability_start_date_14, t0.unavailability_end_date AS unavailability_end_date_15, t0.is_validated AS is_validated_16, t0.company_name AS company_name_17, t0.company_prices AS company_prices_18, t0.comment AS comment_19, t0.viewer_category_id AS viewer_category_id_20 FROM user t0 WHERE t0.id = ? AND t0.discr IN ('administrator', 'advisor', 'sector_manager', 'declarant', 'exterminator', 'supervisor', 'viewer')
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.last_login AS last_login_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.phone_number AS phone_number_8, t0.address AS address_9, t0.enabled AS enabled_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.city_id AS city_id_13, t0.discr, t0.unavailability_start_date AS unavailability_start_date_14, t0.unavailability_end_date AS unavailability_end_date_15, t0.is_validated AS is_validated_16, t0.company_name AS company_name_17, t0.company_prices AS company_prices_18, t0.comment AS comment_19, t0.viewer_category_id AS viewer_category_id_20 FROM user t0 WHERE t0.id = ? AND t0.discr IN ('administrator', 'advisor', 'sector_manager', 'declarant', 'exterminator', 'supervisor', 'viewer')
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.last_login AS last_login_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.phone_number AS phone_number_8, t0.address AS address_9, t0.enabled AS enabled_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.city_id AS city_id_13, t0.discr, t0.unavailability_start_date AS unavailability_start_date_14, t0.unavailability_end_date AS unavailability_end_date_15, t0.is_validated AS is_validated_16, t0.company_name AS company_name_17, t0.company_prices AS company_prices_18, t0.comment AS comment_19, t0.viewer_category_id AS viewer_category_id_20 FROM user t0 WHERE t0.id = ? AND t0.discr IN ('administrator', 'advisor', 'sector_manager', 'declarant', 'exterminator', 'supervisor', 'viewer')
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.last_login AS last_login_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.phone_number AS phone_number_8, t0.address AS address_9, t0.enabled AS enabled_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.city_id AS city_id_13, t0.discr, t0.unavailability_start_date AS unavailability_start_date_14, t0.unavailability_end_date AS unavailability_end_date_15, t0.is_validated AS is_validated_16, t0.company_name AS company_name_17, t0.company_prices AS company_prices_18, t0.comment AS comment_19, t0.viewer_category_id AS viewer_category_id_20 FROM user t0 WHERE t0.id = ? AND t0.discr IN ('administrator', 'advisor', 'sector_manager', 'declarant', 'exterminator', 'supervisor', 'viewer')
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.last_login AS last_login_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.phone_number AS phone_number_8, t0.address AS address_9, t0.enabled AS enabled_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.city_id AS city_id_13, t0.discr, t0.unavailability_start_date AS unavailability_start_date_14, t0.unavailability_end_date AS unavailability_end_date_15, t0.is_validated AS is_validated_16, t0.company_name AS company_name_17, t0.company_prices AS company_prices_18, t0.comment AS comment_19, t0.viewer_category_id AS viewer_category_id_20 FROM user t0 WHERE t0.id = ? AND t0.discr IN ('administrator', 'advisor', 'sector_manager', 'declarant', 'exterminator', 'supervisor', 'viewer')
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.last_login AS last_login_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.phone_number AS phone_number_8, t0.address AS address_9, t0.enabled AS enabled_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.city_id AS city_id_13, t0.discr, t0.unavailability_start_date AS unavailability_start_date_14, t0.unavailability_end_date AS unavailability_end_date_15, t0.is_validated AS is_validated_16, t0.company_name AS company_name_17, t0.company_prices AS company_prices_18, t0.comment AS comment_19, t0.viewer_category_id AS viewer_category_id_20 FROM user t0 WHERE t0.id = ? AND t0.discr IN ('administrator', 'advisor', 'sector_manager', 'declarant', 'exterminator', 'supervisor', 'viewer')
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.last_login AS last_login_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.phone_number AS phone_number_8, t0.address AS address_9, t0.enabled AS enabled_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.city_id AS city_id_13, t0.discr, t0.unavailability_start_date AS unavailability_start_date_14, t0.unavailability_end_date AS unavailability_end_date_15, t0.is_validated AS is_validated_16, t0.company_name AS company_name_17, t0.company_prices AS company_prices_18, t0.comment AS comment_19, t0.viewer_category_id AS viewer_category_id_20 FROM user t0 WHERE t0.id = ? AND t0.discr IN ('administrator', 'advisor', 'sector_manager', 'declarant', 'exterminator', 'supervisor', 'viewer')
SELECT t0.id AS id_1, t0.label AS label_2, t0.postal_code AS postal_code_3, t0.insee_code AS insee_code_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.slug AS slug_7, t0.department_id AS department_id_8, t0.community_id AS community_id_9, t0.funding_status_id AS funding_status_id_10 FROM city t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.label AS label_2, t0.postal_code AS postal_code_3, t0.insee_code AS insee_code_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.slug AS slug_7, t0.department_id AS department_id_8, t0.community_id AS community_id_9, t0.funding_status_id AS funding_status_id_10 FROM city t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.label AS label_2, t0.postal_code AS postal_code_3, t0.insee_code AS insee_code_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.slug AS slug_7, t0.department_id AS department_id_8, t0.community_id AS community_id_9, t0.funding_status_id AS funding_status_id_10 FROM city t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.label AS label_2, t0.sort AS sort_3 FROM nest_support_category t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.label AS label_2, t0.postal_code AS postal_code_3, t0.insee_code AS insee_code_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.slug AS slug_7, t0.department_id AS department_id_8, t0.community_id AS community_id_9, t0.funding_status_id AS funding_status_id_10 FROM city t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.label AS label_2, t0.postal_code AS postal_code_3, t0.insee_code AS insee_code_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.slug AS slug_7, t0.department_id AS department_id_8, t0.community_id AS community_id_9, t0.funding_status_id AS funding_status_id_10 FROM city t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.label AS label_2, t0.postal_code AS postal_code_3, t0.insee_code AS insee_code_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.slug AS slug_7, t0.department_id AS department_id_8, t0.community_id AS community_id_9, t0.funding_status_id AS funding_status_id_10 FROM city t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.label AS label_2, t0.postal_code AS postal_code_3, t0.insee_code AS insee_code_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.slug AS slug_7, t0.department_id AS department_id_8, t0.community_id AS community_id_9, t0.funding_status_id AS funding_status_id_10 FROM city t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.label AS label_2, t0.postal_code AS postal_code_3, t0.insee_code AS insee_code_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.slug AS slug_7, t0.department_id AS department_id_8, t0.community_id AS community_id_9, t0.funding_status_id AS funding_status_id_10 FROM city t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.label AS label_2, t0.postal_code AS postal_code_3, t0.insee_code AS insee_code_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.slug AS slug_7, t0.department_id AS department_id_8, t0.community_id AS community_id_9, t0.funding_status_id AS funding_status_id_10 FROM city t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.label AS label_2, t0.postal_code AS postal_code_3, t0.insee_code AS insee_code_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.slug AS slug_7, t0.department_id AS department_id_8, t0.community_id AS community_id_9, t0.funding_status_id AS funding_status_id_10 FROM city t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.label AS label_2, t0.postal_code AS postal_code_3, t0.insee_code AS insee_code_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.slug AS slug_7, t0.department_id AS department_id_8, t0.community_id AS community_id_9, t0.funding_status_id AS funding_status_id_10 FROM city t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.label AS label_2, t0.postal_code AS postal_code_3, t0.insee_code AS insee_code_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.slug AS slug_7, t0.department_id AS department_id_8, t0.community_id AS community_id_9, t0.funding_status_id AS funding_status_id_10 FROM city t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.label AS label_2, t0.postal_code AS postal_code_3, t0.insee_code AS insee_code_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.slug AS slug_7, t0.department_id AS department_id_8, t0.community_id AS community_id_9, t0.funding_status_id AS funding_status_id_10 FROM city t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.label AS label_2, t0.postal_code AS postal_code_3, t0.insee_code AS insee_code_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.slug AS slug_7, t0.department_id AS department_id_8, t0.community_id AS community_id_9, t0.funding_status_id AS funding_status_id_10 FROM city t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.label AS label_2, t0.postal_code AS postal_code_3, t0.insee_code AS insee_code_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.slug AS slug_7, t0.department_id AS department_id_8, t0.community_id AS community_id_9, t0.funding_status_id AS funding_status_id_10 FROM city t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.label AS label_2, t0.postal_code AS postal_code_3, t0.insee_code AS insee_code_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.slug AS slug_7, t0.department_id AS department_id_8, t0.community_id AS community_id_9, t0.funding_status_id AS funding_status_id_10 FROM city t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.label AS label_2, t0.sort AS sort_3 FROM nest_support_category t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.label AS label_2, t0.postal_code AS postal_code_3, t0.insee_code AS insee_code_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.slug AS slug_7, t0.department_id AS department_id_8, t0.community_id AS community_id_9, t0.funding_status_id AS funding_status_id_10 FROM city t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.label AS label_2, t0.postal_code AS postal_code_3, t0.insee_code AS insee_code_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.slug AS slug_7, t0.department_id AS department_id_8, t0.community_id AS community_id_9, t0.funding_status_id AS funding_status_id_10 FROM city t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.label AS label_2, t0.postal_code AS postal_code_3, t0.insee_code AS insee_code_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.slug AS slug_7, t0.department_id AS department_id_8, t0.community_id AS community_id_9, t0.funding_status_id AS funding_status_id_10 FROM city t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.label AS label_2, t0.postal_code AS postal_code_3, t0.insee_code AS insee_code_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.slug AS slug_7, t0.department_id AS department_id_8, t0.community_id AS community_id_9, t0.funding_status_id AS funding_status_id_10 FROM city t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.label AS label_2, t0.postal_code AS postal_code_3, t0.insee_code AS insee_code_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.slug AS slug_7, t0.department_id AS department_id_8, t0.community_id AS community_id_9, t0.funding_status_id AS funding_status_id_10 FROM city t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.label AS label_2, t0.postal_code AS postal_code_3, t0.insee_code AS insee_code_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.slug AS slug_7, t0.department_id AS department_id_8, t0.community_id AS community_id_9, t0.funding_status_id AS funding_status_id_10 FROM city t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.label AS label_2, t0.postal_code AS postal_code_3, t0.insee_code AS insee_code_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.slug AS slug_7, t0.department_id AS department_id_8, t0.community_id AS community_id_9, t0.funding_status_id AS funding_status_id_10 FROM city t0 WHERE t0.id = ?
SELECT d0_.id AS id_0, d0_.label AS label_1, d0_.code AS code_2, d0_.slug AS slug_3, r1_.id AS id_4, r1_.label AS label_5, r1_.slug AS slug_6, d0_.region_id AS region_id_7 FROM department d0_ INNER JOIN region r1_ ON d0_.region_id = r1_.id WHERE d0_.region_id = ? ORDER BY d0_.code ASC
SELECT r0_.id AS id_0, r0_.label AS label_1 FROM report_category r0_
SELECT r0_.id AS id_0, r0_.label AS label_1, r0_.sort AS sort_2 FROM report_status r0_ ORDER BY r0_.sort ASC

#▲	Time	Info
1	0.55 ms	SELECT d0_.id AS id_0, d0_.label AS label_1, d0_.code AS code_2, d0_.slug AS slug_3, r1_.id AS id_4, r1_.label AS label_5, r1_.slug AS slug_6, d0_.region_id AS region_id_7 FROM department d0_ INNER JOIN region r1_ ON d0_.region_id = r1_.id WHERE d0_.region_id = ? AND d0_.id IN (?) ORDER BY d0_.code ASC Parameters: [`16 "1"`] View formatted query View runnable query Explain query SELECT d0_.id AS id_0, d0_.label AS label_1, d0_.code AS code_2, d0_.slug AS slug_3, r1_.id AS id_4, r1_.label AS label_5, r1_.slug AS slug_6, d0_.region_id AS region_id_7 FROM department d0_ INNER JOIN region r1_ ON d0_.region_id = r1_.id WHERE d0_.region_id = ? AND d0_.id IN (?) ORDER BY d0_.code ASC SELECT d0_.id AS id_0, d0_.label AS label_1, d0_.code AS code_2, d0_.slug AS slug_3, r1_.id AS id_4, r1_.label AS label_5, r1_.slug AS slug_6, d0_.region_id AS region_id_7 FROM department d0_ INNER JOIN region r1_ ON d0_.region_id = r1_.id WHERE d0_.region_id = 16 AND d0_.id IN ('1') ORDER BY d0_.code ASC;
2	0.33 ms	SELECT r0_.id AS id_0, r0_.label AS label_1 FROM report_category r0_ WHERE r0_.id IN (?) Parameters: [`"1"`] View formatted query View runnable query Explain query SELECT r0_.id AS id_0, r0_.label AS label_1 FROM report_category r0_ WHERE r0_.id IN (?) SELECT r0_.id AS id_0, r0_.label AS label_1 FROM report_category r0_ WHERE r0_.id IN ('1');
3	0.25 ms	SELECT r0_.id AS id_0, r0_.label AS label_1, r0_.sort AS sort_2 FROM report_status r0_ WHERE r0_.id IN (?, ?, ?, ?) ORDER BY r0_.sort ASC Parameters: [`4 8 6 7`] View formatted query View runnable query Explain query SELECT r0_.id AS id_0, r0_.label AS label_1, r0_.sort AS sort_2 FROM report_status r0_ WHERE r0_.id IN (?, ?, ?, ?) ORDER BY r0_.sort ASC SELECT r0_.id AS id_0, r0_.label AS label_1, r0_.sort AS sort_2 FROM report_status r0_ WHERE r0_.id IN (4, 8, 6, 7) ORDER BY r0_.sort ASC;
4	0.19 ms	SELECT r0_.id AS id_0, r0_.label AS label_1, r0_.sort AS sort_2 FROM report_status r0_ WHERE r0_.id IN (?, ?, ?, ?) ORDER BY r0_.sort ASC Parameters: [`4 8 6 7`] View formatted query View runnable query Explain query SELECT r0_.id AS id_0, r0_.label AS label_1, r0_.sort AS sort_2 FROM report_status r0_ WHERE r0_.id IN (?, ?, ?, ?) ORDER BY r0_.sort ASC SELECT r0_.id AS id_0, r0_.label AS label_1, r0_.sort AS sort_2 FROM report_status r0_ WHERE r0_.id IN (4, 8, 6, 7) ORDER BY r0_.sort ASC;
5	28.96 ms	SELECT count(DISTINCT r0_.id) AS sclr_0 FROM report r0_ LEFT JOIN city c1_ ON r0_.city_id = c1_.id LEFT JOIN department d2_ ON c1_.department_id = d2_.id LEFT JOIN report_category r3_ ON r0_.report_category_id = r3_.id LEFT JOIN report_status r4_ ON r0_.report_status_id = r4_.id WHERE d2_.id = ? AND r3_.id = ? AND (r4_.id = ? OR r4_.id = ? OR r4_.id = ? OR r4_.id = ?) Parameters: [`1 1 4 8 6 7`] View formatted query View runnable query Explain query SELECT count(DISTINCT r0_.id) AS sclr_0 FROM report r0_ LEFT JOIN city c1_ ON r0_.city_id = c1_.id LEFT JOIN department d2_ ON c1_.department_id = d2_.id LEFT JOIN report_category r3_ ON r0_.report_category_id = r3_.id LEFT JOIN report_status r4_ ON r0_.report_status_id = r4_.id WHERE d2_.id = ? AND r3_.id = ? AND ( r4_.id = ? OR r4_.id = ? OR r4_.id = ? OR r4_.id = ? ) SELECT count(DISTINCT r0_.id) AS sclr_0 FROM report r0_ LEFT JOIN city c1_ ON r0_.city_id = c1_.id LEFT JOIN department d2_ ON c1_.department_id = d2_.id LEFT JOIN report_category r3_ ON r0_.report_category_id = r3_.id LEFT JOIN report_status r4_ ON r0_.report_status_id = r4_.id WHERE d2_.id = 1 AND r3_.id = 1 AND (r4_.id = 4 OR r4_.id = 8 OR r4_.id = 6 OR r4_.id = 7);
6	25.43 ms	SELECT DISTINCT r0_.id AS id_0, r0_.id AS id_1 FROM report r0_ LEFT JOIN city c1_ ON r0_.city_id = c1_.id LEFT JOIN department d2_ ON c1_.department_id = d2_.id LEFT JOIN report_category r3_ ON r0_.report_category_id = r3_.id LEFT JOIN report_status r4_ ON r0_.report_status_id = r4_.id WHERE d2_.id = ? AND r3_.id = ? AND (r4_.id = ? OR r4_.id = ? OR r4_.id = ? OR r4_.id = ?) ORDER BY r0_.id ASC LIMIT 25 Parameters: [`1 1 4 8 6 7`] View formatted query View runnable query Explain query SELECT DISTINCT r0_.id AS id_0, r0_.id AS id_1 FROM report r0_ LEFT JOIN city c1_ ON r0_.city_id = c1_.id LEFT JOIN department d2_ ON c1_.department_id = d2_.id LEFT JOIN report_category r3_ ON r0_.report_category_id = r3_.id LEFT JOIN report_status r4_ ON r0_.report_status_id = r4_.id WHERE d2_.id = ? AND r3_.id = ? AND ( r4_.id = ? OR r4_.id = ? OR r4_.id = ? OR r4_.id = ? ) ORDER BY r0_.id ASC LIMIT 25 SELECT DISTINCT r0_.id AS id_0, r0_.id AS id_1 FROM report r0_ LEFT JOIN city c1_ ON r0_.city_id = c1_.id LEFT JOIN department d2_ ON c1_.department_id = d2_.id LEFT JOIN report_category r3_ ON r0_.report_category_id = r3_.id LEFT JOIN report_status r4_ ON r0_.report_status_id = r4_.id WHERE d2_.id = 1 AND r3_.id = 1 AND (r4_.id = 4 OR r4_.id = 8 OR r4_.id = 6 OR r4_.id = 7) ORDER BY r0_.id ASC LIMIT 25;
7	2.15 ms	SELECT r0_.id AS id_0, r0_.email AS email_1, r0_.date AS date_2, r0_.first_name AS first_name_3, r0_.last_name AS last_name_4, r0_.phone_number AS phone_number_5, r0_.address AS address_6, r0_.latitude AS latitude_7, r0_.longitude AS longitude_8, r0_.position_approximate AS position_approximate_9, r0_.close_to_sensitive_site AS close_to_sensitive_site_10, r0_.other_nest_support AS other_nest_support_11, r0_.nest_height AS nest_height_12, r0_.nest_diameter_centimeters AS nest_diameter_centimeters_13, r0_.nest_access_by_vehicle AS nest_access_by_vehicle_14, r0_.nest_active AS nest_active_15, r0_.property_owner AS property_owner_16, r0_.property_owner_email AS property_owner_email_17, r0_.property_owner_first_name AS property_owner_first_name_18, r0_.property_owner_last_name AS property_owner_last_name_19, r0_.property_owner_phone_number AS property_owner_phone_number_20, r0_.fenced_property AS fenced_property_21, r0_.distance_from_road AS distance_from_road_22, r0_.additional_info AS additional_info_23, r0_.hives AS hives_24, r0_.followup_note AS followup_note_25, r0_.intervention_date AS intervention_date_26, r0_.processing_date AS processing_date_27, r0_.other_nest_destruction_method AS other_nest_destruction_method_28, r0_.destroyed_with_insecticide AS destroyed_with_insecticide_29, r0_.insecticide_name AS insecticide_name_30, r0_.nest_removed AS nest_removed_31, r0_.nest_removal_date AS nest_removal_date_32, r0_.nest_non_removal_reason AS nest_non_removal_reason_33, r0_.nest_disposal_date AS nest_disposal_date_34, r0_.other_nest_disposal_method_without_insecticide AS other_nest_disposal_method_without_insecticide_35, r0_.other_nest_disposal_method_with_insecticide AS other_nest_disposal_method_with_insecticide_36, r0_.community_label AS community_label_37, r0_.exterminator_accepted_report AS exterminator_accepted_report_38, r0_.exterminator_affectation_date AS exterminator_affectation_date_39, r0_.archived AS archived_40, r0_.created_at AS created_at_41, r0_.updated_at AS updated_at_42, r0_.city_id AS city_id_43, r0_.nest_destruction_method_id AS nest_destruction_method_id_44, r0_.nest_disposal_method_id AS nest_disposal_method_id_45, r0_.nest_support_category_id AS nest_support_category_id_46, r0_.original_report_id AS original_report_id_47, r0_.report_category_id AS report_category_id_48, r0_.report_status_id AS report_status_id_49, r0_.report_substatus_id AS report_substatus_id_50, r0_.author_id AS author_id_51, r0_.advisor_id AS advisor_id_52, r0_.exterminator_id AS exterminator_id_53, r0_.funding_status_id AS funding_status_id_54 FROM report r0_ LEFT JOIN city c1_ ON r0_.city_id = c1_.id LEFT JOIN department d2_ ON c1_.department_id = d2_.id LEFT JOIN report_category r3_ ON r0_.report_category_id = r3_.id LEFT JOIN report_status r4_ ON r0_.report_status_id = r4_.id WHERE d2_.id = ? AND r3_.id = ? AND (r4_.id = ? OR r4_.id = ? OR r4_.id = ? OR r4_.id = ?) AND r0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY r0_.id ASC Parameters: [`1 1 4 8 6 7 1881 1895 1953 2059 2135 2138 2161 2168 2177 2217 2301 2351 2369 2427 2444 2478 2528 2530 2560 2577 2637 2702 2767 2776 2947`] View formatted query View runnable query Explain query SELECT r0_.id AS id_0, r0_.email AS email_1, r0_.date AS date_2, r0_.first_name AS first_name_3, r0_.last_name AS last_name_4, r0_.phone_number AS phone_number_5, r0_.address AS address_6, r0_.latitude AS latitude_7, r0_.longitude AS longitude_8, r0_.position_approximate AS position_approximate_9, r0_.close_to_sensitive_site AS close_to_sensitive_site_10, r0_.other_nest_support AS other_nest_support_11, r0_.nest_height AS nest_height_12, r0_.nest_diameter_centimeters AS nest_diameter_centimeters_13, r0_.nest_access_by_vehicle AS nest_access_by_vehicle_14, r0_.nest_active AS nest_active_15, r0_.property_owner AS property_owner_16, r0_.property_owner_email AS property_owner_email_17, r0_.property_owner_first_name AS property_owner_first_name_18, r0_.property_owner_last_name AS property_owner_last_name_19, r0_.property_owner_phone_number AS property_owner_phone_number_20, r0_.fenced_property AS fenced_property_21, r0_.distance_from_road AS distance_from_road_22, r0_.additional_info AS additional_info_23, r0_.hives AS hives_24, r0_.followup_note AS followup_note_25, r0_.intervention_date AS intervention_date_26, r0_.processing_date AS processing_date_27, r0_.other_nest_destruction_method AS other_nest_destruction_method_28, r0_.destroyed_with_insecticide AS destroyed_with_insecticide_29, r0_.insecticide_name AS insecticide_name_30, r0_.nest_removed AS nest_removed_31, r0_.nest_removal_date AS nest_removal_date_32, r0_.nest_non_removal_reason AS nest_non_removal_reason_33, r0_.nest_disposal_date AS nest_disposal_date_34, r0_.other_nest_disposal_method_without_insecticide AS other_nest_disposal_method_without_insecticide_35, r0_.other_nest_disposal_method_with_insecticide AS other_nest_disposal_method_with_insecticide_36, r0_.community_label AS community_label_37, r0_.exterminator_accepted_report AS exterminator_accepted_report_38, r0_.exterminator_affectation_date AS exterminator_affectation_date_39, r0_.archived AS archived_40, r0_.created_at AS created_at_41, r0_.updated_at AS updated_at_42, r0_.city_id AS city_id_43, r0_.nest_destruction_method_id AS nest_destruction_method_id_44, r0_.nest_disposal_method_id AS nest_disposal_method_id_45, r0_.nest_support_category_id AS nest_support_category_id_46, r0_.original_report_id AS original_report_id_47, r0_.report_category_id AS report_category_id_48, r0_.report_status_id AS report_status_id_49, r0_.report_substatus_id AS report_substatus_id_50, r0_.author_id AS author_id_51, r0_.advisor_id AS advisor_id_52, r0_.exterminator_id AS exterminator_id_53, r0_.funding_status_id AS funding_status_id_54 FROM report r0_ LEFT JOIN city c1_ ON r0_.city_id = c1_.id LEFT JOIN department d2_ ON c1_.department_id = d2_.id LEFT JOIN report_category r3_ ON r0_.report_category_id = r3_.id LEFT JOIN report_status r4_ ON r0_.report_status_id = r4_.id WHERE d2_.id = ? AND r3_.id = ? AND ( r4_.id = ? OR r4_.id = ? OR r4_.id = ? OR r4_.id = ? ) AND r0_.id IN ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) ORDER BY r0_.id ASC SELECT r0_.id AS id_0, r0_.email AS email_1, r0_.date AS date_2, r0_.first_name AS first_name_3, r0_.last_name AS last_name_4, r0_.phone_number AS phone_number_5, r0_.address AS address_6, r0_.latitude AS latitude_7, r0_.longitude AS longitude_8, r0_.position_approximate AS position_approximate_9, r0_.close_to_sensitive_site AS close_to_sensitive_site_10, r0_.other_nest_support AS other_nest_support_11, r0_.nest_height AS nest_height_12, r0_.nest_diameter_centimeters AS nest_diameter_centimeters_13, r0_.nest_access_by_vehicle AS nest_access_by_vehicle_14, r0_.nest_active AS nest_active_15, r0_.property_owner AS property_owner_16, r0_.property_owner_email AS property_owner_email_17, r0_.property_owner_first_name AS property_owner_first_name_18, r0_.property_owner_last_name AS property_owner_last_name_19, r0_.property_owner_phone_number AS property_owner_phone_number_20, r0_.fenced_property AS fenced_property_21, r0_.distance_from_road AS distance_from_road_22, r0_.additional_info AS additional_info_23, r0_.hives AS hives_24, r0_.followup_note AS followup_note_25, r0_.intervention_date AS intervention_date_26, r0_.processing_date AS processing_date_27, r0_.other_nest_destruction_method AS other_nest_destruction_method_28, r0_.destroyed_with_insecticide AS destroyed_with_insecticide_29, r0_.insecticide_name AS insecticide_name_30, r0_.nest_removed AS nest_removed_31, r0_.nest_removal_date AS nest_removal_date_32, r0_.nest_non_removal_reason AS nest_non_removal_reason_33, r0_.nest_disposal_date AS nest_disposal_date_34, r0_.other_nest_disposal_method_without_insecticide AS other_nest_disposal_method_without_insecticide_35, r0_.other_nest_disposal_method_with_insecticide AS other_nest_disposal_method_with_insecticide_36, r0_.community_label AS community_label_37, r0_.exterminator_accepted_report AS exterminator_accepted_report_38, r0_.exterminator_affectation_date AS exterminator_affectation_date_39, r0_.archived AS archived_40, r0_.created_at AS created_at_41, r0_.updated_at AS updated_at_42, r0_.city_id AS city_id_43, r0_.nest_destruction_method_id AS nest_destruction_method_id_44, r0_.nest_disposal_method_id AS nest_disposal_method_id_45, r0_.nest_support_category_id AS nest_support_category_id_46, r0_.original_report_id AS original_report_id_47, r0_.report_category_id AS report_category_id_48, r0_.report_status_id AS report_status_id_49, r0_.report_substatus_id AS report_substatus_id_50, r0_.author_id AS author_id_51, r0_.advisor_id AS advisor_id_52, r0_.exterminator_id AS exterminator_id_53, r0_.funding_status_id AS funding_status_id_54 FROM report r0_ LEFT JOIN city c1_ ON r0_.city_id = c1_.id LEFT JOIN department d2_ ON c1_.department_id = d2_.id LEFT JOIN report_category r3_ ON r0_.report_category_id = r3_.id LEFT JOIN report_status r4_ ON r0_.report_status_id = r4_.id WHERE d2_.id = 1 AND r3_.id = 1 AND (r4_.id = 4 OR r4_.id = 8 OR r4_.id = 6 OR r4_.id = 7) AND r0_.id IN (1881, 1895, 1953, 2059, 2135, 2138, 2161, 2168, 2177, 2217, 2301, 2351, 2369, 2427, 2444, 2478, 2528, 2530, 2560, 2577, 2637, 2702, 2767, 2776, 2947) ORDER BY r0_.id ASC;
8	0.44 ms	SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.last_login AS last_login_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.phone_number AS phone_number_8, t0.address AS address_9, t0.enabled AS enabled_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.city_id AS city_id_13, t0.discr, t0.unavailability_start_date AS unavailability_start_date_14, t0.unavailability_end_date AS unavailability_end_date_15, t0.is_validated AS is_validated_16, t0.company_name AS company_name_17, t0.company_prices AS company_prices_18, t0.comment AS comment_19, t0.viewer_category_id AS viewer_category_id_20 FROM user t0 WHERE t0.id = ? AND t0.discr IN ('administrator', 'advisor', 'sector_manager', 'declarant', 'exterminator', 'supervisor', 'viewer') Parameters: [`331`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.last_login AS last_login_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.phone_number AS phone_number_8, t0.address AS address_9, t0.enabled AS enabled_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.city_id AS city_id_13, t0.discr, t0.unavailability_start_date AS unavailability_start_date_14, t0.unavailability_end_date AS unavailability_end_date_15, t0.is_validated AS is_validated_16, t0.company_name AS company_name_17, t0.company_prices AS company_prices_18, t0.comment AS comment_19, t0.viewer_category_id AS viewer_category_id_20 FROM user t0 WHERE t0.id = ? AND t0.discr IN ( 'administrator', 'advisor', 'sector_manager', 'declarant', 'exterminator', 'supervisor', 'viewer' ) SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.last_login AS last_login_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.phone_number AS phone_number_8, t0.address AS address_9, t0.enabled AS enabled_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.city_id AS city_id_13, t0.discr, t0.unavailability_start_date AS unavailability_start_date_14, t0.unavailability_end_date AS unavailability_end_date_15, t0.is_validated AS is_validated_16, t0.company_name AS company_name_17, t0.company_prices AS company_prices_18, t0.comment AS comment_19, t0.viewer_category_id AS viewer_category_id_20 FROM user t0 WHERE t0.id = 331 AND t0.discr IN ('administrator', 'advisor', 'sector_manager', 'declarant', 'exterminator', 'supervisor', 'viewer');
9	0.27 ms	SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.last_login AS last_login_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.phone_number AS phone_number_8, t0.address AS address_9, t0.enabled AS enabled_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.city_id AS city_id_13, t0.discr, t0.unavailability_start_date AS unavailability_start_date_14, t0.unavailability_end_date AS unavailability_end_date_15, t0.is_validated AS is_validated_16, t0.company_name AS company_name_17, t0.company_prices AS company_prices_18, t0.comment AS comment_19, t0.viewer_category_id AS viewer_category_id_20 FROM user t0 WHERE t0.id = ? AND t0.discr IN ('administrator', 'advisor', 'sector_manager', 'declarant', 'exterminator', 'supervisor', 'viewer') Parameters: [`7`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.last_login AS last_login_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.phone_number AS phone_number_8, t0.address AS address_9, t0.enabled AS enabled_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.city_id AS city_id_13, t0.discr, t0.unavailability_start_date AS unavailability_start_date_14, t0.unavailability_end_date AS unavailability_end_date_15, t0.is_validated AS is_validated_16, t0.company_name AS company_name_17, t0.company_prices AS company_prices_18, t0.comment AS comment_19, t0.viewer_category_id AS viewer_category_id_20 FROM user t0 WHERE t0.id = ? AND t0.discr IN ( 'administrator', 'advisor', 'sector_manager', 'declarant', 'exterminator', 'supervisor', 'viewer' ) SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.last_login AS last_login_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.phone_number AS phone_number_8, t0.address AS address_9, t0.enabled AS enabled_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.city_id AS city_id_13, t0.discr, t0.unavailability_start_date AS unavailability_start_date_14, t0.unavailability_end_date AS unavailability_end_date_15, t0.is_validated AS is_validated_16, t0.company_name AS company_name_17, t0.company_prices AS company_prices_18, t0.comment AS comment_19, t0.viewer_category_id AS viewer_category_id_20 FROM user t0 WHERE t0.id = 7 AND t0.discr IN ('administrator', 'advisor', 'sector_manager', 'declarant', 'exterminator', 'supervisor', 'viewer');
10	0.23 ms	SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.last_login AS last_login_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.phone_number AS phone_number_8, t0.address AS address_9, t0.enabled AS enabled_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.city_id AS city_id_13, t0.discr, t0.unavailability_start_date AS unavailability_start_date_14, t0.unavailability_end_date AS unavailability_end_date_15, t0.is_validated AS is_validated_16, t0.company_name AS company_name_17, t0.company_prices AS company_prices_18, t0.comment AS comment_19, t0.viewer_category_id AS viewer_category_id_20 FROM user t0 WHERE t0.id = ? AND t0.discr IN ('administrator', 'advisor', 'sector_manager', 'declarant', 'exterminator', 'supervisor', 'viewer') Parameters: [`2`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.last_login AS last_login_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.phone_number AS phone_number_8, t0.address AS address_9, t0.enabled AS enabled_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.city_id AS city_id_13, t0.discr, t0.unavailability_start_date AS unavailability_start_date_14, t0.unavailability_end_date AS unavailability_end_date_15, t0.is_validated AS is_validated_16, t0.company_name AS company_name_17, t0.company_prices AS company_prices_18, t0.comment AS comment_19, t0.viewer_category_id AS viewer_category_id_20 FROM user t0 WHERE t0.id = ? AND t0.discr IN ( 'administrator', 'advisor', 'sector_manager', 'declarant', 'exterminator', 'supervisor', 'viewer' ) SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.last_login AS last_login_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.phone_number AS phone_number_8, t0.address AS address_9, t0.enabled AS enabled_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.city_id AS city_id_13, t0.discr, t0.unavailability_start_date AS unavailability_start_date_14, t0.unavailability_end_date AS unavailability_end_date_15, t0.is_validated AS is_validated_16, t0.company_name AS company_name_17, t0.company_prices AS company_prices_18, t0.comment AS comment_19, t0.viewer_category_id AS viewer_category_id_20 FROM user t0 WHERE t0.id = 2 AND t0.discr IN ('administrator', 'advisor', 'sector_manager', 'declarant', 'exterminator', 'supervisor', 'viewer');
11	0.23 ms	SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.last_login AS last_login_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.phone_number AS phone_number_8, t0.address AS address_9, t0.enabled AS enabled_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.city_id AS city_id_13, t0.discr, t0.unavailability_start_date AS unavailability_start_date_14, t0.unavailability_end_date AS unavailability_end_date_15, t0.is_validated AS is_validated_16, t0.company_name AS company_name_17, t0.company_prices AS company_prices_18, t0.comment AS comment_19, t0.viewer_category_id AS viewer_category_id_20 FROM user t0 WHERE t0.id = ? AND t0.discr IN ('administrator', 'advisor', 'sector_manager', 'declarant', 'exterminator', 'supervisor', 'viewer') Parameters: [`222`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.last_login AS last_login_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.phone_number AS phone_number_8, t0.address AS address_9, t0.enabled AS enabled_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.city_id AS city_id_13, t0.discr, t0.unavailability_start_date AS unavailability_start_date_14, t0.unavailability_end_date AS unavailability_end_date_15, t0.is_validated AS is_validated_16, t0.company_name AS company_name_17, t0.company_prices AS company_prices_18, t0.comment AS comment_19, t0.viewer_category_id AS viewer_category_id_20 FROM user t0 WHERE t0.id = ? AND t0.discr IN ( 'administrator', 'advisor', 'sector_manager', 'declarant', 'exterminator', 'supervisor', 'viewer' ) SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.last_login AS last_login_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.phone_number AS phone_number_8, t0.address AS address_9, t0.enabled AS enabled_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.city_id AS city_id_13, t0.discr, t0.unavailability_start_date AS unavailability_start_date_14, t0.unavailability_end_date AS unavailability_end_date_15, t0.is_validated AS is_validated_16, t0.company_name AS company_name_17, t0.company_prices AS company_prices_18, t0.comment AS comment_19, t0.viewer_category_id AS viewer_category_id_20 FROM user t0 WHERE t0.id = 222 AND t0.discr IN ('administrator', 'advisor', 'sector_manager', 'declarant', 'exterminator', 'supervisor', 'viewer');
12	0.21 ms	SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.last_login AS last_login_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.phone_number AS phone_number_8, t0.address AS address_9, t0.enabled AS enabled_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.city_id AS city_id_13, t0.discr, t0.unavailability_start_date AS unavailability_start_date_14, t0.unavailability_end_date AS unavailability_end_date_15, t0.is_validated AS is_validated_16, t0.company_name AS company_name_17, t0.company_prices AS company_prices_18, t0.comment AS comment_19, t0.viewer_category_id AS viewer_category_id_20 FROM user t0 WHERE t0.id = ? AND t0.discr IN ('administrator', 'advisor', 'sector_manager', 'declarant', 'exterminator', 'supervisor', 'viewer') Parameters: [`140`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.last_login AS last_login_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.phone_number AS phone_number_8, t0.address AS address_9, t0.enabled AS enabled_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.city_id AS city_id_13, t0.discr, t0.unavailability_start_date AS unavailability_start_date_14, t0.unavailability_end_date AS unavailability_end_date_15, t0.is_validated AS is_validated_16, t0.company_name AS company_name_17, t0.company_prices AS company_prices_18, t0.comment AS comment_19, t0.viewer_category_id AS viewer_category_id_20 FROM user t0 WHERE t0.id = ? AND t0.discr IN ( 'administrator', 'advisor', 'sector_manager', 'declarant', 'exterminator', 'supervisor', 'viewer' ) SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.last_login AS last_login_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.phone_number AS phone_number_8, t0.address AS address_9, t0.enabled AS enabled_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.city_id AS city_id_13, t0.discr, t0.unavailability_start_date AS unavailability_start_date_14, t0.unavailability_end_date AS unavailability_end_date_15, t0.is_validated AS is_validated_16, t0.company_name AS company_name_17, t0.company_prices AS company_prices_18, t0.comment AS comment_19, t0.viewer_category_id AS viewer_category_id_20 FROM user t0 WHERE t0.id = 140 AND t0.discr IN ('administrator', 'advisor', 'sector_manager', 'declarant', 'exterminator', 'supervisor', 'viewer');
13	0.23 ms	SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.last_login AS last_login_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.phone_number AS phone_number_8, t0.address AS address_9, t0.enabled AS enabled_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.city_id AS city_id_13, t0.discr, t0.unavailability_start_date AS unavailability_start_date_14, t0.unavailability_end_date AS unavailability_end_date_15, t0.is_validated AS is_validated_16, t0.company_name AS company_name_17, t0.company_prices AS company_prices_18, t0.comment AS comment_19, t0.viewer_category_id AS viewer_category_id_20 FROM user t0 WHERE t0.id = ? AND t0.discr IN ('administrator', 'advisor', 'sector_manager', 'declarant', 'exterminator', 'supervisor', 'viewer') Parameters: [`727`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.last_login AS last_login_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.phone_number AS phone_number_8, t0.address AS address_9, t0.enabled AS enabled_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.city_id AS city_id_13, t0.discr, t0.unavailability_start_date AS unavailability_start_date_14, t0.unavailability_end_date AS unavailability_end_date_15, t0.is_validated AS is_validated_16, t0.company_name AS company_name_17, t0.company_prices AS company_prices_18, t0.comment AS comment_19, t0.viewer_category_id AS viewer_category_id_20 FROM user t0 WHERE t0.id = ? AND t0.discr IN ( 'administrator', 'advisor', 'sector_manager', 'declarant', 'exterminator', 'supervisor', 'viewer' ) SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.last_login AS last_login_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.phone_number AS phone_number_8, t0.address AS address_9, t0.enabled AS enabled_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.city_id AS city_id_13, t0.discr, t0.unavailability_start_date AS unavailability_start_date_14, t0.unavailability_end_date AS unavailability_end_date_15, t0.is_validated AS is_validated_16, t0.company_name AS company_name_17, t0.company_prices AS company_prices_18, t0.comment AS comment_19, t0.viewer_category_id AS viewer_category_id_20 FROM user t0 WHERE t0.id = 727 AND t0.discr IN ('administrator', 'advisor', 'sector_manager', 'declarant', 'exterminator', 'supervisor', 'viewer');
14	0.21 ms	SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.last_login AS last_login_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.phone_number AS phone_number_8, t0.address AS address_9, t0.enabled AS enabled_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.city_id AS city_id_13, t0.discr, t0.unavailability_start_date AS unavailability_start_date_14, t0.unavailability_end_date AS unavailability_end_date_15, t0.is_validated AS is_validated_16, t0.company_name AS company_name_17, t0.company_prices AS company_prices_18, t0.comment AS comment_19, t0.viewer_category_id AS viewer_category_id_20 FROM user t0 WHERE t0.id = ? AND t0.discr IN ('administrator', 'advisor', 'sector_manager', 'declarant', 'exterminator', 'supervisor', 'viewer') Parameters: [`10`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.last_login AS last_login_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.phone_number AS phone_number_8, t0.address AS address_9, t0.enabled AS enabled_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.city_id AS city_id_13, t0.discr, t0.unavailability_start_date AS unavailability_start_date_14, t0.unavailability_end_date AS unavailability_end_date_15, t0.is_validated AS is_validated_16, t0.company_name AS company_name_17, t0.company_prices AS company_prices_18, t0.comment AS comment_19, t0.viewer_category_id AS viewer_category_id_20 FROM user t0 WHERE t0.id = ? AND t0.discr IN ( 'administrator', 'advisor', 'sector_manager', 'declarant', 'exterminator', 'supervisor', 'viewer' ) SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.last_login AS last_login_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.phone_number AS phone_number_8, t0.address AS address_9, t0.enabled AS enabled_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.city_id AS city_id_13, t0.discr, t0.unavailability_start_date AS unavailability_start_date_14, t0.unavailability_end_date AS unavailability_end_date_15, t0.is_validated AS is_validated_16, t0.company_name AS company_name_17, t0.company_prices AS company_prices_18, t0.comment AS comment_19, t0.viewer_category_id AS viewer_category_id_20 FROM user t0 WHERE t0.id = 10 AND t0.discr IN ('administrator', 'advisor', 'sector_manager', 'declarant', 'exterminator', 'supervisor', 'viewer');
15	0.26 ms	SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.last_login AS last_login_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.phone_number AS phone_number_8, t0.address AS address_9, t0.enabled AS enabled_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.city_id AS city_id_13, t0.discr, t0.unavailability_start_date AS unavailability_start_date_14, t0.unavailability_end_date AS unavailability_end_date_15, t0.is_validated AS is_validated_16, t0.company_name AS company_name_17, t0.company_prices AS company_prices_18, t0.comment AS comment_19, t0.viewer_category_id AS viewer_category_id_20 FROM user t0 WHERE t0.id = ? AND t0.discr IN ('administrator', 'advisor', 'sector_manager', 'declarant', 'exterminator', 'supervisor', 'viewer') Parameters: [`386`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.last_login AS last_login_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.phone_number AS phone_number_8, t0.address AS address_9, t0.enabled AS enabled_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.city_id AS city_id_13, t0.discr, t0.unavailability_start_date AS unavailability_start_date_14, t0.unavailability_end_date AS unavailability_end_date_15, t0.is_validated AS is_validated_16, t0.company_name AS company_name_17, t0.company_prices AS company_prices_18, t0.comment AS comment_19, t0.viewer_category_id AS viewer_category_id_20 FROM user t0 WHERE t0.id = ? AND t0.discr IN ( 'administrator', 'advisor', 'sector_manager', 'declarant', 'exterminator', 'supervisor', 'viewer' ) SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.last_login AS last_login_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.phone_number AS phone_number_8, t0.address AS address_9, t0.enabled AS enabled_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.city_id AS city_id_13, t0.discr, t0.unavailability_start_date AS unavailability_start_date_14, t0.unavailability_end_date AS unavailability_end_date_15, t0.is_validated AS is_validated_16, t0.company_name AS company_name_17, t0.company_prices AS company_prices_18, t0.comment AS comment_19, t0.viewer_category_id AS viewer_category_id_20 FROM user t0 WHERE t0.id = 386 AND t0.discr IN ('administrator', 'advisor', 'sector_manager', 'declarant', 'exterminator', 'supervisor', 'viewer');
16	0.21 ms	SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.last_login AS last_login_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.phone_number AS phone_number_8, t0.address AS address_9, t0.enabled AS enabled_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.city_id AS city_id_13, t0.discr, t0.unavailability_start_date AS unavailability_start_date_14, t0.unavailability_end_date AS unavailability_end_date_15, t0.is_validated AS is_validated_16, t0.company_name AS company_name_17, t0.company_prices AS company_prices_18, t0.comment AS comment_19, t0.viewer_category_id AS viewer_category_id_20 FROM user t0 WHERE t0.id = ? AND t0.discr IN ('administrator', 'advisor', 'sector_manager', 'declarant', 'exterminator', 'supervisor', 'viewer') Parameters: [`6599`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.last_login AS last_login_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.phone_number AS phone_number_8, t0.address AS address_9, t0.enabled AS enabled_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.city_id AS city_id_13, t0.discr, t0.unavailability_start_date AS unavailability_start_date_14, t0.unavailability_end_date AS unavailability_end_date_15, t0.is_validated AS is_validated_16, t0.company_name AS company_name_17, t0.company_prices AS company_prices_18, t0.comment AS comment_19, t0.viewer_category_id AS viewer_category_id_20 FROM user t0 WHERE t0.id = ? AND t0.discr IN ( 'administrator', 'advisor', 'sector_manager', 'declarant', 'exterminator', 'supervisor', 'viewer' ) SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.last_login AS last_login_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.phone_number AS phone_number_8, t0.address AS address_9, t0.enabled AS enabled_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.city_id AS city_id_13, t0.discr, t0.unavailability_start_date AS unavailability_start_date_14, t0.unavailability_end_date AS unavailability_end_date_15, t0.is_validated AS is_validated_16, t0.company_name AS company_name_17, t0.company_prices AS company_prices_18, t0.comment AS comment_19, t0.viewer_category_id AS viewer_category_id_20 FROM user t0 WHERE t0.id = 6599 AND t0.discr IN ('administrator', 'advisor', 'sector_manager', 'declarant', 'exterminator', 'supervisor', 'viewer');
17	0.21 ms	SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.last_login AS last_login_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.phone_number AS phone_number_8, t0.address AS address_9, t0.enabled AS enabled_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.city_id AS city_id_13, t0.discr, t0.unavailability_start_date AS unavailability_start_date_14, t0.unavailability_end_date AS unavailability_end_date_15, t0.is_validated AS is_validated_16, t0.company_name AS company_name_17, t0.company_prices AS company_prices_18, t0.comment AS comment_19, t0.viewer_category_id AS viewer_category_id_20 FROM user t0 WHERE t0.id = ? AND t0.discr IN ('administrator', 'advisor', 'sector_manager', 'declarant', 'exterminator', 'supervisor', 'viewer') Parameters: [`3804`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.last_login AS last_login_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.phone_number AS phone_number_8, t0.address AS address_9, t0.enabled AS enabled_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.city_id AS city_id_13, t0.discr, t0.unavailability_start_date AS unavailability_start_date_14, t0.unavailability_end_date AS unavailability_end_date_15, t0.is_validated AS is_validated_16, t0.company_name AS company_name_17, t0.company_prices AS company_prices_18, t0.comment AS comment_19, t0.viewer_category_id AS viewer_category_id_20 FROM user t0 WHERE t0.id = ? AND t0.discr IN ( 'administrator', 'advisor', 'sector_manager', 'declarant', 'exterminator', 'supervisor', 'viewer' ) SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.last_login AS last_login_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.phone_number AS phone_number_8, t0.address AS address_9, t0.enabled AS enabled_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.city_id AS city_id_13, t0.discr, t0.unavailability_start_date AS unavailability_start_date_14, t0.unavailability_end_date AS unavailability_end_date_15, t0.is_validated AS is_validated_16, t0.company_name AS company_name_17, t0.company_prices AS company_prices_18, t0.comment AS comment_19, t0.viewer_category_id AS viewer_category_id_20 FROM user t0 WHERE t0.id = 3804 AND t0.discr IN ('administrator', 'advisor', 'sector_manager', 'declarant', 'exterminator', 'supervisor', 'viewer');
18	0.18 ms	SELECT t0.id AS id_1, t0.label AS label_2, t0.postal_code AS postal_code_3, t0.insee_code AS insee_code_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.slug AS slug_7, t0.department_id AS department_id_8, t0.community_id AS community_id_9, t0.funding_status_id AS funding_status_id_10 FROM city t0 WHERE t0.id = ? Parameters: [`359`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.label AS label_2, t0.postal_code AS postal_code_3, t0.insee_code AS insee_code_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.slug AS slug_7, t0.department_id AS department_id_8, t0.community_id AS community_id_9, t0.funding_status_id AS funding_status_id_10 FROM city t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.label AS label_2, t0.postal_code AS postal_code_3, t0.insee_code AS insee_code_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.slug AS slug_7, t0.department_id AS department_id_8, t0.community_id AS community_id_9, t0.funding_status_id AS funding_status_id_10 FROM city t0 WHERE t0.id = 359;
19	0.16 ms	SELECT t0.id AS id_1, t0.label AS label_2, t0.postal_code AS postal_code_3, t0.insee_code AS insee_code_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.slug AS slug_7, t0.department_id AS department_id_8, t0.community_id AS community_id_9, t0.funding_status_id AS funding_status_id_10 FROM city t0 WHERE t0.id = ? Parameters: [`399`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.label AS label_2, t0.postal_code AS postal_code_3, t0.insee_code AS insee_code_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.slug AS slug_7, t0.department_id AS department_id_8, t0.community_id AS community_id_9, t0.funding_status_id AS funding_status_id_10 FROM city t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.label AS label_2, t0.postal_code AS postal_code_3, t0.insee_code AS insee_code_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.slug AS slug_7, t0.department_id AS department_id_8, t0.community_id AS community_id_9, t0.funding_status_id AS funding_status_id_10 FROM city t0 WHERE t0.id = 399;
20	0.15 ms	SELECT t0.id AS id_1, t0.label AS label_2, t0.postal_code AS postal_code_3, t0.insee_code AS insee_code_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.slug AS slug_7, t0.department_id AS department_id_8, t0.community_id AS community_id_9, t0.funding_status_id AS funding_status_id_10 FROM city t0 WHERE t0.id = ? Parameters: [`241`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.label AS label_2, t0.postal_code AS postal_code_3, t0.insee_code AS insee_code_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.slug AS slug_7, t0.department_id AS department_id_8, t0.community_id AS community_id_9, t0.funding_status_id AS funding_status_id_10 FROM city t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.label AS label_2, t0.postal_code AS postal_code_3, t0.insee_code AS insee_code_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.slug AS slug_7, t0.department_id AS department_id_8, t0.community_id AS community_id_9, t0.funding_status_id AS funding_status_id_10 FROM city t0 WHERE t0.id = 241;
21	0.13 ms	SELECT t0.id AS id_1, t0.label AS label_2, t0.sort AS sort_3 FROM nest_support_category t0 WHERE t0.id = ? Parameters: [`1`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.label AS label_2, t0.sort AS sort_3 FROM nest_support_category t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.label AS label_2, t0.sort AS sort_3 FROM nest_support_category t0 WHERE t0.id = 1;
22	0.14 ms	SELECT t0.id AS id_1, t0.label AS label_2, t0.postal_code AS postal_code_3, t0.insee_code AS insee_code_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.slug AS slug_7, t0.department_id AS department_id_8, t0.community_id AS community_id_9, t0.funding_status_id AS funding_status_id_10 FROM city t0 WHERE t0.id = ? Parameters: [`73`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.label AS label_2, t0.postal_code AS postal_code_3, t0.insee_code AS insee_code_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.slug AS slug_7, t0.department_id AS department_id_8, t0.community_id AS community_id_9, t0.funding_status_id AS funding_status_id_10 FROM city t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.label AS label_2, t0.postal_code AS postal_code_3, t0.insee_code AS insee_code_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.slug AS slug_7, t0.department_id AS department_id_8, t0.community_id AS community_id_9, t0.funding_status_id AS funding_status_id_10 FROM city t0 WHERE t0.id = 73;
23	0.14 ms	SELECT t0.id AS id_1, t0.label AS label_2, t0.postal_code AS postal_code_3, t0.insee_code AS insee_code_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.slug AS slug_7, t0.department_id AS department_id_8, t0.community_id AS community_id_9, t0.funding_status_id AS funding_status_id_10 FROM city t0 WHERE t0.id = ? Parameters: [`184`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.label AS label_2, t0.postal_code AS postal_code_3, t0.insee_code AS insee_code_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.slug AS slug_7, t0.department_id AS department_id_8, t0.community_id AS community_id_9, t0.funding_status_id AS funding_status_id_10 FROM city t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.label AS label_2, t0.postal_code AS postal_code_3, t0.insee_code AS insee_code_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.slug AS slug_7, t0.department_id AS department_id_8, t0.community_id AS community_id_9, t0.funding_status_id AS funding_status_id_10 FROM city t0 WHERE t0.id = 184;
24	0.16 ms	SELECT t0.id AS id_1, t0.label AS label_2, t0.postal_code AS postal_code_3, t0.insee_code AS insee_code_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.slug AS slug_7, t0.department_id AS department_id_8, t0.community_id AS community_id_9, t0.funding_status_id AS funding_status_id_10 FROM city t0 WHERE t0.id = ? Parameters: [`357`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.label AS label_2, t0.postal_code AS postal_code_3, t0.insee_code AS insee_code_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.slug AS slug_7, t0.department_id AS department_id_8, t0.community_id AS community_id_9, t0.funding_status_id AS funding_status_id_10 FROM city t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.label AS label_2, t0.postal_code AS postal_code_3, t0.insee_code AS insee_code_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.slug AS slug_7, t0.department_id AS department_id_8, t0.community_id AS community_id_9, t0.funding_status_id AS funding_status_id_10 FROM city t0 WHERE t0.id = 357;
25	0.14 ms	SELECT t0.id AS id_1, t0.label AS label_2, t0.postal_code AS postal_code_3, t0.insee_code AS insee_code_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.slug AS slug_7, t0.department_id AS department_id_8, t0.community_id AS community_id_9, t0.funding_status_id AS funding_status_id_10 FROM city t0 WHERE t0.id = ? Parameters: [`50`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.label AS label_2, t0.postal_code AS postal_code_3, t0.insee_code AS insee_code_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.slug AS slug_7, t0.department_id AS department_id_8, t0.community_id AS community_id_9, t0.funding_status_id AS funding_status_id_10 FROM city t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.label AS label_2, t0.postal_code AS postal_code_3, t0.insee_code AS insee_code_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.slug AS slug_7, t0.department_id AS department_id_8, t0.community_id AS community_id_9, t0.funding_status_id AS funding_status_id_10 FROM city t0 WHERE t0.id = 50;
26	0.14 ms	SELECT t0.id AS id_1, t0.label AS label_2, t0.postal_code AS postal_code_3, t0.insee_code AS insee_code_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.slug AS slug_7, t0.department_id AS department_id_8, t0.community_id AS community_id_9, t0.funding_status_id AS funding_status_id_10 FROM city t0 WHERE t0.id = ? Parameters: [`147`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.label AS label_2, t0.postal_code AS postal_code_3, t0.insee_code AS insee_code_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.slug AS slug_7, t0.department_id AS department_id_8, t0.community_id AS community_id_9, t0.funding_status_id AS funding_status_id_10 FROM city t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.label AS label_2, t0.postal_code AS postal_code_3, t0.insee_code AS insee_code_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.slug AS slug_7, t0.department_id AS department_id_8, t0.community_id AS community_id_9, t0.funding_status_id AS funding_status_id_10 FROM city t0 WHERE t0.id = 147;
27	0.16 ms	SELECT t0.id AS id_1, t0.label AS label_2, t0.postal_code AS postal_code_3, t0.insee_code AS insee_code_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.slug AS slug_7, t0.department_id AS department_id_8, t0.community_id AS community_id_9, t0.funding_status_id AS funding_status_id_10 FROM city t0 WHERE t0.id = ? Parameters: [`333`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.label AS label_2, t0.postal_code AS postal_code_3, t0.insee_code AS insee_code_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.slug AS slug_7, t0.department_id AS department_id_8, t0.community_id AS community_id_9, t0.funding_status_id AS funding_status_id_10 FROM city t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.label AS label_2, t0.postal_code AS postal_code_3, t0.insee_code AS insee_code_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.slug AS slug_7, t0.department_id AS department_id_8, t0.community_id AS community_id_9, t0.funding_status_id AS funding_status_id_10 FROM city t0 WHERE t0.id = 333;
28	0.14 ms	SELECT t0.id AS id_1, t0.label AS label_2, t0.postal_code AS postal_code_3, t0.insee_code AS insee_code_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.slug AS slug_7, t0.department_id AS department_id_8, t0.community_id AS community_id_9, t0.funding_status_id AS funding_status_id_10 FROM city t0 WHERE t0.id = ? Parameters: [`222`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.label AS label_2, t0.postal_code AS postal_code_3, t0.insee_code AS insee_code_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.slug AS slug_7, t0.department_id AS department_id_8, t0.community_id AS community_id_9, t0.funding_status_id AS funding_status_id_10 FROM city t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.label AS label_2, t0.postal_code AS postal_code_3, t0.insee_code AS insee_code_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.slug AS slug_7, t0.department_id AS department_id_8, t0.community_id AS community_id_9, t0.funding_status_id AS funding_status_id_10 FROM city t0 WHERE t0.id = 222;
29	0.14 ms	SELECT t0.id AS id_1, t0.label AS label_2, t0.postal_code AS postal_code_3, t0.insee_code AS insee_code_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.slug AS slug_7, t0.department_id AS department_id_8, t0.community_id AS community_id_9, t0.funding_status_id AS funding_status_id_10 FROM city t0 WHERE t0.id = ? Parameters: [`237`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.label AS label_2, t0.postal_code AS postal_code_3, t0.insee_code AS insee_code_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.slug AS slug_7, t0.department_id AS department_id_8, t0.community_id AS community_id_9, t0.funding_status_id AS funding_status_id_10 FROM city t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.label AS label_2, t0.postal_code AS postal_code_3, t0.insee_code AS insee_code_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.slug AS slug_7, t0.department_id AS department_id_8, t0.community_id AS community_id_9, t0.funding_status_id AS funding_status_id_10 FROM city t0 WHERE t0.id = 237;
30	0.14 ms	SELECT t0.id AS id_1, t0.label AS label_2, t0.postal_code AS postal_code_3, t0.insee_code AS insee_code_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.slug AS slug_7, t0.department_id AS department_id_8, t0.community_id AS community_id_9, t0.funding_status_id AS funding_status_id_10 FROM city t0 WHERE t0.id = ? Parameters: [`315`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.label AS label_2, t0.postal_code AS postal_code_3, t0.insee_code AS insee_code_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.slug AS slug_7, t0.department_id AS department_id_8, t0.community_id AS community_id_9, t0.funding_status_id AS funding_status_id_10 FROM city t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.label AS label_2, t0.postal_code AS postal_code_3, t0.insee_code AS insee_code_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.slug AS slug_7, t0.department_id AS department_id_8, t0.community_id AS community_id_9, t0.funding_status_id AS funding_status_id_10 FROM city t0 WHERE t0.id = 315;
31	0.15 ms	SELECT t0.id AS id_1, t0.label AS label_2, t0.postal_code AS postal_code_3, t0.insee_code AS insee_code_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.slug AS slug_7, t0.department_id AS department_id_8, t0.community_id AS community_id_9, t0.funding_status_id AS funding_status_id_10 FROM city t0 WHERE t0.id = ? Parameters: [`129`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.label AS label_2, t0.postal_code AS postal_code_3, t0.insee_code AS insee_code_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.slug AS slug_7, t0.department_id AS department_id_8, t0.community_id AS community_id_9, t0.funding_status_id AS funding_status_id_10 FROM city t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.label AS label_2, t0.postal_code AS postal_code_3, t0.insee_code AS insee_code_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.slug AS slug_7, t0.department_id AS department_id_8, t0.community_id AS community_id_9, t0.funding_status_id AS funding_status_id_10 FROM city t0 WHERE t0.id = 129;
32	0.14 ms	SELECT t0.id AS id_1, t0.label AS label_2, t0.postal_code AS postal_code_3, t0.insee_code AS insee_code_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.slug AS slug_7, t0.department_id AS department_id_8, t0.community_id AS community_id_9, t0.funding_status_id AS funding_status_id_10 FROM city t0 WHERE t0.id = ? Parameters: [`87`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.label AS label_2, t0.postal_code AS postal_code_3, t0.insee_code AS insee_code_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.slug AS slug_7, t0.department_id AS department_id_8, t0.community_id AS community_id_9, t0.funding_status_id AS funding_status_id_10 FROM city t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.label AS label_2, t0.postal_code AS postal_code_3, t0.insee_code AS insee_code_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.slug AS slug_7, t0.department_id AS department_id_8, t0.community_id AS community_id_9, t0.funding_status_id AS funding_status_id_10 FROM city t0 WHERE t0.id = 87;
33	0.15 ms	SELECT t0.id AS id_1, t0.label AS label_2, t0.postal_code AS postal_code_3, t0.insee_code AS insee_code_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.slug AS slug_7, t0.department_id AS department_id_8, t0.community_id AS community_id_9, t0.funding_status_id AS funding_status_id_10 FROM city t0 WHERE t0.id = ? Parameters: [`52`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.label AS label_2, t0.postal_code AS postal_code_3, t0.insee_code AS insee_code_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.slug AS slug_7, t0.department_id AS department_id_8, t0.community_id AS community_id_9, t0.funding_status_id AS funding_status_id_10 FROM city t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.label AS label_2, t0.postal_code AS postal_code_3, t0.insee_code AS insee_code_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.slug AS slug_7, t0.department_id AS department_id_8, t0.community_id AS community_id_9, t0.funding_status_id AS funding_status_id_10 FROM city t0 WHERE t0.id = 52;
34	0.15 ms	SELECT t0.id AS id_1, t0.label AS label_2, t0.postal_code AS postal_code_3, t0.insee_code AS insee_code_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.slug AS slug_7, t0.department_id AS department_id_8, t0.community_id AS community_id_9, t0.funding_status_id AS funding_status_id_10 FROM city t0 WHERE t0.id = ? Parameters: [`89`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.label AS label_2, t0.postal_code AS postal_code_3, t0.insee_code AS insee_code_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.slug AS slug_7, t0.department_id AS department_id_8, t0.community_id AS community_id_9, t0.funding_status_id AS funding_status_id_10 FROM city t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.label AS label_2, t0.postal_code AS postal_code_3, t0.insee_code AS insee_code_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.slug AS slug_7, t0.department_id AS department_id_8, t0.community_id AS community_id_9, t0.funding_status_id AS funding_status_id_10 FROM city t0 WHERE t0.id = 89;
35	0.13 ms	SELECT t0.id AS id_1, t0.label AS label_2, t0.sort AS sort_3 FROM nest_support_category t0 WHERE t0.id = ? Parameters: [`3`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.label AS label_2, t0.sort AS sort_3 FROM nest_support_category t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.label AS label_2, t0.sort AS sort_3 FROM nest_support_category t0 WHERE t0.id = 3;
36	0.15 ms	SELECT t0.id AS id_1, t0.label AS label_2, t0.postal_code AS postal_code_3, t0.insee_code AS insee_code_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.slug AS slug_7, t0.department_id AS department_id_8, t0.community_id AS community_id_9, t0.funding_status_id AS funding_status_id_10 FROM city t0 WHERE t0.id = ? Parameters: [`33`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.label AS label_2, t0.postal_code AS postal_code_3, t0.insee_code AS insee_code_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.slug AS slug_7, t0.department_id AS department_id_8, t0.community_id AS community_id_9, t0.funding_status_id AS funding_status_id_10 FROM city t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.label AS label_2, t0.postal_code AS postal_code_3, t0.insee_code AS insee_code_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.slug AS slug_7, t0.department_id AS department_id_8, t0.community_id AS community_id_9, t0.funding_status_id AS funding_status_id_10 FROM city t0 WHERE t0.id = 33;
37	0.17 ms	SELECT t0.id AS id_1, t0.label AS label_2, t0.postal_code AS postal_code_3, t0.insee_code AS insee_code_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.slug AS slug_7, t0.department_id AS department_id_8, t0.community_id AS community_id_9, t0.funding_status_id AS funding_status_id_10 FROM city t0 WHERE t0.id = ? Parameters: [`371`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.label AS label_2, t0.postal_code AS postal_code_3, t0.insee_code AS insee_code_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.slug AS slug_7, t0.department_id AS department_id_8, t0.community_id AS community_id_9, t0.funding_status_id AS funding_status_id_10 FROM city t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.label AS label_2, t0.postal_code AS postal_code_3, t0.insee_code AS insee_code_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.slug AS slug_7, t0.department_id AS department_id_8, t0.community_id AS community_id_9, t0.funding_status_id AS funding_status_id_10 FROM city t0 WHERE t0.id = 371;
38	0.14 ms	SELECT t0.id AS id_1, t0.label AS label_2, t0.postal_code AS postal_code_3, t0.insee_code AS insee_code_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.slug AS slug_7, t0.department_id AS department_id_8, t0.community_id AS community_id_9, t0.funding_status_id AS funding_status_id_10 FROM city t0 WHERE t0.id = ? Parameters: [`337`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.label AS label_2, t0.postal_code AS postal_code_3, t0.insee_code AS insee_code_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.slug AS slug_7, t0.department_id AS department_id_8, t0.community_id AS community_id_9, t0.funding_status_id AS funding_status_id_10 FROM city t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.label AS label_2, t0.postal_code AS postal_code_3, t0.insee_code AS insee_code_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.slug AS slug_7, t0.department_id AS department_id_8, t0.community_id AS community_id_9, t0.funding_status_id AS funding_status_id_10 FROM city t0 WHERE t0.id = 337;
39	0.15 ms	SELECT t0.id AS id_1, t0.label AS label_2, t0.postal_code AS postal_code_3, t0.insee_code AS insee_code_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.slug AS slug_7, t0.department_id AS department_id_8, t0.community_id AS community_id_9, t0.funding_status_id AS funding_status_id_10 FROM city t0 WHERE t0.id = ? Parameters: [`39`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.label AS label_2, t0.postal_code AS postal_code_3, t0.insee_code AS insee_code_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.slug AS slug_7, t0.department_id AS department_id_8, t0.community_id AS community_id_9, t0.funding_status_id AS funding_status_id_10 FROM city t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.label AS label_2, t0.postal_code AS postal_code_3, t0.insee_code AS insee_code_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.slug AS slug_7, t0.department_id AS department_id_8, t0.community_id AS community_id_9, t0.funding_status_id AS funding_status_id_10 FROM city t0 WHERE t0.id = 39;
40	0.14 ms	SELECT t0.id AS id_1, t0.label AS label_2, t0.postal_code AS postal_code_3, t0.insee_code AS insee_code_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.slug AS slug_7, t0.department_id AS department_id_8, t0.community_id AS community_id_9, t0.funding_status_id AS funding_status_id_10 FROM city t0 WHERE t0.id = ? Parameters: [`364`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.label AS label_2, t0.postal_code AS postal_code_3, t0.insee_code AS insee_code_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.slug AS slug_7, t0.department_id AS department_id_8, t0.community_id AS community_id_9, t0.funding_status_id AS funding_status_id_10 FROM city t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.label AS label_2, t0.postal_code AS postal_code_3, t0.insee_code AS insee_code_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.slug AS slug_7, t0.department_id AS department_id_8, t0.community_id AS community_id_9, t0.funding_status_id AS funding_status_id_10 FROM city t0 WHERE t0.id = 364;
41	0.14 ms	SELECT t0.id AS id_1, t0.label AS label_2, t0.postal_code AS postal_code_3, t0.insee_code AS insee_code_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.slug AS slug_7, t0.department_id AS department_id_8, t0.community_id AS community_id_9, t0.funding_status_id AS funding_status_id_10 FROM city t0 WHERE t0.id = ? Parameters: [`314`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.label AS label_2, t0.postal_code AS postal_code_3, t0.insee_code AS insee_code_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.slug AS slug_7, t0.department_id AS department_id_8, t0.community_id AS community_id_9, t0.funding_status_id AS funding_status_id_10 FROM city t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.label AS label_2, t0.postal_code AS postal_code_3, t0.insee_code AS insee_code_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.slug AS slug_7, t0.department_id AS department_id_8, t0.community_id AS community_id_9, t0.funding_status_id AS funding_status_id_10 FROM city t0 WHERE t0.id = 314;
42	0.20 ms	SELECT t0.id AS id_1, t0.label AS label_2, t0.postal_code AS postal_code_3, t0.insee_code AS insee_code_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.slug AS slug_7, t0.department_id AS department_id_8, t0.community_id AS community_id_9, t0.funding_status_id AS funding_status_id_10 FROM city t0 WHERE t0.id = ? Parameters: [`86`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.label AS label_2, t0.postal_code AS postal_code_3, t0.insee_code AS insee_code_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.slug AS slug_7, t0.department_id AS department_id_8, t0.community_id AS community_id_9, t0.funding_status_id AS funding_status_id_10 FROM city t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.label AS label_2, t0.postal_code AS postal_code_3, t0.insee_code AS insee_code_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.slug AS slug_7, t0.department_id AS department_id_8, t0.community_id AS community_id_9, t0.funding_status_id AS funding_status_id_10 FROM city t0 WHERE t0.id = 86;
43	0.29 ms	SELECT d0_.id AS id_0, d0_.label AS label_1, d0_.code AS code_2, d0_.slug AS slug_3, r1_.id AS id_4, r1_.label AS label_5, r1_.slug AS slug_6, d0_.region_id AS region_id_7 FROM department d0_ INNER JOIN region r1_ ON d0_.region_id = r1_.id WHERE d0_.region_id = ? ORDER BY d0_.code ASC Parameters: [`16`] View formatted query View runnable query Explain query SELECT d0_.id AS id_0, d0_.label AS label_1, d0_.code AS code_2, d0_.slug AS slug_3, r1_.id AS id_4, r1_.label AS label_5, r1_.slug AS slug_6, d0_.region_id AS region_id_7 FROM department d0_ INNER JOIN region r1_ ON d0_.region_id = r1_.id WHERE d0_.region_id = ? ORDER BY d0_.code ASC SELECT d0_.id AS id_0, d0_.label AS label_1, d0_.code AS code_2, d0_.slug AS slug_3, r1_.id AS id_4, r1_.label AS label_5, r1_.slug AS slug_6, d0_.region_id AS region_id_7 FROM department d0_ INNER JOIN region r1_ ON d0_.region_id = r1_.id WHERE d0_.region_id = 16 ORDER BY d0_.code ASC;
44	0.17 ms	SELECT r0_.id AS id_0, r0_.label AS label_1 FROM report_category r0_ Parameters: [] View formatted query View runnable query Explain query SELECT r0_.id AS id_0, r0_.label AS label_1 FROM report_category r0_ SELECT r0_.id AS id_0, r0_.label AS label_1 FROM report_category r0_;
45	0.20 ms	SELECT r0_.id AS id_0, r0_.label AS label_1, r0_.sort AS sort_2 FROM report_status r0_ ORDER BY r0_.sort ASC Parameters: [] View formatted query View runnable query Explain query SELECT r0_.id AS id_0, r0_.label AS label_1, r0_.sort AS sort_2 FROM report_status r0_ ORDER BY r0_.sort ASC SELECT r0_.id AS id_0, r0_.label AS label_1, r0_.sort AS sort_2 FROM report_status r0_ ORDER BY r0_.sort ASC;

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.

Entities Mapping

Class	Mapping errors
App\Entity\Report	No errors.
App\Entity\City	No errors.
App\Entity\Department	No errors.
App\Entity\Region	No errors.
App\Entity\ReportCategory	No errors.
App\Entity\ReportStatus	No errors.
App\Entity\Sector	No errors.
App\Entity\NestDestructionMethod	No errors.
App\Entity\NestDisposalMethod	No errors.
App\Entity\NestSupportCategory	No errors.
App\Entity\ReportSubstatus	No errors.
App\Entity\User	No errors.
App\Entity\Advisor	No errors.
App\Entity\Exterminator	No errors.
App\Entity\FundingStatus	No errors.
App\Entity\Comment	No errors.
App\Entity\Photo	No errors.
App\Entity\InternalPhoto	No errors.
App\Entity\Administrator	No errors.
App\Entity\SectorManager	No errors.
App\Entity\Declarant	No errors.
App\Entity\Supervisor	No errors.
App\Entity\Viewer	No errors.
App\Entity\ViewerCategory	No errors.
App\Entity\Community	No errors.

Symfony Profiler

GET https://signal.frelonsasiatiques.fr/iceadmin/cartographie/list

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping