Query Metrics
7
Database Queries
7
Different statements
180.88 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
156.26 ms (86.39%) |
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 80470 95742 131623 187824 213614 269974 316911 366296 381951 382604 383326 384373 387325 387785 387848 388189 389015 389487 390545 390956 391683 393105 393496 396549 396656 404777 407378 408502 410623 410754 413768 416036 416142 416242 416707 429046 432723 440747 442627 443300 447574 447693 448557 450313 453106 453750 459261 461713 464687 466774 467208 467603 467616 468610 473775 474596 474670 474772 475873 481464 482627 482730 484279 485106 485361 489127 490310 491010 494086 496964 520665 532675 558307 558948 561649 565045 574089 576078 579011 592289 596184 602723 637632 638047 642109 647983 654275 693719 699631 702620 715698 717107 717919 734681 742234 743773 747579 753024 753169 753595 754185 754350 754496 754809 755396 755889 756696 759402 759519 768587 773598 782127 782647 783124 785154 786795 802676 804762 805313 806479 ] |
||||||||||||||||||||||||||||||
|
14.04 ms (7.76%) |
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 693719 702620 717107 717919 558948 596184 592289 602723 637632 638047 642109 804762 805313 782647 785154 734681 747579 753169 759519 786795 753595 754350 754496 743773 753024 754185 754809 755889 756696 759402 768587 742234 755396 773598 782127 783124 802676 806479 213614 269974 391683 80470 95742 384373 383326 131623 187824 393105 393496 366296 316911 381951 382604 389487 389015 387848 387325 390956 390545 387785 388189 396549 396656 404777 410623 416036 416707 407378 408502 413768 416142 429046 440747 443300 416242 432723 410754 442627 482627 482730 447574 448557 450313 453106 453750 466774 467603 490310 447693 467208 468610 475873 484279 485106 485361 459261 461713 467616 473775 474670 489127 491010 494086 496964 520665 532675 464687 474596 474772 481464 576078 558307 565045 574089 561649 715698 647983 654275 699631 579011 ] |
||||||||||||||||||||||||||||||
|
2.96 ms (1.64%) |
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 80470 95742 131623 187824 213614 269974 316911 366296 381951 382604 383326 384373 387325 387785 387848 388189 389015 389487 390545 390956 391683 393105 393496 396549 396656 404777 407378 408502 410623 410754 413768 416036 416142 416242 416707 429046 432723 440747 442627 443300 447574 447693 448557 450313 453106 453750 459261 461713 464687 466774 467208 467603 467616 468610 473775 474596 474670 474772 475873 481464 482627 482730 484279 485106 485361 489127 490310 491010 494086 496964 520665 532675 558307 558948 561649 565045 574089 576078 579011 592289 596184 602723 637632 638047 642109 647983 654275 693719 699631 702620 715698 717107 717919 734681 742234 743773 747579 753024 753169 753595 754185 754350 754496 754809 755396 755889 756696 759402 759519 768587 773598 782127 782647 783124 785154 786795 802676 804762 805313 806479 ] |
||||||||||||||||||||||||||||||
|
2.21 ms (1.22%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"белокурая"
]
|
||||||||||||||||||||||||||||||
|
2.16 ms (1.19%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.75 ms (0.97%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"беловолосая"
]
|
||||||||||||||||||||||||||||||
|
1.50 ms (0.83%) |
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.