Query Metrics
7
Database Queries
7
Different statements
156.33 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
127.38 ms (81.48%) |
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 10171 370039 382750 382941 383247 383791 384082 385388 385728 386269 386923 387566 388450 390134 411884 415518 415523 415527 420082 428115 432796 443715 451718 454806 457159 462372 467608 469357 474771 486438 502247 506787 510562 516004 516957 519184 527282 527502 527519 527525 527536 528997 529040 530489 530643 545607 550410 564214 566018 579318 580214 582778 585431 587511 591357 592478 592724 597951 600013 605300 605317 607954 608430 609864 614993 622049 622398 624784 629359 630030 634522 634550 634560 636987 637016 637134 637426 647626 648595 664235 671101 673125 675480 677296 689592 695316 704526 710197 716143 720711 721695 725310 725342 730077 731814 732277 744016 750727 753072 756544 758476 758540 766723 766756 772721 773654 773986 773989 774410 775755 782425 788166 792184 792534 792564 792772 792807 802478 810218 810220 ] |
||||||||||||||||||||||||||||||
|
19.19 ms (12.28%) |
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 591357 587511 720711 695316 597951 516004 592724 637426 469357 647626 636987 530643 580214 411884 510562 545607 600013 579318 506787 519184 585431 530489 592478 704526 629359 486438 462372 614993 637016 622398 457159 467608 502247 677296 10171 773986 370039 782425 766756 775755 689592 730077 673125 383791 527525 550410 716143 529040 443715 451718 732277 527502 564214 607954 622049 624784 792564 527282 382941 385388 385728 383247 387566 527536 566018 710197 605300 773654 773989 386923 415527 792534 788166 648595 582778 810220 725310 792772 750727 753072 774410 528997 516957 675480 630030 605317 609864 802478 766723 772721 721695 386269 731814 420082 454806 390134 637134 388450 671101 725342 432796 474771 664235 634550 634560 608430 634522 744016 758476 792184 810218 756544 792807 415518 415523 428115 527519 758540 384082 382750 ] |
||||||||||||||||||||||||||||||
|
2.34 ms (1.49%) |
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 10171 370039 382750 382941 383247 383791 384082 385388 385728 386269 386923 387566 388450 390134 411884 415518 415523 415527 420082 428115 432796 443715 451718 454806 457159 462372 467608 469357 474771 486438 502247 506787 510562 516004 516957 519184 527282 527502 527519 527525 527536 528997 529040 530489 530643 545607 550410 564214 566018 579318 580214 582778 585431 587511 591357 592478 592724 597951 600013 605300 605317 607954 608430 609864 614993 622049 622398 624784 629359 630030 634522 634550 634560 636987 637016 637134 637426 647626 648595 664235 671101 673125 675480 677296 689592 695316 704526 710197 716143 720711 721695 725310 725342 730077 731814 732277 744016 750727 753072 756544 758476 758540 766723 766756 772721 773654 773986 773989 774410 775755 782425 788166 792184 792534 792564 792772 792807 802478 810218 810220 ] |
||||||||||||||||||||||||||||||
|
2.14 ms (1.37%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.96 ms (1.25%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"ass casting"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (1.06%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"жоп кастинг"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (1.06%) |
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.