Query Metrics
7
Database Queries
7
Different statements
152.04 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
128.10 ms (84.25%) |
1 |
SELECT phc.post_id, phc.category_id, c.slug, IFNULL(`r`.`name`, `f`.`name`) as `name` FROM post_has_category phc INNER JOIN category c ON phc.category_id = c.category_id AND c.enabled = 1 LEFT JOIN category_translation f ON c.category_id = f.category_id AND f.lang_id=? LEFT JOIN category_translation r ON `c`.`category_id` = `r`.`category_id` AND `r`.`lang_id`=? WHERE phc.post_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 1 2 33917 81496 396795 418992 446814 452426 457848 469090 473553 474115 486954 487587 489266 492415 494626 497365 499899 505741 506068 507705 509318 521412 526983 527138 529622 537337 537351 539208 539331 540453 542338 546419 546438 546842 549670 550795 551645 551826 553227 554501 555568 558109 561739 569274 573176 573666 578180 578342 579553 583257 586686 591501 592128 593728 597712 598345 601845 603043 605160 606143 606190 607462 607693 609042 615170 615698 616435 622446 626243 628695 640811 643569 644005 650647 664557 666683 675587 680953 707127 710474 710920 713919 716082 724797 725202 725239 726998 731062 733032 738029 742943 744221 749920 755041 755049 755190 758157 758445 763474 766493 776655 779753 779790 787086 791054 791761 793454 793632 794875 794893 796191 796283 796305 796641 798535 798957 800738 808071 810121 810340 ] |
||||||||||||||||||||||||||||||
|
14.40 ms (9.47%) |
1 |
SELECT p.post_id, p.user_id, p.content_id, p.public_key, p.search_field, p.cover, p.type, p.sexual_orientation, p.orientation, p.quality, p.noindex, p.nofollow, p.contents_num, p.duration, p.likes, p.dislikes, p.views, p.vote_rating, p.params, p.published_at, IFNULL(`r`.`title`, `f`.`title`) as `title`, IFNULL(`r`.`custom1`, `f`.`custom1`) as `custom1`, IFNULL(`r`.`custom2`, `f`.`custom2`) as `custom2` FROM post p LEFT JOIN post_translation f ON `p`.`post_id` = `f`.`post_id` AND `f`.`lang_id`=? LEFT JOIN post_translation r ON `p`.`post_id` = `r`.`post_id` AND `r`.`lang_id`=? WHERE p.post_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 1 2 725239 733032 763474 755041 755049 726998 755190 716082 33917 578342 418992 527138 509318 546419 573176 561739 578180 549670 615170 591501 607693 469090 724797 537351 791054 810121 506068 499899 554501 551645 615698 593728 598345 603043 606143 749920 791761 710920 446814 473553 601845 497365 507705 798957 725202 731062 810340 758157 650647 644005 486954 81496 457848 546842 555568 779753 537337 742943 680953 569274 492415 474115 539208 573666 710474 713919 675587 616435 640811 796283 798535 539331 558109 609042 489266 550795 579553 707127 592128 622446 605160 452426 526983 551826 583257 553227 586686 607462 626243 505741 521412 396795 487587 494626 529622 540453 542338 546438 664557 666683 597712 628695 606190 643569 793454 794875 796191 808071 776655 779790 787086 793632 796305 796641 800738 738029 744221 758445 766493 794893 ] |
||||||||||||||||||||||||||||||
|
3.09 ms (2.03%) |
1 |
SELECT pht.post_id, pht.tag_id, t.slug, IFNULL(`r`.`name`, `f`.`name`) as `name` FROM post_has_tag pht INNER JOIN tag t ON pht.tag_id = t.tag_id AND t.enabled = 1 LEFT JOIN tag_translation f ON t.tag_id = f.tag_id AND f.lang_id=? LEFT JOIN tag_translation r ON `t`.`tag_id` = `r`.`tag_id` AND `r`.`lang_id`=? WHERE pht.post_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 1 2 33917 81496 396795 418992 446814 452426 457848 469090 473553 474115 486954 487587 489266 492415 494626 497365 499899 505741 506068 507705 509318 521412 526983 527138 529622 537337 537351 539208 539331 540453 542338 546419 546438 546842 549670 550795 551645 551826 553227 554501 555568 558109 561739 569274 573176 573666 578180 578342 579553 583257 586686 591501 592128 593728 597712 598345 601845 603043 605160 606143 606190 607462 607693 609042 615170 615698 616435 622446 626243 628695 640811 643569 644005 650647 664557 666683 675587 680953 707127 710474 710920 713919 716082 724797 725202 725239 726998 731062 733032 738029 742943 744221 749920 755041 755049 755190 758157 758445 763474 766493 776655 779753 779790 787086 791054 791761 793454 793632 794875 794893 796191 796283 796305 796641 798535 798957 800738 808071 810121 810340 ] |
||||||||||||||||||||||||||||||
|
1.75 ms (1.15%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big tits sperm"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (1.09%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.60 ms (1.05%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие сиськ сперм"
]
|
||||||||||||||||||||||||||||||
|
1.43 ms (0.94%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большие сиськ сперм"
]
|
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Entities Mapping
No loaded entities.