Query Metrics
7
Database Queries
7
Different statements
179.10 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
154.86 ms (86.47%) |
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 278442 403229 417263 419267 421413 422448 427455 428028 429105 433051 433078 433541 433620 434093 434207 434616 436490 437335 447609 447692 449115 450779 451981 452654 457013 457014 459560 461316 465863 466027 470120 478220 480331 499868 505795 513371 521836 523541 524192 530803 533333 535425 535521 536682 540272 541861 549571 557677 559045 560668 565721 569332 569443 574224 576546 577087 578025 595361 597700 597830 601427 601978 602199 605437 613443 615818 617533 624320 625605 628037 632696 637023 637129 650034 656320 671523 682916 688376 695316 696225 696500 702635 704208 704261 706118 707650 708450 709850 712541 717845 717986 721150 722101 723131 723287 732878 733857 735614 736265 758780 760955 765357 767236 770376 780610 781621 788923 791160 792173 794090 800565 803485 806162 806797 811621 812827 814257 814556 821765 826182 ] |
||||||||||||||||||||||||||||||
|
14.30 ms (7.99%) |
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 419267 421413 422448 434093 480331 478220 576546 505795 434616 814257 821765 826182 452654 499868 540272 569443 565721 557677 656320 671523 708450 707650 709850 722101 717845 717986 637129 625605 597700 780610 792173 794090 800565 788923 791160 811621 812827 736265 758780 760955 767236 806162 733857 735614 765357 770376 613443 632696 702635 704261 721150 781621 803485 806797 433051 433620 447609 278442 403229 434207 457013 459560 461316 417263 450779 637023 732878 615818 574224 569332 427455 429105 437335 470120 533333 521836 523541 535521 465863 577087 560668 602199 617533 597830 601978 624320 601427 433078 428028 513371 524192 449115 433541 436490 814556 447692 457014 451981 466027 535425 530803 536682 578025 541861 559045 696500 723131 650034 682916 688376 704208 712541 695316 696225 706118 723287 549571 628037 595361 605437 ] |
||||||||||||||||||||||||||||||
|
2.87 ms (1.60%) |
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 278442 403229 417263 419267 421413 422448 427455 428028 429105 433051 433078 433541 433620 434093 434207 434616 436490 437335 447609 447692 449115 450779 451981 452654 457013 457014 459560 461316 465863 466027 470120 478220 480331 499868 505795 513371 521836 523541 524192 530803 533333 535425 535521 536682 540272 541861 549571 557677 559045 560668 565721 569332 569443 574224 576546 577087 578025 595361 597700 597830 601427 601978 602199 605437 613443 615818 617533 624320 625605 628037 632696 637023 637129 650034 656320 671523 682916 688376 695316 696225 696500 702635 704208 704261 706118 707650 708450 709850 712541 717845 717986 721150 722101 723131 723287 732878 733857 735614 736265 758780 760955 765357 767236 770376 780610 781621 788923 791160 792173 794090 800565 803485 806162 806797 811621 812827 814257 814556 821765 826182 ] |
||||||||||||||||||||||||||||||
|
2.10 ms (1.17%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"tattoo teen cum"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (1.02%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"татуированные teen cum"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (1.02%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"татуированные teen cum"
]
|
||||||||||||||||||||||||||||||
|
1.30 ms (0.73%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.