Query Metrics
7
Database Queries
7
Different statements
142.65 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
119.68 ms (83.90%) |
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 237293 381958 382252 383290 388949 391219 391395 398263 401704 402555 415541 419111 430508 447243 447244 448678 451216 453333 460808 461625 462185 465620 466770 467986 469326 471437 471610 476837 486442 486553 491874 506362 510423 511057 511061 511683 512422 515860 519754 520325 521999 525502 525667 527995 528844 529884 531075 531720 535898 536569 546080 547881 548143 548880 551682 551689 553429 556592 556989 560141 561076 562685 567628 575688 577562 578161 582793 582852 584541 586552 589548 593288 593340 593344 602741 604863 604904 614601 620344 620825 633022 641138 665210 666808 667498 675965 676890 692042 695867 700855 701439 705677 719648 720631 731807 738297 751978 757909 772151 773224 773681 784471 791134 795278 801098 802316 803741 803827 806132 806405 807390 808025 808740 809155 811259 811496 812791 814912 818505 826774 ] |
||||||||||||||||||||||||||||||
|
12.82 ms (8.99%) |
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 676890 633022 430508 486442 451216 520325 802316 401704 460808 512422 529884 561076 701439 589548 731807 675965 757909 531075 551689 620344 751978 738297 382252 665210 667498 551682 806132 528844 531720 614601 593340 791134 803741 806405 803827 808025 381958 383290 519754 578161 556989 692042 593288 593344 604904 419111 469326 466770 510423 465620 582793 560141 584541 527995 525502 515860 402555 814912 826774 553429 546080 719648 720631 818505 447243 548880 602741 812791 388949 801098 525667 536569 535898 506362 547881 700855 604863 586552 391395 511057 486553 511061 521999 237293 448678 577562 567628 666808 705677 695867 811259 641138 391219 461625 784471 795278 773681 807390 471610 556592 582852 620825 548143 575688 809155 808740 398263 415541 453333 467986 462185 511683 491874 811496 772151 773224 476837 447244 471437 562685 ] |
||||||||||||||||||||||||||||||
|
2.63 ms (1.84%) |
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 237293 381958 382252 383290 388949 391219 391395 398263 401704 402555 415541 419111 430508 447243 447244 448678 451216 453333 460808 461625 462185 465620 466770 467986 469326 471437 471610 476837 486442 486553 491874 506362 510423 511057 511061 511683 512422 515860 519754 520325 521999 525502 525667 527995 528844 529884 531075 531720 535898 536569 546080 547881 548143 548880 551682 551689 553429 556592 556989 560141 561076 562685 567628 575688 577562 578161 582793 582852 584541 586552 589548 593288 593340 593344 602741 604863 604904 614601 620344 620825 633022 641138 665210 666808 667498 675965 676890 692042 695867 700855 701439 705677 719648 720631 731807 738297 751978 757909 772151 773224 773681 784471 791134 795278 801098 802316 803741 803827 806132 806405 807390 808025 808740 809155 811259 811496 812791 814912 818505 826774 ] |
||||||||||||||||||||||||||||||
|
2.22 ms (1.56%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big boobs sex"
]
|
||||||||||||||||||||||||||||||
|
1.89 ms (1.33%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.80 ms (1.26%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие boobs секс"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (1.13%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большие boobs секс"
]
|
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.