https://dev5.tile.expert/en-ca/docs/policy-personal-data-process

Method
GET
HTTP Status
200
IP
216.73.216.124
Profiled on
Token
4643f7

Query Metrics

15 Database Queries
13 Different statements
75.44 ms Query time
0 Invalid entities

Queries

Group similar statements

default connection

#▲ Time Info
1 0.55 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_.`en` = 1
Parameters: 
[
  "policy-personal-data-process"
]
View formatted query    View runnable query    Explain query
2 1.36 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: 
[
  "2c08a7c972d9256dd97f52bc17cd8c484ce9c9a6ee8b7398a04dcb75f08f21ad"
]
View formatted query    View runnable query    Explain query
3 0.65 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: 
[
  "2c08a7c972d9256dd97f52bc17cd8c484ce9c9a6ee8b7398a04dcb75f08f21ad"
]
View formatted query    View runnable query    Explain query
4 0.35 ms 
SELECT b0_.`id` AS id_0 FROM `buy_order` b0_ WHERE b0_.`token` = ? AND b0_.`status` <> 12
Parameters: 
[
  "2c08a7c972d9256dd97f52bc17cd8c484ce9c9a6ee8b7398a04dcb75f08f21ad"
]
View formatted query    View runnable query    Explain query
5 1.25 ms 
SELECT COUNT(v0_.`id`) AS sclr_0 FROM `visit` v0_ WHERE v0_.`token` = ? AND v0_.`url` <> '/.*catalog.*/'
Parameters: 
[
  "2c08a7c972d9256dd97f52bc17cd8c484ce9c9a6ee8b7398a04dcb75f08f21ad"
]
View formatted query    View runnable query    Explain query
6 0.78 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: 
[
  "2c08a7c972d9256dd97f52bc17cd8c484ce9c9a6ee8b7398a04dcb75f08f21ad"
]
View formatted query    View runnable query    Explain query
7 0.50 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"
]
View formatted query    View runnable query    Explain query
8 0.78 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: 
[
  "2c08a7c972d9256dd97f52bc17cd8c484ce9c9a6ee8b7398a04dcb75f08f21ad"
]
View formatted query    View runnable query    Explain query
9 0.24 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"
]
View formatted query    View runnable query    Explain query
10 0.32 ms 
SELECT f0_.`id` AS id_0 FROM `geo_country` g1_ LEFT JOIN factory_hide_countries f2_ ON g1_.id = f2_.country_id LEFT JOIN `factory` f0_ ON f0_.id = f2_.factory_id WHERE g1_.`code` = ?
Parameters: 
[
  "ca"
]
View formatted query    View runnable query    Explain query
11 65.28 ms 
SELECT c0_.`id` AS id_0, c0_.`url` AS url_1, c0_.`code` AS code_2, c0_.`name` AS name_3, c0_.`alternate_name` AS alternate_name_4, c0_.`name_full` AS name_full_5, f1_.`id` AS id_6, f1_.`url` AS url_7, f1_.`unid` AS unid_8, f2_.`id` AS id_9, f1_.`url` AS url_10, f1_.`name` AS name_11, (SELECT COUNT(p3_.`star`) AS sclr_13 FROM `product_reviews_cache` p3_ WHERE p3_.`sku` = c0_.`code`) AS sclr_12, (SELECT SUM(p4_.`star`) AS sclr_15 FROM `product_reviews_cache` p4_ WHERE p4_.`sku` = c0_.`code`) AS sclr_14 FROM `collection` c0_ INNER JOIN `factory` f1_ ON c0_.factory = f1_.id INNER JOIN `filters` f2_ ON f1_.filter = f2_.id INNER JOIN `list_country` l5_ ON f1_.country = l5_.id LEFT JOIN `locale_url` l6_ ON f2_.id = l6_.filter_id LEFT JOIN `filter_pages` f7_ ON f2_.page_id = f7_.id WHERE f1_.filter IS NOT NULL AND c0_.factory <> '' AND f1_.`status` = ? AND (c0_.`test_access` IS NULL OR c0_.`test_access` = 0) AND (f1_.`test_access` IS NULL OR f1_.`test_access` = 0) AND c0_.`status` = ? AND c0_.`status` = ? AND f1_.`status` = ? ORDER BY c0_.`id` ASC
Parameters: 
[
  1
  1
  1
  1
]
View formatted query    View runnable query    Explain query
12 0.25 ms 
SELECT COUNT(f0_.`id`) AS sclr_0 FROM `filters` f0_ LEFT JOIN `factory` f1_ ON f0_.brand = f1_.id LEFT JOIN `filter_params` f2_ ON f0_.param_id = f2_.id WHERE f0_.brand IS NOT NULL AND f0_.`id` <> 10639 AND f1_.`status` = ? AND f2_.`is_enable` = 1 AND f2_.`count` >= 0 AND f1_.`unid` IS NOT NULL AND f1_.`test_access` IS NULL ORDER BY f0_.`name` ASC
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query
13 0.22 ms 
SELECT
       			lu.en AS slug
            FROM
                publication p
            LEFT JOIN `locale_url` `lu` ON `lu`.publication_id = `p`.id
            LEFT JOIN `locale_bool` `lp` ON `lp`.blog_show_id = `p`.id
            LEFT JOIN `locale_status_translate` `lst` ON `lst`.publication_id = `p`.id
			WHERE p.id = 2232 AND lp.en = 1 AND lst.en = 1;
