Query Metrics
7
Database Queries
7
Different statements
183.22 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
161.57 ms (88.18%) |
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 388506 396687 416293 418460 420130 420597 428793 438428 447384 448774 449908 459400 484934 491125 492435 492478 496661 505348 520401 522994 528848 529453 529498 533153 537044 537459 549502 555505 556546 558163 562158 568034 570391 577269 587433 587437 595739 602179 606675 607235 610171 617796 619667 621051 629596 631620 632750 632860 634729 638441 641330 641465 642271 643400 661590 664318 664816 665854 666834 668696 668809 670813 671559 682763 683840 692681 693384 700852 712188 713145 714563 715168 717137 722248 724845 733020 737307 750711 750877 751835 753485 758277 758621 760595 763569 765605 767401 768538 768650 769438 769860 769885 770237 779560 780703 787785 788456 791341 792796 795061 797878 798824 801804 802251 803807 803822 804617 805364 807403 807869 808335 808457 808980 811334 812036 812048 812317 813909 816718 819157 ] |
||||||||||||||||||||||||||||||
|
12.50 ms (6.83%) |
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 767401 753485 758277 700852 717137 788456 388506 819157 670813 587433 780703 803822 750711 768650 763569 492435 813909 562158 760595 555505 665854 666834 682763 692681 693384 632750 610171 638441 642271 602179 607235 805364 801804 617796 491125 816718 568034 671559 722248 714563 712188 587437 758621 787785 505348 537459 634729 420130 556546 577269 769438 418460 448774 492478 713145 632860 643400 795061 797878 812317 765605 769885 733020 769860 737307 664318 595739 768538 803807 807869 396687 522994 664816 631620 621051 798824 804617 484934 537044 520401 770237 428793 447384 496661 529453 533153 570391 661590 668696 619667 791341 724845 751835 641330 641465 802251 420597 449908 438428 459400 529498 558163 715168 683840 549502 606675 629596 779560 808335 808457 812036 812048 792796 811334 750877 807403 808980 416293 528848 668809 ] |
||||||||||||||||||||||||||||||
|
2.53 ms (1.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 388506 396687 416293 418460 420130 420597 428793 438428 447384 448774 449908 459400 484934 491125 492435 492478 496661 505348 520401 522994 528848 529453 529498 533153 537044 537459 549502 555505 556546 558163 562158 568034 570391 577269 587433 587437 595739 602179 606675 607235 610171 617796 619667 621051 629596 631620 632750 632860 634729 638441 641330 641465 642271 643400 661590 664318 664816 665854 666834 668696 668809 670813 671559 682763 683840 692681 693384 700852 712188 713145 714563 715168 717137 722248 724845 733020 737307 750711 750877 751835 753485 758277 758621 760595 763569 765605 767401 768538 768650 769438 769860 769885 770237 779560 780703 787785 788456 791341 792796 795061 797878 798824 801804 802251 803807 803822 804617 805364 807403 807869 808335 808457 808980 811334 812036 812048 812317 813909 816718 819157 ] |
||||||||||||||||||||||||||||||
|
1.84 ms (1.00%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"tits play"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (0.99%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"сиськ play"
]
|
||||||||||||||||||||||||||||||
|
1.51 ms (0.82%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.45 ms (0.79%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"сиськ play"
]
|
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.