Query Metrics
25
Database Queries
15
Different statements
25.85 ms
Query time
0
Invalid entities
Queries
default connection
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.27 ms |
SELECT l0_.`id` AS id_0, l0_.`code` AS code_1, l0_.`locale` AS locale_2, l0_.`phone_code` AS phone_code_3, l0_.`phone_mask` AS phone_mask_4, l0_.`min_valid_phone_numbers` AS min_valid_phone_numbers_5, l0_.`zip_code_mask` AS zip_code_mask_6, l0_.`percent_vat` AS percent_vat_7, l0_.`name` AS name_8, l0_.`name_en` AS name_en_9, l0_.`alias` AS alias_10, l0_.`sort` AS sort_11, l0_.`count` AS count_12, l0_.`hide` AS hide_13, l0_.`important` AS important_14, l0_.`pay_pal_percent` AS pay_pal_percent_15, l0_.`pay_pal_percent_own` AS pay_pal_percent_own_16, l0_.`vat` AS vat_17, l0_.`pv_type` AS pv_type_18, l0_.`capital_timezone_diff` AS capital_timezone_diff_19, l0_.`capital` AS capital_20, l0_.`free_sample_delivery` AS free_sample_delivery_21, l0_.`units` AS units_22 FROM `list_country` l0_ WHERE l0_.`hide` <> 1 ORDER BY l0_.`code` ASC
Parameters:
[] |
| 2 | 0.66 ms |
SELECT t0.`id` AS id_1, t0.`code` AS code_2, t0.`locale` AS locale_3, t0.`phone_code` AS phone_code_4, t0.`phone_mask` AS phone_mask_5, t0.`min_valid_phone_numbers` AS min_valid_phone_numbers_6, t0.`zip_code_mask` AS zip_code_mask_7, t0.`percent_vat` AS percent_vat_8, t0.`name` AS name_9, t0.`name_en` AS name_en_10, t0.`alias` AS alias_11, t0.`sort` AS sort_12, t0.`count` AS count_13, t0.`hide` AS hide_14, t0.`important` AS important_15, t0.`pay_pal_percent` AS pay_pal_percent_16, t0.`pay_pal_percent_own` AS pay_pal_percent_own_17, t0.`vat` AS vat_18, t0.`pv_type` AS pv_type_19, t0.`capital_timezone_diff` AS capital_timezone_diff_20, t0.`capital` AS capital_21, t0.`free_sample_delivery` AS free_sample_delivery_22, t0.`units` AS units_23 FROM `list_country` t0 WHERE t0.`id` = ?
Parameters:
[
233
]
|
| 3 | 0.28 ms |
SELECT c0_.`id` AS id_0, c0_.`special_date_start` AS special_date_start_1, c0_.`special_date_end` AS special_date_end_2, c0_.`is_working` AS is_working_3, c0_.`mode` AS mode_4, c0_.`mode_holiday` AS mode_holiday_5, c0_.`lang` AS lang_6, c0_.`timeZoneName` AS timeZoneName_7, c0_.country_id AS country_id_8, c0_.blog_id AS blog_id_9 FROM `calendar` c0_ WHERE c0_.`special_date_start` <= ? AND c0_.`special_date_end` >= ? AND c0_.`is_working` = ? AND c0_.country_id = ? ORDER BY c0_.`special_date_start` ASC LIMIT 100
Parameters:
[ "2025-09-03" "2025-08-03" 2 233 ] |
| 4 | 0.18 ms |
SELECT c0_.`id` AS id_0, c0_.`special_date_start` AS special_date_start_1, c0_.`special_date_end` AS special_date_end_2, c0_.`is_working` AS is_working_3, c0_.`mode` AS mode_4, c0_.`mode_holiday` AS mode_holiday_5, c0_.`lang` AS lang_6, c0_.`timeZoneName` AS timeZoneName_7, c0_.country_id AS country_id_8, c0_.blog_id AS blog_id_9 FROM `calendar` c0_ WHERE c0_.`special_date_start` <= ? AND c0_.`special_date_end` >= ? AND c0_.`is_working` = ? AND (c0_.country_id IS NULL OR c0_.country_id = 0 OR c0_.country_id = 'en') ORDER BY c0_.`special_date_start` ASC LIMIT 100
Parameters:
[ "2025-09-03" "2025-08-03" 2 ] |
| 5 | 1.44 ms |
SELECT t0.`id` AS id_1, t0.`lang` AS lang_2, t0.`start_day` AS start_day_3, t0.`end_day` AS end_day_4, t0.`start_hour` AS start_hour_5, t0.`end_hour` AS end_hour_6, t0.`phone` AS phone_7, t0.`email` AS email_8, t0.`twilio_id` AS twilio_id_9, t0.`work_days` AS work_days_10, t0.country_id AS country_id_11 FROM `country_and_lang_specific_data` t0 WHERE t0.`lang` = ? AND t0.country_id = ? LIMIT 1
Parameters:
[ "en" 233 ] |
| 6 | 0.99 ms |
SELECT t0.`id` AS id_1, t0.`unid` AS unid_2, t0.`corporate_unid` AS corporate_unid_3, t0.`token` AS token_4, t0.`is_active` AS is_active_5, t0.`proved` AS proved_6, t0.`alias` AS alias_7, t0.`foreign_alias` AS foreign_alias_8, t0.`lotus_name` AS lotus_name_9, t0.`password` AS password_10, t0.`expired` AS expired_11, t0.`expires_at` AS expires_at_12, t0.`credentials_expired` AS credentials_expired_13, t0.`credentials_expire_at` AS credentials_expire_at_14, t0.`last_ip` AS last_ip_15, t0.`source` AS source_16, t0.`social_network` AS social_network_17, t0.`social_network_id` AS social_network_id_18, t0.`google_id` AS google_id_19, t0.`fb_id` AS fb_id_20, t0.`vk_id` AS vk_id_21, t0.`ig_id` AS ig_id_22, t0.`test` AS test_23, t0.`token_fixed` AS token_fixed_24, t0.`bid` AS bid_25, t0.`email` AS email_26, t0.`salt` AS salt_27, t0.`review_request_sent` AS review_request_sent_28, t0.`username` AS username_29, t0.`roles` AS roles_30, t0.`enabled` AS enabled_31, t0.`confirmation_token` AS confirmation_token_32, t0.`last_login` AS last_login_33, t0.`password_requested_at` AS password_requested_at_34, t0.`security_field` AS security_field_35, t0.`created_at` AS created_at_36, t0.`is_legal_entity` AS is_legal_entity_37, t0.`companyName` AS companyName_38, t0.`vatNumber` AS vatNumber_39, t0.`lang` AS lang_40 FROM `user` t0 WHERE t0.`token` = ? LIMIT 1
Parameters:
[
"391f6277f0a1e21e775fe13ffb15706be795621762d24084985acf7a3eb1fcb4"
]
|
| 7 | 1.64 ms |
SELECT l0_.`id` AS id_0, l0_.`code` AS code_1, l0_.`locale` AS locale_2, l0_.`phone_code` AS phone_code_3, l0_.`phone_mask` AS phone_mask_4, l0_.`min_valid_phone_numbers` AS min_valid_phone_numbers_5, l0_.`zip_code_mask` AS zip_code_mask_6, l0_.`percent_vat` AS percent_vat_7, l0_.`name` AS name_8, l0_.`name_en` AS name_en_9, l0_.`alias` AS alias_10, l0_.`sort` AS sort_11, l0_.`count` AS count_12, l0_.`hide` AS hide_13, l0_.`important` AS important_14, l0_.`pay_pal_percent` AS pay_pal_percent_15, l0_.`pay_pal_percent_own` AS pay_pal_percent_own_16, l0_.`vat` AS vat_17, l0_.`pv_type` AS pv_type_18, l0_.`capital_timezone_diff` AS capital_timezone_diff_19, l0_.`capital` AS capital_20, l0_.`free_sample_delivery` AS free_sample_delivery_21, l0_.`units` AS units_22 FROM `list_country` l0_ WHERE l0_.`code` = ? OR l0_.`id` = ? LIMIT 1
Parameters:
[ "ee" "ee" ] |
| 8 | 4.64 ms |
SELECT t0.`id` AS id_1, t0.`portal_login` AS portal_login_2, t0.`ava_file_name` AS ava_file_name_3, t0.`name_for_chat` AS name_for_chat_4, t0.`email` AS email_5, t0.`sex` AS sex_6 FROM `consultant` t0 WHERE t0.`portal_login` = ? LIMIT 1
Parameters:
[
"amakarkin11920"
]
|
| 9 | 3.50 ms |
SELECT t0.`id` AS id_1, t0.`lang` AS lang_2, t0.`start_day` AS start_day_3, t0.`end_day` AS end_day_4, t0.`start_hour` AS start_hour_5, t0.`end_hour` AS end_hour_6, t0.`phone` AS phone_7, t0.`email` AS email_8, t0.`twilio_id` AS twilio_id_9, t0.`work_days` AS work_days_10, t0.country_id AS country_id_11 FROM `country_and_lang_specific_data` t0 WHERE t0.`lang` = ? AND t0.country_id = ? LIMIT 1
Parameters:
[ "en" 233 ] |
| 10 | 0.24 ms |
SELECT t0.`id` AS id_1, t0.`unid` AS unid_2, t0.`corporate_unid` AS corporate_unid_3, t0.`token` AS token_4, t0.`is_active` AS is_active_5, t0.`proved` AS proved_6, t0.`alias` AS alias_7, t0.`foreign_alias` AS foreign_alias_8, t0.`lotus_name` AS lotus_name_9, t0.`password` AS password_10, t0.`expired` AS expired_11, t0.`expires_at` AS expires_at_12, t0.`credentials_expired` AS credentials_expired_13, t0.`credentials_expire_at` AS credentials_expire_at_14, t0.`last_ip` AS last_ip_15, t0.`source` AS source_16, t0.`social_network` AS social_network_17, t0.`social_network_id` AS social_network_id_18, t0.`google_id` AS google_id_19, t0.`fb_id` AS fb_id_20, t0.`vk_id` AS vk_id_21, t0.`ig_id` AS ig_id_22, t0.`test` AS test_23, t0.`token_fixed` AS token_fixed_24, t0.`bid` AS bid_25, t0.`email` AS email_26, t0.`salt` AS salt_27, t0.`review_request_sent` AS review_request_sent_28, t0.`username` AS username_29, t0.`roles` AS roles_30, t0.`enabled` AS enabled_31, t0.`confirmation_token` AS confirmation_token_32, t0.`last_login` AS last_login_33, t0.`password_requested_at` AS password_requested_at_34, t0.`security_field` AS security_field_35, t0.`created_at` AS created_at_36, t0.`is_legal_entity` AS is_legal_entity_37, t0.`companyName` AS companyName_38, t0.`vatNumber` AS vatNumber_39, t0.`lang` AS lang_40 FROM `user` t0 WHERE t0.`token` = ? LIMIT 1
Parameters:
[
"391f6277f0a1e21e775fe13ffb15706be795621762d24084985acf7a3eb1fcb4"
]
|
| 11 | 0.53 ms |
SELECT l0_.`id` AS id_0, l0_.`code` AS code_1, l0_.`locale` AS locale_2, l0_.`phone_code` AS phone_code_3, l0_.`phone_mask` AS phone_mask_4, l0_.`min_valid_phone_numbers` AS min_valid_phone_numbers_5, l0_.`zip_code_mask` AS zip_code_mask_6, l0_.`percent_vat` AS percent_vat_7, l0_.`name` AS name_8, l0_.`name_en` AS name_en_9, l0_.`alias` AS alias_10, l0_.`sort` AS sort_11, l0_.`count` AS count_12, l0_.`hide` AS hide_13, l0_.`important` AS important_14, l0_.`pay_pal_percent` AS pay_pal_percent_15, l0_.`pay_pal_percent_own` AS pay_pal_percent_own_16, l0_.`vat` AS vat_17, l0_.`pv_type` AS pv_type_18, l0_.`capital_timezone_diff` AS capital_timezone_diff_19, l0_.`capital` AS capital_20, l0_.`free_sample_delivery` AS free_sample_delivery_21, l0_.`units` AS units_22 FROM `list_country` l0_ WHERE l0_.`code` = ? OR l0_.`id` = ? LIMIT 1
Parameters:
[ "ee" "ee" ] |
| 12 | 0.23 ms |
SELECT t0.`id` AS id_1, t0.`portal_login` AS portal_login_2, t0.`ava_file_name` AS ava_file_name_3, t0.`name_for_chat` AS name_for_chat_4, t0.`email` AS email_5, t0.`sex` AS sex_6 FROM `consultant` t0 WHERE t0.`portal_login` = ? LIMIT 1
Parameters:
[
"amakarkin11920"
]
|
| 13 | 0.14 ms |
SELECT t0.`id` AS id_1, t0.`lang` AS lang_2, t0.`start_day` AS start_day_3, t0.`end_day` AS end_day_4, t0.`start_hour` AS start_hour_5, t0.`end_hour` AS end_hour_6, t0.`phone` AS phone_7, t0.`email` AS email_8, t0.`twilio_id` AS twilio_id_9, t0.`work_days` AS work_days_10, t0.country_id AS country_id_11 FROM `country_and_lang_specific_data` t0 WHERE t0.`lang` = ? AND t0.country_id = ? LIMIT 1
Parameters:
[ "en" 233 ] |
| 14 | 0.64 ms |
SELECT c0_.`id` AS id_0, c0_.`special_date_start` AS special_date_start_1, c0_.`special_date_end` AS special_date_end_2, c0_.`is_working` AS is_working_3, c0_.`mode` AS mode_4, c0_.`mode_holiday` AS mode_holiday_5, c0_.`lang` AS lang_6, c0_.`timeZoneName` AS timeZoneName_7, c0_.country_id AS country_id_8, c0_.blog_id AS blog_id_9 FROM `calendar` c0_ WHERE c0_.`special_date_start` <= ? AND c0_.`special_date_end` >= ? AND c0_.`is_working` = ? AND c0_.country_id = ? ORDER BY c0_.`special_date_start` ASC LIMIT 100
Parameters:
[ "2025-09-03" "2025-08-03" 2 233 ] |
| 15 | 0.19 ms |
SELECT c0_.`id` AS id_0, c0_.`special_date_start` AS special_date_start_1, c0_.`special_date_end` AS special_date_end_2, c0_.`is_working` AS is_working_3, c0_.`mode` AS mode_4, c0_.`mode_holiday` AS mode_holiday_5, c0_.`lang` AS lang_6, c0_.`timeZoneName` AS timeZoneName_7, c0_.country_id AS country_id_8, c0_.blog_id AS blog_id_9 FROM `calendar` c0_ WHERE c0_.`special_date_start` <= ? AND c0_.`special_date_end` >= ? AND c0_.`is_working` = ? AND (c0_.country_id IS NULL OR c0_.country_id = 0 OR c0_.country_id = 'en') ORDER BY c0_.`special_date_start` ASC LIMIT 100
Parameters:
[ "2025-09-03" "2025-08-03" 2 ] |
| 16 | 0.34 ms |
SELECT c0_.`id` AS id_0, c0_.`special_date_start` AS special_date_start_1, c0_.`special_date_end` AS special_date_end_2, c0_.`is_working` AS is_working_3, c0_.`mode` AS mode_4, c0_.`mode_holiday` AS mode_holiday_5, c0_.`lang` AS lang_6, c0_.`timeZoneName` AS timeZoneName_7, c0_.country_id AS country_id_8, c0_.blog_id AS blog_id_9 FROM `calendar` c0_ WHERE c0_.`special_date_start` <= ? AND c0_.`special_date_end` >= ? AND c0_.`is_working` = ? AND c0_.country_id = ? ORDER BY c0_.`special_date_start` ASC LIMIT 100
Parameters:
[ "2025-09-03" "2025-08-03" 3 233 ] |
| 17 | 0.20 ms |
SELECT c0_.`id` AS id_0, c0_.`special_date_start` AS special_date_start_1, c0_.`special_date_end` AS special_date_end_2, c0_.`is_working` AS is_working_3, c0_.`mode` AS mode_4, c0_.`mode_holiday` AS mode_holiday_5, c0_.`lang` AS lang_6, c0_.`timeZoneName` AS timeZoneName_7, c0_.country_id AS country_id_8, c0_.blog_id AS blog_id_9 FROM `calendar` c0_ WHERE c0_.`special_date_start` <= ? AND c0_.`special_date_end` >= ? AND c0_.`is_working` = ? AND (c0_.country_id IS NULL OR c0_.country_id = 0 OR c0_.country_id = 'en') ORDER BY c0_.`special_date_start` ASC LIMIT 100
Parameters:
[ "2025-09-03" "2025-08-03" 3 ] |
| 18 | 0.53 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:
[
"391f6277f0a1e21e775fe13ffb15706be795621762d24084985acf7a3eb1fcb4"
]
|
| 19 | 0.19 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:
[
"391f6277f0a1e21e775fe13ffb15706be795621762d24084985acf7a3eb1fcb4"
]
|
| 20 | 0.17 ms |
SELECT b0_.`id` AS id_0 FROM `buy_order` b0_ WHERE b0_.`token` = ? AND b0_.`status` <> 12
Parameters:
[
"391f6277f0a1e21e775fe13ffb15706be795621762d24084985acf7a3eb1fcb4"
]
|
| 21 | 0.37 ms |
SELECT COUNT(v0_.`id`) AS sclr_0 FROM `visit` v0_ WHERE v0_.`token` = ? AND v0_.`url` <> '/.*catalog.*/'
Parameters:
[
"391f6277f0a1e21e775fe13ffb15706be795621762d24084985acf7a3eb1fcb4"
]
|
| 22 | 0.15 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:
[
"391f6277f0a1e21e775fe13ffb15706be795621762d24084985acf7a3eb1fcb4"
]
|
| 23 | 0.25 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"
]
|
| 24 | 0.30 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:
[
"391f6277f0a1e21e775fe13ffb15706be795621762d24084985acf7a3eb1fcb4"
]
|
| 25 | 7.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"
]
|
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\ListState | No errors. |
| WebBundle\Entity\Calendar | 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.