Query Metrics
7
Database Queries
7
Different statements
566.44 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
218.15 ms (38.51%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"сперм creampie"
]
|
||||||||||||||||||||||||||||||
|
209.48 ms (36.98%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"сперм creampie"
]
|
||||||||||||||||||||||||||||||
|
120.73 ms (21.31%) |
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 76150 397977 398399 400620 403782 414730 417130 420405 423436 423602 432804 449800 452275 463596 483811 487587 496247 496460 497903 505947 517758 521002 522055 526136 530235 531340 533246 533363 533383 534615 535993 536145 537158 537484 541827 542256 542338 544255 544638 544741 546438 548116 550345 557826 563684 584966 585450 590284 593848 597282 600718 630136 644929 656137 656532 656619 659387 662146 668734 672826 676308 677180 677914 680342 681422 686966 687070 688245 688551 691197 693425 695123 702000 705225 706188 707567 711346 714054 714381 714392 719300 719924 720521 720570 722329 723157 723522 723597 723637 724797 729000 729960 730668 739879 757301 758121 766602 767290 767536 768300 772010 773843 780440 787567 789044 791257 793076 793860 793876 795341 796809 801132 801444 810334 819397 820057 823860 823974 827337 ] |
||||||||||||||||||||||||||||||
|
11.32 ms (2.00%) |
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 819397 820057 823860 823974 827337 463596 483811 537484 707567 720521 656137 656532 720570 557826 600718 585450 793076 796809 801444 729960 757301 787567 773843 758121 767290 772010 729000 739879 714392 719924 722329 780440 810334 403782 423436 417130 76150 397977 537158 681422 688551 590284 793860 793876 791257 795341 766602 767536 789044 801132 769682 730668 768300 533363 695123 597282 496460 563684 630136 593848 724797 521002 398399 400620 432804 414730 420405 423602 723522 644929 723597 723637 487587 449800 452275 526136 496247 522055 533383 530235 534615 535993 536145 497903 505947 517758 531340 533246 542338 548116 584966 541827 544255 544638 542256 544741 546438 550345 656619 677180 680342 687070 691197 693425 702000 705225 706188 711346 714054 714381 719300 723157 659387 662146 668734 672826 676308 677914 686966 688245 ] |
||||||||||||||||||||||||||||||
|
2.78 ms (0.49%) |
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 76150 397977 398399 400620 403782 414730 417130 420405 423436 423602 432804 449800 452275 463596 483811 487587 496247 496460 497903 505947 517758 521002 522055 526136 530235 531340 533246 533363 533383 534615 535993 536145 537158 537484 541827 542256 542338 544255 544638 544741 546438 548116 550345 557826 563684 584966 585450 590284 593848 597282 600718 630136 644929 656137 656532 656619 659387 662146 668734 672826 676308 677180 677914 680342 681422 686966 687070 688245 688551 691197 693425 695123 702000 705225 706188 707567 711346 714054 714381 714392 719300 719924 720521 720570 722329 723157 723522 723597 723637 724797 729000 729960 730668 739879 757301 758121 766602 767290 767536 768300 772010 773843 780440 787567 789044 791257 793076 793860 793876 795341 796809 801132 801444 810334 819397 820057 823860 823974 827337 ] |
||||||||||||||||||||||||||||||
|
2.09 ms (0.37%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sperm creampie"
]
|
||||||||||||||||||||||||||||||
|
1.90 ms (0.34%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.