Query Metrics
7
Database Queries
7
Different statements
215.01 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
186.81 ms (86.89%) |
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 386751 424646 468694 484193 484440 496165 497941 506518 511828 514377 514756 517638 522087 523357 528942 529092 530034 530488 531091 531108 532940 533016 533018 533522 533576 534032 534151 537187 541532 541676 542247 544206 548796 550294 555851 560968 561832 562853 565160 571210 574870 575154 580623 584259 585417 588014 589196 590802 591714 593766 596274 597260 597269 597275 597907 599963 604331 605399 615517 616025 619782 628116 628403 629934 630234 630679 632626 632969 634512 637039 637105 637141 637431 637432 639787 640777 640785 641623 647313 647891 648924 648937 649576 651620 663801 666532 670250 674713 677364 679775 680120 680142 680161 680202 681134 681505 696950 696995 700996 713867 718675 729134 735703 750527 758226 759340 759344 759848 761717 784054 786114 791686 798948 800781 803793 810226 811643 811944 814210 814460 ] |
||||||||||||||||||||||||||||||
|
18.81 ms (8.75%) |
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 674713 680161 585417 761717 514756 590802 534151 630679 791686 604331 517638 541532 550294 484440 497941 677364 575154 637141 424646 534032 555851 561832 681505 506518 528942 593766 619782 514377 784054 496165 597260 484193 803793 681134 530034 548796 640777 531091 584259 663801 759340 541676 649576 580623 533576 529092 647891 574870 637105 637431 637432 640785 786114 811643 522087 735703 597907 562853 628116 814210 468694 533018 530488 565160 648924 670250 700996 696995 651620 641623 639787 637039 759344 758226 632969 511828 648937 811944 696950 544206 560968 591714 597269 810226 386751 571210 666532 680202 680142 597275 630234 759848 588014 605399 798948 596274 729134 531108 616025 634512 680120 615517 589196 632626 814460 523357 533522 542247 750527 629934 718675 800781 537187 599963 628403 679775 647313 533016 532940 713867 ] |
||||||||||||||||||||||||||||||
|
2.25 ms (1.05%) |
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 386751 424646 468694 484193 484440 496165 497941 506518 511828 514377 514756 517638 522087 523357 528942 529092 530034 530488 531091 531108 532940 533016 533018 533522 533576 534032 534151 537187 541532 541676 542247 544206 548796 550294 555851 560968 561832 562853 565160 571210 574870 575154 580623 584259 585417 588014 589196 590802 591714 593766 596274 597260 597269 597275 597907 599963 604331 605399 615517 616025 619782 628116 628403 629934 630234 630679 632626 632969 634512 637039 637105 637141 637431 637432 639787 640777 640785 641623 647313 647891 648924 648937 649576 651620 663801 666532 670250 674713 677364 679775 680120 680142 680161 680202 681134 681505 696950 696995 700996 713867 718675 729134 735703 750527 758226 759340 759344 759848 761717 784054 786114 791686 798948 800781 803793 810226 811643 811944 814210 814460 ] |
||||||||||||||||||||||||||||||
|
2.00 ms (0.93%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"первая ебля в жопу"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (0.83%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"перв секс анал"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (0.79%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.66 ms (0.77%) |
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.