https://dev5.tile.expert/de-at/items/485/1?isFreezed=false&loadAll=0 Return to referer URL

Method
POST
HTTP Status
200
IP
18.213.70.100
Profiled on
Token
7a30ee

Query Metrics

5 Database Queries
5 Different statements
15.49 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

default connection

Time▼ Count Info
10.53 ms
(0.00%) 		1 
SELECT
                a.id,
                a.code,
                a.name,
                a.not_sample,
                a.alternate_name,
                REPLACE(a.file, "~q~", "'") AS FILE,
                a.express_sample,
                a.variant_image,
                a.size_x,
                a.size_y,
                a.size_z,
                a.file_size2_x,
                a.file_size2_y,
                a.file_size3_x,
                a.file_size3_y,
                a.file_size8_x,
                a.file_size8_y,
                a.type_constraint,
                a.packaging_count,
                a.packaging_count_ft,
                a.packaging_count_pc,
                a.price_prx,
                a.pallet,
                a.pallet_ft,
                a.min_order,
                a.m2one_ps,
                a.multiple_pallet,
                a.urla,
                a.background_white,
                a.border_grey,
                a.image_setting,
                a.file_w,
                a.file_h,
                a.file_w4000,
                a.file_h4000,
                a.scheme,
                a.rotate,
                a.file_rotation,
                a.file_edit,
                a.comment_scheme_image,
                a.description_de,
                a.description_en,

                ad.id AS ad_id,
                ad.file AS ad_file,
                ad.picture_in_title AS ad_picture_in_title,
                ad.gtin AS ad_gtin,
                ad.file_size1_x AS ad_file_size1_x,
                ad.file_size1_y AS ad_file_size1_y,
                ad.file_size2_x AS ad_file_size2_x,
                ad.file_size2_y AS ad_file_size2_y,
                ad.file_size3_x AS ad_file_size3_x,
                ad.file_size3_y AS ad_file_size3_y,
                ad.file_size8_x AS ad_file_size8_x,
                ad.file_size8_y AS ad_file_size8_y,
                ad.file_size500_x AS ad_file_size500_x,
                ad.file_size500_y AS ad_file_size500_y,
                ad.file_size740_x AS ad_file_size740_x,
                ad.file_size740_y AS ad_file_size740_y,
                ad.file_size1_x AS ad_file_size1_x,
                ad.file_size1_y AS ad_file_size1_y,
                ad.description_de AS ad_description_de,
                ad.description_en AS ad_description_en,

                ad.comment AS ad_comment,
                ad.file_edit AS ad_file_edit,
                ad.image_setting AS ad_image_setting,
                ad.file_w AS ad_file_w,
                ad.file_h AS ad_file_h,
                ad.file_w4000 AS ad_file_w4000,
                ad.file_h4000 AS ad_file_h4000,
                ad.comment_scheme_image AS ad_comment_scheme_image,
                ad.variant_image AS ad_variant_image,
                ad.file_rotation AS ad_file_rotation,
                ad.rotate AS ad_rotate,
                ad.type_painting AS ad_type_painting,
                ad.big_size_scheme AS ad_big_size_scheme,

                ld.id AS ld_id,
                lt.id AS lt_id,
                lt.alias AS lt_alias,
                lt.name AS lt_name,
                lms.id AS lms_id,
                lms.alias AS lms_alias,
                lms.name AS lms_name,
                lmt.id AS lmt_id,
                lmt.alias AS lmt_alias,
                lmt.name AS lmt_name,
                lsf.id AS lsf_id,
                lsf.alias AS lsf_alias,
                lsf.name AS lsf_name,
                lfc.id AS lfc_id,
                ltx.id AS ltx_id,
                ltx.alias AS ltx_alias,
                ltx.name AS ltx_name,
                ls.id AS ls_id,
                ls.alias AS ls_alias,
                ls.name AS ls_name,
                lsh.id AS lsh_id,
                lsh.alias AS lsh_alias,
                lsh.name AS lsh_name,
                llm.id AS llm_id,
                llm.alias AS llm_alias,
                llm.name AS llm_name,
                lmss.id AS lmss_id,
                lmss.alias AS lmss_alias,
                apd.id AS apd_id,
                apd.amount AS apd_amount,
                apd.amount_ft AS apd_amount_ft,
                apd.fold AS apd_fold,
                acl.id AS acl_id,
                acl.url AS acl_url,
                acl.name AS acl_name,
                acl.alternate_name AS acl_aname,
                acl.status AS acl_status,
                acl.process AS acl_process,
                acl.settings AS acl_settings,
                acf.id AS acf_id,
                acf.url AS acf_url,
                acf.name AS acf_name,
                acf.alternate_name AS acf_aname,
                acf.status AS acf_status,
                acf.suspended AS acf_suspended,
                acf.stated_at AS acf_stated_at,
                a.price_euro_at AS a_price_euro_at, a.price_mq_euro_at AS a_price_mq_euro_at, apd.price_euro_at AS apd_price_euro_at, acl.pr_min_euro_at AS acl_pr_min_euro_at, 
                
                lcnt.id AS lcnt_id,
                lcnt.code AS lcnt_code,
                lcnt.alias AS lcnt_alias,
                lc.id AS lc_id,
                lc.name AS lc_name,
                lc.alias AS lc_alias
            FROM
                article a
            LEFT JOIN list_type lt ON a.type = lt.id
            LEFT JOIN list_delivery ld ON a.delivery = ld.id
            LEFT JOIN list_measure lms ON a.measure = lms.id
            LEFT JOIN list_material lmt ON a.material = lmt.id
            LEFT JOIN list_surface lsf ON a.surface = lsf.id
            LEFT JOIN article_price_discount apd ON a.id = apd.article AND apd.price_usd > 0
            LEFT JOIN article_color ac ON a.id = ac.article_id
            LEFT JOIN list_color lc ON lc.id = ac.color_id
            LEFT JOIN article_factory_color afc ON a.id = afc.article_id
            LEFT JOIN list_factory_color lfc ON lfc.id = afc.factory_color_id
            LEFT JOIN article_texture at ON a.id = at.article_id
            LEFT JOIN list_texture ltx ON ltx.id = at.texture_id
            LEFT JOIN list_style ls ON a.style = ls.id
            LEFT JOIN collection acl ON acl.id = a.collection
            LEFT JOIN factory acf ON acf.id = acl.factory
            LEFT JOIN list_country lcnt ON lcnt.id = acf.country
            LEFT JOIN article_motiv alm ON a.id = alm.article_id
            LEFT JOIN list_motiv llm ON llm.id = alm.motiv_id
            LEFT JOIN list_shape lsh ON lsh.id = a.shape
            LEFT JOIN list_measure_size lmss ON a.measurement_size = lmss.id
            LEFT JOIN article_detail ad         ON ad.article_id = a.id

            
            WHERE a.collection IS NOT NULL AND (a.price_euro > 0 OR a.delivery = 6) AND ld.id <> 6 AND ad.file IS NOT NULL  AND a.collection = '485' AND a.id IN ('11737686','11737760','11737706','11737795','11737833','11737820','11737824','32122305','952804630','388519946','157889105','11737652','11737791','11737693','12534','11737756','11737762','11737620','11737757','11737598','11737575','11737576','11737646','11737708','11737589','11737673','11737670','11737803','11737632','11737665','45483','11737574','11737676','11737653','11737799','11737577','11737629','11737661','11737698','11737692') AND a.id IN ('157889105','388519946','952804630','32122305','11737824','11737760','11737820','11737706','11737762','11737757','11737652','11737670','11737673','11737708','11737632','11737574','11737653','11737698','11737577','11737833') ORDER BY lfc.name ASC, lt.sort DESC, a.size_x DESC, a.size_y DESC, apd.price_euro DESC, apd.amount DESC, a.scheme ASC, lc.id, lms.id, a.thick, a.id DESC
