Query Metrics
7
Database Queries
7
Different statements
196.42 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
170.36 ms (86.73%) |
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 188456 312264 383631 386759 398263 411693 413170 417221 419969 423869 423966 423968 443632 446865 447882 448182 452194 453539 454389 454560 454561 454956 457392 459936 466346 468018 475260 478381 485758 496329 507199 517452 526682 529294 545414 558252 568228 580642 581744 601101 610647 614721 631615 636464 644813 647913 651102 654634 661536 663438 663443 663873 663912 664154 664274 664800 664967 665124 665250 665442 665455 665840 666778 666834 668886 669201 669771 671338 674197 696115 698123 705355 705781 707464 710916 712672 716329 716862 724702 724878 725633 728442 733587 734572 735942 739171 742608 745354 758280 759714 772113 772120 772124 775140 775436 781851 781862 781895 781912 781922 781961 782015 784922 784964 792819 794190 794796 798275 801527 803476 806301 810000 810744 811727 812055 813552 813821 823857 824067 826781 ] |
||||||||||||||||||||||||||||||
|
16.86 ms (8.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 454389 716329 661536 663443 745354 775436 782015 448182 454561 734572 772124 724702 568228 644813 826781 665840 666834 651102 663873 664274 665124 674197 781895 810000 705355 457392 733587 453539 668886 707464 614721 601101 545414 383631 813552 446865 447882 784922 478381 758280 669771 423966 398263 454956 665442 664967 775140 581744 507199 798275 781961 813821 705781 712672 665250 781862 794190 759714 742608 710916 423968 781912 784964 728442 443632 475260 823857 663438 698123 664800 669201 696115 636464 631615 801527 803476 811727 724878 739171 417221 413170 824067 663912 716862 725633 772120 772113 468018 386759 517452 454560 529294 580642 419969 459936 558252 647913 671338 792819 806301 810744 812055 781922 423869 466346 312264 664154 452194 496329 794796 411693 654634 188456 485758 526682 665455 666778 610647 781851 735942 ] |
||||||||||||||||||||||||||||||
|
2.59 ms (1.32%) |
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 188456 312264 383631 386759 398263 411693 413170 417221 419969 423869 423966 423968 443632 446865 447882 448182 452194 453539 454389 454560 454561 454956 457392 459936 466346 468018 475260 478381 485758 496329 507199 517452 526682 529294 545414 558252 568228 580642 581744 601101 610647 614721 631615 636464 644813 647913 651102 654634 661536 663438 663443 663873 663912 664154 664274 664800 664967 665124 665250 665442 665455 665840 666778 666834 668886 669201 669771 671338 674197 696115 698123 705355 705781 707464 710916 712672 716329 716862 724702 724878 725633 728442 733587 734572 735942 739171 742608 745354 758280 759714 772113 772120 772124 775140 775436 781851 781862 781895 781912 781922 781961 782015 784922 784964 792819 794190 794796 798275 801527 803476 806301 810000 810744 811727 812055 813552 813821 823857 824067 826781 ] |
||||||||||||||||||||||||||||||
|
1.88 ms (0.96%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"минет оральн секс bbw"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (0.85%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"blowjob bbw"
]
|
||||||||||||||||||||||||||||||
|
1.56 ms (0.79%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.50 ms (0.76%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"минет оральн секс bbw"
]
|
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.