https://dev.oceanexpert.net/institutes?dir=asc&page=171&sort=i.instName

Query Metrics

4 Database Queries
4 Different statements
100.13 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 35.08 ms
SELECT i0_.id_inst AS id_inst_0, i0_.parent_id AS parent_id_1, i0_.inst_type_id AS inst_type_id_2, i0_.inst_name AS inst_name_3, i0_.inst_name_eng AS inst_name_eng_4, i0_.country_code AS country_code_5, c1_.country AS country_6, i2_.insttype_name AS insttype_name_7 FROM institutions i0_ LEFT JOIN countries c1_ ON (i0_.country_code = c1_.id_country) LEFT JOIN insttypes i2_ ON (i0_.inst_type_id = i2_.id_insttype) WHERE i0_.activated = 1
Parameters:
[]
2 18.90 ms
SELECT count(DISTINCT i0_.id_inst) AS sclr_0 FROM institutions i0_ LEFT JOIN countries c1_ ON (i0_.country_code = c1_.id_country) LEFT JOIN insttypes i2_ ON (i0_.inst_type_id = i2_.id_insttype) WHERE i0_.activated = 1
Parameters:
[]
3 44.90 ms
SELECT DISTINCT i0_.id_inst AS id_inst_0, i0_.inst_name AS inst_name_1 FROM institutions i0_ LEFT JOIN countries c1_ ON (i0_.country_code = c1_.id_country) LEFT JOIN insttypes i2_ ON (i0_.inst_type_id = i2_.id_insttype) WHERE i0_.activated = 1 ORDER BY i0_.inst_name ASC LIMIT 10 OFFSET 1700
Parameters:
[]
4 1.24 ms
SELECT i0_.id_inst AS id_inst_0, i0_.parent_id AS parent_id_1, i0_.inst_type_id AS inst_type_id_2, i0_.inst_name AS inst_name_3, i0_.inst_name_eng AS inst_name_eng_4, i0_.country_code AS country_code_5, c1_.country AS country_6, i2_.insttype_name AS insttype_name_7 FROM institutions i0_ LEFT JOIN countries c1_ ON (i0_.country_code = c1_.id_country) LEFT JOIN insttypes i2_ ON (i0_.inst_type_id = i2_.id_insttype) WHERE i0_.activated = 1 AND i0_.id_inst IN (?) ORDER BY i0_.inst_name ASC
Parameters:
[
  [
    24737
    18949
    18971
    10197
    15792
    14425
    21285
    22889
    15670
    12154
  ]
]

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
OceanExpertBundle\Entity\Institutions No errors.
OceanExpertBundle\Entity\Countries No errors.
OceanExpertBundle\Entity\Insttypes No errors.