Query Metrics
7
Database Queries
7
Different statements
160.41 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
127.12 ms (79.25%) |
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 396654 411623 418244 421206 422051 423881 425330 425767 434276 434301 435424 435792 439845 441756 442669 443487 444977 446112 446455 446943 447601 448260 448440 454141 456090 459961 463083 464336 467344 469749 472384 472849 473139 473167 476485 478121 478140 479611 481635 481995 484127 485177 485576 485985 488538 488928 490968 492336 493951 495352 496754 498056 498174 500478 501152 501547 502657 503116 507010 507706 510877 512375 512410 513393 513404 514382 516241 516283 517779 519864 520327 520428 520482 521669 522386 523329 524477 525282 525509 525929 525995 526714 528003 528140 534702 539288 546730 552458 555127 558568 558581 559998 567038 568536 569836 574727 575057 582687 586380 586408 587858 590633 598919 598999 600411 602742 604102 605442 609540 622405 624137 679398 682421 684694 714503 717182 732913 759946 795437 797462 ] |
||||||||||||||||||||||||||||||
|
21.83 ms (13.61%) |
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 567038 586408 478140 519864 495352 446455 555127 598999 513393 732913 441756 479611 478121 481635 522386 516283 795437 463083 558568 425330 590633 559998 534702 447601 500478 546730 473167 467344 513404 490968 421206 485985 469749 501152 520428 485576 525509 525929 525995 485177 503116 488928 582687 501547 443487 448440 587858 423881 512410 493951 496754 759946 481995 418244 528140 498174 586380 600411 456090 396654 422051 521669 568536 797462 434301 446943 516241 507010 525282 492336 411623 507706 524477 439845 514382 476485 528003 523329 714503 569836 484127 624137 472849 472384 488538 425767 575057 679398 609540 512375 526714 498056 520327 442669 464336 435424 446112 552458 510877 502657 598919 434276 558581 602742 622405 454141 473139 605442 459961 448260 574727 444977 539288 520482 682421 684694 604102 717182 517779 435792 ] |
||||||||||||||||||||||||||||||
|
3.32 ms (2.07%) |
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 396654 411623 418244 421206 422051 423881 425330 425767 434276 434301 435424 435792 439845 441756 442669 443487 444977 446112 446455 446943 447601 448260 448440 454141 456090 459961 463083 464336 467344 469749 472384 472849 473139 473167 476485 478121 478140 479611 481635 481995 484127 485177 485576 485985 488538 488928 490968 492336 493951 495352 496754 498056 498174 500478 501152 501547 502657 503116 507010 507706 510877 512375 512410 513393 513404 514382 516241 516283 517779 519864 520327 520428 520482 521669 522386 523329 524477 525282 525509 525929 525995 526714 528003 528140 534702 539288 546730 552458 555127 558568 558581 559998 567038 568536 569836 574727 575057 582687 586380 586408 587858 590633 598919 598999 600411 602742 604102 605442 609540 622405 624137 679398 682421 684694 714503 717182 732913 759946 795437 797462 ] |
||||||||||||||||||||||||||||||
|
2.51 ms (1.56%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"passionate blowjob"
]
|
||||||||||||||||||||||||||||||
|
1.93 ms (1.21%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"passionate минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (1.17%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.82 ms (1.14%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"passionate минет оральн секс"
]
|
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.