Query Metrics
7
Database Queries
7
Different statements
167.52 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
142.24 ms (84.91%) |
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 394772 394818 402593 403076 403500 403543 422810 428353 461731 465175 481584 495771 502089 505810 505826 514928 515193 517750 518265 521461 527069 527408 530474 530477 530774 530776 531405 531406 531407 532441 532675 532682 532684 532689 534325 535537 536697 536853 537145 537683 537939 538653 538676 539184 539420 539424 540356 540395 540433 540476 540478 540480 540483 540486 541417 541434 543875 543877 549858 550076 553494 556533 564719 564726 564740 564741 564776 565152 566140 567095 568347 573463 575446 576004 576432 578416 578423 578426 580756 583003 584698 585736 586650 587206 594920 594960 595956 596001 596008 596017 596048 596063 596138 597139 598177 599143 600380 601928 614046 618351 621645 622055 625417 629969 630227 634203 641660 641672 641686 646779 723075 782777 787313 806087 806099 806153 806157 806160 806215 808570 ] |
||||||||||||||||||||||||||||||
|
14.79 ms (8.83%) |
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 806215 531406 723075 575446 641660 596017 618351 587206 601928 586650 527408 567095 641686 614046 782777 806160 530474 502089 521461 527069 536853 630227 573463 646779 550076 537145 538653 514928 540356 539184 578426 585736 532675 584698 549858 595956 787313 495771 541417 566140 565152 580756 596008 806099 806157 806153 808570 530774 576004 543875 596001 629969 596138 596063 461731 536697 532684 532689 534325 505826 530477 532441 540395 540480 564719 564741 598177 599143 641672 556533 596048 806087 540433 515193 530776 568347 564776 594920 600380 535537 578416 518265 634203 517750 481584 622055 539420 564726 541434 553494 594960 538676 531405 625417 597139 465175 531407 532682 505810 537939 539424 543877 564740 578423 621645 540478 540483 540476 576432 583003 428353 537683 422810 540486 402593 394772 403543 394818 403076 403500 ] |
||||||||||||||||||||||||||||||
|
2.65 ms (1.58%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"bangbros big"
]
|
||||||||||||||||||||||||||||||
|
2.53 ms (1.51%) |
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 394772 394818 402593 403076 403500 403543 422810 428353 461731 465175 481584 495771 502089 505810 505826 514928 515193 517750 518265 521461 527069 527408 530474 530477 530774 530776 531405 531406 531407 532441 532675 532682 532684 532689 534325 535537 536697 536853 537145 537683 537939 538653 538676 539184 539420 539424 540356 540395 540433 540476 540478 540480 540483 540486 541417 541434 543875 543877 549858 550076 553494 556533 564719 564726 564740 564741 564776 565152 566140 567095 568347 573463 575446 576004 576432 578416 578423 578426 580756 583003 584698 585736 586650 587206 594920 594960 595956 596001 596008 596017 596048 596063 596138 597139 598177 599143 600380 601928 614046 618351 621645 622055 625417 629969 630227 634203 641660 641672 641686 646779 723075 782777 787313 806087 806099 806153 806157 806160 806215 808570 ] |
||||||||||||||||||||||||||||||
|
2.09 ms (1.25%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.73 ms (1.04%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"bangbros большие"
]
|
||||||||||||||||||||||||||||||
|
1.49 ms (0.89%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"bangbros большие"
]
|
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.