Vehicle Finance, Cheap Car Loans, Cando Car Finance

Auto finance experienced loan brokers

Looking for cheap car finance for yourself or a friend is made easy with Cando Financial. Our experienced team of finance brokers will help you with any questions you may have and also ask you questions that will confirm your borrowing capacity. We offer free, no obligation quotes over the phone or you can fill out an online application form provided on our website. We will find the most suitable lender for you with easy repayments and terms to suit your pocket. Contact our car lending specialists today to get you on your way.

How to get the cheapest Car Loans

Most clients looking for the best car loan call one bank after another. This is a good starting point when searching for a new car loan. Once you have searched a few banks and other non-bank vehicle lenders you should call Cando loans. Providing the best Car Loans at very affordable interest rates is a challenge. Not only do we love a challenge but with over 20 banks available to our car finance manager we are good at what we do. The cheapest interest rate is not always the best for you, considerations such as tax incentives, early payout fees and other hidden cost means you have to be careful which lender is best suited to your needs. Approvals take about 20 minutes with vehicle loans so Cando loans will have you in your new car tomorrow if you want. Remember a Cando car loan manager is available 7 days a week and we always answer our phones.

Buying a Car with low or no deposit

If you are trading a car and buying another new car from a dealer then you can use this as your deposit. Private cars sales, or buying a vehicle from a private seller does not require a deposit. Most people expect to pay a small deposit and this is OK as well. Private seller will normally require a little cash just to prove you are serious and take the vehicle off the market. But as a general rule financial institutions or banks do not require a deposit. However in some case your CanDo manager will advise you a small deposit would be better, this sometimes allows us to request a better interest rate from the banks.

Private sales or Auctions

The choice is your! Once we have a full car loan approval you are free to shop wherever and whenever you like. Approvals last for up to 90 days, so there is no rush to buy the first car you come across. Private seller always like to grab a small deposit just to prove they can take the car off the website they have advertised on. Auctions are very similar they generally take your credit card details when you register. Full finance is still available with either option. The seller will refund the deposit once full payment has been made. Auction also require payment to be made quiet quickly so a full approval should be obtained before the Auction not after. This will make sure the loan amount you are approved for cover your bid!

Joomla! Debug Console

Time

Memory

Time: 0.0 ms / 0.0 ms Memory: 0.800 MB / 0.80 MB Application: afterLoad

Time: 46.7 ms / 46.7 ms Memory: 1.323 MB / 2.12 MB Application: afterInitialise

Time: 34.7 ms / 81.5 ms Memory: 0.534 MB / 2.66 MB Application: afterRoute

Time: 80.3 ms / 161.8 ms Memory: 0.985 MB / 3.64 MB Application: afterDispatch

Time: 7.9 ms / 169.7 ms Memory: 0.158 MB / 3.80 MB Application: beforeRenderModule mod_custom (Outgoing Links)

Time: 1.9 ms / 171.6 ms Memory: 0.011 MB / 3.81 MB Application: afterRenderModule mod_custom (Outgoing Links)

Time: 4.8 ms / 176.5 ms Memory: 0.018 MB / 3.83 MB Application: beforeRenderModule mod_articles_news (Latest Blogs)

Time: 5.3 ms / 181.7 ms Memory: 0.099 MB / 3.93 MB Application: afterRenderModule mod_articles_news (Latest Blogs)

Time: 5.1 ms / 186.9 ms Memory: 0.000 MB / 3.92 MB Application: beforeRenderModule mod_custom (Footer)

Time: 0.8 ms / 187.6 ms Memory: 0.008 MB / 3.92 MB Application: afterRenderModule mod_custom (Footer)

Time: 2.0 ms / 189.6 ms Memory: 0.000 MB / 3.92 MB Application: beforeRenderModule mod_custom (Banner)

Time: 0.8 ms / 190.4 ms Memory: 0.007 MB / 3.93 MB Application: afterRenderModule mod_custom (Banner)

Time: 2.0 ms / 192.4 ms Memory: 0.003 MB / 3.93 MB Application: beforeRenderModule mod_menu (Main Menu)

Time: 7.6 ms / 200.0 ms Memory: 0.047 MB / 3.98 MB Application: afterRenderModule mod_menu (Main Menu)

Time: 4.9 ms / 205.0 ms Memory: 0.000 MB / 3.97 MB Application: beforeRenderModule mod_custom (Free Instant Loan Calculator)

