Symfony Profiler

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        SELECT
          s0_.id AS id_0,
          s0_.legal_text_type AS legal_text_type_1,
          s0_.description_text AS description_text_2,
          s0_.cdr_code AS cdr_code_3,
          s0_.offense_statutes AS offense_statutes_4,
          s0_.penalty_statutes AS penalty_statutes_5,
          s0_.offense_type AS offense_type_6,
          s0_.offense_class AS offense_class_7,
          s0_.election AS election_8,
          s0_.insurance AS insurance_9,
          s0_.dmv AS dmv_10,
          s0_.sled AS sled_11,
          s0_.ai_summary_prompt_context AS ai_summary_prompt_context_12,
          s0_.ai_summary AS ai_summary_13,
          s0_.ai_penalty_prompt_context AS ai_penalty_prompt_context_14,
          s0_.ai_penalty_financial AS ai_penalty_financial_15,
          s0_.ai_penalty_prison AS ai_penalty_prison_16,
          s0_.ai_penalty_other AS ai_penalty_other_17,
          s0_.notes AS notes_18,
          s0_.review_state AS review_state_19,
          s0_.review_flags AS review_flags_20,
          s0_.algorithm_flags AS algorithm_flags_21,
          s0_.violent_computed AS violent_computed_22,
          s0_.severity_computed AS severity_computed_23,
          s0_.search_keywords AS search_keywords_24
        FROM
          statutes s0_
        WHERE
          (
            s0_.description_text LIKE ?
            OR s0_.offense_statutes LIKE ?
            OR s0_.penalty_statutes LIKE ?
            OR s0_.search_keywords LIKE ?
            OR s0_.cdr_code LIKE ?
          )
          AND s0_.dataset_id = ?
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT s0_.id AS id_0, s0_.legal_text_type AS legal_text_type_1, s0_.description_text AS description_text_2, s0_.cdr_code AS cdr_code_3, s0_.offense_statutes AS offense_statutes_4, s0_.penalty_statutes AS penalty_statutes_5, s0_.offense_type AS offense_type_6, s0_.offense_class AS offense_class_7, s0_.election AS election_8, s0_.insurance AS insurance_9, s0_.dmv AS dmv_10, s0_.sled AS sled_11, s0_.ai_summary_prompt_context AS ai_summary_prompt_context_12, s0_.ai_summary AS ai_summary_13, s0_.ai_penalty_prompt_context AS ai_penalty_prompt_context_14, s0_.ai_penalty_financial AS ai_penalty_financial_15, s0_.ai_penalty_prison AS ai_penalty_prison_16, s0_.ai_penalty_other AS ai_penalty_other_17, s0_.notes AS notes_18, s0_.review_state AS review_state_19, s0_.review_flags AS review_flags_20, s0_.algorithm_flags AS algorithm_flags_21, s0_.violent_computed AS violent_computed_22, s0_.severity_computed AS severity_computed_23, s0_.search_keywords AS search_keywords_24 FROM statutes s0_ WHERE (s0_.description_text LIKE '%gambling%' OR s0_.offense_statutes LIKE '%gambling%' OR s0_.penalty_statutes LIKE '%gambling%' OR s0_.search_keywords LIKE '%gambling%' OR s0_.cdr_code LIKE '%gambling%') AND s0_.dataset_id = 13) dctrn_result) dctrn_table;

SELECT
  s0_.id AS id_0,
  s0_.legal_text_type AS legal_text_type_1,
  s0_.description_text AS description_text_2,
  s0_.cdr_code AS cdr_code_3,
  s0_.offense_statutes AS offense_statutes_4,
  s0_.penalty_statutes AS penalty_statutes_5,
  s0_.offense_type AS offense_type_6,
  s0_.offense_class AS offense_class_7,
  s0_.election AS election_8,
  s0_.insurance AS insurance_9,
  s0_.dmv AS dmv_10,
  s0_.sled AS sled_11,
  s0_.ai_summary_prompt_context AS ai_summary_prompt_context_12,
  s0_.ai_summary AS ai_summary_13,
  s0_.ai_penalty_prompt_context AS ai_penalty_prompt_context_14,
  s0_.ai_penalty_financial AS ai_penalty_financial_15,
  s0_.ai_penalty_prison AS ai_penalty_prison_16,
  s0_.ai_penalty_other AS ai_penalty_other_17,
  s0_.notes AS notes_18,
  s0_.review_state AS review_state_19,
  s0_.review_flags AS review_flags_20,
  s0_.algorithm_flags AS algorithm_flags_21,
  s0_.violent_computed AS violent_computed_22,
  s0_.severity_computed AS severity_computed_23,
  s0_.search_keywords AS search_keywords_24,
  s0_.dataset_id AS dataset_id_25
