Query Metrics
7
Database Queries
7
Different statements
183.69 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
155.11 ms (84.44%) |
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 384524 385809 388219 411227 416165 416166 419358 419483 419862 419989 420120 421250 424876 427983 443651 443661 443991 446976 449869 449933 452282 453473 453929 458986 460099 471780 480929 484811 486788 494345 496266 496328 498112 500669 501487 510013 512613 516021 516625 516633 517725 517849 519392 520028 520405 521156 521367 522284 522883 524865 526920 527988 529405 530744 530796 531202 531405 532737 535013 537203 540400 543234 543808 551916 556533 556699 556835 558447 559187 564776 565149 575890 576698 576721 580368 582376 589345 592728 599899 599908 599932 599957 600206 600293 601707 602946 603642 603684 604528 604551 604554 606377 610060 614194 615747 619401 620165 620726 621962 625412 625444 637741 642658 643377 646771 647954 647994 648867 650476 666586 668526 670117 675429 675431 675696 675725 681301 808077 811040 ] |
||||||||||||||||||||||||||||||
|
16.80 ms (9.15%) |
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 556699 565149 576698 576721 564776 648867 670117 675429 675431 675696 681301 675725 556533 600293 603684 614194 625444 604554 619401 589345 599908 615747 811040 604551 808077 471780 419483 419989 453473 512613 517725 517849 484811 513476 516021 496266 522284 498112 500669 520405 527988 519392 416166 582376 449869 388219 529405 575890 643377 516625 384524 411227 443661 427983 416165 443991 449933 452282 453929 486788 460099 521156 521367 532737 540400 496328 531405 551916 543808 543234 558447 647954 650476 556835 599932 606377 610060 620726 621962 599957 637741 620165 601707 385809 458986 419358 443651 480929 526920 510013 516633 520028 522883 421250 419862 424876 524865 592728 604528 446976 494345 535013 420120 530796 531202 537203 530744 559187 580368 647994 646771 668526 666586 642658 600206 599899 602946 603642 625412 501487 ] |
||||||||||||||||||||||||||||||
|
4.32 ms (2.35%) |
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 384524 385809 388219 411227 416165 416166 419358 419483 419862 419989 420120 421250 424876 427983 443651 443661 443991 446976 449869 449933 452282 453473 453929 458986 460099 471780 480929 484811 486788 494345 496266 496328 498112 500669 501487 510013 512613 516021 516625 516633 517725 517849 519392 520028 520405 521156 521367 522284 522883 524865 526920 527988 529405 530744 530796 531202 531405 532737 535013 537203 540400 543234 543808 551916 556533 556699 556835 558447 559187 564776 565149 575890 576698 576721 580368 582376 589345 592728 599899 599908 599932 599957 600206 600293 601707 602946 603642 603684 604528 604551 604554 606377 610060 614194 615747 619401 620165 620726 621962 625412 625444 637741 642658 643377 646771 647954 647994 648867 650476 666586 668526 670117 675429 675431 675696 675725 681301 808077 811040 ] |
||||||||||||||||||||||||||||||
|
2.10 ms (1.14%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"milf black cock"
]
|
||||||||||||||||||||||||||||||
|
2.06 ms (1.12%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"milf black cock"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (0.92%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"milf black cock"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (0.88%) |
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.