Query Metrics
7
Database Queries
7
Different statements
180.65 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
148.55 ms (82.23%) |
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 325660 382895 393848 404126 415028 415863 418441 419312 419468 420774 420793 428317 429245 433898 433925 434900 435882 435924 436465 436582 440641 440819 440897 441353 441406 442051 442100 447049 450262 450272 450277 450278 450279 451275 451276 452219 452316 453376 454471 454678 457992 458004 459356 460080 460814 464149 464234 465109 467049 467064 467107 468255 469519 472509 473481 475309 475730 476051 478148 482714 482731 487796 489222 489953 498419 498426 502384 509631 513202 517475 517509 519192 521853 525839 528526 537359 537449 541541 541965 547659 548842 548869 552614 562427 576915 577313 581264 583222 583904 584425 591513 591992 592596 592597 592672 594463 595581 595969 598341 600849 602072 617197 638997 640282 655832 728741 733246 734687 739119 755022 755689 756990 777765 787624 796647 796696 796703 811450 813122 ] |
||||||||||||||||||||||||||||||
|
22.13 ms (12.25%) |
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 591992 734687 528526 502384 537359 513202 382895 404126 440819 441353 442100 450278 450279 451275 459356 489953 517509 464234 584425 548869 552614 541965 547659 655832 598341 617197 638997 595969 640282 777765 733246 739119 762336 755022 755689 728741 756990 433925 434900 435882 460080 478148 325660 441406 442051 415028 419312 452219 464149 467107 475730 450262 450277 451276 457992 467049 482731 498419 509631 460814 581264 541541 562427 577313 576915 583222 595581 591513 602072 796696 796703 813122 796647 811450 436582 458004 467064 468255 419468 440641 473481 476051 436465 393848 428317 454471 472509 420793 435924 447049 489222 517475 519192 482714 453376 452316 525839 498426 537449 594463 429245 548842 592596 592672 600849 592597 787624 433898 583904 420774 415863 418441 440897 450272 454678 469519 465109 475309 487796 521853 ] |
||||||||||||||||||||||||||||||
|
3.06 ms (1.69%) |
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 325660 382895 393848 404126 415028 415863 418441 419312 419468 420774 420793 428317 429245 433898 433925 434900 435882 435924 436465 436582 440641 440819 440897 441353 441406 442051 442100 447049 450262 450272 450277 450278 450279 451275 451276 452219 452316 453376 454471 454678 457992 458004 459356 460080 460814 464149 464234 465109 467049 467064 467107 468255 469519 472509 473481 475309 475730 476051 478148 482714 482731 487796 489222 489953 498419 498426 502384 509631 513202 517475 517509 519192 521853 525839 528526 537359 537449 541541 541965 547659 548842 548869 552614 562427 576915 577313 581264 583222 583904 584425 591513 591992 592596 592597 592672 594463 595581 595969 598341 600849 602072 617197 638997 640282 655832 728741 733246 734687 739119 755022 755689 756990 777765 787624 796647 796696 796703 811450 813122 ] |
||||||||||||||||||||||||||||||
|
2.01 ms (1.11%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.92 ms (1.06%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"pawg homemade"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (0.93%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"pawg домашн любительск"
]
|
||||||||||||||||||||||||||||||
|
1.31 ms (0.72%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"pawg домашн любительск"
]
|
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.