Query Metrics
7
Database Queries
7
Different statements
166.73 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
135.02 ms (80.98%) |
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 210281 391895 391922 426711 426712 443926 444224 444231 450577 454137 455126 456432 461932 462266 462289 462329 463176 465388 467783 470268 470389 470391 470518 470535 470561 470567 470611 470620 470625 470631 470641 470654 470926 473939 473968 475017 475232 475918 475945 476495 477373 478555 479069 479076 479092 479108 481099 482489 484133 485516 487260 488175 488825 490261 490307 492048 492687 492690 495193 496928 502119 502454 504136 504256 504268 505694 506807 509841 510747 513610 520188 521993 522523 523192 523877 524103 526329 527030 530310 533703 534808 541246 542739 542747 542760 542765 542789 543760 545027 545642 546802 547948 547952 547989 563400 566367 567955 571609 573986 585276 589743 590307 590472 590628 624999 648657 670056 690040 704010 720878 721613 726892 730497 753505 775982 779591 821839 821846 821847 821856 ] |
||||||||||||||||||||||||||||||
|
21.97 ms (13.18%) |
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 462329 454137 479092 490307 210281 547952 481099 462266 444224 484133 470518 496928 485516 563400 543760 502454 488175 541246 475918 476495 470535 567955 426712 545642 470620 506807 648657 690040 510747 624999 566367 542747 521993 547989 520188 542739 456432 504136 488825 523192 534808 545027 546802 585276 775982 463176 475017 821856 821846 721613 726892 753505 524103 470611 571609 455126 473939 473968 470641 527030 670056 470926 590628 470391 443926 523877 573986 542789 391922 475945 526329 470567 444231 479076 504256 391895 821839 821847 470625 513610 530310 547948 590472 779591 467783 509841 504268 490261 522523 589743 475232 470631 487260 462289 461932 502119 533703 542760 720878 492048 505694 542765 479108 482489 590307 704010 478555 477373 730497 479069 492690 470268 492687 426711 470561 495193 470389 465388 470654 450577 ] |
||||||||||||||||||||||||||||||
|
2.63 ms (1.58%) |
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 210281 391895 391922 426711 426712 443926 444224 444231 450577 454137 455126 456432 461932 462266 462289 462329 463176 465388 467783 470268 470389 470391 470518 470535 470561 470567 470611 470620 470625 470631 470641 470654 470926 473939 473968 475017 475232 475918 475945 476495 477373 478555 479069 479076 479092 479108 481099 482489 484133 485516 487260 488175 488825 490261 490307 492048 492687 492690 495193 496928 502119 502454 504136 504256 504268 505694 506807 509841 510747 513610 520188 521993 522523 523192 523877 524103 526329 527030 530310 533703 534808 541246 542739 542747 542760 542765 542789 543760 545027 545642 546802 547948 547952 547989 563400 566367 567955 571609 573986 585276 589743 590307 590472 590628 624999 648657 670056 690040 704010 720878 721613 726892 730497 753505 775982 779591 821839 821846 821847 821856 ] |
||||||||||||||||||||||||||||||
|
2.05 ms (1.23%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"домашнее русские мжм"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (1.09%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.75 ms (1.05%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"домашн любительск русск мжм секс втро"
]
|
||||||||||||||||||||||||||||||
|
1.49 ms (0.89%) |
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.