Time ms | SQL Statement | Params | Rows |
---|
24,803 explain ► | SELECT `id`, `name`, `cores`, `cross_section`, `voltage`
FROM `dnb_catalogue_item`
WHERE (`locale` = ?) AND (`name` REGEXP "^([^ ]+ )*[^`a`-z]*Y")
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 | "HU" (2)
| 457 |
2,405 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 | "25131" (5)
| 1 |
0,653 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 | 35
"HU" (2)
| 1 |
0,649 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 | 35
"EN" (2)
| 1 |
2,001 | UPDATE dnb_catalogue_item
SET views = views + 1
WHERE id = ?
/var/www/clients/client373/web726/web/app/model/CatalogueRepository.php | "25131" (5)
| 1 |
40,836 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 | "HU" (2)
| 12 |
35,721 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 | "HU" (2)
| 3 |
36,770 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 | "HU" (2)
| 36 |
43,362 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 | "HU" (2)
| 27 |
53,834 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 | "HU" (2)
| 13 |
43,078 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 | "HU" (2)
| 6 |
42,221 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 | "HU" (2)
| 13 |
52,111 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 | "HU" (2)
| 11 |
55,851 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 | "HU" (2)
| 11 |
12,708 explain ► | SELECT `id`, `name`, `cores`, `cross_section`, `voltage`
FROM `dnb_catalogue_item`
WHERE (`locale` = ?) AND (`name` REGEXP "^([^ ]+ )*[^`a`-z]*Y")
ORDER BY `name`, `cores`, `cross_section`, `voltage`
LIMIT 7
OFFSET 450
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 | "HU" (2)
| 7 |