Query Metrics
7
Database Queries
7
Different statements
178.20 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
150.29 ms (84.33%) |
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 382344 384401 398475 414118 415376 462626 467677 487268 523281 527095 538352 539961 546284 554846 560953 561169 569036 569736 592132 593765 594617 595137 598143 601955 603423 605754 608225 615580 617183 617215 619336 622739 624526 631224 642187 642996 644178 664994 669500 671365 678810 681312 682872 689514 689894 693789 700905 704314 704598 705732 707044 707143 712143 715886 716795 720005 723090 724909 729937 730222 730267 730543 732041 733437 734155 734184 734258 734594 735747 736302 736551 736875 736894 739950 740143 741930 744783 744952 745924 747046 750298 750660 751899 753760 754838 755169 756473 759316 759669 762366 762572 764094 767654 769600 769911 770417 775048 786744 787017 799029 802094 804280 807203 812447 812975 814343 814621 815174 815899 815973 817782 818014 818627 818785 819686 819702 820810 822441 826102 827257 ] |
||||||||||||||||||||||||||||||
|
17.70 ms (9.94%) |
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 720005 560953 569036 592132 594617 622739 603423 644178 593765 617215 617183 624526 631224 642996 724909 730222 734155 747046 753760 762572 734184 736875 736894 754838 762366 730543 734258 736551 739950 750660 769911 741930 750298 734594 740143 745924 755169 769600 804280 807203 382344 462626 733437 693789 689514 642187 608225 467677 487268 712143 595137 812447 759316 414118 817782 814343 546284 554846 569736 669500 671365 707044 664994 681312 689894 723090 682872 707143 615580 598143 775048 732041 730267 770417 751899 735747 736302 767654 601955 715886 787017 605754 744783 759669 764094 704314 704598 705732 744952 756473 619336 384401 527095 538352 539961 561169 700905 819702 802094 678810 716795 799029 812975 729937 786744 415376 523281 398475 814621 815174 818014 818627 820810 822441 826102 818785 827257 815899 815973 819686 ] |
||||||||||||||||||||||||||||||
|
2.79 ms (1.57%) |
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 382344 384401 398475 414118 415376 462626 467677 487268 523281 527095 538352 539961 546284 554846 560953 561169 569036 569736 592132 593765 594617 595137 598143 601955 603423 605754 608225 615580 617183 617215 619336 622739 624526 631224 642187 642996 644178 664994 669500 671365 678810 681312 682872 689514 689894 693789 700905 704314 704598 705732 707044 707143 712143 715886 716795 720005 723090 724909 729937 730222 730267 730543 732041 733437 734155 734184 734258 734594 735747 736302 736551 736875 736894 739950 740143 741930 744783 744952 745924 747046 750298 750660 751899 753760 754838 755169 756473 759316 759669 762366 762572 764094 767654 769600 769911 770417 775048 786744 787017 799029 802094 804280 807203 812447 812975 814343 814621 815174 815899 815973 817782 818014 818627 818785 819686 819702 820810 822441 826102 827257 ] |
||||||||||||||||||||||||||||||
|
2.00 ms (1.12%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"masturbation dick"
]
|
||||||||||||||||||||||||||||||
|
1.98 ms (1.11%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.76 ms (0.99%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"мастурбац член"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (0.95%) |
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.