Query Metrics
7
Database Queries
7
Different statements
163.75 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
134.90 ms (82.38%) |
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 38452 191495 232940 234239 364242 383940 388223 395427 395556 395924 396393 397068 398946 399518 400097 401057 407169 407685 407782 409882 413100 413472 413478 418930 422295 424977 424985 427766 428539 429416 432837 434193 437302 440292 442783 443669 443695 443701 443818 443948 446088 446311 448362 448958 449696 450195 454220 458012 458731 460273 460404 460744 461041 462934 463160 464388 464426 466026 466149 468581 468629 472166 473309 474795 477876 477993 483362 484586 486345 486896 487338 489841 490138 506830 509536 509881 511790 515045 516076 523762 525625 525964 527753 532058 534244 543332 543773 550223 550379 554897 560390 563195 567080 581135 596576 615311 663936 680860 710588 712338 714750 717688 720614 724297 749825 758436 779175 781079 788507 788868 788875 788959 789527 792660 798679 801726 807546 807553 808537 813916 ] |
||||||||||||||||||||||||||||||
|
18.05 ms (11.02%) |
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 477993 443695 413478 413100 450195 487338 525964 484586 486345 490138 534244 400097 440292 448362 397068 401057 407685 458731 511790 532058 801726 395556 399518 409882 424985 813916 461041 458012 460273 464426 543332 560390 563195 554897 663936 710588 680860 720614 788507 781079 758436 807546 807553 808537 383940 396393 407782 422295 443701 462934 468581 477876 38452 463160 191495 398946 443818 443948 232940 424977 429416 443669 418930 437302 460404 509536 509881 515045 516076 525625 527753 468629 446311 543773 432837 442783 523762 717688 596576 789527 749825 714750 364242 472166 792660 407169 483362 464388 798679 466149 474795 427766 506830 460744 466026 234239 395924 395427 388223 428539 413472 434193 448958 449696 489841 454220 486896 446088 473309 581135 550379 550223 712338 567080 615311 779175 788875 788959 788868 724297 ] |
||||||||||||||||||||||||||||||
|
2.82 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 38452 191495 232940 234239 364242 383940 388223 395427 395556 395924 396393 397068 398946 399518 400097 401057 407169 407685 407782 409882 413100 413472 413478 418930 422295 424977 424985 427766 428539 429416 432837 434193 437302 440292 442783 443669 443695 443701 443818 443948 446088 446311 448362 448958 449696 450195 454220 458012 458731 460273 460404 460744 461041 462934 463160 464388 464426 466026 466149 468581 468629 472166 473309 474795 477876 477993 483362 484586 486345 486896 487338 489841 490138 506830 509536 509881 511790 515045 516076 523762 525625 525964 527753 532058 534244 543332 543773 550223 550379 554897 560390 563195 567080 581135 596576 615311 663936 680860 710588 712338 714750 717688 720614 724297 749825 758436 779175 781079 788507 788868 788875 788959 789527 792660 798679 801726 807546 807553 808537 813916 ] |
||||||||||||||||||||||||||||||
|
2.29 ms (1.40%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"boy fuck mom"
]
|
||||||||||||||||||||||||||||||
|
1.97 ms (1.20%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.89 ms (1.15%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"парен секс mom"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (1.12%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"парен секс mom"
]
|
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.