processlist

MySQL [(none)]> show full processlist\G
*************************** 1. row ***************************
     Id: 37897
   User: root
   Host: localhost
     db: t
Command: Sleep
   Time: 4539
  State:
   Info: NULL
*************************** 2. row ***************************
     Id: 369239
   User: root
   Host: localhost
     db: NULL
Command: Query
   Time: 0
  State: starting
   Info: show full processlist
*************************** 3. row ***************************
     Id: 373193
   User: root
   Host: localhost
     db: t
Command: Query
   Time: 1
  State: Sending data
   Info: CREATE TEMPORARY TABLE ps_cat_filter_restriction ENGINE=MEMORY
														SELECT cp.id_product, MIN(cp.position) position FROM ps_category c
														JOIN ps_category_product cp ON (c.id_category = cp.id_category AND
														c.nleft >= 3
														AND c.nright <= 16
														AND c.active = 1)
														JOIN `ps_product` p ON (p.id_product=cp.id_product)

														 INNER JOIN ps_product_shop product_shop
		ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
														WHERE 1  AND product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog")
														GROUP BY cp.id_product ORDER BY position, id_product
*************************** 4. row ***************************
     Id: 373204
   User: root
   Host: localhost
     db: t
Command: Query
   Time: 1
  State: Sending data
   Info: CREATE TEMPORARY TABLE ps_cat_filter_restriction ENGINE=MEMORY
														SELECT cp.id_product, MIN(cp.position) position FROM ps_category c
														JOIN ps_category_product cp ON (c.id_category = cp.id_category AND
														c.nleft >= 17
														AND c.nright <= 78
														AND c.active = 1)
														JOIN `ps_product` p ON (p.id_product=cp.id_product)

														 INNER JOIN ps_product_shop product_shop
		ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
														WHERE 1  AND product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog")
														GROUP BY cp.id_product ORDER BY position, id_product
*************************** 5. row ***************************
     Id: 373224
   User: root
   Host: localhost
     db: t
Command: Sleep
   Time: 0
  State:
   Info: NULL
*************************** 6. row ***************************
     Id: 373225
   User: root
   Host: localhost
     db: t
Command: Query
   Time: 1
  State: Sending data
   Info: CREATE TEMPORARY TABLE ps_cat_filter_restriction ENGINE=MEMORY
														SELECT cp.id_product, MIN(cp.position) position FROM ps_category c
														JOIN ps_category_product cp ON (c.id_category = cp.id_category AND
														c.nleft >= 17
														AND c.nright <= 78
														AND c.active = 1)
														JOIN `ps_product` p ON (p.id_product=cp.id_product)

														 INNER JOIN ps_product_shop product_shop
		ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
														WHERE 1  AND product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog")
														GROUP BY cp.id_product ORDER BY position, id_product
*************************** 7. row ***************************
     Id: 373228
   User: root
   Host: localhost
     db: t
Command: Query
   Time: 1
  State: Sending data
   Info: CREATE TEMPORARY TABLE ps_cat_filter_restriction ENGINE=MEMORY
														SELECT cp.id_product, MIN(cp.position) position FROM ps_category c
														JOIN ps_category_product cp ON (c.id_category = cp.id_category AND
														c.nleft >= 17
														AND c.nright <= 78
														AND c.active = 1)
														JOIN `ps_product` p ON (p.id_product=cp.id_product)

														 INNER JOIN ps_product_shop product_shop
		ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
														WHERE 1  AND product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog")
														GROUP BY cp.id_product ORDER BY position, id_product
*************************** 8. row ***************************
     Id: 373237
   User: root
   Host: localhost
     db: t
