Query Metrics
7
Database Queries
7
Different statements
197.30 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
168.62 ms (85.46%) |
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 80900 382073 405860 414753 423384 427007 432618 432690 432732 432744 434429 434767 434801 440390 440889 441708 442107 442524 444672 446999 449735 451074 452812 453268 453504 457431 461757 468029 468239 468395 469945 480829 481410 484806 488529 497850 502636 508262 510474 512011 513369 518146 518244 520114 522990 525331 530014 531100 545221 553256 554495 554648 564994 568420 579547 582708 592315 592830 604635 604688 605055 606604 611006 613598 616643 620224 626351 626551 632747 635169 643319 650098 658793 659423 669634 672526 677112 679561 683143 691166 693884 701170 703915 708905 710377 715563 717839 721869 730507 742356 745981 755721 756659 758869 759599 760313 762330 762867 769039 769585 769916 774799 776277 777026 782738 788026 790389 790409 796283 801064 801322 801917 804640 805258 805259 805302 810767 811076 811993 813987 ] |
||||||||||||||||||||||||||||||
|
17.72 ms (8.98%) |
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 423384 440390 451074 452812 480829 453268 461757 531100 564994 553256 579547 658793 715563 605055 620224 790389 759599 742356 721869 801322 811076 432618 434767 434429 441708 444672 518146 80900 382073 442107 813987 446999 468239 530014 554648 650098 679561 701170 659423 669634 683143 691166 717839 672526 677112 693884 703915 710377 592315 626351 632747 613598 643319 592830 616643 796283 805258 804640 758869 762330 769039 788026 730507 745981 760313 769585 769916 755721 756659 762867 604635 604688 708905 782738 801064 805302 810767 449735 468029 481410 414753 484806 508262 512011 606604 611006 805259 405860 510474 568420 635169 626551 801917 469945 502636 520114 522990 488529 518244 442524 468395 774799 525331 432690 457431 513369 497850 545221 554495 811993 453504 427007 790409 776277 777026 434801 582708 432732 432744 440889 ] |
||||||||||||||||||||||||||||||
|
3.30 ms (1.67%) |
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 80900 382073 405860 414753 423384 427007 432618 432690 432732 432744 434429 434767 434801 440390 440889 441708 442107 442524 444672 446999 449735 451074 452812 453268 453504 457431 461757 468029 468239 468395 469945 480829 481410 484806 488529 497850 502636 508262 510474 512011 513369 518146 518244 520114 522990 525331 530014 531100 545221 553256 554495 554648 564994 568420 579547 582708 592315 592830 604635 604688 605055 606604 611006 613598 616643 620224 626351 626551 632747 635169 643319 650098 658793 659423 669634 672526 677112 679561 683143 691166 693884 701170 703915 708905 710377 715563 717839 721869 730507 742356 745981 755721 756659 758869 759599 760313 762330 762867 769039 769585 769916 774799 776277 777026 782738 788026 790389 790409 796283 801064 801322 801917 804640 805258 805259 805302 810767 811076 811993 813987 ] |
||||||||||||||||||||||||||||||
|
2.40 ms (1.22%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"cumshot big ass"
]
|
||||||||||||||||||||||||||||||
|
1.92 ms (0.97%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"cumshot большая большие жоп"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (0.92%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"cumshot большая большие жоп"
]
|
||||||||||||||||||||||||||||||
|
1.52 ms (0.77%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.