Query Metrics
7
Database Queries
7
Different statements
160.40 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
136.19 ms (84.91%) |
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 420308 440276 440947 440997 443309 445625 451499 456995 477123 485644 489292 492372 493684 497509 516028 518763 518912 533655 533793 535636 536449 544748 545637 555057 560923 564282 564298 565693 567056 567611 584298 588077 602602 629354 663337 663523 665899 666361 673503 707227 708087 711953 714630 714888 715027 719957 720065 720154 720788 726929 727460 727785 727789 728719 729285 729301 731333 733375 734969 736674 736692 742797 743934 744975 747958 749322 758152 759878 759891 759895 759905 759917 759933 759950 761103 761587 762379 765311 765555 765789 767116 768387 769291 770331 773686 775377 782090 783372 783382 783778 787614 788073 790832 791216 791561 791624 791627 794364 794720 795689 796050 796081 796139 798811 800313 800392 800439 801214 801298 803498 804339 806296 810290 810308 813946 824848 825418 827609 827632 827686 ] |
||||||||||||||||||||||||||||||
|
13.04 ms (8.13%) |
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 759895 759917 727460 440947 492372 564282 663337 720788 765555 783778 451499 707227 555057 813946 584298 794720 791627 758152 770331 420308 545637 567611 588077 518763 762379 440997 666361 759950 768387 759905 759933 629354 708087 440276 485644 714888 720154 715027 720065 775377 782090 791216 795689 798811 783382 800313 800439 801298 729301 731333 761587 783372 791561 794364 810290 729285 749322 773686 761103 765789 796081 806296 810308 827632 743934 535636 824848 456995 536449 804339 728719 726929 736674 759878 747958 727785 796050 742797 734969 443309 477123 493684 445625 497509 714630 719957 788073 803498 796139 759891 736692 767116 727789 765311 733375 790832 489292 516028 544748 787614 711953 825418 564298 565693 560923 769291 744975 602602 567056 663523 665899 518912 533655 533793 673503 827609 827686 800392 791624 801214 ] |
||||||||||||||||||||||||||||||
|
4.14 ms (2.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 420308 440276 440947 440997 443309 445625 451499 456995 477123 485644 489292 492372 493684 497509 516028 518763 518912 533655 533793 535636 536449 544748 545637 555057 560923 564282 564298 565693 567056 567611 584298 588077 602602 629354 663337 663523 665899 666361 673503 707227 708087 711953 714630 714888 715027 719957 720065 720154 720788 726929 727460 727785 727789 728719 729285 729301 731333 733375 734969 736674 736692 742797 743934 744975 747958 749322 758152 759878 759891 759895 759905 759917 759933 759950 761103 761587 762379 765311 765555 765789 767116 768387 769291 770331 773686 775377 782090 783372 783382 783778 787614 788073 790832 791216 791561 791624 791627 794364 794720 795689 796050 796081 796139 798811 800313 800392 800439 801214 801298 803498 804339 806296 810290 810308 813946 824848 825418 827609 827632 827686 ] |
||||||||||||||||||||||||||||||
|
1.99 ms (1.24%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"milf anal homemade"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (1.15%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.60 ms (1.00%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"milf анал домашн любительск"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (0.99%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"milf анал домашн любительск"
]
|
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.