Query Metrics
7
Database Queries
7
Different statements
167.25 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
142.95 ms (85.47%) |
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 13249 44022 334472 366053 384050 386674 386719 388215 391487 391595 391812 392065 398042 402032 403187 404386 408845 423922 423992 426176 427112 427213 431587 432738 436240 438984 439020 443815 444129 444232 448760 452949 453222 453634 456912 458456 458650 461548 462510 464546 465393 465397 466178 466194 466387 468093 470341 475231 476620 477198 477610 478010 478637 480975 481121 482078 482666 483053 483844 486618 487609 489376 490499 490949 494382 496955 497210 497576 498124 502417 508869 510097 514028 520116 521954 524252 533130 559979 559999 562445 571936 576127 581617 588787 595367 595423 596584 596588 598684 601565 608945 623155 623745 655679 685422 713300 717662 718672 722220 727813 731862 736869 742932 742942 743634 749766 749954 755633 758973 760515 761618 762166 764112 768744 781489 782671 788028 804808 819765 827962 ] |
||||||||||||||||||||||||||||||
|
15.18 ms (9.08%) |
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 334472 44022 452949 489376 514028 487609 571936 480975 391487 588787 595367 727813 427213 470341 427112 524252 483844 490499 398042 456912 477610 481121 438984 423992 431587 458456 782671 788028 755633 761618 742942 13249 743634 482078 462510 502417 596584 736869 749766 764112 731862 742932 749954 781489 384050 465393 403187 458650 475231 408845 819765 827962 388215 386674 432738 466387 392065 508869 598684 436240 521954 576127 760515 453634 722220 713300 685422 623155 595423 623745 608945 391595 559979 596588 443815 448760 453222 465397 426176 478010 559999 486618 402032 386719 498124 496955 655679 423922 468093 717662 482666 466178 477198 483053 444129 444232 804808 768744 718672 391812 366053 520116 581617 562445 476620 478637 466194 497576 601565 461548 510097 439020 490949 497210 758973 464546 533130 494382 762166 404386 ] |
||||||||||||||||||||||||||||||
|
2.64 ms (1.58%) |
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 13249 44022 334472 366053 384050 386674 386719 388215 391487 391595 391812 392065 398042 402032 403187 404386 408845 423922 423992 426176 427112 427213 431587 432738 436240 438984 439020 443815 444129 444232 448760 452949 453222 453634 456912 458456 458650 461548 462510 464546 465393 465397 466178 466194 466387 468093 470341 475231 476620 477198 477610 478010 478637 480975 481121 482078 482666 483053 483844 486618 487609 489376 490499 490949 494382 496955 497210 497576 498124 502417 508869 510097 514028 520116 521954 524252 533130 559979 559999 562445 571936 576127 581617 588787 595367 595423 596584 596588 598684 601565 608945 623155 623745 655679 685422 713300 717662 718672 722220 727813 731862 736869 742932 742942 743634 749766 749954 755633 758973 760515 761618 762166 764112 768744 781489 782671 788028 804808 819765 827962 ] |
||||||||||||||||||||||||||||||
|
2.02 ms (1.21%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"rus sex vagina"
]
|
||||||||||||||||||||||||||||||
|
1.54 ms (0.92%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"русск секс вагин"
]
|
||||||||||||||||||||||||||||||
|
1.46 ms (0.87%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск секс вагин"
]
|
||||||||||||||||||||||||||||||
|
1.45 ms (0.87%) |
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.