Gibson 1921 A2 Mandolin (Code: 64574)

Quantity in stock: 1

This Gibson A2 is a very fine player's instrument built in 1921; that seen some wear and tear but is in really solid structural condition.The tone of this A2 is sweet in the middle with a pretty dry low end like a vintage oval-hole should have.

Top Acoustic Mando and Uke Top Woods : Adirondack Spruce

Mandolin Style Mandolin Body Types : A Style with Oval Hole

Request Info

This Gibson A2 is a very fine player's instrument built in 1921. The third digit of the serial number is most difficult to read as the label is a bit faded and a touch worn, but looking through the archives, 64574 seemed to be most likely. It certainly has seen some wear and tear, but thanks to great work by a pair of wonderful luthiers, it is in really solid structural condition and is very comfortable to play. The Sheraton brown finish still has some sheen to it even with the wear from picking follow-through and patches around the edges.

There have been some repairs and improvements done to this instrument over the years to keep it running smoothly. There was a crack in the back that was fairly recently cleated by an excellent luthier although a couple small filled-in holes from an earlier repair remain. They don't distract the eye, and aren't unattractive per se, but they are visible. An updated adjustable bridge with bone crowned saddles has also been fitted for the mando, and there was some recent fret-work done where the small Gibson frets were replaced with larger more comfortable contemporary fret-wire. All the recent work was done by very skilled and highly regarded luthiers in the Southern Vermont region.

The tone of this A2 is sweet in the middle with a pretty dry low end like a vintage oval-hole should have. It isn't too loud, but it has enough presence to make itself known, and the wide nut and shorter scale make for a really nice, slinky feeling instrument with enough real estate for larger fingers!

Hardshell Case Included (Vintage, 1940s)

Available at Maple Leaf Music in Brattleboro, Vermont

Request More Information

Accepted Payment Methods

All major credit cards issued in the United States
Please verify availability before payment via (802) 254-5559 or [email protected]. Make payments to

for customers in the United States ONLY.
Certified bank checks and money orders *
Personal checks (with necessary shipping delay) *
Cash

Shipping Policy

Ships from Brattleboro, VT

Please contact us by clicking "ask a question" above to request a shipping quote or call (802)254-5559 for the lowest and most appropriate shipping rate available for your instrument, location and availability. We do ship internationally to certain countries, so please contact us.

Return Policy

Maple Leaf Music Co. has a 24-hour approval period after which time if the customer decides to return the item it must be in the original condition it was shipped and in the original packaging. No playing wear or signs of use should be detected. The customer must contact Maple Leaf Music prior to returning their instrument or the package will be refused. The customer is responsible for all shipping charges to and from if they return the instrument. There is a 4% restock fee if a credit card or PayPal was used as payment.*

* Payment with a certified bank check, personal check, and money order does not incur a restocking fee.

In Store Purchases

There is no approval period if you purchase an instrument at the shop (because you’ve seen it, played it and asked all the right questions of our knowledgeable staff), but be assured that if you buy an instrument or other product and are dissatisfied for any reason, we offer store credit for all returns up to 7 days after the purchase with a receipt. No monetary refunds.

Available for local pickup at Maple Leaf Music, 23 Elliot St. Brattleboro, VT 05301

Care and Feeding of a Solid Wood Instrument

Any instrument with solid woods requires the owner to control the humidity and temperature that instrument will be kept in. As a general rule of thumb, a solid wood instrument wants to live in an environment you would be comfortable in.

For the Dry Months

We recommend that you use two humidifiers in your case, one inside the sound hole and one in the space by the headstock.

We sell the Oasis brand humidification products as well as Dampits for instruments with smaller soundholes.

Signs of dryness include:

Depression of the top
Very low string action
String buzz
Sharp frets along the edge of the fingerboard

If any of these occur your instrument is too dry.

While the guitar company will warranty your new guitar for defects in manufacture, they specifically state in all the warranty literature that cracking or any other shrinking due to dryness is not covered.

For the Wet Months

It is as easy to over humidify a guitar as it is to under humidify and the consequences are just as dire. If you keep your house humidified, you probably don‘t need case humidifiers.

Signs of too much humidity include:

Action (String Height) is uncomfortable to play
Frets have discolored or turned green
Condensation on the top
The top is bellied up like and arch top guitar

To prevent humidity issues in either direction, please invest in a hygrometer. You want the levels to be around 45-50% moisture and this little tool will tell you where you are. Oasis makes a good one to go along with its’ humidifiers. Please inquire if you have questions concerning any instrument purchased at Maple Leaf Music.

Joomla! Debug Console

Session

Profile Information

Memory Usage

Database Queries

70 Queries Logged 21.0 ms

7 duplicate found!

4 duplicates: #41 #47 #49 #51

3 duplicates: #56 #58 #63

Query Time: 0.35 ms Query memory: 0.014 MB Memory before query: 4.234 MB Rows returned: 0

SELECT `data`

  FROM `myme2_session`

  WHERE `session_id` = 'de94378afcb47e57431b795eda67dffc'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	myme2_session	const	PRIMARY	PRIMARY	202	const	1

Profile

Status	Duration
starting	0.0 ms
Waiting for query cache lock	0.0 ms
checking query cache for query	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
System lock	0.0 ms
Waiting for query cache lock	0.0 ms
init	0.0 ms
optimizing	0.0 ms
statistics	0.1 ms
preparing	0.0 ms
executing	0.0 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
Waiting for query cache lock	0.0 ms
freeing items	0.0 ms
Waiting for query cache lock	0.0 ms
freeing items	0.0 ms
storing result in query cache	0.1 ms
logging slow query	0.0 ms
cleaning up	0.0 ms

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:37

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.20 ms After last query: 1.70 ms Query memory: 0.011 MB Memory before query: 4.533 MB Rows returned: 0

SELECT `session_id`

  FROM `myme2_session`

  WHERE `session_id` = 'de94378afcb47e57431b795eda67dffc' 
  LIMIT 0, 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	myme2_session	const	PRIMARY	PRIMARY	202	const	1	Using index

Profile

Status	Duration
starting	0.0 ms
Waiting for query cache lock	0.0 ms
checking query cache for query	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
System lock	0.0 ms
Waiting for query cache lock	0.0 ms
init	0.0 ms
optimizing	0.0 ms
statistics	0.0 ms
preparing	0.0 ms
executing	0.0 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
Waiting for query cache lock	0.0 ms
freeing items	0.0 ms
Waiting for query cache lock	0.0 ms
freeing items	0.0 ms
storing result in query cache	0.0 ms
logging slow query	0.0 ms
cleaning up	0.0 ms

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:37

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.25 ms After last query: 0.14 ms Query memory: 0.009 MB Memory before query: 4.544 MB

INSERT INTO `myme2_session`
(`session_id`, `client_id`, `time`) 
  VALUES 
('de94378afcb47e57431b795eda67dffc', 0, '1435808450')

Explain

EXPLAIN not possible on query: INSERT INTO `myme2_session` (`session_id`, `client_id`, `time`) VALUES ('de94378afcb47e57431b795eda67dffc', 0, '1435808450')

Profile

Status	Duration
starting	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
System lock	0.0 ms
init	0.0 ms
update	0.1 ms
Waiting for query cache lock	0.0 ms
update	0.1 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
logging slow query	0.0 ms
cleaning up	0.0 ms

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:37

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.08 ms After last query: 3.96 ms Query memory: 0.013 MB Memory before query: 5.402 MB Rows returned: 1

SELECT b.id

  FROM myme2_usergroups AS a

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

  WHERE a.id = 1

Explain

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	index	idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	8	NULL	10	Using index

Profile

Status	Duration
starting	0.0 ms
Waiting for query cache lock	0.0 ms
checking query cache for query	0.0 ms
checking privileges on cached	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
sending cached result to clien	0.0 ms
logging slow query	0.0 ms
cleaning up	0.0 ms

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:573

JROOT/libraries/cms/application/site.php:209

JROOT/libraries/cms/application/cms.php:252

JROOT/index.php:40

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.07 ms After last query: 0.46 ms Query memory: 0.012 MB Memory before query: 5.492 MB Rows returned: 4

SELECT id, rules

  FROM `myme2_viewlevels`

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	myme2_viewlevels	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	4

Profile

Status	Duration
starting	0.0 ms
Waiting for query cache lock	0.0 ms
checking query cache for query	0.0 ms
checking privileges on cached	0.0 ms
checking permissions	0.0 ms
sending cached result to clien	0.0 ms
logging slow query	0.0 ms
cleaning up	0.0 ms

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:573

JROOT/libraries/cms/application/site.php:209

JROOT/libraries/cms/application/cms.php:252

JROOT/index.php:40

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 1.22 ms After last query: 10.69 ms Query memory: 0.013 MB Memory before query: 7.869 MB Rows returned: 0

SELECT `query`

  FROM `myme2_admintools_wafexceptions`

  WHERE (`option` IS NULL OR `option` = '') 
  AND (`view` IS NULL OR `view` = '')

  GROUP BY `query`

  ORDER BY `query` ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

Profile

Status	Duration
starting	0.0 ms
Waiting for query cache lock	0.0 ms
checking query cache for query	0.0 ms
checking privileges on cached	0.0 ms
checking permissions	0.0 ms
sending cached result to clien	0.0 ms
logging slow query	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT/plugins/system/admintools/admintools/main.php:486

JROOT/plugins/system/admintools/admintools/main.php:96

JROOT/libraries/cms/plugin/helper.php:255

JROOT/libraries/cms/plugin/helper.php:170

JROOT/libraries/cms/application/cms.php:653

JROOT/libraries/cms/application/site.php:647

JROOT/libraries/cms/application/site.php:209

JROOT/libraries/cms/application/cms.php:252

JROOT/index.php:40

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.09 ms After last query: 0.84 ms Query memory: 0.017 MB Memory before query: 7.995 MB Rows returned: 1

SELECT `value`

  FROM `myme2_admintools_storage`

  WHERE `key` = 'cparams'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	myme2_admintools_storage	const	PRIMARY	PRIMARY	767	const	1

Profile

Status	Duration
starting	0.0 ms
Waiting for query cache lock	0.0 ms
checking query cache for query	0.0 ms
checking privileges on cached	0.0 ms
checking permissions	0.0 ms
sending cached result to clien	0.0 ms
logging slow query	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT/administrator/components/com_admintools/models/storage.php:84

JROOT/administrator/components/com_admintools/models/storage.php:49

JROOT/plugins/system/admintools/feature/geoblock.php:21

JROOT/plugins/system/admintools/admintools/main.php:352

JROOT/plugins/system/admintools/admintools/main.php:99

JROOT/libraries/cms/plugin/helper.php:255

JROOT/libraries/cms/plugin/helper.php:170

JROOT/libraries/cms/application/cms.php:653

JROOT/libraries/cms/application/site.php:647

JROOT/libraries/cms/application/site.php:209

JROOT/libraries/cms/application/cms.php:252

JROOT/index.php:40

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.33 ms After last query: 11.64 ms Query memory: 0.012 MB Memory before query: 9.923 MB Rows returned: 1

SELECT `enabled`

  FROM `myme2_extensions`

  WHERE `element` = 'com_akeeba' 
  AND `type` = 'component'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	myme2_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	102	const	1	Using where

Profile

Status	Duration
starting	0.0 ms
Waiting for query cache lock	0.0 ms
checking query cache for query	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
System lock	0.0 ms
Waiting for query cache lock	0.0 ms
init	0.0 ms
optimizing	0.0 ms
statistics	0.1 ms
preparing	0.0 ms
executing	0.0 ms
Sending data	0.0 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
Waiting for query cache lock	0.0 ms
freeing items	0.0 ms
Waiting for query cache lock	0.0 ms
freeing items	0.0 ms
storing result in query cache	0.1 ms
logging slow query	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT/plugins/system/backuponupdate/backuponupdate.php:61

JROOT/libraries/cms/plugin/helper.php:230

JROOT/libraries/cms/plugin/helper.php:170

JROOT/libraries/cms/application/cms.php:653

JROOT/libraries/cms/application/site.php:647

JROOT/libraries/cms/application/site.php:209

JROOT/libraries/cms/application/cms.php:252

JROOT/index.php:40

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.46 ms After last query: 13.29 ms Query memory: 0.017 MB Memory before query: 12.493 MB Rows returned: 1

SHOW VARIABLES LIKE "collation_database"

Explain

EXPLAIN not possible on query: SHOW VARIABLES LIKE "collation_database"

Profile

Status	Duration
starting	0.0 ms
Opening tables	0.0 ms
System lock	0.0 ms
init	0.0 ms
optimizing	0.0 ms
statistics	0.0 ms
preparing	0.0 ms
executing	0.2 ms
Sending data	0.0 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
removing tmp table	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
logging slow query	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT/plugins/system/admintools/feature/utf8mb4.php:28

JROOT/plugins/system/admintools/admintools/main.php:534

JROOT/plugins/system/admintools/admintools/main.php:124

JROOT/libraries/joomla/event/event.php:69

JROOT/libraries/joomla/event/dispatcher.php:160

JROOT/libraries/joomla/application/base.php:83

JROOT/libraries/cms/application/cms.php:654

JROOT/libraries/cms/application/site.php:647

JROOT/libraries/cms/application/site.php:209

JROOT/libraries/cms/application/cms.php:252

JROOT/index.php:40

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.30 ms After last query: 0.32 ms Query memory: 0.016 MB Memory before query: 12.530 MB Rows returned: 0

SELECT *

  FROM `myme2_admintools_ipautoban`

  WHERE `ip` = '204.236.235.245'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

Profile

Status	Duration
starting	0.1 ms
Waiting for query cache lock	0.0 ms
checking query cache for query	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
System lock	0.0 ms
Waiting for query cache lock	0.0 ms
init	0.0 ms
optimizing	0.0 ms
statistics	0.0 ms
preparing	0.0 ms
executing	0.0 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
Waiting for query cache lock	0.0 ms
freeing items	0.0 ms
Waiting for query cache lock	0.0 ms
freeing items	0.0 ms
storing result in query cache	0.1 ms
logging slow query	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT/plugins/system/admintools/feature/autoipfiltering.php:32

