Query Metrics
7
Database Queries
7
Different statements
164.60 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
140.27 ms (85.22%) |
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 374819 383217 388780 389051 396276 397389 398010 398652 399422 403834 409699 410079 411130 412238 414785 420641 421763 423299 423751 427425 428800 432704 433701 435411 441206 441479 451116 459986 462980 469196 496477 503551 508104 508155 510879 515894 535461 537504 539276 540427 543397 544595 549020 553094 555064 557543 562408 563303 575854 578760 584068 591186 604327 606152 608946 609854 621601 622886 630267 632246 653209 656548 656631 661673 663160 670346 670915 680346 686845 693281 693509 698888 705755 710567 712374 718824 721233 721368 723106 724403 727483 727859 732640 736257 740603 741394 741728 743422 750940 755223 756276 756875 757564 757925 757994 758141 760912 765743 766873 767090 768797 778490 778503 778989 779941 787632 787965 787982 791250 792799 793388 794957 797096 798707 798734 799864 810298 812059 824164 824533 ] |
||||||||||||||||||||||||||||||
|
14.53 ms (8.83%) |
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 537504 549020 656631 710567 797096 824533 787965 778490 515894 718824 778503 798707 787982 757925 374819 555064 794957 740603 441479 705755 723106 608946 432704 410079 824164 496477 661673 680346 591186 727859 741394 767090 383217 421763 411130 539276 563303 670915 812059 721233 609854 693281 750940 766873 604327 630267 423751 663160 562408 778989 741728 757564 757994 409699 427425 544595 779941 451116 712374 622886 399422 693509 798734 755223 732640 810298 503551 540427 553094 578760 389051 403834 724403 793388 462980 535461 653209 698888 621601 799864 398010 721368 760912 765743 557543 791250 743422 727483 787632 423299 584068 656548 758141 632246 433701 508155 459986 510879 543397 736257 756875 756276 435411 508104 396276 670346 388780 575854 414785 606152 441206 397389 469196 686845 792799 768797 398652 428800 420641 412238 ] |
||||||||||||||||||||||||||||||
|
2.60 ms (1.58%) |
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 374819 383217 388780 389051 396276 397389 398010 398652 399422 403834 409699 410079 411130 412238 414785 420641 421763 423299 423751 427425 428800 432704 433701 435411 441206 441479 451116 459986 462980 469196 496477 503551 508104 508155 510879 515894 535461 537504 539276 540427 543397 544595 549020 553094 555064 557543 562408 563303 575854 578760 584068 591186 604327 606152 608946 609854 621601 622886 630267 632246 653209 656548 656631 661673 663160 670346 670915 680346 686845 693281 693509 698888 705755 710567 712374 718824 721233 721368 723106 724403 727483 727859 732640 736257 740603 741394 741728 743422 750940 755223 756276 756875 757564 757925 757994 758141 760912 765743 766873 767090 768797 778490 778503 778989 779941 787632 787965 787982 791250 792799 793388 794957 797096 798707 798734 799864 810298 812059 824164 824533 ] |
||||||||||||||||||||||||||||||
|
1.86 ms (1.13%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс creampie"
]
|
||||||||||||||||||||||||||||||
|
1.86 ms (1.13%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"fuck creampie"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (1.06%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс creampie"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (1.05%) |
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.