Query Metrics
7
Database Queries
7
Different statements
213.55 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
190.79 ms (89.34%) |
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 55966 387835 388591 394652 396844 408765 427798 432445 432467 433045 455037 482340 484070 485863 510797 514463 526136 529728 534127 536111 542842 550276 550438 552075 553807 556569 561678 565082 565224 566973 568513 571063 573351 575999 585802 591869 594450 595602 596576 597604 597981 602068 606055 620911 624209 624419 625831 631059 631668 644287 649785 664252 669930 671619 671654 671918 682914 684233 685612 687544 692423 693425 693618 705210 708087 712070 713010 715761 720197 720212 724966 726795 729816 731875 734969 736356 736538 744225 752580 756387 756746 759153 759630 760882 761200 764351 767294 767303 770061 773912 782972 783778 792529 797680 800559 801833 803247 807642 808296 811557 812468 815908 817692 817699 817702 817703 817708 817712 817713 817793 818215 818787 820203 820213 824869 828431 828441 828443 828764 828765 ] |
||||||||||||||||||||||||||||||
|
12.08 ms (5.65%) |
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 817703 818787 815908 820213 828765 828764 828431 828441 828443 536111 534127 542842 553807 566973 571063 575999 684233 692423 669930 693618 705210 552075 561678 585802 597981 624209 631668 594450 596576 606055 591869 595602 597604 620911 625831 624419 644287 801833 803247 800559 724966 759153 767303 782972 726795 736538 731875 752580 756387 760882 761200 729816 736356 744225 756746 759630 767294 773912 734969 764351 770061 602068 631059 783778 807642 808296 811557 812468 432445 510797 671619 720197 55966 408765 687544 682914 792529 797680 388591 455037 482340 394652 387835 396844 432467 433045 427798 817699 824869 817713 817793 817692 817702 817708 817712 818215 820203 484070 526136 529728 514463 485863 565082 573351 565224 568513 550276 550438 556569 664252 685612 693425 708087 712070 715761 720212 649785 671654 671918 713010 ] |
||||||||||||||||||||||||||||||
|
3.28 ms (1.53%) |
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 55966 387835 388591 394652 396844 408765 427798 432445 432467 433045 455037 482340 484070 485863 510797 514463 526136 529728 534127 536111 542842 550276 550438 552075 553807 556569 561678 565082 565224 566973 568513 571063 573351 575999 585802 591869 594450 595602 596576 597604 597981 602068 606055 620911 624209 624419 625831 631059 631668 644287 649785 664252 669930 671619 671654 671918 682914 684233 685612 687544 692423 693425 693618 705210 708087 712070 713010 715761 720197 720212 724966 726795 729816 731875 734969 736356 736538 744225 752580 756387 756746 759153 759630 760882 761200 764351 767294 767303 770061 773912 782972 783778 792529 797680 800559 801833 803247 807642 808296 811557 812468 815908 817692 817699 817702 817703 817708 817712 817713 817793 818215 818787 820203 820213 824869 828431 828441 828443 828764 828765 ] |
||||||||||||||||||||||||||||||
|
1.98 ms (0.93%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"milf teen"
]
|
||||||||||||||||||||||||||||||
|
1.93 ms (0.90%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.92 ms (0.90%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"milf and teen"
]
|
||||||||||||||||||||||||||||||
|
1.58 ms (0.74%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"milf teen"
]
|
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.