Parameters: 
[]
View formatted query    View runnable query    Explain query
14 1.28 ms 
SELECT f0_.`id` AS id_0, f0_.`old_command` AS old_command_1, f0_.`old_id` AS old_id_2, f0_.`left_menu` AS left_menu_3, f1_.`id` AS id_4, f0_.`important` AS important_5, l2_.`en` AS en_6, f3_.`name_menu_en` AS name_menu_en_7, f4_.`alt_name` AS alt_name_8, f5_.`count` AS count_9, f0_.`id` AS id_10, f0_.`name` AS name_11, f0_.`alt_name` AS alt_name_12, f0_.`left_menu` AS left_menu_13, f0_.`sort` AS sort_14, f0_.`important` AS important_15, f0_.`old_command` AS old_command_16, f0_.`old_id` AS old_id_17, f0_.`sub_key` AS sub_key_18, f0_.`parent_key` AS parent_key_19, f0_.`rank` AS rank_20, f0_.`icon` AS icon_21, f0_.`icon_url` AS icon_url_22, f0_.`logo` AS logo_23, f0_.`logo_url` AS logo_url_24, f0_.`created_at` AS created_at_25, f0_.`updated_at` AS updated_at_26, f6_.`id` AS id_27, f6_.`name` AS name_28, f6_.`alt_name` AS alt_name_29, f6_.`left_menu` AS left_menu_30, f6_.`sort` AS sort_31, f6_.`important` AS important_32, f6_.`old_command` AS old_command_33, f6_.`old_id` AS old_id_34, f6_.`sub_key` AS sub_key_35, f6_.`parent_key` AS parent_key_36, f6_.`rank` AS rank_37, f6_.`icon` AS icon_38, f6_.`icon_url` AS icon_url_39, f6_.`logo` AS logo_40, f6_.`logo_url` AS logo_url_41, f6_.`created_at` AS created_at_42, f6_.`updated_at` AS updated_at_43 FROM `filters` f0_ LEFT JOIN `locale_url` l2_ ON f0_.id = l2_.filter_id LEFT JOIN `filter_pages` f3_ ON f0_.page_id = f3_.id LEFT JOIN `filter_params` f5_ ON f0_.param_id = f5_.id LEFT JOIN `filter_groups` f4_ ON f0_.group_id = f4_.id LEFT JOIN `filters` f6_ ON f0_.country_id = f6_.id LEFT JOIN `filters` f1_ ON f0_.parent_id = f1_.id WHERE f5_.`is_enable` = 1 AND (f5_.`show_menu` = 1 OR f5_.`show_menu_advanced` = 1) AND l2_.`en` IS NOT NULL AND f5_.`count` > 0 AND f4_.`alt_name` IN (?) ORDER BY f0_.`sort` ASC, f0_.`name` ASC
Parameters: 
[
  [
    "effect"
    "style"
    "samples"
    "price"
    "color"
    "using"
    "brand"
  ]
]
View formatted query    View runnable query    Explain query
15 1.63 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"
]
View formatted query    View runnable query    Explain query

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.
WebBundle\Entity\TransExEntity No errors.
WebBundle\Entity\Participant No errors.
WebBundle\Entity\FactoryUser No errors.
WebBundle\Entity\ListState No errors.
WebBundle\Entity\Publication No errors.
WebBundle\Entity\ListBrandParser No errors.
FlexApp\Entity\Exhibition\ExhBrandEntity No errors.
WebBundle\Entity\CheckList No errors.
FlexApp\Entity\AttachmentEntity No errors.
FlexApp\Entity\Exhibition\ExhEntity No errors.
WebBundle\Entity\TransEntity No errors.
FlexApp\Entity\Exhibition\ExhCollectionEntity No errors.
WebBundle\Entity\Vacancy No errors.
FlexApp\Entity\Exhibition\ExhImageEntity No errors.
WebBundle\Entity\FilterGroupEntity No errors.
WebBundle\Entity\Calendar No errors.
FlexApp\Entity\GeoLocaleNameEntity No errors.
FlexApp\Entity\GeoRegionEntity No errors.
WebBundle\Entity\ListPrice No errors.
WebBundle\Entity\Interior No errors.
WebBundle\Entity\FilterPageEntity No errors.
WebBundle\Entity\FilterParamEntity No errors.
WebBundle\Entity\LocaleUrlEntity No errors.
FlexApp\Entity\Collection\CollectionEntity No errors.
WebBundle\Entity\ListType No errors.
WebBundle\Entity\ListMeasure No errors.
WebBundle\Entity\ListSurface No errors.
WebBundle\Entity\ListPRStatus No errors.
WebBundle\Entity\ListEdgeType No errors.
WebBundle\Entity\ListUsing No errors.
WebBundle\Entity\ListShape No errors.
WebBundle\Entity\ListMaterial No errors.
WebBundle\Entity\ListDelivery No errors.
WebBundle\Entity\ListSliding No errors.
WebBundle\Entity\ListOffShade No errors.
WebBundle\Entity\ListStyle No errors.
WebBundle\Entity\ListColor No errors.
WebBundle\Entity\ListFactoryColor No errors.
WebBundle\Entity\ListTexture No errors.
WebBundle\Entity\ListStoneTexture No errors.
WebBundle\Entity\ArticlePriceDiscount No errors.
WebBundle\Entity\InteriorArticle No errors.
WebBundle\Entity\InteriorArticleLogging No errors.
WebBundle\Entity\ListRepeatDraw No errors.
WebBundle\Entity\ListMotiv No errors.
WebBundle\Entity\ListMeasureSize No errors.
WebBundle\Entity\SampleEntity No errors.
WebBundle\Entity\ListSink No errors.
WebBundle\Entity\ListMethLaying No errors.
WebBundle\Entity\ArticleDetail No errors.
WebBundle\Entity\ListDraw No errors.
WebBundle\Entity\InteriorHistory No errors.
FlexApp\Entity\Mailing No errors.
WebBundle\Entity\BuyOrderDelivery No errors.
WebBundle\Entity\ListEmailGroup No errors.
WebBundle\Entity\ProductReviewsCache No errors.
WebBundle\Entity\BuyOrderArticleHoliday No errors.

oneC entity manager

No loaded entities.

logs entity manager

No loaded entities.