Query Metrics
7
Database Queries
7
Different statements
147.73 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
120.75 ms (81.74%) |
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 383774 387230 399311 399518 400134 402984 403880 415627 421132 421779 421795 430283 431503 440796 440803 442526 443942 448934 452291 452778 453491 454055 456010 456149 464337 464880 474895 475116 480381 494975 496333 500529 505615 515849 516385 521285 521361 523770 525438 531435 539334 546199 550482 550498 550676 552495 555011 555400 568424 570399 573308 575181 576229 585518 586584 586684 591552 593675 594340 595063 595992 610563 613482 615517 616002 624341 634372 638360 657505 672745 673656 683331 689864 696890 713177 714864 728088 728453 729567 731244 735632 741304 744184 749206 749576 756247 758434 758617 760694 766764 766892 767130 772884 773130 773217 778752 779566 784092 786663 787492 787754 790744 792594 792636 794251 796118 797896 800510 801966 803415 804215 805636 809906 813225 815212 815842 816068 818386 818471 820743 ] |
||||||||||||||||||||||||||||||
|
17.22 ms (11.66%) |
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 672745 689864 576229 610563 778752 786663 805636 729567 735632 728088 773217 741304 749206 749576 728453 787492 387230 399518 442526 440796 415627 431503 815842 818386 816068 448934 456149 453491 452291 452778 480381 505615 523770 494975 500529 516385 464880 570399 550498 683331 657505 555011 573308 595063 616002 594340 595992 634372 779566 787754 790744 803415 794251 744184 766892 773130 756247 772884 731244 767130 792636 800510 400134 515849 521361 496333 525438 403880 443942 440803 430283 421779 820743 815212 818471 474895 475116 454055 456010 464337 521285 531435 539334 550676 550482 555400 575181 546199 568424 696890 714864 713177 673656 552495 585518 613482 586584 591552 615517 586684 638360 593675 784092 797896 796118 801966 813225 766764 760694 758434 758617 624341 792594 804215 809906 421795 383774 399311 402984 421132 ] |
||||||||||||||||||||||||||||||
|
2.93 ms (1.98%) |
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 383774 387230 399311 399518 400134 402984 403880 415627 421132 421779 421795 430283 431503 440796 440803 442526 443942 448934 452291 452778 453491 454055 456010 456149 464337 464880 474895 475116 480381 494975 496333 500529 505615 515849 516385 521285 521361 523770 525438 531435 539334 546199 550482 550498 550676 552495 555011 555400 568424 570399 573308 575181 576229 585518 586584 586684 591552 593675 594340 595063 595992 610563 613482 615517 616002 624341 634372 638360 657505 672745 673656 683331 689864 696890 713177 714864 728088 728453 729567 731244 735632 741304 744184 749206 749576 756247 758434 758617 760694 766764 766892 767130 772884 773130 773217 778752 779566 784092 786663 787492 787754 790744 792594 792636 794251 796118 797896 800510 801966 803415 804215 805636 809906 813225 815212 815842 816068 818386 818471 820743 ] |
||||||||||||||||||||||||||||||
|
1.87 ms (1.26%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"day milf"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (1.15%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"day milf"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (1.11%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"day milf"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (1.10%) |
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.