Query Metrics
7
Database Queries
7
Different statements
195.16 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
167.59 ms (85.87%) |
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 384400 397869 401970 428710 448907 450583 466031 475280 475419 475727 495204 505771 507631 516057 524476 531758 535318 537048 538152 539557 540556 540563 540691 541793 547520 556040 558623 558726 568133 573169 575897 579706 583178 587241 587787 589626 589894 592872 596513 602320 636493 639221 640375 641346 642201 643287 650051 653348 655295 658468 664175 699232 700042 702864 704100 706761 708626 711777 714461 714707 717541 737889 739964 740552 741243 746425 758318 760685 763870 765179 766441 769382 772552 777789 780309 781310 781862 784672 786368 789473 791332 791863 792237 793194 794019 794968 796190 796391 796514 798826 798829 798870 799037 801799 802288 803767 803826 803841 804345 804394 804399 804440 804614 804644 804648 804652 807861 808306 808951 819153 819157 819160 819181 819222 819232 819256 824104 825767 826142 826508 ] |
||||||||||||||||||||||||||||||
|
16.64 ms (8.53%) |
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 708626 711777 642201 794968 796391 798870 808306 741243 758318 699232 804440 535318 766441 819232 516057 808951 804399 804644 802288 475280 781862 819256 824104 539557 540691 556040 655295 714707 640375 796514 746425 740552 739964 798826 804648 507631 397869 401970 819181 826142 819222 825767 524476 495204 531758 537048 540563 475727 541793 547520 706761 653348 658468 589626 592872 596513 791863 792237 777789 791332 804345 781310 784672 789473 796190 760685 763870 780309 793194 819157 636493 807861 769382 428710 384400 450583 714461 700042 717541 573169 643287 639221 794019 786368 803841 804652 799037 801799 803767 803826 765179 772552 798829 505771 804394 804614 737889 641346 475419 826508 819153 819160 466031 448907 540556 538152 575897 583178 558726 568133 579706 702864 704100 650051 664175 558623 587241 602320 587787 589894 ] |
||||||||||||||||||||||||||||||
|
3.20 ms (1.64%) |
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 384400 397869 401970 428710 448907 450583 466031 475280 475419 475727 495204 505771 507631 516057 524476 531758 535318 537048 538152 539557 540556 540563 540691 541793 547520 556040 558623 558726 568133 573169 575897 579706 583178 587241 587787 589626 589894 592872 596513 602320 636493 639221 640375 641346 642201 643287 650051 653348 655295 658468 664175 699232 700042 702864 704100 706761 708626 711777 714461 714707 717541 737889 739964 740552 741243 746425 758318 760685 763870 765179 766441 769382 772552 777789 780309 781310 781862 784672 786368 789473 791332 791863 792237 793194 794019 794968 796190 796391 796514 798826 798829 798870 799037 801799 802288 803767 803826 803841 804345 804394 804399 804440 804614 804644 804648 804652 807861 808306 808951 819153 819157 819160 819181 819222 819232 819256 824104 825767 826142 826508 ] |
||||||||||||||||||||||||||||||
|
2.08 ms (1.07%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"milf соло hot"
]
|
||||||||||||||||||||||||||||||
|
1.98 ms (1.02%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.94 ms (0.99%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"milf solo hot"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (0.89%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"milf соло hot"
]
|
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.