Query Metrics
7
Database Queries
7
Different statements
180.70 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
149.19 ms (82.57%) |
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 384382 393108 405705 414183 414340 431593 435401 465000 465561 474860 479426 481249 481644 492137 493168 501281 513318 528052 531240 532041 532369 533130 537464 541868 543428 548301 548889 550424 552357 556504 563768 569482 570114 583515 585993 590539 597522 598412 603773 603913 606134 607031 607481 608449 609613 610376 616525 617834 630134 654677 664437 666417 673925 684479 684903 695307 695690 710210 716315 717794 719964 721675 722532 724215 731967 732041 732924 733651 749041 749309 756072 761997 762675 762994 764020 768462 768739 770790 771289 773911 776289 777206 779687 780292 782382 783838 783970 784167 784992 785033 785070 786573 787792 787973 788032 789856 793085 795142 797555 797874 798123 799243 802202 804808 807478 809444 809868 810187 810507 811347 813989 814330 818002 820850 820956 821503 822263 825214 825854 826449 ] |
||||||||||||||||||||||||||||||
|
21.90 ms (12.12%) |
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 814330 548301 822263 825214 532369 501281 695690 695307 616525 608449 776289 782382 787792 788032 785033 789856 804808 783838 732924 761997 764020 749309 603913 617834 779687 793085 797555 799243 583515 666417 607481 603773 756072 710210 716315 606134 749041 825854 414183 818002 813989 820850 563768 569482 609613 607031 777206 784167 810187 768462 768739 770790 771289 717794 787973 431593 384382 393108 548889 721675 630134 783970 731967 732041 724215 762675 733651 785070 798123 465000 465561 481644 493168 531240 481249 556504 541868 570114 654677 684903 590539 597522 585993 610376 786573 802202 807478 809868 784992 795142 809444 773911 797874 435401 532041 722532 810507 762994 811347 719964 780292 492137 479426 552357 405705 513318 414340 821503 820956 826449 474860 528052 533130 537464 550424 543428 664437 684479 673925 598412 ] |
||||||||||||||||||||||||||||||
|
2.36 ms (1.31%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"pov dirty"
]
|
||||||||||||||||||||||||||||||
|
2.24 ms (1.24%) |
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 384382 393108 405705 414183 414340 431593 435401 465000 465561 474860 479426 481249 481644 492137 493168 501281 513318 528052 531240 532041 532369 533130 537464 541868 543428 548301 548889 550424 552357 556504 563768 569482 570114 583515 585993 590539 597522 598412 603773 603913 606134 607031 607481 608449 609613 610376 616525 617834 630134 654677 664437 666417 673925 684479 684903 695307 695690 710210 716315 717794 719964 721675 722532 724215 731967 732041 732924 733651 749041 749309 756072 761997 762675 762994 764020 768462 768739 770790 771289 773911 776289 777206 779687 780292 782382 783838 783970 784167 784992 785033 785070 786573 787792 787973 788032 789856 793085 795142 797555 797874 798123 799243 802202 804808 807478 809444 809868 810187 810507 811347 813989 814330 818002 820850 820956 821503 822263 825214 825854 826449 ] |
||||||||||||||||||||||||||||||
|
1.78 ms (0.98%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.75 ms (0.97%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"пов dirty"
]
|
||||||||||||||||||||||||||||||
|
1.47 ms (0.81%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"пов dirty"
]
|
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.