Command: Query
   Time: 1
  State: Sending data
   Info: CREATE TEMPORARY TABLE ps_cat_filter_restriction ENGINE=MEMORY
														SELECT cp.id_product, MIN(cp.position) position FROM ps_category c
														JOIN ps_category_product cp ON (c.id_category = cp.id_category AND
														c.nleft >= 17
														AND c.nright <= 78
														AND c.active = 1)
														JOIN `ps_product` p ON (p.id_product=cp.id_product)

														 INNER JOIN ps_product_shop product_shop
		ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
														WHERE 1  AND product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog")
														GROUP BY cp.id_product ORDER BY position, id_product
*************************** 9. row ***************************
     Id: 373238
   User: root
   Host: localhost
     db: t
Command: Query
   Time: 1
  State: Sending data
   Info: CREATE TEMPORARY TABLE ps_cat_filter_restriction ENGINE=MEMORY
														SELECT cp.id_product, MIN(cp.position) position FROM ps_category c
														JOIN ps_category_product cp ON (c.id_category = cp.id_category AND
														c.nleft >= 3
														AND c.nright <= 16
														AND c.active = 1)
														JOIN `ps_product` p ON (p.id_product=cp.id_product)

														 INNER JOIN ps_product_shop product_shop
		ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
														WHERE 1  AND product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog")
														GROUP BY cp.id_product ORDER BY position, id_product
*************************** 10. row ***************************
     Id: 373241
   User: root
   Host: localhost
     db: t
Command: Query
   Time: 1
  State: Sending data
   Info: CREATE TEMPORARY TABLE ps_cat_filter_restriction ENGINE=MEMORY
														SELECT cp.id_product, MIN(cp.position) position FROM ps_category c
														JOIN ps_category_product cp ON (c.id_category = cp.id_category AND
														c.nleft >= 17
														AND c.nright <= 78
														AND c.active = 1)
														JOIN `ps_product` p ON (p.id_product=cp.id_product)

														 INNER JOIN ps_product_shop product_shop
		ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
														WHERE 1  AND product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog")
														GROUP BY cp.id_product ORDER BY position, id_product
*************************** 11. row ***************************
     Id: 373248
   User: root
   Host: localhost
     db: t
Command: Query
   Time: 0
  State: Sending data
   Info: CREATE TEMPORARY TABLE ps_cat_filter_restriction ENGINE=MEMORY
														SELECT cp.id_product, MIN(cp.position) position FROM ps_category c
														JOIN ps_category_product cp ON (c.id_category = cp.id_category AND
														c.nleft >= 79
														AND c.nright <= 142
														AND c.active = 1)
														JOIN `ps_product` p ON (p.id_product=cp.id_product)

														 INNER JOIN ps_product_shop product_shop
		ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
														WHERE 1  AND product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog")
														GROUP BY cp.id_product ORDER BY position, id_product
*************************** 12. row ***************************
     Id: 373258
   User: root
   Host: localhost
     db: t
Command: Query
   Time: 0
  State: Sending data
   Info: CREATE TEMPORARY TABLE ps_cat_filter_restriction ENGINE=MEMORY
														SELECT cp.id_product, MIN(cp.position) position FROM ps_category c
														JOIN ps_category_product cp ON (c.id_category = cp.id_category AND
														c.nleft >= 17
														AND c.nright <= 78
														AND c.active = 1)
														JOIN `ps_product` p ON (p.id_product=cp.id_product)

														 INNER JOIN ps_product_shop product_shop
		ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
														WHERE 1  AND product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog")
														GROUP BY cp.id_product ORDER BY position, id_product
*************************** 13. row ***************************
     Id: 373263
   User: root
   Host: localhost
     db: t
Command: Query
   Time: 0
  State: Sending data
   Info: CREATE TEMPORARY TABLE ps_cat_filter_restriction ENGINE=MEMORY
														SELECT cp.id_product, MIN(cp.position) position FROM ps_category c
														JOIN ps_category_product cp ON (c.id_category = cp.id_category AND
														c.nleft >= 17
														AND c.nright <= 78
														AND c.active = 1)
														JOIN `ps_product` p ON (p.id_product=cp.id_product)

														 INNER JOIN ps_product_shop product_shop
		ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
														WHERE 1  AND product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog")
														GROUP BY cp.id_product ORDER BY position, id_product
