Product category:	insulated and sheathed wires
Type:	XYMM-J
Rated voltage:	450/750 V
Conductor material:	CU
No. of cores:	4
Cross-section:	1.5 mm²
Core insulation material:	PVC
Outer jacket material:	PVC
Nominal outer diameter:	11.0 mm
Approx. weight:	150 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`	`38696`

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

¤ ×

Unlogged

no identity

¤ ×

Queries: 14, time: 333.852 ms, default

Time ms

SQL Statement

Params

Rows

10.438
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.715
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

"38696" (5)

0.775
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.953

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

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

"38696" (5)

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

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

40.670
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.620
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.572
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)

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

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

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

29.874
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.537
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
442.5 ms
9.03 MB
front:search:default
14 queries / 333.9ms
×

Search by parameters

Search results

Alphabetical filter

Product details

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

Data sheet

front:search:default

Routers

Unlogged

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