Query Metrics
7
Database Queries
7
Different statements
214.27 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
186.96 ms (87.25%) |
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 37245 75852 383809 386304 386596 388690 390024 396526 396527 396609 415883 418538 420120 420192 421250 429523 432559 432562 437123 441185 445739 446167 446976 448817 449123 449869 451875 453473 454925 457160 457163 457166 458013 460328 460706 461747 461765 464188 464453 465649 467568 468009 476120 476143 478033 480439 480929 483094 484547 492064 492126 494269 494345 495014 495418 496033 496270 496302 499174 499817 501487 503855 508856 510284 510394 511810 514798 514939 518733 520213 520405 523091 525303 528035 529256 529286 529360 530483 531560 532441 536925 537901 543808 546861 548577 549992 550774 550960 556533 558447 562894 564776 565102 571016 573373 574559 576346 578500 580151 583593 584105 584708 589345 595764 596643 603252 603724 603813 603907 604451 605105 622682 624930 643112 646001 676463 678159 681709 811040 ] |
||||||||||||||||||||||||||||||
|
18.40 ms (8.59%) |
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 523091 480929 578500 383809 37245 460328 467568 458013 461747 520213 583593 604451 386596 432562 514939 496302 499174 518733 492126 386304 622682 529286 573373 445739 451875 457166 503855 75852 388690 432559 528035 529256 396609 429523 476143 514798 468009 484547 595764 596643 478033 525303 508856 511810 448817 464453 494269 396527 390024 454925 530483 537901 441185 453473 520405 480439 681709 603724 483094 457163 476120 510394 464188 574559 549992 565102 576346 465649 461765 495014 437123 495418 532441 548577 564776 676463 556533 589345 811040 396526 513476 449869 531560 499817 418538 529360 510284 643112 550774 603252 562894 584708 420192 460706 446167 624930 543808 558447 646001 457160 678159 494345 571016 546861 496270 420120 550960 501487 605105 603813 580151 584105 492064 421250 446976 449123 415883 536925 603907 496033 ] |
||||||||||||||||||||||||||||||
|
2.32 ms (1.09%) |
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 37245 75852 383809 386304 386596 388690 390024 396526 396527 396609 415883 418538 420120 420192 421250 429523 432559 432562 437123 441185 445739 446167 446976 448817 449123 449869 451875 453473 454925 457160 457163 457166 458013 460328 460706 461747 461765 464188 464453 465649 467568 468009 476120 476143 478033 480439 480929 483094 484547 492064 492126 494269 494345 495014 495418 496033 496270 496302 499174 499817 501487 503855 508856 510284 510394 511810 514798 514939 518733 520213 520405 523091 525303 528035 529256 529286 529360 530483 531560 532441 536925 537901 543808 546861 548577 549992 550774 550960 556533 558447 562894 564776 565102 571016 573373 574559 576346 578500 580151 583593 584105 584708 589345 595764 596643 603252 603724 603813 603907 604451 605105 622682 624930 643112 646001 676463 678159 681709 811040 ] |
||||||||||||||||||||||||||||||
|
1.77 ms (0.83%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"black boy girls"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (0.77%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.60 ms (0.75%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"black парен девушк"
]
|
||||||||||||||||||||||||||||||
|
1.56 ms (0.73%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"black парен девушк"
]
|
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.