Query Metrics
7
Database Queries
7
Different statements
145.33 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
120.33 ms (82.80%) |
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 373875 396083 399922 401325 401426 416056 420761 421154 423615 426323 431514 431694 437166 443213 447516 447625 448195 451591 454842 456069 458017 461423 463945 464584 465613 465781 466124 468527 470137 470278 473148 473324 473529 473925 478652 480008 481253 485135 487370 489524 491908 497881 498655 502118 503725 512073 512659 513307 513500 521596 521809 522096 524027 524188 524754 524934 527629 531194 546970 552508 555955 561832 565272 569567 574292 574511 595412 598695 603725 611301 618365 619582 621270 624484 625745 626295 626297 628090 651873 652927 654346 670190 677053 680313 685425 695093 698012 701486 704241 711328 717890 722583 723167 724185 727796 730457 733450 742234 742846 747709 750222 750753 761147 764843 765540 766797 769829 771429 772809 774693 784956 786372 794366 798823 805110 806046 812077 813566 826154 827221 ] |
||||||||||||||||||||||||||||||
|
14.94 ms (10.28%) |
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 805110 761147 401325 512659 448195 487370 531194 628090 423615 465613 431514 470278 512073 401426 447516 546970 561832 680313 595412 618365 598695 603725 451591 470137 473925 461423 464584 399922 420761 431694 463945 473148 478652 416056 443213 502118 503725 513307 524027 485135 489524 491908 497881 723167 750222 695093 626295 806046 786372 742846 764843 730457 765540 771429 750753 724185 619582 812077 727796 456069 426323 521596 527629 565272 677053 701486 711328 698012 552508 626297 513500 468527 569567 555955 670190 447625 473324 454842 521809 522096 826154 827221 652927 784956 794366 747709 766797 742234 437166 611301 481253 458017 733450 704241 798823 651873 722583 772809 769829 524934 574511 621270 473529 480008 465781 524188 524754 574292 498655 421154 717890 654346 625745 774693 373875 396083 466124 624484 813566 685425 ] |
||||||||||||||||||||||||||||||
|
2.51 ms (1.73%) |
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 373875 396083 399922 401325 401426 416056 420761 421154 423615 426323 431514 431694 437166 443213 447516 447625 448195 451591 454842 456069 458017 461423 463945 464584 465613 465781 466124 468527 470137 470278 473148 473324 473529 473925 478652 480008 481253 485135 487370 489524 491908 497881 498655 502118 503725 512073 512659 513307 513500 521596 521809 522096 524027 524188 524754 524934 527629 531194 546970 552508 555955 561832 565272 569567 574292 574511 595412 598695 603725 611301 618365 619582 621270 624484 625745 626295 626297 628090 651873 652927 654346 670190 677053 680313 685425 695093 698012 701486 704241 711328 717890 722583 723167 724185 727796 730457 733450 742234 742846 747709 750222 750753 761147 764843 765540 766797 769829 771429 772809 774693 784956 786372 794366 798823 805110 806046 812077 813566 826154 827221 ] |
||||||||||||||||||||||||||||||
|
2.13 ms (1.46%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"сперм анал красивая"
]
|
||||||||||||||||||||||||||||||
|
2.03 ms (1.40%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"сперм анал красивая"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (1.23%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"кончил в попку красотке"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (1.11%) |
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.