Query Metrics
7
Database Queries
7
Different statements
149.67 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
119.89 ms (80.10%) |
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 414075 414651 415883 417324 417829 419403 420192 438192 440632 446167 448810 448811 448817 449123 455898 457160 457165 460706 461765 468010 468628 473735 474621 476120 478527 480439 483094 483550 484786 484801 485149 489328 492064 495014 496033 496270 499817 506612 508518 516291 517184 518476 519392 520775 521089 521850 522147 527106 527273 527611 529405 531560 533746 536645 536752 538283 539232 545611 545614 545747 545801 545803 546861 556037 557236 558432 559948 559959 560197 562391 564596 565102 566786 568053 574559 575734 576720 580472 583714 585139 589524 594874 603813 603907 604295 604387 604528 605449 620205 623198 631984 632635 633798 634115 634153 634780 637074 637121 637145 639716 639732 639798 643112 647932 647972 662048 665768 666876 678159 745384 749152 767601 ] |
||||||||||||||||||||||||||||||
|
19.50 ms (13.03%) |
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 662048 565102 633798 604295 476120 474621 484786 495014 483094 417324 438192 575734 594874 545803 574559 580472 545747 637145 643112 749152 461765 468628 480439 420192 518476 521850 519392 545801 666876 637121 637074 440632 446167 484801 536752 678159 473735 414651 457165 468010 538283 562391 623198 460706 448811 478527 605449 745384 767601 604387 448817 536645 539232 583714 631984 604528 419403 520775 529405 568053 589524 499817 522147 559948 634153 632635 585139 457160 516291 576720 496270 521089 527106 634115 415883 417829 414075 564596 527273 485149 517184 556037 647972 639798 492064 506612 566786 546861 634780 531560 639716 559959 603907 449123 620205 448810 455898 508518 560197 527611 489328 545611 639732 647932 665768 483550 545614 557236 603813 533746 496033 558432 ] |
||||||||||||||||||||||||||||||
|
3.19 ms (2.13%) |
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 414075 414651 415883 417324 417829 419403 420192 438192 440632 446167 448810 448811 448817 449123 455898 457160 457165 460706 461765 468010 468628 473735 474621 476120 478527 480439 483094 483550 484786 484801 485149 489328 492064 495014 496033 496270 499817 506612 508518 516291 517184 518476 519392 520775 521089 521850 522147 527106 527273 527611 529405 531560 533746 536645 536752 538283 539232 545611 545614 545747 545801 545803 546861 556037 557236 558432 559948 559959 560197 562391 564596 565102 566786 568053 574559 575734 576720 580472 583714 585139 589524 594874 603813 603907 604295 604387 604528 605449 620205 623198 631984 632635 633798 634115 634153 634780 637074 637121 637145 639716 639732 639798 643112 647932 647972 662048 665768 666876 678159 745384 749152 767601 ] |
||||||||||||||||||||||||||||||
|
1.94 ms (1.30%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"teen black dick"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (1.25%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.66 ms (1.11%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"teen black член"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (1.08%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"teen black член"
]
|
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.