Query Metrics
7
Database Queries
7
Different statements
162.46 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
138.19 ms (85.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 36832 145424 252608 383046 383744 384321 384551 385303 385471 386303 386860 387895 389310 390967 394186 396522 396787 397279 397387 399300 400446 400450 400718 402267 402503 403947 404267 422920 427179 429257 445040 463771 466187 469874 473549 476155 480856 502706 503917 503949 505501 507929 518209 521854 527002 532149 534109 538431 547998 553276 554176 556379 556412 556969 557172 560372 562602 567002 571672 578465 592735 597460 599747 613778 652563 655489 659635 666141 667525 675746 676453 684235 684580 694132 694180 704853 705977 706933 708459 710001 710964 712722 718554 720469 720487 720504 732404 732466 741480 741647 741650 743082 743103 743127 743142 743144 744155 744790 750561 751900 759574 759587 759599 770475 774376 784925 788647 790295 790988 794517 794702 797216 798992 799402 800305 802269 802397 804704 807516 811560 ] |
||||||||||||||||||||||||||||||
|
12.89 ms (7.93%) |
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 402503 518209 556969 708459 720504 592735 599747 790988 794517 743103 743127 743142 743144 744790 798992 732404 759587 741647 799402 400718 469874 694180 790295 383046 384551 145424 252608 389310 396787 397387 400446 402267 403947 427179 422920 463771 534109 502706 527002 503949 553276 567002 578465 556379 560372 655489 667525 712722 684580 706933 710001 718554 666141 676453 694132 720487 556412 571672 613778 802397 807516 732466 743082 770475 784925 794702 800305 750561 759599 741650 751900 759574 710964 720469 788647 429257 466187 480856 36832 387895 400450 404267 445040 473549 390967 397279 394186 396522 476155 503917 538431 505501 521854 507929 532149 554176 704853 675746 811560 774376 562602 652563 557172 597460 399300 659635 684235 547998 797216 802269 744155 741480 705977 804704 385471 386303 386860 385303 384321 383744 ] |
||||||||||||||||||||||||||||||
|
4.21 ms (2.59%) |
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 36832 145424 252608 383046 383744 384321 384551 385303 385471 386303 386860 387895 389310 390967 394186 396522 396787 397279 397387 399300 400446 400450 400718 402267 402503 403947 404267 422920 427179 429257 445040 463771 466187 469874 473549 476155 480856 502706 503917 503949 505501 507929 518209 521854 527002 532149 534109 538431 547998 553276 554176 556379 556412 556969 557172 560372 562602 567002 571672 578465 592735 597460 599747 613778 652563 655489 659635 666141 667525 675746 676453 684235 684580 694132 694180 704853 705977 706933 708459 710001 710964 712722 718554 720469 720487 720504 732404 732466 741480 741647 741650 743082 743103 743127 743142 743144 744155 744790 750561 751900 759574 759587 759599 770475 774376 784925 788647 790295 790988 794517 794702 797216 798992 799402 800305 802269 802397 804704 807516 811560 ] |
||||||||||||||||||||||||||||||
|
2.07 ms (1.27%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.98 ms (1.22%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"man man"
]
|
||||||||||||||||||||||||||||||
|
1.89 ms (1.16%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"мужчин мужчин"
]
|
||||||||||||||||||||||||||||||
|
1.24 ms (0.76%) |
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.