Parameters: 
[]
View formatted query    View runnable query    Explain query
3.35 ms
(0.00%) 		1 
SELECT
                a.id,
                a.code,
                a.name,
                a.not_sample,
                a.alternate_name,
                REPLACE(a.file, "~q~", "'") AS FILE,
                a.express_sample,
                a.variant_image,
                a.size_x,
                a.size_y,
                a.size_z,
                a.file_size2_x,
                a.file_size2_y,
                a.file_size3_x,
                a.file_size3_y,
                a.file_size8_x,
                a.file_size8_y,
                a.type_constraint,
                a.packaging_count,
                a.packaging_count_ft,
                a.packaging_count_pc,
                a.price_prx,
                a.pallet,
                a.pallet_ft,
                a.min_order,
                a.m2one_ps,
                a.multiple_pallet,
                a.urla,
                a.background_white,
                a.border_grey,
                a.image_setting,
                a.file_w,
                a.file_h,
                a.file_w4000,
                a.file_h4000,
                a.scheme,
                a.rotate,
                a.file_rotation,
                a.file_edit,
                a.comment_scheme_image,
                a.description_de,
                a.description_en,

                ad.id AS ad_id,
                ad.file AS ad_file,
                ad.picture_in_title AS ad_picture_in_title,
                ad.gtin AS ad_gtin,
                ad.file_size1_x AS ad_file_size1_x,
                ad.file_size1_y AS ad_file_size1_y,
                ad.file_size2_x AS ad_file_size2_x,
                ad.file_size2_y AS ad_file_size2_y,
                ad.file_size3_x AS ad_file_size3_x,
                ad.file_size3_y AS ad_file_size3_y,
                ad.file_size8_x AS ad_file_size8_x,
                ad.file_size8_y AS ad_file_size8_y,
                ad.file_size500_x AS ad_file_size500_x,
                ad.file_size500_y AS ad_file_size500_y,
                ad.file_size740_x AS ad_file_size740_x,
                ad.file_size740_y AS ad_file_size740_y,
                ad.file_size1_x AS ad_file_size1_x,
                ad.file_size1_y AS ad_file_size1_y,
                ad.description_de AS ad_description_de,
                ad.description_en AS ad_description_en,

                ad.comment AS ad_comment,
                ad.file_edit AS ad_file_edit,
                ad.image_setting AS ad_image_setting,
                ad.file_w AS ad_file_w,
                ad.file_h AS ad_file_h,
                ad.file_w4000 AS ad_file_w4000,
                ad.file_h4000 AS ad_file_h4000,
                ad.comment_scheme_image AS ad_comment_scheme_image,
                ad.variant_image AS ad_variant_image,
                ad.file_rotation AS ad_file_rotation,
                ad.rotate AS ad_rotate,
                ad.type_painting AS ad_type_painting,
                ad.big_size_scheme AS ad_big_size_scheme,

                ld.id AS ld_id,
                lt.id AS lt_id,
                lt.alias AS lt_alias,
                lt.name AS lt_name,
                lms.id AS lms_id,
                lms.alias AS lms_alias,
                lms.name AS lms_name,
                lmt.id AS lmt_id,
                lmt.alias AS lmt_alias,
                lmt.name AS lmt_name,
                lsf.id AS lsf_id,
                lsf.alias AS lsf_alias,
                lsf.name AS lsf_name,
                lfc.id AS lfc_id,
                ltx.id AS ltx_id,
                ltx.alias AS ltx_alias,
                ltx.name AS ltx_name,
                ls.id AS ls_id,
                ls.alias AS ls_alias,
                ls.name AS ls_name,
                lsh.id AS lsh_id,
                lsh.alias AS lsh_alias,
                lsh.name AS lsh_name,
                llm.id AS llm_id,
                llm.alias AS llm_alias,
                llm.name AS llm_name,
                lmss.id AS lmss_id,
                lmss.alias AS lmss_alias,
                apd.id AS apd_id,
                apd.amount AS apd_amount,
                apd.amount_ft AS apd_amount_ft,
                apd.fold AS apd_fold,
                acl.id AS acl_id,
                acl.url AS acl_url,
                acl.name AS acl_name,
                acl.alternate_name AS acl_aname,
                acl.status AS acl_status,
                acl.process AS acl_process,
                acl.settings AS acl_settings,
                acf.id AS acf_id,
                acf.url AS acf_url,
                acf.name AS acf_name,
                acf.alternate_name AS acf_aname,
                acf.status AS acf_status,
                acf.suspended AS acf_suspended,
                acf.stated_at AS acf_stated_at,
                a.price_euro_at AS a_price_euro_at, a.price_mq_euro_at AS a_price_mq_euro_at, apd.price_euro_at AS apd_price_euro_at, acl.pr_min_euro_at AS acl_pr_min_euro_at, 
                
                lcnt.id AS lcnt_id,
                lcnt.code AS lcnt_code,
                lcnt.alias AS lcnt_alias,
                lc.id AS lc_id,
                lc.name AS lc_name,
                lc.alias AS lc_alias
            FROM
                article a
            LEFT JOIN list_type lt ON a.type = lt.id
            LEFT JOIN list_delivery ld ON a.delivery = ld.id
            LEFT JOIN list_measure lms ON a.measure = lms.id
            LEFT JOIN list_material lmt ON a.material = lmt.id
            LEFT JOIN list_surface lsf ON a.surface = lsf.id
            LEFT JOIN article_price_discount apd ON a.id = apd.article AND apd.price_usd > 0
            LEFT JOIN article_color ac ON a.id = ac.article_id
            LEFT JOIN list_color lc ON lc.id = ac.color_id
            LEFT JOIN article_factory_color afc ON a.id = afc.article_id
            LEFT JOIN list_factory_color lfc ON lfc.id = afc.factory_color_id
            LEFT JOIN article_texture at ON a.id = at.article_id
            LEFT JOIN list_texture ltx ON ltx.id = at.texture_id
            LEFT JOIN list_style ls ON a.style = ls.id
            LEFT JOIN collection acl ON acl.id = a.collection
            LEFT JOIN factory acf ON acf.id = acl.factory
            LEFT JOIN list_country lcnt ON lcnt.id = acf.country
            LEFT JOIN article_motiv alm ON a.id = alm.article_id
            LEFT JOIN list_motiv llm ON llm.id = alm.motiv_id
            LEFT JOIN list_shape lsh ON lsh.id = a.shape
            LEFT JOIN list_measure_size lmss ON a.measurement_size = lmss.id
            LEFT JOIN article_detail ad         ON ad.article_id = a.id

            
            WHERE a.collection IS NOT NULL AND (a.price_euro > 0 OR a.delivery = 6) AND ld.id <> 6 AND ad.file IS NOT NULL  AND a.collection = '485' AND a.id IN ('11737686','11737760','11737706','11737795','11737833','11737820','11737824','32122305','952804630','388519946','157889105','11737652','11737791','11737693','12534','11737756','11737762','11737620','11737757','11737598','11737575','11737576','11737646','11737708','11737589','11737673','11737670','11737803','11737632','11737665','45483','11737574','11737676','11737653','11737799','11737577','11737629','11737661','11737698','11737692') AND a.id IN ('157889105') ORDER BY lfc.name ASC, lt.sort DESC, a.size_x DESC, a.size_y DESC, apd.price_euro DESC, apd.amount DESC, a.scheme ASC, lc.id, lms.id, a.thick, a.id DESC
