Query Metrics
7
Database Queries
7
Different statements
167.77 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
143.15 ms (85.33%) |
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 185143 413089 415554 422342 429574 442795 448735 452252 453271 453489 460205 460758 460865 461186 462315 469525 469551 474679 476507 476709 479135 483359 483841 486903 491110 493026 493128 493213 499423 503972 505242 506047 508239 509174 509287 511402 515569 516220 516274 516288 516646 519218 519341 520204 520286 522442 522638 526066 537833 539450 543550 543558 545544 555038 555239 555252 555277 569235 579586 580884 591906 593377 599732 603269 605049 606564 644682 649156 663408 665849 666666 667288 667320 667574 667644 668174 696213 711747 714561 721954 726471 726632 729635 731042 733518 734306 734375 746680 746737 747054 748128 748250 758291 759674 761858 769600 772038 775878 782559 792546 794391 794817 802451 804002 817283 817801 819067 820367 820837 820888 821056 823757 824356 824400 825388 825429 826683 826684 826689 827416 ] |
||||||||||||||||||||||||||||||
|
15.66 ms (9.34%) |
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 516288 460865 667574 819067 824400 826684 826683 823757 820367 817801 824356 543558 555277 802451 775878 794817 731042 746680 726632 759674 714561 794391 804002 555239 792546 479135 761858 460205 519341 493026 486903 537833 474679 696213 820837 825429 825388 826689 817283 820888 827416 821056 555038 663408 668174 666666 644682 605049 733518 734306 747054 726471 769600 711747 509287 422342 461186 493213 667320 667644 665849 667288 545544 606564 593377 748128 729635 772038 748250 522442 503972 526066 516220 511402 515569 522638 516646 543550 782559 493128 483359 469525 476507 460758 603269 429574 499423 413089 185143 415554 453271 569235 483841 506047 452252 555252 508239 579586 591906 491110 469551 505242 539450 580884 649156 509174 519218 448735 520204 476709 442795 453489 516274 758291 599732 734375 746737 721954 520286 462315 ] |
||||||||||||||||||||||||||||||
|
2.34 ms (1.39%) |
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 185143 413089 415554 422342 429574 442795 448735 452252 453271 453489 460205 460758 460865 461186 462315 469525 469551 474679 476507 476709 479135 483359 483841 486903 491110 493026 493128 493213 499423 503972 505242 506047 508239 509174 509287 511402 515569 516220 516274 516288 516646 519218 519341 520204 520286 522442 522638 526066 537833 539450 543550 543558 545544 555038 555239 555252 555277 569235 579586 580884 591906 593377 599732 603269 605049 606564 644682 649156 663408 665849 666666 667288 667320 667574 667644 668174 696213 711747 714561 721954 726471 726632 729635 731042 733518 734306 734375 746680 746737 747054 748128 748250 758291 759674 761858 769600 772038 775878 782559 792546 794391 794817 802451 804002 817283 817801 819067 820367 820837 820888 821056 823757 824356 824400 825388 825429 826683 826684 826689 827416 ] |
||||||||||||||||||||||||||||||
|
1.78 ms (1.06%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.71 ms (1.02%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mature handjob ass"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (0.98%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mature дрочк член жоп"
]
|
||||||||||||||||||||||||||||||
|
1.48 ms (0.88%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mature дрочк член жоп"
]
|
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.