Product category:	insulated and sheathed wires
Type:	XYMM-J
Rated voltage:	450/750 V
Conductor material:	CU
No. of cores:	3
Cross-section:	2.5 mm²
Core insulation material:	PVC
Outer jacket material:	PVC
Nominal outer diameter:	12.0 mm
Approx. weight:	190 kg/km
Delivery length:	100 m
	500 m
	1000 m
Construction:	Fine stranded copper wirde acc. Class 5, Insulation: cold resistant PVC, conductors stranded, outer sheath: cold resistant PVC
Standard:	ÖVE K41
Available colours:	yellow
Leadfree
Minimum installation temperature:	-5°C
Application:	In dry and humid places and outdoors, for medial and heavy mechanical stress, at low temperatures especially in the area of constructions and temporary appliances, explosive areas. Permitted temperature at cable surface: max. +70 °C for installation and handling min. -35 °C cold resistand not in operation up to -40°C

front:search:default

Parameter	Value
`locale`	`en`
`id`	NULL
`alpha`	`W`
`details`	`38678`

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 alpha = W details = 38678`

¤ ×

Unlogged

no identity

¤ ×

Queries: 14, time: 471.210 ms, default

Time ms

SQL Statement

Params

Rows

11.220
explain ►

SELECT `id` 
FROM `dnb_catalogue_item` 
WHERE (`locale` = ?) AND (`name` REGEXP "^([^ ]+ )*[^`a`-z]*W") 
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)

0.690
explain ►

SELECT `id`, `group_id`, `name`, `cores`, `cross_section`, `voltage`, `core_material`,
`conductor_1`, `reduced_0`, `conductor_2`, `core_insulation`, `conductor_screen`, `armouring`,
`outer_jacket`, `outer_diameter`, `weight`, `resistance_to`, `application`, `delivery_length_1`,
`delivery_length_2`, `delivery_length_3` 
FROM `dnb_catalogue_item` 
WHERE (`id` = ?)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	dnb_catalogue_item	const	PRIMARY	PRIMARY	4	const	1

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

"38678" (5)

0.647
explain ►

SELECT `id`, `group_id`, `locale`, `appendices`, `picture`, `category`, `construction`, `standard`,
`colours`, `fire_performance`, `leadfree`, `halogene_free`, `uv_resistant`, `min_temperature`,
`group_application`, `name` 
FROM `dnb_catalogue_group` 
WHERE (`group_id` = ?) AND (`locale` = ?) 
LIMIT 1

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	dnb_catalogue_group	const	group_id	group_id	6	const,const	1

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

"EN" (2)

1.471

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

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

"38678" (5)

55.275
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)

58.905
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)

60.229
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)

60.189
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)

49.620
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)

50.340
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)

49.749
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)

44.500
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)

27.928
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)

0.447
explain ►

SELECT `id` 
FROM `dnb_catalogue_item` 
WHERE (`locale` = ?) AND (`name` REGEXP "^([^ ]+ )*[^`a`-z]*W") 
ORDER BY `name`, `cores`, `cross_section`, `voltage` 
LIMIT 0 
OFFSET 0

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE								Zero limit

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

"EN" (2)

¤ ×

Nette Framework
1 188.7 ms
9.00 MB
front:search:default
14 queries / 471.2ms
×

Search by parameters

Search results

Alphabetical filter

Product details

XYMM-J 3 × 2.5 mm² 450/750 V

Data sheet

front:search:default

Routers

Unlogged

Queries: 14, time: 471.210 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