Query Metrics
7
Database Queries
7
Different statements
371.02 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
209.05 ms (56.34%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"bdsm girl"
]
|
||||||||||||||||||||||||||||||
|
137.03 ms (36.93%) |
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 246261 384058 384302 385119 414212 421448 422847 427388 428532 428726 429278 441838 456215 463915 467684 470141 470580 471935 472350 477036 479345 488337 489977 491814 493194 493275 494999 495066 500122 500146 500311 502240 502464 505575 511600 516618 518628 521214 522412 523498 525957 527909 531247 532508 532965 533984 537577 544358 544939 546833 546843 548253 550051 550068 550768 551049 551147 554002 555248 558620 559667 559856 561085 563853 565304 569722 569727 574863 575115 575343 575451 575791 576901 579547 579981 580664 585617 588359 593108 598524 600111 603999 605523 606636 610726 627730 630801 649996 665900 683897 701389 704979 707439 713983 715421 726503 728540 740656 746472 752545 754423 754805 755512 758125 763297 764155 765796 769067 775414 780533 789970 790112 797110 802927 817015 817092 817195 818964 821845 ] |
||||||||||||||||||||||||||||||
|
16.22 ms (4.37%) |
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 548253 576901 546833 546843 551049 606636 626851 600111 588359 775414 427388 428532 477036 471935 470580 500122 500146 493275 441838 429278 488337 500311 550068 569722 579547 554002 603999 630801 726503 728540 479345 532508 522412 531247 384058 817092 817195 533984 537577 565304 559667 575343 585617 593108 790112 780533 763297 764155 758125 384302 817015 818964 502240 544939 544358 561085 715421 649996 683897 769067 754805 746472 752545 754423 789970 414212 422847 456215 575451 558620 574863 550768 516618 511600 489977 755512 550051 385119 246261 821845 555248 563853 569727 713983 701389 704979 707439 740656 765796 610726 802927 428726 463915 495066 502464 518628 532965 579981 551147 559856 797110 470141 421448 467684 472350 505575 525957 494999 523498 527909 575115 575791 493194 598524 627730 521214 491814 580664 665900 605523 ] |
||||||||||||||||||||||||||||||
|
3.76 ms (1.01%) |
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 246261 384058 384302 385119 414212 421448 422847 427388 428532 428726 429278 441838 456215 463915 467684 470141 470580 471935 472350 477036 479345 488337 489977 491814 493194 493275 494999 495066 500122 500146 500311 502240 502464 505575 511600 516618 518628 521214 522412 523498 525957 527909 531247 532508 532965 533984 537577 544358 544939 546833 546843 548253 550051 550068 550768 551049 551147 554002 555248 558620 559667 559856 561085 563853 565304 569722 569727 574863 575115 575343 575451 575791 576901 579547 579981 580664 585617 588359 593108 598524 600111 603999 605523 606636 610726 627730 630801 649996 665900 683897 701389 704979 707439 713983 715421 726503 728540 740656 746472 752545 754423 754805 755512 758125 763297 764155 765796 769067 775414 780533 789970 790112 797110 802927 817015 817092 817195 818964 821845 ] |
||||||||||||||||||||||||||||||
|
1.75 ms (0.47%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.68 ms (0.45%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"бдсм девушк"
]
|
||||||||||||||||||||||||||||||
|
1.53 ms (0.41%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.