GET http://back.juridoc.tn/juridoc-api/data/site-parameters?locale=fr&siteParameters=1

Query Metrics

2 Database Queries
2 Different statements
1.42 ms Query time
2 Invalid entities
7 Managed entities

Queries

Group similar statements

default connection

# Time Info
1 0.75 ms
SELECT t0.id AS id_1, t0.logo_name AS logo_name_2, t0.bg_name AS bg_name_3, t0.bg_color AS bg_color_4, t0.contact_email AS contact_email_5, t0.sav_email AS sav_email_6, t0.payment_email AS payment_email_7, t0.phone AS phone_8, t0.phone_mobile AS phone_mobile_9, t0.fax AS fax_10, t0.geocode AS geocode_11, t0.opening_times AS opening_times_12, t0.social_facebook AS social_facebook_13, t0.social_twitter AS social_twitter_14, t0.social_linkedin AS social_linkedin_15, t0.modified_at AS modified_at_16, t0.company_name AS company_name_17, t0.company_address AS company_address_18, t0.company_phone AS company_phone_19, t0.company_email AS company_email_20, t0.company_web AS company_web_21, t0.company_condition AS company_condition_22, t0.company_tax_identification AS company_tax_identification_23, t0.application_vat AS application_vat_24, t0.company_tva AS company_tva_25, t0.application_tax_stamp AS application_tax_stamp_26, t0.tax_stamp AS tax_stamp_27, t0.currency_used AS currency_used_28, t0.company_logo_name AS company_logo_name_29, t0.payment_by_check AS payment_by_check_30, t0.payment_by_bank_transfer AS payment_by_bank_transfer_31, t0.status AS status_32, t0.name_plateforme AS name_plateforme_33, t0.url_plateforme AS url_plateforme_34, t0.ia_agent_first_color AS ia_agent_first_color_35, t0.ia_agent_second_color AS ia_agent_second_color_36, t0.ia_agent_third_color AS ia_agent_third_color_37, t0.ia_agent_logo_name AS ia_agent_logo_name_38, t0.ia_free_status AS ia_free_status_39, t0.ia_free_nb_questions AS ia_free_nb_questions_40, t0.db AS db_41, t0.hourly_quota AS hourly_quota_42, t0.daily_quota AS daily_quota_43, t0.quota_email AS quota_email_44, t0.ia_agent_doc_summer AS ia_agent_doc_summer_45, t0.ia_agent_doc_chat AS ia_agent_doc_chat_46, t0.ia_summer_token AS ia_summer_token_47, t0.conform_free_status AS conform_free_status_48, t0.conform_nb_docs AS conform_nb_docs_49, t0.conform_nb_interactions AS conform_nb_interactions_50, t0.contact_type AS contact_type_51, t0.contact_analyze AS contact_analyze_52, t0.conform_token AS conform_token_53, t0.cgu_id AS cgu_id_54, t0.ia_cgu_id AS ia_cgu_id_55, t0.conform_cgu_id AS conform_cgu_id_56 FROM site_parameters t0 WHERE t0.id = ?
Parameters:
[
  1
]
2 0.67 ms
SELECT t0.id AS id_1, t0.site_name AS site_name_2, t0.site_description AS site_description_3, t0.address AS address_4, t0.meta_title AS meta_title_5, t0.meta_description AS meta_description_6, t0.meta_keyword AS meta_keyword_7, t0.ia_msg_not_have_abonnement AS ia_msg_not_have_abonnement_8, t0.ia_msg_no_credit_abonnement AS ia_msg_no_credit_abonnement_9, t0.ia_msg_error_ia_agent AS ia_msg_error_ia_agent_10, t0.ia_title_linked_docs AS ia_title_linked_docs_11, t0.ia_disclaimer AS ia_disclaimer_12, t0.ia_msg_welcome AS ia_msg_welcome_13, t0.ia_msg_you_dont_have_abonnement AS ia_msg_you_dont_have_abonnement_14, t0.ia_msg_request_your_abonnement AS ia_msg_request_your_abonnement_15, t0.ia_link_video_presentation AS ia_link_video_presentation_16, t0.ia_msg_free_use AS ia_msg_free_use_17, t0.ia_msg_exhausted_free AS ia_msg_exhausted_free_18, t0.quota_message AS quota_message_19, t0.locale AS locale_20, t0.translatable_id AS translatable_id_21 FROM site_parameters_translation t0 WHERE t0.translatable_id IN (?) ORDER BY t0.locale ASC
Parameters:
[
  1
]

Database Connections

