Query Metrics
7
Database Queries
7
Different statements
200.18 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
171.52 ms (85.68%) |
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 23104 183979 382681 383785 387742 388957 396422 397992 398353 407007 409163 409909 413461 423802 427138 433241 434342 440967 441160 446795 449863 450344 453100 453332 453635 465335 466340 469489 474874 475769 476745 478041 480373 480380 480383 480385 480389 480395 480490 483360 488968 493022 494572 500358 504665 506846 513195 513982 518014 518822 521794 526744 527882 528038 528572 530728 533874 535368 535403 541322 544473 544500 545247 546149 547784 549643 549724 555026 555041 555982 559737 570935 572650 574387 574421 586862 592970 592983 599915 600347 605521 607697 610582 631173 633819 636426 647893 649559 657788 661915 665621 671886 716522 719781 720459 724762 728930 732248 734253 761127 788879 788885 794672 800876 801560 801764 802914 806534 815149 815196 815298 815619 815624 815921 816067 816363 816388 816441 816465 816968 ] |
||||||||||||||||||||||||||||||
|
18.11 ms (9.05%) |
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 483360 397992 398353 440967 815149 815298 815619 815921 816388 816441 816465 816363 446795 476745 480490 488968 526744 527882 513982 506846 530728 535403 518014 555982 570935 541322 559737 572650 657788 665621 671886 649559 716522 719781 720459 555041 592970 636426 788879 801764 806534 734253 724762 732248 788885 794672 441160 434342 382681 535368 504665 494572 469489 513195 605521 544500 549643 544473 728930 453100 465335 480373 474874 383785 23104 387742 407007 409909 816067 816968 815624 449863 450344 478041 480389 480383 521794 500358 545247 555026 574387 574421 661915 546149 547784 549724 592983 607697 600347 610582 586862 801560 761127 631173 800876 802914 423802 480395 409163 427138 475769 528572 493022 533874 518822 396422 433241 528038 599915 633819 480380 647893 183979 388957 413461 815196 466340 480385 453332 453635 ] |
||||||||||||||||||||||||||||||
|
3.67 ms (1.83%) |
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 23104 183979 382681 383785 387742 388957 396422 397992 398353 407007 409163 409909 413461 423802 427138 433241 434342 440967 441160 446795 449863 450344 453100 453332 453635 465335 466340 469489 474874 475769 476745 478041 480373 480380 480383 480385 480389 480395 480490 483360 488968 493022 494572 500358 504665 506846 513195 513982 518014 518822 521794 526744 527882 528038 528572 530728 533874 535368 535403 541322 544473 544500 545247 546149 547784 549643 549724 555026 555041 555982 559737 570935 572650 574387 574421 586862 592970 592983 599915 600347 605521 607697 610582 631173 633819 636426 647893 649559 657788 661915 665621 671886 716522 719781 720459 724762 728930 732248 734253 761127 788879 788885 794672 800876 801560 801764 802914 806534 815149 815196 815298 815619 815624 815921 816067 816363 816388 816441 816465 816968 ] |
||||||||||||||||||||||||||||||
|
1.93 ms (0.97%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"wet mature"
]
|
||||||||||||||||||||||||||||||
|
1.91 ms (0.95%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.66 ms (0.83%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"мокрые mature"
]
|
||||||||||||||||||||||||||||||
|
1.38 ms (0.69%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"мокрые mature"
]
|
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.