Query Metrics
7
Database Queries
7
Different statements
156.43 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
131.53 ms (84.08%) |
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 242316 336860 384814 393750 398045 404117 418254 422227 424405 431722 437725 441798 446425 447587 449287 449333 450485 456280 460856 474370 479283 498391 500287 516363 520919 536878 588221 602789 603612 608356 616993 617435 617793 621129 622014 648927 665451 679283 696424 716911 716941 725289 726498 726698 727513 728196 729553 730277 732135 732906 736285 737889 742035 742303 745012 747566 751389 758430 760632 761872 762230 765481 769051 770979 770980 771740 773444 776963 778555 780188 781855 782025 783839 784791 785003 785922 788217 788477 790064 791267 791322 793296 793674 793826 794438 795257 799196 799263 800070 800104 801167 801728 804052 804300 804678 806045 808518 810726 811749 811814 812137 813017 813034 821635 824526 825992 826099 826425 826490 826567 826632 826633 827030 828010 828350 828503 ] |
||||||||||||||||||||||||||||||
|
14.42 ms (9.22%) |
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 588221 608356 621129 780188 781855 782025 785003 791267 793296 793826 800070 804300 804678 810726 811749 776963 788217 788477 795257 799263 800104 801167 813017 813034 726698 742035 758430 760632 770979 793674 794438 799196 801728 804052 806045 811814 725289 728196 729553 732135 736285 761872 769051 727513 732906 742303 765481 770980 771740 730277 745012 747566 751389 762230 773444 726498 737889 602789 617435 617793 716911 716941 778555 783839 784791 785922 790064 791322 808518 812137 393750 422227 424405 441798 404117 456280 460856 474370 418254 431722 446425 447587 398045 449287 450485 479283 437725 536878 500287 520919 336860 825992 826632 826567 827030 824569 826099 826425 828010 828344 828350 828503 665451 696424 622014 384814 242316 679283 616993 603612 449333 498391 516363 648927 821635 824526 824650 826490 826633 822319 ] |
||||||||||||||||||||||||||||||
|
3.15 ms (2.01%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.38 ms (1.52%) |
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 242316 336860 384814 393750 398045 404117 418254 422227 424405 431722 437725 441798 446425 447587 449287 449333 450485 456280 460856 474370 479283 498391 500287 516363 520919 536878 588221 602789 603612 608356 616993 617435 617793 621129 622014 648927 665451 679283 696424 716911 716941 725289 726498 726698 727513 728196 729553 730277 732135 732906 736285 737889 742035 742303 745012 747566 751389 758430 760632 761872 762230 765481 769051 770979 770980 771740 773444 776963 778555 780188 781855 782025 783839 784791 785003 785922 788217 788477 790064 791267 791322 793296 793674 793826 794438 795257 799196 799263 800070 800104 801167 801728 804052 804300 804678 806045 808518 810726 811749 811814 812137 813017 813034 821635 824526 825992 826099 826425 826490 826567 826632 826633 827030 828010 828350 828503 ] |
||||||||||||||||||||||||||||||
|
1.83 ms (1.17%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"shaving pussy"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (1.08%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"shaving pussy"
]
|
||||||||||||||||||||||||||||||
|
1.44 ms (0.92%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"shaving pussy"
]
|
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.