Time: 0.8 ms / 205.8 ms Memory: 0.008 MB / 3.98 MB Application: afterRenderModule mod_custom (Free Instant Loan Calculator)

Time: 1.7 ms / 207.4 ms Memory: 0.006 MB / 3.98 MB Application: beforeRenderModule mod_custom (Apply Now button)

Time: 0.8 ms / 208.2 ms Memory: 0.008 MB / 3.99 MB Application: afterRenderModule mod_custom (Apply Now button)

Time: 1.7 ms / 209.8 ms Memory: 0.000 MB / 3.98 MB Application: beforeRenderModule mod_custom (Buttons)

Time: 0.7 ms / 210.6 ms Memory: 0.008 MB / 3.99 MB Application: afterRenderModule mod_custom (Buttons)

Time: 1.6 ms / 212.2 ms Memory: 0.000 MB / 3.99 MB Application: beforeRenderModule mod_custom (AFG Logo)

Time: 0.7 ms / 213.0 ms Memory: 0.008 MB / 4.00 MB Application: afterRenderModule mod_custom (AFG Logo)

Time: 1.7 ms / 214.7 ms Memory: 0.000 MB / 3.99 MB Application: beforeRenderModule mod_custom (Contact Us)

Time: 0.7 ms / 215.4 ms Memory: 0.007 MB / 4.00 MB Application: afterRenderModule mod_custom (Contact Us)

Time: 1.7 ms / 217.1 ms Memory: 0.000 MB / 4.00 MB Application: beforeRenderModule mod_custom (key words)

Time: 0.7 ms / 217.8 ms Memory: 0.007 MB / 4.00 MB Application: afterRenderModule mod_custom (key words)

Time: 11.1 ms / 228.9 ms Memory: 0.023 MB / 4.03 MB Application: afterRender

Database queries total: 50.5 ms

23 Queries Logged 50.5 ms

2 duplicate found!

2 duplicates: #9 #19

