Query Metrics
7
Database Queries
7
Different statements
1229.39 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
1047.46 ms (85.20%) |
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 425065 456556 517599 520823 526722 489301 495920 508756 519510 511159 664794 510092 456955 415233 443057 449450 457991 473616 478702 447862 459264 460138 455632 485290 499955 502106 537290 502742 463151 553678 567912 659986 661396 716927 704726 580272 613599 622035 599713 626436 605458 731279 735515 463624 463705 451133 463935 426476 448434 446612 463344 465162 501388 511828 516780 517448 519885 520251 483263 487921 489627 492261 505940 522051 527381 529170 484760 485569 523731 537020 493954 494782 507891 511124 522905 525169 527430 527843 522771 626441 417462 422143 479637 476333 518054 450941 528732 418959 448711 453450 524295 528412 516775 602398 408998 439445 456942 449208 415948 450470 521520 523659 525179 499332 520701 402256 464111 527940 496288 496330 521756 534284 521582 464123 477462 480786 549159 567000 580647 583037 ] |
||||||||||||||||||||||||||||||
|
170.87 ms (13.90%) |
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 402256 408998 415233 415948 417462 418959 422143 425065 426476 439445 443057 446612 447862 448434 448711 449208 449450 450470 450941 451133 453450 455632 456556 456942 456955 457991 459264 460138 463151 463344 463624 463705 463935 464111 464123 465162 473616 476333 477462 478702 479637 480786 483263 484760 485290 485569 487921 489301 489627 492261 493954 494782 495920 496288 496330 499332 499955 501388 502106 502742 505940 507891 508756 510092 511124 511159 511828 516775 516780 517448 517599 518054 519510 519885 520251 520701 520823 521520 521582 521756 522051 522771 522905 523659 523731 524295 525169 525179 526722 527381 527430 527843 528412 528732 529170 534284 537020 537290 549159 553678 567000 567912 580272 580647 583037 599713 602398 605458 613599 622035 626436 626441 659986 661396 664794 704726 716927 731279 735515 ] |
||||||||||||||||||||||||||||||
|
3.18 ms (0.26%) |
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 402256 408998 415233 415948 417462 418959 422143 425065 426476 439445 443057 446612 447862 448434 448711 449208 449450 450470 450941 451133 453450 455632 456556 456942 456955 457991 459264 460138 463151 463344 463624 463705 463935 464111 464123 465162 473616 476333 477462 478702 479637 480786 483263 484760 485290 485569 487921 489301 489627 492261 493954 494782 495920 496288 496330 499332 499955 501388 502106 502742 505940 507891 508756 510092 511124 511159 511828 516775 516780 517448 517599 518054 519510 519885 520251 520701 520823 521520 521582 521756 522051 522771 522905 523659 523731 524295 525169 525179 526722 527381 527430 527843 528412 528732 529170 534284 537020 537290 549159 553678 567000 567912 580272 580647 583037 599713 602398 605458 613599 622035 626436 626441 659986 661396 664794 704726 716927 731279 735515 ] |
||||||||||||||||||||||||||||||
|
2.10 ms (0.17%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.02 ms (0.16%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"caught big cock"
]
|
||||||||||||||||||||||||||||||
|
1.95 ms (0.16%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"caught большие cock"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (0.15%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"caught большие cock"
]
|
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.