| 0.0015 |
SELECT "site_name", "site_desc", "site_email", "upload_path_relative", "upload_path", "site_logo", "register", "disable_captcha", "date_format", "avatar_upload", "file_types", "twitter_consumer_key", "twitter_consumer_secret", "disable_social_login", "facebook_app_id", "facebook_app_secret", "google_client_id", "google_client_secret", "file_size", "paypal_email", "paypal_currency", "payment_enabled", "payment_symbol", "global_premium", "install", "login_protect", "activate_account", "default_user_role", "secure_login", "stripe_secret_key", "stripe_publish_key", "google_recaptcha", "google_recaptcha_secret", "google_recaptcha_key", "logo_option", "layout", "profile_comments", "avatar_width", "avatar_height", "cache_time", "checkout2_secret", "checkout2_accountno", "user_display_type", "page_slugs", "calendar_picker_format", "disable_chat", "calendar_picker_format", "enable_google_ads_pages", "enable_google_ads_feed", "enable_rotation_ads_feed", "enable_rotation_ads_pages", "credit_price_pageviews", "rotation_ad_alert_user", "enable_promote_post", "resize_avatar", "verified_cost", "enable_verified_buy", "enable_verified_requests", "public_profiles", "public_pages", "public_blogs", "enable_blogs"
FROM "site_settings"
WHERE "id" = 1
|
| 0.0072 |
SELECT *
FROM "universal_users"
WHERE "username" = 'Iain'
|
| 0.0027 |
SELECT "title_link", "title", "summary", "update_date", "xp", "C"."name"
FROM "lk_submission"
INNER JOIN "lk_category_type_base" as "C" ON "C"."id" = "lk_submission"."category"
WHERE "created_by" = '778'
AND "state" = 1
ORDER BY random()
LIMIT 3
|
| 0.0011 |
SELECT COUNT(*) AS "numrows"
FROM "lk_submission"
WHERE (
"state" = 9
OR "state" = 1
)
AND "created_by" = '778'
|
| 0.0005 |
SELECT COUNT(*) AS "numrows"
FROM "lk_collaborator"
WHERE "created_by" = '778'
|
| 0.0228 |
SELECT COUNT(*) AS "numrows"
FROM "lk_comment"
WHERE "created_by" = '778'
|
| 0.0011 |
SELECT COUNT(*) AS "numrows"
FROM "lk_idea"
WHERE "created_by" = '778'
|
| 0.0010 |
SELECT SUM("hoh") AS "hoh"
FROM "lk_submission"
WHERE "created_by" = '778'
|
| 0.0008 |
SELECT "id"
FROM "lk_submission"
WHERE hoh > 5
AND "created_by" = '778'
|
| 0.0007 |
SELECT COUNT(*) AS "numrows"
FROM "lk_submission"
WHERE "created_by" = '778'
AND quest > 0
|
| 0.0003 |
SELECT "xp", "submissions"
FROM "lk_level"
WHERE "id" = 14
|
| 0.0003 |
SELECT "xp", "submissions"
FROM "lk_level"
WHERE "id" = 13
|
| 0.0008 |
SELECT COUNT(*) AS "numrows"
FROM "lk_submission"
WHERE (
"state" = 5
OR "state" = 7
OR "state" = 2
)
AND "created_by" = '778'
|
| 0.0006 |
SELECT COUNT(*) AS "numrows"
FROM "lk_submission"
WHERE "created_by" = '778'
AND "state" = 2
|
| 0.0007 |
SELECT COUNT(*) AS "numrows"
FROM "lk_submission"
WHERE "created_by" = '778'
AND "state" = 7
|
| 0.0006 |
SELECT COUNT(*) AS "numrows"
FROM "lk_submission"
WHERE "created_by" = '778'
AND "state" = 5
|
| 0.0004 |
SELECT COUNT(*) AS "numrows"
FROM "lk_quest"
|
| 0.0004 |
SELECT COUNT(*) AS "numrows"
FROM "lk_collection"
WHERE "created_by" = '778'
|
| 0.0006 |
SELECT COUNT(*) AS "numrows"
FROM "lk_collection_item"
WHERE "created_by" = '778'
|
| 0.0058 |
SELECT "idea_id", "idea_author", "idea_type_id", "idea_parent", "idea_title", "idea_text", "idea_date", "idea_cond", "idea_xp", "member_name", "member_avatar"
FROM "lockmor_ideas"
ORDER BY RANDOM()
LIMIT 3
|
