Query Metrics

24 Database Queries
5 Different statements
2.41 ms Query time
0 Invalid entities
24 Managed entities

Queries

Group similar statements

# Time Info
1 0.34 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.native_name AS native_name_4, t0.is_active AS is_active_5, t0.is_default AS is_default_6, t0.sort_order AS sort_order_7 FROM language t0 WHERE t0.code = ? AND t0.is_active = ? LIMIT 1
Parameters:
[
  "pt"
  1
]
2 0.12 ms
SELECT l0_.id AS id_0, l0_.code AS code_1, l0_.name AS name_2, l0_.native_name AS native_name_3, l0_.is_active AS is_active_4, l0_.is_default AS is_default_5, l0_.sort_order AS sort_order_6 FROM language l0_ WHERE l0_.code = ?
Parameters:
[
  "pt"
]
3 0.10 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.base_price AS base_price_3, t0.promotional_price AS promotional_price_4, t0.surface AS surface_5, t0.dimensions AS dimensions_6, t0.rooms AS rooms_7, t0.height AS height_8, t0.assembly_time AS assembly_time_9, t0.energy_class AS energy_class_10, t0.warranty_structure AS warranty_structure_11, t0.warranty_equipment AS warranty_equipment_12, t0.is_active AS is_active_13, t0.is_featured AS is_featured_14, t0.is_customizable AS is_customizable_15, t0.sort_order AS sort_order_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.category_id AS category_id_19 FROM product t0 WHERE t0.is_featured = ?
Parameters:
[
  1
]
4 0.19 ms
SELECT t0.id AS id_1, t0.site_name AS site_name_2, t0.phone AS phone_3, t0.whatsapp AS whatsapp_4, t0.address AS address_5, t0.payment_info AS payment_info_6, t0.email AS email_7, t0.email_sender AS email_sender_8, t0.email_received AS email_received_9, t0.facebook AS facebook_10, t0.instagram AS instagram_11, t0.linkedin AS linkedin_12, t0.twitter AS twitter_13, t0.tiktok AS tiktok_14, t0.youtube AS youtube_15, t0.pinterest AS pinterest_16, t0.logo_id AS logo_id_17, t0.logo_light_id AS logo_light_id_18, t0.favicon_id AS favicon_id_19 FROM setting t0 LIMIT 1
Parameters:
[]
5 0.13 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.native_name AS native_name_4, t0.is_active AS is_active_5, t0.is_default AS is_default_6, t0.sort_order AS sort_order_7 FROM language t0 WHERE t0.code = ? AND t0.is_active = ? LIMIT 1
Parameters:
[
  "pt"
  1
]
6 0.13 ms
SELECT t0.id AS id_1, t0.site_name AS site_name_2, t0.phone AS phone_3, t0.whatsapp AS whatsapp_4, t0.address AS address_5, t0.payment_info AS payment_info_6, t0.email AS email_7, t0.email_sender AS email_sender_8, t0.email_received AS email_received_9, t0.facebook AS facebook_10, t0.instagram AS instagram_11, t0.linkedin AS linkedin_12, t0.twitter AS twitter_13, t0.tiktok AS tiktok_14, t0.youtube AS youtube_15, t0.pinterest AS pinterest_16, t0.logo_id AS logo_id_17, t0.logo_light_id AS logo_light_id_18, t0.favicon_id AS favicon_id_19 FROM setting t0 LIMIT 1
Parameters:
[]
7 0.07 ms
SELECT t0.id AS id_1, t0.site_name AS site_name_2, t0.phone AS phone_3, t0.whatsapp AS whatsapp_4, t0.address AS address_5, t0.payment_info AS payment_info_6, t0.email AS email_7, t0.email_sender AS email_sender_8, t0.email_received AS email_received_9, t0.facebook AS facebook_10, t0.instagram AS instagram_11, t0.linkedin AS linkedin_12, t0.twitter AS twitter_13, t0.tiktok AS tiktok_14, t0.youtube AS youtube_15, t0.pinterest AS pinterest_16, t0.logo_id AS logo_id_17, t0.logo_light_id AS logo_light_id_18, t0.favicon_id AS favicon_id_19 FROM setting t0 LIMIT 1
Parameters:
[]
8 0.08 ms
SELECT t0.id AS id_1, t0.site_name AS site_name_2, t0.phone AS phone_3, t0.whatsapp AS whatsapp_4, t0.address AS address_5, t0.payment_info AS payment_info_6, t0.email AS email_7, t0.email_sender AS email_sender_8, t0.email_received AS email_received_9, t0.facebook AS facebook_10, t0.instagram AS instagram_11, t0.linkedin AS linkedin_12, t0.twitter AS twitter_13, t0.tiktok AS tiktok_14, t0.youtube AS youtube_15, t0.pinterest AS pinterest_16, t0.logo_id AS logo_id_17, t0.logo_light_id AS logo_light_id_18, t0.favicon_id AS favicon_id_19 FROM setting t0 LIMIT 1
Parameters:
[]
9 0.06 ms
SELECT t0.id AS id_1, t0.site_name AS site_name_2, t0.phone AS phone_3, t0.whatsapp AS whatsapp_4, t0.address AS address_5, t0.payment_info AS payment_info_6, t0.email AS email_7, t0.email_sender AS email_sender_8, t0.email_received AS email_received_9, t0.facebook AS facebook_10, t0.instagram AS instagram_11, t0.linkedin AS linkedin_12, t0.twitter AS twitter_13, t0.tiktok AS tiktok_14, t0.youtube AS youtube_15, t0.pinterest AS pinterest_16, t0.logo_id AS logo_id_17, t0.logo_light_id AS logo_light_id_18, t0.favicon_id AS favicon_id_19 FROM setting t0 LIMIT 1
Parameters:
[]
10 0.06 ms
SELECT t0.id AS id_1, t0.site_name AS site_name_2, t0.phone AS phone_3, t0.whatsapp AS whatsapp_4, t0.address AS address_5, t0.payment_info AS payment_info_6, t0.email AS email_7, t0.email_sender AS email_sender_8, t0.email_received AS email_received_9, t0.facebook AS facebook_10, t0.instagram AS instagram_11, t0.linkedin AS linkedin_12, t0.twitter AS twitter_13, t0.tiktok AS tiktok_14, t0.youtube AS youtube_15, t0.pinterest AS pinterest_16, t0.logo_id AS logo_id_17, t0.logo_light_id AS logo_light_id_18, t0.favicon_id AS favicon_id_19 FROM setting t0 LIMIT 1
Parameters:
[]
11 0.10 ms
SELECT t0.id AS id_1, t0.site_name AS site_name_2, t0.phone AS phone_3, t0.whatsapp AS whatsapp_4, t0.address AS address_5, t0.payment_info AS payment_info_6, t0.email AS email_7, t0.email_sender AS email_sender_8, t0.email_received AS email_received_9, t0.facebook AS facebook_10, t0.instagram AS instagram_11, t0.linkedin AS linkedin_12, t0.twitter AS twitter_13, t0.tiktok AS tiktok_14, t0.youtube AS youtube_15, t0.pinterest AS pinterest_16, t0.logo_id AS logo_id_17, t0.logo_light_id AS logo_light_id_18, t0.favicon_id AS favicon_id_19 FROM setting t0 LIMIT 1
Parameters:
[]
12 0.10 ms
SELECT t0.id AS id_1, t0.site_name AS site_name_2, t0.phone AS phone_3, t0.whatsapp AS whatsapp_4, t0.address AS address_5, t0.payment_info AS payment_info_6, t0.email AS email_7, t0.email_sender AS email_sender_8, t0.email_received AS email_received_9, t0.facebook AS facebook_10, t0.instagram AS instagram_11, t0.linkedin AS linkedin_12, t0.twitter AS twitter_13, t0.tiktok AS tiktok_14, t0.youtube AS youtube_15, t0.pinterest AS pinterest_16, t0.logo_id AS logo_id_17, t0.logo_light_id AS logo_light_id_18, t0.favicon_id AS favicon_id_19 FROM setting t0 LIMIT 1
Parameters:
[]
13 0.09 ms
SELECT t0.id AS id_1, t0.site_name AS site_name_2, t0.phone AS phone_3, t0.whatsapp AS whatsapp_4, t0.address AS address_5, t0.payment_info AS payment_info_6, t0.email AS email_7, t0.email_sender AS email_sender_8, t0.email_received AS email_received_9, t0.facebook AS facebook_10, t0.instagram AS instagram_11, t0.linkedin AS linkedin_12, t0.twitter AS twitter_13, t0.tiktok AS tiktok_14, t0.youtube AS youtube_15, t0.pinterest AS pinterest_16, t0.logo_id AS logo_id_17, t0.logo_light_id AS logo_light_id_18, t0.favicon_id AS favicon_id_19 FROM setting t0 LIMIT 1
Parameters:
[]
14 0.09 ms
SELECT t0.id AS id_1, t0.site_name AS site_name_2, t0.phone AS phone_3, t0.whatsapp AS whatsapp_4, t0.address AS address_5, t0.payment_info AS payment_info_6, t0.email AS email_7, t0.email_sender AS email_sender_8, t0.email_received AS email_received_9, t0.facebook AS facebook_10, t0.instagram AS instagram_11, t0.linkedin AS linkedin_12, t0.twitter AS twitter_13, t0.tiktok AS tiktok_14, t0.youtube AS youtube_15, t0.pinterest AS pinterest_16, t0.logo_id AS logo_id_17, t0.logo_light_id AS logo_light_id_18, t0.favicon_id AS favicon_id_19 FROM setting t0 LIMIT 1
Parameters:
[]
15 0.08 ms
SELECT t0.id AS id_1, t0.site_name AS site_name_2, t0.phone AS phone_3, t0.whatsapp AS whatsapp_4, t0.address AS address_5, t0.payment_info AS payment_info_6, t0.email AS email_7, t0.email_sender AS email_sender_8, t0.email_received AS email_received_9, t0.facebook AS facebook_10, t0.instagram AS instagram_11, t0.linkedin AS linkedin_12, t0.twitter AS twitter_13, t0.tiktok AS tiktok_14, t0.youtube AS youtube_15, t0.pinterest AS pinterest_16, t0.logo_id AS logo_id_17, t0.logo_light_id AS logo_light_id_18, t0.favicon_id AS favicon_id_19 FROM setting t0 LIMIT 1
Parameters:
[]
16 0.06 ms
SELECT t0.id AS id_1, t0.site_name AS site_name_2, t0.phone AS phone_3, t0.whatsapp AS whatsapp_4, t0.address AS address_5, t0.payment_info AS payment_info_6, t0.email AS email_7, t0.email_sender AS email_sender_8, t0.email_received AS email_received_9, t0.facebook AS facebook_10, t0.instagram AS instagram_11, t0.linkedin AS linkedin_12, t0.twitter AS twitter_13, t0.tiktok AS tiktok_14, t0.youtube AS youtube_15, t0.pinterest AS pinterest_16, t0.logo_id AS logo_id_17, t0.logo_light_id AS logo_light_id_18, t0.favicon_id AS favicon_id_19 FROM setting t0 LIMIT 1
Parameters:
[]
17 0.10 ms
SELECT t0.id AS id_1, t0.site_name AS site_name_2, t0.phone AS phone_3, t0.whatsapp AS whatsapp_4, t0.address AS address_5, t0.payment_info AS payment_info_6, t0.email AS email_7, t0.email_sender AS email_sender_8, t0.email_received AS email_received_9, t0.facebook AS facebook_10, t0.instagram AS instagram_11, t0.linkedin AS linkedin_12, t0.twitter AS twitter_13, t0.tiktok AS tiktok_14, t0.youtube AS youtube_15, t0.pinterest AS pinterest_16, t0.logo_id AS logo_id_17, t0.logo_light_id AS logo_light_id_18, t0.favicon_id AS favicon_id_19 FROM setting t0 LIMIT 1
Parameters:
[]
18 0.07 ms
SELECT t0.id AS id_1, t0.site_name AS site_name_2, t0.phone AS phone_3, t0.whatsapp AS whatsapp_4, t0.address AS address_5, t0.payment_info AS payment_info_6, t0.email AS email_7, t0.email_sender AS email_sender_8, t0.email_received AS email_received_9, t0.facebook AS facebook_10, t0.instagram AS instagram_11, t0.linkedin AS linkedin_12, t0.twitter AS twitter_13, t0.tiktok AS tiktok_14, t0.youtube AS youtube_15, t0.pinterest AS pinterest_16, t0.logo_id AS logo_id_17, t0.logo_light_id AS logo_light_id_18, t0.favicon_id AS favicon_id_19 FROM setting t0 LIMIT 1
Parameters:
[]
19 0.06 ms
SELECT t0.id AS id_1, t0.site_name AS site_name_2, t0.phone AS phone_3, t0.whatsapp AS whatsapp_4, t0.address AS address_5, t0.payment_info AS payment_info_6, t0.email AS email_7, t0.email_sender AS email_sender_8, t0.email_received AS email_received_9, t0.facebook AS facebook_10, t0.instagram AS instagram_11, t0.linkedin AS linkedin_12, t0.twitter AS twitter_13, t0.tiktok AS tiktok_14, t0.youtube AS youtube_15, t0.pinterest AS pinterest_16, t0.logo_id AS logo_id_17, t0.logo_light_id AS logo_light_id_18, t0.favicon_id AS favicon_id_19 FROM setting t0 LIMIT 1
Parameters:
[]
20 0.06 ms
SELECT l0_.id AS id_0, l0_.code AS code_1, l0_.name AS name_2, l0_.native_name AS native_name_3, l0_.is_active AS is_active_4, l0_.is_default AS is_default_5, l0_.sort_order AS sort_order_6 FROM language l0_ WHERE l0_.is_active = ? ORDER BY l0_.sort_order ASC, l0_.name ASC
Parameters:
[
  1
]
21 0.05 ms
SELECT l0_.id AS id_0, l0_.code AS code_1, l0_.name AS name_2, l0_.native_name AS native_name_3, l0_.is_active AS is_active_4, l0_.is_default AS is_default_5, l0_.sort_order AS sort_order_6 FROM language l0_ WHERE l0_.is_active = ? ORDER BY l0_.sort_order ASC, l0_.name ASC
Parameters:
[
  1
]
22 0.05 ms
SELECT l0_.id AS id_0, l0_.code AS code_1, l0_.name AS name_2, l0_.native_name AS native_name_3, l0_.is_active AS is_active_4, l0_.is_default AS is_default_5, l0_.sort_order AS sort_order_6 FROM language l0_ WHERE l0_.is_active = ? ORDER BY l0_.sort_order ASC, l0_.name ASC
Parameters:
[
  1
]
23 0.11 ms
SELECT t0.id AS id_1, t0.site_name AS site_name_2, t0.phone AS phone_3, t0.whatsapp AS whatsapp_4, t0.address AS address_5, t0.payment_info AS payment_info_6, t0.email AS email_7, t0.email_sender AS email_sender_8, t0.email_received AS email_received_9, t0.facebook AS facebook_10, t0.instagram AS instagram_11, t0.linkedin AS linkedin_12, t0.twitter AS twitter_13, t0.tiktok AS tiktok_14, t0.youtube AS youtube_15, t0.pinterest AS pinterest_16, t0.logo_id AS logo_id_17, t0.logo_light_id AS logo_light_id_18, t0.favicon_id AS favicon_id_19 FROM setting t0 LIMIT 1
Parameters:
[]
24 0.10 ms
SELECT t0.id AS id_1, t0.site_name AS site_name_2, t0.phone AS phone_3, t0.whatsapp AS whatsapp_4, t0.address AS address_5, t0.payment_info AS payment_info_6, t0.email AS email_7, t0.email_sender AS email_sender_8, t0.email_received AS email_received_9, t0.facebook AS facebook_10, t0.instagram AS instagram_11, t0.linkedin AS linkedin_12, t0.twitter AS twitter_13, t0.tiktok AS tiktok_14, t0.youtube AS youtube_15, t0.pinterest AS pinterest_16, t0.logo_id AS logo_id_17, t0.logo_light_id AS logo_light_id_18, t0.favicon_id AS favicon_id_19 FROM setting t0 LIMIT 1
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.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\Product 11
App\Entity\Language 9
App\Entity\ProductCategory 3
App\Entity\Setting 1

Entities Mapping

Class Mapping errors
App\Entity\Language No errors.
App\Entity\Product No errors.
App\Entity\ProductCategory No errors.
App\Entity\ProductTranslation No errors.
App\Entity\ProductMedia No errors.
App\Entity\ProductOption No errors.
App\Entity\Setting No errors.
App\Entity\Media No errors.