Query Metrics
8
Database Queries
8
Different statements
159.45 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.87 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 2.12 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"milf cum"
]
|
||||||||||||||||||||||||||||||
| 3 | 1.95 ms |
SELECT 1 FROM `trend_has_post` WHERE `trend_id` = ? LIMIT 1
Parameters:
[
b"\x01”q‹Â½sOR,K,½¶K"
]
|
||||||||||||||||||||||||||||||
| 4 | 12.46 ms |
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 793498 812108 428067 817572 824220 825191 825985 826452 825723 827280 827562 816709 824113 825615 819326 825068 828089 828787 828550 828555 529851 466825 652672 699316 706008 716452 678225 571770 585375 620485 627167 617639 629776 636963 631211 780469 790633 794262 794583 804247 750134 789461 789472 797136 800389 747684 736460 755605 738019 746576 760634 768140 770067 771238 629979 230986 389618 415114 411927 422259 433384 817403 819040 819310 819699 824002 824044 824641 824645 824826 824970 825850 826110 826216 826619 823712 823763 820202 824774 824779 825178 825350 827121 827207 827235 827267 827272 827577 827552 817018 817069 817542 819024 819338 823783 824336 824543 824622 817380 818222 823840 824416 824746 825764 828366 827587 828446 828682 459735 481204 505936 522625 531268 539630 506792 567121 569213 582840 584095 545310 ] |
||||||||||||||||||||||||||||||
| 5 | 3.65 ms |
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 230986 389618 411927 415114 422259 428067 433384 459735 466825 481204 505936 506792 522625 529851 531268 539630 545310 567121 569213 571770 582840 584095 585375 617639 620485 627167 629776 629979 631211 636963 652672 678225 699316 706008 716452 736460 738019 746576 747684 750134 755605 760634 768140 770067 771238 780469 789461 789472 790633 793498 794262 794583 797136 800389 804247 812108 816709 817018 817069 817380 817403 817542 817572 818222 819024 819040 819310 819326 819338 819699 820202 823712 823763 823783 824002 824044 824113 824220 824336 824416 824543 824622 824641 824645 824774 824779 824826 824970 825068 825191 825350 825615 825723 825764 825850 825985 826110 826216 826452 826619 827121 827207 827235 827267 827272 827280 827552 827562 827577 827587 828089 828366 828446 828550 828555 828682 828787 ] |
||||||||||||||||||||||||||||||
| 6 | 133.74 ms |
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 230986 389618 411927 415114 422259 428067 433384 459735 466825 481204 505936 506792 522625 529851 531268 539630 545310 567121 569213 571770 582840 584095 585375 617639 620485 627167 629776 629979 631211 636963 652672 678225 699316 706008 716452 736460 738019 746576 747684 750134 755605 760634 768140 770067 771238 780469 789461 789472 790633 793498 794262 794583 797136 800389 804247 812108 816709 817018 817069 817380 817403 817542 817572 818222 819024 819040 819310 819326 819338 819699 820202 823712 823763 823783 824002 824044 824113 824220 824336 824416 824543 824622 824641 824645 824774 824779 824826 824970 825068 825191 825350 825615 825723 825764 825850 825985 826110 826216 826452 826619 827121 827207 827235 827267 827272 827280 827552 827562 827577 827587 828089 828366 828446 828550 828555 828682 828787 ] |
||||||||||||||||||||||||||||||
| 7 | 1.97 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"milf cum"
]
|
||||||||||||||||||||||||||||||
| 8 | 1.69 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"milf cum"
]
|
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.