Symfony Profiler

SELECT
  s0_.id AS id_0,
  s0_.title AS title_1,
  s0_.date AS date_2,
  s0_.date_accuracy AS date_accuracy_3,
  s0_.excerpt_swe AS excerpt_swe_4,
  s0_.transcription AS transcription_5,
  s0_.research_notes AS research_notes_6,
  s0_.place_in_volume AS place_in_volume_7,
  s0_.status AS status_8,
  s0_.book AS book_9,
  s0_.pages AS pages_10,
  s0_.alvin_id AS alvin_id_11,
  s0_.type AS type_12,
  s0_.updated_at AS updated_at_13,
  s0_.language AS language_14,
  s0_.excerpt_eng AS excerpt_eng_15,
  s0_.short_excerpt_swe AS short_excerpt_swe_16,
  s0_.short_excerpt_eng AS short_excerpt_eng_17,
  s0_.transcription_modern_sve AS transcription_modern_sve_18,
  s0_.excerpt_eng_proofed AS excerpt_eng_proofed_19,
  s0_.excerpt_swe_proofed AS excerpt_swe_proofed_20,
  s0_.short_excerpt_eng_proofed AS short_excerpt_eng_proofed_21,
  s0_.short_excerpt_swe_proofed AS short_excerpt_swe_proofed_22,
  s0_.parent_id AS parent_id_23,
  s0_.volume_id AS volume_id_24,
  s0_.updated_by_id AS updated_by_id_25
FROM
  sources s0_
  LEFT JOIN volumes v1_ ON (s0_.volume_id = v1_.id)
WHERE
  YEAR(s0_.date) = ?
  AND v1_.published <> 0
ORDER BY
  s0_.date ASC

SELECT s0_.id AS id_0, s0_.title AS title_1, s0_.date AS date_2, s0_.date_accuracy AS date_accuracy_3, s0_.excerpt_swe AS excerpt_swe_4, s0_.transcription AS transcription_5, s0_.research_notes AS research_notes_6, s0_.place_in_volume AS place_in_volume_7, s0_.status AS status_8, s0_.book AS book_9, s0_.pages AS pages_10, s0_.alvin_id AS alvin_id_11, s0_.type AS type_12, s0_.updated_at AS updated_at_13, s0_.language AS language_14, s0_.excerpt_eng AS excerpt_eng_15, s0_.short_excerpt_swe AS short_excerpt_swe_16, s0_.short_excerpt_eng AS short_excerpt_eng_17, s0_.transcription_modern_sve AS transcription_modern_sve_18, s0_.excerpt_eng_proofed AS excerpt_eng_proofed_19, s0_.excerpt_swe_proofed AS excerpt_swe_proofed_20, s0_.short_excerpt_eng_proofed AS short_excerpt_eng_proofed_21, s0_.short_excerpt_swe_proofed AS short_excerpt_swe_proofed_22, s0_.parent_id AS parent_id_23, s0_.volume_id AS volume_id_24, s0_.updated_by_id AS updated_by_id_25 FROM sources s0_ LEFT JOIN volumes v1_ ON (s0_.volume_id = v1_.id) WHERE YEAR(s0_.date) = '1764' AND v1_.published <> 0 ORDER BY s0_.date ASC;

SELECT
  t0.id AS id_1,
  t0.created_date AS created_date_2,
  t0.release_date AS release_date_3,
  t0.user_id AS user_id_4,
  t0.source_id AS source_id_5
FROM
  `lock` t0
WHERE
  t0.source_id = ?

SELECT t0.id AS id_1, t0.created_date AS created_date_2, t0.release_date AS release_date_3, t0.user_id AS user_id_4, t0.source_id AS source_id_5 FROM `lock` t0 WHERE t0.source_id = 6060;

SELECT
  t0.id AS id_1,
  t0.created_date AS created_date_2,
  t0.release_date AS release_date_3,
  t0.user_id AS user_id_4,
  t0.source_id AS source_id_5
FROM
  `lock` t0
WHERE
  t0.source_id = ?

