Symfony Profiler

Query Metrics

3 Database Queries

2 Different statements

4.14 ms Query time

0 Invalid entities

Queries

Group similar statements

#▲	Time	Info
1	0.56 ms	SELECT t0.id AS id_1, t0.url_desidered AS url_desidered_2, t0.url_to_go AS url_to_go_3, t0.content AS content_4, t0.content_secondary AS content_secondary_5, t0.h1 AS h1_6, t0.h1_align AS h1_align_7, t0.h2 AS h2_8, t0.h2_align AS h2_align_9, t0.seo_title AS seo_title_10, t0.seo_description AS seo_description_11, t0.date_create AS date_create_12, t0.date_last_update AS date_last_update_13 FROM custom_search t0 WHERE t0.url_desidered = ? LIMIT 1 Parameters: [`"/tools/lightGallery/js/'+h+'"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.url_desidered AS url_desidered_2, t0.url_to_go AS url_to_go_3, t0.content AS content_4, t0.content_secondary AS content_secondary_5, t0.h1 AS h1_6, t0.h1_align AS h1_align_7, t0.h2 AS h2_8, t0.h2_align AS h2_align_9, t0.seo_title AS seo_title_10, t0.seo_description AS seo_description_11, t0.date_create AS date_create_12, t0.date_last_update AS date_last_update_13 FROM custom_search t0 WHERE t0.url_desidered = ? LIMIT 1 SELECT t0.id AS id_1, t0.url_desidered AS url_desidered_2, t0.url_to_go AS url_to_go_3, t0.content AS content_4, t0.content_secondary AS content_secondary_5, t0.h1 AS h1_6, t0.h1_align AS h1_align_7, t0.h2 AS h2_8, t0.h2_align AS h2_align_9, t0.seo_title AS seo_title_10, t0.seo_description AS seo_description_11, t0.date_create AS date_create_12, t0.date_last_update AS date_last_update_13 FROM custom_search t0 WHERE t0.url_desidered = '/tools/lightGallery/js/\'+h+\'' LIMIT 1;
2	1.90 ms	SELECT r0_.id AS id_0, r0_.source_host AS source_host_1, r0_.source_path AS source_path_2, r0_.redirect_url AS redirect_url_3, r0_.redirect_status_code AS redirect_status_code_4, r0_.strict_trailing_slash AS strict_trailing_slash_5, r0_.strict_url_query AS strict_url_query_6, r0_.redirect_count AS redirect_count_7, r0_.last_redirect AS last_redirect_8 FROM redirector_mapping r0_ WHERE r0_.source_host = ? AND (((r0_.strict_trailing_slash = 0 OR r0_.strict_trailing_slash IS NULL) AND (r0_.strict_url_query = 0 OR r0_.strict_url_query IS NULL) AND (r0_.source_path = ? OR r0_.source_path = ?)) OR (r0_.strict_trailing_slash = 1 AND (r0_.strict_url_query = 0 OR r0_.strict_url_query IS NULL) AND (r0_.source_path = ?)) OR ((r0_.strict_trailing_slash = 0 OR r0_.strict_trailing_slash IS NULL) AND r0_.strict_url_query = 1 AND (r0_.source_path = ? OR r0_.source_path = ?)) OR (r0_.strict_trailing_slash = 1 AND r0_.strict_url_query = 1 AND (r0_.source_path = ?))) Parameters: [`"rent.gruppobossoni.wi-staging.it" "/tools/lightGallery/js/'+h+'/" "/tools/lightGallery/js/'+h+'" "/tools/lightGallery/js/'+h+'" "/tools/lightGallery/js/'+h+'/?" "/tools/lightGallery/js/'+h+'?" "/tools/lightGallery/js/'+h+'?"`] View formatted query View runnable query Explain query SELECT r0_.id AS id_0, r0_.source_host AS source_host_1, r0_.source_path AS source_path_2, r0_.redirect_url AS redirect_url_3, r0_.redirect_status_code AS redirect_status_code_4, r0_.strict_trailing_slash AS strict_trailing_slash_5, r0_.strict_url_query AS strict_url_query_6, r0_.redirect_count AS redirect_count_7, r0_.last_redirect AS last_redirect_8 FROM redirector_mapping r0_ WHERE r0_.source_host = ? AND ( ( ( r0_.strict_trailing_slash = 0 OR r0_.strict_trailing_slash IS NULL ) AND ( r0_.strict_url_query = 0 OR r0_.strict_url_query IS NULL ) AND ( r0_.source_path = ? OR r0_.source_path = ? ) ) OR ( r0_.strict_trailing_slash = 1 AND ( r0_.strict_url_query = 0 OR r0_.strict_url_query IS NULL ) AND (r0_.source_path = ?) ) OR ( ( r0_.strict_trailing_slash = 0 OR r0_.strict_trailing_slash IS NULL ) AND r0_.strict_url_query = 1 AND ( r0_.source_path = ? OR r0_.source_path = ? ) ) OR ( r0_.strict_trailing_slash = 1 AND r0_.strict_url_query = 1 AND (r0_.source_path = ?) ) ) SELECT r0_.id AS id_0, r0_.source_host AS source_host_1, r0_.source_path AS source_path_2, r0_.redirect_url AS redirect_url_3, r0_.redirect_status_code AS redirect_status_code_4, r0_.strict_trailing_slash AS strict_trailing_slash_5, r0_.strict_url_query AS strict_url_query_6, r0_.redirect_count AS redirect_count_7, r0_.last_redirect AS last_redirect_8 FROM redirector_mapping r0_ WHERE r0_.source_host = 'rent.gruppobossoni.wi-staging.it' AND (((r0_.strict_trailing_slash = 0 OR r0_.strict_trailing_slash IS NULL) AND (r0_.strict_url_query = 0 OR r0_.strict_url_query IS NULL) AND (r0_.source_path = '/tools/lightGallery/js/\'+h+\'/' OR r0_.source_path = '/tools/lightGallery/js/\'+h+\'')) OR (r0_.strict_trailing_slash = 1 AND (r0_.strict_url_query = 0 OR r0_.strict_url_query IS NULL) AND (r0_.source_path = '/tools/lightGallery/js/\'+h+\'')) OR ((r0_.strict_trailing_slash = 0 OR r0_.strict_trailing_slash IS NULL) AND r0_.strict_url_query = 1 AND (r0_.source_path = '/tools/lightGallery/js/\'+h+\'/?' OR r0_.source_path = '/tools/lightGallery/js/\'+h+\'?')) OR (r0_.strict_trailing_slash = 1 AND r0_.strict_url_query = 1 AND (r0_.source_path = '/tools/lightGallery/js/\'+h+\'?')));
3	1.68 ms	SELECT r0_.id AS id_0, r0_.source_host AS source_host_1, r0_.source_path AS source_path_2, r0_.redirect_url AS redirect_url_3, r0_.redirect_status_code AS redirect_status_code_4, r0_.strict_trailing_slash AS strict_trailing_slash_5, r0_.strict_url_query AS strict_url_query_6, r0_.redirect_count AS redirect_count_7, r0_.last_redirect AS last_redirect_8 FROM redirector_mapping r0_ WHERE r0_.source_host = ? AND (((r0_.strict_trailing_slash = 0 OR r0_.strict_trailing_slash IS NULL) AND (r0_.strict_url_query = 0 OR r0_.strict_url_query IS NULL) AND (r0_.source_path = ? OR r0_.source_path = ?)) OR (r0_.strict_trailing_slash = 1 AND (r0_.strict_url_query = 0 OR r0_.strict_url_query IS NULL) AND (r0_.source_path = ?)) OR ((r0_.strict_trailing_slash = 0 OR r0_.strict_trailing_slash IS NULL) AND r0_.strict_url_query = 1 AND (r0_.source_path = ? OR r0_.source_path = ?)) OR (r0_.strict_trailing_slash = 1 AND r0_.strict_url_query = 1 AND (r0_.source_path = ?))) Parameters: [`"rent.gruppobossoni.wi-staging.it" "/tools/lightGallery/js/'+h+'/" "/tools/lightGallery/js/'+h+'" "/tools/lightGallery/js/'+h+'" "/tools/lightGallery/js/'+h+'/?" "/tools/lightGallery/js/'+h+'?" "/tools/lightGallery/js/'+h+'?"`] View formatted query View runnable query Explain query SELECT r0_.id AS id_0, r0_.source_host AS source_host_1, r0_.source_path AS source_path_2, r0_.redirect_url AS redirect_url_3, r0_.redirect_status_code AS redirect_status_code_4, r0_.strict_trailing_slash AS strict_trailing_slash_5, r0_.strict_url_query AS strict_url_query_6, r0_.redirect_count AS redirect_count_7, r0_.last_redirect AS last_redirect_8 FROM redirector_mapping r0_ WHERE r0_.source_host = ? AND ( ( ( r0_.strict_trailing_slash = 0 OR r0_.strict_trailing_slash IS NULL ) AND ( r0_.strict_url_query = 0 OR r0_.strict_url_query IS NULL ) AND ( r0_.source_path = ? OR r0_.source_path = ? ) ) OR ( r0_.strict_trailing_slash = 1 AND ( r0_.strict_url_query = 0 OR r0_.strict_url_query IS NULL ) AND (r0_.source_path = ?) ) OR ( ( r0_.strict_trailing_slash = 0 OR r0_.strict_trailing_slash IS NULL ) AND r0_.strict_url_query = 1 AND ( r0_.source_path = ? OR r0_.source_path = ? ) ) OR ( r0_.strict_trailing_slash = 1 AND r0_.strict_url_query = 1 AND (r0_.source_path = ?) ) ) SELECT r0_.id AS id_0, r0_.source_host AS source_host_1, r0_.source_path AS source_path_2, r0_.redirect_url AS redirect_url_3, r0_.redirect_status_code AS redirect_status_code_4, r0_.strict_trailing_slash AS strict_trailing_slash_5, r0_.strict_url_query AS strict_url_query_6, r0_.redirect_count AS redirect_count_7, r0_.last_redirect AS last_redirect_8 FROM redirector_mapping r0_ WHERE r0_.source_host = 'rent.gruppobossoni.wi-staging.it' AND (((r0_.strict_trailing_slash = 0 OR r0_.strict_trailing_slash IS NULL) AND (r0_.strict_url_query = 0 OR r0_.strict_url_query IS NULL) AND (r0_.source_path = '/tools/lightGallery/js/\'+h+\'/' OR r0_.source_path = '/tools/lightGallery/js/\'+h+\'')) OR (r0_.strict_trailing_slash = 1 AND (r0_.strict_url_query = 0 OR r0_.strict_url_query IS NULL) AND (r0_.source_path = '/tools/lightGallery/js/\'+h+\'')) OR ((r0_.strict_trailing_slash = 0 OR r0_.strict_trailing_slash IS NULL) AND r0_.strict_url_query = 1 AND (r0_.source_path = '/tools/lightGallery/js/\'+h+\'/?' OR r0_.source_path = '/tools/lightGallery/js/\'+h+\'?')) OR (r0_.strict_trailing_slash = 1 AND r0_.strict_url_query = 1 AND (r0_.source_path = '/tools/lightGallery/js/\'+h+\'?')));

#▲

Time

Info

0.56 ms

SELECT t0.id AS id_1, t0.url_desidered AS url_desidered_2, t0.url_to_go AS url_to_go_3, t0.content AS content_4, t0.content_secondary AS content_secondary_5, t0.h1 AS h1_6, t0.h1_align AS h1_align_7, t0.h2 AS h2_8, t0.h2_align AS h2_align_9, t0.seo_title AS seo_title_10, t0.seo_description AS seo_description_11, t0.date_create AS date_create_12, t0.date_last_update AS date_last_update_13 FROM custom_search t0 WHERE t0.url_desidered = ? LIMIT 1

Parameters:

[
  "/tools/lightGallery/js/'+h+'"
]

View formatted query View runnable query Explain query

SELECT
  t0.id AS id_1,
  t0.url_desidered AS url_desidered_2,
  t0.url_to_go AS url_to_go_3,
  t0.content AS content_4,
  t0.content_secondary AS content_secondary_5,
  t0.h1 AS h1_6,
  t0.h1_align AS h1_align_7,
  t0.h2 AS h2_8,
  t0.h2_align AS h2_align_9,
  t0.seo_title AS seo_title_10,
  t0.seo_description AS seo_description_11,
  t0.date_create AS date_create_12,
  t0.date_last_update AS date_last_update_13
FROM
  custom_search t0
WHERE
  t0.url_desidered = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.url_desidered AS url_desidered_2, t0.url_to_go AS url_to_go_3, t0.content AS content_4, t0.content_secondary AS content_secondary_5, t0.h1 AS h1_6, t0.h1_align AS h1_align_7, t0.h2 AS h2_8, t0.h2_align AS h2_align_9, t0.seo_title AS seo_title_10, t0.seo_description AS seo_description_11, t0.date_create AS date_create_12, t0.date_last_update AS date_last_update_13 FROM custom_search t0 WHERE t0.url_desidered = '/tools/lightGallery/js/\'+h+\'' LIMIT 1;

1.90 ms

SELECT r0_.id AS id_0, r0_.source_host AS source_host_1, r0_.source_path AS source_path_2, r0_.redirect_url AS redirect_url_3, r0_.redirect_status_code AS redirect_status_code_4, r0_.strict_trailing_slash AS strict_trailing_slash_5, r0_.strict_url_query AS strict_url_query_6, r0_.redirect_count AS redirect_count_7, r0_.last_redirect AS last_redirect_8 FROM redirector_mapping r0_ WHERE r0_.source_host = ? AND (((r0_.strict_trailing_slash = 0 OR r0_.strict_trailing_slash IS NULL) AND (r0_.strict_url_query = 0 OR r0_.strict_url_query IS NULL) AND (r0_.source_path = ? OR r0_.source_path = ?)) OR (r0_.strict_trailing_slash = 1 AND (r0_.strict_url_query = 0 OR r0_.strict_url_query IS NULL) AND (r0_.source_path = ?)) OR ((r0_.strict_trailing_slash = 0 OR r0_.strict_trailing_slash IS NULL) AND r0_.strict_url_query = 1 AND (r0_.source_path = ? OR r0_.source_path = ?)) OR (r0_.strict_trailing_slash = 1 AND r0_.strict_url_query = 1 AND (r0_.source_path = ?)))

Parameters:

[
  "rent.gruppobossoni.wi-staging.it"
  "/tools/lightGallery/js/'+h+'/"
  "/tools/lightGallery/js/'+h+'"
  "/tools/lightGallery/js/'+h+'"
  "/tools/lightGallery/js/'+h+'/?"
  "/tools/lightGallery/js/'+h+'?"
  "/tools/lightGallery/js/'+h+'?"
]

View formatted query View runnable query Explain query

SELECT
  r0_.id AS id_0,
  r0_.source_host AS source_host_1,
  r0_.source_path AS source_path_2,
  r0_.redirect_url AS redirect_url_3,
  r0_.redirect_status_code AS redirect_status_code_4,
  r0_.strict_trailing_slash AS strict_trailing_slash_5,
  r0_.strict_url_query AS strict_url_query_6,
  r0_.redirect_count AS redirect_count_7,
  r0_.last_redirect AS last_redirect_8
FROM
  redirector_mapping r0_
WHERE
  r0_.source_host = ?
  AND (
    (
      (
        r0_.strict_trailing_slash = 0
        OR r0_.strict_trailing_slash IS NULL
      )
      AND (
        r0_.strict_url_query = 0
        OR r0_.strict_url_query IS NULL
      )
      AND (
        r0_.source_path = ?
        OR r0_.source_path = ?
      )
    )
    OR (
      r0_.strict_trailing_slash = 1
      AND (
        r0_.strict_url_query = 0
        OR r0_.strict_url_query IS NULL
      )
      AND (r0_.source_path = ?)
    )
    OR (
      (
        r0_.strict_trailing_slash = 0
        OR r0_.strict_trailing_slash IS NULL
      )
      AND r0_.strict_url_query = 1
      AND (
        r0_.source_path = ?
        OR r0_.source_path = ?
      )
    )
    OR (
      r0_.strict_trailing_slash = 1
      AND r0_.strict_url_query = 1
      AND (r0_.source_path = ?)
    )
  )

SELECT r0_.id AS id_0, r0_.source_host AS source_host_1, r0_.source_path AS source_path_2, r0_.redirect_url AS redirect_url_3, r0_.redirect_status_code AS redirect_status_code_4, r0_.strict_trailing_slash AS strict_trailing_slash_5, r0_.strict_url_query AS strict_url_query_6, r0_.redirect_count AS redirect_count_7, r0_.last_redirect AS last_redirect_8 FROM redirector_mapping r0_ WHERE r0_.source_host = 'rent.gruppobossoni.wi-staging.it' AND (((r0_.strict_trailing_slash = 0 OR r0_.strict_trailing_slash IS NULL) AND (r0_.strict_url_query = 0 OR r0_.strict_url_query IS NULL) AND (r0_.source_path = '/tools/lightGallery/js/\'+h+\'/' OR r0_.source_path = '/tools/lightGallery/js/\'+h+\'')) OR (r0_.strict_trailing_slash = 1 AND (r0_.strict_url_query = 0 OR r0_.strict_url_query IS NULL) AND (r0_.source_path = '/tools/lightGallery/js/\'+h+\'')) OR ((r0_.strict_trailing_slash = 0 OR r0_.strict_trailing_slash IS NULL) AND r0_.strict_url_query = 1 AND (r0_.source_path = '/tools/lightGallery/js/\'+h+\'/?' OR r0_.source_path = '/tools/lightGallery/js/\'+h+\'?')) OR (r0_.strict_trailing_slash = 1 AND r0_.strict_url_query = 1 AND (r0_.source_path = '/tools/lightGallery/js/\'+h+\'?')));

1.68 ms

SELECT r0_.id AS id_0, r0_.source_host AS source_host_1, r0_.source_path AS source_path_2, r0_.redirect_url AS redirect_url_3, r0_.redirect_status_code AS redirect_status_code_4, r0_.strict_trailing_slash AS strict_trailing_slash_5, r0_.strict_url_query AS strict_url_query_6, r0_.redirect_count AS redirect_count_7, r0_.last_redirect AS last_redirect_8 FROM redirector_mapping r0_ WHERE r0_.source_host = ? AND (((r0_.strict_trailing_slash = 0 OR r0_.strict_trailing_slash IS NULL) AND (r0_.strict_url_query = 0 OR r0_.strict_url_query IS NULL) AND (r0_.source_path = ? OR r0_.source_path = ?)) OR (r0_.strict_trailing_slash = 1 AND (r0_.strict_url_query = 0 OR r0_.strict_url_query IS NULL) AND (r0_.source_path = ?)) OR ((r0_.strict_trailing_slash = 0 OR r0_.strict_trailing_slash IS NULL) AND r0_.strict_url_query = 1 AND (r0_.source_path = ? OR r0_.source_path = ?)) OR (r0_.strict_trailing_slash = 1 AND r0_.strict_url_query = 1 AND (r0_.source_path = ?)))

Parameters:

[
  "rent.gruppobossoni.wi-staging.it"
  "/tools/lightGallery/js/'+h+'/"
  "/tools/lightGallery/js/'+h+'"
  "/tools/lightGallery/js/'+h+'"
  "/tools/lightGallery/js/'+h+'/?"
  "/tools/lightGallery/js/'+h+'?"
  "/tools/lightGallery/js/'+h+'?"
]

View formatted query View runnable query Explain query

SELECT
  r0_.id AS id_0,
  r0_.source_host AS source_host_1,
  r0_.source_path AS source_path_2,
  r0_.redirect_url AS redirect_url_3,
  r0_.redirect_status_code AS redirect_status_code_4,
  r0_.strict_trailing_slash AS strict_trailing_slash_5,
  r0_.strict_url_query AS strict_url_query_6,
  r0_.redirect_count AS redirect_count_7,
  r0_.last_redirect AS last_redirect_8
FROM
  redirector_mapping r0_
WHERE
  r0_.source_host = ?
  AND (
    (
      (
        r0_.strict_trailing_slash = 0
        OR r0_.strict_trailing_slash IS NULL
      )
      AND (
        r0_.strict_url_query = 0
        OR r0_.strict_url_query IS NULL
      )
      AND (
        r0_.source_path = ?
        OR r0_.source_path = ?
      )
    )
    OR (
      r0_.strict_trailing_slash = 1
      AND (
        r0_.strict_url_query = 0
        OR r0_.strict_url_query IS NULL
      )
      AND (r0_.source_path = ?)
    )
    OR (
      (
        r0_.strict_trailing_slash = 0
        OR r0_.strict_trailing_slash IS NULL
      )
      AND r0_.strict_url_query = 1
      AND (
        r0_.source_path = ?
        OR r0_.source_path = ?
      )
    )
    OR (
      r0_.strict_trailing_slash = 1
      AND r0_.strict_url_query = 1
      AND (r0_.source_path = ?)
    )
  )

SELECT r0_.id AS id_0, r0_.source_host AS source_host_1, r0_.source_path AS source_path_2, r0_.redirect_url AS redirect_url_3, r0_.redirect_status_code AS redirect_status_code_4, r0_.strict_trailing_slash AS strict_trailing_slash_5, r0_.strict_url_query AS strict_url_query_6, r0_.redirect_count AS redirect_count_7, r0_.last_redirect AS last_redirect_8 FROM redirector_mapping r0_ WHERE r0_.source_host = 'rent.gruppobossoni.wi-staging.it' AND (((r0_.strict_trailing_slash = 0 OR r0_.strict_trailing_slash IS NULL) AND (r0_.strict_url_query = 0 OR r0_.strict_url_query IS NULL) AND (r0_.source_path = '/tools/lightGallery/js/\'+h+\'/' OR r0_.source_path = '/tools/lightGallery/js/\'+h+\'')) OR (r0_.strict_trailing_slash = 1 AND (r0_.strict_url_query = 0 OR r0_.strict_url_query IS NULL) AND (r0_.source_path = '/tools/lightGallery/js/\'+h+\'')) OR ((r0_.strict_trailing_slash = 0 OR r0_.strict_trailing_slash IS NULL) AND r0_.strict_url_query = 1 AND (r0_.source_path = '/tools/lightGallery/js/\'+h+\'/?' OR r0_.source_path = '/tools/lightGallery/js/\'+h+\'?')) OR (r0_.strict_trailing_slash = 1 AND r0_.strict_url_query = 1 AND (r0_.source_path = '/tools/lightGallery/js/\'+h+\'?')));

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
IntranetBundle\Entity\CustomSearch	No errors.
RedirectorBundle\Entity\RedirectorMapping	No errors.

Symfony Profiler

GET http://rent.gruppobossoni.wi-staging.it/tools/lightGallery/js/'+h+'

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping