Query Metrics
7
Database Queries
7
Different statements
189.98 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
166.42 ms (87.60%) |
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 383599 402190 403215 410851 416585 418102 418111 418142 421199 426826 427396 428280 434313 434314 434327 434335 434349 434365 435171 435395 435553 437970 439243 446543 448758 451273 451852 456219 466467 466564 467908 467923 469460 477249 485470 497665 500957 505747 511372 517108 517798 538537 539370 545001 547734 547762 550817 550938 578866 582569 583774 588201 589626 591476 593285 595028 596240 604865 605711 613572 625779 630270 636414 643005 644870 647330 650719 650895 660620 666502 670460 677843 687388 696499 697768 701233 708062 708678 726122 736017 738496 738503 749571 751637 753199 766152 768517 773283 782096 784125 784626 784844 786711 787522 791113 793132 794058 795406 797082 798832 801783 801810 803046 803626 804246 805146 806943 807011 807586 807827 808652 808665 809009 809631 811221 812050 814202 821198 824119 824754 ] |
||||||||||||||||||||||||||||||
|
14.32 ms (7.54%) |
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 435553 434327 477249 505747 439243 446543 630270 784626 808652 811221 786711 437970 821198 794058 784125 812050 547762 596240 426826 595028 578866 643005 795406 418102 773283 696499 644870 666502 804246 416585 434349 434314 410851 809009 738496 403215 517108 604865 435395 708062 545001 782096 806943 809631 402190 650895 467923 751637 814202 550938 768517 500957 726122 824754 582569 650719 589626 801783 766152 824119 613572 803626 791113 677843 456219 466467 807011 435171 448758 517798 539370 593285 807827 797082 636414 421199 427396 469460 787522 749571 605711 538537 550817 803046 583774 805146 466564 511372 428280 485470 588201 738503 497665 647330 736017 660620 383599 418111 451852 467908 434313 434365 418142 451273 434335 687388 625779 708678 784844 793132 697768 801810 670460 808665 807586 753199 701233 591476 798832 547734 ] |
||||||||||||||||||||||||||||||
|
2.44 ms (1.29%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"tits solo squirt"
]
|
||||||||||||||||||||||||||||||
|
2.30 ms (1.21%) |
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 383599 402190 403215 410851 416585 418102 418111 418142 421199 426826 427396 428280 434313 434314 434327 434335 434349 434365 435171 435395 435553 437970 439243 446543 448758 451273 451852 456219 466467 466564 467908 467923 469460 477249 485470 497665 500957 505747 511372 517108 517798 538537 539370 545001 547734 547762 550817 550938 578866 582569 583774 588201 589626 591476 593285 595028 596240 604865 605711 613572 625779 630270 636414 643005 644870 647330 650719 650895 660620 666502 670460 677843 687388 696499 697768 701233 708062 708678 726122 736017 738496 738503 749571 751637 753199 766152 768517 773283 782096 784125 784626 784844 786711 787522 791113 793132 794058 795406 797082 798832 801783 801810 803046 803626 804246 805146 806943 807011 807586 807827 808652 808665 809009 809631 811221 812050 814202 821198 824119 824754 ] |
||||||||||||||||||||||||||||||
|
1.55 ms (0.81%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"сиськ соло сквирт оргазм"
]
|
||||||||||||||||||||||||||||||
|
1.49 ms (0.78%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.46 ms (0.77%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.