front:search:default

Parameter	Value
`locale`	`en`
`id`	NULL

Routers

Matched?	Class	Mask	Defaults	Request
no	`Route`	`admin/<presenter>/<action=default>/<id>`	`module = admin presenter = NULL action = default id = NULL`
no	`Route`	`[<locale>/]user/<presenter>/<action>/<id>`	`module = user presenter = NULL action = default id = NULL locale = NULL`
yes	`Route`	`[<locale>/]<presenter>/<action>/<id>`	`module = front presenter = search action = default id = NULL locale = NULL`	`front:search:default locale = en id = NULL`

¤ ×

Unlogged

no identity

¤ ×

Queries: 12, time: 467.481 ms, default

Time ms

SQL Statement

Params

Rows

18.093
explain ►

SELECT `id`, `name`, `cores`, `cross_section`, `voltage` 
FROM `dnb_catalogue_item` 
WHERE (`locale` = ?) 
ORDER BY `name`, `cores`, `cross_section`, `voltage`

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	dnb_catalogue_item	ALL					18719	Using where; Using filesort

/var/www/clients/client373/web726/web/app/model/ItemSelector.php

"EN" (2)

2768

0.550

UPDATE dnb_catalogue_item
SET views = views + 1
WHERE id = ?

/var/www/clients/client373/web726/web/app/model/CatalogueRepository.php

NULL

0

33.492
explain ►

SELECT DISTINCT `voltage` 
FROM `dnb_catalogue_item` 
WHERE (`locale` = ?)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	dnb_catalogue_item	index		voltage	603		18719	Using where

/var/www/clients/client373/web726/web/app/model/CatalogueCommon.php

"EN" (2)

12

36.116
explain ►

SELECT DISTINCT `core_material` 
FROM `dnb_catalogue_item` 
WHERE (`locale` = ?)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	dnb_catalogue_item	index		core_material	603		18719	Using where

/var/www/clients/client373/web726/web/app/model/CatalogueCommon.php

"EN" (2)

3

35.649
explain ►

SELECT DISTINCT `cores` 
FROM `dnb_catalogue_item` 
WHERE (`locale` = ?)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	dnb_catalogue_item	index		cores	603		18719	Using where

/var/www/clients/client373/web726/web/app/model/CatalogueCommon.php

"EN" (2)

36

50.216
explain ►

SELECT DISTINCT `cross_section` 
FROM `dnb_catalogue_item` 
WHERE (`locale` = ?)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	dnb_catalogue_item	index		cross_section	603		18719	Using where

/var/www/clients/client373/web726/web/app/model/CatalogueCommon.php

"EN" (2)

26

58.947
explain ►

SELECT DISTINCT `core_insulation` 
FROM `dnb_catalogue_item` 
WHERE (`locale` = ?)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	dnb_catalogue_item	index		core_insulation	603		18719	Using where

/var/www/clients/client373/web726/web/app/model/CatalogueCommon.php

"EN" (2)

12

48.734
explain ►

SELECT DISTINCT `armouring` 
FROM `dnb_catalogue_item` 
WHERE (`locale` = ?)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	dnb_catalogue_item	index		armouring	603		18719	Using where

/var/www/clients/client373/web726/web/app/model/CatalogueCommon.php

"EN" (2)

5

54.901
explain ►

SELECT DISTINCT `outer_jacket` 
FROM `dnb_catalogue_item` 
WHERE (`locale` = ?)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	dnb_catalogue_item	index		outer_jacket	603		18719	Using where

/var/www/clients/client373/web726/web/app/model/CatalogueCommon.php

"EN" (2)

13

58.086
explain ►

SELECT DISTINCT `resistance_to` 
FROM `dnb_catalogue_item` 
WHERE (`locale` = ?)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	dnb_catalogue_item	index		resistance_to	603		18719	Using where

/var/www/clients/client373/web726/web/app/model/CatalogueCommon.php

"EN" (2)

10

60.056
explain ►

SELECT DISTINCT `application` 
FROM `dnb_catalogue_item` 
WHERE (`locale` = ?)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	dnb_catalogue_item	index		application	603		18719	Using where

/var/www/clients/client373/web726/web/app/model/CatalogueCommon.php

"EN" (2)

9

12.641
explain ►

SELECT `id`, `name`, `cores`, `cross_section`, `voltage` 
FROM `dnb_catalogue_item` 
WHERE (`locale` = ?) 
ORDER BY `name`, `cores`, `cross_section`, `voltage` 
LIMIT 30 
OFFSET 0

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	dnb_catalogue_item	ALL					18719	Using where; Using filesort

/var/www/clients/client373/web726/web/temp/cache/_Nette.FileTemplate/_templates.Search.default.latte-6a359de774037390404e9d95e6663988.php

"EN" (2)

30

¤ ×

Nette Framework
594.2 ms
12.58 MB
front:search:default
12 queries / 467.5ms
×

(N)AY2Y	4	×	120	0,6/1 kV
(N)AY2Y	4	×	120	0,6/1 kV
(N)AY2Y	4	×	150	0,6/1 kV
(N)AY2Y	4	×	150	0,6/1 kV
(N)AY2Y	4	×	185	0,6/1 kV
(N)AY2Y	4	×	240	0,6/1 kV
(N)AY2Y	4	×	25	0,6/1 kV
(N)AY2Y	4	×	25	0,6/1 kV
(N)AY2Y	4	×	35	0,6/1 kV
(N)AY2Y	4	×	35	0,6/1 kV
(N)AY2Y	4	×	50	0,6/1 kV
(N)AY2Y	4	×	50	0,6/1 kV
(N)AY2Y	4	×	70	0,6/1 kV
(N)AY2Y	4	×	70	0,6/1 kV
(N)AY2Y	4	×	95	0,6/1 kV
(N)AY2Y	4	×	95	0,6/1 kV
(N)AYY	4	×	16	0,6/1 kV
(N)Y2Y	4	×	10	0,6/1 kV
(N)Y2Y	4	×	10	0,6/1 kV
(N)Y2Y	4	×	16	0,6/1 kV
(N)Y2Y	4	×	16	0,6/1 kV
(N)Y2Y	4	×	25	0,6/1 kV
(N)Y2Y	4	×	35	0,6/1 kV
(N)Y2Y	4	×	6	0,6/1 kV
1-AYKY	3	×	120	0,6/1 kV
1-AYKY	3	×	150	0,6/1 kV
1-AYKY	3	×	185	0,6/1 kV
1-AYKY	3	×	240	0,6/1 kV
1-AYKY	3	×	50	0,6/1 kV
1-AYKY	3	×	70	0,6/1 kV

Search by parameters

Search results

Alphabetical filter

Product details

front:search:default

Routers

Unlogged

Queries: 12, time: 467.481 ms, default

(no value)
1
2
3
4
5
6
7
8
9
10
11
12
14
15
16
18
19
20
21
24
25
30
32
34
36
37
40
42
48
50
52
54
60
61
80

(no value)
0.5
0.75
1
1.5
2.5
2x0.8
4
6
10
16
25
35
50
70
95
120
150
185
240
300
400
500
630
800
1000