Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

1 Database Queries

1 Different statements

0.14 ms Query time

0 Invalid entities

Queries

Group similar statements

default connection

#▲	Time	Info
1	0.14 ms	SELECT l0_.`id` AS id_0, l0_.`code` AS code_1, l0_.`locale` AS locale_2, l0_.`phone_code` AS phone_code_3, l0_.`phone_mask` AS phone_mask_4, l0_.`min_valid_phone_numbers` AS min_valid_phone_numbers_5, l0_.`zip_code_mask` AS zip_code_mask_6, l0_.`percent_vat` AS percent_vat_7, l0_.`name` AS name_8, l0_.`name_en` AS name_en_9, l0_.`alias` AS alias_10, l0_.`sort` AS sort_11, l0_.`count` AS count_12, l0_.`hide` AS hide_13, l0_.`important` AS important_14, l0_.`pay_pal_percent` AS pay_pal_percent_15, l0_.`pay_pal_percent_own` AS pay_pal_percent_own_16, l0_.`vat` AS vat_17, l0_.`pv_type` AS pv_type_18, l0_.`capital_timezone_diff` AS capital_timezone_diff_19, l0_.`capital` AS capital_20, l0_.`free_sample_delivery` AS free_sample_delivery_21, l0_.`units` AS units_22 FROM `list_country` l0_ WHERE l0_.`hide` <> 1 ORDER BY l0_.`code` ASC Parameters: [] View formatted query View runnable query Explain query SELECT l0_.`id` AS id_0, l0_.`code` AS code_1, l0_.`locale` AS locale_2, l0_.`phone_code` AS phone_code_3, l0_.`phone_mask` AS phone_mask_4, l0_.`min_valid_phone_numbers` AS min_valid_phone_numbers_5, l0_.`zip_code_mask` AS zip_code_mask_6, l0_.`percent_vat` AS percent_vat_7, l0_.`name` AS name_8, l0_.`name_en` AS name_en_9, l0_.`alias` AS alias_10, l0_.`sort` AS sort_11, l0_.`count` AS count_12, l0_.`hide` AS hide_13, l0_.`important` AS important_14, l0_.`pay_pal_percent` AS pay_pal_percent_15, l0_.`pay_pal_percent_own` AS pay_pal_percent_own_16, l0_.`vat` AS vat_17, l0_.`pv_type` AS pv_type_18, l0_.`capital_timezone_diff` AS capital_timezone_diff_19, l0_.`capital` AS capital_20, l0_.`free_sample_delivery` AS free_sample_delivery_21, l0_.`units` AS units_22 FROM `list_country` l0_ WHERE l0_.`hide` <> 1 ORDER BY l0_.`code` ASC SELECT l0_.`id` AS id_0, l0_.`code` AS code_1, l0_.`locale` AS locale_2, l0_.`phone_code` AS phone_code_3, l0_.`phone_mask` AS phone_mask_4, l0_.`min_valid_phone_numbers` AS min_valid_phone_numbers_5, l0_.`zip_code_mask` AS zip_code_mask_6, l0_.`percent_vat` AS percent_vat_7, l0_.`name` AS name_8, l0_.`name_en` AS name_en_9, l0_.`alias` AS alias_10, l0_.`sort` AS sort_11, l0_.`count` AS count_12, l0_.`hide` AS hide_13, l0_.`important` AS important_14, l0_.`pay_pal_percent` AS pay_pal_percent_15, l0_.`pay_pal_percent_own` AS pay_pal_percent_own_16, l0_.`vat` AS vat_17, l0_.`pv_type` AS pv_type_18, l0_.`capital_timezone_diff` AS capital_timezone_diff_19, l0_.`capital` AS capital_20, l0_.`free_sample_delivery` AS free_sample_delivery_21, l0_.`units` AS units_22 FROM `list_country` l0_ WHERE l0_.`hide` <> 1 ORDER BY l0_.`code` ASC;

#▲

Time

Info

0.14 ms

