https://dev5.tile.expert/_fragment?_path=_format%3Dhtml%26_locale%3Den-it%26_controller%3DWebBundle%255CController%255CCommonController%253A%253AtopAction

Method
GET
HTTP Status
200
IP
216.73.216.0
Profiled on
Token
bcc902

Query Metrics

33 Database Queries
24 Different statements
26.83 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

default connection

Time▼ Count Info
12.64 ms
(0.00%) 		1 
SELECT f.id, f.rank AS `rank`, f.alt_name AS `altName`, f.old_command AS `sphinxName`, f.old_id AS `sphinxId`, htmlshow.en AS `isHtmlShow`, fp.name_menu_en AS `nameMenu`, fp.name_many_en AS `nameMany`, fp.name_single_en AS `nameSingle`, fp.html_en AS `html`, fp.description_en AS `description`, metadesc.en AS `metaDescriptionName`, par.count AS `count`, par.code AS `code`, par.is_enable AS `isEnable`, gr.id AS `groupId`, gr.alt_name AS `groupAltName`, gpname.en AS `groupName`, url.en AS `slug`, url.ru AS `slug.ru`, url.en AS `slug.en`, url.it AS `slug.it`, url.es AS `slug.es`, url.fr AS `slug.fr`, url.de AS `slug.de`, url.pl AS `slug.pl`, url.nl AS `slug.nl`, url.fi AS `slug.fi`, url.sv AS `slug.sv`, b.id AS `brandId`, b.status AS `brandStatus`, b.stated_at AS `brandStatedAt`, b.type AS `brandType`, b.name AS `brandName`, f.logo AS `brandLogo`, f.logo_url AS `brandLogoUrl`, b.sound AS `brandSound`, b.video AS `brandVideo`, cn.id AS `countryId`, cnfp.name_single_en AS `countryName`, cnurl.en AS `countrySlug`, cnpar.code AS `countryCode` FROM filters f LEFT JOIN filter_pages fp ON fp.id = f.page_id LEFT JOIN filter_params par ON par.id = f.param_id LEFT JOIN filter_groups gr ON gr.id = f.group_id LEFT JOIN locale_text gpname ON gpname.filter_group_name = gr.id LEFT JOIN locale_text metadesc ON metadesc.filter_name_for_meta_descr_id = f.id LEFT JOIN locale_url url ON url.filter_id = f.id LEFT JOIN locale_bool htmlshow ON htmlshow.filter_html_show_id = f.id LEFT JOIN factory b ON b.id = f.brand LEFT JOIN filters cn ON cn.id = f.country_id LEFT JOIN filter_pages cnfp ON cnfp.id = cn.page_id LEFT JOIN locale_url cnurl ON cnurl.filter_id = cn.id LEFT JOIN filter_params cnpar ON cnpar.id = cn.param_id WHERE url.ru = :slug OR url.en = :slug OR url.it = :slug OR url.es = :slug OR url.fr = :slug OR url.de = :slug OR url.pl = :slug OR url.nl = :slug OR url.fi = :slug OR url.sv = :slug
Parameters: 
[
  "slug" => "grespania"
]
View formatted query    View runnable query    Explain query
6.85 ms
(0.00%) 		2 
SELECT t0.`id` AS id_1, t0.`unid` AS unid_2, t0.`code` AS code_3, t0.`name` AS name_4, t0.`alternate_name` AS alternate_name_5, t0.`name_full` AS name_full_6, t0.`url` AS url_7, t0.`status` AS status_8, t0.`type` AS type_9, t0.`typeSet` AS typeSet_10, t0.`pc_as_m` AS pc_as_m_11, t0.`publish_date` AS publish_date_12, t0.`update_date` AS update_date_13, t0.`archive` AS archive_14, t0.`pr_min_euro` AS pr_min_euro_15, t0.`pr_min_euro_de` AS pr_min_euro_de_16, t0.`pr_min_euro_at` AS pr_min_euro_at_17, t0.`pr_min_euro_fi` AS pr_min_euro_fi_18, t0.`pr_min_euro_fr` AS pr_min_euro_fr_19, t0.`pr_min_euro_it` AS pr_min_euro_it_20, t0.`pr_min_euro_be` AS pr_min_euro_be_21, t0.`pr_min_euro_ie` AS pr_min_euro_ie_22, t0.`pr_min_euro_nl` AS pr_min_euro_nl_23, t0.`pr_min_euro_es` AS pr_min_euro_es_24, t0.`pr_min_rub` AS pr_min_rub_25, t0.`pr_min_rue` AS pr_min_rue_26, t0.`pr_min_gbp` AS pr_min_gbp_27, t0.`pr_min_gbe` AS pr_min_gbe_28, t0.`pr_min_usd` AS pr_min_usd_29, t0.`pr_min_use` AS pr_min_use_30, t0.`pr_min_f_usd` AS pr_min_f_usd_31, t0.`pr_min_f_use` AS pr_min_f_use_32, t0.`pr_min_chf` AS pr_min_chf_33, t0.`pr_min_che` AS pr_min_che_34, t0.`pr_min_sek` AS pr_min_sek_35, t0.`pr_min_see` AS pr_min_see_36, t0.`pr_min_dkk` AS pr_min_dkk_37, t0.`pr_min_dke` AS pr_min_dke_38, t0.`pr_min_nok` AS pr_min_nok_39, t0.`pr_min_noe` AS pr_min_noe_40, t0.`pr_min_pln` AS pr_min_pln_41, t0.`pr_min_ple` AS pr_min_ple_42, t0.`pr_min_cad` AS pr_min_cad_43, t0.`pr_min_cae` AS pr_min_cae_44, t0.`pr_min_f_cad` AS pr_min_f_cad_45, t0.`pr_min_f_cae` AS pr_min_f_cae_46, t0.`pr_min_ed` AS pr_min_ed_47, t0.`important` AS important_48, t0.`author` AS author_49, t0.`author_id` AS author_id_50, t0.`rating` AS rating_51, t0.`header` AS header_52, t0.`settings` AS settings_53, t0.`fids` AS fids_54, t0.`portal_unid` AS portal_unid_55, t0.`accepted_at` AS accepted_at_56, t0.`accept_state` AS accept_state_57, t0.`description_edit` AS description_edit_58, t0.`link_award` AS link_award_59, t0.`awards` AS awards_60, t0.`video` AS video_61, t0.`stated_at` AS stated_at_62, t0.`state` AS state_63, t0.`description_state` AS description_state_64, t0.`body_hide` AS body_hide_65, t0.`release_year` AS release_year_66, t0.`site` AS site_67, t0.`show_main` AS show_main_68, t0.`glue_url` AS glue_url_69, t0.`accessible` AS accessible_70, t0.`delivery_suspended` AS delivery_suspended_71, t0.`process` AS process_72, t0.`exhibition` AS exhibition_73, t0.`test_access` AS test_access_74, t0.`views` AS views_75, t0.`comment_unid` AS comment_unid_76, t0.`accesible_at` AS accesible_at_77, t0.`created_at` AS created_at_78, t0.`updated_at` AS updated_at_79, t0.factory AS factory_80, t0.category_price AS category_price_81, t82.`id` AS id_83, t82.`source` AS source_84, t82.`ru` AS ru_85, t82.`en` AS en_86, t82.`it` AS it_87, t82.`es` AS es_88, t82.`fr` AS fr_89, t82.`de` AS de_90, t82.`pl` AS pl_91, t82.`pt` AS pt_92, t82.`nl` AS nl_93, t82.`fi` AS fi_94, t82.`ua` AS ua_95, t82.`sv` AS sv_96, t82.`no` AS no_97, t82.`da` AS da_98, t82.`cn` AS cn_99, t82.`zh` AS zh_100, t82.`created_at` AS created_at_101, t82.`updated_at` AS updated_at_102, t82.email_body_id AS email_body_id_103, t82.publication_body_id AS publication_body_id_104, t82.static_page_body_id AS static_page_body_id_105, t82.collection_body_id AS collection_body_id_106, t82.trans_val_id AS trans_val_id_107, t82.exh_text_id AS exh_text_id_108, t82.exh_brand_text_id AS exh_brand_text_id_109, t82.exh_collection_text_id AS exh_collection_text_id_110, t82.filter_html_id AS filter_html_id_111, t112.`id` AS id_113, t112.`source` AS source_114, t112.`ru` AS ru_115, t112.`en` AS en_116, t112.`it` AS it_117, t112.`es` AS es_118, t112.`fr` AS fr_119, t112.`de` AS de_120, t112.`pl` AS pl_121, t112.`pt` AS pt_122, t112.`nl` AS nl_123, t112.`fi` AS fi_124, t112.`ua` AS ua_125, t112.`sv` AS sv_126, t112.`no` AS no_127, t112.`da` AS da_128, t112.`cn` AS cn_129, t112.`zh` AS zh_130, t112.`created_at` AS created_at_131, t112.`updated_at` AS updated_at_132, t112.static_page_title_id AS static_page_title_id_133, t112.static_page_keywords_id AS static_page_keywords_id_134, t112.static_page_description_id AS static_page_description_id_135, t112.collection_keywords_id AS collection_keywords_id_136, t112.collection_description_id AS collection_description_id_137, t112.blog_keywords_id AS blog_keywords_id_138, t112.blog_description_id AS blog_description_id_139, t112.exh_keywords_id AS exh_keywords_id_140, t112.exh_description_id AS exh_description_id_141, t142.`id` AS id_143, t142.`source` AS source_144, t142.`ru` AS ru_145, t142.`en` AS en_146, t142.`it` AS it_147, t142.`es` AS es_148, t142.`fr` AS fr_149, t142.`de` AS de_150, t142.`pl` AS pl_151, t142.`pt` AS pt_152, t142.`nl` AS nl_153, t142.`fi` AS fi_154, t142.`ua` AS ua_155, t142.`sv` AS sv_156, t142.`no` AS no_157, t142.`da` AS da_158, t142.`cn` AS cn_159, t142.`zh` AS zh_160, t142.`created_at` AS created_at_161, t142.`updated_at` AS updated_at_162, t142.static_page_title_id AS static_page_title_id_163, t142.static_page_keywords_id AS static_page_keywords_id_164, t142.static_page_description_id AS static_page_description_id_165, t142.collection_keywords_id AS collection_keywords_id_166, t142.collection_description_id AS collection_description_id_167, t142.blog_keywords_id AS blog_keywords_id_168, t142.blog_description_id AS blog_description_id_169, t142.exh_keywords_id AS exh_keywords_id_170, t142.exh_description_id AS exh_description_id_171 FROM `collection` t0 LEFT JOIN `locale_html` t82 ON t82.collection_body_id = t0.id LEFT JOIN `locale_meta` t112 ON t112.collection_keywords_id = t0.id LEFT JOIN `locale_meta` t142 ON t142.collection_description_id = t0.id WHERE t0.factory = ?
Parameters: 
[
  83448
]
View formatted query    View runnable query    Explain query
1.40 ms
(0.00%) 		2 
SELECT t0.`id` AS id_1, t0.`reviewId` AS reviewId_2, t0.`referenceId` AS referenceId_3, t0.`conversationId` AS conversationId_4, t0.`p_id` AS p_id_5, t0.`sku` AS sku_6, t0.`gtin` AS gtin_7, t0.`mpn` AS mpn_8, t0.`url` AS url_9, t0.`star` AS star_10, t0.`score` AS score_11, t0.`date` AS date_12, t0.`created_at` AS created_at_13, t0.`content` AS content_14, t0.`username` AS username_15, t0.`country` AS country_16, t0.`locale` AS locale_17, t0.`language` AS language_18, t0.`state` AS state_19, t0.`unid_theme` AS unid_theme_20, t0.`send_portal_date` AS send_portal_date_21, t0.`answer` AS answer_22, t0.`manager` AS manager_23, t0.`is_anonymous` AS is_anonymous_24, t0.`is_collection_review` AS is_collection_review_25, t0.article_id AS article_id_26, t0.collection_id AS collection_id_27, t0.order_id AS order_id_28, t0.user_id AS user_id_29 FROM `product_reviews_cache` t0 WHERE t0.collection_id IN (?)
Parameters: 
[
  [
    1428962
    1618562
    1618563
    2428528
    2460870
    2460871
    2507639
    2714365
    2723929
    3244607
    3244649
    3244654
    3244655
    3244685
    3244769
    3244770
    3244827
    3244842
    3244873
    3244900
    3245188
    3245248
    3245375
    3245376
    3245377
    3245378
    3245379
    3245674
    3245675
    3245676
    3245677
    3245678
    3245679
    3245680
    3245681
    3245701
    3245702
    3245703
    3245704
    3245705
    3245709
    3245710
    3245723
    3245843
    3245844
    3245845
    3245846
    3246105
    3246284
    3246337
    3246449
    3246450
    3246584
    3246662
    3247021
    3247135
    3247265
    3247270
    3247271
    3247277
    3247278
    3247279
    3247280
    3247300
    3247317
    3247396
    3247467
    3247495
    3247512
    3247577
    3247797
    3247876
    3247915
    3248339
    3248354
    3248355
    3248356
    3248357
    3248358
    3248359
    3248417
    3248436
    3248437
    3248522
    3248688
    3248756
    3248778
    3248966
    3248969
    3249019
    3249151
    3249152
    3249153
    3249154
    3249155
    3249156
    3249157
    3249177
    3251481
    3251484
    3251488
    3251521
    3251683
    3251935
    3253909
    3254482
    3255136
    3255310
    3255559
    3255805
    3255862
    3255889
    3256123
    3256126
  ]
]
View formatted query    View runnable query    Explain query
1.18 ms
(0.00%) 		1 
INSERT INTO `visit` (`token`, `url`, `title`, `icon`, `visit_date`, `v_type`, `v_object_id`) VALUES (?, ?, ?, ?, ?, ?, ?)
Parameters: 
[
  1 => "35e2d7357ae35aa3221f12fe517c13de"
  2 => "catalogue/grespania"
  3 => "Manufacturer Grespania"
  4 => "/img/histories/tile-catalogue.jpg?64"
  5 => "2025-10-22 20:58:16"
  6 => 5
  7 => 0
]
View formatted query    View runnable query    Explain query
0.82 ms
(0.00%) 		1 
SELECT p0_.`id` AS id_0, p0_.`reviewId` AS reviewId_1, p0_.`referenceId` AS referenceId_2, p0_.`conversationId` AS conversationId_3, p0_.`p_id` AS p_id_4, p0_.`sku` AS sku_5, p0_.`gtin` AS gtin_6, p0_.`mpn` AS mpn_7, p0_.`url` AS url_8, p0_.`star` AS star_9, p0_.`score` AS score_10, p0_.`date` AS date_11, p0_.`created_at` AS created_at_12, p0_.`content` AS content_13, p0_.`username` AS username_14, p0_.`country` AS country_15, p0_.`locale` AS locale_16, p0_.`language` AS language_17, p0_.`state` AS state_18, p0_.`unid_theme` AS unid_theme_19, p0_.`send_portal_date` AS send_portal_date_20, p0_.`answer` AS answer_21, p0_.`manager` AS manager_22, p0_.`is_anonymous` AS is_anonymous_23, p0_.`is_collection_review` AS is_collection_review_24 FROM `product_reviews_cache` p0_
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.49 ms
(0.00%) 		6 
SELECT
    f2.id,
    f2.name,
    f2.old_command,
    f2.old_id,
    GROUP_CONCAT(f.id) AS ids,
    GROUP_CONCAT(f.old_id) AS old_ids
