Query Metrics
7
Database Queries
7
Different statements
156.37 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
133.22 ms (85.20%) |
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 438411 441072 447018 453111 453640 456431 456965 457922 459054 459318 460181 468991 469307 478593 478609 478628 480710 480712 480999 484006 490862 492153 492928 493064 493993 505295 505899 506446 510694 511984 512619 514981 520074 522956 523075 523906 530893 538528 543508 555969 559217 561572 562064 564575 568087 573476 580501 580986 583576 583655 586018 601204 602792 603409 603655 609285 609432 610012 613608 616944 618802 618809 620180 625110 626334 627912 635025 639139 641261 642940 650726 660080 667256 667459 674596 684200 689169 690718 693962 694886 695337 695888 697004 697589 701573 701801 702299 702309 707469 710504 712244 714026 715436 715615 719131 724863 725688 726685 728087 728424 728440 746011 748033 754079 757318 761130 761162 761190 761815 765148 794440 802136 802580 804777 810302 810430 812661 812818 814691 823786 ] |
||||||||||||||||||||||||||||||
|
13.55 ms (8.67%) |
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 757318 761162 609285 493064 701801 478593 693962 457922 707469 823786 674596 667459 697589 618809 625110 586018 794440 746011 754079 726685 725688 761190 761815 602792 642940 715436 724863 468991 701573 660080 543508 510694 512619 520074 580986 667256 702299 702309 689169 695337 697004 635025 626334 810302 761130 719131 453640 580501 618802 802136 522956 810430 728424 728440 441072 814691 469307 447018 453111 511984 530893 523075 514981 484006 492928 561572 583655 694886 650726 603409 613608 627912 641261 812818 748033 802580 765148 603655 710504 714026 804777 456965 456431 478609 505295 559217 610012 459054 460181 538528 601204 616944 492153 555969 478628 480710 480999 490862 505899 506446 523906 493993 568087 583576 562064 715615 684200 690718 695888 564575 573476 639139 620180 609432 812661 728087 712244 438411 480712 459318 ] |
||||||||||||||||||||||||||||||
|
2.85 ms (1.82%) |
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 438411 441072 447018 453111 453640 456431 456965 457922 459054 459318 460181 468991 469307 478593 478609 478628 480710 480712 480999 484006 490862 492153 492928 493064 493993 505295 505899 506446 510694 511984 512619 514981 520074 522956 523075 523906 530893 538528 543508 555969 559217 561572 562064 564575 568087 573476 580501 580986 583576 583655 586018 601204 602792 603409 603655 609285 609432 610012 613608 616944 618802 618809 620180 625110 626334 627912 635025 639139 641261 642940 650726 660080 667256 667459 674596 684200 689169 690718 693962 694886 695337 695888 697004 697589 701573 701801 702299 702309 707469 710504 712244 714026 715436 715615 719131 724863 725688 726685 728087 728424 728440 746011 748033 754079 757318 761130 761162 761190 761815 765148 794440 802136 802580 804777 810302 810430 812661 812818 814691 823786 ] |
||||||||||||||||||||||||||||||
|
1.89 ms (1.21%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"do жен cock"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (1.14%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"do wife cock"
]
|
||||||||||||||||||||||||||||||
|
1.58 ms (1.01%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"do жен cock"
]
|
||||||||||||||||||||||||||||||
|
1.49 ms (0.95%) |
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.