Query Metrics
7
Database Queries
7
Different statements
147.07 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
119.29 ms (81.11%) |
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 154127 383470 393220 396369 399152 399912 411896 416022 417674 421290 422177 425028 425312 426043 426271 428741 433981 434332 435005 437950 438748 441041 441108 441124 445066 445175 450410 451157 455792 456899 457814 463211 463384 470520 475485 476166 476671 477223 480194 483814 492737 493606 499531 507189 507503 508885 510905 511277 513938 514752 515551 515994 521831 526659 533598 534625 536613 541501 546566 551031 551654 555297 557387 561481 564387 571316 581412 582032 582567 583267 593812 594131 594136 595660 599865 602614 605673 606259 610710 618271 629808 640400 640686 651912 661020 661510 663217 666596 670037 678713 680475 698890 713176 721168 739054 750951 757152 760629 764491 783941 784630 787095 787480 796336 796644 798877 799636 803530 803628 805021 806144 807589 809391 810884 810896 811955 815038 815801 821195 823809 ] |
||||||||||||||||||||||||||||||
|
17.83 ms (12.12%) |
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 783941 810884 433981 581412 450410 422177 399152 483814 515994 602614 821195 815801 661020 721168 798877 805021 678713 811955 425312 426043 470520 534625 507503 557387 713176 599865 463384 396369 492737 426271 441108 437950 571316 651912 670037 595660 787095 803530 750951 799636 810896 618271 784630 499531 629808 477223 417674 476671 515551 533598 583267 663217 807589 760629 606259 510905 476166 551031 541501 666596 640400 610710 757152 463211 513938 511277 593812 787480 521831 425028 526659 438748 480194 393220 455792 764491 680475 809391 434332 456899 416022 383470 445175 441041 508885 399912 421290 441124 451157 514752 582032 546566 594131 594136 806144 803628 739054 796336 796644 411896 457814 428741 493606 561481 564387 661510 435005 445066 555297 154127 823809 815038 475485 507189 536613 582567 551654 640686 605673 698890 ] |
||||||||||||||||||||||||||||||
|
2.75 ms (1.87%) |
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 154127 383470 393220 396369 399152 399912 411896 416022 417674 421290 422177 425028 425312 426043 426271 428741 433981 434332 435005 437950 438748 441041 441108 441124 445066 445175 450410 451157 455792 456899 457814 463211 463384 470520 475485 476166 476671 477223 480194 483814 492737 493606 499531 507189 507503 508885 510905 511277 513938 514752 515551 515994 521831 526659 533598 534625 536613 541501 546566 551031 551654 555297 557387 561481 564387 571316 581412 582032 582567 583267 593812 594131 594136 595660 599865 602614 605673 606259 610710 618271 629808 640400 640686 651912 661020 661510 663217 666596 670037 678713 680475 698890 713176 721168 739054 750951 757152 760629 764491 783941 784630 787095 787480 796336 796644 798877 799636 803530 803628 805021 806144 807589 809391 810884 810896 811955 815038 815801 821195 823809 ] |
||||||||||||||||||||||||||||||
|
2.21 ms (1.51%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"public masturbation squirt"
]
|
||||||||||||||||||||||||||||||
|
1.94 ms (1.32%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.65 ms (1.12%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"на улиц мастурбац сквирт оргазм"
]
|
||||||||||||||||||||||||||||||
|
1.40 ms (0.95%) |
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.