# |
type |
message |
1 | sfPatternRouting | Match route "session_on_sale_today" (/event/on-sale-today/*) for /event/on-sale-today with parameters array ( 'module' => 'session', 'action' => 'onSaleToday',) |
2 | sfCacheSessionStorage | New session created |
3 | myUser | Restoring cookie (No cookie): null |
4 | Doctrine_Connection_Mysql | exec : SET NAMES 'UTF8' - () |
5 | Doctrine_Connection_Statement | execute : SELECT a.id AS a__id, a.name AS a__name, a.short_name AS a__short_name, a.description AS a__description, a.whitelabel_url AS a__whitelabel_url, a.official_url AS a__official_url, a.facebook_page_url AS a__facebook_page_url, a.facebook_app_id AS a__facebook_app_id, a.facebook_app_namespace AS a__facebook_app_namespace, a.facebook_app_secret AS a__facebook_app_secret, a.google_analytics_id AS a__google_analytics_id, a.third_party_analytics_id AS a__third_party_analytics_id, a.contact_name AS a__contact_name, a.contact_email AS a__contact_email, a.account_manager AS a__account_manager, a.basket AS a__basket, a.is_active AS a__is_active, a.is_tst_venue AS a__is_tst_venue, a.has_newsletter AS a__has_newsletter, a.ticketlight_distributor_id AS a__ticketlight_distributor_id, a.created_at AS a__created_at, a.updated_at AS a__updated_at, a.slug AS a__slug FROM affiliate a WHERE (a.short_name = ?) - (ticketline) |
6 | Doctrine_Connection_Statement | execute : SELECT a.id AS a__id, a.name AS a__name, a.short_name AS a__short_name, a.description AS a__description, a.whitelabel_url AS a__whitelabel_url, a.official_url AS a__official_url, a.facebook_page_url AS a__facebook_page_url, a.facebook_app_id AS a__facebook_app_id, a.facebook_app_namespace AS a__facebook_app_namespace, a.facebook_app_secret AS a__facebook_app_secret, a.google_analytics_id AS a__google_analytics_id, a.third_party_analytics_id AS a__third_party_analytics_id, a.contact_name AS a__contact_name, a.contact_email AS a__contact_email, a.account_manager AS a__account_manager, a.basket AS a__basket, a.is_active AS a__is_active, a.is_tst_venue AS a__is_tst_venue, a.has_newsletter AS a__has_newsletter, a.ticketlight_distributor_id AS a__ticketlight_distributor_id, a.created_at AS a__created_at, a.updated_at AS a__updated_at, a.slug AS a__slug FROM affiliate a WHERE (a.short_name = ?) - (ticketline) |
7 | sfFilterChain | Executing filter "sfRenderingFilter" |
8 | sfFilterChain | Executing filter "tlReferrerFilter" |
9 | myUser | setting referrer: "http://www.ticketline.co.uk/frontend_dev.php/event/on-sale-today" |
10 | sfFilterChain | Executing filter "sfGuardRememberMeFilter" |
11 | sfFilterChain | Executing filter "tlRobotsMetaFilter" |
12 | sfFilterChain | Executing filter "tlSocialFilter" |
13 | sfFilterChain | Executing filter "tlMobileDeviceDetectionFilter" |
14 | sfFilterChain | Executing filter "tlHttpHeaderFilter" |
15 | sfFilterChain | Executing filter "tlRetinaFilter" |
16 | myUser | setting retina display: "" |
17 | sfFilterChain | Executing filter "sfSslRequirementFilter" |
18 | sfFilterChain | Executing filter "tlMailChimpClickThroughIdentifier" |
19 | sfFilterChain | Executing filter "sfSuperCacheFilter" |
20 | sfFilterChain | Executing filter "sfCacheFilter" |
21 | sfFilterChain | Executing filter "sfExecutionFilter" |
22 | sessionActions | Call "sessionActions->executeOnSaleToday()" |
23 | Doctrine_Connection_Statement | execute : SELECT s.id AS s__id, s.event_id AS s__event_id, s.event_name AS s__event_name, s.venue_space_name AS s__venue_space_name, s.datetime AS s__datetime, s.display_datetime AS s__display_datetime, s.hide_time AS s__hide_time, s.hide_date AS s__hide_date, s.on_sale_from AS s__on_sale_from, s.display_on_sale_from AS s__display_on_sale_from, s.presale_code AS s__presale_code, s.on_sale_until AS s__on_sale_until, s.embargoed_until AS s__embargoed_until, s.hide_from AS s__hide_from, s.seating_map_name AS s__seating_map_name, s.tw_seating_map_id AS s__tw_seating_map_id, s.extra_distributor_ids AS s__extra_distributor_ids, s.max_tickets AS s__max_tickets, s.status_code AS s__status_code, s.currency_code AS s__currency_code, s.venue_space_id AS s__venue_space_id, s.seating_plan_id AS s__seating_plan_id, s.order_flow_id AS s__order_flow_id, s.is_general_admission AS s__is_general_admission, s.tw_modified AS s__tw_modified, s.is_guestlist AS s__is_guestlist, s.show_fanticks AS s__show_fanticks, s.encore_id AS s__encore_id, s.created_at AS s__created_at, s.updated_at AS s__updated_at, s.slug AS s__slug, s2.code AS s2__code, s2.name AS s2__name, s2.description AS s2__description, e.id AS e__id, e.name AS e__name, e.created_at AS e__created_at, e.updated_at AS e__updated_at, a.id AS a__id, a.slug AS a__slug, v.id AS v__id, v.venue_id AS v__venue_id, v.name AS v__name, v.default_seating_plan_id AS v__default_seating_plan_id, v.is_general_admission AS v__is_general_admission, v.encore_id AS v__encore_id, v.created_at AS v__created_at, v.updated_at AS v__updated_at, v2.id AS v2__id, v2.name AS v2__name, v2.slug AS v2__slug, v2.latitude AS v2__latitude, v2.longitude AS v2__longitude, v2.city AS v2__city, p.id AS p__id, p.unique_key AS p__unique_key, p.session_id AS p__session_id, p.zone_name AS p__zone_name, p.zone_display_name AS p__zone_display_name, p.price_name AS p__price_name, p.price_display_name AS p__price_display_name, p.rank_name AS p__rank_name, p.face_value AS p__face_value, p.booking_fee AS p__booking_fee, p.kickback AS p__kickback, p.complex_split AS p__complex_split, p.multiple_seats AS p__multiple_seats, p.min_tickets AS p__min_tickets, p.max_tickets AS p__max_tickets, p.availability AS p__availability, p.ticketware_price_id AS p__ticketware_price_id, p.zone_id AS p__zone_id, p.rank_id AS p__rank_id, p.fee_id AS p__fee_id, p.seating_type_id AS p__seating_type_id, p.internal_use AS p__internal_use, p.ticketplan_fee_id AS p__ticketplan_fee_id, p.ticketplan_fee AS p__ticketplan_fee, COALESCE(s.display_on_sale_from, s.on_sale_from) AS s__0, IFNULL(NULLIF(a.id, ''), a3.id) AS a__1, IFNULL(NULLIF(a.slug, ''), a3.slug) AS a__2, IFNULL(NULLIF(a.name, ''), a3.name) AS a__3, IFNULL(NULLIF(a5.name, ''), a6.name) AS a5__4, MIN(p.face_value + p.booking_fee) AS p__5, SUM(p.availability) AS p__6 FROM session s INNER JOIN session_status s2 ON s.status_code = s2.code INNER JOIN event e ON s.event_id = e.id LEFT JOIN artist_event a2 ON (e.id = a2.event_id) LEFT JOIN artist a ON a.id = a2.artist_id LEFT JOIN artist_session a4 ON (s.id = a4.session_id) LEFT JOIN artist a3 ON a3.id = a4.artist_id LEFT JOIN artist_type a5 ON a.type_id = a5.id LEFT JOIN artist_type a6 ON a3.type_id = a6.id INNER JOIN venue_space v ON s.venue_space_id = v.id INNER JOIN venue v2 ON v.venue_id = v2.id INNER JOIN price p ON s.id = p.session_id AND (p.internal_use = 0) WHERE (s.status_code != ? AND s.datetime >= ? AND s.embargoed_until <= ? AND (s.hide_from IS NULL OR s.hide_from > ?) AND ((s.display_on_sale_from IS NULL AND s.on_sale_from >= ?) OR s.display_on_sale_from >= ?) AND ((s.display_on_sale_from IS NULL AND s.on_sale_from <= ?) OR s.display_on_sale_from <= ?)) GROUP BY s.id ORDER BY s.event_name ASC, s.datetime ASC - (D, 2024-05-17 01:14:37, 2024-05-17 01:14:37, 2024-05-17 01:14:37, 2024-05-17 00:00:00, 2024-05-17 00:00:00, 2024-05-17 23:59:59, 2024-05-17 23:59:59) |
24 | Doctrine_Connection_Statement | execute : SELECT p.id AS p__id, p.unique_key AS p__unique_key, p.session_id AS p__session_id, p.zone_name AS p__zone_name, p.zone_display_name AS p__zone_display_name, p.price_name AS p__price_name, p.price_display_name AS p__price_display_name, p.rank_name AS p__rank_name, p.face_value AS p__face_value, p.booking_fee AS p__booking_fee, p.kickback AS p__kickback, p.complex_split AS p__complex_split, p.multiple_seats AS p__multiple_seats, p.min_tickets AS p__min_tickets, p.max_tickets AS p__max_tickets, p.availability AS p__availability, p.ticketware_price_id AS p__ticketware_price_id, p.zone_id AS p__zone_id, p.rank_id AS p__rank_id, p.fee_id AS p__fee_id, p.seating_type_id AS p__seating_type_id, p.internal_use AS p__internal_use, p.ticketplan_fee_id AS p__ticketplan_fee_id, p.ticketplan_fee AS p__ticketplan_fee FROM price p WHERE (p.session_id IN (?)) - (13372887) |
25 | Doctrine_Connection_Statement | execute : SELECT s.code AS s__code, s.name AS s__name, s.description AS s__description FROM session_status s WHERE (s.code = ?) LIMIT 1 - (S) |
26 | Doctrine_Connection_Statement | execute : SELECT s.code AS s__code, s.name AS s__name, s.description AS s__description FROM session_status s WHERE (s.code = ?) LIMIT 1 - (S) |
27 | Doctrine_Connection_Statement | execute : SELECT p.id AS p__id, p.unique_key AS p__unique_key, p.session_id AS p__session_id, p.zone_name AS p__zone_name, p.zone_display_name AS p__zone_display_name, p.price_name AS p__price_name, p.price_display_name AS p__price_display_name, p.rank_name AS p__rank_name, p.face_value AS p__face_value, p.booking_fee AS p__booking_fee, p.kickback AS p__kickback, p.complex_split AS p__complex_split, p.multiple_seats AS p__multiple_seats, p.min_tickets AS p__min_tickets, p.max_tickets AS p__max_tickets, p.availability AS p__availability, p.ticketware_price_id AS p__ticketware_price_id, p.zone_id AS p__zone_id, p.rank_id AS p__rank_id, p.fee_id AS p__fee_id, p.seating_type_id AS p__seating_type_id, p.internal_use AS p__internal_use, p.ticketplan_fee_id AS p__ticketplan_fee_id, p.ticketplan_fee AS p__ticketplan_fee FROM price p WHERE (p.session_id IN (?)) - (13372921) |
28 | Doctrine_Connection_Statement | execute : SELECT s.code AS s__code, s.name AS s__name, s.description AS s__description FROM session_status s WHERE (s.code = ?) LIMIT 1 - (S) |
29 | Doctrine_Connection_Statement | execute : SELECT s.code AS s__code, s.name AS s__name, s.description AS s__description FROM session_status s WHERE (s.code = ?) LIMIT 1 - (S) |
30 | Doctrine_Connection_Statement | execute : SELECT p.id AS p__id, p.unique_key AS p__unique_key, p.session_id AS p__session_id, p.zone_name AS p__zone_name, p.zone_display_name AS p__zone_display_name, p.price_name AS p__price_name, p.price_display_name AS p__price_display_name, p.rank_name AS p__rank_name, p.face_value AS p__face_value, p.booking_fee AS p__booking_fee, p.kickback AS p__kickback, p.complex_split AS p__complex_split, p.multiple_seats AS p__multiple_seats, p.min_tickets AS p__min_tickets, p.max_tickets AS p__max_tickets, p.availability AS p__availability, p.ticketware_price_id AS p__ticketware_price_id, p.zone_id AS p__zone_id, p.rank_id AS p__rank_id, p.fee_id AS p__fee_id, p.seating_type_id AS p__seating_type_id, p.internal_use AS p__internal_use, p.ticketplan_fee_id AS p__ticketplan_fee_id, p.ticketplan_fee AS p__ticketplan_fee FROM price p WHERE (p.session_id IN (?)) - (13372897) |
31 | Doctrine_Connection_Statement | execute : SELECT s.code AS s__code, s.name AS s__name, s.description AS s__description FROM session_status s WHERE (s.code = ?) LIMIT 1 - (S) |
32 | Doctrine_Connection_Statement | execute : SELECT s.code AS s__code, s.name AS s__name, s.description AS s__description FROM session_status s WHERE (s.code = ?) LIMIT 1 - (S) |
33 | Doctrine_Connection_Statement | execute : SELECT p.id AS p__id, p.unique_key AS p__unique_key, p.session_id AS p__session_id, p.zone_name AS p__zone_name, p.zone_display_name AS p__zone_display_name, p.price_name AS p__price_name, p.price_display_name AS p__price_display_name, p.rank_name AS p__rank_name, p.face_value AS p__face_value, p.booking_fee AS p__booking_fee, p.kickback AS p__kickback, p.complex_split AS p__complex_split, p.multiple_seats AS p__multiple_seats, p.min_tickets AS p__min_tickets, p.max_tickets AS p__max_tickets, p.availability AS p__availability, p.ticketware_price_id AS p__ticketware_price_id, p.zone_id AS p__zone_id, p.rank_id AS p__rank_id, p.fee_id AS p__fee_id, p.seating_type_id AS p__seating_type_id, p.internal_use AS p__internal_use, p.ticketplan_fee_id AS p__ticketplan_fee_id, p.ticketplan_fee AS p__ticketplan_fee FROM price p WHERE (p.session_id IN (?)) - (13372891) |
34 | Doctrine_Connection_Statement | execute : SELECT s.code AS s__code, s.name AS s__name, s.description AS s__description FROM session_status s WHERE (s.code = ?) LIMIT 1 - (S) |
35 | Doctrine_Connection_Statement | execute : SELECT s.code AS s__code, s.name AS s__name, s.description AS s__description FROM session_status s WHERE (s.code = ?) LIMIT 1 - (S) |
36 | Doctrine_Connection_Statement | execute : SELECT p.id AS p__id, p.unique_key AS p__unique_key, p.session_id AS p__session_id, p.zone_name AS p__zone_name, p.zone_display_name AS p__zone_display_name, p.price_name AS p__price_name, p.price_display_name AS p__price_display_name, p.rank_name AS p__rank_name, p.face_value AS p__face_value, p.booking_fee AS p__booking_fee, p.kickback AS p__kickback, p.complex_split AS p__complex_split, p.multiple_seats AS p__multiple_seats, p.min_tickets AS p__min_tickets, p.max_tickets AS p__max_tickets, p.availability AS p__availability, p.ticketware_price_id AS p__ticketware_price_id, p.zone_id AS p__zone_id, p.rank_id AS p__rank_id, p.fee_id AS p__fee_id, p.seating_type_id AS p__seating_type_id, p.internal_use AS p__internal_use, p.ticketplan_fee_id AS p__ticketplan_fee_id, p.ticketplan_fee AS p__ticketplan_fee FROM price p WHERE (p.session_id IN (?)) - (13372920) |
37 | Doctrine_Connection_Statement | execute : SELECT s.code AS s__code, s.name AS s__name, s.description AS s__description FROM session_status s WHERE (s.code = ?) LIMIT 1 - (S) |
38 | Doctrine_Connection_Statement | execute : SELECT s.code AS s__code, s.name AS s__name, s.description AS s__description FROM session_status s WHERE (s.code = ?) LIMIT 1 - (S) |
39 | Doctrine_Connection_Statement | execute : SELECT p.id AS p__id, p.unique_key AS p__unique_key, p.session_id AS p__session_id, p.zone_name AS p__zone_name, p.zone_display_name AS p__zone_display_name, p.price_name AS p__price_name, p.price_display_name AS p__price_display_name, p.rank_name AS p__rank_name, p.face_value AS p__face_value, p.booking_fee AS p__booking_fee, p.kickback AS p__kickback, p.complex_split AS p__complex_split, p.multiple_seats AS p__multiple_seats, p.min_tickets AS p__min_tickets, p.max_tickets AS p__max_tickets, p.availability AS p__availability, p.ticketware_price_id AS p__ticketware_price_id, p.zone_id AS p__zone_id, p.rank_id AS p__rank_id, p.fee_id AS p__fee_id, p.seating_type_id AS p__seating_type_id, p.internal_use AS p__internal_use, p.ticketplan_fee_id AS p__ticketplan_fee_id, p.ticketplan_fee AS p__ticketplan_fee FROM price p WHERE (p.session_id IN (?)) - (13372919) |
40 | Doctrine_Connection_Statement | execute : SELECT s.code AS s__code, s.name AS s__name, s.description AS s__description FROM session_status s WHERE (s.code = ?) LIMIT 1 - (S) |
41 | Doctrine_Connection_Statement | execute : SELECT s.code AS s__code, s.name AS s__name, s.description AS s__description FROM session_status s WHERE (s.code = ?) LIMIT 1 - (S) |
42 | Doctrine_Connection_Statement | execute : SELECT p.id AS p__id, p.unique_key AS p__unique_key, p.session_id AS p__session_id, p.zone_name AS p__zone_name, p.zone_display_name AS p__zone_display_name, p.price_name AS p__price_name, p.price_display_name AS p__price_display_name, p.rank_name AS p__rank_name, p.face_value AS p__face_value, p.booking_fee AS p__booking_fee, p.kickback AS p__kickback, p.complex_split AS p__complex_split, p.multiple_seats AS p__multiple_seats, p.min_tickets AS p__min_tickets, p.max_tickets AS p__max_tickets, p.availability AS p__availability, p.ticketware_price_id AS p__ticketware_price_id, p.zone_id AS p__zone_id, p.rank_id AS p__rank_id, p.fee_id AS p__fee_id, p.seating_type_id AS p__seating_type_id, p.internal_use AS p__internal_use, p.ticketplan_fee_id AS p__ticketplan_fee_id, p.ticketplan_fee AS p__ticketplan_fee FROM price p WHERE (p.session_id IN (?)) - (13372864) |
43 | Doctrine_Connection_Statement | execute : SELECT p.id AS p__id, p.unique_key AS p__unique_key, p.session_id AS p__session_id, p.zone_name AS p__zone_name, p.zone_display_name AS p__zone_display_name, p.price_name AS p__price_name, p.price_display_name AS p__price_display_name, p.rank_name AS p__rank_name, p.face_value AS p__face_value, p.booking_fee AS p__booking_fee, p.kickback AS p__kickback, p.complex_split AS p__complex_split, p.multiple_seats AS p__multiple_seats, p.min_tickets AS p__min_tickets, p.max_tickets AS p__max_tickets, p.availability AS p__availability, p.ticketware_price_id AS p__ticketware_price_id, p.zone_id AS p__zone_id, p.rank_id AS p__rank_id, p.fee_id AS p__fee_id, p.seating_type_id AS p__seating_type_id, p.internal_use AS p__internal_use, p.ticketplan_fee_id AS p__ticketplan_fee_id, p.ticketplan_fee AS p__ticketplan_fee FROM price p WHERE (p.session_id IN (?)) - (13372908) |
44 | Doctrine_Connection_Statement | execute : SELECT p.id AS p__id, p.unique_key AS p__unique_key, p.session_id AS p__session_id, p.zone_name AS p__zone_name, p.zone_display_name AS p__zone_display_name, p.price_name AS p__price_name, p.price_display_name AS p__price_display_name, p.rank_name AS p__rank_name, p.face_value AS p__face_value, p.booking_fee AS p__booking_fee, p.kickback AS p__kickback, p.complex_split AS p__complex_split, p.multiple_seats AS p__multiple_seats, p.min_tickets AS p__min_tickets, p.max_tickets AS p__max_tickets, p.availability AS p__availability, p.ticketware_price_id AS p__ticketware_price_id, p.zone_id AS p__zone_id, p.rank_id AS p__rank_id, p.fee_id AS p__fee_id, p.seating_type_id AS p__seating_type_id, p.internal_use AS p__internal_use, p.ticketplan_fee_id AS p__ticketplan_fee_id, p.ticketplan_fee AS p__ticketplan_fee FROM price p WHERE (p.session_id IN (?)) - (13372865) |
45 | sfViewCacheManager | Cache for "session/onSaleToday" does not exist |
46 | sfPHPView | Render "sf_app_dir/modules/session/templates/onSaleTodaySuccess.php" |
47 | sfPartialView | Render "sf_app_dir/modules/session/templates/_listByEvent.php" |
48 | sfPartialView | Render "sf_app_dir/modules/session/templates/_itemDate.php" |
49 | sfPartialView | Render "sf_app_dir/modules/session/templates/_itemMetaData.php" |
50 | Doctrine_Connection_Statement | execute : SELECT v.id AS v__id, v.name AS v__name, v.alt_names AS v__alt_names, v.address AS v__address, v.city AS v__city, v.postal_code AS v__postal_code, v.country_name AS v__country_name, v.country_id AS v__country_id, v.latitude AS v__latitude, v.longitude AS v__longitude, v.is_manual_location AS v__is_manual_location, v.homepage AS v__homepage, v.phone AS v__phone, v.fax AS v__fax, v.email AS v__email, v.capacity AS v__capacity, v.description AS v__description, v.directions AS v__directions, v.is_active AS v__is_active, v.postal_area_id AS v__postal_area_id, v.tw_modified AS v__tw_modified, v.encore_id AS v__encore_id, v.created_at AS v__created_at, v.updated_at AS v__updated_at, v.slug AS v__slug FROM venue v WHERE (v.id = ?) LIMIT 1 - (139009) |
51 | Doctrine_Connection_Statement | execute : SELECT c.id AS c__id, c.name AS c__name, c.code AS c__code, c.status AS c__status, c.created_at AS c__created_at, c.updated_at AS c__updated_at FROM country c WHERE (c.id = ?) - (66009) |
52 | Doctrine_Connection_Statement | execute : SELECT a.id AS a__id, a.name AS a__name, a.alt_names AS a__alt_names, a.twitter AS a__twitter, a.caption AS a__caption, a.html_page_title AS a__html_page_title, a.html_keywords AS a__html_keywords, a.html_description AS a__html_description, a.type_id AS a__type_id, a.mbid AS a__mbid, a.display_sessions_in_calendar AS a__display_sessions_in_calendar, a.hide_artist AS a__hide_artist, a.alert_sent_at AS a__alert_sent_at, a.short_url_id AS a__short_url_id, a.itunes_artist_id AS a__itunes_artist_id, a.page_url AS a__page_url, a.encore_id AS a__encore_id, a.created_at AS a__created_at, a.updated_at AS a__updated_at, a.slug AS a__slug, a.created_by AS a__created_by, a.updated_by AS a__updated_by, a2.artist_id AS a2__artist_id, a2.session_id AS a2__session_id, a2.created_at AS a2__created_at, a2.updated_at AS a2__updated_at FROM artist a LEFT JOIN artist_session a2 ON a.id = a2.artist_id WHERE (a2.session_id IN (?)) - (13372887) |
53 | Doctrine_Connection_Statement | execute : SELECT a.id AS a__id, a.name AS a__name, a.alt_names AS a__alt_names, a.twitter AS a__twitter, a.caption AS a__caption, a.html_page_title AS a__html_page_title, a.html_keywords AS a__html_keywords, a.html_description AS a__html_description, a.type_id AS a__type_id, a.mbid AS a__mbid, a.display_sessions_in_calendar AS a__display_sessions_in_calendar, a.hide_artist AS a__hide_artist, a.alert_sent_at AS a__alert_sent_at, a.short_url_id AS a__short_url_id, a.itunes_artist_id AS a__itunes_artist_id, a.page_url AS a__page_url, a.encore_id AS a__encore_id, a.created_at AS a__created_at, a.updated_at AS a__updated_at, a.slug AS a__slug, a.created_by AS a__created_by, a.updated_by AS a__updated_by FROM artist a WHERE (a.id = ?) LIMIT 1 - (55549) |
54 | Doctrine_Connection_Statement | execute : SELECT a.id AS a__id, a.name AS a__name, a.label AS a__label, a.description AS a__description, a.created_at AS a__created_at, a.updated_at AS a__updated_at FROM artist_type a WHERE (a.id = ?) - (1) |
55 | Doctrine_Connection_Mysql | query : SELECT q.id AS q__id, q.unique_key AS q__unique_key, q.session_id AS q__session_id, q.zone_name AS q__zone_name, q.zone_display_name AS q__zone_display_name, q.price_name AS q__price_name, q.price_display_name AS q__price_display_name, q.rank_name AS q__rank_name, q.face_value AS q__face_value, q.booking_fee AS q__booking_fee, q.kickback AS q__kickback, q.complex_split AS q__complex_split, q.multiple_seats AS q__multiple_seats, q.min_tickets AS q__min_tickets, q.max_tickets AS q__max_tickets, q.availability AS q__availability, q.ticketware_price_id AS q__ticketware_price_id, q.zone_id AS q__zone_id, q.rank_id AS q__rank_id, q.fee_id AS q__fee_id, q.seating_type_id AS q__seating_type_id, q.internal_use AS q__internal_use, q.ticketplan_fee_id AS q__ticketplan_fee_id, q.ticketplan_fee AS q__ticketplan_fee FROM
(
SELECT p.*
FROM price p
LEFT JOIN price_priority pr ON pr.price_unique_key = p.unique_key
WHERE p.availability > 0 AND p.session_id = 13372887 AND p.internal_use = 0 AND p.fee_id != 121073
GROUP BY p.id, p.rank_id
ORDER BY ISNULL(pr. position), pr.position ASC, p.face_value DESC, p.zone_name ASC
) as q
- () |
56 | Doctrine_Connection_Statement | execute : SELECT s.code AS s__code, s.name AS s__name, s.description AS s__description FROM session_status s WHERE (s.code = ?) LIMIT 1 - (S) |
57 | sfPartialView | Render "sf_app_dir/modules/session/templates/_itemButton.php" |
58 | Doctrine_Connection_Statement | execute : SELECT s.code AS s__code, s.name AS s__name, s.description AS s__description FROM session_status s WHERE (s.code = ?) LIMIT 1 - (S) |
59 | Doctrine_Connection_Statement | execute : SELECT s.code AS s__code, s.name AS s__name, s.description AS s__description FROM session_status s WHERE (s.code = ?) LIMIT 1 - (S) |
60 | Doctrine_Connection_Statement | execute : SELECT s.code AS s__code, s.name AS s__name, s.description AS s__description FROM session_status s WHERE (s.code = ?) LIMIT 1 - (S) |
61 | Doctrine_Connection_Statement | execute : SELECT s.code AS s__code, s.name AS s__name, s.description AS s__description FROM session_status s WHERE (s.code = ?) LIMIT 1 - (S) |
62 | sfPartialView | Render "sf_app_dir/modules/session/templates/_widgetFanticks.php" |
63 | Doctrine_Connection_Statement | execute : SELECT s.code AS s__code, s.name AS s__name, s.description AS s__description FROM session_status s WHERE (s.code = ?) LIMIT 1 - (S) |
64 | sfPartialView | Render "sf_app_dir/modules/session/templates/_itemDate.php" |
65 | sfPartialView | Render "sf_app_dir/modules/session/templates/_itemMetaData.php" |
66 | Doctrine_Connection_Statement | execute : SELECT v.id AS v__id, v.name AS v__name, v.alt_names AS v__alt_names, v.address AS v__address, v.city AS v__city, v.postal_code AS v__postal_code, v.country_name AS v__country_name, v.country_id AS v__country_id, v.latitude AS v__latitude, v.longitude AS v__longitude, v.is_manual_location AS v__is_manual_location, v.homepage AS v__homepage, v.phone AS v__phone, v.fax AS v__fax, v.email AS v__email, v.capacity AS v__capacity, v.description AS v__description, v.directions AS v__directions, v.is_active AS v__is_active, v.postal_area_id AS v__postal_area_id, v.tw_modified AS v__tw_modified, v.encore_id AS v__encore_id, v.created_at AS v__created_at, v.updated_at AS v__updated_at, v.slug AS v__slug FROM venue v WHERE (v.id = ?) LIMIT 1 - (140009) |
67 | Doctrine_Connection_Statement | execute : SELECT c.id AS c__id, c.name AS c__name, c.code AS c__code, c.status AS c__status, c.created_at AS c__created_at, c.updated_at AS c__updated_at FROM country c WHERE (c.id = ?) - (66009) |
68 | Doctrine_Connection_Statement | execute : SELECT a.id AS a__id, a.name AS a__name, a.alt_names AS a__alt_names, a.twitter AS a__twitter, a.caption AS a__caption, a.html_page_title AS a__html_page_title, a.html_keywords AS a__html_keywords, a.html_description AS a__html_description, a.type_id AS a__type_id, a.mbid AS a__mbid, a.display_sessions_in_calendar AS a__display_sessions_in_calendar, a.hide_artist AS a__hide_artist, a.alert_sent_at AS a__alert_sent_at, a.short_url_id AS a__short_url_id, a.itunes_artist_id AS a__itunes_artist_id, a.page_url AS a__page_url, a.encore_id AS a__encore_id, a.created_at AS a__created_at, a.updated_at AS a__updated_at, a.slug AS a__slug, a.created_by AS a__created_by, a.updated_by AS a__updated_by, a2.artist_id AS a2__artist_id, a2.session_id AS a2__session_id, a2.created_at AS a2__created_at, a2.updated_at AS a2__updated_at FROM artist a LEFT JOIN artist_session a2 ON a.id = a2.artist_id WHERE (a2.session_id IN (?)) - (13372921) |
69 | Doctrine_Connection_Statement | execute : SELECT a.id AS a__id, a.name AS a__name, a.alt_names AS a__alt_names, a.twitter AS a__twitter, a.caption AS a__caption, a.html_page_title AS a__html_page_title, a.html_keywords AS a__html_keywords, a.html_description AS a__html_description, a.type_id AS a__type_id, a.mbid AS a__mbid, a.display_sessions_in_calendar AS a__display_sessions_in_calendar, a.hide_artist AS a__hide_artist, a.alert_sent_at AS a__alert_sent_at, a.short_url_id AS a__short_url_id, a.itunes_artist_id AS a__itunes_artist_id, a.page_url AS a__page_url, a.encore_id AS a__encore_id, a.created_at AS a__created_at, a.updated_at AS a__updated_at, a.slug AS a__slug, a.created_by AS a__created_by, a.updated_by AS a__updated_by FROM artist a WHERE (a.id = ?) LIMIT 1 - (50521) |
70 | Doctrine_Connection_Statement | execute : SELECT a.id AS a__id, a.name AS a__name, a.label AS a__label, a.description AS a__description, a.created_at AS a__created_at, a.updated_at AS a__updated_at FROM artist_type a WHERE (a.id = ?) - (1) |
71 | Doctrine_Connection_Mysql | query : SELECT q.id AS q__id, q.unique_key AS q__unique_key, q.session_id AS q__session_id, q.zone_name AS q__zone_name, q.zone_display_name AS q__zone_display_name, q.price_name AS q__price_name, q.price_display_name AS q__price_display_name, q.rank_name AS q__rank_name, q.face_value AS q__face_value, q.booking_fee AS q__booking_fee, q.kickback AS q__kickback, q.complex_split AS q__complex_split, q.multiple_seats AS q__multiple_seats, q.min_tickets AS q__min_tickets, q.max_tickets AS q__max_tickets, q.availability AS q__availability, q.ticketware_price_id AS q__ticketware_price_id, q.zone_id AS q__zone_id, q.rank_id AS q__rank_id, q.fee_id AS q__fee_id, q.seating_type_id AS q__seating_type_id, q.internal_use AS q__internal_use, q.ticketplan_fee_id AS q__ticketplan_fee_id, q.ticketplan_fee AS q__ticketplan_fee FROM
(
SELECT p.*
FROM price p
LEFT JOIN price_priority pr ON pr.price_unique_key = p.unique_key
WHERE p.availability > 0 AND p.session_id = 13372921 AND p.internal_use = 0 AND p.fee_id != 121073
GROUP BY p.id, p.rank_id
ORDER BY ISNULL(pr. position), pr.position ASC, p.face_value DESC, p.zone_name ASC
) as q
- () |
72 | Doctrine_Connection_Statement | execute : SELECT s.code AS s__code, s.name AS s__name, s.description AS s__description FROM session_status s WHERE (s.code = ?) LIMIT 1 - (S) |
73 | sfPartialView | Render "sf_app_dir/modules/session/templates/_itemButton.php" |
74 | Doctrine_Connection_Statement | execute : SELECT s.code AS s__code, s.name AS s__name, s.description AS s__description FROM session_status s WHERE (s.code = ?) LIMIT 1 - (S) |
75 | Doctrine_Connection_Statement | execute : SELECT s.code AS s__code, s.name AS s__name, s.description AS s__description FROM session_status s WHERE (s.code = ?) LIMIT 1 - (S) |
76 | Doctrine_Connection_Statement | execute : SELECT s.code AS s__code, s.name AS s__name, s.description AS s__description FROM session_status s WHERE (s.code = ?) LIMIT 1 - (S) |
77 | Doctrine_Connection_Statement | execute : SELECT s.code AS s__code, s.name AS s__name, s.description AS s__description FROM session_status s WHERE (s.code = ?) LIMIT 1 - (S) |
78 | sfPartialView | Render "sf_app_dir/modules/session/templates/_widgetFanticks.php" |
79 | Doctrine_Connection_Statement | execute : SELECT s.code AS s__code, s.name AS s__name, s.description AS s__description FROM session_status s WHERE (s.code = ?) LIMIT 1 - (S) |
80 | sfPartialView | Render "sf_app_dir/modules/session/templates/_itemDate.php" |
81 | sfPartialView | Render "sf_app_dir/modules/session/templates/_itemMetaData.php" |
82 | Doctrine_Connection_Statement | execute : SELECT v.id AS v__id, v.name AS v__name, v.alt_names AS v__alt_names, v.address AS v__address, v.city AS v__city, v.postal_code AS v__postal_code, v.country_name AS v__country_name, v.country_id AS v__country_id, v.latitude AS v__latitude, v.longitude AS v__longitude, v.is_manual_location AS v__is_manual_location, v.homepage AS v__homepage, v.phone AS v__phone, v.fax AS v__fax, v.email AS v__email, v.capacity AS v__capacity, v.description AS v__description, v.directions AS v__directions, v.is_active AS v__is_active, v.postal_area_id AS v__postal_area_id, v.tw_modified AS v__tw_modified, v.encore_id AS v__encore_id, v.created_at AS v__created_at, v.updated_at AS v__updated_at, v.slug AS v__slug FROM venue v WHERE (v.id = ?) LIMIT 1 - (673632) |
83 | Doctrine_Connection_Statement | execute : SELECT c.id AS c__id, c.name AS c__name, c.code AS c__code, c.status AS c__status, c.created_at AS c__created_at, c.updated_at AS c__updated_at FROM country c WHERE (c.id = ?) - (66009) |
84 | Doctrine_Connection_Statement | execute : SELECT a.id AS a__id, a.name AS a__name, a.alt_names AS a__alt_names, a.twitter AS a__twitter, a.caption AS a__caption, a.html_page_title AS a__html_page_title, a.html_keywords AS a__html_keywords, a.html_description AS a__html_description, a.type_id AS a__type_id, a.mbid AS a__mbid, a.display_sessions_in_calendar AS a__display_sessions_in_calendar, a.hide_artist AS a__hide_artist, a.alert_sent_at AS a__alert_sent_at, a.short_url_id AS a__short_url_id, a.itunes_artist_id AS a__itunes_artist_id, a.page_url AS a__page_url, a.encore_id AS a__encore_id, a.created_at AS a__created_at, a.updated_at AS a__updated_at, a.slug AS a__slug, a.created_by AS a__created_by, a.updated_by AS a__updated_by, a2.artist_id AS a2__artist_id, a2.session_id AS a2__session_id, a2.created_at AS a2__created_at, a2.updated_at AS a2__updated_at FROM artist a LEFT JOIN artist_session a2 ON a.id = a2.artist_id WHERE (a2.session_id IN (?)) - (13372897) |
85 | Doctrine_Connection_Statement | execute : SELECT a.id AS a__id, a.name AS a__name, a.alt_names AS a__alt_names, a.twitter AS a__twitter, a.caption AS a__caption, a.html_page_title AS a__html_page_title, a.html_keywords AS a__html_keywords, a.html_description AS a__html_description, a.type_id AS a__type_id, a.mbid AS a__mbid, a.display_sessions_in_calendar AS a__display_sessions_in_calendar, a.hide_artist AS a__hide_artist, a.alert_sent_at AS a__alert_sent_at, a.short_url_id AS a__short_url_id, a.itunes_artist_id AS a__itunes_artist_id, a.page_url AS a__page_url, a.encore_id AS a__encore_id, a.created_at AS a__created_at, a.updated_at AS a__updated_at, a.slug AS a__slug, a.created_by AS a__created_by, a.updated_by AS a__updated_by FROM artist a WHERE (a.id = ?) LIMIT 1 - (44761) |
86 | Doctrine_Connection_Statement | execute : SELECT a.id AS a__id, a.name AS a__name, a.label AS a__label, a.description AS a__description, a.created_at AS a__created_at, a.updated_at AS a__updated_at FROM artist_type a WHERE (a.id = ?) - (1) |
87 | Doctrine_Connection_Mysql | query : SELECT q.id AS q__id, q.unique_key AS q__unique_key, q.session_id AS q__session_id, q.zone_name AS q__zone_name, q.zone_display_name AS q__zone_display_name, q.price_name AS q__price_name, q.price_display_name AS q__price_display_name, q.rank_name AS q__rank_name, q.face_value AS q__face_value, q.booking_fee AS q__booking_fee, q.kickback AS q__kickback, q.complex_split AS q__complex_split, q.multiple_seats AS q__multiple_seats, q.min_tickets AS q__min_tickets, q.max_tickets AS q__max_tickets, q.availability AS q__availability, q.ticketware_price_id AS q__ticketware_price_id, q.zone_id AS q__zone_id, q.rank_id AS q__rank_id, q.fee_id AS q__fee_id, q.seating_type_id AS q__seating_type_id, q.internal_use AS q__internal_use, q.ticketplan_fee_id AS q__ticketplan_fee_id, q.ticketplan_fee AS q__ticketplan_fee FROM
(
SELECT p.*
FROM price p
LEFT JOIN price_priority pr ON pr.price_unique_key = p.unique_key
WHERE p.availability > 0 AND p.session_id = 13372897 AND p.internal_use = 0 AND p.fee_id != 121073
GROUP BY p.id, p.rank_id
ORDER BY ISNULL(pr. position), pr.position ASC, p.face_value DESC, p.zone_name ASC
) as q
- () |
88 | Doctrine_Connection_Statement | execute : SELECT s.code AS s__code, s.name AS s__name, s.description AS s__description FROM session_status s WHERE (s.code = ?) LIMIT 1 - (S) |
89 | sfPartialView | Render "sf_app_dir/modules/session/templates/_itemButton.php" |
90 | Doctrine_Connection_Statement | execute : SELECT s.code AS s__code, s.name AS s__name, s.description AS s__description FROM session_status s WHERE (s.code = ?) LIMIT 1 - (S) |
91 | Doctrine_Connection_Statement | execute : SELECT s.code AS s__code, s.name AS s__name, s.description AS s__description FROM session_status s WHERE (s.code = ?) LIMIT 1 - (S) |
92 | Doctrine_Connection_Statement | execute : SELECT s.code AS s__code, s.name AS s__name, s.description AS s__description FROM session_status s WHERE (s.code = ?) LIMIT 1 - (S) |
93 | Doctrine_Connection_Statement | execute : SELECT s.code AS s__code, s.name AS s__name, s.description AS s__description FROM session_status s WHERE (s.code = ?) LIMIT 1 - (S) |
94 | sfPartialView | Render "sf_app_dir/modules/session/templates/_widgetFanticks.php" |
95 | Doctrine_Connection_Statement | execute : SELECT s.code AS s__code, s.name AS s__name, s.description AS s__description FROM session_status s WHERE (s.code = ?) LIMIT 1 - (S) |
96 | sfPartialView | Render "sf_app_dir/modules/session/templates/_itemDate.php" |
97 | sfPartialView | Render "sf_app_dir/modules/session/templates/_itemMetaData.php" |
98 | Doctrine_Connection_Statement | execute : SELECT v.id AS v__id, v.name AS v__name, v.alt_names AS v__alt_names, v.address AS v__address, v.city AS v__city, v.postal_code AS v__postal_code, v.country_name AS v__country_name, v.country_id AS v__country_id, v.latitude AS v__latitude, v.longitude AS v__longitude, v.is_manual_location AS v__is_manual_location, v.homepage AS v__homepage, v.phone AS v__phone, v.fax AS v__fax, v.email AS v__email, v.capacity AS v__capacity, v.description AS v__description, v.directions AS v__directions, v.is_active AS v__is_active, v.postal_area_id AS v__postal_area_id, v.tw_modified AS v__tw_modified, v.encore_id AS v__encore_id, v.created_at AS v__created_at, v.updated_at AS v__updated_at, v.slug AS v__slug FROM venue v WHERE (v.id = ?) LIMIT 1 - (678398) |
99 | Doctrine_Connection_Statement | execute : SELECT a.id AS a__id, a.name AS a__name, a.alt_names AS a__alt_names, a.twitter AS a__twitter, a.caption AS a__caption, a.html_page_title AS a__html_page_title, a.html_keywords AS a__html_keywords, a.html_description AS a__html_description, a.type_id AS a__type_id, a.mbid AS a__mbid, a.display_sessions_in_calendar AS a__display_sessions_in_calendar, a.hide_artist AS a__hide_artist, a.alert_sent_at AS a__alert_sent_at, a.short_url_id AS a__short_url_id, a.itunes_artist_id AS a__itunes_artist_id, a.page_url AS a__page_url, a.encore_id AS a__encore_id, a.created_at AS a__created_at, a.updated_at AS a__updated_at, a.slug AS a__slug, a.created_by AS a__created_by, a.updated_by AS a__updated_by, a2.artist_id AS a2__artist_id, a2.session_id AS a2__session_id, a2.created_at AS a2__created_at, a2.updated_at AS a2__updated_at FROM artist a LEFT JOIN artist_session a2 ON a.id = a2.artist_id WHERE (a2.session_id IN (?)) - (13372891) |
100 | Doctrine_Connection_Statement | execute : SELECT a.id AS a__id, a.name AS a__name, a.alt_names AS a__alt_names, a.twitter AS a__twitter, a.caption AS a__caption, a.html_page_title AS a__html_page_title, a.html_keywords AS a__html_keywords, a.html_description AS a__html_description, a.type_id AS a__type_id, a.mbid AS a__mbid, a.display_sessions_in_calendar AS a__display_sessions_in_calendar, a.hide_artist AS a__hide_artist, a.alert_sent_at AS a__alert_sent_at, a.short_url_id AS a__short_url_id, a.itunes_artist_id AS a__itunes_artist_id, a.page_url AS a__page_url, a.encore_id AS a__encore_id, a.created_at AS a__created_at, a.updated_at AS a__updated_at, a.slug AS a__slug, a.created_by AS a__created_by, a.updated_by AS a__updated_by FROM artist a WHERE (a.id = ?) LIMIT 1 - (55553) |
101 | Doctrine_Connection_Statement | execute : SELECT a.id AS a__id, a.name AS a__name, a.label AS a__label, a.description AS a__description, a.created_at AS a__created_at, a.updated_at AS a__updated_at FROM artist_type a WHERE (a.id = ?) - (1) |
102 | Doctrine_Connection_Mysql | query : SELECT q.id AS q__id, q.unique_key AS q__unique_key, q.session_id AS q__session_id, q.zone_name AS q__zone_name, q.zone_display_name AS q__zone_display_name, q.price_name AS q__price_name, q.price_display_name AS q__price_display_name, q.rank_name AS q__rank_name, q.face_value AS q__face_value, q.booking_fee AS q__booking_fee, q.kickback AS q__kickback, q.complex_split AS q__complex_split, q.multiple_seats AS q__multiple_seats, q.min_tickets AS q__min_tickets, q.max_tickets AS q__max_tickets, q.availability AS q__availability, q.ticketware_price_id AS q__ticketware_price_id, q.zone_id AS q__zone_id, q.rank_id AS q__rank_id, q.fee_id AS q__fee_id, q.seating_type_id AS q__seating_type_id, q.internal_use AS q__internal_use, q.ticketplan_fee_id AS q__ticketplan_fee_id, q.ticketplan_fee AS q__ticketplan_fee FROM
(
SELECT p.*
FROM price p
LEFT JOIN price_priority pr ON pr.price_unique_key = p.unique_key
WHERE p.availability > 0 AND p.session_id = 13372891 AND p.internal_use = 0 AND p.fee_id != 121073
GROUP BY p.id, p.rank_id
ORDER BY ISNULL(pr. position), pr.position ASC, p.face_value DESC, p.zone_name ASC
) as q
- () |
103 | Doctrine_Connection_Statement | execute : SELECT s.code AS s__code, s.name AS s__name, s.description AS s__description FROM session_status s WHERE (s.code = ?) LIMIT 1 - (S) |
104 | sfPartialView | Render "sf_app_dir/modules/session/templates/_itemButton.php" |
105 | Doctrine_Connection_Statement | execute : SELECT s.code AS s__code, s.name AS s__name, s.description AS s__description FROM session_status s WHERE (s.code = ?) LIMIT 1 - (S) |
106 | Doctrine_Connection_Statement | execute : SELECT s.code AS s__code, s.name AS s__name, s.description AS s__description FROM session_status s WHERE (s.code = ?) LIMIT 1 - (S) |
107 | Doctrine_Connection_Statement | execute : SELECT s.code AS s__code, s.name AS s__name, s.description AS s__description FROM session_status s WHERE (s.code = ?) LIMIT 1 - (S) |
108 | Doctrine_Connection_Statement | execute : SELECT s.code AS s__code, s.name AS s__name, s.description AS s__description FROM session_status s WHERE (s.code = ?) LIMIT 1 - (S) |
109 | sfPartialView | Render "sf_app_dir/modules/session/templates/_widgetFanticks.php" |
110 | Doctrine_Connection_Statement | execute : SELECT s.code AS s__code, s.name AS s__name, s.description AS s__description FROM session_status s WHERE (s.code = ?) LIMIT 1 - (S) |
111 | sfPartialView | Render "sf_app_dir/modules/session/templates/_itemDate.php" |
112 | sfPartialView | Render "sf_app_dir/modules/session/templates/_itemMetaData.php" |
113 | Doctrine_Connection_Statement | execute : SELECT v.id AS v__id, v.name AS v__name, v.alt_names AS v__alt_names, v.address AS v__address, v.city AS v__city, v.postal_code AS v__postal_code, v.country_name AS v__country_name, v.country_id AS v__country_id, v.latitude AS v__latitude, v.longitude AS v__longitude, v.is_manual_location AS v__is_manual_location, v.homepage AS v__homepage, v.phone AS v__phone, v.fax AS v__fax, v.email AS v__email, v.capacity AS v__capacity, v.description AS v__description, v.directions AS v__directions, v.is_active AS v__is_active, v.postal_area_id AS v__postal_area_id, v.tw_modified AS v__tw_modified, v.encore_id AS v__encore_id, v.created_at AS v__created_at, v.updated_at AS v__updated_at, v.slug AS v__slug FROM venue v WHERE (v.id = ?) LIMIT 1 - (577009) |
114 | Doctrine_Connection_Statement | execute : SELECT c.id AS c__id, c.name AS c__name, c.code AS c__code, c.status AS c__status, c.created_at AS c__created_at, c.updated_at AS c__updated_at FROM country c WHERE (c.id = ?) - (66009) |
115 | Doctrine_Connection_Statement | execute : SELECT a.id AS a__id, a.name AS a__name, a.alt_names AS a__alt_names, a.twitter AS a__twitter, a.caption AS a__caption, a.html_page_title AS a__html_page_title, a.html_keywords AS a__html_keywords, a.html_description AS a__html_description, a.type_id AS a__type_id, a.mbid AS a__mbid, a.display_sessions_in_calendar AS a__display_sessions_in_calendar, a.hide_artist AS a__hide_artist, a.alert_sent_at AS a__alert_sent_at, a.short_url_id AS a__short_url_id, a.itunes_artist_id AS a__itunes_artist_id, a.page_url AS a__page_url, a.encore_id AS a__encore_id, a.created_at AS a__created_at, a.updated_at AS a__updated_at, a.slug AS a__slug, a.created_by AS a__created_by, a.updated_by AS a__updated_by, a2.artist_id AS a2__artist_id, a2.session_id AS a2__session_id, a2.created_at AS a2__created_at, a2.updated_at AS a2__updated_at FROM artist a LEFT JOIN artist_session a2 ON a.id = a2.artist_id WHERE (a2.session_id IN (?)) - (13372920) |
116 | Doctrine_Connection_Statement | execute : SELECT a.id AS a__id, a.name AS a__name, a.alt_names AS a__alt_names, a.twitter AS a__twitter, a.caption AS a__caption, a.html_page_title AS a__html_page_title, a.html_keywords AS a__html_keywords, a.html_description AS a__html_description, a.type_id AS a__type_id, a.mbid AS a__mbid, a.display_sessions_in_calendar AS a__display_sessions_in_calendar, a.hide_artist AS a__hide_artist, a.alert_sent_at AS a__alert_sent_at, a.short_url_id AS a__short_url_id, a.itunes_artist_id AS a__itunes_artist_id, a.page_url AS a__page_url, a.encore_id AS a__encore_id, a.created_at AS a__created_at, a.updated_at AS a__updated_at, a.slug AS a__slug, a.created_by AS a__created_by, a.updated_by AS a__updated_by FROM artist a WHERE (a.id = ?) LIMIT 1 - (22133) |
117 | Doctrine_Connection_Statement | execute : SELECT a.id AS a__id, a.name AS a__name, a.label AS a__label, a.description AS a__description, a.created_at AS a__created_at, a.updated_at AS a__updated_at FROM artist_type a WHERE (a.id = ?) - (1) |
118 | Doctrine_Connection_Mysql | query : SELECT q.id AS q__id, q.unique_key AS q__unique_key, q.session_id AS q__session_id, q.zone_name AS q__zone_name, q.zone_display_name AS q__zone_display_name, q.price_name AS q__price_name, q.price_display_name AS q__price_display_name, q.rank_name AS q__rank_name, q.face_value AS q__face_value, q.booking_fee AS q__booking_fee, q.kickback AS q__kickback, q.complex_split AS q__complex_split, q.multiple_seats AS q__multiple_seats, q.min_tickets AS q__min_tickets, q.max_tickets AS q__max_tickets, q.availability AS q__availability, q.ticketware_price_id AS q__ticketware_price_id, q.zone_id AS q__zone_id, q.rank_id AS q__rank_id, q.fee_id AS q__fee_id, q.seating_type_id AS q__seating_type_id, q.internal_use AS q__internal_use, q.ticketplan_fee_id AS q__ticketplan_fee_id, q.ticketplan_fee AS q__ticketplan_fee FROM
(
SELECT p.*
FROM price p
LEFT JOIN price_priority pr ON pr.price_unique_key = p.unique_key
WHERE p.availability > 0 AND p.session_id = 13372920 AND p.internal_use = 0 AND p.fee_id != 121073
GROUP BY p.id, p.rank_id
ORDER BY ISNULL(pr. position), pr.position ASC, p.face_value DESC, p.zone_name ASC
) as q
- () |
119 | Doctrine_Connection_Statement | execute : SELECT s.code AS s__code, s.name AS s__name, s.description AS s__description FROM session_status s WHERE (s.code = ?) LIMIT 1 - (S) |
120 | sfPartialView | Render "sf_app_dir/modules/session/templates/_itemButton.php" |
121 | Doctrine_Connection_Statement | execute : SELECT s.code AS s__code, s.name AS s__name, s.description AS s__description FROM session_status s WHERE (s.code = ?) LIMIT 1 - (S) |
122 | Doctrine_Connection_Statement | execute : SELECT s.code AS s__code, s.name AS s__name, s.description AS s__description FROM session_status s WHERE (s.code = ?) LIMIT 1 - (S) |
123 | Doctrine_Connection_Statement | execute : SELECT s.code AS s__code, s.name AS s__name, s.description AS s__description FROM session_status s WHERE (s.code = ?) LIMIT 1 - (S) |
124 | Doctrine_Connection_Statement | execute : SELECT s.code AS s__code, s.name AS s__name, s.description AS s__description FROM session_status s WHERE (s.code = ?) LIMIT 1 - (S) |
125 | sfPartialView | Render "sf_app_dir/modules/session/templates/_widgetFanticks.php" |
126 | Doctrine_Connection_Statement | execute : SELECT s.code AS s__code, s.name AS s__name, s.description AS s__description FROM session_status s WHERE (s.code = ?) LIMIT 1 - (S) |
127 | sfPartialView | Render "sf_app_dir/modules/session/templates/_itemDate.php" |
128 | sfPartialView | Render "sf_app_dir/modules/session/templates/_itemMetaData.php" |
129 | Doctrine_Connection_Statement | execute : SELECT a.id AS a__id, a.name AS a__name, a.alt_names AS a__alt_names, a.twitter AS a__twitter, a.caption AS a__caption, a.html_page_title AS a__html_page_title, a.html_keywords AS a__html_keywords, a.html_description AS a__html_description, a.type_id AS a__type_id, a.mbid AS a__mbid, a.display_sessions_in_calendar AS a__display_sessions_in_calendar, a.hide_artist AS a__hide_artist, a.alert_sent_at AS a__alert_sent_at, a.short_url_id AS a__short_url_id, a.itunes_artist_id AS a__itunes_artist_id, a.page_url AS a__page_url, a.encore_id AS a__encore_id, a.created_at AS a__created_at, a.updated_at AS a__updated_at, a.slug AS a__slug, a.created_by AS a__created_by, a.updated_by AS a__updated_by, a2.artist_id AS a2__artist_id, a2.session_id AS a2__session_id, a2.created_at AS a2__created_at, a2.updated_at AS a2__updated_at FROM artist a LEFT JOIN artist_session a2 ON a.id = a2.artist_id WHERE (a2.session_id IN (?)) - (13372919) |
130 | Doctrine_Connection_Statement | execute : SELECT a.id AS a__id, a.name AS a__name, a.alt_names AS a__alt_names, a.twitter AS a__twitter, a.caption AS a__caption, a.html_page_title AS a__html_page_title, a.html_keywords AS a__html_keywords, a.html_description AS a__html_description, a.type_id AS a__type_id, a.mbid AS a__mbid, a.display_sessions_in_calendar AS a__display_sessions_in_calendar, a.hide_artist AS a__hide_artist, a.alert_sent_at AS a__alert_sent_at, a.short_url_id AS a__short_url_id, a.itunes_artist_id AS a__itunes_artist_id, a.page_url AS a__page_url, a.encore_id AS a__encore_id, a.created_at AS a__created_at, a.updated_at AS a__updated_at, a.slug AS a__slug, a.created_by AS a__created_by, a.updated_by AS a__updated_by FROM artist a WHERE (a.id = ?) LIMIT 1 - (25705) |
131 | Doctrine_Connection_Statement | execute : SELECT a.id AS a__id, a.name AS a__name, a.label AS a__label, a.description AS a__description, a.created_at AS a__created_at, a.updated_at AS a__updated_at FROM artist_type a WHERE (a.id = ?) - (1) |
132 | Doctrine_Connection_Mysql | query : SELECT q.id AS q__id, q.unique_key AS q__unique_key, q.session_id AS q__session_id, q.zone_name AS q__zone_name, q.zone_display_name AS q__zone_display_name, q.price_name AS q__price_name, q.price_display_name AS q__price_display_name, q.rank_name AS q__rank_name, q.face_value AS q__face_value, q.booking_fee AS q__booking_fee, q.kickback AS q__kickback, q.complex_split AS q__complex_split, q.multiple_seats AS q__multiple_seats, q.min_tickets AS q__min_tickets, q.max_tickets AS q__max_tickets, q.availability AS q__availability, q.ticketware_price_id AS q__ticketware_price_id, q.zone_id AS q__zone_id, q.rank_id AS q__rank_id, q.fee_id AS q__fee_id, q.seating_type_id AS q__seating_type_id, q.internal_use AS q__internal_use, q.ticketplan_fee_id AS q__ticketplan_fee_id, q.ticketplan_fee AS q__ticketplan_fee FROM
(
SELECT p.*
FROM price p
LEFT JOIN price_priority pr ON pr.price_unique_key = p.unique_key
WHERE p.availability > 0 AND p.session_id = 13372919 AND p.internal_use = 0 AND p.fee_id != 121073
GROUP BY p.id, p.rank_id
ORDER BY ISNULL(pr. position), pr.position ASC, p.face_value DESC, p.zone_name ASC
) as q
- () |
133 | Doctrine_Connection_Statement | execute : SELECT s.code AS s__code, s.name AS s__name, s.description AS s__description FROM session_status s WHERE (s.code = ?) LIMIT 1 - (S) |
134 | sfPartialView | Render "sf_app_dir/modules/session/templates/_itemButton.php" |
135 | Doctrine_Connection_Statement | execute : SELECT s.code AS s__code, s.name AS s__name, s.description AS s__description FROM session_status s WHERE (s.code = ?) LIMIT 1 - (S) |
136 | Doctrine_Connection_Statement | execute : SELECT s.code AS s__code, s.name AS s__name, s.description AS s__description FROM session_status s WHERE (s.code = ?) LIMIT 1 - (S) |
137 | Doctrine_Connection_Statement | execute : SELECT s.code AS s__code, s.name AS s__name, s.description AS s__description FROM session_status s WHERE (s.code = ?) LIMIT 1 - (S) |
138 | Doctrine_Connection_Statement | execute : SELECT s.code AS s__code, s.name AS s__name, s.description AS s__description FROM session_status s WHERE (s.code = ?) LIMIT 1 - (S) |
139 | sfPartialView | Render "sf_app_dir/modules/session/templates/_widgetFanticks.php" |
140 | Doctrine_Connection_Statement | execute : SELECT s.code AS s__code, s.name AS s__name, s.description AS s__description FROM session_status s WHERE (s.code = ?) LIMIT 1 - (S) |
141 | sfPartialView | Render "sf_app_dir/modules/session/templates/_itemDate.php" |
142 | sfPartialView | Render "sf_app_dir/modules/session/templates/_itemMetaData.php" |
143 | Doctrine_Connection_Statement | execute : SELECT v.id AS v__id, v.name AS v__name, v.alt_names AS v__alt_names, v.address AS v__address, v.city AS v__city, v.postal_code AS v__postal_code, v.country_name AS v__country_name, v.country_id AS v__country_id, v.latitude AS v__latitude, v.longitude AS v__longitude, v.is_manual_location AS v__is_manual_location, v.homepage AS v__homepage, v.phone AS v__phone, v.fax AS v__fax, v.email AS v__email, v.capacity AS v__capacity, v.description AS v__description, v.directions AS v__directions, v.is_active AS v__is_active, v.postal_area_id AS v__postal_area_id, v.tw_modified AS v__tw_modified, v.encore_id AS v__encore_id, v.created_at AS v__created_at, v.updated_at AS v__updated_at, v.slug AS v__slug FROM venue v WHERE (v.id = ?) LIMIT 1 - (369009) |
144 | Doctrine_Connection_Statement | execute : SELECT c.id AS c__id, c.name AS c__name, c.code AS c__code, c.status AS c__status, c.created_at AS c__created_at, c.updated_at AS c__updated_at FROM country c WHERE (c.id = ?) - (66009) |
145 | Doctrine_Connection_Statement | execute : SELECT a.id AS a__id, a.name AS a__name, a.alt_names AS a__alt_names, a.twitter AS a__twitter, a.caption AS a__caption, a.html_page_title AS a__html_page_title, a.html_keywords AS a__html_keywords, a.html_description AS a__html_description, a.type_id AS a__type_id, a.mbid AS a__mbid, a.display_sessions_in_calendar AS a__display_sessions_in_calendar, a.hide_artist AS a__hide_artist, a.alert_sent_at AS a__alert_sent_at, a.short_url_id AS a__short_url_id, a.itunes_artist_id AS a__itunes_artist_id, a.page_url AS a__page_url, a.encore_id AS a__encore_id, a.created_at AS a__created_at, a.updated_at AS a__updated_at, a.slug AS a__slug, a.created_by AS a__created_by, a.updated_by AS a__updated_by, a2.artist_id AS a2__artist_id, a2.session_id AS a2__session_id, a2.created_at AS a2__created_at, a2.updated_at AS a2__updated_at FROM artist a LEFT JOIN artist_session a2 ON a.id = a2.artist_id WHERE (a2.session_id IN (?)) - (13372900) |
146 | Doctrine_Connection_Statement | execute : SELECT a.id AS a__id, a.name AS a__name, a.alt_names AS a__alt_names, a.twitter AS a__twitter, a.caption AS a__caption, a.html_page_title AS a__html_page_title, a.html_keywords AS a__html_keywords, a.html_description AS a__html_description, a.type_id AS a__type_id, a.mbid AS a__mbid, a.display_sessions_in_calendar AS a__display_sessions_in_calendar, a.hide_artist AS a__hide_artist, a.alert_sent_at AS a__alert_sent_at, a.short_url_id AS a__short_url_id, a.itunes_artist_id AS a__itunes_artist_id, a.page_url AS a__page_url, a.encore_id AS a__encore_id, a.created_at AS a__created_at, a.updated_at AS a__updated_at, a.slug AS a__slug, a.created_by AS a__created_by, a.updated_by AS a__updated_by FROM artist a WHERE (a.id = ?) LIMIT 1 - (567) |
147 | Doctrine_Connection_Statement | execute : SELECT a.id AS a__id, a.name AS a__name, a.label AS a__label, a.description AS a__description, a.created_at AS a__created_at, a.updated_at AS a__updated_at FROM artist_type a WHERE (a.id = ?) - (2) |
148 | Doctrine_Connection_Mysql | query : SELECT q.id AS q__id, q.unique_key AS q__unique_key, q.session_id AS q__session_id, q.zone_name AS q__zone_name, q.zone_display_name AS q__zone_display_name, q.price_name AS q__price_name, q.price_display_name AS q__price_display_name, q.rank_name AS q__rank_name, q.face_value AS q__face_value, q.booking_fee AS q__booking_fee, q.kickback AS q__kickback, q.complex_split AS q__complex_split, q.multiple_seats AS q__multiple_seats, q.min_tickets AS q__min_tickets, q.max_tickets AS q__max_tickets, q.availability AS q__availability, q.ticketware_price_id AS q__ticketware_price_id, q.zone_id AS q__zone_id, q.rank_id AS q__rank_id, q.fee_id AS q__fee_id, q.seating_type_id AS q__seating_type_id, q.internal_use AS q__internal_use, q.ticketplan_fee_id AS q__ticketplan_fee_id, q.ticketplan_fee AS q__ticketplan_fee FROM
(
SELECT p.*
FROM price p
LEFT JOIN price_priority pr ON pr.price_unique_key = p.unique_key
WHERE p.availability > 0 AND p.session_id = 13372900 AND p.internal_use = 0 AND p.fee_id != 121073
GROUP BY p.id, p.rank_id
ORDER BY ISNULL(pr. position), pr.position ASC, p.face_value DESC, p.zone_name ASC
) as q
- () |
149 | sfPartialView | Render "sf_app_dir/modules/session/templates/_itemButton.php" |
150 | sfPartialView | Render "sf_app_dir/modules/session/templates/_widgetFanticks.php" |
151 | sfPartialView | Render "sf_app_dir/modules/session/templates/_itemDate.php" |
152 | sfPartialView | Render "sf_app_dir/modules/session/templates/_itemMetaData.php" |
153 | Doctrine_Connection_Statement | execute : SELECT a.id AS a__id, a.name AS a__name, a.alt_names AS a__alt_names, a.twitter AS a__twitter, a.caption AS a__caption, a.html_page_title AS a__html_page_title, a.html_keywords AS a__html_keywords, a.html_description AS a__html_description, a.type_id AS a__type_id, a.mbid AS a__mbid, a.display_sessions_in_calendar AS a__display_sessions_in_calendar, a.hide_artist AS a__hide_artist, a.alert_sent_at AS a__alert_sent_at, a.short_url_id AS a__short_url_id, a.itunes_artist_id AS a__itunes_artist_id, a.page_url AS a__page_url, a.encore_id AS a__encore_id, a.created_at AS a__created_at, a.updated_at AS a__updated_at, a.slug AS a__slug, a.created_by AS a__created_by, a.updated_by AS a__updated_by, a2.artist_id AS a2__artist_id, a2.session_id AS a2__session_id, a2.created_at AS a2__created_at, a2.updated_at AS a2__updated_at FROM artist a LEFT JOIN artist_session a2 ON a.id = a2.artist_id WHERE (a2.session_id IN (?)) - (13372864) |
154 | Doctrine_Connection_Statement | execute : SELECT a.id AS a__id, a.name AS a__name, a.alt_names AS a__alt_names, a.twitter AS a__twitter, a.caption AS a__caption, a.html_page_title AS a__html_page_title, a.html_keywords AS a__html_keywords, a.html_description AS a__html_description, a.type_id AS a__type_id, a.mbid AS a__mbid, a.display_sessions_in_calendar AS a__display_sessions_in_calendar, a.hide_artist AS a__hide_artist, a.alert_sent_at AS a__alert_sent_at, a.short_url_id AS a__short_url_id, a.itunes_artist_id AS a__itunes_artist_id, a.page_url AS a__page_url, a.encore_id AS a__encore_id, a.created_at AS a__created_at, a.updated_at AS a__updated_at, a.slug AS a__slug, a.created_by AS a__created_by, a.updated_by AS a__updated_by FROM artist a WHERE (a.id = ?) LIMIT 1 - (38985) |
155 | Doctrine_Connection_Statement | execute : SELECT a.id AS a__id, a.name AS a__name, a.label AS a__label, a.description AS a__description, a.created_at AS a__created_at, a.updated_at AS a__updated_at FROM artist_type a WHERE (a.id = ?) - (1) |
156 | Doctrine_Connection_Mysql | query : SELECT q.id AS q__id, q.unique_key AS q__unique_key, q.session_id AS q__session_id, q.zone_name AS q__zone_name, q.zone_display_name AS q__zone_display_name, q.price_name AS q__price_name, q.price_display_name AS q__price_display_name, q.rank_name AS q__rank_name, q.face_value AS q__face_value, q.booking_fee AS q__booking_fee, q.kickback AS q__kickback, q.complex_split AS q__complex_split, q.multiple_seats AS q__multiple_seats, q.min_tickets AS q__min_tickets, q.max_tickets AS q__max_tickets, q.availability AS q__availability, q.ticketware_price_id AS q__ticketware_price_id, q.zone_id AS q__zone_id, q.rank_id AS q__rank_id, q.fee_id AS q__fee_id, q.seating_type_id AS q__seating_type_id, q.internal_use AS q__internal_use, q.ticketplan_fee_id AS q__ticketplan_fee_id, q.ticketplan_fee AS q__ticketplan_fee FROM
(
SELECT p.*
FROM price p
LEFT JOIN price_priority pr ON pr.price_unique_key = p.unique_key
WHERE p.availability > 0 AND p.session_id = 13372864 AND p.internal_use = 0 AND p.fee_id != 121073
GROUP BY p.id, p.rank_id
ORDER BY ISNULL(pr. position), pr.position ASC, p.face_value DESC, p.zone_name ASC
) as q
- () |
157 | Doctrine_Connection_Statement | execute : SELECT s.code AS s__code, s.name AS s__name, s.description AS s__description FROM session_status s WHERE (s.code = ?) LIMIT 1 - (S) |
158 | sfPartialView | Render "sf_app_dir/modules/session/templates/_itemButton.php" |
159 | Doctrine_Connection_Statement | execute : SELECT s.code AS s__code, s.name AS s__name, s.description AS s__description FROM session_status s WHERE (s.code = ?) LIMIT 1 - (S) |
160 | Doctrine_Connection_Statement | execute : SELECT s.code AS s__code, s.name AS s__name, s.description AS s__description FROM session_status s WHERE (s.code = ?) LIMIT 1 - (S) |
161 | Doctrine_Connection_Statement | execute : SELECT s.code AS s__code, s.name AS s__name, s.description AS s__description FROM session_status s WHERE (s.code = ?) LIMIT 1 - (S) |
162 | Doctrine_Connection_Statement | execute : SELECT s.code AS s__code, s.name AS s__name, s.description AS s__description FROM session_status s WHERE (s.code = ?) LIMIT 1 - (S) |
163 | sfPartialView | Render "sf_app_dir/modules/session/templates/_widgetFanticks.php" |
164 | Doctrine_Connection_Statement | execute : SELECT s.code AS s__code, s.name AS s__name, s.description AS s__description FROM session_status s WHERE (s.code = ?) LIMIT 1 - (S) |
165 | sfPartialView | Render "sf_app_dir/modules/session/templates/_itemDate.php" |
166 | sfPartialView | Render "sf_app_dir/modules/session/templates/_itemMetaData.php" |
167 | Doctrine_Connection_Statement | execute : SELECT a.id AS a__id, a.name AS a__name, a.alt_names AS a__alt_names, a.twitter AS a__twitter, a.caption AS a__caption, a.html_page_title AS a__html_page_title, a.html_keywords AS a__html_keywords, a.html_description AS a__html_description, a.type_id AS a__type_id, a.mbid AS a__mbid, a.display_sessions_in_calendar AS a__display_sessions_in_calendar, a.hide_artist AS a__hide_artist, a.alert_sent_at AS a__alert_sent_at, a.short_url_id AS a__short_url_id, a.itunes_artist_id AS a__itunes_artist_id, a.page_url AS a__page_url, a.encore_id AS a__encore_id, a.created_at AS a__created_at, a.updated_at AS a__updated_at, a.slug AS a__slug, a.created_by AS a__created_by, a.updated_by AS a__updated_by, a2.artist_id AS a2__artist_id, a2.session_id AS a2__session_id, a2.created_at AS a2__created_at, a2.updated_at AS a2__updated_at FROM artist a LEFT JOIN artist_session a2 ON a.id = a2.artist_id WHERE (a2.session_id IN (?)) - (13372908) |
168 | Doctrine_Connection_Statement | execute : SELECT a.id AS a__id, a.name AS a__name, a.alt_names AS a__alt_names, a.twitter AS a__twitter, a.caption AS a__caption, a.html_page_title AS a__html_page_title, a.html_keywords AS a__html_keywords, a.html_description AS a__html_description, a.type_id AS a__type_id, a.mbid AS a__mbid, a.display_sessions_in_calendar AS a__display_sessions_in_calendar, a.hide_artist AS a__hide_artist, a.alert_sent_at AS a__alert_sent_at, a.short_url_id AS a__short_url_id, a.itunes_artist_id AS a__itunes_artist_id, a.page_url AS a__page_url, a.encore_id AS a__encore_id, a.created_at AS a__created_at, a.updated_at AS a__updated_at, a.slug AS a__slug, a.created_by AS a__created_by, a.updated_by AS a__updated_by FROM artist a WHERE (a.id = ?) LIMIT 1 - (53821) |
169 | Doctrine_Connection_Statement | execute : SELECT a.id AS a__id, a.name AS a__name, a.label AS a__label, a.description AS a__description, a.created_at AS a__created_at, a.updated_at AS a__updated_at FROM artist_type a WHERE (a.id = ?) - (1) |
170 | Doctrine_Connection_Mysql | query : SELECT q.id AS q__id, q.unique_key AS q__unique_key, q.session_id AS q__session_id, q.zone_name AS q__zone_name, q.zone_display_name AS q__zone_display_name, q.price_name AS q__price_name, q.price_display_name AS q__price_display_name, q.rank_name AS q__rank_name, q.face_value AS q__face_value, q.booking_fee AS q__booking_fee, q.kickback AS q__kickback, q.complex_split AS q__complex_split, q.multiple_seats AS q__multiple_seats, q.min_tickets AS q__min_tickets, q.max_tickets AS q__max_tickets, q.availability AS q__availability, q.ticketware_price_id AS q__ticketware_price_id, q.zone_id AS q__zone_id, q.rank_id AS q__rank_id, q.fee_id AS q__fee_id, q.seating_type_id AS q__seating_type_id, q.internal_use AS q__internal_use, q.ticketplan_fee_id AS q__ticketplan_fee_id, q.ticketplan_fee AS q__ticketplan_fee FROM
(
SELECT p.*
FROM price p
LEFT JOIN price_priority pr ON pr.price_unique_key = p.unique_key
WHERE p.availability > 0 AND p.session_id = 13372908 AND p.internal_use = 0 AND p.fee_id != 121073
GROUP BY p.id, p.rank_id
ORDER BY ISNULL(pr. position), pr.position ASC, p.face_value DESC, p.zone_name ASC
) as q
- () |
171 | Doctrine_Connection_Statement | execute : SELECT s.code AS s__code, s.name AS s__name, s.description AS s__description FROM session_status s WHERE (s.code = ?) LIMIT 1 - (S) |
172 | sfPartialView | Render "sf_app_dir/modules/session/templates/_itemButton.php" |
173 | Doctrine_Connection_Statement | execute : SELECT s.code AS s__code, s.name AS s__name, s.description AS s__description FROM session_status s WHERE (s.code = ?) LIMIT 1 - (S) |
174 | Doctrine_Connection_Statement | execute : SELECT s.code AS s__code, s.name AS s__name, s.description AS s__description FROM session_status s WHERE (s.code = ?) LIMIT 1 - (S) |
175 | Doctrine_Connection_Statement | execute : SELECT s.code AS s__code, s.name AS s__name, s.description AS s__description FROM session_status s WHERE (s.code = ?) LIMIT 1 - (S) |
176 | Doctrine_Connection_Statement | execute : SELECT s.code AS s__code, s.name AS s__name, s.description AS s__description FROM session_status s WHERE (s.code = ?) LIMIT 1 - (S) |
177 | sfPartialView | Render "sf_app_dir/modules/session/templates/_widgetFanticks.php" |
178 | Doctrine_Connection_Statement | execute : SELECT s.code AS s__code, s.name AS s__name, s.description AS s__description FROM session_status s WHERE (s.code = ?) LIMIT 1 - (S) |
179 | sfPartialView | Render "sf_app_dir/modules/session/templates/_itemDate.php" |
180 | sfPartialView | Render "sf_app_dir/modules/session/templates/_itemMetaData.php" |
181 | Doctrine_Connection_Statement | execute : SELECT a.id AS a__id, a.name AS a__name, a.alt_names AS a__alt_names, a.twitter AS a__twitter, a.caption AS a__caption, a.html_page_title AS a__html_page_title, a.html_keywords AS a__html_keywords, a.html_description AS a__html_description, a.type_id AS a__type_id, a.mbid AS a__mbid, a.display_sessions_in_calendar AS a__display_sessions_in_calendar, a.hide_artist AS a__hide_artist, a.alert_sent_at AS a__alert_sent_at, a.short_url_id AS a__short_url_id, a.itunes_artist_id AS a__itunes_artist_id, a.page_url AS a__page_url, a.encore_id AS a__encore_id, a.created_at AS a__created_at, a.updated_at AS a__updated_at, a.slug AS a__slug, a.created_by AS a__created_by, a.updated_by AS a__updated_by, a2.artist_id AS a2__artist_id, a2.session_id AS a2__session_id, a2.created_at AS a2__created_at, a2.updated_at AS a2__updated_at FROM artist a LEFT JOIN artist_session a2 ON a.id = a2.artist_id WHERE (a2.session_id IN (?)) - (13372865) |
182 | Doctrine_Connection_Statement | execute : SELECT a.id AS a__id, a.name AS a__name, a.alt_names AS a__alt_names, a.twitter AS a__twitter, a.caption AS a__caption, a.html_page_title AS a__html_page_title, a.html_keywords AS a__html_keywords, a.html_description AS a__html_description, a.type_id AS a__type_id, a.mbid AS a__mbid, a.display_sessions_in_calendar AS a__display_sessions_in_calendar, a.hide_artist AS a__hide_artist, a.alert_sent_at AS a__alert_sent_at, a.short_url_id AS a__short_url_id, a.itunes_artist_id AS a__itunes_artist_id, a.page_url AS a__page_url, a.encore_id AS a__encore_id, a.created_at AS a__created_at, a.updated_at AS a__updated_at, a.slug AS a__slug, a.created_by AS a__created_by, a.updated_by AS a__updated_by FROM artist a WHERE (a.id = ?) LIMIT 1 - (38955) |
183 | Doctrine_Connection_Statement | execute : SELECT a.id AS a__id, a.name AS a__name, a.label AS a__label, a.description AS a__description, a.created_at AS a__created_at, a.updated_at AS a__updated_at FROM artist_type a WHERE (a.id = ?) - (1) |
184 | Doctrine_Connection_Mysql | query : SELECT q.id AS q__id, q.unique_key AS q__unique_key, q.session_id AS q__session_id, q.zone_name AS q__zone_name, q.zone_display_name AS q__zone_display_name, q.price_name AS q__price_name, q.price_display_name AS q__price_display_name, q.rank_name AS q__rank_name, q.face_value AS q__face_value, q.booking_fee AS q__booking_fee, q.kickback AS q__kickback, q.complex_split AS q__complex_split, q.multiple_seats AS q__multiple_seats, q.min_tickets AS q__min_tickets, q.max_tickets AS q__max_tickets, q.availability AS q__availability, q.ticketware_price_id AS q__ticketware_price_id, q.zone_id AS q__zone_id, q.rank_id AS q__rank_id, q.fee_id AS q__fee_id, q.seating_type_id AS q__seating_type_id, q.internal_use AS q__internal_use, q.ticketplan_fee_id AS q__ticketplan_fee_id, q.ticketplan_fee AS q__ticketplan_fee FROM
(
SELECT p.*
FROM price p
LEFT JOIN price_priority pr ON pr.price_unique_key = p.unique_key
WHERE p.availability > 0 AND p.session_id = 13372865 AND p.internal_use = 0 AND p.fee_id != 121073
GROUP BY p.id, p.rank_id
ORDER BY ISNULL(pr. position), pr.position ASC, p.face_value DESC, p.zone_name ASC
) as q
- () |
185 | Doctrine_Connection_Statement | execute : SELECT s.code AS s__code, s.name AS s__name, s.description AS s__description FROM session_status s WHERE (s.code = ?) LIMIT 1 - (S) |
186 | sfPartialView | Render "sf_app_dir/modules/session/templates/_itemButton.php" |
187 | Doctrine_Connection_Statement | execute : SELECT s.code AS s__code, s.name AS s__name, s.description AS s__description FROM session_status s WHERE (s.code = ?) LIMIT 1 - (S) |
188 | Doctrine_Connection_Statement | execute : SELECT s.code AS s__code, s.name AS s__name, s.description AS s__description FROM session_status s WHERE (s.code = ?) LIMIT 1 - (S) |
189 | Doctrine_Connection_Statement | execute : SELECT s.code AS s__code, s.name AS s__name, s.description AS s__description FROM session_status s WHERE (s.code = ?) LIMIT 1 - (S) |
190 | Doctrine_Connection_Statement | execute : SELECT s.code AS s__code, s.name AS s__name, s.description AS s__description FROM session_status s WHERE (s.code = ?) LIMIT 1 - (S) |
191 | sfPartialView | Render "sf_app_dir/modules/session/templates/_widgetFanticks.php" |
192 | Doctrine_Connection_Statement | execute : SELECT s.code AS s__code, s.name AS s__name, s.description AS s__description FROM session_status s WHERE (s.code = ?) LIMIT 1 - (S) |
193 | main | Set slot "sidebar" |
194 | sfViewCacheManager | Save cache for "session/onSaleToday" |
195 | sfPHPView | Decorate content with "sf_app_dir/templates/layout.php" |
196 | sfPHPView | Render "sf_app_dir/templates/layout.php" |
197 | sfPartialView | Render "sf_app_dir/modules/layout/templates/_debug.php" |
198 | sfPartialView | Render "sf_app_dir/modules/layout/templates/_webmaster.php" |
199 | main | Get slot "ecommerceTracking" |
200 | main | Get slot "facebook_homepage_tracking" |
201 | sfPartialView | Render "sf_app_dir/modules/layout/templates/_assets.php" |
202 | sfPartialView | Render "sf_app_dir/modules/layout/templates/_assetFonts.php" |
203 | main | Get slot "extraBodyClasses" |
204 | sfPartialView | Render "sf_app_dir/modules/social/templates/_itemInitialisation.php" |
205 | sfPartialView | Render "sf_app_dir/modules/layout/templates/_notification.php" |
206 | sfPartialView | Render "sf_app_dir/modules/layout/templates/ticketline_standard/_header.php" |
207 | main | Call "layout->executeWaitingRoomPassInformation()" |
208 | sfPartialView | Render "sf_app_dir/modules/social/templates/_itemLinks.php" |
209 | sfPartialView | Render "sf_app_dir/modules/layout/templates/_mainNav.php" |
210 | sfPartialView | Render "sf_app_dir/modules/search/templates/_form.php" |
211 | sfPartialView | Render "sf_app_dir/modules/layout/templates/_noJavascript.php" |
212 | main | Get slot "sidebar" |
213 | sfPartialView | Render "sf_app_dir/modules/layout/templates/ticketline_standard/_footer.php" |
214 | sfPartialView | Render "sf_app_dir/modules/layout/templates/_ticketlineCompanies.php" |
215 | sfPartialView | Render "sf_app_dir/modules/social/templates/_itemLinks.php" |
216 | sfPartialView | Render "sf_app_dir/modules/layout/templates/_platformSwitch.php" |
217 | sfPartialView | Render "sf_app_dir/modules/layout/templates/_copyright.php" |
218 | sfPartialView | Render "sf_app_dir/modules/layout/templates/_registeredCompany.php" |
219 | sfPartialView | Render "sf_app_dir/modules/layout/templates/_cookieConsent.php" |
220 | sfPartialView | Render "sf_app_dir/modules/layout/templates/_fanticksWidgetJs.php" |
221 | sfPartialView | Render "sf_app_dir/modules/order/templates/_modalProcessing.php" |
222 | sfPartialView | Render "sf_app_dir/modules/layout/templates/_processingGif.php" |
223 | tlResponse | Send status "HTTP/1.1 200 OK" |
224 | tlResponse | Send header "Cache-Control: private" |
225 | tlResponse | Send header "P3p: CP="ALL DSP COR CUR ADM PSA CONi OUR SAM OTR UNR LEG"" |
226 | tlResponse | Send header "Access-Control-Allow-Origin: *" |
227 | tlResponse | Send header "Content-Type: text/html; charset=utf-8" |
228 | tlResponse | Send cookie "tlv4": "937d8926a106d0bdff1c10439e1e1a69:b37ad3144d3d6e16490d7ef0fa46588b270e10ca" |