Query Metrics
33
Database Queries
8
Different statements
17.92 ms
Query time
4
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 1.41 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, t0.ranking AS ranking_7 FROM languages t0 WHERE t0.language = ? LIMIT 1
Parameters:
[
"English"
]
|
2 | 0.74 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, t0.ranking AS ranking_7 FROM languages t0 WHERE t0.language = ? LIMIT 1
Parameters:
[
"English"
]
|
3 | 0.47 ms |
SELECT t0.id AS id_1, t0.english AS english_2, t0.french AS french_3, t0.german AS german_4, t0.spanish AS spanish_5, t0.russian AS russian_6, t0.entity AS entity_7 FROM translation t0 WHERE t0.english = ? LIMIT 1
Parameters:
[
"Date"
]
|
4 | 0.33 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, t0.ranking AS ranking_7 FROM languages t0 WHERE t0.language = ? LIMIT 1
Parameters:
[
"English"
]
|
5 | 0.32 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, t0.ranking AS ranking_7 FROM languages t0 WHERE t0.language = ? LIMIT 1
Parameters:
[
"English"
]
|
6 | 0.31 ms |
SELECT t0.id AS id_1, t0.english AS english_2, t0.french AS french_3, t0.german AS german_4, t0.spanish AS spanish_5, t0.russian AS russian_6, t0.entity AS entity_7 FROM translation t0 WHERE t0.english = ? LIMIT 1
Parameters:
[
"Description"
]
|
7 | 0.29 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, t0.ranking AS ranking_7 FROM languages t0 WHERE t0.language = ? LIMIT 1
Parameters:
[
"English"
]
|
8 | 0.32 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, t0.ranking AS ranking_7 FROM languages t0 WHERE t0.language = ? LIMIT 1
Parameters:
[
"English"
]
|
9 | 0.29 ms |
SELECT t0.id AS id_1, t0.english AS english_2, t0.french AS french_3, t0.german AS german_4, t0.spanish AS spanish_5, t0.russian AS russian_6, t0.entity AS entity_7 FROM translation t0 WHERE t0.english = ? LIMIT 1
Parameters:
[
"Category"
]
|
10 | 0.30 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, t0.ranking AS ranking_7 FROM languages t0 WHERE t0.language = ? LIMIT 1
Parameters:
[
"English"
]
|
11 | 0.34 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, t0.ranking AS ranking_7 FROM languages t0 WHERE t0.language = ? LIMIT 1
Parameters:
[
"English"
]
|
12 | 0.29 ms |
SELECT t0.id AS id_1, t0.english AS english_2, t0.french AS french_3, t0.german AS german_4, t0.spanish AS spanish_5, t0.russian AS russian_6, t0.entity AS entity_7 FROM translation t0 WHERE t0.english = ? LIMIT 1
Parameters:
[
"Notes"
]
|
13 | 0.30 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, t0.ranking AS ranking_7 FROM languages t0 WHERE t0.language = ? LIMIT 1
Parameters:
[
"English"
]
|
14 | 0.30 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, t0.ranking AS ranking_7 FROM languages t0 WHERE t0.language = ? LIMIT 1
Parameters:
[
"English"
]
|
15 | 0.28 ms |
SELECT t0.id AS id_1, t0.english AS english_2, t0.french AS french_3, t0.german AS german_4, t0.spanish AS spanish_5, t0.russian AS russian_6, t0.entity AS entity_7 FROM translation t0 WHERE t0.english = ? LIMIT 1
Parameters:
[
"Document"
]
|
16 | 3.94 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.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.footer_display_address AS footer_display_address_29, t0.footer_display_tel_numbers AS footer_display_tel_numbers_30, t0.footer_display_contact_details AS footer_display_contact_details_31, t0.header_display_login AS header_display_login_32, t0.contact_first_name AS contact_first_name_33, t0.contact_last_name AS contact_last_name_34, t0.home_page_photos_only AS home_page_photos_only_35, t0.database_password AS database_password_36, t0.sql_database AS sql_database_37, t0.header_display_tand_cs AS header_display_tand_cs_38, t0.header_display_products AS header_display_products_39, t0.header_display_sub_products AS header_display_sub_products_40, t0.footer_display_sub_products AS footer_display_sub_products_41, t0.include_contact_form_home_page AS include_contact_form_home_page_42, t0.multi_lingual AS multi_lingual_43, t0.enable_user_registration AS enable_user_registration_44, t0.include_qrcode_home_page AS include_qrcode_home_page_45, t0.header_display_contact_details AS header_display_contact_details_46, t0.header_display_business_contacts AS header_display_business_contacts_47, t0.header_display_weather AS header_display_weather_48, t0.header_display_facebook_pages AS header_display_facebook_pages_49, t0.header_display_competitors AS header_display_competitors_50, t0.facebook_reviews_history_show_months AS facebook_reviews_history_show_months_51, t0.title_useful_links AS title_useful_links_52, t0.header_display_photos AS header_display_photos_53, t0.title_products AS title_products_54, t0.title_sub_products AS title_sub_products_55, t0.company_address_map_link AS company_address_map_link_56, t0.company_address_instructions AS company_address_instructions_57, t0.registration_email AS registration_email_58, t0.user_include_home_address AS user_include_home_address_59, t0.user_include_business_address AS user_include_business_address_60, t0.user_include_personal_details AS user_include_personal_details_61, t0.user_include_job_details AS user_include_job_details_62, t0.website_contacts_email_alert AS website_contacts_email_alert_63, t0.website_contacts_auto_reply AS website_contacts_auto_reply_64, t0.contact_from_response AS contact_from_response_65, t0.default_user_password AS default_user_password_66, t0.contact_from_response_duplicate_verified AS contact_from_response_duplicate_verified_67, t0.contact_from_response_duplicate_unverified AS contact_from_response_duplicate_unverified_68, t0.header_display_tel_numbers AS header_display_tel_numbers_69, t0.header_display_address AS header_display_address_70, t0.user_import_divert_business_contacts AS user_import_divert_business_contacts_71, t0.user_import_divert_competitor AS user_import_divert_competitor_72, t0.user_import_divert_target_partner AS user_import_divert_target_partner_73, t0.photo_locations_sort AS photo_locations_sort_74 FROM company_details t0 WHERE t0.id = ?
Parameters:
[
1
]
|
17 | 0.84 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.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 FROM product t0 WHERE t0.category = ? AND t0.is_active = ? ORDER BY t0.ranking ASC
Parameters:
[ "Main" 1 ] |
18 | 0.65 ms |
SELECT t0.id AS id_1, t0.location AS location_2, t0.enabled_users AS enabled_users_3, t0.date AS date_4, t0.public_private AS public_private_5 FROM photo_locations t0 WHERE t0.public_private = ?
Parameters:
[
"Public"
]
|
19 | 1.73 ms |
SELECT COUNT(*) as count FROM photo_locations WHERE public_private = "Public"
Parameters:
[] |
20 | 0.42 ms |
SELECT t0.id AS id_1, t0.location AS location_2, t0.enabled_users AS enabled_users_3, t0.date AS date_4, t0.public_private AS public_private_5 FROM photo_locations t0 WHERE t0.public_private = ?
Parameters:
[
"Public"
]
|
21 | 0.26 ms |
SELECT t0.id AS id_1, t0.location AS location_2, t0.enabled_users AS enabled_users_3, t0.date AS date_4, t0.public_private AS public_private_5 FROM photo_locations t0 WHERE t0.public_private = ?
Parameters:
[
"Public"
]
|
22 | 0.85 ms |
SELECT t0.id AS id_1, t0.photo_file AS photo_file_2, t0.rotate AS rotate_3, t0.location_id AS location_id_4, t0.uploaded_by_id AS uploaded_by_id_5 FROM photos t0 WHERE t0.location_id = ?
Parameters:
[
13
]
|
23 | 0.57 ms |
SELECT t0.id AS id_1, t0.photo_file AS photo_file_2, t0.rotate AS rotate_3, t0.location_id AS location_id_4, t0.uploaded_by_id AS uploaded_by_id_5 FROM photos t0 WHERE t0.location_id = ?
Parameters:
[
19
]
|
24 | 0.21 ms |
SELECT t0.id AS id_1, t0.photo_file AS photo_file_2, t0.rotate AS rotate_3, t0.location_id AS location_id_4, t0.uploaded_by_id AS uploaded_by_id_5 FROM photos t0 WHERE t0.location_id = ?
Parameters:
[
18
]
|
25 | 0.20 ms |
SELECT t0.id AS id_1, t0.photo_file AS photo_file_2, t0.rotate AS rotate_3, t0.location_id AS location_id_4, t0.uploaded_by_id AS uploaded_by_id_5 FROM photos t0 WHERE t0.location_id = ?
Parameters:
[
15
]
|
26 | 0.18 ms |
SELECT t0.id AS id_1, t0.photo_file AS photo_file_2, t0.rotate AS rotate_3, t0.location_id AS location_id_4, t0.uploaded_by_id AS uploaded_by_id_5 FROM photos t0 WHERE t0.location_id = ?
Parameters:
[
10
]
|
27 | 0.44 ms |
SELECT t0.id AS id_1, t0.photo_file AS photo_file_2, t0.rotate AS rotate_3, t0.location_id AS location_id_4, t0.uploaded_by_id AS uploaded_by_id_5 FROM photos t0 WHERE t0.location_id = ?
Parameters:
[
23
]
|
28 | 0.23 ms |
SELECT t0.id AS id_1, t0.photo_file AS photo_file_2, t0.rotate AS rotate_3, t0.location_id AS location_id_4, t0.uploaded_by_id AS uploaded_by_id_5 FROM photos t0 WHERE t0.location_id = ?
Parameters:
[
17
]
|
29 | 0.20 ms |
SELECT t0.id AS id_1, t0.photo_file AS photo_file_2, t0.rotate AS rotate_3, t0.location_id AS location_id_4, t0.uploaded_by_id AS uploaded_by_id_5 FROM photos t0 WHERE t0.location_id = ?
Parameters:
[
9
]
|
30 | 0.19 ms |
SELECT t0.id AS id_1, t0.photo_file AS photo_file_2, t0.rotate AS rotate_3, t0.location_id AS location_id_4, t0.uploaded_by_id AS uploaded_by_id_5 FROM photos t0 WHERE t0.location_id = ?
Parameters:
[
22
]
|
31 | 0.23 ms |
SELECT t0.id AS id_1, t0.photo_file AS photo_file_2, t0.rotate AS rotate_3, t0.location_id AS location_id_4, t0.uploaded_by_id AS uploaded_by_id_5 FROM photos t0 WHERE t0.location_id = ?
Parameters:
[
14
]
|
32 | 0.25 ms |
SELECT t0.id AS id_1, t0.photo_file AS photo_file_2, t0.rotate AS rotate_3, t0.location_id AS location_id_4, t0.uploaded_by_id AS uploaded_by_id_5 FROM photos t0 WHERE t0.location_id = ?
Parameters:
[
21
]
|
33 | 0.25 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, 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.
Entities Mapping
Class | Mapping errors |
---|---|
App\Entity\Languages | No errors. |
App\Entity\Translation | No errors. |
App\Entity\CompanyDetails | No errors. |
App\Entity\Product |
|
App\Entity\WebsiteContacts | No errors. |
App\Entity\PhotoLocations |
|
App\Entity\Photos |
|
App\Entity\User |
|