SELECT t0.id AS id_1, t0.created_date AS created_date_2, t0.release_date AS release_date_3, t0.user_id AS user_id_4, t0.source_id AS source_id_5 FROM `lock` t0 WHERE t0.source_id = 6061;

SELECT
  t0.id AS id_1,
  t0.created_date AS created_date_2,
  t0.release_date AS release_date_3,
  t0.user_id AS user_id_4,
  t0.source_id AS source_id_5
FROM
  `lock` t0
WHERE
  t0.source_id = ?

SELECT t0.id AS id_1, t0.created_date AS created_date_2, t0.release_date AS release_date_3, t0.user_id AS user_id_4, t0.source_id AS source_id_5 FROM `lock` t0 WHERE t0.source_id = 6062;

SELECT
  t0.id AS id_1,
  t0.created_date AS created_date_2,
  t0.release_date AS release_date_3,
  t0.user_id AS user_id_4,
  t0.source_id AS source_id_5
FROM
  `lock` t0
WHERE
  t0.source_id = ?

SELECT t0.id AS id_1, t0.created_date AS created_date_2, t0.release_date AS release_date_3, t0.user_id AS user_id_4, t0.source_id AS source_id_5 FROM `lock` t0 WHERE t0.source_id = 6063;

SELECT
  t0.id AS id_1,
  t0.created_date AS created_date_2,
  t0.release_date AS release_date_3,
  t0.user_id AS user_id_4,
  t0.source_id AS source_id_5
FROM
  `lock` t0
WHERE
  t0.source_id = ?

SELECT t0.id AS id_1, t0.created_date AS created_date_2, t0.release_date AS release_date_3, t0.user_id AS user_id_4, t0.source_id AS source_id_5 FROM `lock` t0 WHERE t0.source_id = 6064;

SELECT
  t0.id AS id_1,
  t0.created_date AS created_date_2,
  t0.release_date AS release_date_3,
  t0.user_id AS user_id_4,
  t0.source_id AS source_id_5
FROM
  `lock` t0
WHERE
  t0.source_id = ?

SELECT t0.id AS id_1, t0.created_date AS created_date_2, t0.release_date AS release_date_3, t0.user_id AS user_id_4, t0.source_id AS source_id_5 FROM `lock` t0 WHERE t0.source_id = 6065;

SELECT
  t0.id AS id_1,
  t0.created_date AS created_date_2,
  t0.release_date AS release_date_3,
  t0.user_id AS user_id_4,
  t0.source_id AS source_id_5
FROM
  `lock` t0
WHERE
  t0.source_id = ?

SELECT t0.id AS id_1, t0.created_date AS created_date_2, t0.release_date AS release_date_3, t0.user_id AS user_id_4, t0.source_id AS source_id_5 FROM `lock` t0 WHERE t0.source_id = 6066;

SELECT
  t0.id AS id_1,
  t0.created_date AS created_date_2,
  t0.release_date AS release_date_3,
  t0.user_id AS user_id_4,
  t0.source_id AS source_id_5
FROM
  `lock` t0
WHERE
  t0.source_id = ?

SELECT t0.id AS id_1, t0.created_date AS created_date_2, t0.release_date AS release_date_3, t0.user_id AS user_id_4, t0.source_id AS source_id_5 FROM `lock` t0 WHERE t0.source_id = 6067;

SELECT
  t0.id AS id_1,
  t0.created_date AS created_date_2,
  t0.release_date AS release_date_3,
  t0.user_id AS user_id_4,
  t0.source_id AS source_id_5
FROM
  `lock` t0
WHERE
  t0.source_id = ?

SELECT t0.id AS id_1, t0.created_date AS created_date_2, t0.release_date AS release_date_3, t0.user_id AS user_id_4, t0.source_id AS source_id_5 FROM `lock` t0 WHERE t0.source_id = 6068;

SELECT
  t0.id AS id_1,
  t0.created_date AS created_date_2,
  t0.release_date AS release_date_3,
  t0.user_id AS user_id_4,
  t0.source_id AS source_id_5
