Query Metrics
7
Database Queries
7
Different statements
170.74 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
146.00 ms (85.51%) |
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 21397 58516 79898 194224 238994 278764 279212 322900 372986 382212 385478 388583 391315 392678 397828 401814 405249 405584 407487 409174 411055 411377 413560 424268 429643 451584 455600 456327 458584 462320 462576 469900 470153 471188 471365 473613 487710 491388 492274 493124 497284 499414 500252 503323 504355 506425 506492 542108 560340 563672 568723 584661 592566 597172 599759 602774 608092 611611 615800 617780 623265 625069 630279 635752 640868 640877 644885 650346 650358 651142 667140 667447 672402 673097 688172 689672 694362 702488 719471 719486 721266 721810 722046 725364 725760 727018 729816 730419 731445 736950 743764 748134 750030 753645 761620 762629 764597 765806 772789 778011 778200 779334 785978 787727 789922 791363 792608 796531 798977 798980 798981 798984 799005 802612 817480 818746 820426 820535 821740 826882 ] |
||||||||||||||||||||||||||||||
|
12.79 ms (7.49%) |
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 382212 372986 667447 731445 640877 826882 743764 560340 470153 462576 765806 597172 650358 798981 748134 762629 471365 21397 730419 689672 79898 672402 725760 388583 694362 322900 506425 58516 409174 725364 729816 778011 608092 411377 798984 802612 791363 753645 750030 635752 278764 615800 820426 821740 722046 736950 761620 779334 796531 719486 798980 787727 424268 778200 630279 592566 789922 623265 617780 451584 817480 500252 640868 238994 497284 407487 584661 644885 405249 563672 491388 772789 764597 391315 194224 456327 792608 504355 611611 785978 385478 411055 413560 820535 799005 798977 279212 818746 673097 492274 506492 721266 599759 702488 651142 727018 487710 499414 392678 473613 397828 405584 719471 429643 458584 542108 602774 401814 462320 471188 469900 503323 455600 688172 721810 568723 625069 493124 650346 667140 ] |
||||||||||||||||||||||||||||||
|
4.87 ms (2.85%) |
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 21397 58516 79898 194224 238994 278764 279212 322900 372986 382212 385478 388583 391315 392678 397828 401814 405249 405584 407487 409174 411055 411377 413560 424268 429643 451584 455600 456327 458584 462320 462576 469900 470153 471188 471365 473613 487710 491388 492274 493124 497284 499414 500252 503323 504355 506425 506492 542108 560340 563672 568723 584661 592566 597172 599759 602774 608092 611611 615800 617780 623265 625069 630279 635752 640868 640877 644885 650346 650358 651142 667140 667447 672402 673097 688172 689672 694362 702488 719471 719486 721266 721810 722046 725364 725760 727018 729816 730419 731445 736950 743764 748134 750030 753645 761620 762629 764597 765806 772789 778011 778200 779334 785978 787727 789922 791363 792608 796531 798977 798980 798981 798984 799005 802612 817480 818746 820426 820535 821740 826882 ] |
||||||||||||||||||||||||||||||
|
1.94 ms (1.14%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"минет оральн секс в автобус машин русс"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (1.04%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"минет в автобусе русс%…"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (1.01%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.64 ms (0.96%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"минет оральн секс в автобус машин русс"
]
|
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.