Query Metrics
7
Database Queries
7
Different statements
167.92 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
135.60 ms (80.75%) |
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 12351 385007 386721 389347 418545 419851 420557 423839 426006 428685 434491 439581 441646 442280 446833 447337 449333 454300 454550 455589 460040 462070 464627 479878 482590 487297 490060 491353 501615 507013 513682 515379 515732 521903 521972 525425 539548 548074 556643 565510 565730 576499 576501 585518 588646 588944 590103 594607 601602 608800 609939 624858 660272 661333 663415 663520 664958 665500 666418 669251 671837 672878 674826 679453 680584 680616 686779 687571 707434 714927 715355 716374 717436 722192 725582 727545 728937 729284 730932 736345 738066 739899 740101 741073 742035 744140 747257 757512 760632 761250 761318 761809 764005 776503 778658 785922 798945 800622 801383 803216 803451 803472 804395 804494 807381 810726 814376 815222 816087 816925 817312 818157 818878 820489 820610 822295 824892 826651 826977 826987 ] |
||||||||||||||||||||||||||||||
|
22.14 ms (13.18%) |
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 804494 826651 804395 491353 818878 576499 680616 590103 588944 810726 742035 760632 727545 729284 741073 785922 798945 507013 556643 447337 818157 482590 418545 817312 548074 454550 515732 565510 624858 594607 441646 426006 822295 513682 501615 462070 666418 674826 672878 601602 776503 803451 764005 740101 757512 722192 778658 803472 423839 428685 460040 455589 521903 521972 515379 820489 826987 665500 669251 420557 816925 826977 717436 663520 686779 687571 609939 807381 730932 386721 442280 464627 446833 679453 715355 565730 585518 588646 761318 479878 525425 439581 671837 814376 449333 738066 490060 707434 714927 747257 539548 663415 801383 389347 419851 385007 820610 824892 454300 576501 660272 661333 680584 664958 716374 736345 800622 761250 761809 728937 739899 608800 12351 803216 744140 815222 725582 434491 816087 487297 ] |
||||||||||||||||||||||||||||||
|
3.03 ms (1.80%) |
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 12351 385007 386721 389347 418545 419851 420557 423839 426006 428685 434491 439581 441646 442280 446833 447337 449333 454300 454550 455589 460040 462070 464627 479878 482590 487297 490060 491353 501615 507013 513682 515379 515732 521903 521972 525425 539548 548074 556643 565510 565730 576499 576501 585518 588646 588944 590103 594607 601602 608800 609939 624858 660272 661333 663415 663520 664958 665500 666418 669251 671837 672878 674826 679453 680584 680616 686779 687571 707434 714927 715355 716374 717436 722192 725582 727545 728937 729284 730932 736345 738066 739899 740101 741073 742035 744140 747257 757512 760632 761250 761318 761809 764005 776503 778658 785922 798945 800622 801383 803216 803451 803472 804395 804494 807381 810726 814376 815222 816087 816925 817312 818157 818878 820489 820610 822295 824892 826651 826977 826987 ] |
||||||||||||||||||||||||||||||
|
1.95 ms (1.16%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.86 ms (1.11%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big pussy licking"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (1.03%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большие pussy лиза"
]
|
||||||||||||||||||||||||||||||
|
1.62 ms (0.96%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие pussy лиза"
]
|
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.