Search

Featured Stores

Sale Products


    (default) 75 queries took 29 ms
    NrQueryErrorAffectedNum. rowsTook (ms)
    1SELECT `Currency`.`id`, `Currency`.`currency_code`, `Currency`.`symbol`, `Currency`.`name`, `Currency`.`description`, `Currency`.`ordering`, `Currency`.`is_default`, `Currency`.`is_active` FROM `preppers_clever1`.`currencies` AS `Currency` WHERE `Currency`.`is_default` = '1' LIMIT 1110
    2SELECT `Session`.`id`, `Session`.`data`, `Session`.`expires`, `Session`.`user_id` FROM `preppers_clever1`.`cake_sessions` AS `Session` WHERE `Session`.`id` = 'oog7e4k5dv1njaiejq9dtftqd1' LIMIT 1000
    3SELECT `Page`.`id`, `Page`.`title`, `Page`.`alias`, `Page`.`content`, `Page`.`permission`, `Page`.`params`, `Page`.`created`, `Page`.`modified`, `Page`.`menu`, `Page`.`icon_class`, `Page`.`weight`, `Page`.`url`, `Page`.`uri`, `Page`.`description`, `Page`.`keywords`, `Page`.`custom`, `Page`.`fragment`, `Page`.`layout`, `Page`.`levels`, `Page`.`provides`, `Page`.`view_count`, `Page`.`type`, `Page`.`search`, `Page`.`theme_id`, `Page`.`core_content_count`, (`I18n__titleTranslation`.`content`) AS `Page__i18n_titleTranslation`, (`I18n__contentTranslation`.`content`) AS `Page__i18n_contentTranslation`, `MyCoreTheme`.`id`, `MyCoreTheme`.`key`, `MyCoreTheme`.`name`, `MyCoreTheme`.`core`, `MyCoreTheme`.`custom_css_enable`, `MyCoreTheme`.`custom_css` FROM `preppers_clever1`.`pages` AS `Page` LEFT JOIN `preppers_clever1`.`themes` AS `MyCoreTheme` ON (`Page`.`theme_id` = `MyCoreTheme`.`id`) INNER JOIN `preppers_clever1`.`i18n` AS `I18n__titleTranslation` ON (`Page`.`id` = `I18n__titleTranslation`.`foreign_key` AND `I18n__titleTranslation`.`model` = 'Page' AND `I18n__titleTranslation`.`field` = 'title' AND `I18n__titleTranslation`.`locale` = 'eng') INNER JOIN `preppers_clever1`.`i18n` AS `I18n__contentTranslation` ON (`Page`.`id` = `I18n__contentTranslation`.`foreign_key` AND `I18n__contentTranslation`.`model` = 'Page' AND `I18n__contentTranslation`.`field` = 'content' AND `I18n__contentTranslation`.`locale` = 'eng') WHERE `Page`.`uri` = 'stores.index' ORDER BY `Page`.`weight` asc LIMIT 1113
    4SELECT `CoreContent`.`id`, `CoreContent`.`page_id`, `CoreContent`.`type`, `CoreContent`.`name`, `CoreContent`.`component`, `CoreContent`.`parent_id`, `CoreContent`.`order`, `CoreContent`.`params`, `CoreContent`.`attribs`, `CoreContent`.`lft`, `CoreContent`.`rght`, `CoreContent`.`column`, `CoreContent`.`core_block_id`, `CoreContent`.`core_content_count`, `CoreContent`.`invisible`, `CoreContent`.`core_block_title`, `CoreContent`.`plugin`, `CoreContent`.`role_access` FROM `preppers_clever1`.`core_contents` AS `CoreContent` WHERE `CoreContent`.`page_id` = (150)661
    5SELECT `MyCorePage`.`id`, `MyCorePage`.`title`, `MyCorePage`.`alias`, `MyCorePage`.`content`, `MyCorePage`.`permission`, `MyCorePage`.`params`, `MyCorePage`.`created`, `MyCorePage`.`modified`, `MyCorePage`.`menu`, `MyCorePage`.`icon_class`, `MyCorePage`.`weight`, `MyCorePage`.`url`, `MyCorePage`.`uri`, `MyCorePage`.`description`, `MyCorePage`.`keywords`, `MyCorePage`.`custom`, `MyCorePage`.`fragment`, `MyCorePage`.`layout`, `MyCorePage`.`levels`, `MyCorePage`.`provides`, `MyCorePage`.`view_count`, `MyCorePage`.`type`, `MyCorePage`.`search`, `MyCorePage`.`theme_id`, `MyCorePage`.`core_content_count` FROM `preppers_clever1`.`pages` AS `MyCorePage` WHERE `MyCorePage`.`id` = 150111
    6SELECT `MyCorePage`.`id`, `MyCorePage`.`title`, `MyCorePage`.`alias`, `MyCorePage`.`content`, `MyCorePage`.`permission`, `MyCorePage`.`params`, `MyCorePage`.`created`, `MyCorePage`.`modified`, `MyCorePage`.`menu`, `MyCorePage`.`icon_class`, `MyCorePage`.`weight`, `MyCorePage`.`url`, `MyCorePage`.`uri`, `MyCorePage`.`description`, `MyCorePage`.`keywords`, `MyCorePage`.`custom`, `MyCorePage`.`fragment`, `MyCorePage`.`layout`, `MyCorePage`.`levels`, `MyCorePage`.`provides`, `MyCorePage`.`view_count`, `MyCorePage`.`type`, `MyCorePage`.`search`, `MyCorePage`.`theme_id`, `MyCorePage`.`core_content_count` FROM `preppers_clever1`.`pages` AS `MyCorePage` WHERE `MyCorePage`.`id` = 150112
    7SELECT `MyCorePage`.`id`, `MyCorePage`.`title`, `MyCorePage`.`alias`, `MyCorePage`.`content`, `MyCorePage`.`permission`, `MyCorePage`.`params`, `MyCorePage`.`created`, `MyCorePage`.`modified`, `MyCorePage`.`menu`, `MyCorePage`.`icon_class`, `MyCorePage`.`weight`, `MyCorePage`.`url`, `MyCorePage`.`uri`, `MyCorePage`.`description`, `MyCorePage`.`keywords`, `MyCorePage`.`custom`, `MyCorePage`.`fragment`, `MyCorePage`.`layout`, `MyCorePage`.`levels`, `MyCorePage`.`provides`, `MyCorePage`.`view_count`, `MyCorePage`.`type`, `MyCorePage`.`search`, `MyCorePage`.`theme_id`, `MyCorePage`.`core_content_count` FROM `preppers_clever1`.`pages` AS `MyCorePage` WHERE `MyCorePage`.`id` = 150110
    8SELECT `MyCorePage`.`id`, `MyCorePage`.`title`, `MyCorePage`.`alias`, `MyCorePage`.`content`, `MyCorePage`.`permission`, `MyCorePage`.`params`, `MyCorePage`.`created`, `MyCorePage`.`modified`, `MyCorePage`.`menu`, `MyCorePage`.`icon_class`, `MyCorePage`.`weight`, `MyCorePage`.`url`, `MyCorePage`.`uri`, `MyCorePage`.`description`, `MyCorePage`.`keywords`, `MyCorePage`.`custom`, `MyCorePage`.`fragment`, `MyCorePage`.`layout`, `MyCorePage`.`levels`, `MyCorePage`.`provides`, `MyCorePage`.`view_count`, `MyCorePage`.`type`, `MyCorePage`.`search`, `MyCorePage`.`theme_id`, `MyCorePage`.`core_content_count` FROM `preppers_clever1`.`pages` AS `MyCorePage` WHERE `MyCorePage`.`id` = 150110
    9SELECT `MyCorePage`.`id`, `MyCorePage`.`title`, `MyCorePage`.`alias`, `MyCorePage`.`content`, `MyCorePage`.`permission`, `MyCorePage`.`params`, `MyCorePage`.`created`, `MyCorePage`.`modified`, `MyCorePage`.`menu`, `MyCorePage`.`icon_class`, `MyCorePage`.`weight`, `MyCorePage`.`url`, `MyCorePage`.`uri`, `MyCorePage`.`description`, `MyCorePage`.`keywords`, `MyCorePage`.`custom`, `MyCorePage`.`fragment`, `MyCorePage`.`layout`, `MyCorePage`.`levels`, `MyCorePage`.`provides`, `MyCorePage`.`view_count`, `MyCorePage`.`type`, `MyCorePage`.`search`, `MyCorePage`.`theme_id`, `MyCorePage`.`core_content_count` FROM `preppers_clever1`.`pages` AS `MyCorePage` WHERE `MyCorePage`.`id` = 150110
    10SELECT `MyCorePage`.`id`, `MyCorePage`.`title`, `MyCorePage`.`alias`, `MyCorePage`.`content`, `MyCorePage`.`permission`, `MyCorePage`.`params`, `MyCorePage`.`created`, `MyCorePage`.`modified`, `MyCorePage`.`menu`, `MyCorePage`.`icon_class`, `MyCorePage`.`weight`, `MyCorePage`.`url`, `MyCorePage`.`uri`, `MyCorePage`.`description`, `MyCorePage`.`keywords`, `MyCorePage`.`custom`, `MyCorePage`.`fragment`, `MyCorePage`.`layout`, `MyCorePage`.`levels`, `MyCorePage`.`provides`, `MyCorePage`.`view_count`, `MyCorePage`.`type`, `MyCorePage`.`search`, `MyCorePage`.`theme_id`, `MyCorePage`.`core_content_count` FROM `preppers_clever1`.`pages` AS `MyCorePage` WHERE `MyCorePage`.`id` = 150110
    11SELECT `Parent`.`id`, `Parent`.`page_id`, `Parent`.`type`, `Parent`.`name`, `Parent`.`component`, `Parent`.`parent_id`, `Parent`.`order`, `Parent`.`params`, `Parent`.`attribs`, `Parent`.`lft`, `Parent`.`rght`, `Parent`.`column`, `Parent`.`core_block_id`, `Parent`.`core_content_count`, `Parent`.`invisible`, `Parent`.`core_block_title`, `Parent`.`plugin`, `Parent`.`role_access` FROM `preppers_clever1`.`core_contents` AS `Parent` WHERE `Parent`.`id` = 1000110
    12SELECT `Parent`.`id`, `Parent`.`page_id`, `Parent`.`type`, `Parent`.`name`, `Parent`.`component`, `Parent`.`parent_id`, `Parent`.`order`, `Parent`.`params`, `Parent`.`attribs`, `Parent`.`lft`, `Parent`.`rght`, `Parent`.`column`, `Parent`.`core_block_id`, `Parent`.`core_content_count`, `Parent`.`invisible`, `Parent`.`core_block_title`, `Parent`.`plugin`, `Parent`.`role_access` FROM `preppers_clever1`.`core_contents` AS `Parent` WHERE `Parent`.`id` = 1000110
    13SELECT `Parent`.`id`, `Parent`.`page_id`, `Parent`.`type`, `Parent`.`name`, `Parent`.`component`, `Parent`.`parent_id`, `Parent`.`order`, `Parent`.`params`, `Parent`.`attribs`, `Parent`.`lft`, `Parent`.`rght`, `Parent`.`column`, `Parent`.`core_block_id`, `Parent`.`core_content_count`, `Parent`.`invisible`, `Parent`.`core_block_title`, `Parent`.`plugin`, `Parent`.`role_access` FROM `preppers_clever1`.`core_contents` AS `Parent` WHERE `Parent`.`id` = 1000110
    14SELECT `Parent`.`id`, `Parent`.`page_id`, `Parent`.`type`, `Parent`.`name`, `Parent`.`component`, `Parent`.`parent_id`, `Parent`.`order`, `Parent`.`params`, `Parent`.`attribs`, `Parent`.`lft`, `Parent`.`rght`, `Parent`.`column`, `Parent`.`core_block_id`, `Parent`.`core_content_count`, `Parent`.`invisible`, `Parent`.`core_block_title`, `Parent`.`plugin`, `Parent`.`role_access` FROM `preppers_clever1`.`core_contents` AS `Parent` WHERE `Parent`.`id` = 1000110
    15SELECT `Parent`.`id`, `Parent`.`page_id`, `Parent`.`type`, `Parent`.`name`, `Parent`.`component`, `Parent`.`parent_id`, `Parent`.`order`, `Parent`.`params`, `Parent`.`attribs`, `Parent`.`lft`, `Parent`.`rght`, `Parent`.`column`, `Parent`.`core_block_id`, `Parent`.`core_content_count`, `Parent`.`invisible`, `Parent`.`core_block_title`, `Parent`.`plugin`, `Parent`.`role_access` FROM `preppers_clever1`.`core_contents` AS `Parent` WHERE `Parent`.`id` = 1000110
    16SELECT `Children`.`id`, `Children`.`page_id`, `Children`.`type`, `Children`.`name`, `Children`.`component`, `Children`.`parent_id`, `Children`.`order`, `Children`.`params`, `Children`.`attribs`, `Children`.`lft`, `Children`.`rght`, `Children`.`column`, `Children`.`core_block_id`, `Children`.`core_content_count`, `Children`.`invisible`, `Children`.`core_block_title`, `Children`.`plugin`, `Children`.`role_access` FROM `preppers_clever1`.`core_contents` AS `Children` WHERE `Children`.`parent_id` IN (1007, 1000, 1002, 1003, 1009, 1004)550
    17SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content` FROM `preppers_clever1`.`i18n` AS `nameTranslation` WHERE `model` = 'CoreContent' AND `field` = 'core_block_title' AND `nameTranslation`.`foreign_key` IN (1007, 1000, 1002, 1003, 1009, 1004) ORDER BY `id` ASC660
    18SELECT `titleTranslation`.`id`, `titleTranslation`.`locale`, `titleTranslation`.`model`, `titleTranslation`.`foreign_key`, `titleTranslation`.`field`, `titleTranslation`.`content` FROM `preppers_clever1`.`i18n` AS `titleTranslation` WHERE `model` = 'Page' AND `field` = 'title' AND `titleTranslation`.`foreign_key` = (150) ORDER BY `id` ASC110
    19SELECT `contentTranslation`.`id`, `contentTranslation`.`locale`, `contentTranslation`.`model`, `contentTranslation`.`foreign_key`, `contentTranslation`.`field`, `contentTranslation`.`content` FROM `preppers_clever1`.`i18n` AS `contentTranslation` WHERE `model` = 'Page' AND `field` = 'content' AND `contentTranslation`.`foreign_key` = (150) ORDER BY `id` ASC110
    20SELECT `Plugin`.`enabled` FROM `preppers_clever1`.`plugins` AS `Plugin` WHERE `Plugin`.`key` = 'Storage' ORDER BY `Plugin`.`weight` asc LIMIT 1110
    21SELECT `Currency`.`id`, `Currency`.`currency_code`, `Currency`.`symbol`, `Currency`.`name`, `Currency`.`description`, `Currency`.`ordering`, `Currency`.`is_default`, `Currency`.`is_active` FROM `preppers_clever1`.`currencies` AS `Currency` WHERE `Currency`.`is_default` = '1' LIMIT 1110
    22SELECT COUNT(*) AS `count` FROM `preppers_clever1`.`stores` AS `Store` WHERE `Store`.`id` = 3110
    23SELECT `Store`.`id`, `Store`.`user_id`, `Store`.`name`, `Store`.`image`, `Store`.`email`, `Store`.`address`, `Store`.`phone`, `Store`.`paypal_api_username`, `Store`.`paypal_api_password`, `Store`.`paypal_api_signature`, `Store`.`paypal_sandbox`, `Store`.`enable_paypal`, `Store`.`like_count`, `Store`.`dislike_count`, `Store`.`comment_count`, `Store`.`share_count`, `Store`.`created`, `Store`.`updated`, `Store`.`privacy`, `Store`.`enable`, `Store`.`store_price`, `Store`.`store_transaction_currency`, `Store`.`store_transaction_id`, `Store`.`paypal_email`, `Store`.`payments`, `Store`.`paypal_first_name`, `Store`.`paypal_last_name`, `Store`.`featured`, `Store`.`feature_expiration_date`, `Store`.`sent_expiration_email`, `User`.`id`, `User`.`name`, `User`.`email`, `User`.`password`, `User`.`salt`, `User`.`role_id`, `User`.`avatar`, `User`.`photo`, `User`.`created`, `User`.`last_login`, `User`.`photo_count`, `User`.`friend_count`, `User`.`notification_count`, `User`.`friend_request_count`, `User`.`blog_count`, `User`.`topic_count`, `User`.`group_count`, `User`.`event_count`, `User`.`conversation_user_count`, `User`.`video_count`, `User`.`gender`, `User`.`birthday`, `User`.`active`, `User`.`confirmed`, `User`.`code`, `User`.`notification_email`, `User`.`timezone`, `User`.`ip_address`, `User`.`privacy`, `User`.`username`, `User`.`about`, `User`.`featured`, `User`.`lang`, `User`.`hide_online`, `User`.`cover`, `User`.`approved`, `User`.`is_social`, `User`.`has_active_subscription`, `User`.`receive_message_from_non_friend`, `User`.`send_email_when_send_message`, `User`.`request_friend_email`, `User`.`notification_setting`, `User`.`profile_type_id`, `User`.`package_select` FROM `preppers_clever1`.`stores` AS `Store` LEFT JOIN `preppers_clever1`.`users` AS `User` ON (`Store`.`user_id` = `User`.`id`) WHERE `Store`.`id` = 3 LIMIT 1110
    24SELECT `StoreProduct`.`id`, `StoreProduct`.`store_id`, `StoreProduct`.`user_id`, `StoreProduct`.`store_category_id`, `StoreProduct`.`producer_id`, `StoreProduct`.`product_code`, `StoreProduct`.`name`, `StoreProduct`.`alias`, `StoreProduct`.`enable`, `StoreProduct`.`approve`, `StoreProduct`.`ordering`, `StoreProduct`.`updated`, `StoreProduct`.`created`, `StoreProduct`.`price`, `StoreProduct`.`promotion_price`, `StoreProduct`.`include_tax`, `StoreProduct`.`allow_promotion`, `StoreProduct`.`promotion_start`, `StoreProduct`.`promotion_end`, `StoreProduct`.`is_limit_amount`, `StoreProduct`.`limit_buy_min`, `StoreProduct`.`limit_buy_max`, `StoreProduct`.`shipping_id`, `StoreProduct`.`member_only`, `StoreProduct`.`out_of_stock`, `StoreProduct`.`allow_share`, `StoreProduct`.`allow_contact_form`, `StoreProduct`.`is_social`, `StoreProduct`.`allow_comment`, `StoreProduct`.`is_related`, `StoreProduct`.`is_qr`, `StoreProduct`.`is_call`, `StoreProduct`.`is_contact`, `StoreProduct`.`is_hot`, `StoreProduct`.`is_new`, `StoreProduct`.`views`, `StoreProduct`.`warranty`, `StoreProduct`.`brief`, `StoreProduct`.`article`, `StoreProduct`.`promotion_content`, `StoreProduct`.`rating`, `StoreProduct`.`rating_count`, `StoreProduct`.`like_count`, `StoreProduct`.`dislike_count`, `StoreProduct`.`comment_count`, `StoreProduct`.`share_count`, `StoreProduct`.`meta_title`, `StoreProduct`.`meta_keyword`, `StoreProduct`.`meta_description`, `StoreProduct`.`show_quanity`, `StoreProduct`.`featured`, `StoreProduct`.`weight`, `StoreProduct`.`feature_expiration_date`, `StoreProduct`.`sent_expiration_email`, `StoreProduct`.`product_type`, `StoreProduct`.`digital_file`, `StoreProduct`.`product_link`, `StoreProduct`.`video`, `StoreProduct`.`allow_review`, `Store`.`id`, `Store`.`user_id`, `Store`.`name`, `Store`.`image`, `Store`.`email`, `Store`.`address`, `Store`.`phone`, `Store`.`paypal_api_username`, `Store`.`paypal_api_password`, `Store`.`paypal_api_signature`, `Store`.`paypal_sandbox`, `Store`.`enable_paypal`, `Store`.`like_count`, `Store`.`dislike_count`, `Store`.`comment_count`, `Store`.`share_count`, `Store`.`created`, `Store`.`updated`, `Store`.`privacy`, `Store`.`enable`, `Store`.`store_price`, `Store`.`store_transaction_currency`, `Store`.`store_transaction_id`, `Store`.`paypal_email`, `Store`.`payments`, `Store`.`paypal_first_name`, `Store`.`paypal_last_name`, `Store`.`featured`, `Store`.`feature_expiration_date`, `Store`.`sent_expiration_email`, `User`.`id`, `User`.`name`, `User`.`email`, `User`.`password`, `User`.`salt`, `User`.`role_id`, `User`.`avatar`, `User`.`photo`, `User`.`created`, `User`.`last_login`, `User`.`photo_count`, `User`.`friend_count`, `User`.`notification_count`, `User`.`friend_request_count`, `User`.`blog_count`, `User`.`topic_count`, `User`.`group_count`, `User`.`event_count`, `User`.`conversation_user_count`, `User`.`video_count`, `User`.`gender`, `User`.`birthday`, `User`.`active`, `User`.`confirmed`, `User`.`code`, `User`.`notification_email`, `User`.`timezone`, `User`.`ip_address`, `User`.`privacy`, `User`.`username`, `User`.`about`, `User`.`featured`, `User`.`lang`, `User`.`hide_online`, `User`.`cover`, `User`.`approved`, `User`.`is_social`, `User`.`has_active_subscription`, `User`.`receive_message_from_non_friend`, `User`.`send_email_when_send_message`, `User`.`request_friend_email`, `User`.`notification_setting`, `User`.`profile_type_id`, `User`.`package_select`, `StoreProducer`.`id`, `StoreProducer`.`store_id`, `StoreProducer`.`name`, `StoreProducer`.`enable`, `StoreProducer`.`ordering`, `StoreProducer`.`updated`, `StoreProducer`.`created`, `StoreProducer`.`phone`, `StoreProducer`.`email`, `StoreProducer`.`address` FROM `preppers_clever1`.`store_products` AS `StoreProduct` LEFT JOIN `preppers_clever1`.`stores` AS `Store` ON (`StoreProduct`.`store_id` = `Store`.`id`) LEFT JOIN `preppers_clever1`.`users` AS `User` ON (`StoreProduct`.`user_id` = `User`.`id`) LEFT JOIN `preppers_clever1`.`store_producers` AS `StoreProducer` ON (`StoreProduct`.`producer_id` = `StoreProducer`.`id` AND `StoreProducer`.`enable` = '1') WHERE `StoreProduct`.`enable` = '1' AND `StoreProduct`.`approve` = '1' AND `StoreProduct`.`featured` = '1' AND `Store`.`enable` = '1' ORDER BY `StoreProduct`.`id` DESC LIMIT 10220
    25SELECT `StoreProductImage`.`id`, `StoreProductImage`.`product_id`, `StoreProductImage`.`filename`, `StoreProductImage`.`path`, `StoreProductImage`.`enable`, `StoreProductImage`.`ordering`, `StoreProductImage`.`updated`, `StoreProductImage`.`created`, `StoreProductImage`.`is_main` FROM `preppers_clever1`.`store_product_images` AS `StoreProductImage` WHERE `StoreProductImage`.`product_id` IN (11, 10)440
    26SELECT COUNT(*) AS `count` FROM `preppers_clever1`.`store_product_wishlists` AS `StoreProductWishlist` WHERE `user_id` = '' AND `product_id` = 11110
    27SELECT COUNT(*) AS `count` FROM `preppers_clever1`.`store_product_attributes` AS `StoreProductAttribute` WHERE `StoreProductAttribute`.`product_id` = 11 AND `StoreProductAttribute`.`force_to_buy` = '1'110
    28SELECT COUNT(*) AS `count` FROM `preppers_clever1`.`likes` AS `Like` WHERE `Like`.`user_id` = 0 AND `Like`.`target_id` = 11 AND `Like`.`type` = 'Store_Store_Product'110
    29SELECT COUNT(*) AS `count` FROM `preppers_clever1`.`store_product_wishlists` AS `StoreProductWishlist` WHERE `user_id` = '' AND `product_id` = 10110
    30SELECT COUNT(*) AS `count` FROM `preppers_clever1`.`store_product_attributes` AS `StoreProductAttribute` WHERE `StoreProductAttribute`.`product_id` = 10 AND `StoreProductAttribute`.`force_to_buy` = '1'110
    31SELECT COUNT(*) AS `count` FROM `preppers_clever1`.`likes` AS `Like` WHERE `Like`.`user_id` = 0 AND `Like`.`target_id` = 10 AND `Like`.`type` = 'Store_Store_Product'110
    32SELECT `Currency`.`id`, `Currency`.`currency_code`, `Currency`.`symbol`, `Currency`.`name`, `Currency`.`description`, `Currency`.`ordering`, `Currency`.`is_default`, `Currency`.`is_active` FROM `preppers_clever1`.`currencies` AS `Currency` WHERE `Currency`.`is_default` = '1' LIMIT 1111
    33SELECT `StoreProduct`.`id`, `StoreProduct`.`store_id`, `StoreProduct`.`user_id`, `StoreProduct`.`store_category_id`, `StoreProduct`.`producer_id`, `StoreProduct`.`product_code`, `StoreProduct`.`name`, `StoreProduct`.`alias`, `StoreProduct`.`enable`, `StoreProduct`.`approve`, `StoreProduct`.`ordering`, `StoreProduct`.`updated`, `StoreProduct`.`created`, `StoreProduct`.`price`, `StoreProduct`.`promotion_price`, `StoreProduct`.`include_tax`, `StoreProduct`.`allow_promotion`, `StoreProduct`.`promotion_start`, `StoreProduct`.`promotion_end`, `StoreProduct`.`is_limit_amount`, `StoreProduct`.`limit_buy_min`, `StoreProduct`.`limit_buy_max`, `StoreProduct`.`shipping_id`, `StoreProduct`.`member_only`, `StoreProduct`.`out_of_stock`, `StoreProduct`.`allow_share`, `StoreProduct`.`allow_contact_form`, `StoreProduct`.`is_social`, `StoreProduct`.`allow_comment`, `StoreProduct`.`is_related`, `StoreProduct`.`is_qr`, `StoreProduct`.`is_call`, `StoreProduct`.`is_contact`, `StoreProduct`.`is_hot`, `StoreProduct`.`is_new`, `StoreProduct`.`views`, `StoreProduct`.`warranty`, `StoreProduct`.`brief`, `StoreProduct`.`article`, `StoreProduct`.`promotion_content`, `StoreProduct`.`rating`, `StoreProduct`.`rating_count`, `StoreProduct`.`like_count`, `StoreProduct`.`dislike_count`, `StoreProduct`.`comment_count`, `StoreProduct`.`share_count`, `StoreProduct`.`meta_title`, `StoreProduct`.`meta_keyword`, `StoreProduct`.`meta_description`, `StoreProduct`.`show_quanity`, `StoreProduct`.`featured`, `StoreProduct`.`weight`, `StoreProduct`.`feature_expiration_date`, `StoreProduct`.`sent_expiration_email`, `StoreProduct`.`product_type`, `StoreProduct`.`digital_file`, `StoreProduct`.`product_link`, `StoreProduct`.`video`, `StoreProduct`.`allow_review`, `Store`.`id`, `Store`.`user_id`, `Store`.`name`, `Store`.`image`, `Store`.`email`, `Store`.`address`, `Store`.`phone`, `Store`.`paypal_api_username`, `Store`.`paypal_api_password`, `Store`.`paypal_api_signature`, `Store`.`paypal_sandbox`, `Store`.`enable_paypal`, `Store`.`like_count`, `Store`.`dislike_count`, `Store`.`comment_count`, `Store`.`share_count`, `Store`.`created`, `Store`.`updated`, `Store`.`privacy`, `Store`.`enable`, `Store`.`store_price`, `Store`.`store_transaction_currency`, `Store`.`store_transaction_id`, `Store`.`paypal_email`, `Store`.`payments`, `Store`.`paypal_first_name`, `Store`.`paypal_last_name`, `Store`.`featured`, `Store`.`feature_expiration_date`, `Store`.`sent_expiration_email`, `User`.`id`, `User`.`name`, `User`.`email`, `User`.`password`, `User`.`salt`, `User`.`role_id`, `User`.`avatar`, `User`.`photo`, `User`.`created`, `User`.`last_login`, `User`.`photo_count`, `User`.`friend_count`, `User`.`notification_count`, `User`.`friend_request_count`, `User`.`blog_count`, `User`.`topic_count`, `User`.`group_count`, `User`.`event_count`, `User`.`conversation_user_count`, `User`.`video_count`, `User`.`gender`, `User`.`birthday`, `User`.`active`, `User`.`confirmed`, `User`.`code`, `User`.`notification_email`, `User`.`timezone`, `User`.`ip_address`, `User`.`privacy`, `User`.`username`, `User`.`about`, `User`.`featured`, `User`.`lang`, `User`.`hide_online`, `User`.`cover`, `User`.`approved`, `User`.`is_social`, `User`.`has_active_subscription`, `User`.`receive_message_from_non_friend`, `User`.`send_email_when_send_message`, `User`.`request_friend_email`, `User`.`notification_setting`, `User`.`profile_type_id`, `User`.`package_select`, `StoreProducer`.`id`, `StoreProducer`.`store_id`, `StoreProducer`.`name`, `StoreProducer`.`enable`, `StoreProducer`.`ordering`, `StoreProducer`.`updated`, `StoreProducer`.`created`, `StoreProducer`.`phone`, `StoreProducer`.`email`, `StoreProducer`.`address` FROM `preppers_clever1`.`store_products` AS `StoreProduct` LEFT JOIN `preppers_clever1`.`stores` AS `Store` ON (`StoreProduct`.`store_id` = `Store`.`id`) LEFT JOIN `preppers_clever1`.`users` AS `User` ON (`StoreProduct`.`user_id` = `User`.`id`) LEFT JOIN `preppers_clever1`.`store_producers` AS `StoreProducer` ON (`StoreProduct`.`producer_id` = `StoreProducer`.`id` AND `StoreProducer`.`enable` = '1') WHERE `StoreProduct`.`enable` = '1' AND `StoreProduct`.`approve` = '1' AND `Store`.`enable` = '1' ORDER BY `StoreProduct`.`views` DESC LIMIT 5555
    34SELECT `StoreProductImage`.`id`, `StoreProductImage`.`product_id`, `StoreProductImage`.`filename`, `StoreProductImage`.`path`, `StoreProductImage`.`enable`, `StoreProductImage`.`ordering`, `StoreProductImage`.`updated`, `StoreProductImage`.`created`, `StoreProductImage`.`is_main` FROM `preppers_clever1`.`store_product_images` AS `StoreProductImage` WHERE `StoreProductImage`.`product_id` IN (3, 4, 5, 6, 7)550
    35SELECT COUNT(*) AS `count` FROM `preppers_clever1`.`store_product_wishlists` AS `StoreProductWishlist` WHERE `user_id` = '' AND `product_id` = 3110
    36SELECT COUNT(*) AS `count` FROM `preppers_clever1`.`store_product_attributes` AS `StoreProductAttribute` WHERE `StoreProductAttribute`.`product_id` = 3 AND `StoreProductAttribute`.`force_to_buy` = '1'112
    37SELECT COUNT(*) AS `count` FROM `preppers_clever1`.`likes` AS `Like` WHERE `Like`.`user_id` = 0 AND `Like`.`target_id` = 3 AND `Like`.`type` = 'Store_Store_Product'110
    38SELECT COUNT(*) AS `count` FROM `preppers_clever1`.`store_product_wishlists` AS `StoreProductWishlist` WHERE `user_id` = '' AND `product_id` = 4110
    39SELECT COUNT(*) AS `count` FROM `preppers_clever1`.`store_product_attributes` AS `StoreProductAttribute` WHERE `StoreProductAttribute`.`product_id` = 4 AND `StoreProductAttribute`.`force_to_buy` = '1'111
    40SELECT COUNT(*) AS `count` FROM `preppers_clever1`.`likes` AS `Like` WHERE `Like`.`user_id` = 0 AND `Like`.`target_id` = 4 AND `Like`.`type` = 'Store_Store_Product'110
    41SELECT COUNT(*) AS `count` FROM `preppers_clever1`.`store_product_wishlists` AS `StoreProductWishlist` WHERE `user_id` = '' AND `product_id` = 5110
    42SELECT COUNT(*) AS `count` FROM `preppers_clever1`.`store_product_attributes` AS `StoreProductAttribute` WHERE `StoreProductAttribute`.`product_id` = 5 AND `StoreProductAttribute`.`force_to_buy` = '1'110
    43SELECT COUNT(*) AS `count` FROM `preppers_clever1`.`likes` AS `Like` WHERE `Like`.`user_id` = 0 AND `Like`.`target_id` = 5 AND `Like`.`type` = 'Store_Store_Product'110
    44SELECT COUNT(*) AS `count` FROM `preppers_clever1`.`store_product_wishlists` AS `StoreProductWishlist` WHERE `user_id` = '' AND `product_id` = 6112
    45SELECT COUNT(*) AS `count` FROM `preppers_clever1`.`store_product_attributes` AS `StoreProductAttribute` WHERE `StoreProductAttribute`.`product_id` = 6 AND `StoreProductAttribute`.`force_to_buy` = '1'111
    46SELECT COUNT(*) AS `count` FROM `preppers_clever1`.`likes` AS `Like` WHERE `Like`.`user_id` = 0 AND `Like`.`target_id` = 6 AND `Like`.`type` = 'Store_Store_Product'110
    47SELECT COUNT(*) AS `count` FROM `preppers_clever1`.`store_product_wishlists` AS `StoreProductWishlist` WHERE `user_id` = '' AND `product_id` = 7111
    48SELECT COUNT(*) AS `count` FROM `preppers_clever1`.`store_product_attributes` AS `StoreProductAttribute` WHERE `StoreProductAttribute`.`product_id` = 7 AND `StoreProductAttribute`.`force_to_buy` = '1'112
    49SELECT COUNT(*) AS `count` FROM `preppers_clever1`.`likes` AS `Like` WHERE `Like`.`user_id` = 0 AND `Like`.`target_id` = 7 AND `Like`.`type` = 'Store_Store_Product'110
    50SELECT `Currency`.`id`, `Currency`.`currency_code`, `Currency`.`symbol`, `Currency`.`name`, `Currency`.`description`, `Currency`.`ordering`, `Currency`.`is_default`, `Currency`.`is_active` FROM `preppers_clever1`.`currencies` AS `Currency` WHERE `Currency`.`is_default` = '1' LIMIT 1110
    51SELECT `Store`.`id`, `Store`.`user_id`, `Store`.`name`, `Store`.`image`, `Store`.`email`, `Store`.`address`, `Store`.`phone`, `Store`.`paypal_api_username`, `Store`.`paypal_api_password`, `Store`.`paypal_api_signature`, `Store`.`paypal_sandbox`, `Store`.`enable_paypal`, `Store`.`like_count`, `Store`.`dislike_count`, `Store`.`comment_count`, `Store`.`share_count`, `Store`.`created`, `Store`.`updated`, `Store`.`privacy`, `Store`.`enable`, `Store`.`store_price`, `Store`.`store_transaction_currency`, `Store`.`store_transaction_id`, `Store`.`paypal_email`, `Store`.`payments`, `Store`.`paypal_first_name`, `Store`.`paypal_last_name`, `Store`.`featured`, `Store`.`feature_expiration_date`, `Store`.`sent_expiration_email`, `User`.`id`, `User`.`name`, `User`.`email`, `User`.`password`, `User`.`salt`, `User`.`role_id`, `User`.`avatar`, `User`.`photo`, `User`.`created`, `User`.`last_login`, `User`.`photo_count`, `User`.`friend_count`, `User`.`notification_count`, `User`.`friend_request_count`, `User`.`blog_count`, `User`.`topic_count`, `User`.`group_count`, `User`.`event_count`, `User`.`conversation_user_count`, `User`.`video_count`, `User`.`gender`, `User`.`birthday`, `User`.`active`, `User`.`confirmed`, `User`.`code`, `User`.`notification_email`, `User`.`timezone`, `User`.`ip_address`, `User`.`privacy`, `User`.`username`, `User`.`about`, `User`.`featured`, `User`.`lang`, `User`.`hide_online`, `User`.`cover`, `User`.`approved`, `User`.`is_social`, `User`.`has_active_subscription`, `User`.`receive_message_from_non_friend`, `User`.`send_email_when_send_message`, `User`.`request_friend_email`, `User`.`notification_setting`, `User`.`profile_type_id`, `User`.`package_select` FROM `preppers_clever1`.`stores` AS `Store` LEFT JOIN `preppers_clever1`.`users` AS `User` ON (`Store`.`user_id` = `User`.`id`) WHERE `Store`.`featured` = '1' AND `Store`.`enable` = '1' ORDER BY `Store`.`id` DESC LIMIT 5110
    52SELECT `StoreProduct`.`id`, `StoreProduct`.`store_id`, `StoreProduct`.`user_id`, `StoreProduct`.`store_category_id`, `StoreProduct`.`producer_id`, `StoreProduct`.`product_code`, `StoreProduct`.`name`, `StoreProduct`.`alias`, `StoreProduct`.`enable`, `StoreProduct`.`approve`, `StoreProduct`.`ordering`, `StoreProduct`.`updated`, `StoreProduct`.`created`, `StoreProduct`.`price`, `StoreProduct`.`promotion_price`, `StoreProduct`.`include_tax`, `StoreProduct`.`allow_promotion`, `StoreProduct`.`promotion_start`, `StoreProduct`.`promotion_end`, `StoreProduct`.`is_limit_amount`, `StoreProduct`.`limit_buy_min`, `StoreProduct`.`limit_buy_max`, `StoreProduct`.`shipping_id`, `StoreProduct`.`member_only`, `StoreProduct`.`out_of_stock`, `StoreProduct`.`allow_share`, `StoreProduct`.`allow_contact_form`, `StoreProduct`.`is_social`, `StoreProduct`.`allow_comment`, `StoreProduct`.`is_related`, `StoreProduct`.`is_qr`, `StoreProduct`.`is_call`, `StoreProduct`.`is_contact`, `StoreProduct`.`is_hot`, `StoreProduct`.`is_new`, `StoreProduct`.`views`, `StoreProduct`.`warranty`, `StoreProduct`.`brief`, `StoreProduct`.`article`, `StoreProduct`.`promotion_content`, `StoreProduct`.`rating`, `StoreProduct`.`rating_count`, `StoreProduct`.`like_count`, `StoreProduct`.`dislike_count`, `StoreProduct`.`comment_count`, `StoreProduct`.`share_count`, `StoreProduct`.`meta_title`, `StoreProduct`.`meta_keyword`, `StoreProduct`.`meta_description`, `StoreProduct`.`show_quanity`, `StoreProduct`.`featured`, `StoreProduct`.`weight`, `StoreProduct`.`feature_expiration_date`, `StoreProduct`.`sent_expiration_email`, `StoreProduct`.`product_type`, `StoreProduct`.`digital_file`, `StoreProduct`.`product_link`, `StoreProduct`.`video`, `StoreProduct`.`allow_review`, `Store`.`id`, `Store`.`user_id`, `Store`.`name`, `Store`.`image`, `Store`.`email`, `Store`.`address`, `Store`.`phone`, `Store`.`paypal_api_username`, `Store`.`paypal_api_password`, `Store`.`paypal_api_signature`, `Store`.`paypal_sandbox`, `Store`.`enable_paypal`, `Store`.`like_count`, `Store`.`dislike_count`, `Store`.`comment_count`, `Store`.`share_count`, `Store`.`created`, `Store`.`updated`, `Store`.`privacy`, `Store`.`enable`, `Store`.`store_price`, `Store`.`store_transaction_currency`, `Store`.`store_transaction_id`, `Store`.`paypal_email`, `Store`.`payments`, `Store`.`paypal_first_name`, `Store`.`paypal_last_name`, `Store`.`featured`, `Store`.`feature_expiration_date`, `Store`.`sent_expiration_email`, `User`.`id`, `User`.`name`, `User`.`email`, `User`.`password`, `User`.`salt`, `User`.`role_id`, `User`.`avatar`, `User`.`photo`, `User`.`created`, `User`.`last_login`, `User`.`photo_count`, `User`.`friend_count`, `User`.`notification_count`, `User`.`friend_request_count`, `User`.`blog_count`, `User`.`topic_count`, `User`.`group_count`, `User`.`event_count`, `User`.`conversation_user_count`, `User`.`video_count`, `User`.`gender`, `User`.`birthday`, `User`.`active`, `User`.`confirmed`, `User`.`code`, `User`.`notification_email`, `User`.`timezone`, `User`.`ip_address`, `User`.`privacy`, `User`.`username`, `User`.`about`, `User`.`featured`, `User`.`lang`, `User`.`hide_online`, `User`.`cover`, `User`.`approved`, `User`.`is_social`, `User`.`has_active_subscription`, `User`.`receive_message_from_non_friend`, `User`.`send_email_when_send_message`, `User`.`request_friend_email`, `User`.`notification_setting`, `User`.`profile_type_id`, `User`.`package_select`, `StoreProducer`.`id`, `StoreProducer`.`store_id`, `StoreProducer`.`name`, `StoreProducer`.`enable`, `StoreProducer`.`ordering`, `StoreProducer`.`updated`, `StoreProducer`.`created`, `StoreProducer`.`phone`, `StoreProducer`.`email`, `StoreProducer`.`address` FROM `preppers_clever1`.`store_products` AS `StoreProduct` LEFT JOIN `preppers_clever1`.`stores` AS `Store` ON (`StoreProduct`.`store_id` = `Store`.`id`) LEFT JOIN `preppers_clever1`.`users` AS `User` ON (`StoreProduct`.`user_id` = `User`.`id`) LEFT JOIN `preppers_clever1`.`store_producers` AS `StoreProducer` ON (`StoreProduct`.`producer_id` = `StoreProducer`.`id` AND `StoreProducer`.`enable` = '1') WHERE `StoreProduct`.`allow_promotion` = 1 AND ((UNIX_TIMESTAMP(promotion_start) <= UNIX_TIMESTAMP(CURDATE()) AND UNIX_TIMESTAMP(CURDATE()) <= UNIX_TIMESTAMP(promotion_end)) OR (IFNULL(promotion_end, 0) = 0 && UNIX_TIMESTAMP(promotion_start) <= UNIX_TIMESTAMP(CURDATE())) OR (IFNULL(promotion_start, 0) = 0 && UNIX_TIMESTAMP(CURDATE()) <= UNIX_TIMESTAMP(promotion_end))) AND `StoreProduct`.`enable` = '1' AND `StoreProduct`.`approve` = '1' AND `Store`.`enable` = '1' ORDER BY `StoreProduct`.`id` DESC LIMIT 5112
    53SELECT `StoreProductImage`.`id`, `StoreProductImage`.`product_id`, `StoreProductImage`.`filename`, `StoreProductImage`.`path`, `StoreProductImage`.`enable`, `StoreProductImage`.`ordering`, `StoreProductImage`.`updated`, `StoreProductImage`.`created`, `StoreProductImage`.`is_main` FROM `preppers_clever1`.`store_product_images` AS `StoreProductImage` WHERE `StoreProductImage`.`product_id` = (12)220
    54SELECT COUNT(*) AS `count` FROM `preppers_clever1`.`store_product_wishlists` AS `StoreProductWishlist` WHERE `user_id` = '' AND `product_id` = 12110
    55SELECT COUNT(*) AS `count` FROM `preppers_clever1`.`store_product_attributes` AS `StoreProductAttribute` WHERE `StoreProductAttribute`.`product_id` = 12 AND `StoreProductAttribute`.`force_to_buy` = '1'110
    56SELECT COUNT(*) AS `count` FROM `preppers_clever1`.`likes` AS `Like` WHERE `Like`.`user_id` = 0 AND `Like`.`target_id` = 12 AND `Like`.`type` = 'Store_Store_Product'111
    57SELECT `Currency`.`id`, `Currency`.`currency_code`, `Currency`.`symbol`, `Currency`.`name`, `Currency`.`description`, `Currency`.`ordering`, `Currency`.`is_default`, `Currency`.`is_active` FROM `preppers_clever1`.`currencies` AS `Currency` WHERE `Currency`.`is_default` = '1' LIMIT 1110
    58SELECT `Currency`.`id`, `Currency`.`currency_code`, `Currency`.`symbol`, `Currency`.`name`, `Currency`.`description`, `Currency`.`ordering`, `Currency`.`is_default`, `Currency`.`is_active` FROM `preppers_clever1`.`currencies` AS `Currency` WHERE `Currency`.`is_default` = '1' LIMIT 1110
    59SELECT `StoreCategory`.`id`, `StoreCategory`.`parent_id`, `StoreCategory`.`lft`, `StoreCategory`.`rght`, `StoreCategory`.`enable`, `StoreCategory`.`ordering`, `StoreCategory`.`updated`, `StoreCategory`.`created`, `StoreCategory`.`name`, `StoreCategory`.`meta_title`, `StoreCategory`.`meta_keyword`, `StoreCategory`.`meta_description`, (`I18n__nameTranslation`.`content`) AS `StoreCategory__i18n_nameTranslation` FROM `preppers_clever1`.`store_categories` AS `StoreCategory` INNER JOIN `preppers_clever1`.`i18n` AS `I18n__nameTranslation` ON (`StoreCategory`.`id` = `I18n__nameTranslation`.`foreign_key` AND `I18n__nameTranslation`.`model` = 'StoreCategory' AND `I18n__nameTranslation`.`field` = 'name' AND `I18n__nameTranslation`.`locale` = 'eng') WHERE `StoreCategory`.`enable` = '1' ORDER BY `StoreCategory`.`ordering` ASC111
    60SELECT `Setting`.`id`, `Setting`.`group_id`, `Setting`.`label`, `Setting`.`name`, `Setting`.`field`, `Setting`.`value`, `Setting`.`is_hidden`, `Setting`.`version_id`, `Setting`.`type_id`, `Setting`.`value_actual`, `Setting`.`value_default`, `Setting`.`description`, `Setting`.`ordering`, `Setting`.`is_boot`, `SettingGroup`.`id`, `SettingGroup`.`parent_id`, `SettingGroup`.`lft`, `SettingGroup`.`rght`, `SettingGroup`.`group_type`, `SettingGroup`.`module_id`, `SettingGroup`.`name` FROM `preppers_clever1`.`settings` AS `Setting` LEFT JOIN `preppers_clever1`.`setting_groups` AS `SettingGroup` ON (`Setting`.`group_id` = `SettingGroup`.`id`) WHERE `Setting`.`name` = 'logo' LIMIT 1110
    61SELECT `Coremenu`.`id`, `Coremenu`.`name`, `Coremenu`.`style`, `Coremenu`.`alias`, `Coremenu`.`menuid` FROM `preppers_clever1`.`core_menus` AS `Coremenu` WHERE `alias` = 'main-menu' LIMIT 1110
    62SELECT `CoreMenuItem`.`id`, `CoreMenuItem`.`parent_id`, `CoreMenuItem`.`lft`, `CoreMenuItem`.`rght`, `CoreMenuItem`.`name`, `CoreMenuItem`.`original_name`, `CoreMenuItem`.`url`, `CoreMenuItem`.`title_attribute`, `CoreMenuItem`.`font_class`, `CoreMenuItem`.`is_active`, `CoreMenuItem`.`new_blank`, `CoreMenuItem`.`role_access`, `CoreMenuItem`.`menu_id`, `CoreMenuItem`.`type`, `CoreMenuItem`.`menu_order`, `CoreMenuItem`.`plugin`, `CoreMenuItem`.`group` FROM `preppers_clever1`.`core_menu_items` AS `CoreMenuItem` WHERE `CoreMenuItem`.`is_active` = '1' AND `CoreMenuItem`.`menu_id` = (1) ORDER BY `CoreMenuItem`.`menu_order` ASC12120
    63SELECT `nameMenuTranslation`.`id`, `nameMenuTranslation`.`locale`, `nameMenuTranslation`.`model`, `nameMenuTranslation`.`foreign_key`, `nameMenuTranslation`.`field`, `nameMenuTranslation`.`content` FROM `preppers_clever1`.`i18n` AS `nameMenuTranslation` WHERE `model` = 'CoreMenuItem' AND `field` = 'name' AND `nameMenuTranslation`.`foreign_key` IN (1, 6, 3, 53, 8, 54, 50, 2, 60, 41, 73, 75) ORDER BY `id` ASC12121
    64SELECT `Coremenuitem`.`id`, `Coremenuitem`.`parent_id`, `Coremenuitem`.`lft`, `Coremenuitem`.`rght`, `Coremenuitem`.`name`, `Coremenuitem`.`original_name`, `Coremenuitem`.`url`, `Coremenuitem`.`title_attribute`, `Coremenuitem`.`font_class`, `Coremenuitem`.`is_active`, `Coremenuitem`.`new_blank`, `Coremenuitem`.`role_access`, `Coremenuitem`.`menu_id`, `Coremenuitem`.`type`, `Coremenuitem`.`menu_order`, `Coremenuitem`.`plugin`, `Coremenuitem`.`group`, (`I18n__nameMenuTranslation`.`content`) AS `Coremenuitem__i18n_nameMenuTranslation` FROM `preppers_clever1`.`core_menu_items` AS `Coremenuitem` INNER JOIN `preppers_clever1`.`i18n` AS `I18n__nameMenuTranslation` ON (`Coremenuitem`.`id` = `I18n__nameMenuTranslation`.`foreign_key` AND `I18n__nameMenuTranslation`.`model` = 'CoreMenuItem' AND `I18n__nameMenuTranslation`.`field` = 'name' AND `I18n__nameMenuTranslation`.`locale` = 'eng') WHERE `parent_id` = 1 AND `is_active` = '1' ORDER BY `menu_order` ASC000
    65SELECT `Coremenuitem`.`id`, `Coremenuitem`.`parent_id`, `Coremenuitem`.`lft`, `Coremenuitem`.`rght`, `Coremenuitem`.`name`, `Coremenuitem`.`original_name`, `Coremenuitem`.`url`, `Coremenuitem`.`title_attribute`, `Coremenuitem`.`font_class`, `Coremenuitem`.`is_active`, `Coremenuitem`.`new_blank`, `Coremenuitem`.`role_access`, `Coremenuitem`.`menu_id`, `Coremenuitem`.`type`, `Coremenuitem`.`menu_order`, `Coremenuitem`.`plugin`, `Coremenuitem`.`group`, (`I18n__nameMenuTranslation`.`content`) AS `Coremenuitem__i18n_nameMenuTranslation` FROM `preppers_clever1`.`core_menu_items` AS `Coremenuitem` INNER JOIN `preppers_clever1`.`i18n` AS `I18n__nameMenuTranslation` ON (`Coremenuitem`.`id` = `I18n__nameMenuTranslation`.`foreign_key` AND `I18n__nameMenuTranslation`.`model` = 'CoreMenuItem' AND `I18n__nameMenuTranslation`.`field` = 'name' AND `I18n__nameMenuTranslation`.`locale` = 'eng') WHERE `parent_id` = 6 AND `is_active` = '1' ORDER BY `menu_order` ASC001
    66SELECT `Coremenuitem`.`id`, `Coremenuitem`.`parent_id`, `Coremenuitem`.`lft`, `Coremenuitem`.`rght`, `Coremenuitem`.`name`, `Coremenuitem`.`original_name`, `Coremenuitem`.`url`, `Coremenuitem`.`title_attribute`, `Coremenuitem`.`font_class`, `Coremenuitem`.`is_active`, `Coremenuitem`.`new_blank`, `Coremenuitem`.`role_access`, `Coremenuitem`.`menu_id`, `Coremenuitem`.`type`, `Coremenuitem`.`menu_order`, `Coremenuitem`.`plugin`, `Coremenuitem`.`group`, (`I18n__nameMenuTranslation`.`content`) AS `Coremenuitem__i18n_nameMenuTranslation` FROM `preppers_clever1`.`core_menu_items` AS `Coremenuitem` INNER JOIN `preppers_clever1`.`i18n` AS `I18n__nameMenuTranslation` ON (`Coremenuitem`.`id` = `I18n__nameMenuTranslation`.`foreign_key` AND `I18n__nameMenuTranslation`.`model` = 'CoreMenuItem' AND `I18n__nameMenuTranslation`.`field` = 'name' AND `I18n__nameMenuTranslation`.`locale` = 'eng') WHERE `parent_id` = 3 AND `is_active` = '1' ORDER BY `menu_order` ASC000
    67SELECT `Coremenuitem`.`id`, `Coremenuitem`.`parent_id`, `Coremenuitem`.`lft`, `Coremenuitem`.`rght`, `Coremenuitem`.`name`, `Coremenuitem`.`original_name`, `Coremenuitem`.`url`, `Coremenuitem`.`title_attribute`, `Coremenuitem`.`font_class`, `Coremenuitem`.`is_active`, `Coremenuitem`.`new_blank`, `Coremenuitem`.`role_access`, `Coremenuitem`.`menu_id`, `Coremenuitem`.`type`, `Coremenuitem`.`menu_order`, `Coremenuitem`.`plugin`, `Coremenuitem`.`group`, (`I18n__nameMenuTranslation`.`content`) AS `Coremenuitem__i18n_nameMenuTranslation` FROM `preppers_clever1`.`core_menu_items` AS `Coremenuitem` INNER JOIN `preppers_clever1`.`i18n` AS `I18n__nameMenuTranslation` ON (`Coremenuitem`.`id` = `I18n__nameMenuTranslation`.`foreign_key` AND `I18n__nameMenuTranslation`.`model` = 'CoreMenuItem' AND `I18n__nameMenuTranslation`.`field` = 'name' AND `I18n__nameMenuTranslation`.`locale` = 'eng') WHERE `parent_id` = 53 AND `is_active` = '1' ORDER BY `menu_order` ASC000
    68SELECT `Coremenuitem`.`id`, `Coremenuitem`.`parent_id`, `Coremenuitem`.`lft`, `Coremenuitem`.`rght`, `Coremenuitem`.`name`, `Coremenuitem`.`original_name`, `Coremenuitem`.`url`, `Coremenuitem`.`title_attribute`, `Coremenuitem`.`font_class`, `Coremenuitem`.`is_active`, `Coremenuitem`.`new_blank`, `Coremenuitem`.`role_access`, `Coremenuitem`.`menu_id`, `Coremenuitem`.`type`, `Coremenuitem`.`menu_order`, `Coremenuitem`.`plugin`, `Coremenuitem`.`group`, (`I18n__nameMenuTranslation`.`content`) AS `Coremenuitem__i18n_nameMenuTranslation` FROM `preppers_clever1`.`core_menu_items` AS `Coremenuitem` INNER JOIN `preppers_clever1`.`i18n` AS `I18n__nameMenuTranslation` ON (`Coremenuitem`.`id` = `I18n__nameMenuTranslation`.`foreign_key` AND `I18n__nameMenuTranslation`.`model` = 'CoreMenuItem' AND `I18n__nameMenuTranslation`.`field` = 'name' AND `I18n__nameMenuTranslation`.`locale` = 'eng') WHERE `parent_id` = 8 AND `is_active` = '1' ORDER BY `menu_order` ASC000
    69SELECT `Coremenuitem`.`id`, `Coremenuitem`.`parent_id`, `Coremenuitem`.`lft`, `Coremenuitem`.`rght`, `Coremenuitem`.`name`, `Coremenuitem`.`original_name`, `Coremenuitem`.`url`, `Coremenuitem`.`title_attribute`, `Coremenuitem`.`font_class`, `Coremenuitem`.`is_active`, `Coremenuitem`.`new_blank`, `Coremenuitem`.`role_access`, `Coremenuitem`.`menu_id`, `Coremenuitem`.`type`, `Coremenuitem`.`menu_order`, `Coremenuitem`.`plugin`, `Coremenuitem`.`group`, (`I18n__nameMenuTranslation`.`content`) AS `Coremenuitem__i18n_nameMenuTranslation` FROM `preppers_clever1`.`core_menu_items` AS `Coremenuitem` INNER JOIN `preppers_clever1`.`i18n` AS `I18n__nameMenuTranslation` ON (`Coremenuitem`.`id` = `I18n__nameMenuTranslation`.`foreign_key` AND `I18n__nameMenuTranslation`.`model` = 'CoreMenuItem' AND `I18n__nameMenuTranslation`.`field` = 'name' AND `I18n__nameMenuTranslation`.`locale` = 'eng') WHERE `parent_id` = 54 AND `is_active` = '1' ORDER BY `menu_order` ASC000
    70SELECT `Coremenuitem`.`id`, `Coremenuitem`.`parent_id`, `Coremenuitem`.`lft`, `Coremenuitem`.`rght`, `Coremenuitem`.`name`, `Coremenuitem`.`original_name`, `Coremenuitem`.`url`, `Coremenuitem`.`title_attribute`, `Coremenuitem`.`font_class`, `Coremenuitem`.`is_active`, `Coremenuitem`.`new_blank`, `Coremenuitem`.`role_access`, `Coremenuitem`.`menu_id`, `Coremenuitem`.`type`, `Coremenuitem`.`menu_order`, `Coremenuitem`.`plugin`, `Coremenuitem`.`group`, (`I18n__nameMenuTranslation`.`content`) AS `Coremenuitem__i18n_nameMenuTranslation` FROM `preppers_clever1`.`core_menu_items` AS `Coremenuitem` INNER JOIN `preppers_clever1`.`i18n` AS `I18n__nameMenuTranslation` ON (`Coremenuitem`.`id` = `I18n__nameMenuTranslation`.`foreign_key` AND `I18n__nameMenuTranslation`.`model` = 'CoreMenuItem' AND `I18n__nameMenuTranslation`.`field` = 'name' AND `I18n__nameMenuTranslation`.`locale` = 'eng') WHERE `parent_id` = 50 AND `is_active` = '1' ORDER BY `menu_order` ASC000
    71SELECT `Coremenuitem`.`id`, `Coremenuitem`.`parent_id`, `Coremenuitem`.`lft`, `Coremenuitem`.`rght`, `Coremenuitem`.`name`, `Coremenuitem`.`original_name`, `Coremenuitem`.`url`, `Coremenuitem`.`title_attribute`, `Coremenuitem`.`font_class`, `Coremenuitem`.`is_active`, `Coremenuitem`.`new_blank`, `Coremenuitem`.`role_access`, `Coremenuitem`.`menu_id`, `Coremenuitem`.`type`, `Coremenuitem`.`menu_order`, `Coremenuitem`.`plugin`, `Coremenuitem`.`group`, (`I18n__nameMenuTranslation`.`content`) AS `Coremenuitem__i18n_nameMenuTranslation` FROM `preppers_clever1`.`core_menu_items` AS `Coremenuitem` INNER JOIN `preppers_clever1`.`i18n` AS `I18n__nameMenuTranslation` ON (`Coremenuitem`.`id` = `I18n__nameMenuTranslation`.`foreign_key` AND `I18n__nameMenuTranslation`.`model` = 'CoreMenuItem' AND `I18n__nameMenuTranslation`.`field` = 'name' AND `I18n__nameMenuTranslation`.`locale` = 'eng') WHERE `parent_id` = 2 AND `is_active` = '1' ORDER BY `menu_order` ASC000
    72SELECT `Coremenuitem`.`id`, `Coremenuitem`.`parent_id`, `Coremenuitem`.`lft`, `Coremenuitem`.`rght`, `Coremenuitem`.`name`, `Coremenuitem`.`original_name`, `Coremenuitem`.`url`, `Coremenuitem`.`title_attribute`, `Coremenuitem`.`font_class`, `Coremenuitem`.`is_active`, `Coremenuitem`.`new_blank`, `Coremenuitem`.`role_access`, `Coremenuitem`.`menu_id`, `Coremenuitem`.`type`, `Coremenuitem`.`menu_order`, `Coremenuitem`.`plugin`, `Coremenuitem`.`group`, (`I18n__nameMenuTranslation`.`content`) AS `Coremenuitem__i18n_nameMenuTranslation` FROM `preppers_clever1`.`core_menu_items` AS `Coremenuitem` INNER JOIN `preppers_clever1`.`i18n` AS `I18n__nameMenuTranslation` ON (`Coremenuitem`.`id` = `I18n__nameMenuTranslation`.`foreign_key` AND `I18n__nameMenuTranslation`.`model` = 'CoreMenuItem' AND `I18n__nameMenuTranslation`.`field` = 'name' AND `I18n__nameMenuTranslation`.`locale` = 'eng') WHERE `parent_id` = 60 AND `is_active` = '1' ORDER BY `menu_order` ASC000
    73SELECT `Coremenuitem`.`id`, `Coremenuitem`.`parent_id`, `Coremenuitem`.`lft`, `Coremenuitem`.`rght`, `Coremenuitem`.`name`, `Coremenuitem`.`original_name`, `Coremenuitem`.`url`, `Coremenuitem`.`title_attribute`, `Coremenuitem`.`font_class`, `Coremenuitem`.`is_active`, `Coremenuitem`.`new_blank`, `Coremenuitem`.`role_access`, `Coremenuitem`.`menu_id`, `Coremenuitem`.`type`, `Coremenuitem`.`menu_order`, `Coremenuitem`.`plugin`, `Coremenuitem`.`group`, (`I18n__nameMenuTranslation`.`content`) AS `Coremenuitem__i18n_nameMenuTranslation` FROM `preppers_clever1`.`core_menu_items` AS `Coremenuitem` INNER JOIN `preppers_clever1`.`i18n` AS `I18n__nameMenuTranslation` ON (`Coremenuitem`.`id` = `I18n__nameMenuTranslation`.`foreign_key` AND `I18n__nameMenuTranslation`.`model` = 'CoreMenuItem' AND `I18n__nameMenuTranslation`.`field` = 'name' AND `I18n__nameMenuTranslation`.`locale` = 'eng') WHERE `parent_id` = 41 AND `is_active` = '1' ORDER BY `menu_order` ASC000
    74SELECT `Coremenuitem`.`id`, `Coremenuitem`.`parent_id`, `Coremenuitem`.`lft`, `Coremenuitem`.`rght`, `Coremenuitem`.`name`, `Coremenuitem`.`original_name`, `Coremenuitem`.`url`, `Coremenuitem`.`title_attribute`, `Coremenuitem`.`font_class`, `Coremenuitem`.`is_active`, `Coremenuitem`.`new_blank`, `Coremenuitem`.`role_access`, `Coremenuitem`.`menu_id`, `Coremenuitem`.`type`, `Coremenuitem`.`menu_order`, `Coremenuitem`.`plugin`, `Coremenuitem`.`group`, (`I18n__nameMenuTranslation`.`content`) AS `Coremenuitem__i18n_nameMenuTranslation` FROM `preppers_clever1`.`core_menu_items` AS `Coremenuitem` INNER JOIN `preppers_clever1`.`i18n` AS `I18n__nameMenuTranslation` ON (`Coremenuitem`.`id` = `I18n__nameMenuTranslation`.`foreign_key` AND `I18n__nameMenuTranslation`.`model` = 'CoreMenuItem' AND `I18n__nameMenuTranslation`.`field` = 'name' AND `I18n__nameMenuTranslation`.`locale` = 'eng') WHERE `parent_id` = 75 AND `is_active` = '1' ORDER BY `menu_order` ASC001
    75SELECT `Setting`.`id`, `Setting`.`group_id`, `Setting`.`label`, `Setting`.`name`, `Setting`.`field`, `Setting`.`value`, `Setting`.`is_hidden`, `Setting`.`version_id`, `Setting`.`type_id`, `Setting`.`value_actual`, `Setting`.`value_default`, `Setting`.`description`, `Setting`.`ordering`, `Setting`.`is_boot`, `SettingGroup`.`id`, `SettingGroup`.`parent_id`, `SettingGroup`.`lft`, `SettingGroup`.`rght`, `SettingGroup`.`group_type`, `SettingGroup`.`module_id`, `SettingGroup`.`name` FROM `preppers_clever1`.`settings` AS `Setting` LEFT JOIN `preppers_clever1`.`setting_groups` AS `SettingGroup` ON (`Setting`.`group_id` = `SettingGroup`.`id`) WHERE `Setting`.`name` = 'logo' LIMIT 1110