Query Metrics
7
Database Queries
7
Different statements
151.72 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
125.50 ms (82.72%) |
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 33379 385755 396265 398614 415950 416191 418332 419900 419910 420192 420910 422705 422847 423009 423021 423270 425027 425300 435727 443216 445473 452441 456642 458094 459237 488379 492573 496441 497382 499040 508962 511837 512741 512955 525099 527110 529432 532591 533313 540601 542587 542692 546493 547663 549087 550419 551086 551962 552928 554337 554343 557685 559163 559881 560127 564223 565479 566042 566308 568613 574603 577046 581054 587930 590924 591795 592673 595018 595314 595792 597785 602662 603731 604086 623449 623516 636883 645971 647074 648598 650359 658216 662078 662200 664267 673137 688034 689688 694129 702075 702497 713139 717892 717921 718955 720407 720678 720879 722803 731497 737132 737165 739777 741106 750816 753854 757563 758601 758905 770665 784517 784609 792554 795539 799721 800071 809737 815165 816856 827900 ] |
||||||||||||||||||||||||||||||
|
16.79 ms (11.07%) |
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 422705 827900 512955 597785 551962 750816 420192 554337 658216 694129 795539 770665 398614 385755 419900 445473 452441 499040 551086 592673 33379 554343 717921 602662 595314 758601 800071 595792 496441 550419 574603 565479 595018 809737 546493 647074 689688 664267 673137 702497 717892 722803 662078 662200 720879 577046 636883 604086 623516 784609 753854 737165 737132 757563 741106 758905 720678 713139 396265 425027 419910 415950 435727 416191 459237 542692 542587 792554 799721 456642 425300 418332 420910 423021 423270 422847 443216 508962 525099 527110 423009 458094 488379 492573 603731 559163 702075 645971 564223 731497 529432 559881 557685 547663 648598 688034 590924 784517 739777 623449 540601 815165 497382 512741 511837 566042 560127 587930 533313 566308 591795 816856 532591 549087 552928 581054 568613 718955 720407 650359 ] |
||||||||||||||||||||||||||||||
|
2.90 ms (1.91%) |
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 33379 385755 396265 398614 415950 416191 418332 419900 419910 420192 420910 422705 422847 423009 423021 423270 425027 425300 435727 443216 445473 452441 456642 458094 459237 488379 492573 496441 497382 499040 508962 511837 512741 512955 525099 527110 529432 532591 533313 540601 542587 542692 546493 547663 549087 550419 551086 551962 552928 554337 554343 557685 559163 559881 560127 564223 565479 566042 566308 568613 574603 577046 581054 587930 590924 591795 592673 595018 595314 595792 597785 602662 603731 604086 623449 623516 636883 645971 647074 648598 650359 658216 662078 662200 664267 673137 688034 689688 694129 702075 702497 713139 717892 717921 718955 720407 720678 720879 722803 731497 737132 737165 739777 741106 750816 753854 757563 758601 758905 770665 784517 784609 792554 795539 799721 800071 809737 815165 816856 827900 ] |
||||||||||||||||||||||||||||||
|
1.91 ms (1.26%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big dick asian"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (1.18%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большой большие член азиатк"
]
|
||||||||||||||||||||||||||||||
|
1.47 ms (0.97%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большой большие член азиатк"
]
|
||||||||||||||||||||||||||||||
|
1.36 ms (0.90%) |
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.