GET https://standpulse.com/articles/tous

Query Metrics

27 Database Queries
16 Different statements
14.95 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
1.98 ms
(13.22%)
5
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.product_id AS product_id_3 FROM product_image t0 WHERE t0.product_id = ?
Parameters:
[
  1
]
1.77 ms
(11.81%)
5
SELECT t0.id AS id_1, t0.price AS price_2, t0.sale_price AS sale_price_3, t0.is_sale_price AS is_sale_price_4, t0.sale_price_effective_date_start AS sale_price_effective_date_start_5, t0.sale_price_effective_date_end AS sale_price_effective_date_end_6, t0.is_sale_effective_date AS is_sale_effective_date_7 FROM product_price t0 WHERE t0.id = ?
Parameters:
[
  1
]
1.76 ms
(11.77%)
1
SELECT t0.id AS id_1, t0.title_fr AS title_fr_2, t0.title_slug_fr AS title_slug_fr_3, t0.content AS content_4, t0.content_html AS content_html_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.enforcement_at AS enforcement_at_8, t0.is_enabled AS is_enabled_9, t0.random_number AS random_number_10, t0.indice AS indice_11 FROM legal_pages t0 WHERE t0.is_enabled = ?
Parameters:
[
  1
]
1.16 ms
(7.77%)
3
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.locale_id AS locale_id_3 FROM locale_mobile_img t0 WHERE t0.locale_id = ?
Parameters:
[
  1
]
1.14 ms
(7.63%)
2
SELECT t0.id AS id_1, t0.platform_title AS platform_title_2, t0.is_active AS is_active_3, t0.description AS description_4, t0.start_at AS start_at_5, t0.end_at AS end_at_6 FROM platform_data t0 WHERE t0.is_active = ? LIMIT 1
Parameters:
[
  1
]
1.08 ms
(7.24%)
1
SELECT t0.id AS id_1, t0.title_fr AS title_fr_2, t0.title_fr_slug AS title_fr_slug_3, t0.code AS code_4, t0.exchange_rate AS exchange_rate_5, t0.is_enabled AS is_enabled_6, t0.is_default_currency AS is_default_currency_7 FROM currency t0 INNER JOIN platform_data_currency ON t0.id = platform_data_currency.currency_id WHERE platform_data_currency.platform_data_id = ?
Parameters:
[
  1
]
0.89 ms
(5.94%)
1
SELECT t0.id AS id_1, t0.code AS code_2, t0.is_enabled AS is_enabled_3, t0.title_fr AS title_fr_4, t0.title_fr_slug AS title_fr_slug_5 FROM locale t0 INNER JOIN platform_data_locale ON t0.id = platform_data_locale.locale_id WHERE platform_data_locale.platform_data_id = ?
Parameters:
[
  1
]
0.89 ms
(5.93%)
1
SELECT t0.id AS id_1, t0.unique_id AS unique_id_2, t0.title_fr AS title_fr_3, t0.description AS description_4, t0.is_adult AS is_adult_5, t0.date AS date_6, t0.live_stats AS live_stats_7, t0.title_slug_fr AS title_slug_fr_8, t0.is_enabled AS is_enabled_9, t0.keywords AS keywords_10, t0.price_is_active AS price_is_active_11, t0.availability_is_active AS availability_is_active_12, t0.condition_is_active AS condition_is_active_13, t0.long_description AS long_description_14, t0.long_description_html AS long_description_html_15, t0.filter_price AS filter_price_16, t0.category_id AS category_id_17, t0.price_id AS price_id_18, t0.product_availability_id AS product_availability_id_19, t0.product_condition_id AS product_condition_id_20, t0.supplier_id AS supplier_id_21 FROM Product t0 WHERE t0.is_enabled = ?
Parameters:
[
  1
]
0.77 ms
(5.16%)
1
SELECT p0_.id AS id_0, p0_.unique_id AS unique_id_1, p0_.title_fr AS title_fr_2, p0_.description AS description_3, p0_.is_adult AS is_adult_4, p0_.date AS date_5, p0_.live_stats AS live_stats_6, p0_.title_slug_fr AS title_slug_fr_7, p0_.is_enabled AS is_enabled_8, p0_.keywords AS keywords_9, p0_.price_is_active AS price_is_active_10, p0_.availability_is_active AS availability_is_active_11, p0_.condition_is_active AS condition_is_active_12, p0_.long_description AS long_description_13, p0_.long_description_html AS long_description_html_14, p0_.filter_price AS filter_price_15, p0_.category_id AS category_id_16, p0_.price_id AS price_id_17, p0_.product_availability_id AS product_availability_id_18, p0_.product_condition_id AS product_condition_id_19, p0_.supplier_id AS supplier_id_20 FROM Product p0_ WHERE p0_.is_enabled = 1 AND p0_.price_is_active = 1 ORDER BY p0_.live_stats ASC LIMIT 20
Parameters:
[]
0.68 ms
(4.54%)
1
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.platform_data_id AS platform_data_id_3 FROM platform_favicon t0 WHERE t0.platform_data_id = ?
Parameters:
[
  1
]
0.58 ms
(3.85%)
1
SELECT t0.id AS id_1, t0.unique_id AS unique_id_2, t0.title_fr AS title_fr_3, t0.description AS description_4, t0.is_adult AS is_adult_5, t0.date AS date_6, t0.live_stats AS live_stats_7, t0.title_slug_fr AS title_slug_fr_8, t0.is_enabled AS is_enabled_9, t0.keywords AS keywords_10, t0.price_is_active AS price_is_active_11, t0.availability_is_active AS availability_is_active_12, t0.condition_is_active AS condition_is_active_13, t0.long_description AS long_description_14, t0.long_description_html AS long_description_html_15, t0.filter_price AS filter_price_16, t0.category_id AS category_id_17, t0.price_id AS price_id_18, t0.product_availability_id AS product_availability_id_19, t0.product_condition_id AS product_condition_id_20, t0.supplier_id AS supplier_id_21 FROM Product t0
Parameters:
[]
0.56 ms
(3.75%)
1
SELECT t0.id AS id_1, t0.title_fr AS title_fr_2, t0.identifier_value AS identifier_value_3, t0.live_stats AS live_stats_4, t0.description AS description_5, t0.title_slug_fr AS title_slug_fr_6, t0.keywords AS keywords_7, t0.is_enabled AS is_enabled_8, t0.is_pin AS is_pin_9, t0.date AS date_10, t0.icon_library_value AS icon_library_value_11, t0.parent_identifier_value AS parent_identifier_value_12, t0.file_created AS file_created_13, t0.parent_category_id AS parent_category_id_14 FROM categories t0 WHERE t0.is_pin = ?
Parameters:
[
  1
]
0.46 ms
(3.11%)
1
SELECT c0_.id AS id_0, c0_.title_fr AS title_fr_1, c0_.identifier_value AS identifier_value_2, c0_.live_stats AS live_stats_3, c0_.description AS description_4, c0_.title_slug_fr AS title_slug_fr_5, c0_.keywords AS keywords_6, c0_.is_enabled AS is_enabled_7, c0_.is_pin AS is_pin_8, c0_.date AS date_9, c0_.icon_library_value AS icon_library_value_10, c0_.parent_identifier_value AS parent_identifier_value_11, c0_.file_created AS file_created_12, c0_.parent_category_id AS parent_category_id_13 FROM categories c0_
Parameters:
[]
0.44 ms
(2.91%)
1
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.platform_data_id AS platform_data_id_3 FROM platform_logo t0 WHERE t0.platform_data_id = ?
Parameters:
[
  1
]
0.43 ms
(2.86%)
1
SELECT COUNT(p0_.id) AS sclr_0 FROM Product p0_ WHERE p0_.is_enabled = 1
Parameters:
[]
0.38 ms
(2.53%)
1
SELECT t0.id AS id_1, t0.title_fr AS title_fr_2, t0.identifier_value AS identifier_value_3, t0.live_stats AS live_stats_4, t0.description AS description_5, t0.title_slug_fr AS title_slug_fr_6, t0.keywords AS keywords_7, t0.is_enabled AS is_enabled_8, t0.is_pin AS is_pin_9, t0.date AS date_10, t0.icon_library_value AS icon_library_value_11, t0.parent_identifier_value AS parent_identifier_value_12, t0.file_created AS file_created_13, t0.parent_category_id AS parent_category_id_14 FROM categories t0
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.