Query Metrics
7
Database Queries
7
Different statements
198.93 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
166.88 ms (83.89%) |
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 391092 401626 407124 407158 407527 418747 418967 426408 443163 445836 452575 455077 457058 458698 459908 460144 461100 466063 466165 467527 467843 469061 470461 471608 471619 471633 472173 481923 482334 482394 485682 488073 488128 489399 490001 490769 493270 494516 499910 500458 503172 504423 509256 511178 513953 517010 517077 517874 519512 522627 525332 527905 529252 529332 531423 532097 534177 539407 539742 539755 539758 541691 543180 549686 549708 549748 549749 554315 556021 556559 558622 561591 561904 563641 566228 566338 569425 570090 570879 573760 580744 581626 582801 583644 586527 588015 589692 591010 591130 591664 600394 600642 603440 604044 605453 612178 614376 618969 621492 624139 625221 625594 626866 633529 649156 667917 673992 674291 678734 687561 691626 696565 716354 745487 749936 798684 813250 813956 820330 820337 ] |
||||||||||||||||||||||||||||||
|
19.96 ms (10.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 467843 482334 554315 563641 600394 591130 605453 452575 466165 481923 469061 471608 401626 407158 407527 459908 466063 467527 470461 493270 517874 488128 490001 490769 503172 531423 504423 517010 519512 529332 499910 457058 539407 798684 525332 549748 561591 566228 569425 573760 582801 583644 588015 624139 618969 625594 745487 749936 813250 541691 418967 455077 458698 500458 539755 539742 534177 460144 472173 482394 445836 511178 509256 494516 600642 813956 580744 649156 426408 443163 418747 471633 488073 489399 517077 532097 529252 522627 539758 471619 485682 558622 391092 461100 407124 513953 527905 820330 820337 549686 549708 556559 543180 549749 570879 566338 687561 678734 667917 673992 674291 691626 696565 716354 556021 561904 570090 581626 625221 626866 633529 586527 591010 591664 603440 604044 614376 621492 612178 589692 ] |
||||||||||||||||||||||||||||||
|
3.46 ms (1.74%) |
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 391092 401626 407124 407158 407527 418747 418967 426408 443163 445836 452575 455077 457058 458698 459908 460144 461100 466063 466165 467527 467843 469061 470461 471608 471619 471633 472173 481923 482334 482394 485682 488073 488128 489399 490001 490769 493270 494516 499910 500458 503172 504423 509256 511178 513953 517010 517077 517874 519512 522627 525332 527905 529252 529332 531423 532097 534177 539407 539742 539755 539758 541691 543180 549686 549708 549748 549749 554315 556021 556559 558622 561591 561904 563641 566228 566338 569425 570090 570879 573760 580744 581626 582801 583644 586527 588015 589692 591010 591130 591664 600394 600642 603440 604044 605453 612178 614376 618969 621492 624139 625221 625594 626866 633529 649156 667917 673992 674291 678734 687561 691626 696565 716354 745487 749936 798684 813250 813956 820330 820337 ] |
||||||||||||||||||||||||||||||
|
2.53 ms (1.27%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"stepson big dick"
]
|
||||||||||||||||||||||||||||||
|
2.23 ms (1.12%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"stepson большой большие член"
]
|
||||||||||||||||||||||||||||||
|
2.04 ms (1.02%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.83 ms (0.92%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"stepson большой большие член"
]
|
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.