Query Metrics
7
Database Queries
7
Different statements
155.27 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
129.25 ms (83.24%) |
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 399152 412535 415814 417403 420849 421861 422280 424124 424129 428929 433729 435046 439743 443182 447496 459223 461388 462556 465382 470810 472346 474783 474880 476475 477902 479955 487176 488297 491336 491367 491374 494095 497585 499667 505540 505578 506239 508834 509271 509491 512147 516303 521000 521519 521974 522438 525848 528465 543708 543839 544110 546775 547903 548618 552373 552695 558213 558592 558999 562244 562484 563251 564670 565007 566941 567635 569443 577401 579532 582477 582589 589226 590622 594577 603761 608070 609402 610522 620716 621733 623216 643334 647060 651895 662391 662431 668139 671193 678696 679090 680682 681371 685061 685263 685823 692817 696911 699231 708130 721249 731020 732577 733330 733672 741076 751507 757776 761688 768989 780085 780676 786791 793944 799145 799864 804877 805643 808585 823359 ] |
||||||||||||||||||||||||||||||
|
16.46 ms (10.60%) |
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 799145 805643 412535 422280 509271 505578 528465 487176 521000 509491 497585 823359 459223 579532 543839 671193 681371 651895 679090 685263 699231 678696 680682 685823 708130 610522 621733 623216 603761 643334 589226 608070 609402 799864 780676 786791 808585 731020 733330 761688 793944 804877 732577 733672 741076 751507 757776 768989 620716 696911 780085 399152 476475 470810 491374 522438 491336 512147 474783 494095 546775 558592 582477 552695 565007 558213 558999 563251 582589 590622 594577 424129 439743 447496 465382 479955 417403 433729 461388 415814 421861 424124 435046 472346 474880 525848 508834 521974 488297 506239 516303 491367 499667 543708 668139 599106 428929 462556 420849 443182 521519 505540 477902 548618 569443 577401 544110 562244 562484 567635 547903 552373 564670 566941 685061 692817 721249 647060 662391 662431 ] |
||||||||||||||||||||||||||||||
|
3.20 ms (2.06%) |
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 399152 412535 415814 417403 420849 421861 422280 424124 424129 428929 433729 435046 439743 443182 447496 459223 461388 462556 465382 470810 472346 474783 474880 476475 477902 479955 487176 488297 491336 491367 491374 494095 497585 499667 505540 505578 506239 508834 509271 509491 512147 516303 521000 521519 521974 522438 525848 528465 543708 543839 544110 546775 547903 548618 552373 552695 558213 558592 558999 562244 562484 563251 564670 565007 566941 567635 569443 577401 579532 582477 582589 589226 590622 594577 603761 608070 609402 610522 620716 621733 623216 643334 647060 651895 662391 662431 668139 671193 678696 679090 680682 681371 685061 685263 685823 692817 696911 699231 708130 721249 731020 732577 733330 733672 741076 751507 757776 761688 768989 780085 780676 786791 793944 799145 799864 804877 805643 808585 823359 ] |
||||||||||||||||||||||||||||||
|
1.87 ms (1.21%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"real rus"
]
|
||||||||||||||||||||||||||||||
|
1.50 ms (0.97%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"real русск"
]
|
||||||||||||||||||||||||||||||
|
1.49 ms (0.96%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"real русск"
]
|
||||||||||||||||||||||||||||||
|
1.49 ms (0.96%) |
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.