Queries
45
Total Queries
0.0004 s
Total Query Time
SQL | Params | Execution Time |
---|---|---|
SELECT name, id, name, label, description, source, active, installation_date as installationDate, update_date as updateDate, version FROM s_core_plugins WHERE namespace =: namespace AND name not IN(: names) |
array:2 [ "namespace" => "Core" "names" => array:1 [ 0 => "PluginManager" ] ] |
0.0010 ms |
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 = : namespace WHERE ce.type = 0 AND cp.name NOT IN(: names) ORDER BY name, position |
array:2 [ "namespace" => "Core" "names" => array:1 [ 0 => "PluginManager" ] ] |
0.0021 ms |
SELECT name, id, name, label, description, source, active, installation_date as installationDate, update_date as updateDate, version FROM s_core_plugins WHERE namespace =: namespace AND name not IN(: names) |
array:2 [ "namespace" => "Frontend" "names" => array:1 [ 0 => "PluginManager" ] ] |
0.0012 ms |
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 = : namespace WHERE ce.type = 0 AND cp.name NOT IN(: names) ORDER BY name, position |
array:2 [ "namespace" => "Frontend" "names" => array:1 [ 0 => "PluginManager" ] ] |
0.0015 ms |
SELECT name, id, name, label, description, source, active, installation_date as installationDate, update_date as updateDate, version FROM s_core_plugins WHERE namespace =: namespace AND name not IN(: names) |
array:2 [ "namespace" => "Backend" "names" => array:1 [ 0 => "PluginManager" ] ] |
0.0010 ms |
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 = : namespace WHERE ce.type = 0 AND cp.name NOT IN(: names) ORDER BY name, position |
array:2 [ "namespace" => "Backend" "names" => array:1 [ 0 => "PluginManager" ] ] |
0.0023 ms |
SELECT name, version, active, installation_date AS installed FROM s_core_plugins |
[] |
0.0002 ms |
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.readonly AS readonly_8, t0.help_text AS help_text_9, t0.support_text AS support_text_10, t0.translatable AS translatable_11, t0.display_in_backend AS display_in_backend_12, t0.custom AS custom_13, t0.position AS position_14, t0.array_store AS array_store_15 FROM s_attribute_configuration t0 WHERE t0.column_name = ? LIMIT 1 |
array:1 [ 0 => "viisonMoss" ] |
0.0084 ms |
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.readonly AS readonly_8, t0.help_text AS help_text_9, t0.support_text AS support_text_10, t0.translatable AS translatable_11, t0.display_in_backend AS display_in_backend_12, t0.custom AS custom_13, t0.position AS position_14, t0.array_store AS array_store_15 FROM s_attribute_configuration t0 WHERE t0.column_name = ? LIMIT 1 |
array:1 [ 0 => "viisonOtherServiceParagraphOneOrTwo" ] |
0.0002 ms |
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.readonly AS readonly_8, t0.help_text AS help_text_9, t0.support_text AS support_text_10, t0.translatable AS translatable_11, t0.display_in_backend AS display_in_backend_12, t0.custom AS custom_13, t0.position AS position_14, t0.array_store AS array_store_15 FROM s_attribute_configuration t0 WHERE t0.table_name = ? AND t0.column_name = ? LIMIT 1 |
array:2 [ 0 => "s_core_paymentmeans_attributes" 1 => "viison_datev_debtor_account" ] |
0.0002 ms |
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.readonly AS readonly_8, t0.help_text AS help_text_9, t0.support_text AS support_text_10, t0.translatable AS translatable_11, t0.display_in_backend AS display_in_backend_12, t0.custom AS custom_13, t0.position AS position_14, t0.array_store AS array_store_15 FROM s_attribute_configuration t0 WHERE t0.table_name = ? AND t0.column_name = ? LIMIT 1 |
array:2 [ 0 => "s_core_paymentmeans_attributes" 1 => "viison_datev_clearing_account" ] |
0.0002 ms |
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.readonly AS readonly_8, t0.help_text AS help_text_9, t0.support_text AS support_text_10, t0.translatable AS translatable_11, t0.display_in_backend AS display_in_backend_12, t0.custom AS custom_13, t0.position AS position_14, t0.array_store AS array_store_15 FROM s_attribute_configuration t0 WHERE t0.table_name = ? AND t0.column_name = ? LIMIT 1 |
array:2 [ 0 => "s_core_paymentmeans_attributes" 1 => "viison_datev_period_of_payment" ] |
0.0003 ms |
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.readonly AS readonly_8, t0.help_text AS help_text_9, t0.support_text AS support_text_10, t0.translatable AS translatable_11, t0.display_in_backend AS display_in_backend_12, t0.custom AS custom_13, t0.position AS position_14, t0.array_store AS array_store_15 FROM s_attribute_configuration t0 WHERE t0.table_name = ? AND t0.column_name = ? LIMIT 1 |
array:2 [ 0 => "s_user_attributes" 1 => "viison_datev_company_code" ] |
0.0002 ms |
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.readonly AS readonly_8, t0.help_text AS help_text_9, t0.support_text AS support_text_10, t0.translatable AS translatable_11, t0.display_in_backend AS display_in_backend_12, t0.custom AS custom_13, t0.position AS position_14, t0.array_store AS array_store_15 FROM s_attribute_configuration t0 WHERE t0.table_name = ? AND t0.column_name = ? LIMIT 1 |
array:2 [ 0 => "s_user_attributes" 1 => "viison_datev_debtor_account" ] |
0.0002 ms |
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, t0.translations AS translations_25, t0.in_safe_mode AS in_safe_mode_26 FROM s_core_plugins t0 WHERE t0.id = ? LIMIT 1 |
array:1 [ 0 => 65 ] |
0.0002 ms |
SELECT * FROM `s_core_plugins` |
[] |
0.0009 ms |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.language AS language_3, t0.territory AS territory_4 FROM s_core_locales t0 WHERE t0.locale = ? LIMIT 1 |
array:1 [ 0 => "en_GB" ] |
0.0001 ms |
SET @b2b_request_uuid = : uuid; |
array:1 [ "uuid" => "ZHujkJxE6tVixycz52IFPjX5EFq0UB4PgBhsdeqd" ] |
0.0001 ms |
SELECT coreConfigElements.name, coreConfigValues.value FROM s_core_config_values coreConfigValues INNER JOIN s_core_config_elements coreConfigElements ON coreConfigValues.element_id = coreConfigElements.id INNER JOIN s_core_config_forms coreConfigForms ON coreConfigElements.form_id = coreConfigForms.id INNER JOIN s_core_plugins corePlugins ON coreConfigForms.plugin_id = corePlugins.id WHERE ( corePlugins.name = : pluginName3099714110 ) AND ( coreConfigValues.shop_id = : shopId2212294583 ) |
array:2 [ "pluginName3099714110" => "SwagSecurity" "shopId2212294583" => 1 ] |
0.0003 ms |
SELECT coreConfigElements.name, coreConfigElements.value FROM s_core_config_elements coreConfigElements INNER JOIN s_core_config_forms coreConfigForms ON coreConfigElements.form_id = coreConfigForms.id INNER JOIN s_core_plugins corePlugins ON coreConfigForms.plugin_id = corePlugins.id WHERE corePlugins.name = : pluginName3099714110 |
array:1 [ "pluginName3099714110" => "SwagSecurity" ] |
0.0002 ms |
SELECT coreConfigElements.name, coreConfigValues.value FROM s_core_config_values coreConfigValues INNER JOIN s_core_config_elements coreConfigElements ON coreConfigValues.element_id = coreConfigElements.id INNER JOIN s_core_config_forms coreConfigForms ON coreConfigElements.form_id = coreConfigForms.id INNER JOIN s_core_plugins corePlugins ON coreConfigForms.plugin_id = corePlugins.id WHERE ( corePlugins.name = : pluginName3425890772 ) AND ( coreConfigValues.shop_id = : shopId2212294583 ) |
array:2 [ "pluginName3425890772" => "InputFilter" "shopId2212294583" => 1 ] |
0.0002 ms |
SELECT coreConfigElements.name, coreConfigElements.value FROM s_core_config_elements coreConfigElements INNER JOIN s_core_config_forms coreConfigForms ON coreConfigElements.form_id = coreConfigForms.id INNER JOIN s_core_plugins corePlugins ON coreConfigForms.plugin_id = corePlugins.id WHERE corePlugins.name = : pluginName3425890772 |
array:1 [ "pluginName3425890772" => "InputFilter" ] |
0.0002 ms |
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, t0.translations AS translations_25, t0.in_safe_mode AS in_safe_mode_26 FROM s_core_plugins t0 |
[] |
0.0013 ms |
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.readonly AS readonly_8, t0.help_text AS help_text_9, t0.support_text AS support_text_10, t0.translatable AS translatable_11, t0.display_in_backend AS display_in_backend_12, t0.custom AS custom_13, t0.position AS position_14, t0.array_store AS array_store_15 FROM s_attribute_configuration t0 WHERE t0.column_name = ? LIMIT 1 |
array:1 [ 0 => "viisonCountryOfOrigin" ] |
0.0002 ms |
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.readonly AS readonly_8, t0.help_text AS help_text_9, t0.support_text AS support_text_10, t0.translatable AS translatable_11, t0.display_in_backend AS display_in_backend_12, t0.custom AS custom_13, t0.position AS position_14, t0.array_store AS array_store_15 FROM s_attribute_configuration t0 WHERE t0.column_name = ? LIMIT 1 |
array:1 [ 0 => "viisonCustomsTariffNumber" ] |
0.0002 ms |
SELECT coreConfigElements.name, coreConfigValues.value FROM s_core_config_values coreConfigValues INNER JOIN s_core_config_elements coreConfigElements ON coreConfigValues.element_id = coreConfigElements.id INNER JOIN s_core_config_forms coreConfigForms ON coreConfigElements.form_id = coreConfigForms.id INNER JOIN s_core_plugins corePlugins ON coreConfigForms.plugin_id = corePlugins.id WHERE ( corePlugins.name = : pluginName3343718869 ) AND ( coreConfigValues.shop_id = : shopId2212294583 ) |
array:2 [ "pluginName3343718869" => "ViisonPickwareERP" "shopId2212294583" => 1 ] |
0.0002 ms |
SELECT coreConfigElements.name, coreConfigElements.value FROM s_core_config_elements coreConfigElements INNER JOIN s_core_config_forms coreConfigForms ON coreConfigElements.form_id = coreConfigForms.id INNER JOIN s_core_plugins corePlugins ON coreConfigForms.plugin_id = corePlugins.id WHERE corePlugins.name = : pluginName3343718869 |
array:1 [ "pluginName3343718869" => "ViisonPickwareERP" ] |
0.0002 ms |
SELECT coreConfigElements.name, coreConfigValues.value FROM s_core_config_values coreConfigValues INNER JOIN s_core_config_elements coreConfigElements ON coreConfigValues.element_id = coreConfigElements.id INNER JOIN s_core_config_forms coreConfigForms ON coreConfigElements.form_id = coreConfigForms.id INNER JOIN s_core_plugins corePlugins ON coreConfigForms.plugin_id = corePlugins.id WHERE ( corePlugins.name = : pluginName3150267880 ) AND ( coreConfigValues.shop_id = : shopId2212294583 ) |
array:2 [ "pluginName3150267880" => "ViisonPickwarePOS" "shopId2212294583" => 1 ] |
0.0002 ms |
SELECT coreConfigElements.name, coreConfigElements.value FROM s_core_config_elements coreConfigElements INNER JOIN s_core_config_forms coreConfigForms ON coreConfigElements.form_id = coreConfigForms.id INNER JOIN s_core_plugins corePlugins ON coreConfigForms.plugin_id = corePlugins.id WHERE corePlugins.name = : pluginName3150267880 |
array:1 [ "pluginName3150267880" => "ViisonPickwarePOS" ] |
0.0002 ms |
SELECT coreConfigElements.name, coreConfigValues.value FROM s_core_config_values coreConfigValues INNER JOIN s_core_config_elements coreConfigElements ON coreConfigValues.element_id = coreConfigElements.id INNER JOIN s_core_config_forms coreConfigForms ON coreConfigElements.form_id = coreConfigForms.id INNER JOIN s_core_plugins corePlugins ON coreConfigForms.plugin_id = corePlugins.id WHERE ( corePlugins.name = : pluginName3899353074 ) AND ( coreConfigValues.shop_id = : shopId2212294583 ) |
array:2 [ "pluginName3899353074" => "sKUZOOffer" "shopId2212294583" => 1 ] |
0.0004 ms |
SELECT coreConfigElements.name, coreConfigElements.value FROM s_core_config_elements coreConfigElements INNER JOIN s_core_config_forms coreConfigForms ON coreConfigElements.form_id = coreConfigForms.id INNER JOIN s_core_plugins corePlugins ON coreConfigForms.plugin_id = corePlugins.id WHERE corePlugins.name = : pluginName3899353074 |
array:1 [ "pluginName3899353074" => "sKUZOOffer" ] |
0.0002 ms |
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, t0.translations AS translations_25, t0.in_safe_mode AS in_safe_mode_26 FROM s_core_plugins t0 WHERE t0.name IN (?) AND t0.active = ? |
array:2 [ 0 => array:4 [ 0 => "ViisonPickwareERP" 1 => "ViisonPickwareCommon" 2 => "ViisonPickwarePOS" 3 => "ViisonPickwareMobile" ] 1 => true ] |
0.0003 ms |
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, t0.translations AS translations_25, t0.in_safe_mode AS in_safe_mode_26 FROM s_core_plugins t0 WHERE t0.name IN (?) AND t0.active = ? |
array:2 [ 0 => array:4 [ 0 => "ViisonPickwareERP" 1 => "ViisonPickwareCommon" 2 => "ViisonPickwarePOS" 3 => "ViisonPickwareMobile" ] 1 => true ] |
0.0004 ms |
SELECT coreConfigElements.name, coreConfigValues.value FROM s_core_config_values coreConfigValues INNER JOIN s_core_config_elements coreConfigElements ON coreConfigValues.element_id = coreConfigElements.id INNER JOIN s_core_config_forms coreConfigForms ON coreConfigElements.form_id = coreConfigForms.id INNER JOIN s_core_plugins corePlugins ON coreConfigForms.plugin_id = corePlugins.id WHERE ( corePlugins.name = : pluginName2040627552 ) AND ( coreConfigValues.shop_id = : shopId2212294583 ) |
array:2 [ "pluginName2040627552" => "almArticleBadges" "shopId2212294583" => 1 ] |
0.0002 ms |
SELECT coreConfigElements.name, coreConfigElements.value FROM s_core_config_elements coreConfigElements INNER JOIN s_core_config_forms coreConfigForms ON coreConfigElements.form_id = coreConfigForms.id INNER JOIN s_core_plugins corePlugins ON coreConfigForms.plugin_id = corePlugins.id WHERE corePlugins.name = : pluginName2040627552 |
array:1 [ "pluginName2040627552" => "almArticleBadges" ] |
0.0002 ms |
SELECT t0.id AS id_1, t0.date AS date_2, t0.method AS method_3, t0.url AS url_4, t0.requestHeaders AS requestHeaders_5, t0.requestData AS requestData_6, t0.responseCode AS responseCode_7, t0.responseHeaders AS responseHeaders_8, t0.responseData AS responseData_9, t0.exception AS exception_10, t0.user AS user_11, t0.ipAddress AS ipAddress_12, t0.userAgent AS userAgent_13, t0.computationTime AS computationTime_14, t0.idempotentOperationId AS idempotentOperationId_15, t0.idempotentOperationId AS idempotentOperationId_16 FROM pickware_erp_rest_api_requests t0 WHERE t0.id = ? |
array:1 [ 0 => 0 ] |
0.0022 ms |
SELECT @@SESSION.collation_connection; |
[] |
0.0001 ms |
"START TRANSACTION" |
null
|
0.0000 ms |
SELECT * FROM b2b_s_order_change_queue WHERE request_uuid = @b2b_request_uuid COLLATE utf8mb4_general_ci GROUP BY s_order_id; |
[] |
0.0002 ms |
DELETE FROM b2b_s_order_change_queue WHERE request_uuid = @b2b_request_uuid COLLATE utf8mb4_general_ci |
null
|
0.0001 ms |
"COMMIT" |
null
|
0.0000 ms |
SELECT coreConfigElements.name, coreConfigValues.value FROM s_core_config_values coreConfigValues INNER JOIN s_core_config_elements coreConfigElements ON coreConfigValues.element_id = coreConfigElements.id INNER JOIN s_core_config_forms coreConfigForms ON coreConfigElements.form_id = coreConfigForms.id INNER JOIN s_core_plugins corePlugins ON coreConfigForms.plugin_id = corePlugins.id WHERE ( corePlugins.name = : pluginName288793961 ) AND ( coreConfigValues.shop_id = : shopId2212294583 ) |
array:2 [ "pluginName288793961" => "PasswordEncoder" "shopId2212294583" => 1 ] |
0.0003 ms |
SELECT coreConfigElements.name, coreConfigElements.value FROM s_core_config_elements coreConfigElements INNER JOIN s_core_config_forms coreConfigForms ON coreConfigElements.form_id = coreConfigForms.id INNER JOIN s_core_plugins corePlugins ON coreConfigForms.plugin_id = corePlugins.id WHERE corePlugins.name = : pluginName288793961 |
array:1 [ "pluginName288793961" => "PasswordEncoder" ] |
0.0002 ms |
SELECT `locale`.`locale` FROM `s_core_shops` AS `shop` LEFT JOIN `s_core_locales` AS `locale` ON `locale`.`id` = `shop`.`locale_id` WHERE `shop`.`default` = 1 |
[] |
0.2210 ms |
SELECT name FROM s_core_documents dt INNER JOIN s_plugin_viison_coupon_coupon_document_types cdt ON cdt.documentTypeId = dt.id |
[] |
0.1559 ms |