Query Metrics
7
Database Queries
7
Different statements
172.80 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
147.66 ms (85.45%) |
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 61369 229105 298519 338039 341622 365924 382386 382530 384179 394167 395449 397493 410799 414022 417956 418057 418128 418551 419666 420117 423548 424734 425359 428693 428937 432963 440856 442618 444130 448137 448925 449952 450840 452287 452406 453479 453629 455387 457843 457967 460020 460501 461306 464502 465483 465841 468137 468298 473483 475687 477467 478081 479081 481335 484008 484923 490846 492397 492432 494090 495188 495666 497389 497753 499439 501970 506221 507113 513144 514234 514426 517660 520968 522860 523361 524038 526542 527776 530705 531901 533595 535541 537227 547352 549191 552159 552176 552206 559034 559672 562814 566365 570246 571780 573954 574967 578752 583942 588318 589265 591404 593227 595389 604418 614018 633185 636568 670251 672245 693049 723468 748949 756234 759485 769416 785764 818247 821855 823920 826763 ] |
||||||||||||||||||||||||||||||
|
16.06 ms (9.29%) |
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 818247 533595 475687 552159 552206 559672 552176 547352 672245 614018 591404 465841 448925 338039 444130 562814 61369 414022 428693 468298 513144 499439 570246 566365 571780 574967 578752 670251 583942 633185 595389 604418 636568 785764 769416 756234 759485 418128 418057 448137 417956 453479 494090 495188 497389 384179 229105 341622 397493 424734 440856 826763 450840 460501 465483 479081 452287 468137 530705 531901 537227 559034 573954 723468 693049 549191 593227 589265 748949 442618 452406 425359 432963 453629 455387 365924 410799 423548 449952 506221 490846 588318 394167 395449 298519 382530 382386 418551 428937 419666 420117 823920 821855 464502 477467 492432 457967 460020 461306 473483 484008 457843 478081 481335 484923 492397 495666 507113 522860 526542 535541 501970 523361 524038 497753 520968 527776 514234 514426 517660 ] |
||||||||||||||||||||||||||||||
|
2.91 ms (1.68%) |
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 61369 229105 298519 338039 341622 365924 382386 382530 384179 394167 395449 397493 410799 414022 417956 418057 418128 418551 419666 420117 423548 424734 425359 428693 428937 432963 440856 442618 444130 448137 448925 449952 450840 452287 452406 453479 453629 455387 457843 457967 460020 460501 461306 464502 465483 465841 468137 468298 473483 475687 477467 478081 479081 481335 484008 484923 490846 492397 492432 494090 495188 495666 497389 497753 499439 501970 506221 507113 513144 514234 514426 517660 520968 522860 523361 524038 526542 527776 530705 531901 533595 535541 537227 547352 549191 552159 552176 552206 559034 559672 562814 566365 570246 571780 573954 574967 578752 583942 588318 589265 591404 593227 595389 604418 614018 633185 636568 670251 672245 693049 723468 748949 756234 759485 769416 785764 818247 821855 823920 826763 ] |
||||||||||||||||||||||||||||||
|
1.82 ms (1.05%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"пять"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (0.95%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.48 ms (0.86%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"пят"
]
|
||||||||||||||||||||||||||||||
|
1.22 ms (0.70%) |
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.