Query Metrics
8
Database Queries
6
Different statements
10.60 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
6.35 ms (0.00%) |
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.company_address_instructions AS company_address_instructions_11, t0.facebook AS facebook_12, t0.linked_in AS linked_in_13, t0.instagram AS instagram_14, t0.twitter AS twitter_15, t0.favicon_live AS favicon_live_16, t0.favicon_dev AS favicon_dev_17, t0.currency AS currency_18, t0.company_email_password AS company_email_password_19, t0.company_email_import_directory AS company_email_import_directory_20, t0.company_email_import_processed_directory AS company_email_import_processed_directory_21, t0.weather_location AS weather_location_22, t0.company_website AS company_website_23, t0.company_address_longitude AS company_address_longitude_24, t0.company_address_latitude AS company_address_latitude_25, t0.company_time_zone AS company_time_zone_26, t0.company_skype AS company_skype_27, t0.company_qr_code AS company_qr_code_28, t0.footer_display_products AS footer_display_products_29, t0.footer_display_social_media AS footer_display_social_media_30, t0.footer_display_address AS footer_display_address_31, t0.footer_display_tel_numbers AS footer_display_tel_numbers_32, t0.footer_display_contact_details AS footer_display_contact_details_33, t0.header_display_login AS header_display_login_34, t0.contact_first_name AS contact_first_name_35, t0.contact_last_name AS contact_last_name_36, t0.home_page_photos_only AS home_page_photos_only_37, t0.database_password AS database_password_38, t0.sql_database AS sql_database_39, t0.header_display_tand_cs AS header_display_tand_cs_40, t0.header_display_pricing AS header_display_pricing_41, t0.header_display_instructions AS header_display_instructions_42, t0.title_products AS title_products_43, t0.title_sub_products AS title_sub_products_44, t0.header_display_products AS header_display_products_45, t0.header_display_sub_products AS header_display_sub_products_46, t0.footer_display_sub_products AS footer_display_sub_products_47, t0.include_contact_form_home_page AS include_contact_form_home_page_48, t0.multi_lingual AS multi_lingual_49, t0.enable_user_registration AS enable_user_registration_50, t0.registration_email AS registration_email_51, t0.include_qrcode_home_page AS include_qrcode_home_page_52, t0.company_address_map_link AS company_address_map_link_53 FROM company_details t0 WHERE t0.id = ?
Parameters:
[
"1"
]
|
1.66 ms (0.00%) |
1 |
SELECT t0.id AS id_1, t0.photo AS photo_2, t0.title AS title_3, t0.link AS link_4, t0.photo_or_video AS photo_or_video_5, t0.category AS category_6, t0.static_page_name AS static_page_name_7, t0.ranking AS ranking_8, t0.product_id AS product_id_9 FROM cms_photo t0 WHERE t0.static_page_name = ?
Parameters:
[
"Home"
]
|
0.88 ms (0.00%) |
2 |
SELECT t0.id AS id_1, t0.product AS product_2, t0.ranking AS ranking_3, t0.is_active AS is_active_4, t0.comments AS comments_5, t0.include_in_footer AS include_in_footer_6, t0.category AS category_7 FROM product t0 WHERE t0.include_in_footer = ?
Parameters:
[
"1"
]
|
0.80 ms (0.00%) |
2 |
SELECT t0.id AS id_1, t0.product AS product_2, t0.ranking AS ranking_3, t0.is_active AS is_active_4, t0.comments AS comments_5, t0.include_in_footer AS include_in_footer_6, t0.category AS category_7 FROM product t0 WHERE t0.category = ?
Parameters:
[
"Main"
]
|
0.60 ms (0.00%) |
1 |
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.page_count_users AS page_count_users_16, t0.page_count_admin AS page_count_admin_17, t0.product_id AS product_id_18 FROM cms_copy t0 WHERE t0.static_page_name = ?
Parameters:
[
"Home"
]
|
0.30 ms (0.00%) |
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 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.
Entities Mapping
Class | Mapping errors |
---|---|
App\Entity\CmsCopy | No errors. |
App\Entity\CmsPhoto | No errors. |
App\Entity\SubPage | No errors. |
App\Entity\CompanyDetails | No errors. |
App\Entity\Product | No errors. |
App\Entity\Transaction | No errors. |
App\Entity\ServicesOffered | No errors. |
App\Entity\OfficeAppointments | No errors. |
App\Entity\WebsiteContacts | No errors. |
App\Entity\Languages | No errors. |
App\Entity\Translation | No errors. |
App\Entity\Weather | No errors. |
App\Entity\ClientAvailability | No errors. |
App\Entity\ImmigrationAppointments | No errors. |
App\Entity\User | No errors. |
App\Entity\Referrals | No errors. |
App\Entity\BusinessContacts | No errors. |
App\Entity\Passports | No errors. |
App\Entity\BirthDeathMarriageCertificates | No errors. |
App\Entity\DrivingLicense | No errors. |
App\Entity\Medical | No errors. |
App\Entity\HealthInsurance | No errors. |
App\Entity\SchoolAttendanceCertificates | No errors. |
App\Entity\FinancialStatements | No errors. |
App\Entity\EmploymentContracts | No errors. |
App\Entity\UtilityBills | No errors. |
App\Entity\TenancyAgreements | No errors. |
App\Entity\CriminalRecordCheck | No errors. |
App\Entity\DocumentHistory | No errors. |