Query Metrics
7
Database Queries
7
Different statements
170.84 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
142.77 ms (83.57%) |
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 490025 519246 525749 538870 538891 538948 538952 538960 539516 541369 541597 541764 542489 544325 545345 547912 547980 549938 550149 552060 554541 556777 558715 560084 560091 560920 562779 563445 566622 566624 566892 567395 567729 568265 570571 573392 573787 573792 573855 576645 576667 581350 581353 587735 590914 595386 598427 598597 601166 604985 608344 611030 614327 615926 617800 620159 621322 621698 624474 624792 628297 629955 631255 634692 641747 644261 644688 646942 648211 651163 651888 651889 654130 661899 665651 670393 671927 672754 673497 678432 681085 688248 690833 691518 691991 692013 692319 692349 693039 693869 694206 694207 694455 694528 695941 696240 696322 697258 697262 697774 698590 699581 699744 703085 703088 708790 710540 714504 715097 719062 729245 733118 746837 750064 751748 761483 766671 790393 811940 823358 ] |
||||||||||||||||||||||||||||||
|
16.62 ms (9.73%) |
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 641747 538960 539516 538891 550149 556777 541369 541597 568265 573787 554541 648211 670393 692349 693039 694455 694528 671927 678432 695941 697258 651163 703085 708790 715097 608344 628297 746837 729245 624792 629955 714504 719062 576645 573392 595386 566622 576667 651888 661899 696322 699581 703088 651889 665651 698590 691991 693869 598427 601166 620159 631255 811940 733118 634692 525749 567729 672754 560920 545345 538952 544325 552060 621322 624474 697262 490025 519246 581350 581353 750064 541764 621698 615926 823358 560091 566892 688248 690833 694206 692013 646942 681085 587735 598597 590914 761483 699744 563445 566624 538948 538870 542489 547980 558715 570571 573792 547912 567395 560084 654130 691518 692319 696240 673497 694207 710540 549938 562779 573855 644688 644261 604985 611030 790393 751748 766671 614327 617800 697774 ] |
||||||||||||||||||||||||||||||
|
4.29 ms (2.51%) |
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 490025 519246 525749 538870 538891 538948 538952 538960 539516 541369 541597 541764 542489 544325 545345 547912 547980 549938 550149 552060 554541 556777 558715 560084 560091 560920 562779 563445 566622 566624 566892 567395 567729 568265 570571 573392 573787 573792 573855 576645 576667 581350 581353 587735 590914 595386 598427 598597 601166 604985 608344 611030 614327 615926 617800 620159 621322 621698 624474 624792 628297 629955 631255 634692 641747 644261 644688 646942 648211 651163 651888 651889 654130 661899 665651 670393 671927 672754 673497 678432 681085 688248 690833 691518 691991 692013 692319 692349 693039 693869 694206 694207 694455 694528 695941 696240 696322 697258 697262 697774 698590 699581 699744 703085 703088 708790 710540 714504 715097 719062 729245 733118 746837 750064 751748 761483 766671 790393 811940 823358 ] |
||||||||||||||||||||||||||||||
|
2.07 ms (1.21%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"retro tits"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (1.05%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.71 ms (1.00%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"ретр сиськ"
]
|
||||||||||||||||||||||||||||||
|
1.58 ms (0.93%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.