Query Metrics
7
Database Queries
7
Different statements
201.12 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
177.89 ms (88.45%) |
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 6643 91146 96514 233187 236765 315244 327121 382637 382874 383387 385438 388350 388771 389518 389726 389945 390574 395562 396142 397932 399722 400728 401342 401426 401993 404386 404418 404587 404596 405990 410430 412315 413057 414498 420201 421228 421977 423495 424407 429879 432611 434055 443164 447745 448332 448795 450251 450854 454577 457492 458929 461296 464147 468481 473525 478452 485458 487414 488378 490520 492165 502775 506835 506836 510876 512902 519573 522923 530429 542707 544468 549123 559406 561743 574578 576537 577079 578701 583079 584004 591197 592945 601516 661411 671704 671721 673813 680801 687211 687560 693208 693529 700669 707227 708525 709239 715004 715095 716461 726641 728669 729301 732179 735442 746325 748068 758068 761756 771560 801471 817199 817262 821511 821599 824868 824939 825044 826783 827326 827609 ] |
||||||||||||||||||||||||||||||
|
14.15 ms (7.04%) |
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 490520 327121 450854 388350 404596 399722 390574 401426 673813 726641 488378 424407 817262 6643 383387 464147 447745 522923 405990 432611 817199 735442 542707 715095 410430 583079 420201 389726 824868 404418 821599 450251 561743 423495 715004 404386 708525 414498 429879 434055 382637 544468 700669 96514 709239 421977 510876 707227 716461 748068 413057 457492 448795 827326 801471 584004 824939 826783 389945 492165 506835 827609 396142 577079 687211 549123 559406 729301 388771 576537 601516 397932 404587 506836 473525 728669 382874 401342 732179 821511 661411 315244 591197 421228 458929 395562 389518 771560 443164 461296 468481 487414 512902 530429 592945 761756 578701 671721 478452 454577 401993 671704 680801 693208 746325 758068 448332 236765 825044 485458 400728 519573 385438 693529 91146 233187 412315 574578 502775 687560 ] |
||||||||||||||||||||||||||||||
|
2.79 ms (1.39%) |
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 6643 91146 96514 233187 236765 315244 327121 382637 382874 383387 385438 388350 388771 389518 389726 389945 390574 395562 396142 397932 399722 400728 401342 401426 401993 404386 404418 404587 404596 405990 410430 412315 413057 414498 420201 421228 421977 423495 424407 429879 432611 434055 443164 447745 448332 448795 450251 450854 454577 457492 458929 461296 464147 468481 473525 478452 485458 487414 488378 490520 492165 502775 506835 506836 510876 512902 519573 522923 530429 542707 544468 549123 559406 561743 574578 576537 577079 578701 583079 584004 591197 592945 601516 661411 671704 671721 673813 680801 687211 687560 693208 693529 700669 707227 708525 709239 715004 715095 716461 726641 728669 729301 732179 735442 746325 748068 758068 761756 771560 801471 817199 817262 821511 821599 824868 824939 825044 826783 827326 827609 ] |
||||||||||||||||||||||||||||||
|
1.83 ms (0.91%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"hairy anal fuck"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (0.82%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"волосатая анал секс"
]
|
||||||||||||||||||||||||||||||
|
1.49 ms (0.74%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.32 ms (0.65%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"волосатая анал секс"
]
|
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.