Query Metrics
7
Database Queries
7
Different statements
165.75 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
136.66 ms (82.45%) |
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 79765 360015 388719 389351 389729 391477 395860 396249 397361 398969 399585 401077 403324 404994 411352 411897 413524 424410 432306 443695 464420 466244 467124 482602 511268 513149 519945 554321 557572 575723 578158 580623 589472 591008 598508 604143 608091 609052 609878 626535 626539 632051 640784 640785 645891 655071 666968 670103 670109 671640 675807 677726 679388 680141 685001 687928 689001 694219 697298 697374 698293 699626 709781 716277 716787 717610 717677 717895 720197 720306 722050 722557 724509 728384 728446 731857 732054 733862 734692 736911 737152 740704 741158 741896 744276 746423 749116 749919 752685 753890 757367 757643 758226 759543 765299 777250 788277 788284 792636 797247 799360 800625 801319 803461 805433 806084 807497 807617 811624 814933 815722 818167 818278 818406 819573 821369 826285 827152 ] |
||||||||||||||||||||||||||||||
|
18.45 ms (11.13%) |
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 815722 554321 801319 805433 807617 737152 765299 792636 411897 580623 733862 388719 397361 685001 666968 413524 519945 814933 467124 557572 716787 640785 806084 741158 803461 728446 758226 788284 799360 360015 389729 391477 411352 424410 432306 443695 403324 466244 513149 818406 821369 827152 818167 826285 677726 680141 670109 679388 697298 697374 716277 722557 675807 687928 694219 718662 591008 604143 608091 598508 632051 800625 777250 744276 749116 753890 759543 731857 757643 746423 482602 398969 484232 79765 399585 819573 818278 575723 578158 699626 709781 645891 655071 671640 717677 717895 670103 717610 720306 589472 609878 626539 626535 609052 811624 734692 740704 757367 797247 724509 728384 741896 752685 732054 749919 736911 698293 722050 788277 395860 389351 401077 404994 464420 396249 689001 640784 720197 511268 807497 ] |
||||||||||||||||||||||||||||||
|
2.81 ms (1.69%) |
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 79765 360015 388719 389351 389729 391477 395860 396249 397361 398969 399585 401077 403324 404994 411352 411897 413524 424410 432306 443695 464420 466244 467124 482602 511268 513149 519945 554321 557572 575723 578158 580623 589472 591008 598508 604143 608091 609052 609878 626535 626539 632051 640784 640785 645891 655071 666968 670103 670109 671640 675807 677726 679388 680141 685001 687928 689001 694219 697298 697374 698293 699626 709781 716277 716787 717610 717677 717895 720197 720306 722050 722557 724509 728384 728446 731857 732054 733862 734692 736911 737152 740704 741158 741896 744276 746423 749116 749919 752685 753890 757367 757643 758226 759543 765299 777250 788277 788284 792636 797247 799360 800625 801319 803461 805433 806084 807497 807617 811624 814933 815722 818167 818278 818406 819573 821369 826285 827152 ] |
||||||||||||||||||||||||||||||
|
2.20 ms (1.32%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.00 ms (1.21%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big anal old"
]
|
||||||||||||||||||||||||||||||
|
1.86 ms (1.12%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие анал old"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (1.08%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большие анал old"
]
|
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.