Query Metrics
7
Database Queries
7
Different statements
151.02 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
130.19 ms (86.21%) |
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 388696 417304 426167 436047 436938 447534 451029 452896 454842 462369 462605 465001 476701 483777 498112 502894 507445 509643 514047 521999 524788 528929 533185 533648 547235 580890 582595 591427 596675 597031 597493 597997 598768 613861 613962 615823 619123 621457 621796 622777 624426 625467 626866 628515 629612 633120 664444 666439 668141 675582 691385 691395 699494 699518 701875 709764 714261 716318 719255 720434 720915 722990 725713 728490 729413 730645 731881 733708 736289 736893 738296 738310 738328 738338 738339 738365 739585 739896 741878 742224 745126 745354 745473 747739 748419 749909 752116 757112 760568 761027 761394 762671 762706 764647 765877 767454 775903 775982 776244 776273 778220 778254 779443 781608 783804 787888 789158 791989 792693 795665 799544 805946 808535 811330 816247 817661 818678 819797 819858 ] |
||||||||||||||||||||||||||||||
|
11.82 ms (7.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 791989 452896 388696 591427 447534 597493 597997 739896 719255 598768 720915 716318 597031 462369 778220 747739 742224 776244 767454 714261 691385 691395 613962 778254 738310 729413 720434 633120 524788 699518 757112 760568 619123 462605 596675 709764 666439 775903 745354 736893 533648 699494 808535 733708 582595 521999 528929 533185 580890 668141 701875 625467 776273 736289 745473 749909 761027 476701 454842 664444 451029 426167 765877 465001 547235 626866 624426 745126 762671 775982 509643 502894 819797 789158 761394 739585 799544 738365 621457 622777 628515 741878 615823 738328 805946 730645 621796 436047 762706 738339 785992 748419 781608 731881 514047 498112 436938 816247 507445 613861 629612 783804 792693 811330 752116 738338 722990 795665 818678 728490 787888 483777 417304 675582 725713 738296 764647 779443 817661 819858 ] |
||||||||||||||||||||||||||||||
|
2.50 ms (1.66%) |
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 388696 417304 426167 436047 436938 447534 451029 452896 454842 462369 462605 465001 476701 483777 498112 502894 507445 509643 514047 521999 524788 528929 533185 533648 547235 580890 582595 591427 596675 597031 597493 597997 598768 613861 613962 615823 619123 621457 621796 622777 624426 625467 626866 628515 629612 633120 664444 666439 668141 675582 691385 691395 699494 699518 701875 709764 714261 716318 719255 720434 720915 722990 725713 728490 729413 730645 731881 733708 736289 736893 738296 738310 738328 738338 738339 738365 739585 739896 741878 742224 745126 745354 745473 747739 748419 749909 752116 757112 760568 761027 761394 762671 762706 764647 765877 767454 775903 775982 776244 776273 778220 778254 779443 781608 783804 787888 789158 791989 792693 795665 799544 805946 808535 811330 816247 817661 818678 819797 819858 ] |
||||||||||||||||||||||||||||||
|
1.70 ms (1.13%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"огромные cock русск"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (1.09%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"огромные cock русск"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (1.05%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"huge cock russian"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (1.04%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.