Query Metrics
7
Database Queries
7
Different statements
159.16 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
136.05 ms (85.48%) |
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 358566 394420 399585 401077 401129 401142 403289 421890 473733 473909 485095 496073 498228 500904 508191 529035 534109 536674 548300 550436 550443 561007 565169 574089 574244 575723 576020 577362 586628 596563 597052 597960 598505 601922 605122 605325 605339 609052 609812 609878 616994 626535 626537 626539 627730 649191 655071 660055 663425 665694 668524 670103 671630 671640 671832 673371 679381 679457 680251 682496 683382 683564 688660 695215 695243 698051 698293 699626 699691 701682 709781 712723 713834 716032 717297 717610 717895 719137 719703 720306 720384 722050 724509 728309 728384 729962 734692 736911 740704 744698 749684 749911 749919 750521 752685 755368 757367 760004 761083 770389 773841 788958 792789 797247 797905 798990 799292 800937 804751 804972 811624 813549 814803 816485 817898 818278 819573 819586 821068 823493 ] |
||||||||||||||||||||||||||||||
|
12.57 ms (7.90%) |
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 565169 605122 601922 598505 536674 574089 680251 713834 798990 586628 616994 716032 609812 473909 399585 401142 819573 821068 818278 496073 485095 575723 699626 709781 655071 671640 717895 668524 670103 717610 720306 609878 605325 605339 626539 626535 609052 788958 799292 800937 811624 734692 740704 757367 792789 797247 724509 728384 752685 755368 773841 749911 749919 770389 736911 749684 698293 722050 394420 401077 401129 403289 473733 534109 529035 550443 421890 577362 574244 627730 508191 498228 561007 649191 701682 548300 597960 750521 760004 358566 817898 813549 819586 814803 816485 823493 663425 665694 671630 671832 679381 688660 699691 719703 660055 683382 683564 717297 719137 673371 682496 695215 695243 698051 712723 720384 597052 596563 626537 804751 729962 797905 804972 728309 744698 761083 576020 679457 500904 550436 ] |
||||||||||||||||||||||||||||||
|
2.75 ms (1.73%) |
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 358566 394420 399585 401077 401129 401142 403289 421890 473733 473909 485095 496073 498228 500904 508191 529035 534109 536674 548300 550436 550443 561007 565169 574089 574244 575723 576020 577362 586628 596563 597052 597960 598505 601922 605122 605325 605339 609052 609812 609878 616994 626535 626537 626539 627730 649191 655071 660055 663425 665694 668524 670103 671630 671640 671832 673371 679381 679457 680251 682496 683382 683564 688660 695215 695243 698051 698293 699626 699691 701682 709781 712723 713834 716032 717297 717610 717895 719137 719703 720306 720384 722050 724509 728309 728384 729962 734692 736911 740704 744698 749684 749911 749919 750521 752685 755368 757367 760004 761083 770389 773841 788958 792789 797247 797905 798990 799292 800937 804751 804972 811624 813549 814803 816485 817898 818278 819573 819586 821068 823493 ] |
||||||||||||||||||||||||||||||
|
2.59 ms (1.63%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"old man anal"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (1.12%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"old мужчин анал"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (1.10%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"old мужчин анал"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (1.05%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.