Query Metrics
7
Database Queries
7
Different statements
172.07 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
150.06 ms (87.21%) |
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 381996 389861 391565 391949 397869 398755 425088 432524 446171 454044 457199 457383 460555 465647 466360 466435 471051 477620 478988 483957 484781 487984 490389 495546 497399 502321 509188 510934 511869 516008 521712 532058 532462 534079 543723 546102 546398 547705 549252 553285 553702 557808 558117 558610 559260 559842 562708 563113 571508 573758 576193 577260 583364 585434 585607 586079 590713 592800 593267 597098 603377 606051 619490 629205 647058 655531 659991 660622 660826 668605 668626 692424 694149 695128 712642 715364 716260 718279 718459 730059 730665 730700 732164 734730 735917 745217 748955 765202 769968 770031 770076 771380 793067 803759 803766 812483 813592 814382 816655 817575 817737 818550 818890 820323 824204 824767 825000 825366 825688 825882 826142 826143 826303 826407 826713 826723 826761 827579 828006 ] |
||||||||||||||||||||||||||||||
|
11.96 ms (6.95%) |
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 730059 734730 745217 730665 732164 735917 770076 771380 771983 730700 748955 769968 770031 619490 629205 712642 793067 803759 803766 389861 398755 432524 457199 466360 454044 457383 478988 490389 509188 511869 516008 471051 558610 558117 562708 553285 586079 590713 593267 812483 765202 391565 446171 425088 465647 502321 483957 487984 495546 484781 497399 573758 571508 466435 391949 381996 397869 818550 824767 813592 826142 826143 826713 826723 814382 816655 825366 825688 826761 827579 817575 817737 824204 825000 818890 820323 825882 826303 826407 828006 477620 460555 534079 510934 521712 532058 532462 547705 549252 577260 559260 559842 563113 576193 583364 543723 553702 660826 694149 716260 718279 647058 659991 668605 668626 718459 655531 660622 692424 695128 715364 546102 546398 557808 592800 597098 603377 606051 585434 585607 ] |
||||||||||||||||||||||||||||||
|
2.27 ms (1.32%) |
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 381996 389861 391565 391949 397869 398755 425088 432524 446171 454044 457199 457383 460555 465647 466360 466435 471051 477620 478988 483957 484781 487984 490389 495546 497399 502321 509188 510934 511869 516008 521712 532058 532462 534079 543723 546102 546398 547705 549252 553285 553702 557808 558117 558610 559260 559842 562708 563113 571508 573758 576193 577260 583364 585434 585607 586079 590713 592800 593267 597098 603377 606051 619490 629205 647058 655531 659991 660622 660826 668605 668626 692424 694149 695128 712642 715364 716260 718279 718459 730059 730665 730700 732164 734730 735917 745217 748955 765202 769968 770031 770076 771380 793067 803759 803766 812483 813592 814382 816655 817575 817737 818550 818890 820323 824204 824767 825000 825366 825688 825882 826142 826143 826303 826407 826713 826723 826761 827579 828006 ] |
||||||||||||||||||||||||||||||
|
2.17 ms (1.26%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.06 ms (1.20%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"webcam mom"
]
|
||||||||||||||||||||||||||||||
|
2.01 ms (1.17%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"вебкамер mom"
]
|
||||||||||||||||||||||||||||||
|
1.55 ms (0.90%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.