Query Metrics
7
Database Queries
7
Different statements
212.91 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
181.50 ms (85.25%) |
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 80529 233112 397772 409121 410229 413909 427946 428886 430696 431312 442280 453379 455579 456421 457000 463837 465066 466123 472922 474306 481999 483452 486793 494717 496854 498424 512984 516050 533339 556643 567110 569836 577089 578423 578430 582205 586558 592428 593043 594896 604854 605595 606639 609806 615031 615740 644253 660748 665789 669276 675677 679453 681293 710297 715879 716052 716239 720775 726723 727505 729587 730825 730938 732747 733317 744225 744468 765299 766071 767183 767699 770192 771999 772675 781818 784837 785530 788233 788957 789596 794459 794632 795008 795020 799256 799601 800188 801011 801888 802334 802437 802486 803149 803176 803249 804511 805128 805315 805992 806119 808614 811490 811745 812316 813442 814399 814431 815411 815770 815920 817456 817628 818274 818335 818403 820380 824403 824658 824803 824861 ] |
||||||||||||||||||||||||||||||
|
20.29 ms (9.53%) |
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 593043 455579 465066 413909 428886 824403 665789 644253 802437 803249 727505 609806 410229 814431 594896 803176 818335 818403 472922 604854 799256 784837 811490 811745 766071 732747 765299 466123 801011 730938 397772 409121 817628 824803 815920 720775 592428 789596 805315 788233 788957 794459 802334 812316 729587 726723 744225 772675 795020 233112 767699 716239 803149 824658 427946 463837 578423 781818 805992 800188 716052 431312 815411 817456 820380 818274 710297 715879 606639 802486 804511 808614 801888 744468 730825 805128 494717 512984 533339 516050 556643 569836 605595 615740 457000 483452 496854 771999 795008 806119 442280 430696 814399 481999 486793 498424 474306 567110 577089 578430 675677 679453 669276 660748 681293 582205 586558 785530 794632 799601 813442 767183 770192 733317 615031 453379 456421 80529 815770 824861 ] |
||||||||||||||||||||||||||||||
|
3.78 ms (1.77%) |
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 80529 233112 397772 409121 410229 413909 427946 428886 430696 431312 442280 453379 455579 456421 457000 463837 465066 466123 472922 474306 481999 483452 486793 494717 496854 498424 512984 516050 533339 556643 567110 569836 577089 578423 578430 582205 586558 592428 593043 594896 604854 605595 606639 609806 615031 615740 644253 660748 665789 669276 675677 679453 681293 710297 715879 716052 716239 720775 726723 727505 729587 730825 730938 732747 733317 744225 744468 765299 766071 767183 767699 770192 771999 772675 781818 784837 785530 788233 788957 789596 794459 794632 795008 795020 799256 799601 800188 801011 801888 802334 802437 802486 803149 803176 803249 804511 805128 805315 805992 806119 808614 811490 811745 812316 813442 814399 814431 815411 815770 815920 817456 817628 818274 818335 818403 820380 824403 824658 824803 824861 ] |
||||||||||||||||||||||||||||||
|
2.21 ms (1.04%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"lick ass milf"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (0.86%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.67 ms (0.79%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"лиза жоп milf"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (0.77%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"лиза жоп milf"
]
|
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.