Symfony Profiler

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
  catalogue c1_
  LEFT JOIN categories c2_ ON c1_.category_id = c2_.id
  LEFT JOIN translations t3_ ON (
    t3_.model_name = 'Catalogue'
    AND t3_.model_id = c1_.id
    AND t3_.name = 'title'
    AND t3_.language_id = ?
  )
  LEFT JOIN translations t4_ ON (
    t4_.model_name = 'Catalogue'
    AND t4_.model_id = c1_.id
    AND t4_.name = 'description'
    AND t4_.language_id = ?
  )
  LEFT JOIN translations t5_ ON (
    t5_.model_name = 'Catalogue'
    AND t5_.model_id = c1_.id
  )
  LEFT JOIN translations t6_ ON (
    t6_.model_name = 'Category'
    AND t6_.model_id = c1_.category_id
  )
  LEFT JOIN attachments a0_ ON (a0_.model_id = c1_.id)
WHERE
  c1_.auction_id = ?
  AND c1_.category_id IN (?)
  AND a0_.model_name = ?
  AND a0_.description = REPLACE(
    REPLACE(
      REPLACE(
        REPLACE(
          REPLACE(c1_.image, '.jpg', ''),
          '.png',
          ''
        ),
        '.webp',
        ''
      ),
      '.gif',
      ''
    ),
    '.svg',
    ''
  )

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 catalogue c1_ LEFT JOIN categories c2_ ON c1_.category_id = c2_.id LEFT JOIN translations t3_ ON (t3_.model_name = 'Catalogue' AND t3_.model_id = c1_.id AND t3_.name = 'title' AND t3_.language_id = 1) LEFT JOIN translations t4_ ON (t4_.model_name = 'Catalogue' AND t4_.model_id = c1_.id AND t4_.name = 'description' AND t4_.language_id = 1) LEFT JOIN translations t5_ ON (t5_.model_name = 'Catalogue' AND t5_.model_id = c1_.id) LEFT JOIN translations t6_ ON (t6_.model_name = 'Category' AND t6_.model_id = c1_.category_id) LEFT JOIN attachments a0_ ON (a0_.model_id = c1_.id) WHERE c1_.auction_id = 4 AND c1_.category_id IN ('63') AND a0_.model_name = 'Catalogue' AND a0_.description = REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(c1_.image, '.jpg', ''), '.png', ''), '.webp', ''), '.gif', ''), '.svg', '');

SELECT
  DISTINCT c0_.id AS id_0,
  c0_.lot_no AS lot_no_1,
  c0_.price_start AS price_start_2,
  c0_.price_end AS price_end_3,
  c0_.description AS description_4,
  c0_.dimensions AS dimensions_5,
  c0_.image AS image_6,
  c0_.index_id AS index_id_7,
  c0_.debawin_id AS debawin_id_8,
  c0_.debawin_consignation_no AS debawin_consignation_no_9,
  c0_.debawin_consignation_name AS debawin_consignation_name_10,
  c0_.min_auction_price AS min_auction_price_11,
  c0_.title AS title_12,
  c0_.condition_report AS condition_report_13,
  c0_.start_bid AS start_bid_14,
  c0_.created_by AS created_by_15,
  c0_.created_date AS created_date_16,
  c0_.modified_by AS modified_by_17,
  c0_.modified_date AS modified_date_18,
  c1_.id AS id_19,
  c1_.name AS name_20,
  c1_.number AS number_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,
  c0_.auction_id AS auction_id_26,
  c0_.category_id AS category_id_27,
  c1_.auction_id AS auction_id_28
FROM
  catalogue c0_
  LEFT JOIN categories c1_ ON c0_.category_id = c1_.id
  LEFT JOIN translations t2_ ON (
    t2_.model_name = 'Catalogue'
    AND t2_.model_id = c0_.id
    AND t2_.name = 'title'
    AND t2_.language_id = ?
  )
  LEFT JOIN translations t3_ ON (
    t3_.model_name = 'Catalogue'
    AND t3_.model_id = c0_.id
    AND t3_.name = 'description'
    AND t3_.language_id = ?
  )
  LEFT JOIN translations t4_ ON (
    t4_.model_name = 'Catalogue'
    AND t4_.model_id = c0_.id
  )
  LEFT JOIN translations t5_ ON (
    t5_.model_name = 'Category'
    AND t5_.model_id = c0_.category_id
  )
