Query Metrics
7
Database Queries
7
Different statements
155.60 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
131.18 ms (84.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 20190 117221 130089 130506 318318 320078 381883 383387 388091 389315 390538 393314 397192 397232 398666 401325 403966 414058 420471 467606 470273 476111 485147 488721 495218 510180 517840 541853 544848 564392 597018 601544 603172 604331 604566 613179 615900 617421 622656 629409 629886 630536 630764 632632 632650 632674 632706 633447 640858 641413 644995 645891 648819 649543 656904 666579 668527 671739 673353 673363 673366 673369 674492 684126 690809 692796 695188 695620 695930 696355 699691 705514 707262 709261 711891 714613 719335 723468 724179 738821 742015 742194 748951 756023 756092 759326 759485 760240 762257 762268 772667 775140 775787 775798 775810 775858 784308 788930 791370 792059 794817 794824 795139 801934 802610 805594 806268 809493 816568 817080 817898 818468 818516 818517 818541 819272 821532 824052 824130 827201 ] |
||||||||||||||||||||||||||||||
|
14.00 ms (9.00%) |
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 397232 738821 495218 630764 817080 632650 775810 541853 617421 705514 824052 403966 818516 818468 695188 695620 709261 604566 762268 759485 401325 564392 719335 806268 724179 476111 467606 20190 818541 673366 788930 613179 117221 630536 632632 320078 690809 615900 802610 632706 485147 668527 470273 707262 389315 388091 517840 673369 674492 629409 597018 775798 742015 772667 648819 632674 601544 792059 759326 381883 723468 622656 390538 784308 756092 756023 420471 656904 629886 775858 791370 393314 824130 827201 696355 649543 684126 809493 775140 801934 794824 130089 318318 510180 641413 794817 383387 748951 414058 819272 544848 645891 633447 488721 130506 821532 671739 604331 397192 398666 817898 818517 695930 699691 714613 666579 673363 692796 805594 760240 742194 644995 816568 673353 711891 603172 640858 775787 795139 762257 ] |
||||||||||||||||||||||||||||||
|
3.06 ms (1.97%) |
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 20190 117221 130089 130506 318318 320078 381883 383387 388091 389315 390538 393314 397192 397232 398666 401325 403966 414058 420471 467606 470273 476111 485147 488721 495218 510180 517840 541853 544848 564392 597018 601544 603172 604331 604566 613179 615900 617421 622656 629409 629886 630536 630764 632632 632650 632674 632706 633447 640858 641413 644995 645891 648819 649543 656904 666579 668527 671739 673353 673363 673366 673369 674492 684126 690809 692796 695188 695620 695930 696355 699691 705514 707262 709261 711891 714613 719335 723468 724179 738821 742015 742194 748951 756023 756092 759326 759485 760240 762257 762268 772667 775140 775787 775798 775810 775858 784308 788930 791370 792059 794817 794824 795139 801934 802610 805594 806268 809493 816568 817080 817898 818468 818516 818517 818541 819272 821532 824052 824130 827201 ] |
||||||||||||||||||||||||||||||
|
2.26 ms (1.45%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big anal gangbang"
]
|
||||||||||||||||||||||||||||||
|
1.99 ms (1.28%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.63 ms (1.05%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие анал gangbang"
]
|
||||||||||||||||||||||||||||||
|
1.47 ms (0.94%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большие анал gangbang"
]
|
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.