Query Metrics

167 Database Queries
16 Different statements
279.04 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
127.90 ms
(45.83%)
52
SELECT t0.id AS id_1, t0.name AS name_2, t0.link AS link_3, t0.has_children AS has_children_4, t0.position AS position_5 FROM navigation t0
Parameters:
[]
84.99 ms
(30.46%)
52
SELECT t0.id AS id_1, t0.company_name AS company_name_2, t0.site_email AS site_email_3, t0.address AS address_4, t0.city AS city_5, t0.state AS state_6, t0.country AS country_7, t0.telephone AS telephone_8, t0.facebook_id AS facebook_id_9, t0.twitter_id AS twitter_id_10, t0.website_theme AS website_theme_11, t0.company_logo AS company_logo_12, t0.invoice_logo AS invoice_logo_13, t0.short_date AS short_date_14, t0.time_format AS time_format_15, t0.long_date AS long_date_16, t0.def_time_zone AS def_time_zone_17, t0.def_locale AS def_locale_18, t0.week_starts_on AS week_starts_on_19, t0.invoice_header AS invoice_header_20, t0.invoice_footer AS invoice_footer_21, t0.site_offline AS site_offline_22, t0.items_per_page AS items_per_page_23, t0.invoice_page_format AS invoice_page_format_24, t0.default_currency AS default_currency_25, t0.show_slider AS show_slider_26, t0.show_news AS show_news_27, t0.site_meta_keywords AS site_meta_keywords_28, t0.site_description AS site_description_29, t0.news_length AS news_length_30, t0.telephone_alt AS telephone_alt_31, t0.email_alt AS email_alt_32, t0.instagram_id AS instagram_id_33 FROM configuration t0
Parameters:
[]
23.96 ms
(8.59%)
7
SELECT t0.id AS id_1, t0.name AS name_2, t0.link AS link_3, t0.position AS position_4, t0.navigation_id AS navigation_id_5 FROM nav_child t0 WHERE t0.navigation_id = ?
Parameters:
[
  1
]
14.45 ms
(5.18%)
18
SELECT t0.id AS id_1, t0.name AS name_2, t0.typography AS typography_3, t0.position AS position_4, t0.visible AS visible_5, t0.last_updated AS last_updated_6, t0.page_id AS page_id_7 FROM section t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "blog/public_show.html.twig"
]
6.67 ms
(2.39%)
26
SELECT t0.id AS id_1, t0.url AS url_2, t0.placement AS placement_3, t0.alt AS alt_4, t0.thumbnail AS thumbnail_5, t0.section_id AS section_id_6 FROM web_photos t0 WHERE t0.section_id = ? ORDER BY t0.id ASC
Parameters:
[
  1
]
5.80 ms
(2.08%)
1
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.excerpt AS excerpt_4, t0.content AS content_5, t0.published_at AS published_at_6, t0.published AS published_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.image AS image_10, t0.user_id AS user_id_11, t0.category_id AS category_id_12 FROM blog t0 ORDER BY t0.published_at DESC LIMIT 3
Parameters:
[]
5.26 ms
(1.89%)
1
SELECT t0.id AS id_1, t0.description AS description_2, t0.image AS image_3, t0.name AS name_4, t0.type AS type_5, t0.instrument_id AS instrument_id_6, t0.package_id AS package_id_7 FROM course t0
Parameters:
[]
3.97 ms
(1.42%)
2
SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3 FROM page t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "global"
]
1.44 ms
(0.51%)
1
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.active AS active_5, t0.fullname AS fullname_6, t0.is_verified AS is_verified_7, t0.usertype AS usertype_8, t0.photo AS photo_9, t0.book_online AS book_online_10, t0.teacherdata_id AS teacherdata_id_11, t0.studentdata_id AS studentdata_id_12 FROM `user` t0 WHERE t0.id = ?
Parameters:
[
  1
]
1.09 ms
(0.39%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.typography AS typography_3, t0.position AS position_4, t0.visible AS visible_5, t0.last_updated AS last_updated_6, t0.page_id AS page_id_7 FROM section t0 WHERE t0.page_id = ?
Parameters:
[
  7
]
0.79 ms
(0.28%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.availability AS availability_3, t0.category AS category_4, t0.description AS description_5, t0.image AS image_6, t0.book_online AS book_online_7 FROM instrument t0
Parameters:
[]
0.71 ms
(0.25%)
1
SELECT t0.id AS id_1, t0.content AS content_2, t0.created_at AS created_at_3, t0.user_id AS user_id_4, t0.blog_id AS blog_id_5 FROM comment t0 WHERE t0.blog_id = ?
Parameters:
[
  20
]
0.65 ms
(0.23%)
1
SELECT t0.id AS id_1, t0.price AS price_2, t0.duration AS duration_3, t0.name AS name_4, t0.no_of_sessions AS no_of_sessions_5, t0.cost_per_lesson AS cost_per_lesson_6 FROM package t0
Parameters:
[]
0.55 ms
(0.20%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM blog_category t0
Parameters:
[]
0.54 ms
(0.19%)
1
SELECT t0.id AS id_1, t0.description AS description_2, t0.image AS image_3, t0.name AS name_4, t0.type AS type_5, t0.instrument_id AS instrument_id_6, t0.package_id AS package_id_7 FROM course t0 ORDER BY t0.type DESC LIMIT 3
Parameters:
[]
0.28 ms
(0.10%)
1
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.excerpt AS excerpt_4, t0.content AS content_5, t0.published_at AS published_at_6, t0.published AS published_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.image AS image_10, t0.user_id AS user_id_11, t0.category_id AS category_id_12 FROM blog t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  "20"
]

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.