Query Metrics
7
Database Queries
7
Different statements
175.30 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
147.16 ms (83.95%) |
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 34452 47583 62010 69956 80578 106185 107216 111339 187759 191336 270515 366354 382186 382333 382543 385988 390082 391044 391264 392959 393129 397364 397534 398011 398044 399936 401005 402977 407052 410210 411688 413099 413298 413417 417683 417998 419282 420362 421162 424128 425347 425469 426173 428500 433656 434530 435409 437105 437888 440581 440986 444819 445671 447699 450461 450522 452451 456733 456837 458952 464941 466243 468125 470719 471653 472244 477065 477092 480760 480832 481734 482573 482606 483014 485923 486684 496574 500721 501068 502506 504831 505132 506100 508846 513198 513705 514938 518815 523026 527560 528626 531413 545692 551281 551636 558248 558609 567068 567893 570084 570111 572889 580270 592607 606964 608780 609823 612168 615510 647110 661918 662172 676591 783823 785056 790995 796214 800042 802439 806341 ] |
||||||||||||||||||||||||||||||
|
18.27 ms (10.42%) |
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 111339 398044 445671 796214 606964 615510 47583 382543 481734 393129 399936 417683 407052 411688 480760 452451 480832 434530 506100 580270 401005 413298 421162 551281 558248 558609 425469 450522 513198 518815 483014 504831 425347 676591 80578 191336 397534 437105 647110 662172 783823 785056 447699 458952 527560 382186 34452 428500 433656 500721 551636 572889 609823 470719 435409 508846 531413 505132 106185 366354 410210 477092 472244 545692 567068 592607 450461 502506 528626 496574 513705 382333 402977 482606 608780 612168 790995 802439 107216 419282 501068 390082 471653 468125 440581 466243 523026 270515 391264 413417 69956 392959 482573 485923 486684 456733 514938 570111 661918 800042 806341 187759 391044 440986 397364 385988 437888 417998 398011 444819 413099 420362 456837 477065 567893 570084 62010 426173 424128 464941 ] |
||||||||||||||||||||||||||||||
|
2.62 ms (1.49%) |
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 34452 47583 62010 69956 80578 106185 107216 111339 187759 191336 270515 366354 382186 382333 382543 385988 390082 391044 391264 392959 393129 397364 397534 398011 398044 399936 401005 402977 407052 410210 411688 413099 413298 413417 417683 417998 419282 420362 421162 424128 425347 425469 426173 428500 433656 434530 435409 437105 437888 440581 440986 444819 445671 447699 450461 450522 452451 456733 456837 458952 464941 466243 468125 470719 471653 472244 477065 477092 480760 480832 481734 482573 482606 483014 485923 486684 496574 500721 501068 502506 504831 505132 506100 508846 513198 513705 514938 518815 523026 527560 528626 531413 545692 551281 551636 558248 558609 567068 567893 570084 570111 572889 580270 592607 606964 608780 609823 612168 615510 647110 661918 662172 676591 783823 785056 790995 796214 800042 802439 806341 ] |
||||||||||||||||||||||||||||||
|
2.24 ms (1.28%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"трахает лицо парня"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (1.02%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс лиц парен"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (0.93%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.59 ms (0.91%) |
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.