Query Metrics
7
Database Queries
7
Different statements
168.26 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
137.61 ms (81.78%) |
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 159511 304300 385831 393245 396635 398144 415515 415905 416242 423958 424014 424129 425144 427972 429211 429228 445868 448805 450098 450251 450579 455694 459617 459803 461677 461957 462143 463818 465501 465613 466603 468603 468943 469119 471696 474724 474776 480450 484261 493256 494665 496049 499927 500100 503118 516771 517038 517655 518083 523623 526533 526766 527490 527915 530483 533644 534812 538802 542216 544668 550680 552021 552965 553765 555389 555407 558711 560065 561271 562706 566901 568519 576509 581933 586086 588298 590262 590373 590843 591995 594283 597803 602948 604483 618301 619376 624079 624925 627442 637975 645238 646450 648618 653720 665259 679636 680625 680928 683878 687583 692714 695923 697833 702336 705768 712832 758832 766637 785777 791537 792746 793492 794895 801313 801762 803628 805434 810347 813558 815492 ] |
||||||||||||||||||||||||||||||
|
20.16 ms (11.98%) |
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 415905 416242 474776 465501 450251 463818 500100 555389 680928 560065 590843 590373 424129 425144 468943 480450 450098 459803 459617 526766 468603 558711 415515 517655 695923 702336 683878 801313 758832 791537 794895 697833 792746 518083 552965 591995 448805 527915 553765 159511 398144 493256 517038 496049 555407 687583 562706 590262 766637 461677 423958 429228 455694 618301 705768 429211 461957 527490 813558 484261 534812 576509 653720 665259 712832 679636 552021 624079 594283 810347 637975 793492 801762 462143 393245 469119 523623 526533 494665 544668 445868 533644 624925 396635 815492 530483 538802 602948 466603 516771 503118 550680 542216 588298 427972 465613 450579 646450 568519 581933 586086 424014 645238 604483 385831 304300 471696 474724 499927 561271 648618 692714 680625 566901 619376 597803 627442 785777 803628 805434 ] |
||||||||||||||||||||||||||||||
|
3.46 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 159511 304300 385831 393245 396635 398144 415515 415905 416242 423958 424014 424129 425144 427972 429211 429228 445868 448805 450098 450251 450579 455694 459617 459803 461677 461957 462143 463818 465501 465613 466603 468603 468943 469119 471696 474724 474776 480450 484261 493256 494665 496049 499927 500100 503118 516771 517038 517655 518083 523623 526533 526766 527490 527915 530483 533644 534812 538802 542216 544668 550680 552021 552965 553765 555389 555407 558711 560065 561271 562706 566901 568519 576509 581933 586086 588298 590262 590373 590843 591995 594283 597803 602948 604483 618301 619376 624079 624925 627442 637975 645238 646450 648618 653720 665259 679636 680625 680928 683878 687583 692714 695923 697833 702336 705768 712832 758832 766637 785777 791537 792746 793492 794895 801313 801762 803628 805434 810347 813558 815492 ] |
||||||||||||||||||||||||||||||
|
2.13 ms (1.26%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"public anal toys"
]
|
||||||||||||||||||||||||||||||
|
1.86 ms (1.11%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.60 ms (0.95%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"на улиц анал toys"
]
|
||||||||||||||||||||||||||||||
|
1.45 ms (0.86%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"на улиц анал toys"
]
|
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.