Query Metrics
7
Database Queries
7
Different statements
147.15 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
118.63 ms (80.62%) |
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 60843 163368 188655 191450 291689 327421 339392 383734 384092 386023 386050 389959 390241 390387 390614 393127 393129 397045 401859 402267 406330 408539 410356 412474 413712 416367 419055 419126 419139 419917 421310 422566 422609 424729 435759 445766 448536 457267 462306 465194 468616 471178 473060 473746 483560 488816 503248 512193 512216 514627 515702 519956 521122 523560 530667 532927 533691 539095 550618 551105 551888 551943 551962 552053 552891 554320 554340 554764 556409 558431 559873 559875 559897 559914 565470 569726 577064 577251 582669 583677 586635 587761 590958 590960 591278 598515 600544 609847 618712 619420 619429 619435 620498 621025 622601 623521 623614 627728 632280 634760 635484 636929 645559 649870 653843 668950 694468 705547 712169 712197 712219 715125 720879 729065 758725 768089 795074 805671 823615 827880 ] |
||||||||||||||||||||||||||||||
|
18.36 ms (12.48%) |
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 435759 416367 465194 445766 473746 473060 556409 554764 558431 559873 591278 598515 462306 488816 512216 521122 188655 291689 649870 635484 619420 386050 339392 413712 523560 623521 397045 483560 550618 327421 408539 586635 583677 383734 406330 554320 565470 653843 619435 795074 758725 609847 805671 421310 519956 622601 422609 419917 457267 551105 590960 412474 390614 389959 402267 424729 468616 515702 551962 582669 620498 621025 393127 530667 386023 163368 390241 390387 401859 419126 532927 551943 552891 712169 705547 618712 600544 636929 627728 632280 729065 768089 634760 715125 393129 384092 60843 419139 422566 512193 552053 559897 623614 590958 503248 559914 587761 823615 827880 191450 419055 410356 448536 471178 539095 533691 514627 559875 577064 551888 554340 569726 577251 645559 712219 668950 694468 712197 720879 619429 ] |
||||||||||||||||||||||||||||||
|
2.89 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 60843 163368 188655 191450 291689 327421 339392 383734 384092 386023 386050 389959 390241 390387 390614 393127 393129 397045 401859 402267 406330 408539 410356 412474 413712 416367 419055 419126 419139 419917 421310 422566 422609 424729 435759 445766 448536 457267 462306 465194 468616 471178 473060 473746 483560 488816 503248 512193 512216 514627 515702 519956 521122 523560 530667 532927 533691 539095 550618 551105 551888 551943 551962 552053 552891 554320 554340 554764 556409 558431 559873 559875 559897 559914 565470 569726 577064 577251 582669 583677 586635 587761 590958 590960 591278 598515 600544 609847 618712 619420 619429 619435 620498 621025 622601 623521 623614 627728 632280 634760 635484 636929 645559 649870 653843 668950 694468 705547 712169 712197 712219 715125 720879 729065 758725 768089 795074 805671 823615 827880 ] |
||||||||||||||||||||||||||||||
|
1.93 ms (1.31%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.92 ms (1.31%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"азиатк секс"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (1.16%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"asian fuck"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (1.16%) |
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.