June 2015 - Spanish Wedding Planner

Instead of flowers...

Friday, 26 June 2015 00:00

For some brides a bridal bouquet is an integral part of the Big Day and their wedding would not be complete without a bouquet and floral decoration. However, if flowers aren't your thing, you are allergic to certain pollens or flowers , or you haven't got big money to spend in blooms there are other options.

Spanish fans: Fans are very much a part of the tradition and culture in Southern Spain so carrying a special bridal fan and not a bouquet is a great way to change things up from a traditional bouquet. There are still plenty of small family run companies making incredible ornate fans that work brilliantly as you walk up the aisle so you can choose from lots of colours and styles. Fans usually work out cheaper than bouquets and come in a range of colours so you can coordinate bridesmaids fans with your colour scheme and carry on the fan decoration at your reception venue. Ask your planner for prices and examples.

A book: In years gone by brides sometimes carried a prayer book as they walked into the church. Nowadays though you can buck the bouquet trend AND add special meaning to your wedding by carrying a book which has meaning to you and your fiance. If you have a special poem or novel which means something to you and your story then why not use this instead of bouquet?

A wedding purse: This is not just a great to carry a couple of essential or meaningful items but because you really can go to town to make this match your dress and outfit. You can have the purse made of pretty much any material in any colour, add smaller versions for your bridesmaids and, if you have a close family member who can’t be with you on the day, carry a memento of them with you in your purse so can be with you in spirit.

A wedding broach or piece of jewellery: This can be a long-lasting alternative to a wedding bouquet and something which leaves your hands free too! There are some great jewellery designers who will design something to suit your ideas or you can shop around online to find something off the peg to suit your colour scheme, style and budget.

Remember - ultimately it’s your day and if you don’t want flowers then there are alternatives!

What to look for in a wedding planner!

Friday, 19 June 2015 00:00

It may be a strange topic for a wedding planner to broach but there is no doubt finding a good wedding planner is vital if you are going to entrust your Big Day to someone. Not all wedding planners are created equal so if you are paying for a planner make sure you know what to look for in the best.

Long established - we are the longest established wedding company in Spain. A good planner should have worked in the business for several years or be able to tell you what makes her previous experience relevant to wedding planning if she is a relative new comer.

Experience - when it comes to planning and executing a wedding, experience really does count. Check with your planner how many weddings she has done and, if in doubt, ask for testimonials from couples who have used her services in the past.

Variety of suppliers and products. We think we offer the best variety for suppliers and decoration but a good planner should be able to offer you a choice of suppliers such as photographers and be able to suggest great ideas for decoration, favours and flowers etc which will work well at your venue and with the suppliers and wedding date you have chosen.

The way the planner works. We use a great wedding planning software to make the planning easier and documented and this also provides you with a wedding website to make it easier for your guests. Even if your planner does not use a particular software she should be organised and have systems in place so your wedding requests and choices are noted and reflected in your budget.

Love of the job - this is hard to quantify but really why would you want to hire a wedding planner who does not love what she does!

Happy planning!

Honeymoon in Spain - five reasons why it’s a great idea!

Friday, 12 June 2015 00:00

Photo credit: www.honeymoonbeat.com

You´ve come out to Spain for your special day so why make things complicated- stay on for your honeymoon and save time money and stress. See below for five good reasons to have your honeymoon in Spain:

1) Save money. Let´s face it getting married is not cheap. By the time you have paid for your dress, ceremony, music, flights and food and drink for your special day you have usually spent a considerable sum on money. One of the great ways you can save in the long run is by combining your Big Day with your Big holiday - your honeymoon. You can save on flights by staying on in Spain instead of flying back home and off again to a different destination and hotels and venues will often offer special deals for honeymooning couples if you’ve held the wedding there.

2) Save hassle. If you´ve already hired a wedding planner for your Big Day, tap into her expertise and wisdom by asking her to help with your honeymoon too. You can save time and find great deals by asking your wedding planner to help book all or parts of your Spanish honeymoon meaning you have less worry and organisation and more time to enjoy yourselves!

