Redirect 302 redirect from GET @shop_kategorie (344d94)

GET http://dev.nos.marksdev.de/shop/rohmaterial/rund

Response
200 OK
Browse referrer URL
IP
10.244.2.14
Profiled on
Token
707d84

Query Metrics

20 Database Queries
8 Different statements
297.79 ms Query time
0 Invalid entities

Queries

Group similar statements

#▲ Time Info
1 14.48 ms 
SELECT t0.id AS id_1, t0.erstellt AS erstellt_2, t0.aktualisiert AS aktualisiert_3, t0.parent AS parent_4, t0.titel AS titel_5, t0.bezeichnung AS bezeichnung_6, t0.info1 AS info1_7, t0.info2 AS info2_8, t0.beschreibung AS beschreibung_9, t0.uri_part AS uri_part_10, t0.uri_part_full_cache AS uri_part_full_cache_11, t0.sortierung AS sortierung_12, t0.anzeigen_startseite AS anzeigen_startseite_13, t0.ausgeblendet AS ausgeblendet_14, t0.deaktiviert AS deaktiviert_15, t0.artikelsuche_suchgruppe AS artikelsuche_suchgruppe_16, t0.template AS template_17, t0.bild AS bild_18, t0.artikelbilder_anzeigen AS artikelbilder_anzeigen_19, t0.artikelbilder_lazy_load AS artikelbilder_lazy_load_20, t0.verlinkung AS verlinkung_21, t0.hinweistext AS hinweistext_22, t0.artikelsuche_submitbutton_text AS artikelsuche_submitbutton_text_23, t0.hide_tab_alle AS hide_tab_alle_24, t0.banner_farbe AS banner_farbe_25, t0.banner_text AS banner_text_26 FROM nos_artikelkategorie t0 WHERE t0.uri_part = ? AND t0.deaktiviert = ? ORDER BY (SELECT 0) OFFSET 0 ROWS FETCH NEXT 1 ROWS ONLY
Parameters: 
[
  "rohmaterial"
  0
]
View formatted query    View runnable query    Explain query
2 14.73 ms 
SELECT t0.id AS id_1, t0.erstellt AS erstellt_2, t0.aktualisiert AS aktualisiert_3, t0.parent AS parent_4, t0.titel AS titel_5, t0.bezeichnung AS bezeichnung_6, t0.info1 AS info1_7, t0.info2 AS info2_8, t0.beschreibung AS beschreibung_9, t0.uri_part AS uri_part_10, t0.uri_part_full_cache AS uri_part_full_cache_11, t0.sortierung AS sortierung_12, t0.anzeigen_startseite AS anzeigen_startseite_13, t0.ausgeblendet AS ausgeblendet_14, t0.deaktiviert AS deaktiviert_15, t0.artikelsuche_suchgruppe AS artikelsuche_suchgruppe_16, t0.template AS template_17, t0.bild AS bild_18, t0.artikelbilder_anzeigen AS artikelbilder_anzeigen_19, t0.artikelbilder_lazy_load AS artikelbilder_lazy_load_20, t0.verlinkung AS verlinkung_21, t0.hinweistext AS hinweistext_22, t0.artikelsuche_submitbutton_text AS artikelsuche_submitbutton_text_23, t0.hide_tab_alle AS hide_tab_alle_24, t0.banner_farbe AS banner_farbe_25, t0.banner_text AS banner_text_26 FROM nos_artikelkategorie t0 WHERE t0.uri_part = ? AND t0.parent = ? AND t0.deaktiviert = ? ORDER BY (SELECT 0) OFFSET 0 ROWS FETCH NEXT 1 ROWS ONLY
Parameters: 
[
  "rund"
  1
  0
]
View formatted query    View runnable query    Explain query
3 14.62 ms 
SELECT t0.id AS id_1, t0.erstellt AS erstellt_2, t0.aktualisiert AS aktualisiert_3, t0.parent AS parent_4, t0.titel AS titel_5, t0.bezeichnung AS bezeichnung_6, t0.info1 AS info1_7, t0.info2 AS info2_8, t0.beschreibung AS beschreibung_9, t0.uri_part AS uri_part_10, t0.uri_part_full_cache AS uri_part_full_cache_11, t0.sortierung AS sortierung_12, t0.anzeigen_startseite AS anzeigen_startseite_13, t0.ausgeblendet AS ausgeblendet_14, t0.deaktiviert AS deaktiviert_15, t0.artikelsuche_suchgruppe AS artikelsuche_suchgruppe_16, t0.template AS template_17, t0.bild AS bild_18, t0.artikelbilder_anzeigen AS artikelbilder_anzeigen_19, t0.artikelbilder_lazy_load AS artikelbilder_lazy_load_20, t0.verlinkung AS verlinkung_21, t0.hinweistext AS hinweistext_22, t0.artikelsuche_submitbutton_text AS artikelsuche_submitbutton_text_23, t0.hide_tab_alle AS hide_tab_alle_24, t0.banner_farbe AS banner_farbe_25, t0.banner_text AS banner_text_26 FROM nos_artikelkategorie t0 WHERE t0.parent = ? ORDER BY t0.sortierung ASC
Parameters: 
[
  6
]
View formatted query    View runnable query    Explain query
4 14.58 ms 
SELECT t0.id AS id_1, t0.suchgruppe AS suchgruppe_2, t0.formularfeld_ident AS formularfeld_ident_3, t0.formularfeld_typ AS formularfeld_typ_4, t0.formularfeld_bezeichnung AS formularfeld_bezeichnung_5, t0.formularfeld_suffix AS formularfeld_suffix_6, t0.sortierung AS sortierung_7, t0.formularfeld_standardwert AS formularfeld_standardwert_8, t0.formularfeld_convert_decimal AS formularfeld_convert_decimal_9, t0.hinweis AS hinweis_10, t0.formularfeld_nachbar AS formularfeld_nachbar_11 FROM nos_artikelsuche t0 WHERE t0.suchgruppe = ? ORDER BY t0.sortierung ASC
Parameters: 
[
  "rohmaterial_rund"
]
View formatted query    View runnable query    Explain query
5 14.54 ms 
SELECT n0_.id AS id_0 FROM nos_artikelsuche n0_ WHERE CONCAT(n0_.suchgruppe, '_', n0_.formularfeld_ident) = ? AND n0_.formularfeld_convert_decimal = 1 ORDER BY (SELECT 0) OFFSET 0 ROWS FETCH NEXT 1 ROWS ONLY
Parameters: 
[
  "rohmaterial_rund_legierung"
]
View formatted query    View runnable query    Explain query
6 14.64 ms 
SELECT n0_.id AS id_0 FROM nos_artikelsuche n0_ WHERE CONCAT(n0_.suchgruppe, '_', n0_.formularfeld_ident) = ? AND n0_.formularfeld_convert_decimal = 1 ORDER BY (SELECT 0) OFFSET 0 ROWS FETCH NEXT 1 ROWS ONLY
Parameters: 
[
  "rohmaterial_rund_legierung_alternative"
]
View formatted query    View runnable query    Explain query
7 14.66 ms 
SELECT n0_.id AS id_0 FROM nos_artikelsuche n0_ WHERE CONCAT(n0_.suchgruppe, '_', n0_.formularfeld_ident) = ? AND n0_.formularfeld_convert_decimal = 1 ORDER BY (SELECT 0) OFFSET 0 ROWS FETCH NEXT 1 ROWS ONLY
Parameters: 
[
  "rohmaterial_rund_durchmesser"
]
View formatted query    View runnable query    Explain query
8 15.05 ms 
SELECT n0_.id AS id_0 FROM nos_artikelsuche n0_ WHERE CONCAT(n0_.suchgruppe, '_', n0_.formularfeld_ident) = ? AND n0_.formularfeld_convert_decimal = 1 ORDER BY (SELECT 0) OFFSET 0 ROWS FETCH NEXT 1 ROWS ONLY
Parameters: 
[
  "rohmaterial_rund_laenge"
]
View formatted query    View runnable query    Explain query
9 14.62 ms 
SELECT n0_.id AS id_0 FROM nos_artikelsuche n0_ WHERE CONCAT(n0_.suchgruppe, '_', n0_.formularfeld_ident) = ? AND n0_.formularfeld_convert_decimal = 1 ORDER BY (SELECT 0) OFFSET 0 ROWS FETCH NEXT 1 ROWS ONLY
Parameters: 
[
  "rohmaterial_rund_menge"
]
View formatted query    View runnable query    Explain query
10 15.13 ms 
SELECT n0_.id AS id_0 FROM nos_artikelsuche n0_ WHERE CONCAT(n0_.suchgruppe, '_', n0_.formularfeld_ident) = ? AND n0_.formularfeld_convert_decimal = 1 ORDER BY (SELECT 0) OFFSET 0 ROWS FETCH NEXT 1 ROWS ONLY
Parameters: 
[
  "submit"
]
View formatted query    View runnable query    Explain query
11 15.03 ms 
SELECT t0.id AS id_1, t0.erstellt AS erstellt_2, t0.aktualisiert AS aktualisiert_3, t0.parent AS parent_4, t0.titel AS titel_5, t0.bezeichnung AS bezeichnung_6, t0.info1 AS info1_7, t0.info2 AS info2_8, t0.beschreibung AS beschreibung_9, t0.uri_part AS uri_part_10, t0.uri_part_full_cache AS uri_part_full_cache_11, t0.sortierung AS sortierung_12, t0.anzeigen_startseite AS anzeigen_startseite_13, t0.ausgeblendet AS ausgeblendet_14, t0.deaktiviert AS deaktiviert_15, t0.artikelsuche_suchgruppe AS artikelsuche_suchgruppe_16, t0.template AS template_17, t0.bild AS bild_18, t0.artikelbilder_anzeigen AS artikelbilder_anzeigen_19, t0.artikelbilder_lazy_load AS artikelbilder_lazy_load_20, t0.verlinkung AS verlinkung_21, t0.hinweistext AS hinweistext_22, t0.artikelsuche_submitbutton_text AS artikelsuche_submitbutton_text_23, t0.hide_tab_alle AS hide_tab_alle_24, t0.banner_farbe AS banner_farbe_25, t0.banner_text AS banner_text_26 FROM nos_artikelkategorie t0 WHERE t0.parent IS NULL ORDER BY t0.sortierung ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query
12 15.73 ms 
SELECT t0.id AS id_1, t0.erstellt AS erstellt_2, t0.aktualisiert AS aktualisiert_3, t0.parent AS parent_4, t0.titel AS titel_5, t0.bezeichnung AS bezeichnung_6, t0.info1 AS info1_7, t0.info2 AS info2_8, t0.beschreibung AS beschreibung_9, t0.uri_part AS uri_part_10, t0.uri_part_full_cache AS uri_part_full_cache_11, t0.sortierung AS sortierung_12, t0.anzeigen_startseite AS anzeigen_startseite_13, t0.ausgeblendet AS ausgeblendet_14, t0.deaktiviert AS deaktiviert_15, t0.artikelsuche_suchgruppe AS artikelsuche_suchgruppe_16, t0.template AS template_17, t0.bild AS bild_18, t0.artikelbilder_anzeigen AS artikelbilder_anzeigen_19, t0.artikelbilder_lazy_load AS artikelbilder_lazy_load_20, t0.verlinkung AS verlinkung_21, t0.hinweistext AS hinweistext_22, t0.artikelsuche_submitbutton_text AS artikelsuche_submitbutton_text_23, t0.hide_tab_alle AS hide_tab_alle_24, t0.banner_farbe AS banner_farbe_25, t0.banner_text AS banner_text_26 FROM nos_artikelkategorie t0 WHERE t0.parent = ? ORDER BY t0.sortierung ASC
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query
13 14.56 ms 
SELECT t0.id AS id_1, t0.erstellt AS erstellt_2, t0.aktualisiert AS aktualisiert_3, t0.parent AS parent_4, t0.titel AS titel_5, t0.bezeichnung AS bezeichnung_6, t0.info1 AS info1_7, t0.info2 AS info2_8, t0.beschreibung AS beschreibung_9, t0.uri_part AS uri_part_10, t0.uri_part_full_cache AS uri_part_full_cache_11, t0.sortierung AS sortierung_12, t0.anzeigen_startseite AS anzeigen_startseite_13, t0.ausgeblendet AS ausgeblendet_14, t0.deaktiviert AS deaktiviert_15, t0.artikelsuche_suchgruppe AS artikelsuche_suchgruppe_16, t0.template AS template_17, t0.bild AS bild_18, t0.artikelbilder_anzeigen AS artikelbilder_anzeigen_19, t0.artikelbilder_lazy_load AS artikelbilder_lazy_load_20, t0.verlinkung AS verlinkung_21, t0.hinweistext AS hinweistext_22, t0.artikelsuche_submitbutton_text AS artikelsuche_submitbutton_text_23, t0.hide_tab_alle AS hide_tab_alle_24, t0.banner_farbe AS banner_farbe_25, t0.banner_text AS banner_text_26 FROM nos_artikelkategorie t0 WHERE t0.parent = ? ORDER BY t0.sortierung ASC
Parameters: 
[
  1311
]
View formatted query    View runnable query    Explain query
14 15.31 ms 
SELECT t0.id AS id_1, t0.erstellt AS erstellt_2, t0.aktualisiert AS aktualisiert_3, t0.parent AS parent_4, t0.titel AS titel_5, t0.bezeichnung AS bezeichnung_6, t0.info1 AS info1_7, t0.info2 AS info2_8, t0.beschreibung AS beschreibung_9, t0.uri_part AS uri_part_10, t0.uri_part_full_cache AS uri_part_full_cache_11, t0.sortierung AS sortierung_12, t0.anzeigen_startseite AS anzeigen_startseite_13, t0.ausgeblendet AS ausgeblendet_14, t0.deaktiviert AS deaktiviert_15, t0.artikelsuche_suchgruppe AS artikelsuche_suchgruppe_16, t0.template AS template_17, t0.bild AS bild_18, t0.artikelbilder_anzeigen AS artikelbilder_anzeigen_19, t0.artikelbilder_lazy_load AS artikelbilder_lazy_load_20, t0.verlinkung AS verlinkung_21, t0.hinweistext AS hinweistext_22, t0.artikelsuche_submitbutton_text AS artikelsuche_submitbutton_text_23, t0.hide_tab_alle AS hide_tab_alle_24, t0.banner_farbe AS banner_farbe_25, t0.banner_text AS banner_text_26 FROM nos_artikelkategorie t0 WHERE t0.parent = ? ORDER BY t0.sortierung ASC
Parameters: 
[
  33
]
View formatted query    View runnable query    Explain query
15 16.75 ms 
SELECT t0.id AS id_1, t0.erstellt AS erstellt_2, t0.aktualisiert AS aktualisiert_3, t0.parent AS parent_4, t0.titel AS titel_5, t0.bezeichnung AS bezeichnung_6, t0.info1 AS info1_7, t0.info2 AS info2_8, t0.beschreibung AS beschreibung_9, t0.uri_part AS uri_part_10, t0.uri_part_full_cache AS uri_part_full_cache_11, t0.sortierung AS sortierung_12, t0.anzeigen_startseite AS anzeigen_startseite_13, t0.ausgeblendet AS ausgeblendet_14, t0.deaktiviert AS deaktiviert_15, t0.artikelsuche_suchgruppe AS artikelsuche_suchgruppe_16, t0.template AS template_17, t0.bild AS bild_18, t0.artikelbilder_anzeigen AS artikelbilder_anzeigen_19, t0.artikelbilder_lazy_load AS artikelbilder_lazy_load_20, t0.verlinkung AS verlinkung_21, t0.hinweistext AS hinweistext_22, t0.artikelsuche_submitbutton_text AS artikelsuche_submitbutton_text_23, t0.hide_tab_alle AS hide_tab_alle_24, t0.banner_farbe AS banner_farbe_25, t0.banner_text AS banner_text_26 FROM nos_artikelkategorie t0 WHERE t0.parent = ? ORDER BY t0.sortierung ASC
Parameters: 
[
  3
]
View formatted query    View runnable query    Explain query
16 14.57 ms 
SELECT t0.id AS id_1, t0.erstellt AS erstellt_2, t0.aktualisiert AS aktualisiert_3, t0.parent AS parent_4, t0.titel AS titel_5, t0.bezeichnung AS bezeichnung_6, t0.info1 AS info1_7, t0.info2 AS info2_8, t0.beschreibung AS beschreibung_9, t0.uri_part AS uri_part_10, t0.uri_part_full_cache AS uri_part_full_cache_11, t0.sortierung AS sortierung_12, t0.anzeigen_startseite AS anzeigen_startseite_13, t0.ausgeblendet AS ausgeblendet_14, t0.deaktiviert AS deaktiviert_15, t0.artikelsuche_suchgruppe AS artikelsuche_suchgruppe_16, t0.template AS template_17, t0.bild AS bild_18, t0.artikelbilder_anzeigen AS artikelbilder_anzeigen_19, t0.artikelbilder_lazy_load AS artikelbilder_lazy_load_20, t0.verlinkung AS verlinkung_21, t0.hinweistext AS hinweistext_22, t0.artikelsuche_submitbutton_text AS artikelsuche_submitbutton_text_23, t0.hide_tab_alle AS hide_tab_alle_24, t0.banner_farbe AS banner_farbe_25, t0.banner_text AS banner_text_26 FROM nos_artikelkategorie t0 WHERE t0.parent = ? ORDER BY t0.sortierung ASC
Parameters: 
[
  4
]
View formatted query    View runnable query    Explain query
17 14.67 ms 
SELECT t0.id AS id_1, t0.erstellt AS erstellt_2, t0.aktualisiert AS aktualisiert_3, t0.parent AS parent_4, t0.titel AS titel_5, t0.bezeichnung AS bezeichnung_6, t0.info1 AS info1_7, t0.info2 AS info2_8, t0.beschreibung AS beschreibung_9, t0.uri_part AS uri_part_10, t0.uri_part_full_cache AS uri_part_full_cache_11, t0.sortierung AS sortierung_12, t0.anzeigen_startseite AS anzeigen_startseite_13, t0.ausgeblendet AS ausgeblendet_14, t0.deaktiviert AS deaktiviert_15, t0.artikelsuche_suchgruppe AS artikelsuche_suchgruppe_16, t0.template AS template_17, t0.bild AS bild_18, t0.artikelbilder_anzeigen AS artikelbilder_anzeigen_19, t0.artikelbilder_lazy_load AS artikelbilder_lazy_load_20, t0.verlinkung AS verlinkung_21, t0.hinweistext AS hinweistext_22, t0.artikelsuche_submitbutton_text AS artikelsuche_submitbutton_text_23, t0.hide_tab_alle AS hide_tab_alle_24, t0.banner_farbe AS banner_farbe_25, t0.banner_text AS banner_text_26 FROM nos_artikelkategorie t0 WHERE t0.parent = ? ORDER BY t0.sortierung ASC
Parameters: 
[
  135
]
View formatted query    View runnable query    Explain query
18 15.16 ms 
SELECT t0.id AS id_1, t0.erstellt AS erstellt_2, t0.aktualisiert AS aktualisiert_3, t0.menge AS menge_4, t0.session_id AS session_id_5, t0.artikel_id AS artikel_id_6, t0.artikel_typ_id AS artikel_typ_id_7, t0.bestellvermerk AS bestellvermerk_8, t0.werkszeugnis AS werkszeugnis_9, t0.benutzer_id AS benutzer_id_10 FROM nos_warenkorb t0 WHERE t0.session_id = ? ORDER BY t0.erstellt ASC
Parameters: 
[
  "907bfd13698d1b2b0d370bf277d84374"
]
View formatted query    View runnable query    Explain query
19 14.28 ms 
SELECT t0.id AS id_1, t0.wert AS wert_2, t0.beschreibung AS beschreibung_3, t0.erstellt AS erstellt_4, t0.aktualisiert AS aktualisiert_5 FROM nos_einstellungen t0 WHERE t0.id = ?
Parameters: 
[
  "globaler_hinweis"
]
View formatted query    View runnable query    Explain query
20 14.69 ms 
SELECT t0.id AS id_1, t0.wert AS wert_2, t0.beschreibung AS beschreibung_3, t0.erstellt AS erstellt_4, t0.aktualisiert AS aktualisiert_5 FROM nos_einstellungen t0 WHERE t0.id = ?
Parameters: 
[
  "shop_werkszeugnis_nettopreis"
]
View formatted query    View runnable query    Explain query

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

Class Mapping errors
App\Entity\Artikelkategorie No errors.
App\Entity\Artikelsuche No errors.
App\Entity\Warenkorb No errors.
App\Entity\Benutzer No errors.
App\Entity\Einstellungen No errors.