Query Metrics
7
Database Queries
7
Different statements
169.23 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
143.42 ms (84.75%) |
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 414938 416878 425003 426336 426919 431954 432451 432532 432538 433220 434252 434670 435064 435346 437658 442967 446577 449125 449398 452180 452592 453436 453908 455153 455653 455660 457542 457630 458231 459517 463935 464516 464694 465162 467657 470997 472145 474782 476013 476785 479558 483039 483051 483172 484009 484899 485943 489627 490079 491332 492911 495088 496379 498984 499757 500226 502257 503216 504772 505081 506577 507785 510706 510832 512738 512742 514008 514624 516425 517599 518609 519510 519668 520560 520587 520615 521998 523160 524789 525591 526467 527066 527169 527722 528110 528234 528550 528914 538340 547557 551440 552460 555851 555971 557027 558494 558630 560002 561338 561948 565188 565631 567181 567185 568097 569097 569268 583112 584197 586741 596642 599421 599725 615004 616481 619935 673244 695719 696128 813127 ] |
||||||||||||||||||||||||||||||
|
16.13 ms (9.53%) |
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 484899 485943 520560 520615 506577 510706 483051 512742 527722 476785 526467 673244 558494 568097 616481 586741 457542 453436 453908 432532 464516 459517 528110 484009 528234 449398 414938 442967 527066 551440 426336 434670 523160 599725 425003 426919 455153 510832 431954 561338 569268 565631 449125 467657 528914 483039 504772 474782 558630 615004 432538 432451 472145 491332 492911 499757 619935 596642 452180 455653 538340 498984 521998 560002 446577 458231 463935 435064 464694 479558 500226 517599 555851 555971 565188 567185 695719 696128 583112 433220 470997 518609 489627 490079 496379 502257 514624 519668 557027 584197 599421 452592 465162 512738 516425 527169 503216 569097 525591 528550 561948 567181 552460 813127 435346 416878 434252 476013 483172 495088 505081 514008 524789 519510 520587 437658 507785 547557 455660 457630 ] |
||||||||||||||||||||||||||||||
|
2.51 ms (1.48%) |
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 414938 416878 425003 426336 426919 431954 432451 432532 432538 433220 434252 434670 435064 435346 437658 442967 446577 449125 449398 452180 452592 453436 453908 455153 455653 455660 457542 457630 458231 459517 463935 464516 464694 465162 467657 470997 472145 474782 476013 476785 479558 483039 483051 483172 484009 484899 485943 489627 490079 491332 492911 495088 496379 498984 499757 500226 502257 503216 504772 505081 506577 507785 510706 510832 512738 512742 514008 514624 516425 517599 518609 519510 519668 520560 520587 520615 521998 523160 524789 525591 526467 527066 527169 527722 528110 528234 528550 528914 538340 547557 551440 552460 555851 555971 557027 558494 558630 560002 561338 561948 565188 565631 567181 567185 568097 569097 569268 583112 584197 586741 596642 599421 599725 615004 616481 619935 673244 695719 696128 813127 ] |
||||||||||||||||||||||||||||||
|
2.02 ms (1.19%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск sister секс"
]
|
||||||||||||||||||||||||||||||
|
1.95 ms (1.15%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"russian sister fuck"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (0.96%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.57 ms (0.93%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"русск sister секс"
]
|
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.