Query Metrics
7
Database Queries
7
Different statements
156.88 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
130.08 ms (82.92%) |
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 16646 66747 105093 107102 107712 124661 145335 381855 382388 382937 384935 385125 386322 386954 387496 391134 393462 396887 398957 401749 407504 407877 409390 411588 412518 413794 414220 414734 414739 416016 418134 419330 422357 427267 431088 434491 439660 440968 445954 446833 447329 447618 448077 448547 453231 454589 455917 457797 458987 460986 465924 466173 468097 475509 475586 479222 479281 482569 485241 487297 488239 490903 491159 493898 501581 502857 507657 511607 511999 514934 516914 520916 524177 525425 535102 544386 550716 551619 551921 563452 564420 565730 569913 571585 571921 576039 576276 582605 589669 641707 657352 676915 720591 721275 733615 742138 742241 744355 745241 745771 746638 748225 761118 764070 766302 779178 779360 780631 783155 787106 788371 794462 796091 801141 806239 810051 810062 810690 813761 818770 ] |
||||||||||||||||||||||||||||||
|
15.75 ms (10.04%) |
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 145335 107102 535102 745241 733615 641707 779360 427267 413794 493898 748225 744355 411588 465924 439660 466173 468097 520916 382388 16646 387496 482569 676915 721275 563452 780631 810051 779178 745771 787106 810062 385125 407504 414739 124661 105093 720591 414734 398957 813761 454589 458987 479222 571921 569913 571585 576276 582605 761118 796091 475586 391134 381855 422357 445954 453231 455917 447329 475509 457797 479281 511999 485241 490903 491159 488239 507657 419330 806239 386954 434491 418134 446833 448547 487297 501581 550716 551619 576039 564420 565730 742241 766302 409390 412518 460986 414220 448077 502857 525425 524177 514934 516914 386322 107712 396887 818770 657352 589669 788371 794462 783155 801141 742138 764070 746638 382937 407877 66747 393462 416016 431088 447618 544386 551921 511607 810690 440968 401749 384935 ] |
||||||||||||||||||||||||||||||
|
3.21 ms (2.05%) |
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 16646 66747 105093 107102 107712 124661 145335 381855 382388 382937 384935 385125 386322 386954 387496 391134 393462 396887 398957 401749 407504 407877 409390 411588 412518 413794 414220 414734 414739 416016 418134 419330 422357 427267 431088 434491 439660 440968 445954 446833 447329 447618 448077 448547 453231 454589 455917 457797 458987 460986 465924 466173 468097 475509 475586 479222 479281 482569 485241 487297 488239 490903 491159 493898 501581 502857 507657 511607 511999 514934 516914 520916 524177 525425 535102 544386 550716 551619 551921 563452 564420 565730 569913 571585 571921 576039 576276 582605 589669 641707 657352 676915 720591 721275 733615 742138 742241 744355 745241 745771 746638 748225 761118 764070 766302 779178 779360 780631 783155 787106 788371 794462 796091 801141 806239 810051 810062 810690 813761 818770 ] |
||||||||||||||||||||||||||||||
|
2.23 ms (1.42%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"boy lick pussy"
]
|
||||||||||||||||||||||||||||||
|
1.95 ms (1.24%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.89 ms (1.20%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"парен лиза pussy"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (1.13%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"парен лиза pussy"
]
|
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.