Query Metrics
7
Database Queries
7
Different statements
176.82 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
150.75 ms (85.26%) |
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 384470 419170 427779 432405 471458 473264 477618 479929 486823 493776 494885 498199 502207 502784 503408 505953 507248 509567 511867 517185 517624 520279 520999 521094 521160 522088 522719 523185 524227 525757 525791 526284 526321 526862 527286 532206 532312 532314 532326 536381 537436 538984 541163 542134 544251 545108 545213 546578 547524 548323 550593 558691 560288 563632 564287 565868 566118 567914 568637 568654 568962 569648 574060 574363 574643 579168 579477 579993 581103 582492 583456 584096 584361 584570 588018 588590 589135 590824 591969 592157 592967 593120 599455 602580 604322 604663 605967 609296 610405 611230 612682 616167 616407 616435 616879 616895 619556 620473 624932 625108 628321 629452 629543 630156 636956 645892 652623 653333 664494 688680 689154 689542 759607 765092 775580 779982 790126 792050 794306 ] |
||||||||||||||||||||||||||||||
|
15.80 ms (8.93%) |
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 536381 568637 524227 568654 579477 581103 584570 584361 546578 611230 620473 473264 505953 548323 688680 589135 590824 625108 432405 583456 591969 494885 525757 517624 574643 545108 624932 592967 604322 616167 629543 486823 520999 526284 527286 520279 523185 502207 479929 569648 579993 579168 582492 545213 558691 629452 532312 653333 664494 565868 604663 605967 630156 477618 493776 522088 498199 517185 521094 502784 526862 550593 564287 541163 574060 592157 616879 612682 616435 619556 591806 610405 779982 790126 759607 794306 503408 507248 521160 537436 566118 567914 584096 547524 588590 593120 636956 599455 588018 609296 628321 532206 525791 522719 544251 542134 568962 645892 652623 689542 602580 616895 792050 765092 775580 574363 563632 689154 384470 427779 419170 616407 471458 532326 509567 511867 532314 526321 538984 560288 ] |
||||||||||||||||||||||||||||||
|
2.84 ms (1.61%) |
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 384470 419170 427779 432405 471458 473264 477618 479929 486823 493776 494885 498199 502207 502784 503408 505953 507248 509567 511867 517185 517624 520279 520999 521094 521160 522088 522719 523185 524227 525757 525791 526284 526321 526862 527286 532206 532312 532314 532326 536381 537436 538984 541163 542134 544251 545108 545213 546578 547524 548323 550593 558691 560288 563632 564287 565868 566118 567914 568637 568654 568962 569648 574060 574363 574643 579168 579477 579993 581103 582492 583456 584096 584361 584570 588018 588590 589135 590824 591969 592157 592967 593120 599455 602580 604322 604663 605967 609296 610405 611230 612682 616167 616407 616435 616879 616895 619556 620473 624932 625108 628321 629452 629543 630156 636956 645892 652623 653333 664494 688680 689154 689542 759607 765092 775580 779982 790126 792050 794306 ] |
||||||||||||||||||||||||||||||
|
2.17 ms (1.23%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.88 ms (1.06%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sperm in ass"
]
|
||||||||||||||||||||||||||||||
|
1.86 ms (1.05%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"сперм жоп"
]
|
||||||||||||||||||||||||||||||
|
1.52 ms (0.86%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.