Query Metrics
7
Database Queries
7
Different statements
149.60 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
126.66 ms (84.67%) |
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 10006 387270 387274 395849 395959 395975 396251 397329 400689 401037 401077 401129 401142 401498 401993 403289 405082 411175 415256 422593 422924 422987 423260 424622 447675 451595 468085 495148 508191 510689 533783 548300 550236 561007 569677 571211 571229 575723 596161 597960 598508 599946 600204 601877 604227 605325 605610 609052 609878 612925 626535 628390 637436 640797 641682 646824 649191 651161 655071 667904 670103 671640 675807 678954 680156 683955 694219 694260 696977 697298 699626 701682 703100 705320 709688 709781 715707 720306 720816 721744 722126 722645 723931 728384 736911 740704 744276 745003 749116 749919 750521 752685 753890 755696 757367 757643 758198 759543 759553 760004 767181 770981 790972 792789 796970 797729 800000 804915 813526 815740 817244 818278 818828 819311 819573 821369 821725 822142 823359 ] |
||||||||||||||||||||||||||||||
|
13.79 ms (9.22%) |
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 817244 823359 721744 612925 759553 715707 401037 508191 649191 701682 597960 750521 758198 628390 569677 397329 604227 819311 818828 605610 790972 755696 745003 770981 495148 815740 821725 703100 694260 720816 600204 800000 723931 722126 797729 387274 752685 640797 561007 548300 760004 447675 401993 533783 796970 424622 813526 400689 396251 415256 401142 709781 655071 609878 605325 609052 403289 821369 675807 598508 804915 767181 411175 395975 422924 550236 667904 678954 709688 683955 395959 510689 405082 680156 451595 819573 818278 575723 699626 671640 670103 720306 626535 740704 757367 792789 728384 749919 736911 401077 401129 423260 822142 696977 697298 694219 718662 744276 749116 753890 759543 757643 401498 395849 10006 387270 422987 422593 468085 571211 571229 705320 646824 651161 722645 599946 641682 637436 596161 601877 ] |
||||||||||||||||||||||||||||||
|
2.16 ms (1.44%) |
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 10006 387270 387274 395849 395959 395975 396251 397329 400689 401037 401077 401129 401142 401498 401993 403289 405082 411175 415256 422593 422924 422987 423260 424622 447675 451595 468085 495148 508191 510689 533783 548300 550236 561007 569677 571211 571229 575723 596161 597960 598508 599946 600204 601877 604227 605325 605610 609052 609878 612925 626535 628390 637436 640797 641682 646824 649191 651161 655071 667904 670103 671640 675807 678954 680156 683955 694219 694260 696977 697298 699626 701682 703100 705320 709688 709781 715707 720306 720816 721744 722126 722645 723931 728384 736911 740704 744276 745003 749116 749919 750521 752685 753890 755696 757367 757643 758198 759543 759553 760004 767181 770981 790972 792789 796970 797729 800000 804915 813526 815740 817244 818278 818828 819311 819573 821369 821725 822142 823359 ] |
||||||||||||||||||||||||||||||
|
2.01 ms (1.34%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"young girl anal"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (1.20%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"young девушк анал"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (1.07%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.59 ms (1.06%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"young девушк анал"
]
|
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.