Query Metrics
7
Database Queries
7
Different statements
182.61 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
155.82 ms (85.33%) |
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 312264 381930 383065 384128 388716 392019 395628 395878 396629 397019 398038 401903 401954 405860 407727 408709 408978 409251 410633 411626 411628 411710 411737 411794 412776 413454 413472 413476 419839 421257 422426 425984 429267 430293 450147 451436 451474 453108 453114 453122 453541 454408 458364 459472 460273 460682 467062 469360 471078 474111 474115 474123 474124 474849 476310 481467 483358 485758 485763 485765 485772 487349 493472 502061 506349 515059 515074 515083 516137 519135 520894 523076 523382 523595 525495 525507 526404 543119 554446 561992 563065 565918 577178 578163 578183 585111 587298 592998 594283 607692 649527 651886 665101 665197 665206 665229 665294 665357 665372 665864 665871 666796 667833 668699 668901 669418 669753 702158 710127 714203 714698 726859 744232 744985 748467 751511 753050 784669 804421 824833 ] |
||||||||||||||||||||||||||||||
|
16.00 ms (8.76%) |
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 401903 396629 419839 422426 450147 502061 665372 665197 607692 744985 384128 421257 397019 408978 413476 483358 515083 554446 668901 669753 665206 702158 649527 744232 748467 471078 413454 824833 410633 388716 411626 408709 453122 474124 460273 474111 561992 587298 395628 392019 401954 459472 469360 453108 668699 665294 714203 726859 451436 395878 381930 409251 487349 458364 474115 525495 578183 565918 665101 667833 669418 714698 710127 592998 594283 804421 753050 784669 751511 411737 451474 520894 407727 474849 453541 412776 383065 398038 405860 411628 460682 516137 493472 429267 467062 481467 425984 312264 411794 430293 413472 411710 585111 485765 453114 485758 485763 454408 474123 485772 519135 506349 523595 523076 523382 515059 515074 525507 526404 476310 577178 578163 543119 563065 665229 665871 666796 651886 665357 665864 ] |
||||||||||||||||||||||||||||||
|
3.58 ms (1.96%) |
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 312264 381930 383065 384128 388716 392019 395628 395878 396629 397019 398038 401903 401954 405860 407727 408709 408978 409251 410633 411626 411628 411710 411737 411794 412776 413454 413472 413476 419839 421257 422426 425984 429267 430293 450147 451436 451474 453108 453114 453122 453541 454408 458364 459472 460273 460682 467062 469360 471078 474111 474115 474123 474124 474849 476310 481467 483358 485758 485763 485765 485772 487349 493472 502061 506349 515059 515074 515083 516137 519135 520894 523076 523382 523595 525495 525507 526404 543119 554446 561992 563065 565918 577178 578163 578183 585111 587298 592998 594283 607692 649527 651886 665101 665197 665206 665229 665294 665357 665372 665864 665871 666796 667833 668699 668901 669418 669753 702158 710127 714203 714698 726859 744232 744985 748467 751511 753050 784669 804421 824833 ] |
||||||||||||||||||||||||||||||
|
2.21 ms (1.21%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"полненькие волосатые%…"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (1.00%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"полная волосатая"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (0.91%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.50 ms (0.82%) |
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.