*************************** 14. row ***************************
     Id: 373264
   User: root
   Host: localhost
     db: t
Command: Query
   Time: 0
  State: Sending data
   Info: CREATE TEMPORARY TABLE ps_cat_filter_restriction ENGINE=MEMORY
														SELECT cp.id_product, MIN(cp.position) position FROM ps_category c
														JOIN ps_category_product cp ON (c.id_category = cp.id_category AND
														c.nleft >= 3
														AND c.nright <= 16
														AND c.active = 1)
														JOIN `ps_product` p ON (p.id_product=cp.id_product)

														 INNER JOIN ps_product_shop product_shop
		ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
														WHERE 1  AND product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog")
														GROUP BY cp.id_product ORDER BY position, id_product
*************************** 15. row ***************************
     Id: 373269
   User: root
   Host: localhost
     db: t
Command: Query
   Time: 0
  State: Sending data
   Info: CREATE TEMPORARY TABLE ps_cat_filter_restriction ENGINE=MEMORY
														SELECT cp.id_product, MIN(cp.position) position FROM ps_category c
														JOIN ps_category_product cp ON (c.id_category = cp.id_category AND
														c.nleft >= 3
														AND c.nright <= 16
														AND c.active = 1)
														JOIN `ps_product` p ON (p.id_product=cp.id_product)

														 INNER JOIN ps_product_shop product_shop
		ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
														WHERE 1  AND product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog")
														GROUP BY cp.id_product ORDER BY position, id_product
*************************** 16. row ***************************
     Id: 373270
   User: root
   Host: localhost
     db: t
Command: Query
   Time: 0
  State: Sending data
   Info: CREATE TEMPORARY TABLE ps_cat_filter_restriction ENGINE=MEMORY
														SELECT cp.id_product, MIN(cp.position) position FROM ps_category c
														JOIN ps_category_product cp ON (c.id_category = cp.id_category AND
														c.nleft >= 17
														AND c.nright <= 78
														AND c.active = 1)
														JOIN `ps_product` p ON (p.id_product=cp.id_product)

														 INNER JOIN ps_product_shop product_shop
		ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
														WHERE 1  AND product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog")
														GROUP BY cp.id_product ORDER BY position, id_product
*************************** 17. row ***************************
     Id: 373295
   User: root
   Host: localhost
     db: t
Command: Query
   Time: 0
  State: Sending data
   Info: CREATE TEMPORARY TABLE ps_cat_filter_restriction ENGINE=MEMORY
														SELECT cp.id_product, MIN(cp.position) position FROM ps_category c
														JOIN ps_category_product cp ON (c.id_category = cp.id_category AND
														c.nleft >= 17
														AND c.nright <= 78
														AND c.active = 1)
														JOIN `ps_product` p ON (p.id_product=cp.id_product)

														 INNER JOIN ps_product_shop product_shop
		ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
														WHERE 1  AND product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog")
														GROUP BY cp.id_product ORDER BY position, id_product
*************************** 18. row ***************************
     Id: 373299
   User: root
   Host: localhost
     db: t
Command: Query
   Time: 0
  State: Sending data
   Info: CREATE TEMPORARY TABLE ps_cat_filter_restriction ENGINE=MEMORY
														SELECT cp.id_product, MIN(cp.position) position FROM ps_category c
														JOIN ps_category_product cp ON (c.id_category = cp.id_category AND
														c.nleft >= 17
														AND c.nright <= 78
														AND c.active = 1)
														JOIN `ps_product` p ON (p.id_product=cp.id_product)

														 INNER JOIN ps_product_shop product_shop
		ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
														WHERE 1  AND product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog")
														GROUP BY cp.id_product ORDER BY position, id_product
*************************** 19. row ***************************
     Id: 373305
   User: root
   Host: localhost
     db: t
