Query Metrics
7
Database Queries
7
Different statements
143.39 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
115.84 ms (80.79%) |
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 123029 310758 383105 383389 384490 384532 385590 385710 385889 388411 389899 390950 395410 396606 398243 399889 400946 400956 401262 404353 404415 405020 408969 409084 413905 421556 427937 430088 430209 430467 443743 451547 451896 453082 454298 455821 457387 457812 469415 470915 475817 478445 482237 482961 485785 486805 487005 492479 492727 494748 500467 514596 519234 522409 524955 536886 540508 541321 542831 548628 550010 552935 556416 559910 562844 572599 572744 581323 581334 581386 581664 581688 584004 584731 595765 595772 595817 595818 595819 597494 598903 601829 603242 605334 606528 606537 622652 623143 623231 623510 624239 629560 644264 644922 644968 645235 651199 670773 676895 682198 682508 687185 698035 699584 708519 720239 748154 748231 748245 748695 775803 776008 782518 784111 789998 809525 817349 818527 818543 827206 ] |
||||||||||||||||||||||||||||||
|
17.80 ms (12.41%) |
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 581323 720239 598903 603242 644264 595772 809525 623510 413905 400956 385710 310758 398243 818527 457812 519234 581334 584731 670773 556416 562844 622652 601829 624239 595819 605334 775803 782518 748154 748245 748695 451547 487005 522409 383105 827206 817349 475817 469415 478445 524955 494748 552935 651199 682198 699584 595817 776008 385590 430467 818543 457387 536886 572744 548628 550010 645235 595765 606537 789998 388411 399889 492727 389899 390950 455821 500467 584004 443743 454298 581688 572599 676895 400946 581664 404353 123029 404415 421556 451896 482237 405020 427937 430209 409084 430088 644922 482961 542831 687185 606528 708519 470915 453082 492479 385889 384532 384490 396606 401262 408969 644968 486805 540508 541321 559910 581386 682508 698035 623231 623143 629560 595818 597494 784111 748231 395410 485785 514596 383389 ] |
||||||||||||||||||||||||||||||
|
2.85 ms (1.99%) |
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 123029 310758 383105 383389 384490 384532 385590 385710 385889 388411 389899 390950 395410 396606 398243 399889 400946 400956 401262 404353 404415 405020 408969 409084 413905 421556 427937 430088 430209 430467 443743 451547 451896 453082 454298 455821 457387 457812 469415 470915 475817 478445 482237 482961 485785 486805 487005 492479 492727 494748 500467 514596 519234 522409 524955 536886 540508 541321 542831 548628 550010 552935 556416 559910 562844 572599 572744 581323 581334 581386 581664 581688 584004 584731 595765 595772 595817 595818 595819 597494 598903 601829 603242 605334 606528 606537 622652 623143 623231 623510 624239 629560 644264 644922 644968 645235 651199 670773 676895 682198 682508 687185 698035 699584 708519 720239 748154 748231 748245 748695 775803 776008 782518 784111 789998 809525 817349 818527 818543 827206 ] |
||||||||||||||||||||||||||||||
|
1.88 ms (1.31%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"hairy group sex"
]
|
||||||||||||||||||||||||||||||
|
1.87 ms (1.30%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.62 ms (1.13%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"волосатая group секс"
]
|
||||||||||||||||||||||||||||||
|
1.53 ms (1.07%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"волосатая group секс"
]
|
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.