Product category:	insulated and sheathed wires
Type:	XYMM-J
Rated voltage:	450/750 V
Conductor material:	CU
No. of cores:	5
Cross-section:	1.5 mm²
Core insulation material:	PVC
Outer jacket material:	PVC
Nominal outer diameter:	12.0 mm
Approx. weight:	190 kg/km
	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`	`Q`
`details`	`38686`

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 = Q details = 38686`

¤ ×

Unlogged

no identity

¤ ×

Queries: 14, time: 343.632 ms, default

Time ms

SQL Statement

Params

Rows

8.531
explain ►

SELECT `id`, `name`, `cores`, `cross_section`, `voltage` 
FROM `dnb_catalogue_item` 
WHERE (`locale` = ?) AND (`name` REGEXP "^([^ ]+ )*[^`a`-z]*Q") 
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.551
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

"38686" (5)

0.706
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.153

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

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

"38686" (5)

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

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

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

34.924
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.772
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.608
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)

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

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

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

10.563
explain ►

SELECT `id`, `name`, `cores`, `cross_section`, `voltage` 
FROM `dnb_catalogue_item` 
WHERE (`locale` = ?) AND (`name` REGEXP "^([^ ]+ )*[^`a`-z]*Q") 
ORDER BY `name`, `cores`, `cross_section`, `voltage` 
LIMIT 1 
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)

¤ ×

Nette Framework
1 286.2 ms
9.01 MB
front:search:default
14 queries / 343.6ms
×

Search by parameters

Search results

Alphabetical filter

Product details

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

Data sheet

front:search:default

Routers

Unlogged

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