SELECT l0_.`id` AS id_0, l0_.`code` AS code_1, l0_.`locale` AS locale_2, l0_.`phone_code` AS phone_code_3, l0_.`phone_mask` AS phone_mask_4, l0_.`min_valid_phone_numbers` AS min_valid_phone_numbers_5, l0_.`zip_code_mask` AS zip_code_mask_6, l0_.`percent_vat` AS percent_vat_7, l0_.`name` AS name_8, l0_.`name_en` AS name_en_9, l0_.`alias` AS alias_10, l0_.`sort` AS sort_11, l0_.`count` AS count_12, l0_.`hide` AS hide_13, l0_.`important` AS important_14, l0_.`pay_pal_percent` AS pay_pal_percent_15, l0_.`pay_pal_percent_own` AS pay_pal_percent_own_16, l0_.`vat` AS vat_17, l0_.`pv_type` AS pv_type_18, l0_.`capital_timezone_diff` AS capital_timezone_diff_19, l0_.`capital` AS capital_20, l0_.`free_sample_delivery` AS free_sample_delivery_21, l0_.`units` AS units_22 FROM `list_country` l0_ WHERE l0_.`hide` <> 1 ORDER BY l0_.`code` ASC

Parameters:

[]

View formatted query View runnable query Explain query

SELECT
  l0_.`id` AS id_0,
  l0_.`code` AS code_1,
  l0_.`locale` AS locale_2,
  l0_.`phone_code` AS phone_code_3,
  l0_.`phone_mask` AS phone_mask_4,
  l0_.`min_valid_phone_numbers` AS min_valid_phone_numbers_5,
  l0_.`zip_code_mask` AS zip_code_mask_6,
  l0_.`percent_vat` AS percent_vat_7,
  l0_.`name` AS name_8,
  l0_.`name_en` AS name_en_9,
  l0_.`alias` AS alias_10,
  l0_.`sort` AS sort_11,
  l0_.`count` AS count_12,
  l0_.`hide` AS hide_13,
  l0_.`important` AS important_14,
  l0_.`pay_pal_percent` AS pay_pal_percent_15,
  l0_.`pay_pal_percent_own` AS pay_pal_percent_own_16,
  l0_.`vat` AS vat_17,
  l0_.`pv_type` AS pv_type_18,
  l0_.`capital_timezone_diff` AS capital_timezone_diff_19,
  l0_.`capital` AS capital_20,
  l0_.`free_sample_delivery` AS free_sample_delivery_21,
  l0_.`units` AS units_22
FROM
  `list_country` l0_
WHERE
  l0_.`hide` <> 1
ORDER BY
  l0_.`code` ASC

SELECT l0_.`id` AS id_0, l0_.`code` AS code_1, l0_.`locale` AS locale_2, l0_.`phone_code` AS phone_code_3, l0_.`phone_mask` AS phone_mask_4, l0_.`min_valid_phone_numbers` AS min_valid_phone_numbers_5, l0_.`zip_code_mask` AS zip_code_mask_6, l0_.`percent_vat` AS percent_vat_7, l0_.`name` AS name_8, l0_.`name_en` AS name_en_9, l0_.`alias` AS alias_10, l0_.`sort` AS sort_11, l0_.`count` AS count_12, l0_.`hide` AS hide_13, l0_.`important` AS important_14, l0_.`pay_pal_percent` AS pay_pal_percent_15, l0_.`pay_pal_percent_own` AS pay_pal_percent_own_16, l0_.`vat` AS vat_17, l0_.`pv_type` AS pv_type_18, l0_.`capital_timezone_diff` AS capital_timezone_diff_19, l0_.`capital` AS capital_20, l0_.`free_sample_delivery` AS free_sample_delivery_21, l0_.`units` AS units_22 FROM `list_country` l0_ WHERE l0_.`hide` <> 1 ORDER BY l0_.`code` ASC;

oneC connection

No database queries were performed.

logs connection

No database queries were performed.

Database Connections

Name	Service
default	doctrine.dbal.default_connection
oneC	doctrine.dbal.oneC_connection
logs	doctrine.dbal.logs_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager
oneC	doctrine.orm.oneC_entity_manager
logs	doctrine.orm.logs_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

default entity manager

Class	Mapping errors
WebBundle\Entity\User	No errors.
WebBundle\Entity\ListCountry	No errors.
FlexApp\Entity\ChatB	No errors.
FlexApp\Entity\ChatBMessage	No errors.
FlexApp\Entity\BoolDBSetting	No errors.
FlexApp\Entity\Widget	No errors.
FlexApp\Entity\CountryAndLangSpecificDataEntity	No errors.
FlexApp\Entity\ConsultantEntity	No errors.
FlexApp\Entity\GeoCountryEntity	No errors.

oneC entity manager

No loaded entities.

logs entity manager