https://beta.hobbiinn.com/admin/subscriptions/subscribers/list

Query Metrics

8 Database Queries
4 Different statements
4.70 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
1.45 ms
(30.96%)
3
SELECT t0.id AS id_1, t0.name AS name_2, t0.text AS text_3, t0.price AS price_4, t0.quantity AS quantity_5, t0.product_slug AS product_slug_6, t0.percent_deposit AS percent_deposit_7, t0.deadline AS deadline_8, t0.sizes AS sizes_9, t0.colors AS colors_10, t0.size_ring AS size_ring_11, t0.nb_guest AS nb_guest_12, t0.youtube_video AS youtube_video_13, t0.is_activated AS is_activated_14, t0.is_desactivated_by_admin AS is_desactivated_by_admin_15, t0.mode_livraison AS mode_livraison_16, t0.frais_livraison AS frais_livraison_17, t0.weight AS weight_18, t0.transporteurs AS transporteurs_19, t0.code_promo AS code_promo_20, t0.code_promo_euro AS code_promo_euro_21, t0.template AS template_22, t0.taxe_sejour AS taxe_sejour_23, t0.prix_caution AS prix_caution_24, t0.longitude AS longitude_25, t0.latitude AS latitude_26, t0.spring_price AS spring_price_27, t0.summer_price AS summer_price_28, t0.autumn_price AS autumn_price_29, t0.winter_price AS winter_price_30, t0.week_end_price AS week_end_price_31, t0.city_localisation AS city_localisation_32, t0.nb_chambre AS nb_chambre_33, t0.night_min AS night_min_34, t0.company_id AS company_id_35, t0.pack_id AS pack_id_36, t37.id AS id_38, t37.title AS title_39, t37.synthetique_message AS synthetique_message_40, t37.photo1 AS photo1_41, t37.description AS description_42, t37.photo2 AS photo2_43, t37.details AS details_44, t37.photo3 AS photo3_45, t37.product_id AS product_id_46, t0.type_location_id AS type_location_id_47, t0.type_prestation_id AS type_prestation_id_48, t0.tva_id AS tva_id_49, t0.type_hebergements_id AS type_hebergements_id_50, t0.type_activity_id AS type_activity_id_51, t0.caracteristique_vehicule_id AS caracteristique_vehicule_id_52, t0.commune_id AS commune_id_53 FROM product t0 LEFT JOIN product_description t37 ON t37.product_id = t0.id WHERE t0.company_id = ?
Parameters:
[
  266
]
1.24 ms
(26.43%)
3
SELECT t0.id AS id_1, t0.mango_recurring_registration_id AS mango_recurring_registration_id_2, t0.created_at AS created_at_3, t0.next_update AS next_update_4, t0.is_active AS is_active_5, t0.disabling_reason AS disabling_reason_6, t0.stripe_subscription_id AS stripe_subscription_id_7, t0.company_id AS company_id_8, t0.type_abonnement_id AS type_abonnement_id_9, t10.id AS id_11, t10.label AS label_12, t10.prix AS prix_13, t10.explication AS explication_14, t10.stripe_id AS stripe_id_15, t10.payment_link AS payment_link_16 FROM abonnement t0 LEFT JOIN type_abonnement t10 ON t0.type_abonnement_id = t10.id WHERE t0.company_id = ?
Parameters:
[
  266
]
1.04 ms
(22.15%)
1
SELECT c0_.id AS id_0, c0_.siren AS siren_1, c0_.contact_name AS contact_name_2, c0_.contact_phone AS contact_phone_3, c0_.company_name AS company_name_4, c0_.fax AS fax_5, c0_.website AS website_6, c0_.contact_civility AS contact_civility_7, c0_.is_accept_condition AS is_accept_condition_8, c0_.company_slug AS company_slug_9, c0_.description AS description_10, c0_.image AS image_11, c0_.is_confirmed AS is_confirmed_12, c0_.kbis AS kbis_13, c0_.conditions_vente AS conditions_vente_14, c0_.strip_id AS strip_id_15, c0_.stripe_account AS stripe_account_16, c0_.first_name AS first_name_17, c0_.contact_birthday AS contact_birthday_18, c0_.country AS country_19, c0_.mango_id AS mango_id_20, c0_.is_valid_document AS is_valid_document_21, c0_.type AS type_22, c0_.is_editor_guide AS is_editor_guide_23, c0_.paiement_activ AS paiement_activ_24, c0_.commission_active AS commission_active_25, c0_.statu_con AS statu_con_26, c0_.etat_network AS etat_network_27, c0_.created_at AS created_at_28, c0_.is_direct_reservation_mode AS is_direct_reservation_mode_29, c0_.stripe_id AS stripe_id_30, c0_.stripe_account_id AS stripe_account_id_31, c0_.roles AS roles_32, c0_.email AS email_33, c0_.password AS password_34, c0_.adress AS adress_35, c0_.zip_code AS zip_code_36, c0_.city AS city_37 FROM company c0_ INNER JOIN abonnement a1_ ON c0_.id = a1_.company_id WHERE a1_.is_active = 1 OR a1_.is_active = 0 ORDER BY c0_.id DESC
Parameters:
[]
0.96 ms
(20.47%)
1
SELECT t0.id AS id_1, t0.civility AS civility_2, t0.first_name AS first_name_3, t0.last_name AS last_name_4, t0.phone AS phone_5, t0.wedding_date AS wedding_date_6, t0.image AS image_7, t0.id_stripe AS id_stripe_8, t0.livraison_adress AS livraison_adress_9, t0.livraison_zip_code AS livraison_zip_code_10, t0.livraison_city AS livraison_city_11, t0.birth_at AS birth_at_12, t0.nationality AS nationality_13, t0.country_residence AS country_residence_14, t0.mango_id AS mango_id_15, t0.is_valid AS is_valid_16, t0.service_address AS service_address_17, t0.service_zip_code AS service_zip_code_18, t0.service_city AS service_city_19, t0.statu_con AS statu_con_20, t0.etat_network AS etat_network_21, t0.roles AS roles_22, t0.email AS email_23, t0.password AS password_24, t0.adress AS adress_25, t0.zip_code AS zip_code_26, t0.city AS city_27 FROM user t0 WHERE t0.id = ?
Parameters:
[
  39
]

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\User No errors.
App\Entity\Command No errors.
App\Entity\WishList No errors.
App\Entity\Avis No errors.
App\Entity\Messaging No errors.
App\Entity\Ticket No errors.
App\Entity\TableUser No errors.
App\Entity\Litige No errors.
App\Entity\Annonce No errors.
App\Entity\Location No errors.
App\Entity\Reservation No errors.
App\Entity\Caution No errors.
App\Entity\ReseauSociaux\Message No errors.
App\Entity\ReseauSociaux\Conversation No errors.
App\Entity\ReseauSociaux\Espace No errors.
App\Entity\ReseauSociaux\Publication No errors.
App\Entity\ReseauSociaux\Comments No errors.
App\Entity\ReseauSociaux\Notifications No errors.
App\Entity\ReseauSociaux\PostLike No errors.
App\Entity\ReseauSociaux\SharePost No errors.
App\Entity\PendingLocation No errors.
App\Entity\PendingReservation No errors.
App\Entity\Notification No errors.
App\Entity\ReseauSociaux\InvitationEspace No errors.
App\Entity\Company No errors.
App\Entity\Abonnement No errors.
App\Entity\Product No errors.
App\Entity\PlanningCompany No errors.
App\Entity\Category No errors.
App\Entity\Payout No errors.
App\Entity\AnnonceCompany No errors.
App\Entity\Pack No errors.
App\Entity\ProductDescription No errors.
App\Entity\TypeLocation No errors.
App\Entity\TypePrestation No errors.
App\Entity\Tva No errors.
App\Entity\TypeHebergement No errors.
App\Entity\ActivityType No errors.
App\Entity\CaracteristiqueVehicule No errors.
App\Entity\Commune No errors.
App\Entity\TypeAbonnement No errors.
App\Entity\Paiement No errors.
App\Entity\Photos No errors.
App\Entity\Department No errors.
App\Entity\CommandProduct No errors.
App\Entity\ProductPercent No errors.
App\Entity\ContactProduct No errors.
App\Entity\ProductOption No errors.
App\Entity\SubCategory No errors.
App\Entity\Participant No errors.
App\Entity\Chambre No errors.
App\Entity\Caracteristic No errors.
App\Entity\Equipment No errors.
App\Entity\LangueHote No errors.
App\Entity\TypeLocalisation No errors.
App\Entity\Security No errors.
App\Entity\ProductReduction No errors.
App\Entity\ProgrammingDayPrice No errors.
App\Entity\ProductAgenda No errors.
App\Entity\ProductAutoReduction No errors.
App\Entity\ProductPeriodPrice No errors.
App\Entity\TarifDegressif No errors.
App\Entity\EquipementsCuisine No errors.
App\Entity\SalleDeBain No errors.
App\Entity\AccessoiresDeChambre No errors.
App\Entity\MobilierExterieur No errors.
App\Entity\LocalisatioHebergs No errors.