WHERE
  c0_.auction_id = ?
  AND c0_.category_id IN (?)
ORDER BY
  c0_.lot_no ASC,
  c0_.title ASC
LIMIT
  50 OFFSET 50

SELECT DISTINCT c0_.id AS id_0, c0_.lot_no AS lot_no_1, c0_.price_start AS price_start_2, c0_.price_end AS price_end_3, c0_.description AS description_4, c0_.dimensions AS dimensions_5, c0_.image AS image_6, c0_.index_id AS index_id_7, c0_.debawin_id AS debawin_id_8, c0_.debawin_consignation_no AS debawin_consignation_no_9, c0_.debawin_consignation_name AS debawin_consignation_name_10, c0_.min_auction_price AS min_auction_price_11, c0_.title AS title_12, c0_.condition_report AS condition_report_13, c0_.start_bid AS start_bid_14, c0_.created_by AS created_by_15, c0_.created_date AS created_date_16, c0_.modified_by AS modified_by_17, c0_.modified_date AS modified_date_18, c1_.id AS id_19, c1_.name AS name_20, c1_.number AS number_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, c0_.auction_id AS auction_id_26, c0_.category_id AS category_id_27, c1_.auction_id AS auction_id_28 FROM catalogue c0_ LEFT JOIN categories c1_ ON c0_.category_id = c1_.id LEFT JOIN translations t2_ ON (t2_.model_name = 'Catalogue' AND t2_.model_id = c0_.id AND t2_.name = 'title' AND t2_.language_id = 1) LEFT JOIN translations t3_ ON (t3_.model_name = 'Catalogue' AND t3_.model_id = c0_.id AND t3_.name = 'description' AND t3_.language_id = 1) LEFT JOIN translations t4_ ON (t4_.model_name = 'Catalogue' AND t4_.model_id = c0_.id) LEFT JOIN translations t5_ ON (t5_.model_name = 'Category' AND t5_.model_id = c0_.category_id) WHERE c0_.auction_id = 4 AND c0_.category_id IN ('63') ORDER BY c0_.lot_no ASC, c0_.title ASC LIMIT 50 OFFSET 50;

SELECT
  c0_.id AS id_0,
  c0_.title AS title_1,
  t1_.value AS value_2,
  t2_.value AS value_3
FROM
  catalogue c0_
  LEFT JOIN categories c3_ ON c0_.category_id = c3_.id
  LEFT JOIN translations t1_ ON (
    t1_.model_name = 'Catalogue'
    AND t1_.model_id = c0_.id
    AND t1_.name = 'title'
    AND t1_.language_id = ?
  )
  LEFT JOIN translations t2_ ON (
    t2_.model_name = 'Catalogue'
    AND t2_.model_id = c0_.id
    AND t2_.name = 'description'
    AND t2_.language_id = ?
  )
  LEFT JOIN translations t4_ ON (
    t4_.model_name = 'Catalogue'
    AND t4_.model_id = c0_.id
  )
  LEFT JOIN translations t5_ ON (
    t5_.model_name = 'Category'
    AND t5_.model_id = c0_.category_id
  )
WHERE
  c0_.auction_id = ?
  AND c0_.category_id IN (?)
LIMIT
  18446744073709551615 OFFSET 50

SELECT c0_.id AS id_0, c0_.title AS title_1, t1_.value AS value_2, t2_.value AS value_3 FROM catalogue c0_ LEFT JOIN categories c3_ ON c0_.category_id = c3_.id LEFT JOIN translations t1_ ON (t1_.model_name = 'Catalogue' AND t1_.model_id = c0_.id AND t1_.name = 'title' AND t1_.language_id = 1) LEFT JOIN translations t2_ ON (t2_.model_name = 'Catalogue' AND t2_.model_id = c0_.id AND t2_.name = 'description' AND t2_.language_id = 1) LEFT JOIN translations t4_ ON (t4_.model_name = 'Catalogue' AND t4_.model_id = c0_.id) LEFT JOIN translations t5_ ON (t5_.model_name = 'Category' AND t5_.model_id = c0_.category_id) WHERE c0_.auction_id = 4 AND c0_.category_id IN ('63') LIMIT 18446744073709551615 OFFSET 50;

