https://dev-bi.tile.expert/en/login

Query Metrics

1 Database Queries
1 Different statements
10.92 ms Query time
1 Invalid entities

Queries

Group similar statements

default connection

# Time Info
1 10.92 ms
SELECT g0_.`id` AS id_0, g0_.`alias` AS alias_1, g0_.`code` AS code_2, g0_.`code_small` AS code_small_3, g0_.`iso` AS iso_4, g0_.`phone_code` AS phone_code_5, g0_.`phone_mask` AS phone_mask_6, g0_.`zip_code_mask` AS zip_code_mask_7, g0_.`percent_vat` AS percent_vat_8, g0_.`percent_pay_pal` AS percent_pay_pal_9, g0_.`percent_own_pay_pal` AS percent_own_pay_pal_10, g0_.`vat` AS vat_11, g0_.`pv_type` AS pv_type_12, g0_.`hide` AS hide_13, g0_.`locales` AS locales_14, g0_.`capital_timezone_diff` AS capital_timezone_diff_15, g0_.`created_at` AS created_at_16, g0_.`updated_at` AS updated_at_17, g1_.`id` AS id_18, g1_.`source` AS source_19, g1_.`ru` AS ru_20, g1_.`en` AS en_21, g1_.`it` AS it_22, g1_.`es` AS es_23, g1_.`fr` AS fr_24, g1_.`de` AS de_25, g1_.`pl` AS pl_26, g1_.`pt` AS pt_27, g1_.`nl` AS nl_28, g1_.`fi` AS fi_29, g1_.`ua` AS ua_30, g1_.`sv` AS sv_31, g1_.`no` AS no_32, g1_.`da` AS da_33, g1_.`zh` AS zh_34, g1_.`created_at` AS created_at_35, g1_.`updated_at` AS updated_at_36, g2_.`id` AS id_37, g2_.`source` AS source_38, g2_.`ru` AS ru_39, g2_.`en` AS en_40, g2_.`it` AS it_41, g2_.`es` AS es_42, g2_.`fr` AS fr_43, g2_.`de` AS de_44, g2_.`pl` AS pl_45, g2_.`pt` AS pt_46, g2_.`nl` AS nl_47, g2_.`fi` AS fi_48, g2_.`ua` AS ua_49, g2_.`sv` AS sv_50, g2_.`no` AS no_51, g2_.`da` AS da_52, g2_.`zh` AS zh_53, g2_.`created_at` AS created_at_54, g2_.`updated_at` AS updated_at_55, g3_.`id` AS id_56, g3_.`source` AS source_57, g3_.`ru` AS ru_58, g3_.`en` AS en_59, g3_.`it` AS it_60, g3_.`es` AS es_61, g3_.`fr` AS fr_62, g3_.`de` AS de_63, g3_.`pl` AS pl_64, g3_.`pt` AS pt_65, g3_.`nl` AS nl_66, g3_.`fi` AS fi_67, g3_.`ua` AS ua_68, g3_.`sv` AS sv_69, g3_.`no` AS no_70, g3_.`da` AS da_71, g3_.`zh` AS zh_72, g3_.`created_at` AS created_at_73, g3_.`updated_at` AS updated_at_74, g4_.`id` AS id_75, g4_.`source` AS source_76, g4_.`ru` AS ru_77, g4_.`en` AS en_78, g4_.`it` AS it_79, g4_.`es` AS es_80, g4_.`fr` AS fr_81, g4_.`de` AS de_82, g4_.`pl` AS pl_83, g4_.`pt` AS pt_84, g4_.`nl` AS nl_85, g4_.`fi` AS fi_86, g4_.`ua` AS ua_87, g4_.`sv` AS sv_88, g4_.`no` AS no_89, g4_.`da` AS da_90, g4_.`zh` AS zh_91, g4_.`created_at` AS created_at_92, g4_.`updated_at` AS updated_at_93, g5_.`id` AS id_94, g5_.`source` AS source_95, g5_.`ru` AS ru_96, g5_.`en` AS en_97, g5_.`it` AS it_98, g5_.`es` AS es_99, g5_.`fr` AS fr_100, g5_.`de` AS de_101, g5_.`pl` AS pl_102, g5_.`pt` AS pt_103, g5_.`nl` AS nl_104, g5_.`fi` AS fi_105, g5_.`ua` AS ua_106, g5_.`sv` AS sv_107, g5_.`no` AS no_108, g5_.`da` AS da_109, g5_.`zh` AS zh_110, g5_.`created_at` AS created_at_111, g5_.`updated_at` AS updated_at_112, g6_.`id` AS id_113, g6_.`source` AS source_114, g6_.`ru` AS ru_115, g6_.`en` AS en_116, g6_.`it` AS it_117, g6_.`es` AS es_118, g6_.`fr` AS fr_119, g6_.`de` AS de_120, g6_.`pl` AS pl_121, g6_.`pt` AS pt_122, g6_.`nl` AS nl_123, g6_.`fi` AS fi_124, g6_.`ua` AS ua_125, g6_.`sv` AS sv_126, g6_.`no` AS no_127, g6_.`da` AS da_128, g6_.`zh` AS zh_129, g6_.`created_at` AS created_at_130, g6_.`updated_at` AS updated_at_131, g7_.`id` AS id_132, g7_.`source` AS source_133, g7_.`ru` AS ru_134, g7_.`en` AS en_135, g7_.`it` AS it_136, g7_.`es` AS es_137, g7_.`fr` AS fr_138, g7_.`de` AS de_139, g7_.`pl` AS pl_140, g7_.`pt` AS pt_141, g7_.`nl` AS nl_142, g7_.`fi` AS fi_143, g7_.`ua` AS ua_144, g7_.`sv` AS sv_145, g7_.`no` AS no_146, g7_.`da` AS da_147, g7_.`zh` AS zh_148, g7_.`created_at` AS created_at_149, g7_.`updated_at` AS updated_at_150 FROM `geo_country` g0_ LEFT JOIN `geo_locale_name` g1_ ON g0_.id = g1_.country_name_id LEFT JOIN `geo_locale_name` g2_ ON g0_.id = g2_.country_name_in_id LEFT JOIN `geo_locale_name` g3_ ON g0_.id = g3_.country_name_to_id LEFT JOIN `geo_locale_name` g4_ ON g0_.id = g4_.country_name_of_id LEFT JOIN `geo_locale_name` g5_ ON g0_.id = g5_.country_name_across_id LEFT JOIN `geo_locale_name` g6_ ON g0_.id = g6_.country_name_which_id LEFT JOIN `geo_locale_name` g7_ ON g0_.id = g7_.country_capital_id
Parameters:
[]

unbuffered connection

No database queries were performed.

oneC connection

No database queries were performed.

logs connection

No database queries were performed.

Database Connections

Name Service
default doctrine.dbal.default_connection
unbuffered doctrine.dbal.unbuffered_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
  • The field WebBundle\Entity\User#foreignAlias is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity WebBundle\Entity\UserForeignAlias#user does not contain the required 'inversedBy="foreignAlias"' attribute.
  • The field WebBundle\Entity\User#socialNetwork is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity WebBundle\Entity\SocialNetwork#user does not contain the required 'inversedBy="socialNetwork"' attribute.
WebBundle\Entity\BuyOrder No errors.
FlexApp\Entity\InvitationEmailDeliveryStats No errors.
FlexApp\Entity\GeoCountryEntity 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.
WebBundle\Entity\ListCountry No errors.
FlexApp\Entity\ConsultantEntity No errors.
FlexApp\Entity\GeoLocaleNameEntity No errors.

oneC entity manager

No loaded entities.

logs entity manager

No loaded entities.