Query Time: 0.64 ms Query memory: 0.014 MB Memory before query: 1.314 MB Rows returned: 0
```
SELECT `data`

  FROM `joomla_session`

  WHERE `session_id` = 'ib0mvjophvmsurt4ah788nq2n5'
```
Explain
EXPLAIN not possible on query: SELECT `data` FROM `joomla_session` WHERE `session_id` = 'ib0mvjophvmsurt4ah788nq2n5'
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/joomla/session/storage/database.php:44
JROOT/libraries/joomla/session/session.php:665
JROOT/libraries/joomla/session/session.php:603
JROOT/libraries/cms/application/cms.php:739
JROOT/libraries/cms/application/cms.php:131
JROOT/libraries/cms/application/site.php:63
JROOT/libraries/cms/application/cms.php:399
JROOT/libraries/joomla/factory.php:125
JROOT/index.php:42
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.62 ms After last query: 2.26 ms Query memory: 0.011 MB Memory before query: 1.376 MB Rows returned: 0
```
SELECT `session_id`

  FROM `joomla_session`

  WHERE `session_id` = 'ib0mvjophvmsurt4ah788nq2n5' 
  LIMIT 0, 1
```
Explain
EXPLAIN not possible on query: SELECT `session_id` FROM `joomla_session` WHERE `session_id` = 'ib0mvjophvmsurt4ah788nq2n5' LIMIT 0, 1
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/cms/application/cms.php:176
JROOT/libraries/cms/application/cms.php:765
JROOT/libraries/cms/application/cms.php:131
JROOT/libraries/cms/application/site.php:63
JROOT/libraries/cms/application/cms.php:399
JROOT/libraries/joomla/factory.php:125
JROOT/index.php:42
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.59 ms After last query: 0.17 ms Query memory: 0.009 MB Memory before query: 1.388 MB
```
INSERT INTO `joomla_session`
(`session_id`, `client_id`, `time`) 
  VALUES 
('ib0mvjophvmsurt4ah788nq2n5', 0, '1542588046')
```
Explain
EXPLAIN not possible on query: INSERT INTO `joomla_session` (`session_id`, `client_id`, `time`) VALUES ('ib0mvjophvmsurt4ah788nq2n5', 0, '1542588046')
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/cms/application/cms.php:208
JROOT/libraries/cms/application/cms.php:765
JROOT/libraries/cms/application/cms.php:131
JROOT/libraries/cms/application/site.php:63
JROOT/libraries/cms/application/cms.php:399
JROOT/libraries/joomla/factory.php:125
JROOT/index.php:42
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 1.12 ms After last query: 4.09 ms Query memory: 0.013 MB Memory before query: 1.497 MB Rows returned: 36
```
SELECT extension_id AS id, element AS "option", params, enabled

  FROM joomla_extensions

  WHERE `type` = 'component'
```
Explain
EXPLAIN not possible on query: SELECT extension_id AS id, element AS "option", params, enabled FROM joomla_extensions WHERE `type` = 'component'
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/joomla/cache/controller/callback.php:157
JROOT/libraries/cms/component/helper.php:435
JROOT/libraries/cms/component/helper.php:43
JROOT/libraries/cms/component/helper.php:120
JROOT/libraries/cms/application/site.php:584
JROOT/libraries/cms/application/site.php:209
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:45
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.86 ms After last query: 1.42 ms Query memory: 0.013 MB Memory before query: 1.537 MB Rows returned: 2
```
SELECT b.id

  FROM joomla_usergroups AS a

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

  WHERE a.id = 9
```
Explain
EXPLAIN not possible on query: SELECT b.id FROM joomla_usergroups AS a LEFT JOIN joomla_usergroups AS b ON b.lft <= a.lft AND b.rgt >= a.rgt WHERE a.id = 9
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/joomla/access/access.php:332
JROOT/libraries/joomla/access/access.php:401
JROOT/libraries/joomla/user/user.php:453
JROOT/libraries/cms/plugin/helper.php:296
JROOT/libraries/cms/plugin/helper.php:163
JROOT/libraries/cms/application/site.php:589
JROOT/libraries/cms/application/site.php:209
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:45
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.62 ms After last query: 0.22 ms Query memory: 0.012 MB Memory before query: 1.557 MB Rows returned: 4
```
SELECT id, rules

  FROM `joomla_viewlevels`
```
Explain
EXPLAIN not possible on query: SELECT id, rules FROM `joomla_viewlevels`
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/joomla/access/access.php:418
JROOT/libraries/joomla/user/user.php:453
JROOT/libraries/cms/plugin/helper.php:296
JROOT/libraries/cms/plugin/helper.php:163
JROOT/libraries/cms/application/site.php:589
JROOT/libraries/cms/application/site.php:209
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:45
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 1.40 ms After last query: 1.98 ms Query memory: 0.010 MB Memory before query: 1.576 MB Rows returned: 48
```
SELECT folder AS type, element AS name, params

  FROM joomla_extensions

  WHERE enabled = 1 
  AND type ='plugin' 
  AND state IN (0,1) 
  AND access IN (1,1,5)

  ORDER BY ordering
```
Explain
EXPLAIN not possible on query: SELECT folder AS type, element AS name, params FROM joomla_extensions WHERE enabled = 1 AND type ='plugin' AND state IN (0,1) AND access IN (1,1,5) ORDER BY ordering
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/cms/plugin/helper.php:310
JROOT/libraries/cms/plugin/helper.php:163
JROOT/libraries/cms/application/site.php:589
JROOT/libraries/cms/application/site.php:209
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:45
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 1.42 ms After last query: 18.34 ms Query memory: 0.019 MB Memory before query: 2.186 MB Rows returned: 13
```
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 joomla_menu AS m

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

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

  ORDER BY m.lft
```
Explain
EXPLAIN not possible on query: 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 joomla_menu AS m LEFT JOIN joomla_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
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/cms/menu/site.php:45
JROOT/libraries/cms/menu/menu.php:64
JROOT/libraries/cms/menu/menu.php:118
JROOT/libraries/cms/application/cms.php:424
JROOT/libraries/cms/application/site.php:272
JROOT/libraries/cms/router/site.php:57
JROOT/libraries/cms/router/router.php:196
JROOT/libraries/cms/application/cms.php:520
JROOT/libraries/cms/application/site.php:407
JROOT/libraries/cms/application/cms.php:1088
JROOT/libraries/cms/application/site.php:763
JROOT/libraries/cms/application/site.php:215
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:45
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 4.50 ms After last query: 8.21 ms Query memory: 0.016 MB Memory before query: 2.471 MB Rows returned: 30
Duplicate queries: #19
```
SHOW FULL COLUMNS 
  FROM `joomla_content`
```
Explain
EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `joomla_content`
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/plugins/system/articlesanywhere/helper.php:57
JROOT/plugins/system/articlesanywhere/articlesanywhere.php:87
JROOT/libraries/joomla/event/event.php:69
JROOT/libraries/joomla/event/dispatcher.php:160
JROOT/libraries/joomla/application/base.php:106
JROOT/libraries/cms/application/cms.php:1098
JROOT/libraries/cms/application/site.php:763
JROOT/libraries/cms/application/site.php:215
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:45
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 6.16 ms After last query: 7.41 ms Query memory: 0.023 MB Memory before query: 2.546 MB Rows returned: 1
```
SELECT extension_id AS id, element AS "option", params, enabled

  FROM joomla_extensions

  WHERE `type` = 'library' 
  AND `element` = 'joomla'
```
Explain
EXPLAIN not possible on query: SELECT extension_id AS id, element AS "option", params, enabled FROM joomla_extensions WHERE `type` = 'library' AND `element` = 'joomla'
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/joomla/cache/controller/callback.php:157
JROOT/libraries/cms/library/helper.php:156
JROOT/libraries/cms/library/helper.php:47
JROOT/libraries/cms/library/helper.php:90
JROOT/libraries/cms/version/version.php:189
JROOT/libraries/joomla/factory.php:736
JROOT/libraries/joomla/factory.php:216
JROOT/plugins/system/sef/sef.php:29
JROOT/libraries/joomla/event/event.php:69
JROOT/libraries/joomla/event/dispatcher.php:160
JROOT/libraries/joomla/application/base.php:106
JROOT/libraries/cms/application/cms.php:1098
JROOT/libraries/cms/application/site.php:763
JROOT/libraries/cms/application/site.php:215
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:45
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 1.02 ms After last query: 1.50 ms Query memory: 0.018 MB Memory before query: 2.545 MB
```
UPDATE `joomla_extensions`

  SET `params` = '{\"mediaversion\":\"2a457f7f6743397ac79db7430e390a67\"}'

  WHERE `type` = 'library' 
  AND `element` = 'joomla'
```
Explain
EXPLAIN not possible on query: UPDATE `joomla_extensions` SET `params` = '{\"mediaversion\":\"2a457f7f6743397ac79db7430e390a67\"}' WHERE `type` = 'library' AND `element` = 'joomla'
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/cms/library/helper.php:119
JROOT/libraries/cms/version/version.php:240
JROOT/libraries/cms/version/version.php:199
JROOT/libraries/joomla/factory.php:736
JROOT/libraries/joomla/factory.php:216
JROOT/plugins/system/sef/sef.php:29
JROOT/libraries/joomla/event/event.php:69
JROOT/libraries/joomla/event/dispatcher.php:160
JROOT/libraries/joomla/application/base.php:106
JROOT/libraries/cms/application/cms.php:1098
JROOT/libraries/cms/application/site.php:763
JROOT/libraries/cms/application/site.php:215
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:45
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 1.60 ms After last query: 4.78 ms Query memory: 0.010 MB Memory before query: 2.682 MB Rows returned: 1
```
SELECT *

  FROM joomla_languages

  WHERE published=1

  ORDER BY ordering ASC
```
Explain
EXPLAIN not possible on query: SELECT * FROM joomla_languages WHERE published=1 ORDER BY ordering ASC
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/joomla/language/helper.php:164
JROOT/libraries/cms/application/site.php:329
JROOT/libraries/cms/application/site.php:135
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:45
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.97 ms After last query: 2.13 ms Query memory: 0.009 MB Memory before query: 2.703 MB Rows returned: 3
```
SELECT id, home, template, s.params

  FROM joomla_template_styles as s

  LEFT JOIN joomla_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
```
Explain
EXPLAIN not possible on query: SELECT id, home, template, s.params FROM joomla_template_styles as s LEFT JOIN joomla_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
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/cms/application/site.php:484
JROOT/libraries/cms/application/site.php:165
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:45
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.74 ms After last query: 9.77 ms Query memory: 0.024 MB Memory before query: 3.011 MB Rows returned: 1
```
SELECT a.rules

  FROM joomla_assets AS a

  WHERE (a.id = 1)

  GROUP BY a.id, a.rules, a.lft
```
Explain
EXPLAIN not possible on query: SELECT a.rules FROM joomla_assets AS a WHERE (a.id = 1) GROUP BY a.id, a.rules, a.lft
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/joomla/access/access.php:246
JROOT/libraries/joomla/user/user.php:384
JROOT/components/com_content/models/article.php:55
JROOT/libraries/legacy/model/legacy.php:439
JROOT/components/com_content/models/article.php:75
JROOT/libraries/legacy/view/legacy.php:401
JROOT/components/com_content/views/article/view.html.php:42
JROOT/libraries/joomla/cache/controller/view.php:96
JROOT/libraries/legacy/controller/legacy.php:686
JROOT/components/com_content/controller.php:104
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_content/content.php:38
JROOT/libraries/cms/component/helper.php:392
JROOT/libraries/cms/component/helper.php:372
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:45
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 1.36 ms After last query: 1.02 ms Query memory: 0.025 MB Memory before query: 3.047 MB Rows returned: 2
```
SELECT b.rules

  FROM joomla_assets AS a

  LEFT JOIN joomla_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
```
Explain
EXPLAIN not possible on query: SELECT b.rules FROM joomla_assets AS a LEFT JOIN joomla_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
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/joomla/access/access.php:246
JROOT/libraries/joomla/access/access.php:107
JROOT/libraries/joomla/user/user.php:393
JROOT/components/com_content/models/article.php:55
JROOT/libraries/legacy/model/legacy.php:439
JROOT/components/com_content/models/article.php:75
JROOT/libraries/legacy/view/legacy.php:401
JROOT/components/com_content/views/article/view.html.php:42
JROOT/libraries/joomla/cache/controller/view.php:96
JROOT/libraries/legacy/controller/legacy.php:686
JROOT/components/com_content/controller.php:104
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_content/content.php:38
JROOT/libraries/cms/component/helper.php:392
JROOT/libraries/cms/component/helper.php:372
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:45
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 4.68 ms After last query: 0.83 ms Query memory: 0.019 MB Memory before query: 3.091 MB Rows returned: 1
```
SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, 
  CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, 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, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, 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,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 joomla_content AS a

  LEFT JOIN joomla_categories AS c 
  on c.id = a.catid

  LEFT JOIN joomla_users AS u 
  on u.id = a.created_by

  LEFT JOIN joomla_categories as parent 
  ON parent.id = c.parent_id

  LEFT JOIN joomla_content_rating AS v 
  ON a.id = v.content_id

  LEFT 
  OUTER JOIN  (SELECT cat.id as id 
  FROM joomla_categories AS cat JOIN joomla_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.id = 2 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2018-11-19 00:40:47') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2018-11-19 00:40:47') 
  AND (a.state = 1 OR a.state =2)
```
Explain
EXPLAIN not possible on query: SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, 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, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, 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,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 joomla_content AS a LEFT JOIN joomla_categories AS c on c.id = a.catid LEFT JOIN joomla_users AS u on u.id = a.created_by LEFT JOIN joomla_categories as parent ON parent.id = c.parent_id LEFT JOIN joomla_content_rating AS v ON a.id = v.content_id LEFT OUTER JOIN (SELECT cat.id as id FROM joomla_categories AS cat JOIN joomla_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.id = 2 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2018-11-19 00:40:47') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2018-11-19 00:40:47') AND (a.state = 1 OR a.state =2)
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/components/com_content/models/article.php:159
JROOT/libraries/legacy/view/legacy.php:401
JROOT/components/com_content/views/article/view.html.php:42
JROOT/libraries/joomla/cache/controller/view.php:96
JROOT/libraries/legacy/controller/legacy.php:686
JROOT/components/com_content/controller.php:104
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_content/content.php:38
JROOT/libraries/cms/component/helper.php:392
JROOT/libraries/cms/component/helper.php:372
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:45
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 3.07 ms After last query: 2.60 ms Query memory: 0.021 MB Memory before query: 3.207 MB Rows returned: 2
```
SELECT 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, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug

  FROM joomla_categories as c

  LEFT JOIN joomla_categories AS s 
  ON (s.lft <= c.lft 
  AND s.rgt >= c.rgt) OR (s.lft > c.lft 
  AND s.rgt < c.rgt)

  LEFT JOIN  (SELECT cat.id as id 
  FROM joomla_categories AS cat JOIN joomla_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,5) 
  AND c.published = 1 
  AND s.id=2 
  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, c.version

  ORDER BY c.lft
```
Explain
EXPLAIN not possible on query: SELECT 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, c.version, CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug FROM joomla_categories as c LEFT JOIN joomla_categories AS s ON (s.lft <= c.lft AND s.rgt >= c.rgt) OR (s.lft > c.lft AND s.rgt < c.rgt) LEFT JOIN (SELECT cat.id as id FROM joomla_categories AS cat JOIN joomla_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,5) AND c.published = 1 AND s.id=2 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, c.version ORDER BY c.lft
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/legacy/categories/categories.php:292
JROOT/libraries/legacy/categories/categories.php:184
JROOT/components/com_content/helpers/route.php:44
JROOT/components/com_content/views/article/view.html.php:71
JROOT/libraries/joomla/cache/controller/view.php:96
JROOT/libraries/legacy/controller/legacy.php:686
JROOT/components/com_content/controller.php:104
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_content/content.php:38
JROOT/libraries/cms/component/helper.php:392
JROOT/libraries/cms/component/helper.php:372
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:45
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 1.45 ms After last query: 1.93 ms Query memory: 0.018 MB Memory before query: 3.294 MB Rows returned: 0
```
SELECT `m`.`tag_id`,`t`.*

  FROM `joomla_contentitem_tag_map` AS m 

  INNER JOIN `joomla_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

  WHERE `m`.`type_alias` = 'com_content.article' 
  AND `m`.`content_item_id` = 2 
  AND `t`.`published` = 1 
  AND t.access IN (1,1,5)
