Query Metrics
7
Database Queries
7
Different statements
196.71 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
171.91 ms (87.39%) |
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 382226 389980 397350 399224 401334 406868 410057 410897 411046 416314 419428 420063 421462 426044 428986 429153 434337 436796 438533 443299 443467 444043 450690 452637 455471 456300 456878 463196 464497 470162 471347 474581 481813 489524 492109 496144 498852 505233 505474 505939 506063 507178 520944 521794 522316 523974 524199 529043 532006 540996 541526 548519 551386 551454 552282 554539 554951 558617 558762 560665 561252 562282 563553 567883 571553 578109 578398 580711 584474 586500 593793 596347 596722 597964 598828 603400 603724 606185 609695 615849 619720 632654 636463 648593 651147 653207 653555 660956 666331 667106 675165 676444 677006 681848 684480 685767 689490 689565 717810 722231 727428 728568 730906 730975 741499 743946 744051 745886 757128 757549 788660 807067 809712 814144 817344 819564 820365 824413 825959 826203 ] |
||||||||||||||||||||||||||||||
|
14.02 ms (7.13%) |
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 520944 584474 560665 554539 648593 651147 551454 632654 603724 598828 540996 470162 419428 522316 450690 416314 382226 436796 410057 434337 443467 452637 464497 481813 496144 667106 561252 597964 410897 455471 471347 426044 429153 456300 444043 505233 505474 489524 498852 523974 524199 529043 586500 428986 728568 824413 421462 406868 438533 474581 558617 596722 596347 609695 456878 411046 506063 505939 727428 521794 541526 593793 730975 389980 397350 399224 420063 814144 819564 817344 532006 507178 552282 578109 571553 653207 660956 666331 677006 681848 676444 684480 685767 689490 717810 653555 675165 689565 722231 551386 554951 580711 603400 606185 615849 619720 636463 807067 809712 730906 744051 741499 745886 757128 743946 757549 463196 401334 567883 492109 820365 825959 826203 788660 443299 558762 562282 563553 578398 548519 ] |
||||||||||||||||||||||||||||||
|
3.55 ms (1.80%) |
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 382226 389980 397350 399224 401334 406868 410057 410897 411046 416314 419428 420063 421462 426044 428986 429153 434337 436796 438533 443299 443467 444043 450690 452637 455471 456300 456878 463196 464497 470162 471347 474581 481813 489524 492109 496144 498852 505233 505474 505939 506063 507178 520944 521794 522316 523974 524199 529043 532006 540996 541526 548519 551386 551454 552282 554539 554951 558617 558762 560665 561252 562282 563553 567883 571553 578109 578398 580711 584474 586500 593793 596347 596722 597964 598828 603400 603724 606185 609695 615849 619720 632654 636463 648593 651147 653207 653555 660956 666331 667106 675165 676444 677006 681848 684480 685767 689490 689565 717810 722231 727428 728568 730906 730975 741499 743946 744051 745886 757128 757549 788660 807067 809712 814144 817344 819564 820365 824413 825959 826203 ] |
||||||||||||||||||||||||||||||
|
2.15 ms (1.09%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"small cock masturbation"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (0.90%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"маленькая cock мастурбац"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (0.86%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.62 ms (0.82%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"маленькая cock мастурбац"
]
|
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.