Symfony Profiler

Query Metrics

1 Database Queries

1 Different statements

1.41 ms Query time

3 Invalid entities

9 Managed entities

Queries

Group similar statements

default connection

#▲

Time

Info

1.41 ms

SELECT t0.id AS id_1, t0.label AS label_2, t0.name AS name_3, t0.logo AS logo_4, t0.country AS country_5, t0.status AS status_6, t0.actions AS actions_7, t0.carriers AS carriers_8, t0.shipping_methods AS shipping_methods_9, t10.id AS id_11, t10.client_account AS client_account_12, t10.entry_codes AS entry_codes_13, t10.sell_accounts AS sell_accounts_14, t10.tax_accounts AS tax_accounts_15, t10.transport_accounts AS transport_accounts_16, t10.third_party_accounts AS third_party_accounts_17, t10.site_id AS site_id_18, t10.marketplace_id AS marketplace_id_19, t0.company_id AS company_id_20 FROM lengow_marketplace t0 LEFT JOIN entry_configuration t10 ON t10.marketplace_id = t0.id

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.name AS name_3,
  t0.logo AS logo_4,
  t0.country AS country_5,
  t0.status AS status_6,
  t0.actions AS actions_7,
  t0.carriers AS carriers_8,
  t0.shipping_methods AS shipping_methods_9,
  t10.id AS id_11,
  t10.client_account AS client_account_12,
  t10.entry_codes AS entry_codes_13,
  t10.sell_accounts AS sell_accounts_14,
  t10.tax_accounts AS tax_accounts_15,
  t10.transport_accounts AS transport_accounts_16,
  t10.third_party_accounts AS third_party_accounts_17,
  t10.site_id AS site_id_18,
  t10.marketplace_id AS marketplace_id_19,
  t0.company_id AS company_id_20
FROM
  lengow_marketplace t0
  LEFT JOIN entry_configuration t10 ON t10.marketplace_id = t0.id

SELECT t0.id AS id_1, t0.label AS label_2, t0.name AS name_3, t0.logo AS logo_4, t0.country AS country_5, t0.status AS status_6, t0.actions AS actions_7, t0.carriers AS carriers_8, t0.shipping_methods AS shipping_methods_9, t10.id AS id_11, t10.client_account AS client_account_12, t10.entry_codes AS entry_codes_13, t10.sell_accounts AS sell_accounts_14, t10.tax_accounts AS tax_accounts_15, t10.transport_accounts AS transport_accounts_16, t10.third_party_accounts AS third_party_accounts_17, t10.site_id AS site_id_18, t10.marketplace_id AS marketplace_id_19, t0.company_id AS company_id_20 FROM lengow_marketplace t0 LEFT JOIN entry_configuration t10 ON t10.marketplace_id = t0.id;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 942)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 73)
4	Doctrine\ORM\EntityRepository->findAll (line 96)
5	App\Controller\API\Marketplace\ApiLengowController->getMarketplaces (line 107)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
8	Symfony\Component\HttpKernel\Kernel->handle (line 182)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
10	require_once (line 29)
11	require_once (line 5)

Database Connections

Name	Service
default	doctrine.dbal.default_connection
capska	doctrine.dbal.capska_connection
bar	doctrine.dbal.bar_connection
lmdb	doctrine.dbal.lmdb_connection
jardi	doctrine.dbal.jardi_connection
ersho	doctrine.dbal.ersho_connection
soglass	doctrine.dbal.soglass_connection
snaptrap	doctrine.dbal.snaptrap_connection
presta_robin	doctrine.dbal.presta_robin_connection
barcode	doctrine.dbal.barcode_connection
gepreco_shop_dev	doctrine.dbal.gepreco_shop_dev_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager
capska	doctrine.orm.capska_entity_manager
bar	doctrine.orm.bar_entity_manager
lmdb	doctrine.orm.lmdb_entity_manager
jardi	doctrine.orm.jardi_entity_manager
ersho	doctrine.orm.ersho_entity_manager
soglass	doctrine.orm.soglass_entity_manager
snaptrap	doctrine.orm.snaptrap_entity_manager
presta_robin	doctrine.orm.presta_robin_entity_manager
barcode	doctrine.orm.barcode_entity_manager
gepreco_shop_dev	doctrine.orm.gepreco_shop_dev_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\Lengow\Marketplace	8
App\Entity\Gepreco\Societe	1

