Query Metrics
7
Database Queries
7
Different statements
197.20 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
164.41 ms (83.37%) |
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 420580 422343 422380 424103 426726 426879 433716 434933 436218 437249 438020 438971 441806 446040 455187 455383 455551 455738 456133 456557 457339 457565 461161 462142 462549 462666 467707 474880 475213 476004 477637 478920 479094 481764 482843 482973 483056 485492 486090 492544 492693 494898 498897 500123 509274 510776 516295 516312 521618 521806 523132 523598 526796 536099 542081 551466 551844 552366 552369 559716 560793 560794 563670 565019 571467 578036 582534 598052 599135 610830 616728 616798 619682 666483 675845 679537 686524 703656 704291 719400 755863 764162 766312 771445 775362 777210 777270 777506 778189 778639 778984 779321 779974 780145 786969 787971 790777 790938 793592 794081 799005 808696 810895 816626 817248 817995 818013 818101 818106 819365 819917 821806 823366 823588 825566 828441 828443 828764 828765 ] |
||||||||||||||||||||||||||||||
|
17.71 ms (8.98%) |
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 455187 482843 482973 457339 479094 481764 438020 474880 483056 509274 523132 521806 446040 462549 456557 486090 521618 461161 422343 793592 790938 777506 771445 779974 426879 516295 823366 825566 492544 492693 686524 778189 779321 703656 794081 422380 457565 494898 610830 536099 500123 523598 616798 616728 777270 808696 766312 476004 563670 565019 455738 467707 666483 475213 571467 679537 598052 498897 456133 426726 434933 477637 542081 551844 551466 582534 704291 619682 785992 764162 787971 799005 755863 778639 778984 780145 810895 552369 433716 818106 436218 437249 462666 455383 786969 790777 485492 438971 462142 478920 526796 516312 424103 552366 560794 559716 578036 560793 599135 420580 441806 455551 510776 818101 816626 817248 819365 821806 823588 819917 817995 818013 828765 828764 828441 828443 675845 719400 775362 777210 ] |
||||||||||||||||||||||||||||||
|
5.38 ms (2.73%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
3.39 ms (1.72%) |
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 420580 422343 422380 424103 426726 426879 433716 434933 436218 437249 438020 438971 441806 446040 455187 455383 455551 455738 456133 456557 457339 457565 461161 462142 462549 462666 467707 474880 475213 476004 477637 478920 479094 481764 482843 482973 483056 485492 486090 492544 492693 494898 498897 500123 509274 510776 516295 516312 521618 521806 523132 523598 526796 536099 542081 551466 551844 552366 552369 559716 560793 560794 563670 565019 571467 578036 582534 598052 599135 610830 616728 616798 619682 666483 675845 679537 686524 703656 704291 719400 755863 764162 766312 771445 775362 777210 777270 777506 778189 778639 778984 779321 779974 780145 786969 787971 790777 790938 793592 794081 799005 808696 810895 816626 817248 817995 818013 818101 818106 819365 819917 821806 823366 823588 825566 828441 828443 828764 828765 ] |
||||||||||||||||||||||||||||||
|
2.15 ms (1.09%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"русск дрочк член пов"
]
|
||||||||||||||||||||||||||||||
|
2.14 ms (1.09%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск дрочк член пов"
]
|
||||||||||||||||||||||||||||||
|
2.02 ms (1.03%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"russian handjob pov"
]
|
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.