Query Metrics
7
Database Queries
7
Different statements
181.54 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
155.31 ms (85.55%) |
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 399416 407182 417097 418869 421655 425430 427060 429497 433352 433448 433636 434057 437342 437419 437634 440817 441887 442422 443038 449133 450585 452330 452347 453191 453998 454046 457008 459985 460005 460033 460423 461116 461166 461754 461828 463047 465310 465988 468909 470119 472913 473586 473596 476067 479449 480963 490205 495409 500043 500062 513321 514449 517908 519852 524266 528023 548555 548871 554396 555965 556482 558388 559688 561984 568588 571972 575830 576134 576474 577944 579532 579584 579664 581909 582665 584466 588735 589337 590392 591309 595624 599640 601947 604726 614088 615999 616807 617197 630728 650076 650197 651376 673822 682625 690961 750308 754156 767448 770595 770813 772017 773911 777750 778021 778975 779125 784429 785276 789437 790812 798499 803137 804480 806131 809605 810005 816687 827784 ] |
||||||||||||||||||||||||||||||
|
16.88 ms (9.30%) |
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 803137 804480 810005 433636 437419 460005 433352 524266 601947 407182 604726 399416 514449 433448 453191 480963 513321 459985 461116 463047 555965 579532 650076 651376 556482 615999 778021 784429 809605 754156 770595 785276 789437 806131 767448 772017 750308 773911 770813 778975 434057 465310 472913 441887 460033 500062 490205 495409 827784 473586 473596 779125 690961 425430 437342 443038 417097 421655 429497 440817 418869 427060 437634 442422 816687 450585 452347 457008 465988 476067 449133 452330 453998 454046 461166 461754 470119 517908 519852 500043 528023 460423 461828 468909 479449 576474 548871 558388 575830 576134 579584 548555 554396 559688 568588 570835 571972 573401 582665 682625 650197 673822 561984 577944 579664 581909 584466 616807 588735 590392 595624 599640 614088 617197 589337 591309 630728 777750 790812 798499 ] |
||||||||||||||||||||||||||||||
|
2.48 ms (1.37%) |
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 399416 407182 417097 418869 421655 425430 427060 429497 433352 433448 433636 434057 437342 437419 437634 440817 441887 442422 443038 449133 450585 452330 452347 453191 453998 454046 457008 459985 460005 460033 460423 461116 461166 461754 461828 463047 465310 465988 468909 470119 472913 473586 473596 476067 479449 480963 490205 495409 500043 500062 513321 514449 517908 519852 524266 528023 548555 548871 554396 555965 556482 558388 559688 561984 568588 571972 575830 576134 576474 577944 579532 579584 579664 581909 582665 584466 588735 589337 590392 591309 595624 599640 601947 604726 614088 615999 616807 617197 630728 650076 650197 651376 673822 682625 690961 750308 754156 767448 770595 770813 772017 773911 777750 778021 778975 779125 784429 785276 789437 790812 798499 803137 804480 806131 809605 810005 816687 827784 ] |
||||||||||||||||||||||||||||||
|
2.10 ms (1.16%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"step sister pov"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (0.98%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.62 ms (0.89%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"step sister пов"
]
|
||||||||||||||||||||||||||||||
|
1.37 ms (0.75%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"step sister пов"
]
|
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.