Query Metrics
7
Database Queries
7
Different statements
174.66 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
150.47 ms (86.15%) |
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 182895 233504 287436 386606 386728 392716 395377 396294 402085 403216 414220 418197 418469 422005 422336 433997 447094 447483 447496 448641 451048 453551 459602 459821 463120 463302 463460 468798 491379 492093 497127 499922 501043 501527 503787 508225 510535 512813 518505 523533 526151 531161 532971 534389 544475 544504 545511 548414 548421 552045 562497 563304 564139 564381 565730 572331 577706 581104 586513 586558 586739 587959 589392 592372 594784 595690 599108 604581 604850 605927 607157 619368 619556 620014 631603 645998 648424 652159 653801 654278 659352 660342 662826 669255 673852 681028 694387 700468 700682 713735 718996 720609 722050 728134 742033 750477 750729 753633 764044 771642 772124 777017 782582 784549 785349 786277 792892 796230 798067 806031 809898 812575 813268 814147 815096 816797 818638 825758 827299 ] |
||||||||||||||||||||||||||||||
|
13.48 ms (7.72%) |
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 700468 713735 700682 619556 772124 796230 433997 422005 422336 814147 825758 497127 531161 572331 648424 660342 673852 607157 599108 620014 586739 619368 782582 798067 806031 809898 764044 785349 742033 753633 750729 403216 501527 532971 534389 508225 595690 631603 792892 720609 722050 786277 396294 287436 818638 499922 463120 545511 652159 662826 653801 589392 592372 594784 604850 813268 463302 459821 510535 182895 395377 418469 827299 815096 816797 463460 503787 512813 501043 468798 544475 548421 577706 581104 548414 564139 570835 645998 681028 659352 694387 654278 669255 552045 562497 563304 564381 605927 587959 784549 812575 728134 750477 771642 777017 448641 386728 418197 459602 386606 491379 518505 492093 523533 526151 451048 718996 447094 392716 453551 544504 565730 586513 604581 586558 402085 447496 233504 414220 447483 ] |
||||||||||||||||||||||||||||||
|
3.34 ms (1.91%) |
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 182895 233504 287436 386606 386728 392716 395377 396294 402085 403216 414220 418197 418469 422005 422336 433997 447094 447483 447496 448641 451048 453551 459602 459821 463120 463302 463460 468798 491379 492093 497127 499922 501043 501527 503787 508225 510535 512813 518505 523533 526151 531161 532971 534389 544475 544504 545511 548414 548421 552045 562497 563304 564139 564381 565730 572331 577706 581104 586513 586558 586739 587959 589392 592372 594784 595690 599108 604581 604850 605927 607157 619368 619556 620014 631603 645998 648424 652159 653801 654278 659352 660342 662826 669255 673852 681028 694387 700468 700682 713735 718996 720609 722050 728134 742033 750477 750729 753633 764044 771642 772124 777017 782582 784549 785349 786277 792892 796230 798067 806031 809898 812575 813268 814147 815096 816797 818638 825758 827299 ] |
||||||||||||||||||||||||||||||
|
2.16 ms (1.24%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"pussy fucked"
]
|
||||||||||||||||||||||||||||||
|
1.90 ms (1.09%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"pussy fucked"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (1.02%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.54 ms (0.88%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"pussy fucked"
]
|
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.