Query Metrics
7
Database Queries
7
Different statements
157.95 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
127.90 ms (80.97%) |
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 130105 282010 341675 383987 393590 396581 405891 408601 409886 412189 413944 413950 416351 416365 416975 416992 419123 419358 420139 420768 420925 424523 425332 425709 429762 429805 430504 433747 443094 443476 443651 443661 443991 448987 449933 451620 452139 452606 460099 464359 465025 465649 468628 472286 477391 477470 478608 483536 486788 487150 495397 496551 496900 502703 502890 508547 510284 512452 516045 516776 517612 519107 519108 522130 522871 523561 527888 528886 531540 532984 533353 533364 535358 536631 542975 543234 543877 544474 554472 558447 565102 565460 578488 582800 583478 583923 593238 593886 596616 599852 603539 603605 605663 611571 615711 616617 621962 632692 636292 637103 637145 639731 639742 641986 642775 644961 648838 648889 659283 662048 666872 668528 696203 710794 721617 724271 760794 815697 815735 827915 ] |
||||||||||||||||||||||||||||||
|
18.76 ms (11.88%) |
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 724271 396581 578488 827915 533353 558447 443094 408601 413950 425332 449933 424523 393590 341675 405891 409886 416365 477391 472286 519107 583923 593238 425709 452139 130105 443661 433747 416351 815735 531540 532984 544474 543877 648838 668528 605663 616617 603539 637145 639742 760794 416992 419358 443651 527888 496900 383987 443991 644961 483536 486788 460099 512452 519108 496551 510284 522130 528886 533364 535358 536631 477470 542975 554472 543234 648889 696203 593886 611571 637103 599852 636292 632692 443476 465649 468628 430504 413944 416975 420768 429762 451620 517612 516045 516776 464359 565460 583478 666872 565102 603605 639731 487150 412189 420139 448987 465025 478608 502703 502890 582800 721617 659283 621962 641986 642775 429805 419123 815697 662048 615711 452606 508547 710794 596616 420925 522871 523561 282010 495397 ] |
||||||||||||||||||||||||||||||
|
3.90 ms (2.47%) |
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 130105 282010 341675 383987 393590 396581 405891 408601 409886 412189 413944 413950 416351 416365 416975 416992 419123 419358 420139 420768 420925 424523 425332 425709 429762 429805 430504 433747 443094 443476 443651 443661 443991 448987 449933 451620 452139 452606 460099 464359 465025 465649 468628 472286 477391 477470 478608 483536 486788 487150 495397 496551 496900 502703 502890 508547 510284 512452 516045 516776 517612 519107 519108 522130 522871 523561 527888 528886 531540 532984 533353 533364 535358 536631 542975 543234 543877 544474 554472 558447 565102 565460 578488 582800 583478 583923 593238 593886 596616 599852 603539 603605 605663 611571 615711 616617 621962 632692 636292 637103 637145 639731 639742 641986 642775 644961 648838 648889 659283 662048 666872 668528 696203 710794 721617 724271 760794 815697 815735 827915 ] |
||||||||||||||||||||||||||||||
|
2.02 ms (1.28%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс втро bbc"
]
|
||||||||||||||||||||||||||||||
|
1.91 ms (1.21%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.80 ms (1.14%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"threesome bbc"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (1.05%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс втро bbc"
]
|
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.