Query Metrics
7
Database Queries
7
Different statements
218.91 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
191.83 ms (87.63%) |
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 340635 391923 409083 419554 422338 424426 427100 439518 442997 443360 443670 443673 443704 443725 443726 443760 443763 443787 443792 443793 443809 444000 448714 449178 451473 454248 455373 456516 460745 460924 461944 462019 462022 462126 462522 464326 464944 465952 466195 466269 467893 467905 468072 468897 470503 470514 470692 470763 470922 474214 474700 476252 476339 477707 477934 477980 477989 479139 484359 484365 484392 484573 484591 484605 484630 484670 485696 485774 485924 486915 489087 490914 491986 494296 496506 500414 501997 506028 509430 510533 510794 511375 517021 518842 518853 519753 520894 523031 525468 525884 526729 526737 529245 544502 546939 547601 547928 549771 558314 559057 576643 583615 590258 591922 592985 610695 658797 678716 714468 714476 725239 731398 733254 754656 766349 803404 807340 807884 811736 826789 ] |
||||||||||||||||||||||||||||||
|
17.70 ms (8.08%) |
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 523031 470922 443360 526729 549771 424426 443787 449178 519753 558314 678716 714476 658797 592985 509430 525468 476252 807340 442997 444000 466269 451473 465952 485696 484392 500414 477707 510533 547601 547928 559057 590258 811736 340635 409083 462022 419554 477989 443725 443760 526737 484591 501997 484573 484605 506028 529245 511375 462522 477934 731398 826789 517021 803404 754656 725239 733254 766349 807884 391923 464326 439518 443704 468072 484365 518853 525884 443793 461944 468897 489087 546939 462126 448714 477980 470503 443673 462019 496506 474700 484670 484630 583615 576643 443809 456516 460745 467893 464944 466195 443670 460924 470763 476339 422338 443726 443763 443792 454248 470514 518842 485774 486915 484359 491986 494296 610695 470692 485924 479139 474214 510794 520894 490914 544502 714468 591922 467905 455373 427100 ] |
||||||||||||||||||||||||||||||
|
2.99 ms (1.36%) |
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 340635 391923 409083 419554 422338 424426 427100 439518 442997 443360 443670 443673 443704 443725 443726 443760 443763 443787 443792 443793 443809 444000 448714 449178 451473 454248 455373 456516 460745 460924 461944 462019 462022 462126 462522 464326 464944 465952 466195 466269 467893 467905 468072 468897 470503 470514 470692 470763 470922 474214 474700 476252 476339 477707 477934 477980 477989 479139 484359 484365 484392 484573 484591 484605 484630 484670 485696 485774 485924 486915 489087 490914 491986 494296 496506 500414 501997 506028 509430 510533 510794 511375 517021 518842 518853 519753 520894 523031 525468 525884 526729 526737 529245 544502 546939 547601 547928 549771 558314 559057 576643 583615 590258 591922 592985 610695 658797 678716 714468 714476 725239 731398 733254 754656 766349 803404 807340 807884 811736 826789 ] |
||||||||||||||||||||||||||||||
|
1.87 ms (0.86%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"russian hairy mature"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (0.75%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.52 ms (0.69%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск волосатая mature"
]
|
||||||||||||||||||||||||||||||
|
1.37 ms (0.62%) |
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.