Query Metrics
7
Database Queries
7
Different statements
152.57 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
130.05 ms (85.24%) |
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 417742 421144 421695 427091 428846 432618 433446 434609 437983 438005 438324 446277 446817 448729 449335 449713 449849 450784 451276 451615 453708 454350 456827 456990 457678 459245 459251 459783 460154 460464 461166 461402 464022 466709 467303 472964 473712 482881 490214 491337 492956 506069 520370 523075 529433 529948 530883 530886 530892 531499 532569 533179 537424 539812 539816 539820 539825 542268 543358 548815 558236 564731 573184 578285 579189 581135 591679 596116 602571 605144 609966 610615 614744 627161 630106 632766 633848 636333 649702 668459 677823 690105 750723 751576 765853 769299 769379 769503 770653 774271 774994 778471 778994 779213 779566 784087 784151 786247 786258 791516 791983 793295 793617 797675 798011 798616 808525 809369 811052 811243 811500 812836 814041 814629 820423 821596 823196 823477 825798 827918 ] |
||||||||||||||||||||||||||||||
|
13.20 ms (8.65%) |
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 814041 823477 820423 823196 825798 814629 821596 827918 446817 453708 456827 460464 482881 491337 449849 450784 451615 456990 459251 461166 473712 446277 451276 459245 460154 464022 466709 520370 539816 539820 539825 523075 529433 529948 506069 530883 533179 537424 539812 530886 530892 531499 532569 461402 490214 492956 543358 564731 581135 542268 548815 573184 578285 677823 649702 668459 690105 558236 579189 596116 591679 632766 633848 602571 610615 614744 630106 636333 605144 778471 778994 779566 786247 798011 808525 811243 774994 791983 793295 812836 751576 769299 769379 784087 784151 791516 811500 750723 774271 765853 769503 770653 609966 627161 779213 786258 793617 797675 798616 809369 811052 428846 432618 438324 449713 467303 417742 421695 433446 434609 448729 449335 454350 457678 421144 427091 437983 438005 459783 472964 ] |
||||||||||||||||||||||||||||||
|
2.82 ms (1.85%) |
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 417742 421144 421695 427091 428846 432618 433446 434609 437983 438005 438324 446277 446817 448729 449335 449713 449849 450784 451276 451615 453708 454350 456827 456990 457678 459245 459251 459783 460154 460464 461166 461402 464022 466709 467303 472964 473712 482881 490214 491337 492956 506069 520370 523075 529433 529948 530883 530886 530892 531499 532569 533179 537424 539812 539816 539820 539825 542268 543358 548815 558236 564731 573184 578285 579189 581135 591679 596116 602571 605144 609966 610615 614744 627161 630106 632766 633848 636333 649702 668459 677823 690105 750723 751576 765853 769299 769379 769503 770653 774271 774994 778471 778994 779213 779566 784087 784151 786247 786258 791516 791983 793295 793617 797675 798011 798616 808525 809369 811052 811243 811500 812836 814041 814629 820423 821596 823196 823477 825798 827918 ] |
||||||||||||||||||||||||||||||
|
2.15 ms (1.41%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"pov milf beautiful"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (1.12%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.52 ms (1.00%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"пов milf красивая"
]
|
||||||||||||||||||||||||||||||
|
1.12 ms (0.73%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"пов milf красивая"
]
|
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.