GET https://pprod.multilabo.com/

Query Metrics

3 Database Queries
3 Different statements
5.03 ms Query time
0 Invalid entities
146 Managed entities

Queries

Group similar statements

#▲ Time Info
1 0.47 ms
SELECT t0_.id AS id_0, t0_.logo AS logo_1, t0_.nom AS nom_2, t0_.type AS type_3, t0_.texte AS texte_4, t0_.is_actif AS is_actif_5, t0_.is_principal AS is_principal_6, t0_.date_modification AS date_modification_7 FROM temoignage t0_ WHERE t0_.is_principal = ? AND t0_.is_actif = ? ORDER BY RAND() ASC LIMIT 4
Parameters:
[
  1
  1
]
2 0.58 ms
SELECT m0_.id AS id_0, m0_.libelle AS libelle_1, m0_.visuel AS visuel_2, m0_.is_actif AS is_actif_3, m0_.date_modification AS date_modification_4, m0_.lien AS lien_5 FROM marque m0_ WHERE m0_.visuel IS NOT NULL AND m0_.is_actif = 1 ORDER BY RAND() ASC LIMIT 31
Parameters:
[]
3 3.98 ms
SELECT c0_.id AS id_0, c0_.ref_client AS ref_client_1, c0_.date_limite_activation AS date_limite_activation_2, c0_.mail AS mail_3, c0_.tel_fixe AS tel_fixe_4, c0_.mode_reglement AS mode_reglement_5, c0_.video AS video_6, c0_.is_actif AS is_actif_7, c0_.chorus AS chorus_8, c0_.societe AS societe_9, c0_.observation AS observation_10, c0_.message AS message_11, c0_.rcs AS rcs_12, c0_.tel_portable AS tel_portable_13, c0_.has_affichage_ttc AS has_affichage_ttc_14, c0_.has_client_export AS has_client_export_15, c0_.acompte AS acompte_16, c0_.montant_ht_frais_gestion AS montant_ht_frais_gestion_17, c0_.is_demo AS is_demo_18, c0_.budget_annuel AS budget_annuel_19, c0_.dossier_ftp_commande AS dossier_ftp_commande_20, c0_.is_brouillon AS is_brouillon_21, c0_.restrict_bon_plan_access AS restrict_bon_plan_access_22, c0_.restrict_essentiel_access AS restrict_essentiel_access_23, c0_.restrict_promotions_access AS restrict_promotions_access_24, c0_.restrict_destockage_access AS restrict_destockage_access_25, c0_.reactualisation_automatique_prix_client_compte AS reactualisation_automatique_prix_client_compte_26, c0_.jours_desactivation_da AS jours_desactivation_da_27, c0_.created_at AS created_at_28, c0_.is_client_get_orders_in_xml_format AS is_client_get_orders_in_xml_format_29, c0_.certibiocide AS certibiocide_30, c0_.abonnement AS abonnement_31, c0_.joker AS joker_32, c1_.id AS id_33, c1_.is_actif AS is_actif_34, c1_.ordre AS ordre_35, c1_.logo AS logo_36, c1_.date_modification AS date_modification_37, c0_.devise_id AS devise_id_38, c0_.site_id AS site_id_39, c0_.mode_livaison_id AS mode_livaison_id_40, c0_.frais_port_id AS frais_port_id_41, c0_.commercial_id AS commercial_id_42, c0_.profil_id AS profil_id_43, c0_.client_branche_id AS client_branche_id_44, c1_.client_id AS client_id_45 FROM client c0_ INNER JOIN client_logo c1_ ON c0_.id = c1_.client_id WHERE c1_.is_actif = 1 AND c0_.is_actif = 1 ORDER BY RAND() ASC LIMIT 31
Parameters:
[]

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\Marque 31
App\Entity\Client 31
App\Entity\ClientLogo 31
App\Entity\ClientBranche 17
App\Entity\UtilisateurBack 10
App\Entity\FraisPort 7
App\Entity\ClientProfil 6
App\Entity\ModeLivraison 6
App\Entity\Temoignage 4
App\Entity\Site 2
App\Entity\Devise 1