Name Service
default doctrine.dbal.default_connection
user_data_tunis doctrine.dbal.user_data_tunis_connection
user_data_qanouni doctrine.dbal.user_data_qanouni_connection
user_data_nautilus doctrine.dbal.user_data_nautilus_connection
user_data_nautilus_ai doctrine.dbal.user_data_nautilus_ai_connection
user_data_middle_east doctrine.dbal.user_data_middle_east_connection
user_data_senegal doctrine.dbal.user_data_senegal_connection
user_data_smartdoc doctrine.dbal.user_data_smartdoc_connection
user_data_tanassob doctrine.dbal.user_data_tanassob_connection
user_data_code_ivoire doctrine.dbal.user_data_code_ivoire_connection
user_data_mauritanie doctrine.dbal.user_data_mauritanie_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager
user_data_tunis doctrine.orm.user_data_tunis_entity_manager
user_data_qanouni doctrine.orm.user_data_qanouni_entity_manager
user_data_nautilus doctrine.orm.user_data_nautilus_entity_manager
user_data_nautilus_ai doctrine.orm.user_data_nautilus_ai_entity_manager
user_data_middle_east doctrine.orm.user_data_middle_east_entity_manager
user_data_senegal doctrine.orm.user_data_senegal_entity_manager
user_data_smartdoc doctrine.orm.user_data_smartdoc_entity_manager
user_data_tanassob doctrine.orm.user_data_tanassob_entity_manager
user_data_code_ivoire doctrine.orm.user_data_code_ivoire_entity_manager
user_data_mauritanie doctrine.orm.user_data_mauritanie_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\Main\Cgu 3
App\Entity\Main\SiteParametersTranslation 3
App\Entity\Main\SiteParameters 1

user_data_tunis entity manager

Class Amount of managed objects

user_data_qanouni entity manager

Class Amount of managed objects

user_data_nautilus entity manager

Class Amount of managed objects

user_data_nautilus_ai entity manager

Class Amount of managed objects

user_data_middle_east entity manager

Class Amount of managed objects

user_data_senegal entity manager

Class Amount of managed objects

user_data_smartdoc entity manager

Class Amount of managed objects

user_data_tanassob entity manager

Class Amount of managed objects

user_data_code_ivoire entity manager

Class Amount of managed objects

user_data_mauritanie entity manager

Class Amount of managed objects

Entities Mapping

default entity manager

Class Mapping errors
App\Entity\Main\SiteParameters
  • The field App\Entity\Main\SiteParameters#conformProducts is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Main\ConformProducts#siteParameters does not contain the required 'inversedBy: "conformProducts"' attribute.
  • The mappings App\Entity\Main\SiteParameters#conformInvoices and App\Entity\Main\ConformInvoices#siteParameters are inconsistent with each other.
App\Entity\Main\Cgu
  • The mappings App\Entity\Main\Cgu#conformInvoices and App\Entity\Main\ConformInvoices#cgu are inconsistent with each other.
App\Entity\Main\IaAgentsBySite No errors.
App\Entity\Main\SiteParametersTranslation No errors.
App\Entity\Main\News No errors.
App\Entity\Main\Category No errors.
App\Entity\Main\CategoryMegamenu No errors.
App\Entity\Main\CategoryAlert No errors.
App\Entity\Main\Documents No errors.
App\Entity\Main\Products No errors.
App\Entity\Main\Invoices No errors.
App\Entity\Main\ContactsCategory No errors.
App\Entity\Main\Contacts No errors.
App\Entity\Main\IaInvoices No errors.
App\Entity\Main\IaProducts No errors.
App\Entity\Main\IaUniversCategories No errors.
App\Entity\Main\CouponsCode No errors.
App\Entity\Main\Orders No errors.
App\Entity\Main\Amicale No errors.
App\Entity\Main\AmicaleProducts No errors.
App\Entity\Main\Folder No errors.
App\Entity\Main\SearchHistory No errors.
App\Entity\Main\ConformProducts No errors.
App\Entity\Main\ConformInvoices No errors.
App\Entity\Main\ConformCostUsed No errors.
App\Entity\Main\ConformDocuments No errors.
App\Entity\Main\UserViewDoc No errors.

user_data_tunis entity manager

No loaded entities.

user_data_qanouni entity manager

No loaded entities.

user_data_nautilus entity manager

No loaded entities.

user_data_nautilus_ai entity manager

No loaded entities.

user_data_middle_east entity manager

No loaded entities.

user_data_senegal entity manager

No loaded entities.

user_data_smartdoc entity manager

No loaded entities.

user_data_tanassob entity manager

No loaded entities.

user_data_code_ivoire entity manager

No loaded entities.

user_data_mauritanie entity manager

No loaded entities.