| 1 | SELECT `Session`.`id`, `Session`.`data`, `Session`.`expires`, `Session`.`user_id` FROM `travel_moosocial`.`qccake_sessions` AS `Session` WHERE `Session`.`id` = '8559bed149d4d06d7df5d07b4e942fc9' LIMIT 1 | | 1 | 1 | 0 |
| 2 | SELECT `ClassifiedCategory`.`id` FROM `travel_moosocial`.`qcclassified_categories` AS `ClassifiedCategory` WHERE ((`ClassifiedCategory`.`parent_id` = 7) OR (`ClassifiedCategory`.`id` = 7)) ORDER BY `ClassifiedCategory`.`order` ASC | | 1 | 1 | 9 |
| 3 | SELECT Classified.*, User.*,ClassifiedCategory.*,( 3959 * acos( cos( radians(0) ) * cos( radians( Classified.lat ) )
* cos( radians(Classified.lng) - radians(0)) + sin(radians(0))
* sin( radians(Classified.lat)))) AS distance, `Classified`.`id` FROM `travel_moosocial`.`qcclassifieds` AS `Classified` LEFT JOIN `travel_moosocial`.`qcclassified_categories` AS `ClassifiedCategory` ON (`Classified`.`classified_category_id` = `ClassifiedCategory`.`id`) LEFT JOIN `travel_moosocial`.`qcclassified_brands` AS `ClassifiedBrand` ON (`Classified`.`classified_brand_id` = `ClassifiedBrand`.`id`) LEFT JOIN `travel_moosocial`.`qcclassified_packages` AS `ClassifiedPackage` ON (`Classified`.`classified_package_id` = `ClassifiedPackage`.`id`) LEFT JOIN `travel_moosocial`.`qcusers` AS `User` ON (`Classified`.`user_id` = `User`.`id`) WHERE `Classified`.`status` = 1 AND `Classified`.`privacy` = 1 AND `Classified`.`classified_category_id` = (7) ORDER BY `Classified`.`id` DESC LIMIT 10 | | 2 | 2 | 75 |
| 4 | SELECT `ProfileType`.`id`, `ProfileType`.`name`, `ProfileType`.`actived`, `ProfileType`.`profile`, `ProfileType`.`order`, (`I18n__nameTranslation`.`content`) AS `ProfileType__i18n_nameTranslation` FROM `travel_moosocial`.`qcprofile_types` AS `ProfileType` INNER JOIN `travel_moosocial`.`qci18n` AS `I18n__nameTranslation` ON (`ProfileType`.`id` = `I18n__nameTranslation`.`foreign_key` AND `I18n__nameTranslation`.`model` = 'ProfileType' AND `I18n__nameTranslation`.`field` = 'name' AND `I18n__nameTranslation`.`locale` = 'eng') WHERE `ProfileType`.`id` IN (1, 'eng') AND `ProfileType`.`actived` = '1' ORDER BY `ProfileType`.`order` asc | | 1 | 1 | 2 |
| 5 | SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content` FROM `travel_moosocial`.`qci18n` AS `nameTranslation` WHERE `model` = 'ProfileType' AND `field` = 'name' AND `nameTranslation`.`foreign_key` = (1) ORDER BY `id` ASC | | 3 | 3 | 2 |
| 6 | SELECT `ClassifiedCategory`.`id`, `ClassifiedCategory`.`parent_id`, `ClassifiedCategory`.`lft`, `ClassifiedCategory`.`rght`, `ClassifiedCategory`.`name`, `ClassifiedCategory`.`classified_count`, `ClassifiedCategory`.`order`, (`I18n__nameTranslation`.`content`) AS `ClassifiedCategory__i18n_nameTranslation` FROM `travel_moosocial`.`qcclassified_categories` AS `ClassifiedCategory` INNER JOIN `travel_moosocial`.`qci18n` AS `I18n__nameTranslation` ON (`ClassifiedCategory`.`id` = `I18n__nameTranslation`.`foreign_key` AND `I18n__nameTranslation`.`model` = 'ClassifiedCategory' AND `I18n__nameTranslation`.`field` = 'name' AND `I18n__nameTranslation`.`locale` = 'eng') WHERE `ClassifiedCategory`.`id` = 7 ORDER BY `ClassifiedCategory`.`order` ASC LIMIT 1 | | 1 | 1 | 1 |
| 7 | SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content` FROM `travel_moosocial`.`qci18n` AS `nameTranslation` WHERE `model` = 'ClassifiedCategory' AND `field` = 'name' AND `nameTranslation`.`foreign_key` = (7) ORDER BY `id` ASC | | 3 | 3 | 0 |
| 8 | SELECT `ClassifiedCategory`.`id`, `ClassifiedCategory`.`parent_id`, `ClassifiedCategory`.`lft`, `ClassifiedCategory`.`rght`, `ClassifiedCategory`.`name`, `ClassifiedCategory`.`classified_count`, `ClassifiedCategory`.`order`, (`I18n__nameTranslation`.`content`) AS `ClassifiedCategory__i18n_nameTranslation` FROM `travel_moosocial`.`qcclassified_categories` AS `ClassifiedCategory` INNER JOIN `travel_moosocial`.`qci18n` AS `I18n__nameTranslation` ON (`ClassifiedCategory`.`id` = `I18n__nameTranslation`.`foreign_key` AND `I18n__nameTranslation`.`model` = 'ClassifiedCategory' AND `I18n__nameTranslation`.`field` = 'name' AND `I18n__nameTranslation`.`locale` = 'eng') WHERE `ClassifiedCategory`.`id` = 6 ORDER BY `ClassifiedCategory`.`order` ASC LIMIT 1 | | 1 | 1 | 0 |
| 9 | SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content` FROM `travel_moosocial`.`qci18n` AS `nameTranslation` WHERE `model` = 'ClassifiedCategory' AND `field` = 'name' AND `nameTranslation`.`foreign_key` = (6) ORDER BY `id` ASC | | 3 | 3 | 1 |
| 10 | SELECT `ClassifiedCategory`.`id`, `ClassifiedCategory`.`parent_id`, `ClassifiedCategory`.`lft`, `ClassifiedCategory`.`rght`, `ClassifiedCategory`.`name`, `ClassifiedCategory`.`classified_count`, `ClassifiedCategory`.`order`, (`I18n__nameTranslation`.`content`) AS `ClassifiedCategory__i18n_nameTranslation` FROM `travel_moosocial`.`qcclassified_categories` AS `ClassifiedCategory` INNER JOIN `travel_moosocial`.`qci18n` AS `I18n__nameTranslation` ON (`ClassifiedCategory`.`id` = `I18n__nameTranslation`.`foreign_key` AND `I18n__nameTranslation`.`model` = 'ClassifiedCategory' AND `I18n__nameTranslation`.`field` = 'name' AND `I18n__nameTranslation`.`locale` = 'eng') WHERE `ClassifiedCategory`.`parent_id` = 0 ORDER BY `ClassifiedCategory`.`order` ASC | | 10 | 10 | 1 |
| 11 | SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content` FROM `travel_moosocial`.`qci18n` AS `nameTranslation` WHERE `model` = 'ClassifiedCategory' AND `field` = 'name' AND `nameTranslation`.`foreign_key` IN (22, 18, 15, 6, 10, 5, 4, 3, 2, 1) ORDER BY `id` ASC | | 30 | 30 | 2 |
| 12 | SELECT `ClassifiedCategory`.`id`, `ClassifiedCategory`.`parent_id`, `ClassifiedCategory`.`lft`, `ClassifiedCategory`.`rght`, `ClassifiedCategory`.`name`, `ClassifiedCategory`.`classified_count`, `ClassifiedCategory`.`order`, (`I18n__nameTranslation`.`content`) AS `ClassifiedCategory__i18n_nameTranslation` FROM `travel_moosocial`.`qcclassified_categories` AS `ClassifiedCategory` INNER JOIN `travel_moosocial`.`qci18n` AS `I18n__nameTranslation` ON (`ClassifiedCategory`.`id` = `I18n__nameTranslation`.`foreign_key` AND `I18n__nameTranslation`.`model` = 'ClassifiedCategory' AND `I18n__nameTranslation`.`field` = 'name' AND `I18n__nameTranslation`.`locale` = 'eng') WHERE `ClassifiedCategory`.`parent_id` = 6 ORDER BY `ClassifiedCategory`.`order` ASC | | 3 | 3 | 1 |
| 13 | SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content` FROM `travel_moosocial`.`qci18n` AS `nameTranslation` WHERE `model` = 'ClassifiedCategory' AND `field` = 'name' AND `nameTranslation`.`foreign_key` IN (7, 8, 9) ORDER BY `id` ASC | | 9 | 9 | 0 |
| 14 | SELECT `ClassifiedField`.`id`, `ClassifiedField`.`classified_category_id`, `ClassifiedField`.`name`, `ClassifiedField`.`description`, `ClassifiedField`.`type`, `ClassifiedField`.`values`, `ClassifiedField`.`required`, `ClassifiedField`.`searchable`, `ClassifiedField`.`active`, `ClassifiedField`.`order`, (`I18n__nameTranslation`.`content`) AS `ClassifiedField__i18n_nameTranslation`, `ClassifiedCategory`.`id`, `ClassifiedCategory`.`parent_id`, `ClassifiedCategory`.`lft`, `ClassifiedCategory`.`rght`, `ClassifiedCategory`.`name`, `ClassifiedCategory`.`classified_count`, `ClassifiedCategory`.`order` FROM `travel_moosocial`.`qcclassified_fields` AS `ClassifiedField` LEFT JOIN `travel_moosocial`.`qcclassified_categories` AS `ClassifiedCategory` ON (`ClassifiedField`.`classified_category_id` = `ClassifiedCategory`.`id`) INNER JOIN `travel_moosocial`.`qci18n` AS `I18n__nameTranslation` ON (`ClassifiedField`.`id` = `I18n__nameTranslation`.`foreign_key` AND `I18n__nameTranslation`.`model` = 'ClassifiedField' AND `I18n__nameTranslation`.`field` = 'name' AND `I18n__nameTranslation`.`locale` = 'eng') WHERE `classified_category_id` = 7 AND `active` = 1 AND `searchable` = 1 ORDER BY `ClassifiedField`.`order` asc | | 0 | 0 | 1 |
| 15 | SELECT `ClassifiedPaymentmethod`.`id`, `ClassifiedPaymentmethod`.`name`, `ClassifiedPaymentmethod`.`classified_count`, `ClassifiedPaymentmethod`.`order`, (`I18n__nameTranslation`.`content`) AS `ClassifiedPaymentmethod__i18n_nameTranslation` FROM `travel_moosocial`.`qcclassified_paymentmethods` AS `ClassifiedPaymentmethod` INNER JOIN `travel_moosocial`.`qci18n` AS `I18n__nameTranslation` ON (`ClassifiedPaymentmethod`.`id` = `I18n__nameTranslation`.`foreign_key` AND `I18n__nameTranslation`.`model` = 'ClassifiedPaymentmethod' AND `I18n__nameTranslation`.`field` = 'name' AND `I18n__nameTranslation`.`locale` = 'eng') WHERE 1 = 1 ORDER BY `ClassifiedPaymentmethod`.`order` ASC | | 4 | 4 | 1 |
| 16 | SELECT `Classified`.`id`, `Classified`.`user_id`, `Classified`.`available`, `Classified`.`status`, `Classified`.`featured`, `Classified`.`sponsored`, `Classified`.`classified_category_id`, `Classified`.`classified_package_id`, `Classified`.`classified_brand_id`, `Classified`.`classified_paymentmethod_id`, `Classified`.`state`, `Classified`.`condition`, `Classified`.`delivery_method`, `Classified`.`number_available`, `Classified`.`name`, `Classified`.`description`, `Classified`.`price`, `Classified`.`location`, `Classified`.`lat`, `Classified`.`lng`, `Classified`.`thumbnail`, `Classified`.`created`, `Classified`.`modified`, `Classified`.`recently_view`, `Classified`.`privacy`, `Classified`.`classified_contact_count`, `Classified`.`review_rating`, `Classified`.`review_count`, `Classified`.`view_count`, `Classified`.`share_count`, `Classified`.`like_count`, `Classified`.`comment_count`, `Classified`.`dislike_count` FROM `travel_moosocial`.`qcclassifieds` AS `Classified` WHERE `Classified`.`classified_paymentmethod_id` IN (1, 2, 3, 4) | | 10 | 10 | 1 |
| 17 | SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content` FROM `travel_moosocial`.`qci18n` AS `nameTranslation` WHERE `model` = 'ClassifiedPaymentmethod' AND `field` = 'name' AND `nameTranslation`.`foreign_key` IN (1, 2, 3, 4) ORDER BY `id` ASC | | 12 | 12 | 0 |
| 18 | SELECT `Coremenu`.`id`, `Coremenu`.`name`, `Coremenu`.`style`, `Coremenu`.`alias`, `Coremenu`.`menuid` FROM `travel_moosocial`.`qccore_menus` AS `Coremenu` WHERE `id` = 2 LIMIT 1 | | 1 | 1 | 0 |
| 19 | SELECT `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`, `CoreMenuItem`.`url_app`, `CoreMenuItem`.`font_class_app`, `CoreMenuItem`.`show_web`, `CoreMenuItem`.`show_app` FROM `travel_moosocial`.`qccore_menu_items` AS `CoreMenuItem` WHERE `CoreMenuItem`.`is_active` = '1' AND `CoreMenuItem`.`menu_id` = (2) ORDER BY `CoreMenuItem`.`menu_order` ASC | | 4 | 4 | 1 |
| 20 | SELECT `nameMenuTranslation`.`id`, `nameMenuTranslation`.`locale`, `nameMenuTranslation`.`model`, `nameMenuTranslation`.`foreign_key`, `nameMenuTranslation`.`field`, `nameMenuTranslation`.`content` FROM `travel_moosocial`.`qci18n` AS `nameMenuTranslation` WHERE `model` = 'CoreMenuItem' AND `field` = 'name' AND `nameMenuTranslation`.`foreign_key` IN (9, 11, 12, 17) ORDER BY `id` ASC | | 12 | 12 | 1 |
| 21 | SELECT `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`, `Coremenuitem`.`url_app`, `Coremenuitem`.`font_class_app`, `Coremenuitem`.`show_web`, `Coremenuitem`.`show_app`, (`I18n__nameMenuTranslation`.`content`) AS `Coremenuitem__i18n_nameMenuTranslation` FROM `travel_moosocial`.`qccore_menu_items` AS `Coremenuitem` INNER JOIN `travel_moosocial`.`qci18n` 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` = 9 AND `is_active` = '1' ORDER BY `menu_order` ASC | | 0 | 0 | 1 |
| 22 | SELECT `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`, `Coremenuitem`.`url_app`, `Coremenuitem`.`font_class_app`, `Coremenuitem`.`show_web`, `Coremenuitem`.`show_app`, (`I18n__nameMenuTranslation`.`content`) AS `Coremenuitem__i18n_nameMenuTranslation` FROM `travel_moosocial`.`qccore_menu_items` AS `Coremenuitem` INNER JOIN `travel_moosocial`.`qci18n` 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` = 11 AND `is_active` = '1' ORDER BY `menu_order` ASC | | 0 | 0 | 1 |
| 23 | SELECT `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`, `Coremenuitem`.`url_app`, `Coremenuitem`.`font_class_app`, `Coremenuitem`.`show_web`, `Coremenuitem`.`show_app`, (`I18n__nameMenuTranslation`.`content`) AS `Coremenuitem__i18n_nameMenuTranslation` FROM `travel_moosocial`.`qccore_menu_items` AS `Coremenuitem` INNER JOIN `travel_moosocial`.`qci18n` 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` = 12 AND `is_active` = '1' ORDER BY `menu_order` ASC | | 0 | 0 | 1 |
| 24 | SELECT `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`, `Coremenuitem`.`url_app`, `Coremenuitem`.`font_class_app`, `Coremenuitem`.`show_web`, `Coremenuitem`.`show_app`, (`I18n__nameMenuTranslation`.`content`) AS `Coremenuitem__i18n_nameMenuTranslation` FROM `travel_moosocial`.`qccore_menu_items` AS `Coremenuitem` INNER JOIN `travel_moosocial`.`qci18n` 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` = 17 AND `is_active` = '1' ORDER BY `menu_order` ASC | | 0 | 0 | 1 |
| 25 | SELECT `ClassifiedCategory`.`id`, `ClassifiedCategory`.`parent_id`, `ClassifiedCategory`.`lft`, `ClassifiedCategory`.`rght`, `ClassifiedCategory`.`name`, `ClassifiedCategory`.`classified_count`, `ClassifiedCategory`.`order`, (`I18n__nameTranslation`.`content`) AS `ClassifiedCategory__i18n_nameTranslation` FROM `travel_moosocial`.`qcclassified_categories` AS `ClassifiedCategory` INNER JOIN `travel_moosocial`.`qci18n` AS `I18n__nameTranslation` ON (`ClassifiedCategory`.`id` = `I18n__nameTranslation`.`foreign_key` AND `I18n__nameTranslation`.`model` = 'ClassifiedCategory' AND `I18n__nameTranslation`.`field` = 'name' AND `I18n__nameTranslation`.`locale` = 'eng') WHERE `ClassifiedCategory`.`id` = 7 ORDER BY `ClassifiedCategory`.`order` ASC LIMIT 1 | | 1 | 1 | 1 |
| 26 | SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content` FROM `travel_moosocial`.`qci18n` AS `nameTranslation` WHERE `model` = 'ClassifiedCategory' AND `field` = 'name' AND `nameTranslation`.`foreign_key` = (7) ORDER BY `id` ASC | | 3 | 3 | 1 |
| 27 | SELECT `ClassifiedBrand`.`id`, `ClassifiedBrand`.`name`, `ClassifiedBrand`.`classified_count`, `ClassifiedBrand`.`order`, (`I18n__nameTranslation`.`content`) AS `ClassifiedBrand__i18n_nameTranslation` FROM `travel_moosocial`.`qcclassified_brands` AS `ClassifiedBrand` INNER JOIN `travel_moosocial`.`qci18n` AS `I18n__nameTranslation` ON (`ClassifiedBrand`.`id` = `I18n__nameTranslation`.`foreign_key` AND `I18n__nameTranslation`.`model` = 'ClassifiedBrand' AND `I18n__nameTranslation`.`field` = 'name' AND `I18n__nameTranslation`.`locale` = 'eng') WHERE `ClassifiedBrand`.`id` = 7 ORDER BY `ClassifiedBrand`.`order` ASC LIMIT 1 | | 1 | 1 | 1 |
| 28 | SELECT `Classified`.`id`, `Classified`.`user_id`, `Classified`.`available`, `Classified`.`status`, `Classified`.`featured`, `Classified`.`sponsored`, `Classified`.`classified_category_id`, `Classified`.`classified_package_id`, `Classified`.`classified_brand_id`, `Classified`.`classified_paymentmethod_id`, `Classified`.`state`, `Classified`.`condition`, `Classified`.`delivery_method`, `Classified`.`number_available`, `Classified`.`name`, `Classified`.`description`, `Classified`.`price`, `Classified`.`location`, `Classified`.`lat`, `Classified`.`lng`, `Classified`.`thumbnail`, `Classified`.`created`, `Classified`.`modified`, `Classified`.`recently_view`, `Classified`.`privacy`, `Classified`.`classified_contact_count`, `Classified`.`review_rating`, `Classified`.`review_count`, `Classified`.`view_count`, `Classified`.`share_count`, `Classified`.`like_count`, `Classified`.`comment_count`, `Classified`.`dislike_count` FROM `travel_moosocial`.`qcclassifieds` AS `Classified` WHERE `Classified`.`classified_brand_id` = (7) | | 1 | 1 | 0 |
| 29 | SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content` FROM `travel_moosocial`.`qci18n` AS `nameTranslation` WHERE `model` = 'ClassifiedBrand' AND `field` = 'name' AND `nameTranslation`.`foreign_key` = (7) ORDER BY `id` ASC | | 3 | 3 | 0 |
| 30 | SELECT `ClassifiedBrand`.`id`, `ClassifiedBrand`.`name`, `ClassifiedBrand`.`classified_count`, `ClassifiedBrand`.`order`, (`I18n__nameTranslation`.`content`) AS `ClassifiedBrand__i18n_nameTranslation` FROM `travel_moosocial`.`qcclassified_brands` AS `ClassifiedBrand` INNER JOIN `travel_moosocial`.`qci18n` AS `I18n__nameTranslation` ON (`ClassifiedBrand`.`id` = `I18n__nameTranslation`.`foreign_key` AND `I18n__nameTranslation`.`model` = 'ClassifiedBrand' AND `I18n__nameTranslation`.`field` = 'name' AND `I18n__nameTranslation`.`locale` = 'eng') WHERE `ClassifiedBrand`.`id` = 7 ORDER BY `ClassifiedBrand`.`order` ASC LIMIT 1 | | 1 | 1 | 0 |
| 31 | SELECT `Classified`.`id`, `Classified`.`user_id`, `Classified`.`available`, `Classified`.`status`, `Classified`.`featured`, `Classified`.`sponsored`, `Classified`.`classified_category_id`, `Classified`.`classified_package_id`, `Classified`.`classified_brand_id`, `Classified`.`classified_paymentmethod_id`, `Classified`.`state`, `Classified`.`condition`, `Classified`.`delivery_method`, `Classified`.`number_available`, `Classified`.`name`, `Classified`.`description`, `Classified`.`price`, `Classified`.`location`, `Classified`.`lat`, `Classified`.`lng`, `Classified`.`thumbnail`, `Classified`.`created`, `Classified`.`modified`, `Classified`.`recently_view`, `Classified`.`privacy`, `Classified`.`classified_contact_count`, `Classified`.`review_rating`, `Classified`.`review_count`, `Classified`.`view_count`, `Classified`.`share_count`, `Classified`.`like_count`, `Classified`.`comment_count`, `Classified`.`dislike_count` FROM `travel_moosocial`.`qcclassifieds` AS `Classified` WHERE `Classified`.`classified_brand_id` = (7) | | 1 | 1 | 0 |
| 32 | SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content` FROM `travel_moosocial`.`qci18n` AS `nameTranslation` WHERE `model` = 'ClassifiedBrand' AND `field` = 'name' AND `nameTranslation`.`foreign_key` = (7) ORDER BY `id` ASC | | 3 | 3 | 0 |
| 33 | SELECT `Currency`.`id`, `Currency`.`currency_code`, `Currency`.`symbol`, `Currency`.`name`, `Currency`.`description`, `Currency`.`ordering`, `Currency`.`is_default`, `Currency`.`is_active` FROM `travel_moosocial`.`qccurrencies` AS `Currency` WHERE `Currency`.`currency_code` = 'USD' LIMIT 1 | | 1 | 1 | 0 |
| 34 | SELECT `ClassifiedCategory`.`id`, `ClassifiedCategory`.`parent_id`, `ClassifiedCategory`.`lft`, `ClassifiedCategory`.`rght`, `ClassifiedCategory`.`name`, `ClassifiedCategory`.`classified_count`, `ClassifiedCategory`.`order`, (`I18n__nameTranslation`.`content`) AS `ClassifiedCategory__i18n_nameTranslation` FROM `travel_moosocial`.`qcclassified_categories` AS `ClassifiedCategory` INNER JOIN `travel_moosocial`.`qci18n` AS `I18n__nameTranslation` ON (`ClassifiedCategory`.`id` = `I18n__nameTranslation`.`foreign_key` AND `I18n__nameTranslation`.`model` = 'ClassifiedCategory' AND `I18n__nameTranslation`.`field` = 'name' AND `I18n__nameTranslation`.`locale` = 'eng') WHERE `ClassifiedCategory`.`id` = 7 ORDER BY `ClassifiedCategory`.`order` ASC LIMIT 1 | | 1 | 1 | 1 |
| 35 | SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content` FROM `travel_moosocial`.`qci18n` AS `nameTranslation` WHERE `model` = 'ClassifiedCategory' AND `field` = 'name' AND `nameTranslation`.`foreign_key` = (7) ORDER BY `id` ASC | | 3 | 3 | 0 |
| 36 | SELECT `ClassifiedBrand`.`id`, `ClassifiedBrand`.`name`, `ClassifiedBrand`.`classified_count`, `ClassifiedBrand`.`order`, (`I18n__nameTranslation`.`content`) AS `ClassifiedBrand__i18n_nameTranslation` FROM `travel_moosocial`.`qcclassified_brands` AS `ClassifiedBrand` INNER JOIN `travel_moosocial`.`qci18n` AS `I18n__nameTranslation` ON (`ClassifiedBrand`.`id` = `I18n__nameTranslation`.`foreign_key` AND `I18n__nameTranslation`.`model` = 'ClassifiedBrand' AND `I18n__nameTranslation`.`field` = 'name' AND `I18n__nameTranslation`.`locale` = 'eng') WHERE `ClassifiedBrand`.`id` = 4 ORDER BY `ClassifiedBrand`.`order` ASC LIMIT 1 | | 1 | 1 | 1 |
| 37 | SELECT `Classified`.`id`, `Classified`.`user_id`, `Classified`.`available`, `Classified`.`status`, `Classified`.`featured`, `Classified`.`sponsored`, `Classified`.`classified_category_id`, `Classified`.`classified_package_id`, `Classified`.`classified_brand_id`, `Classified`.`classified_paymentmethod_id`, `Classified`.`state`, `Classified`.`condition`, `Classified`.`delivery_method`, `Classified`.`number_available`, `Classified`.`name`, `Classified`.`description`, `Classified`.`price`, `Classified`.`location`, `Classified`.`lat`, `Classified`.`lng`, `Classified`.`thumbnail`, `Classified`.`created`, `Classified`.`modified`, `Classified`.`recently_view`, `Classified`.`privacy`, `Classified`.`classified_contact_count`, `Classified`.`review_rating`, `Classified`.`review_count`, `Classified`.`view_count`, `Classified`.`share_count`, `Classified`.`like_count`, `Classified`.`comment_count`, `Classified`.`dislike_count` FROM `travel_moosocial`.`qcclassifieds` AS `Classified` WHERE `Classified`.`classified_brand_id` = (4) | | 1 | 1 | 0 |
| 38 | SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content` FROM `travel_moosocial`.`qci18n` AS `nameTranslation` WHERE `model` = 'ClassifiedBrand' AND `field` = 'name' AND `nameTranslation`.`foreign_key` = (4) ORDER BY `id` ASC | | 3 | 3 | 0 |
| 39 | SELECT `ClassifiedBrand`.`id`, `ClassifiedBrand`.`name`, `ClassifiedBrand`.`classified_count`, `ClassifiedBrand`.`order`, (`I18n__nameTranslation`.`content`) AS `ClassifiedBrand__i18n_nameTranslation` FROM `travel_moosocial`.`qcclassified_brands` AS `ClassifiedBrand` INNER JOIN `travel_moosocial`.`qci18n` AS `I18n__nameTranslation` ON (`ClassifiedBrand`.`id` = `I18n__nameTranslation`.`foreign_key` AND `I18n__nameTranslation`.`model` = 'ClassifiedBrand' AND `I18n__nameTranslation`.`field` = 'name' AND `I18n__nameTranslation`.`locale` = 'eng') WHERE `ClassifiedBrand`.`id` = 4 ORDER BY `ClassifiedBrand`.`order` ASC LIMIT 1 | | 1 | 1 | 0 |
| 40 | SELECT `Classified`.`id`, `Classified`.`user_id`, `Classified`.`available`, `Classified`.`status`, `Classified`.`featured`, `Classified`.`sponsored`, `Classified`.`classified_category_id`, `Classified`.`classified_package_id`, `Classified`.`classified_brand_id`, `Classified`.`classified_paymentmethod_id`, `Classified`.`state`, `Classified`.`condition`, `Classified`.`delivery_method`, `Classified`.`number_available`, `Classified`.`name`, `Classified`.`description`, `Classified`.`price`, `Classified`.`location`, `Classified`.`lat`, `Classified`.`lng`, `Classified`.`thumbnail`, `Classified`.`created`, `Classified`.`modified`, `Classified`.`recently_view`, `Classified`.`privacy`, `Classified`.`classified_contact_count`, `Classified`.`review_rating`, `Classified`.`review_count`, `Classified`.`view_count`, `Classified`.`share_count`, `Classified`.`like_count`, `Classified`.`comment_count`, `Classified`.`dislike_count` FROM `travel_moosocial`.`qcclassifieds` AS `Classified` WHERE `Classified`.`classified_brand_id` = (4) | | 1 | 1 | 0 |
| 41 | SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content` FROM `travel_moosocial`.`qci18n` AS `nameTranslation` WHERE `model` = 'ClassifiedBrand' AND `field` = 'name' AND `nameTranslation`.`foreign_key` = (4) ORDER BY `id` ASC | | 3 | 3 | 0 |
| 42 | SELECT `Currency`.`id`, `Currency`.`currency_code`, `Currency`.`symbol`, `Currency`.`name`, `Currency`.`description`, `Currency`.`ordering`, `Currency`.`is_default`, `Currency`.`is_active` FROM `travel_moosocial`.`qccurrencies` AS `Currency` WHERE `Currency`.`currency_code` = 'USD' LIMIT 1 | | 1 | 1 | 0 |
| 43 | SELECT `Theme`.`id`, `Theme`.`key`, `Theme`.`name`, `Theme`.`core`, `Theme`.`custom_css_enable`, `Theme`.`custom_css_landing`, `Theme`.`custom_css`, `Theme`.`custom_css_dark` FROM `travel_moosocial`.`qcthemes` AS `Theme` WHERE `Theme`.`key` = 'classic' LIMIT 1 | | 1 | 1 | 0 |
| 44 | SELECT `Theme`.`id`, `Theme`.`key`, `Theme`.`name`, `Theme`.`core`, `Theme`.`custom_css_enable`, `Theme`.`custom_css_landing`, `Theme`.`custom_css`, `Theme`.`custom_css_dark` FROM `travel_moosocial`.`qcthemes` AS `Theme` WHERE `Theme`.`key` = 'classic' LIMIT 1 | | 1 | 1 | 0 |
| 45 | SELECT `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 `travel_moosocial`.`qcsettings` AS `Setting` LEFT JOIN `travel_moosocial`.`qcsetting_groups` AS `SettingGroup` ON (`Setting`.`group_id` = `SettingGroup`.`id`) WHERE `Setting`.`name` = 'logo' LIMIT 1 | | 1 | 1 | 1 |
| 46 | SELECT `Theme`.`id`, `Theme`.`key`, `Theme`.`name`, `Theme`.`core`, `Theme`.`custom_css_enable`, `Theme`.`custom_css_landing`, `Theme`.`custom_css`, `Theme`.`custom_css_dark` FROM `travel_moosocial`.`qcthemes` AS `Theme` WHERE `Theme`.`key` = 'classic' LIMIT 1 | | 1 | 1 | 0 |
| 47 | SELECT `Theme`.`id`, `Theme`.`key`, `Theme`.`name`, `Theme`.`core`, `Theme`.`custom_css_enable`, `Theme`.`custom_css_landing`, `Theme`.`custom_css`, `Theme`.`custom_css_dark` FROM `travel_moosocial`.`qcthemes` AS `Theme` WHERE `Theme`.`key` = 'classic' LIMIT 1 | | 1 | 1 | 0 |
