Query Metrics

66 Database Queries
16 Different statements
15.38 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
3.67 ms
(23.87%)
24
SELECT t0.id AS id_1, t0.grade AS grade_2, t0.status AS status_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.level_id AS level_id_6, t0.country_group_id AS country_group_id_7 FROM mve_costs_cost t0 WHERE t0.country_group_id = ? AND t0.level_id = ? AND t0.grade = ?
Parameters:
[
  3
  7
  "Principal"
]
3.48 ms
(22.62%)
14
SELECT t0.id AS id_1, t0.name AS name_2, t0.fr_name AS fr_name_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.sector_id AS sector_id_6 FROM mve_users_domain t0 WHERE t0.sector_id = ?
Parameters:
[
  1
]
1.59 ms
(10.34%)
6
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.is_active AS is_active_4, t0.code AS code_5, t0.logo AS logo_6, t0.config AS config_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.payment_type_id AS payment_type_id_10 FROM mve_payments_payment_method t0 WHERE t0.id = ?
Parameters:
[
  2
]
1.16 ms
(7.53%)
1
SELECT t0.id AS id_1, t0.unique_id AS unique_id_2, t0.matricule_fiscal AS matricule_fiscal_3, t0.name AS name_4, t0.address AS address_5, t0.city AS city_6, t0.postal_code AS postal_code_7, t0.phone AS phone_8, t0.email AS email_9, t0.web_site AS web_site_10, t0.creation_date AS creation_date_11, t0.description AS description_12, t0.logo_url AS logo_url_13, t0.fav_icon_url AS fav_icon_url_14, t0.status AS status_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.sector_id AS sector_id_18, t0.country_id AS country_id_19, t0.tax_id AS tax_id_20 FROM mve_organizations_organization t0 WHERE t0.status = ? ORDER BY t0.name ASC
Parameters:
[
  "active"
]
1.14 ms
(7.42%)
8
SELECT t0.id AS id_1, t0.price AS price_2, t0.cost_id AS cost_id_3, t0.community_id AS community_id_4 FROM mve_costs_community_cost t0 WHERE t0.community_id = ? AND t0.cost_id = ? LIMIT 1
Parameters:
[
  3
  13
]
0.82 ms
(5.32%)
1
SELECT t0.id AS id_1, t0.token AS token_2, t0.expires_at AS expires_at_3, t0.is_active AS is_active_4, t0.max_uses AS max_uses_5, t0.current_uses AS current_uses_6, t0.last_used_at AS last_used_at_7, t0.allowed_domain AS allowed_domain_8, t0.is_default AS is_default_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.community_id AS community_id_12, t0.event_id AS event_id_13, t0.invited_by_id AS invited_by_id_14 FROM mve_invitations_invitation_token t0 WHERE t0.token = ? LIMIT 1
Parameters:
[
  "c1f2c6e3249df2b5a17ba8d01aba7ed71b4931f6bc135f106fe6fc0716858498"
]
0.72 ms
(4.70%)
3
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.symbol AS symbol_4, t0.enabled AS enabled_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7 FROM mve_misc_currency t0 WHERE t0.id = ?
Parameters:
[
  3
]
0.46 ms
(2.96%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.fr_name AS fr_name_3, t0.description AS description_4, t0.icon AS icon_5, t0.is_active AS is_active_6, t0.sort_order AS sort_order_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM mve_users_interest t0 WHERE t0.is_active = ? ORDER BY t0.sort_order ASC
Parameters:
[
  1
]
0.41 ms
(2.65%)
1
SELECT t0.id AS id_1, t0.unique_id AS unique_id_2, t0.field_name AS field_name_3, t0.field_name_fr AS field_name_fr_4, t0.field_type AS field_type_5, t0.is_required AS is_required_6, t0.is_visible AS is_visible_7, t0.is_editable AS is_editable_8, t0.description AS description_9, t0.options AS options_10, t0.options_fr AS options_fr_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.community_id AS community_id_14 FROM mve_communities_custom_field t0 WHERE t0.community_id = ? AND t0.is_visible = ? ORDER BY t0.id ASC
Parameters:
[
  3
  1
]
0.40 ms
(2.63%)
1
SELECT t0.id AS id_1, t0.unique_id AS unique_id_2, t0.name AS name_3, t0.fr_name AS fr_name_4, t0.qr_path AS qr_path_5, t0.slug AS slug_6, t0.status AS status_7, t0.pricing_plan AS pricing_plan_8, t0.require_validation_before_payment AS require_validation_before_payment_9, t0.community_url AS community_url_10, t0.registration_background_url AS registration_background_url_11, t0.signin_brand_config AS signin_brand_config_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.organization_id AS organization_id_15, t0.speciality_id AS speciality_id_16 FROM mve_communities_community t0 WHERE t0.id = ?
Parameters:
[
  3
]
0.31 ms
(2.02%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.rate AS rate_3, t0.country_ids AS country_ids_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.currency_id AS currency_id_7, t0.community_id AS community_id_8 FROM mve_costs_country_group t0 WHERE t0.community_id = ?
Parameters:
[
  3
]
0.30 ms
(1.98%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.fr_name AS fr_name_3, t0.iso2 AS iso2_4, t0.numeric_code AS numeric_code_5, t0.enabled AS enabled_6 FROM mve_misc_country t0 WHERE t0.id IN (?, ?, ?, ?) ORDER BY t0.name ASC
Parameters:
[
  227
  4
  149
  3
]
0.29 ms
(1.86%)
1
SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.config AS config_3, t0.description AS description_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.organization_id AS organization_id_7, t0.payment_method_id AS payment_method_id_8 FROM mve_payments_payment_org_method t0 WHERE t0.organization_id = ? AND t0.is_active = ?
Parameters:
[
  3
  1
]
0.23 ms
(1.52%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.priority AS priority_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.community_id AS community_id_6 FROM mve_costs_level t0 WHERE t0.community_id = ? ORDER BY t0.priority ASC
Parameters:
[
  3
]
0.23 ms
(1.49%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.fr_name AS fr_name_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM mve_users_sector t0
Parameters:
[]
0.17 ms
(1.10%)
1
SELECT t0.id AS id_1, t0.unique_id AS unique_id_2, t0.name AS name_3, t0.is_default AS is_default_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.community_id AS community_id_7 FROM mve_communities_tag t0 WHERE t0.community_id = ?
Parameters:
[
  3
]

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.