[0.0000s] DEBUG info j4age: Visit time in Joomla Local timezone: 2020-12-02 08:31:52        

Performed SQL enquiries

SELECT `data` FROM `ijm61_session` WHERE `session_id` = 'rkeu9a8cl9s1ft77e1798aokf3'

DELETE FROM `ijm61_session` WHERE `time` < '1606897011'

SELECT `session_id` FROM `ijm61_session` WHERE `session_id` = 'rkeu9a8cl9s1ft77e1798aokf3' LIMIT 0, 1

INSERT INTO `ijm61_session` (`session_id`, `client_id`, `time`) VALUES ('rkeu9a8cl9s1ft77e1798aokf3', 0, '1606897911')

SELECT extension_id AS id, element AS "option", params, enabled FROM ijm61_extensions WHERE `type` = 'component' AND `element` = 'com_users'

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

SELECT id, rules FROM `ijm61_viewlevels`

SELECT folder AS type, element AS name, params FROM ijm61_extensions WHERE enabled >= 1 AND type ='plugin' AND state >= 0 AND access IN (1,1) ORDER BY ordering

SELECT * FROM ijm61_languages WHERE published=1 ORDER BY ordering ASC

SELECT extension_id AS id, element AS "option", params, enabled FROM ijm61_extensions WHERE `type` = 'component' AND `element` = 'com_languages'

SELECT COUNT(*) FROM `ijm61_menu` WHERE home = 1 AND published = 1 AND client_id = 0

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 ijm61_menu AS m LEFT JOIN ijm61_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

SELECT extension_id AS id, element AS "option", params, enabled FROM ijm61_extensions WHERE `type` = 'component' AND `element` = 'com_content'

SELECT id, home, template, s.params FROM ijm61_template_styles as s LEFT JOIN ijm61_extensions as e ON e.element=s.template AND e.type='template' AND e.client_id=s.client_id WHERE s.client_id = 0 AND e.enabled = 1

SELECT a.rules FROM ijm61_assets AS a WHERE (a.id = 1) GROUP BY a.id, a.rules, a.lft

SELECT b.rules FROM ijm61_assets AS a LEFT JOIN ijm61_assets AS b ON b.lft <= a.lft AND b.rgt >= a.rgt WHERE (a.name = 'com_content') GROUP BY b.id, b.rules, b.lft ORDER BY b.lft

SELECT a.id, a.asset_id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext, CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.mask, a.catid, a.created, a.created_by, a.created_by_alias, CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.parentid, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,( SELECT MAX(contact.id) AS id FROM ijm61_contact_details AS contact WHERE contact.published = 1 AND contact.user_id = a.created_by AND (contact.language in ('en-GB','*') OR contact.language IS NULL)) as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count FROM ijm61_content AS a LEFT JOIN ijm61_categories AS c on c.id = a.catid LEFT JOIN ijm61_users AS u on u.id = a.created_by LEFT JOIN ijm61_categories as parent ON parent.id = c.parent_id LEFT JOIN ijm61_content_rating AS v ON a.id = v.content_id LEFT OUTER JOIN (SELECT cat.id as id FROM ijm61_categories AS cat JOIN ijm61_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published <= 0 GROUP BY cat.id) AS badcats ON badcats.id = c.id WHERE a.language in ('en-GB','*') AND a.id = 100 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-12-02 08:31:51') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-12-02 08:31:51') AND (a.state = 1 OR a.state =2)

SELECT c.*, CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug FROM ijm61_categories as c LEFT JOIN ijm61_categories AS s ON (s.lft < c.lft AND s.rgt > c.rgt AND c.language in ('en-GB','*')) OR (s.lft >= c.lft AND s.rgt <= c.rgt) LEFT JOIN (SELECT cat.id as id FROM ijm61_categories AS cat JOIN ijm61_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published != 1 GROUP BY cat.id) AS badcats ON badcats.id = c.id WHERE (c.extension='com_content' OR c.extension='system') AND c.access IN (1,1) AND c.published = 1 AND s.id=37 AND badcats.id is null GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id ORDER BY c.lft

SELECT a.sef AS sef,a.lang_code AS lang_code FROM ijm61_languages AS a

UPDATE ijm61_content SET hits = hits + 1 WHERE id = 100

SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid FROM ijm61_modules AS m LEFT JOIN ijm61_modules_menu AS mm ON mm.moduleid = m.id LEFT JOIN ijm61_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 <= '2020-12-02 08:31:51') AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2020-12-02 08:31:51') AND m.access IN (1,1) AND m.client_id = 0 AND (mm.menuid = 247 OR mm.menuid <= 0) AND m.language IN ('en-GB','*') ORDER BY m.position, m.ordering

SELECT m2.language, m2.id FROM ijm61_menu as m INNER JOIN ijm61_associations as a ON a.id=m.id AND a.context='com_menus.item' INNER JOIN ijm61_associations as a2 ON a.key=a2.key INNER JOIN ijm61_menu as m2 ON a2.id=m2.id WHERE m.id=247


