# |
type |
message |
1 | sfPatternRouting | Connect sfRoute "sf_guard_signin" (/guard/login) |
2 | sfPatternRouting | Connect sfRoute "sf_guard_signout" (/guard/logout) |
3 | sfPatternRouting | Connect sfRoute "sf_guard_forgot_password" (/guard/forgot_password) |
4 | sfPatternRouting | Connect sfDoctrineRoute "sf_guard_forgot_password_change" (/guard/forgot_password/:unique_key) |
5 | sfPatternRouting | Connect sfRoute "sf_guard_password" (/request_password) |
6 | sfPatternRouting | Connect sfRoute "sf_guard_do_password" (/request_password/do) |
7 | sfPatternRouting | Connect sfRoute "sf_guard_forgot_password_reset_password" (/reset_password/:key/:id) |
8 | sfPatternRouting | Match route "itinerary_show_interactive" (/itinerary/view/:id) for /itinerary/view/617 with parameters array ( 'module' => 'itinerary', 'action' => 'view', 'id' => '617',) |
9 | sfFilterChain | Executing filter "sfRenderingFilter" |
10 | sfFilterChain | Executing filter "sfGuardRememberMeFilter" |
11 | sfFilterChain | Executing filter "ConfigFilter" |
12 | sfFilterChain | Executing filter "sfExecutionFilter" |
13 | itineraryActions | Call "itineraryActions->executeView()" |
14 | Doctrine_Connection_Mysql | exec : SET NAMES 'utf8' - () |
15 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.user_id AS i__user_id, i.title AS i__title, i.description AS i__description, i.price AS i__price, i.status AS i__status, i.orig_filename AS i__orig_filename, i.filetype AS i__filetype, i.itinerary_filepath AS i__itinerary_filepath, i.image_filepath AS i__image_filepath, i.rating AS i__rating, i.image_caption AS i__image_caption, i.first_day_free AS i__first_day_free, i.amazon_product_id AS i__amazon_product_id, i.currency_id AS i__currency_id, i.created_at AS i__created_at, i.updated_at AS i__updated_at, i.slug AS i__slug FROM itinerary i WHERE (i.status = ? AND i.id = ? AND i.first_day_free = ?) ORDER BY i.created_at DESC - (3, 617, 1) |
16 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.user_id AS i__user_id, i.title AS i__title, i.description AS i__description, i.price AS i__price, i.status AS i__status, i.orig_filename AS i__orig_filename, i.filetype AS i__filetype, i.itinerary_filepath AS i__itinerary_filepath, i.image_filepath AS i__image_filepath, i.rating AS i__rating, i.image_caption AS i__image_caption, i.first_day_free AS i__first_day_free, i.amazon_product_id AS i__amazon_product_id, i.currency_id AS i__currency_id, i.created_at AS i__created_at, i.updated_at AS i__updated_at, i.slug AS i__slug FROM itinerary i WHERE (i.status = ? AND i.id = ?) ORDER BY i.created_at DESC - (3, 617) |
17 | itineraryActions | Forward to action "itinerary/show" |
18 | sfFilterChain | Executing filter "sfRenderingFilter" |
19 | sfFilterChain | Executing filter "sfGuardRememberMeFilter" |
20 | sfFilterChain | Executing filter "ConfigFilter" |
21 | sfFilterChain | Executing filter "sfExecutionFilter" |
22 | itineraryActions | Call "itineraryActions->executeShow()" |
23 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.user_id AS i__user_id, i.title AS i__title, i.description AS i__description, i.price AS i__price, i.status AS i__status, i.orig_filename AS i__orig_filename, i.filetype AS i__filetype, i.itinerary_filepath AS i__itinerary_filepath, i.image_filepath AS i__image_filepath, i.rating AS i__rating, i.image_caption AS i__image_caption, i.first_day_free AS i__first_day_free, i.amazon_product_id AS i__amazon_product_id, i.currency_id AS i__currency_id, i.created_at AS i__created_at, i.updated_at AS i__updated_at, i.slug AS i__slug FROM itinerary i WHERE (i.status = ? AND i.id = ?) ORDER BY i.created_at DESC - (3, 617) |
24 | Doctrine_Connection_Statement | execute : SELECT n.id AS n__id, n.itinerary_id AS n__itinerary_id, n.node_type AS n__node_type, n.node_subtype AS n__node_subtype, n.title AS n__title, n.address AS n__address, n.start_time AS n__start_time, n.end_time AS n__end_time, n.price AS n__price, n.description AS n__description, n.sequence_order AS n__sequence_order, n.itinerary_day AS n__itinerary_day, n.status AS n__status, n.created_at AS n__created_at, n.updated_at AS n__updated_at, n.slug AS n__slug FROM node n WHERE (n.itinerary_id IN (?)) - (617) |
25 | Doctrine_Connection_Statement | execute : SELECT c.id AS c__id, c.geoarea_id AS c__geoarea_id, c.name AS c__name, c.fips104 AS c__fips104, c.iso2 AS c__iso2, c.iso3 AS c__iso3, c.ison AS c__ison, c.internet AS c__internet, c.capital AS c__capital, c.map_reference AS c__map_reference, c.nationality_singular AS c__nationality_singular, c.nationality_plural AS c__nationality_plural, c.currency AS c__currency, c.currency_code AS c__currency_code, c.population AS c__population, c.title AS c__title, c.comment AS c__comment, c.slug AS c__slug, c2.id AS c2__id, c2.country_id AS c2__country_id, c2.region_id AS c2__region_id, c2.name AS c2__name, c2.latitude AS c2__latitude, c2.longitude AS c2__longitude, c2.timezone AS c2__timezone, c2.dma_id AS c2__dma_id, c2.code AS c2__code, c2.description AS c2__description, c2.slug AS c2__slug, c2.population AS c2__population, c2.rank AS c2__rank, i.itinerary_id AS i__itinerary_id, i.city_id AS i__city_id, i.rank AS i__rank, i.created_at AS i__created_at, i.updated_at AS i__updated_at, i2.id AS i2__id, i2.user_id AS i2__user_id, i2.title AS i2__title, i2.description AS i2__description, i2.price AS i2__price, i2.status AS i2__status, i2.orig_filename AS i2__orig_filename, i2.filetype AS i2__filetype, i2.itinerary_filepath AS i2__itinerary_filepath, i2.image_filepath AS i2__image_filepath, i2.rating AS i2__rating, i2.image_caption AS i2__image_caption, i2.first_day_free AS i2__first_day_free, i2.amazon_product_id AS i2__amazon_product_id, i2.currency_id AS i2__currency_id, i2.created_at AS i2__created_at, i2.updated_at AS i2__updated_at, i2.slug AS i2__slug FROM country c INNER JOIN city c2 ON c.id = c2.country_id INNER JOIN itinerary_city i ON c2.id = i.city_id INNER JOIN itinerary i2 ON i.itinerary_id = i2.id WHERE (i2.id = ?) ORDER BY i.rank ASC - (617) |
26 | Doctrine_Connection_Statement | execute : SELECT c.id AS c__id, c.country_id AS c__country_id, c.region_id AS c__region_id, c.name AS c__name, c.latitude AS c__latitude, c.longitude AS c__longitude, c.timezone AS c__timezone, c.dma_id AS c__dma_id, c.code AS c__code, c.description AS c__description, c.slug AS c__slug, c.population AS c__population, c.rank AS c__rank, c2.id AS c2__id, c2.geoarea_id AS c2__geoarea_id, c2.name AS c2__name, c2.fips104 AS c2__fips104, c2.iso2 AS c2__iso2, c2.iso3 AS c2__iso3, c2.ison AS c2__ison, c2.internet AS c2__internet, c2.capital AS c2__capital, c2.map_reference AS c2__map_reference, c2.nationality_singular AS c2__nationality_singular, c2.nationality_plural AS c2__nationality_plural, c2.currency AS c2__currency, c2.currency_code AS c2__currency_code, c2.population AS c2__population, c2.title AS c2__title, c2.comment AS c2__comment, c2.slug AS c2__slug FROM city c INNER JOIN country c2 ON c.country_id = c2.id WHERE (c.country_id = ?) ORDER BY c.population DESC LIMIT 300 - (91) |
27 | Doctrine_Connection_Statement | execute : SELECT c.id AS c__id, c.country_id AS c__country_id, c.region_id AS c__region_id, c.name AS c__name, c.latitude AS c__latitude, c.longitude AS c__longitude, c.timezone AS c__timezone, c.dma_id AS c__dma_id, c.code AS c__code, c.description AS c__description, c.slug AS c__slug, c.population AS c__population, c.rank AS c__rank, c2.id AS c2__id, c2.geoarea_id AS c2__geoarea_id, c2.name AS c2__name, c2.fips104 AS c2__fips104, c2.iso2 AS c2__iso2, c2.iso3 AS c2__iso3, c2.ison AS c2__ison, c2.internet AS c2__internet, c2.capital AS c2__capital, c2.map_reference AS c2__map_reference, c2.nationality_singular AS c2__nationality_singular, c2.nationality_plural AS c2__nationality_plural, c2.currency AS c2__currency, c2.currency_code AS c2__currency_code, c2.population AS c2__population, c2.title AS c2__title, c2.comment AS c2__comment, c2.slug AS c2__slug FROM city c INNER JOIN country c2 ON c.country_id = c2.id WHERE (c.country_id = ?) ORDER BY c.population DESC LIMIT 300 - (91) |
28 | Doctrine_Connection_Statement | execute : SELECT c.id AS c__id, c.country_id AS c__country_id, c.region_id AS c__region_id, c.name AS c__name, c.latitude AS c__latitude, c.longitude AS c__longitude, c.timezone AS c__timezone, c.dma_id AS c__dma_id, c.code AS c__code, c.description AS c__description, c.slug AS c__slug, c.population AS c__population, c.rank AS c__rank, c2.id AS c2__id, c2.geoarea_id AS c2__geoarea_id, c2.name AS c2__name, c2.fips104 AS c2__fips104, c2.iso2 AS c2__iso2, c2.iso3 AS c2__iso3, c2.ison AS c2__ison, c2.internet AS c2__internet, c2.capital AS c2__capital, c2.map_reference AS c2__map_reference, c2.nationality_singular AS c2__nationality_singular, c2.nationality_plural AS c2__nationality_plural, c2.currency AS c2__currency, c2.currency_code AS c2__currency_code, c2.population AS c2__population, c2.title AS c2__title, c2.comment AS c2__comment, c2.slug AS c2__slug FROM city c INNER JOIN country c2 ON c.country_id = c2.id WHERE (c.country_id = ?) ORDER BY c.population DESC LIMIT 300 - (91) |
29 | Doctrine_Connection_Statement | execute : SELECT c.id AS c__id, c.country_id AS c__country_id, c.region_id AS c__region_id, c.name AS c__name, c.latitude AS c__latitude, c.longitude AS c__longitude, c.timezone AS c__timezone, c.dma_id AS c__dma_id, c.code AS c__code, c.description AS c__description, c.slug AS c__slug, c.population AS c__population, c.rank AS c__rank, c2.id AS c2__id, c2.geoarea_id AS c2__geoarea_id, c2.name AS c2__name, c2.fips104 AS c2__fips104, c2.iso2 AS c2__iso2, c2.iso3 AS c2__iso3, c2.ison AS c2__ison, c2.internet AS c2__internet, c2.capital AS c2__capital, c2.map_reference AS c2__map_reference, c2.nationality_singular AS c2__nationality_singular, c2.nationality_plural AS c2__nationality_plural, c2.currency AS c2__currency, c2.currency_code AS c2__currency_code, c2.population AS c2__population, c2.title AS c2__title, c2.comment AS c2__comment, c2.slug AS c2__slug FROM city c INNER JOIN country c2 ON c.country_id = c2.id WHERE (c.country_id = ?) ORDER BY c.population DESC LIMIT 300 - (91) |
30 | Doctrine_Connection_Statement | execute : SELECT c.id AS c__id, c.country_id AS c__country_id, c.region_id AS c__region_id, c.name AS c__name, c.latitude AS c__latitude, c.longitude AS c__longitude, c.timezone AS c__timezone, c.dma_id AS c__dma_id, c.code AS c__code, c.description AS c__description, c.slug AS c__slug, c.population AS c__population, c.rank AS c__rank, c2.id AS c2__id, c2.geoarea_id AS c2__geoarea_id, c2.name AS c2__name, c2.fips104 AS c2__fips104, c2.iso2 AS c2__iso2, c2.iso3 AS c2__iso3, c2.ison AS c2__ison, c2.internet AS c2__internet, c2.capital AS c2__capital, c2.map_reference AS c2__map_reference, c2.nationality_singular AS c2__nationality_singular, c2.nationality_plural AS c2__nationality_plural, c2.currency AS c2__currency, c2.currency_code AS c2__currency_code, c2.population AS c2__population, c2.title AS c2__title, c2.comment AS c2__comment, c2.slug AS c2__slug FROM city c INNER JOIN country c2 ON c.country_id = c2.id WHERE (c.country_id = ?) ORDER BY c.population DESC LIMIT 300 - (91) |
31 | Doctrine_Connection_Statement | execute : SELECT c.id AS c__id, c.country_id AS c__country_id, c.region_id AS c__region_id, c.name AS c__name, c.latitude AS c__latitude, c.longitude AS c__longitude, c.timezone AS c__timezone, c.dma_id AS c__dma_id, c.code AS c__code, c.description AS c__description, c.slug AS c__slug, c.population AS c__population, c.rank AS c__rank, i.itinerary_id AS i__itinerary_id, i.city_id AS i__city_id, i.rank AS i__rank, i.created_at AS i__created_at, i.updated_at AS i__updated_at, i2.id AS i2__id, i2.user_id AS i2__user_id, i2.title AS i2__title, i2.description AS i2__description, i2.price AS i2__price, i2.status AS i2__status, i2.orig_filename AS i2__orig_filename, i2.filetype AS i2__filetype, i2.itinerary_filepath AS i2__itinerary_filepath, i2.image_filepath AS i2__image_filepath, i2.rating AS i2__rating, i2.image_caption AS i2__image_caption, i2.first_day_free AS i2__first_day_free, i2.amazon_product_id AS i2__amazon_product_id, i2.currency_id AS i2__currency_id, i2.created_at AS i2__created_at, i2.updated_at AS i2__updated_at, i2.slug AS i2__slug FROM city c INNER JOIN itinerary_city i ON c.id = i.city_id INNER JOIN itinerary i2 ON i.itinerary_id = i2.id WHERE (i2.id = ?) ORDER BY i.rank ASC - (617) |
32 | sfPHPView | Render "sf_app_dir/modules/itinerary/templates/showSuccess.php" |
33 | main | Set slot "breadcrumbs" |
34 | Doctrine_Connection_Statement | execute : SELECT g.id AS g__id, g.name AS g__name, g.latitude AS g__latitude, g.longitude AS g__longitude, g.zoom AS g__zoom, g.slug AS g__slug FROM geoarea g WHERE (g.id = ?) - (4) |
35 | main | Call "common->executeAddToCart()" |
36 | sfPartialView | Render "sf_app_dir/modules/common/templates/_addToCart.php" |
37 | Doctrine_Connection_Statement | execute : SELECT s.id AS s__id, s.first_name AS s__first_name, s.last_name AS s__last_name, s.email_address AS s__email_address, s.username AS s__username, s.algorithm AS s__algorithm, s.salt AS s__salt, s.password AS s__password, s.is_active AS s__is_active, s.is_super_admin AS s__is_super_admin, s.last_login AS s__last_login, s.created_at AS s__created_at, s.updated_at AS s__updated_at FROM sf_guard_user s WHERE (s.id = ?) - (1945) |
38 | Doctrine_Connection_Statement | execute : SELECT s.id AS s__id, s.user_id AS s__user_id, s.company AS s__company, s.phone AS s__phone, s.address AS s__address, s.address2 AS s__address2, s.zip AS s__zip, s.city AS s__city, s.state AS s__state, s.country AS s__country, s.opt_in AS s__opt_in, s.photo AS s__photo, s.about AS s__about, s.num_countries_visited AS s__num_countries_visited, s.travel_status AS s__travel_status, s.home_town AS s__home_town, s.twitter_id AS s__twitter_id, s.blog_url AS s__blog_url, s.credit_pending AS s__credit_pending, s.credit_confirmed AS s__credit_confirmed, s.paypal_email AS s__paypal_email, s.balance AS s__balance, s.balance_updated_at AS s__balance_updated_at, s.created_at AS s__created_at, s.updated_at AS s__updated_at FROM sf_guard_user_profile s WHERE (s.user_id = ?) - (1945) |
39 | sfPartialView | Render "sf_app_dir/modules/itinerary/templates/_sample.php" |
40 | Doctrine_Connection_Statement | execute : SELECT c.id AS c__id, c.country_id AS c__country_id, c.region_id AS c__region_id, c.name AS c__name, c.latitude AS c__latitude, c.longitude AS c__longitude, c.timezone AS c__timezone, c.dma_id AS c__dma_id, c.code AS c__code, c.description AS c__description, c.slug AS c__slug, c.population AS c__population, c.rank AS c__rank, i.itinerary_id AS i__itinerary_id, i.city_id AS i__city_id, i.rank AS i__rank, i.created_at AS i__created_at, i.updated_at AS i__updated_at FROM city c LEFT JOIN itinerary_city i ON c.id = i.city_id WHERE (i.itinerary_id IN (?)) - (617) |
41 | sfPHPView | Decorate content with "sf_app_dir/templates/layout.php" |
42 | sfPHPView | Render "sf_app_dir/templates/layout.php" |
43 | main | Call "common->executeLeftColumn()" |
44 | sfPartialView | Render "sf_app_dir/modules/common/templates/_leftColumn.php" |
45 | main | Call "common->executeFeedback()" |
46 | sfPartialView | Render "sf_app_dir/modules/common/templates/_feedback.php" |
47 | sfPartialView | Render "sf_app_dir/templates/_map.php" |
48 | main | Get slot "breadcrumbs" |
49 | sfPartialView | Render "sf_app_dir/templates/_flashes.php" |
50 | sfWebResponse | Send status "HTTP/1.1 200 OK" |
51 | sfWebResponse | Send header "Content-Type: text/html; charset=utf-8" |