| 0.0009 |
SELECT COUNT(*) AS `numrows`
FROM `cle_products`
WHERE `type` = 'product'
|
| 0.0000 |
SELECT COUNT(*) AS `numrows`
FROM `cle_products`
WHERE `type` = 'product'
|
| 0.0019 |
SELECT *
FROM `cle_products`
WHERE `public` = 1
AND `trash` = 0
AND `type` = 'product'
ORDER BY `cle_products`.`order`, `cle_products`.`created` desc
LIMIT 48, 16
|
| 0.0002 |
SELECT *
FROM `cle_products`
WHERE `public` = 1
AND `trash` = 0
AND `type` = 'product'
ORDER BY `cle_products`.`order`, `cle_products`.`created` desc
LIMIT 48, 16
|
| 0.0004 |
SELECT *
FROM `cle_relationships`
WHERE `category_id` = 'main-nav'
AND `object_type` = 'menu'
|
| 0.0002 |
SELECT *
FROM `cle_relationships`
WHERE `category_id` = 'main-vertical'
AND `object_type` = 'menu'
|
| 0.0002 |
SELECT *
FROM `cle_relationships`
WHERE `category_id` = 'menu-mobile'
AND `object_type` = 'menu'
|
| 0.0003 |
SELECT *
FROM `cle_group`
WHERE `id` = '7'
|
| 0.0002 |
SELECT *
FROM `cle_menu`
WHERE `menu_id` = '7'
AND `parent_id` = 0
ORDER BY `order`, `created` desc
|
| 0.0003 |
SELECT *
FROM `cle_menu`
WHERE `parent_id` = '56'
AND `menu_id` = '7'
ORDER BY `order`, `created` desc
|
| 0.0002 |
SELECT *
FROM `cle_menu`
WHERE `parent_id` = '57'
AND `menu_id` = '7'
ORDER BY `order`, `created` desc
|
| 0.0001 |
SELECT *
FROM `cle_menu`
WHERE `parent_id` = '58'
AND `menu_id` = '7'
ORDER BY `order`, `created` desc
|
| 0.0001 |
SELECT *
FROM `cle_menu`
WHERE `parent_id` = '59'
AND `menu_id` = '7'
ORDER BY `order`, `created` desc
|
| 0.0001 |
SELECT *
FROM `cle_menu`
WHERE `parent_id` = '60'
AND `menu_id` = '7'
ORDER BY `order`, `created` desc
|
| 0.0002 |
SHOW TABLES FROM `oilnaryihosting_alohousevn`
|
| 0.0002 |
SELECT *
FROM `cle_product_metadata`
WHERE `object_id` = '12'
AND `meta_key` = 'view'
|
| 0.0002 |
SELECT *
FROM `cle_product_metadata`
WHERE `object_id` = '12'
AND `meta_key` = 'rating_star'
|
| 0.0002 |
SELECT *
FROM `cle_product_metadata`
WHERE `object_id` = '51'
AND `meta_key` = 'view'
|
| 0.0002 |
SELECT *
FROM `cle_product_metadata`
WHERE `object_id` = '51'
AND `meta_key` = 'rating_star'
|
| 0.0003 |
SELECT *
FROM `cle_product_metadata`
WHERE `object_id` = '49'
AND `meta_key` = 'view'
|
| 0.0001 |
SELECT *
FROM `cle_product_metadata`
WHERE `object_id` = '49'
AND `meta_key` = 'rating_star'
|
| 0.0002 |
SELECT *
FROM `cle_product_metadata`
WHERE `object_id` = '48'
AND `meta_key` = 'view'
|
| 0.0002 |
SELECT *
FROM `cle_product_metadata`
WHERE `object_id` = '48'
AND `meta_key` = 'rating_star'
|
| 0.0002 |
SELECT *
FROM `cle_product_metadata`
WHERE `object_id` = '47'
AND `meta_key` = 'view'
|
| 0.0001 |
SELECT *
FROM `cle_product_metadata`
WHERE `object_id` = '47'
AND `meta_key` = 'rating_star'
|
| 0.0001 |
SELECT *
FROM `cle_product_metadata`
WHERE `object_id` = '46'
AND `meta_key` = 'view'
|
| 0.0001 |
SELECT *
FROM `cle_product_metadata`
WHERE `object_id` = '46'
AND `meta_key` = 'rating_star'
|
| 0.0001 |
SELECT *
FROM `cle_product_metadata`
WHERE `object_id` = '13'
AND `meta_key` = 'view'
|
| 0.0002 |
SELECT *
FROM `cle_product_metadata`
WHERE `object_id` = '13'
AND `meta_key` = 'rating_star'
|
| 0.0001 |
SELECT *
FROM `cle_product_metadata`
WHERE `object_id` = '10'
AND `meta_key` = 'view'
|
| 0.0002 |
SELECT *
FROM `cle_product_metadata`
WHERE `object_id` = '10'
AND `meta_key` = 'rating_star'
|
| 0.0002 |
SELECT *
FROM `cle_product_metadata`
WHERE `object_id` = '9'
AND `meta_key` = 'view'
|
| 0.0002 |
SELECT *
FROM `cle_product_metadata`
WHERE `object_id` = '9'
AND `meta_key` = 'rating_star'
|
| 0.0001 |
SELECT *
FROM `cle_product_metadata`
WHERE `object_id` = '32'
AND `meta_key` = 'view'
|
| 0.0002 |
SELECT *
FROM `cle_product_metadata`
WHERE `object_id` = '32'
AND `meta_key` = 'rating_star'
|
| 0.0001 |
SELECT *
FROM `cle_product_metadata`
WHERE `object_id` = '33'
AND `meta_key` = 'view'
|
| 0.0003 |
SELECT *
FROM `cle_product_metadata`
WHERE `object_id` = '33'
AND `meta_key` = 'rating_star'
|
| 0.0002 |
SELECT *
FROM `cle_product_metadata`
WHERE `object_id` = '34'
AND `meta_key` = 'view'
|
| 0.0001 |
SELECT *
FROM `cle_product_metadata`
WHERE `object_id` = '34'
AND `meta_key` = 'rating_star'
|
| 0.0001 |
SELECT *
FROM `cle_product_metadata`
WHERE `object_id` = '35'
AND `meta_key` = 'view'
|
| 0.0001 |
SELECT *
FROM `cle_product_metadata`
WHERE `object_id` = '35'
AND `meta_key` = 'rating_star'
|
| 0.0001 |
SELECT *
FROM `cle_product_metadata`
WHERE `object_id` = '36'
AND `meta_key` = 'view'
|
| 0.0002 |
SELECT *
FROM `cle_product_metadata`
WHERE `object_id` = '36'
AND `meta_key` = 'rating_star'
|
| 0.0001 |
SELECT *
FROM `cle_product_metadata`
WHERE `object_id` = '37'
AND `meta_key` = 'view'
|
| 0.0002 |
SELECT *
FROM `cle_product_metadata`
WHERE `object_id` = '37'
AND `meta_key` = 'rating_star'
|
| 0.0002 |
SELECT *
FROM `cle_product_metadata`
WHERE `object_id` = '38'
AND `meta_key` = 'view'
|
| 0.0001 |
SELECT *
FROM `cle_product_metadata`
WHERE `object_id` = '38'
AND `meta_key` = 'rating_star'
|