```
Explain
EXPLAIN not possible on query: SELECT `m`.`tag_id`,`t`.* FROM `joomla_contentitem_tag_map` AS m INNER JOIN `joomla_tags` AS t ON `m`.`tag_id` = `t`.`id` WHERE `m`.`type_alias` = 'com_content.article' AND `m`.`content_item_id` = 2 AND `t`.`published` = 1 AND t.access IN (1,1,5)
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/cms/helper/tags.php:426
JROOT/components/com_content/views/article/view.html.php:155
JROOT/libraries/joomla/cache/controller/view.php:96
JROOT/libraries/legacy/controller/legacy.php:686
JROOT/components/com_content/controller.php:104
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_content/content.php:38
JROOT/libraries/cms/component/helper.php:392
JROOT/libraries/cms/component/helper.php:372
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:45
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 11.90 ms After last query: 6.50 ms Query memory: 0.024 MB Memory before query: 3.453 MB Rows returned: 30
Duplicate queries: #9
```
SHOW FULL COLUMNS 
  FROM `joomla_content`
```
Explain
EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `joomla_content`
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/joomla/table/table.php:241
JROOT/libraries/joomla/table/table.php:162
JROOT/libraries/legacy/table/content.php:31
JROOT/libraries/joomla/table/table.php:305
JROOT/components/com_content/models/article.php:264
JROOT/components/com_content/views/article/view.html.php:176
JROOT/libraries/joomla/cache/controller/view.php:96
JROOT/libraries/legacy/controller/legacy.php:686
JROOT/components/com_content/controller.php:104
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_content/content.php:38
JROOT/libraries/cms/component/helper.php:392
JROOT/libraries/cms/component/helper.php:372
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:45
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.84 ms After last query: 4.49 ms Query memory: 0.019 MB Memory before query: 3.592 MB Rows returned: 1
```
SELECT *

  FROM joomla_content

  WHERE `id` = '2'