3) Find out more about the area you got married in. The chances are that one of the main reasons you got married in Spain was because you wanted sunshine on your wedding day. There is much more to Spain than just blue skies and tapas though. Staying on after your wedding can give you a chance to explore the history and culture of the area where you got married. There are world famous monuments such as the Alhambra in Granada but also fascinating museums, gardens, ruins, caves and castles. Finding out more can give your decision to marry in Spain a additional depth and meaning and even more memories too!

4) Find out more about a completely different area of Spain. Now you´re in Spain it´s much easier to go further afield and not only explore the area where you married but completely different parts of Spain too. Visit the incredible cities of Madrid and Barcelona, explore historic Toledo, take off walking in the Alpujjaran mountains or get away from it all in Asturias’ incredible countryside. You´be surprised how diverse Spain is!

5) Banish logistical headaches! You and your loved one are in Spain - so stay in Spain. Instead of flying back, unpacking and repacking for a different honeymoon stay on and get a chance to completely unwind and spend time the one you love. After all that´s why you got married….

Help! What kind of wedding ceremony do I want?

Friday, 05 June 2015 00:00

Photo credit: Bob Long

You want to get married in the sun and you love the idea of a relaxed, fun day in Spain soaking up the sun, marrying the one you love and giving your friends and family a holiday into the bargain. You know the kind of venue you like - be it hotel, villa, restaurant or beach bar - but then get stuck on the ceremony. This is not unusual as there is often confusion about the types of ceremony possible for couples marrying here in Spain. In this week's blog therefore we are looking at all the possibilities for your Big Day.

Traditional Catholic ceremony
Possible if one or both of you are Catholic.* Catholic weddings have the advantage of being legally binding providing you do the paperwork required as we can then register them civilly. They are less flexible than blessings however as they must take place in a consecrated Catholic church and the ceremony is the set marriage ceremony for Catholic weddings.

*NB: This applies if you are from Europe. US and Canadian residents and citizens need a civil ceremony in their home country even if they are both Catholic.

Wedding blessing
The blessing ceremony can take place in any location of your choosing and is usually followed by the celebration at the same venue with family and friends. Blessing ceremonies look and sound the same as a "normal" ceremony so your guests will not know it is not legally binding unless you wish to tell them. Many couples actually feel this is the real ceremony in that it is the personal and meaningful commitment to each other while the registry office ceremony was a formality which does not have the same emotional power.

The ceremony can take any of the following forms:

Humanist/Secular - no mention of God or religion, simply about your personal commitment to each other.
Interfaith - a ceremony combining elements of a religious faith with secular and personal traditions and readings.
Christian - the ceremony can follow a traditional Christian format eg: Church of England or be more broadly Christian and incorporate prayers and readings of your choosing.

Other faith ceremonies such as Jewish and Muslim can also be celebrated but are not legally binding so a civil ceremony in your home country or country of residence is also needed to legalise your marriage.

Civil ceremony
If one or both of you are resident in Spain and have been resident for two or more years then it should be possible for you to have a legally binding civil ceremony. This type of civil ceremony is usually conducted at the town hall (Ayuntamiento) in the area in which you are resident. As the legal civil ceremony is usually fairly short (10 - 15 minutes) and quite impersonal most couples also choose to have a Wedding Blessing and celebration.

Remember it’s your day and the ceremony is a vital part of this so it is worth considering the options carefully so you and your loved one can really enjoy every moment!

Status	Duration
Starting	0.10 ms
checking permissions	0.01 ms
Opening tables	0.07 ms
After opening tables	0.05 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.06 ms
Statistics	0.13 ms
Preparing	0.06 ms
Executing	0.03 ms
End of update loop	0.01 ms
Query end	0.04 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.05 ms
Reset for next command	0.01 ms

#	Caller	File and line number
16	JDatabaseDriverMysqli->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:661
9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:621
8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:499
7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:456
6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:826
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
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:386
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.06 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.05 ms
Preparing	0.01 ms
Executing	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.03 ms
Updating status	0.03 ms
Reset for next command	0.00 ms

