Query Metrics
7
Database Queries
7
Different statements
198.71 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
176.72 ms (88.93%) |
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 547415 550958 553179 554491 554958 555205 555210 555319 555761 556618 557054 559411 561522 566568 566661 567470 570883 570947 572269 575877 576482 577687 587121 588401 591848 592219 595149 597166 599566 600831 600904 601099 604642 605097 607765 609246 609686 614236 618946 628666 629941 630045 639657 642240 642241 642292 642387 642853 646329 646443 651652 660025 664547 665331 667738 668678 669287 669933 675350 678758 687404 690016 696317 707373 712336 713141 713427 713457 714220 716216 717388 721082 726236 727582 730059 733073 735876 736188 744770 746871 748492 749570 753762 754699 756749 759077 760164 764419 765634 766475 770246 776419 776746 781382 781934 781954 785894 787163 787238 787535 788143 788624 790433 791919 793092 793108 798455 802358 802913 807006 807257 808924 808966 810025 810073 811901 812284 812469 813367 ] |
||||||||||||||||||||||||||||||
|
12.55 ms (6.32%) |
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 566661 570883 576482 547415 550958 554491 554958 555205 555210 555761 556618 557054 559411 566568 567470 570947 572269 575877 577687 646329 660025 668678 669287 707373 716216 646443 651652 664547 665331 669933 687404 690016 713141 713427 717388 721082 667738 675350 678758 696317 712336 713457 714220 553179 555319 561522 591848 597166 599566 601099 630045 587121 605097 609686 614236 618517 642853 588401 595149 600831 607765 629941 639657 642241 642292 592219 600904 604642 609246 618946 628666 642240 642387 776419 776746 781934 785894 788624 802358 802913 807257 812469 787163 787535 790433 793108 798455 807006 808966 810073 813367 727582 733073 744770 748492 754699 760164 781382 781954 787238 788143 791919 793092 808924 810025 811901 812284 726236 736188 746871 749570 766475 730059 759077 764419 735876 753762 756749 765634 770246 ] |
||||||||||||||||||||||||||||||
|
2.86 ms (1.44%) |
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 547415 550958 553179 554491 554958 555205 555210 555319 555761 556618 557054 559411 561522 566568 566661 567470 570883 570947 572269 575877 576482 577687 587121 588401 591848 592219 595149 597166 599566 600831 600904 601099 604642 605097 607765 609246 609686 614236 618946 628666 629941 630045 639657 642240 642241 642292 642387 642853 646329 646443 651652 660025 664547 665331 667738 668678 669287 669933 675350 678758 687404 690016 696317 707373 712336 713141 713427 713457 714220 716216 717388 721082 726236 727582 730059 733073 735876 736188 744770 746871 748492 749570 753762 754699 756749 759077 760164 764419 765634 766475 770246 776419 776746 781382 781934 781954 785894 787163 787238 787535 788143 788624 790433 791919 793092 793108 798455 802358 802913 807006 807257 808924 808966 810025 810073 811901 812284 812469 813367 ] |
||||||||||||||||||||||||||||||
|
1.91 ms (0.96%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"solo milf ass"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (0.84%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"соло milf жоп"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (0.80%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.40 ms (0.71%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"соло milf жоп"
]
|
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.