Query Metrics
7
Database Queries
7
Different statements
157.26 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
129.31 ms (82.23%) |
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 7365 263144 383700 386044 389319 453742 464235 487449 529857 540542 544127 547479 548941 559212 575625 577512 585372 585992 592180 605012 605067 610923 618761 620554 627142 627418 632111 641328 653488 654918 656283 656590 657205 662078 673776 678909 685934 692505 692528 692818 693628 699589 703713 710379 712580 712718 713667 714830 721710 723219 725106 725151 725515 727501 727777 728713 729115 731679 733454 733668 735834 736682 736918 739124 739390 743015 743748 743961 744260 746242 747409 749608 750712 752587 755840 756091 761125 761740 762085 762912 766856 769100 769787 769846 773417 777409 778115 778298 780571 782041 782519 784066 784170 784364 785847 786496 787868 788550 792761 793818 795688 799995 800304 801263 801290 805773 807394 808002 808401 811689 812738 815978 816889 817786 818753 820542 822048 824938 827923 ] |
||||||||||||||||||||||||||||||
|
15.78 ms (10.04%) |
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 632111 605067 641328 777409 782041 787868 807394 725106 727501 728713 739390 746242 731679 739124 755840 757048 769100 735834 743748 761740 762912 766856 773417 725515 736918 744260 749608 610923 710379 714830 721710 784066 801263 820542 653488 712718 620554 618761 805773 792761 736682 487449 263144 824938 817786 816889 559212 577512 547479 656590 657205 692528 592180 585992 627142 799995 801290 808401 778298 785847 808002 811689 733454 752587 793818 750712 769787 762085 729115 733668 743015 747409 723219 784170 784364 786496 386044 383700 544127 678909 703713 712580 548941 585372 780571 800304 756091 761125 782519 812738 693628 453742 7365 389319 818753 815978 822048 827923 529857 540542 464235 575625 654918 673776 685934 656283 692505 699589 713667 662078 692818 627418 605012 778115 795688 727777 743961 769846 788550 725151 ] |
||||||||||||||||||||||||||||||
|
3.34 ms (2.13%) |
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 7365 263144 383700 386044 389319 453742 464235 487449 529857 540542 544127 547479 548941 559212 575625 577512 585372 585992 592180 605012 605067 610923 618761 620554 627142 627418 632111 641328 653488 654918 656283 656590 657205 662078 673776 678909 685934 692505 692528 692818 693628 699589 703713 710379 712580 712718 713667 714830 721710 723219 725106 725151 725515 727501 727777 728713 729115 731679 733454 733668 735834 736682 736918 739124 739390 743015 743748 743961 744260 746242 747409 749608 750712 752587 755840 756091 761125 761740 762085 762912 766856 769100 769787 769846 773417 777409 778115 778298 780571 782041 782519 784066 784170 784364 785847 786496 787868 788550 792761 793818 795688 799995 800304 801263 801290 805773 807394 808002 808401 811689 812738 815978 816889 817786 818753 820542 822048 824938 827923 ] |
||||||||||||||||||||||||||||||
|
3.18 ms (2.02%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"her жоп"
]
|
||||||||||||||||||||||||||||||
|
2.02 ms (1.29%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"in her ass"
]
|
||||||||||||||||||||||||||||||
|
1.92 ms (1.22%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"her жоп"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (1.08%) |
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.