http://hetopq.world/_fragment?_path=_locale%3Dde%26_format%3Dhtml%26_controller%3DAppBundle%253ADefault%253Adefault

Query Metrics

156 Database Queries
47 Different statements
367.59 ms Query time
0 Invalid entities

Queries

Group similar statements

#▲ Time Info
1 0.48 ms
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
Parameters:
[
  1795065095
  [
    "site_domain_0a5975ce453a1f3fa3ebe3fb7285128b"
  ]
]
2 1.58 ms
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
Parameters:
[
  1795065095
  [
    "system_route_redirect"
  ]
]
3 3.39 ms
SELECT id FROM documents WHERE path = :path AND `key` = :key
Parameters:
[
  "key" => "Fiat--Rueckleuchten~p456"
  "path" => "/de/shop/Produkte/Ersatzteile/Beleuchtung/"
]
4 0.46 ms
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
Parameters:
[
  "prettyUrl" => "/de/shop/Produkte/Ersatzteile/Beleuchtung/Fiat--Rueckleuchten~p456"
]
5 0.12 ms
SELECT id FROM documents WHERE path = :path AND `key` = :key
Parameters:
[
  "key" => "Beleuchtung"
  "path" => "/de/shop/Produkte/Ersatzteile/"
]
6 0.09 ms
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
Parameters:
[
  "prettyUrl" => "/de/shop/Produkte/Ersatzteile/Beleuchtung"
]
7 0.12 ms
SELECT id FROM documents WHERE path = :path AND `key` = :key
Parameters:
[
  "key" => "Ersatzteile"
  "path" => "/de/shop/Produkte/"
]
8 0.09 ms
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
Parameters:
[
  "prettyUrl" => "/de/shop/Produkte/Ersatzteile"
]
9 1.38 ms
SELECT id FROM documents WHERE path = :path AND `key` = :key
Parameters:
[
  "key" => "Produkte"
  "path" => "/de/shop/"
]
10 0.10 ms
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
Parameters:
[
  "prettyUrl" => "/de/shop/Produkte"
]
11 0.38 ms
SELECT id FROM documents WHERE path = :path AND `key` = :key
Parameters:
[
  "key" => "shop"
  "path" => "/de/"
]
12 0.10 ms
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
Parameters:
[
  "prettyUrl" => "/de/shop"
]
13 0.10 ms
SELECT id FROM documents WHERE path = :path AND `key` = :key
Parameters:
[
  "key" => "de"
  "path" => "/"
]
14 0.44 ms
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
Parameters:
[
  1795065095
  [
    "document_136"
  ]
]
15 0.27 ms
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
Parameters:
[
  1795065095
  [
    "document_properties_136"
  ]
]
16 0.08 ms
SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1
Parameters:
[]
17 0.81 ms
SELECT PLUGIN_CMF_COLLECT_DOCUMENT_SEGMENT_ASSIGNMENTS(:elementId)
Parameters:
[
  "elementId" => 136
]
18 0.25 ms
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
Parameters:
[
  1795065095
  [
    "object_835"
  ]
]
19 0.07 ms
SELECT id FROM targeting_rules WHERE active = 1  ORDER BY `prio` ASC
Parameters:
[]
20 0.07 ms
SELECT * FROM targeting_rules WHERE id = ?
Parameters:
[
  1
]
21 0.06 ms
SELECT * FROM targeting_rules WHERE id = ?
Parameters:
[
  2
]
22 0.06 ms
SELECT * FROM targeting_rules WHERE id = ?
Parameters:
[
  3
]
23 0.06 ms
SELECT * FROM targeting_rules WHERE id = ?
Parameters:
[
  4
]
24 0.06 ms
SELECT * FROM targeting_rules WHERE id = ?
Parameters:
[
  6
]
25 0.06 ms
SELECT * FROM targeting_rules WHERE id = ?
Parameters:
[
  7
]
26 0.33 ms
SELECT * FROM targeting_rules WHERE id = ?
Parameters:
[
  8
]
27 0.07 ms
SELECT * FROM targeting_rules WHERE id = ?
Parameters:
[
  9
]
28 0.06 ms
SELECT * FROM targeting_rules WHERE id = ?
Parameters:
[
  10
]
29 2.49 ms
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
Parameters:
[
  1795065095
  [
    "url_1%20and%20timeonsite_2%2F%2Ftimeonsite_2%7Curl_1"
  ]
]
30 0.13 ms
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
Parameters:
[
  1795065095
  [
    "url_1%20and%20timeonsite_2%2F%2Ftimeonsite_2%7Curl_1"
  ]
]
31 0.12 ms
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
Parameters:
[
  1795065095
  [
    "url_1%20and%20timeonsite_2%2F%2Ftimeonsite_2%7Curl_1"
  ]
]
32 0.12 ms
SELECT o_id FROM objects WHERE o_path = :path AND `o_key` = :key
Parameters:
[
  "key" => "Sports-Cars-Fan"
  "path" => "/Customer Management/segments/calculated/Interest-Target-Groups/"
]
33 0.21 ms
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
Parameters:
[
  1795065095
  [
    "object_875"
  ]
]
34 0.79 ms
SELECT o_id FROM objects WHERE o_path = :path AND `o_key` = :key
Parameters:
[
  "key" => "at least once"
  "path" => "/Customer Management/segments/calculated/VisitingCount/"
]
35 1.88 ms
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
Parameters:
[
  1795065095
  [
    "object_860"
  ]
]
36 0.13 ms
SELECT o_id FROM objects WHERE o_path = :path AND `o_key` = :key
Parameters:
[
  "key" => "at least once"
  "path" => "/Customer Management/segments/calculated/VisitingCount/"
]
37 0.31 ms
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
Parameters:
[
  1795065095
  [
    "cmf_has_segment_1%20and%20cmf_customer_is_loggedin_2%2F%2Fcmf_customer_is_loggedin_2%7Ccmf_has_segment_1"
  ]
]
38 0.12 ms
SELECT o_id FROM objects WHERE o_path = :path AND `o_key` = :key
Parameters:
[
  "key" => "at least once"
  "path" => "/Customer Management/segments/calculated/VisitingCount/"
]
39 0.11 ms
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
Parameters:
[
  1795065095
  [
    "cmf_has_segment_1%20and%20cmf_customer_is_loggedin_2%2F%2Fcmf_customer_is_loggedin_2%7Ccmf_has_segment_1"
  ]
]
40 0.16 ms
SELECT o_id FROM objects WHERE o_path = :path AND `o_key` = :key
Parameters:
[
  "key" => "at least once"
  "path" => "/Customer Management/segments/calculated/VisitingCount/"
]
41 0.13 ms
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
Parameters:
[
  1795065095
  [
    "cmf_has_segment_1%20and%20cmf_customer_is_loggedin_2%2F%2Fcmf_customer_is_loggedin_2%7Ccmf_has_segment_1"
  ]
]
42 0.23 ms
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
Parameters:
[
  1795065095
  [
    "document_target_groups_136"
  ]
]
43 0.31 ms
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
Parameters:
[
  1795065095
  [
    "object_456"
  ]
]
44 0.10 ms
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "AP"
]
45 0.08 ms
SELECT * FROM object_relations_AP WHERE src_id = 456 AND fieldname = 'mainCategory' AND ownertype = 'object'
Parameters:
[]
46 0.38 ms
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
Parameters:
[
  1795065095
  [
    "object_396"
  ]
]
47 0.09 ms
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "CA"
]
48 1.17 ms
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
Parameters:
[
  1795065095
  [
    "object_393"
  ]
]
49 12.88 ms
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
Parameters:
[
  1795065095
  [
    "object_392"
  ]
]
50 2.52 ms
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
Parameters:
[
  1795065095
  [
    "object_564"
  ]
]
51 0.26 ms
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
Parameters:
[
  1795065095
  [
    "object_389"
  ]
]
52 4.94 ms
SELECT * FROM object_relations_AP WHERE src_id = 456 AND fieldname = 'manufacturer' AND ownertype = 'object'
Parameters:
[]
53 3.68 ms
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
Parameters:
[
  1795065095
  [
    "object_100"
  ]
]
54 0.08 ms
SELECT * FROM object_relations_AP WHERE src_id = 456 AND fieldname = 'series' AND ownertype = 'object'
Parameters:
[]
55 0.28 ms
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
Parameters:
[
  1795065095
  [
    "object_101"
  ]
]
56 5.11 ms
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "CAR"
]
57 5.92 ms
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
Parameters:
[
  1795065095
  [
    "object_99"
  ]
]
58 0.25 ms
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
Parameters:
[
  1795065095
  [
    "object_2"
  ]
]
59 2.14 ms
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
Parameters:
[
  1795065095
  [
    "object_744"
  ]
]
60 0.70 ms
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
Parameters:
[
  1795065095
  [
    "object_1"
  ]
]
61 13.06 ms
SELECT COUNT(*) AS `totalCount` FROM `object_1` WHERE (reference = ? and (calculated = 1) AND  object_1.o_type IN ('object','folder'))
Parameters:
[
  "Interest Manufacturer"
]
62 3.70 ms
SELECT object_1.o_id as o_id, `object_1`.`o_type` FROM `object_1` WHERE (reference = ? and (calculated = 1) AND  object_1.o_type IN ('object','folder'))
Parameters:
[
  "Interest Manufacturer"
]
63 3.13 ms
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
Parameters:
[
  1795065095
  [
    "object_960"
  ]
]
64 2.25 ms
SELECT COUNT(*) AS `totalCount` FROM `object_2` WHERE ((reference = ?)  AND (group__id = ?)  AND  object_2.o_type IN ('object','folder'))
Parameters:
[
  "Fiat"
  960
]
65 7.27 ms
SELECT object_2.o_id as o_id, `object_2`.`o_type` FROM `object_2` WHERE ((reference = ?)  AND (group__id = ?)  AND  object_2.o_type IN ('object','folder'))
Parameters:
[
  "Fiat"
  960
]
66 1.61 ms
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
Parameters:
[
  1795065095
  [
    "object_987"
  ]
]
67 0.35 ms
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
Parameters:
[
  1795065095
  [
    "object_693"
  ]
]
68 1.48 ms
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "EF_OSTC"
]
69 10.26 ms
SELECT id FROM ecommerceframework_pricing_rule WHERE active = 1  ORDER BY `prio` ASC
Parameters:
[]
70 1.72 ms
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
Parameters:
[
  1795065095
  [
    "system_resource_columns_ecommerceframework_pricing_rule"
  ]
]
71 7.61 ms
SELECT * FROM ecommerceframework_pricing_rule WHERE id='9'
Parameters:
[]
72 1.23 ms
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
Parameters:
[
  1795065095
  [
    "object_559"
  ]
]
73 1.61 ms
SELECT * FROM ecommerceframework_pricing_rule WHERE id='10'
Parameters:
[]
74 1.30 ms
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
Parameters:
[
  1795065095
  [
    "object_556"
  ]
]
75 1.14 ms
SELECT * FROM ecommerceframework_pricing_rule WHERE id='8'
Parameters:
[]
76 8.73 ms
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
Parameters:
[
  1795065095
  [
    "object_75"
  ]
]
77 0.25 ms
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
Parameters:
[
  1795065095
  [
    "object_74"
  ]
]
78 0.43 ms
SELECT o_id FROM objects WHERE o_path = :path AND `o_key` = :key
Parameters:
[
  "key" => "citroen-2cv-head lights"
  "path" => "/Product Data/Accessories/lights/head lights/"
]
79 4.60 ms
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
Parameters:
[
  1795065095
  [
    "object_438"
  ]
]
80 3.30 ms
SELECT * FROM ecommerceframework_pricing_rule WHERE id='6'
Parameters:
[]
81 3.42 ms
SELECT * FROM ecommerceframework_pricing_rule WHERE id='7'
Parameters:
[]
82 0.77 ms
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
Parameters:
[
  1795065095
  [
    "object_399"
  ]
]
83 2.73 ms
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
Parameters:
[
  1795065095
  [
    "object_873"
  ]
]
84 2.34 ms
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
Parameters:
[
  1795065095
  [
    "object_365"
  ]
]
85 1.55 ms
SELECT * FROM object_relations_AP WHERE src_id = 456 AND fieldname = 'compatibleTo' AND ownertype = 'object'
Parameters:
[]
86 0.09 ms
SELECT object_localized_CAR_de.o_id as o_id, `object_localized_CAR_de`.`o_type` FROM `object_localized_CAR_de` WHERE ((o_path LIKE "/Product Data/Cars/fiat/500%" AND  object_localized_CAR_de.o_type IN ('object','folder')) AND object_localized_CAR_de.o_published = 1)
Parameters:
[]
87 2.64 ms
SELECT SQL_CALC_FOUND_ROWS a.o_id, priceSystemName FROM shop_productindex a WHERE active = 1 AND o_virtualProductActive = 1 AND inProductList = 1 AND o_type = 'variant' AND (o_id IN (102,104,103,105))
Parameters:
[]
88 0.10 ms
SELECT FOUND_ROWS()
Parameters:
[]
89 0.26 ms
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
Parameters:
[
  1795065095
  [
    "object_102"
  ]
]
90 0.26 ms
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
Parameters:
[
  1795065095
  [
    "object_103"
  ]
]
91 1.77 ms
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
Parameters:
[
  1795065095
  [
    "object_104"
  ]
]
92 3.50 ms
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
Parameters:
[
  1795065095
  [
    "object_105"
  ]
]
93 0.07 ms
SELECT * FROM object_relations_CAR WHERE src_id = 102 AND fieldname = 'manufacturer' AND ownertype = 'object'
Parameters:
[]
94 0.06 ms
SELECT * FROM object_relations_CAR WHERE src_id = 101 AND fieldname = 'manufacturer' AND ownertype = 'object'
Parameters:
[]
95 0.31 ms
SELECT * FROM object_relations_CAR WHERE src_id = 102 AND fieldname = 'categories' AND ownertype = 'object'
Parameters:
[]
96 0.06 ms
SELECT * FROM object_relations_CAR WHERE src_id = 101 AND fieldname = 'categories' AND ownertype = 'object'
Parameters:
[]
97 0.24 ms
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
Parameters:
[
  1795065095
  [
    "object_548"
  ]
]
98 7.07 ms
SELECT * FROM object_relations_CAR WHERE src_id = 103 AND fieldname = 'manufacturer' AND ownertype = 'object'
Parameters:
[]
99 0.08 ms
SELECT * FROM object_relations_CAR WHERE src_id = 103 AND fieldname = 'categories' AND ownertype = 'object'
Parameters:
[]
100 0.07 ms
SELECT * FROM object_relations_CAR WHERE src_id = 104 AND fieldname = 'manufacturer' AND ownertype = 'object'
Parameters:
[]
101 0.06 ms
SELECT * FROM object_relations_CAR WHERE src_id = 104 AND fieldname = 'categories' AND ownertype = 'object'
Parameters:
[]
102 1.77 ms
SELECT * FROM object_relations_CAR WHERE src_id = 105 AND fieldname = 'manufacturer' AND ownertype = 'object'
Parameters:
[]
103 3.65 ms
SELECT * FROM object_relations_CAR WHERE src_id = 105 AND fieldname = 'categories' AND ownertype = 'object'
Parameters:
[]
104 4.76 ms
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
Parameters:
[
  1795065095
  [
    "nav_ed9dc8022e7afa3acab08cd29e0830a0"
  ]
]
105 0.38 ms
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
Parameters:
[
  1795065095
  [
    "translation_data_messages_de"
  ]
]
106 0.11 ms
SELECT sourceId FROM documents_translations WHERE id = ?
Parameters:
[
  136
]
107 0.07 ms
SELECT id,language FROM documents_translations WHERE sourceId IN(?, ?) UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
Parameters:
[
  "3"
  136
  136
]
108 0.06 ms
SELECT id,language FROM documents_translations WHERE sourceId = ? UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
Parameters:
[
  "136"
  "136"
]
109 0.06 ms
SELECT id,language FROM documents_translations WHERE sourceId = ? UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
Parameters:
[
  "3"
  "3"
]
110 0.29 ms
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
Parameters:
[
  1795065095
  [
    "document_3"
  ]
]
111 0.23 ms
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
Parameters:
[
  1795065095
  [
    "document_properties_3"
  ]
]
112 0.13 ms
SELECT id FROM documents WHERE path = :path AND `key` = :key
Parameters:
[
  "key" => "en"
  "path" => "/"
]
113 0.15 ms
SELECT id FROM documents WHERE path = :path AND `key` = :key
Parameters:
[
  "key" => "fr"
  "path" => "/"
]
114 2.74 ms
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
Parameters:
[
  "prettyUrl" => "/fr"
]
115 0.28 ms
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
Parameters:
[
  1795065095
  [
    "nav_f3e9f14d1fa72fd1bf8879d5371f86ba"
  ]
]
116 5.29 ms
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
Parameters:
[
  1795065095
  [
    "imagick_format_webp"
  ]
]
117 1.31 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_89__36f66dc06a09da0de70f14b109ba0418"
]
118 4.61 ms
INSERT INTO `tmp_store` (`id`, `data`, `tag`, `date`, `expiryDate`, `serialized`) VALUES (:col0, :col1, :col2, :col3, :col4, :col5) ON DUPLICATE KEY UPDATE `id` = :col0, `data` = :col1, `tag` = :col2, `date` = :col3, `expiryDate` = :col4, `serialized` = :col5;
Parameters:
[
  ":col0" => "thumb_89__36f66dc06a09da0de70f14b109ba0418"
  ":col1" => "O:42:"Pimcore\Model\Asset\Image\Thumbnail\Config":16:{s:5:"items";a:2:{i:0;a:2:{s:6:"method";s:11:"cropPercent";s:9:"arguments";a:4:{s:5:"width";d:9.8;s:6:"height";d:14.501510574018127;s:1:"y";d:58.91238670694864;s:1:"x";i:48;}}i:1;a:2:{s:6:"method";s:12:"scaleByWidth";s:9:"arguments";a:2:{s:5:"width";i:900;s:11:"forceResize";b:0;}}}s:6:"medias";a:0:{}s:4:"name";s:53:"galleryLightbox_auto_ea79347f2e7ee578d7997d7b8ee45389";s:11:"description";s:0:"";s:5:"group";s:5:"Areas";s:6:"format";s:6:"SOURCE";s:7:"quality";i:85;s:14:"highResolution";d:0;s:13:"preserveColor";b:0;s:16:"preserveMetaData";b:0;s:12:"rasterizeSVG";b:0;s:12:"downloadable";b:0;s:16:"modificationDate";i:1566220948;s:12:"creationDate";i:1563541426;s:14:"filenameSuffix";N;s:15:"forcePictureTag";b:0;}"
  ":col2" => "thumbnail_deferred"
  ":col3" => 1795065095
  ":col4" => 1795669895
  ":col5" => 1
]
119 0.66 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_89__93da377203247b668b024d637cc9a293"
]
120 4.87 ms
INSERT INTO `tmp_store` (`id`, `data`, `tag`, `date`, `expiryDate`, `serialized`) VALUES (:col0, :col1, :col2, :col3, :col4, :col5) ON DUPLICATE KEY UPDATE `id` = :col0, `data` = :col1, `tag` = :col2, `date` = :col3, `expiryDate` = :col4, `serialized` = :col5;
Parameters:
[
  ":col0" => "thumb_89__93da377203247b668b024d637cc9a293"
  ":col1" => "O:42:"Pimcore\Model\Asset\Image\Thumbnail\Config":16:{s:5:"items";a:2:{i:0;a:2:{s:6:"method";s:11:"cropPercent";s:9:"arguments";a:4:{s:5:"width";d:9.8;s:6:"height";d:14.501510574018127;s:1:"y";d:58.91238670694864;s:1:"x";i:48;}}i:1;a:2:{s:6:"method";s:12:"scaleByWidth";s:9:"arguments";a:2:{s:5:"width";i:700;s:11:"forceResize";b:0;}}}s:6:"medias";a:0:{}s:4:"name";s:52:"product_detail_auto_f5dea6896ca02eb0297d750836489b1e";s:11:"description";s:0:"";s:5:"group";s:10:"E-Commerce";s:6:"format";s:6:"SOURCE";s:7:"quality";i:85;s:14:"highResolution";d:0;s:13:"preserveColor";b:0;s:16:"preserveMetaData";b:0;s:12:"rasterizeSVG";b:0;s:12:"downloadable";b:0;s:16:"modificationDate";i:1566220986;s:12:"creationDate";i:1565167920;s:14:"filenameSuffix";N;s:15:"forcePictureTag";b:0;}"
  ":col2" => "thumbnail_deferred"
  ":col3" => 1795065095
  ":col4" => 1795669895
  ":col5" => 1
]
121 0.21 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_89__93da377203247b668b024d637cc9a293"
]
122 1.42 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_89__cb52f568795a7edf78fd6718bd472781"
]
123 4.52 ms
INSERT INTO `tmp_store` (`id`, `data`, `tag`, `date`, `expiryDate`, `serialized`) VALUES (:col0, :col1, :col2, :col3, :col4, :col5) ON DUPLICATE KEY UPDATE `id` = :col0, `data` = :col1, `tag` = :col2, `date` = :col3, `expiryDate` = :col4, `serialized` = :col5;
Parameters:
[
  ":col0" => "thumb_89__cb52f568795a7edf78fd6718bd472781"
  ":col1" => "O:42:"Pimcore\Model\Asset\Image\Thumbnail\Config":16:{s:5:"items";a:2:{i:0;a:2:{s:6:"method";s:11:"cropPercent";s:9:"arguments";a:4:{s:5:"width";d:9.8;s:6:"height";d:14.501510574018127;s:1:"y";d:58.91238670694864;s:1:"x";i:48;}}i:1;a:2:{s:6:"method";s:12:"scaleByWidth";s:9:"arguments";a:2:{s:5:"width";i:700;s:11:"forceResize";b:0;}}}s:6:"medias";a:0:{}s:4:"name";s:52:"product_detail_auto_f5dea6896ca02eb0297d750836489b1e";s:11:"description";s:0:"";s:5:"group";s:10:"E-Commerce";s:6:"format";s:6:"SOURCE";s:7:"quality";i:85;s:14:"highResolution";d:2;s:13:"preserveColor";b:0;s:16:"preserveMetaData";b:0;s:12:"rasterizeSVG";b:0;s:12:"downloadable";b:0;s:16:"modificationDate";i:1566220986;s:12:"creationDate";i:1565167920;s:14:"filenameSuffix";N;s:15:"forcePictureTag";b:0;}"
  ":col2" => "thumbnail_deferred"
  ":col3" => 1795065095
  ":col4" => 1795669895
  ":col5" => 1
]
124 0.37 ms
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
Parameters:
[
  1795065095
  [
    "object_547"
  ]
]
125 0.29 ms
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
Parameters:
[
  1795065095
  [
    "object_390"
  ]
]
126 0.08 ms
SELECT * FROM object_relations_CAR WHERE src_id = 102 AND fieldname = 'bodyStyle' AND ownertype = 'object'
Parameters:
[]
127 0.06 ms
SELECT * FROM object_relations_CAR WHERE src_id = 101 AND fieldname = 'bodyStyle' AND ownertype = 'object'
Parameters:
[]
128 3.66 ms
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
Parameters:
[
  1795065095
  [
    "object_42"
  ]
]
129 3.09 ms
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "BS"
]
130 2.78 ms
SELECT * FROM object_relations_CAR WHERE src_id = 103 AND fieldname = 'bodyStyle' AND ownertype = 'object'
Parameters:
[]
131 6.19 ms
SELECT * FROM object_relations_CAR WHERE src_id = 104 AND fieldname = 'bodyStyle' AND ownertype = 'object'
Parameters:
[]
132 0.09 ms
SELECT * FROM object_relations_CAR WHERE src_id = 105 AND fieldname = 'bodyStyle' AND ownertype = 'object'
Parameters:
[]
133 9.93 ms
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
Parameters:
[
  1795065095
  [
    "document_170"
  ]
]
134 7.44 ms
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
Parameters:
[
  1795065095
  [
    "document_target_groups_170"
  ]
]
135 0.12 ms
SELECT * FROM documents_elements WHERE documentId = ?
Parameters:
[
  170
]
136 9.31 ms
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
Parameters:
[
  1795065095
  [
    "document_properties_170"
  ]
]
137 7.36 ms
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
Parameters:
[
  1795065095
  [
    "document_164"
  ]
]
138 10.23 ms
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
Parameters:
[
  1795065095
  [
    "document_165"
  ]
]
139 13.25 ms
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
Parameters:
[
  1795065095
  [
    "document_151"
  ]
]
140 2.43 ms
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
Parameters:
[
  1795065095
  [
    "document_152"
  ]
]
141 7.00 ms
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
Parameters:
[
  1795065095
  [
    "document_153"
  ]
]
142 7.48 ms
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
Parameters:
[
  1795065095
  [
    "document_154"
  ]
]
143 1.82 ms
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
Parameters:
[
  1795065095
  [
    "document_155"
  ]
]
144 0.31 ms
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
Parameters:
[
  1795065095
  [
    "document_156"
  ]
]
145 9.44 ms
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
Parameters:
[
  1795065095
  [
    "document_48"
  ]
]
146 2.70 ms
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
Parameters:
[
  1795065095
  [
    "document_52"
  ]
]
147 0.37 ms
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
Parameters:
[
  1795065095
  [
    "document_112"
  ]
]
148 13.38 ms
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
Parameters:
[
  1795065095
  [
    "document_49"
  ]
]
149 0.63 ms
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
Parameters:
[
  1795065095
  [
    "document_113"
  ]
]
150 4.46 ms
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
Parameters:
[
  1795065095
  [
    "document_39"
  ]
]
151 10.19 ms
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
Parameters:
[
  1795065095
  [
    "document_50"
  ]
]
152 1.79 ms
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
Parameters:
[
  1795065095
  [
    "document_38"
  ]
]
153 12.25 ms
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
Parameters:
[
  1795065095
  [
    "document_51"
  ]
]
154 2.80 ms
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
Parameters:
[
  1795065095
  [
    "document_95"
  ]
]
155 10.92 ms
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
Parameters:
[
  1795065095
  [
    "document_110"
  ]
]
156 6.38 ms
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
Parameters:
[
  1795065095
  [
    "document_88"
  ]
]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

There are no configured entity managers.

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping