Query Metrics
7
Database Queries
7
Different statements
159.54 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
136.28 ms (85.42%) |
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 14216 382212 386959 389770 391819 391850 391932 397950 398984 402233 402887 413898 414653 414967 418297 424072 424092 425295 427025 427076 427129 435799 438983 438987 439055 444666 445808 446239 448765 450383 455597 456121 456741 461233 466594 470141 477369 477739 481297 485799 485954 487163 494573 497042 503512 516175 521499 522655 533739 543566 555125 561244 581453 593181 595658 596665 600142 601410 619564 621955 626489 629446 636208 639720 651955 661512 661650 663330 675585 675831 679685 683305 693145 701283 703504 709635 712870 715167 719829 723127 731669 733958 738347 739248 743711 744903 750384 753665 761789 762076 762666 763128 766903 775580 777266 778739 779632 780026 780853 780925 782941 784208 784697 788442 789768 789869 790552 791139 792338 792515 803038 804824 805623 807281 809305 810388 816154 824712 825487 827094 ] |
||||||||||||||||||||||||||||||
|
13.42 ms (8.41%) |
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 14216 438983 775580 780925 424072 780853 715167 675831 593181 809305 789768 739248 803038 497042 446239 427076 487163 639720 601410 693145 750384 703504 522655 827094 780026 792338 805623 779632 733958 683305 424092 470141 414653 543566 663330 445808 533739 414967 485799 398984 675585 723127 581453 391850 450383 629446 402233 651955 709635 784208 804824 621955 782941 778739 413898 456741 418297 701283 382212 494573 516175 391819 397950 477739 816154 824712 719829 807281 744903 792515 391932 389770 825487 790552 763128 777266 784697 427025 448765 485954 738347 481297 555125 561244 595658 743711 753665 712870 661512 600142 438987 466594 521499 596665 766903 731669 791139 661650 679685 619564 636208 626489 789869 810388 761789 762666 762076 435799 456121 455597 427129 439055 477369 503512 788442 425295 402887 386959 444666 461233 ] |
||||||||||||||||||||||||||||||
|
3.35 ms (2.10%) |
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 14216 382212 386959 389770 391819 391850 391932 397950 398984 402233 402887 413898 414653 414967 418297 424072 424092 425295 427025 427076 427129 435799 438983 438987 439055 444666 445808 446239 448765 450383 455597 456121 456741 461233 466594 470141 477369 477739 481297 485799 485954 487163 494573 497042 503512 516175 521499 522655 533739 543566 555125 561244 581453 593181 595658 596665 600142 601410 619564 621955 626489 629446 636208 639720 651955 661512 661650 663330 675585 675831 679685 683305 693145 701283 703504 709635 712870 715167 719829 723127 731669 733958 738347 739248 743711 744903 750384 753665 761789 762076 762666 763128 766903 775580 777266 778739 779632 780026 780853 780925 782941 784208 784697 788442 789768 789869 790552 791139 792338 792515 803038 804824 805623 807281 809305 810388 816154 824712 825487 827094 ] |
||||||||||||||||||||||||||||||
|
1.75 ms (1.10%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"russian deep throat"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (1.05%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.57 ms (0.98%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"русск глубокийминет минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.50 ms (0.94%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.