https://immigrationservices.atts-systems.com/

Query Metrics

8 Database Queries
6 Different statements
6.19 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 2.64 ms
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"
]
2 0.83 ms
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"
]
3 0.39 ms
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"
]
4 0.71 ms
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"
]
5 0.32 ms
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:
[
  "Sub"
]
6 0.46 ms
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
]
7 0.51 ms
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"
]
8 0.33 ms
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"
]

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.