BadMethodCallException
BadMethodCallException
Method Illuminate\Support\Collection::byCollectionOrMenuSlug does not exist.
GET theloftfifthavenue.com
PHP 8.3.14 — Laravel 11.44.7
vendor/laravel/framework/src/Illuminate/Macroable/Traits/Macroable.php
:115
app/Http/Controllers/ProductController.php
:60
vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php
:47
vendor/laravel/framework/src/Illuminate/Routing/Route.php
:266
vendor/laravel/framework/src/Illuminate/Routing/Route.php
:212
vendor/laravel/framework/src/Illuminate/Routing/Router.php
:808
vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php
:170
vendor/twa/cache/src/middleware/CacheMiddleware.php
:121
vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php
:209
vendor/twa/ecom-auth/src/middleware/AuthCheckProfileComplete.php
:42
vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php
:209
vendor/twa/ecom-general/src/middleware/storeDefaultDataMiddleware.php
:80
vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php
:209
vendor/twa/ecom-general/src/middleware/storeRoutesMiddleware.php
:59
vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php
:209
vendor/twa/htmlhelpers/src/middleware/TWASEOMiddleware.php
:44
vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php
:209
vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php
:51
vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php
:209
vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php
:88
vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php
:209
vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php
:49
vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php
:209
vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php
:121
vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php
:64
vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php
:209
vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php
:37
vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php
:209
vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php
:75
vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php
:209
vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php
:127
vendor/laravel/framework/src/Illuminate/Routing/Router.php
:807
vendor/laravel/framework/src/Illuminate/Routing/Router.php
:786
vendor/laravel/framework/src/Illuminate/Routing/Router.php
:750
vendor/laravel/framework/src/Illuminate/Routing/Router.php
:739
vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php
:201
vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php
:170
vendor/livewire/livewire/src/Features/SupportDisablingBackButtonCache/DisableBackButtonCacheMiddleware.php
:19
vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php
:209
vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php
:49
vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php
:209
vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php
:121
vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php
:64
vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php
:209
vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php
:37
vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php
:209
vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php
:75
vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php
:209
vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php
:21
vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ConvertEmptyStringsToNull.php
:31
vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php
:209
vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php
:21
vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TrimStrings.php
:51
vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php
:209
vendor/laravel/framework/src/Illuminate/Http/Middleware/ValidatePostSize.php
:27
vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php
:209
vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/PreventRequestsDuringMaintenance.php
:110
vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php
:209
vendor/laravel/framework/src/Illuminate/Http/Middleware/HandleCors.php
:49
vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php
:209
vendor/laravel/framework/src/Illuminate/Http/Middleware/TrustProxies.php
:58
vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php
:209
vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/InvokeDeferredCallbacks.php
:22
vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php
:209
vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php
:127
vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php
:176
vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php
:145
vendor/laravel/framework/src/Illuminate/Foundation/Application.php
:1220
public/index.php
:17
Request
GET
/ae/en/products/skn
Headers
cf-ipcountry
US
cf-connecting-ip
107.173.224.127
cdn-loop
cloudflare; loops=1
x-forwarded-proto
https
cf-visitor
{"scheme":"https"}
x-forwarded-for
107.173.224.127
cf-ray
946c22f7adccd7af-LAX
accept
text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
cookie
XSRF-TOKEN=eyJpdiI6ImdwRDFJVUlWRVJQNnE2THc1QU5BaXc9PSIsInZhbHVlIjoiRnF2T1FzVDhKL1NzOGkxQ1E5QWIremtRYjJxU1B5bnlxeWxDaU81UzBhdHlvbDlSVFFMdHQ5Snc0UXFQNzNwNDZxTnJabU1xaUsxZmJlajh5cU4vYnBxZE5uQ3pJMGUwL25sODdhMnJVT05NMjJNb2sreDdQeTJQMmVsZVBaRnRha2dJcWpralZSZk1QZ0N6dmQ3K2kzY245UGIrVy9uY0lacm80Y0NOMmJ2ajQzYmUzdTgxV05PR3Z3U09MaFdiRjZZS1cyUnl0dm9IV0JvbVBKTUQxR1BHbmU0Q2N2dlFuK01VSDFDUjFDZi91bGp5a2xRNlRFSHlwN3lsZ0pUZkhoVkRoemUvV0dJS2tNbVhKZFRMaWtsTmFFWEZTTEVDZTlxbHNHSnJKU1M5d0hqRGdLY2p3a1RKWnVyMlEvR1Y1QnpJZk5hZCtpNDZQakdsdU5vaUlkOTJBSFB4UklRYUtPeTNsRFE5ZkhRcFpUbUl4RTRsemIzYk9sVjd4U3Z3aWRmQmZkTTFoenRqUGk3d2QrNTNmNE11c2g1bVJiVnFudXd4NjZoZFM3WEV3Z2h2UDl2U2k0TUI1TG9Fb3Zub0NpdXlBVU9GMXliK3IybVQxVmN2YVBIYS91TXVZa3UwVk1NaWo5ZTdzcGJoNzdOZTE5NHhJSU5RbFFsTFVlUUQiLCJtYWMiOiI3YThlNjZlOGI2YWM5NDgyNTI2ZDQ5ZjQ3OWNmNjc2NDAwNjdjMzJmZTdlMTgyYzllZWJjY2M3OGEzYmJmNGQ4IiwidGFnIjoiIn0%3D; offlineToken_v2=t_5697215a72f00f31e5d081236a408ddd; the_loft_session=eyJpdiI6ImlEb2JWRHJTUkZyWGVpbFBUSnhjbkE9PSIsInZhbHVlIjoiaEpvQkZPN1R4MDJkb25SVnNWN1hlamVQQ1M4TDREMVFiMDV4eTYvT05kN0J4bFNMSkdaOGxqVXRDK2o4S20vUjBjU25HcmxyYUFxL05vZTBFdWN0Sm1GV003SEJ3WnVTN1F0TGhJcE91N2dMNENKZFZDMFJNK3dxVjJKdDE3QUoiLCJtYWMiOiIyMTE1M2JiZmVkNWI0NzMxMDc2YjhiZTc4N2YzOTE5YmRhOTM5ZTIzMTJhYzA4MmFkMzFlNmU4ZjI3ODRiOGMyIiwidGFnIjoiIn0%3D
user-agent
Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.81 Safari/537.36
accept-encoding
gzip, br
host
theloftfifthavenue.com
Body
No body data
Application
Routing
controller
\App\Http\Controllers\ProductController@ProductListing
route name
product
middleware
web, twa\htmlhelpers\middleware\TWASEOMiddleware, twa\ecomgeneral\middleware\storeRoutesMiddleware, twa\ecomgeneral\middleware\storeDefaultDataMiddleware, twa\ecomauth\middleware\AuthCheckProfileComplete, twa\cache\middleware\CacheMiddleware
Routing Parameters
{
"store_prefix": "ae",
"language_prefix": "en",
"slug": "skn"
}
Database Queries
only the first 100 queries are displayed
mysql
(5.09 ms)
select * from `00_cms_seo_settings` where `cancelled` = 0 order by `orders` asc limit 1
mysql
(6.66 ms)
select * from `00_cms_seo_by_route` where `cancelled` = 0 order by CHAR_LENGTH(`route`) DESC
mysql
(1.55 ms)
select *, header_message_en AS header_message, label_en AS label from `ecom_stores` where `web_prefix` = 'ae' and `cancelled` = 0 and `published` = 1 limit 1
mysql
(1.69 ms)
select *, header_message_en AS header_message, label_en AS label, group_en AS `group` , contact_us_store_information_en AS contact_us_store_information from `ecom_stores` where `id` = 1 and `cancelled` = 0 limit 1
mysql
(1.44 ms)
select * from `ecom_currencies` where `id` in ('1', '2', '3')
mysql
(1.53 ms)
select * from `settings_v2` where `cancelled` = 0
mysql
(27.52 ms)
select * from `ecom_users_temporary` where `token` = 't_5697215a72f00f31e5d081236a408ddd' and `cancelled` = 0 limit 1
mysql
(1.51 ms)
select * from `00_cms_cache` where `url` = '/ae/en/products/skn' and `request_signature` = '0a4501b4f94658e7baedf109e98959dc' and `cancelled` = 0 order by `id` desc limit 1
mysql
(1.94 ms)
select * from `00_cms_utilities_frontend_menus_links` where `cancelled` = 0 and `slug` = 'skn' limit 1
mysql
(1.93 ms)
select column_name as `name`, data_type as `type_name`, column_type as `type`, collation_name as `collation`, is_nullable as `nullable`, column_default as `default`, column_comment as `comment`, generation_expression as `expression`, extra as `extra` from information_schema.columns where table_schema = 'theloftfifthaven_67daaf86e1938_db_live' and table_name = '00_cms_utilities_frontend_menus_links' order by ordinal_position asc
mysql
(2.14 ms)
select column_name as `name`, data_type as `type_name`, column_type as `type`, collation_name as `collation`, is_nullable as `nullable`, column_default as `default`, column_comment as `comment`, generation_expression as `expression`, extra as `extra` from information_schema.columns where table_schema = 'theloftfifthaven_67daaf86e1938_db_live' and table_name = '00_cms_utilities_frontend_menus_links' order by ordinal_position asc
mysql
(1.3 ms)
select * from `00_cms_utilities_frontend_menus` where `label` = 'Main Menu' and `ecom_stores_id` LIKE '%"1"%' and `cancelled` = 0 limit 1
mysql
(2.1 ms)
select *, label_en AS label, link_en AS link, CONCAT('https://theloft.fra1.cdn.digitaloceanspaces.com/theloftfifthavenue.com/public/data/front_end_menus/', id , '.', extension_image,'4v=' , version) AS image from `00_cms_utilities_frontend_menus_links` where `00_cms_utilities_frontend_menus_id` = 0 and `cancelled` = ?
mysql
(2.56 ms)
select * from `00_cms_utilities_frontend_menus_links` where `cancelled` = 0 and `id` in (2, 30, 369) order by CASE id WHEN 2 THEN 0 WHEN 30 THEN 1 WHEN 369 THEN 2 END
mysql
(2.28 ms)
select column_name as `name`, data_type as `type_name`, column_type as `type`, collation_name as `collation`, is_nullable as `nullable`, column_default as `default`, column_comment as `comment`, generation_expression as `expression`, extra as `extra` from information_schema.columns where table_schema = 'theloftfifthaven_67daaf86e1938_db_live' and table_name = 'ecom_products' order by ordinal_position asc
mysql
(2.1 ms)
select column_name as `name`, data_type as `type_name`, column_type as `type`, collation_name as `collation`, is_nullable as `nullable`, column_default as `default`, column_comment as `comment`, generation_expression as `expression`, extra as `extra` from information_schema.columns where table_schema = 'theloftfifthaven_67daaf86e1938_db_live' and table_name = 'ecom_products' order by ordinal_position asc
mysql
(2.11 ms)
select column_name as `name`, data_type as `type_name`, column_type as `type`, collation_name as `collation`, is_nullable as `nullable`, column_default as `default`, column_comment as `comment`, generation_expression as `expression`, extra as `extra` from information_schema.columns where table_schema = 'theloftfifthaven_67daaf86e1938_db_live' and table_name = 'ecom_products' order by ordinal_position asc
mysql
(2.1 ms)
select column_name as `name`, data_type as `type_name`, column_type as `type`, collation_name as `collation`, is_nullable as `nullable`, column_default as `default`, column_comment as `comment`, generation_expression as `expression`, extra as `extra` from information_schema.columns where table_schema = 'theloftfifthaven_67daaf86e1938_db_live' and table_name = 'ecom_products' order by ordinal_position asc
mysql
(2.66 ms)
select `id`, `ecom_products_bulk_pricing_id`, `price_ttc`, `keywords`, `digital_product`, `ecom_products_giftcards_id`, `ecom_vendors_id`, `ecom_products_brands_id`, `ecom_subcategories_id`, `00_cms_files_image`, `hscode`, `barcode`, `ecom_products_categories_id`, `family_group_id`, (price_ttc - price_ttc * (COALESCE(discount,0) + 0) / 100) AS price, CONCAT("/ae/en/product/",slug) AS link from `ecom_products` where `cancelled` = 0 and `display` = 1 and `ecom_stores_id` = 1 and `price_ttc` > 0 and `no_listing` = 0
mysql
(1.31 ms)
select * from `ecom_products_brands` where `id` in (2, 3, 4, 5, 1, 6, 7, 9, 10, 11, 13, 17, NULL, 18)
mysql
(1.81 ms)
select min(`price_ttc`) as aggregate from `ecom_products` where `cancelled` = 0 and `display` = 1 and `ecom_stores_id` = 1 and `price_ttc` > 0 and `no_listing` = 0
mysql
(1.61 ms)
select max(`price_ttc`) as aggregate from `ecom_products` where `cancelled` = 0 and `display` = 1 and `ecom_stores_id` = 1 and `price_ttc` > 0 and `no_listing` = 0
mysql
(1.09 ms)
SET SESSION group_concat_max_len = 99999999999
mysql
(2.42 ms)
select `id`, GROUP_CONCAT(ecom_products_filters_id SEPARATOR ',') AS col from `ecom_products` where `cancelled` = 0 and `display` = 1 and `ecom_stores_id` = 1 and `price_ttc` > 0 and `no_listing` = 0 and `ecom_products_filters_id` is not null group by 'all' limit 1
mysql
(2.15 ms)
select `id`, `version`, `cms_attributes`, label_en AS label, group_en AS `group` from `ecom_products_filters` where `cancelled` = 0 and `id` in ('147', '150', '153', '160', '162', '193', '78', '55', '38', '41', '140', '149', '151', '152', '166', '169', '173', '182', '35', '53', '45', '58', '64', '72', '148', '164', '52', '56', '103', '163', '44', '168', '42', '176', '185', '191', '79', '67', '77', '181', '71', '87', '183', '73', '172', '63', '165', '76', '184', '74', '170', '61', '167', '80', '175', '145', '146', '83', '177', '68', '189', '51', '179', '69', '186', '75', '65', '174', '155', '50', '142', '180', '60', '70', '171', '62', '37', '81', '86', '158', '178', '157', '54', '187', '109', '124', '159', '161', '91', '107', '116', '117', '188', '190', '93', '108', '57', '95', '195', '118', '119', '36', '198') order by `orders` asc
mysql
(14.13 ms)
select `ecom_products_categories_id` from `ecom_products` where `cancelled` = 0 and `display` = 1 and `ecom_stores_id` = 1 and `price_ttc` > 0 and `no_listing` = 0 group by COALESCE(family_group_id,id) order by `orders` asc
mysql
(3.1 ms)
select `ecom_products_brands_id` from `ecom_products` where `cancelled` = 0 and `display` = 1 and `ecom_stores_id` = 1 and `price_ttc` > 0 and `no_listing` = 0 group by COALESCE(family_group_id,id) order by `orders` asc
mysql
(5.74 ms)
select count(*) as aggregate from (select `id`, `ecom_products_bulk_pricing_id`, `price_ttc`, `keywords`, `digital_product`, `ecom_products_giftcards_id`, `ecom_vendors_id`, `ecom_products_brands_id`, `ecom_subcategories_id`, `00_cms_files_image`, `hscode`, `barcode`, `ecom_products_categories_id`, `family_group_id`, (price_ttc - price_ttc * (COALESCE(discount,0) + 0) / 100) AS price, CONCAT("/ae/en/product/",slug) AS link from `ecom_products` where `cancelled` = 0 and `display` = 1 and `ecom_stores_id` = 1 and `price_ttc` > 0 and `no_listing` = 0 group by COALESCE(family_group_id,id)) as `aggregate_table`
mysql
(4.06 ms)
select `id`, `ecom_products_bulk_pricing_id`, `price_ttc`, `keywords`, `digital_product`, `ecom_products_giftcards_id`, `ecom_vendors_id`, `ecom_products_brands_id`, `ecom_subcategories_id`, `00_cms_files_image`, `hscode`, `barcode`, `ecom_products_categories_id`, `family_group_id`, (price_ttc - price_ttc * (COALESCE(discount,0) + 0) / 100) AS price, CONCAT("/ae/en/product/",slug) AS link from `ecom_products` where `cancelled` = 0 and `display` = 1 and `ecom_stores_id` = 1 and `price_ttc` > 0 and `no_listing` = 0 group by COALESCE(family_group_id,id) order by `orders` asc limit 24 offset 0
mysql
(3.41 ms)
select column_name as `name`, data_type as `type_name`, column_type as `type`, collation_name as `collation`, is_nullable as `nullable`, column_default as `default`, column_comment as `comment`, generation_expression as `expression`, extra as `extra` from information_schema.columns where table_schema = 'theloftfifthaven_67daaf86e1938_db_live' and table_name = 'ecom_products' order by ordinal_position asc
mysql
(2.63 ms)
select column_name as `name`, data_type as `type_name`, column_type as `type`, collation_name as `collation`, is_nullable as `nullable`, column_default as `default`, column_comment as `comment`, generation_expression as `expression`, extra as `extra` from information_schema.columns where table_schema = 'theloftfifthaven_67daaf86e1938_db_live' and table_name = 'ecom_products' order by ordinal_position asc
mysql
(1.84 ms)
select `id`, `ecom_products_bulk_pricing_id`, `weight`, `width`, `length`, `hscode`, `barcode`, `extension_image`, `sku`, `price_ttc`, `price_shelf`, `version`, `stock_quantity`, `family_group_id`, `keywords`, `gallery`, `cms_attributes`, `ecom_products_tags_id`, `ecom_stores_id`, `ecom_subcategories_id`, `slug`, `digital_product`, `ecom_products_giftcards_id`, `preorder_available`, `ecom_vendors_id`, `ecom_products_brands_id`, `00_cms_files_image`, `created_at`, CONCAT("/ae/en/product/",slug) AS link, COALESCE(discount,0) AS discount, (price_ttc - price_ttc * (LEAST(COALESCE(discount,0) + 0,100) / 100)) AS price, LEAST(COALESCE(discount,0) + 0,100) AS discount, label_en AS label, small_description_en AS small_description, gallery from `ecom_products` where `display` = 1 and `cancelled` = 0 and `price_ttc` > 0 and `ecom_stores_id` = 1 and `id` in (482, 503, 497, 561, 580, 562, 581, 576, 564, 568, 571, 560, 577, 578, 565, 570, 572, 579, 566, 483, 484, 485, 505, 492)
mysql
(1.24 ms)
select * from `00_cms_utilities_frontend_menus` where `ecom_stores_id` LIKE '%"1"%' order by `orders` asc limit 1
mysql
(1.93 ms)
select column_name as `name`, data_type as `type_name`, column_type as `type`, collation_name as `collation`, is_nullable as `nullable`, column_default as `default`, column_comment as `comment`, generation_expression as `expression`, extra as `extra` from information_schema.columns where table_schema = 'theloftfifthaven_67daaf86e1938_db_live' and table_name = '00_cms_utilities_frontend_menus_links' order by ordinal_position asc
mysql
(1.91 ms)
select column_name as `name`, data_type as `type_name`, column_type as `type`, collation_name as `collation`, is_nullable as `nullable`, column_default as `default`, column_comment as `comment`, generation_expression as `expression`, extra as `extra` from information_schema.columns where table_schema = 'theloftfifthaven_67daaf86e1938_db_live' and table_name = '00_cms_utilities_frontend_menus_links' order by ordinal_position asc
mysql
(1.41 ms)
select * from `00_cms_utilities_frontend_menus` where `label` = 'Footer Menu' and `ecom_stores_id` LIKE '%"1"%' and `cancelled` = 0 limit 1
mysql
(3.69 ms)
select *, label_en AS label, link_en AS link, CONCAT('https://theloft.fra1.cdn.digitaloceanspaces.com/theloftfifthavenue.com/public/data/front_end_menus/', id , '.', extension_image,'2v=' , version) AS image from `00_cms_utilities_frontend_menus_links` where `00_cms_utilities_frontend_menus_id` = 0 and `cancelled` = ?
mysql
(2.44 ms)
select `id`, `extension_image`, `sku`, `price_ttc`, `price_shelf`, `version`, `stock_quantity`, `family_group_id`, `cms_attributes`, `ecom_products_tags_id`, `ecom_stores_id`, `ecom_subcategories_id`, `slug`, `digital_product`, `ecom_products_giftcards_id`, `keywords`, `preorder_available`, `ecom_vendors_id`, `ecom_products_brands_id`, `family_group_id`, COALESCE(discount,0) as discount, CONCAT("/ae/en/product/",slug) AS link, (price_ttc - price_ttc * (LEAST(COALESCE(discount,0) + 0,100) / 100)) AS price, LEAST(COALESCE(discount,0) + 0,100) AS discount, label_en AS label, small_description_en AS small_description, gallery from `ecom_products` where `price_ttc` > 0 and `display` = 1 and `cancelled` = 0 and `family_group_id` in ('6601246dcb9c1', '6679467d64ea5', '6628f527465ce', '6834b468a423a', '6835dff8e011a', '6834bf4166de4', '6835e1c2d70ce', '6835d95c941c4', '6835b47926aa6', '6835bf2192ae3', '6835cb989cb48', '6834ae0b09cf8', '6835db274349c', '6835dc94b087c', '6835b86412033', '6835ca445fee9', '6835cd1bda6bc', '6835de506319b', '6835ba083a003', '6601277dc2c1a', '66012bf10eab2', '66012e2c2d8f9', '667948ce16b98', '6628a11118978') and `ecom_stores_id` = 1 order by `family_group_id` asc, `orders` asc
mysql
(2.08 ms)
select * from `ecom_users_reviews` where `cancelled` = 0 and `approved` = 1
mysql
(1.56 ms)
select count(*) as aggregate from `00_cms_files` where `cancelled` = 0
mysql
(1.5 ms)
select count(*) as aggregate from `00_cms_files` where `cancelled` = 0
mysql
(2.1 ms)
select count(*) as aggregate from `00_cms_files` where `cancelled` = 0
mysql
(1.66 ms)
select count(*) as aggregate from `00_cms_files` where `cancelled` = 0
mysql
(2.05 ms)
select count(*) as aggregate from `00_cms_files` where `cancelled` = 0
mysql
(1.56 ms)
select count(*) as aggregate from `00_cms_files` where `cancelled` = 0
mysql
(1.42 ms)
select count(*) as aggregate from `00_cms_files` where `cancelled` = 0
mysql
(1.65 ms)
select count(*) as aggregate from `00_cms_files` where `cancelled` = 0
mysql
(1.84 ms)
select count(*) as aggregate from `00_cms_files` where `cancelled` = 0
mysql
(1.7 ms)
select count(*) as aggregate from `00_cms_files` where `cancelled` = 0
mysql
(1.87 ms)
select count(*) as aggregate from `00_cms_files` where `cancelled` = 0
mysql
(1.55 ms)
select count(*) as aggregate from `00_cms_files` where `cancelled` = 0
mysql
(1.84 ms)
select count(*) as aggregate from `00_cms_files` where `cancelled` = 0
mysql
(2.38 ms)
select count(*) as aggregate from `00_cms_files` where `cancelled` = 0
mysql
(1.56 ms)
select count(*) as aggregate from `00_cms_files` where `cancelled` = 0
mysql
(1.44 ms)
select count(*) as aggregate from `00_cms_files` where `cancelled` = 0
mysql
(1.35 ms)
select `id`, label_en AS label, group_en AS `group` from `ecom_products_filters` where `id` in ('') and `cancelled` = 0 order by `orders` asc
mysql
(1.47 ms)
select count(*) as aggregate from `00_cms_files` where `cancelled` = 0
mysql
(1.52 ms)
select count(*) as aggregate from `00_cms_files` where `cancelled` = 0
mysql
(1.5 ms)
select count(*) as aggregate from `00_cms_files` where `cancelled` = 0
mysql
(1.41 ms)
select count(*) as aggregate from `00_cms_files` where `cancelled` = 0
mysql
(2.62 ms)
select count(*) as aggregate from `00_cms_files` where `cancelled` = 0
mysql
(3.16 ms)
select count(*) as aggregate from `00_cms_files` where `cancelled` = 0
mysql
(1.42 ms)
select count(*) as aggregate from `00_cms_files` where `cancelled` = 0
mysql
(1.45 ms)
select count(*) as aggregate from `00_cms_files` where `cancelled` = 0
mysql
(1.59 ms)
select count(*) as aggregate from `00_cms_files` where `cancelled` = 0
mysql
(1.5 ms)
select count(*) as aggregate from `00_cms_files` where `cancelled` = 0
mysql
(1.54 ms)
select count(*) as aggregate from `00_cms_files` where `cancelled` = 0
mysql
(1.69 ms)
select count(*) as aggregate from `00_cms_files` where `cancelled` = 0
mysql
(1.52 ms)
select count(*) as aggregate from `00_cms_files` where `cancelled` = 0
mysql
(2.5 ms)
select count(*) as aggregate from `00_cms_files` where `cancelled` = 0
mysql
(1.52 ms)
select count(*) as aggregate from `00_cms_files` where `cancelled` = 0
mysql
(1.61 ms)
select count(*) as aggregate from `00_cms_files` where `cancelled` = 0
mysql
(1.51 ms)
select count(*) as aggregate from `00_cms_files` where `cancelled` = 0
mysql
(1.45 ms)
select count(*) as aggregate from `00_cms_files` where `cancelled` = 0
mysql
(1.83 ms)
select count(*) as aggregate from `00_cms_files` where `cancelled` = 0
mysql
(2.46 ms)
select count(*) as aggregate from `00_cms_files` where `cancelled` = 0
mysql
(1.87 ms)
select count(*) as aggregate from `00_cms_files` where `cancelled` = 0
mysql
(1.75 ms)
select count(*) as aggregate from `00_cms_files` where `cancelled` = 0
mysql
(1.48 ms)
select count(*) as aggregate from `00_cms_files` where `cancelled` = 0
mysql
(2.51 ms)
select count(*) as aggregate from `00_cms_files` where `cancelled` = 0
mysql
(1.65 ms)
select count(*) as aggregate from `00_cms_files` where `cancelled` = 0
mysql
(1.52 ms)
select count(*) as aggregate from `00_cms_files` where `cancelled` = 0
mysql
(2.17 ms)
select count(*) as aggregate from `00_cms_files` where `cancelled` = 0
mysql
(1.61 ms)
select count(*) as aggregate from `00_cms_files` where `cancelled` = 0
mysql
(1.45 ms)
select count(*) as aggregate from `00_cms_files` where `cancelled` = 0
mysql
(1.41 ms)
select count(*) as aggregate from `00_cms_files` where `cancelled` = 0
mysql
(1.49 ms)
select count(*) as aggregate from `00_cms_files` where `cancelled` = 0
mysql
(1.5 ms)
select count(*) as aggregate from `00_cms_files` where `cancelled` = 0
mysql
(1.51 ms)
select count(*) as aggregate from `00_cms_files` where `cancelled` = 0
mysql
(1.72 ms)
select count(*) as aggregate from `00_cms_files` where `cancelled` = 0
mysql
(1.47 ms)
select count(*) as aggregate from `00_cms_files` where `cancelled` = 0
mysql
(1.5 ms)
select count(*) as aggregate from `00_cms_files` where `cancelled` = 0
mysql
(1.49 ms)
select count(*) as aggregate from `00_cms_files` where `cancelled` = 0
mysql
(1.64 ms)
select count(*) as aggregate from `00_cms_files` where `cancelled` = 0
mysql
(1.77 ms)
select count(*) as aggregate from `00_cms_files` where `cancelled` = 0
mysql
(1.59 ms)
select count(*) as aggregate from `00_cms_files` where `cancelled` = 0
mysql
(1.44 ms)
select count(*) as aggregate from `00_cms_files` where `cancelled` = 0
mysql
(1.47 ms)
select count(*) as aggregate from `00_cms_files` where `cancelled` = 0
mysql
(1.59 ms)
select count(*) as aggregate from `00_cms_files` where `cancelled` = 0
mysql
(1.48 ms)
select count(*) as aggregate from `00_cms_files` where `cancelled` = 0