GET https://annuairesdz.com/search?page=389&page%3D3757=

Query Metrics

3 Database Queries
3 Different statements
8.12 ms Query time
0 Invalid entities
21 Managed entities

Grouped Statements

Show all queries

Time Count Info
6.78 ms
(83.53%)
1
SELECT count(DISTINCT b0_.id) AS sclr_0 FROM business_information b0_
Parameters:
[]
0.78 ms
(9.60%)
1
SELECT DISTINCT b0_.id AS id_0 FROM business_information b0_ LIMIT 21 OFFSET 8148
Parameters:
[]
0.56 ms
(6.87%)
1
SELECT b0_.id AS id_0, b0_.business_name AS business_name_1, b0_.street_address AS street_address_2, b0_.state AS state_3, b0_.fixe_phone AS fixe_phone_4, b0_.fax_number AS fax_number_5, b0_.mobile AS mobile_6, b0_.email AS email_7, b0_.website AS website_8, b0_.categories AS categories_9, b0_.logo AS logo_10, b0_.city AS city_11, b0_.custmer_type AS custmer_type_12, b0_.key_words AS key_words_13, b0_.created_by AS created_by_14, b0_.created_date AS created_date_15, b0_.company_presentation AS company_presentation_16, b0_.service_photo_1 AS service_photo_1_17, b0_.service_photo_2 AS service_photo_2_18, b0_.service_photo_3 AS service_photo_3_19, b0_.service_photo_4 AS service_photo_4_20, b0_.service_photo_5 AS service_photo_5_21, b0_.service_photo_6 AS service_photo_6_22, b0_.documentations_catalogs AS documentations_catalogs_23, b0_.company_references AS company_references_24, b0_.video_entreprise AS video_entreprise_25, b0_.facebook AS facebook_26, b0_.youtube AS youtube_27, b0_.maps AS maps_28, b0_.banner AS banner_29, b0_.add_date AS add_date_30, b0_.maquette AS maquette_31, b0_.alaune AS alaune_32, b0_.mobile1 AS mobile1_33, b0_.mobile2 AS mobile2_34, b0_.mobile3 AS mobile3_35, b0_.email1 AS email1_36, b0_.email2 AS email2_37 FROM business_information b0_ WHERE b0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  8149
  8150
  8151
  8152
  8153
  8154
  8155
  8156
  8157
  8158
  8159
  8160
  8161
  8162
  8163
  8164
  8165
  8166
  8167
  8168
  8169
]

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.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\BusinessInformation 21

Entities Mapping

Class Mapping errors
App\Entity\BusinessInformation No errors.