Query Metrics
7
Database Queries
7
Different statements
163.71 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
138.75 ms (84.75%) |
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 16971 395632 395747 396647 402247 416039 419178 426084 434275 436933 438067 438095 443591 443609 443871 445879 447400 448938 449170 454924 455919 457629 458694 461599 462535 464366 465010 465103 465253 470106 470150 470335 473598 477355 477545 478818 482409 483660 484649 484915 485591 485788 485940 487719 488352 489310 498306 499010 499028 502326 504163 504408 506841 509033 513824 514692 514815 514949 516141 516429 516634 516875 517190 519240 519272 521534 522107 522318 523474 525871 526435 526948 529271 531278 532352 534300 534850 534968 541215 543604 549778 551577 570214 570700 573644 574231 574831 576343 581354 582189 586539 590809 591437 591646 593641 593855 593875 593992 595011 598642 603629 608695 609783 615443 625556 633047 649240 675471 695282 713630 716501 718798 722903 726553 784315 784475 786064 795179 798684 811133 ] |
||||||||||||||||||||||||||||||
|
15.37 ms (9.39%) |
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 516875 525871 485591 509033 514815 449170 434275 455919 582189 484649 484915 470150 593992 514949 477355 443609 526435 443871 419178 436933 534850 595011 586539 784315 576343 502326 462535 543604 506841 519240 458694 426084 485940 517190 608695 529271 445879 461599 718798 649240 811133 470106 478818 454924 514692 485788 498306 499010 516141 551577 464366 526948 448938 457629 521534 531278 465103 593641 603629 798684 438067 443591 465010 516429 473598 615443 470335 477545 570700 489310 522107 516634 591646 726553 609783 504163 402247 395632 570214 716501 396647 598642 416039 504408 465253 549778 675471 593855 574231 722903 541215 593875 395747 532352 574831 695282 713630 784475 786064 795179 488352 522318 499028 573644 513824 483660 534968 590809 625556 447400 16971 438095 534300 581354 482409 633047 591437 519272 523474 487719 ] |
||||||||||||||||||||||||||||||
|
2.63 ms (1.61%) |
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 16971 395632 395747 396647 402247 416039 419178 426084 434275 436933 438067 438095 443591 443609 443871 445879 447400 448938 449170 454924 455919 457629 458694 461599 462535 464366 465010 465103 465253 470106 470150 470335 473598 477355 477545 478818 482409 483660 484649 484915 485591 485788 485940 487719 488352 489310 498306 499010 499028 502326 504163 504408 506841 509033 513824 514692 514815 514949 516141 516429 516634 516875 517190 519240 519272 521534 522107 522318 523474 525871 526435 526948 529271 531278 532352 534300 534850 534968 541215 543604 549778 551577 570214 570700 573644 574231 574831 576343 581354 582189 586539 590809 591437 591646 593641 593855 593875 593992 595011 598642 603629 608695 609783 615443 625556 633047 649240 675471 695282 713630 716501 718798 722903 726553 784315 784475 786064 795179 798684 811133 ] |
||||||||||||||||||||||||||||||
|
1.95 ms (1.19%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"частное домашний жмж"
]
|
||||||||||||||||||||||||||||||
|
1.92 ms (1.17%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.62 ms (0.99%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"любительск домашн любительск жмж секс втро"
]
|
||||||||||||||||||||||||||||||
|
1.46 ms (0.89%) |
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.