Query Metrics
7
Database Queries
7
Different statements
158.26 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
131.96 ms (83.38%) |
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 4463 31329 205794 388318 389612 391565 397898 397911 398531 409346 411322 411757 411945 424421 432596 432803 433380 439643 443378 446634 454274 454565 455343 455475 457459 462156 466199 466238 466310 466868 469101 470307 470537 470612 473333 473342 476023 476338 477963 479085 479112 480647 481257 481926 482443 483333 483654 484447 490404 490892 491329 502730 502929 509427 518901 535446 542950 543535 546941 547605 547810 547934 555041 555108 555116 555119 555138 558009 558700 560390 561337 563078 563080 563200 563217 563222 564920 571103 573728 589608 590503 590613 600083 601930 614881 618757 620223 695103 705458 705471 712580 714470 714496 718746 722240 733319 733338 739927 741723 741744 741764 741789 742585 744386 745462 765227 778774 781648 781652 781686 781692 781702 781745 782210 786527 794657 801450 802195 803862 817886 ] |
||||||||||||||||||||||||||||||
|
15.63 ms (9.88%) |
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 781702 741789 803862 739927 742585 722240 781652 781686 781692 781745 802195 388318 547605 466238 620223 817886 542950 695103 714496 718746 705471 600083 614881 601930 786527 794657 744386 745462 765227 705458 778774 782210 801450 397898 446634 31329 466199 454274 424421 457459 535446 502730 490404 466310 484447 462156 714470 477963 479085 490892 411322 470307 4463 712580 733338 781648 439643 411945 482443 466868 473333 473342 560390 563200 543535 546941 547810 555041 563222 564920 589608 397911 432803 454565 455475 469101 476338 480647 389612 409346 411757 470612 476023 481257 391565 398531 205794 432596 443378 470537 481926 483654 509427 479112 741744 741723 558700 555116 555119 561337 590613 733319 741764 455343 483333 491329 502929 518901 618757 547934 563078 563217 571103 573728 555108 555138 558009 563080 590503 433380 ] |
||||||||||||||||||||||||||||||
|
3.04 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 4463 31329 205794 388318 389612 391565 397898 397911 398531 409346 411322 411757 411945 424421 432596 432803 433380 439643 443378 446634 454274 454565 455343 455475 457459 462156 466199 466238 466310 466868 469101 470307 470537 470612 473333 473342 476023 476338 477963 479085 479112 480647 481257 481926 482443 483333 483654 484447 490404 490892 491329 502730 502929 509427 518901 535446 542950 543535 546941 547605 547810 547934 555041 555108 555116 555119 555138 558009 558700 560390 561337 563078 563080 563200 563217 563222 564920 571103 573728 589608 590503 590613 600083 601930 614881 618757 620223 695103 705458 705471 712580 714470 714496 718746 722240 733319 733338 739927 741723 741744 741764 741789 742585 744386 745462 765227 778774 781648 781652 781686 781692 781702 781745 782210 786527 794657 801450 802195 803862 817886 ] |
||||||||||||||||||||||||||||||
|
2.05 ms (1.30%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.97 ms (1.25%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
b"ÐÇÐâÐüÐüð║ð©ðÁ ðÀÐÇðÁð╗ÐïðÁ ð╝ð░ÐéÐÄÐÇÐ%ÔǪ"
]
|
||||||||||||||||||||||||||||||
|
1.86 ms (1.17%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"русск зрелая женщин зрелая женщин"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (1.11%) |
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.