Query Metrics
7
Database Queries
7
Different statements
163.09 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
132.19 ms (81.05%) |
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 382450 415507 423561 429358 447511 448367 456686 461120 464595 472559 473937 483226 490862 491684 492158 506112 517676 520421 521896 522056 529259 537976 540286 541890 548246 548680 548848 554952 559016 560767 564409 569991 571619 571635 572988 573015 573090 573100 573119 573545 573568 573638 573646 573655 573664 573690 573699 573715 573780 573816 573831 573882 573891 574523 574561 574571 574818 574854 574896 574914 575214 575452 575475 575478 575483 575520 575754 575812 575815 576028 576054 576076 576351 578088 581928 584554 597512 605397 606425 607342 613635 619870 619878 620670 625013 628326 629268 636813 639934 647933 669408 679385 693278 693385 701501 707289 714948 718798 721187 722199 740157 741219 765297 771837 775137 780868 780932 788264 805049 805595 806043 809574 810681 810905 810908 810970 811009 811154 820743 ] |
||||||||||||||||||||||||||||||
|
22.06 ms (13.53%) |
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 560767 571619 573090 573119 573568 573638 573646 573655 573664 573690 573699 573715 573882 574523 574561 574818 574854 574914 575214 575452 575475 575520 575812 576028 576054 578088 581928 584554 693278 701501 707289 679385 693385 714948 722199 548680 559016 564409 569991 571635 572988 573015 573100 573545 573780 573816 573831 573891 574571 574896 575478 575483 575754 576076 576351 597512 619878 628326 620670 625013 639934 605397 636813 606425 810681 811009 780868 780932 810970 811154 805595 806043 810905 810908 741219 724357 740157 613635 619870 775137 415507 429358 521896 529259 491684 492158 506112 472559 548848 647933 788264 522056 423561 820743 461120 541890 554952 721187 669408 629268 607342 765297 805049 771837 809574 382450 473937 447511 456686 520421 483226 718798 575815 464595 448367 490862 537976 517676 540286 548246 ] |
||||||||||||||||||||||||||||||
|
2.28 ms (1.40%) |
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 382450 415507 423561 429358 447511 448367 456686 461120 464595 472559 473937 483226 490862 491684 492158 506112 517676 520421 521896 522056 529259 537976 540286 541890 548246 548680 548848 554952 559016 560767 564409 569991 571619 571635 572988 573015 573090 573100 573119 573545 573568 573638 573646 573655 573664 573690 573699 573715 573780 573816 573831 573882 573891 574523 574561 574571 574818 574854 574896 574914 575214 575452 575475 575478 575483 575520 575754 575812 575815 576028 576054 576076 576351 578088 581928 584554 597512 605397 606425 607342 613635 619870 619878 620670 625013 628326 629268 636813 639934 647933 669408 679385 693278 693385 701501 707289 714948 718798 721187 722199 740157 741219 765297 771837 775137 780868 780932 788264 805049 805595 806043 809574 810681 810905 810908 810970 811009 811154 820743 ] |
||||||||||||||||||||||||||||||
|
1.94 ms (1.19%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"porn beauty big"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (1.09%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.52 ms (0.94%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"porn beauty большие"
]
|
||||||||||||||||||||||||||||||
|
1.32 ms (0.81%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"porn beauty большие"
]
|
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.