Businesses for ou manger

  • No businesses found
(default) 19 queries took 14 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 `plpb_strascity`.`currencies` AS `Currency` WHERE `Currency`.`is_default` = '1' LIMIT 1111
2SELECT `Session`.`id`, `Session`.`data`, `Session`.`expires`, `Session`.`user_id` FROM `plpb_strascity`.`cake_sessions` AS `Session` WHERE `Session`.`id` = '05ac0ea2f290fcb0ff2f7f2d400b1d3c' LIMIT 1001
3SELECT `BusinessLocation`.`id` FROM `plpb_strascity`.`business_locations` AS `BusinessLocation` WHERE `BusinessLocation`.`parent_id` = 0 AND `BusinessLocation`.`enabled` = '1' ORDER BY `BusinessLocation`.`ordering` ASC001
4SELECT `BusinessLocation`.`id`, `BusinessLocation`.`parent_id`, `BusinessLocation`.`lft`, `BusinessLocation`.`rght`, `BusinessLocation`.`name`, `BusinessLocation`.`business_count`, `BusinessLocation`.`is_default`, `BusinessLocation`.`on_popup`, `BusinessLocation`.`enabled`, `BusinessLocation`.`ordering`, `BusinessLocation`.`created`, `BusinessLocation`.`updated`, `BusinessLocation`.`city` FROM `plpb_strascity`.`business_locations` AS `BusinessLocation` WHERE `BusinessLocation`.`is_default` = '1' AND `BusinessLocation`.`parent_id` IS NULL ORDER BY `BusinessLocation`.`ordering` ASC LIMIT 1000
5SELECT `BusinessCategory`.`id`, `BusinessCategory`.`parent_id`, `BusinessCategory`.`lft`, `BusinessCategory`.`rght`, `BusinessCategory`.`name`, `BusinessCategory`.`icon`, `BusinessCategory`.`enable`, `BusinessCategory`.`is_highlight`, `BusinessCategory`.`business_count`, `BusinessCategory`.`ordering`, `BusinessCategory`.`feature_ordering`, `BusinessCategory`.`user_create`, `BusinessCategory`.`created`, `BusinessCategory`.`updated`, (`I18n__nameTranslation`.`content`) AS `BusinessCategory__i18n_nameTranslation` FROM `plpb_strascity`.`business_categories` AS `BusinessCategory` INNER JOIN `plpb_strascity`.`i18n` AS `I18n__nameTranslation` ON (`BusinessCategory`.`id` = `I18n__nameTranslation`.`foreign_key` AND `I18n__nameTranslation`.`model` = 'BusinessCategory' AND `I18n__nameTranslation`.`field` = 'name' AND `I18n__nameTranslation`.`locale` = 'fra') WHERE `BusinessCategory`.`enable` = '1' AND `BusinessCategory`.`id` = 1 ORDER BY `BusinessCategory`.`id` ASC112
6SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content` FROM `plpb_strascity`.`i18n` AS `nameTranslation` WHERE `model` = 'BusinessCategory' AND `field` = 'name' AND `nameTranslation`.`foreign_key` = (1) ORDER BY `id` ASC221
7SELECT `BusinessCategory`.`lft`, `BusinessCategory`.`rght` FROM `plpb_strascity`.`business_categories` AS `BusinessCategory` WHERE 1 = 1 AND `BusinessCategory`.`id` = 1 LIMIT 1110
8SELECT `BusinessCategory`.`id`, `BusinessCategory`.`parent_id`, `BusinessCategory`.`lft`, `BusinessCategory`.`rght`, `BusinessCategory`.`name`, `BusinessCategory`.`icon`, `BusinessCategory`.`enable`, `BusinessCategory`.`is_highlight`, `BusinessCategory`.`business_count`, `BusinessCategory`.`ordering`, `BusinessCategory`.`feature_ordering`, `BusinessCategory`.`user_create`, `BusinessCategory`.`created`, `BusinessCategory`.`updated`, (`I18n__nameTranslation`.`content`) AS `BusinessCategory__i18n_nameTranslation` FROM `plpb_strascity`.`business_categories` AS `BusinessCategory` INNER JOIN `plpb_strascity`.`i18n` AS `I18n__nameTranslation` ON (`BusinessCategory`.`id` = `I18n__nameTranslation`.`foreign_key` AND `I18n__nameTranslation`.`model` = 'BusinessCategory' AND `I18n__nameTranslation`.`field` = 'name' AND `I18n__nameTranslation`.`locale` = 'fra') WHERE 1 = 1 AND `BusinessCategory`.`rght` < 6 AND `BusinessCategory`.`lft` > 1 ORDER BY `BusinessCategory`.`lft` asc221
9SELECT `Business`.`id`, `Business`.`parent_id`, `Business`.`user_id`, `Business`.`creator_id`, `Business`.`album_id`, `Business`.`business_location_id`, `Business`.`business_type_id`, `Business`.`name`, `Business`.`company_number`, `Business`.`description`, `Business`.`logo`, `Business`.`address`, `Business`.`lat`, `Business`.`lng`, `Business`.`postal_code`, `Business`.`email`, `Business`.`phone`, `Business`.`fax`, `Business`.`website`, `Business`.`facebook`, `Business`.`twitter`, `Business`.`linkedin`, `Business`.`youtube`, `Business`.`instagram`, `Business`.`always_open`, `Business`.`timezone`, `Business`.`total_score`, `Business`.`featured`, `Business`.`review_count`, `Business`.`follow_count`, `Business`.`photo_count`, `Business`.`branch_count`, `Business`.`checkin_count`, `Business`.`status`, `Business`.`verify`, `Business`.`is_free`, `Business`.`business_package_id`, `Business`.`claim_id`, `Business`.`is_claim`, `Business`.`permissions`, `Business`.`created`, `Business`.`updated` FROM `plpb_strascity`.`businesses` AS `Business` WHERE `Business`.`status` = 'approved' AND `Business`.`claim_id` = 0 AND `Business`.`id` IN (SELECT business_id FROM business_category_items WHERE business_category_id IN(1,12,13)) ORDER BY `Business`.`featured` DESC LIMIT 10002
10SELECT `BusinessCategory`.`id`, `BusinessCategory`.`parent_id`, `BusinessCategory`.`lft`, `BusinessCategory`.`rght`, `BusinessCategory`.`name`, `BusinessCategory`.`icon`, `BusinessCategory`.`enable`, `BusinessCategory`.`is_highlight`, `BusinessCategory`.`business_count`, `BusinessCategory`.`ordering`, `BusinessCategory`.`feature_ordering`, `BusinessCategory`.`user_create`, `BusinessCategory`.`created`, `BusinessCategory`.`updated`, (`I18n__nameTranslation`.`content`) AS `BusinessCategory__i18n_nameTranslation` FROM `plpb_strascity`.`business_categories` AS `BusinessCategory` INNER JOIN `plpb_strascity`.`i18n` AS `I18n__nameTranslation` ON (`BusinessCategory`.`id` = `I18n__nameTranslation`.`foreign_key` AND `I18n__nameTranslation`.`model` = 'BusinessCategory' AND `I18n__nameTranslation`.`field` = 'name' AND `I18n__nameTranslation`.`locale` = 'fra') WHERE `BusinessCategory`.`enable` = '1' AND `BusinessCategory`.`parent_id` = 0 ORDER BY `BusinessCategory`.`ordering` ASC, `BusinessCategory`.`id` ASC LIMIT 10992
11SELECT `BusinessLocation`.`id` FROM `plpb_strascity`.`business_locations` AS `BusinessLocation` WHERE `BusinessLocation`.`parent_id` = 0 AND `BusinessLocation`.`enabled` = '1' ORDER BY `BusinessLocation`.`ordering` ASC000
12SELECT `BusinessLocation`.`id` FROM `plpb_strascity`.`business_locations` AS `BusinessLocation` WHERE `BusinessLocation`.`parent_id` = 0 AND `BusinessLocation`.`enabled` = '1' ORDER BY `BusinessLocation`.`ordering` ASC000
13SELECT `BusinessLocation`.`id`, `BusinessLocation`.`parent_id`, `BusinessLocation`.`lft`, `BusinessLocation`.`rght`, `BusinessLocation`.`name`, `BusinessLocation`.`business_count`, `BusinessLocation`.`is_default`, `BusinessLocation`.`on_popup`, `BusinessLocation`.`enabled`, `BusinessLocation`.`ordering`, `BusinessLocation`.`created`, `BusinessLocation`.`updated`, `BusinessLocation`.`city` FROM `plpb_strascity`.`business_locations` AS `BusinessLocation` WHERE `BusinessLocation`.`is_default` = '1' AND `BusinessLocation`.`parent_id` IS NULL ORDER BY `BusinessLocation`.`ordering` ASC LIMIT 1000
14SELECT `BusinessLocation`.`id` FROM `plpb_strascity`.`business_locations` AS `BusinessLocation` WHERE `BusinessLocation`.`parent_id` = 0 AND `BusinessLocation`.`enabled` = '1' ORDER BY `BusinessLocation`.`ordering` ASC000
15SELECT `BusinessLocation`.`id`, `BusinessLocation`.`parent_id`, `BusinessLocation`.`lft`, `BusinessLocation`.`rght`, `BusinessLocation`.`name`, `BusinessLocation`.`business_count`, `BusinessLocation`.`is_default`, `BusinessLocation`.`on_popup`, `BusinessLocation`.`enabled`, `BusinessLocation`.`ordering`, `BusinessLocation`.`created`, `BusinessLocation`.`updated`, `BusinessLocation`.`city` FROM `plpb_strascity`.`business_locations` AS `BusinessLocation` WHERE `BusinessLocation`.`is_default` = '1' AND `BusinessLocation`.`parent_id` IS NULL ORDER BY `BusinessLocation`.`ordering` ASC LIMIT 1000
16SELECT `Theme`.`id`, `Theme`.`key`, `Theme`.`name`, `Theme`.`core`, `Theme`.`custom_css_enable`, `Theme`.`custom_css` FROM `plpb_strascity`.`themes` AS `Theme` WHERE `Theme`.`key` = 'default' LIMIT 1111
17SELECT `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 `plpb_strascity`.`settings` AS `Setting` LEFT JOIN `plpb_strascity`.`setting_groups` AS `SettingGroup` ON (`Setting`.`group_id` = `SettingGroup`.`id`) WHERE `Setting`.`name` = 'logo' LIMIT 1111
18SELECT `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 `plpb_strascity`.`settings` AS `Setting` LEFT JOIN `plpb_strascity`.`setting_groups` AS `SettingGroup` ON (`Setting`.`group_id` = `SettingGroup`.`id`) WHERE `Setting`.`name` = 'logo' LIMIT 1111
19SELECT `Theme`.`id`, `Theme`.`key`, `Theme`.`name`, `Theme`.`core`, `Theme`.`custom_css_enable`, `Theme`.`custom_css` FROM `plpb_strascity`.`themes` AS `Theme` WHERE `Theme`.`key` = 'default' LIMIT 1110