GET https://healthmkt.allxsolutions.com/en/referidos

Query Metrics

6 Database Queries
4 Different statements
42.10 ms Query time
0 Invalid entities
5586 Managed entities

Queries

Group similar statements

#▲ Time Info
1 0.35 ms
SELECT t0.id AS id_1, t0.iso2 AS iso2_2, t0.name AS name_3, t0.iso3 AS iso3_4, t0.numeric_code AS numeric_code_5, t0.phonecode AS phonecode_6, t0.capital AS capital_7, t0.currency AS currency_8, t0.currency_name AS currency_name_9, t0.currency_symbol AS currency_symbol_10, t0.tld AS tld_11, t0.native AS native_12, t0.population AS population_13, t0.gdp AS gdp_14, t0.region AS region_15, t0.subregion AS subregion_16, t0.nationality AS nationality_17, t0.area_sq_km AS area_sq_km_18, t0.postal_code_format AS postal_code_format_19, t0.postal_code_regex AS postal_code_regex_20, t0.timezones AS timezones_21, t0.translations AS translations_22, t0.latitude AS latitude_23, t0.longitude AS longitude_24, t0.emoji AS emoji_25, t0.emoji_u AS emoji_u_26, t0.created_at AS created_at_27, t0.updated_at AS updated_at_28, t0.flag AS flag_29, t0.wiki_data_id AS wiki_data_id_30, t0.region_id AS region_id_31, t0.subregion_id AS subregion_id_32 FROM country t0 WHERE t0.iso2 = ? LIMIT 1
Parameters:
[
  "MX"
]
2 0.49 ms
SELECT t0.id AS id_1, t0.iso2 AS iso2_2, t0.name AS name_3, t0.iso3 AS iso3_4, t0.numeric_code AS numeric_code_5, t0.phonecode AS phonecode_6, t0.capital AS capital_7, t0.currency AS currency_8, t0.currency_name AS currency_name_9, t0.currency_symbol AS currency_symbol_10, t0.tld AS tld_11, t0.native AS native_12, t0.population AS population_13, t0.gdp AS gdp_14, t0.region AS region_15, t0.subregion AS subregion_16, t0.nationality AS nationality_17, t0.area_sq_km AS area_sq_km_18, t0.postal_code_format AS postal_code_format_19, t0.postal_code_regex AS postal_code_regex_20, t0.timezones AS timezones_21, t0.translations AS translations_22, t0.latitude AS latitude_23, t0.longitude AS longitude_24, t0.emoji AS emoji_25, t0.emoji_u AS emoji_u_26, t0.created_at AS created_at_27, t0.updated_at AS updated_at_28, t0.flag AS flag_29, t0.wiki_data_id AS wiki_data_id_30, t0.region_id AS region_id_31, t0.subregion_id AS subregion_id_32 FROM country t0 WHERE t0.iso2 = ? LIMIT 1
Parameters:
[
  "MX"
]
3 0.28 ms
SELECT t0.id AS id_1, t0.iso2 AS iso2_2, t0.name AS name_3, t0.iso3 AS iso3_4, t0.numeric_code AS numeric_code_5, t0.phonecode AS phonecode_6, t0.capital AS capital_7, t0.currency AS currency_8, t0.currency_name AS currency_name_9, t0.currency_symbol AS currency_symbol_10, t0.tld AS tld_11, t0.native AS native_12, t0.population AS population_13, t0.gdp AS gdp_14, t0.region AS region_15, t0.subregion AS subregion_16, t0.nationality AS nationality_17, t0.area_sq_km AS area_sq_km_18, t0.postal_code_format AS postal_code_format_19, t0.postal_code_regex AS postal_code_regex_20, t0.timezones AS timezones_21, t0.translations AS translations_22, t0.latitude AS latitude_23, t0.longitude AS longitude_24, t0.emoji AS emoji_25, t0.emoji_u AS emoji_u_26, t0.created_at AS created_at_27, t0.updated_at AS updated_at_28, t0.flag AS flag_29, t0.wiki_data_id AS wiki_data_id_30, t0.region_id AS region_id_31, t0.subregion_id AS subregion_id_32 FROM country t0 WHERE t0.iso2 = ? LIMIT 1
Parameters:
[
  "MX"
]
4 0.27 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.country_code AS country_code_3, t0.fips_code AS fips_code_4, t0.iso2 AS iso2_5, t0.iso31662 AS iso31662_6, t0.type AS type_7, t0.level AS level_8, t0.parent_id AS parent_id_9, t0.native AS native_10, t0.latitude AS latitude_11, t0.longitude AS longitude_12, t0.timezone AS timezone_13, t0.translations AS translations_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.flag AS flag_17, t0.wiki_data_id AS wiki_data_id_18, t0.population AS population_19, t0.country_id AS country_id_20 FROM state t0 WHERE t0.country_id = ? LIMIT 1
Parameters:
[
  142
]
5 0.76 ms
SELECT c0_.id AS id_0, c0_.iso2 AS iso2_1, c0_.name AS name_2, c0_.iso3 AS iso3_3, c0_.numeric_code AS numeric_code_4, c0_.phonecode AS phonecode_5, c0_.capital AS capital_6, c0_.currency AS currency_7, c0_.currency_name AS currency_name_8, c0_.currency_symbol AS currency_symbol_9, c0_.tld AS tld_10, c0_.native AS native_11, c0_.population AS population_12, c0_.gdp AS gdp_13, c0_.region AS region_14, c0_.subregion AS subregion_15, c0_.nationality AS nationality_16, c0_.area_sq_km AS area_sq_km_17, c0_.postal_code_format AS postal_code_format_18, c0_.postal_code_regex AS postal_code_regex_19, c0_.timezones AS timezones_20, c0_.translations AS translations_21, c0_.latitude AS latitude_22, c0_.longitude AS longitude_23, c0_.emoji AS emoji_24, c0_.emoji_u AS emoji_u_25, c0_.created_at AS created_at_26, c0_.updated_at AS updated_at_27, c0_.flag AS flag_28, c0_.wiki_data_id AS wiki_data_id_29, c0_.region_id AS region_id_30, c0_.subregion_id AS subregion_id_31 FROM country c0_
Parameters:
[]
6 39.95 ms
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.country_code AS country_code_2, s0_.fips_code AS fips_code_3, s0_.iso2 AS iso2_4, s0_.iso31662 AS iso31662_5, s0_.type AS type_6, s0_.level AS level_7, s0_.parent_id AS parent_id_8, s0_.native AS native_9, s0_.latitude AS latitude_10, s0_.longitude AS longitude_11, s0_.timezone AS timezone_12, s0_.translations AS translations_13, s0_.created_at AS created_at_14, s0_.updated_at AS updated_at_15, s0_.flag AS flag_16, s0_.wiki_data_id AS wiki_data_id_17, s0_.population AS population_18, s0_.country_id AS country_id_19 FROM state s0_
Parameters:
[]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\State 5308
App\Entity\Country 250
App\Entity\Subregion 22
App\Entity\Region 6

Entities Mapping

Class Mapping errors
App\Entity\Country No errors.
App\Entity\Region No errors.
App\Entity\Subregion No errors.
App\Entity\Contacto No errors.
App\Entity\Referido No errors.
App\Entity\State No errors.
App\Entity\Postcode No errors.