Query Metrics
7
Database Queries
7
Different statements
153.19 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
126.73 ms (82.73%) |
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 409031 417267 423384 424655 425478 427620 427762 432710 432741 434750 436809 438495 448471 450152 451088 451107 451276 451292 454380 455031 456062 456382 456712 458996 459978 460104 461245 461402 462899 462981 463369 465310 470827 474063 478088 478111 478296 479656 479886 481410 484210 489894 493886 496059 496148 496637 503511 506144 506961 508262 510801 510902 511988 512011 515711 518318 519237 521594 522561 522764 522960 525896 527619 527644 528301 530213 546516 553256 557071 557824 558752 560970 562056 562720 564080 568637 568654 572962 574097 575386 577723 583456 586146 588018 594981 595026 595040 595367 596371 599956 603795 604916 606143 606633 616167 616939 627743 644735 654269 662427 662930 664676 672243 684447 693632 707892 739997 757455 771406 777223 778116 781291 784989 794530 802815 810772 812593 813095 825862 ] |
||||||||||||||||||||||||||||||
|
15.66 ms (10.22%) |
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 465310 427620 481410 417267 456062 474063 508262 512011 825862 528301 409031 425478 458996 451088 522561 586146 596371 599956 456382 462981 448471 455031 461245 463369 519237 510801 515711 496148 503511 510902 810772 456712 436809 424655 434750 427762 438495 423384 432710 432741 450152 451107 451292 479886 484210 489894 454380 460104 462899 451276 478088 478111 506961 518318 496637 521594 511988 522764 522960 527619 527644 530213 496059 506144 525896 459978 461402 470827 478296 479656 493886 546516 558752 564080 568637 568654 574097 575386 583456 553256 557071 572962 693632 707892 654269 672243 662427 662930 664676 684447 557824 560970 562056 562720 577723 595026 595040 603795 606633 594981 604916 616939 644735 588018 595367 606143 616167 627743 777223 778116 781291 802815 812593 813095 784989 794530 739997 757455 769184 771406 ] |
||||||||||||||||||||||||||||||
|
3.30 ms (2.15%) |
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 409031 417267 423384 424655 425478 427620 427762 432710 432741 434750 436809 438495 448471 450152 451088 451107 451276 451292 454380 455031 456062 456382 456712 458996 459978 460104 461245 461402 462899 462981 463369 465310 470827 474063 478088 478111 478296 479656 479886 481410 484210 489894 493886 496059 496148 496637 503511 506144 506961 508262 510801 510902 511988 512011 515711 518318 519237 521594 522561 522764 522960 525896 527619 527644 528301 530213 546516 553256 557071 557824 558752 560970 562056 562720 564080 568637 568654 572962 574097 575386 577723 583456 586146 588018 594981 595026 595040 595367 596371 599956 603795 604916 606143 606633 616167 616939 627743 644735 654269 662427 662930 664676 672243 684447 693632 707892 739997 757455 771406 777223 778116 781291 784989 794530 802815 810772 812593 813095 825862 ] |
||||||||||||||||||||||||||||||
|
2.10 ms (1.37%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"cumshot pov"
]
|
||||||||||||||||||||||||||||||
|
2.03 ms (1.33%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"cumshot пов"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (1.13%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.63 ms (1.07%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"cumshot пов"
]
|
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.