22.06 ms
15
SELECT `app` . `id` as `app.id` , `app` . `name` as `app.name` , `app` . `path` as `app.path` , `app` . `author` as `app.author` , `app` . `copyright` as `app.copyright` , `app` . `license` as `app.license` , `app` . `active` as `app.active` , `app` . `configurable` as `app.configurable` , `app` . `privacy` as `app.privacy` , `app` . `version` as `app.version` , `app` . `icon` as `app.iconRaw` , `app` . `app_secret` as `app.appSecret` , `app` . `modules` as `app.modules` , `app` . `main_module` as `app.mainModule` , `app` . `cookies` as `app.cookies` , `app` . `allow_disable` as `app.allowDisable` , `app` . `base_app_url` as `app.baseAppUrl` , `app` . `allowed_hosts` as `app.allowedHosts` , `app` . `template_load_priority` as `app.templateLoadPriority` , `app` . `integration_id` as `app.integrationId` , `app.integration` . `id` as `app.integration.id` , `app.integration` . `label` as `app.integration.label` , `app.integration` . `access_key` as `app.integration.accessKey` , `app.integration` . `secret_access_key` as `app.integration.secretAccessKey` , `app.integration` . `last_usage_at` as `app.integration.lastUsageAt` , `app.integration` . `admin` as `app.integration.admin` , `app.integration` . `custom_fields` as `app.integration.customFields` , `app.integration` . `deleted_at` as `app.integration.deletedAt` , `app.integration` . `write_access` as `app.integration.writeAccess` , `app.integration` . `created_at` as `app.integration.createdAt` , `app.integration` . `updated_at` as `app.integration.updatedAt` , `app` . `acl_role_id` as `app.aclRoleId` , `app.aclRole` . `id` as `app.aclRole.id` , `app.aclRole` . `name` as `app.aclRole.name` , `app.aclRole` . `description` as `app.aclRole.description` , `app.aclRole` . `privileges` as `app.aclRole.privileges` , `app.aclRole` . `deleted_at` as `app.aclRole.deletedAt` , `app.aclRole` . `created_at` as `app.aclRole.createdAt` , `app.aclRole` . `updated_at` as `app.aclRole.updatedAt` , `app` . `created_at` as `app.createdAt` , `app` . `updated_at` as `app.updatedAt` , `app.translation.label` , COALESCE (`app.translation.label` , `app.translation.label` ) as `app.label` , `app.translation.description` , COALESCE (`app.translation.description` , `app.translation.description` ) as `app.description` , `app.translation.privacyPolicyExtensions` , COALESCE (`app.translation.privacyPolicyExtensions` , `app.translation.privacyPolicyExtensions` ) as `app.privacyPolicyExtensions` , `app.translation.customFields` , COALESCE (`app.translation.customFields` , `app.translation.customFields` ) as `app.customFields` , `app.translation.createdAt` , `app.translation.updatedAt` , `app.translation.appId` , `app.translation.languageId` FROM `app` LEFT JOIN (SELECT `app.translation` . app_id , `app.translation` . label as `app.translation.label` , `app.translation` . description as `app.translation.description` , `app.translation` . privacy_policy_extensions as `app.translation.privacyPolicyExtensions` , `app.translation` . custom_fields as `app.translation.customFields` , `app.translation` . created_at as `app.translation.createdAt` , `app.translation` . updated_at as `app.translation.updatedAt` , `app.translation` . app_id as `app.translation.appId` , `app.translation` . language_id as `app.translation.languageId` FROM `app_translation` `app.translation` WHERE `app.translation` . language_id = ? ) `app.app_translation` ON `app.app_translation` . `app_id` = `app` . `id` LEFT JOIN `integration` `app.integration` ON `app` . `integration_id` = `app.integration` . `id` LEFT JOIN `acl_role` `app.aclRole` ON `app` . `acl_role_id` = `app.aclRole` . `id` WHERE `app` . `id` IN (? )
Parameters :
[
b"/»_ââšMpªXTÎ|ãâ\v "
b"\x01 ‰±5ÆYp\x07 €£êò\f õÃá ]
SELECT
`app` . `id` as `app.id` ,
`app` . `name` as `app.name` ,
`app` . `path` as `app.path` ,
`app` . `author` as `app.author` ,
`app` . `copyright` as `app.copyright` ,
`app` . `license` as `app.license` ,
`app` . `active` as `app.active` ,
`app` . `configurable` as `app.configurable` ,
`app` . `privacy` as `app.privacy` ,
`app` . `version` as `app.version` ,
`app` . `icon` as `app.iconRaw` ,
`app` . `app_secret` as `app.appSecret` ,
`app` . `modules` as `app.modules` ,
`app` . `main_module` as `app.mainModule` ,
`app` . `cookies` as `app.cookies` ,
`app` . `allow_disable` as `app.allowDisable` ,
`app` . `base_app_url` as `app.baseAppUrl` ,
`app` . `allowed_hosts` as `app.allowedHosts` ,
`app` . `template_load_priority` as `app.templateLoadPriority` ,
`app` . `integration_id` as `app.integrationId` ,
`app.integration` . `id` as `app.integration.id` ,
`app.integration` . `label` as `app.integration.label` ,
`app.integration` . `access_key` as `app.integration.accessKey` ,
`app.integration` . `secret_access_key` as `app.integration.secretAccessKey` ,
`app.integration` . `last_usage_at` as `app.integration.lastUsageAt` ,
`app.integration` . `admin` as `app.integration.admin` ,
`app.integration` . `custom_fields` as `app.integration.customFields` ,
`app.integration` . `deleted_at` as `app.integration.deletedAt` ,
`app.integration` . `write_access` as `app.integration.writeAccess` ,
`app.integration` . `created_at` as `app.integration.createdAt` ,
`app.integration` . `updated_at` as `app.integration.updatedAt` ,
`app` . `acl_role_id` as `app.aclRoleId` ,
`app.aclRole` . `id` as `app.aclRole.id` ,
`app.aclRole` . `name` as `app.aclRole.name` ,
`app.aclRole` . `description` as `app.aclRole.description` ,
`app.aclRole` . `privileges` as `app.aclRole.privileges` ,
`app.aclRole` . `deleted_at` as `app.aclRole.deletedAt` ,
`app.aclRole` . `created_at` as `app.aclRole.createdAt` ,
`app.aclRole` . `updated_at` as `app.aclRole.updatedAt` ,
`app` . `created_at` as `app.createdAt` ,
`app` . `updated_at` as `app.updatedAt` ,
`app.translation.label` ,
COALESCE (
`app.translation.label` , `app.translation.label`
) as `app.label` ,
`app.translation.description` ,
COALESCE (
`app.translation.description` , `app.translation.description`
) as `app.description` ,
`app.translation.privacyPolicyExtensions` ,
COALESCE (
`app.translation.privacyPolicyExtensions` ,
`app.translation.privacyPolicyExtensions`
) as `app.privacyPolicyExtensions` ,
`app.translation.customFields` ,
COALESCE (
`app.translation.customFields` ,
`app.translation.customFields`
) as `app.customFields` ,
`app.translation.createdAt` ,
`app.translation.updatedAt` ,
`app.translation.appId` ,
`app.translation.languageId`
FROM
`app`
LEFT JOIN (
SELECT
`app.translation` . app_id ,
`app.translation` . label as `app.translation.label` ,
`app.translation` . description as `app.translation.description` ,
`app.translation` . privacy_policy_extensions as `app.translation.privacyPolicyExtensions` ,
`app.translation` . custom_fields as `app.translation.customFields` ,
`app.translation` . created_at as `app.translation.createdAt` ,
`app.translation` . updated_at as `app.translation.updatedAt` ,
`app.translation` . app_id as `app.translation.appId` ,
`app.translation` . language_id as `app.translation.languageId`
FROM
`app_translation` `app.translation`
WHERE
`app.translation` . language_id = ?
) `app.app_translation` ON `app.app_translation` . `app_id` = `app` . `id`
LEFT JOIN `integration` `app.integration` ON `app` . `integration_id` = `app.integration` . `id`
LEFT JOIN `acl_role` `app.aclRole` ON `app` . `acl_role_id` = `app.aclRole` . `id`
WHERE
`app` . `id` IN (? )Copy
SELECT `app` . `id` as `app.id` , `app` . `name` as `app.name` , `app` . `path` as `app.path` , `app` . `author` as `app.author` , `app` . `copyright` as `app.copyright` , `app` . `license` as `app.license` , `app` . `active` as `app.active` , `app` . `configurable` as `app.configurable` , `app` . `privacy` as `app.privacy` , `app` . `version` as `app.version` , `app` . `icon` as `app.iconRaw` , `app` . `app_secret` as `app.appSecret` , `app` . `modules` as `app.modules` , `app` . `main_module` as `app.mainModule` , `app` . `cookies` as `app.cookies` , `app` . `allow_disable` as `app.allowDisable` , `app` . `base_app_url` as `app.baseAppUrl` , `app` . `allowed_hosts` as `app.allowedHosts` , `app` . `template_load_priority` as `app.templateLoadPriority` , `app` . `integration_id` as `app.integrationId` , `app.integration` . `id` as `app.integration.id` , `app.integration` . `label` as `app.integration.label` , `app.integration` . `access_key` as `app.integration.accessKey` , `app.integration` . `secret_access_key` as `app.integration.secretAccessKey` , `app.integration` . `last_usage_at` as `app.integration.lastUsageAt` , `app.integration` . `admin` as `app.integration.admin` , `app.integration` . `custom_fields` as `app.integration.customFields` , `app.integration` . `deleted_at` as `app.integration.deletedAt` , `app.integration` . `write_access` as `app.integration.writeAccess` , `app.integration` . `created_at` as `app.integration.createdAt` , `app.integration` . `updated_at` as `app.integration.updatedAt` , `app` . `acl_role_id` as `app.aclRoleId` , `app.aclRole` . `id` as `app.aclRole.id` , `app.aclRole` . `name` as `app.aclRole.name` , `app.aclRole` . `description` as `app.aclRole.description` , `app.aclRole` . `privileges` as `app.aclRole.privileges` , `app.aclRole` . `deleted_at` as `app.aclRole.deletedAt` , `app.aclRole` . `created_at` as `app.aclRole.createdAt` , `app.aclRole` . `updated_at` as `app.aclRole.updatedAt` , `app` . `created_at` as `app.createdAt` , `app` . `updated_at` as `app.updatedAt` , `app.translation.label` , COALESCE (`app.translation.label` , `app.translation.label` ) as `app.label` , `app.translation.description` , COALESCE (`app.translation.description` , `app.translation.description` ) as `app.description` , `app.translation.privacyPolicyExtensions` , COALESCE (`app.translation.privacyPolicyExtensions` , `app.translation.privacyPolicyExtensions` ) as `app.privacyPolicyExtensions` , `app.translation.customFields` , COALESCE (`app.translation.customFields` , `app.translation.customFields` ) as `app.customFields` , `app.translation.createdAt` , `app.translation.updatedAt` , `app.translation.appId` , `app.translation.languageId` FROM `app` LEFT JOIN (SELECT `app.translation` . app_id , `app.translation` . label as `app.translation.label` , `app.translation` . description as `app.translation.description` , `app.translation` . privacy_policy_extensions as `app.translation.privacyPolicyExtensions` , `app.translation` . custom_fields as `app.translation.customFields` , `app.translation` . created_at as `app.translation.createdAt` , `app.translation` . updated_at as `app.translation.updatedAt` , `app.translation` . app_id as `app.translation.appId` , `app.translation` . language_id as `app.translation.languageId` FROM `app_translation` `app.translation` WHERE `app.translation` . language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) `app.app_translation` ON `app.app_translation` . `app_id` = `app` . `id` LEFT JOIN `integration` `app.integration` ON `app` . `integration_id` = `app.integration` . `id` LEFT JOIN `acl_role` `app.aclRole` ON `app` . `acl_role_id` = `app.aclRole` . `id` WHERE `app` . `id` IN (0x0189B135C659700780A3EAF20CF5C3E1 ); Copy
15.05 ms
15
SELECT `script` . `id` as `script.id` , `script` . `script` as `script.script` , `script` . `hook` as `script.hook` , `script` . `name` as `script.name` , `script` . `active` as `script.active` , `script` . `app_id` as `script.appId` , `script` . `created_at` as `script.createdAt` , `script` . `updated_at` as `script.updatedAt` FROM `script` WHERE (`script` . `app_id` IN (? ))
Parameters :
[
b"\x01 ‰±5ÆYp\x07 €£êò\f õÃá ]
SELECT `script` . `id` as `script.id` , `script` . `script` as `script.script` , `script` . `hook` as `script.hook` , `script` . `name` as `script.name` , `script` . `active` as `script.active` , `script` . `app_id` as `script.appId` , `script` . `created_at` as `script.createdAt` , `script` . `updated_at` as `script.updatedAt` FROM `script` WHERE (`script` . `app_id` IN (0x0189B135C659700780A3EAF20CF5C3E1 )); Copy
12.81 ms
1
SELECT seo_path_info , path_info , sales_channel_id FROM seo_url WHERE (seo_url . is_canonical = 1 ) AND (seo_url . path_info IN (? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? )) AND (seo_url . language_id = ? ) AND (seo_url . sales_channel_id = ? OR seo_url . sales_channel_id IS NULL ) AND (seo_url . is_deleted = 0 )
Parameters :
[
"/navigation/4f2d452ecaffc1a1cff6417787162675 "
"/note "
"/navigation/93a4337318f0054690d354de28c5dddc "
"/navigation/fd676cf919c6fa8bd32dc34773cdd1a2 "
"/navigation/b043ac3b6b3140955905850879e26592 "
"/navigation/eff45ba8ecb85b0ade6abc9b2e928e82 "
"/navigation/fa16ab0a538a8501a95e8578041b2f59 "
"/navigation/131942a1db80fb0ac3ce5522c90415f3 "
"/navigation/24aca821ba4db7ab66c76a5fd7ae0cc5 "
"/navigation/34b3309fc64351ac445a4c172cb4d44c "
"/landingPage/132b3e541f3a46778137ebdc495c60fd "
"/navigation/bb3af78c78896a1e31b7ef400d3a28fc "
"/navigation/1c518506f752949ec293737722e4499b "
"/navigation/778e0ed7ab5c1a7d786e8e8b3a676d14 "
"/navigation/5ecbefc853199c4a26f05d46ceb6c86a "
"/navigation/6dda38aeb1d0f1ae1544b23c8f08c1bf "
"/navigation/e0fafb740f309b9617c6851e26daac7b "
"/navigation/165bf1461c54c861b54db9502494e8bb "
"/navigation/d06491a73f7481f8d0f6c8420a2ba270 "
"/navigation/f3fbbedf45da7098e77af90ab3fed694 "
"/navigation/9dbceb82cd1ad9852be2d66c03f42805 "
"/navigation/f9153356d34d571babf82f7a32523837 "
"/detail/5c25705ab668cf993926245948f86d00 "
"/navigation/89abb3174e2d7e7304e9f3a525fc5b86 "
"/navigation/e710d14628a15b62da0ad737eafca643 "
"/navigation/b69ddce29e21df7be3020bed56282668 "
"/navigation/2f291725e83f578c57b926f542e7e22f "
"/navigation/2a6ed2c9e3caee7fcfe61c55fbc08757 "
"/navigation/6fb849e2ef6ce9da07eeaf2f70016495 "
"/navigation/3f62648c673058f2d1499975a6b445a2 "
"/navigation/b67d8baa46c67425f0f0948cd6d58411 "
"/navigation/ec05f0a7bc40c9e7e3a118a0ad5f3802 "
"/navigation/71f3f644a2728c9f4ede6fe5d0b0fbd9 "
"/navigation/580d21fec58a183e72b8608115df7a9f "
"/navigation/0d40a9663c11a2342f02e447f269023c "
"/navigation/2488454d5762b2f97c085f3160753fd0 "
"/navigation/eeafdd77e2abc9dc08b3bbf011ff97bf "
"/navigation/94e0ed4a8dc29ec245c846b8dd35db95 "
"/navigation/e24dd7d82ce4461d63fceb2576dd2819 "
"/navigation/6805a9e4583dd6c416186289bcc86d12 "
"/navigation/35b1adb37395d91de43b0b4634b78663 "
"/navigation/3547ce3e294d5d08530d29045149f0e2 "
"/navigation/484a5288a950ad9a143cb8c4c6f6aa39 "
"/navigation/80c2cdca20d8cacfcff206d2caa93ebf "
"/navigation/00f7b8117945483ea1ad5204fbb7a2b9 "
"/navigation/22bf636f562462eb849b23a878c6eca8 "
"/navigation/981758de3d52c50a878b1f25eecd8742 "
"/navigation/38fa32fdc995af57b8c0fdde4ceea074 "
"/navigation/043a706bfe30516c97d46a838b8902c5 "
"/navigation/bef204edf93555e1d960ccdbe66c08b8 "
"/navigation/90dc8d5ca64af4113933927420c2f66c "
"/navigation/df7051ed7bb92ac154f23fd0e4034f23 "
"/navigation/bf9f6f2f198741008dccbb762c7d50b2 "
"/navigation/7658f31a192ad7978f92a03c9878ceab "
"/navigation/0bf4f16f690c467e31d903a04185d95b "
"/navigation/7cc2aa0bfe1a099b0d4c3a3e4648569d "
"/navigation/4e6a91d907322489a2fd17d46071ec97 "
"/navigation/77848cf4f279d463177d2695ec7811dc "
"/navigation/7a6cf7b63e9849798fde605516a7e2ce "
"/navigation/7ba75687d380c1652767a9f7cea72c46 "
"/navigation/d406cad7131ab368a9af4b2af7be669b "
"/navigation/2276908e77e901a5f9700b10a2e42f1d "
"/navigation/4d4cc90a5eff22ccc630475c8985b11c "
"/navigation/24d6be0ee3f75d3cf14ad646e15b5706 "
"/navigation/95d19b7d2a43bca874ed937173ab818d "
"/navigation/f67a99c5bf8c0bd4fb150997bf0de350 "
"/navigation/e9a88b01e32a9d86660c8c8b3334b500 "
"/navigation/0cc4d1e6097fb38dfc49b3e035911870 "
"/navigation/225a611208d5a56f780026586f84acd0 "
"/navigation/5536c572dcdd2656aad11feb2e8d6309 "
"/navigation/64ed80ef87b9b9b754be36772425e947 "
"/navigation/40ed8a18f47da7d87f6c8719bb28385a "
"/navigation/499456f34de05a8962ada7af19c70b70 "
"/navigation/38af3ad37d571a413da701644b1511b9 "
"/navigation/1c1708cf9234149e42c462815ab6db09 "
"/navigation/ea18b796828ab701c109d6c82cd644f4 "
"/navigation/6bcdc53ba589d9ca5e0a806b247beabd "
"/landingPage/01900bcdf62a789ba0e74be57b210083 "
"/landingPage/0190973de41a757d89600621522778a1 "
"/landingPage/38bdd0c3e4ef4cdd94eb98e6acec006b "
"/landingPage/018ee7156a227c90a5cae86d76127ead "
"/landingPage/0190307e217c7fc892e45b7ec067d6b5 "
"/landingPage/01901652ffbf78e6be8e6d19d0af461b "
"/landingPage/05e1ea75fb5248d48ecd6f533ceb0643 "
"/landingPage/018ebcad754a70abb7d72fcffdd4fb8e "
"/landingPage/018eeae802b676f98f5b75096f158d8f "
"/landingPage/80b15d8cbdd64db29782cecb9e837b4b "
"/landingPage/3215141b9d834c4a85e405f40cfd0151 "
"/landingPage/c4b54c9423c94cb882f32376fbcdc2cc "
"/landingPage/6cfbd3fb873e4379955f38697d0cee51 "
"/landingPage/0190790d6fe477109ef87826b43657e4 "
"/landingPage/018fbf3fff2c78e1adc27bfd4efa60a6 "
"/landingPage/7fb1ee1593f14ffe8d1a3de9f29f3fa0 "
"/landingPage/535996cae7b54c7fa2321e5d03c734dc "
"/landingPage/018fb926e4177c90a5b229230ba9229b "
"/landingPage/018fe30405f873eb8a445e81d223f44e "
"/landingPage/018fde7030da73dc9e85c4e23d665202 "
"/landingPage/4d4c983734434b1bac6951f026cb2569 "
"/detail/13466a35cf36ba1928d56ade5d350d6b "
"/detail/36918680607bd33777215fc995d0797a "
"/detail/301f77896dd858656f9458eb853b0e14 "
"/detail/0bf3debcd963233c4f92e32bbfabea9b "
"/detail/388225c461c4166c8b0b7f5503e84743 "
"/detail/a3b08d8c695a525717c64a8643b0f505 "
"/detail/356ac7ebf1fd5bcd91faac08bf8935dc "
"/detail/8eb8349bde3459003a2fb4b04ac3eb49 "
"/detail/5e718484f0bfff6de90ddde2ac1106fb "
"/detail/40d97ad7696554abe0f5231810dcb21d "
"/detail/27e99b97d6f46b8781a0d0b41acdeae2 "
"/detail/a28cbfcccaef9099bc2729b3fcccda26 "
"/detail/0ce4badccc48b1c41c35c646199c822b "
"/detail/074fb69317549035b3d91e0a57ac5765 "
"/detail/1fa71057e6dc6627582591ee6e5908bb "
"/detail/d03f5e61ff46a7ae0cce0d0929be618a "
"/detail/84300a1f19738f18bfbf008af7f83151 "
"/detail/ce3cf8be0c128f5788a36afa7b06879d "
"/detail/4b1430bc03e92cfa65773358f2a88228 "
"/detail/e7726c2097f4b3a3c5df4a1e02ead549 "
"/detail/5efe853e61b6a72201e4cf2fcc86386d "
"/detail/29937fb3fae929939fdabdab7d8688d0 "
"/detail/c48668ab52cc51fb1f92ae0ba3fa5a68 "
"/detail/eb5ddaad9bf7c36458cc8e2f3917a5b2 "
"/navigation/fbec4d5652ba6ca205fcee47f291b602 "
"/detail/d96aef2e7f7d39bfa30e3ea809b7eda6 "
"/navigation/47c823ffa54c4a838419e63637237423 "
"/navigation/003fead0b2c54c02b2b6a000fd0dc3c6 "
"/landingPage/019146c494347206b1979287d007975e "
"/navigation/7d5664d1b3e6418f85f1bc53429bc3ca "
"/navigation/513109c128ad4a7ab30fa1d8979d40e0 "
"/navigation/a5b2c8e80d144124a5321366d0d6bdc6 "
"/landingPage/018ee098c74f763e91f7d621dbfa7074 "
"/landingPage/4e6f17971ae5455ab840ad4974ac14a1 "
b"/»_ââšMpªXTÎ|ãâ\v "
b"\x02 a\f\x08 ÑQN├ü\v b¦©!\x19 à ]
SELECT
seo_path_info ,
path_info ,
sales_channel_id
FROM
seo_url
WHERE
(seo_url . is_canonical = 1 )
AND (
seo_url . path_info IN (
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
?
)
)
AND (seo_url . language_id = ? )
AND (
seo_url . sales_channel_id = ?
OR seo_url . sales_channel_id IS NULL
)
AND (seo_url . is_deleted = 0 )
Copy
SELECT seo_path_info , path_info , sales_channel_id FROM seo_url WHERE (seo_url . is_canonical = 1 ) AND (seo_url . path_info IN ('/navigation/4f2d452ecaffc1a1cff6417787162675' , '/note' , '/navigation/93a4337318f0054690d354de28c5dddc' , '/navigation/fd676cf919c6fa8bd32dc34773cdd1a2' , '/navigation/b043ac3b6b3140955905850879e26592' , '/navigation/eff45ba8ecb85b0ade6abc9b2e928e82' , '/navigation/fa16ab0a538a8501a95e8578041b2f59' , '/navigation/131942a1db80fb0ac3ce5522c90415f3' , '/navigation/24aca821ba4db7ab66c76a5fd7ae0cc5' , '/navigation/34b3309fc64351ac445a4c172cb4d44c' , '/landingPage/132b3e541f3a46778137ebdc495c60fd' , '/navigation/bb3af78c78896a1e31b7ef400d3a28fc' , '/navigation/1c518506f752949ec293737722e4499b' , '/navigation/778e0ed7ab5c1a7d786e8e8b3a676d14' , '/navigation/5ecbefc853199c4a26f05d46ceb6c86a' , '/navigation/6dda38aeb1d0f1ae1544b23c8f08c1bf' , '/navigation/e0fafb740f309b9617c6851e26daac7b' , '/navigation/165bf1461c54c861b54db9502494e8bb' , '/navigation/d06491a73f7481f8d0f6c8420a2ba270' , '/navigation/f3fbbedf45da7098e77af90ab3fed694' , '/navigation/9dbceb82cd1ad9852be2d66c03f42805' , '/navigation/f9153356d34d571babf82f7a32523837' , '/detail/5c25705ab668cf993926245948f86d00' , '/navigation/89abb3174e2d7e7304e9f3a525fc5b86' , '/navigation/e710d14628a15b62da0ad737eafca643' , '/navigation/b69ddce29e21df7be3020bed56282668' , '/navigation/2f291725e83f578c57b926f542e7e22f' , '/navigation/2a6ed2c9e3caee7fcfe61c55fbc08757' , '/navigation/6fb849e2ef6ce9da07eeaf2f70016495' , '/navigation/3f62648c673058f2d1499975a6b445a2' , '/navigation/b67d8baa46c67425f0f0948cd6d58411' , '/navigation/ec05f0a7bc40c9e7e3a118a0ad5f3802' , '/navigation/71f3f644a2728c9f4ede6fe5d0b0fbd9' , '/navigation/580d21fec58a183e72b8608115df7a9f' , '/navigation/0d40a9663c11a2342f02e447f269023c' , '/navigation/2488454d5762b2f97c085f3160753fd0' , '/navigation/eeafdd77e2abc9dc08b3bbf011ff97bf' , '/navigation/94e0ed4a8dc29ec245c846b8dd35db95' , '/navigation/e24dd7d82ce4461d63fceb2576dd2819' , '/navigation/6805a9e4583dd6c416186289bcc86d12' , '/navigation/35b1adb37395d91de43b0b4634b78663' , '/navigation/3547ce3e294d5d08530d29045149f0e2' , '/navigation/484a5288a950ad9a143cb8c4c6f6aa39' , '/navigation/80c2cdca20d8cacfcff206d2caa93ebf' , '/navigation/00f7b8117945483ea1ad5204fbb7a2b9' , '/navigation/22bf636f562462eb849b23a878c6eca8' , '/navigation/981758de3d52c50a878b1f25eecd8742' , '/navigation/38fa32fdc995af57b8c0fdde4ceea074' , '/navigation/043a706bfe30516c97d46a838b8902c5' , '/navigation/bef204edf93555e1d960ccdbe66c08b8' , '/navigation/90dc8d5ca64af4113933927420c2f66c' , '/navigation/df7051ed7bb92ac154f23fd0e4034f23' , '/navigation/bf9f6f2f198741008dccbb762c7d50b2' , '/navigation/7658f31a192ad7978f92a03c9878ceab' , '/navigation/0bf4f16f690c467e31d903a04185d95b' , '/navigation/7cc2aa0bfe1a099b0d4c3a3e4648569d' , '/navigation/4e6a91d907322489a2fd17d46071ec97' , '/navigation/77848cf4f279d463177d2695ec7811dc' , '/navigation/7a6cf7b63e9849798fde605516a7e2ce' , '/navigation/7ba75687d380c1652767a9f7cea72c46' , '/navigation/d406cad7131ab368a9af4b2af7be669b' , '/navigation/2276908e77e901a5f9700b10a2e42f1d' , '/navigation/4d4cc90a5eff22ccc630475c8985b11c' , '/navigation/24d6be0ee3f75d3cf14ad646e15b5706' , '/navigation/95d19b7d2a43bca874ed937173ab818d' , '/navigation/f67a99c5bf8c0bd4fb150997bf0de350' , '/navigation/e9a88b01e32a9d86660c8c8b3334b500' , '/navigation/0cc4d1e6097fb38dfc49b3e035911870' , '/navigation/225a611208d5a56f780026586f84acd0' , '/navigation/5536c572dcdd2656aad11feb2e8d6309' , '/navigation/64ed80ef87b9b9b754be36772425e947' , '/navigation/40ed8a18f47da7d87f6c8719bb28385a' , '/navigation/499456f34de05a8962ada7af19c70b70' , '/navigation/38af3ad37d571a413da701644b1511b9' , '/navigation/1c1708cf9234149e42c462815ab6db09' , '/navigation/ea18b796828ab701c109d6c82cd644f4' , '/navigation/6bcdc53ba589d9ca5e0a806b247beabd' , '/landingPage/01900bcdf62a789ba0e74be57b210083' , '/landingPage/0190973de41a757d89600621522778a1' , '/landingPage/38bdd0c3e4ef4cdd94eb98e6acec006b' , '/landingPage/018ee7156a227c90a5cae86d76127ead' , '/landingPage/0190307e217c7fc892e45b7ec067d6b5' , '/landingPage/01901652ffbf78e6be8e6d19d0af461b' , '/landingPage/05e1ea75fb5248d48ecd6f533ceb0643' , '/landingPage/018ebcad754a70abb7d72fcffdd4fb8e' , '/landingPage/018eeae802b676f98f5b75096f158d8f' , '/landingPage/80b15d8cbdd64db29782cecb9e837b4b' , '/landingPage/3215141b9d834c4a85e405f40cfd0151' , '/landingPage/c4b54c9423c94cb882f32376fbcdc2cc' , '/landingPage/6cfbd3fb873e4379955f38697d0cee51' , '/landingPage/0190790d6fe477109ef87826b43657e4' , '/landingPage/018fbf3fff2c78e1adc27bfd4efa60a6' , '/landingPage/7fb1ee1593f14ffe8d1a3de9f29f3fa0' , '/landingPage/535996cae7b54c7fa2321e5d03c734dc' , '/landingPage/018fb926e4177c90a5b229230ba9229b' , '/landingPage/018fe30405f873eb8a445e81d223f44e' , '/landingPage/018fde7030da73dc9e85c4e23d665202' , '/landingPage/4d4c983734434b1bac6951f026cb2569' , '/detail/13466a35cf36ba1928d56ade5d350d6b' , '/detail/36918680607bd33777215fc995d0797a' , '/detail/301f77896dd858656f9458eb853b0e14' , '/detail/0bf3debcd963233c4f92e32bbfabea9b' , '/detail/388225c461c4166c8b0b7f5503e84743' , '/detail/a3b08d8c695a525717c64a8643b0f505' , '/detail/356ac7ebf1fd5bcd91faac08bf8935dc' , '/detail/8eb8349bde3459003a2fb4b04ac3eb49' , '/detail/5e718484f0bfff6de90ddde2ac1106fb' , '/detail/40d97ad7696554abe0f5231810dcb21d' , '/detail/27e99b97d6f46b8781a0d0b41acdeae2' , '/detail/a28cbfcccaef9099bc2729b3fcccda26' , '/detail/0ce4badccc48b1c41c35c646199c822b' , '/detail/074fb69317549035b3d91e0a57ac5765' , '/detail/1fa71057e6dc6627582591ee6e5908bb' , '/detail/d03f5e61ff46a7ae0cce0d0929be618a' , '/detail/84300a1f19738f18bfbf008af7f83151' , '/detail/ce3cf8be0c128f5788a36afa7b06879d' , '/detail/4b1430bc03e92cfa65773358f2a88228' , '/detail/e7726c2097f4b3a3c5df4a1e02ead549' , '/detail/5efe853e61b6a72201e4cf2fcc86386d' , '/detail/29937fb3fae929939fdabdab7d8688d0' , '/detail/c48668ab52cc51fb1f92ae0ba3fa5a68' , '/detail/eb5ddaad9bf7c36458cc8e2f3917a5b2' , '/navigation/fbec4d5652ba6ca205fcee47f291b602' , '/detail/d96aef2e7f7d39bfa30e3ea809b7eda6' , '/navigation/47c823ffa54c4a838419e63637237423' , '/navigation/003fead0b2c54c02b2b6a000fd0dc3c6' , '/landingPage/019146c494347206b1979287d007975e' , '/navigation/7d5664d1b3e6418f85f1bc53429bc3ca' , '/navigation/513109c128ad4a7ab30fa1d8979d40e0' , '/navigation/a5b2c8e80d144124a5321366d0d6bdc6' , '/landingPage/018ee098c74f763e91f7d621dbfa7074' , '/landingPage/4e6f17971ae5455ab840ad4974ac14a1' )) AND (seo_url . language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) AND (seo_url . sales_channel_id = 0x02610C08A5514EC3810B62DDB82119C7 OR seo_url . sales_channel_id IS NULL ) AND (seo_url . is_deleted = 0 );
Copy
12.57 ms
5
SELECT `app` . `id` as `app.id` , `app` . `name` as `app.name` , `app` . `path` as `app.path` , `app` . `author` as `app.author` , `app` . `copyright` as `app.copyright` , `app` . `license` as `app.license` , `app` . `active` as `app.active` , `app` . `configurable` as `app.configurable` , `app` . `privacy` as `app.privacy` , `app` . `version` as `app.version` , `app` . `icon` as `app.iconRaw` , `app` . `app_secret` as `app.appSecret` , `app` . `modules` as `app.modules` , `app` . `main_module` as `app.mainModule` , `app` . `cookies` as `app.cookies` , `app` . `allow_disable` as `app.allowDisable` , `app` . `base_app_url` as `app.baseAppUrl` , `app` . `allowed_hosts` as `app.allowedHosts` , `app` . `template_load_priority` as `app.templateLoadPriority` , `app` . `integration_id` as `app.integrationId` , `app.integration` . `id` as `app.integration.id` , `app.integration` . `label` as `app.integration.label` , `app.integration` . `access_key` as `app.integration.accessKey` , `app.integration` . `secret_access_key` as `app.integration.secretAccessKey` , `app.integration` . `last_usage_at` as `app.integration.lastUsageAt` , `app.integration` . `admin` as `app.integration.admin` , `app.integration` . `custom_fields` as `app.integration.customFields` , `app.integration` . `deleted_at` as `app.integration.deletedAt` , `app.integration` . `write_access` as `app.integration.writeAccess` , `app.integration` . `created_at` as `app.integration.createdAt` , `app.integration` . `updated_at` as `app.integration.updatedAt` , `app` . `acl_role_id` as `app.aclRoleId` , `app.aclRole` . `id` as `app.aclRole.id` , `app.aclRole` . `name` as `app.aclRole.name` , `app.aclRole` . `description` as `app.aclRole.description` , `app.aclRole` . `privileges` as `app.aclRole.privileges` , `app.aclRole` . `deleted_at` as `app.aclRole.deletedAt` , `app.aclRole` . `created_at` as `app.aclRole.createdAt` , `app.aclRole` . `updated_at` as `app.aclRole.updatedAt` , `app` . `created_at` as `app.createdAt` , `app` . `updated_at` as `app.updatedAt` , `app.translation.label` , COALESCE (`app.translation.label` , `app.translation.label` ) as `app.label` , `app.translation.description` , COALESCE (`app.translation.description` , `app.translation.description` ) as `app.description` , `app.translation.privacyPolicyExtensions` , COALESCE (`app.translation.privacyPolicyExtensions` , `app.translation.privacyPolicyExtensions` ) as `app.privacyPolicyExtensions` , `app.translation.customFields` , COALESCE (`app.translation.customFields` , `app.translation.customFields` ) as `app.customFields` , `app.translation.createdAt` , `app.translation.updatedAt` , `app.translation.appId` , `app.translation.languageId` FROM `app` LEFT JOIN (SELECT `app.translation` . app_id , `app.translation` . label as `app.translation.label` , `app.translation` . description as `app.translation.description` , `app.translation` . privacy_policy_extensions as `app.translation.privacyPolicyExtensions` , `app.translation` . custom_fields as `app.translation.customFields` , `app.translation` . created_at as `app.translation.createdAt` , `app.translation` . updated_at as `app.translation.updatedAt` , `app.translation` . app_id as `app.translation.appId` , `app.translation` . language_id as `app.translation.languageId` FROM `app_translation` `app.translation` WHERE `app.translation` . language_id = ? ) `app.app_translation` ON `app.app_translation` . `app_id` = `app` . `id` LEFT JOIN `integration` `app.integration` ON `app` . `integration_id` = `app.integration` . `id` LEFT JOIN `acl_role` `app.aclRole` ON `app` . `acl_role_id` = `app.aclRole` . `id` WHERE (`app` . `active` = ? )
Parameters :
[
b"/»_ââšMpªXTÎ|ãâ\v "
true
]
SELECT
`app` . `id` as `app.id` ,
`app` . `name` as `app.name` ,
`app` . `path` as `app.path` ,
`app` . `author` as `app.author` ,
`app` . `copyright` as `app.copyright` ,
`app` . `license` as `app.license` ,
`app` . `active` as `app.active` ,
`app` . `configurable` as `app.configurable` ,
`app` . `privacy` as `app.privacy` ,
`app` . `version` as `app.version` ,
`app` . `icon` as `app.iconRaw` ,
`app` . `app_secret` as `app.appSecret` ,
`app` . `modules` as `app.modules` ,
`app` . `main_module` as `app.mainModule` ,
`app` . `cookies` as `app.cookies` ,
`app` . `allow_disable` as `app.allowDisable` ,
`app` . `base_app_url` as `app.baseAppUrl` ,
`app` . `allowed_hosts` as `app.allowedHosts` ,
`app` . `template_load_priority` as `app.templateLoadPriority` ,
`app` . `integration_id` as `app.integrationId` ,
`app.integration` . `id` as `app.integration.id` ,
`app.integration` . `label` as `app.integration.label` ,
`app.integration` . `access_key` as `app.integration.accessKey` ,
`app.integration` . `secret_access_key` as `app.integration.secretAccessKey` ,
`app.integration` . `last_usage_at` as `app.integration.lastUsageAt` ,
`app.integration` . `admin` as `app.integration.admin` ,
`app.integration` . `custom_fields` as `app.integration.customFields` ,
`app.integration` . `deleted_at` as `app.integration.deletedAt` ,
`app.integration` . `write_access` as `app.integration.writeAccess` ,
`app.integration` . `created_at` as `app.integration.createdAt` ,
`app.integration` . `updated_at` as `app.integration.updatedAt` ,
`app` . `acl_role_id` as `app.aclRoleId` ,
`app.aclRole` . `id` as `app.aclRole.id` ,
`app.aclRole` . `name` as `app.aclRole.name` ,
`app.aclRole` . `description` as `app.aclRole.description` ,
`app.aclRole` . `privileges` as `app.aclRole.privileges` ,
`app.aclRole` . `deleted_at` as `app.aclRole.deletedAt` ,
`app.aclRole` . `created_at` as `app.aclRole.createdAt` ,
`app.aclRole` . `updated_at` as `app.aclRole.updatedAt` ,
`app` . `created_at` as `app.createdAt` ,
`app` . `updated_at` as `app.updatedAt` ,
`app.translation.label` ,
COALESCE (
`app.translation.label` , `app.translation.label`
) as `app.label` ,
`app.translation.description` ,
COALESCE (
`app.translation.description` , `app.translation.description`
) as `app.description` ,
`app.translation.privacyPolicyExtensions` ,
COALESCE (
`app.translation.privacyPolicyExtensions` ,
`app.translation.privacyPolicyExtensions`
) as `app.privacyPolicyExtensions` ,
`app.translation.customFields` ,
COALESCE (
`app.translation.customFields` ,
`app.translation.customFields`
) as `app.customFields` ,
`app.translation.createdAt` ,
`app.translation.updatedAt` ,
`app.translation.appId` ,
`app.translation.languageId`
FROM
`app`
LEFT JOIN (
SELECT
`app.translation` . app_id ,
`app.translation` . label as `app.translation.label` ,
`app.translation` . description as `app.translation.description` ,
`app.translation` . privacy_policy_extensions as `app.translation.privacyPolicyExtensions` ,
`app.translation` . custom_fields as `app.translation.customFields` ,
`app.translation` . created_at as `app.translation.createdAt` ,
`app.translation` . updated_at as `app.translation.updatedAt` ,
`app.translation` . app_id as `app.translation.appId` ,
`app.translation` . language_id as `app.translation.languageId`
FROM
`app_translation` `app.translation`
WHERE
`app.translation` . language_id = ?
) `app.app_translation` ON `app.app_translation` . `app_id` = `app` . `id`
LEFT JOIN `integration` `app.integration` ON `app` . `integration_id` = `app.integration` . `id`
LEFT JOIN `acl_role` `app.aclRole` ON `app` . `acl_role_id` = `app.aclRole` . `id`
WHERE
(`app` . `active` = ? )
Copy
SELECT `app` . `id` as `app.id` , `app` . `name` as `app.name` , `app` . `path` as `app.path` , `app` . `author` as `app.author` , `app` . `copyright` as `app.copyright` , `app` . `license` as `app.license` , `app` . `active` as `app.active` , `app` . `configurable` as `app.configurable` , `app` . `privacy` as `app.privacy` , `app` . `version` as `app.version` , `app` . `icon` as `app.iconRaw` , `app` . `app_secret` as `app.appSecret` , `app` . `modules` as `app.modules` , `app` . `main_module` as `app.mainModule` , `app` . `cookies` as `app.cookies` , `app` . `allow_disable` as `app.allowDisable` , `app` . `base_app_url` as `app.baseAppUrl` , `app` . `allowed_hosts` as `app.allowedHosts` , `app` . `template_load_priority` as `app.templateLoadPriority` , `app` . `integration_id` as `app.integrationId` , `app.integration` . `id` as `app.integration.id` , `app.integration` . `label` as `app.integration.label` , `app.integration` . `access_key` as `app.integration.accessKey` , `app.integration` . `secret_access_key` as `app.integration.secretAccessKey` , `app.integration` . `last_usage_at` as `app.integration.lastUsageAt` , `app.integration` . `admin` as `app.integration.admin` , `app.integration` . `custom_fields` as `app.integration.customFields` , `app.integration` . `deleted_at` as `app.integration.deletedAt` , `app.integration` . `write_access` as `app.integration.writeAccess` , `app.integration` . `created_at` as `app.integration.createdAt` , `app.integration` . `updated_at` as `app.integration.updatedAt` , `app` . `acl_role_id` as `app.aclRoleId` , `app.aclRole` . `id` as `app.aclRole.id` , `app.aclRole` . `name` as `app.aclRole.name` , `app.aclRole` . `description` as `app.aclRole.description` , `app.aclRole` . `privileges` as `app.aclRole.privileges` , `app.aclRole` . `deleted_at` as `app.aclRole.deletedAt` , `app.aclRole` . `created_at` as `app.aclRole.createdAt` , `app.aclRole` . `updated_at` as `app.aclRole.updatedAt` , `app` . `created_at` as `app.createdAt` , `app` . `updated_at` as `app.updatedAt` , `app.translation.label` , COALESCE (`app.translation.label` , `app.translation.label` ) as `app.label` , `app.translation.description` , COALESCE (`app.translation.description` , `app.translation.description` ) as `app.description` , `app.translation.privacyPolicyExtensions` , COALESCE (`app.translation.privacyPolicyExtensions` , `app.translation.privacyPolicyExtensions` ) as `app.privacyPolicyExtensions` , `app.translation.customFields` , COALESCE (`app.translation.customFields` , `app.translation.customFields` ) as `app.customFields` , `app.translation.createdAt` , `app.translation.updatedAt` , `app.translation.appId` , `app.translation.languageId` FROM `app` LEFT JOIN (SELECT `app.translation` . app_id , `app.translation` . label as `app.translation.label` , `app.translation` . description as `app.translation.description` , `app.translation` . privacy_policy_extensions as `app.translation.privacyPolicyExtensions` , `app.translation` . custom_fields as `app.translation.customFields` , `app.translation` . created_at as `app.translation.createdAt` , `app.translation` . updated_at as `app.translation.updatedAt` , `app.translation` . app_id as `app.translation.appId` , `app.translation` . language_id as `app.translation.languageId` FROM `app_translation` `app.translation` WHERE `app.translation` . language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) `app.app_translation` ON `app.app_translation` . `app_id` = `app` . `id` LEFT JOIN `integration` `app.integration` ON `app` . `integration_id` = `app.integration` . `id` LEFT JOIN `acl_role` `app.aclRole` ON `app` . `acl_role_id` = `app.aclRole` . `id` WHERE (`app` . `active` = 1 );
Copy
10.39 ms
1
SELECT `product` . `id` as `product.id` , `product` . `version_id` as `product.versionId` , `product` . `product_number` as `product.productNumber` , `product` . `stock` as `product.stock` FROM `product` WHERE (`product` . `version_id` = ? ) AND ((((`product` . `stock` > = ? ) AND (`product` . `available_stock` < ? ) AND `product` . `version_id` = ? )))
Parameters :
[
b"\x0F ©\x1C ãéjK¾KÙÎu,4%0
0
b"\x0F ©\x1C ãéjK¾KÙÎu,4% ]
SELECT `product` . `id` as `product.id` , `product` . `version_id` as `product.versionId` , `product` . `product_number` as `product.productNumber` , `product` . `stock` as `product.stock` FROM `product` WHERE (`product` . `version_id` = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425 ) AND ((((`product` . `stock` > = 0 ) AND (`product` . `available_stock` < 0 ) AND `product` . `version_id` = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425 ))); Copy
7.52 ms
5
SELECT LOWER (HEX (`script` . `app_id` )) as `app_id` ,
`script` . `name` AS scriptName ,
`script` . `script` AS script ,
`script` . `hook` AS hook ,
IFNULL (`script` . `updated_at` , `script` . `created_at` ) AS lastModified ,
`app` . `name` AS appName ,
LOWER (HEX (`app` . `integration_id` )) AS integrationId ,
`app` . `version` AS appVersion ,
`script` . `active` AS active
FROM `script`
LEFT JOIN `app` ON `script` . `app_id` = `app` . `id`
WHERE `script` . `hook` ! = 'include'
ORDER BY `app` . `created_at` , `app` . `id` , `script` . `name`
SELECT LOWER (HEX (`script` . `app_id` )) as `app_id` ,
`script` . `name` AS scriptName ,
`script` . `script` AS script ,
`script` . `hook` AS hook ,
IFNULL (`script` . `updated_at` , `script` . `created_at` ) AS lastModified ,
`app` . `name` AS appName ,
LOWER (HEX (`app` . `integration_id` )) AS integrationId ,
`app` . `version` AS appVersion ,
`script` . `active` AS active
FROM `script`
LEFT JOIN `app` ON `script` . `app_id` = `app` . `id`
WHERE `script` . `hook` ! = 'include'
ORDER BY `app` . `created_at` , `app` . `id` , `script` . `name`
; Copy
4.17 ms
5
SELECT LOWER (HEX (`script` . `app_id` )) as `app_id` ,
`script` . `name` AS name ,
`script` . `script` AS script ,
`app` . `name` AS appName ,
LOWER (HEX (`app` . `integration_id` )) AS integrationId ,
IFNULL (`script` . `updated_at` , `script` . `created_at` ) AS lastModified
FROM `script`
LEFT JOIN `app` ON `script` . `app_id` = `app` . `id`
WHERE `script` . `hook` = 'include'
ORDER BY `app` . `created_at` , `app` . `id` , `script` . `name`
SELECT LOWER (HEX (`script` . `app_id` )) as `app_id` ,
`script` . `name` AS name ,
`script` . `script` AS script ,
`app` . `name` AS appName ,
LOWER (HEX (`app` . `integration_id` )) AS integrationId ,
IFNULL (`script` . `updated_at` , `script` . `created_at` ) AS lastModified
FROM `script`
LEFT JOIN `app` ON `script` . `app_id` = `app` . `id`
WHERE `script` . `hook` = 'include'
ORDER BY `app` . `created_at` , `app` . `id` , `script` . `name`
; Copy
2.77 ms
1
SELECT `bisg_warehouse_stock` . `id` as `bisg_warehouse_stock.id` , `bisg_warehouse_stock` . `warehouse_id` as `bisg_warehouse_stock.warehouseId` , `bisg_warehouse_stock` . `product_id` as `bisg_warehouse_stock.productId` , `bisg_warehouse_stock` . `product_version_id` as `bisg_warehouse_stock.productVersionId` , `bisg_warehouse_stock` . `product_number` as `bisg_warehouse_stock.productNumber` , `bisg_warehouse_stock` . `stock` as `bisg_warehouse_stock.stock` , `bisg_warehouse_stock` . `available_stock` as `bisg_warehouse_stock.availableStock` , `bisg_warehouse_stock` . `charge` as `bisg_warehouse_stock.charge` , `bisg_warehouse_stock` . `serial_number` as `bisg_warehouse_stock.serialNumber` , `bisg_warehouse_stock` . `created_at` as `bisg_warehouse_stock.createdAt` , `bisg_warehouse_stock` . `updated_at` as `bisg_warehouse_stock.updatedAt` FROM `bisg_warehouse_stock` LEFT JOIN `bisg_warehouse` `bisg_warehouse_stock.warehouse` ON `bisg_warehouse_stock` . `warehouse_id` = `bisg_warehouse_stock.warehouse` . `id` LEFT JOIN `bisg_warehouse_group` `bisg_warehouse_stock.warehouse.group` ON `bisg_warehouse_stock.warehouse` . `group_id` = `bisg_warehouse_stock.warehouse.group` . `id` WHERE (((`bisg_warehouse_stock` . `product_id` IN (? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ) AND `bisg_warehouse_stock.warehouse.group` . `location_id` IN (? ) AND ((`bisg_warehouse_stock` . `charge` < = > ? OR (`bisg_warehouse_stock` . `charge` > ? )) AND ((`bisg_warehouse_stock` . `available_stock` > = ? ))))))
Parameters :
[
b"\x13 Fj5Ï6º\x19 (ÕjÞ]5\r k6‘†€`{Ó7w!_É•Ðyz "
b"0\x1F w‰mØXeo”Xë…;\x0E\x14 "
b"\v óÞ¼Ùc#<O’ã+¿«ê›8‚%ÄaÄ\x16 l‹\v\x7F U\x03 èGC "
b"ú░ìîiZRW\x17 ãJåC░§\x05 "
b"5jÇëñý[Í‘ú¬\x08 ¿‰5Ü "
b"Ž¸4›Þ4Y\x00 :/´°JÃëI "
b"^q„„ð¿ÿmé\r Ýâ¬\x11\x06 û "
b"@Ùz×ieT«àõ#\x18\x10 ܲ\x1D "
b"'ÚøùͶkçüáð┤\x1A ═ÛÔ "
b"óî┐╠╩´ÉÖ╝')│³╠┌& "
b"\f äºÜÌH±Ä\x1C 5ÆF\x19 œ‚+\x07 OÂô\x17 TÉ5│┘\x1E \n W¼We
"""
b"\x1F §\x10 WæÜf'X%‘înY\x08 »Ð?^aÿF§®\f Î\r \t )¾aŠ "
b"ä0\n \x1F\x19 sÅ\x18 ┐┐\x00 踰1Q "
b"╬<°¥\f\x12 ÅWêúj·{\x06 çØ "
b"K\x14 0¼\x03 é,úew3Xò¨‚( "
b"çrl —ô³£ÅßJ\x1E\x02 êÕI "
b"^þ…>a¶§"\x01 äÏ/̆8m "
b")“\x7F ³úé)“ŸÚ½«}†ˆÐ "
b"Ćh«RÌQû\x1F ’®\v £úZh "
b"ë]Ú›÷ÃdXÌŽ/9\x17 ¥² "
b"\x01 Žæm…£rªŽo\x15 }Y\x17 @mnull
"2024-11-24 "
1
]
SELECT `bisg_warehouse_stock` . `id` as `bisg_warehouse_stock.id` , `bisg_warehouse_stock` . `warehouse_id` as `bisg_warehouse_stock.warehouseId` , `bisg_warehouse_stock` . `product_id` as `bisg_warehouse_stock.productId` , `bisg_warehouse_stock` . `product_version_id` as `bisg_warehouse_stock.productVersionId` , `bisg_warehouse_stock` . `product_number` as `bisg_warehouse_stock.productNumber` , `bisg_warehouse_stock` . `stock` as `bisg_warehouse_stock.stock` , `bisg_warehouse_stock` . `available_stock` as `bisg_warehouse_stock.availableStock` , `bisg_warehouse_stock` . `charge` as `bisg_warehouse_stock.charge` , `bisg_warehouse_stock` . `serial_number` as `bisg_warehouse_stock.serialNumber` , `bisg_warehouse_stock` . `created_at` as `bisg_warehouse_stock.createdAt` , `bisg_warehouse_stock` . `updated_at` as `bisg_warehouse_stock.updatedAt` FROM `bisg_warehouse_stock` LEFT JOIN `bisg_warehouse` `bisg_warehouse_stock.warehouse` ON `bisg_warehouse_stock` . `warehouse_id` = `bisg_warehouse_stock.warehouse` . `id` LEFT JOIN `bisg_warehouse_group` `bisg_warehouse_stock.warehouse.group` ON `bisg_warehouse_stock.warehouse` . `group_id` = `bisg_warehouse_stock.warehouse.group` . `id` WHERE (((`bisg_warehouse_stock` . `product_id` IN (0x13466A35CF36BA1928D56ADE5D350D6B , 0x36918680607BD33777215FC995D0797A , 0x301F77896DD858656F9458EB853B0E14 , 0x0BF3DEBCD963233C4F92E32BBFABEA9B , 0x388225C461C4166C8B0B7F5503E84743 , 0xA3B08D8C695A525717C64A8643B0F505 , 0x356AC7EBF1FD5BCD91FAAC08BF8935DC , 0x8EB8349BDE3459003A2FB4B04AC3EB49 , 0x5E718484F0BFFF6DE90DDDE2AC1106FB , 0x40D97AD7696554ABE0F5231810DCB21D , 0x27E99B97D6F46B8781A0D0B41ACDEAE2 , 0xA28CBFCCCAEF9099BC2729B3FCCCDA26 , 0x0CE4BADCCC48B1C41C35C646199C822B , 0x074FB69317549035B3D91E0A57AC5765 , 0x1FA71057E6DC6627582591EE6E5908BB , 0xD03F5E61FF46A7AE0CCE0D0929BE618A , 0x84300A1F19738F18BFBF008AF7F83151 , 0xCE3CF8BE0C128F5788A36AFA7B06879D , 0x4B1430BC03E92CFA65773358F2A88228 , 0xE7726C2097F4B3A3C5DF4A1E02EAD549 , 0x5EFE853E61B6A72201E4CF2FCC86386D , 0x29937FB3FAE929939FDABDAB7D8688D0 , 0xC48668AB52CC51FB1F92AE0BA3FA5A68 , 0xEB5DDAAD9BF7C36458CC8E2F3917A5B2 ) AND `bisg_warehouse_stock.warehouse.group` . `location_id` IN (0x018EE66D85A372AA8E6F157D5917406D ) AND ((`bisg_warehouse_stock` . `charge` < = > NULL OR (`bisg_warehouse_stock` . `charge` > '2024-11-24' )) AND ((`bisg_warehouse_stock` . `available_stock` > = 1 )))))); Copy
2.72 ms
1
SELECT `bisg_product_feature_type` . `id` as `bisg_product_feature_type.id` , `bisg_product_feature_type` . `name` as `bisg_product_feature_type.name` , `bisg_product_feature_type` . `custom_field_config` as `bisg_product_feature_type.customFieldConfig` , `bisg_product_feature_type` . `created_at` as `bisg_product_feature_type.createdAt` , `bisg_product_feature_type` . `updated_at` as `bisg_product_feature_type.updatedAt` , `bisg_product_feature_type.translation.label` , COALESCE (`bisg_product_feature_type.translation.label` , `bisg_product_feature_type.translation.label` ) as `bisg_product_feature_type.label` , `bisg_product_feature_type.translation.description` , COALESCE (`bisg_product_feature_type.translation.description` , `bisg_product_feature_type.translation.description` ) as `bisg_product_feature_type.description` , `bisg_product_feature_type.translation.createdAt` , `bisg_product_feature_type.translation.updatedAt` , `bisg_product_feature_type.translation.bisgProductFeatureTypeId` , `bisg_product_feature_type.translation.languageId` FROM `bisg_product_feature_type` LEFT JOIN (SELECT `bisg_product_feature_type.translation` . bisg_product_feature_type_id , `bisg_product_feature_type.translation` . label as `bisg_product_feature_type.translation.label` , `bisg_product_feature_type.translation` . description as `bisg_product_feature_type.translation.description` , `bisg_product_feature_type.translation` . created_at as `bisg_product_feature_type.translation.createdAt` , `bisg_product_feature_type.translation` . updated_at as `bisg_product_feature_type.translation.updatedAt` , `bisg_product_feature_type.translation` . bisg_product_feature_type_id as `bisg_product_feature_type.translation.bisgProductFeatureTypeId` , `bisg_product_feature_type.translation` . language_id as `bisg_product_feature_type.translation.languageId` FROM `bisg_product_feature_type_translation` `bisg_product_feature_type.translation` WHERE `bisg_product_feature_type.translation` . language_id = ? ) `bisg_product_feature_type.bisg_product_feature_type_translation` ON `bisg_product_feature_type.bisg_product_feature_type_translation` . `bisg_product_feature_type_id` = `bisg_product_feature_type` . `id`
Parameters :
[
b"/»_ââšMpªXTÎ|ãâ\v "
]
SELECT `bisg_product_feature_type` . `id` as `bisg_product_feature_type.id` , `bisg_product_feature_type` . `name` as `bisg_product_feature_type.name` , `bisg_product_feature_type` . `custom_field_config` as `bisg_product_feature_type.customFieldConfig` , `bisg_product_feature_type` . `created_at` as `bisg_product_feature_type.createdAt` , `bisg_product_feature_type` . `updated_at` as `bisg_product_feature_type.updatedAt` , `bisg_product_feature_type.translation.label` , COALESCE (`bisg_product_feature_type.translation.label` , `bisg_product_feature_type.translation.label` ) as `bisg_product_feature_type.label` , `bisg_product_feature_type.translation.description` , COALESCE (`bisg_product_feature_type.translation.description` , `bisg_product_feature_type.translation.description` ) as `bisg_product_feature_type.description` , `bisg_product_feature_type.translation.createdAt` , `bisg_product_feature_type.translation.updatedAt` , `bisg_product_feature_type.translation.bisgProductFeatureTypeId` , `bisg_product_feature_type.translation.languageId` FROM `bisg_product_feature_type` LEFT JOIN (SELECT `bisg_product_feature_type.translation` . bisg_product_feature_type_id , `bisg_product_feature_type.translation` . label as `bisg_product_feature_type.translation.label` , `bisg_product_feature_type.translation` . description as `bisg_product_feature_type.translation.description` , `bisg_product_feature_type.translation` . created_at as `bisg_product_feature_type.translation.createdAt` , `bisg_product_feature_type.translation` . updated_at as `bisg_product_feature_type.translation.updatedAt` , `bisg_product_feature_type.translation` . bisg_product_feature_type_id as `bisg_product_feature_type.translation.bisgProductFeatureTypeId` , `bisg_product_feature_type.translation` . language_id as `bisg_product_feature_type.translation.languageId` FROM `bisg_product_feature_type_translation` `bisg_product_feature_type.translation` WHERE `bisg_product_feature_type.translation` . language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) `bisg_product_feature_type.bisg_product_feature_type_translation` ON `bisg_product_feature_type.bisg_product_feature_type_translation` . `bisg_product_feature_type_id` = `bisg_product_feature_type` . `id` ; Copy
2.39 ms
1
SELECT `sales_channel` . `id` as `sales_channel.id` , `sales_channel` . `type_id` as `sales_channel.typeId` , `sales_channel` . `language_id` as `sales_channel.languageId` , `sales_channel` . `customer_group_id` as `sales_channel.customerGroupId` , `sales_channel` . `currency_id` as `sales_channel.currencyId` , `sales_channel` . `payment_method_id` as `sales_channel.paymentMethodId` , `sales_channel` . `shipping_method_id` as `sales_channel.shippingMethodId` , `sales_channel` . `country_id` as `sales_channel.countryId` , `sales_channel` . `analytics_id` as `sales_channel.analyticsId` , `sales_channel` . `navigation_category_id` as `sales_channel.navigationCategoryId` , `sales_channel` . `navigation_category_version_id` as `sales_channel.navigationCategoryVersionId` , `sales_channel` . `navigation_category_depth` as `sales_channel.navigationCategoryDepth` , `sales_channel` . `footer_category_id` as `sales_channel.footerCategoryId` , `sales_channel` . `footer_category_version_id` as `sales_channel.footerCategoryVersionId` , `sales_channel` . `service_category_id` as `sales_channel.serviceCategoryId` , `sales_channel` . `service_category_version_id` as `sales_channel.serviceCategoryVersionId` , `sales_channel` . `mail_header_footer_id` as `sales_channel.mailHeaderFooterId` , `sales_channel` . `hreflang_default_domain_id` as `sales_channel.hreflangDefaultDomainId` , `sales_channel` . `short_name` as `sales_channel.shortName` , `sales_channel` . `tax_calculation_type` as `sales_channel.taxCalculationType` , `sales_channel` . `access_key` as `sales_channel.accessKey` , `sales_channel` . `configuration` as `sales_channel.configuration` , `sales_channel` . `active` as `sales_channel.active` , `sales_channel` . `hreflang_active` as `sales_channel.hreflangActive` , `sales_channel` . `maintenance` as `sales_channel.maintenance` , `sales_channel` . `maintenance_ip_whitelist` as `sales_channel.maintenanceIpWhitelist` , `sales_channel` . `payment_method_ids` as `sales_channel.paymentMethodIds` , `sales_channel` . `home_cms_page_id` as `sales_channel.homeCmsPageId` , `sales_channel` . `home_cms_page_version_id` as `sales_channel.homeCmsPageVersionId` , `sales_channel.analytics` . `id` as `sales_channel.analytics.id` , `sales_channel.analytics` . `tracking_id` as `sales_channel.analytics.trackingId` , `sales_channel.analytics` . `active` as `sales_channel.analytics.active` , `sales_channel.analytics` . `track_orders` as `sales_channel.analytics.trackOrders` , `sales_channel.analytics` . `anonymize_ip` as `sales_channel.analytics.anonymizeIp` , `sales_channel.analytics` . `created_at` as `sales_channel.analytics.createdAt` , `sales_channel.analytics` . `updated_at` as `sales_channel.analytics.updatedAt` , `sales_channel` . `created_at` as `sales_channel.createdAt` , `sales_channel` . `updated_at` as `sales_channel.updatedAt` , (SELECT GROUP_CONCAT (HEX (`sales_channel.paymentMethods.mapping` . `payment_method_id` ) SEPARATOR '||' )
FROM `sales_channel_payment_method` `sales_channel.paymentMethods.mapping`
WHERE `sales_channel.paymentMethods.mapping` . `sales_channel_id` = `sales_channel` . `id` ) as `sales_channel.paymentMethods.id_mapping` , `sales_channel.country` . `id` as `sales_channel.country.id` , `sales_channel.country` . `iso` as `sales_channel.country.iso` , `sales_channel.country` . `position` as `sales_channel.country.position` , `sales_channel.country` . `active` as `sales_channel.country.active` , `sales_channel.country` . `shipping_available` as `sales_channel.country.shippingAvailable` , `sales_channel.country` . `iso3` as `sales_channel.country.iso3` , `sales_channel.country` . `display_state_in_registration` as `sales_channel.country.displayStateInRegistration` , `sales_channel.country` . `force_state_in_registration` as `sales_channel.country.forceStateInRegistration` , `sales_channel.country` . `check_vat_id_pattern` as `sales_channel.country.checkVatIdPattern` , `sales_channel.country` . `vat_id_required` as `sales_channel.country.vatIdRequired` , `sales_channel.country` . `vat_id_pattern` as `sales_channel.country.vatIdPattern` , `sales_channel.country` . `customer_tax` as `sales_channel.country.customerTax` , `sales_channel.country` . `company_tax` as `sales_channel.country.companyTax` , `sales_channel.country` . `postal_code_required` as `sales_channel.country.postalCodeRequired` , `sales_channel.country` . `check_postal_code_pattern` as `sales_channel.country.checkPostalCodePattern` , `sales_channel.country` . `check_advanced_postal_code_pattern` as `sales_channel.country.checkAdvancedPostalCodePattern` , `sales_channel.country` . `advanced_postal_code_pattern` as `sales_channel.country.advancedPostalCodePattern` , `sales_channel.country` . `default_postal_code_pattern` as `sales_channel.country.defaultPostalCodePattern` , `sales_channel.country` . `created_at` as `sales_channel.country.createdAt` , `sales_channel.country` . `updated_at` as `sales_channel.country.updatedAt` , `sales_channel.country.translation.name` , COALESCE (`sales_channel.country.translation.name` , `sales_channel.country.translation.name` ) as `sales_channel.country.name` , `sales_channel.country.translation.addressFormat` , COALESCE (`sales_channel.country.translation.addressFormat` , `sales_channel.country.translation.addressFormat` ) as `sales_channel.country.addressFormat` , `sales_channel.country.translation.customFields` , COALESCE (`sales_channel.country.translation.customFields` , `sales_channel.country.translation.customFields` ) as `sales_channel.country.customFields` , `sales_channel.country.translation.createdAt` , `sales_channel.country.translation.updatedAt` , `sales_channel.country.translation.countryId` , `sales_channel.country.translation.languageId` , `sales_channel.language` . `id` as `sales_channel.language.id` , `sales_channel.language` . `parent_id` as `sales_channel.language.parentId` , `sales_channel.language` . `locale_id` as `sales_channel.language.localeId` , `sales_channel.language` . `translation_code_id` as `sales_channel.language.translationCodeId` , `sales_channel.language` . `name` as `sales_channel.language.name` , `sales_channel.language` . `custom_fields` as `sales_channel.language.customFields` , `sales_channel.language` . `created_at` as `sales_channel.language.createdAt` , `sales_channel.language` . `updated_at` as `sales_channel.language.updatedAt` , `sales_channel.language.locale` . `id` as `sales_channel.language.locale.id` , `sales_channel.language.locale` . `code` as `sales_channel.language.locale.code` , `sales_channel.language.locale` . `created_at` as `sales_channel.language.locale.createdAt` , `sales_channel.language.locale` . `updated_at` as `sales_channel.language.locale.updatedAt` , `sales_channel.language.locale.translation.name` , COALESCE (`sales_channel.language.locale.translation.name` , `sales_channel.language.locale.translation.name` ) as `sales_channel.language.locale.name` , `sales_channel.language.locale.translation.territory` , COALESCE (`sales_channel.language.locale.translation.territory` , `sales_channel.language.locale.translation.territory` ) as `sales_channel.language.locale.territory` , `sales_channel.language.locale.translation.customFields` , COALESCE (`sales_channel.language.locale.translation.customFields` , `sales_channel.language.locale.translation.customFields` ) as `sales_channel.language.locale.customFields` , `sales_channel.language.locale.translation.createdAt` , `sales_channel.language.locale.translation.updatedAt` , `sales_channel.language.locale.translation.localeId` , `sales_channel.language.locale.translation.languageId` , `sales_channel.translation.name` , COALESCE (`sales_channel.translation.name` , `sales_channel.translation.name` ) as `sales_channel.name` , `sales_channel.translation.homeSlotConfig` , COALESCE (`sales_channel.translation.homeSlotConfig` , `sales_channel.translation.homeSlotConfig` ) as `sales_channel.homeSlotConfig` , `sales_channel.translation.homeEnabled` , COALESCE (`sales_channel.translation.homeEnabled` , `sales_channel.translation.homeEnabled` ) as `sales_channel.homeEnabled` , `sales_channel.translation.homeName` , COALESCE (`sales_channel.translation.homeName` , `sales_channel.translation.homeName` ) as `sales_channel.homeName` , `sales_channel.translation.homeMetaTitle` , COALESCE (`sales_channel.translation.homeMetaTitle` , `sales_channel.translation.homeMetaTitle` ) as `sales_channel.homeMetaTitle` , `sales_channel.translation.homeMetaDescription` , COALESCE (`sales_channel.translation.homeMetaDescription` , `sales_channel.translation.homeMetaDescription` ) as `sales_channel.homeMetaDescription` , `sales_channel.translation.homeKeywords` , COALESCE (`sales_channel.translation.homeKeywords` , `sales_channel.translation.homeKeywords` ) as `sales_channel.homeKeywords` , `sales_channel.translation.customFields` , COALESCE (`sales_channel.translation.customFields` , `sales_channel.translation.customFields` ) as `sales_channel.customFields` , `sales_channel.translation.createdAt` , `sales_channel.translation.updatedAt` , `sales_channel.translation.salesChannelId` , `sales_channel.translation.languageId` FROM `sales_channel` LEFT JOIN (SELECT `sales_channel.translation` . sales_channel_id , `sales_channel.translation` . name as `sales_channel.translation.name` , `sales_channel.translation` . home_slot_config as `sales_channel.translation.homeSlotConfig` , `sales_channel.translation` . home_enabled as `sales_channel.translation.homeEnabled` , `sales_channel.translation` . home_name as `sales_channel.translation.homeName` , `sales_channel.translation` . home_meta_title as `sales_channel.translation.homeMetaTitle` , `sales_channel.translation` . home_meta_description as `sales_channel.translation.homeMetaDescription` , `sales_channel.translation` . home_keywords as `sales_channel.translation.homeKeywords` , `sales_channel.translation` . custom_fields as `sales_channel.translation.customFields` , `sales_channel.translation` . created_at as `sales_channel.translation.createdAt` , `sales_channel.translation` . updated_at as `sales_channel.translation.updatedAt` , `sales_channel.translation` . sales_channel_id as `sales_channel.translation.salesChannelId` , `sales_channel.translation` . language_id as `sales_channel.translation.languageId` FROM `sales_channel_translation` `sales_channel.translation` WHERE `sales_channel.translation` . language_id = ? ) `sales_channel.sales_channel_translation` ON `sales_channel.sales_channel_translation` . `sales_channel_id` = `sales_channel` . `id` LEFT JOIN `sales_channel_analytics` `sales_channel.analytics` ON `sales_channel` . `analytics_id` = `sales_channel.analytics` . `id` LEFT JOIN `country` `sales_channel.country` ON `sales_channel` . `country_id` = `sales_channel.country` . `id` LEFT JOIN `language` `sales_channel.language` ON `sales_channel` . `language_id` = `sales_channel.language` . `id` LEFT JOIN (SELECT `sales_channel.country.translation` . country_id , `sales_channel.country.translation` . name as `sales_channel.country.translation.name` , `sales_channel.country.translation` . address_format as `sales_channel.country.translation.addressFormat` , `sales_channel.country.translation` . custom_fields as `sales_channel.country.translation.customFields` , `sales_channel.country.translation` . created_at as `sales_channel.country.translation.createdAt` , `sales_channel.country.translation` . updated_at as `sales_channel.country.translation.updatedAt` , `sales_channel.country.translation` . country_id as `sales_channel.country.translation.countryId` , `sales_channel.country.translation` . language_id as `sales_channel.country.translation.languageId` FROM `country_translation` `sales_channel.country.translation` WHERE `sales_channel.country.translation` . language_id = ? ) `sales_channel.country.country_translation` ON `sales_channel.country.country_translation` . `country_id` = `sales_channel.country` . `id` LEFT JOIN `locale` `sales_channel.language.locale` ON `sales_channel.language` . `locale_id` = `sales_channel.language.locale` . `id` LEFT JOIN (SELECT `sales_channel.language.locale.translation` . locale_id , `sales_channel.language.locale.translation` . name as `sales_channel.language.locale.translation.name` , `sales_channel.language.locale.translation` . territory as `sales_channel.language.locale.translation.territory` , `sales_channel.language.locale.translation` . custom_fields as `sales_channel.language.locale.translation.customFields` , `sales_channel.language.locale.translation` . created_at as `sales_channel.language.locale.translation.createdAt` , `sales_channel.language.locale.translation` . updated_at as `sales_channel.language.locale.translation.updatedAt` , `sales_channel.language.locale.translation` . locale_id as `sales_channel.language.locale.translation.localeId` , `sales_channel.language.locale.translation` . language_id as `sales_channel.language.locale.translation.languageId` FROM `locale_translation` `sales_channel.language.locale.translation` WHERE `sales_channel.language.locale.translation` . language_id = ? ) `sales_channel.language.locale.locale_translation` ON `sales_channel.language.locale.locale_translation` . `locale_id` = `sales_channel.language.locale` . `id` WHERE `sales_channel` . `id` IN (? )
Parameters :
[
b"/»_ââšMpªXTÎ|ãâ\v "
b"/»_ââšMpªXTÎ|ãâ\v "
b"/»_ââšMpªXTÎ|ãâ\v "
b"\x02 a\f\x08 ÑQN├ü\v b¦©!\x19 à ]
SELECT
`sales_channel` . `id` as `sales_channel.id` ,
`sales_channel` . `type_id` as `sales_channel.typeId` ,
`sales_channel` . `language_id` as `sales_channel.languageId` ,
`sales_channel` . `customer_group_id` as `sales_channel.customerGroupId` ,
`sales_channel` . `currency_id` as `sales_channel.currencyId` ,
`sales_channel` . `payment_method_id` as `sales_channel.paymentMethodId` ,
`sales_channel` . `shipping_method_id` as `sales_channel.shippingMethodId` ,
`sales_channel` . `country_id` as `sales_channel.countryId` ,
`sales_channel` . `analytics_id` as `sales_channel.analyticsId` ,
`sales_channel` . `navigation_category_id` as `sales_channel.navigationCategoryId` ,
`sales_channel` . `navigation_category_version_id` as `sales_channel.navigationCategoryVersionId` ,
`sales_channel` . `navigation_category_depth` as `sales_channel.navigationCategoryDepth` ,
`sales_channel` . `footer_category_id` as `sales_channel.footerCategoryId` ,
`sales_channel` . `footer_category_version_id` as `sales_channel.footerCategoryVersionId` ,
`sales_channel` . `service_category_id` as `sales_channel.serviceCategoryId` ,
`sales_channel` . `service_category_version_id` as `sales_channel.serviceCategoryVersionId` ,
`sales_channel` . `mail_header_footer_id` as `sales_channel.mailHeaderFooterId` ,
`sales_channel` . `hreflang_default_domain_id` as `sales_channel.hreflangDefaultDomainId` ,
`sales_channel` . `short_name` as `sales_channel.shortName` ,
`sales_channel` . `tax_calculation_type` as `sales_channel.taxCalculationType` ,
`sales_channel` . `access_key` as `sales_channel.accessKey` ,
`sales_channel` . `configuration` as `sales_channel.configuration` ,
`sales_channel` . `active` as `sales_channel.active` ,
`sales_channel` . `hreflang_active` as `sales_channel.hreflangActive` ,
`sales_channel` . `maintenance` as `sales_channel.maintenance` ,
`sales_channel` . `maintenance_ip_whitelist` as `sales_channel.maintenanceIpWhitelist` ,
`sales_channel` . `payment_method_ids` as `sales_channel.paymentMethodIds` ,
`sales_channel` . `home_cms_page_id` as `sales_channel.homeCmsPageId` ,
`sales_channel` . `home_cms_page_version_id` as `sales_channel.homeCmsPageVersionId` ,
`sales_channel.analytics` . `id` as `sales_channel.analytics.id` ,
`sales_channel.analytics` . `tracking_id` as `sales_channel.analytics.trackingId` ,
`sales_channel.analytics` . `active` as `sales_channel.analytics.active` ,
`sales_channel.analytics` . `track_orders` as `sales_channel.analytics.trackOrders` ,
`sales_channel.analytics` . `anonymize_ip` as `sales_channel.analytics.anonymizeIp` ,
`sales_channel.analytics` . `created_at` as `sales_channel.analytics.createdAt` ,
`sales_channel.analytics` . `updated_at` as `sales_channel.analytics.updatedAt` ,
`sales_channel` . `created_at` as `sales_channel.createdAt` ,
`sales_channel` . `updated_at` as `sales_channel.updatedAt` ,
(
SELECT
GROUP_CONCAT (
HEX (
`sales_channel.paymentMethods.mapping` . `payment_method_id`
) SEPARATOR '||'
)
FROM
`sales_channel_payment_method` `sales_channel.paymentMethods.mapping`
WHERE
`sales_channel.paymentMethods.mapping` . `sales_channel_id` = `sales_channel` . `id`
) as `sales_channel.paymentMethods.id_mapping` ,
`sales_channel.country` . `id` as `sales_channel.country.id` ,
`sales_channel.country` . `iso` as `sales_channel.country.iso` ,
`sales_channel.country` . `position` as `sales_channel.country.position` ,
`sales_channel.country` . `active` as `sales_channel.country.active` ,
`sales_channel.country` . `shipping_available` as `sales_channel.country.shippingAvailable` ,
`sales_channel.country` . `iso3` as `sales_channel.country.iso3` ,
`sales_channel.country` . `display_state_in_registration` as `sales_channel.country.displayStateInRegistration` ,
`sales_channel.country` . `force_state_in_registration` as `sales_channel.country.forceStateInRegistration` ,
`sales_channel.country` . `check_vat_id_pattern` as `sales_channel.country.checkVatIdPattern` ,
`sales_channel.country` . `vat_id_required` as `sales_channel.country.vatIdRequired` ,
`sales_channel.country` . `vat_id_pattern` as `sales_channel.country.vatIdPattern` ,
`sales_channel.country` . `customer_tax` as `sales_channel.country.customerTax` ,
`sales_channel.country` . `company_tax` as `sales_channel.country.companyTax` ,
`sales_channel.country` . `postal_code_required` as `sales_channel.country.postalCodeRequired` ,
`sales_channel.country` . `check_postal_code_pattern` as `sales_channel.country.checkPostalCodePattern` ,
`sales_channel.country` . `check_advanced_postal_code_pattern` as `sales_channel.country.checkAdvancedPostalCodePattern` ,
`sales_channel.country` . `advanced_postal_code_pattern` as `sales_channel.country.advancedPostalCodePattern` ,
`sales_channel.country` . `default_postal_code_pattern` as `sales_channel.country.defaultPostalCodePattern` ,
`sales_channel.country` . `created_at` as `sales_channel.country.createdAt` ,
`sales_channel.country` . `updated_at` as `sales_channel.country.updatedAt` ,
`sales_channel.country.translation.name` ,
COALESCE (
`sales_channel.country.translation.name` ,
`sales_channel.country.translation.name`
) as `sales_channel.country.name` ,
`sales_channel.country.translation.addressFormat` ,
COALESCE (
`sales_channel.country.translation.addressFormat` ,
`sales_channel.country.translation.addressFormat`
) as `sales_channel.country.addressFormat` ,
`sales_channel.country.translation.customFields` ,
COALESCE (
`sales_channel.country.translation.customFields` ,
`sales_channel.country.translation.customFields`
) as `sales_channel.country.customFields` ,
`sales_channel.country.translation.createdAt` ,
`sales_channel.country.translation.updatedAt` ,
`sales_channel.country.translation.countryId` ,
`sales_channel.country.translation.languageId` ,
`sales_channel.language` . `id` as `sales_channel.language.id` ,
`sales_channel.language` . `parent_id` as `sales_channel.language.parentId` ,
`sales_channel.language` . `locale_id` as `sales_channel.language.localeId` ,
`sales_channel.language` . `translation_code_id` as `sales_channel.language.translationCodeId` ,
`sales_channel.language` . `name` as `sales_channel.language.name` ,
`sales_channel.language` . `custom_fields` as `sales_channel.language.customFields` ,
`sales_channel.language` . `created_at` as `sales_channel.language.createdAt` ,
`sales_channel.language` . `updated_at` as `sales_channel.language.updatedAt` ,
`sales_channel.language.locale` . `id` as `sales_channel.language.locale.id` ,
`sales_channel.language.locale` . `code` as `sales_channel.language.locale.code` ,
`sales_channel.language.locale` . `created_at` as `sales_channel.language.locale.createdAt` ,
`sales_channel.language.locale` . `updated_at` as `sales_channel.language.locale.updatedAt` ,
`sales_channel.language.locale.translation.name` ,
COALESCE (
`sales_channel.language.locale.translation.name` ,
`sales_channel.language.locale.translation.name`
) as `sales_channel.language.locale.name` ,
`sales_channel.language.locale.translation.territory` ,
COALESCE (
`sales_channel.language.locale.translation.territory` ,
`sales_channel.language.locale.translation.territory`
) as `sales_channel.language.locale.territory` ,
`sales_channel.language.locale.translation.customFields` ,
COALESCE (
`sales_channel.language.locale.translation.customFields` ,
`sales_channel.language.locale.translation.customFields`
) as `sales_channel.language.locale.customFields` ,
`sales_channel.language.locale.translation.createdAt` ,
`sales_channel.language.locale.translation.updatedAt` ,
`sales_channel.language.locale.translation.localeId` ,
`sales_channel.language.locale.translation.languageId` ,
`sales_channel.translation.name` ,
COALESCE (
`sales_channel.translation.name` ,
`sales_channel.translation.name`
) as `sales_channel.name` ,
`sales_channel.translation.homeSlotConfig` ,
COALESCE (
`sales_channel.translation.homeSlotConfig` ,
`sales_channel.translation.homeSlotConfig`
) as `sales_channel.homeSlotConfig` ,
`sales_channel.translation.homeEnabled` ,
COALESCE (
`sales_channel.translation.homeEnabled` ,
`sales_channel.translation.homeEnabled`
) as `sales_channel.homeEnabled` ,
`sales_channel.translation.homeName` ,
COALESCE (
`sales_channel.translation.homeName` ,
`sales_channel.translation.homeName`
) as `sales_channel.homeName` ,
`sales_channel.translation.homeMetaTitle` ,
COALESCE (
`sales_channel.translation.homeMetaTitle` ,
`sales_channel.translation.homeMetaTitle`
) as `sales_channel.homeMetaTitle` ,
`sales_channel.translation.homeMetaDescription` ,
COALESCE (
`sales_channel.translation.homeMetaDescription` ,
`sales_channel.translation.homeMetaDescription`
) as `sales_channel.homeMetaDescription` ,
`sales_channel.translation.homeKeywords` ,
COALESCE (
`sales_channel.translation.homeKeywords` ,
`sales_channel.translation.homeKeywords`
) as `sales_channel.homeKeywords` ,
`sales_channel.translation.customFields` ,
COALESCE (
`sales_channel.translation.customFields` ,
`sales_channel.translation.customFields`
) as `sales_channel.customFields` ,
`sales_channel.translation.createdAt` ,
`sales_channel.translation.updatedAt` ,
`sales_channel.translation.salesChannelId` ,
`sales_channel.translation.languageId`
FROM
`sales_channel`
LEFT JOIN (
SELECT
`sales_channel.translation` . sales_channel_id ,
`sales_channel.translation` . name as `sales_channel.translation.name` ,
`sales_channel.translation` . home_slot_config as `sales_channel.translation.homeSlotConfig` ,
`sales_channel.translation` . home_enabled as `sales_channel.translation.homeEnabled` ,
`sales_channel.translation` . home_name as `sales_channel.translation.homeName` ,
`sales_channel.translation` . home_meta_title as `sales_channel.translation.homeMetaTitle` ,
`sales_channel.translation` . home_meta_description as `sales_channel.translation.homeMetaDescription` ,
`sales_channel.translation` . home_keywords as `sales_channel.translation.homeKeywords` ,
`sales_channel.translation` . custom_fields as `sales_channel.translation.customFields` ,
`sales_channel.translation` . created_at as `sales_channel.translation.createdAt` ,
`sales_channel.translation` . updated_at as `sales_channel.translation.updatedAt` ,
`sales_channel.translation` . sales_channel_id as `sales_channel.translation.salesChannelId` ,
`sales_channel.translation` . language_id as `sales_channel.translation.languageId`
FROM
`sales_channel_translation` `sales_channel.translation`
WHERE
`sales_channel.translation` . language_id = ?
) `sales_channel.sales_channel_translation` ON `sales_channel.sales_channel_translation` . `sales_channel_id` = `sales_channel` . `id`
LEFT JOIN `sales_channel_analytics` `sales_channel.analytics` ON `sales_channel` . `analytics_id` = `sales_channel.analytics` . `id`
LEFT JOIN `country` `sales_channel.country` ON `sales_channel` . `country_id` = `sales_channel.country` . `id`
LEFT JOIN `language` `sales_channel.language` ON `sales_channel` . `language_id` = `sales_channel.language` . `id`
LEFT JOIN (
SELECT
`sales_channel.country.translation` . country_id ,
`sales_channel.country.translation` . name as `sales_channel.country.translation.name` ,
`sales_channel.country.translation` . address_format as `sales_channel.country.translation.addressFormat` ,
`sales_channel.country.translation` . custom_fields as `sales_channel.country.translation.customFields` ,
`sales_channel.country.translation` . created_at as `sales_channel.country.translation.createdAt` ,
`sales_channel.country.translation` . updated_at as `sales_channel.country.translation.updatedAt` ,
`sales_channel.country.translation` . country_id as `sales_channel.country.translation.countryId` ,
`sales_channel.country.translation` . language_id as `sales_channel.country.translation.languageId`
FROM
`country_translation` `sales_channel.country.translation`
WHERE
`sales_channel.country.translation` . language_id = ?
) `sales_channel.country.country_translation` ON `sales_channel.country.country_translation` . `country_id` = `sales_channel.country` . `id`
LEFT JOIN `locale` `sales_channel.language.locale` ON `sales_channel.language` . `locale_id` = `sales_channel.language.locale` . `id`
LEFT JOIN (
SELECT
`sales_channel.language.locale.translation` . locale_id ,
`sales_channel.language.locale.translation` . name as `sales_channel.language.locale.translation.name` ,
`sales_channel.language.locale.translation` . territory as `sales_channel.language.locale.translation.territory` ,
`sales_channel.language.locale.translation` . custom_fields as `sales_channel.language.locale.translation.customFields` ,
`sales_channel.language.locale.translation` . created_at as `sales_channel.language.locale.translation.createdAt` ,
`sales_channel.language.locale.translation` . updated_at as `sales_channel.language.locale.translation.updatedAt` ,
`sales_channel.language.locale.translation` . locale_id as `sales_channel.language.locale.translation.localeId` ,
`sales_channel.language.locale.translation` . language_id as `sales_channel.language.locale.translation.languageId`
FROM
`locale_translation` `sales_channel.language.locale.translation`
WHERE
`sales_channel.language.locale.translation` . language_id = ?
) `sales_channel.language.locale.locale_translation` ON `sales_channel.language.locale.locale_translation` . `locale_id` = `sales_channel.language.locale` . `id`
WHERE
`sales_channel` . `id` IN (? )Copy
SELECT `sales_channel` . `id` as `sales_channel.id` , `sales_channel` . `type_id` as `sales_channel.typeId` , `sales_channel` . `language_id` as `sales_channel.languageId` , `sales_channel` . `customer_group_id` as `sales_channel.customerGroupId` , `sales_channel` . `currency_id` as `sales_channel.currencyId` , `sales_channel` . `payment_method_id` as `sales_channel.paymentMethodId` , `sales_channel` . `shipping_method_id` as `sales_channel.shippingMethodId` , `sales_channel` . `country_id` as `sales_channel.countryId` , `sales_channel` . `analytics_id` as `sales_channel.analyticsId` , `sales_channel` . `navigation_category_id` as `sales_channel.navigationCategoryId` , `sales_channel` . `navigation_category_version_id` as `sales_channel.navigationCategoryVersionId` , `sales_channel` . `navigation_category_depth` as `sales_channel.navigationCategoryDepth` , `sales_channel` . `footer_category_id` as `sales_channel.footerCategoryId` , `sales_channel` . `footer_category_version_id` as `sales_channel.footerCategoryVersionId` , `sales_channel` . `service_category_id` as `sales_channel.serviceCategoryId` , `sales_channel` . `service_category_version_id` as `sales_channel.serviceCategoryVersionId` , `sales_channel` . `mail_header_footer_id` as `sales_channel.mailHeaderFooterId` , `sales_channel` . `hreflang_default_domain_id` as `sales_channel.hreflangDefaultDomainId` , `sales_channel` . `short_name` as `sales_channel.shortName` , `sales_channel` . `tax_calculation_type` as `sales_channel.taxCalculationType` , `sales_channel` . `access_key` as `sales_channel.accessKey` , `sales_channel` . `configuration` as `sales_channel.configuration` , `sales_channel` . `active` as `sales_channel.active` , `sales_channel` . `hreflang_active` as `sales_channel.hreflangActive` , `sales_channel` . `maintenance` as `sales_channel.maintenance` , `sales_channel` . `maintenance_ip_whitelist` as `sales_channel.maintenanceIpWhitelist` , `sales_channel` . `payment_method_ids` as `sales_channel.paymentMethodIds` , `sales_channel` . `home_cms_page_id` as `sales_channel.homeCmsPageId` , `sales_channel` . `home_cms_page_version_id` as `sales_channel.homeCmsPageVersionId` , `sales_channel.analytics` . `id` as `sales_channel.analytics.id` , `sales_channel.analytics` . `tracking_id` as `sales_channel.analytics.trackingId` , `sales_channel.analytics` . `active` as `sales_channel.analytics.active` , `sales_channel.analytics` . `track_orders` as `sales_channel.analytics.trackOrders` , `sales_channel.analytics` . `anonymize_ip` as `sales_channel.analytics.anonymizeIp` , `sales_channel.analytics` . `created_at` as `sales_channel.analytics.createdAt` , `sales_channel.analytics` . `updated_at` as `sales_channel.analytics.updatedAt` , `sales_channel` . `created_at` as `sales_channel.createdAt` , `sales_channel` . `updated_at` as `sales_channel.updatedAt` , (SELECT GROUP_CONCAT (HEX (`sales_channel.paymentMethods.mapping` . `payment_method_id` ) SEPARATOR '||' )
FROM `sales_channel_payment_method` `sales_channel.paymentMethods.mapping`
WHERE `sales_channel.paymentMethods.mapping` . `sales_channel_id` = `sales_channel` . `id` ) as `sales_channel.paymentMethods.id_mapping` , `sales_channel.country` . `id` as `sales_channel.country.id` , `sales_channel.country` . `iso` as `sales_channel.country.iso` , `sales_channel.country` . `position` as `sales_channel.country.position` , `sales_channel.country` . `active` as `sales_channel.country.active` , `sales_channel.country` . `shipping_available` as `sales_channel.country.shippingAvailable` , `sales_channel.country` . `iso3` as `sales_channel.country.iso3` , `sales_channel.country` . `display_state_in_registration` as `sales_channel.country.displayStateInRegistration` , `sales_channel.country` . `force_state_in_registration` as `sales_channel.country.forceStateInRegistration` , `sales_channel.country` . `check_vat_id_pattern` as `sales_channel.country.checkVatIdPattern` , `sales_channel.country` . `vat_id_required` as `sales_channel.country.vatIdRequired` , `sales_channel.country` . `vat_id_pattern` as `sales_channel.country.vatIdPattern` , `sales_channel.country` . `customer_tax` as `sales_channel.country.customerTax` , `sales_channel.country` . `company_tax` as `sales_channel.country.companyTax` , `sales_channel.country` . `postal_code_required` as `sales_channel.country.postalCodeRequired` , `sales_channel.country` . `check_postal_code_pattern` as `sales_channel.country.checkPostalCodePattern` , `sales_channel.country` . `check_advanced_postal_code_pattern` as `sales_channel.country.checkAdvancedPostalCodePattern` , `sales_channel.country` . `advanced_postal_code_pattern` as `sales_channel.country.advancedPostalCodePattern` , `sales_channel.country` . `default_postal_code_pattern` as `sales_channel.country.defaultPostalCodePattern` , `sales_channel.country` . `created_at` as `sales_channel.country.createdAt` , `sales_channel.country` . `updated_at` as `sales_channel.country.updatedAt` , `sales_channel.country.translation.name` , COALESCE (`sales_channel.country.translation.name` , `sales_channel.country.translation.name` ) as `sales_channel.country.name` , `sales_channel.country.translation.addressFormat` , COALESCE (`sales_channel.country.translation.addressFormat` , `sales_channel.country.translation.addressFormat` ) as `sales_channel.country.addressFormat` , `sales_channel.country.translation.customFields` , COALESCE (`sales_channel.country.translation.customFields` , `sales_channel.country.translation.customFields` ) as `sales_channel.country.customFields` , `sales_channel.country.translation.createdAt` , `sales_channel.country.translation.updatedAt` , `sales_channel.country.translation.countryId` , `sales_channel.country.translation.languageId` , `sales_channel.language` . `id` as `sales_channel.language.id` , `sales_channel.language` . `parent_id` as `sales_channel.language.parentId` , `sales_channel.language` . `locale_id` as `sales_channel.language.localeId` , `sales_channel.language` . `translation_code_id` as `sales_channel.language.translationCodeId` , `sales_channel.language` . `name` as `sales_channel.language.name` , `sales_channel.language` . `custom_fields` as `sales_channel.language.customFields` , `sales_channel.language` . `created_at` as `sales_channel.language.createdAt` , `sales_channel.language` . `updated_at` as `sales_channel.language.updatedAt` , `sales_channel.language.locale` . `id` as `sales_channel.language.locale.id` , `sales_channel.language.locale` . `code` as `sales_channel.language.locale.code` , `sales_channel.language.locale` . `created_at` as `sales_channel.language.locale.createdAt` , `sales_channel.language.locale` . `updated_at` as `sales_channel.language.locale.updatedAt` , `sales_channel.language.locale.translation.name` , COALESCE (`sales_channel.language.locale.translation.name` , `sales_channel.language.locale.translation.name` ) as `sales_channel.language.locale.name` , `sales_channel.language.locale.translation.territory` , COALESCE (`sales_channel.language.locale.translation.territory` , `sales_channel.language.locale.translation.territory` ) as `sales_channel.language.locale.territory` , `sales_channel.language.locale.translation.customFields` , COALESCE (`sales_channel.language.locale.translation.customFields` , `sales_channel.language.locale.translation.customFields` ) as `sales_channel.language.locale.customFields` , `sales_channel.language.locale.translation.createdAt` , `sales_channel.language.locale.translation.updatedAt` , `sales_channel.language.locale.translation.localeId` , `sales_channel.language.locale.translation.languageId` , `sales_channel.translation.name` , COALESCE (`sales_channel.translation.name` , `sales_channel.translation.name` ) as `sales_channel.name` , `sales_channel.translation.homeSlotConfig` , COALESCE (`sales_channel.translation.homeSlotConfig` , `sales_channel.translation.homeSlotConfig` ) as `sales_channel.homeSlotConfig` , `sales_channel.translation.homeEnabled` , COALESCE (`sales_channel.translation.homeEnabled` , `sales_channel.translation.homeEnabled` ) as `sales_channel.homeEnabled` , `sales_channel.translation.homeName` , COALESCE (`sales_channel.translation.homeName` , `sales_channel.translation.homeName` ) as `sales_channel.homeName` , `sales_channel.translation.homeMetaTitle` , COALESCE (`sales_channel.translation.homeMetaTitle` , `sales_channel.translation.homeMetaTitle` ) as `sales_channel.homeMetaTitle` , `sales_channel.translation.homeMetaDescription` , COALESCE (`sales_channel.translation.homeMetaDescription` , `sales_channel.translation.homeMetaDescription` ) as `sales_channel.homeMetaDescription` , `sales_channel.translation.homeKeywords` , COALESCE (`sales_channel.translation.homeKeywords` , `sales_channel.translation.homeKeywords` ) as `sales_channel.homeKeywords` , `sales_channel.translation.customFields` , COALESCE (`sales_channel.translation.customFields` , `sales_channel.translation.customFields` ) as `sales_channel.customFields` , `sales_channel.translation.createdAt` , `sales_channel.translation.updatedAt` , `sales_channel.translation.salesChannelId` , `sales_channel.translation.languageId` FROM `sales_channel` LEFT JOIN (SELECT `sales_channel.translation` . sales_channel_id , `sales_channel.translation` . name as `sales_channel.translation.name` , `sales_channel.translation` . home_slot_config as `sales_channel.translation.homeSlotConfig` , `sales_channel.translation` . home_enabled as `sales_channel.translation.homeEnabled` , `sales_channel.translation` . home_name as `sales_channel.translation.homeName` , `sales_channel.translation` . home_meta_title as `sales_channel.translation.homeMetaTitle` , `sales_channel.translation` . home_meta_description as `sales_channel.translation.homeMetaDescription` , `sales_channel.translation` . home_keywords as `sales_channel.translation.homeKeywords` , `sales_channel.translation` . custom_fields as `sales_channel.translation.customFields` , `sales_channel.translation` . created_at as `sales_channel.translation.createdAt` , `sales_channel.translation` . updated_at as `sales_channel.translation.updatedAt` , `sales_channel.translation` . sales_channel_id as `sales_channel.translation.salesChannelId` , `sales_channel.translation` . language_id as `sales_channel.translation.languageId` FROM `sales_channel_translation` `sales_channel.translation` WHERE `sales_channel.translation` . language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) `sales_channel.sales_channel_translation` ON `sales_channel.sales_channel_translation` . `sales_channel_id` = `sales_channel` . `id` LEFT JOIN `sales_channel_analytics` `sales_channel.analytics` ON `sales_channel` . `analytics_id` = `sales_channel.analytics` . `id` LEFT JOIN `country` `sales_channel.country` ON `sales_channel` . `country_id` = `sales_channel.country` . `id` LEFT JOIN `language` `sales_channel.language` ON `sales_channel` . `language_id` = `sales_channel.language` . `id` LEFT JOIN (SELECT `sales_channel.country.translation` . country_id , `sales_channel.country.translation` . name as `sales_channel.country.translation.name` , `sales_channel.country.translation` . address_format as `sales_channel.country.translation.addressFormat` , `sales_channel.country.translation` . custom_fields as `sales_channel.country.translation.customFields` , `sales_channel.country.translation` . created_at as `sales_channel.country.translation.createdAt` , `sales_channel.country.translation` . updated_at as `sales_channel.country.translation.updatedAt` , `sales_channel.country.translation` . country_id as `sales_channel.country.translation.countryId` , `sales_channel.country.translation` . language_id as `sales_channel.country.translation.languageId` FROM `country_translation` `sales_channel.country.translation` WHERE `sales_channel.country.translation` . language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) `sales_channel.country.country_translation` ON `sales_channel.country.country_translation` . `country_id` = `sales_channel.country` . `id` LEFT JOIN `locale` `sales_channel.language.locale` ON `sales_channel.language` . `locale_id` = `sales_channel.language.locale` . `id` LEFT JOIN (SELECT `sales_channel.language.locale.translation` . locale_id , `sales_channel.language.locale.translation` . name as `sales_channel.language.locale.translation.name` , `sales_channel.language.locale.translation` . territory as `sales_channel.language.locale.translation.territory` , `sales_channel.language.locale.translation` . custom_fields as `sales_channel.language.locale.translation.customFields` , `sales_channel.language.locale.translation` . created_at as `sales_channel.language.locale.translation.createdAt` , `sales_channel.language.locale.translation` . updated_at as `sales_channel.language.locale.translation.updatedAt` , `sales_channel.language.locale.translation` . locale_id as `sales_channel.language.locale.translation.localeId` , `sales_channel.language.locale.translation` . language_id as `sales_channel.language.locale.translation.languageId` FROM `locale_translation` `sales_channel.language.locale.translation` WHERE `sales_channel.language.locale.translation` . language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) `sales_channel.language.locale.locale_translation` ON `sales_channel.language.locale.locale_translation` . `locale_id` = `sales_channel.language.locale` . `id` WHERE `sales_channel` . `id` IN (0x02610C08A5514EC3810B62DDB82119C7 ); Copy
2.34 ms
2
SELECT `category` . `id` as `category.id` , `category` . `version_id` as `category.versionId` , `category` . `parent_id` as `category.parentId` , `category` . `parent_version_id` as `category.parentVersionId` , `category` . `after_category_id` as `category.afterCategoryId` , `category` . `after_category_version_id` as `category.afterCategoryVersionId` , `category` . `media_id` as `category.mediaId` , `category` . `display_nested_products` as `category.displayNestedProducts` , `category` . `auto_increment` as `category.autoIncrement` , `category` . `level` as `category.level` , `category` . `path` as `category.path` , `category` . `child_count` as `category.childCount` , `category` . `type` as `category.type` , `category` . `product_assignment_type` as `category.productAssignmentType` , `category` . `visible` as `category.visible` , `category` . `active` as `category.active` , `category` . `cms_page_id` as `category.cmsPageId` , `category` . `cms_page_version_id` as `category.cmsPageVersionId` , `category` . `product_stream_id` as `category.productStreamId` , `category` . `custom_entity_type_id` as `category.customEntityTypeId` , `category` . `created_at` as `category.createdAt` , `category` . `updated_at` as `category.updatedAt` , `category.translation.name` , COALESCE (`category.translation.name` , `category.translation.name` ) as `category.name` , `category.translation.breadcrumb` , COALESCE (`category.translation.breadcrumb` , `category.translation.breadcrumb` ) as `category.breadcrumb` , `category.translation.slotConfig` , COALESCE (`category.translation.slotConfig` , `category.translation.slotConfig` ) as `category.slotConfig` , `category.translation.linkType` , COALESCE (`category.translation.linkType` , `category.translation.linkType` ) as `category.linkType` , `category.translation.internalLink` , COALESCE (`category.translation.internalLink` , `category.translation.internalLink` ) as `category.internalLink` , `category.translation.externalLink` , COALESCE (`category.translation.externalLink` , `category.translation.externalLink` ) as `category.externalLink` , `category.translation.linkNewTab` , COALESCE (`category.translation.linkNewTab` , `category.translation.linkNewTab` ) as `category.linkNewTab` , `category.translation.description` , COALESCE (`category.translation.description` , `category.translation.description` ) as `category.description` , `category.translation.metaTitle` , COALESCE (`category.translation.metaTitle` , `category.translation.metaTitle` ) as `category.metaTitle` , `category.translation.metaDescription` , COALESCE (`category.translation.metaDescription` , `category.translation.metaDescription` ) as `category.metaDescription` , `category.translation.keywords` , COALESCE (`category.translation.keywords` , `category.translation.keywords` ) as `category.keywords` , `category.translation.customFields` , COALESCE (`category.translation.customFields` , `category.translation.customFields` ) as `category.customFields` , `category.translation.createdAt` , `category.translation.updatedAt` , `category.translation.categoryId` , `category.translation.languageId` , `category.translation.categoryVersionId` FROM `category` LEFT JOIN (SELECT `category.translation` . category_id , `category.translation` . category_version_id , `category.translation` . name as `category.translation.name` , `category.translation` . breadcrumb as `category.translation.breadcrumb` , `category.translation` . slot_config as `category.translation.slotConfig` , `category.translation` . link_type as `category.translation.linkType` , `category.translation` . internal_link as `category.translation.internalLink` , `category.translation` . external_link as `category.translation.externalLink` , `category.translation` . link_new_tab as `category.translation.linkNewTab` , `category.translation` . description as `category.translation.description` , `category.translation` . meta_title as `category.translation.metaTitle` , `category.translation` . meta_description as `category.translation.metaDescription` , `category.translation` . keywords as `category.translation.keywords` , `category.translation` . custom_fields as `category.translation.customFields` , `category.translation` . created_at as `category.translation.createdAt` , `category.translation` . updated_at as `category.translation.updatedAt` , `category.translation` . category_id as `category.translation.categoryId` , `category.translation` . language_id as `category.translation.languageId` , `category.translation` . category_version_id as `category.translation.categoryVersionId` FROM `category_translation` `category.translation` WHERE `category.translation` . language_id = ? ) `category.category_translation` ON `category.category_translation` . `category_id` = `category` . `id` AND `category.category_translation` . category_version_id = `category` . version_id WHERE (`category` . `version_id` = ? ) AND (`category` . `id` IN (? , ? , ? ))
Parameters :
[
b"/»_ââšMpªXTÎ|ãâ\v "
b"\x0F ©\x1C ãéjK¾KÙÎu,4%ú\x16 «\n
SŠ…\x01 ©^…x\x04\e /Y
"""
b"5±³s•Ù\x1D ä;\v F4·†c "
b"O-E.ÊÿÁ¡ÏöAw‡\x16 &u "
]
SELECT
`category` . `id` as `category.id` ,
`category` . `version_id` as `category.versionId` ,
`category` . `parent_id` as `category.parentId` ,
`category` . `parent_version_id` as `category.parentVersionId` ,
`category` . `after_category_id` as `category.afterCategoryId` ,
`category` . `after_category_version_id` as `category.afterCategoryVersionId` ,
`category` . `media_id` as `category.mediaId` ,
`category` . `display_nested_products` as `category.displayNestedProducts` ,
`category` . `auto_increment` as `category.autoIncrement` ,
`category` . `level` as `category.level` ,
`category` . `path` as `category.path` ,
`category` . `child_count` as `category.childCount` ,
`category` . `type` as `category.type` ,
`category` . `product_assignment_type` as `category.productAssignmentType` ,
`category` . `visible` as `category.visible` ,
`category` . `active` as `category.active` ,
`category` . `cms_page_id` as `category.cmsPageId` ,
`category` . `cms_page_version_id` as `category.cmsPageVersionId` ,
`category` . `product_stream_id` as `category.productStreamId` ,
`category` . `custom_entity_type_id` as `category.customEntityTypeId` ,
`category` . `created_at` as `category.createdAt` ,
`category` . `updated_at` as `category.updatedAt` ,
`category.translation.name` ,
COALESCE (
`category.translation.name` , `category.translation.name`
) as `category.name` ,
`category.translation.breadcrumb` ,
COALESCE (
`category.translation.breadcrumb` ,
`category.translation.breadcrumb`
) as `category.breadcrumb` ,
`category.translation.slotConfig` ,
COALESCE (
`category.translation.slotConfig` ,
`category.translation.slotConfig`
) as `category.slotConfig` ,
`category.translation.linkType` ,
COALESCE (
`category.translation.linkType` ,
`category.translation.linkType`
) as `category.linkType` ,
`category.translation.internalLink` ,
COALESCE (
`category.translation.internalLink` ,
`category.translation.internalLink`
) as `category.internalLink` ,
`category.translation.externalLink` ,
COALESCE (
`category.translation.externalLink` ,
`category.translation.externalLink`
) as `category.externalLink` ,
`category.translation.linkNewTab` ,
COALESCE (
`category.translation.linkNewTab` ,
`category.translation.linkNewTab`
) as `category.linkNewTab` ,
`category.translation.description` ,
COALESCE (
`category.translation.description` ,
`category.translation.description`
) as `category.description` ,
`category.translation.metaTitle` ,
COALESCE (
`category.translation.metaTitle` ,
`category.translation.metaTitle`
) as `category.metaTitle` ,
`category.translation.metaDescription` ,
COALESCE (
`category.translation.metaDescription` ,
`category.translation.metaDescription`
) as `category.metaDescription` ,
`category.translation.keywords` ,
COALESCE (
`category.translation.keywords` ,
`category.translation.keywords`
) as `category.keywords` ,
`category.translation.customFields` ,
COALESCE (
`category.translation.customFields` ,
`category.translation.customFields`
) as `category.customFields` ,
`category.translation.createdAt` ,
`category.translation.updatedAt` ,
`category.translation.categoryId` ,
`category.translation.languageId` ,
`category.translation.categoryVersionId`
FROM
`category`
LEFT JOIN (
SELECT
`category.translation` . category_id ,
`category.translation` . category_version_id ,
`category.translation` . name as `category.translation.name` ,
`category.translation` . breadcrumb as `category.translation.breadcrumb` ,
`category.translation` . slot_config as `category.translation.slotConfig` ,
`category.translation` . link_type as `category.translation.linkType` ,
`category.translation` . internal_link as `category.translation.internalLink` ,
`category.translation` . external_link as `category.translation.externalLink` ,
`category.translation` . link_new_tab as `category.translation.linkNewTab` ,
`category.translation` . description as `category.translation.description` ,
`category.translation` . meta_title as `category.translation.metaTitle` ,
`category.translation` . meta_description as `category.translation.metaDescription` ,
`category.translation` . keywords as `category.translation.keywords` ,
`category.translation` . custom_fields as `category.translation.customFields` ,
`category.translation` . created_at as `category.translation.createdAt` ,
`category.translation` . updated_at as `category.translation.updatedAt` ,
`category.translation` . category_id as `category.translation.categoryId` ,
`category.translation` . language_id as `category.translation.languageId` ,
`category.translation` . category_version_id as `category.translation.categoryVersionId`
FROM
`category_translation` `category.translation`
WHERE
`category.translation` . language_id = ?
) `category.category_translation` ON `category.category_translation` . `category_id` = `category` . `id`
AND `category.category_translation` . category_version_id = `category` . version_id
WHERE
(`category` . `version_id` = ? )
AND (
`category` . `id` IN (? , ? , ? )
)
Copy
SELECT `category` . `id` as `category.id` , `category` . `version_id` as `category.versionId` , `category` . `parent_id` as `category.parentId` , `category` . `parent_version_id` as `category.parentVersionId` , `category` . `after_category_id` as `category.afterCategoryId` , `category` . `after_category_version_id` as `category.afterCategoryVersionId` , `category` . `media_id` as `category.mediaId` , `category` . `display_nested_products` as `category.displayNestedProducts` , `category` . `auto_increment` as `category.autoIncrement` , `category` . `level` as `category.level` , `category` . `path` as `category.path` , `category` . `child_count` as `category.childCount` , `category` . `type` as `category.type` , `category` . `product_assignment_type` as `category.productAssignmentType` , `category` . `visible` as `category.visible` , `category` . `active` as `category.active` , `category` . `cms_page_id` as `category.cmsPageId` , `category` . `cms_page_version_id` as `category.cmsPageVersionId` , `category` . `product_stream_id` as `category.productStreamId` , `category` . `custom_entity_type_id` as `category.customEntityTypeId` , `category` . `created_at` as `category.createdAt` , `category` . `updated_at` as `category.updatedAt` , `category.translation.name` , COALESCE (`category.translation.name` , `category.translation.name` ) as `category.name` , `category.translation.breadcrumb` , COALESCE (`category.translation.breadcrumb` , `category.translation.breadcrumb` ) as `category.breadcrumb` , `category.translation.slotConfig` , COALESCE (`category.translation.slotConfig` , `category.translation.slotConfig` ) as `category.slotConfig` , `category.translation.linkType` , COALESCE (`category.translation.linkType` , `category.translation.linkType` ) as `category.linkType` , `category.translation.internalLink` , COALESCE (`category.translation.internalLink` , `category.translation.internalLink` ) as `category.internalLink` , `category.translation.externalLink` , COALESCE (`category.translation.externalLink` , `category.translation.externalLink` ) as `category.externalLink` , `category.translation.linkNewTab` , COALESCE (`category.translation.linkNewTab` , `category.translation.linkNewTab` ) as `category.linkNewTab` , `category.translation.description` , COALESCE (`category.translation.description` , `category.translation.description` ) as `category.description` , `category.translation.metaTitle` , COALESCE (`category.translation.metaTitle` , `category.translation.metaTitle` ) as `category.metaTitle` , `category.translation.metaDescription` , COALESCE (`category.translation.metaDescription` , `category.translation.metaDescription` ) as `category.metaDescription` , `category.translation.keywords` , COALESCE (`category.translation.keywords` , `category.translation.keywords` ) as `category.keywords` , `category.translation.customFields` , COALESCE (`category.translation.customFields` , `category.translation.customFields` ) as `category.customFields` , `category.translation.createdAt` , `category.translation.updatedAt` , `category.translation.categoryId` , `category.translation.languageId` , `category.translation.categoryVersionId` FROM `category` LEFT JOIN (SELECT `category.translation` . category_id , `category.translation` . category_version_id , `category.translation` . name as `category.translation.name` , `category.translation` . breadcrumb as `category.translation.breadcrumb` , `category.translation` . slot_config as `category.translation.slotConfig` , `category.translation` . link_type as `category.translation.linkType` , `category.translation` . internal_link as `category.translation.internalLink` , `category.translation` . external_link as `category.translation.externalLink` , `category.translation` . link_new_tab as `category.translation.linkNewTab` , `category.translation` . description as `category.translation.description` , `category.translation` . meta_title as `category.translation.metaTitle` , `category.translation` . meta_description as `category.translation.metaDescription` , `category.translation` . keywords as `category.translation.keywords` , `category.translation` . custom_fields as `category.translation.customFields` , `category.translation` . created_at as `category.translation.createdAt` , `category.translation` . updated_at as `category.translation.updatedAt` , `category.translation` . category_id as `category.translation.categoryId` , `category.translation` . language_id as `category.translation.languageId` , `category.translation` . category_version_id as `category.translation.categoryVersionId` FROM `category_translation` `category.translation` WHERE `category.translation` . language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) `category.category_translation` ON `category.category_translation` . `category_id` = `category` . `id` AND `category.category_translation` . category_version_id = `category` . version_id WHERE (`category` . `version_id` = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425 ) AND (`category` . `id` IN (0xFA16AB0A538A8501A95E8578041B2F59 , 0x35B1ADB37395D91DE43B0B4634B78663 , 0x4F2D452ECAFFC1A1CFF6417787162675 ));
Copy
1.38 ms
1
SELECT `country` . `id` FROM `country` LEFT JOIN `sales_channel_country` `country.salesChannels.mapping` ON `country` . `id` = `country.salesChannels.mapping` . `country_id` LEFT JOIN `sales_channel` `country.salesChannels` ON `country.salesChannels.mapping` . `sales_channel_id` = `country.salesChannels` . `id` WHERE ((`country.salesChannels` . `id` = ? )) AND (`country` . `id` IN (? )) GROUP BY `country` . `id`
Parameters :
[
b"\x02 a\f\x08 ÑQN├ü\v b¦©!\x19 ÃÉ╣îW\x7F ÷K╬®¤Y┤Çpîà "
]
SELECT `country` . `id` FROM `country` LEFT JOIN `sales_channel_country` `country.salesChannels.mapping` ON `country` . `id` = `country.salesChannels.mapping` . `country_id` LEFT JOIN `sales_channel` `country.salesChannels` ON `country.salesChannels.mapping` . `sales_channel_id` = `country.salesChannels` . `id` WHERE ((`country.salesChannels` . `id` = 0x02610C08A5514EC3810B62DDB82119C7 )) AND (`country` . `id` IN (0x90B98C577FF64BCEA9CF59B480708C85 )) GROUP BY `country` . `id` ; Copy
1.32 ms
1
SELECT `payment_method` . `id` as `payment_method.id` , `payment_method` . `plugin_id` as `payment_method.pluginId` , `payment_method` . `handler_identifier` as `payment_method.handlerIdentifier` , `payment_method` . `position` as `payment_method.position` , `payment_method` . `active` as `payment_method.active` , `payment_method` . `after_order_enabled` as `payment_method.afterOrderEnabled` , `payment_method` . `availability_rule_id` as `payment_method.availabilityRuleId` , `payment_method` . `media_id` as `payment_method.mediaId` , `payment_method.appPaymentMethod` . `id` as `payment_method.appPaymentMethod.id` , `payment_method.appPaymentMethod` . `app_name` as `payment_method.appPaymentMethod.appName` , `payment_method.appPaymentMethod` . `identifier` as `payment_method.appPaymentMethod.identifier` , `payment_method.appPaymentMethod` . `pay_url` as `payment_method.appPaymentMethod.payUrl` , `payment_method.appPaymentMethod` . `finalize_url` as `payment_method.appPaymentMethod.finalizeUrl` , `payment_method.appPaymentMethod` . `validate_url` as `payment_method.appPaymentMethod.validateUrl` , `payment_method.appPaymentMethod` . `capture_url` as `payment_method.appPaymentMethod.captureUrl` , `payment_method.appPaymentMethod` . `refund_url` as `payment_method.appPaymentMethod.refundUrl` , `payment_method.appPaymentMethod` . `recurring_url` as `payment_method.appPaymentMethod.recurringUrl` , `payment_method.appPaymentMethod` . `app_id` as `payment_method.appPaymentMethod.appId` , `payment_method.appPaymentMethod` . `original_media_id` as `payment_method.appPaymentMethod.originalMediaId` , `payment_method.appPaymentMethod` . `payment_method_id` as `payment_method.appPaymentMethod.paymentMethodId` , `payment_method.appPaymentMethod` . `created_at` as `payment_method.appPaymentMethod.createdAt` , `payment_method.appPaymentMethod` . `updated_at` as `payment_method.appPaymentMethod.updatedAt` , `payment_method` . `technical_name` as `payment_method.technicalName` , `payment_method` . `created_at` as `payment_method.createdAt` , `payment_method` . `updated_at` as `payment_method.updatedAt` , `payment_method.translation.name` , COALESCE (`payment_method.translation.name` , `payment_method.translation.name` ) as `payment_method.name` , `payment_method.translation.distinguishableName` , COALESCE (`payment_method.translation.distinguishableName` , `payment_method.translation.distinguishableName` ) as `payment_method.distinguishableName` , `payment_method.translation.description` , COALESCE (`payment_method.translation.description` , `payment_method.translation.description` ) as `payment_method.description` , `payment_method.translation.customFields` , COALESCE (`payment_method.translation.customFields` , `payment_method.translation.customFields` ) as `payment_method.customFields` , `payment_method.translation.createdAt` , `payment_method.translation.updatedAt` , `payment_method.translation.paymentMethodId` , `payment_method.translation.languageId` FROM `payment_method` LEFT JOIN (SELECT `payment_method.translation` . payment_method_id , `payment_method.translation` . name as `payment_method.translation.name` , `payment_method.translation` . distinguishable_name as `payment_method.translation.distinguishableName` , `payment_method.translation` . description as `payment_method.translation.description` , `payment_method.translation` . custom_fields as `payment_method.translation.customFields` , `payment_method.translation` . created_at as `payment_method.translation.createdAt` , `payment_method.translation` . updated_at as `payment_method.translation.updatedAt` , `payment_method.translation` . payment_method_id as `payment_method.translation.paymentMethodId` , `payment_method.translation` . language_id as `payment_method.translation.languageId` FROM `payment_method_translation` `payment_method.translation` WHERE `payment_method.translation` . language_id = ? ) `payment_method.payment_method_translation` ON `payment_method.payment_method_translation` . `payment_method_id` = `payment_method` . `id` LEFT JOIN `app_payment_method` `payment_method.appPaymentMethod` ON `payment_method` . `id` = `payment_method.appPaymentMethod` . `payment_method_id` WHERE `payment_method` . `id` IN (? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? )
Parameters :
[
b"/»_ââšMpªXTÎ|ãâ\v "
b"\x01 è<\x1C ░═q<òTÔfÅ\x08 _\x01 Ä╠®Â[qèü╦\x13 $8k┴\x04 ZvóEê\x1D C°˜ýP†€È›ö "
b"u4Í\x03 ·`ID©¹û¼LDæÈ "
b"…"Vv2—CÑšN‚j¢ÝÜ "
b"ª÷\x1F _ÁnH\x06 ž^\x19 ‘[\x06 •s "
b"▒7Í6ÚÆO'ì┘\x07 $▓╗A "
b"¼wë1y>N5¯¡lwz\x18 /h "
b"½¯\x05 †p¡Kx¹[\x0F\x13 ·š\x0E "
b"╬G}‗┴ÅE2ê=ÉnQ┌Cg "
b"ÓQýÔ;dHy€!z\x02 ®Îé˜ "
b"Þêe'&ÞEù¶ç\x19 –ø\x1C !J "
b"áb0\x13 {\x15 D˜³\x14 'eŽh$ˆ "
b"íà[q›!AC¤Ë\x1C\x02\x16 ¸RÞ "
]
SELECT
`payment_method` . `id` as `payment_method.id` ,
`payment_method` . `plugin_id` as `payment_method.pluginId` ,
`payment_method` . `handler_identifier` as `payment_method.handlerIdentifier` ,
`payment_method` . `position` as `payment_method.position` ,
`payment_method` . `active` as `payment_method.active` ,
`payment_method` . `after_order_enabled` as `payment_method.afterOrderEnabled` ,
`payment_method` . `availability_rule_id` as `payment_method.availabilityRuleId` ,
`payment_method` . `media_id` as `payment_method.mediaId` ,
`payment_method.appPaymentMethod` . `id` as `payment_method.appPaymentMethod.id` ,
`payment_method.appPaymentMethod` . `app_name` as `payment_method.appPaymentMethod.appName` ,
`payment_method.appPaymentMethod` . `identifier` as `payment_method.appPaymentMethod.identifier` ,
`payment_method.appPaymentMethod` . `pay_url` as `payment_method.appPaymentMethod.payUrl` ,
`payment_method.appPaymentMethod` . `finalize_url` as `payment_method.appPaymentMethod.finalizeUrl` ,
`payment_method.appPaymentMethod` . `validate_url` as `payment_method.appPaymentMethod.validateUrl` ,
`payment_method.appPaymentMethod` . `capture_url` as `payment_method.appPaymentMethod.captureUrl` ,
`payment_method.appPaymentMethod` . `refund_url` as `payment_method.appPaymentMethod.refundUrl` ,
`payment_method.appPaymentMethod` . `recurring_url` as `payment_method.appPaymentMethod.recurringUrl` ,
`payment_method.appPaymentMethod` . `app_id` as `payment_method.appPaymentMethod.appId` ,
`payment_method.appPaymentMethod` . `original_media_id` as `payment_method.appPaymentMethod.originalMediaId` ,
`payment_method.appPaymentMethod` . `payment_method_id` as `payment_method.appPaymentMethod.paymentMethodId` ,
`payment_method.appPaymentMethod` . `created_at` as `payment_method.appPaymentMethod.createdAt` ,
`payment_method.appPaymentMethod` . `updated_at` as `payment_method.appPaymentMethod.updatedAt` ,
`payment_method` . `technical_name` as `payment_method.technicalName` ,
`payment_method` . `created_at` as `payment_method.createdAt` ,
`payment_method` . `updated_at` as `payment_method.updatedAt` ,
`payment_method.translation.name` ,
COALESCE (
`payment_method.translation.name` ,
`payment_method.translation.name`
) as `payment_method.name` ,
`payment_method.translation.distinguishableName` ,
COALESCE (
`payment_method.translation.distinguishableName` ,
`payment_method.translation.distinguishableName`
) as `payment_method.distinguishableName` ,
`payment_method.translation.description` ,
COALESCE (
`payment_method.translation.description` ,
`payment_method.translation.description`
) as `payment_method.description` ,
`payment_method.translation.customFields` ,
COALESCE (
`payment_method.translation.customFields` ,
`payment_method.translation.customFields`
) as `payment_method.customFields` ,
`payment_method.translation.createdAt` ,
`payment_method.translation.updatedAt` ,
`payment_method.translation.paymentMethodId` ,
`payment_method.translation.languageId`
FROM
`payment_method`
LEFT JOIN (
SELECT
`payment_method.translation` . payment_method_id ,
`payment_method.translation` . name as `payment_method.translation.name` ,
`payment_method.translation` . distinguishable_name as `payment_method.translation.distinguishableName` ,
`payment_method.translation` . description as `payment_method.translation.description` ,
`payment_method.translation` . custom_fields as `payment_method.translation.customFields` ,
`payment_method.translation` . created_at as `payment_method.translation.createdAt` ,
`payment_method.translation` . updated_at as `payment_method.translation.updatedAt` ,
`payment_method.translation` . payment_method_id as `payment_method.translation.paymentMethodId` ,
`payment_method.translation` . language_id as `payment_method.translation.languageId`
FROM
`payment_method_translation` `payment_method.translation`
WHERE
`payment_method.translation` . language_id = ?
) `payment_method.payment_method_translation` ON `payment_method.payment_method_translation` . `payment_method_id` = `payment_method` . `id`
LEFT JOIN `app_payment_method` `payment_method.appPaymentMethod` ON `payment_method` . `id` = `payment_method.appPaymentMethod` . `payment_method_id`
WHERE
`payment_method` . `id` IN (? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? )Copy
SELECT `payment_method` . `id` as `payment_method.id` , `payment_method` . `plugin_id` as `payment_method.pluginId` , `payment_method` . `handler_identifier` as `payment_method.handlerIdentifier` , `payment_method` . `position` as `payment_method.position` , `payment_method` . `active` as `payment_method.active` , `payment_method` . `after_order_enabled` as `payment_method.afterOrderEnabled` , `payment_method` . `availability_rule_id` as `payment_method.availabilityRuleId` , `payment_method` . `media_id` as `payment_method.mediaId` , `payment_method.appPaymentMethod` . `id` as `payment_method.appPaymentMethod.id` , `payment_method.appPaymentMethod` . `app_name` as `payment_method.appPaymentMethod.appName` , `payment_method.appPaymentMethod` . `identifier` as `payment_method.appPaymentMethod.identifier` , `payment_method.appPaymentMethod` . `pay_url` as `payment_method.appPaymentMethod.payUrl` , `payment_method.appPaymentMethod` . `finalize_url` as `payment_method.appPaymentMethod.finalizeUrl` , `payment_method.appPaymentMethod` . `validate_url` as `payment_method.appPaymentMethod.validateUrl` , `payment_method.appPaymentMethod` . `capture_url` as `payment_method.appPaymentMethod.captureUrl` , `payment_method.appPaymentMethod` . `refund_url` as `payment_method.appPaymentMethod.refundUrl` , `payment_method.appPaymentMethod` . `recurring_url` as `payment_method.appPaymentMethod.recurringUrl` , `payment_method.appPaymentMethod` . `app_id` as `payment_method.appPaymentMethod.appId` , `payment_method.appPaymentMethod` . `original_media_id` as `payment_method.appPaymentMethod.originalMediaId` , `payment_method.appPaymentMethod` . `payment_method_id` as `payment_method.appPaymentMethod.paymentMethodId` , `payment_method.appPaymentMethod` . `created_at` as `payment_method.appPaymentMethod.createdAt` , `payment_method.appPaymentMethod` . `updated_at` as `payment_method.appPaymentMethod.updatedAt` , `payment_method` . `technical_name` as `payment_method.technicalName` , `payment_method` . `created_at` as `payment_method.createdAt` , `payment_method` . `updated_at` as `payment_method.updatedAt` , `payment_method.translation.name` , COALESCE (`payment_method.translation.name` , `payment_method.translation.name` ) as `payment_method.name` , `payment_method.translation.distinguishableName` , COALESCE (`payment_method.translation.distinguishableName` , `payment_method.translation.distinguishableName` ) as `payment_method.distinguishableName` , `payment_method.translation.description` , COALESCE (`payment_method.translation.description` , `payment_method.translation.description` ) as `payment_method.description` , `payment_method.translation.customFields` , COALESCE (`payment_method.translation.customFields` , `payment_method.translation.customFields` ) as `payment_method.customFields` , `payment_method.translation.createdAt` , `payment_method.translation.updatedAt` , `payment_method.translation.paymentMethodId` , `payment_method.translation.languageId` FROM `payment_method` LEFT JOIN (SELECT `payment_method.translation` . payment_method_id , `payment_method.translation` . name as `payment_method.translation.name` , `payment_method.translation` . distinguishable_name as `payment_method.translation.distinguishableName` , `payment_method.translation` . description as `payment_method.translation.description` , `payment_method.translation` . custom_fields as `payment_method.translation.customFields` , `payment_method.translation` . created_at as `payment_method.translation.createdAt` , `payment_method.translation` . updated_at as `payment_method.translation.updatedAt` , `payment_method.translation` . payment_method_id as `payment_method.translation.paymentMethodId` , `payment_method.translation` . language_id as `payment_method.translation.languageId` FROM `payment_method_translation` `payment_method.translation` WHERE `payment_method.translation` . language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) `payment_method.payment_method_translation` ON `payment_method.payment_method_translation` . `payment_method_id` = `payment_method` . `id` LEFT JOIN `app_payment_method` `payment_method.appPaymentMethod` ON `payment_method` . `id` = `payment_method.appPaymentMethod` . `payment_method_id` WHERE `payment_method` . `id` IN (0x018A3C1CB0CD713C9554E2668F08205F , 0x018ECCA9B65B718A81CB1324386BC104 , 0x5A76F345EA1D43B098FD508680C89BF6 , 0x7534CD03B7604944A9B9FBBC4C44E6C8 , 0x85225676329743D19A4EAD826AA2DDDC , 0xAAF71F5FC16E48069E5E19915B069573 , 0xB137D636E9924F278DD90724B2F0BB41 , 0xBC77EB31793E4E35AFA16C777A182F68 , 0xBDAF058670A14B78B95B0F1320B79A0E , 0xCE477DF2C18F4532883D906E51DA4367 , 0xD351FDD43B64487980217A02AECEE998 , 0xDEEA652726DE45F9B6E71996F81C214A , 0xE16230137B154498B31427658E682488 , 0xEDE05B719B214143A4CB1C0216B852DE ); Copy
1.03 ms
1
SELECT
`name` ,
`base_class` AS baseClass ,
IF (`active` = 1 AND `installed_at` IS NOT NULL , 1 , 0 ) AS active ,
`path` ,
`version` ,
`autoload` ,
`managed_by_composer` AS managedByComposer ,
composer_name as composerName
FROM `plugin`
ORDER BY `installed_at` ;
SELECT
`name` ,
`base_class` AS baseClass ,
IF (`active` = 1 AND `installed_at` IS NOT NULL , 1 , 0 ) AS active ,
`path` ,
`version` ,
`autoload` ,
`managed_by_composer` AS managedByComposer ,
composer_name as composerName
FROM `plugin`
ORDER BY `installed_at` ; ;
Copy
0.93 ms
1
SHOW COLUMNS FROM `cart` WHERE `Field` LIKE ?
Parameters :
[
"payload "
]
SHOW COLUMNS FROM `cart` WHERE `Field` LIKE 'payload' ; Copy
0.87 ms
1
SELECT `language` . `id` as `language.id` , `language` . `parent_id` as `language.parentId` , `language` . `locale_id` as `language.localeId` , `language` . `translation_code_id` as `language.translationCodeId` , `language` . `name` as `language.name` , `language` . `custom_fields` as `language.customFields` , `language` . `created_at` as `language.createdAt` , `language` . `updated_at` as `language.updatedAt` , `language.locale` . `id` as `language.locale.id` , `language.locale` . `code` as `language.locale.code` , `language.locale` . `created_at` as `language.locale.createdAt` , `language.locale` . `updated_at` as `language.locale.updatedAt` , `language.locale.translation.name` , COALESCE (`language.locale.translation.name` , `language.locale.translation.name` ) as `language.locale.name` , `language.locale.translation.territory` , COALESCE (`language.locale.translation.territory` , `language.locale.translation.territory` ) as `language.locale.territory` , `language.locale.translation.customFields` , COALESCE (`language.locale.translation.customFields` , `language.locale.translation.customFields` ) as `language.locale.customFields` , `language.locale.translation.createdAt` , `language.locale.translation.updatedAt` , `language.locale.translation.localeId` , `language.locale.translation.languageId` FROM `language` LEFT JOIN `locale` `language.locale` ON `language` . `locale_id` = `language.locale` . `id` LEFT JOIN (SELECT `language.locale.translation` . locale_id , `language.locale.translation` . name as `language.locale.translation.name` , `language.locale.translation` . territory as `language.locale.translation.territory` , `language.locale.translation` . custom_fields as `language.locale.translation.customFields` , `language.locale.translation` . created_at as `language.locale.translation.createdAt` , `language.locale.translation` . updated_at as `language.locale.translation.updatedAt` , `language.locale.translation` . locale_id as `language.locale.translation.localeId` , `language.locale.translation` . language_id as `language.locale.translation.languageId` FROM `locale_translation` `language.locale.translation` WHERE `language.locale.translation` . language_id = ? ) `language.locale.locale_translation` ON `language.locale.locale_translation` . `locale_id` = `language.locale` . `id` WHERE `language` . `id` IN (? )
Parameters :
[
b"/»_ââšMpªXTÎ|ãâ\v "
b"/»_ââšMpªXTÎ|ãâ\v "
]
SELECT `language` . `id` as `language.id` , `language` . `parent_id` as `language.parentId` , `language` . `locale_id` as `language.localeId` , `language` . `translation_code_id` as `language.translationCodeId` , `language` . `name` as `language.name` , `language` . `custom_fields` as `language.customFields` , `language` . `created_at` as `language.createdAt` , `language` . `updated_at` as `language.updatedAt` , `language.locale` . `id` as `language.locale.id` , `language.locale` . `code` as `language.locale.code` , `language.locale` . `created_at` as `language.locale.createdAt` , `language.locale` . `updated_at` as `language.locale.updatedAt` , `language.locale.translation.name` , COALESCE (`language.locale.translation.name` , `language.locale.translation.name` ) as `language.locale.name` , `language.locale.translation.territory` , COALESCE (`language.locale.translation.territory` , `language.locale.translation.territory` ) as `language.locale.territory` , `language.locale.translation.customFields` , COALESCE (`language.locale.translation.customFields` , `language.locale.translation.customFields` ) as `language.locale.customFields` , `language.locale.translation.createdAt` , `language.locale.translation.updatedAt` , `language.locale.translation.localeId` , `language.locale.translation.languageId` FROM `language` LEFT JOIN `locale` `language.locale` ON `language` . `locale_id` = `language.locale` . `id` LEFT JOIN (SELECT `language.locale.translation` . locale_id , `language.locale.translation` . name as `language.locale.translation.name` , `language.locale.translation` . territory as `language.locale.translation.territory` , `language.locale.translation` . custom_fields as `language.locale.translation.customFields` , `language.locale.translation` . created_at as `language.locale.translation.createdAt` , `language.locale.translation` . updated_at as `language.locale.translation.updatedAt` , `language.locale.translation` . locale_id as `language.locale.translation.localeId` , `language.locale.translation` . language_id as `language.locale.translation.languageId` FROM `locale_translation` `language.locale.translation` WHERE `language.locale.translation` . language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) `language.locale.locale_translation` ON `language.locale.locale_translation` . `locale_id` = `language.locale` . `id` WHERE `language` . `id` IN (0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ); Copy
0.79 ms
2
SELECT
LOWER (HEX (product . id )) as __product_productId , LOWER (HEX (product . version_id )) as __product_versionId , product . id as __product_id , product . product_number as __product_productNumber , LOWER (HEX (product . active )) as __product_active , LOWER (HEX (parentProduct . id )) as __parentProduct_productId , LOWER (HEX (parentProduct . version_id )) as __parentProduct_versionId , parentProduct . id as __parentProduct_id , parentProduct . product_number as __parentProduct_productNumber , LOWER (HEX (parentProduct . active )) as __parentProduct_active
FROM product
LEFT JOIN product parentProduct ON parentProduct . id = product . parent_id AND parentProduct . version_id = product . version_id
WHERE product . product_number = ?
AND product . version_id = ?
Parameters :
[
"TM-CO2-comp "
b"\x0F ©\x1C ãéjK¾KÙÎu,4% ]
SELECT
LOWER (HEX (product . id )) as __product_productId , LOWER (HEX (product . version_id )) as __product_versionId , product . id as __product_id , product . product_number as __product_productNumber , LOWER (HEX (product . active )) as __product_active , LOWER (HEX (parentProduct . id )) as __parentProduct_productId , LOWER (HEX (parentProduct . version_id )) as __parentProduct_versionId , parentProduct . id as __parentProduct_id , parentProduct . product_number as __parentProduct_productNumber , LOWER (HEX (parentProduct . active )) as __parentProduct_active
FROM product
LEFT JOIN product parentProduct ON parentProduct . id = product . parent_id AND parentProduct . version_id = product . version_id
WHERE product . product_number = 'TM-CO2-comp'
AND product . version_id = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425 ; Copy
0.72 ms
1
SELECT id , path_info pathInfo , is_canonical isCanonical , sales_channel_id salesChannelId FROM seo_url WHERE (language_id = ? ) AND ((sales_channel_id = ? OR sales_channel_id IS NULL )) AND (seo_path_info = ? )
Parameters :
[
b"/»_ââšMpªXTÎ|ãâ\v "
b"\x02 a\f\x08 ÑQN├ü\v b¦©!\x19 Ãgeschenke/geschenke-nach-anlass/danksagung "
]
SELECT id , path_info pathInfo , is_canonical isCanonical , sales_channel_id salesChannelId FROM seo_url WHERE (language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) AND ((sales_channel_id = 0x02610C08A5514EC3810B62DDB82119C7 OR sales_channel_id IS NULL )) AND (seo_path_info = 'geschenke/geschenke-nach-anlass/danksagung' );
Copy
0.69 ms
1
SELECT `rule` . `id` as `rule.id` , `rule` . `name` as `rule.name` , `rule` . `priority` as `rule.priority` , `rule` . `description` as `rule.description` , `rule` . `payload` as `rule.payload` , `rule` . `invalid` as `rule.invalid` , `rule` . `areas` as `rule.areas` , `rule` . `custom_fields` as `rule.customFields` , `rule` . `module_types` as `rule.moduleTypes` , `rule` . `created_at` as `rule.createdAt` , `rule` . `updated_at` as `rule.updatedAt` FROM `rule` WHERE `rule` . `id` IN (? , ? , ? , ? , ? , ? , ? , ? )
Parameters :
[
b"\x01 Å\x14 tÜÃvLò\x02\v\v Ý╚Ť\x01 É£¼of|y┐¦\x11 ½§oRï'g\n
\x10 ØÙFü¾„ZÃŽòâcüÀùòÇÃAÒñé\x07 =µ¢Ð┼ "
b"■Ð@¤¤´N│É\x03 ╩ıº\x02 D\ "
b"""
\x01 ô\e ÜUìv¥ê£\x04 ©\n °j¦
"""
b"F-ø‘S\x10 DÅ‘8Ò'Ïý~Ù "
b"Ÿ£ê\x1C ¨\x03\x11 "4+L,ƒ\x02 ½\x10 "
]
SELECT `rule` . `id` as `rule.id` , `rule` . `name` as `rule.name` , `rule` . `priority` as `rule.priority` , `rule` . `description` as `rule.description` , `rule` . `payload` as `rule.payload` , `rule` . `invalid` as `rule.invalid` , `rule` . `areas` as `rule.areas` , `rule` . `custom_fields` as `rule.customFields` , `rule` . `module_types` as `rule.moduleTypes` , `rule` . `created_at` as `rule.createdAt` , `rule` . `updated_at` as `rule.updatedAt` FROM `rule` WHERE `rule` . `id` IN (0x018F14749AC7764C95020B0BEDC88FCF , 0x01909CAC6F667C79BFDD11ABF56F528B , 0x27670A10D8D946FCBE845AC38EF2E263 , 0x81B7979580C741E3A482073DE6BDD1C5 , 0xFED140CFCFEF4EB39003CAD5A702445C , 0x01931B9A558D76BE889C04B80AF86ADD , 0x462DF891531044C59138D227CFFD7ED9 , 0x9FA3EA1CA8031122342B4C2C8302BD10 ); Copy
0.58 ms
1
SELECT configuration_key , configuration_value FROM system_config WHERE (sales_channel_id IS NULL OR sales_channel_id = ? ) AND (configuration_key LIKE ? ) ORDER BY sales_channel_id ASC
Parameters :
[
b"\x02 a\f\x08 ÑQN├ü\v b¦©!\x19 ÃKlarnaPayment.settings.% "
]
SELECT configuration_key , configuration_value FROM system_config WHERE (sales_channel_id IS NULL OR sales_channel_id = 0x02610C08A5514EC3810B62DDB82119C7 ) AND (configuration_key LIKE 'KlarnaPayment.settings.%' ) ORDER BY sales_channel_id ASC ; Copy
0.56 ms
1
SELECT `app` . `name` , `app` . `version` , `app` . `template_load_priority`
FROM `app`
INNER JOIN `app_template` ON `app_template` . `app_id` = `app` . `id`
WHERE `app` . `active` = 1 AND `app_template` . `active` = 1
SELECT `app` . `name` , `app` . `version` , `app` . `template_load_priority`
FROM `app`
INNER JOIN `app_template` ON `app_template` . `app_id` = `app` . `id`
WHERE `app` . `active` = 1 AND `app_template` . `active` = 1 ; Copy
0.49 ms
1
SELECT custom_entity . name , custom_entity . fields , custom_entity . flags
FROM custom_entity
LEFT JOIN app ON app . id = custom_entity . app_id
WHERE (custom_entity . app_id IS NULL OR app . active = 1 ) AND custom_entity . deleted_at IS NULL ;
SELECT custom_entity . name , custom_entity . fields , custom_entity . flags
FROM custom_entity
LEFT JOIN app ON app . id = custom_entity . app_id
WHERE (custom_entity . app_id IS NULL OR app . active = 1 ) AND custom_entity . deleted_at IS NULL ;
; Copy
0.45 ms
1
SELECT `handler_identifier` , LOWER (HEX (`id` )) FROM `payment_method`
SELECT `handler_identifier` , LOWER (HEX (`id` )) FROM `payment_method` ; Copy
0.42 ms
1
SELECT `name` , `path` , `author`
FROM `app`
WHERE `active` = 1
SELECT `name` , `path` , `author`
FROM `app`
WHERE `active` = 1
; Copy
0.40 ms
1
SELECT * FROM sales_channel_api_context WHERE (sales_channel_id = ? ) AND (token = ? ) LIMIT 1
Parameters :
[
b"\x02 a\f\x08 ÑQN├ü\v b¦©!\x19 ÃJXCq0vLJKHDJnggImNR8Tk1lHZAHzsjO "
]
SELECT * FROM sales_channel_api_context WHERE (sales_channel_id = 0x02610C08A5514EC3810B62DDB82119C7 ) AND (token = 'JXCq0vLJKHDJnggImNR8Tk1lHZAHzsjO' ) LIMIT 1 ; Copy
0.39 ms
1
SELECT LOWER (HEX (id )) FROM snippet_set WHERE iso = ?
SELECT LOWER (HEX (id )) FROM snippet_set WHERE iso = 'de-DE' ; Copy
0.39 ms
1
SELECT `acl_role` . `privileges` AS `privileges`
FROM `acl_role`
INNER JOIN `app` ON `app` . `acl_role_id` = `acl_role` . `id`
WHERE `app` . `id` = ?
Parameters :
[
b"\x01 ŠŽå’Ör\x07 ±\t\x1D Ù¡\x10 2Œ ]
SELECT `acl_role` . `privileges` AS `privileges`
FROM `acl_role`
INNER JOIN `app` ON `app` . `acl_role_id` = `acl_role` . `id`
WHERE `app` . `id` = 0x018A8EE592D67207B1091DD9A110328C
; Copy
0.37 ms
1
SELECT `bisg_warehouse` . `id` as `bisg_warehouse.id` , `bisg_warehouse` . `group_id` as `bisg_warehouse.groupId` , `bisg_warehouse` . `number` as `bisg_warehouse.number` FROM `bisg_warehouse` WHERE (`bisg_warehouse` . `group_id` < = > ? AND NOT (`bisg_warehouse` . `number` IN (? )))
Parameters :
[
null
"BKRPC5 "
]
SELECT `bisg_warehouse` . `id` as `bisg_warehouse.id` , `bisg_warehouse` . `group_id` as `bisg_warehouse.groupId` , `bisg_warehouse` . `number` as `bisg_warehouse.number` FROM `bisg_warehouse` WHERE (`bisg_warehouse` . `group_id` < = > NULL AND NOT (`bisg_warehouse` . `number` IN ('BKRPC5' ))); Copy
0.36 ms
1
SELECT LOWER (HEX (assoc . `sales_channel_id` ))
FROM `sales_channel_payment_method` AS assoc
LEFT JOIN `payment_method` AS pm
ON pm . `id` = assoc . `payment_method_id`
WHERE
assoc . `payment_method_id` = ? AND
pm . `active` = 1
Parameters :
[
b"▒7Í6ÚÆO'ì┘\x07 $▓╗A "
]
SELECT LOWER (HEX (assoc . `sales_channel_id` ))
FROM `sales_channel_payment_method` AS assoc
LEFT JOIN `payment_method` AS pm
ON pm . `id` = assoc . `payment_method_id`
WHERE
assoc . `payment_method_id` = 0xB137D636E9924F278DD90724B2F0BB41 AND
pm . `active` = 1 ; Copy
0.25 ms
1
SELECT `name` , `type` FROM `custom_field` WHERE `active` = 1
SELECT `name` , `type` FROM `custom_field` WHERE `active` = 1 ; Copy
0.22 ms
1
SET @@group_concat_max_len = CAST (IF (@@group_concat_max_len > 320000 , @@group_concat_max_len , 320000 ) AS UNSIGNED ); SET sql_mode = (SELECT REPLACE (@@sql_mode , 'ONLY_FULL_GROUP_BY' , '' ))
SET @@group_concat_max_len = CAST (IF (@@group_concat_max_len > 320000 , @@group_concat_max_len , 320000 ) AS UNSIGNED ); SET sql_mode = (SELECT REPLACE (@@sql_mode , 'ONLY_FULL_GROUP_BY' , '' )); Copy
0.22 ms
1
SELECT `language` . `id` FROM `language` WHERE `language` . `id` IN (? ) LIMIT 1
Parameters :
[
b"/»_ââšMpªXTÎ|ãâ\v "
]
SELECT `language` . `id` FROM `language` WHERE `language` . `id` IN (0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) LIMIT 1 ; Copy
0.21 ms
1
SELECT `cart` . `payload` , `cart` . `rule_ids` , `cart` . `compressed` FROM cart WHERE `token` = ?
Parameters :
[
"JXCq0vLJKHDJnggImNR8Tk1lHZAHzsjO "
]
SELECT `cart` . `payload` , `cart` . `rule_ids` , `cart` . `compressed` FROM cart WHERE `token` = 'JXCq0vLJKHDJnggImNR8Tk1lHZAHzsjO' ;
Copy