Query Metrics
7
Database Queries
7
Different statements
145.98 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
119.78 ms (82.05%) |
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 381959 392607 415818 436001 437120 438316 438994 443134 443153 446396 447759 451533 452612 452770 453025 454275 455505 457020 457789 460535 461432 461767 463213 465933 466466 466554 467830 469126 469263 469271 472584 474635 477993 486623 487260 490846 490945 491738 491889 492341 494577 496758 499395 502341 504220 504499 508786 509325 509701 511376 511505 519355 519442 520171 520343 522626 523878 523907 526738 527179 531586 534943 540714 540996 544510 545860 546059 546442 546675 548621 557479 557506 560660 564855 566705 567754 571509 571939 576916 579392 579604 584885 599429 601845 614693 619535 625996 627089 629906 659472 667928 682421 682958 713945 716695 717118 719200 721996 724744 731565 743846 744413 746127 746680 751501 759345 764556 765222 778737 786716 789257 793019 794291 795363 795616 803444 805342 820199 825296 827539 ] |
||||||||||||||||||||||||||||||
|
16.93 ms (11.60%) |
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 546059 548621 765222 629906 778737 795616 461767 463213 452770 461432 436001 519355 527179 491889 466466 803444 447759 526738 540714 625996 571939 564855 571509 576916 614693 619535 446396 460535 486623 508786 522626 491738 504499 511376 381959 492341 546675 557506 713945 601845 520343 566705 467830 477993 438316 487260 499395 523878 520171 415818 793019 451533 504220 494577 534943 795363 560660 546442 579392 540996 627089 455505 825296 469271 716695 719200 764556 751501 759345 743846 721996 443153 820199 509701 519442 544510 557479 579604 437120 453025 454275 457020 469263 472584 502341 509325 531586 490945 496758 511505 466554 789257 392607 490846 452612 465933 474635 523907 827539 682958 717118 659472 794291 786716 746127 724744 744413 746680 731565 805342 469126 682421 438994 443134 457789 567754 584885 667928 545860 599429 ] |
||||||||||||||||||||||||||||||
|
3.35 ms (2.30%) |
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 381959 392607 415818 436001 437120 438316 438994 443134 443153 446396 447759 451533 452612 452770 453025 454275 455505 457020 457789 460535 461432 461767 463213 465933 466466 466554 467830 469126 469263 469271 472584 474635 477993 486623 487260 490846 490945 491738 491889 492341 494577 496758 499395 502341 504220 504499 508786 509325 509701 511376 511505 519355 519442 520171 520343 522626 523878 523907 526738 527179 531586 534943 540714 540996 544510 545860 546059 546442 546675 548621 557479 557506 560660 564855 566705 567754 571509 571939 576916 579392 579604 584885 599429 601845 614693 619535 625996 627089 629906 659472 667928 682421 682958 713945 716695 717118 719200 721996 724744 731565 743846 744413 746127 746680 751501 759345 764556 765222 778737 786716 789257 793019 794291 795363 795616 803444 805342 820199 825296 827539 ] |
||||||||||||||||||||||||||||||
|
1.51 ms (1.04%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"любительск русск подборк"
]
|
||||||||||||||||||||||||||||||
|
1.51 ms (1.03%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"amateur russian compilation"
]
|
||||||||||||||||||||||||||||||
|
1.46 ms (1.00%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.43 ms (0.98%) |
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.