FROM
  statutes s0_
WHERE
  (
    s0_.description_text LIKE ?
    OR s0_.offense_statutes LIKE ?
    OR s0_.penalty_statutes LIKE ?
    OR s0_.search_keywords LIKE ?
    OR s0_.cdr_code LIKE ?
  )
  AND s0_.dataset_id = ?
LIMIT
  25

SELECT s0_.id AS id_0, s0_.legal_text_type AS legal_text_type_1, s0_.description_text AS description_text_2, s0_.cdr_code AS cdr_code_3, s0_.offense_statutes AS offense_statutes_4, s0_.penalty_statutes AS penalty_statutes_5, s0_.offense_type AS offense_type_6, s0_.offense_class AS offense_class_7, s0_.election AS election_8, s0_.insurance AS insurance_9, s0_.dmv AS dmv_10, s0_.sled AS sled_11, s0_.ai_summary_prompt_context AS ai_summary_prompt_context_12, s0_.ai_summary AS ai_summary_13, s0_.ai_penalty_prompt_context AS ai_penalty_prompt_context_14, s0_.ai_penalty_financial AS ai_penalty_financial_15, s0_.ai_penalty_prison AS ai_penalty_prison_16, s0_.ai_penalty_other AS ai_penalty_other_17, s0_.notes AS notes_18, s0_.review_state AS review_state_19, s0_.review_flags AS review_flags_20, s0_.algorithm_flags AS algorithm_flags_21, s0_.violent_computed AS violent_computed_22, s0_.severity_computed AS severity_computed_23, s0_.search_keywords AS search_keywords_24, s0_.dataset_id AS dataset_id_25 FROM statutes s0_ WHERE (s0_.description_text LIKE '%gambling%' OR s0_.offense_statutes LIKE '%gambling%' OR s0_.penalty_statutes LIKE '%gambling%' OR s0_.search_keywords LIKE '%gambling%' OR s0_.cdr_code LIKE '%gambling%') AND s0_.dataset_id = 13 LIMIT 25;

