Query Metrics
7
Database Queries
7
Different statements
193.35 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
166.79 ms (86.27%) |
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 266633 398527 400800 405966 417612 417854 420078 423867 428373 437575 456062 459618 459993 462311 464512 467942 470697 480251 480697 482003 489254 496586 502852 506460 512449 512619 514205 517375 517835 520109 525571 526724 530161 539634 545233 546560 546570 546990 551886 553677 555089 556551 558778 562061 563778 566911 571795 574151 575525 577243 578020 579198 585257 588830 592062 593014 593249 596343 599820 600851 610134 620692 626449 627710 630821 634614 641463 642237 642249 653440 667928 670212 672846 682363 691306 704361 705339 715001 715779 717962 718758 718867 719211 725760 727034 727608 728912 731117 731225 736576 739642 739898 741006 742758 743422 743774 749566 749602 762541 764266 764603 765022 769257 778740 779316 779387 779686 781075 781516 786742 788883 789149 790650 791819 792300 793467 795954 795978 805361 809787 ] |
||||||||||||||||||||||||||||||
|
16.10 ms (8.33%) |
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 667928 462311 502852 551886 578020 546990 423867 546570 705339 718758 670212 715001 545233 630821 778740 779316 779686 781075 789149 790650 795954 795978 741006 762541 769257 786742 791819 793467 731117 736576 739642 765022 731225 743774 749566 728912 626449 715779 718867 788883 809787 610134 555089 566911 588830 417612 470697 489254 563778 620692 553677 717962 642237 727034 764266 642249 514205 428373 562061 459618 512619 496586 556551 574151 558778 682363 691306 653440 627710 641463 634614 417854 420078 456062 530161 506460 517835 579198 585257 593249 593014 596343 599820 672846 539634 577243 805361 779387 727608 520109 749602 405966 517375 464512 512449 575525 792300 742758 398527 725760 739898 764603 482003 743422 600851 592062 459993 480697 400800 467942 526724 525571 571795 437575 266633 480251 546560 704361 719211 781516 ] |
||||||||||||||||||||||||||||||
|
2.38 ms (1.23%) |
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 266633 398527 400800 405966 417612 417854 420078 423867 428373 437575 456062 459618 459993 462311 464512 467942 470697 480251 480697 482003 489254 496586 502852 506460 512449 512619 514205 517375 517835 520109 525571 526724 530161 539634 545233 546560 546570 546990 551886 553677 555089 556551 558778 562061 563778 566911 571795 574151 575525 577243 578020 579198 585257 588830 592062 593014 593249 596343 599820 600851 610134 620692 626449 627710 630821 634614 641463 642237 642249 653440 667928 670212 672846 682363 691306 704361 705339 715001 715779 717962 718758 718867 719211 725760 727034 727608 728912 731117 731225 736576 739642 739898 741006 742758 743422 743774 749566 749602 762541 764266 764603 765022 769257 778740 779316 779387 779686 781075 781516 786742 788883 789149 790650 791819 792300 793467 795954 795978 805361 809787 ] |
||||||||||||||||||||||||||||||
|
2.21 ms (1.14%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.05 ms (1.06%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"измена кончи в рот"
]
|
||||||||||||||||||||||||||||||
|
1.96 ms (1.01%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"жен сперм в рот"
]
|
||||||||||||||||||||||||||||||
|
1.86 ms (0.96%) |
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.