# |
type |
message |
1 | sfPatternRouting | Match route "location_results_city" (/event/location/region/:city) for /event/location/region/liverpool with parameters array ( 'module' => 'location', 'action' => 'results', 'city' => 'liverpool',) |
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/location/region/liverpool" |
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 | locationActions | Call "locationActions->executeResults()" |
23 | Doctrine_Connection_Statement | execute : SELECT t.id AS t__id, t.name AS t__name, t.is_ticketline_genre AS t__is_ticketline_genre, t.created_at AS t__created_at, t.updated_at AS t__updated_at, t.slug AS t__slug FROM tag t INNER JOIN affiliate_tag a2 ON (t.id = a2.tag_id) INNER JOIN affiliate a ON a.id = a2.affiliate_id WHERE (a.id = ?) ORDER BY t.name - (1) |
24 | Doctrine_Connection_Statement | execute : SELECT t.id AS t__id, t.name AS t__name, t.is_ticketline_genre AS t__is_ticketline_genre, t.created_at AS t__created_at, t.updated_at AS t__updated_at, t.slug AS t__slug FROM tag t INNER JOIN affiliate_tag a2 ON (t.id = a2.tag_id) INNER JOIN affiliate a ON a.id = a2.affiliate_id WHERE (a.id = ?) ORDER BY t.name - (1) |
25 | Doctrine_Connection_Statement | execute : SELECT t.id AS t__id, t.name AS t__name, t.is_ticketline_genre AS t__is_ticketline_genre, t.created_at AS t__created_at, t.updated_at AS t__updated_at, t.slug AS t__slug FROM tag t INNER JOIN affiliate_tag a2 ON (t.id = a2.tag_id) INNER JOIN affiliate a ON a.id = a2.affiliate_id WHERE (a.id = ?) ORDER BY t.name - (1) |
26 | 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, a.affiliate_id AS a__affiliate_id, a.venue_space_id AS a__venue_space_id FROM venue_space v LEFT JOIN affiliate_venue_space a ON v.id = a.venue_space_id WHERE (a.affiliate_id IN (?)) - (1) |
27 | 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, e2.id AS e2__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.slug AS v2__slug, v2.latitude AS v2__latitude, v2.longitude AS v2__longitude, 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, IFNULL(NULLIF(a7.artist_id, ''), a8.artist_id) AS a7__0, IFNULL(NULLIF(a9.name, ''), a10.name) AS a9__1, IFNULL(NULLIF(a9.slug, ''), a10.slug) AS a9__2, MIN(p.face_value + p.booking_fee) AS p__3, SUM(p.availability) AS p__4, IFNULL(s.encore_id, s.id) AS s__5 FROM session s 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_tag a5 ON (a.id = a5.artist_id) LEFT JOIN tag t ON t.id = a5.tag_id AND (t.id IN (1, 2, 3, 22, 4, 5, 6, 7, 8, 24, 23, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 25, 26, 27, 21)) LEFT JOIN artist_tag a6 ON (a3.id = a6.artist_id) LEFT JOIN tag t2 ON t2.id = a6.tag_id AND (t2.id IN (1, 2, 3, 22, 4, 5, 6, 7, 8, 24, 23, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 25, 26, 27, 21)) INNER JOIN session_status s2 ON s.status_code = s2.code INNER JOIN event e2 ON s.event_id = e2.id INNER JOIN venue_space v ON s.venue_space_id = v.id AND (v.venue_id IN (172009, 589009, 500000533, 500000685, 551009, 676710, 48009, 672632, 51009, 673213, 675724, 675725, 648009, 405009, 554009, 672815, 185009, 673316, 674525, 309009, 673976, 674302, 674239, 673814, 677161, 674282, 673960, 674296, 565009, 49009, 234009, 673021, 673644, 173009, 233009, 672843, 672990, 236009, 672610, 672544, 672887, 235009, 437009, 672701, 672319, 672786, 216009, 672019, 672110, 672870, 674570, 673240, 479009, 675033, 677213, 238009, 672882, 674374, 676897, 674767, 677635, 232009, 239009, 672797, 673621, 674116, 677519, 674145, 672586, 673348, 420009, 678340, 672232, 672864, 672372, 673318, 672517, 672714, 674077, 674246, 240009, 674252, 270009, 672986, 673048, 678313, 676786, 677926, 677457, 672258, 674211, 229009, 230009, 231009, 673427, 673507, 677464, 677465, 674702, 151009, 676506, 672537, 673073, 674260, 673375, 674299, 673556, 673309, 673642, 672599, 676994, 237009, 672826, 521009, 672074, 326009, 675280, 675281, 675282, 673232, 50009, 672692, 677769, 244009, 676122, 675562, 672128, 672798, 673061, 674513, 673495, 673600, 674290, 673717, 674217, 673444, 672518, 673685, 673931, 674593, 672049, 673301, 653009, 500000088, 673567, 52009, 675899, 672256, 672562, 672730, 279009, 323009, 675588, 673110, 674124, 228009, 673417, 672111, 672512, 673946, 672257, 678406, 673637, 281009, 673059, 675130, 283009, 672434, 674580, 675930, 672072, 595009, 676499, 500000598, 500000612, 673113, 672773, 674312, 400009, 674628, 672755, 677207, 677208, 673275, 674062, 673292, 673211, 673536, 673619, 673994, 674289, 674691, 676705, 674573, 676972, 676973, 672722, 675759, 673091, 675075)) INNER JOIN venue v2 ON v.venue_id = v2.id LEFT JOIN artist_event a7 ON e2.id = a7.event_id LEFT JOIN artist_session a8 ON s.id = a8.session_id LEFT JOIN artist a9 ON a7.artist_id = a9.id LEFT JOIN artist a10 ON a8.artist_id = a10.id LEFT JOIN artist_tag a11 ON (a9.id = a11.artist_id) LEFT JOIN tag t3 ON t3.id = a11.tag_id LEFT JOIN artist_tag a12 ON (a10.id = a12.artist_id) LEFT JOIN tag t4 ON t4.id = a12.tag_id LEFT JOIN session_distributor s3 ON (s.id = s3.session_id) LEFT JOIN distributor d ON d.id = s3.distributor_id LEFT JOIN price p ON s.id = p.session_id AND ((p.availability > 0 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 (t.id IS NOT NULL OR t2.id IS NOT NULL) AND (a7.event_id IS NOT NULL OR a8.session_id IS NOT NULL) AND s.datetime >= ? AND s.datetime <= ?) GROUP BY s__5 ORDER BY FIELD(v.venue_id, 172009, 589009, 500000533, 500000685, 551009, 676710, 48009, 672632, 51009, 673213, 675724, 675725, 648009, 405009, 554009, 672815, 185009, 673316, 674525, 309009, 673976, 674302, 674239, 673814, 677161, 674282, 673960, 674296, 565009, 49009, 234009, 673021, 673644, 173009, 233009, 672843, 672990, 236009, 672610, 672544, 672887, 235009, 437009, 672701, 672319, 672786, 216009, 672019, 672110, 672870, 674570, 673240, 479009, 675033, 677213, 238009, 672882, 674374, 676897, 674767, 677635, 232009, 239009, 672797, 673621, 674116, 677519, 674145, 672586, 673348, 420009, 678340, 672232, 672864, 672372, 673318, 672517, 672714, 674077, 674246, 240009, 674252, 270009, 672986, 673048, 678313, 676786, 677926, 677457, 672258, 674211, 229009, 230009, 231009, 673427, 673507, 677464, 677465, 674702, 151009, 676506, 672537, 673073, 674260, 673375, 674299, 673556, 673309, 673642, 672599, 676994, 237009, 672826, 521009, 672074, 326009, 675280, 675281, 675282, 673232, 50009, 672692, 677769, 244009, 676122, 675562, 672128, 672798, 673061, 674513, 673495, 673600, 674290, 673717, 674217, 673444, 672518, 673685, 673931, 674593, 672049, 673301, 653009, 500000088, 673567, 52009, 675899, 672256, 672562, 672730, 279009, 323009, 675588, 673110, 674124, 228009, 673417, 672111, 672512, 673946, 672257, 678406, 673637, 281009, 673059, 675130, 283009, 672434, 674580, 675930, 672072, 595009, 676499, 500000598, 500000612, 673113, 672773, 674312, 400009, 674628, 672755, 677207, 677208, 673275, 674062, 673292, 673211, 673536, 673619, 673994, 674289, 674691, 676705, 674573, 676972, 676973, 672722, 675759, 673091, 675075), s.datetime - (D, 2024-05-17 19:14:20, 2024-05-17 19:14:20, 2024-05-17 19:14:20, 2024-05-17 00-00:01, 2024-11-17 23-59:59) |
28 | 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 (?)) - (13371528) |
29 | 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 (?)) - (13371571) |
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 (?)) - (13371964) |
31 | 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 (?)) - (13370406) |
32 | 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 (?)) - (13370418) |
33 | sfPHPView | Render "sf_app_dir/modules/location/templates/resultsSuccess.php" |
34 | sfPartialView | Render "sf_app_dir/modules/location/templates/_itemGMap.php" |
35 | sfPartialView | Render "sf_app_dir/modules/session/templates/_listByVenue.php" |
36 | sfPartialView | Render "sf_app_dir/modules/session/templates/_itemDate.php" |
37 | sfPartialView | Render "sf_app_dir/modules/session/templates/_itemMetaData.php" |
38 | 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.event_id AS a2__event_id, a2.created_at AS a2__created_at, a2.updated_at AS a2__updated_at FROM artist a LEFT JOIN artist_event a2 ON a.id = a2.artist_id WHERE (a2.event_id IN (?)) - (6696418) |
39 | 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) |
40 | 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 - (50009) |
41 | 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) |
42 | 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 (?)) - (13371528) |
43 | 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 = 13371528 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
- () |
44 | sfPartialView | Render "sf_app_dir/modules/session/templates/_itemButton.php" |
45 | sfPartialView | Render "sf_app_dir/modules/session/templates/_widgetFanticks.php" |
46 | sfPartialView | Render "sf_app_dir/modules/session/templates/_itemDate.php" |
47 | sfPartialView | Render "sf_app_dir/modules/session/templates/_itemMetaData.php" |
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.event_id AS a2__event_id, a2.created_at AS a2__created_at, a2.updated_at AS a2__updated_at FROM artist a LEFT JOIN artist_event a2 ON a.id = a2.artist_id WHERE (a2.event_id IN (?)) - (6731064) |
49 | 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 - (653009) |
50 | 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) |
51 | 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 (?)) - (13371571) |
52 | 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) |
53 | 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) |
54 | 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 = 13371571 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
- () |
55 | sfPartialView | Render "sf_app_dir/modules/session/templates/_itemButton.php" |
56 | sfPartialView | Render "sf_app_dir/modules/session/templates/_widgetFanticks.php" |
57 | sfPartialView | Render "sf_app_dir/modules/session/templates/_itemDate.php" |
58 | sfPartialView | Render "sf_app_dir/modules/session/templates/_itemMetaData.php" |
59 | 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.event_id AS a2__event_id, a2.created_at AS a2__created_at, a2.updated_at AS a2__updated_at FROM artist a LEFT JOIN artist_event a2 ON a.id = a2.artist_id WHERE (a2.event_id IN (?)) - (6731263) |
60 | 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 (?)) - (13371964) |
61 | 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 = 13371964 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
- () |
62 | sfPartialView | Render "sf_app_dir/modules/session/templates/_itemButton.php" |
63 | sfPartialView | Render "sf_app_dir/modules/session/templates/_widgetFanticks.php" |
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 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.event_id AS a2__event_id, a2.created_at AS a2__created_at, a2.updated_at AS a2__updated_at FROM artist a LEFT JOIN artist_event a2 ON a.id = a2.artist_id WHERE (a2.event_id IN (?)) - (6730273) |
67 | 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 (?)) - (13370406) |
68 | 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 = 13370406 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
- () |
69 | sfPartialView | Render "sf_app_dir/modules/session/templates/_itemButton.php" |
70 | sfPartialView | Render "sf_app_dir/modules/session/templates/_widgetFanticks.php" |
71 | sfPartialView | Render "sf_app_dir/modules/session/templates/_itemDate.php" |
72 | sfPartialView | Render "sf_app_dir/modules/session/templates/_itemMetaData.php" |
73 | 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.event_id AS a2__event_id, a2.created_at AS a2__created_at, a2.updated_at AS a2__updated_at FROM artist a LEFT JOIN artist_event a2 ON a.id = a2.artist_id WHERE (a2.event_id IN (?)) - (6730274) |
74 | 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 (?)) - (13370418) |
75 | 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 = 13370418 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
- () |
76 | sfPartialView | Render "sf_app_dir/modules/session/templates/_itemButton.php" |
77 | sfPartialView | Render "sf_app_dir/modules/session/templates/_widgetFanticks.php" |
78 | main | Set slot "sidebar" |
79 | sfPartialView | Render "sf_app_dir/modules/location/templates/_blockChangeLocation.php" |
80 | sfPartialView | Render "sf_app_dir/modules/location/templates/_formLocationSearch.php" |
81 | main | Call "location->executeBlockFilter()" |
82 | sfPartialView | Render "sf_app_dir/modules/location/templates/_blockFilter.php" |
83 | main | Call "social->executeBlockFacebookLike()" |
84 | sfPartialView | Render "sf_app_dir/modules/social/templates/_blockFacebookLike.php" |
85 | sfPHPView | Decorate content with "sf_app_dir/templates/layout.php" |
86 | sfPHPView | Render "sf_app_dir/templates/layout.php" |
87 | sfPartialView | Render "sf_app_dir/modules/layout/templates/_debug.php" |
88 | sfPartialView | Render "sf_app_dir/modules/layout/templates/_webmaster.php" |
89 | main | Get slot "ecommerceTracking" |
90 | main | Get slot "facebook_homepage_tracking" |
91 | sfPartialView | Render "sf_app_dir/modules/layout/templates/_assets.php" |
92 | sfPartialView | Render "sf_app_dir/modules/layout/templates/_assetFonts.php" |
93 | main | Get slot "extraBodyClasses" |
94 | sfPartialView | Render "sf_app_dir/modules/social/templates/_itemInitialisation.php" |
95 | sfPartialView | Render "sf_app_dir/modules/layout/templates/_notification.php" |
96 | sfPartialView | Render "sf_app_dir/modules/layout/templates/ticketline_standard/_header.php" |
97 | main | Call "layout->executeWaitingRoomPassInformation()" |
98 | sfPartialView | Render "sf_app_dir/modules/social/templates/_itemLinks.php" |
99 | sfPartialView | Render "sf_app_dir/modules/layout/templates/_mainNav.php" |
100 | sfPartialView | Render "sf_app_dir/modules/search/templates/_form.php" |
101 | sfPartialView | Render "sf_app_dir/modules/layout/templates/_noJavascript.php" |
102 | main | Get slot "sidebar" |
103 | sfPartialView | Render "sf_app_dir/modules/layout/templates/ticketline_standard/_footer.php" |
104 | sfPartialView | Render "sf_app_dir/modules/layout/templates/_ticketlineCompanies.php" |
105 | sfPartialView | Render "sf_app_dir/modules/social/templates/_itemLinks.php" |
106 | sfPartialView | Render "sf_app_dir/modules/layout/templates/_platformSwitch.php" |
107 | sfPartialView | Render "sf_app_dir/modules/layout/templates/_copyright.php" |
108 | sfPartialView | Render "sf_app_dir/modules/layout/templates/_registeredCompany.php" |
109 | sfPartialView | Render "sf_app_dir/modules/layout/templates/_cookieConsent.php" |
110 | sfPartialView | Render "sf_app_dir/modules/layout/templates/_fanticksWidgetJs.php" |
111 | sfPartialView | Render "sf_app_dir/modules/order/templates/_modalProcessing.php" |
112 | sfPartialView | Render "sf_app_dir/modules/layout/templates/_processingGif.php" |
113 | tlResponse | Send status "HTTP/1.1 200 OK" |
114 | tlResponse | Send header "Cache-Control: private" |
115 | tlResponse | Send header "P3p: CP="ALL DSP COR CUR ADM PSA CONi OUR SAM OTR UNR LEG"" |
116 | tlResponse | Send header "Access-Control-Allow-Origin: *" |
117 | tlResponse | Send header "Content-Type: text/html; charset=utf-8" |
118 | tlResponse | Send cookie "tlv4": "14e48e900ce29e80c00e7805e008279b:8c5b66b48453d152dcc9ba385aa8b0e2f7aa1511" |