Query Metrics
7
Database Queries
7
Different statements
212.65 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
178.49 ms (83.94%) |
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 383160 385491 391934 417058 421871 421890 421907 426712 426719 427010 443831 445869 453085 453089 454521 455411 456384 456432 457332 459907 460738 462700 463107 464266 464542 465384 465441 466090 466094 466112 466253 466493 467552 467700 469586 470074 470389 470547 470583 470620 470640 470641 470919 470926 470939 473321 474024 474065 474488 474673 475439 476495 477079 477707 477930 482506 482510 484419 484693 484706 484727 484728 484748 485700 485703 485735 485927 486515 487550 490261 492687 492690 500363 502144 502147 502222 504116 510742 511023 514808 517567 517568 517640 519104 520758 526426 526435 527608 530726 531316 531884 532101 543609 555972 558788 561132 562368 578411 583482 603615 603649 603673 603678 605532 635432 640136 703492 717236 718234 727814 733347 739916 742670 742683 749488 750827 760619 761088 818609 823585 ] |
||||||||||||||||||||||||||||||
|
21.47 ms (10.09%) |
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 603649 603673 603678 742683 750827 760619 749488 733347 739916 742670 761088 603615 635432 703492 717236 426712 470919 470926 473321 477930 391934 427010 456432 466253 470640 474488 470620 385491 465384 465441 470641 470547 476495 485927 502222 475439 484693 455411 477707 485735 502147 531316 530726 484728 583482 558788 640136 605532 456384 443831 454521 460738 462700 464266 466094 466112 470074 517567 484419 484706 484748 485700 510742 514808 727814 818609 562368 718234 823585 531884 527608 482506 487550 464542 477079 500363 526435 578411 421871 421890 421907 474024 470939 466090 485703 511023 484727 383160 426719 417058 482510 445869 453085 453089 466493 467552 474673 492690 457332 470583 459907 463107 469586 470389 486515 502144 517568 517640 504116 519104 526426 532101 520758 467700 474065 490261 492687 543609 555972 561132 ] |
||||||||||||||||||||||||||||||
|
4.23 ms (1.99%) |
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 383160 385491 391934 417058 421871 421890 421907 426712 426719 427010 443831 445869 453085 453089 454521 455411 456384 456432 457332 459907 460738 462700 463107 464266 464542 465384 465441 466090 466094 466112 466253 466493 467552 467700 469586 470074 470389 470547 470583 470620 470640 470641 470919 470926 470939 473321 474024 474065 474488 474673 475439 476495 477079 477707 477930 482506 482510 484419 484693 484706 484727 484728 484748 485700 485703 485735 485927 486515 487550 490261 492687 492690 500363 502144 502147 502222 504116 510742 511023 514808 517567 517568 517640 519104 520758 526426 526435 527608 530726 531316 531884 532101 543609 555972 558788 561132 562368 578411 583482 603615 603649 603673 603678 605532 635432 640136 703492 717236 718234 727814 733347 739916 742670 742683 749488 750827 760619 761088 818609 823585 ] |
||||||||||||||||||||||||||||||
|
2.49 ms (1.17%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"swingers mature"
]
|
||||||||||||||||||||||||||||||
|
2.33 ms (1.10%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"свингер mature"
]
|
||||||||||||||||||||||||||||||
|
1.89 ms (0.89%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.75 ms (0.82%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"свингер mature"
]
|
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.