Query Metrics
7
Database Queries
7
Different statements
193.18 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
170.45 ms (88.24%) |
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 426712 427290 431599 442681 446932 448521 450238 455977 456423 456432 457226 461231 462289 465384 466253 467575 470508 470622 470640 470926 476495 477478 477930 478568 478571 488175 488825 490840 492691 495050 499566 500599 500717 504876 505064 508405 509403 509861 511291 511784 516645 517568 517598 520758 521993 524613 527865 528149 532649 535306 535547 535747 537970 539413 542739 542765 542789 544247 544398 545187 545629 546668 546722 546771 550292 550302 551572 553432 557487 563400 563411 577587 578803 581552 583691 587970 590307 591327 593847 597152 599533 602443 603673 603686 604746 606375 607023 609235 622835 625385 627701 631859 631908 633051 642469 642556 649211 650532 650847 653383 653595 654246 654591 661382 661970 662143 665926 670717 670820 688991 694028 694029 704010 723892 732003 732553 733589 739916 742670 750827 ] |
||||||||||||||||||||||||||||||
|
13.52 ms (7.00%) |
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 470926 524613 455977 542789 457226 461231 462289 511291 516645 590307 642556 622835 704010 545629 509403 535747 500717 739916 550292 527865 528149 581552 578803 488175 470508 476495 517568 537970 499566 520758 542765 649211 426712 599533 470640 597152 470622 604746 633051 504876 544247 654246 653383 517598 688991 631859 563411 609235 602443 606375 505064 477478 653595 550302 661382 427290 625385 448521 631908 670820 521993 661970 577587 508405 587970 539413 654591 593847 603673 627701 732553 477930 478568 467575 478571 509861 495050 511784 544398 551572 665926 545187 546668 553432 563400 750827 723892 456423 465384 500599 431599 535547 532649 490840 542739 546722 583691 670717 694029 694028 642469 591327 603686 607023 732003 733589 742670 456432 466253 450238 488825 535306 442681 446932 492691 546771 557487 650847 662143 650532 ] |
||||||||||||||||||||||||||||||
|
2.17 ms (1.12%) |
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 426712 427290 431599 442681 446932 448521 450238 455977 456423 456432 457226 461231 462289 465384 466253 467575 470508 470622 470640 470926 476495 477478 477930 478568 478571 488175 488825 490840 492691 495050 499566 500599 500717 504876 505064 508405 509403 509861 511291 511784 516645 517568 517598 520758 521993 524613 527865 528149 532649 535306 535547 535747 537970 539413 542739 542765 542789 544247 544398 545187 545629 546668 546722 546771 550292 550302 551572 553432 557487 563400 563411 577587 578803 581552 583691 587970 590307 591327 593847 597152 599533 602443 603673 603686 604746 606375 607023 609235 622835 625385 627701 631859 631908 633051 642469 642556 649211 650532 650847 653383 653595 654246 654591 661382 661970 662143 665926 670717 670820 688991 694028 694029 704010 723892 732003 732553 733589 739916 742670 750827 ] |
||||||||||||||||||||||||||||||
|
1.94 ms (1.00%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.92 ms (0.99%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"свингеры домашнее мжм"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (0.90%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"свингер домашн любительск мжм секс втро"
]
|
||||||||||||||||||||||||||||||
|
1.43 ms (0.74%) |
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.