#	Caller	File and line number
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
8	JDatabaseDriver->loadResult()	JROOT/libraries/src/Session/MetadataManager.php:74
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:154
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:828
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
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:386
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.01 ms
After opening tables	0.02 ms
System lock	0.01 ms
table lock	0.01 ms
init for update	0.02 ms
Update	0.28 ms
Waiting for query cache lock	0.01 ms
Update	0.02 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.67 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Instead of flowers...

What to look for in a wedding planner!

Honeymoon in Spain - five reasons why it’s a great idea!

Help! What kind of wedding ceremony do I want?

Archive

Most popular

Tagcloud

Joomla! Debug Console

Session

Profile Information

Time

Memory

Memory Usage

Database Queries

55 Queries Logged 78.97 ms

2 duplicate found!

38 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

OTHER Tables:

Status	Duration
Starting	0.08 ms
checking permissions	0.01 ms
Opening tables	0.07 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.03 ms
Statistics	0.21 ms
Preparing	0.06 ms
Executing	0.02 ms
Sending data	0.32 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.03 ms
Starting cleanup	0.02 ms
Freeing items	0.04 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

#	Caller	File and line number
12	JDatabaseDriverMysqli->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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

#	Caller	File and line number
10	JDatabaseDriverMysqli->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:318
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

