Query Metrics
7
Database Queries
7
Different statements
208.20 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
179.70 ms (86.31%) |
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 278472 335462 405146 415509 417672 423531 425957 427204 428701 432256 438100 440257 440749 446303 448332 449180 449558 455623 459871 462135 465263 466786 472672 476443 478144 481545 487475 490471 492010 496220 498210 500475 502754 504991 508219 514111 514202 517580 518266 521884 523091 527312 527328 533403 534583 538114 542296 551166 554955 555234 558252 559258 560029 569574 570087 582031 588819 592293 599006 599236 599510 599754 601198 602712 606890 609187 618841 626915 627505 630723 638878 641109 644877 647212 647661 651348 664514 665082 667052 678992 685933 690516 693539 694877 698341 699871 699916 700845 708311 714755 722046 724265 729903 733145 735246 748699 750030 753645 760217 760303 760313 760595 761211 763886 766462 766473 768360 770486 777903 783399 792843 797817 798735 798852 799518 800791 804821 817485 818788 818804 ] |
||||||||||||||||||||||||||||||
|
18.16 ms (8.72%) |
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 798735 766462 748699 768360 735246 770486 627505 698341 783399 465263 498210 599510 601198 551166 665082 502754 678992 618841 455623 472672 500475 582031 647212 514111 560029 626915 417672 423531 446303 425957 438100 527312 554955 476443 335462 700845 792843 405146 466786 492010 664514 690516 693539 708311 609187 599006 760217 729903 760303 724265 760595 763886 602712 638878 798852 559258 570087 440257 518266 432256 449558 533403 508219 599236 527328 504991 517580 462135 685933 427204 440749 644877 448332 487475 514202 521884 481545 558252 555234 714755 699871 641109 800791 804821 777903 733145 761211 797817 760313 766473 496220 278472 818804 817485 534583 538114 647661 651348 694877 722046 599754 588819 630723 753645 750030 415509 459871 478144 569574 667052 592293 699916 799518 490471 523091 428701 542296 449180 818788 606890 ] |
||||||||||||||||||||||||||||||
|
2.99 ms (1.44%) |
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 278472 335462 405146 415509 417672 423531 425957 427204 428701 432256 438100 440257 440749 446303 448332 449180 449558 455623 459871 462135 465263 466786 472672 476443 478144 481545 487475 490471 492010 496220 498210 500475 502754 504991 508219 514111 514202 517580 518266 521884 523091 527312 527328 533403 534583 538114 542296 551166 554955 555234 558252 559258 560029 569574 570087 582031 588819 592293 599006 599236 599510 599754 601198 602712 606890 609187 618841 626915 627505 630723 638878 641109 644877 647212 647661 651348 664514 665082 667052 678992 685933 690516 693539 694877 698341 699871 699916 700845 708311 714755 722046 724265 729903 733145 735246 748699 750030 753645 760217 760303 760313 760595 761211 763886 766462 766473 768360 770486 777903 783399 792843 797817 798735 798852 799518 800791 804821 817485 818788 818804 ] |
||||||||||||||||||||||||||||||
|
2.28 ms (1.10%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"car big ass"
]
|
||||||||||||||||||||||||||||||
|
1.87 ms (0.90%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"вмашин большая большие жоп"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (0.80%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.52 ms (0.73%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.