JROOT/plugins/system/admintools/admintools/main.php:534

JROOT/plugins/system/admintools/admintools/main.php:124

JROOT/libraries/joomla/event/event.php:69

JROOT/libraries/joomla/event/dispatcher.php:160

JROOT/libraries/joomla/application/base.php:83

JROOT/libraries/cms/application/cms.php:654

JROOT/libraries/cms/application/site.php:647

JROOT/libraries/cms/application/site.php:209

JROOT/libraries/cms/application/cms.php:252

JROOT/index.php:40

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.06 ms After last query: 0.11 ms Query memory: 0.016 MB Memory before query: 12.545 MB Rows returned: 1

SELECT `ip`

  FROM `myme2_admintools_ipblock`

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	myme2_admintools_ipblock	system	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1

Profile

Status	Duration
starting	0.0 ms
Waiting for query cache lock	0.0 ms
checking query cache for query	0.0 ms
checking privileges on cached	0.0 ms
checking permissions	0.0 ms
sending cached result to clien	0.0 ms
logging slow query	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT/plugins/system/admintools/feature/ipblacklist.php:41

JROOT/plugins/system/admintools/admintools/main.php:534

JROOT/plugins/system/admintools/admintools/main.php:124

JROOT/libraries/joomla/event/event.php:69

JROOT/libraries/joomla/event/dispatcher.php:160

JROOT/libraries/joomla/application/base.php:83

JROOT/libraries/cms/application/cms.php:654

JROOT/libraries/cms/application/site.php:647

JROOT/libraries/cms/application/site.php:209

JROOT/libraries/cms/application/cms.php:252

JROOT/index.php:40

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.06 ms After last query: 0.21 ms Query memory: 0.016 MB Memory before query: 12.566 MB Rows returned: 0

SELECT *

  FROM `myme2_admintools_wafblacklists`

  WHERE `verb` IN('','GET') 
  AND `option` IN('') 
  AND `view` IN('') 
  AND `task` IN('')

  GROUP BY `query`

  ORDER BY `query` ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

Profile

Status	Duration
starting	0.0 ms
Waiting for query cache lock	0.0 ms
checking query cache for query	0.0 ms
checking privileges on cached	0.0 ms
checking permissions	0.0 ms
sending cached result to clien	0.0 ms
logging slow query	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT/plugins/system/admintools/feature/wafblacklist.php:65

JROOT/plugins/system/admintools/admintools/main.php:534

JROOT/plugins/system/admintools/admintools/main.php:124

JROOT/libraries/joomla/event/event.php:69

JROOT/libraries/joomla/event/dispatcher.php:160

JROOT/libraries/joomla/application/base.php:83

JROOT/libraries/cms/application/cms.php:654

JROOT/libraries/cms/application/site.php:647

JROOT/libraries/cms/application/site.php:209

JROOT/libraries/cms/application/cms.php:252

JROOT/index.php:40

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.09 ms After last query: 0.21 ms Query memory: 0.016 MB Memory before query: 12.579 MB Rows returned: 0

SELECT `word`

  FROM `myme2_admintools_badwords`

  GROUP BY `word`

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	myme2_admintools_badwords	system	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	0	const row not found

Profile

Status	Duration
starting	0.0 ms
Waiting for query cache lock	0.0 ms
checking query cache for query	0.0 ms
checking privileges on cached	0.0 ms
checking permissions	0.0 ms
sending cached result to clien	0.0 ms
logging slow query	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT/plugins/system/admintools/feature/badwords.php:48

JROOT/plugins/system/admintools/admintools/main.php:534

JROOT/plugins/system/admintools/admintools/main.php:124

JROOT/libraries/joomla/event/event.php:69

JROOT/libraries/joomla/event/dispatcher.php:160

JROOT/libraries/joomla/application/base.php:83

JROOT/libraries/cms/application/cms.php:654

JROOT/libraries/cms/application/site.php:647

JROOT/libraries/cms/application/site.php:209

JROOT/libraries/cms/application/cms.php:252

JROOT/index.php:40

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.39 ms After last query: 0.31 ms Query memory: 0.016 MB Memory before query: 12.599 MB Rows returned: 0

SELECT `source`,`keepurlparams`

  FROM `myme2_admintools_redirects`

  WHERE ((`dest` = 'shop/mandolins/gibson-1921-a2-mandolin-64574') OR (`dest` = 'shop/mandolins/gibson-1921-a2-mandolin-64574') OR ('shop/mandolins/gibson-1921-a2-mandolin-64574' LIKE `dest`)) 
  AND `published` = '1'

  ORDER BY `ordering` DESC 
  LIMIT 0, 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	myme2_admintools_redirects	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	443	Using where; Using filesort

Profile

Status	Duration
starting	0.0 ms
Waiting for query cache lock	0.0 ms
checking query cache for query	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
System lock	0.0 ms
Waiting for query cache lock	0.0 ms
init	0.0 ms
optimizing	0.0 ms
statistics	0.0 ms
preparing	0.0 ms
executing	0.0 ms
Sorting result	0.2 ms
Sending data	0.0 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
Waiting for query cache lock	0.0 ms
freeing items	0.0 ms
Waiting for query cache lock	0.0 ms
freeing items	0.0 ms
storing result in query cache	0.0 ms
logging slow query	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT/plugins/system/admintools/feature/urlredir.php:89

JROOT/plugins/system/admintools/admintools/main.php:534

JROOT/plugins/system/admintools/admintools/main.php:124

JROOT/libraries/joomla/event/event.php:69

JROOT/libraries/joomla/event/dispatcher.php:160

JROOT/libraries/joomla/application/base.php:83

JROOT/libraries/cms/application/cms.php:654

JROOT/libraries/cms/application/site.php:647

JROOT/libraries/cms/application/site.php:209

JROOT/libraries/cms/application/cms.php:252

JROOT/index.php:40

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 1.00 ms After last query: 5.33 ms Query memory: 0.019 MB Memory before query: 13.603 MB Rows returned: 67

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 myme2_menu AS m

  LEFT JOIN myme2_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

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	101	Using where; Using filesort
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	mnelson_joomlamaple.m.component_id	1

Profile

Status	Duration
starting	0.0 ms
Waiting for query cache lock	0.0 ms
checking query cache for query	0.1 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
System lock	0.0 ms
Waiting for query cache lock	0.0 ms
init	0.0 ms
optimizing	0.0 ms
statistics	0.0 ms
preparing	0.0 ms
executing	0.0 ms
Sorting result	0.2 ms
Sending data	0.1 ms
Waiting for query cache lock	0.0 ms
Sending data	0.1 ms
Waiting for query cache lock	0.0 ms
Sending data	0.2 ms
Waiting for query cache lock	0.0 ms
Sending data	0.0 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
Waiting for query cache lock	0.0 ms
freeing items	0.0 ms
Waiting for query cache lock	0.0 ms
freeing items	0.0 ms
storing result in query cache	0.1 ms
logging slow query	0.0 ms
cleaning up	0.0 ms

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:747

JROOT/libraries/cms/application/site.php:215

JROOT/libraries/cms/application/cms.php:252

JROOT/index.php:40

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 2.50 ms After last query: 12.41 ms Query memory: 0.023 MB Memory before query: 16.132 MB Rows returned: 140

SHOW FULL COLUMNS 
  FROM `myme2_jshopping_config`

Explain

EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `myme2_jshopping_config`

Profile

Status	Duration
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
Sending data	0.3 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
removing tmp table	0.2 ms
closing tables	0.0 ms
freeing items	0.0 ms
logging slow query	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT/libraries/joomla/table/table.php:241

JROOT/libraries/joomla/table/table.php:162

JROOT/components/com_jshopping/tables/config.php:15

JROOT/components/com_jshopping/lib/factory.php:26

JROOT/components/com_jshopping/lib/factory.php:227

JROOT/components/com_jshopping/lib/factory.php:250

JROOT/components/com_jshopping/router.php:207

JROOT/libraries/cms/component/router/legacy.php:104

JROOT/libraries/cms/router/site.php:395

JROOT/libraries/cms/router/router.php:479

JROOT/libraries/cms/router/router.php:234

JROOT/libraries/cms/router/site.php:118

JROOT/libraries/cms/application/cms.php:1089

JROOT/libraries/cms/application/site.php:747

JROOT/libraries/cms/application/site.php:215

JROOT/libraries/cms/application/cms.php:252

JROOT/index.php:40

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.16 ms After last query: 2.25 ms Query memory: 0.020 MB Memory before query: 16.616 MB Rows returned: 1

SELECT *

  FROM myme2_jshopping_config

  WHERE `id` = '1'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	myme2_jshopping_config	system	PRIMARY	NO INDEX KEY COULD BE USED	NULL	NULL	1

Profile

Status	Duration
starting	0.0 ms
Waiting for query cache lock	0.0 ms
checking query cache for query	0.0 ms
checking privileges on cached	0.0 ms
checking permissions	0.0 ms
sending cached result to clien	0.0 ms
logging slow query	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT/libraries/joomla/table/table.php:728

JROOT/components/com_jshopping/lib/factory.php:30

JROOT/components/com_jshopping/lib/factory.php:227

JROOT/components/com_jshopping/lib/factory.php:250

JROOT/components/com_jshopping/router.php:207

JROOT/libraries/cms/component/router/legacy.php:104

JROOT/libraries/cms/router/site.php:395

JROOT/libraries/cms/router/router.php:479

JROOT/libraries/cms/router/router.php:234

JROOT/libraries/cms/router/site.php:118

JROOT/libraries/cms/application/cms.php:1089

JROOT/libraries/cms/application/site.php:747

JROOT/libraries/cms/application/site.php:215

JROOT/libraries/cms/application/cms.php:252

JROOT/index.php:40

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.51 ms After last query: 1.12 ms Query memory: 0.028 MB Memory before query: 16.721 MB Rows returned: 8

SHOW FULL COLUMNS 
  FROM `myme2_jshopping_currencies`

Explain

EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `myme2_jshopping_currencies`

Profile

Status	Duration
starting	0.0 ms
checking permissions	0.0 ms
Opening tables	0.2 ms
System lock	0.0 ms
init	0.0 ms
optimizing	0.0 ms
statistics	0.0 ms
preparing	0.0 ms
executing	0.0 ms
Opening tables	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
Sending data	0.0 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
removing tmp table	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
logging slow query	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT/libraries/joomla/table/table.php:241

JROOT/libraries/joomla/table/table.php:162

JROOT/components/com_jshopping/tables/currency.php:22

JROOT/libraries/joomla/table/table.php:305

JROOT/components/com_jshopping/lib/factory.php:682

JROOT/components/com_jshopping/lib/factory.php:630

JROOT/components/com_jshopping/tables/config.php:48

JROOT/components/com_jshopping/lib/factory.php:32

JROOT/components/com_jshopping/lib/factory.php:227

JROOT/components/com_jshopping/lib/factory.php:250

JROOT/components/com_jshopping/router.php:207

JROOT/libraries/cms/component/router/legacy.php:104

JROOT/libraries/cms/router/site.php:395

JROOT/libraries/cms/router/router.php:479

JROOT/libraries/cms/router/router.php:234

JROOT/libraries/cms/router/site.php:118

JROOT/libraries/cms/application/cms.php:1089

JROOT/libraries/cms/application/site.php:747

JROOT/libraries/cms/application/site.php:215

JROOT/libraries/cms/application/cms.php:252

JROOT/index.php:40

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.05 ms After last query: 0.13 ms Query memory: 0.022 MB Memory before query: 16.763 MB Rows returned: 2

SELECT currency_id, currency_name, currency_code, currency_code_iso, currency_value 
  FROM `myme2_jshopping_currencies` 
  WHERE currency_publish = '1' 
  ORDER BY currency_ordering

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	myme2_jshopping_currencies	ref	currency_publish	currency_publish	1	const	1	Using where; Using filesort

Profile

Status	Duration
starting	0.0 ms
Waiting for query cache lock	0.0 ms
checking query cache for query	0.0 ms
checking privileges on cached	0.0 ms
checking permissions	0.0 ms
sending cached result to clien	0.0 ms
logging slow query	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT/components/com_jshopping/tables/currency.php:30

JROOT/components/com_jshopping/lib/factory.php:631

JROOT/components/com_jshopping/tables/config.php:48

JROOT/components/com_jshopping/lib/factory.php:32

JROOT/components/com_jshopping/lib/factory.php:227

JROOT/components/com_jshopping/lib/factory.php:250

JROOT/components/com_jshopping/router.php:207

JROOT/libraries/cms/component/router/legacy.php:104

JROOT/libraries/cms/router/site.php:395

JROOT/libraries/cms/router/router.php:479

JROOT/libraries/cms/router/router.php:234

JROOT/libraries/cms/router/site.php:118

JROOT/libraries/cms/application/cms.php:1089

JROOT/libraries/cms/application/site.php:747

JROOT/libraries/cms/application/site.php:215

JROOT/libraries/cms/application/cms.php:252

JROOT/index.php:40

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.09 ms After last query: 0.44 ms Query memory: 0.016 MB Memory before query: 16.781 MB Rows returned: 376

select product_id as id, `alias_en-GB` as alias 
  from myme2_jshopping_products 
  where `alias_en-GB`!=''

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	myme2_jshopping_products	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	376	Using where

Profile

Status	Duration
starting	0.0 ms
Waiting for query cache lock	0.0 ms
checking query cache for query	0.0 ms
checking privileges on cached	0.0 ms
checking permissions	0.0 ms
sending cached result to clien	0.0 ms
logging slow query	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT/components/com_jshopping/lib/factory.php:358