INSERT INTO search_logs (
  search_timestamp, result_count, view_count,
  has_feedback, feedback, suggested_results,
  internal_notes, exclude_from_metrics,
  user_id, search_term_id, os_name_id,
  os_version_id, browser_name_id,
  browser_version_id, device_type_id
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO search_logs (search_timestamp, result_count, view_count, has_feedback, feedback, suggested_results, internal_notes, exclude_from_metrics, user_id, search_term_id, os_name_id, os_version_id, browser_name_id, browser_version_id, device_type_id) VALUES ('2025-08-25 16:32:12', 14, 0, 0, NULL, NULL, NULL, 0, 20, 156, 1, 1, 1, 11, 1);

SELECT
  t0.id AS id_1,
  t0.legal_text_type AS legal_text_type_2,
  t0.section_number AS section_number_3,
  t0.section_name AS section_name_4,
  t0.content_text AS content_text_5,
  t0.alias_simple AS alias_simple_6,
  t0.alias_padded AS alias_padded_7,
  t0.tag AS tag_8,
  t0.label AS label_9,
  t0.identifier AS identifier_10,
  t0.type AS type_11,
  t0.volume AS volume_12,
  t0.descendant_range_start AS descendant_range_start_13,
  t0.descendant_range_end AS descendant_range_end_14,
  t0.content_type_flags AS content_type_flags_15,
  t0.dataset_id AS dataset_id_16,
  t0.parent_id AS parent_id_17,
  t0.primary_statute_id AS primary_statute_id_18
FROM
  statute_texts t0
WHERE
  t0.primary_statute_id = ?

SELECT t0.id AS id_1, t0.legal_text_type AS legal_text_type_2, t0.section_number AS section_number_3, t0.section_name AS section_name_4, t0.content_text AS content_text_5, t0.alias_simple AS alias_simple_6, t0.alias_padded AS alias_padded_7, t0.tag AS tag_8, t0.label AS label_9, t0.identifier AS identifier_10, t0.type AS type_11, t0.volume AS volume_12, t0.descendant_range_start AS descendant_range_start_13, t0.descendant_range_end AS descendant_range_end_14, t0.content_type_flags AS content_type_flags_15, t0.dataset_id AS dataset_id_16, t0.parent_id AS parent_id_17, t0.primary_statute_id AS primary_statute_id_18 FROM statute_texts t0 WHERE t0.primary_statute_id = 37;

"COMMIT"

"COMMIT";

INSERT INTO search_log_terms (term, total_search_count)
VALUES
  (?, ?)

INSERT INTO search_log_terms (term, total_search_count) VALUES ('gambling', 1);

SELECT
  t0.id AS id_1,
  t0.term AS term_2,
  t0.total_search_count AS total_search_count_3
FROM
  search_log_terms t0
WHERE
  t0.term = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.term AS term_2, t0.total_search_count AS total_search_count_3 FROM search_log_terms t0 WHERE t0.term = 'gambling' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.version AS version_2
FROM
  os_versions t0
WHERE
  t0.version = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.version AS version_2 FROM os_versions t0 WHERE t0.version = '10.15' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.jurisdiction AS jurisdiction_2,
  t0.collection_time AS collection_time_3,
  t0.state AS state_4
FROM
  datasets t0
WHERE
  t0.jurisdiction = ?
  AND t0.state = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.jurisdiction AS jurisdiction_2, t0.collection_time AS collection_time_3, t0.state AS state_4 FROM datasets t0 WHERE t0.jurisdiction = 'sc' AND t0.state = 5 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.version AS version_2
FROM
  browser_versions t0
WHERE
  t0.version = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.version AS version_2 FROM browser_versions t0 WHERE t0.version = '141.0' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  browser_names t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2 FROM browser_names t0 WHERE t0.name = 'Firefox' LIMIT 1;

UPDATE
  user
SET
  last_active_at = ?
WHERE
  id = ?

UPDATE user SET last_active_at = '2025-08-25 16:32:12' WHERE id = 20;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.is_verified AS is_verified_5,
  t0.outseta_person_id AS outseta_person_id_6,
  t0.active_subscriptions AS active_subscriptions_7,
  t0.force_enabled_subscriptions AS force_enabled_subscriptions_8,
  t0.last_active_at AS last_active_at_9
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_verified AS is_verified_5, t0.outseta_person_id AS outseta_person_id_6, t0.active_subscriptions AS active_subscriptions_7, t0.force_enabled_subscriptions AS force_enabled_subscriptions_8, t0.last_active_at AS last_active_at_9 FROM user t0 WHERE t0.id = 20;

SELECT
  w0_.id AS id_0,
  w0_.word AS word_1,
  w0_.associated_words AS associated_words_2,
  w0_.is_disabled AS is_disabled_3
FROM
  word_association w0_
WHERE
  w0_.word IN (?)
  AND w0_.is_disabled = 0

SELECT w0_.id AS id_0, w0_.word AS word_1, w0_.associated_words AS associated_words_2, w0_.is_disabled AS is_disabled_3 FROM word_association w0_ WHERE w0_.word IN ('gambling') AND w0_.is_disabled = 0;

SELECT
  t0.id AS id_1,
  t0.abbreviation AS abbreviation_2,
  t0.definition AS definition_3
FROM
  abbreviations t0

SELECT t0.id AS id_1, t0.abbreviation AS abbreviation_2, t0.definition AS definition_3 FROM abbreviations t0;

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  os_names t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2 FROM os_names t0 WHERE t0.name = 'Mac' LIMIT 1;

"START TRANSACTION"

"START TRANSACTION";

SELECT
  t0.id AS id_1,
  t0.device_name AS device_name_2
FROM
  device_types t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.device_name AS device_name_2 FROM device_types t0 WHERE t0.id = 1 LIMIT 1;