Query Metrics
7
Database Queries
7
Different statements
178.90 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
149.56 ms (83.60%) |
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 396447 413418 414212 421838 421845 421853 421885 421917 421977 439756 450300 450585 451505 452131 452551 454508 457468 466907 469054 470076 470522 472691 478377 480331 480724 481484 482342 483644 483738 484696 496143 498305 504083 508204 508505 511819 512459 513826 516485 521129 521220 523130 523465 524486 533736 534550 534839 538773 547976 549842 566766 569220 571399 583476 594534 596684 596941 599203 602644 603236 604265 605382 607549 610193 615511 618514 620731 620891 641212 656575 663523 668975 674177 686807 689521 691209 693941 695333 705310 710410 712555 728375 736265 736316 749694 751120 757566 761850 763437 764116 765628 767136 767224 773553 773911 775172 775684 782512 786049 787943 789782 792185 795685 796945 798529 799289 801305 802369 803120 807435 810297 811711 811993 813276 814968 816629 817492 818368 826015 826248 ] |
||||||||||||||||||||||||||||||
|
17.40 ms (9.73%) |
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 749694 773911 603236 594534 767224 470076 504083 728375 421853 396447 484696 596941 547976 607549 618514 813276 798529 761850 751120 472691 496143 521129 615511 602644 641212 795685 799289 789782 803120 811711 663523 693941 691209 605382 450300 413418 818368 826015 450585 451505 583476 674177 686807 695333 705310 604265 782512 736265 767136 773553 787943 736316 757566 764116 775172 469054 481484 470522 512459 566766 668975 796945 807435 792185 765628 452551 457468 482342 421917 478377 480331 508505 710410 775684 513826 480724 620731 712555 452131 421977 534550 599203 439756 421845 826248 483738 538773 689521 620891 811993 454508 521220 523465 816629 814968 817492 533736 610193 786049 801305 483644 569220 802369 466907 810297 421885 524486 763437 498305 511819 596684 421838 516485 523130 414212 508204 534839 571399 656575 549842 ] |
||||||||||||||||||||||||||||||
|
4.00 ms (2.23%) |
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 396447 413418 414212 421838 421845 421853 421885 421917 421977 439756 450300 450585 451505 452131 452551 454508 457468 466907 469054 470076 470522 472691 478377 480331 480724 481484 482342 483644 483738 484696 496143 498305 504083 508204 508505 511819 512459 513826 516485 521129 521220 523130 523465 524486 533736 534550 534839 538773 547976 549842 566766 569220 571399 583476 594534 596684 596941 599203 602644 603236 604265 605382 607549 610193 615511 618514 620731 620891 641212 656575 663523 668975 674177 686807 689521 691209 693941 695333 705310 710410 712555 728375 736265 736316 749694 751120 757566 761850 763437 764116 765628 767136 767224 773553 773911 775172 775684 782512 786049 787943 789782 792185 795685 796945 798529 799289 801305 802369 803120 807435 810297 811711 811993 813276 814968 816629 817492 818368 826015 826248 ] |
||||||||||||||||||||||||||||||
|
2.11 ms (1.18%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"домашн любительск анал рыжая"
]
|
||||||||||||||||||||||||||||||
|
2.06 ms (1.15%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.00 ms (1.12%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"homemade anal redhead"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (0.99%) |
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.