FROM
  `lock` t0
WHERE
  t0.source_id = ?

SELECT t0.id AS id_1, t0.created_date AS created_date_2, t0.release_date AS release_date_3, t0.user_id AS user_id_4, t0.source_id AS source_id_5 FROM `lock` t0 WHERE t0.source_id = 6069;

SELECT
  t0.id AS id_1,
  t0.created_date AS created_date_2,
  t0.release_date AS release_date_3,
  t0.user_id AS user_id_4,
  t0.source_id AS source_id_5
FROM
  `lock` t0
WHERE
  t0.source_id = ?

SELECT t0.id AS id_1, t0.created_date AS created_date_2, t0.release_date AS release_date_3, t0.user_id AS user_id_4, t0.source_id AS source_id_5 FROM `lock` t0 WHERE t0.source_id = 6070;

SELECT
  t0.id AS id_1,
  t0.created_date AS created_date_2,
  t0.release_date AS release_date_3,
  t0.user_id AS user_id_4,
  t0.source_id AS source_id_5
FROM
  `lock` t0
WHERE
  t0.source_id = ?

SELECT t0.id AS id_1, t0.created_date AS created_date_2, t0.release_date AS release_date_3, t0.user_id AS user_id_4, t0.source_id AS source_id_5 FROM `lock` t0 WHERE t0.source_id = 6071;

SELECT
  t0.id AS id_1,
  t0.created_date AS created_date_2,
  t0.release_date AS release_date_3,
  t0.user_id AS user_id_4,
  t0.source_id AS source_id_5
FROM
  `lock` t0
WHERE
  t0.source_id = ?

SELECT t0.id AS id_1, t0.created_date AS created_date_2, t0.release_date AS release_date_3, t0.user_id AS user_id_4, t0.source_id AS source_id_5 FROM `lock` t0 WHERE t0.source_id = 6072;

SELECT
  t0.id AS id_1,
  t0.created_date AS created_date_2,
  t0.release_date AS release_date_3,
  t0.user_id AS user_id_4,
  t0.source_id AS source_id_5
FROM
  `lock` t0
WHERE
  t0.source_id = ?

SELECT t0.id AS id_1, t0.created_date AS created_date_2, t0.release_date AS release_date_3, t0.user_id AS user_id_4, t0.source_id AS source_id_5 FROM `lock` t0 WHERE t0.source_id = 6073;

SELECT
  t0.id AS id_1,
  t0.created_date AS created_date_2,
  t0.release_date AS release_date_3,
  t0.user_id AS user_id_4,
  t0.source_id AS source_id_5
FROM
  `lock` t0
WHERE
  t0.source_id = ?

SELECT t0.id AS id_1, t0.created_date AS created_date_2, t0.release_date AS release_date_3, t0.user_id AS user_id_4, t0.source_id AS source_id_5 FROM `lock` t0 WHERE t0.source_id = 6074;

SELECT
  t0.id AS id_1,
  t0.created_date AS created_date_2,
  t0.release_date AS release_date_3,
  t0.user_id AS user_id_4,
  t0.source_id AS source_id_5
FROM
  `lock` t0
WHERE
  t0.source_id = ?

SELECT t0.id AS id_1, t0.created_date AS created_date_2, t0.release_date AS release_date_3, t0.user_id AS user_id_4, t0.source_id AS source_id_5 FROM `lock` t0 WHERE t0.source_id = 6075;

SELECT
  t0.id AS id_1,
  t0.created_date AS created_date_2,
  t0.release_date AS release_date_3,
  t0.user_id AS user_id_4,
  t0.source_id AS source_id_5
FROM
  `lock` t0
WHERE
  t0.source_id = ?

SELECT t0.id AS id_1, t0.created_date AS created_date_2, t0.release_date AS release_date_3, t0.user_id AS user_id_4, t0.source_id AS source_id_5 FROM `lock` t0 WHERE t0.source_id = 6076;

SELECT
  t0.id AS id_1,
  t0.created_date AS created_date_2,
  t0.release_date AS release_date_3,
  t0.user_id AS user_id_4,
  t0.source_id AS source_id_5