```
Explain
EXPLAIN not possible on query: SELECT * FROM joomla_content WHERE `id` = '2'
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/joomla/table/table.php:728
JROOT/components/com_content/models/article.php:265
JROOT/components/com_content/views/article/view.html.php:176
JROOT/libraries/joomla/cache/controller/view.php:96
JROOT/libraries/legacy/controller/legacy.php:686
JROOT/components/com_content/controller.php:104
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_content/content.php:38
JROOT/libraries/cms/component/helper.php:392
JROOT/libraries/cms/component/helper.php:372
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:45
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.60 ms After last query: 0.31 ms Query memory: 0.017 MB Memory before query: 3.613 MB
```
UPDATE joomla_content

  SET `hits` = (`hits` + 1)

  WHERE `id` = '2'
```
Explain
EXPLAIN not possible on query: UPDATE joomla_content SET `hits` = (`hits` + 1) WHERE `id` = '2'
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/joomla/table/table.php:1239
JROOT/components/com_content/models/article.php:266
JROOT/components/com_content/views/article/view.html.php:176
JROOT/libraries/joomla/cache/controller/view.php:96
JROOT/libraries/legacy/controller/legacy.php:686
JROOT/components/com_content/controller.php:104
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_content/content.php:38
JROOT/libraries/cms/component/helper.php:392
JROOT/libraries/cms/component/helper.php:372
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:45
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 2.46 ms After last query: 23.22 ms Query memory: 0.017 MB Memory before query: 3.702 MB Rows returned: 11
```
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid

  FROM joomla_modules AS m

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

  LEFT JOIN joomla_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 <= '2018-11-19 00:40:47') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2018-11-19 00:40:47') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 101 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering
```
Explain
EXPLAIN not possible on query: SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid FROM joomla_modules AS m LEFT JOIN joomla_modules_menu AS mm ON mm.moduleid = m.id LEFT JOIN joomla_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 <= '2018-11-19 00:40:47') AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2018-11-19 00:40:47') AND m.access IN (1,1,5) AND m.client_id = 0 AND (mm.menuid = 101 OR mm.menuid <= 0) ORDER BY m.position, m.ordering
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/cms/module/helper.php:407
JROOT/libraries/cms/module/helper.php:350
JROOT/libraries/cms/module/helper.php:84
JROOT/libraries/joomla/document/html/html.php:501
JROOT/templates/cando/index.php:104
JROOT/libraries/joomla/document/html/html.php:578
JROOT/libraries/joomla/document/html/html.php:635
JROOT/libraries/joomla/document/html/html.php:455
JROOT/libraries/cms/application/cms.php:1045
JROOT/libraries/cms/application/site.php:745
JROOT/libraries/cms/application/cms.php:258
JROOT/index.php:45
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 1.87 ms After last query: 13.46 ms Query memory: 0.024 MB Memory before query: 3.953 MB Rows returned: 0
```
SELECT a.fulltext, a.id, a.title, a.alias, a.introtext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.featured, a.language,a.fulltext, a.id, a.title, a.alias, a.introtext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.featured, a.language,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 joomla_content AS a

  LEFT JOIN joomla_content_frontpage AS fp 
  ON fp.content_id = a.id

  LEFT JOIN joomla_categories AS c 
  ON c.id = a.catid

  LEFT JOIN joomla_users AS ua 
  ON ua.id = a.created_by

  LEFT JOIN joomla_users AS uam 
  ON uam.id = a.modified_by

  LEFT JOIN joomla_categories as parent 
  ON parent.id = c.parent_id

  LEFT JOIN joomla_content_rating AS v 
  ON a.id = v.content_id

  LEFT 
  OUTER JOIN (SELECT cat.id as id 
  FROM joomla_categories AS cat JOIN joomla_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 a.access IN (1,1,5) 
  AND c.access IN (1,1,5) 
  AND 
  CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1 
  AND a.catid IN (9) 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2018-11-19 00:40:47') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2018-11-19 00:40:47')

  ORDER BY a.publish_up DESC 
  LIMIT 0, 2
