Query Metrics
7
Database Queries
7
Different statements
194.82 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
167.16 ms (85.80%) |
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 61895 123436 181420 189004 196240 274678 282038 325660 383580 386027 389997 390845 392760 392841 396245 398805 411925 413827 418485 418551 418605 420226 420753 421519 426166 427330 428364 430713 433355 435746 437939 444258 445672 447246 447661 447688 448310 450190 452488 453136 453530 454195 458855 465652 467304 469594 470934 474711 476310 477699 478011 480218 486167 486185 489141 494720 495157 502713 505995 512043 513661 515130 518843 522454 533514 538031 541332 545672 552059 554782 555885 556844 558293 560202 562109 562314 564626 565067 567605 568575 568707 569523 569861 570048 570065 573184 578477 582333 590796 594173 594760 596669 596915 599327 605122 620295 621317 624215 624935 625036 630760 631976 638429 645618 666432 677329 705767 720273 723103 730225 745257 745443 758388 766570 777063 780713 781991 785767 812943 813128 ] |
||||||||||||||||||||||||||||||
|
17.22 ms (8.84%) |
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 513661 522454 494720 533514 383580 450190 730225 398805 392841 560202 568575 567605 596915 418605 413827 445672 624935 620295 621317 478011 448310 453136 435746 426166 515130 486185 555885 562109 570048 570065 562314 569523 569861 578477 596669 594173 447688 541332 565067 624215 605122 590796 386027 189004 392760 282038 325660 61895 389997 390845 396245 418551 421519 430713 437939 420753 427330 411925 418485 420226 452488 453530 489141 467304 447661 454195 502713 505995 518843 512043 538031 495157 469594 474711 476310 486167 558293 582333 545672 568707 552059 554782 564626 573184 645618 677329 666432 705767 720273 556844 599327 631976 638429 594760 630760 780713 781991 813128 745443 758388 745257 766570 625036 723103 777063 785767 812943 428364 458855 470934 477699 196240 123436 465652 480218 181420 274678 433355 444258 447246 ] |
||||||||||||||||||||||||||||||
|
3.03 ms (1.55%) |
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 61895 123436 181420 189004 196240 274678 282038 325660 383580 386027 389997 390845 392760 392841 396245 398805 411925 413827 418485 418551 418605 420226 420753 421519 426166 427330 428364 430713 433355 435746 437939 444258 445672 447246 447661 447688 448310 450190 452488 453136 453530 454195 458855 465652 467304 469594 470934 474711 476310 477699 478011 480218 486167 486185 489141 494720 495157 502713 505995 512043 513661 515130 518843 522454 533514 538031 541332 545672 552059 554782 555885 556844 558293 560202 562109 562314 564626 565067 567605 568575 568707 569523 569861 570048 570065 573184 578477 582333 590796 594173 594760 596669 596915 599327 605122 620295 621317 624215 624935 625036 630760 631976 638429 645618 666432 677329 705767 720273 723103 730225 745257 745443 758388 766570 777063 780713 781991 785767 812943 813128 ] |
||||||||||||||||||||||||||||||
|
2.22 ms (1.14%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"man to ass"
]
|
||||||||||||||||||||||||||||||
|
1.99 ms (1.02%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.74 ms (0.89%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"мужчин жоп"
]
|
||||||||||||||||||||||||||||||
|
1.48 ms (0.76%) |
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.