Voucher Plugins

Joomla Gift Card Plugin

Let your customers buy gift cards/certificates for your services & products directly on your website. (See live examples here, here & here).

Reduce manual efforts with Joomla Gift Voucher Plugin for the basic events related to templates like “Birthday”, “New Year”, “Valentine’s day”, “Independence day”, etc. Create your own templates, set your own logo or any event image etc.

PURCHASE NOW

Purchase Now

Trapped over deciding what could you can gift your customers, employees, relatives or neighbours. Here we come to your rescue with our brilliantly customizable gift cards plugin.

Joomla Gift Card Plugin is a multi-supported plugin that is unique in its own way. It is a perfect solution for gift cards, rewards, promotions, fitness & wellness packages and event tickets that includes variety of services. The merchant can create many gift card products or gift packages according to the fest and occasion with perfect prices.

Not only this, the plugin also opens the door for you to sell any product, service or experience online using PDF gift cards that can be printed and redeemed in person.

Basic vouchers for events like ‘Birthday’, ‘Anniversary’, ‘New Year’, ‘Valentine’s Day’ etc can be easily created. They largely reduce manual efforts because all you need to do is just select a template of your choice from available options, set your logo or event image and you are DONE! You see how simple is that!

PURCHASE NOW

Main Features - Frontend

Create and design templates with your own logo as per the occasions or fests.
Customers can pick from a variety of templates uploaded by the admin and can sort by events (Anniversaries, Birthdays, Valentine’s day, Weddings, etc.)
Customers can view coupon balance.
Admins can create fixed price gift items for different services and products for their customers.
Customers can preview their Gift Card on their booking page.
Purchased gift card/voucher is sent to the recipient’s email address.
Add messages to be printed on the PDF gift card/voucher.
Redeem gift cards/vouchers using unique auto-generated coupon codes.
Multiple payment gateway integrations available such as Stripe, PayPal, Sofort Pay, and Bank Transfer.
Invoice based payment solutions i.e. your customers can directly pay to your bank account after purchasing the voucher
Provides 3 varieties for voucher styles in PDF formats (See Demo)
Set voucher expiry as fixed dates or number of days
Remove Expiry date from vouchers
Hide Price from vouchers
Allow customers to schedule when a gift card will be delivered
Send customer receipt after successful order placement.

Main Features - Backend

View all gift orders.
Track the gift cards/vouchers whether they are used or paid orders
Add edit/delete/view to your voucher/card templates and gift items
View details of each gift card: full amount, credit left, associated gift-card order, orders on which it has been applied and the total spend it generated.
Export all gift orders
Create gift categories
Set your sender name, email, company name along with company details from plugin settings etc.
Enable multiple payment gateways

Premium Live Demo

Watch the premium demo to get a crystal clear understanding of the features of Gift Cards.

For easy understanding visit our demos from below links –

Gift Voucher Demo Watch the premium demo to get a crystal clear understanding of the features of Gift Cards.For easy understanding visit our demos from below links – Gift Voucher Demo
Gift Item Demo Watch the premium demo to get a crystal clear understanding of the features of Gift Item .For easy understanding visit our demos from below links – Gift Item Demo

If you want to demo payment for a Giftcard account, please try the accounts here:

- Paypal:

User name: This email address is being protected from spambots. You need JavaScript enabled to view it.
Password: jonirenoug123!@#

- Stripe:

Email: This email address is being protected from spambots. You need JavaScript enabled to view it.
Card information:
Number: 4242424242424242
Expiry: 12/21
CVV: 123
Name on card: Patrick Fuchshofer

Documentation

Please, read the official documentation of Joomla Gift Card Plugin to learn more about all plugin features.

Status	Duration
starting	0.14 ms
checking permissions	0.02 ms
Opening tables	0.89 ms
init	0.03 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.59 ms
executing	0.03 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.02 ms
freeing items	0.03 ms
cleaning up	0.03 ms

#	Caller	File and line number
12	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1465
11	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/database/driver/pdomysql.php:587
10	JDatabaseDriverPdomysql->hasProfiling()	JROOT/libraries/joomla/database/driver/pdomysql.php:162
9	JDatabaseDriverPdomysql->connect()	JROOT/libraries/src/Filter/InputFilter.php:72
8	Joomla\CMS\Filter\InputFilter->__construct()	JROOT/libraries/src/Filter/InputFilter.php:105
7	Joomla\CMS\Filter\InputFilter::getInstance()	JROOT/libraries/src/Input/Input.php:64
6	Joomla\CMS\Input\Input->__construct()	JROOT/libraries/src/Application/WebApplication.php:213
5	Joomla\CMS\Application\WebApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:109
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:344
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

