Query Metrics
7
Database Queries
7
Different statements
189.45 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
165.37 ms (87.29%) |
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 389258 425356 429520 435452 467111 474553 475438 475477 475481 479021 486318 503693 518733 522634 522636 533474 535725 537799 538132 538538 540983 544462 550405 556181 557604 559745 566583 566828 566871 575862 575954 579106 583492 585439 587268 592159 596937 599606 600741 600871 602177 602995 603601 610030 632172 636419 637870 643018 652122 671374 673779 682179 682943 690045 704339 710398 717158 719946 719955 719968 725621 737305 739877 747023 748794 758136 762779 764748 764955 766572 766737 770945 771644 782659 784363 784443 784455 784460 784508 784510 785405 787738 788488 792813 793447 796234 799555 801101 804374 804657 806038 808042 809365 810426 810434 811049 811418 815091 816372 820500 820583 820637 820844 820845 820952 821162 821196 821730 822098 822153 822298 822495 822630 822701 822712 823091 823878 826883 827835 ] |
||||||||||||||||||||||||||||||
|
14.52 ms (7.67%) |
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 762779 556181 822298 467111 475438 643018 792813 787738 785405 475481 820500 827835 475477 535725 537799 637870 585439 603601 784460 784508 725621 748794 809365 435452 503693 425356 486318 766572 822098 823091 822701 822712 823878 533474 540983 575862 690045 592159 811049 758136 784443 788488 810434 429520 579106 550405 806038 522636 389258 815091 538538 544462 566828 566871 682179 610030 587268 602995 804374 808042 784455 764748 479021 518733 739877 793447 816372 820637 821730 538132 559745 583492 710398 599606 600871 636419 810426 811418 784363 737305 770445 771644 632172 717158 522634 704339 782659 719946 796234 747023 821162 820845 821196 822495 820583 822630 826883 557604 566583 575954 652122 671374 682943 673779 602177 600741 596937 784510 804657 801101 766737 770945 764955 474553 719968 799555 719955 822153 820952 820844 ] |
||||||||||||||||||||||||||||||
|
2.53 ms (1.33%) |
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 389258 425356 429520 435452 467111 474553 475438 475477 475481 479021 486318 503693 518733 522634 522636 533474 535725 537799 538132 538538 540983 544462 550405 556181 557604 559745 566583 566828 566871 575862 575954 579106 583492 585439 587268 592159 596937 599606 600741 600871 602177 602995 603601 610030 632172 636419 637870 643018 652122 671374 673779 682179 682943 690045 704339 710398 717158 719946 719955 719968 725621 737305 739877 747023 748794 758136 762779 764748 764955 766572 766737 770945 771644 782659 784363 784443 784455 784460 784508 784510 785405 787738 788488 792813 793447 796234 799555 801101 804374 804657 806038 808042 809365 810426 810434 811049 811418 815091 816372 820500 820583 820637 820844 820845 820952 821162 821196 821730 822098 822153 822298 822495 822630 822701 822712 823091 823878 826883 827835 ] |
||||||||||||||||||||||||||||||
|
1.85 ms (0.98%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"pov ebony"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (0.94%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.75 ms (0.92%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"пов чернокожая"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (0.86%) |
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.