Query Metrics
7
Database Queries
7
Different statements
173.51 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
147.36 ms (84.93%) |
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 391482 411884 422155 426003 428580 433291 433359 439695 439713 442661 454048 456603 457301 457437 457449 460189 461601 463699 469399 477335 481161 492331 493155 493158 495394 499327 504423 506135 510074 510222 512531 513113 513143 520683 521176 524272 524331 525551 526525 526997 527778 527991 528087 531979 532064 535662 536944 540549 546199 547993 549747 549825 555223 555233 555927 556806 557612 562964 565339 565341 567730 568539 569217 580750 581723 582797 592907 604138 604306 605999 607697 655186 673772 691228 693208 751560 756115 759369 764151 765297 771974 773000 774394 777794 783777 788942 788945 795142 795143 795954 798572 801542 801562 802620 803957 805434 807133 807402 808636 814218 814288 814359 815081 815111 815115 815128 815616 816326 817747 820417 820542 820641 821422 821734 821899 822623 823510 823672 827842 827903 ] |
||||||||||||||||||||||||||||||
|
15.40 ms (8.87%) |
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 442661 457301 463699 693208 815115 428580 815111 820542 821899 822623 823672 815081 817747 815128 820417 827842 460189 513143 531979 532064 527778 525551 547993 555223 581723 555927 557612 567730 788945 798572 777794 771974 773000 751560 783777 802620 808636 391482 426003 469399 477335 526997 506135 524272 546199 565339 607697 765297 807133 795954 411884 520683 540549 510074 492331 439695 439713 513113 521176 422155 821734 774394 814288 815616 820641 814359 816326 814218 821422 823510 827903 454048 461601 536944 527991 535662 495394 549747 569217 655186 673772 568539 592907 604306 604138 788942 801562 795143 805434 764151 795142 756115 759369 605999 801542 803957 807402 499327 512531 691228 481161 510222 528087 582797 549825 555233 556806 565341 562964 580750 433291 433359 457449 457437 456603 526525 493155 493158 504423 524331 ] |
||||||||||||||||||||||||||||||
|
3.01 ms (1.74%) |
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 391482 411884 422155 426003 428580 433291 433359 439695 439713 442661 454048 456603 457301 457437 457449 460189 461601 463699 469399 477335 481161 492331 493155 493158 495394 499327 504423 506135 510074 510222 512531 513113 513143 520683 521176 524272 524331 525551 526525 526997 527778 527991 528087 531979 532064 535662 536944 540549 546199 547993 549747 549825 555223 555233 555927 556806 557612 562964 565339 565341 567730 568539 569217 580750 581723 582797 592907 604138 604306 605999 607697 655186 673772 691228 693208 751560 756115 759369 764151 765297 771974 773000 774394 777794 783777 788942 788945 795142 795143 795954 798572 801542 801562 802620 803957 805434 807133 807402 808636 814218 814288 814359 815081 815111 815115 815128 815616 816326 817747 820417 820542 820641 821422 821734 821899 822623 823510 823672 827842 827903 ] |
||||||||||||||||||||||||||||||
|
2.43 ms (1.40%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mature pov mom"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (1.03%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.77 ms (1.02%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mature пов mom"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (1.00%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mature пов mom"
]
|
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.