GET https://dev.gepreco.fr/api/sites/minified?allSites=false&excludeCustom=false

Query Metrics

3 Database Queries
3 Different statements
0.87 ms Query time
2 Invalid entities
5 Managed entities

Grouped Statements

Show all queries

default connection

Time Count Info
0.30 ms
(35.17%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.adresse1 AS adresse1_3, t0.adresse2 AS adresse2_4, t0.code_postal AS code_postal_5, t0.ville AS ville_6, t0.pays AS pays_7, t0.fn AS fn_8, t0.ln AS ln_9, t0.mail AS mail_10, t0.tel AS tel_11, t0.email_litige AS email_litige_12, t0.compte_tnt AS compte_tnt_13, t0.siret AS siret_14, t0.invoice_mail AS invoice_mail_15, t0.supplier_order_mail AS supplier_order_mail_16, t0.is_stock_blocked_by_location AS is_stock_blocked_by_location_17, t0.dolibarr_url AS dolibarr_url_18 FROM societe t0
Parameters:
[]
0.30 ms
(34.48%)
1
SELECT
            site.id,
            site.name,
            site.em,
            soc.id as companyId,
            url_site as url,
            0 as custom
            from site
            LEFT JOIN societe soc ON soc.id = site.societe_id
            WHERE soc.id IN (1,2,4,5)
Parameters:
[]
0.26 ms
(30.35%)
1
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.name AS name_5, t0.notification_allowed AS notification_allowed_6, t0.receive_mail AS receive_mail_7, t0.changelog_read AS changelog_read_8, t0.slack_id AS slack_id_9, t0.default_societe_id AS default_societe_id_10 FROM `user` t0 WHERE t0.email = ? LIMIT 1
Parameters:
[
  "robin@agence-colibri.com"
]

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\Gepreco\Societe 4
App\Entity\Gepreco\User 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\Gepreco\User No errors.
App\Entity\Gepreco\Societe 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\UserSite No errors.
App\Entity\Gepreco\History\HistoryPrepa No errors.
App\Entity\Gepreco\Stock\StockHistory No errors.
App\Entity\Gepreco\Commande\Litige\Litige No errors.
App\Entity\Gepreco\Stock\UpdateImport\UpdateImport No errors.
App\Entity\Gepreco\Stock\Inventory\Inventory No errors.
App\Entity\Gepreco\Site No errors.
App\Entity\Gepreco\Stats\StatsPub No errors.
App\Entity\Gepreco\Paypal\ApiAccount No errors.
App\Entity\Gepreco\Paypal\Transaction 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\Lengow\Marketplace No errors.
App\Entity\Gepreco\Accounting\Amazon\AmazonEntryBook 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.