capska entity manager

Class	Amount of managed objects

bar entity manager

Class	Amount of managed objects

lmdb entity manager

Class	Amount of managed objects

jardi entity manager

Class	Amount of managed objects

ersho entity manager

Class	Amount of managed objects

soglass entity manager

Class	Amount of managed objects

snaptrap entity manager

Class	Amount of managed objects

presta_robin entity manager

Class	Amount of managed objects

barcode entity manager

Class	Amount of managed objects

gepreco_shop_dev entity manager

Class	Amount of managed objects

Entities Mapping

default entity manager

Class	Mapping errors
App\Entity\Lengow\Marketplace	No errors.
App\Entity\Gepreco\Accounting\EntryConfiguration	No errors.
App\Entity\Gepreco\Site	No errors.
App\Entity\Gepreco\Societe	No errors.
App\Entity\Gepreco\Accounting\EntryBook	No errors.
App\Entity\Gepreco\Stock\GsSiteCombinaison	No errors.
App\Entity\Gepreco\Statut\StatutCommandeSite	The association App\Entity\Gepreco\Statut\StatutCommandeSite#orders refers to the owning side field App\Entity\Gepreco\Order\Order#statut which does not exist.
App\Entity\Gepreco\Statut\StatutCommandeFournisseurCsv	No errors.
App\Entity\Gepreco\Statut\StatutApresPrepa	No errors.
App\Entity\Gepreco\Commande\GestionCasse\GestionCasse	No errors.
App\Entity\Gepreco\Commande\CarrierSite	No errors.
App\Entity\Gepreco\Commande\GestionCasse\GestionCasseStatut	No errors.
App\Entity\Gepreco\UserSite	No errors.
App\Entity\Gepreco\Stats\Stats	No errors.
App\Entity\Gepreco\History\HistoryPrepa	No errors.
App\Entity\Gepreco\Paypal\Transaction	No errors.
App\Entity\Gepreco\Stock\GsRemoveOrder	No errors.
App\Entity\Gepreco\Stats\StatsProduct	No errors.
App\Entity\Gepreco\Stats\StatsCarriers	No errors.
App\Entity\Gepreco\Commande\GestionRetour\GestionRetour	No errors.
App\Entity\Gepreco\Stock\GsCommandeFournisseur	The mappings App\Entity\Gepreco\Stock\GsCommandeFournisseur#stateLogs and App\Entity\Gepreco\SupplierOrder\SupplierOrderStateLog#supplierOrder are inconsistent with each other.
App\Entity\Gepreco\Stats\StatsPub	No errors.
App\Entity\Gepreco\User	No errors.
App\Entity\Gepreco\Paypal\ApiAccount	No errors.
App\Entity\Gepreco\Stats\StatsCarrierTaxes	No errors.
App\Entity\Gepreco\Stats\StatsSiteCustom	No errors.
App\Entity\Gepreco\Stock\GsStock	The mappings App\Entity\Gepreco\Stock\GsStock#photosToPresta and App\Entity\Gepreco\Stock\PhotoToPresta#product are inconsistent with each other.
App\Entity\Gepreco\Accounting\Amazon\AmazonEntryBook	No errors.
App\Entity\Gepreco\Accounting\Entry	No errors.

capska entity manager

No loaded entities.

bar entity manager

No loaded entities.

lmdb entity manager

No loaded entities.

jardi entity manager

No loaded entities.

ersho entity manager

No loaded entities.

soglass entity manager

No loaded entities.

snaptrap entity manager

No loaded entities.

presta_robin entity manager

No loaded entities.

barcode entity manager

No loaded entities.

gepreco_shop_dev entity manager

No loaded entities.

Symfony Profiler

GET https://dev.gepreco.fr/api/marketplace/lengow/marketplaces

Configuration Settings

Theme

Page Width

Query Metrics

Queries

default connection

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

capska entity manager

bar entity manager

lmdb entity manager

jardi entity manager

ersho entity manager

soglass entity manager

snaptrap entity manager

presta_robin entity manager

barcode entity manager

gepreco_shop_dev entity manager

Entities Mapping

default entity manager

capska entity manager

bar entity manager

lmdb entity manager

jardi entity manager

ersho entity manager

soglass entity manager

snaptrap entity manager

presta_robin entity manager

barcode entity manager

gepreco_shop_dev entity manager