Query Metrics
7
Database Queries
7
Different statements
145.17 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
119.15 ms (82.08%) |
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 6858 233027 382212 384775 387080 388687 389117 389516 391908 393330 396052 398714 398784 400719 401295 401374 401952 405242 409651 411405 420015 422635 424164 426672 427158 435215 435528 435555 438540 440217 444666 447234 447503 448763 448765 451579 459491 459991 461414 461851 466022 466030 466178 470096 470192 470630 473905 474918 475605 477649 482834 483240 486051 487133 489593 491334 491542 494119 494616 495719 501730 511701 511873 513667 515537 519657 520622 521396 522241 522242 522714 537963 547811 549777 554983 558101 561291 561709 563993 570198 572141 572997 573423 573675 574918 598010 598688 626880 653479 654784 655950 657360 659168 663345 670985 673126 675630 689121 715377 720113 722819 722923 728974 729786 730269 731835 740561 742818 743099 743285 745744 754758 758734 781481 788433 791586 791764 792338 809971 810766 ] |
||||||||||||||||||||||||||||||
|
16.33 ms (11.25%) |
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 474918 422635 451579 511701 515537 521396 486051 489593 522714 424164 573423 558101 598688 382212 384775 396052 438540 447234 459991 475605 477649 387080 466030 398784 401374 435215 435555 233027 511873 494616 520622 483240 400719 655950 657360 659168 663345 675630 689121 715377 722923 653479 654784 670985 673126 626880 791764 781481 788433 809971 792338 810766 731835 745744 754758 728974 729786 758734 730269 743099 740561 743285 720113 722819 791586 6858 427158 561291 487133 519657 448763 522241 411405 470096 549777 388687 389516 401295 447503 401952 466178 448765 470192 389117 466022 501730 537963 494119 482834 495719 522242 491334 491542 435528 470630 513667 554983 570198 573675 563993 572141 547811 561709 572997 574918 598010 742818 393330 426672 391908 440217 444666 459491 461414 461851 473905 398714 405242 409651 420015 ] |
||||||||||||||||||||||||||||||
|
2.90 ms (2.00%) |
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 6858 233027 382212 384775 387080 388687 389117 389516 391908 393330 396052 398714 398784 400719 401295 401374 401952 405242 409651 411405 420015 422635 424164 426672 427158 435215 435528 435555 438540 440217 444666 447234 447503 448763 448765 451579 459491 459991 461414 461851 466022 466030 466178 470096 470192 470630 473905 474918 475605 477649 482834 483240 486051 487133 489593 491334 491542 494119 494616 495719 501730 511701 511873 513667 515537 519657 520622 521396 522241 522242 522714 537963 547811 549777 554983 558101 561291 561709 563993 570198 572141 572997 573423 573675 574918 598010 598688 626880 653479 654784 655950 657360 659168 663345 670985 673126 675630 689121 715377 720113 722819 722923 728974 729786 730269 731835 740561 742818 743099 743285 745744 754758 758734 781481 788433 791586 791764 792338 809971 810766 ] |
||||||||||||||||||||||||||||||
|
2.16 ms (1.49%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"brunette russian"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (1.09%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"черноволосая русск"
]
|
||||||||||||||||||||||||||||||
|
1.58 ms (1.09%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.46 ms (1.00%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.