Query Metrics
7
Database Queries
7
Different statements
369.97 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
208.86 ms (56.45%) |
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 170836 395541 397115 453090 474789 477970 499231 518956 531418 531790 531974 532807 533345 533447 534371 535258 536706 537624 540472 544272 544615 553886 556804 558751 563853 568716 570850 572730 581278 588054 590195 592543 598742 605035 605490 607144 607327 608386 612991 616709 618284 629662 639953 642614 649634 652248 659075 659079 667287 671454 674744 680888 682176 693988 702620 703795 713561 716356 718497 720036 725375 725654 742007 748353 755396 771619 776798 778136 780048 782976 785688 788961 790002 798342 802076 803464 805825 808122 810343 813628 815068 815496 815497 815564 815590 815962 815989 816038 816313 816419 816501 816525 816587 816880 816929 817028 817332 818161 818225 818280 818363 818469 818609 818744 818901 819711 819988 820017 820452 820667 820962 821450 822068 822303 822907 823118 825327 825862 827884 ] |
||||||||||||||||||||||||||||||
|
140.23 ms (37.90%) |
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 170836 395541 397115 453090 474789 477970 499231 518956 531418 531790 531974 532807 533345 533447 534371 535258 536706 537624 540472 544272 544615 553886 556804 558751 563853 568716 570850 572730 581278 588054 590195 592543 598742 605035 605490 607144 607327 608386 612991 616709 618284 629662 639953 642614 649634 652248 659075 659079 667287 671454 674744 680888 682176 693988 702620 703795 713561 716356 718497 720036 725375 725654 742007 748353 755396 771619 776798 778136 780048 782976 785688 788961 790002 798342 802076 803464 805825 808122 810343 813628 815068 815496 815497 815564 815590 815962 815989 816038 816313 816419 816501 816525 816587 816880 816929 817028 817332 818161 818225 818280 818363 818469 818609 818744 818901 819711 819988 820017 820452 820667 820962 821450 822068 822303 822907 823118 825327 825862 827884 ] |
||||||||||||||||||||||||||||||
|
13.38 ms (3.62%) |
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 397115 816929 818469 818609 825862 817332 819988 816525 820017 825782 818225 818363 827884 499231 563853 682176 718497 652248 674744 702620 605035 642614 782976 748353 790002 725654 755396 771619 808122 170836 395541 815989 816038 818280 813628 818161 818901 820452 822303 822907 815496 815497 815590 815962 816313 816419 816587 816880 817028 820667 822068 823118 815068 815564 816501 818744 819711 820962 821450 825327 453090 531974 536706 532807 535258 518956 533345 531418 531790 533447 534371 537624 540472 474789 477970 544272 558751 556804 572730 581278 544615 553886 570850 659075 720036 659079 667287 693988 713561 649634 671454 680888 703795 716356 568716 588054 592543 605490 607144 612991 618284 629662 639953 598742 607327 590195 608386 616709 776798 778136 780048 788961 805825 785688 798342 802076 803464 810343 725375 742007 ] |
||||||||||||||||||||||||||||||
|
2.16 ms (0.58%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mom dick"
]
|
||||||||||||||||||||||||||||||
|
2.04 ms (0.55%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mom член"
]
|
||||||||||||||||||||||||||||||
|
1.85 ms (0.50%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.47 ms (0.40%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mom член"
]
|
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.