Query Metrics
7
Database Queries
7
Different statements
216.73 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
188.41 ms (86.93%) |
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 204376 386430 392917 392918 392928 394738 394772 394780 394816 394818 394874 402103 402142 402593 403076 403361 403382 403500 403543 403986 406765 415714 419413 422810 428353 444453 452258 454644 458104 461731 465175 480513 481584 495771 505810 505826 515193 517750 518265 529260 530477 530774 530776 530781 530783 531405 531407 532441 532682 532684 532689 534325 535537 536697 537683 537939 538676 539420 539424 539456 540395 540433 540476 540478 540480 540483 540486 541417 541434 543875 543877 544789 553494 556533 564719 564726 564740 564741 564776 565152 566140 568347 573803 575441 576004 576432 578416 578423 580756 583003 584740 594920 594960 595956 596001 596008 596048 596054 596063 596138 597139 598177 599143 600380 621645 622055 625417 629969 634203 635222 638282 638292 641672 645327 787313 806087 806099 806153 806157 808570 ] |
||||||||||||||||||||||||||||||
|
17.61 ms (8.12%) |
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 595956 787313 495771 541417 566140 565152 580756 596008 806099 806157 806153 808570 530774 576004 543875 596001 629969 530781 596138 596063 461731 536697 532684 532689 534325 505826 530477 532441 540395 540480 575441 564719 564741 645327 598177 599143 641672 556533 596048 806087 204376 540433 515193 530776 568347 564776 594920 600380 535537 530783 584740 578416 518265 634203 635222 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 386430 428353 537683 422810 540486 402593 394772 403543 394818 403076 403500 392928 394874 596054 394780 444453 529260 539456 454644 402142 403986 403361 392918 638282 394816 419413 638292 573803 402103 406765 458104 392917 394738 403382 544789 415714 452258 480513 ] |
||||||||||||||||||||||||||||||
|
2.98 ms (1.38%) |
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 204376 386430 392917 392918 392928 394738 394772 394780 394816 394818 394874 402103 402142 402593 403076 403361 403382 403500 403543 403986 406765 415714 419413 422810 428353 444453 452258 454644 458104 461731 465175 480513 481584 495771 505810 505826 515193 517750 518265 529260 530477 530774 530776 530781 530783 531405 531407 532441 532682 532684 532689 534325 535537 536697 537683 537939 538676 539420 539424 539456 540395 540433 540476 540478 540480 540483 540486 541417 541434 543875 543877 544789 553494 556533 564719 564726 564740 564741 564776 565152 566140 568347 573803 575441 576004 576432 578416 578423 580756 583003 584740 594920 594960 595956 596001 596008 596048 596054 596063 596138 597139 598177 599143 600380 621645 622055 625417 629969 634203 635222 638282 638292 641672 645327 787313 806087 806099 806153 806157 808570 ] |
||||||||||||||||||||||||||||||
|
2.05 ms (0.94%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big bangbros"
]
|
||||||||||||||||||||||||||||||
|
2.02 ms (0.93%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.87 ms (0.86%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие bangbros"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (0.83%) |
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.