Query Metrics
7
Database Queries
7
Different statements
172.01 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
143.93 ms (83.68%) |
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 332765 387018 407377 408652 411448 412091 413459 433443 433446 433609 442188 442197 443668 443890 447906 449153 451758 458794 460181 465324 466646 468354 476382 481124 481815 482197 486522 488549 490161 496089 507532 510953 514883 517813 519746 525168 528160 529718 531528 532061 532573 537136 537140 542142 543962 546922 563009 568991 576436 578045 587693 595092 603601 608122 613586 627158 637758 649635 653902 659195 661890 666059 670232 670249 701252 707404 710478 714011 714129 715569 721039 721243 724985 725059 725116 727582 738276 743012 744203 744680 747083 747111 753573 758587 761137 776741 777841 781269 782165 782658 784554 786598 787480 788875 788939 789585 789976 793433 794857 796245 800056 801259 802358 802547 804455 807650 808007 809061 809354 811500 812593 812631 815496 819318 819634 823149 825870 826391 827731 ] |
||||||||||||||||||||||||||||||
|
15.47 ms (8.99%) |
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 788875 802547 804455 811500 758587 637758 481815 482197 468354 517813 595092 789976 747083 332765 466646 451758 761137 443890 481124 519746 825870 823149 815496 537136 653902 670232 707404 578045 587693 627158 776741 812631 782165 781269 747111 753573 738276 543962 659195 666059 714011 789585 788939 794857 796245 721039 809061 412091 447906 819634 827731 819318 824009 826391 525168 537140 532573 576436 661890 710478 715569 721243 649635 670249 701252 603601 613586 777841 786598 793433 802358 784554 725059 727582 743012 800056 724985 744680 782658 787480 808007 387018 413459 408652 442197 411448 433443 486522 449153 476382 507532 490161 542142 546922 714129 812593 809354 608122 433446 496089 510953 514883 528160 458794 532061 433609 465324 531528 488549 407377 443668 442188 529718 807650 725116 744203 460181 568991 563009 801259 ] |
||||||||||||||||||||||||||||||
|
4.02 ms (2.34%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"your мам женщин"
]
|
||||||||||||||||||||||||||||||
|
3.18 ms (1.85%) |
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 332765 387018 407377 408652 411448 412091 413459 433443 433446 433609 442188 442197 443668 443890 447906 449153 451758 458794 460181 465324 466646 468354 476382 481124 481815 482197 486522 488549 490161 496089 507532 510953 514883 517813 519746 525168 528160 529718 531528 532061 532573 537136 537140 542142 543962 546922 563009 568991 576436 578045 587693 595092 603601 608122 613586 627158 637758 649635 653902 659195 661890 666059 670232 670249 701252 707404 710478 714011 714129 715569 721039 721243 724985 725059 725116 727582 738276 743012 744203 744680 747083 747111 753573 758587 761137 776741 777841 781269 782165 782658 784554 786598 787480 788875 788939 789585 789976 793433 794857 796245 800056 801259 802358 802547 804455 807650 808007 809061 809354 811500 812593 812631 815496 819318 819634 823149 825870 826391 827731 ] |
||||||||||||||||||||||||||||||
|
2.07 ms (1.20%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"your mother"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (0.97%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.66 ms (0.97%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"your мам женщин"
]
|
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.