SELECT
  COUNT(DISTINCT c0_.id) AS sclr_0
FROM
  catalogue c0_
  LEFT JOIN categories c1_ ON c0_.category_id = c1_.id
  LEFT JOIN translations t2_ ON (
    t2_.model_name = 'Catalogue'
    AND t2_.model_id = c0_.id
    AND t2_.name = 'title'
    AND t2_.language_id = ?
  )
  LEFT JOIN translations t3_ ON (
    t3_.model_name = 'Catalogue'
    AND t3_.model_id = c0_.id
    AND t3_.name = 'description'
    AND t3_.language_id = ?
  )
  LEFT JOIN translations t4_ ON (
    t4_.model_name = 'Catalogue'
    AND t4_.model_id = c0_.id
  )
  LEFT JOIN translations t5_ ON (
    t5_.model_name = 'Category'
    AND t5_.model_id = c0_.category_id
  )
WHERE
  c0_.auction_id = ?
  AND c0_.category_id IN (?)
ORDER BY
  c0_.lot_no ASC,
  c0_.title ASC

SELECT COUNT(DISTINCT c0_.id) AS sclr_0 FROM catalogue c0_ LEFT JOIN categories c1_ ON c0_.category_id = c1_.id LEFT JOIN translations t2_ ON (t2_.model_name = 'Catalogue' AND t2_.model_id = c0_.id AND t2_.name = 'title' AND t2_.language_id = 1) LEFT JOIN translations t3_ ON (t3_.model_name = 'Catalogue' AND t3_.model_id = c0_.id AND t3_.name = 'description' AND t3_.language_id = 1) LEFT JOIN translations t4_ ON (t4_.model_name = 'Catalogue' AND t4_.model_id = c0_.id) LEFT JOIN translations t5_ ON (t5_.model_name = 'Category' AND t5_.model_id = c0_.category_id) WHERE c0_.auction_id = 4 AND c0_.category_id IN ('63') ORDER BY c0_.lot_no ASC, c0_.title ASC;

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  t1_.value AS value_2
FROM
  categories c0_
  INNER JOIN catalogue c2_ ON (c2_.category_id = c0_.id)
  LEFT JOIN translations t1_ ON (
    t1_.model_name = 'Category'
    AND t1_.model_id = c0_.id
    AND t1_.language_id = ?
  )
WHERE
  c0_.auction_id = ?
GROUP BY
  c0_.id

SELECT c0_.id AS id_0, c0_.name AS name_1, t1_.value AS value_2 FROM categories c0_ INNER JOIN catalogue c2_ ON (c2_.category_id = c0_.id) LEFT JOIN translations t1_ ON (t1_.model_name = 'Category' AND t1_.model_id = c0_.id AND t1_.language_id = 1) WHERE c0_.auction_id = 4 GROUP BY c0_.id;

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

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

SELECT
  DISTINCT a0_.id AS id_0,
  a0_.name AS name_1,
  a0_.number AS number_2,
  t1_.value AS value_3
FROM
  auctions a0_
  LEFT JOIN translations t1_ ON (
    t1_.model_name = 'Auction'
    AND t1_.model_id = a0_.id
    AND t1_.name = 'name'
    AND t1_.language_id = ?
  )
WHERE
  a0_.visible = ?
ORDER BY
  a0_.number DESC

SELECT DISTINCT a0_.id AS id_0, a0_.name AS name_1, a0_.number AS number_2, t1_.value AS value_3 FROM auctions a0_ LEFT JOIN translations t1_ ON (t1_.model_name = 'Auction' AND t1_.model_id = a0_.id AND t1_.name = 'name' AND t1_.language_id = 1) WHERE a0_.visible = 1 ORDER BY a0_.number 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 = 'PageCatalogue' AND t0_.model_id = 1 AND t0_.state = 'translated' AND t0_.language_id = 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.id = ?

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.id = 1;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.description AS description_3,
  t0.sort_field AS sort_field_4,
  t0.sort_direction AS sort_direction_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
  page_catalogue t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.sort_field AS sort_field_4, t0.sort_direction AS sort_direction_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 page_catalogue t0 WHERE t0.id = 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
FROM
  auctions a0_
WHERE
  a0_.active = ?
LIMIT
  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 FROM auctions a0_ WHERE a0_.active = 1 LIMIT 1;