Query Metrics
7
Database Queries
7
Different statements
221.58 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
195.73 ms (88.33%) |
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 427709 428738 436627 443541 443904 450189 464580 464874 467951 480725 481276 488224 494861 496368 499096 499241 500271 500947 502626 504083 504692 509570 513826 517006 517634 518607 518925 519816 523261 528338 528495 529092 529331 541357 542312 543143 543450 544205 544768 547390 549081 549808 550465 557438 557468 562224 562411 566431 566764 569341 569469 574089 575632 577566 577845 581124 581211 583027 583418 584257 584291 587171 587487 587755 588014 590803 592025 593649 593764 594380 595275 597912 600807 602212 603029 604981 605644 606397 615679 615997 619092 619166 621224 621523 621765 624158 625736 626338 630697 637437 638633 640083 641830 644189 649845 651428 668997 680923 691991 720262 724698 725622 726936 731004 734437 742670 755705 761047 777624 780718 783105 784275 785226 785518 786509 791164 791803 803755 813051 ] |
||||||||||||||||||||||||||||||
|
16.10 ms (7.27%) |
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 621523 630697 450189 542312 549808 566431 541357 543143 574089 562224 626338 624158 783105 691991 638633 443541 436627 480725 499241 500271 517006 517634 550465 577845 583027 549081 581124 584291 651428 668997 680923 547390 566764 606397 615997 619092 600807 644189 587487 590803 587755 595275 785518 791803 731004 725622 724698 481276 464580 544768 594380 604981 443904 464874 504083 529331 467951 569469 544205 562411 569341 649845 581211 587171 641830 592025 603029 605644 593764 780718 785226 786509 803755 813051 784275 755705 761047 777624 428738 528495 557438 575632 583418 593649 615679 621224 502626 518925 588014 726936 637437 488224 523261 494861 496368 499096 500947 504692 519816 528338 557468 720262 597912 625736 602212 621765 619166 791164 734437 742670 640083 518607 826431 427709 509570 513826 529092 543450 584257 577566 ] |
||||||||||||||||||||||||||||||
|
2.38 ms (1.07%) |
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 427709 428738 436627 443541 443904 450189 464580 464874 467951 480725 481276 488224 494861 496368 499096 499241 500271 500947 502626 504083 504692 509570 513826 517006 517634 518607 518925 519816 523261 528338 528495 529092 529331 541357 542312 543143 543450 544205 544768 547390 549081 549808 550465 557438 557468 562224 562411 566431 566764 569341 569469 574089 575632 577566 577845 581124 581211 583027 583418 584257 584291 587171 587487 587755 588014 590803 592025 593649 593764 594380 595275 597912 600807 602212 603029 604981 605644 606397 615679 615997 619092 619166 621224 621523 621765 624158 625736 626338 630697 637437 638633 640083 641830 644189 649845 651428 668997 680923 691991 720262 724698 725622 726936 731004 734437 742670 755705 761047 777624 780718 783105 784275 785226 785518 786509 791164 791803 803755 813051 ] |
||||||||||||||||||||||||||||||
|
1.99 ms (0.90%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"amateur first time"
]
|
||||||||||||||||||||||||||||||
|
1.98 ms (0.89%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.82 ms (0.82%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"любительск вперв"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (0.72%) |
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.