Query Metrics
7
Database Queries
7
Different statements
148.66 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
122.44 ms (82.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 282649 417839 423444 424932 424995 424996 425003 425079 426336 428154 428166 428783 432532 435174 436627 439274 441366 441442 443565 444067 444099 444836 445883 445967 446453 446914 449120 450585 453018 454929 455574 455787 455869 455875 457413 457687 457880 458713 459628 459865 459866 459872 464152 465792 465873 466981 470284 472147 472175 476333 478705 480960 484899 492136 496616 497413 497805 499771 502144 504735 504739 504906 507685 507785 517214 518231 518233 520415 521241 521537 521664 523578 524340 525591 532826 534494 538520 542021 551132 555851 557027 562637 566939 574049 575710 580177 582297 584498 584716 590076 590381 592180 604155 604330 604338 604368 604384 610808 616807 648144 695719 696128 703268 710032 717966 737848 745673 748981 750308 757370 766734 771055 773911 794307 794807 795212 810382 813566 816687 823819 ] |
||||||||||||||||||||||||||||||
|
16.24 ms (10.92%) |
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 745673 748981 282649 757370 750308 773911 710032 496616 423444 524340 424932 436627 737848 766734 459872 813566 823819 771055 703268 478705 470284 432532 472175 450585 810382 604338 794807 525591 459628 551132 459866 816687 604384 604330 532826 610808 604155 446914 457413 794307 443565 449120 555851 534494 424996 582297 465873 444067 428154 439274 484899 696128 428166 455787 465792 417839 507685 444099 458713 521241 648144 492136 455574 717966 520415 604368 435174 444836 455869 695719 425079 480960 446453 795212 464152 428783 453018 574049 504735 518233 523578 584498 445967 584716 455875 504906 575710 424995 441366 441442 459865 557027 566939 499771 457880 472147 580177 425003 426336 518231 590381 542021 616807 562637 457687 504739 497413 538520 454929 521664 476333 502144 590076 521537 466981 517214 592180 507785 445883 497805 ] |
||||||||||||||||||||||||||||||
|
2.93 ms (1.97%) |
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 282649 417839 423444 424932 424995 424996 425003 425079 426336 428154 428166 428783 432532 435174 436627 439274 441366 441442 443565 444067 444099 444836 445883 445967 446453 446914 449120 450585 453018 454929 455574 455787 455869 455875 457413 457687 457880 458713 459628 459865 459866 459872 464152 465792 465873 466981 470284 472147 472175 476333 478705 480960 484899 492136 496616 497413 497805 499771 502144 504735 504739 504906 507685 507785 517214 518231 518233 520415 521241 521537 521664 523578 524340 525591 532826 534494 538520 542021 551132 555851 557027 562637 566939 574049 575710 580177 582297 584498 584716 590076 590381 592180 604155 604330 604338 604368 604384 610808 616807 648144 695719 696128 703268 710032 717966 737848 745673 748981 750308 757370 766734 771055 773911 794307 794807 795212 810382 813566 816687 823819 ] |
||||||||||||||||||||||||||||||
|
2.04 ms (1.37%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.92 ms (1.29%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sister anal homemade"
]
|
||||||||||||||||||||||||||||||
|
1.89 ms (1.27%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"sister анал домашн любительск"
]
|
||||||||||||||||||||||||||||||
|
1.19 ms (0.80%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"sister анал домашн любительск"
]
|
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.