JROOT/components/com_jshopping/router.php:268

JROOT/libraries/cms/component/router/legacy.php:104

JROOT/libraries/cms/router/site.php:395

JROOT/libraries/cms/router/router.php:479

JROOT/libraries/cms/router/router.php:234

JROOT/libraries/cms/router/site.php:118

JROOT/libraries/cms/application/cms.php:1089

JROOT/libraries/cms/application/site.php:747

JROOT/libraries/cms/application/site.php:215

JROOT/libraries/cms/application/cms.php:252

JROOT/index.php:40

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.43 ms After last query: 5.13 ms Query memory: 0.017 MB Memory before query: 17.325 MB

UPDATE `myme2_extensions`

  SET `params` = '{\"mediaversion\":\"a9c377121dd170325457442ac6a15686\"}'

  WHERE `type` = 'library' 
  AND `element` = 'joomla'

Explain

EXPLAIN not possible on query: UPDATE `myme2_extensions` SET `params` = '{\"mediaversion\":\"a9c377121dd170325457442ac6a15686\"}' WHERE `type` = 'library' AND `element` = 'joomla'

Profile

Status	Duration
starting	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
System lock	0.0 ms
init	0.1 ms
Updating	0.0 ms
end	0.0 ms
Waiting for query cache lock	0.0 ms
end	0.1 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
logging slow query	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT/libraries/cms/library/helper.php:119

JROOT/libraries/cms/version/version.php:228

JROOT/libraries/cms/version/version.php:187

JROOT/libraries/joomla/factory.php:736

JROOT/libraries/joomla/factory.php:216

JROOT/plugins/system/arktypography/arktypography.php:48

JROOT/libraries/joomla/event/event.php:69

JROOT/libraries/joomla/event/dispatcher.php:160

JROOT/libraries/joomla/application/base.php:83

JROOT/libraries/cms/application/cms.php:1098

JROOT/libraries/cms/application/site.php:747

JROOT/libraries/cms/application/site.php:215

JROOT/libraries/cms/application/cms.php:252

JROOT/index.php:40

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.10 ms After last query: 1.79 ms Query memory: 0.014 MB Memory before query: 17.744 MB Rows returned: 0

SELECT element,views,context,types,params

  FROM myme2_ark_editor_inline_views

  WHERE element = 'com_jshopping' 
  LIMIT 0, 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	myme2_ark_editor_inline_views	ref	PRIMARY	PRIMARY	152	const	1	Using where

Profile

Status	Duration
starting	0.0 ms
Waiting for query cache lock	0.0 ms
checking query cache for query	0.0 ms
checking privileges on cached	0.0 ms
checking permissions	0.0 ms
sending cached result to clien	0.0 ms
logging slow query	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT/plugins/system/inlinecontent/inlinecontent.php:61

JROOT/libraries/joomla/event/event.php:69

JROOT/libraries/joomla/event/dispatcher.php:160

JROOT/libraries/joomla/application/base.php:83

JROOT/libraries/cms/application/cms.php:1098

JROOT/libraries/cms/application/site.php:747

JROOT/libraries/cms/application/site.php:215

JROOT/libraries/cms/application/cms.php:252

JROOT/index.php:40

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.32 ms After last query: 0.74 ms Query memory: 0.014 MB Memory before query: 17.760 MB Rows returned: 1

SELECT params

  FROM myme2_extensions

  WHERE type ='component' 
  AND element ='com_arkeditor'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	myme2_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	102	const	1	Using where

Profile

Status	Duration
starting	0.0 ms
Waiting for query cache lock	0.0 ms
checking query cache for query	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
System lock	0.0 ms
Waiting for query cache lock	0.0 ms
init	0.0 ms
optimizing	0.0 ms
statistics	0.0 ms
preparing	0.0 ms
executing	0.0 ms
Sending data	0.0 ms
Waiting for query cache lock	0.0 ms
Sending data	0.0 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
Waiting for query cache lock	0.0 ms
freeing items	0.0 ms
Waiting for query cache lock	0.0 ms
freeing items	0.0 ms
storing result in query cache	0.0 ms
logging slow query	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT/plugins/system/arkbootstrap/arkbootstrap.php:55

JROOT/libraries/joomla/event/event.php:69

JROOT/libraries/joomla/event/dispatcher.php:160

JROOT/libraries/joomla/application/base.php:83

JROOT/libraries/cms/application/cms.php:1098

JROOT/libraries/cms/application/site.php:747

JROOT/libraries/cms/application/site.php:215

JROOT/libraries/cms/application/cms.php:252

JROOT/index.php:40

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.09 ms After last query: 0.83 ms Query memory: 0.025 MB Memory before query: 17.795 MB Rows returned: 55

select id,link 
  from myme2_menu 
  where `type`='component' 
  and published=1 
  and link like '%option=com_jshopping%' 
  and client_id=0 
  and (language='*' or language='en-GB') 
  and access IN (1,1)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	myme2_menu	ref	idx_client_id_parent_id_alias_language,idx_language	idx_client_id_parent_id_alias_language	1	const	102	Using where

Profile

Status	Duration
starting	0.0 ms
Waiting for query cache lock	0.0 ms
checking query cache for query	0.0 ms
checking privileges on cached	0.0 ms
checking permissions	0.0 ms
sending cached result to clien	0.0 ms
logging slow query	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT/components/com_jshopping/lib/shop_item_menu.php:130

JROOT/components/com_jshopping/lib/shop_item_menu.php:41

JROOT/components/com_jshopping/lib/shop_item_menu.php:35

JROOT/components/com_jshopping/router.php:16

JROOT/libraries/cms/component/router/legacy.php:68

JROOT/libraries/cms/router/site.php:483

JROOT/libraries/cms/router/site.php:452

JROOT/libraries/cms/router/router.php:280

JROOT/libraries/cms/router/site.php:134

JROOT/libraries/joomla/application/route.php:62

JROOT/plugins/system/sef/sef.php:45

JROOT/libraries/joomla/event/event.php:69

JROOT/libraries/joomla/event/dispatcher.php:160

JROOT/libraries/joomla/application/base.php:83

JROOT/libraries/cms/application/cms.php:1098

JROOT/libraries/cms/application/site.php:747

JROOT/libraries/cms/application/site.php:215

JROOT/libraries/cms/application/cms.php:252

JROOT/index.php:40

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.09 ms After last query: 0.72 ms Query memory: 0.023 MB Memory before query: 17.944 MB Rows returned: 25

select category_id as id, `alias_en-GB` as alias 
  from myme2_jshopping_categories 
  where `alias_en-GB`!=''

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	myme2_jshopping_categories	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	28	Using where

Profile

Status	Duration
starting	0.0 ms
Waiting for query cache lock	0.0 ms
checking query cache for query	0.0 ms
checking privileges on cached	0.0 ms
checking permissions	0.0 ms
sending cached result to clien	0.0 ms
logging slow query	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT/components/com_jshopping/lib/factory.php:324

JROOT/components/com_jshopping/router.php:67

JROOT/libraries/cms/component/router/legacy.php:68

JROOT/libraries/cms/router/site.php:483

JROOT/libraries/cms/router/site.php:452

JROOT/libraries/cms/router/router.php:280

JROOT/libraries/cms/router/site.php:134

JROOT/libraries/joomla/application/route.php:62

JROOT/plugins/system/sef/sef.php:45

JROOT/libraries/joomla/event/event.php:69

JROOT/libraries/joomla/event/dispatcher.php:160

JROOT/libraries/joomla/application/base.php:83

JROOT/libraries/cms/application/cms.php:1098

JROOT/libraries/cms/application/site.php:747

JROOT/libraries/cms/application/site.php:215

JROOT/libraries/cms/application/cms.php:252

JROOT/index.php:40

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.09 ms After last query: 3.38 ms Query memory: 0.013 MB Memory before query: 18.073 MB Rows returned: 1

select * 
  from myme2_jshopping_languages

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	myme2_jshopping_languages	system	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1

Profile

Status	Duration
starting	0.0 ms
Waiting for query cache lock	0.0 ms
checking query cache for query	0.0 ms
checking privileges on cached	0.0 ms
checking permissions	0.0 ms
sending cached result to clien	0.0 ms
logging slow query	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT/components/com_jshopping/lib/functions.php:274

JROOT/components/com_jshopping/loadparams.php:40

JROOT/components/com_jshopping/jshopping.php:16

JROOT/libraries/cms/component/helper.php:391

JROOT/libraries/cms/component/helper.php:371

JROOT/libraries/cms/application/site.php:191

JROOT/libraries/cms/application/site.php:230

JROOT/libraries/cms/application/cms.php:252

JROOT/index.php:40

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 1.45 ms After last query: 7.83 ms Query memory: 0.020 MB Memory before query: 19.892 MB Rows returned: 68

SHOW FULL COLUMNS 
  FROM `myme2_jshopping_products`

Explain

EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `myme2_jshopping_products`

Profile

Status	Duration
starting	0.0 ms
checking permissions	0.0 ms
Opening tables	0.2 ms
System lock	0.0 ms
init	0.0 ms
optimizing	0.0 ms
statistics	0.0 ms
preparing	0.0 ms
executing	0.0 ms
Opening tables	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
Sending data	0.1 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
removing tmp table	0.1 ms
closing tables	0.0 ms
freeing items	0.0 ms
logging slow query	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT/libraries/joomla/table/table.php:241

JROOT/libraries/joomla/table/table.php:162

JROOT/components/com_jshopping/tables/product.php:14

JROOT/libraries/joomla/table/table.php:305

JROOT/components/com_jshopping/lib/factory.php:682

JROOT/components/com_jshopping/controllers/product.php:45

JROOT/libraries/legacy/controller/legacy.php:728

JROOT/components/com_jshopping/jshopping.php:25

JROOT/libraries/cms/component/helper.php:391

JROOT/libraries/cms/component/helper.php:371

JROOT/libraries/cms/application/site.php:191

JROOT/libraries/cms/application/site.php:230

JROOT/libraries/cms/application/cms.php:252

JROOT/index.php:40

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.30 ms After last query: 0.65 ms Query memory: 0.015 MB Memory before query: 20.068 MB Rows returned: 1

SELECT *

  FROM myme2_jshopping_products

  WHERE `product_id` = '264'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	myme2_jshopping_products	const	PRIMARY	PRIMARY	4	const	1

Profile

Status	Duration
starting	0.0 ms
Waiting for query cache lock	0.0 ms
checking query cache for query	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
System lock	0.0 ms
Waiting for query cache lock	0.0 ms
init	0.0 ms
optimizing	0.0 ms
statistics	0.0 ms
preparing	0.0 ms
executing	0.0 ms
Sending data	0.0 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
Waiting for query cache lock	0.0 ms
freeing items	0.0 ms
Waiting for query cache lock	0.0 ms
freeing items	0.0 ms
storing result in query cache	0.0 ms
logging slow query	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT/libraries/joomla/table/table.php:728

JROOT/components/com_jshopping/controllers/product.php:46

JROOT/libraries/legacy/controller/legacy.php:728

JROOT/components/com_jshopping/jshopping.php:25

JROOT/libraries/cms/component/helper.php:391

JROOT/libraries/cms/component/helper.php:371

JROOT/libraries/cms/application/site.php:191

JROOT/libraries/cms/application/site.php:230

JROOT/libraries/cms/application/cms.php:252

JROOT/index.php:40

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.07 ms After last query: 0.19 ms Query memory: 0.015 MB Memory before query: 20.071 MB Rows returned: 2

SELECT * 
  FROM `myme2_jshopping_products_to_categories` 
  WHERE product_id='264'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	myme2_jshopping_products_to_categories	ref	PRIMARY,product_id,product_id_2	product_id_2	4	const	2	Using index

Profile

Status	Duration
starting	0.0 ms
Waiting for query cache lock	0.0 ms
checking query cache for query	0.0 ms
checking privileges on cached	0.0 ms
checking permissions	0.0 ms
sending cached result to clien	0.0 ms
logging slow query	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT/components/com_jshopping/tables/product.php:235

JROOT/components/com_jshopping/controllers/product.php:47

JROOT/libraries/legacy/controller/legacy.php:728

JROOT/components/com_jshopping/jshopping.php:25

JROOT/libraries/cms/component/helper.php:391

JROOT/libraries/cms/component/helper.php:371

JROOT/libraries/cms/application/site.php:191

JROOT/libraries/cms/application/site.php:230

JROOT/libraries/cms/application/cms.php:252

JROOT/index.php:40

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.46 ms After last query: 0.42 ms Query memory: 0.026 MB Memory before query: 20.136 MB Rows returned: 11

SHOW FULL COLUMNS 
  FROM `myme2_jshopping_products_extra_fields`

Explain

EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `myme2_jshopping_products_extra_fields`

Profile

Status	Duration
starting	0.0 ms
checking permissions	0.0 ms
Opening tables	0.1 ms
System lock	0.0 ms
init	0.0 ms
optimizing	0.0 ms
statistics	0.0 ms
preparing	0.0 ms
executing	0.0 ms
Opening tables	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
Sending data	0.0 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
removing tmp table	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
logging slow query	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT/libraries/joomla/table/table.php:241

JROOT/libraries/joomla/table/table.php:162

JROOT/components/com_jshopping/tables/productfield.php:16

JROOT/libraries/joomla/table/table.php:305

JROOT/components/com_jshopping/lib/factory.php:682

JROOT/components/com_jshopping/lib/factory.php:557

JROOT/components/com_jshopping/lib/functions.php:1097

JROOT/components/com_jshopping/lib/jtableauto.php:200

JROOT/components/com_jshopping/tables/product.php:766

JROOT/components/com_jshopping/tables/product.php:478

JROOT/components/com_jshopping/controllers/product.php:66

JROOT/libraries/legacy/controller/legacy.php:728

JROOT/components/com_jshopping/jshopping.php:25

JROOT/libraries/cms/component/helper.php:391

