Query Metrics
7
Database Queries
7
Different statements
147.40 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
121.79 ms (82.63%) |
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 37183 74239 383735 383747 384340 384514 384930 384935 385426 386257 390085 413286 419221 428216 454045 464627 468616 470866 471306 475146 475586 475592 483342 494432 494615 498199 501752 505549 509965 514210 518152 526281 527018 544951 546750 557052 557219 562104 568324 569964 570159 570170 579345 594958 606436 612414 616007 619556 631137 640895 643984 644307 644323 649082 664317 664599 664837 665906 666719 670473 670506 672664 672828 673312 679372 681246 707596 709376 710374 712804 717934 724475 726464 727549 728523 729013 729259 736417 740070 741073 741122 743955 746539 746546 750729 761250 766035 768829 777117 778555 778602 779362 782025 786346 786880 786884 789237 790469 791095 792207 792253 794490 798257 800107 800126 800129 800145 801728 803364 804130 806064 808518 812137 813745 815222 818489 819987 825189 826235 826694 ] |
||||||||||||||||||||||||||||||
|
15.27 ms (10.36%) |
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 825189 819987 815222 818489 562104 746546 384514 384935 570170 664317 729259 385426 800126 727549 800107 800129 778602 826235 782025 812137 74239 649082 766035 631137 606436 475586 514210 37183 640895 790469 470866 557052 569964 383747 612414 501752 570159 413286 664837 475592 509965 483342 672664 384930 804130 644307 664599 670506 743955 806064 768829 736417 386257 670473 801728 778555 808518 644323 724475 643984 384340 390085 468616 728523 594958 464627 666719 579345 568324 672828 792207 826694 786884 750729 494615 786880 792253 789237 800145 729013 673312 741122 803364 777117 740070 527018 544951 717934 707596 681246 813745 616007 779362 709376 471306 454045 679372 794490 741073 498199 786346 712804 665906 383735 428216 419221 619556 761250 526281 710374 798257 505549 518152 557219 791095 546750 726464 746539 475146 494432 ] |
||||||||||||||||||||||||||||||
|
3.09 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 37183 74239 383735 383747 384340 384514 384930 384935 385426 386257 390085 413286 419221 428216 454045 464627 468616 470866 471306 475146 475586 475592 483342 494432 494615 498199 501752 505549 509965 514210 518152 526281 527018 544951 546750 557052 557219 562104 568324 569964 570159 570170 579345 594958 606436 612414 616007 619556 631137 640895 643984 644307 644323 649082 664317 664599 664837 665906 666719 670473 670506 672664 672828 673312 679372 681246 707596 709376 710374 712804 717934 724475 726464 727549 728523 729013 729259 736417 740070 741073 741122 743955 746539 746546 750729 761250 766035 768829 777117 778555 778602 779362 782025 786346 786880 786884 789237 790469 791095 792207 792253 794490 798257 800107 800126 800129 800145 801728 803364 804130 806064 808518 812137 813745 815222 818489 819987 825189 826235 826694 ] |
||||||||||||||||||||||||||||||
|
1.99 ms (1.35%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"her pussy licked"
]
|
||||||||||||||||||||||||||||||
|
1.93 ms (1.31%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.78 ms (1.21%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"her pussy licked"
]
|
||||||||||||||||||||||||||||||
|
1.55 ms (1.05%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"her pussy licked"
]
|
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.