Query Metrics
7
Database Queries
7
Different statements
176.38 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
152.32 ms (86.36%) |
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 390692 413247 418782 426894 427542 428255 429357 438490 440645 441073 441102 443095 444512 445704 447488 449175 449916 450277 450845 453697 453968 454368 456058 456071 460378 463420 463978 464690 466391 468236 475411 475431 475729 475769 478988 486923 495467 497635 498303 503994 504424 519350 525527 526291 530042 535352 538343 538365 548720 551360 555131 561346 561780 564626 572018 573930 575935 577340 580786 582636 586988 587879 608574 617114 618374 621255 623281 628340 644438 644572 644585 653243 661092 661579 661788 662945 663535 665166 677001 701054 716127 729691 733985 738877 738947 740507 744477 749526 750941 751396 756359 756770 756992 757369 758218 761304 762264 762792 766422 772511 773156 773163 773177 773188 781754 788193 788594 790109 793624 799942 803966 810366 815704 816556 816967 817478 818317 820169 820787 825704 ] |
||||||||||||||||||||||||||||||
|
13.42 ms (7.61%) |
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 475769 526291 495467 519350 413247 475431 475729 450845 582636 548720 551360 572018 587879 644585 729691 440645 447488 466391 426894 454368 453697 538343 498303 561346 475411 418782 444512 504424 586988 608574 621255 788594 751396 427542 815704 817478 820169 818317 816967 820787 816556 530042 575935 561780 661092 662945 677001 661579 661788 663535 665166 701054 716127 617114 618374 623281 644438 628340 781754 793624 733985 756992 762264 762792 766422 773156 773163 773177 773188 788193 790109 738947 740507 744477 749526 738877 772511 750941 756359 756770 757369 758218 761304 644572 799942 803966 810366 390692 438490 441073 428255 429357 441102 443095 825704 453968 463978 486923 445704 449175 449916 456071 450277 456058 464690 468236 478988 497635 525527 503994 538365 535352 460378 463420 573930 577340 580786 555131 564626 653243 ] |
||||||||||||||||||||||||||||||
|
3.28 ms (1.86%) |
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 390692 413247 418782 426894 427542 428255 429357 438490 440645 441073 441102 443095 444512 445704 447488 449175 449916 450277 450845 453697 453968 454368 456058 456071 460378 463420 463978 464690 466391 468236 475411 475431 475729 475769 478988 486923 495467 497635 498303 503994 504424 519350 525527 526291 530042 535352 538343 538365 548720 551360 555131 561346 561780 564626 572018 573930 575935 577340 580786 582636 586988 587879 608574 617114 618374 621255 623281 628340 644438 644572 644585 653243 661092 661579 661788 662945 663535 665166 677001 701054 716127 729691 733985 738877 738947 740507 744477 749526 750941 751396 756359 756770 756992 757369 758218 761304 762264 762792 766422 772511 773156 773163 773177 773188 781754 788193 788594 790109 793624 799942 803966 810366 815704 816556 816967 817478 818317 820169 820787 825704 ] |
||||||||||||||||||||||||||||||
|
2.17 ms (1.23%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"masturbation oil"
]
|
||||||||||||||||||||||||||||||
|
1.87 ms (1.06%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"мастурбац масл"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (0.95%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"мастурбац масл"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (0.93%) |
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.