Query Metrics
7
Database Queries
7
Different statements
190.25 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
158.64 ms (83.38%) |
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 95668 392213 397295 402159 403769 406203 407995 411802 414117 418388 419030 419277 419299 419303 421629 422025 426995 428484 431503 432695 432711 434767 437151 437157 437367 437863 439484 440486 440715 440788 443151 446929 447237 449854 450175 453833 453958 453987 454001 456115 456587 460330 463437 463636 466793 468434 471623 474894 475054 489849 492190 496124 496465 498703 500552 502195 504946 508314 508616 509725 511155 514094 514912 518146 518606 519157 524381 525082 525332 531296 539275 541474 543970 545738 556422 557562 558135 558194 558883 560434 562100 567622 568926 570712 582479 584112 586691 591737 594875 597584 601307 602944 604409 605966 607465 612638 621868 626710 629171 629580 630135 658773 664462 680459 707175 710706 712859 718089 731058 766637 773908 793871 795125 795247 795484 797742 800239 804114 805259 813562 ] |
||||||||||||||||||||||||||||||
|
19.79 ms (10.40%) |
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 95668 407995 414117 813562 449854 466793 496465 500552 545738 567622 664462 707175 718089 601307 621868 626710 797742 795484 731058 773908 800239 710706 793871 795125 804114 392213 440715 508314 630135 584112 437863 502195 514912 558883 612638 586691 602944 421629 525082 558194 556422 519157 453958 795247 463437 475054 437151 558135 525332 428484 437367 496124 562100 570712 594875 426995 498703 560434 604409 591737 397295 432695 418388 440486 419299 439484 431503 454001 460330 468434 489849 447237 453987 463636 453833 531296 509725 539275 514094 541474 543970 568926 582479 658773 680459 712859 557562 597584 605966 629171 607465 766637 434767 471623 419030 419303 402159 403769 419277 437157 456587 511155 492190 508616 504946 518146 518606 524381 456115 805259 629580 406203 422025 440788 411802 432711 443151 450175 474894 446929 ] |
||||||||||||||||||||||||||||||
|
3.24 ms (1.70%) |
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 95668 392213 397295 402159 403769 406203 407995 411802 414117 418388 419030 419277 419299 419303 421629 422025 426995 428484 431503 432695 432711 434767 437151 437157 437367 437863 439484 440486 440715 440788 443151 446929 447237 449854 450175 453833 453958 453987 454001 456115 456587 460330 463437 463636 466793 468434 471623 474894 475054 489849 492190 496124 496465 498703 500552 502195 504946 508314 508616 509725 511155 514094 514912 518146 518606 519157 524381 525082 525332 531296 539275 541474 543970 545738 556422 557562 558135 558194 558883 560434 562100 567622 568926 570712 582479 584112 586691 591737 594875 597584 601307 602944 604409 605966 607465 612638 621868 626710 629171 629580 630135 658773 664462 680459 707175 710706 712859 718089 731058 766637 773908 793871 795125 795247 795484 797742 800239 804114 805259 813562 ] |
||||||||||||||||||||||||||||||
|
3.04 ms (1.60%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.05 ms (1.08%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"public ass creampie"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (0.92%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"на улиц жоп creampie"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (0.91%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"на улиц жоп creampie"
]
|
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.