GET https://business-n2a.myn2a.online/public/enseignes

Query Metrics

21 Database Queries
7 Different statements
7.09 ms Query time
2 Invalid entities
46 Managed entities

Queries

Group similar statements

# Time Info
1 0.84 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.libelle AS libelle_3, t0.logo AS logo_4, t0.telephone AS telephone_5, t0.email AS email_6, t0.dgi_token AS dgi_token_7, t0.site_web AS site_web_8, t0.slogan AS slogan_9, t0.gps AS gps_10, t0.address AS address_11, t0.code AS code_12, t0.livrado AS livrado_13, t0.businesspay AS businesspay_14, t0.bpay_account AS bpay_account_15, t0.businesspay_account AS businesspay_account_16, t0.cashline_account AS cashline_account_17, t0.careconcept_account AS careconcept_account_18, t0.instantmark_account AS instantmark_account_19, t0.pays_id AS pays_id_20, t0.entreprise_id AS entreprise_id_21, t0.secteur_activite_id AS secteur_activite_id_22, t0.pack_id AS pack_id_23, t0.mode_integration_id AS mode_integration_id_24 FROM enseigne t0
Parameters:
[]
2 0.86 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.code AS code_3, t0.indicatif AS indicatif_4, t0.flag AS flag_5, t0.phone_length AS phone_length_6, t0.phone_regex AS phone_regex_7, t0.phone_example AS phone_example_8, t0.is_active AS is_active_9, t0.zone_economique_id AS zone_economique_id_10 FROM pays t0 WHERE t0.id = ?
Parameters:
[
  2
]
3 0.67 ms
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.logo AS logo_3, t0.telephone AS telephone_4, t0.email AS email_5, t0.site_web AS site_web_6, t0.gps AS gps_7, t0.address AS address_8, t0.description AS description_9, t0.ifu AS ifu_10, t0.rccm AS rccm_11, t0.dgi_token AS dgi_token_12, t0.bpay_account AS bpay_account_13, t0.careconcept_account AS careconcept_account_14, t0.businesspay_account AS businesspay_account_15, t0.cashline_account AS cashline_account_16, t0.instantmark_account AS instantmark_account_17, t0.user_id AS user_id_18, t0.pays_id AS pays_id_19 FROM entreprise t0 WHERE t0.id = ?
Parameters:
[
  15
]
4 0.30 ms
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.code AS code_3 FROM secteur_activite t0 WHERE t0.id = ?
Parameters:
[
  2
]
5 0.46 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.nom AS nom_3, t0.logo AS logo_4, t0.banniere AS banniere_5, t0.description AS description_6, t0.prix AS prix_7, t0.updated_at AS updated_at_8, t0.frais_mise_en_service AS frais_mise_en_service_9, t0.mensualite AS mensualite_10, t0.frais_entretien_annuel AS frais_entretien_annuel_11 FROM pack t0 WHERE t0.id = ?
Parameters:
[
  1
]
6 0.21 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.nom AS nom_3, t0.description AS description_4 FROM mode_integration t0 WHERE t0.id = ?
Parameters:
[
  1
]
7 0.72 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.nom AS nom_3, t0.description AS description_4, t0.prix AS prix_5, t0.logo AS logo_6, t0.banniere AS banniere_7, t0.presentation AS presentation_8, t0.site_officiel AS site_officiel_9, t0.lien_plateforme AS lien_plateforme_10, t0.base_prefix AS base_prefix_11, t0.base_suffix AS base_suffix_12, t0.api_service AS api_service_13, t0.api_provisionning AS api_provisionning_14, t0.db_host AS db_host_15, t0.db_name AS db_name_16, t0.db_user AS db_user_17, t0.db_pass AS db_pass_18, t0.base_url AS base_url_19, t0.api_key AS api_key_20, t0.numero_bpay AS numero_bpay_21, t0.portail AS portail_22, t0.ordre_portail AS ordre_portail_23, t0.sous_compte_bpay AS sous_compte_bpay_24, t0.updated_at AS updated_at_25 FROM plateforme t0 INNER JOIN pack_plateformes ON t0.id = pack_plateformes.plateforme_id WHERE pack_plateformes.pack_id = ?
Parameters:
[
  1
]
8 0.20 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.nom AS nom_3, t0.description AS description_4 FROM mode_integration t0 WHERE t0.id = ?
Parameters:
[
  2
]
9 0.23 ms
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.logo AS logo_3, t0.telephone AS telephone_4, t0.email AS email_5, t0.site_web AS site_web_6, t0.gps AS gps_7, t0.address AS address_8, t0.description AS description_9, t0.ifu AS ifu_10, t0.rccm AS rccm_11, t0.dgi_token AS dgi_token_12, t0.bpay_account AS bpay_account_13, t0.careconcept_account AS careconcept_account_14, t0.businesspay_account AS businesspay_account_15, t0.cashline_account AS cashline_account_16, t0.instantmark_account AS instantmark_account_17, t0.user_id AS user_id_18, t0.pays_id AS pays_id_19 FROM entreprise t0 WHERE t0.id = ?
Parameters:
[
  16
]
10 0.18 ms
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.code AS code_3 FROM secteur_activite t0 WHERE t0.id = ?
Parameters:
[
  1
]
11 0.23 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.nom AS nom_3, t0.logo AS logo_4, t0.banniere AS banniere_5, t0.description AS description_6, t0.prix AS prix_7, t0.updated_at AS updated_at_8, t0.frais_mise_en_service AS frais_mise_en_service_9, t0.mensualite AS mensualite_10, t0.frais_entretien_annuel AS frais_entretien_annuel_11 FROM pack t0 WHERE t0.id = ?
Parameters:
[
  3
]
12 0.28 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.nom AS nom_3, t0.description AS description_4, t0.prix AS prix_5, t0.logo AS logo_6, t0.banniere AS banniere_7, t0.presentation AS presentation_8, t0.site_officiel AS site_officiel_9, t0.lien_plateforme AS lien_plateforme_10, t0.base_prefix AS base_prefix_11, t0.base_suffix AS base_suffix_12, t0.api_service AS api_service_13, t0.api_provisionning AS api_provisionning_14, t0.db_host AS db_host_15, t0.db_name AS db_name_16, t0.db_user AS db_user_17, t0.db_pass AS db_pass_18, t0.base_url AS base_url_19, t0.api_key AS api_key_20, t0.numero_bpay AS numero_bpay_21, t0.portail AS portail_22, t0.ordre_portail AS ordre_portail_23, t0.sous_compte_bpay AS sous_compte_bpay_24, t0.updated_at AS updated_at_25 FROM plateforme t0 INNER JOIN pack_plateformes ON t0.id = pack_plateformes.plateforme_id WHERE pack_plateformes.pack_id = ?
Parameters:
[
  3
]
13 0.20 ms
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.logo AS logo_3, t0.telephone AS telephone_4, t0.email AS email_5, t0.site_web AS site_web_6, t0.gps AS gps_7, t0.address AS address_8, t0.description AS description_9, t0.ifu AS ifu_10, t0.rccm AS rccm_11, t0.dgi_token AS dgi_token_12, t0.bpay_account AS bpay_account_13, t0.careconcept_account AS careconcept_account_14, t0.businesspay_account AS businesspay_account_15, t0.cashline_account AS cashline_account_16, t0.instantmark_account AS instantmark_account_17, t0.user_id AS user_id_18, t0.pays_id AS pays_id_19 FROM entreprise t0 WHERE t0.id = ?
Parameters:
[
  17
]
14 0.21 ms
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.code AS code_3 FROM secteur_activite t0 WHERE t0.id = ?
Parameters:
[
  3
]
15 0.18 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.nom AS nom_3, t0.description AS description_4 FROM mode_integration t0 WHERE t0.id = ?
Parameters:
[
  3
]
16 0.23 ms
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.logo AS logo_3, t0.telephone AS telephone_4, t0.email AS email_5, t0.site_web AS site_web_6, t0.gps AS gps_7, t0.address AS address_8, t0.description AS description_9, t0.ifu AS ifu_10, t0.rccm AS rccm_11, t0.dgi_token AS dgi_token_12, t0.bpay_account AS bpay_account_13, t0.careconcept_account AS careconcept_account_14, t0.businesspay_account AS businesspay_account_15, t0.cashline_account AS cashline_account_16, t0.instantmark_account AS instantmark_account_17, t0.user_id AS user_id_18, t0.pays_id AS pays_id_19 FROM entreprise t0 WHERE t0.id = ?
Parameters:
[
  18
]
17 0.21 ms
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.logo AS logo_3, t0.telephone AS telephone_4, t0.email AS email_5, t0.site_web AS site_web_6, t0.gps AS gps_7, t0.address AS address_8, t0.description AS description_9, t0.ifu AS ifu_10, t0.rccm AS rccm_11, t0.dgi_token AS dgi_token_12, t0.bpay_account AS bpay_account_13, t0.careconcept_account AS careconcept_account_14, t0.businesspay_account AS businesspay_account_15, t0.cashline_account AS cashline_account_16, t0.instantmark_account AS instantmark_account_17, t0.user_id AS user_id_18, t0.pays_id AS pays_id_19 FROM entreprise t0 WHERE t0.id = ?
Parameters:
[
  19
]
18 0.19 ms
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.logo AS logo_3, t0.telephone AS telephone_4, t0.email AS email_5, t0.site_web AS site_web_6, t0.gps AS gps_7, t0.address AS address_8, t0.description AS description_9, t0.ifu AS ifu_10, t0.rccm AS rccm_11, t0.dgi_token AS dgi_token_12, t0.bpay_account AS bpay_account_13, t0.careconcept_account AS careconcept_account_14, t0.businesspay_account AS businesspay_account_15, t0.cashline_account AS cashline_account_16, t0.instantmark_account AS instantmark_account_17, t0.user_id AS user_id_18, t0.pays_id AS pays_id_19 FROM entreprise t0 WHERE t0.id = ?
Parameters:
[
  20
]
19 0.21 ms
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.logo AS logo_3, t0.telephone AS telephone_4, t0.email AS email_5, t0.site_web AS site_web_6, t0.gps AS gps_7, t0.address AS address_8, t0.description AS description_9, t0.ifu AS ifu_10, t0.rccm AS rccm_11, t0.dgi_token AS dgi_token_12, t0.bpay_account AS bpay_account_13, t0.careconcept_account AS careconcept_account_14, t0.businesspay_account AS businesspay_account_15, t0.cashline_account AS cashline_account_16, t0.instantmark_account AS instantmark_account_17, t0.user_id AS user_id_18, t0.pays_id AS pays_id_19 FROM entreprise t0 WHERE t0.id = ?
Parameters:
[
  25
]
20 0.19 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.nom AS nom_3, t0.logo AS logo_4, t0.banniere AS banniere_5, t0.description AS description_6, t0.prix AS prix_7, t0.updated_at AS updated_at_8, t0.frais_mise_en_service AS frais_mise_en_service_9, t0.mensualite AS mensualite_10, t0.frais_entretien_annuel AS frais_entretien_annuel_11 FROM pack t0 WHERE t0.id = ?
Parameters:
[
  2
]
21 0.29 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.nom AS nom_3, t0.description AS description_4, t0.prix AS prix_5, t0.logo AS logo_6, t0.banniere AS banniere_7, t0.presentation AS presentation_8, t0.site_officiel AS site_officiel_9, t0.lien_plateforme AS lien_plateforme_10, t0.base_prefix AS base_prefix_11, t0.base_suffix AS base_suffix_12, t0.api_service AS api_service_13, t0.api_provisionning AS api_provisionning_14, t0.db_host AS db_host_15, t0.db_name AS db_name_16, t0.db_user AS db_user_17, t0.db_pass AS db_pass_18, t0.base_url AS base_url_19, t0.api_key AS api_key_20, t0.numero_bpay AS numero_bpay_21, t0.portail AS portail_22, t0.ordre_portail AS ordre_portail_23, t0.sous_compte_bpay AS sous_compte_bpay_24, t0.updated_at AS updated_at_25 FROM plateforme t0 INNER JOIN pack_plateformes ON t0.id = pack_plateformes.plateforme_id WHERE pack_plateformes.pack_id = ?
Parameters:
[
  2
]

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\Enseigne 16
App\Entity\Entreprise 7
App\Entity\Plateforme 7
App\Entity\Users 5
App\Entity\SecteurActivite 3
App\Entity\Pack 3
App\Entity\ModeIntegration 3
App\Entity\Pays 1
App\Entity\ZoneEconomique 1

Entities Mapping

Class Mapping errors
App\Entity\Enseigne
  • The field App\Entity\Enseigne#packAbonnements is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\PackAbonnement#enseigne does not contain the required 'inversedBy="packAbonnements"' attribute.
App\Entity\Pays No errors.
App\Entity\Entreprise No errors.
App\Entity\SecteurActivite
  • The association App\Entity\SecteurActivite#entreprises refers to the owning side field App\Entity\Entreprise#secteurActivite which does not exist.
App\Entity\Pack No errors.
App\Entity\ModeIntegration No errors.
App\Entity\PackAbonnement No errors.
App\Entity\ZoneEconomique No errors.
App\Entity\Users No errors.
App\Entity\Plateforme No errors.