GET https://icecream.ll.allgofree.org/search/sc/submit?query=gambling&sourceText=

Response
200 OK
Browse referrer URL
IP
10.0.13.1
Profiled on
Token
b46dcb

Query Metrics

31 Database Queries
18 Different statements
43.69 ms Query time
0 Invalid entities
36 Managed entities

Queries

Group similar statements

#▲ Time Info
1 0.86 ms 
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 = ?
Parameters: 
[
  20
]
View formatted query    View runnable query    Explain query    View query backtrace
2 1.13 ms 
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
Parameters: 
[
  "sc"
  5
]
View formatted query    View runnable query    Explain query    View query backtrace
3 0.55 ms 
SELECT t0.id AS id_1, t0.abbreviation AS abbreviation_2, t0.definition AS definition_3 FROM abbreviations t0
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
4 0.77 ms 
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
Parameters: 
[
  "gambling"
]
View formatted query    View runnable query    Explain query    View query backtrace
5 12.33 ms 
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
Parameters: 
[
  "%gambling%"
  "%gambling%"
  "%gambling%"
  "%gambling%"
  "%gambling%"
  13
]
View formatted query    View runnable query    Explain query    View query backtrace
6 7.30 ms 
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
Parameters: 
[
  "%gambling%"
  "%gambling%"
  "%gambling%"
  "%gambling%"
  "%gambling%"
  13
]
View formatted query    View runnable query    Explain query    View query backtrace
7 1.45 ms 
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 = ?
Parameters: 
[
  37
]
View formatted query    View runnable query    Explain query    View query backtrace
8 0.31 ms 
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 = ?
Parameters: 
[
  52
]
View formatted query    View runnable query    Explain query    View query backtrace
9 0.30 ms 
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 = ?
Parameters: 
[
  438
]
View formatted query    View runnable query    Explain query    View query backtrace
10 0.30 ms 
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 = ?
Parameters: 
[
  810
]
View formatted query    View runnable query    Explain query    View query backtrace
11 0.33 ms 
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 = ?
Parameters: 
[
  811
]
View formatted query    View runnable query    Explain query    View query backtrace
12 0.39 ms 
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 = ?
Parameters: 
[
  812
]
View formatted query    View runnable query    Explain query    View query backtrace
13 0.29 ms 
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 = ?
Parameters: 
[
  813
]
View formatted query    View runnable query    Explain query    View query backtrace
14 0.27 ms 
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 = ?
Parameters: 
[
  814
]
View formatted query    View runnable query    Explain query    View query backtrace
15 0.25 ms 
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 = ?
Parameters: 
[
  815
]
View formatted query    View runnable query    Explain query    View query backtrace
16 0.24 ms 
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 = ?
Parameters: 
[
  816
]
View formatted query    View runnable query    Explain query    View query backtrace
17 0.24 ms 
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 = ?
Parameters: 
[
  817
]
View formatted query    View runnable query    Explain query    View query backtrace
18 0.25 ms 
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 = ?
Parameters: 
[
  1686
]
View formatted query    View runnable query    Explain query    View query backtrace
19 0.27 ms 
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 = ?
Parameters: 
[
  1922
]
View formatted query    View runnable query    Explain query    View query backtrace
20 0.25 ms 
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 = ?
Parameters: 
[
  1923
]
View formatted query    View runnable query    Explain query    View query backtrace
21 1.14 ms 
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
Parameters: 
[
  "gambling"
]
View formatted query    View runnable query    Explain query    View query backtrace
22 0.37 ms 
SELECT t0.id AS id_1, t0.name AS name_2 FROM os_names t0 WHERE t0.name = ? LIMIT 1
Parameters: 
[
  "Mac"
]
View formatted query    View runnable query    Explain query    View query backtrace
23 1.13 ms 
SELECT t0.id AS id_1, t0.version AS version_2 FROM os_versions t0 WHERE t0.version = ? LIMIT 1
Parameters: 
[
  "10.15"
]
View formatted query    View runnable query    Explain query    View query backtrace
24 0.96 ms 
SELECT t0.id AS id_1, t0.name AS name_2 FROM browser_names t0 WHERE t0.name = ? LIMIT 1
Parameters: 
[
  "Firefox"
]
View formatted query    View runnable query    Explain query    View query backtrace
25 1.04 ms 
SELECT t0.id AS id_1, t0.version AS version_2 FROM browser_versions t0 WHERE t0.version = ? LIMIT 1
Parameters: 
[
  "141.0"
]
View formatted query    View runnable query    Explain query    View query backtrace
26 0.26 ms 
SELECT t0.id AS id_1, t0.device_name AS device_name_2 FROM device_types t0 WHERE t0.id = ? LIMIT 1
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
27 0.32 ms 
"START TRANSACTION"
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
28 1.34 ms 
INSERT INTO search_log_terms (term, total_search_count) VALUES (?, ?)
Parameters: 
[
  "gambling"
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
29 6.05 ms 
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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters: 
[
  "2025-08-25 16:32:12"
  14
  0
  0
  null
  null
  null
  0
  20
  156
  1
  1
  1
  11
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
30 0.92 ms 
UPDATE user SET last_active_at = ? WHERE id = ?
Parameters: 
[
  "2025-08-25 16:32:12"
  20
]
View formatted query    View runnable query    Explain query    View query backtrace
31 2.06 ms 
"COMMIT"
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace

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.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\Statute 14
App\Entity\Abbreviation 13
App\Entity\User 1
App\Entity\Dataset 1
App\Entity\OSName 1
App\Entity\OSVersion 1
App\Entity\BrowserName 1
App\Entity\BrowserVersion 1
App\Entity\DeviceType 1
App\Entity\SearchLogTerm 1
App\Entity\SearchLog 1

Entities Mapping

Class Mapping errors
App\Entity\User No errors.
App\Entity\ReviewerAction No errors.
App\Entity\SearchLog No errors.
App\Entity\OutsetaAccountId No errors.
App\Entity\OutsetaAccount No errors.
App\Entity\APIKey No errors.
App\Entity\FavoriteCategory No errors.
App\Entity\Favorite No errors.
App\Entity\Dataset No errors.
App\Entity\Statute No errors.
App\Entity\StatuteText No errors.
App\Entity\RuleText No errors.
App\Entity\Exemption No errors.
App\Entity\MaximumSentence No errors.
App\Entity\RepeatOffender No errors.
App\Entity\SeriousCrime No errors.
App\Entity\SubsectionOverride No errors.
App\Entity\ViolentCrime No errors.
App\Entity\Abbreviation No errors.
App\Entity\WordAssociation No errors.
App\Entity\StatuteTranslation No errors.
App\Entity\SearchLogTerm No errors.
App\Entity\OSName No errors.
App\Entity\OSVersion No errors.
App\Entity\BrowserName No errors.
App\Entity\BrowserVersion No errors.
App\Entity\DeviceType No errors.
App\Entity\OffenseViewLog No errors.