Fruit and vegetables in Bratislava

SELECT COUNT(pid) FROM url_alias

0.3

SELECT src FROM url_alias WHERE dst = 'business/category/fruit-vegetables/slovakia/bratislava'

0.29

module_list

SELECT name, filename, throttle FROM system WHERE type = 'module' AND status = 1 ORDER BY weight ASC, filename ASC

0.25

SELECT src FROM url_alias WHERE dst = 'business'

0.31

SELECT dst FROM url_alias WHERE src = 'lm_paypal/ipn'

0.37

list_themes

SELECT * FROM system WHERE type = 'theme'

0.3

SELECT dst FROM url_alias WHERE src = 'sites/all/themes/slovakiacompany/'

0.28

user_access

SELECT DISTINCT(p.perm) FROM role r INNER JOIN permission p ON p.rid = r.rid WHERE r.rid IN (1)

0.5

SELECT data, created, headers, expire FROM cache_menu WHERE cid = '0:en'

0.44

business_display_businesses

SELECT dst FROM url_alias WHERE src = 'business/category/fruit-vegetables/slovakia/bratislava'

0.51

globalredirect_init

SELECT dst FROM url_alias WHERE dst = 'business/category/fruit-vegetables/slovakia/bratislava'

30.76

business_get_insane

SELECT * FROM content_type_business b WHERE 1 AND field_business_city_sane_value = 'bratislava' AND field_business_category_sane_value = 'fruit-vegetables' LIMIT 1

642.8

SELECT b.*, u.dst, n.sticky FROM content_type_business b, url_alias u, node n WHERE 1 AND n.nid = b.nid AND u.src = CONCAT( 'node/', CONVERT( b.nid USING utf8 ) ) AND field_business_region_sane_value = 'slovakia' AND field_business_city_sane_value = 'bratislava' AND b.field_business_category_sane_value = 'fruit-vegetables' ORDER BY n.sticky DESC, b.field_business_name_sane_value

0.42

SELECT dst FROM url_alias WHERE src = 'company/bratislava/fruit-vegetables/asparagus-spol-s-ro-fd5.html'

0.33

SELECT dst FROM url_alias WHERE src = 'company/bratislava/fruit-vegetables/yami-sro-d28.html'

0.13

SELECT dst FROM url_alias WHERE src = 'business/slovakia'

0.13

SELECT dst FROM url_alias WHERE src = 'business/slovakia/'

0.18

SELECT dst FROM url_alias WHERE src = 'business'

0.12

system_region_list

SELECT * FROM system WHERE type = 'theme' AND name = 'slovakiacompany'

0.14

_node_types_build

SELECT nt.type, nt.* FROM node_type nt ORDER BY nt.type ASC

0.13

block_list

SELECT DISTINCT b.* FROM blocks b LEFT JOIN blocks_roles r ON b.module = r.module AND b.delta = r.delta WHERE b.theme = 'slovakiacompany' AND b.status = 1 AND (r.rid IN (1) OR r.rid IS NULL) ORDER BY b.region, b.weight, b.module

0.24

SELECT data, created, headers, expire FROM cache_block WHERE cid = 'bc_40::_http://www.slovakiacompany.com'

0.19

block_block

SELECT body, format FROM boxes WHERE bid = 3

0.32

SELECT data, created, headers, expire FROM cache_filter WHERE cid = '2:af16d2772a39be61a60ef773ec81f0a3'

0.16

filter_format_allowcache

SELECT cache FROM filter_formats WHERE format = 2

0.15

filter_list_format

SELECT * FROM filters WHERE format = 2 ORDER BY weight ASC

0.23

SELECT dst FROM url_alias WHERE src = 'node/455372'

0.22

SELECT dst FROM url_alias WHERE src = 'node/455374'

0.23

SELECT dst FROM url_alias WHERE src = 'node/455355'

0.19

SELECT dst FROM url_alias WHERE src = 'node/455350'

0.21

SELECT dst FROM url_alias WHERE src = 'node/455377'

0.2

SELECT dst FROM url_alias WHERE src = 'node/455376'

0.2

SELECT dst FROM url_alias WHERE src = 'node/455367'

0.22

SELECT dst FROM url_alias WHERE src = 'node/455352'

0.22

SELECT dst FROM url_alias WHERE src = 'node/455353'

0.21

SELECT dst FROM url_alias WHERE src = 'node/455354'

0.3

SELECT dst FROM url_alias WHERE src = 'node/455351'

0.16

block_block

SELECT body, format FROM boxes WHERE bid = 1

0.16

SELECT data, created, headers, expire FROM cache_filter WHERE cid = '3:63825aa8157cf091ecee1b61caba8150'

0.27

SELECT data, created, headers, expire FROM cache WHERE cid = 'www.slovakiacompany.com22a2bad0bc408b6c1a10254c49b6e385'

0.29

SELECT dst FROM url_alias WHERE src = 'admin/lm_paypal/settings'

0.15

SELECT dst FROM url_alias WHERE src = 'admin/user/access'

0.16

