GET https://dev.alatiimasine.com/proizvodjaci/6

Query Metrics

8 Database Queries
8 Different statements
20.89 ms Query time
0 Invalid entities
0 Managed entities

Queries

Group similar statements

# Time Info
1 0.23 ms
SELECT page_title, page_meta_description, page_meta_keywords, web_page
	        FROM website_tags
	        WHERE website = ? and web_page IN (?, ?)
Parameters:
[
  2
  "brendovi"
  "ostale"
]
2 0.78 ms
SELECT COUNT(*) FROM proizvodjaci WHERE active = 1 AND show_brand = 1 AND num_of_products_aim > 0
Parameters:
[]
3 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:
[
  1780723874
  "cache_tree_aim_21"
]
4 0.68 ms
SELECT b.id AS brand_id, b.brand_name, b.num_of_products_aim AS broj_proizvoda
			FROM proizvodjaci b
			WHERE b.active = 1 AND b.show_brand = 1
			ORDER BY broj_proizvoda DESC
			LIMIT 25
Parameters:
[]
5 16.64 ms
SELECT COUNT(p.id) AS uk_broj_aktivnih 
            FROM proizvodi p 
            WHERE p.active = 1 AND p.show_product = 1
Parameters:
[]
6 0.57 ms
SELECT COUNT(*) AS num_brands
                                FROM proizvodjaci b
                              	WHERE  active = 1 AND show_brand = 1 AND num_of_products_aim > 0
Parameters:
[]
7 0.14 ms
SELECT * FROM upload_images ORDER BY id
Parameters:
[]
8 1.53 ms
SELECT b.id, b.brand_name, b.brand_name_seo, b.brand_description, b.brand_image, b.meta_title, b.meta_description, b.meta_keywords, b.num_of_products, b.num_of_products_aim, b.img_size
			FROM proizvodjaci b
			WHERE b.active = 1 AND b.show_brand = 1 AND b.num_of_products_aim > 0
			ORDER BY b.brand_name
			 LIMIT 40 OFFSET 200
Parameters:
[]

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.