Query Metrics
7
Database Queries
7
Different statements
153.48 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
129.56 ms (84.41%) |
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 421841 421883 422147 422153 422283 422635 423769 425562 426657 433372 437353 439569 439638 439704 439763 442932 443182 443191 446549 446792 447204 448558 460404 460704 462560 465362 465545 471607 471686 472113 474097 474777 474790 474798 477699 477981 479027 479120 479121 481198 488556 492977 493185 495226 495227 506055 506226 507003 508393 510504 516712 516941 517304 518938 519648 523843 524612 525315 525509 526994 527181 527641 528826 529157 538011 540713 547748 552285 561597 579163 582500 614499 619105 619564 663772 686177 687862 697720 718774 742292 744184 751583 751587 762513 763985 765853 765861 766903 778739 778994 780086 781028 781079 784814 787488 789178 790575 791501 792135 792284 794089 796209 797944 798011 798015 802041 803258 805141 806432 806686 807176 807352 807562 807577 808321 809354 809486 811782 814226 814309 ] |
||||||||||||||||||||||||||||||
|
14.52 ms (9.46%) |
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 439704 439763 447204 479121 433372 506055 516712 527641 529157 488556 495226 508393 510504 516941 525315 506226 507003 538011 492977 495227 519648 526994 527181 439569 422153 443182 814226 814309 446792 540713 552285 582500 561597 697720 718774 663772 687862 547748 579163 619564 614499 619105 778994 787488 794089 796209 798011 805141 806432 807352 780086 781079 789178 791501 792135 797944 798015 806686 807562 807577 809354 744184 792284 802041 807176 808321 811782 763985 742292 751587 762513 765853 751583 765861 766903 778739 781028 784814 790575 803258 809486 443191 460704 465545 477699 421883 422147 423769 426657 437353 471686 474790 479120 422635 425562 471607 474798 460404 481198 523843 518938 528826 686177 474777 517304 474097 422283 472113 442932 479027 421841 448558 462560 465362 439638 477981 446549 493185 524612 525509 ] |
||||||||||||||||||||||||||||||
|
2.22 ms (1.44%) |
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 421841 421883 422147 422153 422283 422635 423769 425562 426657 433372 437353 439569 439638 439704 439763 442932 443182 443191 446549 446792 447204 448558 460404 460704 462560 465362 465545 471607 471686 472113 474097 474777 474790 474798 477699 477981 479027 479120 479121 481198 488556 492977 493185 495226 495227 506055 506226 507003 508393 510504 516712 516941 517304 518938 519648 523843 524612 525315 525509 526994 527181 527641 528826 529157 538011 540713 547748 552285 561597 579163 582500 614499 619105 619564 663772 686177 687862 697720 718774 742292 744184 751583 751587 762513 763985 765853 765861 766903 778739 778994 780086 781028 781079 784814 787488 789178 790575 791501 792135 792284 794089 796209 797944 798011 798015 802041 803258 805141 806432 806686 807176 807352 807562 807577 808321 809354 809486 811782 814226 814309 ] |
||||||||||||||||||||||||||||||
|
2.01 ms (1.31%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"русск mom домашн любительск"
]
|
||||||||||||||||||||||||||||||
|
1.91 ms (1.25%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"russian mom homemade"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (1.13%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск mom домашн любительск"
]
|
||||||||||||||||||||||||||||||
|
1.53 ms (1.00%) |
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.