Query Metrics
7
Database Queries
7
Different statements
215.72 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
185.66 ms (86.07%) |
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 383409 387155 396524 403042 403052 406800 408832 410950 416066 416244 417102 417773 418286 420386 423490 426250 429910 435973 437476 438466 445109 447848 450585 451726 453505 453694 453802 455390 457679 457869 459963 462865 463118 465873 468025 468119 468274 470317 472122 474583 475076 479943 482937 487172 487654 488361 489035 491170 494814 497430 503947 508534 509180 509494 513051 516883 517641 521488 521607 521650 523157 524598 526126 533566 534077 535699 539293 541840 547718 549149 553225 558076 571474 574240 575380 577792 577896 583536 585437 586965 597260 618364 619994 633684 636658 649511 652513 671724 677874 685889 686749 700846 706475 711946 714469 715792 716076 717297 717906 720421 720755 722585 727611 735593 740407 740689 743345 744290 748695 751512 772815 777306 787515 794906 810702 812105 814616 815877 818297 822660 ] |
||||||||||||||||||||||||||||||
|
20.12 ms (9.32%) |
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 810702 387155 521488 517641 438466 447848 408832 508534 406800 445109 558076 720755 714469 586965 618364 740407 403042 722585 700846 740689 685889 652513 619994 735593 453505 416066 513051 777306 489035 524598 423490 716076 727611 403052 410950 457869 794906 468025 509180 494814 383409 523157 597260 465873 547718 521607 533566 450585 822660 649511 717297 686749 516883 539293 429910 468274 459963 706475 497430 420386 453694 482937 571474 751512 526126 474583 577896 585437 453802 417773 491170 487654 671724 463118 487172 509494 717906 468119 396524 416244 455390 720421 418286 583536 744290 818297 417102 535699 549149 475076 470317 479943 472122 488361 534077 503947 541840 743345 772815 812105 748695 426250 451726 457679 574240 435973 462865 437476 521650 815877 814616 553225 715792 677874 633684 636658 787515 575380 577792 711946 ] |
||||||||||||||||||||||||||||||
|
2.76 ms (1.28%) |
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 383409 387155 396524 403042 403052 406800 408832 410950 416066 416244 417102 417773 418286 420386 423490 426250 429910 435973 437476 438466 445109 447848 450585 451726 453505 453694 453802 455390 457679 457869 459963 462865 463118 465873 468025 468119 468274 470317 472122 474583 475076 479943 482937 487172 487654 488361 489035 491170 494814 497430 503947 508534 509180 509494 513051 516883 517641 521488 521607 521650 523157 524598 526126 533566 534077 535699 539293 541840 547718 549149 553225 558076 571474 574240 575380 577792 577896 583536 585437 586965 597260 618364 619994 633684 636658 649511 652513 671724 677874 685889 686749 700846 706475 711946 714469 715792 716076 717297 717906 720421 720755 722585 727611 735593 740407 740689 743345 744290 748695 751512 772815 777306 787515 794906 810702 812105 814616 815877 818297 822660 ] |
||||||||||||||||||||||||||||||
|
2.04 ms (0.94%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"little dick fuck"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (0.85%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"little член секс"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (0.82%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.53 ms (0.71%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"little член секс"
]
|
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.