Query Metrics
7
Database Queries
7
Different statements
148.41 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
121.38 ms (81.78%) |
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 386712 388647 391565 392620 393731 393758 400447 401362 401996 409100 413732 413934 417010 418725 421132 425554 427282 430144 430308 433748 434168 434185 434661 435613 435735 435768 437336 441506 442380 443064 445501 446331 446354 448560 449431 453548 454043 455060 455957 455973 457113 457675 460247 460677 461645 464307 465507 466368 466775 467313 467663 469022 469514 471408 471775 471962 472436 472466 475174 477699 479021 481795 485187 486946 493138 493817 494040 505973 506130 506227 506778 507363 512061 513495 513584 514272 516410 516757 516792 517526 519934 520004 521391 523323 524518 524910 526394 526591 526611 526830 527181 527663 537020 546894 557961 560885 565012 566337 567014 572028 572943 575704 578078 591690 591735 598483 604157 607214 610021 612601 618893 636070 645273 647856 662140 714062 717895 789067 789698 812593 ] |
||||||||||||||||||||||||||||||
|
16.63 ms (11.21%) |
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 409100 386712 471408 425554 441506 460247 516410 519934 493817 516792 505973 400447 434661 442380 435768 446354 449431 467313 493138 454043 517526 526394 506130 524910 467663 469022 567014 572943 560885 636070 418725 433748 437336 421132 457675 472466 466368 512061 513584 485187 494040 521391 392620 388647 401996 413732 427282 465507 457113 546894 557961 572028 565012 578078 714062 662140 717895 610021 604157 789698 812593 789067 607214 612601 393731 477699 391565 466775 455973 524518 486946 430308 443064 516757 566337 647856 591690 591735 598483 618893 417010 514272 471962 527181 455957 506778 471775 507363 537020 434185 435735 434168 455060 461645 527663 469514 446331 475174 393758 435613 464307 472436 526591 506227 513495 523323 526611 520004 526830 401362 413934 430144 445501 481795 448560 453548 460677 479021 575704 645273 ] |
||||||||||||||||||||||||||||||
|
2.92 ms (1.97%) |
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 386712 388647 391565 392620 393731 393758 400447 401362 401996 409100 413732 413934 417010 418725 421132 425554 427282 430144 430308 433748 434168 434185 434661 435613 435735 435768 437336 441506 442380 443064 445501 446331 446354 448560 449431 453548 454043 455060 455957 455973 457113 457675 460247 460677 461645 464307 465507 466368 466775 467313 467663 469022 469514 471408 471775 471962 472436 472466 475174 477699 479021 481795 485187 486946 493138 493817 494040 505973 506130 506227 506778 507363 512061 513495 513584 514272 516410 516757 516792 517526 519934 520004 521391 523323 524518 524910 526394 526591 526611 526830 527181 527663 537020 546894 557961 560885 565012 566337 567014 572028 572943 575704 578078 591690 591735 598483 604157 607214 610021 612601 618893 636070 645273 647856 662140 714062 717895 789067 789698 812593 ] |
||||||||||||||||||||||||||||||
|
2.02 ms (1.36%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"dad dick"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (1.27%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.81 ms (1.22%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"dad член"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (1.20%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"dad член"
]
|
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.