Query Metrics
7
Database Queries
7
Different statements
194.00 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
163.14 ms (84.09%) |
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 439798 454292 460857 526436 540139 540159 541207 542285 542412 542445 543652 546036 546049 550207 551912 552382 554859 555220 555395 559020 562048 562053 571248 577019 577543 580129 581053 583913 597763 610199 615634 626332 627131 629458 630254 631396 632750 632901 633823 637511 638147 644655 645700 649306 649440 650608 650919 651903 656523 662480 665328 666863 666901 666902 672313 678662 680159 681535 691381 695126 696865 698133 700011 701194 709712 710265 710471 716088 716672 724039 726434 727017 727042 727052 727556 732589 733085 733122 738564 738675 739561 741893 744280 746298 747069 751170 751360 751431 754184 754209 757211 757238 757246 758292 760446 762210 767218 767329 774666 778762 788127 790234 794019 797240 797250 798273 800504 807881 809925 810347 811785 811862 811882 811889 811907 811992 812279 814333 817878 817889 ] |
||||||||||||||||||||||||||||||
|
21.00 ms (10.82%) |
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 754184 760446 811907 724039 733122 738675 751360 727042 751431 758292 632901 637511 709712 774666 666901 695126 790234 460857 554859 562053 546036 650608 681535 656523 546049 615634 631396 778762 811882 811785 733085 746298 751170 727017 757238 762210 739561 627131 638147 701194 811862 811889 541207 583913 666863 666902 680159 817878 817889 542445 577019 649440 662480 716672 700011 716088 632750 626332 644655 794019 807881 797250 798273 757246 767218 767329 727556 757211 809925 543652 550207 698133 540139 540159 551912 552382 562048 650919 678662 696865 710265 672313 691381 555220 580129 597763 610199 630254 788127 812279 797240 800504 810347 811992 732589 741893 744280 738564 726434 727052 747069 754209 629458 633823 710471 439798 665328 526436 814333 454292 542412 555395 559020 581053 542285 577543 571248 645700 651903 649306 ] |
||||||||||||||||||||||||||||||
|
3.06 ms (1.58%) |
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 439798 454292 460857 526436 540139 540159 541207 542285 542412 542445 543652 546036 546049 550207 551912 552382 554859 555220 555395 559020 562048 562053 571248 577019 577543 580129 581053 583913 597763 610199 615634 626332 627131 629458 630254 631396 632750 632901 633823 637511 638147 644655 645700 649306 649440 650608 650919 651903 656523 662480 665328 666863 666901 666902 672313 678662 680159 681535 691381 695126 696865 698133 700011 701194 709712 710265 710471 716088 716672 724039 726434 727017 727042 727052 727556 732589 733085 733122 738564 738675 739561 741893 744280 746298 747069 751170 751360 751431 754184 754209 757211 757238 757246 758292 760446 762210 767218 767329 774666 778762 788127 790234 794019 797240 797250 798273 800504 807881 809925 810347 811785 811862 811882 811889 811907 811992 812279 814333 817878 817889 ] |
||||||||||||||||||||||||||||||
|
1.89 ms (0.97%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"писсинг shower"
]
|
||||||||||||||||||||||||||||||
|
1.87 ms (0.96%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"piss in shower"
]
|
||||||||||||||||||||||||||||||
|
1.55 ms (0.80%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.51 ms (0.78%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"писсинг shower"
]
|
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.