FROM
    `filters` f
LEFT JOIN filters f2 ON
    f.parent_id = f2.id
LEFT JOIN filter_params p ON
    f.param_id = p.id
WHERE
    f.parent_id IS NOT NULL AND p.is_enable = 1  AND p.show_menu != 0  
GROUP BY
    f.parent_id;
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.48 ms
(0.00%) 		1 
SELECT f.id, f.rank AS `rank`, f.alt_name AS `altName`, f.old_command AS `sphinxName`, f.old_id AS `sphinxId`, htmlshow.en AS `isHtmlShow`, fp.name_menu_en AS `nameMenu`, fp.name_many_en AS `nameMany`, fp.name_single_en AS `nameSingle`, fp.html_en AS `html`, fp.description_en AS `description`, metadesc.en AS `metaDescriptionName`, par.count AS `count`, par.code AS `code`, par.is_enable AS `isEnable`, gr.id AS `groupId`, gr.alt_name AS `groupAltName`, gpname.en AS `groupName`, url.en AS `slug`, url.ru AS `slug.ru`, url.en AS `slug.en`, url.it AS `slug.it`, url.es AS `slug.es`, url.fr AS `slug.fr`, url.de AS `slug.de`, url.pl AS `slug.pl`, url.nl AS `slug.nl`, url.fi AS `slug.fi`, url.sv AS `slug.sv`, b.id AS `brandId`, b.status AS `brandStatus`, b.stated_at AS `brandStatedAt`, b.type AS `brandType`, b.name AS `brandName`, f.logo AS `brandLogo`, f.logo_url AS `brandLogoUrl`, b.sound AS `brandSound`, b.video AS `brandVideo`, cn.id AS `countryId`, cnfp.name_single_en AS `countryName`, cnurl.en AS `countrySlug`, cnpar.code AS `countryCode` FROM filters f LEFT JOIN filter_pages fp ON fp.id = f.page_id LEFT JOIN filter_params par ON par.id = f.param_id LEFT JOIN filter_groups gr ON gr.id = f.group_id LEFT JOIN locale_text gpname ON gpname.filter_group_name = gr.id LEFT JOIN locale_text metadesc ON metadesc.filter_name_for_meta_descr_id = f.id LEFT JOIN locale_url url ON url.filter_id = f.id LEFT JOIN locale_bool htmlshow ON htmlshow.filter_html_show_id = f.id LEFT JOIN factory b ON b.id = f.brand LEFT JOIN filters cn ON cn.id = f.country_id LEFT JOIN filter_pages cnfp ON cnfp.id = cn.page_id LEFT JOIN locale_url cnurl ON cnurl.filter_id = cn.id LEFT JOIN filter_params cnpar ON cnpar.id = cn.param_id WHERE f.id IN (?) ORDER BY gr.sort, f.sort
Parameters: 
[
  1 => 10359
]
View formatted query    View runnable query    Explain query
0.40 ms
(0.00%) 		1 
SELECT t0.`id` AS id_1, t0.`unid` AS unid_2, t0.`name` AS name_3, t0.`name_inv` AS name_inv_4, t0.`url` AS url_5, t0.`alternate_name` AS alternate_name_6, t0.`description_ru` AS description_ru_7, t0.`description_en` AS description_en_8, t0.`description_it` AS description_it_9, t0.`description_es` AS description_es_10, t0.`description_fr` AS description_fr_11, t0.`description_de` AS description_de_12, t0.`description_pt` AS description_pt_13, t0.`description_pl` AS description_pl_14, t0.`description_nl` AS description_nl_15, t0.`description_fi` AS description_fi_16, t0.`description_ua` AS description_ua_17, t0.`description_sv` AS description_sv_18, t0.`description_no` AS description_no_19, t0.`description_da` AS description_da_20, t0.`description_zh` AS description_zh_21, t0.`delivery_time` AS delivery_time_22, t0.`not_regular` AS not_regular_23, t0.`suspended` AS suspended_24, t0.`status` AS status_25, t0.`type` AS type_26, t0.`discount` AS discount_27, t0.`discount_date_start` AS discount_date_start_28, t0.`discount_date_end` AS discount_date_end_29, t0.`transcription` AS transcription_30, t0.`cost_delivery` AS cost_delivery_31, t0.`create_date` AS create_date_32, t0.`is_accepted` AS is_accepted_33, t0.`accepted_at` AS accepted_at_34, t0.`accept_state` AS accept_state_35, t0.`description_edit` AS description_edit_36, t0.`stated_at` AS stated_at_37, t0.`state` AS state_38, t0.`description_state` AS description_state_39, t0.`video` AS video_40, t0.`parser_address` AS parser_address_41, t0.`accessible` AS accessible_42, t0.`sound` AS sound_43, t0.`test_access` AS test_access_44, t0.`total_ideas` AS total_ideas_45, t0.`votes_submit` AS votes_submit_46, t0.`votes_stars` AS votes_stars_47, t0.`brand_link` AS brand_link_48, t0.`brand_logo` AS brand_logo_49, t0.`no_send_portl_message` AS no_send_portl_message_50, t0.user_id AS user_id_51, t0.country AS country_52, t0.filter AS filter_53 FROM `factory` t0 WHERE t0.`url` = ? LIMIT 1
Parameters: 
[
  "grespania"
]
View formatted query    View runnable query    Explain query
0.38 ms
(0.00%) 		1 
SELECT v0_.`id` AS id_0, v0_.`token` AS token_1, v0_.`url` AS url_2, v0_.`title` AS title_3, v0_.`icon` AS icon_4, v0_.`visit_date` AS visit_date_5, v0_.`v_type` AS v_type_6, v0_.`v_object_id` AS v_object_id_7 FROM `visit` v0_ WHERE v0_.`token` = ? AND v0_.`url` = ? AND v0_.`url` <> '/.*catalog.*/' LIMIT 1
Parameters: 
[
  "35e2d7357ae35aa3221f12fe517c13de8a951dd16702a40799345e00ea90e2c7"
  "catalogue/grespania"
]
View formatted query    View runnable query    Explain query
0.30 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: 
[
  "35e2d7357ae35aa3221f12fe517c13de8a951dd16702a40799345e00ea90e2c7"
]
View formatted query    View runnable query    Explain query
0.25 ms
(0.00%) 		1 
SELECT COUNT(v0_.`id`) AS sclr_0 FROM `visit` v0_ WHERE v0_.`token` = ? AND v0_.`url` <> '/.*catalog.*/'
Parameters: 
[
  "35e2d7357ae35aa3221f12fe517c13de8a951dd16702a40799345e00ea90e2c7"
]
View formatted query    View runnable query    Explain query
0.25 ms
(0.00%) 		2 
SELECT
    f2.id,
    f2.name,
    f2.old_command,
    f2.old_id,
    GROUP_CONCAT(f.id) AS ids,
    GROUP_CONCAT(f.old_id) AS old_ids
