Query Metrics
7
Database Queries
7
Different statements
194.04 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
169.52 ms (87.37%) |
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 96341 114153 263259 396415 399143 402628 410851 412092 415220 422134 434382 435131 435171 439117 441233 445718 448327 448758 449300 449992 452720 453020 453332 454531 455079 456219 459211 459745 460323 464120 467725 472547 475140 480279 481961 489324 490135 492726 498630 502776 504474 507193 510198 511073 513330 517745 517798 518643 530479 532816 533276 533389 536538 539370 541757 541760 545451 545605 555390 561495 565175 567737 575445 584460 584748 586339 588070 595028 604053 604062 605742 634157 634472 635258 636414 639645 639760 639818 647895 648235 653520 666863 666888 685511 693809 695882 708472 713189 725649 738496 745964 756992 765224 766234 766505 766556 773416 778892 782041 783928 784720 792223 800082 800884 801041 801084 803672 805336 805698 807011 812336 814114 814178 814202 814883 815847 815969 817901 819228 827901 ] |
||||||||||||||||||||||||||||||
|
15.13 ms (7.80%) |
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 765224 114153 434382 441233 561495 435131 635258 575445 782041 725649 801084 805698 766234 801041 805336 584748 532816 263259 410851 815969 815847 456219 460323 453020 459745 504474 545451 653520 595028 634157 812336 807011 773416 738496 800884 480279 435171 472547 415220 475140 448758 492726 498630 517798 502776 539370 533276 513330 695882 783928 713189 817901 827901 588070 402628 814178 449300 489324 449992 565175 541760 459211 445718 481961 511073 490135 399143 452720 518643 541757 586339 636414 605742 792223 530479 510198 648235 666863 634472 604062 536538 639818 639760 584460 455079 96341 814883 454531 453332 439117 448327 467725 412092 422134 517745 507193 685511 396415 814114 819228 533389 666888 693809 567737 639645 778892 800082 756992 784720 766505 647895 814202 745964 555390 604053 803672 545605 464120 708472 766556 ] |
||||||||||||||||||||||||||||||
|
3.20 ms (1.65%) |
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 96341 114153 263259 396415 399143 402628 410851 412092 415220 422134 434382 435131 435171 439117 441233 445718 448327 448758 449300 449992 452720 453020 453332 454531 455079 456219 459211 459745 460323 464120 467725 472547 475140 480279 481961 489324 490135 492726 498630 502776 504474 507193 510198 511073 513330 517745 517798 518643 530479 532816 533276 533389 536538 539370 541757 541760 545451 545605 555390 561495 565175 567737 575445 584460 584748 586339 588070 595028 604053 604062 605742 634157 634472 635258 636414 639645 639760 639818 647895 648235 653520 666863 666888 685511 693809 695882 708472 713189 725649 738496 745964 756992 765224 766234 766505 766556 773416 778892 782041 783928 784720 792223 800082 800884 801041 801084 803672 805336 805698 807011 812336 814114 814178 814202 814883 815847 815969 817901 819228 827901 ] |
||||||||||||||||||||||||||||||
|
1.70 ms (0.88%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"squirt ass"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (0.86%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.61 ms (0.83%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"сквирт оргазм жоп"
]
|
||||||||||||||||||||||||||||||
|
1.21 ms (0.62%) |
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.