| 0.0002 |
SELECT *
FROM `settings`
|
| 0.0001 |
DELETE FROM `users_sessions`
WHERE `last_activity` < 1603759520
|
| 0.0007 |
SELECT * FROM (
SELECT campaigns.*, campaigns_categories.name AS category_name , campaigns_categories.url AS category_url , users.username , CONCAT(users.first_name, ' ' ,users.last_name) AS creator_name
FROM campaigns_categories
INNER JOIN campaigns ON campaigns_categories.id = campaigns.category_id
LEFT JOIN users ON campaigns.creator_id = users.id
WHERE campaigns.featured = 1 AND campaigns.type = 1 ORDER BY RAND()
) AS shuffled_items GROUP BY category_id
|
| 0.0001 |
SELECT `campaigns`.*, `campaigns_categories`.`name` as `category_name`, `campaigns_categories`.`url` as `category_url`, `campaigns_categories`.`fa_icon`, `users`.`username`, CONCAT(users.first_name, " ", users.last_name) AS creator_name
FROM `campaigns`
LEFT JOIN `users` ON `campaigns`.`creator_id` = `users`.`id`
LEFT JOIN `campaigns_categories` ON `campaigns`.`category_id` = `campaigns_categories`.`id`
WHERE `slider` = 1
AND `type` = 1
ORDER BY `campaigns`.`created_on` DESC
|
| 0.0003 |
SELECT `campaigns`.*, SUM(campaigns_supporters.social_reach) as sum_social_reach, `campaigns_categories`.`name` as `category_name`, `campaigns_categories`.`url` as `category_url`, `campaigns_categories`.`fa_icon`, `users`.`username`, CONCAT(users.first_name, " ", users.last_name) AS creator_name
FROM `campaigns`
LEFT JOIN `users` ON `campaigns`.`creator_id` = `users`.`id`
LEFT JOIN `campaigns_categories` ON `campaigns`.`category_id` = `campaigns_categories`.`id`
LEFT JOIN `campaigns_supporters` ON `campaigns`.`id` = `campaigns_supporters`.`campaign_id`
WHERE `campaigns`.`type` = 1
GROUP BY `campaigns`.`id`
ORDER BY `sum_social_reach` DESC
LIMIT 2
|
| 0.0001 |
SELECT `campaigns`.*, `campaigns_categories`.`name` as `category_name`, `campaigns_categories`.`url` as `category_url`, `campaigns_categories`.`fa_icon`, `users`.`username`, CONCAT(users.first_name, " ", users.last_name) AS creator_name
FROM `campaigns`
LEFT JOIN `users` ON `campaigns`.`creator_id` = `users`.`id`
LEFT JOIN `campaigns_categories` ON `campaigns`.`category_id` = `campaigns_categories`.`id`
WHERE `type` = 1
ORDER BY `campaigns`.`created_on` DESC
LIMIT 2
|
| 0.0003 |
SELECT `campaigns`.*, `campaigns_categories`.`name` as `category_name`, `campaigns_categories`.`url` as `category_url`, `campaigns_categories`.`fa_icon`, `users`.`username`, CONCAT(users.first_name, " ", users.last_name) AS creator_name
FROM `campaigns`
LEFT JOIN `users` ON `campaigns`.`creator_id` = `users`.`id`
LEFT JOIN `campaigns_categories` ON `campaigns`.`category_id` = `campaigns_categories`.`id`
WHERE `type` = 2
ORDER BY `finish` desc
LIMIT 2
|
| 0.0001 |
SELECT `campaigns`.*, `campaigns_categories`.`name` as `category_name`, `campaigns_categories`.`url` as `category_url`, `campaigns_categories`.`fa_icon`, `users`.`username`, CONCAT(users.first_name, " ", users.last_name) AS creator_name
FROM `campaigns`
LEFT JOIN `users` ON `campaigns`.`creator_id` = `users`.`id`
LEFT JOIN `campaigns_categories` ON `campaigns`.`category_id` = `campaigns_categories`.`id`
WHERE `type` = 1
ORDER BY `finish` desc
LIMIT 2
|
| 0.0001 |
SELECT *
FROM `featured`
|
| 0.0001 |
SELECT *
FROM `testimonials`
|
| 0.0091 |
SELECT `su_hashtags`.*, COUNT(su_status_hashtags.id) as count, `su_status_updates`.`created_on` AS `status_creation_date`
FROM `su_status_hashtags`
LEFT JOIN `su_hashtags` ON `su_status_hashtags`.`hashtag_id` = `su_hashtags`.`id`
LEFT JOIN `su_status_updates` ON `su_status_hashtags`.`status_id` = `su_status_updates`.`id`
WHERE UNIX_TIMESTAMP(su_status_updates.order_date) >= 1601171120
GROUP BY `su_status_hashtags`.`hashtag_id`
ORDER BY `count` DESC, `su_hashtags`.`text` ASC
LIMIT 24
|
| 0.0001 |
SELECT `status_id` as `id`
FROM `su_sticked_statuses`
WHERE `pin_type` = 'offers'
|
| 0.0028 |
SELECT `su_status_updates`.*, `users`.`username`, CONCAT(users.first_name, " ", users.last_name) AS creator_name
FROM `su_status_updates`
LEFT JOIN `users` ON `su_status_updates`.`creator_id` = `users`.`id`
WHERE (`status_source` = 2 AND `coins` >0) OR (`status_source` = 1)
ORDER BY `su_status_updates`.`order_date` DESC
LIMIT 10
|
| 0.0001 |
SELECT COUNT(*) AS `numrows`
FROM `su_status_replies`
WHERE `status_id` = '11833'
|
| 0.0002 |
SELECT COUNT(*) AS `numrows`
FROM `su_likes`
WHERE `item_id` = '11833'
AND `item_type` = 'st'
|
| 0.0001 |
SELECT COUNT(*) AS `numrows`
FROM `su_recrews`
WHERE `recrewed_status_id` = '11833'
|
| 0.0011 |
SELECT *
FROM `su_multimedia`
WHERE `status_id` = '167015f92f8ca4448b'
|
| 0.0001 |
SELECT `su_status_replies`.*, `users`.`username`, CONCAT(users.first_name, " ", users.last_name) AS creator_name
FROM `su_status_replies`
LEFT JOIN `users` ON `su_status_replies`.`creator_id` = `users`.`id`
WHERE `status_id` = '11833'
AND `parent` =0
ORDER BY `created_on` DESC
|
| 0.0001 |
SELECT COUNT(*) AS `numrows`
FROM `su_status_replies`
WHERE `status_id` = '11832'
|
| 0.0002 |
SELECT COUNT(*) AS `numrows`
FROM `su_likes`
WHERE `item_id` = '11832'
AND `item_type` = 'st'
|
| 0.0001 |
SELECT COUNT(*) AS `numrows`
FROM `su_recrews`
WHERE `recrewed_status_id` = '11832'
|
| 0.0011 |
SELECT *
FROM `su_multimedia`
WHERE `status_id` = '167015f92da4f7a1f6'
|
| 0.0001 |
SELECT `su_status_replies`.*, `users`.`username`, CONCAT(users.first_name, " ", users.last_name) AS creator_name
FROM `su_status_replies`
LEFT JOIN `users` ON `su_status_replies`.`creator_id` = `users`.`id`
WHERE `status_id` = '11832'
AND `parent` =0
ORDER BY `created_on` DESC
|
| 0.0001 |
SELECT COUNT(*) AS `numrows`
FROM `su_status_replies`
WHERE `status_id` = '11831'
|
| 0.0002 |
SELECT COUNT(*) AS `numrows`
FROM `su_likes`
WHERE `item_id` = '11831'
AND `item_type` = 'st'
|
| 0.0001 |
SELECT COUNT(*) AS `numrows`
FROM `su_recrews`
WHERE `recrewed_status_id` = '11831'
|
| 0.0010 |
SELECT *
FROM `su_multimedia`
WHERE `status_id` = '167015f92d7ae73867'
|
| 0.0001 |
SELECT `su_status_replies`.*, `users`.`username`, CONCAT(users.first_name, " ", users.last_name) AS creator_name
FROM `su_status_replies`
LEFT JOIN `users` ON `su_status_replies`.`creator_id` = `users`.`id`
WHERE `status_id` = '11831'
AND `parent` =0
ORDER BY `created_on` DESC
|
| 0.0001 |
SELECT COUNT(*) AS `numrows`
FROM `su_status_replies`
WHERE `status_id` = '11816'
|
| 0.0002 |
SELECT COUNT(*) AS `numrows`
FROM `su_likes`
WHERE `item_id` = '11816'
AND `item_type` = 'st'
|
| 0.0001 |
SELECT COUNT(*) AS `numrows`
FROM `su_recrews`
WHERE `recrewed_status_id` = '11816'
|
| 0.0011 |
SELECT *
FROM `su_multimedia`
WHERE `status_id` = '183645f9169bbe1ca0'
|
| 0.0001 |
SELECT `su_status_replies`.*, `users`.`username`, CONCAT(users.first_name, " ", users.last_name) AS creator_name
FROM `su_status_replies`
LEFT JOIN `users` ON `su_status_replies`.`creator_id` = `users`.`id`
WHERE `status_id` = '11816'
AND `parent` =0
ORDER BY `created_on` DESC
|
| 0.0001 |
SELECT COUNT(*) AS `numrows`
FROM `su_status_replies`
WHERE `status_id` = '11815'
|
| 0.0002 |
SELECT COUNT(*) AS `numrows`
FROM `su_likes`
WHERE `item_id` = '11815'
AND `item_type` = 'st'
|
| 0.0001 |
SELECT COUNT(*) AS `numrows`
FROM `su_recrews`
WHERE `recrewed_status_id` = '11815'
|
| 0.0011 |
SELECT *
FROM `su_multimedia`
WHERE `status_id` = '183645f916507514a0'
|
| 0.0001 |
SELECT `su_status_replies`.*, `users`.`username`, CONCAT(users.first_name, " ", users.last_name) AS creator_name
FROM `su_status_replies`
LEFT JOIN `users` ON `su_status_replies`.`creator_id` = `users`.`id`
WHERE `status_id` = '11815'
AND `parent` =0
ORDER BY `created_on` DESC
|
| 0.0001 |
SELECT COUNT(*) AS `numrows`
FROM `su_status_replies`
WHERE `status_id` = '11814'
|
| 0.0002 |
SELECT COUNT(*) AS `numrows`
FROM `su_likes`
WHERE `item_id` = '11814'
AND `item_type` = 'st'
|
| 0.0001 |
SELECT COUNT(*) AS `numrows`
FROM `su_recrews`
WHERE `recrewed_status_id` = '11814'
|
| 0.0011 |
SELECT *
FROM `su_multimedia`
WHERE `status_id` = '183645f915d4fac303'
|
| 0.0001 |
SELECT `su_status_replies`.*, `users`.`username`, CONCAT(users.first_name, " ", users.last_name) AS creator_name
FROM `su_status_replies`
LEFT JOIN `users` ON `su_status_replies`.`creator_id` = `users`.`id`
WHERE `status_id` = '11814'
AND `parent` =0
ORDER BY `created_on` DESC
|
| 0.0001 |
SELECT COUNT(*) AS `numrows`
FROM `su_status_replies`
WHERE `status_id` = '11813'
|
| 0.0002 |
SELECT COUNT(*) AS `numrows`
FROM `su_likes`
WHERE `item_id` = '11813'
AND `item_type` = 'st'
|
| 0.0001 |
SELECT COUNT(*) AS `numrows`
FROM `su_recrews`
WHERE `recrewed_status_id` = '11813'
|
| 0.0011 |
SELECT *
FROM `su_multimedia`
WHERE `status_id` = '183645f91562d2fbb6'
|
| 0.0001 |
SELECT `su_status_replies`.*, `users`.`username`, CONCAT(users.first_name, " ", users.last_name) AS creator_name
FROM `su_status_replies`
LEFT JOIN `users` ON `su_status_replies`.`creator_id` = `users`.`id`
WHERE `status_id` = '11813'
AND `parent` =0
ORDER BY `created_on` DESC
|
| 0.0001 |
SELECT COUNT(*) AS `numrows`
FROM `su_status_replies`
WHERE `status_id` = '11812'
|
| 0.0002 |
SELECT COUNT(*) AS `numrows`
FROM `su_likes`
WHERE `item_id` = '11812'
AND `item_type` = 'st'
|
| 0.0001 |
SELECT COUNT(*) AS `numrows`
FROM `su_recrews`
WHERE `recrewed_status_id` = '11812'
|
| 0.0010 |
SELECT *
FROM `su_multimedia`
WHERE `status_id` = '211885f9154f096bf6'
|
| 0.0001 |
SELECT `su_status_replies`.*, `users`.`username`, CONCAT(users.first_name, " ", users.last_name) AS creator_name
FROM `su_status_replies`
LEFT JOIN `users` ON `su_status_replies`.`creator_id` = `users`.`id`
WHERE `status_id` = '11812'
AND `parent` =0
ORDER BY `created_on` DESC
|
| 0.0001 |
SELECT COUNT(*) AS `numrows`
FROM `su_status_replies`
WHERE `status_id` = '11811'
|
| 0.0002 |
SELECT COUNT(*) AS `numrows`
FROM `su_likes`
WHERE `item_id` = '11811'
AND `item_type` = 'st'
|
| 0.0001 |
SELECT COUNT(*) AS `numrows`
FROM `su_recrews`
WHERE `recrewed_status_id` = '11811'
|
| 0.0010 |
SELECT *
FROM `su_multimedia`
WHERE `status_id` = '183645f914d7781aff'
|
| 0.0001 |
SELECT `su_status_replies`.*, `users`.`username`, CONCAT(users.first_name, " ", users.last_name) AS creator_name
FROM `su_status_replies`
LEFT JOIN `users` ON `su_status_replies`.`creator_id` = `users`.`id`
WHERE `status_id` = '11811'
AND `parent` =0
ORDER BY `created_on` DESC
|
| 0.0001 |
SELECT COUNT(*) AS `numrows`
FROM `su_status_replies`
WHERE `status_id` = '11810'
|
| 0.0002 |
SELECT COUNT(*) AS `numrows`
FROM `su_likes`
WHERE `item_id` = '11810'
AND `item_type` = 'st'
|
| 0.0001 |
SELECT COUNT(*) AS `numrows`
FROM `su_recrews`
WHERE `recrewed_status_id` = '11810'
|
| 0.0010 |
SELECT *
FROM `su_multimedia`
WHERE `status_id` = '183645f9147c83b096'
|
| 0.0001 |
SELECT `su_status_replies`.*, `users`.`username`, CONCAT(users.first_name, " ", users.last_name) AS creator_name
FROM `su_status_replies`
LEFT JOIN `users` ON `su_status_replies`.`creator_id` = `users`.`id`
WHERE `status_id` = '11810'
AND `parent` =0
ORDER BY `created_on` DESC
|
| 1.1418 |
SELECT `su_status_updates`.*, `users`.`username`, CONCAT(users.first_name, " ", users.last_name) AS creator_name, (COUNT(`su_likes`.`id`) + COUNT(`su_recrews`.`id`) ) as rating
FROM `su_status_updates`
LEFT JOIN `users` ON `su_status_updates`.`creator_id` = `users`.`id`
LEFT JOIN `su_likes` ON `su_status_updates`.`id` = `su_likes`.`item_id`
LEFT JOIN `su_recrews` ON `su_status_updates`.`id` = `su_recrews`.`recrewed_status_id`
WHERE (`su_likes`.`item_type` = 'st' OR `su_recrews`.`id` IS NULL) OR `su_likes`.`id` IS NULL
AND (`status_source` = 2 AND `coins` >0) OR (`status_source` = 1)
GROUP BY `su_status_updates`.`id`
HAVING `rating` >0
ORDER BY `rating` DESC
LIMIT 10
|
| 0.0001 |
SELECT COUNT(*) AS `numrows`
FROM `su_status_replies`
WHERE `status_id` = '2110'
|
| 0.0002 |
SELECT COUNT(*) AS `numrows`
FROM `su_likes`
WHERE `item_id` = '2110'
AND `item_type` = 'st'
|
| 0.0001 |
SELECT COUNT(*) AS `numrows`
FROM `su_recrews`
WHERE `recrewed_status_id` = '2110'
|
| 0.0011 |
SELECT *
FROM `su_multimedia`
WHERE `status_id` = '167455a334f9051fa5'
|
| 0.0001 |
SELECT `su_status_replies`.*, `users`.`username`, CONCAT(users.first_name, " ", users.last_name) AS creator_name
FROM `su_status_replies`
LEFT JOIN `users` ON `su_status_replies`.`creator_id` = `users`.`id`
WHERE `status_id` = '2110'
AND `parent` =0
ORDER BY `created_on` DESC
|
| 0.0001 |
SELECT COUNT(*) AS `numrows`
FROM `su_status_replies`
WHERE `status_id` = '2115'
|
| 0.0002 |
SELECT COUNT(*) AS `numrows`
FROM `su_likes`
WHERE `item_id` = '2115'
AND `item_type` = 'st'
|
| 0.0001 |
SELECT COUNT(*) AS `numrows`
FROM `su_recrews`
WHERE `recrewed_status_id` = '2115'
|
| 0.0010 |
SELECT *
FROM `su_multimedia`
WHERE `status_id` = '167455a3373ae96cb7'
|
| 0.0001 |
SELECT `su_status_replies`.*, `users`.`username`, CONCAT(users.first_name, " ", users.last_name) AS creator_name
FROM `su_status_replies`
LEFT JOIN `users` ON `su_status_replies`.`creator_id` = `users`.`id`
WHERE `status_id` = '2115'
AND `parent` =0
ORDER BY `created_on` DESC
|
| 0.0001 |
SELECT COUNT(*) AS `numrows`
FROM `su_status_replies`
WHERE `status_id` = '1783'
|
| 0.0002 |
SELECT COUNT(*) AS `numrows`
FROM `su_likes`
WHERE `item_id` = '1783'
AND `item_type` = 'st'
|
| 0.0001 |
SELECT COUNT(*) AS `numrows`
FROM `su_recrews`
WHERE `recrewed_status_id` = '1783'
|
| 0.0010 |
SELECT *
FROM `su_multimedia`
WHERE `status_id` = '167515a14380facb88'
|
| 0.0001 |
SELECT `su_status_replies`.*, `users`.`username`, CONCAT(users.first_name, " ", users.last_name) AS creator_name
FROM `su_status_replies`
LEFT JOIN `users` ON `su_status_replies`.`creator_id` = `users`.`id`
WHERE `status_id` = '1783'
AND `parent` =0
ORDER BY `created_on` DESC
|
| 0.0001 |
SELECT COUNT(*) AS `numrows`
FROM `su_status_replies`
WHERE `status_id` = '1786'
|
| 0.0002 |
SELECT COUNT(*) AS `numrows`
FROM `su_likes`
WHERE `item_id` = '1786'
AND `item_type` = 'st'
|
| 0.0001 |
SELECT COUNT(*) AS `numrows`
FROM `su_recrews`
WHERE `recrewed_status_id` = '1786'
|
| 0.0010 |
SELECT *
FROM `su_multimedia`
WHERE `status_id` = '167515a143832daf86'
|
| 0.0001 |
SELECT `su_status_replies`.*, `users`.`username`, CONCAT(users.first_name, " ", users.last_name) AS creator_name
FROM `su_status_replies`
LEFT JOIN `users` ON `su_status_replies`.`creator_id` = `users`.`id`
WHERE `status_id` = '1786'
AND `parent` =0
ORDER BY `created_on` DESC
|
| 0.0001 |
SELECT COUNT(*) AS `numrows`
FROM `su_status_replies`
WHERE `status_id` = '1856'
|
| 0.0002 |
SELECT COUNT(*) AS `numrows`
FROM `su_likes`
WHERE `item_id` = '1856'
AND `item_type` = 'st'
|
| 0.0001 |
SELECT COUNT(*) AS `numrows`
FROM `su_recrews`
WHERE `recrewed_status_id` = '1856'
|
| 0.0010 |
SELECT *
FROM `su_multimedia`
WHERE `status_id` = '105a192dcd4460c'
|
| 0.0001 |
SELECT `su_status_replies`.*, `users`.`username`, CONCAT(users.first_name, " ", users.last_name) AS creator_name
FROM `su_status_replies`
LEFT JOIN `users` ON `su_status_replies`.`creator_id` = `users`.`id`
WHERE `status_id` = '1856'
AND `parent` =0
ORDER BY `created_on` DESC
|
| 0.0001 |
SELECT COUNT(*) AS `numrows`
FROM `su_status_replies`
WHERE `status_id` = '1840'
|
| 0.0002 |
SELECT COUNT(*) AS `numrows`
FROM `su_likes`
WHERE `item_id` = '1840'
AND `item_type` = 'st'
|
| 0.0001 |
SELECT COUNT(*) AS `numrows`
FROM `su_recrews`
WHERE `recrewed_status_id` = '1840'
|
| 0.0010 |
SELECT *
FROM `su_multimedia`
WHERE `status_id` = '105a15353662f7c'
|
| 0.0001 |
SELECT `su_status_replies`.*, `users`.`username`, CONCAT(users.first_name, " ", users.last_name) AS creator_name
FROM `su_status_replies`
LEFT JOIN `users` ON `su_status_replies`.`creator_id` = `users`.`id`
WHERE `status_id` = '1840'
AND `parent` =0
ORDER BY `created_on` DESC
|
| 0.0001 |
SELECT COUNT(*) AS `numrows`
FROM `su_status_replies`
WHERE `status_id` = '1933'
|
| 0.0002 |
SELECT COUNT(*) AS `numrows`
FROM `su_likes`
WHERE `item_id` = '1933'
AND `item_type` = 'st'
|
| 0.0001 |
SELECT COUNT(*) AS `numrows`
FROM `su_recrews`
WHERE `recrewed_status_id` = '1933'
|
| 0.0010 |
SELECT *
FROM `su_multimedia`
WHERE `status_id` = '167515a258cbf0024a'
|
| 0.0001 |
SELECT `su_status_replies`.*, `users`.`username`, CONCAT(users.first_name, " ", users.last_name) AS creator_name
FROM `su_status_replies`
LEFT JOIN `users` ON `su_status_replies`.`creator_id` = `users`.`id`
WHERE `status_id` = '1933'
AND `parent` =0
ORDER BY `created_on` DESC
|
| 0.0001 |
SELECT COUNT(*) AS `numrows`
FROM `su_status_replies`
WHERE `status_id` = '1994'
|
| 0.0002 |
SELECT COUNT(*) AS `numrows`
FROM `su_likes`
WHERE `item_id` = '1994'
AND `item_type` = 'st'
|
| 0.0001 |
SELECT COUNT(*) AS `numrows`
FROM `su_recrews`
WHERE `recrewed_status_id` = '1994'
|
| 0.0010 |
SELECT *
FROM `su_multimedia`
WHERE `status_id` = '167515a2bb9ab711f6'
|
| 0.0001 |
SELECT `su_status_replies`.*, `users`.`username`, CONCAT(users.first_name, " ", users.last_name) AS creator_name
FROM `su_status_replies`
LEFT JOIN `users` ON `su_status_replies`.`creator_id` = `users`.`id`
WHERE `status_id` = '1994'
AND `parent` =0
ORDER BY `created_on` DESC
|
| 0.0001 |
SELECT COUNT(*) AS `numrows`
FROM `su_status_replies`
WHERE `status_id` = '2031'
|
| 0.0002 |
SELECT COUNT(*) AS `numrows`
FROM `su_likes`
WHERE `item_id` = '2031'
AND `item_type` = 'st'
|
| 0.0001 |
SELECT COUNT(*) AS `numrows`
FROM `su_recrews`
WHERE `recrewed_status_id` = '2031'
|
| 0.0010 |
SELECT *
FROM `su_multimedia`
WHERE `status_id` = '167515a2c17bd131a0'
|
| 0.0001 |
SELECT `su_status_replies`.*, `users`.`username`, CONCAT(users.first_name, " ", users.last_name) AS creator_name
FROM `su_status_replies`
LEFT JOIN `users` ON `su_status_replies`.`creator_id` = `users`.`id`
WHERE `status_id` = '2031'
AND `parent` =0
ORDER BY `created_on` DESC
|
| 0.0001 |
SELECT COUNT(*) AS `numrows`
FROM `su_status_replies`
WHERE `status_id` = '2034'
|
| 0.0002 |
SELECT COUNT(*) AS `numrows`
FROM `su_likes`
WHERE `item_id` = '2034'
AND `item_type` = 'st'
|
| 0.0001 |
SELECT COUNT(*) AS `numrows`
FROM `su_recrews`
WHERE `recrewed_status_id` = '2034'
|
| 0.0010 |
SELECT *
FROM `su_multimedia`
WHERE `status_id` = '167515a2c184887236'
|
| 0.0001 |
SELECT `su_status_replies`.*, `users`.`username`, CONCAT(users.first_name, " ", users.last_name) AS creator_name
FROM `su_status_replies`
LEFT JOIN `users` ON `su_status_replies`.`creator_id` = `users`.`id`
WHERE `status_id` = '2034'
AND `parent` =0
ORDER BY `created_on` DESC
|
| 0.0253 |
SELECT `su_status_updates`.*, `users`.`username`, CONCAT(users.first_name, " ", users.last_name) AS creator_name
FROM `su_status_updates`
LEFT JOIN `users` ON `su_status_updates`.`creator_id` = `users`.`id`
JOIN `su_multimedia` ON `su_status_updates`.`identificator` = `su_multimedia`.`status_id`
WHERE (`status_source` = 2 AND `coins` >0) OR (`status_source` = 1)
GROUP BY `su_status_updates`.`id`
ORDER BY `su_status_updates`.`order_date` DESC
LIMIT 10
|
| 0.0001 |
SELECT COUNT(*) AS `numrows`
FROM `su_status_replies`
WHERE `status_id` = '11833'
|
| 0.0002 |
SELECT COUNT(*) AS `numrows`
FROM `su_likes`
WHERE `item_id` = '11833'
AND `item_type` = 'st'
|
| 0.0001 |
SELECT COUNT(*) AS `numrows`
FROM `su_recrews`
WHERE `recrewed_status_id` = '11833'
|
| 0.0010 |
SELECT *
FROM `su_multimedia`
WHERE `status_id` = '167015f92f8ca4448b'
|
| 0.0001 |
SELECT `su_status_replies`.*, `users`.`username`, CONCAT(users.first_name, " ", users.last_name) AS creator_name
FROM `su_status_replies`
LEFT JOIN `users` ON `su_status_replies`.`creator_id` = `users`.`id`
WHERE `status_id` = '11833'
AND `parent` =0
ORDER BY `created_on` DESC
|
| 0.0001 |
SELECT COUNT(*) AS `numrows`
FROM `su_status_replies`
WHERE `status_id` = '11832'
|
| 0.0002 |
SELECT COUNT(*) AS `numrows`
FROM `su_likes`
WHERE `item_id` = '11832'
AND `item_type` = 'st'
|
| 0.0001 |
SELECT COUNT(*) AS `numrows`
FROM `su_recrews`
WHERE `recrewed_status_id` = '11832'
|
| 0.0010 |
SELECT *
FROM `su_multimedia`
WHERE `status_id` = '167015f92da4f7a1f6'
|
| 0.0001 |
SELECT `su_status_replies`.*, `users`.`username`, CONCAT(users.first_name, " ", users.last_name) AS creator_name
FROM `su_status_replies`
LEFT JOIN `users` ON `su_status_replies`.`creator_id` = `users`.`id`
WHERE `status_id` = '11832'
AND `parent` =0
ORDER BY `created_on` DESC
|
| 0.0001 |
SELECT COUNT(*) AS `numrows`
FROM `su_status_replies`
WHERE `status_id` = '11831'
|
| 0.0002 |
SELECT COUNT(*) AS `numrows`
FROM `su_likes`
WHERE `item_id` = '11831'
AND `item_type` = 'st'
|
| 0.0001 |
SELECT COUNT(*) AS `numrows`
FROM `su_recrews`
WHERE `recrewed_status_id` = '11831'
|
| 0.0010 |
SELECT *
FROM `su_multimedia`
WHERE `status_id` = '167015f92d7ae73867'
|
| 0.0001 |
SELECT `su_status_replies`.*, `users`.`username`, CONCAT(users.first_name, " ", users.last_name) AS creator_name
FROM `su_status_replies`
LEFT JOIN `users` ON `su_status_replies`.`creator_id` = `users`.`id`
WHERE `status_id` = '11831'
AND `parent` =0
ORDER BY `created_on` DESC
|
| 0.0001 |
SELECT COUNT(*) AS `numrows`
FROM `su_status_replies`
WHERE `status_id` = '11816'
|
| 0.0002 |
SELECT COUNT(*) AS `numrows`
FROM `su_likes`
WHERE `item_id` = '11816'
AND `item_type` = 'st'
|
| 0.0001 |
SELECT COUNT(*) AS `numrows`
FROM `su_recrews`
WHERE `recrewed_status_id` = '11816'
|
| 0.0010 |
SELECT *
FROM `su_multimedia`
WHERE `status_id` = '183645f9169bbe1ca0'
|
| 0.0001 |
SELECT `su_status_replies`.*, `users`.`username`, CONCAT(users.first_name, " ", users.last_name) AS creator_name
FROM `su_status_replies`
LEFT JOIN `users` ON `su_status_replies`.`creator_id` = `users`.`id`
WHERE `status_id` = '11816'
AND `parent` =0
ORDER BY `created_on` DESC
|
| 0.0001 |
SELECT COUNT(*) AS `numrows`
FROM `su_status_replies`
WHERE `status_id` = '11815'
|
| 0.0002 |
SELECT COUNT(*) AS `numrows`
FROM `su_likes`
WHERE `item_id` = '11815'
AND `item_type` = 'st'
|
| 0.0001 |
SELECT COUNT(*) AS `numrows`
FROM `su_recrews`
WHERE `recrewed_status_id` = '11815'
|
| 0.0010 |
SELECT *
FROM `su_multimedia`
WHERE `status_id` = '183645f916507514a0'
|
| 0.0001 |
SELECT `su_status_replies`.*, `users`.`username`, CONCAT(users.first_name, " ", users.last_name) AS creator_name
FROM `su_status_replies`
LEFT JOIN `users` ON `su_status_replies`.`creator_id` = `users`.`id`
WHERE `status_id` = '11815'
AND `parent` =0
ORDER BY `created_on` DESC
|
| 0.0001 |
SELECT COUNT(*) AS `numrows`
FROM `su_status_replies`
WHERE `status_id` = '11814'
|
| 0.0002 |
SELECT COUNT(*) AS `numrows`
FROM `su_likes`
WHERE `item_id` = '11814'
AND `item_type` = 'st'
|
| 0.0001 |
SELECT COUNT(*) AS `numrows`
FROM `su_recrews`
WHERE `recrewed_status_id` = '11814'
|
| 0.0010 |
SELECT *
FROM `su_multimedia`
WHERE `status_id` = '183645f915d4fac303'
|
| 0.0001 |
SELECT `su_status_replies`.*, `users`.`username`, CONCAT(users.first_name, " ", users.last_name) AS creator_name
FROM `su_status_replies`
LEFT JOIN `users` ON `su_status_replies`.`creator_id` = `users`.`id`
WHERE `status_id` = '11814'
AND `parent` =0
ORDER BY `created_on` DESC
|
| 0.0001 |
SELECT COUNT(*) AS `numrows`
FROM `su_status_replies`
WHERE `status_id` = '11813'
|
| 0.0002 |
SELECT COUNT(*) AS `numrows`
FROM `su_likes`
WHERE `item_id` = '11813'
AND `item_type` = 'st'
|
| 0.0001 |
SELECT COUNT(*) AS `numrows`
FROM `su_recrews`
WHERE `recrewed_status_id` = '11813'
|
| 0.0010 |
SELECT *
FROM `su_multimedia`
WHERE `status_id` = '183645f91562d2fbb6'
|
| 0.0001 |
SELECT `su_status_replies`.*, `users`.`username`, CONCAT(users.first_name, " ", users.last_name) AS creator_name
FROM `su_status_replies`
LEFT JOIN `users` ON `su_status_replies`.`creator_id` = `users`.`id`
WHERE `status_id` = '11813'
AND `parent` =0
ORDER BY `created_on` DESC
|
| 0.0001 |
SELECT COUNT(*) AS `numrows`
FROM `su_status_replies`
WHERE `status_id` = '11811'
|
| 0.0002 |
SELECT COUNT(*) AS `numrows`
FROM `su_likes`
WHERE `item_id` = '11811'
AND `item_type` = 'st'
|
| 0.0001 |
SELECT COUNT(*) AS `numrows`
FROM `su_recrews`
WHERE `recrewed_status_id` = '11811'
|
| 0.0010 |
SELECT *
FROM `su_multimedia`
WHERE `status_id` = '183645f914d7781aff'
|
| 0.0001 |
SELECT `su_status_replies`.*, `users`.`username`, CONCAT(users.first_name, " ", users.last_name) AS creator_name
FROM `su_status_replies`
LEFT JOIN `users` ON `su_status_replies`.`creator_id` = `users`.`id`
WHERE `status_id` = '11811'
AND `parent` =0
ORDER BY `created_on` DESC
|
| 0.0001 |
SELECT COUNT(*) AS `numrows`
FROM `su_status_replies`
WHERE `status_id` = '11810'
|
| 0.0002 |
SELECT COUNT(*) AS `numrows`
FROM `su_likes`
WHERE `item_id` = '11810'
AND `item_type` = 'st'
|
| 0.0001 |
SELECT COUNT(*) AS `numrows`
FROM `su_recrews`
WHERE `recrewed_status_id` = '11810'
|
| 0.0010 |
SELECT *
FROM `su_multimedia`
WHERE `status_id` = '183645f9147c83b096'
|
| 0.0001 |
SELECT `su_status_replies`.*, `users`.`username`, CONCAT(users.first_name, " ", users.last_name) AS creator_name
FROM `su_status_replies`
LEFT JOIN `users` ON `su_status_replies`.`creator_id` = `users`.`id`
WHERE `status_id` = '11810'
AND `parent` =0
ORDER BY `created_on` DESC
|
| 0.0001 |
SELECT COUNT(*) AS `numrows`
FROM `su_status_replies`
WHERE `status_id` = '11809'
|
| 0.0002 |
SELECT COUNT(*) AS `numrows`
FROM `su_likes`
WHERE `item_id` = '11809'
AND `item_type` = 'st'
|
| 0.0001 |
SELECT COUNT(*) AS `numrows`
FROM `su_recrews`
WHERE `recrewed_status_id` = '11809'
|
| 0.0010 |
SELECT *
FROM `su_multimedia`
WHERE `status_id` = '183645f9140d3ddc6d'
|
| 0.0001 |
SELECT `su_status_replies`.*, `users`.`username`, CONCAT(users.first_name, " ", users.last_name) AS creator_name
FROM `su_status_replies`
LEFT JOIN `users` ON `su_status_replies`.`creator_id` = `users`.`id`
WHERE `status_id` = '11809'
AND `parent` =0
ORDER BY `created_on` DESC
|
| 0.0029 |
SELECT `su_status_updates`.*, `users`.`username`, CONCAT(users.first_name, " ", users.last_name) AS creator_name
FROM `su_status_updates`
LEFT JOIN `users` ON `su_status_updates`.`creator_id` = `users`.`id`
WHERE `su_status_updates`.`metadata_type` = 'video'
AND (`status_source` = 2 AND `coins` >0) OR (`status_source` = 1)
ORDER BY `su_status_updates`.`order_date` DESC
LIMIT 10
|
| 0.0001 |
SELECT COUNT(*) AS `numrows`
FROM `su_status_replies`
WHERE `status_id` = '11833'
|
| 0.0002 |
SELECT COUNT(*) AS `numrows`
FROM `su_likes`
WHERE `item_id` = '11833'
AND `item_type` = 'st'
|
| 0.0001 |
SELECT COUNT(*) AS `numrows`
FROM `su_recrews`
WHERE `recrewed_status_id` = '11833'
|
| 0.0010 |
SELECT *
FROM `su_multimedia`
WHERE `status_id` = '167015f92f8ca4448b'
|
| 0.0001 |
SELECT `su_status_replies`.*, `users`.`username`, CONCAT(users.first_name, " ", users.last_name) AS creator_name
FROM `su_status_replies`
LEFT JOIN `users` ON `su_status_replies`.`creator_id` = `users`.`id`
WHERE `status_id` = '11833'
AND `parent` =0
ORDER BY `created_on` DESC
|
| 0.0001 |
SELECT COUNT(*) AS `numrows`
FROM `su_status_replies`
WHERE `status_id` = '11832'
|
| 0.0002 |
SELECT COUNT(*) AS `numrows`
FROM `su_likes`
WHERE `item_id` = '11832'
AND `item_type` = 'st'
|
| 0.0001 |
SELECT COUNT(*) AS `numrows`
FROM `su_recrews`
WHERE `recrewed_status_id` = '11832'
|
| 0.0010 |
SELECT *
FROM `su_multimedia`
WHERE `status_id` = '167015f92da4f7a1f6'
|
| 0.0001 |
SELECT `su_status_replies`.*, `users`.`username`, CONCAT(users.first_name, " ", users.last_name) AS creator_name
FROM `su_status_replies`
LEFT JOIN `users` ON `su_status_replies`.`creator_id` = `users`.`id`
WHERE `status_id` = '11832'
AND `parent` =0
ORDER BY `created_on` DESC
|
| 0.0001 |
SELECT COUNT(*) AS `numrows`
FROM `su_status_replies`
WHERE `status_id` = '11831'
|
| 0.0002 |
SELECT COUNT(*) AS `numrows`
FROM `su_likes`
WHERE `item_id` = '11831'
AND `item_type` = 'st'
|
| 0.0001 |
SELECT COUNT(*) AS `numrows`
FROM `su_recrews`
WHERE `recrewed_status_id` = '11831'
|
| 0.0010 |
SELECT *
FROM `su_multimedia`
WHERE `status_id` = '167015f92d7ae73867'
|
| 0.0001 |
SELECT `su_status_replies`.*, `users`.`username`, CONCAT(users.first_name, " ", users.last_name) AS creator_name
FROM `su_status_replies`
LEFT JOIN `users` ON `su_status_replies`.`creator_id` = `users`.`id`
WHERE `status_id` = '11831'
AND `parent` =0
ORDER BY `created_on` DESC
|
| 0.0001 |
SELECT COUNT(*) AS `numrows`
FROM `su_status_replies`
WHERE `status_id` = '11816'
|
| 0.0002 |
SELECT COUNT(*) AS `numrows`
FROM `su_likes`
WHERE `item_id` = '11816'
AND `item_type` = 'st'
|
| 0.0001 |
SELECT COUNT(*) AS `numrows`
FROM `su_recrews`
WHERE `recrewed_status_id` = '11816'
|
| 0.0010 |
SELECT *
FROM `su_multimedia`
WHERE `status_id` = '183645f9169bbe1ca0'
|
| 0.0001 |
SELECT `su_status_replies`.*, `users`.`username`, CONCAT(users.first_name, " ", users.last_name) AS creator_name
FROM `su_status_replies`
LEFT JOIN `users` ON `su_status_replies`.`creator_id` = `users`.`id`
WHERE `status_id` = '11816'
AND `parent` =0
ORDER BY `created_on` DESC
|
| 0.0001 |
SELECT COUNT(*) AS `numrows`
FROM `su_status_replies`
WHERE `status_id` = '11815'
|
| 0.0002 |
SELECT COUNT(*) AS `numrows`
FROM `su_likes`
WHERE `item_id` = '11815'
AND `item_type` = 'st'
|
| 0.0001 |
SELECT COUNT(*) AS `numrows`
FROM `su_recrews`
WHERE `recrewed_status_id` = '11815'
|
| 0.0010 |
SELECT *
FROM `su_multimedia`
WHERE `status_id` = '183645f916507514a0'
|
| 0.0001 |
SELECT `su_status_replies`.*, `users`.`username`, CONCAT(users.first_name, " ", users.last_name) AS creator_name
FROM `su_status_replies`
LEFT JOIN `users` ON `su_status_replies`.`creator_id` = `users`.`id`
WHERE `status_id` = '11815'
AND `parent` =0
ORDER BY `created_on` DESC
|
| 0.0001 |
SELECT COUNT(*) AS `numrows`
FROM `su_status_replies`
WHERE `status_id` = '11814'
|
| 0.0002 |
SELECT COUNT(*) AS `numrows`
FROM `su_likes`
WHERE `item_id` = '11814'
AND `item_type` = 'st'
|
| 0.0001 |
SELECT COUNT(*) AS `numrows`
FROM `su_recrews`
WHERE `recrewed_status_id` = '11814'
|
| 0.0010 |
SELECT *
FROM `su_multimedia`
WHERE `status_id` = '183645f915d4fac303'
|
| 0.0001 |
SELECT `su_status_replies`.*, `users`.`username`, CONCAT(users.first_name, " ", users.last_name) AS creator_name
FROM `su_status_replies`
LEFT JOIN `users` ON `su_status_replies`.`creator_id` = `users`.`id`
WHERE `status_id` = '11814'
AND `parent` =0
ORDER BY `created_on` DESC
|
| 0.0001 |
SELECT COUNT(*) AS `numrows`
FROM `su_status_replies`
WHERE `status_id` = '11813'
|
| 0.0002 |
SELECT COUNT(*) AS `numrows`
FROM `su_likes`
WHERE `item_id` = '11813'
AND `item_type` = 'st'
|
| 0.0001 |
SELECT COUNT(*) AS `numrows`
FROM `su_recrews`
WHERE `recrewed_status_id` = '11813'
|
| 0.0011 |
SELECT *
FROM `su_multimedia`
WHERE `status_id` = '183645f91562d2fbb6'
|
| 0.0001 |
SELECT `su_status_replies`.*, `users`.`username`, CONCAT(users.first_name, " ", users.last_name) AS creator_name
FROM `su_status_replies`
LEFT JOIN `users` ON `su_status_replies`.`creator_id` = `users`.`id`
WHERE `status_id` = '11813'
AND `parent` =0
ORDER BY `created_on` DESC
|
| 0.0001 |
SELECT COUNT(*) AS `numrows`
FROM `su_status_replies`
WHERE `status_id` = '11812'
|
| 0.0002 |
SELECT COUNT(*) AS `numrows`
FROM `su_likes`
WHERE `item_id` = '11812'
AND `item_type` = 'st'
|
| 0.0001 |
SELECT COUNT(*) AS `numrows`
FROM `su_recrews`
WHERE `recrewed_status_id` = '11812'
|
| 0.0010 |
SELECT *
FROM `su_multimedia`
WHERE `status_id` = '211885f9154f096bf6'
|
| 0.0001 |
SELECT `su_status_replies`.*, `users`.`username`, CONCAT(users.first_name, " ", users.last_name) AS creator_name
FROM `su_status_replies`
LEFT JOIN `users` ON `su_status_replies`.`creator_id` = `users`.`id`
WHERE `status_id` = '11812'
AND `parent` =0
ORDER BY `created_on` DESC
|
| 0.0001 |
SELECT COUNT(*) AS `numrows`
FROM `su_status_replies`
WHERE `status_id` = '11811'
|
| 0.0002 |
SELECT COUNT(*) AS `numrows`
FROM `su_likes`
WHERE `item_id` = '11811'
AND `item_type` = 'st'
|
| 0.0001 |
SELECT COUNT(*) AS `numrows`
FROM `su_recrews`
WHERE `recrewed_status_id` = '11811'
|
| 0.0010 |
SELECT *
FROM `su_multimedia`
WHERE `status_id` = '183645f914d7781aff'
|
| 0.0001 |
SELECT `su_status_replies`.*, `users`.`username`, CONCAT(users.first_name, " ", users.last_name) AS creator_name
FROM `su_status_replies`
LEFT JOIN `users` ON `su_status_replies`.`creator_id` = `users`.`id`
WHERE `status_id` = '11811'
AND `parent` =0
ORDER BY `created_on` DESC
|
| 0.0001 |
SELECT COUNT(*) AS `numrows`
FROM `su_status_replies`
WHERE `status_id` = '11810'
|
| 0.0002 |
SELECT COUNT(*) AS `numrows`
FROM `su_likes`
WHERE `item_id` = '11810'
AND `item_type` = 'st'
|
| 0.0001 |
SELECT COUNT(*) AS `numrows`
FROM `su_recrews`
WHERE `recrewed_status_id` = '11810'
|
| 0.0010 |
SELECT *
FROM `su_multimedia`
WHERE `status_id` = '183645f9147c83b096'
|
| 0.0001 |
SELECT `su_status_replies`.*, `users`.`username`, CONCAT(users.first_name, " ", users.last_name) AS creator_name
FROM `su_status_replies`
LEFT JOIN `users` ON `su_status_replies`.`creator_id` = `users`.`id`
WHERE `status_id` = '11810'
AND `parent` =0
ORDER BY `created_on` DESC
|
| 0.0001 |
SELECT *
FROM `su_sticked_statuses`
WHERE `pin_type` = 'offers'
ORDER BY `timestamp` DESC
|
| 0.0001 |
SELECT *
FROM `settings`
|
| 0.0001 |
SELECT *
FROM `home_items`
WHERE `group` = 'how_work'
ORDER BY `id` ASC
|
| 0.0001 |
SELECT *
FROM `home_items`
WHERE `group` = 'benefits'
ORDER BY `id` ASC
|
| 0.0001 |
SELECT *
FROM `home_items`
WHERE `group` = 'choose_us'
ORDER BY `id` ASC
|
| 0.0001 |
SELECT *
FROM `campaigns_categories`
WHERE `status` = 1
|
| 0.0001 |
SELECT *
FROM `pages`
WHERE `show_in_menu` = 1
|
| 0.0001 |
SELECT *
FROM `pages`
WHERE `show_in_footer` = 1
|
blogengage
Oct 23 - 03:37pm
Statistics
