Query Metrics
7
Database Queries
7
Different statements
409.52 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
208.14 ms (50.82%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"межрасов мжм секс втро"
]
|
||||||||||||||||||||||||||||||
|
178.80 ms (43.66%) |
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 44998 78926 81565 95990 96484 310295 326297 341753 385036 387545 389987 395404 395408 396504 396745 397503 399053 403171 409732 429198 443457 445928 453612 457401 491272 499894 510058 516627 516818 530034 530492 531860 532783 537671 538158 540200 540479 540528 544748 544830 545433 545766 556773 556958 584018 593075 600346 600359 600429 600955 603578 603590 604508 604572 604679 605617 606496 606520 606584 610620 616341 622582 630497 630915 631101 631150 632851 634213 634216 635490 636564 638547 649291 649931 650786 651039 651259 653392 653912 654183 654291 655608 656301 662071 665852 666575 678128 690885 696250 709915 711288 716879 719391 719852 720258 720911 730206 732696 733071 741307 742452 743066 745051 747729 767190 788194 789677 790753 801899 804508 807847 807981 808047 814574 815285 817131 820662 826232 827875 828758 ] |
||||||||||||||||||||||||||||||
|
14.70 ms (3.59%) |
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 593075 767190 656301 690885 634213 828758 531860 530034 719391 789677 720258 630497 603590 606496 556958 510058 603578 732696 654291 742452 807847 801899 733071 788194 387545 604679 326297 385036 44998 96484 396745 399053 814574 622582 499894 396504 78926 397503 540479 650786 651259 719852 545766 747729 443457 516818 820662 826232 457401 584018 600359 632851 808047 341753 651039 653912 604572 634216 600955 631101 631150 716879 81565 491272 544748 743066 389987 827875 556773 730206 395408 807981 804508 445928 530492 537671 604508 600429 605617 666575 635490 600346 544830 649291 662071 678128 532783 630915 95990 403171 409732 815285 453612 538158 540528 653392 610620 616341 638547 606520 720911 395404 636564 817131 516627 654183 665852 696250 649931 545433 741307 745051 606584 429198 310295 540200 655608 711288 709915 790753 ] |
||||||||||||||||||||||||||||||
|
2.73 ms (0.67%) |
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 44998 78926 81565 95990 96484 310295 326297 341753 385036 387545 389987 395404 395408 396504 396745 397503 399053 403171 409732 429198 443457 445928 453612 457401 491272 499894 510058 516627 516818 530034 530492 531860 532783 537671 538158 540200 540479 540528 544748 544830 545433 545766 556773 556958 584018 593075 600346 600359 600429 600955 603578 603590 604508 604572 604679 605617 606496 606520 606584 610620 616341 622582 630497 630915 631101 631150 632851 634213 634216 635490 636564 638547 649291 649931 650786 651039 651259 653392 653912 654183 654291 655608 656301 662071 665852 666575 678128 690885 696250 709915 711288 716879 719391 719852 720258 720911 730206 732696 733071 741307 742452 743066 745051 747729 767190 788194 789677 790753 801899 804508 807847 807981 808047 814574 815285 817131 820662 826232 827875 828758 ] |
||||||||||||||||||||||||||||||
|
1.95 ms (0.48%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"interracial mmf"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (0.42%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.48 ms (0.36%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.