Parameters: 
[]
View formatted query    View runnable query    Explain query
1.26 ms
(0.00%) 		1 
SELECT a0_.`id` AS id_0, b1_.`amount` AS amount_1, b2_.`name` AS name_2, b2_.`status` AS status_3, b2_.`bank_transfer_requested` AS bank_transfer_requested_4 FROM `buy_order` b2_ LEFT JOIN `buy_order_article` b1_ ON b2_.id = b1_.buy_order_id LEFT JOIN `article` a0_ ON b1_.article_id = a0_.id WHERE b2_.`status` IN (1, 2, 3) AND a0_.`id` <> '' AND b2_.`token` = ? AND b2_.`status` <> 12 AND a0_.collection = ? ORDER BY b1_.`amount` DESC
Parameters: 
[
  "6dc67784f7aef4cd31bf90083ab6e05a712fbd0eb975e9aac45eb2f3dae0a3a2"
  485
]
View formatted query    View runnable query    Explain query
0.19 ms
(0.00%) 		1 
SELECT a.id FROM article a LEFT JOIN list_type lt ON a.type = lt.id LEFT JOIN list_delivery ld ON a.delivery = ld.id LEFT JOIN list_measure lms ON a.measure = lms.id LEFT JOIN list_material lmt ON a.material = lmt.id LEFT JOIN list_surface lsf ON a.surface = lsf.id LEFT JOIN article_price_discount apd ON a.id = apd.article AND apd.price_usd > 0 LEFT JOIN article_color ac ON a.id = ac.article_id LEFT JOIN article_factory_color afc ON a.id = afc.article_id LEFT JOIN list_factory_color lfc ON lfc.id = afc.factory_color_id LEFT JOIN article_texture at ON a.id = at.article_id LEFT JOIN list_texture ltx ON ltx.id = at.texture_id LEFT JOIN list_style ls ON a.style = ls.id LEFT JOIN list_color lc ON lc.id = ac.color_id LEFT JOIN collection acl ON acl.id = a.collection LEFT JOIN factory acf ON acf.id = acl.factory LEFT JOIN list_country lcnt ON lcnt.id = acf.country LEFT JOIN article_motiv alm ON a.id = alm.article_id LEFT JOIN list_motiv llm ON llm.id = alm.motiv_id LEFT JOIN list_shape lsh ON lsh.id = a.shape LEFT JOIN article_detail ad ON ad.article_id = a.id WHERE a.collection IS NOT NULL AND (a.price_euro > 0 OR ld.id = 6) AND ld.id <> 6 AND ad.file IS NOT NULL AND a.collection = '485' AND a.id IN ('11737686','11737760','11737706','11737795','11737833','11737820','11737824','32122305','952804630','388519946','157889105','11737652','11737791','11737693','12534','11737756','11737762','11737620','11737757','11737598','11737575','11737576','11737646','11737708','11737589','11737673','11737670','11737803','11737632','11737665','45483','11737574','11737676','11737653','11737799','11737577','11737629','11737661','11737698','11737692') GROUP BY a.id ORDER BY lfc.name ASC, lt.sort DESC, a.size_x DESC, a.size_y DESC, apd.price_euro DESC, apd.amount DESC, a.scheme ASC, lc.id, lms.id, a.thick, a.id DESC LIMIT 1 OFFSET 0
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.16 ms
(0.00%) 		1 
SELECT a.id FROM article a LEFT JOIN list_type lt ON a.type = lt.id LEFT JOIN list_delivery ld ON a.delivery = ld.id LEFT JOIN list_measure lms ON a.measure = lms.id LEFT JOIN list_material lmt ON a.material = lmt.id LEFT JOIN list_surface lsf ON a.surface = lsf.id LEFT JOIN article_price_discount apd ON a.id = apd.article AND apd.price_usd > 0 LEFT JOIN article_color ac ON a.id = ac.article_id LEFT JOIN article_factory_color afc ON a.id = afc.article_id LEFT JOIN list_factory_color lfc ON lfc.id = afc.factory_color_id LEFT JOIN article_texture at ON a.id = at.article_id LEFT JOIN list_texture ltx ON ltx.id = at.texture_id LEFT JOIN list_style ls ON a.style = ls.id LEFT JOIN list_color lc ON lc.id = ac.color_id LEFT JOIN collection acl ON acl.id = a.collection LEFT JOIN factory acf ON acf.id = acl.factory LEFT JOIN list_country lcnt ON lcnt.id = acf.country LEFT JOIN article_motiv alm ON a.id = alm.article_id LEFT JOIN list_motiv llm ON llm.id = alm.motiv_id LEFT JOIN list_shape lsh ON lsh.id = a.shape LEFT JOIN article_detail ad ON ad.article_id = a.id WHERE a.collection IS NOT NULL AND (a.price_euro > 0 OR ld.id = 6) AND ld.id <> 6 AND ad.file IS NOT NULL AND a.collection = '485' AND a.id IN ('11737686','11737760','11737706','11737795','11737833','11737820','11737824','32122305','952804630','388519946','157889105','11737652','11737791','11737693','12534','11737756','11737762','11737620','11737757','11737598','11737575','11737576','11737646','11737708','11737589','11737673','11737670','11737803','11737632','11737665','45483','11737574','11737676','11737653','11737799','11737577','11737629','11737661','11737698','11737692') GROUP BY a.id ORDER BY lfc.name ASC, lt.sort DESC, a.size_x DESC, a.size_y DESC, apd.price_euro DESC, apd.amount DESC, a.scheme ASC, lc.id, lms.id, a.thick, a.id DESC LIMIT 20 OFFSET 0
Parameters: 
[]
View formatted query    View runnable query    Explain query

