Query Metrics
29
Database Queries
6
Different statements
77.21 ms
Query time
0
Invalid entities
0
Managed entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 6.00 ms |
SELECT id, category_name, category_name_seo, category_image, category_film, category_pdf, description, parent_category_id, level, `timestamp`, show_category, active, fl_alat, category_name_aim, meta_title, meta_description, meta_keywords, created, updated, cache_tree, cache_tree_aim, show_eponuda FROM kategorije WHERE category_name_seo = ? and active = 1
Parameters:
[
"tastature"
]
|
||||||||||||||||||||||||||||||||||
| 2 | 0.27 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:
[ 1780786437 "cache_tree_aim_992" ]
|
||||||||||||||||||||||||||||||||||
| 3 | 8.19 ms |
DELETE FROM cache_items WHERE item_lifetime + item_time <= ? AND item_id IN (?)
Parameters:
[ 1780786437 "cache_tree_aim_992" ]
|
||||||||||||||||||||||||||||||||||
| 4 | 0.47 ms |
SELECT k.id AS category_id, k.category_name, k.category_name_seo, k.category_name_aim, k.category_image FROM kategorije k WHERE k.parent_category_id = ? and k.active = 1 and k.show_category = 1 AND k.fl_alat = 1 UNION ALL (SELECT c1.category_id, c2.category_name, c2.category_name_seo, c2.category_name_aim, c2.category_image FROM kategorije_veze c1, kategorije c2 WHERE c1.category_id = c2.id and c1.parent_category_id = ? and c1.active = 1 and c2.show_category = 1 AND c2.fl_alat = 1) ORDER BY category_name
Parameters:
[ 992 992 ] |
||||||||||||||||||||||||||||||||||
| 5 | 8.41 ms |
INSERT INTO cache_items (item_id, item_data, item_lifetime, item_time) VALUES (?, ?, ?, ?) ON DUPLICATE KEY UPDATE item_data = VALUES(item_data), item_lifetime = VALUES(item_lifetime), item_time = VALUES(item_time)
Parameters:
[ 2 => 3600 3 => 1780786437 0 => "cache_tree_aim_992" 1 => "a:2:{s:13:"subCategories";a:0:{}s:8:"products";a:1:{i:0;a:6:{s:2:"id";s:6:"115886";s:10:"product_id";i:115886;s:4:"name";s:58:"Hama tastatura "CK-100" USB A na USB-C adapt.USB-C to USB-";s:12:"product_name";s:58:"Hama tastatura "CK-100" USB A na USB-C adapt.USB-C to USB-";s:3:"url";s:54:"hama-tastatura-ck-100-usb-a-na-usb-c-adaptusb-c-to-usb";s:4:"path";s:15:"/1/172/205/992/";}}}" ] |
||||||||||||||||||||||||||||||||||
| 6 | 0.21 ms |
SELECT id, category_name, category_name_seo, category_image, category_film, category_pdf, description, parent_category_id, level, `timestamp`, show_category, active, fl_alat, category_name_aim, meta_title, meta_description, meta_keywords, created, updated, show_eponuda FROM kategorije WHERE id = ? and active = 1
Parameters:
[
205
]
|
||||||||||||||||||||||||||||||||||
| 7 | 0.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:
[ 1780786437 "cache_tree_aim_205" ]
|
||||||||||||||||||||||||||||||||||
| 8 | 21.03 ms |
DELETE FROM cache_items WHERE item_lifetime + item_time <= ? AND item_id IN (?)
Parameters:
[ 1780786437 "cache_tree_aim_205" ]
|
||||||||||||||||||||||||||||||||||
| 9 | 0.46 ms |
SELECT k.id AS category_id, k.category_name, k.category_name_seo, k.category_name_aim, k.category_image FROM kategorije k WHERE k.parent_category_id = ? and k.active = 1 and k.show_category = 1 AND k.fl_alat = 1 UNION ALL (SELECT c1.category_id, c2.category_name, c2.category_name_seo, c2.category_name_aim, c2.category_image FROM kategorije_veze c1, kategorije c2 WHERE c1.category_id = c2.id and c1.parent_category_id = ? and c1.active = 1 and c2.show_category = 1 AND c2.fl_alat = 1) ORDER BY category_name
Parameters:
[ 205 205 ] |
||||||||||||||||||||||||||||||||||
| 10 | 0.21 ms |
SELECT k.id AS category_id, k.category_name, k.category_name_seo, k.category_name_aim, k.category_image FROM kategorije k WHERE k.parent_category_id = ? and k.active = 1 and k.show_category = 1 AND k.fl_alat = 1 UNION ALL (SELECT c1.category_id, c2.category_name, c2.category_name_seo, c2.category_name_aim, c2.category_image FROM kategorije_veze c1, kategorije c2 WHERE c1.category_id = c2.id and c1.parent_category_id = ? and c1.active = 1 and c2.show_category = 1 AND c2.fl_alat = 1) ORDER BY category_name
Parameters:
[ 1484 1484 ] |
||||||||||||||||||||||||||||||||||
| 11 | 0.40 ms |
SELECT k.id AS category_id, k.category_name, k.category_name_seo, k.category_name_aim, k.category_image FROM kategorije k WHERE k.parent_category_id = ? and k.active = 1 and k.show_category = 1 AND k.fl_alat = 1 UNION ALL (SELECT c1.category_id, c2.category_name, c2.category_name_seo, c2.category_name_aim, c2.category_image FROM kategorije_veze c1, kategorije c2 WHERE c1.category_id = c2.id and c1.parent_category_id = ? and c1.active = 1 and c2.show_category = 1 AND c2.fl_alat = 1) ORDER BY category_name
Parameters:
[ 869 869 ] |
||||||||||||||||||||||||||||||||||
| 12 | 0.20 ms |
SELECT k.id AS category_id, k.category_name, k.category_name_seo, k.category_name_aim, k.category_image FROM kategorije k WHERE k.parent_category_id = ? and k.active = 1 and k.show_category = 1 AND k.fl_alat = 1 UNION ALL (SELECT c1.category_id, c2.category_name, c2.category_name_seo, c2.category_name_aim, c2.category_image FROM kategorije_veze c1, kategorije c2 WHERE c1.category_id = c2.id and c1.parent_category_id = ? and c1.active = 1 and c2.show_category = 1 AND c2.fl_alat = 1) ORDER BY category_name
Parameters:
[ 1238 1238 ] |
||||||||||||||||||||||||||||||||||
| 13 | 11.79 ms |
INSERT INTO cache_items (item_id, item_data, item_lifetime, item_time) VALUES (?, ?, ?, ?) ON DUPLICATE KEY UPDATE item_data = VALUES(item_data), item_lifetime = VALUES(item_lifetime), item_time = VALUES(item_time)
Parameters:
[ 2 => 3600 3 => 1780786437 0 => "cache_tree_aim_205" 1 => "a:2:{s:13:"subCategories";a:3:{i:0;a:7:{s:11:"category_id";i:1484;s:13:"category_name";s:45:"Baterije-akumulatori za UPS i solarne sisteme";s:17:"category_name_seo";s:45:"baterije-akumulatori-za-ups-i-solarne-sisteme";s:17:"category_name_aim";s:27:"Baterije-akumulatori za UPS";s:14:"category_image";s:19:"1484-1701358023.jpg";s:13:"subCategories";a:0:{}s:8:"products";a:5:{i:0;a:6:{s:2:"id";s:5:"78823";s:10:"product_id";i:78823;s:4:"name";s:33:"Žele akumulator 6V/1,3-Ultracell";s:12:"product_name";s:33:"Žele akumulator 6V/1,3-Ultracell";s:3:"url";s:30:"zele-akumulator-6v13-ultracell";s:4:"path";s:15:"/1/29/311/1484/";}i:1;a:6:{s:2:"id";s:6:"111384";s:10:"product_id";i:111384;s:4:"name";s:30:"Baterija 6V 1.2Ah WP1.2-6 LONG";s:12:"product_name";s:30:"Baterija 6V 1.2Ah WP1.2-6 LONG";s:3:"url";s:28:"baterija-6v-12ah-wp12-6-long";s:4:"path";s:15:"/1/29/311/1484/";}i:2;a:6:{s:2:"id";s:6:"108986";s:10:"product_id";i:108986;s:4:"name";s:37:"Baterija Long WPS4-6 6V 4Ah Kung Long";s:12:"product_name";s:37:"Baterija Long WPS4-6 6V 4Ah Kung Long";s:3:"url";s:37:"baterija-long-wps4-6-6v-4ah-kung-long";s:4:"path";s:15:"/1/29/311/1484/";}i:3;a:6:{s:2:"id";s:6:"108996";s:10:"product_id";i:108996;s:4:"name";s:34:"Baterija LP6-4,5 6V 4,5Ah Landport";s:12:"product_name";s:34:"Baterija LP6-4,5 6V 4,5Ah Landport";s:3:"url";s:32:"baterija-lp6-45-6v-45ah-landport";s:4:"path";s:15:"/1/29/311/1484/";}i:4;a:6:{s:2:"id";s:5:"78822";s:10:"product_id";i:78822;s:4:"name";s:33:"Žele akumulator 6V/4,5-Ultracell";s:12:"product_name";s:33:"Žele akumulator 6V/4,5-Ultracell";s:3:"url";s:30:"zele-akumulator-6v45-ultracell";s:4:"path";s:15:"/1/29/311/1484/";}}}i:1;a:7:{s:11:"category_id";i:869;s:13:"category_name";s:20:"Kablovi za računare";s:17:"category_name_seo";s:19:"kablovi-za-racunare";s:17:"category_name_aim";s:20:"Kablovi za računare";s:14:"category_image";s:18:"869-1675254116.jpg";s:13:"subCategories";a:5:{i:0;a:5:{s:11:"category_id";i:875;s:13:"category_name";s:12:"HDMI kablovi";s:17:"category_name_seo";s:12:"hdmi-kablovi";s:17:"category_name_aim";s:12:"HDMI kablovi";s:14:"category_image";s:18:"875-1675428358.jpg";}i:1;a:5:{s:11:"category_id";i:874;s:13:"category_name";s:19:"LAN-mrežni kablovi";s:17:"category_name_seo";s:18:"lan-mrezni-kablovi";s:17:"category_name_aim";s:19:"LAN-mrežni kablovi";s:14:"category_image";s:18:"874-1675428741.jpg";}i:2;a:5:{s:11:"category_id";i:872;s:13:"category_name";s:13:"Scart kablovi";s:17:"category_name_seo";s:13:"scart-kablovi";s:17:"category_name_aim";s:13:"Scart kablovi";s:14:"category_image";s:18:"872-1675428553.jpg";}i:3;a:5:{s:11:"category_id";i:871;s:13:"category_name";s:11:"USB kablovi";s:17:"category_name_seo";s:11:"usb-kablovi";s:17:"category_name_aim";s:11:"USB kablovi";s:14:"category_image";s:18:"871-1671746420.jpg";}i:4;a:5:{s:11:"category_id";i:870;s:13:"category_name";s:11:"VGA kablovi";s:17:"category_name_seo";s:11:"vga-kablovi";s:17:"category_name_aim";s:11:"VGA kablovi";s:14:"category_image";s:18:"870-1675428196.jpg";}}s:8:"products";a:0:{}}i:2;a:7:{s:11:"category_id";i:1238;s:13:"category_name";s:30:"Produžni kablovi sa zaštitom";s:17:"category_name_seo";s:28:"produzni-kablovi-sa-zastitom";s:17:"category_name_aim";s:30:"Produžni kablovi sa zaštitom";s:14:"category_image";s:19:"1238-1671745615.jpg";s:13:"subCategories";a:0:{}s:8:"products";a:5:{i:0;a:6:{s:2:"id";s:5:"95175";s:10:"product_id";i:95175;s:4:"name";s:93:"GEMBIRD Produžni kabl sa prenaponskom zaštitom SPG6-B-6 (3G1.5) – 6 utičnica, 1.8m, crni";s:12:"product_name";s:93:"GEMBIRD Produžni kabl sa prenaponskom zaštitom SPG6-B-6 (3G1.5) – 6 utičnica, 1.8m, crni";s:3:"url";s:80:"gembird-produzni-kabl-sa-prenaponskom-zastitom-spg6-b-6-3g15-6-uticnica-18m-crni";s:4:"path";s:15:"/1/29/311/1238/";}i:1;a:6:{s:2:"id";s:5:"50049";s:10:"product_id";i:50049;s:4:"name";s:92:"GEMBIRD Produžni kabl sa prenaponskom zaštitom SPG6-B-10 (3G1.5) – 6 utičnica, 3m, crni";s:12:"product_name";s:92:"GEMBIRD Produžni kabl sa prenaponskom zaštitom SPG6-B-10 (3G1.5) – 6 utičnica, 3m, crni";s:3:"url";s:80:"gembird-produzni-kabl-sa-prenaponskom-zastitom-spg6-b-10-3g15-6-uticnica-3m-crni";s:4:"path";s:15:"/1/29/311/1238/";}i:2;a:6:{s:2:"id";s:5:"50050";s:10:"product_id";i:50050;s:4:"name";s:94:"GEMBIRD Produžni kabl sa prenaponskom zaštitom SPG6-B-15 (3G1.0) – 6 utičnica, 4,5m, crni";s:12:"product_name";s:94:"GEMBIRD Produžni kabl sa prenaponskom zaštitom SPG6-B-15 (3G1.0) – 6 utičnica, 4,5m, crni";s:3:"url";s:81:"gembird-produzni-kabl-sa-prenaponskom-zastitom-spg6-b-15-3g10-6-uticnica-45m-crni";s:4:"path";s:15:"/1/29/311/1238/";}i:3;a:6:{s:2:"id";s:5:"67121";s:10:"product_id";i:67121;s:4:"name";s:65:"Produžni kabli sa prenaponskom zaštitom 5 utičnica 1.4m BEOROL";s:12:"product_name";s:65:"Produžni kabli sa prenaponskom zaštitom 5 utičnica 1.4m BEOROL";s:3:"url";s:61:"produzni-kabli-sa-prenaponskom-zastitom-5-uticnica-14m-beorol";s:4:"path";s:15:"/1/29/311/1238/";}i:4;a:6:{s:2:"id";s:5:"67124";s:10:"product_id";i:67124;s:4:"name";s:65:"Produžni kabli sa prenaponskom zaštitom 7 utičnica 1.4m BEOROL";s:12:"product_name";s:65:"Produžni kabli sa prenaponskom zaštitom 7 utičnica 1.4m BEOROL";s:3:"url";s:61:"produzni-kabli-sa-prenaponskom-zastitom-7-uticnica-14m-beorol";s:4:"path";s:15:"/1/29/311/1238/";}}}}s:8:"products";a:0:{}}" ] |
||||||||||||||||||||||||||||||||||
| 14 | 0.37 ms |
SELECT id, category_name, category_name_seo, category_image, category_film, category_pdf, description, parent_category_id, level, `timestamp`, show_category, active, fl_alat, category_name_aim, meta_title, meta_description, meta_keywords, created, updated, show_eponuda FROM kategorije WHERE id = ? and active = 1
Parameters:
[
172
]
|
||||||||||||||||||||||||||||||||||
| 15 | 0.18 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:
[ 1780786437 "cache_tree_aim_172" ] |
||||||||||||||||||||||||||||||||||
| 16 | 8.00 ms |
DELETE FROM cache_items WHERE item_lifetime + item_time <= ? AND item_id IN (?)
Parameters:
[ 1780786437 "cache_tree_aim_172" ] |
||||||||||||||||||||||||||||||||||
| 17 | 0.66 ms |
SELECT k.id AS category_id, k.category_name, k.category_name_seo, k.category_name_aim, k.category_image FROM kategorije k WHERE k.parent_category_id = ? and k.active = 1 and k.show_category = 1 AND k.fl_alat = 1 UNION ALL (SELECT c1.category_id, c2.category_name, c2.category_name_seo, c2.category_name_aim, c2.category_image FROM kategorije_veze c1, kategorije c2 WHERE c1.category_id = c2.id and c1.parent_category_id = ? and c1.active = 1 and c2.show_category = 1 AND c2.fl_alat = 1) ORDER BY category_name
Parameters:
[ 172 172 ] |
||||||||||||||||||||||||||||||||||
| 18 | 0.37 ms |
SELECT k.id AS category_id, k.category_name, k.category_name_seo, k.category_name_aim, k.category_image FROM kategorije k WHERE k.parent_category_id = ? and k.active = 1 and k.show_category = 1 AND k.fl_alat = 1 UNION ALL (SELECT c1.category_id, c2.category_name, c2.category_name_seo, c2.category_name_aim, c2.category_image FROM kategorije_veze c1, kategorije c2 WHERE c1.category_id = c2.id and c1.parent_category_id = ? and c1.active = 1 and c2.show_category = 1 AND c2.fl_alat = 1) ORDER BY category_name
Parameters:
[ 869 869 ] |
||||||||||||||||||||||||||||||||||
| 19 | 7.93 ms |
INSERT INTO cache_items (item_id, item_data, item_lifetime, item_time) VALUES (?, ?, ?, ?) ON DUPLICATE KEY UPDATE item_data = VALUES(item_data), item_lifetime = VALUES(item_lifetime), item_time = VALUES(item_time)
Parameters:
[ 2 => 3600 3 => 1780786437 0 => "cache_tree_aim_172" 1 => "a:2:{s:13:"subCategories";a:1:{i:0;a:7:{s:11:"category_id";i:869;s:13:"category_name";s:20:"Kablovi za računare";s:17:"category_name_seo";s:19:"kablovi-za-racunare";s:17:"category_name_aim";s:20:"Kablovi za računare";s:14:"category_image";s:18:"869-1675254116.jpg";s:13:"subCategories";a:5:{i:0;a:5:{s:11:"category_id";i:875;s:13:"category_name";s:12:"HDMI kablovi";s:17:"category_name_seo";s:12:"hdmi-kablovi";s:17:"category_name_aim";s:12:"HDMI kablovi";s:14:"category_image";s:18:"875-1675428358.jpg";}i:1;a:5:{s:11:"category_id";i:874;s:13:"category_name";s:19:"LAN-mrežni kablovi";s:17:"category_name_seo";s:18:"lan-mrezni-kablovi";s:17:"category_name_aim";s:19:"LAN-mrežni kablovi";s:14:"category_image";s:18:"874-1675428741.jpg";}i:2;a:5:{s:11:"category_id";i:872;s:13:"category_name";s:13:"Scart kablovi";s:17:"category_name_seo";s:13:"scart-kablovi";s:17:"category_name_aim";s:13:"Scart kablovi";s:14:"category_image";s:18:"872-1675428553.jpg";}i:3;a:5:{s:11:"category_id";i:871;s:13:"category_name";s:11:"USB kablovi";s:17:"category_name_seo";s:11:"usb-kablovi";s:17:"category_name_aim";s:11:"USB kablovi";s:14:"category_image";s:18:"871-1671746420.jpg";}i:4;a:5:{s:11:"category_id";i:870;s:13:"category_name";s:11:"VGA kablovi";s:17:"category_name_seo";s:11:"vga-kablovi";s:17:"category_name_aim";s:11:"VGA kablovi";s:14:"category_image";s:18:"870-1675428196.jpg";}}s:8:"products";a:0:{}}}s:8:"products";a:0:{}}" ] |
||||||||||||||||||||||||||||||||||
| 20 | 0.39 ms |
SELECT id, category_name, category_name_seo, category_image, category_film, category_pdf, description, parent_category_id, level, `timestamp`, show_category, active, fl_alat, category_name_aim, meta_title, meta_description, meta_keywords, created, updated, show_eponuda FROM kategorije WHERE id = ? and active = 1
Parameters:
[
1
]
|
||||||||||||||||||||||||||||||||||
| 21 | 0.31 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:
[ 1780786437 "cache_tree_aim_1" ] |
||||||||||||||||||||||||||||||||||
| 22 | 0.23 ms |
SELECT id, category_name, category_name_seo, category_image, category_film, category_pdf, description, parent_category_id, level, `timestamp`, show_category, active, fl_alat, category_name_aim, meta_title, meta_description, meta_keywords, created, updated, show_eponuda FROM kategorije WHERE id = ? and active = 1
Parameters:
[
1
]
|
||||||||||||||||||||||||||||||||||
| 23 | 0.21 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:
[ 1780786437 "cache_tree_aim_1" ] |
||||||||||||||||||||||||||||||||||
| 24 | 0.20 ms |
SELECT id, category_name, category_name_seo, category_image, category_film, category_pdf, description, parent_category_id, level, `timestamp`, show_category, active, fl_alat, category_name_aim, meta_title, meta_description, meta_keywords, created, updated, show_eponuda FROM kategorije WHERE id = ? and active = 1
Parameters:
[
172
]
|
||||||||||||||||||||||||||||||||||
| 25 | 0.14 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:
[ 1780786437 "cache_tree_aim_172" ] |
||||||||||||||||||||||||||||||||||
| 26 | 0.12 ms |
SELECT id, category_name, category_name_seo, category_image, category_film, category_pdf, description, parent_category_id, level, `timestamp`, show_category, active, fl_alat, category_name_aim, meta_title, meta_description, meta_keywords, created, updated, show_eponuda FROM kategorije WHERE id = ? and active = 1
Parameters:
[
1
]
|
||||||||||||||||||||||||||||||||||
| 27 | 0.11 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:
[ 1780786437 "cache_tree_aim_1" ] |
||||||||||||||||||||||||||||||||||
| 28 | 0.15 ms |
SELECT id, category_name, category_name_seo, category_image, category_film, category_pdf, description, parent_category_id, level, `timestamp`, show_category, active, fl_alat, category_name_aim, meta_title, meta_description, meta_keywords, created, updated, show_eponuda FROM kategorije WHERE id = ? and active = 1
Parameters:
[
1
]
|
||||||||||||||||||||||||||||||||||
| 29 | 0.12 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:
[ 1780786437 "cache_tree_aim_1" ] |
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.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|
Entities Mapping
No loaded entities.