```
Explain
EXPLAIN not possible on query: SELECT a.fulltext, a.id, a.title, a.alias, a.introtext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.featured, a.language,a.fulltext, a.id, a.title, a.alias, a.introtext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.featured, a.language,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 joomla_content AS a LEFT JOIN joomla_content_frontpage AS fp ON fp.content_id = a.id LEFT JOIN joomla_categories AS c ON c.id = a.catid LEFT JOIN joomla_users AS ua ON ua.id = a.created_by LEFT JOIN joomla_users AS uam ON uam.id = a.modified_by LEFT JOIN joomla_categories as parent ON parent.id = c.parent_id LEFT JOIN joomla_content_rating AS v ON a.id = v.content_id LEFT OUTER JOIN (SELECT cat.id as id FROM joomla_categories AS cat JOIN joomla_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 a.access IN (1,1,5) AND c.access IN (1,1,5) AND CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1 AND a.catid IN (9) AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2018-11-19 00:40:47') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2018-11-19 00:40:47') ORDER BY a.publish_up DESC LIMIT 0, 2
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/legacy/model/legacy.php:312
JROOT/libraries/legacy/model/list.php:185
JROOT/components/com_content/models/articles.php:537
JROOT/modules/mod_articles_news/helper.php:82
JROOT/modules/mod_articles_news/mod_articles_news.php:15
JROOT/libraries/cms/module/helper.php:190
JROOT/libraries/joomla/cache/controller/callback.php:157
JROOT/libraries/cms/module/helper.php:595
JROOT/libraries/joomla/document/html/renderer/module.php:99
JROOT/libraries/joomla/document/html/renderer/modules.php:43
JROOT/libraries/joomla/document/html/html.php:411
JROOT/libraries/joomla/document/html/html.php:697
JROOT/libraries/joomla/document/html/html.php:477
JROOT/libraries/cms/application/cms.php:1059
JROOT/libraries/cms/application/site.php:745
JROOT/libraries/cms/application/cms.php:258
JROOT/index.php:45
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

21 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

2 × SELECT extension_id AS id, element AS "option", params, enabled 
  FROM joomla_extensions

1 × SELECT 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, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug 
  FROM joomla_categories as c 
  LEFT JOIN joomla_categories AS s 
  ON (s.lft <= c.lft 
  AND s.rgt >= c.rgt) OR (s.lft > c.lft 
  AND s.rgt < c.rgt) 
  LEFT JOIN  (SELECT cat.id as id 
  FROM joomla_categories AS cat JOIN joomla_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt

1 × SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, 
  CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, 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, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, 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,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 joomla_content AS a 
  LEFT JOIN joomla_categories AS c 
  on c.id = a.catid 
  LEFT JOIN joomla_users AS u 
  on u.id = a.created_by 
  LEFT JOIN joomla_categories as parent 
  ON parent.id = c.parent_id 
  LEFT JOIN joomla_content_rating AS v 
  ON a.id = v.content_id 
  LEFT 
  OUTER JOIN  (SELECT cat.id as id 
  FROM joomla_categories AS cat JOIN joomla_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt

1 × SELECT `m`.`tag_id`,`t`.* 
  FROM `joomla_contentitem_tag_map` AS m  
  INNER JOIN `joomla_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

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

