Query Metrics
7
Database Queries
7
Different statements
151.96 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
128.42 ms (84.51%) |
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 388976 455361 460857 477702 478329 480083 492016 492667 501322 502716 512596 513330 513789 513804 521318 523979 529683 530395 531377 535847 536046 536219 538060 547572 554147 579319 583165 595716 603919 607098 612905 617599 619979 621394 625699 631605 637309 642996 649588 653051 656167 662144 662383 664472 672822 673874 676528 679049 679662 679909 681388 681490 682954 686322 687355 689085 692095 692096 692733 693753 693788 697217 698259 700920 701360 706704 707452 709434 711326 714079 714122 714126 714382 716681 717137 717145 718703 720195 720791 721576 721903 723469 726229 726918 729641 729843 732991 733409 733518 734330 737231 737425 739551 739899 741796 742195 742657 743354 744791 745914 747375 753744 756849 758724 761527 762339 762659 771281 791790 794168 799387 799832 801018 805269 810732 813961 815751 824164 825492 827282 ] |
||||||||||||||||||||||||||||||
|
13.78 ms (9.07%) |
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 529683 513330 513804 531377 538060 530395 492667 554147 692095 714382 720791 721576 682954 687355 689085 697217 714126 649588 653051 656167 679049 681388 692096 700920 706704 707452 709434 583165 595716 619979 607098 612905 617599 631605 637309 625699 642996 801018 805269 810732 729641 734330 737231 742195 756849 771281 794168 799832 732991 743354 744791 761527 762659 726229 733409 733518 742657 753744 758724 729843 741796 747375 762339 726918 737425 739551 745914 603919 711326 714122 716681 717137 717145 720195 791790 799387 455361 388976 662144 662383 672822 621394 739899 714079 477702 825492 827282 815751 824164 813961 478329 492016 501322 512596 513789 523979 535847 536046 502716 521318 536219 460857 480083 579319 547572 664472 673874 676528 679909 681490 692733 693788 698259 723469 679662 686322 693753 701360 718703 721903 ] |
||||||||||||||||||||||||||||||
|
2.79 ms (1.84%) |
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 388976 455361 460857 477702 478329 480083 492016 492667 501322 502716 512596 513330 513789 513804 521318 523979 529683 530395 531377 535847 536046 536219 538060 547572 554147 579319 583165 595716 603919 607098 612905 617599 619979 621394 625699 631605 637309 642996 649588 653051 656167 662144 662383 664472 672822 673874 676528 679049 679662 679909 681388 681490 682954 686322 687355 689085 692095 692096 692733 693753 693788 697217 698259 700920 701360 706704 707452 709434 711326 714079 714122 714126 714382 716681 717137 717145 718703 720195 720791 721576 721903 723469 726229 726918 729641 729843 732991 733409 733518 734330 737231 737425 739551 739899 741796 742195 742657 743354 744791 745914 747375 753744 756849 758724 761527 762339 762659 771281 791790 794168 799387 799832 801018 805269 810732 813961 815751 824164 825492 827282 ] |
||||||||||||||||||||||||||||||
|
2.00 ms (1.31%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"orgasm on cock"
]
|
||||||||||||||||||||||||||||||
|
1.90 ms (1.25%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"orgasm cock"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (1.06%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.46 ms (0.96%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"orgasm cock"
]
|
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.