Query Metrics
9
Database Queries
8
Different statements
51.79 ms
Query time
0
Invalid entities
Queries
default connection
| #▲ | Time | Info |
|---|---|---|
| 1 | 7.98 ms |
SELECT s0_.`id` AS id_0, s0_.`name` AS name_1, s0_.`url` AS url_2, s0_.`enable` AS enable_3, s0_.`vars` AS vars_4, s0_.`created_at` AS created_at_5, s0_.`updated_at` AS updated_at_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_.`source` AS source_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, l8_.`id` AS id_147, l8_.`source` AS source_148, l8_.`ru` AS ru_149, l8_.`en` AS en_150, l8_.`it` AS it_151, l8_.`es` AS es_152, l8_.`fr` AS fr_153, l8_.`de` AS de_154, l8_.`pl` AS pl_155, l8_.`pt` AS pt_156, l8_.`nl` AS nl_157, l8_.`fi` AS fi_158, l8_.`ua` AS ua_159, l8_.`sv` AS sv_160, l8_.`no` AS no_161, l8_.`da` AS da_162, l8_.`usa` AS usa_163, l8_.`cn` AS cn_164, l8_.`zh` AS zh_165, l8_.`created_at` AS created_at_166, l8_.`updated_at` AS updated_at_167 FROM `static_page` s0_ LEFT JOIN `locale_title` l1_ ON s0_.id = l1_.static_page_title_id LEFT JOIN `locale_html` l2_ ON s0_.id = l2_.static_page_body_id LEFT JOIN `locale_bool` l3_ ON s0_.id = l3_.static_page_status_show_id LEFT JOIN `locale_bool` l4_ ON s0_.id = l4_.static_page_comment_show_id LEFT JOIN `locale_meta` l5_ ON s0_.id = l5_.static_page_title_id LEFT JOIN `locale_meta` l6_ ON s0_.id = l6_.static_page_keywords_id LEFT JOIN `locale_meta` l7_ ON s0_.id = l7_.static_page_description_id LEFT JOIN `locale_text` l8_ ON s0_.id = l8_.static_page_unid_id WHERE s0_.`enable` = 1 AND s0_.`url` = ? AND l3_.`fr` = 1
Parameters:
[
"cookie-policy"
]
|
| 2 | 7.80 ms |
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:
[
"c8f161d7e1bb5b9f68406d52cf201f100bfb32795ec439341eaab7d24fe6e13e"
]
|
| 3 | 4.22 ms |
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:
[
"c8f161d7e1bb5b9f68406d52cf201f100bfb32795ec439341eaab7d24fe6e13e"
]
|
| 4 | 3.77 ms |
SELECT b0_.`id` AS id_0 FROM `buy_order` b0_ WHERE b0_.`token` = ? AND b0_.`status` <> 12
Parameters:
[
"c8f161d7e1bb5b9f68406d52cf201f100bfb32795ec439341eaab7d24fe6e13e"
]
|
| 5 | 3.62 ms |
SELECT COUNT(v0_.`id`) AS sclr_0 FROM `visit` v0_ WHERE v0_.`token` = ? AND v0_.`url` <> '/.*catalog.*/'
Parameters:
[
"c8f161d7e1bb5b9f68406d52cf201f100bfb32795ec439341eaab7d24fe6e13e"
]
|
| 6 | 3.74 ms |
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:
[
"c8f161d7e1bb5b9f68406d52cf201f100bfb32795ec439341eaab7d24fe6e13e"
]
|
| 7 | 2.75 ms |
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"
]
|
| 8 | 16.08 ms |
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:
[
"c8f161d7e1bb5b9f68406d52cf201f100bfb32795ec439341eaab7d24fe6e13e"
]
|
| 9 | 1.84 ms |
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"
]
|
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. |
| WebBundle\Entity\StaticPageEntity | No errors. |
| WebBundle\Entity\IdeasShare | No errors. |
| FlexApp\Entity\CountryAndLangSpecificDataEntity | No errors. |
| WebBundle\Entity\Factory | No errors. |
| FlexApp\Entity\ChatB | No errors. |
| FlexApp\Entity\ChatBMessage | No errors. |
| FlexApp\Entity\BoolDBSetting | No errors. |
| FlexApp\Entity\Widget | No errors. |
| FlexApp\Entity\ConsultantEntity | No errors. |
| WebBundle\Entity\LocaleTitleEntity | No errors. |
| WebBundle\Entity\LocaleHtmlEntity | No errors. |
| WebBundle\Entity\LocaleBoolEntity | No errors. |
| WebBundle\Entity\LocaleMetaEntity | No errors. |
| WebBundle\Entity\LocaleTextEntity | 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.