FROM
    `filters` f
LEFT JOIN filters f2 ON
    f.parent_id = f2.id
LEFT JOIN filter_params p ON
    f.param_id = p.id
WHERE
    f.parent_id IS NOT NULL AND p.is_enable = 1  AND p.show_menu_advanced != 0 
GROUP BY
    f.parent_id;
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.22 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"
]
View formatted query    View runnable query    Explain query
0.19 ms
(0.00%) 		1 
SELECT i0_.`id` AS id_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` = ? GROUP BY i0_.`id`
Parameters: 
[
  "35e2d7357ae35aa3221f12fe517c13de8a951dd16702a40799345e00ea90e2c7"
]
View formatted query    View runnable query    Explain query
0.13 ms
(0.00%) 		1 
SELECT t0.`id` AS id_1, t0.`unid` AS unid_2, t0.`name` AS name_3, t0.`name_inv` AS name_inv_4, t0.`url` AS url_5, t0.`alternate_name` AS alternate_name_6, t0.`description_ru` AS description_ru_7, t0.`description_en` AS description_en_8, t0.`description_it` AS description_it_9, t0.`description_es` AS description_es_10, t0.`description_fr` AS description_fr_11, t0.`description_de` AS description_de_12, t0.`description_pt` AS description_pt_13, t0.`description_pl` AS description_pl_14, t0.`description_nl` AS description_nl_15, t0.`description_fi` AS description_fi_16, t0.`description_ua` AS description_ua_17, t0.`description_sv` AS description_sv_18, t0.`description_no` AS description_no_19, t0.`description_da` AS description_da_20, t0.`description_zh` AS description_zh_21, t0.`delivery_time` AS delivery_time_22, t0.`not_regular` AS not_regular_23, t0.`suspended` AS suspended_24, t0.`status` AS status_25, t0.`type` AS type_26, t0.`discount` AS discount_27, t0.`discount_date_start` AS discount_date_start_28, t0.`discount_date_end` AS discount_date_end_29, t0.`transcription` AS transcription_30, t0.`cost_delivery` AS cost_delivery_31, t0.`create_date` AS create_date_32, t0.`is_accepted` AS is_accepted_33, t0.`accepted_at` AS accepted_at_34, t0.`accept_state` AS accept_state_35, t0.`description_edit` AS description_edit_36, t0.`stated_at` AS stated_at_37, t0.`state` AS state_38, t0.`description_state` AS description_state_39, t0.`video` AS video_40, t0.`parser_address` AS parser_address_41, t0.`accessible` AS accessible_42, t0.`sound` AS sound_43, t0.`test_access` AS test_access_44, t0.`total_ideas` AS total_ideas_45, t0.`votes_submit` AS votes_submit_46, t0.`votes_stars` AS votes_stars_47, t0.`brand_link` AS brand_link_48, t0.`brand_logo` AS brand_logo_49, t0.`no_send_portl_message` AS no_send_portl_message_50, t0.user_id AS user_id_51, t0.country AS country_52, t0.filter AS filter_53 FROM `factory` t0 WHERE t0.`id` = ?
Parameters: 
[
  83448
]
View formatted query    View runnable query    Explain query
0.12 ms
(0.00%) 		1 
SELECT f0_.`old_id` AS old_id_0, f1_.`name_single_en` AS name_single_en_1, f1_.`name_menu_en` AS name_menu_en_2 FROM `filters` f0_ LEFT JOIN `filter_pages` f1_ ON f0_.page_id = f1_.id LEFT JOIN `filter_groups` f2_ ON f0_.group_id = f2_.id WHERE f2_.`id` = 407 ORDER BY f0_.`sort` ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.12 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: 
[
  "35e2d7357ae35aa3221f12fe517c13de8a951dd16702a40799345e00ea90e2c7"
]
View formatted query    View runnable query    Explain query
0.12 ms
(0.00%) 		1 
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: 
[
  "it"
]
View formatted query    View runnable query    Explain query
0.09 ms
(0.00%) 		1 
SELECT t0.`id` AS id_1, t0.`name` AS name_2, t0.`alias` AS alias_3, t0.`sort` AS sort_4, t0.`count` AS count_5, t0.`hide` AS hide_6, t0.`important` AS important_7 FROM `list_measure` t0 WHERE t0.`hide` = ?
Parameters: 
[
  0
]
View formatted query    View runnable query    Explain query
0.09 ms
(0.00%) 		1 
"COMMIT"
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.09 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: 
[
  "35e2d7357ae35aa3221f12fe517c13de8a951dd16702a40799345e00ea90e2c7"
]
View formatted query    View runnable query    Explain query
0.08 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: 
[
  "35e2d7357ae35aa3221f12fe517c13de8a951dd16702a40799345e00ea90e2c7"
]
View formatted query    View runnable query    Explain query
0.08 ms
(0.00%) 		1 
SELECT b0_.`id` AS id_0 FROM `buy_order` b0_ WHERE b0_.`token` = ? AND b0_.`status` <> 12
Parameters: 
[
  "35e2d7357ae35aa3221f12fe517c13de8a951dd16702a40799345e00ea90e2c7"
]
View formatted query    View runnable query    Explain query
0.07 ms
(0.00%) 		1 
"START TRANSACTION"
Parameters: 
[]
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\Publication No errors.
WebBundle\Entity\FilterEntity No errors.
WebBundle\Entity\Collection No errors.
WebBundle\Entity\Factory No errors.
WebBundle\Entity\ListMeasure No errors.
WebBundle\Entity\ListMaterial No errors.
WebBundle\Entity\ProductReviewsCache No errors.
WebBundle\Entity\ReviewsCache No errors.
WebBundle\Entity\ListCountry No errors.
WebBundle\Entity\Article No errors.
WebBundle\Entity\Interior No errors.
WebBundle\Entity\Idea No errors.
WebBundle\Entity\CollectionAlsoViewed No errors.
WebBundle\Entity\InteriorHistory 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.
WebBundle\Entity\FactoryUser No errors.
WebBundle\Entity\ListBrandParser No errors.
FlexApp\Entity\Exhibition\ExhBrandEntity No errors.
WebBundle\Entity\CheckList No errors.
WebBundle\Entity\ListPrice No errors.
WebBundle\Entity\LocaleHtmlEntity No errors.
WebBundle\Entity\ListEmail No errors.
WebBundle\Entity\StaticPageEntity No errors.
WebBundle\Entity\TransEntity No errors.
FlexApp\Entity\Exhibition\ExhEntity No errors.
FlexApp\Entity\Exhibition\ExhCollectionEntity No errors.
WebBundle\Entity\LocaleMetaEntity No errors.
WebBundle\Entity\BuyOrderArticle No errors.
WebBundle\Entity\BuyOrder No errors.
WebBundle\Entity\Visit No errors.
WebBundle\Entity\OrderAddress 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\BuyOrderManager No errors.
FlexApp\Entity\InterviewEntity No errors.

oneC entity manager

No loaded entities.

logs entity manager

No loaded entities.