Symfony Profiler

SELECT
  l0_.id AS id_0
FROM
  languages l0_
WHERE
  l0_.code = ?

SELECT l0_.id AS id_0 FROM languages l0_ WHERE l0_.code = 'en';

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 = ?

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 = 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

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;

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 = ?

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 = '103_45.1' AND a0_.model_id = 330;

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 = ?

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 = '102_1.1' AND a0_.model_id = 1;

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 = ?

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 = '122_3.1' AND a0_.model_id = 2;

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 = ?

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 = '102_4.5' AND a0_.model_id = 4;

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 = ?

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 = '102_7.1' AND a0_.model_id = 5;

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 = ?

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 = '102_127.1' AND a0_.model_id = 3;

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 = ?

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 = 'Catalogue' AND t0_.model_id IN (330, 1, 2, 4, 5, 3) AND t0_.language_id = 2 AND t0_.name = 'title' AND t0_.state = 'translated';

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

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 = 1 AND a2_.auction_id = c1_.auction_id ORDER BY a2_.bid_value DESC;

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 = ?

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 = 'PageResult' AND t0_.model_id = 1 AND t0_.state = 'translated' AND t0_.language_id = 2;