![](images/main/a01.jpg) |
(mysql): Select * From `ProductsNode` WHERE `node_id`= '2'
(mysql): Select * From `ProductsNode` WHERE `node_level`= '2' AND `node_left` > '2' AND `node_right` < '7' ORDER BY `node_left` ASC
(mysql): Select * From `ProductsNode` WHERE `node_id`= '3'
(mysql): Select * From `ProductsNode` WHERE `node_level`= '2' AND `node_left` > '8' AND `node_right` < '19' ORDER BY `node_left` ASC
(mysql): Select * From `ProductsNode` WHERE `node_id`= '4'
(mysql): Select * From `ProductsNode` WHERE `node_level`= '2' AND `node_left` > '20' AND `node_right` < '23' ORDER BY `node_left` ASC
(mysql): Select * From `ProductsNode` WHERE `node_id`= '5'
(mysql): Select * From `ProductsNode` WHERE `node_level`= '2' AND `node_left` > '24' AND `node_right` < '37' ORDER BY `node_left` ASC
(mysql): Select * From `ProductsNode` WHERE `node_id`= '6'
(mysql): Select * From `ProductsNode` WHERE `node_level`= '2' AND `node_left` > '38' AND `node_right` < '53' ORDER BY `node_left` ASC
(mysql): Select * From `ProductsNode` WHERE `node_id`= '7'
(mysql): Select * From `ProductsNode` WHERE `node_level`= '2' AND `node_left` > '54' AND `node_right` < '67' ORDER BY `node_left` ASC
(mysql): Select * From `ProductsNode` WHERE `node_id`= '8'
(mysql): Select * From `ProductsNode` WHERE `node_level`= '2' AND `node_left` > '68' AND `node_right` < '71' ORDER BY `node_left` ASC
(mysql): Select * From `ProductsNode` WHERE `node_id`= '9'
(mysql): Select * From `ProductsNode` WHERE `node_level`= '2' AND `node_left` > '72' AND `node_right` < '79' ORDER BY `node_left` ASC
(mysql): Select * From `ProductsNode` WHERE `node_id`= '10'
(mysql): Select * From `ProductsNode` WHERE `node_level`= '2' AND `node_left` > '80' AND `node_right` < '91' ORDER BY `node_left` ASC
|
|
|
![](images/main/atb.jpg) |
(mysql): Select * From `ProductsNode` WHERE `node_id`= '11'
(mysql): Select * From `ProductsNode` WHERE `node_level`= '2' AND `node_left` > '92' AND `node_right` < '101' ORDER BY `node_left` ASC
(mysql): Select * From `ProductsNode` WHERE `node_id`= '12'
(mysql): Select * From `ProductsNode` WHERE `node_level`= '2' AND `node_left` > '102' AND `node_right` < '109' ORDER BY `node_left` ASC
(mysql): Select * From `ProductsNode` WHERE `node_id`= '13'
(mysql): Select * From `ProductsNode` WHERE `node_level`= '2' AND `node_left` > '110' AND `node_right` < '119' ORDER BY `node_left` ASC
(mysql): Select * From `ProductsNode` WHERE `node_id`= '14'
(mysql): Select * From `ProductsNode` WHERE `node_level`= '2' AND `node_left` > '120' AND `node_right` < '127' ORDER BY `node_left` ASC
|
|
|
![](images/main/atb.jpg) |
|
|
(mysql): Select * From `Products` WHERE `status` = 'E' AND `id` != '1257' AND `inventory` > 0 AND `node_id` IN (Select node_id FROM `ProductsNode` WHERE `node_level` = '2' AND `node_left` > '92' AND `node_right` < '101') ORDER BY RAND() LIMIT 0, 12
![](images/products/related_arrow01.jpg) |
(mysql): Select * From `Brands` WHERE `id` = '54'
| |
(mysql): Select * From `Brands` WHERE `id` = '56'
| |
(mysql): Select * From `Brands` WHERE `id` = '55'
| |
(mysql): Select * From `Brands` WHERE `id` = '54'
| |
(mysql): Select * From `Brands` WHERE `id` = '62'
|
(mysql): Select * From `Brands` WHERE `id` = '62'
| |
(mysql): Select * From `Brands` WHERE `id` = '62'
| |
(mysql): Select * From `Brands` WHERE `id` = '54'
| |
(mysql): Select * From `Brands` WHERE `id` = '56'
| |
(mysql): Select * From `Brands` WHERE `id` = '62'
|
(mysql): Select * From `Brands` WHERE `id` = '62'
| |
(mysql): Select * From `Brands` WHERE `id` = '46'
| |
|
![](images/products/related_arrow02.jpg) |
|