SELECT *
FROM `sharden_components`
WHERE `parent` = 0
0.00015 sec (explain)SELECT `folder` AS `type`, `element` AS `name`, `params`
FROM `sharden_plugins`
WHERE `published` >= 1
AND `access` <= 0
ORDER BY `ordering`
8.0E-5 sec (explain)SELECT m.*, c.`option` AS component
FROM sharden_menu AS m
LEFT JOIN sharden_components AS c ON m.componentid = c.id
WHERE m.lang="en-GB"
AND m.published = 1
ORDER BY m.sublevel, m.parent, m.ordering
0.00016 sec (explain)SELECT template
FROM sharden_templates_menu
WHERE lang="en-GB"
AND client_id = 0
AND (menuid = 0 OR menuid = 9)
ORDER BY menuid DESC
LIMIT 0, 1
9.0E-5 sec (explain)SELECT a.*, u.name AS author, u.usertype, cc.title AS category, s.title AS section, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, g.name AS groups, s.published AS sec_pub, cc.published AS cat_pub, s.access AS sec_access, cc.access AS cat_access
FROM sharden_content AS a
LEFT JOIN sharden_categories AS cc ON cc.id = a.catid
LEFT JOIN sharden_sections AS s ON s.id = cc.section
AND s.scope = "content"
LEFT JOIN sharden_users AS u ON u.id = a.created_by
LEFT JOIN sharden_groups AS g ON a.access = g.id
WHERE a.id = 621
AND ( ( a.created_by = 0 ) OR ( a.state = 1
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2013-06-19 02:20:00' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2013-06-19 02:20:00' ) ) OR ( a.state = -1 ) )
0.07486 sec (explain)UPDATE sharden_content
SET hits = ( hits + 1 )
WHERE id='621'
0.00268 secSELECT `id`, `url`
FROM `sharden_pseudocron`
WHERE 1371608401 - `runtime` >= `updated`
AND `status`="1"
LIMIT 1
0.0233 sec (explain)UPDATE `sharden_pseudocron`
SET `updated`=1371608401
WHERE `id`=3
0.0003 secSELECT id, title, module, position, content, showtitle, control, params
FROM sharden_modules AS m
LEFT JOIN sharden_modules_menu AS mm ON mm.moduleid = m.id
WHERE lang="en-GB"
AND m.published = 1
AND m.access <= 0
AND m.client_id = 0
AND ( mm.menuid = 9 OR mm.menuid = 0 )
ORDER BY position, ordering
0.00016 sec (explain)SELECT `r`.*, `l`.`title`, `l`.`description`
FROM `sharden_hotel_rooms_type` AS `r`
LEFT JOIN `sharden_hotel_rooms_type_lang` AS `l` ON `l`.`parent_id`=`r`.`id`
WHERE `published`=1
AND l.lang ='en-GB'
GROUP BY `r`.`id`
ORDER BY `l`.`title`
0.00013 sec (explain)SELECT *
FROM sharden_currency_rates
WHERE `id` = "14" OR `id` = "36" OR `id` = "43"
ORDER BY id ASC
7.0E-5 sec (explain)SELECT DAYOFMONTH(CONVERT_TZ(`a`.`publish_up`, "+00:00", "+04:00")) AS `days`, YEAR(CONVERT_TZ(`a`.`publish_up`, "+00:00", "+04:00")) AS `year`, MONTH(CONVERT_TZ(`a`.`publish_up`, "+00:00", "+04:00")) AS `MONTH`
FROM `sharden_content` AS `a`
LEFT JOIN `sharden_categories` AS `cc` ON `cc`.`id` = `a`.`catid`
LEFT JOIN `sharden_sections` AS `s` ON `s`.`id` = `a`.`sectionid`
WHERE (YEAR(CONVERT_TZ(`a`.`publish_up`, "+00:00", "+04:00")) ='2013' )
AND (MONTH(CONVERT_TZ(`a`.`publish_up`, "+00:00", "+04:00")) ='06' )
AND (`s`.`published` =1)
AND (`cc`.`published` =1)
AND (`a`.`state` = 1)
AND (`a`.`publish_up` = '0000-00-00 00:00:00' OR `a`.`publish_up` <= '2013-06-19 02:20' )
AND (`a`.`publish_down` = '0000-00-00 00:00:00' OR `a`.`publish_down` >= '2013-06-19 02:20' )
AND (`a`.`lang`='en-GB')
AND (`a`.`catid` NOT IN(140,149,157))
GROUP BY `days`
0.00095 sec (explain)SELECT DAYOFMONTH(CONVERT_TZ(`a`.`publish_down`, "+00:00", "+04:00")) AS `days`, YEAR(CONVERT_TZ(`a`.`publish_down`, "+00:00", "+04:00")) AS `year`, MONTH(CONVERT_TZ(`a`.`publish_down`, "+00:00", "+04:00")) AS `MONTH`, `a`.`publish_down`
FROM `sharden_content` AS `a`
LEFT JOIN `sharden_categories` AS `cc` ON `cc`.`id` = `a`.`catid`
LEFT JOIN `sharden_sections` AS `s` ON `s`.`id` = `a`.`sectionid`
WHERE (YEAR(CONVERT_TZ(`a`.`publish_down`, "+00:00", "+04:00")) ='2013' )
AND (MONTH(CONVERT_TZ(`a`.`publish_down`, "+00:00", "+04:00")) ='06' )
AND (`s`.`published` =1)
AND (`cc`.`published` =1)
AND (`a`.`state` = 1)
AND (`a`.`catid` IN (140,149,157))
AND (`a`.`publish_down` >= '2013-06-19 02:20' )
AND (`a`.`lang`='en-GB')
GROUP BY `days`
0.00047 sec (explain)SELECT DAYOFMONTH(CONVERT_TZ(`a`.`publish_up`, "+00:00", "+04:00")) AS `days`, YEAR(CONVERT_TZ(`a`.`publish_up`, "+00:00", "+04:00")) AS `year`, MONTH(CONVERT_TZ(`a`.`publish_up`, "+00:00", "+04:00")) AS `MONTH`
FROM `sharden_content` AS `a`
LEFT JOIN `sharden_categories` AS `cc` ON `cc`.`id` = `a`.`catid`
LEFT JOIN `sharden_sections` AS `s` ON `s`.`id` = `a`.`sectionid`
WHERE (YEAR(CONVERT_TZ(`a`.`publish_up`, "+00:00", "+04:00")) ='2013' )
AND (MONTH(CONVERT_TZ(`a`.`publish_up`, "+00:00", "+04:00")) ='06' )
AND (`s`.`published` =1)
AND (`cc`.`published` =1)
AND (`a`.`state` = 1)
AND (`a`.`publish_up` = '0000-00-00 00:00:00' OR `a`.`publish_up` <= '2013-06-19 02:20' )
AND (`a`.`publish_down` = '0000-00-00 00:00:00' OR `a`.`publish_down` >= '2013-06-19 02:20' )
AND (`a`.`lang`='en-GB')
AND (`a`.`catid` NOT IN(140,149,157))
GROUP BY `days`
6.0E-5 sec (explain)SELECT DAYOFMONTH(CONVERT_TZ(`a`.`publish_down`, "+00:00", "+04:00")) AS `days`, YEAR(CONVERT_TZ(`a`.`publish_down`, "+00:00", "+04:00")) AS `year`, MONTH(CONVERT_TZ(`a`.`publish_down`, "+00:00", "+04:00")) AS `MONTH`, `a`.`publish_down`
FROM `sharden_content` AS `a`
LEFT JOIN `sharden_categories` AS `cc` ON `cc`.`id` = `a`.`catid`
LEFT JOIN `sharden_sections` AS `s` ON `s`.`id` = `a`.`sectionid`
WHERE (YEAR(CONVERT_TZ(`a`.`publish_down`, "+00:00", "+04:00")) ='2013' )
AND (MONTH(CONVERT_TZ(`a`.`publish_down`, "+00:00", "+04:00")) ='06' )
AND (`s`.`published` =1)
AND (`cc`.`published` =1)
AND (`a`.`state` = 1)
AND (`a`.`catid` IN (140,149,157))
AND (`a`.`publish_down` >= '2013-06-19 02:20' )
AND (`a`.`lang`='en-GB')
GROUP BY `days`
5.0E-5 sec (explain)
- - -
