GET https://www.test.cr-art-auctions.be/nl

Query Metrics

10 Database Queries
9 Different statements
8.43 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
1.67 ms
(19.78%)
1
SELECT s0_.value AS value_0, s1_.value AS value_1, s2_.value AS value_2, s3_.value AS value_3, s4_.value AS value_4 FROM settings s0_ INNER JOIN settings s1_ INNER JOIN settings s2_ INNER JOIN settings s3_ INNER JOIN settings s4_ WHERE s0_.name = ? AND s1_.name = ? AND s2_.name = ? AND s3_.name = ? AND s4_.name = ?
Parameters:
[
  "auction.live.status"
  "auction.live.fair.warning"
  "auction.live.lot.number"
  "auction.live.current.bid"
  "auction.live.current.bid.number"
]
1.47 ms
(17.40%)
1
SELECT t0_.id AS id_0, t0_.name AS name_1, t0_.type AS type_2, t0_.src AS src_3, t0_.model_name AS model_name_4, t0_.model_id AS model_id_5, t0_.value AS value_6, t0_.state AS state_7, t0_.trace AS trace_8, t0_.created_by AS created_by_9, t0_.created_date AS created_date_10, t0_.modified_by AS modified_by_11, t0_.modified_date AS modified_date_12, t0_.language_id AS language_id_13 FROM translations t0_ WHERE t0_.model_name = ? AND t0_.model_id = ? AND t0_.state = ? AND t0_.language_id = ?
Parameters:
[
  "PageHome"
  1
  "translated"
  1
]
1.16 ms
(13.73%)
2
SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.number AS number_2, a0_.index_id AS index_id_3, a0_.active AS active_4, a0_.visible AS visible_5, a0_.created_by AS created_by_6, a0_.created_date AS created_date_7, a0_.modified_by AS modified_by_8, a0_.modified_date AS modified_date_9 FROM auctions a0_ WHERE a0_.active = ? LIMIT 1
Parameters:
[
  1
]
0.79 ms
(9.37%)
1
SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.number AS number_2, a0_.index_id AS index_id_3, a0_.active AS active_4, a0_.visible AS visible_5, a0_.created_by AS created_by_6, a0_.created_date AS created_date_7, a0_.modified_by AS modified_by_8, a0_.modified_date AS modified_date_9, a1_.id AS id_10, a1_.date AS date_11, a1_.bids_start AS bids_start_12, a1_.bids_end AS bids_end_13, a1_.lot_no_start AS lot_no_start_14, a1_.lot_no_end AS lot_no_end_15, a1_.type AS type_16, a1_.created_by AS created_by_17, a1_.created_date AS created_date_18, a1_.modified_by AS modified_by_19, a1_.modified_date AS modified_date_20, a1_.auction_id AS auction_id_21 FROM auctions a0_ LEFT JOIN auction_days a1_ ON a0_.id = a1_.auction_id WHERE a1_.date >= ? ORDER BY a1_.date ASC
Parameters:
[
  "2025-12-10 04:05:12"
]
0.78 ms
(9.23%)
1
SELECT s0_.id AS id_0, s0_.sequence AS sequence_1, s0_.created_by AS created_by_2, s0_.created_date AS created_date_3, s0_.modified_by AS modified_by_4, s0_.modified_date AS modified_date_5, c1_.id AS id_6, c1_.lot_no AS lot_no_7, c1_.price_start AS price_start_8, c1_.price_end AS price_end_9, c1_.description AS description_10, c1_.dimensions AS dimensions_11, c1_.image AS image_12, c1_.index_id AS index_id_13, c1_.debawin_id AS debawin_id_14, c1_.debawin_consignation_no AS debawin_consignation_no_15, c1_.debawin_consignation_name AS debawin_consignation_name_16, c1_.min_auction_price AS min_auction_price_17, c1_.title AS title_18, c1_.condition_report AS condition_report_19, c1_.start_bid AS start_bid_20, c1_.created_by AS created_by_21, c1_.created_date AS created_date_22, c1_.modified_by AS modified_by_23, c1_.modified_date AS modified_date_24, s0_.home_page_id AS home_page_id_25, s0_.catalogue_id AS catalogue_id_26, c1_.auction_id AS auction_id_27, c1_.category_id AS category_id_28 FROM slider_images s0_ LEFT JOIN catalogue c1_ ON s0_.catalogue_id = c1_.id WHERE s0_.home_page_id = ?
Parameters:
[
  1
]
0.72 ms
(8.50%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.iso_code AS iso_code_4, t0.active AS active_5, t0.created_by AS created_by_6, t0.created_date AS created_date_7, t0.modified_by AS modified_by_8, t0.modified_date AS modified_date_9 FROM languages t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
  "nl"
]
0.69 ms
(8.24%)
1
SELECT t0.id AS id_1, t0.date AS date_2, t0.bids_start AS bids_start_3, t0.bids_end AS bids_end_4, t0.lot_no_start AS lot_no_start_5, t0.lot_no_end AS lot_no_end_6, t0.type AS type_7, t0.created_by AS created_by_8, t0.created_date AS created_date_9, t0.modified_by AS modified_by_10, t0.modified_date AS modified_date_11, t0.auction_id AS auction_id_12 FROM auction_days t0 WHERE t0.auction_id = ?
Parameters:
[
  4
]
0.59 ms
(6.94%)
1
SELECT t0.id AS id_1, t0.title AS title_2, t0.left_text AS left_text_3, t0.welcome_text AS welcome_text_4, t0.buy_text AS buy_text_5, t0.tel_text AS tel_text_6, t0.live_text AS live_text_7, t0.created_by AS created_by_8, t0.created_date AS created_date_9, t0.modified_by AS modified_by_10, t0.modified_date AS modified_date_11 FROM page_home t0 WHERE t0.id = ?
Parameters:
[
  1
]
0.57 ms
(6.80%)
1
SELECT l0_.id AS id_0 FROM languages l0_ WHERE l0_.code = ?
Parameters:
[
  "nl"
]

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