Status	Duration
starting	0.05 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
init	0.03 ms
System lock	0.03 ms
optimizing	0.03 ms
statistics	0.04 ms
executing	0.04 ms
end	0.04 ms
query end	0.02 ms
closing tables	0.02 ms
freeing items	0.03 ms
cleaning up	0.03 ms

#	Caller	File and line number
16	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
14	JSessionStorageDatabase->read()	Same as call in the line below.
13	session_start()	JROOT/libraries/joomla/session/handler/native.php:260
12	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:50
11	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:88
10	JSessionHandlerJoomla->start()	JROOT/libraries/src/Session/Session.php:660
9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:620
8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:498
7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:455
6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:758
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:344
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

Status	Duration
starting	0.05 ms
checking permissions	0.03 ms
Opening tables	0.03 ms
init	0.03 ms
System lock	0.02 ms
update	0.64 ms
Waiting for query cache lock	0.03 ms
update	0.03 ms
end	0.02 ms
query end	0.06 ms
closing tables	0.03 ms
freeing items	0.03 ms
cleaning up	0.03 ms

Joomla Gift Card Plugin

Login Form

Joomla! Debug Console

Session

Profile Information

Time

Memory

Memory Usage

Database Queries

21 Queries Logged 69.76 ms

20 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

OTHER Tables:

#	Caller	File and line number
8	JDatabaseDriverPdo->execute()	JROOT/libraries/src/Session/MetadataManager.php:116
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:153
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:760
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:344
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

#	Caller	File and line number
12	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Component/ComponentHelper.php:445
10	Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}()	Same as call in the line below.
9	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
8	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Component/ComponentHelper.php:453
7	Joomla\CMS\Component\ComponentHelper::load()	JROOT/libraries/src/Component/ComponentHelper.php:519
6	Joomla\CMS\Component\ComponentHelper::getComponents()	JROOT/libraries/src/Component/ComponentHelper.php:44
5	Joomla\CMS\Component\ComponentHelper::getComponent()	JROOT/libraries/src/Component/ComponentHelper.php:103
4	Joomla\CMS\Component\ComponentHelper::getParams()	JROOT/libraries/src/Application/SiteApplication.php:594
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

#	Caller	File and line number
10	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1506
9	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Access/Access.php:1063
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:321
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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; Using index

Status	Duration
starting	0.08 ms
checking permissions	0.04 ms
Opening tables	0.03 ms
init	0.05 ms
System lock	0.04 ms
optimizing	0.04 ms
statistics	0.08 ms
preparing	0.09 ms
Sorting result	0.05 ms
executing	0.03 ms
Sending data	0.06 ms
Creating sort index	1.11 ms
end	0.03 ms
query end	0.03 ms
closing tables	0.03 ms
freeing items	0.08 ms
cleaning up	0.03 ms

#	Caller	File and line number
11	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1550
10	JDatabaseDriver->loadColumn()	JROOT/libraries/src/Access/Access.php:980
9	Joomla\CMS\Access\Access::getGroupsByUser()	JROOT/libraries/src/Access/Access.php:1095
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:321
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

Status	Duration
starting	0.07 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
Opening tables	1.18 ms
init	0.06 ms
System lock	0.03 ms
optimizing	0.03 ms
statistics	0.73 ms
preparing	0.09 ms
Sorting result	0.03 ms
executing	0.02 ms
Sending data	0.04 ms
Creating sort index	3.36 ms
end	0.03 ms
query end	0.03 ms
closing tables	0.03 ms
freeing items	0.03 ms
cleaning up	0.03 ms

#	Caller	File and line number
15	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1662
14	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
13	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Same as call in the line below.
12	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
11	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
10	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
9	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
8	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
7	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
6	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
5	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/Application/WebApplication.php:1130
4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT/libraries/src/Application/SiteApplication.php:133
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

