The Why,
The What,
The How

Here you'll find the why and how ICL group has unified under one strong brand. One consolidated entity with one story and one language as a symbol of working together towards one big purpose.

Why one ICL?

"We decided to take a step forward. To adopt to change while connecting to our roots."
Stefan Borgas – President & CEO

New global challenges, tough competition, unpredictable changes in the world's essential needs urged us to be focused and united.
We, at ICL realized we needed to unite our strong abilities and assets, and become consolidated around one vision. In order to succeed and lead growth in the next decade, we needed to adopt a new strategy "The Next Step Forward" and start to operate as ONE - one united leading global company, which derives its success from mutual support between all business units under one strong voice.

But What Exactly Makes Us One Company?

What is ICL? What is our common denominator? What can flame retardants, horticulture specialty fertilizers, food specialties and other branches possibly have in common?
What makes us one company is that we all share one unequivocal mutual mission: seeing humanity as our client. Waking up each morning and providing humanity's needs with all of the most pioneering, practical, effective solutions.

About
humanity’s
needs

Listening to the Universe

Following a comprehensive learning process, ICL saw its new vision as a major opportunity. Whether needs are "calling" in agriculture, food or engineered materials.
Whether in Africa, India, Europe,Asia, North or South America or in the Middle East, it is our responsibility to keep a finger on the pulse of changes and developments, to embrace them and to evolve along with them.

ICL'S Solutions

Needs Evolve. So Do We

And so ICL embraces a new way of thinking, shifting its focus from being a products-oriented company, to one that listens to humanity's needs, always providing it with innovative solutions - wherever these needs may come up and whichever direction they may take.

See the Videos

Where Needs Take Us

Part of the new ICL identity was to create a visionary tagline and brand language that will convey our new strategy. This new tagline reflects ICL's willingness to act upon any possible change. To constantly be able to transform, adapt and evolve as needs evolve all over the world.

See all
Business Units

One Voice, One Identity

The transformation from an organization owning a variety of strong independent brands into one powerful brand, with one clear narrative, lead to the unification of all ICL subsidiaries. Today, all of ICL's units gravitate around one backbone, with one quest, one voice and one mission statement of supplying humanity's essential needs.

About the
Graphic Language

The Brand Language: Reflecting ICL’s Story Through a Visual Identity

The new graphic language was designed to serve ICL's new identity and brand narrative and to enable it to operate as ONE ICL also through its visual appearance.
And so the "Wavering Ribbons" were born. Inspired by iconic visuals of transformation, movement and dynamic evolvement, the ICL "ribbons" capture, symbolically, the true nature of ICL, as a synergized system, prepared to be "taken" where needs call.

See the
New Branding

Joomla! Debug Console

Session

Profile Information

Memory Usage

Database Queries

14 Queries Logged 20.4 ms

2 duplicate found!

2 duplicates: #11 #13

Query Time: 0.25 ms Query memory: 0.013 MB Memory before query: 2.278 MB Rows returned: 0
```
SELECT `data`

  FROM `cp38l_session`

  WHERE `session_id` = 'fftjt2gc221jem0jqi23otmjr1'
```
Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE cp38l_session const PRIMARY PRIMARY 602 const 1
Profile
Error
MySql have_profiling = off
Call Stack
JROOT/libraries/joomla/session/storage/database.php:46
JROOT/libraries/joomla/session/session.php:658
JROOT/libraries/joomla/session/session.php:596
JROOT/libraries/cms/application/cms.php:668
JROOT/libraries/cms/application/cms.php:131
JROOT/libraries/cms/application/site.php:63
JROOT/libraries/cms/application/cms.php:328
JROOT/libraries/joomla/factory.php:124
JROOT/index.php:37
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.18 ms After last query: 2.11 ms Query memory: 0.010 MB Memory before query: 2.424 MB Rows returned: 0
```
SELECT `session_id`

  FROM `cp38l_session`

  WHERE `session_id` = 'fftjt2gc221jem0jqi23otmjr1' 
  LIMIT 0, 1
```
Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE cp38l_session const PRIMARY PRIMARY 602 const 1 Using index
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/cms/application/cms.php:175
JROOT/libraries/cms/application/cms.php:694
JROOT/libraries/cms/application/cms.php:131
JROOT/libraries/cms/application/site.php:63
JROOT/libraries/cms/application/cms.php:328
JROOT/libraries/joomla/factory.php:124
JROOT/index.php:37
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 6.17 ms After last query: 0.29 ms Query memory: 0.009 MB Memory before query: 2.437 MB
```
INSERT INTO `cp38l_session`
(`session_id`, `client_id`, `time`) 
  VALUES 
('fftjt2gc221jem0jqi23otmjr1', 0, '1576311146')
```
Explain
EXPLAIN not possible on query: INSERT INTO `cp38l_session` (`session_id`, `client_id`, `time`) VALUES ('fftjt2gc221jem0jqi23otmjr1', 0, '1576311146')
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/cms/application/cms.php:207
JROOT/libraries/cms/application/cms.php:694
JROOT/libraries/cms/application/cms.php:131
JROOT/libraries/cms/application/site.php:63
JROOT/libraries/cms/application/cms.php:328
JROOT/libraries/joomla/factory.php:124
JROOT/index.php:37
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.36 ms After last query: 7.02 ms Query memory: 0.013 MB Memory before query: 2.890 MB Rows returned: 2
```
SELECT b.id

  FROM cp38l_usergroups AS a

  LEFT JOIN cp38l_usergroups AS b 
  ON b.lft <= a.lft 
  AND b.rgt >= a.rgt

  WHERE a.id = 9
```
Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE a const PRIMARY PRIMARY 4 const 1
1 SIMPLE b range idx_usergroup_nested_set_lookup idx_usergroup_nested_set_lookup 4 NULL 3 Using where; Using index
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/joomla/access/access.php:334
JROOT/libraries/joomla/access/access.php:403
JROOT/libraries/joomla/user/user.php:428
JROOT/libraries/cms/plugin/helper.php:298
JROOT/libraries/cms/plugin/helper.php:165
JROOT/libraries/cms/application/site.php:575
JROOT/libraries/cms/application/site.php:209
JROOT/libraries/cms/application/cms.php:251
JROOT/index.php:40
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.14 ms After last query: 0.83 ms Query memory: 0.011 MB Memory before query: 2.954 MB Rows returned: 5
```
SELECT id, rules

  FROM `cp38l_viewlevels`
```
Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE cp38l_viewlevels ALL NULL NO INDEX KEY COULD BE USED NULL NULL 5
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/joomla/access/access.php:420
JROOT/libraries/joomla/user/user.php:428
JROOT/libraries/cms/plugin/helper.php:298
JROOT/libraries/cms/plugin/helper.php:165
JROOT/libraries/cms/application/site.php:575
JROOT/libraries/cms/application/site.php:209
JROOT/libraries/cms/application/cms.php:251
JROOT/index.php:40
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.47 ms After last query: 5.95 ms Query memory: 0.012 MB Memory before query: 3.420 MB Rows returned: 1
```
SELECT COUNT(*)

  FROM `cp38l_menu`

  WHERE home = 1 
  AND published = 1 
  AND client_id = 0
```
Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE cp38l_menu ref idx_client_id_parent_id_alias_language idx_client_id_parent_id_alias_language 1 const 66 Using where
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/administrator/components/com_languages/helpers/multilangstatus.php:32
JROOT/plugins/system/languagefilter/languagefilter.php:71
JROOT/libraries/cms/plugin/helper.php:257
JROOT/libraries/cms/plugin/helper.php:172
JROOT/libraries/cms/application/site.php:575
JROOT/libraries/cms/application/site.php:209
JROOT/libraries/cms/application/cms.php:251
JROOT/index.php:40
[Add xdebug.file_link_format directive to your php.ini file to have links for files]

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cp38l_session	const	PRIMARY	PRIMARY	602	const	1

Error
MySql have_profiling = off

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cp38l_session	const	PRIMARY	PRIMARY	602	const	1	Using index

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	b	range	idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	4	NULL	3	Using where; Using index

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cp38l_viewlevels	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	5

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cp38l_menu	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	66	Using where

Query Time: 1.81 ms After last query: 19.95 ms Query memory: 0.019 MB Memory before query: 4.486 MB Rows returned: 78

SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component

  FROM cp38l_menu AS m

  LEFT JOIN cp38l_extensions AS e 
  ON m.component_id = e.extension_id

  WHERE m.published = 1 
  AND m.parent_id > 0 
  AND m.client_id = 0

  ORDER BY m.lft

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	66	Using where; Using filesort
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	iclbrandin_db.m.component_id	1

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

JROOT/libraries/cms/menu/site.php:47

JROOT/libraries/cms/menu/menu.php:64

JROOT/libraries/cms/menu/menu.php:118

JROOT/libraries/cms/application/cms.php:353

