Query Metrics
7
Database Queries
7
Different statements
163.22 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
137.04 ms (83.96%) |
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 233622 382541 382810 388363 389150 406012 414103 415879 415988 418112 419819 420163 424606 424765 434367 439071 443246 443257 448791 451022 452800 452815 452937 452950 454172 457217 461100 465454 466427 467872 467929 468165 468236 468238 470473 473750 475336 476664 477506 483736 486243 486810 490380 491107 500340 500341 500342 509440 511005 511375 516339 517514 518187 519350 520813 523590 531844 534532 534574 537138 538791 541377 541451 541836 545455 545550 545905 547237 547486 547489 547795 548834 550916 555063 556871 580265 583712 586713 590281 593044 602194 607296 641997 660411 660412 665958 669056 669071 670368 671018 671045 672939 672946 686106 705451 713142 717514 749067 749084 749271 751546 752767 757226 765712 766415 776829 784775 787512 788521 803543 806822 814192 824632 825432 826589 827178 827395 827396 827692 ] |
||||||||||||||||||||||||||||||
|
16.50 ms (10.11%) |
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 476664 465454 468236 531844 537138 475336 583712 541451 545550 545905 556871 452815 382810 414103 424606 439071 451022 454172 518187 483736 545455 547486 564310 547489 669071 672939 660412 669056 713142 660411 670368 671018 671045 686106 641997 766415 751546 752767 765712 717514 419819 470473 516339 500341 590281 461100 415879 424765 452800 448791 534574 824632 827395 827396 827692 825432 787512 586713 382541 486243 534532 466427 550916 541377 548834 555063 705451 665958 672946 607296 776829 784775 803543 749067 749084 757226 749271 788521 806822 389150 388363 511005 415988 517514 491107 826589 827178 418112 547237 434367 477506 443257 468165 541836 538791 233622 523590 467872 467929 473750 406012 490380 500342 457217 500340 443246 452937 452950 509440 486810 468238 580265 593044 420163 519350 520813 511375 547795 602194 814192 ] |
||||||||||||||||||||||||||||||
|
2.50 ms (1.53%) |
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 233622 382541 382810 388363 389150 406012 414103 415879 415988 418112 419819 420163 424606 424765 434367 439071 443246 443257 448791 451022 452800 452815 452937 452950 454172 457217 461100 465454 466427 467872 467929 468165 468236 468238 470473 473750 475336 476664 477506 483736 486243 486810 490380 491107 500340 500341 500342 509440 511005 511375 516339 517514 518187 519350 520813 523590 531844 534532 534574 537138 538791 541377 541451 541836 545455 545550 545905 547237 547486 547489 547795 548834 550916 555063 556871 580265 583712 586713 590281 593044 602194 607296 641997 660411 660412 665958 669056 669071 670368 671018 671045 672939 672946 686106 705451 713142 717514 749067 749084 749271 751546 752767 757226 765712 766415 776829 784775 787512 788521 803543 806822 814192 824632 825432 826589 827178 827395 827396 827692 ] |
||||||||||||||||||||||||||||||
|
2.01 ms (1.23%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"webcam dildo mature"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (1.11%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"вебкамер дилд mature"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (1.09%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.58 ms (0.97%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"вебкамер дилд mature"
]
|
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.