Query Metrics
7
Database Queries
7
Different statements
155.97 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
126.56 ms (81.15%) |
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 6679 95586 95640 95991 97288 123271 226028 260297 382567 384801 385077 385248 385287 385359 386626 387599 387636 388066 388687 391027 392967 395378 396079 400125 400932 401583 401584 401597 403268 404598 405802 409405 411118 411284 414115 415319 415380 418346 419410 419623 420060 421162 423907 423963 424556 426154 426365 426718 427185 429446 437152 439660 443689 443700 443716 443844 445363 447832 448518 449123 451566 451567 452448 453783 454127 456142 456585 456710 458831 459120 461118 461478 462713 464513 468176 469893 470303 470562 470596 470747 471416 471587 477085 477141 478353 479117 486435 487864 488710 490538 492739 496230 499431 504112 521276 521595 521877 524853 526372 536012 546684 549560 554246 562248 562976 570864 577537 591180 600006 601545 606600 610421 667473 673297 675001 731950 781297 781298 789495 808224 ] |
||||||||||||||||||||||||||||||
|
20.43 ms (13.10%) |
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 414115 477085 610421 400125 411284 95640 385248 388066 521595 391027 521877 562976 591180 526372 606600 424556 443716 667473 789495 781298 781297 386626 456710 452448 477141 536012 469893 123271 470303 401597 426718 385077 504112 562248 487864 546684 490538 426154 396079 409405 731950 403268 451566 470747 415319 423963 419410 554246 808224 260297 385359 443689 479117 549560 388687 387599 461478 443844 456585 449123 226028 429446 462713 418346 392967 577537 385287 675001 468176 401583 461118 95586 437152 448518 471416 492739 458831 496230 415380 470562 600006 488710 384801 387636 451567 453783 673297 95991 419623 427185 499431 443700 439660 521276 570864 464513 471587 445363 486435 524853 470596 404598 6679 420060 447832 405802 459120 395378 97288 426365 401584 423907 382567 456142 411118 454127 601545 478353 400932 421162 ] |
||||||||||||||||||||||||||||||
|
2.13 ms (1.37%) |
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 6679 95586 95640 95991 97288 123271 226028 260297 382567 384801 385077 385248 385287 385359 386626 387599 387636 388066 388687 391027 392967 395378 396079 400125 400932 401583 401584 401597 403268 404598 405802 409405 411118 411284 414115 415319 415380 418346 419410 419623 420060 421162 423907 423963 424556 426154 426365 426718 427185 429446 437152 439660 443689 443700 443716 443844 445363 447832 448518 449123 451566 451567 452448 453783 454127 456142 456585 456710 458831 459120 461118 461478 462713 464513 468176 469893 470303 470562 470596 470747 471416 471587 477085 477141 478353 479117 486435 487864 488710 490538 492739 496230 499431 504112 521276 521595 521877 524853 526372 536012 546684 549560 554246 562248 562976 570864 577537 591180 600006 601545 606600 610421 667473 673297 675001 731950 781297 781298 789495 808224 ] |
||||||||||||||||||||||||||||||
|
2.04 ms (1.31%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"2 girls boy"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (1.21%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.52 ms (0.98%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"два девушк парен"
]
|
||||||||||||||||||||||||||||||
|
1.40 ms (0.90%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.