Query Metrics
7
Database Queries
7
Different statements
139.79 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
115.31 ms (82.49%) |
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 414071 418817 423802 423856 424265 426259 435356 435592 448140 448263 452640 452823 454755 454869 457294 457950 470022 470064 471088 475318 475419 478985 483686 492101 492407 492758 515038 515486 516043 516574 516873 517304 518598 522797 522978 524497 529704 532560 547466 547468 547482 547488 547679 547756 547767 547789 547800 555565 562423 563939 569575 571712 572259 575300 581173 581978 586002 589166 592702 594150 596025 597878 600719 602338 604404 605026 606088 618999 624742 628641 633485 640152 648761 669080 670841 690020 701206 703930 716167 726432 729678 732832 743890 750907 753496 757427 757436 758079 760649 763720 782804 783312 784221 784657 786406 788949 788953 791504 799228 800031 800677 803046 803129 803524 805366 807590 807619 808440 808655 809078 809081 810790 810791 810804 811337 811381 812043 814681 816722 ] |
||||||||||||||||||||||||||||||
|
14.48 ms (10.36%) |
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 809078 809081 810790 810791 811337 786406 800677 805366 729678 783312 800031 807590 808440 810804 757427 758079 763720 757436 606088 703930 791504 807619 475318 475419 478985 423802 418817 435356 454869 424265 454755 515486 492101 492407 516873 522978 516574 483686 492758 572259 426259 452640 457294 518598 547767 547789 547679 586002 596025 423856 435592 457950 470022 522797 624742 471088 470064 811381 799228 414071 816722 814681 448140 448263 452823 516043 517304 529704 524497 515038 532560 547466 547482 547488 569575 547756 555565 563939 547468 547800 575300 581173 581978 670841 690020 648761 669080 701206 716167 562423 571712 592702 600719 604404 640152 589166 594150 618999 597878 628641 602338 605026 788953 808655 812043 782804 788949 796642 803129 803524 743890 750907 732832 726432 753496 760649 633485 784221 784657 803046 ] |
||||||||||||||||||||||||||||||
|
2.88 ms (2.06%) |
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 414071 418817 423802 423856 424265 426259 435356 435592 448140 448263 452640 452823 454755 454869 457294 457950 470022 470064 471088 475318 475419 478985 483686 492101 492407 492758 515038 515486 516043 516574 516873 517304 518598 522797 522978 524497 529704 532560 547466 547468 547482 547488 547679 547756 547767 547789 547800 555565 562423 563939 569575 571712 572259 575300 581173 581978 586002 589166 592702 594150 596025 597878 600719 602338 604404 605026 606088 618999 624742 628641 633485 640152 648761 669080 670841 690020 701206 703930 716167 726432 729678 732832 743890 750907 753496 757427 757436 758079 760649 763720 782804 783312 784221 784657 786406 788949 788953 791504 799228 800031 800677 803046 803129 803524 805366 807590 807619 808440 808655 809078 809081 810790 810791 810804 811337 811381 812043 814681 816722 ] |
||||||||||||||||||||||||||||||
|
2.18 ms (1.56%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mom masturbation webcam"
]
|
||||||||||||||||||||||||||||||
|
1.86 ms (1.33%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mom мастурбац вебкамер"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (1.12%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mom мастурбац вебкамер"
]
|
||||||||||||||||||||||||||||||
|
1.51 ms (1.08%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.