GET https://showcase.payrexx.com/shopware6/public/detail/19178dbb0c244cbd8e3b39ed8877f946

Response
200 OK
IP
47.128.123.109
Profiled on
Token
d97746
id select_type table type possible_keys key key_len ref rows Extra
1 PRIMARY product const PRIMARY PRIMARY 32 const, const 1
1 PRIMARY product.parent const PRIMARY PRIMARY 32 const, const 1
1 PRIMARY product.unit const PRIMARY 1
1 PRIMARY product.deliveryTime const PRIMARY 1
1 PRIMARY product.translation const PRIMARY, fk.product_translation.language_id fk.product_translation.language_id 48 const, const, const 1 Using where
1 PRIMARY product.parent.translation eq_ref PRIMARY, fk.product_translation.language_id PRIMARY 48 const, const, const 1 Using where
1 PRIMARY product.tax eq_ref PRIMARY PRIMARY 16 const 1 Using where
1 PRIMARY product.manufacturer eq_ref PRIMARY PRIMARY 32 const, const 1 Using where
1 PRIMARY product.cover eq_ref PRIMARY PRIMARY 32 const, const 1 Using where
1 PRIMARY product.manufacturer.translation eq_ref PRIMARY, fk.product_manufacturer_translation.language_id PRIMARY 48 showcase_sw6.product.manufacturer.id, showcase_sw6.product.manufacturer.version_id, const 1 Using where
1 PRIMARY product.manufacturer.media eq_ref PRIMARY PRIMARY 16 showcase_sw6.product.manufacturer.media_id 1 Using where
1 PRIMARY product.manufacturer.media.translation eq_ref PRIMARY, fk.media_translation.language_id PRIMARY 32 showcase_sw6.product.manufacturer.media.id, const 1 Using where
1 PRIMARY product.unit.translation eq_ref PRIMARY, fk.unit_translation.language_id PRIMARY 32 const, const 1 Using where
1 PRIMARY product.deliveryTime.translation eq_ref PRIMARY, fk.delivery_time_translation.language_id PRIMARY 32 const, const 1 Using where
1 PRIMARY product.cover.media eq_ref PRIMARY PRIMARY 16 showcase_sw6.product.cover.media_id 1 Using where
1 PRIMARY product.cover.media.translation eq_ref PRIMARY, fk.media_translation.language_id PRIMARY 32 showcase_sw6.product.cover.media.id, const 1 Using where
3 SUBQUERY product.properties.mapping ref PRIMARY PRIMARY 16 const 7 Using index
2 SUBQUERY product.options.mapping ref PRIMARY PRIMARY 16 const 1 Using index