Query Metrics
7
Database Queries
7
Different statements
184.53 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
159.77 ms (86.59%) |
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 411927 415114 422259 433384 459735 481204 505936 506792 522625 531268 539630 543115 545310 548308 552970 553405 554237 555622 561557 563789 563962 567121 569213 578643 578741 582840 583937 584095 591901 592940 612979 626846 631307 633426 660036 666001 667349 672883 679895 693699 696133 707581 716273 716341 719284 723156 723978 726848 730215 734402 735345 739253 777461 778687 779781 779837 781137 782492 789152 793530 795860 798061 799690 801104 801456 801528 801571 802389 808254 810460 812727 813528 817018 817069 817380 817403 817542 818222 819024 819040 819310 819338 819699 820202 823712 823763 823783 824002 824044 824336 824416 824543 824622 824641 824645 824774 824779 824826 824970 825350 825764 825850 826110 826216 826619 827121 827207 827235 827267 827272 827552 827577 827587 828366 828446 828682 ] |
||||||||||||||||||||||||||||||
|
13.53 ms (7.33%) |
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 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 548308 555622 561557 563962 543115 552970 553405 563789 578741 583937 666001 716273 660036 667349 679895 693699 707581 719284 672883 696133 716341 723156 554237 578643 633426 591901 612979 626846 592940 631307 777461 779781 779837 781137 799690 801104 802389 810460 812727 813528 778687 782492 789152 793530 795860 798061 801422 801456 801528 801571 808254 723978 726848 730215 734402 735345 739253 ] |
||||||||||||||||||||||||||||||
|
3.57 ms (1.93%) |
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 411927 415114 422259 433384 459735 481204 505936 506792 522625 531268 539630 543115 545310 548308 552970 553405 554237 555622 561557 563789 563962 567121 569213 578643 578741 582840 583937 584095 591901 592940 612979 626846 631307 633426 660036 666001 667349 672883 679895 693699 696133 707581 716273 716341 719284 723156 723978 726848 730215 734402 735345 739253 777461 778687 779781 779837 781137 782492 789152 793530 795860 798061 799690 801104 801456 801528 801571 802389 808254 810460 812727 813528 817018 817069 817380 817403 817542 818222 819024 819040 819310 819338 819699 820202 823712 823763 823783 824002 824044 824336 824416 824543 824622 824641 824645 824774 824779 824826 824970 825350 825764 825850 826110 826216 826619 827121 827207 827235 827267 827272 827552 827577 827587 828366 828446 828682 ] |
||||||||||||||||||||||||||||||
|
2.26 ms (1.23%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"cum milf"
]
|
||||||||||||||||||||||||||||||
|
2.17 ms (1.17%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"cum milf"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (0.89%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"cum milf"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (0.86%) |
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.