Query Metrics
7
Database Queries
7
Different statements
192.79 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
169.98 ms (88.17%) |
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 338225 390019 391221 394528 396421 398547 398907 400815 406867 409759 413210 414785 418297 424651 426966 432897 434992 437888 437901 442988 445747 446200 459055 464616 465050 478067 517746 519253 522644 538840 542967 544255 557964 578221 583769 584664 586322 589001 591899 606978 610140 613920 616615 618363 621990 625757 626880 630351 636929 654337 654353 657493 672274 674603 675829 676415 680094 682877 692919 693281 715521 724240 726267 727915 728907 730222 730492 731620 734116 734436 738347 740743 740759 742567 742592 742916 749760 750769 751152 751220 756910 760210 760787 761510 762443 763516 763626 764077 766799 766866 767836 769068 775618 776040 776106 779573 779966 781590 783180 783572 786156 786217 787060 787458 788621 790592 792659 793329 793663 795552 799324 801232 802619 806855 808802 815946 817708 819005 819352 823735 ] |
||||||||||||||||||||||||||||||
|
12.51 ms (6.49%) |
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 618363 764077 400815 437888 801232 409759 437901 396421 478067 672274 727915 751152 542967 584664 779966 792659 760787 767836 762443 742567 742592 391221 676415 636929 616615 793329 808802 799324 731620 787060 432897 426966 446200 394528 693281 544255 538840 630351 418297 823735 606978 390019 413210 760210 445747 815946 398907 583769 414785 338225 715521 692919 621990 775618 783572 734116 786156 557964 793663 817708 591899 740743 750769 675829 682877 586322 790592 779573 786217 434992 578221 680094 589001 806855 738347 763626 674603 517746 657493 766866 459055 819005 519253 613920 626880 776106 781590 787458 802619 726267 766799 769068 783180 788621 734436 742916 751220 724240 728907 740759 749760 756910 610140 776040 819352 465050 730222 424651 464616 522644 761510 763516 442988 406867 730492 398547 654353 654337 795552 625757 ] |
||||||||||||||||||||||||||||||
|
3.22 ms (1.67%) |
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 338225 390019 391221 394528 396421 398547 398907 400815 406867 409759 413210 414785 418297 424651 426966 432897 434992 437888 437901 442988 445747 446200 459055 464616 465050 478067 517746 519253 522644 538840 542967 544255 557964 578221 583769 584664 586322 589001 591899 606978 610140 613920 616615 618363 621990 625757 626880 630351 636929 654337 654353 657493 672274 674603 675829 676415 680094 682877 692919 693281 715521 724240 726267 727915 728907 730222 730492 731620 734116 734436 738347 740743 740759 742567 742592 742916 749760 750769 751152 751220 756910 760210 760787 761510 762443 763516 763626 764077 766799 766866 767836 769068 775618 776040 776106 779573 779966 781590 783180 783572 786156 786217 787060 787458 788621 790592 792659 793329 793663 795552 799324 801232 802619 806855 808802 815946 817708 819005 819352 823735 ] |
||||||||||||||||||||||||||||||
|
2.00 ms (1.04%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"blowjob creampie"
]
|
||||||||||||||||||||||||||||||
|
1.92 ms (1.00%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.67 ms (0.87%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"минет оральн секс creampie"
]
|
||||||||||||||||||||||||||||||
|
1.49 ms (0.77%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"минет оральн секс creampie"
]
|
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.