Query Metrics
7
Database Queries
7
Different statements
188.15 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
167.36 ms (88.95%) |
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 399000 474588 493796 531332 546409 549550 554697 557462 562577 582842 593223 636955 654918 656238 656812 659960 668091 691405 703929 707895 707928 712141 715014 715051 715877 717664 719318 720067 721971 722160 722447 724021 726217 726888 726989 727578 728321 728675 729285 729295 731088 731552 732369 733284 734990 736921 737643 739320 740726 742470 742715 747633 749330 749336 750141 750155 757263 758461 758830 760921 761195 761679 761719 761728 765101 765109 765345 765364 765548 765589 765789 766173 766803 766883 767061 767081 773419 773686 776018 777036 779730 781049 781057 781366 786094 786752 786869 787563 787714 787883 788351 788621 788782 788786 788985 789595 790548 791046 792671 794765 797063 798688 800349 800469 801214 803699 803920 804888 804893 804900 805495 810308 810314 812905 819403 826265 827609 827632 828553 ] |
||||||||||||||||||||||||||||||
|
11.62 ms (6.17%) |
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 729285 765101 765109 766173 765067 773686 728675 736921 749336 765789 781057 788985 790548 791046 797063 803920 810308 703929 593223 474588 654918 656238 668091 707928 761195 786869 788782 717664 720067 750141 767061 758461 731552 715014 766803 707895 749330 728321 766883 715877 827632 787714 810314 773419 691405 493796 722160 719318 722447 549550 554697 562577 636955 779730 787883 788351 803699 776018 777036 781366 792671 724021 726888 729295 731088 732369 737643 740726 765345 786752 788621 789595 794765 804888 804893 812905 757263 758830 761679 726217 742715 765589 733284 739320 760921 761719 761728 765364 767081 726989 727578 734990 742470 747633 750155 712141 721971 786094 788786 800349 804900 798688 800469 819403 826265 827609 828553 715051 781049 787563 805495 765548 801214 399000 531332 546409 582842 557462 656812 659960 ] |
||||||||||||||||||||||||||||||
|
2.47 ms (1.31%) |
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 399000 474588 493796 531332 546409 549550 554697 557462 562577 582842 593223 636955 654918 656238 656812 659960 668091 691405 703929 707895 707928 712141 715014 715051 715877 717664 719318 720067 721971 722160 722447 724021 726217 726888 726989 727578 728321 728675 729285 729295 731088 731552 732369 733284 734990 736921 737643 739320 740726 742470 742715 747633 749330 749336 750141 750155 757263 758461 758830 760921 761195 761679 761719 761728 765101 765109 765345 765364 765548 765589 765789 766173 766803 766883 767061 767081 773419 773686 776018 777036 779730 781049 781057 781366 786094 786752 786869 787563 787714 787883 788351 788621 788782 788786 788985 789595 790548 791046 792671 794765 797063 798688 800349 800469 801214 803699 803920 804888 804893 804900 805495 810308 810314 812905 819403 826265 827609 827632 828553 ] |
||||||||||||||||||||||||||||||
|
1.79 ms (0.95%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.79 ms (0.95%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"webcam amateur anal"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (0.94%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"вебкамер любительск анал"
]
|
||||||||||||||||||||||||||||||
|
1.34 ms (0.71%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.