Query Metrics
5
Database Queries
5
Different statements
5.78 ms
Query time
0
Invalid entities
Queries
default connection
| #▲ | Time | Info |
|---|---|---|
| 1 | 5.37 ms |
SELECT c0_.`id` AS id_0, c0_.`unid` AS unid_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, c0_.`url` AS url_6, c0_.`status` AS status_7, c0_.`type` AS type_8, c0_.`typeSet` AS typeSet_9, c0_.`pc_as_m` AS pc_as_m_10, c0_.`publish_date` AS publish_date_11, c0_.`update_date` AS update_date_12, c0_.`archive` AS archive_13, c0_.`pr_min_euro` AS pr_min_euro_14, c0_.`pr_min_euro_de` AS pr_min_euro_de_15, c0_.`pr_min_euro_at` AS pr_min_euro_at_16, c0_.`pr_min_euro_fi` AS pr_min_euro_fi_17, c0_.`pr_min_euro_fr` AS pr_min_euro_fr_18, c0_.`pr_min_euro_it` AS pr_min_euro_it_19, c0_.`pr_min_euro_be` AS pr_min_euro_be_20, c0_.`pr_min_euro_ie` AS pr_min_euro_ie_21, c0_.`pr_min_euro_nl` AS pr_min_euro_nl_22, c0_.`pr_min_euro_es` AS pr_min_euro_es_23, c0_.`pr_min_rub` AS pr_min_rub_24, c0_.`pr_min_rue` AS pr_min_rue_25, c0_.`pr_min_gbp` AS pr_min_gbp_26, c0_.`pr_min_gbe` AS pr_min_gbe_27, c0_.`pr_min_usd` AS pr_min_usd_28, c0_.`pr_min_use` AS pr_min_use_29, c0_.`pr_min_f_usd` AS pr_min_f_usd_30, c0_.`pr_min_f_use` AS pr_min_f_use_31, c0_.`pr_min_chf` AS pr_min_chf_32, c0_.`pr_min_che` AS pr_min_che_33, c0_.`pr_min_sek` AS pr_min_sek_34, c0_.`pr_min_see` AS pr_min_see_35, c0_.`pr_min_dkk` AS pr_min_dkk_36, c0_.`pr_min_dke` AS pr_min_dke_37, c0_.`pr_min_nok` AS pr_min_nok_38, c0_.`pr_min_noe` AS pr_min_noe_39, c0_.`pr_min_pln` AS pr_min_pln_40, c0_.`pr_min_ple` AS pr_min_ple_41, c0_.`pr_min_cad` AS pr_min_cad_42, c0_.`pr_min_cae` AS pr_min_cae_43, c0_.`pr_min_f_cad` AS pr_min_f_cad_44, c0_.`pr_min_f_cae` AS pr_min_f_cae_45, c0_.`pr_min_ed` AS pr_min_ed_46, c0_.`important` AS important_47, c0_.`author` AS author_48, c0_.`author_id` AS author_id_49, c0_.`rating` AS rating_50, c0_.`header` AS header_51, c0_.`settings` AS settings_52, c0_.`fids` AS fids_53, c0_.`portal_unid` AS portal_unid_54, c0_.`accepted_at` AS accepted_at_55, c0_.`accept_state` AS accept_state_56, c0_.`description_edit` AS description_edit_57, c0_.`link_award` AS link_award_58, c0_.`awards` AS awards_59, c0_.`video` AS video_60, c0_.`stated_at` AS stated_at_61, c0_.`state` AS state_62, c0_.`description_state` AS description_state_63, c0_.`body_hide` AS body_hide_64, c0_.`release_year` AS release_year_65, c0_.`site` AS site_66, c0_.`show_main` AS show_main_67, c0_.`glue_url` AS glue_url_68, c0_.`accessible` AS accessible_69, c0_.`delivery_suspended` AS delivery_suspended_70, c0_.`process` AS process_71, c0_.`exhibition` AS exhibition_72, c0_.`test_access` AS test_access_73, c0_.`views` AS views_74, c0_.`comment_unid` AS comment_unid_75, c0_.`accesible_at` AS accesible_at_76, c0_.`created_at` AS created_at_77, c0_.`updated_at` AS updated_at_78, f1_.`id` AS id_79, f1_.`unid` AS unid_80, f1_.`name` AS name_81, f1_.`name_inv` AS name_inv_82, f1_.`url` AS url_83, f1_.`alternate_name` AS alternate_name_84, f1_.`description_ru` AS description_ru_85, f1_.`description_en` AS description_en_86, f1_.`description_it` AS description_it_87, f1_.`description_es` AS description_es_88, f1_.`description_fr` AS description_fr_89, f1_.`description_de` AS description_de_90, f1_.`description_pt` AS description_pt_91, f1_.`description_pl` AS description_pl_92, f1_.`description_nl` AS description_nl_93, f1_.`description_fi` AS description_fi_94, f1_.`description_ua` AS description_ua_95, f1_.`description_sv` AS description_sv_96, f1_.`description_no` AS description_no_97, f1_.`description_da` AS description_da_98, f1_.`description_zh` AS description_zh_99, f1_.`delivery_time` AS delivery_time_100, f1_.`not_regular` AS not_regular_101, f1_.`suspended` AS suspended_102, f1_.`status` AS status_103, f1_.`type` AS type_104, f1_.`discount` AS discount_105, f1_.`discount_date_start` AS discount_date_start_106, f1_.`discount_date_end` AS discount_date_end_107, f1_.`transcription` AS transcription_108, f1_.`cost_delivery` AS cost_delivery_109, f1_.`create_date` AS create_date_110, f1_.`is_accepted` AS is_accepted_111, f1_.`accepted_at` AS accepted_at_112, f1_.`accept_state` AS accept_state_113, f1_.`description_edit` AS description_edit_114, f1_.`stated_at` AS stated_at_115, f1_.`state` AS state_116, f1_.`description_state` AS description_state_117, f1_.`video` AS video_118, f1_.`parser_address` AS parser_address_119, f1_.`accessible` AS accessible_120, f1_.`sound` AS sound_121, f1_.`test_access` AS test_access_122, f1_.`total_ideas` AS total_ideas_123, f1_.`votes_submit` AS votes_submit_124, f1_.`votes_stars` AS votes_stars_125, f1_.`brand_link` AS brand_link_126, f1_.`brand_logo` AS brand_logo_127, f1_.`no_send_portl_message` AS no_send_portl_message_128, l2_.`id` AS id_129, l2_.`code` AS code_130, l2_.`locale` AS locale_131, l2_.`phone_code` AS phone_code_132, l2_.`phone_mask` AS phone_mask_133, l2_.`min_valid_phone_numbers` AS min_valid_phone_numbers_134, l2_.`zip_code_mask` AS zip_code_mask_135, l2_.`percent_vat` AS percent_vat_136, l2_.`name` AS name_137, l2_.`name_en` AS name_en_138, l2_.`alias` AS alias_139, l2_.`sort` AS sort_140, l2_.`count` AS count_141, l2_.`hide` AS hide_142, l2_.`important` AS important_143, l2_.`pay_pal_percent` AS pay_pal_percent_144, l2_.`pay_pal_percent_own` AS pay_pal_percent_own_145, l2_.`vat` AS vat_146, l2_.`pv_type` AS pv_type_147, l2_.`capital_timezone_diff` AS capital_timezone_diff_148, l2_.`capital` AS capital_149, l2_.`free_sample_delivery` AS free_sample_delivery_150, l2_.`units` AS units_151 FROM `collection` c0_ INNER JOIN `factory` f1_ ON c0_.factory = f1_.id INNER JOIN `list_country` l2_ ON f1_.country = l2_.id WHERE f1_.`url` = ? AND c0_.`url` = ? AND c0_.`status` IN (?) AND (c0_.`test_access` IS NULL OR c0_.`test_access` = 0) AND (f1_.`test_access` IS NULL OR f1_.`test_access` = 0) LIMIT 1
Parameters:
[ "rondine" "bristol-rondine" [ 1 2 3 7 4 ] ] |
| 2 | 0.15 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:
[
"pl"
]
|
| 3 | 0.08 ms |
SELECT COUNT(i0_.`id`) AS sclr_0 FROM `interior` i0_ WHERE i0_.`status` = 1 AND i0_.collection = ?
Parameters:
[
428348
]
|
| 4 | 0.08 ms |
SELECT i0_.`id` AS id_0 FROM `interior` i0_ WHERE (i0_.`url` = ? OR i0_.`file` = ?) AND i0_.collection = ? LIMIT 1
Parameters:
[ "bristol (rondine)-rondine-1" "bristol (rondine)-rondine-1" 428348 ] |
| 5 | 0.09 ms |
SELECT i0_.`url` AS url_0 FROM `interior` i0_ WHERE i0_.collection = ? AND i0_.`name` = ? LIMIT 1
Parameters:
[ 428348 "bristol (rondine)-rondine-1" ] |
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\FilterEntity | No errors. |
| WebBundle\Entity\SampleEntity | No errors. |
| WebBundle\Entity\BuyOrder | No errors. |
| WebBundle\Entity\ListCountry | No errors. |
| WebBundle\Entity\Publication | No errors. |
| WebBundle\Entity\Idea | No errors. |
| WebBundle\Entity\Article | No errors. |
| WebBundle\Entity\Collection | No errors. |
| WebBundle\Entity\Interior | No errors. |
| WebBundle\Entity\LastUrlEntity | No errors. |
| WebBundle\Entity\ProductReviewsCache | No errors. |
| WebBundle\Entity\ReviewsCache | No errors. |
| WebBundle\Entity\CurrencyRate | No errors. |
| WebBundle\Entity\Factory | 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. |
oneC entity manager
No loaded entities.
logs entity manager
No loaded entities.