23M. I’ve never been a super social guy. I’ve always been shy, chronic low-grade depression, etc., and it hasn’t been conducive to making friends.
I had one irl friend who I met at a job four years ago. We were hanging out more frequently and getting closer at the start of this year, but I found out something so fucked up about him a month and a half ago that I was pretty much forced to completely stop talking to him.
I had one online friend, and I was very close with her for two years. She completely moved on from me a few weeks ago, and she made it clear to me a few weeks ago that I was useful for a certain time in her life, but now I’m not useful to her anymore, so she’s moved on with new irl friends who she just recently met.
After over a year of applying and interviewing, I got an office job in November of 2022. I was getting a lot of positive feedback, wasn’t screwing up any tasks, etc., but I was suddenly fired without a clear reason two weeks ago. I don’t have enough experience to reliably know if I’ll be able to get another job in the same field.
I don’t have a job. I have literally no one to talk to, not even just an acquaintance or cousin. I don’t talk to anyone from any of the schools I went to, no one from any of the jobs I’ve had, and none of my extended family (family drama from a decade ago screwed everything up). My parents turned into raging alcoholics six years ago, so I mostly avoid them. I tried making friends at the most recent job I had, but I don’t think any of them really liked me, tbh. My family used to have family friends who would visit, and we would just do different things together in general, but we don’t do shit since they became raging alcoholics.
Idek if it’s possible to recover from this level of isolation. There’s literally nothing in my life. I’ve went through almost 24 years of life, and I somehow don’t even have a single acquaintance to show for it, not a single person to talk to or who genuinely cares about me.

Even if you think 95% cases in India are not reported still per capita rape cases are higher in USA.

What in my opinion makes it worse is victim blaming.

US also has a victim blaming going on specially in their college campuses.

In the US, a video recording of the crime can be, and is used as evidence in the court. While in India, a video recording is used to shame and silence the victim.

Also how are you comparing how law acts on video evidence in US with how public reacts on video evidence?
Is this not textbook example of false comparison? Considering law should be compared with law and people with people?

I remember how a while ago, name of the rape victim was among the highest searched terms on a porn site. Shameful is a rather soft term for this. Each time the news of a rape makes headlines, along comes a sexist remark from a party leader.

