Query Metrics
7
Database Queries
7
Different statements
404.24 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
211.29 ms (52.27%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
171.45 ms (42.41%) |
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 187516 382434 386866 390728 407887 411390 412988 453096 466278 470201 471405 474506 474843 477994 479027 484437 486350 488362 490193 502029 502724 505628 526708 537836 549247 555077 557137 557148 560383 560430 563413 589707 592924 601869 623493 650388 663375 663432 663957 664281 664290 665095 665235 665270 665456 666156 667291 667607 667772 675512 681295 687524 696316 707282 710502 710531 712332 712812 713635 714909 718549 718559 718570 720533 720599 721267 721477 721974 721987 723984 724302 724702 725363 727050 727927 728228 728237 728266 728348 730352 732356 733055 733078 733943 734332 734691 735023 735484 738000 738070 739686 739948 742249 742433 742704 742949 743724 743773 744339 745196 746598 747095 747230 749907 758311 761012 766695 785932 807376 808456 817555 817772 818630 818638 818810 819019 819615 823444 823691 823806 ] |
||||||||||||||||||||||||||||||
|
12.21 ms (3.02%) |
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 819615 823691 557148 707282 664281 712812 589707 727927 743773 667607 721267 665235 718570 720533 557137 592924 744339 742949 738000 747230 739686 386866 818630 818638 823806 474843 560383 663432 714909 650388 664290 667291 681295 665095 696316 712332 713635 718549 601869 785932 807376 723984 734332 808456 724702 725363 728348 732356 749907 727050 728237 742704 724302 735484 728228 742433 761012 766695 623493 710531 718559 720599 390728 411390 187516 490193 502724 823444 817555 819019 817772 537836 474506 721477 710502 675512 721974 721987 747095 758311 733055 733078 733943 728266 742249 745196 734691 743724 746598 453096 486350 563413 560430 730352 382434 470201 412988 488362 466278 484437 505628 526708 549247 471405 479027 477994 502029 818810 555077 665270 663375 663957 666156 667772 665456 687524 735023 739948 738070 407887 ] |
||||||||||||||||||||||||||||||
|
2.81 ms (0.70%) |
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 187516 382434 386866 390728 407887 411390 412988 453096 466278 470201 471405 474506 474843 477994 479027 484437 486350 488362 490193 502029 502724 505628 526708 537836 549247 555077 557137 557148 560383 560430 563413 589707 592924 601869 623493 650388 663375 663432 663957 664281 664290 665095 665235 665270 665456 666156 667291 667607 667772 675512 681295 687524 696316 707282 710502 710531 712332 712812 713635 714909 718549 718559 718570 720533 720599 721267 721477 721974 721987 723984 724302 724702 725363 727050 727927 728228 728237 728266 728348 730352 732356 733055 733078 733943 734332 734691 735023 735484 738000 738070 739686 739948 742249 742433 742704 742949 743724 743773 744339 745196 746598 747095 747230 749907 758311 761012 766695 785932 807376 808456 817555 817772 818630 818638 818810 819019 819615 823444 823691 823806 ] |
||||||||||||||||||||||||||||||
|
2.54 ms (0.63%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mature cock"
]
|
||||||||||||||||||||||||||||||
|
1.97 ms (0.49%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mature cock"
]
|
||||||||||||||||||||||||||||||
|
1.96 ms (0.49%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mature 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.