```
1 × SELECT * 
  FROM joomla_content
```

1 × SELECT a.fulltext, a.id, a.title, a.alias, a.introtext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.featured, a.language,a.fulltext, a.id, a.title, a.alias, a.introtext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.featured, a.language,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 joomla_content AS a 
  LEFT JOIN joomla_content_frontpage AS fp 
  ON fp.content_id = a.id 
  LEFT JOIN joomla_categories AS c 
  ON c.id = a.catid 
  LEFT JOIN joomla_users AS ua 
  ON ua.id = a.created_by 
  LEFT JOIN joomla_users AS uam 
  ON uam.id = a.modified_by 
  LEFT JOIN joomla_categories as parent 
  ON parent.id = c.parent_id 
  LEFT JOIN joomla_content_rating AS v 
  ON a.id = v.content_id 
  LEFT 
  OUTER JOIN (SELECT cat.id as id 
  FROM joomla_categories AS cat JOIN joomla_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt

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

1 × SELECT a.rules 
  FROM joomla_assets AS a

1 × SELECT id, home, template, s.params 
  FROM joomla_template_styles as s 
  LEFT JOIN joomla_extensions as e 
  ON e.element=s.template 
  AND e.type='template' 
  AND e.client_id=s.client_id

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

1 × SELECT `session_id` 
  FROM `joomla_session`

1 × SELECT id, rules 
  FROM `joomla_viewlevels

1 × SELECT folder AS type, element AS name, params 
  FROM joomla_extensions

```
1 × SELECT * 
  FROM joomla_languages
```

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

1 × SELECT `data` 
  FROM `joomla_session`

OTHER Tables:

2 × SHOW FULL COLUMNS 
  FROM `joomla_content

1 × UPDATE joomla_content 
  SET `hits` = (`hits` + 1)

1 × UPDATE `joomla_extensions` 
  SET `params` = '{\"mediaversion\":\"2a457f7f6743397ac79db7430e390a67\"}'

1 × INSERT INTO `joomla_session` (`session_id`, `client_id`, `time`) 
  VALUES  ('ib0mvjophvmsurt4ah788nq2n5', 0, '1542588046'

Vehicle Finance Cheap Car Loans Cando Car Finance

Auto Loan Calculator

Auto finance experienced loan brokers

How to get the cheapest Car Loans

Buying a Car with low or no deposit

Private sales or Auctions

CanDo's best financed offers below

Joomla! Debug Console

Session

__default

Profile Information