SELECT dst FROM url_alias WHERE src = 'admin/help/lm_paypal'

0.48

statistics_exit

INSERT INTO accesslog (title, path, url, hostname, uid, sid, timer, timestamp) values('Fruit and vegetables in Bratislava', 'business/category/fruit-vegetables/slovakia/bratislava', '', '38.107.179.209', 0, '8219e43eae621b4a14103a4aa9fbdbd3', 1051, 1337929751)

0.33

LOCK TABLES variable WRITE

16.33

DELETE FROM variable WHERE name = 'poormanscron_lastrun'

0.28

INSERT INTO variable (name, value) VALUES ('poormanscron_lastrun', 'i:1337926742;')

0.19

UNLOCK TABLES

9.97

DELETE FROM cache WHERE cid = 'variables'

0.22

LOCK TABLES variable WRITE

0.28

DELETE FROM variable WHERE name = 'cron_semaphore'

0.23

INSERT INTO variable (name, value) VALUES ('cron_semaphore', 'i:1337929751;')

0.16

UNLOCK TABLES

0.19

DELETE FROM cache WHERE cid = 'variables'

0.19

LOCK TABLES variable WRITE

0.29

DELETE FROM variable WHERE name = 'cache_flush_cache_filter'

0.2

INSERT INTO variable (name, value) VALUES ('cache_flush_cache_filter', 'i:1337929751;')

0.16

UNLOCK TABLES

0.18

business_internals_yahoo_get_weather

DELETE FROM cache WHERE cid = 'variables'

87.56

node_cron

DELETE FROM history WHERE timestamp < 1335337750

1230.41

ping_cron

SELECT nid FROM node WHERE status = 1 AND (created > '1337926142' OR changed > '1337926142')

299.39

statistics_cron

DELETE FROM accesslog WHERE timestamp < 1337670552

2702.33

watchdog_cron

DELETE FROM watchdog WHERE timestamp < 1337324952

14.76

watchdog_cron

DELETE FROM flood WHERE timestamp < 1337926155

0.18

TRUNCATE TABLE `ms_weather`

0.33

INSERT INTO watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (0, 'php', 'Table &#039;c0skcompany.ms_weather&#039; doesn&#039;t exist\nquery: business_internals_yahoo_get_weather\nTRUNCATE TABLE `ms_weather` in /var/www/clients/client0/web4/web/includes/database.mysql.inc on line 174.', 2, '', 'http://www.slovakiacompany.com/business/category/fruit-vegetables/slovakia/bratislava', '', '38.107.179.209', 1337929755)

0.24

business_management_get_last_updated_nodes

INSERT INTO watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (0, 'php', 'Invalid argument supplied for foreach() in /var/www/clients/client0/web4/web/sites/all/modules/business_internals/business_internals.module on line 2218.', 2, '', 'http://www.slovakiacompany.com/business/category/fruit-vegetables/slovakia/bratislava', '', '38.107.179.209', 1337929755)

0.29

user_load

SELECT * FROM users u WHERE uid = 1

13.48

user_load

SELECT r.rid, r.name FROM role r INNER JOIN users_roles ur ON ur.rid = r.rid WHERE ur.uid = 1

0.3

location_load_locations

SELECT lid FROM location_instance WHERE uid = 1

0.18

business_internals_cron

SET CHARACTER SET utf8

16.16

SELECT TIME(FROM_UNIXTIME(changed)) as time, title FROM node WHERE changed BETWEEN UNIX_TIMESTAMP('2012-05-24 00:00:00') AND UNIX_TIMESTAMP('2012-05-24 23:59:59') ORDER by time DESC

56.76

lm_paypal_cron

DELETE FROM lm_paypal_ipns WHERE timestamp < 1337497755

128.52

_update_status_cache_get

SELECT data, created, expire FROM cache_update_status WHERE cid = 'update_status_available_releases'

0.41

LOCK TABLES variable WRITE

0.47

DELETE FROM variable WHERE name = 'cron_last'

0.3

INSERT INTO variable (name, value) VALUES ('cron_last', 'i:1337929755;')

0.31

UNLOCK TABLES

0.44

DELETE FROM cache WHERE cid = 'variables'

0.47

INSERT INTO watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (1, 'cron', 'Cron run completed.', 0, '', 'http://www.slovakiacompany.com/business/category/fruit-vegetables/slovakia/bratislava', '', '38.107.179.209', 1337929755)

0.35

variable_del

DELETE FROM variable WHERE name = 'cron_semaphore'

0.3

DELETE FROM cache WHERE cid = 'variables'

0.45

INSERT INTO watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (1, 'cron', 'Cron run completed (via poormanscron).', 0, '', 'http://www.slovakiacompany.com/business/category/fruit-vegetables/slovakia/bratislava', '', '38.107.179.209', 1337929755)

0.29

LOCK TABLES variable WRITE

0.48

DELETE FROM variable WHERE name = 'poormanscron_lastrun'

0.28

INSERT INTO variable (name, value) VALUES ('poormanscron_lastrun', 'i:1337929755;')

0.27

UNLOCK TABLES

0.36