Query Metrics
7
Database Queries
7
Different statements
155.42 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
131.63 ms (84.69%) |
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 282558 384963 419522 419529 422729 426711 428415 429810 443130 443407 443591 443799 443926 447105 447750 457789 466075 466223 469920 473788 474635 475017 475428 476248 476921 478781 479149 481289 484568 485940 501198 505446 506216 510420 510427 510641 515858 516683 518059 521907 521939 522568 526735 533548 540270 541110 548754 551175 552216 555688 557942 557945 567075 570627 574235 575176 576056 576404 598176 598557 598783 603536 604142 611723 616716 620563 622349 628181 640939 651934 651944 652617 653209 654594 654824 654846 659539 661262 676444 676973 678568 678579 678954 679058 679090 696748 712441 717310 720799 720835 721202 721367 722827 722871 723510 726892 730210 740161 741958 742046 744328 745723 747008 751646 759548 785337 785963 790397 792491 800316 807462 809651 812364 814330 818582 821837 821839 821846 821856 825299 ] |
||||||||||||||||||||||||||||||
|
13.06 ms (8.40%) |
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 792491 552216 814330 723510 818582 551175 659539 676444 679090 678568 721202 611723 730210 742046 721367 384963 640939 722871 522568 443407 678579 679058 654824 720799 720835 598783 622349 628181 598557 785963 741958 751646 759548 696748 557945 510427 555688 604142 469920 474635 481289 821837 506216 652617 654594 651934 717310 651944 653209 570627 620563 807462 809651 740161 745723 521939 510641 676973 515858 521907 501198 541110 447750 476248 282558 443926 825299 576056 484568 557942 479149 485940 598176 821839 678954 744328 747008 800316 443130 447105 540270 790397 428415 429810 478781 510420 518059 526735 575176 576404 548754 567075 476921 574235 603536 812364 785337 722827 475017 426711 516683 419529 466075 443591 419522 443799 466223 475428 505446 661262 616716 457789 821856 821846 533548 654846 712441 726892 422729 473788 ] |
||||||||||||||||||||||||||||||
|
3.09 ms (1.99%) |
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 282558 384963 419522 419529 422729 426711 428415 429810 443130 443407 443591 443799 443926 447105 447750 457789 466075 466223 469920 473788 474635 475017 475428 476248 476921 478781 479149 481289 484568 485940 501198 505446 506216 510420 510427 510641 515858 516683 518059 521907 521939 522568 526735 533548 540270 541110 548754 551175 552216 555688 557942 557945 567075 570627 574235 575176 576056 576404 598176 598557 598783 603536 604142 611723 616716 620563 622349 628181 640939 651934 651944 652617 653209 654594 654824 654846 659539 661262 676444 676973 678568 678579 678954 679058 679090 696748 712441 717310 720799 720835 721202 721367 722827 722871 723510 726892 730210 740161 741958 742046 744328 745723 747008 751646 759548 785337 785963 790397 792491 800316 807462 809651 812364 814330 818582 821837 821839 821846 821856 825299 ] |
||||||||||||||||||||||||||||||
|
2.25 ms (1.45%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"русские молодые втрое…"
]
|
||||||||||||||||||||||||||||||
|
2.17 ms (1.40%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск молодые секс втро"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (1.06%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"русск молодые секс втро"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (1.01%) |
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.