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 "
]
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 = 3 AND t0 . level_id = 7 AND t0 . grade = 'Principal' ;
Copy
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 = ?
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 = 1 ;
Copy
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 = ?
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 = 2 ;
Copy
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
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 = 'active' ORDER BY t0 . name ASC ;
Copy
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
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 = 3 AND t0 . cost_id = 13 LIMIT 1 ;
Copy
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 "
]
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 = 'c1f2c6e3249df2b5a17ba8d01aba7ed71b4931f6bc135f106fe6fc0716858498' LIMIT 1 ;
Copy
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 = ?
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 = 3 ;
Copy
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
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 = 1 ORDER BY t0 . sort_order ASC ;
Copy
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
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 = 3 AND t0 . is_visible = 1 ORDER BY t0 . id ASC ;
Copy
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 = ?
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 = 3 ;
Copy
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 = ?
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 = 3 ;
Copy
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
]
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 (227 , 4 , 149 , 3 ) ORDER BY t0 . name ASC ;
Copy
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 = ?
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 = 3 AND t0 . is_active = 1 ;
Copy
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
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 = 3 ORDER BY t0 . priority ASC ;
Copy
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
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 ;
Copy
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 = ?
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 = 3 ;
Copy