FROM
  `lock` t0
WHERE
  t0.source_id = ?

SELECT t0.id AS id_1, t0.created_date AS created_date_2, t0.release_date AS release_date_3, t0.user_id AS user_id_4, t0.source_id AS source_id_5 FROM `lock` t0 WHERE t0.source_id = 6077;

SELECT
  t0.id AS id_1,
  t0.created_date AS created_date_2,
  t0.release_date AS release_date_3,
  t0.user_id AS user_id_4,
  t0.source_id AS source_id_5
FROM
  `lock` t0
WHERE
  t0.source_id = ?

SELECT t0.id AS id_1, t0.created_date AS created_date_2, t0.release_date AS release_date_3, t0.user_id AS user_id_4, t0.source_id AS source_id_5 FROM `lock` t0 WHERE t0.source_id = 6078;

SELECT
  t0.id AS id_1,
  t0.created_date AS created_date_2,
  t0.release_date AS release_date_3,
  t0.user_id AS user_id_4,
  t0.source_id AS source_id_5
FROM
  `lock` t0
WHERE
  t0.source_id = ?

SELECT t0.id AS id_1, t0.created_date AS created_date_2, t0.release_date AS release_date_3, t0.user_id AS user_id_4, t0.source_id AS source_id_5 FROM `lock` t0 WHERE t0.source_id = 6079;

SELECT
  t0.id AS id_1,
  t0.created_date AS created_date_2,
  t0.release_date AS release_date_3,
  t0.user_id AS user_id_4,
  t0.source_id AS source_id_5
FROM
  `lock` t0
WHERE
  t0.source_id = ?

SELECT t0.id AS id_1, t0.created_date AS created_date_2, t0.release_date AS release_date_3, t0.user_id AS user_id_4, t0.source_id AS source_id_5 FROM `lock` t0 WHERE t0.source_id = 6080;

SELECT
  t0.id AS id_1,
  t0.created_date AS created_date_2,
  t0.release_date AS release_date_3,
  t0.user_id AS user_id_4,
  t0.source_id AS source_id_5
FROM
  `lock` t0
WHERE
  t0.source_id = ?

SELECT t0.id AS id_1, t0.created_date AS created_date_2, t0.release_date AS release_date_3, t0.user_id AS user_id_4, t0.source_id AS source_id_5 FROM `lock` t0 WHERE t0.source_id = 6081;

SELECT
  t0.id AS id_1,
  t0.created_date AS created_date_2,
  t0.release_date AS release_date_3,
  t0.user_id AS user_id_4,
  t0.source_id AS source_id_5
FROM
  `lock` t0
WHERE
  t0.source_id = ?

SELECT t0.id AS id_1, t0.created_date AS created_date_2, t0.release_date AS release_date_3, t0.user_id AS user_id_4, t0.source_id AS source_id_5 FROM `lock` t0 WHERE t0.source_id = 6082;

SELECT
  t0.id AS id_1,
  t0.created_date AS created_date_2,
  t0.release_date AS release_date_3,
  t0.user_id AS user_id_4,
  t0.source_id AS source_id_5
FROM
  `lock` t0
WHERE
  t0.source_id = ?

SELECT t0.id AS id_1, t0.created_date AS created_date_2, t0.release_date AS release_date_3, t0.user_id AS user_id_4, t0.source_id AS source_id_5 FROM `lock` t0 WHERE t0.source_id = 6083;

SELECT
  t0.id AS id_1,
  t0.created_date AS created_date_2,
  t0.release_date AS release_date_3,
  t0.user_id AS user_id_4,
  t0.source_id AS source_id_5
FROM
  `lock` t0
WHERE
  t0.source_id = ?

SELECT t0.id AS id_1, t0.created_date AS created_date_2, t0.release_date AS release_date_3, t0.user_id AS user_id_4, t0.source_id AS source_id_5 FROM `lock` t0 WHERE t0.source_id = 6084;