oneC connection

No database queries were performed.

logs connection

No database queries were performed.

Database Connections

Name Service
default doctrine.dbal.default_connection
oneC doctrine.dbal.oneC_connection
logs doctrine.dbal.logs_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager
oneC doctrine.orm.oneC_entity_manager
logs doctrine.orm.logs_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

default entity manager

Class Mapping errors
WebBundle\Entity\User No errors.
WebBundle\Entity\Article No errors.
WebBundle\Entity\BuyOrder No errors.
WebBundle\Entity\FilterEntity No errors.
WebBundle\Entity\Idea No errors.
WebBundle\Entity\Interior No errors.
WebBundle\Entity\Publication No errors.
WebBundle\Entity\Visit No errors.
WebBundle\Entity\LastUrlEntity No errors.
WebBundle\Entity\Collection No errors.
WebBundle\Entity\ProductReviewsCache No errors.
WebBundle\Entity\ReviewsCache No errors.
WebBundle\Entity\ListCountry No errors.
WebBundle\Entity\Factory No errors.
WebBundle\Entity\CollectionAlsoViewed No errors.
WebBundle\Entity\InteriorHistory No errors.
FlexApp\Entity\ChatB No errors.
FlexApp\Entity\ChatBMessage No errors.
FlexApp\Entity\BoolDBSetting No errors.
FlexApp\Entity\Widget No errors.
FlexApp\Entity\CountryAndLangSpecificDataEntity No errors.
FlexApp\Entity\ConsultantEntity No errors.
WebBundle\Entity\ArticleDetail No errors.
WebBundle\Entity\ListDelivery No errors.
WebBundle\Entity\ListMeasure No errors.
WebBundle\Entity\ListMaterial No errors.
WebBundle\Entity\ArticlePriceDiscount No errors.
WebBundle\Entity\ListFactoryColor No errors.
WebBundle\Entity\ListTexture No errors.
WebBundle\Entity\ListStyle No errors.
WebBundle\Entity\ListSurface No errors.
WebBundle\Entity\ListType No errors.
WebBundle\Entity\ListMotiv No errors.
WebBundle\Entity\ListShape No errors.
WebBundle\Entity\ListMeasureSize No errors.
WebBundle\Entity\ListColor No errors.
FlexApp\Entity\GeoCountryEntity No errors.

oneC entity manager

No loaded entities.

logs entity manager

No loaded entities.