Query Metrics
7
Database Queries
7
Different statements
180.45 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
157.33 ms (87.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 233398 382946 383549 384521 390214 395591 402762 415698 416137 416871 421578 425302 427216 428239 437880 445611 447788 456827 458235 460464 460553 461485 470943 481626 481711 491095 492615 494814 504816 505615 514910 515731 521646 523655 532659 535785 548775 555837 556318 556766 566042 573663 575495 579834 584430 585472 590227 591234 599397 599535 608317 608352 609202 609921 630822 637486 641445 644115 647356 667791 679058 697155 708803 714655 716418 718561 718750 720707 720714 727684 728646 730642 730741 731360 734003 744346 744910 745401 747101 747776 748051 755589 755633 758699 759635 760752 761618 763886 765513 767959 768943 769752 771249 781846 783448 786453 786806 787548 788223 790849 791851 797746 798671 799763 802035 802344 804167 807920 810276 810735 812705 814275 814584 815408 815437 822603 823065 823788 ] |
||||||||||||||||||||||||||||||
|
13.69 ms (7.58%) |
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 823065 532659 514910 460553 755633 761618 802035 427216 535785 720707 798671 747776 720714 799763 747101 771249 728646 644115 390214 797746 730642 745401 744346 767959 758699 608317 815437 822603 447788 456827 504816 505615 555837 556766 584430 667791 787548 609921 575495 415698 815408 814275 609202 637486 812705 755589 790849 383549 492615 734003 416137 579834 437880 521646 573663 718561 608352 727684 465188 814584 428239 716418 664379 590227 599397 630822 804167 810276 781846 730741 445611 461485 470943 402762 599535 760752 641445 491095 679058 556318 585472 810735 458235 425302 494814 566042 481626 823788 515731 714655 591234 791851 783448 786806 731360 748051 744910 763886 768943 786453 788223 708803 548775 759635 233398 481711 765513 697155 421578 523655 718750 647356 802344 807920 769752 384521 416871 460464 382946 395591 ] |
||||||||||||||||||||||||||||||
|
2.87 ms (1.59%) |
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 233398 382946 383549 384521 390214 395591 402762 415698 416137 416871 421578 425302 427216 428239 437880 445611 447788 456827 458235 460464 460553 461485 470943 481626 481711 491095 492615 494814 504816 505615 514910 515731 521646 523655 532659 535785 548775 555837 556318 556766 566042 573663 575495 579834 584430 585472 590227 591234 599397 599535 608317 608352 609202 609921 630822 637486 641445 644115 647356 667791 679058 697155 708803 714655 716418 718561 718750 720707 720714 727684 728646 730642 730741 731360 734003 744346 744910 745401 747101 747776 748051 755589 755633 758699 759635 760752 761618 763886 765513 767959 768943 769752 771249 781846 783448 786453 786806 787548 788223 790849 791851 797746 798671 799763 802035 802344 804167 807920 810276 810735 812705 814275 814584 815408 815437 822603 823065 823788 ] |
||||||||||||||||||||||||||||||
|
1.76 ms (0.98%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"good blowjob"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (0.95%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"good минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (0.89%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"good минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.48 ms (0.82%) |
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.