Query Metrics
7
Database Queries
7
Different statements
192.88 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
159.03 ms (82.45%) |
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 117890 382670 391432 397670 398074 401071 401184 414042 416192 416635 417396 417674 418135 419352 419452 419455 420918 421678 424265 429106 429759 436074 439257 439326 439345 445265 445428 445493 446241 447778 448575 454725 460314 468165 471101 471115 471118 471148 473778 476216 476649 477125 477762 478901 480800 483951 486783 486829 493249 495559 497286 504661 509981 516584 517214 521637 524479 530948 531075 547241 547242 552619 560029 560925 564383 568483 568499 569656 573748 575198 577822 579523 581806 583508 584301 584832 585446 585951 585954 590377 592005 593292 595471 595588 597919 602268 604219 604342 604794 604936 609892 613515 621259 626617 632169 632569 633163 638074 639159 643084 650510 666942 680428 680484 696485 720622 746570 752148 752915 756491 783486 786201 796982 805144 806580 807599 810186 823788 824685 826142 ] |
||||||||||||||||||||||||||||||
|
21.04 ms (10.91%) |
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 595588 783486 752148 439345 401184 478901 382670 517214 486783 826142 746570 397670 414042 468165 477762 547242 573748 680484 585951 417396 471101 486829 569656 581806 597919 626617 471148 585446 632169 805144 419452 420918 439326 445493 471118 429759 471115 476649 521637 495559 504661 497286 633163 477125 418135 650510 796982 752915 609892 493249 643084 807599 756491 419352 473778 460314 786201 564383 604342 584301 592005 604219 516584 454725 595471 639159 436074 604794 810186 680428 590377 806580 417674 419455 424265 552619 560925 547241 416635 480800 577822 398074 824685 568499 585954 638074 391432 117890 602268 584832 509981 613515 560029 583508 593292 632569 823788 579523 568483 445428 421678 530948 575198 476216 416192 621259 445265 483951 666942 720622 696485 604936 401071 448575 439257 447778 429106 446241 531075 524479 ] |
||||||||||||||||||||||||||||||
|
4.21 ms (2.18%) |
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 117890 382670 391432 397670 398074 401071 401184 414042 416192 416635 417396 417674 418135 419352 419452 419455 420918 421678 424265 429106 429759 436074 439257 439326 439345 445265 445428 445493 446241 447778 448575 454725 460314 468165 471101 471115 471118 471148 473778 476216 476649 477125 477762 478901 480800 483951 486783 486829 493249 495559 497286 504661 509981 516584 517214 521637 524479 530948 531075 547241 547242 552619 560029 560925 564383 568483 568499 569656 573748 575198 577822 579523 581806 583508 584301 584832 585446 585951 585954 590377 592005 593292 595471 595588 597919 602268 604219 604342 604794 604936 609892 613515 621259 626617 632169 632569 633163 638074 639159 643084 650510 666942 680428 680484 696485 720622 746570 752148 752915 756491 783486 786201 796982 805144 806580 807599 810186 823788 824685 826142 ] |
||||||||||||||||||||||||||||||
|
2.35 ms (1.22%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"beauty anal solo"
]
|
||||||||||||||||||||||||||||||
|
2.20 ms (1.14%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.04 ms (1.06%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"beauty анал соло"
]
|
||||||||||||||||||||||||||||||
|
2.01 ms (1.04%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"beauty анал соло"
]
|
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.