Query Metrics

12 Database Queries
11 Different statements
27.65 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

default connection

Time Count Info
12.25 ms
(0.00%)
1
SELECT p0_.`id` AS id_0, p0_.`enable` AS enable_1, p0_.`unid` AS unid_2, p0_.`publish_date` AS publish_date_3, p0_.`update_date` AS update_date_4, p0_.`view` AS view_5, p0_.`hide_countries` AS hide_countries_6, l1_.`id` AS id_7, l1_.`source` AS source_8, l1_.`ru` AS ru_9, l1_.`en` AS en_10, l1_.`it` AS it_11, l1_.`es` AS es_12, l1_.`fr` AS fr_13, l1_.`de` AS de_14, l1_.`pl` AS pl_15, l1_.`pt` AS pt_16, l1_.`nl` AS nl_17, l1_.`fi` AS fi_18, l1_.`ua` AS ua_19, l1_.`sv` AS sv_20, l1_.`no` AS no_21, l1_.`da` AS da_22, l1_.`cn` AS cn_23, l1_.`zh` AS zh_24, l1_.`created_at` AS created_at_25, l1_.`updated_at` AS updated_at_26, l2_.`id` AS id_27, l2_.`source` AS source_28, l2_.`ru` AS ru_29, l2_.`en` AS en_30, l2_.`it` AS it_31, l2_.`es` AS es_32, l2_.`fr` AS fr_33, l2_.`de` AS de_34, l2_.`pl` AS pl_35, l2_.`pt` AS pt_36, l2_.`nl` AS nl_37, l2_.`fi` AS fi_38, l2_.`ua` AS ua_39, l2_.`sv` AS sv_40, l2_.`no` AS no_41, l2_.`da` AS da_42, l2_.`cn` AS cn_43, l2_.`zh` AS zh_44, l2_.`created_at` AS created_at_45, l2_.`updated_at` AS updated_at_46, l3_.`id` AS id_47, l3_.`source` AS source_48, l3_.`ru` AS ru_49, l3_.`en` AS en_50, l3_.`it` AS it_51, l3_.`es` AS es_52, l3_.`fr` AS fr_53, l3_.`de` AS de_54, l3_.`pl` AS pl_55, l3_.`pt` AS pt_56, l3_.`nl` AS nl_57, l3_.`fi` AS fi_58, l3_.`ua` AS ua_59, l3_.`sv` AS sv_60, l3_.`no` AS no_61, l3_.`da` AS da_62, l3_.`cn` AS cn_63, l3_.`zh` AS zh_64, l3_.`created_at` AS created_at_65, l3_.`updated_at` AS updated_at_66, l4_.`id` AS id_67, l4_.`source` AS source_68, l4_.`ru` AS ru_69, l4_.`en` AS en_70, l4_.`it` AS it_71, l4_.`es` AS es_72, l4_.`fr` AS fr_73, l4_.`de` AS de_74, l4_.`pl` AS pl_75, l4_.`pt` AS pt_76, l4_.`nl` AS nl_77, l4_.`fi` AS fi_78, l4_.`ua` AS ua_79, l4_.`sv` AS sv_80, l4_.`no` AS no_81, l4_.`da` AS da_82, l4_.`cn` AS cn_83, l4_.`zh` AS zh_84, l4_.`created_at` AS created_at_85, l4_.`updated_at` AS updated_at_86, l5_.`id` AS id_87, l5_.`source` AS source_88, l5_.`ru` AS ru_89, l5_.`en` AS en_90, l5_.`it` AS it_91, l5_.`es` AS es_92, l5_.`fr` AS fr_93, l5_.`de` AS de_94, l5_.`pl` AS pl_95, l5_.`pt` AS pt_96, l5_.`nl` AS nl_97, l5_.`fi` AS fi_98, l5_.`ua` AS ua_99, l5_.`sv` AS sv_100, l5_.`no` AS no_101, l5_.`da` AS da_102, l5_.`cn` AS cn_103, l5_.`zh` AS zh_104, l5_.`created_at` AS created_at_105, l5_.`updated_at` AS updated_at_106, l6_.`id` AS id_107, l6_.`source` AS source_108, l6_.`ru` AS ru_109, l6_.`en` AS en_110, l6_.`it` AS it_111, l6_.`es` AS es_112, l6_.`fr` AS fr_113, l6_.`de` AS de_114, l6_.`pl` AS pl_115, l6_.`pt` AS pt_116, l6_.`nl` AS nl_117, l6_.`fi` AS fi_118, l6_.`ua` AS ua_119, l6_.`sv` AS sv_120, l6_.`no` AS no_121, l6_.`da` AS da_122, l6_.`cn` AS cn_123, l6_.`zh` AS zh_124, l6_.`created_at` AS created_at_125, l6_.`updated_at` AS updated_at_126, l7_.`id` AS id_127, l7_.`def` AS def_128, l7_.`ru` AS ru_129, l7_.`en` AS en_130, l7_.`it` AS it_131, l7_.`es` AS es_132, l7_.`fr` AS fr_133, l7_.`de` AS de_134, l7_.`pl` AS pl_135, l7_.`pt` AS pt_136, l7_.`nl` AS nl_137, l7_.`fi` AS fi_138, l7_.`ua` AS ua_139, l7_.`sv` AS sv_140, l7_.`no` AS no_141, l7_.`da` AS da_142, l7_.`cn` AS cn_143, l7_.`zh` AS zh_144, l7_.`created_at` AS created_at_145, l7_.`updated_at` AS updated_at_146, p8_.`id` AS id_147, p8_.`token` AS token_148, u9_.`id` AS id_149, u9_.`unid` AS unid_150, u9_.`corporate_unid` AS corporate_unid_151, u9_.`token` AS token_152, u9_.`is_active` AS is_active_153, u9_.`proved` AS proved_154, u9_.`alias` AS alias_155, u9_.`foreign_alias` AS foreign_alias_156, u9_.`lotus_name` AS lotus_name_157, u9_.`password` AS password_158, u9_.`expired` AS expired_159, u9_.`expires_at` AS expires_at_160, u9_.`credentials_expired` AS credentials_expired_161, u9_.`credentials_expire_at` AS credentials_expire_at_162, u9_.`last_ip` AS last_ip_163, u9_.`source` AS source_164, u9_.`social_network` AS social_network_165, u9_.`social_network_id` AS social_network_id_166, u9_.`google_id` AS google_id_167, u9_.`fb_id` AS fb_id_168, u9_.`vk_id` AS vk_id_169, u9_.`ig_id` AS ig_id_170, u9_.`test` AS test_171, u9_.`token_fixed` AS token_fixed_172, u9_.`bid` AS bid_173, u9_.`email` AS email_174, u9_.`salt` AS salt_175, u9_.`review_request_sent` AS review_request_sent_176, u9_.`username` AS username_177, u9_.`roles` AS roles_178, u9_.`enabled` AS enabled_179, u9_.`confirmation_token` AS confirmation_token_180, u9_.`last_login` AS last_login_181, u9_.`password_requested_at` AS password_requested_at_182, u9_.`security_field` AS security_field_183, u9_.`created_at` AS created_at_184, u9_.`is_legal_entity` AS is_legal_entity_185, u9_.`companyName` AS companyName_186, u9_.`vatNumber` AS vatNumber_187, u9_.`lang` AS lang_188, l10_.`id` AS id_189, l10_.`source` AS source_190, l10_.`ru` AS ru_191, l10_.`en` AS en_192, l10_.`it` AS it_193, l10_.`es` AS es_194, l10_.`fr` AS fr_195, l10_.`de` AS de_196, l10_.`pl` AS pl_197, l10_.`pt` AS pt_198, l10_.`nl` AS nl_199, l10_.`fi` AS fi_200, l10_.`ua` AS ua_201, l10_.`sv` AS sv_202, l10_.`no` AS no_203, l10_.`da` AS da_204, l10_.`cn` AS cn_205, l10_.`zh` AS zh_206, l10_.`created_at` AS created_at_207, l10_.`updated_at` AS updated_at_208 FROM `publication` p0_ LEFT JOIN `locale_url` l1_ ON p0_.id = l1_.publication_id LEFT JOIN `locale_html` l2_ ON p0_.id = l2_.publication_body_id LEFT JOIN `locale_title` l3_ ON p0_.id = l3_.publication_id LEFT JOIN `locale_meta` l4_ ON p0_.id = l4_.blog_description_id LEFT JOIN `locale_meta` l5_ ON p0_.id = l5_.blog_keywords_id LEFT JOIN `locale_bool` l6_ ON p0_.id = l6_.blog_show_id LEFT JOIN `locale_preview` l7_ ON p0_.id = l7_.publication_id LEFT JOIN `publication_like` p8_ ON p0_.id = p8_.publication_id LEFT JOIN `user` u9_ ON p0_.author = u9_.id LEFT JOIN `locale_bool` l10_ ON p0_.id = l10_.blog_hide_single_id WHERE l1_.`ru` = ? OR l1_.`en` = ? OR l1_.`it` = ? OR l1_.`es` = ? OR l1_.`fr` = ? OR l1_.`de` = ? OR l1_.`pl` = ? OR l1_.`nl` = ? OR l1_.`fi` = ? OR l1_.`sv` = ?
Parameters:
[
  "highlights-of-cersaie-2021-tile-exhibition-bologna"
  "highlights-of-cersaie-2021-tile-exhibition-bologna"
  "highlights-of-cersaie-2021-tile-exhibition-bologna"
  "highlights-of-cersaie-2021-tile-exhibition-bologna"
  "highlights-of-cersaie-2021-tile-exhibition-bologna"
  "highlights-of-cersaie-2021-tile-exhibition-bologna"
  "highlights-of-cersaie-2021-tile-exhibition-bologna"
  "highlights-of-cersaie-2021-tile-exhibition-bologna"
  "highlights-of-cersaie-2021-tile-exhibition-bologna"
  "highlights-of-cersaie-2021-tile-exhibition-bologna"
]
8.68 ms
(0.00%)
1
SELECT e0_.`id` AS id_0, e0_.`enable` AS enable_1, e0_.`unid` AS unid_2, e0_.`view` AS view_3, e0_.`created_at` AS created_at_4, e0_.`updated_at` AS updated_at_5, l1_.`id` AS id_6, l1_.`source` AS source_7, l1_.`ru` AS ru_8, l1_.`en` AS en_9, l1_.`it` AS it_10, l1_.`es` AS es_11, l1_.`fr` AS fr_12, l1_.`de` AS de_13, l1_.`pl` AS pl_14, l1_.`pt` AS pt_15, l1_.`nl` AS nl_16, l1_.`fi` AS fi_17, l1_.`ua` AS ua_18, l1_.`sv` AS sv_19, l1_.`no` AS no_20, l1_.`da` AS da_21, l1_.`cn` AS cn_22, l1_.`zh` AS zh_23, l1_.`created_at` AS created_at_24, l1_.`updated_at` AS updated_at_25, l2_.`id` AS id_26, l2_.`source` AS source_27, l2_.`ru` AS ru_28, l2_.`en` AS en_29, l2_.`it` AS it_30, l2_.`es` AS es_31, l2_.`fr` AS fr_32, l2_.`de` AS de_33, l2_.`pl` AS pl_34, l2_.`pt` AS pt_35, l2_.`nl` AS nl_36, l2_.`fi` AS fi_37, l2_.`ua` AS ua_38, l2_.`sv` AS sv_39, l2_.`no` AS no_40, l2_.`da` AS da_41, l2_.`cn` AS cn_42, l2_.`zh` AS zh_43, l2_.`created_at` AS created_at_44, l2_.`updated_at` AS updated_at_45, l3_.`id` AS id_46, l3_.`source` AS source_47, l3_.`ru` AS ru_48, l3_.`en` AS en_49, l3_.`it` AS it_50, l3_.`es` AS es_51, l3_.`fr` AS fr_52, l3_.`de` AS de_53, l3_.`pl` AS pl_54, l3_.`pt` AS pt_55, l3_.`nl` AS nl_56, l3_.`fi` AS fi_57, l3_.`ua` AS ua_58, l3_.`sv` AS sv_59, l3_.`no` AS no_60, l3_.`da` AS da_61, l3_.`cn` AS cn_62, l3_.`zh` AS zh_63, l3_.`created_at` AS created_at_64, l3_.`updated_at` AS updated_at_65, l4_.`id` AS id_66, l4_.`source` AS source_67, l4_.`ru` AS ru_68, l4_.`en` AS en_69, l4_.`it` AS it_70, l4_.`es` AS es_71, l4_.`fr` AS fr_72, l4_.`de` AS de_73, l4_.`pl` AS pl_74, l4_.`pt` AS pt_75, l4_.`nl` AS nl_76, l4_.`fi` AS fi_77, l4_.`ua` AS ua_78, l4_.`sv` AS sv_79, l4_.`no` AS no_80, l4_.`da` AS da_81, l4_.`cn` AS cn_82, l4_.`zh` AS zh_83, l4_.`created_at` AS created_at_84, l4_.`updated_at` AS updated_at_85, l5_.`id` AS id_86, l5_.`source` AS source_87, l5_.`ru` AS ru_88, l5_.`en` AS en_89, l5_.`it` AS it_90, l5_.`es` AS es_91, l5_.`fr` AS fr_92, l5_.`de` AS de_93, l5_.`pl` AS pl_94, l5_.`pt` AS pt_95, l5_.`nl` AS nl_96, l5_.`fi` AS fi_97, l5_.`ua` AS ua_98, l5_.`sv` AS sv_99, l5_.`no` AS no_100, l5_.`da` AS da_101, l5_.`cn` AS cn_102, l5_.`zh` AS zh_103, l5_.`created_at` AS created_at_104, l5_.`updated_at` AS updated_at_105, l6_.`id` AS id_106, l6_.`def` AS def_107, l6_.`ru` AS ru_108, l6_.`en` AS en_109, l6_.`it` AS it_110, l6_.`es` AS es_111, l6_.`fr` AS fr_112, l6_.`de` AS de_113, l6_.`pl` AS pl_114, l6_.`pt` AS pt_115, l6_.`nl` AS nl_116, l6_.`fi` AS fi_117, l6_.`ua` AS ua_118, l6_.`sv` AS sv_119, l6_.`no` AS no_120, l6_.`da` AS da_121, l6_.`cn` AS cn_122, l6_.`zh` AS zh_123, l6_.`created_at` AS created_at_124, l6_.`updated_at` AS updated_at_125, l7_.`id` AS id_126, l7_.`token` AS token_127, e8_.`id` AS id_128, e8_.`enable` AS enable_129, e8_.`name` AS name_130, e8_.`cid` AS cid_131, l9_.`id` AS id_132, l9_.`source` AS source_133, l9_.`ru` AS ru_134, l9_.`en` AS en_135, l9_.`it` AS it_136, l9_.`es` AS es_137, l9_.`fr` AS fr_138, l9_.`de` AS de_139, l9_.`pl` AS pl_140, l9_.`pt` AS pt_141, l9_.`nl` AS nl_142, l9_.`fi` AS fi_143, l9_.`ua` AS ua_144, l9_.`sv` AS sv_145, l9_.`no` AS no_146, l9_.`da` AS da_147, l9_.`cn` AS cn_148, l9_.`zh` AS zh_149, l9_.`created_at` AS created_at_150, l9_.`updated_at` AS updated_at_151 FROM `exh` e0_ LEFT JOIN `locale_url` l1_ ON e0_.id = l1_.exh_id LEFT JOIN `locale_title` l2_ ON e0_.id = l2_.exh_title_id LEFT JOIN `locale_html` l3_ ON e0_.id = l3_.exh_text_id LEFT JOIN `locale_meta` l4_ ON e0_.id = l4_.exh_description_id LEFT JOIN `locale_meta` l5_ ON e0_.id = l5_.exh_keywords_id LEFT JOIN `locale_preview` l6_ ON e0_.id = l6_.exh_id LEFT JOIN `likes` l7_ ON e0_.id = l7_.exh_id LEFT JOIN `exh_brand` e8_ ON e0_.id = e8_.exh_id LEFT JOIN `locale_bool` l9_ ON e0_.id = l9_.exh_show_id WHERE l1_.`ru` = ? OR l1_.`en` = ? OR l1_.`it` = ? OR l1_.`es` = ? OR l1_.`fr` = ? OR l1_.`de` = ? OR l1_.`pl` = ? OR l1_.`nl` = ? OR l1_.`fi` = ? OR l1_.`sv` = ?
Parameters:
[
  "highlights-of-cersaie-2021-tile-exhibition-bologna"
  "highlights-of-cersaie-2021-tile-exhibition-bologna"
  "highlights-of-cersaie-2021-tile-exhibition-bologna"
  "highlights-of-cersaie-2021-tile-exhibition-bologna"
  "highlights-of-cersaie-2021-tile-exhibition-bologna"
  "highlights-of-cersaie-2021-tile-exhibition-bologna"
  "highlights-of-cersaie-2021-tile-exhibition-bologna"
  "highlights-of-cersaie-2021-tile-exhibition-bologna"
  "highlights-of-cersaie-2021-tile-exhibition-bologna"
  "highlights-of-cersaie-2021-tile-exhibition-bologna"
]
2.10 ms
(0.00%)
1
UPDATE `exh` SET `view` = `view` + 1  WHERE `id` = 9;
Parameters:
[]
0.82 ms
(0.00%)
1
SELECT COUNT(i0_.`id`) AS sclr_0 FROM `idea` i1_ INNER JOIN idea_interior i2_ ON i1_.id = i2_.idea_id INNER JOIN `interior` i0_ ON i0_.id = i2_.interior_id WHERE i1_.`token` = ?
Parameters:
[
  "ef4603a0e666d8cd9c6d39109bebc460f3de05a4037ac08e7ee40a74c95f6a00"
]
0.81 ms
(0.00%)
1
SELECT u0_.`id` AS id_0, u0_.`unid` AS unid_1, u0_.`corporate_unid` AS corporate_unid_2, u0_.`token` AS token_3, u0_.`is_active` AS is_active_4, u0_.`proved` AS proved_5, u0_.`alias` AS alias_6, u0_.`foreign_alias` AS foreign_alias_7, u0_.`lotus_name` AS lotus_name_8, u0_.`password` AS password_9, u0_.`expired` AS expired_10, u0_.`expires_at` AS expires_at_11, u0_.`credentials_expired` AS credentials_expired_12, u0_.`credentials_expire_at` AS credentials_expire_at_13, u0_.`last_ip` AS last_ip_14, u0_.`source` AS source_15, u0_.`social_network` AS social_network_16, u0_.`social_network_id` AS social_network_id_17, u0_.`google_id` AS google_id_18, u0_.`fb_id` AS fb_id_19, u0_.`vk_id` AS vk_id_20, u0_.`ig_id` AS ig_id_21, u0_.`test` AS test_22, u0_.`token_fixed` AS token_fixed_23, u0_.`bid` AS bid_24, u0_.`email` AS email_25, u0_.`salt` AS salt_26, u0_.`review_request_sent` AS review_request_sent_27, u0_.`username` AS username_28, u0_.`roles` AS roles_29, u0_.`enabled` AS enabled_30, u0_.`confirmation_token` AS confirmation_token_31, u0_.`last_login` AS last_login_32, u0_.`password_requested_at` AS password_requested_at_33, u0_.`security_field` AS security_field_34, u0_.`created_at` AS created_at_35, u0_.`is_legal_entity` AS is_legal_entity_36, u0_.`companyName` AS companyName_37, u0_.`vatNumber` AS vatNumber_38, u0_.`lang` AS lang_39 FROM `user` u0_ WHERE u0_.`token` = ? LIMIT 1
Parameters:
[
  "ef4603a0e666d8cd9c6d39109bebc460f3de05a4037ac08e7ee40a74c95f6a00"
]
0.74 ms
(0.00%)
1
SELECT COUNT(b0_.`code`) AS sclr_0 FROM `buy_order` b1_ LEFT JOIN `buy_order_article` b0_ ON b1_.id = b0_.buy_order_id WHERE b1_.`token` = ? AND b1_.`status` <> 12
Parameters:
[
  "ef4603a0e666d8cd9c6d39109bebc460f3de05a4037ac08e7ee40a74c95f6a00"
]
0.64 ms
(0.00%)
1
SELECT t0.`id` AS id_1, t0.`token` AS token_2, t0.`current_welcome_cons` AS current_welcome_cons_3, t0.`current_country` AS current_country_4, t0.`current_country_by_ip` AS current_country_by_ip_5, t0.`current_locale` AS current_locale_6, t0.`is_interview` AS is_interview_7, t0.`job_seeker_unid` AS job_seeker_unid_8, t0.interview_id AS interview_id_9 FROM `chat_b` t0 WHERE t0.`token` = ? LIMIT 1
Parameters:
[
  "ef4603a0e666d8cd9c6d39109bebc460f3de05a4037ac08e7ee40a74c95f6a00"
]
0.52 ms
(0.00%)
1
SELECT COUNT(v0_.`id`) AS sclr_0 FROM `visit` v0_ WHERE v0_.`token` = ? AND v0_.`url` <> '/.*catalog.*/'
Parameters:
[
  "ef4603a0e666d8cd9c6d39109bebc460f3de05a4037ac08e7ee40a74c95f6a00"
]
0.48 ms
(0.00%)
2
SELECT b0_.`id` AS id_0, b0_.`name` AS name_1, b0_.`descr` AS descr_2, b0_.`val` AS val_3 FROM `BoolDBSetting` b0_ WHERE b0_.`name` = ?
Parameters:
[
  "RTWidget"
]
0.37 ms
(0.00%)
1
SELECT b0_.`id` AS id_0 FROM `buy_order` b0_ WHERE b0_.`token` = ? AND b0_.`status` <> 12
Parameters:
[
  "ef4603a0e666d8cd9c6d39109bebc460f3de05a4037ac08e7ee40a74c95f6a00"
]
0.24 ms
(0.00%)
1
SELECT s0_.`code` AS code_0, s0_.`value` AS value_1, s0_.`link` AS link_2, s0_.`login` AS login_3, s0_.`token` AS token_4 FROM `social_stat` s0_ WHERE s0_.`locale` IS NULL OR s0_.`locale` = ?
Parameters:
[
  "en"
]

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\Publication No errors.
FlexApp\Entity\Exhibition\ExhEntity No errors.
WebBundle\Entity\LocaleUrlEntity 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.
WebBundle\Entity\LocaleTitleEntity No errors.
WebBundle\Entity\LocaleHtmlEntity No errors.
WebBundle\Entity\LocaleMetaEntity No errors.
WebBundle\Entity\LocalePreviewEntity No errors.
FlexApp\Entity\LikesEntity No errors.
FlexApp\Entity\Exhibition\ExhBrandEntity No errors.
WebBundle\Entity\LocaleBoolEntity No errors.
WebBundle\Entity\SocialStat No errors.
FlexApp\Entity\GeoCountryEntity No errors.
WebBundle\Entity\Collection No errors.
WebBundle\Entity\FilterEntity No errors.
WebBundle\Entity\Article No errors.
WebBundle\Entity\Visit No errors.
WebBundle\Entity\Idea No errors.
WebBundle\Entity\BuyOrder No errors.
WebBundle\Entity\OrderAddress No errors.
WebBundle\Entity\ListEmail No errors.
WebBundle\Entity\OrderHistory No errors.
WebBundle\Entity\OrderPayment No errors.
WebBundle\Entity\CurrencyRate No errors.
WebBundle\Entity\ListVat No errors.
WebBundle\Entity\WarehouseEntity No errors.
WebBundle\Entity\BuyOrderArticle No errors.
WebBundle\Entity\BuyOrderManager No errors.
FlexApp\Entity\InterviewEntity No errors.

oneC entity manager

No loaded entities.

logs entity manager

No loaded entities.