Query | Affected | Num. rows | Took (ms) | Actions |
---|
SELECT `BootstrapInstance`.`id`, `BootstrapInstance`.`name`, `BootstrapInstance`.`slug` FROM `johnsonssewing_db`.`prototype_instances` AS `BootstrapInstance` WHERE 1 = 1 | 4 | 4 | 0 | |
SELECT `Permission`.`id`, `Permission`.`plugin`, `Permission`.`controller`, `Permission`.`action`, `Permission`.`resource_id`, `Permission`.`description`, `Permission`.`created`, `Permission`.`modified`, `Permission`.`deleted`, `Permission`.`deleted_date`, (CONCAT_WS(':', NULLIF(`Permission`.`plugin`, ''), NULLIF(`Permission`.`controller`, ''), NULLIF(`Permission`.`action`, ''), NULLIF(`Permission`.`resource_id`, ''))) AS `Permission__name` FROM `johnsonssewing_db`.`permissions` AS `Permission` WHERE `Permission`.`deleted` = '0' ORDER BY `Permission`.`plugin` ASC, `Permission`.`controller` ASC, `Permission`.`action` ASC, `Permission`.`resource_id` ASC | 71 | 71 | 0 | |
SELECT `LoginToken`.`id` FROM `johnsonssewing_db`.`login_tokens` AS `LoginToken` WHERE expires < "2024-10-04 11:13:05" | 0 | 0 | 0 | |
SELECT `Group`.`id`, `Group`.`name`, `Group`.`created`, `Group`.`modified`, `Group`.`login_redirect`, `Group`.`rank`, `Group`.`deleted`, `Group`.`deleted_date` FROM `johnsonssewing_db`.`groups` AS `Group` WHERE `Group`.`name` = 'Unregistered' AND `Group`.`deleted` = '0' ORDER BY `Group`.`rank` ASC, `Group`.`id` ASC, `Group`.`rank` ASC LIMIT 1 | 0 | 0 | 0 | |
SELECT `LoginToken`.`id` FROM `johnsonssewing_db`.`login_tokens` AS `LoginToken` WHERE expires < "2024-10-04 11:13:05" | 0 | 0 | 0 | |
SELECT `Group`.`id`, `Group`.`name`, `Group`.`created`, `Group`.`modified`, `Group`.`login_redirect`, `Group`.`rank`, `Group`.`deleted`, `Group`.`deleted_date` FROM `johnsonssewing_db`.`groups` AS `Group` WHERE `Group`.`name` = 'Unregistered' AND `Group`.`deleted` = '0' ORDER BY `Group`.`rank` ASC, `Group`.`id` ASC, `Group`.`rank` ASC LIMIT 1 | 0 | 0 | 0 | |
SELECT `LoginToken`.`id` FROM `johnsonssewing_db`.`login_tokens` AS `LoginToken` WHERE expires < "2024-10-04 11:13:05" | 0 | 0 | 0 | |
SELECT `Group`.`id`, `Group`.`name`, `Group`.`created`, `Group`.`modified`, `Group`.`login_redirect`, `Group`.`rank`, `Group`.`deleted`, `Group`.`deleted_date` FROM `johnsonssewing_db`.`groups` AS `Group` WHERE `Group`.`name` = 'Unregistered' AND `Group`.`deleted` = '0' ORDER BY `Group`.`rank` ASC, `Group`.`id` ASC, `Group`.`rank` ASC LIMIT 1 | 0 | 0 | 0 | |
SELECT `Inventory`.`id`, `Inventory`.`created`, `Inventory`.`modified`, `Inventory`.`name`, `Inventory`.`description`, `Inventory`.`rank`, `Inventory`.`slug`, `Inventory`.`viewed`, `Inventory`.`deleted`, `Inventory`.`deleted_date`, `Inventory`.`price`, `Inventory`.`features`, `Inventory`.`specifications`, `Inventory`.`link`, `Inventory`.`link_label`, `Inventory`.`link_2`, `Inventory`.`link_2_label`, `Inventory`.`summary_features`, `Inventory`.`standard_buy_line`, `Inventory`.`feature_buy_line`, `Inventory`.`clearance_savings_amount`, `Inventory`.`highlighted_buy_line`, `Inventory`.`email_specials_standard_buy_line`, `Inventory`.`email_specials_feature_buy_line`, `Inventory`.`email_specials_highlighted_buy_line`, `Inventory`.`featured`, `Inventory`.`for_sale_online`, `Inventory`.`cost`, `Inventory`.`environment_fee`, `Inventory`.`free_shipping`, `Inventory`.`additional_shipping`, `Inventory`.`tax_exempt`, `PublishingInformation`.`id`, `PublishingInformation`.`created`, `PublishingInformation`.`modified`, `PublishingInformation`.`model`, `PublishingInformation`.`foreign_key`, `PublishingInformation`.`start`, `PublishingInformation`.`end`, `PublishingInformation`.`published` FROM `johnsonssewing_db`.`inventories` AS `Inventory` LEFT JOIN `johnsonssewing_db`.`publishing_information` AS `PublishingInformation` ON (`PublishingInformation`.`foreign_key` = `Inventory`.`id` AND `PublishingInformation`.`model` = 'Inventory') WHERE `Inventory`.`slug` = 'tula-pink-tiny-beasts' AND `Inventory`.`deleted` = '0' AND `PublishingInformation`.`published` = '1' AND `PublishingInformation`.`start` <= '2024-10-04 11:13:05' AND ((`PublishingInformation`.`end` IS NULL) OR (`PublishingInformation`.`end` > '2024-10-04 11:13:05')) ORDER BY `Inventory`.`rank` ASC LIMIT 1 | 1 | 1 | 25 | maybe slow |
SELECT `Image`.`id`, `Image`.`model`, `Image`.`foreign_key`, `Image`.`dirname`, `Image`.`basename`, `Image`.`checksum`, `Image`.`alternative`, `Image`.`group`, `Image`.`created`, `Image`.`modified`, `Image`.`rank`, `Image`.`deleted`, `Image`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Image__path` FROM `johnsonssewing_db`.`attachments` AS `Image` WHERE `Image`.`model` = 'Inventory' AND `Image`.`group` = 'Image' AND `Image`.`foreign_key` = (2862) ORDER BY `Image`.`rank` ASC, `Image`.`id` ASC | 4 | 4 | 1 | maybe slow |
SELECT `Document`.`id`, `Document`.`model`, `Document`.`foreign_key`, `Document`.`dirname`, `Document`.`basename`, `Document`.`checksum`, `Document`.`alternative`, `Document`.`group`, `Document`.`created`, `Document`.`modified`, `Document`.`rank`, `Document`.`deleted`, `Document`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Document__path` FROM `johnsonssewing_db`.`attachments` AS `Document` WHERE `Document`.`model` = 'Inventory' AND `Document`.`group` = 'Document' AND `Document`.`foreign_key` = (2862) ORDER BY `Document`.`rank` ASC, `Document`.`id` ASC | 0 | 0 | 0 | |
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `johnsonssewing_db`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'Inventory' AND `MetaValue`.`foreign_key` = (2862) | 0 | 0 | 0 | |
SELECT `InventoryCategory`.`id`, `InventoryCategory`.`created`, `InventoryCategory`.`modified`, `InventoryCategory`.`name`, `InventoryCategory`.`page_title`, `InventoryCategory`.`description`, `InventoryCategory`.`rank`, `InventoryCategory`.`slug`, `InventoryCategory`.`lft`, `InventoryCategory`.`rght`, `InventoryCategory`.`parent_id`, `InventoryCategory`.`inventory_count`, `InventoryCategory`.`deleted`, `InventoryCategory`.`deleted_date`, `InventoryCategory`.`display_publicly`, `InventoriesInventoryCategory`.`id`, `InventoriesInventoryCategory`.`inventory_id`, `InventoriesInventoryCategory`.`inventory_category_id`, `InventoriesInventoryCategory`.`rank` FROM `johnsonssewing_db`.`inventory_categories` AS `InventoryCategory` JOIN `johnsonssewing_db`.`inventories_inventory_categories` AS `InventoriesInventoryCategory` ON (`InventoriesInventoryCategory`.`inventory_id` = 2862 AND `InventoriesInventoryCategory`.`inventory_category_id` = `InventoryCategory`.`id`) | 1 | 1 | 1 | |
SELECT COUNT(*) AS `count` FROM `johnsonssewing_db`.`inventories` AS `Inventory` WHERE `Inventory`.`id` = 2862 | 1 | 1 | 0 | |
SELECT COUNT(*) AS `count` FROM `johnsonssewing_db`.`inventories` AS `Inventory` WHERE `Inventory`.`id` = 2862 | 1 | 1 | 0 | |
UPDATE `johnsonssewing_db`.`inventories` SET `viewed` = 609, `modified` = '2024-10-04 11:13:05' WHERE `johnsonssewing_db`.`inventories`.`id` = '2862' | 1 | 1 | 1 | |
SELECT
COUNT(InventoryInventoryCategory.inventory_id) AS the_count
, InventoryInventoryCategory.inventory_category_id
FROM
inventories_inventory_categories AS InventoryInventoryCategory
INNER JOIN
inventories AS Inventory
ON
Inventory.id = InventoryInventoryCategory.inventory_id AND Inventory.deleted = 0
INNER JOIN
publishing_information AS PublishingInformation
ON
PublishingInformation.model = 'Inventory'
AND
PublishingInformation.foreign_key = Inventory.id
AND
PublishingInformation.published = 1
AND
(
PublishingInformation.start <= NOW()
AND
(
PublishingInformation.end IS NULL
OR
PublishingInformation.end >= NOW()
)
)
GROUP BY
InventoryInventoryCategory.inventory_category_id | 29 | 29 | 5 | maybe slow |
SELECT `InventoryCategory`.`id`, `InventoryCategory`.`name` FROM `johnsonssewing_db`.`inventory_categories` AS `InventoryCategory` LEFT JOIN `johnsonssewing_db`.`publishing_information` AS `PublishingInformation` ON (`PublishingInformation`.`foreign_key` = `InventoryCategory`.`id` AND `PublishingInformation`.`model` = 'InventoryCategory') WHERE `InventoryCategory`.`deleted` = '0' | 32 | 32 | 0 | |
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `johnsonssewing_db`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'InventoryCategory' AND `MetaValue`.`foreign_key` IN (5, 6, 7, 8, 10, 11, 12, 19, 20, 24, 27, 29, 31, 32, 33, 35, 36, 37, 38, 42, 50, 55, 58, 59, 61, 62, 63, 64, 65, 66, 67, 68) | 128 | 128 | 1 | |
SELECT COUNT(*) AS `count` FROM `johnsonssewing_db`.`inventory_categories` AS `InventoryCategory` WHERE `InventoryCategory`.`id` = 5 | 1 | 1 | 0 | |
SELECT COUNT(*) AS `count` FROM `johnsonssewing_db`.`inventory_categories` AS `InventoryCategory` WHERE `InventoryCategory`.`id` = 6 | 1 | 1 | 0 | |
SELECT COUNT(*) AS `count` FROM `johnsonssewing_db`.`inventory_categories` AS `InventoryCategory` WHERE `InventoryCategory`.`id` = 7 | 1 | 1 | 0 | |
SELECT COUNT(*) AS `count` FROM `johnsonssewing_db`.`inventory_categories` AS `InventoryCategory` WHERE `InventoryCategory`.`id` = 8 | 1 | 1 | 0 | |
SELECT COUNT(*) AS `count` FROM `johnsonssewing_db`.`inventory_categories` AS `InventoryCategory` WHERE `InventoryCategory`.`id` = 10 | 1 | 1 | 0 | |
SELECT COUNT(*) AS `count` FROM `johnsonssewing_db`.`inventory_categories` AS `InventoryCategory` WHERE `InventoryCategory`.`id` = 11 | 1 | 1 | 0 | |
SELECT COUNT(*) AS `count` FROM `johnsonssewing_db`.`inventory_categories` AS `InventoryCategory` WHERE `InventoryCategory`.`id` = 12 | 1 | 1 | 0 | |
SELECT COUNT(*) AS `count` FROM `johnsonssewing_db`.`inventory_categories` AS `InventoryCategory` WHERE `InventoryCategory`.`id` = 19 | 1 | 1 | 0 | |
SELECT COUNT(*) AS `count` FROM `johnsonssewing_db`.`inventory_categories` AS `InventoryCategory` WHERE `InventoryCategory`.`id` = 20 | 1 | 1 | 0 | |
SELECT COUNT(*) AS `count` FROM `johnsonssewing_db`.`inventory_categories` AS `InventoryCategory` WHERE `InventoryCategory`.`id` = 24 | 1 | 1 | 0 | |
SELECT COUNT(*) AS `count` FROM `johnsonssewing_db`.`inventory_categories` AS `InventoryCategory` WHERE `InventoryCategory`.`id` = 27 | 1 | 1 | 0 | |
SELECT COUNT(*) AS `count` FROM `johnsonssewing_db`.`inventory_categories` AS `InventoryCategory` WHERE `InventoryCategory`.`id` = 29 | 1 | 1 | 0 | |
SELECT COUNT(*) AS `count` FROM `johnsonssewing_db`.`inventory_categories` AS `InventoryCategory` WHERE `InventoryCategory`.`id` = 31 | 1 | 1 | 0 | |
SELECT COUNT(*) AS `count` FROM `johnsonssewing_db`.`inventory_categories` AS `InventoryCategory` WHERE `InventoryCategory`.`id` = 32 | 1 | 1 | 0 | |
SELECT COUNT(*) AS `count` FROM `johnsonssewing_db`.`inventory_categories` AS `InventoryCategory` WHERE `InventoryCategory`.`id` = 33 | 1 | 1 | 0 | |
SELECT COUNT(*) AS `count` FROM `johnsonssewing_db`.`inventory_categories` AS `InventoryCategory` WHERE `InventoryCategory`.`id` = 35 | 1 | 1 | 0 | |
SELECT COUNT(*) AS `count` FROM `johnsonssewing_db`.`inventory_categories` AS `InventoryCategory` WHERE `InventoryCategory`.`id` = 37 | 1 | 1 | 0 | |
SELECT COUNT(*) AS `count` FROM `johnsonssewing_db`.`inventory_categories` AS `InventoryCategory` WHERE `InventoryCategory`.`id` = 38 | 1 | 1 | 0 | |
SELECT COUNT(*) AS `count` FROM `johnsonssewing_db`.`inventory_categories` AS `InventoryCategory` WHERE `InventoryCategory`.`id` = 42 | 1 | 1 | 0 | |
SELECT COUNT(*) AS `count` FROM `johnsonssewing_db`.`inventory_categories` AS `InventoryCategory` WHERE `InventoryCategory`.`id` = 50 | 1 | 1 | 0 | |
SELECT COUNT(*) AS `count` FROM `johnsonssewing_db`.`inventory_categories` AS `InventoryCategory` WHERE `InventoryCategory`.`id` = 55 | 1 | 1 | 0 | |
SELECT COUNT(*) AS `count` FROM `johnsonssewing_db`.`inventory_categories` AS `InventoryCategory` WHERE `InventoryCategory`.`id` = 58 | 1 | 1 | 0 | |
SELECT COUNT(*) AS `count` FROM `johnsonssewing_db`.`inventory_categories` AS `InventoryCategory` WHERE `InventoryCategory`.`id` = 59 | 1 | 1 | 0 | |
SELECT COUNT(*) AS `count` FROM `johnsonssewing_db`.`inventory_categories` AS `InventoryCategory` WHERE `InventoryCategory`.`id` = 61 | 1 | 1 | 0 | |
SELECT COUNT(*) AS `count` FROM `johnsonssewing_db`.`inventory_categories` AS `InventoryCategory` WHERE `InventoryCategory`.`id` = 62 | 1 | 1 | 0 | |
SELECT COUNT(*) AS `count` FROM `johnsonssewing_db`.`inventory_categories` AS `InventoryCategory` WHERE `InventoryCategory`.`id` = 63 | 1 | 1 | 0 | |
SELECT COUNT(*) AS `count` FROM `johnsonssewing_db`.`inventory_categories` AS `InventoryCategory` WHERE `InventoryCategory`.`id` = 64 | 1 | 1 | 0 | |
SELECT COUNT(*) AS `count` FROM `johnsonssewing_db`.`inventory_categories` AS `InventoryCategory` WHERE `InventoryCategory`.`id` = 65 | 1 | 1 | 0 | |
SELECT COUNT(*) AS `count` FROM `johnsonssewing_db`.`inventory_categories` AS `InventoryCategory` WHERE `InventoryCategory`.`id` = 68 | 1 | 1 | 0 | |
SELECT COUNT(*) AS `count` FROM `johnsonssewing_db`.`inventory_categories` AS `InventoryCategory` WHERE `InventoryCategory`.`id` = 36 | 1 | 1 | 0 | |
SELECT COUNT(*) AS `count` FROM `johnsonssewing_db`.`inventory_categories` AS `InventoryCategory` WHERE `InventoryCategory`.`id` = 66 | 1 | 1 | 0 | |
SELECT COUNT(*) AS `count` FROM `johnsonssewing_db`.`inventory_categories` AS `InventoryCategory` WHERE `InventoryCategory`.`id` = 67 | 1 | 1 | 0 | |
SELECT `Page`.`id`, `Page`.`created`, `Page`.`modified`, `Page`.`internal_name`, `Page`.`title`, `Page`.`page_heading`, `Page`.`content`, `Page`.`slug`, `Page`.`path`, `Page`.`parent_id`, `Page`.`lft`, `Page`.`rght`, `Page`.`layout`, `Page`.`plugin`, `Page`.`controller`, `Page`.`action`, `Page`.`extra`, `Page`.`protected`, `Page`.`exclude_sitemap`, `Page`.`deleted`, `Page`.`deleted_date`, `Page`.`password`, `Page`.`published`, `Page`.`extra_header_code`, `Page`.`extra_footer_code`, `Page`.`override_title_format`, `Page`.`super_admin`, (CONCAT_WS('/', NULLIF(`Page`.`plugin`, ''), NULLIF(`Page`.`controller`, ''), NULLIF(`Page`.`action`, ''), NULLIF(`Page`.`extra`, ''))) AS `Page__action_map` FROM `johnsonssewing_db`.`pages` AS `Page` WHERE `controller` = 'inventories' AND `action` = 'view' AND `extra` = 'tula-pink-tiny-beasts' AND `Page`.`deleted` = '0' LIMIT 1 | 0 | 0 | 0 | |
SELECT `Page`.`id`, `Page`.`created`, `Page`.`modified`, `Page`.`internal_name`, `Page`.`title`, `Page`.`page_heading`, `Page`.`content`, `Page`.`slug`, `Page`.`path`, `Page`.`parent_id`, `Page`.`lft`, `Page`.`rght`, `Page`.`layout`, `Page`.`plugin`, `Page`.`controller`, `Page`.`action`, `Page`.`extra`, `Page`.`protected`, `Page`.`exclude_sitemap`, `Page`.`deleted`, `Page`.`deleted_date`, `Page`.`password`, `Page`.`published`, `Page`.`extra_header_code`, `Page`.`extra_footer_code`, `Page`.`override_title_format`, `Page`.`super_admin`, (CONCAT_WS('/', NULLIF(`Page`.`plugin`, ''), NULLIF(`Page`.`controller`, ''), NULLIF(`Page`.`action`, ''), NULLIF(`Page`.`extra`, ''))) AS `Page__action_map` FROM `johnsonssewing_db`.`pages` AS `Page` WHERE `controller` = 'inventories' AND `action` = 'view' AND `Page`.`deleted` = '0' LIMIT 1 | 0 | 0 | 0 | |
SELECT `InventoryCategory`.`id`, `InventoryCategory`.`created`, `InventoryCategory`.`modified`, `InventoryCategory`.`name`, `InventoryCategory`.`page_title`, `InventoryCategory`.`description`, `InventoryCategory`.`rank`, `InventoryCategory`.`slug`, `InventoryCategory`.`lft`, `InventoryCategory`.`rght`, `InventoryCategory`.`parent_id`, `InventoryCategory`.`inventory_count`, `InventoryCategory`.`deleted`, `InventoryCategory`.`deleted_date`, `InventoryCategory`.`display_publicly`, `PublishingInformation`.`id`, `PublishingInformation`.`created`, `PublishingInformation`.`modified`, `PublishingInformation`.`model`, `PublishingInformation`.`foreign_key`, `PublishingInformation`.`start`, `PublishingInformation`.`end`, `PublishingInformation`.`published` FROM `johnsonssewing_db`.`inventory_categories` AS `InventoryCategory` LEFT JOIN `johnsonssewing_db`.`publishing_information` AS `PublishingInformation` ON (`PublishingInformation`.`foreign_key` = `InventoryCategory`.`id` AND `PublishingInformation`.`model` = 'InventoryCategory') WHERE `InventoryCategory`.`parent_id` IS NULL AND `InventoryCategory`.`deleted` = '0' AND `InventoryCategory`.`inventory_count` > 0 AND `PublishingInformation`.`published` = '1' AND `PublishingInformation`.`start` <= '2024-10-04 11:13:05' AND ((`PublishingInformation`.`end` IS NULL) OR (`PublishingInformation`.`end` > '2024-10-04 11:13:05')) | 13 | 13 | 0 | |
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `johnsonssewing_db`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'InventoryCategory' AND `MetaValue`.`foreign_key` IN (5, 6, 7, 10, 20, 27, 29, 31, 42, 50, 55, 58, 59) | 52 | 52 | 0 | |
SELECT `Page`.`id`, `Page`.`created`, `Page`.`modified`, `Page`.`internal_name`, `Page`.`title`, `Page`.`page_heading`, `Page`.`content`, `Page`.`slug`, `Page`.`path`, `Page`.`parent_id`, `Page`.`lft`, `Page`.`rght`, `Page`.`layout`, `Page`.`plugin`, `Page`.`controller`, `Page`.`action`, `Page`.`extra`, `Page`.`protected`, `Page`.`exclude_sitemap`, `Page`.`deleted`, `Page`.`deleted_date`, `Page`.`password`, `Page`.`published`, `Page`.`extra_header_code`, `Page`.`extra_footer_code`, `Page`.`override_title_format`, `Page`.`super_admin`, (CONCAT_WS('/', NULLIF(`Page`.`plugin`, ''), NULLIF(`Page`.`controller`, ''), NULLIF(`Page`.`action`, ''), NULLIF(`Page`.`extra`, ''))) AS `Page__action_map` FROM `johnsonssewing_db`.`pages` AS `Page` WHERE `controller` = 'inventories' AND `action` = 'view' AND `extra` = 'tula-pink-tiny-beasts' AND `Page`.`deleted` = '0' LIMIT 1 | 0 | 0 | 0 | |
SELECT `Page`.`id`, `Page`.`created`, `Page`.`modified`, `Page`.`internal_name`, `Page`.`title`, `Page`.`page_heading`, `Page`.`content`, `Page`.`slug`, `Page`.`path`, `Page`.`parent_id`, `Page`.`lft`, `Page`.`rght`, `Page`.`layout`, `Page`.`plugin`, `Page`.`controller`, `Page`.`action`, `Page`.`extra`, `Page`.`protected`, `Page`.`exclude_sitemap`, `Page`.`deleted`, `Page`.`deleted_date`, `Page`.`password`, `Page`.`published`, `Page`.`extra_header_code`, `Page`.`extra_footer_code`, `Page`.`override_title_format`, `Page`.`super_admin`, (CONCAT_WS('/', NULLIF(`Page`.`plugin`, ''), NULLIF(`Page`.`controller`, ''), NULLIF(`Page`.`action`, ''), NULLIF(`Page`.`extra`, ''))) AS `Page__action_map` FROM `johnsonssewing_db`.`pages` AS `Page` WHERE `controller` = 'inventories' AND `action` = 'view' AND `Page`.`deleted` = '0' LIMIT 1 | 0 | 0 | 0 | |
SELECT `MetaKey`.`id`, `MetaKey`.`name`, `MetaKey`.`default`, `MetaKey`.`allow_default` FROM `johnsonssewing_db`.`meta_keys` AS `MetaKey` WHERE 1 = 1 ORDER BY `MetaKey`.`rank` ASC | 4 | 4 | 0 | |
SELECT `AttachmentVersion`.`id`, `AttachmentVersion`.`created`, `AttachmentVersion`.`modified`, `AttachmentVersion`.`model`, `AttachmentVersion`.`foreign_key`, `AttachmentVersion`.`group`, `AttachmentVersion`.`name`, `AttachmentVersion`.`type`, `AttachmentVersion`.`convert`, `AttachmentVersion`.`width`, `AttachmentVersion`.`height`, `AttachmentVersion`.`bgcolour`, `AttachmentVersion`.`gravity`, `AttachmentVersion`.`deleted`, `AttachmentVersion`.`deleted_date` FROM `johnsonssewing_db`.`attachment_versions` AS `AttachmentVersion` WHERE `AttachmentVersion`.`deleted` = '0' | 58 | 58 | 0 | |
SELECT `Setting`.`id`, `Setting`.`created`, `Setting`.`rank`, `Setting`.`modified`, `Setting`.`key`, `Setting`.`value`, `Setting`.`title`, `Setting`.`description`, `Setting`.`type`, `Setting`.`editable`, `Setting`.`super_admin`, `Setting`.`options`, `Setting`.`method`, `Setting`.`display`, (REPLACE(CONCAT(UPPER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1), 1, 1)), LOWER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1) FROM 2))), '_', ' ')) AS `Setting__tinyMceOption` FROM `johnsonssewing_db`.`settings` AS `Setting` WHERE `Setting`.`key` = 'Site.Bing.verification_code' ORDER BY `Setting`.`rank` ASC LIMIT 1 | 1 | 1 | 0 | |
SELECT `Image`.`id`, `Image`.`model`, `Image`.`foreign_key`, `Image`.`dirname`, `Image`.`basename`, `Image`.`checksum`, `Image`.`alternative`, `Image`.`group`, `Image`.`created`, `Image`.`modified`, `Image`.`rank`, `Image`.`deleted`, `Image`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Image__path` FROM `johnsonssewing_db`.`attachments` AS `Image` WHERE `Image`.`model` = 'Setting' AND `Image`.`group` = 'Image' AND `Image`.`foreign_key` = (21) ORDER BY `Image`.`rank` ASC, `Image`.`id` ASC | 0 | 0 | 0 | |
SELECT `Document`.`id`, `Document`.`model`, `Document`.`foreign_key`, `Document`.`dirname`, `Document`.`basename`, `Document`.`checksum`, `Document`.`alternative`, `Document`.`group`, `Document`.`created`, `Document`.`modified`, `Document`.`rank`, `Document`.`deleted`, `Document`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Document__path` FROM `johnsonssewing_db`.`attachments` AS `Document` WHERE `Document`.`model` = 'Setting' AND `Document`.`group` = 'Document' AND `Document`.`foreign_key` = (21) ORDER BY `Document`.`rank` ASC | 0 | 0 | 0 | |
SELECT `MetaKey`.`id`, `MetaKey`.`created`, `MetaKey`.`modified`, `MetaKey`.`name`, `MetaKey`.`type`, `MetaKey`.`default`, `MetaKey`.`rank`, `MetaKey`.`allow_default` FROM `johnsonssewing_db`.`meta_keys` AS `MetaKey` WHERE 1 = 1 ORDER BY `MetaKey`.`rank` ASC | 4 | 4 | 0 | |
SELECT `Setting`.`id`, `Setting`.`created`, `Setting`.`rank`, `Setting`.`modified`, `Setting`.`key`, `Setting`.`value`, `Setting`.`title`, `Setting`.`description`, `Setting`.`type`, `Setting`.`editable`, `Setting`.`super_admin`, `Setting`.`options`, `Setting`.`method`, `Setting`.`display`, (REPLACE(CONCAT(UPPER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1), 1, 1)), LOWER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1) FROM 2))), '_', ' ')) AS `Setting__tinyMceOption` FROM `johnsonssewing_db`.`settings` AS `Setting` WHERE `Setting`.`key` = 'Site.Contact.hours' ORDER BY `Setting`.`rank` ASC LIMIT 1 | 1 | 1 | 0 | |
SELECT `Image`.`id`, `Image`.`model`, `Image`.`foreign_key`, `Image`.`dirname`, `Image`.`basename`, `Image`.`checksum`, `Image`.`alternative`, `Image`.`group`, `Image`.`created`, `Image`.`modified`, `Image`.`rank`, `Image`.`deleted`, `Image`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Image__path` FROM `johnsonssewing_db`.`attachments` AS `Image` WHERE `Image`.`model` = 'Setting' AND `Image`.`group` = 'Image' AND `Image`.`foreign_key` = (45) ORDER BY `Image`.`rank` ASC, `Image`.`id` ASC | 0 | 0 | 0 | |
SELECT `Document`.`id`, `Document`.`model`, `Document`.`foreign_key`, `Document`.`dirname`, `Document`.`basename`, `Document`.`checksum`, `Document`.`alternative`, `Document`.`group`, `Document`.`created`, `Document`.`modified`, `Document`.`rank`, `Document`.`deleted`, `Document`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Document__path` FROM `johnsonssewing_db`.`attachments` AS `Document` WHERE `Document`.`model` = 'Setting' AND `Document`.`group` = 'Document' AND `Document`.`foreign_key` = (45) ORDER BY `Document`.`rank` ASC | 0 | 0 | 0 | |
SELECT `Setting`.`id`, `Setting`.`created`, `Setting`.`rank`, `Setting`.`modified`, `Setting`.`key`, `Setting`.`value`, `Setting`.`title`, `Setting`.`description`, `Setting`.`type`, `Setting`.`editable`, `Setting`.`super_admin`, `Setting`.`options`, `Setting`.`method`, `Setting`.`display`, (REPLACE(CONCAT(UPPER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1), 1, 1)), LOWER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1) FROM 2))), '_', ' ')) AS `Setting__tinyMceOption` FROM `johnsonssewing_db`.`settings` AS `Setting` WHERE `Setting`.`key` = 'Site.name' ORDER BY `Setting`.`rank` ASC LIMIT 1 | 1 | 1 | 0 | |
SELECT `Image`.`id`, `Image`.`model`, `Image`.`foreign_key`, `Image`.`dirname`, `Image`.`basename`, `Image`.`checksum`, `Image`.`alternative`, `Image`.`group`, `Image`.`created`, `Image`.`modified`, `Image`.`rank`, `Image`.`deleted`, `Image`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Image__path` FROM `johnsonssewing_db`.`attachments` AS `Image` WHERE `Image`.`model` = 'Setting' AND `Image`.`group` = 'Image' AND `Image`.`foreign_key` = (1) ORDER BY `Image`.`rank` ASC, `Image`.`id` ASC | 0 | 0 | 0 | |
SELECT `Document`.`id`, `Document`.`model`, `Document`.`foreign_key`, `Document`.`dirname`, `Document`.`basename`, `Document`.`checksum`, `Document`.`alternative`, `Document`.`group`, `Document`.`created`, `Document`.`modified`, `Document`.`rank`, `Document`.`deleted`, `Document`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Document__path` FROM `johnsonssewing_db`.`attachments` AS `Document` WHERE `Document`.`model` = 'Setting' AND `Document`.`group` = 'Document' AND `Document`.`foreign_key` = (1) ORDER BY `Document`.`rank` ASC | 0 | 0 | 0 | |
SELECT `Setting`.`id`, `Setting`.`created`, `Setting`.`rank`, `Setting`.`modified`, `Setting`.`key`, `Setting`.`value`, `Setting`.`title`, `Setting`.`description`, `Setting`.`type`, `Setting`.`editable`, `Setting`.`super_admin`, `Setting`.`options`, `Setting`.`method`, `Setting`.`display`, (REPLACE(CONCAT(UPPER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1), 1, 1)), LOWER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1) FROM 2))), '_', ' ')) AS `Setting__tinyMceOption` FROM `johnsonssewing_db`.`settings` AS `Setting` WHERE `Setting`.`key` = 'Site.Contact.pinterest' ORDER BY `Setting`.`rank` ASC LIMIT 1 | 1 | 1 | 0 | |
SELECT `Image`.`id`, `Image`.`model`, `Image`.`foreign_key`, `Image`.`dirname`, `Image`.`basename`, `Image`.`checksum`, `Image`.`alternative`, `Image`.`group`, `Image`.`created`, `Image`.`modified`, `Image`.`rank`, `Image`.`deleted`, `Image`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Image__path` FROM `johnsonssewing_db`.`attachments` AS `Image` WHERE `Image`.`model` = 'Setting' AND `Image`.`group` = 'Image' AND `Image`.`foreign_key` = (47) ORDER BY `Image`.`rank` ASC, `Image`.`id` ASC | 0 | 0 | 0 | |
SELECT `Document`.`id`, `Document`.`model`, `Document`.`foreign_key`, `Document`.`dirname`, `Document`.`basename`, `Document`.`checksum`, `Document`.`alternative`, `Document`.`group`, `Document`.`created`, `Document`.`modified`, `Document`.`rank`, `Document`.`deleted`, `Document`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Document__path` FROM `johnsonssewing_db`.`attachments` AS `Document` WHERE `Document`.`model` = 'Setting' AND `Document`.`group` = 'Document' AND `Document`.`foreign_key` = (47) ORDER BY `Document`.`rank` ASC | 0 | 0 | 0 | |
SELECT `Setting`.`id`, `Setting`.`created`, `Setting`.`rank`, `Setting`.`modified`, `Setting`.`key`, `Setting`.`value`, `Setting`.`title`, `Setting`.`description`, `Setting`.`type`, `Setting`.`editable`, `Setting`.`super_admin`, `Setting`.`options`, `Setting`.`method`, `Setting`.`display`, (REPLACE(CONCAT(UPPER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1), 1, 1)), LOWER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1) FROM 2))), '_', ' ')) AS `Setting__tinyMceOption` FROM `johnsonssewing_db`.`settings` AS `Setting` WHERE `Setting`.`key` = 'Site.Contact.instagram' ORDER BY `Setting`.`rank` ASC LIMIT 1 | 1 | 1 | 0 | |
SELECT `Image`.`id`, `Image`.`model`, `Image`.`foreign_key`, `Image`.`dirname`, `Image`.`basename`, `Image`.`checksum`, `Image`.`alternative`, `Image`.`group`, `Image`.`created`, `Image`.`modified`, `Image`.`rank`, `Image`.`deleted`, `Image`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Image__path` FROM `johnsonssewing_db`.`attachments` AS `Image` WHERE `Image`.`model` = 'Setting' AND `Image`.`group` = 'Image' AND `Image`.`foreign_key` = (55) ORDER BY `Image`.`rank` ASC, `Image`.`id` ASC | 0 | 0 | 0 | |
SELECT `Document`.`id`, `Document`.`model`, `Document`.`foreign_key`, `Document`.`dirname`, `Document`.`basename`, `Document`.`checksum`, `Document`.`alternative`, `Document`.`group`, `Document`.`created`, `Document`.`modified`, `Document`.`rank`, `Document`.`deleted`, `Document`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Document__path` FROM `johnsonssewing_db`.`attachments` AS `Document` WHERE `Document`.`model` = 'Setting' AND `Document`.`group` = 'Document' AND `Document`.`foreign_key` = (55) ORDER BY `Document`.`rank` ASC | 0 | 0 | 0 | |
SELECT `Setting`.`id`, `Setting`.`created`, `Setting`.`rank`, `Setting`.`modified`, `Setting`.`key`, `Setting`.`value`, `Setting`.`title`, `Setting`.`description`, `Setting`.`type`, `Setting`.`editable`, `Setting`.`super_admin`, `Setting`.`options`, `Setting`.`method`, `Setting`.`display`, (REPLACE(CONCAT(UPPER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1), 1, 1)), LOWER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1) FROM 2))), '_', ' ')) AS `Setting__tinyMceOption` FROM `johnsonssewing_db`.`settings` AS `Setting` WHERE `Setting`.`key` = 'Site.Contact.instagram' ORDER BY `Setting`.`rank` ASC LIMIT 1 | 1 | 1 | 0 | |
SELECT `Image`.`id`, `Image`.`model`, `Image`.`foreign_key`, `Image`.`dirname`, `Image`.`basename`, `Image`.`checksum`, `Image`.`alternative`, `Image`.`group`, `Image`.`created`, `Image`.`modified`, `Image`.`rank`, `Image`.`deleted`, `Image`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Image__path` FROM `johnsonssewing_db`.`attachments` AS `Image` WHERE `Image`.`model` = 'Setting' AND `Image`.`group` = 'Image' AND `Image`.`foreign_key` = (55) ORDER BY `Image`.`rank` ASC, `Image`.`id` ASC | 0 | 0 | 0 | |
SELECT `Document`.`id`, `Document`.`model`, `Document`.`foreign_key`, `Document`.`dirname`, `Document`.`basename`, `Document`.`checksum`, `Document`.`alternative`, `Document`.`group`, `Document`.`created`, `Document`.`modified`, `Document`.`rank`, `Document`.`deleted`, `Document`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Document__path` FROM `johnsonssewing_db`.`attachments` AS `Document` WHERE `Document`.`model` = 'Setting' AND `Document`.`group` = 'Document' AND `Document`.`foreign_key` = (55) ORDER BY `Document`.`rank` ASC | 0 | 0 | 0 | |
SELECT `Setting`.`id`, `Setting`.`created`, `Setting`.`rank`, `Setting`.`modified`, `Setting`.`key`, `Setting`.`value`, `Setting`.`title`, `Setting`.`description`, `Setting`.`type`, `Setting`.`editable`, `Setting`.`super_admin`, `Setting`.`options`, `Setting`.`method`, `Setting`.`display`, (REPLACE(CONCAT(UPPER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1), 1, 1)), LOWER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1) FROM 2))), '_', ' ')) AS `Setting__tinyMceOption` FROM `johnsonssewing_db`.`settings` AS `Setting` WHERE `Setting`.`key` = 'Site.Contact.facebook' ORDER BY `Setting`.`rank` ASC LIMIT 1 | 1 | 1 | 0 | |
SELECT `Image`.`id`, `Image`.`model`, `Image`.`foreign_key`, `Image`.`dirname`, `Image`.`basename`, `Image`.`checksum`, `Image`.`alternative`, `Image`.`group`, `Image`.`created`, `Image`.`modified`, `Image`.`rank`, `Image`.`deleted`, `Image`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Image__path` FROM `johnsonssewing_db`.`attachments` AS `Image` WHERE `Image`.`model` = 'Setting' AND `Image`.`group` = 'Image' AND `Image`.`foreign_key` = (46) ORDER BY `Image`.`rank` ASC, `Image`.`id` ASC | 0 | 0 | 0 | |
SELECT `Document`.`id`, `Document`.`model`, `Document`.`foreign_key`, `Document`.`dirname`, `Document`.`basename`, `Document`.`checksum`, `Document`.`alternative`, `Document`.`group`, `Document`.`created`, `Document`.`modified`, `Document`.`rank`, `Document`.`deleted`, `Document`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Document__path` FROM `johnsonssewing_db`.`attachments` AS `Document` WHERE `Document`.`model` = 'Setting' AND `Document`.`group` = 'Document' AND `Document`.`foreign_key` = (46) ORDER BY `Document`.`rank` ASC | 0 | 0 | 0 | |
SELECT `Setting`.`id`, `Setting`.`created`, `Setting`.`rank`, `Setting`.`modified`, `Setting`.`key`, `Setting`.`value`, `Setting`.`title`, `Setting`.`description`, `Setting`.`type`, `Setting`.`editable`, `Setting`.`super_admin`, `Setting`.`options`, `Setting`.`method`, `Setting`.`display`, (REPLACE(CONCAT(UPPER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1), 1, 1)), LOWER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1) FROM 2))), '_', ' ')) AS `Setting__tinyMceOption` FROM `johnsonssewing_db`.`settings` AS `Setting` WHERE `Setting`.`key` = 'Site.Contact.facebook' ORDER BY `Setting`.`rank` ASC LIMIT 1 | 1 | 1 | 0 | |
SELECT `Image`.`id`, `Image`.`model`, `Image`.`foreign_key`, `Image`.`dirname`, `Image`.`basename`, `Image`.`checksum`, `Image`.`alternative`, `Image`.`group`, `Image`.`created`, `Image`.`modified`, `Image`.`rank`, `Image`.`deleted`, `Image`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Image__path` FROM `johnsonssewing_db`.`attachments` AS `Image` WHERE `Image`.`model` = 'Setting' AND `Image`.`group` = 'Image' AND `Image`.`foreign_key` = (46) ORDER BY `Image`.`rank` ASC, `Image`.`id` ASC | 0 | 0 | 0 | |
SELECT `Document`.`id`, `Document`.`model`, `Document`.`foreign_key`, `Document`.`dirname`, `Document`.`basename`, `Document`.`checksum`, `Document`.`alternative`, `Document`.`group`, `Document`.`created`, `Document`.`modified`, `Document`.`rank`, `Document`.`deleted`, `Document`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Document__path` FROM `johnsonssewing_db`.`attachments` AS `Document` WHERE `Document`.`model` = 'Setting' AND `Document`.`group` = 'Document' AND `Document`.`foreign_key` = (46) ORDER BY `Document`.`rank` ASC | 0 | 0 | 0 | |
SELECT `Setting`.`id`, `Setting`.`created`, `Setting`.`rank`, `Setting`.`modified`, `Setting`.`key`, `Setting`.`value`, `Setting`.`title`, `Setting`.`description`, `Setting`.`type`, `Setting`.`editable`, `Setting`.`super_admin`, `Setting`.`options`, `Setting`.`method`, `Setting`.`display`, (REPLACE(CONCAT(UPPER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1), 1, 1)), LOWER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1) FROM 2))), '_', ' ')) AS `Setting__tinyMceOption` FROM `johnsonssewing_db`.`settings` AS `Setting` WHERE `Setting`.`key` = 'Site.Contact.facebook-quilters' ORDER BY `Setting`.`rank` ASC LIMIT 1 | 1 | 1 | 0 | |
SELECT `Image`.`id`, `Image`.`model`, `Image`.`foreign_key`, `Image`.`dirname`, `Image`.`basename`, `Image`.`checksum`, `Image`.`alternative`, `Image`.`group`, `Image`.`created`, `Image`.`modified`, `Image`.`rank`, `Image`.`deleted`, `Image`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Image__path` FROM `johnsonssewing_db`.`attachments` AS `Image` WHERE `Image`.`model` = 'Setting' AND `Image`.`group` = 'Image' AND `Image`.`foreign_key` = (51) ORDER BY `Image`.`rank` ASC, `Image`.`id` ASC | 0 | 0 | 0 | |
SELECT `Document`.`id`, `Document`.`model`, `Document`.`foreign_key`, `Document`.`dirname`, `Document`.`basename`, `Document`.`checksum`, `Document`.`alternative`, `Document`.`group`, `Document`.`created`, `Document`.`modified`, `Document`.`rank`, `Document`.`deleted`, `Document`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Document__path` FROM `johnsonssewing_db`.`attachments` AS `Document` WHERE `Document`.`model` = 'Setting' AND `Document`.`group` = 'Document' AND `Document`.`foreign_key` = (51) ORDER BY `Document`.`rank` ASC | 0 | 0 | 0 | |
SELECT `Setting`.`id`, `Setting`.`created`, `Setting`.`rank`, `Setting`.`modified`, `Setting`.`key`, `Setting`.`value`, `Setting`.`title`, `Setting`.`description`, `Setting`.`type`, `Setting`.`editable`, `Setting`.`super_admin`, `Setting`.`options`, `Setting`.`method`, `Setting`.`display`, (REPLACE(CONCAT(UPPER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1), 1, 1)), LOWER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1) FROM 2))), '_', ' ')) AS `Setting__tinyMceOption` FROM `johnsonssewing_db`.`settings` AS `Setting` WHERE `Setting`.`key` = 'Site.Contact.facebook-quilters' ORDER BY `Setting`.`rank` ASC LIMIT 1 | 1 | 1 | 0 | |
SELECT `Image`.`id`, `Image`.`model`, `Image`.`foreign_key`, `Image`.`dirname`, `Image`.`basename`, `Image`.`checksum`, `Image`.`alternative`, `Image`.`group`, `Image`.`created`, `Image`.`modified`, `Image`.`rank`, `Image`.`deleted`, `Image`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Image__path` FROM `johnsonssewing_db`.`attachments` AS `Image` WHERE `Image`.`model` = 'Setting' AND `Image`.`group` = 'Image' AND `Image`.`foreign_key` = (51) ORDER BY `Image`.`rank` ASC, `Image`.`id` ASC | 0 | 0 | 0 | |
SELECT `Document`.`id`, `Document`.`model`, `Document`.`foreign_key`, `Document`.`dirname`, `Document`.`basename`, `Document`.`checksum`, `Document`.`alternative`, `Document`.`group`, `Document`.`created`, `Document`.`modified`, `Document`.`rank`, `Document`.`deleted`, `Document`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Document__path` FROM `johnsonssewing_db`.`attachments` AS `Document` WHERE `Document`.`model` = 'Setting' AND `Document`.`group` = 'Document' AND `Document`.`foreign_key` = (51) ORDER BY `Document`.`rank` ASC | 0 | 0 | 0 | |
SELECT `Setting`.`id`, `Setting`.`created`, `Setting`.`rank`, `Setting`.`modified`, `Setting`.`key`, `Setting`.`value`, `Setting`.`title`, `Setting`.`description`, `Setting`.`type`, `Setting`.`editable`, `Setting`.`super_admin`, `Setting`.`options`, `Setting`.`method`, `Setting`.`display`, (REPLACE(CONCAT(UPPER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1), 1, 1)), LOWER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1) FROM 2))), '_', ' ')) AS `Setting__tinyMceOption` FROM `johnsonssewing_db`.`settings` AS `Setting` WHERE `Setting`.`key` = 'Site.Google.maps_api_key' ORDER BY `Setting`.`rank` ASC LIMIT 1 | 1 | 1 | 0 | |
SELECT `Image`.`id`, `Image`.`model`, `Image`.`foreign_key`, `Image`.`dirname`, `Image`.`basename`, `Image`.`checksum`, `Image`.`alternative`, `Image`.`group`, `Image`.`created`, `Image`.`modified`, `Image`.`rank`, `Image`.`deleted`, `Image`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Image__path` FROM `johnsonssewing_db`.`attachments` AS `Image` WHERE `Image`.`model` = 'Setting' AND `Image`.`group` = 'Image' AND `Image`.`foreign_key` = (18) ORDER BY `Image`.`rank` ASC, `Image`.`id` ASC | 0 | 0 | 0 | |
SELECT `Document`.`id`, `Document`.`model`, `Document`.`foreign_key`, `Document`.`dirname`, `Document`.`basename`, `Document`.`checksum`, `Document`.`alternative`, `Document`.`group`, `Document`.`created`, `Document`.`modified`, `Document`.`rank`, `Document`.`deleted`, `Document`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Document__path` FROM `johnsonssewing_db`.`attachments` AS `Document` WHERE `Document`.`model` = 'Setting' AND `Document`.`group` = 'Document' AND `Document`.`foreign_key` = (18) ORDER BY `Document`.`rank` ASC | 0 | 0 | 0 | |