Query Metrics
7
Database Queries
7
Different statements
165.37 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
138.09 ms (83.51%) |
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 4375 6640 7015 7295 67242 123000 151564 197736 205882 276780 313978 326290 358410 384905 387650 389945 391694 392277 393391 395592 400892 401200 401229 401307 403334 403588 404953 411185 411322 411547 411700 412358 413544 417094 422188 422205 424933 425192 428108 433236 434181 438001 439542 439607 439682 439715 439817 440469 440868 440901 440996 441770 441782 441846 441957 443777 443790 445436 445707 446520 448350 452318 454658 457437 457449 457469 458385 460619 462350 464353 464601 466217 466218 466247 466872 466897 468343 468344 469582 470923 471813 477538 481618 482568 484585 486209 486253 488743 489299 493158 494451 499726 508940 516226 516229 519332 520681 523019 523842 525634 541055 546958 555130 561447 563096 590194 598890 650388 661987 689001 705451 713433 720814 736741 765580 781824 789690 790517 799146 801917 ] |
||||||||||||||||||||||||||||||
|
17.43 ms (10.54%) |
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 151564 468344 276780 470923 123000 477538 4375 488743 499726 466897 443777 358410 389945 464353 650388 781824 790517 395592 7015 417094 411185 468343 486209 197736 508940 413544 433236 452318 525634 460619 555130 546958 590194 799146 439817 466218 7295 401307 439542 439682 440901 457449 411322 422188 445707 457437 462350 440996 466247 489299 493158 401200 439607 422205 443790 484585 661987 393391 440469 516226 713433 439715 457469 541055 598890 403588 401229 466872 486253 520681 438001 454658 789690 466217 384905 313978 720814 411547 689001 404953 445436 400892 428108 424933 448350 464601 469582 561447 563096 801917 765580 434181 411700 412358 440868 471813 494451 523842 326290 425192 441770 441957 441846 482568 446520 481618 516229 705451 736741 458385 391694 519332 523019 205882 392277 67242 6640 387650 403334 441782 ] |
||||||||||||||||||||||||||||||
|
2.71 ms (1.64%) |
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 4375 6640 7015 7295 67242 123000 151564 197736 205882 276780 313978 326290 358410 384905 387650 389945 391694 392277 393391 395592 400892 401200 401229 401307 403334 403588 404953 411185 411322 411547 411700 412358 413544 417094 422188 422205 424933 425192 428108 433236 434181 438001 439542 439607 439682 439715 439817 440469 440868 440901 440996 441770 441782 441846 441957 443777 443790 445436 445707 446520 448350 452318 454658 457437 457449 457469 458385 460619 462350 464353 464601 466217 466218 466247 466872 466897 468343 468344 469582 470923 471813 477538 481618 482568 484585 486209 486253 488743 489299 493158 494451 499726 508940 516226 516229 519332 520681 523019 523842 525634 541055 546958 555130 561447 563096 590194 598890 650388 661987 689001 705451 713433 720814 736741 765580 781824 789690 790517 799146 801917 ] |
||||||||||||||||||||||||||||||
|
2.13 ms (1.29%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"milf anal boy"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (1.06%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.75 ms (1.06%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"milf анал парен"
]
|
||||||||||||||||||||||||||||||
|
1.51 ms (0.91%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"milf анал парен"
]
|
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.