API tools faq
paste
Guest User

Untitled

a guest
Jul 20th, 2018
69
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 68.88 KB | None | 0 0
raw download clone embed print report
  1. Id User Host db Command Time State Info
  2. 364442 someclient someserver:57451 someclient Sleep 1 NULL
  3. 371080 someclient someserver:37048 someclient Sleep 1 NULL
  4. 374204 someclient someserver:53546 someclient Sleep 3694 NULL
  5. 381368 someclient someserver:53602 someclient Query 360 Locked UPDATE `shop_productvariation` SET `unit_price` = '49.95', `sale_id` = NULL, `sale_price` = NULL, `sale_from` = NULL, `sale_to` = NULL, `num_in_stock_pool` = 0, `product_id` = 18256, `sku` = '216134-08-14', `num_in_stock` = 54, `default` = 0, `image_id` = 40331, `option1` = '14', `option2` = NULL WHERE `shop_productvariation`.`id` = 78703
  6. 396246 someclient someserver:56031 someclient Query 348 Locked SELECT DISTINCT `shop_product`.`id`, `shop_product`.`keywords_string`, `shop_product`.`rating_count`, `shop_product`.`rating_average`, `shop_product`.`title`, `shop_product`.`slug`, `shop_product`.`status`, `shop_product`.`publish_date`, `shop_product`.`expiry_date`, `shop_product`.`description`, `shop_product`.`short_url`, `shop_product`.`site_id`, `shop_product`.`content`, `shop_product`.`unit_price`, `shop_product`.`sale_id`, `shop_product`.`sale_price`, `shop_product`.`sale_from`, `shop_product`.`sale_to`, `shop_product`.`available`, `shop_product`.`master_item_code`, `shop_product`.`actual_item_code`, `shop_product`.`colour`, `shop_product`.`image`, `shop_product`.`date_added`, `shop_product`.`featured`, `shop_product`.`in_stock`, `shop_product`.`ranking` FROM `shop_product` LEFT OUTER JOIN `shop_product_categories` ON (`shop_product`.`id` = `shop_product_categories`.`product_id`) LEFT OUTER JOIN `shop_category` ON (`shop_product_categories`.`category_id` = `shop_category`.`page_ptr_id`) LEFT OUTER JOIN `pages_page` ON (`shop_category`.`page_ptr_id` = `pages_page`.`id`) LEFT OUTER JOIN `shop_productvariation` ON (`shop_product`.`id` = `shop_productvariation`.`product_id`) LEFT OUTER JOIN `shop_product_categories` T7 ON (`shop_product`.`id` = T7.`product_id`) LEFT OUTER JOIN `shop_category` T8 ON (T7.`category_id` = T8.`page_ptr_id`) LEFT OUTER JOIN `pages_page` T9 ON (T8.`page_ptr_id` = T9.`id`) LEFT OUTER JOIN `shop_productvariation` T10 ON (`shop_product`.`id` = T10.`product_id`) WHERE (`shop_product`.`site_id` = 1 AND (`shop_product`.`title` LIKE '%huggie%' OR `shop_product`.`content` LIKE '%huggie%' OR `pages_page`.`title` LIKE '%huggie%' OR `shop_productvariation`.`sku` LIKE '%huggie%' ) AND (`shop_product`.`title` LIKE '%tights%' OR `shop_product`.`content` LIKE '%tights%' OR T9.`title` LIKE '%tights%' OR T10.`sku` LIKE '%tights%' )) ORDER BY `shop_product`.`title` DESC
  7. 396256 someclient someserver:56087 someclient Query 941 Sending data SELECT COUNT(DISTINCT `shop_product`.`id`) FROM `shop_product` LEFT OUTER JOIN `shop_product_categories` ON (`shop_product`.`id` = `shop_product_categories`.`product_id`) LEFT OUTER JOIN `shop_category` ON (`shop_product_categories`.`category_id` = `shop_category`.`page_ptr_id`) LEFT OUTER JOIN `pages_page` ON (`shop_category`.`page_ptr_id` = `pages_page`.`id`) LEFT OUTER JOIN `shop_productvariation` ON (`shop_product`.`id` = `shop_productvariation`.`product_id`) LEFT OUTER JOIN `shop_product_categories` T7 ON (`shop_product`.`id` = T7.`product_id`) LEFT OUTER JOIN `shop_category` T8 ON (T7.`category_id` = T8.`page_ptr_id`) LEFT OUTER JOIN `pages_page` T9 ON (T8.`page_ptr_id` = T9.`id`) LEFT OUTER JOIN `shop_productvariation` T10 ON (`shop_product`.`id` = T10.`product_id`) LEFT OUTER JOIN `shop_product_categories` T11 ON (`shop_product`.`id` = T11.`product_id`) LEFT OUTER JOIN `shop_category` T12 ON (T11.`category_id` = T12.`page_ptr_id`) LEFT OUTER JOIN `pages_page` T13 ON (T12.`page_ptr_id` = T13.`id`) LEFT OUTER JOIN `shop_productvariation` T14 ON (`shop_product`.`id` = T14.`product_id`) LEFT OUTER JOIN `shop_product_categories` T15 ON (`shop_product`.`id` = T15.`product_id`) LEFT OUTER JOIN `shop_category` T16 ON (T15.`category_id` = T16.`page_ptr_id`) LEFT OUTER JOIN `pages_page` T17 ON (T16.`page_ptr_id` = T17.`id`) LEFT OUTER JOIN `shop_productvariation` T18 ON (`shop_product`.`id` = T18.`product_id`) WHERE (`shop_product`.`site_id` = 1 AND (`shop_product`.`title` LIKE '%on%' OR `shop_product`.`content` LIKE '%on%' OR `pages_page`.`title` LIKE '%on%' OR `shop_productvariation`.`sku` LIKE '%on%' ) AND (`shop_product`.`title` LIKE '%a%' OR `shop_product`.`content` LIKE '%a%' OR T9.`title` LIKE '%a%' OR T10.`sku` LIKE '%a%' ) AND (`shop_product`.`title` LIKE '%roll%' OR `shop_product`.`content` LIKE '%roll%' OR T13.`title` LIKE '%roll%' OR T14.`sku` LIKE '%roll%' ) AND (`shop_product`.`title` LIKE '%tape%' OR `shop_product`.`content` LIKE '%tape%' OR T17.`title` LIKE '%tape%' OR T18.`sku` LIKE '%tape%' ))
  8. 396288 someclient someserver:56137 someclient Query 884 Sending data SELECT COUNT(DISTINCT `shop_product`.`id`) FROM `shop_product` LEFT OUTER JOIN `shop_product_categories` ON (`shop_product`.`id` = `shop_product_categories`.`product_id`) LEFT OUTER JOIN `shop_category` ON (`shop_product_categories`.`category_id` = `shop_category`.`page_ptr_id`) LEFT OUTER JOIN `pages_page` ON (`shop_category`.`page_ptr_id` = `pages_page`.`id`) LEFT OUTER JOIN `shop_productvariation` ON (`shop_product`.`id` = `shop_productvariation`.`product_id`) LEFT OUTER JOIN `shop_product_categories` T7 ON (`shop_product`.`id` = T7.`product_id`) LEFT OUTER JOIN `shop_category` T8 ON (T7.`category_id` = T8.`page_ptr_id`) LEFT OUTER JOIN `pages_page` T9 ON (T8.`page_ptr_id` = T9.`id`) LEFT OUTER JOIN `shop_productvariation` T10 ON (`shop_product`.`id` = T10.`product_id`) LEFT OUTER JOIN `shop_product_categories` T11 ON (`shop_product`.`id` = T11.`product_id`) LEFT OUTER JOIN `shop_category` T12 ON (T11.`category_id` = T12.`page_ptr_id`) LEFT OUTER JOIN `pages_page` T13 ON (T12.`page_ptr_id` = T13.`id`) LEFT OUTER JOIN `shop_productvariation` T14 ON (`shop_product`.`id` = T14.`product_id`) LEFT OUTER JOIN `shop_product_categories` T15 ON (`shop_product`.`id` = T15.`product_id`) LEFT OUTER JOIN `shop_category` T16 ON (T15.`category_id` = T16.`page_ptr_id`) LEFT OUTER JOIN `pages_page` T17 ON (T16.`page_ptr_id` = T17.`id`) LEFT OUTER JOIN `shop_productvariation` T18 ON (`shop_product`.`id` = T18.`product_id`) WHERE (`shop_product`.`site_id` = 1 AND (`shop_product`.`title` LIKE '%on%' OR `shop_product`.`content` LIKE '%on%' OR `pages_page`.`title` LIKE '%on%' OR `shop_productvariation`.`sku` LIKE '%on%' ) AND (`shop_product`.`title` LIKE '%a%' OR `shop_product`.`content` LIKE '%a%' OR T9.`title` LIKE '%a%' OR T10.`sku` LIKE '%a%' ) AND (`shop_product`.`title` LIKE '%roll%' OR `shop_product`.`content` LIKE '%roll%' OR T13.`title` LIKE '%roll%' OR T14.`sku` LIKE '%roll%' ) AND (`shop_product`.`title` LIKE '%tape%' OR `shop_product`.`content` LIKE '%tape%' OR T17.`title` LIKE '%tape%' OR T18.`sku` LIKE '%tape%' ))
  9. 396305 someclient someserver:59371 someclient Query 604 Sending data SELECT COUNT(DISTINCT `shop_product`.`id`) FROM `shop_product` LEFT OUTER JOIN `shop_product_categories` ON (`shop_product`.`id` = `shop_product_categories`.`product_id`) LEFT OUTER JOIN `shop_category` ON (`shop_product_categories`.`category_id` = `shop_category`.`page_ptr_id`) LEFT OUTER JOIN `pages_page` ON (`shop_category`.`page_ptr_id` = `pages_page`.`id`) LEFT OUTER JOIN `shop_productvariation` ON (`shop_product`.`id` = `shop_productvariation`.`product_id`) LEFT OUTER JOIN `shop_product_categories` T7 ON (`shop_product`.`id` = T7.`product_id`) LEFT OUTER JOIN `shop_category` T8 ON (T7.`category_id` = T8.`page_ptr_id`) LEFT OUTER JOIN `pages_page` T9 ON (T8.`page_ptr_id` = T9.`id`) LEFT OUTER JOIN `shop_productvariation` T10 ON (`shop_product`.`id` = T10.`product_id`) LEFT OUTER JOIN `shop_product_categories` T11 ON (`shop_product`.`id` = T11.`product_id`) LEFT OUTER JOIN `shop_category` T12 ON (T11.`category_id` = T12.`page_ptr_id`) LEFT OUTER JOIN `pages_page` T13 ON (T12.`page_ptr_id` = T13.`id`) LEFT OUTER JOIN `shop_productvariation` T14 ON (`shop_product`.`id` = T14.`product_id`) LEFT OUTER JOIN `shop_product_categories` T15 ON (`shop_product`.`id` = T15.`product_id`) LEFT OUTER JOIN `shop_category` T16 ON (T15.`category_id` = T16.`page_ptr_id`) LEFT OUTER JOIN `pages_page` T17 ON (T16.`page_ptr_id` = T17.`id`) LEFT OUTER JOIN `shop_productvariation` T18 ON (`shop_product`.`id` = T18.`product_id`) WHERE (`shop_product`.`site_id` = 1 AND (`shop_product`.`title` LIKE '%on%' OR `shop_product`.`content` LIKE '%on%' OR `pages_page`.`title` LIKE '%on%' OR `shop_productvariation`.`sku` LIKE '%on%' ) AND (`shop_product`.`title` LIKE '%a%' OR `shop_product`.`content` LIKE '%a%' OR T9.`title` LIKE '%a%' OR T10.`sku` LIKE '%a%' ) AND (`shop_product`.`title` LIKE '%roll%' OR `shop_product`.`content` LIKE '%roll%' OR T13.`title` LIKE '%roll%' OR T14.`sku` LIKE '%roll%' ) AND (`shop_product`.`title` LIKE '%tape%' OR `shop_product`.`content` LIKE '%tape%' OR T17.`title` LIKE '%tape%' OR T18.`sku` LIKE '%tape%' ))
  10. 396339 someclient someserver:59421 someclient Query 670 Sending data SELECT COUNT(DISTINCT `shop_product`.`id`) FROM `shop_product` LEFT OUTER JOIN `shop_product_categories` ON (`shop_product`.`id` = `shop_product_categories`.`product_id`) LEFT OUTER JOIN `shop_category` ON (`shop_product_categories`.`category_id` = `shop_category`.`page_ptr_id`) LEFT OUTER JOIN `pages_page` ON (`shop_category`.`page_ptr_id` = `pages_page`.`id`) LEFT OUTER JOIN `shop_productvariation` ON (`shop_product`.`id` = `shop_productvariation`.`product_id`) LEFT OUTER JOIN `shop_product_categories` T7 ON (`shop_product`.`id` = T7.`product_id`) LEFT OUTER JOIN `shop_category` T8 ON (T7.`category_id` = T8.`page_ptr_id`) LEFT OUTER JOIN `pages_page` T9 ON (T8.`page_ptr_id` = T9.`id`) LEFT OUTER JOIN `shop_productvariation` T10 ON (`shop_product`.`id` = T10.`product_id`) LEFT OUTER JOIN `shop_product_categories` T11 ON (`shop_product`.`id` = T11.`product_id`) LEFT OUTER JOIN `shop_category` T12 ON (T11.`category_id` = T12.`page_ptr_id`) LEFT OUTER JOIN `pages_page` T13 ON (T12.`page_ptr_id` = T13.`id`) LEFT OUTER JOIN `shop_productvariation` T14 ON (`shop_product`.`id` = T14.`product_id`) LEFT OUTER JOIN `shop_product_categories` T15 ON (`shop_product`.`id` = T15.`product_id`) LEFT OUTER JOIN `shop_category` T16 ON (T15.`category_id` = T16.`page_ptr_id`) LEFT OUTER JOIN `pages_page` T17 ON (T16.`page_ptr_id` = T17.`id`) LEFT OUTER JOIN `shop_productvariation` T18 ON (`shop_product`.`id` = T18.`product_id`) WHERE (`shop_product`.`site_id` = 1 AND (`shop_product`.`title` LIKE '%on%' OR `shop_product`.`content` LIKE '%on%' OR `pages_page`.`title` LIKE '%on%' OR `shop_productvariation`.`sku` LIKE '%on%' ) AND (`shop_product`.`title` LIKE '%a%' OR `shop_product`.`content` LIKE '%a%' OR T9.`title` LIKE '%a%' OR T10.`sku` LIKE '%a%' ) AND (`shop_product`.`title` LIKE '%roll%' OR `shop_product`.`content` LIKE '%roll%' OR T13.`title` LIKE '%roll%' OR T14.`sku` LIKE '%roll%' ) AND (`shop_product`.`title` LIKE '%tape%' OR `shop_product`.`content` LIKE '%tape%' OR T17.`title` LIKE '%tape%' OR T18.`sku` LIKE '%tape%' ))
  11. 396370 someclient someserver:59455 someclient Query 348 Locked SELECT COUNT(DISTINCT `shop_product`.`id`) FROM `shop_product` LEFT OUTER JOIN `shop_product_categories` ON (`shop_product`.`id` = `shop_product_categories`.`product_id`) LEFT OUTER JOIN `shop_category` ON (`shop_product_categories`.`category_id` = `shop_category`.`page_ptr_id`) LEFT OUTER JOIN `pages_page` ON (`shop_category`.`page_ptr_id` = `pages_page`.`id`) LEFT OUTER JOIN `shop_productvariation` ON (`shop_product`.`id` = `shop_productvariation`.`product_id`) LEFT OUTER JOIN `shop_product_categories` T7 ON (`shop_product`.`id` = T7.`product_id`) LEFT OUTER JOIN `shop_category` T8 ON (T7.`category_id` = T8.`page_ptr_id`) LEFT OUTER JOIN `pages_page` T9 ON (T8.`page_ptr_id` = T9.`id`) LEFT OUTER JOIN `shop_productvariation` T10 ON (`shop_product`.`id` = T10.`product_id`) WHERE (`shop_product`.`site_id` = 1 AND (`shop_product`.`title` LIKE '%huggie%' OR `shop_product`.`content` LIKE '%huggie%' OR `pages_page`.`title` LIKE '%huggie%' OR `shop_productvariation`.`sku` LIKE '%huggie%' ) AND (`shop_product`.`title` LIKE '%tights%' OR `shop_product`.`content` LIKE '%tights%' OR T9.`title` LIKE '%tights%' OR T10.`sku` LIKE '%tights%' ))
  12. 396371 someclient someserver:59471 someclient Query 714 Sending data SELECT COUNT(DISTINCT `shop_product`.`id`) FROM `shop_product` LEFT OUTER JOIN `shop_product_categories` ON (`shop_product`.`id` = `shop_product_categories`.`product_id`) LEFT OUTER JOIN `shop_category` ON (`shop_product_categories`.`category_id` = `shop_category`.`page_ptr_id`) LEFT OUTER JOIN `pages_page` ON (`shop_category`.`page_ptr_id` = `pages_page`.`id`) LEFT OUTER JOIN `shop_productvariation` ON (`shop_product`.`id` = `shop_productvariation`.`product_id`) LEFT OUTER JOIN `shop_product_categories` T7 ON (`shop_product`.`id` = T7.`product_id`) LEFT OUTER JOIN `shop_category` T8 ON (T7.`category_id` = T8.`page_ptr_id`) LEFT OUTER JOIN `pages_page` T9 ON (T8.`page_ptr_id` = T9.`id`) LEFT OUTER JOIN `shop_productvariation` T10 ON (`shop_product`.`id` = T10.`product_id`) LEFT OUTER JOIN `shop_product_categories` T11 ON (`shop_product`.`id` = T11.`product_id`) LEFT OUTER JOIN `shop_category` T12 ON (T11.`category_id` = T12.`page_ptr_id`) LEFT OUTER JOIN `pages_page` T13 ON (T12.`page_ptr_id` = T13.`id`) LEFT OUTER JOIN `shop_productvariation` T14 ON (`shop_product`.`id` = T14.`product_id`) LEFT OUTER JOIN `shop_product_categories` T15 ON (`shop_product`.`id` = T15.`product_id`) LEFT OUTER JOIN `shop_category` T16 ON (T15.`category_id` = T16.`page_ptr_id`) LEFT OUTER JOIN `pages_page` T17 ON (T16.`page_ptr_id` = T17.`id`) LEFT OUTER JOIN `shop_productvariation` T18 ON (`shop_product`.`id` = T18.`product_id`) WHERE (`shop_product`.`site_id` = 1 AND (`shop_product`.`title` LIKE '%on%' OR `shop_product`.`content` LIKE '%on%' OR `pages_page`.`title` LIKE '%on%' OR `shop_productvariation`.`sku` LIKE '%on%' ) AND (`shop_product`.`title` LIKE '%a%' OR `shop_product`.`content` LIKE '%a%' OR T9.`title` LIKE '%a%' OR T10.`sku` LIKE '%a%' ) AND (`shop_product`.`title` LIKE '%roll%' OR `shop_product`.`content` LIKE '%roll%' OR T13.`title` LIKE '%roll%' OR T14.`sku` LIKE '%roll%' ) AND (`shop_product`.`title` LIKE '%tape%' OR `shop_product`.`content` LIKE '%tape%' OR T17.`title` LIKE '%tape%' OR T18.`sku` LIKE '%tape%' ))
  13. 396454 someclient someserver:59587 someclient Query 409 Sending data SELECT COUNT(DISTINCT `shop_product`.`id`) FROM `shop_product` LEFT OUTER JOIN `shop_product_categories` ON (`shop_product`.`id` = `shop_product_categories`.`product_id`) LEFT OUTER JOIN `shop_category` ON (`shop_product_categories`.`category_id` = `shop_category`.`page_ptr_id`) LEFT OUTER JOIN `pages_page` ON (`shop_category`.`page_ptr_id` = `pages_page`.`id`) LEFT OUTER JOIN `shop_productvariation` ON (`shop_product`.`id` = `shop_productvariation`.`product_id`) LEFT OUTER JOIN `shop_product_categories` T7 ON (`shop_product`.`id` = T7.`product_id`) LEFT OUTER JOIN `shop_category` T8 ON (T7.`category_id` = T8.`page_ptr_id`) LEFT OUTER JOIN `pages_page` T9 ON (T8.`page_ptr_id` = T9.`id`) LEFT OUTER JOIN `shop_productvariation` T10 ON (`shop_product`.`id` = T10.`product_id`) LEFT OUTER JOIN `shop_product_categories` T11 ON (`shop_product`.`id` = T11.`product_id`) LEFT OUTER JOIN `shop_category` T12 ON (T11.`category_id` = T12.`page_ptr_id`) LEFT OUTER JOIN `pages_page` T13 ON (T12.`page_ptr_id` = T13.`id`) LEFT OUTER JOIN `shop_productvariation` T14 ON (`shop_product`.`id` = T14.`product_id`) LEFT OUTER JOIN `shop_product_categories` T15 ON (`shop_product`.`id` = T15.`product_id`) LEFT OUTER JOIN `shop_category` T16 ON (T15.`category_id` = T16.`page_ptr_id`) LEFT OUTER JOIN `pages_page` T17 ON (T16.`page_ptr_id` = T17.`id`) LEFT OUTER JOIN `shop_productvariation` T18 ON (`shop_product`.`id` = T18.`product_id`) WHERE (`shop_product`.`site_id` = 1 AND (`shop_product`.`title` LIKE '%on%' OR `shop_product`.`content` LIKE '%on%' OR `pages_page`.`title` LIKE '%on%' OR `shop_productvariation`.`sku` LIKE '%on%' ) AND (`shop_product`.`title` LIKE '%a%' OR `shop_product`.`content` LIKE '%a%' OR T9.`title` LIKE '%a%' OR T10.`sku` LIKE '%a%' ) AND (`shop_product`.`title` LIKE '%roll%' OR `shop_product`.`content` LIKE '%roll%' OR T13.`title` LIKE '%roll%' OR T14.`sku` LIKE '%roll%' ) AND (`shop_product`.`title` LIKE '%tape%' OR `shop_product`.`content` LIKE '%tape%' OR T17.`title` LIKE '%tape%' OR T18.`sku` LIKE '%tape%' ))
  14. 396457 someclient someserver:59601 someclient Query 519 Sending data SELECT COUNT(DISTINCT `shop_product`.`id`) FROM `shop_product` LEFT OUTER JOIN `shop_product_categories` ON (`shop_product`.`id` = `shop_product_categories`.`product_id`) LEFT OUTER JOIN `shop_category` ON (`shop_product_categories`.`category_id` = `shop_category`.`page_ptr_id`) LEFT OUTER JOIN `pages_page` ON (`shop_category`.`page_ptr_id` = `pages_page`.`id`) LEFT OUTER JOIN `shop_productvariation` ON (`shop_product`.`id` = `shop_productvariation`.`product_id`) LEFT OUTER JOIN `shop_product_categories` T7 ON (`shop_product`.`id` = T7.`product_id`) LEFT OUTER JOIN `shop_category` T8 ON (T7.`category_id` = T8.`page_ptr_id`) LEFT OUTER JOIN `pages_page` T9 ON (T8.`page_ptr_id` = T9.`id`) LEFT OUTER JOIN `shop_productvariation` T10 ON (`shop_product`.`id` = T10.`product_id`) LEFT OUTER JOIN `shop_product_categories` T11 ON (`shop_product`.`id` = T11.`product_id`) LEFT OUTER JOIN `shop_category` T12 ON (T11.`category_id` = T12.`page_ptr_id`) LEFT OUTER JOIN `pages_page` T13 ON (T12.`page_ptr_id` = T13.`id`) LEFT OUTER JOIN `shop_productvariation` T14 ON (`shop_product`.`id` = T14.`product_id`) LEFT OUTER JOIN `shop_product_categories` T15 ON (`shop_product`.`id` = T15.`product_id`) LEFT OUTER JOIN `shop_category` T16 ON (T15.`category_id` = T16.`page_ptr_id`) LEFT OUTER JOIN `pages_page` T17 ON (T16.`page_ptr_id` = T17.`id`) LEFT OUTER JOIN `shop_productvariation` T18 ON (`shop_product`.`id` = T18.`product_id`) WHERE (`shop_product`.`site_id` = 1 AND (`shop_product`.`title` LIKE '%on%' OR `shop_product`.`content` LIKE '%on%' OR `pages_page`.`title` LIKE '%on%' OR `shop_productvariation`.`sku` LIKE '%on%' ) AND (`shop_product`.`title` LIKE '%a%' OR `shop_product`.`content` LIKE '%a%' OR T9.`title` LIKE '%a%' OR T10.`sku` LIKE '%a%' ) AND (`shop_product`.`title` LIKE '%roll%' OR `shop_product`.`content` LIKE '%roll%' OR T13.`title` LIKE '%roll%' OR T14.`sku` LIKE '%roll%' ) AND (`shop_product`.`title` LIKE '%tape%' OR `shop_product`.`content` LIKE '%tape%' OR T17.`title` LIKE '%tape%' OR T18.`sku` LIKE '%tape%' ))
  15. 396458 someclient someserver:59621 someclient Sleep 556 NULL
  16. 396465 someclient someserver:59628 someclient Sleep 549 NULL
  17. 396529 someclient someserver:35893 someclient Sleep 486 NULL
  18. 396533 someclient someserver:35923 someclient Query 359 Locked SELECT `shop_productvariation`.`option1`, `shop_productvariation`.`option2` FROM `shop_productvariation` WHERE (`shop_productvariation`.`product_id` = 7512 AND `shop_productvariation`.`unit_price` IS NOT NULL) ORDER BY `shop_productvariation`.`default` DESC
  19. 396534 someclient someserver:35928 someclient Query 351 Locked SELECT DISTINCT `shop_product`.`id`, `shop_product`.`keywords_string`, `shop_product`.`rating_count`, `shop_product`.`rating_average`, `shop_product`.`title`, `shop_product`.`slug`, `shop_product`.`status`, `shop_product`.`publish_date`, `shop_product`.`expiry_date`, `shop_product`.`description`, `shop_product`.`short_url`, `shop_product`.`site_id`, `shop_product`.`content`, `shop_product`.`unit_price`, `shop_product`.`sale_id`, `shop_product`.`sale_price`, `shop_product`.`sale_from`, `shop_product`.`sale_to`, `shop_product`.`available`, `shop_product`.`master_item_code`, `shop_product`.`actual_item_code`, `shop_product`.`colour`, `shop_product`.`image`, `shop_product`.`date_added`, `shop_product`.`featured`, `shop_product`.`in_stock`, `shop_product`.`ranking` FROM `shop_product` LEFT OUTER JOIN `shop_product_categories` ON (`shop_product`.`id` = `shop_product_categories`.`product_id`) LEFT OUTER JOIN `shop_category` ON (`shop_product_categories`.`category_id` = `shop_category`.`page_ptr_id`) LEFT OUTER JOIN `pages_page` ON (`shop_category`.`page_ptr_id` = `pages_page`.`id`) LEFT OUTER JOIN `shop_productvariation` ON (`shop_product`.`id` = `shop_productvariation`.`product_id`) LEFT OUTER JOIN `shop_product_categories` T7 ON (`shop_product`.`id` = T7.`product_id`) LEFT OUTER JOIN `shop_category` T8 ON (T7.`category_id` = T8.`page_ptr_id`) LEFT OUTER JOIN `pages_page` T9 ON (T8.`page_ptr_id` = T9.`id`) LEFT OUTER JOIN `shop_productvariation` T10 ON (`shop_product`.`id` = T10.`product_id`) WHERE (`shop_product`.`site_id` = 1 AND (`shop_product`.`title` LIKE '%huggie%' OR `shop_product`.`content` LIKE '%huggie%' OR `pages_page`.`title` LIKE '%huggie%' OR `shop_productvariation`.`sku` LIKE '%huggie%' ) AND (`shop_product`.`title` LIKE '%tights%' OR `shop_product`.`content` LIKE '%tights%' OR T9.`title` LIKE '%tights%' OR T10.`sku` LIKE '%tights%' )) ORDER BY `shop_product`.`title` DESC
  20. 396535 someclient someserver:35932 someclient Query 447 Sending data SELECT COUNT(DISTINCT `shop_product`.`id`) FROM `shop_product` LEFT OUTER JOIN `shop_product_categories` ON (`shop_product`.`id` = `shop_product_categories`.`product_id`) LEFT OUTER JOIN `shop_category` ON (`shop_product_categories`.`category_id` = `shop_category`.`page_ptr_id`) LEFT OUTER JOIN `pages_page` ON (`shop_category`.`page_ptr_id` = `pages_page`.`id`) LEFT OUTER JOIN `shop_productvariation` ON (`shop_product`.`id` = `shop_productvariation`.`product_id`) LEFT OUTER JOIN `shop_product_categories` T7 ON (`shop_product`.`id` = T7.`product_id`) LEFT OUTER JOIN `shop_category` T8 ON (T7.`category_id` = T8.`page_ptr_id`) LEFT OUTER JOIN `pages_page` T9 ON (T8.`page_ptr_id` = T9.`id`) LEFT OUTER JOIN `shop_productvariation` T10 ON (`shop_product`.`id` = T10.`product_id`) LEFT OUTER JOIN `shop_product_categories` T11 ON (`shop_product`.`id` = T11.`product_id`) LEFT OUTER JOIN `shop_category` T12 ON (T11.`category_id` = T12.`page_ptr_id`) LEFT OUTER JOIN `pages_page` T13 ON (T12.`page_ptr_id` = T13.`id`) LEFT OUTER JOIN `shop_productvariation` T14 ON (`shop_product`.`id` = T14.`product_id`) LEFT OUTER JOIN `shop_product_categories` T15 ON (`shop_product`.`id` = T15.`product_id`) LEFT OUTER JOIN `shop_category` T16 ON (T15.`category_id` = T16.`page_ptr_id`) LEFT OUTER JOIN `pages_page` T17 ON (T16.`page_ptr_id` = T17.`id`) LEFT OUTER JOIN `shop_productvariation` T18 ON (`shop_product`.`id` = T18.`product_id`) WHERE (`shop_product`.`site_id` = 1 AND (`shop_product`.`title` LIKE '%on%' OR `shop_product`.`content` LIKE '%on%' OR `pages_page`.`title` LIKE '%on%' OR `shop_productvariation`.`sku` LIKE '%on%' ) AND (`shop_product`.`title` LIKE '%a%' OR `shop_product`.`content` LIKE '%a%' OR T9.`title` LIKE '%a%' OR T10.`sku` LIKE '%a%' ) AND (`shop_product`.`title` LIKE '%roll%' OR `shop_product`.`content` LIKE '%roll%' OR T13.`title` LIKE '%roll%' OR T14.`sku` LIKE '%roll%' ) AND (`shop_product`.`title` LIKE '%tape%' OR `shop_product`.`content` LIKE '%tape%' OR T17.`title` LIKE '%tape%' OR T18.`sku` LIKE '%tape%' ))
  21. 396539 someclient yetsomeotherserver:40989 someclient Query 357 Locked SELECT DISTINCT `shop_productvariation`.`option1`, `shop_productvariation`.`default` FROM `shop_productvariation` WHERE (`shop_productvariation`.`product_id` IN (18486, 18485, 18484, 18493, 18479, 18476, 18477, 18489, 18491, 18496, 18495, 18494, 18488, 18492, 18487, 18490, 18481, 18475, 18480, 18478, 18345, 18346, 18342, 18343, 18344, 18347, 18348, 18349, 16624, 15812, 15808, 15926, 15925, 15520, 6122, 6120, 15521, 16625, 16626, 16331, 16303, 15813, 16330, 13609, 14922, 15942, 15938, 15939, 15924, 15946, 15941, 15931, 15540, 15932, 16319, 15933, 15525, 15940, 15923, 15943, 15945, 15948, 15929, 15928, 15920, 16307, 16306, 15934, 15956, 15732, 15731, 15730, 16305, 15955, 16314, 16308, 16315, 16313, 16312, 11666, 16152, 16322, 11665, 15927, 16304, 16310, 16317, 16327, 16320, 16316, 15895, 15896, 15519, 15538, 15522, 15531, 15527, 15532, 15533, 15528, 6038, 14918, 14913, 14923, 14924, 14946, 14950, 14952, 14925, 14926, 14929, 14930, 14957, 14959, 14741, 14735, 13675, 13676, 13536, 14912, 13556, 13557, 11686, 11687, 11688, 11683, 12182, 12710, 12740, 12741, 12771, 12773, 12774, 12775, 12783, 12785, 13103, 12781, 13092, 13093, 13094, 11695, 13108, 13109, 13110, 13111, 13122, 13123, 12199, 12200, 13104, 13125, 13128, 9868, 9869, 9872, 10677, 9834, 9835, 10923, 7350, 6114, 6054, 6052, 6113, 6112, 6106, 6029, 6005, 6004, 6003, 6009, 6021, 6019, 6015, 6045, 6025, 6046, 6028, 6027, 6026, 12757, 12758) AND `shop_productvariation`.`num_in_stock` > 0 ) ORDER BY `shop_productvariation`.`default` DESC
  22. 396550 someclient bne3-0487d.server-web.com:50298 someclient Query 357 Locked SELECT DISTINCT `shop_productvariation`.`option1`, `shop_productvariation`.`default` FROM `shop_productvariation` WHERE (`shop_productvariation`.`product_id` IN (18486, 18485, 18484, 18493, 18479, 18476, 18477, 18489, 18491, 18496, 18495, 18494, 18488, 18492, 18487, 18490, 18481, 18475, 18480, 18478, 18345, 18346, 18342, 18343, 18344, 18347, 18348, 18349, 16624, 15812, 15808, 15926, 15925, 15520, 6122, 6120, 15521, 16625, 16626, 16331, 16303, 15813, 16330, 13609, 14922, 15942, 15938, 15939, 15924, 15946, 15941, 15931, 15540, 15932, 16319, 15933, 15525, 15940, 15923, 15943, 15945, 15948, 15929, 15928, 15920, 16307, 16306, 15934, 15956, 15732, 15731, 15730, 16305, 15955, 16314, 16308, 16315, 16313, 16312, 11666, 16152, 16322, 11665, 15927, 16304, 16310, 16317, 16327, 16320, 16316, 15895, 15896, 15519, 15538, 15522, 15531, 15527, 15532, 15533, 15528, 6038, 14918, 14913, 14923, 14924, 14946, 14950, 14952, 14925, 14926, 14929, 14930, 14957, 14959, 14741, 14735, 13675, 13676, 13536, 14912, 13556, 13557, 11686, 11687, 11688, 11683, 12182, 12710, 12740, 12741, 12771, 12773, 12774, 12775, 12783, 12785, 13103, 12781, 13092, 13093, 13094, 11695, 13108, 13109, 13110, 13111, 13122, 13123, 12199, 12200, 13104, 13125, 13128, 9868, 9869, 9872, 10677, 9834, 9835, 10923, 7350, 6114, 6054, 6052, 6113, 6112, 6106, 6029, 6005, 6004, 6003, 6009, 6021, 6019, 6015, 6045, 6025, 6046, 6028, 6027, 6026, 12757, 12758) AND `shop_productvariation`.`num_in_stock` > 0 ) ORDER BY `shop_productvariation`.`default` DESC
  23. 396561 someclient bne3-0487d.server-web.com:50311 someclient Query 359 Locked SELECT DISTINCT `shop_productvariation`.`option1`, `shop_productvariation`.`default` FROM `shop_productvariation` WHERE (`shop_productvariation`.`product_id` IN (18480, 18481, 16624, 16626, 16625, 16319, 15927, 16304, 16320, 14929, 14930, 11683, 13103, 12781, 6054, 6052, 6005, 6004, 6003, 6021, 6019) AND `shop_productvariation`.`num_in_stock` > 0 ) ORDER BY `shop_productvariation`.`default` DESC
  24. 396568 someclient someserver:35988 someclient Query 135 Locked SELECT COUNT(DISTINCT `shop_product`.`id`) FROM `shop_product` LEFT OUTER JOIN `shop_product_categories` ON (`shop_product`.`id` = `shop_product_categories`.`product_id`) LEFT OUTER JOIN `shop_category` ON (`shop_product_categories`.`category_id` = `shop_category`.`page_ptr_id`) LEFT OUTER JOIN `pages_page` ON (`shop_category`.`page_ptr_id` = `pages_page`.`id`) LEFT OUTER JOIN `shop_productvariation` ON (`shop_product`.`id` = `shop_productvariation`.`product_id`) LEFT OUTER JOIN `shop_product_categories` T7 ON (`shop_product`.`id` = T7.`product_id`) LEFT OUTER JOIN `shop_category` T8 ON (T7.`category_id` = T8.`page_ptr_id`) LEFT OUTER JOIN `pages_page` T9 ON (T8.`page_ptr_id` = T9.`id`) LEFT OUTER JOIN `shop_productvariation` T10 ON (`shop_product`.`id` = T10.`product_id`) WHERE (`shop_product`.`site_id` = 1 AND (`shop_product`.`title` LIKE '%huggie%' OR `shop_product`.`content` LIKE '%huggie%' OR `pages_page`.`title` LIKE '%huggie%' OR `shop_productvariation`.`sku` LIKE '%huggie%' ) AND (`shop_product`.`title` LIKE '%tights%' OR `shop_product`.`content` LIKE '%tights%' OR T9.`title` LIKE '%tights%' OR T10.`sku` LIKE '%tights%' ))
  25. 396569 someclient someotherserver:47484 someclient Query 359 Locked SELECT `shop_productvariation`.`option1`, `shop_productvariation`.`option2` FROM `shop_productvariation` WHERE (`shop_productvariation`.`product_id` = 13458 AND `shop_productvariation`.`unit_price` IS NOT NULL) ORDER BY `shop_productvariation`.`default` DESC
  26. 396570 someclient someotherserver:47485 someclient Query 359 Locked SELECT `shop_productvariation`.`option1`, `shop_productvariation`.`option2` FROM `shop_productvariation` WHERE (`shop_productvariation`.`product_id` = 15216 AND `shop_productvariation`.`unit_price` IS NOT NULL) ORDER BY `shop_productvariation`.`default` DESC
  27. 396571 someclient someserver:35991 someclient Sleep 399 NULL
  28. 396577 someclient someotherserver:47497 someclient Query 357 Locked SELECT DISTINCT `shop_productvariation`.`option1`, `shop_productvariation`.`default` FROM `shop_productvariation` WHERE (`shop_productvariation`.`product_id` IN (18486, 18485, 18484, 18493, 18479, 18476, 18477, 18489, 18491, 18496, 18495, 18494, 18488, 18492, 18487, 18490, 18481, 18475, 18480, 18478, 18345, 18346, 18342, 18343, 18344, 18347, 18348, 18349, 16624, 15812, 15808, 15926, 15925, 15520, 6122, 6120, 15521, 16625, 16626, 16331, 16303, 15813, 16330, 13609, 14922, 15942, 15938, 15939, 15924, 15946, 15941, 15931, 15540, 15932, 16319, 15933, 15525, 15940, 15923, 15943, 15945, 15948, 15929, 15928, 15920, 16307, 16306, 15934, 15956, 15732, 15731, 15730, 16305, 15955, 16314, 16308, 16315, 16313, 16312, 11666, 16152, 16322, 11665, 15927, 16304, 16310, 16317, 16327, 16320, 16316, 15895, 15896, 15519, 15538, 15522, 15531, 15527, 15532, 15533, 15528, 6038, 14918, 14913, 14923, 14924, 14946, 14950, 14952, 14925, 14926, 14929, 14930, 14957, 14959, 14741, 14735, 13675, 13676, 13536, 14912, 13556, 13557, 11686, 11687, 11688, 11683, 12182, 12710, 12740, 12741, 12771, 12773, 12774, 12775, 12783, 12785, 13103, 12781, 13092, 13093, 13094, 11695, 13108, 13109, 13110, 13111, 13122, 13123, 12199, 12200, 13104, 13125, 13128, 9868, 9869, 9872, 10677, 9834, 9835, 10923, 7350, 6114, 6054, 6052, 6113, 6112, 6106, 6029, 6005, 6004, 6003, 6009, 6021, 6019, 6015, 6045, 6025, 6046, 6028, 6027, 6026, 12757, 12758) AND `shop_productvariation`.`num_in_stock` > 0 ) ORDER BY `shop_productvariation`.`default` DESC
  29. 396593 someclient yetsomeotherserver:41086 someclient Query 357 Locked SELECT DISTINCT `shop_productvariation`.`option1`, `shop_productvariation`.`default` FROM `shop_productvariation` WHERE (`shop_productvariation`.`product_id` IN (18478, 18345, 18346, 18342, 18343, 18344, 18347, 18348, 18349, 15956, 16314, 15948, 16306, 16308, 15920, 15731, 15732, 15730, 15955, 16307, 11666, 16152, 16322, 11665, 16327, 15919, 6038, 14923, 14924, 14925, 14926, 14741, 14735, 14912, 13556, 13557, 11695, 12199, 12200, 13128, 10923, 6046, 6028, 6027, 6045, 6025) AND `shop_productvariation`.`num_in_stock` > 0 ) ORDER BY `shop_productvariation`.`default` DESC
  30. 396597 someclient yetsomeotherserver:41098 someclient Query 360 Locked SELECT DISTINCT `shop_productvariation`.`option1`, `shop_productvariation`.`default` FROM `shop_productvariation` WHERE (`shop_productvariation`.`product_id` IN (18486, 18485, 18484, 18493, 18479, 18476, 18477, 18489, 18491, 18496, 18495, 18494, 18488, 18492, 18487, 18490, 18481, 18475, 18480, 18478, 18345, 18346, 18342, 18343, 18344, 18347, 18348, 18349, 16624, 15812, 15808, 15926, 15925, 15520, 6122, 6120, 15521, 16625, 16626, 16331, 16303, 15813, 16330, 13609, 14922, 15942, 15938, 15939, 15924, 15946, 15941, 15931, 15540, 15932, 16319, 15933, 15525, 15940, 15923, 15943, 15945, 15948, 15929, 15928, 15920, 16307, 16306, 15934, 15956, 15732, 15731, 15730, 16305, 15955, 16314, 16308, 16315, 16313, 16312, 11666, 16152, 16322, 11665, 15927, 16304, 16310, 16317, 16327, 16320, 16316, 15895, 15896, 15519, 15538, 15522, 15531, 15527, 15532, 15533, 15528, 6038, 14918, 14913, 14923, 14924, 14946, 14950, 14952, 14925, 14926, 14929, 14930, 14957, 14959, 14741, 14735, 13675, 13676, 13536, 14912, 13556, 13557, 11686, 11687, 11688, 11683, 12182, 12710, 12740, 12741, 12771, 12773, 12774, 12775, 12783, 12785, 13103, 12781, 13092, 13093, 13094, 11695, 13108, 13109, 13110, 13111, 13122, 13123, 12199, 12200, 13104, 13125, 13128, 9868, 9869, 9872, 10677, 9834, 9835, 10923, 7350, 6114, 6054, 6052, 6113, 6112, 6106, 6029, 6005, 6004, 6003, 6009, 6021, 6019, 6015, 6045, 6025, 6046, 6028, 6027, 6026, 12757, 12758) AND `shop_productvariation`.`num_in_stock` > 0 ) ORDER BY `shop_productvariation`.`default` DESC
  31. 396600 someclient yetsomeotherserver:41110 someclient Query 358 Locked SELECT DISTINCT `shop_productvariation`.`option1`, `shop_productvariation`.`default` FROM `shop_productvariation` WHERE (`shop_productvariation`.`product_id` IN (18478, 18345, 18346, 18342, 18343, 18344, 18347, 18348, 18349, 15956, 16314, 15948, 16306, 16308, 15920, 15731, 15732, 15730, 15955, 16307, 11666, 16152, 16322, 11665, 16327, 15919, 6038, 14923, 14924, 14925, 14926, 14741, 14735, 14912, 13556, 13557, 11695, 12199, 12200, 13128, 10923, 6046, 6028, 6027, 6045, 6025) AND `shop_productvariation`.`num_in_stock` > 0 ) ORDER BY `shop_productvariation`.`default` DESC
  32. 396611 someclient bne3-0487d.server-web.com:50402 someclient Query 351 Locked SELECT DISTINCT `shop_productvariation`.`option1`, `shop_productvariation`.`default` FROM `shop_productvariation` WHERE (`shop_productvariation`.`product_id` IN (15924, 15933, 15923, 15932, 15931, 15934, 15895) AND `shop_productvariation`.`num_in_stock` > 0 ) ORDER BY `shop_productvariation`.`default` DESC
  33. 396614 someclient bne3-0487d.server-web.com:50408 someclient Query 348 Locked SELECT DISTINCT `shop_productvariation`.`option1`, `shop_productvariation`.`default` FROM `shop_productvariation` WHERE (`shop_productvariation`.`product_id` IN (18486, 18485, 18484, 18493, 18479, 18476, 18477, 18489, 18491, 18496, 18495, 18494, 18488, 18492, 18487, 18490, 18481, 18475, 18480, 18478, 18345, 18346, 18342, 18343, 18344, 18347, 18348, 18349, 16624, 15812, 15808, 15926, 15925, 15520, 6122, 6120, 15521, 16625, 16626, 16331, 16303, 15813, 16330, 13609, 14922, 15942, 15938, 15939, 15924, 15946, 15941, 15931, 15540, 15932, 16319, 15933, 15525, 15940, 15923, 15943, 15945, 15948, 15929, 15928, 15920, 16307, 16306, 15934, 15956, 15732, 15731, 15730, 16305, 15955, 16314, 16308, 16315, 16313, 16312, 11666, 16152, 16322, 11665, 15927, 16304, 16310, 16317, 16327, 16320, 16316, 15895, 15896, 15519, 15538, 15522, 15531, 15527, 15532, 15533, 15528, 6038, 14918, 14913, 14923, 14924, 14946, 14950, 14952, 14925, 14926, 14929, 14930, 14957, 14959, 14741, 14735, 13675, 13676, 13536, 14912, 13556, 13557, 11686, 11687, 11688, 11683, 12182, 12710, 12740, 12741, 12771, 12773, 12774, 12775, 12783, 12785, 13103, 12781, 13092, 13093, 13094, 11695, 13108, 13109, 13110, 13111, 13122, 13123, 12199, 12200, 13104, 13125, 13128, 9868, 9869, 9872, 10677, 9834, 9835, 10923, 7350, 6114, 6054, 6052, 6113, 6112, 6106, 6029, 6005, 6004, 6003, 6009, 6021, 6019, 6015, 6045, 6025, 6046, 6028, 6027, 6026, 12757, 12758) AND `shop_productvariation`.`num_in_stock` > 0 ) ORDER BY `shop_productvariation`.`default` DESC
  34. 396617 someclient yetsomeotherserver:41190 someclient Query 347 Locked SELECT DISTINCT `shop_productvariation`.`option1`, `shop_productvariation`.`default` FROM `shop_productvariation` WHERE (`shop_productvariation`.`product_id` IN (18490, 18484, 18492, 18493, 18479, 18477, 18476, 18485, 18489, 18491, 18496, 18495, 18494, 18486, 18487, 18488, 15812, 15808, 15925, 15926, 15520, 6120, 16331, 16303, 15813, 15521, 16330, 6122, 13609, 14922, 15939, 15941, 15942, 15525, 15938, 15945, 15943, 15946, 15940, 15540, 15896, 15522, 15519, 15531, 15538, 14918, 13675, 13676, 13536, 11687, 11686, 11688, 12182, 12710, 12740, 12741, 12771, 12773, 12774, 12775, 12783, 12785, 13092, 13093, 13094, 9868, 9869, 9872, 10677, 9834, 9835, 7350, 6113, 6112, 6114, 6009, 6106, 6029) AND `shop_productvariation`.`num_in_stock` > 0 ) ORDER BY `shop_productvariation`.`default` DESC
  35. 396622 someclient someotherserver:47559 someclient Query 336 Locked SELECT DISTINCT `shop_productvariation`.`option1`, `shop_productvariation`.`default` FROM `shop_productvariation` WHERE (`shop_productvariation`.`product_id` IN (18486, 18485, 18484, 18493, 18479, 18476, 18477, 18489, 18491, 18496, 18495, 18494, 18488, 18492, 18487, 18490, 18481, 18475, 18480, 18478, 18345, 18346, 18342, 18343, 18344, 18347, 18348, 18349, 16624, 15812, 15808, 15926, 15925, 15520, 6122, 6120, 15521, 16625, 16626, 16331, 16303, 15813, 16330, 13609, 14922, 15942, 15938, 15939, 15924, 15946, 15941, 15931, 15540, 15932, 16319, 15933, 15525, 15940, 15923, 15943, 15945, 15948, 15929, 15928, 15920, 16307, 16306, 15934, 15956, 15732, 15731, 15730, 16305, 15955, 16314, 16308, 16315, 16313, 16312, 11666, 16152, 16322, 11665, 15927, 16304, 16310, 16317, 16327, 16320, 16316, 15895, 15896, 15519, 15538, 15522, 15531, 15527, 15532, 15533, 15528, 6038, 14918, 14913, 14923, 14924, 14946, 14950, 14952, 14925, 14926, 14929, 14930, 14957, 14959, 14741, 14735, 13675, 13676, 13536, 14912, 13556, 13557, 11686, 11687, 11688, 11683, 12182, 12710, 12740, 12741, 12771, 12773, 12774, 12775, 12783, 12785, 13103, 12781, 13092, 13093, 13094, 11695, 13108, 13109, 13110, 13111, 13122, 13123, 12199, 12200, 13104, 13125, 13128, 9868, 9869, 9872, 10677, 9834, 9835, 10923, 7350, 6114, 6054, 6052, 6113, 6112, 6106, 6029, 6005, 6004, 6003, 6009, 6021, 6019, 6015, 6045, 6025, 6046, 6028, 6027, 6026, 12757, 12758) AND `shop_productvariation`.`num_in_stock` > 0 ) ORDER BY `shop_productvariation`.`default` DESC
  36. 396631 someclient someotherserver:47568 someclient Query 334 Locked SELECT DISTINCT `shop_productvariation`.`option1`, `shop_productvariation`.`default` FROM `shop_productvariation` WHERE (`shop_productvariation`.`product_id` IN (18475, 15929, 16305, 15928, 16315, 16312, 16317, 16310, 16313, 16316, 15527, 15532, 15533, 15528, 14913, 14946, 14950, 14952, 14957, 14959, 13108, 13109, 13110, 13111, 13122, 13123, 13104, 13125, 6015, 6026, 12757, 12758) AND `shop_productvariation`.`num_in_stock` > 0 ) ORDER BY `shop_productvariation`.`default` DESC
  37. 396632 someclient someserver:36046 someclient Query 30 Locked SELECT COUNT(DISTINCT `shop_product`.`id`) FROM `shop_product` LEFT OUTER JOIN `shop_product_categories` ON (`shop_product`.`id` = `shop_product_categories`.`product_id`) LEFT OUTER JOIN `shop_category` ON (`shop_product_categories`.`category_id` = `shop_category`.`page_ptr_id`) LEFT OUTER JOIN `pages_page` ON (`shop_category`.`page_ptr_id` = `pages_page`.`id`) LEFT OUTER JOIN `shop_productvariation` ON (`shop_product`.`id` = `shop_productvariation`.`product_id`) LEFT OUTER JOIN `shop_product_categories` T7 ON (`shop_product`.`id` = T7.`product_id`) LEFT OUTER JOIN `shop_category` T8 ON (T7.`category_id` = T8.`page_ptr_id`) LEFT OUTER JOIN `pages_page` T9 ON (T8.`page_ptr_id` = T9.`id`) LEFT OUTER JOIN `shop_productvariation` T10 ON (`shop_product`.`id` = T10.`product_id`) WHERE (`shop_product`.`site_id` = 1 AND (`shop_product`.`title` LIKE '%huggie%' OR `shop_product`.`content` LIKE '%huggie%' OR `pages_page`.`title` LIKE '%huggie%' OR `shop_productvariation`.`sku` LIKE '%huggie%' ) AND (`shop_product`.`title` LIKE '%tights%' OR `shop_product`.`content` LIKE '%tights%' OR T9.`title` LIKE '%tights%' OR T10.`sku` LIKE '%tights%' ))
  38. 396633 someclient someserver:36051 someclient Query 260 Locked SELECT COUNT(DISTINCT `shop_product`.`id`) FROM `shop_product` LEFT OUTER JOIN `shop_product_categories` ON (`shop_product`.`id` = `shop_product_categories`.`product_id`) LEFT OUTER JOIN `shop_category` ON (`shop_product_categories`.`category_id` = `shop_category`.`page_ptr_id`) LEFT OUTER JOIN `pages_page` ON (`shop_category`.`page_ptr_id` = `pages_page`.`id`) LEFT OUTER JOIN `shop_productvariation` ON (`shop_product`.`id` = `shop_productvariation`.`product_id`) LEFT OUTER JOIN `shop_product_categories` T7 ON (`shop_product`.`id` = T7.`product_id`) LEFT OUTER JOIN `shop_category` T8 ON (T7.`category_id` = T8.`page_ptr_id`) LEFT OUTER JOIN `pages_page` T9 ON (T8.`page_ptr_id` = T9.`id`) LEFT OUTER JOIN `shop_productvariation` T10 ON (`shop_product`.`id` = T10.`product_id`) LEFT OUTER JOIN `shop_product_categories` T11 ON (`shop_product`.`id` = T11.`product_id`) LEFT OUTER JOIN `shop_category` T12 ON (T11.`category_id` = T12.`page_ptr_id`) LEFT OUTER JOIN `pages_page` T13 ON (T12.`page_ptr_id` = T13.`id`) LEFT OUTER JOIN `shop_productvariation` T14 ON (`shop_product`.`id` = T14.`product_id`) LEFT OUTER JOIN `shop_product_categories` T15 ON (`shop_product`.`id` = T15.`product_id`) LEFT OUTER JOIN `shop_category` T16 ON (T15.`category_id` = T16.`page_ptr_id`) LEFT OUTER JOIN `pages_page` T17 ON (T16.`page_ptr_id` = T17.`id`) LEFT OUTER JOIN `shop_productvariation` T18 ON (`shop_product`.`id` = T18.`product_id`) WHERE (`shop_product`.`site_id` = 1 AND (`shop_product`.`title` LIKE '%on%' OR `shop_product`.`content` LIKE '%on%' OR `pages_page`.`title` LIKE '%on%' OR `shop_productvariation`.`sku` LIKE '%on%' ) AND (`shop_product`.`title` LIKE '%a%' OR `shop_product`.`content` LIKE '%a%' OR T9.`title` LIKE '%a%' OR T10.`sku` LIKE '%a%' ) AND (`shop_product`.`title` LIKE '%roll%' OR `shop_product`.`content` LIKE '%roll%' OR T13.`title` LIKE '%roll%' OR T14.`sku` LIKE '%roll%' ) AND (`shop_product`.`title` LIKE '%tape%' OR `shop_product`.`content` LIKE '%tape%' OR T17.`title` LIKE '%tape%' OR T18.`sku` LIKE '%tape%' ))
  39. 396634 someclient someserver:36054 someclient Query 262 Locked SELECT COUNT(DISTINCT `shop_product`.`id`) FROM `shop_product` LEFT OUTER JOIN `shop_product_categories` ON (`shop_product`.`id` = `shop_product_categories`.`product_id`) LEFT OUTER JOIN `shop_category` ON (`shop_product_categories`.`category_id` = `shop_category`.`page_ptr_id`) LEFT OUTER JOIN `pages_page` ON (`shop_category`.`page_ptr_id` = `pages_page`.`id`) LEFT OUTER JOIN `shop_productvariation` ON (`shop_product`.`id` = `shop_productvariation`.`product_id`) LEFT OUTER JOIN `shop_product_categories` T7 ON (`shop_product`.`id` = T7.`product_id`) LEFT OUTER JOIN `shop_category` T8 ON (T7.`category_id` = T8.`page_ptr_id`) LEFT OUTER JOIN `pages_page` T9 ON (T8.`page_ptr_id` = T9.`id`) LEFT OUTER JOIN `shop_productvariation` T10 ON (`shop_product`.`id` = T10.`product_id`) WHERE (`shop_product`.`site_id` = 1 AND (`shop_product`.`title` LIKE '%huggie%' OR `shop_product`.`content` LIKE '%huggie%' OR `pages_page`.`title` LIKE '%huggie%' OR `shop_productvariation`.`sku` LIKE '%huggie%' ) AND (`shop_product`.`title` LIKE '%tights%' OR `shop_product`.`content` LIKE '%tights%' OR T9.`title` LIKE '%tights%' OR T10.`sku` LIKE '%tights%' ))
  40. 396656 someclient someserver:36086 someclient Sleep 288 NULL
  41. 396658 someclient bne3-0487d.server-web.com:50482 someclient Query 287 Locked SELECT DISTINCT `shop_productvariation`.`option1`, `shop_productvariation`.`default` FROM `shop_productvariation` WHERE (`shop_productvariation`.`product_id` IN (17337, 17317, 17316, 17319, 17318, 17314, 17313, 17342, 16910, 16837, 16836, 16838, 16702, 16698, 16699, 16769, 16771, 16700, 16701, 16686, 16687, 16512, 16046, 16510, 16509, 7316, 12892, 12889, 12890, 12891, 16289, 16288, 16287, 16286, 12942, 12935, 12936, 12937, 12938, 16048, 16047, 15659, 15658, 15660, 15688, 15662, 15661, 15686, 15687, 15672, 15678, 15677, 15209, 15019, 15003, 15034, 15035, 14636, 14634, 11632) AND `shop_productvariation`.`num_in_stock` > 0 ) ORDER BY `shop_productvariation`.`default` DESC
  42. 396666 someclient yetsomeotherserver:41298 someclient Query 283 Locked SELECT DISTINCT `shop_productvariation`.`option1`, `shop_productvariation`.`default` FROM `shop_productvariation` WHERE (`shop_productvariation`.`product_id` IN (6133, 6134, 6124, 17492, 16563, 16562, 16474, 16472, 16473, 16464, 16239, 16238, 14669, 12236, 13167, 18497, 18516, 18514, 18513, 18515, 18512, 18511, 18504, 18525, 18366, 18367, 18365, 6123, 17028, 17027, 17042, 17040, 17033, 16953, 16950, 17029, 16954, 17044, 16469, 16477, 16476, 16161, 16162, 15959, 15961, 15958, 15962, 15305, 15306, 15303, 15304, 15078, 15079, 15080, 14977, 14670, 14674, 14673, 14275, 13999, 13158, 13159, 13160, 12823, 12841, 10259, 10260, 10263, 8312, 8314, 6586, 6548, 6549, 6173, 6178, 6576, 6580) AND `shop_productvariation`.`num_in_stock` > 0 ) ORDER BY `shop_productvariation`.`default` DESC
  43. 396681 someclient someotherserver:47650 someclient Query 278 Locked SELECT DISTINCT `shop_productvariation`.`option1`, `shop_productvariation`.`default` FROM `shop_productvariation` WHERE (`shop_productvariation`.`product_id` IN (18490, 18484, 18492, 18493, 18479, 18477, 18476, 18485, 18489, 18491, 18496, 18495, 18494, 18486, 18487, 18488, 15812, 15808, 15925, 15926, 15520, 6120, 16331, 16303, 15813, 15521, 16330, 6122, 13609, 14922, 15939, 15941, 15942, 15525, 15938, 15945, 15943, 15946, 15940, 15540, 15896, 15522, 15519, 15531, 15538, 14918, 13675, 13676, 13536, 11687, 11686, 11688, 12182, 12710, 12740, 12741, 12771, 12773, 12774, 12775, 12783, 12785, 13092, 13093, 13094, 9868, 9869, 9872, 10677, 9834, 9835, 7350, 6113, 6112, 6114, 6009, 6106, 6029) AND `shop_productvariation`.`num_in_stock` > 0 ) ORDER BY `shop_productvariation`.`default` DESC
  44. 396686 someclient bne3-0487d.server-web.com:50524 someclient Query 276 Locked SELECT DISTINCT `shop_productvariation`.`option1`, `shop_productvariation`.`default` FROM `shop_productvariation` WHERE (`shop_productvariation`.`product_id` IN (16979, 16974, 16752, 16577, 16572, 16574, 16573, 16571, 16649, 16647, 16646, 16648, 16462, 15430, 15429, 11072, 6157, 6158, 6159, 6160, 6161, 6162, 18536, 18535, 18384, 16967, 16978, 16977, 16663, 16740, 16800, 16744, 16799, 16798, 16797, 16793, 16655, 16580, 16015, 16556, 16555, 16554, 16664, 16557, 16016, 16654, 16653, 16478, 16810, 16808, 16247, 15268, 15106, 15107, 14435, 14206, 14291, 14293, 13805, 13599, 12338, 13190, 13191, 12850, 12851, 13186, 13187, 13188, 13189, 11050, 11051, 8108, 6522, 6372, 6376, 6397, 6398, 6311, 6526, 6525) AND `shop_productvariation`.`num_in_stock` > 0 ) ORDER BY `shop_productvariation`.`default` DESC
  45. 396690 someclient yetsomeotherserver:41315 someclient Query 218 Locked SELECT DISTINCT `shop_productvariation`.`option1`, `shop_productvariation`.`default` FROM `shop_productvariation` WHERE (`shop_productvariation`.`product_id` IN (18486, 18485, 18484, 18493, 18479, 18476, 18477, 18489, 18491, 18496, 18495, 18494, 18488, 18492, 18487, 18490, 18481, 18475, 18480, 18478, 18345, 18346, 18342, 18343, 18344, 18347, 18348, 18349, 16624, 15812, 15808, 15926, 15925, 15520, 6122, 6120, 15521, 16625, 16626, 16331, 16303, 15813, 16330, 13609, 14922, 15942, 15938, 15939, 15924, 15946, 15941, 15931, 15540, 15932, 16319, 15933, 15525, 15940, 15923, 15943, 15945, 15948, 15929, 15928, 15920, 16307, 16306, 15934, 15956, 15732, 15731, 15730, 16305, 15955, 16314, 16308, 16315, 16313, 16312, 11666, 16152, 16322, 11665, 15927, 16304, 16310, 16317, 16327, 16320, 16316, 15895, 15896, 15519, 15538, 15522, 15531, 15527, 15532, 15533, 15528, 6038, 14918, 14913, 14923, 14924, 14946, 14950, 14952, 14925, 14926, 14929, 14930, 14957, 14959, 14741, 14735, 13675, 13676, 13536, 14912, 13556, 13557, 11686, 11687, 11688, 11683, 12182, 12710, 12740, 12741, 12771, 12773, 12774, 12775, 12783, 12785, 13103, 12781, 13092, 13093, 13094, 11695, 13108, 13109, 13110, 13111, 13122, 13123, 12199, 12200, 13104, 13125, 13128, 9868, 9869, 9872, 10677, 9834, 9835, 10923, 7350, 6114, 6054, 6052, 6113, 6112, 6106, 6029, 6005, 6004, 6003, 6009, 6021, 6019, 6015, 6045, 6025, 6046, 6028, 6027, 6026, 12757, 12758) AND `shop_productvariation`.`num_in_stock` > 0 ) ORDER BY `shop_productvariation`.`default` DESC
  46. 396695 someclient bne3-0487d.server-web.com:50531 someclient Query 264 Locked SELECT DISTINCT `shop_productvariation`.`option1`, `shop_productvariation`.`default` FROM `shop_productvariation` WHERE (`shop_productvariation`.`product_id` IN (16979, 16974, 16752, 16577, 16572, 16574, 16573, 16571, 16649, 16647, 16646, 16648, 16462, 15430, 15429, 11072, 6157, 6158, 6159, 6160, 6161, 6162, 18536, 18535, 18384, 16967, 16978, 16977, 16663, 16740, 16800, 16744, 16799, 16798, 16797, 16793, 16655, 16580, 16015, 16556, 16555, 16554, 16664, 16557, 16016, 16654, 16653, 16478, 16810, 16808, 16247, 15268, 15106, 15107, 14435, 14206, 14291, 14293, 13805, 13599, 12338, 13190, 13191, 12850, 12851, 13186, 13187, 13188, 13189, 11050, 11051, 8108, 6522, 6372, 6376, 6397, 6398, 6311, 6526, 6525) AND `shop_productvariation`.`num_in_stock` > 0 ) ORDER BY `shop_productvariation`.`default` DESC
  47. 396701 someclient yetsomeotherserver:41355 someclient Query 246 Locked SELECT DISTINCT `shop_productvariation`.`option1`, `shop_productvariation`.`default` FROM `shop_productvariation` WHERE (`shop_productvariation`.`product_id` IN (18486, 18485, 18484, 18493, 18479, 18476, 18477, 18489, 18491, 18496, 18495, 18494, 18488, 18492, 18487, 18490, 18481, 18475, 18480, 18478, 18345, 18346, 18342, 18343, 18344, 18347, 18348, 18349, 16624, 15812, 15808, 15926, 15925, 15520, 6122, 6120, 15521, 16625, 16626, 16331, 16303, 15813, 16330, 13609, 14922, 15942, 15938, 15939, 15924, 15946, 15941, 15931, 15540, 15932, 16319, 15933, 15525, 15940, 15923, 15943, 15945, 15948, 15929, 15928, 15920, 16307, 16306, 15934, 15956, 15732, 15731, 15730, 16305, 15955, 16314, 16308, 16315, 16313, 16312, 11666, 16152, 16322, 11665, 15927, 16304, 16310, 16317, 16327, 16320, 16316, 15895, 15896, 15519, 15538, 15522, 15531, 15527, 15532, 15533, 15528, 6038, 14918, 14913, 14923, 14924, 14946, 14950, 14952, 14925, 14926, 14929, 14930, 14957, 14959, 14741, 14735, 13675, 13676, 13536, 14912, 13556, 13557, 11686, 11687, 11688, 11683, 12182, 12710, 12740, 12741, 12771, 12773, 12774, 12775, 12783, 12785, 13103, 12781, 13092, 13093, 13094, 11695, 13108, 13109, 13110, 13111, 13122, 13123, 12199, 12200, 13104, 13125, 13128, 9868, 9869, 9872, 10677, 9834, 9835, 10923, 7350, 6114, 6054, 6052, 6113, 6112, 6106, 6029, 6005, 6004, 6003, 6009, 6021, 6019, 6015, 6045, 6025, 6046, 6028, 6027, 6026, 12757, 12758) AND `shop_productvariation`.`num_in_stock` > 0 ) ORDER BY `shop_productvariation`.`default` DESC
  48. 396704 someclient someotherserver:47711 someclient Query 246 Locked SELECT `shop_productvariation`.`option1`, `shop_productvariation`.`option2` FROM `shop_productvariation` WHERE (`shop_productvariation`.`product_id` = 9973 AND `shop_productvariation`.`unit_price` IS NOT NULL) ORDER BY `shop_productvariation`.`default` DESC
  49. 396718 someclient someserver:57876 someclient Query 138 Locked SELECT COUNT(DISTINCT `shop_product`.`id`) FROM `shop_product` LEFT OUTER JOIN `shop_product_categories` ON (`shop_product`.`id` = `shop_product_categories`.`product_id`) LEFT OUTER JOIN `shop_category` ON (`shop_product_categories`.`category_id` = `shop_category`.`page_ptr_id`) LEFT OUTER JOIN `pages_page` ON (`shop_category`.`page_ptr_id` = `pages_page`.`id`) LEFT OUTER JOIN `shop_productvariation` ON (`shop_product`.`id` = `shop_productvariation`.`product_id`) LEFT OUTER JOIN `shop_product_categories` T7 ON (`shop_product`.`id` = T7.`product_id`) LEFT OUTER JOIN `shop_category` T8 ON (T7.`category_id` = T8.`page_ptr_id`) LEFT OUTER JOIN `pages_page` T9 ON (T8.`page_ptr_id` = T9.`id`) LEFT OUTER JOIN `shop_productvariation` T10 ON (`shop_product`.`id` = T10.`product_id`) LEFT OUTER JOIN `shop_product_categories` T11 ON (`shop_product`.`id` = T11.`product_id`) LEFT OUTER JOIN `shop_category` T12 ON (T11.`category_id` = T12.`page_ptr_id`) LEFT OUTER JOIN `pages_page` T13 ON (T12.`page_ptr_id` = T13.`id`) LEFT OUTER JOIN `shop_productvariation` T14 ON (`shop_product`.`id` = T14.`product_id`) LEFT OUTER JOIN `shop_product_categories` T15 ON (`shop_product`.`id` = T15.`product_id`) LEFT OUTER JOIN `shop_category` T16 ON (T15.`category_id` = T16.`page_ptr_id`) LEFT OUTER JOIN `pages_page` T17 ON (T16.`page_ptr_id` = T17.`id`) LEFT OUTER JOIN `shop_productvariation` T18 ON (`shop_product`.`id` = T18.`product_id`) WHERE (`shop_product`.`site_id` = 1 AND (`shop_product`.`title` LIKE '%on%' OR `shop_product`.`content` LIKE '%on%' OR `pages_page`.`title` LIKE '%on%' OR `shop_productvariation`.`sku` LIKE '%on%' ) AND (`shop_product`.`title` LIKE '%a%' OR `shop_product`.`content` LIKE '%a%' OR T9.`title` LIKE '%a%' OR T10.`sku` LIKE '%a%' ) AND (`shop_product`.`title` LIKE '%roll%' OR `shop_product`.`content` LIKE '%roll%' OR T13.`title` LIKE '%roll%' OR T14.`sku` LIKE '%roll%' ) AND (`shop_product`.`title` LIKE '%tape%' OR `shop_product`.`content` LIKE '%tape%' OR T17.`title` LIKE '%tape%' OR T18.`sku` LIKE '%tape%' ))
  50. 396722 someclient bne3-0487d.server-web.com:50613 someclient Query 224 Locked SELECT DISTINCT `shop_productvariation`.`option1`, `shop_productvariation`.`default` FROM `shop_productvariation` WHERE (`shop_productvariation`.`product_id` IN (6133, 6134, 6124, 17492, 16563, 16562, 16474, 16472, 16473, 16464, 16239, 16238, 14669, 12236, 13167, 18497, 18516, 18514, 18513, 18515, 18512, 18511, 18504, 18525, 18366, 18367, 18365, 6123, 17028, 17027, 17042, 17040, 17033, 16953, 16950, 17029, 16954, 17044, 16469, 16477, 16476, 16161, 16162, 15959, 15961, 15958, 15962, 15305, 15306, 15303, 15304, 15078, 15079, 15080, 14977, 14670, 14674, 14673, 14275, 13999, 13158, 13159, 13160, 12823, 12841, 10259, 10260, 10263, 8312, 8314, 6586, 6548, 6549, 6173, 6178, 6576, 6580) AND `shop_productvariation`.`num_in_stock` > 0 ) ORDER BY `shop_productvariation`.`default` DESC
  51. 396735 someclient bne3-0487d.server-web.com:50630 someclient Query 216 Locked SELECT DISTINCT `shop_productvariation`.`option1`, `shop_productvariation`.`default` FROM `shop_productvariation` WHERE (`shop_productvariation`.`product_id` IN (17337, 17317, 17316, 17319, 17318, 17314, 17313, 17342, 16910, 16837, 16836, 16838, 16702, 16698, 16699, 16769, 16771, 16700, 16701, 16686, 16687, 16512, 16046, 16510, 16509, 7316, 12892, 12889, 12890, 12891, 16289, 16288, 16287, 16286, 12942, 12935, 12936, 12937, 12938, 16048, 16047, 15659, 15658, 15660, 15688, 15662, 15661, 15686, 15687, 15672, 15678, 15677, 15209, 15019, 15003, 15034, 15035, 14636, 14634, 11632) AND `shop_productvariation`.`num_in_stock` > 0 ) ORDER BY `shop_productvariation`.`default` DESC
  52. 396738 someclient bne3-0487d.server-web.com:50633 someclient Query 214 Locked SELECT DISTINCT `shop_productvariation`.`option1`, `shop_productvariation`.`default` FROM `shop_productvariation` WHERE (`shop_productvariation`.`product_id` IN (18486, 18485, 18484, 18493, 18479, 18476, 18477, 18489, 18491, 18496, 18495, 18494, 18488, 18492, 18487, 18490, 18481, 18475, 18480, 18478, 18345, 18346, 18342, 18343, 18344, 18347, 18348, 18349, 16624, 15812, 15808, 15926, 15925, 15520, 6122, 6120, 15521, 16625, 16626, 16331, 16303, 15813, 16330, 13609, 14922, 15942, 15938, 15939, 15924, 15946, 15941, 15931, 15540, 15932, 16319, 15933, 15525, 15940, 15923, 15943, 15945, 15948, 15929, 15928, 15920, 16307, 16306, 15934, 15956, 15732, 15731, 15730, 16305, 15955, 16314, 16308, 16315, 16313, 16312, 11666, 16152, 16322, 11665, 15927, 16304, 16310, 16317, 16327, 16320, 16316, 15895, 15896, 15519, 15538, 15522, 15531, 15527, 15532, 15533, 15528, 6038, 14918, 14913, 14923, 14924, 14946, 14950, 14952, 14925, 14926, 14929, 14930, 14957, 14959, 14741, 14735, 13675, 13676, 13536, 14912, 13556, 13557, 11686, 11687, 11688, 11683, 12182, 12710, 12740, 12741, 12771, 12773, 12774, 12775, 12783, 12785, 13103, 12781, 13092, 13093, 13094, 11695, 13108, 13109, 13110, 13111, 13122, 13123, 12199, 12200, 13104, 13125, 13128, 9868, 9869, 9872, 10677, 9834, 9835, 10923, 7350, 6114, 6054, 6052, 6113, 6112, 6106, 6029, 6005, 6004, 6003, 6009, 6021, 6019, 6015, 6045, 6025, 6046, 6028, 6027, 6026, 12757, 12758) AND `shop_productvariation`.`num_in_stock` > 0 ) ORDER BY `shop_productvariation`.`default` DESC
  53. 396742 someclient someotherserver:47798 someclient Query 209 Locked SELECT DISTINCT `shop_productvariation`.`option1`, `shop_productvariation`.`default` FROM `shop_productvariation` WHERE (`shop_productvariation`.`product_id` IN (18475, 15929, 16305, 15928, 16315, 16312, 16317, 16310, 16313, 16316, 15527, 15532, 15533, 15528, 14913, 14946, 14950, 14952, 14957, 14959, 13108, 13109, 13110, 13111, 13122, 13123, 13104, 13125, 6015, 6026, 12757, 12758) AND `shop_productvariation`.`num_in_stock` > 0 ) ORDER BY `shop_productvariation`.`default` DESC
  54. 396746 someclient bne3-0487d.server-web.com:50668 someclient Query 192 Locked SELECT `shop_productvariation`.`option1`, `shop_productvariation`.`option2` FROM `shop_productvariation` WHERE (`shop_productvariation`.`product_id` = 5584 AND `shop_productvariation`.`unit_price` IS NOT NULL) ORDER BY `shop_productvariation`.`default` DESC
  55. 396757 someclient bne3-0487d.server-web.com:50698 someclient Query 184 Locked SELECT DISTINCT `shop_productvariation`.`option1`, `shop_productvariation`.`default` FROM `shop_productvariation` WHERE (`shop_productvariation`.`product_id` IN (18292, 18293, 18295, 18296, 18297, 18294, 18336, 18303, 18328, 18329, 18330, 18333, 18331, 18332, 18302, 16096, 16097, 16101, 16117, 13773, 13774, 10616, 10617, 8241, 7775, 8040, 5892, 5889, 5871, 5870) AND `shop_productvariation`.`num_in_stock` > 0 ) ORDER BY `shop_productvariation`.`default` DESC
  56. 396765 someclient yetsomeotherserver:41456 someclient Query 157 Locked SELECT DISTINCT `shop_productvariation`.`option1`, `shop_productvariation`.`default` FROM `shop_productvariation` WHERE (`shop_productvariation`.`product_id` IN (16979, 16974, 16752, 16577, 16572, 16574, 16573, 16571, 16649, 16647, 16646, 16648, 16462, 15430, 15429, 11072, 6157, 6158, 6159, 6160, 6161, 6162, 18536, 18535, 18384, 16967, 16978, 16977, 16663, 16740, 16800, 16744, 16799, 16798, 16797, 16793, 16655, 16580, 16015, 16556, 16555, 16554, 16664, 16557, 16016, 16654, 16653, 16478, 16810, 16808, 16247, 15268, 15106, 15107, 14435, 14206, 14291, 14293, 13805, 13599, 12338, 13190, 13191, 12850, 12851, 13186, 13187, 13188, 13189, 11050, 11051, 8108, 6522, 6372, 6376, 6397, 6398, 6311, 6526, 6525) AND `shop_productvariation`.`num_in_stock` > 0 ) ORDER BY `shop_productvariation`.`default` DESC
  57. 396783 someclient someserver:57952 someclient Sleep 142 NULL
  58. 396789 someclient someserver:57956 someclient Sleep 138 NULL
  59. 396803 someclient yetsomeotherserver:41522 someclient Query 124 Locked SELECT DISTINCT `shop_productvariation`.`option1`, `shop_productvariation`.`default` FROM `shop_productvariation` WHERE (`shop_productvariation`.`product_id` IN (18390, 18393, 18388, 18396, 18395, 16899, 16903, 16813, 16815, 16814, 16811, 16812, 16816, 14456, 14457, 14458, 14459, 12876, 12879, 16889, 16883, 16884, 16025, 16026, 16024, 16018, 16020, 16019, 16017, 16192, 15609, 15612, 15450, 15444, 15443, 15445, 15271, 15272, 15273, 14789, 14687, 14666, 14488, 14489, 14490, 14000, 14001, 14002, 14003, 14004, 13477, 13214, 10840, 11110, 6461, 14974) AND `shop_productvariation`.`num_in_stock` > 0 ) ORDER BY `shop_productvariation`.`default` DESC
  60. 396811 someclient someotherserver:47932 someclient Query 122 Locked SELECT `shop_productvariation`.`option1`, `shop_productvariation`.`option2` FROM `shop_productvariation` WHERE (`shop_productvariation`.`product_id` = 16838 AND `shop_productvariation`.`unit_price` IS NOT NULL) ORDER BY `shop_productvariation`.`default` DESC
  61. 396818 someclient someotherserver:47947 someclient Query 120 Locked SELECT `shop_productvariation`.`option1`, `shop_productvariation`.`option2` FROM `shop_productvariation` WHERE (`shop_productvariation`.`product_id` = 15216 AND `shop_productvariation`.`unit_price` IS NOT NULL) ORDER BY `shop_productvariation`.`default` DESC
  62. 396821 someclient yetsomeotherserver:41565 someclient Sleep 106 NULL
  63. 396822 someclient bne3-0487d.server-web.com:50816 someclient Sleep 103 NULL
  64. 396843 someclient bne3-0487d.server-web.com:50860 someclient Query 89 Locked SELECT `shop_productvariation`.`option1`, `shop_productvariation`.`option2` FROM `shop_productvariation` WHERE (`shop_productvariation`.`product_id` = 12884 AND `shop_productvariation`.`unit_price` IS NOT NULL) ORDER BY `shop_productvariation`.`default` DESC
  65. 396848 someclient bne3-0487d.server-web.com:50869 someclient Query 88 Locked SELECT DISTINCT `shop_productvariation`.`option1`, `shop_productvariation`.`default` FROM `shop_productvariation` WHERE (`shop_productvariation`.`product_id` IN (18486, 18485, 18484, 18493, 18479, 18476, 18477, 18489, 18491, 18496, 18495, 18494, 18488, 18492, 18487, 18490, 18481, 18475, 18480, 18478, 18345, 18346, 18342, 18343, 18344, 18347, 18348, 18349, 16624, 15812, 15808, 15926, 15925, 15520, 6122, 6120, 15521, 16625, 16626, 16331, 16303, 15813, 16330, 13609, 14922, 15942, 15938, 15939, 15924, 15946, 15941, 15931, 15540, 15932, 16319, 15933, 15525, 15940, 15923, 15943, 15945, 15948, 15929, 15928, 15920, 16307, 16306, 15934, 15956, 15732, 15731, 15730, 16305, 15955, 16314, 16308, 16315, 16313, 16312, 11666, 16152, 16322, 11665, 15927, 16304, 16310, 16317, 16327, 16320, 16316, 15895, 15896, 15519, 15538, 15522, 15531, 15527, 15532, 15533, 15528, 6038, 14918, 14913, 14923, 14924, 14946, 14950, 14952, 14925, 14926, 14929, 14930, 14957, 14959, 14741, 14735, 13675, 13676, 13536, 14912, 13556, 13557, 11686, 11687, 11688, 11683, 12182, 12710, 12740, 12741, 12771, 12773, 12774, 12775, 12783, 12785, 13103, 12781, 13092, 13093, 13094, 11695, 13108, 13109, 13110, 13111, 13122, 13123, 12199, 12200, 13104, 13125, 13128, 9868, 9869, 9872, 10677, 9834, 9835, 10923, 7350, 6114, 6054, 6052, 6113, 6112, 6106, 6029, 6005, 6004, 6003, 6009, 6021, 6019, 6015, 6045, 6025, 6046, 6028, 6027, 6026, 12757, 12758) AND `shop_productvariation`.`num_in_stock` > 0 ) ORDER BY `shop_productvariation`.`default` DESC
  66. 396854 someclient bne3-0487d.server-web.com:50899 someclient Query 67 Locked SELECT `shop_productvariation`.`option1`, `shop_productvariation`.`option2` FROM `shop_productvariation` WHERE (`shop_productvariation`.`product_id` = 14406 AND `shop_productvariation`.`unit_price` IS NOT NULL) ORDER BY `shop_productvariation`.`default` DESC
  67. 396864 someclient yetsomeotherserver:41613 someclient Query 59 Locked SELECT DISTINCT `shop_productvariation`.`option1`, `shop_productvariation`.`default` FROM `shop_productvariation` WHERE (`shop_productvariation`.`product_id` IN (8946, 11482, 10403, 10404, 10405, 9537, 9696, 9914, 8767, 9321, 18223, 18224, 18226, 18225, 18216, 17193, 17196, 16666, 16420, 16586, 16164, 16084, 16076, 16079, 15548, 15825, 15546, 15547, 15508, 14996, 14905, 14850, 14794, 14852, 14807, 14803, 14804, 14802, 14801, 14699, 14840, 14841, 14698, 14842, 14798, 14799, 14626, 14508, 14512, 14514, 14515, 14517, 14519, 14520, 14521, 14522, 14524, 14501, 14494, 14498, 14506, 14507, 14509, 14510, 14511, 14527, 14495, 14496, 14129, 14133, 14173, 14175, 14177, 14163, 14165, 14159, 14161, 14025, 14022, 14024, 14038, 14039, 14040, 13916, 13917, 13848, 13740, 13807, 13808, 13809, 13835, 13825, 13845, 13830, 13847, 12064, 12065, 12066, 12067, 12068, 12069, 12070, 12071, 12072, 12073, 12074, 12075, 12076, 12077, 12078, 12079, 12080, 12081, 12087, 12088, 12089, 12090, 12091, 12092, 12093, 12094, 12095, 12096, 12524, 12528, 12543, 12544, 12545, 12546, 12547, 12548, 12549, 12550, 12551, 12552, 12553, 12554, 12555, 12556, 12557, 12558, 12559, 12560, 12561, 12562, 11511, 11554, 12043, 12050, 12051, 12052, 12054, 12056, 12477, 12571, 12572, 12573, 12574, 12575, 12576, 12577, 12606, 12607, 12609, 12610, 12047, 11484, 11483, 12385, 12370, 12387, 12467, 12468, 12469, 12475, 12481, 12482, 12483, 12516, 12518, 12613, 12614, 12615, 12384, 12425, 12427, 12443, 12447, 12480, 12517, 12568, 12569, 12570, 12634, 12637, 11451, 11486, 11487, 11526, 11525, 11568, 12408, 12453, 12465, 12542, 12589, 13219, 13220, 13222, 13217, 11476, 9648, 9649, 9650, 9651, 9652, 9653, 9654, 9655, 10496, 9623, 9624, 9625, 9942, 9964, 9966, 9988, 10025, 10045, 10046, 10047, 10048, 10049, 10050, 10390, 10397, 10401, 10402, 10495, 9539, 9628, 9629, 9630, 9659, 9661, 9663, 9667, 9751, 9752, 10055, 10056, 10355, 10378, 10381, 10353, 9602, 9646, 10374, 10373, 9614, 9741, 9743, 9927, 9985, 10031, 10061, 10357, 10365, 10406, 8727, 8781, 8782, 8529, 8530, 8531, 8532, 8536, 8537, 8585, 9136, 9235, 9251, 9252, 9263, 8697, 8509, 8558, 8587, 8777, 8778, 8970, 9243, 8717, 8461, 8574, 8522) AND `shop_productvariation`.`num_in_stock` > 0 ) ORDER BY `shop_productvariation`.`default` DESC
  68. 396867 someclient bne3-0487d.server-web.com:50928 someclient Sleep 45 NULL
  69. 396870 someclient someotherserver:48092 someclient Query 36 Locked SELECT DISTINCT `shop_productvariation`.`option1`, `shop_productvariation`.`default` FROM `shop_productvariation` WHERE (`shop_productvariation`.`product_id` IN (18486, 18485, 18484, 18493, 18479, 18476, 18477, 18489, 18491, 18496, 18495, 18494, 18488, 18492, 18487, 18490, 18481, 18475, 18480, 18478, 18345, 18346, 18342, 18343, 18344, 18347, 18348, 18349, 16624, 15812, 15808, 15926, 15925, 15520, 6122, 6120, 15521, 16625, 16626, 16331, 16303, 15813, 16330, 13609, 14922, 15942, 15938, 15939, 15924, 15946, 15941, 15931, 15540, 15932, 16319, 15933, 15525, 15940, 15923, 15943, 15945, 15948, 15929, 15928, 15920, 16307, 16306, 15934, 15956, 15732, 15731, 15730, 16305, 15955, 16314, 16308, 16315, 16313, 16312, 11666, 16152, 16322, 11665, 15927, 16304, 16310, 16317, 16327, 16320, 16316, 15895, 15896, 15519, 15538, 15522, 15531, 15527, 15532, 15533, 15528, 6038, 14918, 14913, 14923, 14924, 14946, 14950, 14952, 14925, 14926, 14929, 14930, 14957, 14959, 14741, 14735, 13675, 13676, 13536, 14912, 13556, 13557, 11686, 11687, 11688, 11683, 12182, 12710, 12740, 12741, 12771, 12773, 12774, 12775, 12783, 12785, 13103, 12781, 13092, 13093, 13094, 11695, 13108, 13109, 13110, 13111, 13122, 13123, 12199, 12200, 13104, 13125, 13128, 9868, 9869, 9872, 10677, 9834, 9835, 10923, 7350, 6114, 6054, 6052, 6113, 6112, 6106, 6029, 6005, 6004, 6003, 6009, 6021, 6019, 6015, 6045, 6025, 6046, 6028, 6027, 6026, 12757, 12758) AND `shop_productvariation`.`num_in_stock` > 0 ) ORDER BY `shop_productvariation`.`default` DESC
  70. 396871 someclient yetsomeotherserver:41634 someclient Query 37 Locked SELECT `shop_productvariation`.`option1`, `shop_productvariation`.`option2` FROM `shop_productvariation` WHERE (`shop_productvariation`.`product_id` = 14845 AND `shop_productvariation`.`unit_price` IS NOT NULL) ORDER BY `shop_productvariation`.`default` DESC
  71. 396875 someclient someotherserver:48097 someclient Query 4 NULL commit
  72. 396876 someclient someotherserver:48098 someclient Query 4 NULL commit
  73. 396878 someclient bne3-0487d.server-web.com:50946 someclient Query 4 NULL commit
  74. 396881 someclient someotherserver:48114 someclient Query 4 NULL commit
  75. 396882 someclient someserver:58052 someclient Query 28 Locked SELECT COUNT(DISTINCT `shop_product`.`id`) FROM `shop_product` LEFT OUTER JOIN `shop_product_categories` ON (`shop_product`.`id` = `shop_product_categories`.`product_id`) LEFT OUTER JOIN `shop_category` ON (`shop_product_categories`.`category_id` = `shop_category`.`page_ptr_id`) LEFT OUTER JOIN `pages_page` ON (`shop_category`.`page_ptr_id` = `pages_page`.`id`) LEFT OUTER JOIN `shop_productvariation` ON (`shop_product`.`id` = `shop_productvariation`.`product_id`) LEFT OUTER JOIN `shop_product_categories` T7 ON (`shop_product`.`id` = T7.`product_id`) LEFT OUTER JOIN `shop_category` T8 ON (T7.`category_id` = T8.`page_ptr_id`) LEFT OUTER JOIN `pages_page` T9 ON (T8.`page_ptr_id` = T9.`id`) LEFT OUTER JOIN `shop_productvariation` T10 ON (`shop_product`.`id` = T10.`product_id`) LEFT OUTER JOIN `shop_product_categories` T11 ON (`shop_product`.`id` = T11.`product_id`) LEFT OUTER JOIN `shop_category` T12 ON (T11.`category_id` = T12.`page_ptr_id`) LEFT OUTER JOIN `pages_page` T13 ON (T12.`page_ptr_id` = T13.`id`) LEFT OUTER JOIN `shop_productvariation` T14 ON (`shop_product`.`id` = T14.`product_id`) LEFT OUTER JOIN `shop_product_categories` T15 ON (`shop_product`.`id` = T15.`product_id`) LEFT OUTER JOIN `shop_category` T16 ON (T15.`category_id` = T16.`page_ptr_id`) LEFT OUTER JOIN `pages_page` T17 ON (T16.`page_ptr_id` = T17.`id`) LEFT OUTER JOIN `shop_productvariation` T18 ON (`shop_product`.`id` = T18.`product_id`) WHERE (`shop_product`.`site_id` = 1 AND (`shop_product`.`title` LIKE '%on%' OR `shop_product`.`content` LIKE '%on%' OR `pages_page`.`title` LIKE '%on%' OR `shop_productvariation`.`sku` LIKE '%on%' ) AND (`shop_product`.`title` LIKE '%a%' OR `shop_product`.`content` LIKE '%a%' OR T9.`title` LIKE '%a%' OR T10.`sku` LIKE '%a%' ) AND (`shop_product`.`title` LIKE '%roll%' OR `shop_product`.`content` LIKE '%roll%' OR T13.`title` LIKE '%roll%' OR T14.`sku` LIKE '%roll%' ) AND (`shop_product`.`title` LIKE '%tape%' OR `shop_product`.`content` LIKE '%tape%' OR T17.`title` LIKE '%tape%' OR T18.`sku` LIKE '%tape%' ))
  76. 396883 someclient yetsomeotherserver:41646 someclient Query 4 NULL commit
  77. 396884 someclient bne3-0487d.server-web.com:50959 someclient Query 22 Locked SELECT `shop_productvariation`.`option1`, `shop_productvariation`.`option2` FROM `shop_productvariation` WHERE (`shop_productvariation`.`product_id` = 10151 AND `shop_productvariation`.`unit_price` IS NOT NULL) ORDER BY `shop_productvariation`.`default` DESC
  78. 396885 someclient someserver:58063 someclient Sleep 16 NULL
  79. 396886 someclient someserver:58065 someclient Sleep 14 NULL
  80. 396888 someclient yetsomeotherserver:41670 someclient Query 3 NULL commit
  81. 396891 someclient yetsomeotherserver:41680 someclient Query 2 Locked SELECT DISTINCT `shop_productvariation`.`option1`, `shop_productvariation`.`default` FROM `shop_productvariation` WHERE (`shop_productvariation`.`product_id` IN (16227, 16225, 16229, 16222, 16231, 16211, 16182, 16181, 15468, 15469, 15543, 15545, 15544, 15541, 15542, 15356, 15349, 15351, 15352, 15347, 15334, 15338, 15252, 15244, 15262, 15263, 15264, 15181, 14966, 14975, 14783, 14594, 14606, 13988, 11901, 11831, 6166, 6169, 6243, 6273, 6264, 6265, 6266) AND `shop_productvariation`.`num_in_stock` > 0 ) ORDER BY `shop_productvariation`.`default` DESC
  82. 396892 someclient someotherserver:48148 someclient Query 0 NULL commit
  83. 396893 someclient someotherserver:48149 someclient Sleep 0 NULL
  84. 396895 someclient someotherserver:48157 someclient Sleep 0 NULL
  85. 396896 root localhost NULL Query 0 NULL show full processlist
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!