JROOT/libraries/cms/application/site.php:279

JROOT/libraries/cms/router/site.php:218

JROOT/libraries/cms/router/router.php:408

JROOT/libraries/cms/router/router.php:192

JROOT/libraries/cms/router/site.php:90

JROOT/libraries/cms/application/cms.php:1018

JROOT/libraries/cms/application/site.php:749

JROOT/libraries/cms/application/site.php:231

JROOT/libraries/cms/application/cms.php:251

JROOT/index.php:40

[Add xdebug.file_link_format directive to your php.ini file to have links for files]

Query Time: 3.36 ms After last query: 9.63 ms Query memory: 0.018 MB Memory before query: 5.502 MB
```
UPDATE `cp38l_extensions`

  SET `params` = '{\"mediaversion\":\"993d758531c2542d36699f67cc951a92\"}'

  WHERE `type` = 'library' 
  AND `element` = 'joomla'
```
Explain
EXPLAIN not possible on query: UPDATE `cp38l_extensions` SET `params` = '{\"mediaversion\":\"993d758531c2542d36699f67cc951a92\"}' WHERE `type` = 'library' AND `element` = 'joomla'
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/cms/library/helper.php:119
JROOT/libraries/cms/version/version.php:230
JROOT/libraries/cms/version/version.php:189
JROOT/libraries/joomla/factory.php:734
JROOT/libraries/joomla/factory.php:215
JROOT/plugins/system/sef/sef.php:30
JROOT/libraries/joomla/event/event.php:71
JROOT/libraries/joomla/event/dispatcher.php:162
JROOT/libraries/joomla/application/base.php:106
JROOT/libraries/cms/application/cms.php:1027
JROOT/libraries/cms/application/site.php:749
JROOT/libraries/cms/application/site.php:231
JROOT/libraries/cms/application/cms.php:251
JROOT/index.php:40
[Add xdebug.file_link_format directive to your php.ini file to have links for files]

Query Time: 0.90 ms After last query: 14.96 ms Query memory: 0.023 MB Memory before query: 6.454 MB Rows returned: 1

SELECT COUNT(*)

  FROM `cp38l_icl_front_page_items` AS a

  LEFT JOIN cp38l_users AS uc 
  ON uc.id=a.checked_out

  LEFT JOIN cp38l_users AS created_by 
  ON created_by.id = a.created_by

  LEFT JOIN cp38l_content AS cp38l_content_1521491 
  ON cp38l_content_1521491.id = a.scroll_to

  WHERE (a.language = 'en-GB' OR a.language = '*') 
  AND a.state = 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	79	Using where
1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	iclbrandin_db.a.checked_out	1	Using index
1	SIMPLE	created_by	eq_ref	PRIMARY	PRIMARY	4	iclbrandin_db.a.created_by	1	Using index
1	SIMPLE	cp38l_content_1521491	eq_ref	PRIMARY	PRIMARY	4	iclbrandin_db.a.scroll_to	1	Using index

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

JROOT/libraries/legacy/model/legacy.php:327

JROOT/libraries/legacy/model/list.php:276

JROOT/libraries/legacy/model/list.php:310

JROOT/libraries/legacy/model/list.php:171

JROOT/components/com_icl_front_page/models/frontpageitems.php:204

JROOT/libraries/legacy/view/legacy.php:398

JROOT/components/com_icl_front_page/views/frontpageitems/view.html.php:38

JROOT/libraries/legacy/controller/legacy.php:693

JROOT/components/com_icl_front_page/controller.php:32

JROOT/libraries/legacy/controller/legacy.php:730

JROOT/components/com_icl_front_page/icl_front_page.php:17

JROOT/libraries/cms/component/helper.php:352

JROOT/libraries/cms/component/helper.php:332

JROOT/libraries/cms/application/site.php:191

JROOT/libraries/cms/application/site.php:237

JROOT/libraries/cms/application/cms.php:251

JROOT/index.php:40

[Add xdebug.file_link_format directive to your php.ini file to have links for files]

Query Time: 1.24 ms After last query: 0.21 ms Query memory: 0.020 MB Memory before query: 6.469 MB Rows returned: 9

SELECT DISTINCT a.*,uc.name AS editor,cp38l_content_1521491.title AS content_title_1521491

  FROM `cp38l_icl_front_page_items` AS a

  LEFT JOIN cp38l_users AS uc 
  ON uc.id=a.checked_out

  LEFT JOIN cp38l_users AS created_by 
  ON created_by.id = a.created_by

  LEFT JOIN cp38l_content AS cp38l_content_1521491 
  ON cp38l_content_1521491.id = a.scroll_to

  WHERE (a.language = 'en-GB' OR a.language = '*') 
  AND a.state = 1

  ORDER BY a.ordering 
  LIMIT 0, 20

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	79	Using where; Using temporary; Using filesort
1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	iclbrandin_db.a.checked_out	1
1	SIMPLE	created_by	eq_ref	PRIMARY	PRIMARY	4	iclbrandin_db.a.created_by	1	Using index
1	SIMPLE	cp38l_content_1521491	eq_ref	PRIMARY	PRIMARY	4	iclbrandin_db.a.scroll_to	1

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

JROOT/libraries/legacy/model/legacy.php:301

JROOT/libraries/legacy/model/list.php:171

JROOT/components/com_icl_front_page/models/frontpageitems.php:204

JROOT/libraries/legacy/view/legacy.php:398

JROOT/components/com_icl_front_page/views/frontpageitems/view.html.php:38

JROOT/libraries/legacy/controller/legacy.php:693

JROOT/components/com_icl_front_page/controller.php:32

JROOT/libraries/legacy/controller/legacy.php:730

JROOT/components/com_icl_front_page/icl_front_page.php:17

JROOT/libraries/cms/component/helper.php:352

JROOT/libraries/cms/component/helper.php:332

JROOT/libraries/cms/application/site.php:191

JROOT/libraries/cms/application/site.php:237

JROOT/libraries/cms/application/cms.php:251

JROOT/index.php:40

[Add xdebug.file_link_format directive to your php.ini file to have links for files]

Query Time: 0.43 ms After last query: 27.16 ms Query memory: 0.013 MB Memory before query: 7.461 MB Rows returned: 0
Duplicate queries: #13
```
SELECT m2.language, m2.id

  FROM cp38l_menu as m

  INNER JOIN cp38l_associations as a 
  ON a.id=m.id 
  AND a.context='com_menus.item'

  INNER JOIN cp38l_associations as a2 
  ON a.key=a2.key

  INNER JOIN cp38l_menu as m2 
  ON a2.id=m2.id

  WHERE m.id=173
```
Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE NULL NULL NULL NO INDEX KEY COULD BE USED NULL NULL NULL Impossible WHERE noticed after reading const tables
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/administrator/components/com_menus/helpers/menus.php:257
JROOT/plugins/system/languagefilter/languagefilter.php:592
JROOT/libraries/joomla/event/event.php:71
JROOT/libraries/joomla/event/dispatcher.php:162
JROOT/libraries/joomla/application/base.php:106
JROOT/libraries/cms/application/site.php:196
JROOT/libraries/cms/application/site.php:237
JROOT/libraries/cms/application/cms.php:251
JROOT/index.php:40
[Add xdebug.file_link_format directive to your php.ini file to have links for files]

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

Query Time: 2.32 ms After last query: 16.21 ms Query memory: 0.015 MB Memory before query: 8.096 MB Rows returned: 12

SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid

  FROM cp38l_modules AS m

  LEFT JOIN cp38l_modules_menu AS mm 
  ON mm.moduleid = m.id

  LEFT JOIN cp38l_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

  WHERE m.published = 1 
  AND e.enabled = 1 
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2019-12-14 08:12:26') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2019-12-14 08:12:26') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 173 OR mm.menuid <= 0) 
  AND m.language IN ('en-GB','*')

  ORDER BY m.position, m.ordering

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ref	PRIMARY,published,newsfeeds,idx_language	published	1	const	34	Using where; Using filesort
1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	iclbrandin_db.m.id	1	Using where; Using index
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	303	iclbrandin_db.m.module,const	1	Using where

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

JROOT/libraries/cms/module/helper.php:376

JROOT/libraries/cms/module/helper.php:84

JROOT/libraries/joomla/document/html/html.php:510

JROOT/templates/icl/index.php:40

JROOT/libraries/joomla/document/html/html.php:576

JROOT/libraries/joomla/document/html/html.php:634

JROOT/libraries/joomla/document/html/html.php:452

JROOT/libraries/cms/application/cms.php:974

JROOT/libraries/cms/application/site.php:731

JROOT/libraries/cms/application/cms.php:257

JROOT/index.php:40

[Add xdebug.file_link_format directive to your php.ini file to have links for files]

Query Time: 0.32 ms After last query: 5.78 ms Query memory: 0.018 MB Memory before query: 8.223 MB Rows returned: 0
Duplicate queries: #11
```
SELECT m2.language, m2.id

  FROM cp38l_menu as m

  INNER JOIN cp38l_associations as a 
  ON a.id=m.id 
  AND a.context='com_menus.item'

  INNER JOIN cp38l_associations as a2 
  ON a.key=a2.key

  INNER JOIN cp38l_menu as m2 
  ON a2.id=m2.id

  WHERE m.id=173
```
Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE NULL NULL NULL NO INDEX KEY COULD BE USED NULL NULL NULL Impossible WHERE noticed after reading const tables
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/administrator/components/com_menus/helpers/menus.php:257
JROOT/modules/mod_languages/helper.php:58
JROOT/modules/mod_languages/mod_languages.php:18
JROOT/libraries/cms/module/helper.php:190
JROOT/libraries/joomla/document/html/renderer/module.php:105
JROOT/libraries/joomla/document/html/renderer/modules.php:46
JROOT/libraries/joomla/document/html/html.php:408
JROOT/libraries/joomla/document/html/html.php:696
JROOT/libraries/joomla/document/html/html.php:474
JROOT/libraries/cms/application/cms.php:988
JROOT/libraries/cms/application/site.php:731
JROOT/libraries/cms/application/cms.php:257
JROOT/index.php:40
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 2.48 ms After last query: 7.36 ms Query memory: 0.003 MB Memory before query: 8.326 MB
```
UPDATE `cp38l_session`

  SET `data` = '__default|a:9:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1576311146;s:18:\"session.timer.last\";i:1576311146;s:17:\"session.timer.now\";i:1576311146;s:24:\"session.client.forwarded\";s:13:\"3.234.214.179\";s:22:\"session.client.browser\";s:40:\"CCBot/2.0 (https://commoncrawl.org/faq/)\";s:8:\"registry\";O:24:\"Joomla\\Registry\\Registry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":25:{s:9:\"\\0\\0\\0isRoot\";N;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:1:{i:0;s:1:\"9\";}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:12:\"requireReset\";N;s:10:\"\\0\\0\\0_params\";O:24:\"Joomla\\Registry\\Registry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:14:\"\\0\\0\\0_authGroups\";N;s:14:\"\\0\\0\\0_authLevels\";a:3:{i:0;i:1;i:1;i:1;i:2;i:5;}s:15:\"\\0\\0\\0_authActions\";N;s:12:\"\\0\\0\\0_errorMsg\";N;s:10:\"\\0\\0\\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:13:\"session.token\";s:32:\"f35f272e488caff2c746e4bb01c71317\";}'
	, `time` = '1576311146'

  WHERE `session_id` = 'fftjt2gc221jem0jqi23otmjr1'
```
Explain
EXPLAIN not possible on query: UPDATE `cp38l_session` SET `data` = '__default|a:9:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1576311146;s:18:\"session.timer.last\";i:1576311146;s:17:\"session.timer.now\";i:1576311146;s:24:\"session.client.forwarded\";s:13:\"3.234.214.179\";s:22:\"session.client.browser\";s:40:\"CCBot/2.0 (https://commoncrawl.org/faq/)\";s:8:\"registry\";O:24:\"Joomla\\Registry\\Registry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":25:{s:9:\"\\0\\0\\0isRoot\";N;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:1:{i:0;s:1:\"9\";}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:12:\"requireReset\";N;s:10:\"\\0\\0\\0_params\";O:24:\"Joomla\\Registry\\Registry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:14:\"\\0\\0\\0_authGroups\";N;s:14:\"\\0\\0\\0_authLevels\";a:3:{i:0;i:1;i:1;i:1;i:2;i:5;}s:15:\"\\0\\0\\0_authActions\";N;s:12:\"\\0\\0\\0_errorMsg\";N;s:10:\"\\0\\0\\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:13:\"session.token\";s:32:\"f35f272e488caff2c746e4bb01c71317\";}' , `time` = '1576311146' WHERE `session_id` = 'fftjt2gc221jem0jqi23otmjr1'
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/joomla/session/storage/database.php:85
[Add xdebug.file_link_format directive to your php.ini file to have links for files]

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

13 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

2 × SELECT m2.language, m2.id 
  FROM cp38l_menu as m 
  INNER JOIN cp38l_associations as a 
  ON a.id=m.id 
  AND a.context='com_menus.item' 
  INNER JOIN cp38l_associations as a2 
  ON a.key=a2.key 
  INNER JOIN cp38l_menu as m2 
  ON a2.id=m2.id

1 × SELECT COUNT(*) 
  FROM `cp38l_icl_front_page_items` AS a 
  LEFT JOIN cp38l_users AS uc 
  ON uc.id=a.checked_out 
  LEFT JOIN cp38l_users AS created_by 
  ON created_by.id = a.created_by 
  LEFT JOIN cp38l_content AS cp38l_content_1521491 
  ON cp38l_content_1521491.id = a.scroll_to

1 × SELECT DISTINCT a.*,uc.name AS editor,cp38l_content_1521491.title AS content_title_1521491 
  FROM `cp38l_icl_front_page_items` AS a 
  LEFT JOIN cp38l_users AS uc 
  ON uc.id=a.checked_out 
  LEFT JOIN cp38l_users AS created_by 
  ON created_by.id = a.created_by 
  LEFT JOIN cp38l_content AS cp38l_content_1521491 
  ON cp38l_content_1521491.id = a.scroll_to

1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component 
  FROM cp38l_menu AS m 
  LEFT JOIN cp38l_extensions AS e 
  ON m.component_id = e.extension_id

1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
  FROM cp38l_modules AS m 
  LEFT JOIN cp38l_modules_menu AS mm 
  ON mm.moduleid = m.id 
  LEFT JOIN cp38l_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

1 × SELECT COUNT(*) 
  FROM `cp38l_menu`

1 × SELECT `session_id` 
  FROM `cp38l_session`

1 × SELECT b.id 
  FROM cp38l_usergroups AS a 
  LEFT JOIN cp38l_usergroups AS b 
  ON b.lft <= a.lft 
  AND b.rgt >= a.rgt

1 × SELECT id, rules 
  FROM `cp38l_viewlevels

1 × SELECT `data` 
  FROM `cp38l_session`

OTHER Tables:

1 × UPDATE `cp38l_session` 
  SET `data` = '__default|a:9:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1576311146;s:18:\"session.timer.last\";i:1576311146;s:17:\"session.timer.now\";i:1576311146;s:24:\"session.client.forwarded\";s:13:\"3.234.214.179\";s:22:\"session.client.browser\";s:40:\"CCBot/2.0 (https://commoncrawl.org/faq/)\";s:8:\"registry\";O:24:\"Joomla\\Registry\\Registry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":25:{s:9:\"\\0\\0\\0isRoot\";N;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:1:{i:0;s:1:\"9\";}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:12:\"requireReset\";N;s:10:\"\\0\\0\\0_params\";O:24:\"Joomla\\Registry\\Registry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:14:\"\\0\\0\\0_authGroups\";N;s:14:\"\\0\\0\\0_authLevels\";a:3:{i:0;i:1;i:1;i:1;i:2;i:5;}s:15:\"\\0\\0\\0_authActions\";N;s:12:\"\\0\\0\\0_errorMsg\";N;s:10:\"\\0\\0\\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:13:\"session.token\";s:32:\"f35f272e488caff2c746e4bb01c71317\";}'  , `time` = '1576311146'

1 × UPDATE `cp38l_extensions` 
  SET `params` = '{\"mediaversion\":\"993d758531c2542d36699f67cc951a92\"}'

1 × INSERT INTO `cp38l_session` (`session_id`, `client_id`, `time`) 
  VALUES  ('fftjt2gc221jem0jqi23otmjr1', 0, '1576311146'

ICL - Where needs take us

The Why,
The What,
The How

Why one ICL?

But What Exactly Makes Us One Company?

Listening to the Universe

Needs Evolve. So Do We

Where Needs Take Us

One Voice, One Identity

The Brand Language: Reflecting ICL’s Story Through a Visual Identity

Useful Links

Additional Info

Joomla! Debug Console

Session

__default

Profile Information

Time

Memory

Memory Usage

Database Queries

14 Queries Logged 20.4 ms

2 duplicate found!

13 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

OTHER Tables:

ICL - Where needs take us

The Why,The What, The How

Why one ICL?

But What Exactly Makes Us One Company?

Listening to the Universe

Needs Evolve. So Do We

Where Needs Take Us

One Voice, One Identity

The Brand Language: Reflecting ICL’s Story Through a Visual Identity

Useful Links

Additional Info

Joomla! Debug Console

Session

__default

Profile Information

Time

Memory

Memory Usage

Database Queries

14 Queries Logged 20.4 ms

2 duplicate found!

13 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

OTHER Tables:

The Why,
The What,
The How