Query Metrics
7
Database Queries
7
Different statements
425.01 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
209.52 ms (49.30%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"фистинг жен"
]
|
||||||||||||||||||||||||||||||
|
195.69 ms (46.04%) |
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 117596 117806 389775 396119 410239 415029 415988 419557 422324 429961 434527 440739 441057 441073 441101 441107 441834 441925 443152 444079 448791 459201 460070 471671 474891 481169 481903 481905 487429 493744 501098 502457 506516 506839 508909 512065 512078 514234 514261 515965 517724 518561 519312 519697 519698 524804 529897 530310 531869 534552 534578 536375 536463 547465 547484 547501 559298 559368 559787 568257 568268 573193 575369 576438 576916 577005 580207 580786 581781 586844 590289 592926 595483 602283 604080 619108 619996 628485 639381 643187 644018 648224 651963 656886 656895 661036 666988 668677 669012 669062 670360 671002 672942 672952 684706 685061 689074 705466 709559 713185 729800 735124 742304 750300 752598 757400 757883 788181 788580 790136 791501 792736 796837 800930 801625 801628 805227 805642 817671 ] |
||||||||||||||||||||||||||||||
|
12.60 ms (2.97%) |
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 481903 524804 515965 481905 575369 666988 671002 651963 656895 668677 705466 602283 729800 790136 792736 800930 801628 757400 801625 805642 440739 481169 518561 512078 519312 530310 396119 441107 441834 422324 434527 441073 419557 429961 441057 443152 559368 487429 460070 471671 459201 493744 514261 536375 536463 529897 534552 534578 514234 531869 547465 547484 547501 568257 577005 580786 568268 573193 576438 580207 648224 656886 669062 684706 685061 713185 670360 672952 672942 559298 586844 619996 644018 628485 592926 619108 782849 788580 791501 750300 805227 757883 742304 752598 415029 474891 441101 441925 415988 444079 512065 788181 117596 389775 817671 661036 709559 639381 643187 796837 735124 117806 502457 506516 501098 506839 508909 517724 519697 519698 581781 669012 559787 576916 590289 604080 595483 410239 448791 689074 ] |
||||||||||||||||||||||||||||||
|
2.70 ms (0.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 117596 117806 389775 396119 410239 415029 415988 419557 422324 429961 434527 440739 441057 441073 441101 441107 441834 441925 443152 444079 448791 459201 460070 471671 474891 481169 481903 481905 487429 493744 501098 502457 506516 506839 508909 512065 512078 514234 514261 515965 517724 518561 519312 519697 519698 524804 529897 530310 531869 534552 534578 536375 536463 547465 547484 547501 559298 559368 559787 568257 568268 573193 575369 576438 576916 577005 580207 580786 581781 586844 590289 592926 595483 602283 604080 619108 619996 628485 639381 643187 644018 648224 651963 656886 656895 661036 666988 668677 669012 669062 670360 671002 672942 672952 684706 685061 689074 705466 709559 713185 729800 735124 742304 750300 752598 757400 757883 788181 788580 790136 791501 792736 796837 800930 801625 801628 805227 805642 817671 ] |
||||||||||||||||||||||||||||||
|
1.77 ms (0.42%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"фистинг жен"
]
|
||||||||||||||||||||||||||||||
|
1.38 ms (0.33%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"fisting wife"
]
|
||||||||||||||||||||||||||||||
|
1.35 ms (0.32%) |
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.