Query Metrics
7
Database Queries
7
Different statements
157.97 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
127.96 ms (81.00%) |
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 3444 3786 7329 14320 77381 129955 383375 390845 395246 395275 398434 418084 421732 427591 437486 438551 447813 452390 453092 453417 453882 457191 457743 461119 465518 475466 475691 477069 478111 486623 496808 499995 500945 504517 508265 510862 512547 512946 513071 522277 522693 524787 526459 526683 528756 529026 529394 534826 538757 538772 544014 551779 554494 554731 565011 565676 567118 580624 588018 592009 603074 606511 607459 609696 617398 620509 622649 627206 627766 628596 629387 629602 629891 629912 629932 634100 635020 636550 656301 658819 660340 668784 669672 677120 682373 691479 695307 698575 708052 708194 708254 708878 709340 710905 711672 713171 714070 717235 721910 726648 731463 742065 750588 751357 757134 757234 760917 763810 770109 778204 782389 794435 797228 797392 799964 803960 809607 818576 825454 827093 ] |
||||||||||||||||||||||||||||||
|
18.65 ms (11.80%) |
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 742065 751357 757134 622649 627206 636550 708878 709340 713171 778204 782389 794435 797228 508265 7329 453092 478111 554731 731463 457191 528756 427591 551779 592009 390845 437486 475466 475691 447813 453882 496808 529394 512946 500945 522277 580624 617398 418084 3444 526459 544014 629387 629932 797392 3786 77381 809607 750588 465518 524787 522693 770109 760917 763810 629891 827093 818576 395246 129955 14320 588018 513071 421732 510862 504517 383375 477069 453417 565676 565011 499995 825454 658819 629912 607459 629602 634100 603074 627766 757234 799964 803960 726648 486623 395275 398434 438551 461119 452390 457743 526683 538772 512547 529026 534826 538757 668784 682373 708194 708254 710905 721910 660340 669672 677120 691479 695307 708052 656301 698575 711672 714070 717235 554494 567118 628596 609696 620509 635020 606511 ] |
||||||||||||||||||||||||||||||
|
2.72 ms (1.72%) |
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 3444 3786 7329 14320 77381 129955 383375 390845 395246 395275 398434 418084 421732 427591 437486 438551 447813 452390 453092 453417 453882 457191 457743 461119 465518 475466 475691 477069 478111 486623 496808 499995 500945 504517 508265 510862 512547 512946 513071 522277 522693 524787 526459 526683 528756 529026 529394 534826 538757 538772 544014 551779 554494 554731 565011 565676 567118 580624 588018 592009 603074 606511 607459 609696 617398 620509 622649 627206 627766 628596 629387 629602 629891 629912 629932 634100 635020 636550 656301 658819 660340 668784 669672 677120 682373 691479 695307 698575 708052 708194 708254 708878 709340 710905 711672 713171 714070 717235 721910 726648 731463 742065 750588 751357 757134 757234 760917 763810 770109 778204 782389 794435 797228 797392 799964 803960 809607 818576 825454 827093 ] |
||||||||||||||||||||||||||||||
|
2.34 ms (1.48%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
b"большие жопи подборкÐâ…"
]
|
||||||||||||||||||||||||||||||
|
2.19 ms (1.39%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большая большие жоп подборк"
]
|
||||||||||||||||||||||||||||||
|
2.15 ms (1.36%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большая большие жоп подборк"
]
|
||||||||||||||||||||||||||||||
|
1.96 ms (1.24%) |
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.