Symfony Profiler

[
  "route" => "organizer"
  "route_parameters" => [
    "_route" => "organizer"
    "_controller" => "App\Controller\Front\OrganizerController::organizer"
    "_locale" => "ar"
    "slug" => "usmo-ticket"
  ]
  "request_uri" => "https://www.sopovia.com/ar/organizer/usmo-ticket"
  "method" => "GET"
]

[
  "firewall_name" => "main"
  "authenticators" => 2
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "params" => [
    "driver" => "pdo_mysql"
    "idle_connection_ttl" => 600
    "host" => "127.0.0.1"
    "port" => 3306
    "user" => "u546667110_sopovia_db"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => []
    "dbname" => "u546667110_sopovia_db"
    "serverVersion" => "8.0"
    "charset" => "utf8mb4"
  ]
]

[
  "sql" => "SELECT e0_.id AS id_0, e0_.email AS email_1, e0_.gender AS gender_2, e0_.first_name AS first_name_3, e0_.last_name AS last_name_4, e0_.slug AS slug_5, e0_.street AS street_6, e0_.street2 AS street2_7, e0_.city AS city_8, e0_.state AS state_9, e0_.postal_code AS postal_code_10, e0_.phone AS phone_11, e0_.birth_date AS birth_date_12, e0_.avatar_name AS avatar_name_13, e0_.avatar_dimensions AS avatar_dimensions_14, e0_.facebook_profile_picture AS facebook_profile_picture_15, e0_.google_profile_picture AS google_profile_picture_16, e0_.facebook_id AS facebook_id_17, e0_.google_id AS google_id_18, e0_.api_key AS api_key_19, e0_.created_at AS created_at_20, e0_.updated_at AS updated_at_21, e0_.last_login_at AS last_login_at_22, e0_.roles AS roles_23, e0_.password AS password_24, e0_.is_enabled AS is_enabled_25, e0_.is_verified AS is_verified_26, e0_.country_id AS country_id_27, e0_.organizer_id AS organizer_id_28, e0_.scanner_id AS scanner_id_29, e0_.point_of_sale_id AS point_of_sale_id_30, e0_.is_organizer_on_homepage_slider_id AS is_organizer_on_homepage_slider_id_31 FROM eventic_user e0_ LEFT JOIN eventic_organizer e1_ ON e0_.organizer_id = e1_.id WHERE e1_.slug = ? AND e0_.is_enabled = ? AND e0_.slug <> ? ORDER BY e0_.created_at DESC"
  "params" => [
    1 => "usmo-ticket"
    2 => 1
    3 => "administrator"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1101
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#1216
      +name: "BOOLEAN"
    }
    3 => Doctrine\DBAL\ParameterType {#1101}
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.website AS website_5, t0.email AS email_6, t0.phone AS phone_7, t0.facebook AS facebook_8, t0.x AS x_9, t0.instagram AS instagram_10, t0.linked_in AS linked_in_11, t0.youtube_url AS youtube_url_12, t0.logo_name AS logo_name_13, t0.logo_dimensions AS logo_dimensions_14, t0.cover_name AS cover_name_15, t0.cover_dimensions AS cover_dimensions_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.views AS views_19, t0.show_venues_map AS show_venues_map_20, t0.show_followers AS show_followers_21, t0.show_reviews AS show_reviews_22, t0.show_event_date_stats_on_scanner_app AS show_event_date_stats_on_scanner_app_23, t0.allow_tap_to_check_in_on_scanner_app AS allow_tap_to_check_in_on_scanner_app_24, t0.user_id AS user_id_25, t0.country_id AS country_id_26 FROM eventic_organizer t0 WHERE t0.id = ?"
  "params" => [
    1 => 12
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1217
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.logo_name AS logo_name_2, t0.favicon_name AS favicon_name_3, t0.og_image_name AS og_image_name_4, t0.updated_at AS updated_at_5 FROM eventic_app_layout_setting t0 WHERE t0.id = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1217
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT e0_.id AS id_0, e0_.name AS name_1, e0_.slug AS slug_2, e0_.header AS header_3 FROM eventic_menu e0_ WHERE e0_.slug = ?"
  "params" => [
    1 => "header-menu"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1101
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM eventic_menu_translation t0 WHERE t0.object_id = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1217
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.label AS label_2, t0.slug AS slug_3, t0.icon AS icon_4, t0.link AS link_5, t0.custom_link AS custom_link_6, t0.position AS position_7, t0.menu_id AS menu_id_8 FROM eventic_menu_element t0 WHERE t0.menu_id = ? ORDER BY t0.position ASC"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1217
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM eventic_menu_element_translation t0 WHERE t0.object_id = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1217
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT COUNT(DISTINCT e0_.id) AS sclr_0 FROM eventic_event e0_ LEFT JOIN eventic_event_date e1_ ON e0_.id = e1_.event_id LEFT JOIN eventic_venue e2_ ON e1_.venue_id = e2_.id LEFT JOIN eventic_organizer e3_ ON e0_.organizer_id = e3_.id LEFT JOIN eventic_user e4_ ON e3_.user_id = e4_.id WHERE e3_.slug = ? AND e0_.published = ? AND e4_.is_enabled = ? ORDER BY e1_.start_date ASC"
  "params" => [
    1 => "usmo-ticket"
    2 => 1
    3 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1101
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#1216
      +name: "BOOLEAN"
    }
    3 => Doctrine\DBAL\ParameterType {#1216}
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.icon AS icon_4, t0.image_name AS image_name_5, t0.image_dimensions AS image_dimensions_6, t0.hidden AS hidden_7, t0.featured AS featured_8, t0.featured_order AS featured_order_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11 FROM eventic_category t0 INNER JOIN eventic_organizer_category ON t0.id = eventic_organizer_category.category_id WHERE eventic_organizer_category.organizer_id = ?"
  "params" => [
    1 => 12
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1217
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.email AS email_2, t0.gender AS gender_3, t0.first_name AS first_name_4, t0.last_name AS last_name_5, t0.slug AS slug_6, t0.street AS street_7, t0.street2 AS street2_8, t0.city AS city_9, t0.state AS state_10, t0.postal_code AS postal_code_11, t0.phone AS phone_12, t0.birth_date AS birth_date_13, t0.avatar_name AS avatar_name_14, t0.avatar_dimensions AS avatar_dimensions_15, t0.facebook_profile_picture AS facebook_profile_picture_16, t0.google_profile_picture AS google_profile_picture_17, t0.facebook_id AS facebook_id_18, t0.google_id AS google_id_19, t0.api_key AS api_key_20, t0.created_at AS created_at_21, t0.updated_at AS updated_at_22, t0.last_login_at AS last_login_at_23, t0.roles AS roles_24, t0.password AS password_25, t0.is_enabled AS is_enabled_26, t0.is_verified AS is_verified_27, t0.country_id AS country_id_28, t0.organizer_id AS organizer_id_29, t0.scanner_id AS scanner_id_30, t0.point_of_sale_id AS point_of_sale_id_31, t0.is_organizer_on_homepage_slider_id AS is_organizer_on_homepage_slider_id_32 FROM eventic_user t0 INNER JOIN eventic_following ON t0.id = eventic_following.user_id WHERE eventic_following.organizer_id = ?"
  "params" => [
    1 => 12
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1217
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT COUNT(DISTINCT e0_.id) AS sclr_0 FROM eventic_event e0_ LEFT JOIN eventic_event_date e1_ ON e0_.id = e1_.event_id LEFT JOIN eventic_venue e2_ ON e1_.venue_id = e2_.id LEFT JOIN eventic_organizer e3_ ON e0_.organizer_id = e3_.id LEFT JOIN eventic_user e4_ ON e3_.user_id = e4_.id WHERE e3_.slug = ? AND e0_.published = ? AND e1_.start_date >= CURRENT_TIMESTAMP AND e4_.is_enabled = ? ORDER BY e1_.start_date ASC"
  "params" => [
    1 => "usmo-ticket"
    2 => 1
    3 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1101
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#1216
      +name: "BOOLEAN"
    }
    3 => Doctrine\DBAL\ParameterType {#1216}
  ]
]

[
  "sql" => "SELECT COUNT(DISTINCT e0_.id) AS sclr_0 FROM eventic_event e0_ LEFT JOIN eventic_event_date e1_ ON e0_.id = e1_.event_id LEFT JOIN eventic_venue e2_ ON e1_.venue_id = e2_.id LEFT JOIN eventic_organizer e3_ ON e0_.organizer_id = e3_.id LEFT JOIN eventic_user e4_ ON e3_.user_id = e4_.id WHERE e3_.slug = ? AND e0_.published = ? AND e1_.start_date < CURRENT_TIMESTAMP AND e4_.is_enabled = ? ORDER BY e1_.start_date ASC"
  "params" => [
    1 => "usmo-ticket"
    2 => 1
    3 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1101
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#1216
      +name: "BOOLEAN"
    }
    3 => Doctrine\DBAL\ParameterType {#1216}
  ]
]

[
  "sql" => "SELECT DISTINCT e0_.id AS id_0, e0_.name AS name_1, e0_.slug AS slug_2, e0_.description AS description_3, e0_.reference AS reference_4, e0_.views AS views_5, e0_.youtube_url AS youtube_url_6, e0_.external_link AS external_link_7, e0_.phone_number AS phone_number_8, e0_.email AS email_9, e0_.x AS x_10, e0_.instagram AS instagram_11, e0_.facebook AS facebook_12, e0_.linked_in AS linked_in_13, e0_.tags AS tags_14, e0_.artists AS artists_15, e0_.year AS year_16, e0_.image_name AS image_name_17, e0_.image_dimensions AS image_dimensions_18, e0_.created_at AS created_at_19, e0_.updated_at AS updated_at_20, e0_.published AS published_21, e0_.enable_reviews AS enable_reviews_22, e0_.show_attendees AS show_attendees_23, e0_.category_id AS category_id_24, e0_.country_id AS country_id_25, e0_.organizer_id AS organizer_id_26, e0_.is_on_homepage_slider_id AS is_on_homepage_slider_id_27 FROM eventic_event e0_ LEFT JOIN eventic_event_date e1_ ON e0_.id = e1_.event_id LEFT JOIN eventic_venue e2_ ON e1_.venue_id = e2_.id LEFT JOIN eventic_organizer e3_ ON e0_.organizer_id = e3_.id LEFT JOIN eventic_user e4_ ON e3_.user_id = e4_.id WHERE e3_.slug = ? AND e0_.published = ? AND e1_.start_date >= CURRENT_TIMESTAMP AND e4_.is_enabled = ? ORDER BY e1_.start_date ASC LIMIT 10"
  "params" => [
    1 => "usmo-ticket"
    2 => 1
    3 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1101
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#1216
      +name: "BOOLEAN"
    }
    3 => Doctrine\DBAL\ParameterType {#1216}
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM eventic_event_translation t0 WHERE t0.object_id = ?"
  "params" => [
    1 => 18
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1217
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM eventic_event_translation t0 WHERE t0.object_id = ?"
  "params" => [
    1 => 17
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1217
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.online AS online_2, t0.has_seating_plan AS has_seating_plan_3, t0.reference AS reference_4, t0.active AS active_5, t0.start_date AS start_date_6, t0.end_date AS end_date_7, t0.event_id AS event_id_8, t0.venue_id AS venue_id_9, t0.seating_plan_id AS seating_plan_id_10 FROM eventic_event_date t0 WHERE t0.event_id = ? ORDER BY t0.start_date ASC"
  "params" => [
    1 => 18
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1217
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.reference AS reference_2, t0.active AS active_3, t0.name AS name_4, t0.description AS description_5, t0.free AS free_6, t0.price AS price_7, t0.promotional_price AS promotional_price_8, t0.quantity AS quantity_9, t0.tickets_per_attendee AS tickets_per_attendee_10, t0.sales_start_date AS sales_start_date_11, t0.sales_end_date AS sales_end_date_12, t0.position AS position_13, t0.seating_plan_sections AS seating_plan_sections_14, t0.event_date_id AS event_date_id_15 FROM eventic_event_date_ticket t0 WHERE t0.event_date_id = ? ORDER BY t0.position ASC"
  "params" => [
    1 => 20
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1217
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.reserved_seats AS reserved_seats_2, t0.unit_price AS unit_price_3, t0.quantity AS quantity_4, t0.order_id AS order_id_5, t0.event_ticket_id AS event_ticket_id_6 FROM eventic_order_element t0 WHERE t0.event_ticket_id = ?"
  "params" => [
    1 => 25
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1217
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.reference AS reference_2, t0.note AS note_3, t0.status AS status_4, t0.ticket_fee AS ticket_fee_5, t0.ticket_price_percentage_cut AS ticket_price_percentage_cut_6, t0.currency_ccy AS currency_ccy_7, t0.currency_symbol AS currency_symbol_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.user_id AS user_id_11, t0.payment_gateway_id AS payment_gateway_id_12, t0.payment_id AS payment_id_13 FROM eventic_order t0 WHERE t0.id = ?"
  "params" => [
    1 => 78
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1217
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.reference AS reference_2, t0.note AS note_3, t0.status AS status_4, t0.ticket_fee AS ticket_fee_5, t0.ticket_price_percentage_cut AS ticket_price_percentage_cut_6, t0.currency_ccy AS currency_ccy_7, t0.currency_symbol AS currency_symbol_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.user_id AS user_id_11, t0.payment_gateway_id AS payment_gateway_id_12, t0.payment_id AS payment_id_13 FROM eventic_order t0 WHERE t0.id = ?"
  "params" => [
    1 => 80
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1217
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.expires_at AS expires_at_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.user_id AS user_id_6, t0.event_ticket_id AS event_ticket_id_7, t0.order_element_id AS order_element_id_8 FROM eventic_ticket_reservation t0 WHERE t0.event_ticket_id = ?"
  "params" => [
    1 => 25
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1217
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.reference AS reference_2, t0.note AS note_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.status AS status_6, t0.payment_id AS payment_id_7, t0.organizer_id AS organizer_id_8, t0.payment_gateway_id AS payment_gateway_id_9, t0.event_date_id AS event_date_id_10 FROM eventic_payout_request t0 WHERE t0.event_date_id = ?"
  "params" => [
    1 => 20
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1217
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.seated_guests AS seated_guests_5, t0.standing_guests AS standing_guests_6, t0.neighborhoods AS neighborhoods_7, t0.food_beverage AS food_beverage_8, t0.pricing AS pricing_9, t0.availability AS availability_10, t0.hidden AS hidden_11, t0.show_map AS show_map_12, t0.quote_form AS quote_form_13, t0.contact_email AS contact_email_14, t0.listed_on_diretory AS listed_on_diretory_15, t0.street AS street_16, t0.street2 AS street2_17, t0.city AS city_18, t0.state AS state_19, t0.postal_code AS postal_code_20, t0.lat AS lat_21, t0.lng AS lng_22, t0.created_at AS created_at_23, t0.updated_at AS updated_at_24, t0.organizer_id AS organizer_id_25, t0.country_id AS country_id_26, t0.type_id AS type_id_27 FROM eventic_venue t0 WHERE t0.id = ?"
  "params" => [
    1 => 13
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1217
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM eventic_venue_translation t0 WHERE t0.object_id = ?"
  "params" => [
    1 => 13
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1217
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.hidden AS hidden_4, t0.code AS code_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7 FROM eventic_country t0 WHERE t0.id = ?"
  "params" => [
    1 => 101
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1217
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM eventic_country_translation t0 WHERE t0.object_id = ?"
  "params" => [
    1 => 101
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1217
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.icon AS icon_4, t0.image_name AS image_name_5, t0.image_dimensions AS image_dimensions_6, t0.hidden AS hidden_7, t0.featured AS featured_8, t0.featured_order AS featured_order_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11 FROM eventic_category t0 WHERE t0.id = ?"
  "params" => [
    1 => 11
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1217
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM eventic_category_translation t0 WHERE t0.object_id = ?"
  "params" => [
    1 => 11
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1217
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.online AS online_2, t0.has_seating_plan AS has_seating_plan_3, t0.reference AS reference_4, t0.active AS active_5, t0.start_date AS start_date_6, t0.end_date AS end_date_7, t0.event_id AS event_id_8, t0.venue_id AS venue_id_9, t0.seating_plan_id AS seating_plan_id_10 FROM eventic_event_date t0 WHERE t0.event_id = ? ORDER BY t0.start_date ASC"
  "params" => [
    1 => 17
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1217
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.reference AS reference_2, t0.active AS active_3, t0.name AS name_4, t0.description AS description_5, t0.free AS free_6, t0.price AS price_7, t0.promotional_price AS promotional_price_8, t0.quantity AS quantity_9, t0.tickets_per_attendee AS tickets_per_attendee_10, t0.sales_start_date AS sales_start_date_11, t0.sales_end_date AS sales_end_date_12, t0.position AS position_13, t0.seating_plan_sections AS seating_plan_sections_14, t0.event_date_id AS event_date_id_15 FROM eventic_event_date_ticket t0 WHERE t0.event_date_id = ? ORDER BY t0.position ASC"
  "params" => [
    1 => 19
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1217
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.reserved_seats AS reserved_seats_2, t0.unit_price AS unit_price_3, t0.quantity AS quantity_4, t0.order_id AS order_id_5, t0.event_ticket_id AS event_ticket_id_6 FROM eventic_order_element t0 WHERE t0.event_ticket_id = ?"
  "params" => [
    1 => 24
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1217
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.reference AS reference_2, t0.note AS note_3, t0.status AS status_4, t0.ticket_fee AS ticket_fee_5, t0.ticket_price_percentage_cut AS ticket_price_percentage_cut_6, t0.currency_ccy AS currency_ccy_7, t0.currency_symbol AS currency_symbol_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.user_id AS user_id_11, t0.payment_gateway_id AS payment_gateway_id_12, t0.payment_id AS payment_id_13 FROM eventic_order t0 WHERE t0.id = ?"
  "params" => [
    1 => 72
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1217
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.reference AS reference_2, t0.note AS note_3, t0.status AS status_4, t0.ticket_fee AS ticket_fee_5, t0.ticket_price_percentage_cut AS ticket_price_percentage_cut_6, t0.currency_ccy AS currency_ccy_7, t0.currency_symbol AS currency_symbol_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.user_id AS user_id_11, t0.payment_gateway_id AS payment_gateway_id_12, t0.payment_id AS payment_id_13 FROM eventic_order t0 WHERE t0.id = ?"
  "params" => [
    1 => 73
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1217
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.reference AS reference_2, t0.note AS note_3, t0.status AS status_4, t0.ticket_fee AS ticket_fee_5, t0.ticket_price_percentage_cut AS ticket_price_percentage_cut_6, t0.currency_ccy AS currency_ccy_7, t0.currency_symbol AS currency_symbol_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.user_id AS user_id_11, t0.payment_gateway_id AS payment_gateway_id_12, t0.payment_id AS payment_id_13 FROM eventic_order t0 WHERE t0.id = ?"
  "params" => [
    1 => 74
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1217
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.reference AS reference_2, t0.note AS note_3, t0.status AS status_4, t0.ticket_fee AS ticket_fee_5, t0.ticket_price_percentage_cut AS ticket_price_percentage_cut_6, t0.currency_ccy AS currency_ccy_7, t0.currency_symbol AS currency_symbol_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.user_id AS user_id_11, t0.payment_gateway_id AS payment_gateway_id_12, t0.payment_id AS payment_id_13 FROM eventic_order t0 WHERE t0.id = ?"
  "params" => [
    1 => 75
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1217
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.reference AS reference_2, t0.note AS note_3, t0.status AS status_4, t0.ticket_fee AS ticket_fee_5, t0.ticket_price_percentage_cut AS ticket_price_percentage_cut_6, t0.currency_ccy AS currency_ccy_7, t0.currency_symbol AS currency_symbol_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.user_id AS user_id_11, t0.payment_gateway_id AS payment_gateway_id_12, t0.payment_id AS payment_id_13 FROM eventic_order t0 WHERE t0.id = ?"
  "params" => [
    1 => 76
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1217
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.reference AS reference_2, t0.note AS note_3, t0.status AS status_4, t0.ticket_fee AS ticket_fee_5, t0.ticket_price_percentage_cut AS ticket_price_percentage_cut_6, t0.currency_ccy AS currency_ccy_7, t0.currency_symbol AS currency_symbol_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.user_id AS user_id_11, t0.payment_gateway_id AS payment_gateway_id_12, t0.payment_id AS payment_id_13 FROM eventic_order t0 WHERE t0.id = ?"
  "params" => [
    1 => 77
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1217
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.reference AS reference_2, t0.note AS note_3, t0.status AS status_4, t0.ticket_fee AS ticket_fee_5, t0.ticket_price_percentage_cut AS ticket_price_percentage_cut_6, t0.currency_ccy AS currency_ccy_7, t0.currency_symbol AS currency_symbol_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.user_id AS user_id_11, t0.payment_gateway_id AS payment_gateway_id_12, t0.payment_id AS payment_id_13 FROM eventic_order t0 WHERE t0.id = ?"
  "params" => [
    1 => 79
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1217
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.expires_at AS expires_at_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.user_id AS user_id_6, t0.event_ticket_id AS event_ticket_id_7, t0.order_element_id AS order_element_id_8 FROM eventic_ticket_reservation t0 WHERE t0.event_ticket_id = ?"
  "params" => [
    1 => 24
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1217
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.reference AS reference_2, t0.note AS note_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.status AS status_6, t0.payment_id AS payment_id_7, t0.organizer_id AS organizer_id_8, t0.payment_gateway_id AS payment_gateway_id_9, t0.event_date_id AS event_date_id_10 FROM eventic_payout_request t0 WHERE t0.event_date_id = ?"
  "params" => [
    1 => 19
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1217
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT COUNT(e0_.id) AS sclr_0 FROM eventic_review e0_ LEFT JOIN eventic_event e1_ ON e0_.event_id = e1_.id LEFT JOIN eventic_organizer e2_ ON e1_.organizer_id = e2_.id WHERE e2_.slug = ? AND e0_.visible = ? ORDER BY e0_.created_at DESC"
  "params" => [
    1 => "usmo-ticket"
    2 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1101
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#1216
      +name: "BOOLEAN"
    }
  ]
]

[
  "sql" => "SELECT e0_.id AS id_0, e0_.name AS name_1, e0_.slug AS slug_2, e0_.header AS header_3 FROM eventic_menu e0_ WHERE e0_.slug = ?"
  "params" => [
    1 => "first-footer-section-menu"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1101
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM eventic_menu_translation t0 WHERE t0.object_id = ?"
  "params" => [
    1 => 2
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1217
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT e0_.id AS id_0, e0_.name AS name_1, e0_.slug AS slug_2, e0_.header AS header_3 FROM eventic_menu e0_ WHERE e0_.slug = ?"
  "params" => [
    1 => "first-footer-section-menu"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1101
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.label AS label_2, t0.slug AS slug_3, t0.icon AS icon_4, t0.link AS link_5, t0.custom_link AS custom_link_6, t0.position AS position_7, t0.menu_id AS menu_id_8 FROM eventic_menu_element t0 WHERE t0.menu_id = ? ORDER BY t0.position ASC"
  "params" => [
    1 => 2
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1217
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM eventic_menu_element_translation t0 WHERE t0.object_id = ?"
  "params" => [
    1 => 10
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1217
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM eventic_menu_element_translation t0 WHERE t0.object_id = ?"
  "params" => [
    1 => 12
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1217
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT e0_.id AS id_0, e0_.name AS name_1, e0_.slug AS slug_2, e0_.header AS header_3 FROM eventic_menu e0_ WHERE e0_.slug = ?"
  "params" => [
    1 => "second-footer-section-menu"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1101
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM eventic_menu_translation t0 WHERE t0.object_id = ?"
  "params" => [
    1 => 3
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1217
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT e0_.id AS id_0, e0_.name AS name_1, e0_.slug AS slug_2, e0_.header AS header_3 FROM eventic_menu e0_ WHERE e0_.slug = ?"
  "params" => [
    1 => "second-footer-section-menu"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1101
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.label AS label_2, t0.slug AS slug_3, t0.icon AS icon_4, t0.link AS link_5, t0.custom_link AS custom_link_6, t0.position AS position_7, t0.menu_id AS menu_id_8 FROM eventic_menu_element t0 WHERE t0.menu_id = ? ORDER BY t0.position ASC"
  "params" => [
    1 => 3
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1217
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM eventic_menu_element_translation t0 WHERE t0.object_id = ?"
  "params" => [
    1 => 14
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1217
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM eventic_menu_element_translation t0 WHERE t0.object_id = ?"
  "params" => [
    1 => 15
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1217
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM eventic_menu_element_translation t0 WHERE t0.object_id = ?"
  "params" => [
    1 => 16
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1217
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM eventic_menu_element_translation t0 WHERE t0.object_id = ?"
  "params" => [
    1 => 17
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1217
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM eventic_menu_element_translation t0 WHERE t0.object_id = ?"
  "params" => [
    1 => 18
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1217
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT e0_.id AS id_0, e0_.name AS name_1, e0_.slug AS slug_2, e0_.header AS header_3 FROM eventic_menu e0_ WHERE e0_.slug = ?"
  "params" => [
    1 => "third-footer-section-menu"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1101
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM eventic_menu_translation t0 WHERE t0.object_id = ?"
  "params" => [
    1 => 4
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1217
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT e0_.id AS id_0, e0_.name AS name_1, e0_.slug AS slug_2, e0_.header AS header_3 FROM eventic_menu e0_ WHERE e0_.slug = ?"
  "params" => [
    1 => "third-footer-section-menu"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1101
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.label AS label_2, t0.slug AS slug_3, t0.icon AS icon_4, t0.link AS link_5, t0.custom_link AS custom_link_6, t0.position AS position_7, t0.menu_id AS menu_id_8 FROM eventic_menu_element t0 WHERE t0.menu_id = ? ORDER BY t0.position ASC"
  "params" => [
    1 => 4
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1217
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM eventic_menu_element_translation t0 WHERE t0.object_id = ?"
  "params" => [
    1 => 19
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1217
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM eventic_menu_element_translation t0 WHERE t0.object_id = ?"
  "params" => [
    1 => 20
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1217
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT e0_.id AS id_0, e0_.name AS name_1, e0_.slug AS slug_2, e0_.icon AS icon_3, e0_.image_name AS image_name_4, e0_.image_dimensions AS image_dimensions_5, e0_.hidden AS hidden_6, e0_.featured AS featured_7, e0_.featured_order AS featured_order_8, e0_.created_at AS created_at_9, e0_.updated_at AS updated_at_10 FROM eventic_category e0_ WHERE e0_.hidden = ? AND e0_.slug <> ? AND e0_.featured = ? ORDER BY e0_.featured_order ASC LIMIT 4"
  "params" => [
    1 => 0
    2 => "notSlug"
    3 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1216
      +name: "BOOLEAN"
    }
    2 => Doctrine\DBAL\ParameterType {#1101
      +name: "STRING"
    }
    3 => Doctrine\DBAL\ParameterType {#1216}
  ]
]