| # |
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 | Match route "opportunities_overview" (/:sf_culture/opportunities/overview) for /en/opportunities/overview with parameters array ( 'module' => 'opportunities', 'action' => 'overview', 'sf_culture' => 'en',) |
| 6 | sfFilterChain | Executing filter "sfRenderingFilter" |
| 7 | sfFilterChain | Executing filter "sfGuardRememberMeFilter" |
| 8 | sfFilterChain | Executing filter "sfExecutionFilter" |
| 9 | opportunitiesActions | Call "opportunitiesActions->executeOverview()" |
| 10 | Doctrine_Connection_Mysql | exec : SET NAMES 'UTF8' - () |
| 11 | Doctrine_Connection_Mysql | query :
SELECT cont_1_id as continent_id, geo, IFNULL(geo_code_1, 0) + IFNULL(geo_code_2, 0) + IFNULL(geo_code_3, 0) + IFNULL(geo_code_4, 0) + IFNULL(geo_code_5, 0) + IFNULL(geo_code_6, 0) as opp_count FROM
(SELECT art_id, MAX(LEFT(geo_1_code, 1)) as cont_1_id, COUNT(LEFT(geo_1_code, 1)) as geo_code_1
FROM i__inserat
WHERE art_id = 1
GROUP BY art_id, LEFT(geo_1_code, 1)) q1
LEFT JOIN i__geo_translation tran ON tran.code = q1.cont_1_id and lang = 'en'
LEFT JOIN
(SELECT MAX(LEFT(geo_2_code, 1)) as cont_2_id, COUNT(LEFT(geo_2_code, 1)) as geo_code_2
FROM i__inserat
WHERE art_id = 1
GROUP BY art_id, LEFT(geo_2_code, 1)) q2
ON q1.cont_1_id =q2.cont_2_id
LEFT JOIN
(SELECT MAX(LEFT(geo_3_code, 1)) as cont_3_id, COUNT(LEFT(geo_3_code, 1)) as geo_code_3
FROM i__inserat
WHERE art_id = 1
GROUP BY art_id, LEFT(geo_3_code, 1)) q3
ON q1.cont_1_id = q3.cont_3_id
LEFT JOIN
(SELECT MAX(LEFT(geo_4_code, 1)) as cont_4_id,COUNT(LEFT(geo_4_code, 1)) as geo_code_4
FROM i__inserat
WHERE art_id = 1
GROUP BY art_id, LEFT(geo_4_code, 1)) q4
ON q1.cont_1_id = q4.cont_4_id
LEFT JOIN
(SELECT MAX(LEFT(geo_5_code, 1)) as cont_5_id,COUNT(LEFT(geo_5_code, 1)) as geo_code_5
FROM i__inserat
WHERE art_id = 1
GROUP BY art_id, LEFT(geo_5_code, 1)) q5
ON q1.cont_1_id = q5.cont_5_id
LEFT JOIN
(SELECT MAX(LEFT(geo_6_code, 1)) as cont_6_id,COUNT(LEFT(geo_6_code, 1)) as geo_code_6
FROM i__inserat
WHERE art_id = 1
GROUP BY art_id, LEFT(geo_6_code, 1)) q6
ON q1.cont_1_id = q6.cont_6_id - () |
| 12 | Doctrine_Connection_Mysql | query :
SELECT industry_1_id as industry_id, branche, IFNULL(branche_code_1, 0) + IFNULL(branche_code_2, 0) + IFNULL(branche_code_3, 0) + IFNULL(branche_code_4, 0) + IFNULL(branche_code_5, 0) + IFNULL(branche_code_6, 0) as opp_count FROM
(SELECT art_id,MAX(LEFT(branche_1_code, 1)) as industry_1_id,COUNT(LEFT(branche_1_code, 1)) as branche_code_1
FROM i__inserat
WHERE art_id = 1
GROUP BY art_id, LEFT(branche_1_code, 1)) q1
LEFT JOIN i__branche_translation tran ON tran.code = q1.industry_1_id and lang = 'en'
LEFT JOIN
(SELECT MAX(LEFT(branche_2_code, 1)) as industry_2_id,COUNT(LEFT(branche_2_code, 1)) as branche_code_2
FROM i__inserat
WHERE art_id = 1
GROUP BY art_id, LEFT(branche_2_code, 1)) q2
ON q1.industry_1_id =q2.industry_2_id
LEFT JOIN
(SELECT MAX(LEFT(branche_3_code, 1)) as industry_3_id,COUNT(LEFT(branche_3_code, 1)) as branche_code_3
FROM i__inserat
WHERE art_id = 1
GROUP BY art_id, LEFT(branche_3_code, 1)) q3
ON q1.industry_1_id = q3.industry_3_id
LEFT JOIN
(SELECT MAX(LEFT(branche_4_code, 1)) as industry_4_id,COUNT(LEFT(branche_4_code, 1)) as branche_code_4
FROM i__inserat
WHERE art_id = 1
GROUP BY art_id, LEFT(branche_4_code, 1)) q4
ON q1.industry_1_id = q4.industry_4_id
LEFT JOIN
(SELECT MAX(LEFT(branche_5_code, 1)) as industry_5_id,COUNT(LEFT(branche_5_code, 1)) as branche_code_5
FROM i__inserat
WHERE art_id = 1
GROUP BY art_id, LEFT(branche_5_code, 1)) q5
ON q1.industry_1_id = q5.industry_5_id
LEFT JOIN
(SELECT MAX(LEFT(branche_6_code, 1)) as industry_6_id,COUNT(LEFT(branche_6_code, 1)) as branche_code_6
FROM i__inserat
WHERE art_id = 1
GROUP BY art_id, LEFT(branche_6_code, 1)) q6
ON q1.industry_1_id = q6.industry_6_id - () |
| 13 | Doctrine_Connection_Mysql | query :
SELECT cont_1_id as continent_id, geo, IFNULL(geo_code_1, 0) + IFNULL(geo_code_2, 0) + IFNULL(geo_code_3, 0) + IFNULL(geo_code_4, 0) + IFNULL(geo_code_5, 0) + IFNULL(geo_code_6, 0) as opp_count FROM
(SELECT art_id, MAX(LEFT(geo_1_code, 1)) as cont_1_id, COUNT(LEFT(geo_1_code, 1)) as geo_code_1
FROM i__inserat
WHERE art_id = 2
GROUP BY art_id, LEFT(geo_1_code, 1)) q1
LEFT JOIN i__geo_translation tran ON tran.code = q1.cont_1_id and lang = 'en'
LEFT JOIN
(SELECT MAX(LEFT(geo_2_code, 1)) as cont_2_id, COUNT(LEFT(geo_2_code, 1)) as geo_code_2
FROM i__inserat
WHERE art_id = 2
GROUP BY art_id, LEFT(geo_2_code, 1)) q2
ON q1.cont_1_id =q2.cont_2_id
LEFT JOIN
(SELECT MAX(LEFT(geo_3_code, 1)) as cont_3_id, COUNT(LEFT(geo_3_code, 1)) as geo_code_3
FROM i__inserat
WHERE art_id = 2
GROUP BY art_id, LEFT(geo_3_code, 1)) q3
ON q1.cont_1_id = q3.cont_3_id
LEFT JOIN
(SELECT MAX(LEFT(geo_4_code, 1)) as cont_4_id,COUNT(LEFT(geo_4_code, 1)) as geo_code_4
FROM i__inserat
WHERE art_id = 2
GROUP BY art_id, LEFT(geo_4_code, 1)) q4
ON q1.cont_1_id = q4.cont_4_id
LEFT JOIN
(SELECT MAX(LEFT(geo_5_code, 1)) as cont_5_id,COUNT(LEFT(geo_5_code, 1)) as geo_code_5
FROM i__inserat
WHERE art_id = 2
GROUP BY art_id, LEFT(geo_5_code, 1)) q5
ON q1.cont_1_id = q5.cont_5_id
LEFT JOIN
(SELECT MAX(LEFT(geo_6_code, 1)) as cont_6_id,COUNT(LEFT(geo_6_code, 1)) as geo_code_6
FROM i__inserat
WHERE art_id = 2
GROUP BY art_id, LEFT(geo_6_code, 1)) q6
ON q1.cont_1_id = q6.cont_6_id - () |
| 14 | Doctrine_Connection_Mysql | query :
SELECT industry_1_id as industry_id, branche, IFNULL(branche_code_1, 0) + IFNULL(branche_code_2, 0) + IFNULL(branche_code_3, 0) + IFNULL(branche_code_4, 0) + IFNULL(branche_code_5, 0) + IFNULL(branche_code_6, 0) as opp_count FROM
(SELECT art_id,MAX(LEFT(branche_1_code, 1)) as industry_1_id,COUNT(LEFT(branche_1_code, 1)) as branche_code_1
FROM i__inserat
WHERE art_id = 2
GROUP BY art_id, LEFT(branche_1_code, 1)) q1
LEFT JOIN i__branche_translation tran ON tran.code = q1.industry_1_id and lang = 'en'
LEFT JOIN
(SELECT MAX(LEFT(branche_2_code, 1)) as industry_2_id,COUNT(LEFT(branche_2_code, 1)) as branche_code_2
FROM i__inserat
WHERE art_id = 2
GROUP BY art_id, LEFT(branche_2_code, 1)) q2
ON q1.industry_1_id =q2.industry_2_id
LEFT JOIN
(SELECT MAX(LEFT(branche_3_code, 1)) as industry_3_id,COUNT(LEFT(branche_3_code, 1)) as branche_code_3
FROM i__inserat
WHERE art_id = 2
GROUP BY art_id, LEFT(branche_3_code, 1)) q3
ON q1.industry_1_id = q3.industry_3_id
LEFT JOIN
(SELECT MAX(LEFT(branche_4_code, 1)) as industry_4_id,COUNT(LEFT(branche_4_code, 1)) as branche_code_4
FROM i__inserat
WHERE art_id = 2
GROUP BY art_id, LEFT(branche_4_code, 1)) q4
ON q1.industry_1_id = q4.industry_4_id
LEFT JOIN
(SELECT MAX(LEFT(branche_5_code, 1)) as industry_5_id,COUNT(LEFT(branche_5_code, 1)) as branche_code_5
FROM i__inserat
WHERE art_id = 2
GROUP BY art_id, LEFT(branche_5_code, 1)) q5
ON q1.industry_1_id = q5.industry_5_id
LEFT JOIN
(SELECT MAX(LEFT(branche_6_code, 1)) as industry_6_id,COUNT(LEFT(branche_6_code, 1)) as branche_code_6
FROM i__inserat
WHERE art_id = 2
GROUP BY art_id, LEFT(branche_6_code, 1)) q6
ON q1.industry_1_id = q6.industry_6_id - () |
| 15 | Doctrine_Connection_Mysql | query :
SELECT cont_1_id as continent_id, geo, IFNULL(geo_code_1, 0) + IFNULL(geo_code_2, 0) + IFNULL(geo_code_3, 0) + IFNULL(geo_code_4, 0) + IFNULL(geo_code_5, 0) + IFNULL(geo_code_6, 0) as opp_count FROM
(SELECT art_id, MAX(LEFT(geo_1_code, 1)) as cont_1_id, COUNT(LEFT(geo_1_code, 1)) as geo_code_1
FROM i__inserat
WHERE art_id = 3
GROUP BY art_id, LEFT(geo_1_code, 1)) q1
LEFT JOIN i__geo_translation tran ON tran.code = q1.cont_1_id and lang = 'en'
LEFT JOIN
(SELECT MAX(LEFT(geo_2_code, 1)) as cont_2_id, COUNT(LEFT(geo_2_code, 1)) as geo_code_2
FROM i__inserat
WHERE art_id = 3
GROUP BY art_id, LEFT(geo_2_code, 1)) q2
ON q1.cont_1_id =q2.cont_2_id
LEFT JOIN
(SELECT MAX(LEFT(geo_3_code, 1)) as cont_3_id, COUNT(LEFT(geo_3_code, 1)) as geo_code_3
FROM i__inserat
WHERE art_id = 3
GROUP BY art_id, LEFT(geo_3_code, 1)) q3
ON q1.cont_1_id = q3.cont_3_id
LEFT JOIN
(SELECT MAX(LEFT(geo_4_code, 1)) as cont_4_id,COUNT(LEFT(geo_4_code, 1)) as geo_code_4
FROM i__inserat
WHERE art_id = 3
GROUP BY art_id, LEFT(geo_4_code, 1)) q4
ON q1.cont_1_id = q4.cont_4_id
LEFT JOIN
(SELECT MAX(LEFT(geo_5_code, 1)) as cont_5_id,COUNT(LEFT(geo_5_code, 1)) as geo_code_5
FROM i__inserat
WHERE art_id = 3
GROUP BY art_id, LEFT(geo_5_code, 1)) q5
ON q1.cont_1_id = q5.cont_5_id
LEFT JOIN
(SELECT MAX(LEFT(geo_6_code, 1)) as cont_6_id,COUNT(LEFT(geo_6_code, 1)) as geo_code_6
FROM i__inserat
WHERE art_id = 3
GROUP BY art_id, LEFT(geo_6_code, 1)) q6
ON q1.cont_1_id = q6.cont_6_id - () |
| 16 | Doctrine_Connection_Mysql | query :
SELECT industry_1_id as industry_id, branche, IFNULL(branche_code_1, 0) + IFNULL(branche_code_2, 0) + IFNULL(branche_code_3, 0) + IFNULL(branche_code_4, 0) + IFNULL(branche_code_5, 0) + IFNULL(branche_code_6, 0) as opp_count FROM
(SELECT art_id,MAX(LEFT(branche_1_code, 1)) as industry_1_id,COUNT(LEFT(branche_1_code, 1)) as branche_code_1
FROM i__inserat
WHERE art_id = 3
GROUP BY art_id, LEFT(branche_1_code, 1)) q1
LEFT JOIN i__branche_translation tran ON tran.code = q1.industry_1_id and lang = 'en'
LEFT JOIN
(SELECT MAX(LEFT(branche_2_code, 1)) as industry_2_id,COUNT(LEFT(branche_2_code, 1)) as branche_code_2
FROM i__inserat
WHERE art_id = 3
GROUP BY art_id, LEFT(branche_2_code, 1)) q2
ON q1.industry_1_id =q2.industry_2_id
LEFT JOIN
(SELECT MAX(LEFT(branche_3_code, 1)) as industry_3_id,COUNT(LEFT(branche_3_code, 1)) as branche_code_3
FROM i__inserat
WHERE art_id = 3
GROUP BY art_id, LEFT(branche_3_code, 1)) q3
ON q1.industry_1_id = q3.industry_3_id
LEFT JOIN
(SELECT MAX(LEFT(branche_4_code, 1)) as industry_4_id,COUNT(LEFT(branche_4_code, 1)) as branche_code_4
FROM i__inserat
WHERE art_id = 3
GROUP BY art_id, LEFT(branche_4_code, 1)) q4
ON q1.industry_1_id = q4.industry_4_id
LEFT JOIN
(SELECT MAX(LEFT(branche_5_code, 1)) as industry_5_id,COUNT(LEFT(branche_5_code, 1)) as branche_code_5
FROM i__inserat
WHERE art_id = 3
GROUP BY art_id, LEFT(branche_5_code, 1)) q5
ON q1.industry_1_id = q5.industry_5_id
LEFT JOIN
(SELECT MAX(LEFT(branche_6_code, 1)) as industry_6_id,COUNT(LEFT(branche_6_code, 1)) as branche_code_6
FROM i__inserat
WHERE art_id = 3
GROUP BY art_id, LEFT(branche_6_code, 1)) q6
ON q1.industry_1_id = q6.industry_6_id - () |
| 17 | Doctrine_Connection_Statement | execute : SELECT a.id AS a__id, a.name AS a__name, a.created_at AS a__created_at, a.updated_at AS a__updated_at, a2.id AS a2__id, a2.uri AS a2__uri, a2.content AS a2__content, a2.lang AS a2__lang FROM a__content_site a LEFT JOIN a__content_site_translation a2 ON a.id = a2.id WHERE (a.name = ? AND a2.lang = ?) - (opportunities_overview, en) |
| 18 | Doctrine_Connection_Statement | execute : SELECT i.code AS i__code, i.parent_code AS i__parent_code, i2.code AS i2__code, i2.lang AS i2__lang, i2.geo AS i2__geo FROM i__geo i LEFT JOIN i__geo_translation i2 ON i.code = i2.code WHERE (i2.lang = ?) - (en) |
| 19 | sfPHPView | Render "sf_app_dir/modules/opportunities/templates/overviewSuccess.php" |
| 20 | sfPartialView | Render "sf_app_dir/modules/default/templates/_header_banner.php" |
| 21 | sfPartialView | Render "sf_app_dir/modules/opportunities/templates/_action_buttons.php" |
| 22 | Doctrine_Connection_Statement | execute : SELECT DISTINCT i.id AS i__id, i.user_id AS i__user_id, i.creator_id AS i__creator_id, i.mitglied_id AS i__mitglied_id, i.art_id AS i__art_id, i.ip_adresse AS i__ip_adresse, i.bol_counted AS i__bol_counted, i.bol_tokened AS i__bol_tokened, i.reward_date AS i__reward_date, i.last_infomail_send_date AS i__last_infomail_send_date, i.titel AS i__titel, i.branche_1_code AS i__branche_1_code, i.branche_2_code AS i__branche_2_code, i.branche_3_code AS i__branche_3_code, i.branche_4_code AS i__branche_4_code, i.branche_5_code AS i__branche_5_code, i.branche_6_code AS i__branche_6_code, i.currency_id AS i__currency_id, i.dateiname_pdf_1 AS i__dateiname_pdf_1, i.dateiname_pdf_2 AS i__dateiname_pdf_2, i.dateiname_pdf_3 AS i__dateiname_pdf_3, i.kurzbeschrieb AS i__kurzbeschrieb, i.anz_mitarbeiter_id AS i__anz_mitarbeiter_id, i.umsatzkategorie_id AS i__umsatzkategorie_id, i.ebitda_id AS i__ebitda_id, i.beteiligungs_art_id AS i__beteiligungs_art_id, i.beteiligung_id AS i__beteiligung_id, i.geo_1_code AS i__geo_1_code, i.geo_2_code AS i__geo_2_code, i.geo_3_code AS i__geo_3_code, i.geo_4_code AS i__geo_4_code, i.geo_5_code AS i__geo_5_code, i.geo_6_code AS i__geo_6_code, i.homepage AS i__homepage, i.bol_kontakt_show AS i__bol_kontakt_show, i.vorname AS i__vorname, i.nachname AS i__nachname, i.firma AS i__firma, i.adresse AS i__adresse, i.plz AS i__plz, i.ort AS i__ort, i.k_land AS i__k_land, i.tel AS i__tel, i.mobil AS i__mobil, i.email AS i__email, i.weitere_infos AS i__weitere_infos, i.referenz_nr AS i__referenz_nr, i.bol_opp_digests AS i__bol_opp_digests, i.bol_data_feeds AS i__bol_data_feeds, i.bol_freigabe_user AS i__bol_freigabe_user, i.freigabe_user_datum AS i__freigabe_user_datum, i.sperren_dealgate_datum AS i__sperren_dealgate_datum, i.ablauf_datum AS i__ablauf_datum, i.bol_aktiv AS i__bol_aktiv, i.anzeige_ab_datum AS i__anzeige_ab_datum, i.anzeige_bis_datum AS i__anzeige_bis_datum, i.bol_geloescht AS i__bol_geloescht, i.geloescht_am AS i__geloescht_am, i.aktiv_datum AS i__aktiv_datum, i.member_reference AS i__member_reference, i.created_at AS i__created_at, i.updated_at AS i__updated_at, i3.code AS i3__code, i4.code AS i4__code, i4.lang AS i4__lang, i4.branche AS i4__0, i5.code AS i5__code, i6.code AS i6__code, i6.lang AS i6__lang, i6.branche AS i6__1, i7.code AS i7__code, i8.code AS i8__code, i8.lang AS i8__lang, i8.branche AS i8__2, i9.code AS i9__code, i10.code AS i10__code, i10.lang AS i10__lang, i10.branche AS i10__3, i11.code AS i11__code, i12.code AS i12__code, i12.lang AS i12__lang, i12.branche AS i12__4, i13.code AS i13__code, i14.code AS i14__code, i14.lang AS i14__lang, i14.branche AS i14__5, i15.code AS i15__code, i16.code AS i16__code, i16.lang AS i16__lang, i16.geo AS i16__6, i17.code AS i17__code, i18.code AS i18__code, i18.lang AS i18__lang, i18.geo AS i18__7, i19.code AS i19__code, i20.code AS i20__code, i20.lang AS i20__lang, i20.geo AS i20__8, i21.code AS i21__code, i22.code AS i22__code, i22.lang AS i22__lang, i22.geo AS i22__9, i23.code AS i23__code, i24.code AS i24__code, i24.lang AS i24__lang, i24.geo AS i24__10, i25.code AS i25__code, i26.code AS i26__code, i26.lang AS i26__lang, i26.geo AS i26__11, i4.branche AS i4__0, i6.branche AS i6__1, i8.branche AS i8__2, i10.branche AS i10__3, i12.branche AS i12__4, i14.branche AS i14__5, i16.geo AS i16__6, i18.geo AS i18__7, i20.geo AS i20__8, i22.geo AS i22__9, i24.geo AS i24__10, i26.geo AS i26__11 FROM i__inserat i LEFT JOIN i__inserat_x_mitgliedsgruppe i2 ON i.id = i2.inserat_id LEFT JOIN sf_guard_user s ON i.user_id = s.id LEFT JOIN i__branche i3 ON i.branche_1_code = i3.code LEFT JOIN i__branche_translation i4 ON i3.code = i4.code LEFT JOIN i__branche i5 ON i.branche_2_code = i5.code LEFT JOIN i__branche_translation i6 ON i5.code = i6.code LEFT JOIN i__branche i7 ON i.branche_3_code = i7.code LEFT JOIN i__branche_translation i8 ON i7.code = i8.code LEFT JOIN i__branche i9 ON i.branche_4_code = i9.code LEFT JOIN i__branche_translation i10 ON i9.code = i10.code LEFT JOIN i__branche i11 ON i.branche_5_code = i11.code LEFT JOIN i__branche_translation i12 ON i11.code = i12.code LEFT JOIN i__branche i13 ON i.branche_6_code = i13.code LEFT JOIN i__branche_translation i14 ON i13.code = i14.code LEFT JOIN i__geo i15 ON i.geo_1_code = i15.code LEFT JOIN i__geo_translation i16 ON i15.code = i16.code LEFT JOIN i__geo i17 ON i.geo_2_code = i17.code LEFT JOIN i__geo_translation i18 ON i17.code = i18.code LEFT JOIN i__geo i19 ON i.geo_3_code = i19.code LEFT JOIN i__geo_translation i20 ON i19.code = i20.code LEFT JOIN i__geo i21 ON i.geo_4_code = i21.code LEFT JOIN i__geo_translation i22 ON i21.code = i22.code LEFT JOIN i__geo i23 ON i.geo_5_code = i23.code LEFT JOIN i__geo_translation i24 ON i23.code = i24.code LEFT JOIN i__geo i25 ON i.geo_6_code = i25.code LEFT JOIN i__geo_translation i26 ON i25.code = i26.code WHERE (i.bol_aktiv = ? AND i.bol_geloescht = ? AND i.art_id = ? AND s.is_active = ? AND i4.lang = ? AND (i6.lang = ? OR i6.lang IS NULL) AND (i8.lang = ? OR i8.lang IS NULL) AND (i10.lang = ? OR i10.lang IS NULL) AND (i12.lang = ? OR i12.lang IS NULL) AND (i14.lang = ? OR i14.lang IS NULL) AND i16.lang = ? AND (i18.lang = ? OR i18.lang IS NULL) AND (i20.lang = ? OR i20.lang IS NULL) AND (i22.lang = ? OR i22.lang IS NULL) AND (i24.lang = ? OR i24.lang IS NULL) AND (i26.lang = ? OR i26.lang IS NULL)) ORDER BY i.created_at DESC - (1, 0, 1, 1, en, en, en, en, en, en, en, en, en, en, en, en) |
| 23 | sfPartialView | Render "sf_app_dir/modules/opportunities/templates/_opportunities_list.php" |
| 24 | Doctrine_Connection_Statement | execute : SELECT DISTINCT i.id AS i__id, i.user_id AS i__user_id, i.creator_id AS i__creator_id, i.mitglied_id AS i__mitglied_id, i.art_id AS i__art_id, i.ip_adresse AS i__ip_adresse, i.bol_counted AS i__bol_counted, i.bol_tokened AS i__bol_tokened, i.reward_date AS i__reward_date, i.last_infomail_send_date AS i__last_infomail_send_date, i.titel AS i__titel, i.branche_1_code AS i__branche_1_code, i.branche_2_code AS i__branche_2_code, i.branche_3_code AS i__branche_3_code, i.branche_4_code AS i__branche_4_code, i.branche_5_code AS i__branche_5_code, i.branche_6_code AS i__branche_6_code, i.currency_id AS i__currency_id, i.dateiname_pdf_1 AS i__dateiname_pdf_1, i.dateiname_pdf_2 AS i__dateiname_pdf_2, i.dateiname_pdf_3 AS i__dateiname_pdf_3, i.kurzbeschrieb AS i__kurzbeschrieb, i.anz_mitarbeiter_id AS i__anz_mitarbeiter_id, i.umsatzkategorie_id AS i__umsatzkategorie_id, i.ebitda_id AS i__ebitda_id, i.beteiligungs_art_id AS i__beteiligungs_art_id, i.beteiligung_id AS i__beteiligung_id, i.geo_1_code AS i__geo_1_code, i.geo_2_code AS i__geo_2_code, i.geo_3_code AS i__geo_3_code, i.geo_4_code AS i__geo_4_code, i.geo_5_code AS i__geo_5_code, i.geo_6_code AS i__geo_6_code, i.homepage AS i__homepage, i.bol_kontakt_show AS i__bol_kontakt_show, i.vorname AS i__vorname, i.nachname AS i__nachname, i.firma AS i__firma, i.adresse AS i__adresse, i.plz AS i__plz, i.ort AS i__ort, i.k_land AS i__k_land, i.tel AS i__tel, i.mobil AS i__mobil, i.email AS i__email, i.weitere_infos AS i__weitere_infos, i.referenz_nr AS i__referenz_nr, i.bol_opp_digests AS i__bol_opp_digests, i.bol_data_feeds AS i__bol_data_feeds, i.bol_freigabe_user AS i__bol_freigabe_user, i.freigabe_user_datum AS i__freigabe_user_datum, i.sperren_dealgate_datum AS i__sperren_dealgate_datum, i.ablauf_datum AS i__ablauf_datum, i.bol_aktiv AS i__bol_aktiv, i.anzeige_ab_datum AS i__anzeige_ab_datum, i.anzeige_bis_datum AS i__anzeige_bis_datum, i.bol_geloescht AS i__bol_geloescht, i.geloescht_am AS i__geloescht_am, i.aktiv_datum AS i__aktiv_datum, i.member_reference AS i__member_reference, i.created_at AS i__created_at, i.updated_at AS i__updated_at, i3.code AS i3__code, i4.code AS i4__code, i4.lang AS i4__lang, i4.branche AS i4__0, i5.code AS i5__code, i6.code AS i6__code, i6.lang AS i6__lang, i6.branche AS i6__1, i7.code AS i7__code, i8.code AS i8__code, i8.lang AS i8__lang, i8.branche AS i8__2, i9.code AS i9__code, i10.code AS i10__code, i10.lang AS i10__lang, i10.branche AS i10__3, i11.code AS i11__code, i12.code AS i12__code, i12.lang AS i12__lang, i12.branche AS i12__4, i13.code AS i13__code, i14.code AS i14__code, i14.lang AS i14__lang, i14.branche AS i14__5, i15.code AS i15__code, i16.code AS i16__code, i16.lang AS i16__lang, i16.geo AS i16__6, i17.code AS i17__code, i18.code AS i18__code, i18.lang AS i18__lang, i18.geo AS i18__7, i19.code AS i19__code, i20.code AS i20__code, i20.lang AS i20__lang, i20.geo AS i20__8, i21.code AS i21__code, i22.code AS i22__code, i22.lang AS i22__lang, i22.geo AS i22__9, i23.code AS i23__code, i24.code AS i24__code, i24.lang AS i24__lang, i24.geo AS i24__10, i25.code AS i25__code, i26.code AS i26__code, i26.lang AS i26__lang, i26.geo AS i26__11, i4.branche AS i4__0, i6.branche AS i6__1, i8.branche AS i8__2, i10.branche AS i10__3, i12.branche AS i12__4, i14.branche AS i14__5, i16.geo AS i16__6, i18.geo AS i18__7, i20.geo AS i20__8, i22.geo AS i22__9, i24.geo AS i24__10, i26.geo AS i26__11 FROM i__inserat i LEFT JOIN i__inserat_x_mitgliedsgruppe i2 ON i.id = i2.inserat_id LEFT JOIN sf_guard_user s ON i.user_id = s.id LEFT JOIN i__branche i3 ON i.branche_1_code = i3.code LEFT JOIN i__branche_translation i4 ON i3.code = i4.code LEFT JOIN i__branche i5 ON i.branche_2_code = i5.code LEFT JOIN i__branche_translation i6 ON i5.code = i6.code LEFT JOIN i__branche i7 ON i.branche_3_code = i7.code LEFT JOIN i__branche_translation i8 ON i7.code = i8.code LEFT JOIN i__branche i9 ON i.branche_4_code = i9.code LEFT JOIN i__branche_translation i10 ON i9.code = i10.code LEFT JOIN i__branche i11 ON i.branche_5_code = i11.code LEFT JOIN i__branche_translation i12 ON i11.code = i12.code LEFT JOIN i__branche i13 ON i.branche_6_code = i13.code LEFT JOIN i__branche_translation i14 ON i13.code = i14.code LEFT JOIN i__geo i15 ON i.geo_1_code = i15.code LEFT JOIN i__geo_translation i16 ON i15.code = i16.code LEFT JOIN i__geo i17 ON i.geo_2_code = i17.code LEFT JOIN i__geo_translation i18 ON i17.code = i18.code LEFT JOIN i__geo i19 ON i.geo_3_code = i19.code LEFT JOIN i__geo_translation i20 ON i19.code = i20.code LEFT JOIN i__geo i21 ON i.geo_4_code = i21.code LEFT JOIN i__geo_translation i22 ON i21.code = i22.code LEFT JOIN i__geo i23 ON i.geo_5_code = i23.code LEFT JOIN i__geo_translation i24 ON i23.code = i24.code LEFT JOIN i__geo i25 ON i.geo_6_code = i25.code LEFT JOIN i__geo_translation i26 ON i25.code = i26.code WHERE (i.bol_aktiv = ? AND i.bol_geloescht = ? AND i.art_id = ? AND s.is_active = ? AND i4.lang = ? AND (i6.lang = ? OR i6.lang IS NULL) AND (i8.lang = ? OR i8.lang IS NULL) AND (i10.lang = ? OR i10.lang IS NULL) AND (i12.lang = ? OR i12.lang IS NULL) AND (i14.lang = ? OR i14.lang IS NULL) AND i16.lang = ? AND (i18.lang = ? OR i18.lang IS NULL) AND (i20.lang = ? OR i20.lang IS NULL) AND (i22.lang = ? OR i22.lang IS NULL) AND (i24.lang = ? OR i24.lang IS NULL) AND (i26.lang = ? OR i26.lang IS NULL)) ORDER BY i.created_at DESC - (1, 0, 2, 1, en, en, en, en, en, en, en, en, en, en, en, en) |
| 25 | sfPartialView | Render "sf_app_dir/modules/opportunities/templates/_opportunities_list.php" |
| 26 | Doctrine_Connection_Statement | execute : SELECT DISTINCT i.id AS i__id, i.user_id AS i__user_id, i.creator_id AS i__creator_id, i.mitglied_id AS i__mitglied_id, i.art_id AS i__art_id, i.ip_adresse AS i__ip_adresse, i.bol_counted AS i__bol_counted, i.bol_tokened AS i__bol_tokened, i.reward_date AS i__reward_date, i.last_infomail_send_date AS i__last_infomail_send_date, i.titel AS i__titel, i.branche_1_code AS i__branche_1_code, i.branche_2_code AS i__branche_2_code, i.branche_3_code AS i__branche_3_code, i.branche_4_code AS i__branche_4_code, i.branche_5_code AS i__branche_5_code, i.branche_6_code AS i__branche_6_code, i.currency_id AS i__currency_id, i.dateiname_pdf_1 AS i__dateiname_pdf_1, i.dateiname_pdf_2 AS i__dateiname_pdf_2, i.dateiname_pdf_3 AS i__dateiname_pdf_3, i.kurzbeschrieb AS i__kurzbeschrieb, i.anz_mitarbeiter_id AS i__anz_mitarbeiter_id, i.umsatzkategorie_id AS i__umsatzkategorie_id, i.ebitda_id AS i__ebitda_id, i.beteiligungs_art_id AS i__beteiligungs_art_id, i.beteiligung_id AS i__beteiligung_id, i.geo_1_code AS i__geo_1_code, i.geo_2_code AS i__geo_2_code, i.geo_3_code AS i__geo_3_code, i.geo_4_code AS i__geo_4_code, i.geo_5_code AS i__geo_5_code, i.geo_6_code AS i__geo_6_code, i.homepage AS i__homepage, i.bol_kontakt_show AS i__bol_kontakt_show, i.vorname AS i__vorname, i.nachname AS i__nachname, i.firma AS i__firma, i.adresse AS i__adresse, i.plz AS i__plz, i.ort AS i__ort, i.k_land AS i__k_land, i.tel AS i__tel, i.mobil AS i__mobil, i.email AS i__email, i.weitere_infos AS i__weitere_infos, i.referenz_nr AS i__referenz_nr, i.bol_opp_digests AS i__bol_opp_digests, i.bol_data_feeds AS i__bol_data_feeds, i.bol_freigabe_user AS i__bol_freigabe_user, i.freigabe_user_datum AS i__freigabe_user_datum, i.sperren_dealgate_datum AS i__sperren_dealgate_datum, i.ablauf_datum AS i__ablauf_datum, i.bol_aktiv AS i__bol_aktiv, i.anzeige_ab_datum AS i__anzeige_ab_datum, i.anzeige_bis_datum AS i__anzeige_bis_datum, i.bol_geloescht AS i__bol_geloescht, i.geloescht_am AS i__geloescht_am, i.aktiv_datum AS i__aktiv_datum, i.member_reference AS i__member_reference, i.created_at AS i__created_at, i.updated_at AS i__updated_at, i3.code AS i3__code, i4.code AS i4__code, i4.lang AS i4__lang, i4.branche AS i4__0, i5.code AS i5__code, i6.code AS i6__code, i6.lang AS i6__lang, i6.branche AS i6__1, i7.code AS i7__code, i8.code AS i8__code, i8.lang AS i8__lang, i8.branche AS i8__2, i9.code AS i9__code, i10.code AS i10__code, i10.lang AS i10__lang, i10.branche AS i10__3, i11.code AS i11__code, i12.code AS i12__code, i12.lang AS i12__lang, i12.branche AS i12__4, i13.code AS i13__code, i14.code AS i14__code, i14.lang AS i14__lang, i14.branche AS i14__5, i15.code AS i15__code, i16.code AS i16__code, i16.lang AS i16__lang, i16.geo AS i16__6, i17.code AS i17__code, i18.code AS i18__code, i18.lang AS i18__lang, i18.geo AS i18__7, i19.code AS i19__code, i20.code AS i20__code, i20.lang AS i20__lang, i20.geo AS i20__8, i21.code AS i21__code, i22.code AS i22__code, i22.lang AS i22__lang, i22.geo AS i22__9, i23.code AS i23__code, i24.code AS i24__code, i24.lang AS i24__lang, i24.geo AS i24__10, i25.code AS i25__code, i26.code AS i26__code, i26.lang AS i26__lang, i26.geo AS i26__11, i4.branche AS i4__0, i6.branche AS i6__1, i8.branche AS i8__2, i10.branche AS i10__3, i12.branche AS i12__4, i14.branche AS i14__5, i16.geo AS i16__6, i18.geo AS i18__7, i20.geo AS i20__8, i22.geo AS i22__9, i24.geo AS i24__10, i26.geo AS i26__11 FROM i__inserat i LEFT JOIN i__inserat_x_mitgliedsgruppe i2 ON i.id = i2.inserat_id LEFT JOIN sf_guard_user s ON i.user_id = s.id LEFT JOIN i__branche i3 ON i.branche_1_code = i3.code LEFT JOIN i__branche_translation i4 ON i3.code = i4.code LEFT JOIN i__branche i5 ON i.branche_2_code = i5.code LEFT JOIN i__branche_translation i6 ON i5.code = i6.code LEFT JOIN i__branche i7 ON i.branche_3_code = i7.code LEFT JOIN i__branche_translation i8 ON i7.code = i8.code LEFT JOIN i__branche i9 ON i.branche_4_code = i9.code LEFT JOIN i__branche_translation i10 ON i9.code = i10.code LEFT JOIN i__branche i11 ON i.branche_5_code = i11.code LEFT JOIN i__branche_translation i12 ON i11.code = i12.code LEFT JOIN i__branche i13 ON i.branche_6_code = i13.code LEFT JOIN i__branche_translation i14 ON i13.code = i14.code LEFT JOIN i__geo i15 ON i.geo_1_code = i15.code LEFT JOIN i__geo_translation i16 ON i15.code = i16.code LEFT JOIN i__geo i17 ON i.geo_2_code = i17.code LEFT JOIN i__geo_translation i18 ON i17.code = i18.code LEFT JOIN i__geo i19 ON i.geo_3_code = i19.code LEFT JOIN i__geo_translation i20 ON i19.code = i20.code LEFT JOIN i__geo i21 ON i.geo_4_code = i21.code LEFT JOIN i__geo_translation i22 ON i21.code = i22.code LEFT JOIN i__geo i23 ON i.geo_5_code = i23.code LEFT JOIN i__geo_translation i24 ON i23.code = i24.code LEFT JOIN i__geo i25 ON i.geo_6_code = i25.code LEFT JOIN i__geo_translation i26 ON i25.code = i26.code WHERE (i.bol_aktiv = ? AND i.bol_geloescht = ? AND i.art_id = ? AND s.is_active = ? AND i4.lang = ? AND (i6.lang = ? OR i6.lang IS NULL) AND (i8.lang = ? OR i8.lang IS NULL) AND (i10.lang = ? OR i10.lang IS NULL) AND (i12.lang = ? OR i12.lang IS NULL) AND (i14.lang = ? OR i14.lang IS NULL) AND i16.lang = ? AND (i18.lang = ? OR i18.lang IS NULL) AND (i20.lang = ? OR i20.lang IS NULL) AND (i22.lang = ? OR i22.lang IS NULL) AND (i24.lang = ? OR i24.lang IS NULL) AND (i26.lang = ? OR i26.lang IS NULL)) ORDER BY i.created_at DESC - (1, 0, 3, 1, en, en, en, en, en, en, en, en, en, en, en, en) |
| 27 | sfPartialView | Render "sf_app_dir/modules/opportunities/templates/_opportunities_list.php" |
| 28 | sfPartialView | Render "sf_app_dir/modules/opportunities/templates/_render_graph.php" |
| 29 | sfPHPView | Decorate content with "sf_app_dir/templates/layout.php" |
| 30 | sfPHPView | Render "sf_app_dir/templates/layout.php" |
| 31 | main | Call "_navigation->executeNavigation_top()" |
| 32 | sfPartialView | Render "sf_app_dir/modules/_navigation/templates/_navigation_top.php" |
| 33 | main | Call "_navigation->executeNavigation_main()" |
| 34 | sfPartialView | Render "sf_app_dir/modules/_navigation/templates/_navigation_main.php" |
| 35 | sfPartialView | Render "sf_app_dir/modules/__login/templates/_form_signin.php" |
| 36 | sfPartialView | Render "sf_app_dir/modules/__login/templates/_form_signin_body.php" |
| 37 | sfPartialView | Render "sf_app_dir/modules/default/templates/_footer.php" |
| 38 | Doctrine_Connection_Statement | execute : SELECT a.id AS a__id, a.dateiname AS a__dateiname FROM a__a_g_b_verwaltung a WHERE (ISNULL(gueltig_bis) OR a.gueltig_bis > ?) - (2024-04-19) |
| 39 | main | Call "_navigation->executeNavigation_footer()" |
| 40 | sfPartialView | Render "sf_app_dir/modules/_navigation/templates/_navigation_footer.php" |
| 41 | main | Call "_navigation->executeNavigation_footer_account()" |
| 42 | sfPartialView | Render "sf_app_dir/modules/_navigation/templates/_navigation_footer_account.php" |
| 43 | sfWebResponse | Send status "HTTP/1.1 200 OK" |
| 44 | sfWebResponse | Send header "Content-Type: text/html; charset=utf-8" |
config
view
logs
37376.0 KB
2658 ms
13
