# |
type |
message |
1 | sfPatternRouting | Match route "venue_show" (/venue/:slug) for /venue/glasgow-royal-concert-hall with parameters array ( 'module' => 'venue', 'action' => 'show', 'slug' => 'glasgow-royal-concert-hall',) |
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: "none" |
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 | venueActions | Call "venueActions->executeShow()" |
23 | 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.slug = ?) LIMIT 1 - (glasgow-royal-concert-hall) |
24 | 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, e.id AS e__id, 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, s2.code AS s2__code, s2.name AS s2__name, p.unique_key AS p__unique_key, p.id AS p__id, a.id AS a__id, a.name AS a__name, a.slug AS a__slug, a3.id AS a3__id, a3.name AS a3__name, MIN(p.face_value + p.booking_fee) AS p__0, SUM(p.availability) AS p__1 FROM session s INNER JOIN event e ON s.event_id = e.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 session_status s2 ON s.status_code = s2.code LEFT JOIN price p ON s.id = p.session_id AND ((p.availability > 0 AND p.internal_use = 0)) LEFT JOIN artist_event a2 ON (e.id = a2.event_id) LEFT JOIN artist a ON a.id = a2.artist_id LEFT JOIN artist_type a3 ON a.type_id = a3.id WHERE (s.status_code != ? AND s.datetime >= ? AND s.embargoed_until <= ? AND (s.hide_from IS NULL OR s.hide_from > ?) AND v2.id = ?) GROUP BY s.id ORDER BY s.datetime, s.event_name - (D, 2024-05-17 16:08:28, 2024-05-17 16:08:28, 2024-05-17 16:08:28, 42009) |
25 | 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 (?)) - (13370137) |
26 | 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 (?)) - (13372709) |
27 | 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, COUNT(DISTINCT s.id) AS s__0 FROM venue v INNER JOIN venue_space v2 ON v.id = v2.venue_id INNER JOIN session s ON v2.id = s.venue_space_id WHERE (v.is_active = ? AND v.city = ? AND s.status_code != ? AND s.datetime >= ? AND s.embargoed_until <= ? AND (s.hide_from IS NULL OR s.hide_from > ?)) GROUP BY v.id ORDER BY COUNT(DISTINCT s.id) DESC - (1, Glasgow, D, 2024-05-17 16:08:28, 2024-05-17 16:08:28, 2024-05-17 16:08:28) |
28 | sfPHPView | Render "sf_app_dir/modules/venue/templates/showSuccess.php" |
29 | main | Call "social->executeItemShare()" |
30 | Doctrine_Connection_Statement | execute : SELECT s.id AS s__id, s.url AS s__url, s.code AS s__code, s.alias AS s__alias, s.created_at AS s__created_at, s.updated_at AS s__updated_at FROM short_url s WHERE (s.url = ?) - (http://www.ticketline.co.uk/venue/glasgow-royal-concert-hall) |
31 | sfPartialView | Render "sf_app_dir/modules/social/templates/_itemShare.php" |
32 | sfPartialView | Render "sf_app_dir/modules/venue/templates/_tabInfo.php" |
33 | Doctrine_Connection_Statement | execute : SELECT v.id AS v__id, v.venue_id AS v__venue_id, v.image_type_id AS v__image_type_id, v.filename AS v__filename, v.priority AS v__priority, v.height AS v__height, v.width AS v__width, v.alt_description AS v__alt_description, v.created_at AS v__created_at, v.updated_at AS v__updated_at FROM venue_image v WHERE (v.venue_id = ?) - (42009) |
34 | Doctrine_Connection_Statement | execute : SELECT 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 FROM venue_space v WHERE (v.venue_id IN (?)) - (42009) |
35 | Doctrine_Connection_Statement | execute : SELECT s.id AS s__id, s.filename AS s__filename, s.is_active AS s__is_active, s.name AS s__name, s.venue_space_id AS s__venue_space_id FROM seating_plan s WHERE (s.id = ?) - (270) |
36 | Doctrine_Connection_Statement | execute : SELECT s.id AS s__id, s.filename AS s__filename, s.is_active AS s__is_active, s.name AS s__name, s.venue_space_id AS s__venue_space_id, 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.alt_names AS v2__alt_names, v2.address AS v2__address, v2.city AS v2__city, v2.postal_code AS v2__postal_code, v2.country_name AS v2__country_name, v2.country_id AS v2__country_id, v2.latitude AS v2__latitude, v2.longitude AS v2__longitude, v2.is_manual_location AS v2__is_manual_location, v2.homepage AS v2__homepage, v2.phone AS v2__phone, v2.fax AS v2__fax, v2.email AS v2__email, v2.capacity AS v2__capacity, v2.description AS v2__description, v2.directions AS v2__directions, v2.is_active AS v2__is_active, v2.postal_area_id AS v2__postal_area_id, v2.tw_modified AS v2__tw_modified, v2.encore_id AS v2__encore_id, v2.created_at AS v2__created_at, v2.updated_at AS v2__updated_at, v2.slug AS v2__slug FROM seating_plan s INNER JOIN venue_space v ON s.venue_space_id = v.id INNER JOIN venue v2 ON v.venue_id = v2.id WHERE (v2.id = ? AND s.id NOT IN (?)) - (42009, 270) |
37 | Doctrine_Connection_Statement | execute : SELECT v.id AS v__id, v.venue_id AS v__venue_id, v.image_type_id AS v__image_type_id, v.filename AS v__filename, v.priority AS v__priority, v.height AS v__height, v.width AS v__width, v.alt_description AS v__alt_description, v.created_at AS v__created_at, v.updated_at AS v__updated_at FROM venue_image v WHERE (v.venue_id = ?) - (42009) |
38 | Doctrine_Connection_Statement | execute : SELECT s.id AS s__id, s.filename AS s__filename, s.is_active AS s__is_active, s.name AS s__name, s.venue_space_id AS s__venue_space_id, 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.alt_names AS v2__alt_names, v2.address AS v2__address, v2.city AS v2__city, v2.postal_code AS v2__postal_code, v2.country_name AS v2__country_name, v2.country_id AS v2__country_id, v2.latitude AS v2__latitude, v2.longitude AS v2__longitude, v2.is_manual_location AS v2__is_manual_location, v2.homepage AS v2__homepage, v2.phone AS v2__phone, v2.fax AS v2__fax, v2.email AS v2__email, v2.capacity AS v2__capacity, v2.description AS v2__description, v2.directions AS v2__directions, v2.is_active AS v2__is_active, v2.postal_area_id AS v2__postal_area_id, v2.tw_modified AS v2__tw_modified, v2.encore_id AS v2__encore_id, v2.created_at AS v2__created_at, v2.updated_at AS v2__updated_at, v2.slug AS v2__slug FROM seating_plan s INNER JOIN venue_space v ON s.venue_space_id = v.id INNER JOIN venue v2 ON v.venue_id = v2.id WHERE (v2.id = ? AND s.id NOT IN (?)) - (42009, 270) |
39 | main | Call "layout->executeItemImageGallery()" |
40 | sfPartialView | Render "sf_app_dir/modules/layout/templates/_itemImageGallery.php" |
41 | sfPartialView | Render "sf_app_dir/modules/venue/templates/_tabContact.php" |
42 | sfPartialView | Render "sf_app_dir/modules/venue/templates/_itemGoogleMap.php" |
43 | sfPartialView | Render "sf_app_dir/modules/session/templates/_list.php" |
44 | sfPartialView | Render "sf_app_dir/modules/session/templates/_itemDate.php" |
45 | sfPartialView | Render "sf_app_dir/modules/session/templates/_itemMetaData.php" |
46 | 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 = ?) - (42009) |
47 | 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) |
48 | 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 (?)) - (13370137) |
49 | 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 - (31874) |
50 | 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 = 13370137 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
- () |
51 | sfPartialView | Render "sf_app_dir/modules/session/templates/_itemOnSaleDate.php" |
52 | sfPartialView | Render "sf_app_dir/modules/session/templates/_itemButton.php" |
53 | sfPartialView | Render "sf_app_dir/modules/session/templates/_widgetFanticks.php" |
54 | sfPartialView | Render "sf_app_dir/modules/session/templates/_itemDate.php" |
55 | sfPartialView | Render "sf_app_dir/modules/session/templates/_itemMetaData.php" |
56 | 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 (?)) - (13369400) |
57 | 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 - (10277) |
58 | 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 = 13369400 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
- () |
59 | sfPartialView | Render "sf_app_dir/modules/session/templates/_itemOnSaleDate.php" |
60 | sfPartialView | Render "sf_app_dir/modules/session/templates/_itemButton.php" |
61 | sfPartialView | Render "sf_app_dir/modules/session/templates/_widgetFanticks.php" |
62 | sfPartialView | Render "sf_app_dir/modules/session/templates/_itemDate.php" |
63 | sfPartialView | Render "sf_app_dir/modules/session/templates/_itemMetaData.php" |
64 | 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 (?)) - (13370890) |
65 | 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 = 13370890 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
- () |
66 | sfPartialView | Render "sf_app_dir/modules/session/templates/_itemOnSaleDate.php" |
67 | sfPartialView | Render "sf_app_dir/modules/session/templates/_itemButton.php" |
68 | sfPartialView | Render "sf_app_dir/modules/session/templates/_widgetFanticks.php" |
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, 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 (?)) - (13372709) |
70 | sfPartialView | Render "sf_app_dir/modules/session/templates/_itemDate.php" |
71 | sfPartialView | Render "sf_app_dir/modules/session/templates/_itemMetaData.php" |
72 | 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) |
73 | 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 = 13372709 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
- () |
74 | sfPartialView | Render "sf_app_dir/modules/session/templates/_itemOnSaleDate.php" |
75 | sfPartialView | Render "sf_app_dir/modules/session/templates/_itemButton.php" |
76 | sfPartialView | Render "sf_app_dir/modules/session/templates/_widgetFanticks.php" |
77 | main | Set slot "sidebar" |
78 | main | Call "social->executeBlockFacebookLike()" |
79 | sfPartialView | Render "sf_app_dir/modules/social/templates/_blockFacebookLike.php" |
80 | sfPHPView | Decorate content with "sf_app_dir/templates/layout.php" |
81 | sfPHPView | Render "sf_app_dir/templates/layout.php" |
82 | sfPartialView | Render "sf_app_dir/modules/layout/templates/_debug.php" |
83 | sfPartialView | Render "sf_app_dir/modules/layout/templates/_webmaster.php" |
84 | main | Get slot "ecommerceTracking" |
85 | main | Get slot "facebook_homepage_tracking" |
86 | sfPartialView | Render "sf_app_dir/modules/layout/templates/_assets.php" |
87 | sfPartialView | Render "sf_app_dir/modules/layout/templates/_assetFonts.php" |
88 | main | Get slot "extraBodyClasses" |
89 | sfPartialView | Render "sf_app_dir/modules/social/templates/_itemInitialisation.php" |
90 | sfPartialView | Render "sf_app_dir/modules/layout/templates/_notification.php" |
91 | sfPartialView | Render "sf_app_dir/modules/layout/templates/ticketline_standard/_header.php" |
92 | main | Call "layout->executeWaitingRoomPassInformation()" |
93 | sfPartialView | Render "sf_app_dir/modules/social/templates/_itemLinks.php" |
94 | sfPartialView | Render "sf_app_dir/modules/layout/templates/_mainNav.php" |
95 | sfPartialView | Render "sf_app_dir/modules/search/templates/_form.php" |
96 | sfPartialView | Render "sf_app_dir/modules/layout/templates/_noJavascript.php" |
97 | main | Get slot "sidebar" |
98 | sfPartialView | Render "sf_app_dir/modules/layout/templates/ticketline_standard/_footer.php" |
99 | sfPartialView | Render "sf_app_dir/modules/layout/templates/_ticketlineCompanies.php" |
100 | sfPartialView | Render "sf_app_dir/modules/social/templates/_itemLinks.php" |
101 | sfPartialView | Render "sf_app_dir/modules/layout/templates/_platformSwitch.php" |
102 | sfPartialView | Render "sf_app_dir/modules/layout/templates/_copyright.php" |
103 | sfPartialView | Render "sf_app_dir/modules/layout/templates/_registeredCompany.php" |
104 | sfPartialView | Render "sf_app_dir/modules/layout/templates/_cookieConsent.php" |
105 | sfPartialView | Render "sf_app_dir/modules/layout/templates/_fanticksWidgetJs.php" |
106 | sfPartialView | Render "sf_app_dir/modules/order/templates/_modalProcessing.php" |
107 | sfPartialView | Render "sf_app_dir/modules/layout/templates/_processingGif.php" |
108 | tlResponse | Send status "HTTP/1.1 200 OK" |
109 | tlResponse | Send header "Cache-Control: private" |
110 | tlResponse | Send header "P3p: CP="ALL DSP COR CUR ADM PSA CONi OUR SAM OTR UNR LEG"" |
111 | tlResponse | Send header "Access-Control-Allow-Origin: *" |
112 | tlResponse | Send header "Content-Type: text/html; charset=utf-8" |
113 | tlResponse | Send cookie "tlv4": "e27f63a66e5a7f5f699c2dd64ac212f6:c3d1ee01dac42e7d4229f7dd4ce209f5cd62a12c" |