Retail Diversity Map 2017
An interactive map was developed showing the diversity of food retail in Hanoi, Vietnam in 2017 as part of the project
“Retail Diversity for Dietary Diversity (RD4DD)”
An interactive map was developed showing the diversity of food retail in Hanoi, Vietnam in 2017 as part of the project
“Retail Diversity for Dietary Diversity (RD4DD)”
Fresh Studio ©2013
session.client.browser ⇒ CCBot/2.0 (https://commoncrawl.org/faq/)
password_clear ⇒
groups ⇒
link ⇒ https://freshstudio.vn/index.php/rd4ddmap
Application 0.000 seconds (+0.000); 0.34 MB (+0.338) - afterLoad
Application 0.090 seconds (+0.090); 1.50 MB (+1.163) - afterInitialise
Application 0.120 seconds (+0.031); 2.06 MB (+0.558) - afterRoute
Application 0.191 seconds (+0.070); 2.80 MB (+0.746) - afterDispatch
Application 0.200 seconds (+0.009); 2.92 MB (+0.115) - beforeRenderModule mod_menu (Footer Menu)
Application 0.205 seconds (+0.006); 2.95 MB (+0.026) - afterRenderModule mod_menu (Footer Menu)
Application 0.205 seconds (+0.000); 2.94 MB (-0.007) - beforeRenderModule mod_custom (Copyright)
Application 0.207 seconds (+0.002); 2.95 MB (+0.010) - afterRenderModule mod_custom (Copyright)
Application 0.208 seconds (+0.000); 2.95 MB (-0.003) - beforeRenderModule mod_custom (Footer - Social media)
Application 0.208 seconds (+0.001); 2.95 MB (+0.004) - afterRenderModule mod_custom (Footer - Social media)
Application 0.209 seconds (+0.000); 2.95 MB (-0.001) - beforeRenderModule mod_menu (Main Menu)
Application 0.216 seconds (+0.008); 3.00 MB (+0.049) - afterRenderModule mod_menu (Main Menu)
Application 0.243 seconds (+0.026); 3.01 MB (+0.015) - afterRender
3.01 MB (3,157,080 Bytes)
SELECT `data`
FROM `fr_session`
WHERE `session_id` = '0rfgb4jfpiagvvvk8594v0qdg7'
DELETE
FROM `fr_session`
WHERE `time` < '1618424657'
SELECT `session_id`
FROM `fr_session`
WHERE `session_id` = '0rfgb4jfpiagvvvk8594v0qdg7'
LIMIT 0, 1
INSERT INTO `fr_session`
(`session_id`, `client_id`, `time`)
VALUES
('0rfgb4jfpiagvvvk8594v0qdg7', 0, '1618428257')
SELECT extension_id AS id, element AS "option", params, enabled
FROM fr_extensions
WHERE `type` = 'component'
AND `element` = 'com_users'
SELECT b.id
FROM fr_usergroups AS a
LEFT JOIN fr_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 1
SELECT id, rules
FROM `fr_viewlevels`
SELECT folder AS type, element AS name, params
FROM fr_extensions
WHERE enabled >= 1
AND type ='plugin'
AND state >= 0
AND access IN (1,1)
ORDER BY ordering
SELECT extension_id AS id, element AS "option", params, enabled
FROM fr_extensions
WHERE `type` = 'component'
AND `element` = 'com_languages'
SELECT `enabled`
FROM `fr_extensions`
WHERE `element` = 'com_akeeba'
AND `type` = 'component'
SELECT extension_id AS id, element AS "option", params, enabled
FROM fr_extensions
WHERE `type` = 'component'
AND `element` = 'com_k2'
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 fr_menu AS m
LEFT JOIN fr_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
SELECT id, home, template, s.params
FROM fr_template_styles as s
LEFT JOIN fr_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
WHERE s.client_id = 0
AND e.enabled = 1
SELECT *
FROM fr_languages
WHERE published=1
ORDER BY ordering ASC
SELECT a.rules
FROM fr_assets AS a
WHERE (a.id = 1)
GROUP BY a.id, a.rules, a.lft
SELECT b.rules
FROM fr_assets AS a
LEFT JOIN fr_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE (a.name = 'com_k2')
GROUP BY b.id, b.rules, b.lft
ORDER BY b.lft
SELECT id
FROM fr_k2_categories
WHERE published=1
AND trash=0
AND access IN(1,1)
SELECT *
FROM fr_k2_items
WHERE id=399
LIMIT 0, 1
SHOW FULL COLUMNS
FROM `fr_k2_categories`
SELECT *
FROM fr_k2_categories
WHERE id = '36'
SELECT tag.*
FROM fr_k2_tags AS tag
JOIN fr_k2_tags_xref AS xref
ON tag.id = xref.tagID
WHERE tag.published=1
AND xref.itemID = 399
ORDER BY xref.id ASC
SELECT COUNT(*)
FROM fr_k2_comments
WHERE itemID=399
AND published=1
SHOW FULL COLUMNS
FROM `fr_k2_items`
UPDATE fr_k2_items
SET `hits` = (`hits` + 1)
WHERE id = '399'
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM fr_modules AS m
LEFT JOIN fr_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN fr_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 <= '2021-04-14 19:24:17')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2021-04-14 19:24:17')
AND m.access IN (1,1)
AND m.client_id = 0
AND (mm.menuid = 177 OR mm.menuid <= 0)
ORDER BY m.position, m.ordering
UPDATE `fr_session`
SET `data` = '__default|a:8:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1618428257;s:18:\"session.timer.last\";i:1618428257;s:17:\"session.timer.now\";i:1618428257;s:22:\"session.client.browser\";s:40:\"CCBot/2.0 (https://commoncrawl.org/faq/)\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":26:{s:9:\"\0*\0isRoot\";b:0;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:8:\"usertype\";N;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:0:{}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:14:\"\0*\0_authGroups\";a:1:{i:0;i:1;}s:14:\"\0*\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;s:3:\"gid\";i:1;}s:16:\"com_mailto.links\";a:1:{s:40:\"49a1d39a025b725ead13e2f16a408928948136e8\";O:8:\"stdClass\":2:{s:4:\"link\";s:41:\"https://freshstudio.vn/index.php/rd4ddmap\";s:6:\"expiry\";i:1618428257;}}}'
, `time` = '1618428257'
WHERE `session_id` = '0rfgb4jfpiagvvvk8594v0qdg7'
3 × SELECT extension_id AS id, element AS "option", params, enabled
FROM fr_extensions
1 × SELECT *
FROM fr_k2_items
1 × SELECT id
FROM fr_k2_categories
1 × SELECT *
FROM fr_k2_categories
1 × SELECT b.rules
FROM fr_assets AS a
LEFT JOIN fr_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
1 × SELECT tag.*
FROM fr_k2_tags AS tag JOIN fr_k2_tags_xref AS xref
ON tag.id = xref.tagID
1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM fr_modules AS m
LEFT JOIN fr_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN fr_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
1 × SELECT COUNT(*)
FROM fr_k2_comments
1 × SELECT a.rules
FROM fr_assets AS a
1 × SELECT id, home, template, s.params
FROM fr_template_styles as s
LEFT JOIN fr_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
1 × SELECT id, rules
FROM `fr_viewlevels
1 × SELECT b.id
FROM fr_usergroups AS a
LEFT JOIN fr_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
1 × SELECT `session_id`
FROM `fr_session`
1 × SELECT folder AS type, element AS name, params
FROM fr_extensions
1 × SELECT `enabled`
FROM `fr_extensions`
1 × SELECT `data`
FROM `fr_session`
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 fr_menu AS m
LEFT JOIN fr_extensions AS e
ON m.component_id = e.extension_id
1 × SELECT *
FROM fr_languages
1 × UPDATE fr_k2_items
SET `hits` = (`hits` + 1)
1 × UPDATE `fr_session`
SET `data` = '__default|a:8:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1618428257;s:18:\"session.timer.last\";i:1618428257;s:17:\"session.timer.now\";i:1618428257;s:22:\"session.client.browser\";s:40:\"CCBot/2.0 (https://commoncrawl.org/faq/)\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":26:{s:9:\"\0*\0isRoot\";b:0;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:8:\"usertype\";N;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:0:{}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:14:\"\0*\0_authGroups\";a:1:{i:0;i:1;}s:14:\"\0*\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;s:3:\"gid\";i:1;}s:16:\"com_mailto.links\";a:1:{s:40:\"49a1d39a025b725ead13e2f16a408928948136e8\";O:8:\"stdClass\":2:{s:4:\"link\";s:41:\"https://freshstudio.vn/index.php/rd4ddmap\";s:6:\"expiry\";i:1618428257;}}}' , `time` = '1618428257'
1 × SHOW FULL COLUMNS
FROM `fr_k2_items
1 × SHOW FULL COLUMNS
FROM `fr_k2_categories
1 × INSERT INTO `fr_session` (`session_id`, `client_id`, `time`)
VALUES ('0rfgb4jfpiagvvvk8594v0qdg7', 0, '1618428257'
1 × DELETE
FROM `fr_session`