select count(p.products_id) as total from products p inner join products_description pd on p.products_id = pd.products_id where pd.products_name LIKE 'v%' === 0.072468996047974 === /index.php === /canada-laptop-batteries/v/5.html
select p.`products_id`,pd.`products_name` FROM (SELECT products_id FROM products_description where products_name like 'v%' ORDER BY products_id desc limit 400, 100) AS tmp INNER JOIN products p ON tmp.products_id = p.products_id ,products_description pd where p.`products_id` = pd.`products_id` AND pd.`products_name` LIKE 'v%' limit 100 === 0.020215034484863 === /index.php === /canada-laptop-batteries/v/5.html
Canada Battery Store: Vr8590 battery store, other 24Wh camcorder batteries for
Shopping Cart
0 item(s) - C$0.00
ProductBanner_1
A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | 0-9
select count(p.products_id) as total from products p inner join products_description pd on p.products_id = pd.products_id where pd.products_name LIKE 'v%' === 0.070037841796875 === /index.php === /canada-laptop-batteries/v/5.html
select p.`products_id`,pd.`products_name` FROM (SELECT products_id FROM products_description where products_name like 'v%' ORDER BY products_id desc limit 400, 100) AS tmp INNER JOIN products p ON tmp.products_id = p.products_id ,products_description pd where p.`products_id` = pd.`products_id` AND pd.`products_name` LIKE 'v%' limit 100 === 0.020435094833374 === /index.php === /canada-laptop-batteries/v/5.html
 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25
 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50
 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75
 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100
 101 102 103 104 105

Disclaimer:
The information on this website contains certain brand trademarks, which is solely to show that our products are compatible with this brand, the trademarks belong to the original registered brands

Parse Time: 0.734 - Number of Queries: 549 - Query Time: 0.71183562278748