Query Metrics

117 Database Queries
27 Different statements
75.71 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.62 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[
  1719431955
  "site_domain_c1114a657c638166de0c8066ae0059b4"
]
2 0.52 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?)
Parameters:
[
  1719431955
  "system\x01tags\x01"
  "site\x01tags\x01"
]
3 0.52 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "BUNDLE_INSTALLED__Pimcore\Bundle\SeoBundle\PimcoreSeoBundle"
  "pimcore"
]
4 0.65 ms
SELECT * FROM redirects WHERE
            (
                (source = ? AND (`type` = ? OR `type` = ?)) OR
                (source = ? AND `type` = ?) OR
                (source = ? AND `type` = ?)
            ) AND active = 1 AND (regex IS NULL OR regex = 0) AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND sourceSite IS NULL AND priority = 99 ORDER BY `priority` DESC
Parameters:
[
  "/ar/منتجات/حليب-مبخر-أصلي-170-غ"
  "path"
  "auto_create"
  "/ar/منتجات/حليب-مبخر-أصلي-170-غ"
  "path_query"
  "http://www.rainbowmilk.com/ar/منتجات/حليب-مبخر-أصلي-170-غ"
  "entire_uri"
]
5 0.45 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[
  1719431955
  "system_route_redirect"
]
6 0.47 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?)
Parameters:
[
  1719431955
  "system\x01tags\x01"
  "redirect\x01tags\x01"
  "route\x01tags\x01"
]
7 0.47 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "maintenance_mode"
]
8 0.46 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[
  1719431955
  "output_5bc1f777ac3ba1fe8c5a8506872beaaf_phone"
]
9 0.47 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[
  1719431955
  "\x00tags\x00output_5bc1f777ac3ba1fe8c5a8506872beaaf_phone"
]
10 0.51 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[
  1719431955
  "output_5bc1f777ac3ba1fe8c5a8506872beaaf"
]
11 0.44 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[
  1719431955
  "\x00tags\x00output_5bc1f777ac3ba1fe8c5a8506872beaaf"
]
12 0.43 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "reports"
  "pimcore"
]
13 0.51 ms
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[
  "/ar/منتجات/"
  "حليب-مبخر-أصلي-170-غ"
]
14 0.46 ms
SELECT id FROM documents_page WHERE prettyUrl = ?
Parameters:
[
  "/ar/منتجات/حليب-مبخر-أصلي-170-غ"
]
15 0.51 ms
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[
  "/ar/منتجات/"
  "حليب-مبخر-أصلي-170-غ"
]
16 0.44 ms
SELECT id FROM documents_page WHERE prettyUrl = ?
Parameters:
[
  "/ar/منتجات/حليب-مبخر-أصلي-170-غ"
]
17 0.44 ms
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[
  "/ar/"
  "منتجات"
]
18 0.47 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[
  1719431955
  "document_101"
]
19 0.46 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?)
Parameters:
[
  1719431955
  "document_101\x01tags\x01"
  "asset_4926\x01tags\x01"
]
20 0.44 ms
SELECT * FROM object_url_slugs WHERE slug = '/ar/منتجات/حليب-مبخر-أصلي-170-غ' AND siteId = 0 ORDER BY siteId DESC LIMIT 1
Parameters:
[]
21 0.45 ms
SELECT id FROM settings_store WHERE scope = ?
Parameters:
[
  "pimcore_staticroutes"
]
22 0.49 ms
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[
  "/ar/منتجات/"
  "حليب-مبخر-أصلي-170-غ"
]
23 0.45 ms
SELECT id FROM documents_page WHERE prettyUrl = ?
Parameters:
[
  "/ar/منتجات/حليب-مبخر-أصلي-170-غ"
]
24 0.49 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[
  1719431955
  "document_properties_101"
]
25 0.50 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?)
Parameters:
[
  1719431955
  "document_properties\x01tags\x01"
  "document_101\x01tags\x01"
]
26 1.22 ms
SELECT object_localized_14_ar.id AS id, object_localized_14_ar.type AS `type` FROM object_localized_14_ar WHERE (url IN (?) AND  object_localized_14_ar.type IN ('object','variant','folder')) AND object_localized_14_ar.published = 1
Parameters:
[
  "حليب-مبخر-أصلي-170-غ"
]
27 0.79 ms
SELECT COUNT(*) FROM object_localized_14_ar WHERE (url IN (?) AND  object_localized_14_ar.type IN ('object','variant','folder')) AND object_localized_14_ar.published = 1
Parameters:
[
  "حليب-مبخر-أصلي-170-غ"
]
28 1.03 ms
SELECT object_localized_12_ar.id AS id, object_localized_12_ar.type AS `type` FROM object_localized_12_ar WHERE (url IN (?) AND  object_localized_12_ar.type IN ('object','variant','folder')) AND object_localized_12_ar.published = 1
Parameters:
[
  "حليب-مبخر-أصلي-170-غ"
]
29 0.97 ms
SELECT COUNT(*) FROM object_localized_12_ar WHERE (url IN (?) AND  object_localized_12_ar.type IN ('object','variant','folder')) AND object_localized_12_ar.published = 1
Parameters:
[
  "حليب-مبخر-أصلي-170-غ"
]
30 0.91 ms
SELECT object_localized_23_ar.id AS id, object_localized_23_ar.type AS `type` FROM object_localized_23_ar WHERE (url IN (?) AND  object_localized_23_ar.type IN ('object','variant','folder')) AND object_localized_23_ar.published = 1
Parameters:
[
  "حليب-مبخر-أصلي-170-غ"
]
31 0.54 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[
  1719431955
  "object_12688"
]
32 0.46 ms
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "23"
]
33 0.64 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?)
Parameters:
[
  1719431955
  "object_12688\x01tags\x01"
  "class_23\x01tags\x01"
]
34 0.54 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[
  1719431955
  "object_12692"
]
35 0.46 ms
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "12"
]
36 0.47 ms
SELECT id FROM targeting_target_groups ORDER BY `name` ASC
Parameters:
[]
37 0.45 ms
SELECT * FROM targeting_target_groups WHERE id = ?
Parameters:
[
  4
]
38 0.42 ms
SELECT * FROM targeting_target_groups WHERE id = ?
Parameters:
[
  13
]
39 0.43 ms
SELECT * FROM targeting_target_groups WHERE id = ?
Parameters:
[
  12
]
40 0.45 ms
SELECT * FROM targeting_target_groups WHERE id = ?
Parameters:
[
  5
]
41 0.42 ms
SELECT * FROM targeting_target_groups WHERE id = ?
Parameters:
[
  21
]
42 0.41 ms
SELECT * FROM targeting_target_groups WHERE id = ?
Parameters:
[
  6
]
43 0.40 ms
SELECT * FROM targeting_target_groups WHERE id = ?
Parameters:
[
  11
]
44 0.41 ms
SELECT * FROM targeting_target_groups WHERE id = ?
Parameters:
[
  16
]
45 0.44 ms
SELECT * FROM targeting_target_groups WHERE id = ?
Parameters:
[
  7
]
46 0.43 ms
SELECT * FROM targeting_target_groups WHERE id = ?
Parameters:
[
  17
]
47 0.42 ms
SELECT * FROM targeting_target_groups WHERE id = ?
Parameters:
[
  8
]
48 0.42 ms
SELECT * FROM targeting_target_groups WHERE id = ?
Parameters:
[
  20
]
49 0.43 ms
SELECT * FROM targeting_target_groups WHERE id = ?
Parameters:
[
  10
]
50 0.43 ms
SELECT * FROM targeting_target_groups WHERE id = ?
Parameters:
[
  19
]
51 0.42 ms
SELECT * FROM targeting_target_groups WHERE id = ?
Parameters:
[
  22
]
52 0.43 ms
SELECT * FROM targeting_target_groups WHERE id = ?
Parameters:
[
  18
]
53 0.46 ms
SELECT * FROM targeting_target_groups WHERE id = ?
Parameters:
[
  9
]
54 0.49 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?, ?)
Parameters:
[
  1719431955
  "object_12692\x01tags\x01"
  "class_12\x01tags\x01"
  "asset_6861\x01tags\x01"
  "asset_6566\x01tags\x01"
]
55 2.10 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[
  1719431955
  "object_12548"
]
56 0.43 ms
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "43"
]
57 0.73 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  1719431955
  "object_12548\x01tags\x01"
  "class_43\x01tags\x01"
  "asset_7069\x01tags\x01"
  "asset_5565\x01tags\x01"
  "asset_5647\x01tags\x01"
  "asset_5649\x01tags\x01"
  "asset_6431\x01tags\x01"
  "asset_6452\x01tags\x01"
]
58 1.52 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[
  1719431955
  "object_12568"
]
59 0.50 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  1719431955
  "object_12568\x01tags\x01"
  "class_43\x01tags\x01"
  "asset_7084\x01tags\x01"
  "asset_7100\x01tags\x01"
  "asset_5706\x01tags\x01"
  "asset_5664\x01tags\x01"
  "asset_6443\x01tags\x01"
  "asset_6463\x01tags\x01"
]
60 1.34 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[
  1719431955
  "object_12576"
]
61 0.49 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  1719431955
  "object_12576\x01tags\x01"
  "class_43\x01tags\x01"
  "asset_7076\x01tags\x01"
  "asset_5567\x01tags\x01"
  "asset_5695\x01tags\x01"
  "asset_5657\x01tags\x01"
  "asset_6437\x01tags\x01"
  "asset_6459\x01tags\x01"
]
62 1.33 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[
  1719431955
  "object_12577"
]
63 0.51 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  1719431955
  "object_12577\x01tags\x01"
  "class_43\x01tags\x01"
  "asset_7091\x01tags\x01"
  "asset_5568\x01tags\x01"
  "asset_5710\x01tags\x01"
  "asset_5666\x01tags\x01"
  "asset_6449\x01tags\x01"
  "asset_6470\x01tags\x01"
]
64 1.59 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[
  1719431955
  "object_12592"
]
65 0.54 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  1719431955
  "object_12592\x01tags\x01"
  "class_43\x01tags\x01"
  "asset_7093\x01tags\x01"
  "asset_5223\x01tags\x01"
  "asset_5709\x01tags\x01"
  "asset_5668\x01tags\x01"
  "asset_6448\x01tags\x01"
  "asset_6469\x01tags\x01"
]
66 1.15 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[
  1719431955
  "object_12600"
]
67 0.52 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  1719431955
  "object_12600\x01tags\x01"
  "class_43\x01tags\x01"
  "asset_7075\x01tags\x01"
  "asset_5570\x01tags\x01"
  "asset_5694\x01tags\x01"
  "asset_5654\x01tags\x01"
  "asset_6433\x01tags\x01"
  "asset_6456\x01tags\x01"
]
68 1.23 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[
  1719431955
  "object_12618"
]
69 0.51 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  1719431955
  "object_12618\x01tags\x01"
  "class_43\x01tags\x01"
  "asset_7074\x01tags\x01"
  "asset_7101\x01tags\x01"
  "asset_5699\x01tags\x01"
  "asset_5653\x01tags\x01"
  "asset_6436\x01tags\x01"
  "asset_6454\x01tags\x01"
]
70 0.84 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[
  1719431955
  "object_12625"
]
71 0.53 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  1719431955
  "object_12625\x01tags\x01"
  "class_43\x01tags\x01"
  "asset_7082\x01tags\x01"
  "asset_5573\x01tags\x01"
  "asset_5698\x01tags\x01"
  "asset_6434\x01tags\x01"
  "asset_6457\x01tags\x01"
]
72 1.17 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[
  1719431955
  "object_12619"
]
73 0.54 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  1719431955
  "object_12619\x01tags\x01"
  "class_43\x01tags\x01"
  "asset_7098\x01tags\x01"
  "asset_5574\x01tags\x01"
  "asset_5711\x01tags\x01"
  "asset_5667\x01tags\x01"
  "asset_6446\x01tags\x01"
  "asset_6467\x01tags\x01"
]
74 0.90 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[
  1719431955
  "object_12623"
]
75 0.54 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  1719431955
  "object_12623\x01tags\x01"
  "class_43\x01tags\x01"
  "asset_7095\x01tags\x01"
  "asset_5575\x01tags\x01"
  "asset_5707\x01tags\x01"
  "asset_6435\x01tags\x01"
  "asset_6466\x01tags\x01"
]
76 1.38 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[
  1719431955
  "object_12667"
]
77 0.53 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  1719431955
  "object_12667\x01tags\x01"
  "class_43\x01tags\x01"
  "asset_7080\x01tags\x01"
  "asset_5583\x01tags\x01"
  "asset_5704\x01tags\x01"
  "asset_5669\x01tags\x01"
  "asset_6444\x01tags\x01"
  "asset_6464\x01tags\x01"
]
78 1.16 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[
  1719431955
  "object_12678"
]
79 0.60 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  1719431955
  "object_12678\x01tags\x01"
  "class_43\x01tags\x01"
  "asset_7073\x01tags\x01"
  "asset_5584\x01tags\x01"
  "asset_5692\x01tags\x01"
  "asset_5652\x01tags\x01"
  "asset_6445\x01tags\x01"
  "asset_6465\x01tags\x01"
]
80 1.08 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[
  1719431955
  "object_12672"
]
81 0.60 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  1719431955
  "object_12672\x01tags\x01"
  "class_43\x01tags\x01"
  "asset_7071\x01tags\x01"
  "asset_5585\x01tags\x01"
  "asset_5696\x01tags\x01"
  "asset_5650\x01tags\x01"
  "asset_6440\x01tags\x01"
  "asset_6455\x01tags\x01"
]
82 1.33 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[
  1719431955
  "object_12677"
]
83 0.56 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  1719431955
  "object_12677\x01tags\x01"
  "class_43\x01tags\x01"
  "asset_7085\x01tags\x01"
  "asset_5586\x01tags\x01"
  "asset_5702\x01tags\x01"
  "asset_5661\x01tags\x01"
  "asset_6441\x01tags\x01"
  "asset_6461\x01tags\x01"
]
84 0.62 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[
  1719431955
  "object_12852"
]
85 0.58 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  1719431955
  "object_12852\x01tags\x01"
  "class_43\x01tags\x01"
  "asset_7081\x01tags\x01"
  "asset_5895\x01tags\x01"
  "asset_5856\x01tags\x01"
  "asset_5855\x01tags\x01"
  "asset_6534\x01tags\x01"
  "asset_6539\x01tags\x01"
  "asset_6553\x01tags\x01"
  "asset_6555\x01tags\x01"
  "asset_6557\x01tags\x01"
  "asset_6558\x01tags\x01"
  "asset_6556\x01tags\x01"
  "asset_6559\x01tags\x01"
  "asset_6554\x01tags\x01"
  "asset_6547\x01tags\x01"
  "asset_6548\x01tags\x01"
]
86 1.96 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[
  1719431955
  "object_12908"
]
87 0.59 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  1719431955
  "object_12908\x01tags\x01"
  "class_43\x01tags\x01"
  "asset_7087\x01tags\x01"
  "asset_6370\x01tags\x01"
  "asset_6333\x01tags\x01"
  "asset_6332\x01tags\x01"
  "asset_6535\x01tags\x01"
  "asset_6538\x01tags\x01"
  "asset_6387\x01tags\x01"
  "asset_6389\x01tags\x01"
  "asset_6386\x01tags\x01"
  "asset_6388\x01tags\x01"
  "asset_6390\x01tags\x01"
  "asset_6549\x01tags\x01"
  "asset_6550\x01tags\x01"
]
88 0.62 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[
  1719431955
  "object_12902"
]
89 0.60 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  1719431955
  "object_12902\x01tags\x01"
  "class_43\x01tags\x01"
  "asset_7089\x01tags\x01"
  "asset_6339\x01tags\x01"
  "asset_6342\x01tags\x01"
  "asset_6341\x01tags\x01"
  "asset_6536\x01tags\x01"
  "asset_6537\x01tags\x01"
  "asset_6391\x01tags\x01"
  "asset_6397\x01tags\x01"
  "asset_6393\x01tags\x01"
  "asset_6394\x01tags\x01"
  "asset_6392\x01tags\x01"
  "asset_6396\x01tags\x01"
  "asset_6395\x01tags\x01"
  "asset_6551\x01tags\x01"
  "asset_6552\x01tags\x01"
]
90 0.85 ms
SELECT object_44.id AS id, object_44.type AS `type` FROM object_44 WHERE (recipe_id__id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND  object_44.type IN ('object','variant','folder')) AND object_44.published = 1 LIMIT 4
Parameters:
[
  12548
  12568
  12576
  12577
  12592
  12600
  12618
  12625
  12619
  12623
  12667
  12678
  12672
  12677
  12852
  12908
  12902
]
91 0.48 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[
  1719431955
  "object_13052"
]
92 0.57 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?)
Parameters:
[
  1719431955
  "object_13052\x01tags\x01"
  "class_44\x01tags\x01"
]
93 0.50 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[
  1719431955
  "object_13053"
]
94 0.46 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?)
Parameters:
[
  1719431955
  "object_13053\x01tags\x01"
  "class_44\x01tags\x01"
]
95 0.50 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[
  1719431955
  "object_13054"
]
96 0.47 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?)
Parameters:
[
  1719431955
  "object_13054\x01tags\x01"
  "class_44\x01tags\x01"
]
97 0.48 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[
  1719431955
  "object_13055"
]
98 0.45 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?)
Parameters:
[
  1719431955
  "object_13055\x01tags\x01"
  "class_44\x01tags\x01"
]
99 0.51 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[
  1719431955
  "object_12691"
]
100 0.47 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[
  1719431955
  "object_12691\x01tags\x01"
]
101 0.48 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[
  1719431955
  "object_11842"
]
102 0.46 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[
  1719431955
  "object_11842\x01tags\x01"
]
103 0.47 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[
  1719431955
  "object_1"
]
104 0.45 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[
  1719431955
  "object_1\x01tags\x01"
]
105 0.46 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "BUNDLE_INSTALLED__Pimcore\Bundle\SeoBundle\PimcoreSeoBundle"
  "pimcore"
]
106 0.50 ms
SELECT date FROM http_error_log WHERE uri = ?
Parameters:
[
  "http://www.rainbowmilk.com/ar/%D9%85%D9%86%D8%AA%D8%AC%D8%A7%D8%AA/%D8%AD%D9%84%D9%8A%D8%A8-%D9%85%D8%A8%D8%AE%D8%B1-%D8%A3%D8%B5%D9%84%D9%8A-170-%D8%BA"
]
107 2.69 ms
UPDATE http_error_log SET `count` = `count` + 1, date = ? WHERE uri = ?
Parameters:
[
  1719431955
  "http://www.rainbowmilk.com/ar/%D9%85%D9%86%D8%AA%D8%AC%D8%A7%D8%AA/%D8%AD%D9%84%D9%8A%D8%A8-%D9%85%D8%A8%D8%AE%D8%B1-%D8%A3%D8%B5%D9%84%D9%8A-170-%D8%BA"
]
108 0.48 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "BUNDLE_INSTALLED__Pimcore\Bundle\SeoBundle\PimcoreSeoBundle"
  "pimcore"
]
109 0.59 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[
  1719431955
  "sites_path_mapping"
]
110 0.49 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[
  1719431955
  "\x00tags\x00sites_path_mapping"
]
111 0.56 ms
SELECT id FROM sites ORDER BY (SELECT LENGTH(`path`) FROM documents WHERE documents.id = sites.rootId) DESC
Parameters:
[]
112 0.47 ms
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[
  "/ar/"
  "server-error"
]
113 0.49 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[
  1719431955
  "document_128"
]
114 0.46 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[
  1719431955
  "document_128\x01tags\x01"
]
115 0.52 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[
  1719431955
  "document_properties_128"
]
116 0.52 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "BUNDLE_INSTALLED__Pimcore\Bundle\SeoBundle\PimcoreSeoBundle"
  "pimcore"
]
117 0.71 ms
SELECT * FROM redirects WHERE
            (
                (source = ? AND (`type` = ? OR `type` = ?)) OR
                (source = ? AND `type` = ?) OR
                (source = ? AND `type` = ?)
            ) AND active = 1 AND (regex IS NULL OR regex = 0) AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND sourceSite IS NULL AND priority = 99 ORDER BY `priority` DESC
Parameters:
[
  "/_fragment"
  "path"
  "auto_create"
  "/_fragment?_path=_locale=ar&_format=html&_controller=App%5CController%5CContentController%3A%3AdefaultAction"
  "path_query"
  "http://www.rainbowmilk.com/_fragment?_path=_locale=ar&_format=html&_controller=App%5CController%5CContentController%3A%3AdefaultAction"
  "entire_uri"
]

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

No mapped entities.