API tools faq
paste
pwagner

shopware-mysql-log

pwagner
Dec 16th, 2016
36
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 17.74 KB | None | 0 0
raw download clone embed print report
  1. 887 CONNECT root@localhost ON devshop
  2. 887 Query   SET @@SESSION.sql_mode = ""
  3. 887 Query   SELECT name FROM s_core_plugins WHERE namespace LIKE "ShopwarePlugins" AND active = 1 AND installation_date IS NOT NULL
  4. 887 Query   SELECT name, id, name, label, description, SOURCE, active, installation_date AS installationDate, update_date AS updateDate, versionFROM s_core_pluginsWHERE namespace='Core'
  5. 887 Query   SELECT ce.subscribe AS name, ce.listener, ce.POSITION, cp.name AS plugin FROM s_core_subscribes ce JOIN s_core_plugins cp ON cp.id=ce.pluginID AND cp.active=1 AND cp.namespace='Core' WHERE ce.TYPE=0 ORDER BY name, POSITION
  6. 887 Query   SELECT name, id, name, label, description, SOURCE, active, installation_date AS installationDate, update_date AS updateDate, versionFROM s_core_pluginsWHERE namespace='Frontend'
  7. 887 Query   SELECT ce.subscribe AS name, ce.listener, ce.POSITION, cp.name AS plugin FROM s_core_subscribes ce JOIN s_core_plugins cp ON cp.id=ce.pluginID AND cp.active=1 AND cp.namespace='Frontend' WHERE ce.TYPE=0 ORDER BY name, POSITION
  8. 887 Query   SELECT name, id, name, label, description, SOURCE, active, installation_date AS installationDate, update_date AS updateDate, versionFROM s_core_pluginsWHERE namespace='Backend'
  9. 887 Query   SELECT ce.subscribe AS name, ce.listener, ce.POSITION, cp.name AS plugin FROM s_core_subscribes ce JOIN s_core_plugins cp ON cp.id=ce.pluginID AND cp.active=1 AND cp.namespace='Backend' WHERE ce.TYPE=0 ORDER BY name, POSITION
  10. 887 Query   SELECT t0.id AS id_1, t0.name AS name_2, t0.label AS label_3, t0.namespace AS namespace_4, t0.SOURCE AS source_5, t0.description AS description_6, t0.active AS active_7, t0.added AS added_8, t0.installation_date AS installation_date_9, t0.update_date AS update_date_10, t0.refresh_date AS refresh_date_11, t0.author AS author_12, t0.copyright AS copyright_13, t0.license AS license_14, t0.version AS version_15, t0.support AS support_16, t0.changes AS changes_17, t0.link AS link_18, t0.update_version AS update_version_19, t0.update_source AS update_source_20, t0.capability_update AS capability_update_21, t0.capability_install AS capability_install_22, t0.capability_enable AS capability_enable_23, t0.capability_secure_uninstall AS capability_secure_uninstall_24 FROM s_core_plugins t0 WHERE t0.id = '72' LIMIT 1
  11. 887 Query   SELECT name, namespace, sourceFROM s_core_plugins
  12. 887 Query   SELECT t0.id AS id_1, t0.name AS name_2, t0.label AS label_3, t0.namespace AS namespace_4, t0.SOURCE AS source_5, t0.description AS description_6, t0.active AS active_7, t0.added AS added_8, t0.installation_date AS installation_date_9, t0.update_date AS update_date_10, t0.refresh_date AS refresh_date_11, t0.author AS author_12, t0.copyright AS copyright_13, t0.license AS license_14, t0.version AS version_15, t0.support AS support_16, t0.changes AS changes_17, t0.link AS link_18, t0.update_version AS update_version_19, t0.update_source AS update_source_20, t0.capability_update AS capability_update_21, t0.capability_install AS capability_install_22, t0.capability_enable AS capability_enable_23, t0.capability_secure_uninstall AS capability_secure_uninstall_24 FROM s_core_plugins t0 WHERE t0.id = '59' LIMIT 1
  13. 886 Query   SELECT t0.id AS id_1, t0.name AS name_2, t0.label AS label_3, t0.namespace AS namespace_4, t0.SOURCE AS source_5, t0.description AS description_6, t0.active AS active_7, t0.added AS added_8, t0.installation_date AS installation_date_9, t0.update_date AS update_date_10, t0.refresh_date AS refresh_date_11, t0.author AS author_12, t0.copyright AS copyright_13, t0.license AS license_14, t0.version AS version_15, t0.support AS support_16, t0.changes AS changes_17, t0.link AS link_18, t0.update_version AS update_version_19, t0.update_source AS update_source_20, t0.capability_update AS capability_update_21, t0.capability_install AS capability_install_22, t0.capability_enable AS capability_enable_23, t0.capability_secure_uninstall AS capability_secure_uninstall_24 FROM s_core_plugins t0 WHERE t0.id = '71' LIMIT 1
  14. 887 Query   SELECT t0.id AS id_1, t0.name AS name_2, t0.label AS label_3, t0.namespace AS namespace_4, t0.SOURCE AS source_5, t0.description AS description_6, t0.active AS active_7, t0.added AS added_8, t0.installation_date AS installation_date_9, t0.update_date AS update_date_10, t0.refresh_date AS refresh_date_11, t0.author AS author_12, t0.copyright AS copyright_13, t0.license AS license_14, t0.version AS version_15, t0.support AS support_16, t0.changes AS changes_17, t0.link AS link_18, t0.update_version AS update_version_19, t0.update_source AS update_source_20, t0.capability_update AS capability_update_21, t0.capability_install AS capability_install_22, t0.capability_enable AS capability_enable_23, t0.capability_secure_uninstall AS capability_secure_uninstall_24 FROM s_core_plugins t0 WHERE t0.id = '71' LIMIT 1
  15. 887 Query   SELECT module, host, license FROM s_core_licenses WHERE active=1
  16. 887 Query   SELECT host FROM s_core_shops WHERE `default`=1
  17. 887 Query   SELECT t0.id AS id_1, t0.name AS name_2, t0.label AS label_3, t0.namespace AS namespace_4, t0.SOURCE AS source_5, t0.description AS description_6, t0.active AS active_7, t0.added AS added_8, t0.installation_date AS installation_date_9, t0.update_date AS update_date_10, t0.refresh_date AS refresh_date_11, t0.author AS author_12, t0.copyright AS copyright_13, t0.license AS license_14, t0.version AS version_15, t0.support AS support_16, t0.changes AS changes_17, t0.link AS link_18, t0.update_version AS update_version_19, t0.update_source AS update_source_20, t0.capability_update AS capability_update_21, t0.capability_install AS capability_install_22, t0.capability_enable AS capability_enable_23, t0.capability_secure_uninstall AS capability_secure_uninstall_24 FROM s_core_plugins t0 WHERE t0.id = '73' LIMIT 1
  18. 887 Query   SELECT t0.id AS id_1, t0.name AS name_2, t0.label AS label_3, t0.namespace AS namespace_4, t0.SOURCE AS source_5, t0.description AS description_6, t0.active AS active_7, t0.added AS added_8, t0.installation_date AS installation_date_9, t0.update_date AS update_date_10, t0.refresh_date AS refresh_date_11, t0.author AS author_12, t0.copyright AS copyright_13, t0.license AS license_14, t0.version AS version_15, t0.support AS support_16, t0.changes AS changes_17, t0.link AS link_18, t0.update_version AS update_version_19, t0.update_source AS update_source_20, t0.capability_update AS capability_update_21, t0.capability_install AS capability_install_22, t0.capability_enable AS capability_enable_23, t0.capability_secure_uninstall AS capability_secure_uninstall_24 FROM s_core_plugins t0 WHERE t0.id = '76' LIMIT 1
  19. 887 Query   SELECT t0.id AS id_1, t0.name AS name_2, t0.label AS label_3, t0.namespace AS namespace_4, t0.SOURCE AS source_5, t0.description AS description_6, t0.active AS active_7, t0.added AS added_8, t0.installation_date AS installation_date_9, t0.update_date AS update_date_10, t0.refresh_date AS refresh_date_11, t0.author AS author_12, t0.copyright AS copyright_13, t0.license AS license_14, t0.version AS version_15, t0.support AS support_16, t0.changes AS changes_17, t0.link AS link_18, t0.update_version AS update_version_19, t0.update_source AS update_source_20, t0.capability_update AS capability_update_21, t0.capability_install AS capability_install_22, t0.capability_enable AS capability_enable_23, t0.capability_secure_uninstall AS capability_secure_uninstall_24 FROM s_core_plugins t0 WHERE t0.id = '83' LIMIT 1
  20. 887 Query   SELECT t0.id AS id_1, t0.TABLE_NAME AS table_name_2, t0.column_name AS column_name_3, t0.column_type AS column_type_4, t0.default_value AS default_value_5, t0.entity AS entity_6, t0.label AS label_7, t0.help_text AS help_text_8, t0.support_text AS support_text_9, t0.translatable AS translatable_10, t0.display_in_backend AS display_in_backend_11, t0.custom AS custom_12, t0.POSITION AS position_13, t0.array_store AS array_store_14 FROM s_attribute_configuration t0 WHERE t0.column_name = 'viisonCountryOfOrigin' LIMIT 1
  21. 887 Query   SELECT t0.id AS id_1, t0.name AS name_2, t0.label AS label_3, t0.namespace AS namespace_4, t0.SOURCE AS source_5, t0.description AS description_6, t0.active AS active_7, t0.added AS added_8, t0.installation_date AS installation_date_9, t0.update_date AS update_date_10, t0.refresh_date AS refresh_date_11, t0.author AS author_12, t0.copyright AS copyright_13, t0.license AS license_14, t0.version AS version_15, t0.support AS support_16, t0.changes AS changes_17, t0.link AS link_18, t0.update_version AS update_version_19, t0.update_source AS update_source_20, t0.capability_update AS capability_update_21, t0.capability_install AS capability_install_22, t0.capability_enable AS capability_enable_23, t0.capability_secure_uninstall AS capability_secure_uninstall_24 FROM s_core_plugins t0 WHERE t0.id = '83' LIMIT 1
  22. 887 Query   SELECT t0.id AS id_1, t0.TABLE_NAME AS table_name_2, t0.column_name AS column_name_3, t0.column_type AS column_type_4, t0.default_value AS default_value_5, t0.entity AS entity_6, t0.label AS label_7, t0.help_text AS help_text_8, t0.support_text AS support_text_9, t0.translatable AS translatable_10, t0.display_in_backend AS display_in_backend_11, t0.custom AS custom_12, t0.POSITION AS position_13, t0.array_store AS array_store_14 FROM s_attribute_configuration t0 WHERE t0.column_name = 'viisonCountryOfOrigin' LIMIT 1
  23. 887 Query   SELECT t0.id AS id_1, t0.TABLE_NAME AS table_name_2, t0.column_name AS column_name_3, t0.column_type AS column_type_4, t0.default_value AS default_value_5, t0.entity AS entity_6, t0.label AS label_7, t0.help_text AS help_text_8, t0.support_text AS support_text_9, t0.translatable AS translatable_10, t0.display_in_backend AS display_in_backend_11, t0.custom AS custom_12, t0.POSITION AS position_13, t0.array_store AS array_store_14 FROM s_attribute_configuration t0 WHERE t0.column_name = 'viisonCustomsTariffNumber' LIMIT 1
  24. 887 Query   SELECT t0.id AS id_1, t0.TABLE_NAME AS table_name_2, t0.column_name AS column_name_3, t0.column_type AS column_type_4, t0.default_value AS default_value_5, t0.entity AS entity_6, t0.label AS label_7, t0.help_text AS help_text_8, t0.support_text AS support_text_9, t0.translatable AS translatable_10, t0.display_in_backend AS display_in_backend_11, t0.custom AS custom_12, t0.POSITION AS position_13, t0.array_store AS array_store_14 FROM s_attribute_configuration t0 WHERE t0.column_name = 'viisonCountryOfOrigin' LIMIT 1
  25. 887 Query   SELECT t0.id AS id_1, t0.TABLE_NAME AS table_name_2, t0.column_name AS column_name_3, t0.column_type AS column_type_4, t0.default_value AS default_value_5, t0.entity AS entity_6, t0.label AS label_7, t0.help_text AS help_text_8, t0.support_text AS support_text_9, t0.translatable AS translatable_10, t0.display_in_backend AS display_in_backend_11, t0.custom AS custom_12, t0.POSITION AS position_13, t0.array_store AS array_store_14 FROM s_attribute_configuration t0 WHERE t0.column_name = 'viisonCountryOfOrigin' LIMIT 1
  26. 887 Query   SELECT t0.id AS id_1, t0.TABLE_NAME AS table_name_2, t0.column_name AS column_name_3, t0.column_type AS column_type_4, t0.default_value AS default_value_5, t0.entity AS entity_6, t0.label AS label_7, t0.help_text AS help_text_8, t0.support_text AS support_text_9, t0.translatable AS translatable_10, t0.display_in_backend AS display_in_backend_11, t0.custom AS custom_12, t0.POSITION AS position_13, t0.array_store AS array_store_14 FROM s_attribute_configuration t0 WHERE t0.column_name = 'viisonCustomsTariffNumber' LIMIT 1
  27. 887 Query   SELECT ce.name, COALESCE(currentShop.VALUE, parentShop.VALUE, fallbackShop.VALUE, ce.VALUE) AS VALUE FROM s_core_plugins p INNER JOIN s_core_config_forms cf ON cf.plugin_id = p.id INNER JOIN s_core_config_elements ce ON ce.form_id = cf.id LEFT JOIN s_core_config_values currentShop ON currentShop.element_id = ce.id AND currentShop.shop_id = NULL LEFT JOIN s_core_config_values parentShop ON parentShop.element_id = ce.id AND parentShop.shop_id = '1' LEFT JOIN s_core_config_values fallbackShop ON fallbackShop.element_id = ce.id AND fallbackShop.shop_id = '1' WHERE p.name='ErrorHandler'
  28. 887 Query   SELECT ce.name, COALESCE(currentShop.VALUE, parentShop.VALUE, fallbackShop.VALUE, ce.VALUE) AS VALUE FROM s_core_plugins p INNER JOIN s_core_config_forms cf ON cf.plugin_id = p.id INNER JOIN s_core_config_elements ce ON ce.form_id = cf.id LEFT JOIN s_core_config_values currentShop ON currentShop.element_id = ce.id AND currentShop.shop_id = NULL LEFT JOIN s_core_config_values parentShop ON parentShop.element_id = ce.id AND parentShop.shop_id = '1' LEFT JOIN s_core_config_values fallbackShop ON fallbackShop.element_id = ce.id AND fallbackShop.shop_id = '1' WHERE p.name='InputFilter'
  29. 887 Query   SELECT ce.name, COALESCE(currentShop.VALUE, parentShop.VALUE, fallbackShop.VALUE, ce.VALUE) AS VALUE FROM s_core_plugins p INNER JOIN s_core_config_forms cf ON cf.plugin_id = p.id INNER JOIN s_core_config_elements ce ON ce.form_id = cf.id LEFT JOIN s_core_config_values currentShop ON currentShop.element_id = ce.id AND currentShop.shop_id = NULL LEFT JOIN s_core_config_values parentShop ON parentShop.element_id = ce.id AND parentShop.shop_id = '1' LEFT JOIN s_core_config_values fallbackShop ON fallbackShop.element_id = ce.id AND fallbackShop.shop_id = '1' WHERE p.name='Auth'
  30. 887 Query   SELECT `s_core_sessions_backend`.* FROM `s_core_sessions_backend` WHERE (((`s_core_sessions_backend`.`id` = '57d31blablablablabla81e4')))
  31. 887 Query   SELECT t0.id AS id_1, t0.name AS name_2, t0.pluginID AS pluginID_3 FROM s_core_acl_resources t0
  32. 887 Query   SELECT t0.id AS id_1, t0.parentID AS parentID_2, t0.name AS name_3, t0.description AS description_4, t0.SOURCE AS source_5, t0.enabled AS enabled_6, t0.admin AS admin_7, t0.parentID AS parentID_8 FROM s_core_auth_roles t0
  33. 887 Query   SELECT t0.id AS id_1, t0.privilegeID AS privilegeID_2, t0.roleID AS roleID_3, t0.resourceID AS resourceID_4, t0.roleID AS roleID_5, t6.id AS id_7, t6.parentID AS parentID_8, t6.name AS name_9, t6.description AS description_10, t6.SOURCE AS source_11, t6.enabled AS enabled_12, t6.admin AS admin_13, t6.parentID AS parentID_14, t0.resourceID AS resourceID_15, t16.id AS id_17, t16.name AS name_18, t16.pluginID AS pluginID_19, t0.privilegeID AS privilegeID_20, t21.id AS id_22, t21.resourceID AS resourceID_23, t21.name AS name_24, t21.resourceID AS resourceID_25 FROM s_core_acl_roles t0 LEFT JOIN s_core_auth_roles t6 ON t0.roleID = t6.id LEFT JOIN s_core_acl_resources t16 ON t0.resourceID = t16.id LEFT JOIN s_core_acl_privileges t21 ON t0.privilegeID = t21.id
  34. 887 Query   SELECT `s_core_auth`.* FROM `s_core_auth` WHERE (active=1) AND (lockeduntil <= NOW()) AND (`sessionID` = '57d31blablablablabla81e4')
  35. 887 Query   UPDATE `s_core_auth` SET `lastlogin` = '2016-12-15 16:49:53' WHERE (`username` = 'blaexampleuser')
  36. 887 Query   SELECT COLUMN_NAME AS FIELD, COLUMN_TYPE AS TYPE, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'devshop' AND TABLE_NAME = 's_order_attributes'
  37. 887 Query   SELECT alias.* FROM s_order_attributes alias WHERE alias.orderid = '123' LIMIT 1 OFFSET 0
  38. 887 Query   UPDATE s_order_attributes alias SET alias.my_modified_date = '2016-12-15 15:09:25' WHERE alias.orderid = '123'
  39. 887 Query   SELECT `s_core_sessions_backend`.* FROM `s_core_sessions_backend` WHERE (((`s_core_sessions_backend`.`id` = '57d31blablablablabla81e4')))
  40. 887 Query   UPDATE `s_core_sessions_backend` SET `modified` = '1481816993', `data` = 'ShopwareBackend|a:2:{s:12:\"X-CSRF-Token\";s:30:\"qwvrblablablablabla9Xj\";s:13:\"sbp_available\";i:1;}Shopware|a:1:{s:4:\"Auth\";O:8:\"stdClass\":18:{s:2:\"id\";s:2:\"50\";s:6:\"roleID\";s:1:\"1\";s:8:\"username\";s:6:\"blaexampleuser\";s:8:\"password\";s:60:\"$2b$la$AAblablablaYJf/blablablablabla/v2PZxblablablablabla0W\";s:7:\"encoder\";s:6:\"bcrypt\";s:6:\"apiKey\";N;s:8:\"localeID\";s:1:\"1\";s:9:\"sessionID\";s:32:\"d56ec1blablablablablac3d6\";s:9:\"lastlogin\";s:19:\"2016-12-15 13:38:12\";s:4:\"name\";s:5:\"Admin\";s:5:\"email\";s:20:\"[email protected]\";s:6:\"active\";s:1:\"1\";s:12:\"failedlogins\";s:1:\"0\";s:11:\"lockeduntil\";s:19:\"0000-00-00 00:00:00\";s:15:\"extended_editor\";s:1:\"0\";s:14:\"disabled_cache\";s:1:\"0\";s:4:\"role\";O:25:\"Shopware\\Models\\User\\Role\":11:{s:29:\"\0Shopware\\Models\\User\\Role\0id\";i:1;s:35:\"\0Shopware\\Models\\User\\Role\0parentId\";N;s:31:\"\0Shopware\\Models\\User\\Role\0name\";s:12:\"local_admins\";s:38:\"\0Shopware\\Models\\User\\Role\0description\";s:53:\"Default group that gains access to all shop functions\";s:33:\"\0Shopware\\Models\\User\\Role\0source\";s:8:\"build-in\";s:34:\"\0Shopware\\Models\\User\\Role\0enabled\";i:1;s:32:\"\0Shopware\\Models\\User\\Role\0admin\";i:1;s:32:\"\0Shopware\\Models\\User\\Role\0users\";O:33:\"Doctrine\\ORM\\PersistentCollection\":2:{s:13:\"\0*\0collection\";O:43:\"Doctrine\\Common\\Collections\\ArrayCollection\":1:{s:53:\"\0Doctrine\\Common\\Collections\\ArrayCollection\0elements\";a:0:{}}s:14:\"\0*\0initialized\";b:0;}s:32:\"\0Shopware\\Models\\User\\Role\0rules\";O:33:\"Doctrine\\ORM\\PersistentCollection\":2:{s:13:\"\0*\0collection\";O:43:\"Doctrine\\Common\\Collections\\ArrayCollection\":1:{s:53:\"\0Doctrine\\Common\\Collections\\ArrayCollection\0elements\";a:0:{}}s:14:\"\0*\0initialized\";b:0;}s:35:\"\0Shopware\\Models\\User\\Role\0children\";O:33:\"Doctrine\\ORM\\PersistentCollection\":2:{s:13:\"\0*\0collection\";O:43:\"Doctrine\\Common\\Collections\\ArrayCollection\":1:{s:53:\"\0Doctrine\\Common\\Collections\\ArrayCollection\0elements\";a:0:{}}s:14:\"\0*\0initialized\";b:0;}s:33:\"\0Shopware\\Models\\User\\Role\0parent\";N;}s:6:\"locale\";O:27:\"Shopware\\Models\\Shop\\Locale\":4:{s:31:\"\0Shopware\\Models\\Shop\\Locale\0id\";i:1;s:35:\"\0Shopware\\Models\\Shop\\Locale\0locale\";s:5:\"de_DE\";s:37:\"\0Shopware\\Models\\Shop\\Locale\0language\";s:7:\"Deutsch\";s:38:\"\0Shopware\\Models\\Shop\\Locale\0territory\";s:11:\"Deutschland\";}}}', `expiry` = '7200' WHERE (`id` = '57d31blablablablabla81e4')
  41. 887 Quit
Advertisement
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!