Unfortunately same things happen in US as well. It's just that their population is not high enough to make them reach number one on search list.
Plus they don't report on rapes like we do, so knowledge of a rape case never goes outside the city in most cases for them.
Here, we know about rapes happening 1000 km away from us. (Which in my opinion is a good thing. US media houses care more about image management of the country than their own citizen's safety making them worse than trash.)

I don't know much about the politics around sexual crimes in the US, but I can safely say that the chances that a victim gets justice and leads a comparatively normal life without judgements from peers is higher in the US.

I don't know anything about a country but I will say using my inferiority complex that US is better. This is what this statement looks like.

That being said, this is a horrible crime and not something to compete about. The number must be zero both in India and around the world.

Then preach it to the US idiots filled with superiority complex before coming here. Why is it that preachers always try to persuade the retaliators and not the aggressors?

Just wondering, where do you think rape cases get more unreported? India or America?

I gave you detailed answer of this question with data but I didn't knew your pea sized brain was unable to process this data.

how america define rape

https://www.justice.gov/archives/opa/blog/updated-definition-rape

how India defines rape

https://www.indiacode.nic.in/show-data?actid=AC_CEN_5_23_00037_186045_1523266765688&orderno=424
Compare yourself.

lmk which country has more child marriage,

Don't have data but child marriage in India is illegal but it is legal in USA. So it's not a crime there.

which country let's their Hindu representatives out even after raping women?

USA does that. Not hindu but Christian probably https://www.kptv.com/2022/12/16/portlands-jogger-rapist-released-friday-after-36-years-prison-victims-concerned-outraged/

Not half as much effective as Indian blaming culture. Your whole life is ruined NOT coz of the mental effect on the victim but coz of the enormous shaming the society does. And don't compare the effects also coz India is a collectivistic society, the opinion of the collective matters more here.

That is just your opinion. There is no statistical evidence to suggest that. Shaming does exist but if you want to claim it is higher or lower than other countries, statistics are needed not opinions.

No it's not. The reason the law acts that way is CONNECTED to how the people react. Honour culture is not as prominent there so it's considered appropriate to use videos as evidence.

Absolutely false. Law is independent of the feelings of the people. That is why it's law.
Law of one country cannot be compared to feelings of people in another country. That is textbook definition of false comparison.
This is the stupidest mental gymnastics you are doing.

Ummm...the OPPOSITE is true you know that right? Data collection in India is bad and since we like to attach shame to women's bodies many people don't even report.

False. Public opinions are not defined by statistical data but news reports.
Media reports define public opinion.
Statistical reports defines actual data and law.
There is no mix matching here. How hard is it to get that?
I am literally laughing at the amount of intentional mix matching you are trying to do just because you can't accept that "muh america" has as much and more shit than many other countries in terms of rape.

Again the opposite is true. We are the ones that try to hide it as much as we can. And no US media houses don't do that, it's a different thing that in the US every city has its own channel but no they don't burry it or sweep anything under the carpet.

Evidence? Just saying "opposite is true" won't make it to be.
Because statistically rape news is a national news in India and Indian media is much more likely to report rape than US.
The ratio of "rape registered in police station" by "rape reported by media" is way higher in the US than in India.
If they are not reporting the rapes registered, we are supposed to play make believe that their media is better at reporting rapes in general because again "muh america". Keep dreaming.

You don't NECESSARILY have to know about the hair thin nuances to know what the culture around it is like. A knowledge on how they treat things like sex, women and men is quite enough to draw conclusions.

Yeah sure. Discuss on rape and laws without knowing the laws.
Sure, sure, SURE.
This so called "overall idea of what culture is" is what is called prejudice.
Real knowledge requires nuance.
But again I am talking to someone who denies nuance as a necessity.
India: 4.9 per 100k US: 38.2 per 100k
For India's number to be equal to the US with the assumption that all rapes are reported in the US,
4.9/38.3 = 12.8%
What this means is, even if 87% of rapes go unreported in India, our country will is just as bad as the US.
If you still want to believe the propaganda and think the worst of your countrymen, it's up to you.
Maybe you'll believe a woman writing for the scroll.
Is India the rape capital of the world? Think again

The rate of rape in India is low, even factoring in a high degree of under-reporting.
“The foreign media always describes India as having the maximum number of rapes, but this is not true,” said Flavia Agnes, a women’s rights lawyer with Majlis Legal Centre in Mumbai.
The past year has seen headlines reading, 'Understanding India's rape crisis' or 'Rape capital image affecting Indian tourism?' Others use anecdotal evidence to place India among the top five least safe countries for women in the world. However, these media reports, both Indian and foreign, strike far from the truth.

Even if you think 95% cases in India are not reported still per capita rape cases are higher in USA.

What in my opinion makes it worse is victim blaming.

US also has a victim blaming going on specially in their college campuses.

In the US, a video recording of the crime can be, and is used as evidence in the court. While in India, a video recording is used to shame and silence the victim.

Also how are you comparing how law acts on video evidence in US with how public reacts on video evidence?
Is this not textbook example of false comparison? Considering law should be compared with law and people with people?

I remember how a while ago, name of the rape victim was among the highest searched terms on a porn site. Shameful is a rather soft term for this. Each time the news of a rape makes headlines, along comes a sexist remark from a party leader.

Unfortunately same things happen in US as well. It's just that their population is not high enough to make them reach number one on search list.
Plus they don't report on rapes like we do, so knowledge of a rape case never goes outside the city in most cases for them.
Here, we know about rapes happening 1000 km away from us. (Which in my opinion is a good thing. US media houses care more about image management of the country than their own citizen's safety making them worse than trash.)

I don't know much about the politics around sexual crimes in the US, but I can safely say that the chances that a victim gets justice and leads a comparatively normal life without judgements from peers is higher in the US.

I don't know anything about a country but I will say using my inferiority complex that US is better. This is what this statement looks like.

That being said, this is a horrible crime and not something to compete about. The number must be zero both in India and around the world.

Then preach it to the US idiots filled with superiority complex before coming here. Why is it that preachers always try to persuade the retaliators and not the aggressors?

Just wondering, where do you think rape cases get more unreported? India or America?

I gave you detailed answer of this question with data but I didn't knew your pea sized brain was unable to process this data.

how america define rape

https://www.justice.gov/archives/opa/blog/updated-definition-rape

how India defines rape

https://www.indiacode.nic.in/show-data?actid=AC_CEN_5_23_00037_186045_1523266765688&orderno=424
Compare yourself.

lmk which country has more child marriage,

Don't have data but child marriage in India is illegal but it is legal in USA. So it's not a crime there.

which country let's their Hindu representatives out even after raping women?

USA does that. Not hindu but Christian probably https://www.kptv.com/2022/12/16/portlands-jogger-rapist-released-friday-after-36-years-prison-victims-concerned-outraged/

Not half as much effective as Indian blaming culture. Your whole life is ruined NOT coz of the mental effect on the victim but coz of the enormous shaming the society does. And don't compare the effects also coz India is a collectivistic society, the opinion of the collective matters more here.

That is just your opinion. There is no statistical evidence to suggest that. Shaming does exist but if you want to claim it is higher or lower than other countries, statistics are needed not opinions.

No it's not. The reason the law acts that way is CONNECTED to how the people react. Honour culture is not as prominent there so it's considered appropriate to use videos as evidence.

Absolutely false. Law is independent of the feelings of the people. That is why it's law.
Law of one country cannot be compared to feelings of people in another country. That is textbook definition of false comparison.
This is the stupidest mental gymnastics you are doing.

Ummm...the OPPOSITE is true you know that right? Data collection in India is bad and since we like to attach shame to women's bodies many people don't even report.

False. Public opinions are not defined by statistical data but news reports.
Media reports define public opinion.
Statistical reports defines actual data and law.
There is no mix matching here. How hard is it to get that?
I am literally laughing at the amount of intentional mix matching you are trying to do just because you can't accept that "muh america" has as much and more shit than many other countries in terms of rape.

Again the opposite is true. We are the ones that try to hide it as much as we can. And no US media houses don't do that, it's a different thing that in the US every city has its own channel but no they don't burry it or sweep anything under the carpet.

Evidence? Just saying "opposite is true" won't make it to be.
Because statistically rape news is a national news in India and Indian media is much more likely to report rape than US.
The ratio of "rape registered in police station" by "rape reported by media" is way higher in the US than in India.
If they are not reporting the rapes registered, we are supposed to play make believe that their media is better at reporting rapes in general because again "muh america". Keep dreaming.

You don't NECESSARILY have to know about the hair thin nuances to know what the culture around it is like. A knowledge on how they treat things like sex, women and men is quite enough to draw conclusions.

Yeah sure. Discuss on rape and laws without knowing the laws.
Sure, sure, SURE.
This so called "overall idea of what culture is" is what is called prejudice.
Real knowledge requires nuance.
But again I am talking to someone who denies nuance as a necessity.
India: 4.9 per 100k US: 38.2 per 100k
For India's number to be equal to the US with the assumption that all rapes are reported in the US,
4.9/38.3 = 12.8%
What this means is, even if 87% of rapes go unreported in India, our country will is just as bad as the US.
If you still want to believe the propaganda and think the worst of your countrymen, it's up to you.
Maybe you'll believe a woman writing for the scroll.
Is India the rape capital of the world? Think again

The rate of rape in India is low, even factoring in a high degree of under-reporting.
“The foreign media always describes India as having the maximum number of rapes, but this is not true,” said Flavia Agnes, a women’s rights lawyer with Majlis Legal Centre in Mumbai.
The past year has seen headlines reading, 'Understanding India's rape crisis' or 'Rape capital image affecting Indian tourism?' Others use anecdotal evidence to place India among the top five least safe countries for women in the world. However, these media reports, both Indian and foreign, strike far from the truth.

Even if you think 95% cases in India are not reported still per capita rape cases are higher in USA.

What in my opinion makes it worse is victim blaming.

US also has a victim blaming going on specially in their college campuses.

In the US, a video recording of the crime can be, and is used as evidence in the court. While in India, a video recording is used to shame and silence the victim.

Also how are you comparing how law acts on video evidence in US with how public reacts on video evidence?
Is this not textbook example of false comparison? Considering law should be compared with law and people with people?

I remember how a while ago, name of the rape victim was among the highest searched terms on a porn site. Shameful is a rather soft term for this. Each time the news of a rape makes headlines, along comes a sexist remark from a party leader.

Unfortunately same things happen in US as well. It's just that their population is not high enough to make them reach number one on search list.
Plus they don't report on rapes like we do, so knowledge of a rape case never goes outside the city in most cases for them.
Here, we know about rapes happening 1000 km away from us. (Which in my opinion is a good thing. US media houses care more about image management of the country than their own citizen's safety making them worse than trash.)

I don't know much about the politics around sexual crimes in the US, but I can safely say that the chances that a victim gets justice and leads a comparatively normal life without judgements from peers is higher in the US.

I don't know anything about a country but I will say using my inferiority complex that US is better. This is what this statement looks like.

That being said, this is a horrible crime and not something to compete about. The number must be zero both in India and around the world.

Then preach it to the US idiots filled with superiority complex before coming here. Why is it that preachers always try to persuade the retaliators and not the aggressors?

Just wondering, where do you think rape cases get more unreported? India or America?

I gave you detailed answer of this question with data but I didn't knew your pea sized brain was unable to process this data.

how america define rape

https://www.justice.gov/archives/opa/blog/updated-definition-rape

how India defines rape

https://www.indiacode.nic.in/show-data?actid=AC_CEN_5_23_00037_186045_1523266765688&orderno=424
Compare yourself.

lmk which country has more child marriage,

Don't have data but child marriage in India is illegal but it is legal in USA. So it's not a crime there.

which country let's their Hindu representatives out even after raping women?

USA does that. Not hindu but Christian probably https://www.kptv.com/2022/12/16/portlands-jogger-rapist-released-friday-after-36-years-prison-victims-concerned-outraged/

Not half as much effective as Indian blaming culture. Your whole life is ruined NOT coz of the mental effect on the victim but coz of the enormous shaming the society does. And don't compare the effects also coz India is a collectivistic society, the opinion of the collective matters more here.

That is just your opinion. There is no statistical evidence to suggest that. Shaming does exist but if you want to claim it is higher or lower than other countries, statistics are needed not opinions.

No it's not. The reason the law acts that way is CONNECTED to how the people react. Honour culture is not as prominent there so it's considered appropriate to use videos as evidence.

Absolutely false. Law is independent of the feelings of the people. That is why it's law.
Law of one country cannot be compared to feelings of people in another country. That is textbook definition of false comparison.
This is the stupidest mental gymnastics you are doing.

Ummm...the OPPOSITE is true you know that right? Data collection in India is bad and since we like to attach shame to women's bodies many people don't even report.

False. Public opinions are not defined by statistical data but news reports.
Media reports define public opinion.
Statistical reports defines actual data and law.
There is no mix matching here. How hard is it to get that?
I am literally laughing at the amount of intentional mix matching you are trying to do just because you can't accept that "muh america" has as much and more shit than many other countries in terms of rape.

Again the opposite is true. We are the ones that try to hide it as much as we can. And no US media houses don't do that, it's a different thing that in the US every city has its own channel but no they don't burry it or sweep anything under the carpet.

Evidence? Just saying "opposite is true" won't make it to be.
Because statistically rape news is a national news in India and Indian media is much more likely to report rape than US.
The ratio of "rape registered in police station" by "rape reported by media" is way higher in the US than in India.
If they are not reporting the rapes registered, we are supposed to play make believe that their media is better at reporting rapes in general because again "muh america". Keep dreaming.

You don't NECESSARILY have to know about the hair thin nuances to know what the culture around it is like. A knowledge on how they treat things like sex, women and men is quite enough to draw conclusions.

Yeah sure. Discuss on rape and laws without knowing the laws.
Sure, sure, SURE.
This so called "overall idea of what culture is" is what is called prejudice.
Real knowledge requires nuance.
But again I am talking to someone who denies nuance as a necessity.
India: 4.9 per 100k US: 38.2 per 100k
For India's number to be equal to the US with the assumption that all rapes are reported in the US,
4.9/38.3 = 12.8%
What this means is, even if 87% of rapes go unreported in India, our country will is just as bad as the US.
If you still want to believe the propaganda and think the worst of your countrymen, it's up to you.
Maybe you'll believe a woman writing for the scroll.
Is India the rape capital of the world? Think again

The rate of rape in India is low, even factoring in a high degree of under-reporting.
“The foreign media always describes India as having the maximum number of rapes, but this is not true,” said Flavia Agnes, a women’s rights lawyer with Majlis Legal Centre in Mumbai.
The past year has seen headlines reading, 'Understanding India's rape crisis' or 'Rape capital image affecting Indian tourism?' Others use anecdotal evidence to place India among the top five least safe countries for women in the world. However, these media reports, both Indian and foreign, strike far from the truth.

Bitcoin mining is powered by a HIGHER percentage of renewable energy than any developed country.
Specifically, 58% of the mining in the network is powered by renewable energy in 2022.
This makes it the #1 cleanest energy user of ANY INDUSTRY in the world.
​
Why is this the case?
In many REMOTE regions, renewable energy is CHEAPER than fossil fuels. There is also a LACK OF DEMAND for such energy in remote regions.
Imagine a hydroelectric dam where only a small town in the area consumes part of the energy.
Bitcoin miner’s can be placed next to the dam to consume the WASTED energy.
​
Some popular regions where mining farms are:
Wind farms in Texas
Hydro electric dams in Canada
Geothermal areas in Iceland
​
We know Bitcoin mining is highly competitive.
To be profitable, miners need access to CHEAP energy.
Renewable energy gives miners an edge.
This is why the network is mainly powered by low carbon emissions.
​
According to the Bitcoin Mining Council, Bitcoin mining uses 0.16% of the world’s total energy production (2022 data).

Even if you think 95% cases in India are not reported still per capita rape cases are higher in USA.

What in my opinion makes it worse is victim blaming.

US also has a victim blaming going on specially in their college campuses.

In the US, a video recording of the crime can be, and is used as evidence in the court. While in India, a video recording is used to shame and silence the victim.

Also how are you comparing how law acts on video evidence in US with how public reacts on video evidence?
Is this not textbook example of false comparison? Considering law should be compared with law and people with people?

I remember how a while ago, name of the rape victim was among the highest searched terms on a porn site. Shameful is a rather soft term for this. Each time the news of a rape makes headlines, along comes a sexist remark from a party leader.

Unfortunately same things happen in US as well. It's just that their population is not high enough to make them reach number one on search list.
Plus they don't report on rapes like we do, so knowledge of a rape case never goes outside the city in most cases for them.
Here, we know about rapes happening 1000 km away from us. (Which in my opinion is a good thing. US media houses care more about image management of the country than their own citizen's safety making them worse than trash.)

I don't know much about the politics around sexual crimes in the US, but I can safely say that the chances that a victim gets justice and leads a comparatively normal life without judgements from peers is higher in the US.

I don't know anything about a country but I will say using my inferiority complex that US is better. This is what this statement looks like.

That being said, this is a horrible crime and not something to compete about. The number must be zero both in India and around the world.

Then preach it to the US idiots filled with superiority complex before coming here. Why is it that preachers always try to persuade the retaliators and not the aggressors?

Just wondering, where do you think rape cases get more unreported? India or America?

I gave you detailed answer of this question with data but I didn't knew your pea sized brain was unable to process this data.

how america define rape

https://www.justice.gov/archives/opa/blog/updated-definition-rape

how India defines rape

https://www.indiacode.nic.in/show-data?actid=AC_CEN_5_23_00037_186045_1523266765688&orderno=424
Compare yourself.

lmk which country has more child marriage,

Don't have data but child marriage in India is illegal but it is legal in USA. So it's not a crime there.

which country let's their Hindu representatives out even after raping women?

USA does that. Not hindu but Christian probably https://www.kptv.com/2022/12/16/portlands-jogger-rapist-released-friday-after-36-years-prison-victims-concerned-outraged/

Not half as much effective as Indian blaming culture. Your whole life is ruined NOT coz of the mental effect on the victim but coz of the enormous shaming the society does. And don't compare the effects also coz India is a collectivistic society, the opinion of the collective matters more here.

That is just your opinion. There is no statistical evidence to suggest that. Shaming does exist but if you want to claim it is higher or lower than other countries, statistics are needed not opinions.

No it's not. The reason the law acts that way is CONNECTED to how the people react. Honour culture is not as prominent there so it's considered appropriate to use videos as evidence.

Absolutely false. Law is independent of the feelings of the people. That is why it's law.
Law of one country cannot be compared to feelings of people in another country. That is textbook definition of false comparison.
This is the stupidest mental gymnastics you are doing.

Ummm...the OPPOSITE is true you know that right? Data collection in India is bad and since we like to attach shame to women's bodies many people don't even report.

False. Public opinions are not defined by statistical data but news reports.
Media reports define public opinion.
Statistical reports defines actual data and law.
There is no mix matching here. How hard is it to get that?
I am literally laughing at the amount of intentional mix matching you are trying to do just because you can't accept that "muh america" has as much and more shit than many other countries in terms of rape.

Again the opposite is true. We are the ones that try to hide it as much as we can. And no US media houses don't do that, it's a different thing that in the US every city has its own channel but no they don't burry it or sweep anything under the carpet.

Evidence? Just saying "opposite is true" won't make it to be.
Because statistically rape news is a national news in India and Indian media is much more likely to report rape than US.
The ratio of "rape registered in police station" by "rape reported by media" is way higher in the US than in India.
If they are not reporting the rapes registered, we are supposed to play make believe that their media is better at reporting rapes in general because again "muh america". Keep dreaming.

You don't NECESSARILY have to know about the hair thin nuances to know what the culture around it is like. A knowledge on how they treat things like sex, women and men is quite enough to draw conclusions.

Yeah sure. Discuss on rape and laws without knowing the laws.
Sure, sure, SURE.
This so called "overall idea of what culture is" is what is called prejudice.
Real knowledge requires nuance.
But again I am talking to someone who denies nuance as a necessity.
India: 4.9 per 100k US: 38.2 per 100k
For India's number to be equal to the US with the assumption that all rapes are reported in the US,
4.9/38.3 = 12.8%
What this means is, even if 87% of rapes go unreported in India, our country will is just as bad as the US.
If you still want to believe the propaganda and think the worst of your countrymen, it's up to you.
Maybe you'll believe a woman writing for the scroll.
Is India the rape capital of the world? Think again

The rate of rape in India is low, even factoring in a high degree of under-reporting.
“The foreign media always describes India as having the maximum number of rapes, but this is not true,” said Flavia Agnes, a women’s rights lawyer with Majlis Legal Centre in Mumbai.
The past year has seen headlines reading, 'Understanding India's rape crisis' or 'Rape capital image affecting Indian tourism?' Others use anecdotal evidence to place India among the top five least safe countries for women in the world. However, these media reports, both Indian and foreign, strike far from the truth.

PK Dunk Low Off-White Los 4

PK Dunk Low Off-White Los 4

beliebtes Modell

Anyone with Tweed Lows that have a “Nike SB” tongue logo? I see a listing with one but I can’t find any reference photos of Tweed Lows specifically with a “Nike SB” instead of just “Nike” on the tongue. Only one I found were fakes

I'm currently trying to optimize performance in an application which uses a MariaDB (v10.5.10). When I analyze the low performing query the ANALYZE statement is confusing me by having longer execution time in specific blocks than expected.
The CREATE statement of the relevant tables.

CREATE TABLE `position` ( `id` INT(11) NOT NULL AUTO_INCREMENT, `name` VARCHAR(255) NULL DEFAULT NULL COLLATE 'utf8_general_ci', `comment` VARCHAR(255) NULL DEFAULT NULL COLLATE 'utf8_general_ci', `created_at` DATETIME NULL DEFAULT NULL, `updated_at` DATETIME NULL DEFAULT NULL, `deleted_at` DATETIME NULL DEFAULT NULL, `version` INT(11) NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) COLLATE='utf8_general_ci' ENGINE=InnoDB AUTO_INCREMENT=1692 ; CREATE TABLE `position_info` ( `id` CHAR(36) NOT NULL COLLATE 'utf8_bin', `position_id` INT(11) NULL DEFAULT NULL, `bezeichnung` TEXT NULL DEFAULT NULL COLLATE 'utf8_general_ci', `location` VARCHAR(255) NULL DEFAULT NULL COLLATE 'utf8_general_ci', `bereich` VARCHAR(255) NULL DEFAULT NULL COLLATE 'utf8_general_ci', `valid_from` DATETIME NULL DEFAULT NULL, `valid_to` DATETIME NULL DEFAULT NULL, `created_by` VARCHAR(255) NULL DEFAULT NULL COLLATE 'utf8_general_ci', `updated_by` VARCHAR(255) NULL DEFAULT NULL COLLATE 'utf8_general_ci', `deleted_by` VARCHAR(255) NULL DEFAULT NULL COLLATE 'utf8_general_ci', `created_at` DATETIME NULL DEFAULT NULL, `updated_at` DATETIME NULL DEFAULT NULL, `deleted_at` DATETIME NULL DEFAULT NULL, `version` INT(11) NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE, INDEX `position_info_position_idx` (`position_id`) USING BTREE, INDEX `position_info_created_idx` (`created_by`) USING BTREE, INDEX `position_info_updated_idx` (`updated_by`) USING BTREE, INDEX `position_info_deleted_idx` (`deleted_by`) USING BTREE, INDEX `pi_valid_from_index` (`position_id`, `valid_from`) USING BTREE, CONSTRAINT `position_info_created_idx` FOREIGN KEY (`created_by`) REFERENCES `db`.`user` (`id`) ON UPDATE CASCADE ON DELETE CASCADE, CONSTRAINT `position_info_deleted_idx` FOREIGN KEY (`deleted_by`) REFERENCES `db`.`user` (`id`) ON UPDATE CASCADE ON DELETE CASCADE, CONSTRAINT `position_info_position_idx` FOREIGN KEY (`position_id`) REFERENCES `db`.`position` (`id`) ON UPDATE CASCADE ON DELETE CASCADE, CONSTRAINT `position_info_updated_idx` FOREIGN KEY (`updated_by`) REFERENCES `db`.`user` (`id`) ON UPDATE CASCADE ON DELETE CASCADE ) COLLATE='utf8_general_ci' ENGINE=InnoDB ; 

A shortened version of the SQL query with the low performance (2172ms total).

SELECT `positionInfo`.* FROM ( SELECT * FROM ( SELECT `id`, `position_id` AS `positionId`, `bezeichnung`, `location`, `bereich`, `valid_from` AS `validFrom`, `valid_to` AS `validTo`, `created_by` AS `createdBy`, `updated_by` AS `updatedBy`, `deleted_by` AS `deletedBy`, `created_at`, `updated_at`, `deleted_at`, `version`, `created_at` AS `createdAt`, `updated_at` AS `updatedAt`, `deleted_at` AS `deletedAt` FROM `position_info` AS `positionInfo` WHERE (`positionInfo`.`deleted_at` IS NULL AND ((`positionInfo`.`deleted_at` IS NULL AND `positionInfo`.`valid_from` <= '2022-03-20 22:59:59.999'))) AND `positionInfo`.`position_id` = 256 ORDER BY `validFrom` DESC LIMIT 1) AS sub UNION ALL SELECT * FROM ( SELECT `id`, `position_id` AS `positionId`, `bezeichnung`, `location`, `bereich`, `valid_from` AS `validFrom`, `valid_to` AS `validTo`, `created_by` AS `createdBy`, `updated_by` AS `updatedBy`, `deleted_by` AS `deletedBy`, `created_at`, `updated_at`, `deleted_at`, `version`, `created_at` AS `createdAt`, `updated_at` AS `updatedAt`, `deleted_at` AS `deletedAt` FROM `position_info` AS `positionInfo` WHERE (`positionInfo`.`deleted_at` IS NULL AND ((`positionInfo`.`deleted_at` IS NULL AND `positionInfo`.`valid_from` <= '2022-03-20 22:59:59.999'))) AND `positionInfo`.`position_id` = 18 ORDER BY `validFrom` DESC LIMIT 1) AS sub UNION ALL ... 

The query is generated by Sequelize, a JavaScript ORM, as a separate query to a more complex query. Since the where statement uses both the position_id and valid_from fields I created the pi_valid_from_index which is a composite index over both fields.
​
When I analyze it it yields the following result:

{ "query_block": { "select_id": 1, "r_loops": 1, "r_total_time_ms": 1809.757232, "table": { "table_name": "", "access_type": "ALL", "r_loops": 1, "rows": 350, "r_rows": 171, "r_table_time_ms": 0.46998943, "r_other_time_ms": 0.151807862, "filtered": 100, "r_filtered": 100, "materialized": { "query_block": { "union_result": { "table_name": "", "access_type": "ALL", "r_loops": 0, "r_rows": null, "query_specifications": [ { "query_block": { "select_id": 2, "r_loops": 1, "r_total_time_ms": 16.59932409, "table": { "table_name": "", "access_type": "ALL", "r_loops": 1, "rows": 2, "r_rows": 1, "r_table_time_ms": 0.044354854, "r_other_time_ms": 0.01983318, "filtered": 100, "r_filtered": 100, "materialized": { "query_block": { "select_id": 3, "r_loops": 1, "r_total_time_ms": 0.10711399, "table": { "table_name": "positionInfo", "access_type": "range", "possible_keys": [ "position_info_position_idx", "pi_valid_from_index" ], "key": "pi_valid_from_index", "key_length": "11", "used_key_parts": ["position_id", "valid_from"], "r_loops": 1, "rows": 1, "r_rows": 1, "r_table_time_ms": 0.028658321, "r_other_time_ms": 0.019230482, "filtered": 100, "r_filtered": 100, "attached_condition": "positioninfo.position_id <=> 256 and positioninfo.deleted_at is null and positioninfo.deleted_at is null and positioninfo.valid_from <= '2022-03-20 22:59:59.999'" } } } } } }, { "query_block": { "select_id": 4, "operation": "UNION", "r_loops": 1, "r_total_time_ms": 11.18885812, "table": { "table_name": "", "access_type": "ALL", "r_loops": 1, "rows": 2, "r_rows": 1, "r_table_time_ms": 0.040932656, "r_other_time_ms": 0.01641161, "filtered": 100, "r_filtered": 100, "materialized": { "query_block": { "select_id": 5, "r_loops": 1, "r_total_time_ms": 0.097741398, "table": { "table_name": "positionInfo", "access_type": "range", "possible_keys": [ "position_info_position_idx", "pi_valid_from_index" ], "key": "pi_valid_from_index", "key_length": "11", "used_key_parts": ["position_id", "valid_from"], "r_loops": 1, "rows": 1, "r_rows": 1, "r_table_time_ms": 0.025234867, "r_other_time_ms": 0.020159014, "filtered": 100, "r_filtered": 100, "attached_condition": "positioninfo.position_id <=> 18 and positioninfo.deleted_at is null and positioninfo.deleted_at is null and positioninfo.valid_from <= '2022-03-20 22:59:59.999'" } } } } } }, ... 

The db is using the index as expected. As seen the r_total_time_ms of the middle block is ca. 10ms on most blocks but the time of the deeper ones doesn't add up to that. I know that there can be also causes like other things happening on the db but it is tested on test db with no extra traffic.
​
What confuses me the most is that there is a second similiar query on a similiar table which has similiar r_total_time_ms in the deeper blocks but a way shorter time in the middle blocks. I have added the same info for the second table that works faster below.
​
Another thing that suprised me is that the performance stays the same even without the composite index when it only uses the index over the position_id. Adding the index to the second table improved the performance from ca. 80 ms to 7ms.
​
The CREATE statement of the relevant tables.

CREATE TABLE `aircraft` ( `id` CHAR(36) NOT NULL COLLATE 'utf8_bin', `registration` VARCHAR(255) NULL DEFAULT NULL COLLATE 'utf8_general_ci', `created_by` VARCHAR(255) NULL DEFAULT NULL COLLATE 'utf8_general_ci', `created_at` DATETIME NULL DEFAULT NULL, `updated_at` DATETIME NULL DEFAULT NULL, `deleted_at` DATETIME NULL DEFAULT NULL, `version` INT(11) NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE, INDEX `aircraft_created_idx` (`created_by`) USING BTREE, CONSTRAINT `aircraft_created_idx` FOREIGN KEY (`created_by`) REFERENCES `db`.`user` (`id`) ON UPDATE CASCADE ON DELETE CASCADE ) COLLATE='utf8_general_ci' ENGINE=InnoDB ; CREATE TABLE `aircraft_assignment` ( `id` CHAR(36) NOT NULL COLLATE 'utf8_bin', `aircraft_id` CHAR(36) NULL DEFAULT NULL COLLATE 'utf8_bin', `airline_id` INT(11) NULL DEFAULT NULL, `type` VARCHAR(255) NULL DEFAULT NULL COLLATE 'utf8_general_ci', `class` VARCHAR(255) NULL DEFAULT NULL COLLATE 'utf8_general_ci', `category` VARCHAR(255) NULL DEFAULT NULL COLLATE 'utf8_general_ci', `created_by` VARCHAR(255) NULL DEFAULT NULL COLLATE 'utf8_general_ci', `valid_from` DATETIME NULL DEFAULT NULL, `valid_to` DATETIME NULL DEFAULT NULL, `created_at` DATETIME NULL DEFAULT NULL, `updated_at` DATETIME NULL DEFAULT NULL, `deleted_at` DATETIME NULL DEFAULT NULL, `version` INT(11) NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE, INDEX `aircraft_assignment_aircraft_idx` (`aircraft_id`) USING BTREE, INDEX `aircraft_assignment_airline_idx` (`airline_id`) USING BTREE, INDEX `aircraft_assignment_created_idx` (`created_by`) USING BTREE, INDEX `aa_valid_from_index` (`aircraft_id`, `valid_from`) USING BTREE, CONSTRAINT `aircraft_assignment_aircraft_idx` FOREIGN KEY (`aircraft_id`) REFERENCES `db`.`aircraft` (`id`) ON UPDATE CASCADE ON DELETE CASCADE, CONSTRAINT `aircraft_assignment_airline_idx` FOREIGN KEY (`airline_id`) REFERENCES `db`.`airline` (`id`) ON UPDATE CASCADE ON DELETE CASCADE, CONSTRAINT `aircraft_assignment_created_idx` FOREIGN KEY (`created_by`) REFERENCES `db`.`user` (`id`) ON UPDATE CASCADE ON DELETE CASCADE ) COLLATE='utf8_general_ci' ENGINE=InnoDB ; 

​
A shortened version of the SQL query that performs better (31ms total)

SELECT * FROM ( SELECT `id`, `aircraft_id` AS `aircraftId`, `airline_id` AS `airlineId`, `type`, `class`, `category`, `created_by` AS `createdBy`, `valid_from` AS `validFrom`, `valid_to` AS `validTo`, `created_at`, `updated_at`, `deleted_at`, `version`, `created_at` AS `createdAt`, `updated_at` AS `updatedAt`, `deleted_at` AS `deletedAt` FROM `aircraft_assignment` AS `aircraftAssignment` WHERE (`aircraftAssignment`.`deleted_at` IS NULL AND ((`aircraftAssignment`.`deleted_at` IS NULL AND `aircraftAssignment`.`valid_from` <= '2022-03-20 22:59:59.999'))) AND `aircraftAssignment`.`aircraft_id` = 'd27feb20-7de9-4500-b0a5-9965aa9fb80a' ORDER BY `validFrom` DESC LIMIT 1) AS sub UNION ALL SELECT * FROM ( SELECT `id`, `aircraft_id` AS `aircraftId`, `airline_id` AS `airlineId`, `type`, `class`, `category`, `created_by` AS `createdBy`, `valid_from` AS `validFrom`, `valid_to` AS `validTo`, `created_at`, `updated_at`, `deleted_at`, `version`, `created_at` AS `createdAt`, `updated_at` AS `updatedAt`, `deleted_at` AS `deletedAt` FROM `aircraft_assignment` AS `aircraftAssignment` WHERE (`aircraftAssignment`.`deleted_at` IS NULL AND ((`aircraftAssignment`.`deleted_at` IS NULL AND `aircraftAssignment`.`valid_from` <= '2022-03-20 22:59:59.999'))) AND `aircraftAssignment`.`aircraft_id` = 'de648ae2-4dff-431f-bbe7-7514d8902d0e' ORDER BY `validFrom` DESC LIMIT 1) AS sub UNION ALL ... 

When I analyze it it yields the following result:

{ "query_block": { "select_id": 1, "r_loops": 1, "r_total_time_ms": 7.936409288, "table": { "table_name": "", "access_type": "ALL", "r_loops": 1, "rows": 342, "r_rows": 171, "r_table_time_ms": 0.166444022, "r_other_time_ms": 0.15610209, "filtered": 100, "r_filtered": 100, "materialized": { "query_block": { "union_result": { "table_name": "", "access_type": "ALL", "r_loops": 0, "r_rows": null, "query_specifications": [ { "query_block": { "select_id": 2, "r_loops": 1, "r_total_time_ms": 0.128546205, "table": { "table_name": "", "access_type": "ALL", "r_loops": 1, "rows": 2, "r_rows": 1, "r_table_time_ms": 0.013479732, "r_other_time_ms": 0.016444884, "filtered": 100, "r_filtered": 100, "materialized": { "query_block": { "select_id": 3, "r_loops": 1, "r_total_time_ms": 0.102809089, "table": { "table_name": "aircraftAssignment", "access_type": "range", "possible_keys": [ "aircraft_assignment_aircraft_idx", "aa_valid_from_index" ], "key": "aa_valid_from_index", "key_length": "115", "used_key_parts": ["aircraft_id", "valid_from"], "r_loops": 1, "rows": 5, "r_rows": 3, "r_table_time_ms": 0.040696599, "r_other_time_ms": 0.030328298, "filtered": 100, "r_filtered": 33.33333333, "attached_condition": "aircraftassignment.aircraft_id <=> 'd27feb20-7de9-4500-b0a5-9965aa9fb80a' and aircraftassignment.deleted_at is null and aircraftassignment.valid_from <= '2022-03-20 22:59:59.999'" } } } } } }, { "query_block": { "select_id": 4, "operation": "UNION", "r_loops": 1, "r_total_time_ms": 0.049281287, "table": { "table_name": "", "access_type": "ALL", "r_loops": 1, "rows": 2, "r_rows": 1, "r_table_time_ms": 0.002692682, "r_other_time_ms": 0.006288156, "filtered": 100, "r_filtered": 100, "materialized": { "query_block": { "select_id": 5, "r_loops": 1, "r_total_time_ms": 0.035126031, "table": { "table_name": "aircraftAssignment", "access_type": "range", "possible_keys": [ "aircraft_assignment_aircraft_idx", "aa_valid_from_index" ], "key": "aa_valid_from_index", "key_length": "115", "used_key_parts": ["aircraft_id", "valid_from"], "r_loops": 1, "rows": 9, "r_rows": 1, "r_table_time_ms": 0.013620362, "r_other_time_ms": 0.009586675, "filtered": 0.100033343, "r_filtered": 100, "attached_condition": "aircraftassignment.aircraft_id = 'de648ae2-4dff-431f-bbe7-7514d8902d0e' and aircraftassignment.deleted_at is null and aircraftassignment.valid_from <= '2022-03-20 22:59:59.999'" } } } } } }, ... 

​
As visible the r_total_time_ms of the middle blocks are as expected ca. equal by the sum of the times deeper. The main difference between the two tables is that the position table uses an integer as the id and the aircraft table uses an uuid but I don't think that this should have a real impact on the performance and even then I would expect the integer id to be the better performing one.
​
The total count of the rows in the tables is the following:
position: 1691
positionInfo: 790
aircraft: 1735
aircraftAssignment: 8997
​
As seen positionInfo even has less rows than aircraftAssignment but performs worse.
​
Any ideas what could cause the worse performance? I would prefer to let the query be as it is and tweak things on the indices if possible.