Query Metrics
7
Database Queries
7
Different statements
155.49 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
126.99 ms (81.67%) |
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 125934 223010 418714 419246 421970 422546 437687 443053 446264 447930 451541 458593 458599 458652 460596 464316 466928 471057 473195 473907 477581 480467 480474 483497 483774 484241 487206 488164 488240 488337 488510 489241 490451 495984 498811 499594 504533 505291 505300 507124 509009 511009 512693 514435 516718 518897 519388 520206 528360 528452 528568 539329 539662 542987 545947 551067 554849 557193 557839 566657 566661 567341 568453 570177 577010 581148 583894 583966 583990 584109 584120 584524 584679 585303 593742 599324 602692 606154 607519 608353 612287 614194 615145 616382 623797 624424 625861 627641 636649 636674 637174 642462 649645 691407 700134 700949 702077 714927 727554 730779 733224 733274 759731 760994 762567 772069 788920 790888 800570 805225 806910 807687 812080 819323 824562 824718 824961 826393 828423 828712 ] |
||||||||||||||||||||||||||||||
|
18.01 ms (11.59%) |
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 759731 733224 505300 691407 518897 446264 480467 520206 607519 805225 458599 636674 554849 583990 483774 615145 464316 505291 637174 733274 760994 458652 443053 528568 800570 583966 473195 557839 483497 642462 480474 495984 625861 614194 616382 727554 602692 583894 488337 539329 471057 557193 624424 473907 566657 584524 623797 421970 788920 488164 488510 498811 584679 702077 627641 458593 509009 528360 490451 608353 599324 437687 489241 577010 512693 824718 460596 593742 567341 584120 519388 714927 418714 539662 419246 542987 806910 451541 484241 514435 511009 488240 568453 700134 762567 487206 477581 570177 649645 790888 826393 700949 606154 807687 730779 422546 828423 499594 507124 516718 447930 812080 824562 828712 566661 545947 551067 528452 223010 581148 125934 612287 819323 824961 504533 585303 584109 636649 466928 772069 ] |
||||||||||||||||||||||||||||||
|
2.99 ms (1.92%) |
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 125934 223010 418714 419246 421970 422546 437687 443053 446264 447930 451541 458593 458599 458652 460596 464316 466928 471057 473195 473907 477581 480467 480474 483497 483774 484241 487206 488164 488240 488337 488510 489241 490451 495984 498811 499594 504533 505291 505300 507124 509009 511009 512693 514435 516718 518897 519388 520206 528360 528452 528568 539329 539662 542987 545947 551067 554849 557193 557839 566657 566661 567341 568453 570177 577010 581148 583894 583966 583990 584109 584120 584524 584679 585303 593742 599324 602692 606154 607519 608353 612287 614194 615145 616382 623797 624424 625861 627641 636649 636674 637174 642462 649645 691407 700134 700949 702077 714927 727554 730779 733224 733274 759731 760994 762567 772069 788920 790888 800570 805225 806910 807687 812080 819323 824562 824718 824961 826393 828423 828712 ] |
||||||||||||||||||||||||||||||
|
2.16 ms (1.39%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big tits pregnant"
]
|
||||||||||||||||||||||||||||||
|
1.87 ms (1.20%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.75 ms (1.13%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большие сиськ беремен"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (1.10%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.