Query Metrics
7
Database Queries
7
Different statements
472.19 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
235.03 ms (49.77%) |
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 321285 385385 419461 423360 427714 433746 434885 435610 435618 435620 435635 435830 438191 438459 439352 441160 441295 442100 447997 452860 457383 458440 464869 466859 468260 472805 482036 485230 489326 492842 495525 496840 498311 502630 502660 505256 505328 513136 514845 514946 515649 516715 517809 520953 521485 523393 523552 523640 526902 527098 528530 532387 532727 533141 533554 535403 541265 543993 544861 554818 556335 557896 560758 562384 569331 570729 570935 578148 579622 590073 594053 598512 599998 602146 602221 605178 607520 608351 608605 619697 619903 623280 627311 629144 655010 659004 659944 661421 662588 663183 671518 706765 712212 714889 736047 743610 753150 758061 765490 766342 773272 774874 781884 783053 784110 784743 790568 791507 792092 796387 797046 798481 803605 804696 806413 807278 809924 810750 814181 ] |
||||||||||||||||||||||||||||||
|
209.71 ms (44.41%) |
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 321285 385385 419461 423360 427714 433746 434885 435610 435618 435620 435635 435830 438191 438459 439352 441160 441295 442100 447997 452860 457383 458440 464869 466859 468260 472805 482036 485230 489326 492842 495525 496840 498311 502630 502660 505256 505328 513136 514845 514946 515649 516715 517809 520953 521485 523393 523552 523640 526902 527098 528530 532387 532727 533141 533554 535403 541265 543993 544861 554818 556335 557896 560758 562384 569331 570729 570935 578148 579622 590073 594053 598512 599998 602146 602221 605178 607520 608351 608605 619697 619903 623280 627311 629144 655010 659004 659944 661421 662588 663183 671518 706765 712212 714889 736047 743610 753150 758061 765490 766342 773272 774874 781884 783053 784110 784743 790568 791507 792092 796387 797046 798481 803605 804696 806413 807278 809924 810750 814181 ] |
||||||||||||||||||||||||||||||
|
16.94 ms (3.59%) |
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 590073 619697 599998 791507 796387 803605 809924 781884 798481 804696 806505 810750 758061 736047 712212 790568 792092 797046 439352 447997 517809 513136 385385 435830 472805 543993 607520 623280 438459 532727 560758 743610 321285 427714 433746 423360 485230 468260 528530 495525 569331 659004 659944 608605 753150 520953 502660 514845 498311 523393 521485 489326 605178 807278 464869 527098 435635 452860 496840 532387 526902 533141 466859 556335 557896 579622 655010 662588 663183 706765 570729 765490 784110 806413 766342 773272 619903 627311 714889 774874 783053 458440 516715 492842 419461 441295 457383 514946 562384 541265 554818 661421 578148 594053 598512 602221 608351 438191 434885 441160 502630 515649 505328 523640 602146 435618 435620 482036 523552 671518 629144 784743 435610 442100 814181 505256 535403 533554 544861 570935 ] |
||||||||||||||||||||||||||||||
|
4.83 ms (1.02%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.00 ms (0.42%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"solo wet ass"
]
|
||||||||||||||||||||||||||||||
|
1.99 ms (0.42%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"соло мокрые жоп"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (0.36%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.