Query Metrics
4
Database Queries
4
Different statements
1895.92 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
962.04 ms (50.74%) |
1 |
SELECT DISTINCT b0_.id AS id_0 FROM business_information b0_ WHERE (LOWER(b0_.id) LIKE ? OR LOWER(b0_.business_name) LIKE ? OR LOWER(b0_.street_address) LIKE ? OR LOWER(b0_.state) LIKE ? OR LOWER(b0_.fixe_phone) LIKE ? OR LOWER(b0_.fax_number) LIKE ? OR LOWER(b0_.mobile) LIKE ? OR LOWER(b0_.email) LIKE ? OR LOWER(b0_.website) LIKE ? OR LOWER(b0_.categories) LIKE ? OR LOWER(b0_.logo) LIKE ? OR LOWER(b0_.city) LIKE ? OR LOWER(b0_.description) LIKE ? OR LOWER(b0_.contact_name) LIKE ? OR LOWER(b0_.business_title) LIKE ? OR LOWER(b0_.custmer_type) LIKE ? OR LOWER(b0_.key_words) LIKE ? OR LOWER(b0_.general_info) LIKE ? OR LOWER(b0_.created_by) LIKE ? OR LOWER(b0_.statut) LIKE ? OR LOWER(b0_.created_date) LIKE ? OR LOWER(b0_.company_presentation) LIKE ? OR LOWER(b0_.year_established) LIKE ? OR LOWER(b0_.service_photo_1) LIKE ? OR LOWER(b0_.service_photo_2) LIKE ? OR LOWER(b0_.service_photo_3) LIKE ? OR LOWER(b0_.service_photo_4) LIKE ? OR LOWER(b0_.service_photo_5) LIKE ? OR LOWER(b0_.service_photo_6) LIKE ? OR LOWER(b0_.documentations_catalogs) LIKE ? OR LOWER(b0_.company_references) LIKE ? OR LOWER(b0_.video_entreprise) LIKE ? OR LOWER(b0_.facebook) LIKE ? OR LOWER(b0_.youtube) LIKE ? OR LOWER(b0_.maps) LIKE ? OR LOWER(b0_.banner) LIKE ? OR LOWER(b0_.add_date) LIKE ? OR LOWER(b0_.maquette) LIKE ?) AND (LOWER(b0_.id) LIKE ? OR LOWER(b0_.business_name) LIKE ? OR LOWER(b0_.street_address) LIKE ? OR LOWER(b0_.state) LIKE ? OR LOWER(b0_.fixe_phone) LIKE ? OR LOWER(b0_.fax_number) LIKE ? OR LOWER(b0_.mobile) LIKE ? OR LOWER(b0_.email) LIKE ? OR LOWER(b0_.website) LIKE ? OR LOWER(b0_.categories) LIKE ? OR LOWER(b0_.logo) LIKE ? OR LOWER(b0_.city) LIKE ? OR LOWER(b0_.description) LIKE ? OR LOWER(b0_.contact_name) LIKE ? OR LOWER(b0_.business_title) LIKE ? OR LOWER(b0_.custmer_type) LIKE ? OR LOWER(b0_.key_words) LIKE ? OR LOWER(b0_.general_info) LIKE ? OR LOWER(b0_.created_by) LIKE ? OR LOWER(b0_.statut) LIKE ? OR LOWER(b0_.created_date) LIKE ? OR LOWER(b0_.company_presentation) LIKE ? OR LOWER(b0_.year_established) LIKE ? OR LOWER(b0_.service_photo_1) LIKE ? OR LOWER(b0_.service_photo_2) LIKE ? OR LOWER(b0_.service_photo_3) LIKE ? OR LOWER(b0_.service_photo_4) LIKE ? OR LOWER(b0_.service_photo_5) LIKE ? OR LOWER(b0_.service_photo_6) LIKE ? OR LOWER(b0_.documentations_catalogs) LIKE ? OR LOWER(b0_.company_references) LIKE ? OR LOWER(b0_.video_entreprise) LIKE ? OR LOWER(b0_.facebook) LIKE ? OR LOWER(b0_.youtube) LIKE ? OR LOWER(b0_.maps) LIKE ? OR LOWER(b0_.banner) LIKE ? OR LOWER(b0_.add_date) LIKE ? OR LOWER(b0_.maquette) LIKE ?) LIMIT 20
Parameters:
[ "%bisco%" "%bisco%" "%bisco%" "%bisco%" "%bisco%" "%bisco%" "%bisco%" "%bisco%" "%bisco%" "%bisco%" "%bisco%" "%bisco%" "%bisco%" "%bisco%" "%bisco%" "%bisco%" "%bisco%" "%bisco%" "%bisco%" "%bisco%" "%bisco%" "%bisco%" "%bisco%" "%bisco%" "%bisco%" "%bisco%" "%bisco%" "%bisco%" "%bisco%" "%bisco%" "%bisco%" "%bisco%" "%bisco%" "%bisco%" "%bisco%" "%bisco%" "%bisco%" "%bisco%" "%fruits%" "%fruits%" "%fruits%" "%fruits%" "%fruits%" "%fruits%" "%fruits%" "%fruits%" "%fruits%" "%fruits%" "%fruits%" "%fruits%" "%fruits%" "%fruits%" "%fruits%" "%fruits%" "%fruits%" "%fruits%" "%fruits%" "%fruits%" "%fruits%" "%fruits%" "%fruits%" "%fruits%" "%fruits%" "%fruits%" "%fruits%" "%fruits%" "%fruits%" "%fruits%" "%fruits%" "%fruits%" "%fruits%" "%fruits%" "%fruits%" "%fruits%" "%fruits%" "%fruits%" ] |
|
929.71 ms (49.04%) |
1 |
SELECT COUNT(b0_.id) AS sclr_0 FROM business_information b0_ WHERE (LOWER(b0_.id) LIKE ? OR LOWER(b0_.business_name) LIKE ? OR LOWER(b0_.street_address) LIKE ? OR LOWER(b0_.state) LIKE ? OR LOWER(b0_.fixe_phone) LIKE ? OR LOWER(b0_.fax_number) LIKE ? OR LOWER(b0_.mobile) LIKE ? OR LOWER(b0_.email) LIKE ? OR LOWER(b0_.website) LIKE ? OR LOWER(b0_.categories) LIKE ? OR LOWER(b0_.logo) LIKE ? OR LOWER(b0_.city) LIKE ? OR LOWER(b0_.description) LIKE ? OR LOWER(b0_.contact_name) LIKE ? OR LOWER(b0_.business_title) LIKE ? OR LOWER(b0_.custmer_type) LIKE ? OR LOWER(b0_.key_words) LIKE ? OR LOWER(b0_.general_info) LIKE ? OR LOWER(b0_.created_by) LIKE ? OR LOWER(b0_.statut) LIKE ? OR LOWER(b0_.created_date) LIKE ? OR LOWER(b0_.company_presentation) LIKE ? OR LOWER(b0_.year_established) LIKE ? OR LOWER(b0_.service_photo_1) LIKE ? OR LOWER(b0_.service_photo_2) LIKE ? OR LOWER(b0_.service_photo_3) LIKE ? OR LOWER(b0_.service_photo_4) LIKE ? OR LOWER(b0_.service_photo_5) LIKE ? OR LOWER(b0_.service_photo_6) LIKE ? OR LOWER(b0_.documentations_catalogs) LIKE ? OR LOWER(b0_.company_references) LIKE ? OR LOWER(b0_.video_entreprise) LIKE ? OR LOWER(b0_.facebook) LIKE ? OR LOWER(b0_.youtube) LIKE ? OR LOWER(b0_.maps) LIKE ? OR LOWER(b0_.banner) LIKE ? OR LOWER(b0_.add_date) LIKE ? OR LOWER(b0_.maquette) LIKE ?) AND (LOWER(b0_.id) LIKE ? OR LOWER(b0_.business_name) LIKE ? OR LOWER(b0_.street_address) LIKE ? OR LOWER(b0_.state) LIKE ? OR LOWER(b0_.fixe_phone) LIKE ? OR LOWER(b0_.fax_number) LIKE ? OR LOWER(b0_.mobile) LIKE ? OR LOWER(b0_.email) LIKE ? OR LOWER(b0_.website) LIKE ? OR LOWER(b0_.categories) LIKE ? OR LOWER(b0_.logo) LIKE ? OR LOWER(b0_.city) LIKE ? OR LOWER(b0_.description) LIKE ? OR LOWER(b0_.contact_name) LIKE ? OR LOWER(b0_.business_title) LIKE ? OR LOWER(b0_.custmer_type) LIKE ? OR LOWER(b0_.key_words) LIKE ? OR LOWER(b0_.general_info) LIKE ? OR LOWER(b0_.created_by) LIKE ? OR LOWER(b0_.statut) LIKE ? OR LOWER(b0_.created_date) LIKE ? OR LOWER(b0_.company_presentation) LIKE ? OR LOWER(b0_.year_established) LIKE ? OR LOWER(b0_.service_photo_1) LIKE ? OR LOWER(b0_.service_photo_2) LIKE ? OR LOWER(b0_.service_photo_3) LIKE ? OR LOWER(b0_.service_photo_4) LIKE ? OR LOWER(b0_.service_photo_5) LIKE ? OR LOWER(b0_.service_photo_6) LIKE ? OR LOWER(b0_.documentations_catalogs) LIKE ? OR LOWER(b0_.company_references) LIKE ? OR LOWER(b0_.video_entreprise) LIKE ? OR LOWER(b0_.facebook) LIKE ? OR LOWER(b0_.youtube) LIKE ? OR LOWER(b0_.maps) LIKE ? OR LOWER(b0_.banner) LIKE ? OR LOWER(b0_.add_date) LIKE ? OR LOWER(b0_.maquette) LIKE ?)
Parameters:
[ "%bisco%" "%bisco%" "%bisco%" "%bisco%" "%bisco%" "%bisco%" "%bisco%" "%bisco%" "%bisco%" "%bisco%" "%bisco%" "%bisco%" "%bisco%" "%bisco%" "%bisco%" "%bisco%" "%bisco%" "%bisco%" "%bisco%" "%bisco%" "%bisco%" "%bisco%" "%bisco%" "%bisco%" "%bisco%" "%bisco%" "%bisco%" "%bisco%" "%bisco%" "%bisco%" "%bisco%" "%bisco%" "%bisco%" "%bisco%" "%bisco%" "%bisco%" "%bisco%" "%bisco%" "%fruits%" "%fruits%" "%fruits%" "%fruits%" "%fruits%" "%fruits%" "%fruits%" "%fruits%" "%fruits%" "%fruits%" "%fruits%" "%fruits%" "%fruits%" "%fruits%" "%fruits%" "%fruits%" "%fruits%" "%fruits%" "%fruits%" "%fruits%" "%fruits%" "%fruits%" "%fruits%" "%fruits%" "%fruits%" "%fruits%" "%fruits%" "%fruits%" "%fruits%" "%fruits%" "%fruits%" "%fruits%" "%fruits%" "%fruits%" "%fruits%" "%fruits%" "%fruits%" "%fruits%" ] |
|
2.99 ms (0.16%) |
1 |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.firstname AS firstname_5, t0.lastname AS lastname_6 FROM user t0 WHERE t0.id = ?
Parameters:
[
8
]
|
|
1.18 ms (0.06%) |
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_.description AS description_12, b0_.contact_name AS contact_name_13, b0_.business_title AS business_title_14, b0_.custmer_type AS custmer_type_15, b0_.key_words AS key_words_16, b0_.general_info AS general_info_17, b0_.created_by AS created_by_18, b0_.statut AS statut_19, b0_.created_date AS created_date_20, b0_.company_presentation AS company_presentation_21, b0_.year_established AS year_established_22, b0_.service_photo_1 AS service_photo_1_23, b0_.service_photo_2 AS service_photo_2_24, b0_.service_photo_3 AS service_photo_3_25, b0_.service_photo_4 AS service_photo_4_26, b0_.service_photo_5 AS service_photo_5_27, b0_.service_photo_6 AS service_photo_6_28, b0_.documentations_catalogs AS documentations_catalogs_29, b0_.company_references AS company_references_30, b0_.video_entreprise AS video_entreprise_31, b0_.facebook AS facebook_32, b0_.youtube AS youtube_33, b0_.maps AS maps_34, b0_.banner AS banner_35, b0_.add_date AS add_date_36, b0_.maquette AS maquette_37, b0_.alaune AS alaune_38 FROM business_information b0_ WHERE (LOWER(b0_.id) LIKE ? OR LOWER(b0_.business_name) LIKE ? OR LOWER(b0_.street_address) LIKE ? OR LOWER(b0_.state) LIKE ? OR LOWER(b0_.fixe_phone) LIKE ? OR LOWER(b0_.fax_number) LIKE ? OR LOWER(b0_.mobile) LIKE ? OR LOWER(b0_.email) LIKE ? OR LOWER(b0_.website) LIKE ? OR LOWER(b0_.categories) LIKE ? OR LOWER(b0_.logo) LIKE ? OR LOWER(b0_.city) LIKE ? OR LOWER(b0_.description) LIKE ? OR LOWER(b0_.contact_name) LIKE ? OR LOWER(b0_.business_title) LIKE ? OR LOWER(b0_.custmer_type) LIKE ? OR LOWER(b0_.key_words) LIKE ? OR LOWER(b0_.general_info) LIKE ? OR LOWER(b0_.created_by) LIKE ? OR LOWER(b0_.statut) LIKE ? OR LOWER(b0_.created_date) LIKE ? OR LOWER(b0_.company_presentation) LIKE ? OR LOWER(b0_.year_established) LIKE ? OR LOWER(b0_.service_photo_1) LIKE ? OR LOWER(b0_.service_photo_2) LIKE ? OR LOWER(b0_.service_photo_3) LIKE ? OR LOWER(b0_.service_photo_4) LIKE ? OR LOWER(b0_.service_photo_5) LIKE ? OR LOWER(b0_.service_photo_6) LIKE ? OR LOWER(b0_.documentations_catalogs) LIKE ? OR LOWER(b0_.company_references) LIKE ? OR LOWER(b0_.video_entreprise) LIKE ? OR LOWER(b0_.facebook) LIKE ? OR LOWER(b0_.youtube) LIKE ? OR LOWER(b0_.maps) LIKE ? OR LOWER(b0_.banner) LIKE ? OR LOWER(b0_.add_date) LIKE ? OR LOWER(b0_.maquette) LIKE ?) AND (LOWER(b0_.id) LIKE ? OR LOWER(b0_.business_name) LIKE ? OR LOWER(b0_.street_address) LIKE ? OR LOWER(b0_.state) LIKE ? OR LOWER(b0_.fixe_phone) LIKE ? OR LOWER(b0_.fax_number) LIKE ? OR LOWER(b0_.mobile) LIKE ? OR LOWER(b0_.email) LIKE ? OR LOWER(b0_.website) LIKE ? OR LOWER(b0_.categories) LIKE ? OR LOWER(b0_.logo) LIKE ? OR LOWER(b0_.city) LIKE ? OR LOWER(b0_.description) LIKE ? OR LOWER(b0_.contact_name) LIKE ? OR LOWER(b0_.business_title) LIKE ? OR LOWER(b0_.custmer_type) LIKE ? OR LOWER(b0_.key_words) LIKE ? OR LOWER(b0_.general_info) LIKE ? OR LOWER(b0_.created_by) LIKE ? OR LOWER(b0_.statut) LIKE ? OR LOWER(b0_.created_date) LIKE ? OR LOWER(b0_.company_presentation) LIKE ? OR LOWER(b0_.year_established) LIKE ? OR LOWER(b0_.service_photo_1) LIKE ? OR LOWER(b0_.service_photo_2) LIKE ? OR LOWER(b0_.service_photo_3) LIKE ? OR LOWER(b0_.service_photo_4) LIKE ? OR LOWER(b0_.service_photo_5) LIKE ? OR LOWER(b0_.service_photo_6) LIKE ? OR LOWER(b0_.documentations_catalogs) LIKE ? OR LOWER(b0_.company_references) LIKE ? OR LOWER(b0_.video_entreprise) LIKE ? OR LOWER(b0_.facebook) LIKE ? OR LOWER(b0_.youtube) LIKE ? OR LOWER(b0_.maps) LIKE ? OR LOWER(b0_.banner) LIKE ? OR LOWER(b0_.add_date) LIKE ? OR LOWER(b0_.maquette) LIKE ?) AND b0_.id IN (?)
Parameters:
[ "%bisco%" "%bisco%" "%bisco%" "%bisco%" "%bisco%" "%bisco%" "%bisco%" "%bisco%" "%bisco%" "%bisco%" "%bisco%" "%bisco%" "%bisco%" "%bisco%" "%bisco%" "%bisco%" "%bisco%" "%bisco%" "%bisco%" "%bisco%" "%bisco%" "%bisco%" "%bisco%" "%bisco%" "%bisco%" "%bisco%" "%bisco%" "%bisco%" "%bisco%" "%bisco%" "%bisco%" "%bisco%" "%bisco%" "%bisco%" "%bisco%" "%bisco%" "%bisco%" "%bisco%" "%fruits%" "%fruits%" "%fruits%" "%fruits%" "%fruits%" "%fruits%" "%fruits%" "%fruits%" "%fruits%" "%fruits%" "%fruits%" "%fruits%" "%fruits%" "%fruits%" "%fruits%" "%fruits%" "%fruits%" "%fruits%" "%fruits%" "%fruits%" "%fruits%" "%fruits%" "%fruits%" "%fruits%" "%fruits%" "%fruits%" "%fruits%" "%fruits%" "%fruits%" "%fruits%" "%fruits%" "%fruits%" "%fruits%" "%fruits%" "%fruits%" "%fruits%" "%fruits%" "%fruits%" 1269 ] |
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\User | No errors. |
| App\Entity\BusinessInformation | No errors. |