Product category:	insulated and sheathed wires
Type:	XYMM-J
Rated voltage:	450/750 V
Conductor material:	CU
No. of cores:	5
Cross-section:	10 mm²
Core insulation material:	PVC
Outer jacket material:	PVC
Nominal outer diameter:	24.0 mm
Approx. weight:	940 kg/km
Delivery length:	50 m
	100 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`	`38626`

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 = 38626`

¤ ×

Unlogged

no identity

¤ ×

Queries: 14, time: 328.445 ms, default

Time ms

SQL Statement

Params

Rows

10.672
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.610
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

"38626" (5)

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

2.294

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

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

"38626" (5)

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

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

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

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

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

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

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

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

32.251
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.548
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
699.2 ms
9.02 MB
front:search:default
14 queries / 328.4ms
×

Search by parameters

Search results

Alphabetical filter

Product details

XYMM-J 5 × 10 mm² 450/750 V

Data sheet

front:search:default

Routers

Unlogged

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