Query Metrics
8
Database Queries
8
Different statements
164.12 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
136.49 ms (83.16%) |
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 118226 397849 405177 407867 411547 414319 415342 421828 421867 424125 427281 428136 428602 430701 432688 439682 439710 439776 440640 441413 444870 447969 448636 449428 457437 457452 457461 462125 465641 466222 468120 469407 472152 472679 473261 473785 475552 476176 478367 480760 488370 488373 489384 493175 493221 493781 495225 497886 503992 505956 506133 506281 512781 513434 515506 517017 518264 518486 518756 523848 526517 531882 534704 534748 537664 538002 547458 549720 549825 549831 554235 555116 564306 567055 567950 568178 568344 568477 578664 579876 583686 591130 609083 610181 612219 616852 617044 626231 656916 664522 665905 665971 680944 681298 699061 705391 715090 717942 726922 727805 740718 757388 759622 761036 765835 766598 766600 767271 773482 779069 779804 788178 791006 791627 792100 792533 793597 793875 800372 804674 ] |
||||||||||||||||||||||||||||||
|
16.18 ms (9.86%) |
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 665905 699061 705391 717942 617044 610181 779804 791627 759622 765835 766598 793875 549831 549825 421867 439682 439710 444870 457437 472679 457461 526517 428602 441413 531882 537664 547458 567950 656916 626231 779069 793597 766600 800372 761036 726922 773482 757388 616852 791006 804674 473785 421828 414319 515506 609083 397849 405177 440640 480760 447969 466222 513434 512781 506281 555116 564306 664522 665971 680944 681298 767271 792533 407867 415342 475552 476176 468120 439776 497886 538002 489384 503992 505956 523848 493175 495225 488373 449428 493221 788178 448636 534748 715090 792100 727805 740718 427281 473261 432688 568178 568477 567055 612219 424125 469407 488370 472152 517017 478367 493781 549720 554235 578664 568344 583686 591130 428136 462125 457452 465641 430701 518264 518486 518756 534704 411547 579876 506133 118226 ] |
||||||||||||||||||||||||||||||
|
3.18 ms (1.94%) |
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 118226 397849 405177 407867 411547 414319 415342 421828 421867 424125 427281 428136 428602 430701 432688 439682 439710 439776 440640 441413 444870 447969 448636 449428 457437 457452 457461 462125 465641 466222 468120 469407 472152 472679 473261 473785 475552 476176 478367 480760 488370 488373 489384 493175 493221 493781 495225 497886 503992 505956 506133 506281 512781 513434 515506 517017 518264 518486 518756 523848 526517 531882 534704 534748 537664 538002 547458 549720 549825 549831 554235 555116 564306 567055 567950 568178 568344 568477 578664 579876 583686 591130 609083 610181 612219 616852 617044 626231 656916 664522 665905 665971 680944 681298 699061 705391 715090 717942 726922 727805 740718 757388 759622 761036 765835 766598 766600 767271 773482 779069 779804 788178 791006 791627 792100 792533 793597 793875 800372 804674 ] |
||||||||||||||||||||||||||||||
|
1.87 ms (1.14%) |
1 |
SELECT 1 FROM `trend_has_post` WHERE `trend_id` = ? LIMIT 1
Parameters:
[
b"\x01–\x1AGEÂq_’C2ß©ëæ“"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (1.09%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mature anal fucked"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (1.03%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mature анал fucked"
]
|
||||||||||||||||||||||||||||||
|
1.48 ms (0.90%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mature анал fucked"
]
|
||||||||||||||||||||||||||||||
|
1.45 ms (0.88%) |
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.