PC Games - Socialmedya Get Cheapest Digital Loots

Batman Arkham Collection PC ( Instant Delivery Digital code)

₹ 600.00 ₹ 5,086.00

Batman Arkham Collection PC ( Instant Delivery Digital code)

G...

Selling PUBG Account ( Transfer Ownership ) Instant Delivery

₹ 20,000.00 ₹ 35,000.00

Selling PUBG Account ( Transfer Ownership ) Instant Delivery

...

Total: 7

Sorting Options

Reset Name Price Likes

-82%

Human: Fall Flat (Code in the Box - for PC) Instant Delivery

Human: Fall Flat (Code in the Box - for PC) Instant Delivery

Membership: none

₹ 180.00 ₹ 999.00

0

0

31 Dec 2020

Add

-80%

PLAYERUNKNOWN'S BATTLEGROUNDS -PUBG - Instant Delivery

PLAYERUNKNOWN'S BATTLEGROUNDS -PUBG - Instant Delivery

Membership: none

₹ 600.00 ₹ 2,991.00

0

0

31 Dec 2020

Add

-86%

Mortal Kombat 11 (Code in the Box - for PC) Instant Delivery

Mortal Kombat 11 (Code in the Box - for PC) Instant Delivery

Membership: none

₹ 344.00 ₹ 2,499.00

0

0

31 Dec 2020

Add

-50%

Cyberpunk 2077 - GOG Code , Instant Delivery Digital Code

Cyberpunk 2077 - GOG Code , Instant Delivery Digital Code

Membership: none

₹ 1,500.00 ₹ 2,999.00

0

0

31 Dec 2020

Add

-85%

Grand Theft Auto V: Premium Online Edition ( PC Game ) Instant Delivery

Grand Theft Auto V: Premium Online Edition ( PC Game ) Instant Delivery

Membership: none

₹ 400.00 ₹ 2,638.00

0

0

31 Dec 2020

Add

-75%

Buy Watch_Dogs2 Gold Edition Instant Delivery

Buy Watch_Dogs2 Gold Edition Instant Delivery

Membership: none

₹ 500.00 ₹ 1,999.00

0

0

30 Dec 2020

Add

-60%

Need For Speed : Heat (for PC) Instant Delivery

Need For Speed : Heat (for PC) Instant Delivery

Membership: none

₹ 600.00 ₹ 1,499.00

0

0

30 Dec 2020

Add

Debug General Params (4) Warnings (0) Errors (0) SQL Queries (7)

Total execution time: 0.011299 sec.
Framework 1.50 v5.01
Memory Usage 0.93MB
POST:

Array
(
)

GET:

Array
(
)

Array
(
    [before] => Closure Object
        (
        )

    [segment] => Array
        (
            [0] => category
            [1] => pc-games
        )

    [route] => /category/pc-games
    [template] => front/themes/master/category.tpl.php
)

1. select | total: 1
SELECT * FROM `settings` WHERE id = 1 ;

2. select | total: 1
SELECT * FROM `categories` WHERE slug = "pc-games" LIMIT 1;

3. count | total: 9
SELECT COUNT(p.id) FROM `products` AS p INNER JOIN `categories_related` AS rc ON p.id = rc.product_id WHERE rc.category_id = 8 AND p.active = 1 LIMIT 1;

4. SELECT | total: 9
SELECT p.id, p.created, p.price, p.sprice, p.is_sale, p.title, p.slug, p.thumb, p.token, p.likes, p.body, p.type, p.token, p.affiliate, p.membership_id, c.slug AS cslug, c.name, GROUP_CONCAT(m.title SEPARATOR ', ') AS memberships, (SELECT COUNT(product_id) FROM `comments` WHERE `comments`.product_id = p.id) as comments FROM `products` AS p LEFT JOIN `categories` AS c ON c.id = p.category_id INNER JOIN `categories_related` AS rc ON p.id = rc.product_id LEFT JOIN `memberships` AS m ON FIND_IN_SET(m.id, p.membership_id) WHERE rc.category_id = 8 AND p.active = 1 AND c.active = 1 GROUP BY p.id ORDER BY created DESC LIMIT 0,16

5. SELECT | total: 7
SELECT m.id, m.name, m.content_type, m.link, m.target, p.slug, p.page_type FROM `menus` AS m LEFT JOIN `pages` AS p ON p.id = m.page_id WHERE m.active = 1 ORDER BY m.sorting;

6. select | total: 8
SELECT id, parent_id, name, slug FROM `categories` ORDER BY parent_id, sorting;

7. SELECT | total: 0
SELECT COUNT(id) AS items FROM `cart` WHERE user_id = "d7f06203fa1d8e16a545d656906819f0dfdbea17" AND membership_id = 0 GROUP BY user_id;

1. select | total: 1 . SELECT * FROM `settings` WHERE id = 1 ;

2. select | total: 1 . SELECT * FROM `categories` WHERE slug = "pc-games" LIMIT 1;

3. count | total: 9 . 
			  SELECT 
				COUNT(p.id) 
			  FROM
				`products` AS p 
				INNER JOIN `categories_related` AS rc 
				  ON p.id = rc.product_id 
			  WHERE rc.category_id = 8 
				AND p.active = 1 
			  LIMIT 1;

4. SELECT | total: 9 . SELECT 
				p.id,
				p.created,
				p.price,
				p.sprice,
				p.is_sale,
				p.title,
				p.slug,
				p.thumb,
				p.token,
				p.likes,
				p.body,
				p.type,
				p.token,
				p.affiliate,
				p.membership_id,
				c.slug AS cslug,
				c.name,
				GROUP_CONCAT(m.title SEPARATOR ', ') AS memberships,
				(SELECT 
				  COUNT(product_id) 
				FROM
				  `comments`
				WHERE `comments`.product_id = p.id) as comments
			  FROM
				`products` AS p
				LEFT JOIN `categories` AS c
				  ON c.id = p.category_id
				INNER JOIN `categories_related` AS rc 
				  ON p.id = rc.product_id
				LEFT JOIN `memberships` AS m 
				  ON FIND_IN_SET(m.id, p.membership_id)
			  WHERE rc.category_id = 8
			  AND p.active = 1 
			  AND c.active = 1  
			  GROUP BY p.id
			  ORDER BY  created DESC  LIMIT 0,16

5. SELECT | total: 7 . SELECT 
		    m.id,
			m.name,
			m.content_type,
			m.link,
			m.target,
			p.slug,
			p.page_type
		  FROM
			`menus` AS m 
			LEFT JOIN `pages` AS p 
			  ON p.id = m.page_id 
		  WHERE m.active = 1
		  ORDER BY m.sorting;

6. select | total: 8 . SELECT id, parent_id,  name,  slug FROM `categories` ORDER BY parent_id, sorting;

7. SELECT | total: 0 . SELECT 
			COUNT(id) AS items 
		  FROM
			`cart`
		  WHERE user_id = "d7f06203fa1d8e16a545d656906819f0dfdbea17"
		  AND membership_id = 0
		  GROUP BY user_id;