Query Metrics
7
Database Queries
7
Different statements
209.83 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
183.94 ms (87.66%) |
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 229566 384270 387615 388115 390344 410872 412326 419849 423552 431488 441748 453486 456130 461124 464809 468788 474053 478313 482053 482585 487101 488651 498724 498845 503179 503774 506070 506977 508953 509400 514787 516534 521387 523237 524332 525787 527119 528102 529155 529500 536372 541474 542300 550472 557386 558576 559007 565877 567150 571096 574068 579617 582497 585112 599670 603051 603594 605496 606382 607246 609072 609965 610680 613155 615849 619895 636487 644517 645994 659349 659423 664524 674216 678910 685728 692696 701552 708389 708752 709369 712212 712896 714258 716283 717187 723622 723629 724411 725165 727398 730642 734017 739769 741210 750195 755369 757094 760396 763955 764317 765584 766528 766721 768939 774966 779102 780300 782594 786163 788361 795023 799153 802884 802885 809998 818459 818461 821186 824123 ] |
||||||||||||||||||||||||||||||
|
15.41 ms (7.34%) |
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 760396 786163 727398 734017 765584 741210 750195 757094 766528 708752 779102 799153 387615 482053 229566 412326 506070 523237 605496 384270 824123 585112 723622 821186 498845 503179 464809 482585 542300 558576 659349 716283 717187 685728 674216 678910 708389 712896 718662 609965 607246 603594 606382 619895 636487 780300 724411 730642 764317 788361 809998 755369 768939 613155 709369 712212 441748 423552 527119 536372 567150 579617 599670 516534 390344 410872 818459 503774 529500 521387 506977 557386 565877 571096 692696 645994 659423 664524 701552 714258 582497 615849 609072 610680 644517 603051 782594 795023 802884 802885 766721 763955 725165 739769 774966 468788 478313 388115 419849 431488 818461 723629 453486 456130 461124 487101 488651 529155 498724 509400 514787 524332 525787 528102 508953 474053 541474 550472 559007 574068 ] |
||||||||||||||||||||||||||||||
|
3.05 ms (1.45%) |
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 229566 384270 387615 388115 390344 410872 412326 419849 423552 431488 441748 453486 456130 461124 464809 468788 474053 478313 482053 482585 487101 488651 498724 498845 503179 503774 506070 506977 508953 509400 514787 516534 521387 523237 524332 525787 527119 528102 529155 529500 536372 541474 542300 550472 557386 558576 559007 565877 567150 571096 574068 579617 582497 585112 599670 603051 603594 605496 606382 607246 609072 609965 610680 613155 615849 619895 636487 644517 645994 659349 659423 664524 674216 678910 685728 692696 701552 708389 708752 709369 712212 712896 714258 716283 717187 723622 723629 724411 725165 727398 730642 734017 739769 741210 750195 755369 757094 760396 763955 764317 765584 766528 766721 768939 774966 779102 780300 782594 786163 788361 795023 799153 802884 802885 809998 818459 818461 821186 824123 ] |
||||||||||||||||||||||||||||||
|
1.95 ms (0.93%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"pussy girlfriend"
]
|
||||||||||||||||||||||||||||||
|
1.94 ms (0.93%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.86 ms (0.88%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"pussy girlfriend"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (0.80%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"pussy girlfriend"
]
|
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.