Query Metrics
85
Database Queries
23
Different statements
2324.43 ms
Query time
0
Invalid entities
0
Managed entities
Grouped Statements
default connection
| Time▼ | Count | Info |
|---|---|---|
|
1377.29 ms (59.25%) |
1 |
SELECT DISTINCT SUBSTRING_INDEX(SUBSTRING_INDEX(data, ';', n.digit+1), ';', -1) val, name FROM assets inner join assets_metadata on id=cid INNER JOIN ( SELECT 0 digit UNION ALL SELECT 1 UNION ALL SELECT 2 UNION ALL SELECT 3 UNION ALL SELECT 4 UNION ALL SELECT 5 UNION ALL SELECT 6 ) n ON LENGTH(REPLACE(data, ';' , '')) <= LENGTH(data)-n.digit WHERE id in(145677,2298692,5043329,144674,45705,45608,4975531,4975696,4975701,47224,166817,64868,894638,48550,34064,951095,34350,34323,36898,48660,48601,34061,48397,167163,167190,166714,145768,894666,855715,894667,951936,1571578,2121181,2121230,2298614,2298543,2298489,3587528,4691673,4691695,4691657,4691668,2298571,2298455,2298486,2298556,4975831,4975832,4975834,23887,45637,167283,25846,34076,797561,1295924,1571477,2121217,2121235,2121195,2121240,2121185,2121184,1403980,1403983,1403960,4975498,4975499,1571570,23985,2298714,2298683,2298520,4975398,5185991,64743,46167,34209,48457,747448,4418805,4975459,4975698,4975699,4975700,48389,24012,23997,24015,951074,4780002,1571440,2565373,4691730,4691666,4691660,4691705,4691684,4691728,4691698,4691650,4691671,4691680,4691656,4691649,4691662,4975688,951400,952032,145412,951794,4975447,4975511,4975512,1403972,1403964,4691665,4691700,4975857,5043306,4691725,4691689,4691647,4691664,4691708,48226,47217,45922,64709,5185994,166978,167179,797562,951380,951663,951608,951941,951746,2298554,4779926,4691729,4975581,5043251,5043252,5043253,5043366,797551,797541,951781,951952,951585,4975625,1726795,951201,951471,2121160,4975626,4975488,4975489,166712,166665,167258,1713484,1713485,2298686,34221,34333,144702,145669,34079,35661,34066,45852,23969,45606,34120,23926,2298718,4975705,4975706,4975707,5185953,5185956,5185957,5185958,166613,167247,145706,166586,855744,855772,1098706,2298654,4975788,2121227,26024,167071,167255,25860,23886,23891,144687,167170,167110,166832,34353,772256,797549,855710,951012,951713,951982,1148629,1403969,1403974,1713467,1713503,2121234,2121216,2121190,2121220,1403975,4975500,4975425,4975657,4975833,4975835,5185954,2298731,145863,241742,4975610,4975611,4975846,4975847,1571535,167229,166809,45652,167171,139912,2298521,45649,145261,64994,45891,36224,48421,45648,48687,64725,34351,34087,167313,45489,109787,48578,48492,45677,48551,46242,45911,166829,2121316,141052,167207,1713497,2121206,2121210,166811,2121194,241883,34069,5185950,145093,3587380,108381,139084,48481,45786,951598,951726,951586,951308,5043280,5043281,5043282,1713501,4691703,4975628,951879,4691658,3508181,4418803,4691661,4780024,167192,167234,166598,797555,797546,797564,797557,855650,4975490,5043214,3508188,3508184,3587347,2648458,3508195,4418830,4418632,4418727,855687,146847,34326,36437,167231,147422,951358,167166,167228,166956,109732,4418917,5043239,34338,34321,34059,34354,45583,34081,64956,46031,147460,166744,145071,1713515,167189,855666,139072,951159,894636,4975612,64780,34319,34347,34348,34060,34336,951017,139182,145771,4975429,139706,855813,855736,855696,855757,1295904,1295912,2298434,1295902,1295919,4975619,45721,1098732,166822,166696,166662,1148645,1295909,4418570,4975606,34315,34334,855821,166588,167752,166805,166789,23966,855733,951798,855717,894635,951549,951246,2121212,2298588,4975604,46060,167136,797552,46131,108492,35412,48453,167135,48490,166785,34318,34330,951749,951600,167145,64953,45618,48597,48538,108412,1098724,45876,45930,45726,166607,167253,167030,166716,167225,166813,167239,167768,167315,797543,797558,797547,951453,2298694,2298647,4975487,4975582,45733,45818,48436,48535,45532,47243,45527,145934,2121245,855810,3920909,4975484,4975485,4975548,167050,48391,797537,4975621,4975661,1098704,1098728,1098744,48536,46129,47158,166600,145674,797563,951633,144681,4975820,145807,166940,4975623,147428,108347,952033,951418,139070,4975660,139519,34314,139694,951009,951302,34078,34118,4975841,108424,1713505,4975634,4975636,4975637,1295896,2648465,4975563,4975801,48348,48509,3587613,4975508,4975812,48383,45601,48274,167184,797539,47532,23916,64716,951148,1148598,4975662,4975783,4975805,2298590,4975663,4975848,951348,2298451,4975437,5043229,5043235,5043247,5043248,5043249,5043330,166787,167236,4975743,45560,48630,2298682,4975602,145049,145935,167217,167126,166584,34317,166735,147423,4975804,139188,3587684,1295918,45630,145204,45763,1295907,3587471,141310,208162,48375,48347,48447,145201,167245,208180,855774,855805,855706,855633,855595,2298723,2298636,2298504,167735,4975462,4975744,4975627,4975482,4975494,4975588,4975589,5185934,45996,34340,166820,145867,139399,139076,2200457,45464,4418792,4975579,4975585,4975472,951998,4975412,4975726,4975495,3587627,1295910,4975753,4418758,4975673,4975809,46153,34332,84305,45625,34391,34344,34312,34280,894668,4975690,34328,4975709,4975710,4975711,4975712,4975822,145394,64686,45513,145403,4975682,167054,145703,4418740,45724,4975465,4975466,2298747,2298626,4975825,1713512,1148646,5185970,34337,34068,1713488,1713475,144700,4418810,145404,4975808,4975849,23909,23879,48637,950997,951766,951831,951929,2298759,2298468,2298540,2298563,2298472,2298471,4418856,4975639,2121249,2121253,2298632,2298482,2298559,48396,45735,167763,48183,64720,145732,4975824,4975810,146705,952026,4418890,1713533,4975566,4975837,4975813,34176,34073,34052,145087,145422,145805,64928,46028,23907,145727,23874,1833228,951587,951812,4975539,4975598,4975779,4975789,5043353,951870,4975521,951989,951395,951655,951688,4975537,4975538,4975653,166967,2648494,4975616,4975650,4975651,4975652,855603,855803,45499,48742,45589,5185940,166726,35446,34313,951851,4975509,5043389,4975665,4975727,167233,48339,4975507,48561,139763,4975464,951424,45545,166720,951235,167269,167113,951649,167061,951988,145650,1571499,2121231,2121213,167747,166710,167776,166952,45679,951434,4975533,139282,951085,48450,797554,145166,139914,241800,951361,145091,34311,145861,2298539,166582,145675,166694,2121248,2121166,4975457,144676,1148574,1148578,1148559,1148543,2565369,4418673,241811,5112743,951163,4975689,4975685,45671,45742,48459,4975732,4691710,4691701,4691707,4691653,4691724,4691696,4691702,5043315,5043319,4975406,5043311,5043313,5185929,951536,2298500,2298711,2565351,4691672,4975738,5043213,5043215,5043314,5043317,5043318,5043320,4975570,747518,4975814,1571534,4975811,1463743,4975473,4975584,4363270,5486102,4363272,166593,145640,797553,2298552,1148586,45985,64856,34281,5185960,5185962,4975449,166733,4975742,4975764,2298690,2298756,2298605,34320,2298744,167173,167740,951656,1713478,4691714,4691652,4975448,4975787,4975791,5043368,5043369,48522,4975503,48479,2298678,2298453,2298651,2298608,4975792,5043341,145762,4418686,4975451,4975728,5043371,145164,4418871,48501,4975807,2298725,2121244,46149,1295920,4975551,4975823,241791,145103,5185961,894640,4691706,4691719,4975403,4975683,4975844,4975845,951800,951658,2121218,4975469,4975724,951847,2298708,2298596,2298427,4975557,1833207,241828,147432,145798,951271,951082,2121188,4975601,241852,64927,26043,34121,147418,139401,48456,34374,109823,47686,48628,45991,64560,951181,2121221,2121163,2121229,2121173,2121178,5043226,5043227,5043258,5043259,5043260,5043332,5043333,5422404,5422407,5422409,5422411,5422413,5422415,5422420,5422425,5422430,5422432,5422435,951139,951682,951134,951647,1463834,2121226,2298562,4975504,4975666,4975745,5043196,5043197,5043198,3508168,3508202,951817,4975583,5043263,5043292,5185951,855683,3587273,1403953,1403956,1403981,1403965,4418671,5043275,5043276,3508176,4975730,5043153,5422437,34075,241858,166690,36271,35588,34056,34364,34048,2298712,3587592,4418866,4975746,4977451,4977453,4977458,4977460,5043377,1713535,166707,34071,855605,950995,5422343,5422346,5422349,5422352,5422354,5422356,5422358,5422360,5422363,5422366,5422369,5422372,5422374,5486103,5486104,5486105,5486106,5486107,5486108,5486109,3587507,3587290,166596,3508193,5185947,5185948,145644,34153,34339,3587376,3587404,4418683,139917,108360,46173,4418899,1713499,145413,167263,108375,48515,4975840,48614,46048,65000,48445,2121197,2298446,2298745,4975405,2298774,4975560,4975561,4975522,4975523,4975524,4975526,4975527,4975731,4975735,952048,2121252,4975617,4975654,4975736,951030,1148628,4975719,2121183,4975474,4975559,4691692,4691677,4691681,5043335,5043336,951250,3587594,4691715,4691686,4691712,4691722,4691648,4975515,4975545,4975595,4975729,5185989,2121196,1463827,1463835,952049,4975470,4975649,167210,2298514,951793,951716,951222,797566,2298648,2298447,4574054,4574057,4574058,4975453,4975454,4975455,4975778,5043149,5043150,5043151,5043152,5043203,5043204,5043205,2298458,2298460,4975460,5043262,4975587,4975750,2298685,2298760,2121215,2298657,4975773,5043221,5043222,5043223,5043224,5185931,1571533,241721,3508166,3508192,4975752,4975552,4418815,4975686,5043373,1463836,1046054,1463740,1463829,4975687,417942,1463828,2121239,2121179,2121177,2121236,4975577,4975655,4975656,4975658,4975659,4975740,3920916,4975737,5043200,5043201,5043272,2121238,2121186,2121241,4975571,34070,185594,185598,185593,1148591,34084,34050,951438,951097,951617,951324,1148599,1148572,1148568,2298665,2298623,4975597,34232,242059,145194,167158,4975549,5043300,4975806,4363275,4975399,4975450,951972,3508185,5185972,5185974,5185976,951299,2121251,2121233,2298650,4975481,4975599,5043267,4975644,5043375,4975476,4975677,4975678,4977216,4977217,2298671,4975646,4975642,4418777,4418942,4975535,4975477,4975722,4975828,4975850,2121222,4975635,4975671,4975534,4975829,4975679,4975520,4975493,4975573,4975669,4975546,4975751,4975827,4975674,167067,145417,139185,2121192,4975513,2121225,4975782,951796,3587618,3587316,3587564,951905,4975540,166676,951842,145937,2121219,3508161,951002,34074,4975684,3587388,4975496,5043207,5043208,5043209,5043210,5043211,5112745,5112746,5112747,5185964,3587557,4975572,1571472,1098745,4975438,5043270,5043370,5043372,5185966,2121242,2121214,4975733,4975574,4975721,5486084,4975769,4975519,4975725,4975667,4975590,4418744,4975591,3508199,4691721,4975418,5043302,5043303,3920908,3920903,3920904,4975514,4975749,5185936,5422418,5422423,5422427,1833219,1833225,1148597,1148603,1148529,1148640,5043278,2298722,4975747,4975748,4975803,5043350,3508163,3508200,3508160,4975668,2449973,4975647,4975478,4975479,4975516,4975629,5043288,5043348,4975422,4975643,2121175,2121205,4975786,5043363,5043364,2121232,2200456,4975414,3587490,4975506,4975567,5043277,5185729,4975568,4975802,4975675,4975600,4975800,5185955,3508173,3508174,3508190,5043323,5043326,5486093,5043219,951720,4975475,4975734,5043256,2298523,4975718,3508189,3508171,3587523,1148547,1148601,4975723,4975780,4691676,4975772,5043238,5043245,5185965,4975818,2449969,4975578,2121224,2121208,4975739,4975404,4975676,4975645,4975427,4975777,4975770,4975771,4975505,4975720,4975423,4975517,4975631,4975632,4975424,4975502,4975593,4975501,4975592,4975562,5043356,5043358,5043360,4975774,4975518,4975415,2298477,2298494,4975547,5043284,4975776,4975443,4975648,4975575,4975480,4975630,4975775,5185986,4975426,4975680,3508191,4975681,4975525,3508182,4975768,4975510,64739,4779880,4780055,4975633,4779878,5185979,5185982,4779883,4975395,4975396,5186010,5185745,4975409,4975445,4975528,4975529,145648,48686,4975394,4975408,4780025,4975407,4975446,4975397,4975419,4975420,4975413,3508183,3508180,4975428,4975416,4975430,4975417,4975410,4975411,3508196,4975402,4975401,4975400,4975421,3508170,4975532,4975444,5043183,5043194,5185737,5043193,5185733,5486095,5043167,5422376,5043158,5043192,5043413,5043164,5043179,5043173,5422385,5043169,5043176,5043154,5043217,5043155,5043161,5185760,5186013,5486082,5185735,5185756,5185748,5185753,5486078,5185742,5185724,5185727,5486080,5185942,5185943,5185944,5185945,5185996,5185999,5186001,5186003,5186005,5186007,5486075,5422399,5422380,5486099,5486086,5486088,5486089,5486097,5486071,5486073,5486101,5422394,5486069,5422389) and (name='cf_product_family_wd' or name='cf_region' or name='cf_segment_wd' or name='cf_mounting_wd') and (language=?) ORDER BY name, data;
Parameters:
[
"de"
]
|
|
616.66 ms (26.53%) |
1 |
select distinct SUBSTRING_INDEX(SUBSTRING_INDEX(SUBSTRING_INDEX(projectImages, ',', n.digit + 1), ',', -1), '|', -1) val from object_query_prod INNER JOIN (SELECT 0 digit UNION ALL SELECT 1 UNION ALL SELECT 2 UNION ALL SELECT 3 UNION ALL SELECT 4 UNION ALL SELECT 5 UNION ALL SELECT 6 UNION ALL SELECT 7 UNION ALL SELECT 8 UNION ALL SELECT 9 UNION ALL SELECT 10 UNION ALL SELECT 11 UNION ALL SELECT 12 UNION ALL SELECT 13 UNION ALL SELECT 14 UNION ALL SELECT 15 UNION ALL SELECT 16 UNION ALL SELECT 17 UNION ALL SELECT 18 UNION ALL SELECT 19 UNION ALL SELECT 20 UNION ALL SELECT 21 UNION ALL SELECT 22 UNION ALL SELECT 23 UNION ALL SELECT 24 UNION ALL SELECT 25 UNION ALL SELECT 26 UNION ALL SELECT 27 UNION ALL SELECT 28 UNION ALL SELECT 29 UNION ALL SELECT 30 UNION ALL SELECT 31 UNION ALL SELECT 32 UNION ALL SELECT 33 UNION ALL SELECT 34 UNION ALL SELECT 35 UNION ALL SELECT 36 UNION ALL SELECT 37 UNION ALL SELECT 38 UNION ALL SELECT 39 UNION ALL SELECT 40) n ON LENGTH(REPLACE(projectImages, ',', '')) <= LENGTH(projectImages) - n.digit where projectImages is not null and lifecycle = 'active';
Parameters:
[] |
|
171.04 ms (7.36%) |
1 |
SELECT distinct filename, path, id, upper(trim(replace(replace(replace(replace(am0.data, ' ', ';'),';','|'),',','|'),'| ','|'))) as 'lines' from assets inner join assets_metadata am0 on id = am0.cid where am0.name='cf_used_products' and path like '%/projects/%' and am0.language IN (?, ?) and id in(145677,2298692,5043329,144674,45705,45608,4975531,4975696,4975701,47224,166817,64868,894638,48550,34064,951095,34350,34323,36898,48660,48601,34061,48397,167163,167190,166714,145768,894666,855715,894667,951936,1571578,2121181,2121230,2298614,2298543,2298489,3587528,4691673,4691695,4691657,4691668,2298571,2298455,2298486,2298556,4975831,4975832,4975834,23887,45637,167283,25846,34076,797561,1295924,1571477,2121217,2121235,2121195,2121240,2121185,2121184,1403980,1403983,1403960,4975498,4975499,1571570,23985,2298714,2298683,2298520,4975398,5185991,64743,46167,34209,48457,747448,4418805,4975459,4975698,4975699,4975700,48389,24012,23997,24015,951074,4780002,1571440,2565373,4691730,4691666,4691660,4691705,4691684,4691728,4691698,4691650,4691671,4691680,4691656,4691649,4691662,4975688,951400,952032,145412,951794,4975447,4975511,4975512,1403972,1403964,4691665,4691700,4975857,5043306,4691725,4691689,4691647,4691664,4691708,48226,47217,45922,64709,5185994,166978,167179,797562,951380,951663,951608,951941,951746,2298554,4779926,4691729,4975581,5043251,5043252,5043253,5043366,797551,797541,951781,951952,951585,4975625,1726795,951201,951471,2121160,4975626,4975488,4975489,166712,166665,167258,1713484,1713485,2298686,34221,34333,144702,145669,34079,35661,34066,45852,23969,45606,34120,23926,2298718,4975705,4975706,4975707,5185953,5185956,5185957,5185958,166613,167247,145706,166586,855744,855772,1098706,2298654,4975788,2121227,26024,167071,167255,25860,23886,23891,144687,167170,167110,166832,34353,772256,797549,855710,951012,951713,951982,1148629,1403969,1403974,1713467,1713503,2121234,2121216,2121190,2121220,1403975,4975500,4975425,4975657,4975833,4975835,5185954,2298731,145863,241742,4975610,4975611,4975846,4975847,1571535,167229,166809,45652,167171,139912,2298521,45649,145261,64994,45891,36224,48421,45648,48687,64725,34351,34087,167313,45489,109787,48578,48492,45677,48551,46242,45911,166829,2121316,141052,167207,1713497,2121206,2121210,166811,2121194,241883,34069,5185950,145093,3587380,108381,139084,48481,45786,951598,951726,951586,951308,5043280,5043281,5043282,1713501,4691703,4975628,951879,4691658,3508181,4418803,4691661,4780024,167192,167234,166598,797555,797546,797564,797557,855650,4975490,5043214,3508188,3508184,3587347,2648458,3508195,4418830,4418632,4418727,855687,146847,34326,36437,167231,147422,951358,167166,167228,166956,109732,4418917,5043239,34338,34321,34059,34354,45583,34081,64956,46031,147460,166744,145071,1713515,167189,855666,139072,951159,894636,4975612,64780,34319,34347,34348,34060,34336,951017,139182,145771,4975429,139706,855813,855736,855696,855757,1295904,1295912,2298434,1295902,1295919,4975619,45721,1098732,166822,166696,166662,1148645,1295909,4418570,4975606,34315,34334,855821,166588,167752,166805,166789,23966,855733,951798,855717,894635,951549,951246,2121212,2298588,4975604,46060,167136,797552,46131,108492,35412,48453,167135,48490,166785,34318,34330,951749,951600,167145,64953,45618,48597,48538,108412,1098724,45876,45930,45726,166607,167253,167030,166716,167225,166813,167239,167768,167315,797543,797558,797547,951453,2298694,2298647,4975487,4975582,45733,45818,48436,48535,45532,47243,45527,145934,2121245,855810,3920909,4975484,4975485,4975548,167050,48391,797537,4975621,4975661,1098704,1098728,1098744,48536,46129,47158,166600,145674,797563,951633,144681,4975820,145807,166940,4975623,147428,108347,952033,951418,139070,4975660,139519,34314,139694,951009,951302,34078,34118,4975841,108424,1713505,4975634,4975636,4975637,1295896,2648465,4975563,4975801,48348,48509,3587613,4975508,4975812,48383,45601,48274,167184,797539,47532,23916,64716,951148,1148598,4975662,4975783,4975805,2298590,4975663,4975848,951348,2298451,4975437,5043229,5043235,5043247,5043248,5043249,5043330,166787,167236,4975743,45560,48630,2298682,4975602,145049,145935,167217,167126,166584,34317,166735,147423,4975804,139188,3587684,1295918,45630,145204,45763,1295907,3587471,141310,208162,48375,48347,48447,145201,167245,208180,855774,855805,855706,855633,855595,2298723,2298636,2298504,167735,4975462,4975744,4975627,4975482,4975494,4975588,4975589,5185934,45996,34340,166820,145867,139399,139076,2200457,45464,4418792,4975579,4975585,4975472,951998,4975412,4975726,4975495,3587627,1295910,4975753,4418758,4975673,4975809,46153,34332,84305,45625,34391,34344,34312,34280,894668,4975690,34328,4975709,4975710,4975711,4975712,4975822,145394,64686,45513,145403,4975682,167054,145703,4418740,45724,4975465,4975466,2298747,2298626,4975825,1713512,1148646,5185970,34337,34068,1713488,1713475,144700,4418810,145404,4975808,4975849,23909,23879,48637,950997,951766,951831,951929,2298759,2298468,2298540,2298563,2298472,2298471,4418856,4975639,2121249,2121253,2298632,2298482,2298559,48396,45735,167763,48183,64720,145732,4975824,4975810,146705,952026,4418890,1713533,4975566,4975837,4975813,34176,34073,34052,145087,145422,145805,64928,46028,23907,145727,23874,1833228,951587,951812,4975539,4975598,4975779,4975789,5043353,951870,4975521,951989,951395,951655,951688,4975537,4975538,4975653,166967,2648494,4975616,4975650,4975651,4975652,855603,855803,45499,48742,45589,5185940,166726,35446,34313,951851,4975509,5043389,4975665,4975727,167233,48339,4975507,48561,139763,4975464,951424,45545,166720,951235,167269,167113,951649,167061,951988,145650,1571499,2121231,2121213,167747,166710,167776,166952,45679,951434,4975533,139282,951085,48450,797554,145166,139914,241800,951361,145091,34311,145861,2298539,166582,145675,166694,2121248,2121166,4975457,144676,1148574,1148578,1148559,1148543,2565369,4418673,241811,5112743,951163,4975689,4975685,45671,45742,48459,4975732,4691710,4691701,4691707,4691653,4691724,4691696,4691702,5043315,5043319,4975406,5043311,5043313,5185929,951536,2298500,2298711,2565351,4691672,4975738,5043213,5043215,5043314,5043317,5043318,5043320,4975570,747518,4975814,1571534,4975811,1463743,4975473,4975584,4363270,5486102,4363272,166593,145640,797553,2298552,1148586,45985,64856,34281,5185960,5185962,4975449,166733,4975742,4975764,2298690,2298756,2298605,34320,2298744,167173,167740,951656,1713478,4691714,4691652,4975448,4975787,4975791,5043368,5043369,48522,4975503,48479,2298678,2298453,2298651,2298608,4975792,5043341,145762,4418686,4975451,4975728,5043371,145164,4418871,48501,4975807,2298725,2121244,46149,1295920,4975551,4975823,241791,145103,5185961,894640,4691706,4691719,4975403,4975683,4975844,4975845,951800,951658,2121218,4975469,4975724,951847,2298708,2298596,2298427,4975557,1833207,241828,147432,145798,951271,951082,2121188,4975601,241852,64927,26043,34121,147418,139401,48456,34374,109823,47686,48628,45991,64560,951181,2121221,2121163,2121229,2121173,2121178,5043226,5043227,5043258,5043259,5043260,5043332,5043333,5422404,5422407,5422409,5422411,5422413,5422415,5422420,5422425,5422430,5422432,5422435,951139,951682,951134,951647,1463834,2121226,2298562,4975504,4975666,4975745,5043196,5043197,5043198,3508168,3508202,951817,4975583,5043263,5043292,5185951,855683,3587273,1403953,1403956,1403981,1403965,4418671,5043275,5043276,3508176,4975730,5043153,5422437,34075,241858,166690,36271,35588,34056,34364,34048,2298712,3587592,4418866,4975746,4977451,4977453,4977458,4977460,5043377,1713535,166707,34071,855605,950995,5422343,5422346,5422349,5422352,5422354,5422356,5422358,5422360,5422363,5422366,5422369,5422372,5422374,5486103,5486104,5486105,5486106,5486107,5486108,5486109,3587507,3587290,166596,3508193,5185947,5185948,145644,34153,34339,3587376,3587404,4418683,139917,108360,46173,4418899,1713499,145413,167263,108375,48515,4975840,48614,46048,65000,48445,2121197,2298446,2298745,4975405,2298774,4975560,4975561,4975522,4975523,4975524,4975526,4975527,4975731,4975735,952048,2121252,4975617,4975654,4975736,951030,1148628,4975719,2121183,4975474,4975559,4691692,4691677,4691681,5043335,5043336,951250,3587594,4691715,4691686,4691712,4691722,4691648,4975515,4975545,4975595,4975729,5185989,2121196,1463827,1463835,952049,4975470,4975649,167210,2298514,951793,951716,951222,797566,2298648,2298447,4574054,4574057,4574058,4975453,4975454,4975455,4975778,5043149,5043150,5043151,5043152,5043203,5043204,5043205,2298458,2298460,4975460,5043262,4975587,4975750,2298685,2298760,2121215,2298657,4975773,5043221,5043222,5043223,5043224,5185931,1571533,241721,3508166,3508192,4975752,4975552,4418815,4975686,5043373,1463836,1046054,1463740,1463829,4975687,417942,1463828,2121239,2121179,2121177,2121236,4975577,4975655,4975656,4975658,4975659,4975740,3920916,4975737,5043200,5043201,5043272,2121238,2121186,2121241,4975571,34070,185594,185598,185593,1148591,34084,34050,951438,951097,951617,951324,1148599,1148572,1148568,2298665,2298623,4975597,34232,242059,145194,167158,4975549,5043300,4975806,4363275,4975399,4975450,951972,3508185,5185972,5185974,5185976,951299,2121251,2121233,2298650,4975481,4975599,5043267,4975644,5043375,4975476,4975677,4975678,4977216,4977217,2298671,4975646,4975642,4418777,4418942,4975535,4975477,4975722,4975828,4975850,2121222,4975635,4975671,4975534,4975829,4975679,4975520,4975493,4975573,4975669,4975546,4975751,4975827,4975674,167067,145417,139185,2121192,4975513,2121225,4975782,951796,3587618,3587316,3587564,951905,4975540,166676,951842,145937,2121219,3508161,951002,34074,4975684,3587388,4975496,5043207,5043208,5043209,5043210,5043211,5112745,5112746,5112747,5185964,3587557,4975572,1571472,1098745,4975438,5043270,5043370,5043372,5185966,2121242,2121214,4975733,4975574,4975721,5486084,4975769,4975519,4975725,4975667,4975590,4418744,4975591,3508199,4691721,4975418,5043302,5043303,3920908,3920903,3920904,4975514,4975749,5185936,5422418,5422423,5422427,1833219,1833225,1148597,1148603,1148529,1148640,5043278,2298722,4975747,4975748,4975803,5043350,3508163,3508200,3508160,4975668,2449973,4975647,4975478,4975479,4975516,4975629,5043288,5043348,4975422,4975643,2121175,2121205,4975786,5043363,5043364,2121232,2200456,4975414,3587490,4975506,4975567,5043277,5185729,4975568,4975802,4975675,4975600,4975800,5185955,3508173,3508174,3508190,5043323,5043326,5486093,5043219,951720,4975475,4975734,5043256,2298523,4975718,3508189,3508171,3587523,1148547,1148601,4975723,4975780,4691676,4975772,5043238,5043245,5185965,4975818,2449969,4975578,2121224,2121208,4975739,4975404,4975676,4975645,4975427,4975777,4975770,4975771,4975505,4975720,4975423,4975517,4975631,4975632,4975424,4975502,4975593,4975501,4975592,4975562,5043356,5043358,5043360,4975774,4975518,4975415,2298477,2298494,4975547,5043284,4975776,4975443,4975648,4975575,4975480,4975630,4975775,5185986,4975426,4975680,3508191,4975681,4975525,3508182,4975768,4975510,64739,4779880,4780055,4975633,4779878,5185979,5185982,4779883,4975395,4975396,5186010,5185745,4975409,4975445,4975528,4975529,145648,48686,4975394,4975408,4780025,4975407,4975446,4975397,4975419,4975420,4975413,3508183,3508180,4975428,4975416,4975430,4975417,4975410,4975411,3508196,4975402,4975401,4975400,4975421,3508170,4975532,4975444,5043183,5043194,5185737,5043193,5185733,5486095,5043167,5422376,5043158,5043192,5043413,5043164,5043179,5043173,5422385,5043169,5043176,5043154,5043217,5043155,5043161,5185760,5186013,5486082,5185735,5185756,5185748,5185753,5486078,5185742,5185724,5185727,5486080,5185942,5185943,5185944,5185945,5185996,5185999,5186001,5186003,5186005,5186007,5486075,5422399,5422380,5486099,5486086,5486088,5486089,5486097,5486071,5486073,5486101,5422394,5486069,5422389) order by creationdate desc limit 0, 16;
Parameters:
[
"de"
""
]
|
|
58.74 ms (2.53%) |
1 |
select distinct path, filename, upper(linename) as linename, mainImage, oo_id from assets inner join object_query_prod on id = mainImage where lifecycle='active' and upper(linename) rlike ? order by mainProductInLine desc;
Parameters:
[
"DEEP BIJOU 2.0|WETRO 2.0|TRADORA IP65 1.0|CLASCO 1.0|TRADORA SUSPENDED IP65 1.0|MATCH TABLE 1.0|CENO SURFACE 4.1|ODREY ON TRACK 1.3|DOMY ON STREX 1.0|STRIPE SLIM 1.4|PAVIO IP65 1.0|RONY PETIT 1.0|LARRA OPAL 1.0|LARRA OPAL 2.0|LINOO 4.1|RAY SUSPENDED MINI 5.0|PILLO 1.0|LECA SNOOZE 1.0|PILLO ON TRACK 1.0"
]
|
|
15.69 ms (0.67%) |
8 |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "BUNDLE_INSTALLED__Pimcore\Bundle\SeoBundle\PimcoreSeoBundle" "pimcore" ] |
|
13.99 ms (0.60%) |
8 |
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
4574046
]
|
|
11.53 ms (0.50%) |
12 |
SELECT id,language FROM documents_translations WHERE sourceId = ? UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
Parameters:
[ 2237 2237 ] |
|
10.13 ms (0.44%) |
7 |
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
2237
]
|
|
8.24 ms (0.35%) |
6 |
SELECT * FROM redirects WHERE ( (source = ? AND (`type` = ? OR `type` = ?)) OR (source = ? AND `type` = ?) OR (source = ? AND `type` = ?) ) AND active = 1 AND (regex IS NULL OR regex = 0) AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND (sourceSite IS NULL OR sourceSite = 0) AND priority = 99 ORDER BY `priority` DESC
Parameters:
[ "/_fragment" "path" "auto_create" "/_fragment?_path=_locale=de&_format=html&_controller=App%5CController%5CSnippetController%3A%3AheaderAction" "path_query" "https://testing.weverducre.com/_fragment?_path=_locale=de&_format=html&_controller=App%5CController%5CSnippetController%3A%3AheaderAction" "entire_uri" ] |
|
6.89 ms (0.30%) |
6 |
SELECT name FROM classes WHERE id = ?
Parameters:
[
"SCONF"
]
|
|
5.42 ms (0.23%) |
1 |
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[ "/weverducre.com/de/" "gallery" ] |
|
4.85 ms (0.21%) |
1 |
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
"maintenance_mode"
]
|
|
4.64 ms (0.20%) |
8 |
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
Parameters:
[
4574046
]
|
|
3.98 ms (0.17%) |
1 |
SELECT * FROM object_url_slugs WHERE slug = '/de/gallery' AND (siteId = 1 OR siteId = 0) ORDER BY siteId DESC LIMIT 1
Parameters:
[] |
|
3.05 ms (0.13%) |
1 |
SELECT * FROM redirects WHERE ( (source = ? AND (`type` = ? OR `type` = ?)) OR (source = ? AND `type` = ?) OR (source = ? AND `type` = ?) ) AND active = 1 AND (regex IS NULL OR regex = 0) AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND (sourceSite IS NULL OR sourceSite = 1) AND priority = 99 ORDER BY `priority` DESC
Parameters:
[ "/de/gallery" "path" "auto_create" "/de/gallery" "path_query" "https://testing.weverducre.com/de/gallery" "entire_uri" ] |
|
2.77 ms (0.12%) |
7 |
SELECT * FROM sites WHERE rootId = ?
Parameters:
[
2
]
|
|
2.07 ms (0.09%) |
5 |
SELECT documents.id, documents.type FROM documents WHERE (parentId = ?) AND published = 1 ORDER BY `index` ASC
Parameters:
[
120
]
|
|
2.00 ms (0.09%) |
1 |
SELECT object_localized_8_de.id as id, object_localized_8_de.type as `type` FROM object_localized_8_de WHERE ( object_localized_8_de.type IN ('object','variant','folder')) AND object_localized_8_de.published = 1
Parameters:
[] |
|
1.42 ms (0.06%) |
2 |
SELECT id,language FROM documents_translations WHERE sourceId IN(?, ?) UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
Parameters:
[ 2217 2237 2237 ] |
|
1.18 ms (0.05%) |
2 |
SELECT sourceId FROM documents_translations WHERE id = ?
Parameters:
[
2237
]
|
|
0.98 ms (0.04%) |
1 |
SELECT * FROM object_relations_SCONF WHERE src_id = ?
Parameters:
[
1547
]
|
|
0.94 ms (0.04%) |
2 |
SELECT * FROM translations_admin LIMIT 1;
Parameters:
[] |
|
0.92 ms (0.04%) |
2 |
SELECT * FROM translations_messages LIMIT 1;
Parameters:
[] |
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
| ax | doctrine.dbal.ax_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 |
|---|
Entities Mapping
No loaded entities.