https://chilco.diig.cl/data/category.json

Query Metrics

37 Database Queries
4 Different statements
15.64 ms Query time
1 Invalid entities

Queries

Group similar statements

# Time Info
1 1.15 ms
SELECT t0.id AS id_1, t0.url_old AS url_old_2, t0.url_new AS url_new_3, t0.position AS position_4, t0.create_at AS create_at_5, t0.update_at AS update_at_6 FROM redirect t0 WHERE t0.url_old = ? LIMIT 1
Parameters:
[
  "/data/category.json"
]
2 0.79 ms
SELECT t0.id AS id_1, t0.public AS public_2, t0.name AS name_3, t0.slug AS slug_4, t0.position AS position_5, t0.create_at AS create_at_6, t0.update_at AS update_at_7, t0.image_id AS image_id_8, t0.general_category_id AS general_category_id_9, t0.seo_id AS seo_id_10 FROM product_category t0 ORDER BY t0.position ASC
Parameters:
[]
3 0.56 ms
SELECT t0.name AS name_1, t0.description AS description_2, t0.enabled AS enabled_3, t0.provider_name AS provider_name_4, t0.provider_status AS provider_status_5, t0.provider_reference AS provider_reference_6, t0.provider_metadata AS provider_metadata_7, t0.width AS width_8, t0.height AS height_9, t0.length AS length_10, t0.content_type AS content_type_11, t0.content_size AS content_size_12, t0.copyright AS copyright_13, t0.author_name AS author_name_14, t0.context AS context_15, t0.cdn_is_flushable AS cdn_is_flushable_16, t0.cdn_flush_identifier AS cdn_flush_identifier_17, t0.cdn_flush_at AS cdn_flush_at_18, t0.cdn_status AS cdn_status_19, t0.updated_at AS updated_at_20, t0.created_at AS created_at_21, t0.id AS id_22 FROM media__media t0 WHERE t0.id = ?
Parameters:
[
  571
]
4 0.37 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.keywords AS keywords_3, t0.description AS description_4, t0.create_at AS create_at_5, t0.share_image_id AS share_image_id_6 FROM seo t0 WHERE t0.id = ?
Parameters:
[
  7
]
5 0.49 ms
SELECT t0.name AS name_1, t0.description AS description_2, t0.enabled AS enabled_3, t0.provider_name AS provider_name_4, t0.provider_status AS provider_status_5, t0.provider_reference AS provider_reference_6, t0.provider_metadata AS provider_metadata_7, t0.width AS width_8, t0.height AS height_9, t0.length AS length_10, t0.content_type AS content_type_11, t0.content_size AS content_size_12, t0.copyright AS copyright_13, t0.author_name AS author_name_14, t0.context AS context_15, t0.cdn_is_flushable AS cdn_is_flushable_16, t0.cdn_flush_identifier AS cdn_flush_identifier_17, t0.cdn_flush_at AS cdn_flush_at_18, t0.cdn_status AS cdn_status_19, t0.updated_at AS updated_at_20, t0.created_at AS created_at_21, t0.id AS id_22 FROM media__media t0 WHERE t0.id = ?
Parameters:
[
  555
]
6 0.39 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.keywords AS keywords_3, t0.description AS description_4, t0.create_at AS create_at_5, t0.share_image_id AS share_image_id_6 FROM seo t0 WHERE t0.id = ?
Parameters:
[
  8
]
7 0.49 ms
SELECT t0.name AS name_1, t0.description AS description_2, t0.enabled AS enabled_3, t0.provider_name AS provider_name_4, t0.provider_status AS provider_status_5, t0.provider_reference AS provider_reference_6, t0.provider_metadata AS provider_metadata_7, t0.width AS width_8, t0.height AS height_9, t0.length AS length_10, t0.content_type AS content_type_11, t0.content_size AS content_size_12, t0.copyright AS copyright_13, t0.author_name AS author_name_14, t0.context AS context_15, t0.cdn_is_flushable AS cdn_is_flushable_16, t0.cdn_flush_identifier AS cdn_flush_identifier_17, t0.cdn_flush_at AS cdn_flush_at_18, t0.cdn_status AS cdn_status_19, t0.updated_at AS updated_at_20, t0.created_at AS created_at_21, t0.id AS id_22 FROM media__media t0 WHERE t0.id = ?
Parameters:
[
  575
]
8 0.35 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.keywords AS keywords_3, t0.description AS description_4, t0.create_at AS create_at_5, t0.share_image_id AS share_image_id_6 FROM seo t0 WHERE t0.id = ?
Parameters:
[
  27
]
9 0.42 ms
SELECT t0.name AS name_1, t0.description AS description_2, t0.enabled AS enabled_3, t0.provider_name AS provider_name_4, t0.provider_status AS provider_status_5, t0.provider_reference AS provider_reference_6, t0.provider_metadata AS provider_metadata_7, t0.width AS width_8, t0.height AS height_9, t0.length AS length_10, t0.content_type AS content_type_11, t0.content_size AS content_size_12, t0.copyright AS copyright_13, t0.author_name AS author_name_14, t0.context AS context_15, t0.cdn_is_flushable AS cdn_is_flushable_16, t0.cdn_flush_identifier AS cdn_flush_identifier_17, t0.cdn_flush_at AS cdn_flush_at_18, t0.cdn_status AS cdn_status_19, t0.updated_at AS updated_at_20, t0.created_at AS created_at_21, t0.id AS id_22 FROM media__media t0 WHERE t0.id = ?
Parameters:
[
  572
]
10 0.37 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.keywords AS keywords_3, t0.description AS description_4, t0.create_at AS create_at_5, t0.share_image_id AS share_image_id_6 FROM seo t0 WHERE t0.id = ?
Parameters:
[
  30
]
11 0.45 ms
SELECT t0.name AS name_1, t0.description AS description_2, t0.enabled AS enabled_3, t0.provider_name AS provider_name_4, t0.provider_status AS provider_status_5, t0.provider_reference AS provider_reference_6, t0.provider_metadata AS provider_metadata_7, t0.width AS width_8, t0.height AS height_9, t0.length AS length_10, t0.content_type AS content_type_11, t0.content_size AS content_size_12, t0.copyright AS copyright_13, t0.author_name AS author_name_14, t0.context AS context_15, t0.cdn_is_flushable AS cdn_is_flushable_16, t0.cdn_flush_identifier AS cdn_flush_identifier_17, t0.cdn_flush_at AS cdn_flush_at_18, t0.cdn_status AS cdn_status_19, t0.updated_at AS updated_at_20, t0.created_at AS created_at_21, t0.id AS id_22 FROM media__media t0 WHERE t0.id = ?
Parameters:
[
  576
]
12 0.35 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.keywords AS keywords_3, t0.description AS description_4, t0.create_at AS create_at_5, t0.share_image_id AS share_image_id_6 FROM seo t0 WHERE t0.id = ?
Parameters:
[
  32
]
13 0.39 ms
SELECT t0.name AS name_1, t0.description AS description_2, t0.enabled AS enabled_3, t0.provider_name AS provider_name_4, t0.provider_status AS provider_status_5, t0.provider_reference AS provider_reference_6, t0.provider_metadata AS provider_metadata_7, t0.width AS width_8, t0.height AS height_9, t0.length AS length_10, t0.content_type AS content_type_11, t0.content_size AS content_size_12, t0.copyright AS copyright_13, t0.author_name AS author_name_14, t0.context AS context_15, t0.cdn_is_flushable AS cdn_is_flushable_16, t0.cdn_flush_identifier AS cdn_flush_identifier_17, t0.cdn_flush_at AS cdn_flush_at_18, t0.cdn_status AS cdn_status_19, t0.updated_at AS updated_at_20, t0.created_at AS created_at_21, t0.id AS id_22 FROM media__media t0 WHERE t0.id = ?
Parameters:
[
  583
]
14 0.31 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.keywords AS keywords_3, t0.description AS description_4, t0.create_at AS create_at_5, t0.share_image_id AS share_image_id_6 FROM seo t0 WHERE t0.id = ?
Parameters:
[
  38
]
15 0.37 ms
SELECT t0.name AS name_1, t0.description AS description_2, t0.enabled AS enabled_3, t0.provider_name AS provider_name_4, t0.provider_status AS provider_status_5, t0.provider_reference AS provider_reference_6, t0.provider_metadata AS provider_metadata_7, t0.width AS width_8, t0.height AS height_9, t0.length AS length_10, t0.content_type AS content_type_11, t0.content_size AS content_size_12, t0.copyright AS copyright_13, t0.author_name AS author_name_14, t0.context AS context_15, t0.cdn_is_flushable AS cdn_is_flushable_16, t0.cdn_flush_identifier AS cdn_flush_identifier_17, t0.cdn_flush_at AS cdn_flush_at_18, t0.cdn_status AS cdn_status_19, t0.updated_at AS updated_at_20, t0.created_at AS created_at_21, t0.id AS id_22 FROM media__media t0 WHERE t0.id = ?
Parameters:
[
  582
]
16 0.30 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.keywords AS keywords_3, t0.description AS description_4, t0.create_at AS create_at_5, t0.share_image_id AS share_image_id_6 FROM seo t0 WHERE t0.id = ?
Parameters:
[
  40
]
17 0.33 ms
SELECT t0.name AS name_1, t0.description AS description_2, t0.enabled AS enabled_3, t0.provider_name AS provider_name_4, t0.provider_status AS provider_status_5, t0.provider_reference AS provider_reference_6, t0.provider_metadata AS provider_metadata_7, t0.width AS width_8, t0.height AS height_9, t0.length AS length_10, t0.content_type AS content_type_11, t0.content_size AS content_size_12, t0.copyright AS copyright_13, t0.author_name AS author_name_14, t0.context AS context_15, t0.cdn_is_flushable AS cdn_is_flushable_16, t0.cdn_flush_identifier AS cdn_flush_identifier_17, t0.cdn_flush_at AS cdn_flush_at_18, t0.cdn_status AS cdn_status_19, t0.updated_at AS updated_at_20, t0.created_at AS created_at_21, t0.id AS id_22 FROM media__media t0 WHERE t0.id = ?
Parameters:
[
  580
]
18 0.29 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.keywords AS keywords_3, t0.description AS description_4, t0.create_at AS create_at_5, t0.share_image_id AS share_image_id_6 FROM seo t0 WHERE t0.id = ?
Parameters:
[
  6
]
19 0.32 ms
SELECT t0.name AS name_1, t0.description AS description_2, t0.enabled AS enabled_3, t0.provider_name AS provider_name_4, t0.provider_status AS provider_status_5, t0.provider_reference AS provider_reference_6, t0.provider_metadata AS provider_metadata_7, t0.width AS width_8, t0.height AS height_9, t0.length AS length_10, t0.content_type AS content_type_11, t0.content_size AS content_size_12, t0.copyright AS copyright_13, t0.author_name AS author_name_14, t0.context AS context_15, t0.cdn_is_flushable AS cdn_is_flushable_16, t0.cdn_flush_identifier AS cdn_flush_identifier_17, t0.cdn_flush_at AS cdn_flush_at_18, t0.cdn_status AS cdn_status_19, t0.updated_at AS updated_at_20, t0.created_at AS created_at_21, t0.id AS id_22 FROM media__media t0 WHERE t0.id = ?
Parameters:
[
  579
]
20 0.51 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.keywords AS keywords_3, t0.description AS description_4, t0.create_at AS create_at_5, t0.share_image_id AS share_image_id_6 FROM seo t0 WHERE t0.id = ?
Parameters:
[
  49
]
21 0.34 ms
SELECT t0.name AS name_1, t0.description AS description_2, t0.enabled AS enabled_3, t0.provider_name AS provider_name_4, t0.provider_status AS provider_status_5, t0.provider_reference AS provider_reference_6, t0.provider_metadata AS provider_metadata_7, t0.width AS width_8, t0.height AS height_9, t0.length AS length_10, t0.content_type AS content_type_11, t0.content_size AS content_size_12, t0.copyright AS copyright_13, t0.author_name AS author_name_14, t0.context AS context_15, t0.cdn_is_flushable AS cdn_is_flushable_16, t0.cdn_flush_identifier AS cdn_flush_identifier_17, t0.cdn_flush_at AS cdn_flush_at_18, t0.cdn_status AS cdn_status_19, t0.updated_at AS updated_at_20, t0.created_at AS created_at_21, t0.id AS id_22 FROM media__media t0 WHERE t0.id = ?
Parameters:
[
  578
]
22 0.28 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.keywords AS keywords_3, t0.description AS description_4, t0.create_at AS create_at_5, t0.share_image_id AS share_image_id_6 FROM seo t0 WHERE t0.id = ?
Parameters:
[
  51
]
23 0.26 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.keywords AS keywords_3, t0.description AS description_4, t0.create_at AS create_at_5, t0.share_image_id AS share_image_id_6 FROM seo t0 WHERE t0.id = ?
Parameters:
[
  60
]
24 0.33 ms
SELECT t0.name AS name_1, t0.description AS description_2, t0.enabled AS enabled_3, t0.provider_name AS provider_name_4, t0.provider_status AS provider_status_5, t0.provider_reference AS provider_reference_6, t0.provider_metadata AS provider_metadata_7, t0.width AS width_8, t0.height AS height_9, t0.length AS length_10, t0.content_type AS content_type_11, t0.content_size AS content_size_12, t0.copyright AS copyright_13, t0.author_name AS author_name_14, t0.context AS context_15, t0.cdn_is_flushable AS cdn_is_flushable_16, t0.cdn_flush_identifier AS cdn_flush_identifier_17, t0.cdn_flush_at AS cdn_flush_at_18, t0.cdn_status AS cdn_status_19, t0.updated_at AS updated_at_20, t0.created_at AS created_at_21, t0.id AS id_22 FROM media__media t0 WHERE t0.id = ?
Parameters:
[
  564
]
25 0.26 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.keywords AS keywords_3, t0.description AS description_4, t0.create_at AS create_at_5, t0.share_image_id AS share_image_id_6 FROM seo t0 WHERE t0.id = ?
Parameters:
[
  66
]
26 0.35 ms
SELECT t0.name AS name_1, t0.description AS description_2, t0.enabled AS enabled_3, t0.provider_name AS provider_name_4, t0.provider_status AS provider_status_5, t0.provider_reference AS provider_reference_6, t0.provider_metadata AS provider_metadata_7, t0.width AS width_8, t0.height AS height_9, t0.length AS length_10, t0.content_type AS content_type_11, t0.content_size AS content_size_12, t0.copyright AS copyright_13, t0.author_name AS author_name_14, t0.context AS context_15, t0.cdn_is_flushable AS cdn_is_flushable_16, t0.cdn_flush_identifier AS cdn_flush_identifier_17, t0.cdn_flush_at AS cdn_flush_at_18, t0.cdn_status AS cdn_status_19, t0.updated_at AS updated_at_20, t0.created_at AS created_at_21, t0.id AS id_22 FROM media__media t0 WHERE t0.id = ?
Parameters:
[
  574
]
27 0.26 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.keywords AS keywords_3, t0.description AS description_4, t0.create_at AS create_at_5, t0.share_image_id AS share_image_id_6 FROM seo t0 WHERE t0.id = ?
Parameters:
[
  68
]
28 0.40 ms
SELECT t0.name AS name_1, t0.description AS description_2, t0.enabled AS enabled_3, t0.provider_name AS provider_name_4, t0.provider_status AS provider_status_5, t0.provider_reference AS provider_reference_6, t0.provider_metadata AS provider_metadata_7, t0.width AS width_8, t0.height AS height_9, t0.length AS length_10, t0.content_type AS content_type_11, t0.content_size AS content_size_12, t0.copyright AS copyright_13, t0.author_name AS author_name_14, t0.context AS context_15, t0.cdn_is_flushable AS cdn_is_flushable_16, t0.cdn_flush_identifier AS cdn_flush_identifier_17, t0.cdn_flush_at AS cdn_flush_at_18, t0.cdn_status AS cdn_status_19, t0.updated_at AS updated_at_20, t0.created_at AS created_at_21, t0.id AS id_22 FROM media__media t0 WHERE t0.id = ?
Parameters:
[
  577
]
29 0.35 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.keywords AS keywords_3, t0.description AS description_4, t0.create_at AS create_at_5, t0.share_image_id AS share_image_id_6 FROM seo t0 WHERE t0.id = ?
Parameters:
[
  76
]
30 0.44 ms
SELECT t0.name AS name_1, t0.description AS description_2, t0.enabled AS enabled_3, t0.provider_name AS provider_name_4, t0.provider_status AS provider_status_5, t0.provider_reference AS provider_reference_6, t0.provider_metadata AS provider_metadata_7, t0.width AS width_8, t0.height AS height_9, t0.length AS length_10, t0.content_type AS content_type_11, t0.content_size AS content_size_12, t0.copyright AS copyright_13, t0.author_name AS author_name_14, t0.context AS context_15, t0.cdn_is_flushable AS cdn_is_flushable_16, t0.cdn_flush_identifier AS cdn_flush_identifier_17, t0.cdn_flush_at AS cdn_flush_at_18, t0.cdn_status AS cdn_status_19, t0.updated_at AS updated_at_20, t0.created_at AS created_at_21, t0.id AS id_22 FROM media__media t0 WHERE t0.id = ?
Parameters:
[
  581
]
31 0.35 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.keywords AS keywords_3, t0.description AS description_4, t0.create_at AS create_at_5, t0.share_image_id AS share_image_id_6 FROM seo t0 WHERE t0.id = ?
Parameters:
[
  80
]
32 0.41 ms
SELECT t0.name AS name_1, t0.description AS description_2, t0.enabled AS enabled_3, t0.provider_name AS provider_name_4, t0.provider_status AS provider_status_5, t0.provider_reference AS provider_reference_6, t0.provider_metadata AS provider_metadata_7, t0.width AS width_8, t0.height AS height_9, t0.length AS length_10, t0.content_type AS content_type_11, t0.content_size AS content_size_12, t0.copyright AS copyright_13, t0.author_name AS author_name_14, t0.context AS context_15, t0.cdn_is_flushable AS cdn_is_flushable_16, t0.cdn_flush_identifier AS cdn_flush_identifier_17, t0.cdn_flush_at AS cdn_flush_at_18, t0.cdn_status AS cdn_status_19, t0.updated_at AS updated_at_20, t0.created_at AS created_at_21, t0.id AS id_22 FROM media__media t0 WHERE t0.id = ?
Parameters:
[
  573
]
33 1.21 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.keywords AS keywords_3, t0.description AS description_4, t0.create_at AS create_at_5, t0.share_image_id AS share_image_id_6 FROM seo t0 WHERE t0.id = ?
Parameters:
[
  82
]
34 0.39 ms
SELECT t0.name AS name_1, t0.description AS description_2, t0.enabled AS enabled_3, t0.provider_name AS provider_name_4, t0.provider_status AS provider_status_5, t0.provider_reference AS provider_reference_6, t0.provider_metadata AS provider_metadata_7, t0.width AS width_8, t0.height AS height_9, t0.length AS length_10, t0.content_type AS content_type_11, t0.content_size AS content_size_12, t0.copyright AS copyright_13, t0.author_name AS author_name_14, t0.context AS context_15, t0.cdn_is_flushable AS cdn_is_flushable_16, t0.cdn_flush_identifier AS cdn_flush_identifier_17, t0.cdn_flush_at AS cdn_flush_at_18, t0.cdn_status AS cdn_status_19, t0.updated_at AS updated_at_20, t0.created_at AS created_at_21, t0.id AS id_22 FROM media__media t0 WHERE t0.id = ?
Parameters:
[
  590
]
35 0.30 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.keywords AS keywords_3, t0.description AS description_4, t0.create_at AS create_at_5, t0.share_image_id AS share_image_id_6 FROM seo t0 WHERE t0.id = ?
Parameters:
[
  116
]
36 0.38 ms
SELECT t0.name AS name_1, t0.description AS description_2, t0.enabled AS enabled_3, t0.provider_name AS provider_name_4, t0.provider_status AS provider_status_5, t0.provider_reference AS provider_reference_6, t0.provider_metadata AS provider_metadata_7, t0.width AS width_8, t0.height AS height_9, t0.length AS length_10, t0.content_type AS content_type_11, t0.content_size AS content_size_12, t0.copyright AS copyright_13, t0.author_name AS author_name_14, t0.context AS context_15, t0.cdn_is_flushable AS cdn_is_flushable_16, t0.cdn_flush_identifier AS cdn_flush_identifier_17, t0.cdn_flush_at AS cdn_flush_at_18, t0.cdn_status AS cdn_status_19, t0.updated_at AS updated_at_20, t0.created_at AS created_at_21, t0.id AS id_22 FROM media__media t0 WHERE t0.id = ?
Parameters:
[
  568
]
37 0.34 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.keywords AS keywords_3, t0.description AS description_4, t0.create_at AS create_at_5, t0.share_image_id AS share_image_id_6 FROM seo t0 WHERE t0.id = ?
Parameters:
[
  121
]

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
TMWK\RedirectBundle\Entity\Redirect No errors.
App\Entity\ProductCategory
  • The field App\Entity\ProductCategory#products is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Product#categories does not contain the required 'inversedBy="products"' attribute.
Sonata\MediaBundle\Entity\BaseMedia No errors.
App\Entity\SonataMediaMedia No errors.
App\Entity\GeneralCategory No errors.
App\Entity\Seo No errors.
App\Entity\Product No errors.
Sonata\MediaBundle\Entity\BaseGalleryItem No errors.
App\Entity\SonataMediaGalleryItem No errors.
App\Entity\HomePage No errors.
App\Entity\News No errors.
App\Entity\ManualsAndCatalogs No errors.
App\Entity\BigWorks No errors.
App\Entity\BigWorkPage No errors.
App\Entity\ManualsAndCatalogsPage No errors.
App\Entity\NewsPage No errors.
App\Entity\ProductsPage No errors.
App\Entity\SearchPage No errors.
App\Entity\UsPage No errors.
App\Entity\AboutPage No errors.