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

Query Metrics

12 Database Queries
7 Different statements
92.25 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
77.91 ms
(84.45%)
6
SELECT a0_.id AS id_0, a0_.description AS description_1, a0_.file_size AS file_size_2, a0_.file_name AS file_name_3, a0_.file_name_encoded AS file_name_encoded_4, a0_.file_path AS file_path_5, a0_.model_name AS model_name_6, a0_.model_id AS model_id_7, a0_.type AS type_8, a0_.data AS data_9, a0_.sequence AS sequence_10, a0_.created_by AS created_by_11, a0_.created_date AS created_date_12, a0_.modified_by AS modified_by_13, a0_.modified_date AS modified_date_14 FROM attachments a0_ WHERE a0_.description = ? AND a0_.model_id = ?
Parameters:
[
  "103_45.1"
  330
]
4.85 ms
(5.26%)
1
SELECT r0_.id AS id_0, r0_.sequence AS sequence_1, r0_.highlight AS highlight_2, r0_.created_by AS created_by_3, r0_.created_date AS created_date_4, r0_.modified_by AS modified_by_5, r0_.modified_date AS modified_date_6, c1_.id AS id_7, c1_.lot_no AS lot_no_8, c1_.price_start AS price_start_9, c1_.price_end AS price_end_10, c1_.description AS description_11, c1_.dimensions AS dimensions_12, c1_.image AS image_13, c1_.index_id AS index_id_14, c1_.debawin_id AS debawin_id_15, c1_.debawin_consignation_no AS debawin_consignation_no_16, c1_.debawin_consignation_name AS debawin_consignation_name_17, c1_.min_auction_price AS min_auction_price_18, c1_.title AS title_19, c1_.condition_report AS condition_report_20, c1_.start_bid AS start_bid_21, c1_.created_by AS created_by_22, c1_.created_date AS created_date_23, c1_.modified_by AS modified_by_24, c1_.modified_date AS modified_date_25, a2_.id AS id_26, a2_.bid_number AS bid_number_27, a2_.bid_value AS bid_value_28, a2_.bid_hold_value AS bid_hold_value_29, a2_.external_id AS external_id_30, a2_.created_by AS created_by_31, a2_.created_date AS created_date_32, a2_.modified_by AS modified_by_33, a2_.modified_date AS modified_date_34, r0_.catalogue_id AS catalogue_id_35, c1_.auction_id AS auction_id_36, c1_.category_id AS category_id_37, a2_.auction_id AS auction_id_38, a2_.catalogue_id AS catalogue_id_39 FROM results r0_ LEFT JOIN catalogue c1_ ON r0_.catalogue_id = c1_.id LEFT JOIN auction_wins a2_ ON c1_.id = a2_.catalogue_id ORDER BY r0_.sequence ASC
Parameters:
[]
4.55 ms
(4.94%)
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 IN (?, ?, ?, ?, ?, ?) AND t0_.language_id = ? AND t0_.name = ? AND t0_.state = ?
Parameters:
[
  "Catalogue"
  330
  1
  2
  4
  5
  3
  2
  "title"
  "translated"
]
2.43 ms
(2.63%)
1
SELECT l0_.id AS id_0 FROM languages l0_ WHERE l0_.code = ?
Parameters:
[
  "en"
]
1.12 ms
(1.22%)
1
SELECT t0.id AS id_1, t0.title AS title_2, t0.text AS text_3, t0.created_by AS created_by_4, t0.created_date AS created_date_5, t0.modified_by AS modified_by_6, t0.modified_date AS modified_date_7 FROM page_results t0 WHERE t0.id = ?
Parameters:
[
  1
]
0.91 ms
(0.99%)
1
SELECT r0_.id AS id_0, r0_.sequence AS sequence_1, r0_.highlight AS highlight_2, r0_.created_by AS created_by_3, r0_.created_date AS created_date_4, r0_.modified_by AS modified_by_5, r0_.modified_date AS modified_date_6, c1_.id AS id_7, c1_.lot_no AS lot_no_8, c1_.price_start AS price_start_9, c1_.price_end AS price_end_10, c1_.description AS description_11, c1_.dimensions AS dimensions_12, c1_.image AS image_13, c1_.index_id AS index_id_14, c1_.debawin_id AS debawin_id_15, c1_.debawin_consignation_no AS debawin_consignation_no_16, c1_.debawin_consignation_name AS debawin_consignation_name_17, c1_.min_auction_price AS min_auction_price_18, c1_.title AS title_19, c1_.condition_report AS condition_report_20, c1_.start_bid AS start_bid_21, c1_.created_by AS created_by_22, c1_.created_date AS created_date_23, c1_.modified_by AS modified_by_24, c1_.modified_date AS modified_date_25, a2_.id AS id_26, a2_.bid_number AS bid_number_27, a2_.bid_value AS bid_value_28, a2_.bid_hold_value AS bid_hold_value_29, a2_.external_id AS external_id_30, a2_.created_by AS created_by_31, a2_.created_date AS created_date_32, a2_.modified_by AS modified_by_33, a2_.modified_date AS modified_date_34, r0_.catalogue_id AS catalogue_id_35, c1_.auction_id AS auction_id_36, c1_.category_id AS category_id_37, a2_.auction_id AS auction_id_38, a2_.catalogue_id AS catalogue_id_39 FROM results r0_ LEFT JOIN catalogue c1_ ON r0_.catalogue_id = c1_.id LEFT JOIN auction_wins a2_ ON c1_.id = a2_.catalogue_id WHERE r0_.highlight = ? AND a2_.auction_id = c1_.auction_id ORDER BY a2_.bid_value DESC
Parameters:
[
  1
]
0.47 ms
(0.51%)
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:
[
  "PageResult"
  1
  "translated"
  2
]

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