# |
type |
message |
1 | sfPatternRouting | Match route "default" (/:module/:action/*) for /D4/utopia with parameters array ( 'module' => 'D4', 'action' => 'utopia',) |
2 | sfFilterChain | Executing filter "sfRenderingFilter" |
3 | sfFilterChain | Executing filter "sfExecutionFilter" |
4 | D4Actions | Call "D4Actions->executeUtopia()" |
5 | Doctrine_Connection_Mysql | exec : SET NAMES 'UTF8' - () |
6 | Doctrine_Connection_Statement | execute : SELECT u.id AS u__id, u.continent_id AS u__continent_id, u.country AS u__country, u.division_first_id AS u__division_first_id, u.division_second_id AS u__division_second_id, u.name AS u__name, u.other_names AS u__other_names, u.city AS u__city, u.to_see AS u__to_see, u.start AS u__start, u.end AS u__end, u.duration AS u__duration, u.population AS u__population, u.population_type AS u__population_type, u.population_about AS u__population_about, u.founders AS u__founders, u.front_page AS u__front_page, u.front_page_en AS u__front_page_en, u.instructions AS u__instructions, u.testimony1 AS u__testimony1, u.testimony2 AS u__testimony2, u.testimony3 AS u__testimony3, u.bibliography AS u__bibliography, u.latitude AS u__latitude, u.longitude AS u__longitude, u.altitude AS u__altitude, u.color_id AS u__color_id, u.sound AS u__sound, u.is_published AS u__is_published, u.created_at AS u__created_at, u.updated_at AS u__updated_at, u.deleted_at AS u__deleted_at FROM utopia u WHERE (u.name LIKE '%Macluria%' AND u.is_published = ?) - (1) |
7 | Doctrine_Connection_Statement | execute : SELECT u.id AS u__id, u.continent_id AS u__continent_id, u.country AS u__country, u.division_first_id AS u__division_first_id, u.division_second_id AS u__division_second_id, u.name AS u__name, u.other_names AS u__other_names, u.city AS u__city, u.to_see AS u__to_see, u.start AS u__start, u.end AS u__end, u.duration AS u__duration, u.population AS u__population, u.population_type AS u__population_type, u.population_about AS u__population_about, u.founders AS u__founders, u.front_page AS u__front_page, u.front_page_en AS u__front_page_en, u.instructions AS u__instructions, u.testimony1 AS u__testimony1, u.testimony2 AS u__testimony2, u.testimony3 AS u__testimony3, u.bibliography AS u__bibliography, u.latitude AS u__latitude, u.longitude AS u__longitude, u.altitude AS u__altitude, u.color_id AS u__color_id, u.sound AS u__sound, u.is_published AS u__is_published, u.created_at AS u__created_at, u.updated_at AS u__updated_at, u.deleted_at AS u__deleted_at FROM utopia u WHERE (u.id = ?) LIMIT 1 - (42) |
8 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.ideology_id AS i__ideology_id, i.utopia_id AS i__utopia_id FROM ideology_utopia i WHERE (i.utopia_id = ?) - (42) |
9 | Doctrine_Connection_Statement | execute : SELECT e.id AS e__id, e.economy_id AS e__economy_id, e.utopia_id AS e__utopia_id FROM economy_utopia e WHERE (e.utopia_id = ?) - (42) |
10 | Doctrine_Connection_Statement | execute : SELECT p.id AS p__id, p.utopia_id AS p__utopia_id, p.img AS p__img, p.caption AS p__caption, p.position AS p__position FROM picture p WHERE (p.utopia_id = ?) ORDER BY p.position asc - (42) |
11 | Doctrine_Connection_Statement | execute : SELECT p.id AS p__id, p.utopia_id AS p__utopia_id, p.img AS p__img, p.screen AS p__screen, p.start AS p__start, p.end AS p__end, p.duration AS p__duration, p.position AS p__position FROM picture_cimaise p WHERE (p.utopia_id = ? AND position = 1) ORDER BY p.position asc - (42) |
12 | Doctrine_Connection_Statement | execute : SELECT o.id AS o__id, o.utopia_id AS o__utopia_id, o.title AS o__title, o.text AS o__text, o.img1 AS o__img1, o.caption1 AS o__caption1, o.img2 AS o__img2, o.caption2 AS o__caption2, o.dimensions AS o__dimensions FROM object_related o WHERE (o.utopia_id = ?) LIMIT 1 - (42) |
13 | Doctrine_Connection_Statement | execute : SELECT c.id AS c__id, c.name AS c__name, c.capital AS c__capital, c.latitude AS c__latitude, c.longitude AS c__longitude, c.altitude AS c__altitude FROM country c WHERE (c.name = ?) LIMIT 1 - (United States) |
14 | sfPartialView | Render "sf_app_dir/modules/D4/templates/_utopia.php" |
15 | Doctrine_Connection_Statement | execute : SELECT c.id AS c__id, c.name AS c__name FROM continent c WHERE (c.id = ?) - (2) |
16 | Doctrine_Connection_Statement | execute : SELECT d.id AS d__id, d.country AS d__country, d.name AS d__name, d.name_en AS d__name_en, d.latitude AS d__latitude, d.longitude AS d__longitude, d.altitude AS d__altitude FROM division_first d WHERE (d.id = ?) - (11) |
17 | Doctrine_Connection_Statement | execute : SELECT d.id AS d__id, d.division_first_id AS d__division_first_id, d.name AS d__name, d.name_en AS d__name_en, d.latitude AS d__latitude, d.longitude AS d__longitude, d.altitude AS d__altitude FROM division_second d WHERE (d.id = ?) - (20) |
18 | Doctrine_Connection_Statement | execute : SELECT f.id AS f__id, f.first_name AS f__first_name, f.last_name AS f__last_name, f.biography AS f__biography, f2.id AS f2__id, f2.founder_id AS f2__founder_id, f2.utopia_id AS f2__utopia_id FROM founder f LEFT JOIN founder_utopia f2 ON f.id = f2.founder_id WHERE (f2.utopia_id IN (?)) - (42) |
19 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.name AS i__name, i.description AS i__description FROM ideology i WHERE (i.id = ?) - (3) |
20 | Doctrine_Connection_Statement | execute : SELECT e.id AS e__id, e.name AS e__name FROM economy e WHERE (e.id = ?) - (1) |
21 | sfWebResponse | Send status "HTTP/1.1 200 OK" |
22 | sfWebResponse | Send header "Content-Type: text/html; charset=utf-8" |