Query Metrics
7
Database Queries
7
Different statements
193.55 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
168.30 ms (86.96%) |
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 40835 324555 384562 385507 385759 386062 389028 393188 394536 395162 395249 396300 399865 402788 404470 405809 408770 417953 428913 431432 444605 453711 457627 458666 460939 463868 466919 468889 470642 477577 503395 506257 516207 521565 554893 562450 564071 585073 590381 593023 603287 604008 604106 608980 614281 621631 625818 636798 639702 640457 646927 650098 652602 663203 676487 677375 685819 693286 698458 698496 703350 711909 712553 714175 715169 716828 717667 717701 718492 720536 720768 722107 723147 724048 728201 728463 729835 733872 739915 740692 743089 753395 753727 754239 761129 769754 770117 770248 773901 776328 776765 779487 779613 780410 781606 783666 785269 786443 790126 790207 790367 791679 796169 797490 799272 799590 800762 801419 801839 803590 809657 810057 811204 811428 813455 815386 818452 818802 825804 827944 ] |
||||||||||||||||||||||||||||||
|
15.15 ms (7.83%) |
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 614281 715169 776328 779613 797490 811204 389028 521565 621631 818452 753395 815386 813455 720768 769754 754239 718492 593023 652602 790126 740692 716828 677375 776765 724048 40835 396300 477577 466919 564071 457627 460939 717701 800762 739915 773901 404470 385507 324555 402788 639702 728201 761129 395162 393188 405809 399865 408770 453711 625818 803590 729835 728463 386062 640457 799272 790207 733872 712553 791679 780410 785269 444605 385759 395249 585073 516207 554893 650098 685819 603287 590381 604008 604106 796169 786443 428913 646927 809657 417953 458666 468889 470642 394536 431432 503395 818802 717667 698458 722107 562450 743089 770248 790367 770117 753727 698496 714175 720536 801419 801839 810057 811428 384562 825804 827944 463868 506257 693286 723147 676487 711909 663203 703350 608980 636798 779487 781606 783666 799590 ] |
||||||||||||||||||||||||||||||
|
2.92 ms (1.51%) |
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 40835 324555 384562 385507 385759 386062 389028 393188 394536 395162 395249 396300 399865 402788 404470 405809 408770 417953 428913 431432 444605 453711 457627 458666 460939 463868 466919 468889 470642 477577 503395 506257 516207 521565 554893 562450 564071 585073 590381 593023 603287 604008 604106 608980 614281 621631 625818 636798 639702 640457 646927 650098 652602 663203 676487 677375 685819 693286 698458 698496 703350 711909 712553 714175 715169 716828 717667 717701 718492 720536 720768 722107 723147 724048 728201 728463 729835 733872 739915 740692 743089 753395 753727 754239 761129 769754 770117 770248 773901 776328 776765 779487 779613 780410 781606 783666 785269 786443 790126 790207 790367 791679 796169 797490 799272 799590 800762 801419 801839 803590 809657 810057 811204 811428 813455 815386 818452 818802 825804 827944 ] |
||||||||||||||||||||||||||||||
|
2.08 ms (1.08%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"blowjob hard"
]
|
||||||||||||||||||||||||||||||
|
1.87 ms (0.97%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"минет оральн секс hard"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (0.83%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"минет оральн секс hard"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (0.83%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.