Jedes Jahr tragen Tierarzneimittel zu Gesundheit und Wohlbefinden von Millionen Tieren auf der ganzen Welt bei. Als eines der führenden Tiergesundheitsunternehmen in über 90 Ländern widmen wir uns seit 1954 mit Hingabe der Entwicklung innovativer Produkte und Dienstleistungen.
Unsere Mission: die Lebensqualität von Haus- und Nutztieren durch fortschrittliche Therapien und Präventionsmaßnahmen zu verbessern.
Unser Kieler Standort produziert seit mehr als 40 Jahren Arzneimittel für Haus- und Nutztiere. Mit über 900 Mitarbeitern gehören wir zu den größten Industrieunternehmen der Landeshauptstadt. Unsere Produkte werden von Tierärztinnen und Tierärzte in Deutschland ebenso eingesetzt wie von Wildhütern in Südafrika, von Schäfern in Neuseeland, Imkern in Frankreich oder Veterinären in China.
Hi, ich bin Christian Boehmer, Head of HR DACH Commercial bei Elanco. Ich freue mich auf deine Kontaktaufnahme!
Bei Elanco fördern wir eine Kultur des Einbezugs und der Nachhaltigkeit, in der jede/r Mitarbeitende/r durch Eigenverantwortung, persönliches Wachstum und Wohlbefinden einen Unterschied machen kann.
Wir pflegen eine inklusive, zweckorientierte Kultur, die auf den Grundwerten von Elanco basiert.
Wir agieren als "Ein Elanco", durch Engagement für herausragende Leistungen und die Verantwortung für unsere Entscheidungen schaffen wir stets positive Ergebnisse für unsere Kundinnen und Kunden und ermutigen sie, unsere Vision "Food and Companionship Enriching Life" zu teilen.
Wir bei Elanco setzen uns für eine integrative Kultur ein, in der Du etwas bewegen kannst, indem wir Eingenverantwortung, Entwicklung und Wohlbefinden fördern.
Unsere Leistungspakete helfen uns dabei, die großen Talente in der Branche zu halten und zu gewinnen.
Unsere Gesamtvergütungspakete umfassen umfangreiche Sozialleistungen.
Wir fördern Ihren Erfolg und bieten Ihnen die Schulungen, die Sie benötigen, um dorthin zu gelangen, wo Sie sein möchten.
Beteiligen Sie sich an unseren Programmen und Initiativen für das Gemeinwohl.
Unsere Kultur ist eine Kultur, die die Fürsorge füreinander und die Einbeziehung fördert.
Teilen Sie unsere Vision „Food and Companionship Enriching Life“, indem Sie für unsere Gesellschaft etwas bewegen.
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| 17 | |
| 18 | |
| 19 | |
| 20 | |
| 21 | |
| 22 | |
| 23 | |
| 24 | |
| 25 | |
| 26 | |
| 27 | |
| 28 | |
| 29 | |
| 30 | |
| 31 | |
| 32 | |
| 33 | |
| 34 | |
| 35 | |
| 36 | |
| 37 | |
| 38 | |
| 39 | |
| 40 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| 17 | |
| 18 | |
| 19 | |
| 20 | |
| 21 | |
| 22 | |
| 23 | |
| 24 | |
| 25 | |
| 26 | |
| 27 | |
| 28 | |
| 29 | |
| 30 | |
| 31 | |
| 32 | |
| 33 | |
| 34 | |
| 35 | |
| 36 | |
| 37 | |
| 38 | |
| 39 | |
| 40 | |
| 41 | |
| 42 | |
| 43 | |
| 44 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| 17 | |
| 18 | |
| 19 | |
| 20 | |
| 21 | |
| 22 | |
| 23 | |
| 24 | |
| 25 | |
| 26 | |
| 27 | |
| 28 | |
| 29 | |
| 30 | |
| 31 | |
| 32 | |
| 33 | |
| 34 | |
| 35 | |
| 36 | |
| 37 | |
| 38 | |
| 39 | |
| 40 | |
| 41 | |
| 42 | |
| 43 | |
| 44 | |
| 45 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| 17 | |
| 18 | |
| 19 | |
| 20 | |
| 21 | |
| 22 | |
| 23 | |
| 24 | |
| 25 | |
| 26 | |
| 27 | |
| 28 | |
| 29 | |
| 30 | |
| 31 | |
| 32 | |
| 33 | |
| 34 | |
| 35 | |
| 36 | |
| 37 | |
| 38 | |
| 39 | |
| 40 | |
| 41 | |
| 42 | |
| 43 | |
| 44 | |
| 45 | |
| 46 | |
| 47 | |
| 48 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| 17 | |
| 18 | |
| 19 | |
| 20 | |
| 21 | |
| 22 | |
| 23 | |
| 24 | |
| 25 | |
| 26 | |
| 27 | |
| 28 | |
| 29 | |
| 30 | |
| 31 | |
| 32 | |
| 33 | |
| 34 | |
| 35 | |
| 36 | |
| 37 | |
| 38 | |
| 39 | |
| 40 | |
| 41 | |
| 42 | |
| 43 | |
| 44 | |
| 45 | |
| 46 | |
| 47 | |
| 48 | |
| 49 | |
| 50 | |
| 51 | |
| 52 | |
| 53 | |
| 54 | |
| 55 | |
| 56 | |
| 57 | |
| 58 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| 17 | |
| 18 | |
| 19 | |
| 20 | |
| 21 | |
| 22 | |
| 23 | |
| 24 | |
| 25 | |
| 26 | |
| 27 | |
| 28 | |
| 29 | |
| 30 | |
| 31 | |
| 32 | |
| 33 | |
| 34 | |
| 35 | |
| 36 | |
| 37 | |
| 38 | |
| 39 | |
| 40 | |
| 41 | |
| 42 | |
| 43 | |
| 44 | |
| 45 | |
| 46 | |
| 47 | |
| 48 | |
| 49 | |
| 50 | |
| 51 | |
| 52 | |
| 53 | |
| 54 | |
| 55 | |
| 56 | |
| 57 | |
| 58 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| 17 | |
| 18 | |
| 19 | |
| 20 | |
| 21 | |
| 22 | |
| 23 | |
| 24 | |
| 25 | |
| 26 | |
| 27 | |
| 28 | |
| 29 | |
| 30 | |
| 31 | |
| 32 | |
| 33 | |
| 34 | |
| 35 | |
| 36 | |
| 37 | |
| 38 | |
| 39 | |
| 40 | |
| 41 | |
| 42 | |
| 43 | |
| 44 | |
| 45 | |
| 46 | |
| 47 | |
| 48 | |
| 49 | |
| 50 | |
| 51 | |
| 52 | |
| 53 | |
| 54 | |
| 55 | |
| 56 | |
| 57 | |
| 58 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| 17 | |
| 18 | |
| 19 | |
| 20 | |
| 21 | |
| 22 | |
| 23 | |
| 24 | |
| 25 | |
| 26 | |
| 27 | |
| 28 | |
| 29 | |
| 30 | |
| 31 | |
| 32 | |
| 33 | |
| 34 | |
| 35 | |
| 36 | |
| 37 | |
| 38 | |
| 39 | |
| 40 | |
| 41 | |
| 42 | |
| 43 | |
| 44 | |
| 45 | |
| 46 | |
| 47 | |
| 48 | |
| 49 | |
| 50 | |
| 51 | |
| 52 | |
| 53 | |
| 54 | |
| 55 | |
| 56 | |
| 57 | |
| 58 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| 17 | |
| 18 | |
| 19 | |
| 20 | |
| 21 | |
| 22 | |
| 23 | |
| 24 | |
| 25 | |
| 26 | |
| 27 | |
| 28 | |
| 29 | |
| 30 | |
| 31 | |
| 32 | |
| 33 | |
| 34 | |
| 35 | |
| 36 | |
| 37 | |
| 38 | |
| 39 | |
| 40 | |
| 41 | |
| 42 | |
| 43 | |
| 44 | |
| 45 | |
| 46 | |
| 47 | |
| 48 | |
| 49 | |
| 50 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| 17 | |
| 18 | |
| 19 | |
| 20 | |
| 21 | |
| 22 | |
| 23 | |
| 24 | |
| 25 | |
| 26 | |
| 27 | |
| 28 | |
| 29 | |
| 30 | |
| 31 | |
| 32 | |
| 33 | |
| 34 | |
| 35 | |
| 36 | |
| 37 | |
| 38 | |
| 39 | |
| 40 | |
| 41 | |
| 42 | |
| 43 | |
| 44 | |
| 45 | |
| 46 | |
| 47 | |
| 48 | |
| 49 | |
| 50 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| 17 | |
| 18 | |
| 19 | |
| 20 | |
| 21 | |
| 22 | |
| 23 | |
| 24 | |
| 25 | |
| 26 | |
| 27 | |
| 28 | |
| 29 | |
| 30 | |
| 31 | |
| 32 | |
| 33 | |
| 34 | |
| 35 | |
| 36 | |
| 37 | |
| 38 | |
| 39 | |
| 40 | |
| 41 | |
| 42 | |
| 43 | |
| 44 | |
| 45 | |
| 46 | |
| 47 | |
| 48 | |
| 49 | |
| 50 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| 17 | |
| 18 | |
| 19 | |
| 20 | |
| 21 | |
| 22 | |
| 23 | |
| 24 | |
| 25 | |
| 26 | |
| 27 | |
| 28 | |
| 29 | |
| 30 | |
| 31 | |
| 32 | |
| 33 | |
| 34 | |
| 35 | |
| 36 | |
| 37 | |
| 38 | |
| 39 | |
| 40 | |
| 41 | |
| 42 | |
| 43 | |
| 44 | |
| 45 | |
| 46 | |
| 47 | |
| 48 | |
| 49 | |
| 50 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| 17 | |
| 18 | |
| 19 | |
| 20 | |
| 21 | |
| 22 | |
| 23 | |
| 24 | |
| 25 | |
| 26 | |
| 27 | |
| 28 | |
| 29 | |
| 30 | |
| 31 | |
| 32 | |
| 33 | |
| 34 | |
| 35 | |
| 36 | |
| 37 | |
| 38 | |
| 39 | |
| 40 | |
| 41 | |
| 42 | |
| 43 | |
| 44 | |
| 45 | |
| 46 | |
| 47 | |
| 48 | |
| 49 | |
| 50 | |
| 51 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| 17 | |
| 18 | |
| 19 | |
| 20 | |
| 21 | |
| 22 | |
| 23 | |
| 24 | |
| 25 | |
| 26 | |
| 27 | |
| 28 | |
| 29 | |
| 30 | |
| 31 | |
| 32 | |
| 33 | |
| 34 | |
| 35 | |
| 36 | |
| 37 | |
| 38 | |
| 39 | |
| 40 | |
| 41 | |
| 42 | |
| 43 | |
| 44 | |
| 45 | |
| 46 | |
| 47 | |
| 48 | |
| 49 | |
| 50 | |
| 51 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| 17 | |
| 18 | |
| 19 | |
| 20 | |
| 21 | |
| 22 | |
| 23 | |
| 24 | |
| 25 | |
| 26 | |
| 27 | |
| 28 | |
| 29 | |
| 30 | |
| 31 | |
| 32 | |
| 33 | |
| 34 | |
| 35 | |
| 36 | |
| 37 | |
| 38 | |
| 39 | |
| 40 | |
| 41 | |
| 42 | |
| 43 | |
| 44 | |
| 45 | |
| 46 | |
| 47 | |
| 48 | |
| 49 | |
| 50 | |
| 51 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| 17 | |
| 18 | |
| 19 | |
| 20 | |
| 21 | |
| 22 | |
| 23 | |
| 24 | |
| 25 | |
| 26 | |
| 27 | |
| 28 | |
| 29 | |
| 30 | |
| 31 | |
| 32 | |
| 33 | |
| 34 | |
| 35 | |
| 36 | |
| 37 | |
| 38 | |
| 39 | |
| 40 | |
| 41 | |
| 42 | |
| 43 | |
| 44 | |
| 45 | |
| 46 | |
| 47 | |
| 48 | |
| 49 | |
| 50 | |
| 51 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| 17 | |
| 18 | |
| 19 | |
| 20 | |
| 21 | |
| 22 | |
| 23 | |
| 24 | |
| 25 | |
| 26 | |
| 27 | |
| 28 | |
| 29 | |
| 30 | |
| 31 | |
| 32 | |
| 33 | |
| 34 | |
| 35 | |
| 36 | |
| 37 | |
| 38 | |
| 39 | |
| 40 | |
| 41 | |
| 42 | |
| 43 | |
| 44 | |
| 45 | |
| 46 | |
| 47 | |
| 48 | |
| 49 | |
| 50 | |
| 51 | |
| 52 | |
| 53 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| 17 | |
| 18 | |
| 19 | |
| 20 | |
| 21 | |
| 22 | |
| 23 | |
| 24 | |
| 25 | |
| 26 | |
| 27 | |
| 28 | |
| 29 | |
| 30 | |
| 31 | |
| 32 | |
| 33 | |
| 34 | |
| 35 | |
| 36 | |
| 37 | |
| 38 | |
| 39 | |
| 40 | |
| 41 | |
| 42 | |
| 43 | |
| 44 | |
| 45 | |
| 46 | |
| 47 | |
| 48 | |
| 49 | |
| 50 | |
| 51 | |
| 52 | |
| 53 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| 17 | |
| 18 | |
| 19 | |
| 20 | |
| 21 | |
| 22 | |
| 23 | |
| 24 | |
| 25 | |
| 26 | |
| 27 | |
| 28 | |
| 29 | |
| 30 | |
| 31 | |
| 32 | |
| 33 | |
| 34 | |
| 35 | |
| 36 | |
| 37 | |
| 38 | |
| 39 | |
| 40 | |
| 41 | |
| 42 | |
| 43 | |
| 44 | |
| 45 | |
| 46 | |
| 47 | |
| 48 | |
| 49 | |
| 50 | |
| 51 | |
| 52 | |
| 53 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| 17 | |
| 18 | |
| 19 | |
| 20 | |
| 21 | |
| 22 | |
| 23 | |
| 24 | |
| 25 | |
| 26 | |
| 27 | |
| 28 | |
| 29 | |
| 30 | |
| 31 | |
| 32 | |
| 33 | |
| 34 | |
| 35 | |
| 36 | |
| 37 | |
| 38 | |
| 39 | |
| 40 | |
| 41 | |
| 42 | |
| 43 | |
| 44 | |
| 45 | |
| 46 | |
| 47 | |
| 48 | |
| 49 | |
| 50 | |
| 51 | |
| 52 | |
| 53 | |
| 54 | |
| 55 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| 17 | |
| 18 | |
| 19 | |
| 20 | |
| 21 | |
| 22 | |
| 23 | |
| 24 | |
| 25 | |
| 26 | |
| 27 | |
| 28 | |
| 29 | |
| 30 | |
| 31 | |
| 32 | |
| 33 | |
| 34 | |
| 35 | |
| 36 | |
| 37 | |
| 38 | |
| 39 | |
| 40 | |
| 41 | |
| 42 | |
| 43 | |
| 44 | |
| 45 | |
| 46 | |
| 47 | |
| 48 | |
| 49 | |
| 50 | |
| 51 | |
| 52 | |
| 53 | |
| 54 | |
| 55 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| 17 | |
| 18 | |
| 19 | |
| 20 | |
| 21 | |
| 22 | |
| 23 | |
| 24 | |
| 25 | |
| 26 | |
| 27 | |
| 28 | |
| 29 | |
| 30 | |
| 31 | |
| 32 | |
| 33 | |
| 34 | |
| 35 | |
| 36 | |
| 37 | |
| 38 | |
| 39 | |
| 40 | |
| 41 | |
| 42 | |
| 43 | |
| 44 | |
| 45 | |
| 46 | |
| 47 | |
| 48 | |
| 49 | |
| 50 | |
| 51 | |
| 52 | |
| 53 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| 17 | |
| 18 | |
| 19 | |
| 20 | |
| 21 | |
| 22 | |
| 23 | |
| 24 | |
| 25 | |
| 26 | |
| 27 | |
| 28 | |
| 29 | |
| 30 | |
| 31 | |
| 32 | |
| 33 | |
| 34 | |
| 35 | |
| 36 | |
| 37 | |
| 38 | |
| 39 | |
| 40 | |
| 41 | |
| 42 | |
| 43 | |
| 44 | |
| 45 | |
| 46 | |
| 47 | |
| 48 | |
| 49 | |
| 50 | |
| 51 | |
| 52 | |
| 53 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| 17 | |
| 18 | |
| 19 | |
| 20 | |
| 21 | |
| 22 | |
| 23 | |
| 24 | |
| 25 | |
| 26 | |
| 27 | |
| 28 | |
| 29 | |
| 30 | |
| 31 | |
| 32 | |
| 33 | |
| 34 | |
| 35 | |
| 36 | |
| 37 | |
| 38 | |
| 39 | |
| 40 | |
| 41 | |
| 42 | |
| 43 | |
| 44 | |
| 45 | |
| 46 | |
| 47 | |
| 48 | |
| 49 | |
| 50 | |
| 51 | |
| 52 | |
| 53 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| 17 | |
| 18 | |
| 19 | |
| 20 | |
| 21 | |
| 22 | |
| 23 | |
| 24 | |
| 25 | |
| 26 | |
| 27 | |
| 28 | |
| 29 | |
| 30 | |
| 31 | |
| 32 | |
| 33 | |
| 34 | |
| 35 | |
| 36 | |
| 37 | |
| 38 | |
| 39 | |
| 40 | |
| 41 | |
| 42 | |
| 43 | |
| 44 | |
| 45 | |
| 46 | |
| 47 | |
| 48 | |
| 49 | |
| 50 | |
| 51 | |
| 52 | |
| 53 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| 17 | |
| 18 | |
| 19 | |
| 20 | |
| 21 | |
| 22 | |
| 23 | |
| 24 | |
| 25 | |
| 26 | |
| 27 | |
| 28 | |
| 29 | |
| 30 | |
| 31 | |
| 32 | |
| 33 | |
| 34 | |
| 35 | |
| 36 | |
| 37 | |
| 38 | |
| 39 | |
| 40 | |
| 41 | |
| 42 | |
| 43 | |
| 44 | |
| 45 | |
| 46 | |
| 47 | |
| 48 | |
| 49 | |
| 50 | |
| 51 | |
| 52 | |
| 53 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| 17 | |
| 18 | |
| 19 | |
| 20 | |
| 21 | |
| 22 | |
| 23 | |
| 24 | |
| 25 | |
| 26 | |
| 27 | |
| 28 | |
| 29 | |
| 30 | |
| 31 | |
| 32 | |
| 33 | |
| 34 | |
| 35 | |
| 36 | |
| 37 | |
| 38 | |
| 39 | |
| 40 | |
| 41 | |
| 42 | |
| 43 | |
| 44 | |
| 45 | |
| 46 | |
| 47 | |
| 48 | |
| 49 | |
| 50 | |
| 51 | |
| 52 | |
| 53 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| 17 | |
| 18 | |
| 19 | |
| 20 | |
| 21 | |
| 22 | |
| 23 | |
| 24 | |
| 25 | |
| 26 | |
| 27 | |
| 28 | |
| 29 | |
| 30 | |
| 31 | |
| 32 | |
| 33 | |
| 34 | |
| 35 | |
| 36 | |
| 37 | |
| 38 | |
| 39 | |
| 40 | |
| 41 | |
| 42 | |
| 43 | |
| 44 | |
| 45 | |
| 46 | |
| 47 | |
| 48 | |
| 49 | |
| 50 | |
| 51 | |
| 52 | |
| 53 | |
| 54 | |
| 55 | |
| 56 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| 17 | |
| 18 | |
| 19 | |
| 20 | |
| 21 | |
| 22 | |
| 23 | |
| 24 | |
| 25 | |
| 26 | |
| 27 | |
| 28 | |
| 29 | |
| 30 | |
| 31 | |
| 32 | |
| 33 | |
| 34 | |
| 35 | |
| 36 | |
| 37 | |
| 38 | |
| 39 | |
| 40 | |
| 41 | |
| 42 | |
| 43 | |
| 44 | |
| 45 | |
| 46 | |
| 47 | |
| 48 | |
| 49 | |
| 50 | |
| 51 | |
| 52 | |
| 53 | |
| 54 | |
| 55 | |
| 56 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| 17 | |
| 18 | |
| 19 | |
| 20 | |
| 21 | |
| 22 | |
| 23 | |
| 24 | |
| 25 | |
| 26 | |
| 27 | |
| 28 | |
| 29 | |
| 30 | |
| 31 | |
| 32 | |
| 33 | |
| 34 | |
| 35 | |
| 36 | |
| 37 | |
| 38 | |
| 39 | |
| 40 | |
| 41 | |
| 42 | |
| 43 | |
| 44 | |
| 45 | |
| 46 | |
| 47 | |
| 48 | |
| 49 | |
| 50 | |
| 51 | |
| 52 | |
| 53 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| 17 | |
| 18 | |
| 19 | |
| 20 | |
| 21 | |
| 22 | |
| 23 | |
| 24 | |
| 25 | |
| 26 | |
| 27 | |
| 28 | |
| 29 | |
| 30 | |
| 31 | |
| 32 | |
| 33 | |
| 34 | |
| 35 | |
| 36 | |
| 37 | |
| 38 | |
| 39 | |
| 40 | |
| 41 | |
| 42 | |
| 43 | |
| 44 | |
| 45 | |
| 46 | |
| 47 | |
| 48 | |
| 49 | |
| 50 | |
| 51 | |
| 52 | |
| 53 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| 17 | |
| 18 | |
| 19 | |
| 20 | |
| 21 | |
| 22 | |
| 23 | |
| 24 | |
| 25 | |
| 26 | |
| 27 | |
| 28 | |
| 29 | |
| 30 | |
| 31 | |
| 32 | |
| 33 | |
| 34 | |
| 35 | |
| 36 | |
| 37 | |
| 38 | |
| 39 | |
| 40 | |
| 41 | |
| 42 | |
| 43 | |
| 44 | |
| 45 | |
| 46 | |
| 47 | |
| 48 | |
| 49 | |
| 50 | |
| 51 | |
| 52 | |
| 53 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| 17 | |
| 18 | |
| 19 | |
| 20 | |
| 21 | |
| 22 | |
| 23 | |
| 24 | |
| 25 | |
| 26 | |
| 27 | |
| 28 | |
| 29 | |
| 30 | |
| 31 | |
| 32 | |
| 33 | |
| 34 | |
| 35 | |
| 36 | |
| 37 | |
| 38 | |
| 39 | |
| 40 | |
| 41 | |
| 42 | |
| 43 | |
| 44 | |
| 45 | |
| 46 | |
| 47 | |
| 48 | |
| 49 | |
| 50 | |
| 51 | |
| 52 | |
| 53 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| 17 | |
| 18 | |
| 19 | |
| 20 | |
| 21 | |
| 22 | |
| 23 | |
| 24 | |
| 25 | |
| 26 | |
| 27 | |
| 28 | |
| 29 | |
| 30 | |
| 31 | |
| 32 | |
| 33 | |
| 34 | |
| 35 | |
| 36 | |
| 37 | |
| 38 | |
| 39 | |
| 40 | |
| 41 | |
| 42 | |
| 43 | |
| 44 | |
| 45 | |
| 46 | |
| 47 | |
| 48 | |
| 49 | |
| 50 | |
| 51 | |
| 52 | |
| 53 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| 17 | |
| 18 | |
| 19 | |
| 20 | |
| 21 | |
| 22 | |
| 23 | |
| 24 | |
| 25 | |
| 26 | |
| 27 | |
| 28 | |
| 29 | |
| 30 | |
| 31 | |
| 32 | |
| 33 | |
| 34 | |
| 35 | |
| 36 | |
| 37 | |
| 38 | |
| 39 | |
| 40 | |
| 41 | |
| 42 | |
| 43 | |
| 44 | |
| 45 | |
| 46 | |
| 47 | |
| 48 | |
| 49 | |
| 50 | |
| 51 | |
| 52 | |
| 53 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| 17 | |
| 18 | |
| 19 | |
| 20 | |
| 21 | |
| 22 | |
| 23 | |
| 24 | |
| 25 | |
| 26 | |
| 27 | |
| 28 | |
| 29 | |
| 30 | |
| 31 | |
| 32 | |
| 33 | |
| 34 | |
| 35 | |
| 36 | |
| 37 | |
| 38 | |
| 39 | |
| 40 | |
| 41 | |
| 42 | |
| 43 | |
| 44 | |
| 45 | |
| 46 | |
| 47 | |
| 48 | |
| 49 | |
| 50 | |
| 51 | |
| 52 | |
| 53 | |
| 54 | |
| 55 | |
| 56 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| 17 | |
| 18 | |
| 19 | |
| 20 | |
| 21 | |
| 22 | |
| 23 | |
| 24 | |
| 25 | |
| 26 | |
| 27 | |
| 28 | |
| 29 | |
| 30 | |
| 31 | |
| 32 | |
| 33 | |
| 34 | |
| 35 | |
| 36 | |
| 37 | |
| 38 | |
| 39 | |
| 40 | |
| 41 | |
| 42 | |
| 43 | |
| 44 | |
| 45 | |
| 46 | |
| 47 | |
| 48 | |
| 49 | |
| 50 | |
| 51 | |
| 52 | |
| 53 | |
| 54 | |
| 55 | |
| 56 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| 17 | |
| 18 | |
| 19 | |
| 20 | |
| 21 | |
| 22 | |
| 23 | |
| 24 | |
| 25 | |
| 26 | |
| 27 | |
| 28 | |
| 29 | |
| 30 | |
| 31 | |
| 32 | |
| 33 | |
| 34 | |
| 35 | |
| 36 | |
| 37 | |
| 38 | |
| 39 | |
| 40 | |
| 41 | |
| 42 | |
| 43 | |
| 44 | |
| 45 | |
| 46 | |
| 47 | |
| 48 | |
| 49 | |
| 50 | |
| 51 | |
| 52 | |
| 53 | |
| 54 | |
| 55 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| 17 | |
| 18 | |
| 19 | |
| 20 | |
| 21 | |
| 22 | |
| 23 | |
| 24 | |
| 25 | |
| 26 | |
| 27 | |
| 28 | |
| 29 | |
| 30 | |
| 31 | |
| 32 | |
| 33 | |
| 34 | |
| 35 | |
| 36 | |
| 37 | |
| 38 | |
| 39 | |
| 40 | |
| 41 | |
| 42 | |
| 43 | |
| 44 | |
| 45 | |
| 46 | |
| 47 | |
| 48 | |
| 49 | |
| 50 | |
| 51 | |
| 52 | |
| 53 | |
| 54 | |
| 55 | |
select `ep`.*, `c`.*, `pep`.`ep_id` as `parent_ep_id` from `companies` as `c` inner join `employer_profile` as `ep` on `c`.`company_id` = `ep`.`company_id` left join `companies` as `pc` on `c`.`parent_company_id` = `pc`.`company_id` left join `employer_profile` as `pep` on `pc`.`company_id` = `pep`.`company_id` where `ep`.`url` = 'elanco' and `c`.`contract_type` != '8' limit 11.5ms/app/Models/Customer.php:42d01cc94c| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select `c`.`company_id` from `companies` as `c` inner join `employer_profile` as `ep` on `ep`.`company_id` = `c`.`company_id` where `c`.`parent_company_id` = '53028' and `ep`.`online` = '1'180μs/app/Models/Customer.php:114d01cc94c| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `m`.`name`, `m`.`ep_id`, `me`.`custom_headline` from `customer_site_modules` as `m` inner join `customer_site_modules_employer_profile` as `me` on `m`.`module_id` = `me`.`module_id` where `me`.`ep_id` = '733' order by `me`.`sort` asc830μs/app/Models/Customer.php:131d01cc94c| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `we`.* from `companies_work_environments` as `cwe` inner join `work_environments` as `we` on `cwe`.`we_id` = `we`.`we_id` where `cwe`.`company_id` = '53028'310μs/app/Models/Customer.php:58d01cc94c| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select `sf`.* from `companies_special_fields` as `csf` inner join `special_fields` as `sf` on `csf`.`sf_id` = `sf`.`sf_id` where `csf`.`company_id` = '53028'1.2ms/app/Models/Customer.php:74d01cc94c| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select `c`.*, `ca`.* from `companies` as `c` left join `company_address` as `ca` on `c`.`company_id` = `ca`.`company_id` where `c`.`company_id` = '53028' and `ca`.`company_address_id` = '6645' limit 1380μs/app/Models/Customer.php:166d01cc94c| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select `c`.*, `cc`.*, `cc`.`img` as `contact_img`, `g`.`salutation` from `companies` as `c` left join `company_contact` as `cc` on `c`.`company_id` = `cc`.`company_id` left join `genders` as `g` on `g`.`gender_id` = `cc`.`gender` where `c`.`company_id` = '53028' and `cc`.`primary_contact` = '1' limit 1310μs/app/Models/Customer.php:186d01cc94c| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select COUNT(l_id) as anzahl from `companies_likes` where `company_id` = '53028' limit 1230μs/app/Models/Customer.php:293d01cc94c| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select *, 53028 as directory from `employer_profile_testimonial` where `ep_id` = '733' order by `sort` asc170μs/app/Models/Customer.php:201d01cc94c| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `employer_profile_local` where `ep_id` = '733' order by `sort` asc140μs/app/Models/Customer.php:215d01cc94c| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select *, 53028 as directory from `employer_profile_img` where `ep_id` = '733' and `template_pos` = 'header' and `sort` is not null order by `sort` asc180μs/app/Models/Customer.php:266d01cc94c| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select *, 53028 as directory from `employer_profile_img` where `ep_id` = '733' and `template_pos` = 'gallery' and `sort` is not null order by `sort` asc170μs/app/Models/Customer.php:266d01cc94c| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select *, 53028 as directory from `employer_profile_img` where `ep_id` = '733' and `template_pos` = 'vision' and `sort` is not null order by `sort` asc190μs/app/Models/Customer.php:266d01cc94c| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `employer_profile_videos` where `ep_id` = '733' order by `sort` asc150μs/app/Models/Customer.php:280d01cc94c| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select `ept`.*, `eptp`.`tagname`, `eptp`.`icon`, `eptp`.`fa_icon` from `employer_profile_employeebenefits` as `ept` left join `employeebenefits` as `eptp` on `ept`.`eptag_id` = `eptp`.`eptag_id` where `ept`.`ep_id` = '733' order by `sort` asc570μs/app/Models/Customer.php:232d01cc94c| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select `epf`.`epfaq_id`, `epf`.`faq_title`, `epf`.`faq_text`, `epf`.`epfc_id`, `epfc`.`epfc_title`, `epfc`.`fa_icon`, IFNULL(IF(epf.faq_title = "", NULL, epf.faq_title), epfc.epfc_title) as title from `employer_profile_faqs` as `epf` left join `employer_profile_faq_categories` as `epfc` on `epfc`.`epfc_id` = `epf`.`epfc_id` where `epf`.`ep_id` = '733' order by `epf`.`sort` asc660μs/app/Models/Customer.php:734d01cc94c| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `s`.`title`, (SUM(IF(a.answer_value <= 6, -1, IF(a.answer_value >= 9, 1, 0))) * 100 ) / COUNT(a.answer_value) AS score from `employee_surveys_enps` as `s` left join `employee_surveys_enps_answers` as `a` on `a`.`survey_id` = `s`.`survey_id` and `a`.`answer_value` is not null where `s`.`company_id` = '53028' and `s`.`visible` = '1' and `s`.`status` = '1' and `s`.`hash` <> '' and `s`.`expiration_date` <= NOW() and `s`.`participations` >= '3' group by `s`.`survey_id` having score IS NOT NULL order by `s`.`created` desc limit 1240μs/app/Models/Customer.php:816d01cc94c| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `ad`.*, `tri`.`url` as `img`, `ca`.*, `c`.*, GROUP_CONCAT(t.tag ORDER BY t.id ASC) AS tags_string, GROUP_CONCAT(t.id ORDER BY t.id ASC) AS tags_id from `training_ads` as `ad` inner join `company_address` as `ca` on `ca`.`company_address_id` = `ad`.`addr_id` inner join `companies` as `c` on `c`.`company_id` = `ad`.`company_id` left join `training_images` as `tri` on `ad`.`training_id` = `tri`.`training_id` and `tri`.`sort` = '1' left join `trainings_tags` as `tt` on `tt`.`training_id` = `ad`.`training_id` left join `tags` as `t` on `t`.`id` = `tt`.`tag_id` where `ad`.`company_id` in ('53028') and `ad`.`visible` = '1' and `ad`.`status` = '1' group by `ad`.`training_id` order by `ad`.`always_available` asc, `ad`.`date_start` asc, `ad`.`atf_hours` desc750μs/app/Models/Customer.php:330d01cc94c| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select `ad`.*, `tri`.`url` as `img`, `ca`.*, `c`.*, GROUP_CONCAT(t.tag ORDER BY t.id ASC) AS tags_string, GROUP_CONCAT(t.id ORDER BY t.id ASC) AS tags_id from `training_ads` as `ad` inner join `company_address` as `ca` on `ca`.`company_address_id` = `ad`.`addr_id` inner join `companies` as `c` on `c`.`company_id` = `ad`.`company_id` left join `training_images` as `tri` on `ad`.`training_id` = `tri`.`training_id` and `tri`.`sort` = '1' left join `trainings_tags` as `tt` on `tt`.`training_id` = `ad`.`training_id` left join `tags` as `t` on `t`.`id` = `tt`.`tag_id` where `ad`.`company_id` = '53028' and `ad`.`registration` = '1' and `ad`.`visible` = '1' and `ad`.`always_available` = '1' and `ad`.`status` = '1' group by `ad`.`training_id` order by `ad`.`last_booked` desc limit 1760μs/app/Models/Customer.php:368d01cc94c| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select `ad`.*, `tri`.`url` as `img`, `ca`.*, `c`.*, GROUP_CONCAT(t.tag ORDER BY t.id ASC) AS tags_string, GROUP_CONCAT(t.id ORDER BY t.id ASC) AS tags_id from `training_ads` as `ad` inner join `company_address` as `ca` on `ca`.`company_address_id` = `ad`.`addr_id` inner join `companies` as `c` on `c`.`company_id` = `ad`.`company_id` left join `training_images` as `tri` on `ad`.`training_id` = `tri`.`training_id` and `tri`.`sort` = '1' left join `trainings_tags` as `tt` on `tt`.`training_id` = `ad`.`training_id` left join `tags` as `t` on `t`.`id` = `tt`.`tag_id` where `ad`.`company_id` = '53028' and `ad`.`registration` = '2' and `ad`.`visible` = '1' and `ad`.`always_available` = '1' and `ad`.`status` = '1' group by `ad`.`training_id` order by `ad`.`last_booked` desc limit 1790μs/app/Models/Customer.php:368d01cc94c| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select `ad`.*, `sai`.`url` as `img`, `sc`.`type`, `ad`.`created`, GROUP_CONCAT(t.tag ORDER BY t.id ASC) AS tags_string, GROUP_CONCAT(t.id ORDER BY t.id ASC) AS tags_id from `specialist_ads` as `ad` left join `specialist_images` as `sai` on `ad`.`specialist_id` = `sai`.`specialist_id` and `sai`.`sort` = '1' left join `specialist_categories` as `sc` on `ad`.`sc_id` = `sc`.`sc_id` left join `specialists_tags` as `st` on `st`.`specialist_id` = `ad`.`specialist_id` left join `tags` as `t` on `t`.`id` = `st`.`tag_id` where `ad`.`company_id` in ('53028') and `ad`.`visible` = '1' and (`ad`.`date_start` <= CURDATE() or `ad`.`date_start` is null) and `ad`.`status` = '1' group by `ad`.`specialist_id` order by IFNULL(ad.date_start,ad.last_booked) desc530μs/app/Models/Customer.php:405d01cc94c| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select `ad`.*, `sai`.`url` as `img`, `sc`.`type`, `ad`.`created`, GROUP_CONCAT(t.tag ORDER BY t.id ASC) AS tags_string, GROUP_CONCAT(t.id ORDER BY t.id ASC) AS tags_id from `specialist_ads` as `ad` left join `specialist_images` as `sai` on `ad`.`specialist_id` = `sai`.`specialist_id` and `sai`.`sort` = '1' left join `specialist_categories` as `sc` on `ad`.`sc_id` = `sc`.`sc_id` left join `specialists_tags` as `st` on `st`.`specialist_id` = `ad`.`specialist_id` left join `tags` as `t` on `t`.`id` = `st`.`tag_id` where `ad`.`company_id` = '53028' and `ad`.`visible` = '1' and (`ad`.`date_start` <= CURDATE() or `ad`.`date_start` is null) and `ad`.`status` = '1' group by `ad`.`specialist_id` order by IFNULL(ad.date_start,ad.last_booked) desc limit 1460μs/app/Models/Customer.php:441d01cc94c| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select `tp`.`title`, `tpc`.`title` as `category`, `tp`.`language`, `tp`.`img` from `training_possibilities` as `tp` left join `training_possibilities_categories` as `tpc` on `tpc`.`category_id` = `tp`.`category_id` inner join `companies_training_possibilities` as `ctp` on `ctp`.`training_pos_id` = `tp`.`training_pos_id` where `ctp`.`company_id` = '53028' order by `tpc`.`sort` asc310μs/app/Models/Customer.php:461d01cc94c| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `b`.`badge_id`, `b`.`badgename`, `b`.`icon` from `companies_badges` as `cb` inner join `badges` as `b` on `cb`.`badge_id` = `b`.`badge_id` where `cb`.`company_id` = '53028' order by `b`.`sort` asc240μs/app/Models/Customer.php:833d01cc94c| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select distinct `ad`.*, `adc`.`adc_url`, `c`.`company_name`, `ca`.`street`, `ca`.`zip`, `ca`.`city`, `ca`.`lat`, `ca`.`lng`, `cs`.`country` as `country`, `gender`, `title`, `firstname`, `lastname`, `phone`, `mobile`, `cc`.`img` as `contact_img`, `plzs`.`name` as `state_name`, `i`.`url` as `img`, `epi`.`filename` as `ep_header_image` from `ads` as `ad` left join `company_address` as `ca` on `ad`.`addr_id` = `ca`.`company_address_id` left join `company_contact` as `cc` on `ad`.`company_contact_id` = `cc`.`company_contact_id` left join `companies` as `c` on `ad`.`company_id` = `c`.`company_id` left join `ad_category` as `adc` on `ad`.`adc_id` = `adc`.`adc_id` left join `countries` as `cs` on `cs`.`key` = `ca`.`country` left join `plzsearch_zipcode` as `plzz` on `ca`.`zip` = `plzz`.`zipcode` left join `plzsearch_state` as `plzs` on `plzz`.`state_id` = `plzs`.`id` left join `ad_images` as `i` on `i`.`ad_id` = `ad`.`ad_id` and `i`.`sort` = '1' left join `employer_profile` as `ep` on `ep`.`company_id` = `c`.`company_id` left join `employer_profile_img` as `epi` on `ep`.`ep_id` = `epi`.`ep_id` and `epi`.`template_pos` = 'header' and `epi`.`sort` = '1' where `ad`.`visible` = '1' and `ad`.`is_template` = '0' and `cs`.`locale` = 'de_DE' and ((`ad`.`company_id` in ('53028')) or (`ad`.`addr_id` = '6645')) and `ad`.`status` = '1' order by `ad`.`list_promo_sort` desc, `ad`.`last_booked` desc1.1ms/app/Models/Customer.php:523d01cc94c| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `mi`.`mi_id`, `mi`.`title`, `mi`.`description`, `mi`.`img`, `mi`.`icon` from `companies_mandatory_internships` as `cmi` inner join `mandatory_internships` as `mi` on `mi`.`mi_id` = `cmi`.`mi_id` where `cmi`.`company_id` = '53028' order by `mi`.`sort` asc340μs/app/Models/Customer.php:850d01cc94c| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `ca`.`street`, `ca`.`zip`, `ca`.`city`, `ca`.`lat`, `ca`.`lng`, `c`.`company_id` as `link_company_id`, `ep`.`url`, `c`.`profile_name` as `name`, `c`.`contract_type` from `companies` as `c` inner join `employer_profile` as `ep` on `c`.`company_id` = `ep`.`company_id` left join `company_address` as `ca` on `ca`.`company_address_id` = `c`.`addr_id` where `c`.`company_id` = '53028'230μs/app/Models/Customer.php:792d01cc94c| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `gm`.`street`, `gm`.`zip`, `gm`.`city`, `gm`.`lat`, `gm`.`lng`, `gm`.`link_company_id`, `ep`.`url`, `gm`.`name`, `gm`.`group_map_id`, `c`.`contract_type` from `companies_group_map` as `gm` left join `employer_profile` as `ep` on `ep`.`company_id` = `gm`.`link_company_id` left join `companies` as `c` on `c`.`company_id` = `ep`.`company_id` where `gm`.`company_id` = '53028'190μs/app/Models/Customer.php:753d01cc94c| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `ca`.`street`, `ca`.`zip`, `ca`.`city`, `ca`.`lat`, `ca`.`lng`, `c`.`company_id` as `link_company_id`, `ep`.`url`, `ep`.`online`, `c`.`profile_name` as `name`, `c`.`contract_type` from `companies` as `c` inner join `employer_profile` as `ep` on `c`.`company_id` = `ep`.`company_id` left join `company_address` as `ca` on `ca`.`company_address_id` = `c`.`addr_id` where `c`.`parent_company_id` = '53028' and `ep`.`online` = '1'280μs/app/Models/Customer.php:773d01cc94c| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `c`.`profile_name`, `ep`.`url`, `ca`.* from `employer_profile` as `ep` inner join `companies` as `c` on `c`.`company_id` = `ep`.`company_id` inner join `company_address` as `ca` on `ca`.`company_id` = `c`.`company_id` where `c`.`vuk_membership` = '1' and `ep`.`online` = '1' and `ca`.`job_primary` = '1'160μs/app/Models/Customer.php:870d01cc94c| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|