https://zebunet.studiolab.fr/nos-projets

Query Metrics

15 Database Queries
9 Different statements
9.83 ms Query time
1 Invalid entities

Grouped Statements

Show all queries

default connection

Time Count Info
1.98 ms
(20.18%)
1
SELECT       c.COLUMN_NAME        AS field,
       c.COLUMN_TYPE        AS type,
       c.IS_NULLABLE        AS `null`,
       c.COLUMN_KEY         AS `key`,
       c.COLUMN_DEFAULT     AS `default`,
       c.EXTRA,
       c.COLUMN_COMMENT     AS comment,
       c.CHARACTER_SET_NAME AS characterset,
       c.COLLATION_NAME     AS collation
FROM information_schema.COLUMNS c
    INNER JOIN information_schema.TABLES t
        ON t.TABLE_NAME = c.TABLE_NAME WHERE c.TABLE_SCHEMA = ? AND t.TABLE_SCHEMA = ? AND t.TABLE_TYPE = 'BASE TABLE' AND t.TABLE_NAME = ? ORDER BY ORDINAL_POSITION
Parameters:
[
  "zebunet"
  "zebunet"
  "doctrine_migration_versions"
]
1.95 ms
(19.83%)
2
SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME
Parameters:
[
  "zebunet"
]
1.47 ms
(14.93%)
6
SELECT DATABASE()
Parameters:
[]
1.08 ms
(11.01%)
1
SELECT t0.id AS id_1, t0.label AS label_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4 FROM project_status t0 WHERE t0.id = ?
Parameters:
[
  2
]
1.01 ms
(10.30%)
1
SELECT t.TABLE_NAME,
           t.ENGINE,
           t.AUTO_INCREMENT,
           t.TABLE_COMMENT,
           t.CREATE_OPTIONS,
           t.TABLE_COLLATION,
           ccsa.CHARACTER_SET_NAME
      FROM information_schema.TABLES t
        INNER JOIN information_schema.COLLATION_CHARACTER_SET_APPLICABILITY ccsa
            ON ccsa.COLLATION_NAME = t.TABLE_COLLATION WHERE t.TABLE_SCHEMA = ? AND t.TABLE_NAME = ? AND t.TABLE_TYPE = 'BASE TABLE'
Parameters:
[
  "zebunet"
  "doctrine_migration_versions"
]
0.87 ms
(8.82%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.is_active AS is_active_3, t0.subscription_count AS subscription_count_4, t0.comment AS comment_5, t0.description AS description_6, t0.cover AS cover_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.status_id AS status_id_10, t0.country_id AS country_id_11, t0.plan_type_id AS plan_type_id_12, t0.partner_id AS partner_id_13 FROM project t0 WHERE t0.is_active = ? AND t0.status_id = ? ORDER BY t0.created_at DESC
Parameters:
[
  1
  2
]
0.76 ms
(7.78%)
1
SELECT DISTINCT            k.CONSTRAINT_NAME,
            k.COLUMN_NAME,
            k.REFERENCED_TABLE_NAME,
            k.REFERENCED_COLUMN_NAME,
            k.ORDINAL_POSITION /*!50116,
            c.UPDATE_RULE,
            c.DELETE_RULE */
FROM information_schema.key_column_usage k /*!50116
INNER JOIN information_schema.referential_constraints c
ON c.CONSTRAINT_NAME = k.CONSTRAINT_NAME
AND c.TABLE_NAME = k.TABLE_NAME */ WHERE k.TABLE_SCHEMA = ? AND k.TABLE_NAME = ? AND k.REFERENCED_COLUMN_NAME IS NOT NULL /*!50116 AND c.CONSTRAINT_SCHEMA = 'zebunet' */ ORDER BY k.ORDINAL_POSITION
Parameters:
[
  "zebunet"
  "doctrine_migration_versions"
]
0.49 ms
(4.99%)
1
SELECT        NON_UNIQUE  AS Non_Unique,
        INDEX_NAME  AS Key_name,
        COLUMN_NAME AS Column_Name,
        SUB_PART    AS Sub_Part,
        INDEX_TYPE  AS Index_Type
FROM information_schema.STATISTICS WHERE TABLE_SCHEMA = ? AND TABLE_NAME = ? ORDER BY SEQ_IN_INDEX
Parameters:
[
  "zebunet"
  "doctrine_migration_versions"
]
0.21 ms
(2.17%)
1
SELECT * FROM doctrine_migration_versions
Parameters:
[]

Database Connections

Name Service
default doctrine.dbal.default_connection
wordpress doctrine.dbal.wordpress_connection
legacy doctrine.dbal.legacy_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager
wordpress doctrine.orm.wordpress_entity_manager
legacy doctrine.orm.legacy_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

default entity manager

Class Mapping errors
App\Entity\ProjectStatus No errors.
App\Entity\Project No errors.
App\Entity\Country No errors.
App\Entity\PlanType No errors.
App\Entity\Partner No errors.
App\Entity\Plan
  • The association App\Entity\Plan#gifts refers to the owning side field App\Entity\Plan#plan which does not exist.
  • The association App\Entity\Plan#reinvestmentPlans refers to the owning side field App\Entity\Gift#reinvestmentPlan which does not exist.
App\Entity\Peasant No errors.
App\Entity\Loan No errors.
App\Entity\Newsletter No errors.
App\Entity\User No errors.
App\Entity\Village No errors.
App\Entity\LoanType No errors.

wordpress entity manager

No loaded entities.

legacy entity manager

No loaded entities.