Query Metrics
7
Database Queries
7
Different statements
161.84 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
139.49 ms (86.19%) |
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 396522 398508 398869 401976 402244 408509 412984 418623 419179 419277 423414 423444 424281 424715 428608 429406 429698 430392 432618 435376 435657 436231 441476 441566 450640 454380 460894 461316 462823 463752 465164 465240 465910 466816 468778 469302 472509 476900 478073 478205 478431 478637 480338 491056 495235 499261 499735 502369 504103 508707 512892 520286 522428 523211 526083 526106 528118 528884 539913 541772 549497 555400 562706 564422 566858 577565 577805 581750 582057 592536 594995 596855 597144 602553 604254 605987 609827 611033 614875 617575 653532 662454 682270 684564 694953 696138 715768 734167 744067 745475 761717 765733 765907 769311 770277 772777 777678 781006 782400 787950 788030 791495 791592 791604 792135 793877 794736 794760 795686 798075 800658 800962 801299 802161 802504 807481 807699 808097 810392 817729 ] |
||||||||||||||||||||||||||||||
|
12.98 ms (8.02%) |
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 798075 810392 396522 696138 800962 808097 744067 430392 429698 468778 526083 684564 793877 807699 777678 792135 807481 782400 469302 480338 398508 817729 564422 769311 794760 460894 402244 461316 478205 512892 566858 611033 802504 734167 526106 522428 539913 549497 614875 541772 401976 418623 419179 466816 592536 594995 791495 795686 787950 435376 435657 436231 398869 478637 478073 504103 577805 423414 802161 412984 441566 424281 429406 454380 476900 715768 617575 781006 800658 788030 791592 794736 772777 765907 770277 801299 478431 502369 495235 597144 582057 428608 653532 596855 424715 528118 508707 520286 662454 682270 609827 602553 745475 528884 605987 408509 463752 604254 791604 765733 465240 462823 465164 491056 465910 577565 694953 562706 761717 432618 450640 419277 423444 441476 472509 523211 499735 499261 555400 581750 ] |
||||||||||||||||||||||||||||||
|
2.92 ms (1.80%) |
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 396522 398508 398869 401976 402244 408509 412984 418623 419179 419277 423414 423444 424281 424715 428608 429406 429698 430392 432618 435376 435657 436231 441476 441566 450640 454380 460894 461316 462823 463752 465164 465240 465910 466816 468778 469302 472509 476900 478073 478205 478431 478637 480338 491056 495235 499261 499735 502369 504103 508707 512892 520286 522428 523211 526083 526106 528118 528884 539913 541772 549497 555400 562706 564422 566858 577565 577805 581750 582057 592536 594995 596855 597144 602553 604254 605987 609827 611033 614875 617575 653532 662454 682270 684564 694953 696138 715768 734167 744067 745475 761717 765733 765907 769311 770277 772777 777678 781006 782400 787950 788030 791495 791592 791604 792135 793877 794736 794760 795686 798075 800658 800962 801299 802161 802504 807481 807699 808097 810392 817729 ] |
||||||||||||||||||||||||||||||
|
1.71 ms (1.06%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sperm sex"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (1.05%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"сперм секс"
]
|
||||||||||||||||||||||||||||||
|
1.54 ms (0.95%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.49 ms (0.92%) |
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.