https://mail.chilco.diig.cl/data/product.json

Query Metrics

8 Database Queries
7 Different statements
15.72 ms Query time
1 Invalid entities

Grouped Statements

Show all queries

Time▼ Count Info
5.31 ms
(33.79%)
1
"COMMIT"
Parameters:
[]
2.73 ms
(17.39%)
1
SELECT t0.id AS id_1, t0.public AS public_2, t0.name AS name_3, t0.slug AS slug_4, t0.description AS description_5, t0.recommended_uses AS recommended_uses_6, t0.uses AS uses_7, t0.conditions AS conditions_8, t0.tools AS tools_9, t0.dilution AS dilution_10, t0.layers AS layers_11, t0.drying_time AS drying_time_12, t0.touch_drying AS touch_drying_13, t0.repaint_drying AS repaint_drying_14, t0.final_drying AS final_drying_15, t0.data_sheet AS data_sheet_16, t0.safety_sheet AS safety_sheet_17, t0.safety_sheet_cb AS safety_sheet_cb_18, t0.transport_sheet AS transport_sheet_19, t0.packed_colors AS packed_colors_20, t0.link_mp AS link_mp_21, t0.create_at AS create_at_22, t0.update_at AS update_at_23, t0.image_id AS image_id_24, t0.image_cover_id AS image_cover_id_25, t0.video_id AS video_id_26, t0.video_image_id AS video_image_id_27, t0.seo_id AS seo_id_28 FROM product t0 WHERE t0.public = ?
Parameters:
[
  1
]
2.41 ms
(15.31%)
1
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/product.json"
]
2.04 ms
(12.98%)
1
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 INNER JOIN product_categories ON t0.id = product_categories.categories_id WHERE product_categories.product_id = ?
Parameters:
[
  2
]
1.54 ms
(9.80%)
2
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:
[
  406
]
0.99 ms
(6.29%)
1
INSERT INTO exception_notification (message, file, line, code, status_code, data_request, data_query, data_session, data_method, create_at) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  """
    Attempted to call an undefined method named "getPackedColorsImage" of class "App\Entity\Product".\n
    Did you mean to call e.g. "getPackedColors" or "setPackedColors"?
    """
  "/home/chilcodiig/src/Controller/DefaultController.php"
  291
  "0"
  null
  "a:0:{}"
  "a:0:{}"
  "a:0:{}"
  "GET"
  "2026-11-11 02:22:34"
]
0.70 ms
(4.43%)
1
"START TRANSACTION"
Parameters:
[]

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\Product No errors.
Sonata\MediaBundle\Entity\BaseMedia No errors.
App\Entity\SonataMediaMedia No errors.
App\Entity\Seo 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.
App\Entity\ProductFilter No errors.
App\Entity\ProductColor No errors.
App\Entity\GeneralCategory No errors.
Sonata\MediaBundle\Entity\BaseGalleryItem No errors.
App\Entity\SonataMediaGalleryItem No errors.
TMWK\ExceptionNotifierBundle\Entity\ExceptionNotification 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.
App\Entity\ProductFilter1 No errors.
App\Entity\ProductFilter2 No errors.
App\Entity\ProductFilter3 No errors.
Sonata\MediaBundle\Entity\BaseGallery No errors.
App\Entity\SonataMediaGallery No errors.