Query Metrics
7
Database Queries
7
Different statements
207.60 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
182.41 ms (87.87%) |
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 382785 443173 461053 465327 471009 471013 477527 483359 484234 491240 506309 509185 516937 517490 517513 517519 517534 522333 526013 533884 537651 538480 539416 540568 544236 545968 547807 550186 553283 554804 555035 555055 555503 556341 556586 558172 559342 561513 561524 562418 565630 565636 565726 570948 571755 573168 574389 576455 577073 578010 580503 580819 581520 582545 582765 585694 587606 589171 590946 593387 593538 593820 596732 596769 599398 600399 604999 605009 607182 612091 614770 614772 614782 614794 614797 614798 614819 614865 615922 626572 633204 636210 649437 649936 650519 657768 666433 677146 696108 705053 706422 709898 710374 710458 710586 714510 717621 718487 734251 736901 742549 744470 746114 760170 760609 784036 790396 790630 791861 793559 797333 803026 804453 807405 808158 811912 812383 816169 816170 819964 ] |
||||||||||||||||||||||||||||||
|
15.17 ms (7.31%) |
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 614865 585694 593387 596769 612091 614797 742549 590946 558172 506309 650519 706422 710586 666433 705053 649437 649936 677146 710458 607182 636210 589171 599398 626572 600399 614770 614794 596732 605009 614772 614798 614819 734251 614782 709898 517534 538480 570948 744470 443173 816169 819964 816170 484234 461053 471009 509185 522333 540568 537651 477527 561524 576455 582765 555503 577073 550186 565630 573168 580819 696108 565636 580503 587606 593820 615922 593538 790396 811912 812383 784036 790630 807405 736901 746114 793559 803026 804453 808158 760170 760609 714510 717621 718487 791861 797333 471013 526013 517490 547807 555055 556341 556586 565726 562418 545968 633204 578010 581520 710374 571755 382785 465327 517519 483359 657768 516937 517513 533884 539416 554804 561513 553283 582545 604999 491240 544236 555035 559342 574389 ] |
||||||||||||||||||||||||||||||
|
3.37 ms (1.62%) |
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 382785 443173 461053 465327 471009 471013 477527 483359 484234 491240 506309 509185 516937 517490 517513 517519 517534 522333 526013 533884 537651 538480 539416 540568 544236 545968 547807 550186 553283 554804 555035 555055 555503 556341 556586 558172 559342 561513 561524 562418 565630 565636 565726 570948 571755 573168 574389 576455 577073 578010 580503 580819 581520 582545 582765 585694 587606 589171 590946 593387 593538 593820 596732 596769 599398 600399 604999 605009 607182 612091 614770 614772 614782 614794 614797 614798 614819 614865 615922 626572 633204 636210 649437 649936 650519 657768 666433 677146 696108 705053 706422 709898 710374 710458 710586 714510 717621 718487 734251 736901 742549 744470 746114 760170 760609 784036 790396 790630 791861 793559 797333 803026 804453 807405 808158 811912 812383 816169 816170 819964 ] |
||||||||||||||||||||||||||||||
|
2.04 ms (0.98%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"homemade erotic mature"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (0.82%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"домашн любительск эротик mature"
]
|
||||||||||||||||||||||||||||||
|
1.50 ms (0.72%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.41 ms (0.68%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"домашн любительск эротик mature"
]
|
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.