#	Caller	File and line number
10	JDatabaseDriverPdo->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
9	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
8	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
7	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
6	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
5	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/Application/WebApplication.php:1130
4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT/libraries/src/Application/SiteApplication.php:133
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid,extension	extension	82	const	4	1.25	Using index condition; Using where
1	SIMPLE	s	NULL	ref	idx_template,idx_client_id,idx_client_id_home	idx_template	202	5150598db142.e.element	1	60.00	Using index condition; Using where

#	Caller	File and line number
19	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
17	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Same as call in the line below.
16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
14	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:76
13	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
12	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:131
11	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:375
10	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
9	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:65
8	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
7	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:491
6	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:403
5	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/libraries/src/Application/CMSApplication.php:1073
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

#	Caller	File and line number
21	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
19	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
18	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
17	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
16	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
15	Joomla\CMS\User\User->authorise()	JROOT/components/com_content/models/articles.php:115
14	ContentModelArticles->populateState()	JROOT/components/com_content/models/featured.php:45
13	ContentModelFeatured->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:440
12	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_content/views/featured/view.html.php:55
10	ContentViewFeatured->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

Status	Duration
starting	0.10 ms
checking permissions	0.02 ms
Opening tables	1.40 ms
init	0.07 ms
System lock	0.03 ms
optimizing	0.05 ms
statistics	0.16 ms
preparing	0.03 ms
executing	0.02 ms
Sending data	1.54 ms
end	0.03 ms
query end	0.02 ms
closing tables	0.03 ms
freeing items	0.03 ms
cleaning up	0.04 ms

Status	Duration
starting	0.20 ms
checking permissions	0.05 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
Opening tables	4.45 ms
init	0.14 ms
System lock	0.03 ms
optimizing	0.03 ms
statistics	1.66 ms
preparing	0.06 ms
Creating tmp table	0.10 ms
Sorting result	0.03 ms
executing	0.02 ms
Sending data	3.10 ms
Creating sort index	0.08 ms
end	0.02 ms
query end	0.03 ms
removing tmp table	0.06 ms
query end	0.03 ms
closing tables	0.05 ms
freeing items	0.05 ms
cleaning up	0.04 ms

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ALL	idx_tag_type	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	Using where
1	SIMPLE	t	NULL	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	5150598db142.m.tag_id	1	100.00	Using where

Status	Duration
starting	0.12 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
Opening tables	0.05 ms
init	0.05 ms
System lock	0.03 ms
optimizing	0.03 ms
statistics	0.13 ms
preparing	0.06 ms
executing	0.02 ms
Sending data	0.07 ms
end	0.02 ms
query end	0.03 ms
closing tables	0.03 ms
freeing items	0.04 ms
cleaning up	0.03 ms

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	fp	NULL	index	PRIMARY	PRIMARY	4	NULL	2	100.00	Using index
1	SIMPLE	a	NULL	eq_ref	PRIMARY,idx_access,idx_state,idx_catid	PRIMARY	4	5150598db142.fp.content_id	1	5.00	Using where
1	SIMPLE	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	5150598db142.a.created_by	1	100.00	Using where; Using index
1	SIMPLE	uam	NULL	eq_ref	PRIMARY	PRIMARY	4	5150598db142.a.modified_by	1	100.00	Using where; Using index
1	SIMPLE	c	NULL	eq_ref	PRIMARY,idx_access	PRIMARY	4	5150598db142.a.catid	1	10.00	Using where
1	SIMPLE	parent	NULL	eq_ref	PRIMARY	PRIMARY	4	5150598db142.c.parent_id	1	100.00	Using where; Using index

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	100.00	Using index condition; Using where; Using temporary; Using filesort
1	SIMPLE	l	NULL	eq_ref	idx_langcode	idx_langcode	28	5150598db142.a.language	1	100.00	Using where
1	SIMPLE	uc	NULL	eq_ref	PRIMARY	PRIMARY	4	5150598db142.a.checked_out	1	100.00	NULL
1	SIMPLE	ag	NULL	eq_ref	PRIMARY	PRIMARY	4	5150598db142.a.access	1	100.00	Using where
1	SIMPLE	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	5150598db142.a.created_user_id	1	100.00	Using where
1	SIMPLE	g	NULL	eq_ref	PRIMARY	PRIMARY	4	5150598db142.a.group_id	1	100.00	Using where
1	SIMPLE	fc	NULL	ref	PRIMARY	PRIMARY	4	5150598db142.a.id	1	100.00	Using where; Using index; Distinct