Query Metrics
7
Database Queries
7
Different statements
137.45 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
117.56 ms (85.52%) |
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 53740 364027 391439 398428 398604 415956 417551 418225 424384 429121 429815 432370 432392 432431 432471 432481 432485 432504 432525 433024 433051 433358 433366 433433 433435 433447 433622 433749 434236 434241 444574 450690 452716 453825 503796 517990 522160 526397 529357 530192 535794 536876 543127 545745 561880 575570 581229 588479 591120 592843 594238 594443 595057 598440 598677 599871 600945 603052 610650 620554 629130 635192 653229 656090 664206 669578 690508 709589 719947 719979 719990 719991 720439 722538 730202 730302 737298 742188 744270 745081 745336 746445 746472 746581 748555 748574 751242 761386 767899 770295 772312 775909 775919 775939 779779 783103 787172 788414 791782 791814 792485 802588 813399 818855 820865 823721 827013 828431 828541 828544 828557 828664 828673 828677 828763 828770 828780 828785 ] |
||||||||||||||||||||||||||||||
|
11.71 ms (8.52%) |
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 748555 719947 761386 433433 432481 432471 432504 432431 779779 417551 592843 575570 517990 594372 433435 433358 595057 598677 594443 526397 598440 720439 690508 802588 529357 610650 591120 432485 429121 433749 434236 530192 433447 434241 828673 828557 656090 629130 450690 719991 746472 828763 599871 745081 828780 827013 828677 745336 415956 730202 791814 783103 820865 788414 775909 823721 775939 818855 828541 828664 748574 398428 424384 719990 398604 418225 767899 453825 391439 787172 791782 722538 603052 770295 669578 730302 751242 433366 452716 828770 828785 828544 746581 561880 620554 792485 432392 594238 664206 433622 828652 545745 653229 744270 737298 742188 536876 746445 432370 433051 522160 543127 828431 53740 719979 444574 772312 813399 429815 432525 433024 535794 635192 588479 503796 581229 600945 709589 775919 364027 ] |
||||||||||||||||||||||||||||||
|
2.36 ms (1.72%) |
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 53740 364027 391439 398428 398604 415956 417551 418225 424384 429121 429815 432370 432392 432431 432471 432481 432485 432504 432525 433024 433051 433358 433366 433433 433435 433447 433622 433749 434236 434241 444574 450690 452716 453825 503796 517990 522160 526397 529357 530192 535794 536876 543127 545745 561880 575570 581229 588479 591120 592843 594238 594443 595057 598440 598677 599871 600945 603052 610650 620554 629130 635192 653229 656090 664206 669578 690508 709589 719947 719979 719990 719991 720439 722538 730202 730302 737298 742188 744270 745081 745336 746445 746472 746581 748555 748574 751242 761386 767899 770295 772312 775909 775919 775939 779779 783103 787172 788414 791782 791814 792485 802588 813399 818855 820865 823721 827013 828431 828541 828544 828557 828664 828673 828677 828763 828770 828780 828785 ] |
||||||||||||||||||||||||||||||
|
1.74 ms (1.26%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"teen handjob"
]
|
||||||||||||||||||||||||||||||
|
1.54 ms (1.12%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.36 ms (0.99%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"teen дрочк член"
]
|
||||||||||||||||||||||||||||||
|
1.19 ms (0.87%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"teen дрочк член"
]
|
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.