Command: Query
   Time: 0
  State: Sending data
   Info: CREATE TEMPORARY TABLE ps_cat_filter_restriction ENGINE=MEMORY
														SELECT cp.id_product, MIN(cp.position) position FROM ps_category c
														JOIN ps_category_product cp ON (c.id_category = cp.id_category AND
														c.nleft >= 79
														AND c.nright <= 142
														AND c.active = 1)
														JOIN `ps_product` p ON (p.id_product=cp.id_product)

														 INNER JOIN ps_product_shop product_shop
		ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
														WHERE 1  AND product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog")
														GROUP BY cp.id_product ORDER BY position, id_product
*************************** 20. row ***************************
     Id: 373307
   User: root
   Host: localhost
     db: t
Command: Query
   Time: 0
  State: Sending data
   Info: CREATE TEMPORARY TABLE ps_cat_filter_restriction ENGINE=MEMORY
														SELECT cp.id_product, MIN(cp.position) position FROM ps_category c
														JOIN ps_category_product cp ON (c.id_category = cp.id_category AND
														c.nleft >= 79
														AND c.nright <= 142
														AND c.active = 1)
														JOIN `ps_product` p ON (p.id_product=cp.id_product)

														 INNER JOIN ps_product_shop product_shop
		ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
														WHERE 1  AND product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog")
														GROUP BY cp.id_product ORDER BY position, id_product
*************************** 21. row ***************************
     Id: 373308
   User: root
   Host: localhost
     db: t
Command: Query
   Time: 0
  State: Sending data
   Info: CREATE TEMPORARY TABLE ps_cat_filter_restriction ENGINE=MEMORY
														SELECT cp.id_product, MIN(cp.position) position FROM ps_category c
														JOIN ps_category_product cp ON (c.id_category = cp.id_category AND
														c.nleft >= 3
														AND c.nright <= 16
														AND c.active = 1)
														JOIN `ps_product` p ON (p.id_product=cp.id_product)

														 INNER JOIN ps_product_shop product_shop
		ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
														WHERE 1  AND product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog")
														GROUP BY cp.id_product ORDER BY position, id_product
*************************** 22. row ***************************
     Id: 373316
   User: root
   Host: localhost
     db: t
Command: Query
   Time: 0
  State: Sending data
   Info: CREATE TEMPORARY TABLE ps_cat_filter_restriction ENGINE=MEMORY
														SELECT cp.id_product, MIN(cp.position) position FROM ps_category c
														JOIN ps_category_product cp ON (c.id_category = cp.id_category AND
														c.nleft >= 3
														AND c.nright <= 16
														AND c.active = 1)
														JOIN `ps_product` p ON (p.id_product=cp.id_product)

														 INNER JOIN ps_product_shop product_shop
		ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
														WHERE 1  AND product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog")
														GROUP BY cp.id_product ORDER BY position, id_product
*************************** 23. row ***************************
     Id: 373322
   User: root
   Host: localhost
     db: t
Command: Query
   Time: 0
  State: Sending data
   Info: CREATE TEMPORARY TABLE ps_cat_filter_restriction ENGINE=MEMORY
														SELECT cp.id_product, MIN(cp.position) position FROM ps_category c
														JOIN ps_category_product cp ON (c.id_category = cp.id_category AND
														c.nleft >= 17
														AND c.nright <= 78
														AND c.active = 1)
														JOIN `ps_product` p ON (p.id_product=cp.id_product)

														 INNER JOIN ps_product_shop product_shop
		ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
														WHERE 1  AND product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog")
														GROUP BY cp.id_product ORDER BY position, id_product
*************************** 24. row ***************************
     Id: 373327
   User: root
   Host: localhost
     db: t
