Query Metrics
7
Database Queries
7
Different statements
185.23 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
155.93 ms (84.18%) |
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 2808 37980 72285 159865 185208 185335 188028 190204 233335 325253 382840 385934 386264 386449 387539 391125 397641 398012 398656 398874 400409 401646 401790 402164 403478 403862 404024 405744 407141 407165 408705 409349 409353 411009 413316 414248 415529 415633 417559 418497 418708 421567 425420 426633 426635 426782 427204 428938 429494 430553 431568 432200 432467 434674 434877 434886 437178 438682 439470 440681 440918 441424 441750 443144 443186 444474 444512 444619 444649 445033 445227 446893 448702 449283 452197 452934 453487 455796 456725 459842 460652 461069 461285 461935 463236 464029 464291 464655 464991 465591 468446 468785 469400 477085 477308 477550 479883 480272 483990 485991 487246 489671 490789 491038 493007 502328 505651 506062 523690 525368 537999 546649 547389 548719 550442 565792 570373 585692 789623 811473 ] |
||||||||||||||||||||||||||||||
|
17.48 ms (9.44%) |
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 405744 428938 429494 415529 432467 444512 407141 407165 408705 438682 444474 443144 413316 432200 441750 459842 452934 448702 452197 460652 469400 506062 477308 546649 547389 565792 570373 585692 789623 811473 159865 185335 382840 398012 426782 464029 468785 37980 398874 400409 418708 425420 437178 463236 465591 403478 427204 2808 190204 233335 414248 434886 444649 445033 449283 453487 461935 464991 479883 523690 525368 483990 487246 489671 493007 505651 490789 485991 491038 550442 548719 468446 430553 537999 502328 386449 385934 386264 188028 185208 325253 72285 387539 391125 397641 398656 402164 401790 401646 403862 404024 418497 426635 431568 434674 434877 439470 441424 409353 440681 411009 415633 443186 417559 440918 444619 445227 409349 421567 426633 446893 455796 456725 461069 461285 464291 464655 477085 477550 480272 ] |
||||||||||||||||||||||||||||||
|
3.46 ms (1.87%) |
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 2808 37980 72285 159865 185208 185335 188028 190204 233335 325253 382840 385934 386264 386449 387539 391125 397641 398012 398656 398874 400409 401646 401790 402164 403478 403862 404024 405744 407141 407165 408705 409349 409353 411009 413316 414248 415529 415633 417559 418497 418708 421567 425420 426633 426635 426782 427204 428938 429494 430553 431568 432200 432467 434674 434877 434886 437178 438682 439470 440681 440918 441424 441750 443144 443186 444474 444512 444619 444649 445033 445227 446893 448702 449283 452197 452934 453487 455796 456725 459842 460652 461069 461285 461935 463236 464029 464291 464655 464991 465591 468446 468785 469400 477085 477308 477550 479883 480272 483990 485991 487246 489671 490789 491038 493007 502328 505651 506062 523690 525368 537999 546649 547389 548719 550442 565792 570373 585692 789623 811473 ] |
||||||||||||||||||||||||||||||
|
2.85 ms (1.54%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"легл"
]
|
||||||||||||||||||||||||||||||
|
1.97 ms (1.06%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"легла"
]
|
||||||||||||||||||||||||||||||
|
1.91 ms (1.03%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"легл"
]
|
||||||||||||||||||||||||||||||
|
1.62 ms (0.88%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.