JROOT/libraries/cms/component/helper.php:371

JROOT/libraries/cms/application/site.php:191

JROOT/libraries/cms/application/site.php:230

JROOT/libraries/cms/application/cms.php:252

JROOT/index.php:40

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.10 ms After last query: 0.16 ms Query memory: 0.020 MB Memory before query: 20.183 MB Rows returned: 22

SELECT F.id, F.`name_en-GB` as name, F.`description_en-GB` as description, F.allcats, F.type, F.cats, F.ordering, F.`
  group`, G.`name_en-GB` as groupname, multilist 
  FROM `myme2_jshopping_products_extra_fields` as F 
  left join `myme2_jshopping_products_extra_field_groups` as G 
  on G.id=F.
  group 
  order by G.ordering, F.ordering

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	F	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	22	Using temporary; Using filesort
1	SIMPLE	G	eq_ref	PRIMARY	PRIMARY	4	mnelson_joomlamaple.F.group	1

Profile

Status	Duration
starting	0.0 ms
Waiting for query cache lock	0.0 ms
checking query cache for query	0.0 ms
checking privileges on cached	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
sending cached result to clien	0.0 ms
logging slow query	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT/components/com_jshopping/tables/productfield.php:50

JROOT/components/com_jshopping/lib/factory.php:558

JROOT/components/com_jshopping/lib/functions.php:1097

JROOT/components/com_jshopping/lib/jtableauto.php:200

JROOT/components/com_jshopping/tables/product.php:766

JROOT/components/com_jshopping/tables/product.php:478

JROOT/components/com_jshopping/controllers/product.php:66

JROOT/libraries/legacy/controller/legacy.php:728

JROOT/components/com_jshopping/jshopping.php:25

JROOT/libraries/cms/component/helper.php:391

JROOT/libraries/cms/component/helper.php:371

JROOT/libraries/cms/application/site.php:191

JROOT/libraries/cms/application/site.php:230

JROOT/libraries/cms/application/cms.php:252

JROOT/index.php:40

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.82 ms After last query: 0.29 ms Query memory: 0.016 MB Memory before query: 20.261 MB Rows returned: 1

SELECT prod.product_id, pr_cat.category_id, prod.`name_en-GB` as name, prod.`short_description_en-GB` as short_description, prod.product_ean, prod.image, prod.product_price, prod.currency_id, prod.product_tax_id as tax_id, prod.product_old_price, prod.product_weight, prod.average_rating, prod.reviews_count, prod.hits, prod.weight_volume_units, prod.basic_price_unit_id, prod.label_id, prod.product_manufacturer_id, prod.min_price, prod.product_quantity, prod.different_prices, prod.`extra_field_3` , prod.`extra_field_4` , prod.`extra_field_5` , prod.`extra_field_9` , prod.`extra_field_16` , prod.`extra_field_17` , prod.`extra_field_18` , prod.`extra_field_13` , prod.`extra_field_19` , prod.`extra_field_22` , prod.`extra_field_14` , prod.`extra_field_20` , prod.`extra_field_10` , prod.`extra_field_23`  
  FROM `myme2_jshopping_products_relations` AS relation
                
  INNER JOIN `myme2_jshopping_products` AS prod 
  ON relation.product_related_id = prod.product_id
                
  LEFT JOIN `myme2_jshopping_products_to_categories` AS pr_cat 
  ON pr_cat.product_id = relation.product_related_id
                
  LEFT JOIN `myme2_jshopping_categories` AS cat 
  ON pr_cat.category_id = cat.category_id
                
                
  WHERE relation.product_id = '264' 
  AND cat.category_publish='1' 
  AND prod.product_publish = '1'  
  AND prod.access IN (1,1) 
  AND cat.access IN (1,1) 
  group by prod.product_id 
  order by relation.id

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	relation	ref	product_id,product_id_2,product_related_id	product_id	4	const	2	Using where; Using temporary; Using filesort
1	SIMPLE	prod	eq_ref	PRIMARY,product_publish,access	PRIMARY	4	mnelson_joomlamaple.relation.product_related_id	1	Using where
1	SIMPLE	pr_cat	ref	PRIMARY,category_id,product_id,product_id_2	product_id_2	4	mnelson_joomlamaple.prod.product_id	2	Using where; Using index
1	SIMPLE	cat	eq_ref	PRIMARY,category_publish,access,category_publish_2	PRIMARY	4	mnelson_joomlamaple.pr_cat.category_id	1	Using where

Profile

Status	Duration
starting	0.0 ms
Waiting for query cache lock	0.0 ms
checking query cache for query	0.1 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
Opening tables	0.1 ms
System lock	0.0 ms
Waiting for query cache lock	0.0 ms
init	0.0 ms
optimizing	0.0 ms
statistics	0.1 ms
preparing	0.0 ms
Creating tmp table	0.1 ms
executing	0.0 ms
Copying to tmp table	0.1 ms
Sorting result	0.0 ms
Sending data	0.0 ms
end	0.0 ms
removing tmp table	0.0 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
Waiting for query cache lock	0.0 ms
freeing items	0.0 ms
Waiting for query cache lock	0.0 ms
freeing items	0.0 ms
storing result in query cache	0.0 ms
logging slow query	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT/components/com_jshopping/tables/product.php:778

JROOT/components/com_jshopping/tables/product.php:478

JROOT/components/com_jshopping/controllers/product.php:66

JROOT/libraries/legacy/controller/legacy.php:728

JROOT/components/com_jshopping/jshopping.php:25

JROOT/libraries/cms/component/helper.php:391

JROOT/libraries/cms/component/helper.php:371

JROOT/libraries/cms/application/site.php:191

JROOT/libraries/cms/application/site.php:230

JROOT/libraries/cms/application/cms.php:252

JROOT/index.php:40

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 1.21 ms After last query: 1.63 ms Query memory: 0.023 MB Memory before query: 20.542 MB Rows returned: 53

SHOW FULL COLUMNS 
  FROM `myme2_jshopping_users`

Explain

EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `myme2_jshopping_users`

Profile

Status	Duration
starting	0.0 ms
checking permissions	0.0 ms
Opening tables	0.2 ms
System lock	0.0 ms
init	0.0 ms
optimizing	0.0 ms
statistics	0.0 ms
preparing	0.0 ms
executing	0.0 ms
Opening tables	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
Sending data	0.1 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
removing tmp table	0.1 ms
closing tables	0.0 ms
freeing items	0.0 ms
logging slow query	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT/libraries/joomla/table/table.php:241

JROOT/libraries/joomla/table/table.php:162

JROOT/components/com_jshopping/tables/usershop.php:14

JROOT/components/com_jshopping/lib/factory.php:120

JROOT/components/com_jshopping/lib/functions.php:662

JROOT/components/com_jshopping/tables/product.php:782

JROOT/components/com_jshopping/tables/product.php:478

JROOT/components/com_jshopping/controllers/product.php:66

JROOT/libraries/legacy/controller/legacy.php:728

JROOT/components/com_jshopping/jshopping.php:25

JROOT/libraries/cms/component/helper.php:391

JROOT/libraries/cms/component/helper.php:371

JROOT/libraries/cms/application/site.php:191

JROOT/libraries/cms/application/site.php:230

JROOT/libraries/cms/application/cms.php:252

JROOT/index.php:40

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.31 ms After last query: 0.66 ms Query memory: 0.025 MB Memory before query: 20.713 MB Rows returned: 3

SHOW FULL COLUMNS 
  FROM `myme2_jshopping_taxes`

Explain

EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `myme2_jshopping_taxes`

Profile

Status	Duration
starting	0.0 ms
checking permissions	0.0 ms
Opening tables	0.1 ms
System lock	0.0 ms
init	0.0 ms
optimizing	0.0 ms
statistics	0.0 ms
preparing	0.0 ms
executing	0.0 ms
Opening tables	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
Sending data	0.0 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
removing tmp table	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
logging slow query	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT/libraries/joomla/table/table.php:241

JROOT/libraries/joomla/table/table.php:162

JROOT/components/com_jshopping/tables/tax.php:17

JROOT/libraries/joomla/table/table.php:305

JROOT/components/com_jshopping/lib/factory.php:682

JROOT/components/com_jshopping/lib/factory.php:424

JROOT/components/com_jshopping/lib/functions.php:663

JROOT/components/com_jshopping/tables/product.php:782

JROOT/components/com_jshopping/tables/product.php:478

JROOT/components/com_jshopping/controllers/product.php:66

JROOT/libraries/legacy/controller/legacy.php:728

JROOT/components/com_jshopping/jshopping.php:25

JROOT/libraries/cms/component/helper.php:391

JROOT/libraries/cms/component/helper.php:371

JROOT/libraries/cms/application/site.php:191

JROOT/libraries/cms/application/site.php:230

JROOT/libraries/cms/application/cms.php:252

JROOT/index.php:40

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.05 ms After last query: 0.13 ms Query memory: 0.020 MB Memory before query: 20.745 MB Rows returned: 1

SELECT tax_id, tax_name, tax_value 
  FROM `myme2_jshopping_taxes`

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	myme2_jshopping_taxes	system	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1

Profile

Status	Duration
starting	0.0 ms
Waiting for query cache lock	0.0 ms
checking query cache for query	0.0 ms
checking privileges on cached	0.0 ms
checking permissions	0.0 ms
sending cached result to clien	0.0 ms
logging slow query	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT/components/com_jshopping/tables/tax.php:24

JROOT/components/com_jshopping/lib/factory.php:410

JROOT/components/com_jshopping/lib/factory.php:425

JROOT/components/com_jshopping/lib/functions.php:663

JROOT/components/com_jshopping/tables/product.php:782

JROOT/components/com_jshopping/tables/product.php:478

JROOT/components/com_jshopping/controllers/product.php:66

JROOT/libraries/legacy/controller/legacy.php:728

JROOT/components/com_jshopping/jshopping.php:25

JROOT/libraries/cms/component/helper.php:391

JROOT/libraries/cms/component/helper.php:371

JROOT/libraries/cms/application/site.php:191

JROOT/libraries/cms/application/site.php:230

JROOT/libraries/cms/application/cms.php:252

JROOT/index.php:40

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.31 ms After last query: 0.38 ms Query memory: 0.026 MB Memory before query: 20.805 MB Rows returned: 5

SHOW FULL COLUMNS 
  FROM `myme2_jshopping_products_extra_field_values`

Explain

EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `myme2_jshopping_products_extra_field_values`

Profile

Status	Duration
starting	0.0 ms
checking permissions	0.0 ms
Opening tables	0.1 ms
System lock	0.0 ms
init	0.0 ms
optimizing	0.0 ms
statistics	0.0 ms
preparing	0.0 ms
executing	0.0 ms
Opening tables	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
Sending data	0.0 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
removing tmp table	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
logging slow query	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT/libraries/joomla/table/table.php:241

JROOT/libraries/joomla/table/table.php:162

JROOT/components/com_jshopping/tables/productfieldvalue.php:16

JROOT/libraries/joomla/table/table.php:305

JROOT/components/com_jshopping/lib/factory.php:682

JROOT/components/com_jshopping/lib/factory.php:566

JROOT/components/com_jshopping/lib/functions.php:805

JROOT/components/com_jshopping/lib/functions.php:730

JROOT/components/com_jshopping/tables/product.php:782

JROOT/components/com_jshopping/tables/product.php:478

JROOT/components/com_jshopping/controllers/product.php:66

JROOT/libraries/legacy/controller/legacy.php:728

JROOT/components/com_jshopping/jshopping.php:25

JROOT/libraries/cms/component/helper.php:391

JROOT/libraries/cms/component/helper.php:371

JROOT/libraries/cms/application/site.php:191

JROOT/libraries/cms/application/site.php:230

JROOT/libraries/cms/application/cms.php:252

JROOT/index.php:40

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.14 ms After last query: 0.12 ms Query memory: 0.020 MB Memory before query: 20.839 MB Rows returned: 202

SELECT id, `name_en-GB` as name, field_id 
  FROM `myme2_jshopping_products_extra_field_values` 
  order by ordering

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	myme2_jshopping_products_extra_field_values	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	202	Using filesort

Profile

Status	Duration
starting	0.0 ms
Waiting for query cache lock	0.0 ms
checking query cache for query	0.0 ms
checking privileges on cached	0.0 ms
checking permissions	0.0 ms
sending cached result to clien	0.0 ms
logging slow query	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT/components/com_jshopping/tables/productfieldvalue.php:27

JROOT/components/com_jshopping/lib/factory.php:567

JROOT/components/com_jshopping/lib/functions.php:805

JROOT/components/com_jshopping/lib/functions.php:730

JROOT/components/com_jshopping/tables/product.php:782

JROOT/components/com_jshopping/tables/product.php:478

JROOT/components/com_jshopping/controllers/product.php:66

JROOT/libraries/legacy/controller/legacy.php:728

JROOT/components/com_jshopping/jshopping.php:25

JROOT/libraries/cms/component/helper.php:391

JROOT/libraries/cms/component/helper.php:371

JROOT/libraries/cms/application/site.php:191

JROOT/libraries/cms/application/site.php:230

JROOT/libraries/cms/application/cms.php:252

JROOT/index.php:40

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.39 ms After last query: 0.95 ms Query memory: 0.024 MB Memory before query: 20.926 MB Rows returned: 6

SHOW FULL COLUMNS 
  FROM `myme2_jshopping_product_labels`

Explain

EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `myme2_jshopping_product_labels`

Profile

Status	Duration
starting	0.0 ms
checking permissions	0.0 ms
Opening tables	0.1 ms
System lock	0.0 ms
init	0.0 ms
optimizing	0.0 ms
statistics	0.0 ms
preparing	0.0 ms
executing	0.0 ms
Opening tables	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
Sending data	0.0 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
removing tmp table	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
logging slow query	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT/libraries/joomla/table/table.php:241

JROOT/libraries/joomla/table/table.php:162