[0.0017s] DEBUG info j4age: JS 0.000 seconds (+0.000); 3.96 MB (+3.961) - Perform Visitor counting process (function: countVisitor())        

Performed SQL enquiries

SELECT * FROM ijm61_jstats_configuration


[0.0001s] DEBUG info j4age: JS 0.000 seconds (+0.000); 3.96 MB (+0.002) - loadKnownRecords start        

Performed SQL enquiries


[0.0000s] DEBUG info j4age: Trace Code from cookie:         

Performed SQL enquiries


[0.0000s] DEBUG info j4age: Client-ID from cookie:         

Performed SQL enquiries


[0.0007s] DEBUG info j4age: No former entry found for IP 64692172        

Performed SQL enquiries

SELECT * FROM ijm61_jstats_ipaddresses AS a WHERE a.ip = '64692172'


[0.0021s] DEBUG info j4age: No known client found for IP 64692172        

Performed SQL enquiries

SELECT c.* FROM ijm61_jstats_clients AS c LEFT OUTER JOIN ijm61_jstats_visits AS v ON c.client_id = v.client_id WHERE v.ip = '64692172' AND (c.visitor_id = 0 OR c.visitor_id IS NULL);


[0.0001s] DEBUG info j4age: JS 0.003 seconds (+0.003); 3.97 MB (+0.003) - loadKnownRecords end        

Performed SQL enquiries


[0.0000s] DEBUG info j4age: JS 0.003 seconds (+0.000); 3.97 MB (+0.001) - client & ip handling start        

Performed SQL enquiries


[0.0000s] DEBUG info j4age: Retrieve IP Infos        

Performed SQL enquiries


[0.0001s] DEBUG info j4age: Fire Event => resolvelocation        

Performed SQL enquiries


[0.0004s] DEBUG info j4age: 1 Plugins found in DB        

Performed SQL enquiries

select * from `ijm61_jstats_configuration` where description like 'ext_%' and value = '1'


[0.0023s] DEBUG info j4age: Register plugin ext_ip2nation for event onpostinstallation        

Performed SQL enquiries


[0.0000s] DEBUG info j4age: Register plugin ext_ip2nation for event resolvelocation        

Performed SQL enquiries


[0.0000s] DEBUG info j4age: Event ext_ip2nation
extComponentip2nation Object
(
    [BuildVersion] => 1.0.3
    [id] => ext_ip2nation
    [published] => 1
    [config] => stdClass Object
        (
            [active] => 1
        )

    [name] => 
    [creationdate] => 
    [author] => 
    [authorUrl] => 
    [authorEmail] => 
    [copyright] => 
    [version] => 
)
        

Performed SQL enquiries


[0.0001s] DEBUG info j4age: JS 0.006 seconds (+0.003); 3.99 MB (+0.024) - Execute Module ext_ip2nation - Start resolvelocation        

Performed SQL enquiries


[0.0000s] DEBUG info j4age: getCountryCodeFromJSDatabase start        

Performed SQL enquiries


[0.0010s] DEBUG info j4age: getCountryCodeFromJSDatabase stop        

Performed SQL enquiries

SELECT i2n.country FROM ijm61_ip2nation i2n WHERE i2n.ip < 64692172 ORDER BY i2n.ip DESC LIMIT 0,1


[0.0016s] DEBUG info j4age: JS 0.009 seconds (+0.003); 3.99 MB (+0.003) - Execute Module ext_ip2nation - End resolvelocation        

Performed SQL enquiries

SELECT t.code , t.country FROM ijm61_ip2nationCountries t WHERE t.code='us'


[0.0001s] DEBUG info j4age: Location resolved
js_Location Object
(
    [ip] => 64692172
    [ip_exclude] => 
    [ip_type] => 
    [Tld] => js_Tld Object
        (
            [tld] => us
            [tld_name] => United States
            [tld_img] => us
        )

    [city] => 
    [code] => us
    [nslookup] => ec2-3-219-31-204.compute-1.amazonaws.com
)
        

Performed SQL enquiries


[0.0001s] DEBUG info j4age: Fire Event => beforecounting        

Performed SQL enquiries


[0.0004s] DEBUG info j4age: Add New IP using IP 64692172        

Performed SQL enquiries

INSERT IGNORE INTO ijm61_jstats_ipaddresses (ip, nslookup, ip_type, ip_exclude, code) VALUES ('64692172', 'ec2-3-219-31-204.compute-1.amazonaws.com' , '', '', 'us')


[0.0000s] DEBUG info j4age: 0Cookies available        

Performed SQL enquiries


[0.0000s] DEBUG info j4age: Client is empty        

Performed SQL enquiries


[0.0000s] DEBUG info j4age: New Client        

Performed SQL enquiries


[0.0000s] DEBUG info j4age: Retrieve Client Details        

Performed SQL enquiries


[0.0075s] DEBUG info j4age: Added New Client using ID 7928        

Performed SQL enquiries

SELECT * FROM ijm61_jstats_browsers br WHERE br.browser_id > 0 ORDER BY br.browser_ordering

SELECT LENGTH(o.os_key) AS strlen, o.os_id AS os_id, o.os_type AS os_type, o.os_key AS os_key, o.os_name AS os_name, o.os_img AS os_img FROM ijm61_jstats_systems o WHERE o.os_id > 0 ORDER BY o.os_ordering

INSERT IGNORE INTO ijm61_jstats_clients ( os_id, visitor_id, browser_id, browser_version, useragent, client_type, client_exclude) VALUES ( '', NULL, '1024', '', 'ccbot/2.0 (https://commoncrawl.org/faq/)', '2', '0')


[0.0001s] DEBUG info j4age: Set Cookie cltid=7928        

Performed SQL enquiries


[0.0001s] DEBUG info j4age: JS 0.017 seconds (+0.008); 4.07 MB (+0.071) - client & ip handling end        

Performed SQL enquiries


[0.0000s] DEBUG info j4age: Perform Visit counting process        

Performed SQL enquiries


[0.0004s] DEBUG info j4age: This is new Visit        

Performed SQL enquiries

SELECT v.visit_id FROM ijm61_jstats_visits as v WHERE v.client_id = 7928 AND v.ip = 64692172 AND v.changed_at >= 1606869112


[0.0003s] DEBUG info j4age: Set Cookie js_vsid=15406        

Performed SQL enquiries

INSERT INTO ijm61_jstats_visits (client_id, joomla_userid, changed_at, ip) VALUES ( 7928, 0, 1606897912, 64692172 )


[0.0000s] DEBUG info j4age: Visit 15406 registered        

Performed SQL enquiries


[0.0000s] DEBUG info j4age: URL called weezet.nl-HTTP/1.1        

Performed SQL enquiries


[0.0000s] DEBUG info j4age: Perform Page counting process         

Performed SQL enquiries


[0.0014s] DEBUG info j4age: Page counting process successful        

Performed SQL enquiries

SELECT page_id, page_title FROM ijm61_jstats_pages WHERE page = '/index.php/en/functions-en/abap-en' LIMIT 1

INSERT INTO `ijm61_jstats_impressions` (`page_id`, `visit_id`, `timestamp`) VALUES (699,15406,1606897912)


[0.0000s] DEBUG info j4age: Page impression 1 registered        

Performed SQL enquiries


[0.0000s] DEBUG info j4age: Referrer not set.        

Performed SQL enquiries


[0.0000s] DEBUG info j4age: Keyword & Referrer registered = False        

Performed SQL enquiries


[0.0000s] DEBUG info j4age: Fire Event => aftercounting        

Performed SQL enquiries


[0.0000s] DEBUG info j4age: JS 0.019 seconds (+0.002); 4.07 MB (+0.005) - Counting Visitor finished        

Performed SQL enquiries

Functions: Abap Consultant

November 2010
March 2012
Ineos Styrenics Fi/Co
Interfacing
MM
QM
SapScript

SD
Smartforms
October 2010 ISE Automotive Fi/Co
April 2010
October 2010
ING Real Estate Adobe Forms 
BP
CML
CMS
Fi/Co
Idoc's
Interfacing
February 2010 
March 2010
The Greenery MM
SD
January 2010  IMpact Retail MM
IS-Retail
SD
WM
May 2008  
December 2009
The Greenery Adobe Forms
Fi/Co
Interfacing
MM
PP
QM
RF
RFC
SapScript
SD
WM
September 2007
April 2008
Momentive Fi/Co
MM
SapScript
SD
September 2004
August 2007
Siemens Nederland CS
EDI
Fi/Co
Idoc's
MM
SD
August 2004 C&A HR
Interfacing
June 2004
July 2004
ABN Amro Fi/Co
Interfacing
February 2003
May 2004
ECI MM
OLE
RFC
January 2004 Kabel Zaandam Interfacing
MM
December 2002
January 2003
Makro HR
Interfacing
May 2002
November 2002
Siemens AMC NWE Idoc's
Interfacing
SD
Oktober 2001
May 2002
Forbo Interfacing
PP
WM
March 2001
October 2001
KPN INS Business Objects
CS
Fi/Co
Interfacing
OLE
SD
January 2001
February 2001
Dikema Interfacing
SD
November 2000
May 2001
The Solutions Web CATS
HR
Interfacing
OLE
April 2000
October 2000
Jaarbeurs Interfacing
Performance
SD
January 2000
February 2000
Dikema Interfacing
SD
December 1998
January 2000
IT's Idoc's
Interfacing
IS-Retail
MM
SapScript
SD
WM
September 1998
October 1998
MAN Roland Interfacing
MM
September 1998
December 1998
Dunnet SD
August 1998 Mid Ocean SD
February 1998
July 1998
Sony Fi/Co
Idoc's
Interfacing
MM

Joomla! Debug Console