Query Metrics
7
Database Queries
7
Different statements
172.26 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
147.51 ms (85.63%) |
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 208400 385141 397707 401552 401649 402905 406061 410853 413650 413719 416163 419185 421158 427558 429123 437156 447252 448218 457060 459085 461319 461836 462760 464597 465161 467764 468116 472074 474601 475118 475172 485043 485178 492932 498766 501961 506519 510003 521610 521629 523890 527321 529470 534470 535418 552415 556359 558881 559617 561314 565294 567822 568559 571971 572704 574108 575469 578295 578551 579735 585273 585794 586700 593581 599207 599454 602559 603967 606555 617295 621270 651979 653208 654929 655293 659176 670296 672379 672399 679653 686997 689170 699194 701557 729351 737065 757981 762836 763321 764788 767008 768180 771647 779614 782582 789327 790089 792196 794088 796981 807032 815131 816145 817339 818687 821439 821490 821600 824329 824991 825469 825485 825600 825608 826158 826447 827835 827845 827907 828403 ] |
||||||||||||||||||||||||||||||
|
13.99 ms (8.12%) |
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 764788 768180 413719 492932 575469 461319 701557 827835 464597 670296 599454 796981 468116 621270 574108 779614 406061 824329 818687 824991 552415 208400 672379 568559 815131 559617 586700 459085 416163 427558 472074 527321 689170 699194 653208 782582 792196 794088 771647 737065 457060 529470 419185 534470 578295 467764 506519 521610 535418 413650 429123 817339 593581 807032 821600 821490 816145 827907 827845 510003 565294 579735 654929 585273 585794 617295 762836 763321 556359 659176 599207 421158 475172 729351 401649 825600 821439 825469 826447 825608 828403 672399 602559 606555 790089 757981 789327 523890 567822 603967 475118 397707 410853 558881 401552 402905 437156 385141 521629 572704 686997 655293 651979 767008 571971 679653 561314 462760 474601 465161 498766 825485 826158 447252 448218 461836 485178 501961 485043 578551 ] |
||||||||||||||||||||||||||||||
|
3.22 ms (1.87%) |
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 208400 385141 397707 401552 401649 402905 406061 410853 413650 413719 416163 419185 421158 427558 429123 437156 447252 448218 457060 459085 461319 461836 462760 464597 465161 467764 468116 472074 474601 475118 475172 485043 485178 492932 498766 501961 506519 510003 521610 521629 523890 527321 529470 534470 535418 552415 556359 558881 559617 561314 565294 567822 568559 571971 572704 574108 575469 578295 578551 579735 585273 585794 586700 593581 599207 599454 602559 603967 606555 617295 621270 651979 653208 654929 655293 659176 670296 672379 672399 679653 686997 689170 699194 701557 729351 737065 757981 762836 763321 764788 767008 768180 771647 779614 782582 789327 790089 792196 794088 796981 807032 815131 816145 817339 818687 821439 821490 821600 824329 824991 825469 825485 825600 825608 826158 826447 827835 827845 827907 828403 ] |
||||||||||||||||||||||||||||||
|
2.18 ms (1.26%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"brunette 18 pov"
]
|
||||||||||||||||||||||||||||||
|
1.86 ms (1.08%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"черноволосая 18 пов"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (1.06%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.68 ms (0.97%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"черноволосая 18 пов"
]
|
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.