Query Metrics
7
Database Queries
7
Different statements
179.31 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
153.66 ms (85.69%) |
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 386493 389273 396881 397622 401059 402887 406390 413446 417618 418272 418757 421100 422495 423540 423600 433953 434330 434895 435047 437807 439694 443645 446649 449292 451216 455451 456219 460073 463722 478679 480655 484067 486607 486990 488941 489042 490500 492957 500710 520325 524632 526158 540344 549565 555053 555810 561303 561521 562737 577724 582474 584693 588005 591564 599307 599322 602424 608367 609564 610716 612263 625713 626471 631120 631581 636566 641445 653969 664201 670622 682923 686845 707480 708153 715834 717603 717826 720164 724556 725303 731626 733236 739926 748607 751715 758448 760683 762666 764922 766547 767683 772796 773508 774271 775127 777090 779806 780191 780599 781197 782662 784111 789783 790753 793466 796581 799397 799435 802640 805128 806378 807663 807860 809657 810492 810783 811280 811335 811369 818071 ] |
||||||||||||||||||||||||||||||
|
15.57 ms (8.68%) |
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 636566 602424 625713 789783 731626 809657 762666 766547 775127 780599 796581 807663 422495 449292 486990 396881 406390 488941 717603 555810 811335 802640 806378 540344 664201 653969 555053 599307 782662 799397 779806 780191 790753 805128 748607 764922 631120 777090 434895 423600 386493 577724 715834 588005 599322 641445 811369 733236 739926 767683 418272 526158 492957 561521 610716 443645 451216 520325 561303 455451 439694 500710 490500 413446 446649 480655 460073 584693 549565 682923 686845 708153 562737 591564 612263 626471 631581 781197 799435 807860 810783 774271 725303 751715 760683 772796 758448 793466 810492 811280 433953 478679 437807 435047 397622 421100 423540 417618 434330 818071 463722 456219 484067 582474 670622 720164 707480 717826 609564 784111 724556 773508 608367 389273 402887 418757 486607 489042 524632 401059 ] |
||||||||||||||||||||||||||||||
|
2.40 ms (1.34%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sloppy tits"
]
|
||||||||||||||||||||||||||||||
|
2.36 ms (1.32%) |
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 386493 389273 396881 397622 401059 402887 406390 413446 417618 418272 418757 421100 422495 423540 423600 433953 434330 434895 435047 437807 439694 443645 446649 449292 451216 455451 456219 460073 463722 478679 480655 484067 486607 486990 488941 489042 490500 492957 500710 520325 524632 526158 540344 549565 555053 555810 561303 561521 562737 577724 582474 584693 588005 591564 599307 599322 602424 608367 609564 610716 612263 625713 626471 631120 631581 636566 641445 653969 664201 670622 682923 686845 707480 708153 715834 717603 717826 720164 724556 725303 731626 733236 739926 748607 751715 758448 760683 762666 764922 766547 767683 772796 773508 774271 775127 777090 779806 780191 780599 781197 782662 784111 789783 790753 793466 796581 799397 799435 802640 805128 806378 807663 807860 809657 810492 810783 811280 811335 811369 818071 ] |
||||||||||||||||||||||||||||||
|
1.85 ms (1.03%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"sloppy сиськ"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (0.97%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.72 ms (0.96%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"sloppy сиськ"
]
|
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.