Query Metrics
47
Database Queries
13
Different statements
92.86 ms
Query time
0
Invalid entities
78
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
25.37 ms (27.32%) |
8 |
SELECT t0.id AS id_1, t0.content_text AS content_text_2, t0.hyperlinks AS hyperlinks_3, t0.content_title AS content_title_4, t0.content_text_fr AS content_text_fr_5, t0.content_text_de AS content_text_de_6, t0.content_title_fr AS content_title_fr_7, t0.content_title_de AS content_title_de_8, t0.tab_title AS tab_title_9, t0.category AS category_10, t0.static_page_name AS static_page_name_11, t0.attachment AS attachment_12, t0.ranking AS ranking_13, t0.tab_title_fr AS tab_title_fr_14, t0.tab_title_de AS tab_title_de_15, t0.product_id AS product_id_16, t0.page_layout_id AS page_layout_id_17 FROM cms_copy t0 WHERE t0.product_id = ?
Parameters:
[
4
]
|
|
23.80 ms (25.63%) |
27 |
SELECT t0.id AS id_1, t0.email AS email_2, t0.email2 AS email2_3, t0.email3 AS email3_4, t0.email_verified AS email_verified_5, t0.password AS password_6, t0.salutation AS salutation_7, t0.first_name AS first_name_8, t0.last_name AS last_name_9, t0.full_name AS full_name_10, t0.mobile AS mobile_11, t0.mobile2 AS mobile2_12, t0.plain_password AS plain_password_13, t0.company AS company_14, t0.birthday AS birthday_15, t0.web_page AS web_page_16, t0.notes AS notes_17, t0.job_title AS job_title_18, t0.linked_in AS linked_in_19, t0.business_phone AS business_phone_20, t0.business_street AS business_street_21, t0.business_city AS business_city_22, t0.business_postal_code AS business_postal_code_23, t0.business_country AS business_country_24, t0.home_phone AS home_phone_25, t0.home_phone2 AS home_phone2_26, t0.home_street AS home_street_27, t0.home_city AS home_city_28, t0.home_postal_code AS home_postal_code_29, t0.home_country AS home_country_30, t0.photo AS photo_31, t0.auto_login_url AS auto_login_url_32, t0.pause_for_bookmark AS pause_for_bookmark_33, t0.include_in_team_bios AS include_in_team_bios_34, t0.default_language_id AS default_language_id_35 FROM user t0 INNER JOIN to_do_list_user ON t0.id = to_do_list_user.user_id WHERE to_do_list_user.to_do_list_id = ?
Parameters:
[
36
]
|
|
15.65 ms (16.85%) |
1 |
SELECT t0.id AS id_1, t0.priority AS priority_2, t0.project AS project_3, t0.live_website AS live_website_4, t0.summary AS summary_5, t0.monthly_revenue AS monthly_revenue_6, t0.c_dev_directory AS c_dev_directory_7, t0.sql_database_file_name AS sql_database_file_name_8, t0.ats_template_last_updated AS ats_template_last_updated_9, t0.active_coding_project AS active_coding_project_10, t0.live_website_working AS live_website_working_11, t0.expand_collapse AS expand_collapse_12 FROM to_do_list t0
Parameters:
[] |
|
15.55 ms (16.75%) |
1 |
SELECT t0.id AS id_1, t0.company_name AS company_name_2, t0.company_email AS company_email_3, t0.company_tel AS company_tel_4, t0.company_mobile AS company_mobile_5, t0.company_address_street AS company_address_street_6, t0.company_address_town AS company_address_town_7, t0.company_address_city AS company_address_city_8, t0.company_address_postal_code AS company_address_postal_code_9, t0.company_address_country AS company_address_country_10, t0.facebook AS facebook_11, t0.linked_in AS linked_in_12, t0.instagram AS instagram_13, t0.twitter AS twitter_14, t0.favicon_live AS favicon_live_15, t0.favicon_dev AS favicon_dev_16, t0.currency AS currency_17, t0.company_email_password AS company_email_password_18, t0.company_email_import_directory AS company_email_import_directory_19, t0.company_email_import_processed_directory AS company_email_import_processed_directory_20, t0.weather_location AS weather_location_21, t0.company_website AS company_website_22, t0.company_address_longitude AS company_address_longitude_23, t0.company_address_latitude AS company_address_latitude_24, t0.company_time_zone AS company_time_zone_25, t0.company_qr_code AS company_qr_code_26, t0.footer_display_products AS footer_display_products_27, t0.footer_display_social_media AS footer_display_social_media_28, t0.header_display_login AS header_display_login_29, t0.contact_first_name AS contact_first_name_30, t0.contact_last_name AS contact_last_name_31, t0.home_page_photos_only AS home_page_photos_only_32, t0.database_password AS database_password_33, t0.sql_database AS sql_database_34, t0.header_display_tand_cs AS header_display_tand_cs_35, t0.header_display_products AS header_display_products_36, t0.header_display_sub_products AS header_display_sub_products_37, t0.footer_display_sub_products AS footer_display_sub_products_38, t0.include_contact_form_home_page AS include_contact_form_home_page_39, t0.multi_lingual AS multi_lingual_40, t0.enable_user_registration AS enable_user_registration_41, t0.include_qrcode_home_page AS include_qrcode_home_page_42, t0.header_display_contact_details AS header_display_contact_details_43, t0.header_display_business_contacts AS header_display_business_contacts_44, t0.header_display_weather AS header_display_weather_45, t0.header_display_facebook_pages AS header_display_facebook_pages_46, t0.header_display_competitors AS header_display_competitors_47, t0.facebook_reviews_history_show_months AS facebook_reviews_history_show_months_48, t0.title_useful_links AS title_useful_links_49, t0.header_display_photos AS header_display_photos_50, t0.title_products AS title_products_51, t0.title_sub_products AS title_sub_products_52, t0.company_address_map_link AS company_address_map_link_53, t0.company_address_instructions AS company_address_instructions_54, t0.registration_email AS registration_email_55, t0.user_include_home_address AS user_include_home_address_56, t0.user_include_business_address AS user_include_business_address_57, t0.user_include_personal_details AS user_include_personal_details_58, t0.user_include_job_details AS user_include_job_details_59, t0.website_contacts_auto_reply AS website_contacts_auto_reply_60, t0.contact_from_response AS contact_from_response_61, t0.default_user_password AS default_user_password_62, t0.contact_from_response_duplicate_verified AS contact_from_response_duplicate_verified_63, t0.contact_from_response_duplicate_unverified AS contact_from_response_duplicate_unverified_64, t0.user_import_divert_business_contacts AS user_import_divert_business_contacts_65, t0.user_import_divert_competitor AS user_import_divert_competitor_66, t0.user_import_divert_target_partner AS user_import_divert_target_partner_67, t0.photo_locations_sort AS photo_locations_sort_68, t0.testing_mode AS testing_mode_69, t0.header_display_useful_links AS header_display_useful_links_70, t0.contact_details_display_address AS contact_details_display_address_71, t0.contact_details_display_tel_numbers AS contact_details_display_tel_numbers_72, t0.contact_details_display_company_vcf AS contact_details_display_company_vcf_73, t0.footer_display_contact_details AS footer_display_contact_details_74, t0.contact_form_include_tel_number AS contact_form_include_tel_number_75, t0.contact_form_include_message AS contact_form_include_message_76, t0.auto_login_available AS auto_login_available_77, t0.registration_user_notes AS registration_user_notes_78, t0.header_display_products_logged_in AS header_display_products_logged_in_79, t0.header_display_sub_products_logged_in AS header_display_sub_products_logged_in_80, t0.header_display_photos_logged_in AS header_display_photos_logged_in_81, t0.competitor_outreach_email AS competitor_outreach_email_82, t0.competitor_outreach_email_subject AS competitor_outreach_email_subject_83, t0.header_display_team_bios AS header_display_team_bios_84, t0.weather_last_scraped AS weather_last_scraped_85, t0.vcf_photo AS vcf_photo_86 FROM company_details t0 WHERE t0.id = ?
Parameters:
[
1
]
|
|
5.30 ms (5.71%) |
1 |
SELECT l0_.id AS id_0, l0_.language AS language_1, l0_.abbreviation AS abbreviation_2, l0_.icon AS icon_3, l0_.is_active AS is_active_4, l0_.linked_in_other AS linked_in_other_5, l0_.ranking AS ranking_6 FROM languages l0_ WHERE l0_.is_active = 1 ORDER BY l0_.ranking ASC
Parameters:
[] |
|
2.55 ms (2.74%) |
1 |
SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.mobile AS mobile_4, t0.notes AS notes_5, t0.date_time AS date_time_6, t0.email AS email_7, t0.status AS status_8, t0.date_responded AS date_responded_9 FROM website_contacts t0 WHERE t0.status = ?
Parameters:
[
"Pending"
]
|
|
1.63 ms (1.76%) |
1 |
SELECT t0.id AS id_1, t0.product AS product_2, t0.ranking AS ranking_3, t0.is_active AS is_active_4, t0.include_in_footer AS include_in_footer_5, t0.category AS category_6, t0.include_in_contact_form AS include_in_contact_form_7, t0.notes AS notes_8, t0.new_client_email AS new_client_email_9, t0.menu_icon AS menu_icon_10, t0.menu_icon_colour AS menu_icon_colour_11, t0.helpful_guide_topic AS helpful_guide_topic_12 FROM product t0 WHERE t0.category = ? AND t0.is_active = ? ORDER BY t0.ranking ASC
Parameters:
[ "Main" 1 ] |
|
0.72 ms (0.78%) |
1 |
SELECT t0.id AS id_1, t0.language AS language_2, t0.abbreviation AS abbreviation_3, t0.icon AS icon_4, t0.is_active AS is_active_5, t0.linked_in_other AS linked_in_other_6, t0.ranking AS ranking_7 FROM languages t0 WHERE t0.abbreviation = ? LIMIT 1
Parameters:
[
"en"
]
|
|
0.61 ms (0.66%) |
2 |
SELECT COUNT(*) FROM product t0 WHERE t0.category = ?
Parameters:
[
"Useful Guide"
]
|
|
0.58 ms (0.62%) |
1 |
SELECT t0.id AS id_1, t0.status AS status_2, t0.priority AS priority_3, t0.task AS task_4, t0.hours_allocated AS hours_allocated_5, t0.immediate_priority AS immediate_priority_6, t0.attachment AS attachment_7, t0.needs_research AS needs_research_8, t0.last_saved AS last_saved_9, t0.project_id AS project_id_10 FROM to_do_list_items t0 WHERE t0.id = ?
Parameters:
[
"325"
]
|
|
0.47 ms (0.50%) |
1 |
SELECT t0.id AS id_1, t0.product AS product_2, t0.ranking AS ranking_3, t0.is_active AS is_active_4, t0.include_in_footer AS include_in_footer_5, t0.category AS category_6, t0.include_in_contact_form AS include_in_contact_form_7, t0.notes AS notes_8, t0.new_client_email AS new_client_email_9, t0.menu_icon AS menu_icon_10, t0.menu_icon_colour AS menu_icon_colour_11, t0.helpful_guide_topic AS helpful_guide_topic_12 FROM product t0 WHERE t0.category = ? ORDER BY t0.ranking ASC
Parameters:
[
"Sub"
]
|
|
0.33 ms (0.36%) |
1 |
SELECT t0.id AS id_1, t0.location AS location_2, t0.date AS date_3, t0.public_private AS public_private_4 FROM photo_locations t0 WHERE t0.public_private = ?
Parameters:
[
"Public"
]
|
|
0.30 ms (0.32%) |
1 |
SELECT t0.id AS id_1, t0.language AS language_2, t0.abbreviation AS abbreviation_3, t0.icon AS icon_4, t0.is_active AS is_active_5, t0.linked_in_other AS linked_in_other_6, t0.ranking AS ranking_7 FROM languages t0 WHERE t0.is_active = ?
Parameters:
[
1
]
|
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| App\Entity\ToDoList | 27 |
| App\Entity\CmsCopy | 27 |
| App\Entity\Product | 13 |
| App\Entity\Languages | 4 |
| App\Entity\PhotoLocations | 3 |
| App\Entity\ToDoListItems | 1 |
| App\Entity\User | 1 |
| App\Entity\CompanyDetails | 1 |
| App\Entity\CmsCopyPageFormats | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Languages | No errors. |
| App\Entity\ToDoListItems | No errors. |
| App\Entity\ToDoList | No errors. |
| App\Entity\User | No errors. |
| App\Entity\Role | No errors. |
| App\Entity\Log | No errors. |
| App\Entity\PhotoLocations | No errors. |
| App\Entity\CompanyDetails | No errors. |
| App\Entity\WebsiteContacts | No errors. |
| App\Entity\Product | No errors. |
| App\Entity\CmsCopy | No errors. |
| App\Entity\CmsCopyPageFormats | No errors. |
| App\Entity\Photos | No errors. |