Command: Query
   Time: 0
  State: Sending data
   Info: CREATE TEMPORARY TABLE ps_cat_filter_restriction ENGINE=MEMORY
														SELECT cp.id_product, MIN(cp.position) position FROM ps_category c
														JOIN ps_category_product cp ON (c.id_category = cp.id_category AND
														c.nleft >= 79
														AND c.nright <= 142
														AND c.active = 1)
														JOIN `ps_product` p ON (p.id_product=cp.id_product)

														 INNER JOIN ps_product_shop product_shop
		ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
														WHERE 1  AND product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog")
														GROUP BY cp.id_product ORDER BY position, id_product
*************************** 25. row ***************************
     Id: 373330
   User: root
   Host: localhost
     db: t
Command: Query
   Time: 0
  State: Sending data
   Info: CREATE TEMPORARY TABLE ps_cat_filter_restriction ENGINE=MEMORY
														SELECT cp.id_product, MIN(cp.position) position FROM ps_category c
														JOIN ps_category_product cp ON (c.id_category = cp.id_category AND
														c.nleft >= 17
														AND c.nright <= 78
														AND c.active = 1)
														JOIN `ps_product` p ON (p.id_product=cp.id_product)

														 INNER JOIN ps_product_shop product_shop
		ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
														WHERE 1  AND product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog")
														GROUP BY cp.id_product ORDER BY position, id_product
*************************** 26. row ***************************
     Id: 373346
   User: root
   Host: localhost
     db: t
Command: Query
   Time: 0
  State: Sending data
   Info: CREATE TEMPORARY TABLE ps_cat_filter_restriction ENGINE=MEMORY
														SELECT cp.id_product, MIN(cp.position) position FROM ps_category c
														JOIN ps_category_product cp ON (c.id_category = cp.id_category AND
														c.nleft >= 79
														AND c.nright <= 142
														AND c.active = 1)
														JOIN `ps_product` p ON (p.id_product=cp.id_product)

														 INNER JOIN ps_product_shop product_shop
		ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
														WHERE 1  AND product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog")
														GROUP BY cp.id_product ORDER BY position, id_product
*************************** 27. row ***************************
     Id: 373348
   User: root
   Host: localhost
     db: t
Command: Query
   Time: 0
  State: Sending data
   Info: CREATE TEMPORARY TABLE ps_cat_filter_restriction ENGINE=MEMORY
														SELECT cp.id_product, MIN(cp.position) position FROM ps_category c
														JOIN ps_category_product cp ON (c.id_category = cp.id_category AND
														c.nleft >= 17
														AND c.nright <= 78
														AND c.active = 1)
														JOIN `ps_product` p ON (p.id_product=cp.id_product)

														 INNER JOIN ps_product_shop product_shop
		ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
														WHERE 1  AND product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog")
														GROUP BY cp.id_product ORDER BY position, id_product
*************************** 28. row ***************************
     Id: 373351
   User: root
   Host: localhost
     db: t
Command: Query
   Time: 0
  State: Sending data
   Info: CREATE TEMPORARY TABLE ps_cat_filter_restriction ENGINE=MEMORY
														SELECT cp.id_product, MIN(cp.position) position FROM ps_category c
														JOIN ps_category_product cp ON (c.id_category = cp.id_category AND
														c.nleft >= 3
														AND c.nright <= 16
														AND c.active = 1)
														JOIN `ps_product` p ON (p.id_product=cp.id_product)

														 INNER JOIN ps_product_shop product_shop
		ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
														WHERE 1  AND product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog")
														GROUP BY cp.id_product ORDER BY position, id_product
*************************** 29. row ***************************
     Id: 373353
   User: root
   Host: localhost
     db: t
Command: Query
   Time: 0
  State: Sending data
   Info: CREATE TEMPORARY TABLE ps_cat_filter_restriction ENGINE=MEMORY
														SELECT cp.id_product, MIN(cp.position) position FROM ps_category c
														JOIN ps_category_product cp ON (c.id_category = cp.id_category AND
														c.nleft >= 79
														AND c.nright <= 142
														AND c.active = 1)
														JOIN `ps_product` p ON (p.id_product=cp.id_product)

														 INNER JOIN ps_product_shop product_shop
		ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
														WHERE 1  AND product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog")
														GROUP BY cp.id_product ORDER BY position, id_product
