Query Metrics
7
Database Queries
7
Different statements
149.88 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
121.23 ms (80.89%) |
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 96269 187938 233187 305931 383842 384289 385389 386408 387287 387510 388325 388757 389518 389966 390881 391911 391917 391945 391994 392007 392238 395659 396218 396989 397352 397780 400942 401122 401342 401426 401615 401830 402266 402678 404418 404831 405056 405990 406128 410517 413057 415128 418522 421696 421977 426571 429886 430792 434334 439171 439518 444654 445066 445619 445731 445787 448793 450455 451302 457492 457500 457516 458926 459149 464161 464959 467872 468097 471012 473223 475799 476138 478427 478480 478774 493411 494999 506835 522148 545342 551117 551962 552638 568287 584004 585726 592440 594340 605256 605329 618460 621675 622980 626566 637647 644323 649947 651685 671701 681298 692732 699540 703533 720375 720397 723480 748549 762285 773577 780724 801471 802062 815120 815814 816266 817119 818867 820890 823341 825514 ] |
||||||||||||||||||||||||||||||
|
17.77 ms (11.86%) |
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 621675 478480 404418 389966 457500 471012 506835 681298 413057 429886 457492 388325 402678 401615 723480 391945 426571 818867 626566 816266 815120 699540 622980 397352 651685 637647 395659 389518 445787 391994 493411 592440 418522 585726 387510 387287 748549 401426 405990 421977 415128 451302 618460 233187 421696 396218 96269 434334 402266 445066 468097 494999 385389 305931 823341 478427 762285 392238 390881 444654 401830 401122 820890 825514 552638 605329 802062 773577 464161 815814 703533 720375 605256 396989 388757 391917 450455 401342 391911 430792 392007 467872 644323 584004 448793 551962 594340 439518 384289 400942 406128 473223 522148 383842 187938 397780 404831 459149 545342 671701 692732 457516 780724 386408 801471 817119 445731 551117 649947 720397 405056 410517 439171 475799 445619 478774 464959 476138 568287 458926 ] |
||||||||||||||||||||||||||||||
|
3.57 ms (2.38%) |
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 96269 187938 233187 305931 383842 384289 385389 386408 387287 387510 388325 388757 389518 389966 390881 391911 391917 391945 391994 392007 392238 395659 396218 396989 397352 397780 400942 401122 401342 401426 401615 401830 402266 402678 404418 404831 405056 405990 406128 410517 413057 415128 418522 421696 421977 426571 429886 430792 434334 439171 439518 444654 445066 445619 445731 445787 448793 450455 451302 457492 457500 457516 458926 459149 464161 464959 467872 468097 471012 473223 475799 476138 478427 478480 478774 493411 494999 506835 522148 545342 551117 551962 552638 568287 584004 585726 592440 594340 605256 605329 618460 621675 622980 626566 637647 644323 649947 651685 671701 681298 692732 699540 703533 720375 720397 723480 748549 762285 773577 780724 801471 802062 815120 815814 816266 817119 818867 820890 823341 825514 ] |
||||||||||||||||||||||||||||||
|
2.22 ms (1.48%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"hairy anal brunette"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (1.25%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.66 ms (1.11%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"волосатая анал черноволосая"
]
|
||||||||||||||||||||||||||||||
|
1.54 ms (1.03%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.