Query Metrics
7
Database Queries
7
Different statements
154.88 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
127.20 ms (82.13%) |
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 14602 341889 387915 395162 395919 396725 397192 398132 398477 401615 402386 404940 411804 414360 417723 417967 418487 421740 422469 427585 439463 444437 447558 452931 454623 456048 457310 458699 460769 461644 464211 464256 466027 466883 468100 468395 472337 487338 493849 494327 501755 512010 517999 518250 519555 519726 523563 525748 526162 530371 531113 531143 531200 531212 531844 533696 533783 534432 535051 535057 535643 536598 537881 537887 537936 541706 541867 544810 545183 553122 555098 559018 560636 564293 564377 564555 569149 580597 581188 581242 583541 590078 599946 604257 604669 610728 618850 620224 620240 623003 630544 631245 634157 634533 634546 635968 637439 638191 646900 650160 660310 667760 674936 690786 696226 706058 712558 714613 715373 717701 727751 728465 756078 757331 777580 777905 786532 792088 817608 818569 ] |
||||||||||||||||||||||||||||||
|
16.20 ms (10.46%) |
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 454623 458699 519726 512010 402386 464211 536598 533696 631245 14602 817608 456048 531844 564293 560636 712558 674936 706058 590078 623003 620240 620224 777580 638191 396725 421740 444437 466883 650160 756078 786532 341889 395162 397192 555098 714613 690786 518250 717701 777905 395919 583541 696226 660310 604669 610728 472337 541706 414360 818569 452931 523563 544810 757331 533783 531212 534432 535051 634533 537881 581188 581242 494327 411804 457310 461644 580597 564555 401615 531113 667760 387915 398132 417723 417967 468100 466027 526162 541867 727751 404940 460769 398477 517999 519555 531200 537936 545183 559018 553122 569149 646900 599946 618850 635968 604257 634157 630544 637439 792088 728465 715373 493849 439463 537887 531143 464256 468395 418487 447558 422469 427585 487338 501755 525748 634546 564377 535057 530371 535643 ] |
||||||||||||||||||||||||||||||
|
3.24 ms (2.09%) |
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 14602 341889 387915 395162 395919 396725 397192 398132 398477 401615 402386 404940 411804 414360 417723 417967 418487 421740 422469 427585 439463 444437 447558 452931 454623 456048 457310 458699 460769 461644 464211 464256 466027 466883 468100 468395 472337 487338 493849 494327 501755 512010 517999 518250 519555 519726 523563 525748 526162 530371 531113 531143 531200 531212 531844 533696 533783 534432 535051 535057 535643 536598 537881 537887 537936 541706 541867 544810 545183 553122 555098 559018 560636 564293 564377 564555 569149 580597 581188 581242 583541 590078 599946 604257 604669 610728 618850 620224 620240 623003 630544 631245 634157 634533 634546 635968 637439 638191 646900 650160 660310 667760 674936 690786 696226 706058 712558 714613 715373 717701 727751 728465 756078 757331 777580 777905 786532 792088 817608 818569 ] |
||||||||||||||||||||||||||||||
|
2.27 ms (1.47%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"deep anal big"
]
|
||||||||||||||||||||||||||||||
|
2.16 ms (1.40%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"deep анал большие"
]
|
||||||||||||||||||||||||||||||
|
2.13 ms (1.37%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.68 ms (1.08%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"deep анал большие"
]
|
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.