Query Metrics
487
Database Queries
4
Different statements
173.01 ms
Query time
0
Invalid entities
1348
Managed entities
Grouped Statements
default connection
| Time▼ | Count | Info | ||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
121.94 ms (70.49%) |
483 |
SELECT t0.id AS id_1, t0.plan_path AS plan_path_2, t0.exploded_path AS exploded_path_3, t0.assembly_path AS assembly_path_4, t0.extra_info AS extra_info_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.product_id AS product_id_8 FROM set_details t0 WHERE t0.product_id = ?
Parameters:
[
"dd8ebe1f-eb12-5bf0-9829-862d892e9d8f"
]
|
||||||||||||||||||||||||||||
|
37.38 ms (21.61%) |
1 |
SELECT p0_.id AS id_0, p0_.sku AS sku_1, p0_.name AS name_2, p0_.description AS description_3, p0_.price_including_vat AS price_including_vat_4, p0_.featured AS featured_5, p0_.price AS price_6, p0_.currency AS currency_7, p0_.vat_rate AS vat_rate_8, p0_.enabled AS enabled_9, p0_.stock AS stock_10, p0_.image_path AS image_path_11, p0_.show_title AS show_title_12, p0_.show_content AS show_content_13, p0_.imported AS imported_14, p0_.imported_code AS imported_code_15, p0_.is_set AS is_set_16, p0_.obsolete AS obsolete_17, p0_.visibility_role AS visibility_role_18, p0_.metadata AS metadata_19, p0_.created_at AS created_at_20, p0_.updated_at AS updated_at_21, p1_.id AS id_22, p1_.role AS role_23, p1_.position AS position_24, p1_.enabled AS enabled_25, p1_.legacy_media_id AS legacy_media_id_26, p1_.created_at AS created_at_27, p1_.updated_at AS updated_at_28, p2_.id AS id_29, p2_.locale AS locale_30, p2_.path AS path_31, p2_.alt AS alt_32, p2_.title AS title_33, p2_.mime_type AS mime_type_34, p2_.size AS size_35, p2_.width AS width_36, p2_.height AS height_37, p2_.created_at AS created_at_38, p2_.updated_at AS updated_at_39, p3_.id AS id_40, p3_.filename AS filename_41, p3_.original_filename AS original_filename_42, p3_.name AS name_43, p3_.mime_type AS mime_type_44, p3_.type AS type_45, p3_.locale AS locale_46, p3_.created_at AS created_at_47, p3_.updated_at AS updated_at_48, c4_.id AS id_49, c4_.category_usage AS category_usage_50, c4_.created_at AS created_at_51, c4_.updated_at AS updated_at_52, c5_.id AS id_53, c5_.locale AS locale_54, c5_.name AS name_55, c5_.created_at AS created_at_56, c5_.updated_at AS updated_at_57, p1_.product_id AS product_id_58, p2_.product_image_id AS product_image_id_59, p3_.product_id AS product_id_60, c4_.parent_id AS parent_id_61, c5_.category_id AS category_id_62 FROM products p0_ LEFT JOIN product_images p1_ ON p0_.id = p1_.product_id LEFT JOIN product_image_translations p2_ ON p1_.id = p2_.product_image_id LEFT JOIN product_library p3_ ON p0_.id = p3_.product_id LEFT JOIN category_product c6_ ON p0_.id = c6_.product_id LEFT JOIN categories c4_ ON c4_.id = c6_.category_id LEFT JOIN category_translations c5_ ON c4_.id = c5_.category_id WHERE p0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND p0_.enabled = 1 AND p0_.is_set = 0 ORDER BY p0_.name ASC
Parameters:
[ "2e9fb162-a352-5d6b-b889-eb32eeff3b55" "b4441309-1ce3-5881-bdbd-d42255cfcfa5" "bee2c212-7d28-504a-bc8c-6a2907535b7f" "14eaa6b9-139e-5043-9cf3-8c2319b3870e" "fc515488-926f-51b7-9269-f9cde9391919" "89089077-98d6-5e3c-bcff-295dc7dc1d69" "13393137-c53e-5f2e-8272-e28301b914fb" "438ba350-7e50-57d1-8026-cdccf3c84d45" "94a04d22-c484-5a9b-8236-e3be9aca8b44" "8ae262cb-588a-5035-b70d-556847307c7d" "f51bab3e-3864-5029-ac60-6d213841010e" "2fcb8252-b2f6-507e-b131-cae402f61d95" "d366cc90-2f36-5d3e-a892-f267b66c230b" "48238f8e-bd1b-5c4d-87d6-f923d30b04c9" "020f94d6-7b14-5012-811a-e0ac1e8943f0" "0de40be7-a6c6-5be9-85e7-14b4aff97054" "17762c1e-8b83-5eac-b399-9c4dc18f323b" "a26d1943-c0b1-59f4-9463-4c3517a92a4a" "4a0d5ff9-c6a0-5f65-9838-bd367d609c99" "aa43108c-d8e1-5cb3-8dd7-6e022a8efa77" "ce6d7820-5904-53fa-bbc1-f835155b965a" "08bc4891-d401-5443-bf79-fcc12cb977e5" "46409df8-b0af-5288-98e5-2fbdb50bbcd5" "cd58750f-9d97-5eec-9a3c-59d41e83900f" "c0c177b1-a8b1-514f-b26e-df333b3f13da" "8fd1c2bf-1a47-526a-88c9-ae83ecab8f53" "0301ee02-5606-5b10-acbd-a17f932543d9" "71cfc7d3-25c0-543d-8341-b515b485a8cf" "40e8c305-0ee1-5c20-b560-9a9155b5ee71" "73bad55f-73c9-5c74-ac3c-520be1f5f1c0" "be81c416-cdde-57f3-84de-3d7e3fbfb2c3" "4355bb0f-f7b1-5456-a9f6-4ec7b8bd9551" "10a8cfca-33e3-519a-9e86-9944d41a1e7d" "bbe7e14c-86cc-53d2-bfd7-8b9357586542" "2ef3cd40-9cc1-5dd0-a91a-73a0df6ff366" "14f79245-f6d0-5e6e-bbfd-23785f7ac2e6" "e085e74c-6338-5c11-9026-0925a6f5af5a" "6011ed01-4250-5c48-a5a4-72d34c2c39e0" "8bc436bd-6156-52f4-98f3-09431fc722ef" "da64a58b-2a7c-51d3-8d15-3cd6d09d2571" "98de940b-39e3-5322-b9d6-228f48b083a3" "6a0da5bb-9220-5b01-ad07-8a2888dcc07f" "8c26e4cd-0289-51da-8180-24ee5098948b" "e1e1fca8-c75b-5768-bf85-9dedbb8f96a7" "d3697fbc-c7d6-5183-a6bf-4fe41c8dd94f" "d858b046-325a-5a6e-a879-3972158e5d47" "4d3af4b3-56ca-529f-9503-100cbf84c2a6" "97bf4e87-aa2e-56de-8b92-67679dca0db0" "b7078755-0c33-56f6-8268-79bcde692271" "d7f44f6b-10ff-5551-a06c-cb8378b7d1fd" "393ccf2d-f31a-58e9-95f2-21bfd83c6b24" "5529d58b-58ca-53e4-9cf5-7e6987f92c76" "5c9a030f-74f7-51bb-a42f-0fad4030f039" "b91f3361-9f00-5610-b999-d32fd43f9995" "ffba182c-eead-5300-87b5-34076a7dcbf9" "4314ff37-cf67-5beb-b49f-04405cbce938" "54f4edaa-90ef-5aab-a010-bcec448da8bc" "2782d4ce-aa90-543b-8bbf-cfeccdc7fc6d" "168dba22-be44-59f9-ad55-0394fdce9184" "67512ee8-8d2d-5cc1-b0ed-358be2db160c" "4816d1ce-feb6-5362-b87f-f0a90b038ced" "7860d61b-b94a-5806-bf82-fe6bbed54ac9" "2093de63-cbfe-520a-bd59-d03b8f5bfc7d" "f10cfef4-7d77-574c-860b-6439206e2a44" "b473ce32-cc26-55f4-931e-b15ba69db733" "ec8cb017-5bc7-5fea-ae7e-795eaeefa0b4" "1e81b0f8-5de9-5247-85c1-abdbb834c21c" "86b008cd-f991-5fcd-83dc-677f9e62c1c0" "52c860aa-51fa-5b76-b4ed-c8ee7b1f04c9" "a3409b7d-14c0-56c8-897d-e146a514e7e3" "3d68db34-ba0f-5124-95ac-1442e8200d59" "ec88752f-85c9-558e-b06d-c923feb812d4" "fb5536d2-2385-51f9-8245-0a9f315ea6df" "fff8070d-0574-5daa-83f1-76f2c6adea65" "fa27dd05-a2b9-5b60-a4f3-8b231878e11c" "828e8e16-54e4-5ad9-9290-f42fc2f9413c" "9382717e-bd0c-5427-bf95-b55d3b63580e" "1de5596d-05df-5d11-ae09-5c4ca3f19350" "5036d103-ff97-5737-a41b-5eefa9a8cd56" "e525de83-260d-52bd-8a5c-d4bc5376da07" "41493453-6e17-5af0-a7c5-c84a2ad450cd" "7ce1dfe5-a962-5449-96ad-3d56d7187231" "602e6018-6d97-542c-a3be-a8dd9230012d" "6d156d87-01fe-59b0-82e9-c83793e55244" "65e4a98d-abd6-5ecd-a9f6-53177abec458" "765cc238-c06c-582c-a334-1eec91f6af18" "5dd8db5d-1b33-5808-ba26-13dadabf2a09" "3358ae06-01f7-5aad-8f14-2822be13a599" "cb881c6f-3f17-5adc-9d10-bc41938b99e3" "c91e8927-d7aa-5980-bd27-6577b32b5f66" "d7167cd4-2186-5ebf-9fdb-0204562649d0" "00e58324-80eb-5afa-8c28-dbb8c56bf15f" "48680508-c93d-5f0a-9b5d-d6b310d13e35" "87383e6e-ebed-579d-a0f6-0dc794236b8c" "f4b877e2-2787-550d-ac7d-193401ae1db5" "dc6bdf63-2e52-5f22-b3d8-9f5aee5120d6" "37d48f42-20d7-5753-a82b-182999fdb027" "dd763e79-e2f7-585b-941f-c8ed7a73dde1" "e07179bd-53e1-57e1-bce4-2a1b3afe36eb" "f8ea2d54-61ba-5bfa-bf17-8918d8eb2f9f" "09b6d1f6-e3de-5593-bc3b-b08346507f57" "fa9163ab-0a1a-552b-a351-ede402ad35db" "cb8bf8b5-3aa5-502c-bbf8-1f1e13c0235a" "7717c48c-4a9b-5faa-add5-613a688041a7" "34fa9f3b-57a6-53d4-b8fe-4d7e095e6412" "e63364f3-7fac-5aa8-8f45-8acea5dd281f" "e69d1f4d-9118-59ba-9ab3-65784848c52d" "68cf1ab1-c504-52c5-be78-d9284216c786" "5467cbbe-c074-5c04-88cb-68b6597ee363" "ed684a60-ce32-5e07-a4cc-ff49a1be52da" "e4e6b66c-ecc3-528f-801b-4c0774a9192a" "74113c7f-bacb-5b1a-9848-1bae5e65795d" "dbb5fa5e-dc10-5b70-a03f-24a55a537d94" "e6f425cc-f103-56b1-9334-533a4d63d7f9" "c4708f28-3303-5efd-ae2d-e5d6caad90ea" "da30825e-3880-5706-bc4f-d95b2400160f" "cfbdf4dc-10af-5a03-900c-7cf68bc0fddf" "7710ebe5-c03b-51cd-9816-68ac2442207d" "23f38f30-e1a0-5c13-8038-11025b68a425" "35c01bab-f1cf-5f18-9222-1d8305470f0f" "d95412e8-2a3a-5559-9094-97eeb7e854a2" "824ace12-7322-5eb8-83b9-515589edc1cc" "c96c9571-9860-582e-a397-5d6fd9678f30" "5140c5e7-a2a9-572e-8898-ee059de19d81" "94be81c8-fe34-53a8-ba39-f09a96975ef8" "ee3b95eb-212d-5d7d-b4f1-4575f41c09ac" "8ec903a7-524a-599a-9cb2-ced30ddd5d6f" "4f2025f3-2d52-50da-bd07-5ae94a50f3c8" "9c5cf666-3716-52f7-a39d-bdf4f877ee08" "b69630bd-0d5b-5318-bf93-03a259a42b7f" "9e00d8df-2e78-59f7-abb0-6b0b30d5ecca" "e77751bd-6f2c-51d6-b7da-f8dce5f219ca" "f3555fb6-96b4-5caf-bbbd-5e8ea26a9a30" "083b74ee-f8bc-59c4-98a7-344acfd575f9" "d3d8a73a-c365-5c80-adf7-b5c32f3d10a5" "d620659d-7f32-5469-baa6-dda58de6b898" "9318ce2a-6ad9-5991-9cd0-1ed7c0d23ca6" "b7f11b88-6ea6-5c19-95b7-3ba6c1e47e3d" "d368e22a-6b8a-5216-a7d6-c61e1b7486fe" "aac3d9e1-7623-5086-9447-52cb8a93f4e7" "ef9169f6-4db9-51cc-8ecf-fcf4aa543dc2" "7ffae380-95ab-53fd-b057-32612d21f5bc" "72dc7b1e-6a1d-5092-9755-3d11ffec2d25" "8dd03131-c243-5c76-9c0f-73c75635bef9" "d89cf394-0269-5656-9bd9-ab0425e58a93" "8168fe6c-b50c-5fa1-b602-22db9c27a88d" "1370616c-7268-5f81-85b0-65066730838f" "db8ac287-86d2-533c-8047-b8dd873132dc" "8ae5f59a-afc2-5d73-94d8-34d03dc9df64" "4f5aba0e-0b95-5399-a6e9-4dc06590d679" "00f72923-ab93-58fa-aa7e-a4abc672d26f" "bfe3dc29-977e-590e-b468-9797bcc5433b" "967d5aca-2d8f-56ff-9449-c1c7f3ab180f" "c3f53928-5987-5f85-9328-71e535827500" "453b93d5-a66b-52d9-ac51-36cb6a6369f9" "4be4cd45-0be1-533e-8915-5ef176b5570c" "446fb5e7-055e-5291-8340-949c078020b6" "c63fac14-ce7b-5430-9944-82d8cb86d692" "c64e0a33-edd0-5477-b7bd-a23c0a90bc86" "0f1f164a-06ed-58c8-9488-1ebb16c612fd" "95d8bcd0-74ce-5d82-b32c-7caf894f0dbe" "1234ba4d-0d58-581a-a752-f7d08b090843" "1c805ace-1521-526b-98ca-b75c10199a8a" "7696ef8d-1d76-52d3-9513-1751bcf7e413" "50cd4a04-bc70-53d9-bf06-711496a3917a" "e142eb47-0c61-538b-bb81-96f8a067b4fa" "cb309b5c-b0e2-5cd8-b779-7e94f06399b1" "f2a4d1ae-6dfa-534b-9281-4a18740a09dd" "5b3025a4-7cc1-58a6-a997-592605144f0e" "3a118be2-a822-54b1-9b9f-82dbf73824d4" "5575ded1-b340-58cf-a84d-ad1a6eff0da9" "094d28e2-9398-5d44-bea5-4dac1ea81c3c" "2e30b59d-c7e1-5ef2-ab8f-ad4b0a35e1f2" "1ef7e539-2838-53b1-9686-7ce0eb31bf05" "50d454ac-d77a-5c1d-bb2f-5eeb10e22207" "a34d7856-e310-5b47-84e0-168360e98f59" "51565e25-e08f-5374-9efd-2eecebff8849" "f344fb6f-aa74-59e5-a5f6-a324010834dc" "8a9557b7-7668-5c28-864f-5c7f78b5807d" "48f89591-728f-5d69-b439-8f48cd00e21a" "90010006-1c0a-5664-93c5-bbc911a1de63" "b1c91e71-a083-5578-9270-f6743fac263c" "243291ad-6b76-583c-bfd2-2d2e6ed62277" "ff34c29b-764d-5c3a-8a7e-b7a3ac6d9563" "d9cd72b1-98e3-5696-8aac-db876a25329f" "145fac2f-16b3-5ef4-b4ec-b41e5001bcdf" "6e4e75ec-eccc-58d2-abca-904c554e751d" "54f561f5-42d6-5a8c-bb5d-2a03ebef52a6" "9299c192-ca20-5fc6-804e-521eb9523833" "eeef24ad-ad3a-57ce-b080-badb49c19d2c" "b5a32f2a-a2bf-53ab-8480-eb7c3158b6d9" "c0e159c6-d0dd-5d0c-aefa-9104968efc4d" "8838b134-2020-5904-ae32-ba22a1e89d17" "398df66a-461f-52d4-aa27-38c3820c5adb" "0b9737ae-fdbe-57bd-928f-b1f410254fe3" "b3cc8479-9777-5882-bb44-2b7caf426447" "56447346-1a84-5e9a-8607-9fb1d2745748" "f7c9e4f4-ce03-5b12-b724-fef50a55f396" "4eb0317d-2afb-53fb-b3fb-9b600d90d440" "d8e3e49a-f765-5c99-b46a-5c74d1910bee" "fe64b5b9-db71-51bf-82a5-2db0e01b7dca" "f48bfc3e-1a9c-5203-8c5c-2f77918d81a2" "94dba156-2c0b-5306-9970-4207b1a6d8af" "980d9e58-e0d7-59b1-b37f-2161089a3f05" "195e569c-f5dd-51e7-8cab-aa99855910b4" "b09085fd-4a1a-5e3e-9efa-7c3e0146ceb0" "44813351-76dc-5a10-95df-9457a7174fc2" "fe8a7cc5-5ac7-5d29-b7b7-151100c7d303" "3284d9c5-a90e-56b9-8cdb-6bcd2304034f" "1d9191fe-94df-5ed4-9763-998cbec50261" "dd7587f1-7c17-556d-b21a-02613bbf4563" "c91c3c6a-c048-53a7-b8ce-a83b7a73ffa3" "97cdb887-2e9d-5fb5-8efa-fd32d7e640b5" "74e7347b-67ba-53b5-b37a-07fb850b9a3f" "4e6b1062-da27-52c1-adb0-a8f58a4f638f" "61f330e7-3c42-558c-bb61-419cab082047" "971035df-4551-5daf-84bf-894c71fde7f2" "6ae01fd9-684a-5362-9722-106791263ee1" "d04be663-1587-5bea-93e5-55cdab42d22c" "50d9a98d-4507-5eff-8e55-79f4b9bbc67a" "b619aa05-0137-514a-bc38-b58a3d8b1bf4" "9971aecb-016b-540b-9662-03397392f6b8" "65778692-bff8-5c34-8727-f3281fa87740" "3849f46d-f75c-5a01-b2f2-06069bf83b1f" "35825a65-816e-5aa5-abd2-d195f270f991" "7cedb310-92a7-5978-9534-cadf24f8456c" "101a3a04-a998-50e7-b2a8-dc9b1170035a" "c131eb9f-779c-506f-bfae-6061920ff219" "30a622f4-3aa6-5c1a-b111-0ae7f0854d37" "eb3afa4e-8cb0-5976-8f46-d475d71b9ea8" "16c6ef47-9b37-54ab-8abe-3535b11e9935" "6ef982d1-cd01-5ff6-bf81-8ef71829a8d7" "30c8ec7f-aa53-547c-8ec7-2eee0cc4b9b5" "21790074-2b59-5878-9b3d-2aac109a608b" "5fec44a8-8dc4-50b8-94b1-45638b892b26" "002afc4f-a607-52c1-805c-23263fe68e39" "cdc28955-57ae-5aa3-a57f-68ba1f9066fd" "dee9c3c2-74b1-53ba-8cf7-05343fe94a09" "1e86d8a0-c4c4-5cc0-b0e5-cc51e0074d08" "5fe71850-97b7-549e-a866-f5caff7bd05d" "3c84e68a-fa51-5f15-bd56-4b11c417ff55" "745640be-28c7-5793-8645-c5c5d3348d0a" "63f0d000-4060-525f-8f51-1b2ddfb96db2" "08daaad5-7455-5d0f-b3a8-ba89f2e44d9a" "ff893d09-c3e4-5552-863e-2e205d349b62" "7d1cea38-eb29-5f20-85c1-9380fbf9ef32" "1a9cc475-0273-5d4a-aa6e-514b1c8afa91" "8b280652-f58f-59e5-bfb2-060aa26db420" "da033752-1a5f-5b3e-9fdc-bb6b747b6b5b" "76cc71e7-5d9f-56ef-ad91-d06c46f56c27" "df71b2fa-1c4e-59e2-b384-809391800e44" "fda73a85-8bd7-5396-bec1-356dadb19d67" "084945f3-5e53-5c60-aa6f-5d9de44ae694" "2d7f9b4b-27d3-50c5-8acd-9b369df97b07" "0fa8fd96-cb79-51cd-975a-724c2dd3aec2" "916fc731-baf5-538c-a0ea-c60f03d44199" "d7ee5314-9390-54ea-ba9d-39a23f558b3e" "103e9cbe-2192-5c23-9198-fad03d681dbe" "d1f83542-0cc2-52c9-8017-b715af0a9b21" "de682d8a-f4bb-5887-a82d-9228ba8e07d4" "638f11b1-14c9-5dbf-8739-f3c24bb5fbf3" "0e6621f9-ce69-5520-b5f3-8cf681a8e5ca" "32d73d90-aae6-52a2-bef3-54585ea8b0bc" "e2d7a244-da2e-5d68-98ba-6e96750b8f1f" "e2188d2f-f343-5f21-a1dc-c5f3d54fa207" "b8cbb688-b2eb-5892-812e-e17a2291b2f7" "d57968e5-5bf4-51a5-a219-90c941d0080f" "538cb6ac-8a32-55d0-889d-91472df17385" "3b14afca-c163-55e7-a1fe-ca8af2135591" "29266e00-6221-5d52-a4e9-042ba04b3afb" "707ed3c1-ccfc-5328-8893-b7c37e64e95c" "ab9d857e-8b44-5db4-8a28-6071e0621116" "7392af0d-cc08-5648-8278-bbf4eb4881ae" "0079e32d-2ef8-5ca5-a2b6-b2d60bfcda3a" "c0c884e9-4809-5f3e-9d69-0535b8e1a3d1" "5042692c-c7cc-5aca-81d7-ccc873b8fadd" "9b90caf4-9a66-58ce-a911-8fe16c23cd35" "4725ef68-70fe-56eb-87bf-b9f8a40456ba" "88afdfe7-232e-5aaa-ab9b-dbc92282f779" "7c2f7a9d-9dfb-511c-865b-473ae462650e" "50c80ac3-3214-5310-a857-fc62a4b24030" "baa97031-ff3d-508b-9243-652704a09002" "1792e689-67fd-5f6c-af0e-0319cc4c6e32" "db695794-3bda-5e1b-a0eb-7d578602463b" "c736a304-d7e3-5334-9935-7c12b202e37d" "d7073f74-fc5c-5046-82fc-564e47ced964" "b57a72bd-3060-5c84-ab9a-b4d44443b72c" "5f19f465-5d9d-5890-811d-05a69262b6d0" "a87b3da6-da6b-5e79-bce7-e169016eb6cb" "f239cb1e-ba7c-5ba5-a8aa-b8035bbbc947" "4fdb2879-b690-56b2-8da4-2e01dede9413" "5fe2b8a9-518e-529b-bc14-4b26d786b128" "2e59d6a5-0344-558c-b217-cb7992e2f1e1" "5a23b98f-0de8-5292-9eac-813dd59374e2" "66e8e76c-9a41-51b0-94e4-a22afe5c515c" "f4b95af9-b4e4-5316-8045-91d55a8c077f" "87a0ee47-e84e-5549-a18d-23f9e3f1261b" "758f8fc6-dda4-5c53-9d83-f1b9eff19fc9" "8f462b6f-bf7d-53b8-938b-bbb25aa416ae" "e6e15856-bda6-546d-8e1c-b41d9a958c1e" "21846901-a232-52ef-b590-be6268af1b6a" "222fd2e9-a7e1-5708-9dc4-8508f0b6e176" "1043e95e-a7e4-5afc-af36-3c678dbeb9bd" "23e6c65a-bfd8-54e1-899f-f1abf9887d4b" "f3da1689-aa9b-5a49-b1e5-d713ad851266" "0bc537d9-b370-5be5-bce7-c6b04dfa9c86" "1e378279-6de8-5169-8553-5a2cdc6e9483" "33e32d5f-4681-5442-a731-7d8939b21d10" "ad26b443-499e-5f0e-b8c3-db9fbb6fd99b" "d11c1d43-76c4-5ac2-8181-c4df1be2b0f2" "5f04c877-b215-55eb-9871-6ed84b3db1de" "3f0b49bc-a705-531b-b2a6-2959a2244b91" "fe2e292b-4ed0-5576-8637-719c77af928e" "0c4b26d2-783b-53ff-b46b-53ef0fefdaad" "1510e805-7f76-5284-8296-4f40bce739fb" "2fcdd26b-03cc-5dd1-a615-f2cfdb0732f0" "a0a25929-bfb3-56e0-bb60-945bf2847423" "176acb41-7e16-5cfa-a126-1f801a739629" "aaaa2142-05d8-5241-9ec5-bbabad24e76c" "f50cfea7-fa4e-5ae9-99be-66cee55311e1" "bc440984-5138-59c9-a092-7de0c3898ed9" "4825756a-119e-58c9-b55b-6f233650d7ba" "3ed873f0-d615-5679-9740-76d1ee85c2c7" "2ef33967-e506-5001-a0c4-fc8b77cb7c4f" "8d90a487-4982-5849-b4bd-934d1529fd23" "ab574726-c731-5f22-8ab1-731a1510a6a7" "57fab8fd-6ffc-5131-9abe-52f5d05a4412" "75c4d50e-aa4e-5963-a552-5b9d4014222c" "28d8f2f6-2484-5625-a486-6b11a9b11ac2" "9825db31-8d8c-5fc3-bf7d-712eafe14176" "07cbe8a1-3ea7-5c26-b23d-e80f8a5212fe" "9ec3b7fa-2d63-53ef-b10d-659bda3b9cad" "6c70fe2c-f640-5ed3-8158-5662aff3879a" "af721824-b8cf-5841-a6a6-3a96421d1909" "2be58f29-f334-5a8e-aaac-701a8ca02b99" "53ce6f0b-f0be-5170-be4e-3692dd471ea8" "8510f673-4866-5094-91a4-444a48c7abf5" "35937a56-f2f8-5c9a-a86d-d16acc86f6b3" "5e73aec3-729f-5af6-96db-fe43b2f2af67" "98a4933b-2c7a-5c59-9993-1cf6869a129c" "c1f14820-814b-51f2-aa32-62834a1a7924" "61904f1f-60df-5228-864f-660c4bfaf595" "6a4065b0-c934-599d-becb-cd827727ac26" "bd208e7e-a5dc-5fe1-a2b3-27a267992771" "f7761968-9277-5c90-84de-5a5b357ff3cc" "d7b20192-c6f2-5f32-9222-90c07ca91611" "060849ea-a48a-54c7-9660-c9cc0fe34933" "c019b6be-e465-5770-a517-ef7fdf4ebe7a" "df9e1815-6be7-5bf1-9178-60599ca0fda2" "05d19ca7-724a-5f5d-b403-cf203623ccd8" "1d26049b-1698-5a90-b142-30be66b15900" "15271399-1a0c-561c-a7fd-aae1562dd690" "e87dbae7-0b83-5646-ab30-cf0b510f4d76" "2326fae1-f60f-5e6c-bc9a-771a40204ef4" "0ef868de-82a2-50a0-b145-c86f3d6fa63f" "200400c1-54d4-5c43-b471-8ad9fcf5932e" "4e93ab0a-3e15-5289-9b4b-7e991097eb88" "4085afce-0f06-51c1-ac81-e89b0ff8537b" "f8ade83a-8640-5f82-847f-43acf13bddbc" "79297a22-0889-5359-bb34-661ba06181da" "3c885985-1823-5650-beed-ea6db38d7209" "63c89959-27e6-5246-b3b5-9ebcd111c7be" "ff7732e9-8c13-5627-a9bc-28ef338b3e1c" "4bd60888-ffc9-5b8d-ba9d-2ceaffad916e" "87011b51-0c9b-5da4-b3fd-bd3fe6cd1d15" "fcb10186-3080-51f4-973b-ef4ae65017e9" "65ebe8d3-a9d0-547f-8069-93606f5b831b" "4f76f901-4355-5c6d-a9e6-5b0bcb2097dc" "f8c6884c-2a96-507b-9e6c-fc50ff43af3e" "baa21ba8-bf18-5be5-b1f4-22f1ec21ab36" "bb503dd6-c2cf-5f5c-a698-26398d5dd952" "cfded749-78a1-555e-8091-1f1799dd37f7" "5326a851-2e08-57d4-9249-ad63b8637b99" "1954a2f0-4a11-561f-b425-5bd9b30670e0" "148f9389-8f41-5d64-93ba-9c06b3af1271" "8206062b-786a-589a-b5f8-64496bf5d4d0" "12d11574-b9d3-5218-992d-839eac68120c" "55804c6e-172e-5930-97a8-09b6abef3fcb" "d4db4980-ff9a-55b6-a4f2-02cc4b3cdc08" "d2ed03e4-9279-5d50-993a-059beef64fde" "3c1b9cfd-9814-5bba-8f33-1b9ffc05e7ab" "ad8eb17a-d523-54d6-83b8-74418fbbd4cb" "b5e6a124-e9d9-5e78-b90e-e552078ae5bb" "8099153e-3a90-5668-af88-5d52572c6d6e" "bb3f2794-c8ad-5624-97c9-20c8b883fe30" "cc8a3505-5f47-58b7-8227-f139c489cbb4" "3aa02981-7dfc-5e43-ac71-549c318571ac" "79888c22-df80-5bea-8e83-93ced6db19ee" "f227a5b9-3ef7-557d-abc3-4c91d9d77e72" "caf8fd33-c311-510b-b4ef-23e70c5300f5" "f73a1a67-b435-5e88-a3b2-18db816f109e" "d02805b2-f67a-515e-9efa-d79c2c04eea7" "41025c22-a328-533a-98ee-1ee7fa8d9fee" "165c1614-d020-524a-86d1-829b608c8e6d" "b0b03921-5be5-54ba-af4f-fa4e929dcf92" "7b1410fd-d823-51c2-bca8-e0f838df66a2" "9d0d2db8-fed2-5a4b-92b4-f599b253c959" "89fd3deb-0a2a-5185-9e8e-747d0659ed90" "9b5948b9-1c1c-5de6-9bd0-3e72f92be1d9" "54e3681a-3340-54af-945e-10e286719809" "c6a78920-b768-5c8a-9736-9636b5339ffb" "3a7f7cb6-559e-533d-b984-b9c8986c444e" "4883e2b3-5414-5cde-a20a-2e73bec266a4" "c1721ef0-3e32-5439-98a9-5c49b1d94a0a" "a68fd6ce-b8c7-574f-a784-6c1d82eca65f" "7cfc3a42-90d1-5c8a-b18d-83dc6f45b9c4" "957d8537-b971-5979-ae81-345b239c2165" "b3c99478-5276-5daa-b8ad-20476d51fe29" "e62532a8-ac73-5d28-b4ea-ab92b7dc8641" "b3b4b7bb-5b5e-5b06-b7af-5c397203c2c3" "315c0722-3e0e-519d-976a-12c9cab5eed8" "7e568cd6-db33-5fb8-bf0c-fbafffa06036" "ad0199fc-5bd6-5abb-a490-294e5134de9d" "303e4da5-4596-5fd0-b166-78fbc67ffb8d" "3ea9cb21-e330-5afe-b49e-816be8b70bc0" "fc9aa9e1-91bc-57ea-9f4b-073b4315af28" "1c9d8a23-d740-55fa-9f52-652f4c4c23ce" "010753c4-381d-5f3d-9020-508db8152dc3" "6ededf4e-46d2-5ac1-a21d-c83bdeb8bf9c" "2f7163b6-cfd6-5ce3-8b80-bbb3a4f1b4c1" "ff6d8ffc-4352-5719-b251-a1756f4f1dad" "3f4ba14b-fd39-52cb-b7f9-33972b9eed37" "0e129d76-1ea8-5eb1-b53d-f3c3d96fc3d2" "84340b69-a096-590d-9948-06a71b89e610" "df3c6dbf-9a58-5359-8b04-66b1292fefd2" "0d4920cc-7392-5db0-b1d2-baa88ce36a7e" "57c31bd9-f1a2-5ac9-8ac7-c18fe3a57e5d" "84e15332-c4ad-5b97-9850-fb89c71c3cf7" "480af001-4901-5952-9aa6-4db1cf826c5b" "6dcc4c55-1a71-5d9a-b152-b4dbcd3e49d4" "314639d5-3e02-511a-af9f-b36d1ab27d00" "ded0dc05-e39e-5334-af71-30bdb98acbef" "e3a99100-f7c3-557f-ad76-02e74029f27f" "8bd48cdb-7fb6-53e5-9390-32333b3e6633" "340f0c17-9e46-57fb-923b-55235cbd1a53" "0d971817-673f-530f-a7b3-a80ce76a811e" "d4103b68-4aa4-5333-93e9-5dd350cef5f6" "2c5c71ab-cfe7-584c-8d73-a0d2e012b031" "9fc1ebcf-9f58-526b-9389-8509af229236" "79e31284-22b1-55ae-826c-b71be1dfb8bb" "f735483e-1419-56d7-9ec5-5181419d77b5" "f7cfd45a-58d2-5af1-8544-b8a39f3dbd4b" "f16f7f20-c743-540d-b6b7-d78d66570606" "3a18d9e2-15d8-51fb-8d0a-138b4041f38b" "c5aca954-e1d3-5e1e-9e80-19aa06919806" "a3964299-eaf3-5f96-9a8f-8a5cedb33b5e" "f2bec0b2-44b8-5f6c-91eb-8ed1d5b986ab" "d621fc3d-6069-522a-8118-43c7198a1587" "99441ebd-392e-5ca8-9874-a85b37e580f4" "de8addde-08db-5733-a911-6e47845f6ef9" "0be8be90-28ff-51a6-a105-14ab467250cf" "81c9e6af-1203-5b83-b4a2-76981c8e2b20" "a0246567-c221-558e-9c57-3afbea2ceb4c" "7fdbb43b-8edd-5672-ac2f-488799562f57" "ac7dc19a-49a9-553b-8bab-ceafb518aa96" "0e3803bc-44c2-5768-9d1a-560cd6e753d2" "1f548b74-f4d4-530c-93ce-50a49a3de693" "cc1ff9c3-fbd8-55ef-8dc9-1e01f2ed7015" "e59ca28e-5406-5d5d-81bb-dd70fd9fdba4" "175b635c-1777-545c-8152-4232c4713048" "8939c25f-f2c9-5723-85c5-3bb43278205e" "5e9d76eb-a27a-5dfc-a492-eb1820cc79a4" "b473bc7e-63ac-5204-8a65-4f5ed1142f51" "64d405a3-e9e9-5be8-92db-9419a3a5af18" "244ce2d7-c620-5000-9a61-72a96c19490e" "ab7606bb-572c-584a-89b9-07a73e12720d" "e76ef3ca-3026-50cc-ad2e-e47e419f6faf" "0c372307-3451-5157-89fb-3c1c9303f567" "2c3b7dc0-1751-5244-bf6d-cdc88233bc47" "fdbd8aa5-39a7-5c05-b55d-3a1cf1b4d152" "cac11c60-28f3-53a5-be69-97b04d591eb0" "7f5b8b5c-9d52-5df8-9793-075ea44ada5d" "b0840007-293a-5ae3-9f05-4eac65e5e39d" "18e77ce7-2be6-53ae-8e9a-dfc2cd6e5754" "e682ca86-7368-539f-b396-74bb2c4ef92f" "dcf89510-5217-5a35-809f-83631455599c" "1248c197-8d58-532b-84e3-ad1e3dcbc0d6" "63b80125-2b61-5bf3-9d20-e8b57d5fb359" "a6c25fc3-e805-50ba-8999-a2d2b0217a14" "b3c7e6e1-75b7-54a5-8ea0-e8b0249c3bdf" "9844783d-8693-5cce-a52d-08e408a2249a" "5c5bc65c-9000-5584-b940-cf81c334b3d9" "53a55380-d42b-538e-abad-e8c7938f8193" "b7c12ffc-4881-5775-9a05-fca14c886dd4" "8f30b255-caaa-5a84-b02e-5eca519a869b" "68423cbf-1f2f-5ef8-bff6-d87653413bf5" "62d6a110-4831-5353-8988-bcbfd9e93a88" "9e89ce5d-6c91-53da-ba09-658b69f3c942" "6860b4c1-115b-54c3-8bc0-55072d0f4af6" "79441f73-f739-5b13-b845-918fff99bcfb" "ec4bb7de-80dc-5c30-b8f0-a497e6730e0a" "b64a72f1-0cc4-595b-8859-9d960109ec98" "294b7ae8-a93d-534c-b669-939707065e48" "3080330a-83fa-5324-9f8c-a1bb9282060a" "a07d097e-1fd3-5021-a9f7-4b4226c6ca65" "1d77c117-bc30-591e-94f3-d7492137c5f2" "45ea4626-576c-511b-b053-94bb65f99aa1" "dcac837e-8592-5e61-8e91-56216264eb34" "2f3e9665-a6d4-5769-99f9-b8f63cd14441" "df186641-e574-50cd-82d1-d833843263be" "c3f5a0ca-0bc6-51e0-90dd-ba5808731ecd" "785c4fed-3d73-5a56-ad16-6db21ddb464d" "8af75f51-533a-5f4c-b772-ac9faa4fa3f0" "dd9bf825-dac1-58a4-8b11-2a07a1a0ab68" "99f930d7-f7d2-574d-b98c-7db463e198a8" "7eb3b682-845f-5af9-a043-fa3c753f9ca5" "0ca26042-951c-536a-a1b8-84281f2f048a" "7a711294-d81b-55ea-9565-c8a0b05186cb" "a57ddd85-8da2-5055-8745-bf13870d955c" "dc5c6a76-c4ec-5f37-9f11-bceb0024867a" "b0e54210-29c7-5f03-b87a-26d2ae0476ac" "d7c61c86-3f32-5034-899a-8c790729d2c9" "627c9f35-96ac-5824-a3e6-3c90bca648cd" "6229f159-d932-5bf9-b7e5-07021e04be9a" "d8c114b1-a841-5c76-ad81-00c8fb7298a9" "26043adf-1f24-5c5e-ac33-6037f6bc3a40" "ed27b910-b4e9-57c2-836b-a3554e89f6bb" "29f6ee69-9105-5125-b74a-585978610e31" "75be355e-f1f6-5d1c-b754-d1fb214245bb" "a6c80588-68ea-53ec-8498-134086027875" "5dc18e7d-d4f5-515d-b842-6111d0451622" "337f5e1b-a429-50f2-b868-015b2ea59226" "b8edbb2b-b2c4-5899-aa4a-66f1c1329a3e" "048dc0e1-a1c8-570b-be5b-cf66bb1ab302" "3bf8f34d-ca07-5a82-b69a-9dfd23ec3407" "2a401259-3bde-523f-b751-6d17502666ab" "9fc80c9c-8034-5fd5-bc8d-265af4fcdca2" "9381e668-ead9-5a21-83ab-ba91ab8b2f5c" "8ab16552-f177-58f5-ab1f-0da2544c621b" "b054ba2f-23d3-5fa0-86b1-ad8041cb6dc5" "3dbe4fa0-4f32-5076-9555-319fe57403e1" "1ba38d2c-2639-57c7-920a-1d3566f1c261" "2afd25cb-1d96-569a-9588-c5c0b09123c9" "ae518d18-f802-5f64-ac47-4eb8899d5f22" "8fabc8f7-18f4-545b-86a4-967f16028219" "1b382d62-7d2b-5bfa-974b-8127961e22ae" "1ce9ecec-bd36-590c-a21e-839a5f18239c" "83fd3dc6-0901-5d5d-9478-3f5ed112a1e7" "9ad0ee2a-3063-5619-85a5-b9f9fbd3b3d2" "d41f088f-225e-57d9-a0a1-2ae206152c8f" "62265b35-e5c5-5480-b2ba-dafa5b54ddfb" "d8ccd61c-d462-525e-8bc4-ae74650335a2" "c0a4ede7-c0a3-5d4c-b7cc-7460a5f86c8c" "8ef11f1a-a692-5d7e-9ce5-cc1381acc5dc" "4f3c39ae-d37a-5e5f-91f6-ecca503c6a72" "7d6ddb8a-c0f7-59ed-83e3-03ccf58cf2c6" "a2f7605d-8c67-5090-91ca-d41504c73bec" "ed9177b0-b441-5988-81c1-4281493cb8d9" "a8c2a39b-7d8c-54b0-9ff6-9514fce51265" "cdee9779-2be3-573e-a903-dfa10243ca3a" "f72399f5-fd0e-5be6-9395-60234992b21f" "519f8539-387b-54a5-911e-d29a763c38a8" "e90003a8-2c9e-5ec6-9e46-0a4fa7049af0" "bfd4389a-292b-5168-ae7e-cc9b3fcb896d" "3cd98934-2018-59d2-beb6-9a7d4372ffa5" "de761b27-ff9b-51a9-a680-61277047f692" "48b2ac7d-ebe6-58b8-8f1f-b85111bae8d0" "169bd570-2aee-5a30-9a50-623d6a4bfd1e" "ed333666-8ad2-5e88-9b8b-225cfe3914db" "05d02c34-ac9c-56b2-9e0c-1baaafe6fe95" "b9eaa696-0ca7-5e92-8848-921c764ca587" "75d85393-bd54-5fec-ae33-7e61f0cfb141" "1b4b8fdc-c1ac-5d35-a268-d14438b05f7f" "0a58ffd6-18ef-5dc7-94cf-d150ee441757" "8919522b-1776-54dc-a001-86a85b33ba68" "586631c6-f5d0-52ce-b053-2762eb488a9e" "355ffa61-ae39-5e37-92a3-15ff007b6da9" "7421468e-4568-5258-b691-e132aa605a14" "5cad4657-1dcf-5283-82dd-76836cd091c8" "070450ed-dd37-5f35-b850-709456a30a3b" "2118be1e-f43f-515f-b76e-504c6e8d4024" "dde358a8-99b1-59f3-a792-ed34e1f3788f" "23053317-e486-5d33-a3a2-973aebcce1fc" "3758d8e8-449d-50ce-9bda-aab9186250b5" "fb823c1f-017d-55a4-b496-e9c5e4169355" "b17fadea-4eb2-5a5d-abbf-33d227010eaf" "bd34d7a8-683f-54c2-8bbf-a61d949ecd3b" "19544b1a-af80-5b5f-ac52-635de5a2a60c" "bae51b4f-16a0-568f-bdc2-176824bf139d" "dd8ebe1f-eb12-5bf0-9829-862d892e9d8f" "ed4d2692-8fe0-552d-8a44-8e51bb85f4d7" "72ce17a3-1994-5fe8-bc8e-4ae99330b804" "20f2b3d7-381b-5f1f-b8d4-477de0739026" "07d9f860-d371-585d-b7da-4754bf83d4a4" "2d1a7d20-8d58-521c-aa78-5b1ea90c680d" "91ee3d8c-ec8f-52ea-9bec-eac0c0be6850" "523ac32d-d93c-5ef1-aa7c-d210e3b275fa" "037da304-d55c-5fca-a7dd-36b0efd32a9e" "7cc7c92c-c0ee-5d8b-ac46-61823f2e6641" "f7b569ab-fd26-53a7-bb55-3d9b628b5c58" "31beb633-2d4d-5589-be7f-d12757e716c8" "b57ff4ff-b2bc-501e-b963-d732e268e9da" "8e0f81d0-510e-5192-87b1-d7c44ea5a630" "11bb90bc-4deb-566c-af2d-3dc2803b59db" "7a59a5a6-f4aa-5eb2-8716-f002f0e3c47a" "0b48b56b-18b7-52d5-989b-a01c91032b6b" "d123c370-097e-544c-8fd7-390d7bff1261" "d5ef9118-e331-5098-98e1-0aa4a7823540" "4d8c9fc1-0ec3-538a-9910-189f9578ad02" "28beb7e3-8f02-596e-9d0f-3c182dc96ded" ]
|
||||||||||||||||||||||||||||
|
12.63 ms (7.30%) |
1 |
WITH RECURSIVE related_products (product_id) AS ( SELECT sd.product_id FROM set_details sd INNER JOIN set_detail_machine sdm ON sdm.set_detail_id = sd.id WHERE sdm.machine_id = ? UNION SELECT mpr.product_id FROM machine_product_relations mpr WHERE mpr.machine_id = ? UNION SELECT pr.related_id FROM product_relations pr INNER JOIN related_products rp ON rp.product_id = pr.product_id ) SELECT DISTINCT product_id FROM related_products
Parameters:
[ "7257ea99-e86a-56ab-b56d-e864120c8a54" "7257ea99-e86a-56ab-b56d-e864120c8a54" ]
|
||||||||||||||||||||||||||||
|
1.06 ms (0.61%) |
2 |
SELECT t0.id AS id_1, t0.username AS username_2, t0.email AS email_3, t0.name AS name_4, t0.surname AS surname_5, t0.roles AS roles_6, t0.mobile_phone AS mobile_phone_7, t0.address AS address_8, t0.city AS city_9, t0.zip_code AS zip_code_10, t0.state AS state_11, t0.country AS country_12, t0.price_modifier AS price_modifier_13, t0.password AS password_14, t0.reset_password_token AS reset_password_token_15, t0.locale AS locale_16, t0.double_factor_method AS double_factor_method_17, t0.auth_code AS auth_code_18, t0.google_authenticator_secret AS google_authenticator_secret_19, t0.disabled_at AS disabled_at_20, t0.last_login_at AS last_login_at_21, t0.last_login_ip AS last_login_ip_22, t0.previous_login_at AS previous_login_at_23, t0.previous_login_ip AS previous_login_ip_24, t0.created_at AS created_at_25, t0.updated_at AS updated_at_26 FROM users t0 WHERE t0.id = ?
Parameters:
[
"e1d213a7-a827-410f-8a36-623e68f7991b"
]
|
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
| legacy | doctrine.dbal.legacy_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| App\Entity\Product | 483 |
| App\Entity\ProductImage | 364 |
| App\Entity\ProductImageTranslation | 364 |
| App\Entity\Category | 68 |
| App\Entity\CategoryTranslation | 67 |
| App\Entity\User | 2 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\User | No errors. |
| App\Entity\Product | No errors. |
| App\Entity\ProductImage | No errors. |
| App\Entity\ProductImageTranslation | No errors. |
| App\Entity\ProductLibrary | No errors. |
| App\Entity\Category | No errors. |
| App\Entity\CategoryTranslation | No errors. |
| App\Entity\ProductRelation | No errors. |
| App\Entity\ProductTranslation | No errors. |
| App\Entity\SetDetail | No errors. |