*************************** 30. row ***************************
     Id: 373355
   User: root
   Host: localhost
     db: t
Command: Query
   Time: 0
  State: Sending data
   Info: CREATE TEMPORARY TABLE ps_cat_filter_restriction ENGINE=MEMORY
														SELECT cp.id_product, MIN(cp.position) position FROM ps_category c
														JOIN ps_category_product cp ON (c.id_category = cp.id_category AND
														c.nleft >= 79
														AND c.nright <= 142
														AND c.active = 1)
														JOIN `ps_product` p ON (p.id_product=cp.id_product)

														 INNER JOIN ps_product_shop product_shop
		ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
														WHERE 1  AND product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog")
														GROUP BY cp.id_product ORDER BY position, id_product
*************************** 31. row ***************************
     Id: 373359
   User: root
   Host: localhost
     db: t
Command: Query
   Time: 0
  State: Sending data
   Info: CREATE TEMPORARY TABLE ps_cat_filter_restriction ENGINE=MEMORY
														SELECT cp.id_product, MIN(cp.position) position FROM ps_category c
														JOIN ps_category_product cp ON (c.id_category = cp.id_category AND
														c.nleft >= 79
														AND c.nright <= 142
														AND c.active = 1)
														JOIN `ps_product` p ON (p.id_product=cp.id_product)

														 INNER JOIN ps_product_shop product_shop
		ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
														WHERE 1  AND product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog")
														GROUP BY cp.id_product ORDER BY position, id_product
*************************** 32. row ***************************
     Id: 373360
   User: root
   Host: localhost
     db: t
Command: Query
   Time: 0
  State: Sending data
   Info: CREATE TEMPORARY TABLE ps_cat_filter_restriction ENGINE=MEMORY
														SELECT cp.id_product, MIN(cp.position) position FROM ps_category c
														JOIN ps_category_product cp ON (c.id_category = cp.id_category AND
														c.nleft >= 3
														AND c.nright <= 16
														AND c.active = 1)
														JOIN `ps_product` p ON (p.id_product=cp.id_product)

														 INNER JOIN ps_product_shop product_shop
		ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
														WHERE 1  AND product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog")
														GROUP BY cp.id_product ORDER BY position, id_product
*************************** 33. row ***************************
     Id: 373378
   User: root
   Host: localhost
     db: t
Command: Query
   Time: 0
  State: Sending data
   Info: CREATE TEMPORARY TABLE ps_cat_filter_restriction ENGINE=MEMORY
														SELECT cp.id_product, MIN(cp.position) position FROM ps_category c
														JOIN ps_category_product cp ON (c.id_category = cp.id_category AND
														c.nleft >= 3
														AND c.nright <= 16
														AND c.active = 1)
														JOIN `ps_product` p ON (p.id_product=cp.id_product)

														 INNER JOIN ps_product_shop product_shop
		ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
														WHERE 1  AND product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog")
														GROUP BY cp.id_product ORDER BY position, id_product
*************************** 34. row ***************************
     Id: 373384
   User: root
   Host: localhost
     db: t
Command: Query
   Time: 0
  State: Sending data
   Info: CREATE TEMPORARY TABLE ps_cat_filter_restriction ENGINE=MEMORY
														SELECT cp.id_product, MIN(cp.position) position FROM ps_category c
														JOIN ps_category_product cp ON (c.id_category = cp.id_category AND
														c.nleft >= 3
														AND c.nright <= 16
														AND c.active = 1)
														JOIN `ps_product` p ON (p.id_product=cp.id_product)

														 INNER JOIN ps_product_shop product_shop
		ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
														WHERE 1  AND product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog")
														GROUP BY cp.id_product ORDER BY position, id_product
