https://cud.devecomputer.com/robots.txt

Query Metrics

11 Database Queries
7 Different statements
11.17 ms Query time
1 Invalid entities

Grouped Statements

Show all queries

Time Count Info
3.18 ms
(28.49%)
1
SELECT k.CONSTRAINT_NAME, k.COLUMN_NAME, k.REFERENCED_TABLE_NAME, k.REFERENCED_COLUMN_NAME /*!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_NAME = 'doctrine_migration_versions' AND k.TABLE_SCHEMA = 'cud_api' /*!50116 AND c.CONSTRAINT_SCHEMA = 'cud_api' */ORDER BY k.ORDINAL_POSITION
Parameters:
[]
3.08 ms
(27.53%)
2
SHOW FULL TABLES WHERE Table_type = 'BASE TABLE'
Parameters:
[]
1.61 ms
(14.37%)
1
SELECT 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 TABLE_TYPE = 'BASE TABLE' AND TABLE_SCHEMA = DATABASE() AND TABLE_NAME = 'doctrine_migration_versions'
Parameters:
[]
1.49 ms
(13.30%)
1
SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'cud_api' AND TABLE_NAME = 'doctrine_migration_versions' ORDER BY ORDINAL_POSITION ASC
Parameters:
[]
0.81 ms
(7.25%)
4
SELECT DATABASE()
Parameters:
[]
0.52 ms
(4.68%)
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_NAME = 'doctrine_migration_versions' AND TABLE_SCHEMA = 'cud_api' ORDER BY SEQ_IN_INDEX ASC
Parameters:
[]
0.49 ms
(4.38%)
1
SELECT * FROM doctrine_migration_versions
Parameters:
[]

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\MediaObjectQuinquenios No errors.
App\Entity\OpidInvestigationResults No errors.
App\Entity\ScientificPublication No errors.
App\Entity\Booking No errors.
App\Entity\MediaObjectTicIssue No errors.
App\Entity\MediaObjectAcademicMemory No errors.
App\Entity\MediaObject No errors.
App\Entity\HolidaysItemCategory No errors.
App\Entity\Page No errors.
App\Entity\CreditsAcknowledgmentRequest No errors.
App\Entity\NewsItem No errors.
App\Entity\EquipmentIssue No errors.
App\Entity\User No errors.
App\Entity\NewsItemCategory No errors.
App\Entity\MediaObjectHolidaysItem No errors.
App\Entity\MediaObjectIssue No errors.
App\Entity\TicIssue No errors.
App\Entity\NewsItemUser No errors.
App\Entity\AcademicText No errors.
App\Entity\EquipmentIssueMessage No errors.
App\Entity\MediaObjectNewsItemUser No errors.
App\Entity\Section No errors.
App\Entity\Quinquenios No errors.
App\Entity\Payroll No errors.
App\Entity\ChangeRequest No errors.
App\Entity\BookingRoom No errors.
App\Entity\MediaObjectNewsItem No errors.
App\Entity\NewStudentEnrollment No errors.
App\Entity\AcademicMemory No errors.
App\Entity\ImpresosSolicitud No errors.
App\Entity\HolidaysItem No errors.
App\Entity\InternalEvent No errors.
App\Entity\InternalEventUser No errors.
App\Entity\InvestigationProyect No errors.
App\Entity\InvestigationSeminar No errors.
App\Entity\MediaObjectCreditsAcknowledgmentRequest No errors.
App\Entity\MediaObjectImpresosSolicitud No errors.
App\Entity\MediaObjectNewStudentEnrollment No errors.
App\Entity\MediaObjectPayroll No errors.
App\Entity\MediaObjectUser No errors.
App\Entity\OpidTechnologyOfferProfile No errors.
App\Entity\PayrollRemesa No errors.
App\Entity\MediaObjectBookingRoom
  • The association App\Entity\MediaObjectBookingRoom#bookingRoom refers to the inverse side field App\Entity\BookingRoom#mediaObjectBookingRoom which does not exist.
App\Entity\TicIssueMessage No errors.
Vich\UploaderBundle\Entity\File No errors.