Query Metrics
7
Database Queries
7
Different statements
177.25 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
151.14 ms (85.27%) |
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 198001 385009 398972 401215 404116 407616 413106 423711 423958 428955 437092 441315 445638 450845 452236 453249 455591 456317 456509 459648 463771 465138 470979 471182 474575 477227 478633 483902 486175 494540 499661 502877 503447 504017 508803 509958 511668 513017 514031 514073 517436 518014 526505 527818 542043 545001 550125 554248 556751 560046 563345 564191 574050 577805 578588 579823 584284 589820 598433 599667 599789 607669 611259 612073 613912 619856 620817 626212 629468 629500 629844 630486 648266 659192 659401 665465 665621 666967 672857 678992 679652 685509 686585 689056 692531 701237 701904 703525 712542 715175 717850 719443 725448 729626 739675 740586 743479 744197 745394 750601 752913 759013 760079 760117 768884 776217 779961 784654 785674 793492 799161 801569 802208 806995 807384 811068 811238 813136 818154 824371 ] |
||||||||||||||||||||||||||||||
|
16.85 ms (9.51%) |
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 752913 768884 750601 784654 793492 477227 508803 760117 703525 517436 478633 450845 579823 659401 719443 550125 802208 811238 760079 743479 744197 813136 407616 465138 437092 513017 441315 563345 542043 672857 689056 712542 659192 679652 686585 692531 701904 626212 629468 598433 619856 630486 599667 620817 589820 779961 785674 725448 759013 739675 715175 514031 385009 423711 452236 518014 564191 717850 665465 666967 678992 545001 554248 556751 612073 745394 629500 470979 471182 198001 445638 486175 499661 401215 404116 818154 456509 459648 453249 455591 494540 509958 511668 527818 574050 578588 577805 584284 665621 685509 648266 701237 613912 599789 607669 611259 629844 801569 806995 807384 776217 799161 729626 740586 811068 428955 474575 398972 526505 502877 423958 413106 824371 463771 483902 456317 503447 504017 514073 560046 ] |
||||||||||||||||||||||||||||||
|
2.37 ms (1.34%) |
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 198001 385009 398972 401215 404116 407616 413106 423711 423958 428955 437092 441315 445638 450845 452236 453249 455591 456317 456509 459648 463771 465138 470979 471182 474575 477227 478633 483902 486175 494540 499661 502877 503447 504017 508803 509958 511668 513017 514031 514073 517436 518014 526505 527818 542043 545001 550125 554248 556751 560046 563345 564191 574050 577805 578588 579823 584284 589820 598433 599667 599789 607669 611259 612073 613912 619856 620817 626212 629468 629500 629844 630486 648266 659192 659401 665465 665621 666967 672857 678992 679652 685509 686585 689056 692531 701237 701904 703525 712542 715175 717850 719443 725448 729626 739675 740586 743479 744197 745394 750601 752913 759013 760079 760117 768884 776217 779961 784654 785674 793492 799161 801569 802208 806995 807384 811068 811238 813136 818154 824371 ] |
||||||||||||||||||||||||||||||
|
2.03 ms (1.15%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big masturbating"
]
|
||||||||||||||||||||||||||||||
|
1.89 ms (1.07%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.56 ms (0.88%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие masturbating"
]
|
||||||||||||||||||||||||||||||
|
1.41 ms (0.79%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большие masturbating"
]
|
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.