Query Metrics
7
Database Queries
7
Different statements
165.65 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
139.17 ms (84.01%) |
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 34382 394941 417363 419631 420369 420459 421732 421982 424965 431871 431882 431918 432928 441176 451073 452890 453030 453032 453043 453098 453228 455735 457971 459490 460806 460863 463084 464155 464989 465027 465052 465208 465611 469983 469989 470437 470532 470538 470858 472085 472813 475537 476274 477104 482145 482937 484271 486383 489833 493552 495016 495940 507042 510247 515747 521559 523975 530452 535732 542572 545854 548243 550314 550692 557192 563986 565280 566656 569020 572689 578028 580159 580188 581231 581500 582301 582966 583035 583098 590205 590767 606892 618389 621501 627709 632668 659321 670662 684178 689750 705694 711685 715365 718928 719765 741151 752148 766825 770136 774709 784157 784184 784754 786444 788258 788527 788562 788903 788920 790219 792552 792553 795406 801359 801377 807208 809191 810991 815194 816565 ] |
||||||||||||||||||||||||||||||
|
16.23 ms (9.80%) |
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 684178 705694 557192 801359 784184 788527 523975 394941 431882 431918 417363 472813 482145 453043 470538 465027 580159 580188 582966 572689 621501 627709 807208 752148 810991 452890 420369 457971 469983 472085 489833 34382 431871 815194 470858 535732 542572 711685 719765 809191 792552 455735 432928 470437 453228 482937 530452 521559 582301 718928 659321 563986 581231 606892 788920 420459 470532 419631 421982 453032 465052 469989 486383 465611 476274 569020 581500 550692 583035 689750 590767 788258 788903 801377 784157 784754 766825 632668 790219 463084 441176 459490 460806 464989 495940 507042 510247 421732 816565 453098 475537 484271 453030 495016 566656 545854 548243 550314 565280 670662 715365 578028 583098 590205 618389 786444 788562 795406 741151 770136 774709 792553 451073 465208 477104 424965 460863 464155 515747 493552 ] |
||||||||||||||||||||||||||||||
|
2.85 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 34382 394941 417363 419631 420369 420459 421732 421982 424965 431871 431882 431918 432928 441176 451073 452890 453030 453032 453043 453098 453228 455735 457971 459490 460806 460863 463084 464155 464989 465027 465052 465208 465611 469983 469989 470437 470532 470538 470858 472085 472813 475537 476274 477104 482145 482937 484271 486383 489833 493552 495016 495940 507042 510247 515747 521559 523975 530452 535732 542572 545854 548243 550314 550692 557192 563986 565280 566656 569020 572689 578028 580159 580188 581231 581500 582301 582966 583035 583098 590205 590767 606892 618389 621501 627709 632668 659321 670662 684178 689750 705694 711685 715365 718928 719765 741151 752148 766825 770136 774709 784157 784184 784754 786444 788258 788527 788562 788903 788920 790219 792552 792553 795406 801359 801377 807208 809191 810991 815194 816565 ] |
||||||||||||||||||||||||||||||
|
2.20 ms (1.33%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sex games"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (1.13%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.72 ms (1.04%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс games"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (0.97%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс games"
]
|
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.