Array
(
    [0] => SELECT 1
FROM `ci_sessions`
WHERE `id` = 'vto659vkbcut0g1kaiq9okmfup807srj'
    [1] => SELECT GET_LOCK('ba465aa70a1c1227ded9b93415689a6a', 300) AS ci_session_lock
    [2] => SELECT `data`
FROM `ci_sessions`
WHERE `id` = 'vto659vkbcut0g1kaiq9okmfup807srj'
    [3] => SELECT *
FROM `general_settings`
    [4] => SELECT *
FROM `users`
    [5] => SELECT * FROM language_translations WHERE lang_id = 1
    [6] => SELECT *
FROM `currencies`
ORDER BY `status` DESC, `id`
    [7] => SELECT *
FROM `location_countries`
WHERE `status` = 1
ORDER BY `name`
    [8] => SELECT *
FROM `users`
WHERE `id` = '51'
    [9] => SELECT * FROM ((SELECT font_url AS site_font_url, font_family AS site_font_family FROM fonts WHERE id = 33) AS tbl_site, 
        (SELECT font_url AS dashboard_font_url, font_family AS dashboard_font_family FROM fonts WHERE id = 22) AS tbl_dashboard)
    [10] => SELECT `id`, `title`, `slug`, `page_order`, `location`, `page_default_name`
FROM `pages`
WHERE `lang_id` = 1
AND `visibility` = 1
AND `v_id` = '51'
ORDER BY `page_order`
    [11] => SELECT `id`
FROM `categories`
WHERE `parent_id` = 0
    [12] => SELECT `categories`.`id`, `categories`.`slug`, `categories`.`parent_id`, `categories`.`parent_tree`, `categories`.`category_order`, `categories`.`featured_order`, `categories`.`storage`, `categories`.`image`, `categories`.`show_image_on_navigation`, `categories`.`parent_id` AS `join_parent_id`, (SELECT name FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS name, (SELECT slug FROM categories WHERE id = join_parent_id) AS parent_slug, (SELECT id FROM categories AS sub_categories WHERE sub_categories.parent_id = categories.id LIMIT 1) AS has_subcategory
FROM `categories`
WHERE `visibility` = 1
AND   (
categories.id IN(SELECT `id`
FROM `categories`
WHERE `id` IN('1', '3', '19', '26', '104', '109', '200')
AND `parent_id` = 0)
OR categories.id IN(SELECT `id`
FROM `categories`
WHERE parent_id IN(SELECT `id`
FROM `categories`
WHERE `id` IN('1', '3', '19', '26', '104', '109', '200')
AND `parent_id` = 0))
OR categories.id IN(SELECT `id`
FROM `categories`
WHERE parent_id IN(SELECT `id`
FROM `categories`
WHERE parent_id IN(SELECT `id`
FROM `categories`
WHERE `id` IN('1', '3', '19', '26', '104', '109', '200')
AND `parent_id` = 0)))
 )
ORDER BY `categories`.`created_at`
    [13] => SELECT `categories`.`id`, `categories`.`slug`, `categories`.`parent_id`, `categories`.`parent_tree`, `categories`.`category_order`, `categories`.`featured_order`, `categories`.`storage`, `categories`.`image`, `categories`.`show_image_on_navigation`, `categories`.`parent_id` AS `join_parent_id`, (SELECT name FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS name, (SELECT slug FROM categories WHERE id = join_parent_id) AS parent_slug, (SELECT id FROM categories AS sub_categories WHERE sub_categories.parent_id = categories.id LIMIT 1) AS has_subcategory
FROM `categories`
WHERE `visibility` = 1
AND   (
categories.id IN(SELECT `id`
FROM `categories`
WHERE `parent_id` = 0)
OR categories.id IN(SELECT `id`
FROM `categories`
WHERE parent_id IN(SELECT `id`
FROM `categories`
WHERE `parent_id` = 0))
OR categories.id IN(SELECT `id`
FROM `categories`
WHERE parent_id IN(SELECT `id`
FROM `categories`
WHERE parent_id IN(SELECT `id`
FROM `categories`
WHERE `parent_id` = 0)))
 )
ORDER BY `categories`.`created_at`
    [14] => SELECT *
FROM `users`
WHERE `users`.`domain_name` LIKE '%metromantar.com%' ESCAPE '!'
 LIMIT 1
    [15] => SELECT `user_category`.*
FROM `user_category`
WHERE `user_id` = 51
    [16] => SELECT *
FROM `pages`
WHERE `v_id` = '51'
AND `slug` = 'mens-fashion'
AND `visibility` = 1
AND `pages`.`lang_id` = 1
    [17] => SELECT `categories`.*, `categories`.`parent_id` AS `join_parent_id`, (SELECT name FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS name, (SELECT slug FROM categories WHERE id = join_parent_id) AS parent_slug, (SELECT id FROM categories AS sub_categories WHERE sub_categories.parent_id = categories.id LIMIT 1) AS has_subcategory
FROM `categories`
WHERE `categories`.`slug` = 'mens-fashion'
AND `visibility` = 1
AND `parent_id` = 0
ORDER BY `id`
 LIMIT 1
    [18] => SELECT *
FROM `categories`
WHERE FIND_IN_SET(1, categories.parent_tree)
    [19] => SELECT `categories`.*, `categories`.`parent_id` AS `join_parent_id`, (SELECT name FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS name, (SELECT slug FROM categories WHERE id = join_parent_id) AS parent_slug, (SELECT id FROM categories AS sub_categories WHERE sub_categories.parent_id = categories.id LIMIT 1) AS has_subcategory
FROM `categories`
WHERE id IN(11, 1, 12, 13, 14, 112, 113, 201, 202, 203, 204, 205, 206, 208, 209, 210, 211, 212, 213, 214, 215, 216, 217, 218, 219, 220, 239, 240, 241, 242, 247, 248, 249, 250, 252, 255, 256, 257, 259, 260, 265, 266, 267, 268, 269, 270, 271, 272, 273, 284, 288, 292, 294, 341, 342, 343, 344, 345, 346, 347, 348, 349, 350, 351, 352, 353, 355, 359, 427, 428, 429, 430)
AND `visibility` = 1
AND `parent_id` = '1'
    [20] => SELECT `categories`.*, `categories`.`parent_id` AS `join_parent_id`, (SELECT name FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS name, (SELECT slug FROM categories WHERE id = join_parent_id) AS parent_slug, (SELECT id FROM categories AS sub_categories WHERE sub_categories.parent_id = categories.id LIMIT 1) AS has_subcategory
FROM `categories`
WHERE categories.id IN(1)
AND `categories`.`visibility` = 1
ORDER BY FIELD(id, 1)
    [21] => SELECT `custom_fields`.*
FROM `custom_fields`
JOIN `custom_fields_category` ON `custom_fields_category`.`field_id` = `custom_fields`.`id`
WHERE `custom_fields_category`.`category_id` IN('1')
AND `custom_fields`.`status` = 1
AND `custom_fields`.`is_product_filter` = 1
AND   (
`custom_fields`.`field_type` = 'checkbox'
OR `custom_fields`.`field_type` = 'radio_button'
OR `custom_fields`.`field_type` = 'dropdown'
 )
ORDER BY `custom_fields`.`field_order`
    [22] => SELECT COUNT(*) AS `numrows`
FROM `products`
JOIN `users` ON `products`.`user_id` = `users`.`id` AND `users`.`is_membership_plan_expired` = 0
WHERE `users`.`banned` = 0
AND `products`.`status` = 1
AND `products`.`visibility` = 1
AND `products`.`is_draft` = 0
AND `products`.`is_deleted` = 0
AND `users`.`role` != 'member'
AND products.category_id IN(11, 12, 13, 14, 112, 113, 201, 202, 203, 204, 205, 206, 208, 209, 210, 211, 212, 213, 214, 215, 216, 217, 218, 219, 220, 239, 240, 241, 242, 247, 248, 249, 250, 252, 255, 256, 257, 259, 260, 265, 266, 267, 268, 269, 270, 271, 272, 273, 284, 288, 292, 294, 341, 342, 343, 344, 345, 346, 347, 348, 349, 350, 351, 352, 353, 355, 359, 427, 428, 429, 430, 1)
    [23] => SELECT `products`.`id`, `products`.`slug`, `products`.`listing_type`, `products`.`is_free_product`, `products`.`price`, `products`.`rating`, `products`.`discount_rate`, `products`.`stock`, `products`.`user_id`, `products`.`parent_cat`, `products`.`category_id`, `products`.`orderby`, `products`.`is_promoted`, `products`.`created_at`, `products`.`main_image`, ROUND(products.price - ((products.price * products.discount_rate)/100)) AS price_final
FROM `products`
JOIN `users` ON `products`.`user_id` = `users`.`id` AND `users`.`is_membership_plan_expired` = 0
WHERE `products`.`status` = 1
AND `products`.`visibility` = 1
AND `products`.`is_draft` = 0
AND `products`.`is_deleted` = 0
AND `users`.`role` != 'member'
AND products.category_id IN(11, 12, 13, 14, 112, 113, 201, 202, 203, 204, 205, 206, 208, 209, 210, 211, 212, 213, 214, 215, 216, 217, 218, 219, 220, 239, 240, 241, 242, 247, 248, 249, 250, 252, 255, 256, 257, 259, 260, 265, 266, 267, 268, 269, 270, 271, 272, 273, 284, 288, 292, 294, 341, 342, 343, 344, 345, 346, 347, 348, 349, 350, 351, 352, 353, 355, 359, 427, 428, 429, 430, 1)
ORDER BY `products`.`orderby` ASC, `products`.`is_promoted` DESC, `products`.`created_at` DESC
 LIMIT 408, 24
)
Array
(
    [0] => 0.00029993057250977
    [1] => 1.0924680233002
    [2] => 0.00025010108947754
    [3] => 0.00066900253295898
    [4] => 0.01784086227417
    [5] => 0.00056910514831543
    [6] => 0.00021910667419434
    [7] => 0.00017404556274414
    [8] => 0.00020003318786621
    [9] => 0.00015711784362793
    [10] => 0.0001528263092041
    [11] => 0.00016999244689941
    [12] => 0.00025081634521484
    [13] => 0.00020384788513184
    [14] => 0.00017714500427246
    [15] => 0.00012898445129395
    [16] => 0.00020003318786621
    [17] => 0.00019598007202148
    [18] => 0.0002288818359375
    [19] => 0.00016498565673828
    [20] => 0.00016117095947266
    [21] => 0.00016498565673828
    [22] => 0.076702117919922
    [23] => 0.098326921463013
)