Over 243 cafes, diners, restaurants, and Food On The Run lunch stops sorted by location, and cuisine for your convenience and planning your next Lunch adventure. Click below to interact with the urban glob map.
I find myself thinking more about salads as lunch time possibilities. I'm not sure how that happened. But I do enjoy seeing my lunch is a crisp, crunchy. This salad as the perfect mid-day meal item to satisfy my food cravings. Of course a salad with ...
Detour creates new lunch plans The GLOB Master and Jon Roosenraad,…
The GLOB Master has been hearing stories about how the…
When GLOBers say Las Margaritas I think parking. So many…
Lunch entree makes sharing lunch fun This lunch at long time…
Amidst friendly service it's all about flavor By Mike Sanford, GLOB…
Bar Americain dinner exceeds all expectations > NYC Road Trip: 9/11…
An excellent Asian lunch in serene setting By Lynn Dirk, GLOB…
Over 243 cafes, diners, restaurants, and Food On The Run lunch stops sorted by location, and cuisine for your convenience and planning your next Lunch adventure. Click below to interact with the urban glob map.
29 March, 2019 | Hits:22609
Nothing fancy about this BBQ shack By Mike Sanford, GLOB Editor You can count...
01 December, 2013 | Hits:18446
40 mile ride preps for anxiety, turkey day feast By Ron Cunningham, GLOB ...
04 April, 2013 | Hits:13068
Hello, my name is Kate Valdovinos, and welcome to Gainesville Greens, my contrib...
Gainesville's Natural Treasures
16 February, 2013 | Hits:10956
Join the GLOB Master as he seeks out beautiful picnic areas, lunchspots and fun,...
joomla ⇒ TzoyNDoiSm9vbWxhXFJlZ2lzdHJ5XFJlZ2lzdHJ5IjoxOntzOjc6IgAqAGRhdGEiO086ODoic3RkQ2xhc3MiOjE6e3M6OToiX19kZWZhdWx0IjtPOjg6InN0ZENsYXNzIjozOntzOjc6InNlc3Npb24iO086ODoic3RkQ2xhc3MiOjM6e3M6NzoiY291bnRlciI7aToxO3M6NToidGltZXIiO086ODoic3RkQ2xhc3MiOjM6e3M6NToic3RhcnQiO2k6MTYxMTA4MzI0OTtzOjQ6Imxhc3QiO2k6MTYxMTA4MzI0OTtzOjM6Im5vdyI7aToxNjExMDgzMjQ5O31zOjU6InRva2VuIjtzOjMyOiJiYmIxNmQ3OWQzMGE1ODJiYmY0MWU0ZmUyN2Y4NmM0MCI7fXM6ODoicmVnaXN0cnkiO086MjQ6Ikpvb21sYVxSZWdpc3RyeVxSZWdpc3RyeSI6MTp7czo3OiIAKgBkYXRhIjtPOjg6InN0ZENsYXNzIjowOnt9fXM6NDoidXNlciI7Tzo1OiJKVXNlciI6MjU6e3M6OToiACoAaXNSb290IjtiOjA7czoyOiJpZCI7aTowO3M6NDoibmFtZSI7TjtzOjg6InVzZXJuYW1lIjtOO3M6NToiZW1haWwiO047czo4OiJwYXNzd29yZCI7TjtzOjE0OiJwYXNzd29yZF9jbGVhciI7czowOiIiO3M6NToiYmxvY2siO047czo5OiJzZW5kRW1haWwiO2k6MDtzOjEyOiJyZWdpc3RlckRhdGUiO047czoxMzoibGFzdHZpc2l0RGF0ZSI7TjtzOjEwOiJhY3RpdmF0aW9uIjtOO3M6NjoicGFyYW1zIjtOO3M6NjoiZ3JvdXBzIjthOjE6e2k6MDtzOjE6IjEiO31zOjU6Imd1ZXN0IjtpOjE7czoxMzoibGFzdFJlc2V0VGltZSI7TjtzOjEwOiJyZXNldENvdW50IjtOO3M6MTI6InJlcXVpcmVSZXNldCI7TjtzOjEwOiIAKgBfcGFyYW1zIjtPOjI0OiJKb29tbGFcUmVnaXN0cnlcUmVnaXN0cnkiOjE6e3M6NzoiACoAZGF0YSI7Tzo4OiJzdGRDbGFzcyI6MDp7fX1zOjE0OiIAKgBfYXV0aEdyb3VwcyI7YToxOntpOjA7aToxO31zOjE0OiIAKgBfYXV0aExldmVscyI7YToyOntpOjA7aToxO2k6MTtpOjE7fXM6MTU6IgAqAF9hdXRoQWN0aW9ucyI7TjtzOjEyOiIAKgBfZXJyb3JNc2ciO047czoxMDoiACoAX2Vycm9ycyI7YTowOnt9czozOiJhaWQiO2k6MDt9fX19
SELECT `data`
FROM `j3_session`
WHERE `session_id` = 'q8e6do6mc94omruca2j855pqf4'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | j3_session | NULL | const | PRIMARY | PRIMARY | 602 | const | 1 | 100.00 | NULL |
| Status | Duration |
|---|---|
| starting | 0.1 ms |
| checking permissions | 0.0 ms |
| Opening tables | 0.0 ms |
| init | 0.0 ms |
| System lock | 0.0 ms |
| optimizing | 0.0 ms |
| statistics | 0.0 ms |
| executing | 0.0 ms |
| end | 0.0 ms |
| query end | 0.0 ms |
| closing tables | 0.0 ms |
| freeing items | 0.0 ms |
| cleaning up | 0.0 ms |
DELETE
FROM `j3_session`
WHERE `time` < '1611076049'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | DELETE | j3_session | NULL | range | time | time | 45 | const | 1 | 100.00 | Using where |
| Status | Duration |
|---|---|
| starting | 0.0 ms |
| checking permissions | 0.0 ms |
| Opening tables | 0.0 ms |
| init | 0.0 ms |
| System lock | 0.0 ms |
| updating | 0.2 ms |
| end | 0.0 ms |
| query end | 0.0 ms |
| closing tables | 0.1 ms |
| freeing items | 0.0 ms |
| cleaning up | 0.0 ms |
SELECT `session_id`
FROM `j3_session`
WHERE `session_id` = 'q8e6do6mc94omruca2j855pqf4'
LIMIT 0, 1
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | j3_session | NULL | const | PRIMARY | PRIMARY | 602 | const | 1 | 100.00 | Using index |
| Status | Duration |
|---|---|
| starting | 0.0 ms |
| checking permissions | 0.0 ms |
| Opening tables | 0.0 ms |
| init | 0.0 ms |
| System lock | 0.0 ms |
| optimizing | 0.0 ms |
| statistics | 0.0 ms |
| executing | 0.0 ms |
| end | 0.0 ms |
| query end | 0.0 ms |
| closing tables | 0.0 ms |
| freeing items | 0.0 ms |
| cleaning up | 0.0 ms |
INSERT INTO `j3_session` (`session_id`, `client_id`, `time`)
VALUES ('q8e6do6mc94omruca2j855pqf4', 0, '1611083249')
| Status | Duration |
|---|---|
| starting | 0.0 ms |
| checking permissions | 0.0 ms |
| Opening tables | 0.0 ms |
| init | 0.0 ms |
| System lock | 0.0 ms |
| update | 0.1 ms |
| end | 0.0 ms |
| query end | 0.0 ms |
| closing tables | 0.0 ms |
| freeing items | 0.0 ms |
| cleaning up | 0.0 ms |
SELECT extension_id AS id, element AS "option", params, enabled
FROM j3_extensions
WHERE `type` = 'component'
AND `element` = 'com_users'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | j3_extensions | NULL | ref | element_clientid,element_folder_clientid,extension | element_clientid | 302 | const | 1 | 10.00 | Using where |
| Status | Duration |
|---|---|
| starting | 0.1 ms |
| checking permissions | 0.0 ms |
| Opening tables | 0.0 ms |
| init | 0.0 ms |
| System lock | 0.0 ms |
| optimizing | 0.0 ms |
| statistics | 0.2 ms |
| preparing | 0.0 ms |
| executing | 0.0 ms |
| Sending data | 0.0 ms |
| end | 0.0 ms |
| query end | 0.0 ms |
| closing tables | 0.0 ms |
| freeing items | 0.0 ms |
| cleaning up | 0.0 ms |
SELECT b.id
FROM j3_usergroups AS a
LEFT JOIN j3_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 1
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | a | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
| 1 | SIMPLE | b | NULL | range | idx_usergroup_nested_set_lookup | idx_usergroup_nested_set_lookup | 4 | NULL | 2 | 100.00 | Using where |
| Status | Duration |
|---|---|
| starting | 0.0 ms |
| checking permissions | 0.0 ms |
| checking permissions | 0.0 ms |
| Opening tables | 0.0 ms |
| init | 0.0 ms |
| System lock | 0.0 ms |
| optimizing | 0.0 ms |
| statistics | 0.0 ms |
| preparing | 0.0 ms |
| executing | 0.0 ms |
| Sending data | 0.0 ms |
| end | 0.0 ms |
| query end | 0.0 ms |
| closing tables | 0.0 ms |
| freeing items | 0.0 ms |
| cleaning up | 0.0 ms |
SELECT id, rules
FROM `j3_viewlevels`
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | j3_viewlevels | NULL | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 3 | 100.00 | NULL |
| Status | Duration |
|---|---|
| starting | 0.0 ms |
| checking permissions | 0.0 ms |
| Opening tables | 0.0 ms |
| init | 0.0 ms |
| System lock | 0.0 ms |
| optimizing | 0.0 ms |
| statistics | 0.0 ms |
| preparing | 0.0 ms |
| executing | 0.0 ms |
| Sending data | 0.0 ms |
| end | 0.0 ms |
| query end | 0.0 ms |
| closing tables | 0.0 ms |
| freeing items | 0.0 ms |
| cleaning up | 0.0 ms |
SELECT folder AS type, element AS name, params
FROM j3_extensions
WHERE enabled >= 1
AND type ='plugin'
AND state >= 0
AND access IN (1,1)
ORDER BY ordering
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | j3_extensions | NULL | ref | extension | extension | 62 | const | 120 | 2.22 | Using index condition; Using where; Using filesort |
| Status | Duration |
|---|---|
| starting | 0.0 ms |
| checking permissions | 0.0 ms |
| Opening tables | 0.0 ms |
| init | 0.0 ms |
| System lock | 0.0 ms |
| optimizing | 0.0 ms |
| statistics | 0.1 ms |
| preparing | 0.0 ms |
| Sorting result | 0.0 ms |
| executing | 0.0 ms |
| Sending data | 0.0 ms |
| Creating sort index | 0.7 ms |
| end | 0.0 ms |
| query end | 0.0 ms |
| closing tables | 0.0 ms |
| freeing items | 0.0 ms |
| cleaning up | 0.0 ms |
SELECT extension_id AS id, element AS "option", params, enabled
FROM j3_extensions
WHERE `type` = 'component'
AND `element` = 'com_languages'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | j3_extensions | NULL | ref | element_clientid,element_folder_clientid,extension | element_clientid | 302 | const | 1 | 10.00 | Using where |
| Status | Duration |
|---|---|
| starting | 0.0 ms |
| checking permissions | 0.0 ms |
| Opening tables | 0.0 ms |
| init | 0.0 ms |
| System lock | 0.0 ms |
| optimizing | 0.0 ms |
| statistics | 0.1 ms |
| preparing | 0.0 ms |
| executing | 0.0 ms |
| Sending data | 0.0 ms |
| end | 0.0 ms |
| query end | 0.0 ms |
| closing tables | 0.0 ms |
| freeing items | 0.0 ms |
| cleaning up | 0.0 ms |
SELECT extension_id AS id, element AS "option", params, enabled
FROM j3_extensions
WHERE `type` = 'component'
AND `element` = 'com_k2'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | j3_extensions | NULL | ref | element_clientid,element_folder_clientid,extension | element_clientid | 302 | const | 1 | 10.00 | Using where |
| Status | Duration |
|---|---|
| starting | 0.1 ms |
| checking permissions | 0.0 ms |
| Opening tables | 0.0 ms |
| init | 0.0 ms |
| System lock | 0.0 ms |
| optimizing | 0.0 ms |
| statistics | 0.2 ms |
| preparing | 0.0 ms |
| executing | 0.0 ms |
| Sending data | 0.0 ms |
| end | 0.0 ms |
| query end | 0.0 ms |
| closing tables | 0.0 ms |
| freeing items | 0.0 ms |
| cleaning up | 0.0 ms |
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 j3_menu AS m
LEFT JOIN j3_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
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | m | NULL | ref | idx_client_id_parent_id_alias_language | idx_client_id_parent_id_alias_language | 1 | const | 1 | 5.00 | Using index condition; Using where; Using filesort |
| 1 | SIMPLE | e | NULL | eq_ref | PRIMARY | PRIMARY | 4 | gator_joomla3.m.component_id | 1 | 100.00 | Using where |
| Status | Duration |
|---|---|
| starting | 0.1 ms |
| checking permissions | 0.0 ms |
| checking permissions | 0.0 ms |
| Opening tables | 0.0 ms |
| init | 0.1 ms |
| System lock | 0.0 ms |
| optimizing | 0.0 ms |
| statistics | 0.1 ms |
| preparing | 0.0 ms |
| Sorting result | 0.0 ms |
| executing | 0.0 ms |
| Sending data | 0.0 ms |
| Creating sort index | 0.7 ms |
| end | 0.0 ms |
| query end | 0.0 ms |
| closing tables | 0.0 ms |
| freeing items | 0.0 ms |
| cleaning up | 0.0 ms |
SELECT extension_id AS id, element AS "option", params, enabled
FROM j3_extensions
WHERE `type` = 'library'
AND `element` = 'joomla'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | j3_extensions | NULL | ref | element_clientid,element_folder_clientid,extension | extension | 364 | const,const | 1 | 100.00 | NULL |
| Status | Duration |
|---|---|
| starting | 0.1 ms |
| checking permissions | 0.0 ms |
| Opening tables | 0.0 ms |
| init | 0.0 ms |
| System lock | 0.0 ms |
| optimizing | 0.0 ms |
| statistics | 0.2 ms |
| preparing | 0.0 ms |
| executing | 0.0 ms |
| Sending data | 0.0 ms |
| end | 0.0 ms |
| query end | 0.0 ms |
| closing tables | 0.0 ms |
| freeing items | 0.0 ms |
| cleaning up | 0.0 ms |
UPDATE `j3_extensions`
SET `params` = '{\"mediaversion\":\"4cf8fbc8456de6a098f925e95455a38b\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | UPDATE | j3_extensions | NULL | range | element_clientid,element_folder_clientid,extension | extension | 364 | const,const | 1 | 100.00 | Using where |
| Status | Duration |
|---|---|
| starting | 0.0 ms |
| checking permissions | 0.0 ms |
| Opening tables | 0.0 ms |
| init | 0.0 ms |
| System lock | 0.2 ms |
| updating | 0.1 ms |
| end | 0.0 ms |
| query end | 0.0 ms |
| closing tables | 0.0 ms |
| freeing items | 0.0 ms |
| cleaning up | 0.0 ms |
SELECT *
FROM j3_languages
WHERE published=1
ORDER BY ordering ASC
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | j3_languages | NULL | system | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 1 | 100.00 | NULL |
| Status | Duration |
|---|---|
| starting | 0.0 ms |
| checking permissions | 0.0 ms |
| Opening tables | 0.0 ms |
| init | 0.0 ms |
| System lock | 0.0 ms |
| optimizing | 0.0 ms |
| statistics | 0.1 ms |
| preparing | 0.0 ms |
| executing | 0.0 ms |
| Sending data | 0.0 ms |
| end | 0.0 ms |
| query end | 0.0 ms |
| closing tables | 0.0 ms |
| freeing items | 0.0 ms |
| cleaning up | 0.0 ms |
SELECT id, home, template, s.params
FROM j3_template_styles as s
LEFT JOIN j3_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
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | s | NULL | ALL | idx_template | NO INDEX KEY COULD BE USED | NULL | NULL | 3 | 33.33 | Using where |
| 1 | SIMPLE | e | NULL | ref | element_clientid,element_folder_clientid,extension | element_clientid | 303 | gator_joomla3.s.template,const | 1 | 5.00 | Using index condition; Using where |
| Status | Duration |
|---|---|
| starting | 0.1 ms |
| checking permissions | 0.0 ms |
| checking permissions | 0.0 ms |
| Opening tables | 0.0 ms |
| init | 0.0 ms |
| System lock | 0.0 ms |
| optimizing | 0.0 ms |
| statistics | 0.1 ms |
| preparing | 0.0 ms |
| executing | 0.0 ms |
| Sending data | 0.1 ms |
| end | 0.0 ms |
| query end | 0.0 ms |
| closing tables | 0.0 ms |
| freeing items | 0.0 ms |
| cleaning up | 0.0 ms |
SELECT extension_id AS id, element AS "option", params, enabled
FROM j3_extensions
WHERE `type` = 'component'
AND `element` = 'com_content'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | j3_extensions | NULL | ref | element_clientid,element_folder_clientid,extension | element_clientid | 302 | const | 1 | 10.00 | Using where |
| Status | Duration |
|---|---|
| starting | 0.1 ms |
| checking permissions | 0.0 ms |
| Opening tables | 0.0 ms |
| init | 0.0 ms |
| System lock | 0.0 ms |
| optimizing | 0.0 ms |
| statistics | 0.2 ms |
| preparing | 0.0 ms |
| executing | 0.0 ms |
| Sending data | 0.0 ms |
| end | 0.0 ms |
| query end | 0.0 ms |
| closing tables | 0.0 ms |
| freeing items | 0.0 ms |
| cleaning up | 0.0 ms |
SELECT a.rules
FROM j3_assets AS a
WHERE (a.id = 1)
GROUP BY a.id, a.rules, a.lft
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | a | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
| Status | Duration |
|---|---|
| starting | 0.1 ms |
| checking permissions | 0.0 ms |
| Opening tables | 0.0 ms |
| init | 0.0 ms |
| System lock | 0.0 ms |
| optimizing | 0.0 ms |
| statistics | 0.0 ms |
| preparing | 0.0 ms |
| executing | 0.0 ms |
| Sending data | 0.0 ms |
| end | 0.0 ms |
| query end | 0.0 ms |
| closing tables | 0.0 ms |
| freeing items | 0.0 ms |
| cleaning up | 0.0 ms |
SELECT b.rules
FROM j3_assets AS a
LEFT JOIN j3_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
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | a | NULL | const | idx_asset_name | idx_asset_name | 152 | const | 1 | 100.00 | Using temporary; Using filesort |
| 1 | SIMPLE | b | NULL | range | idx_lft_rgt | idx_lft_rgt | 4 | NULL | 11 | 100.00 | Using where |
| Status | Duration |
|---|---|
| starting | 0.1 ms |
| checking permissions | 0.0 ms |
| checking permissions | 0.0 ms |
| Opening tables | 0.0 ms |
| init | 0.0 ms |
| System lock | 0.0 ms |
| optimizing | 0.0 ms |
| statistics | 0.1 ms |
| preparing | 0.0 ms |
| Creating tmp table | 0.1 ms |
| Sorting result | 0.0 ms |
| executing | 0.0 ms |
| Sending data | 0.1 ms |
| Creating sort index | 0.0 ms |
| end | 0.0 ms |
| query end | 0.0 ms |
| removing tmp table | 0.0 ms |
| query end | 0.0 ms |
| closing tables | 0.0 ms |
| freeing items | 0.0 ms |
| cleaning up | 0.0 ms |
SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language, LENGTH(a.fulltext) AS readmore,
CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,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,c.published,
CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published
FROM j3_content AS a
LEFT JOIN j3_categories AS c
ON c.id = a.catid
LEFT JOIN j3_users AS ua
ON ua.id = a.created_by
LEFT JOIN j3_users AS uam
ON uam.id = a.modified_by
LEFT JOIN j3_categories as parent
ON parent.id = c.parent_id
LEFT JOIN j3_content_rating AS v
ON a.id = v.content_id
LEFT
OUTER JOIN (SELECT cat.id as id
FROM j3_categories AS cat JOIN j3_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
INNER JOIN j3_content_frontpage AS fp
ON fp.content_id = a.id
WHERE a.access IN (1,1)
AND c.access IN (1,1)
AND
CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2021-01-19 19:07:29')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2021-01-19 19:07:29')
ORDER BY
CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END DESC , a.created DESC
LIMIT 0, 9
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | PRIMARY | NULL | NULL | NULL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | NULL | NULL | no matching row in const table |
| 2 | DERIVED | parent | NULL | range | cat_idx,idx_left_right | cat_idx | 153 | NULL | 5 | 100.00 | Using index condition; Using temporary; Using filesort |
| 2 | DERIVED | cat | NULL | ALL | PRIMARY,idx_left_right | NO INDEX KEY COULD BE USED | NULL | NULL | 45 | 11.11 | Range checked for each record (index map: 0x21) |
| Status | Duration |
|---|---|
| starting | 0.2 ms |
| checking permissions | 0.0 ms |
| checking permissions | 0.0 ms |
| checking permissions | 0.0 ms |
| checking permissions | 0.0 ms |
| checking permissions | 0.0 ms |
| checking permissions | 0.0 ms |
| checking permissions | 0.0 ms |
| checking permissions | 0.0 ms |
| checking permissions | 0.0 ms |
| Opening tables | 0.0 ms |
| init | 0.1 ms |
| System lock | 0.0 ms |
| optimizing | 0.0 ms |
| optimizing | 0.0 ms |
| statistics | 0.1 ms |
| preparing | 0.0 ms |
| Creating tmp table | 0.0 ms |
| Sorting result | 0.0 ms |
| statistics | 0.1 ms |
| executing | 0.0 ms |
| end | 0.0 ms |
| query end | 0.0 ms |
| removing tmp table | 0.0 ms |
| query end | 0.0 ms |
| closing tables | 0.0 ms |
| removing tmp table | 0.0 ms |
| closing tables | 0.0 ms |
| freeing items | 0.0 ms |
| cleaning up | 0.0 ms |
SELECT COUNT(*)
FROM j3_content AS a
LEFT JOIN j3_categories AS c
ON c.id = a.catid
LEFT JOIN j3_users AS ua
ON ua.id = a.created_by
LEFT JOIN j3_users AS uam
ON uam.id = a.modified_by
LEFT JOIN j3_categories as parent
ON parent.id = c.parent_id
LEFT JOIN j3_content_rating AS v
ON a.id = v.content_id
LEFT
OUTER JOIN (SELECT cat.id as id
FROM j3_categories AS cat JOIN j3_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
INNER JOIN j3_content_frontpage AS fp
ON fp.content_id = a.id
WHERE a.access IN (1,1)
AND c.access IN (1,1)
AND
CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2021-01-19 19:07:29')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2021-01-19 19:07:29')
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | PRIMARY | NULL | NULL | NULL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | NULL | NULL | no matching row in const table |
| 2 | DERIVED | parent | NULL | range | cat_idx,idx_left_right | cat_idx | 153 | NULL | 5 | 100.00 | Using index condition; Using temporary; Using filesort |
| 2 | DERIVED | cat | NULL | ALL | PRIMARY,idx_left_right | NO INDEX KEY COULD BE USED | NULL | NULL | 45 | 11.11 | Range checked for each record (index map: 0x21) |
| Status | Duration |
|---|---|
| starting | 0.1 ms |
| checking permissions | 0.0 ms |
| checking permissions | 0.0 ms |
| checking permissions | 0.0 ms |
| checking permissions | 0.0 ms |
| checking permissions | 0.0 ms |
| checking permissions | 0.0 ms |
| checking permissions | 0.0 ms |
| checking permissions | 0.0 ms |
| checking permissions | 0.0 ms |
| Opening tables | 0.0 ms |
| init | 0.1 ms |
| System lock | 0.0 ms |
| optimizing | 0.0 ms |
| optimizing | 0.0 ms |
| statistics | 0.1 ms |
| preparing | 0.0 ms |
| Creating tmp table | 0.0 ms |
| Sorting result | 0.0 ms |
| statistics | 0.1 ms |
| executing | 0.0 ms |
| end | 0.0 ms |
| query end | 0.0 ms |
| removing tmp table | 0.0 ms |
| query end | 0.0 ms |
| closing tables | 0.0 ms |
| removing tmp table | 0.0 ms |
| closing tables | 0.0 ms |
| freeing items | 0.0 ms |
| cleaning up | 0.0 ms |
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM j3_modules AS m
LEFT JOIN j3_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN j3_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 <= '2021-01-19 19:07:29')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2021-01-19 19:07:29')
AND m.access IN (1,1)
AND m.client_id = 0
AND (mm.menuid = 15 OR mm.menuid <= 0)
ORDER BY m.position, m.ordering
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | m | NULL | range | PRIMARY,published,newsfeeds | published | 5 | NULL | 34 | 1.60 | Using index condition; Using where; Using filesort |
| 1 | SIMPLE | e | NULL | ref | element_clientid,element_folder_clientid | element_clientid | 303 | gator_joomla3.m.module,const | 1 | 10.00 | Using index condition; Using where |
| 1 | SIMPLE | mm | NULL | ref | PRIMARY | PRIMARY | 4 | gator_joomla3.m.id | 2 | 40.00 | Using where; Using index |
| Status | Duration |
|---|---|
| starting | 0.2 ms |
| checking permissions | 0.0 ms |
| checking permissions | 0.0 ms |
| checking permissions | 0.0 ms |
| Opening tables | 0.0 ms |
| init | 0.1 ms |
| System lock | 0.0 ms |
| optimizing | 0.0 ms |
| statistics | 0.1 ms |
| preparing | 0.0 ms |
| Sorting result | 0.0 ms |
| executing | 0.0 ms |
| Sending data | 0.0 ms |
| Creating sort index | 0.7 ms |
| end | 0.0 ms |
| query end | 0.0 ms |
| closing tables | 0.0 ms |
| freeing items | 0.0 ms |
| cleaning up | 0.0 ms |
SELECT *
FROM j3_k2_categories
WHERE parent=53
AND published=1
AND trash=0
AND access<=0
ORDER BY ordering
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | j3_k2_categories | NULL | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 46 | 2.17 | Using where; Using filesort |
| Status | Duration |
|---|---|
| starting | 0.1 ms |
| checking permissions | 0.0 ms |
| Opening tables | 0.0 ms |
| init | 0.1 ms |
| System lock | 0.0 ms |
| optimizing | 0.0 ms |
| statistics | 0.0 ms |
| preparing | 0.0 ms |
| Sorting result | 0.0 ms |
| executing | 0.0 ms |
| Sending data | 0.0 ms |
| Creating sort index | 0.1 ms |
| end | 0.0 ms |
| query end | 0.0 ms |
| closing tables | 0.0 ms |
| freeing items | 0.0 ms |
| cleaning up | 0.0 ms |
SELECT DISTINCT title, id, alias
FROM j3_k2_items
WHERE catid IN (53 )
AND published=1
AND trash=0
GROUP BY title
ORDER BY title
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | j3_k2_items | NULL | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 7550 | 0.10 | Using where; Using temporary; Using filesort |
| Status | Duration |
|---|---|
| starting | 0.0 ms |
| checking permissions | 0.0 ms |
| Opening tables | 0.0 ms |
| init | 0.0 ms |
| System lock | 0.0 ms |
| optimizing | 0.0 ms |
| statistics | 0.0 ms |
| preparing | 0.0 ms |
| Creating tmp table | 0.0 ms |
| Sorting result | 0.0 ms |
| executing | 0.0 ms |
| Sending data | 14.4 ms |
| Creating sort index | 0.4 ms |
| end | 0.0 ms |
| query end | 0.0 ms |
| removing tmp table | 0.0 ms |
| query end | 0.0 ms |
| closing tables | 0.0 ms |
| freeing items | 0.0 ms |
| cleaning up | 0.0 ms |
SELECT i.id
FROM j3_k2_items as i
LEFT JOIN j3_k2_categories c
ON c.id = i.catid
WHERE i.published=1
AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2021-01-19 19:07:29' )
AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2021-01-19 19:07:29' )
AND i.trash=0
AND i.access IN(1,1)
AND c.published=1
AND c.trash=0
AND c.access IN(1,1)
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | i | NULL | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 7550 | 0.03 | Using where |
| 1 | SIMPLE | c | NULL | eq_ref | PRIMARY,id | PRIMARY | 4 | gator_joomla3.i.catid | 1 | 5.00 | Using index condition; Using where |
| Status | Duration |
|---|---|
| starting | 0.1 ms |
| checking permissions | 0.0 ms |
| checking permissions | 0.0 ms |
| Opening tables | 0.0 ms |
| init | 0.1 ms |
| System lock | 0.0 ms |
| optimizing | 0.0 ms |
| statistics | 0.0 ms |
| preparing | 0.0 ms |
| executing | 0.0 ms |
| Sending data | 42.2 ms |
| end | 0.0 ms |
| query end | 0.0 ms |
| closing tables | 0.0 ms |
| freeing items | 0.1 ms |
| cleaning up | 0.0 ms |
SELECT tag.name, tag.id
FROM j3_k2_tags as tag
LEFT JOIN j3_k2_tags_xref AS xref
ON xref.tagID = tag.id
WHERE xref.itemID IN (1,3855,3848,3849,4,3850,3851,3852,3853,3854,8,9,1281,10,13,14,17,18,358,21,22,406,26,421,31,32,3856,420,36,347,338,39,412,47,48,49,3857,51,52,310,53,295,54,55,56,304,58,59,313,60,365,63,64,65,66,362,67,3858,4447,3859,3860,854,72,74,407,79,316,80,618,402,85,416,417,88,89,90,91,92,335,93,413,97,99,3862,350,3910,106,3863,114,116,117,122,3866,3867,3868,127,129,131,132,133,135,136,137,138,3869,3870,410,3871,3872,368,369,3873,3874,3875,3876,605,3877,418,419,154,155,3865,157,1433,159,3914,165,4844,166,167,168,169,397,398,3878,174,175,3879,177,3884,3881,182,306,183,184,3882,403,189,190,193,307,3883,196,197,318,7916,199,201,4089,296,4487,400,401,207,210,3122,399,212,361,215,405,3918,3919,3920,3921,3922,3923,3924,3925,3926,3927,3928,3929,3930,3931,3932,3933,3934,379,382,3889,383,386,395,5640,5641,391,390,227,228,392,394,411,409,3890,3891,3892,3893,3894,3895,3896,3897,3898,388,242,243,246,408,248,374,252,254,256,348,349,264,265,266,268,354,269,271,272,273,360,276,277,281,282,283,284,3909,285,287,312,3900,387,366,994,975,414,3917,3901,305,370,393,4722,355,328,323,367,363,7674,7675,7676,3911,297,385,294,384,346,3912,371,330,389,3907,3908,320,3902,3903,3904,504,378,322,353,633,333,3905,3906,327,4898,6460,4899,329,331,4684,4685,1761,668,422,423,424,425,438,427,428,429,430,433,431,432,434,435,779,436,437,439,440,441,442,443,3935,445,446,3936,448,449,450,451,452,3937,454,3938,456,457,458,459,462,463,464,465,466,467,469,613,470,472,471,473,559,474,507,3844,3196,4279,3199,3200,3202,3204,3205,3206,3207,3208,3209,3210,3211,5582,5445,3213,3214,4283,3216,3217,4284,4285,4286,3219,475,476,477,478,480,481,482,483,484,485,7996,7997,7998,486,487,488,489,490,3939,492,846,3940,3941,931,932,494,495,496,497,498,499,500,501,502,3942,3943,505,506,593,521,3944,3945,509,511,7377,7378,510,512,513,514,3946,529,516,517,518,519,520,522,523,524,525,526,527,3171,3172,530,531,532,533,534,535,542,536,537,538,539,540,541,543,544,545,546,547,548,549,550,551,552,553,554,555,3947,557,3948,560,561,568,562,563,564,565,566,567,569,570,572,574,571,573,575,576,577,578,579,580,581,582,583,584,587,585,586,588,589,590,591,614,592,594,595,596,597,598,599,600,601,602,604,606,607,608,609,610,611,612,615,617,619,620,3949,622,623,624,625,626,627,628,629,630,5593,632,634,635,636,637,649,639,640,641,642,643,644,646,3950,3951,650,651,652,713,653,654,655,656,658,657,659,660,661,662,3952,667,669,670,671,674,673,675,676,677,678,679,680,681,682,683,685,687,710,688,689,690,691,692,693,694,695,696,697,698,699,700,701,702,703,704,705,706,707,709,3954,714,715,720,716,717,718,719,721,722,723,724,725,726,727,755,752,728,729,730,731,732,733,734,735,736,737,738,739,741,742,743,744,745,746,747,750,751,753,754,756,757,758,759,760,761,762,764,765,766,767,768,769,770,771,772,773,775,776,777,778,780,781,782,783,784,785,786,788,789,814,790,791,792,793,794,795,3957,810,6572,3861,798,799,800,801,812,802,803,804,805,806,807,808,809,811,813,815,816,817,818,819,820,3958,823,824,825,3959,827,828,829,830,3960,833,837,3961,836,838,839,840,841,842,843,844,845,847,848,849,850,851,852,853,855,856,857,858,859,860,861,863,3962,3963,864,865,866,867,868,869,870,871,881,872,873,874,875,876,877,878,3964,3965,883,882,884,885,3969,3967,3968,886,887,3966,889,890,892,897,898,3970,900,901,902,903,904,905,906,907,908,921,909,911,913,914,915,916,919,920,922,925,923,924,927,926,928,930,933,934,935,937,4810,940,936,938,939,941,942,943,944,945,946,947,948,950,951,952,953,954,955,956,957,958,959,960,961,962,963,964,4351,3972,968,973,969,970,971,976,985,978,979,980,982,983,984,986,987,988,993,989,990,991,6391,1034,995,996,997,998,1001,1041,999,1000,1003,1002,1194,1008,1009,1004,1005,1006,1020,1019,1007,1010,1011,1012,1013,1014,1015,1016,1017,1018,1022,1023,1024,1025,1026,1027,3973,1029,1030,1031,1032,1033,1035,1036,1037,1038,1039,1040,1042,1049,1043,1045,1046,1047,3974,1050,1051,1052,1053,1054,1055,1067,1056,1057,1058,1059,1060,3975,3976,1063,1064,1065,1066,1068,1071,1070,1093,1073,1074,1075,1076,1078,1080,3982,3983,3977,3978,1081,1082,1083,1084,1085,1086,1087,1088,1089,1090,1091,1092,1094,3979,1096,1097,1101,1098,1099,1102,1103,1104,3980,3981,1106,1108,1109,1110,1111,1112,1113,1114,1116,1117,1118,1119,1120,1121,1123,1124,1125,1126,1127,1128,1129,1130,1131,1132,1135,1133,1136,1137,1138,3985,3986,3987,3988,1141,1142,1143,1144,1145,1146,1156,1147,1148,1149,1150,1151,1152,1153,1154,1158,1157,3989,3990,1160,1161,1162,1163,1164,1165,3992,1167,1168,1169,1170,1184,1171,1172,1173,1174,3993,1176,1177,1178,1179,1181,1182,1183,1202,3994,1193,1186,1187,1188,1190,1191,1192,1195,1196,1198,1199,1200,1203,1201,1204,1205,1206,1207,1208,1209,1215,1210,1211,1212,1213,1214,1216,3995,1218,1219,1220,1221,1222,1223,1224,1225,1227,1228,4953,1237,2131,1538,1492,4214,4215,4216,1319,1254,1814,1304,1283,1295,1232,7762,2003,1990,4058,1615,1815,4248,1546,1418,1282,1353,1434,2476,4220,4221,4222,2462,1238,4952,1241,4951,3996,1243,1244,1245,1247,1249,1250,1251,1252,1253,1255,3997,1257,1258,1259,1260,2618,7892,3998,1263,3999,4000,1265,1266,1267,1269,1270,1271,1272,1273,1275,1296,1276,1277,1278,1279,1280,1813,1564,1284,1285,1287,1288,1289,1291,1292,1293,1294,1297,1298,1375,1411,1299,1300,1301,1302,1303,1305,1306,1307,1308,1309,1310,1311,1312,1313,1314,1315,1316,1317,1318,1320,1321,1322,1323,1324,1325,4001,1327,1328,1329,1330,1331,4002,1334,1335,1336,1337,1338,1339,1341,1342,1343,1345,1346,1347,1348,1349,1350,1351,1352,1354,1356,1357,1358,1359,1360,1514,1362,1363,1364,1365,1366,1367,1368,1939,1369,1370,1371,1372,1373,1374,1376,1377,1378,7696,1379,1380,1381,1382,1383,1384,1385,1386,1388,1389,1390,1391,1392,1393,1394,1395,1397,1513,1398,1399,1401,1400,1402,1403,2119,1406,1407,1408,1409,4007,1412,1413,1414,1415,1416,1417,1419,1420,1421,1424,1422,1423,1425,1426,1427,1429,1430,4008,4009,4010,1435,1436,1437,1438,1439,1440,4247,1441,1444,1442,4188,1443,1463,4011,4012,1446,1447,4014,1449,1451,1450,1452,1453,1454,1455,1456,1457,1458,1459,1460,1461,4015,4016,4017,1466,1467,1468,1469,1470,1471,1472,1473,1474,1475,1476,1477,1478,1479,1481,1482,1483,4018,1486,1487,1488,1489,1490,1491,1493,1494,1495,1496,1497,1498,1499,1500,1501,1503,4019,1504,1505,1506,1507,1508,1509,1510,1511,1512,1515,1516,4020,1518,1519,1520,1521,1522,1523,4021,1525,1526,1527,1528,1530,2133,1531,1532,1533,1534,1535,1536,1539,1540,1541,1542,1543,1544,1545,1547,1548,1549,1550,1551,4022,1554,1556,1555,4023,1558,1559,1560,1562,1563,1565,1566,1567,1570,1569,4025,4027,1573,1574,1575,1576,1577,1578,1579,1580,1581,1582,1583,1584,1585,1586,4029,1588,1589,1590,4030,1592,1593,1594,1595,1596,1597,1598,1599,1600,1601,1602,1603,4031,1605,1606,1607,1608,1609,1610,1611,1612,1613,1614,1616,1617,1618,1619,1621,1622,1623,1624,1625,1626,4032,1628,1629,1630,1631,1632,1633,1634,1635,1636,1637,1638,1639,1640,4033,1643,1644,1645,1646,1648,1649,1650,1651,1652,1654,1653,1655,1656,1657,1658,1660,1659,1662,1663,1664,1665,1666,1667,1668,1669,1670,1671,1672,1673,1674,1675,1676,1677,4036,1680,1681,1683,1684,1687,1688,1689,1690,1691,1692,1693,4037,1696,1697,1698,1699,1700,1701,1702,1703,1706,1704,1705,1707,1714,3956,1709,1710,1711,4040,4041,1712,4038,4039,1715,1716,1717,4042,4043,1721,1722,1723,1724,1725,1726,1727,1728,1729,1730,1731,1743,1732,1733,1734,1735,1738,1740,1739,1742,1744,1745,1746,1747,1748,1749,1750,1751,1752,1753,1754,1755,1757,1758,2606,1759,4045,4046,4048,4049,4050,1762,1763,1764,1765,1766,1767,1768,1769,1770,1771,1772,1773,1774,1777,1775,4051,1778,4052,1781,1782,1783,1784,1785,1796,1786,1788,1789,1790,1791,1792,4055,1795,1812,1797,1799,1800,1801,1802,1803,1804,1805,1806,1807,1808,1809,1810,1811,4056,1817,1818,1819,1820,1821,1823,1826,1827,1828,1829,1830,1832,1833,1834,1835,1836,1837,1838,1839,1840,1843,1841,1842,1844,1845,4061,4062,1847,1848,1849,1850,1851,1852,1853,1854,1855,1856,1857,1858,1859,1860,4063,4064,1862,1863,1864,1865,1866,1867,1868,1869,1870,1871,1872,1873,1874,1875,4065,4066,1877,1878,1879,1883,1880,1881,1882,1884,4067,1886,1887,1888,1889,1890,1891,1892,1893,1894,1895,1896,1897,1907,1898,1899,4068,4070,1904,1905,1906,1908,1909,1910,1911,1912,2719,1914,1915,1916,1917,4071,1919,1920,1921,1922,1923,1924,1925,1926,1927,1928,1929,1930,1931,1932,1933,1934,1935,1937,1938,4072,4073,4074,1941,1943,2065,1942,1944,1945,1946,1947,1948,1949,1950,1951,1952,1953,1954,1955,1957,1958,2629,1959,4075,4078,1962,1961,3277,1964,1965,1966,1967,1968,1969,1970,1971,1972,1973,1974,1975,1977,1976,4076,4077,1984,1985,1986,1989,1991,1992,1993,1994,1995,1996,1997,1998,1999,2000,2002,2004,2005,2006,2007,2008,2009,2010,2011,2012,2013,2014,2015,2016,2017,2018,2019,2020,7069,2021,4120,2022,2023,2025,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2039,2040,2041,2042,2043,2044,2045,2046,2047,2048,2049,2052,2053,2054,2055,2057,2058,2059,2060,2061,2062,2063,2811,2066,2067,2068,2069,2070,2071,2072,2073,4079,2075,2076,2077,2078,2079,2080,2081,2082,4080,4081,2084,2085,2086,2087,2088,2089,2090,2091,2092,2093,2095,2097,2099,4083,4084,4085,2104,4086,2106,2107,2109,2110,4087,4088,2114,2115,2116,2117,2118,4090,2122,2124,2125,2126,2127,2128,2129,2130,4091,2134,2135,2136,2137,2138,2139,2140,2141,2142,2143,2144,2145,2146,2147,2148,4661,4004,2151,2152,2153,2154,2155,2156,2158,4179,4177,2159,2180,2160,4092,4093,2162,2163,2164,2165,2166,2167,2168,2169,2170,2171,2172,4094,4095,4096,2174,4280,4281,4282,2176,2177,2178,2266,2179,4098,2182,2183,2184,2185,2186,2187,2188,2189,2190,2191,2192,2193,2194,2195,2196,2604,4099,4100,2198,2199,2200,2201,2202,2203,2204,2205,2206,2207,2208,4101,4102,4103,4104,4105,4106,2930,2211,4108,4109,4110,2214,2227,4111,2215,2260,4059,4060,2219,3635,2220,2221,2222,2223,2224,2225,2226,2228,2229,2230,2231,2232,2233,2234,2235,2236,4112,2239,2240,2241,2242,2243,2245,2246,2247,2248,2249,2250,4113,2254,3885,3886,3887,2257,2258,4128,4122,4115,4116,4117,2261,2262,2263,2264,2265,2267,4118,4119,2269,2270,2272,2273,2274,2275,2281,2276,2277,2278,2279,2280,4123,4124,2284,4126,2286,4127,2288,2289,2290,2292,2293,2294,2295,2296,2297,2298,2299,2300,2301,2302,2303,2304,4129,4724,4130,2307,2309,4131,4140,4132,4133,4134,2313,2314,2315,2316,2317,2318,2319,2320,2321,2322,2323,2324,2325,4136,4137,4138,2366,2328,4139,2333,2334,2335,2336,2337,2338,2339,3913,2341,4141,4142,4144,4146,4147,4148,4149,4150,4151,4152,4153,4154,4155,4156,4157,4158,4159,4160,4161,2359,4172,2345,4173,4174,4175,4176,2348,2349,2350,2351,2352,2353,2355,2356,2357,2358,2360,2362,2363,2364,4178,2367,2368,2369,2370,2371,2372,2373,2374,2375,2376,2377,2378,2379,2381,2382,2383,2384,2385,2464,2386,2387,2388,2392,2393,2394,2395,2396,2398,2399,4194,4195,4196,2400,4185,2403,2404,2405,2406,2408,2409,2410,2412,2413,2415,2416,2417,2418,2419,2420,2421,2422,2423,4187,2426,2427,2428,2429,2431,2430,2432,2433,2434,2435,2436,2438,2439,2440,2441,2442,2443,2444,2445,2447,2448,2449,4190,4191,2451,2452,2453,2454,2455,2456,2458,2460,2461,5280,5281,2463,4192,4193,2466,2467,2468,2469,2470,2471,2472,2473,2474,2475,2478,2479,2480,2481,2482,2483,2485,2486,2487,2488,2489,2490,4197,2492,2493,2494,4198,4199,4200,2496,4201,2498,2499,2500,2501,2502,2503,2504,2505,2506,2507,4202,2509,2510,2511,2512,2513,2514,2515,4203,2517,2518,2519,2520,2521,2522,2523,2524,2525,2526,2527,2528,2529,2530,2531,2533,2534,2535,2536,2541,2538,2539,2540,2542,2543,2544,2545,4205,4204,2548,2549,2550,2551,2552,2565,2566,2555,2557,2558,2559,2561,2562,4006,2564,2567,2568,2569,2570,2571,2572,2573,2574,2575,2576,2577,2579,2580,4206,2582,2583,4207,2585,2586,2587,2589,2590,2591,2592,2593,4209,2595,2596,2597,4208,2599,2600,3991,2603,2607,2608,2609,2610,2611,2612,2613,2614,2615,2616,2617,2619,4210,4211,4212,2622,2623,2624,2625,2626,2627,2628,2630,2631,2632,2633,2634,2635,2636,2637,2638,2639,2640,2641,2642,2643,2644,2645,2646,2647,2648,4213,2650,2651,2652,2654,2656,2657,2658,2659,2660,2661,2662,2663,2664,2665,2666,2667,4217,4218,2669,4219,2671,2672,2673,2674,2675,2676,2677,2678,2679,2680,2681,2690,2682,2683,2685,2686,2688,2689,2691,2692,2693,2694,2696,2697,2698,2699,2700,2702,2701,2703,2704,2706,2707,2708,2709,2710,2711,2712,2714,2715,2716,2717,2718,2720,2721,2722,2723,2724,2725,2726,2727,2728,2729,2730,2731,2732,2733,2735,2736,2739,4223,2741,2742,2743,2744,2745,2746,2747,2748,2749,2750,2751,2753,2754,2755,2756,2757,2758,4224,2761,2762,2763,2764,2765,2767,2768,2769,2772,2771,2773,2777,2775,4660,4225,2794,2778,2779,2780,2781,2782,2783,2784,2785,2786,2787,2788,3916,2791,2792,4226,4227,2795,2796,2797,2798,2799,2800,2801,2802,2803,2804,2805,2807,2806,2808,2809,4228,4230,2812,2813,2814,2815,2816,2817,2818,2819,2820,2821,2822,4231,4232,4233,4235,4236,2824,2826,4237,4238,2828,2830,2831,2832,2833,2834,2835,2836,2837,2838,2839,2840,2841,2842,2843,2844,2845,2846,2849,2850,2851,2852,2853,4239,4240,2855,2856,2857,2858,2859,2860,2861,2862,2863,2864,2865,2866,2867,2869,2870,2894,7933,2871,2872,2890,4242,4243,4244,2874,2875,2876,2877,2878,2879,4245,2881,2882,2883,2884,2886,2888,2889,2892,2893,2895,4246,2897,2898,2899,2900,2901,2902,2903,2904,2905,2907,2908,2909,2910,2911,2912,2914,2915,2916,2917,2918,2919,2920,2921,2923,2924,2925,2927,3915,2950,2929,2931,2932,2934,2935,2936,2937,2938,2939,4249,2941,2942,2943,2944,2945,2946,2947,2948,2949,2951,2952,2953,2954,2955,2956,2957,2958,2959,2960,2961,2962,4251,2964,2965,2966,2967,2968,2969,2970,2972,2971,2973,2974,2975,2976,2977,2978,2979,4252,4253,2981,2982,2983,2984,2985,2986,4254,2988,2989,2990,2991,2992,2994,2995,2996,2997,2998,2999,3000,3001,3002,3006,3003,4255,3005,3007,3008,3009,3010,3011,3012,4256,4257,4258,4259,3015,3016,3017,3018,3019,3021,3024,3025,3027,3026,3028,3029,3030,3031,3032,3033,3034,3035,3038,3039,3041,3042,3052,3044,3045,6663,3047,3049,3050,3051,3053,3054,3055,3056,3057,3059,3060,3061,3063,3064,3065,3066,3068,3070,3071,3075,3077,3076,3078,3080,3094,3081,3083,3084,3086,3087,3141,3088,3089,3090,3091,3092,3093,3096,3098,3099,3100,3101,3102,3107,3104,3105,3106,3108,3109,3112,3110,3113,3114,3115,3116,3117,3118,3119,3120,3121,3123,3124,3126,4264,3129,3245,3246,3188,3131,3132,3133,3134,3135,3136,3137,3138,3139,4266,4267,3142,3143,3144,3145,3146,3147,3148,4268,3150,4270,3151,4269,3153,3155,5989,5973,4271,4272,4273,3158,3159,3160,3161,3162,3163,3164,3165,3166,3167,3168,3169,3170,3193,4278,3173,3175,4274,4275,4276,3180,3181,3182,3183,3184,3185,3186,3349,3189,3190,3191,3220,4287,3222,3223,3224,4290,3226,3227,3243,3228,3229,4291,4292,4293,3231,3232,3233,3234,3235,3236,3237,3238,3239,3240,3241,3242,3247,3248,3249,3250,3252,4294,3254,3255,3256,3258,3259,4296,3260,4597,3263,3264,3265,3267,3268,3269,3271,3272,3273,3274,3275,3276,3279,3280,4297,4298,3282,3283,3284,3285,3286,3287,4299,3289,3290,4300,3292,3293,4301,4302,3296,3297,3298,3299,3300,3301,3302,3303,3304,3305,3306,3307,3308,3309,4303,3311,3312,3313,4304,3315,3316,3317,4305,4306,3320,3321,3322,3323,3324,3325,3326,3327,3328,3329,3330,3331,3334,4307,4308,4309,3335,3336,3337,3338,3339,3340,3341,3342,3343,3344,3345,4310,3347,3348,4311,3351,3353,3355,3354,3356,3357,3358,3359,3361,3362,3363,3364,3365,3366,3367,4312,3369,3370,3371,3372,3373,3375,3376,3377,3378,3512,3461,3463,3380,3758,3382,3383,4315,3385,3386,3387,3388,3389,3390,3391,3392,3393,3813,3394,3395,4316,3397,3398,3399,4355,4356,4357,3401,3684,3400,3402,4317,4318,4320,3405,3406,3407,3408,3409,3410,3411,3412,3413,3414,3415,3416,4321,4323,4324,3418,3419,3420,3421,3422,3423,3424,3425,3426,4325,4326,4327,4328,3428,3429,3430,3431,3432,3433,3434,3435,3436,3819,3438,3439,3441,3442,3443,3444,3445,3446,3447,3448,3449,3450,3451,3452,3453,3454,3455,3456,3457,3458,3460,4162,3464,4329,3466,3467,3468,3469,3470,3471,3472,3473,4330,3475,3476,3477,3479,3480,3481,3482,3483,3484,3485,3486,3487,4331,4332,3488,3489,3490,3491,3750,3864,3493,3495,4358,4333,3497,3498,3499,3500,3501,3502,3503,3504,3505,3506,3507,3508,3509,3510,3511,4334,4335,4336,3514,3515,3516,3517,3518,3519,3520,3521,3522,3550,3523,3524,3525,4337,4338,4339,3527,3528,3529,3530,3531,3532,3533,3534,3535,3536,3537,3538,3539,3540,3541,3542,4340,4341,4342,4343,3544,3545,3546,3547,3548,3549,4344,3551,3552,3553,3554,3555,3557,4345,3559,5030,4346,3561,4163,4164,4165,4166,4167,4168,4169,4171,3563,3564,3565,3566,3567,3568,3569,3570,3571,3572,3573,3575,3576,3577,3578,3579,3581,3582,3583,3584,3585,3586,3587,3588,3589,3590,3591,3592,3594,3595,3596,3597,3598,3599,3600,3601,3602,3603,3604,3605,3606,3607,3608,3609,3610,4347,3612,3613,3614,3615,3616,3617,3618,3619,3620,3621,3622,3623,4348,4349,4350,3625,3626,3627,3628,3629,3630,3631,3632,3633,3634,3637,3636,3638,4352,4353,3640,3641,3642,3643,3644,3645,3646,3647,3648,3649,3650,3651,3652,3653,3656,3657,3658,3659,3660,3662,3663,3664,3665,3666,3667,3668,4379,3670,3671,3672,3673,3674,3675,3676,3677,3678,3679,3680,3681,3682,3683,3686,3687,3688,3689,3690,3691,3692,3693,3694,3695,3696,3697,3698,3812,3702,3703,4360,3705,3706,3707,3708,3709,3710,3711,3712,3713,3714,4361,4362,4363,3717,3718,3719,3720,3721,3722,3723,3724,3725,3726,3727,3728,3729,4364,4365,4366,4367,3731,3732,3733,3734,3735,3736,3737,3738,3739,3740,3741,3742,3743,3744,3745,3746,3747,3748,3749,4368,4369,4370,4371,3752,3753,3754,3755,3757,4372,3761,3762,3763,3764,3765,3766,3767,3768,3769,3770,3771,3772,3773,3774,3775,3776,3777,3778,3779,3780,3781,3782,3783,4373,3785,3786,3787,3788,3789,3790,3792,3793,3794,3795,3796,3797,3798,3799,3800,3801,3802,3803,3804,3805,3806,4374,3808,3809,3810,3811,3814,3815,4375,3818,3820,3821,3822,3823,3824,3836,4265,3845,3826,3827,3828,3829,3830,3831,3832,3833,3834,3835,3837,3838,3839,3840,3841,4376,4377,4380,4378,4381,4382,4384,4385,4386,4387,4388,4390,4391,4392,4393,4414,4394,4395,4396,4397,4398,4399,4400,4401,4402,4403,4404,4405,4406,4408,4409,4410,4412,4413,4415,4416,4417,4418,4419,4420,4422,4423,4425,4427,4428,4429,4430,4431,4432,4433,4434,4435,4436,4437,4438,4439,4440,4443,4444,4445,4449,4450,4451,4469,4452,4453,4454,4455,4456,4457,4458,4459,4460,4461,4462,4463,4464,4465,4466,4467,4936,4468,4470,4471,4472,4473,4474,4475,4477,4478,4479,4480,4482,4483,4484,4485,4486,4488,4489,4490,4491,4492,4493,4494,4495,4496,4497,4498,4499,4501,4502,6530,4513,4503,4504,4505,4506,4508,4509,4510,5575,4511,4512,4514,4515,4516,4518,4519,4520,4521,4522,4523,4524,4525,4527,4528,4529,4530,4531,4532,4534,4535,4536,4537,4539,4538,4540,4541,4542,4543,4544,4545,4546,4547,4549,4551,4552,4610,4555,4557,4556,4558,4561,4559,4560,4562,4563,4564,4565,4566,4567,4568,4569,4570,4571,4573,4575,4609,4577,4576,4579,4581,4582,4583,4584,4585,4586,4587,4588,4590,4591,4592,4594,4595,4596,4598,4600,4602,4603,4604,4605,4648,4606,4608,4611,4613,4614,4615,4616,4617,4619,4620,4622,4623,4624,4625,4626,4627,4629,4630,4631,4633,4634,4636,4637,4639,4640,4641,4642,4644,6055,4647,5028,4649,4654,4657,4658,4662,4682,4683,4686,4687,4688,4689,4692,4693,4694,4695,4697,4699,4700,4701,4702,4703,4704,4705,4706,4707,4708,4709,4710,4713,4714,4715,4716,4717,4718,4719,4720,4721,4725,4726,4727,4729,4730,4732,4733,4734,4735,4736,4737,4738,4739,4740,4741,4742,4743,4744,4745,4746,4747,4748,5524,4750,4751,4752,4753,4755,4756,4757,4758,4759,4760,4761,4762,4763,4764,4765,4766,4767,4768,4769,4770,4771,4772,4773,4774,4775,4776,4778,4779,4780,4781,7068,4783,6073,4784,4785,4786,4788,4789,4790,4791,4792,4793,4794,4795,4796,4797,4798,4800,4801,4802,4803,4804,4805,4806,4807,6414,4808,4809,4811,4812,4813,4814,4815,4816,4817,4818,4819,4820,4822,4823,4825,6662,5716,4826,5952,4829,6445,4830,4831,4832,4833,4834,4835,4838,4839,4840,4841,4842,4843,4845,4846,4848,4849,4850,4851,4852,4854,4855,4856,4859,4860,4862,4863,4864,4865,4866,5905,4868,4869,4870,4871,4872,4873,4874,4875,4876,4877,4878,4879,4880,4881,4882,4883,4884,4885,4886,4887,4888,4890,4891,4892,4893,4894,4896,4897,4900,4901,4902,4904,4907,4908,4909,4910,4911,4913,4914,4915,4916,4917,4919,4920,4921,4922,4924,4925,4926,4927,4928,4930,4932,4933,4934,4935,4937,4968,5695,4938,4939,4940,4941,4942,4943,4944,4945,4947,4950,4954,4955,4957,4958,4959,4960,4962,4963,4964,4965,4966,4967,6840,4971,4972,4973,4970,4974,4975,4976,4977,4978,4979,4980,4981,4982,4983,4984,4985,4986,4987,4989,4990,4992,4994,4995,4996,4997,4998,4999,5000,5001,5002,5003,5004,5005,5006,5007,5008,5009,5010,5011,5012,5013,5014,5015,5016,5017,5018,5019,5020,5021,5022,5023,5024,5025,5026,5027,5029,5031,5032,5033,5034,5035,5036,5037,5038,5039,5040,5041,5042,5044,5237,5046,5751,5047,5049,5050,5051,5052,5053,5054,5055,5057,5058,5059,5060,5061,5062,5324,5063,5064,5065,5066,5067,5068,5069,5070,5071,5072,5073,5074,5078,5075,5076,5077,5079,5080,5081,5082,5083,5084,5085,5086,5087,5088,5089,5090,5091,5093,5094,5095,5097,5098,5122,5099,5100,5101,5102,5103,5104,5105,5106,5107,5108,5109,5110,5111,5112,5113,5114,5115,5116,5117,5118,5119,5120,5121,5123,5124,5125,5126,5127,5129,5130,5131,5132,5133,5134,5135,5136,5137,5138,5139,5140,5141,5142,5143,5144,5145,5146,5147,5148,5149,5150,5151,5152,5153,5155,5156,5157,5159,5160,5161,5168,5162,5163,5164,5165,5166,5167,5169,5170,5171,5172,5173,5174,5176,5177,5178,5179,5180,5181,5183,5185,5186,5677,5205,5187,5188,5191,5192,5193,5194,5195,5196,5197,5198,5199,5200,5201,5202,5203,5204,5206,5207,5208,5210,5212,5213,5214,5215,5216,5217,5218,5219,5220,5261,5221,5222,5224,5225,5226,5227,5228,5229,5230,5231,5232,5233,5234,5235,5236,5238,5239,5240,5241,5242,5243,5244,5245,5246,5248,5249,5250,5251,5252,5253,5254,7677,7678,5255,5256,5257,5258,7067,5738,5259,5260,5262,5263,5264,5265,5266,5267,5268,5269,5270,5271,5272,5273,5274,5275,5276,5277,5279,5278,5282,5283,5284,5285,5286,5287,5288,5289,5290,5291,5292,5293,5294,5307,5295,5296,5297,5298,5299,5300,5301,5302,5303,5304,5305,5306,6365,5308,5309,5311,5313,5314,5315,5316,5317,5318,5319,5321,5322,6516,5323,5326,5328,5329,5330,5331,5332,5333,5334,5335,5336,5337,5338,5339,5340,6694,5345,5341,5342,5343,6231,5346,5347,5348,5349,5350,5351,5352,5353,5354,5355,5356,5371,5357,5358,5359,5360,5361,5362,5363,5364,5365,5366,5367,5368,5369,5372,5370,5385,5373,5374,5376,5377,5378,5379,5380,5381,5382,5383,5384,5386,5387,5388,5389,5390,5392,5393,5394,5395,5396,5397,5399,5401,5402,5403,5404,5405,5406,5407,5408,5409,5410,5411,5412,5413,5414,5415,5416,5417,5418,5419,5420,5421,5422,5423,5424,5425,5427,5429,5430,5431,5432,5433,5434,5435,5436,5437,5438,5439,5440,5442,5443,5466,5444,7312,5448,5449,5451,5452,5453,5454,5455,5456,5457,5459,5460,5461,5462,5463,5464,5465,5467,5486,5468,5469,5470,5471,5472,5473,5474,5475,5476,5477,5478,5479,5480,5481,5482,5483,5484,5485,5487,5488,5489,5490,5491,5492,5493,5494,5495,5496,5497,5498,5499,5500,5502,5501,5503,5504,5505,5506,5508,5509,5510,5511,5512,5513,5514,5515,5516,5517,5518,5519,5520,5522,5523,5525,5526,5527,5528,5529,5530,5531,5532,5533,5535,5536,5537,5538,5539,5541,5545,5547,5548,5549,5551,5552,5554,5555,5557,5573,5558,5559,5560,5561,5562,5563,5564,5565,5566,5568,5569,5570,5572,5574,5576,5577,5578,5580,5581,5583,5584,5585,5586,5587,5588,5589,5590,5591,5592,6772,5594,5595,5608,5596,5598,5597,5599,5600,5601,5602,5603,5604,5605,5606,5607,5610,5611,5612,5613,5614,5615,5616,5617,5618,5619,5620,5621,6746,5623,5625,5626,5627,5628,5629,5630,5631,5632,5633,5634,5635,5636,5637,5638,5639,5642,5644,5645,5646,5647,5648,5649,5650,5651,5652,5653,5654,5655,5656,5657,5658,5659,5660,5661,5662,5663,5664,5665,5666,5667,5668,5669,5670,5671,5672,5673,5674,5675,5676,5680,5681,5682,5683,5684,5685,5686,5687,5688,5689,5690,5692,5693,5696,5698,5699,5700,5701,5704,5705,5706,5707,5708,5709,5710,5711,5712,5713,5714,5715,5717,5719,5720,5721,5722,5723,5724,5725,5726,5727,5728,5729,5730,5731,5732,5733,5735,5736,6280,5737,5739,5740,5741,5742,5743,5744,5745,5746,5747,5749,5750,5752,5753,5754,5755,5756,5757,5758,5759,5760,5761,5762,5763,5769,5764,5765,5766,5767,5768,5771,5772,5773,5774,5775,5776,5777,5778,5779,5780,5781,5782,5783,5784,5785,5786,5787,5788,5789,5790,5791,5792,5796,5797,5798,5799,5800,5801,5802,5803,5804,5805,5806,5807,5808,5809,5810,5811,5812,5813,5814,5815,5816,6661,6203,5817,5818,5819,5823,5824,5825,5826,5828,5829,5830,5831,5832,5833,5834,5835,5836,5837,5838,5839,5840,5841,5842,5843,5844,5845,5846,5847,5848,5849,5850,5851,5852,5853,5854,5855,5856,5857,5858,5859,5860,5861,5862,5863,5864,5865,5866,5867,5868,5869,5870,5871,5872,5873,5874,5875,5876,5877,5878,5879,5880,5881,5882,5883,5884,5885,5886,5887,5888,5889,5891,5892,5893,6444,5894,5895,5896,5897,5898,5899,5900,5901,5902,5904,5906,5908,5909,5910,5911,5912,5913,5914,5915,5916,5917,5918,5919,5920,5921,5922,5923,5924,5925,5926,5927,5928,5929,5930,5931,5932,5933,5934,5935,5936,5937,5938,5939,5940,5941,5942,5943,5944,5945,5946,5947,5948,5949,5950,5951,5954,5955,5956,5957,5958,5959,5953,5960,5961,5962,5963,5964,5965,5966,5967,5968,5969,5970,5971,5972,5974,5975,5976,5977,5978,5979,5980,5981,5982,5984,5985,5986,5987,5988,5990,5992,5993,5994,5995,5996,5997,5998,5999,6000,6001,6002,6003,6004,6005,6006,6007,6008,6009,6010,6011,6012,6013,6014,6015,6030,6016,6017,6018,6019,6020,6021,6022,6023,6024,6025,6026,6027,6028,6033,6034,6035,6036,6037,6038,6031,6032,6039,6040,6041,6042,6043,6044,6046,6047,6048,6049,6050,6051,6052,6053,6054,6056,6057,6058,6059,6060,6061,6062,6063,6064,6065,6066,6067,6068,6069,6070,6072,6074,6075,6076,6077,6078,6079,6080,6081,6082,6083,6084,6085,6087,6086,6088,6089,6090,6091,6094,6095,6096,6097,6098,6099,6100,6101,6103,6104,6105,6106,6107,6108,6109,6110,6111,6112,6114,6115,6116,6117,6118,6119,6120,6121,6122,6123,6124,6125,6126,6127,6128,6129,6130,6131,6132,6133,6134,6135,6137,6138,6139,6140,6141,6142,6143,6144,6145,6153,6150,6151,6146,6147,6148,6149,6152,6172,6156,6158,6159,6161,6162,6163,6164,6165,6166,6167,6168,6169,6170,6171,6173,6174,6175,6176,6177,6178,6179,6180,6181,6182,6183,6184,6185,6186,6189,6190,6191,6192,6194,6304,6195,6196,6197,6198,6199,6200,6201,6202,6206,6208,6209,6210,6211,6212,6213,6214,6215,6216,6217,6218,6219,6220,6221,6222,6223,6224,6225,6227,6228,6233,6234,6235,6236,6237,6238,6239,6240,6241,6242,6243,6244,6245,6246,6247,6256,6248,6249,6251,6252,6253,6254,6255,6257,6258,6259,6260,6261,6262,6263,6265,6266,6267,6268,6269,6270,6271,6272,6273,6275,6276,6277,6278,6279,6427,6281,6282,6284,6285,6286,6287,6289,6290,6291,6292,6293,6294,6295,6296,6299,6300,6301,6302,6303,6305,6306,6308,6309,6310,6312,6314,6315,6316,6317,6318,6319,6320,6321,6322,6323,6324,6325,6824,6326,6327,6328,6329,6330,6331,6332,6333,6334,6335,6336,6337,6338,6340,6341,6342,6343,6344,6345,6346,6347,6348,6349,6350,6351,6353,6354,6355,6356,6357,6358,6359,6360,6361,6362,6364,6366,6367,6368,6369,6370,6371,6372,6373,6374,6375,6376,6378,6379,6380,6381,6382,6383,6384,6385,6386,6387,6388,6389,6390,6392,6394,6395,6396,6397,6398,6399,6400,6401,6402,6403,6405,6406,6407,6408,6409,6410,6411,6412,6413,6415,6416,6417,6419,6420,6422,6423,6424,6425,6426,6428,6429,6430,6431,6432,6433,6434,6435,6436,6437,6439,6440,6441,6442,6443,6446,6448,6449,6450,6451,6452,6453,6454,6455,6456,6457,6458,6459,6461,6462,6464,6465,6466,6467,6468,6469,6470,6471,6473,6474,6475,6476,6477,6478,6479,6480,6481,6482,6483,6484,6485,6486,6487,6489,6490,6491,6492,6495,6496,6498,6499,6500,6501,6504,6505,6506,6507,6508,6509,6510,6511,6512,6513,6514,6515,6517,6518,6519,6520,6521,6522,6523,6524,6525,6526,6527,6528,6529,6531,6532,6533,6534,6535,6536,6537,6538,6539,6540,6542,6543,6544,6545,6546,6547,6548,6549,6550,6552,6553,6554,6555,6556,6557,6558,6559,6560,6562,6563,6564,6565,6566,6573,6567,6569,6570,6571,6574,6575,6576,6577,6578,6580,6581,6582,6583,6585,6586,6587,6588,6589,6591,6593,6594,6595,6596,6597,6599,6600,6601,6602,6604,6605,6606,6676,6607,6608,6609,6610,6613,6612,6614,6615,6616,6617,6618,6619,6620,6621,6622,6624,6627,6628,6629,6630,6631,6632,6633,6634,6635,6636,6637,6638,6639,6640,6641,6642,6643,6644,6645,6646,6680,6648,6649,6651,6652,6653,6654,6655,6656,6657,6658,6659,6660,6664,6665,6666,6667,6668,6669,6670,6671,6672,6673,6674,6675,6677,6678,6679,6681,6695,6683,6684,6685,6687,6688,6689,6690,6691,6692,6693,6696,6697,6698,6699,6700,6701,6702,6703,6705,6706,6707,6708,6709,6710,6711,6712,6713,6714,6716,6717,6718,6719,6720,6721,6722,6723,6724,6725,6726,6727,6729,6730,6731,6732,6733,6734,6735,6736,6737,6738,6739,6740,6741,6742,6743,6744,6745,6747,6748,6749,6750,6751,6752,6753,6754,6755,6756,6757,6758,6759,6760,6761,6762,6763,6764,6765,6766,6767,6768,6769,6770,6804,6771,6773,6774,6775,6776,6777,6778,6779,6780,6781,6782,6783,6784,6785,6786,6787,6788,6789,6791,6792,6793,6794,6795,6796,6797,6798,6799,6800,6802,6803,6806,6807,6808,6809,6810,6812,6813,6814,6815,6816,6817,6818,6819,6820,6821,6822,6823,6825,6826,6827,6828,6829,6830,6831,6832,6833,6834,6835,6836,6837,6838,6839,6857,6841,6843,6845,6846,6847,6848,6849,6850,6851,6852,6853,6854,6855,6856,6858,6859,6860,6861,6862,6863,6864,6865,6866,6867,6868,6869,6870,6871,6872,6873,6874,6875,6876,6877,6878,6879,6880,6882,6883,6884,6885,6886,6887,6888,6891,6890,6892,6893,6894,6895,6896,6897,6898,6899,6900,6901,6902,6903,6904,6905,6906,6907,6908,6909,6910,6911,6912,6913,6914,6915,6916,6917,6918,6919,6921,6922,6923,6924,6925,6926,6927,6928,6929,6930,6931,6932,6933,6934,6935,6936,6937,6939,6941,6942,6943,6944,6945,6946,6948,6951,6952,6953,6954,6955,6966,6956,6957,6958,6959,6960,6961,6962,6963,6964,6965,6967,6968,6970,6972,6975,6977,6979,6980,6981,6983,6984,6993,6995,6997,6999,7000,7001,7002,7004,7005,7006,7007,7008,7009,7010,7011,7012,7013,7014,7015,7016,7017,7018,7019,7020,7021,7022,7023,7024,7025,7026,7027,7028,7029,7030,7031,7033,7034,7035,7037,7038,7039,7040,7041,7042,7043,7044,7045,7046,7048,7049,7050,7051,7052,7053,7054,7055,7056,7057,7058,7059,7060,7061,7062,7063,7064,7065,7070,7071,7072,7073,7075,7076,7078,7079,7080,7081,7082,7083,7084,7086,7088,7089,7090,7091,7092,7093,7094,7095,7096,7097,7098,7100,7101,7102,7104,7105,7106,7107,7109,7108,7110,7111,7112,7113,7114,7115,7116,7117,7119,7120,7122,7123,7126,7127,7129,7130,7132,7133,7134,7135,7136,7137,7150,7138,7139,7140,7141,7142,7143,7144,7145,7146,7147,7149,7152,7153,7154,7155,7156,7157,7158,7160,7161,7162,7163,7164,7166,7167,7168,7169,7170,7171,7172,7173,7174,7175,7176,7177,7178,7179,7180,7181,7182,7183,7184,7185,7186,7187,7188,7190,7191,7192,7193,7194,7195,7196,7197,7198,7199,7201,7202,7203,7205,7204,7207,7206,7208,7209,7210,7212,7213,7214,7215,7217,7218,7219,7220,7221,7222,7223,7224,7225,7226,7228,7229,7230,7231,7232,7233,7234,7235,7236,7237,7238,7239,7240,7241,7242,7243,7244,7245,7271,7268,7247,7248,7249,7250,7251,7252,7253,7254,7256,7257,7258,7259,7260,7261,7262,7263,7264,7265,7266,7267,7269,7272,7273,7275,7277,7278,7279,7280,7281,7282,7283,7284,7285,7287,7288,7289,7291,7292,7293,7294,7295,7296,7297,7298,7299,7300,7301,7302,7303,7304,7305,7306,7307,7308,7309,7310,7322,7313,7314,7315,7316,7317,7318,7319,7320,7321,7323,7324,7325,7326,7327,7328,7329,7330,7331,7332,7333,7334,7335,7336,7337,7339,7341,7342,7343,7344,7345,7358,7346,7347,7349,7350,7351,7352,7353,7354,7355,7357,7356,7359,7360,7361,7362,7363,7364,7365,7366,7367,7368,7369,7370,7372,7374,7375,7379,7380,7381,7382,7383,7384,7385,7386,7388,7391,7393,7394,7395,7396,7397,7398,7399,7595,7457,7401,7402,7403,7404,7406,7407,7408,7409,7410,7411,7412,7423,7413,7493,7415,7416,7417,7418,7419,7420,7421,7431,7422,7424,7425,7426,7427,7428,7429,7430,7456,7432,7433,7434,7435,7436,7438,7439,7440,7441,7442,7443,7445,7446,7447,7448,7449,7450,7452,7454,7455,7458,7459,7460,7461,7462,7463,7464,7465,7466,7467,7468,7469,7470,7471,7472,7473,7474,7475,7476,7477,7478,7479,7489,7480,7481,7482,7483,7484,7485,7486,7487,7488,7490,7497,7491,7492,7494,7495,7496,7498,7499,7500,7502,7503,7505,7506,7507,7508,7509,7510,7511,7512,7513,7514,7515,7516,7517,7518,7519,7520,7521,7522,7524,7525,7526,7527,7528,7529,7530,7531,7532,7533,7534,7535,7536,7538,7537,7539,7540,7541,7542,7543,7544,7545,7546,7547,7548,7549,7550,7551,7553,7555,7556,7557,7558,7559,7560,7561,7562,7563,7564,7565,7567,7568,7570,7571,7572,7574,7575,7576,7577,7578,7579,7580,7581,7582,7594,7585,7587,7589,7591,7592,7593,7597,7598,7600,7602,7603,7605,7606,7607,7608,7610,7611,7612,7613,7614,7615,7633,7616,7617,7618,7619,7620,7621,7622,7624,7625,7628,7629,7630,7632,7634,7636,7639,7640,7643,7649,7652,7653,7654,7656,7657,7658,7659,7661,7662,7663,7664,7665,7666,7667,7668,7669,7671,7673,7679,8022,7680,7681,7682,7683,7684,7685,7686,7687,7688,7689,7690,7691,7693,7694,7697,7698,7699,7700,7701,7702,7703,7704,7705,7706,7707,7708,7710,7719,7711,7712,7713,7714,7715,7716,7717,7718,7720,7721,7722,7723,7725,7726,7724,7728,7729,7730,7731,7732,7733,7734,7735,7736,7737,7738,7739,7740,7742,7743,7744,7745,7746,7747,7748,7749,7751,7752,7753,7754,7755,7756,7757,7758,7760,7761,7763,7764,7765,7766,7767,7768,7769,7771,7772,7773,7775,7777,7778,7779,7780,7781,7782,7784,7786,7787,7792,7788,7789,7790,7791,7793,7794,7795,7796,7799,7800,7801,7803,7804,7805,7806,7807,7808,7809,7810,7811,7812,7813,7814,7815,7816,7817,7818,7819,7820,7821,7823,7824,7825,7826,7828,7829,7830,7831,7832,7833,7834,7835,7836,7837,7838,7839,7840,7841,7842,7843,7844,7845,7847,7853,7849,7850,7851,7852,7854,7855,7857,7858,7859,7860,7861,7862,7863,7864,7865,7866,7867,7868,7869,7870,7871,7872,7873,7874,7875,7876,7877,7878,7879,7880,7881,7882,7883,7884,7885,7886,7887,7888,7889,7890,7891,7894,7896,7897,7898,7899,7901,7902,7903,7904,7905,7906,7907,7908,7909,7910,7912,7913,7914,7915,7917,7918,7919,7920,7921,7922,7923,7924,7925,7926,7927,7929,7930,7931,7932,7981,7934,7935,7936,7937,7938,7939,7940,7941,7943,7944,7945,7946,7947,7949,7951,7953,7954,7955,7956,7957,7958,7960,7961,7962,7963,7964,7965,7966,7967,7968,7969,7970,7971,7972,7973,7974,7976,7977,7979,7978,7980,7982,7983,7984,7985,7986,7987,7988,7989,7990,7991,7992,7993,7994,7995,8126,8010,7999,8000,8001,8002,8003,8004,8005,8008,8009,8011,8012,8013,8014,8015,8016,8017,8018,8019,8020,8021,8023,8024,8025,8027,8026,8028,8029,8030,8031,8032,8033,8034,8035,8036,8037,8038,8039,8041,8042,8043,8044,8045,8046,8047,8048,8049,8050,8051,8052,8053,8054,8055,8056,8057,8058,8059,8060,8061,8062,8063,8064,8065,8066,8067,8068,8069,8070,8071,8072,8073,8074,8075,8076,8078,8079,8081,8082,8083,8084,8085,8086,8089,8088,8091,8092,8093,8096,8097,8098,8099,8100,8101,8102,8103,8104,8105,8106,8107,8108,8109,8110,8111,8112,8113,8114,8115,8116,8117,8118,8119,8120,8121,8123,8124,8125,8127,8134,8137,8142,8143,8144)
AND tag.published = 1
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | xref | NULL | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 1564 | 50.00 | Using where |
| 1 | SIMPLE | tag | NULL | eq_ref | PRIMARY | PRIMARY | 4 | gator_joomla3.xref.tagID | 1 | 10.00 | Using where |
| Status | Duration |
|---|---|
| starting | 2.5 ms |
| checking permissions | 0.0 ms |
| checking permissions | 0.0 ms |
| Opening tables | 0.0 ms |
| init | 1.1 ms |
| System lock | 0.0 ms |
| optimizing | 0.3 ms |
| statistics | 0.5 ms |
| preparing | 0.4 ms |
| executing | 0.0 ms |
| Sending data | 2.8 ms |
| end | 0.0 ms |
| query end | 0.0 ms |
| closing tables | 0.0 ms |
| freeing items | 0.1 ms |
| cleaning up | 0.0 ms |
select `blacklist`
from j3_ad_agency_settings
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | j3_ad_agency_settings | NULL | system | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 1 | 100.00 | NULL |
| Status | Duration |
|---|---|
| starting | 0.1 ms |
| checking permissions | 0.0 ms |
| Opening tables | 0.0 ms |
| init | 0.0 ms |
| System lock | 0.0 ms |
| optimizing | 0.0 ms |
| statistics | 0.0 ms |
| preparing | 0.0 ms |
| executing | 0.0 ms |
| Sending data | 0.0 ms |
| end | 0.0 ms |
| query end | 0.0 ms |
| closing tables | 0.0 ms |
| freeing items | 0.0 ms |
| cleaning up | 0.0 ms |
select `blacklist`
from j3_ad_agency_settings
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | j3_ad_agency_settings | NULL | system | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 1 | 100.00 | NULL |
| Status | Duration |
|---|---|
| starting | 0.0 ms |
| checking permissions | 0.0 ms |
| Opening tables | 0.0 ms |
| init | 0.0 ms |
| System lock | 0.0 ms |
| optimizing | 0.0 ms |
| statistics | 0.0 ms |
| preparing | 0.0 ms |
| executing | 0.0 ms |
| Sending data | 0.0 ms |
| end | 0.0 ms |
| query end | 0.0 ms |
| closing tables | 0.0 ms |
| freeing items | 0.0 ms |
| cleaning up | 0.0 ms |
select `params`
from j3_ad_agency_settings
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | j3_ad_agency_settings | NULL | system | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 1 | 100.00 | NULL |
| Status | Duration |
|---|---|
| starting | 0.0 ms |
| checking permissions | 0.0 ms |
| Opening tables | 0.0 ms |
| init | 0.0 ms |
| System lock | 0.0 ms |
| optimizing | 0.0 ms |
| statistics | 0.0 ms |
| preparing | 0.0 ms |
| executing | 0.0 ms |
| Sending data | 0.0 ms |
| end | 0.0 ms |
| query end | 0.0 ms |
| closing tables | 0.0 ms |
| freeing items | 0.0 ms |
| cleaning up | 0.0 ms |
SELECT *
FROM j3_ad_agency_settings
LIMIT 1
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | j3_ad_agency_settings | NULL | system | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 1 | 100.00 | NULL |
| Status | Duration |
|---|---|
| starting | 0.0 ms |
| checking permissions | 0.0 ms |
| Opening tables | 0.0 ms |
| init | 0.0 ms |
| System lock | 0.0 ms |
| optimizing | 0.0 ms |
| statistics | 0.0 ms |
| preparing | 0.0 ms |
| executing | 0.0 ms |
| Sending data | 0.0 ms |
| end | 0.0 ms |
| query end | 0.0 ms |
| closing tables | 0.0 ms |
| freeing items | 0.0 ms |
| cleaning up | 0.0 ms |
SELECT *
FROM j3_ad_agency_zone
WHERE zoneid=149
LIMIT 1
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | j3_ad_agency_zone | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
| Status | Duration |
|---|---|
| starting | 0.0 ms |
| checking permissions | 0.0 ms |
| Opening tables | 0.0 ms |
| init | 0.0 ms |
| System lock | 0.0 ms |
| optimizing | 0.0 ms |
| statistics | 0.0 ms |
| preparing | 0.0 ms |
| executing | 0.0 ms |
| Sending data | 0.0 ms |
| end | 0.0 ms |
| query end | 0.0 ms |
| closing tables | 0.0 ms |
| freeing items | 0.0 ms |
| cleaning up | 0.0 ms |
select `approved`
from j3_ad_agency_banners
where `id`=0
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | NULL | NULL | NULL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | NULL | NULL | no matching row in const table |
| Status | Duration |
|---|---|
| starting | 0.0 ms |
| checking permissions | 0.0 ms |
| Opening tables | 0.0 ms |
| init | 0.0 ms |
| System lock | 0.0 ms |
| optimizing | 0.0 ms |
| statistics | 0.0 ms |
| executing | 0.0 ms |
| end | 0.0 ms |
| query end | 0.0 ms |
| closing tables | 0.0 ms |
| freeing items | 0.0 ms |
| cleaning up | 0.0 ms |
select `approved`
from j3_ad_agency_banners
where `id`=0
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | NULL | NULL | NULL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | NULL | NULL | no matching row in const table |
| Status | Duration |
|---|---|
| starting | 0.0 ms |
| checking permissions | 0.0 ms |
| Opening tables | 0.0 ms |
| init | 0.0 ms |
| System lock | 0.0 ms |
| optimizing | 0.0 ms |
| statistics | 0.0 ms |
| executing | 0.0 ms |
| end | 0.0 ms |
| query end | 0.0 ms |
| closing tables | 0.0 ms |
| freeing items | 0.0 ms |
| cleaning up | 0.0 ms |
SELECT *
FROM j3_ad_agency_zone
WHERE zoneid=149
LIMIT 1
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | j3_ad_agency_zone | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
| Status | Duration |
|---|---|
| starting | 0.0 ms |
| checking permissions | 0.0 ms |
| Opening tables | 0.0 ms |
| init | 0.0 ms |
| System lock | 0.0 ms |
| optimizing | 0.0 ms |
| statistics | 0.0 ms |
| preparing | 0.0 ms |
| executing | 0.0 ms |
| Sending data | 0.0 ms |
| end | 0.0 ms |
| query end | 0.0 ms |
| closing tables | 0.0 ms |
| freeing items | 0.0 ms |
| cleaning up | 0.0 ms |
select `blacklist`
from j3_ad_agency_settings
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | j3_ad_agency_settings | NULL | system | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 1 | 100.00 | NULL |
| Status | Duration |
|---|---|
| starting | 0.0 ms |
| checking permissions | 0.0 ms |
| Opening tables | 0.1 ms |
| init | 0.0 ms |
| System lock | 0.0 ms |
| optimizing | 0.0 ms |
| statistics | 0.0 ms |
| preparing | 0.0 ms |
| executing | 0.0 ms |
| Sending data | 0.0 ms |
| end | 0.0 ms |
| query end | 0.0 ms |
| closing tables | 0.0 ms |
| freeing items | 0.0 ms |
| cleaning up | 0.0 ms |
select `blacklist`
from j3_ad_agency_settings
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | j3_ad_agency_settings | NULL | system | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 1 | 100.00 | NULL |
| Status | Duration |
|---|---|
| starting | 0.0 ms |
| checking permissions | 0.0 ms |
| Opening tables | 0.0 ms |
| init | 0.0 ms |
| System lock | 0.0 ms |
| optimizing | 0.0 ms |
| statistics | 0.0 ms |
| preparing | 0.0 ms |
| executing | 0.0 ms |
| Sending data | 0.0 ms |
| end | 0.0 ms |
| query end | 0.0 ms |
| closing tables | 0.0 ms |
| freeing items | 0.0 ms |
| cleaning up | 0.0 ms |
select `params`
from j3_ad_agency_settings
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | j3_ad_agency_settings | NULL | system | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 1 | 100.00 | NULL |
| Status | Duration |
|---|---|
| starting | 0.0 ms |
| checking permissions | 0.0 ms |
| Opening tables | 0.0 ms |
| init | 0.0 ms |
| System lock | 0.0 ms |
| optimizing | 0.0 ms |
| statistics | 0.0 ms |
| preparing | 0.0 ms |
| executing | 0.0 ms |
| Sending data | 0.0 ms |
| end | 0.0 ms |
| query end | 0.0 ms |
| closing tables | 0.0 ms |
| freeing items | 0.0 ms |
| cleaning up | 0.0 ms |
SELECT *
FROM j3_ad_agency_settings
LIMIT 1
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | j3_ad_agency_settings | NULL | system | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 1 | 100.00 | NULL |
| Status | Duration |
|---|---|
| starting | 0.0 ms |
| checking permissions | 0.0 ms |
| Opening tables | 0.0 ms |
| init | 0.0 ms |
| System lock | 0.0 ms |
| optimizing | 0.0 ms |
| statistics | 0.0 ms |
| preparing | 0.0 ms |
| executing | 0.0 ms |
| Sending data | 0.0 ms |
| end | 0.0 ms |
| query end | 0.0 ms |
| closing tables | 0.0 ms |
| freeing items | 0.0 ms |
| cleaning up | 0.0 ms |
SELECT *
FROM j3_ad_agency_zone
WHERE zoneid=74
LIMIT 1
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | j3_ad_agency_zone | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
| Status | Duration |
|---|---|
| starting | 0.0 ms |
| checking permissions | 0.0 ms |
| Opening tables | 0.0 ms |
| init | 0.0 ms |
| System lock | 0.0 ms |
| optimizing | 0.0 ms |
| statistics | 0.0 ms |
| preparing | 0.0 ms |
| executing | 0.0 ms |
| Sending data | 0.0 ms |
| end | 0.0 ms |
| query end | 0.0 ms |
| closing tables | 0.0 ms |
| freeing items | 0.0 ms |
| cleaning up | 0.0 ms |
select `approved`
from j3_ad_agency_banners
where `id`=0
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | NULL | NULL | NULL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | NULL | NULL | no matching row in const table |
| Status | Duration |
|---|---|
| starting | 0.0 ms |
| checking permissions | 0.0 ms |
| Opening tables | 0.0 ms |
| init | 0.0 ms |
| System lock | 0.0 ms |
| optimizing | 0.0 ms |
| statistics | 0.0 ms |
| executing | 0.0 ms |
| end | 0.0 ms |
| query end | 0.0 ms |
| closing tables | 0.0 ms |
| freeing items | 0.0 ms |
| cleaning up | 0.0 ms |
select `approved`
from j3_ad_agency_banners
where `id`=0
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | NULL | NULL | NULL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | NULL | NULL | no matching row in const table |
| Status | Duration |
|---|---|
| starting | 0.0 ms |
| checking permissions | 0.0 ms |
| Opening tables | 0.0 ms |
| init | 0.0 ms |
| System lock | 0.0 ms |
| optimizing | 0.0 ms |
| statistics | 0.0 ms |
| executing | 0.0 ms |
| end | 0.0 ms |
| query end | 0.0 ms |
| closing tables | 0.0 ms |
| freeing items | 0.0 ms |
| cleaning up | 0.0 ms |
SELECT *
FROM j3_ad_agency_zone
WHERE zoneid=74
LIMIT 1
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | j3_ad_agency_zone | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
| Status | Duration |
|---|---|
| starting | 0.0 ms |
| checking permissions | 0.0 ms |
| Opening tables | 0.0 ms |
| init | 0.0 ms |
| System lock | 0.0 ms |
| optimizing | 0.0 ms |
| statistics | 0.0 ms |
| preparing | 0.0 ms |
| executing | 0.0 ms |
| Sending data | 0.0 ms |
| end | 0.0 ms |
| query end | 0.0 ms |
| closing tables | 0.0 ms |
| freeing items | 0.0 ms |
| cleaning up | 0.0 ms |
SELECT c.*, i.catid, i.title, i.alias, category.alias as catalias, category.name as categoryname
FROM j3_k2_comments as c
LEFT JOIN j3_k2_items as i
ON i.id=c.itemID
LEFT JOIN j3_k2_categories as category
ON category.id=i.catid
WHERE i.published=1
AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2021-01-19 19:07:29' )
AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2021-01-19 19:07:29' )
AND i.trash=0
AND i.access IN(1,1)
AND category.published=1
AND category.trash=0
AND category.access IN(1,1)
AND c.published=1
ORDER BY c.commentDate DESC
LIMIT 0, 8
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | c | NULL | ALL | itemId | NO INDEX KEY COULD BE USED | NULL | NULL | 1581 | 10.00 | Using where; Using filesort |
| 1 | SIMPLE | i | NULL | eq_ref | PRIMARY,id | PRIMARY | 4 | gator_joomla3.c.itemID | 1 | 5.00 | Using where |
| 1 | SIMPLE | category | NULL | eq_ref | PRIMARY,id | PRIMARY | 4 | gator_joomla3.i.catid | 1 | 5.00 | Using index condition; Using where |
| Status | Duration |
|---|---|
| starting | 0.1 ms |
| checking permissions | 0.0 ms |
| checking permissions | 0.0 ms |
| checking permissions | 0.0 ms |
| Opening tables | 0.0 ms |
| init | 0.1 ms |
| System lock | 0.0 ms |
| optimizing | 0.0 ms |
| statistics | 0.1 ms |
| preparing | 0.0 ms |
| Sorting result | 0.0 ms |
| executing | 0.0 ms |
| Sending data | 0.0 ms |
| Creating sort index | 0.9 ms |
| end | 0.0 ms |
| query end | 0.0 ms |
| closing tables | 0.0 ms |
| freeing items | 0.0 ms |
| cleaning up | 0.0 ms |
SELECT id, name, parent
FROM j3_k2_categories
WHERE published=1
AND trash=0
AND access IN(1,1)
ORDER BY parent
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | j3_k2_categories | NULL | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 46 | 2.17 | Using where; Using filesort |
| Status | Duration |
|---|---|
| starting | 0.0 ms |
| checking permissions | 0.0 ms |
| Opening tables | 0.0 ms |
| init | 0.0 ms |
| System lock | 0.0 ms |
| optimizing | 0.0 ms |
| statistics | 0.0 ms |
| preparing | 0.0 ms |
| Sorting result | 0.0 ms |
| executing | 0.0 ms |
| Sending data | 0.0 ms |
| Creating sort index | 0.1 ms |
| end | 0.0 ms |
| query end | 0.0 ms |
| closing tables | 0.0 ms |
| freeing items | 0.0 ms |
| cleaning up | 0.0 ms |
SELECT DISTINCT c.id AS ID, c.name AS name, c.alias AS alias
FROM j3_k2_categories AS c
LEFT JOIN j3_k2_items AS content
ON c.id = content.catid
WHERE ( c.id = 68 )
AND c.published = 1
AND c.access <= 1;
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | c | NULL | const | PRIMARY,id | PRIMARY | 4 | const | 1 | 100.00 | Using temporary |
| 1 | SIMPLE | content | NULL | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 7550 | 100.00 | Using where; Distinct |
| Status | Duration |
|---|---|
| starting | 0.1 ms |
| checking permissions | 0.0 ms |
| checking permissions | 0.0 ms |
| Opening tables | 0.0 ms |
| init | 0.0 ms |
| System lock | 0.0 ms |
| optimizing | 0.0 ms |
| statistics | 0.1 ms |
| preparing | 0.0 ms |
| Creating tmp table | 0.0 ms |
| executing | 0.0 ms |
| Sending data | 13.3 ms |
| Removing duplicates | 0.0 ms |
| end | 0.0 ms |
| query end | 0.0 ms |
| removing tmp table | 0.0 ms |
| query end | 0.0 ms |
| closing tables | 0.0 ms |
| freeing items | 0.0 ms |
| cleaning up | 0.0 ms |
SELECT content.id AS IID, content.catid AS cat_id, content.title AS title, content.introtext AS text, content.created AS date, content.publish_up AS date_publish, content.alias AS alias, content.hits AS hits, content.plugins AS plugins
FROM j3_k2_items AS content
WHERE content.trash = 0
AND content.access <= 1
AND content.published = 1
AND ( content.publish_up = '0000-00-00 00:00:00' OR content.publish_up <= '2021-01-19 00:00:00' )
AND ( content.publish_down = '0000-00-00 00:00:00' OR content.publish_down >= '2021-01-19 00:00:00' )
AND ( content.catid = 68 )
ORDER BY content.created DESC
LIMIT 0,20;
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | content | NULL | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 7550 | 0.01 | Using where; Using filesort |
| Status | Duration |
|---|---|
| starting | 0.1 ms |
| checking permissions | 0.0 ms |
| Opening tables | 0.0 ms |
| init | 0.0 ms |
| System lock | 0.0 ms |
| optimizing | 0.0 ms |
| statistics | 0.0 ms |
| preparing | 0.0 ms |
| Sorting result | 0.0 ms |
| executing | 0.0 ms |
| Sending data | 0.0 ms |
| Creating sort index | 13.3 ms |
| end | 0.0 ms |
| query end | 0.0 ms |
| closing tables | 0.0 ms |
| freeing items | 0.0 ms |
| cleaning up | 0.0 ms |
SELECT content.id AS ID, cats.name AS cat_name, cats.alias AS cat_alias, content.catid AS cat_id, users.name AS author, users.email AS author_email, users.id AS author_id, content_rating.rating_sum AS rating_sum, content_rating.rating_count AS rating_count
FROM j3_k2_items AS content
LEFT JOIN j3_k2_categories AS cats
ON cats.id = content.catid
LEFT JOIN j3_users AS users
ON users.id = content.created_by
LEFT JOIN j3_k2_rating AS content_rating
ON content.id = content_rating.itemID
WHERE content.id = 2869 OR content.id = 639 OR content.id = 448 OR content.id = 5656 OR content.id = 2894 OR content.id = 7267 OR content.id = 3380 OR content.id = 4246 OR content.id = 6711 OR content.id = 4311 OR content.id = 945 OR content.id = 4204 OR content.id = 7154 OR content.id = 1443 OR content.id = 1833 OR content.id = 4089 OR content.id = 1715 OR content.id = 2867 OR content.id = 4752 OR content.id = 3811
ORDER BY content.created DESC
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | content | NULL | range | PRIMARY,id | PRIMARY | 4 | NULL | 20 | 100.00 | Using index condition; Using filesort |
| 1 | SIMPLE | cats | NULL | eq_ref | PRIMARY,id | PRIMARY | 4 | gator_joomla3.content.catid | 1 | 100.00 | Using where |
| 1 | SIMPLE | users | NULL | eq_ref | PRIMARY | PRIMARY | 4 | gator_joomla3.content.created_by | 1 | 100.00 | NULL |
| 1 | SIMPLE | content_rating | NULL | eq_ref | PRIMARY | PRIMARY | 4 | gator_joomla3.content.id | 1 | 100.00 | NULL |
| Status | Duration |
|---|---|
| starting | 0.1 ms |
| checking permissions | 0.0 ms |
| checking permissions | 0.0 ms |
| checking permissions | 0.0 ms |
| checking permissions | 0.0 ms |
| Opening tables | 0.0 ms |
| init | 0.1 ms |
| System lock | 0.0 ms |
| optimizing | 0.0 ms |
| statistics | 0.1 ms |
| preparing | 0.0 ms |
| Sorting result | 0.0 ms |
| executing | 0.0 ms |
| Sending data | 0.0 ms |
| Creating sort index | 0.5 ms |
| end | 0.0 ms |
| query end | 0.0 ms |
| closing tables | 0.0 ms |
| freeing items | 0.0 ms |
| cleaning up | 0.0 ms |