Query Metrics
7
Database Queries
7
Different statements
218.63 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
191.33 ms (87.51%) |
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 79677 389630 397777 398648 400696 404257 410663 413898 415835 419240 419515 424024 426705 427003 428684 429960 431608 435020 443129 443715 443950 449981 453610 454136 455641 456741 457580 462167 465803 466124 466137 473785 473995 474062 474242 477135 483850 483969 486118 491071 496822 496882 497201 501507 509240 510348 516295 543708 543714 543717 543734 544186 572949 579704 585895 601907 610835 627746 664529 689170 730819 733661 749882 757803 757981 764076 764668 766159 766354 766361 767553 768491 771445 771822 773826 777471 778543 778766 778773 779266 782184 783609 783796 784700 786090 786093 787471 787840 788032 788388 791498 791841 792677 794081 795617 796598 801736 803246 807286 809645 810189 810880 817205 817740 819208 819793 819946 821039 821796 823647 823648 824057 824547 825180 825525 825641 825927 827105 827107 828665 ] |
||||||||||||||||||||||||||||||
|
17.84 ms (8.16%) |
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 773826 766361 400696 415835 825641 819946 404257 601907 543714 543734 786093 809645 733661 768491 782184 466137 509240 783609 419515 389630 465803 435020 455641 496882 496822 516295 397777 510348 413898 456741 664529 777471 786090 778766 779266 801736 749882 771822 791498 792677 803246 825927 827105 825180 819793 821796 823648 795617 757981 426705 824547 824057 486118 827107 828665 473785 410663 462167 443950 627746 473995 454136 585895 794081 778773 810880 771445 784700 544186 543717 689170 610835 778543 730819 766354 443129 424024 457580 823647 572949 398648 483850 497201 767553 79677 427003 449981 796598 757803 819208 543708 579704 419240 477135 788032 764076 764668 788388 443715 453610 474242 431608 429960 466124 810189 817740 821039 787471 428684 474062 501507 766159 791841 491071 483969 817205 825525 787840 783796 807286 ] |
||||||||||||||||||||||||||||||
|
2.37 ms (1.08%) |
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 79677 389630 397777 398648 400696 404257 410663 413898 415835 419240 419515 424024 426705 427003 428684 429960 431608 435020 443129 443715 443950 449981 453610 454136 455641 456741 457580 462167 465803 466124 466137 473785 473995 474062 474242 477135 483850 483969 486118 491071 496822 496882 497201 501507 509240 510348 516295 543708 543714 543717 543734 544186 572949 579704 585895 601907 610835 627746 664529 689170 730819 733661 749882 757803 757981 764076 764668 766159 766354 766361 767553 768491 771445 771822 773826 777471 778543 778766 778773 779266 782184 783609 783796 784700 786090 786093 787471 787840 788032 788388 791498 791841 792677 794081 795617 796598 801736 803246 807286 809645 810189 810880 817205 817740 819208 819793 819946 821039 821796 823647 823648 824057 824547 825180 825525 825641 825927 827105 827107 828665 ] |
||||||||||||||||||||||||||||||
|
1.90 ms (0.87%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.89 ms (0.86%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"пов секс с русскими"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (0.83%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"пов секс русск"
]
|
||||||||||||||||||||||||||||||
|
1.49 ms (0.68%) |
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.