Query Metrics
7
Database Queries
7
Different statements
219.66 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
197.61 ms (89.96%) |
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 80536 185296 382396 383597 390209 390229 393058 405505 407141 413300 415623 416384 417416 418922 422233 422252 423584 431427 448504 451961 456792 459231 460960 463867 490070 498816 503064 505062 509278 509720 510033 511599 515779 519946 523214 525239 532110 538343 551386 551402 555384 557519 559958 561399 561667 567565 568369 569454 569827 571293 576381 577775 580742 583283 584389 584610 592364 593330 598268 599669 609731 610266 618284 620105 628345 628677 644780 655418 662401 666321 673052 701873 706432 708760 708913 710881 710998 714958 717327 721091 724502 725347 727728 728171 730498 730948 738432 741796 743857 746553 748450 750922 755362 758306 767616 767748 772188 775621 779738 779817 786549 787136 794574 795576 797688 797698 797706 798197 799313 800140 800257 800738 802179 808761 811236 814570 815824 817028 824806 825715 ] |
||||||||||||||||||||||||||||||
|
12.62 ms (5.74%) |
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 577775 620105 592364 599669 460960 557519 568369 610266 593330 727728 413300 422252 673052 800140 800257 755362 730498 767616 746553 717327 797706 758306 741796 644780 382396 390209 423584 551386 538343 418922 498816 815824 721091 708913 655418 708760 561667 798197 795576 750922 797698 730948 743857 725347 748450 772188 523214 569827 567565 799313 779817 786549 787136 407141 551402 555384 580742 628345 431427 510033 185296 519946 559958 584610 417416 503064 511599 779738 724502 393058 390229 814570 817028 666321 710881 618284 808761 811236 794574 800738 802179 797688 767748 738432 701873 775621 505062 383597 609731 463867 490070 569454 405505 451961 515779 415623 576381 583283 422233 448504 509720 525239 509278 598268 80536 459231 584389 456792 416384 824806 825715 532110 561399 662401 706432 710998 714958 571293 628677 728171 ] |
||||||||||||||||||||||||||||||
|
3.10 ms (1.41%) |
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 80536 185296 382396 383597 390209 390229 393058 405505 407141 413300 415623 416384 417416 418922 422233 422252 423584 431427 448504 451961 456792 459231 460960 463867 490070 498816 503064 505062 509278 509720 510033 511599 515779 519946 523214 525239 532110 538343 551386 551402 555384 557519 559958 561399 561667 567565 568369 569454 569827 571293 576381 577775 580742 583283 584389 584610 592364 593330 598268 599669 609731 610266 618284 620105 628345 628677 644780 655418 662401 666321 673052 701873 706432 708760 708913 710881 710998 714958 717327 721091 724502 725347 727728 728171 730498 730948 738432 741796 743857 746553 748450 750922 755362 758306 767616 767748 772188 775621 779738 779817 786549 787136 794574 795576 797688 797698 797706 798197 799313 800140 800257 800738 802179 808761 811236 814570 815824 817028 824806 825715 ] |
||||||||||||||||||||||||||||||
|
1.81 ms (0.83%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"дроча массаж"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (0.72%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"дрочк массаж"
]
|
||||||||||||||||||||||||||||||
|
1.48 ms (0.67%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.47 ms (0.67%) |
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.