Query Metrics
7
Database Queries
7
Different statements
194.48 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
167.76 ms (86.26%) |
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 3320 6892 98749 126104 161528 233547 338487 339096 365861 382958 384138 387445 395392 395955 396919 398043 412081 427261 484129 485591 506467 521754 530930 533345 535693 536063 536305 543126 544287 545085 545091 545417 545979 547946 554816 563910 563913 566413 566434 574399 575667 577112 577209 579305 593884 596174 598453 598852 606539 619447 630578 634827 635791 635831 635871 635877 645050 645832 648912 649086 649250 649621 652251 653347 653600 657254 659259 661238 661447 662019 663939 664481 665350 668161 670487 686024 690049 690321 693863 694228 694310 700775 703052 710426 717372 721813 722103 723433 730718 730937 746421 748363 755134 756240 768356 770121 771480 775945 778160 779794 784877 786062 790823 795133 803064 807700 807844 808121 809655 809781 814586 816313 819180 820935 821991 822482 825998 826621 827898 ] |
||||||||||||||||||||||||||||||
|
16.98 ms (8.73%) |
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 748363 730937 755134 703052 365861 395392 427261 484129 412081 485591 659259 795133 746421 566413 598852 506467 814586 536063 575667 663939 635831 126104 339096 338487 98749 6892 822482 825998 816313 820935 824131 827898 530930 535693 544287 547946 563910 563913 579305 545085 554816 566434 543126 545979 661238 661447 664481 670487 690321 645050 645832 648912 649086 649250 653347 653600 657254 665350 690049 717372 649621 662019 668161 686024 694228 694310 700775 721813 545091 598453 619447 635791 635871 593884 596174 606539 635877 779794 784877 786062 807700 775945 778160 803064 808121 809781 730718 756240 768356 770121 771480 630578 634827 710426 722103 723433 790823 807844 809655 395955 233547 396919 577209 387445 382958 384138 161528 3320 398043 826621 821991 819180 536305 533345 521754 574399 577112 545417 652251 693863 ] |
||||||||||||||||||||||||||||||
|
3.01 ms (1.55%) |
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 3320 6892 98749 126104 161528 233547 338487 339096 365861 382958 384138 387445 395392 395955 396919 398043 412081 427261 484129 485591 506467 521754 530930 533345 535693 536063 536305 543126 544287 545085 545091 545417 545979 547946 554816 563910 563913 566413 566434 574399 575667 577112 577209 579305 593884 596174 598453 598852 606539 619447 630578 634827 635791 635831 635871 635877 645050 645832 648912 649086 649250 649621 652251 653347 653600 657254 659259 661238 661447 662019 663939 664481 665350 668161 670487 686024 690049 690321 693863 694228 694310 700775 703052 710426 717372 721813 722103 723433 730718 730937 746421 748363 755134 756240 768356 770121 771480 775945 778160 779794 784877 786062 790823 795133 803064 807700 807844 808121 809655 809781 814586 816313 819180 820935 821991 822482 825998 826621 827898 ] |
||||||||||||||||||||||||||||||
|
2.10 ms (1.08%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"threesome sex"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (0.88%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.49 ms (0.76%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс втро секс"
]
|
||||||||||||||||||||||||||||||
|
1.44 ms (0.74%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.