#	Caller	File and line number
11	JDatabaseDriverMysqli->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:318
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Status	Duration
Starting	0.17 ms
checking permissions	0.02 ms
Opening tables	0.17 ms
After opening tables	0.02 ms
System lock	0.03 ms
table lock	0.01 ms
init	0.06 ms
Optimizing	0.04 ms
Statistics	0.15 ms
Preparing	0.06 ms
Sorting result	0.03 ms
Executing	0.01 ms
Sending data	0.05 ms
Creating sort index	1.03 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.03 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Status	Duration
Starting	0.11 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.04 ms
Optimizing	0.03 ms
Statistics	0.16 ms
Preparing	0.04 ms
Executing	0.01 ms
Sending data	0.09 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.02 ms
Unlocking tables	0.01 ms
closing tables	0.03 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
18	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
17	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{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/Helper/LibraryHelper.php:175
14	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
13	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
12	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
11	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
10	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
9	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/k2/k2.php:374
8	plgSystemK2->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
13	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
12	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
11	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
10	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
9	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/k2/k2.php:374
8	plgSystemK2->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
11	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
10	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
9	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
8	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
7	Joomla\CMS\User\User->authorise()	JROOT/components/com_k2/k2.php:16
6	require_once JROOT/components/com_k2/k2.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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/components/com_k2/models/itemlist.php:348
12	K2ModelItemlist->getData()	JROOT/components/com_k2/views/itemlist/view.html.php:566
11	K2ViewItemlist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/itemlist.php:49
8	K2ControllerItemlist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	ref	idx_template,idx_client_id,idx_client_id_home	idx_client_id	1	const	3
1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	swp_db.s.template,const	1	Using index condition; Using where

Status	Duration
Starting	0.20 ms
checking permissions	0.01 ms
Opening tables	0.23 ms
After opening tables	0.05 ms
System lock	0.02 ms
table lock	0.04 ms
init	0.11 ms
Optimizing	0.06 ms
Statistics	0.33 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.06 ms
Sorting result	0.03 ms
Executing	0.01 ms
Sending data	0.03 ms
Creating sort index	0.75 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.02 ms
Reset for next command	0.03 ms

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
17	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_k2/tables/k2category.php:61
16	TableK2Category->load()	JROOT/components/com_k2/models/item.php:65
15	K2ModelItem->prepareItem()	Same as call in the line below.
14	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
13	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
12	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/components/com_k2/views/itemlist/view.html.php:691
11	K2ViewItemlist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/itemlist.php:49
8	K2ControllerItemlist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

Status	Duration
Starting	0.14 ms
checking permissions	0.01 ms
Opening tables	0.10 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.04 ms
Optimizing	0.03 ms
Statistics	0.19 ms
Preparing	0.05 ms
Executing	0.01 ms
Sending data	0.12 ms
End of update loop	0.01 ms
Query end	0.03 ms
Commit	0.02 ms
closing tables	0.01 ms
Unlocking tables	0.02 ms
closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.03 ms

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

Status	Duration
Starting	0.30 ms
checking permissions	0.01 ms
Opening tables	0.25 ms
After opening tables	0.02 ms
System lock	0.05 ms
table lock	0.02 ms
init	0.12 ms
Optimizing	0.07 ms
Statistics	0.63 ms
Preparing	0.11 ms
Creating tmp table	0.21 ms
Sorting result	0.04 ms
Executing	0.24 ms
Sending data	0.73 ms
Creating sort index	0.12 ms
Removing tmp table	0.65 ms
Creating sort index	0.04 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.03 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.04 ms
Reset for next command	0.02 ms

Status	Duration
Starting	0.18 ms
checking permissions	0.03 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.04 ms
Optimizing	0.03 ms
Statistics	0.03 ms
Preparing	0.01 ms
Executing	0.03 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ref	PRIMARY,published,newsfeeds	published	1	const	22	Using index condition; Using where; Using filesort
1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	swp_db.m.id	1	Using where; Using index
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	swp_db.m.module,const	1	Using index condition; Using where

#	Caller	File and line number
29	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1773
28	JDatabaseDriver->loadRow()	JROOT/plugins/content/sigplus/core/core.php:3081
27	SigPlusNovoCore->getGalleryHTML()	JROOT/modules/mod_sigplus/mod_sigplus.php:78
26	include JROOT/modules/mod_sigplus/mod_sigplus.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
25	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
24	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/plugins/content/loadmodule/loadmodule.php:175
23	PlgContentLoadmodule->_load()	JROOT/plugins/content/loadmodule/loadmodule.php:81
22	PlgContentLoadmodule->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
21	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
20	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
19	JHtmlContent::prepare()	Same as call in the line below.
18	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
17	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
16	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/templates/swp/html/com_k2/generic.php:16
15	include JROOT/templates/swp/html/com_k2/generic.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
13	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/administrator/components/com_k2/views/view.php:35
12	K2View->display()	JROOT/components/com_k2/views/itemlist/view.html.php:1460
11	K2ViewItemlist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/itemlist.php:49
8	K2ControllerItemlist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

#	Caller	File and line number
30	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver/mysqli.php:837
29	JDatabaseDriverMysqli->transactionStart()	JROOT/plugins/content/sigplus/core/core.php:1063
28	SigPlusNovoGalleryBase->update()	JROOT/plugins/content/sigplus/core/core.php:3089
27	SigPlusNovoCore->getGalleryHTML()	JROOT/modules/mod_sigplus/mod_sigplus.php:78
26	include JROOT/modules/mod_sigplus/mod_sigplus.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
25	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
24	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/plugins/content/loadmodule/loadmodule.php:175
23	PlgContentLoadmodule->_load()	JROOT/plugins/content/loadmodule/loadmodule.php:81
22	PlgContentLoadmodule->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
21	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
20	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
19	JHtmlContent::prepare()	Same as call in the line below.
18	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
17	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
16	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/templates/swp/html/com_k2/generic.php:16
15	include JROOT/templates/swp/html/com_k2/generic.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
13	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/administrator/components/com_k2/views/view.php:35
12	K2View->display()	JROOT/components/com_k2/views/itemlist/view.html.php:1460
11	K2ViewItemlist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/itemlist.php:49
8	K2ControllerItemlist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	h	ref	PRIMARY,eygea_FK_sigplus_hierarchy_descendant,eygea_IX_sigplus_hierarchy_depthnum	PRIMARY	4	const	1	Using where
1	PRIMARY	f	eq_ref	PRIMARY	PRIMARY	4	swp_db.h.descendantid	1	Using index
1	PRIMARY	i	ref	eygea_FK_sigplus_image_folder	eygea_FK_sigplus_image_folder	5	swp_db.h.descendantid	1	Using where
2	MATERIALIZED	v	ref	PRIMARY,eygea_FK_sigplus_imageview_view	eygea_FK_sigplus_imageview_view	4	const	3	Using index

#	Caller	File and line number
33	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1811
32	JDatabaseDriver->loadRowList()	JROOT/plugins/content/sigplus/core/core.php:1807
31	SigPlusNovoLocalBase->getMissingImageViews()	JROOT/plugins/content/sigplus/core/core.php:1894
30	SigPlusNovoLocalGallery->populateFolderViews()	JROOT/plugins/content/sigplus/core/core.php:1945
29	SigPlusNovoLocalGallery->populate()	JROOT/plugins/content/sigplus/core/core.php:1065
28	SigPlusNovoGalleryBase->update()	JROOT/plugins/content/sigplus/core/core.php:3089
27	SigPlusNovoCore->getGalleryHTML()	JROOT/modules/mod_sigplus/mod_sigplus.php:78
26	include JROOT/modules/mod_sigplus/mod_sigplus.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
25	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
24	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/plugins/content/loadmodule/loadmodule.php:175
23	PlgContentLoadmodule->_load()	JROOT/plugins/content/loadmodule/loadmodule.php:81
22	PlgContentLoadmodule->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
21	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
20	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
19	JHtmlContent::prepare()	Same as call in the line below.
18	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
17	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
16	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/templates/swp/html/com_k2/generic.php:16
15	include JROOT/templates/swp/html/com_k2/generic.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
13	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/administrator/components/com_k2/views/view.php:35
12	K2View->display()	JROOT/components/com_k2/views/itemlist/view.html.php:1460
11	K2ViewItemlist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/itemlist.php:49
8	K2ControllerItemlist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

#	Caller	File and line number
30	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver/mysqli.php:777
29	JDatabaseDriverMysqli->transactionCommit()	JROOT/plugins/content/sigplus/core/core.php:1071
28	SigPlusNovoGalleryBase->update()	JROOT/plugins/content/sigplus/core/core.php:3089
27	SigPlusNovoCore->getGalleryHTML()	JROOT/modules/mod_sigplus/mod_sigplus.php:78
26	include JROOT/modules/mod_sigplus/mod_sigplus.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
25	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
24	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/plugins/content/loadmodule/loadmodule.php:175
23	PlgContentLoadmodule->_load()	JROOT/plugins/content/loadmodule/loadmodule.php:81
22	PlgContentLoadmodule->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
21	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
20	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
19	JHtmlContent::prepare()	Same as call in the line below.
18	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
17	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
16	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/templates/swp/html/com_k2/generic.php:16
15	include JROOT/templates/swp/html/com_k2/generic.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
13	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/administrator/components/com_k2/views/view.php:35
12	K2View->display()	JROOT/components/com_k2/views/itemlist/view.html.php:1460
11	K2ViewItemlist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/itemlist.php:49
8	K2ControllerItemlist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	a	const	PRIMARY,folderurl	folderurl	769	const	1	Using index; Using temporary; Using filesort
1	PRIMARY	h	ref	PRIMARY,eygea_FK_sigplus_hierarchy_descendant,eygea_IX_sigplus_hierarchy_depthnum	PRIMARY	4	const	1	Using where
1	PRIMARY	f	eq_ref	PRIMARY	PRIMARY	4	swp_db.h.descendantid	1	Using index
1	PRIMARY	i	ref	PRIMARY,eygea_FK_sigplus_image_folder	eygea_FK_sigplus_image_folder	5	swp_db.h.descendantid	1
1	PRIMARY	v	eq_ref	PRIMARY,eygea_FK_sigplus_imageview_view	PRIMARY	8	swp_db.i.imageid,const	1
1	PRIMARY	c	eq_ref	PRIMARY,eygea_FK_sigplus_caption_language,eygea_FK_sigplus_caption_country	PRIMARY	8	swp_db.i.imageid,const,const	1
6	DEPENDENT SUBQUERY	p	index	PRIMARY,eygea_FK_sigplus_foldercaption_language,eygea_FK_sigplus_foldercaption_country	eygea_IX_sigplus_foldercaption_priority	2	NULL	1	Using where
5	DEPENDENT SUBQUERY	mp	const	PRIMARY,propertyname	propertyname	257	const	1	Using index
5	DEPENDENT SUBQUERY	md	eq_ref	PRIMARY,eygea_FK_sigplus_data_property	PRIMARY	8	swp_db.i.imageid,const	1
4	DEPENDENT SUBQUERY	p	index	PRIMARY,eygea_FK_sigplus_foldercaption_language,eygea_FK_sigplus_foldercaption_country	eygea_IX_sigplus_foldercaption_priority	2	NULL	1	Using where
3	DEPENDENT SUBQUERY	mp	const	PRIMARY,propertyname	propertyname	257	const	1	Using index
3	DEPENDENT SUBQUERY	md	eq_ref	PRIMARY,eygea_FK_sigplus_data_property	PRIMARY	8	swp_db.i.imageid,const	1
2	DEPENDENT SUBQUERY	mp	const	PRIMARY,propertyname	propertyname	257	const	1	Using index
2	DEPENDENT SUBQUERY	md	eq_ref	PRIMARY,eygea_FK_sigplus_data_property	PRIMARY	8	swp_db.i.imageid,const	1

Status	Duration
Starting	0.81 ms
checking permissions	0.02 ms
Opening tables	0.43 ms
After opening tables	0.10 ms
System lock	0.13 ms
table lock	0.01 ms
init	0.17 ms
Optimizing	0.06 ms
Statistics	0.56 ms
Preparing	0.02 ms
Unlocking tables	0.01 ms
Preparing	0.07 ms
Optimizing	0.03 ms
Statistics	0.23 ms
Preparing	0.05 ms
Sorting result	0.03 ms
Optimizing	0.05 ms
Statistics	1.20 ms
Preparing	0.06 ms
Optimizing	0.06 ms
Statistics	0.18 ms
Preparing	0.05 ms
Sorting result	0.03 ms
Optimizing	0.03 ms
Statistics	0.10 ms
Preparing	0.04 ms
Optimizing	0.02 ms
Statistics	0.09 ms
Preparing	0.05 ms
Creating tmp table	0.26 ms
Sorting result	0.03 ms
Executing	0.01 ms
Sending data	0.93 ms
Removing tmp table	0.02 ms
Sending data	0.01 ms
Executing	0.01 ms
Sending data	0.07 ms
Removing tmp table	0.01 ms
Sending data	0.01 ms
Executing	0.01 ms
Sending data	1.27 ms
Removing tmp table	0.62 ms
Sending data	0.01 ms
Executing	0.01 ms
Sending data	0.09 ms
Removing tmp table	0.01 ms
Sending data	0.01 ms
Executing	0.00 ms
Sending data	0.03 ms
Removing tmp table	0.01 ms
Sending data	0.01 ms
Executing	0.01 ms
Sending data	0.15 ms
Executing	0.01 ms
Sending data	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
Executing	0.01 ms
Sending data	0.02 ms
Executing	0.01 ms
Sending data	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
Executing	0.00 ms
Sending data	0.02 ms
Executing	0.01 ms
Sending data	0.01 ms
Executing	0.01 ms
Sending data	0.02 ms
Creating sort index	3.15 ms
Removing tmp table	1.15 ms
Creating sort index	0.16 ms
End of update loop	0.23 ms
Query end	0.02 ms
Commit	0.01 ms
closing tables	0.08 ms
Unlocking tables	0.01 ms
closing tables	0.04 ms
Starting cleanup	0.01 ms
Freeing items	0.06 ms
Updating status	0.04 ms
Reset for next command	0.24 ms

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c	system	PRIMARY,category,published,access,trash	NO INDEX KEY COULD BE USED	NULL	NULL	1
1	SIMPLE	i	range	catid,idx_item	idx_item	7	NULL	61	Using index condition; Using where; Using filesort

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	xref	ALL	tagID,itemID	NO INDEX KEY COULD BE USED	NULL	NULL	429	Using where
1	SIMPLE	tag	eq_ref	PRIMARY,published	PRIMARY	4	swp_db.xref.tagID	1	Using where