SELECT
  t0.id AS id_1,
  t0.created_date AS created_date_2,
  t0.release_date AS release_date_3,
  t0.user_id AS user_id_4,
  t0.source_id AS source_id_5
FROM
  `lock` t0
WHERE
  t0.source_id = ?

SELECT t0.id AS id_1, t0.created_date AS created_date_2, t0.release_date AS release_date_3, t0.user_id AS user_id_4, t0.source_id AS source_id_5 FROM `lock` t0 WHERE t0.source_id = 6085;

SELECT
  t0.id AS id_1,
  t0.created_date AS created_date_2,
  t0.release_date AS release_date_3,
  t0.user_id AS user_id_4,
  t0.source_id AS source_id_5
FROM
  `lock` t0
WHERE
  t0.source_id = ?

SELECT t0.id AS id_1, t0.created_date AS created_date_2, t0.release_date AS release_date_3, t0.user_id AS user_id_4, t0.source_id AS source_id_5 FROM `lock` t0 WHERE t0.source_id = 6086;

SELECT
  t0.id AS id_1,
  t0.created_date AS created_date_2,
  t0.release_date AS release_date_3,
  t0.user_id AS user_id_4,
  t0.source_id AS source_id_5
FROM
  `lock` t0
WHERE
  t0.source_id = ?

SELECT t0.id AS id_1, t0.created_date AS created_date_2, t0.release_date AS release_date_3, t0.user_id AS user_id_4, t0.source_id AS source_id_5 FROM `lock` t0 WHERE t0.source_id = 6087;

SELECT
  t0.id AS id_1,
  t0.created_date AS created_date_2,
  t0.release_date AS release_date_3,
  t0.user_id AS user_id_4,
  t0.source_id AS source_id_5
FROM
  `lock` t0
WHERE
  t0.source_id = ?

SELECT t0.id AS id_1, t0.created_date AS created_date_2, t0.release_date AS release_date_3, t0.user_id AS user_id_4, t0.source_id AS source_id_5 FROM `lock` t0 WHERE t0.source_id = 6089;

SELECT
  t0.id AS id_1,
  t0.created_date AS created_date_2,
  t0.release_date AS release_date_3,
  t0.user_id AS user_id_4,
  t0.source_id AS source_id_5
FROM
  `lock` t0
WHERE
  t0.source_id = ?

SELECT t0.id AS id_1, t0.created_date AS created_date_2, t0.release_date AS release_date_3, t0.user_id AS user_id_4, t0.source_id AS source_id_5 FROM `lock` t0 WHERE t0.source_id = 6088;

SELECT
  t0.id AS id_1,
  t0.created_date AS created_date_2,
  t0.release_date AS release_date_3,
  t0.user_id AS user_id_4,
  t0.source_id AS source_id_5
FROM
  `lock` t0
WHERE
  t0.source_id = ?

SELECT t0.id AS id_1, t0.created_date AS created_date_2, t0.release_date AS release_date_3, t0.user_id AS user_id_4, t0.source_id AS source_id_5 FROM `lock` t0 WHERE t0.source_id = 6090;

SELECT
  t0.id AS id_1,
  t0.created_date AS created_date_2,
  t0.release_date AS release_date_3,
  t0.user_id AS user_id_4,
  t0.source_id AS source_id_5
FROM
  `lock` t0
WHERE
  t0.source_id = ?

SELECT t0.id AS id_1, t0.created_date AS created_date_2, t0.release_date AS release_date_3, t0.user_id AS user_id_4, t0.source_id AS source_id_5 FROM `lock` t0 WHERE t0.source_id = 6091;

SELECT
  t0.id AS id_1,
  t0.created_date AS created_date_2,
  t0.release_date AS release_date_3,
  t0.user_id AS user_id_4,
  t0.source_id AS source_id_5
FROM
  `lock` t0
WHERE
  t0.source_id = ?

SELECT t0.id AS id_1, t0.created_date AS created_date_2, t0.release_date AS release_date_3, t0.user_id AS user_id_4, t0.source_id AS source_id_5 FROM `lock` t0 WHERE t0.source_id = 6092;