Query Metrics
7
Database Queries
7
Different statements
260.19 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
234.57 ms (90.15%) |
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 89205 281465 382015 384349 384960 397395 397509 401414 402138 413203 420432 420625 420799 421051 425687 426690 429715 430988 432974 437808 439341 445272 454725 458440 459794 464659 470219 471129 475769 480788 485031 494489 496725 497399 499715 500746 500780 502641 505798 515293 516579 516605 520019 525466 526244 536236 537993 539873 544774 556611 559811 560000 560808 565298 568263 569614 577240 579783 584093 591799 599322 601744 602136 602251 604035 613245 614843 619178 623207 631325 652092 662803 666982 670450 670779 676944 678548 678570 679073 680476 689207 701303 704626 708543 712398 713289 714388 716360 717643 722944 736903 743550 745543 751491 752771 753090 755227 767745 774179 777670 777835 781017 781856 785074 787365 788012 799691 801308 805548 806432 814191 814197 816855 820802 821402 821501 822635 822910 823317 824929 ] |
||||||||||||||||||||||||||||||
|
14.90 ms (5.73%) |
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 496725 497399 499715 520019 577240 717643 613245 420432 602251 516605 781856 430988 420799 401414 560000 591799 614843 631325 425687 458440 525466 526244 432974 823317 568263 670779 652092 623207 751491 767745 752771 413203 384349 599322 384960 601744 454725 806432 502641 569614 471129 437808 516579 505798 426690 464659 537993 500746 485031 565298 602136 785074 397509 421051 480788 429715 439341 459794 470219 475769 420625 445272 500780 494489 382015 816855 824929 536236 539873 704626 708543 604035 619178 777670 777835 781017 788012 799691 801308 805548 736903 743550 755227 774179 745543 753090 713289 716360 787365 397395 402138 281465 89205 814197 821402 821501 820802 822910 814191 822635 515293 584093 559811 579783 544774 556611 560808 678548 680476 712398 722944 662803 666982 679073 701303 714388 670450 676944 678570 689207 ] |
||||||||||||||||||||||||||||||
|
3.77 ms (1.45%) |
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 89205 281465 382015 384349 384960 397395 397509 401414 402138 413203 420432 420625 420799 421051 425687 426690 429715 430988 432974 437808 439341 445272 454725 458440 459794 464659 470219 471129 475769 480788 485031 494489 496725 497399 499715 500746 500780 502641 505798 515293 516579 516605 520019 525466 526244 536236 537993 539873 544774 556611 559811 560000 560808 565298 568263 569614 577240 579783 584093 591799 599322 601744 602136 602251 604035 613245 614843 619178 623207 631325 652092 662803 666982 670450 670779 676944 678548 678570 679073 680476 689207 701303 704626 708543 712398 713289 714388 716360 717643 722944 736903 743550 745543 751491 752771 753090 755227 767745 774179 777670 777835 781017 781856 785074 787365 788012 799691 801308 805548 806432 814191 814197 816855 820802 821402 821501 822635 822910 823317 824929 ] |
||||||||||||||||||||||||||||||
|
2.01 ms (0.77%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"beautiful solo sex"
]
|
||||||||||||||||||||||||||||||
|
1.90 ms (0.73%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"красивая соло секс"
]
|
||||||||||||||||||||||||||||||
|
1.53 ms (0.59%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"красивая соло секс"
]
|
||||||||||||||||||||||||||||||
|
1.51 ms (0.58%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.