*************************** 35. row ***************************
     Id: 373403
   User: root
   Host: localhost
     db: t
Command: Query
   Time: 0
  State: Sending data
   Info: CREATE TEMPORARY TABLE ps_cat_filter_restriction ENGINE=MEMORY
														SELECT cp.id_product, MIN(cp.position) position FROM ps_category c
														JOIN ps_category_product cp ON (c.id_category = cp.id_category AND
														c.nleft >= 3
														AND c.nright <= 16
														AND c.active = 1)
														JOIN `ps_product` p ON (p.id_product=cp.id_product)

														 INNER JOIN ps_product_shop product_shop
		ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
														WHERE 1  AND product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog")
														GROUP BY cp.id_product ORDER BY position, id_product
*************************** 36. row ***************************
     Id: 373421
   User: root
   Host: localhost
     db: t
Command: Sleep
   Time: 0
  State:
   Info: NULL
*************************** 37. row ***************************
     Id: 373424
   User: root
   Host: localhost
     db: t
Command: Sleep
   Time: 0
  State:
   Info: NULL
*************************** 38. row ***************************
     Id: 373427
   User: root
   Host: localhost
     db: t
Command: Sleep
   Time: 0
  State:
   Info: NULL
*************************** 39. row ***************************
     Id: 373428
   User: root
   Host: localhost
     db: t
Command: Query
   Time: 0
  State: Sending data
   Info: CREATE TEMPORARY TABLE ps_cat_filter_restriction ENGINE=MEMORY
														SELECT cp.id_product, MIN(cp.position) position FROM ps_category c
														JOIN ps_category_product cp ON (c.id_category = cp.id_category AND
														c.nleft >= 3
														AND c.nright <= 16
														AND c.active = 1)
														JOIN `ps_product` p ON (p.id_product=cp.id_product)

														 INNER JOIN ps_product_shop product_shop
		ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
														WHERE 1  AND product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog")
														GROUP BY cp.id_product ORDER BY position, id_product
*************************** 40. row ***************************
     Id: 373430
   User: root
   Host: localhost
     db: t
Command: Query
   Time: 0
  State: Sending data
   Info: CREATE TEMPORARY TABLE ps_cat_filter_restriction ENGINE=MEMORY
														SELECT cp.id_product, MIN(cp.position) position FROM ps_category c
														JOIN ps_category_product cp ON (c.id_category = cp.id_category AND
														c.nleft >= 3
														AND c.nright <= 16
														AND c.active = 1)
														JOIN `ps_product` p ON (p.id_product=cp.id_product)

														 INNER JOIN ps_product_shop product_shop
		ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
														WHERE 1  AND product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog")
														GROUP BY cp.id_product ORDER BY position, id_product
*************************** 41. row ***************************
     Id: 373431
   User: root
   Host: localhost
     db: t
Command: Sleep
   Time: 0
  State:
   Info: NULL
*************************** 42. row ***************************
     Id: 373435
   User: root
   Host: localhost
     db: t
Command: Query
   Time: 0
  State: Sending data
   Info: CREATE TEMPORARY TABLE ps_cat_filter_restriction ENGINE=MEMORY
														SELECT cp.id_product, MIN(cp.position) position FROM ps_category c
														JOIN ps_category_product cp ON (c.id_category = cp.id_category AND
														c.nleft >= 79
														AND c.nright <= 142
														AND c.active = 1)
															JOIN `ps_product` p ON (p.id_product=cp.id_product)

														 INNER JOIN ps_product_shop product_shop
		ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
														WHERE 1  AND product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog")
														GROUP BY cp.id_product ORDER BY position, id_product
*************************** 43. row ***************************
     Id: 373436
   User: root
   Host: localhost
     db: t
Command: Query
   Time: 0
  State: Sending data
   Info: CREATE TEMPORARY TABLE ps_cat_filter_restriction ENGINE=MEMORY
														SELECT cp.id_product, MIN(cp.position) position FROM ps_category c
														JOIN ps_category_product cp ON (c.id_category = cp.id_category AND
														c.nleft >= 3
														AND c.nright <= 16
														AND c.active = 1)
														JOIN `ps_product` p ON (p.id_product=cp.id_product)

														 INNER JOIN ps_product_shop product_shop
		ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
														WHERE 1  AND product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog")
														GROUP BY cp.id_product ORDER BY position, id_product
*************************** 44. row ***************************
     Id: 373438
   User: root
   Host: localhost
     db: t
Command: Query
   Time: 0
  State: Sending data
   Info: CREATE TEMPORARY TABLE ps_cat_filter_restriction ENGINE=MEMORY
														SELECT cp.id_product, MIN(cp.position) position FROM ps_category c
														JOIN ps_category_product cp ON (c.id_category = cp.id_category AND
														c.nleft >= 6
														AND c.nright <= 7
														AND c.active = 1)
														JOIN `ps_product` p ON (p.id_product=cp.id_product)

														 INNER JOIN ps_product_shop product_shop
		ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
														WHERE 1  AND product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog")
														GROUP BY cp.id_product ORDER BY position, id_product
*************************** 45. row ***************************
     Id: 373439
   User: root
   Host: localhost
     db: t
Command: Sleep
   Time: 0
  State:
   Info: NULL
*************************** 46. row ***************************
     Id: 373440
   User: root
   Host: localhost
     db: t
Command: Sleep
   Time: 0
  State:
   Info: NULL
*************************** 47. row ***************************
     Id: 373441
   User: root
   Host: localhost
     db: t
Command: Sleep
   Time: 0
  State:
   Info: NULL
*************************** 48. row ***************************
     Id: 373442
   User: root
   Host: localhost
     db: t
Command: Sleep
   Time: 0
  State:
   Info: NULL
*************************** 49. row ***************************
     Id: 373443
   User: root
   Host: localhost
     db: t
Command: Sleep
   Time: 0
  State:
   Info: NULL
*************************** 50. row ***************************
     Id: 373444
   User: root
   Host: localhost
     db: t
Command: Sleep
   Time: 0
  State:
   Info: NULL
*************************** 51. row ***************************
     Id: 373445
   User: root
   Host: localhost
     db: t
Command: Sleep
   Time: 0
  State:
   Info: NULL
*************************** 52. row ***************************
     Id: 373446
   User: root
   Host: localhost
     db: t
Command: Sleep
   Time: 0
  State:
   Info: NULL
*************************** 53. row ***************************
     Id: 373447
   User: root
   Host: localhost
     db: t
Command: Sleep
   Time: 0
  State:
   Info: NULL
*************************** 54. row ***************************
     Id: 373448
   User: root
   Host: localhost
     db: t
Command: Sleep
   Time: 0
  State:
   Info: NULL
*************************** 55. row ***************************
     Id: 373449
   User: root
   Host: localhost
     db: t
Command: Sleep
   Time: 0
  State:
   Info: NULL
*************************** 56. row ***************************
     Id: 373450
   User: root
   Host: localhost
     db: t
Command: Sleep
   Time: 0
  State:
   Info: NULL
*************************** 57. row ***************************
     Id: 373451
   User: root
   Host: localhost
     db: t
Command: Sleep
   Time: 0
  State:
   Info: NULL
*************************** 58. row ***************************
     Id: 373452
   User: root
   Host: localhost
     db: t
Command: Sleep
   Time: 0
  State:
   Info: NULL
*************************** 59. row ***************************
     Id: 373453
   User: root
   Host: localhost
     db: t
Command: Sleep
   Time: 0
  State:
   Info: NULL
*************************** 60. row ***************************
     Id: 373454
   User: root
   Host: localhost
     db: t
Command: Sleep
   Time: 0
  State:
   Info: NULL
60 rows in set (0.00 sec)