JROOT/components/com_jshopping/tables/productlabel.php:14

JROOT/libraries/joomla/table/table.php:305

JROOT/components/com_jshopping/lib/factory.php:682

JROOT/components/com_jshopping/lib/functions.php:634

JROOT/components/com_jshopping/lib/functions.php:769

JROOT/components/com_jshopping/tables/product.php:782

JROOT/components/com_jshopping/tables/product.php:478

JROOT/components/com_jshopping/controllers/product.php:66

JROOT/libraries/legacy/controller/legacy.php:728

JROOT/components/com_jshopping/jshopping.php:25

JROOT/libraries/cms/component/helper.php:391

JROOT/libraries/cms/component/helper.php:371

JROOT/libraries/cms/application/site.php:191

JROOT/libraries/cms/application/site.php:230

JROOT/libraries/cms/application/cms.php:252

JROOT/index.php:40

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.07 ms After last query: 0.11 ms Query memory: 0.019 MB Memory before query: 20.962 MB Rows returned: 5

SELECT id, image, `name_en-GB` as name 
  FROM `myme2_jshopping_product_labels` 
  ORDER BY name

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	myme2_jshopping_product_labels	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	5	Using filesort

Profile

Status	Duration
starting	0.0 ms
Waiting for query cache lock	0.0 ms
checking query cache for query	0.0 ms
checking privileges on cached	0.0 ms
checking permissions	0.0 ms
sending cached result to clien	0.0 ms
logging slow query	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT/components/com_jshopping/tables/productlabel.php:22

JROOT/components/com_jshopping/lib/functions.php:635

JROOT/components/com_jshopping/lib/functions.php:769

JROOT/components/com_jshopping/tables/product.php:782

JROOT/components/com_jshopping/tables/product.php:478

JROOT/components/com_jshopping/controllers/product.php:66

JROOT/libraries/legacy/controller/legacy.php:728

JROOT/components/com_jshopping/jshopping.php:25

JROOT/libraries/cms/component/helper.php:391

JROOT/libraries/cms/component/helper.php:371

JROOT/libraries/cms/application/site.php:191

JROOT/libraries/cms/application/site.php:230

JROOT/libraries/cms/application/cms.php:252

JROOT/index.php:40

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.69 ms After last query: 0.80 ms Query memory: 0.020 MB Memory before query: 21.098 MB Rows returned: 25

SHOW FULL COLUMNS 
  FROM `myme2_jshopping_categories`

Explain

EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `myme2_jshopping_categories`

Profile

Status	Duration
starting	0.0 ms
checking permissions	0.0 ms
Opening tables	0.1 ms
System lock	0.0 ms
init	0.0 ms
optimizing	0.0 ms
statistics	0.0 ms
preparing	0.0 ms
executing	0.0 ms
Opening tables	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
Sending data	0.1 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
removing tmp table	0.1 ms
closing tables	0.0 ms
freeing items	0.0 ms
logging slow query	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT/libraries/joomla/table/table.php:241

JROOT/libraries/joomla/table/table.php:162

JROOT/components/com_jshopping/tables/category.php:15

JROOT/libraries/joomla/table/table.php:305

JROOT/components/com_jshopping/lib/factory.php:682

JROOT/components/com_jshopping/controllers/product.php:68

JROOT/libraries/legacy/controller/legacy.php:728

JROOT/components/com_jshopping/jshopping.php:25

JROOT/libraries/cms/component/helper.php:391

JROOT/libraries/cms/component/helper.php:371

JROOT/libraries/cms/application/site.php:191

JROOT/libraries/cms/application/site.php:230

JROOT/libraries/cms/application/cms.php:252

JROOT/index.php:40

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.06 ms After last query: 0.36 ms Query memory: 0.015 MB Memory before query: 21.178 MB Rows returned: 1

Duplicate queries: #47 #49 #51

SELECT *

  FROM myme2_jshopping_categories

  WHERE `category_id` = '11'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	myme2_jshopping_categories	const	PRIMARY	PRIMARY	4	const	1

Profile

Status	Duration
starting	0.0 ms
Waiting for query cache lock	0.0 ms
checking query cache for query	0.0 ms
checking privileges on cached	0.0 ms
checking permissions	0.0 ms
sending cached result to clien	0.0 ms
logging slow query	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT/libraries/joomla/table/table.php:728

JROOT/components/com_jshopping/controllers/product.php:69

JROOT/libraries/legacy/controller/legacy.php:728

JROOT/components/com_jshopping/jshopping.php:25

JROOT/libraries/cms/component/helper.php:391

JROOT/libraries/cms/component/helper.php:371

JROOT/libraries/cms/application/site.php:191

JROOT/libraries/cms/application/site.php:230

JROOT/libraries/cms/application/cms.php:252

JROOT/index.php:40

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.54 ms After last query: 0.94 ms Query memory: 0.012 MB Memory before query: 21.264 MB

UPDATE myme2_jshopping_products

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

  WHERE `product_id` = '264'

Explain

EXPLAIN not possible on query: UPDATE myme2_jshopping_products SET `hits` = (`hits` + 1) WHERE `product_id` = '264'

Profile

Status	Duration
starting	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
System lock	0.0 ms
init	0.0 ms
Updating	0.1 ms
end	0.0 ms
Waiting for query cache lock	0.0 ms
end	0.3 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
logging slow query	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT/libraries/joomla/table/table.php:1239

JROOT/components/com_jshopping/controllers/product.php:85

JROOT/libraries/legacy/controller/legacy.php:728

JROOT/components/com_jshopping/jshopping.php:25

JROOT/libraries/cms/component/helper.php:391

JROOT/libraries/cms/component/helper.php:371

JROOT/libraries/cms/application/site.php:191

JROOT/libraries/cms/application/site.php:230

JROOT/libraries/cms/application/cms.php:252

JROOT/index.php:40

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.46 ms After last query: 1.09 ms Query memory: 0.020 MB Memory before query: 21.472 MB Rows returned: 10

SHOW FULL COLUMNS 
  FROM `myme2_jshopping_products_reviews`

Explain

EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `myme2_jshopping_products_reviews`

Profile

Status	Duration
starting	0.0 ms
checking permissions	0.0 ms
Opening tables	0.1 ms
System lock	0.0 ms
init	0.0 ms
optimizing	0.0 ms
statistics	0.0 ms
preparing	0.0 ms
executing	0.0 ms
Opening tables	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
Sending data	0.0 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
removing tmp table	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
logging slow query	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT/libraries/joomla/table/table.php:241

JROOT/libraries/joomla/table/table.php:162

JROOT/components/com_jshopping/tables/review.php:14

JROOT/libraries/joomla/table/table.php:305

JROOT/components/com_jshopping/lib/factory.php:682

JROOT/components/com_jshopping/controllers/product.php:101

JROOT/libraries/legacy/controller/legacy.php:728

JROOT/components/com_jshopping/jshopping.php:25

JROOT/libraries/cms/component/helper.php:391

JROOT/libraries/cms/component/helper.php:371

JROOT/libraries/cms/application/site.php:191

JROOT/libraries/cms/application/site.php:230

JROOT/libraries/cms/application/cms.php:252

JROOT/index.php:40

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.08 ms After last query: 0.18 ms Query memory: 0.016 MB Memory before query: 21.511 MB Rows returned: 22

select manufacturer_id as id, `name_en-GB` as name, manufacturer_logo, manufacturer_url 
  from myme2_jshopping_manufacturers 
  where manufacturer_publish='1'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	myme2_jshopping_manufacturers	ref	manufacturer_publish	manufacturer_publish	1	const	21

Profile

Status	Duration
starting	0.0 ms
Waiting for query cache lock	0.0 ms
checking query cache for query	0.0 ms
checking privileges on cached	0.0 ms
checking permissions	0.0 ms
sending cached result to clien	0.0 ms
logging slow query	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT/components/com_jshopping/lib/factory.php:483

JROOT/components/com_jshopping/tables/product.php:384

JROOT/components/com_jshopping/controllers/product.php:119

JROOT/libraries/legacy/controller/legacy.php:728

JROOT/components/com_jshopping/jshopping.php:25

JROOT/libraries/cms/component/helper.php:391

JROOT/libraries/cms/component/helper.php:371

JROOT/libraries/cms/application/site.php:191

JROOT/libraries/cms/application/site.php:230

JROOT/libraries/cms/application/cms.php:252

JROOT/index.php:40

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.41 ms After last query: 0.33 ms Query memory: 0.015 MB Memory before query: 21.555 MB Rows returned: 6

SELECT I.*, IF(P.image=I.image_name,0,1) as sort 
  FROM `myme2_jshopping_products_images` as I 
  left join `myme2_jshopping_products` as P 
  on P.product_id=I.product_id
                 
  WHERE I.product_id = '264' 
  ORDER BY sort, I.ordering

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	I	ref	product_id	product_id	4	const	5	Using temporary; Using filesort
1	SIMPLE	P	eq_ref	PRIMARY	PRIMARY	4	mnelson_joomlamaple.I.product_id	1

Profile

Status	Duration
starting	0.0 ms
Waiting for query cache lock	0.0 ms
checking query cache for query	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
Opening tables	0.1 ms
System lock	0.0 ms
Waiting for query cache lock	0.0 ms
init	0.0 ms
optimizing	0.0 ms
statistics	0.0 ms
preparing	0.0 ms
Creating tmp table	0.0 ms
executing	0.0 ms
Copying to tmp table	0.0 ms
Sorting result	0.0 ms
Sending data	0.0 ms
end	0.0 ms
removing tmp table	0.0 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
Waiting for query cache lock	0.0 ms
freeing items	0.0 ms
Waiting for query cache lock	0.0 ms
freeing items	0.0 ms
storing result in query cache	0.0 ms
logging slow query	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT/components/com_jshopping/tables/product.php:321

JROOT/components/com_jshopping/controllers/product.php:221

JROOT/libraries/legacy/controller/legacy.php:728

JROOT/components/com_jshopping/jshopping.php:25

JROOT/libraries/cms/component/helper.php:391

JROOT/libraries/cms/component/helper.php:371

JROOT/libraries/cms/application/site.php:191

JROOT/libraries/cms/application/site.php:230

JROOT/libraries/cms/application/cms.php:252

JROOT/index.php:40

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.82 ms After last query: 4.04 ms Query memory: 0.022 MB Memory before query: 21.973 MB Rows returned: 7

SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid

  FROM myme2_modules AS m

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

  LEFT JOIN myme2_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 <= '2015-07-02 03:40:50') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2015-07-02 03:40:50') 
  AND m.access IN (1,1) 
  AND m.client_id = 0 
  AND (mm.menuid = 613 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

Explain

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

Profile

Status	Duration
starting	0.0 ms
Waiting for query cache lock	0.0 ms
checking query cache for query	0.1 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
System lock	0.0 ms
Waiting for query cache lock	0.0 ms
init	0.0 ms
optimizing	0.0 ms
statistics	0.0 ms
preparing	0.0 ms
executing	0.0 ms
Sorting result	0.1 ms
Sending data	0.3 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
Waiting for query cache lock	0.0 ms
freeing items	0.0 ms
Waiting for query cache lock	0.0 ms
freeing items	0.0 ms
storing result in query cache	0.0 ms
logging slow query	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:430

JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:373

JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:89

JROOT/components/com_jshopping/templates/fixel/product/product_default.php:426

JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661

JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:207

JROOT/components/com_jshopping/views/product/view.html.php:13

JROOT/components/com_jshopping/controllers/product.php:274

JROOT/libraries/legacy/controller/legacy.php:728

JROOT/components/com_jshopping/jshopping.php:25

JROOT/libraries/cms/component/helper.php:391

JROOT/libraries/cms/component/helper.php:371

JROOT/libraries/cms/application/site.php:191

JROOT/libraries/cms/application/site.php:230

JROOT/libraries/cms/application/cms.php:252

JROOT/index.php:40

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.15 ms After last query: 8.53 ms Query memory: 0.017 MB Memory before query: 22.453 MB Rows returned: 1

Duplicate queries: #41 #49 #51

SELECT *

  FROM myme2_jshopping_categories

  WHERE `category_id` = '11'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	myme2_jshopping_categories	const	PRIMARY	PRIMARY	4	const	1

Profile

Status	Duration
starting	0.0 ms
Waiting for query cache lock	0.0 ms
checking query cache for query	0.0 ms
checking privileges on cached	0.0 ms
checking permissions	0.0 ms
sending cached result to clien	0.0 ms
logging slow query	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT/libraries/joomla/table/table.php:728

JROOT/modules/mod_jshopping_categories/mod_jshopping_categories.php:40

JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:195

JROOT/libraries/joomla/document/html/renderer/module.php:103

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:729

JROOT/libraries/cms/application/cms.php:258

JROOT/index.php:40

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.08 ms After last query: 0.16 ms Query memory: 0.017 MB Memory before query: 22.464 MB Rows returned: 1

SELECT category_parent_id 
  FROM `myme2_jshopping_categories` 
  WHERE category_id = '11' 
  and category_publish = '1' 
  and  access IN (1,1)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	myme2_jshopping_categories	const	PRIMARY,category_publish,access,category_publish_2	PRIMARY	4	const	1

Profile

Status	Duration
starting	0.0 ms
Waiting for query cache lock	0.0 ms
checking query cache for query	0.0 ms
checking privileges on cached	0.0 ms
checking permissions	0.0 ms
sending cached result to clien	0.0 ms
logging slow query	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT/components/com_jshopping/tables/category.php:139

JROOT/modules/mod_jshopping_categories/mod_jshopping_categories.php:41

JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:195

JROOT/libraries/joomla/document/html/renderer/module.php:103

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:729

JROOT/libraries/cms/application/cms.php:258

JROOT/index.php:40

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.09 ms After last query: 0.23 ms Query memory: 0.019 MB Memory before query: 22.497 MB Rows returned: 1

Duplicate queries: #41 #47 #51

SELECT *

  FROM myme2_jshopping_categories

  WHERE `category_id` = '11'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	myme2_jshopping_categories	const	PRIMARY	PRIMARY	4	const	1

Profile

Status	Duration
starting	0.0 ms
Waiting for query cache lock	0.0 ms
checking query cache for query	0.0 ms
checking privileges on cached	0.0 ms
checking permissions	0.0 ms
sending cached result to clien	0.0 ms
logging slow query	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT/libraries/joomla/table/table.php:728

JROOT/modules/mod_jshopping_categories/helper.php:8

JROOT/modules/mod_jshopping_categories/helper.php:47

JROOT/modules/mod_jshopping_categories/mod_jshopping_categories.php:42

JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:195

JROOT/libraries/joomla/document/html/renderer/module.php:103

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:729

JROOT/libraries/cms/application/cms.php:258

JROOT/index.php:40

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.10 ms After last query: 0.15 ms Query memory: 0.020 MB Memory before query: 22.509 MB Rows returned: 10

SELECT `name_en-GB` as name,`description_en-GB` as description,`short_description_en-GB` as short_description, category_id, category_publish, ordering, category_image 
  FROM `myme2_jshopping_categories`
                   
  WHERE category_parent_id = '0'  
  AND category_publish = '1'  
  AND access IN (1,1)
                   
  ORDER BY ordering asc

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	myme2_jshopping_categories	ref	category_parent_id,category_publish,access,category_publish_2	category_publish_2	1	const	3	Using where; Using filesort

Profile

Status	Duration
starting	0.0 ms
Waiting for query cache lock	0.0 ms
checking query cache for query	0.0 ms
checking privileges on cached	0.0 ms
checking permissions	0.0 ms
sending cached result to clien	0.0 ms
logging slow query	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT/components/com_jshopping/tables/category.php:34

JROOT/components/com_jshopping/tables/category.php:116

JROOT/modules/mod_jshopping_categories/helper.php:10

JROOT/modules/mod_jshopping_categories/helper.php:47

JROOT/modules/mod_jshopping_categories/mod_jshopping_categories.php:42

JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:195

JROOT/libraries/joomla/document/html/renderer/module.php:103

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:729

JROOT/libraries/cms/application/cms.php:258

JROOT/index.php:40

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.10 ms After last query: 2.56 ms Query memory: 0.019 MB Memory before query: 22.591 MB Rows returned: 1

Duplicate queries: #41 #47 #49

SELECT *

  FROM myme2_jshopping_categories

  WHERE `category_id` = '11'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	myme2_jshopping_categories	const	PRIMARY	PRIMARY	4	const	1

Profile

Status	Duration
starting	0.0 ms
Waiting for query cache lock	0.0 ms
checking query cache for query	0.0 ms
checking privileges on cached	0.0 ms
checking permissions	0.0 ms
sending cached result to clien	0.0 ms
logging slow query	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT/libraries/joomla/table/table.php:728

JROOT/modules/mod_jshopping_categories/helper.php:18

JROOT/modules/mod_jshopping_categories/helper.php:47

JROOT/modules/mod_jshopping_categories/mod_jshopping_categories.php:42

JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:195

JROOT/libraries/joomla/document/html/renderer/module.php:103

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:729

JROOT/libraries/cms/application/cms.php:258

JROOT/index.php:40

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.09 ms After last query: 0.15 ms Query memory: 0.020 MB Memory before query: 22.604 MB Rows returned: 0

SELECT `name_en-GB` as name,`description_en-GB` as description,`short_description_en-GB` as short_description, category_id, category_publish, ordering, category_image 
  FROM `myme2_jshopping_categories`
                   
  WHERE category_parent_id = '11'  
  AND category_publish = '1'  
  AND access IN (1,1)
                   
  ORDER BY ordering asc

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	myme2_jshopping_categories	ref	category_parent_id,category_publish,access,category_publish_2	category_parent_id	4	const	1	Using where; Using filesort

Profile

Status	Duration
starting	0.0 ms
Waiting for query cache lock	0.0 ms
checking query cache for query	0.0 ms
checking privileges on cached	0.0 ms
checking permissions	0.0 ms
sending cached result to clien	0.0 ms
logging slow query	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT/components/com_jshopping/tables/category.php:34

JROOT/components/com_jshopping/tables/category.php:112

JROOT/modules/mod_jshopping_categories/helper.php:20

JROOT/modules/mod_jshopping_categories/helper.php:47

JROOT/modules/mod_jshopping_categories/mod_jshopping_categories.php:42

JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:195

JROOT/libraries/joomla/document/html/renderer/module.php:103

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:729

JROOT/libraries/cms/application/cms.php:258

JROOT/index.php:40

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.45 ms After last query: 11.86 ms Query memory: 0.018 MB Memory before query: 23.259 MB Rows returned: 0

SELECT *
 
  FROM myme2_jmap_metainfo
 
  WHERE `linkurl` = 'http://mapleleafmusic.com/shop/mandolins/gibson-1921-a2-mandolin-64574'
 
  AND `published` = 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	myme2_jmap_metainfo	ref	linkurl,published	linkurl	767	const	1	Using where

Profile

Status	Duration
starting	0.0 ms
Waiting for query cache lock	0.0 ms
checking query cache for query	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
System lock	0.0 ms
Waiting for query cache lock	0.0 ms
init	0.0 ms
optimizing	0.0 ms
statistics	0.0 ms
preparing	0.0 ms
executing	0.0 ms
Sending data	0.0 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
Waiting for query cache lock	0.0 ms
freeing items	0.1 ms
Waiting for query cache lock	0.0 ms
freeing items	0.0 ms
storing result in query cache	0.0 ms
logging slow query	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT/plugins/system/jmap/jmap.php:246

JROOT/libraries/joomla/event/event.php:69

JROOT/libraries/joomla/event/dispatcher.php:160

JROOT/libraries/joomla/application/base.php:83

JROOT/libraries/joomla/document/html/renderer/head.php:57

JROOT/libraries/joomla/document/html/renderer/head.php:34

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:729

JROOT/libraries/cms/application/cms.php:258

JROOT/index.php:40

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.12 ms After last query: 16.38 ms Query memory: 0.013 MB Memory before query: 25.622 MB Rows returned: 1

SELECT `FormId`, `FormLayout`, `ScriptDisplay`, `ErrorMessage`, `FormTitle`, `CSS`, `JS`, `CSSClass`, `CSSId`, `CSSName`, `CSSAction`, `CSSAdditionalAttributes`, `AjaxValidation`, `ThemeParams` 
  FROM myme2_rsform_forms 
  WHERE FormId='3' 
  AND `Published`='1'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	myme2_rsform_forms	const	PRIMARY	PRIMARY	4	const	1

Profile

Status	Duration
starting	0.0 ms
Waiting for query cache lock	0.0 ms
checking query cache for query	0.0 ms
checking privileges on cached	0.0 ms
checking permissions	0.0 ms
sending cached result to clien	0.0 ms
logging slow query	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT/plugins/system/rsform/rsform.php:97

JROOT/libraries/joomla/event/event.php:69

JROOT/libraries/joomla/event/dispatcher.php:160

JROOT/libraries/joomla/application/base.php:83

JROOT/libraries/cms/application/cms.php:1065

JROOT/libraries/cms/application/site.php:729

JROOT/libraries/cms/application/cms.php:258

JROOT/index.php:40

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.07 ms After last query: 0.09 ms Query memory: 0.015 MB Memory before query: 25.640 MB Rows returned: 1

SELECT Published, FormTitle, MetaTitle, MetaDesc, MetaKeywords, ShowThankyou, Access 
  FROM myme2_rsform_forms 
  WHERE FormId='3'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	myme2_rsform_forms	const	PRIMARY	PRIMARY	4	const	1

Profile

Status	Duration
starting	0.0 ms
Waiting for query cache lock	0.0 ms
checking query cache for query	0.0 ms
checking privileges on cached	0.0 ms
checking permissions	0.0 ms
sending cached result to clien	0.0 ms
logging slow query	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT/administrator/components/com_rsform/helpers/rsform.php:179

JROOT/plugins/system/rsform/rsform.php:126

JROOT/libraries/joomla/event/event.php:69

JROOT/libraries/joomla/event/dispatcher.php:160

JROOT/libraries/joomla/application/base.php:83

JROOT/libraries/cms/application/cms.php:1065

JROOT/libraries/cms/application/site.php:729

JROOT/libraries/cms/application/cms.php:258

JROOT/index.php:40

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.05 ms After last query: 0.08 ms Query memory: 0.015 MB Memory before query: 25.656 MB Rows returned: 1

Duplicate queries: #58 #63

SELECT `Lang` 
  FROM myme2_rsform_forms 
  WHERE FormId='3'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	myme2_rsform_forms	const	PRIMARY	PRIMARY	4	const	1

Profile

Status	Duration
starting	0.0 ms
Waiting for query cache lock	0.0 ms
checking query cache for query	0.0 ms
checking privileges on cached	0.0 ms
checking permissions	0.0 ms
sending cached result to clien	0.0 ms
logging slow query	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT/administrator/components/com_rsform/helpers/rsform.php:3631

JROOT/administrator/components/com_rsform/helpers/rsform.php:219

JROOT/plugins/system/rsform/rsform.php:126

JROOT/libraries/joomla/event/event.php:69

JROOT/libraries/joomla/event/dispatcher.php:160

JROOT/libraries/joomla/application/base.php:83

JROOT/libraries/cms/application/cms.php:1065

JROOT/libraries/cms/application/site.php:729

JROOT/libraries/cms/application/cms.php:258

JROOT/index.php:40

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.09 ms After last query: 0.11 ms Query memory: 0.015 MB Memory before query: 25.672 MB Rows returned: 1

SELECT `FormId`, `FormLayoutName`, `FormLayout`, `ScriptDisplay`, `ErrorMessage`, `FormTitle`, `CSS`, `JS`, `CSSClass`, `CSSId`, `CSSName`, `CSSAction`, `CSSAdditionalAttributes`, `AjaxValidation`, `ThemeParams` 
  FROM myme2_rsform_forms 
  WHERE FormId='3' 
  AND `Published`='1'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	myme2_rsform_forms	const	PRIMARY	PRIMARY	4	const	1

Profile

Status	Duration
starting	0.0 ms
Waiting for query cache lock	0.0 ms
checking query cache for query	0.0 ms
checking privileges on cached	0.0 ms
checking permissions	0.0 ms
sending cached result to clien	0.0 ms
logging slow query	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT/administrator/components/com_rsform/helpers/rsform.php:1585

JROOT/administrator/components/com_rsform/helpers/rsform.php:274

JROOT/plugins/system/rsform/rsform.php:126

JROOT/libraries/joomla/event/event.php:69

JROOT/libraries/joomla/event/dispatcher.php:160

JROOT/libraries/joomla/application/base.php:83

JROOT/libraries/cms/application/cms.php:1065

JROOT/libraries/cms/application/site.php:729

JROOT/libraries/cms/application/cms.php:258

JROOT/index.php:40

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.08 ms After last query: 0.12 ms Query memory: 0.016 MB Memory before query: 25.693 MB Rows returned: 1

Duplicate queries: #56 #63

SELECT `Lang` 
  FROM myme2_rsform_forms 
  WHERE FormId='3'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	myme2_rsform_forms	const	PRIMARY	PRIMARY	4	const	1

Profile

Status	Duration
starting	0.0 ms
Waiting for query cache lock	0.0 ms
checking query cache for query	0.0 ms
checking privileges on cached	0.0 ms
checking permissions	0.0 ms
sending cached result to clien	0.0 ms
logging slow query	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT/administrator/components/com_rsform/helpers/rsform.php:3631

JROOT/administrator/components/com_rsform/helpers/rsform.php:1588

JROOT/administrator/components/com_rsform/helpers/rsform.php:274

JROOT/plugins/system/rsform/rsform.php:126

JROOT/libraries/joomla/event/event.php:69

JROOT/libraries/joomla/event/dispatcher.php:160

JROOT/libraries/joomla/application/base.php:83

JROOT/libraries/cms/application/cms.php:1065

JROOT/libraries/cms/application/site.php:729

JROOT/libraries/cms/application/cms.php:258

JROOT/index.php:40

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.07 ms After last query: 0.09 ms Query memory: 0.016 MB Memory before query: 25.710 MB Rows returned: 0

SELECT ComponentId 
  FROM myme2_rsform_components 
  WHERE ComponentTypeId='6' 
  AND FormId='3' 
  AND Published='1'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	myme2_rsform_components	ref	ComponentTypeId,FormId	ComponentTypeId	4	const	1	Using where

Profile

Status	Duration
starting	0.0 ms
Waiting for query cache lock	0.0 ms
checking query cache for query	0.0 ms
checking privileges on cached	0.0 ms
checking permissions	0.0 ms
sending cached result to clien	0.0 ms
logging slow query	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT/administrator/components/com_rsform/helpers/rsform.php:1494

JROOT/administrator/components/com_rsform/helpers/rsform.php:1608

JROOT/administrator/components/com_rsform/helpers/rsform.php:274

JROOT/plugins/system/rsform/rsform.php:126

JROOT/libraries/joomla/event/event.php:69

JROOT/libraries/joomla/event/dispatcher.php:160

JROOT/libraries/joomla/application/base.php:83

JROOT/libraries/cms/application/cms.php:1065

JROOT/libraries/cms/application/site.php:729

JROOT/libraries/cms/application/cms.php:258

JROOT/index.php:40

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.08 ms After last query: 0.07 ms Query memory: 0.015 MB Memory before query: 25.726 MB Rows returned: 7

SELECT p.PropertyValue AS name, c.ComponentId, c.ComponentTypeId, ct.ComponentTypeName, c.
  Order 
  FROM myme2_rsform_properties p 
  LEFT JOIN myme2_rsform_components c 
  ON (c.ComponentId=p.ComponentId) 
  LEFT JOIN myme2_rsform_component_types ct 
  ON (ct.ComponentTypeId=c.ComponentTypeId) 
  WHERE c.FormId='3' 
  AND p.PropertyName='NAME' 
  AND c.Published='1' 
  ORDER BY c.
  Order

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c	ref	ComponentId,FormId	FormId	4	const	10	Using where; Using filesort
1	SIMPLE	ct	eq_ref	PRIMARY	PRIMARY	4	mnelson_joomlamaple.c.ComponentTypeId	1
1	SIMPLE	p	ref	ComponentId	ComponentId	4	mnelson_joomlamaple.c.ComponentId	11	Using where

Profile

Status	Duration
starting	0.0 ms
Waiting for query cache lock	0.0 ms
checking query cache for query	0.0 ms
checking privileges on cached	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
sending cached result to clien	0.0 ms
logging slow query	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT/administrator/components/com_rsform/helpers/rsform.php:1661

JROOT/administrator/components/com_rsform/helpers/rsform.php:274

JROOT/plugins/system/rsform/rsform.php:126

JROOT/libraries/joomla/event/event.php:69

JROOT/libraries/joomla/event/dispatcher.php:160

JROOT/libraries/joomla/application/base.php:83

JROOT/libraries/cms/application/cms.php:1065

JROOT/libraries/cms/application/site.php:729

JROOT/libraries/cms/application/cms.php:258

JROOT/index.php:40

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.06 ms After last query: 0.10 ms Query memory: 0.016 MB Memory before query: 25.752 MB Rows returned: 87

SELECT `PropertyName`, `PropertyValue`, `ComponentId` 
  FROM myme2_rsform_properties 
  WHERE `ComponentId` IN (50,25,36,23,28,51,26)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	myme2_rsform_properties	ALL	ComponentId	NO INDEX KEY COULD BE USED	NULL	NULL	242	Using where

Profile

Status	Duration
starting	0.0 ms
Waiting for query cache lock	0.0 ms
checking query cache for query	0.0 ms
checking privileges on cached	0.0 ms
checking permissions	0.0 ms
sending cached result to clien	0.0 ms
logging slow query	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT/administrator/components/com_rsform/helpers/rsform.php:517

JROOT/administrator/components/com_rsform/helpers/rsform.php:1686

JROOT/administrator/components/com_rsform/helpers/rsform.php:274

JROOT/plugins/system/rsform/rsform.php:126

JROOT/libraries/joomla/event/event.php:69

JROOT/libraries/joomla/event/dispatcher.php:160

JROOT/libraries/joomla/application/base.php:83

JROOT/libraries/cms/application/cms.php:1065

JROOT/libraries/cms/application/site.php:729

JROOT/libraries/cms/application/cms.php:258

JROOT/index.php:40

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.07 ms After last query: 0.29 ms Query memory: 0.016 MB Memory before query: 25.857 MB Rows returned: 1

SELECT FormId 
  FROM myme2_rsform_components 
  WHERE ComponentId='50'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	myme2_rsform_components	const	ComponentId	ComponentId	4	const	1

Profile

Status	Duration
starting	0.0 ms
Waiting for query cache lock	0.0 ms
checking query cache for query	0.0 ms
checking privileges on cached	0.0 ms
checking permissions	0.0 ms
sending cached result to clien	0.0 ms
logging slow query	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT/administrator/components/com_rsform/helpers/rsform.php:527

JROOT/administrator/components/com_rsform/helpers/rsform.php:1686

JROOT/administrator/components/com_rsform/helpers/rsform.php:274

JROOT/plugins/system/rsform/rsform.php:126

JROOT/libraries/joomla/event/event.php:69

JROOT/libraries/joomla/event/dispatcher.php:160

JROOT/libraries/joomla/application/base.php:83

JROOT/libraries/cms/application/cms.php:1065

JROOT/libraries/cms/application/site.php:729

JROOT/libraries/cms/application/cms.php:258

JROOT/index.php:40

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.06 ms After last query: 0.07 ms Query memory: 0.017 MB Memory before query: 25.873 MB Rows returned: 1

Duplicate queries: #56 #58

SELECT `Lang` 
  FROM myme2_rsform_forms 
  WHERE FormId='3'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	myme2_rsform_forms	const	PRIMARY	PRIMARY	4	const	1

Profile

Status	Duration
starting	0.0 ms
Waiting for query cache lock	0.0 ms
checking query cache for query	0.0 ms
checking privileges on cached	0.0 ms
checking permissions	0.0 ms
sending cached result to clien	0.0 ms
logging slow query	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT/administrator/components/com_rsform/helpers/rsform.php:3631

JROOT/administrator/components/com_rsform/helpers/rsform.php:531

JROOT/administrator/components/com_rsform/helpers/rsform.php:1686

JROOT/administrator/components/com_rsform/helpers/rsform.php:274

JROOT/plugins/system/rsform/rsform.php:126

JROOT/libraries/joomla/event/event.php:69

JROOT/libraries/joomla/event/dispatcher.php:160

JROOT/libraries/joomla/application/base.php:83

JROOT/libraries/cms/application/cms.php:1065

JROOT/libraries/cms/application/site.php:729

JROOT/libraries/cms/application/cms.php:258

JROOT/index.php:40

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.32 ms After last query: 0.25 ms Query memory: 0.018 MB Memory before query: 25.837 MB Rows returned: 1

SELECT *

  FROM myme2_jshopping_products

  WHERE product_id =264

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	myme2_jshopping_products	const	PRIMARY	PRIMARY	4	const	1

Profile

Status	Duration
starting	0.0 ms
Waiting for query cache lock	0.0 ms
checking query cache for query	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
System lock	0.0 ms
Waiting for query cache lock	0.0 ms
init	0.0 ms
optimizing	0.0 ms
statistics	0.0 ms
preparing	0.0 ms
executing	0.0 ms
Sending data	0.0 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
Waiting for query cache lock	0.0 ms
freeing items	0.0 ms
Waiting for query cache lock	0.0 ms
freeing items	0.0 ms
storing result in query cache	0.0 ms
logging slow query	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT/administrator/components/com_rsform/helpers/rsform.php(552) : eval()'d code:12

JROOT/administrator/components/com_rsform/helpers/rsform.php:552

JROOT/administrator/components/com_rsform/helpers/rsform.php:2742

JROOT/administrator/components/com_rsform/helpers/rsform.php:1718

JROOT/administrator/components/com_rsform/helpers/rsform.php:274

JROOT/plugins/system/rsform/rsform.php:126

JROOT/libraries/joomla/event/event.php:69

JROOT/libraries/joomla/event/dispatcher.php:160

JROOT/libraries/joomla/application/base.php:83

JROOT/libraries/cms/application/cms.php:1065

JROOT/libraries/cms/application/site.php:729

JROOT/libraries/cms/application/cms.php:258

JROOT/index.php:40

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.08 ms After last query: 1.00 ms Query memory: 0.018 MB Memory before query: 25.908 MB Rows returned: 0

SELECT ComponentId 
  FROM myme2_rsform_components 
  WHERE ComponentTypeId='41' 
  AND FormId='3' 
  AND Published='1'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	myme2_rsform_components	ref	ComponentTypeId,FormId	ComponentTypeId	4	const	1	Using where

Profile

Status	Duration
starting	0.0 ms
Waiting for query cache lock	0.0 ms
checking query cache for query	0.0 ms
checking privileges on cached	0.0 ms
checking permissions	0.0 ms
sending cached result to clien	0.0 ms
logging slow query	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT/administrator/components/com_rsform/helpers/rsform.php:1494

JROOT/administrator/components/com_rsform/helpers/rsform.php:3109

JROOT/administrator/components/com_rsform/helpers/rsform.php:1718

JROOT/administrator/components/com_rsform/helpers/rsform.php:274

JROOT/plugins/system/rsform/rsform.php:126

JROOT/libraries/joomla/event/event.php:69

JROOT/libraries/joomla/event/dispatcher.php:160

JROOT/libraries/joomla/application/base.php:83

JROOT/libraries/cms/application/cms.php:1065

JROOT/libraries/cms/application/site.php:729

JROOT/libraries/cms/application/cms.php:258

JROOT/index.php:40

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.07 ms After last query: 0.14 ms Query memory: 0.021 MB Memory before query: 25.909 MB Rows returned: 15

SELECT *

  FROM myme2_rsform_config

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	myme2_rsform_config	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	15

Profile

Status	Duration
starting	0.0 ms
Waiting for query cache lock	0.0 ms
checking query cache for query	0.0 ms
checking privileges on cached	0.0 ms
checking permissions	0.0 ms
sending cached result to clien	0.0 ms
logging slow query	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT/administrator/components/com_rsform/helpers/config.php:50

JROOT/administrator/components/com_rsform/helpers/config.php:17

JROOT/administrator/components/com_rsform/helpers/config.php:97

JROOT/administrator/components/com_rsform/helpers/rsform.php:354

JROOT/administrator/components/com_rsform/helpers/rsform.php:2406

JROOT/administrator/components/com_rsform/helpers/rsform.php:1745

JROOT/administrator/components/com_rsform/helpers/rsform.php:274

JROOT/plugins/system/rsform/rsform.php:126

JROOT/libraries/joomla/event/event.php:69

JROOT/libraries/joomla/event/dispatcher.php:160

JROOT/libraries/joomla/application/base.php:83

JROOT/libraries/cms/application/cms.php:1065

JROOT/libraries/cms/application/site.php:729

JROOT/libraries/cms/application/cms.php:258

JROOT/index.php:40

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.08 ms After last query: 0.33 ms Query memory: 0.016 MB Memory before query: 25.937 MB Rows returned: 0

SELECT c.*,p.PropertyValue AS ComponentName 
  FROM `myme2_rsform_conditions` c 
  LEFT JOIN myme2_rsform_properties p 
  ON (c.component_id = p.ComponentId) 
  LEFT JOIN myme2_rsform_components comp 
  ON (comp.ComponentId=p.ComponentId) 
  WHERE c.`form_id` = 3 
  AND c.lang_code='en-GB' 
  AND comp.Published = 1 
  AND p.PropertyName='NAME' 
  ORDER BY c.`id` ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

Profile

Status	Duration
starting	0.0 ms
Waiting for query cache lock	0.0 ms
checking query cache for query	0.0 ms
checking privileges on cached	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
sending cached result to clien	0.0 ms
logging slow query	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT/administrator/components/com_rsform/helpers/rsform.php:1544

JROOT/administrator/components/com_rsform/helpers/rsform.php:1876

JROOT/administrator/components/com_rsform/helpers/rsform.php:274

JROOT/plugins/system/rsform/rsform.php:126

JROOT/libraries/joomla/event/event.php:69

JROOT/libraries/joomla/event/dispatcher.php:160

JROOT/libraries/joomla/application/base.php:83

JROOT/libraries/cms/application/cms.php:1065

JROOT/libraries/cms/application/site.php:729

JROOT/libraries/cms/application/cms.php:258

JROOT/index.php:40

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.07 ms After last query: 0.06 ms Query memory: 0.016 MB Memory before query: 25.953 MB Rows returned: 0

SELECT * 
  FROM myme2_rsform_calculations 
  WHERE formId = 3 
  ORDER BY `ordering`

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

Profile

Status	Duration
starting	0.0 ms
Waiting for query cache lock	0.0 ms
checking query cache for query	0.0 ms
checking privileges on cached	0.0 ms
checking permissions	0.0 ms
sending cached result to clien	0.0 ms
logging slow query	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT/administrator/components/com_rsform/helpers/rsform.php:4375

JROOT/administrator/components/com_rsform/helpers/rsform.php:1927

JROOT/administrator/components/com_rsform/helpers/rsform.php:274

JROOT/plugins/system/rsform/rsform.php:126

JROOT/libraries/joomla/event/event.php:69

JROOT/libraries/joomla/event/dispatcher.php:160

JROOT/libraries/joomla/application/base.php:83

JROOT/libraries/cms/application/cms.php:1065

JROOT/libraries/cms/application/site.php:729

JROOT/libraries/cms/application/cms.php:258

JROOT/index.php:40

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.06 ms After last query: 0.07 ms Query memory: 0.016 MB Memory before query: 25.969 MB Rows returned: 0

SELECT ComponentId 
  FROM myme2_rsform_components 
  WHERE ComponentTypeId='212' 
  AND FormId='3' 
  AND Published='1'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	myme2_rsform_components	ref	ComponentTypeId,FormId	ComponentTypeId	4	const	1	Using where

Profile

Status	Duration
starting	0.0 ms
Waiting for query cache lock	0.0 ms
checking query cache for query	0.0 ms
checking privileges on cached	0.0 ms
checking permissions	0.0 ms
sending cached result to clien	0.0 ms
logging slow query	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT/administrator/components/com_rsform/helpers/rsform.php:1494

JROOT/administrator/components/com_rsform/helpers/rsform.php:1945

JROOT/administrator/components/com_rsform/helpers/rsform.php:274

JROOT/plugins/system/rsform/rsform.php:126

JROOT/libraries/joomla/event/event.php:69

JROOT/libraries/joomla/event/dispatcher.php:160

JROOT/libraries/joomla/application/base.php:83

JROOT/libraries/cms/application/cms.php:1065

JROOT/libraries/cms/application/site.php:729

JROOT/libraries/cms/application/cms.php:258

JROOT/index.php:40

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.37 ms After last query: 7.24 ms Query memory: 0.003 MB Memory before query: 25.772 MB

UPDATE `myme2_session`

  SET `data` = '__default|a:15:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1435808450;s:18:\"session.timer.last\";i:1435808450;s:17:\"session.timer.now\";i:1435808450;s:22:\"session.client.browser\";s:11:\"ia_archiver\";s:8:\"registry\";O:24:\"Joomla\\Registry\\Registry\":2:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}s:9:\"separator\";s:1:\".\";}s:4:\"user\";O:5:\"JUser\":26:{s:9:\"\\0\\0\\0isRoot\";N;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:1:{i:0;s:1:\"1\";}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:12:\"requireReset\";N;s:10:\"\\0\\0\\0_params\";O:24:\"Joomla\\Registry\\Registry\":2:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}s:9:\"separator\";s:1:\".\";}s:14:\"\\0\\0\\0_authGroups\";a:1:{i:0;i:1;}s:14:\"\\0\\0\\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}s:15:\"\\0\\0\\0_authActions\";N;s:12:\"\\0\\0\\0_errorMsg\";N;s:13:\"\\0\\0\\0userHelper\";O:18:\"JUserWrapperHelper\":0:{}s:10:\"\\0\\0\\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:19:\"js_id_currency_orig\";s:1:\"2\";s:14:\"js_id_currency\";s:1:\"2\";s:19:\"js_history_sel_lang\";s:5:\"en-GB\";s:15:\"js_prev_user_id\";i:0;s:22:\"jshop_checked_language\";a:1:{i:0;s:5:\"en-GB\";}s:26:\"jshop_end_page_buy_product\";s:45:\"/shop/mandolins/gibson-1921-a2-mandolin-64574\";s:18:\"product_back_value\";a:0:{}s:13:\"session.token\";s:32:\"0b2f19ed6540691e6748b361a44770d8\";}'
	, `time` = '1435808450'

  WHERE `session_id` = 'de94378afcb47e57431b795eda67dffc'

Explain

EXPLAIN not possible on query: UPDATE `myme2_session` SET `data` = '__default|a:15:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1435808450;s:18:\"session.timer.last\";i:1435808450;s:17:\"session.timer.now\";i:1435808450;s:22:\"session.client.browser\";s:11:\"ia_archiver\";s:8:\"registry\";O:24:\"Joomla\\Registry\\Registry\":2:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}s:9:\"separator\";s:1:\".\";}s:4:\"user\";O:5:\"JUser\":26:{s:9:\"\\0\\0\\0isRoot\";N;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:1:{i:0;s:1:\"1\";}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:12:\"requireReset\";N;s:10:\"\\0\\0\\0_params\";O:24:\"Joomla\\Registry\\Registry\":2:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}s:9:\"separator\";s:1:\".\";}s:14:\"\\0\\0\\0_authGroups\";a:1:{i:0;i:1;}s:14:\"\\0\\0\\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}s:15:\"\\0\\0\\0_authActions\";N;s:12:\"\\0\\0\\0_errorMsg\";N;s:13:\"\\0\\0\\0userHelper\";O:18:\"JUserWrapperHelper\":0:{}s:10:\"\\0\\0\\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:19:\"js_id_currency_orig\";s:1:\"2\";s:14:\"js_id_currency\";s:1:\"2\";s:19:\"js_history_sel_lang\";s:5:\"en-GB\";s:15:\"js_prev_user_id\";i:0;s:22:\"jshop_checked_language\";a:1:{i:0;s:5:\"en-GB\";}s:26:\"jshop_end_page_buy_product\";s:45:\"/shop/mandolins/gibson-1921-a2-mandolin-64574\";s:18:\"product_back_value\";a:0:{}s:13:\"session.token\";s:32:\"0b2f19ed6540691e6748b361a44770d8\";}' , `time` = '1435808450' WHERE `session_id` = 'de94378afcb47e57431b795eda67dffc'

Profile

Status	Duration
starting	0.1 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
System lock	0.0 ms
init	0.0 ms
Updating	0.1 ms
end	0.0 ms
Waiting for query cache lock	0.0 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
logging slow query	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT/libraries/joomla/session/storage/database.php:84

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

61 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

4 × SELECT * 
  FROM myme2_jshopping_categories

3 × SELECT `Lang` 
  FROM myme2_rsform_forms

3 × SELECT ComponentId 
  FROM myme2_rsform_components

2 × SELECT * 
  FROM myme2_jshopping_products

2 × SELECT `name_en-GB` as name,`description_en-GB` as description,`short_description_en-GB` as short_description, category_id, category_publish, ordering, category_image 
  FROM `myme2_jshopping_categories`

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

1 × SELECT category_parent_id 
  FROM `myme2_jshopping_categories`

1 × SELECT I.*, IF(P.image=I.image_name,0,1) as sort 
  FROM `myme2_jshopping_products_images` as I 
  left join `myme2_jshopping_products` as P 
  on P.product_id=I.product_id

1 × select manufacturer_id as id, `name_en-GB` as name, manufacturer_logo, manufacturer_url 
  from myme2_jshopping_manufacturers

1 × SELECT id, `name_en-GB` as name, field_id 
  FROM `myme2_jshopping_products_extra_field_values`

1 × SELECT id, image, `name_en-GB` as name 
  FROM `myme2_jshopping_product_labels`

1 × SELECT tax_id, tax_name, tax_value 
  FROM `myme2_jshopping_taxes

1 × SELECT `FormId`, `FormLayout`, `ScriptDisplay`, `ErrorMessage`, `FormTitle`, `CSS`, `JS`, `CSSClass`, `CSSId`, `CSSName`, `CSSAction`, `CSSAdditionalAttributes`, `AjaxValidation`, `ThemeParams` 
  FROM myme2_rsform_forms

1 × SELECT FormId 
  FROM myme2_rsform_components

1 × SELECT * 
  FROM myme2_rsform_confi

1 × SELECT c.*,p.PropertyValue AS ComponentName 
  FROM `myme2_rsform_conditions` c 
  LEFT JOIN myme2_rsform_properties p 
  ON (c.component_id = p.ComponentId) 
  LEFT JOIN myme2_rsform_components comp 
  ON (comp.ComponentId=p.ComponentId)

1 × SELECT * 
  FROM myme2_rsform_calculations

1 × SELECT `PropertyName`, `PropertyValue`, `ComponentId` 
  FROM myme2_rsform_properties

1 × SELECT p.PropertyValue AS name, c.ComponentId, c.ComponentTypeId, ct.ComponentTypeName, c.
  Order 
  FROM myme2_rsform_properties p 
  LEFT JOIN myme2_rsform_components c 
  ON (c.ComponentId=p.ComponentId) 
  LEFT JOIN myme2_rsform_component_types ct 
  ON (ct.ComponentTypeId=c.ComponentTypeId)

1 × SELECT prod.product_id, pr_cat.category_id, prod.`name_en-GB` as name, prod.`short_description_en-GB` as short_description, prod.product_ean, prod.image, prod.product_price, prod.currency_id, prod.product_tax_id as tax_id, prod.product_old_price, prod.product_weight, prod.average_rating, prod.reviews_count, prod.hits, prod.weight_volume_units, prod.basic_price_unit_id, prod.label_id, prod.product_manufacturer_id, prod.min_price, prod.product_quantity, prod.different_prices, prod.`extra_field_3` , prod.`extra_field_4` , prod.`extra_field_5` , prod.`extra_field_9` , prod.`extra_field_16` , prod.`extra_field_17` , prod.`extra_field_18` , prod.`extra_field_13` , prod.`extra_field_19` , prod.`extra_field_22` , prod.`extra_field_14` , prod.`extra_field_20` , prod.`extra_field_10` , prod.`extra_field_23`  
  FROM `myme2_jshopping_products_relations` AS relation
                 
  INNER JOIN `myme2_jshopping_products` AS prod 
  ON relation.product_related_id = prod.product_id
                 
  LEFT JOIN `myme2_jshopping_products_to_categories` AS pr_cat 
  ON pr_cat.product_id = relation.product_related_id
                 
  LEFT JOIN `myme2_jshopping_categories` AS cat 
  ON pr_cat.category_id = cat.category_id

1 × SELECT Published, FormTitle, MetaTitle, MetaDesc, MetaKeywords, ShowThankyou, Access 
  FROM myme2_rsform_forms

1 × SELECT `FormId`, `FormLayoutName`, `FormLayout`, `ScriptDisplay`, `ErrorMessage`, `FormTitle`, `CSS`, `JS`, `CSSClass`, `CSSId`, `CSSName`, `CSSAction`, `CSSAdditionalAttributes`, `AjaxValidation`, `ThemeParams` 
  FROM myme2_rsform_forms

1 × SELECT *  
  FROM myme2_jmap_metainfo

1 × SELECT * 
  FROM `myme2_jshopping_products_to_categories`

1 × SELECT * 
  FROM `myme2_admintools_ipautoban`

1 × SELECT `ip` 
  FROM `myme2_admintools_ipblock

1 × SELECT * 
  FROM `myme2_admintools_wafblacklists`

1 × SELECT `word` 
  FROM `myme2_admintools_badwords` 
  GROUP BY `word

1 × SELECT `enabled` 
  FROM `myme2_extensions`

1 × SELECT `value` 
  FROM `myme2_admintools_storage`

1 × SELECT `session_id` 
  FROM `myme2_session`

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

1 × SELECT id, rules 
  FROM `myme2_viewlevels

1 × SELECT `query` 
  FROM `myme2_admintools_wafexceptions`

1 × SELECT `source`,`keepurlparams` 
  FROM `myme2_admintools_redirects`

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 myme2_menu AS m 
  LEFT JOIN myme2_extensions AS e 
  ON m.component_id = e.extension_id

```
1 × select id,link 
  from myme2_menu
```

1 × select category_id as id, `alias_en-GB` as alias 
  from myme2_jshopping_categories

1 × select * 
  from myme2_jshopping_language

1 × SELECT `data` 
  FROM `myme2_session`

1 × SELECT params 
  FROM myme2_extensions

1 × SELECT element,views,context,types,params 
  FROM myme2_ark_editor_inline_views

1 × SELECT * 
  FROM myme2_jshopping_config

1 × SELECT currency_id, currency_name, currency_code, currency_code_iso, currency_value 
  FROM `myme2_jshopping_currencies`

1 × select product_id as id, `alias_en-GB` as alias 
  from myme2_jshopping_products

1 × SELECT F.id, F.`name_en-GB` as name, F.`description_en-GB` as description, F.allcats, F.type, F.cats, F.ordering, F.`
  group`, G.`name_en-GB` as groupname, multilist 
  FROM `myme2_jshopping_products_extra_fields` as F 
  left join `myme2_jshopping_products_extra_field_groups` as G 
  on G.id=F.
  group

OTHER Tables:

1 × SHOW FULL COLUMNS 
  FROM `myme2_jshopping_product_labels

1 × SHOW FULL COLUMNS 
  FROM `myme2_jshopping_products_extra_field_values

1 × SHOW FULL COLUMNS 
  FROM `myme2_jshopping_categories

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

1 × UPDATE `myme2_session` 
  SET `data` = '__default|a:15:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1435808450;s:18:\"session.timer.last\";i:1435808450;s:17:\"session.timer.now\";i:1435808450;s:22:\"session.client.browser\";s:11:\"ia_archiver\";s:8:\"registry\";O:24:\"Joomla\\Registry\\Registry\":2:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}s:9:\"separator\";s:1:\".\";}s:4:\"user\";O:5:\"JUser\":26:{s:9:\"\\0\\0\\0isRoot\";N;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:1:{i:0;s:1:\"1\";}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:12:\"requireReset\";N;s:10:\"\\0\\0\\0_params\";O:24:\"Joomla\\Registry\\Registry\":2:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}s:9:\"separator\";s:1:\".\";}s:14:\"\\0\\0\\0_authGroups\";a:1:{i:0;i:1;}s:14:\"\\0\\0\\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}s:15:\"\\0\\0\\0_authActions\";N;s:12:\"\\0\\0\\0_errorMsg\";N;s:13:\"\\0\\0\\0userHelper\";O:18:\"JUserWrapperHelper\":0:{}s:10:\"\\0\\0\\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:19:\"js_id_currency_orig\";s:1:\"2\";s:14:\"js_id_currency\";s:1:\"2\";s:19:\"js_history_sel_lang\";s:5:\"en-GB\";s:15:\"js_prev_user_id\";i:0;s:22:\"jshop_checked_language\";a:1:{i:0;s:5:\"en-GB\";}s:26:\"jshop_end_page_buy_product\";s:45:\"/shop/mandolins/gibson-1921-a2-mandolin-64574\";s:18:\"product_back_value\";a:0:{}s:13:\"session.token\";s:32:\"0b2f19ed6540691e6748b361a44770d8\";}'  , `time` = '1435808450'

1 × SHOW FULL COLUMNS 
  FROM `myme2_jshopping_products_reviews

1 × SHOW FULL COLUMNS 
  FROM `myme2_jshopping_taxes

1 × SHOW FULL COLUMNS 
  FROM `myme2_jshopping_users

1 × SHOW FULL COLUMNS 
  FROM `myme2_jshopping_config

1 × SHOW VARIABLES LIKE "collation_database

1 × SHOW FULL COLUMNS 
  FROM `myme2_jshopping_currencies

1 × UPDATE `myme2_extensions` 
  SET `params` = '{\"mediaversion\":\"a9c377121dd170325457442ac6a15686\"}'

1 × SHOW FULL COLUMNS 
  FROM `myme2_jshopping_products_extra_fields

1 × SHOW FULL COLUMNS 
  FROM `myme2_jshopping_products

1 × INSERT INTO `myme2_session` (`session_id`, `client_id`, `time`) 
  VALUES  ('de94378afcb47e57431b795eda67dffc', 0, '1435808450'

Gibson 1921 A2 Mandolin (Code: 64574)

Request More Information

Accepted Payment Methods

Shipping Policy

Return Policy

In Store Purchases

Care and Feeding of a Solid Wood Instrument

For the Dry Months

For the Wet Months

Browse By Category

Joomla! Debug Console

Session

__default

Profile Information

Time

Memory

Memory Usage

Database Queries

70 Queries Logged 21.0 ms

7 duplicate found!

61 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

OTHER Tables: