Query Metrics
7
Database Queries
7
Different statements
137.20 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
113.96 ms (83.06%) |
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 409383 415745 418594 423348 424548 428305 434344 435560 435607 438013 445099 447657 449484 449546 451654 452326 452753 452787 455813 457486 466374 474989 480119 495525 496647 498278 499552 500222 505902 508968 509983 511507 525970 527471 528544 534604 534722 536049 539956 551116 553942 556496 571511 571769 573274 578733 579145 581978 584362 584421 585316 586307 592778 594560 595275 600094 602063 611032 612276 613576 614585 614857 620820 624166 628692 636666 638744 641534 644785 662093 662104 664186 666055 672317 676724 681237 681485 691787 692780 705424 707436 707545 715282 719461 739496 739946 747955 749899 749978 751050 758248 758780 761293 765325 769150 776080 777779 778811 784039 785500 785603 788423 790636 790912 791504 792700 801148 804441 806930 807842 808623 808884 812035 ] |
||||||||||||||||||||||||||||||
|
12.85 ms (9.37%) |
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 636666 644785 641534 808623 804441 806930 751050 785603 790912 808884 747955 739946 758248 784039 445099 424548 499552 527471 451654 449546 457486 447657 534722 539956 498278 525970 495525 536049 511507 579145 676724 691787 707436 666055 681237 692780 672317 719461 571769 573274 620820 790636 801148 776080 777779 778811 807842 758780 765325 788423 739496 749978 614585 707545 812035 435560 428305 434344 452753 435607 505902 466374 415745 455813 508968 534604 480119 584362 664186 662093 585316 592778 586307 612276 638744 628692 595275 761293 749899 791504 423348 409383 500222 528544 452326 474989 449484 452787 571511 551116 578733 581978 681485 662104 715282 594560 769150 792700 418594 556496 584421 611032 624166 614857 785500 705424 438013 613576 602063 496647 509983 600094 553942 ] |
||||||||||||||||||||||||||||||
|
3.07 ms (2.24%) |
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 409383 415745 418594 423348 424548 428305 434344 435560 435607 438013 445099 447657 449484 449546 451654 452326 452753 452787 455813 457486 466374 474989 480119 495525 496647 498278 499552 500222 505902 508968 509983 511507 525970 527471 528544 534604 534722 536049 539956 551116 553942 556496 571511 571769 573274 578733 579145 581978 584362 584421 585316 586307 592778 594560 595275 600094 602063 611032 612276 613576 614585 614857 620820 624166 628692 636666 638744 641534 644785 662093 662104 664186 666055 672317 676724 681237 681485 691787 692780 705424 707436 707545 715282 719461 739496 739946 747955 749899 749978 751050 758248 758780 761293 765325 769150 776080 777779 778811 784039 785500 785603 788423 790636 790912 791504 792700 801148 804441 806930 807842 808623 808884 812035 ] |
||||||||||||||||||||||||||||||
|
1.93 ms (1.40%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"solo pussy cum"
]
|
||||||||||||||||||||||||||||||
|
1.92 ms (1.40%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.73 ms (1.26%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"соло pussy cum"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (1.26%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"соло pussy cum"
]
|
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.